squirrels

15 rows where Date = 10062018 and Hectare Squirrel Number = 8 sorted by Longitude

View and edit SQL

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

Police Precincts

Hectare Squirrel Number

Date

  • 10062018 · 15
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
1820 -73.9546337446865 40.7898772579576 33I-PM-1006-08 33I PM 10062018 8 Adult Gray   Gray+   Above Ground 6   false false true false false   false false false false true false true false   POINT (-73.9546337446865 40.7898772579576)   19 4 19 13
564 -73.9570086212285 40.7946679755816 37E-PM-1006-08 37E PM 10062018 8 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.95700862122851 40.7946679755816)   19 4 19 13
717 -73.9574749571848 40.7981898890735 40C-PM-1006-08 40C PM 10062018 8 Adult Gray   Gray+   Ground Plane FALSE By the main road true false false false false   false false false false false false false true   POINT (-73.9574749571848 40.7981898890735)   19 4 19 13
1757 -73.9601561064548 40.7900513933531 31E-PM-1006-08 31E PM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9601561064548 40.7900513933531)   19 4 19 13
2723 -73.960642602756 40.7917265419842 32D-PM-1006-08 32D PM 10062018 8 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true false false false stand on two feet and watching me POINT (-73.960642602756 40.7917265419842)   19 4 19 13
1378 -73.9669762657479 40.7835913293646 22C-PM-1006-08 22C PM 10062018 8 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9669762657479 40.7835913293646)   19 4 19 13
476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree false false false false false   true true false false false false false false not backing down POINT (-73.9690968160819 40.769923269444)   19 4 19 13
1106 -73.9702970919317 40.7696883113413 7H-PM-1006-08 07H PM 10062018 8 Adult Gray White Gray+White   Ground Plane FALSE in grass false false false false true   false false false false true true false true   POINT (-73.9702970919317 40.7696883113413)   19 4 19 13
1285 -73.9705115189429 40.7698395577068 7H-AM-1006-08 07H AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9705115189429 40.7698395577068)   19 4 19 13
2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   false false false true false   false false false true true false true false   POINT (-73.9706949930717 40.772362045852)   19 4 19 13
2289 -73.9745800592393 40.767356541975 3F-AM-1006-08 03F AM 10062018 8 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE close to tall tree & light post true false false false true   false false false false false false true false   POINT (-73.9745800592393 40.767356541975)   19 4 19 13
2233 -73.9754709117681 40.7681421869407 3E-AM-1006-08 03E AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false false true false   false false false false false true false false   POINT (-73.9754709117681 40.7681421869407)   19 4 19 13
214 -73.9772576561244 40.7679895093963 3D-AM-1006-08 03D AM 10062018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false true false false approaches (food stand) POINT (-73.9772576561244 40.7679895093963)   19 4 19 13
2223 -73.9784863123685 40.7669225020831 1D-AM-1006-08 01D AM 10062018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45   false false true false false   false false false false false false false false   POINT (-73.9784863123685 40.7669225020831)   19 4 19 13
895 -73.9786898656279 40.7720833097065 6A-AM-1006-08 06A AM 10062018 8 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false true false true false   POINT (-73.9786898656279 40.77208330970651)   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 68.497ms