This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Running, Chasing, Eating, Foraging, Kuks, Quaas, Moans, Tail flags, Approaches, Indifferent, Runs from, Other Interactions, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2067 | 2067 | -73.9725077933574 | 40.7654562710325 | 2I-PM-1006-01 | 02I | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | Sitting on back of bench with food hanging from mouth | false | false | false | false | false | staring at me | false | false | false | false | false | false | false | true | POINT (-73.9725077933574 40.7654562710325) | 19 | 4 | 19 | 13 | |||
1333 | 1333 | -73.9754527701832 | 40.7656088463928 | 1G-PM-1010-02 | 01G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | false | false | false | laying on tree branch | false | false | false | true | true | false | false | false | POINT (-73.9754527701832 40.7656088463928) | 19 | 4 | 19 | 13 | ||||
2136 | 2136 | -73.9721897915211 | 40.7660434203132 | 3I-AM-1010-02 | 03I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721897915211 40.76604342031321) | 19 | 4 | 19 | 13 | ||||||
2914 | 2914 | -73.9722053355548 | 40.7662094993614 | 3I-AM-1010-03 | 03I | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9722053355548 40.7662094993614) | 19 | 4 | 19 | 13 | ||||||
1254 | 1254 | -73.9764013589865 | 40.7663063499207 | 1F-PM-1019-03 | 01F | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | false | false | false | false | false | hiding | false | false | false | false | false | false | false | false | POINT (-73.9764013589865 40.7663063499207) | 19 | 4 | 19 | 13 | |||||
2680 | 2680 | -73.9721348050673 | 40.7666920046704 | 3H-AM-1008-01 | 03H | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | false | false | false | false | false | teasing barking dog | false | false | false | false | false | false | true | false | indifferent by not caring about dog | POINT (-73.9721348050673 40.7666920046704) | 19 | 4 | 19 | 13 | |||
2322 | 2322 | -73.9723677854798 | 40.7667315410871 | 3H-AM-1008-04 | 03H | AM | 10082018 | 4 | Adult | Black | Black+ | Above Ground | 50 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9723677854798 40.7667315410871) | 19 | 4 | 19 | 13 | ||||||
394 | 394 | -73.9719888241794 | 40.7667681685356 | 4I-PM-1007-03 | 04I | PM | 10072018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | ran to tree | false | false | false | false | false | being chased | false | false | false | false | false | false | false | false | POINT (-73.9719888241794 40.7667681685356) | 19 | 4 | 19 | 13 | |||
2128 | 2128 | -73.9757673193743 | 40.7669614322613 | 2F-PM-1014-04 | 02F | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9757673193743 40.766961432261304) | 19 | 4 | 19 | 13 | ||||||
2767 | 2767 | -73.9751806727197 | 40.7671940332258 | 3F-PM-1013-05 | 03F | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 13 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97518067271972 40.7671940332258) | 19 | 4 | 19 | 13 | |||||
2755 | 2755 | -73.9712022111028 | 40.7672504368263 | 4I-AM-1006-01 | 04I | AM | 10062018 | 1 | Adult | Black | Black+ | Above Ground | 3 | On top of park lamp | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
2025 | 2025 | -73.9766541879006 | 40.7674077265375 | 2E-AM-1010-06 | 02E | AM | 10102018 | 6 | Adult | Cinnamon | Cinnamon+ | Above Ground | 35 | false | false | false | false | false | leaping branch to branch | false | false | false | false | false | false | true | false | POINT (-73.9766541879006 40.7674077265375) | 19 | 4 | 19 | 13 | |||||
1446 | 1446 | -73.9775238847836 | 40.7675792683587 | 2D-AM-1007-05 | 02D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 100 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775238847836 40.7675792683587) | 19 | 4 | 19 | 13 | ||||||
2502 | 2502 | -73.9758375334287 | 40.7676793289765 | 3E-AM-1006-06 | 03E | AM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 14 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9758375334287 40.7676793289765) | 19 | 4 | 19 | 13 | |||||
2865 | 2865 | -73.9802842404016 | 40.7678257384977 | 1B-PM-1019-03 | 01B | PM | 10192018 | 3 | 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.98028424040162 40.7678257384977) | 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 | ||||
2476 | 2476 | -73.9710843362124 | 40.7679739601336 | 5I-AM-1010-03 | 05I | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9710843362124 40.7679739601336) | 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 | ||||
2233 | 2233 | -73.9754709117681 | 40.7681421869407 | 3E-AM-1006-08 | 03E | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9754709117681 40.7681421869407) | 19 | 4 | 19 | 13 | |||||
600 | 600 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
2387 | 2387 | -73.9808517324721 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 10142018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9808517324721 40.7683154647217) | 19 | 4 | 19 | 13 | |||||
650 | 650 | -73.9809610117171 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
2573 | 2573 | -73.9810149147578 | 40.7683925377714 | 2A-AM-1010-03 | 02A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | on trunk | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9810149147578 40.7683925377714) | 19 | 4 | 19 | 13 | ||||
2412 | 2412 | -73.9809446489564 | 40.7685032165879 | 2A-PM-1019-03 | 02A | PM | 10192018 | 3 | 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.9809446489564 40.7685032165879) | 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 | ||||
2950 | 2950 | -73.9790980124501 | 40.7685934093915 | 2B-PM-1013-08 | 02B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9790980124501 40.7685934093915) | 19 | 4 | 19 | 13 | |||||
1384 | 1384 | -73.9787608762005 | 40.7686062296462 | 3C-PM-1008-01 | 03C | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | false | false | false | false | false | walked between trees | false | false | false | false | false | false | true | false | POINT (-73.9787608762005 40.7686062296462) | 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 | |||
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | true | false | false | false | false | was chased by # 11 | true | false | false | false | false | false | false | true | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 | ||||
1768 | 1768 | -73.9773696455031 | 40.7687241866704 | 3D-PM-1010-14 | 03D | PM | 10102018 | 14 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | crying out | true | true | false | false | false | false | false | false | POINT (-73.9773696455031 40.7687241866704) | 19 | 4 | 19 | 13 | ||||
2777 | 2777 | -73.9810843611086 | 40.7687905493699 | 2A-PM-1019-05 | 02A | PM | 10192018 | 5 | ? | Gray | Gray+ | Above Ground | 50 | in tall planetree | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9810843611086 40.7687905493699) | 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 | |||||
1408 | 1408 | -73.973230162241 | 40.7689824531444 | 5F-AM-1007-01 | 05F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | fence | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.973230162241 40.7689824531444) | 19 | 4 | 19 | 13 | ||||
2699 | 2699 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.97435094238212 40.7690043677328) | 19 | 4 | 19 | 13 | |||||
2385 | 2385 | -73.9787552947847 | 40.7690779628762 | 3B-AM-1010-06 | 03B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9787552947847 40.7690779628762) | 19 | 4 | 19 | 13 | ||||||
1495 | 1495 | -73.9735137178369 | 40.769109895294 | 5F-AM-1007-06 | 05F | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 2 | branch | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9735137178369 40.769109895294) | 19 | 4 | 19 | 13 | |||||
1661 | 1661 | -73.974519308015 | 40.7691228794395 | 5E-AM-1008-02 | 05E | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | trellis | true | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.974519308015 40.7691228794395) | 19 | 4 | 19 | 13 | ||||
1239 | 1239 | -73.9725897240269 | 40.7691342079294 | 6G-AM-1008-01 | 06G | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | in tree | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9725897240269 40.7691342079294) | 19 | 4 | 19 | 13 | |||
2706 | 2706 | -73.9745141185576 | 40.7691479781207 | 5E-AM-1008-01 | 05E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on a checker table | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9745141185576 40.7691479781207) | 19 | 4 | 19 | 13 | ||||
2389 | 2389 | -73.9801343393329 | 40.7691512453402 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9801343393329 40.7691512453402) | 19 | 4 | 19 | 13 | ||||
441 | 441 | -73.9742973420446 | 40.7691801644292 | 5F-AM-1007-04 | 05F | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | rocks | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9742973420446 40.7691801644292) | 19 | 4 | 19 | 13 | |||||
1923 | 1923 | -73.9743795190073 | 40.7692030411004 | 5E-AM-1008-05 | 05E | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9743795190073 40.7692030411004) | 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 | ||||
2893 | 2893 | -73.9793101482654 | 40.7692600238491 | 3B-PM-1007-02 | 03B | PM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | in tree | false | false | false | false | false | chased by dog | false | false | false | false | false | false | false | false | POINT (-73.9793101482654 40.7692600238491) | 19 | 4 | 19 | 13 | ||||
1297 | 1297 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 10122018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9802831706033 40.7692763295564) | 19 | 4 | 19 | 13 | ||||
2944 | 2944 | -73.9739403850622 | 40.7693162287509 | 5F-AM-1007-05 | 05F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 2 | tree | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9739403850622 40.7693162287509) | 19 | 4 | 19 | 13 | ||||
2177 | 2177 | -73.9758211560957 | 40.7693422860766 | 5E-AM-1008-10 | 05E | AM | 10082018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | up a tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9758211560957 40.7693422860766) | 19 | 4 | 19 | 13 | ||||
1871 | 1871 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | oak tree at end of ramp from Chess House | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9748367344424 40.7693513000034) | 19 | 4 | 19 | 13 | ||||
2403 | 2403 | -73.9777879635216 | 40.769359455673 | 4C-AM-1006-03 | 04C | AM | 10062018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9777879635216 40.769359455673) | 19 | 4 | 19 | 13 | ||||||
377 | 377 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 10082018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | went up tree | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
1799 | 1799 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 10102018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | true | false | false | false | chasing squirrel #6 | true | true | false | false | true | false | false | false | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
2640 | 2640 | -73.9788304714091 | 40.7696373635315 | 4B-AM-1010-06 | 04B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 12 | true | false | false | false | false | running from squirrel #5 | false | false | false | false | false | false | false | false | POINT (-73.9788304714091 40.7696373635315) | 19 | 4 | 19 | 13 | |||||
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
729 | 729 | -73.9776044578446 | 40.7697607308033 | 4C-PM-1010-15 | 04C | PM | 10102018 | 15 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree | false | true | false | false | false | chasing #14 | false | false | false | false | false | false | true | false | POINT (-73.9776044578446 40.7697607308033) | 19 | 4 | 19 | 13 | ||||
352 | 352 | -73.970540988328 | 40.7698103067062 | 7H-AM-1006-06 | 07H | AM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.970540988328 40.7698103067062) | 19 | 4 | 19 | 13 | |||||
20 | 20 | -73.9706105896967 | 40.7698124821507 | 7H-AM-1006-05 | 07H | AM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706105896967 40.7698124821507) | 19 | 4 | 19 | 13 | |||||
2831 | 2831 | -73.9753585157592 | 40.7698398607941 | 5E-AM-1008-07 | 05E | AM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | on fence | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9753585157592 40.7698398607941) | 19 | 4 | 19 | 13 | ||||
476 | 476 | -73.9690968160819 | 40.769923269444 | 8I-AM-1006-08 | 08I | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | not backing down | POINT (-73.9690968160819 40.769923269444) | 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 | ||||
2393 | 2393 | -73.9729190572117 | 40.770018150905 | 6F-PM-1008-03 | 06F | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | top of tree | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9729190572117 40.770018150905) | 19 | 4 | 19 | 13 | |||||
1575 | 1575 | -73.9703169373939 | 40.7700658823854 | 7H-AM-1006-13 | 07H | AM | 10062018 | 13 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | running (up tree) | false | false | false | false | false | false | true | false | POINT (-73.9703169373939 40.7700658823854) | 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 | |||||
1960 | 1960 | -73.9730158913661 | 40.7701310707272 | 6F-PM-1008-02 | 06F | PM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | true | true | false | false | false | chasing #2 | false | false | false | false | false | false | false | false | POINT (-73.9730158913661 40.7701310707272) | 19 | 4 | 19 | 13 | ||||
1817 | 1817 | -73.9703076450783 | 40.770158422629 | 8H-PM-1014-07 | 08H | PM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#8),playing? | false | false | false | false | false | false | true | false | POINT (-73.9703076450783 40.770158422629) | 19 | 4 | 19 | 13 | |||||
110 | 110 | -73.9711318790279 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
1527 | 1527 | -73.970216605149 | 40.7702960667277 | 8H-PM-1014-08 | 08H | PM | 10142018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#7),playing? | false | false | false | false | false | false | true | false | POINT (-73.970216605149 40.7702960667277) | 19 | 4 | 19 | 13 | |||||
1016 | 1016 | -73.9691293546408 | 40.7703219076549 | 8I-AM-1006-11 | 08I | AM | 10062018 | 11 | Adult | Gray | Gray+ | Above Ground | 50 | tree | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691293546408 40.77032190765491) | 19 | 4 | 19 | 13 | |||||
1434 | 1434 | -73.9760749752948 | 40.7703284894392 | 5D-PM-1018-02 | 05D | PM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | On low fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9760749752948 40.7703284894392) | 19 | 4 | 19 | 13 | |||||
1770 | 1770 | -73.9728170980779 | 40.7703557830437 | 7F-AM-1008-06 | 07F | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 28 | in hole in tree | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9728170980779 40.770355783043705) | 19 | 4 | 19 | 13 | ||||
2267 | 2267 | -73.9727926335397 | 40.77037055775 | 7F-AM-1008-07 | 07F | AM | 10082018 | 7 | Adult | Gray | Gray+ | Above Ground | 28 | next to the hole of #6 | false | false | false | false | false | standing | false | false | false | false | false | false | true | false | POINT (-73.9727926335397 40.77037055775) | 19 | 4 | 19 | 13 | ||||
2694 | 2694 | -73.969628583287 | 40.7704067797932 | 8H-AM-1017-03 | 08H | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | fence | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.969628583287 40.7704067797932) | 19 | 4 | 19 | 13 | ||||
1179 | 1179 | -73.9696762034757 | 40.7704883494264 | 8H-AM-1017-02 | 08H | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | root bed of tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9696762034757 40.7704883494264) | 19 | 4 | 19 | 13 | ||||
1020 | 1020 | -73.97016933635 | 40.7705452529783 | 8H-AM-1017-05 | 08H | AM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.97016933635001 40.7705452529783) | 19 | 4 | 19 | 13 | |||||
2331 | 2331 | -73.9694681803635 | 40.770585795359 | 8I-AM-1006-06 | 08I | AM | 10062018 | 6 | Adult | Gray | White | Gray+White | Above Ground | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694681803635 40.770585795359) | 19 | 4 | 19 | 13 | ||||||
44 | 44 | -73.970252675331 | 40.7705999588222 | 8H-AM-1017-06 | 08H | AM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.970252675331 40.77059995882221) | 19 | 4 | 19 | 13 | |||||
2521 | 2521 | -73.976869549792 | 40.7706982454723 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | false | false | false | false | false | relaxing | false | false | false | true | false | false | true | false | POINT (-73.976869549792 40.7706982454723) | 19 | 4 | 19 | 13 | |||
896 | 896 | -73.9755055978764 | 40.7707438681742 | 6D-AM-1008-02 | 06D | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9755055978764 40.7707438681742) | 19 | 4 | 19 | 13 | ||||||
2334 | 2334 | -73.9754922970511 | 40.7707686392991 | 6D-AM-1008-03 | 06D | AM | 10082018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9754922970511 40.7707686392991) | 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 | ||||
1226 | 1226 | -73.97684509717 | 40.7709430375069 | 5C-PM-1010-07 | 05C | PM | 10102018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 13 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97684509717 40.7709430375069) | 19 | 4 | 19 | 13 | |||||
2648 | 2648 | -73.9729410488021 | 40.7709484964577 | 7F-AM-1008-13 | 07F | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 4 | to tree | true | false | false | true | true | ran up tree 4 feet and ate leaves | false | false | false | false | false | false | true | false | POINT (-73.9729410488021 40.7709484964577) | 19 | 4 | 19 | 13 | ||||
98 | 98 | -73.9730277911422 | 40.7712145488828 | 7F-AM-1008-16 | 07F | AM | 10082018 | 16 | Juvenile | Gray | Gray+ | Above Ground | 2 | tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9730277911422 40.7712145488828) | 19 | 4 | 19 | 13 | |||||
1060 | 1060 | -73.9728871061191 | 40.7712983658944 | 8F-PM-1012-08 | 08F | PM | 10122018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9728871061191 40.7712983658944) | 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 | ||||||
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 | ||||
335 | 335 | -73.9782351435852 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | false | true | false | true | false | false | false | false | true | true | false | false | false | POINT (-73.9782351435852 40.7715896672335) | 19 | 4 | 19 | 13 | ||||
1006 | 1006 | -73.9686296217893 | 40.771812308875 | 10H-AM-1014-02 | 10H | AM | 10142018 | 2 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 6 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686296217893 40.771812308875) | 19 | 4 | 19 | 13 | ||||||
747 | 747 | -73.9771422625274 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9771422625274 40.772361415776) | 19 | 4 | 19 | 13 | ||||||
2433 | 2433 | -73.9706949930717 | 40.772362045852 | 10G-AM-1006-08 | 10G | AM | 10062018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 3 | false | false | false | true | false | false | false | false | true | true | false | true | false | POINT (-73.9706949930717 40.772362045852) | 19 | 4 | 19 | 13 | |||||
811 | 811 | -73.9771695272048 | 40.7724277276263 | 7B-AM-1008-03 | 07B | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9771695272048 40.7724277276263) | 19 | 4 | 19 | 13 | ||||||
849 | 849 | -73.9736165917399 | 40.7724543901497 | 8D-AM-1007-04 | 08D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | chasing squirrel #3 | false | false | false | false | false | false | false | false | POINT (-73.9736165917399 40.7724543901497) | 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 | |||
2917 | 2917 | -73.9770313887741 | 40.7724869252099 | 7B-AM-1008-05 | 07B | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9770313887741 40.772486925209904) | 19 | 4 | 19 | 13 | |||||||
1624 | 1624 | -73.9737060043988 | 40.7725660224983 | 8D-AM-1007-05 | 08D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9737060043988 40.7725660224983) | 19 | 4 | 19 | 13 | ||||||
801 | 801 | -73.9743342303548 | 40.7727742948332 | 8D-AM-1007-08 | 08D | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | false | false | communicating from tree | false | false | false | false | false | false | false | false | POINT (-73.97433423035481 40.7727742948332) | 19 | 4 | 19 | 13 | |||||
1065 | 1065 | -73.9769700777377 | 40.7728489574967 | 7B-AM-1008-08 | 07B | AM | 10082018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9769700777377 40.7728489574967) | 19 | 4 | 19 | 13 | ||||||
2417 | 2417 | -73.9720323148189 | 40.7729703459618 | 10E-PM-1007-01 | 10E | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9720323148189 40.7729703459618) | 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 | |||||
1623 | 1623 | -73.9770119133023 | 40.7732949090005 | 8A-AM-1013-04 | 08A | AM | 10132018 | 4 | Juvenile | + | Above Ground | 4 | fence | true | true | false | true | true | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770119133023 40.7732949090005) | 19 | 4 | 19 | 13 | |||||
2542 | 2542 | -73.9754802138871 | 40.773300804412 | 9C-PM-1006-03 | 09C | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9754802138871 40.773300804412) | 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 );