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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1366 | 1366 | -73.97115821991021 | 40.7783674409485 | 15C-PM-1017-05 | 15C | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9711582199102 40.7783674409485) | ||||
| 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) | ||||
| 1661 | 1661 | -73.974519308015 | 40.7691228794395 | 5E-AM-1008-02 | 05E | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | trellis | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.974519308015 40.7691228794395) | |||
| 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) | ||||
| 1947 | 1947 | -73.97471754195459 | 40.769282003087795 | 5E-PM-1012-05 | 05E | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | begging | POINT (-73.9747175419546 40.7692820030878) | |||
| 2998 | 2998 | -73.97520792474191 | 40.775537697900205 | 11B-AM-1007-01 | 11B | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9752079247419 40.7755376979002) | ||||
| 1756 | 1756 | -73.9755041276839 | 40.7678213857557 | 3F-AM-1006-13 | 03F | AM | 10062018 | 13 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9755041276839 40.7678213857557) | ||||
| 1623 | 1623 | -73.97701191330229 | 40.773294909000505 | 8A-AM-1013-04 | 08A | AM | 10132018 | 4 | Juvenile | + | Above Ground | 4 | fence | 1 | 1 | 0 | 1 | 1 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770119133023 40.7732949090005) | ||||
| 222 | 222 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | ||||
| 2044 | 2044 | -73.97715523261991 | 40.7706917595308 | 5C-AM-1006-01 | 05C | AM | 10062018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | POINT (-73.9771552326199 40.7706917595308) | ||||
| 2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9772239251936 40.7731716665766) | ||||
| 257 | 257 | -73.9773317054464 | 40.7684035996758 | 3D-AM-1006-03 | 03D | AM | 10062018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | on top [of] a big rock/boulder in the area | 1 | 0 | 1 | 0 | 0 | climbing (rock) | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (slightly),wary of humans | POINT (-73.9773317054464 40.76840359967581) |
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 );