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, Kuks, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25 | 25 | -73.96711306801141 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9671130680114 40.7784859700171) | ||||
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) | ||||||
73 | 73 | -73.96148483609001 | 40.7922645521905 | 33C-PM-1007-03 | 33C | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96148483609 40.7922645521905) | ||||
115 | 115 | -73.9530040923555 | 40.7922896176936 | 36I-PM-1007-10 | 36I | PM | 10072018 | 10 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | stole (found?) an entire sandwich | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530040923555 40.7922896176936) | |||
163 | 163 | -73.97123088643941 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 0 | 0 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712308864394 40.7714534847379) | |||
269 | 269 | -73.9591400366159 | 40.7891708599318 | 31F-PM-1007-01 | 31F | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | white neck and belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9591400366159 40.7891708599318) | |||
407 | 407 | -73.9787658435198 | 40.768941976539296 | 3B-PM-1007-07 | 03B | PM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating loudly <- peanuts w/ shells | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787658435198 40.7689419765393) | |||
437 | 437 | -73.9793952066038 | 40.7707837657859 | 4A-PM-1007-03 | 04A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by rock | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9793952066038 40.77078376578591) | |||
440 | 440 | -73.9642717435966 | 40.782087049693 | 22F-AM-1007-05 | 22F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9642717435966 40.782087049693) | |||
468 | 468 | -73.9780659679557 | 40.7672382282781 | 1D-PM-1007-06 | 01D | PM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9780659679557 40.7672382282781) | ||||
475 | 475 | -73.9697855573137 | 40.7742186391935 | 12F-PM-1007-05 | 12F | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9697855573137 40.7742186391935) | ||||
575 | 575 | -73.9783366903829 | 40.7668300056094 | 1D-PM-1007-03 | 01D | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783366903829 40.7668300056094) | ||||
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) | ||||
741 | 741 | -73.9790214253443 | 40.7686791169776 | 3B-PM-1007-10 | 03B | PM | 10072018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | hopping | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9790214253443 40.7686791169776) | |||
750 | 750 | -73.96996720741642 | 40.777438934574796 | 15D-AM-1007-07 | 15D | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699672074164 40.7774389345748) | |||
781 | 781 | -73.955516031113 | 40.7923188156277 | 35G-AM-1007-01 | 35G | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955516031113 40.7923188156277) | ||||
800 | 800 | -73.96821440393342 | 40.7773070675393 | 15F-AM-1007-08 | 15F | AM | 10072018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682144039334 40.7773070675393) | ||||
817 | 817 | -73.9540022445432 | 40.7979409854977 | 41E-AM-1007-01 | 41E | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | white haunches | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9540022445432 40.7979409854977) | |||
1246 | 1246 | -73.9543044385367 | 40.7984498571338 | 41E-AM-1007-04 | 41E | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white haunches/tail | Ground Plane | FALSE | rubbing belly on ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9543044385367 40.798449857133804) | ||
1413 | 1413 | -73.98100322064279 | 40.768162563497896 | 1A-AM-1007-01 | 01A | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9810032206428 40.7681625634979) | ||||
1418 | 1418 | -73.9673924060436 | 40.7788781851716 | 17F-AM-1007-03 | 17F | AM | 10072018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9673924060436 40.7788781851716) | ||||
1498 | 1498 | -73.9765064169087 | 40.7737211426714 | 8B-AM-1007-06 | 08B | AM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9765064169087 40.7737211426714) | ||||
1590 | 1590 | -73.9610388059192 | 40.793952935840004 | 34B-PM-1007-01 | 34B | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9610388059192 40.79395293584) | ||||
1660 | 1660 | -73.98004994980342 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9800499498034 40.770218109957305) | |||
1671 | 1671 | -73.9611399573659 | 40.781130706026 | 22I-AM-1007-01 | 22I | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611399573659 40.781130706026005) | ||||
1727 | 1727 | -73.96924722995651 | 40.7722592187215 | 10H-PM-1007-01 | 10H | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | dark gray | Above Ground | 15 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9692472299565 40.7722592187215) | ||
1730 | 1730 | -73.97961428483491 | 40.7702117898305 | 4A-PM-1007-04 | 04A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9796142848349 40.7702117898305) | ||||
1804 | 1804 | -73.98077710643099 | 40.7681635726316 | 1A-AM-1007-02 | 01A | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 11 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.980777106431 40.7681635726316) | ||||
1851 | 1851 | -73.9623621412501 | 40.7814673556041 | 22H-PM-1007-03 | 22H | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | chased squirrel #2 away | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9623621412501 40.7814673556041) | |||
1929 | 1929 | -73.9646023053207 | 40.7810680044024 | 20F-PM-1007-14 | 20F | PM | 10072018 | 14 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9646023053207 40.78106800440241) | ||||
1972 | 1972 | -73.9558370309765 | 40.7921977208472 | 35G-AM-1007-02 | 35G | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9558370309765 40.7921977208472) | ||||
2081 | 2081 | -73.96757180595391 | 40.7786049141486 | 17F-AM-1007-06 | 17F | AM | 10072018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9675718059539 40.7786049141486) | ||||
2111 | 2111 | -73.968446056806 | 40.785824818871 | 24A-PM-1007-01 | 24A | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96844605680602 40.785824818871) | ||||
2478 | 2478 | -73.96749310703241 | 40.778369369095394 | 17F-AM-1007-04 | 17F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 4 | 0 | 0 | 0 | 1 | 0 | chilling | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9674931070324 40.7783693690954) | |||
2704 | 2704 | -73.96577644902841 | 40.781192322928604 | 20F-PM-1007-10 | 20F | PM | 10072018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657764490284 40.7811923229286) | ||||
2732 | 2732 | -73.9694185786221 | 40.7787189999566 | 16D-AM-1007-06 | 16D | AM | 10072018 | 6 | Adult | Cinnamon | White | Cinnamon+White | primary color: brown ( I marked cinnamon as closest to brown - JO) | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694185786221 40.7787189999566) | |||
2906 | 2906 | -73.9597260014375 | 40.790707423031 | 32E-AM-1007-04 | 32E | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9597260014375 40.790707423031) |
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 );