This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Chasing, Eating, Foraging, Other Activities, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116 | 116 | -73.9572093760529 | 40.798848730021604 | 41B-AM-1010-06 | 41B | AM | 10102018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9572093760529 40.7988487300216) | ||||
260 | 260 | -73.97843611793199 | 40.7724769242403 | 6A-AM-1006-06 | 06A | AM | 10062018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | tree | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.978436117932 40.7724769242403) | |||
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) | ||||
496 | 496 | -73.9548430741605 | 40.798207350942 | 41E-AM-1007-06 | 41E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | tree | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9548430741605 40.798207350942) | ||||
708 | 708 | -73.9592819491968 | 40.7941062008626 | 35C-AM-1007-06 | 35C | AM | 10072018 | 6 | Adult | + | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9592819491968 40.7941062008626) | ||||||
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) | ||||
737 | 737 | -73.97111769994709 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | Different tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711176999471 40.7724278547281) | |||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9552035011902 40.7889851896334) | |||
1032 | 1032 | -73.96328685617941 | 40.7907806312915 | 30B-AM-1007-06 | 30B | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632868561794 40.7907806312915) | |||||
1099 | 1099 | -73.9761527947483 | 40.770960700253895 | 6C-AM-1007-06 | 06C | AM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | disappeared when jogger ran by | POINT (-73.9761527947483 40.7709607002539) | |||
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) | ||||
1133 | 1133 | -73.9712550584322 | 40.7764273475386 | 13D-PM-1018-06 | 13D | PM | 10182018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712550584322 40.7764273475386) | |||
1161 | 1161 | -73.9694066600156 | 40.7805662180672 | 18C-PM-1018-06 | 18C | PM | 10182018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694066600156 40.7805662180672) | ||||
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) | ||||
1535 | 1535 | -73.9703921271418 | 40.770027611531404 | 7H-PM-1006-06 | 07H | PM | 10062018 | 6 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 1 | 1 | 0 | 0 | playing w/ #7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703921271418 40.770027611531404) | ||||
1886 | 1886 | -73.956806913988 | 40.7987736900857 | 41C-AM-1017-06 | 41C | AM | 10172018 | 6 | Adult | Gray | Gray+ | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.956806913988 40.7987736900857) | |||||
1943 | 1943 | -73.9690447463294 | 40.783913304529 | 21B-AM-1019-06 | 21B | AM | 10192018 | 6 | Juvenile | Gray | Gray+ | Above Ground | 7 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690447463294 40.78391330452901) | |||||
1998 | 1998 | -73.9595686513629 | 40.7906859748696 | 32E-AM-1007-06 | 32E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 40 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595686513629 40.7906859748696) | |||||
2081 | 2081 | -73.96757180595391 | 40.7786049141486 | 17F-AM-1007-06 | 17F | AM | 10072018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9675718059539 40.7786049141486) | ||||
2144 | 2144 | -73.975198284551 | 40.7740343763399 | 9B-AM-1010-06 | 09B | AM | 10102018 | 6 | Juvenile | Gray | White | Gray+White | Above Ground | 16 | tree | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975198284551 40.7740343763399) | ||
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) | ||||
2323 | 2323 | -73.9715921982161 | 40.7746153066601 | 11E-PM-1012-06 | 11E | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 5 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715921982161 40.7746153066601) | |||
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) | |||||
2588 | 2588 | -73.95810074370941 | 40.795940311272204 | 38C-AM-1019-06 | 38C | AM | 10192018 | 6 | Adult | Gray | Gray+ | Above Ground | 23 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9581007437094 40.7959403112722) | |||||
2702 | 2702 | -73.9588339897601 | 40.7848084865431 | 26I-PM-1010-06 | 26I | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | tree | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9588339897601 40.7848084865431) | |||
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) | ||||
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) |
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 );