2018_Central_Park_Squirrel_Census_-_Squirrel_Data

43 rows where Specific Location = "tree" sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number ✖

Specific Location ✖

  • tree · 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
46 46 -73.9673253417305 40.7749505252981 13H-PM-1010-02 13H PM 10102018 2 Adult Gray   Gray+   Above Ground 5 tree 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9673253417305 40.7749505252981)
98 98 -73.9730277911422 40.771214548882796 7F-AM-1008-16 07F AM 10082018 16 Juvenile Gray   Gray+   Above Ground 2 tree 0 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9730277911422 40.7712145488828)
112 112 -73.96517544644391 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9651754464439 40.7755181941559)
189 189 -73.9735489537928 40.76812579115229 4G-AM-1006-02 04G AM 10062018 2   Gray White Gray+White   Above Ground 12 tree 0 0 0 0 0 sitting in tree 0 0 0 0 0 0 1 0   POINT (-73.9735489537928 40.7681257911523)
260 260 -73.97843611793199 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree 0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.978436117932 40.7724769242403)
262 262 -73.97128762341721 40.7695885530701 7H-PM-1006-02 07H PM 10062018 2 Adult Gray   Gray+   Above Ground 25 tree 1 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9712876234172 40.7695885530701)
433 433 -73.9558474701153 40.7913335515534 34H-AM-1007-01 34H AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree 0 0 0 0 0   1 1 0 0 0 0 0 0   POINT (-73.9558474701153 40.7913335515534)
440 440 -73.9642717435966 40.782087049693 22F-AM-1007-05 22F AM 10072018 5 Adult Gray White Gray+White   Above Ground 10 tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9642717435966 40.782087049693)
476 476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree 0 0 0 0 0   1 1 0 0 0 0 0 0 not backing down POINT (-73.9690968160819 40.769923269444)
496 496 -73.9548430741605 40.798207350942 41E-AM-1007-06 41E AM 10072018 6 Adult Gray   Gray+   Above Ground 30 tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9548430741605 40.798207350942)
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)
569 569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree 1 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9709040623777 40.7701163892686)
700 700 -73.9691261755936 40.7702929428604 8I-AM-1006-12 08I AM 10062018 12 Adult Gray   Gray+   Above Ground 50 tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691261755936 40.7702929428604)
789 789 -73.9675023138703 40.7872554700995 25A-PM-1007-01 25A PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 40 tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9675023138703 40.7872554700995)
861 861 -73.953287300494 40.793520326789 37H-PM-1006-04 37H PM 10062018 4       +   Above Ground 43 tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.953287300494 40.793520326789)
908 908 -73.9594120573719 40.78419457505979 26I-PM-1010-05 26I PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9594120573719 40.7841945750598)
1016 1016 -73.9691293546408 40.7703219076549 8I-AM-1006-11 08I AM 10062018 11 Adult Gray   Gray+   Above Ground 50 tree 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691293546408 40.77032190765491)
1018 1018 -73.96953055553921 40.7757541971012 13F-PM-1008-03 13F PM 10082018 3 Adult Gray   Gray+   Above Ground 15 tree 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9695305555392 40.7757541971012)
1201 1201 -73.97828135384209 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.9782813538421 40.7715730368712)
1329 1329 -73.9772164524209 40.768839953875606 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree 1 0 1 0 0   0 0 0 0 0 0 0 0 did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)
1371 1371 -73.9542733797804 40.795578653743 39F-PM-1006-02 39F PM 10062018 2 Adult Gray   Gray+   Above Ground 20 tree 0 0 0 0 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.9542733797804 40.795578653743)
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)
1467 1467 -73.9684657285532 40.7840113573723 22B-AM-1013-05 22B AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 0 0 1 0 0   0 0 0 0 0 0 0 0 looked down on me like her imperial subject POINT (-73.9684657285532 40.7840113573723)
1625 1625 -73.9736873018042 40.76491066771379 1I-PM-1012-02 01I PM 10122018 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1 tree 0 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9736873018042 40.7649106677138)
1745 1745 -73.9688438058715 40.7703014325728 8I-AM-1006-05 08I AM 10062018 5 Adult Gray White Gray+White   Above Ground 20 tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9688438058715 40.7703014325728)
1842 1842 -73.9532804650089 40.7934579333341 37H-PM-1006-05 37H PM 10062018 5       +   Above Ground   tree 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9532804650089 40.7934579333341)
1850 1850 -73.975809362521 40.773470273783495 8B-PM-1012-09 08B PM 10122018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.975809362521 40.7734702737835)
1931 1931 -73.9533085932603 40.793487786107505 37H-PM-1006-03 37H PM 10062018 3       +   Above Ground 43 tree 0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9533085932603 40.7934877861075)
2144 2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree 0 0 1 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.975198284551 40.7740343763399)
2280 2280 -73.97671436441509 40.76847569413211 3D-AM-1006-02 03D AM 10062018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25 tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767143644151 40.7684756941321)
2282 2282 -73.9722056538718 40.7805111762703 17A-PM-1013-03 17A PM 10132018 3 Adult Gray   Gray+   Above Ground 15 tree 0 0 0 0 0 grooming! & scratching 0 0 0 0 0 0 1 0   POINT (-73.9722056538718 40.7805111762703)
2352 2352 -73.9727310397798 40.778701677351705 15B-PM-1017-02 15B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE tree 0 0 1 1 1 digging,chewing on tree—has nut in mouth! 0 0 0 0 0 0 0 1   POINT (-73.97273103977982 40.7787016773517)
2699 2699 -73.9743509423821 40.7690043677328 5F-AM-1007-02 05F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97435094238212 40.7690043677328)
2944 2944 -73.97394038506219 40.769316228750895 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9739403850622 40.7693162287509)
335 335 -73.97823514358521 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 0 1 0   0 0 0 1 1 0 0 0   POINT (-73.9782351435852 40.7715896672335)
856 856 -73.9591667162801 40.7937602121568 35D-PM-1013-07 35D PM 10132018 7 Juvenile Gray White Gray+White   Above Ground 12 tree 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.95916671628011 40.7937602121568)
1048 1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree 0 0 1 0 0   0 0 0 1 1 0 0 0 curious POINT (-73.9782120139407 40.7717154468791)
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
1118 1118 -73.9719460335398 40.7810508156287 18A-AM-1012-01 18A AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 3 tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719460335398 40.7810508156287)
1627 1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree 0 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594391759139 40.784115697669)
2157 2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
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)
2874 2874 -73.9597453664295 40.7891382153733 30F-PM-1007-01 30F PM 10072018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 1 tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9597453664295 40.7891382153733)

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