This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63 | 63 | -73.9745630038492 | 40.7692602628745 | 5E-AM-1008-06 | 05E | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9745630038492 40.7692602628745) | ||||
| 1871 | 1871 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | oak tree at end of ramp from Chess House | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9748367344424 40.7693513000034) | |||
| 1495 | 1495 | -73.97351371783691 | 40.769109895294 | 5F-AM-1007-06 | 05F | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 2 | branch | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9735137178369 40.769109895294) | ||||
| 260 | 260 | -73.97843611793199 | 40.7724769242403 | 6A-AM-1006-06 | 06A | AM | 10062018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | tree | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.978436117932 40.7724769242403) | |||
| 763 | 763 | -73.9767455430709 | 40.7717866237826 | 6B-PM-1017-06 | 06B | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767455430709 40.7717866237826) | ||||
| 1099 | 1099 | -73.9761527947483 | 40.770960700253895 | 6C-AM-1007-06 | 06C | AM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | disappeared when jogger ran by | POINT (-73.9761527947483 40.7709607002539) | |||
| 58 | 58 | -73.9704082821356 | 40.7690280985956 | 6I-PM-1013-06 | 06I | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing with #5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9704082821356 40.7690280985956) | |||
| 1629 | 1629 | -73.9759428006237 | 40.7715081817329 | 7C-PM-1020-06 | 07C | PM | 10202018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9759428006237 40.7715081817329) | |||||
| 712 | 712 | -73.9736169886655 | 40.7714942196257 | 7E-AM-1006-06 | 07E | AM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9736169886655 40.7714942196257) | ||||
| 2765 | 2765 | -73.971525123573 | 40.770368535984204 | 7G-PM-1018-06 | 07G | PM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.971525123573 40.7703685359842) | |||
| 2274 | 2274 | -73.96980442184758 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | 0 | 0 | 0 | 1 | 0 | playing,interacting with #7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9698044218476 40.7697007833531) | ||
| 943 | 943 | -73.9773096718574 | 40.773805386248895 | 8A-AM-1013-06 | 08A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9773096718574 40.7738053862489) | ||||
| 1562 | 1562 | -73.97408468107099 | 40.7728197139621 | 8D-AM-1007-06 | 08D | AM | 10072018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.974084681071 40.7728197139621) | |||||
| 1644 | 1644 | -73.9734654671008 | 40.7715988711659 | 8E-PM-1008-06 | 08E | PM | 10082018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734654671008 40.7715988711659) | |||
| 171 | 171 | -73.971086588091 | 40.77197032351779 | 9G-PM-1007-06 | 09G | PM | 10072018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.971086588091 40.7719703235178) | |||||
| 2676 | 2676 | -73.9692849074642 | 40.7708755098145 | 9H-PM-1018-06 | 09H | PM | 10182018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9692849074642 40.7708755098145) |
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 );