This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Other Interactions
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 87 | -73.9541453465817 | 40.7982162223764 | 42E-PM-1012-06 | 42E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9541453465817 40.79821622237641) | 19 | 4 | 19 | 13 | |||||
151 | 151 | -73.9714789136757 | 40.7694886645194 | 6H-AM-1008-01 | 06H | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9714789136757 40.7694886645194) | 19 | 4 | 19 | 13 | |||||
188 | 188 | -73.9570528770427 | 40.7990973804149 | 41B-AM-1010-07 | 41B | AM | 10102018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | false | false | false | false | false | true | false | false | true | false | true | false | false | mad! | POINT (-73.9570528770427 40.7990973804149) | 19 | 4 | 19 | 13 | ||||
233 | 233 | -73.9568343093228 | 40.7949401350882 | 37E-PM-1006-04 | 37E | PM | 10062018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | doesn't see me | POINT (-73.9568343093228 40.7949401350882) | 19 | 4 | 19 | 13 | ||||
813 | 813 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9758959798289 40.7694125671679) | 19 | 4 | 19 | 13 | |||||
925 | 925 | -73.9763116425885 | 40.7688839576487 | 4D-PM-1008-03 | 04D | PM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | 19 | 4 | 19 | 13 | ||||
982 | 982 | -73.9676424599715 | 40.7777766106807 | 16F-AM-1008-01 | 16F | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | near fence | false | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9676424599715 40.7777766106807) | 19 | 4 | 19 | 13 | ||||
1345 | 1345 | -73.9581326554206 | 40.7918074743129 | 34E-PM-1006-02 | 34E | PM | 10062018 | 2 | Juvenile | Black | Gray, White | Black+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9581326554206 40.7918074743129) | 19 | 4 | 19 | 13 | |||||
1412 | 1412 | -73.9594676326588 | 40.7984457363388 | 39A-AM-1013-01 | 39A | AM | 10132018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9594676326588 40.7984457363388) | 19 | 4 | 19 | 13 | |||||
1572 | 1572 | -73.9540197079615 | 40.798039260983 | 41E-PM-1013-03 | 41E | PM | 10132018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray on legs | Above Ground | 20 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540197079615 40.798039260983) | 19 | 4 | 19 | 13 | ||||
1683 | 1683 | -73.9790889008147 | 40.7676402781925 | 1C-PM-1013-01 | 01C | PM | 10132018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | true | false | false | POINT (-73.9790889008147 40.7676402781925) | 19 | 4 | 19 | 13 | |||||
1871 | 1871 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | oak tree at end of ramp from Chess House | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9748367344424 40.7693513000034) | 19 | 4 | 19 | 13 | ||||
1947 | 1947 | -73.9747175419546 | 40.7692820030878 | 5E-PM-1012-05 | 05E | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | begging | POINT (-73.9747175419546 40.7692820030878) | 19 | 4 | 19 | 13 | ||||
2152 | 2152 | -73.9686925781295 | 40.7705688673142 | 9I-PM-1010-05 | 09I | PM | 10102018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9686925781295 40.7705688673142) | 19 | 4 | 19 | 13 | |||||
2194 | 2194 | -73.960898739757 | 40.7961393097144 | 37A-PM-1013-02 | 37A | PM | 10132018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.960898739757 40.7961393097144) | 19 | 4 | 19 | 13 | |||||
2455 | 2455 | -73.9577297187155 | 40.799225295679 | 41B-AM-1010-08 | 41B | AM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 20 | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9577297187155 40.799225295679) | 19 | 4 | 19 | 13 | |||||
2574 | 2574 | -73.978199543688 | 40.7695660563362 | 4C-PM-1010-17 | 04C | PM | 10102018 | 17 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | climbed up tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.978199543688 40.7695660563362) | 19 | 4 | 19 | 13 | ||||
2595 | 2595 | -73.9692676659807 | 40.7700678919108 | 8I-PM-1013-08 | 08I | PM | 10132018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.96926766598071 40.7700678919108) | 19 | 4 | 19 | 13 | |||||
2647 | 2647 | -73.954499539822 | 40.7949716693686 | 38F-AM-1018-01 | 38F | AM | 10182018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.954499539822 40.7949716693686) | 19 | 4 | 19 | 13 | |||||
2735 | 2735 | -73.9768096953647 | 40.7708185213129 | 5C-PM-1010-08 | 05C | PM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768096953647 40.7708185213129) | 19 | 4 | 19 | 13 | |||||
2895 | 2895 | -73.9747873899653 | 40.7731945258327 | 9C-PM-1006-04 | 09C | PM | 10062018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9747873899653 40.7731945258327) | 19 | 4 | 19 | 13 | |||||
2965 | 2965 | -73.9767389132988 | 40.7689323691424 | 4D-PM-1008-10 | 04D | PM | 10082018 | 10 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 6 | climbed the fence & posed for a picture | false | false | true | false | true | false | false | false | false | false | true | false | false | POINT (-73.9767389132988 40.7689323691424) | 19 | 4 | 19 | 13 | ||||
2989 | 2989 | -73.9643538221947 | 40.7917565604735 | 31A-PM-1017-01 | 31A | PM | 10172018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9643538221947 40.7917565604735) | 19 | 4 | 19 | 13 | ||||
3023 | 3023 | -73.9754794191553 | 40.7696404489025 | 5E-PM-1012-01 | 05E | PM | 10122018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9754794191553 40.7696404489025) | 19 | 4 | 19 | 13 | |||||
150 | 150 | -73.9763430829342 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | false | true | false | false | false | chased #12 | true | false | false | true | false | false | false | true | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
303 | 303 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 10082018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | true | true | climbed fence staring at me - went up tree | false | false | false | false | false | false | false | true | POINT (-73.97623482246482 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
2976 | 2976 | -73.9724083320538 | 40.7744163768061 | 11D-AM-1010-08 | 11D | AM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | drinking | false | false | false | false | false | true | false | false | POINT (-73.9724083320538 40.7744163768061) | 19 | 4 | 19 | 13 | ||||
1165 | 1165 | -73.9689504114652 | 40.7766770153764 | 14F-PM-1012-05 | 14F | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2 | on a fallen branch | true | false | false | true | false | sitting | false | false | false | false | false | false | false | false | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
2330 | 2330 | -73.9724618533895 | 40.7745021602455 | 11D-AM-1010-02 | 11D | AM | 10102018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | walking | false | false | false | false | true | false | false | true | POINT (-73.9724618533895 40.7745021602455) | 19 | 4 | 19 | 13 | ||||
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | true | false | false | false | false | was chased by # 11 | true | false | false | false | false | false | false | true | POINT (-73.9763236949008 40.7686815615335) | 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 );