2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Above Ground Sighter Measurement = 30 and Date = 10072018 sorted by Running

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Running, Climbing, Foraging, Tail flags, Indifferent

Tail twitches ✖

  • 0 10
  • 1 1

Date ✖

  • 10072018 · 11 ✖

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
347 347 -73.96116961447841 40.7816692895155 22I-AM-1007-03 22I AM 10072018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611696144784 40.7816692895155)
496 496 -73.9548430741605 40.798207350942 41E-AM-1007-06 41E AM 10072018 6 Adult Gray   Gray+   Above Ground 30 tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9548430741605 40.798207350942)
634 634 -73.95963759070379 40.79073477083529 32E-AM-1007-05 32E AM 10072018 5 Adult Black   Black+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9596375907038 40.79073477083531)
708 708 -73.9592819491968 40.7941062008626 35C-AM-1007-06 35C AM 10072018 6 Adult     +   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9592819491968 40.7941062008626)
1044 1044 -73.9693254080548 40.77616003271179 14F-AM-1007-01 14F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9693254080548 40.7761600327118)
1972 1972 -73.9558370309765 40.7921977208472 35G-AM-1007-02 35G AM 10072018 2 Adult Gray White Gray+White   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9558370309765 40.7921977208472)
1994 1994 -73.9598463837775 40.783452472425395 25I-PM-1007-05 25I PM 10072018 5 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9598463837775 40.7834524724254)
2228 2228 -73.9714045891597 40.771541833397606 9G-AM-1007-03 09G AM 10072018 3 Adult Gray Black Gray+Black   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.97140458915972 40.7715418333976)
2851 2851 -73.955208233231 40.7890574331084 32I-PM-1007-02 32I PM 10072018 2 Adult     +   Above Ground 30   0 0 1 0 0 different sound - happy,playful chirps 0 0 0 0 1 0 1 0   POINT (-73.955208233231 40.7890574331084)
480 480 -73.9641293283734 40.7907654006019 30B-AM-1007-03 30B AM 10072018 3 Adult Gray   Gray+   Above Ground 30   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9641293283734 40.7907654006019)
1046 1046 -73.9647891228606 40.789853066039 29B-AM-1007-02 29B AM 10072018 2 Adult Gray   Gray+   Above Ground 30   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.9647891228606 40.789853066039)

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