2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Above Ground Sighter Measurement = 50, Foraging = 0 and Indifferent = 0 sorted by Chasing

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Combination of Primary and Highlight Color, Running, Climbing, Eating, Tail twitches, Runs from

Highlight Fur Color ✖

Foraging ✖

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
48 48 -73.95959331954091 40.7905847332369 32E-AM-1007-13 32E AM 10072018 13 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9595933195409 40.7905847332369)
109 109 -73.967097592707 40.785411934253794 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   1 0 0 1 0 took nut to bury 0 0 0 0 1 0 0 1   POINT (-73.967097592707 40.7854119342538)
156 156 -73.9576589997493 40.7972751877447 39C-PM-1006-02 39C PM 10062018 2 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0 unaware of POINT (-73.95765899974931 40.7972751877447)
919 919 -73.96372797118529 40.7905198502307 30B-AM-1007-09 30B AM 10072018 9 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0 jumping b/w trees 0 0 0 0 0 0 0 0   POINT (-73.9637279711853 40.7905198502307)
1071 1071 -73.9703774000082 40.771760755155505 9G-AM-1007-01 09G AM 10072018 1 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9703774000082 40.7717607551555)
1110 1110 -73.96764342569759 40.78623366244479 24A-PM-1007-04 24A PM 10072018 4 Adult Gray   Gray+   Above Ground 50 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676434256976 40.7862336624448)
1154 1154 -73.9786936992465 40.771394367466606 5A-PM-1010-02 05A PM 10102018 2 Adult Gray White Gray+White   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9786936992465 40.7713943674666)
1398 1398 -73.9602808042376 40.7906130788763 32E-AM-1007-14 32E AM 10072018 14 Adult Gray   Gray+   Above Ground 50 literally fell to ground from 50 feet up 0 0 0 0 0 falling 0 0 0 0 0 0 0 1   POINT (-73.9602808042376 40.7906130788763)
2479 2479 -73.9657958433575 40.7763496875058 15H-AM-1013-01 15H AM 10132018 1 Adult Gray White Gray+White   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9657958433575 40.7763496875058)
2603 2603 -73.97087815045279 40.7724138070355 10F-AM-1007-03 10F AM 10072018 3 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708781504528 40.7724138070355)
2777 2777 -73.98108436110859 40.768790549369896 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9810843611086 40.7687905493699)

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