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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2252 | 2252 | -73.95377032313591 | 40.7915959393814 | 35I-AM-1013-01 | 35I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | White underbelly | Above Ground | 18 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9537703231359 40.7915959393814) | |||
2278 | 2278 | -73.96453903109901 | 40.78099163100121 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.964539031099 40.7809916310012) | ||||
2283 | 2283 | -73.9628982772673 | 40.788430480338604 | 28D-PM-1019-01 | 28D | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9628982772673 40.7884304803386) | ||||
2312 | 2312 | -73.97658670292259 | 40.7674304266107 | 2E-PM-1014-01 | 02E | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9765867029226 40.7674304266107) | ||||
2387 | 2387 | -73.98085173247209 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 10142018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9808517324721 40.7683154647217) | ||||
2406 | 2406 | -73.9668964315686 | 40.777757799088604 | 16G-AM-1010-01 | 16G | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9668964315686 40.7777577990886) | ||||
2415 | 2415 | -73.9683598086625 | 40.7811150451315 | 19D-PM-1008-01 | 19D | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9683598086625 40.7811150451315) | ||||
2438 | 2438 | -73.969532160039 | 40.7822616641357 | 20B-PM-1013-01 | 20B | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969532160039 40.7822616641357) | ||||
2479 | 2479 | -73.9657958433575 | 40.7763496875058 | 15H-AM-1013-01 | 15H | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 50 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9657958433575 40.7763496875058) | ||||
2497 | 2497 | -73.9622050752008 | 40.7886373772305 | 29D-PM-1010-01 | 29D | PM | 10102018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622050752008 40.7886373772305) | ||||
2526 | 2526 | -73.96464954504991 | 40.7791203699027 | 19H-PM-1008-01 | 19H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9646495450499 40.7791203699027) | ||||
2545 | 2545 | -73.9617594316752 | 40.7946803725236 | 35A-AM-1014-01 | 35A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9617594316752 40.7946803725236) | ||||
2550 | 2550 | -73.96948057455221 | 40.774355690284295 | 12F-AM-1020-01 | 12F | AM | 10202018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 17 | Tree | 0 | 0 | 0 | 0 | 0 | jumping | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9694805745522 40.7743556902843) | ||
2605 | 2605 | -73.97368963630059 | 40.767763086262605 | 4G-AM-1006-01 | 04G | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9736896363006 40.7677630862626) | ||||
2691 | 2691 | -73.9564599077179 | 40.7965185098695 | 39D-PM-1012-01 | 39D | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9564599077179 40.7965185098695) | ||||
2706 | 2706 | -73.9745141185576 | 40.76914797812071 | 5E-AM-1008-01 | 05E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on a checker table | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745141185576 40.7691479781207) | |||
2743 | 2743 | -73.9587179613803 | 40.7992119571657 | 41A-PM-1007-01 | 41A | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9587179613803 40.7992119571657) | ||||
2764 | 2764 | -73.9692660977515 | 40.7830532310766 | 21B-PM-1017-01 | 21B | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | paused to look at me | POINT (-73.9692660977515 40.7830532310766) | |||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9712187890707 40.7750640173134) | ||||
2843 | 2843 | -73.97147871782009 | 40.779804947074496 | 16B-PM-1017-01 | 16B | PM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714787178201 40.7798049470745) | ||||
2900 | 2900 | -73.9631005470369 | 40.788549405719294 | 28D-AM-1012-01 | 28D | AM | 10122018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9631005470369 40.7885494057193) | ||||
2920 | 2920 | -73.9657391918196 | 40.776502470347 | 16H-PM-1014-01 | 16H | PM | 10142018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657391918196 40.776502470347) | ||||
2956 | 2956 | -73.9654741695628 | 40.7890427851106 | 28B-PM-1010-01 | 28B | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9654741695628 40.7890427851106) | |||
2973 | 2973 | -73.9766693184436 | 40.7708879215854 | 6C-PM-1020-01 | 06C | PM | 10202018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Across Transverse | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766693184436 40.7708879215854) | |||
2997 | 2997 | -73.96197353854829 | 40.7944667974974 | 35A-PM-1013-01 | 35A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9619735385483 40.7944667974974) |
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 );