This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Tail flags, Tail twitches
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | 17 | -73.96950635353329 | 40.7823507678183 | 20B-PM-1013-05 | 20B | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695063535333 40.7823507678183) | ||||
69 | 69 | -73.9689000978955 | 40.7828364735236 | 20B-PM-1013-10 | 20B | PM | 10132018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | drank from a pond of rain water | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689000978955 40.7828364735236) | |||
141 | 141 | -73.9590992841423 | 40.793758098573 | 35D-PM-1013-09 | 35D | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9590992841423 40.793758098573) | ||||
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) | ||||
239 | 239 | -73.97584649051329 | 40.77259574088411 | 8C-PM-1013-05 | 08C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9758464905133 40.7725957408841) | ||||
272 | 272 | -73.9521950056404 | 40.794937340844996 | 39H-PM-1013-01 | 39H | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ran away when a human approached with a dog | POINT (-73.9521950056404 40.794937340845) | |||
280 | 280 | -73.9587401274261 | 40.7960322222949 | 37C-PM-1013-03 | 37C | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9587401274261 40.7960322222949) | ||||||
299 | 299 | -73.9586214081667 | 40.7937473968735 | 35D-PM-1013-03 | 35D | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | No Tail! | Above Ground | 2 | bench | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586214081667 40.7937473968735) | ||
323 | 323 | -73.9573469787503 | 40.7944044592573 | 36E-AM-1013-03 | 36E | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent (moving very fast) | POINT (-73.9573469787503 40.7944044592573) | |||
375 | 375 | -73.9752000129992 | 40.773291812223896 | 8C-PM-1013-04 | 08C | PM | 10132018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752000129992 40.7732918122239) | ||||
761 | 761 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 10132018 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975062146111 40.7723417173451) | |||||
809 | 809 | -73.96332506365009 | 40.7922155082679 | 32A-PM-1013-09 | 32A | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9633250636501 40.7922155082679) | ||||
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) | |||
924 | 924 | -73.9591695545875 | 40.793811636076704 | 35D-PM-1013-08 | 35D | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9591695545875 40.7938116360767) | ||||
965 | 965 | -73.97083010709241 | 40.7820200927465 | 19A-PM-1013-01 | 19A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | planting acorns | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9708301070924 40.7820200927465) | |||
1225 | 1225 | -73.95848035139392 | 40.7933802077327 | 35D-PM-1013-01 | 35D | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 12 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584803513939 40.7933802077327) | ||||
1308 | 1308 | -73.95603964408441 | 40.7945080361909 | 37E-AM-1013-01 | 37E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9560396440844 40.7945080361909) | ||||
1403 | 1403 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9761632586697 40.7741085606149) | ||||
1405 | 1405 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589371550945 40.7959812504467) | ||||||
1478 | 1478 | -73.9676370985166 | 40.7869888639434 | 25A-AM-1013-01 | 25A | AM | 10132018 | 1 | Gray | White | Gray+White | White Belly | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | staring at me | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96763709851662 40.7869888639434) | |||
1559 | 1559 | -73.9631648674122 | 40.7926529617419 | 32A-PM-1013-08 | 32A | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631648674122 40.7926529617419) | ||||
1585 | 1585 | -73.96113123553481 | 40.79501308639129 | 36A-PM-1013-04 | 36A | PM | 10132018 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | ON ROCK NEAR POND | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9611312355348 40.7950130863913) | |||
1689 | 1689 | -73.9547031549299 | 40.797886753932204 | 41E-PM-1013-01 | 41E | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9547031549299 40.7978867539322) | ||||
1747 | 1747 | -73.96657637976071 | 40.7761316400012 | 15H-AM-1013-03 | 15H | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665763797607 40.7761316400012) | ||||
1836 | 1836 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9751056714758 40.7732060035215) | ||||
1933 | 1933 | -73.95848243616551 | 40.7934247634031 | 35D-PM-1013-02 | 35D | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 24 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584824361655 40.7934247634031) | ||||
1935 | 1935 | -73.9675268877392 | 40.775040968171794 | 13H-AM-1013-01 | 13H | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9675268877392 40.7750409681718) | ||||
1961 | 1961 | -73.953664715831 | 40.7981256393159 | 41E-PM-1013-04 | 41E | PM | 10132018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.953664715831 40.7981256393159) | ||||
2012 | 2012 | -73.95874648525609 | 40.793496354083 | 35D-PM-1013-05 | 35D | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9587464852561 40.793496354083) | ||||
2085 | 2085 | -73.9690551477139 | 40.782368566319604 | 20B-PM-1013-07 | 20B | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690551477139 40.7823685663196) | ||||
2224 | 2224 | -73.9662310606968 | 40.7747758221226 | 14I-AM-1013-01 | 14I | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662310606968 40.7747758221226) | ||||
2225 | 2225 | -73.95623234556741 | 40.7946180656349 | 37E-AM-1013-02 | 37E | AM | 10132018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9562323455674 40.79461806563491) | |||||
2252 | 2252 | -73.95377032313591 | 40.7915959393814 | 35I-AM-1013-01 | 35I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | White underbelly | Above Ground | 18 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9537703231359 40.7915959393814) | |||
2353 | 2353 | -73.963623175585 | 40.7927451068919 | 32A-PM-1013-04 | 32A | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.963623175585 40.7927451068919) | ||||
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) | ||||
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) | |||
2855 | 2855 | -73.9690832219322 | 40.782343340985996 | 20B-PM-1013-06 | 20B | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96908322193221 40.782343340986) | ||||
2978 | 2978 | -73.96888170064429 | 40.7829120321438 | 20B-PM-1013-09 | 20B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688817006443 40.7829120321438) | ||||
3020 | 3020 | -73.97040158596391 | 40.7825600069973 | 19A-PM-1013-05 | 19A | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704015859639 40.7825600069973) |
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 );