This data as json, CSV (advanced)
Suggested facets: Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Zip Codes, City Council Districts, Police Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9561344937861 | 40.7940823884086 | 37F-PM-1014-03 | 37F | PM | 10142018 | 3 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
10 | 10 | -73.9596413903948 | 40.7903128889029 | 32E-PM-1017-14 | 32E | PM | 10172018 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9596413903948 40.7903128889029) | 19 | 4 | 19 | 13 | |||||||
173 | 173 | -73.958770180151 | 40.7934123941528 | 35D-PM-1013-04 | 35D | PM | 10132018 | 4 | Juvenile | Gray | White | Gray+White | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958770180151 40.7934123941528) | 19 | 4 | 19 | 13 | |||||||
348 | 348 | -73.9542990150586 | 40.7940915300678 | 37G-PM-1007-09 | 37G | PM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9542990150586 40.7940915300678) | 19 | 4 | 19 | 13 | |||||||
363 | 363 | -73.9707197274481 | 40.7773956803431 | 14D-PM-1019-12 | 14D | PM | 10192018 | 12 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9707197274481 40.7773956803431) | 19 | 4 | 19 | 13 | ||||||||
390 | 390 | -73.970720187655 | 40.7774564799983 | 14D-PM-1019-11 | 14D | PM | 10192018 | 11 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.970720187655 40.7774564799983) | 19 | 4 | 19 | 13 | ||||||||
607 | 607 | -73.9547711796823 | 40.7908540751983 | 34I-PM-1010-06 | 34I | PM | 10102018 | 6 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9547711796823 40.7908540751983) | 19 | 4 | 19 | 13 | ||||||||
645 | 645 | -73.9758152322587 | 40.7692377401467 | 4E-PM-1008-03 | 04E | PM | 10082018 | 3 | Adult | Gray | Gray+ | false | true | false | false | false | chasing #4 | false | false | false | false | false | false | false | false | POINT (-73.9758152322587 40.7692377401467) | 19 | 4 | 19 | 13 | |||||||
1342 | 1342 | -73.9662063642345 | 40.7890778665307 | 28A-PM-1007-04 | 28A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | false | looking at me & #5 | true | false | false | false | true | false | false | false | freezes | POINT (-73.9662063642345 40.7890778665307) | 19 | 4 | 19 | 13 | |||||
1372 | 1372 | -73.9528353702209 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 10192018 | 2 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9528353702209 40.7976456178263) | 19 | 4 | 19 | 13 | ||||||||||
1475 | 1475 | -73.9686778167484 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 10122018 | 4 | + | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.96867781674841 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
1619 | 1619 | -73.9744555348544 | 40.7728498106357 | 8D-PM-1007-03 | 08D | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9744555348544 40.7728498106357) | 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 | |||||||
1764 | 1764 | -73.9534878316472 | 40.7978951981698 | 41F-PM-1019-01 | 41F | PM | 10192018 | 1 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9534878316472 40.7978951981698) | 19 | 4 | 19 | 13 | ||||||||||
1958 | 1958 | -73.9693120090055 | 40.771096102012 | 9H-PM-1018-07 | 09H | PM | 10182018 | 7 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9693120090055 40.771096102012) | 19 | 4 | 19 | 13 | ||||||||
2014 | 2014 | -73.9786474809514 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
2080 | 2080 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 10102018 | 7 | Adult | Gray | Gray+ | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
2102 | 2102 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | false | false | false | true | true | watching | false | false | false | false | false | false | false | true | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
2237 | 2237 | -73.9708225719705 | 40.7772497804149 | 14D-PM-1019-13 | 14D | PM | 10192018 | 13 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9708225719705 40.7772497804149) | 19 | 4 | 19 | 13 | ||||||||
2257 | 2257 | -73.95431338448 | 40.7940537582585 | 37G-PM-1007-08 | 37G | PM | 10072018 | 8 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.95431338448 40.7940537582585) | 19 | 4 | 19 | 13 | ||||||||
2347 | 2347 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 10082018 | 2 | Adult | Gray | Gray+ | false | false | false | false | false | hopping around | false | false | false | false | false | false | false | true | POINT (-73.9663124560664 40.779544003786) | 19 | 4 | 19 | 13 | |||||||
2714 | 2714 | -73.9600738985438 | 40.7938328798752 | 35C-PM-1013-08 | 35C | PM | 10132018 | 8 | + | false | false | false | false | false | true | false | false | false | false | false | false | false | did not *see* | POINT (-73.9600738985438 40.7938328798752) | 19 | 4 | 19 | 13 | |||||||||
2869 | 2869 | -73.9630822385425 | 40.7914844989865 | 31B-PM-1007-04 | 31B | PM | 10072018 | 4 | Juvenile | Gray | Gray+ | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9630822385425 40.7914844989865) | 19 | 4 | 19 | 13 | ||||||||
2875 | 2875 | -73.9546616782922 | 40.790974533739 | 34I-PM-1010-05 | 34I | PM | 10102018 | 5 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9546616782922 40.790974533739) | 19 | 4 | 19 | 13 | ||||||||
2910 | 2910 | -73.9506062997507 | 40.7976189496674 | 42H-PM-1014-03 | 42H | PM | 10142018 | 3 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9506062997507 40.7976189496674) | 12423 | 18 | 4 | 36 | 18 | ||||||||
4 | 4 | -73.9757249834141 | 40.7697032606755 | 5D-PM-1018-05 | 05D | PM | 10182018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9757249834141 40.7697032606755) | 19 | 4 | 19 | 13 | ||||||
39 | 39 | -73.9716147061553 | 40.7813911036179 | 18A-PM-1018-01 | 18A | PM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9716147061553 40.7813911036179) | 19 | 4 | 19 | 13 | ||||||
72 | 72 | -73.9666007935638 | 40.7845098131567 | 23C-PM-1014-03 | 23C | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | false | true | false | false | false | chasing (#4 across trees) | false | false | false | false | false | false | false | false | POINT (-73.9666007935638 40.7845098131567) | 19 | 4 | 19 | 13 | |||||
85 | 85 | -73.9676410497481 | 40.7766043512974 | 15G-PM-1019-05 | 15G | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9676410497481 40.7766043512974) | 19 | 4 | 19 | 13 | |||||
91 | 91 | -73.9565905868276 | 40.7895654068546 | 32H-PM-1006-01 | 32H | PM | 10062018 | 1 | Gray | Gray+ | Above Ground | in the European Beech | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565905868276 40.7895654068546) | 19 | 4 | 19 | 13 | |||||||
102 | 102 | -73.9575986161364 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | false | true | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
111 | 111 | -73.9763243383771 | 40.7705409315703 | 5C-PM-1010-13 | 05C | PM | 10102018 | 13 | Adult | Gray | White | Gray+White | Above Ground | 20 | way up a tree! | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9763243383771 40.7705409315703) | 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 | ||||
126 | 126 | -73.9792155473689 | 40.7693711799946 | 3B-PM-1007-11 | 03B | PM | 10072018 | 11 | Adult | Gray | Gray+ | Above Ground | 5 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792155473689 40.7693711799946) | 19 | 4 | 19 | 13 | |||||
135 | 135 | -73.9694168118643 | 40.7728877377977 | 11G-PM-1013-01 | 11G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | In the Woods/Brush | false | false | true | false | true | false | false | false | false | false | false | false | true | watching me | POINT (-73.9694168118643 40.7728877377977) | 19 | 4 | 19 | 13 | |||
144 | 144 | -73.9730750601212 | 40.7701304211944 | 6F-PM-1008-01 | 06F | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730750601212 40.7701304211944) | 19 | 4 | 19 | 13 | |||||
150 | 150 | -73.9763430829342 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | false | true | false | false | false | chased #12 | true | false | false | true | false | false | false | true | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
156 | 156 | -73.9576589997493 | 40.7972751877447 | 39C-PM-1006-02 | 39C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | unaware of | POINT (-73.95765899974931 40.7972751877447) | 19 | 4 | 19 | 13 | |||||
168 | 168 | -73.9745691353018 | 40.7771035589298 | 13A-PM-1014-03 | 13A | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | true | child chasing | POINT (-73.9745691353018 40.7771035589298) | 19 | 4 | 19 | 13 | ||||
210 | 210 | -73.9711298491132 | 40.7676902603543 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | false | false | true | true | false | false | false | false | true | false | false | false | false | POINT (-73.9711298491132 40.7676902603543) | 19 | 4 | 19 | 13 | ||||
220 | 220 | -73.967181612203 | 40.7787752287055 | 17F-PM-1020-03 | 17F | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.967181612203 40.7787752287055) | 19 | 4 | 19 | 13 | |||||
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 | |||
229 | 229 | -73.972416242971 | 40.7714260236636 | 8F-PM-1012-04 | 08F | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.972416242971 40.7714260236636) | 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 | |||||
248 | 248 | -73.9751729403694 | 40.7743284123118 | 10B-PM-1014-02 | 10B | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | gingko tree by traffic light in front of Strawberry Fields | false | false | false | false | true | false | false | false | false | true | false | false | false | came over on tree to see me then disappeared | POINT (-73.9751729403694 40.7743284123118) | 19 | 4 | 19 | 13 | ||||
281 | 281 | -73.9619411917909 | 40.7923536640283 | 33B-PM-1010-11 | 33B | PM | 10102018 | 11 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9619411917909 40.7923536640283) | 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 | |||||
306 | 306 | -73.9689700100267 | 40.7775169562765 | 15E-PM-1008-05 | 15E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting | false | true | false | false | false | false | false | false | POINT (-73.9689700100267 40.7775169562765) | 19 | 4 | 19 | 13 | |||||
311 | 311 | -73.9578779556574 | 40.7934116539732 | 35E-PM-1006-06 | 35E | PM | 10062018 | 6 | Adult | Gray | Gray+ | Above Ground | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9578779556574 40.7934116539732) | 19 | 4 | 19 | 13 | |||||||
317 | 317 | -73.9545799024508 | 40.7908084039886 | 34I-PM-1010-01 | 34I | PM | 10102018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9545799024508 40.7908084039886) | 19 | 4 | 19 | 13 | ||||||
331 | 331 | -73.95448101115 | 40.7954469678857 | 39F-PM-1006-03 | 39F | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | lower branch of tree | false | false | false | true | false | false | false | false | false | false | false | false | true | ran up tree when approached | POINT (-73.95448101115 40.7954469678857) | 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 | |||
341 | 341 | -73.9703161745884 | 40.7702610461336 | 8H-PM-1014-05 | 08H | PM | 10142018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9703161745884 40.7702610461336) | 19 | 4 | 19 | 13 | ||||||
354 | 354 | -73.9566751022336 | 40.799035789744 | 41C-PM-1007-04 | 41C | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 65 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566751022336 40.799035789744) | 19 | 4 | 19 | 13 | |||||
360 | 360 | -73.9672054610151 | 40.7876519923501 | 26A-PM-1006-05 | 26A | PM | 10062018 | 5 | Adult | Gray | Gray+ | Above Ground | 40 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9672054610151 40.7876519923501) | 19 | 4 | 19 | 13 | ||||||
366 | 366 | -73.9673548527075 | 40.7765669058396 | 15G-PM-1019-11 | 15G | PM | 10192018 | 11 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673548527075 40.7765669058396) | 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 | |||||
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 | ||||||
385 | 385 | -73.979316275899 | 40.7692134727555 | 3B-PM-1007-01 | 03B | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | in tree | false | false | false | false | false | chased by dog | false | false | false | false | false | false | false | false | POINT (-73.979316275899 40.7692134727555) | 19 | 4 | 19 | 13 | ||||
387 | 387 | -73.9578316525492 | 40.7890102959629 | 31G-PM-1007-01 | 31G | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | false | false | hiding | false | false | false | false | true | false | false | false | froze,sight of dogs | POINT (-73.9578316525492 40.7890102959629) | 19 | 4 | 19 | 13 | ||||
394 | 394 | -73.9719888241794 | 40.7667681685356 | 4I-PM-1007-03 | 04I | PM | 10072018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | ran to tree | false | false | false | false | false | being chased | false | false | false | false | false | false | false | false | POINT (-73.9719888241794 40.7667681685356) | 19 | 4 | 19 | 13 | |||
401 | 401 | -73.965862100991 | 40.7825926896917 | 22D-PM-1012-01 | 22D | PM | 10122018 | 1 | Adult | Gray | Black, White | Gray+Black, White | Above Ground | 5 | false | false | true | false | false | true | false | false | false | false | false | false | false | climbing tree | POINT (-73.965862100991 40.7825926896917) | 19 | 4 | 19 | 13 | ||||
430 | 430 | -73.9710116801402 | 40.7723689301989 | 10G-PM-1017-08 | 10G | PM | 10172018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9710116801402 40.7723689301989) | 19 | 4 | 19 | 13 | |||||
503 | 503 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 10062018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.95983407835722 40.7915857030295) | 19 | 4 | 19 | 13 | ||||||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
526 | 526 | -73.9680833729772 | 40.7741871025115 | 12H-PM-1007-08 | 12H | PM | 10072018 | 8 | + | Above Ground | 7 | in tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680833729772 40.7741871025115) | 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 | |||||
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 | |||||
591 | 591 | -73.9543323786888 | 40.7943086530436 | 37G-PM-1007-03 | 37G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | false | true | false | lying on belly on branch,eating big nut | false | false | false | false | false | false | false | false | POINT (-73.9543323786888 40.7943086530436) | 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 | ||||||
600 | 600 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
601 | 601 | -73.9522291603405 | 40.7976985385835 | 42G-PM-1014-01 | 42G | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 8 | false | false | true | false | true | false | false | true | false | false | false | false | true | POINT (-73.9522291603405 40.7976985385835) | 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 | ||||
635 | 635 | -73.9673235555321 | 40.7786749596774 | 17F-PM-1020-04 | 17F | PM | 10202018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9673235555321 40.7786749596774) | 19 | 4 | 19 | 13 | ||||||
639 | 639 | -73.9558589529608 | 40.7892400394941 | 32H-PM-1006-02 | 32H | PM | 10062018 | 2 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9558589529608 40.7892400394941) | 19 | 4 | 19 | 13 | |||||||
646 | 646 | -73.954092292214 | 40.7979800395433 | 41E-PM-1013-05 | 41E | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.954092292214 40.7979800395433) | 19 | 4 | 19 | 13 | ||||
726 | 726 | -73.973305698325 | 40.7783823311296 | 14A-PM-1014-06 | 14A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 9 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.973305698325 40.7783823311296) | 19 | 4 | 19 | 13 | |||||
744 | 744 | -73.9745687653791 | 40.7776396926997 | 13A-PM-1014-02 | 13A | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 45 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9745687653791 40.7776396926997) | 19 | 4 | 19 | 13 | ||||||
755 | 755 | -73.9579941847434 | 40.7991216713328 | 41B-PM-1014-02 | 41B | PM | 10142018 | 2 | Adult | Black | Black+ | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579941847434 40.7991216713328) | 19 | 4 | 19 | 13 | ||||||
780 | 780 | -73.9675472064204 | 40.7835947167436 | 22C-PM-1006-06 | 22C | PM | 10062018 | 6 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | on tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9675472064204 40.7835947167436) | 19 | 4 | 19 | 13 | ||||
782 | 782 | -73.9710559113762 | 40.7794279914209 | 16C-PM-1018-01 | 16C | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | false | disappeared up other side of tree | POINT (-73.9710559113762 40.7794279914209) | 19 | 4 | 19 | 13 | ||||
789 | 789 | -73.9675023138703 | 40.7872554700995 | 25A-PM-1007-01 | 25A | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 40 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9675023138703 40.7872554700995) | 19 | 4 | 19 | 13 | ||||
808 | 808 | -73.9716881838671 | 40.778553537087 | 15C-PM-1017-02 | 15C | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9716881838671 40.778553537087) | 19 | 4 | 19 | 13 | |||||
844 | 844 | -73.9642379942652 | 40.7774792520738 | 17I-PM-1017-01 | 17I | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | was in a tree,so i couldn't really tell | POINT (-73.9642379942652 40.7774792520738) | 19 | 4 | 19 | 13 | ||||
861 | 861 | -73.953287300494 | 40.793520326789 | 37H-PM-1006-04 | 37H | PM | 10062018 | 4 | + | Above Ground | 43 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.953287300494 40.793520326789) | 19 | 4 | 19 | 13 | |||||||
865 | 865 | -73.9741621946917 | 40.7752481472025 | 11C-PM-1018-01 | 11C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9741621946917 40.7752481472025) | 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 | ||||||
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 | ||||||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | false | true | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9667755678511 40.7760256836088) | 19 | 4 | 19 | 13 | |||||
920 | 920 | -73.9571233640232 | 40.7992458980266 | 41B-PM-1014-04 | 41B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | climbing | POINT (-73.9571233640232 40.7992458980266) | 19 | 4 | 19 | 13 | ||||
926 | 926 | -73.9596006938677 | 40.7834706440535 | 25I-PM-1007-07 | 25I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Above Ground | playing very high in tree w/ #8 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596006938677 40.7834706440535) | 19 | 4 | 19 | 13 | ||||||
935 | 935 | -73.9666195118963 | 40.7839216739357 | 22C-PM-1006-10 | 22C | PM | 10062018 | 10 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9666195118963 40.78392167393571) | 19 | 4 | 19 | 13 | ||||||
951 | 951 | -73.971791854883 | 40.7802971729784 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
981 | 981 | -73.9673160165357 | 40.7766158001202 | 15G-PM-1019-12 | 15G | PM | 10192018 | 12 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673160165357 40.7766158001202) | 19 | 4 | 19 | 13 | |||||
984 | 984 | -73.9672950266018 | 40.7782477517567 | 17F-PM-1020-01 | 17F | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9672950266018 40.7782477517567) | 19 | 4 | 19 | 13 | |||||
991 | 991 | -73.9635689059841 | 40.790163434915 | 30B-PM-1019-03 | 30B | PM | 10192018 | 3 | Adult | Gray | Black | Gray+Black | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9635689059841 40.790163434915) | 19 | 4 | 19 | 13 | |||||
1008 | 1008 | -73.9553038162633 | 40.7909367783223 | 34H-PM-1006-04 | 34H | PM | 10062018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Elm tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9553038162633 40.790936778322305) | 19 | 4 | 19 | 13 | ||||||
1022 | 1022 | -73.9548853492712 | 40.7984783584388 | 41D-PM-1014-04 | 41D | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | jumping tree to tree | false | false | false | false | false | false | false | false | POINT (-73.9548853492712 40.7984783584388) | 19 | 4 | 19 | 13 | ||||
1037 | 1037 | -73.9677409841969 | 40.7763579140639 | 15G-PM-1019-08 | 15G | PM | 10192018 | 8 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | true | true | false | false | false | false | false | POINT (-73.9677409841969 40.7763579140639) | 19 | 4 | 19 | 13 | |||||||
1055 | 1055 | -73.9632337134707 | 40.7914682370734 | 31B-PM-1007-01 | 31B | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #2 and climbing tree w/ #2 | false | false | false | false | false | false | false | true | POINT (-73.9632337134707 40.7914682370734) | 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 );