squirrels

16 rows where Date = 10082018, Foraging = "true" and Hectare Squirrel Number = 3

View and edit SQL

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

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
219 -73.9761209945419 40.7682404528903 3E-PM-1008-03 03E PM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9761209945419 40.7682404528903)   19 4 19 13
491 -73.9688470831269 40.7844651946415 22A-AM-1008-03 22A AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9688470831269 40.7844651946415)   19 4 19 13
716 -73.9745427984089 40.7691848214817 5E-AM-1008-03 05E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9745427984089 40.7691848214817)   19 4 19 13
1018 -73.9695305555392 40.7757541971012 13F-PM-1008-03 13F PM 10082018 3 Adult Gray   Gray+   Above Ground 15 tree false false false true true   false false false false false false true false   POINT (-73.9695305555392 40.7757541971012)   19 4 19 13
1028 -73.9707012345661 40.7758938984066 13E-PM-1008-03 13E PM 10082018 3 Juvenile Gray White Gray+White   Above Ground 10 hanging upside down to get a nut false false false false true   false false false false false false true false   POINT (-73.9707012345661 40.7758938984066)   19 4 19 13
1121 -73.9645060433292 40.7768322057794 16I-AM-1008-03 16I AM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9645060433292 40.7768322057794)   19 4 19 13
1222 -73.9691420412059 40.7773492582138 15E-PM-1008-03 15E PM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true walking false false false false false false true false   POINT (-73.9691420412059 40.7773492582138)   19 4 19 13
1834 -73.9739038832156 40.7730354890554 9D-AM-1008-03 09D AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9739038832156 40.7730354890554)   19 4 19 13
1981 -73.972154069981 40.7690128009722 6G-AM-1008-03 06G AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE grass false false false true true   false false false true false false true false   POINT (-73.972154069981 40.7690128009722)   19 4 19 13
2006 -73.9695641121727 40.7769562886685 14E-AM-1008-03 14E AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true walking false false false false false false true false unaware of POINT (-73.9695641121727 40.7769562886685)   19 4 19 13
2015 -73.9574365550758 40.7886924675052 31H-PM-1008-03 31H PM 10082018 3 Adult Gray   Gray+   Above Ground   no clue, way up a tree! false false true false true throwing down acorns false false false false false false false false   POINT (-73.9574365550758 40.7886924675052)   19 4 19 13
2253 -73.973394428186 40.7722933513053 8E-PM-1008-03 08E PM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE in between 2 trees false false false true true   false false false false false true false false also being lured by mom & baby w/ food POINT (-73.973394428186 40.7722933513053)   19 4 19 13
2393 -73.9729190572117 40.770018150905 6F-PM-1008-03 06F PM 10082018 3 Adult Gray   Gray+   Above Ground 50 top of tree false false false false true   false false false false false false false false   POINT (-73.9729190572117 40.770018150905)   19 4 19 13
2485 -73.9584950620879 40.7902770710643 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.9584950620879 40.7902770710643)   19 4 19 13
2563 -73.9664536611195 40.7827694131949 21D-AM-1008-03 21D AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9664536611195 40.7827694131949)   19 4 19 13
2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9777124331985 40.7704051056666)   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 55.08ms