squirrels

15 rows where Combination of Primary and Highlight Color = "Gray+", Date = 10132018 and Tail twitches = "true" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from, Other Interactions

Shift ✖

Foraging ✖

Tail twitches ✖

  • true · 15 ✖

Date ✖

  • 10132018 · 15 ✖

Combination of Primary and Highlight Color ✖

  • Gray+ · 15 ✖
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
109 109 -73.967097592707 40.7854119342538 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   true false false true false took nut to bury false false false false true false false true   POINT (-73.967097592707 40.7854119342538)   19 4 19 13
361 361 -73.9614824437251 40.7912929799884 32C-PM-1013-03 32C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false false   POINT (-73.9614824437251 40.7912929799884)   19 4 19 13
874 874 -73.9591957793992 40.7949568873453 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9591957793992 40.7949568873453)   19 4 19 13
979 979 -73.9612349421547 40.7959586475744 36A-PM-1013-09 36A PM 10132018 9   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH true false false false false   false false false false true false false true   POINT (-73.9612349421547 40.7959586475744)   19 4 19 13
1058 1058 -73.9737100743183 40.7708360121735 7E-PM-1013-03 07E PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Ground & Tree Base false false false false true   false false false true true false true false   POINT (-73.9737100743183 40.7708360121735)   19 4 19 13
1167 1167 -73.9593244415072 40.794964729747 36C-PM-1013-03 36C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9593244415072 40.794964729747)   19 4 19 13
1188 1188 -73.9669529835992 40.7871864151365 25A-AM-1013-05 25A AM 10132018 5   Gray   Gray+   Ground Plane FALSE CROSS BRIDLE - INTO TREE TO AVOID DOGGO true false true false false d.p.t. false false false true true false true false calm POINT (-73.96695298359921 40.7871864151365)   19 4 19 13
1352 1352 -73.9616770335086 40.7921648631096 32C-PM-1013-13 32C PM 10132018 13 Adult Gray   Gray+   Ground Plane FALSE   false false false false true buried nut false false false false true false false false   POINT (-73.9616770335086 40.7921648631096)   19 4 19 13
1553 1553 -73.9690645326017 40.7773822116124 15E-AM-1013-03 15E AM 10132018 3 Adult Gray   Gray+   Above Ground 2 on fallen log false false false false false   false false false false true false false true   POINT (-73.9690645326017 40.7773822116124)   19 4 19 13
1651 1651 -73.9763373510536 40.7741168933928 9B-PM-1013-09 09B PM 10132018 9 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false true runs from (people) POINT (-73.9763373510536 40.7741168933928)   19 4 19 13
1872 1872 -73.9613998967903 40.7912437235667 32C-PM-1013-02 32C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false false   POINT (-73.9613998967903 40.7912437235667)   19 4 19 13
1971 1971 -73.9591880400132 40.7950071252836 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   true true false false true false true false   POINT (-73.95918804001322 40.7950071252836)   19 4 19 13
2202 2202 -73.9556039997621 40.7977549157287 40D-AM-1013-05 40D AM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9556039997621 40.7977549157287)   19 4 19 13
2378 2378 -73.9747592855901 40.7763762870413 12A-PM-1013-01 12A PM 10132018 1 Adult Gray   Gray+ But it was kind of dark? Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9747592855901 40.7763762870413)   19 4 19 13
176 176 -73.9618064639153 40.792158440043 32C-PM-1013-12 32C PM 10132018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false true true false false   POINT (-73.9618064639153 40.792158440043)   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 76.236ms