squirrels

24 rows where Combination of Primary and Highlight Color = "Cinnamon+White" and Running = "true"

View and edit SQL

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

Climbing

Running

  • true · 24

Combination of Primary and Highlight Color

  • Cinnamon+White · 24
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
63 -73.9745630038492 40.7692602628745 5E-AM-1008-06 05E AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9745630038492 40.7692602628745)   19 4 19 13
199 -73.9771614686616 40.7709677983247 5C-AM-1006-02 05C AM 10062018 2 Adult Cinnamon White Cinnamon+White   Above Ground 10   true false true true false   false false false false false false true false   POINT (-73.9771614686616 40.7709677983247)   19 4 19 13
375 -73.9752000129992 40.7732918122239 8C-PM-1013-04 08C PM 10132018 4 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9752000129992 40.7732918122239)   19 4 19 13
405 -73.9786603147149 40.7671937837017 1D-AM-1006-09 01D AM 10062018 9 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false true false   POINT (-73.9786603147149 40.7671937837017)   19 4 19 13
464 -73.9664450399121 40.7887844904695 27A-AM-1008-02 27A AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9664450399121 40.7887844904695)   19 4 19 13
477 -73.9701481200298 40.7751110354034 12F-AM-1020-06 12F AM 10202018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9701481200298 40.7751110354034)   19 4 19 13
490 -73.978426472499 40.771904101844 6A-PM-1012-04 06A PM 10122018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.978426472499 40.771904101844)   19 4 19 13
514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true false false true   false true false false false false false false   POINT (-73.9768357173861 40.7683813358343)   19 4 19 13
1075 -73.9640534906634 40.7777383899836 17I-AM-1014-02 17I AM 10142018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false standing upright false false false false false true false true runs from (only ran away when a grandpa chased it off) POINT (-73.9640534906634 40.7777383899836)   19 4 19 13
1418 -73.9673924060436 40.7788781851716 17F-AM-1007-03 17F AM 10072018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9673924060436 40.7788781851716)   19 4 19 13
1551 -73.9785114291288 40.7719779589449 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785114291288 40.7719779589449)   19 4 19 13
1652 -73.9498421746221 40.7969397424182 42I-PM-1014-02 42I PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 8   true false false false false   false false false false false false false true   POINT (-73.9498421746221 40.7969397424182)   19 4 19 13
1740 -73.9577758125518 40.799384716477 41B-AM-1010-10 41B AM 10102018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9577758125518 40.799384716477)   19 4 19 13
1889 -73.9679319758284 40.7821154802399 20C-PM-1018-07 20C PM 10182018 7 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9679319758284 40.7821154802399)   19 4 19 13
1961 -73.953664715831 40.7981256393159 41E-PM-1013-04 41E PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false true false   POINT (-73.953664715831 40.7981256393159)   19 4 19 13
2044 -73.9771552326199 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   false false false true false true false false   POINT (-73.9771552326199 40.7706917595308)   19 4 19 13
2268 -73.9590191655172 40.7926139425111 34D-AM-1008-03 34D AM 10082018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9590191655172 40.7926139425111)   19 4 19 13
2278 -73.964539031099 40.7809916310012 20G-PM-1013-01 20G PM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.964539031099 40.7809916310012)   19 4 19 13
2620 -73.9771800098131 40.7708863131336 5C-PM-1010-03 05C PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9771800098131 40.7708863131336)   19 4 19 13
2732 -73.9694185786221 40.7787189999566 16D-AM-1007-06 16D AM 10072018 6 Adult Cinnamon White Cinnamon+White primary color: brown ( I marked cinnamon as closest to brown - JO) Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9694185786221 40.7787189999566)   19 4 19 13
2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   true false false true false false false true   POINT (-73.9712187890707 40.7750640173134)   19 4 19 13
2886 -73.9729265300533 40.7741768291642 10D-AM-1008-02 10D AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9729265300533 40.7741768291642)   19 4 19 13
2897 -73.9689554458632 40.7778593393957 16E-PM-1018-10 16E PM 10182018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9689554458632 40.7778593393957)   19 4 19 13
2900 -73.9631005470369 40.7885494057193 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9631005470369 40.7885494057193)   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 137.577ms