2018_Central_Park_Squirrel_Census_-_Squirrel_Data

174 rows where Date = 10062018 and Shift = "PM" sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 43
  • 1 31

Shift ✖

Date ✖

  • 10062018 · 74 ✖
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
2063 2063 -73.95447632818859 40.7969645476349 40F-PM-1006-03 40F PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9544763281886 40.7969645476349)
2067 2067 -73.97250779335741 40.7654562710325 2I-PM-1006-01 02I PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 Sitting on back of bench with food hanging from mouth 0 0 0 0 0 staring at me 0 0 0 0 0 0 0 1   POINT (-73.9725077933574 40.7654562710325)
2087 2087 -73.956502663005 40.788160908881004 30I-PM-1006-05 30I PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.956502663005 40.788160908881)
2101 2101 -73.957600085245 40.7936111607879 35E-PM-1006-04 35E PM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.957600085245 40.7936111607879)
2120 2120 -73.9733905460282 40.7656337147768 2H-PM-1006-03 02H PM 10062018 3 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9733905460282 40.7656337147768)
2142 2142 -73.95985354257058 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0 hanging on fence 1 0 0 1 0 0 0 1   POINT (-73.9598535425706 40.7915589343685)
2150 2150 -73.9557710118271 40.791916118555704 34G-PM-1006-01 34G PM 10062018 1 Adult Black   Black+ Skinny, thin tail Ground Plane FALSE   0 0 0 0 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9557710118271 40.7919161185557)
2180 2180 -73.960864328605 40.7902122634639 31D-PM-1006-02 31D PM 10062018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.960864328605 40.7902122634639)
2193 2193 -73.95693181052529 40.7973442139041 40C-PM-1006-07 40C PM 10062018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9569318105253 40.7973442139041)
2197 2197 -73.9672413354558 40.7838116138235 22C-PM-1006-03 22C PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9672413354558 40.7838116138235)
2272 2272 -73.9569670900695 40.7948792856813 37E-PM-1006-03 37E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 me POINT (-73.9569670900695 40.794879285681304)
2290 2290 -73.95656457165641 40.795903994957705 38D-PM-1006-03 38D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9565645716564 40.795903994957705)
2292 2292 -73.96698919404629 40.7835635162331 22C-PM-1006-07 22C PM 10062018 7 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9669891940463 40.7835635162331)
2298 2298 -73.97553718499721 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755371849972 40.7733561233828)
2299 2299 -73.9605554843228 40.7901473714024 31E-PM-1006-09 31E PM 10062018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9605554843228 40.7901473714024)
2329 2329 -73.9717515173863 40.7747999274418 11D-PM-1006-04 11D PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9717515173863 40.7747999274418)
2336 2336 -73.95312632141359 40.7965675089932 40F-PM-1006-01 40F PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9531263214136 40.7965675089932)
2345 2345 -73.965738547469 40.78869627401671 27B-PM-1006-01 27B PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE By large tree 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.965738547469 40.7886962740167)
2362 2362 -73.9700263936574 40.769933509858106 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #6 0 0 0 0 0 0 1 0   POINT (-73.9700263936574 40.7699335098581)
2368 2368 -73.9731925179247 40.7748962746181 11D-PM-1006-02 11D PM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731925179247 40.7748962746181)
2408 2408 -73.9596949258862 40.79000794792171 31E-PM-1006-04 31E PM 10062018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9596949258862 40.7900079479217)
2457 2457 -73.9569896638974 40.7911914507504 33G-PM-1006-02 33G PM 10062018 2 Adult Gray   Gray+ my favorite Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0 engaged w/ me POINT (-73.9569896638974 40.7911914507504)
2542 2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)
2590 2590 -73.9568524771058 40.7974664985551 40C-PM-1006-06 40C PM 10062018 6 Juvenile Gray   Gray+   Ground Plane FALSE By The Road 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9568524771058 40.7974664985551)
2623 2623 -73.9604482901468 40.7898646293603 31E-PM-1006-07 31E PM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9604482901468 40.7898646293603)
2624 2624 -73.9706308500637 40.769617487459605 7H-PM-1006-10 07H PM 10062018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9706308500637 40.7696174874596)
2650 2650 -73.9538251716292 40.7919360198175 35I-PM-1006-01 35I PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538251716292 40.7919360198175)
2677 2677 -73.97348276186 40.7656171832911 2H-PM-1006-02 02H PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97348276186 40.7656171832911)
2726 2726 -73.9734206435334 40.7657854684194 2H-PM-1006-01 02H PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9734206435334 40.7657854684194)
2741 2741 -73.9545877741228 40.79000012103529 33I-PM-1006-01 33I PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9545877741228 40.7900001210353)
2750 2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.957775998085 40.7932880937406)
2785 2785 -73.9729105002306 40.7672758037086 4H-PM-1006-02 04H PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9729105002306 40.7672758037086)
2796 2796 -73.96310890114121 40.789191946875 29C-PM-1006-02 29C PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9631089011412 40.789191946875)
2814 2814 -73.9551625272308 40.791193071916 34H-PM-1006-06 34H PM 10062018 6 Adult Gray   Gray+   Ground Plane FALSE in grass 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9551625272308 40.791193071916)
2842 2842 -73.9579292340076 40.7976287835027 39C-PM-1006-04 39C PM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579292340076 40.7976287835027)
2847 2847 -73.9568378330302 40.788031780276604 30I-PM-1006-04 30I PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568378330302 40.7880317802766)
2858 2858 -73.9728723853967 40.7670816164986 4H-PM-1006-01 04H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9728723853967 40.7670816164986)
2870 2870 -73.9538475741188 40.796479421955 40F-PM-1006-02 40F PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538475741188 40.796479421955)
2873 2873 -73.955068474109 40.79117881528779 34H-PM-1006-05 34H PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White white tail tip Ground Plane FALSE in grass 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.955068474109 40.7911788152878)
2879 2879 -73.9744080700098 40.773151572182606 9C-PM-1006-07 09C PM 10062018 7 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE on top of tarped sand pile 0 0 0 1 0   0 0 0 0 0 0 0 1 (me) POINT (-73.9744080700098 40.7731515721826)
2895 2895 -73.9747873899653 40.77319452583271 9C-PM-1006-04 09C PM 10062018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9747873899653 40.7731945258327)
2909 2909 -73.9564478909357 40.79769287754171 40C-PM-1006-04 40C PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9564478909357 40.7976928775417)
2958 2958 -73.9541748083177 40.795275844289705 39F-PM-1006-01 39F PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 carrying leaves 0 0 0 0 0 0 1 0   POINT (-73.9541748083177 40.7952758442897)
15 15 -73.9674285955293 40.7829723919744 21C-PM-1006-01 21C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 1 1 0 0 0   POINT (-73.9674285955293 40.7829723919744)
298 298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 moseying 0 0 0 0 1 1 0 0   POINT (-73.957342596188 40.7944359654227)
314 314 -73.960601067176 40.7917243850136 32D-PM-1006-09 32D PM 10062018 9 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.960601067176 40.7917243850136)
360 360 -73.9672054610151 40.7876519923501 26A-PM-1006-05 26A PM 10062018 5 Adult Gray   Gray+   Above Ground 40   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9672054610151 40.7876519923501)
381 381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   1 0 0 1 0   0 0 0 0 1 0 0 1 ran up tree POINT (-73.959709414696 40.7919745085986)
546 546 -73.9547423290276 40.7899702628835 33I-PM-1006-09 33I PM 10062018 9 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9547423290276 40.7899702628835)
550 550 -73.9714465493257 40.7772135587308 14C-PM-1006-02 14C PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9714465493257 40.7772135587308)
670 670 -73.9602398690946 40.7910157676119 32D-PM-1006-04 32D PM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602398690946 40.7910157676119)
697 697 -73.97046560040201 40.770112577324795 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. 1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.970465600402 40.7701125773248)
728 728 -73.96029131055779 40.7910635810038 32D-PM-1006-03 32D PM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602913105578 40.7910635810038)
837 837 -73.9557172336815 40.79211256577221 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9557172336815 40.7921125657722)
1106 1106 -73.97029709193171 40.7696883113413 7H-PM-1006-08 07H PM 10062018 8 Adult Gray White Gray+White   Ground Plane FALSE in grass 0 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9702970919317 40.7696883113413)
1303 1303 -73.9603302382958 40.7910100435196 32D-PM-1006-01 32D PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9603302382958 40.7910100435196)
1345 1345 -73.95813265542058 40.7918074743129 34E-PM-1006-02 34E PM 10062018 2 Juvenile Black Gray, White Black+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9581326554206 40.7918074743129)
1519 1519 -73.97173027730099 40.7748805439381 11D-PM-1006-05 11D PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.971730277301 40.7748805439381)
1586 1586 -73.9714150090362 40.7774976423922 14C-PM-1006-03 14C PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9714150090362 40.7774976423922)
1703 1703 -73.956998502609 40.7948117428147 37E-PM-1006-01 37E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.956998502609 40.7948117428147)
1820 1820 -73.9546337446865 40.7898772579576 33I-PM-1006-08 33I PM 10062018 8 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9546337446865 40.7898772579576)
1973 1973 -73.957138759793 40.795592603505504 38D-PM-1006-02 38D PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.957138759793 40.7955926035055)
2396 2396 -73.9704339422613 40.77401495296439 11F-PM-1006-03 11F PM 10062018 3 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9704339422613 40.7740149529644)
2454 2454 -73.9565151662506 40.794664798744705 37E-PM-1006-07 37E PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 me POINT (-73.9565151662506 40.7946647987447)
2559 2559 -73.95723834787741 40.787685738072206 30H-PM-1006-01 30H PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9572383478774 40.7876857380722)
2604 2604 -73.9605163698302 40.7914179994956 32D-PM-1006-05 32D PM 10062018 5 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9605163698302 40.7914179994956)
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass 0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9713379914423 40.7696367609606)
2723 2723 -73.96064260275601 40.791726541984204 32D-PM-1006-08 32D PM 10062018 8 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0 stand on two feet and watching me POINT (-73.960642602756 40.7917265419842)
2766 2766 -73.95516398474659 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9551639847466 40.790858199891)
2782 2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9563473341712 40.78937123984251)
2803 2803 -73.9576652087316 40.787545797780105 29H-PM-1006-02 29H PM 10062018 2 Adult Gray   Gray+   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9576652087316 40.7875457977801)
2839 2839 -73.9672252136807 40.787650474321204 26A-PM-1006-04 26A PM 10062018 4 Adult Gray   Gray+   Above Ground 40   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9672252136807 40.7876504743212)
2935 2935 -73.96045994773449 40.7915035010169 32D-PM-1006-06 32D PM 10062018 6 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9604599477345 40.7915035010169)
2947 2947 -73.96012151981141 40.7909769801241 32D-PM-1006-02 32D PM 10062018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9601215198114 40.7909769801241)

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