2018_Central_Park_Squirrel_Census_-_Squirrel_Data

131 rows where Date = 10122018 and Foraging = 1 sorted by Climbing

✎ View and edit SQL

This data as json, CSV (advanced)

Foraging ✖

Date ✖

  • 10122018 · 64 ✖
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
1959 1959 -73.97077370737709 40.780037346583796 17B-PM-1012-02 17B PM 10122018 2 Adult Black   Black+   Ground Plane FALSE   1 1 0 0 1 2/3 chasing each other 1 1 0 1 1 0 1 0   POINT (-73.9707737073771 40.7800373465838)
1991 1991 -73.965059909327 40.776213188679705 15I-PM-1012-06 15I PM 10122018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.965059909327 40.7762131886797)
2019 2019 -73.9566705412766 40.7935560645735 36F-PM-1012-01 36F PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Near rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9566705412766 40.7935560645735)
2023 2023 -73.9663977261879 40.775645134229 14H-PM-1012-08 14H PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9663977261879 40.775645134229)
2057 2057 -73.9579659543224 40.7905646887034 32F-AM-1012-07 32F AM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9579659543224 40.7905646887034)
2089 2089 -73.9535980341677 40.7981186822179 42E-PM-1012-01 42E PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9535980341677 40.7981186822179)
2106 2106 -73.9801651470389 40.767769865693495 1B-AM-1012-05 01B AM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9801651470389 40.7677698656935)
2147 2147 -73.9651217998407 40.7761115392738 15I-PM-1012-01 15I PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9651217998407 40.7761115392738)
2155 2155 -73.9538938706987 40.7981150065974 42E-PM-1012-05 42E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538938706987 40.7981150065974)
2176 2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   1 0 0 1 1 0 0 1   POINT (-73.95832017896151 40.7913938722521)
2211 2211 -73.9799250782277 40.767610659888895 1B-AM-1012-03 01B AM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97992507822771 40.7676106598889)
2250 2250 -73.95890163858891 40.7911727679625 33E-PM-1012-03 33E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9589016385889 40.7911727679625)
2277 2277 -73.95385121459 40.7981257651433 42E-PM-1012-04 42E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95385121459 40.7981257651433)
2306 2306 -73.956453902485 40.7936584431012 36F-PM-1012-05 36F PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.956453902485 40.7936584431012)
2311 2311 -73.96801718943509 40.772464442631296 11I-PM-1012-07 11I PM 10122018 7 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying its food into the ground 0 0 0 0 0 0 0 0   POINT (-73.96801718943512 40.7724644426313)
2314 2314 -73.9663961415789 40.7750691120996 14H-PM-1012-06 14H PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary with a note that it was "hard to tell". Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9663961415789 40.7750691120996)
2328 2328 -73.9678620840741 40.784719027304 23B-PM-1012-03 23B PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1 2/3 were chasing each other 0 0 0 0 1 0 0 1   POINT (-73.96786208407411 40.784719027304)
2367 2367 -73.9681671864047 40.7753770538635 14G-AM-1012-04 14G AM 10122018 4 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9681671864047 40.7753770538635)
2381 2381 -73.95884149804891 40.7953525481367 37C-AM-1012-01 37C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 caching 0 0 0 0 0 0 0 1   POINT (-73.9588414980489 40.7953525481367)
2405 2405 -73.9588361742943 40.791115225155 33E-PM-1012-02 33E PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9588361742943 40.791115225155)
2428 2428 -73.9755643404768 40.769756914938796 5E-PM-1012-03 05E PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9755643404768 40.7697569149388)
2430 2430 -73.9569811285656 40.793091234605 35F-PM-1012-02 35F PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9569811285656 40.793091234605)
2447 2447 -73.9589670987899 40.795212703928705 37C-AM-1012-04 37C AM 10122018 4 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9589670987899 40.7952127039287)
2477 2477 -73.9663297144622 40.7837932023685 22D-PM-1012-03 22D PM 10122018 3 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9663297144622 40.7837932023685)
2492 2492 -73.9801619956135 40.76785766975421 1B-AM-1012-09 01B AM 10122018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9801619956135 40.7678576697542)
2494 2494 -73.9713968424625 40.774039018852704 11E-PM-1012-03 11E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9713968424625 40.7740390188527)
2538 2538 -73.9796985410897 40.767861283506704 1B-AM-1012-01 01B AM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9796985410897 40.7678612835067)
2568 2568 -73.9779039082557 40.7675313108314 2D-PM-1012-01 02D PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9779039082557 40.7675313108314)
2591 2591 -73.9786351029146 40.771611416400205 6A-PM-1012-06 06A PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE elevated ground 0 1 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9786351029146 40.771611416400205)
2627 2627 -73.97663480786329 40.7717715634438 7C-AM-1012-01 07C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 hopping around grass 0 0 0 0 0 0 1 0   POINT (-73.9766348078633 40.7717715634438)
2638 2638 -73.9598973337711 40.793334636047796 34C-PM-1012-01 34C PM 10122018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9598973337711 40.7933346360478)
2666 2666 -73.9763593390732 40.771729705854895 7C-AM-1012-03 07C AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 foraging (loving the acorns!) 0 0 0 0 0 0 1 0   POINT (-73.97635933907321 40.7717297058549)
2673 2673 -73.9768867959365 40.7734803954589 8B-PM-1012-01 08B PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768867959365 40.7734803954589)
2691 2691 -73.9564599077179 40.7965185098695 39D-PM-1012-01 39D PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9564599077179 40.7965185098695)
2757 2757 -73.96714191194559 40.77586024868621 14G-AM-1012-01 14G AM 10122018 1 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9671419119456 40.7758602486862)
2806 2806 -73.9714298880357 40.774105786890004 11E-PM-1012-02 11E PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714298880357 40.77410578689)
2808 2808 -73.9765027953575 40.7717327360835 7C-AM-1012-02 07C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 hopping around 0 0 0 0 0 0 1 0   POINT (-73.9765027953575 40.7717327360835)
2823 2823 -73.9664054327771 40.7756180893318 14H-PM-1012-07 14H PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9664054327771 40.7756180893318)
2860 2860 -73.95651796713192 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.95651796713192 40.7936663940365)
2880 2880 -73.9726598256924 40.7707862446236 7F-PM-1012-03 07F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9726598256924 40.7707862446236)
2900 2900 -73.9631005470369 40.788549405719294 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9631005470369 40.7885494057193)
2903 2903 -73.9670432105975 40.7753462013506 14H-PM-1012-03 14H PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9670432105975 40.7753462013506)
2929 2929 -73.953123365424 40.7941113777459 38H-PM-1012-01 38H PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.953123365424 40.7941113777459)
2986 2986 -73.97565337638129 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9756533763813 40.7733537881363)
3000 3000 -73.9688293382172 40.7738958027568 12G-AM-1012-04 12G AM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9688293382172 40.773895802756805)
3021 3021 -73.96658719935171 40.783677506488296 22D-PM-1012-07 22D PM 10122018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9665871993517 40.7836775064883)
3023 3023 -73.97547941915529 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9754794191553 40.7696404489025)
402 402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 1 runs from the dog POINT (-73.9681917366128 40.7723298813768)
760 760 -73.97182341595571 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 1 burying 0 0 0 1 0 0 0 1   POINT (-73.9718234159557 40.7810842503715)
798 798 -73.98085422862799 40.7678702158382 1B-AM-1012-17 01B AM 10122018 17 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.98085422862802 40.7678702158382)
889 889 -73.96810426129379 40.772331431865 11I-PM-1012-04 11I PM 10122018 4 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681042612938 40.772331431865)
931 931 -73.97859484138829 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785948413883 40.7718908026758)
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)
1299 1299 -73.9766653663947 40.7688767713012 4D-AM-1012-01 04D AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9766653663947 40.7688767713012)
1317 1317 -73.9680522379372 40.772389813511 11I-PM-1012-06 11I PM 10122018 6 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9680522379372 40.772389813511)
1487 1487 -73.96539465596099 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1 burying the food on ground 0 0 0 0 0 0 0 0 look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)
1568 1568 -73.96810798698209 40.772349408134495 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681079869821 40.7723494081345)
1697 1697 -73.9568610943394 40.7935959584643 36E-PM-1012-02 36E PM 10122018 2 Adult Gray   Gray+   Above Ground 28 on tree branch 0 0 1 0 1 picking acorns off oak tree 0 0 0 0 0 0 1 0   POINT (-73.95686109433942 40.7935959584643)
1962 1962 -73.9647318357023 40.7760936175332 15I-PM-1012-04 15I PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9647318357023 40.7760936175332)
2069 2069 -73.9538377039825 40.798060533496106 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 0 1   1 0 0 0 0 0 1 0   POINT (-73.9538377039825 40.7980605334961)
2090 2090 -73.9569759970802 40.7931497452294 35F-PM-1012-03 35F PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9569759970802 40.79314974522941)
2317 2317 -73.97673696861709 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9767369686171 40.7735074437085)
2511 2511 -73.95845615374209 40.791121116475395 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 1 0 0 0   POINT (-73.9584561537421 40.7911211164754)
2818 2818 -73.9681664642028 40.77246696819579 11I-PM-1012-02 11I PM 10122018 2 Adult Gray   Gray+   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 0 1 runs away from the ball POINT (-73.9681664642028 40.7724669681958)

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.115ms