This data as json, CSV (advanced)
Suggested facets: Date, Age, 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, Approaches, Indifferent
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107 | 107 | -73.9521110154872 | 40.7978449143313 | 42G-AM-1018-03 | 42G | AM | 10182018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | stop to look at me—then ran | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9521110154872 40.7978449143313) | |||
123 | 123 | -73.9671147090087 | 40.7772624641112 | 16G-AM-1010-03 | 16G | AM | 10102018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | was hanging out w/ #2 until i showed up | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9671147090087 40.7772624641112) | |||
124 | 124 | -73.9588660250232 | 40.7982597947515 | 40A-AM-1010-03 | 40A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | bottom of great hill | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | dog chased | POINT (-73.9588660250232 40.7982597947515) | ||
204 | 204 | -73.96795381633409 | 40.7837103696906 | 22C-AM-1013-03 | 22C | AM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | eating (mushroom) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9679538163341 40.7837103696906) | |||
232 | 232 | -73.9624184586031 | 40.7921524868211 | 32B-AM-1017-03 | 32B | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | approaches (primarily),runs from (initially),follows | POINT (-73.9624184586031 40.7921524868211) | |||
258 | 258 | -73.9534333425633 | 40.793256416332795 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9534333425633 40.7932564163328) | |||
388 | 388 | -73.9592537496995 | 40.7919271821316 | 33E-AM-1014-03 | 33E | AM | 10142018 | 3 | Adult | Black | Black+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9592537496995 40.7919271821316) | |||||
491 | 491 | -73.9688470831269 | 40.7844651946415 | 22A-AM-1008-03 | 22A | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9688470831269 40.7844651946415) | |||||
612 | 612 | -73.9629420113622 | 40.789133072717 | 29C-AM-1007-03 | 29C | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629420113622 40.789133072717) | ||||
820 | 820 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 10122018 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801902133148 40.769557595068) | |||
852 | 852 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | 1 | 0 | 1 | 0 | 0 | hopping | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | POINT (-73.9609704650925 40.7938786854735) | |||
891 | 891 | -73.9613351649026 | 40.79098668513571 | 31D-AM-1014-03 | 31D | AM | 10142018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9613351649026 40.7909866851357) | ||||
898 | 898 | -73.95428280532559 | 40.794179732035495 | 37G-AM-1014-03 | 37G | AM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9542828053256 40.7941797320355) | |||||
963 | 963 | -73.9621066718851 | 40.7942427079733 | 34A-AM-1012-03 | 34A | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9621066718851 40.7942427079733) | |||||
1126 | 1126 | -73.97001860010491 | 40.7826052184658 | 20B-AM-1007-03 | 20B | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9700186001049 40.7826052184658) | |||||
1159 | 1159 | -73.9682129261841 | 40.77542323581179 | 14G-AM-1012-03 | 14G | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9682129261841 40.7754232358118) | ||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9790822606486 40.7714466633386) | |||||
1328 | 1328 | -73.9765758043111 | 40.771380315403206 | 6C-AM-1007-03 | 06C | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 8 | another tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9765758043111 40.7713803154032) | |||
1375 | 1375 | -73.9564741038174 | 40.7938845572816 | 36F-AM-1017-03 | 36F | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon on shoulders | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (me) | POINT (-73.9564741038174 40.7938845572816) | ||
1395 | 1395 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 10142018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9710801547498 40.7760872452093) | ||||
1502 | 1502 | -73.97052548010001 | 40.7763606494306 | 13E-AM-1017-03 | 13E | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | acknowledges | POINT (-73.9705254801 40.7763606494306) | |||
1548 | 1548 | -73.9790044506465 | 40.7689469479245 | 3B-AM-1010-03 | 03B | AM | 10102018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing #2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9790044506465 40.7689469479245) | |||
1553 | 1553 | -73.9690645326017 | 40.7773822116124 | 15E-AM-1013-03 | 15E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | on fallen log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9690645326017 40.7773822116124) | ||||
1620 | 1620 | -73.96356061997841 | 40.782206970617 | 22G-AM-1018-03 | 22G | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9635606199784 40.782206970617) | ||||
1658 | 1658 | -73.9736016229655 | 40.772378137671396 | 8D-AM-1007-03 | 08D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran up tree when approached | POINT (-73.9736016229655 40.77237813767141) | ||||
1759 | 1759 | -73.9576219570858 | 40.79633512256721 | 38C-AM-1019-03 | 38C | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9576219570858 40.7963351225672) | ||||
1968 | 1968 | -73.9699088881236 | 40.775277835162605 | 13F-AM-1007-03 | 13F | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9699088881236 40.7752778351626) | ||||
1992 | 1992 | -73.9586085843149 | 40.7946617684536 | 36C-AM-1014-03 | 36C | AM | 10142018 | 3 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9586085843149 40.7946617684536) | ||||||
2034 | 2034 | -73.96991351872971 | 40.7782354186163 | 16D-AM-1007-03 | 16D | AM | 10072018 | 3 | Adult | + | ran away before I could take a good look | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9699135187297 40.7782354186163) | |||||
2043 | 2043 | -73.9643223016635 | 40.781431908715 | 21F-AM-1018-03 | 21F | AM | 10182018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | dead | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9643223016635 40.781431908715) | |||
2117 | 2117 | -73.9597192455543 | 40.7973316178661 | 38A-AM-1019-03 | 38A | AM | 10192018 | 3 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | stood on back legs | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | POINT (-73.9597192455543 40.7973316178661) | ||
2397 | 2397 | -73.9704592500888 | 40.772962887933005 | 10G-AM-1006-03 | 10G | AM | 10062018 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704592500888 40.772962887933) | |||
2541 | 2541 | -73.9579097104326 | 40.797227339471604 | 39C-AM-1017-03 | 39C | AM | 10172018 | 3 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9579097104326 40.7972273394716) | ||||
2687 | 2687 | -73.9550235589287 | 40.7951312356844 | 38F-AM-1018-03 | 38F | AM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9550235589287 40.7951312356844) | ||||
2928 | 2928 | -73.9767953468937 | 40.7676376977667 | 3E-AM-1006-03 | 03E | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | checkin' his stashes | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | POINT (-73.9767953468937 40.7676376977667) | |||
2948 | 2948 | -73.9545225586988 | 40.7956074663106 | 39F-AM-1014-03 | 39F | AM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9545225586988 40.7956074663106) |
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 );