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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1846 | 1846 | -73.96533111365609 | 40.780193490342995 | 19F-PM-1017-07 | 19F | PM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9653311136561 40.78019349034301) | ||||
2943 | 2943 | -73.962534856258 | 40.7812134517411 | 22H-PM-1007-01 | 22H | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.962534856258 40.7812134517411) | ||||
2026 | 2026 | -73.9622752768962 | 40.7814921913101 | 22H-PM-1007-02 | 22H | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | low branch | 0 | 0 | 0 | 0 | 0 | watching me scratching | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9622752768962 40.7814921913101) | ||
2255 | 2255 | -73.96429678758571 | 40.78156523539371 | 21F-AM-1018-08 | 21F | AM | 10182018 | 8 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9642967875857 40.7815652353937) | ||||
687 | 687 | -73.96369718436651 | 40.78256385373621 | 22F-AM-1007-04 | 22F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636971843665 40.7825638537362) | ||||||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9595222999173 40.7833202577782) | |||
166 | 166 | -73.96384633980401 | 40.7834051716226 | 23F-AM-1018-01 | 23F | AM | 10182018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.963846339804 40.7834051716226) | ||||
261 | 261 | -73.9552861155228 | 40.788973931872 | 32I-AM-1013-05 | 32I | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9552861155228 40.788973931872) | |||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9552035011902 40.7889851896334) | |||
1513 | 1513 | -73.96624099976421 | 40.789104293543204 | 28A-PM-1007-03 | 28A | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | chasing #2 took #2 food wrapper and is foraging through it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662409997642 40.7891042935432) | |||
1145 | 1145 | -73.9611446263364 | 40.7911003407299 | 32D-AM-1013-03 | 32D | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611446263364 40.7911003407299) | ||||
1473 | 1473 | -73.9584064190878 | 40.7912992852442 | 33F-PM-1012-03 | 33F | PM | 10122018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9584064190878 40.7912992852442) | ||||
1351 | 1351 | -73.9610985171525 | 40.7913867116989 | 32D-AM-1013-01 | 32D | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9610985171525 40.7913867116989) | ||||
1103 | 1103 | -73.9541500874008 | 40.7920329989756 | 35H-AM-1013-02 | 35H | AM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Sitting on tree limb | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | watching me from tree,but calm | POINT (-73.9541500874008 40.7920329989756) | |
3004 | 3004 | -73.9528482858163 | 40.7922056218325 | 36I-PM-1007-08 | 36I | PM | 10072018 | 8 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9528482858163 40.7922056218325) | ||||
1253 | 1253 | -73.9527227282134 | 40.7935061484064 | 37I-AM-1010-03 | 37I | AM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9527227282134 40.7935061484064) | |||
2802 | 2802 | -73.9533101544112 | 40.7938634280159 | 38H-AM-1019-01 | 38H | AM | 10192018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9533101544112 40.7938634280159) | ||||
2461 | 2461 | -73.9605347462123 | 40.794207544838706 | 35B-AM-1010-04 | 35B | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | lawn | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9605347462123 40.7942075448387) | |||
290 | 290 | -73.95606798644259 | 40.7947887062326 | 37E-PM-1006-06 | 37E | PM | 10062018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9560679864426 40.7947887062326) | ||||
2504 | 2504 | -73.9550131837533 | 40.7958617258176 | 39E-PM-1013-02 | 39E | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail & butt | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9550131837533 40.7958617258176) | |||
525 | 525 | -73.952526164386 | 40.796375924050395 | 40G-AM-1007-02 | 40G | AM | 10072018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 18 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.952526164386 40.7963759240504) | ||||
2696 | 2696 | -73.9501457233643 | 40.797094356558 | 42I-PM-1014-01 | 42I | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9501457233643 40.797094356558) | ||||
2493 | 2493 | -73.954767265558 | 40.7973243644491 | 40E-PM-1017-03 | 40E | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.954767265558 40.7973243644491) | ||||
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) | ||||
1601 | 1601 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (chased by #1),found a nut,buried it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9544278270221 40.7987827316512) | ||
1034 | 1034 | -73.95531638295509 | 40.7988610926249 | 42D-PM-1013-04 | 42D | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Light Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | carrying nut away | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9553163829551 40.7988610926249) |
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 );