squirrels

31 rows where Date = 10082018, Highlight Fur Color = "Cinnamon" and Location = "Ground Plane"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Color notes, Specific Location, Running, Eating, Foraging, Other Activities, Tail flags, 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
54 54 -73.9760298241178 40.7681954366911 3E-PM-1008-07 03E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9760298241178 40.7681954366911)   19 4 19 13
219 219 -73.9761209945419 40.7682404528903 3E-PM-1008-03 03E PM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9761209945419 40.7682404528903)   19 4 19 13
250 250 -73.9726747666002 40.7703022669308 7F-AM-1008-02 07F AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true see stories and locations POINT (-73.9726747666002 40.7703022669308)   19 4 19 13
716 716 -73.9745427984089 40.7691848214817 5E-AM-1008-03 05E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9745427984089 40.7691848214817)   19 4 19 13
718 718 -73.9661694463488 40.7757530583569 15H-PM-1008-07 15H PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE along bottom of rock outcropping false false false true true   false false false false false false true false   POINT (-73.9661694463488 40.7757530583569)   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
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
1089 1089 -73.9655955841325 40.7762063860571 15H-PM-1008-04 15H PM 10082018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of landscape false false false false true   false false false false false false true false   POINT (-73.9655955841325 40.7762063860571)   19 4 19 13
1094 1094 -73.9773898301093 40.7708581562057 5B-AM-1008-01 05B AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running across ball field 5,near home plate false false false false false false true false   POINT (-73.9773898301093 40.7708581562057)   19 4 19 13
1237 1237 -73.9705370795538 40.7761725434851 13E-PM-1008-04 13E PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true false false false he took 2 steps then turned and stared at me POINT (-73.9705370795538 40.7761725434851)   19 4 19 13
1257 1257 -73.9767247593654 40.7726200054197 7B-AM-1008-15 07B AM 10082018 15 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9767247593654 40.7726200054197)   19 4 19 13
1364 1364 -73.9726090882487 40.7710199108849 7F-AM-1008-14 07F AM 10082018 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false sitting false false false false false false true false   POINT (-73.9726090882487 40.7710199108849)   19 4 19 13
1376 1376 -73.9773361580792 40.7729478226715 7B-AM-1008-13 07B AM 10082018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9773361580792 40.7729478226715)   19 4 19 13
1401 1401 -73.9681202146851 40.7743979416812 13G-PM-1008-04 13G PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE lawn @ edge of landscaped area false false false false true   false false false false false false true false   POINT (-73.9681202146851 40.7743979416812)   19 4 19 13
1419 1419 -73.9756017589251 40.7680335996527 3E-PM-1008-06 03E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9756017589251 40.7680335996527)   19 4 19 13
1472 1472 -73.9698611971209 40.7753915552001 13F-PM-1008-02 13F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9698611971209 40.7753915552001)   19 4 19 13
1521 1521 -73.9723922904119 40.7729164833027 9E-AM-1008-01 09E AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9723922904119 40.7729164833027)   19 4 19 13
1664 1664 -73.9729142912203 40.7724091146678 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9729142912203 40.7724091146678)   19 4 19 13
1687 1687 -73.9754790964561 40.768336388516 4E-PM-1008-07 04E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9754790964561 40.768336388516)   19 4 19 13
1975 1975 -73.9753291616796 40.7687376032936 4E-PM-1008-01 04E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false true false   POINT (-73.9753291616796 40.7687376032936)   19 4 19 13
1990 1990 -73.9774584305147 40.7708133986192 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9774584305147 40.7708133986192)   19 4 19 13
2058 2058 -73.9669017345324 40.7766928987073 15G-AM-1008-01 15G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9669017345324 40.7766928987073)   19 4 19 13
2146 2146 -73.9547398684817 40.7896483795302 33I-AM-1008-01 33I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park @ 98th (north) false false false false true   false false false false false false true false   POINT (-73.9547398684817 40.7896483795302)   19 4 19 13
2264 2264 -73.9773520582734 40.7708198505781 5B-AM-1008-04 05B AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.9773520582734 40.7708198505781)   19 4 19 13
2271 2271 -73.9673949458096 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9673949458096 40.78262185394961)   19 4 19 13
2429 2429 -73.9726699686943 40.7701123791223 7F-AM-1008-01 07F AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bench false false false false true   false false false true false false true false   POINT (-73.9726699686943 40.7701123791223)   19 4 19 13
2431 2431 -73.9630054996358 40.7905225147022 30C-PM-1008-01 30C PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9630054996358 40.7905225147022)   19 4 19 13
2489 2489 -73.9663168490265 40.7825083721362 21D-AM-1008-01 21D AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false true true false true false   POINT (-73.9663168490265 40.7825083721362)   19 4 19 13
2675 2675 -73.9762227323096 40.768453603768 3E-PM-1008-02 03E PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9762227323096 40.768453603768)   19 4 19 13
2871 2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9777124331985 40.7704051056666)   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

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 60.602ms