This data as json, CSV (advanced)
Suggested facets: Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Climbing, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts
These facets timed out: Running
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 | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1652 | 1652 | -73.9498421746221 | 40.7969397424182 | 42I-PM-1014-02 | 42I | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 8 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9498421746221 40.7969397424182) | 19 | 4 | 19 | 13 | |||||
1489 | 1489 | -73.9501762527462 | 40.7975534086077 | 42H-PM-1014-05 | 42H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9501762527462 40.7975534086077) | 12423 | 18 | 4 | 36 | 18 | ||||
3008 | 3008 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9503533343658 40.7976543603953) | 12423 | 18 | 4 | 36 | 18 | ||||
2632 | 2632 | -73.950827557335 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.950827557335 40.797579073666) | 18 | 4 | 36 | 18 | |||||
224 | 224 | -73.9520592496349 | 40.7975076299811 | 42G-PM-1014-03 | 42G | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | on fence | true | false | false | false | false | prancing | false | false | false | false | false | false | false | true | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
525 | 525 | -73.952526164386 | 40.7963759240504 | 40G-AM-1007-02 | 40G | AM | 10072018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 18 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.952526164386 40.7963759240504) | 19 | 4 | 19 | 13 | |||||
300 | 300 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 10172018 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10 | Running down tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9528149779809 40.7924984810637) | 19 | 4 | 19 | 13 | |||
2708 | 2708 | -73.9528429238071 | 40.7922651848867 | 36I-PM-1007-09 | 36I | PM | 10072018 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5 | true | true | false | false | false | burying nut | false | false | false | false | true | false | false | false | POINT (-73.9528429238071 40.7922651848867) | 19 | 4 | 19 | 13 | |||||
1464 | 1464 | -73.9532074573139 | 40.7934669464908 | 37H-PM-1006-06 | 37H | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | tree | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9532074573139 40.7934669464908) | 19 | 4 | 19 | 13 | ||||
2639 | 2639 | -73.9543832609857 | 40.7953550639701 | 39F-AM-1014-02 | 39F | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | rocks | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9543832609857 40.7953550639701) | 19 | 4 | 19 | 13 | ||||
284 | 284 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9547336666137 40.7938937756332) | 19 | 4 | 19 | 13 | |||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | true | false | true | false | true | true | true | false | false | false | false | true | false | POINT (-73.9547959269955 40.7925162926273) | 19 | 4 | 19 | 13 | ||||
1394 | 1394 | -73.95488263914 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 10142018 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2 | up/down tree | true | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.95488263914 40.7959474571251) | 19 | 4 | 19 | 13 | |||||
2247 | 2247 | -73.9559520137172 | 40.7950536287174 | 38E-AM-1010-06 | 38E | AM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | true | true | false | false | false | chasing and being chased by #7 | false | false | false | false | true | false | true | false | POINT (-73.95595201371721 40.7950536287174) | 19 | 4 | 19 | 13 | |||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | true | true | false | false | false | chasing and being chased by #6 | false | false | false | false | true | false | false | true | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
2242 | 2242 | -73.9565824187667 | 40.797312050952 | 40D-AM-1013-06 | 40D | AM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | false | true | false | true | true | false | false | false | true | false | false | true | POINT (-73.9565824187667 40.797312050952) | 19 | 4 | 19 | 13 | |||||
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9574648097543 40.78925084286221) | 19 | 4 | 19 | 13 | |||||
2803 | 2803 | -73.9576652087316 | 40.7875457977801 | 29H-PM-1006-02 | 29H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
45 | 45 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9579645940414 40.7918613498407) | 19 | 4 | 19 | 13 | |||||
1925 | 1925 | -73.9581389870644 | 40.7993081122523 | 41A-PM-1007-04 | 41A | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | laid down on the branch | false | false | false | false | false | false | false | true | POINT (-73.9581389870644 40.799308112252305) | 19 | 4 | 19 | 13 | |||||
2002 | 2002 | -73.9581706950566 | 40.7906321397269 | 32F-AM-1012-05 | 32F | AM | 10122018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9581706950566 40.7906321397269) | 19 | 4 | 19 | 13 | |||||
561 | 561 | -73.9581982486469 | 40.7992194575293 | 41A-PM-1007-03 | 41A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 55 | true | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.95819824864691 40.7992194575293) | 19 | 4 | 19 | 13 | |||||
2436 | 2436 | -73.95827701417 | 40.7856610238891 | 28I-PM-1007-01 | 28I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.95827701417 40.7856610238891) | 19 | 4 | 19 | 13 | ||||||
337 | 337 | -73.9583101927652 | 40.7852649316039 | 27I-PM-1020-05 | 27I | PM | 10202018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | In tree | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (us) | POINT (-73.9583101927652 40.7852649316039) | 19 | 4 | 19 | 13 | |||
1381 | 1381 | -73.9586077039567 | 40.7961896477077 | 38C-AM-1019-10 | 38C | AM | 10192018 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20 | true | false | true | true | false | true | false | false | false | true | false | false | true | POINT (-73.9586077039567 40.7961896477077) | 19 | 4 | 19 | 13 | |||||
1767 | 1767 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 10142018 | 4 | Gray | White | Gray+White | Above Ground | 15 | Ground then tree to eat | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
1410 | 1410 | -73.9587913289229 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 10192018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20 | true | false | true | true | false | true | false | false | false | true | false | false | true | POINT (-73.9587913289229 40.7961707624534) | 19 | 4 | 19 | 13 | |||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | true | true | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | true | true | false | false | false | false | false | false | true | true | false | true | false | POINT (-73.9595222999173 40.7833202577782) | 19 | 4 | 19 | 13 | ||||
369 | 369 | -73.9596398997228 | 40.7933386953847 | 34D-PM-1007-02 | 34D | PM | 10072018 | 2 | Adult | Black | Black+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | cautiously aware | POINT (-73.9596398997228 40.7933386953847) | 19 | 4 | 19 | 13 | |||||
2609 | 2609 | -73.9596865318094 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596865318094 40.7893787188526) | 19 | 4 | 19 | 13 | |||||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | true | false | false | true | false | false | false | false | false | true | false | false | true | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
1348 | 1348 | -73.9599197612389 | 40.7954836456006 | 36B-PM-1013-05 | 36B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9599197612389 40.7954836456006) | 19 | 4 | 19 | 13 | ||||||
1613 | 1613 | -73.9599202233536 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 10192018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9599202233536 40.7972599930224) | 19 | 4 | 19 | 13 | ||||||
2466 | 2466 | -73.9599419926299 | 40.7972774728811 | 38A-AM-1019-01 | 38A | AM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
1695 | 1695 | -73.9604083891356 | 40.7910284106931 | 32D-AM-1013-05 | 32D | AM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9604083891356 40.7910284106931) | 19 | 4 | 19 | 13 | |||||
2629 | 2629 | -73.9604576237503 | 40.7818120101394 | 23I-PM-1019-01 | 23I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | true | false | false | false | false | running (across branches) | false | false | false | false | false | false | false | false | POINT (-73.9604576237503 40.7818120101394) | 19 | 4 | 19 | 13 | |||||
852 | 852 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | true | false | true | false | false | hopping | false | false | false | false | false | true | false | true | POINT (-73.9609704650925 40.7938786854735) | 19 | 4 | 19 | 13 | ||||
1823 | 1823 | -73.9612854506075 | 40.7920830673571 | 32C-PM-1013-04 | 32C | PM | 10132018 | 4 | Juvenile | Gray | Gray+ | Above Ground | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
1576 | 1576 | -73.9619985187616 | 40.7943277743532 | 34A-AM-1012-02 | 34A | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | chasing from tree to ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9619985187616 40.7943277743532) | 19 | 4 | 19 | 13 | ||||
2652 | 2652 | -73.9620542514749 | 40.7943731722138 | 34A-AM-1012-01 | 34A | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | chasing from tree to ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9620542514749 40.7943731722138) | 19 | 4 | 19 | 13 | ||||
2495 | 2495 | -73.9621253644004 | 40.7912082086879 | 31C-AM-1017-01 | 31C | AM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | true | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9621253644004 40.7912082086879) | 19 | 4 | 19 | 13 | |||||
2913 | 2913 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9621297946132 40.7944058222814) | 19 | 4 | 19 | 13 | |||||
930 | 930 | -73.9622030085794 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
1516 | 1516 | -73.9625383795297 | 40.7883862331728 | 28D-AM-1012-03 | 28D | AM | 10122018 | 3 | Adult | Black | Black+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9625383795297 40.7883862331728) | 19 | 4 | 19 | 13 | ||||||
858 | 858 | -73.9629383420274 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 10072018 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10 | true | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9629383420274 40.7889383725489) | 19 | 4 | 19 | 13 | |||||
869 | 869 | -73.9629483374528 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9629483374528 40.7936809905265) | 19 | 4 | 19 | 13 | ||||||
1989 | 1989 | -73.9631646754647 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9631646754647 40.7925716810884) | 19 | 4 | 19 | 13 | ||||||
1147 | 1147 | -73.9631818528816 | 40.7925332194132 | 32A-AM-1018-01 | 32A | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9631818528816 40.7925332194132) | 19 | 4 | 19 | 13 | ||||||
1684 | 1684 | -73.9637824756607 | 40.7904737110761 | 30B-AM-1007-08 | 30B | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9637824756607 40.7904737110761) | 19 | 4 | 19 | 13 | ||||||
371 | 371 | -73.964080104186 | 40.7907898627287 | 30B-AM-1007-02 | 30B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.964080104186 40.7907898627287) | 19 | 4 | 19 | 13 | ||||||
480 | 480 | -73.9641293283734 | 40.7907654006019 | 30B-AM-1007-03 | 30B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641293283734 40.7907654006019) | 19 | 4 | 19 | 13 | ||||||
983 | 983 | -73.9641552070803 | 40.7908479527923 | 30B-AM-1007-05 | 30B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641552070803 40.7908479527923) | 19 | 4 | 19 | 13 | ||||||
1451 | 1451 | -73.9645365195454 | 40.7781531021263 | 18H-AM-1018-02 | 18H | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | true | true | false | false | false | playing? | false | false | false | false | false | false | false | false | POINT (-73.9645365195454 40.7781531021263) | 19 | 4 | 19 | 13 | ||||
528 | 528 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
1420 | 1420 | -73.9647605121306 | 40.7803961531517 | 20G-AM-1018-03 | 20G | AM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 12 | in tree | true | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9647605121306 40.7803961531517) | 19 | 4 | 19 | 13 | |||||
1046 | 1046 | -73.9647891228606 | 40.789853066039 | 29B-AM-1007-02 | 29B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.9647891228606 40.789853066039) | 19 | 4 | 19 | 13 | ||||||
771 | 771 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | Ran up tree | true | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9650499507011 40.7908191782173) | 19 | 4 | 19 | 13 | |||||
1487 | 1487 | -73.965394655961 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | burying the food on ground | false | false | false | false | false | false | false | false | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | 19 | 4 | 19 | 13 | ||||
620 | 620 | -73.9655905300923 | 40.7752614638023 | 14I-PM-1018-06 | 14I | PM | 10182018 | 6 | Adult | Cinnamon | Black | Cinnamon+Black | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9655905300923 40.7752614638023) | 19 | 4 | 19 | 13 | |||||
2157 | 2157 | -73.9657171357842 | 40.7773277532224 | 16H-PM-1014-05 | 16H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 5 | tree | true | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9657171357842 40.7773277532224) | 19 | 4 | 19 | 13 | ||||
2522 | 2522 | -73.9658747245917 | 40.7754033737532 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
462 | 462 | -73.9661785940531 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | climbed tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9661785940531 40.7742569936186) | 19 | 4 | 19 | 13 | ||||
2224 | 2224 | -73.9662310606968 | 40.7747758221226 | 14I-AM-1013-01 | 14I | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9662310606968 40.7747758221226) | 19 | 4 | 19 | 13 | |||||
1426 | 1426 | -73.9664986446294 | 40.778308334318 | 17G-PM-1017-02 | 17G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664986446294 40.778308334318) | 19 | 4 | 19 | 13 | ||||||
1182 | 1182 | -73.9667206046912 | 40.7779993565098 | 17G-PM-1017-04 | 17G | PM | 10172018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9667206046912 40.7779993565098) | 19 | 4 | 19 | 13 | ||||
2071 | 2071 | -73.9667694439895 | 40.7779501809095 | 17G-PM-1017-03 | 17G | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9667694439895 40.7779501809095) | 19 | 4 | 19 | 13 | ||||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670432105975 40.7753462013506) | 19 | 4 | 19 | 13 | |||||
1123 | 1123 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670858934045 40.7753505024976) | 19 | 4 | 19 | 13 | |||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
25 | 25 | -73.9671130680114 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24 | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9671130680114 40.7784859700171) | 19 | 4 | 19 | 13 | |||||
610 | 610 | -73.9671549566066 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 180 | top of tree | true | false | false | false | false | jumping between branches | false | false | false | false | false | false | true | false | POINT (-73.9671549566066 40.7751342870705) | 19 | 4 | 19 | 13 | ||||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
1163 | 1163 | -73.9677096985223 | 40.7825358361204 | 21C-AM-1014-02 | 21C | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 50 | true | true | true | false | true | false | true | false | false | false | false | false | false | looked at us from tree | POINT (-73.9677096985223 40.7825358361204) | 19 | 4 | 19 | 13 | ||||
237 | 237 | -73.967895656898 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
1235 | 1235 | -73.9679686793869 | 40.7825993867876 | 21C-AM-1014-01 | 21C | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | true | false | false | false | false | jumping back & forth on tree | false | false | false | true | true | false | true | false | POINT (-73.9679686793869 40.7825993867876) | 19 | 4 | 19 | 13 | ||||
1317 | 1317 | -73.9680522379372 | 40.772389813511 | 11I-PM-1012-06 | 11I | PM | 10122018 | 6 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9680522379372 40.772389813511) | 19 | 4 | 19 | 13 | ||||||
1081 | 1081 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 10072018 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680855277775 40.7769251965381) | 19 | 4 | 19 | 13 | |||||
889 | 889 | -73.9681042612938 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
1568 | 1568 | -73.9681079869821 | 40.7723494081345 | 11I-PM-1012-05 | 11I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681079869821 40.7723494081345) | 19 | 4 | 19 | 13 | ||||||
2818 | 2818 | -73.9681664642028 | 40.7724669681958 | 11I-PM-1012-02 | 11I | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 4 | true | false | true | false | true | false | false | false | false | false | false | false | true | runs away from the ball | POINT (-73.9681664642028 40.7724669681958) | 19 | 4 | 19 | 13 | |||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685227310735 40.776599466588) | 19 | 4 | 19 | 13 | ||||
602 | 602 | -73.9685751595485 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 10102018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1 | ran up tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
1006 | 1006 | -73.9686296217893 | 40.771812308875 | 10H-AM-1014-02 | 10H | AM | 10142018 | 2 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 6 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686296217893 40.771812308875) | 19 | 4 | 19 | 13 | ||||||
749 | 749 | -73.9686304581526 | 40.7773631337117 | 15E-PM-1008-01 | 15E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 4 | on fallen tree | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9686304581526 40.7773631337117) | 19 | 4 | 19 | 13 | |||||
2465 | 2465 | -73.9686999860219 | 40.7844014735136 | 22B-PM-1014-03 | 22B | PM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686999860219 40.7844014735136) | 19 | 4 | 19 | 13 | |||||
2029 | 2029 | -73.9687213827744 | 40.7843586374648 | 22B-PM-1014-02 | 22B | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687213827744 40.7843586374648) | 19 | 4 | 19 | 13 | |||||
1765 | 1765 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
1530 | 1530 | -73.9689305978751 | 40.7818152496266 | 19C-PM-1018-06 | 19C | PM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | Climbed fence | true | false | true | false | false | climbing (fence) | false | false | false | false | false | false | true | false | POINT (-73.9689305978751 40.7818152496266) | 19 | 4 | 19 | 13 | |||
1165 | 1165 | -73.9689504114652 | 40.7766770153764 | 14F-PM-1012-05 | 14F | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2 | on a fallen branch | true | false | false | true | false | sitting | false | false | false | false | false | false | false | false | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
2515 | 2515 | -73.9693338657183 | 40.7757055884538 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | true | false | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9693338657183 40.77570558845381) | 19 | 4 | 19 | 13 | ||||
797 | 797 | -73.969345754447 | 40.7770429650288 | 15E-AM-1013-02 | 15E | AM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.969345754447 40.7770429650288) | 19 | 4 | 19 | 13 | |||||
2694 | 2694 | -73.969628583287 | 40.7704067797932 | 8H-AM-1017-03 | 08H | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | fence | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.969628583287 40.7704067797932) | 19 | 4 | 19 | 13 | ||||
1179 | 1179 | -73.9696762034757 | 40.7704883494264 | 8H-AM-1017-02 | 08H | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | root bed of tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9696762034757 40.7704883494264) | 19 | 4 | 19 | 13 | ||||
2018 | 2018 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 10182018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
598 | 598 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 10182018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
113 | 113 | -73.9700100617602 | 40.7815739959357 | 19B-PM-1018-01 | 19B | PM | 10182018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | true | false | false | false | false | flying | false | false | false | false | false | false | false | false | POINT (-73.9700100617602 40.7815739959357) | 19 | 4 | 19 | 13 | ||||
1517 | 1517 | -73.970041085185 | 40.7834427580313 | 21A-AM-1019-07 | 21A | AM | 10192018 | 7 | Adult | Gray | Gray+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.970041085185 40.783442758031306) | 19 | 4 | 19 | 13 | ||||||
1020 | 1020 | -73.97016933635 | 40.7705452529783 | 8H-AM-1017-05 | 08H | AM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.97016933635001 40.7705452529783) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE squirrels( "Longitude" TEXT, "Latitude" TEXT, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" TEXT, "Hectare Squirrel Number" TEXT, "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" TEXT, "Chasing" TEXT, "Climbing" TEXT, "Eating" TEXT, "Foraging" TEXT, "Other Activities" TEXT, "Kuks" TEXT, "Quaas" TEXT, "Moans" TEXT, "Tail flags" TEXT, "Tail twitches" TEXT, "Approaches" TEXT, "Indifferent" TEXT, "Runs from" TEXT, "Other Interactions" TEXT, "Lat/Long" TEXT, "Zip Codes" TEXT, "Community Districts" TEXT, "Borough Boundaries" TEXT, "City Council Districts" TEXT, "Police Precincts" TEXT );