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, Running, Climbing, Eating, Kuks, Tail flags, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21 | 21 | -73.9703781726172 | 40.778752613032104 | 16C-PM-1018-03 | 16C | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703781726172 40.7787526130321) | ||||
1018 | 1018 | -73.96953055553921 | 40.7757541971012 | 13F-PM-1008-03 | 13F | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695305555392 40.7757541971012) | ||||
1028 | 1028 | -73.97070123456609 | 40.7758938984066 | 13E-PM-1008-03 | 13E | PM | 10082018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | hanging upside down to get a nut | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707012345661 40.7758938984066) | |||
1126 | 1126 | -73.97001860010491 | 40.7826052184658 | 20B-AM-1007-03 | 20B | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9700186001049 40.7826052184658) | |||||
1425 | 1425 | -73.95862528758559 | 40.7852027586217 | 27I-AM-1007-03 | 27I | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | had .5 of a tail | Above Ground | 20 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586252875856 40.7852027586217) | |||
1572 | 1572 | -73.9540197079615 | 40.798039260982996 | 41E-PM-1013-03 | 41E | PM | 10132018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray on legs | Above Ground | 20 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9540197079615 40.798039260983) | |||
1851 | 1851 | -73.9623621412501 | 40.7814673556041 | 22H-PM-1007-03 | 22H | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | chased squirrel #2 away | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9623621412501 40.7814673556041) | |||
2015 | 2015 | -73.9574365550758 | 40.7886924675052 | 31H-PM-1008-03 | 31H | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | no clue, way up a tree! | 0 | 0 | 1 | 0 | 1 | throwing down acorns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9574365550758 40.7886924675052) | ||||
2069 | 2069 | -73.9538377039825 | 40.798060533496106 | 42E-PM-1012-03 | 42E | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538377039825 40.7980605334961) | |||
2090 | 2090 | -73.9569759970802 | 40.7931497452294 | 35F-PM-1012-03 | 35F | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569759970802 40.79314974522941) | ||||
2132 | 2132 | -73.967472660349 | 40.7772125619715 | 16F-PM-1013-03 | 16F | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | Woods | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.96747266034902 40.7772125619715) | |||
2259 | 2259 | -73.975565603566 | 40.7738462518304 | 9B-AM-1010-03 | 09B | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975565603566 40.7738462518304) | ||||
2388 | 2388 | -73.9604476047877 | 40.7938014328732 | 35C-AM-1007-03 | 35C | AM | 10072018 | 3 | Adult | + | Above Ground | 40 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9604476047877 40.7938014328732) | ||||||
2393 | 2393 | -73.9729190572117 | 40.770018150904995 | 6F-PM-1008-03 | 06F | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | top of tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9729190572117 40.770018150905) | ||||
2403 | 2403 | -73.97778796352159 | 40.769359455673 | 4C-AM-1006-03 | 04C | AM | 10062018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9777879635216 40.769359455673) | |||||
2694 | 2694 | -73.969628583287 | 40.770406779793205 | 8H-AM-1017-03 | 08H | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969628583287 40.7704067797932) | |||
2747 | 2747 | -73.971314838366 | 40.774951285041 | 12E-AM-1017-03 | 12E | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.971314838366 40.774951285041) | ||||
2763 | 2763 | -73.96260656728941 | 40.788722645116 | 29D-AM-1014-03 | 29D | AM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 35 | End of tree limb foraging | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9626065672894 40.788722645116) | ||||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670432105975 40.7753462013506) |
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 );