squirrels

22 rows where Hectare = "03D" and Police Precincts = 13 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from, Other Interactions

Hectare Squirrel Number

Police Precincts

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
1763 -73.9768286349595 40.7687012827059 3D-PM-1010-05 03D PM 10102018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9768286349595 40.7687012827059)   19 4 19 13
214 -73.9772576561244 40.7679895093963 3D-AM-1006-08 03D AM 10062018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false true false false approaches (food stand) POINT (-73.9772576561244 40.7679895093963)   19 4 19 13
257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area true false true false false climbing (rock) false false false false false true false false approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)   19 4 19 13
493 -73.9776854797916 40.7683102295663 3D-AM-1006-04 03D AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (boy on bike) POINT (-73.9776854797916 40.7683102295663)   19 4 19 13
2245 -73.9774228454023 40.7686399839016 3D-AM-1006-05 03D AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (chased by boy),wary of humans in playground POINT (-73.9774228454023 40.7686399839016)   19 4 19 13
2280 -73.9767143644151 40.7684756941321 3D-AM-1006-02 03D AM 10062018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25 tree true false true false false   false false false false false false true false   POINT (-73.9767143644151 40.7684756941321)   19 4 19 13
2462 -73.9768544488742 40.7680069500977 3D-AM-1006-07 03D AM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false running (with food in mouth) false false false false false false true false   POINT (-73.9768544488742 40.7680069500977)   19 4 19 13
2583 -73.9769693140651 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree true false true true true digging (?) false false false true false false false true runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)   19 4 19 13
140 -73.9768652785664 40.7684838168207 3D-PM-1010-03 03D PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.97686527856641 40.7684838168207)   19 4 19 13
514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true false false true   false true false false false false false false   POINT (-73.9768357173861 40.7683813358343)   19 4 19 13
1127 -73.9776445567926 40.768119107973 3D-PM-1010-07 03D PM 10102018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9776445567926 40.768119107973)   19 4 19 13
2674 -73.9771009024581 40.7688793288864 3D-PM-1010-06 03D PM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9771009024581 40.7688793288864)   19 4 19 13
1238 -73.9773692131441 40.7679771150149 3D-PM-1010-02 03D PM 10102018 2 Adult Gray   Gray+   Above Ground 8   false false true false false   false false false false false false false false   POINT (-73.9773692131441 40.7679771150149)   19 4 19 13
1293 -73.9775465365348 40.7681943707876 3D-PM-1010-09 03D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9775465365348 40.7681943707876)   19 4 19 13
1329 -73.9772164524209 40.7688399538756 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree true false true false false   false false false false false false false false did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)   19 4 19 13
705 -73.9779228287629 40.7681019683859 3D-PM-1010-01 03D PM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9779228287629 40.7681019683859)   19 4 19 13
1768 -73.9773696455031 40.7687241866704 3D-PM-1010-14 03D PM 10102018 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false crying out true true false false false false false false   POINT (-73.9773696455031 40.7687241866704)   19 4 19 13
2315 -73.9767849679735 40.768566516928 3D-PM-1010-04 03D PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9767849679735 40.768566516928)   19 4 19 13
807 -73.9777259022441 40.7682059907903 3D-PM-1010-10 03D PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9777259022441 40.7682059907903)   19 4 19 13
1532 -73.9779263114572 40.7682681855369 3D-PM-1010-08 03D PM 10102018 8 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9779263114572 40.7682681855369)   19 4 19 13
1913 -73.9774630821854 40.7680626674086 3D-PM-1010-11 03D PM 10102018 11 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774630821854 40.76806266740861)   19 4 19 13
2628 -73.9770439076963 40.7685720141731 3D-PM-1010-13 03D PM 10102018 13 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9770439076963 40.7685720141731)   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 98.783ms