This data as json, CSV (advanced)
Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
247 | 247 | -73.97331176635409 | 40.7694584620114 | 6F-PM-1008-05 | 06F | PM | 10082018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white patch | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97331176635412 40.7694584620114) | |||
376 | 376 | -73.9698817079185 | 40.775832262771104 | 13E-PM-1008-10 | 13E | PM | 10082018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9698817079185 40.7758322627711) | ||||
382 | 382 | -73.9735946835545 | 40.7724155751282 | 8E-PM-1008-01 | 08E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by tree trunk base | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | eating food being thrown at it by a mom & baby | POINT (-73.9735946835545 40.7724155751282) | ||
389 | 389 | -73.9733966282316 | 40.7717179627127 | 8E-PM-1008-08 | 08E | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9733966282316 40.7717179627127) | ||||
426 | 426 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on railing | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9741944367138 40.7769889953596) | |||
436 | 436 | -73.9734695768004 | 40.7716297491384 | 8E-PM-1008-05 | 08E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734695768004 40.7716297491384) | |||
448 | 448 | -73.9706929341294 | 40.7760473872395 | 13E-PM-1008-06 | 13E | PM | 10082018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706929341294 40.77604738723951) | ||||
689 | 689 | -73.970595381455 | 40.7762912142457 | 13E-PM-1008-05 | 13E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970595381455 40.7762912142457) | ||||
773 | 773 | -73.95661891453521 | 40.7883417969746 | 31H-PM-1008-01 | 31H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9566189145352 40.7883417969746) | ||||
879 | 879 | -73.9735120882106 | 40.7715915415169 | 8E-PM-1008-07 | 08E | PM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9735120882106 40.7715915415169) | |||
897 | 897 | -73.97346875380642 | 40.769430895922206 | 6F-PM-1008-04 | 06F | PM | 10082018 | 4 | Adult | Cinnamon | White | Cinnamon+White | patches of white on haunches | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734687538064 40.7694308959222) | |||
952 | 952 | -73.9699763667769 | 40.775706073102604 | 13E-PM-1008-11 | 13E | PM | 10082018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699763667769 40.775706073102604) | ||||
957 | 957 | -73.9586527721822 | 40.790883111056104 | 32F-PM-1008-08 | 32F | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586527721822 40.7908831110561) | ||||
1028 | 1028 | -73.97070123456609 | 40.7758938984066 | 13E-PM-1008-03 | 13E | PM | 10082018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | hanging upside down to get a nut | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707012345661 40.7758938984066) | |||
1030 | 1030 | -73.9697526733133 | 40.7759529849808 | 13E-PM-1008-09 | 13E | PM | 10082018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9697526733133 40.7759529849808) | ||||
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) | ||||
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) | ||||
1644 | 1644 | -73.9734654671008 | 40.7715988711659 | 8E-PM-1008-06 | 08E | PM | 10082018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734654671008 40.7715988711659) | |||
1802 | 1802 | -73.9736418085696 | 40.7716931127716 | 8E-PM-1008-04 | 08E | PM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass by a grove of tall maples | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | there's a family playing soccer | POINT (-73.9736418085696 40.7716931127716) | ||
1984 | 1984 | -73.9739249209875 | 40.7768528386853 | 13B-PM-1008-02 | 13B | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9739249209875 40.7768528386853) | ||||
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) | ||||
2253 | 2253 | -73.973394428186 | 40.7722933513053 | 8E-PM-1008-03 | 08E | PM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in between 2 trees | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | also being lured by mom & baby w/ food | POINT (-73.973394428186 40.7722933513053) | ||
2415 | 2415 | -73.9683598086625 | 40.7811150451315 | 19D-PM-1008-01 | 19D | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9683598086625 40.7811150451315) | ||||
2526 | 2526 | -73.96464954504991 | 40.7791203699027 | 19H-PM-1008-01 | 19H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9646495450499 40.7791203699027) | ||||
2528 | 2528 | -73.96765297807241 | 40.7823206990549 | 21D-PM-1008-03 | 21D | PM | 10082018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676529780724 40.7823206990549) | ||||
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) | |||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9547959269955 40.7925162926273) |
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 );