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, Location, Above Ground Sighter Measurement, Chasing, Climbing, Foraging, Kuks, Quaas, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30 | 30 | -73.9692943291611 | 40.7769536102488 | 15E-AM-1013-01 | 15E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9692943291611 40.7769536102488) | 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 | |||||
51 | 51 | -73.9801666435401 | 40.7686905339212 | 2B-PM-1013-01 | 02B | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | running (with nut) | false | false | false | false | false | false | false | false | POINT (-73.9801666435401 40.7686905339212) | 19 | 4 | 19 | 13 | ||||
55 | 55 | -73.9568802149818 | 40.7972399133816 | 39C-PM-1006-01 | 39C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9568802149818 40.7972399133816) | 19 | 4 | 19 | 13 | ||||||
82 | 82 | -73.9688271202401 | 40.7809719445309 | 19C-PM-1018-01 | 19C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9688271202401 40.7809719445309) | 19 | 4 | 19 | 13 | |||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
113 | 113 | -73.9700100617602 | 40.7815739959357 | 19B-PM-1018-01 | 19B | PM | 10182018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | true | false | false | false | false | flying | false | false | false | false | false | false | false | false | POINT (-73.9700100617602 40.7815739959357) | 19 | 4 | 19 | 13 | ||||
118 | 118 | -73.9566346046453 | 40.7973923396512 | 40D-PM-1013-01 | 40D | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566346046453 40.7973923396512) | 19 | 4 | 19 | 13 | |||||
120 | 120 | -73.9511118711108 | 40.7950813345902 | 40I-AM-1018-01 | 40I | AM | 10182018 | 1 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | begging | false | false | false | false | false | false | false | false | POINT (-73.9511118711108 40.7950813345902) | 19 | 4 | 19 | 13 | |||||
142 | 142 | -73.9724063986771 | 40.7705711897977 | 7F-PM-1012-01 | 07F | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9724063986771 40.7705711897977) | 19 | 4 | 19 | 13 | ||||||
170 | 170 | -73.9597205966324 | 40.7969409510133 | 38B-AM-1019-01 | 38B | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9597205966324 40.7969409510133) | 19 | 4 | 19 | 13 | |||||
193 | 193 | -73.9537691298752 | 40.7941272599797 | 38G-PM-1020-01 | 38G | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9537691298752 40.7941272599797) | 19 | 4 | 19 | 13 | |||||
285 | 285 | -73.9691433356733 | 40.7731708333242 | 11G-AM-1012-01 | 11G | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691433356733 40.77317083332421) | 19 | 4 | 19 | 13 | |||||
365 | 365 | -73.9576035072364 | 40.7966120824816 | 38C-AM-1019-01 | 38C | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (lawnmower) | POINT (-73.9576035072364 40.7966120824816) | 19 | 4 | 19 | 13 | ||||
373 | 373 | -73.9672127283283 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | true | false | true | true | false | a lot of activity | false | false | false | true | false | false | false | false | POINT (-73.9672127283283 40.7810666805133) | 19 | 4 | 19 | 13 | ||||
386 | 386 | -73.9550351380957 | 40.7974681522214 | 40E-AM-1014-01 | 40E | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9550351380957 40.7974681522214) | 19 | 4 | 19 | 13 | |||||
403 | 403 | -73.9597470659927 | 40.7973215935416 | 38A-PM-1013-01 | 38A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9597470659927 40.7973215935416) | 19 | 4 | 19 | 13 | |||||
404 | 404 | -73.9680774548516 | 40.7762491903691 | 14F-PM-1012-01 | 14F | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9680774548516 40.7762491903691) | 19 | 4 | 19 | 13 | |||||
420 | 420 | -73.9671851611243 | 40.7750878657618 | 14H-PM-1012-01 | 14H | PM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | true | false | false | approaches (came very close to me) | POINT (-73.9671851611243 40.7750878657618) | 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 | ||||
429 | 429 | -73.9694784056618 | 40.7787735291442 | 16D-PM-1010-01 | 16D | PM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694784056618 40.7787735291442) | 19 | 4 | 19 | 13 | ||||||
462 | 462 | -73.9661785940531 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | climbed tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9661785940531 40.7742569936186) | 19 | 4 | 19 | 13 | ||||
465 | 465 | -73.9683041099256 | 40.7862652300082 | 24A-AM-1014-01 | 24A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | freezes | POINT (-73.9683041099256 40.7862652300082) | 19 | 4 | 19 | 13 | ||||
479 | 479 | -73.9569403365847 | 40.7956599608798 | 38D-PM-1006-01 | 38D | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | didn't see me or others | POINT (-73.9569403365847 40.7956599608798) | 19 | 4 | 19 | 13 | ||||
520 | 520 | -73.9749446629706 | 40.7720659696067 | 7D-PM-1010-01 | 07D | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | outside fenced hectare | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9749446629706 40.7720659696067) | 19 | 4 | 19 | 13 | ||||
528 | 528 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9650499507011 40.7908191782173) | 19 | 4 | 19 | 13 | |||||
568 | 568 | -73.9799441493404 | 40.7671499997527 | 1C-AM-1012-01 | 01C | AM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9799441493404 40.7671499997527) | 12081 | 11 | 4 | 51 | 10 | |||
610 | 610 | -73.9671549566066 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 180 | top of tree | true | false | false | false | false | jumping between branches | false | false | false | false | false | false | true | false | POINT (-73.9671549566066 40.7751342870705) | 19 | 4 | 19 | 13 | ||||
623 | 623 | -73.9662939630722 | 40.7878502338031 | 26B-AM-1010-01 | 26B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | running across bridle path | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9662939630722 40.7878502338031) | 19 | 4 | 19 | 13 | |||||
641 | 641 | -73.9719036217446 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | ground & tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719036217446 40.7803588122409) | 19 | 4 | 19 | 13 | ||||
661 | 661 | -73.9700759073973 | 40.7680560871695 | 5I-AM-1010-01 | 05I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9700759073973 40.7680560871695) | 10090 | 23 | 4 | 51 | 11 | |||||
674 | 674 | -73.9779811967788 | 40.7675178797546 | 2D-AM-1007-01 | 02D | AM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9779811967788 40.7675178797546) | 19 | 4 | 19 | 13 | |||||
706 | 706 | -73.9570132570934 | 40.7932014159087 | 35F-PM-1012-01 | 35F | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | true | false | false | true | true | POINT (-73.9570132570934 40.7932014159087) | 19 | 4 | 19 | 13 | |||||
720 | 720 | -73.9669814346326 | 40.780390919948 | 19E-PM-1018-01 | 19E | PM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9669814346326 40.780390919948) | 19 | 4 | 19 | 13 | |||||
746 | 746 | -73.9591407691 | 40.7960846903122 | 37B-AM-1018-01 | 37B | AM | 10182018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9591407691 40.7960846903122) | 19 | 4 | 19 | 13 | ||||||
749 | 749 | -73.9686304581526 | 40.7773631337117 | 15E-PM-1008-01 | 15E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 4 | on fallen tree | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9686304581526 40.7773631337117) | 19 | 4 | 19 | 13 | |||||
751 | 751 | -73.9683479943823 | 40.7815827298303 | 20C-PM-1018-01 | 20C | PM | 10182018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9683479943823 40.7815827298303) | 19 | 4 | 19 | 13 | ||||||
802 | 802 | -73.958494212554 | 40.7995008636057 | 41A-AM-1013-01 | 41A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | ran across a path | false | false | false | false | false | false | true | false | POINT (-73.958494212554 40.7995008636057) | 19 | 4 | 19 | 13 | ||||
804 | 804 | -73.9697196619878 | 40.7814068507607 | 19B-AM-1019-01 | 19B | AM | 10192018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Side stripes | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | true | indifferent then runs from | POINT (-73.9697196619878 40.7814068507607) | 19 | 4 | 19 | 13 | |||
837 | 837 | -73.9557172336815 | 40.7921125657722 | 35G-PM-1006-01 | 35G | PM | 10062018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9557172336815 40.7921125657722) | 19 | 4 | 19 | 13 | |||||
884 | 884 | -73.9678937289837 | 40.7782808361645 | 16E-PM-1018-01 | 16E | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9678937289837 40.7782808361645) | 19 | 4 | 19 | 13 | |||||
930 | 930 | -73.9622030085794 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
950 | 950 | -73.9637415893182 | 40.7898140363534 | 29B-AM-1007-01 | 29B | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9637415893182 40.7898140363534) | 19 | 4 | 19 | 13 | ||||||
951 | 951 | -73.971791854883 | 40.7802971729784 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.971791854883 40.7802971729784) | 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 | ||||
1004 | 1004 | -73.9670850805619 | 40.7833747810387 | 22C-PM-1006-01 | 22C | PM | 10062018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | for food | false | true | false | false | false | false | false | false | POINT (-73.9670850805619 40.7833747810387) | 19 | 4 | 19 | 13 | |||||
1051 | 1051 | -73.9613747032702 | 40.7920483852431 | 33C-PM-1007-01 | 33C | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9613747032702 40.792048385243106) | 19 | 4 | 19 | 13 | ||||||
1094 | 1094 | -73.9773898301093 | 40.7708581562057 | 5B-AM-1008-01 | 05B | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | running across ball field 5,near home plate | false | false | false | false | false | false | true | false | POINT (-73.9773898301093 40.7708581562057) | 19 | 4 | 19 | 13 | ||||
1096 | 1096 | -73.9568300899773 | 40.7935855743354 | 36E-AM-1013-01 | 36E | AM | 10132018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran into treebrush) | POINT (-73.9568300899773 40.7935855743354) | 19 | 4 | 19 | 13 | |||||
1118 | 1118 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3 | tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719460335398 40.7810508156287) | 19 | 4 | 19 | 13 | |||
1147 | 1147 | -73.9631818528816 | 40.7925332194132 | 32A-AM-1018-01 | 32A | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9631818528816 40.7925332194132) | 19 | 4 | 19 | 13 | ||||||
1171 | 1171 | -73.9573477643797 | 40.7971734060509 | 39C-AM-1017-01 | 39C | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9573477643797 40.7971734060509) | 19 | 4 | 19 | 13 | ||||||
1180 | 1180 | -73.9639726817977 | 40.7829083461049 | 23F-PM-1013-01 | 23F | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.) | POINT (-73.9639726817977 40.7829083461049) | 19 | 4 | 19 | 13 | ||||
1193 | 1193 | -73.9731880656287 | 40.7660026186155 | 2H-AM-1006-01 | 02H | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9731880656287 40.7660026186155) | 19 | 4 | 19 | 13 | ||||||
1235 | 1235 | -73.9679686793869 | 40.7825993867876 | 21C-AM-1014-01 | 21C | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | true | false | false | false | false | jumping back & forth on tree | false | false | false | true | true | false | true | false | POINT (-73.9679686793869 40.7825993867876) | 19 | 4 | 19 | 13 | ||||
1264 | 1264 | -73.9785353775382 | 40.7674923683184 | 2C-PM-1013-01 | 02C | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9785353775382 40.7674923683184) | 19 | 4 | 19 | 13 | |||||
1284 | 1284 | -73.9570891696776 | 40.7935448802241 | 36E-PM-1012-01 | 36E | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9570891696776 40.7935448802241) | 19 | 4 | 19 | 13 | |||||
1298 | 1298 | -73.9612900553755 | 40.7912917391867 | 32C-AM-1014-01 | 32C | AM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9612900553755 40.7912917391867) | 19 | 4 | 19 | 13 | ||||||
1299 | 1299 | -73.9766653663947 | 40.7688767713012 | 4D-AM-1012-01 | 04D | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9766653663947 40.7688767713012) | 19 | 4 | 19 | 13 | |||||
1303 | 1303 | -73.9603302382958 | 40.7910100435196 | 32D-PM-1006-01 | 32D | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9603302382958 40.7910100435196) | 19 | 4 | 19 | 13 | |||||
1307 | 1307 | -73.9565197137317 | 40.7986011403785 | 41C-PM-1007-01 | 41C | PM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9565197137317 40.7986011403785) | 19 | 4 | 19 | 13 | ||||||
1308 | 1308 | -73.9560396440844 | 40.7945080361909 | 37E-AM-1013-01 | 37E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9560396440844 40.7945080361909) | 19 | 4 | 19 | 13 | |||||
1373 | 1373 | -73.956737220098 | 40.797580989255 | 40C-PM-1006-01 | 40C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.95673722009802 40.797580989255) | 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 | ||||
1412 | 1412 | -73.9594676326588 | 40.7984457363388 | 39A-AM-1013-01 | 39A | AM | 10132018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9594676326588 40.7984457363388) | 19 | 4 | 19 | 13 | |||||
1427 | 1427 | -73.9755321998542 | 40.7668311576007 | 2F-PM-1014-01 | 02F | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.97553219985421 40.7668311576007) | 19 | 4 | 19 | 13 | ||||||
1429 | 1429 | -73.9706533131129 | 40.768902033819 | 6I-AM-1006-01 | 06I | AM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | true | false | true | true | true | false | false | false | false | false | false | false | true | runs from (someone sneezed) | POINT (-73.9706533131129 40.768902033819) | 19 | 4 | 19 | 13 | |||||
1440 | 1440 | -73.9748669205206 | 40.7743879232016 | 10B-AM-1006-01 | 10B | AM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9748669205206 40.7743879232016) | 19 | 4 | 19 | 13 | |||||
1441 | 1441 | -73.961335649743 | 40.7818876867842 | 23H-PM-1019-01 | 23H | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.961335649743 40.7818876867842) | 19 | 4 | 19 | 13 | ||||||
1511 | 1511 | -73.9721642509914 | 40.7701179390078 | 7G-AM-1010-01 | 07G | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9721642509914 40.7701179390078) | 19 | 4 | 19 | 13 | |||||
1549 | 1549 | -73.9777978497894 | 40.7668620784309 | 1D-AM-1006-01 | 01D | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | true | false | false | false | POINT (-73.9777978497894 40.7668620784309) | 19 | 4 | 19 | 13 | |||||
1579 | 1579 | -73.9768309556127 | 40.7717803706095 | 6B-AM-1012-01 | 06B | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Started in field, crossed busy street, ran up tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97683095561271 40.7717803706095) | 19 | 4 | 19 | 13 | ||||
1588 | 1588 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9693209851947 40.7707450042769) | 19 | 4 | 19 | 13 | |||||
1590 | 1590 | -73.9610388059192 | 40.79395293584 | 34B-PM-1007-01 | 34B | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9610388059192 40.79395293584) | 19 | 4 | 19 | 13 | |||||
1612 | 1612 | -73.9746049088475 | 40.7728776887397 | 8C-AM-1007-01 | 08C | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | behind fence, safe | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9746049088475 40.7728776887397) | 19 | 4 | 19 | 13 | |||||
1628 | 1628 | -73.9713665249614 | 40.7697178648002 | 7H-AM-1006-01 | 07H | AM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | nut in mouth | false | false | false | false | false | false | true | false | POINT (-73.9713665249614 40.7697178648002) | 19 | 4 | 19 | 13 | ||||
1685 | 1685 | -73.9678822983274 | 40.7802960985637 | 18E-PM-1006-01 | 18E | PM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9678822983274 40.7802960985637) | 19 | 4 | 19 | 13 | |||||
1689 | 1689 | -73.9547031549299 | 40.7978867539322 | 41E-PM-1013-01 | 41E | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9547031549299 40.7978867539322) | 19 | 4 | 19 | 13 | |||||
1739 | 1739 | -73.9639700434449 | 40.7775003050028 | 17I-AM-1014-01 | 17I | AM | 10142018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | Running across fence between statue & swings | true | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9639700434449 40.7775003050028) | 19 | 4 | 19 | 13 | ||||
1766 | 1766 | -73.972757765574 | 40.7654285510067 | 2I-AM-1006-01 | 02I | AM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.972757765574 40.7654285510067) | 19 | 4 | 19 | 13 | ||||||
1795 | 1795 | -73.968004352343 | 40.7726669278308 | 11I-PM-1012-01 | 11I | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | true | true | false | false | false | look at humans determining | POINT (-73.968004352343 40.7726669278308) | 19 | 4 | 19 | 13 | |||||
1840 | 1840 | -73.9733222531339 | 40.7649975371546 | 1I-PM-1012-01 | 01I | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9733222531339 40.7649975371546) | 19 | 4 | 19 | 13 | ||||
1866 | 1866 | -73.9636027664439 | 40.790075966587 | 30B-PM-1019-01 | 30B | PM | 10192018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.9636027664439 40.790075966587) | 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 | |||||
1877 | 1877 | -73.9524490779105 | 40.7936003219524 | 38I-AM-1019-01 | 38I | AM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9524490779105 40.7936003219524) | 19 | 4 | 19 | 13 | |||||
1894 | 1894 | -73.9699780857298 | 40.7688706046944 | 6I-PM-1013-01 | 06I | PM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9699780857298 40.7688706046944) | 19 | 4 | 19 | 13 | |||||
1911 | 1911 | -73.9528937660465 | 40.7922919074537 | 36I-AM-1017-01 | 36I | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | true | runs from (me!)—from a pretty big distance | POINT (-73.9528937660465 40.7922919074537) | 19 | 4 | 19 | 13 | ||||
1945 | 1945 | -73.9530257401736 | 40.795139740737 | 39G-PM-1013-01 | 39G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9530257401736 40.79513974073701) | 19 | 4 | 19 | 13 | |||||
1952 | 1952 | -73.9681810466693 | 40.7720638449419 | 10I-PM-1013-01 | 10I | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9681810466693 40.7720638449419) | 19 | 4 | 19 | 13 | |||||
1975 | 1975 | -73.9753291616796 | 40.7687376032936 | 4E-PM-1008-01 | 04E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9753291616796 40.7687376032936) | 19 | 4 | 19 | 13 | |||||
2033 | 2033 | -73.9500167570283 | 40.7966185836685 | 41I-AM-1018-01 | 41I | AM | 10182018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | false | cautious,observant,runs off | POINT (-73.9500167570283 40.7966185836685) | 19 | 4 | 19 | 13 | ||||
2044 | 2044 | -73.9771552326199 | 40.7706917595308 | 5C-AM-1006-01 | 05C | AM | 10062018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | true | false | false | POINT (-73.9771552326199 40.7706917595308) | 19 | 4 | 19 | 13 | |||||
2058 | 2058 | -73.9669017345324 | 40.7766928987073 | 15G-AM-1008-01 | 15G | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9669017345324 40.7766928987073) | 19 | 4 | 19 | 13 | |||||
2070 | 2070 | -73.9725700261894 | 40.7668793330427 | 3H-PM-1014-01 | 03H | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a parked car | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9725700261894 40.7668793330427) | 19 | 4 | 19 | 13 | |||||
2111 | 2111 | -73.968446056806 | 40.785824818871 | 24A-PM-1007-01 | 24A | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.96844605680602 40.785824818871) | 19 | 4 | 19 | 13 | |||||
2118 | 2118 | -73.958369699409 | 40.7902456668332 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.958369699409 40.7902456668332) | 19 | 4 | 19 | 13 | ||||||
2143 | 2143 | -73.9596232170232 | 40.7959550843229 | 37B-PM-1013-01 | 37B | PM | 10132018 | 1 | Adult | Gray | Gray+ | Sighting was far away | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9596232170232 40.795955084322905) | 19 | 4 | 19 | 13 | |||||
2147 | 2147 | -73.9651217998407 | 40.7761115392738 | 15I-PM-1012-01 | 15I | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9651217998407 40.7761115392738) | 19 | 4 | 19 | 13 | |||||
2163 | 2163 | -73.9643664403785 | 40.7793670703727 | 19H-AM-1010-01 | 19H | AM | 10102018 | 1 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | true | false | false | true | true | false | false | false | false | false | false | true | false | run from human w/ dog | POINT (-73.9643664403785 40.7793670703727) | 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 );