This data as json, CSV (advanced)
Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Tail flags, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
942 | 942 | -73.9533923917973 | 40.796170187476896 | 40G-AM-1007-01 | 40G | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | large tree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9533923917973 40.7961701874769) | |||
2833 | 2833 | -73.9552595564798 | 40.7889533029466 | 32I-PM-1007-01 | 32I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | chirps | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9552595564798 40.7889533029466) | |||
781 | 781 | -73.955516031113 | 40.7923188156277 | 35G-AM-1007-01 | 35G | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955516031113 40.7923188156277) | ||||
45 | 45 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9579645940414 40.7918613498407) | ||||
470 | 470 | -73.95812430217221 | 40.794431473386 | 36D-AM-1007-01 | 36D | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | avoiding a dog | POINT (-73.95812430217221 40.794431473386) | |||
2436 | 2436 | -73.95827701417 | 40.785661023889105 | 28I-PM-1007-01 | 28I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95827701417 40.7856610238891) | |||||
1560 | 1560 | -73.9587072763996 | 40.7850256219415 | 27I-AM-1007-01 | 27I | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587072763996 40.7850256219415) | ||||
2561 | 2561 | -73.9591513028486 | 40.7835978067328 | 25I-PM-1007-01 | 25I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9591513028486 40.7835978067328) | |||||
1315 | 1315 | -73.9595955824812 | 40.793304794353396 | 34D-PM-1007-01 | 34D | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9595955824812 40.7933047943534) | ||||
2874 | 2874 | -73.9597453664295 | 40.7891382153733 | 30F-PM-1007-01 | 30F | PM | 10072018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 1 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9597453664295 40.7891382153733) | |||
1051 | 1051 | -73.96137470327021 | 40.7920483852431 | 33C-PM-1007-01 | 33C | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9613747032702 40.792048385243106) | |||||
1055 | 1055 | -73.9632337134707 | 40.791468237073396 | 31B-PM-1007-01 | 31B | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 1 | 1 | 0 | 0 | chasing #2 and climbing tree w/ #2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9632337134707 40.7914682370734) | |||
1609 | 1609 | -73.96390249881229 | 40.777695306584896 | 18I-PM-1007-01 | 18I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | 0 | 0 | 1 | 1 | 1 | hanging upside down | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639024988123 40.7776953065849) | |||
97 | 97 | -73.9639744005647 | 40.782511195076395 | 22F-AM-1007-01 | 22F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639744005647 40.7825111950764) | ||||
2003 | 2003 | -73.9640526358598 | 40.7907411574825 | 30B-AM-1007-01 | 30B | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9640526358598 40.7907411574825) | |||||
2463 | 2463 | -73.9653343572865 | 40.77752869246171 | 17H-PM-1007-01 | 17H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9653343572865 40.7775286924617) | ||||
373 | 373 | -73.96721272832829 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | a lot of activity | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9672127283283 40.7810666805133) | |||
2440 | 2440 | -73.96738035086291 | 40.778524502550795 | 17F-AM-1007-01 | 17F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 18 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9673803508629 40.7785245025508) | |||||
789 | 789 | -73.9675023138703 | 40.7872554700995 | 25A-PM-1007-01 | 25A | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 40 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675023138703 40.7872554700995) | |||
52 | 52 | -73.9675634326877 | 40.781347735250705 | 19D-AM-1007-01 | 19D | AM | 10072018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | fenced off area can't approach | POINT (-73.9675634326877 40.7813477352507) | ||||
1010 | 1010 | -73.9689723590015 | 40.7756860990338 | 13F-AM-1007-01 | 13F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689723590015 40.7756860990338) | ||||
1727 | 1727 | -73.96924722995651 | 40.7722592187215 | 10H-PM-1007-01 | 10H | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | dark gray | Above Ground | 15 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9692472299565 40.7722592187215) | ||
1044 | 1044 | -73.9693254080548 | 40.77616003271179 | 14F-AM-1007-01 | 14F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693254080548 40.7761600327118) | ||||
996 | 996 | -73.9703149829421 | 40.778558363032296 | 16D-AM-1007-01 | 16D | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9703149829421 40.7785583630323) | ||||
1071 | 1071 | -73.9703774000082 | 40.771760755155505 | 9G-AM-1007-01 | 09G | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 50 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9703774000082 40.7717607551555) | |||||
566 | 566 | -73.9708364583591 | 40.772369158743295 | 10F-AM-1007-01 | 10F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 60 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9708364583591 40.7723691587433) | |||||
1837 | 1837 | -73.97102881010059 | 40.7715777109992 | 9G-PM-1007-01 | 09G | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | climbing (down tree) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9710288101006 40.7715777109992) | ||||
733 | 733 | -73.9764397550289 | 40.7737004557104 | 8B-AM-1007-01 | 08B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9764397550289 40.7737004557104) | ||||
1500 | 1500 | -73.9769969548024 | 40.7710711265211 | 6C-AM-1007-01 | 06C | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | vid! | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | curious,but wary | POINT (-73.97699695480242 40.7710711265211) | ||
1974 | 1974 | -73.97724207345091 | 40.773002519140704 | 7A-PM-1007-01 | 07A | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9772420734509 40.7730025191407) | |||||
674 | 674 | -73.9779811967788 | 40.7675178797546 | 2D-AM-1007-01 | 02D | AM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9779811967788 40.7675178797546) | ||||
2508 | 2508 | -73.97938145045201 | 40.770903369788705 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.979381450452 40.770903369788705) | ||||
1413 | 1413 | -73.98100322064279 | 40.768162563497896 | 1A-AM-1007-01 | 01A | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9810032206428 40.7681625634979) |
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 );