2018_Central_Park_Squirrel_Census_-_Squirrel_Data

47 rows where Date = 10132018, Hectare Squirrel Number = 1, Running = 0 and Runs from = 0 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent

Runs from ✖

Running ✖

Hectare Squirrel Number ✖

Date ✖

  • 10132018 · 47 ✖
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
271 271 -73.9661262885099 40.7844085550945 23D-AM-1013-01 23D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   0 0 1 0 0   0 0 0 0 0 1 0 0 approaches (he saw me,came towards,then darted up) POINT (-73.9661262885099 40.7844085550945)
291 291 -73.9679661308374 40.7837388390673 22C-AM-1013-01 22C AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 sitting still,tail over back 0 0 0 0 0 0 0 0   POINT (-73.9679661308374 40.7837388390673)
1178 1178 -73.9507772992986 40.7949188960194 40I-PM-1013-01 40I PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   0 0 0 1 0 eating (berries) 0 0 0 0 0 0 1 0   POINT (-73.9507772992986 40.7949188960194)
1225 1225 -73.95848035139392 40.7933802077327 35D-PM-1013-01 35D PM 10132018 1 Adult Gray White Gray+White   Above Ground 12   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584803513939 40.7933802077327)
1351 1351 -73.9610985171525 40.7913867116989 32D-AM-1013-01 32D AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9610985171525 40.7913867116989)
1935 1935 -73.9675268877392 40.775040968171794 13H-AM-1013-01 13H AM 10132018 1 Adult Gray White Gray+White   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675268877392 40.7750409681718)
2252 2252 -73.95377032313591 40.7915959393814 35I-AM-1013-01 35I AM 10132018 1 Adult Cinnamon White Cinnamon+White White underbelly Above Ground 18   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9537703231359 40.7915959393814)
2479 2479 -73.9657958433575 40.7763496875058 15H-AM-1013-01 15H AM 10132018 1 Adult Gray White Gray+White   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9657958433575 40.7763496875058)
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)
197 197 -73.9679336341793 40.7754186579647 14G-PM-1013-01 14G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0 watching POINT (-73.9679336341793 40.7754186579647)
272 272 -73.9521950056404 40.794937340844996 39H-PM-1013-01 39H PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0 ran away when a human approached with a dog POINT (-73.9521950056404 40.794937340845)
308 308 -73.9554095823557 40.788730580204394 32I-AM-1013-01 32I AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9554095823557 40.7887305802044)
353 353 -73.97400077595091 40.7650077086539 1H-PM-1013-01 01H PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9740007759509 40.7650077086539)
422 422 -73.9694630409125 40.769737659647 8I-PM-1013-01 08I PM 10132018 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.9694630409125 40.769737659647)
478 478 -73.954482814186 40.7987031768001 42D-PM-1013-01 42D PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon Drawing included. Ground Plane FALSE   0 0 0 0 1 watching passers-by 0 0 0 0 0 1 1 0   POINT (-73.954482814186 40.7987031768001)
545 545 -73.97568104536059 40.7756257458036 11A-PM-1013-01 11A PM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray Off-white, decorator's white? Ground Plane FALSE   0 0 0 1 0 eating (osage orange) 0 0 0 0 0 0 1 0   POINT (-73.9756810453606 40.7756257458036)
622 622 -73.97548367967059 40.7738879545412 9B-PM-1013-01 09B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 1 0 1 0   POINT (-73.9754836796706 40.7738879545412)
662 662 -73.9721854790038 40.776108635243794 12C-AM-1013-01 12C AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9721854790038 40.7761086352438)
688 688 -73.95807856006171 40.795798131089704 37C-PM-1013-01 37C PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9580785600617 40.7957981310897)
874 874 -73.95919577939921 40.79495688734529 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9591957793992 40.7949568873453)
918 918 -73.9681093100008 40.7731753915361 11H-PM-1013-01 11H PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 nut in mouth 0 0 0 0 0 0 1 0   POINT (-73.9681093100008 40.7731753915361)
927 927 -73.9609885686834 40.796110864031895 37A-PM-1013-01 37A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.96098856868342 40.7961108640319)
965 965 -73.97083010709241 40.7820200927465 19A-PM-1013-01 19A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 planting acorns 0 0 0 0 0 0 1 0   POINT (-73.9708301070924 40.7820200927465)
1027 1027 -73.9640016324897 40.7921759097124 32A-PM-1013-01 32A PM 10132018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9640016324897 40.7921759097124)
1052 1052 -73.9773858189627 40.770807701562 5B-PM-1013-01 05B PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9773858189627 40.770807701562)
1189 1189 -73.95776297445391 40.7897460758298 32G-PM-1013-01 32G PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 allowed me to approach within 10 ft POINT (-73.9577629744539 40.789746075829804)
1205 1205 -73.9611118778753 40.7952007875354 36A-PM-1013-01 36A PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 1 0 0   POINT (-73.9611118778753 40.7952007875354)
1211 1211 -73.9549337398033 40.794655273162796 38F-PM-1013-01 38F PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon tail & belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9549337398033 40.7946552731628)
1279 1279 -73.95121209494779 40.7947945266515 39I-PM-1013-01 39I PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE along the road 0 0 0 1 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9512120949478 40.7947945266515)
1306 1306 -73.9755974646331 40.767343579828896 3F-PM-1013-01 03F PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9755974646331 40.7673435798289)
1343 1343 -73.95636629637029 40.799195210194895 42C-PM-1013-01 42C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9563662963703 40.7991952101949)
1478 1478 -73.9676370985166 40.7869888639434 25A-AM-1013-01 25A AM 10132018 1   Gray White Gray+White White Belly Ground Plane FALSE   0 0 0 1 0 staring at me 0 0 0 0 0 0 1 0   POINT (-73.96763709851662 40.7869888639434)
1493 1493 -73.96847906578509 40.7838818717863 22B-AM-1013-01 22B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 looked at me,standing on back feet POINT (-73.9684790657851 40.7838818717863)
1526 1526 -73.96209645764691 40.791733200173795 32C-PM-1013-01 32C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9620964576469 40.7917332001738)
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9790889008147 40.7676402781925)
1848 1848 -73.96040944813359 40.795145147879296 36B-PM-1013-01 36B PM 10132018 1 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.9604094481336 40.7951451478793)
1869 1869 -73.9718248273522 40.780199897002895 17A-PM-1013-01 17A PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 crossing path 0 0 0 0 0 0 1 0   POINT (-73.9718248273522 40.78019989700291)
2030 2030 -73.9749251267433 40.7679111971294 4F-PM-1013-01 04F PM 10132018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9749251267433 40.7679111971294)
2134 2134 -73.9614373639552 40.7945051962914 35B-PM-1013-01 35B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 did not notice dog sitting a few yards away (10-20 ft) 0 0 0 1 0 0 1 0   POINT (-73.9614373639552 40.7945051962914)
2161 2161 -73.9715375915057 40.7751212088827 12D-AM-1013-01 12D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9715375915057 40.7751212088827)
2302 2302 -73.9754333866435 40.773239091613796 8C-PM-1013-01 08C PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9754333866435 40.7732390916138)
2378 2378 -73.9747592855901 40.776376287041295 12A-PM-1013-01 12A PM 10132018 1 Adult Gray   Gray+ But it was kind of dark? Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9747592855901 40.7763762870413)
2409 2409 -73.97259471799521 40.7794481577234 16A-AM-1013-01 16A AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9725947179952 40.7794481577234)
2438 2438 -73.969532160039 40.7822616641357 20B-PM-1013-01 20B PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.969532160039 40.7822616641357)
2549 2549 -73.972248505758 40.76590436930079 3I-PM-1013-01 03I PM 10132018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.972248505758 40.765904369300806)
2636 2636 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 10132018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Bench 0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9700264128414 40.7692014637698)
2711 2711 -73.96288429601181 40.793804857240296 34A-PM-1013-01 34A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1 took a chestnut 0 0 0 0 0 0 0 0   POINT (-73.9628842960118 40.7938048572403)

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