squirrels

18 rows where Chasing = "true" and Date = 10182018

View and edit SQL

Suggested facets: Hectare, Shift, 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, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Runs from, Other Interactions

Indifferent

Date

  • 10182018 · 18

Chasing

  • true · 18
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
82 -73.9688271202401 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false true false true false   POINT (-73.9688271202401 40.7809719445309)   19 4 19 13
598 -73.9698196671161 40.7802972001469 18C-PM-1018-03 18C PM 10182018 3 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9698196671161 40.7802972001469)   19 4 19 13
627 -73.9763791121438 40.770281512254 5D-PM-1018-04 05D PM 10182018 4 Adult Gray White Gray+White Partial missing tail Ground Plane FALSE   false true false false false chasing (dog chasing) false false false false false false false true   POINT (-73.9763791121438 40.770281512254)   19 4 19 13
751 -73.9683479943823 40.7815827298303 20C-PM-1018-01 20C PM 10182018 1 Juvenile Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9683479943823 40.7815827298303)   19 4 19 13
1007 -73.9635317822977 40.7821352080233 22G-AM-1018-01 22G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   true false false true false false true false   POINT (-73.9635317822977 40.7821352080233)   19 4 19 13
1147 -73.9631818528816 40.7925332194132 32A-AM-1018-01 32A AM 10182018 1 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631818528816 40.7925332194132)   19 4 19 13
1393 -73.9687134137786 40.7812207913391 19C-PM-1018-03 19C PM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9687134137786 40.7812207913391)   19 4 19 13
1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   false true false true true   false false false false true false true false   POINT (-73.9704677007779 40.7786860108302)   19 4 19 13
1415 -73.9678561384348 40.7782877397822 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false true false false false   false false false true false false false false gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)   19 4 19 13
1451 -73.9645365195454 40.7781531021263 18H-AM-1018-02 18H AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   Tree true true false false false playing? false false false false false false false false   POINT (-73.9645365195454 40.7781531021263)   19 4 19 13
1509 -73.9556450015702 40.7967188058002 39E-AM-1018-04 39E AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9556450015702 40.7967188058002)   19 4 19 13
1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9630381400083 40.7807571827321)   19 4 19 13
1539 -73.9681874036914 40.7817948690964 20C-PM-1018-02 20C PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9681874036914 40.7817948690964)   19 4 19 13
1989 -73.9631646754647 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631646754647 40.7925716810884)   19 4 19 13
2018 -73.9697924026634 40.7803611152023 18C-PM-1018-04 18C PM 10182018 4 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9697924026634 40.7803611152023)   19 4 19 13
2313 -73.9646174034945 40.7781287528262 18H-AM-1018-01 18H AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Running from one tree to the other true true false false false playing? false false false false false false false false   POINT (-73.9646174034945 40.7781287528262)   19 4 19 13
2676 -73.9692849074642 40.7708755098145 9H-PM-1018-06 09H PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9692849074642 40.7708755098145)   19 4 19 13
2930 -73.9692563597762 40.770904999952 9H-PM-1018-05 09H PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9692563597762 40.770904999952)   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 132.984ms