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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1597 | 1597 | -73.9789401448556 | 40.76973731414979 | 4B-AM-1010-04 | 04B | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9789401448556 40.7697373141498) | ||||
1704 | 1704 | -73.9624052832372 | 40.7809656348254 | 21H-PM-1018-04 | 21H | PM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9624052832372 40.7809656348254) | ||||
1868 | 1868 | -73.97122650227809 | 40.778379099119206 | 15C-PM-1017-04 | 15C | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9712265022781 40.7783790991192) | ||||
1919 | 1919 | -73.9637440847107 | 40.789142741937205 | 29C-AM-1007-04 | 29C | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9637440847107 40.7891427419372) | ||||
2575 | 2575 | -73.97357533521291 | 40.7687061447032 | 5G-PM-1010-04 | 05G | PM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9735753352129 40.7687061447032) | ||||
644 | 644 | -73.97221256300399 | 40.776131146585705 | 13C-PM-1019-05 | 13C | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.972212563004 40.7761311465857) | ||||
1174 | 1174 | -73.9682067129876 | 40.7779911208015 | 16E-PM-1018-05 | 16E | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | staring | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | approaches (very close) | POINT (-73.9682067129876 40.7779911208015) | ||
1336 | 1336 | -73.97338200536791 | 40.76873304735621 | 5G-PM-1010-05 | 05G | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9733820053679 40.7687330473562) | ||||
1366 | 1366 | -73.97115821991021 | 40.7783674409485 | 15C-PM-1017-05 | 15C | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9711582199102 40.7783674409485) | ||||
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) | |||
2703 | 2703 | -73.9690174442945 | 40.7817617696508 | 19C-PM-1018-05 | 19C | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9690174442945 40.7817617696508) | ||||
594 | 594 | -73.9727488640736 | 40.7781916780621 | 14B-PM-1014-06 | 14B | PM | 10142018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | watching me | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | skittish | POINT (-73.9727488640736 40.7781916780621) | ||
682 | 682 | -73.9651828383592 | 40.780282094386294 | 19F-PM-1017-06 | 19F | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9651828383592 40.7802820943863) | ||||
712 | 712 | -73.9736169886655 | 40.7714942196257 | 7E-AM-1006-06 | 07E | AM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9736169886655 40.7714942196257) | ||||
1862 | 1862 | -73.97648512317541 | 40.771573686286104 | 6C-AM-1007-07 | 06C | AM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | ambling | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | trucks | POINT (-73.9764851231754 40.7715736862861) | ||
1285 | 1285 | -73.97051151894291 | 40.769839557706796 | 7H-AM-1006-08 | 07H | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9705115189429 40.7698395577068) | ||||
2233 | 2233 | -73.9754709117681 | 40.7681421869407 | 3E-AM-1006-08 | 03E | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9754709117681 40.7681421869407) | ||||
1557 | 1557 | -73.9705331808443 | 40.769994357129605 | 7H-AM-1006-09 | 07H | AM | 10062018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9705331808443 40.7699943571296) | ||||||
572 | 572 | -73.97636222692721 | 40.7704671295941 | 5C-PM-1010-10 | 05C | PM | 10102018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | fed by woman | POINT (-73.9763622269272 40.7704671295941) | |||
941 | 941 | -73.9717920322306 | 40.7763095393715 | 13D-AM-1014-10 | 13D | AM | 10142018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9717920322306 40.7763095393715) | ||||
435 | 435 | -73.9702963056917 | 40.7697928730791 | 7H-AM-1006-11 | 07H | AM | 10062018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9702963056917 40.7697928730791) | ||||
136 | 136 | -73.9528682507794 | 40.792580780830704 | 36I-PM-1007-13 | 36I | PM | 10072018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9528682507794 40.7925807808307) | ||||
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) | |||
1257 | 1257 | -73.97672475936541 | 40.772620005419704 | 7B-AM-1008-15 | 07B | AM | 10082018 | 15 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9767247593654 40.7726200054197) |
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 );