This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||
1451 | 1451 | -73.9645365195454 | 40.7781531021263 | 18H-AM-1018-02 | 18H | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | true | true | false | false | false | playing? | false | false | false | false | false | false | false | false | POINT (-73.9645365195454 40.7781531021263) | 19 | 4 | 19 | 13 | ||||
1459 | 1459 | -73.9563847867316 | 40.7906012261163 | 33G-AM-1013-03 | 33G | AM | 10132018 | 3 | ? | + | Only peeked head out | Above Ground | 13 | false | false | false | false | false | peeking out of tree,did *not* come out | false | false | false | false | false | false | false | false | POINT (-73.9563847867316 40.7906012261163) | 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 | ||||
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 | |||||
1506 | 1506 | -73.9728339757306 | 40.7782891207966 | 14B-PM-1014-04 | 14B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | running up and down | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9728339757306 40.7782891207966) | 19 | 4 | 19 | 13 | ||||
1508 | 1508 | -73.9693894305786 | 40.7756906748026 | 13F-PM-1008-04 | 13F | PM | 10082018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9693894305786 40.7756906748026) | 19 | 4 | 19 | 13 | |||||
1553 | 1553 | -73.9690645326017 | 40.7773822116124 | 15E-AM-1013-03 | 15E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | on fallen log | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9690645326017 40.7773822116124) | 19 | 4 | 19 | 13 | |||||
1554 | 1554 | -73.9597462612063 | 40.7832801145306 | 25I-PM-1007-06 | 25I | PM | 10072018 | 6 | + | Didn't see squirrel size, or colors | Above Ground | 20 | up in tree | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9597462612063 40.7832801145306) | 19 | 4 | 19 | 13 | ||||||
1572 | 1572 | -73.9540197079615 | 40.798039260983 | 41E-PM-1013-03 | 41E | PM | 10132018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray on legs | Above Ground | 20 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540197079615 40.798039260983) | 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 | |||||
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 | ||||||
1649 | 1649 | -73.969347812694 | 40.7744098063421 | 12G-PM-1007-02 | 12G | PM | 10072018 | 2 | Gray | Gray+ | Above Ground | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.969347812694 40.7744098063421) | 19 | 4 | 19 | 13 | |||||||
1652 | 1652 | -73.9498421746221 | 40.7969397424182 | 42I-PM-1014-02 | 42I | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 8 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9498421746221 40.7969397424182) | 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 | ||||
1662 | 1662 | -73.9561600237284 | 40.7953143196705 | 38E-AM-1010-10 | 38E | AM | 10102018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | over a log across stream | false | false | false | false | false | chillin' | false | false | false | false | false | false | false | true | runs from leaf blower | POINT (-73.9561600237284 40.7953143196705) | 19 | 4 | 19 | 13 | ||
1673 | 1673 | -73.9746940851342 | 40.7760966488186 | 11B-PM-1014-02 | 11B | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746940851342 40.7760966488186) | 19 | 4 | 19 | 13 | ||||||
1684 | 1684 | -73.9637824756607 | 40.7904737110761 | 30B-AM-1007-08 | 30B | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9637824756607 40.7904737110761) | 19 | 4 | 19 | 13 | ||||||
1688 | 1688 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 10192018 | 7 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9677593344667 40.7763054313195) | 19 | 4 | 19 | 13 | |||||||
1693 | 1693 | -73.9593781427412 | 40.7841519912635 | 26I-AM-1010-02 | 26I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.95937814274122 40.7841519912635) | 19 | 4 | 19 | 13 | ||||||
1751 | 1751 | -73.9594045885402 | 40.7840886870652 | 26I-AM-1010-01 | 26I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9594045885402 40.7840886870652) | 19 | 4 | 19 | 13 | ||||||
1765 | 1765 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 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 | ||||
1778 | 1778 | -73.9685598106128 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 10082018 | 2 | + | unknown - cannot see, only hear | Above Ground | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9685598106128 40.7807054868066) | 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 | ||||
1831 | 1831 | -73.9746877519291 | 40.7761402808083 | 11B-PM-1014-03 | 11B | PM | 10142018 | 3 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746877519291 40.7761402808083) | 19 | 4 | 19 | 13 | |||||||
1832 | 1832 | -73.9693159934697 | 40.7831212338295 | 21B-PM-1017-03 | 21B | PM | 10172018 | 3 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9693159934697 40.7831212338295) | 19 | 4 | 19 | 13 | |||||
1842 | 1842 | -73.9532804650089 | 40.7934579333341 | 37H-PM-1006-05 | 37H | PM | 10062018 | 5 | + | Above Ground | tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9532804650089 40.7934579333341) | 19 | 4 | 19 | 13 | ||||||||
1864 | 1864 | -73.9694344956258 | 40.7742869276902 | 12G-PM-1007-01 | 12G | PM | 10072018 | 1 | Gray | Gray+ | Above Ground | 40 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9694344956258 40.7742869276902) | 19 | 4 | 19 | 13 | ||||||
1867 | 1867 | -73.9745204169071 | 40.7736282868469 | 9C-AM-1006-01 | 09C | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 40 | Tree | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9745204169071 40.7736282868469) | 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 | ||||
1875 | 1875 | -73.9527430510248 | 40.7924807950552 | 36I-PM-1007-12 | 36I | PM | 10072018 | 12 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Tiny! So tiny! | Above Ground | 2 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9527430510248 40.7924807950552) | 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 | |||||
1916 | 1916 | -73.9693504617353 | 40.7830678709405 | 21B-PM-1017-02 | 21B | PM | 10172018 | 2 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | false | true | false | false | false | false | true | false | false | false | false | false | false | stood on hind legs with front legs on the chest | POINT (-73.9693504617353 40.7830678709405) | 19 | 4 | 19 | 13 | ||||
1926 | 1926 | -73.9742811484852 | 40.775533619083 | 11B-PM-1014-08 | 11B | PM | 10142018 | 8 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97428114848522 40.775533619083) | 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 | ||||
1970 | 1970 | -73.9631464693769 | 40.793415656751 | 33A-PM-1018-02 | 33A | PM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | Tree cavity [of] London Plane tree | false | false | false | false | false | hanging out,watching world | false | false | false | false | false | false | false | false | watching | POINT (-73.9631464693769 40.793415656751) | 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 | |||
2010 | 2010 | -73.9673821557469 | 40.7786375267659 | 17F-PM-1020-06 | 17F | PM | 10202018 | 6 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.96738215574692 40.7786375267659) | 19 | 4 | 19 | 13 | ||||||
2018 | 2018 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 10182018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
2029 | 2029 | -73.9687213827744 | 40.7843586374648 | 22B-PM-1014-02 | 22B | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687213827744 40.7843586374648) | 19 | 4 | 19 | 13 | |||||
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 | |||
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 | |||
2114 | 2114 | -73.9651541395415 | 40.7798283208748 | 19G-PM-1017-01 | 19G | PM | 10172018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | false | false | false | false | false | watching | false | false | false | false | false | true | false | false | POINT (-73.9651541395415 40.7798283208748) | 19 | 4 | 19 | 13 | ||||
2142 | 2142 | -73.9598535425706 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 10062018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | hanging on fence | true | false | false | true | false | false | false | true | POINT (-73.9598535425706 40.7915589343685) | 19 | 4 | 19 | 13 | |||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | true | true | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
2215 | 2215 | -73.9674978826751 | 40.776288410765 | 15G-PM-1019-10 | 15G | PM | 10192018 | 10 | Adult | Gray | Gray+ | Above Ground | 1 | on a log | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9674978826751 40.776288410765) | 19 | 4 | 19 | 13 | |||||
2231 | 2231 | -73.9545427611477 | 40.7930353817441 | 36G-PM-1012-02 | 36G | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9545427611477 40.7930353817441) | 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 | |||||
2244 | 2244 | -73.9509628195532 | 40.7977775674178 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9509628195532 40.7977775674178) | 12423 | 18 | 4 | 36 | 18 | ||||
2284 | 2284 | -73.9730181306326 | 40.7794601322427 | 16A-AM-1013-02 | 16A | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9730181306326 40.7794601322427) | 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 | ||||||
2327 | 2327 | -73.9567801028221 | 40.7960096659564 | 38D-AM-1017-01 | 38D | AM | 10172018 | 1 | + | Above Ground | 30 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9567801028221 40.7960096659564) | 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 | ||||||
2337 | 2337 | -73.9673490137465 | 40.7782728130401 | 17F-PM-1020-02 | 17F | PM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9673490137465 40.7782728130401) | 19 | 4 | 19 | 13 | |||||
2341 | 2341 | -73.9665363265054 | 40.7844967881001 | 23C-PM-1014-04 | 23C | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | false | false | false | being chased by #3 across trees | false | false | false | false | false | false | false | false | POINT (-73.9665363265054 40.7844967881001) | 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 | |||||
2388 | 2388 | -73.9604476047877 | 40.7938014328732 | 35C-AM-1007-03 | 35C | AM | 10072018 | 3 | Adult | + | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9604476047877 40.7938014328732) | 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 | ||||
2390 | 2390 | -73.9680741975294 | 40.7847036778165 | 23B-PM-1012-04 | 23B | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 20 | false | false | false | false | false | watching me - didn't move | false | false | false | false | true | false | false | true | POINT (-73.9680741975294 40.7847036778165) | 19 | 4 | 19 | 13 | ||||
2392 | 2392 | -73.9578981223015 | 40.7989967754358 | 41B-AM-1010-03 | 41B | AM | 10102018 | 3 | Adult | + | Above Ground | 60 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9578981223015 40.7989967754358) | 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 | |||||
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 | ||||||
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 | ||||||
2419 | 2419 | -73.9590551473416 | 40.7891607060794 | 31F-PM-1007-02 | 31F | PM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | tree trunk | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.95905514734162 40.7891607060794) | 19 | 4 | 19 | 13 | |||||
2456 | 2456 | -73.9698446365683 | 40.7842607168578 | 22A-AM-1008-01 | 22A | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9698446365683 40.7842607168578) | 19 | 4 | 19 | 13 | ||||
2465 | 2465 | -73.9686999860219 | 40.7844014735136 | 22B-PM-1014-03 | 22B | PM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686999860219 40.7844014735136) | 19 | 4 | 19 | 13 | |||||
2499 | 2499 | -73.9690079924094 | 40.7845473505585 | 22A-AM-1008-06 | 22A | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9690079924094 40.7845473505585) | 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 | |||||
2515 | 2515 | -73.9693338657183 | 40.7757055884538 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | true | false | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9693338657183 40.77570558845381) | 19 | 4 | 19 | 13 | ||||
2522 | 2522 | -73.9658747245917 | 40.7754033737532 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
2550 | 2550 | -73.9694805745522 | 40.7743556902843 | 12F-AM-1020-01 | 12F | AM | 10202018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 17 | Tree | false | false | false | false | false | jumping | false | false | false | false | false | false | false | false | POINT (-73.9694805745522 40.7743556902843) | 19 | 4 | 19 | 13 | |||
2629 | 2629 | -73.9604576237503 | 40.7818120101394 | 23I-PM-1019-01 | 23I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | true | false | false | false | false | running (across branches) | false | false | false | false | false | false | false | false | POINT (-73.9604576237503 40.7818120101394) | 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 | |||||
2659 | 2659 | -73.9553603438021 | 40.7985282963244 | 41D-PM-1014-05 | 41D | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9553603438021 40.7985282963244) | 19 | 4 | 19 | 13 | |||||
2693 | 2693 | -73.9561498646036 | 40.7949288561893 | 37E-AM-1013-05 | 37E | AM | 10132018 | 5 | ? | + | Above Ground | 10 | unsure, just heard kuks | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9561498646036 40.79492885618931) | 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 | |||||
2707 | 2707 | -73.9743165321099 | 40.7754674678574 | 11B-PM-1014-07 | 11B | PM | 10142018 | 7 | Gray | Gray+ | Above Ground | 10 | true | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9743165321099 40.7754674678574) | 19 | 4 | 19 | 13 | |||||||
2708 | 2708 | -73.9528429238071 | 40.7922651848867 | 36I-PM-1007-09 | 36I | PM | 10072018 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5 | true | true | false | false | false | burying nut | false | false | false | false | true | false | false | false | POINT (-73.9528429238071 40.7922651848867) | 19 | 4 | 19 | 13 | |||||
2740 | 2740 | -73.9612658688914 | 40.7912119940469 | 32C-AM-1014-04 | 32C | AM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9612658688914 40.7912119940469) | 19 | 4 | 19 | 13 | ||||||
2742 | 2742 | -73.9628041577934 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 10122018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5 | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9628041577934 40.78841801560551) | 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 | |||||
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 | |||||
2839 | 2839 | -73.9672252136807 | 40.7876504743212 | 26A-PM-1006-04 | 26A | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 40 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9672252136807 40.7876504743212) | 19 | 4 | 19 | 13 | ||||||
2862 | 2862 | -73.967466716152 | 40.7824346548278 | 21D-PM-1008-04 | 21D | PM | 10082018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | false | false | false | true | false | false | false | false | false | false | false | false | true | i scared it | POINT (-73.967466716152 40.7824346548278) | 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 | ||||
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 | ||||
2912 | 2912 | -73.9632164738341 | 40.7921270121312 | 32B-PM-1010-03 | 32B | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9632164738341 40.7921270121312) | 19 | 4 | 19 | 13 | |||||
2913 | 2913 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9621297946132 40.7944058222814) | 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 | ||||
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 | |||||
3008 | 3008 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9503533343658 40.7976543603953) | 12423 | 18 | 4 | 36 | 18 | ||||
3011 | 3011 | -73.9678831312936 | 40.7847605974975 | 23B-PM-1012-06 | 23B | PM | 10122018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | false | false | true | false | false | false | false | false | false | false | scolding | POINT (-73.9678831312936 40.7847605974975) | 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 | |||||
21 | 21 | -73.9703781726172 | 40.7787526130321 | 16C-PM-1018-03 | 16C | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9703781726172 40.7787526130321) | 19 | 4 | 19 | 13 | |||||
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 | |||||
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 | |||||
46 | 46 | -73.9673253417305 | 40.7749505252981 | 13H-PM-1010-02 | 13H | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | tree | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9673253417305 40.7749505252981) | 19 | 4 | 19 | 13 | |||||
50 | 50 | -73.9680635070949 | 40.779249873647 | 17E-AM-1017-05 | 17E | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Branch | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9680635070949 40.779249873647) | 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 |
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 );