squirrels

42 rows where Combination of Primary and Highlight Color = "Cinnamon+White" and Shift = "AM"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Runs from ✖

Indifferent ✖

Shift ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+White · 42 ✖
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
27 27 -73.9670628558161 40.7734991420941 12I-AM-1013-01 12I AM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on tree roots false false false false false sitting false false false false true false false true   POINT (-73.9670628558161 40.77349914209411)   19 4 19 13
63 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
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
268 268 -73.968107276769 40.7768612676036 15F-AM-1007-09 15F AM 10072018 9 Adult Cinnamon White Cinnamon+White   Above Ground 20   false false true false true   false false false false false false false true   POINT (-73.968107276769 40.7768612676036)   19 4 19 13
349 349 -73.9689657039917 40.7767834276767 15F-AM-1007-04 15F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9689657039917 40.7767834276767)   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
464 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 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
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
667 667 -73.9624538733037 40.7883829851518 28D-AM-1012-04 28D AM 10122018 4 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9624538733037 40.7883829851518)   19 4 19 13
699 699 -73.9504693544225 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9504693544225 40.797225436004)   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
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
1075 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
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
1290 1290 -73.9668140804066 40.7768100147333 15G-AM-1008-06 15G AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9668140804066 40.7768100147333)   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
1617 1617 -73.9752029513644 40.7671734667361 3F-AM-1006-04 03F AM 10062018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on a rock false false false false true   false false false false false false false true   POINT (-73.9752029513644 40.7671734667361)   19 4 19 13
1650 1650 -73.9762494239719 40.7750175306716 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields false false false true false eating (a peanut) false false false false false true false false   POINT (-73.9762494239719 40.7750175306716)   19 4 19 13
1740 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
2005 2005 -73.9755259087781 40.7707256124181 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true true false   true false false false false true false false   POINT (-73.9755259087781 40.7707256124181)   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
2044 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
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
2344 2344 -73.9786310308892 40.7669349368183 1D-AM-1006-05 01D AM 10062018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false true false false false   POINT (-73.9786310308892 40.7669349368183)   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
2503 2503 -73.974382557804 40.7674812627373 3F-AM-1006-10 03F AM 10062018 10 Adult Cinnamon White Cinnamon+White   Above Ground 6 on fence false false true false false   false false false false false false false false clueless POINT (-73.974382557804 40.7674812627373)   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
2550 2550 -73.9694805745522 40.7743556902843 12F-AM-1020-01 12F AM 10202018 1 Adult Cinnamon White Cinnamon+White   Above Ground 17 Tree false false false false false jumping false false false false false false false false   POINT (-73.9694805745522 40.7743556902843)   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
2742 2742 -73.9628041577934 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   false false false true false   false false false false false false false true   POINT (-73.9628041577934 40.78841801560551)   19 4 19 13
2886 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
2900 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 95.053ms