squirrels

26 rows where Date = 10082018 and Hectare Squirrel Number = 5 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Indifferent, Runs from, Other Interactions

Foraging ✖

Police Precincts ✖

Hectare Squirrel Number ✖

Date ✖

  • 10082018 · 26 ✖
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
647 647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   false false true false false   false false false false true false false false   POINT (-73.9734762649298 40.7663703404546)   19 4 19 13
276 276 -73.9758579666874 40.7679326548845 3E-PM-1008-05 03E PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false jump false false false false false false true false   POINT (-73.9758579666874 40.7679326548845)   19 4 19 13
863 863 -73.9764016030666 40.7689894344251 4D-PM-1008-05 04D PM 10082018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9764016030666 40.7689894344251)   19 4 19 13
1711 1711 -73.975836799137 40.7691593428471 4E-PM-1008-05 04E PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.975836799137 40.769159342847104)   19 4 19 13
1923 1923 -73.9743795190073 40.7692030411004 5E-AM-1008-05 05E AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false false false true   false false false false false false true false   POINT (-73.9743795190073 40.7692030411004)   19 4 19 13
247 247 -73.9733117663541 40.7694584620114 6F-PM-1008-05 06F PM 10082018 5 Adult Cinnamon White Cinnamon+White white patch Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97331176635412 40.7694584620114)   19 4 19 13
2552 2552 -73.9724947710698 40.7696619340886 6G-AM-1008-05 06G AM 10082018 5 Adult Gray   Gray+   Above Ground 30 branch false false true false false sitting false false false false false false true false   POINT (-73.9724947710698 40.7696619340886)   19 4 19 13
1288 1288 -73.9730454295997 40.7702909454392 7F-AM-1008-05 07F AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE bush false true false false false   false false false false false false true false   POINT (-73.9730454295997 40.7702909454392)   19 4 19 13
436 436 -73.9734695768004 40.7716297491384 8E-PM-1008-05 08E PM 10082018 5 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false false false true true   false false false false false false false false   POINT (-73.9734695768004 40.7716297491384)   19 4 19 13
2917 2917 -73.9770313887741 40.7724869252099 7B-AM-1008-05 07B AM 10082018 5 Adult Gray   Gray+   Above Ground     false true false false false   false false false false false false true false   POINT (-73.9770313887741 40.772486925209904)   19 4 19 13
792 792 -73.9730115687964 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   false false true true false   false false false false false false false false   POINT (-73.9730115687964 40.7741018274312)   19 4 19 13
2515 2515 -73.9693338657183 40.7757055884538 13F-PM-1008-05 13F PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 tree trunk true false false true true   true false false false true false false false   POINT (-73.9693338657183 40.77570558845381)   19 4 19 13
696 696 -73.9656098194149 40.7757643078973 15I-AM-1008-05 15I AM 10082018 5 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false true   POINT (-73.9656098194149 40.7757643078973)   19 4 19 13
1839 1839 -73.9655925527354 40.7760049171097 15H-PM-1008-05 15H PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE lawn false false false false true   false false false false false false true false   POINT (-73.9655925527354 40.7760049171097)   19 4 19 13
689 689 -73.970595381455 40.7762912142457 13E-PM-1008-05 13E PM 10082018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.970595381455 40.7762912142457)   19 4 19 13
810 810 -73.967418114684 40.7764595360054 15G-AM-1008-05 15G AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.967418114684 40.7764595360054)   19 4 19 13
139 139 -73.969847380865 40.7769884612305 14E-AM-1008-05 14E AM 10082018 5 Adult Gray   Gray+   Above Ground 25   false false true false false nest building false false false false false false true false   POINT (-73.969847380865 40.7769884612305)   19 4 19 13
306 306 -73.9689700100267 40.7775169562765 15E-PM-1008-05 15E PM 10082018 5 Adult Gray   Gray+   Above Ground 20   false false false false false sitting false true false false false false false false   POINT (-73.9689700100267 40.7775169562765)   19 4 19 13
1940 1940 -73.9696445614055 40.7791486203627 17D-AM-1008-05 17D AM 10082018 5 Juvenile Gray   Gray+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9696445614055 40.7791486203627)   19 4 19 13
909 909 -73.9665705456197 40.7823552871044 21D-PM-1008-05 21D PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9665705456197 40.7823552871044)   19 4 19 13
2925 2925 -73.9672152696834 40.7823874581829 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9672152696834 40.7823874581829)   19 4 19 13
80 80 -73.9688454483585 40.7845301288163 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can false false false true false   false false false true false false false true   POINT (-73.9688454483585 40.7845301288163)   19 4 19 13
1592 1592 -73.9575517912392 40.7889158268192 31H-PM-1008-05 31H PM 10082018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground     false false true false false   false false false false false false false true   POINT (-73.9575517912392 40.7889158268192)   19 4 19 13
1483 1483 -73.9545773579075 40.7898684635744 33I-AM-1008-05 33I AM 10082018 5 Adult     +   Above Ground 100   false false true false true   false false false false false false true false nearly dropped shell on my head! POINT (-73.9545773579075 40.7898684635744)   19 4 19 13
672 672 -73.9588708103486 40.7905794078843 32F-PM-1008-05 32F PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9588708103486 40.7905794078843)   19 4 19 13
1883 1883 -73.9568108465086 40.7971727026108 39D-AM-1008-05 39D AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.95681084650862 40.7971727026108)   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 113.265ms