squirrels

21 rows where Combination of Primary and Highlight Color = "Cinnamon+White", Indifferent = "true" and Shift = "AM" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches

Hectare Squirrel Number ✖

Indifferent ✖

  • true · 21 ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+White · 21 ✖
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
12 12 -73.9683613516225 40.7725908847499 11H-AM-1010-03 11H AM 10102018 3 Adult Cinnamon White Cinnamon+White         false false false false true   false false false false true false true false   POINT (-73.9683613516225 40.7725908847499)   19 4 19 13
68 68 -73.9694240327509 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         false false false true true   false false false false false false true false   POINT (-73.96942403275091 40.7755898126674)   19 4 19 13
199 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
405 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
485 485 -73.9677423154682 40.7728813350245 11I-AM-1012-02 11I AM 10122018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9677423154682 40.77288133502451)   19 4 19 13
800 800 -73.9682144039334 40.7773070675393 15F-AM-1007-08 15F AM 10072018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9682144039334 40.7773070675393)   19 4 19 13
967 967 -73.9683994064731 40.7710765500799 9I-AM-1014-06 09I AM 10142018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false true   false false false false false false true false   POINT (-73.96839940647311 40.7710765500799)   19 4 19 13
1140 1140 -73.9615817859213 40.7945839663845 35A-AM-1014-08 35A AM 10142018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.9615817859213 40.79458396638451)   19 4 19 13
1233 1233 -73.9722281263634 40.7704083288013 7G-AM-1010-06 07G AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9722281263634 40.7704083288013)   19 4 19 13
1246 1246 -73.9543044385367 40.7984498571338 41E-AM-1007-04 41E AM 10072018 4 Adult Cinnamon White Cinnamon+White white haunches/tail Ground Plane FALSE rubbing belly on ground false false false false true   false false false false false false true false   POINT (-73.9543044385367 40.798449857133804)   19 4 19 13
1418 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
2007 2007 -73.9684834138222 40.7724289120211 11H-AM-1010-06 11H AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false true false false false   false false false false true false true false   POINT (-73.9684834138222 40.7724289120211)   19 4 19 13
2081 2081 -73.9675718059539 40.7786049141486 17F-AM-1007-06 17F AM 10072018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 8   false false true false false   false false false false false false true false   POINT (-73.9675718059539 40.7786049141486)   19 4 19 13
2190 2190 -73.9657040391563 40.7755567428199 15I-AM-1008-06 15I AM 10082018 6 Adult Cinnamon White Cinnamon+White   Above Ground 12   false false false true false   false false false false false false true false   POINT (-73.9657040391563 40.7755567428199)   19 4 19 13
2252 2252 -73.9537703231359 40.7915959393814 35I-AM-1013-01 35I AM 10132018 1 Adult Cinnamon White Cinnamon+White White underbelly Above Ground 18   false false true false false   false false false false false false true false   POINT (-73.9537703231359 40.7915959393814)   19 4 19 13
2268 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
2539 2539 -73.9781033448468 40.7666724066213 1D-AM-1006-03 01D AM 10062018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9781033448468 40.7666724066213)   19 4 19 13
2547 2547 -73.9743393747021 40.7676346798325 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9743393747021 40.7676346798325)   19 4 19 13
2732 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
2478 2478 -73.9674931070324 40.7783693690954 17F-AM-1007-04 17F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Above Ground 4   false false false true false chilling true false false false false false true false   POINT (-73.9674931070324 40.7783693690954)   19 4 19 13
1001 1001 -73.9801985977846 40.7680159511705 1B-AM-1012-11 01B AM 10122018 11 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false fighting w/ pigeons false false false false false false true false   POINT (-73.9801985977846 40.7680159511705)   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 74.473ms