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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2907 | 2907 | -73.96852016269341 | 40.783329261225 | 21B-AM-1019-05 | 21B | AM | 10192018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9685201626934 40.783329261225) | |||||
2924 | 2924 | -73.9727230609785 | 40.7795341640894 | 16A-PM-1019-01 | 16A | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9727230609785 40.7795341640894) | |||||
2987 | 2987 | -73.9563724838337 | 40.7882504581015 | 31I-PM-1019-04 | 31I | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95637248383372 40.7882504581015) | |||||
2384 | 2384 | -73.9708564226824 | 40.7726219968014 | 10F-PM-1019-09 | 10F | PM | 10192018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Across Arbor path into hill w/ bushes | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9708564226824 40.7726219968014) | |||
209 | 209 | -73.97107601968679 | 40.7725506006789 | 10F-PM-1019-02 | 10F | PM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Ground Plane | FALSE | Behind fence, grass | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9710760196868 40.7725506006789) | ||
1026 | 1026 | -73.9710951149579 | 40.772501245008 | 10F-PM-1019-04 | 10F | PM | 10192018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | Behind fence, grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710951149579 40.772501245008) | ||||
99 | 99 | -73.9710541405708 | 40.772469160571795 | 10F-PM-1019-05 | 10F | PM | 10192018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Behind fence, tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710541405708 40.7724691605718) | ||||
2517 | 2517 | -73.9710221361528 | 40.7724939691584 | 10F-PM-1019-01 | 10F | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Above Ground | 2 | Behind fence, tree trunk | 0 | 0 | 1 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710221361528 40.7724939691584) | |
737 | 737 | -73.97111769994709 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | Different tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711176999471 40.7724278547281) | |||
2153 | 2153 | -73.9797122322834 | 40.767834758743504 | 1B-PM-1019-10 | 01B | PM | 10192018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | Dog chased up tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.97971223228342 40.7678347587435) | ||||
332 | 332 | -73.9705123624953 | 40.7731723757869 | 10F-PM-1019-11 | 10F | PM | 10192018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Grassy area | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9705123624953 40.7731723757869) | |||
1897 | 1897 | -73.97107389601 | 40.7723265810536 | 10F-PM-1019-07 | 10F | PM | 10192018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | Same tree (as #6) | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97107389601 40.7723265810536) | |||
1912 | 1912 | -73.9698064901149 | 40.7842538115839 | 21A-AM-1019-03 | 21A | AM | 10192018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Tree & ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698064901149 40.78425381158391) | ||||
2200 | 2200 | -73.96980803283041 | 40.7842252948542 | 21A-AM-1019-02 | 21A | AM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Tree & ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698080328304 40.7842252948542) | ||||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9803282698463 40.7680809889384) | |||
2662 | 2662 | -73.97086289336241 | 40.772563088678396 | 10F-PM-1019-08 | 10F | PM | 10192018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Under "Grape Arbor" structure behind Bandshell | 1 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9708628933624 40.7725630886784) | ||
2777 | 2777 | -73.98108436110859 | 40.768790549369896 | 2A-PM-1019-05 | 02A | PM | 10192018 | 5 | ? | Gray | Gray+ | Above Ground | 50 | in tall planetree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9810843611086 40.7687905493699) | ||||
1411 | 1411 | -73.98028400317591 | 40.7678599069819 | 1B-PM-1019-04 | 01B | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9802840031759 40.7678599069819) | |||
2865 | 2865 | -73.98028424040159 | 40.767825738497706 | 1B-PM-1019-03 | 01B | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.98028424040162 40.7678257384977) | |||
999 | 999 | -73.980948293606 | 40.76856888506279 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980948293606 40.7685688850628) | |||
2412 | 2412 | -73.98094464895641 | 40.768503216587895 | 2A-PM-1019-03 | 02A | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809446489564 40.7685032165879) | |||
1152 | 1152 | -73.9608399003798 | 40.7817704502248 | 23I-AM-1019-01 | 23I | AM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 18 | on a tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | eyed me warily,then went up the tree | POINT (-73.9608399003798 40.7817704502248) | ||
512 | 512 | -73.9586098170241 | 40.793965373389796 | 35D-AM-1019-01 | 35D | AM | 10192018 | 1 | + | Above Ground | on tree, blue jays gathering nearby | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9586098170241 40.7939653733898) |
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 );