squirrels

14 rows where Combination of Primary and Highlight Color = "Black+" and Eating = "true" sorted by City Council Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions

Runs from ✖

Eating ✖

  • true · 14 ✖

Combination of Primary and Highlight Color ✖

  • Black+ · 14 ✖
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
42 42 -73.9579564338627 40.7959337795027 38C-PM-1014-09 38C PM 10142018 9 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9579564338627 40.7959337795027)   19 4 19 13
130 130 -73.9581655949437 40.7997708190022 41A-PM-1007-06 41A PM 10072018 6 Adult Black   Black+   Ground Plane FALSE   true false true true false   false false false false false false false true   POINT (-73.9581655949437 40.7997708190022)   19 4 19 13
325 325 -73.9630990823243 40.7885764284016 28D-AM-1012-02 28D AM 10122018 2 Adult Black   Black+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9630990823243 40.7885764284016)   19 4 19 13
381 381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   true false false true false   false false false false true false false true ran up tree POINT (-73.959709414696 40.7919745085986)   19 4 19 13
658 658 -73.9704575848926 40.7693499326095 7H-PM-1006-09 07H PM 10062018 9 Adult Black   Black+   Ground Plane FALSE by tree false false false true true   false false false true false true false true   POINT (-73.9704575848926 40.7693499326095)   19 4 19 13
731 731 -73.9733545802515 40.7675056025357 4G-AM-1006-04 04G AM 10062018 4 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9733545802515 40.7675056025357)   19 4 19 13
1066 1066 -73.9720174997123 40.7748894266027 11D-AM-1010-07 11D AM 10102018 7 Adult Black   Black+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9720174997123 40.7748894266027)   19 4 19 13
1232 1232 -73.9589254878322 40.7914467650712 33E-PM-1012-09 33E PM 10122018 9 Adult Black   Black+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9589254878322 40.7914467650712)   19 4 19 13
1261 1261 -73.9719109949232 40.7723138521327 9F-AM-1013-01 09F AM 10132018 1 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9719109949232 40.7723138521327)   19 4 19 13
1307 1307 -73.9565197137317 40.7986011403785 41C-PM-1007-01 41C PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9565197137317 40.7986011403785)   19 4 19 13
1528 1528 -73.9690104245067 40.7853358193723 23A-AM-1018-02 23A AM 10182018 2 Juvenile Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690104245067 40.7853358193723)   19 4 19 13
2120 2120 -73.9733905460282 40.7656337147768 2H-PM-1006-03 02H PM 10062018 3 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9733905460282 40.7656337147768)   19 4 19 13
2270 2270 -73.9703732649257 40.7701979377103 8H-PM-1014-04 08H PM 10142018 4 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.97037326492571 40.7701979377103)   19 4 19 13
2549 2549 -73.972248505758 40.7659043693008 3I-PM-1013-01 03I PM 10132018 1 Adult Black   Black+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.972248505758 40.765904369300806)   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 180.901ms