This data as json, CSV (advanced)
Suggested facets: Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Zip Codes, Community Districts, Police Precincts
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||
21 | 21 | -73.9703781726172 | 40.7787526130321 | 16C-PM-1018-03 | 16C | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9703781726172 40.7787526130321) | 19 | 4 | 19 | 13 | |||||
23 | 23 | -73.9638179439747 | 40.7924173263904 | 32A-PM-1013-03 | 32A | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9638179439747 40.7924173263904) | 19 | 4 | 19 | 13 | |||||
32 | 32 | -73.9576530157255 | 40.7868659490397 | 29I-PM-1007-01 | 29I | PM | 10072018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9576530157255 40.7868659490397) | 19 | 4 | 19 | 13 | ||||||
34 | 34 | -73.9704402681017 | 40.7798965621203 | 17C-PM-1013-05 | 17C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | eating (ate upside down on a tree — #jealous) | false | false | false | false | false | false | true | false | POINT (-73.9704402681017 40.77989656212031) | 19 | 4 | 19 | 13 | |||||
42 | 42 | -73.9579564338627 | 40.7959337795027 | 38C-PM-1014-09 | 38C | PM | 10142018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9579564338627 40.7959337795027) | 19 | 4 | 19 | 13 | ||||||
54 | 54 | -73.9760298241178 | 40.7681954366911 | 3E-PM-1008-07 | 03E | PM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9760298241178 40.7681954366911) | 19 | 4 | 19 | 13 | |||||
64 | 64 | -73.9595002339508 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 10172018 | 13 | 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 | true | false | POINT (-73.9595002339508 40.7903365788694) | 19 | 4 | 19 | 13 | |||||||
74 | 74 | -73.9546654184146 | 40.7947639241491 | 38G-PM-1020-09 | 38G | PM | 10202018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | true | false | POINT (-73.9546654184146 40.7947639241491) | 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 | |||||
94 | 94 | -73.9641971813967 | 40.7813537959435 | 21G-PM-1007-01 | 21G | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9641971813967 40.7813537959435) | 19 | 4 | 19 | 13 | |||||
105 | 105 | -73.9589249555235 | 40.7908193284981 | 32E-PM-1017-03 | 32E | PM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | bottom of tree | false | false | false | true | false | still | false | false | false | false | false | false | true | false | POINT (-73.9589249555235 40.7908193284981) | 19 | 4 | 19 | 13 | ||||
106 | 106 | -73.9634623418761 | 40.7917685404482 | 31A-PM-1017-04 | 31A | PM | 10172018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9634623418761 40.7917685404482) | 19 | 4 | 19 | 13 | |||||
115 | 115 | -73.9530040923555 | 40.7922896176936 | 36I-PM-1007-10 | 36I | PM | 10072018 | 10 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | stole (found?) an entire sandwich | false | false | false | false | false | false | true | false | POINT (-73.9530040923555 40.7922896176936) | 19 | 4 | 19 | 13 | ||||
128 | 128 | -73.9746229094643 | 40.7748467061969 | 10B-PM-1014-05 | 10B | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | false | false | avoided people | POINT (-73.9746229094643 40.7748467061969) | 19 | 4 | 19 | 13 | ||||
129 | 129 | -73.9705092958892 | 40.7761092972965 | 13E-PM-1008-07 | 13E | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9705092958892 40.7761092972965) | 19 | 4 | 19 | 13 | ||||||
130 | 130 | -73.9581655949437 | 40.7997708190022 | 41A-PM-1007-06 | 41A | PM | 10072018 | 6 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9581655949437 40.7997708190022) | 19 | 4 | 19 | 13 | ||||||
136 | 136 | -73.9528682507794 | 40.7925807808307 | 36I-PM-1007-13 | 36I | PM | 10072018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9528682507794 40.7925807808307) | 19 | 4 | 19 | 13 | |||||
143 | 143 | -73.9661361310677 | 40.7787872561177 | 18G-PM-1013-01 | 18G | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | burying | false | false | false | false | false | false | false | true | POINT (-73.9661361310677 40.7787872561177) | 19 | 4 | 19 | 13 | ||||
158 | 158 | -73.9710991123992 | 40.7723889726647 | 9F-PM-1014-02 | 09F | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9710991123992 40.7723889726647) | 19 | 4 | 19 | 13 | |||||
159 | 159 | -73.9638270331336 | 40.7810450065235 | 21G-PM-1007-02 | 21G | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9638270331336 40.7810450065235) | 19 | 4 | 19 | 13 | ||||||
161 | 161 | -73.9649632550828 | 40.7809187761995 | 20F-PM-1007-01 | 20F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9649632550828 40.7809187761995) | 19 | 4 | 19 | 13 | ||||
165 | 165 | -73.969058856545 | 40.7766356226979 | 14F-PM-1012-06 | 14F | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.969058856545 40.7766356226979) | 19 | 4 | 19 | 13 | |||||
171 | 171 | -73.971086588091 | 40.7719703235178 | 9G-PM-1007-06 | 09G | PM | 10072018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.971086588091 40.7719703235178) | 19 | 4 | 19 | 13 | ||||||
178 | 178 | -73.9613780522542 | 40.790786197111 | 31D-PM-1006-04 | 31D | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9613780522542 40.790786197111) | 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 | ||||
213 | 213 | -73.968367485157 | 40.7838472644815 | 22B-PM-1014-05 | 22B | PM | 10142018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | eating (eats with head tilted far to the right (tooth issue?)) | false | false | false | false | false | false | false | false | POINT (-73.968367485157 40.7838472644815) | 19 | 4 | 19 | 13 | |||||
218 | 218 | -73.9712318712643 | 40.7773053099657 | 14D-PM-1019-04 | 14D | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9712318712643 40.7773053099657) | 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 | |||||
245 | 245 | -73.9589414339242 | 40.7907073888277 | 32E-PM-1017-04 | 32E | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589414339242 40.7907073888277) | 19 | 4 | 19 | 13 | |||||
246 | 246 | -73.9779805668091 | 40.7680931566797 | 2D-PM-1012-02 | 02D | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9779805668091 40.7680931566797) | 19 | 4 | 19 | 13 | |||||
252 | 252 | -73.974420668782 | 40.7749628597465 | 10C-PM-1013-04 | 10C | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.974420668782 40.7749628597465) | 19 | 4 | 19 | 13 | ||||||
262 | 262 | -73.9712876234172 | 40.7695885530701 | 7H-PM-1006-02 | 07H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | tree | true | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9712876234172 40.7695885530701) | 19 | 4 | 19 | 13 | |||||
266 | 266 | -73.9786481009499 | 40.7697372811949 | 4B-PM-1018-03 | 04B | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786481009499 40.7697372811949) | 19 | 4 | 19 | 13 | ||||||
267 | 267 | -73.9754742295091 | 40.7696998327247 | 5E-PM-1012-02 | 05E | PM | 10122018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9754742295091 40.7696998327247) | 19 | 4 | 19 | 13 | |||||
272 | 272 | -73.9521950056404 | 40.794937340845 | 39H-PM-1013-01 | 39H | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | ran away when a human approached with a dog | POINT (-73.9521950056404 40.794937340845) | 19 | 4 | 19 | 13 | ||||
274 | 274 | -73.9639832886071 | 40.7909532437095 | 30B-PM-1019-08 | 30B | PM | 10192018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9639832886071 40.7909532437095) | 19 | 4 | 19 | 13 | |||||
275 | 275 | -73.974467903723 | 40.7686520352868 | 4F-PM-1013-04 | 04F | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.974467903723 40.7686520352868) | 19 | 4 | 19 | 13 | |||||
276 | 276 | -73.9758579666874 | 40.7679326548845 | 3E-PM-1008-05 | 03E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | jump | false | false | false | false | false | false | true | false | POINT (-73.9758579666874 40.7679326548845) | 19 | 4 | 19 | 13 | |||||
288 | 288 | -73.9731113265165 | 40.7786640676355 | 15A-PM-1017-01 | 15A | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | false | false | true | true | false | eating in tree | false | false | false | false | false | false | true | false | POINT (-73.9731113265165 40.7786640676355) | 19 | 4 | 19 | 13 | ||||
290 | 290 | -73.9560679864426 | 40.7947887062326 | 37E-PM-1006-06 | 37E | PM | 10062018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9560679864426 40.7947887062326) | 19 | 4 | 19 | 13 | |||||
294 | 294 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | true | false | false | true | false | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
299 | 299 | -73.9586214081667 | 40.7937473968735 | 35D-PM-1013-03 | 35D | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | No Tail! | Above Ground | 2 | bench | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9586214081667 40.7937473968735) | 19 | 4 | 19 | 13 | |||
303 | 303 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 10082018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | true | true | climbed fence staring at me - went up tree | false | false | false | false | false | false | false | true | POINT (-73.97623482246482 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
309 | 309 | -73.9696001184129 | 40.7820810673532 | 19B-PM-1018-05 | 19B | PM | 10182018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9696001184129 40.7820810673532) | 19 | 4 | 19 | 13 | ||||
314 | 314 | -73.960601067176 | 40.7917243850136 | 32D-PM-1006-09 | 32D | PM | 10062018 | 9 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.960601067176 40.7917243850136) | 19 | 4 | 19 | 13 | |||||
315 | 315 | -73.9539734770934 | 40.7956055442 | 39G-PM-1013-04 | 39G | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9539734770934 40.7956055442) | 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 | ||||||
328 | 328 | -73.9652357279671 | 40.7819296887147 | 21E-PM-1012-02 | 21E | PM | 10122018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9652357279671 40.7819296887147) | 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 | |||
333 | 333 | -73.9667560049684 | 40.7882333830729 | 27A-PM-1006-01 | 27A | PM | 10062018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | false | false | false | true | true | walking up & down branches | false | false | false | false | false | false | true | false | POINT (-73.9667560049684 40.7882333830729) | 19 | 4 | 19 | 13 | ||||
339 | 339 | -73.965509576403 | 40.7752456763263 | 14I-PM-1018-05 | 14I | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | false | false | true | true | false | false | false | false | false | true | false | true | false | POINT (-73.96550957640301 40.7752456763263) | 19 | 4 | 19 | 13 | |||||
344 | 344 | -73.9759432151552 | 40.7733240612552 | 8B-PM-1012-06 | 08B | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | on a bench | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9759432151552 40.7733240612552) | 19 | 4 | 19 | 13 | ||||
353 | 353 | -73.9740007759509 | 40.7650077086539 | 1H-PM-1013-01 | 01H | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9740007759509 40.7650077086539) | 19 | 4 | 19 | 13 | ||||||
355 | 355 | -73.9639635134738 | 40.7900337598704 | 29B-PM-1010-05 | 29B | PM | 10102018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9639635134738 40.7900337598704) | 19 | 4 | 19 | 13 | |||||
357 | 357 | -73.9724801784201 | 40.7790131966689 | 15B-PM-1017-05 | 15B | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9724801784201 40.7790131966689) | 19 | 4 | 19 | 13 | |||||
368 | 368 | -73.970315671921 | 40.7720905395472 | 10G-PM-1017-02 | 10G | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.970315671921 40.7720905395472) | 19 | 4 | 19 | 13 | |||||
376 | 376 | -73.9698817079185 | 40.7758322627711 | 13E-PM-1008-10 | 13E | PM | 10082018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.9698817079185 40.7758322627711) | 19 | 4 | 19 | 13 | |||||
379 | 379 | -73.9606817053484 | 40.7917320450401 | 32D-PM-1006-07 | 32D | PM | 10062018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9606817053484 40.7917320450401) | 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 | ||||||
382 | 382 | -73.9735946835545 | 40.7724155751282 | 8E-PM-1008-01 | 08E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by tree trunk base | false | false | false | true | false | false | false | false | false | false | true | false | false | eating food being thrown at it by a mom & baby | POINT (-73.9735946835545 40.7724155751282) | 19 | 4 | 19 | 13 | |||
383 | 383 | -73.9588358879692 | 40.7912631913057 | 33E-PM-1012-01 | 33E | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9588358879692 40.7912631913057) | 19 | 4 | 19 | 13 | |||||
393 | 393 | -73.9577212629651 | 40.7965525296722 | 38C-PM-1014-06 | 38C | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9577212629651 40.7965525296722) | 19 | 4 | 19 | 13 | |||||
396 | 396 | -73.9669206605745 | 40.7748155701122 | 13H-PM-1010-03 | 13H | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | in glen | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9669206605745 40.7748155701122) | 19 | 4 | 19 | 13 | |||||
399 | 399 | -73.9763433202401 | 40.7738473490681 | 9B-PM-1013-10 | 09B | PM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | "Brown" written in as Primary | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9763433202401 40.7738473490681) | 19 | 4 | 19 | 13 | ||||
404 | 404 | -73.9680774548516 | 40.7762491903691 | 14F-PM-1012-01 | 14F | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9680774548516 40.7762491903691) | 19 | 4 | 19 | 13 | |||||
407 | 407 | -73.9787658435198 | 40.7689419765393 | 3B-PM-1007-07 | 03B | PM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | eating loudly <- peanuts w/ shells | false | false | false | false | false | false | true | false | POINT (-73.9787658435198 40.7689419765393) | 19 | 4 | 19 | 13 | ||||
409 | 409 | -73.9530809650496 | 40.7959176317705 | 40G-PM-1013-02 | 40G | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | hiding from dog | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9530809650496 40.79591763177051) | 19 | 4 | 19 | 13 | ||||
416 | 416 | -73.9702788578386 | 40.7694484997295 | 7I-PM-1013-05 | 07I | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rock | false | false | false | true | false | false | false | false | true | false | false | false | false | POINT (-73.9702788578386 40.7694484997295) | 19 | 4 | 19 | 13 | ||||
418 | 418 | -73.9573604880421 | 40.7930844158021 | 35E-PM-1006-03 | 35E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9573604880421 40.7930844158021) | 19 | 4 | 19 | 13 | |||||
420 | 420 | -73.9671851611243 | 40.7750878657618 | 14H-PM-1012-01 | 14H | PM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | true | false | false | approaches (came very close to me) | POINT (-73.9671851611243 40.7750878657618) | 19 | 4 | 19 | 13 | ||||
429 | 429 | -73.9694784056618 | 40.7787735291442 | 16D-PM-1010-01 | 16D | PM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694784056618 40.7787735291442) | 19 | 4 | 19 | 13 | ||||||
436 | 436 | -73.9734695768004 | 40.7716297491384 | 8E-PM-1008-05 | 08E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9734695768004 40.7716297491384) | 19 | 4 | 19 | 13 | ||||
437 | 437 | -73.9793952066038 | 40.7707837657859 | 4A-PM-1007-03 | 04A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by rock | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9793952066038 40.77078376578591) | 19 | 4 | 19 | 13 | ||||
446 | 446 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | mushroom | false | false | false | false | false | false | true | false | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
453 | 453 | -73.959514034869 | 40.789911786416 | 31E-PM-1006-02 | 31E | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | false | false | false | true | true | false | true | false | false | false | false | true | false | POINT (-73.959514034869 40.789911786416) | 19 | 4 | 19 | 13 | ||||
456 | 456 | -73.9547878025303 | 40.7899151873467 | 33I-PM-1006-05 | 33I | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9547878025303 40.7899151873467) | 19 | 4 | 19 | 13 | ||||||
460 | 460 | -73.9549135206961 | 40.798525897229 | 42D-PM-1013-03 | 42D | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9549135206961 40.798525897229) | 19 | 4 | 19 | 13 | ||||
461 | 461 | -73.9648195433192 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | staring | false | false | false | false | true | false | false | false | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
463 | 463 | -73.9592103064327 | 40.7904390691553 | 32E-PM-1017-10 | 32E | PM | 10172018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9592103064327 40.7904390691553) | 19 | 4 | 19 | 13 | ||||||
475 | 475 | -73.9697855573137 | 40.7742186391935 | 12F-PM-1007-05 | 12F | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697855573137 40.7742186391935) | 19 | 4 | 19 | 13 | |||||
495 | 495 | -73.9801007327506 | 40.7677455633932 | 1B-PM-1019-06 | 01B | PM | 10192018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9801007327506 40.7677455633932) | 19 | 4 | 19 | 13 | |||||
505 | 505 | -73.9677387336667 | 40.7742695912 | 12H-PM-1007-02 | 12H | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | false | false | true | true | false | peanuts | false | false | false | false | false | false | true | false | POINT (-73.9677387336667 40.7742695912) | 19 | 4 | 19 | 13 | |||
516 | 516 | -73.9597418366664 | 40.7964417084985 | 37B-PM-1013-05 | 37B | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9597418366664 40.7964417084985) | 19 | 4 | 19 | 13 | |||||
519 | 519 | -73.9659010238417 | 40.7791683666215 | 18G-PM-1013-02 | 18G | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9659010238417 40.779168366621505) | 19 | 4 | 19 | 13 | ||||||
522 | 522 | -73.9773821135611 | 40.7690453494383 | 4C-PM-1010-06 | 04C | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | behind playground benches | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9773821135611 40.7690453494383) | 19 | 4 | 19 | 13 | ||||
530 | 530 | -73.9696360756453 | 40.7786545659072 | 16D-PM-1010-03 | 16D | PM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9696360756453 40.7786545659072) | 19 | 4 | 19 | 13 | ||||||
540 | 540 | -73.9746802194012 | 40.7731347452245 | 9C-PM-1006-01 | 09C | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9746802194012 40.7731347452245) | 19 | 4 | 19 | 13 | |||||
545 | 545 | -73.9756810453606 | 40.7756257458036 | 11A-PM-1013-01 | 11A | PM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Off-white, decorator's white? | Ground Plane | FALSE | false | false | false | true | false | eating (osage orange) | false | false | false | false | false | false | true | false | POINT (-73.9756810453606 40.7756257458036) | 19 | 4 | 19 | 13 | |||
548 | 548 | -73.9584696083284 | 40.7980121226635 | 39B-PM-1014-03 | 39B | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584696083284 40.7980121226635) | 19 | 4 | 19 | 13 | ||||||
571 | 571 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9659549963516 40.7833659689194) | 19 | 4 | 19 | 13 | |||||||
572 | 572 | -73.9763622269272 | 40.7704671295941 | 5C-PM-1010-10 | 05C | PM | 10102018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | fed by woman | POINT (-73.9763622269272 40.7704671295941) | 19 | 4 | 19 | 13 | ||||
574 | 574 | -73.9706360005275 | 40.7717074044466 | 9G-PM-1007-05 | 09G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9706360005275 40.7717074044466) | 19 | 4 | 19 | 13 | |||||
577 | 577 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 10142018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9497217674555 40.796517007214) | 19 | 4 | 19 | 13 | ||||||
578 | 578 | -73.9671306431211 | 40.7838870159057 | 22C-PM-1006-05 | 22C | PM | 10062018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9671306431211 40.783887015905705) | 19 | 4 | 19 | 13 | ||||||
579 | 579 | -73.9786714207307 | 40.7696870806229 | 4B-PM-1018-01 | 04B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786714207307 40.7696870806229) | 19 | 4 | 19 | 13 | ||||||
580 | 580 | -73.9750992564362 | 40.7743391883762 | 10B-PM-1014-03 | 10B | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | avoided people | POINT (-73.9750992564362 40.7743391883762) | 19 | 4 | 19 | 13 | ||||
581 | 581 | -73.9556218199258 | 40.7980460204041 | 41D-PM-1014-01 | 41D | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | digging,drinking | false | false | false | false | false | false | false | true | POINT (-73.9556218199258 40.7980460204041) | 19 | 4 | 19 | 13 | ||||
585 | 585 | -73.9700148248402 | 40.7787780193358 | 16D-PM-1010-04 | 16D | PM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9700148248402 40.7787780193358) | 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 |
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 );