squirrels

9 rows where Date = 10192018, Hectare Squirrel Number = 4 and Indifferent = "true"

View and edit SQL

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

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
273 -73.9579218587172 40.7960605028848 38C-AM-1019-04 38C AM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   true true false false false false true false   POINT (-73.9579218587172 40.79606050288481)   19 4 19 13
343 -73.9730224561601 40.7796833353894 16A-PM-1019-04 16A PM 10192018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9730224561601 40.7796833353894)   19 4 19 13
999 -73.980948293606 40.7685688850628 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.980948293606 40.7685688850628)   19 4 19 13
1026 -73.9710951149579 40.772501245008 10F-PM-1019-04 10F PM 10192018 4 Adult Black   Black+   Ground Plane FALSE Behind fence, grass false false false false true   false false false false false false true false   POINT (-73.9710951149579 40.772501245008)   19 4 19 13
1583 -73.9701030393506 40.7838953063625 21A-AM-1019-04 21A AM 10192018 4 Juvenile Gray Black Gray+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9701030393506 40.7838953063625)   19 4 19 13
1591 -73.9576223390082 40.7979746639647 40B-AM-1019-04 40B AM 10192018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true false true   false false false false false true true false   POINT (-73.9576223390082 40.79797466396471)   19 4 19 13
2140 -73.9598875541307 40.7973415580717 38A-AM-1019-04 38A AM 10192018 4 Adult Gray   Gray+   Above Ground 2   false false false false false walking false false false false false false true false   POINT (-73.9598875541307 40.7973415580717)   19 4 19 13
2295 -73.9590632051055 40.7963146584827 38B-AM-1019-04 38B AM 10192018 4 Adult Gray   Gray+   Above Ground 20   false false false false false sitting in tree true true false true false false true false observant POINT (-73.9590632051055 40.7963146584827)   19 4 19 13
2987 -73.9563724838337 40.7882504581015 31I-PM-1019-04 31I PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.95637248383372 40.7882504581015)   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 60.415ms