2018_Central_Park_Squirrel_Census_-_Squirrel_Data

48 rows where Date = 10142018 and Highlight Fur Color = "Cinnamon, White" sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Approaches, Indifferent, Runs from

Tail twitches ✖

  • 0 42
  • 1 6

Highlight Fur Color ✖

  • Cinnamon, White · 48 ✖

Date ✖

  • 10142018 · 48 ✖
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
236 236 -73.9737266070919 40.7786338379896 14A-PM-1014-01 14A PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9737266070919 40.7786338379896)
330 330 -73.9708969246276 40.7767695507462 14D-AM-1014-03 14D AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9708969246276 40.7767695507462)
351 351 -73.97133305944341 40.7771924214236 14D-AM-1014-10 14D AM 10142018 10 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.9713330594434 40.7771924214236)
494 494 -73.958837574505 40.7985003987784 40A-PM-1014-06 40A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.958837574505 40.7985003987784)
531 531 -73.97091043803229 40.7769096957616 14D-AM-1014-16 14D AM 10142018 16 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9709104380323 40.7769096957616)
541 541 -73.9617612388703 40.7952875954297 35A-AM-1014-04 35A AM 10142018 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.9617612388703 40.7952875954297)
726 726 -73.973305698325 40.778382331129606 14A-PM-1014-06 14A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 9   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.973305698325 40.7783823311296)
734 734 -73.9714921188372 40.776758371867 14D-AM-1014-11 14D AM 10142018 11 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.9714921188372 40.776758371867)
826 826 -73.95572635334891 40.7939505791448 37F-PM-1014-02 37F PM 10142018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE LAWN 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95572635334891 40.7939505791448)
835 835 -73.97079005665191 40.777167055008896 14D-AM-1014-09 14D AM 10142018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9707900566519 40.7771670550089)
842 842 -73.9645147011741 40.777256683379896 17I-AM-1014-04 17I AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 1 0   POINT (-73.9645147011741 40.7772566833799)
843 843 -73.97140896474309 40.7767916587915 14D-AM-1014-12 14D AM 10142018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9714089647431 40.7767916587915)
1036 1036 -73.9709207551033 40.7767932008037 14D-AM-1014-04 14D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9709207551033 40.7767932008037)
1104 1104 -73.95898529894859 40.7912720015917 33E-AM-1014-07 33E AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9589852989486 40.7912720015917)
1183 1183 -73.9525699067954 40.7937125788106 38I-PM-1014-01 38I PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE on the lawn East of the fountain 0 0 0 0 0 scampering thru the grass! 0 0 0 0 1 0 0 1   POINT (-73.9525699067954 40.7937125788106)
1223 1223 -73.95912985511109 40.7919612446005 33E-AM-1014-04 33E AM 10142018 4 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9591298551111 40.7919612446005)
1245 1245 -73.9739326393775 40.7779105370473 14A-PM-1014-07 14A PM 10142018 7 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.9739326393775 40.7779105370473)
1295 1295 -73.9709534894049 40.7765964740768 14D-AM-1014-15 14D AM 10142018 15 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9709534894049 40.7765964740768)
1359 1359 -73.97087829663691 40.776946866963 14D-AM-1014-08 14D AM 10142018 8 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.9708782966369 40.77694686696301)
1424 1424 -73.9709722223794 40.7767329646325 14D-AM-1014-06 14D AM 10142018 6 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.9709722223794 40.7767329646325)
1584 1584 -73.9581310602492 40.7960214726964 38C-PM-1014-05 38C PM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#4) 0 0 0 0 0 0 0 1   POINT (-73.9581310602492 40.7960214726964)
1603 1603 -73.95459292421741 40.7986940168685 42D-AM-1014-02 42D AM 10142018 2 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 1 1   0 0 0 0 0 0 1 0   POINT (-73.9545929242174 40.7986940168685)
1639 1639 -73.9736800575584 40.778306973575795 14A-PM-1014-04 14A PM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 0 0 0 0 1 0 1 0   POINT (-73.9736800575584 40.7783069735758)
1686 1686 -73.9593373093799 40.7982428507976 39A-PM-1014-03 39A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. Above Ground 6 Jumped from ground onto branch 0 0 0 0 1 digging? 0 0 0 0 1 0 1 0   POINT (-73.95933730937992 40.7982428507976)
1708 1708 -73.9618486459307 40.7946365810826 35A-AM-1014-02 35A AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9618486459307 40.7946365810826)
1786 1786 -73.9709407456459 40.776423522087 14D-AM-1014-13 14D AM 10142018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9709407456459 40.776423522087)
1791 1791 -73.97109071758341 40.776373910820006 13D-AM-1014-07 13D AM 10142018 7 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.9710907175834 40.77637391082)
1800 1800 -73.970962498391 40.7766899040856 14D-AM-1014-05 14D AM 10142018 5 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.970962498391 40.7766899040856)
1876 1876 -73.973598991549 40.7783020016983 14A-PM-1014-03 14A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#4) 0 0 0 0 0 0 1 0   POINT (-73.973598991549 40.7783020016983)
2039 2039 -73.97083718064292 40.7764813666684 14D-AM-1014-14 14D AM 10142018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708371806429 40.7764813666684)
2054 2054 -73.97263812347471 40.7752694815985 12D-PM-1014-01 12D PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9726381234747 40.7752694815985)
2056 2056 -73.9589600626433 40.7913690265064 33E-AM-1014-08 33E AM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9589600626433 40.7913690265064)
2059 2059 -73.9710026704697 40.776105276462104 13D-AM-1014-04 13D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9710026704697 40.7761052764621)
2086 2086 -73.9525627119429 40.793860286746394 38I-PM-1014-02 38I PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE hanging out w/ Squirrel #1 0 0 0 0 0 scampering w/ squirrel #1 0 0 0 0 1 0 0 1   POINT (-73.9525627119429 40.7938602867464)
2108 2108 -73.9702420100291 40.7772720889907 14D-AM-1014-02 14D AM 10142018 2 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.9702420100291 40.7772720889907)
2195 2195 -73.955352152771 40.7988549523022 42D-AM-1014-01 42D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   0 0 1 1 0   1 0 0 0 0 0 1 0   POINT (-73.955352152771 40.7988549523022)
2251 2251 -73.9587678566254 40.7962656030995 38C-PM-1014-01 38C PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9587678566254 40.7962656030995)
2303 2303 -73.9589470461357 40.7912817646361 33E-AM-1014-10 33E AM 10142018 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9589470461357 40.7912817646361)
2307 2307 -73.9736997033862 40.778497952406 14A-PM-1014-02 14A PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9736997033862 40.778497952406)
2332 2332 -73.9709797467807 40.776909571067904 14D-AM-1014-07 14D AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9709797467807 40.7769095710679)
2653 2653 -73.958932543729 40.7913445531266 33E-AM-1014-11 33E AM 10142018 11 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.958932543729 40.7913445531266)
2655 2655 -73.9659156108069 40.781070981869604 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9659156108069 40.7810709818696)
2849 2849 -73.9709912560997 40.77589655951979 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9709912560997 40.7758965595198)
2901 2901 -73.9735833104203 40.7786318041581 14A-PM-1014-08 14A PM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1 new movement flailing arms while foraging 0 0 0 0 0 0 0 1   POINT (-73.9735833104203 40.7786318041581)
2916 2916 -73.95175251116791 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9517525111679 40.7974407641075)
2922 2922 -73.97034213914421 40.7773706575356 14D-AM-1014-01 14D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9703421391442 40.7773706575356)
2931 2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9730926233232 40.7781330751738)
3013 3013 -73.964661337306 40.7769785494935 17I-AM-1014-03 17I AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon face Above Ground 10   0 0 1 0 0 climbing (dog barked & it ran up tree) 0 0 0 0 0 0 1 0   POINT (-73.964661337306 40.7769785494935)

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 135.045ms