squirrels

43 rows where Age = "", Foraging = "true" and Police Precincts = 13 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, 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, Approaches, Indifferent, Runs from, Other Interactions

Police Precincts

Foraging

  • true · 43

Age

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
182 -73.9691050656013 40.7808139538222 18C-PM-1018-01 18C PM 10182018 1   Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9691050656013 40.7808139538222)   19 4 19 13
397 -73.9690416961886 40.7716618670996 10H-AM-1014-05 10H AM 10142018 5   Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9690416961886 40.7716618670996)   19 4 19 13
2281 -73.9691520826028 40.7717104037783 10H-AM-1014-06 10H AM 10142018 6   Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9691520826028 40.7717104037783)   19 4 19 13
305 -73.9750283794865 40.7724101927821 8C-PM-1013-08 08C PM 10132018 8   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9750283794865 40.7724101927821)   19 4 19 13
604 -73.9540908513075 40.794201225045 37G-PM-1007-04 37G PM 10072018 4   Cinnamon Gray Cinnamon+Gray gray tail Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9540908513075 40.794201225045)   19 4 19 13
1311 -73.9694169352433 40.7744408293858 12G-PM-1007-03 12G PM 10072018 3   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE bushes false false false false true   false false false false false false false false friendly POINT (-73.9694169352433 40.7744408293858)   19 4 19 13
177 -73.9554432393295 40.7945669054449 37F-PM-1014-01 37F PM 10142018 1   Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9554432393295 40.7945669054449)   19 4 19 13
617 -73.9558809064648 40.7952765022241 38E-PM-1014-03 38E PM 10142018 3   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH false false false false true   false false false false false false true false   POINT (-73.9558809064648 40.7952765022241)   19 4 19 13
959 -73.9746133058077 40.7760646554109 11B-PM-1014-04 11B PM 10142018 4   Gray   Gray+   Ground Plane FALSE   false false false false true jumping false false false false false false false false   POINT (-73.9746133058077 40.776064655410906)   19 4 19 13
1785 -73.9550627447399 40.7910104700332 34H-PM-1006-02 34H PM 10062018 2   Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9550627447399 40.7910104700332)   19 4 19 13
1857 -73.9728797531377 40.7786733148687 15B-PM-1017-01 15B PM 10172018 1   Gray   Gray+   Above Ground 20 in tree false false true false true   false false false false false false true false   POINT (-73.9728797531377 40.7786733148687)   19 4 19 13
1992 -73.9586085843149 40.7946617684536 36C-AM-1014-03 36C AM 10142018 3   Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9586085843149 40.7946617684536)   19 4 19 13
2339 -73.9695117797648 40.7802675743233 18C-PM-1018-07 18C PM 10182018 7   Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9695117797648 40.780267574323304)   19 4 19 13
2707 -73.9743165321099 40.7754674678574 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   true false false true true   false false false false false false false false   POINT (-73.9743165321099 40.7754674678574)   19 4 19 13
8 -73.9602609920814 40.7942883045566 35C-PM-1013-03 35C PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9602609920814 40.79428830455661)   19 4 19 13
32 -73.9576530157255 40.7868659490397 29I-PM-1007-01 29I PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9576530157255 40.7868659490397)   19 4 19 13
252 -73.974420668782 40.7749628597465 10C-PM-1013-04 10C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.974420668782 40.7749628597465)   19 4 19 13
302 -73.9695176417703 40.7741725190048 12G-PM-1007-04 12G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9695176417703 40.7741725190048)   19 4 19 13
324 -73.9587879699956 40.7908135158551 32F-AM-1012-01 32F AM 10122018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true made a back-door escape from dog off-leash false false false false false false false true   POINT (-73.9587879699956 40.7908135158551)   19 4 19 13
398 -73.9686737866872 40.7739714023732 12G-PM-1007-06 12G PM 10072018 6   Gray Cinnamon Gray+Cinnamon         false false false false true   false false false false false false true false   POINT (-73.9686737866872 40.7739714023732)   19 4 19 13
515 -73.9601486483164 40.7943724108626 35C-PM-1013-02 35C PM 10132018 2   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false approaches (when i crouched down) POINT (-73.9601486483164 40.7943724108626)   19 4 19 13
633 -73.9673243699918 40.7875392957722 26A-AM-1014-01 26A AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false could not get close due to fences POINT (-73.9673243699918 40.7875392957722)   19 4 19 13
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
1205 -73.9611118778753 40.7952007875354 36A-PM-1013-01 36A PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true burying false false false false false true false false   POINT (-73.9611118778753 40.7952007875354)   19 4 19 13
1385 -73.9615649773504 40.7954761311501 36A-PM-1013-02 36A PM 10132018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false false false true   false false false false false false true false   POINT (-73.9615649773504 40.7954761311501)   19 4 19 13
1501 -73.9608167300104 40.7954348688268 36A-PM-1013-05 36A PM 10132018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS false false false false true   false false false false false false false true   POINT (-73.9608167300104 40.7954348688268)   19 4 19 13
1622 -73.9615090149261 40.7945150173918 35A-PM-1013-09 35A PM 10132018 9   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9615090149261 40.7945150173918)   19 4 19 13
1738 -73.967975586222 40.7735683044313 12H-PM-1007-07 12H PM 10072018 7   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE grass field false false false false true   false false false false false false false true humans POINT (-73.967975586222 40.7735683044313)   19 4 19 13
2011 -73.9603245806655 40.7942712477697 35C-PM-1013-04 35C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9603245806655 40.7942712477697)   19 4 19 13
2305 -73.9679833225379 40.7738547093402 12H-PM-1007-05 12H PM 10072018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9679833225379 40.7738547093402)   19 4 19 13
2498 -73.9674556940019 40.7875399402461 26A-AM-1014-02 26A AM 10142018 2   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false could not get close due to fences POINT (-73.9674556940019 40.7875399402461)   19 4 19 13
2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false true   true true false true true false true false   POINT (-73.9601988871514 40.7943473161329)   19 4 19 13
2995 -73.9668442742942 40.7870781042595 25B-PM-1007-01 25B PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9668442742942 40.7870781042595)   19 4 19 13
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
2163 -73.9643664403785 40.7793670703727 19H-AM-1010-01 19H AM 10102018 1   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false false false false true false run from human w/ dog POINT (-73.9643664403785 40.7793670703727)   19 4 19 13
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
29 -73.9671786715256 40.7867352791232 25A-AM-1013-04 25A AM 10132018 4   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9671786715256 40.7867352791232)   19 4 19 13
537 -73.9682803241007 40.7724510558327 11H-AM-1010-04 11H AM 10102018 4   Gray White Gray+White         false false false false true   false false false false true false false false   POINT (-73.9682803241007 40.7724510558327)   19 4 19 13
891 -73.9613351649026 40.7909866851357 31D-AM-1014-03 31D AM 10142018 3   Gray White Gray+White   Ground Plane FALSE Undergrowth false false false false true   false false false false false false false true   POINT (-73.9613351649026 40.7909866851357)   19 4 19 13
2191 -73.9734108731087 40.7676051392697 4G-AM-1006-03 04G AM 10062018 3   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9734108731087 40.7676051392697)   19 4 19 13
2582 -73.9665004148497 40.7805656411756 19E-PM-1018-05 19E PM 10182018 5   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9665004148497 40.7805656411756)   19 4 19 13
2860 -73.9565179671319 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.95651796713192 40.7936663940365)   19 4 19 13
3009 -73.9675637870968 40.7823880671728 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9675637870968 40.7823880671728)   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 79.502ms