This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Zip Codes, Community Districts, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||
280 | 280 | -73.9587401274261 | 40.7960322222949 | 37C-PM-1013-03 | 37C | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9587401274261 40.7960322222949) | 19 | 4 | 19 | 13 | |||||||
537 | 537 | -73.9682803241007 | 40.7724510558327 | 11H-AM-1010-04 | 11H | AM | 10102018 | 4 | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9682803241007 40.7724510558327) | 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 | |||||
1405 | 1405 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9589371550945 40.7959812504467) | 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 | |||||||
1988 | 1988 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | true | true | true | false | false | chasing (#4),digging | false | false | false | false | true | false | true | false | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
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 | |||||||
2918 | 2918 | -73.9745152462626 | 40.7655415515908 | 1G-AM-1006-04 | 01G | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | false | true | false | false | true | collecting nest material | false | false | false | false | true | false | true | false | POINT (-73.9745152462626 40.76554155159081) | 19 | 4 | 19 | 13 | ||||||
25 | 25 | -73.9671130680114 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24 | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9671130680114 40.7784859700171) | 19 | 4 | 19 | 13 | |||||
45 | 45 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9579645940414 40.7918613498407) | 19 | 4 | 19 | 13 | |||||
80 | 80 | -73.9688454483585 | 40.7845301288163 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9688454483585 40.7845301288163) | 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 | ||||
137 | 137 | -73.9782417115139 | 40.7724665036447 | 7A-AM-1006-01 | 07A | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | false | false | false | false | true | false | true | false | false | true | false | false | false | looked at us | POINT (-73.9782417115139 40.7724665036447) | 19 | 4 | 19 | 13 | |||
163 | 163 | -73.9712308864394 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | false | false | grooming | false | false | false | false | false | false | true | false | POINT (-73.9712308864394 40.7714534847379) | 19 | 4 | 19 | 13 | ||||
189 | 189 | -73.9735489537928 | 40.7681257911523 | 4G-AM-1006-02 | 04G | AM | 10062018 | 2 | Gray | White | Gray+White | Above Ground | 12 | tree | false | false | false | false | false | sitting in tree | false | false | false | false | false | false | true | false | POINT (-73.9735489537928 40.7681257911523) | 19 | 4 | 19 | 13 | ||||
212 | 212 | -73.9638837160341 | 40.7809747900833 | 21G-AM-1014-07 | 21G | AM | 10142018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 5 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9638837160341 40.7809747900833) | 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 | ||||
258 | 258 | -73.9534333425633 | 40.7932564163328 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | false | false | false | true | false | false | true | false | false | false | false | false | true | POINT (-73.9534333425633 40.7932564163328) | 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 | |||
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 | |||
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 | |||||
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 | ||||
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 | ||||
426 | 426 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on railing | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
428 | 428 | -73.96362827608 | 40.7807994595242 | 21G-AM-1014-02 | 21G | AM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 3 | fence | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.96362827608 40.7807994595242) | 19 | 4 | 19 | 13 | ||||
440 | 440 | -73.9642717435966 | 40.782087049693 | 22F-AM-1007-05 | 22F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9642717435966 40.782087049693) | 19 | 4 | 19 | 13 | ||||
483 | 483 | -73.9789952029637 | 40.7697758333099 | 4B-AM-1010-03 | 04B | AM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9789952029637 40.7697758333099) | 19 | 4 | 19 | 13 | |||||
488 | 488 | -73.9615751148595 | 40.7954551238146 | 36A-AM-1018-01 | 36A | AM | 10182018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | eating (red berries) | false | false | false | false | false | false | true | false | POINT (-73.9615751148595 40.7954551238146) | 19 | 4 | 19 | 13 | ||||
498 | 498 | -73.9669432929573 | 40.779136518298 | 18F-AM-1014-01 | 18F | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | Low tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9669432929573 40.779136518298) | 19 | 4 | 19 | 13 | |||||
508 | 508 | -73.9746918762076 | 40.7655231883678 | 1G-AM-1006-02 | 01G | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30 | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9746918762076 40.7655231883678) | 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 | |||||
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 | ||||
702 | 702 | -73.963858549251 | 40.7808999610914 | 21G-AM-1014-03 | 21G | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 7 | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.963858549251 40.7808999610914) | 19 | 4 | 19 | 13 | |||||
737 | 737 | -73.9711176999471 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | Different tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9711176999471 40.7724278547281) | 19 | 4 | 19 | 13 | ||||
773 | 773 | -73.9566189145352 | 40.7883417969746 | 31H-PM-1008-01 | 31H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9566189145352 40.7883417969746) | 19 | 4 | 19 | 13 | |||||
781 | 781 | -73.955516031113 | 40.7923188156277 | 35G-AM-1007-01 | 35G | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.955516031113 40.7923188156277) | 19 | 4 | 19 | 13 | |||||
792 | 792 | -73.9730115687964 | 40.7741018274312 | 10D-AM-1008-05 | 10D | AM | 10082018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.9730115687964 40.7741018274312) | 19 | 4 | 19 | 13 | |||||
856 | 856 | -73.9591667162801 | 40.7937602121568 | 35D-PM-1013-07 | 35D | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Above Ground | 12 | tree | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.95916671628011 40.7937602121568) | 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 | |||||
917 | 917 | -73.9676514056678 | 40.7730853732876 | 11H-AM-1010-01 | 11H | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | true | false | false | started climbing down to me | POINT (-73.9676514056678 40.7730853732876) | 19 | 4 | 19 | 13 | ||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | true | false | true | false | true | true | true | false | false | false | false | true | false | POINT (-73.9547959269955 40.7925162926273) | 19 | 4 | 19 | 13 | ||||
966 | 966 | -73.958317581802 | 40.7916566683158 | 33E-AM-1014-12 | 33E | AM | 10142018 | 12 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | false | false | sleeping | false | false | false | false | false | false | false | false | asleep | POINT (-73.958317581802 40.7916566683158) | 19 | 4 | 19 | 13 | |||
996 | 996 | -73.9703149829421 | 40.7785583630323 | 16D-AM-1007-01 | 16D | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9703149829421 40.7785583630323) | 19 | 4 | 19 | 13 | |||||
999 | 999 | -73.980948293606 | 40.7685688850628 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
1028 | 1028 | -73.9707012345661 | 40.7758938984066 | 13E-PM-1008-03 | 13E | PM | 10082018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | hanging upside down to get a nut | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9707012345661 40.7758938984066) | 19 | 4 | 19 | 13 | ||||
1080 | 1080 | -73.9690211935346 | 40.773038298158 | 11H-AM-1010-07 | 11H | AM | 10102018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 4 | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9690211935346 40.773038298158) | 19 | 4 | 19 | 13 | |||||
1116 | 1116 | -73.9729847109778 | 40.7740709049602 | 10D-AM-1008-03 | 10D | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9729847109778 40.7740709049602) | 19 | 4 | 19 | 13 | |||||
1126 | 1126 | -73.9700186001049 | 40.7826052184658 | 20B-AM-1007-03 | 20B | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9700186001049 40.7826052184658) | 19 | 4 | 19 | 13 | ||||||
1133 | 1133 | -73.9712550584322 | 40.7764273475386 | 13D-PM-1018-06 | 13D | PM | 10182018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | cleaning | false | false | false | false | false | false | true | false | POINT (-73.9712550584322 40.7764273475386) | 19 | 4 | 19 | 13 | ||||
1154 | 1154 | -73.9786936992465 | 40.7713943674666 | 5A-PM-1010-02 | 05A | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9786936992465 40.7713943674666) | 19 | 4 | 19 | 13 | |||||
1182 | 1182 | -73.9667206046912 | 40.7779993565098 | 17G-PM-1017-04 | 17G | PM | 10172018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9667206046912 40.7779993565098) | 19 | 4 | 19 | 13 | ||||
1203 | 1203 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | eating (red berries) | false | false | false | false | false | false | true | false | POINT (-73.9616999731028 40.7954126939561) | 19 | 4 | 19 | 13 | ||||
1225 | 1225 | -73.9584803513939 | 40.7933802077327 | 35D-PM-1013-01 | 35D | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 12 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9584803513939 40.7933802077327) | 19 | 4 | 19 | 13 | |||||
1241 | 1241 | -73.9651817987035 | 40.7819082838334 | 21E-AM-1017-01 | 21E | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | Climbs small tree | false | false | false | true | true | false | false | false | false | true | false | false | false | walks from | POINT (-73.9651817987035 40.7819082838334) | 19 | 4 | 19 | 13 | |||
1252 | 1252 | -73.9777998932399 | 40.7709815865334 | 5B-PM-1013-02 | 05B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9777998932399 40.7709815865334) | 19 | 4 | 19 | 13 | |||||
1268 | 1268 | -73.9623984262936 | 40.7913900453449 | 31C-PM-1010-03 | 31C | PM | 10102018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9623984262936 40.7913900453449) | 19 | 4 | 19 | 13 | |||||
1315 | 1315 | -73.9595955824812 | 40.7933047943534 | 34D-PM-1007-01 | 34D | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | false | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9595955824812 40.7933047943534) | 19 | 4 | 19 | 13 | |||||
1324 | 1324 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | 19 | 4 | 19 | 13 | ||||
1328 | 1328 | -73.9765758043111 | 40.7713803154032 | 6C-AM-1007-03 | 06C | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 8 | another tree | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9765758043111 40.7713803154032) | 19 | 4 | 19 | 13 | ||||
1374 | 1374 | -73.9653739273979 | 40.7889762096967 | 28B-PM-1010-02 | 28B | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9653739273979 40.7889762096967) | 19 | 4 | 19 | 13 | |||||
1381 | 1381 | -73.9586077039567 | 40.7961896477077 | 38C-AM-1019-10 | 38C | AM | 10192018 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20 | true | false | true | true | false | true | false | false | false | true | false | false | true | POINT (-73.9586077039567 40.7961896477077) | 19 | 4 | 19 | 13 | |||||
1395 | 1395 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 10142018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2 | false | true | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9710801547498 40.7760872452093) | 19 | 4 | 19 | 13 | |||||
1397 | 1397 | -73.9655233748105 | 40.7792737287734 | 18G-AM-1014-01 | 18G | AM | 10142018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | true | false | looking | POINT (-73.9655233748105 40.7792737287734) | 19 | 4 | 19 | 13 | ||||
1410 | 1410 | -73.9587913289229 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 10192018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20 | true | false | true | true | false | true | false | false | false | true | false | false | true | POINT (-73.9587913289229 40.7961707624534) | 19 | 4 | 19 | 13 | |||||
1411 | 1411 | -73.9802840031759 | 40.7678599069819 | 1B-PM-1019-04 | 01B | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9802840031759 40.7678599069819) | 19 | 4 | 19 | 13 | ||||
1413 | 1413 | -73.9810032206428 | 40.7681625634979 | 1A-AM-1007-01 | 01A | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9810032206428 40.7681625634979) | 19 | 4 | 19 | 13 | |||||
1414 | 1414 | -73.9580513096783 | 40.79909641532 | 41B-AM-1010-02 | 41B | AM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 16 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9580513096783 40.79909641532) | 19 | 4 | 19 | 13 | |||||
1423 | 1423 | -73.9600204328201 | 40.782877291358 | 24I-AM-1019-01 | 24I | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9600204328201 40.782877291358) | 19 | 4 | 19 | 13 | |||||
1466 | 1466 | -73.9651177657676 | 40.7812408103825 | 20F-PM-1007-05 | 20F | PM | 10072018 | 5 | Juvenile | Gray | White | Gray+White | white tail | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9651177657676 40.781240810382506) | 19 | 4 | 19 | 13 | ||||
1489 | 1489 | -73.9501762527462 | 40.7975534086077 | 42H-PM-1014-05 | 42H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9501762527462 40.7975534086077) | 12423 | 18 | 4 | 36 | 18 | ||||
1500 | 1500 | -73.9769969548024 | 40.7710711265211 | 6C-AM-1007-01 | 06C | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | vid! | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | false | false | curious,but wary | POINT (-73.97699695480242 40.7710711265211) | 19 | 4 | 19 | 13 | |||
1659 | 1659 | -73.9690498876944 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 10062018 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9690498876944 40.7700011818847) | 19 | 4 | 19 | 13 | ||||
1727 | 1727 | -73.9692472299565 | 40.7722592187215 | 10H-PM-1007-01 | 10H | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | dark gray | Above Ground | 15 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692472299565 40.7722592187215) | 19 | 4 | 19 | 13 | |||
1745 | 1745 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 10062018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20 | tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9688438058715 40.7703014325728) | 19 | 4 | 19 | 13 | ||||
1747 | 1747 | -73.9665763797607 | 40.7761316400012 | 15H-AM-1013-03 | 15H | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9665763797607 40.7761316400012) | 19 | 4 | 19 | 13 | |||||
1767 | 1767 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 10142018 | 4 | Gray | White | Gray+White | Above Ground | 15 | Ground then tree to eat | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
1783 | 1783 | -73.9730001080547 | 40.7678719218983 | 4G-AM-1006-05 | 04G | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | true | false | indifferent—was in front of my face (we were on a bridge)! | POINT (-73.9730001080547 40.7678719218983) | 19 | 4 | 19 | 13 | |||
1787 | 1787 | -73.9720365327715 | 40.7762329714016 | 13D-PM-1018-11 | 13D | PM | 10182018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | false | true | false | true | false | POINT (-73.9720365327715 40.7762329714016) | 19 | 4 | 19 | 13 | |||||
1804 | 1804 | -73.980777106431 | 40.7681635726316 | 1A-AM-1007-02 | 01A | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 11 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.980777106431 40.7681635726316) | 19 | 4 | 19 | 13 | |||||
1825 | 1825 | -73.9624209799704 | 40.7910200972752 | 31C-PM-1010-01 | 31C | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9624209799704 40.7910200972752) | 19 | 4 | 19 | 13 | |||||
1851 | 1851 | -73.9623621412501 | 40.7814673556041 | 22H-PM-1007-03 | 22H | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | chased squirrel #2 away | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9623621412501 40.7814673556041) | 19 | 4 | 19 | 13 | ||||
1915 | 1915 | -73.9797112925048 | 40.7688046778472 | 2B-PM-1013-09 | 02B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
1924 | 1924 | -73.9542332505231 | 40.7933475171434 | 37G-AM-1014-01 | 37G | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | White tail | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9542332505231 40.7933475171434) | 19 | 4 | 19 | 13 | ||||
1933 | 1933 | -73.9584824361655 | 40.7934247634031 | 35D-PM-1013-02 | 35D | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 24 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9584824361655 40.7934247634031) | 19 | 4 | 19 | 13 | |||||
1935 | 1935 | -73.9675268877392 | 40.7750409681718 | 13H-AM-1013-01 | 13H | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9675268877392 40.7750409681718) | 19 | 4 | 19 | 13 | |||||
1972 | 1972 | -73.9558370309765 | 40.7921977208472 | 35G-AM-1007-02 | 35G | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9558370309765 40.7921977208472) | 19 | 4 | 19 | 13 | |||||
1977 | 1977 | -73.9586570546871 | 40.796349417475 | 38C-AM-1019-09 | 38C | AM | 10192018 | 9 | Adult | Gray | White | Gray+White | Gray & White selected as Primary & Highlights. Made executive adjustments. | Above Ground | 3 | Between ground & tree | false | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.9586570546871 40.796349417475) | 19 | 4 | 19 | 13 | |||
1987 | 1987 | -73.9573692542155 | 40.7989252908321 | 41B-PM-1014-03 | 41B | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9573692542155 40.7989252908321) | 19 | 4 | 19 | 13 | |||||
1999 | 1999 | -73.9549860947234 | 40.7911550328309 | 34H-PM-1006-07 | 34H | PM | 10062018 | 7 | Juvenile | Gray | White | Gray+White | white belly | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9549860947234 40.7911550328309) | 19 | 4 | 19 | 13 | ||||
2002 | 2002 | -73.9581706950566 | 40.7906321397269 | 32F-AM-1012-05 | 32F | AM | 10122018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9581706950566 40.7906321397269) | 19 | 4 | 19 | 13 | |||||
2069 | 2069 | -73.9538377039825 | 40.7980605334961 | 42E-PM-1012-03 | 42E | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | false | false | true | false | true | true | false | false | false | false | false | true | false | POINT (-73.9538377039825 40.7980605334961) | 19 | 4 | 19 | 13 | ||||
2071 | 2071 | -73.9667694439895 | 40.7779501809095 | 17G-PM-1017-03 | 17G | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9667694439895 40.7779501809095) | 19 | 4 | 19 | 13 | ||||
2084 | 2084 | -73.9567255763265 | 40.7936331899263 | 36F-AM-1017-05 | 36F | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 8 | false | false | false | false | false | staying very still to avoid two very curious dogs on the ground | false | false | false | false | false | false | false | false | petrified,frozen (tail over its back,frozen) | POINT (-73.9567255763265 40.7936331899263) | 19 | 4 | 19 | 13 | |||
2103 | 2103 | -73.9782983634755 | 40.7668314364263 | 1D-AM-1006-04 | 01D | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9782983634755 40.7668314364263) | 19 | 4 | 19 | 13 | |||||
2144 | 2144 | -73.975198284551 | 40.7740343763399 | 9B-AM-1010-06 | 09B | AM | 10102018 | 6 | Juvenile | Gray | White | Gray+White | Above Ground | 16 | tree | false | false | true | false | false | cleaning | false | false | false | false | false | false | true | false | POINT (-73.975198284551 40.7740343763399) | 19 | 4 | 19 | 13 | |||
2145 | 2145 | -73.9651250402583 | 40.7812884929069 | 20F-PM-1007-04 | 20F | PM | 10072018 | 4 | Juvenile | Gray | White | Gray+White | white on tail | Above Ground | 20 | climbed tree | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9651250402583 40.7812884929069) | 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 );