2018_Central_Park_Squirrel_Census_-_Squirrel_Data

17 rows where Hectare = "32E" and Runs from = 0 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hectare Squirrel Number ✖

Runs from ✖

Hectare ✖

  • 32E · 17 ✖
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
64 64 -73.95950023395079 40.7903365788694 32E-PM-1017-13 32E PM 10172018 13 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9595002339508 40.7903365788694)
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)
105 105 -73.9589249555235 40.7908193284981 32E-PM-1017-03 32E PM 10172018 3 Adult Gray   Gray+   Above Ground 2 bottom of tree 0 0 0 1 0 still 0 0 0 0 0 0 1 0   POINT (-73.9589249555235 40.7908193284981)
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)
1207 1207 -73.95947083287321 40.791192982895005 32E-AM-1007-07 32E AM 10072018 7 Adult Gray   Gray+   Above Ground   on tennis club house roof 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9594708328732 40.791192982895)
1998 1998 -73.9595686513629 40.7906859748696 32E-AM-1007-06 32E AM 10072018 6 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9595686513629 40.7906859748696)
2791 2791 -73.9593624259363 40.7905522356793 32E-AM-1007-02 32E AM 10072018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9593624259363 40.7905522356793)
2826 2826 -73.9600357018376 40.790653976688105 32E-AM-1007-08 32E AM 10072018 8 Adult Gray   Gray+   Above Ground 65 tree top 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9600357018376 40.7906539766881)
227 227 -73.95981553009129 40.7905887826983 32E-AM-1007-10 32E AM 10072018 10 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9598155300913 40.7905887826983)
1760 1760 -73.95970725337871 40.79055818537861 32E-AM-1007-12 32E AM 10072018 12 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9597072533787 40.79055818537861)
1789 1789 -73.9596271142953 40.790661231367295 32E-PM-1017-12 32E PM 10172018 12 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 1 0 0 0 0 0 0   POINT (-73.9596271142953 40.7906612313673)
2123 2123 -73.959874668294 40.7907004233491 32E-AM-1007-09 32E AM 10072018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.959874668294 40.7907004233491)
2236 2236 -73.9597845469964 40.790617930344794 32E-AM-1007-11 32E AM 10072018 11 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9597845469964 40.7906179303448)
2364 2364 -73.9587183039085 40.790920913796896 32E-PM-1017-02 32E PM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9587183039085 40.7909209137969)
2376 2376 -73.9594204646985 40.790592376521296 32E-PM-1017-11 32E PM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9594204646985 40.7905923765213)
2413 2413 -73.959701727877 40.790660026971004 32E-AM-1007-03 32E AM 10072018 3 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.959701727877 40.790660026971)
2906 2906 -73.9597260014375 40.790707423031 32E-AM-1007-04 32E AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9597260014375 40.790707423031)

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