This data as json, CSV (advanced)
Suggested facets: Hectare, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21 | 21 | -73.9703781726172 | 40.7787526130321 | 16C-PM-1018-03 | 16C | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9703781726172 40.7787526130321) | 19 | 4 | 19 | 13 | |||||
330 | 330 | -73.9708969246276 | 40.7767695507462 | 14D-AM-1014-03 | 14D | AM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9708969246276 40.7767695507462) | 19 | 4 | 19 | 13 | |||||
714 | 714 | -73.9691585756191 | 40.776340465695 | 14F-AM-1007-03 | 14F | AM | 10072018 | 3 | 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.9691585756191 40.776340465695) | 19 | 4 | 19 | 13 | |||||
728 | 728 | -73.9602913105578 | 40.7910635810038 | 32D-PM-1006-03 | 32D | PM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9602913105578 40.7910635810038) | 19 | 4 | 19 | 13 | |||||
961 | 961 | -73.9731457102903 | 40.7660255393205 | 2H-AM-1006-03 | 02H | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9731457102903 40.7660255393205) | 19 | 4 | 19 | 13 | |||||
1024 | 1024 | -73.9521514669041 | 40.7949515182825 | 39H-PM-1013-03 | 39H | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | true | true | POINT (-73.9521514669041 40.7949515182825) | 19 | 4 | 19 | 13 | |||||
1068 | 1068 | -73.96660639702 | 40.7756655031741 | 14H-AM-1007-03 | 14H | AM | 10072018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.96660639702002 40.7756655031741) | 19 | 4 | 19 | 13 | |||||
1242 | 1242 | -73.9714512125212 | 40.7760275250114 | 13D-PM-1018-03 | 13D | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9714512125212 40.7760275250114) | 19 | 4 | 19 | 13 | ||||
1681 | 1681 | -73.9638141923763 | 40.7829225326288 | 23F-PM-1013-03 | 23F | PM | 10132018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | indifferent (noticed me,busy eating,foraging) | POINT (-73.9638141923763 40.7829225326288) | 19 | 4 | 19 | 13 | ||||
1863 | 1863 | -73.9682830510954 | 40.7810151087286 | 19D-PM-1008-03 | 19D | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | may be same squirrel as #1 - male | Above Ground | 5 | on branch of dead tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9682830510954 40.7810151087286) | 19 | 4 | 19 | 13 | |||
2091 | 2091 | -73.9676112864286 | 40.7772792086081 | 16F-AM-1008-03 | 16F | AM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | road | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9676112864286 40.7772792086081) | 19 | 4 | 19 | 13 | ||||
2211 | 2211 | -73.9799250782277 | 40.7676106598889 | 1B-AM-1012-03 | 01B | AM | 10122018 | 3 | 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.97992507822771 40.7676106598889) | 19 | 4 | 19 | 13 | |||||
2471 | 2471 | -73.964274290774 | 40.7795319556023 | 19H-AM-1010-03 | 19H | AM | 10102018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | ran from human w/ dog | POINT (-73.964274290774 40.7795319556023) | 19 | 4 | 19 | 13 | ||||
2485 | 2485 | -73.9584950620879 | 40.7902770710643 | 32F-PM-1008-03 | 32F | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584950620879 40.7902770710643) | 19 | 4 | 19 | 13 | |||||
2589 | 2589 | -73.9694166642262 | 40.7697788641081 | 8I-PM-1013-03 | 08I | PM | 10132018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694166642262 40.7697788641081) | 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 | |||||||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670432105975 40.7753462013506) | 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 | ||||
3013 | 3013 | -73.964661337306 | 40.7769785494935 | 17I-AM-1014-03 | 17I | AM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon face | Above Ground | 10 | false | false | true | false | false | climbing (dog barked & it ran up tree) | false | false | false | false | false | false | true | false | POINT (-73.964661337306 40.7769785494935) | 19 | 4 | 19 | 13 | |||
1686 | 1686 | -73.9593373093799 | 40.7982428507976 | 39A-PM-1014-03 | 39A | PM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. | Above Ground | 6 | Jumped from ground onto branch | false | false | false | false | true | digging? | false | false | false | false | true | false | true | false | POINT (-73.95933730937992 40.7982428507976) | 19 | 4 | 19 | 13 | ||
2480 | 2480 | -73.9546780963388 | 40.7903216522111 | 34I-AM-1012-03 | 34I | AM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | false | nut in mouth | false | false | false | false | false | false | true | false | POINT (-73.9546780963388 40.7903216522111) | 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 );