2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Age = "Juvenile", Highlight Fur Color = "Cinnamon" and Running = 1 sorted by Lat/Long

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Indifferent, Runs from

Tail twitches

  • 0 11
  • 1 7

Running

Highlight Fur Color

  • Cinnamon · 18

Age

  • Juvenile · 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 ▼
1064 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon         1 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9540257319561 40.798408619116)
43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9574648097543 40.78925084286221)
2357 -73.96323010348829 40.7925707244111 32A-PM-1013-06 32A PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9632301034883 40.7925707244111)
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)
2522 -73.9658747245917 40.77540337375321 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch 1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9658747245917 40.7754033737532)
884 -73.96789372898371 40.7782808361645 16E-PM-1018-01 16E PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9678937289837 40.7782808361645)
2465 -73.9686999860219 40.784401473513604 22B-PM-1014-03 22B PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686999860219 40.7844014735136)
2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687213827744 40.7843586374648)
995 -73.9698843507358 40.780375418758105 18C-PM-1018-02 18C PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9698843507358 40.7803754187581)
209 -73.97107601968679 40.7725506006789 10F-PM-1019-02 10F PM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Ground Plane FALSE Behind fence, grass 1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9710760196868 40.7725506006789)
1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running (from a dog) 0 0 0 0 0 0 1 0   POINT (-73.97186968288 40.778926988884)
1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
2324 -73.9737247632185 40.7759469280872 12C-PM-1017-01 12C PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 digging/burying,drinking from lake 0 0 0 0 1 0 1 0   POINT (-73.9737247632185 40.7759469280872)
596 -73.9769319450348 40.7743883576247 9A-AM-1013-11 09A AM 10132018 11 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE foot of tree 1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9769319450348 40.7743883576247)
993 -73.97724226646571 40.773436329163 8A-AM-1013-02 08A AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE playground 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9772422664657 40.773436329163)
943 -73.9773096718574 40.773805386248895 8A-AM-1013-06 08A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9773096718574 40.7738053862489)
419 -73.9777328709928 40.7669087724668 1D-AM-1006-02 01D AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9777328709928 40.7669087724668)
2426 -73.9790203973636 40.768883711483205 3B-AM-1010-02 03B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 together w/ #3 0 0 0 0 0 0 0 1   POINT (-73.9790203973636 40.7688837114832)

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