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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1617 | 1617 | -73.97520295136441 | 40.767173466736104 | 3F-AM-1006-04 | 03F | AM | 10062018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on a rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9752029513644 40.7671734667361) | |||
1636 | 1636 | -73.97014086231209 | 40.7695511718541 | 7I-PM-1013-04 | 07I | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Grass | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9701408623121 40.7695511718541) | |||
1725 | 1725 | -73.96574800660741 | 40.7753465489231 | 14I-PM-1018-04 | 14I | PM | 10182018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9657480066074 40.7753465489231) | ||||
2001 | 2001 | -73.9521655419974 | 40.7948785497717 | 39H-AM-1007-04 | 39H | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9521655419974 40.7948785497717) | ||||
2060 | 2060 | -73.9575798004084 | 40.795701403548996 | 38D-PM-1006-04 | 38D | PM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | near drive -runners -cyclists | POINT (-73.95757980040841 40.795701403549) | |||
2156 | 2156 | -73.96503878480009 | 40.7814134438394 | 21F-AM-1018-04 | 21F | AM | 10182018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9650387848001 40.7814134438394) | ||||
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) | ||||
2514 | 2514 | -73.95744422055 | 40.7961046528557 | 38D-AM-1017-04 | 38D | AM | 10172018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95744422055 40.7961046528557) | ||||
2560 | 2560 | -73.97554590905341 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 10202018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | chillin' | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9755459090534 40.7680866624003) | |||
2587 | 2587 | -73.97899712868441 | 40.7707024146365 | 5A-PM-1010-04 | 05A | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9789971286844 40.7707024146365) | ||||
2745 | 2745 | -73.97296259363002 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 10122018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2 | on ledge | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97296259363 40.7652601851275) | ||
2779 | 2779 | -73.9767835160078 | 40.767403033048204 | 2E-PM-1014-04 | 02E | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9767835160078 40.7674030330482) | ||||
2878 | 2878 | -73.969720780557 | 40.774110568875706 | 12F-AM-1020-04 | 12F | AM | 10202018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.969720780557 40.7741105688757) | ||||
2895 | 2895 | -73.9747873899653 | 40.77319452583271 | 9C-PM-1006-04 | 09C | PM | 10062018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9747873899653 40.7731945258327) | ||||
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) | |||
256 | 256 | -73.976798124308 | 40.774131657411296 | 9A-PM-1010-04 | 09A | PM | 10102018 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97679812430802 40.7741316574113) | ||||||
375 | 375 | -73.9752000129992 | 40.773291812223896 | 8C-PM-1013-04 | 08C | PM | 10132018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752000129992 40.7732918122239) | ||||
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) | ||||||
805 | 805 | -73.97068515461841 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 10172018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706851546184 40.7780777016038) | ||||
971 | 971 | -73.978392591149 | 40.7668993398193 | 1D-PM-1007-04 | 01D | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.978392591149 40.7668993398193) | ||||
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) | ||
1056 | 1056 | -73.98110784424621 | 40.767515940567 | 1A-AM-1007-04 | 01A | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9811078442462 40.767515940567) | ||||
1177 | 1177 | -73.98078982247259 | 40.768215817511 | 1A-PM-1014-04 | 01A | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9807898224726 40.768215817511) | ||||
1246 | 1246 | -73.9543044385367 | 40.7984498571338 | 41E-AM-1007-04 | 41E | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white haunches/tail | Ground Plane | FALSE | rubbing belly on ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9543044385367 40.798449857133804) | ||
1282 | 1282 | -73.974451175321 | 40.770129463526395 | 6E-PM-1010-04 | 06E | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 1 | 0 | 1 | 0 | chasing #3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974451175321 40.7701294635264) | |
1457 | 1457 | -73.9697744662785 | 40.775595042897294 | 13F-AM-1007-04 | 13F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9697744662785 40.7755950428973) | ||||
1492 | 1492 | -73.9807078515193 | 40.768333529264204 | 2A-AM-1010-04 | 02A | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9807078515193 40.7683335292642) | ||||
1961 | 1961 | -73.953664715831 | 40.7981256393159 | 41E-PM-1013-04 | 41E | PM | 10132018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.953664715831 40.7981256393159) | ||||
2309 | 2309 | -73.966824257293 | 40.775340537786896 | 14H-PM-1012-04 | 14H | PM | 10122018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.966824257293 40.7753405377869) | ||||
2367 | 2367 | -73.9681671864047 | 40.7753770538635 | 14G-AM-1012-04 | 14G | AM | 10122018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9681671864047 40.7753770538635) | ||||
2404 | 2404 | -73.96653096896159 | 40.7775271020244 | 16G-AM-1010-04 | 16G | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665309689616 40.7775271020244) | ||||
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) | |||
2478 | 2478 | -73.96749310703241 | 40.778369369095394 | 17F-AM-1007-04 | 17F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 4 | 0 | 0 | 0 | 1 | 0 | chilling | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9674931070324 40.7783693690954) | |||
2521 | 2521 | -73.976869549792 | 40.770698245472296 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | 0 | 0 | 0 | 0 | 0 | relaxing | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.976869549792 40.7706982454723) | ||
2752 | 2752 | -73.972069937746 | 40.765940262783204 | 3I-PM-1013-04 | 03I | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97206993774601 40.7659402627832) | ||||
2753 | 2753 | -73.96810908249779 | 40.783827583032796 | 22B-PM-1014-04 | 22B | PM | 10142018 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9681090824978 40.7838275830328) | |||||
2952 | 2952 | -73.9763719445827 | 40.768955141333706 | 4D-PM-1008-04 | 04D | PM | 10082018 | 4 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9763719445827 40.7689551413337) |
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 );