2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Date = 10072018, Hectare Squirrel Number = 1 and Running = 1 sorted by Quaas

View and edit SQL

Suggested facets: Shift, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Climbing, Eating, Foraging, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Running

Hectare Squirrel Number

Date

  • 10072018 · 20
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
45 -73.9579645940414 40.7918613498407 34F-AM-1007-01 34F AM 10072018 1 Adult Gray White Gray+White   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9579645940414 40.7918613498407)
373 -73.96721272832829 40.7810666805133 20D-AM-1007-01 20D AM 10072018 1 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   1 0 1 1 0 a lot of activity 0 0 0 1 0 0 0 0   POINT (-73.9672127283283 40.7810666805133)
610 -73.96715495660659 40.7751342870705 14H-AM-1007-01 14H AM 10072018 1 Adult Gray   Gray+   Above Ground 180 top of tree 1 0 0 0 0 jumping between branches 0 0 0 0 0 0 1 0   POINT (-73.9671549566066 40.7751342870705)
674 -73.9779811967788 40.7675178797546 2D-AM-1007-01 02D AM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779811967788 40.7675178797546)
950 -73.9637415893182 40.7898140363534 29B-AM-1007-01 29B AM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9637415893182 40.7898140363534)
1051 -73.96137470327021 40.7920483852431 33C-PM-1007-01 33C PM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9613747032702 40.792048385243106)
1307 -73.9565197137317 40.7986011403785 41C-PM-1007-01 41C PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9565197137317 40.7986011403785)
1408 -73.973230162241 40.768982453144396 5F-AM-1007-01 05F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 fence 1 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.973230162241 40.7689824531444)
1590 -73.9610388059192 40.793952935840004 34B-PM-1007-01 34B PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9610388059192 40.79395293584)
1612 -73.97460490884751 40.772877688739705 8C-AM-1007-01 08C AM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE behind fence, safe 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9746049088475 40.7728776887397)
2111 -73.968446056806 40.785824818871 24A-PM-1007-01 24A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.96844605680602 40.785824818871)
2166 -73.9711178122133 40.7672642958437 4I-PM-1007-01 04I PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9711178122133 40.76726429584371)
2424 -73.9684752839242 40.776581626151795 15F-AM-1007-01 15F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 1   POINT (-73.9684752839242 40.7765816261518)
2436 -73.95827701417 40.785661023889105 28I-PM-1007-01 28I PM 10072018 1 Adult Gray   Gray+   Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.95827701417 40.7856610238891)
2469 -73.9600963639087 40.7934962325313 34C-AM-1007-01 34C AM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1 dog POINT (-73.9600963639087 40.7934962325313)
2508 -73.97938145045201 40.770903369788705 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.979381450452 40.770903369788705)
2546 -73.9660267365885 40.776444395505 16H-AM-1007-01 16H AM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9660267365885 40.776444395505)
2743 -73.9587179613803 40.7992119571657 41A-PM-1007-01 41A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9587179613803 40.7992119571657)
2905 -73.9784872728213 40.768812260393204 3C-AM-1007-01 03C AM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9784872728213 40.7688122603932)
2998 -73.97520792474191 40.775537697900205 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752079247419 40.7755376979002)

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