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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2772 | 2772 | -73.9677368646039 | 40.782155096483706 | 20C-PM-1018-06 | 20C | PM | 10182018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.96773686460392 40.782155096483706) | |||||
| 53 | 53 | -73.95849706432129 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9584970643213 40.7982886348696) | ||||
| 482 | 482 | -73.97217978245759 | 40.7801213843628 | 16A-PM-1019-07 | 16A | PM | 10192018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | approaches (very friendly) | POINT (-73.9721797824576 40.7801213843628) | |||
| 1196 | 1196 | -73.95801114962751 | 40.7985365971474 | 40B-AM-1019-05 | 40B | AM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9580111496275 40.7985365971474) | ||||
| 1392 | 1392 | -73.96480906981759 | 40.7903882097837 | 29A-PM-1019-03 | 29A | PM | 10192018 | 3 | Juvenile | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ran from,but now approaching. kind of weirding me out. | POINT (-73.9648090698176 40.7903882097837) | |||
| 1591 | 1591 | -73.95762233900821 | 40.79797466396471 | 40B-AM-1019-04 | 40B | AM | 10192018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9576223390082 40.79797466396471) | ||||
| 2117 | 2117 | -73.9597192455543 | 40.7973316178661 | 38A-AM-1019-03 | 38A | AM | 10192018 | 3 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | stood on back legs | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | POINT (-73.9597192455543 40.7973316178661) | ||
| 2685 | 2685 | -73.9601851468038 | 40.7968698151479 | 38A-AM-1019-05 | 38A | AM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon head, White belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | standing on back legs | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9601851468038 40.7968698151479) | ||
| 2131 | 2131 | -73.9752225195115 | 40.7703747669865 | 6D-PM-1020-05 | 06D | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9752225195115 40.7703747669865) | |||||
| 2399 | 2399 | -73.9583762071264 | 40.7852226065643 | 27I-PM-1020-03 | 27I | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | begging for food; on hind legs | POINT (-73.9583762071264 40.7852226065643) | |||
| 2453 | 2453 | -73.9756105226696 | 40.7696531972655 | 5D-AM-1020-03 | 05D | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9756105226696 40.7696531972655) |
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 );