2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Date = 10182018 and Hectare Squirrel Number = 3 sorted by Specific Location

✎ View and edit SQL

This data as json, CSV (advanced)

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

Quaas ✖

  • 0 30
  • 1 1

Hectare Squirrel Number ✖

Date ✖

  • 10182018 · 31 ✖
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
21 21 -73.9703781726172 40.778752613032104 16C-PM-1018-03 16C PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9703781726172 40.7787526130321)
107 107 -73.9521110154872 40.7978449143313 42G-AM-1018-03 42G AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 stop to look at me—then ran 0 0 0 0 0 0 0 1   POINT (-73.9521110154872 40.7978449143313)
138 138 -73.9721442939797 40.770075080231706 7G-PM-1018-03 07G PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9721442939797 40.7700750802317)
164 164 -73.9758676144255 40.7701671581939 5D-PM-1018-03 05D PM 10182018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9758676144255 40.7701671581939)
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)
296 296 -73.9596964641652 40.795775359158505 37B-AM-1018-03 37B AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9596964641652 40.7957753591585)
329 329 -73.967832992543 40.778366991340796 17E-PM-1018-03 17E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.967832992543 40.7783669913408)
408 408 -73.9633760173635 40.7818422357619 22G-PM-1018-03 22G PM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 chilling 0 0 0 0 0 0 1 0 observed POINT (-73.96337601736352 40.7818422357619)
551 551 -73.9643825381614 40.7815445841195 21F-PM-1018-03 21F PM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9643825381614 40.7815445841195)
598 598 -73.9698196671161 40.7802972001469 18C-PM-1018-03 18C PM 10182018 3 Juvenile Gray   Gray+   Above Ground 1   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9698196671161 40.7802972001469)
869 869 -73.96294833745279 40.7936809905265 33A-PM-1018-03 33A PM 10182018 3 Adult Gray   Gray+   Above Ground 6   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9629483374528 40.7936809905265)
1242 1242 -73.9714512125212 40.77602752501139 13D-PM-1018-03 13D PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9714512125212 40.7760275250114)
1337 1337 -73.9750986553543 40.7740671171292 10C-AM-1018-03 10C AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9750986553543 40.7740671171292)
1393 1393 -73.96871341377859 40.7812207913391 19C-PM-1018-03 19C PM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9687134137786 40.7812207913391)
1543 1543 -73.9713906492842 40.775006131014294 12E-PM-1018-03 12E PM 10182018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9713906492842 40.7750061310143)
1620 1620 -73.96356061997841 40.782206970617 22G-AM-1018-03 22G AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9635606199784 40.782206970617)
1874 1874 -73.96573273328491 40.7747554568985 14I-PM-1018-03 14I PM 10182018 3 Juvenile Gray Black Gray+Black   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657327332849 40.7747554568985)
2043 2043 -73.9643223016635 40.781431908715 21F-AM-1018-03 21F AM 10182018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 dead 0 0 0 0 0 0 0 1   POINT (-73.9643223016635 40.781431908715)
2049 2049 -73.9692650850957 40.7713793846002 9H-PM-1018-03 09H PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9692650850957 40.7713793846002)
2082 2082 -73.9696802053043 40.781605740612505 19B-PM-1018-03 19B PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9696802053043 40.7816057406125)
2407 2407 -73.95557243517759 40.7967602498249 39E-AM-1018-03 39E AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9555724351776 40.7967602498249)
2422 2422 -73.9683066605832 40.7781213930544 16E-PM-1018-03 16E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9683066605832 40.7781213930544)
2687 2687 -73.9550235589287 40.7951312356844 38F-AM-1018-03 38F AM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550235589287 40.7951312356844)
2853 2853 -73.96786131850709 40.7822170887526 20C-PM-1018-03 20C PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9678613185071 40.7822170887526)
2937 2937 -73.96834606070209 40.7805408447877 18D-AM-1018-03 18D AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9683460607021 40.7805408447877)
2960 2960 -73.96252481451499 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.962524814515 40.7810022923615)
2972 2972 -73.9631468456897 40.7926110399714 32A-AM-1018-03 32A AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9631468456897 40.7926110399714)
2188 2188 -73.9676113345824 40.7803482448467 19E-PM-1018-03 19E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE Baseball field #3 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9676113345824 40.7803482448467)
2599 2599 -73.96898934126929 40.785308737683 23A-AM-1018-03 23A AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8 Tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689893412693 40.785308737683)
258 258 -73.9534333425633 40.793256416332795 37H-AM-1018-03 37H AM 10182018 3 Adult Gray White Gray+White   Above Ground 10 in a tree with red berries 0 0 0 1 0   0 1 0 0 0 0 0 1   POINT (-73.9534333425633 40.7932564163328)
1420 1420 -73.9647605121306 40.780396153151706 20G-AM-1018-03 20G AM 10182018 3 Adult Gray   Gray+   Above Ground 12 in tree 1 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9647605121306 40.7803961531517)

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