squirrels

19 rows where Hectare = "16D"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Indifferent, Runs from, Other Interactions

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
211 211 -73.9702755805141 40.7783547795222 16D-PM-1010-13 16D PM 10102018 13 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9702755805141 40.7783547795222)   19 4 19 13
429 429 -73.9694784056618 40.7787735291442 16D-PM-1010-01 16D PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9694784056618 40.7787735291442)   19 4 19 13
530 530 -73.9696360756453 40.7786545659072 16D-PM-1010-03 16D PM 10102018 3 Adult Gray   Gray+   Above Ground 18   false false true true false   false false false false false false true false   POINT (-73.9696360756453 40.7786545659072)   19 4 19 13
563 563 -73.9700330712119 40.7782913925727 16D-PM-1010-06 16D PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   true false false false true walking false false false false false false false false checking me out POINT (-73.9700330712119 40.7782913925727)   19 4 19 13
585 585 -73.9700148248402 40.7787780193358 16D-PM-1010-04 16D PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9700148248402 40.7787780193358)   19 4 19 13
609 609 -73.9698762023146 40.7782055688113 16D-PM-1010-09 16D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   true false false false false false true false   POINT (-73.9698762023146 40.77820556881131)   19 4 19 13
694 694 -73.9698032734704 40.7782343912417 16D-AM-1007-02 16D AM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9698032734704 40.7782343912417)   19 4 19 13
996 996 -73.9703149829421 40.7785583630323 16D-AM-1007-01 16D AM 10072018 1 Adult Gray White Gray+White   Above Ground 3   false false true true false   false false false false false false false true   POINT (-73.9703149829421 40.7785583630323)   19 4 19 13
1084 1084 -73.9698839750249 40.7781433076692 16D-PM-1010-08 16D PM 10102018 8 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   true false false false false false true false   POINT (-73.9698839750249 40.7781433076692)   19 4 19 13
1550 1550 -73.9698642668906 40.7784669316504 16D-PM-1010-10 16D PM 10102018 10 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9698642668906 40.7784669316504)   19 4 19 13
1902 1902 -73.9703314162405 40.778584776139 16D-PM-1010-12 16D PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9703314162405 40.778584776139)   19 4 19 13
1903 1903 -73.9701379806066 40.7785234812393 16D-PM-1010-11 16D PM 10102018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9701379806066 40.7785234812393)   19 4 19 13
1934 1934 -73.969756965598 40.7786455091699 16D-PM-1010-02 16D PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.969756965598 40.7786455091699)   19 4 19 13
2034 2034 -73.9699135187297 40.7782354186163 16D-AM-1007-03 16D AM 10072018 3 Adult     + ran away before I could take a good look Above Ground 2   false false true false false   false false false false false false false true   POINT (-73.9699135187297 40.7782354186163)   19 4 19 13
2209 2209 -73.9697583235533 40.7787320391004 16D-AM-1007-05 16D AM 10072018 5 Adult Gray   Gray+ didn't get a good look Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.96975832355331 40.7787320391004)   19 4 19 13
2240 2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9697787673802 40.7781746195436)   19 4 19 13
2634 2634 -73.9695685186489 40.7788293026327 16D-AM-1007-04 16D AM 10072018 4 Adult Gray   Gray+   Above Ground 8   false false true false false   false false false true false false false true   POINT (-73.9695685186489 40.7788293026327)   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
2780 2780 -73.9700634278 40.7784223722453 16D-PM-1010-07 16D PM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9700634278 40.7784223722453)   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 56.623ms