squirrels

36 rows where Combination of Primary and Highlight Color = "Cinnamon+White" and Indifferent = "true" sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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

Runs from ✖

Indifferent ✖

  • true · 36 ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+White · 36 ✖
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
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
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
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
495 495 -73.9801007327506 40.7677455633932 1B-PM-1019-06 01B PM 10192018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9801007327506 40.7677455633932)   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
1177 1177 -73.9807898224726 40.768215817511 1A-PM-1014-04 01A PM 10142018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9807898224726 40.768215817511)   19 4 19 13
247 247 -73.9733117663541 40.7694584620114 6F-PM-1008-05 06F PM 10082018 5 Adult Cinnamon White Cinnamon+White white patch Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97331176635412 40.7694584620114)   19 4 19 13
1129 1129 -73.9744906832678 40.7699948746776 6E-PM-1010-05 06E PM 10102018 5 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE   false false false true false could this squirrel be eating a white mushroom? false false false false false false true false   POINT (-73.9744906832678 40.76999487467761)   19 4 19 13
2946 2946 -73.974515099169 40.7700650799886 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false true false true false chasing #4 false false false false false false true false   POINT (-73.974515099169 40.770065079988605)   19 4 19 13
1536 1536 -73.9746128451271 40.7700957046709 6E-PM-1010-02 06E PM 10102018 2 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false false false false true   false false false false false false true false   POINT (-73.9746128451271 40.7700957046709)   19 4 19 13
1282 1282 -73.974451175321 40.7701294635264 6E-PM-1010-04 06E PM 10102018 4 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false true false true false chasing #3 false false false false false false true false   POINT (-73.974451175321 40.7701294635264)   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
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
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
640 640 -73.9785536529136 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground false true false false true   false false false false false false true false   POINT (-73.9785536529136 40.771618450500206)   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
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
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
375 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
424 424 -73.9756557086441 40.773296289824 8B-PM-1012-08 08B PM 10122018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9756557086441 40.773296289824)   19 4 19 13
2317 2317 -73.9767369686171 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9767369686171 40.7735074437085)   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
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
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
2099 2099 -73.9685612289881 40.7778488829217 16E-PM-1018-08 16E PM 10182018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9685612289881 40.7778488829217)   19 4 19 13
2897 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
2171 2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk false false true false false   false false false false true false true false   POINT (-73.9686370726471 40.7780382348833)   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
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
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
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
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
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
1961 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
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

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 72.161ms