This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, 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, Foraging, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, Runs from, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193 | 193 | -73.9537691298752 | 40.7941272599797 | 38G-PM-1020-01 | 38G | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9537691298752 40.7941272599797) | 19 | 4 | 19 | 13 | |||||
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
241 | 241 | -73.9760256477558 | 40.7703573131398 | 5D-AM-1020-02 | 05D | AM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | small jumps | false | false | false | false | false | false | false | false | POINT (-73.9760256477558 40.7703573131398) | 19 | 4 | 19 | 13 | ||||
264 | 264 | -73.9698714743386 | 40.7743814661685 | 12F-AM-1020-02 | 12F | AM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9698714743386 40.7743814661685) | 19 | 4 | 19 | 13 | ||||||
316 | 316 | -73.9540616660191 | 40.7951556603245 | 38G-PM-1020-10 | 38G | PM | 10202018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9540616660191 40.7951556603245) | 19 | 4 | 19 | 13 | |||||
337 | 337 | -73.9583101927652 | 40.7852649316039 | 27I-PM-1020-05 | 27I | PM | 10202018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | In tree | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (us) | POINT (-73.9583101927652 40.7852649316039) | 19 | 4 | 19 | 13 | |||
356 | 356 | -73.9761036400144 | 40.7705482684594 | 6D-PM-1020-03 | 06D | PM | 10202018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9761036400144 40.7705482684594) | 19 | 4 | 19 | 13 | ||||||
477 | 477 | -73.9701481200298 | 40.7751110354034 | 12F-AM-1020-06 | 12F | AM | 10202018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701481200298 40.7751110354034) | 19 | 4 | 19 | 13 | |||||
984 | 984 | -73.9672950266018 | 40.7782477517567 | 17F-PM-1020-01 | 17F | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9672950266018 40.7782477517567) | 19 | 4 | 19 | 13 | |||||
1047 | 1047 | -73.9580111056675 | 40.7854339401483 | 27I-PM-1020-02 | 27I | PM | 10202018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9580111056675 40.7854339401483) | 19 | 4 | 19 | 13 | |||||
1077 | 1077 | -73.9541837143178 | 40.7944340477396 | 38G-PM-1020-06 | 38G | PM | 10202018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | true | false | false | false | false | false | true | POINT (-73.9541837143178 40.7944340477396) | 19 | 4 | 19 | 13 | |||||
1263 | 1263 | -73.9770873939997 | 40.7710379662106 | 6C-PM-1020-02 | 06C | PM | 10202018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9770873939997 40.7710379662106) | 19 | 4 | 19 | 13 | ||||||
1377 | 1377 | -73.9752263564287 | 40.772084917017 | 7C-PM-1020-02 | 07C | PM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9752263564287 40.772084917017) | 19 | 4 | 19 | 13 | ||||||
1476 | 1476 | -73.976609486498 | 40.7717832922535 | 7C-PM-1020-04 | 07C | PM | 10202018 | 4 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.976609486498 40.7717832922535) | 19 | 4 | 19 | 13 | ||||||
1629 | 1629 | -73.9759428006237 | 40.7715081817329 | 7C-PM-1020-06 | 07C | PM | 10202018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9759428006237 40.7715081817329) | 19 | 4 | 19 | 13 | ||||||
1657 | 1657 | -73.9768254058709 | 40.7716757945251 | 6C-PM-1020-03 | 06C | PM | 10202018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9768254058709 40.7716757945251) | 19 | 4 | 19 | 13 | ||||||
1755 | 1755 | -73.9714798196777 | 40.7695231949631 | 6H-PM-1020-02 | 06H | PM | 10202018 | 2 | Adult | + | Above Ground | Fence pole | false | false | true | false | false | false | false | false | false | false | false | false | true | runs from (me) | POINT (-73.9714798196777 40.7695231949631) | 19 | 4 | 19 | 13 | ||||||
1888 | 1888 | -73.9673919075839 | 40.7786845769177 | 17F-PM-1020-05 | 17F | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9673919075839 40.7786845769177) | 19 | 4 | 19 | 13 | ||||||
2024 | 2024 | -73.9722472286151 | 40.7699550476176 | 6G-PM-1020-04 | 06G | PM | 10202018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9722472286151 40.7699550476176) | 19 | 4 | 19 | 13 | ||||||
2088 | 2088 | -73.9651155880346 | 40.790694632578 | 30A-PM-1020-01 | 30A | PM | 10202018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9651155880346 40.790694632578) | 19 | 4 | 19 | 13 | |||||
2131 | 2131 | -73.9752225195115 | 40.7703747669865 | 6D-PM-1020-05 | 06D | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9752225195115 40.7703747669865) | 19 | 4 | 19 | 13 | ||||||
2162 | 2162 | -73.9583300280173 | 40.7853495002675 | 27I-PM-1020-04 | 27I | PM | 10202018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9583300280173 40.7853495002675) | 19 | 4 | 19 | 13 | ||||||
2399 | 2399 | -73.9583762071264 | 40.7852226065643 | 27I-PM-1020-03 | 27I | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | false | begging for food; on hind legs | POINT (-73.9583762071264 40.7852226065643) | 19 | 4 | 19 | 13 | ||||
2453 | 2453 | -73.9756105226696 | 40.7696531972655 | 5D-AM-1020-03 | 05D | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9756105226696 40.7696531972655) | 19 | 4 | 19 | 13 | |||||
2550 | 2550 | -73.9694805745522 | 40.7743556902843 | 12F-AM-1020-01 | 12F | AM | 10202018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 17 | Tree | false | false | false | false | false | jumping | false | false | false | false | false | false | false | false | POINT (-73.9694805745522 40.7743556902843) | 19 | 4 | 19 | 13 | |||
2560 | 2560 | -73.9755459090534 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 10202018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | false | chillin' | false | false | false | false | false | false | false | true | POINT (-73.9755459090534 40.7680866624003) | 19 | 4 | 19 | 13 | ||||
2592 | 2592 | -73.9758128509653 | 40.7715946097064 | 7C-PM-1020-03 | 07C | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9758128509653 40.7715946097064) | 19 | 4 | 19 | 13 | |||||
2883 | 2883 | -73.9698592838836 | 40.7743071443959 | 12F-AM-1020-03 | 12F | AM | 10202018 | 3 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | false | playing | false | false | false | false | true | false | false | false | POINT (-73.9698592838836 40.7743071443959) | 19 | 4 | 19 | 13 | ||||
3016 | 3016 | -73.9756457597888 | 40.7703559775625 | 6D-PM-1020-02 | 06D | PM | 10202018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9756457597888 40.7703559775625) | 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 );