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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
823 | 823 | -73.954595058342 | 40.7956567934304 | 39F-AM-1014-04 | 39F | AM | 10142018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.954595058342 40.7956567934304) | ||||
1006 | 1006 | -73.96862962178929 | 40.771812308875 | 10H-AM-1014-02 | 10H | AM | 10142018 | 2 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686296217893 40.771812308875) | |||||
1021 | 1021 | -73.97186968288 | 40.778926988884 | 15B-AM-1014-03 | 15B | AM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | running (from a dog) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97186968288 40.778926988884) | |||
1394 | 1394 | -73.95488263914001 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 10142018 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2 | up/down tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95488263914 40.7959474571251) | ||||
1395 | 1395 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 10142018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9710801547498 40.7760872452093) | ||||
1397 | 1397 | -73.9655233748105 | 40.7792737287734 | 18G-AM-1014-01 | 18G | AM | 10142018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | looking | POINT (-73.9655233748105 40.7792737287734) | |||
1482 | 1482 | -73.95886101956991 | 40.7945269936639 | 36C-AM-1014-02 | 36C | AM | 10142018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Crossing path | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9588610195699 40.7945269936639) | |||
1630 | 1630 | -73.9710025484537 | 40.7792529489016 | 16C-AM-1014-01 | 16C | AM | 10142018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 40 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710025484537 40.7792529489016) | |||||
2028 | 2028 | -73.96873477318609 | 40.7718955594385 | 10H-AM-1014-03 | 10H | AM | 10142018 | 3 | Juvenile | + | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687347731861 40.7718955594385) | ||||||
2061 | 2061 | -73.9608834102446 | 40.790624710005005 | 31D-AM-1014-05 | 31D | AM | 10142018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9608834102446 40.790624710005) | ||||
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) | ||||
2303 | 2303 | -73.9589470461357 | 40.7912817646361 | 33E-AM-1014-10 | 33E | AM | 10142018 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589470461357 40.7912817646361) | ||||
2641 | 2641 | -73.96155167034941 | 40.790521938835894 | 31D-AM-1014-04 | 31D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Open ground | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9615516703494 40.7905219388359) | ||||
2653 | 2653 | -73.958932543729 | 40.7913445531266 | 33E-AM-1014-11 | 33E | AM | 10142018 | 11 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958932543729 40.7913445531266) | ||||
2754 | 2754 | -73.9687025912431 | 40.7719319822619 | 10H-AM-1014-04 | 10H | AM | 10142018 | 4 | Juvenile | + | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687025912431 40.7719319822619) | ||||||
2763 | 2763 | -73.96260656728941 | 40.788722645116 | 29D-AM-1014-03 | 29D | AM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 35 | End of tree limb foraging | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9626065672894 40.788722645116) | ||||
743 | 743 | -73.9565035705619 | 40.7937382705056 | 36F-AM-1017-04 | 36F | AM | 10172018 | 4 | Juvenile | Gray | White | Gray+White | White legs, front & back | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | approaches (me),runs from (me) | POINT (-73.9565035705619 40.7937382705056) | ||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674631254594 40.7790076357696) | ||||
1777 | 1777 | -73.9711751356843 | 40.775242275820204 | 12E-AM-1017-06 | 12E | AM | 10172018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711751356843 40.7752422758202) | ||||
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) | ||||
467 | 467 | -73.95797241199429 | 40.794870990001606 | 37D-AM-1018-01 | 37D | AM | 10182018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579724119943 40.7948709900016) | ||||
488 | 488 | -73.9615751148595 | 40.795455123814605 | 36A-AM-1018-01 | 36A | AM | 10182018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615751148595 40.7954551238146) | |||
777 | 777 | -73.96542102635209 | 40.7782529692575 | 17G-AM-1018-01 | 17G | AM | 10182018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9654210263521 40.77825296925751) | |||||
1061 | 1061 | -73.9532657715601 | 40.7949046809422 | 39G-AM-1018-02 | 39G | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 25 | Tree | 0 | 0 | 0 | 0 | 0 | sitting & watching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532657715601 40.7949046809422) | |||
1203 | 1203 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9616999731028 40.7954126939561) | |||
1528 | 1528 | -73.9690104245067 | 40.7853358193723 | 23A-AM-1018-02 | 23A | AM | 10182018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690104245067 40.7853358193723) | |||||
1620 | 1620 | -73.96356061997841 | 40.782206970617 | 22G-AM-1018-03 | 22G | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9635606199784 40.782206970617) | ||||
1737 | 1737 | -73.9640741640547 | 40.7807274581426 | 20G-AM-1018-01 | 20G | AM | 10182018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 7 | Tree limb | 0 | 0 | 0 | 0 | 0 | sitting still on limb | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9640741640547 40.7807274581426) | |||
1978 | 1978 | -73.9579689996645 | 40.794933848991704 | 37D-AM-1018-02 | 37D | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579689996645 40.7949338489917) | ||||
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) | |||
2599 | 2599 | -73.96898934126929 | 40.785308737683 | 23A-AM-1018-03 | 23A | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | Tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689893412693 40.785308737683) | |||
2941 | 2941 | -73.96902666603171 | 40.7853134751509 | 23A-AM-1018-01 | 23A | AM | 10182018 | 1 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690266660317 40.7853134751509) | |||||
6 | 6 | -73.9565700386162 | 40.7902561000937 | 33H-AM-1019-02 | 33H | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | wrestling with mother | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565700386162 40.7902561000937) | |||
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) | ||||
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) | ||||
187 | 187 | -73.9700162034073 | 40.7815277479588 | 19B-AM-1019-02 | 19B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | posing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | indifferent then runs from | POINT (-73.9700162034073 40.7815277479588) | ||
365 | 365 | -73.9576035072364 | 40.7966120824816 | 38C-AM-1019-01 | 38C | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (lawnmower) | POINT (-73.9576035072364 40.7966120824816) | |||
693 | 693 | -73.969353372175 | 40.7838247422369 | 21A-AM-1019-06 | 21A | AM | 10192018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969353372175 40.7838247422369) | |||||
804 | 804 | -73.9697196619878 | 40.7814068507607 | 19B-AM-1019-01 | 19B | AM | 10192018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Side stripes | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | indifferent then runs from | POINT (-73.9697196619878 40.7814068507607) | ||
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) | ||||
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) | ||||
1583 | 1583 | -73.97010303935059 | 40.7838953063625 | 21A-AM-1019-04 | 21A | AM | 10192018 | 4 | Juvenile | Gray | Black | Gray+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701030393506 40.7838953063625) | ||||
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) | ||||
1653 | 1653 | -73.9695881075086 | 40.7842441291991 | 21A-AM-1019-01 | 21A | AM | 10192018 | 1 | Juvenile | Gray | Black | Gray+Black | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | keeps to tree,drops down on side away from people | POINT (-73.9695881075086 40.7842441291991) | |||
1759 | 1759 | -73.9576219570858 | 40.79633512256721 | 38C-AM-1019-03 | 38C | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9576219570858 40.7963351225672) | ||||
1885 | 1885 | -73.9594174605642 | 40.7973128653773 | 38B-AM-1019-02 | 38B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594174605642 40.7973128653773) | ||||
1907 | 1907 | -73.9689227467959 | 40.783754160749396 | 21B-AM-1019-03 | 21B | AM | 10192018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689227467959 40.7837541607494) | ||||
1943 | 1943 | -73.9690447463294 | 40.783913304529 | 21B-AM-1019-06 | 21B | AM | 10192018 | 6 | Juvenile | Gray | Gray+ | Above Ground | 7 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690447463294 40.78391330452901) | |||||
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) | ||||
2657 | 2657 | -73.9582150734453 | 40.7962862794303 | 38C-AM-1019-08 | 38C | AM | 10192018 | 8 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9582150734453 40.7962862794303) | ||||
2736 | 2736 | -73.95938952535009 | 40.797308584408704 | 38B-AM-1019-03 | 38B | AM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9593895253501 40.7973085844087) | |||||
2841 | 2841 | -73.9693262952166 | 40.783260411082004 | 21B-AM-1019-01 | 21B | AM | 10192018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693262952166 40.783260411082) |
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 );