squirrels

19 rows where Climbing = "true" and Combination of Primary and Highlight Color = "Cinnamon+White" sorted by Other Activities

✎ 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, Eating, Kuks, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Tail flags ✖

Foraging ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+White · 19 ✖

Climbing ✖

  • true · 19 ✖
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
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
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
844 844 -73.9642379942652 40.7774792520738 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false false was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)   19 4 19 13
931 931 -73.9785948413883 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false true   false false false false false false false false   POINT (-73.9785948413883 40.7718908026758)   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
1551 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
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
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
2153 2153 -73.9797122322834 40.7678347587435 1B-PM-1019-10 01B PM 10192018 10 Adult Cinnamon White Cinnamon+White   Above Ground   Dog chased up tree false false true false false   false false false false true false false false   POINT (-73.97971223228342 40.7678347587435)   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
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
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
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
2745 2745 -73.97296259363 40.7652601851275 1I-PM-1012-04 01I PM 10122018 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2 on ledge false false true false false   false false false false true false false true   POINT (-73.97296259363 40.7652601851275)   19 4 19 13
2779 2779 -73.9767835160078 40.7674030330482 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false true   POINT (-73.9767835160078 40.7674030330482)   19 4 19 13
2794 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

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