squirrels

20 rows where Date = 10082018, Eating = "true" and Highlight Fur Color = "Cinnamon"

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent

Runs from

Combination of Primary and Highlight Color

Highlight Fur Color

  • Cinnamon · 20

Eating

  • true · 20

Date

  • 10082018 · 20
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
54 -73.9760298241178 40.7681954366911 3E-PM-1008-07 03E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9760298241178 40.7681954366911)   19 4 19 13
112 -73.9651754464439 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree false false true true false   false false false false false false true false   POINT (-73.9651754464439 40.7755181941559)   19 4 19 13
210 -73.9711298491132 40.7676902603543 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing false false true true false   false false false true false false false false   POINT (-73.9711298491132 40.7676902603543)   19 4 19 13
615 -73.9653279069888 40.7758743113817 15I-AM-1008-02 15I AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon Could be same squirrel as #1? Above Ground 4 on fence false false false true false   false false false false false false false true   POINT (-73.9653279069888 40.7758743113817)   19 4 19 13
718 -73.9661694463488 40.7757530583569 15H-PM-1008-07 15H PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE along bottom of rock outcropping false false false true true   false false false false false false true false   POINT (-73.9661694463488 40.7757530583569)   19 4 19 13
1094 -73.9773898301093 40.7708581562057 5B-AM-1008-01 05B AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running across ball field 5,near home plate false false false false false false true false   POINT (-73.9773898301093 40.7708581562057)   19 4 19 13
1257 -73.9767247593654 40.7726200054197 7B-AM-1008-15 07B AM 10082018 15 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9767247593654 40.7726200054197)   19 4 19 13
1419 -73.9756017589251 40.7680335996527 3E-PM-1008-06 03E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9756017589251 40.7680335996527)   19 4 19 13
1472 -73.9698611971209 40.7753915552001 13F-PM-1008-02 13F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9698611971209 40.7753915552001)   19 4 19 13
1664 -73.9729142912203 40.7724091146678 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9729142912203 40.7724091146678)   19 4 19 13
1687 -73.9754790964561 40.768336388516 4E-PM-1008-07 04E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9754790964561 40.768336388516)   19 4 19 13
1878 -73.9761223919286 40.7685998275864 4E-PM-1008-06 04E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon         false false false true true   false false false false false false true false   POINT (-73.9761223919286 40.7685998275864)   19 4 19 13
1975 -73.9753291616796 40.7687376032936 4E-PM-1008-01 04E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false true false   POINT (-73.9753291616796 40.7687376032936)   19 4 19 13
1990 -73.9774584305147 40.7708133986192 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9774584305147 40.7708133986192)   19 4 19 13
2431 -73.9630054996358 40.7905225147022 30C-PM-1008-01 30C PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9630054996358 40.7905225147022)   19 4 19 13
2456 -73.9698446365683 40.7842607168578 22A-AM-1008-01 22A AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4 on fence false false false true false   false false false false false false false false   POINT (-73.9698446365683 40.7842607168578)   19 4 19 13
2489 -73.9663168490265 40.7825083721362 21D-AM-1008-01 21D AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false true true false true false   POINT (-73.9663168490265 40.7825083721362)   19 4 19 13
2515 -73.9693338657183 40.7757055884538 13F-PM-1008-05 13F PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 tree trunk true false false true true   true false false false true false false false   POINT (-73.9693338657183 40.77570558845381)   19 4 19 13
2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9777124331985 40.7704051056666)   19 4 19 13
2925 -73.9672152696834 40.7823874581829 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9672152696834 40.7823874581829)   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 60.251ms