2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Kuks = 1, Location = "Ground Plane" and Shift = "AM" sorted by rowid

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Hectare Squirrel Number ✖

Shift ✖

Location ✖

  • Ground Plane · 20 ✖
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
84 84 -73.9701824825872 40.776653057929295 14E-AM-1008-09 14E AM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.9701824825872 40.7766530579293)
123 123 -73.9671147090087 40.7772624641112 16G-AM-1010-03 16G AM 10102018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 was hanging out w/ #2 until i showed up 1 0 0 0 0 0 0 1   POINT (-73.9671147090087 40.7772624641112)
273 273 -73.9579218587172 40.7960605028848 38C-AM-1019-04 38C AM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   1 1 0 0 0 0 1 0   POINT (-73.9579218587172 40.79606050288481)
471 471 -73.97072153948871 40.7727508149058 10G-AM-1006-05 10G AM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#6) 1 0 0 0 0 0 0 0   POINT (-73.9707215394887 40.7727508149058)
529 529 -73.96352907511829 40.7820936628202 22G-AM-1018-02 22G AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9635290751183 40.7820936628202)
603 603 -73.9721592378418 40.776034583573 12C-AM-1013-02 12C AM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9721592378418 40.776034583573)
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   1 0 0 1 1   1 0 0 0 0 1 0 1 approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)
769 769 -73.976521916284 40.773784724458 9B-AM-1010-01 09B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 0 0 0 1   POINT (-73.976521916284 40.773784724458)
853 853 -73.9534509627885 40.7921084224711 36I-AM-1017-07 36I AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1 chasing (#8),scratching 1 0 0 0 1 0 1 0   POINT (-73.9534509627885 40.7921084224711)
929 929 -73.97386112577159 40.773724677958704 10D-AM-1008-01 10D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 1 0 0 1   POINT (-73.9738611257716 40.7737246779587)
978 978 -73.9676692772518 40.7764726688908 15G-AM-1008-03 15G AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9676692772518 40.7764726688908)
1007 1007 -73.96353178229771 40.7821352080233 22G-AM-1018-01 22G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   1 0 0 1 0 0 1 0   POINT (-73.9635317822977 40.7821352080233)
1172 1172 -73.9706929270645 40.77278411194239 10G-AM-1006-06 10G AM 10062018 6 Juvenile Gray   Gray+ skinny tail Ground Plane FALSE   0 1 0 0 0 chasing (#5) 1 0 0 0 0 0 0 0   POINT (-73.9706929270645 40.7727841119424)
1302 1302 -73.9704024529864 40.772925606388895 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 1 0 0 0 0 0 0 0   POINT (-73.9704024529864 40.7729256063889)
1436 1436 -73.97667795856859 40.7669673778105 2E-AM-1010-04 02E AM 10102018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   1 0 0 0 0 0 1 0   POINT (-73.9766779585686 40.7669673778105)
1502 1502 -73.97052548010001 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1 acknowledges POINT (-73.9705254801 40.7763606494306)
1563 1563 -73.96762706709958 40.776391443152 15G-AM-1008-04 15G AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9676270670996 40.776391443152)
1588 1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9693209851947 40.7707450042769)
2657 2657 -73.9582150734453 40.7962862794303 38C-AM-1019-08 38C AM 10192018 8 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 0 0 1 0   POINT (-73.9582150734453 40.7962862794303)
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.9690082314914 40.7738993942891)

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