This data as json, CSV (advanced)
Suggested facets: Hectare, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Foraging, Other Activities, Tail twitches, Approaches, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52 | 52 | -73.9675634326877 | 40.7813477352507 | 19D-AM-1007-01 | 19D | AM | 10072018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | false | fenced off area can't approach | POINT (-73.9675634326877 40.7813477352507) | 19 | 4 | 19 | 13 | |||||
130 | 130 | -73.9581655949437 | 40.7997708190022 | 41A-PM-1007-06 | 41A | PM | 10072018 | 6 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9581655949437 40.7997708190022) | 19 | 4 | 19 | 13 | ||||||
222 | 222 | -73.9770273553525 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | true | true | true | true | false | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
262 | 262 | -73.9712876234172 | 40.7695885530701 | 7H-PM-1006-02 | 07H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | tree | true | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9712876234172 40.7695885530701) | 19 | 4 | 19 | 13 | |||||
373 | 373 | -73.9672127283283 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | true | false | true | true | false | a lot of activity | false | false | false | true | false | false | false | false | POINT (-73.9672127283283 40.7810666805133) | 19 | 4 | 19 | 13 | ||||
461 | 461 | -73.9648195433192 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | staring | false | false | false | false | true | false | false | false | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
511 | 511 | -73.9653142636891 | 40.7760015129298 | 15I-AM-1008-04 | 15I | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653142636891 40.7760015129298) | 19 | 4 | 19 | 13 | ||||||
530 | 530 | -73.9696360756453 | 40.7786545659072 | 16D-PM-1010-03 | 16D | PM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9696360756453 40.7786545659072) | 19 | 4 | 19 | 13 | ||||||
850 | 850 | -73.9642288873015 | 40.7820439983567 | 22F-AM-1007-06 | 22F | AM | 10072018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9642288873015 40.7820439983567) | 19 | 4 | 19 | 13 | ||||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9578924882613 40.789806297824) | 19 | 4 | 19 | 13 | ||||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9790822606486 40.7714466633386) | 19 | 4 | 19 | 13 | ||||||
1240 | 1240 | -73.9696119179789 | 40.7802926111865 | 18C-PM-1018-09 | 18C | PM | 10182018 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5 | false | false | true | true | true | false | false | false | false | false | false | false | false | POINT (-73.9696119179789 40.7802926111865) | 19 | 4 | 19 | 13 | ||||||
1422 | 1422 | -73.9537356145842 | 40.7917273773486 | 35I-PM-1006-02 | 35I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9537356145842 40.7917273773486) | 19 | 4 | 19 | 13 | ||||||
1442 | 1442 | -73.961241953418 | 40.7941677113011 | 35B-PM-1013-07 | 35B | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | true | false | got fed twice by grandpa,grabbed from grass and ate in tree | false | false | false | false | false | true | true | true | approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. | POINT (-73.961241953418 40.7941677113011) | 19 | 4 | 19 | 13 | ||||
1566 | 1566 | -73.9695133370801 | 40.7765009796853 | 14E-AM-1008-16 | 14E | AM | 10082018 | 16 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695133370801 40.7765009796853) | 19 | 4 | 19 | 13 | ||||||
1696 | 1696 | -73.9694591667705 | 40.7766518221998 | 14E-AM-1008-12 | 14E | AM | 10082018 | 12 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694591667705 40.7766518221998) | 19 | 4 | 19 | 13 | ||||||
1701 | 1701 | -73.9701634768603 | 40.7778691433218 | 15D-AM-1007-03 | 15D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9701634768603 40.7778691433218) | 19 | 4 | 19 | 13 | ||||||
1732 | 1732 | -73.9767141407274 | 40.7737313251559 | 8A-PM-1014-02 | 08A | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | runs from (goes up a tree) | POINT (-73.9767141407274 40.7737313251559) | 19 | 4 | 19 | 13 | |||||
1776 | 1776 | -73.9562350820255 | 40.7913464147989 | 34G-PM-1006-02 | 34G | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | true | eating bread it found on ground | false | false | false | false | false | false | false | true | POINT (-73.9562350820255 40.7913464147989) | 19 | 4 | 19 | 13 | |||||
1841 | 1841 | -73.9806377967573 | 40.7681097168268 | 1B-AM-1012-15 | 01B | AM | 10122018 | 15 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9806377967573 40.7681097168268) | 19 | 4 | 19 | 13 | ||||||
1943 | 1943 | -73.9690447463294 | 40.783913304529 | 21B-AM-1019-06 | 21B | AM | 10192018 | 6 | Juvenile | Gray | Gray+ | Above Ground | 7 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9690447463294 40.78391330452901) | 19 | 4 | 19 | 13 | ||||||
2118 | 2118 | -73.958369699409 | 40.7902456668332 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.958369699409 40.7902456668332) | 19 | 4 | 19 | 13 | ||||||
2122 | 2122 | -73.9692946938852 | 40.7767389791452 | 14E-AM-1008-13 | 14E | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | true | false | curious | POINT (-73.9692946938852 40.7767389791452) | 19 | 4 | 19 | 13 | |||||
2154 | 2154 | -73.976716425804 | 40.7736889979965 | 8A-PM-1014-03 | 08A | PM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 23 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.976716425804 40.7736889979965) | 19 | 4 | 19 | 13 | ||||||
2174 | 2174 | -73.9684092812839 | 40.7711445841928 | 9I-AM-1014-07 | 09I | AM | 10142018 | 7 | Adult | Cinnamon | Cinnamon+ | No real highlight, White tail? | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9684092812839 40.7711445841928) | 19 | 4 | 19 | 13 | |||||
2175 | 2175 | -73.9657487923637 | 40.7786823090663 | 18G-PM-1013-04 | 18G | PM | 10132018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9657487923637 40.7786823090663) | 19 | 4 | 19 | 13 | ||||||
2338 | 2338 | -73.9716621112698 | 40.7742862219469 | 11E-AM-1013-01 | 11E | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9716621112698 40.7742862219469) | 19 | 4 | 19 | 13 | ||||||
2440 | 2440 | -73.9673803508629 | 40.7785245025508 | 17F-AM-1007-01 | 17F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 18 | false | false | true | true | false | false | false | false | true | false | false | true | false | POINT (-73.9673803508629 40.7785245025508) | 19 | 4 | 19 | 13 | ||||||
2859 | 2859 | -73.9786940945874 | 40.7690820276888 | 3B-PM-1007-05 | 03B | PM | 10072018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 6 | on rock | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9786940945874 40.7690820276888) | 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 );