squirrels

9 rows where Combination of Primary and Highlight Color = "Cinnamon+", Date = 10132018 and Foraging = "true" sorted by Approaches

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Color notes, Specific Location, Running, Eating, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Police Precincts

Foraging

  • true · 9

Date

  • 10132018 · 9

Combination of Primary and Highlight Color

  • Cinnamon+ · 9
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
88 -73.9683608295976 40.7842927405327 22B-AM-1013-04 22B AM 10132018 4 Adult Cinnamon   Cinnamon+   Ground Plane FALSE Under bench false false false false true   false false false false false false false true ran from dog-walker POINT (-73.9683608295976 40.7842927405327)   19 4 19 13
412 -73.9785675798034 40.7672992405289 1C-PM-1013-05 01C PM 10132018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9785675798034 40.7672992405289)   19 4 19 13
1379 -73.9796470494747 40.7678370925485 1C-PM-1013-08 01C PM 10132018 8 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9796470494747 40.7678370925485)   19 4 19 13
1558 -73.968200390984 40.7837095769482 22B-AM-1013-02 22B AM 10132018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true climbed tree false false false false false false true false   POINT (-73.968200390984 40.7837095769482)   19 4 19 13
2411 -73.9686907918759 40.7839462261858 22B-AM-1013-03 22B AM 10132018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9686907918759 40.7839462261858)   19 4 19 13
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 true false false true true   false false false false true false true true   POINT (-73.9596083366477 40.7949526729608)   19 4 19 13
2505 -73.9762974698771 40.7740076116964 9B-PM-1013-06 09B PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9762974698771 40.7740076116964)   19 4 19 13
2601 -73.979636950073 40.7677999753976 1C-PM-1013-10 01C PM 10132018 10 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.979636950073 40.7677999753976)   19 4 19 13
79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false true true eating (a mushroom),circles around us,really fat,scratching himself,grooming activity false false false false true true false false   POINT (-73.9610705592868 40.7914829661051)   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 69.487ms