squirrels

17 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon, White", Eating = "true", Hectare Squirrel Number = 2, Indifferent = "true" and Police Precincts = 13 sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Other Activities, Quaas, Tail twitches, Runs from, Other Interactions

Police Precincts ✖

Indifferent ✖

  • true · 17 ✖

Hectare Squirrel Number ✖

Eating ✖

  • true · 17 ✖

Combination of Primary and Highlight Color ✖

  • Gray+Cinnamon, White · 17 ✖
Link rowid Longitude Latitude Unique Squirrel ID Hectare Shift Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating Foraging Other Activities ▼ Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
679 679 -73.955018489069 40.7971235333699 40E-PM-1017-02 40E PM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.955018489069 40.7971235333699)   19 4 19 13
776 776 -73.9686816795392 40.775770422667 14F-PM-1012-02 14F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   false false true true false   false false false false false false true false   POINT (-73.9686816795392 40.775770422667)   19 4 19 13
787 787 -73.9725157534356 40.7658376729234 2I-PM-1006-02 02I PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9725157534356 40.7658376729234)   19 4 19 13
826 826 -73.9557263533489 40.7939505791448 37F-PM-1014-02 37F PM 10142018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE LAWN false false false true true   false false false false false false true false   POINT (-73.95572635334891 40.7939505791448)   19 4 19 13
1108 1108 -73.9638397790384 40.7828950272904 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false true false false true false true false indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)   19 4 19 13
1123 1123 -73.9670858934045 40.7753505024976 14H-PM-1012-02 14H PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   true false false true true   false false false false false false true false   POINT (-73.9670858934045 40.7753505024976)   19 4 19 13
1396 1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   false true false true true   false false false false true false true false   POINT (-73.9704677007779 40.7786860108302)   19 4 19 13
1552 1552 -73.9695655231393 40.7698324659513 8I-PM-1013-02 08I PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9695655231393 40.7698324659513)   19 4 19 13
1603 1603 -73.9545929242174 40.7986940168685 42D-AM-1014-02 42D AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9545929242174 40.7986940168685)   19 4 19 13
1708 1708 -73.9618486459307 40.7946365810826 35A-AM-1014-02 35A AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9618486459307 40.7946365810826)   19 4 19 13
1885 1885 -73.9594174605642 40.7973128653773 38B-AM-1019-02 38B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9594174605642 40.7973128653773)   19 4 19 13
2048 2048 -73.9627661465376 40.7819356810575 22G-PM-1018-02 22G PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9627661465376 40.7819356810575)   19 4 19 13
2785 2785 -73.9729105002306 40.7672758037086 4H-PM-1006-02 04H PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9729105002306 40.7672758037086)   19 4 19 13
2916 2916 -73.9517525111679 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   false false true true false   false false false false false false true false   POINT (-73.9517525111679 40.7974407641075)   19 4 19 13
3022 3022 -73.9639941227864 40.7899152327912 29B-PM-1010-02 29B PM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9639941227864 40.7899152327912)   19 4 19 13
187 187 -73.9700162034073 40.7815277479588 19B-AM-1019-02 19B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true false posing false false false false false false true true indifferent then runs from POINT (-73.9700162034073 40.7815277479588)   19 4 19 13
2510 2510 -73.9748635473782 40.7742591029151 10C-AM-1018-02 10C AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false sitting in the sun false false false false false false true false   POINT (-73.9748635473782 40.7742591029151)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);
Powered by Datasette · Query took 4879.351ms