2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Date = 10182018, Foraging = 1 and Shift = "AM" sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Tail flags, Approaches, Indifferent, Runs from

Tail twitches ✖

  • 0 20
  • 1 3

Shift ✖

Foraging ✖

Date ✖

  • 10182018 · 23 ✖
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
120 120 -73.9511118711108 40.7950813345902 40I-AM-1018-01 40I AM 10182018 1 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1 begging 0 0 0 0 0 0 0 0   POINT (-73.9511118711108 40.7950813345902)
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)
334 334 -73.9687395228846 40.7807364481385 18D-AM-1018-02 18D AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9687395228846 40.7807364481385)
442 442 -73.9502466289084 40.795922877988296 41I-AM-1018-02 41I AM 10182018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0 runs off POINT (-73.9502466289084 40.7959228779883)
467 467 -73.95797241199429 40.794870990001606 37D-AM-1018-01 37D AM 10182018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579724119943 40.7948709900016)
527 527 -73.9632646049622 40.781740129208295 22G-AM-1018-05 22G AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9632646049622 40.7817401292083)
777 777 -73.96542102635209 40.7782529692575 17G-AM-1018-01 17G AM 10182018 1 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9654210263521 40.77825296925751)
913 913 -73.9514111329059 40.797508587289705 42G-AM-1018-01 42G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 1   POINT (-73.9514111329059 40.797508587289705)
945 945 -73.9532838338416 40.79311126745829 37H-AM-1018-01 37H AM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE Right behind fence of the conservatory 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9532838338416 40.7931112674583)
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)
1828 1828 -73.9682965197661 40.780537896388296 18D-AM-1018-04 18D AM 10182018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9682965197661 40.7805378963883)
1957 1957 -73.96841872074229 40.780592789875996 18D-AM-1018-01 18D AM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 cleaning 0 0 0 0 0 0 0 0   POINT (-73.9684187207423 40.780592789876)
1978 1978 -73.9579689996645 40.794933848991704 37D-AM-1018-02 37D AM 10182018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579689996645 40.7949338489917)
2156 2156 -73.96503878480009 40.7814134438394 21F-AM-1018-04 21F AM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9650387848001 40.7814134438394)
2255 2255 -73.96429678758571 40.78156523539371 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9642967875857 40.7815652353937)
2531 2531 -73.9599424115626 40.79574725853271 37B-AM-1018-05 37B AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9599424115626 40.7957472585327)
2830 2830 -73.9556083695689 40.7965223709493 39E-AM-1018-02 39E AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9556083695689 40.7965223709493)
2838 2838 -73.9507699667119 40.7955166039555 40I-AM-1018-02 40I AM 10182018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9507699667119 40.795516603955505)
2876 2876 -73.95589957376541 40.7960097734603 39E-AM-1018-05 39E AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9558995737654 40.7960097734603)
2884 2884 -73.9598378495787 40.7956843021662 37B-AM-1018-04 37B AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9598378495787 40.7956843021662)
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)
2966 2966 -73.9630596103391 40.792572062055605 32A-AM-1018-04 32A AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE Base of tree 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9630596103391 40.7925720620556)
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)

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