This data as json, CSV (advanced)
Suggested facets: Hectare, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
82 | 82 | -73.96882712024009 | 40.7809719445309 | 19C-PM-1018-01 | 19C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9688271202401 40.7809719445309) | ||||
136 | 136 | -73.9528682507794 | 40.792580780830704 | 36I-PM-1007-13 | 36I | PM | 10072018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9528682507794 40.7925807808307) | ||||
314 | 314 | -73.960601067176 | 40.7917243850136 | 32D-PM-1006-09 | 32D | PM | 10062018 | 9 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.960601067176 40.7917243850136) | ||||
339 | 339 | -73.965509576403 | 40.7752456763263 | 14I-PM-1018-05 | 14I | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96550957640301 40.7752456763263) | ||||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ran up tree | POINT (-73.959709414696 40.7919745085986) | |||||
461 | 461 | -73.96481954331921 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | staring | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9648195433192 40.7796399955868) | ||||
522 | 522 | -73.97738211356109 | 40.769045349438294 | 4C-PM-1010-06 | 04C | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | behind playground benches | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9773821135611 40.7690453494383) | |||
670 | 670 | -73.9602398690946 | 40.7910157676119 | 32D-PM-1006-04 | 32D | PM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602398690946 40.7910157676119) | ||||
728 | 728 | -73.96029131055779 | 40.7910635810038 | 32D-PM-1006-03 | 32D | PM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602913105578 40.7910635810038) | ||||
1255 | 1255 | -73.9717469822209 | 40.7753731930704 | 12D-PM-1014-03 | 12D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9717469822209 40.7753731930704) | |||||
1296 | 1296 | -73.97055091705421 | 40.7689416540228 | 6I-PM-1013-04 | 06I | PM | 10132018 | 4 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Grass | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9705509170542 40.7689416540228) | |||
1303 | 1303 | -73.9603302382958 | 40.7910100435196 | 32D-PM-1006-01 | 32D | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9603302382958 40.7910100435196) | ||||
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) | ||||
1345 | 1345 | -73.95813265542058 | 40.7918074743129 | 34E-PM-1006-02 | 34E | PM | 10062018 | 2 | Juvenile | Black | Gray, White | Black+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9581326554206 40.7918074743129) | ||||
1430 | 1430 | -73.970804709441 | 40.7758611111219 | 13E-PM-1008-01 | 13E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.970804709441 40.7758611111219) | ||||
1545 | 1545 | -73.9669207809051 | 40.779276785012605 | 18F-PM-1008-01 | 18F | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9669207809051 40.7792767850126) | ||||
1586 | 1586 | -73.9714150090362 | 40.7774976423922 | 14C-PM-1006-03 | 14C | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9714150090362 40.7774976423922) | ||||
1787 | 1787 | -73.9720365327715 | 40.7762329714016 | 13D-PM-1018-11 | 13D | PM | 10182018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720365327715 40.7762329714016) | ||||
2030 | 2030 | -73.9749251267433 | 40.7679111971294 | 4F-PM-1013-01 | 04F | PM | 10132018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9749251267433 40.7679111971294) | ||||
2229 | 2229 | -73.9620719414292 | 40.788637452988 | 29D-PM-1010-02 | 29D | PM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9620719414292 40.788637452988) | ||||
2274 | 2274 | -73.96980442184758 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | 0 | 0 | 0 | 1 | 0 | playing,interacting with #7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9698044218476 40.7697007833531) | ||
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) | |||
2382 | 2382 | -73.97439704555329 | 40.7687880243986 | 5F-PM-1007-01 | 05F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9743970455533 40.7687880243986) | ||||
2472 | 2472 | -73.9596820155238 | 40.7932886803231 | 34D-PM-1007-03 | 34D | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9596820155238 40.7932886803231) | ||||
2604 | 2604 | -73.9605163698302 | 40.7914179994956 | 32D-PM-1006-05 | 32D | PM | 10062018 | 5 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9605163698302 40.7914179994956) | ||||
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) | |||||
2683 | 2683 | -73.972179947936 | 40.7810042827198 | 17A-PM-1013-02 | 17A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | on a little pedestal-shaped part of a tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.972179947936 40.7810042827198) | |||
2723 | 2723 | -73.96064260275601 | 40.791726541984204 | 32D-PM-1006-08 | 32D | PM | 10062018 | 8 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | stand on two feet and watching me | POINT (-73.960642602756 40.7917265419842) | |||
2766 | 2766 | -73.95516398474659 | 40.790858199891 | 34H-PM-1006-03 | 34H | PM | 10062018 | 3 | Gray | White | Gray+White | white belly | Ground Plane | FALSE | Under Tupelo Tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9551639847466 40.790858199891) | |||
2776 | 2776 | -73.9789687905912 | 40.769269313932796 | 3B-PM-1007-04 | 03B | PM | 10072018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | At fence | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9789687905912 40.7692693139328) | |||
2801 | 2801 | -73.9697665830132 | 40.7759094917104 | 13E-PM-1008-08 | 13E | PM | 10082018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697665830132 40.7759094917104) | ||||
2947 | 2947 | -73.96012151981141 | 40.7909769801241 | 32D-PM-1006-02 | 32D | PM | 10062018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9601215198114 40.7909769801241) | ||||
3004 | 3004 | -73.9528482858163 | 40.7922056218325 | 36I-PM-1007-08 | 36I | PM | 10072018 | 8 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9528482858163 40.7922056218325) |
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 );