This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68 | 68 | -73.96942403275091 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 10072018 | 2 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96942403275091 40.7755898126674) | ||||||
624 | 624 | -73.96130519573059 | 40.7909351393505 | 31D-AM-1014-02 | 31D | AM | 10142018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9613051957306 40.7909351393505) | |||
694 | 694 | -73.9698032734704 | 40.7782343912417 | 16D-AM-1007-02 | 16D | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698032734704 40.7782343912417) | ||||
1093 | 1093 | -73.9584106786233 | 40.7902777556926 | 32F-PM-1008-02 | 32F | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584106786233 40.7902777556926) | ||||
1187 | 1187 | -73.97933344163779 | 40.7674142089209 | 1C-PM-1013-02 | 01C | PM | 10132018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9793334416378 40.7674142089209) | |||
1482 | 1482 | -73.95886101956991 | 40.7945269936639 | 36C-AM-1014-02 | 36C | AM | 10142018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Crossing path | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9588610195699 40.7945269936639) | |||
1536 | 1536 | -73.9746128451271 | 40.770095704670894 | 6E-PM-1010-02 | 06E | PM | 10102018 | 2 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9746128451271 40.7700957046709) | ||
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) | ||||
1717 | 1717 | -73.97149520927671 | 40.7748063281815 | 12E-AM-1017-02 | 12E | AM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714952092767 40.7748063281815) | ||||
1873 | 1873 | -73.955754300682 | 40.795681399740005 | 38E-PM-1014-02 | 38E | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955754300682 40.79568139974) | ||||
1978 | 1978 | -73.9579689996645 | 40.794933848991704 | 37D-AM-1018-02 | 37D | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579689996645 40.7949338489917) | ||||
2072 | 2072 | -73.9618709589382 | 40.7944969066792 | 35A-PM-1013-02 | 35A | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9618709589382 40.7944969066792) | ||||
2097 | 2097 | -73.9773486521595 | 40.77084549021129 | 5C-PM-1010-02 | 05C | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9773486521595 40.7708454902113) | ||||
2185 | 2185 | -73.9707571364399 | 40.7758859812524 | 13E-PM-1008-02 | 13E | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9707571364399 40.7758859812524) | ||||
2212 | 2212 | -73.9801138983722 | 40.768572151563504 | 2B-PM-1013-02 | 02B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9801138983722 40.7685721515635) | ||||
2352 | 2352 | -73.9727310397798 | 40.778701677351705 | 15B-PM-1017-02 | 15B | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | tree | 0 | 0 | 1 | 1 | 1 | digging,chewing on tree—has nut in mouth! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97273103977982 40.7787016773517) | ||
2398 | 2398 | -73.95871384837301 | 40.7963918051751 | 38C-PM-1014-02 | 38C | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958713848373 40.7963918051751) | ||||
2405 | 2405 | -73.9588361742943 | 40.791115225155 | 33E-PM-1012-02 | 33E | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588361742943 40.791115225155) | ||||
2458 | 2458 | -73.969517504176 | 40.782074134429706 | 20B-PM-1013-02 | 20B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969517504176 40.7820741344297) | ||||
2594 | 2594 | -73.9638812060405 | 40.7923714941429 | 32A-PM-1013-02 | 32A | PM | 10132018 | 2 | ? | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9638812060405 40.792371494142905) | ||||
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) | |||
2689 | 2689 | -73.97041219894871 | 40.7824040236981 | 19A-PM-1013-02 | 19A | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Looks very brown, not like English red squirrels | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704121989487 40.7824040236981) | |||
2819 | 2819 | -73.95503500969379 | 40.797694218705004 | 41E-PM-1013-02 | 41E | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9550350096938 40.797694218705004) | ||||
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) | ||||
2887 | 2887 | -73.964593167562 | 40.7780374890066 | 18H-PM-1014-02 | 18H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.964593167562 40.7780374890066) | ||||
3009 | 3009 | -73.9675637870968 | 40.782388067172796 | 21D-PM-1008-02 | 21D | PM | 10082018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675637870968 40.7823880671728) |
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 );