2018_Central_Park_Squirrel_Census_-_Squirrel_Data

161 rows where Date = 10122018 and Runs from = 0 sorted by Lat/Long descending

✎ View and edit SQL

This data as json, CSV (advanced)

Runs from ✖

Moans ✖

  • 0 61

Date ✖

  • 10122018 · 61 ✖
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 ▲
1487 1487 -73.96539465596099 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1 burying the food on ground 0 0 0 0 0 0 0 0 look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)
1641 1641 -73.96531352771491 40.7817434070169 21E-PM-1012-01 21E PM 10122018 1 Adult Gray   Gray+   Above Ground 20 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653135277149 40.7817434070169)
328 328 -73.96523572796708 40.781929688714705 21E-PM-1012-02 21E PM 10122018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9652357279671 40.7819296887147)
1706 1706 -73.965215665278 40.7761309082202 15I-PM-1012-02 15I PM 10122018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.965215665278 40.7761309082202)
125 125 -73.9651601541795 40.7761841788025 15I-PM-1012-07 15I PM 10122018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9651601541795 40.7761841788025)
2147 2147 -73.9651217998407 40.7761115392738 15I-PM-1012-01 15I PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9651217998407 40.7761115392738)
1991 1991 -73.965059909327 40.776213188679705 15I-PM-1012-06 15I PM 10122018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.965059909327 40.7762131886797)
1962 1962 -73.9647318357023 40.7760936175332 15I-PM-1012-04 15I PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9647318357023 40.7760936175332)
179 179 -73.9646901432328 40.775995869679 15I-PM-1012-03 15I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9646901432328 40.775995869679)
2900 2900 -73.9631005470369 40.788549405719294 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9631005470369 40.7885494057193)
1845 1845 -73.9626560807032 40.7884633049896 28D-AM-1012-05 28D AM 10122018 5 Juvenile Black   Black+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9626560807032 40.7884633049896)
1516 1516 -73.9625383795297 40.7883862331728 28D-AM-1012-03 28D AM 10122018 3 Adult Black   Black+   Above Ground 30   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9625383795297 40.7883862331728)
2652 2652 -73.96205425147491 40.794373172213795 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9620542514749 40.7943731722138)
1576 1576 -73.96199851876159 40.79432777435321 34A-AM-1012-02 34A AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9619985187616 40.7943277743532)
565 565 -73.9615402629655 40.7924082330328 33C-AM-1012-02 33C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along back & tail Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615402629655 40.7924082330328)
2872 2872 -73.96153964579959 40.792359436678296 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615396457996 40.7923594366783)
1690 1690 -73.96052295327 40.7934359372871 34C-PM-1012-04 34C PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.96052295327 40.7934359372871)
1447 1447 -73.9601968065017 40.7935831836482 34C-PM-1012-03 34C PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9601968065017 40.79358318364821)
1781 1781 -73.96005650463 40.793404850298295 34C-PM-1012-02 34C PM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96005650463 40.7934048502983)
2638 2638 -73.9598973337711 40.793334636047796 34C-PM-1012-01 34C PM 10122018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9598973337711 40.7933346360478)
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree 1 1 0 0 0   0 0 0 1 1 0 1 0   POINT (-73.9595222999173 40.7833202577782)
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map 1 1 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9594986107981 40.7840083040604)
1138 1138 -73.9594357049738 40.7840678890949 25I-AM-1012-01 25I AM 10122018 1 Adult Cinnamon   Cinnamon+   Above Ground 4 on bar 0 0 0 1 0   0 0 0 1 1 1 0 0   POINT (-73.9594357049738 40.7840678890949)
1805 1805 -73.9590328527128 40.791221441757706 33E-PM-1012-06 33E PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9590328527128 40.7912214417577)
1292 1292 -73.959019987128 40.791254669180496 33E-PM-1012-05 33E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.959019987128 40.7912546691805)
1249 1249 -73.9590132705889 40.7952248279764 37C-AM-1012-03 37C AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9590132705889 40.7952248279764)
2447 2447 -73.9589670987899 40.795212703928705 37C-AM-1012-04 37C AM 10122018 4 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9589670987899 40.7952127039287)
1477 1477 -73.9589635326362 40.7951748673846 37C-AM-1012-02 37C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks, light band across nose Ground Plane FALSE   0 0 0 0 1 caching 0 0 0 0 0 0 1 0   POINT (-73.9589635326362 40.7951748673846)
1547 1547 -73.958939037549 40.7913193931203 33E-PM-1012-04 33E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 playing 0 0 0 0 0 0 0 0   POINT (-73.958939037549 40.7913193931203)
2250 2250 -73.95890163858891 40.7911727679625 33E-PM-1012-03 33E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9589016385889 40.7911727679625)
698 698 -73.95855376683821 40.7903905787005 32F-AM-1012-03 32F AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0 bringing green leaves to nest 0 0 0 0 0 0 0 0   POINT (-73.9585537668382 40.7903905787005)
1744 1744 -73.9584661589182 40.791206838084506 33F-PM-1012-01 33F PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9584661589182 40.7912068380845)
2511 2511 -73.95845615374209 40.791121116475395 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 1 0 0 0   POINT (-73.9584561537421 40.7911211164754)
772 772 -73.95841884610591 40.7913241048498 33E-PM-1012-07 33E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9584188461059 40.7913241048498)
1473 1473 -73.9584064190878 40.7912992852442 33F-PM-1012-03 33F PM 10122018 3 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9584064190878 40.7912992852442)
2214 2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9583688637255 40.791388958496)
740 740 -73.95834778506341 40.7914073632782 33F-PM-1012-06 33F PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 1 1   1 0 0 0 1 0 0 0   POINT (-73.9583477850634 40.7914073632782)
2113 2113 -73.95829048146521 40.790591574956395 32F-AM-1012-04 32F AM 10122018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9582904814652 40.7905915749564)
1435 1435 -73.9582534432858 40.7917772296796 34F-PM-1012-01 34F PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9582534432858 40.7917772296796)
2002 2002 -73.9581706950566 40.790632139726895 32F-AM-1012-05 32F AM 10122018 5 Adult Gray White Gray+White   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9581706950566 40.7906321397269)
907 907 -73.95806099213101 40.7907158878729 32F-AM-1012-06 32F AM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.958060992131 40.7907158878729)
2057 2057 -73.9579659543224 40.7905646887034 32F-AM-1012-07 32F AM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9579659543224 40.7905646887034)
1284 1284 -73.95708916967759 40.793544880224104 36E-PM-1012-01 36E PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9570891696776 40.7935448802241)
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)
1697 1697 -73.9568610943394 40.7935959584643 36E-PM-1012-02 36E PM 10122018 2 Adult Gray   Gray+   Above Ground 28 on tree branch 0 0 1 0 1 picking acorns off oak tree 0 0 0 0 0 0 1 0   POINT (-73.95686109433942 40.7935959584643)
2019 2019 -73.9566705412766 40.7935560645735 36F-PM-1012-01 36F PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Near rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9566705412766 40.7935560645735)
2232 2232 -73.9566277721581 40.7966674587803 39D-PM-1012-04 39D PM 10122018 4 Juvenile Gray White Gray+White   Above Ground 10 on tree trunk (descending from height of ~10 ft) 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.95662777215811 40.7966674587803)
880 880 -73.95656845779891 40.79360039404129 36F-PM-1012-02 36F PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9565684577989 40.7936003940413)
2860 2860 -73.95651796713192 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.95651796713192 40.7936663940365)
2691 2691 -73.9564599077179 40.7965185098695 39D-PM-1012-01 39D PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9564599077179 40.7965185098695)
2306 2306 -73.956453902485 40.7936584431012 36F-PM-1012-05 36F PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.956453902485 40.7936584431012)
2617 2617 -73.9564228238736 40.7936908887644 36F-PM-1012-06 36F PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9564228238736 40.7936908887644)
549 549 -73.9549082481152 40.7933537584624 36G-PM-1012-01 36G PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 crossing east drive 0 0 0 0 0 0 0 0   POINT (-73.9549082481152 40.7933537584624)
2480 2480 -73.9546780963388 40.790321652211105 34I-AM-1012-03 34I AM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 nut in mouth 0 0 0 0 0 0 1 0   POINT (-73.9546780963388 40.7903216522111)
1710 1710 -73.95454386561221 40.7902168635009 34I-AM-1012-04 34I AM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9545438656122 40.7902168635009)
2231 2231 -73.95454276114769 40.793035381744104 36G-PM-1012-02 36G PM 10122018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9545427611477 40.7930353817441)
2600 2600 -73.9544553697736 40.7912866208106 34I-AM-1012-01 34I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9544553697736 40.7912866208106)
2155 2155 -73.9538938706987 40.7981150065974 42E-PM-1012-05 42E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538938706987 40.7981150065974)
2277 2277 -73.95385121459 40.7981257651433 42E-PM-1012-04 42E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95385121459 40.7981257651433)
2069 2069 -73.9538377039825 40.798060533496106 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 0 1   1 0 0 0 0 0 1 0   POINT (-73.9538377039825 40.7980605334961)
2089 2089 -73.9535980341677 40.7981186822179 42E-PM-1012-01 42E PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9535980341677 40.7981186822179)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);
Powered by Datasette · Query took 12.582ms