squirrels

66 rows where Foraging = "true", Police Precincts = 13 and Tail flags = "true" sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: 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, Other Activities, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Tail flags

  • true · 66

Police Precincts

Foraging

  • true · 66
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
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
770 -73.9597782762029 40.7920773376757 33D-AM-1017-07 33D AM 10172018 7 Adult Black   Black+   Ground Plane FALSE   false false false false true   false true false true false false true false   POINT (-73.9597782762029 40.7920773376757)   19 4 19 13
1959 -73.9707737073771 40.7800373465838 17B-PM-1012-02 17B PM 10122018 2 Adult Black   Black+   Ground Plane FALSE   true true false false true 2/3 chasing each other true true false true true false true false   POINT (-73.9707737073771 40.7800373465838)   19 4 19 13
2505 -73.9762974698771 40.7740076116964 9B-PM-1013-06 09B PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9762974698771 40.7740076116964)   19 4 19 13
1198 -73.9762187733662 40.7739282973004 9B-PM-1013-08 09B PM 10132018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9762187733662 40.7739282973004)   19 4 19 13
261 -73.9552861155228 40.788973931872 32I-AM-1013-05 32I AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552861155228 40.788973931872)   19 4 19 13
384 -73.968045072743 40.7836626717225 22C-AM-1013-02 22C AM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   false false true false true   true false false true false false false true   POINT (-73.968045072743 40.7836626717225)   19 4 19 13
1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552035011902 40.7889851896334)   19 4 19 13
1808 -73.9698870647042 40.7826510985538 20B-AM-1007-02 20B AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true true true false false   POINT (-73.9698870647042 40.7826510985538)   19 4 19 13
1982 -73.9729979174723 40.7742904356698 10D-PM-1008-01 10D PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9729979174723 40.7742904356698)   19 4 19 13
2583 -73.9769693140651 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree true false true true true digging (?) false false false true false false false true runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)   19 4 19 13
2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9746063250438 40.7687654196811)   19 4 19 13
194 -73.9764839973068 40.7691725326976 4D-PM-1008-06 04D PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9764839973068 40.7691725326976)   19 4 19 13
2547 -73.9743393747021 40.7676346798325 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9743393747021 40.7676346798325)   19 4 19 13
192 -73.9651654887991 40.7777806006951 17H-PM-1007-02 17H PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9651654887991 40.7777806006951)   19 4 19 13
203 -73.9638774579549 40.7913532129148 31A-AM-1010-05 31A AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true jumping false false false true true false true false eventually ran from lawnmower (tail flag) POINT (-73.9638774579549 40.7913532129148)   19 4 19 13
427 -73.9589367709165 40.7896465303483 31F-PM-1007-04 31F PM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9589367709165 40.7896465303483)   19 4 19 13
507 -73.9744835563086 40.7729521433235 9D-AM-1008-01 09D AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9744835563086 40.7729521433235)   19 4 19 13
663 -73.9766440589836 40.7682390282581 3E-AM-1006-02 03E AM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9766440589836 40.7682390282581)   19 4 19 13
730 -73.9607280801601 40.7901506706248 31D-PM-1006-01 31D PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false false false true   POINT (-73.9607280801601 40.7901506706248)   19 4 19 13
1058 -73.9737100743183 40.7708360121735 7E-PM-1013-03 07E PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Ground & Tree Base false false false false true   false false false true true false true false   POINT (-73.9737100743183 40.7708360121735)   19 4 19 13
1795 -73.968004352343 40.7726669278308 11I-PM-1012-01 11I PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false true true false false false look at humans determining POINT (-73.968004352343 40.7726669278308)   19 4 19 13
1818 -73.956863563379 40.7986418851147 41C-AM-1017-01 41C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.95686356337902 40.7986418851147)   19 4 19 13
1944 -73.9743292066413 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false true false false   POINT (-73.9743292066413 40.7756090404121)   19 4 19 13
2966 -73.9630596103391 40.7925720620556 32A-AM-1018-04 32A AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE Base of tree false false false false true   false false false true false false true false   POINT (-73.9630596103391 40.7925720620556)   19 4 19 13
706 -73.9570132570934 40.7932014159087 35F-PM-1012-01 35F PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false true true   false false false true false false true true   POINT (-73.9570132570934 40.7932014159087)   19 4 19 13
1967 -73.9647247254127 40.7806136565784 20G-PM-1013-03 20G PM 10132018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true true   false false false true false false false true   POINT (-73.9647247254127 40.7806136565784)   19 4 19 13
2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false true   true false false true true false false true   POINT (-73.95832017896151 40.7913938722521)   19 4 19 13
90 -73.9787180870736 40.7715877863274 5A-AM-1006-05 05A AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near 65th St arch false false false false true   false false false true false false false true   POINT (-73.9787180870736 40.7715877863274)   19 4 19 13
124 -73.9588660250232 40.7982597947515 40A-AM-1010-03 40A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom of great hill false false false true true   false false false true false false true true dog chased POINT (-73.9588660250232 40.7982597947515)   19 4 19 13
242 -73.9590236602085 40.7982632456866 40A-AM-1010-04 40A AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom great hill false false false false true   false false false true false false true true dog chased POINT (-73.9590236602085 40.7982632456866)   19 4 19 13
308 -73.9554095823557 40.7887305802044 32I-AM-1013-01 32I AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9554095823557 40.7887305802044)   19 4 19 13
614 -73.9642411990432 40.7779692777193 18H-PM-1014-03 18H PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9642411990432 40.7779692777193)   19 4 19 13
681 -73.9552880892701 40.7889040503316 32I-AM-1013-04 32I AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9552880892701 40.7889040503316)   19 4 19 13
760 -73.9718234159557 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true true burying false false false true false false false true   POINT (-73.9718234159557 40.7810842503715)   19 4 19 13
784 -73.9649658099293 40.7823262369074 22F-PM-1014-03 22F PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9649658099293 40.7823262369074)   19 4 19 13
815 -73.9753283783695 40.7733043910649 8C-PM-1013-02 08C PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9753283783695 40.7733043910649)   19 4 19 13
1218 -73.953375642605 40.7947144477885 38G-PM-1020-02 38G PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.953375642605 40.7947144477885)   19 4 19 13
1523 -73.9673103881521 40.7874267409618 26A-PM-1006-01 26A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9673103881521 40.7874267409618)   19 4 19 13
1616 -73.9642666013207 40.7810384867375 21G-PM-1007-03 21G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.96426660132072 40.7810384867375)   19 4 19 13
1722 -73.9802564685265 40.7681759098199 2B-AM-1010-05 02B AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9802564685265 40.7681759098199)   19 4 19 13
2425 -73.9791141532217 40.7714888835416 5A-AM-1006-04 05A AM 10062018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9791141532217 40.77148888354161)   19 4 19 13
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
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
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
2751 -73.956289117157 40.7953393993803 38E-AM-1010-11 38E AM 10102018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of the stream false false false false true   false false false true false false true false   POINT (-73.956289117157 40.7953393993803)   19 4 19 13
2759 -73.9543373703455 40.7943889087123 38G-PM-1020-07 38G PM 10202018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false true false true false false true false   POINT (-73.9543373703455 40.7943889087123)   19 4 19 13
2857 -73.9649230271173 40.7821766215675 22F-PM-1014-02 22F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9649230271173 40.7821766215675)   19 4 19 13
2876 -73.9558995737654 40.7960097734603 39E-AM-1018-05 39E AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9558995737654 40.7960097734603)   19 4 19 13
2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true checkin' his stashes false false false true false true false true   POINT (-73.9767953468937 40.7676376977667)   19 4 19 13
74 -73.9546654184146 40.7947639241491 38G-PM-1020-09 38G PM 10202018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false true false false true false   POINT (-73.9546654184146 40.7947639241491)   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
1514 -73.9548006161673 40.7945503341011 38G-PM-1020-08 38G PM 10202018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   true false false true false false true false   POINT (-73.9548006161673 40.7945503341011)   19 4 19 13
1910 -73.9699876501742 40.7742482676758 12F-PM-1007-06 12F PM 10072018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true false false true   false false false true false false true false   POINT (-73.9699876501742 40.77424826767581)   19 4 19 13
2210 -73.9699124811406 40.7743016981538 12F-PM-1007-07 12F PM 10072018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true false true   false false false true false false true false   POINT (-73.9699124811406 40.7743016981538)   19 4 19 13
239 -73.9758464905133 40.7725957408841 8C-PM-1013-05 08C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9758464905133 40.7725957408841)   19 4 19 13
887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9635028497015 40.7928207574906)   19 4 19 13
1126 -73.9700186001049 40.7826052184658 20B-AM-1007-03 20B AM 10072018 3 Adult Gray White Gray+White   Above Ground     false false false false true   false false false true false false false true   POINT (-73.9700186001049 40.7826052184658)   19 4 19 13
1175 -73.9803282698463 40.7680809889384 1B-PM-1019-09 01B PM 10192018 9 Adult Gray White Gray+White   Ground Plane FALSE Tree to ground false false false false true   false false false true false false true false   POINT (-73.9803282698463 40.7680809889384)   19 4 19 13
1421 -73.9595022290348 40.7831151330074 25I-PM-1007-02 25I PM 10072018 2 Adult Gray White Gray+White white belly Ground Plane FALSE   false false false false true   false false false true true false false true   POINT (-73.9595022290348 40.783115133007406)   19 4 19 13
1529 -73.9692401421068 40.7707128895661 8I-AM-1006-04 08I AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false true false false true false   POINT (-73.9692401421068 40.7707128895661)   19 4 19 13
1660 -73.9800499498034 40.7702181099573 4A-PM-1007-05 04A PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE At rock false false false false true   false false false true true false true false   POINT (-73.9800499498034 40.770218109957305)   19 4 19 13
1981 -73.972154069981 40.7690128009722 6G-AM-1008-03 06G AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE grass false false false true true   false false false true false false true false   POINT (-73.972154069981 40.7690128009722)   19 4 19 13
2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   false false false false true   false false false true false false true false   POINT (-73.9707571364399 40.7758859812524)   19 4 19 13
2363 -73.9690638424196 40.7713869295685 9H-AM-1006-06 09H AM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true true false true false   POINT (-73.9690638424196 40.7713869295685)   19 4 19 13
2591 -73.9786351029146 40.7716114164002 6A-PM-1012-06 06A PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE elevated ground false true false false true   false false false true false false true false   POINT (-73.9786351029146 40.771611416400205)   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 170.835ms