squirrels

14 rows where Foraging = "false" and Hectare = "07F" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Other Activities, Runs from, Other Interactions

Hectare Squirrel Number ✖

Indifferent ✖

Police Precincts ✖

Hectare ✖

  • 07F · 14 ✖

Foraging ✖

  • false · 14 ✖
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
98 98 -73.9730277911422 40.7712145488828 7F-AM-1008-16 07F AM 10082018 16 Juvenile Gray   Gray+   Above Ground 2 tree false false false false false   false false false false false false false true   POINT (-73.9730277911422 40.7712145488828)   19 4 19 13
142 142 -73.9724063986771 40.7705711897977 7F-PM-1012-01 07F PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9724063986771 40.7705711897977)   19 4 19 13
259 259 -73.9726958070536 40.7706096126328 7F-AM-1008-09 07F AM 10082018 9 Adult Gray   Gray+   Above Ground 20   false false true false false playing w/ #8 false false false false false false true false   POINT (-73.9726958070536 40.7706096126328)   19 4 19 13
1278 1278 -73.9729848996456 40.7707143294261 7F-AM-1008-11 07F AM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9729848996456 40.7707143294261)   19 4 19 13
1288 1288 -73.9730454295997 40.7702909454392 7F-AM-1008-05 07F AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE bush false true false false false   false false false false false false true false   POINT (-73.9730454295997 40.7702909454392)   19 4 19 13
1470 1470 -73.9724806580638 40.7710077206132 7F-AM-1008-15 07F AM 10082018 15 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9724806580638 40.7710077206132)   19 4 19 13
1569 1569 -73.973047824163 40.7700873791211 7F-AM-1008-03 07F AM 10082018 3 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.973047824163 40.7700873791211)   19 4 19 13
1598 1598 -73.9726828460055 40.7705707694822 7F-AM-1008-08 07F AM 10082018 8 Adult Gray   Gray+   Above Ground 20   false false true false false playing w/ #9 false false false false false false true false   POINT (-73.9726828460055 40.7705707694822)   19 4 19 13
1602 1602 -73.9728836727349 40.770815850599 7F-AM-1008-10 07F AM 10082018 10 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9728836727349 40.770815850599)   19 4 19 13
1770 1770 -73.9728170980779 40.7703557830437 7F-AM-1008-06 07F AM 10082018 6 Adult Gray   Gray+   Above Ground 28 in hole in tree false false false false false sitting false false false false false false true false   POINT (-73.9728170980779 40.770355783043705)   19 4 19 13
2267 2267 -73.9727926335397 40.77037055775 7F-AM-1008-07 07F AM 10082018 7 Adult Gray   Gray+   Above Ground 28 next to the hole of #6 false false false false false standing false false false false false false true false   POINT (-73.9727926335397 40.77037055775)   19 4 19 13
250 250 -73.9726747666002 40.7703022669308 7F-AM-1008-02 07F AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true see stories and locations POINT (-73.9726747666002 40.7703022669308)   19 4 19 13
1364 1364 -73.9726090882487 40.7710199108849 7F-AM-1008-14 07F AM 10082018 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false sitting false false false false false false true false   POINT (-73.9726090882487 40.7710199108849)   19 4 19 13
2340 2340 -73.9730284815849 40.7702462529502 7F-AM-1008-04 07F AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE bush false true false false false   false false false false false false true false   POINT (-73.9730284815849 40.7702462529502)   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 72.828ms