This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail twitches
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
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 | |||||||
2739 | 2739 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 10102018 | 2 | Cinnamon | Gray | Cinnamon+Gray | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9681960138614 40.7726867422002) | 19 | 4 | 19 | 13 | ||||||||
2836 | 2836 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 10172018 | 3 | Gray | Cinnamon | Gray+Cinnamon | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
12 | 12 | -73.9683613516225 | 40.7725908847499 | 11H-AM-1010-03 | 11H | AM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9683613516225 40.7725908847499) | 19 | 4 | 19 | 13 | |||||||
64 | 64 | -73.9595002339508 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 10172018 | 13 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9595002339508 40.7903365788694) | 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 | |||||||
280 | 280 | -73.9587401274261 | 40.7960322222949 | 37C-PM-1013-03 | 37C | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9587401274261 40.7960322222949) | 19 | 4 | 19 | 13 | |||||||
458 | 458 | -73.9735750352959 | 40.7694500333777 | 6F-PM-1008-06 | 06F | PM | 10082018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | White patches. Almost looks like fox squirrel | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9735750352959 40.7694500333777) | 19 | 4 | 19 | 13 | ||||||
571 | 571 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9659549963516 40.7833659689194) | 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 | |||||||
1091 | 1091 | -73.97055600791 | 40.7698499183436 | 7H-AM-1006-07 | 07H | AM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.97055600791 40.7698499183436) | 19 | 4 | 19 | 13 | |||||||
1323 | 1323 | -73.9744387347626 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744387347626 40.7776953143835) | 19 | 4 | 19 | 13 | ||||||||
1405 | 1405 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9589371550945 40.7959812504467) | 19 | 4 | 19 | 13 | |||||||
1786 | 1786 | -73.9709407456459 | 40.776423522087 | 14D-AM-1014-13 | 14D | AM | 10142018 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9709407456459 40.776423522087) | 19 | 4 | 19 | 13 | |||||||
1878 | 1878 | -73.9761223919286 | 40.7685998275864 | 4E-PM-1008-06 | 04E | PM | 10082018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9761223919286 40.7685998275864) | 19 | 4 | 19 | 13 | |||||||
1988 | 1988 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | true | true | true | false | false | chasing (#4),digging | false | false | false | false | true | false | true | false | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
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 | |||||||||
2039 | 2039 | -73.9708371806429 | 40.7764813666684 | 14D-AM-1014-14 | 14D | AM | 10142018 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9708371806429 40.7764813666684) | 19 | 4 | 19 | 13 | |||||||
2631 | 2631 | -73.9690080105286 | 40.7710230515054 | 9I-PM-1010-03 | 09I | PM | 10102018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9690080105286 40.7710230515054) | 19 | 4 | 19 | 13 | |||||||
2737 | 2737 | -73.9703683510176 | 40.7743975363958 | 12F-PM-1007-10 | 12F | PM | 10072018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9703683510176 40.7743975363958) | 19 | 4 | 19 | 13 | |||||||
2787 | 2787 | -73.9765306970303 | 40.7694956875859 | 4D-PM-1008-09 | 04D | PM | 10082018 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9765306970303 40.7694956875859) | 19 | 4 | 19 | 13 | |||||||
2797 | 2797 | -73.9576913492669 | 40.7994216061391 | 41B-AM-1010-11 | 41B | AM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | eating a mushroom! | false | false | false | false | false | false | true | false | POINT (-73.9576913492669 40.7994216061391) | 19 | 4 | 19 | 13 | ||||||
2866 | 2866 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 10172018 | 4 | Adult | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
2918 | 2918 | -73.9745152462626 | 40.7655415515908 | 1G-AM-1006-04 | 01G | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | false | true | false | false | true | collecting nest material | false | false | false | false | true | false | true | false | POINT (-73.9745152462626 40.76554155159081) | 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 | |||||||
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 |
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 );