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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2170 | 2170 | -73.9678923667678 | 40.7819675626236 | 20C-PM-1018-05 | 20C | PM | 10182018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9678923667678 40.781967562623606) | |||||
2254 | 2254 | -73.9709991016317 | 40.7725756707748 | 10F-PM-1019-03 | 10F | PM | 10192018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head | Ground Plane | FALSE | Behind fence, grass | 0 | 0 | 0 | 1 | 0 | eating (nuts) | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (bad tourists w/ nuts) | POINT (-73.9709991016317 40.772575670774806) |
2590 | 2590 | -73.9568524771058 | 40.7974664985551 | 40C-PM-1006-06 | 40C | PM | 10062018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | By The Road | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9568524771058 40.7974664985551) | ||||
2636 | 2636 | -73.9700264128414 | 40.7692014637698 | 7I-PM-1013-01 | 07I | PM | 10132018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Bench | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9700264128414 40.7692014637698) | |||
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) | |||||
1024 | 1024 | -73.9521514669041 | 40.7949515182825 | 39H-PM-1013-03 | 39H | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | POINT (-73.9521514669041 40.7949515182825) | ||||
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) |
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 );