2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Date = 10172018 and Kuks = 1 sorted by latitude

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Quaas, Approaches, Indifferent, Runs from

Tail twitches

Kuks

Date

  • 10172018 · 8
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
1502 -73.97052548010001 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1 acknowledges POINT (-73.9705254801 40.7763606494306)
1366 -73.97115821991021 40.7783674409485 15C-PM-1017-05 15C PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 1 1 0 0   POINT (-73.9711582199102 40.7783674409485)
2206 -73.95944460183459 40.7917800352042 33D-AM-1017-06 33D AM 10172018 6 Adult Black   Black+   Above Ground 10   0 0 1 0 0   1 1 0 0 0 0 0 1 runs from (ran into hole in tree trunk) POINT (-73.9594446018346 40.7917800352042)
2731 -73.9595886063173 40.7918405182594 33D-AM-1017-09 33D AM 10172018 9 Adult Black Cinnamon Black+Cinnamon   Above Ground 7   0 0 1 0 0   1 1 0 0 0 0 1 1   POINT (-73.9595886063173 40.7918405182594)
853 -73.9534509627885 40.7921084224711 36I-AM-1017-07 36I AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1 chasing (#8),scratching 1 0 0 0 1 0 1 0   POINT (-73.9534509627885 40.7921084224711)
743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   1 0 0 1 1   1 0 0 0 0 1 0 1 approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)
2327 -73.9567801028221 40.7960096659564 38D-AM-1017-01 38D AM 10172018 1       +   Above Ground 30   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9567801028221 40.7960096659564)
1886 -73.956806913988 40.7987736900857 41C-AM-1017-06 41C AM 10172018 6 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.956806913988 40.7987736900857)

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