This data as json, CSV (advanced)
Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | -73.9570437717691 | 40.7948509408039 | 37E-PM-1006-03 | 37E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | me | POINT (-73.9570437717691 40.794850940803904) | |||
207 | 207 | -73.9770824412252 | 40.770996130945704 | 5C-AM-1006-03 | 05C | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97708244122522 40.7709961309457) | ||||
223 | 223 | -73.9737091707831 | 40.771373256751204 | 7E-AM-1006-03 | 07E | AM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9737091707831 40.7713732567512) | ||||
254 | 254 | -73.9762246600197 | 40.775164077652 | 10A-AM-1006-03 | 10A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Bridle Path lawn | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9762246600197 40.775164077652) | ||||
331 | 331 | -73.95448101115 | 40.7954469678857 | 39F-PM-1006-03 | 39F | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | lower branch of tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran up tree when approached | POINT (-73.95448101115 40.7954469678857) | ||
335 | 335 | -73.97823514358521 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | POINT (-73.9782351435852 40.7715896672335) | |||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ran up tree | POINT (-73.959709414696 40.7919745085986) | |||||
395 | 395 | -73.9565686300382 | 40.797592846003 | 40C-PM-1006-03 | 40C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565686300382 40.797592846003) | |||||
418 | 418 | -73.9573604880421 | 40.7930844158021 | 35E-PM-1006-03 | 35E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9573604880421 40.7930844158021) | ||||
454 | 454 | -73.9752793195744 | 40.7733960128931 | 9C-AM-1006-03 | 09C | AM | 10062018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752793195744 40.7733960128931) | |||||
569 | 569 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9709040623777 40.7701163892686) | ||||
728 | 728 | -73.96029131055779 | 40.7910635810038 | 32D-PM-1006-03 | 32D | PM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602913105578 40.7910635810038) | ||||
757 | 757 | -73.9783185278595 | 40.7724861675504 | 7A-AM-1006-03 | 07A | AM | 10062018 | 3 | Adult | Gray | Gray+ | 3/4 length tail, hair loss | Above Ground | 20 | in trees, then to ground | 1 | 0 | 1 | 0 | 0 | jumping | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783185278595 40.7724861675504) | ||
774 | 774 | -73.9673603655908 | 40.787697417778205 | 26A-PM-1006-03 | 26A | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9673603655908 40.7876974177782) | |||||
825 | 825 | -73.9580105174865 | 40.7974468322692 | 39C-PM-1006-03 | 39C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9580105174865 40.7974468322692) | |||||
830 | 830 | -73.95956459625391 | 40.7899599350145 | 31E-PM-1006-03 | 31E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 1 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595645962539 40.7899599350145) | ||
961 | 961 | -73.9731457102903 | 40.7660255393205 | 2H-AM-1006-03 | 02H | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9731457102903 40.7660255393205) | ||||
1012 | 1012 | -73.9755569170561 | 40.7668006977526 | 2F-AM-1006-03 | 02F | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755569170561 40.7668006977526) | |||
1160 | 1160 | -73.97772569893621 | 40.766623699564 | 1E-AM-1006-03 | 01E | AM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9777256989362 40.766623699564) | |||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9790822606486 40.7714466633386) | |||||
1248 | 1248 | -73.9719729323923 | 40.7668318394546 | 4I-AM-1006-03 | 04I | AM | 10062018 | 3 | Adult | + | Can't tell :( | Above Ground | 28 | Tree | 0 | 0 | 1 | 0 | 0 | building nest! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9719729323923 40.7668318394546) | |||
1358 | 1358 | -73.9693772461788 | 40.770687589290105 | 8I-AM-1006-03 | 08I | AM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693772461788 40.7706875892901) | ||||
1542 | 1542 | -73.960876728048 | 40.790357245370004 | 31D-PM-1006-03 | 31D | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960876728048 40.79035724537) | ||||
1586 | 1586 | -73.9714150090362 | 40.7774976423922 | 14C-PM-1006-03 | 14C | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9714150090362 40.7774976423922) | ||||
1678 | 1678 | -73.95687265085459 | 40.7878795081255 | 30I-PM-1006-03 | 30I | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | up tree | POINT (-73.9568726508546 40.7878795081255) | ||||
1779 | 1779 | -73.9695560376915 | 40.7708835103516 | 9H-AM-1006-03 | 09H | AM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96955603769152 40.7708835103516) | ||||
1819 | 1819 | -73.9711378905748 | 40.7696218346333 | 7H-AM-1006-03 | 07H | AM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | on rock (large) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9711378905748 40.769621834633305) | ||||
1920 | 1920 | -73.95453837191879 | 40.7899711263765 | 33I-PM-1006-03 | 33I | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.95453837191882 40.7899711263765) | |||||
1931 | 1931 | -73.9533085932603 | 40.793487786107505 | 37H-PM-1006-03 | 37H | PM | 10062018 | 3 | + | Above Ground | 43 | tree | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9533085932603 40.7934877861075) | ||||||
2063 | 2063 | -73.95447632818859 | 40.7969645476349 | 40F-PM-1006-03 | 40F | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9544763281886 40.7969645476349) | ||||
2120 | 2120 | -73.9733905460282 | 40.7656337147768 | 2H-PM-1006-03 | 02H | PM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9733905460282 40.7656337147768) | |||||
2191 | 2191 | -73.9734108731087 | 40.767605139269705 | 4G-AM-1006-03 | 04G | AM | 10062018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9734108731087 40.7676051392697) | |||||
2197 | 2197 | -73.9672413354558 | 40.7838116138235 | 22C-PM-1006-03 | 22C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9672413354558 40.7838116138235) | |||||
2272 | 2272 | -73.9569670900695 | 40.7948792856813 | 37E-PM-1006-03 | 37E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | me | POINT (-73.9569670900695 40.794879285681304) | |||
2290 | 2290 | -73.95656457165641 | 40.795903994957705 | 38D-PM-1006-03 | 38D | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9565645716564 40.795903994957705) | ||||
2396 | 2396 | -73.9704339422613 | 40.77401495296439 | 11F-PM-1006-03 | 11F | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9704339422613 40.7740149529644) | |||||
2397 | 2397 | -73.9704592500888 | 40.772962887933005 | 10G-AM-1006-03 | 10G | AM | 10062018 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704592500888 40.772962887933) | |||
2403 | 2403 | -73.97778796352159 | 40.769359455673 | 4C-AM-1006-03 | 04C | AM | 10062018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9777879635216 40.769359455673) | |||||
2427 | 2427 | -73.97292974853309 | 40.767327854143794 | 4H-AM-1006-03 | 04H | AM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | met #4 while foraging and briefly tussled | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729297485331 40.7673278541438) | ||||
2539 | 2539 | -73.97810334484679 | 40.766672406621296 | 1D-AM-1006-03 | 01D | AM | 10062018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9781033448468 40.7666724066213) | ||||
2542 | 2542 | -73.9754802138871 | 40.773300804411996 | 9C-PM-1006-03 | 09C | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754802138871 40.773300804412) | ||||
2766 | 2766 | -73.95516398474659 | 40.790858199891 | 34H-PM-1006-03 | 34H | PM | 10062018 | 3 | Gray | White | Gray+White | white belly | Ground Plane | FALSE | Under Tupelo Tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9551639847466 40.790858199891) | |||
257 | 257 | -73.9773317054464 | 40.7684035996758 | 3D-AM-1006-03 | 03D | AM | 10062018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | on top [of] a big rock/boulder in the area | 1 | 0 | 1 | 0 | 0 | climbing (rock) | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (slightly),wary of humans | POINT (-73.9773317054464 40.76840359967581) | |
1289 | 1289 | -73.97246812695259 | 40.7743474675821 | 11D-PM-1006-03 | 11D | PM | 10062018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9724681269526 40.7743474675821) | ||||
1892 | 1892 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 10062018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9745908987975 40.7655191512308) | ||||
2586 | 2586 | -73.9752965316933 | 40.775253857578896 | 10B-AM-1006-03 | 10B | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | In tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9752965316933 40.7752538575789) | ||||
2782 | 2782 | -73.9563473341712 | 40.7893712398425 | 32H-PM-1006-03 | 32H | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9563473341712 40.78937123984251) | ||||
2856 | 2856 | -73.9751615527833 | 40.767013871509 | 3F-AM-1006-03 | 03F | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | on the path | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9751615527833 40.767013871509) | ||
2928 | 2928 | -73.9767953468937 | 40.7676376977667 | 3E-AM-1006-03 | 03E | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | checkin' his stashes | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | POINT (-73.9767953468937 40.7676376977667) |
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 );