This data as json, CSV (advanced)
Suggested facets: Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | -73.9770718586754 | 40.7729752391435 | 7B-AM-1008-09 | 07B | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770718586754 40.7729752391435) | |||||
146 | 146 | -73.95621174550999 | 40.795104437820704 | 38E-AM-1010-09 | 38E | AM | 10102018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95621174551 40.7951044378207) | ||||
259 | 259 | -73.9726958070536 | 40.770609612632796 | 7F-AM-1008-09 | 07F | AM | 10082018 | 9 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | playing w/ #8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9726958070536 40.7706096126328) | ||||
377 | 377 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 10082018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | went up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757001944781 40.769499790547) | |||
405 | 405 | -73.97866031471492 | 40.7671937837017 | 1D-AM-1006-09 | 01D | AM | 10062018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9786603147149 40.7671937837017) | ||||
406 | 406 | -73.97663549671971 | 40.7734575166319 | 8B-AM-1007-09 | 08B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766354967197 40.7734575166319) | ||||
518 | 518 | -73.96878474106559 | 40.778185700305 | 16E-AM-1014-09 | 16E | AM | 10142018 | 9 | Adult | Gray | Gray+ | Above Ground | 25 | In tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687847410656 40.778185700305) | ||||
570 | 570 | -73.9745227769788 | 40.7673618284782 | 3F-AM-1006-09 | 03F | AM | 10062018 | 9 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | in grass by light post | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745227769788 40.76736182847821) | |||
608 | 608 | -73.95896759955171 | 40.791311922358396 | 33E-AM-1014-09 | 33E | AM | 10142018 | 9 | Juvenile | Black | Black+ | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589675995517 40.7913119223584) | |||||
666 | 666 | -73.96870277827259 | 40.770516261619896 | 9I-AM-1014-09 | 09I | AM | 10142018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.96870277827261 40.7705162616199) | |||||
704 | 704 | -73.97935655643609 | 40.767925939044794 | 2C-AM-1010-09 | 02C | AM | 10102018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | climbed up tree as i neared | POINT (-73.9793565564361 40.7679259390448) | |||
822 | 822 | -73.9576559099012 | 40.7992598626483 | 41B-AM-1010-09 | 41B | AM | 10102018 | 9 | Adult | Gray | Gray+ | Above Ground | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576559099012 40.7992598626483) | |||||
835 | 835 | -73.97079005665191 | 40.777167055008896 | 14D-AM-1014-09 | 14D | AM | 10142018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707900566519 40.7771670550089) | ||||
919 | 919 | -73.96372797118529 | 40.7905198502307 | 30B-AM-1007-09 | 30B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Above Ground | 50 | 0 | 0 | 1 | 0 | 0 | jumping b/w trees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9637279711853 40.7905198502307) | ||||
973 | 973 | -73.97059770598621 | 40.7760413182276 | 13E-AM-1017-09 | 13E | AM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9705977059862 40.776041318227605) | |||||
1212 | 1212 | -73.9761792189352 | 40.7745745517215 | 9A-AM-1013-09 | 09A | AM | 10132018 | 9 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761792189352 40.7745745517215) | |||||
1335 | 1335 | -73.969560591279 | 40.7705619840715 | 8I-AM-1006-09 | 08I | AM | 10062018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | very curious,looked like it expected food | POINT (-73.969560591279 40.7705619840715) | |||
1445 | 1445 | -73.9696196840065 | 40.7836431098335 | 21A-AM-1019-09 | 21A | AM | 10192018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9696196840065 40.7836431098335) | |||||
1557 | 1557 | -73.9705331808443 | 40.769994357129605 | 7H-AM-1006-09 | 07H | AM | 10062018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9705331808443 40.7699943571296) | ||||||
2123 | 2123 | -73.959874668294 | 40.7907004233491 | 32E-AM-1007-09 | 32E | AM | 10072018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.959874668294 40.7907004233491) | ||||
2293 | 2293 | -73.9675309175947 | 40.7788649926486 | 17E-AM-1017-09 | 17E | AM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9675309175947 40.7788649926486) | |||||
2319 | 2319 | -73.97568707891871 | 40.773364678267896 | 9B-AM-1010-09 | 09B | AM | 10102018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | food in mouth | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9756870789187 40.7733646782679) | |||
2401 | 2401 | -73.972010921173 | 40.7701626919216 | 7G-AM-1010-09 | 07G | AM | 10102018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.972010921173 40.7701626919216) | |||||
2492 | 2492 | -73.9801619956135 | 40.76785766975421 | 1B-AM-1012-09 | 01B | AM | 10122018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801619956135 40.7678576697542) | |||||
2692 | 2692 | -73.98016364007441 | 40.769019205592606 | 2A-AM-1010-09 | 02A | AM | 10102018 | 9 | Adult | Gray | White | Gray+White | Above Ground | climbing in bush | 0 | 0 | 1 | 0 | 0 | hopping & flipping around. this one was very energetic & jumping aorund | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | climbed a foot up a tree and watched me | POINT (-73.9801636400744 40.7690192055926) | ||
2799 | 2799 | -73.96826273820729 | 40.773076674345205 | 11H-AM-1010-09 | 11H | AM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9682627382073 40.7730766743452) | ||||
2967 | 2967 | -73.97132575863719 | 40.776271961946705 | 13D-AM-1014-09 | 13D | AM | 10142018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9713257586372 40.7762719619467) | ||||
84 | 84 | -73.9701824825872 | 40.776653057929295 | 14E-AM-1008-09 | 14E | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9701824825872 40.7766530579293) | |||||
186 | 186 | -73.9788138172962 | 40.7693001754769 | 3B-AM-1010-09 | 03B | AM | 10102018 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9788138172962 40.7693001754769) | |||||
268 | 268 | -73.968107276769 | 40.7768612676036 | 15F-AM-1007-09 | 15F | AM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 20 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.968107276769 40.7768612676036) | ||||
1019 | 1019 | -73.97042696309641 | 40.7722964640257 | 10G-AM-1006-09 | 10G | AM | 10062018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704269630964 40.7722964640257) | ||||
1977 | 1977 | -73.9586570546871 | 40.796349417475 | 38C-AM-1019-09 | 38C | AM | 10192018 | 9 | Adult | Gray | White | Gray+White | Gray & White selected as Primary & Highlights. Made executive adjustments. | Above Ground | 3 | Between ground & tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586570546871 40.796349417475) | ||
2731 | 2731 | -73.9595886063173 | 40.7918405182594 | 33D-AM-1017-09 | 33D | AM | 10172018 | 9 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9595886063173 40.7918405182594) |
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 );