This data as json, CSV (advanced)
Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Kuks, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61 | 61 | -73.9797084866613 | 40.7698885241349 | 3A-PM-1017-06 | 03A | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9797084866613 40.7698885241349) | ||||
70 | 70 | -73.9804528867547 | 40.7696753655986 | 3A-PM-1017-05 | 03A | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9804528867547 40.76967536559861) | ||||
75 | 75 | -73.9667114027214 | 40.7768804702473 | 16G-PM-1017-01 | 16G | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667114027214 40.7768804702473) | ||||
153 | 153 | -73.9702348982803 | 40.7773295419104 | 15D-PM-1017-01 | 15D | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9702348982803 40.7773295419104) | ||||
240 | 240 | -73.9767080512177 | 40.7717708794221 | 6B-PM-1017-04 | 06B | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767080512177 40.7717708794221) | ||||
282 | 282 | -73.97015758910979 | 40.773097328242294 | 10G-PM-1017-06 | 10G | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701575891098 40.7730973282423) | ||||
295 | 295 | -73.97006916295742 | 40.782889364519704 | 20A-PM-1017-01 | 20A | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97006916295742 40.7828893645197) | ||||
502 | 502 | -73.96833124530109 | 40.780166168571206 | 18D-PM-1017-01 | 18D | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9683312453011 40.7801661685712) | |||||
521 | 521 | -73.971322876671 | 40.771414508636106 | 8G-PM-1017-01 | 08G | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.971322876671 40.7714145086361) | ||||
621 | 621 | -73.9588886083793 | 40.7909991733435 | 32E-PM-1017-01 | 32E | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588886083793 40.7909991733435) | |||||
651 | 651 | -73.9801661903932 | 40.7697950141751 | 3A-PM-1017-03 | 03A | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9801661903932 40.7697950141751) | ||||
763 | 763 | -73.9767455430709 | 40.7717866237826 | 6B-PM-1017-06 | 06B | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767455430709 40.7717866237826) | ||||
791 | 791 | -73.9772635911119 | 40.7709428872533 | 6B-PM-1017-03 | 06B | PM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9772635911119 40.7709428872533) | ||||
857 | 857 | -73.9714243547433 | 40.7713973982359 | 8G-PM-1017-02 | 08G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714243547433 40.7713973982359) | |||||
1132 | 1132 | -73.9798390387307 | 40.7700761090896 | 3A-PM-1017-07 | 03A | PM | 10172018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9798390387307 40.7700761090896) | ||||
1149 | 1149 | -73.960237785199 | 40.7907831607574 | 32E-PM-1017-16 | 32E | PM | 10172018 | 16 | Adult | Black | Black+ | Ground Plane | FALSE | rocky outcrop | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.960237785199 40.7907831607574) | ||||
1276 | 1276 | -73.9798005188704 | 40.7691868791734 | 3A-PM-1017-01 | 03A | PM | 10172018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.97980051887042 40.7691868791734) | ||||
1340 | 1340 | -73.97730836162592 | 40.7710535931636 | 6B-PM-1017-01 | 06B | PM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9773083616259 40.7710535931636) | |||
1366 | 1366 | -73.97115821991021 | 40.7783674409485 | 15C-PM-1017-05 | 15C | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9711582199102 40.7783674409485) | ||||
1474 | 1474 | -73.9801971465604 | 40.7697081749827 | 3A-PM-1017-04 | 03A | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9801971465604 40.7697081749827) | ||||
1564 | 1564 | -73.9703816112358 | 40.777384606591895 | 15D-PM-1017-02 | 15D | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703816112358 40.7773846065919) | ||||
1712 | 1712 | -73.9801899519657 | 40.7695777009264 | 3A-PM-1017-02 | 03A | PM | 10172018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9801899519657 40.7695777009264) | ||||
1746 | 1746 | -73.96034711618691 | 40.7906003311747 | 32E-PM-1017-15 | 32E | PM | 10172018 | 15 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9603471161869 40.7906003311747) | |||||
1857 | 1857 | -73.9728797531377 | 40.778673314868705 | 15B-PM-1017-01 | 15B | PM | 10172018 | 1 | Gray | Gray+ | Above Ground | 20 | in tree | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728797531377 40.7786733148687) | |||||
2078 | 2078 | -73.9706041173545 | 40.778015278480396 | 15D-PM-1017-05 | 15D | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706041173545 40.7780152784804) | ||||
2115 | 2115 | -73.96582039993879 | 40.7775874026824 | 17G-PM-1017-01 | 17G | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | base of tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9658203999388 40.7775874026824) | ||||
2129 | 2129 | -73.9701182454818 | 40.777280550087106 | 15D-PM-1017-03 | 15D | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701182454818 40.7772805500871) | ||||
2148 | 2148 | -73.9767317539505 | 40.7717600450632 | 6B-PM-1017-05 | 06B | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767317539505 40.7717600450632) | ||||
2296 | 2296 | -73.965596981561 | 40.7797738845824 | 19F-PM-1017-02 | 19F | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.965596981561 40.7797738845824) | |||||
2364 | 2364 | -73.9587183039085 | 40.790920913796896 | 32E-PM-1017-02 | 32E | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9587183039085 40.7909209137969) | |||||
2400 | 2400 | -73.97682684678571 | 40.771460804193296 | 6B-PM-1017-02 | 06B | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768268467857 40.7714608041933) | ||||
2493 | 2493 | -73.954767265558 | 40.7973243644491 | 40E-PM-1017-03 | 40E | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.954767265558 40.7973243644491) | ||||
2513 | 2513 | -73.9767590273554 | 40.7717561807266 | 6B-PM-1017-07 | 06B | PM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767590273554 40.7717561807266) | ||||
2643 | 2643 | -73.9693719015914 | 40.7768710160557 | 14E-PM-1017-02 | 14E | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | staring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693719015914 40.7768710160557) | |||
2656 | 2656 | -73.97239959684201 | 40.7788765078432 | 15B-PM-1017-04 | 15B | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | on hill | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.972399596842 40.7788765078432) | ||||
2721 | 2721 | -73.95519234082391 | 40.796830266140205 | 40E-PM-1017-01 | 40E | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9551923408239 40.7968302661402) | ||||
2728 | 2728 | -73.9507140045973 | 40.7957700986293 | 41I-PM-1017-01 | 41I | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon oval on back | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507140045973 40.7957700986293) | |||
2890 | 2890 | -73.9726236083428 | 40.7788217771475 | 15B-PM-1017-03 | 15B | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by water | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9726236083428 40.778821777147506) | |||
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) |
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 );