2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Hectare = "33B" sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hectare Squirrel Number ✖

Runs from ✖

  • 0 11
  • 1 7

Hectare ✖

  • 33B · 18 ✖
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
281 281 -73.9619411917909 40.7923536640283 33B-PM-1010-11 33B PM 10102018 11 Adult Gray   Gray+   Above Ground 10   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9619411917909 40.7923536640283)
707 707 -73.961547503801 40.793156066867205 33B-AM-1010-06 33B AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.961547503801 40.7931560668672)
739 739 -73.9620597449066 40.7922465876813 33B-PM-1010-10 33B PM 10102018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 0 0 0 0   POINT (-73.9620597449066 40.7922465876813)
785 785 -73.9619417432685 40.7930365939865 33B-PM-1010-12 33B PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9619417432685 40.7930365939865)
933 933 -73.96162045695479 40.7926188605509 33B-PM-1010-01 33B PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9616204569548 40.7926188605509)
1277 1277 -73.9619609976132 40.7922824443528 33B-PM-1010-09 33B PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9619609976132 40.7922824443528)
1347 1347 -73.9616693665254 40.792971019627 33B-AM-1010-05 33B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9616693665254 40.792971019627)
1361 1361 -73.961934398055 40.79247895485221 33B-PM-1010-07 33B PM 10102018 7 Adult     +   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.961934398055 40.7924789548522)
1645 1645 -73.9619673317128 40.7924176673037 33B-PM-1010-08 33B PM 10102018 8 Juvenile Gray   Gray+   Above Ground   running up tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9619673317128 40.7924176673037)
1979 1979 -73.96127592913992 40.7930468323219 33B-AM-1010-03 33B AM 10102018 3 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9612759291399 40.7930468323219)
2062 2062 -73.9618173092433 40.7925800181543 33B-PM-1010-04 33B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9618173092433 40.7925800181543)
2501 2501 -73.96169441957758 40.7927250423024 33B-PM-1010-02 33B PM 10102018 2 Adult     +   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9616944195776 40.7927250423024)
2523 2523 -73.9619016393127 40.792516012692104 33B-PM-1010-06 33B PM 10102018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9619016393127 40.7925160126921)
2555 2555 -73.9613127978423 40.79293215045679 33B-AM-1010-04 33B AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9613127978423 40.7929321504568)
2807 2807 -73.9618213644671 40.792764881973795 33B-AM-1010-02 33B AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.96182136446711 40.7927648819738)
2970 2970 -73.9619019299709 40.7924476439693 33B-PM-1010-05 33B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9619019299709 40.7924476439693)
2994 2994 -73.96172070912449 40.792283902593496 33B-AM-1010-01 33B AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9617207091245 40.7922839025935)
1824 1824 -73.9617250054003 40.7925390432044 33B-PM-1010-03 33B PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9617250054003 40.7925390432044)

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