2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Above Ground Sighter Measurement = 8 and Indifferent = 1 sorted by Running

View and edit SQL

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Running, Climbing, Eating, Foraging, Tail flags

Highlight Fur Color

Tail twitches

Indifferent

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
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)
1217 -73.9764850086767 40.7737340720562 8B-AM-1007-07 08B AM 10072018 7 Juvenile Gray Black Gray+Black   Above Ground 8   0 0 0 1 0 holding nut 0 0 0 0 0 0 1 0   POINT (-73.9764850086767 40.7737340720562)
2081 -73.96757180595391 40.7786049141486 17F-AM-1007-06 17F AM 10072018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675718059539 40.7786049141486)
2599 -73.96898934126929 40.785308737683 23A-AM-1018-03 23A AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8 Tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689893412693 40.785308737683)
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)
2680 -73.9721348050673 40.7666920046704 3H-AM-1008-01 03H AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 0 0 0 teasing barking dog 0 0 0 0 0 0 1 0 indifferent by not caring about dog POINT (-73.9721348050673 40.7666920046704)
2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.971314838366 40.774951285041)
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)
569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree 1 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9709040623777 40.7701163892686)

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