2018_Central_Park_Squirrel_Census_-_Squirrel_Data

216 rows where Date = 10172018

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 47
  • 1 5

Chasing ✖

  • 0 49
  • 1 3

Date ✖

  • 10172018 · 52 ✖
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
2246 2246 -73.9711607544742 40.774988247642 12E-AM-1017-04 12E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711607544742 40.774988247642)
2293 2293 -73.9675309175947 40.7788649926486 17E-AM-1017-09 17E AM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675309175947 40.7788649926486)
2296 2296 -73.965596981561 40.7797738845824 19F-PM-1017-02 19F PM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.965596981561 40.7797738845824)
2310 2310 -73.9712863172608 40.774698758184 12E-AM-1017-01 12E AM 10172018 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.9712863172608 40.774698758184)
2324 2324 -73.9737247632185 40.7759469280872 12C-PM-1017-01 12C PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 digging/burying,drinking from lake 0 0 0 0 1 0 1 0   POINT (-73.9737247632185 40.7759469280872)
2327 2327 -73.9567801028221 40.7960096659564 38D-AM-1017-01 38D AM 10172018 1       +   Above Ground 30   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9567801028221 40.7960096659564)
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)
2364 2364 -73.9587183039085 40.790920913796896 32E-PM-1017-02 32E PM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9587183039085 40.7909209137969)
2376 2376 -73.9594204646985 40.790592376521296 32E-PM-1017-11 32E PM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9594204646985 40.7905923765213)
2400 2400 -73.97682684678571 40.771460804193296 6B-PM-1017-02 06B PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9768268467857 40.7714608041933)
2414 2414 -73.97081754618041 40.7759228565501 13E-AM-1017-10 13E AM 10172018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9708175461804 40.7759228565501)
2442 2442 -73.9699369796844 40.772035019127294 10G-PM-1017-04 10G PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9699369796844 40.7720350191273)
2449 2449 -73.9599911537509 40.791445254284504 33D-AM-1017-04 33D AM 10172018 4 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9599911537509 40.7914452542845)
2460 2460 -73.9526681107152 40.7977012009146 42F-PM-1017-01 42F PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.9526681107152 40.7977012009146)
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)
2495 2495 -73.9621253644004 40.7912082086879 31C-AM-1017-01 31C AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   1 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9621253644004 40.7912082086879)
2513 2513 -73.9767590273554 40.7717561807266 6B-PM-1017-07 06B PM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767590273554 40.7717561807266)
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)
2541 2541 -73.9579097104326 40.797227339471604 39C-AM-1017-03 39C AM 10172018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9579097104326 40.7972273394716)
2593 2593 -73.9590191812452 40.790616698140894 32E-PM-1017-08 32E PM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9590191812452 40.7906166981409)
2616 2616 -73.9675917702187 40.7789922281625 17E-AM-1017-02 17E AM 10172018 2 Adult Gray   Gray+   Above Ground 8 Shore 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9675917702187 40.7789922281625)
2643 2643 -73.9693719015914 40.7768710160557 14E-PM-1017-02 14E PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 staring 0 0 0 0 0 0 0 0   POINT (-73.9693719015914 40.7768710160557)
2649 2649 -73.9706428641753 40.7762933936464 13E-AM-1017-07 13E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706428641753 40.7762933936464)
2656 2656 -73.97239959684201 40.7788765078432 15B-PM-1017-04 15B PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE on hill 0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.972399596842 40.7788765078432)
2658 2658 -73.9690212174 40.783409940410706 21B-PM-1017-05 21B PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9690212174 40.7834099404107)
2678 2678 -73.95629468736941 40.7938593012595 36F-AM-1017-01 36F AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9562946873694 40.7938593012595)
2682 2682 -73.97110012783891 40.778746609584104 15C-PM-1017-01 15C PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9711001278389 40.7787466095841)
2694 2694 -73.969628583287 40.770406779793205 8H-AM-1017-03 08H AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 fence 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969628583287 40.7704067797932)
2697 2697 -73.9710674928906 40.7778757544025 15D-PM-1017-06 15D PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 0 0 stopped and watched me before slowly moving on POINT (-73.9710674928906 40.7778757544025)
2698 2698 -73.9744917362668 40.77783887377 13A-AM-1017-02 13A AM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744917362668 40.77783887377)
2721 2721 -73.95519234082391 40.796830266140205 40E-PM-1017-01 40E PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9551923408239 40.7968302661402)
2728 2728 -73.9507140045973 40.7957700986293 41I-PM-1017-01 41I PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon oval on back Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9507140045973 40.7957700986293)
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)
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)
2747 2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.971314838366 40.774951285041)
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)
2764 2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 paused to look at me POINT (-73.9692660977515 40.7830532310766)
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9705409446299 40.7764608087703)
2836 2836 -73.953092053256 40.7982256930243 42F-PM-1017-03 42F PM 10172018 3   Gray Cinnamon Gray+Cinnamon         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.953092053256 40.7982256930243)
2840 2840 -73.9532163535175 40.7982970313067 42F-PM-1017-04 42F PM 10172018 4   Gray   Gray+         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9532163535175 40.7982970313067)
2843 2843 -73.97147871782009 40.779804947074496 16B-PM-1017-01 16B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9714787178201 40.7798049470745)
2866 2866 -73.9744025383371 40.7777296605765 13A-AM-1017-04 13A AM 10172018 4 Adult Gray   Gray+         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744025383371 40.7777296605765)
2867 2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.969370141813 40.7840721191988)
2890 2890 -73.9726236083428 40.7788217771475 15B-PM-1017-03 15B PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE by water 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9726236083428 40.778821777147506)
2908 2908 -73.96542881512659 40.7815953970174 21E-AM-1017-02 21E AM 10172018 2 Adult Gray   Gray+   Above Ground 7   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9654288151266 40.7815953970174)
2932 2932 -73.9705837974358 40.775849484967296 13E-AM-1017-13 13E AM 10172018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97058379743581 40.7758494849673)
2964 2964 -73.9703604542938 40.776269022329394 13E-AM-1017-04 13E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9703604542938 40.7762690223294)
2974 2974 -73.9575791421589 40.7959934459432 38D-AM-1017-06 38D AM 10172018 6 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9575791421589 40.7959934459432)
2983 2983 -73.9689586689061 40.7839613907139 21B-PM-1017-04 21B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9689586689061 40.7839613907139)
2989 2989 -73.9643538221947 40.7917565604735 31A-PM-1017-01 31A PM 10172018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9643538221947 40.7917565604735)
2993 2993 -73.95707222626929 40.798570614351895 40C-AM-1017-04 40C AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1 chasing (#3) 0 0 0 0 0 0 1 0   POINT (-73.9570722262693 40.7985706143519)
3007 3007 -73.9635140434993 40.7912807969365 31B-AM-1017-01 31B AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9635140434993 40.7912807969365)

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