This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Combination of Primary and Highlight Color, Color notes, Location, Specific Location, Climbing, Other Activities, Kuks, Quaas, Tail flags, Approaches, Community Districts, City Council Districts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181 | 181 | -73.9708775864433 | 40.772473633538 | 10F-PM-1019-12 | 10F | PM | 10192018 | 12 | Adult | Black | White | Black+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708775864433 40.772473633538) | 19 | 4 | 19 | 13 | |||||
63 | 63 | -73.9745630038492 | 40.7692602628745 | 5E-AM-1008-06 | 05E | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9745630038492 40.7692602628745) | 19 | 4 | 19 | 13 | |||||
199 | 199 | -73.9771614686616 | 40.7709677983247 | 5C-AM-1006-02 | 05C | AM | 10062018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | true | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9771614686616 40.7709677983247) | 19 | 4 | 19 | 13 | |||||
375 | 375 | -73.9752000129992 | 40.7732918122239 | 8C-PM-1013-04 | 08C | PM | 10132018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9752000129992 40.7732918122239) | 19 | 4 | 19 | 13 | |||||
405 | 405 | -73.9786603147149 | 40.7671937837017 | 1D-AM-1006-09 | 01D | AM | 10062018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9786603147149 40.7671937837017) | 19 | 4 | 19 | 13 | |||||
464 | 464 | -73.9664450399121 | 40.7887844904695 | 27A-AM-1008-02 | 27A | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664450399121 40.7887844904695) | 19 | 4 | 19 | 13 | |||||
477 | 477 | -73.9701481200298 | 40.7751110354034 | 12F-AM-1020-06 | 12F | AM | 10202018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701481200298 40.7751110354034) | 19 | 4 | 19 | 13 | |||||
490 | 490 | -73.978426472499 | 40.771904101844 | 6A-PM-1012-04 | 06A | PM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.978426472499 40.771904101844) | 19 | 4 | 19 | 13 | |||||
514 | 514 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | true | false | false | true | false | true | false | false | false | false | false | false | POINT (-73.9768357173861 40.7683813358343) | 19 | 4 | 19 | 13 | |||||
1075 | 1075 | -73.9640534906634 | 40.7777383899836 | 17I-AM-1014-02 | 17I | AM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | standing upright | false | false | false | false | false | true | false | true | runs from (only ran away when a grandpa chased it off) | POINT (-73.9640534906634 40.7777383899836) | 19 | 4 | 19 | 13 | |||
1418 | 1418 | -73.9673924060436 | 40.7788781851716 | 17F-AM-1007-03 | 17F | AM | 10072018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9673924060436 40.7788781851716) | 19 | 4 | 19 | 13 | |||||
1551 | 1551 | -73.9785114291288 | 40.7719779589449 | 6A-PM-1012-03 | 06A | PM | 10122018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9785114291288 40.7719779589449) | 19 | 4 | 19 | 13 | |||||
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 | |||||
1740 | 1740 | -73.9577758125518 | 40.799384716477 | 41B-AM-1010-10 | 41B | AM | 10102018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9577758125518 40.799384716477) | 19 | 4 | 19 | 13 | |||||
1889 | 1889 | -73.9679319758284 | 40.7821154802399 | 20C-PM-1018-07 | 20C | PM | 10182018 | 7 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9679319758284 40.7821154802399) | 19 | 4 | 19 | 13 | |||||
1961 | 1961 | -73.953664715831 | 40.7981256393159 | 41E-PM-1013-04 | 41E | PM | 10132018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.953664715831 40.7981256393159) | 19 | 4 | 19 | 13 | |||||
2044 | 2044 | -73.9771552326199 | 40.7706917595308 | 5C-AM-1006-01 | 05C | AM | 10062018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | true | false | false | POINT (-73.9771552326199 40.7706917595308) | 19 | 4 | 19 | 13 | |||||
2268 | 2268 | -73.9590191655172 | 40.7926139425111 | 34D-AM-1008-03 | 34D | AM | 10082018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9590191655172 40.7926139425111) | 19 | 4 | 19 | 13 | |||||
2278 | 2278 | -73.964539031099 | 40.7809916310012 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.964539031099 40.7809916310012) | 19 | 4 | 19 | 13 | |||||
2620 | 2620 | -73.9771800098131 | 40.7708863131336 | 5C-PM-1010-03 | 05C | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9771800098131 40.7708863131336) | 19 | 4 | 19 | 13 | |||||
2732 | 2732 | -73.9694185786221 | 40.7787189999566 | 16D-AM-1007-06 | 16D | AM | 10072018 | 6 | Adult | Cinnamon | White | Cinnamon+White | primary color: brown ( I marked cinnamon as closest to brown - JO) | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694185786221 40.7787189999566) | 19 | 4 | 19 | 13 | ||||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | true | false | false | true | false | false | false | true | POINT (-73.9712187890707 40.7750640173134) | 19 | 4 | 19 | 13 | |||||
2886 | 2886 | -73.9729265300533 | 40.7741768291642 | 10D-AM-1008-02 | 10D | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9729265300533 40.7741768291642) | 19 | 4 | 19 | 13 | |||||
2897 | 2897 | -73.9689554458632 | 40.7778593393957 | 16E-PM-1018-10 | 16E | PM | 10182018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689554458632 40.7778593393957) | 19 | 4 | 19 | 13 | |||||
2900 | 2900 | -73.9631005470369 | 40.7885494057193 | 28D-AM-1012-01 | 28D | AM | 10122018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9631005470369 40.7885494057193) | 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 | |||||
30 | 30 | -73.9692943291611 | 40.7769536102488 | 15E-AM-1013-01 | 15E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9692943291611 40.7769536102488) | 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 | |||||
51 | 51 | -73.9801666435401 | 40.7686905339212 | 2B-PM-1013-01 | 02B | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | running (with nut) | false | false | false | false | false | false | false | false | POINT (-73.9801666435401 40.7686905339212) | 19 | 4 | 19 | 13 | ||||
53 | 53 | -73.9584970643213 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | true | false | false | POINT (-73.9584970643213 40.7982886348696) | 19 | 4 | 19 | 13 | |||||
82 | 82 | -73.9688271202401 | 40.7809719445309 | 19C-PM-1018-01 | 19C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9688271202401 40.7809719445309) | 19 | 4 | 19 | 13 | |||||
170 | 170 | -73.9597205966324 | 40.7969409510133 | 38B-AM-1019-01 | 38B | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9597205966324 40.7969409510133) | 19 | 4 | 19 | 13 | |||||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.958535640774 40.7982737896998) | 19 | 4 | 19 | 13 | |||||
184 | 184 | -73.9553811810434 | 40.7970895007931 | 40E-AM-1014-02 | 40E | AM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9553811810434 40.7970895007931) | 19 | 4 | 19 | 13 | |||||
277 | 277 | -73.9619070229674 | 40.79525566925 | 35A-AM-1014-05 | 35A | AM | 10142018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9619070229674 40.79525566925) | 19 | 4 | 19 | 13 | |||||
365 | 365 | -73.9576035072364 | 40.7966120824816 | 38C-AM-1019-01 | 38C | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (lawnmower) | POINT (-73.9576035072364 40.7966120824816) | 19 | 4 | 19 | 13 | ||||
386 | 386 | -73.9550351380957 | 40.7974681522214 | 40E-AM-1014-01 | 40E | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9550351380957 40.7974681522214) | 19 | 4 | 19 | 13 | |||||
426 | 426 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on railing | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
465 | 465 | -73.9683041099256 | 40.7862652300082 | 24A-AM-1014-01 | 24A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | freezes | POINT (-73.9683041099256 40.7862652300082) | 19 | 4 | 19 | 13 | ||||
469 | 469 | -73.9717201378775 | 40.776120280884 | 13D-PM-1018-02 | 13D | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9717201378775 40.776120280884) | 19 | 4 | 19 | 13 | |||||
517 | 517 | -73.954959868822 | 40.7985404965582 | 41D-PM-1014-03 | 41D | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.954959868822 40.7985404965582) | 19 | 4 | 19 | 13 | |||||
520 | 520 | -73.9749446629706 | 40.7720659696067 | 7D-PM-1010-01 | 07D | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | outside fenced hectare | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9749446629706 40.7720659696067) | 19 | 4 | 19 | 13 | ||||
556 | 556 | -73.9721670042434 | 40.776085913838 | 13D-PM-1018-09 | 13D | PM | 10182018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9721670042434 40.776085913838) | 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 | |||||
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 | ||||
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 | true | false | false | true | true | true | false | false | false | false | true | false | true | approaches (me),runs from (me) | POINT (-73.9565035705619 40.7937382705056) | 19 | 4 | 19 | 13 | |||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9773079154219 40.7696506688861) | 19 | 4 | 19 | 13 | |||||
772 | 772 | -73.9584188461059 | 40.7913241048498 | 33E-PM-1012-07 | 33E | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9584188461059 40.7913241048498) | 19 | 4 | 19 | 13 | |||||
859 | 859 | -73.9600964585868 | 40.7952339524416 | 36B-PM-1013-02 | 36B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | true | false | true | POINT (-73.9600964585868 40.7952339524416) | 19 | 4 | 19 | 13 | |||||
895 | 895 | -73.9786898656279 | 40.7720833097065 | 6A-AM-1006-08 | 06A | AM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9786898656279 40.77208330970651) | 19 | 4 | 19 | 13 | |||||
902 | 902 | -73.969105907 | 40.7820474909192 | 20B-PM-1013-08 | 20B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | (very brown) | Ground Plane | FALSE | true | false | false | false | false | being chased by dog | false | false | false | false | false | false | false | true | POINT (-73.969105907 40.7820474909192) | 19 | 4 | 19 | 13 | |||
907 | 907 | -73.958060992131 | 40.7907158878729 | 32F-AM-1012-06 | 32F | AM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958060992131 40.7907158878729) | 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 | ||||
957 | 957 | -73.9586527721822 | 40.7908831110561 | 32F-PM-1008-08 | 32F | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586527721822 40.7908831110561) | 19 | 4 | 19 | 13 | |||||
999 | 999 | -73.980948293606 | 40.7685688850628 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
1019 | 1019 | -73.9704269630964 | 40.7722964640257 | 10G-AM-1006-09 | 10G | AM | 10062018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704269630964 40.7722964640257) | 19 | 4 | 19 | 13 | |||||
1047 | 1047 | -73.9580111056675 | 40.7854339401483 | 27I-PM-1020-02 | 27I | PM | 10202018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9580111056675 40.7854339401483) | 19 | 4 | 19 | 13 | |||||
1049 | 1049 | -73.9564606426367 | 40.7880546572608 | 30I-PM-1006-06 | 30I | PM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | true | ran up tree | POINT (-73.9564606426367 40.7880546572608) | 19 | 4 | 19 | 13 | ||||
1054 | 1054 | -73.9570050460867 | 40.7985192250745 | 40C-AM-1017-05 | 40C | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9570050460867 40.7985192250745) | 19 | 4 | 19 | 13 | |||||
1139 | 1139 | -73.9716271494641 | 40.7796462634184 | 16B-PM-1017-02 | 16B | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9716271494641 40.7796462634184) | 19 | 4 | 19 | 13 | |||||
1141 | 1141 | -73.9664669369583 | 40.7774085361976 | 16G-AM-1010-05 | 16G | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9664669369583 40.7774085361976) | 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 | ||||
1202 | 1202 | -73.9694979297007 | 40.7694667408721 | 7I-PM-1013-02 | 07I | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Construction materials | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9694979297007 40.7694667408721) | 19 | 4 | 19 | 13 | ||||
1204 | 1204 | -73.9762965341309 | 40.775112516678 | 10A-AM-1006-02 | 10A | AM | 10062018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Bridle Path lawn | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9762965341309 40.775112516678) | 19 | 4 | 19 | 13 | ||||
1259 | 1259 | -73.976864402584 | 40.7705663751959 | 5C-PM-1010-05 | 05C | PM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.976864402584 40.7705663751959) | 19 | 4 | 19 | 13 | |||||
1264 | 1264 | -73.9785353775382 | 40.7674923683184 | 2C-PM-1013-01 | 02C | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9785353775382 40.7674923683184) | 19 | 4 | 19 | 13 | |||||
1308 | 1308 | -73.9560396440844 | 40.7945080361909 | 37E-AM-1013-01 | 37E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9560396440844 40.7945080361909) | 19 | 4 | 19 | 13 | |||||
1328 | 1328 | -73.9765758043111 | 40.7713803154032 | 6C-AM-1007-03 | 06C | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 8 | another tree | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9765758043111 40.7713803154032) | 19 | 4 | 19 | 13 | ||||
1356 | 1356 | -73.9534910562766 | 40.7935774443789 | 37H-AM-1018-04 | 37H | AM | 10182018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | was with a lot of robins | POINT (-73.9534910562766 40.7935774443789) | 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 | |||||
1403 | 1403 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9761632586697 40.7741085606149) | 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 | |||||
1453 | 1453 | -73.9555856074105 | 40.7969457685677 | 40E-AM-1014-04 | 40E | AM | 10142018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | on rocks/bushy rocks | true | false | false | false | false | hiding from bird | false | true | false | false | true | false | true | false | POINT (-73.9555856074105 40.79694576856771) | 19 | 4 | 19 | 13 | |||
1456 | 1456 | -73.9714242426496 | 40.7744535798123 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | foraging (foraged,ran to tree root,munched) | false | false | false | false | false | false | true | false | POINT (-73.9714242426496 40.7744535798123) | 19 | 4 | 19 | 13 | ||||
1461 | 1461 | -73.956926909344 | 40.7965323262487 | 39D-PM-1012-03 | 39D | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.956926909344 40.7965323262487) | 19 | 4 | 19 | 13 | |||||
1465 | 1465 | -73.9720289863666 | 40.7763749561607 | 13C-PM-1019-03 | 13C | PM | 10192018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.97202898636661 40.7763749561607) | 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 | ||||
1510 | 1510 | -73.9655670884957 | 40.7763728890554 | 16H-PM-1014-03 | 16H | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | followed man across bridge | POINT (-73.9655670884957 40.7763728890554) | 19 | 4 | 19 | 13 | ||||
1529 | 1529 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
1532 | 1532 | -73.9779263114572 | 40.7682681855369 | 3D-PM-1010-08 | 03D | PM | 10102018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9779263114572 40.7682681855369) | 19 | 4 | 19 | 13 | |||||
1549 | 1549 | -73.9777978497894 | 40.7668620784309 | 1D-AM-1006-01 | 01D | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | true | false | false | false | POINT (-73.9777978497894 40.7668620784309) | 19 | 4 | 19 | 13 | |||||
1587 | 1587 | -73.9805517765469 | 40.7683044693163 | 2B-PM-1013-05 | 02B | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | climbing fence! | false | false | false | false | false | false | false | false | snuck into bike cart! | POINT (-73.9805517765469 40.7683044693163) | 19 | 4 | 19 | 13 | |||
1588 | 1588 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9693209851947 40.7707450042769) | 19 | 4 | 19 | 13 | |||||
1590 | 1590 | -73.9610388059192 | 40.79395293584 | 34B-PM-1007-01 | 34B | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9610388059192 40.79395293584) | 19 | 4 | 19 | 13 | |||||
1604 | 1604 | -73.9734644470766 | 40.7782766486921 | 14A-PM-1014-05 | 14A | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.97346444707661 40.7782766486921) | 19 | 4 | 19 | 13 | |||||
1648 | 1648 | -73.9790263372004 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
1685 | 1685 | -73.9678822983274 | 40.7802960985637 | 18E-PM-1006-01 | 18E | PM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9678822983274 40.7802960985637) | 19 | 4 | 19 | 13 | |||||
1689 | 1689 | -73.9547031549299 | 40.7978867539322 | 41E-PM-1013-01 | 41E | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9547031549299 40.7978867539322) | 19 | 4 | 19 | 13 | |||||
1717 | 1717 | -73.9714952092767 | 40.7748063281815 | 12E-AM-1017-02 | 12E | AM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714952092767 40.7748063281815) | 19 | 4 | 19 | 13 | |||||
1756 | 1756 | -73.9755041276839 | 40.7678213857557 | 3F-AM-1006-13 | 03F | AM | 10062018 | 13 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9755041276839 40.7678213857557) | 19 | 4 | 19 | 13 | |||||
1758 | 1758 | -73.9581241870185 | 40.7961057536141 | 38C-AM-1019-05 | 38C | AM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9581241870185 40.7961057536141) | 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 | |||||
1911 | 1911 | -73.9528937660465 | 40.7922919074537 | 36I-AM-1017-01 | 36I | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | true | runs from (me!)—from a pretty big distance | POINT (-73.9528937660465 40.7922919074537) | 19 | 4 | 19 | 13 | ||||
1913 | 1913 | -73.9774630821854 | 40.7680626674086 | 3D-PM-1010-11 | 03D | PM | 10102018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9774630821854 40.76806266740861) | 19 | 4 | 19 | 13 | |||||
1915 | 1915 | -73.9797112925048 | 40.7688046778472 | 2B-PM-1013-09 | 02B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
1956 | 1956 | -73.980897497712 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
1984 | 1984 | -73.9739249209875 | 40.7768528386853 | 13B-PM-1008-02 | 13B | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9739249209875 40.7768528386853) | 19 | 4 | 19 | 13 | |||||
1988 | 1988 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | true | true | true | false | false | chasing (#4),digging | false | false | false | false | true | false | true | false | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
1996 | 1996 | -73.977641787698 | 40.7695830265784 | 4C-PM-1010-10 | 04C | PM | 10102018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.977641787698 40.7695830265784) | 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 |
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 );