This data as json, CSV (advanced)
Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Tail flags, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65 | 65 | -73.9741824992294 | 40.7689486657963 | 5F-PM-1007-03 | 05F | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hiding nut | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9741824992294 40.7689486657963) | |||
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) | ||||
310 | 310 | -73.9795081274695 | 40.7691431548544 | 3B-PM-1007-03 | 03B | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9795081274695 40.7691431548544) | |||||
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) | |||
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) | ||||
612 | 612 | -73.9629420113622 | 40.789133072717 | 29C-AM-1007-03 | 29C | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629420113622 40.789133072717) | ||||
660 | 660 | -73.9638298997554 | 40.78259663323671 | 22F-AM-1007-03 | 22F | AM | 10072018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | large white highlight | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9638298997554 40.7825966332367) | |||
714 | 714 | -73.96915857561909 | 40.776340465695 | 14F-AM-1007-03 | 14F | AM | 10072018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691585756191 40.776340465695) | ||||
937 | 937 | -73.97063234587691 | 40.7713196034265 | 9G-PM-1007-03 | 09G | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706323458769 40.771319603426505) | ||||
954 | 954 | -73.96584435488221 | 40.7796704898979 | 19F-AM-1007-03 | 19F | AM | 10072018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | scared | POINT (-73.9658443548822 40.7796704898979) | ||||
1068 | 1068 | -73.96660639702 | 40.7756655031741 | 14H-AM-1007-03 | 14H | AM | 10072018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96660639702002 40.7756655031741) | ||||
1272 | 1272 | -73.9595717225279 | 40.7829872498299 | 25I-PM-1007-03 | 25I | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9595717225279 40.7829872498299) | |||||
1311 | 1311 | -73.9694169352433 | 40.774440829385796 | 12G-PM-1007-03 | 12G | PM | 10072018 | 3 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | bushes | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | friendly | POINT (-73.9694169352433 40.7744408293858) | |||
1326 | 1326 | -73.9747288122551 | 40.7659918747507 | 2G-PM-1007-03 | 02G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9747288122551 40.7659918747507) | ||||
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) | ||||
1494 | 1494 | -73.95257524081691 | 40.7954915417553 | 39H-AM-1007-03 | 39H | AM | 10072018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9525752408169 40.7954915417553) | ||||
1513 | 1513 | -73.96624099976421 | 40.789104293543204 | 28A-PM-1007-03 | 28A | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | chasing #2 took #2 food wrapper and is foraging through it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662409997642 40.7891042935432) | |||
1616 | 1616 | -73.9642666013207 | 40.7810384867375 | 21G-PM-1007-03 | 21G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.96426660132072 40.7810384867375) | ||||
1658 | 1658 | -73.9736016229655 | 40.772378137671396 | 8D-AM-1007-03 | 08D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran up tree when approached | POINT (-73.9736016229655 40.77237813767141) | ||||
1750 | 1750 | -73.9684806250183 | 40.7858776210151 | 24A-PM-1007-03 | 24A | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9684806250183 40.7858776210151) | |||||
1858 | 1858 | -73.9742010726136 | 40.769150169929 | 5F-AM-1007-03 | 05F | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742010726136 40.769150169929006) | ||||
1914 | 1914 | -73.9588714413332 | 40.7895787115444 | 31F-PM-1007-03 | 31F | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | white belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9588714413332 40.7895787115444) | |||
1968 | 1968 | -73.9699088881236 | 40.775277835162605 | 13F-AM-1007-03 | 13F | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9699088881236 40.7752778351626) | ||||
2184 | 2184 | -73.9694938608335 | 40.7745700102115 | 12F-PM-1007-03 | 12F | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694938608335 40.7745700102115) | ||||
2238 | 2238 | -73.95361987261741 | 40.798013510222795 | 41E-AM-1007-03 | 41E | AM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9536198726174 40.7980135102228) | |||||
2241 | 2241 | -73.95752586279659 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 10072018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9575258627966 40.787715550749) | |||||
2346 | 2346 | -73.9562177305881 | 40.798341327633096 | 41C-PM-1007-03 | 41C | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562177305881 40.7983413276331) | ||||
2413 | 2413 | -73.959701727877 | 40.790660026971004 | 32E-AM-1007-03 | 32E | AM | 10072018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.959701727877 40.790660026971) | |||||
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) | ||||
2491 | 2491 | -73.98069052596709 | 40.76811522108579 | 1A-AM-1007-03 | 01A | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | looking in bush | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9806905259671 40.7681152210858) | |||
2518 | 2518 | -73.9647219419257 | 40.781208440293206 | 20F-PM-1007-03 | 20F | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | gray on haunches white on tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9647219419257 40.7812084402932) | |||
2524 | 2524 | -73.9743877909071 | 40.7754706115974 | 11B-AM-1007-03 | 11B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743877909071 40.7754706115974) | |||||
2679 | 2679 | -73.9794481602391 | 40.770638572864 | 4A-AM-1007-03 | 04A | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9794481602391 40.770638572864) | ||||
2686 | 2686 | -73.97755714038921 | 40.766531658519796 | 1E-PM-1007-03 | 01E | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9775571403892 40.7665316585198) | |||||
2695 | 2695 | -73.962800448652 | 40.7915532640139 | 31B-PM-1007-03 | 31B | PM | 10072018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.962800448652 40.7915532640139) | ||||
2718 | 2718 | -73.9530587825442 | 40.7919087309222 | 36I-PM-1007-03 | 36I | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9530587825442 40.7919087309222) | |||||
2789 | 2789 | -73.96868007849409 | 40.77667390291379 | 15F-AM-1007-03 | 15F | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686800784941 40.7766739029138) | |||
2954 | 2954 | -73.9677474313377 | 40.7742119240825 | 12H-PM-1007-03 | 12H | PM | 10072018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | peanuts | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677474313377 40.7742119240825) |
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 );