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, Foraging, Kuks, Moans, Tail flags, Tail twitches, Indifferent
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45 | 45 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9579645940414 40.7918613498407) | ||||
143 | 143 | -73.9661361310677 | 40.7787872561177 | 18G-PM-1013-01 | 18G | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9661361310677 40.7787872561177) | |||
170 | 170 | -73.95972059663241 | 40.7969409510133 | 38B-AM-1019-01 | 38B | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9597205966324 40.7969409510133) | ||||
342 | 342 | -73.9605966636226 | 40.788984910863704 | 30E-AM-1008-01 | 30E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | scurried into bushes when jogger ran by | POINT (-73.9605966636226 40.7889849108637) | |||
365 | 365 | -73.9576035072364 | 40.7966120824816 | 38C-AM-1019-01 | 38C | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (lawnmower) | POINT (-73.9576035072364 40.7966120824816) | |||
383 | 383 | -73.9588358879692 | 40.7912631913057 | 33E-PM-1012-01 | 33E | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588358879692 40.7912631913057) | ||||
386 | 386 | -73.95503513809571 | 40.7974681522214 | 40E-AM-1014-01 | 40E | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9550351380957 40.7974681522214) | ||||
410 | 410 | -73.9584024936392 | 40.785149170194394 | 27I-PM-1020-01 | 27I | PM | 10202018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | runs from (us) | POINT (-73.9584024936392 40.7851491701944) | |||
601 | 601 | -73.9522291603405 | 40.7976985385835 | 42G-PM-1014-01 | 42G | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 8 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9522291603405 40.7976985385835) | ||||
643 | 643 | -73.976730206737 | 40.773709213913996 | 8A-PM-1014-01 | 08A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | |||
855 | 855 | -73.9808247660048 | 40.76894088312871 | 2A-PM-1019-01 | 02A | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | runs from | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9808247660048 40.7689408831287) | |||
865 | 865 | -73.9741621946917 | 40.775248147202504 | 11C-PM-1018-01 | 11C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9741621946917 40.7752481472025) | ||||
929 | 929 | -73.97386112577159 | 40.773724677958704 | 10D-AM-1008-01 | 10D | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9738611257716 40.7737246779587) | ||||
996 | 996 | -73.9703149829421 | 40.778558363032296 | 16D-AM-1007-01 | 16D | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9703149829421 40.7785583630323) | ||||
1107 | 1107 | -73.95307395621309 | 40.7932034409546 | 37H-PM-1006-01 | 37H | PM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | from voice | POINT (-73.95307395621312 40.7932034409546) | |||
1305 | 1305 | -73.9569324958684 | 40.7877748374259 | 30I-PM-1006-01 | 30I | PM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | sitting there | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569324958684 40.78777483742591) | |||
1315 | 1315 | -73.9595955824812 | 40.793304794353396 | 34D-PM-1007-01 | 34D | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9595955824812 40.7933047943534) | ||||
1534 | 1534 | -73.9695226023739 | 40.7797527775804 | 17D-AM-1008-01 | 17D | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9695226023739 40.7797527775804) | ||||
1707 | 1707 | -73.96045242711669 | 40.7956624328733 | 36B-AM-1013-01 | 36B | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9604524271167 40.7956624328733) | ||||
1825 | 1825 | -73.9624209799704 | 40.79102009727521 | 31C-PM-1010-01 | 31C | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9624209799704 40.7910200972752) | ||||
1911 | 1911 | -73.9528937660465 | 40.7922919074537 | 36I-AM-1017-01 | 36I | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | runs from (me!)—from a pretty big distance | POINT (-73.9528937660465 40.7922919074537) | |||
2105 | 2105 | -73.9738723117119 | 40.7786845612246 | 14A-AM-1014-01 | 14A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | foraging?,crossing road | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | runs from (dogs) | POINT (-73.9738723117119 40.7786845612246) | ||
2278 | 2278 | -73.96453903109901 | 40.78099163100121 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.964539031099 40.7809916310012) | ||||
2406 | 2406 | -73.9668964315686 | 40.777757799088604 | 16G-AM-1010-01 | 16G | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9668964315686 40.7777577990886) | ||||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9712187890707 40.7750640173134) | ||||
2997 | 2997 | -73.96197353854829 | 40.7944667974974 | 35A-PM-1013-01 | 35A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9619735385483 40.7944667974974) | ||||
102 | 102 | -73.95759861613641 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575986161364 40.799368134968) | ||
27 | 27 | -73.9670628558161 | 40.7734991420941 | 12I-AM-1013-01 | 12I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on tree roots | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9670628558161 40.77349914209411) |
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 );