2018_Central_Park_Squirrel_Census_-_Squirrel_Data

24 rows where Date = 10182018, Highlight Fur Color = "Cinnamon" and Indifferent = 0 sorted by Location descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Approaches, Runs from

Tail twitches ✖

  • 0 20
  • 1 4

Indifferent ✖

Highlight Fur Color ✖

  • Cinnamon · 24 ✖

Date ✖

  • 10182018 · 24 ✖
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
107 107 -73.9521110154872 40.7978449143313 42G-AM-1018-03 42G AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 stop to look at me—then ran 0 0 0 0 0 0 0 1   POINT (-73.9521110154872 40.7978449143313)
148 148 -73.9532620128307 40.795247554804796 39G-AM-1018-01 39G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 dead (something ran over it) 0 0 0 0 0 0 0 0   POINT (-73.9532620128307 40.7952475548048)
180 180 -73.96908283251791 40.781803817227505 19C-PM-1018-04 19C PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9690828325179 40.7818038172275)
551 551 -73.9643825381614 40.7815445841195 21F-PM-1018-03 21F PM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9643825381614 40.7815445841195)
631 631 -73.95488778301359 40.795015748910295 38F-AM-1018-04 38F AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.95488778301362 40.7950157489103)
720 720 -73.9669814346326 40.780390919948 19E-PM-1018-01 19E PM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9669814346326 40.780390919948)
913 913 -73.9514111329059 40.797508587289705 42G-AM-1018-01 42G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 1   POINT (-73.9514111329059 40.797508587289705)
995 995 -73.9698843507358 40.780375418758105 18C-PM-1018-02 18C PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9698843507358 40.7803754187581)
1111 1111 -73.96327993398721 40.7808316436308 21H-PM-1018-01 21H PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 staring 0 0 0 0 1 1 0 0   POINT (-73.9632799339872 40.7808316436308)
1174 1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 staring 0 0 0 1 0 1 0 0 approaches (very close) POINT (-73.9682067129876 40.7779911208015)
1620 1620 -73.96356061997841 40.782206970617 22G-AM-1018-03 22G AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9635606199784 40.782206970617)
1704 1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9624052832372 40.7809656348254)
2164 2164 -73.955013129397 40.7954024311542 38F-AM-1018-05 38F AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 ran up tree 0 0 0 0 0 0 0 1   POINT (-73.955013129397 40.7954024311542)
2313 2313 -73.9646174034945 40.778128752826206 18H-AM-1018-01 18H AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Running from one tree to the other 1 1 0 0 0 playing? 0 0 0 0 0 0 0 0   POINT (-73.9646174034945 40.7781287528262)
2374 2374 -73.9551370586201 40.7946465469021 38F-AM-1018-06 38F AM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 hopped away 0 0 0 0 0 0 0 1   POINT (-73.95513705862011 40.7946465469021)
2432 2432 -73.9657203199746 40.775173008911 14I-PM-1018-02 14I PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9657203199746 40.775173008911)
2681 2681 -73.968807163616 40.7812018159499 19C-PM-1018-02 19C PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.968807163616 40.7812018159499)
2703 2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9690174442945 40.7817617696508)
2765 2765 -73.971525123573 40.770368535984204 7G-PM-1018-06 07G PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 grooming 0 0 0 0 0 0 0 0   POINT (-73.971525123573 40.7703685359842)
2888 2888 -73.955258162768 40.7958147673603 39E-AM-1018-01 39E AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 standing still 0 0 0 0 0 0 0 1   POINT (-73.955258162768 40.7958147673603)
1451 1451 -73.9645365195454 40.778153102126296 18H-AM-1018-02 18H AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   Tree 1 1 0 0 0 playing? 0 0 0 0 0 0 0 0   POINT (-73.9645365195454 40.7781531021263)
1518 1518 -73.9632265832593 40.7816914475461 22G-AM-1018-04 22G AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9632265832593 40.78169144754611)
1970 1970 -73.96314646937691 40.793415656751 33A-PM-1018-02 33A PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Tree cavity [of] London Plane tree 0 0 0 0 0 hanging out,watching world 0 0 0 0 0 0 0 0 watching POINT (-73.9631464693769 40.793415656751)
2522 2522 -73.9658747245917 40.77540337375321 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch 1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9658747245917 40.7754033737532)

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