squirrels

9 rows where Combination of Primary and Highlight Color = "Cinnamon+" and Hectare Squirrel Number = 5 sorted by Zip Codes descending

View and edit SQL

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Eating, Indifferent, Runs from

Tail twitches

Climbing

Hectare Squirrel Number

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
36 -73.9662438996681 40.7890381809441 28A-PM-1007-05 28A PM 10072018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9662438996681 40.7890381809441)   19 4 19 13
397 -73.9690416961886 40.7716618670996 10H-AM-1014-05 10H AM 10142018 5   Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9690416961886 40.7716618670996)   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
1382 -73.9611274898661 40.7915250069086 32C-AM-1014-05 32C AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9611274898661 40.7915250069086)   19 4 19 13
1394 -73.95488263914 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree true false true false true   false false false false true false true false   POINT (-73.95488263914 40.7959474571251)   19 4 19 13
1763 -73.9768286349595 40.7687012827059 3D-PM-1010-05 03D PM 10102018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9768286349595 40.7687012827059)   19 4 19 13
2464 -73.9691318044969 40.7709801974696 9I-AM-1014-05 09I AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9691318044969 40.7709801974696)   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
2612 -73.9711673006524 40.7747979614577 12E-PM-1018-05 12E PM 10182018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9711673006524 40.7747979614577)   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 106.504ms