squirrels

7 rows where Hectare Squirrel Number = 2 and Location = "" sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail twitches, Indifferent

Runs from

Location

Hectare Squirrel Number

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
92 -73.9565759733611 40.7992461674802 42C-AM-1007-02 42C AM 10072018 2       +         false false false false false   false true false false false false false false   POINT (-73.9565759733611 40.7992461674802)   19 4 19 13
1112 -73.9583934264026 40.7854742185504 27I-AM-1007-02 27I AM 10072018 2       +         false false false false false   true false false false false false false false   POINT (-73.9583934264026 40.785474218550405)   19 4 19 13
1372 -73.9528353702209 40.7976456178263 41F-PM-1019-02 41F PM 10192018 2       +         false false false false false   false false false false false false false false   POINT (-73.9528353702209 40.7976456178263)   19 4 19 13
2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         false false false true false   false false false false true false true false   POINT (-73.9681960138614 40.7726867422002)   19 4 19 13
68 -73.9694240327509 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         false false false true true   false false false false false false true false   POINT (-73.96942403275091 40.7755898126674)   19 4 19 13
2347 -73.9663124560664 40.779544003786 18F-PM-1008-02 18F PM 10082018 2 Adult Gray   Gray+         false false false false false hopping around false false false false false false false true   POINT (-73.9663124560664 40.779544003786)   19 4 19 13
1064 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon         true false true false false   false false false false false false true true   POINT (-73.9540257319561 40.798408619116)   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 58.121ms