2018_Central_Park_Squirrel_Census_-_Squirrel_Data

158 rows where Date = 10192018 sorted by Hectare Squirrel Number descending

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 58

Date ✖

  • 10192018 · 58 ✖
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
6 6 -73.9565700386162 40.7902561000937 33H-AM-1019-02 33H AM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 wrestling with mother 0 0 0 0 0 0 0 0   POINT (-73.9565700386162 40.7902561000937)
172 172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.958535640774 40.7982737896998)
187 187 -73.9700162034073 40.7815277479588 19B-AM-1019-02 19B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0 posing 0 0 0 0 0 0 1 1 indifferent then runs from POINT (-73.9700162034073 40.7815277479588)
200 200 -73.9510747586301 40.7973106833951 42H-AM-1019-02 42H AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9510747586301 40.7973106833951)
209 209 -73.97107601968679 40.7725506006789 10F-PM-1019-02 10F PM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Ground Plane FALSE Behind fence, grass 1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9710760196868 40.7725506006789)
638 638 -73.9562765288004 40.78806179638679 31I-PM-1019-02 31I PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9562765288004 40.7880617963868)
766 766 -73.96844631543979 40.78348133193521 21B-AM-1019-02 21B AM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9684463154398 40.7834813319352)
1009 1009 -73.9636551433178 40.790157281877605 30B-PM-1019-02 30B PM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9636551433178 40.7901572818776)
1186 1186 -73.96740331258341 40.7769132902037 15G-PM-1019-02 15G PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9674033125834 40.7769132902037)
1265 1265 -73.96035971176191 40.7824399298414 23I-PM-1019-02 23I PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9603597117619 40.7824399298414)
1286 1286 -73.9589096782789 40.793969875790296 35D-AM-1019-02 35D AM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Black tail & edge, Cinnamon mid, While tail edge Ground Plane FALSE   0 0 0 0 1 very quietly searching in long grass 0 0 0 0 0 0 0 0   POINT (-73.9589096782789 40.7939698757903)
1372 1372 -73.95283537022091 40.7976456178263 41F-PM-1019-02 41F PM 10192018 2       +         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9528353702209 40.7976456178263)
1613 1613 -73.95992022335359 40.7972599930224 38A-AM-1019-02 38A AM 10192018 2 Adult Gray   Gray+   Above Ground 3   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9599202233536 40.7972599930224)
1833 1833 -73.962516494651 40.788476898990204 28D-PM-1019-02 28D PM 10192018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.962516494651 40.7884768989902)
1885 1885 -73.9594174605642 40.7973128653773 38B-AM-1019-02 38B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594174605642 40.7973128653773)
1956 1956 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)
2200 2200 -73.96980803283041 40.7842252948542 21A-AM-1019-02 21A AM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE Tree & ground 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9698080328304 40.7842252948542)
2320 2320 -73.9576897478787 40.796469532845705 38C-AM-1019-02 38C AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9576897478787 40.7964695328457)
2380 2380 -73.97613757295049 40.766223189212496 1F-PM-1019-02 01F PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9761375729505 40.7662231892125)
2488 2488 -73.97269208477921 40.779411746388895 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scared by dog POINT (-73.9726920847792 40.7794117463889)
2509 2509 -73.97142951022491 40.776954371947 14D-PM-1019-02 14D PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714295102249 40.776954371947)
2608 2608 -73.95226776576591 40.7934034811368 38I-AM-1019-02 38I AM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9522677657659 40.7934034811368)
2688 2688 -73.9799302952205 40.767720720979796 1B-PM-1019-02 01B PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9799302952205 40.7677207209798)
2834 2834 -73.9651132904127 40.7905384124102 29A-PM-1019-02 29A PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9651132904127 40.7905384124102)
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9530811255728 40.79830691185791)
2904 2904 -73.97203897567171 40.7763524091989 13C-PM-1019-02 13C PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9720389756717 40.7763524091989)
170 170 -73.95972059663241 40.7969409510133 38B-AM-1019-01 38B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9597205966324 40.7969409510133)
286 286 -73.97209073846129 40.7762987836055 13C-PM-1019-01 13C PM 10192018 1 Adult Gray   Gray+   Above Ground 7   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9720907384613 40.7762987836055)
365 365 -73.9576035072364 40.7966120824816 38C-AM-1019-01 38C AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (lawnmower) POINT (-73.9576035072364 40.7966120824816)
512 512 -73.9586098170241 40.793965373389796 35D-AM-1019-01 35D AM 10192018 1       +   Above Ground   on tree, blue jays gathering nearby 0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9586098170241 40.7939653733898)
699 699 -73.95046935442251 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9504693544225 40.797225436004)
804 804 -73.9697196619878 40.7814068507607 19B-AM-1019-01 19B AM 10192018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Side stripes Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 1 indifferent then runs from POINT (-73.9697196619878 40.7814068507607)
846 846 -73.95826439540551 40.800046006127204 42A-AM-1019-01 42A AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.95826439540551 40.8000460061272)
855 855 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)
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)
1184 1184 -73.9807982742225 40.7678795985389 1B-PM-1019-01 01B PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9807982742225 40.7678795985389)
1269 1269 -73.9652921233647 40.790440565854 29A-PM-1019-01 29A PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9652921233647 40.790440565854)
1316 1316 -73.9674724790652 40.7768771349868 15G-PM-1019-01 15G PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9674724790652 40.7768771349868)
1423 1423 -73.96002043282009 40.782877291358 24I-AM-1019-01 24I AM 10192018 1 Adult Gray White Gray+White   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9600204328201 40.782877291358)
1441 1441 -73.961335649743 40.7818876867842 23H-PM-1019-01 23H PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.961335649743 40.7818876867842)
1653 1653 -73.9695881075086 40.7842441291991 21A-AM-1019-01 21A AM 10192018 1 Juvenile Gray Black Gray+Black   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0 keeps to tree,drops down on side away from people POINT (-73.9695881075086 40.7842441291991)
1764 1764 -73.95348783164721 40.7978951981698 41F-PM-1019-01 41F PM 10192018 1       +         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9534878316472 40.7978951981698)
1801 1801 -73.9587072373474 40.7985209579925 40B-AM-1019-01 40B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9587072373474 40.7985209579925)
1866 1866 -73.96360276644391 40.790075966587 30B-PM-1019-01 30B PM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9636027664439 40.790075966587)
1877 1877 -73.9524490779105 40.7936003219524 38I-AM-1019-01 38I AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9524490779105 40.7936003219524)
1997 1997 -73.97146376830841 40.776898456156296 14D-PM-1019-01 14D PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714637683084 40.7768984561563)
2283 2283 -73.9628982772673 40.788430480338604 28D-PM-1019-01 28D PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9628982772673 40.7884304803386)
2287 2287 -73.97681733031649 40.7661261813557 1F-PM-1019-01 01F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768173303165 40.7661261813557)
2342 2342 -73.9533645762606 40.7983709215535 42F-AM-1019-01 42F AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 0 1 runs from (me) POINT (-73.9533645762606 40.7983709215535)
2375 2375 -73.9563720614251 40.7879453306251 31I-PM-1019-01 31I PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9563720614251 40.7879453306251)
2466 2466 -73.95994199262991 40.797277472881106 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9599419926299 40.7972774728811)
2517 2517 -73.9710221361528 40.7724939691584 10F-PM-1019-01 10F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Above Ground 2 Behind fence, tree trunk 0 0 1 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9710221361528 40.7724939691584)
2629 2629 -73.9604576237503 40.7818120101394 23I-PM-1019-01 23I PM 10192018 1 Adult Gray   Gray+   Above Ground 35   1 0 0 0 0 running (across branches) 0 0 0 0 0 0 0 0   POINT (-73.9604576237503 40.7818120101394)
2802 2802 -73.9533101544112 40.7938634280159 38H-AM-1019-01 38H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9533101544112 40.7938634280159)
2841 2841 -73.9693262952166 40.783260411082004 21B-AM-1019-01 21B AM 10192018 1 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693262952166 40.783260411082)
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   0 0 0 0 0 wrestling with child 0 0 0 0 0 0 0 0   POINT (-73.956581233786 40.79021276908371)
2924 2924 -73.9727230609785 40.7795341640894 16A-PM-1019-01 16A PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9727230609785 40.7795341640894)
3017 3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 1 0 eating (on branch) 1 0 0 0 0 0 1 0   POINT (-73.9662895079734 40.7843300758044)

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