2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Hectare = "04B" sorted by Runs from

✎ View and edit SQL

This data as json, CSV (advanced)

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

Highlight Fur Color ✖

Tail twitches ✖

Eating ✖

Hectare ✖

  • 04B · 11 ✖
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
266 266 -73.97864810094991 40.7697372811949 4B-PM-1018-03 04B PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9786481009499 40.7697372811949)
483 483 -73.9789952029637 40.7697758333099 4B-AM-1010-03 04B AM 10102018 3 Juvenile Gray White Gray+White   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9789952029637 40.7697758333099)
579 579 -73.9786714207307 40.769687080622894 4B-PM-1018-01 04B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9786714207307 40.7696870806229)
882 882 -73.9786805884996 40.769755923192704 4B-PM-1018-02 04B PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9786805884996 40.7697559231927)
1164 1164 -73.97902264006291 40.76989976537921 4B-AM-1010-01 04B AM 10102018 1 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9790226400629 40.7698997653792)
1597 1597 -73.9789401448556 40.76973731414979 4B-AM-1010-04 04B AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9789401448556 40.7697373141498)
1799 1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 1 0 0 0 chasing squirrel #6 1 1 0 0 1 0 0 0   POINT (-73.978844141973 40.7696046074378)
1856 1856 -73.97829402311491 40.7694236097224 4B-PM-1018-05 04B PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9782940231149 40.7694236097224)
2300 2300 -73.9789251806378 40.7699558513225 4B-AM-1010-02 04B AM 10102018 2 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 30   0 0 1 1 1   1 0 0 0 0 0 1 0   POINT (-73.9789251806378 40.7699558513225)
2640 2640 -73.9788304714091 40.7696373635315 4B-AM-1010-06 04B AM 10102018 6 Adult Gray   Gray+   Above Ground 12   1 0 0 0 0 running from squirrel #5 0 0 0 0 0 0 0 0   POINT (-73.9788304714091 40.7696373635315)
2756 2756 -73.9787312025627 40.7701071405918 4B-PM-1018-04 04B PM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9787312025627 40.7701071405918)

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