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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1616 | 1616 | -73.9642666013207 | 40.7810384867375 | 21G-PM-1007-03 | 21G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.96426660132072 40.7810384867375) | 19 | 4 | 19 | 13 | |||||
1722 | 1722 | -73.9802564685265 | 40.7681759098199 | 2B-AM-1010-05 | 02B | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9802564685265 40.7681759098199) | 19 | 4 | 19 | 13 | |||||
1815 | 1815 | -73.9603268255317 | 40.7900154505092 | 31E-PM-1006-06 | 31E | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9603268255317 40.7900154505092) | 19 | 4 | 19 | 13 | |||||
1995 | 1995 | -73.9603366992925 | 40.7899612889539 | 31E-PM-1006-05 | 31E | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9603366992925 40.789961288953904) | 19 | 4 | 19 | 13 | |||||
2134 | 2134 | -73.9614373639552 | 40.7945051962914 | 35B-PM-1013-01 | 35B | PM | 10132018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | did not notice dog sitting a few yards away (10-20 ft) | false | false | false | true | false | false | true | false | POINT (-73.9614373639552 40.7945051962914) | 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 | |||||
2217 | 2217 | -73.9652746477521 | 40.7809326848536 | 20F-PM-1007-07 | 20F | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | true | false | false | false | false | watching | false | false | false | true | false | false | false | true | POINT (-73.96527464775211 40.7809326848536) | 19 | 4 | 19 | 13 | |||
2425 | 2425 | -73.9791141532217 | 40.7714888835416 | 5A-AM-1006-04 | 05A | AM | 10062018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9791141532217 40.77148888354161) | 19 | 4 | 19 | 13 | |||||
2429 | 2429 | -73.9726699686943 | 40.7701123791223 | 7F-AM-1008-01 | 07F | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bench | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9726699686943 40.7701123791223) | 19 | 4 | 19 | 13 | ||||
2463 | 2463 | -73.9653343572865 | 40.7775286924617 | 17H-PM-1007-01 | 17H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9653343572865 40.7775286924617) | 19 | 4 | 19 | 13 | |||||
2489 | 2489 | -73.9663168490265 | 40.7825083721362 | 21D-AM-1008-01 | 21D | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | true | false | true | false | POINT (-73.9663168490265 40.7825083721362) | 19 | 4 | 19 | 13 | |||||
2569 | 2569 | -73.9559663734409 | 40.7945828261377 | 37F-AM-1010-01 | 37F | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.9559663734409 40.7945828261377) | 19 | 4 | 19 | 13 | |||||
2700 | 2700 | -73.9601988871514 | 40.7943473161329 | 35C-PM-1013-01 | 35C | PM | 10132018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | true | true | true | false | true | true | false | true | false | POINT (-73.9601988871514 40.7943473161329) | 19 | 4 | 19 | 13 | ||||||
2751 | 2751 | -73.956289117157 | 40.7953393993803 | 38E-AM-1010-11 | 38E | AM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of the stream | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.956289117157 40.7953393993803) | 19 | 4 | 19 | 13 | ||||
2759 | 2759 | -73.9543373703455 | 40.7943889087123 | 38G-PM-1020-07 | 38G | PM | 10202018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | true | false | true | false | false | true | false | POINT (-73.9543373703455 40.7943889087123) | 19 | 4 | 19 | 13 | |||||
2857 | 2857 | -73.9649230271173 | 40.7821766215675 | 22F-PM-1014-02 | 22F | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9649230271173 40.7821766215675) | 19 | 4 | 19 | 13 | |||||
2876 | 2876 | -73.9558995737654 | 40.7960097734603 | 39E-AM-1018-05 | 39E | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9558995737654 40.7960097734603) | 19 | 4 | 19 | 13 | |||||
2923 | 2923 | -73.9672160533827 | 40.7830263908749 | 21C-AM-1014-05 | 21C | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9672160533827 40.7830263908749) | 19 | 4 | 19 | 13 | |||||
2928 | 2928 | -73.9767953468937 | 40.7676376977667 | 3E-AM-1006-03 | 03E | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | checkin' his stashes | false | false | false | true | false | true | false | true | POINT (-73.9767953468937 40.7676376977667) | 19 | 4 | 19 | 13 | ||||
2968 | 2968 | -73.9587236619579 | 40.7991850180434 | 40A-AM-1010-02 | 40A | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park at 108th West | true | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9587236619579 40.7991850180434) | 19 | 4 | 19 | 13 | ||||
2980 | 2980 | -73.9716414586381 | 40.771760114722 | 9F-PM-1014-06 | 09F | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | running (from birds) | false | false | false | true | false | false | true | false | POINT (-73.9716414586381 40.771760114722) | 19 | 4 | 19 | 13 | ||||
74 | 74 | -73.9546654184146 | 40.7947639241491 | 38G-PM-1020-09 | 38G | PM | 10202018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | true | false | POINT (-73.9546654184146 40.7947639241491) | 19 | 4 | 19 | 13 | |||||
316 | 316 | -73.9540616660191 | 40.7951556603245 | 38G-PM-1020-10 | 38G | PM | 10202018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9540616660191 40.7951556603245) | 19 | 4 | 19 | 13 | |||||
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 | ||||
1048 | 1048 | -73.9782120139407 | 40.7717154468791 | 6A-AM-1006-05 | 06A | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | tree | false | false | true | false | false | false | false | false | true | true | false | false | false | curious | POINT (-73.9782120139407 40.7717154468791) | 19 | 4 | 19 | 13 | |||
1201 | 1201 | -73.9782813538421 | 40.7715730368712 | 6A-AM-1006-02 | 06A | AM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | false | true | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.9782813538421 40.7715730368712) | 19 | 4 | 19 | 13 | ||||
1330 | 1330 | -73.9643032554205 | 40.7794514526463 | 19H-AM-1010-02 | 19H | AM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | true | false | false | true | true | false | false | false | true | false | true | false | false | ran from human with dog | POINT (-73.9643032554205 40.7794514526463) | 19 | 4 | 19 | 13 | ||||
1514 | 1514 | -73.9548006161673 | 40.7945503341011 | 38G-PM-1020-08 | 38G | PM | 10202018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | true | false | false | true | false | false | true | false | POINT (-73.9548006161673 40.7945503341011) | 19 | 4 | 19 | 13 | |||||
1910 | 1910 | -73.9699876501742 | 40.7742482676758 | 12F-PM-1007-06 | 12F | PM | 10072018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699876501742 40.77424826767581) | 19 | 4 | 19 | 13 | |||||
2210 | 2210 | -73.9699124811406 | 40.7743016981538 | 12F-PM-1007-07 | 12F | PM | 10072018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699124811406 40.7743016981538) | 19 | 4 | 19 | 13 | |||||
2294 | 2294 | -73.9630820577441 | 40.7821632293136 | 22G-PM-1018-01 | 22G | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9630820577441 40.7821632293136) | 19 | 4 | 19 | 13 | ||||
2348 | 2348 | -73.9531965469704 | 40.7947437983977 | 38G-PM-1020-11 | 38G | PM | 10202018 | 11 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | true | true | false | POINT (-73.9531965469704 40.7947437983977) | 19 | 4 | 19 | 13 | |||||
2821 | 2821 | -73.9754536566013 | 40.7698604918771 | 5E-PM-1012-04 | 05E | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9754536566013 40.7698604918771) | 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 | |||||
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 | ||||
239 | 239 | -73.9758464905133 | 40.7725957408841 | 8C-PM-1013-05 | 08C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9758464905133 40.7725957408841) | 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 | ||||
855 | 855 | -73.9808247660048 | 40.7689408831287 | 2A-PM-1019-01 | 02A | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | runs from | false | false | false | true | false | false | false | true | POINT (-73.9808247660048 40.7689408831287) | 19 | 4 | 19 | 13 | ||||
887 | 887 | -73.9635028497015 | 40.7928207574906 | 32A-PM-1013-05 | 32A | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9635028497015 40.7928207574906) | 19 | 4 | 19 | 13 | |||||
1019 | 1019 | -73.9704269630964 | 40.7722964640257 | 10G-AM-1006-09 | 10G | AM | 10062018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704269630964 40.7722964640257) | 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 | ||||||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
1403 | 1403 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9761632586697 40.7741085606149) | 19 | 4 | 19 | 13 | |||||
1421 | 1421 | -73.9595022290348 | 40.7831151330074 | 25I-PM-1007-02 | 25I | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | white belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | true | false | false | true | POINT (-73.9595022290348 40.783115133007406) | 19 | 4 | 19 | 13 | ||||
1529 | 1529 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
1660 | 1660 | -73.9800499498034 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9800499498034 40.770218109957305) | 19 | 4 | 19 | 13 | ||||
1836 | 1836 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9751056714758 40.7732060035215) | 19 | 4 | 19 | 13 | |||||
1956 | 1956 | -73.980897497712 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
1981 | 1981 | -73.972154069981 | 40.7690128009722 | 6G-AM-1008-03 | 06G | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | grass | false | false | false | true | true | false | false | false | true | false | false | true | false | POINT (-73.972154069981 40.7690128009722) | 19 | 4 | 19 | 13 | ||||
2185 | 2185 | -73.9707571364399 | 40.7758859812524 | 13E-PM-1008-02 | 13E | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9707571364399 40.7758859812524) | 19 | 4 | 19 | 13 | |||||
2363 | 2363 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9690638424196 40.7713869295685) | 19 | 4 | 19 | 13 | |||||
2397 | 2397 | -73.9704592500888 | 40.772962887933 | 10G-AM-1006-03 | 10G | AM | 10062018 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704592500888 40.772962887933) | 19 | 4 | 19 | 13 | ||||
2444 | 2444 | -73.966590487009 | 40.7802469052891 | 19E-PM-1018-02 | 19E | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.96659048700901 40.7802469052891) | 19 | 4 | 19 | 13 | |||||
2591 | 2591 | -73.9786351029146 | 40.7716114164002 | 6A-PM-1012-06 | 06A | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | false | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9786351029146 40.771611416400205) | 19 | 4 | 19 | 13 | ||||
2618 | 2618 | -73.95795157569 | 40.7961254697958 | 38C-PM-1014-04 | 38C | PM | 10142018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.95795157569 40.7961254697958) | 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 );