This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions
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) | ||||
130 | 130 | -73.95816559494371 | 40.799770819002205 | 41A-PM-1007-06 | 41A | PM | 10072018 | 6 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9581655949437 40.7997708190022) | |||||
529 | 529 | -73.96352907511829 | 40.7820936628202 | 22G-AM-1018-02 | 22G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9635290751183 40.7820936628202) | |||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9650499507011 40.7908191782173) | ||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685227310735 40.776599466588) | |||
795 | 795 | -73.9582523503306 | 40.7996897499473 | 41A-PM-1007-05 | 41A | PM | 10072018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9582523503306 40.7996897499473) | ||||
837 | 837 | -73.9557172336815 | 40.79211256577221 | 35G-PM-1006-01 | 35G | PM | 10062018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9557172336815 40.7921125657722) | ||||
852 | 852 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | 1 | 0 | 1 | 0 | 0 | hopping | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | POINT (-73.9609704650925 40.7938786854735) | |||
858 | 858 | -73.96293834202741 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 10072018 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629383420274 40.7889383725489) | ||||
859 | 859 | -73.9600964585868 | 40.7952339524416 | 36B-PM-1013-02 | 36B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9600964585868 40.7952339524416) | ||||
869 | 869 | -73.96294833745279 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629483374528 40.7936809905265) | |||||
916 | 916 | -73.95618876244708 | 40.7958187455815 | 38E-AM-1010-04 | 38E | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | me | POINT (-73.95618876244711 40.7958187455815) | |||
1051 | 1051 | -73.96137470327021 | 40.7920483852431 | 33C-PM-1007-01 | 33C | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9613747032702 40.792048385243106) | |||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | ||||||
1079 | 1079 | -73.9722737593623 | 40.768963018754 | 6G-AM-1008-04 | 06G | AM | 10082018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | very long tail | Above Ground | 20 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9722737593623 40.768963018754) | ||
1081 | 1081 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 10072018 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9680855277775 40.7769251965381) | ||||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9775735077285 40.7692872082165) | |||
1328 | 1328 | -73.9765758043111 | 40.771380315403206 | 6C-AM-1007-03 | 06C | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 8 | another tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9765758043111 40.7713803154032) | |||
1381 | 1381 | -73.9586077039567 | 40.796189647707706 | 38C-AM-1019-10 | 38C | AM | 10192018 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586077039567 40.7961896477077) | ||||
1410 | 1410 | -73.95879132892291 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 10192018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9587913289229 40.7961707624534) | ||||
1426 | 1426 | -73.9664986446294 | 40.778308334318 | 17G-PM-1017-02 | 17G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9664986446294 40.778308334318) | |||||
1442 | 1442 | -73.961241953418 | 40.7941677113011 | 35B-PM-1013-07 | 35B | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | got fed twice by grandpa,grabbed from grass and ate in tree | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. | POINT (-73.961241953418 40.7941677113011) | |||
1484 | 1484 | -73.9716736557408 | 40.7749333494336 | 12E-AM-1017-07 | 12E | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9716736557408 40.7749333494336) | ||||
1594 | 1594 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9778730762957 40.770827251547) | |||||
1733 | 1733 | -73.9756345867747 | 40.7675540517649 | 3E-PM-1008-09 | 03E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9756345867747 40.7675540517649) | |||||
1754 | 1754 | -73.9652134469963 | 40.7803438278765 | 19F-PM-1017-05 | 19F | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9652134469963 40.7803438278765) | ||||
1767 | 1767 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 10142018 | 4 | Gray | White | Gray+White | Above Ground | 15 | Ground then tree to eat | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.958719099962 40.7947587726617) | ||||
1850 | 1850 | -73.975809362521 | 40.773470273783495 | 8B-PM-1012-09 | 08B | PM | 10122018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.975809362521 40.7734702737835) | ||||
1925 | 1925 | -73.95813898706442 | 40.7993081122523 | 41A-PM-1007-04 | 41A | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | laid down on the branch | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9581389870644 40.799308112252305) | ||||
2495 | 2495 | -73.9621253644004 | 40.7912082086879 | 31C-AM-1017-01 | 31C | AM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9621253644004 40.7912082086879) | ||||
2562 | 2562 | -73.9615643742864 | 40.7944678447843 | 35B-PM-1013-06 | 35B | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | chased by dog #2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9615643742864 40.7944678447843) | ||
2604 | 2604 | -73.9605163698302 | 40.7914179994956 | 32D-PM-1006-05 | 32D | PM | 10062018 | 5 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9605163698302 40.7914179994956) | ||||
2734 | 2734 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763629541474 40.7682321897044) | |||||
2776 | 2776 | -73.9789687905912 | 40.769269313932796 | 3B-PM-1007-04 | 03B | PM | 10072018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | At fence | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9789687905912 40.7692693139328) | |||
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) | ||||
2803 | 2803 | -73.9576652087316 | 40.787545797780105 | 29H-PM-1006-02 | 29H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9576652087316 40.7875457977801) | |||||
2811 | 2811 | -73.97568897660891 | 40.7676078308589 | 3F-AM-1006-14 | 03F | AM | 10062018 | 14 | Adult | Gray | White | Gray+White | Above Ground | 12 | 1 | 0 | 1 | 0 | 0 | running from dog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9756889766089 40.7676078308589) | |||
2820 | 2820 | -73.9615926031253 | 40.7944223235385 | 35B-PM-1013-05 | 35B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | chased by dog #2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.96159260312531 40.7944223235385) | |||
2968 | 2968 | -73.9587236619579 | 40.799185018043396 | 40A-AM-1010-02 | 40A | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park at 108th West | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9587236619579 40.7991850180434) | |||
2985 | 2985 | -73.9721159387757 | 40.766050318863705 | 3I-PM-1013-03 | 03I | PM | 10132018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9721159387757 40.7660503188637) |
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 );