2018_Central_Park_Squirrel_Census_-_Squirrel_Data

41 rows where Foraging = 1, Hectare Squirrel Number = 2 and Highlight Fur Color = "White" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Tail flags, Tail twitches, Indifferent, Runs from

Color notes ✖

Highlight Fur Color ✖

  • White · 41 ✖

Hectare Squirrel Number ✖

Foraging ✖

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
68 68 -73.96942403275091 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.96942403275091 40.7755898126674)
184 184 -73.9553811810434 40.7970895007931 40E-AM-1014-02 40E AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9553811810434 40.7970895007931)
248 248 -73.9751729403694 40.774328412311796 10B-PM-1014-02 10B PM 10142018 2 Adult Gray White Gray+White   Above Ground   gingko tree by traffic light in front of Strawberry Fields 0 0 0 0 1   0 0 0 0 1 0 0 0 came over on tree to see me then disappeared POINT (-73.9751729403694 40.7743284123118)
485 485 -73.9677423154682 40.7728813350245 11I-AM-1012-02 11I AM 10122018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9677423154682 40.77288133502451)
508 508 -73.97469187620759 40.765523188367794 1G-AM-1006-02 01G AM 10062018 2 Juvenile Gray White Gray+White   Above Ground 30   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9746918762076 40.7655231883678)
624 624 -73.96130519573059 40.7909351393505 31D-AM-1014-02 31D AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Undergrowth 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9613051957306 40.7909351393505)
694 694 -73.9698032734704 40.7782343912417 16D-AM-1007-02 16D AM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9698032734704 40.7782343912417)
756 756 -73.9773079154219 40.7696506688861 4C-AM-1006-02 04C AM 10062018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9773079154219 40.7696506688861)
762 762 -73.96792913479558 40.7846973096665 23B-PM-1012-02 23B PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1 2/3 were chasing each other 0 0 0 0 1 0 0 1   POINT (-73.9679291347956 40.7846973096665)
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584106786233 40.7902777556926)
1187 1187 -73.97933344163779 40.7674142089209 1C-PM-1013-02 01C PM 10132018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 0 0   POINT (-73.9793334416378 40.7674142089209)
1256 1256 -73.9679457364586 40.7717350221981 10I-AM-1010-02 10I AM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9679457364586 40.7717350221981)
1283 1283 -73.9566785136491 40.7963368332834 39D-PM-1012-02 39D PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9566785136491 40.7963368332834)
1387 1387 -73.9697160572446 40.7711445570446 9H-AM-1006-02 09H AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.96971605724461 40.7711445570446)
1421 1421 -73.9595022290348 40.7831151330074 25I-PM-1007-02 25I PM 10072018 2 Adult Gray White Gray+White white belly Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 0 0 1   POINT (-73.9595022290348 40.783115133007406)
1482 1482 -73.95886101956991 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9588610195699 40.7945269936639)
1536 1536 -73.9746128451271 40.770095704670894 6E-PM-1010-02 06E PM 10102018 2 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9746128451271 40.7700957046709)
1712 1712 -73.9801899519657 40.7695777009264 3A-PM-1017-02 03A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9801899519657 40.7695777009264)
1717 1717 -73.97149520927671 40.7748063281815 12E-AM-1017-02 12E AM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714952092767 40.7748063281815)
1873 1873 -73.955754300682 40.795681399740005 38E-PM-1014-02 38E PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.955754300682 40.79568139974)
1978 1978 -73.9579689996645 40.794933848991704 37D-AM-1018-02 37D AM 10182018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579689996645 40.7949338489917)
2040 2040 -73.96481673340891 40.7811164976329 20F-PM-1007-02 20F PM 10072018 2 Adult Gray White Gray+White white on tail Ground Plane FALSE   0 0 0 1 1 digging one hole w/ determination 0 0 0 0 1 0 0 1   POINT (-73.96481673340891 40.7811164976329)
2072 2072 -73.9618709589382 40.7944969066792 35A-PM-1013-02 35A PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9618709589382 40.7944969066792)
2097 2097 -73.9773486521595 40.77084549021129 5C-PM-1010-02 05C PM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9773486521595 40.7708454902113)
2185 2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9707571364399 40.7758859812524)
2212 2212 -73.9801138983722 40.768572151563504 2B-PM-1013-02 02B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9801138983722 40.7685721515635)
2216 2216 -73.97351950184459 40.778714727971504 14A-AM-1014-02 14A AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 0 0   POINT (-73.9735195018446 40.7787147279715)
2326 2326 -73.9691692160865 40.7725330502929 10H-PM-1007-02 10H PM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9691692160865 40.7725330502929)
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)
2398 2398 -73.95871384837301 40.7963918051751 38C-PM-1014-02 38C PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.958713848373 40.7963918051751)
2405 2405 -73.9588361742943 40.791115225155 33E-PM-1012-02 33E PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9588361742943 40.791115225155)
2430 2430 -73.9569811285656 40.793091234605 35F-PM-1012-02 35F PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9569811285656 40.793091234605)
2458 2458 -73.969517504176 40.782074134429706 20B-PM-1013-02 20B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.969517504176 40.7820741344297)
2576 2576 -73.9751625910271 40.7671023412885 3F-AM-1006-02 03F AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9751625910271 40.7671023412885)
2594 2594 -73.9638812060405 40.7923714941429 32A-PM-1013-02 32A PM 10132018 2 ? Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9638812060405 40.792371494142905)
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)
2689 2689 -73.97041219894871 40.7824040236981 19A-PM-1013-02 19A PM 10132018 2 Adult Gray White Gray+White Looks very brown, not like English red squirrels Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9704121989487 40.7824040236981)
2819 2819 -73.95503500969379 40.797694218705004 41E-PM-1013-02 41E PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9550350096938 40.797694218705004)
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)
2887 2887 -73.964593167562 40.7780374890066 18H-PM-1014-02 18H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.964593167562 40.7780374890066)
3009 3009 -73.9675637870968 40.782388067172796 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9675637870968 40.7823880671728)

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