squirrels

15 rows where Above Ground Sighter Measurement = 12 and Kuks = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

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
96 96 -73.9708549670788 40.7699587019058 7H-PM-1006-04 07H PM 10062018 4 Adult Gray   Gray+   Above Ground 12 on tree knob false false false false false sitting false false false false false false true false   POINT (-73.9708549670788 40.7699587019058)   19 4 19 13
189 189 -73.9735489537928 40.7681257911523 4G-AM-1006-02 04G AM 10062018 2   Gray White Gray+White   Above Ground 12 tree false false false false false sitting in tree false false false false false false true false   POINT (-73.9735489537928 40.7681257911523)   19 4 19 13
352 352 -73.970540988328 40.7698103067062 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false true false false false   false false false false false false true false   POINT (-73.970540988328 40.7698103067062)   19 4 19 13
399 399 -73.9763433202401 40.7738473490681 9B-PM-1013-10 09B PM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray "Brown" written in as Primary Above Ground 12   false false false true false   false false false false false false true false   POINT (-73.9763433202401 40.7738473490681)   19 4 19 13
856 856 -73.9591667162801 40.7937602121568 35D-PM-1013-07 35D PM 10132018 7 Juvenile Gray White Gray+White   Above Ground 12 tree false false true false false   false false false false true false true false   POINT (-73.95916671628011 40.7937602121568)   19 4 19 13
1095 1095 -73.9735547926323 40.7723420076108 8D-AM-1007-02 08D AM 10072018 2 Adult Gray   Gray+   Above Ground 12   false false true false false   false false false false false false true false   POINT (-73.9735547926323 40.7723420076108)   19 4 19 13
1225 1225 -73.9584803513939 40.7933802077327 35D-PM-1013-01 35D PM 10132018 1 Adult Gray White Gray+White   Above Ground 12   false false true false false   false false false false false false true false   POINT (-73.9584803513939 40.7933802077327)   19 4 19 13
2114 2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   false false false false false watching false false false false false true false false   POINT (-73.9651541395415 40.7798283208748)   19 4 19 13
2190 2190 -73.9657040391563 40.7755567428199 15I-AM-1008-06 15I AM 10082018 6 Adult Cinnamon White Cinnamon+White   Above Ground 12   false false false true false   false false false false false false true false   POINT (-73.9657040391563 40.7755567428199)   19 4 19 13
2222 2222 -73.9639048209454 40.7777373345558 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639048209454 40.7777373345558)   19 4 19 13
2521 2521 -73.976869549792 40.7706982454723 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree false false false false false relaxing false false false true false false true false   POINT (-73.976869549792 40.7706982454723)   19 4 19 13
2640 2640 -73.9788304714091 40.7696373635315 4B-AM-1010-06 04B AM 10102018 6 Adult Gray   Gray+   Above Ground 12   true false false false false running from squirrel #5 false false false false false false false false   POINT (-73.9788304714091 40.7696373635315)   19 4 19 13
2659 2659 -73.9553603438021 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   false false false true false   false false false false false false false false   POINT (-73.9553603438021 40.7985282963244)   19 4 19 13
2783 2783 -73.9791767156268 40.7714445258765 5A-AM-1006-02 05A AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 12 in tall shrubs near wall next to CPW false false true true false   false false false false false false true false   POINT (-73.9791767156268 40.7714445258765)   19 4 19 13
2811 2811 -73.9756889766089 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   true false true false false running from dog false false false false false false false true   POINT (-73.9756889766089 40.7676078308589)   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 97.72ms