This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1357 | 1357 | -73.96313500206341 | 40.791907210332 | 32B-PM-1010-01 | 32B | PM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 25 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9631350020634 40.791907210332) | ||||
1714 | 1714 | -73.9763542780331 | 40.773653130362206 | 9B-AM-1010-02 | 09B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | in bush | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | froze | POINT (-73.9763542780331 40.773653130362206) | ||
820 | 820 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 10122018 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801902133148 40.769557595068) | |||
1840 | 1840 | -73.9733222531339 | 40.764997537154606 | 1I-PM-1012-01 | 01I | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9733222531339 40.7649975371546) | |||
2389 | 2389 | -73.9801343393329 | 40.769151245340204 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801343393329 40.7691512453402) | |||
2745 | 2745 | -73.97296259363002 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 10122018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2 | on ledge | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97296259363 40.7652601851275) | ||
155 | 155 | -73.9522142360388 | 40.7949598486683 | 39H-PM-1013-02 | 39H | PM | 10132018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9522142360388 40.7949598486683) | ||||
238 | 238 | -73.9760942252437 | 40.7742035674209 | 9B-PM-1013-07 | 09B | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97609422524371 40.7742035674209) | ||||
423 | 423 | -73.97567542977471 | 40.7738518843446 | 9B-PM-1013-02 | 09B | PM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9756754297747 40.7738518843446) | ||||
432 | 432 | -73.9757787135906 | 40.7737231427345 | 9B-PM-1013-03 | 09B | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9757787135906 40.7737231427345) | ||||
567 | 567 | -73.9756972647636 | 40.773624164826 | 9B-PM-1013-04 | 09B | PM | 10132018 | 4 | Juvenile | Gray | Black | Gray+Black | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9756972647636 40.773624164826) | ||||
622 | 622 | -73.97548367967059 | 40.7738879545412 | 9B-PM-1013-01 | 09B | PM | 10132018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9754836796706 40.7738879545412) | |||
856 | 856 | -73.9591667162801 | 40.7937602121568 | 35D-PM-1013-07 | 35D | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Above Ground | 12 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95916671628011 40.7937602121568) | |||
1651 | 1651 | -73.97633735105359 | 40.774116893392794 | 9B-PM-1013-09 | 09B | PM | 10132018 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | runs from (people) | POINT (-73.9763373510536 40.7741168933928) | ||||
2606 | 2606 | -73.96143417385001 | 40.794546426211205 | 35B-PM-1013-02 | 35B | PM | 10132018 | 2 | Juvenile | + | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | did not notice dog sitting a few yards away (10-20 ft) | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96143417385 40.7945464262112) | |||||
655 | 655 | -73.9728783802067 | 40.7731671049246 | 9E-PM-1014-02 | 09E | PM | 10142018 | 2 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9728783802067 40.7731671049246) | ||||
1394 | 1394 | -73.95488263914001 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 10142018 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2 | up/down tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95488263914 40.7959474571251) | ||||
2641 | 2641 | -73.96155167034941 | 40.790521938835894 | 31D-AM-1014-04 | 31D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Open ground | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9615516703494 40.7905219388359) | ||||
2324 | 2324 | -73.9737247632185 | 40.7759469280872 | 12C-PM-1017-01 | 12C | PM | 10172018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | digging/burying,drinking from lake | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9737247632185 40.7759469280872) | |||
2989 | 2989 | -73.9643538221947 | 40.7917565604735 | 31A-PM-1017-01 | 31A | PM | 10172018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9643538221947 40.7917565604735) | |||
217 | 217 | -73.9712327308512 | 40.7748702909218 | 12E-PM-1018-06 | 12E | PM | 10182018 | 6 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9712327308512 40.7748702909218) | |||||
884 | 884 | -73.96789372898371 | 40.7782808361645 | 16E-PM-1018-01 | 16E | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9678937289837 40.7782808361645) | ||||
1111 | 1111 | -73.96327993398721 | 40.7808316436308 | 21H-PM-1018-01 | 21H | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | staring | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9632799339872 40.7808316436308) | |||
2033 | 2033 | -73.9500167570283 | 40.7966185836685 | 41I-AM-1018-01 | 41I | AM | 10182018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | cautious,observant,runs off | POINT (-73.9500167570283 40.7966185836685) | |||
2171 | 2171 | -73.9686370726471 | 40.7780382348833 | 16E-PM-1018-09 | 16E | PM | 10182018 | 9 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 3 | On trunk | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9686370726471 40.7780382348833) | |||
2522 | 2522 | -73.9658747245917 | 40.77540337375321 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9658747245917 40.7754033737532) | ||||
53 | 53 | -73.95849706432129 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9584970643213 40.7982886348696) | ||||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.958535640774 40.7982737896998) | ||||
209 | 209 | -73.97107601968679 | 40.7725506006789 | 10F-PM-1019-02 | 10F | PM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Ground Plane | FALSE | Behind fence, grass | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9710760196868 40.7725506006789) | ||
482 | 482 | -73.97217978245759 | 40.7801213843628 | 16A-PM-1019-07 | 16A | PM | 10192018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | approaches (very friendly) | POINT (-73.9721797824576 40.7801213843628) | |||
846 | 846 | -73.95826439540551 | 40.800046006127204 | 42A-AM-1019-01 | 42A | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95826439540551 40.8000460061272) | ||||
1524 | 1524 | -73.97259615083159 | 40.7795720444974 | 16A-PM-1019-06 | 16A | PM | 10192018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9725961508316 40.7795720444974) | |||||
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) | ||||
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) | |||||
356 | 356 | -73.97610364001441 | 40.77054826845939 | 6D-PM-1020-03 | 06D | PM | 10202018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9761036400144 40.7705482684594) | |||||
3016 | 3016 | -73.9756457597888 | 40.7703559775625 | 6D-PM-1020-02 | 06D | PM | 10202018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9756457597888 40.7703559775625) |
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 );