This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103 | 103 | -73.96077013704429 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 10132018 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 0 | 1 | 0 | 0 | 0 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9607701370443 40.7955418990855) | ||||
322 | 322 | -73.9546042927016 | 40.7898133734952 | 33I-PM-1006-07 | 33I | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9546042927016 40.7898133734952) | |||||
379 | 379 | -73.9606817053484 | 40.7917320450401 | 32D-PM-1006-07 | 32D | PM | 10062018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9606817053484 40.7917320450401) | ||||
407 | 407 | -73.9787658435198 | 40.768941976539296 | 3B-PM-1007-07 | 03B | PM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating loudly <- peanuts w/ shells | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787658435198 40.7689419765393) | |||
434 | 434 | -73.96766397404859 | 40.7745369616499 | 13H-PM-1010-07 | 13H | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9676639740486 40.7745369616499) | |||||
722 | 722 | -73.9745953710328 | 40.7728284025195 | 8D-AM-1007-07 | 08D | AM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9745953710328 40.7728284025195) | ||||
761 | 761 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 10132018 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975062146111 40.7723417173451) | |||||
772 | 772 | -73.95841884610591 | 40.7913241048498 | 33E-PM-1012-07 | 33E | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9584188461059 40.7913241048498) | ||||
812 | 812 | -73.9699675160516 | 40.7773012642758 | 15E-PM-1008-07 | 15E | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699675160516 40.7773012642758) | |||||
879 | 879 | -73.9735120882106 | 40.7715915415169 | 8E-PM-1008-07 | 08E | PM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9735120882106 40.7715915415169) | |||
980 | 980 | -73.9709817796369 | 40.7773554311586 | 14D-PM-1019-07 | 14D | PM | 10192018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9709817796369 40.7773554311586) | |||||
1059 | 1059 | -73.97494575169209 | 40.7676712372245 | 3F-PM-1013-07 | 03F | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9749457516921 40.7676712372245) | ||||
1142 | 1142 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 10082018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765805609072 40.7692807820935) | |||
1173 | 1173 | -73.959070754026 | 40.790667514341294 | 32E-PM-1017-07 | 32E | PM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.959070754026 40.7906675143413) | ||||
1210 | 1210 | -73.97079374645409 | 40.772528270844795 | 10G-PM-1017-07 | 10G | PM | 10172018 | 7 | Adult | Black | White | Black+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | traveling | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707937464541 40.7725282708448) | |||
1231 | 1231 | -73.9555583724966 | 40.7932879745739 | 36F-PM-1012-07 | 36F | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9555583724966 40.7932879745739) | ||||
1236 | 1236 | -73.97920390711141 | 40.76787494712671 | 2C-AM-1010-07 | 02C | AM | 10102018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | #7 & #8 chased each other up diff tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9792039071114 40.76787494712671) | |||
1361 | 1361 | -73.961934398055 | 40.79247895485221 | 33B-PM-1010-07 | 33B | PM | 10102018 | 7 | Adult | + | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.961934398055 40.7924789548522) | ||||||
1390 | 1390 | -73.9677146741772 | 40.77882313323371 | 17E-AM-1017-07 | 17E | AM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677146741772 40.7788231332337) | |||||
1442 | 1442 | -73.961241953418 | 40.7941677113011 | 35B-PM-1013-07 | 35B | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | got fed twice by grandpa,grabbed from grass and ate in tree | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. | POINT (-73.961241953418 40.7941677113011) | |||
1656 | 1656 | -73.9557399927792 | 40.7971563708988 | 40D-PM-1013-07 | 40D | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9557399927792 40.7971563708988) | ||||
1666 | 1666 | -73.96494654768709 | 40.7822708362663 | 22F-PM-1014-07 | 22F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9649465476871 40.7822708362663) | |||||
1687 | 1687 | -73.97547909645608 | 40.768336388516005 | 4E-PM-1008-07 | 04E | PM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754790964561 40.768336388516) | ||||
1771 | 1771 | -73.9750688083336 | 40.766558468102495 | 2F-PM-1014-07 | 02F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9750688083336 40.7665584681025) | |||||
1814 | 1814 | -73.97223594012421 | 40.7702891474555 | 7G-AM-1010-07 | 07G | AM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9722359401242 40.7702891474555) | ||||
1846 | 1846 | -73.96533111365609 | 40.780193490342995 | 19F-PM-1017-07 | 19F | PM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9653311136561 40.78019349034301) | ||||
1861 | 1861 | -73.97555625268109 | 40.7678821029525 | 3E-AM-1006-07 | 03E | AM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | burying nuts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755562526811 40.7678821029525) | |||
1862 | 1862 | -73.97648512317541 | 40.771573686286104 | 6C-AM-1007-07 | 06C | AM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | ambling | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | trucks | POINT (-73.9764851231754 40.7715736862861) | ||
1889 | 1889 | -73.9679319758284 | 40.782115480239895 | 20C-PM-1018-07 | 20C | PM | 10182018 | 7 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9679319758284 40.7821154802399) | ||||
2085 | 2085 | -73.9690551477139 | 40.782368566319604 | 20B-PM-1013-07 | 20B | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690551477139 40.7823685663196) | ||||
2104 | 2104 | -73.9622419917579 | 40.794579797904 | 35A-AM-1014-07 | 35A | AM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622419917579 40.794579797904) | ||||
2165 | 2165 | -73.9794371709817 | 40.768387910254 | 2B-PM-1013-07 | 02B | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9794371709817 40.768387910254) | |||||
2189 | 2189 | -73.9761776424664 | 40.7695941843825 | 5D-PM-1018-07 | 05D | PM | 10182018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761776424664 40.7695941843825) | ||||
2193 | 2193 | -73.95693181052529 | 40.7973442139041 | 40C-PM-1006-07 | 40C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569318105253 40.7973442139041) | |||||
2217 | 2217 | -73.9652746477521 | 40.7809326848536 | 20F-PM-1007-07 | 20F | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | watching | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.96527464775211 40.7809326848536) | ||
2261 | 2261 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 10142018 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9609692861012 40.790502891247) | |||||
2301 | 2301 | -73.968906907671 | 40.781627826784295 | 19C-PM-1018-07 | 19C | PM | 10182018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.968906907671 40.7816278267843) | |||
2304 | 2304 | -73.9715251156965 | 40.774621784862 | 11E-PM-1012-07 | 11E | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715251156965 40.774621784862) | ||||
2402 | 2402 | -73.9777206733344 | 40.7668595585487 | 1D-PM-1007-07 | 01D | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | lying down | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9777206733344 40.7668595585487) | ||||
2462 | 2462 | -73.9768544488742 | 40.76800695009771 | 3D-AM-1006-07 | 03D | AM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | running (with food in mouth) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768544488742 40.7680069500977) | |||
2482 | 2482 | -73.9805927710872 | 40.76799891166421 | 1B-PM-1019-07 | 01B | PM | 10192018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9805927710872 40.7679989116642) | ||||
2713 | 2713 | -73.9687214684206 | 40.779284172016396 | 17D-AM-1008-07 | 17D | AM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687214684206 40.7792841720164) | ||||
2780 | 2780 | -73.9700634278 | 40.778422372245295 | 16D-PM-1010-07 | 16D | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9700634278 40.7784223722453) | |||||
2804 | 2804 | -73.9576094432477 | 40.7965342664074 | 38C-PM-1014-07 | 38C | PM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576094432477 40.7965342664074) | ||||
2812 | 2812 | -73.963209639301 | 40.7926138443715 | 32A-PM-1013-07 | 32A | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.963209639301 40.7926138443715) | ||||
2879 | 2879 | -73.9744080700098 | 40.773151572182606 | 9C-PM-1006-07 | 09C | PM | 10062018 | 7 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | on top of tarped sand pile | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | (me) | POINT (-73.9744080700098 40.7731515721826) |
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 );