This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions
Link | rowid | Longitude | Latitude | Unique Squirrel ID | Hectare | Shift | Date | Hectare Squirrel Number | Age | Primary Fur Color | Highlight Fur Color | Combination of Primary and Highlight Color | Color notes | Location | Above Ground Sighter Measurement | Specific Location | Running | Chasing | Climbing | Eating | Foraging | Other Activities ▼ | Kuks | Quaas | Moans | Tail flags | Tail twitches | Approaches | Indifferent | Runs from | Other Interactions | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126 | 126 | -73.9792155473689 | 40.7693711799946 | 3B-PM-1007-11 | 03B | PM | 10072018 | 11 | Adult | Gray | Gray+ | Above Ground | 5 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792155473689 40.7693711799946) | 19 | 4 | 19 | 13 | |||||
183 | 183 | -73.9768434635084 | 40.7728494038744 | 7B-AM-1008-11 | 07B | AM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9768434635084 40.7728494038744) | 19 | 4 | 19 | 13 | ||||||
281 | 281 | -73.9619411917909 | 40.7923536640283 | 33B-PM-1010-11 | 33B | PM | 10102018 | 11 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9619411917909 40.7923536640283) | 19 | 4 | 19 | 13 | ||||||
366 | 366 | -73.9673548527075 | 40.7765669058396 | 15G-PM-1019-11 | 15G | PM | 10192018 | 11 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673548527075 40.7765669058396) | 19 | 4 | 19 | 13 | |||||
390 | 390 | -73.970720187655 | 40.7774564799983 | 14D-PM-1019-11 | 14D | PM | 10192018 | 11 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.970720187655 40.7774564799983) | 19 | 4 | 19 | 13 | ||||||||
435 | 435 | -73.9702963056917 | 40.7697928730791 | 7H-AM-1006-11 | 07H | AM | 10062018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9702963056917 40.7697928730791) | 19 | 4 | 19 | 13 | |||||
596 | 596 | -73.9769319450348 | 40.7743883576247 | 9A-AM-1013-11 | 09A | AM | 10132018 | 11 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | foot of tree | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9769319450348 40.7743883576247) | 19 | 4 | 19 | 13 | ||||
625 | 625 | -73.9764235373322 | 40.770606513989 | 5C-PM-1010-11 | 05C | PM | 10102018 | 11 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.97642353733221 40.770606513989) | 19 | 4 | 19 | 13 | |||||
678 | 678 | -73.977447585355 | 40.7697167828003 | 4C-PM-1010-11 | 04C | PM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.977447585355 40.7697167828003) | 19 | 4 | 19 | 13 | |||||
734 | 734 | -73.9714921188372 | 40.776758371867 | 14D-AM-1014-11 | 14D | AM | 10142018 | 11 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714921188372 40.776758371867) | 19 | 4 | 19 | 13 | |||||
952 | 952 | -73.9699763667769 | 40.7757060731026 | 13E-PM-1008-11 | 13E | PM | 10082018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699763667769 40.775706073102604) | 19 | 4 | 19 | 13 | |||||
1016 | 1016 | -73.9691293546408 | 40.7703219076549 | 8I-AM-1006-11 | 08I | AM | 10062018 | 11 | Adult | Gray | Gray+ | Above Ground | 50 | tree | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691293546408 40.77032190765491) | 19 | 4 | 19 | 13 | |||||
1131 | 1131 | -73.9793082679745 | 40.7679930598805 | 2C-PM-1013-11 | 02C | PM | 10132018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9793082679745 40.7679930598805) | 19 | 4 | 19 | 13 | |||||
1229 | 1229 | -73.9677751507448 | 40.7790990066658 | 17E-AM-1017-11 | 17E | AM | 10172018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | Shore | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9677751507448 40.7790990066658) | 19 | 4 | 19 | 13 | |||||
1278 | 1278 | -73.9729848996456 | 40.7707143294261 | 7F-AM-1008-11 | 07F | AM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9729848996456 40.7707143294261) | 19 | 4 | 19 | 13 | ||||||
1344 | 1344 | -73.9618591510932 | 40.7921343738001 | 32C-PM-1013-11 | 32C | PM | 10132018 | 11 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9618591510932 40.7921343738001) | 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 | ||||||
1596 | 1596 | -73.9666945123922 | 40.7839956493194 | 22C-PM-1006-11 | 22C | PM | 10062018 | 11 | Juvenile | Gray | Gray+ | Above Ground | 13 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9666945123922 40.7839956493194) | 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 | ||||||
1787 | 1787 | -73.9720365327715 | 40.7762329714016 | 13D-PM-1018-11 | 13D | PM | 10182018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | false | true | false | true | false | POINT (-73.9720365327715 40.7762329714016) | 19 | 4 | 19 | 13 | |||||
1903 | 1903 | -73.9701379806066 | 40.7785234812393 | 16D-PM-1010-11 | 16D | PM | 10102018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9701379806066 40.7785234812393) | 19 | 4 | 19 | 13 | ||||||
1913 | 1913 | -73.9774630821854 | 40.7680626674086 | 3D-PM-1010-11 | 03D | PM | 10102018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9774630821854 40.76806266740861) | 19 | 4 | 19 | 13 | |||||
1946 | 1946 | -73.9692925815903 | 40.7774506065008 | 15E-PM-1008-11 | 15E | PM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9692925815903 40.7774506065008) | 19 | 4 | 19 | 13 | ||||||
2022 | 2022 | -73.9719583492187 | 40.7763434967164 | 13D-AM-1014-11 | 13D | AM | 10142018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9719583492187 40.7763434967164) | 19 | 4 | 19 | 13 | |||||
2098 | 2098 | -73.9700779726297 | 40.7722086251085 | 10G-AM-1006-11 | 10G | AM | 10062018 | 11 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9700779726297 40.7722086251085) | 19 | 4 | 19 | 13 | ||||||
2236 | 2236 | -73.9597845469964 | 40.7906179303448 | 32E-AM-1007-11 | 32E | AM | 10072018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9597845469964 40.7906179303448) | 19 | 4 | 19 | 13 | ||||||
2348 | 2348 | -73.9531965469704 | 40.7947437983977 | 38G-PM-1020-11 | 38G | PM | 10202018 | 11 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | true | true | false | POINT (-73.9531965469704 40.7947437983977) | 19 | 4 | 19 | 13 | |||||
2376 | 2376 | -73.9594204646985 | 40.7905923765213 | 32E-PM-1017-11 | 32E | PM | 10172018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9594204646985 40.7905923765213) | 19 | 4 | 19 | 13 | ||||||
2653 | 2653 | -73.958932543729 | 40.7913445531266 | 33E-AM-1014-11 | 33E | AM | 10142018 | 11 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.958932543729 40.7913445531266) | 19 | 4 | 19 | 13 | |||||
2751 | 2751 | -73.956289117157 | 40.7953393993803 | 38E-AM-1010-11 | 38E | AM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of the stream | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.956289117157 40.7953393993803) | 19 | 4 | 19 | 13 | ||||
2760 | 2760 | -73.9701808122548 | 40.7744632730919 | 12F-PM-1007-11 | 12F | PM | 10072018 | 11 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9701808122548 40.7744632730919) | 19 | 4 | 19 | 13 | |||||
2868 | 2868 | -73.9653873284496 | 40.7804699882574 | 20F-PM-1007-11 | 20F | PM | 10072018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9653873284496 40.7804699882574) | 19 | 4 | 19 | 13 | ||||
2665 | 2665 | -73.969784066769 | 40.7766940405403 | 14E-AM-1008-11 | 14E | AM | 10082018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | burying | false | false | false | false | false | false | true | false | curious | POINT (-73.969784066769 40.7766940405403) | 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 | ||||||
1001 | 1001 | -73.9801985977846 | 40.7680159511705 | 1B-AM-1012-11 | 01B | AM | 10122018 | 11 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | fighting w/ pigeons | false | false | false | false | false | false | true | false | POINT (-73.9801985977846 40.7680159511705) | 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 );