squirrels

15 rows where Date = 10072018, Highlight Fur Color = "Cinnamon" and Tail twitches = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Color notes, Location, Above Ground Sighter Measurement, Climbing, Eating, Foraging, Other Activities, Approaches, 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
65 65 -73.9741824992294 40.7689486657963 5F-PM-1007-03 05F PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false hiding nut false false false false true false true false   POINT (-73.9741824992294 40.7689486657963)   19 4 19 13
136 136 -73.9528682507794 40.7925807808307 36I-PM-1007-13 36I PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.9528682507794 40.7925807808307)   19 4 19 13
161 161 -73.9649632550828 40.7809187761995 20F-PM-1007-01 20F PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9649632550828 40.7809187761995)   19 4 19 13
304 304 -73.9523001834395 40.7949231000186 39H-AM-1007-02 39H AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9523001834395 40.7949231000186)   19 4 19 13
733 733 -73.9764397550289 40.7737004557104 8B-AM-1007-01 08B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false false false false true false true false   POINT (-73.9764397550289 40.7737004557104)   19 4 19 13
1169 1169 -73.9570391901515 40.7930697207834 35F-AM-1007-01 35F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9570391901515 40.7930697207834)   19 4 19 13
1668 1668 -73.9746934810667 40.7659431884158 2G-PM-1007-02 02G PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false burying nut false false false false true false true false   POINT (-73.9746934810667 40.7659431884158)   19 4 19 13
1948 1948 -73.9738410069766 40.7691686156505 5F-PM-1007-06 05F PM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false jumping on fence false false false false true false true false   POINT (-73.9738410069766 40.7691686156505)   19 4 19 13
2037 2037 -73.9683370417551 40.78135983505 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false true false true   false false false false true false false false fenced area POINT (-73.9683370417551 40.78135983505)   19 4 19 13
2133 2133 -73.9736164871197 40.7725695048569 8D-PM-1007-04 08D PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9736164871197 40.7725695048569)   19 4 19 13
2321 2321 -73.9743060404813 40.7687901781431 5F-PM-1007-02 05F PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9743060404813 40.7687901781431)   19 4 19 13
2382 2382 -73.9743970455533 40.7687880243986 5F-PM-1007-01 05F PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9743970455533 40.7687880243986)   19 4 19 13
2472 2472 -73.9596820155238 40.7932886803231 34D-PM-1007-03 34D PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9596820155238 40.7932886803231)   19 4 19 13
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true true chirps false false false false true false true false   POINT (-73.9552595564798 40.7889533029466)   19 4 19 13
2961 2961 -73.9736238258579 40.7688712771191 5F-PM-1007-04 05F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9736238258579 40.7688712771191)   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 53.31ms