This data as json, CSV (advanced)
Suggested facets: Unique Squirrel ID, Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Eating, Foraging, Kuks, Quaas, Tail twitches, Indifferent
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61 | 61 | -73.9797084866613 | 40.7698885241349 | 3A-PM-1017-06 | 03A | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9797084866613 40.7698885241349) | ||||
522 | 522 | -73.97738211356109 | 40.769045349438294 | 4C-PM-1010-06 | 04C | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | behind playground benches | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9773821135611 40.7690453494383) | |||
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) | ||||
988 | 988 | -73.97870401924729 | 40.767901024728104 | 2C-AM-1010-06 | 02C | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | stood still & watched me then jumped on a fence and ran away | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9787040192473 40.7679010247281) | ||||
1077 | 1077 | -73.9541837143178 | 40.7944340477396 | 38G-PM-1020-06 | 38G | PM | 10202018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9541837143178 40.7944340477396) | ||||
1162 | 1162 | -73.95685442708809 | 40.7972517274475 | 39D-AM-1008-06 | 39D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 3 | on rock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9568544270881 40.7972517274475) | ||||
1273 | 1273 | -73.95589438800509 | 40.7971535141896 | 40D-PM-1013-06 | 40D | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9558943880051 40.7971535141896) | ||||
1290 | 1290 | -73.96681408040659 | 40.77681001473329 | 15G-AM-1008-06 | 15G | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9668140804066 40.7768100147333) | ||||
1520 | 1520 | -73.968021326951 | 40.7778807692445 | 16F-PM-1013-06 | 16F | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Big rock in meadow | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.968021326951 40.7778807692445) | |||
1540 | 1540 | -73.957710975899 | 40.79840556140471 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.957710975899 40.7984055614047) | ||||
1674 | 1674 | -73.9589698681439 | 40.7906520520417 | 32E-PM-1017-06 | 32E | PM | 10172018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9589698681439 40.7906520520417) | ||||
1699 | 1699 | -73.9706968708903 | 40.7821499135828 | 19A-PM-1013-06 | 19A | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9706968708903 40.7821499135828) | ||||
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) | ||||
2079 | 2079 | -73.96430251719141 | 40.790570391517 | 30B-PM-1019-06 | 30B | PM | 10192018 | 6 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9643025171914 40.790570391517) | ||||
2168 | 2168 | -73.95823634371351 | 40.7987752300505 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9582363437135 40.7987752300505) | ||||
2206 | 2206 | -73.95944460183459 | 40.7917800352042 | 33D-AM-1017-06 | 33D | AM | 10172018 | 6 | Adult | Black | Black+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (ran into hole in tree trunk) | POINT (-73.9594446018346 40.7917800352042) | ||||
2239 | 2239 | -73.9668922014699 | 40.7823535653774 | 21D-AM-1008-06 | 21D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9668922014699 40.7823535653774) | |||||
2274 | 2274 | -73.96980442184758 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | 0 | 0 | 0 | 1 | 0 | playing,interacting with #7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9698044218476 40.7697007833531) | ||
2374 | 2374 | -73.9551370586201 | 40.7946465469021 | 38F-AM-1018-06 | 38F | AM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hopped away | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.95513705862011 40.7946465469021) | |||
2395 | 2395 | -73.9729603550254 | 40.7660215710657 | 3H-AM-1008-06 | 03H | AM | 10082018 | 6 | Adult | Black | Black+ | beauty! | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9729603550254 40.7660215710657) | ||||
2519 | 2519 | -73.9589475065438 | 40.7934846881536 | 35D-PM-1013-06 | 35D | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9589475065438 40.7934846881536) | ||||
2577 | 2577 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 10182018 | 6 | Adult | Gray | Gray+ | Above Ground | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9597048490102 40.7955846466241) | |||||
2720 | 2720 | -73.9566300789162 | 40.7993692120774 | 42C-PM-1013-06 | 42C | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Between park and main drag | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9566300789162 40.7993692120774) | |||
2742 | 2742 | -73.96280415779341 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 10122018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9628041577934 40.78841801560551) | ||||
2815 | 2815 | -73.97473113123941 | 40.76773197250439 | 3F-PM-1013-06 | 03F | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 19 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97473113123941 40.7677319725044) | ||||
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) |
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 );