This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Other Activities, Tail flags, Approaches, Indifferent, Runs from, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27 | 27 | -73.9670628558161 | 40.7734991420941 | 12I-AM-1013-01 | 12I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on tree roots | false | false | false | false | false | sitting | false | false | false | false | true | false | false | true | POINT (-73.9670628558161 40.77349914209411) | 19 | 4 | 19 | 13 | |||
58 | 58 | -73.9704082821356 | 40.7690280985956 | 6I-PM-1013-06 | 06I | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | playing with #5 | false | false | false | false | true | false | false | false | POINT (-73.9704082821356 40.7690280985956) | 19 | 4 | 19 | 13 | ||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
361 | 361 | -73.9614824437251 | 40.7912929799884 | 32C-PM-1013-03 | 32C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9614824437251 40.7912929799884) | 19 | 4 | 19 | 13 | ||||||
567 | 567 | -73.9756972647636 | 40.773624164826 | 9B-PM-1013-04 | 09B | PM | 10132018 | 4 | Juvenile | Gray | Black | Gray+Black | Above Ground | 30 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9756972647636 40.773624164826) | 19 | 4 | 19 | 13 | |||||
622 | 622 | -73.9754836796706 | 40.7738879545412 | 9B-PM-1013-01 | 09B | PM | 10132018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | playing | false | false | false | false | true | false | true | false | POINT (-73.9754836796706 40.7738879545412) | 19 | 4 | 19 | 13 | ||||
628 | 628 | -73.9600165785486 | 40.7952466761832 | 36B-PM-1013-03 | 36B | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9600165785486 40.7952466761832) | 19 | 4 | 19 | 13 | |||||
856 | 856 | -73.9591667162801 | 40.7937602121568 | 35D-PM-1013-07 | 35D | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Above Ground | 12 | tree | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.95916671628011 40.7937602121568) | 19 | 4 | 19 | 13 | ||||
979 | 979 | -73.9612349421547 | 40.7959586475744 | 36A-PM-1013-09 | 36A | PM | 10132018 | 9 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9612349421547 40.7959586475744) | 19 | 4 | 19 | 13 | ||||||
1157 | 1157 | -73.9704449096084 | 40.7689970778303 | 6I-PM-1013-05 | 06I | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | playing with #6 | false | false | false | false | true | false | false | false | POINT (-73.9704449096084 40.7689970778303) | 19 | 4 | 19 | 13 | ||||
1188 | 1188 | -73.9669529835992 | 40.7871864151365 | 25A-AM-1013-05 | 25A | AM | 10132018 | 5 | Gray | Gray+ | Ground Plane | FALSE | CROSS BRIDLE - INTO TREE TO AVOID DOGGO | true | false | true | false | false | d.p.t. | false | false | false | true | true | false | true | false | calm | POINT (-73.96695298359921 40.7871864151365) | 19 | 4 | 19 | 13 | ||||
1202 | 1202 | -73.9694979297007 | 40.7694667408721 | 7I-PM-1013-02 | 07I | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Construction materials | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9694979297007 40.7694667408721) | 19 | 4 | 19 | 13 | ||||
1296 | 1296 | -73.9705509170542 | 40.7689416540228 | 6I-PM-1013-04 | 06I | PM | 10132018 | 4 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Grass | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9705509170542 40.7689416540228) | 19 | 4 | 19 | 13 | ||||
1553 | 1553 | -73.9690645326017 | 40.7773822116124 | 15E-AM-1013-03 | 15E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | on fallen log | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9690645326017 40.7773822116124) | 19 | 4 | 19 | 13 | |||||
1585 | 1585 | -73.9611312355348 | 40.7950130863913 | 36A-PM-1013-04 | 36A | PM | 10132018 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | ON ROCK NEAR POND | false | false | false | false | false | sitting | false | false | false | false | true | false | true | false | POINT (-73.9611312355348 40.7950130863913) | 19 | 4 | 19 | 13 | ||||
1797 | 1797 | -73.9697178096275 | 40.7697036696301 | 7I-PM-1013-07 | 07I | PM | 10132018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | Under the tree | false | true | false | false | false | playing,interacting with #6 | false | false | false | false | true | false | false | false | POINT (-73.9697178096275 40.769703669630104) | 19 | 4 | 19 | 13 | |||
1872 | 1872 | -73.9613998967903 | 40.7912437235667 | 32C-PM-1013-02 | 32C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9613998967903 40.7912437235667) | 19 | 4 | 19 | 13 | ||||||
1894 | 1894 | -73.9699780857298 | 40.7688706046944 | 6I-PM-1013-01 | 06I | PM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9699780857298 40.7688706046944) | 19 | 4 | 19 | 13 | |||||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9540151828782 40.7920066170587) | 19 | 4 | 19 | 13 | ||||
2274 | 2274 | -73.9698044218476 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | false | false | false | true | false | playing,interacting with #7 | false | false | false | false | true | false | false | true | POINT (-73.9698044218476 40.7697007833531) | 19 | 4 | 19 | 13 | |||
2535 | 2535 | -73.9700101107283 | 40.7696729501144 | 7I-PM-1013-08 | 07I | PM | 10132018 | 8 | Adult | Black | Black+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9700101107283 40.7696729501144) | 19 | 4 | 19 | 13 | ||||||
2606 | 2606 | -73.96143417385 | 40.7945464262112 | 35B-PM-1013-02 | 35B | PM | 10132018 | 2 | Juvenile | + | Ground Plane | FALSE | false | false | false | true | false | did not notice dog sitting a few yards away (10-20 ft) | false | false | false | false | true | false | true | false | POINT (-73.96143417385 40.7945464262112) | 19 | 4 | 19 | 13 | ||||||
2683 | 2683 | -73.972179947936 | 40.7810042827198 | 17A-PM-1013-02 | 17A | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | on a little pedestal-shaped part of a tree | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.972179947936 40.7810042827198) | 19 | 4 | 19 | 13 | ||||
2855 | 2855 | -73.9690832219322 | 40.782343340986 | 20B-PM-1013-06 | 20B | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.96908322193221 40.782343340986) | 19 | 4 | 19 | 13 | |||||
859 | 859 | -73.9600964585868 | 40.7952339524416 | 36B-PM-1013-02 | 36B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | true | false | true | POINT (-73.9600964585868 40.7952339524416) | 19 | 4 | 19 | 13 | |||||
1294 | 1294 | -73.9604089940153 | 40.7910028063138 | 32D-AM-1013-04 | 32D | AM | 10132018 | 4 | Adult | Cinnamon | Cinnamon+ | Brown legs | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | true | false | true | POINT (-73.9604089940153 40.7910028063138) | 19 | 4 | 19 | 13 | |||||
2030 | 2030 | -73.9749251267433 | 40.7679111971294 | 4F-PM-1013-01 | 04F | PM | 10132018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9749251267433 40.7679111971294) | 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 );