2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Date = 10082018, Highlight Fur Color = "White" and Indifferent = 0 sorted by Primary Fur Color

✎ 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, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, Runs from

Foraging ✖

  • 0 14
  • 1 9

Indifferent ✖

Highlight Fur Color ✖

  • White · 23 ✖

Date ✖

  • 10082018 · 23 ✖
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
63 63 -73.9745630038492 40.7692602628745 5E-AM-1008-06 05E AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9745630038492 40.7692602628745)
376 376 -73.9698817079185 40.775832262771104 13E-PM-1008-10 13E PM 10082018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9698817079185 40.7758322627711)
464 464 -73.96644503991209 40.788784490469496 27A-AM-1008-02 27A AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664450399121 40.7887844904695)
897 897 -73.97346875380642 40.769430895922206 6F-PM-1008-04 06F PM 10082018 4 Adult Cinnamon White Cinnamon+White patches of white on haunches Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9734687538064 40.7694308959222)
1290 1290 -73.96681408040659 40.77681001473329 15G-AM-1008-06 15G AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9668140804066 40.7768100147333)
2005 2005 -73.9755259087781 40.770725612418104 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 1 0   1 0 0 0 0 1 0 0   POINT (-73.9755259087781 40.7707256124181)
2886 2886 -73.9729265300533 40.774176829164205 10D-AM-1008-02 10D AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9729265300533 40.7741768291642)
80 80 -73.9688454483585 40.78453012881629 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can 0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9688454483585 40.7845301288163)
342 342 -73.9605966636226 40.788984910863704 30E-AM-1008-01 30E AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scurried into bushes when jogger ran by POINT (-73.9605966636226 40.7889849108637)
382 382 -73.9735946835545 40.7724155751282 8E-PM-1008-01 08E PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE by tree trunk base 0 0 0 1 0   0 0 0 0 0 1 0 0 eating food being thrown at it by a mom & baby POINT (-73.9735946835545 40.7724155751282)
389 389 -73.9733966282316 40.7717179627127 8E-PM-1008-08 08E PM 10082018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9733966282316 40.7717179627127)
436 436 -73.9734695768004 40.7716297491384 8E-PM-1008-05 08E PM 10082018 5 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9734695768004 40.7716297491384)
732 732 -73.9695041366722 40.779787880948206 17D-AM-1008-02 17D AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695041366722 40.7797878809482)
792 792 -73.97301156879641 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9730115687964 40.7741018274312)
879 879 -73.9735120882106 40.7715915415169 8E-PM-1008-07 08E PM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9735120882106 40.7715915415169)
929 929 -73.97386112577159 40.773724677958704 10D-AM-1008-01 10D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 1 0 0 1   POINT (-73.9738611257716 40.7737246779587)
1030 1030 -73.9697526733133 40.7759529849808 13E-PM-1008-09 13E PM 10082018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697526733133 40.7759529849808)
1116 1116 -73.9729847109778 40.774070904960205 10D-AM-1008-03 10D AM 10082018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9729847109778 40.7740709049602)
1534 1534 -73.9695226023739 40.7797527775804 17D-AM-1008-01 17D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695226023739 40.7797527775804)
1644 1644 -73.9734654671008 40.7715988711659 8E-PM-1008-06 08E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9734654671008 40.7715988711659)
2253 2253 -73.973394428186 40.7722933513053 8E-PM-1008-03 08E PM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE in between 2 trees 0 0 0 1 1   0 0 0 0 0 1 0 0 also being lured by mom & baby w/ food POINT (-73.973394428186 40.7722933513053)
2528 2528 -73.96765297807241 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676529780724 40.7823206990549)
3009 3009 -73.9675637870968 40.782388067172796 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9675637870968 40.7823880671728)

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