squirrels

16 rows where Date = 10132018 and Hectare Squirrel Number = 8 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Foraging

Police Precincts

Hectare Squirrel Number

Date

  • 10132018 · 16
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
867 -73.9762257701293 40.7744032758323 9A-AM-1013-08 09A AM 10132018 8 Adult     +         false false false false false   false false false false false false false true   POINT (-73.9762257701293 40.7744032758323)   19 4 19 13
2714 -73.9600738985438 40.7938328798752 35C-PM-1013-08 35C PM 10132018 8       +         false false false false false   true false false false false false false false did not *see* POINT (-73.9600738985438 40.7938328798752)   19 4 19 13
2266 -73.9716402454355 40.7665133780672 3I-PM-1013-08 03I PM 10132018 8 Adult Black   Black+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9716402454355 40.7665133780672)   19 4 19 13
2535 -73.9700101107283 40.7696729501144 7I-PM-1013-08 07I PM 10132018 8 Adult Black   Black+   Above Ground 4   false false true false false   false false false false true false false false   POINT (-73.9700101107283 40.7696729501144)   19 4 19 13
1379 -73.9796470494747 40.7678370925485 1C-PM-1013-08 01C PM 10132018 8 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9796470494747 40.7678370925485)   19 4 19 13
1198 -73.9762187733662 40.7739282973004 9B-PM-1013-08 09B PM 10132018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9762187733662 40.7739282973004)   19 4 19 13
305 -73.9750283794865 40.7724101927821 8C-PM-1013-08 08C PM 10132018 8   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9750283794865 40.7724101927821)   19 4 19 13
2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true true true   false false false false false false false true   POINT (-73.96926766598071 40.7700678919108)   19 4 19 13
955 -73.960657061561 40.7956150744102 36A-PM-1013-08 36A PM 10132018 8   Gray   Gray+   Ground Plane FALSE "FIELD" true false false false false running from #7 false false false false false false false true   POINT (-73.960657061561 40.7956150744102)   19 4 19 13
2437 -73.9619856085821 40.7919516520091 32C-PM-1013-08 32C PM 10132018 8 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9619856085821 40.7919516520091)   19 4 19 13
586 -73.9789126088606 40.7685079149692 2C-PM-1013-08 02C PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false true false false   POINT (-73.9789126088606 40.7685079149692)   19 4 19 13
839 -73.9615602805554 40.7945662185621 35A-PM-1013-08 35A PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9615602805554 40.7945662185621)   19 4 19 13
902 -73.969105907 40.7820474909192 20B-PM-1013-08 20B PM 10132018 8 Adult Gray White Gray+White (very brown) Ground Plane FALSE   true false false false false being chased by dog false false false false false false false true   POINT (-73.969105907 40.7820474909192)   19 4 19 13
924 -73.9591695545875 40.7938116360767 35D-PM-1013-08 35D PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9591695545875 40.7938116360767)   19 4 19 13
1559 -73.9631648674122 40.7926529617419 32A-PM-1013-08 32A PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9631648674122 40.7926529617419)   19 4 19 13
2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9790980124501 40.7685934093915)   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 162.624ms