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, Kuks, Tail flags, Approaches, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47 | 47 | -73.9640032826529 | 40.782030982544796 | 22F-PM-1014-06 | 22F | PM | 10142018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9640032826529 40.7820309825448) | |||||
81 | 81 | -73.9578237168359 | 40.7980959471034 | 40B-PM-1014-06 | 40B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9578237168359 40.7980959471034) | ||||
378 | 378 | -73.95848354168459 | 40.7978213396921 | 39B-PM-1014-06 | 39B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584835416846 40.7978213396921) | ||||
393 | 393 | -73.9577212629651 | 40.796552529672205 | 38C-PM-1014-06 | 38C | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9577212629651 40.7965525296722) | ||||
492 | 492 | -73.97030108562241 | 40.7701983575511 | 8H-PM-1014-06 | 08H | PM | 10142018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703010856224 40.7701983575511) | |||||
494 | 494 | -73.958837574505 | 40.7985003987784 | 40A-PM-1014-06 | 40A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958837574505 40.7985003987784) | ||||
501 | 501 | -73.9708798496132 | 40.7761532088521 | 13D-AM-1014-06 | 13D | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9708798496132 40.7761532088521) | ||||
576 | 576 | -73.96220476777009 | 40.7945126358465 | 35A-AM-1014-06 | 35A | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622047677701 40.7945126358465) | ||||
594 | 594 | -73.9727488640736 | 40.7781916780621 | 14B-PM-1014-06 | 14B | PM | 10142018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | watching me | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | skittish | POINT (-73.9727488640736 40.7781916780621) | ||
726 | 726 | -73.973305698325 | 40.778382331129606 | 14A-PM-1014-06 | 14A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.973305698325 40.7783823311296) | ||||
818 | 818 | -73.96087574240521 | 40.790668650465705 | 31D-AM-1014-06 | 31D | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9608757424052 40.7906686504657) | ||||
967 | 967 | -73.9683994064731 | 40.7710765500799 | 9I-AM-1014-06 | 09I | AM | 10142018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96839940647311 40.7710765500799) | ||||
1128 | 1128 | -73.9638599044346 | 40.7809288795308 | 21G-AM-1014-06 | 21G | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9638599044346 40.7809288795308) | ||||
1194 | 1194 | -73.96874625660729 | 40.783898987005 | 22B-PM-1014-06 | 22B | PM | 10142018 | 6 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687462566073 40.783898987005) | ||||
1314 | 1314 | -73.980919134781 | 40.7683772453336 | 1A-PM-1014-06 | 01A | PM | 10142018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.980919134781 40.7683772453336) | |||||
1424 | 1424 | -73.9709722223794 | 40.7767329646325 | 14D-AM-1014-06 | 14D | AM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9709722223794 40.7767329646325) | ||||
1694 | 1694 | -73.97301963428741 | 40.766022437401 | 3H-PM-1014-06 | 03H | PM | 10142018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730196342874 40.766022437401) | |||||
1803 | 1803 | -73.9588076804698 | 40.7912942607296 | 33E-AM-1014-06 | 33E | AM | 10142018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588076804698 40.7912942607296) | ||||
1870 | 1870 | -73.9542118614769 | 40.7939171395463 | 37G-AM-1014-06 | 37G | AM | 10142018 | 6 | Adult | Gray | White | Gray+White | White tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95421186147692 40.7939171395463) | |||
1964 | 1964 | -73.9622859117854 | 40.788616918696604 | 29D-AM-1014-06 | 29D | AM | 10142018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622859117854 40.7886169186966) | |||||
2052 | 2052 | -73.97464934414141 | 40.7750478734868 | 11B-PM-1014-06 | 11B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 0 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9746493441414 40.7750478734868) | |||
2276 | 2276 | -73.9611985783336 | 40.791604823372005 | 32C-AM-1014-06 | 32C | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9611985783336 40.791604823372) | ||||
2281 | 2281 | -73.96915208260279 | 40.77171040377829 | 10H-AM-1014-06 | 10H | AM | 10142018 | 6 | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9691520826028 40.7717104037783) | ||||||
2410 | 2410 | -73.97551920769341 | 40.7664413570796 | 2F-PM-1014-06 | 02F | PM | 10142018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755192076934 40.7664413570796) | ||||
2844 | 2844 | -73.9578840941242 | 40.7955586232429 | 37D-PM-1014-06 | 37D | PM | 10142018 | 6 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9578840941242 40.7955586232429) | |||||
2892 | 2892 | -73.9688070760806 | 40.777968829417205 | 16E-AM-1014-06 | 16E | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9688070760806 40.777968829417205) | ||||
2980 | 2980 | -73.97164145863809 | 40.771760114722 | 9F-PM-1014-06 | 09F | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | running (from birds) | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9716414586381 40.771760114722) |
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 );