This data as json, CSV (advanced)
Suggested facets: Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
157 | 157 | -73.9637946878735 | 40.791570044687795 | 31A-AM-1010-04 | 31A | AM | 10102018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9637946878735 40.7915700446878) | ||||
163 | 163 | -73.97123088643941 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 0 | 0 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712308864394 40.7714534847379) | |||
349 | 349 | -73.9689657039917 | 40.776783427676705 | 15F-AM-1007-04 | 15F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9689657039917 40.7767834276767) | ||||
537 | 537 | -73.9682803241007 | 40.772451055832704 | 11H-AM-1010-04 | 11H | AM | 10102018 | 4 | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9682803241007 40.7724510558327) | |||||||
589 | 589 | -73.97826438139 | 40.7717086090782 | 6A-AM-1006-04 | 06A | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | curious | POINT (-73.97826438139 40.7717086090782) | |||
1246 | 1246 | -73.9543044385367 | 40.7984498571338 | 41E-AM-1007-04 | 41E | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white haunches/tail | Ground Plane | FALSE | rubbing belly on ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9543044385367 40.798449857133804) | ||
1302 | 1302 | -73.9704024529864 | 40.772925606388895 | 10G-AM-1006-04 | 10G | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#3) | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9704024529864 40.7729256063889) | |||
1453 | 1453 | -73.9555856074105 | 40.7969457685677 | 40E-AM-1014-04 | 40E | AM | 10142018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | on rocks/bushy rocks | 1 | 0 | 0 | 0 | 0 | hiding from bird | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9555856074105 40.79694576856771) | ||
1529 | 1529 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9692401421068 40.7707128895661) | ||||
1663 | 1663 | -73.96967203626271 | 40.779185159819704 | 17D-AM-1008-04 | 17D | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9696720362627 40.7791851598197) | ||||
1709 | 1709 | -73.9771696835698 | 40.76970111004871 | 4C-AM-1006-04 | 04C | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771696835698 40.7697011100487) | ||||
1901 | 1901 | -73.9680237209555 | 40.771702220822505 | 10I-AM-1010-04 | 10I | AM | 10102018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9680237209555 40.7717022208225) | ||||
2103 | 2103 | -73.9782983634755 | 40.766831436426294 | 1D-AM-1006-04 | 01D | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9782983634755 40.7668314364263) | ||||
2340 | 2340 | -73.9730284815849 | 40.7702462529502 | 7F-AM-1008-04 | 07F | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | bush | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730284815849 40.7702462529502) | |||
2355 | 2355 | -73.9728654439465 | 40.7724853142211 | 9E-AM-1008-04 | 09E | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728654439465 40.7724853142211) | ||||
2478 | 2478 | -73.96749310703241 | 40.778369369095394 | 17F-AM-1007-04 | 17F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 4 | 0 | 0 | 0 | 1 | 0 | chilling | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9674931070324 40.7783693690954) | |||
2613 | 2613 | -73.96393252683 | 40.7808289765857 | 21G-AM-1014-04 | 21G | AM | 10142018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 6 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96393252683 40.7808289765857) | ||||
2906 | 2906 | -73.9597260014375 | 40.790707423031 | 32E-AM-1007-04 | 32E | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9597260014375 40.790707423031) | ||||
2918 | 2918 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.76554155159081) | |||||
29 | 29 | -73.96717867152559 | 40.7867352791232 | 25A-AM-1013-04 | 25A | AM | 10132018 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9671786715256 40.7867352791232) | |||||
421 | 421 | -73.9664630067791 | 40.775636151582496 | 14H-AM-1007-04 | 14H | AM | 10072018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9664630067791 40.7756361515825) | ||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9624538733037 40.7883829851518) | ||||
743 | 743 | -73.9565035705619 | 40.7937382705056 | 36F-AM-1017-04 | 36F | AM | 10172018 | 4 | Juvenile | Gray | White | Gray+White | White legs, front & back | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | approaches (me),runs from (me) | POINT (-73.9565035705619 40.7937382705056) | ||
1356 | 1356 | -73.9534910562766 | 40.7935774443789 | 37H-AM-1018-04 | 37H | AM | 10182018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | was with a lot of robins | POINT (-73.9534910562766 40.7935774443789) | |||
1617 | 1617 | -73.97520295136441 | 40.767173466736104 | 3F-AM-1006-04 | 03F | AM | 10062018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on a rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9752029513644 40.7671734667361) | |||
1767 | 1767 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 10142018 | 4 | Gray | White | Gray+White | Above Ground | 15 | Ground then tree to eat | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.958719099962 40.7947587726617) | ||||
2094 | 2094 | -73.9701630539326 | 40.7779553961101 | 15D-AM-1007-04 | 15D | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97016305393261 40.7779553961101) |
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 );