This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2267 | 2267 | -73.97279263353971 | 40.77037055775 | 7F-AM-1008-07 | 07F | AM | 10082018 | 7 | Adult | Gray | Gray+ | Above Ground | 28 | next to the hole of #6 | 0 | 0 | 0 | 0 | 0 | standing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9727926335397 40.77037055775) | |||
2292 | 2292 | -73.96698919404629 | 40.7835635162331 | 22C-PM-1006-07 | 22C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9669891940463 40.7835635162331) | |||||
2297 | 2297 | -73.9787771053108 | 40.769356212275 | 3B-AM-1010-07 | 03B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | together w/ #8 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9787771053108 40.76935621227501) | ||||
2301 | 2301 | -73.968906907671 | 40.781627826784295 | 19C-PM-1018-07 | 19C | PM | 10182018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.968906907671 40.7816278267843) | |||
2311 | 2311 | -73.96801718943509 | 40.772464442631296 | 11I-PM-1012-07 | 11I | PM | 10122018 | 7 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying its food into the ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.96801718943512 40.7724644426313) | ||||
2332 | 2332 | -73.9709797467807 | 40.776909571067904 | 14D-AM-1014-07 | 14D | AM | 10142018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9709797467807 40.7769095710679) | ||||
2362 | 2362 | -73.9700263936574 | 40.769933509858106 | 7H-PM-1006-07 | 07H | PM | 10062018 | 7 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 1 | 1 | 0 | 0 | playing w/ #6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9700263936574 40.7699335098581) | ||||
2372 | 2372 | -73.9724879969884 | 40.771098202397 | 8F-PM-1012-07 | 08F | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 17 | 0 | 0 | 1 | 0 | 0 | gathering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9724879969884 40.771098202397) | |||
2402 | 2402 | -73.9777206733344 | 40.7668595585487 | 1D-PM-1007-07 | 01D | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | lying down | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9777206733344 40.7668595585487) | ||||
2513 | 2513 | -73.9767590273554 | 40.7717561807266 | 6B-PM-1017-07 | 06B | PM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9767590273554 40.7717561807266) | ||||
2567 | 2567 | -73.9690241805398 | 40.783796758077294 | 21B-AM-1019-07 | 21B | AM | 10192018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690241805398 40.7837967580773) | |||||
2623 | 2623 | -73.9604482901468 | 40.7898646293603 | 31E-PM-1006-07 | 31E | PM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9604482901468 40.7898646293603) | ||||
2649 | 2649 | -73.9706428641753 | 40.7762933936464 | 13E-AM-1017-07 | 13E | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706428641753 40.7762933936464) | ||||
2669 | 2669 | -73.9615900833886 | 40.7945431292846 | 35A-PM-1013-07 | 35A | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9615900833886 40.7945431292846) | ||||
2713 | 2713 | -73.9687214684206 | 40.779284172016396 | 17D-AM-1008-07 | 17D | AM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687214684206 40.7792841720164) | ||||
2759 | 2759 | -73.9543373703455 | 40.7943889087123 | 38G-PM-1020-07 | 38G | PM | 10202018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9543373703455 40.7943889087123) | ||||
2778 | 2778 | -73.9761799699276 | 40.774213409933 | 9B-AM-1010-07 | 09B | AM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761799699276 40.774213409933) | ||||
2780 | 2780 | -73.9700634278 | 40.778422372245295 | 16D-PM-1010-07 | 16D | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9700634278 40.7784223722453) | |||||
2812 | 2812 | -73.963209639301 | 40.7926138443715 | 32A-PM-1013-07 | 32A | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.963209639301 40.7926138443715) | ||||
2831 | 2831 | -73.9753585157592 | 40.7698398607941 | 5E-AM-1008-07 | 05E | AM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | on fence | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9753585157592 40.7698398607941) |
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 );