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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2117 | 2117 | -73.9597192455543 | 40.7973316178661 | 38A-AM-1019-03 | 38A | AM | 10192018 | 3 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | stood on back legs | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | POINT (-73.9597192455543 40.7973316178661) | ||
2131 | 2131 | -73.9752225195115 | 40.7703747669865 | 6D-PM-1020-05 | 06D | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9752225195115 40.7703747669865) | |||||
2149 | 2149 | -73.9691845420174 | 40.7707749899254 | 9I-AM-1014-03 | 09I | AM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9691845420174 40.7707749899254) | |||||
2161 | 2161 | -73.9715375915057 | 40.7751212088827 | 12D-AM-1013-01 | 12D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9715375915057 40.7751212088827) | ||||
2187 | 2187 | -73.96991340526091 | 40.774446589038 | 12F-PM-1007-14 | 12F | PM | 10072018 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9699134052609 40.774446589038) | ||||
2196 | 2196 | -73.96233563694321 | 40.7888693815168 | 29D-AM-1014-05 | 29D | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rocky area | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9623356369432 40.7888693815168) | |||
2253 | 2253 | -73.973394428186 | 40.7722933513053 | 8E-PM-1008-03 | 08E | PM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in between 2 trees | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | also being lured by mom & baby w/ food | POINT (-73.973394428186 40.7722933513053) | ||
2275 | 2275 | -73.96142184133559 | 40.793894505879294 | 34B-AM-1013-01 | 34B | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9614218413356 40.7938945058793) | |||
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) | ||||
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) | ||||
2333 | 2333 | -73.9771924901559 | 40.766672272947105 | 1E-PM-1007-01 | 01E | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | people feeding squirrel | POINT (-73.9771924901559 40.7666722729471) | |||
2358 | 2358 | -73.9788379085607 | 40.7683896583055 | 2C-PM-1013-06 | 02C | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | cleaning face & tail | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9788379085607 40.7683896583055) | |||
2428 | 2428 | -73.9755643404768 | 40.769756914938796 | 5E-PM-1012-03 | 05E | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9755643404768 40.7697569149388) | ||||
2590 | 2590 | -73.9568524771058 | 40.7974664985551 | 40C-PM-1006-06 | 40C | PM | 10062018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | By The Road | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9568524771058 40.7974664985551) | ||||
2610 | 2610 | -73.9713379914423 | 40.7696367609606 | 7H-PM-1006-01 | 07H | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | middle of grass | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9713379914423 40.7696367609606) | |||
2670 | 2670 | -73.95310419064691 | 40.7919916819219 | 36I-PM-1007-02 | 36I | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | chased birds (blue jay) | POINT (-73.9531041906469 40.7919916819219) | ||||
2685 | 2685 | -73.9601851468038 | 40.7968698151479 | 38A-AM-1019-05 | 38A | AM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon head, White belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | standing on back legs | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9601851468038 40.7968698151479) | ||
2750 | 2750 | -73.957775998085 | 40.7932880937406 | 35E-PM-1006-05 | 35E | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.957775998085 40.7932880937406) | |||||
2782 | 2782 | -73.9563473341712 | 40.7893712398425 | 32H-PM-1006-03 | 32H | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9563473341712 40.78937123984251) | ||||
2816 | 2816 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) | |||
2856 | 2856 | -73.9751615527833 | 40.767013871509 | 3F-AM-1006-03 | 03F | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | on the path | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9751615527833 40.767013871509) | ||
2922 | 2922 | -73.97034213914421 | 40.7773706575356 | 14D-AM-1014-01 | 14D | AM | 10142018 | 1 | 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.9703421391442 40.7773706575356) | ||||
2928 | 2928 | -73.9767953468937 | 40.7676376977667 | 3E-AM-1006-03 | 03E | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | checkin' his stashes | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | POINT (-73.9767953468937 40.7676376977667) | |||
2931 | 2931 | -73.9730926233232 | 40.7781330751738 | 14B-PM-1014-08 | 14B | PM | 10142018 | 8 | Gray | Cinnamon, White | Gray+Cinnamon, White | White belly & stripes on tail, Cinnamon face & stripes on back | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9730926233232 40.7781330751738) | ||||
2932 | 2932 | -73.9705837974358 | 40.775849484967296 | 13E-AM-1017-13 | 13E | AM | 10172018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | on rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.97058379743581 40.7758494849673) | |||
2957 | 2957 | -73.97473131521521 | 40.7653888351839 | 1G-PM-1010-03 | 01G | PM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9747313152152 40.7653888351839) |
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 );