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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1264 | 1264 | -73.97853537753821 | 40.7674923683184 | 2C-PM-1013-01 | 02C | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785353775382 40.7674923683184) | ||||
1588 | 1588 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693209851947 40.7707450042769) | ||||
1835 | 1835 | -73.9562068537632 | 40.796733285323796 | 39D-AM-1008-01 | 39D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562068537632 40.7967332853238) | |||||
1997 | 1997 | -73.97146376830841 | 40.776898456156296 | 14D-PM-1019-01 | 14D | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714637683084 40.7768984561563) | |||||
2118 | 2118 | -73.958369699409 | 40.79024566683321 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958369699409 40.7902456668332) | |||||
2182 | 2182 | -73.9573656523498 | 40.7979754563974 | 40C-AM-1017-01 | 40C | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#2) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9573656523498 40.7979754563974) | ||||
2313 | 2313 | -73.9646174034945 | 40.778128752826206 | 18H-AM-1018-01 | 18H | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Running from one tree to the other | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9646174034945 40.7781287528262) | ||
2351 | 2351 | -73.97458184501092 | 40.765449887362706 | 1G-AM-1006-01 | 01G | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745818450109 40.7654498873627) | |||||
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) | ||||
2466 | 2466 | -73.95994199262991 | 40.797277472881106 | 38A-AM-1019-01 | 38A | AM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599419926299 40.7972774728811) | |||||
2652 | 2652 | -73.96205425147491 | 40.794373172213795 | 34A-AM-1012-01 | 34A | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9620542514749 40.7943731722138) | |||
2861 | 2861 | -73.9720102361126 | 40.7692143930301 | 6G-PM-1020-01 | 06G | PM | 10202018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9720102361126 40.7692143930301) | |||||
2872 | 2872 | -73.96153964579959 | 40.792359436678296 | 33C-AM-1012-01 | 33C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along tail & back | Above Ground | 20 | tree branches | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615396457996 40.7923594366783) | ||
751 | 751 | -73.9683479943823 | 40.7815827298303 | 20C-PM-1018-01 | 20C | PM | 10182018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9683479943823 40.7815827298303) | |||||
1004 | 1004 | -73.9670850805619 | 40.7833747810387 | 22C-PM-1006-01 | 22C | PM | 10062018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | for food | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9670850805619 40.7833747810387) |
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 );