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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
238 | 238 | -73.9760942252437 | 40.7742035674209 | 9B-PM-1013-07 | 09B | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97609422524371 40.7742035674209) | ||||
248 | 248 | -73.9751729403694 | 40.774328412311796 | 10B-PM-1014-02 | 10B | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | gingko tree by traffic light in front of Strawberry Fields | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | came over on tree to see me then disappeared | POINT (-73.9751729403694 40.7743284123118) | |||
278 | 278 | -73.9787796921165 | 40.7707526535381 | 5A-PM-1010-01 | 05A | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9787796921165 40.7707526535381) | ||||
376 | 376 | -73.9698817079185 | 40.775832262771104 | 13E-PM-1008-10 | 13E | PM | 10082018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9698817079185 40.7758322627711) | ||||
431 | 431 | -73.97574360194321 | 40.774606436322706 | 10B-PM-1014-01 | 10B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | on lawn in front of a tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | stay on ground but went to other side of tree to hide from a dog | POINT (-73.9757436019432 40.7746064363227) | ||
762 | 762 | -73.96792913479558 | 40.7846973096665 | 23B-PM-1012-02 | 23B | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 2/3 were chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9679291347956 40.7846973096665) | |||
839 | 839 | -73.9615602805554 | 40.7945662185621 | 35A-PM-1013-08 | 35A | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9615602805554 40.7945662185621) | ||||
1106 | 1106 | -73.97029709193171 | 40.7696883113413 | 7H-PM-1006-08 | 07H | PM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9702970919317 40.7696883113413) | |||
1283 | 1283 | -73.9566785136491 | 40.7963368332834 | 39D-PM-1012-02 | 39D | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9566785136491 40.7963368332834) | ||||
1315 | 1315 | -73.9595955824812 | 40.793304794353396 | 34D-PM-1007-01 | 34D | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9595955824812 40.7933047943534) | ||||
1421 | 1421 | -73.9595022290348 | 40.7831151330074 | 25I-PM-1007-02 | 25I | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | white belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | POINT (-73.9595022290348 40.783115133007406) | |||
1660 | 1660 | -73.98004994980342 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9800499498034 40.770218109957305) | |||
1730 | 1730 | -73.97961428483491 | 40.7702117898305 | 4A-PM-1007-04 | 04A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9796142848349 40.7702117898305) | ||||
1914 | 1914 | -73.9588714413332 | 40.7895787115444 | 31F-PM-1007-03 | 31F | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | white belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9588714413332 40.7895787115444) | |||
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) | ||||
2040 | 2040 | -73.96481673340891 | 40.7811164976329 | 20F-PM-1007-02 | 20F | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | white on tail | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | digging one hole w/ determination | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.96481673340891 40.7811164976329) | ||
2088 | 2088 | -73.96511558803459 | 40.790694632578 | 30A-PM-1020-01 | 30A | PM | 10202018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9651155880346 40.790694632578) | ||||
2099 | 2099 | -73.9685612289881 | 40.7778488829217 | 16E-PM-1018-08 | 16E | PM | 10182018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9685612289881 40.7778488829217) | ||||
2157 | 2157 | -73.9657171357842 | 40.7773277532224 | 16H-PM-1014-05 | 16H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 5 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9657171357842 40.7773277532224) | |||
2278 | 2278 | -73.96453903109901 | 40.78099163100121 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.964539031099 40.7809916310012) | ||||
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) | ||||
2326 | 2326 | -73.9691692160865 | 40.7725330502929 | 10H-PM-1007-02 | 10H | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9691692160865 40.7725330502929) | ||||
2328 | 2328 | -73.9678620840741 | 40.784719027304 | 23B-PM-1012-03 | 23B | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 2/3 were chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.96786208407411 40.784719027304) | |||
2353 | 2353 | -73.963623175585 | 40.7927451068919 | 32A-PM-1013-04 | 32A | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.963623175585 40.7927451068919) | ||||
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) | |||
2430 | 2430 | -73.9569811285656 | 40.793091234605 | 35F-PM-1012-02 | 35F | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9569811285656 40.793091234605) | ||||
2529 | 2529 | -73.98002714878629 | 40.7702554167042 | 4A-PM-1007-06 | 04A | PM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | A rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9800271487863 40.7702554167042) | |||
2532 | 2532 | -73.9695150319891 | 40.782613519363 | 20B-PM-1013-04 | 20B | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | chased a bird carrying massive wad of grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9695150319891 40.782613519363) | |||
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) | ||||
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) |
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 );