This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Chasing, Climbing, Eating, Foraging, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||||
74 | 74 | -73.95466541841459 | 40.7947639241491 | 38G-PM-1020-09 | 38G | PM | 10202018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9546654184146 40.7947639241491) | ||||
141 | 141 | -73.9590992841423 | 40.793758098573 | 35D-PM-1013-09 | 35D | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9590992841423 40.793758098573) | ||||
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) | ||||
444 | 444 | -73.96414623605409 | 40.7778316005464 | 18I-PM-1007-09 | 18I | PM | 10072018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | canoodling w/ 8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9641462360541 40.7778316005464) | |||
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) | ||||
546 | 546 | -73.9547423290276 | 40.7899702628835 | 33I-PM-1006-09 | 33I | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9547423290276 40.7899702628835) | |||||
556 | 556 | -73.9721670042434 | 40.776085913838 | 13D-PM-1018-09 | 13D | PM | 10182018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721670042434 40.776085913838) | ||||
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) | |||||
609 | 609 | -73.9698762023146 | 40.778205568811295 | 16D-PM-1010-09 | 16D | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698762023146 40.77820556881131) | |||||
611 | 611 | -73.9679399097382 | 40.774281314995704 | 13H-PM-1010-09 | 13H | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96793990973822 40.7742813149957) | |||||
803 | 803 | -73.9697983725608 | 40.7700677022205 | 8I-PM-1013-09 | 08I | PM | 10132018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9697983725608 40.7700677022205) | ||||
809 | 809 | -73.96332506365009 | 40.7922155082679 | 32A-PM-1013-09 | 32A | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9633250636501 40.7922155082679) | ||||
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) | ||||
949 | 949 | -73.9701596268736 | 40.7702106607329 | 8H-PM-1014-09 | 08H | PM | 10142018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701596268736 40.7702106607329) | ||||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9803282698463 40.7680809889384) | |||
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) | |||||
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) | |||||
1479 | 1479 | -73.97074984303941 | 40.7723724480959 | 10G-PM-1017-09 | 10G | PM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707498430394 40.7723724480959) | |||||
1605 | 1605 | -73.96903623845971 | 40.7767162824413 | 14F-PM-1012-09 | 14F | PM | 10122018 | 9 | 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.9690362384597 40.7767162824413) | ||||
2031 | 2031 | -73.9795454787631 | 40.768802689274104 | 3B-PM-1007-09 | 03B | PM | 10072018 | 9 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9795454787631 40.7688026892741) | ||||||||
2160 | 2160 | -73.975028559002 | 40.7667307335544 | 2F-PM-1014-09 | 02F | PM | 10142018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975028559002 40.7667307335544) | ||||
2171 | 2171 | -73.9686370726471 | 40.7780382348833 | 16E-PM-1018-09 | 16E | PM | 10182018 | 9 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 3 | On trunk | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9686370726471 40.7780382348833) | |||
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) | |||||
2299 | 2299 | -73.9605554843228 | 40.7901473714024 | 31E-PM-1006-09 | 31E | PM | 10062018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9605554843228 40.7901473714024) | ||||
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) | |||||
2625 | 2625 | -73.96991885444591 | 40.7772180370053 | 15E-PM-1008-09 | 15E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699188544459 40.7772180370053) | |||||
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) | ||||
2787 | 2787 | -73.9765306970303 | 40.769495687585895 | 4D-PM-1008-09 | 04D | PM | 10082018 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765306970303 40.7694956875859) | ||||||
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) | ||||
2978 | 2978 | -73.96888170064429 | 40.7829120321438 | 20B-PM-1013-09 | 20B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688817006443 40.7829120321438) | ||||
3003 | 3003 | -73.96986639266571 | 40.773999710413 | 12F-PM-1007-09 | 12F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698663926657 40.773999710413) |
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 );