This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Other Activities, Indifferent, Runs from
Combination of Primary and Highlight Color ✖
Highlight Fur Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60 | 60 | -73.9768674812942 | 40.7735232648872 | 8B-PM-1012-02 | 08B | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | hiding in bushes | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9768674812942 40.7735232648872) | |||
270 | 270 | -73.9767191629692 | 40.7730786298701 | 8B-PM-1012-03 | 08B | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9767191629692 40.7730786298701) | ||||
344 | 344 | -73.9759432151552 | 40.7733240612552 | 8B-PM-1012-06 | 08B | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | on a bench | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9759432151552 40.7733240612552) | |||
406 | 406 | -73.97663549671971 | 40.7734575166319 | 8B-AM-1007-09 | 08B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766354967197 40.7734575166319) | ||||
424 | 424 | -73.9756557086441 | 40.773296289823996 | 8B-PM-1012-08 | 08B | PM | 10122018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756557086441 40.773296289824) | ||||
733 | 733 | -73.9764397550289 | 40.7737004557104 | 8B-AM-1007-01 | 08B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9764397550289 40.7737004557104) | ||||
1031 | 1031 | -73.9766593636657 | 40.7735708178842 | 8B-PM-1012-04 | 08B | PM | 10122018 | 4 | 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.9766593636657 40.7735708178842) | ||||
1217 | 1217 | -73.9764850086767 | 40.7737340720562 | 8B-AM-1007-07 | 08B | AM | 10072018 | 7 | Juvenile | Gray | Black | Gray+Black | Above Ground | 8 | 0 | 0 | 0 | 1 | 0 | holding nut | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9764850086767 40.7737340720562) | |||
1498 | 1498 | -73.9765064169087 | 40.7737211426714 | 8B-AM-1007-06 | 08B | AM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9765064169087 40.7737211426714) | ||||
1546 | 1546 | -73.976422624924 | 40.7735818387346 | 8B-AM-1007-08 | 08B | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 0 | 1 | 0 | holding nut | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.976422624924 40.7735818387346) | ||||
1729 | 1729 | -73.97650461090191 | 40.7736674124746 | 8B-AM-1007-04 | 08B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765046109019 40.7736674124746) | |||||
1796 | 1796 | -73.9765355395622 | 40.7735653237366 | 8B-AM-1007-03 | 08B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97653553956222 40.7735653237366) | |||||
1850 | 1850 | -73.975809362521 | 40.773470273783495 | 8B-PM-1012-09 | 08B | PM | 10122018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.975809362521 40.7734702737835) | ||||
1899 | 1899 | -73.9764314091366 | 40.773645805795205 | 8B-AM-1007-02 | 08B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9764314091366 40.773645805795205) | |||||
2317 | 2317 | -73.97673696861709 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767369686171 40.7735074437085) | ||||
2486 | 2486 | -73.9766317094163 | 40.7734230472026 | 8B-AM-1007-05 | 08B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766317094163 40.7734230472026) | |||||
2673 | 2673 | -73.9768867959365 | 40.7734803954589 | 8B-PM-1012-01 | 08B | PM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9768867959365 40.7734803954589) | ||||
2986 | 2986 | -73.97565337638129 | 40.7733537881363 | 8B-PM-1012-07 | 08B | PM | 10122018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756533763813 40.7733537881363) |
JSON shape: default, array, newline-delimited
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 );