This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Kuks, Quaas, Tail twitches, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68 | 68 | -73.96942403275091 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 10072018 | 2 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96942403275091 40.7755898126674) | ||||||
262 | 262 | -73.97128762341721 | 40.7695885530701 | 7H-PM-1006-02 | 07H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | tree | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712876234172 40.7695885530701) | ||||
267 | 267 | -73.97547422950909 | 40.769699832724704 | 5E-PM-1012-02 | 05E | PM | 10122018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754742295091 40.7696998327247) | ||||
304 | 304 | -73.9523001834395 | 40.7949231000186 | 39H-AM-1007-02 | 39H | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9523001834395 40.7949231000186) | ||||
346 | 346 | -73.9712971568288 | 40.7745520717065 | 11E-AM-1013-02 | 11E | AM | 10132018 | 2 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712971568288 40.7745520717065) | ||||
453 | 453 | -73.959514034869 | 40.789911786416 | 31E-PM-1006-02 | 31E | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.959514034869 40.789911786416) | |||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9773079154219 40.7696506688861) | ||||
779 | 779 | -73.9745305540008 | 40.7742043234014 | 10C-PM-1013-02 | 10C | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9745305540008 40.7742043234014) | ||||
787 | 787 | -73.97251575343559 | 40.765837672923396 | 2I-PM-1006-02 | 02I | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9725157534356 40.7658376729234) | ||||
826 | 826 | -73.95572635334891 | 40.7939505791448 | 37F-PM-1014-02 | 37F | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | LAWN | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95572635334891 40.7939505791448) | |||
1067 | 1067 | -73.9695305996721 | 40.774538689695895 | 12F-PM-1007-02 | 12F | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695305996721 40.7745386896959) | ||||
1093 | 1093 | -73.9584106786233 | 40.7902777556926 | 32F-PM-1008-02 | 32F | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584106786233 40.7902777556926) | ||||
1097 | 1097 | -73.9761579527932 | 40.7755877312075 | 10A-PM-1014-02 | 10A | PM | 10142018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | in the bushes beneath a tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9761579527932 40.7755877312075) | |||
1108 | 1108 | -73.96383977903841 | 40.782895027290394 | 23F-PM-1013-02 | 23F | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | indifferent (mostly,did notice me,busy eating,foraging) | POINT (-73.9638397790384 40.7828950272904) | |||
1120 | 1120 | -73.9564079273261 | 40.7939340053805 | 36F-AM-1017-02 | 36F | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon on shoulders | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9564079273261 40.7939340053805) | |||
1123 | 1123 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670858934045 40.7753505024976) | ||||
1396 | 1396 | -73.9704677007779 | 40.7786860108302 | 16C-PM-1018-02 | 16C | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9704677007779 40.7786860108302) | ||||
1482 | 1482 | -73.95886101956991 | 40.7945269936639 | 36C-AM-1014-02 | 36C | AM | 10142018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Crossing path | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9588610195699 40.7945269936639) | |||
1552 | 1552 | -73.9695655231393 | 40.769832465951296 | 8I-PM-1013-02 | 08I | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695655231393 40.7698324659513) | ||||
1603 | 1603 | -73.95459292421741 | 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 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9545929242174 40.7986940168685) | |||
1677 | 1677 | -73.9594332600733 | 40.7960622445291 | 37B-PM-1013-02 | 37B | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9594332600733 40.7960622445291) | ||||
1853 | 1853 | -73.9721210372896 | 40.7667971476099 | 4I-AM-1006-02 | 04I | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721210372896 40.7667971476099) | ||||
1885 | 1885 | -73.9594174605642 | 40.7973128653773 | 38B-AM-1019-02 | 38B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594174605642 40.7973128653773) | ||||
1934 | 1934 | -73.969756965598 | 40.7786455091699 | 16D-PM-1010-02 | 16D | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969756965598 40.7786455091699) | |||||
1936 | 1936 | -73.9667911565238 | 40.779321901098 | 18F-AM-1014-02 | 18F | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | In small tree by water | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667911565238 40.77932190109801) | ||||
1971 | 1971 | -73.9591880400132 | 40.795007125283604 | 36C-PM-1013-02 | 36C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95918804001322 40.7950071252836) | ||||
2048 | 2048 | -73.96276614653759 | 40.7819356810575 | 22G-PM-1018-02 | 22G | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9627661465376 40.7819356810575) | ||||
2222 | 2222 | -73.9639048209454 | 40.777737334555795 | 18I-PM-1007-02 | 18I | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | 0 | 0 | 1 | 1 | 1 | hanging upside down | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639048209454 40.7777373345558) | |||
2300 | 2300 | -73.9789251806378 | 40.7699558513225 | 4B-AM-1010-02 | 04B | AM | 10102018 | 2 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 30 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9789251806378 40.7699558513225) | ||||
2430 | 2430 | -73.9569811285656 | 40.793091234605 | 35F-PM-1012-02 | 35F | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9569811285656 40.793091234605) | ||||
2470 | 2470 | -73.96388775886999 | 40.79154773042521 | 31A-AM-1010-02 | 31A | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | scratching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96388775887 40.7915477304252) | ||||
2785 | 2785 | -73.9729105002306 | 40.7672758037086 | 4H-PM-1006-02 | 04H | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729105002306 40.7672758037086) | ||||
2846 | 2846 | -73.96615704780291 | 40.7807271518813 | 20E-AM-1014-02 | 20E | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9661570478029 40.7807271518813) | ||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530811255728 40.79830691185791) | ||||
2915 | 2915 | -73.9734630412566 | 40.7653097139415 | 1H-PM-1013-02 | 01H | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9734630412566 40.7653097139415) |
JSON shape: default, array, newline-delimited
CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" ( "longitude" REAL, "latitude" REAL, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" INTEGER, "Hectare Squirrel Number" INTEGER, "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" INTEGER, "Chasing" INTEGER, "Climbing" INTEGER, "Eating" INTEGER, "Foraging" INTEGER, "Other Activities" TEXT, "Kuks" INTEGER, "Quaas" INTEGER, "Moans" INTEGER, "Tail flags" INTEGER, "Tail twitches" INTEGER, "Approaches" INTEGER, "Indifferent" INTEGER, "Runs from" INTEGER, "Other Interactions" TEXT, "Lat/Long" TEXT );