squirrels

34 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon, White", Date = 10062018 and Police Precincts = 13 sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Age, Location, Above Ground Sighter Measurement, Climbing, Eating, Foraging, Kuks, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Tail flags ✖

Police Precincts ✖

Date ✖

  • 10062018 · 34 ✖

Combination of Primary and Highlight Color ✖

  • Gray+Cinnamon, White · 34 ✖
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
104 104 -73.9764036522984 40.7705846185121 5C-AM-1006-05 05C AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9764036522984 40.7705846185121)   19 4 19 13
131 131 -73.9755560786227 40.7662992317575 2F-AM-1006-05 02F AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false false curious but shy POINT (-73.9755560786227 40.7662992317575)   19 4 19 13
260 260 -73.978436117932 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree false false true false false   true false false false false false false false   POINT (-73.978436117932 40.7724769242403)   19 4 19 13
335 335 -73.9782351435852 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true false true false   false false false true true false false false   POINT (-73.9782351435852 40.7715896672335)   19 4 19 13
540 540 -73.9746802194012 40.7731347452245 9C-PM-1006-01 09C PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9746802194012 40.7731347452245)   19 4 19 13
570 570 -73.9745227769788 40.7673618284782 3F-AM-1006-09 03F AM 10062018 9 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE in grass by light post false false false false true   false false false false false false true false   POINT (-73.9745227769788 40.76736182847821)   19 4 19 13
670 670 -73.9602398690946 40.7910157676119 32D-PM-1006-04 32D PM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   false false false true false   false false false false true false true false   POINT (-73.9602398690946 40.7910157676119)   19 4 19 13
728 728 -73.9602913105578 40.7910635810038 32D-PM-1006-03 32D PM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   false false false true false   false false false false true false true false   POINT (-73.9602913105578 40.7910635810038)   19 4 19 13
787 787 -73.9725157534356 40.7658376729234 2I-PM-1006-02 02I PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9725157534356 40.7658376729234)   19 4 19 13
790 790 -73.9745040517502 40.77333038538 9C-PM-1006-06 09C PM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97450405175022 40.77333038538)   19 4 19 13
816 816 -73.9785300509908 40.7721127748427 6A-AM-1006-07 06A AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9785300509908 40.7721127748427)   19 4 19 13
961 961 -73.9731457102903 40.7660255393205 2H-AM-1006-03 02H AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9731457102903 40.7660255393205)   19 4 19 13
1048 1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree false false true false false   false false false true true false false false curious POINT (-73.9782120139407 40.7717154468791)   19 4 19 13
1201 1201 -73.9782813538421 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true true false false   false false false true false false false false   POINT (-73.9782813538421 40.7715730368712)   19 4 19 13
1243 1243 -73.9745556229855 40.7672921040998 3F-AM-1006-07 03F AM 10062018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE close to tall tree & light post false false false false true   false false false false false false true false   POINT (-73.9745556229855 40.7672921040998)   19 4 19 13
1303 1303 -73.9603302382958 40.7910100435196 32D-PM-1006-01 32D PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false true false false true   POINT (-73.9603302382958 40.7910100435196)   19 4 19 13
1335 1335 -73.969560591279 40.7705619840715 8I-AM-1006-09 08I AM 10062018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false false false very curious,looked like it expected food POINT (-73.969560591279 40.7705619840715)   19 4 19 13
1519 1519 -73.971730277301 40.7748805439381 11D-PM-1006-05 11D PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.971730277301 40.7748805439381)   19 4 19 13
1555 1555 -73.9784942525972 40.7672600003683 1D-AM-1006-06 01D AM 10062018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false false tumbling false false false false false false false false   POINT (-73.9784942525972 40.7672600003683)   19 4 19 13
1600 1600 -73.9753093777 40.7666673897583 2F-AM-1006-04 02F AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Beautiful white puff at the end of its tail Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.97530937770001 40.7666673897583)   19 4 19 13
1788 1788 -73.9685567075413 40.7703797723105 8I-AM-1006-10 08I AM 10062018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3 bush false false true false false   false false false false false false false true   POINT (-73.96855670754131 40.7703797723105)   19 4 19 13
2066 2066 -73.9784610031588 40.7668839966177 1D-AM-1006-07 01D AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9784610031588 40.7668839966177)   19 4 19 13
2067 2067 -73.9725077933574 40.7654562710325 2I-PM-1006-01 02I PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 Sitting on back of bench with food hanging from mouth false false false false false staring at me false false false false false false false true   POINT (-73.9725077933574 40.7654562710325)   19 4 19 13
2289 2289 -73.9745800592393 40.767356541975 3F-AM-1006-08 03F AM 10062018 8 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE close to tall tree & light post true false false false true   false false false false false false true false   POINT (-73.9745800592393 40.767356541975)   19 4 19 13
2299 2299 -73.9605554843228 40.7901473714024 31E-PM-1006-09 31E PM 10062018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9605554843228 40.7901473714024)   19 4 19 13
2785 2785 -73.9729105002306 40.7672758037086 4H-PM-1006-02 04H PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9729105002306 40.7672758037086)   19 4 19 13
2858 2858 -73.9728723853967 40.7670816164986 4H-PM-1006-01 04H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9728723853967 40.7670816164986)   19 4 19 13
2863 2863 -73.9698246369929 40.7711472794488 9H-AM-1006-04 09H AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9698246369929 40.7711472794488)   19 4 19 13
2873 2873 -73.955068474109 40.7911788152878 34H-PM-1006-05 34H PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White white tail tip Ground Plane FALSE in grass true false false false true   false false false false false false false false   POINT (-73.955068474109 40.7911788152878)   19 4 19 13
162 162 -73.957219204335 40.7931529059779 35E-PM-1006-01 35E PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false looking/begging for food POINT (-73.957219204335 40.7931529059779)   19 4 19 13
230 230 -73.9731498064872 40.7659963196581 2H-AM-1006-02 02H AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true true false false   false false false false false true false false   POINT (-73.9731498064872 40.7659963196581)   19 4 19 13
362 362 -73.9571407991577 40.7931917396406 35E-PM-1006-02 35E PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false begging for food POINT (-73.9571407991577 40.7931917396406)   19 4 19 13
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass false false false true true   false false false false true true false false   POINT (-73.9713379914423 40.7696367609606)   19 4 19 13
2856 2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path false false false false true   false false false false false true false false   POINT (-73.9751615527833 40.767013871509)   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 22564.801ms