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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1323 | 1323 | -73.97443873476259 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744387347626 40.7776953143835) | |||||||
1282 | 1282 | -73.974451175321 | 40.770129463526395 | 6E-PM-1010-04 | 06E | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 1 | 0 | 1 | 0 | chasing #3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974451175321 40.7701294635264) | |
2946 | 2946 | -73.974515099169 | 40.770065079988605 | 6E-PM-1010-03 | 06E | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 1 | 0 | 1 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974515099169 40.770065079988605) | |
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) | |||||
2351 | 2351 | -73.97458184501092 | 40.765449887362706 | 1G-AM-1006-01 | 01G | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745818450109 40.7654498873627) | |||||
1417 | 1417 | -73.974828939898 | 40.7668886121909 | 2F-PM-1014-11 | 02F | PM | 10142018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974828939898 40.7668886121909) | |||||
2542 | 2542 | -73.9754802138871 | 40.773300804411996 | 9C-PM-1006-03 | 09C | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754802138871 40.773300804412) | ||||
2298 | 2298 | -73.97553718499721 | 40.7733561233828 | 9C-PM-1006-02 | 09C | PM | 10062018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755371849972 40.7733561233828) | ||||
336 | 336 | -73.97574132156208 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757413215621 40.7692582758978) | |||||
2845 | 2845 | -73.9765016413674 | 40.77406728629529 | 9A-AM-1013-06 | 09A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765016413674 40.7740672862953) | ||||
1705 | 1705 | -73.97654172820009 | 40.7740994735325 | 9A-AM-1013-05 | 09A | AM | 10132018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765417282001 40.7740994735325) | ||||
1142 | 1142 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 10082018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765805609072 40.7692807820935) | |||
2990 | 2990 | -73.97660121083071 | 40.7712310725379 | 6C-AM-1007-05 | 06C | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 1 | 1 | 0 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766012108307 40.7712310725379) | ||||
2988 | 2988 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766342759486 40.7687518380873) | ||||
2248 | 2248 | -73.9766477027266 | 40.7712737417779 | 6C-AM-1007-04 | 06C | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 1 | 1 | 0 | 0 | chasing #5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766477027266 40.7712737417779) | ||||
2598 | 2598 | -73.976658503418 | 40.768686845691704 | 4D-AM-1012-03 | 04D | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.976658503418 40.7686868456917) | |||||
2919 | 2919 | -73.9768563402344 | 40.7744487310786 | 9A-AM-1013-12 | 09A | AM | 10132018 | 12 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | foot of tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768563402344 40.7744487310786) | |||
596 | 596 | -73.9769319450348 | 40.7743883576247 | 9A-AM-1013-11 | 09A | AM | 10132018 | 11 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | foot of tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9769319450348 40.7743883576247) | |||
2917 | 2917 | -73.9770313887741 | 40.7724869252099 | 7B-AM-1008-05 | 07B | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770313887741 40.772486925209904) | ||||||
873 | 873 | -73.9770948563006 | 40.7724063459185 | 7B-AM-1008-04 | 07B | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770948563006 40.7724063459185) | |||||
747 | 747 | -73.97714226252741 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771422625274 40.772361415776) | |||||
811 | 811 | -73.9771695272048 | 40.772427727626294 | 7B-AM-1008-03 | 07B | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771695272048 40.7724277276263) | |||||
1448 | 1448 | -73.9772810073685 | 40.7693577540392 | 4C-PM-1010-03 | 04C | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772810073685 40.7693577540392) | ||||
729 | 729 | -73.97760445784459 | 40.7697607308033 | 4C-PM-1010-15 | 04C | PM | 10102018 | 15 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree | 0 | 1 | 0 | 0 | 0 | chasing #14 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9776044578446 40.7697607308033) | |||
1847 | 1847 | -73.9782283921819 | 40.766793260207706 | 1D-PM-1007-02 | 01D | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9782283921819 40.7667932602077) | ||||
575 | 575 | -73.9783366903829 | 40.7668300056094 | 1D-PM-1007-03 | 01D | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783366903829 40.7668300056094) | ||||
640 | 640 | -73.97855365291359 | 40.7716184505002 | 6A-PM-1012-07 | 06A | PM | 10122018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | elevated ground | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9785536529136 40.771618450500206) | |||
2591 | 2591 | -73.9786351029146 | 40.771611416400205 | 6A-PM-1012-06 | 06A | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9786351029146 40.771611416400205) | |||
1166 | 1166 | -73.980048119915 | 40.7676638655026 | 1B-AM-1012-06 | 01B | AM | 10122018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980048119915 40.7676638655026) | ||||
255 | 255 | -73.9800669115792 | 40.767682513438395 | 1B-AM-1012-07 | 01B | AM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800669115792 40.7676825134384) | ||||
2106 | 2106 | -73.9801651470389 | 40.767769865693495 | 1B-AM-1012-05 | 01B | AM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801651470389 40.7677698656935) | ||||
2369 | 2369 | -73.9801956082236 | 40.767836440957 | 1B-AM-1012-08 | 01B | AM | 10122018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801956082236 40.767836440957) | ||||
1100 | 1100 | -73.98054238861499 | 40.768204880479395 | 1B-AM-1012-14 | 01B | AM | 10122018 | 14 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980542388615 40.7682048804794) |
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 );