squirrels

15 rows where Above Ground Sighter Measurement = 20 and Eating = "true"

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Kuks, Tail twitches, Approaches, Indifferent, Runs from

Foraging

Climbing

Eating

  • true · 15

Above Ground Sighter Measurement

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
1123 -73.9670858934045 40.7753505024976 14H-PM-1012-02 14H PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   true false false true true   false false false false false false true false   POINT (-73.9670858934045 40.7753505024976)   19 4 19 13
1381 -73.9586077039567 40.7961896477077 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1410 -73.9587913289229 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
1504 -73.9706586108006 40.7796357444471 17C-PM-1013-02 17C PM 10132018 2 Adult Gray   Gray+   Above Ground 20 in a tree false false false true false   false false false false false false true false   POINT (-73.9706586108006 40.7796357444471)   19 4 19 13
1560 -73.9587072763996 40.7850256219415 27I-AM-1007-01 27I AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   false false true true false   false false false false false false false true   POINT (-73.9587072763996 40.7850256219415)   19 4 19 13
1574 -73.9561840935803 40.7992037821497 42C-PM-1013-05 42C PM 10132018 5 Adult Gray   Gray+   Above Ground 20   false false false true false   true false false false false false true false   POINT (-73.9561840935803 40.7992037821497)   19 4 19 13
2010 -73.9673821557469 40.7786375267659 17F-PM-1020-06 17F PM 10202018 6 Adult Gray   Gray+   Above Ground 20   false false false true false   false false false false false false false false   POINT (-73.96738215574692 40.7786375267659)   19 4 19 13
2128 -73.9757673193743 40.7669614322613 2F-PM-1014-04 02F PM 10142018 4 Adult Gray   Gray+   Above Ground 20   false false false true false   false false false false false false true false   POINT (-73.9757673193743 40.766961432261304)   19 4 19 13
2195 -73.955352152771 40.7988549523022 42D-AM-1014-01 42D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   false false true true false   true false false false false false true false   POINT (-73.955352152771 40.7988549523022)   19 4 19 13
2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   false false true true false   false false false false false true false false   POINT (-73.9577297187155 40.799225295679)   19 4 19 13
2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true true false   false false false false false true false false   POINT (-73.9772239251936 40.7731716665766)   19 4 19 13
2683 -73.972179947936 40.7810042827198 17A-PM-1013-02 17A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 on a little pedestal-shaped part of a tree false false false true false   false false false false true false true false   POINT (-73.972179947936 40.7810042827198)   19 4 19 13
2730 -73.9653575758687 40.7805339953372 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree false false true true false   false false false false false false false false   POINT (-73.9653575758687 40.7805339953372)   19 4 19 13
2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true true true   false false false false false false true false   POINT (-73.9772908667333 40.7697207404744)   19 4 19 13
2903 -73.9670432105975 40.7753462013506 14H-PM-1012-03 14H PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   true false false true true   false false false false false false true false   POINT (-73.9670432105975 40.7753462013506)   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 99.932ms