This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Running, Chasing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | -73.9768311751004 | 40.7667178072558 | 2E-AM-1010-03 | 02E | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9768311751004 40.76671780725581) | 19 | 4 | 19 | 13 | ||||||
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9574648097543 40.78925084286221) | 19 | 4 | 19 | 13 | |||||
97 | 97 | -73.9639744005647 | 40.7825111950764 | 22F-AM-1007-01 | 22F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9639744005647 40.7825111950764) | 19 | 4 | 19 | 13 | |||||
99 | 99 | -73.9710541405708 | 40.7724691605718 | 10F-PM-1019-05 | 10F | PM | 10192018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Behind fence, tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9710541405708 40.7724691605718) | 19 | 4 | 19 | 13 | |||||
112 | 112 | -73.9651754464439 | 40.7755181941559 | 15I-AM-1008-01 | 15I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | tree | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9651754464439 40.7755181941559) | 19 | 4 | 19 | 13 | ||||
147 | 147 | -73.9564023626619 | 40.7905423546155 | 33G-AM-1013-02 | 33G | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564023626619 40.7905423546155) | 19 | 4 | 19 | 13 | |||||
166 | 166 | -73.963846339804 | 40.7834051716226 | 23F-AM-1018-01 | 23F | AM | 10182018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.963846339804 40.7834051716226) | 19 | 4 | 19 | 13 | |||||
169 | 169 | -73.9748706415584 | 40.7744174965072 | 10B-AM-1006-02 | 10B | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | High in a tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9748706415584 40.7744174965072) | 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 | |||||
201 | 201 | -73.9598015842806 | 40.7973522744237 | 38A-PM-1013-03 | 38A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9598015842806 40.7973522744237) | 19 | 4 | 19 | 13 | |||||
207 | 207 | -73.9770824412252 | 40.7709961309457 | 5C-AM-1006-03 | 05C | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97708244122522 40.7709961309457) | 19 | 4 | 19 | 13 | |||||
255 | 255 | -73.9800669115792 | 40.7676825134384 | 1B-AM-1012-07 | 01B | AM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on tree trunk | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
256 | 256 | -73.976798124308 | 40.7741316574113 | 9A-PM-1010-04 | 09A | PM | 10102018 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97679812430802 40.7741316574113) | 19 | 4 | 19 | 13 | |||||||
261 | 261 | -73.9552861155228 | 40.788973931872 | 32I-AM-1013-05 | 32I | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552861155228 40.788973931872) | 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 | |||||
279 | 279 | -73.9550082056509 | 40.7894521543449 | 33I-AM-1008-03 | 33I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | 98th @ edge of park | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9550082056509 40.7894521543449) | 19 | 4 | 19 | 13 | |||||
286 | 286 | -73.9720907384613 | 40.7762987836055 | 13C-PM-1019-01 | 13C | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 7 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.9720907384613 40.7762987836055) | 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 | ||||
300 | 300 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 10172018 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10 | Running down tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9528149779809 40.7924984810637) | 19 | 4 | 19 | 13 | |||
326 | 326 | -73.9699843570636 | 40.7729480440312 | 10G-AM-1006-01 | 10G | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 80 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.96998435706361 40.7729480440312) | 19 | 4 | 19 | 13 | ||||||
336 | 336 | -73.9757413215621 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
339 | 339 | -73.965509576403 | 40.7752456763263 | 14I-PM-1018-05 | 14I | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | false | false | true | true | false | false | false | false | false | true | false | true | false | POINT (-73.96550957640301 40.7752456763263) | 19 | 4 | 19 | 13 | |||||
347 | 347 | -73.9611696144784 | 40.7816692895155 | 22I-AM-1007-03 | 22I | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611696144784 40.7816692895155) | 19 | 4 | 19 | 13 | ||||||
378 | 378 | -73.9584835416846 | 40.7978213396921 | 39B-PM-1014-06 | 39B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9584835416846 40.7978213396921) | 19 | 4 | 19 | 13 | |||||
380 | 380 | -73.9649590119935 | 40.7822107920769 | 21F-AM-1018-01 | 21F | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9649590119935 40.7822107920769) | 19 | 4 | 19 | 13 | ||||||
414 | 414 | -73.9721899838568 | 40.7761519045651 | 13C-AM-1010-03 | 13C | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721899838568 40.7761519045651) | 19 | 4 | 19 | 13 | ||||||
415 | 415 | -73.9570131890379 | 40.7991786736124 | 41B-PM-1014-05 | 41B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | true | false | false | false | false | false | true | true | POINT (-73.9570131890379 40.7991786736124) | 19 | 4 | 19 | 13 | ||||||
428 | 428 | -73.96362827608 | 40.7807994595242 | 21G-AM-1014-02 | 21G | AM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 3 | fence | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.96362827608 40.7807994595242) | 19 | 4 | 19 | 13 | ||||
440 | 440 | -73.9642717435966 | 40.782087049693 | 22F-AM-1007-05 | 22F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9642717435966 40.782087049693) | 19 | 4 | 19 | 13 | ||||
457 | 457 | -73.965848283831 | 40.7797243033057 | 19F-PM-1017-01 | 19F | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.965848283831 40.7797243033057) | 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 | ||||
483 | 483 | -73.9789952029637 | 40.7697758333099 | 4B-AM-1010-03 | 04B | AM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9789952029637 40.7697758333099) | 19 | 4 | 19 | 13 | |||||
508 | 508 | -73.9746918762076 | 40.7655231883678 | 1G-AM-1006-02 | 01G | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30 | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9746918762076 40.7655231883678) | 19 | 4 | 19 | 13 | |||||
518 | 518 | -73.9687847410656 | 40.778185700305 | 16E-AM-1014-09 | 16E | AM | 10142018 | 9 | Adult | Gray | Gray+ | Above Ground | 25 | In tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687847410656 40.778185700305) | 19 | 4 | 19 | 13 | |||||
525 | 525 | -73.952526164386 | 40.7963759240504 | 40G-AM-1007-02 | 40G | AM | 10072018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 18 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.952526164386 40.7963759240504) | 19 | 4 | 19 | 13 | |||||
530 | 530 | -73.9696360756453 | 40.7786545659072 | 16D-PM-1010-03 | 16D | PM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9696360756453 40.7786545659072) | 19 | 4 | 19 | 13 | ||||||
531 | 531 | -73.9709104380323 | 40.7769096957616 | 14D-AM-1014-16 | 14D | AM | 10142018 | 16 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9709104380323 40.7769096957616) | 19 | 4 | 19 | 13 | |||||
539 | 539 | -73.9761440627966 | 40.7706035301542 | 6D-PM-1020-04 | 06D | PM | 10202018 | 4 | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9761440627966 40.7706035301542) | 19 | 4 | 19 | 13 | |||||||
565 | 565 | -73.9615402629655 | 40.7924082330328 | 33C-AM-1012-02 | 33C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along back & tail | Above Ground | 20 | tree branches | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9615402629655 40.7924082330328) | 19 | 4 | 19 | 13 | |||
567 | 567 | -73.9756972647636 | 40.773624164826 | 9B-PM-1013-04 | 09B | PM | 10132018 | 4 | Juvenile | Gray | Black | Gray+Black | Above Ground | 30 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9756972647636 40.773624164826) | 19 | 4 | 19 | 13 | |||||
569 | 569 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | tree | true | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.9709040623777 40.7701163892686) | 19 | 4 | 19 | 13 | |||||
620 | 620 | -73.9655905300923 | 40.7752614638023 | 14I-PM-1018-06 | 14I | PM | 10182018 | 6 | Adult | Cinnamon | Black | Cinnamon+Black | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9655905300923 40.7752614638023) | 19 | 4 | 19 | 13 | |||||
634 | 634 | -73.9596375907038 | 40.7907347708353 | 32E-AM-1007-05 | 32E | AM | 10072018 | 5 | Adult | Black | Black+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9596375907038 40.79073477083531) | 19 | 4 | 19 | 13 | ||||||
649 | 649 | -73.9554891003543 | 40.7968774599654 | 40E-AM-1014-03 | 40E | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9554891003543 40.79687745996541) | 19 | 4 | 19 | 13 | |||||
657 | 657 | -73.9679008849677 | 40.7759013923034 | 14G-AM-1012-02 | 14G | AM | 10122018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9679008849677 40.7759013923034) | 19 | 4 | 19 | 13 | ||||||
695 | 695 | -73.9685080639873 | 40.7745309794155 | 13G-PM-1008-03 | 13G | PM | 10082018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | maple tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9685080639873 40.77453097941551) | 19 | 4 | 19 | 13 | ||||
700 | 700 | -73.9691261755936 | 40.7702929428604 | 8I-AM-1006-12 | 08I | AM | 10062018 | 12 | Adult | Gray | Gray+ | Above Ground | 50 | tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691261755936 40.7702929428604) | 19 | 4 | 19 | 13 | |||||
733 | 733 | -73.9764397550289 | 40.7737004557104 | 8B-AM-1007-01 | 08B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9764397550289 40.7737004557104) | 19 | 4 | 19 | 13 | |||||
737 | 737 | -73.9711176999471 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | Different tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9711176999471 40.7724278547281) | 19 | 4 | 19 | 13 | ||||
754 | 754 | -73.9563203089105 | 40.7906275357726 | 33G-PM-1006-01 | 33G | PM | 10062018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9563203089105 40.7906275357726) | 19 | 4 | 19 | 13 | ||||||
764 | 764 | -73.9746608786299 | 40.7776092078254 | 13A-AM-1017-01 | 13A | AM | 10172018 | 1 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9746608786299 40.7776092078254) | 19 | 4 | 19 | 13 | ||||||
765 | 765 | -73.96797780019 | 40.7847629473258 | 23B-PM-1012-05 | 23B | PM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | chain link fence | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.96797780019 40.7847629473258) | 19 | 4 | 19 | 13 | ||||
773 | 773 | -73.9566189145352 | 40.7883417969746 | 31H-PM-1008-01 | 31H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9566189145352 40.7883417969746) | 19 | 4 | 19 | 13 | |||||
776 | 776 | -73.9686816795392 | 40.775770422667 | 14F-PM-1012-02 | 14F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9686816795392 40.775770422667) | 19 | 4 | 19 | 13 | |||||
781 | 781 | -73.955516031113 | 40.7923188156277 | 35G-AM-1007-01 | 35G | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.955516031113 40.7923188156277) | 19 | 4 | 19 | 13 | |||||
788 | 788 | -73.9687476703117 | 40.7742856696093 | 12G-AM-1012-01 | 12G | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687476703117 40.7742856696093) | 19 | 4 | 19 | 13 | |||||
798 | 798 | -73.980854228628 | 40.7678702158382 | 1B-AM-1012-17 | 01B | AM | 10122018 | 17 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.98085422862802 40.7678702158382) | 19 | 4 | 19 | 13 | |||||
835 | 835 | -73.9707900566519 | 40.7771670550089 | 14D-AM-1014-09 | 14D | AM | 10142018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9707900566519 40.7771670550089) | 19 | 4 | 19 | 13 | |||||
856 | 856 | -73.9591667162801 | 40.7937602121568 | 35D-PM-1013-07 | 35D | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Above Ground | 12 | tree | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.95916671628011 40.7937602121568) | 19 | 4 | 19 | 13 | ||||
894 | 894 | -73.9675198230918 | 40.778631094685 | 17F-AM-1007-02 | 17F | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9675198230918 40.778631094685) | 19 | 4 | 19 | 13 | |||||
908 | 908 | -73.9594120573719 | 40.7841945750598 | 26I-PM-1010-05 | 26I | PM | 10102018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | tree | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9594120573719 40.7841945750598) | 19 | 4 | 19 | 13 | ||||
937 | 937 | -73.9706323458769 | 40.7713196034265 | 9G-PM-1007-03 | 09G | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706323458769 40.771319603426505) | 19 | 4 | 19 | 13 | |||||
942 | 942 | -73.9533923917973 | 40.7961701874769 | 40G-AM-1007-01 | 40G | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | large tree | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9533923917973 40.7961701874769) | 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 | ||||
967 | 967 | -73.9683994064731 | 40.7710765500799 | 9I-AM-1014-06 | 09I | AM | 10142018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.96839940647311 40.7710765500799) | 19 | 4 | 19 | 13 | |||||
1010 | 1010 | -73.9689723590015 | 40.7756860990338 | 13F-AM-1007-01 | 13F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689723590015 40.7756860990338) | 19 | 4 | 19 | 13 | |||||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552035011902 40.7889851896334) | 19 | 4 | 19 | 13 | ||||
1035 | 1035 | -73.9772569909673 | 40.7664804797448 | 1E-AM-1006-02 | 01E | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9772569909673 40.7664804797448) | 19 | 4 | 19 | 13 | |||||
1041 | 1041 | -73.9643236505425 | 40.7887854771596 | 28C-AM-1014-02 | 28C | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9643236505425 40.7887854771596) | 19 | 4 | 19 | 13 | ||||||
1044 | 1044 | -73.9693254080548 | 40.7761600327118 | 14F-AM-1007-01 | 14F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9693254080548 40.7761600327118) | 19 | 4 | 19 | 13 | |||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | true | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
1067 | 1067 | -73.9695305996721 | 40.7745386896959 | 12F-PM-1007-02 | 12F | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695305996721 40.7745386896959) | 19 | 4 | 19 | 13 | |||||
1093 | 1093 | -73.9584106786233 | 40.7902777556926 | 32F-PM-1008-02 | 32F | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584106786233 40.7902777556926) | 19 | 4 | 19 | 13 | |||||
1095 | 1095 | -73.9735547926323 | 40.7723420076108 | 8D-AM-1007-02 | 08D | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 12 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9735547926323 40.7723420076108) | 19 | 4 | 19 | 13 | ||||||
1104 | 1104 | -73.9589852989486 | 40.7912720015917 | 33E-AM-1014-07 | 33E | AM | 10142018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9589852989486 40.7912720015917) | 19 | 4 | 19 | 13 | |||||
1140 | 1140 | -73.9615817859213 | 40.7945839663845 | 35A-AM-1014-08 | 35A | AM | 10142018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9615817859213 40.79458396638451) | 19 | 4 | 19 | 13 | |||||
1145 | 1145 | -73.9611446263364 | 40.7911003407299 | 32D-AM-1013-03 | 32D | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611446263364 40.7911003407299) | 19 | 4 | 19 | 13 | |||||
1161 | 1161 | -73.9694066600156 | 40.7805662180672 | 18C-PM-1018-06 | 18C | PM | 10182018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694066600156 40.7805662180672) | 19 | 4 | 19 | 13 | |||||
1164 | 1164 | -73.9790226400629 | 40.7698997653792 | 4B-AM-1010-01 | 04B | AM | 10102018 | 1 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9790226400629 40.7698997653792) | 19 | 4 | 19 | 13 | |||||
1166 | 1166 | -73.980048119915 | 40.7676638655026 | 1B-AM-1012-06 | 01B | AM | 10122018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.980048119915 40.7676638655026) | 19 | 4 | 19 | 13 | |||||
1182 | 1182 | -73.9667206046912 | 40.7779993565098 | 17G-PM-1017-04 | 17G | PM | 10172018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9667206046912 40.7779993565098) | 19 | 4 | 19 | 13 | ||||
1185 | 1185 | -73.958230674366 | 40.7989268396525 | 40B-AM-1019-08 | 40B | AM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | true | POINT (-73.958230674366 40.7989268396525) | 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 | ||||||
1207 | 1207 | -73.9594708328732 | 40.791192982895 | 32E-AM-1007-07 | 32E | AM | 10072018 | 7 | Adult | Gray | Gray+ | Above Ground | on tennis club house roof | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9594708328732 40.791192982895) | 19 | 4 | 19 | 13 | ||||||
1225 | 1225 | -73.9584803513939 | 40.7933802077327 | 35D-PM-1013-01 | 35D | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 12 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9584803513939 40.7933802077327) | 19 | 4 | 19 | 13 | |||||
1227 | 1227 | -73.9527924755398 | 40.7934366260533 | 37I-AM-1010-04 | 37I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 50 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527924755398 40.7934366260533) | 19 | 4 | 19 | 13 | |||||
1253 | 1253 | -73.9527227282134 | 40.7935061484064 | 37I-AM-1010-03 | 37I | AM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527227282134 40.7935061484064) | 19 | 4 | 19 | 13 | ||||
1262 | 1262 | -73.9683345414813 | 40.7779016280345 | 16E-PM-1018-07 | 16E | PM | 10182018 | 7 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.9683345414813 40.7779016280345) | 19 | 4 | 19 | 13 | |||||
1274 | 1274 | -73.9745859998733 | 40.7671634885616 | 3G-AM-1008-02 | 03G | AM | 10082018 | 2 | Adult | Gray | Gray+ | Big one! Beautiful tail | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9745859998733 40.7671634885616) | 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 | |||||
1301 | 1301 | -73.9552146665714 | 40.7892909102377 | 32I-PM-1007-03 | 32I | PM | 10072018 | 3 | Adult | Gray | Gray+ | small adult | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9552146665714 40.7892909102377) | 19 | 4 | 19 | 13 | |||||
1331 | 1331 | -73.9588809150045 | 40.7847231576181 | 26I-PM-1010-01 | 26I | PM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9588809150045 40.7847231576181) | 19 | 4 | 19 | 13 | |||||
1351 | 1351 | -73.9610985171525 | 40.7913867116989 | 32D-AM-1013-01 | 32D | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9610985171525 40.7913867116989) | 19 | 4 | 19 | 13 | |||||
1394 | 1394 | -73.95488263914 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 10142018 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2 | up/down tree | true | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.95488263914 40.7959474571251) | 19 | 4 | 19 | 13 | |||||
1397 | 1397 | -73.9655233748105 | 40.7792737287734 | 18G-AM-1014-01 | 18G | AM | 10142018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | true | false | looking | POINT (-73.9655233748105 40.7792737287734) | 19 | 4 | 19 | 13 | ||||
1400 | 1400 | -73.9773495807135 | 40.7664559937331 | 1E-AM-1006-05 | 01E | AM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9773495807135 40.7664559937331) | 19 | 4 | 19 | 13 | |||||
1402 | 1402 | -73.9745009906157 | 40.7741574075364 | 10C-AM-1018-01 | 10C | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9745009906157 40.7741574075364) | 19 | 4 | 19 | 13 | ||||||
1413 | 1413 | -73.9810032206428 | 40.7681625634979 | 1A-AM-1007-01 | 01A | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9810032206428 40.7681625634979) | 19 | 4 | 19 | 13 | |||||
1422 | 1422 | -73.9537356145842 | 40.7917273773486 | 35I-PM-1006-02 | 35I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9537356145842 40.7917273773486) | 19 | 4 | 19 | 13 | ||||||
1425 | 1425 | -73.9586252875856 | 40.7852027586217 | 27I-AM-1007-03 | 27I | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | had .5 of a tail | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586252875856 40.7852027586217) | 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 );