2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Above Ground Sighter Measurement = 2, Foraging = 0 and Running = 1 sorted by Lat/Long

View and edit SQL

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Climbing, Eating, Tail twitches, Indifferent, Runs from

Running

Location

Foraging

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 ▼
2803 -73.9576652087316 40.787545797780105 29H-PM-1006-02 29H PM 10062018 2 Adult Gray   Gray+   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9576652087316 40.7875457977801)
620 -73.9655905300923 40.775261463802295 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9655905300923 40.7752614638023)
1070 -73.9674631254594 40.7790076357696 17E-AM-1017-10 17E AM 10172018 10 Juvenile Gray   Gray+   Above Ground 2 Fence 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9674631254594 40.7790076357696)
1530 -73.96893059787509 40.781815249626604 19C-PM-1018-06 19C PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 Climbed fence 1 0 1 0 0 climbing (fence) 0 0 0 0 0 0 1 0   POINT (-73.9689305978751 40.7818152496266)
1165 -73.9689504114652 40.77667701537639 14F-PM-1012-05 14F PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 2 on a fallen branch 1 0 0 1 0 sitting 0 0 0 0 0 0 0 0 looking at me POINT (-73.9689504114652 40.7766770153764)
805 -73.97068515461841 40.7780777016038 15D-PM-1017-04 15D PM 10172018 4 Adult Cinnamon   Cinnamon+   Above Ground 2 on fence 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706851546184 40.7780777016038)
426 -73.9741944367138 40.7769889953596 13B-PM-1008-01 13B PM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on railing 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9741944367138 40.7769889953596)
377 -73.9757001944781 40.769499790547 5E-AM-1008-09 05E AM 10082018 9 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2 went up tree 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9757001944781 40.769499790547)

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.718ms