2018_Central_Park_Squirrel_Census_-_Squirrel_Data

143 rows where Climbing = 1 and Highlight Fur Color = "Cinnamon" sorted by longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 35
  • 1 8

Highlight Fur Color ✖

  • Cinnamon · 43 ✖

Climbing ✖

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
364 364 -73.9623696148045 40.792184861375 32B-AM-1017-04 32B AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9623696148045 40.792184861375)
2652 2652 -73.96205425147491 40.794373172213795 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9620542514749 40.7943731722138)
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0 chased by dog #2 1 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9615643742864 40.7944678447843)
2729 2729 -73.9615429203441 40.7907417648701 31D-AM-1014-01 31D AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20 Ground then up tree 0 0 1 0 0 chased by a doggo 0 0 1 0 0 0 0 1 runs from (dogs!) POINT (-73.9615429203441 40.7907417648701)
565 565 -73.9615402629655 40.7924082330328 33C-AM-1012-02 33C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along back & tail Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615402629655 40.7924082330328)
2872 2872 -73.96153964579959 40.792359436678296 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615396457996 40.7923594366783)
2724 2724 -73.96114340826671 40.7893671772846 30E-PM-1008-01 30E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 1 0 0 0 0 0 0   POINT (-73.9611434082667 40.7893671772846)
1152 1152 -73.9608399003798 40.7817704502248 23I-AM-1019-01 23I AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 18 on a tree 0 0 1 0 0   0 0 0 0 0 0 0 0 eyed me warily,then went up the tree POINT (-73.9608399003798 40.7817704502248)
1949 1949 -73.9605362268777 40.7939470599346 35C-AM-1007-02 35C AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9605362268777 40.7939470599346)
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)
2748 2748 -73.960094705031 40.7916066137699 33D-AM-1017-01 33D AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.960094705031 40.7916066137699)
2664 2664 -73.95983503855409 40.7973274000224 38A-PM-1013-04 38A PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598350385541 40.7973274000224)
201 201 -73.9598015842806 40.7973522744237 38A-PM-1013-03 38A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598015842806 40.7973522744237)
2731 2731 -73.9595886063173 40.7918405182594 33D-AM-1017-09 33D AM 10172018 9 Adult Black Cinnamon Black+Cinnamon   Above Ground 7   0 0 1 0 0   1 1 0 0 0 0 1 1   POINT (-73.9595886063173 40.7918405182594)
2016 2016 -73.9589492240754 40.798901118974 40A-PM-1014-01 40A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0   0 0 0 0 1 0 1 0 stared & then went back up tree—then ran to different tree POINT (-73.9589492240754 40.798901118974)
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree 0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9588339897601 40.7848084865431)
2968 2968 -73.9587236619579 40.799185018043396 40A-AM-1010-02 40A AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park at 108th West 1 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9587236619579 40.7991850180434)
1425 1425 -73.95862528758559 40.7852027586217 27I-AM-1007-03 27I AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon had .5 of a tail Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586252875856 40.7852027586217)
698 698 -73.95855376683821 40.7903905787005 32F-AM-1012-03 32F AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0 bringing green leaves to nest 0 0 0 0 0 0 0 0   POINT (-73.9585537668382 40.7903905787005)
378 378 -73.95848354168459 40.7978213396921 39B-PM-1014-06 39B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584835416846 40.7978213396921)
43 43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9574648097543 40.78925084286221)
2559 2559 -73.95723834787741 40.787685738072206 30H-PM-1006-01 30H PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9572383478774 40.7876857380722)
920 920 -73.9571233640232 40.7992458980266 41B-PM-1014-04 41B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 0 0 climbing POINT (-73.9571233640232 40.7992458980266)
2847 2847 -73.9568378330302 40.788031780276604 30I-PM-1006-04 30I PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568378330302 40.7880317802766)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
680 680 -73.95640114211221 40.7958097849369 38E-AM-1010-02 38E AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0 climbs POINT (-73.95640114211221 40.7958097849369)
916 916 -73.95618876244708 40.7958187455815 38E-AM-1010-04 38E AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 1 me POINT (-73.95618876244711 40.7958187455815)
2569 2569 -73.9559663734409 40.794582826137706 37F-AM-1010-01 37F AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9559663734409 40.7945828261377)
1273 1273 -73.95589438800509 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9558943880051 40.7971535141896)
837 837 -73.9557172336815 40.79211256577221 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9557172336815 40.7921125657722)
374 374 -73.9556817958407 40.788852000621 32I-AM-1013-02 32I AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556817958407 40.788852000621)
2262 2262 -73.9556177490335 40.788856916153705 32I-AM-1013-03 32I AM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556177490335 40.7888569161537)
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 chirps 0 0 0 0 1 0 1 0   POINT (-73.9552595564798 40.7889533029466)
631 631 -73.95488778301359 40.795015748910295 38F-AM-1018-04 38F AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.95488778301362 40.7950157489103)
1022 1022 -73.95488534927121 40.7984783584388 41D-PM-1014-04 41D PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0 jumping tree to tree 0 0 0 0 0 0 0 0   POINT (-73.9548853492712 40.7984783584388)
1608 1608 -73.9545425520879 40.7956853415959 39F-PM-1006-04 39F PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 in tree 0 0 1 0 0 climbing down 0 0 0 0 0 0 0 1 ran when saw me POINT (-73.9545425520879 40.7956853415959)
2639 2639 -73.9543832609857 40.795355063970106 39F-AM-1014-02 39F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 rocks 1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9543832609857 40.7953550639701)
1064 1064 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon         1 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9540257319561 40.798408619116)
1522 1522 -73.95389705545321 40.7955196793479 39G-PM-1013-03 39G PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9538970554532 40.7955196793479)
942 942 -73.9533923917973 40.796170187476896 40G-AM-1007-01 40G AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 large tree 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9533923917973 40.7961701874769)
504 504 -73.95334760207359 40.7933003544685 37H-PM-1006-02 37H PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE tree 1 0 1 0 1   1 0 0 0 0 0 0 1 dogs POINT (-73.9533476020736 40.7933003544685)
1464 1464 -73.95320745731391 40.793466946490796 37H-PM-1006-06 37H PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9532074573139 40.7934669464908)

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 13.067ms