squirrels

23 rows where Date = 10102018, Foraging = "true", Police Precincts = 13 and Running = "true" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Running ✖

  • true · 23 ✖

Police Precincts ✖

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
429 429 -73.9694784056618 40.7787735291442 16D-PM-1010-01 16D PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9694784056618 40.7787735291442)   19 4 19 13
514 514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true false false true   false true false false false false false false   POINT (-73.9768357173861 40.7683813358343)   19 4 19 13
563 563 -73.9700330712119 40.7782913925727 16D-PM-1010-06 16D PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   true false false false true walking false false false false false false false false checking me out POINT (-73.9700330712119 40.7782913925727)   19 4 19 13
828 828 -73.9545101041865 40.7903823616782 34I-PM-1010-03 34I PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE in the playground. true false false false true with some nuts in the mouth false false false false false false false false   POINT (-73.9545101041865 40.7903823616782)   19 4 19 13
903 903 -73.9719941577406 40.77037129313 7G-AM-1010-04 07G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9719941577406 40.77037129313)   19 4 19 13
1000 1000 -73.9805137046778 40.769275143797 2A-AM-1010-08 02A AM 10102018 8 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9805137046778 40.769275143797)   19 4 19 13
1293 1293 -73.9775465365348 40.7681943707876 3D-PM-1010-09 03D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9775465365348 40.7681943707876)   19 4 19 13
1532 1532 -73.9779263114572 40.7682681855369 3D-PM-1010-08 03D PM 10102018 8 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9779263114572 40.7682681855369)   19 4 19 13
1567 1567 -73.9774407362587 40.7698056129554 4C-PM-1010-12 04C PM 10102018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774407362587 40.7698056129554)   19 4 19 13
1606 1606 -73.9628932797886 40.7923116396365 32B-PM-1010-05 32B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9628932797886 40.7923116396365)   19 4 19 13
1763 1763 -73.9768286349595 40.7687012827059 3D-PM-1010-05 03D PM 10102018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9768286349595 40.7687012827059)   19 4 19 13
1909 1909 -73.9772070122251 40.7694343352509 4C-PM-1010-02 04C PM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.97720701222511 40.7694343352509)   19 4 19 13
1913 1913 -73.9774630821854 40.7680626674086 3D-PM-1010-11 03D PM 10102018 11 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774630821854 40.76806266740861)   19 4 19 13
1996 1996 -73.977641787698 40.7695830265784 4C-PM-1010-10 04C PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.977641787698 40.7695830265784)   19 4 19 13
2080 2080 -73.954530253849 40.7910247489879 34I-PM-1010-07 34I PM 10102018 7 Adult Gray   Gray+         true false false false true   false false false false false false false false   POINT (-73.954530253849 40.7910247489879)   19 4 19 13
2152 2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9686925781295 40.7705688673142)   19 4 19 13
2163 2163 -73.9643664403785 40.7793670703727 19H-AM-1010-01 19H AM 10102018 1   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false false false false true false run from human w/ dog POINT (-73.9643664403785 40.7793670703727)   19 4 19 13
2240 2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9697787673802 40.7781746195436)   19 4 19 13
2259 2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   true false true false true   false false false false false false true false   POINT (-73.975565603566 40.7738462518304)   19 4 19 13
2574 2574 -73.978199543688 40.7695660563362 4C-PM-1010-17 04C PM 10102018 17 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE climbed up tree true false true false true   false false false false true false false true   POINT (-73.978199543688 40.7695660563362)   19 4 19 13
2644 2644 -73.9775445441194 40.7697096533728 4C-PM-1010-13 04C PM 10102018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9775445441194 40.7697096533728)   19 4 19 13
2999 2999 -73.972415182837 40.773080463452 10E-AM-1010-02 10E AM 10102018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   true false false false true   false false false false true false true false   POINT (-73.972415182837 40.773080463452)   19 4 19 13
1330 1330 -73.9643032554205 40.7794514526463 19H-AM-1010-02 19H AM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false true false true false false ran from human with dog POINT (-73.9643032554205 40.7794514526463)   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 4400.075ms