This data as json, CSV (advanced)
Suggested facets: Shift, 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, Kuks, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2031 | 2031 | -73.9795454787631 | 40.7688026892741 | 3B-PM-1007-09 | 03B | PM | 10072018 | 9 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9795454787631 40.7688026892741) | 19 | 4 | 19 | 13 | |||||||||
2141 | 2141 | -73.9787015184662 | 40.7690114585688 | 3B-PM-1007-06 | 03B | PM | 10072018 | 6 | Juvenile | + | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9787015184662 40.7690114585688) | 19 | 4 | 19 | 13 | |||||||||
2851 | 2851 | -73.955208233231 | 40.7890574331084 | 32I-PM-1007-02 | 32I | PM | 10072018 | 2 | Adult | + | Above Ground | 30 | false | false | true | false | false | different sound - happy,playful chirps | false | false | false | false | true | false | true | false | POINT (-73.955208233231 40.7890574331084) | 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 | ||||||
2241 | 2241 | -73.9575258627966 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 10072018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9575258627966 40.787715550749) | 19 | 4 | 19 | 13 | ||||||
1843 | 1843 | -73.9685940262068 | 40.776932102013 | 15F-AM-1007-07 | 15F | AM | 10072018 | 7 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9685940262068 40.776932102013) | 19 | 4 | 19 | 13 | |||||
319 | 319 | -73.9659034359706 | 40.7797516688844 | 19F-AM-1007-02 | 19F | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 8 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9659034359706 40.77975166888441) | 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 | |||||
685 | 685 | -73.9658181813014 | 40.7798160637561 | 19F-AM-1007-01 | 19F | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | bit scared | POINT (-73.9658181813014 40.7798160637561) | 19 | 4 | 19 | 13 | ||||
687 | 687 | -73.9636971843665 | 40.7825638537362 | 22F-AM-1007-04 | 22F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9636971843665 40.7825638537362) | 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 | |||||
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 | |||||
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 | |||||
971 | 971 | -73.978392591149 | 40.7668993398193 | 1D-PM-1007-04 | 01D | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.978392591149 40.7668993398193) | 19 | 4 | 19 | 13 | |||||
1056 | 1056 | -73.9811078442462 | 40.767515940567 | 1A-AM-1007-04 | 01A | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9811078442462 40.767515940567) | 12081 | 11 | 4 | 51 | 10 | ||||
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 | |||||
1457 | 1457 | -73.9697744662785 | 40.7755950428973 | 13F-AM-1007-04 | 13F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697744662785 40.7755950428973) | 19 | 4 | 19 | 13 | |||||
1513 | 1513 | -73.9662409997642 | 40.7891042935432 | 28A-PM-1007-03 | 28A | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | true | true | chasing #2 took #2 food wrapper and is foraging through it | false | false | false | false | false | false | true | false | POINT (-73.9662409997642 40.7891042935432) | 19 | 4 | 19 | 13 | ||||
2026 | 2026 | -73.9622752768962 | 40.7814921913101 | 22H-PM-1007-02 | 22H | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | low branch | false | false | false | false | false | watching me scratching | true | false | false | true | false | false | true | false | POINT (-73.9622752768962 40.7814921913101) | 19 | 4 | 19 | 13 | |||
2075 | 2075 | -73.9636234953334 | 40.7775138547689 | 18I-PM-1007-06 | 18I | PM | 10072018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9636234953334 40.7775138547689) | 19 | 4 | 19 | 13 | ||||
2184 | 2184 | -73.9694938608335 | 40.7745700102115 | 12F-PM-1007-03 | 12F | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694938608335 40.7745700102115) | 19 | 4 | 19 | 13 | |||||
2943 | 2943 | -73.962534856258 | 40.7812134517411 | 22H-PM-1007-01 | 22H | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.962534856258 40.7812134517411) | 19 | 4 | 19 | 13 | |||||
3003 | 3003 | -73.9698663926657 | 40.773999710413 | 12F-PM-1007-09 | 12F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9698663926657 40.773999710413) | 19 | 4 | 19 | 13 | |||||
3004 | 3004 | -73.9528482858163 | 40.7922056218325 | 36I-PM-1007-08 | 36I | PM | 10072018 | 8 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9528482858163 40.7922056218325) | 19 | 4 | 19 | 13 | |||||
2891 | 2891 | -73.9636482556874 | 40.7775831570186 | 18I-PM-1007-05 | 18I | PM | 10072018 | 5 | Juvenile | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | false | false | false | false | true | jumping crazily / digging hole | false | false | false | false | false | false | true | false | POINT (-73.9636482556874 40.7775831570186) | 19 | 4 | 19 | 13 | ||||
660 | 660 | -73.9638298997554 | 40.7825966332367 | 22F-AM-1007-03 | 22F | AM | 10072018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | large white highlight | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9638298997554 40.7825966332367) | 19 | 4 | 19 | 13 | ||||
799 | 799 | -73.9529413156461 | 40.7920963446605 | 36I-PM-1007-06 | 36I | PM | 10072018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9529413156461 40.7920963446605) | 19 | 4 | 19 | 13 | |||||
68 | 68 | -73.9694240327509 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 10072018 | 2 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.96942403275091 40.7755898126674) | 19 | 4 | 19 | 13 | |||||||
800 | 800 | -73.9682144039334 | 40.7773070675393 | 15F-AM-1007-08 | 15F | AM | 10072018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9682144039334 40.7773070675393) | 19 | 4 | 19 | 13 | |||||
1246 | 1246 | -73.9543044385367 | 40.7984498571338 | 41E-AM-1007-04 | 41E | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white haunches/tail | Ground Plane | FALSE | rubbing belly on ground | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9543044385367 40.798449857133804) | 19 | 4 | 19 | 13 | |||
1418 | 1418 | -73.9673924060436 | 40.7788781851716 | 17F-AM-1007-03 | 17F | AM | 10072018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9673924060436 40.7788781851716) | 19 | 4 | 19 | 13 | |||||
2081 | 2081 | -73.9675718059539 | 40.7786049141486 | 17F-AM-1007-06 | 17F | AM | 10072018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9675718059539 40.7786049141486) | 19 | 4 | 19 | 13 | |||||
2478 | 2478 | -73.9674931070324 | 40.7783693690954 | 17F-AM-1007-04 | 17F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 4 | false | false | false | true | false | chilling | true | false | false | false | false | false | true | false | POINT (-73.9674931070324 40.7783693690954) | 19 | 4 | 19 | 13 | ||||
2732 | 2732 | -73.9694185786221 | 40.7787189999566 | 16D-AM-1007-06 | 16D | AM | 10072018 | 6 | Adult | Cinnamon | White | Cinnamon+White | primary color: brown ( I marked cinnamon as closest to brown - JO) | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694185786221 40.7787189999566) | 19 | 4 | 19 | 13 | ||||
76 | 76 | -73.9530035564643 | 40.7921822457613 | 36I-PM-1007-07 | 36I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9530035564643 40.7921822457613) | 19 | 4 | 19 | 13 | ||||||
192 | 192 | -73.9651654887991 | 40.7777806006951 | 17H-PM-1007-02 | 17H | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9651654887991 40.7777806006951) | 19 | 4 | 19 | 13 | ||||||
215 | 215 | -73.9519639918804 | 40.7949911702392 | 39H-AM-1007-01 | 39H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9519639918804 40.7949911702392) | 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 | ||||||
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 | |||||
599 | 599 | -73.9530263552489 | 40.7920949788358 | 36I-PM-1007-05 | 36I | PM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9530263552489 40.7920949788358) | 19 | 4 | 19 | 13 | ||||||
610 | 610 | -73.9671549566066 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 180 | top of tree | true | false | false | false | false | jumping between branches | false | false | false | false | false | false | true | false | POINT (-73.9671549566066 40.7751342870705) | 19 | 4 | 19 | 13 | ||||
892 | 892 | -73.9611368390233 | 40.7815619053395 | 22I-AM-1007-02 | 22I | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9611368390233 40.7815619053395) | 19 | 4 | 19 | 13 | ||||||
912 | 912 | -73.958024711869 | 40.7938724278575 | 36D-PM-1007-01 | 36D | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.958024711869 40.7938724278575) | 19 | 4 | 19 | 13 | ||||||
936 | 936 | -73.9684758245091 | 40.7858531619022 | 24A-PM-1007-02 | 24A | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9684758245091 40.7858531619022) | 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 | ||||||
1190 | 1190 | -73.9728069355821 | 40.7794458131748 | 15A-AM-1007-01 | 15A | AM | 10072018 | 1 | Adult | Gray | Gray+ | tbd | Ground Plane | FALSE | false | false | false | false | true | hopping | false | false | false | false | false | false | true | false | in fenced in lawn (chill) | POINT (-73.9728069355821 40.7794458131748) | 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 | ||||||
1228 | 1228 | -73.9729090336637 | 40.7794340052503 | 15A-AM-1007-02 | 15A | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | in fenced in lawn (chill) | POINT (-73.9729090336637 40.7794340052503) | 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 | |||||
1321 | 1321 | -73.9699285688296 | 40.7774474015189 | 15D-AM-1007-08 | 15D | AM | 10072018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | chasing #7 | false | false | false | false | false | false | true | false | POINT (-73.9699285688296 40.7774474015189) | 19 | 4 | 19 | 13 | |||||
1546 | 1546 | -73.976422624924 | 40.7735818387346 | 8B-AM-1007-08 | 08B | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | true | false | holding nut | false | false | false | false | false | false | true | false | POINT (-73.976422624924 40.7735818387346) | 19 | 4 | 19 | 13 | |||||
1570 | 1570 | -73.9662864884789 | 40.7891062338302 | 28A-PM-1007-02 | 28A | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | running from #3 | false | false | false | false | false | false | true | false | POINT (-73.9662864884789 40.7891062338302) | 19 | 4 | 19 | 13 | |||||
1612 | 1612 | -73.9746049088475 | 40.7728776887397 | 8C-AM-1007-01 | 08C | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | behind fence, safe | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9746049088475 40.7728776887397) | 19 | 4 | 19 | 13 | |||||
1647 | 1647 | -73.9795585338537 | 40.768895893226 | 3B-PM-1007-08 | 03B | PM | 10072018 | 8 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9795585338537 40.768895893226) | 19 | 4 | 19 | 13 | ||||||
1701 | 1701 | -73.9701634768603 | 40.7778691433218 | 15D-AM-1007-03 | 15D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9701634768603 40.7778691433218) | 19 | 4 | 19 | 13 | ||||||
1713 | 1713 | -73.97977158132 | 40.7706273151066 | 4A-AM-1007-01 | 04A | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.97977158132 40.7706273151066) | 19 | 4 | 19 | 13 | ||||||
1724 | 1724 | -73.9795492724533 | 40.7709497471738 | 4A-AM-1007-02 | 04A | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9795492724533 40.7709497471738) | 19 | 4 | 19 | 13 | ||||||
1729 | 1729 | -73.9765046109019 | 40.7736674124746 | 8B-AM-1007-04 | 08B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9765046109019 40.7736674124746) | 19 | 4 | 19 | 13 | ||||||
1743 | 1743 | -73.9635412640983 | 40.7902529354639 | 30B-AM-1007-11 | 30B | AM | 10072018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9635412640983 40.7902529354639) | 19 | 4 | 19 | 13 | ||||||
1750 | 1750 | -73.9684806250183 | 40.7858776210151 | 24A-PM-1007-03 | 24A | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9684806250183 40.7858776210151) | 19 | 4 | 19 | 13 | ||||||
1796 | 1796 | -73.9765355395622 | 40.7735653237366 | 8B-AM-1007-03 | 08B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97653553956222 40.7735653237366) | 19 | 4 | 19 | 13 | ||||||
1899 | 1899 | -73.9764314091366 | 40.7736458057952 | 8B-AM-1007-02 | 08B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9764314091366 40.773645805795205) | 19 | 4 | 19 | 13 | ||||||
1998 | 1998 | -73.9595686513629 | 40.7906859748696 | 32E-AM-1007-06 | 32E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9595686513629 40.7906859748696) | 19 | 4 | 19 | 13 | ||||||
2167 | 2167 | -73.9799594281222 | 40.7701978146968 | 4A-AM-1007-05 | 04A | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9799594281222 40.7701978146968) | 19 | 4 | 19 | 13 | ||||||
2227 | 2227 | -73.9792814244424 | 40.770503194056 | 4A-AM-1007-04 | 04A | AM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9792814244424 40.770503194056) | 19 | 4 | 19 | 13 | ||||||
2230 | 2230 | -73.9730813162152 | 40.7779315720879 | 14B-AM-1007-02 | 14B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9730813162152 40.7779315720879) | 19 | 4 | 19 | 13 | ||||||
2238 | 2238 | -73.9536198726174 | 40.7980135102228 | 41E-AM-1007-03 | 41E | AM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9536198726174 40.7980135102228) | 19 | 4 | 19 | 13 | ||||||
2248 | 2248 | -73.9766477027266 | 40.7712737417779 | 6C-AM-1007-04 | 06C | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | true | true | false | false | chasing #5 | false | false | false | false | false | false | true | false | POINT (-73.9766477027266 40.7712737417779) | 19 | 4 | 19 | 13 | |||||
2356 | 2356 | -73.9611355303487 | 40.793069353224 | 34C-AM-1007-02 | 34C | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611355303487 40.793069353224) | 19 | 4 | 19 | 13 | ||||||
2359 | 2359 | -73.9700785314537 | 40.777714111862 | 15D-AM-1007-01 | 15D | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9700785314537 40.777714111862) | 19 | 4 | 19 | 13 | ||||||
2360 | 2360 | -73.9573325001041 | 40.7874662104558 | 30H-AM-1007-01 | 30H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9573325001041 40.7874662104558) | 19 | 4 | 19 | 13 | ||||||
2402 | 2402 | -73.9777206733344 | 40.7668595585487 | 1D-PM-1007-07 | 01D | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | lying down | false | false | false | false | false | false | true | false | POINT (-73.9777206733344 40.7668595585487) | 19 | 4 | 19 | 13 | |||||
2436 | 2436 | -73.95827701417 | 40.7856610238891 | 28I-PM-1007-01 | 28I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.95827701417 40.7856610238891) | 19 | 4 | 19 | 13 | ||||||
2440 | 2440 | -73.9673803508629 | 40.7785245025508 | 17F-AM-1007-01 | 17F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | true | false | false | true | false | POINT (-73.9673803508629 40.7785245025508) | 19 | 4 | 19 | 13 | ||||||
2486 | 2486 | -73.9766317094163 | 40.7734230472026 | 8B-AM-1007-05 | 08B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9766317094163 40.7734230472026) | 19 | 4 | 19 | 13 | ||||||
2670 | 2670 | -73.9531041906469 | 40.7919916819219 | 36I-PM-1007-02 | 36I | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | true | true | true | false | chased birds (blue jay) | POINT (-73.9531041906469 40.7919916819219) | 19 | 4 | 19 | 13 | |||||
2686 | 2686 | -73.9775571403892 | 40.7665316585198 | 1E-PM-1007-03 | 01E | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9775571403892 40.7665316585198) | 19 | 4 | 19 | 13 | ||||||
2791 | 2791 | -73.9593624259363 | 40.7905522356793 | 32E-AM-1007-02 | 32E | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9593624259363 40.7905522356793) | 19 | 4 | 19 | 13 | ||||||
2859 | 2859 | -73.9786940945874 | 40.7690820276888 | 3B-PM-1007-05 | 03B | PM | 10072018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 6 | on rock | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9786940945874 40.7690820276888) | 19 | 4 | 19 | 13 | |||||
2990 | 2990 | -73.9766012108307 | 40.7712310725379 | 6C-AM-1007-05 | 06C | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | true | true | false | false | chasing #4 | false | false | false | false | false | false | true | false | POINT (-73.9766012108307 40.7712310725379) | 19 | 4 | 19 | 13 | |||||
1217 | 1217 | -73.9764850086767 | 40.7737340720562 | 8B-AM-1007-07 | 08B | AM | 10072018 | 7 | Juvenile | Gray | Black | Gray+Black | Above Ground | 8 | false | false | false | true | false | holding nut | false | false | false | false | false | false | true | false | POINT (-73.9764850086767 40.7737340720562) | 19 | 4 | 19 | 13 | ||||
1969 | 1969 | -73.9689051473072 | 40.7764511282884 | 14F-AM-1007-04 | 14F | AM | 10072018 | 4 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689051473072 40.7764511282884) | 19 | 4 | 19 | 13 | |||||
2208 | 2208 | -73.9614972757332 | 40.7921404951324 | 33C-PM-1007-02 | 33C | PM | 10072018 | 2 | Adult | Gray | Black, White | Gray+Black, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9614972757332 40.7921404951324) | 19 | 4 | 19 | 13 | |||||
18 | 18 | -73.9532170504865 | 40.7919669739962 | 36I-PM-1007-01 | 36I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9532170504865 40.7919669739962) | 19 | 4 | 19 | 13 | |||||
38 | 38 | -73.9742073452913 | 40.7757957380463 | 12B-AM-1007-01 | 12B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9742073452913 40.7757957380463) | 19 | 4 | 19 | 13 | |||||
57 | 57 | -73.9690175838534 | 40.7760432720017 | 14F-AM-1007-05 | 14F | AM | 10072018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9690175838534 40.7760432720017) | 19 | 4 | 19 | 13 | |||||
65 | 65 | -73.9741824992294 | 40.7689486657963 | 5F-PM-1007-03 | 05F | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | hiding nut | false | false | false | false | true | false | true | false | POINT (-73.9741824992294 40.7689486657963) | 19 | 4 | 19 | 13 | ||||
94 | 94 | -73.9641971813967 | 40.7813537959435 | 21G-PM-1007-01 | 21G | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9641971813967 40.7813537959435) | 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 | |||||
132 | 132 | -73.9696433533986 | 40.7828208083804 | 20B-AM-1007-01 | 20B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | quietly | false | false | false | false | false | false | true | false | POINT (-73.9696433533986 40.7828208083804) | 19 | 4 | 19 | 13 | ||||
161 | 161 | -73.9649632550828 | 40.7809187761995 | 20F-PM-1007-01 | 20F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9649632550828 40.7809187761995) | 19 | 4 | 19 | 13 | ||||
190 | 190 | -73.9695507965155 | 40.7743070423435 | 12F-PM-1007-04 | 12F | PM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | stared | POINT (-73.96955079651552 40.7743070423435) | 19 | 4 | 19 | 13 | ||||
234 | 234 | -73.9741401377844 | 40.7758134257881 | 12B-AM-1007-02 | 12B | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9741401377844 40.7758134257881) | 19 | 4 | 19 | 13 | |||||
304 | 304 | -73.9523001834395 | 40.7949231000186 | 39H-AM-1007-02 | 39H | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9523001834395 40.7949231000186) | 19 | 4 | 19 | 13 | |||||
398 | 398 | -73.9686737866872 | 40.7739714023732 | 12G-PM-1007-06 | 12G | PM | 10072018 | 6 | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686737866872 40.7739714023732) | 19 | 4 | 19 | 13 | ||||||||
444 | 444 | -73.9641462360541 | 40.7778316005464 | 18I-PM-1007-09 | 18I | PM | 10072018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | canoodling w/ 8 | false | false | false | false | false | false | true | false | POINT (-73.9641462360541 40.7778316005464) | 19 | 4 | 19 | 13 | ||||
446 | 446 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | mushroom | false | false | false | false | false | false | true | false | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
484 | 484 | -73.9666526554772 | 40.7756111718355 | 14H-AM-1007-02 | 14H | AM | 10072018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9666526554772 40.77561117183551) | 19 | 4 | 19 | 13 | ||||
505 | 505 | -73.9677387336667 | 40.7742695912 | 12H-PM-1007-02 | 12H | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | false | false | true | true | false | peanuts | false | false | false | false | false | false | true | false | POINT (-73.9677387336667 40.7742695912) | 19 | 4 | 19 | 13 | |||
553 | 553 | -73.9638526062093 | 40.782693848993 | 22F-AM-1007-02 | 22F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | standing | false | false | false | false | false | false | true | false | POINT (-73.9638526062093 40.782693848993) | 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 );