2018_Central_Park_Squirrel_Census_-_Squirrel_Data

37 rows where Date = 10142018, Hectare Squirrel Number = 1 and Shift = "PM" sorted by longitude

✎ View and edit SQL

This data as json, CSV (advanced)

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

Moans ✖

  • 0 36
  • 1 1

Shift ✖

Hectare Squirrel Number ✖

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
2387 2387 -73.98085173247209 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9808517324721 40.7683154647217)
643 643 -73.976730206737 40.773709213913996 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   1 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)
2312 2312 -73.97658670292259 40.7674304266107 2E-PM-1014-01 02E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9765867029226 40.7674304266107)
431 431 -73.97574360194321 40.774606436322706 10B-PM-1014-01 10B PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE on lawn in front of a tree 0 0 0 0 1   0 0 0 0 1 0 0 0 stay on ground but went to other side of tree to hide from a dog POINT (-73.9757436019432 40.7746064363227)
35 35 -73.97569760767071 40.775389733191794 10A-PM-1014-01 10A PM 10142018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray & White selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. Ground Plane FALSE in b/w trees 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756976076707 40.7753897331918)
1427 1427 -73.9755321998542 40.766831157600706 2F-PM-1014-01 02F PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.97553219985421 40.7668311576007)
1206 1206 -73.97487092063541 40.77608025411 11B-PM-1014-01 11B PM 10142018 1 Adult Gray   Gray+ Fat! Above Ground 10   0 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9748709206354 40.77608025411)
1930 1930 -73.9744279648953 40.7777760612191 13A-PM-1014-01 13A PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744279648953 40.7777760612191)
236 236 -73.9737266070919 40.7786338379896 14A-PM-1014-01 14A PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9737266070919 40.7786338379896)
1490 1490 -73.9727405679487 40.778267755448205 14B-PM-1014-01 14B PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9727405679487 40.7782677554482)
2054 2054 -73.97263812347471 40.7752694815985 12D-PM-1014-01 12D PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9726381234747 40.7752694815985)
2070 2070 -73.9725700261894 40.7668793330427 3H-PM-1014-01 03H PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE under a parked car 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9725700261894 40.7668793330427)
1015 1015 -73.9720347089273 40.7727750272024 9E-PM-1014-01 09E PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Gathering/digging in grassy area b/w trees 0 0 0 0 1 looked like it was smelling/digging in the ground 0 0 0 0 1 0 1 0 indifferent (was in a grassy area with no humans nearby) POINT (-73.9720347089273 40.7727750272024)
1965 1965 -73.9719359643975 40.772699885583 9F-PM-1014-01 09F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 he is fed every day by a woman who calls him "chiquita"! he ran right up to her. POINT (-73.9719359643975 40.772699885583)
2580 2580 -73.970795746101 40.77047272122989 8H-PM-1014-01 08H PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970795746101 40.7704727212299)
1980 1980 -73.9686635017966 40.78431767328279 22B-PM-1014-01 22B PM 10142018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.96866350179661 40.7843176732828)
1360 1360 -73.96749306684309 40.781351011968 20D-PM-1014-01 20D PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.96749306684312 40.781351011968)
2443 2443 -73.96670731869591 40.7840581361598 23C-PM-1014-01 23C PM 10142018 1 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.96670731869591 40.7840581361598)
2920 2920 -73.9657391918196 40.776502470347 16H-PM-1014-01 16H PM 10142018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657391918196 40.776502470347)
1271 1271 -73.96567502325959 40.7833002587016 22E-PM-1014-01 22E PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9656750232596 40.7833002587016)
2507 2507 -73.964868521585 40.7821064183815 22F-PM-1014-01 22F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.964868521585 40.7821064183815)
1667 1667 -73.96459890035891 40.778215745915496 18H-PM-1014-01 18H PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9645989003589 40.7782157459155)
840 840 -73.9598084794625 40.797616543450204 39A-PM-1014-01 39A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598084794625 40.7976165434502)
2016 2016 -73.9589492240754 40.798901118974 40A-PM-1014-01 40A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0   0 0 0 0 1 0 1 0 stared & then went back up tree—then ran to different tree POINT (-73.9589492240754 40.798901118974)
2251 2251 -73.9587678566254 40.7962656030995 38C-PM-1014-01 38C PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9587678566254 40.7962656030995)
845 845 -73.9582850206205 40.7978975855555 39B-PM-1014-01 39B PM 10142018 1 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9582850206205 40.7978975855555)
3010 3010 -73.9580906814132 40.7948404060484 37D-PM-1014-01 37D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1 eyes from a safe distance POINT (-73.9580906814132 40.7948404060484)
2316 2316 -73.957697363244 40.7997576909042 42A-PM-1014-01 42A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 up on hind legs looking around 0 0 0 0 0 0 0 0 came to about 10' away then ran off POINT (-73.957697363244 40.7997576909042)
102 102 -73.95759861613641 40.799368134968 41B-PM-1014-01 41B PM 10142018 1 Adult Gray White Gray+White   Above Ground 25 Climbing tree 0 0 1 0 0 climbing (tree) 0 0 0 0 0 0 0 1   POINT (-73.9575986161364 40.799368134968)
560 560 -73.9573057686241 40.7985734105729 40B-PM-1014-01 40B PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9573057686241 40.7985734105729)
1151 1151 -73.9557602499712 40.7956452424385 38E-PM-1014-01 38E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9557602499712 40.7956452424385)
581 581 -73.9556218199258 40.7980460204041 41D-PM-1014-01 41D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 digging,drinking 0 0 0 0 0 0 0 1   POINT (-73.9556218199258 40.7980460204041)
177 177 -73.9554432393295 40.794566905444896 37F-PM-1014-01 37F PM 10142018 1   Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9554432393295 40.7945669054449)
1183 1183 -73.9525699067954 40.7937125788106 38I-PM-1014-01 38I PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE on the lawn East of the fountain 0 0 0 0 0 scampering thru the grass! 0 0 0 0 1 0 0 1   POINT (-73.9525699067954 40.7937125788106)
601 601 -73.9522291603405 40.7976985385835 42G-PM-1014-01 42G PM 10142018 1 Adult Gray White Gray+White   Above Ground 8   0 0 1 0 1   0 0 1 0 0 0 0 1   POINT (-73.9522291603405 40.7976985385835)
2244 2244 -73.9509628195532 40.797777567417796 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9509628195532 40.7977775674178)
2696 2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9501457233643 40.797094356558)

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