squirrels

43 rows where Combination of Primary and Highlight Color = "Cinnamon+Gray" and Location = "Above Ground" sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

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

Police Precincts ✖

Community Districts ✖

City Council Districts ✖

Location ✖

  • Above Ground · 43 ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+Gray · 43 ✖
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
224 224 -73.9520592496349 40.7975076299811 42G-PM-1014-03 42G PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 on fence true false false false false prancing false false false false false false false true   POINT (-73.9520592496349 40.7975076299811)   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
319 319 -73.9659034359706 40.7797516688844 19F-AM-1007-02 19F AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 8   false false false true false   false false false false false false true false   POINT (-73.9659034359706 40.77975166888441)   19 4 19 13
377 377 -73.9757001944781 40.769499790547 5E-AM-1008-09 05E AM 10082018 9 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2 went up tree true false false false false   false false false false false false true false   POINT (-73.9757001944781 40.769499790547)   19 4 19 13
384 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
399 399 -73.9763433202401 40.7738473490681 9B-PM-1013-10 09B PM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray "Brown" written in as Primary Above Ground 12   false false false true false   false false false false false false true false   POINT (-73.9763433202401 40.7738473490681)   19 4 19 13
506 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 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 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 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 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
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
780 780 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 10062018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 on tree false false false true false   false false false false false false false false   POINT (-73.9675472064204 40.7835947167436)   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
852 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 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
1003 1003 -73.9645547556826 40.776877007081 16I-AM-1008-04 16I AM 10082018 4 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 9 tree hollow false false false false false in hollow false false false false false false false false curious POINT (-73.9645547556826 40.776877007081)   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
1081 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
1103 1103 -73.9541500874008 40.7920329989756 35H-AM-1013-02 35H AM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 Sitting on tree limb false false false false false sitting false false false false false false true false watching me from tree,but calm POINT (-73.9541500874008 40.7920329989756)   19 4 19 13
1135 1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree false true false false false watching me false true false true false false false false observant POINT (-73.9667474482967 40.7760643720793)   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
1226 1226 -73.97684509717 40.7709430375069 5C-PM-1010-07 05C PM 10102018 7 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 13   false true false false false   false false false false false false false false   POINT (-73.97684509717 40.7709430375069)   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
1560 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 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 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
1799 1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   false true false false false chasing squirrel #6 true true false false true false false false   POINT (-73.978844141973 40.7696046074378)   19 4 19 13
1891 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 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
2026 2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch false false false false false watching me scratching true false false true false false true false   POINT (-73.9622752768962 40.7814921913101)   19 4 19 13
2244 2244 -73.9509628195532 40.7977775674178 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false false false false   false false false false true false false true   POINT (-73.9509628195532 40.7977775674178) 12423 18 4 36 18
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
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree true true false false false   false false false true true false true false   POINT (-73.9595222999173 40.7833202577782)   19 4 19 13
2521 2521 -73.976869549792 40.7706982454723 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree false false false false false relaxing false false false true false false true false   POINT (-73.976869549792 40.7706982454723)   19 4 19 13
2583 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 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
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9632164738341 40.7921270121312)   19 4 19 13
2913 2913 -73.9621297946132 40.7944058222814 34A-PM-1013-05 34A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   true false false false false   false false false false false false false false   POINT (-73.9621297946132 40.7944058222814)   19 4 19 13
2927 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 66.726ms