squirrels

38 rows where Climbing = "true" and Combination of Primary and Highlight Color = "Cinnamon+Gray" sorted by Zip Codes descending

View and edit SQL

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

Combination of Primary and Highlight Color

  • Cinnamon+Gray · 38

Climbing

  • true · 38
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 -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 -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 -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
384 -73.968045072743 40.7836626717225 22C-AM-1013-02 22C AM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   false false true false true   true false false true false false false true   POINT (-73.968045072743 40.7836626717225)   19 4 19 13
470 -73.9581243021722 40.794431473386 36D-AM-1007-01 36D AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false true   false false false false false false false true avoiding a dog POINT (-73.95812430217221 40.794431473386)   19 4 19 13
506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false true false false   false false false false true false false true   POINT (-73.9649611089685 40.7814371834837)   19 4 19 13
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
534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   true false true false false   false false false false true false false true   POINT (-73.9650499507011 40.7908191782173)   19 4 19 13
552 -73.9625416200877 40.7811302397912 21H-AM-1017-02 21H AM 10172018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 1   false false true false false   false false false false false false false true   POINT (-73.9625416200877 40.78113023979121)   19 4 19 13
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 -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 -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 -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 -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
852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   true false true false false hopping false false false false false true false true   POINT (-73.9609704650925 40.7938786854735)   19 4 19 13
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 -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 -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
1067 -73.9695305996721 40.7745386896959 12F-PM-1007-02 12F PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9695305996721 40.7745386896959)   19 4 19 13
1081 -73.9680855277775 40.7769251965381 15F-AM-1007-10 15F AM 10072018 10 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true false false   false false false false false false false true   POINT (-73.9680855277775 40.7769251965381)   19 4 19 13
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
1215 -73.9728895595977 40.7699378332299 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true false   false false false false false true false false   POINT (-73.9728895595977 40.7699378332299)   19 4 19 13
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 -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
1354 -73.9765269282059 40.7746876635248 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9765269282059 40.7746876635248)   19 4 19 13
1560 -73.9587072763996 40.7850256219415 27I-AM-1007-01 27I AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   false false true true false   false false false false false false false true   POINT (-73.9587072763996 40.7850256219415)   19 4 19 13
1631 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 10072018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true false false   false false false false false false false true me! POINT (-73.9527196716568 40.792363826828)   19 4 19 13
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
1891 -73.9749641575871 40.7673305056277 3F-AM-1006-05 03F AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true true false   false false false false false false false true   POINT (-73.9749641575871 40.7673305056277)   19 4 19 13
1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree false false true false false   false false false false true false false true   POINT (-73.9540151828782 40.7920066170587)   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
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
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
2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true true false   false false false false false true false false   POINT (-73.9772239251936 40.7731716665766)   19 4 19 13
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
2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false true false true   false false false false true false false true   POINT (-73.974596903918 40.7765498215674)   19 4 19 13
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
2927 -73.9650120066074 40.7805932882407 20F-PM-1007-13 20F PM 10072018 13 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9650120066074 40.78059328824071)   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 78.892ms