squirrels

23 rows where Date = 10122018, Foraging = "true" and Primary Fur Color = "Cinnamon"

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail twitches, 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
87 -73.9541453465817 40.7982162223764 42E-PM-1012-06 42E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9541453465817 40.79821622237641)   19 4 19 13
125 -73.9651601541795 40.7761841788025 15I-PM-1012-07 15I PM 10122018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9651601541795 40.7761841788025)   19 4 19 13
165 -73.969058856545 40.7766356226979 14F-PM-1012-06 14F PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.969058856545 40.7766356226979)   19 4 19 13
267 -73.9754742295091 40.7696998327247 5E-PM-1012-02 05E PM 10122018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9754742295091 40.7696998327247)   19 4 19 13
424 -73.9756557086441 40.773296289824 8B-PM-1012-08 08B PM 10122018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9756557086441 40.773296289824)   19 4 19 13
485 -73.9677423154682 40.7728813350245 11I-AM-1012-02 11I AM 10122018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9677423154682 40.77288133502451)   19 4 19 13
490 -73.978426472499 40.771904101844 6A-PM-1012-04 06A PM 10122018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.978426472499 40.771904101844)   19 4 19 13
590 -73.9785133301426 40.7718260288338 6A-PM-1012-05 06A PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9785133301426 40.7718260288338)   19 4 19 13
640 -73.9785536529136 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground false true false false true   false false false false false false true false   POINT (-73.9785536529136 40.771618450500206)   19 4 19 13
684 -73.9691057326088 40.7765973509721 14F-PM-1012-07 14F PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9691057326088 40.7765973509721)   19 4 19 13
931 -73.9785948413883 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false true   false false false false false false false false   POINT (-73.9785948413883 40.7718908026758)   19 4 19 13
1098 -73.9604954276129 40.7965682182001 37A-AM-1012-01 37A AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray Drawing included on tally sheet Ground Plane FALSE   false false false false true scanning (drawing included) false false false false false false false true   POINT (-73.9604954276129 40.7965682182001)   19 4 19 13
1605 -73.9690362384597 40.7767162824413 14F-PM-1012-09 14F PM 10122018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9690362384597 40.7767162824413)   19 4 19 13
1716 -73.9797425262459 40.7679120246352 1B-AM-1012-02 01B AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9797425262459 40.7679120246352)   19 4 19 13
1772 -73.9690540696008 40.7766014124609 14F-PM-1012-08 14F PM 10122018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9690540696008 40.7766014124609)   19 4 19 13
1947 -73.9747175419546 40.7692820030878 5E-PM-1012-05 05E PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false true false false begging POINT (-73.9747175419546 40.7692820030878)   19 4 19 13
2317 -73.9767369686171 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9767369686171 40.7735074437085)   19 4 19 13
2367 -73.9681671864047 40.7753770538635 14G-AM-1012-04 14G AM 10122018 4 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9681671864047 40.7753770538635)   19 4 19 13
2492 -73.9801619956135 40.7678576697542 1B-AM-1012-09 01B AM 10122018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9801619956135 40.7678576697542)   19 4 19 13
2757 -73.9671419119456 40.7758602486862 14G-AM-1012-01 14G AM 10122018 1 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9671419119456 40.7758602486862)   19 4 19 13
2900 -73.9631005470369 40.7885494057193 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9631005470369 40.7885494057193)   19 4 19 13
2986 -73.9756533763813 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9756533763813 40.7733537881363)   19 4 19 13
3023 -73.9754794191553 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9754794191553 40.7696404489025)   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 58.021ms