squirrels

21 rows where Climbing = "true", Eating = "false", Highlight Fur Color = "Gray" and Runs from = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, 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
166 166 -73.963846339804 40.7834051716226 23F-AM-1018-01 23F AM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.963846339804 40.7834051716226)   19 4 19 13
257 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
261 261 -73.9552861155228 40.788973931872 32I-AM-1013-05 32I AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552861155228 40.788973931872)   19 4 19 13
391 391 -73.9790875480358 40.7676104780657 2C-AM-1010-03 02C AM 10102018 3 Adult Black Gray Black+Gray   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9790875480358 40.7676104780657)   19 4 19 13
525 525 -73.952526164386 40.7963759240504 40G-AM-1007-02 40G AM 10072018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 18   true false true false false   false false false false false false true false   POINT (-73.952526164386 40.7963759240504)   19 4 19 13
588 588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true false false   false false false false true false false false alert & aware POINT (-73.9646597452128 40.7827698220703)   19 4 19 13
625 625 -73.9764235373322 40.770606513989 5C-PM-1010-11 05C PM 10102018 11 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false true   false false false false false false false false   POINT (-73.97642353733221 40.770606513989)   19 4 19 13
695 695 -73.9685080639873 40.7745309794155 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree false false true false false   false false false false false false true false   POINT (-73.9685080639873 40.77453097941551)   19 4 19 13
788 788 -73.9687476703117 40.7742856696093 12G-AM-1012-01 12G AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9687476703117 40.7742856696093)   19 4 19 13
789 789 -73.9675023138703 40.7872554700995 25A-PM-1007-01 25A PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 40 tree false false true false false   false false false false false false false false   POINT (-73.9675023138703 40.7872554700995)   19 4 19 13
894 894 -73.9675198230918 40.778631094685 17F-AM-1007-02 17F AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   false false true false false   false false false false false false true false   POINT (-73.9675198230918 40.778631094685)   19 4 19 13
937 937 -73.9706323458769 40.7713196034265 9G-PM-1007-03 09G PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false true false false   false false false false false false true false   POINT (-73.9706323458769 40.771319603426505)   19 4 19 13
1017 1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552035011902 40.7889851896334)   19 4 19 13
1145 1145 -73.9611446263364 40.7911003407299 32D-AM-1013-03 32D AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9611446263364 40.7911003407299)   19 4 19 13
1253 1253 -73.9527227282134 40.7935061484064 37I-AM-1010-03 37I AM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 in tree false false true false false   false false false false false false true false   POINT (-73.9527227282134 40.7935061484064)   19 4 19 13
1351 1351 -73.9610985171525 40.7913867116989 32D-AM-1013-01 32D AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9610985171525 40.7913867116989)   19 4 19 13
1680 1680 -73.9638167248251 40.7776485679354 18I-PM-1007-03 18I PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25   false false true false false   false false false false false false false false stared at me POINT (-73.9638167248251 40.77764856793541)   19 4 19 13
2280 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
2404 2404 -73.9665309689616 40.7775271020244 16G-AM-1010-04 16G AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.9665309689616 40.7775271020244)   19 4 19 13
2696 2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false false   false false false false true false true false   POINT (-73.9501457233643 40.797094356558)   19 4 19 13
2822 2822 -73.9711120079542 40.7760801911766 13D-PM-1018-14 13D PM 10182018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false true false false climbing (down) false false false false false false true false   POINT (-73.9711120079542 40.7760801911766)   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 104.541ms