squirrels

19 rows where Date = 10122018 and Hectare Squirrel Number = 5 sorted by Color notes

✎ View and edit SQL

This data as json, CSV (advanced)

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

Police Precincts ✖

Hectare Squirrel Number ✖

Date ✖

  • 10122018 · 19 ✖
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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
447 447 -73.9725906016474 40.7713889729739 8F-PM-1012-05 08F PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false false   POINT (-73.9725906016474 40.7713889729739)   19 4 19 13
571 571 -73.9659549963516 40.7833659689194 22D-PM-1012-05 22D PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White         false false false true false   false false false false false false true false   POINT (-73.9659549963516 40.7833659689194)   19 4 19 13
590 590 -73.9785133301426 40.7718260288338 6A-PM-1012-05 06A PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9785133301426 40.7718260288338)   19 4 19 13
765 765 -73.96797780019 40.7847629473258 23B-PM-1012-05 23B PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 chain link fence false true true false false   false false false false false false true false   POINT (-73.96797780019 40.7847629473258)   19 4 19 13
1165 1165 -73.9689504114652 40.7766770153764 14F-PM-1012-05 14F PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 2 on a fallen branch true false false true false sitting false false false false false false false false looking at me POINT (-73.9689504114652 40.7766770153764)   19 4 19 13
1292 1292 -73.959019987128 40.7912546691805 33E-PM-1012-05 33E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing false false false false false false false false   POINT (-73.959019987128 40.7912546691805)   19 4 19 13
1428 1428 -73.9666113598566 40.7752662550312 14H-PM-1012-05 14H PM 10122018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false approaches (someone was feeding it) POINT (-73.9666113598566 40.7752662550312)   19 4 19 13
1456 1456 -73.9714242426496 40.7744535798123 11E-PM-1012-05 11E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true foraging (foraged,ran to tree root,munched) false false false false false false true false   POINT (-73.9714242426496 40.7744535798123)   19 4 19 13
1487 1487 -73.965394655961 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   true false true false true burying the food on ground false false false false false false false false look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)   19 4 19 13
1568 1568 -73.9681079869821 40.7723494081345 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9681079869821 40.7723494081345)   19 4 19 13
1845 1845 -73.9626560807032 40.7884633049896 28D-AM-1012-05 28D AM 10122018 5 Juvenile Black   Black+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9626560807032 40.7884633049896)   19 4 19 13
1947 1947 -73.9747175419546 40.7692820030878 5E-PM-1012-05 05E PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false true false false begging POINT (-73.9747175419546 40.7692820030878)   19 4 19 13
2002 2002 -73.9581706950566 40.7906321397269 32F-AM-1012-05 32F AM 10122018 5 Adult Gray White Gray+White   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9581706950566 40.7906321397269)   19 4 19 13
2106 2106 -73.9801651470389 40.7677698656935 1B-AM-1012-05 01B AM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9801651470389 40.7677698656935)   19 4 19 13
2155 2155 -73.9538938706987 40.7981150065974 42E-PM-1012-05 42E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9538938706987 40.7981150065974)   19 4 19 13
2176 2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false true   true false false true true false false true   POINT (-73.95832017896151 40.7913938722521)   19 4 19 13
2306 2306 -73.956453902485 40.7936584431012 36F-PM-1012-05 36F PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.956453902485 40.7936584431012)   19 4 19 13
2317 2317 -73.9767369686171 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9767369686171 40.7735074437085)   19 4 19 13
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false   true false false false false false false true   POINT (-73.9690082314914 40.7738993942891)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "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" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);
Powered by Datasette · Query took 68.044ms