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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1092 | 1092 | -73.9711319254625 | 40.7760324859879 | 13D-PM-1018-12 | 13D | PM | 10182018 | 12 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711319254625 40.776032485987905) | ||||
843 | 843 | -73.97140896474309 | 40.7767916587915 | 14D-AM-1014-12 | 14D | AM | 10142018 | 12 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9714089647431 40.7767916587915) | ||||
1386 | 1386 | -73.9730085729495 | 40.770893357032705 | 7F-AM-1008-12 | 07F | AM | 10082018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730085729495 40.7708933570327) | |||||
2547 | 2547 | -73.9743393747021 | 40.767634679832504 | 3F-AM-1006-12 | 03F | AM | 10062018 | 12 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9743393747021 40.7676346798325) | ||||
974 | 974 | -73.9753744539307 | 40.7671162211032 | 2F-PM-1014-12 | 02F | PM | 10142018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97537445393071 40.7671162211032) | |||||
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | 1 | 0 | 0 | 0 | 0 | was chased by # 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763236949008 40.7686815615335) | |||
1158 | 1158 | -73.97638947595429 | 40.7705523372364 | 5C-PM-1010-12 | 05C | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9763894759543 40.7705523372364) | ||||
514 | 514 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768357173861 40.7683813358343) | ||||
2919 | 2919 | -73.9768563402344 | 40.7744487310786 | 9A-AM-1013-12 | 09A | AM | 10132018 | 12 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | foot of tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768563402344 40.7744487310786) | |||
969 | 969 | -73.97735293684991 | 40.772875068569896 | 7B-AM-1008-12 | 07B | AM | 10082018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9773529368499 40.7728750685699) | |||||
1567 | 1567 | -73.97744073625871 | 40.7698056129554 | 4C-PM-1010-12 | 04C | PM | 10102018 | 12 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9774407362587 40.7698056129554) | ||||
1485 | 1485 | -73.9791085350047 | 40.76770253426329 | 2C-PM-1013-12 | 02C | PM | 10132018 | 12 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9791085350047 40.7677025342633) | ||||
392 | 392 | -73.98023761310341 | 40.768070751662705 | 1B-AM-1012-12 | 01B | AM | 10122018 | 12 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802376131034 40.7680707516627) |
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 );