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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2174 | 2174 | -73.9684092812839 | 40.7711445841928 | 9I-AM-1014-07 | 09I | AM | 10142018 | 7 | Adult | Cinnamon | Cinnamon+ | No real highlight, White tail? | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9684092812839 40.7711445841928) | ||||
2179 | 2179 | -73.95596639495109 | 40.7974497269789 | 40D-AM-1013-07 | 40D | AM | 10132018 | 7 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | curious | POINT (-73.9559663949511 40.7974497269789) | ||||
2261 | 2261 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 10142018 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9609692861012 40.790502891247) | |||||
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) | ||||
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) | |||||
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) | ||||
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) | ||||
2746 | 2746 | -73.95614328368629 | 40.798266534723396 | 41C-AM-1017-07 | 41C | AM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9561432836863 40.7982665347234) | ||||
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) | ||||
2784 | 2784 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 10132018 | 7 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763722433833 40.7744121430891) | ||||||||
2788 | 2788 | -73.9647845655965 | 40.7816573808695 | 21F-AM-1018-07 | 21F | AM | 10182018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9647845655965 40.7816573808695) | ||||
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) | |||
1236 | 1236 | -73.97920390711141 | 40.76787494712671 | 2C-AM-1010-07 | 02C | AM | 10102018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | #7 & #8 chased each other up diff tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9792039071114 40.76787494712671) | |||
1862 | 1862 | -73.97648512317541 | 40.771573686286104 | 6C-AM-1007-07 | 06C | AM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | ambling | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | trucks | POINT (-73.9764851231754 40.7715736862861) | ||
1861 | 1861 | -73.97555625268109 | 40.7678821029525 | 3E-AM-1006-07 | 03E | AM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | burying nuts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755562526811 40.7678821029525) | |||
750 | 750 | -73.96996720741642 | 40.777438934574796 | 15D-AM-1007-07 | 15D | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699672074164 40.7774389345748) | |||
853 | 853 | -73.9534509627885 | 40.7921084224711 | 36I-AM-1017-07 | 36I | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (#8),scratching | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9534509627885 40.7921084224711) | |||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | ||
642 | 642 | -73.9568382279233 | 40.7975685470963 | 40C-AM-1017-07 | 40C | AM | 10172018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9568382279233 40.7975685470963) | |||
1217 | 1217 | -73.9764850086767 | 40.7737340720562 | 8B-AM-1007-07 | 08B | AM | 10072018 | 7 | Juvenile | Gray | Black | Gray+Black | Above Ground | 8 | 0 | 0 | 0 | 1 | 0 | holding nut | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9764850086767 40.7737340720562) | |||
2462 | 2462 | -73.9768544488742 | 40.76800695009771 | 3D-AM-1006-07 | 03D | AM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | running (with food in mouth) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768544488742 40.7680069500977) | |||
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) | |||
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) | ||||
559 | 559 | -73.9704166194815 | 40.7766720346576 | 14E-AM-1008-07 | 14E | AM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704166194815 40.7766720346576) |
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 );