This data as json, CSV (advanced)
Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180 | 180 | -73.96908283251791 | 40.781803817227505 | 19C-PM-1018-04 | 19C | PM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9690828325179 40.7818038172275) | ||||
509 | 509 | -73.9714289592392 | 40.775067070209296 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9714289592392 40.7750670702093) | |||||
627 | 627 | -73.97637911214379 | 40.770281512254 | 5D-PM-1018-04 | 05D | PM | 10182018 | 4 | Adult | Gray | White | Gray+White | Partial missing tail | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (dog chasing) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763791121438 40.770281512254) | ||
631 | 631 | -73.95488778301359 | 40.795015748910295 | 38F-AM-1018-04 | 38F | AM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95488778301362 40.7950157489103) | ||||
870 | 870 | -73.97187204036571 | 40.770233505633705 | 7G-PM-1018-04 | 07G | PM | 10182018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9718720403657 40.7702335056337) | ||||
1013 | 1013 | -73.96955389629501 | 40.77098849292771 | 9H-PM-1018-04 | 09H | PM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969553896295 40.7709884929277) | |||||
1053 | 1053 | -73.96858597054859 | 40.784880506532204 | 23A-AM-1018-04 | 23A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | Tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685859705486 40.7848805065322) | ||||
1087 | 1087 | -73.9679955831115 | 40.7818431607916 | 20C-PM-1018-04 | 20C | PM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9679955831115 40.7818431607916) | |||||
1356 | 1356 | -73.9534910562766 | 40.7935774443789 | 37H-AM-1018-04 | 37H | AM | 10182018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | was with a lot of robins | POINT (-73.9534910562766 40.7935774443789) | |||
1463 | 1463 | -73.96300972763659 | 40.7936658446251 | 33A-PM-1018-04 | 33A | PM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9630097276366 40.79366584462511) | ||||
1509 | 1509 | -73.9556450015702 | 40.796718805800204 | 39E-AM-1018-04 | 39E | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9556450015702 40.7967188058002) | |||||
1518 | 1518 | -73.9632265832593 | 40.7816914475461 | 22G-AM-1018-04 | 22G | AM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632265832593 40.78169144754611) | ||||
1541 | 1541 | -73.9711617997772 | 40.7761212878075 | 13D-PM-1018-04 | 13D | PM | 10182018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711617997772 40.7761212878075) | |||
1655 | 1655 | -73.96957001271599 | 40.7816501516863 | 19B-PM-1018-04 | 19B | PM | 10182018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969570012716 40.7816501516863) | |||
1736 | 1736 | -73.9743873549635 | 40.7745426051392 | 10C-AM-1018-04 | 10C | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9743873549635 40.7745426051392) | |||||
1828 | 1828 | -73.9682965197661 | 40.780537896388296 | 18D-AM-1018-04 | 18D | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9682965197661 40.7805378963883) | |||||
2018 | 2018 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 10182018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9697924026634 40.7803611152023) | |||||
2156 | 2156 | -73.96503878480009 | 40.7814134438394 | 21F-AM-1018-04 | 21F | AM | 10182018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9650387848001 40.7814134438394) | ||||
2712 | 2712 | -73.9682760864462 | 40.778072756941704 | 16E-PM-1018-04 | 16E | PM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682760864462 40.7780727569417) | |||||
2756 | 2756 | -73.9787312025627 | 40.7701071405918 | 4B-PM-1018-04 | 04B | PM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9787312025627 40.7701071405918) | |||||
2884 | 2884 | -73.9598378495787 | 40.7956843021662 | 37B-AM-1018-04 | 37B | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9598378495787 40.7956843021662) | |||||
2966 | 2966 | -73.9630596103391 | 40.792572062055605 | 32A-AM-1018-04 | 32A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | Base of tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630596103391 40.7925720620556) | ||||
3014 | 3014 | -73.9665572004288 | 40.780434754830296 | 19E-PM-1018-04 | 19E | PM | 10182018 | 4 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665572004288 40.7804347548303) | ||||||
1704 | 1704 | -73.9624052832372 | 40.7809656348254 | 21H-PM-1018-04 | 21H | PM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9624052832372 40.7809656348254) | ||||
1725 | 1725 | -73.96574800660741 | 40.7753465489231 | 14I-PM-1018-04 | 14I | PM | 10182018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9657480066074 40.7753465489231) |
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 );