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, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
205 | 205 | -73.9564724104048 | 40.7936055508162 | 36F-PM-1012-04 | 36F | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9564724104048 40.7936055508162) | ||||
221 | 221 | -73.9665709146738 | 40.7839384318554 | 22D-PM-1012-04 | 22D | PM | 10122018 | 4 | Adult | Gray | Black, White | Gray+Black, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665709146738 40.7839384318554) | ||||
229 | 229 | -73.97241624297101 | 40.7714260236636 | 8F-PM-1012-04 | 08F | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.972416242971 40.7714260236636) | |||||
490 | 490 | -73.978426472499 | 40.771904101844 | 6A-PM-1012-04 | 06A | PM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.978426472499 40.771904101844) | ||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9624538733037 40.7883829851518) | ||||
889 | 889 | -73.96810426129379 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681042612938 40.772331431865) | |||||
1031 | 1031 | -73.9766593636657 | 40.7735708178842 | 8B-PM-1012-04 | 08B | PM | 10122018 | 4 | 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.9766593636657 40.7735708178842) | ||||
1460 | 1460 | -73.97143299793049 | 40.7741873388945 | 11E-PM-1012-04 | 11E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714329979305 40.7741873388945) | ||||
1462 | 1462 | -73.9584064203778 | 40.7912272455454 | 33F-PM-1012-04 | 33F | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9584064203778 40.7912272455454) | ||||
1475 | 1475 | -73.96867781674841 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 10122018 | 4 | + | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.96867781674841 40.7765625256946) | |||||||||
1547 | 1547 | -73.958939037549 | 40.7913193931203 | 33E-PM-1012-04 | 33E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958939037549 40.7913193931203) | |||
1690 | 1690 | -73.96052295327 | 40.7934359372871 | 34C-PM-1012-04 | 34C | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96052295327 40.7934359372871) | |||||
1710 | 1710 | -73.95454386561221 | 40.7902168635009 | 34I-AM-1012-04 | 34I | AM | 10122018 | 4 | 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.9545438656122 40.7902168635009) | ||||
1962 | 1962 | -73.9647318357023 | 40.7760936175332 | 15I-PM-1012-04 | 15I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9647318357023 40.7760936175332) | |||||
2113 | 2113 | -73.95829048146521 | 40.790591574956395 | 32F-AM-1012-04 | 32F | AM | 10122018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9582904814652 40.7905915749564) | |||||
2232 | 2232 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 10122018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | on tree trunk (descending from height of ~10 ft) | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95662777215811 40.7966674587803) | |||
2277 | 2277 | -73.95385121459 | 40.7981257651433 | 42E-PM-1012-04 | 42E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95385121459 40.7981257651433) | ||||
2309 | 2309 | -73.966824257293 | 40.775340537786896 | 14H-PM-1012-04 | 14H | PM | 10122018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.966824257293 40.7753405377869) | ||||
2367 | 2367 | -73.9681671864047 | 40.7753770538635 | 14G-AM-1012-04 | 14G | AM | 10122018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9681671864047 40.7753770538635) | ||||
2390 | 2390 | -73.9680741975294 | 40.7847036778165 | 23B-PM-1012-04 | 23B | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | watching me - didn't move | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9680741975294 40.7847036778165) | |||
2447 | 2447 | -73.9589670987899 | 40.795212703928705 | 37C-AM-1012-04 | 37C | AM | 10122018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon flanks | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589670987899 40.7952127039287) | |||
2745 | 2745 | -73.97296259363002 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 10122018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2 | on ledge | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97296259363 40.7652601851275) | ||
2821 | 2821 | -73.97545365660129 | 40.769860491877104 | 5E-PM-1012-04 | 05E | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9754536566013 40.7698604918771) | ||||
2981 | 2981 | -73.9800094828465 | 40.7677782585639 | 1B-AM-1012-04 | 01B | AM | 10122018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800094828465 40.7677782585639) | |||||
2988 | 2988 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766342759486 40.7687518380873) | ||||
3000 | 3000 | -73.9688293382172 | 40.7738958027568 | 12G-AM-1012-04 | 12G | AM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9688293382172 40.773895802756805) |
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 );