2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Hectare = "16D" sorted by Tail twitches

✎ 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, Kuks, Tail flags, Indifferent

Hectare Squirrel Number ✖

Runs from ✖

  • 0 14
  • 1 5

Hectare ✖

  • 16D · 19 ✖
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
211 211 -73.9702755805141 40.7783547795222 16D-PM-1010-13 16D PM 10102018 13 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9702755805141 40.7783547795222)
429 429 -73.96947840566179 40.7787735291442 16D-PM-1010-01 16D PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694784056618 40.7787735291442)
530 530 -73.9696360756453 40.7786545659072 16D-PM-1010-03 16D PM 10102018 3 Adult Gray   Gray+   Above Ground 18   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9696360756453 40.7786545659072)
563 563 -73.97003307121192 40.778291392572704 16D-PM-1010-06 16D PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1 walking 0 0 0 0 0 0 0 0 checking me out POINT (-73.9700330712119 40.7782913925727)
585 585 -73.9700148248402 40.778778019335796 16D-PM-1010-04 16D PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9700148248402 40.7787780193358)
609 609 -73.9698762023146 40.778205568811295 16D-PM-1010-09 16D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9698762023146 40.77820556881131)
694 694 -73.9698032734704 40.7782343912417 16D-AM-1007-02 16D AM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9698032734704 40.7782343912417)
996 996 -73.9703149829421 40.778558363032296 16D-AM-1007-01 16D AM 10072018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9703149829421 40.7785583630323)
1084 1084 -73.96988397502491 40.778143307669204 16D-PM-1010-08 16D PM 10102018 8 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9698839750249 40.7781433076692)
1550 1550 -73.9698642668906 40.7784669316504 16D-PM-1010-10 16D PM 10102018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9698642668906 40.7784669316504)
1902 1902 -73.9703314162405 40.778584776139 16D-PM-1010-12 16D PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9703314162405 40.778584776139)
1903 1903 -73.9701379806066 40.7785234812393 16D-PM-1010-11 16D PM 10102018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701379806066 40.7785234812393)
1934 1934 -73.969756965598 40.7786455091699 16D-PM-1010-02 16D PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.969756965598 40.7786455091699)
2034 2034 -73.96991351872971 40.7782354186163 16D-AM-1007-03 16D AM 10072018 3 Adult     + ran away before I could take a good look Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9699135187297 40.7782354186163)
2209 2209 -73.9697583235533 40.7787320391004 16D-AM-1007-05 16D AM 10072018 5 Adult Gray   Gray+ didn't get a good look Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.96975832355331 40.7787320391004)
2240 2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697787673802 40.7781746195436)
2634 2634 -73.96956851864891 40.7788293026327 16D-AM-1007-04 16D AM 10072018 4 Adult Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9695685186489 40.7788293026327)
2732 2732 -73.9694185786221 40.7787189999566 16D-AM-1007-06 16D AM 10072018 6 Adult Cinnamon White Cinnamon+White primary color: brown ( I marked cinnamon as closest to brown - JO) Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9694185786221 40.7787189999566)
2780 2780 -73.9700634278 40.778422372245295 16D-PM-1010-07 16D PM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9700634278 40.7784223722453)

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