2018_Central_Park_Squirrel_Census_-_Squirrel_Data

139 rows where Age = "Adult" and Highlight Fur Color = "Gray" sorted by Other Interactions

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Age ✖

  • Adult · 39 ✖
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
2493 2493 -73.954767265558 40.7973243644491 40E-PM-1017-03 40E PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.954767265558 40.7973243644491)
2496 2496 -73.96962742914171 40.7691980808067 7I-PM-1013-03 07I PM 10132018 3 Adult Black Gray Black+Gray   Ground Plane FALSE Trash bins 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9696274291417 40.7691980808067)
2504 2504 -73.9550131837533 40.7958617258176 39E-PM-1013-02 39E PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail & butt Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 0   POINT (-73.9550131837533 40.7958617258176)
2514 2514 -73.95744422055 40.7961046528557 38D-AM-1017-04 38D AM 10172018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.95744422055 40.7961046528557)
2521 2521 -73.976869549792 40.770698245472296 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree 0 0 0 0 0 relaxing 0 0 0 1 0 0 1 0   POINT (-73.976869549792 40.7706982454723)
2523 2523 -73.9619016393127 40.792516012692104 33B-PM-1010-06 33B PM 10102018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9619016393127 40.7925160126921)
2608 2608 -73.95226776576591 40.7934034811368 38I-AM-1019-02 38I AM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9522677657659 40.7934034811368)
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9772239251936 40.7731716665766)
2651 2651 -73.9632993246327 40.78881995196561 29C-AM-1007-05 29C AM 10072018 5 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9632993246327 40.7888199519656)
2696 2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9501457233643 40.797094356558)
2727 2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.974596903918 40.7765498215674)
2746 2746 -73.95614328368629 40.798266534723396 41C-AM-1017-07 41C AM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9561432836863 40.7982665347234)
2752 2752 -73.972069937746 40.765940262783204 3I-PM-1013-04 03I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97206993774601 40.7659402627832)
2788 2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9647845655965 40.7816573808695)
2799 2799 -73.96826273820729 40.773076674345205 11H-AM-1010-09 11H AM 10102018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9682627382073 40.7730766743452)
2802 2802 -73.9533101544112 40.7938634280159 38H-AM-1019-01 38H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9533101544112 40.7938634280159)
2822 2822 -73.9711120079542 40.776080191176604 13D-PM-1018-14 13D PM 10182018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0 climbing (down) 0 0 0 0 0 0 1 0   POINT (-73.9711120079542 40.7760801911766)
2878 2878 -73.969720780557 40.774110568875706 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.969720780557 40.7741105688757)
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   0 0 0 0 0 wrestling with child 0 0 0 0 0 0 0 0   POINT (-73.956581233786 40.79021276908371)
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9632164738341 40.7921270121312)
2913 2913 -73.9621297946132 40.7944058222814 34A-PM-1013-05 34A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9621297946132 40.7944058222814)
2915 2915 -73.9734630412566 40.7653097139415 1H-PM-1013-02 01H PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9734630412566 40.7653097139415)
2938 2938 -73.97033289561999 40.7701079697795 7H-AM-1006-14 07H AM 10062018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97033289562 40.7701079697795)
2943 2943 -73.962534856258 40.7812134517411 22H-PM-1007-01 22H PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.962534856258 40.7812134517411)
2971 2971 -73.9639801411692 40.7778921302618 18I-PM-1007-04 18I PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 walking sitting up 0 0 0 0 0 0 0 1   POINT (-73.9639801411692 40.7778921302618)
2998 2998 -73.97520792474191 40.775537697900205 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752079247419 40.7755376979002)
2999 2999 -73.972415182837 40.773080463452004 10E-AM-1010-02 10E AM 10102018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.972415182837 40.773080463452)
3003 3003 -73.96986639266571 40.773999710413 12F-PM-1007-09 12F PM 10072018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9698663926657 40.773999710413)
214 214 -73.97725765612441 40.767989509396294 3D-AM-1006-08 03D AM 10062018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0 approaches (food stand) POINT (-73.9772576561244 40.7679895093963)
470 470 -73.95812430217221 40.794431473386 36D-AM-1007-01 36D AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1 avoiding a dog POINT (-73.95812430217221 40.794431473386)
685 685 -73.9658181813014 40.7798160637561 19F-AM-1007-01 19F AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 bit scared POINT (-73.9658181813014 40.7798160637561)
2454 2454 -73.9565151662506 40.794664798744705 37E-PM-1006-07 37E PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 me POINT (-73.9565151662506 40.7946647987447)
2060 2060 -73.9575798004084 40.795701403548996 38D-PM-1006-04 38D PM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 near drive -runners -cyclists POINT (-73.95757980040841 40.795701403549)
1135 1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree 0 1 0 0 0 watching me 0 1 0 1 0 0 0 0 observant POINT (-73.9667474482967 40.7760643720793)
493 493 -73.97768547979159 40.768310229566296 3D-AM-1006-04 03D AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (boy on bike) POINT (-73.9776854797916 40.7683102295663)
2245 2245 -73.9774228454023 40.7686399839016 3D-AM-1006-05 03D AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (chased by boy),wary of humans in playground POINT (-73.9774228454023 40.7686399839016)
2583 2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
2488 2488 -73.97269208477921 40.779411746388895 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scared by dog POINT (-73.9726920847792 40.7794117463889)
1680 1680 -73.9638167248251 40.7776485679354 18I-PM-1007-03 18I PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 0 stared at me POINT (-73.9638167248251 40.77764856793541)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "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" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 8.192ms