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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2029 | 2029 | -73.9687213827744 | 40.7843586374648 | 22B-PM-1014-02 | 22B | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687213827744 40.7843586374648) | ||||
2038 | 2038 | -73.98035621370491 | 40.7685780990634 | 2B-AM-1010-02 | 02B | AM | 10102018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9803562137049 40.7685780990634) | |||||
2112 | 2112 | -73.9655206571055 | 40.7764851568746 | 16H-PM-1014-02 | 16H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9655206571055 40.7764851568746) | ||||
2136 | 2136 | -73.97218979152109 | 40.7660434203132 | 3I-AM-1010-02 | 03I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721897915211 40.76604342031321) | |||||
2225 | 2225 | -73.95623234556741 | 40.7946180656349 | 37E-AM-1013-02 | 37E | AM | 10132018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9562323455674 40.79461806563491) | |||||
2263 | 2263 | -73.95693753558841 | 40.793539800861204 | 36E-AM-1013-02 | 36E | AM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569375355884 40.7935398008612) | |||||
2280 | 2280 | -73.97671436441509 | 40.76847569413211 | 3D-AM-1006-02 | 03D | AM | 10062018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 25 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767143644151 40.7684756941321) | |||
2307 | 2307 | -73.9736997033862 | 40.778497952406 | 14A-PM-1014-02 | 14A | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9736997033862 40.778497952406) | ||||
2318 | 2318 | -73.967458693983 | 40.7769922522105 | 15G-AM-1008-02 | 15G | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.967458693983 40.7769922522105) | |||||
2320 | 2320 | -73.9576897478787 | 40.796469532845705 | 38C-AM-1019-02 | 38C | AM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9576897478787 40.7964695328457) | ||||
2391 | 2391 | -73.9721497679014 | 40.771616019938605 | 8F-PM-1012-02 | 08F | PM | 10122018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9721497679014 40.7716160199386) | |||||
2394 | 2394 | -73.97858295460459 | 40.7719652299132 | 6A-PM-1012-02 | 06A | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785829546046 40.7719652299132) | ||||
2426 | 2426 | -73.9790203973636 | 40.768883711483205 | 3B-AM-1010-02 | 03B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | together w/ #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9790203973636 40.7688837114832) | |||
2444 | 2444 | -73.966590487009 | 40.780246905289104 | 19E-PM-1018-02 | 19E | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.96659048700901 40.7802469052891) | ||||
2457 | 2457 | -73.9569896638974 | 40.7911914507504 | 33G-PM-1006-02 | 33G | PM | 10062018 | 2 | Adult | Gray | Gray+ | my favorite | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | engaged w/ me | POINT (-73.9569896638974 40.7911914507504) | |||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9595222999173 40.7833202577782) | |||
2490 | 2490 | -73.9693876553956 | 40.7707232748402 | 8I-AM-1006-02 | 08I | AM | 10062018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693876553956 40.7707232748402) | ||||
2543 | 2543 | -73.96914249979191 | 40.780542852496 | 18C-AM-1018-02 | 18C | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691424997919 40.780542852496) | ||||
2557 | 2557 | -73.97124542516791 | 40.7674262749891 | 5I-PM-1008-02 | 05I | PM | 10082018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | crossing pavement in front of arsenal | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9712454251679 40.7674262749891) | ||||
2564 | 2564 | -73.970996228532 | 40.7715540712285 | 9G-PM-1007-02 | 09G | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.970996228532 40.7715540712285) | ||||
2611 | 2611 | -73.951448051873 | 40.7973951649254 | 42G-AM-1018-02 | 42G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.951448051873 40.7973951649254) | |||||
2632 | 2632 | -73.95082755733499 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.950827557335 40.797579073666) | ||||
2639 | 2639 | -73.9543832609857 | 40.795355063970106 | 39F-AM-1014-02 | 39F | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | rocks | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9543832609857 40.7953550639701) | |||
2670 | 2670 | -73.95310419064691 | 40.7919916819219 | 36I-PM-1007-02 | 36I | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | chased birds (blue jay) | POINT (-73.9531041906469 40.7919916819219) | ||||
2688 | 2688 | -73.9799302952205 | 40.767720720979796 | 1B-PM-1019-02 | 01B | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799302952205 40.7677207209798) | ||||
2698 | 2698 | -73.9744917362668 | 40.77783887377 | 13A-AM-1017-02 | 13A | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744917362668 40.77783887377) | |||||
2699 | 2699 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.97435094238212 40.7690043677328) | ||||
2705 | 2705 | -73.9748962681637 | 40.76787782717 | 4F-PM-1013-02 | 04F | PM | 10132018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9748962681637 40.76787782717) | ||||
2727 | 2727 | -73.974596903918 | 40.7765498215674 | 12A-PM-1013-02 | 12A | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.974596903918 40.7765498215674) | ||||
2785 | 2785 | -73.9729105002306 | 40.7672758037086 | 4H-PM-1006-02 | 04H | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729105002306 40.7672758037086) | ||||
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) | |||||
2807 | 2807 | -73.9618213644671 | 40.792764881973795 | 33B-AM-1010-02 | 33B | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.96182136446711 40.7927648819738) | |||||
2808 | 2808 | -73.9765027953575 | 40.7717327360835 | 7C-AM-1012-02 | 07C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping around | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765027953575 40.7717327360835) | |||
2818 | 2818 | -73.9681664642028 | 40.77246696819579 | 11I-PM-1012-02 | 11I | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 4 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs away from the ball | POINT (-73.9681664642028 40.7724669681958) | ||||
2829 | 2829 | -73.95652309635541 | 40.798556387711 | 41C-PM-1007-02 | 41C | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565230963554 40.798556387711) | ||||
2838 | 2838 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 10182018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507699667119 40.795516603955505) | |||||
2881 | 2881 | -73.9541629063295 | 40.7934259301577 | 37G-AM-1014-02 | 37G | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | ran away & disappeared | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9541629063295 40.7934259301577) | ||||
2886 | 2886 | -73.9729265300533 | 40.774176829164205 | 10D-AM-1008-02 | 10D | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9729265300533 40.7741768291642) | ||||
2904 | 2904 | -73.97203897567171 | 40.7763524091989 | 13C-PM-1019-02 | 13C | PM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720389756717 40.7763524091989) | |||||
2947 | 2947 | -73.96012151981141 | 40.7909769801241 | 32D-PM-1006-02 | 32D | PM | 10062018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9601215198114 40.7909769801241) | ||||
2949 | 2949 | -73.9651206201297 | 40.778527906484705 | 18G-AM-1014-02 | 18G | AM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9651206201297 40.7785279064847) | ||||
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) | |||
2999 | 2999 | -73.972415182837 | 40.773080463452004 | 10E-AM-1010-02 | 10E | AM | 10102018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.972415182837 40.773080463452) |
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 );