This data as json, CSV (advanced)
Suggested facets: Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
155 | 155 | -73.9522142360388 | 40.7949598486683 | 39H-PM-1013-02 | 39H | PM | 10132018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9522142360388 40.7949598486683) | 19 | 4 | 19 | 13 | |||||
679 | 679 | -73.955018489069 | 40.7971235333699 | 40E-PM-1017-02 | 40E | PM | 10172018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.955018489069 40.7971235333699) | 19 | 4 | 19 | 13 | |||||
776 | 776 | -73.9686816795392 | 40.775770422667 | 14F-PM-1012-02 | 14F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9686816795392 40.775770422667) | 19 | 4 | 19 | 13 | |||||
787 | 787 | -73.9725157534356 | 40.7658376729234 | 2I-PM-1006-02 | 02I | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9725157534356 40.7658376729234) | 19 | 4 | 19 | 13 | |||||
826 | 826 | -73.9557263533489 | 40.7939505791448 | 37F-PM-1014-02 | 37F | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | LAWN | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.95572635334891 40.7939505791448) | 19 | 4 | 19 | 13 | ||||
848 | 848 | -73.9692190295442 | 40.7763366309154 | 14F-AM-1007-02 | 14F | AM | 10072018 | 2 | 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.9692190295442 40.7763366309154) | 19 | 4 | 19 | 13 | |||||
938 | 938 | -73.9699451196396 | 40.7710409982701 | 9H-PM-1018-02 | 09H | PM | 10182018 | 2 | 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.9699451196396 40.7710409982701) | 19 | 4 | 19 | 13 | |||||
1108 | 1108 | -73.9638397790384 | 40.7828950272904 | 23F-PM-1013-02 | 23F | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | true | false | false | true | false | true | false | indifferent (mostly,did notice me,busy eating,foraging) | POINT (-73.9638397790384 40.7828950272904) | 19 | 4 | 19 | 13 | ||||
1123 | 1123 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 10122018 | 2 | 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.9670858934045 40.7753505024976) | 19 | 4 | 19 | 13 | |||||
1130 | 1130 | -73.9519081627768 | 40.7973148719421 | 41G-AM-1013-02 | 41G | AM | 10132018 | 2 | 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.9519081627768 40.7973148719421) | 19 | 4 | 19 | 13 | |||||
1325 | 1325 | -73.9775278847897 | 40.7687881061059 | 3C-AM-1007-02 | 03C | AM | 10072018 | 2 | 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.9775278847897 40.7687881061059) | 19 | 4 | 19 | 13 | |||||
1396 | 1396 | -73.9704677007779 | 40.7786860108302 | 16C-PM-1018-02 | 16C | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | false | true | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9704677007779 40.7786860108302) | 19 | 4 | 19 | 13 | |||||
1409 | 1409 | -73.9581544682422 | 40.7958081306449 | 37C-PM-1013-02 | 37C | PM | 10132018 | 2 | 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.9581544682422 40.7958081306449) | 19 | 4 | 19 | 13 | |||||
1552 | 1552 | -73.9695655231393 | 40.7698324659513 | 8I-PM-1013-02 | 08I | PM | 10132018 | 2 | 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.9695655231393 40.7698324659513) | 19 | 4 | 19 | 13 | |||||
1576 | 1576 | -73.9619985187616 | 40.7943277743532 | 34A-AM-1012-02 | 34A | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | chasing from tree to ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9619985187616 40.7943277743532) | 19 | 4 | 19 | 13 | ||||
1603 | 1603 | -73.9545929242174 | 40.7986940168685 | 42D-AM-1014-02 | 42D | AM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9545929242174 40.7986940168685) | 19 | 4 | 19 | 13 | ||||
1708 | 1708 | -73.9618486459307 | 40.7946365810826 | 35A-AM-1014-02 | 35A | AM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9618486459307 40.7946365810826) | 19 | 4 | 19 | 13 | |||||
1847 | 1847 | -73.9782283921819 | 40.7667932602077 | 1D-PM-1007-02 | 01D | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9782283921819 40.7667932602077) | 19 | 4 | 19 | 13 | |||||
1885 | 1885 | -73.9594174605642 | 40.7973128653773 | 38B-AM-1019-02 | 38B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9594174605642 40.7973128653773) | 19 | 4 | 19 | 13 | |||||
1895 | 1895 | -73.954699659637 | 40.7951308856929 | 38F-AM-1018-02 | 38F | AM | 10182018 | 2 | 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.954699659637 40.7951308856929) | 19 | 4 | 19 | 13 | |||||
1954 | 1954 | -73.9794840520702 | 40.7709595369804 | 4A-PM-1007-02 | 04A | PM | 10072018 | 2 | 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.9794840520702 40.770959536980406) | 19 | 4 | 19 | 13 | |||||
2048 | 2048 | -73.9627661465376 | 40.7819356810575 | 22G-PM-1018-02 | 22G | PM | 10182018 | 2 | 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.9627661465376 40.7819356810575) | 19 | 4 | 19 | 13 | |||||
2108 | 2108 | -73.9702420100291 | 40.7772720889907 | 14D-AM-1014-02 | 14D | AM | 10142018 | 2 | 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.9702420100291 40.7772720889907) | 19 | 4 | 19 | 13 | |||||
2500 | 2500 | -73.9689703880705 | 40.7712025611298 | 9I-PM-1010-02 | 09I | PM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | standard coloration | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.96897038807052 40.7712025611298) | 19 | 4 | 19 | 13 | ||||
2785 | 2785 | -73.9729105002306 | 40.7672758037086 | 4H-PM-1006-02 | 04H | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9729105002306 40.7672758037086) | 19 | 4 | 19 | 13 | |||||
2806 | 2806 | -73.9714298880357 | 40.77410578689 | 11E-PM-1012-02 | 11E | PM | 10122018 | 2 | 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.9714298880357 40.77410578689) | 19 | 4 | 19 | 13 | |||||
2916 | 2916 | -73.9517525111679 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9517525111679 40.7974407641075) | 19 | 4 | 19 | 13 | |||||
3022 | 3022 | -73.9639941227864 | 40.7899152327912 | 29B-PM-1010-02 | 29B | PM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9639941227864 40.7899152327912) | 19 | 4 | 19 | 13 | ||||||
2474 | 2474 | -73.9721448879766 | 40.7762112840981 | 13C-AM-1010-02 | 13C | AM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | false | false | true | false | false | burying | false | false | false | false | false | false | true | false | POINT (-73.9721448879766 40.7762112840981) | 19 | 4 | 19 | 13 | ||||
1595 | 1595 | -73.9754696312232 | 40.768191647092 | 4E-AM-1020-02 | 04E | AM | 10202018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 15 | false | false | true | false | true | foraging (on the tree itself) | false | false | false | false | false | false | true | false | POINT (-73.9754696312232 40.768191647092) | 19 | 4 | 19 | 13 | |||
187 | 187 | -73.9700162034073 | 40.7815277479588 | 19B-AM-1019-02 | 19B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | posing | false | false | false | false | false | false | true | true | indifferent then runs from | POINT (-73.9700162034073 40.7815277479588) | 19 | 4 | 19 | 13 | |||
2510 | 2510 | -73.9748635473782 | 40.7742591029151 | 10C-AM-1018-02 | 10C | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | sitting in the sun | false | false | false | false | false | false | true | false | POINT (-73.9748635473782 40.7742591029151) | 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 );