This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Kuks, Tail flags, Approaches, Indifferent, Runs from, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
218 | 218 | -73.9712318712643 | 40.7773053099657 | 14D-PM-1019-04 | 14D | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9712318712643 40.7773053099657) | |||||
274 | 274 | -73.9639832886071 | 40.7909532437095 | 30B-PM-1019-08 | 30B | PM | 10192018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9639832886071 40.7909532437095) | ||||
495 | 495 | -73.9801007327506 | 40.7677455633932 | 1B-PM-1019-06 | 01B | PM | 10192018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801007327506 40.7677455633932) | ||||
644 | 644 | -73.97221256300399 | 40.776131146585705 | 13C-PM-1019-05 | 13C | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.972212563004 40.7761311465857) | ||||
699 | 699 | -73.95046935442251 | 40.797225436004 | 42H-AM-1019-01 | 42H | AM | 10192018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9504693544225 40.797225436004) | ||||
827 | 827 | -73.97002473508999 | 40.78369290444589 | 21A-AM-1019-08 | 21A | AM | 10192018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97002473509 40.7836929044459) | ||||
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) | |||||
1009 | 1009 | -73.9636551433178 | 40.790157281877605 | 30B-PM-1019-02 | 30B | PM | 10192018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9636551433178 40.7901572818776) | ||||
1316 | 1316 | -73.9674724790652 | 40.7768771349868 | 15G-PM-1019-01 | 15G | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9674724790652 40.7768771349868) | ||||
1383 | 1383 | -73.96767327256721 | 40.7763194425467 | 15G-PM-1019-09 | 15G | PM | 10192018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676732725672 40.7763194425467) | |||||
1423 | 1423 | -73.96002043282009 | 40.782877291358 | 24I-AM-1019-01 | 24I | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9600204328201 40.782877291358) | ||||
1582 | 1582 | -73.9804065254162 | 40.7681481183296 | 1B-PM-1019-08 | 01B | PM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9804065254162 40.7681481183296) | ||||
1885 | 1885 | -73.9594174605642 | 40.7973128653773 | 38B-AM-1019-02 | 38B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594174605642 40.7973128653773) | ||||
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) | |||||
1950 | 1950 | -73.96430161168391 | 40.7904796216068 | 30B-PM-1019-05 | 30B | PM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | hiding a nut | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9643016116839 40.7904796216068) | |||
1977 | 1977 | -73.9586570546871 | 40.796349417475 | 38C-AM-1019-09 | 38C | AM | 10192018 | 9 | Adult | Gray | White | Gray+White | Gray & White selected as Primary & Highlights. Made executive adjustments. | Above Ground | 3 | Between ground & tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586570546871 40.796349417475) | ||
2203 | 2203 | -73.97105314852979 | 40.7773757069445 | 14D-PM-1019-06 | 14D | PM | 10192018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.97105314852982 40.777375706944504) | |||||
2215 | 2215 | -73.96749788267509 | 40.776288410765 | 15G-PM-1019-10 | 15G | PM | 10192018 | 10 | Adult | Gray | Gray+ | Above Ground | 1 | on a log | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674978826751 40.776288410765) | ||||
2254 | 2254 | -73.9709991016317 | 40.7725756707748 | 10F-PM-1019-03 | 10F | PM | 10192018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head | Ground Plane | FALSE | Behind fence, grass | 0 | 0 | 0 | 1 | 0 | eating (nuts) | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (bad tourists w/ nuts) | POINT (-73.9709991016317 40.772575670774806) |
2380 | 2380 | -73.97613757295049 | 40.766223189212496 | 1F-PM-1019-02 | 01F | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9761375729505 40.7662231892125) | ||||
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) | ||||
2736 | 2736 | -73.95938952535009 | 40.797308584408704 | 38B-AM-1019-03 | 38B | AM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9593895253501 40.7973085844087) | |||||
2800 | 2800 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802983138318 40.7676540772339) | ||||
2802 | 2802 | -73.9533101544112 | 40.7938634280159 | 38H-AM-1019-01 | 38H | AM | 10192018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9533101544112 40.7938634280159) | ||||
2825 | 2825 | -73.96435075880079 | 40.790432469329204 | 30B-PM-1019-07 | 30B | PM | 10192018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.96435075880082 40.7904324693292) | ||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530811255728 40.79830691185791) | ||||
3017 | 3017 | -73.9662895079734 | 40.7843300758044 | 23C-AM-1019-01 | 23C | AM | 10192018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 7 | 0 | 0 | 1 | 1 | 0 | eating (on branch) | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662895079734 40.7843300758044) | ||
187 | 187 | -73.9700162034073 | 40.7815277479588 | 19B-AM-1019-02 | 19B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | posing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | indifferent then runs from | POINT (-73.9700162034073 40.7815277479588) | ||
804 | 804 | -73.9697196619878 | 40.7814068507607 | 19B-AM-1019-01 | 19B | AM | 10192018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Side stripes | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | indifferent then runs from | POINT (-73.9697196619878 40.7814068507607) | ||
922 | 922 | -73.9708002461415 | 40.7726685284831 | 10F-PM-1019-10 | 10F | PM | 10192018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Arbor path & hill w/ bushes | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9708002461415 40.7726685284831) | |||
964 | 964 | -73.9631045499811 | 40.790618096947206 | 30B-PM-1019-04 | 30B | PM | 10192018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9631045499811 40.7906180969472) | ||||
1381 | 1381 | -73.9586077039567 | 40.796189647707706 | 38C-AM-1019-10 | 38C | AM | 10192018 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586077039567 40.7961896477077) | ||||
1410 | 1410 | -73.95879132892291 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 10192018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9587913289229 40.7961707624534) | ||||
1465 | 1465 | -73.9720289863666 | 40.7763749561607 | 13C-PM-1019-03 | 13C | PM | 10192018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97202898636661 40.7763749561607) | ||||
1866 | 1866 | -73.96360276644391 | 40.790075966587 | 30B-PM-1019-01 | 30B | PM | 10192018 | 1 | 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.9636027664439 40.790075966587) |
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 );