2018_Central_Park_Squirrel_Census_-_Squirrel_Data

36 rows where Date = 10132018, Hectare Squirrel Number = 1 and Highlight Fur Color = "Cinnamon" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Eating ✖

  • 0 28
  • 1 8

Highlight Fur Color ✖

  • Cinnamon · 36 ✖

Hectare Squirrel Number ✖

Date ✖

  • 10132018 · 36 ✖
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
118 118 -73.9566346046453 40.7973923396512 40D-PM-1013-01 40D PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9566346046453 40.7973923396512)
135 135 -73.9694168118643 40.7728877377977 11G-PM-1013-01 11G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 In the Woods/Brush 0 0 1 0 1   0 0 0 0 0 0 0 1 watching me POINT (-73.9694168118643 40.7728877377977)
195 195 -73.97377736133109 40.7673662611015 3G-PM-1013-01 03G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9737773613311 40.7673662611015)
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)
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)
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)
403 403 -73.9597470659927 40.797321593541604 38A-PM-1013-01 38A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9597470659927 40.7973215935416)
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)
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)
630 630 -73.9580109357087 40.78556544054471 28I-AM-1013-01 28I AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Jumped onto path & then back into brush 0 0 0 0 0 stood on fence 0 0 0 0 0 0 0 1   POINT (-73.9580109357087 40.7855654405447)
802 802 -73.958494212554 40.7995008636057 41A-AM-1013-01 41A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 ran across a path 0 0 0 0 0 0 1 0   POINT (-73.958494212554 40.7995008636057)
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)
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)
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)
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)
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)
1621 1621 -73.97349693209429 40.7722754599865 8E-AM-1013-01 08E AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9734969320943 40.7722754599865)
1865 1865 -73.9558118887106 40.796885713436 39E-PM-1013-01 39E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9558118887106 40.796885713436005)
1896 1896 -73.973998077367 40.773902913391105 10C-PM-1013-01 10C PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.973998077367 40.7739029133911)
1945 1945 -73.9530257401736 40.795139740737 39G-PM-1013-01 39G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9530257401736 40.79513974073701)
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)
2183 2183 -73.967334936601 40.7773289724189 16F-PM-1013-01 16F PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Woods 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.967334936601 40.7773289724189)
2275 2275 -73.96142184133559 40.793894505879294 34B-AM-1013-01 34B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 hopping 0 0 0 0 1 1 0 0   POINT (-73.9614218413356 40.7938945058793)
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)
2371 2371 -73.9769520212123 40.774006725862996 9A-AM-1013-01 09A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9769520212123 40.774006725863)
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.973552877209 40.7715638228207)
2446 2446 -73.95227045119691 40.796566887896105 41G-AM-1013-01 41G AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9522704511969 40.7965668878961)
2530 2530 -73.95610768244549 40.7981145780509 40D-AM-1013-01 40D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9561076824455 40.7981145780509)
2585 2585 -73.9771726831497 40.7732320781799 8A-AM-1013-01 08A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE trail 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9771726831497 40.7732320781799)
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)
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)
2969 2969 -73.9654409838612 40.7901338748522 29A-AM-1013-01 29A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 climbed tree (oak) 0 0 0 0 1 0 0 1   POINT (-73.9654409838612 40.7901338748522)

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