This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2485 | 2485 | -73.9584950620879 | 40.790277071064295 | 32F-PM-1008-03 | 32F | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584950620879 40.7902770710643) | ||||
2489 | 2489 | -73.9663168490265 | 40.7825083721362 | 21D-AM-1008-01 | 21D | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9663168490265 40.7825083721362) | ||||
2515 | 2515 | -73.9693338657183 | 40.775705588453796 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9693338657183 40.77570558845381) | |||
2563 | 2563 | -73.9664536611195 | 40.7827694131949 | 21D-AM-1008-03 | 21D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9664536611195 40.7827694131949) | |||||
2625 | 2625 | -73.96991885444591 | 40.7772180370053 | 15E-PM-1008-09 | 15E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699188544459 40.7772180370053) | |||||
2675 | 2675 | -73.9762227323096 | 40.768453603768 | 3E-PM-1008-02 | 03E | PM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9762227323096 40.768453603768) | ||||
2690 | 2690 | -73.9572840457971 | 40.788693337174394 | 31H-PM-1008-04 | 31H | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | Also way up | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95728404579711 40.7886933371744) | |||||
2786 | 2786 | -73.9683883750097 | 40.7754344396847 | 13G-PM-1008-01 | 13G | PM | 10082018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 20 | willow oak tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9683883750097 40.7754344396847) | ||||
2787 | 2787 | -73.9765306970303 | 40.769495687585895 | 4D-PM-1008-09 | 04D | PM | 10082018 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765306970303 40.7694956875859) | ||||||
2793 | 2793 | -73.9742847552668 | 40.7731740123046 | 9D-AM-1008-02 | 09D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9742847552668 40.7731740123046) | |||||
2831 | 2831 | -73.9753585157592 | 40.7698398607941 | 5E-AM-1008-07 | 05E | AM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | on fence | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9753585157592 40.7698398607941) | |||
2837 | 2837 | -73.9772691210241 | 40.7690960712994 | 4D-PM-1008-13 | 04D | PM | 10082018 | 13 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772691210241 40.7690960712994) | ||||
2850 | 2850 | -73.9744847446854 | 40.76924227444 | 5E-AM-1008-04 | 05E | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744847446854 40.76924227444) | |||||
2864 | 2864 | -73.9761879300037 | 40.7683918970301 | 3E-PM-1008-01 | 03E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761879300037 40.7683918970301) | |||||
2871 | 2871 | -73.9777124331985 | 40.7704051056666 | 5B-AM-1008-03 | 05B | AM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9777124331985 40.7704051056666) | ||||
2921 | 2921 | -73.9699573485164 | 40.7765857838015 | 14E-AM-1008-10 | 14E | AM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699573485164 40.7765857838015) | |||||
2952 | 2952 | -73.9763719445827 | 40.768955141333706 | 4D-PM-1008-04 | 04D | PM | 10082018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9763719445827 40.7689551413337) | ||||
2965 | 2965 | -73.9767389132988 | 40.7689323691424 | 4D-PM-1008-10 | 04D | PM | 10082018 | 10 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 6 | climbed the fence & posed for a picture | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9767389132988 40.7689323691424) | |||
2984 | 2984 | -73.9700158929437 | 40.7762359066591 | 14E-AM-1008-18 | 14E | AM | 10082018 | 18 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9700158929437 40.7762359066591) | |||||
3009 | 3009 | -73.9675637870968 | 40.782388067172796 | 21D-PM-1008-02 | 21D | PM | 10082018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675637870968 40.7823880671728) | |||||
1399 | 1399 | -73.970442878377 | 40.7763755560359 | 14E-AM-1008-22 | 14E | AM | 10082018 | 22 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970442878377 40.7763755560359) | ||||
2665 | 2665 | -73.969784066769 | 40.77669404054029 | 14E-AM-1008-11 | 14E | AM | 10082018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | curious | POINT (-73.969784066769 40.7766940405403) | ||
2775 | 2775 | -73.96971093983021 | 40.7776218260789 | 15E-PM-1008-06 | 15E | PM | 10082018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9697109398302 40.7776218260789) | ||||
303 | 303 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 10082018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | climbed fence staring at me - went up tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97623482246482 40.7694522315322) | |||
2648 | 2648 | -73.97294104880208 | 40.770948496457706 | 7F-AM-1008-13 | 07F | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 4 | to tree | 1 | 0 | 0 | 1 | 1 | ran up tree 4 feet and ate leaves | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729410488021 40.7709484964577) | |||
1094 | 1094 | -73.9773898301093 | 40.770858156205705 | 5B-AM-1008-01 | 05B | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | running across ball field 5,near home plate | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9773898301093 40.7708581562057) | |||
2749 | 2749 | -73.972967003211 | 40.7711848438157 | 7F-AM-1008-17 | 07F | AM | 10082018 | 17 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scratching self | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.972967003211 40.7711848438157) | ||||
2015 | 2015 | -73.9574365550758 | 40.7886924675052 | 31H-PM-1008-03 | 31H | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | no clue, way up a tree! | 0 | 0 | 1 | 0 | 1 | throwing down acorns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9574365550758 40.7886924675052) | ||||
22 | 22 | -73.9703925210471 | 40.7765032004992 | 14E-AM-1008-23 | 14E | AM | 10082018 | 23 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703925210471 40.7765032004992) | ||||
95 | 95 | -73.9692883970928 | 40.776855370308205 | 14E-AM-1008-02 | 14E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9692883970928 40.7768553703082) | ||||
466 | 466 | -73.97030871607099 | 40.7763985667344 | 14E-AM-1008-20 | 14E | AM | 10082018 | 20 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970308716071 40.7763985667344) | ||||
559 | 559 | -73.9704166194815 | 40.7766720346576 | 14E-AM-1008-07 | 14E | AM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704166194815 40.7766720346576) | ||||
1222 | 1222 | -73.9691420412059 | 40.777349258213796 | 15E-PM-1008-03 | 15E | PM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691420412059 40.7773492582138) | ||||
1322 | 1322 | -73.97018243765059 | 40.7763703306736 | 14E-AM-1008-21 | 14E | AM | 10082018 | 21 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | curious,but not expecting food | POINT (-73.9701824376506 40.7763703306736) | |||
2006 | 2006 | -73.9695641121727 | 40.7769562886685 | 14E-AM-1008-03 | 14E | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | unaware of | POINT (-73.9695641121727 40.7769562886685) | |||
2269 | 2269 | -73.9695518341907 | 40.776214599393704 | 14E-AM-1008-15 | 14E | AM | 10082018 | 15 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695518341907 40.7762145993937) |
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 );