2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Above Ground Sighter Measurement = 8 and Hectare Squirrel Number = 2 sorted by Date

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Tail twitches, Approaches, Indifferent, Runs from

Hectare Squirrel Number

Above Ground Sighter Measurement

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
372 -73.9781303869038 40.7725000348875 7A-AM-1006-02 07A AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 in tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9781303869038 40.7725000348875)
639 -73.9558589529608 40.789240039494096 32H-PM-1006-02 32H PM 10062018 2   Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9558589529608 40.7892400394941)
319 -73.96590343597059 40.779751668884394 19F-AM-1007-02 19F AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 8   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9659034359706 40.77975166888441)
43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9574648097543 40.78925084286221)
1661 -73.974519308015 40.7691228794395 5E-AM-1008-02 05E AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 trellis 1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.974519308015 40.7691228794395)
1238 -73.97736921314409 40.767977115014894 3D-PM-1010-02 03D PM 10102018 2 Adult Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9773692131441 40.7679771150149)
1652 -73.94984217462209 40.7969397424182 42I-PM-1014-02 42I PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 8   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9498421746221 40.7969397424182)
2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687213827744 40.7843586374648)
2616 -73.9675917702187 40.7789922281625 17E-AM-1017-02 17E AM 10172018 2 Adult Gray   Gray+   Above Ground 8 Shore 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9675917702187 40.7789922281625)

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