This data as json, CSV (advanced)
Suggested facets: Hectare Squirrel Number, Age, Highlight Fur Color, Color notes, Chasing, Other Activities, Kuks, Quaas, Tail flags, Indifferent, Runs from, Other Interactions, City Council Districts, Police Precincts
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9561344937861 | 40.7940823884086 | 37F-PM-1014-03 | 37F | PM | 10142018 | 3 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
37 | 37 | -73.9643153920428 | 40.7820818516957 | 22F-PM-1014-05 | 22F | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9643153920428 40.7820818516957) | 19 | 4 | 19 | 13 | |||||
47 | 47 | -73.9640032826529 | 40.7820309825448 | 22F-PM-1014-06 | 22F | PM | 10142018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9640032826529 40.7820309825448) | 19 | 4 | 19 | 13 | ||||||
72 | 72 | -73.9666007935638 | 40.7845098131567 | 23C-PM-1014-03 | 23C | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | false | true | false | false | false | chasing (#4 across trees) | false | false | false | false | false | false | false | false | POINT (-73.9666007935638 40.7845098131567) | 19 | 4 | 19 | 13 | |||||
81 | 81 | -73.9578237168359 | 40.7980959471034 | 40B-PM-1014-06 | 40B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9578237168359 40.7980959471034) | 19 | 4 | 19 | 13 | |||||
102 | 102 | -73.9575986161364 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | false | true | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
158 | 158 | -73.9710991123992 | 40.7723889726647 | 9F-PM-1014-02 | 09F | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9710991123992 40.7723889726647) | 19 | 4 | 19 | 13 | |||||
167 | 167 | -73.9597642778427 | 40.7976368003915 | 39A-PM-1014-02 | 39A | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9597642778427 40.7976368003915) | 19 | 4 | 19 | 13 | |||||
168 | 168 | -73.9745691353018 | 40.7771035589298 | 13A-PM-1014-03 | 13A | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | true | child chasing | POINT (-73.9745691353018 40.7771035589298) | 19 | 4 | 19 | 13 | ||||
213 | 213 | -73.968367485157 | 40.7838472644815 | 22B-PM-1014-05 | 22B | PM | 10142018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | eating (eats with head tilted far to the right (tooth issue?)) | false | false | false | false | false | false | false | false | POINT (-73.968367485157 40.7838472644815) | 19 | 4 | 19 | 13 | |||||
224 | 224 | -73.9520592496349 | 40.7975076299811 | 42G-PM-1014-03 | 42G | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | on fence | true | false | false | false | false | prancing | false | false | false | false | false | false | false | true | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
236 | 236 | -73.9737266070919 | 40.7786338379896 | 14A-PM-1014-01 | 14A | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9737266070919 40.7786338379896) | 19 | 4 | 19 | 13 | |||||
338 | 338 | -73.9765595553183 | 40.7748455340432 | 10A-PM-1014-04 | 10A | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9765595553183 40.7748455340432) | 19 | 4 | 19 | 13 | |||||
341 | 341 | -73.9703161745884 | 40.7702610461336 | 8H-PM-1014-05 | 08H | PM | 10142018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9703161745884 40.7702610461336) | 19 | 4 | 19 | 13 | ||||||
359 | 359 | -73.9716404781264 | 40.7753181851766 | 12D-PM-1014-02 | 12D | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | seems to be grinding teeth on a piece of material (sounds from grinding) | false | false | false | false | false | false | true | false | POINT (-73.9716404781264 40.7753181851766) | 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 | |||||
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 | ||||||
494 | 494 | -73.958837574505 | 40.7985003987784 | 40A-PM-1014-06 | 40A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958837574505 40.7985003987784) | 19 | 4 | 19 | 13 | |||||
499 | 499 | -73.9657288055011 | 40.7764580036287 | 16H-PM-1014-04 | 16H | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9657288055011 40.7764580036287) | 19 | 4 | 19 | 13 | |||||
517 | 517 | -73.954959868822 | 40.7985404965582 | 41D-PM-1014-03 | 41D | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.954959868822 40.7985404965582) | 19 | 4 | 19 | 13 | |||||
577 | 577 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 10142018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9497217674555 40.796517007214) | 19 | 4 | 19 | 13 | ||||||
581 | 581 | -73.9556218199258 | 40.7980460204041 | 41D-PM-1014-01 | 41D | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | digging,drinking | false | false | false | false | false | false | false | true | POINT (-73.9556218199258 40.7980460204041) | 19 | 4 | 19 | 13 | ||||
600 | 600 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
643 | 643 | -73.976730206737 | 40.773709213914 | 8A-PM-1014-01 | 08A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | true | false | false | false | false | false | false | true | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | 19 | 4 | 19 | 13 | ||||
709 | 709 | -73.9519387881692 | 40.7936273636929 | 38I-PM-1014-04 | 38I | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9519387881692 40.7936273636929) | 19 | 4 | 19 | 13 | ||||||
726 | 726 | -73.973305698325 | 40.7783823311296 | 14A-PM-1014-06 | 14A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 9 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.973305698325 40.7783823311296) | 19 | 4 | 19 | 13 | |||||
742 | 742 | -73.9767016963397 | 40.7674012784541 | 2E-PM-1014-02 | 02E | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767016963397 40.7674012784541) | 19 | 4 | 19 | 13 | |||||
744 | 744 | -73.9745687653791 | 40.7776396926997 | 13A-PM-1014-02 | 13A | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 45 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9745687653791 40.7776396926997) | 19 | 4 | 19 | 13 | ||||||
755 | 755 | -73.9579941847434 | 40.7991216713328 | 41B-PM-1014-02 | 41B | PM | 10142018 | 2 | Adult | Black | Black+ | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579941847434 40.7991216713328) | 19 | 4 | 19 | 13 | ||||||
840 | 840 | -73.9598084794625 | 40.7976165434502 | 39A-PM-1014-01 | 39A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9598084794625 40.7976165434502) | 19 | 4 | 19 | 13 | |||||
878 | 878 | -73.9757215415855 | 40.7668205976986 | 2F-PM-1014-03 | 02F | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9757215415855 40.7668205976986) | 19 | 4 | 19 | 13 | |||||
885 | 885 | -73.9750463844984 | 40.7666871742836 | 2F-PM-1014-08 | 02F | PM | 10142018 | 8 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9750463844984 40.7666871742836) | 19 | 4 | 19 | 13 | |||||
920 | 920 | -73.9571233640232 | 40.7992458980266 | 41B-PM-1014-04 | 41B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | climbing | POINT (-73.9571233640232 40.7992458980266) | 19 | 4 | 19 | 13 | ||||
974 | 974 | -73.9753744539307 | 40.7671162211032 | 2F-PM-1014-12 | 02F | PM | 10142018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97537445393071 40.7671162211032) | 19 | 4 | 19 | 13 | ||||||
985 | 985 | -73.9681722244801 | 40.783559826281 | 22B-PM-1014-07 | 22B | PM | 10142018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9681722244801 40.783559826281) | 19 | 4 | 19 | 13 | |||||
1022 | 1022 | -73.9548853492712 | 40.7984783584388 | 41D-PM-1014-04 | 41D | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | jumping tree to tree | false | false | false | false | false | false | false | false | POINT (-73.9548853492712 40.7984783584388) | 19 | 4 | 19 | 13 | ||||
1122 | 1122 | -73.9728700359494 | 40.7659842666881 | 3H-PM-1014-05 | 03H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9728700359494 40.7659842666881) | 19 | 4 | 19 | 13 | |||||
1183 | 1183 | -73.9525699067954 | 40.7937125788106 | 38I-PM-1014-01 | 38I | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | on the lawn East of the fountain | false | false | false | false | false | scampering thru the grass! | false | false | false | false | true | false | false | true | POINT (-73.9525699067954 40.7937125788106) | 19 | 4 | 19 | 13 | |||
1194 | 1194 | -73.9687462566073 | 40.783898987005 | 22B-PM-1014-06 | 22B | PM | 10142018 | 6 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | digging | false | false | false | false | false | false | false | false | POINT (-73.9687462566073 40.783898987005) | 19 | 4 | 19 | 13 | |||||
1206 | 1206 | -73.9748709206354 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 10142018 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9748709206354 40.77608025411) | 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 | ||||||
1314 | 1314 | -73.980919134781 | 40.7683772453336 | 1A-PM-1014-06 | 01A | PM | 10142018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.980919134781 40.7683772453336) | 19 | 4 | 19 | 13 | ||||||
1417 | 1417 | -73.974828939898 | 40.7668886121909 | 2F-PM-1014-11 | 02F | PM | 10142018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.974828939898 40.7668886121909) | 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 | ||||||
1489 | 1489 | -73.9501762527462 | 40.7975534086077 | 42H-PM-1014-05 | 42H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9501762527462 40.7975534086077) | 12423 | 18 | 4 | 36 | 18 | ||||
1506 | 1506 | -73.9728339757306 | 40.7782891207966 | 14B-PM-1014-04 | 14B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | running up and down | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9728339757306 40.7782891207966) | 19 | 4 | 19 | 13 | ||||
1527 | 1527 | -73.970216605149 | 40.7702960667277 | 8H-PM-1014-08 | 08H | PM | 10142018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#7),playing? | false | false | false | false | false | false | true | false | POINT (-73.970216605149 40.7702960667277) | 19 | 4 | 19 | 13 | |||||
1537 | 1537 | -73.9767220179725 | 40.7753262103123 | 10A-PM-1014-03 | 10A | PM | 10142018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | above my head in tree | false | false | false | true | false | eating (in a tree) | false | false | false | false | false | false | true | false | indifferent (lots of people taking its picture,didn't bother it) | POINT (-73.9767220179725 40.7753262103123) | 12420 | 20 | 4 | 19 | 12 | ||
1584 | 1584 | -73.9581310602492 | 40.7960214726964 | 38C-PM-1014-05 | 38C | PM | 10142018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | chasing (#4) | false | false | false | false | false | false | false | true | POINT (-73.9581310602492 40.7960214726964) | 19 | 4 | 19 | 13 | ||||
1604 | 1604 | -73.9734644470766 | 40.7782766486921 | 14A-PM-1014-05 | 14A | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.97346444707661 40.7782766486921) | 19 | 4 | 19 | 13 | |||||
1635 | 1635 | -73.9560731738677 | 40.7980336018554 | 41D-PM-1014-02 | 41D | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9560731738677 40.7980336018554) | 19 | 4 | 19 | 13 | |||||
1639 | 1639 | -73.9736800575584 | 40.7783069735758 | 14A-PM-1014-04 | 14A | PM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | chasing (#3) | false | false | false | false | true | false | true | false | POINT (-73.9736800575584 40.7783069735758) | 19 | 4 | 19 | 13 | ||||
1652 | 1652 | -73.9498421746221 | 40.7969397424182 | 42I-PM-1014-02 | 42I | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 8 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9498421746221 40.7969397424182) | 19 | 4 | 19 | 13 | |||||
1665 | 1665 | -73.9583944353352 | 40.7979689846815 | 39B-PM-1014-04 | 39B | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | true | runs from (me—when i approached) | POINT (-73.9583944353352 40.7979689846815) | 19 | 4 | 19 | 13 | |||||
1666 | 1666 | -73.9649465476871 | 40.7822708362663 | 22F-PM-1014-07 | 22F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9649465476871 40.7822708362663) | 19 | 4 | 19 | 13 | ||||||
1667 | 1667 | -73.9645989003589 | 40.7782157459155 | 18H-PM-1014-01 | 18H | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9645989003589 40.7782157459155) | 19 | 4 | 19 | 13 | |||||
1673 | 1673 | -73.9746940851342 | 40.7760966488186 | 11B-PM-1014-02 | 11B | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746940851342 40.7760966488186) | 19 | 4 | 19 | 13 | ||||||
1682 | 1682 | -73.9759258407288 | 40.7667622711142 | 2F-PM-1014-05 | 02F | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9759258407288 40.7667622711142) | 19 | 4 | 19 | 13 | ||||||
1732 | 1732 | -73.9767141407274 | 40.7737313251559 | 8A-PM-1014-02 | 08A | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | runs from (goes up a tree) | POINT (-73.9767141407274 40.7737313251559) | 19 | 4 | 19 | 13 | |||||
1735 | 1735 | -73.9563652303243 | 40.7955127873968 | 38E-PM-1014-05 | 38E | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | on log | false | false | false | false | false | statue | false | false | false | false | false | false | true | false | POINT (-73.9563652303243 40.7955127873968) | 19 | 4 | 19 | 13 | |||
1771 | 1771 | -73.9750688083336 | 40.7665584681025 | 2F-PM-1014-07 | 02F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9750688083336 40.7665584681025) | 19 | 4 | 19 | 13 | ||||||
1775 | 1775 | -73.951965247933 | 40.7938167628067 | 38I-PM-1014-03 | 38I | PM | 10142018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | true | POINT (-73.951965247933 40.7938167628067) | 19 | 4 | 19 | 13 | |||||
1807 | 1807 | -73.9581366214863 | 40.7988964092722 | 40B-PM-1014-02 | 40B | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | true | true | false | false | false | false | false | true | POINT (-73.9581366214863 40.7988964092722) | 19 | 4 | 19 | 13 | ||||||
1817 | 1817 | -73.9703076450783 | 40.770158422629 | 8H-PM-1014-07 | 08H | PM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#8),playing? | false | false | false | false | false | false | true | false | POINT (-73.9703076450783 40.770158422629) | 19 | 4 | 19 | 13 | |||||
1831 | 1831 | -73.9746877519291 | 40.7761402808083 | 11B-PM-1014-03 | 11B | PM | 10142018 | 3 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746877519291 40.7761402808083) | 19 | 4 | 19 | 13 | |||||||
1860 | 1860 | -73.9767100101318 | 40.7675779951996 | 2E-PM-1014-03 | 02E | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767100101318 40.7675779951996) | 19 | 4 | 19 | 13 | |||||
1876 | 1876 | -73.973598991549 | 40.7783020016983 | 14A-PM-1014-03 | 14A | PM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | chasing (#4) | false | false | false | false | false | false | true | false | POINT (-73.973598991549 40.7783020016983) | 19 | 4 | 19 | 13 | ||||
1884 | 1884 | -73.9733898487296 | 40.7666975131518 | 3H-PM-1014-02 | 03H | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9733898487296 40.7666975131518) | 19 | 4 | 19 | 13 | |||||
1908 | 1908 | -73.9588345546879 | 40.7991830272008 | 40A-PM-1014-02 | 40A | PM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from base of tree into bushes) | POINT (-73.9588345546879 40.7991830272008) | 19 | 4 | 19 | 13 | |||||
1926 | 1926 | -73.9742811484852 | 40.775533619083 | 11B-PM-1014-08 | 11B | PM | 10142018 | 8 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97428114848522 40.775533619083) | 19 | 4 | 19 | 13 | |||||||
1930 | 1930 | -73.9744279648953 | 40.7777760612191 | 13A-PM-1014-01 | 13A | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744279648953 40.7777760612191) | 19 | 4 | 19 | 13 | ||||||
1965 | 1965 | -73.9719359643975 | 40.772699885583 | 9F-PM-1014-01 | 09F | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | he is fed every day by a woman who calls him "chiquita"! he ran right up to her. | POINT (-73.9719359643975 40.772699885583) | 19 | 4 | 19 | 13 | ||||
1987 | 1987 | -73.9573692542155 | 40.7989252908321 | 41B-PM-1014-03 | 41B | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9573692542155 40.7989252908321) | 19 | 4 | 19 | 13 | |||||
2016 | 2016 | -73.9589492240754 | 40.798901118974 | 40A-PM-1014-01 | 40A | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | false | false | false | false | true | false | true | false | stared & then went back up tree—then ran to different tree | POINT (-73.9589492240754 40.798901118974) | 19 | 4 | 19 | 13 | ||||
2029 | 2029 | -73.9687213827744 | 40.7843586374648 | 22B-PM-1014-02 | 22B | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687213827744 40.7843586374648) | 19 | 4 | 19 | 13 | |||||
2047 | 2047 | -73.9721656413591 | 40.7722869065638 | 9F-PM-1014-08 | 09F | PM | 10142018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | turned to face me while eating | POINT (-73.9721656413591 40.7722869065638) | 19 | 4 | 19 | 13 | ||||
2052 | 2052 | -73.9746493441414 | 40.7750478734868 | 11B-PM-1014-06 | 11B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | false | false | false | cleaning | false | false | false | false | false | false | true | false | POINT (-73.9746493441414 40.7750478734868) | 19 | 4 | 19 | 13 | ||||
2054 | 2054 | -73.9726381234747 | 40.7752694815985 | 12D-PM-1014-01 | 12D | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9726381234747 40.7752694815985) | 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 | |||||
2086 | 2086 | -73.9525627119429 | 40.7938602867464 | 38I-PM-1014-02 | 38I | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | hanging out w/ Squirrel #1 | false | false | false | false | false | scampering w/ squirrel #1 | false | false | false | false | true | false | false | true | POINT (-73.9525627119429 40.7938602867464) | 19 | 4 | 19 | 13 | |||
2112 | 2112 | -73.9655206571055 | 40.7764851568746 | 16H-PM-1014-02 | 16H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9655206571055 40.7764851568746) | 19 | 4 | 19 | 13 | |||||
2128 | 2128 | -73.9757673193743 | 40.7669614322613 | 2F-PM-1014-04 | 02F | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9757673193743 40.766961432261304) | 19 | 4 | 19 | 13 | ||||||
2154 | 2154 | -73.976716425804 | 40.7736889979965 | 8A-PM-1014-03 | 08A | PM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 23 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.976716425804 40.7736889979965) | 19 | 4 | 19 | 13 | ||||||
2160 | 2160 | -73.975028559002 | 40.7667307335544 | 2F-PM-1014-09 | 02F | PM | 10142018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.975028559002 40.7667307335544) | 19 | 4 | 19 | 13 | |||||
2243 | 2243 | -73.9579967047318 | 40.7948682042252 | 37D-PM-1014-02 | 37D | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.95799670473181 40.7948682042252) | 19 | 4 | 19 | 13 | ||||||
2244 | 2244 | -73.9509628195532 | 40.7977775674178 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9509628195532 40.7977775674178) | 12423 | 18 | 4 | 36 | 18 | ||||
2251 | 2251 | -73.9587678566254 | 40.7962656030995 | 38C-PM-1014-01 | 38C | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9587678566254 40.7962656030995) | 19 | 4 | 19 | 13 | |||||
2270 | 2270 | -73.9703732649257 | 40.7701979377103 | 8H-PM-1014-04 | 08H | PM | 10142018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.97037326492571 40.7701979377103) | 19 | 4 | 19 | 13 | ||||||
2279 | 2279 | -73.9586085858962 | 40.7990326758282 | 40A-PM-1014-04 | 40A | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from path to bushes) | POINT (-73.9586085858962 40.7990326758282) | 19 | 4 | 19 | 13 | |||||
2307 | 2307 | -73.9736997033862 | 40.778497952406 | 14A-PM-1014-02 | 14A | PM | 10142018 | 2 | 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.9736997033862 40.778497952406) | 19 | 4 | 19 | 13 | |||||
2325 | 2325 | -73.9728360875598 | 40.7660637295671 | 3H-PM-1014-04 | 03H | PM | 10142018 | 4 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9728360875598 40.7660637295671) | 19 | 4 | 19 | 13 | |||||
2341 | 2341 | -73.9665363265054 | 40.7844967881001 | 23C-PM-1014-04 | 23C | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | false | false | false | being chased by #3 across trees | false | false | false | false | false | false | false | false | POINT (-73.9665363265054 40.7844967881001) | 19 | 4 | 19 | 13 | |||||
2387 | 2387 | -73.9808517324721 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 10142018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9808517324721 40.7683154647217) | 19 | 4 | 19 | 13 | |||||
2410 | 2410 | -73.9755192076934 | 40.7664413570796 | 2F-PM-1014-06 | 02F | PM | 10142018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9755192076934 40.7664413570796) | 19 | 4 | 19 | 13 | |||||
2416 | 2416 | -73.9588689820908 | 40.7992384137972 | 40A-PM-1014-03 | 40A | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from base of tree into bushes) | POINT (-73.9588689820908 40.799238413797205) | 19 | 4 | 19 | 13 | |||||
2441 | 2441 | -73.9579865329778 | 40.794906535675 | 37D-PM-1014-03 | 37D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579865329778 40.794906535675) | 19 | 4 | 19 | 13 | ||||||
2443 | 2443 | -73.9667073186959 | 40.7840581361598 | 23C-PM-1014-01 | 23C | PM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.96670731869591 40.7840581361598) | 19 | 4 | 19 | 13 | ||||||
2465 | 2465 | -73.9686999860219 | 40.7844014735136 | 22B-PM-1014-03 | 22B | PM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686999860219 40.7844014735136) | 19 | 4 | 19 | 13 | |||||
2507 | 2507 | -73.964868521585 | 40.7821064183815 | 22F-PM-1014-01 | 22F | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.964868521585 40.7821064183815) | 19 | 4 | 19 | 13 | |||||
2551 | 2551 | -73.970138810251 | 40.770579297644 | 8H-PM-1014-02 | 08H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | froze & watched me,then went back to eating | POINT (-73.970138810251 40.770579297644) | 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 );