2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Chasing = 1, Eating = 0 and Hectare Squirrel Number = 8 sorted by Hectare Squirrel Number

View and edit SQL

Suggested facets: Shift, Date, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Quaas, Moans, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number

Eating

Chasing

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
724 -73.9532952763106 40.792007446262204 36I-AM-1017-08 36I AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#7) 0 0 0 0 1 0 0 1 runs from (me) POINT (-73.95329527631061 40.7920074462622)
957 -73.9586527721822 40.790883111056104 32F-PM-1008-08 32F PM 10082018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586527721822 40.7908831110561)
1037 -73.96774098419691 40.776357914063894 15G-PM-1019-08 15G PM 10192018 8 Adult     +   Above Ground 5   0 1 0 0 0   0 1 1 0 0 0 0 0   POINT (-73.9677409841969 40.7763579140639)
1040 -73.9702588981432 40.776610754288 14E-AM-1008-08 14E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9702588981432 40.776610754288)
1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 1 1 0 0 canoodling w/ #9 0 0 0 0 0 0 1 0   POINT (-73.964280573021 40.777830911491)
1321 -73.96992856882959 40.7774474015189 15D-AM-1007-08 15D AM 10072018 8 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 1 chasing #7 0 0 0 0 0 0 1 0   POINT (-73.9699285688296 40.7774474015189)
1527 -73.970216605149 40.7702960667277 8H-PM-1014-08 08H PM 10142018 8 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0 chasing (#7),playing? 0 0 0 0 0 0 1 0   POINT (-73.970216605149 40.7702960667277)
1821 -73.9676314068477 40.7788030406918 17E-AM-1017-08 17E AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9676314068477 40.7788030406918)
1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.97428114848522 40.775533619083)
2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9583688637255 40.791388958496)

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