2018_Central_Park_Squirrel_Census_-_Squirrel_Data

14 rows where Date = 10172018, Foraging = 1 and Hectare Squirrel Number = 5 sorted by latitude

View and edit SQL

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

Tail twitches

  • 0 12
  • 1 2

Hectare Squirrel Number

Foraging

Date

  • 10172018 · 14
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
70 -73.9804528867547 40.7696753655986 3A-PM-1017-05 03A PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9804528867547 40.76967536559861)
1020 -73.97016933635 40.770545252978295 8H-AM-1017-05 08H AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.97016933635001 40.7705452529783)
2148 -73.9767317539505 40.7717600450632 6B-PM-1017-05 06B PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767317539505 40.7717600450632)
1637 -73.9699513151755 40.7722062991044 10G-PM-1017-05 10G PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699513151755 40.7722062991044)
11 -73.9702676472613 40.7762126854894 13E-AM-1017-05 13E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on tree stump 0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9702676472613 40.7762126854894)
1784 -73.9748318777506 40.7771821378056 13A-AM-1017-05 13A AM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9748318777506 40.7771821378056)
2078 -73.9706041173545 40.778015278480396 15D-PM-1017-05 15D PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706041173545 40.7780152784804)
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)
357 -73.9724801784201 40.7790131966689 15B-PM-1017-05 15B PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9724801784201 40.7790131966689)
50 -73.96806350709491 40.779249873647 17E-AM-1017-05 17E AM 10172018 5 Adult Black   Black+   Above Ground 10 Branch 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9680635070949 40.779249873647)
1812 -73.9590074024938 40.7907059424675 32E-PM-1017-05 32E PM 10172018 5 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9590074024938 40.7907059424675)
2135 -73.9596251284566 40.7916254797561 33D-AM-1017-05 33D AM 10172018 5 Adult Black   Black+   Above Ground 5   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9596251284566 40.7916254797561)
231 -73.9527808174534 40.7924167234441 36I-AM-1017-05 36I AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9527808174534 40.7924167234441)
975 -73.95686908603099 40.798885877111395 41C-AM-1017-05 41C AM 10172018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.956869086031 40.7988858771114)

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