squirrels

13 rows where Date = 10202018, Hectare Squirrel Number = 2 and Police Precincts = 13

✎ 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, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Indifferent, Runs from, 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
7 7 -73.9719735582476 40.7693045133578 6G-PM-1020-02 06G PM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false true false   POINT (-73.9719735582476 40.7693045133578)   19 4 19 13
241 241 -73.9760256477558 40.7703573131398 5D-AM-1020-02 05D AM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true small jumps false false false false false false false false   POINT (-73.9760256477558 40.7703573131398)   19 4 19 13
264 264 -73.9698714743386 40.7743814661685 12F-AM-1020-02 12F AM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9698714743386 40.7743814661685)   19 4 19 13
1047 1047 -73.9580111056675 40.7854339401483 27I-PM-1020-02 27I PM 10202018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9580111056675 40.7854339401483)   19 4 19 13
1170 1170 -73.9647904085226 40.7911589002217 30A-PM-1020-02 30A PM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon back. Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE Rock false false false true false   false false false false false false false true   POINT (-73.9647904085226 40.7911589002217)   19 4 19 13
1218 1218 -73.953375642605 40.7947144477885 38G-PM-1020-02 38G PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.953375642605 40.7947144477885)   19 4 19 13
1263 1263 -73.9770873939997 40.7710379662106 6C-PM-1020-02 06C PM 10202018 2 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9770873939997 40.7710379662106)   19 4 19 13
1377 1377 -73.9752263564287 40.772084917017 7C-PM-1020-02 07C PM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9752263564287 40.772084917017)   19 4 19 13
1595 1595 -73.9754696312232 40.768191647092 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   false false true false true foraging (on the tree itself) false false false false false false true false   POINT (-73.9754696312232 40.768191647092)   19 4 19 13
1755 1755 -73.9714798196777 40.7695231949631 6H-PM-1020-02 06H PM 10202018 2 Adult     +   Above Ground   Fence pole false false true false false   false false false false false false false true runs from (me) POINT (-73.9714798196777 40.7695231949631)   19 4 19 13
2337 2337 -73.9673490137465 40.7782728130401 17F-PM-1020-02 17F PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false false true false   false false false false false false false true   POINT (-73.9673490137465 40.7782728130401)   19 4 19 13
2979 2979 -73.9571808775915 40.7934443866725 35E-AM-1020-02 35E AM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false false false false cleaning herself false false false false false false true false   POINT (-73.9571808775915 40.7934443866725)   19 4 19 13
3016 3016 -73.9756457597888 40.7703559775625 6D-PM-1020-02 06D PM 10202018 2 Juvenile Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false true   POINT (-73.9756457597888 40.7703559775625)   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 88.656ms