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, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
79 | 79 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | true | true | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | false | false | false | false | true | true | false | false | POINT (-73.9610705592868 40.7914829661051) | 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 | |||||
199 | 199 | -73.9771614686616 | 40.7709677983247 | 5C-AM-1006-02 | 05C | AM | 10062018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | true | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9771614686616 40.7709677983247) | 19 | 4 | 19 | 13 | |||||
222 | 222 | -73.9770273553525 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | true | true | true | true | false | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
262 | 262 | -73.9712876234172 | 40.7695885530701 | 7H-PM-1006-02 | 07H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | tree | true | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9712876234172 40.7695885530701) | 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 | ||||
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 | |||||
406 | 406 | -73.9766354967197 | 40.7734575166319 | 8B-AM-1007-09 | 08B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating | false | false | false | false | false | false | true | false | POINT (-73.9766354967197 40.7734575166319) | 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 | ||||
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 | ||||||
535 | 535 | -73.9772396728545 | 40.7668696411765 | 2E-AM-1010-02 | 02E | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | totally indifferent | POINT (-73.9772396728545 40.7668696411765) | 19 | 4 | 19 | 13 | |||||
619 | 619 | -73.9769887473852 | 40.7707561532949 | 5C-PM-1010-04 | 05C | PM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.97698874738522 40.7707561532949) | 19 | 4 | 19 | 13 | |||||
678 | 678 | -73.977447585355 | 40.7697167828003 | 4C-PM-1010-11 | 04C | PM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.977447585355 40.7697167828003) | 19 | 4 | 19 | 13 | |||||
684 | 684 | -73.9691057326088 | 40.7765973509721 | 14F-PM-1012-07 | 14F | PM | 10122018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9691057326088 40.7765973509721) | 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 | |||||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9773079154219 40.7696506688861) | 19 | 4 | 19 | 13 | |||||
786 | 786 | -73.953296595236 | 40.7927644594513 | 36I-AM-1017-03 | 36I | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.953296595236 40.7927644594513) | 19 | 4 | 19 | 13 | ||||
787 | 787 | -73.9725157534356 | 40.7658376729234 | 2I-PM-1006-02 | 02I | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9725157534356 40.7658376729234) | 19 | 4 | 19 | 13 | |||||
868 | 868 | -73.9738481771673 | 40.7706540698938 | 7E-PM-1013-04 | 07E | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9738481771673 40.7706540698938) | 19 | 4 | 19 | 13 | |||||
895 | 895 | -73.9786898656279 | 40.7720833097065 | 6A-AM-1006-08 | 06A | AM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9786898656279 40.77208330970651) | 19 | 4 | 19 | 13 | |||||
922 | 922 | -73.9708002461415 | 40.7726685284831 | 10F-PM-1019-10 | 10F | PM | 10192018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Arbor path & hill w/ bushes | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9708002461415 40.7726685284831) | 19 | 4 | 19 | 13 | ||||
928 | 928 | -73.967042958599 | 40.7784370719371 | 17F-AM-1007-05 | 17F | AM | 10072018 | 5 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.967042958599 40.7784370719371) | 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 | |||||
1021 | 1021 | -73.97186968288 | 40.778926988884 | 15B-AM-1014-03 | 15B | AM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | running (from a dog) | false | false | false | false | false | false | true | false | POINT (-73.97186968288 40.778926988884) | 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 | ||||
1108 | 1108 | -73.9638397790384 | 40.7828950272904 | 23F-PM-1013-02 | 23F | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | true | false | false | true | false | true | false | indifferent (mostly,did notice me,busy eating,foraging) | POINT (-73.9638397790384 40.7828950272904) | 19 | 4 | 19 | 13 | ||||
1123 | 1123 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670858934045 40.7753505024976) | 19 | 4 | 19 | 13 | |||||
1139 | 1139 | -73.9716271494641 | 40.7796462634184 | 16B-PM-1017-02 | 16B | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9716271494641 40.7796462634184) | 19 | 4 | 19 | 13 | |||||
1165 | 1165 | -73.9689504114652 | 40.7766770153764 | 14F-PM-1012-05 | 14F | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2 | on a fallen branch | true | false | false | true | false | sitting | false | false | false | false | false | false | false | false | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
1223 | 1223 | -73.9591298551111 | 40.7919612446005 | 33E-AM-1014-04 | 33E | AM | 10142018 | 4 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9591298551111 40.7919612446005) | 19 | 4 | 19 | 13 | |||||
1242 | 1242 | -73.9714512125212 | 40.7760275250114 | 13D-PM-1018-03 | 13D | PM | 10182018 | 3 | 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 | true | false | false | false | false | false | false | true | false | POINT (-73.9714512125212 40.7760275250114) | 19 | 4 | 19 | 13 | ||||
1255 | 1255 | -73.9717469822209 | 40.7753731930704 | 12D-PM-1014-03 | 12D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9717469822209 40.7753731930704) | 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 | ||||
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 | ||||
1416 | 1416 | -73.9757313481982 | 40.7754704051391 | 11A-PM-1013-04 | 11A | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9757313481982 40.7754704051391) | 19 | 4 | 19 | 13 | |||||
1456 | 1456 | -73.9714242426496 | 40.7744535798123 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | foraging (foraged,ran to tree root,munched) | false | false | false | false | false | false | true | false | POINT (-73.9714242426496 40.7744535798123) | 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 | |||||
1636 | 1636 | -73.9701408623121 | 40.7695511718541 | 7I-PM-1013-04 | 07I | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Grass | true | false | false | true | false | false | false | false | true | false | false | false | false | POINT (-73.9701408623121 40.7695511718541) | 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 | ||||||
1690 | 1690 | -73.96052295327 | 40.7934359372871 | 34C-PM-1012-04 | 34C | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.96052295327 40.7934359372871) | 19 | 4 | 19 | 13 | ||||||
1695 | 1695 | -73.9604083891356 | 40.7910284106931 | 32D-AM-1013-05 | 32D | AM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9604083891356 40.7910284106931) | 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 | ||||||
1772 | 1772 | -73.9690540696008 | 40.7766014124609 | 14F-PM-1012-08 | 14F | PM | 10122018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9690540696008 40.7766014124609) | 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 | |||||
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 | |||||
1990 | 1990 | -73.9774584305147 | 40.7708133986192 | 5B-AM-1008-02 | 05B | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9774584305147 40.7708133986192) | 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 | ||||||
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 | ||||
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 | |||||
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 | ||||
2319 | 2319 | -73.9756870789187 | 40.7733646782679 | 9B-AM-1010-09 | 09B | AM | 10102018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | food in mouth | false | false | false | false | false | false | false | false | POINT (-73.9756870789187 40.7733646782679) | 19 | 4 | 19 | 13 | ||||
2324 | 2324 | -73.9737247632185 | 40.7759469280872 | 12C-PM-1017-01 | 12C | PM | 10172018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | digging/burying,drinking from lake | false | false | false | false | true | false | true | false | POINT (-73.9737247632185 40.7759469280872) | 19 | 4 | 19 | 13 | ||||
2442 | 2442 | -73.9699369796844 | 40.7720350191273 | 10G-PM-1017-04 | 10G | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9699369796844 40.7720350191273) | 19 | 4 | 19 | 13 | ||||||
2485 | 2485 | -73.9584950620879 | 40.7902770710643 | 32F-PM-1008-03 | 32F | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584950620879 40.7902770710643) | 19 | 4 | 19 | 13 | |||||
2508 | 2508 | -73.979381450452 | 40.7709033697887 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.979381450452 40.770903369788705) | 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 | ||||
2545 | 2545 | -73.9617594316752 | 40.7946803725236 | 35A-AM-1014-01 | 35A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9617594316752 40.7946803725236) | 19 | 4 | 19 | 13 | |||||
2641 | 2641 | -73.9615516703494 | 40.7905219388359 | 31D-AM-1014-04 | 31D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Open ground | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9615516703494 40.7905219388359) | 19 | 4 | 19 | 13 | |||||
2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9772239251936 40.7731716665766) | 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 | ||||
2655 | 2655 | -73.9659156108069 | 40.7810709818696 | 20E-AM-1014-01 | 20E | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9659156108069 40.7810709818696) | 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 | |||||||
2785 | 2785 | -73.9729105002306 | 40.7672758037086 | 4H-PM-1006-02 | 04H | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9729105002306 40.7672758037086) | 19 | 4 | 19 | 13 | |||||
2835 | 2835 | -73.9531953594918 | 40.7960413520131 | 40G-PM-1013-01 | 40G | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9531953594918 40.7960413520131) | 19 | 4 | 19 | 13 | ||||||
2871 | 2871 | -73.9777124331985 | 40.7704051056666 | 5B-AM-1008-03 | 05B | AM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9777124331985 40.7704051056666) | 19 | 4 | 19 | 13 | |||||
2878 | 2878 | -73.969720780557 | 40.7741105688757 | 12F-AM-1020-04 | 12F | AM | 10202018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.969720780557 40.7741105688757) | 19 | 4 | 19 | 13 | |||||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670432105975 40.7753462013506) | 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 | ||||
2981 | 2981 | -73.9800094828465 | 40.7677782585639 | 1B-AM-1012-04 | 01B | AM | 10122018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9800094828465 40.7677782585639) | 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 );