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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
506 | 506 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 10182018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9649611089685 40.7814371834837) | ||||
552 | 552 | -73.9625416200877 | 40.7811302397912 | 21H-AM-1017-02 | 21H | AM | 10172018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9625416200877 40.78113023979121) | ||||
968 | 968 | -73.9689781843873 | 40.7709333833783 | 9I-PM-1010-04 | 09I | PM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9689781843873 40.7709333833783) | ||||
1098 | 1098 | -73.96049542761291 | 40.7965682182001 | 37A-AM-1012-01 | 37A | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Drawing included on tally sheet | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scanning (drawing included) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9604954276129 40.7965682182001) | ||
1117 | 1117 | -73.9693465383617 | 40.7744996336934 | 12F-PM-1007-01 | 12F | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9693465383617 40.7744996336934) | ||||
1155 | 1155 | -73.964572179093 | 40.7811208719018 | 21F-PM-1018-01 | 21F | PM | 10182018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.964572179093 40.7811208719018) | ||||
1334 | 1334 | -73.957134662576 | 40.7872395604122 | 30I-PM-1006-07 | 30I | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.957134662576 40.7872395604122) | ||||
1354 | 1354 | -73.97652692820591 | 40.774687663524794 | 9A-AM-1013-10 | 09A | AM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9765269282059 40.7746876635248) | ||||
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) | ||||
1619 | 1619 | -73.9744555348544 | 40.772849810635705 | 8D-PM-1007-03 | 08D | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9744555348544 40.7728498106357) | ||||||
1631 | 1631 | -73.9527196716568 | 40.792363826828 | 36I-PM-1007-11 | 36I | PM | 10072018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | me! | POINT (-73.9527196716568 40.792363826828) | |||
1891 | 1891 | -73.9749641575871 | 40.767330505627704 | 3F-AM-1006-05 | 03F | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9749641575871 40.7673305056277) | ||||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9540151828782 40.7920066170587) | |||
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) | |||
2218 | 2218 | -73.9694382427984 | 40.7846350692923 | 22A-AM-1008-04 | 22A | AM | 10082018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9694382427984 40.7846350692923) | ||||
2234 | 2234 | -73.9734741818047 | 40.766328451425 | 3H-PM-1014-03 | 03H | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9734741818047 40.766328451425) | ||||
2244 | 2244 | -73.9509628195532 | 40.797777567417796 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9509628195532 40.7977775674178) | ||||
2467 | 2467 | -73.9755923256429 | 40.7672967972471 | 3F-PM-1013-02 | 03F | PM | 10132018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97559232564292 40.7672967972471) | ||||
2488 | 2488 | -73.97269208477921 | 40.779411746388895 | 16A-PM-1019-02 | 16A | PM | 10192018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | scared by dog | POINT (-73.9726920847792 40.7794117463889) | |||
2608 | 2608 | -73.95226776576591 | 40.7934034811368 | 38I-AM-1019-02 | 38I | AM | 10192018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9522677657659 40.7934034811368) | ||||
2671 | 2671 | -73.97433690682541 | 40.7675726965985 | 3F-AM-1006-11 | 03F | AM | 10062018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9743369068254 40.7675726965985) | ||||
2927 | 2927 | -73.96501200660741 | 40.7805932882407 | 20F-PM-1007-13 | 20F | PM | 10072018 | 13 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9650120066074 40.78059328824071) | ||||
2971 | 2971 | -73.9639801411692 | 40.7778921302618 | 18I-PM-1007-04 | 18I | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | walking sitting up | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9639801411692 40.7778921302618) | |||
2992 | 2992 | -73.9746063250438 | 40.7687654196811 | 4F-PM-1013-03 | 04F | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9746063250438 40.7687654196811) | ||||
3018 | 3018 | -73.9645437409662 | 40.7811599933331 | 21F-PM-1018-02 | 21F | PM | 10182018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9645437409662 40.7811599933331) |
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 );