squirrels

59 rows where Age = "Juvenile" and Combination of Primary and Highlight Color = "Gray+White"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Climbing ✖

Combination of Primary and Highlight Color ✖

  • Gray+White · 59 ✖

Age ✖

  • Juvenile · 59 ✖
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
53 53 -73.9584970643213 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true true false false   POINT (-73.9584970643213 40.7982886348696)   19 4 19 13
115 115 -73.9530040923555 40.7922896176936 36I-PM-1007-10 36I PM 10072018 10 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true false stole (found?) an entire sandwich false false false false false false true false   POINT (-73.9530040923555 40.7922896176936)   19 4 19 13
172 172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true false false false   POINT (-73.958535640774 40.7982737896998)   19 4 19 13
173 173 -73.958770180151 40.7934123941528 35D-PM-1013-04 35D PM 10132018 4 Juvenile Gray White Gray+White         false false false false false   false false false false false false false false   POINT (-73.958770180151 40.7934123941528)   19 4 19 13
238 238 -73.9760942252437 40.7742035674209 9B-PM-1013-07 09B PM 10132018 7 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.97609422524371 40.7742035674209)   19 4 19 13
277 277 -73.9619070229674 40.79525566925 35A-AM-1014-05 35A AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9619070229674 40.79525566925)   19 4 19 13
299 299 -73.9586214081667 40.7937473968735 35D-PM-1013-03 35D PM 10132018 3 Juvenile Gray White Gray+White No Tail! Above Ground 2 bench false false false true false   false false false false false false true false   POINT (-73.9586214081667 40.7937473968735)   19 4 19 13
365 365 -73.9576035072364 40.7966120824816 38C-AM-1019-01 38C AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (lawnmower) POINT (-73.9576035072364 40.7966120824816)   19 4 19 13
421 421 -73.9664630067791 40.7756361515825 14H-AM-1007-04 14H AM 10072018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false true   POINT (-73.9664630067791 40.7756361515825)   19 4 19 13
467 467 -73.9579724119943 40.7948709900016 37D-AM-1018-01 37D AM 10182018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9579724119943 40.7948709900016)   19 4 19 13
483 483 -73.9789952029637 40.7697758333099 4B-AM-1010-03 04B AM 10102018 3 Juvenile Gray White Gray+White   Above Ground 25   false false true false false   false false false false false false true false   POINT (-73.9789952029637 40.7697758333099)   19 4 19 13
488 488 -73.9615751148595 40.7954551238146 36A-AM-1018-01 36A AM 10182018 1 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9615751148595 40.7954551238146)   19 4 19 13
508 508 -73.9746918762076 40.7655231883678 1G-AM-1006-02 01G AM 10062018 2 Juvenile Gray White Gray+White   Above Ground 30   false false true false true   false false false false true false true false   POINT (-73.9746918762076 40.7655231883678)   19 4 19 13
624 624 -73.9613051957306 40.7909351393505 31D-AM-1014-02 31D AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Undergrowth false false false false true   false false false false false false false true   POINT (-73.9613051957306 40.7909351393505)   19 4 19 13
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   true false false true true   true false false false false true false true approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)   19 4 19 13
756 756 -73.9773079154219 40.7696506688861 4C-AM-1006-02 04C AM 10062018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false true false true false   POINT (-73.9773079154219 40.7696506688861)   19 4 19 13
792 792 -73.9730115687964 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   false false true true false   false false false false false false false false   POINT (-73.9730115687964 40.7741018274312)   19 4 19 13
846 846 -73.9582643954055 40.8000460061272 42A-AM-1019-01 42A AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.95826439540551 40.8000460061272)   19 4 19 13
856 856 -73.9591667162801 40.7937602121568 35D-PM-1013-07 35D PM 10132018 7 Juvenile Gray White Gray+White   Above Ground 12 tree false false true false false   false false false false true false true false   POINT (-73.95916671628011 40.7937602121568)   19 4 19 13
887 887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9635028497015 40.7928207574906)   19 4 19 13
999 999 -73.980948293606 40.7685688850628 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.980948293606 40.7685688850628)   19 4 19 13
1027 1027 -73.9640016324897 40.7921759097124 32A-PM-1013-01 32A PM 10132018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9640016324897 40.7921759097124)   19 4 19 13
1028 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
1107 1107 -73.9530739562131 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false true from voice POINT (-73.95307395621312 40.7932034409546)   19 4 19 13
1203 1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9616999731028 40.7954126939561)   19 4 19 13
1302 1302 -73.9704024529864 40.7729256063889 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   false true false false false chasing (#3) true false false false false false false false   POINT (-73.9704024529864 40.7729256063889)   19 4 19 13
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   false true true true false   false false false false false false false true   POINT (-73.9710801547498 40.7760872452093)   19 4 19 13
1397 1397 -73.9655233748105 40.7792737287734 18G-AM-1014-01 18G AM 10142018 1 Juvenile Gray White Gray+White   Above Ground 10   false false true false false   true false false false false false true false looking POINT (-73.9655233748105 40.7792737287734)   19 4 19 13
1403 1403 -73.9761632586697 40.7741085606149 9B-PM-1013-05 09B PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9761632586697 40.7741085606149)   19 4 19 13
1411 1411 -73.9802840031759 40.7678599069819 1B-PM-1019-04 01B PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.9802840031759 40.7678599069819)   19 4 19 13
1466 1466 -73.9651177657676 40.7812408103825 20F-PM-1007-05 20F PM 10072018 5 Juvenile Gray White Gray+White white tail Above Ground 20   false false true false false   false false false false false false false true   POINT (-73.9651177657676 40.781240810382506)   19 4 19 13
1482 1482 -73.9588610195699 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path false false false true true   false false false false false false true false   POINT (-73.9588610195699 40.7945269936639)   19 4 19 13
1494 1494 -73.9525752408169 40.7954915417553 39H-AM-1007-03 39H AM 10072018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9525752408169 40.7954915417553)   19 4 19 13
1540 1540 -73.957710975899 40.7984055614047 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.957710975899 40.7984055614047)   19 4 19 13
1549 1549 -73.9777978497894 40.7668620784309 1D-AM-1006-01 01D AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   true false true false true   false false false false true false false false   POINT (-73.9777978497894 40.7668620784309)   19 4 19 13
1672 1672 -73.9640989602986 40.7899295439265 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9640989602986 40.7899295439265)   19 4 19 13
1685 1685 -73.9678822983274 40.7802960985637 18E-PM-1006-01 18E PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9678822983274 40.7802960985637)   19 4 19 13
1709 1709 -73.9771696835698 40.7697011100487 4C-AM-1006-04 04C AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9771696835698 40.7697011100487)   19 4 19 13
1756 1756 -73.9755041276839 40.7678213857557 3F-AM-1006-13 03F AM 10062018 13 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false true false false   POINT (-73.9755041276839 40.7678213857557)   19 4 19 13
1759 1759 -73.9576219570858 40.7963351225672 38C-AM-1019-03 38C AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9576219570858 40.7963351225672)   19 4 19 13
1783 1783 -73.9730001080547 40.7678719218983 4G-AM-1006-05 04G AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true false false climbing (tree) false false false false false false true false indifferent—was in front of my face (we were on a bridge)! POINT (-73.9730001080547 40.7678719218983)   19 4 19 13
1836 1836 -73.9751056714758 40.7732060035215 8C-PM-1013-03 08C PM 10132018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9751056714758 40.7732060035215)   19 4 19 13
1978 1978 -73.9579689996645 40.7949338489917 37D-AM-1018-02 37D AM 10182018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9579689996645 40.7949338489917)   19 4 19 13
1999 1999 -73.9549860947234 40.7911550328309 34H-PM-1006-07 34H PM 10062018 7 Juvenile Gray White Gray+White white belly Above Ground 20   false false true false false   false false false false false false false true   POINT (-73.9549860947234 40.7911550328309)   19 4 19 13
2061 2061 -73.9608834102446 40.790624710005 31D-AM-1014-05 31D AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9608834102446 40.790624710005)   19 4 19 13
2116 2116 -73.9801562527339 40.7687267327113 2B-AM-1010-01 02B AM 10102018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9801562527339 40.7687267327113)   19 4 19 13
2144 2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree false false true false false cleaning false false false false false false true false   POINT (-73.975198284551 40.7740343763399)   19 4 19 13
2145 2145 -73.9651250402583 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree false false true false true   false false false false false false false false   POINT (-73.9651250402583 40.7812884929069)   19 4 19 13
2168 2168 -73.9582363437135 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9582363437135 40.7987752300505)   19 4 19 13
2221 2221 -73.9771847728747 40.7695971164981 4C-AM-1006-01 04C AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9771847728747 40.7695971164981)   19 4 19 13
2232 2232 -73.9566277721581 40.7966674587803 39D-PM-1012-04 39D PM 10122018 4 Juvenile Gray White Gray+White   Above Ground 10 on tree trunk (descending from height of ~10 ft) false false true false false   false false false false false false true false   POINT (-73.95662777215811 40.7966674587803)   19 4 19 13
2288 2288 -73.9577009571427 40.796126044521 38C-PM-1014-10 38C PM 10142018 10 Juvenile Gray White Gray+White   Above Ground 10   false false true true true climbing (down from ~10') false false false false false false false true   POINT (-73.9577009571427 40.796126044521)   19 4 19 13
2397 2397 -73.9704592500888 40.772962887933 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   false false true false false   false false false true false false false true   POINT (-73.9704592500888 40.772962887933)   19 4 19 13
2412 2412 -73.9809446489564 40.7685032165879 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.9809446489564 40.7685032165879)   19 4 19 13
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   false false true true false   false false false false false false true false   POINT (-73.9622050752008 40.7886373772305)   19 4 19 13
2657 2657 -73.9582150734453 40.7962862794303 38C-AM-1019-08 38C AM 10192018 8 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false true   true false false false false false true false   POINT (-73.9582150734453 40.7962862794303)   19 4 19 13
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true true true   false false false false false false true false   POINT (-73.9772908667333 40.7697207404744)   19 4 19 13
2865 2865 -73.9802842404016 40.7678257384977 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.98028424040162 40.7678257384977)   19 4 19 13
2920 2920 -73.9657391918196 40.776502470347 16H-PM-1014-01 16H PM 10142018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9657391918196 40.776502470347)   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 89.944ms