2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Date = 10142018, Hectare Squirrel Number = 3 and Shift = "AM" sorted by Approaches

View and edit SQL

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

Shift

Hectare Squirrel Number

Date

  • 10142018 · 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
77 -73.9615696577673 40.7951278622399 35A-AM-1014-03 35A AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9615696577673 40.7951278622399)
330 -73.9708969246276 40.7767695507462 14D-AM-1014-03 14D AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9708969246276 40.7767695507462)
388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9592537496995 40.7919271821316)
649 -73.9554891003543 40.7968774599654 40E-AM-1014-03 40E AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9554891003543 40.79687745996541)
702 -73.963858549251 40.7808999610914 21G-AM-1014-03 21G AM 10142018 3 Adult Gray White Gray+White   Above Ground 7   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.963858549251 40.7808999610914)
891 -73.9613351649026 40.79098668513571 31D-AM-1014-03 31D AM 10142018 3   Gray White Gray+White   Ground Plane FALSE Undergrowth 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9613351649026 40.7909866851357)
898 -73.95428280532559 40.794179732035495 37G-AM-1014-03 37G AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9542828053256 40.7941797320355)
958 -73.9613862251332 40.791282169715 32C-AM-1014-03 32C AM 10142018 3 Adult Gray   Gray+   Above Ground 3   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9613862251332 40.791282169715)
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)
1310 -73.9546201403481 40.798942376865604 42D-AM-1014-03 42D AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9546201403481 40.7989423768656)
1355 -73.9655277320465 40.780612052936895 20F-AM-1014-03 20F AM 10142018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9655277320465 40.7806120529369)
1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   0 1 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9710801547498 40.7760872452093)
1992 -73.9586085843149 40.7946617684536 36C-AM-1014-03 36C AM 10142018 3   Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9586085843149 40.7946617684536)
2028 -73.96873477318609 40.7718955594385 10H-AM-1014-03 10H AM 10142018 3 Juvenile     +   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687347731861 40.7718955594385)
2041 -73.9651796685091 40.7785578267586 18G-AM-1014-03 18G AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9651796685091 40.7785578267586)
2096 -73.97089038621759 40.778737067464206 16C-AM-1014-03 16C AM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708903862176 40.7787370674642)
2286 -73.95544156650821 40.798420141601795 41D-AM-1014-03 41D AM 10142018 3 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9554415665082 40.7984201416018)
2763 -73.96260656728941 40.788722645116 29D-AM-1014-03 29D AM 10142018 3 Juvenile Gray   Gray+   Above Ground 35 End of tree limb foraging 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9626065672894 40.788722645116)
2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   0 1 1 0 0   0 1 0 0 0 0 0 0 looked at us from tree POINT (-73.9677903197449 40.7826561917755)
2948 -73.9545225586988 40.7956074663106 39F-AM-1014-03 39F AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9545225586988 40.7956074663106)
3013 -73.964661337306 40.7769785494935 17I-AM-1014-03 17I AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon face Above Ground 10   0 0 1 0 0 climbing (dog barked & it ran up tree) 0 0 0 0 0 0 1 0   POINT (-73.964661337306 40.7769785494935)
154 -73.9686056085297 40.7781658424866 16E-AM-1014-03 16E AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9686056085297 40.7781658424866)
2149 -73.9691845420174 40.7707749899254 9I-AM-1014-03 09I AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9691845420174 40.7707749899254)

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