squirrels

19 rows where Approaches = "true", Highlight Fur Color = "Cinnamon, White", Indifferent = "false" and Runs from = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, 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
162 162 -73.957219204335 40.7931529059779 35E-PM-1006-01 35E PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false looking/begging for food POINT (-73.957219204335 40.7931529059779)   19 4 19 13
230 230 -73.9731498064872 40.7659963196581 2H-AM-1006-02 02H AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true true false false   false false false false false true false false   POINT (-73.9731498064872 40.7659963196581)   19 4 19 13
246 246 -73.9779805668091 40.7680931566797 2D-PM-1012-02 02D PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9779805668091 40.7680931566797)   19 4 19 13
362 362 -73.9571407991577 40.7931917396406 35E-PM-1006-02 35E PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false begging for food POINT (-73.9571407991577 40.7931917396406)   19 4 19 13
482 482 -73.9721797824576 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true false false approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)   19 4 19 13
669 669 -73.9802079259866 40.7678723471007 1B-AM-1012-10 01B AM 10122018 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9802079259866 40.7678723471007)   19 4 19 13
843 843 -73.9714089647431 40.7767916587915 14D-AM-1014-12 14D AM 10142018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9714089647431 40.7767916587915)   19 4 19 13
1036 1036 -73.9709207551033 40.7767932008037 14D-AM-1014-04 14D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9709207551033 40.7767932008037)   19 4 19 13
1295 1295 -73.9709534894049 40.7765964740768 14D-AM-1014-15 14D AM 10142018 15 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9709534894049 40.7765964740768)   19 4 19 13
1330 1330 -73.9643032554205 40.7794514526463 19H-AM-1010-02 19H AM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false true false true false false ran from human with dog POINT (-73.9643032554205 40.7794514526463)   19 4 19 13
2019 2019 -73.9566705412766 40.7935560645735 36F-PM-1012-01 36F PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Near rock false false false false true   false false false false false true false false   POINT (-73.9566705412766 40.7935560645735)   19 4 19 13
2068 2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false false wandering,interacting with tourists false false false false false true false false approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)   19 4 19 13
2332 2332 -73.9709797467807 40.7769095710679 14D-AM-1014-07 14D AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9709797467807 40.7769095710679)   19 4 19 13
2333 2333 -73.9771924901559 40.7666722729471 1E-PM-1007-01 01E PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false people feeding squirrel POINT (-73.9771924901559 40.7666722729471)   19 4 19 13
2428 2428 -73.9755643404768 40.7697569149388 5E-PM-1012-03 05E PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9755643404768 40.7697569149388)   19 4 19 13
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass false false false true true   false false false false true true false false   POINT (-73.9713379914423 40.7696367609606)   19 4 19 13
2856 2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path false false false false true   false false false false false true false false   POINT (-73.9751615527833 40.767013871509)   19 4 19 13
2922 2922 -73.9703421391442 40.7773706575356 14D-AM-1014-01 14D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9703421391442 40.7773706575356)   19 4 19 13
2931 2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9730926233232 40.7781330751738)   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 86.973ms