2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Date = 10132018, Eating = 1 and Tail twitches = 1 sorted by Tail twitches

View and edit SQL

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

Tail twitches

Eating

Date

  • 10132018 · 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
79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 1 1 eating (a mushroom),circles around us,really fat,scratching himself,grooming activity 0 0 0 0 1 1 0 0   POINT (-73.9610705592868 40.7914829661051)
109 -73.967097592707 40.785411934253794 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   1 0 0 1 0 took nut to bury 0 0 0 0 1 0 0 1   POINT (-73.967097592707 40.7854119342538)
595 -73.9742804552383 40.7707167671865 7E-PM-1013-05 07E PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE On rocks 0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9742804552383 40.7707167671865)
779 -73.9745305540008 40.7742043234014 10C-PM-1013-02 10C PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 1   POINT (-73.9745305540008 40.7742043234014)
868 -73.9738481771673 40.7706540698938 7E-PM-1013-04 07E PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9738481771673 40.7706540698938)
874 -73.95919577939921 40.79495688734529 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9591957793992 40.7949568873453)
1108 -73.96383977903841 40.782895027290394 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 1 0 0 1 0 1 0 indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)
1167 -73.9593244415072 40.794964729747 36C-PM-1013-03 36C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9593244415072 40.794964729747)
1296 -73.97055091705421 40.7689416540228 6I-PM-1013-04 06I PM 10132018 4 Adult Black Gray Black+Gray   Ground Plane FALSE Grass 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9705509170542 40.7689416540228)
1681 -73.9638141923763 40.782922532628795 23F-PM-1013-03 23F PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0 indifferent (noticed me,busy eating,foraging) POINT (-73.9638141923763 40.7829225326288)
1971 -73.9591880400132 40.795007125283604 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   1 1 0 0 1 0 1 0   POINT (-73.95918804001322 40.7950071252836)
2030 -73.9749251267433 40.7679111971294 4F-PM-1013-01 04F PM 10132018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9749251267433 40.7679111971294)
2109 -73.9744488584414 40.7741627220859 10C-PM-1013-03 10C PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9744488584414 40.7741627220859)
2202 -73.95560399976209 40.7977549157287 40D-AM-1013-05 40D AM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9556039997621 40.7977549157287)
2274 -73.96980442184758 40.7697007833531 7I-PM-1013-06 07I PM 10132018 6 Adult Cinnamon   Cinnamon+ "Brown" written in as Primary Ground Plane FALSE Under the tree 0 0 0 1 0 playing,interacting with #7 0 0 0 0 1 0 0 1   POINT (-73.9698044218476 40.7697007833531)
2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people 1 0 0 1 1   0 0 0 0 1 0 1 1   POINT (-73.9596083366477 40.7949526729608)
2606 -73.96143417385001 40.794546426211205 35B-PM-1013-02 35B PM 10132018 2 Juvenile     +   Ground Plane FALSE   0 0 0 1 0 did not notice dog sitting a few yards away (10-20 ft) 0 0 0 0 1 0 1 0   POINT (-73.96143417385 40.7945464262112)
2683 -73.972179947936 40.7810042827198 17A-PM-1013-02 17A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 on a little pedestal-shaped part of a tree 0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.972179947936 40.7810042827198)

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