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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2880 | 2880 | -73.9726598256924 | 40.7707862446236 | 7F-PM-1012-03 | 07F | PM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9726598256924 40.7707862446236) | |||
1001 | 1001 | -73.9801985977846 | 40.768015951170504 | 1B-AM-1012-11 | 01B | AM | 10122018 | 11 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | fighting w/ pigeons | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801985977846 40.7680159511705) | |||
1456 | 1456 | -73.97142424264959 | 40.774453579812295 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | foraging (foraged,ran to tree root,munched) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714242426496 40.7744535798123) | |||
2666 | 2666 | -73.9763593390732 | 40.771729705854895 | 7C-AM-1012-03 | 07C | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | foraging (loving the acorns!) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97635933907321 40.7717297058549) | |||
2372 | 2372 | -73.9724879969884 | 40.771098202397 | 8F-PM-1012-07 | 08F | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 17 | 0 | 0 | 1 | 0 | 0 | gathering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9724879969884 40.771098202397) | |||
2051 | 2051 | -73.9544808708211 | 40.7906575852286 | 34I-AM-1012-02 | 34I | AM | 10122018 | 2 | Adult | Gray | White | Gray+White | Short tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hiding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9544808708211 40.7906575852286) | ||
2808 | 2808 | -73.9765027953575 | 40.7717327360835 | 7C-AM-1012-02 | 07C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping around | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765027953575 40.7717327360835) | |||
2627 | 2627 | -73.97663480786329 | 40.7717715634438 | 7C-AM-1012-01 | 07C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping around grass | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766348078633 40.7717715634438) | |||
324 | 324 | -73.9587879699956 | 40.7908135158551 | 32F-AM-1012-01 | 32F | AM | 10122018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | made a back-door escape from dog off-leash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587879699956 40.7908135158551) | ||||
2480 | 2480 | -73.9546780963388 | 40.790321652211105 | 34I-AM-1012-03 | 34I | AM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | nut in mouth | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9546780963388 40.7903216522111) | |||
1697 | 1697 | -73.9568610943394 | 40.7935959584643 | 36E-PM-1012-02 | 36E | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 28 | on tree branch | 0 | 0 | 1 | 0 | 1 | picking acorns off oak tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95686109433942 40.7935959584643) | |||
1292 | 1292 | -73.959019987128 | 40.791254669180496 | 33E-PM-1012-05 | 33E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.959019987128 40.7912546691805) | |||
1547 | 1547 | -73.958939037549 | 40.7913193931203 | 33E-PM-1012-04 | 33E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958939037549 40.7913193931203) | |||
1805 | 1805 | -73.9590328527128 | 40.791221441757706 | 33E-PM-1012-06 | 33E | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9590328527128 40.7912214417577) | |||
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) | ||
1165 | 1165 | -73.9689504114652 | 40.77667701537639 | 14F-PM-1012-05 | 14F | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2 | on a fallen branch | 1 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looking at me | POINT (-73.9689504114652 40.7766770153764) | |
1332 | 1332 | -73.97749282457809 | 40.7720464606979 | 6B-AM-1012-02 | 06B | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | by bike racks at Tavern on the Green | 0 | 0 | 0 | 0 | 1 | walking,exploring - digging in flower bed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9774928245781 40.7720464606979) | ||
2390 | 2390 | -73.9680741975294 | 40.7847036778165 | 23B-PM-1012-04 | 23B | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | watching me - didn't move | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9680741975294 40.7847036778165) |
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 );