This data as json, CSV (advanced)
Location ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2030 | 2030 | -73.9749251267433 | 40.7679111971294 | 4F-PM-1013-01 | 04F | PM | 10132018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9749251267433 40.7679111971294) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 232 | 232 | -73.9624184586031 | 40.7921524868211 | 32B-AM-1017-03 | 32B | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | approaches (primarily),runs from (initially),follows | POINT (-73.9624184586031 40.7921524868211) | |||
| 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) | ||||
| 1057 | 1057 | -73.9594406225891 | 40.7918533707789 | 33D-AM-1017-02 | 33D | AM | 10172018 | 2 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594406225891 40.7918533707789) | ||||
| 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) | ||||
| 1111 | 1111 | -73.96327993398721 | 40.7808316436308 | 21H-PM-1018-01 | 21H | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | staring | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9632799339872 40.7808316436308) | |||
| 1312 | 1312 | -73.97120343207409 | 40.7764415506669 | 13D-PM-1018-05 | 13D | PM | 10182018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9712034320741 40.7764415506669) | |||
| 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) | ||||
| 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) | ||||
| 53 | 53 | -73.95849706432129 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9584970643213 40.7982886348696) | ||||
| 482 | 482 | -73.97217978245759 | 40.7801213843628 | 16A-PM-1019-07 | 16A | PM | 10192018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | approaches (very friendly) | POINT (-73.9721797824576 40.7801213843628) | |||
| 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) | ||||
| 1196 | 1196 | -73.95801114962751 | 40.7985365971474 | 40B-AM-1019-05 | 40B | AM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9580111496275 40.7985365971474) |
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 );