squirrels

17 rows where Combination of Primary and Highlight Color = "Gray+" and Hectare Squirrel Number = 11 sorted by Longitude

View and edit SQL

Suggested facets: Hectare, Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail twitches, Indifferent, Other Interactions

Police Precincts

Hectare Squirrel Number

Combination of Primary and Highlight Color

  • Gray+ · 17
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
2376 -73.9594204646985 40.7905923765213 32E-PM-1017-11 32E PM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9594204646985 40.7905923765213)   19 4 19 13
2236 -73.9597845469964 40.7906179303448 32E-AM-1007-11 32E AM 10072018 11 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9597845469964 40.7906179303448)   19 4 19 13
1344 -73.9618591510932 40.7921343738001 32C-PM-1013-11 32C PM 10132018 11 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9618591510932 40.7921343738001)   19 4 19 13
281 -73.9619411917909 40.7923536640283 33B-PM-1010-11 33B PM 10102018 11 Adult Gray   Gray+   Above Ground 10   false false false false false   false false false false false false false false   POINT (-73.9619411917909 40.7923536640283)   19 4 19 13
1743 -73.9635412640983 40.7902529354639 30B-AM-1007-11 30B AM 10072018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9635412640983 40.7902529354639)   19 4 19 13
1596 -73.9666945123922 40.7839956493194 22C-PM-1006-11 22C PM 10062018 11 Juvenile Gray   Gray+   Above Ground 13   false false true false false   true false false false false false false false   POINT (-73.9666945123922 40.7839956493194)   19 4 19 13
366 -73.9673548527075 40.7765669058396 15G-PM-1019-11 15G PM 10192018 11 Adult Gray   Gray+   Above Ground 4   false false true false false   false false false false false false false false stared POINT (-73.9673548527075 40.7765669058396)   19 4 19 13
1229 -73.9677751507448 40.7790990066658 17E-AM-1017-11 17E AM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE Shore true false false false false   false false false false false false true false   POINT (-73.9677751507448 40.7790990066658)   19 4 19 13
1016 -73.9691293546408 40.7703219076549 8I-AM-1006-11 08I AM 10062018 11 Adult Gray   Gray+   Above Ground 50 tree false true false false false   false false false false false false true false   POINT (-73.9691293546408 40.77032190765491)   19 4 19 13
1946 -73.9692925815903 40.7774506065008 15E-PM-1008-11 15E PM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9692925815903 40.7774506065008)   19 4 19 13
2098 -73.9700779726297 40.7722086251085 10G-AM-1006-11 10G AM 10062018 11 Juvenile Gray   Gray+   Above Ground 2   false false true false false   false false false false true false false false   POINT (-73.9700779726297 40.7722086251085)   19 4 19 13
1903 -73.9701379806066 40.7785234812393 16D-PM-1010-11 16D PM 10102018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9701379806066 40.7785234812393)   19 4 19 13
390 -73.970720187655 40.7774564799983 14D-PM-1019-11 14D PM 10192018 11 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.970720187655 40.7774564799983)   19 4 19 13
1278 -73.9729848996456 40.7707143294261 7F-AM-1008-11 07F AM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9729848996456 40.7707143294261)   19 4 19 13
1417 -73.974828939898 40.7668886121909 2F-PM-1014-11 02F PM 10142018 11 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.974828939898 40.7668886121909)   19 4 19 13
183 -73.9768434635084 40.7728494038744 7B-AM-1008-11 07B AM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9768434635084 40.7728494038744)   19 4 19 13
126 -73.9792155473689 40.7693711799946 3B-PM-1007-11 03B PM 10072018 11 Adult Gray   Gray+   Above Ground 5 in tree false false true false false   false false false false false false false false   POINT (-73.9792155473689 40.7693711799946)   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 99.437ms