squirrels

13 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon, White", Hectare Squirrel Number = 3, Indifferent = "true", Running = "false" and Runs from = "false" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Tail twitches, Other Interactions

Runs from ✖

  • false · 13 ✖

Running ✖

  • false · 13 ✖

Hectare Squirrel Number ✖

Combination of Primary and Highlight Color ✖

  • Gray+Cinnamon, White · 13 ✖
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
330 330 -73.9708969246276 40.7767695507462 14D-AM-1014-03 14D AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9708969246276 40.7767695507462)   19 4 19 13
714 714 -73.9691585756191 40.776340465695 14F-AM-1007-03 14F AM 10072018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9691585756191 40.776340465695)   19 4 19 13
728 728 -73.9602913105578 40.7910635810038 32D-PM-1006-03 32D PM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   false false false true false   false false false false true false true false   POINT (-73.9602913105578 40.7910635810038)   19 4 19 13
1068 1068 -73.96660639702 40.7756655031741 14H-AM-1007-03 14H AM 10072018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.96660639702002 40.7756655031741)   19 4 19 13
1681 1681 -73.9638141923763 40.7829225326288 23F-PM-1013-03 23F PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false indifferent (noticed me,busy eating,foraging) POINT (-73.9638141923763 40.7829225326288)   19 4 19 13
1863 1863 -73.9682830510954 40.7810151087286 19D-PM-1008-03 19D PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White may be same squirrel as #1 - male Above Ground 5 on branch of dead tree false false false true false   false false false false false false true false   POINT (-73.9682830510954 40.7810151087286)   19 4 19 13
2211 2211 -73.9799250782277 40.7676106598889 1B-AM-1012-03 01B AM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97992507822771 40.7676106598889)   19 4 19 13
2471 2471 -73.964274290774 40.7795319556023 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false ran from human w/ dog POINT (-73.964274290774 40.7795319556023)   19 4 19 13
2589 2589 -73.9694166642262 40.7697788641081 8I-PM-1013-03 08I PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9694166642262 40.7697788641081)   19 4 19 13
1876 1876 -73.973598991549 40.7783020016983 14A-PM-1014-03 14A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false chasing (#4) false false false false false false true false   POINT (-73.973598991549 40.7783020016983)   19 4 19 13
3013 3013 -73.964661337306 40.7769785494935 17I-AM-1014-03 17I AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon face Above Ground 10   false false true false false climbing (dog barked & it ran up tree) false false false false false false true false   POINT (-73.964661337306 40.7769785494935)   19 4 19 13
1686 1686 -73.9593373093799 40.7982428507976 39A-PM-1014-03 39A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. Above Ground 6 Jumped from ground onto branch false false false false true digging? false false false false true false true false   POINT (-73.95933730937992 40.7982428507976)   19 4 19 13
2480 2480 -73.9546780963388 40.7903216522111 34I-AM-1012-03 34I AM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false false nut in mouth false false false false false false true false   POINT (-73.9546780963388 40.7903216522111)   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 22556.075ms