This data as json, CSV (advanced)
Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Chasing, Climbing, Eating, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Runs from, Zip Codes, Community Districts, City Council Districts, Police Precincts
Hectare Squirrel Number ✖
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 | ||||||||||
2 | 2 | -73.9570437717691 | 40.7948509408039 | 37E-PM-1006-03 | 37E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | me | POINT (-73.9570437717691 40.794850940803904) | 19 | 4 | 19 | 13 | ||||
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 | ||||||
7 | 7 | -73.9719735582476 | 40.7693045133578 | 6G-PM-1020-02 | 06G | PM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9719735582476 40.7693045133578) | 19 | 4 | 19 | 13 | ||||||
15 | 15 | -73.9674285955293 | 40.7829723919744 | 21C-PM-1006-01 | 21C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | true | true | false | false | false | POINT (-73.9674285955293 40.7829723919744) | 19 | 4 | 19 | 13 | ||||||
19 | 19 | -73.9768603630674 | 40.7702795904962 | 5C-PM-1010-09 | 05C | PM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768603630674 40.7702795904962) | 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 | |||||
31 | 31 | -73.9540054100539 | 40.7952445999836 | 39G-PM-1013-06 | 39G | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9540054100539 40.7952445999836) | 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 | |||||
37 | 37 | -73.9643153920428 | 40.7820818516957 | 22F-PM-1014-05 | 22F | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9643153920428 40.7820818516957) | 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 | ||||||
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 | ||||||
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9574648097543 40.78925084286221) | 19 | 4 | 19 | 13 | |||||
47 | 47 | -73.9640032826529 | 40.7820309825448 | 22F-PM-1014-06 | 22F | PM | 10142018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9640032826529 40.7820309825448) | 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 | ||||
58 | 58 | -73.9704082821356 | 40.7690280985956 | 6I-PM-1013-06 | 06I | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | playing with #5 | false | false | false | false | true | false | false | false | POINT (-73.9704082821356 40.7690280985956) | 19 | 4 | 19 | 13 | ||||
65 | 65 | -73.9741824992294 | 40.7689486657963 | 5F-PM-1007-03 | 05F | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | hiding nut | false | false | false | false | true | false | true | false | POINT (-73.9741824992294 40.7689486657963) | 19 | 4 | 19 | 13 | ||||
71 | 71 | -73.9576245992455 | 40.7873862510001 | 29H-PM-1006-01 | 29H | PM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9576245992455 40.7873862510001) | 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 | |||||
78 | 78 | -73.964474836001 | 40.7883840104749 | 28C-PM-1006-01 | 28C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | gathering acorns | false | false | false | true | false | false | false | true | gnd to tree | POINT (-73.964474836001 40.7883840104749) | 19 | 4 | 19 | 13 | |||
81 | 81 | -73.9578237168359 | 40.7980959471034 | 40B-PM-1014-06 | 40B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9578237168359 40.7980959471034) | 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 | |||||
83 | 83 | -73.9617088749928 | 40.7944585082367 | 35A-PM-1013-06 | 35A | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9617088749928 40.7944585082367) | 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 | |||||||
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 | |||||
96 | 96 | -73.9708549670788 | 40.7699587019058 | 7H-PM-1006-04 | 07H | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 12 | on tree knob | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9708549670788 40.7699587019058) | 19 | 4 | 19 | 13 | ||||
99 | 99 | -73.9710541405708 | 40.7724691605718 | 10F-PM-1019-05 | 10F | PM | 10192018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Behind fence, tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9710541405708 40.7724691605718) | 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 | |||
103 | 103 | -73.9607701370443 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 10132018 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | false | true | false | false | false | chasing #8 | false | false | false | false | false | false | false | true | POINT (-73.9607701370443 40.7955418990855) | 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 | ||||
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 | ||||
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 | ||||
118 | 118 | -73.9566346046453 | 40.7973923396512 | 40D-PM-1013-01 | 40D | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566346046453 40.7973923396512) | 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 | |||||
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 | ||||||
133 | 133 | -73.9664711607022 | 40.787896428768 | 26A-PM-1006-06 | 26A | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Tree 90th left 90th & 89 | false | false | true | false | false | false | false | false | true | false | false | false | false | studying us looking for food | POINT (-73.9664711607022 40.787896428768) | 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 | |||||
140 | 140 | -73.9768652785664 | 40.7684838168207 | 3D-PM-1010-03 | 03D | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97686527856641 40.7684838168207) | 19 | 4 | 19 | 13 | |||||
142 | 142 | -73.9724063986771 | 40.7705711897977 | 7F-PM-1012-01 | 07F | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9724063986771 40.7705711897977) | 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 | |||||
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 | ||||||
167 | 167 | -73.9597642778427 | 40.7976368003915 | 39A-PM-1014-02 | 39A | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9597642778427 40.7976368003915) | 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 | ||||
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 | ||||||
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 | |||||||
174 | 174 | -73.9707274055755 | 40.7723889080377 | 10G-PM-1017-10 | 10G | PM | 10172018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | playing (with #9) | false | false | false | false | false | false | true | false | POINT (-73.9707274055755 40.7723889080377) | 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 | ||||||
193 | 193 | -73.9537691298752 | 40.7941272599797 | 38G-PM-1020-01 | 38G | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9537691298752 40.7941272599797) | 19 | 4 | 19 | 13 | |||||
196 | 196 | -73.965796978969 | 40.7760402842845 | 15H-PM-1008-03 | 15H | PM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | lawn moving east over Park path | false | false | false | false | false | not sure walk-pause-walk | false | false | false | false | false | false | true | false | POINT (-73.96579697896901 40.7760402842845) | 19 | 4 | 19 | 13 | ||||
197 | 197 | -73.9679336341793 | 40.7754186579647 | 14G-PM-1013-01 | 14G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | watching | POINT (-73.9679336341793 40.7754186579647) | 19 | 4 | 19 | 13 | ||||
201 | 201 | -73.9598015842806 | 40.7973522744237 | 38A-PM-1013-03 | 38A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9598015842806 40.7973522744237) | 19 | 4 | 19 | 13 | |||||
209 | 209 | -73.9710760196868 | 40.7725506006789 | 10F-PM-1019-02 | 10F | PM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Ground Plane | FALSE | Behind fence, grass | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9710760196868 40.7725506006789) | 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 | |||||
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 | |||
225 | 225 | -73.963842266151 | 40.7887340867773 | 28C-PM-1006-02 | 28C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Near rock | true | false | false | false | false | false | false | false | false | false | false | false | true | dog | POINT (-73.963842266151 40.7887340867773) | 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 | ||||||
235 | 235 | -73.9753574279936 | 40.7683211694257 | 4E-PM-1008-08 | 04E | PM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9753574279936 40.7683211694257) | 19 | 4 | 19 | 13 | ||||||
236 | 236 | -73.9737266070919 | 40.7786338379896 | 14A-PM-1014-01 | 14A | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9737266070919 40.7786338379896) | 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 | |||||
256 | 256 | -73.976798124308 | 40.7741316574113 | 9A-PM-1010-04 | 09A | PM | 10102018 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97679812430802 40.7741316574113) | 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 | ||||||
269 | 269 | -73.9591400366159 | 40.7891708599318 | 31F-PM-1007-01 | 31F | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | white neck and belly | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9591400366159 40.7891708599318) | 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 | ||||
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 | |||||
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 | |||||
286 | 286 | -73.9720907384613 | 40.7762987836055 | 13C-PM-1019-01 | 13C | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 7 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.9720907384613 40.7762987836055) | 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 | ||||
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 | ||||
298 | 298 | -73.957342596188 | 40.7944359654227 | 37E-PM-1006-09 | 37E | PM | 10062018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | moseying | false | false | false | false | true | true | false | false | POINT (-73.957342596188 40.7944359654227) | 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 | |||
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 | |||||
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 | |||||
316 | 316 | -73.9540616660191 | 40.7951556603245 | 38G-PM-1020-10 | 38G | PM | 10202018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9540616660191 40.7951556603245) | 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 | ||||||
318 | 318 | -73.9743990576746 | 40.7768690723163 | 12A-PM-1013-04 | 12A | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | false | true | false | false | false | chasing #3 | false | false | false | false | false | false | true | false | POINT (-73.9743990576746 40.7768690723163) | 19 | 4 | 19 | 13 | |||||
321 | 321 | -73.9694288806212 | 40.7842952265291 | 22A-PM-1017-01 | 22A | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9694288806212 40.7842952265291) | 19 | 4 | 19 | 13 | ||||||
322 | 322 | -73.9546042927016 | 40.7898133734952 | 33I-PM-1006-07 | 33I | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9546042927016 40.7898133734952) | 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 | |||||
329 | 329 | -73.967832992543 | 40.7783669913408 | 17E-PM-1018-03 | 17E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.967832992543 40.7783669913408) | 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 | |||
336 | 336 | -73.9757413215621 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757413215621 40.7692582758978) | 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 | |||
338 | 338 | -73.9765595553183 | 40.7748455340432 | 10A-PM-1014-04 | 10A | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9765595553183 40.7748455340432) | 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 | |||||
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 | |||||
356 | 356 | -73.9761036400144 | 40.7705482684594 | 6D-PM-1020-03 | 06D | PM | 10202018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9761036400144 40.7705482684594) | 19 | 4 | 19 | 13 | ||||||
359 | 359 | -73.9716404781264 | 40.7753181851766 | 12D-PM-1014-02 | 12D | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | seems to be grinding teeth on a piece of material (sounds from grinding) | false | false | false | false | false | false | true | false | POINT (-73.9716404781264 40.7753181851766) | 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 |
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 );