squirrels

8 rows where Above Ground Sighter Measurement = 5, Climbing = "false", Foraging = "false", Indifferent = "true" and Police Precincts = 13 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Hectare, Shift, Date, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Eating, Other Activities, Kuks

Hectare Squirrel Number

Police Precincts

Indifferent

  • true · 8

Foraging

  • false · 8

Climbing

  • false · 8
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
747 -73.9771422625274 40.772361415776 7B-AM-1008-02 07B AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false true false false false   false false false false false false true false   POINT (-73.9771422625274 40.772361415776)   19 4 19 13
811 -73.9771695272048 40.7724277276263 7B-AM-1008-03 07B AM 10082018 3 Adult Gray   Gray+   Above Ground 5   false true false false false   false false false false false false true false   POINT (-73.9771695272048 40.7724277276263)   19 4 19 13
1065 -73.9769700777377 40.7728489574967 7B-AM-1008-08 07B AM 10082018 8 Adult Gray   Gray+   Above Ground 5   true false false false false   false false false false false false true false   POINT (-73.9769700777377 40.7728489574967)   19 4 19 13
1527 -73.970216605149 40.7702960667277 8H-PM-1014-08 08H PM 10142018 8 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#7),playing? false false false false false false true false   POINT (-73.970216605149 40.7702960667277)   19 4 19 13
1817 -73.9703076450783 40.770158422629 8H-PM-1014-07 08H PM 10142018 7 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#8),playing? false false false false false false true false   POINT (-73.9703076450783 40.770158422629)   19 4 19 13
1955 -73.9606559309874 40.7889527629826 30E-AM-1008-02 30E AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false true false false false   true false false false false false true false   POINT (-73.9606559309874 40.7889527629826)   19 4 19 13
2654 -73.9549261242548 40.7944701994615 37G-AM-1014-04 37G AM 10142018 4 Adult Gray   Gray+   Above Ground 5   false true false false false playing false false false false false false true false   POINT (-73.9549261242548 40.7944701994615)   19 4 19 13
1863 -73.9682830510954 40.7810151087286 19D-PM-1008-03 19D PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White may be same squirrel as #1 - male Above Ground 5 on branch of dead tree false false false true false   false false false false false false true false   POINT (-73.9682830510954 40.7810151087286)   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 67.625ms