2018_Central_Park_Squirrel_Census_-_Squirrel_Data

148 rows where Date = 10072018 and Location = "Above Ground" sorted by Other Interactions

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Eating ✖

  • 0 41
  • 1 7

Location ✖

  • Above Ground · 48 ✖

Date ✖

  • 10072018 · 48 ✖
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
1994 1994 -73.9598463837775 40.783452472425395 25I-PM-1007-05 25I PM 10072018 5 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9598463837775 40.7834524724254)
1998 1998 -73.9595686513629 40.7906859748696 32E-AM-1007-06 32E AM 10072018 6 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9595686513629 40.7906859748696)
2003 2003 -73.9640526358598 40.7907411574825 30B-AM-1007-01 30B AM 10072018 1 Adult Gray   Gray+   Above Ground 35   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9640526358598 40.7907411574825)
2026 2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch 0 0 0 0 0 watching me scratching 1 0 0 1 0 0 1 0   POINT (-73.9622752768962 40.7814921913101)
2034 2034 -73.96991351872971 40.7782354186163 16D-AM-1007-03 16D AM 10072018 3 Adult     + ran away before I could take a good look Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9699135187297 40.7782354186163)
2074 2074 -73.9676246014119 40.786355136088 24A-PM-1007-05 24A PM 10072018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676246014119 40.786355136088)
2081 2081 -73.96757180595391 40.7786049141486 17F-AM-1007-06 17F AM 10072018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675718059539 40.7786049141486)
2145 2145 -73.96512504025829 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9651250402583 40.7812884929069)
2222 2222 -73.9639048209454 40.777737334555795 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639048209454 40.7777373345558)
2228 2228 -73.9714045891597 40.771541833397606 9G-AM-1007-03 09G AM 10072018 3 Adult Gray Black Gray+Black   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.97140458915972 40.7715418333976)
2248 2248 -73.9766477027266 40.7712737417779 6C-AM-1007-04 06C AM 10072018 4 Adult Gray   Gray+   Above Ground 20   0 1 1 0 0 chasing #5 0 0 0 0 0 0 1 0   POINT (-73.9766477027266 40.7712737417779)
2354 2354 -73.9636740170308 40.7903538224977 30B-AM-1007-12 30B AM 10072018 12 Adult Gray   Gray+   Above Ground 4   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.96367401703081 40.79035382249771)
2356 2356 -73.9611355303487 40.793069353224 34C-AM-1007-02 34C AM 10072018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611355303487 40.793069353224)
2388 2388 -73.9604476047877 40.7938014328732 35C-AM-1007-03 35C AM 10072018 3 Adult     +   Above Ground 40   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9604476047877 40.7938014328732)
2417 2417 -73.9720323148189 40.772970345961795 10E-PM-1007-01 10E PM 10072018 1 Adult Gray   Gray+   Above Ground 35   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9720323148189 40.7729703459618)
2419 2419 -73.9590551473416 40.7891607060794 31F-PM-1007-02 31F PM 10072018 2 Adult Gray   Gray+   Above Ground 2 tree trunk 0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.95905514734162 40.7891607060794)
2436 2436 -73.95827701417 40.785661023889105 28I-PM-1007-01 28I PM 10072018 1 Adult Gray   Gray+   Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.95827701417 40.7856610238891)
2440 2440 -73.96738035086291 40.778524502550795 17F-AM-1007-01 17F AM 10072018 1 Adult Gray   Gray+   Above Ground 18   0 0 1 1 0   0 0 0 1 0 0 1 0   POINT (-73.9673803508629 40.7785245025508)
2463 2463 -73.9653343572865 40.77752869246171 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9653343572865 40.7775286924617)
2478 2478 -73.96749310703241 40.778369369095394 17F-AM-1007-04 17F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Above Ground 4   0 0 0 1 0 chilling 1 0 0 0 0 0 1 0   POINT (-73.9674931070324 40.7783693690954)
2561 2561 -73.9591513028486 40.7835978067328 25I-PM-1007-01 25I PM 10072018 1 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9591513028486 40.7835978067328)
2603 2603 -73.97087815045279 40.7724138070355 10F-AM-1007-03 10F AM 10072018 3 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708781504528 40.7724138070355)
2634 2634 -73.96956851864891 40.7788293026327 16D-AM-1007-04 16D AM 10072018 4 Adult Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9695685186489 40.7788293026327)
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)
2708 2708 -73.9528429238071 40.7922651848867 36I-PM-1007-09 36I PM 10072018 9 Juvenile Gray   Gray+   Above Ground 5   1 1 0 0 0 burying nut 0 0 0 0 1 0 0 0   POINT (-73.9528429238071 40.7922651848867)
2730 2730 -73.96535757586871 40.78053399533721 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9653575758687 40.7805339953372)
2776 2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2791 2791 -73.9593624259363 40.7905522356793 32E-AM-1007-02 32E AM 10072018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9593624259363 40.7905522356793)
2826 2826 -73.9600357018376 40.790653976688105 32E-AM-1007-08 32E AM 10072018 8 Adult Gray   Gray+   Above Ground 65 tree top 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9600357018376 40.7906539766881)
2851 2851 -73.955208233231 40.7890574331084 32I-PM-1007-02 32I PM 10072018 2 Adult     +   Above Ground 30   0 0 1 0 0 different sound - happy,playful chirps 0 0 0 0 1 0 1 0   POINT (-73.955208233231 40.7890574331084)
2859 2859 -73.9786940945874 40.769082027688796 3B-PM-1007-05 03B PM 10072018 5 Juvenile Gray   Gray+   Above Ground 6 on rock 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9786940945874 40.7690820276888)
2868 2868 -73.9653873284496 40.7804699882574 20F-PM-1007-11 20F PM 10072018 11 Adult Gray White Gray+White   Above Ground 10 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653873284496 40.7804699882574)
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)
2893 2893 -73.97931014826541 40.7692600238491 3B-PM-1007-02 03B PM 10072018 2 Adult Gray   Gray+   Above Ground 10 in tree 0 0 0 0 0 chased by dog 0 0 0 0 0 0 0 0   POINT (-73.9793101482654 40.7692600238491)
2927 2927 -73.96501200660741 40.7805932882407 20F-PM-1007-13 20F PM 10072018 13 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9650120066074 40.78059328824071)
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)
2990 2990 -73.97660121083071 40.7712310725379 6C-AM-1007-05 06C AM 10072018 5 Adult Gray   Gray+   Above Ground 20   0 1 1 0 0 chasing #4 0 0 0 0 0 0 1 0   POINT (-73.9766012108307 40.7712310725379)
588 588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 0 alert & aware POINT (-73.9646597452128 40.7827698220703)
369 369 -73.9596398997228 40.793338695384705 34D-PM-1007-02 34D PM 10072018 2 Adult Black   Black+   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 0 cautiously aware POINT (-73.9596398997228 40.7933386953847)
1500 1500 -73.9769969548024 40.7710711265211 6C-AM-1007-01 06C AM 10072018 1 Adult Gray White Gray+White vid! Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 0 curious,but wary POINT (-73.97699695480242 40.7710711265211)
1099 1099 -73.9761527947483 40.770960700253895 6C-AM-1007-06 06C AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   0 0 1 0 0   0 0 0 0 0 0 0 0 disappeared when jogger ran by POINT (-73.9761527947483 40.7709607002539)
2037 2037 -73.96833704175509 40.781359835050004 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 0 1   0 0 0 0 1 0 0 0 fenced area POINT (-73.9683370417551 40.78135983505)
387 387 -73.9578316525492 40.789010295962896 31G-PM-1007-01 31G PM 10072018 1 Adult Gray   Gray+   Above Ground 15   0 0 0 0 0 hiding 0 0 0 0 1 0 0 0 froze,sight of dogs POINT (-73.9578316525492 40.7890102959629)
425 425 -73.9704485231855 40.7717290560806 9G-AM-1007-02 09G AM 10072018 2 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 1 kids were trying to poke it with a stick POINT (-73.9704485231855 40.7717290560806)
1324 1324 -73.954554245377 40.7983935730557 41E-AM-1007-05 41E AM 10072018 5 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1 man/pit bull mix wandered POINT (-73.954554245377 40.7983935730557)
1631 1631 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 10072018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 1 me! POINT (-73.9527196716568 40.792363826828)
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)
1887 1887 -73.95861842328891 40.7993153832942 41A-PM-1007-02 41A PM 10072018 2 Adult Black   Black+   Above Ground 15   0 0 1 0 0 jumping 0 0 0 0 0 0 0 0 stared at me POINT (-73.9586184232889 40.7993153832942)

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