squirrels

10 rows where Combination of Primary and Highlight Color = "Cinnamon+", Foraging = "true" and Running = "true" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

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

Running ✖

  • true · 10 ✖

Police Precincts ✖

Foraging ✖

  • true · 10 ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+ · 10 ✖
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
36 36 -73.9662438996681 40.7890381809441 28A-PM-1007-05 28A PM 10072018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9662438996681 40.7890381809441)   19 4 19 13
120 120 -73.9511118711108 40.7950813345902 40I-AM-1018-01 40I AM 10182018 1 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true begging false false false false false false false false   POINT (-73.9511118711108 40.7950813345902)   19 4 19 13
125 125 -73.9651601541795 40.7761841788025 15I-PM-1012-07 15I PM 10122018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9651601541795 40.7761841788025)   19 4 19 13
1199 1199 -73.9756993198381 40.7681956641913 3E-PM-1008-08 03E PM 10082018 8 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9756993198381 40.7681956641913)   19 4 19 13
1394 1394 -73.95488263914 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree true false true false true   false false false false true false true false   POINT (-73.95488263914 40.7959474571251)   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
2483 2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people true false false true true   false false false false true false true true   POINT (-73.9596083366477 40.7949526729608)   19 4 19 13
2838 2838 -73.9507699667119 40.7955166039555 40I-AM-1018-02 40I AM 10182018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9507699667119 40.795516603955505)   19 4 19 13
79 79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false true true eating (a mushroom),circles around us,really fat,scratching himself,grooming activity false false false false true true false false   POINT (-73.9610705592868 40.7914829661051)   19 4 19 13
320 320 -73.9684376038582 40.7824275067237 20C-PM-1018-09 20C PM 10182018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false true false false   POINT (-73.9684376038582 40.7824275067237)   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 85.805ms