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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
914 | 914 | -73.9760801742337 | 40.7674218954729 | 3E-AM-1006-04 | 03E | AM | 10062018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9760801742337 40.7674218954729) | |||||
1043 | 1043 | -73.9758564394842 | 40.7674758942811 | 3E-AM-1006-05 | 03E | AM | 10062018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9758564394842 40.7674758942811) | |||||
1243 | 1243 | -73.97455562298549 | 40.767292104099795 | 3F-AM-1006-07 | 03F | AM | 10062018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | close to tall tree & light post | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745556229855 40.7672921040998) | |||
2289 | 2289 | -73.97458005923929 | 40.767356541975005 | 3F-AM-1006-08 | 03F | AM | 10062018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | close to tall tree & light post | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745800592393 40.767356541975) | |||
570 | 570 | -73.9745227769788 | 40.7673618284782 | 3F-AM-1006-09 | 03F | AM | 10062018 | 9 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | in grass by light post | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745227769788 40.76736182847821) | |||
2671 | 2671 | -73.97433690682541 | 40.7675726965985 | 3F-AM-1006-11 | 03F | AM | 10062018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9743369068254 40.7675726965985) | ||||
2547 | 2547 | -73.9743393747021 | 40.767634679832504 | 3F-AM-1006-12 | 03F | AM | 10062018 | 12 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9743393747021 40.7676346798325) | ||||
1756 | 1756 | -73.9755041276839 | 40.7678213857557 | 3F-AM-1006-13 | 03F | AM | 10062018 | 13 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9755041276839 40.7678213857557) | ||||
2420 | 2420 | -73.95877875927509 | 40.7981699014259 | 40A-AM-1010-01 | 40A | AM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 30 | bottom of great hill | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | climbing up a tree | POINT (-73.9587787592751 40.7981699014259) | |||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.958535640774 40.7982737896998) | ||||
53 | 53 | -73.95849706432129 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9584970643213 40.7982886348696) | ||||
1591 | 1591 | -73.95762233900821 | 40.79797466396471 | 40B-AM-1019-04 | 40B | AM | 10192018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9576223390082 40.79797466396471) | ||||
1540 | 1540 | -73.957710975899 | 40.79840556140471 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.957710975899 40.7984055614047) | ||||
2168 | 2168 | -73.95823634371351 | 40.7987752300505 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9582363437135 40.7987752300505) | ||||
525 | 525 | -73.952526164386 | 40.796375924050395 | 40G-AM-1007-02 | 40G | AM | 10072018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 18 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.952526164386 40.7963759240504) | ||||
2033 | 2033 | -73.9500167570283 | 40.7966185836685 | 41I-AM-1018-01 | 41I | AM | 10182018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | cautious,observant,runs off | POINT (-73.9500167570283 40.7966185836685) | |||
442 | 442 | -73.9502466289084 | 40.795922877988296 | 41I-AM-1018-02 | 41I | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | runs off | POINT (-73.9502466289084 40.7959228779883) | ||||
846 | 846 | -73.95826439540551 | 40.800046006127204 | 42A-AM-1019-01 | 42A | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95826439540551 40.8000460061272) | ||||
2300 | 2300 | -73.9789251806378 | 40.7699558513225 | 4B-AM-1010-02 | 04B | AM | 10102018 | 2 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 30 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9789251806378 40.7699558513225) | ||||
483 | 483 | -73.9789952029637 | 40.7697758333099 | 4B-AM-1010-03 | 04B | AM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9789952029637 40.7697758333099) | ||||
2221 | 2221 | -73.9771847728747 | 40.769597116498105 | 4C-AM-1006-01 | 04C | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771847728747 40.7695971164981) | ||||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9773079154219 40.7696506688861) | ||||
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) | |||||
1709 | 1709 | -73.9771696835698 | 40.76970111004871 | 4C-AM-1006-04 | 04C | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771696835698 40.7697011100487) | ||||
2854 | 2854 | -73.9772908667333 | 40.7697207404744 | 4C-AM-1006-05 | 04C | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772908667333 40.7697207404744) | ||||
1783 | 1783 | -73.9730001080547 | 40.7678719218983 | 4G-AM-1006-05 | 04G | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent—was in front of my face (we were on a bridge)! | POINT (-73.9730001080547 40.7678719218983) | ||
2783 | 2783 | -73.97917671562679 | 40.7714445258765 | 5A-AM-1006-02 | 05A | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | in tall shrubs near wall next to CPW | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9791767156268 40.7714445258765) | |||
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) | |||||
2425 | 2425 | -73.9791141532217 | 40.7714888835416 | 5A-AM-1006-04 | 05A | AM | 10062018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9791141532217 40.77148888354161) | ||||
896 | 896 | -73.9755055978764 | 40.77074386817421 | 6D-AM-1008-02 | 06D | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755055978764 40.7707438681742) | |||||
2334 | 2334 | -73.97549229705109 | 40.7707686392991 | 6D-AM-1008-03 | 06D | AM | 10082018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9754922970511 40.7707686392991) | |||||
2207 | 2207 | -73.9748943397482 | 40.770399256427204 | 6E-AM-1014-01 | 06E | AM | 10142018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9748943397482 40.7703992564272) | ||||
1215 | 1215 | -73.9728895595977 | 40.769937833229896 | 6F-AM-1006-01 | 06F | AM | 10062018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9728895595977 40.7699378332299) | ||||
56 | 56 | -73.97246424363941 | 40.7690526441109 | 6G-AM-1008-02 | 06G | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | bush | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9724642436394 40.7690526441109) | ||||
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) | ||
1470 | 1470 | -73.97248065806379 | 40.771007720613206 | 7F-AM-1008-15 | 07F | AM | 10082018 | 15 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9724806580638 40.7710077206132) | |||||
98 | 98 | -73.9730277911422 | 40.771214548882796 | 7F-AM-1008-16 | 07F | AM | 10082018 | 16 | Juvenile | Gray | Gray+ | Above Ground | 2 | tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9730277911422 40.7712145488828) | ||||
993 | 993 | -73.97724226646571 | 40.773436329163 | 8A-AM-1013-02 | 08A | AM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | playground | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9772422664657 40.773436329163) | |||
222 | 222 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | ||||
1623 | 1623 | -73.97701191330229 | 40.773294909000505 | 8A-AM-1013-04 | 08A | AM | 10132018 | 4 | Juvenile | + | Above Ground | 4 | fence | 1 | 1 | 0 | 1 | 1 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770119133023 40.7732949090005) | ||||
943 | 943 | -73.9773096718574 | 40.773805386248895 | 8A-AM-1013-06 | 08A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9773096718574 40.7738053862489) | ||||
1217 | 1217 | -73.9764850086767 | 40.7737340720562 | 8B-AM-1007-07 | 08B | AM | 10072018 | 7 | Juvenile | Gray | Black | Gray+Black | Above Ground | 8 | 0 | 0 | 0 | 1 | 0 | holding nut | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9764850086767 40.7737340720562) | |||
2065 | 2065 | -73.9768411547701 | 40.7741377018895 | 9A-AM-1013-03 | 09A | AM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768411547701 40.7741377018895) | ||||
654 | 654 | -73.976769659152 | 40.7741908010484 | 9A-AM-1013-04 | 09A | AM | 10132018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.976769659152 40.7741908010484) | ||||
1705 | 1705 | -73.97654172820009 | 40.7740994735325 | 9A-AM-1013-05 | 09A | AM | 10132018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765417282001 40.7740994735325) | ||||
2845 | 2845 | -73.9765016413674 | 40.77406728629529 | 9A-AM-1013-06 | 09A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765016413674 40.7740672862953) | ||||
1212 | 1212 | -73.9761792189352 | 40.7745745517215 | 9A-AM-1013-09 | 09A | AM | 10132018 | 9 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761792189352 40.7745745517215) | |||||
1354 | 1354 | -73.97652692820591 | 40.774687663524794 | 9A-AM-1013-10 | 09A | AM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9765269282059 40.7746876635248) | ||||
596 | 596 | -73.9769319450348 | 40.7743883576247 | 9A-AM-1013-11 | 09A | AM | 10132018 | 11 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | foot of tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9769319450348 40.7743883576247) | |||
2919 | 2919 | -73.9768563402344 | 40.7744487310786 | 9A-AM-1013-12 | 09A | AM | 10132018 | 12 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | foot of tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768563402344 40.7744487310786) | |||
1714 | 1714 | -73.9763542780331 | 40.773653130362206 | 9B-AM-1010-02 | 09B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | in bush | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | froze | POINT (-73.9763542780331 40.773653130362206) | ||
2144 | 2144 | -73.975198284551 | 40.7740343763399 | 9B-AM-1010-06 | 09B | AM | 10102018 | 6 | Juvenile | Gray | White | Gray+White | Above Ground | 16 | tree | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975198284551 40.7740343763399) |
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 );