squirrels

155 rows where Tail flags = "true" sorted by Highlight Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Combination of Primary and Highlight Color ✖

Climbing ✖

Tail flags ✖

  • true · 55 ✖

City Council Districts ✖

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
2980 2980 -73.9716414586381 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false running (from birds) false false false true false false true false   POINT (-73.9716414586381 40.771760114722)   19 4 19 13
74 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
316 316 -73.9540616660191 40.7951556603245 38G-PM-1020-10 38G PM 10202018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9540616660191 40.7951556603245)   19 4 19 13
335 335 -73.9782351435852 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true false true false   false false false true true false false false   POINT (-73.9782351435852 40.7715896672335)   19 4 19 13
1048 1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree false false true false false   false false false true true false false false curious POINT (-73.9782120139407 40.7717154468791)   19 4 19 13
1201 1201 -73.9782813538421 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true true false false   false false false true false false false false   POINT (-73.9782813538421 40.7715730368712)   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
1514 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 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 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
2294 2294 -73.9630820577441 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false true false   false false false true false false true false   POINT (-73.9630820577441 40.7821632293136)   19 4 19 13
2348 2348 -73.9531965469704 40.7947437983977 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false true true false   POINT (-73.9531965469704 40.7947437983977)   19 4 19 13
2821 2821 -73.9754536566013 40.7698604918771 5E-PM-1012-04 05E PM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9754536566013 40.7698604918771)   19 4 19 13
261 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 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
928 928 -73.967042958599 40.7784370719371 17F-AM-1007-05 17F AM 10072018 5 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true false   false false false true false false true false   POINT (-73.967042958599 40.7784370719371)   19 4 19 13
1017 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
1135 1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree false true false false false watching me false true false true false false false false observant POINT (-73.9667474482967 40.7760643720793)   19 4 19 13
1415 1415 -73.9678561384348 40.7782877397822 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false true false false false   false false false true false false false false gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)   19 4 19 13
1636 1636 -73.9701408623121 40.7695511718541 7I-PM-1013-04 07I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Grass true false false true false   false false false true false false false false   POINT (-73.9701408623121 40.7695511718541)   19 4 19 13
1808 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 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
2026 2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch false false false false false watching me scratching true false false true false false true false   POINT (-73.9622752768962 40.7814921913101)   19 4 19 13
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree true true false false false   false false false true true false true false   POINT (-73.9595222999173 40.7833202577782)   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
2583 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 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
150 150 -73.9763430829342 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward false true false false false chased #12 true false false true false false false true   POINT (-73.9763430829342 40.7686351097159)   19 4 19 13
188 188 -73.9570528770427 40.7990973804149 41B-AM-1010-07 41B AM 10102018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   false false false false false   true false false true false true false false mad! POINT (-73.9570528770427 40.7990973804149)   19 4 19 13
194 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
25 25 -73.9671130680114 40.7784859700171 17F-AM-1007-07 17F AM 10072018 7 Adult Gray White Gray+White   Above Ground 24   true false false false false   false false false true false false true false   POINT (-73.9671130680114 40.7784859700171)   19 4 19 13
80 80 -73.9688454483585 40.7845301288163 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can false false false true false   false false false true false false false true   POINT (-73.9688454483585 40.7845301288163)   19 4 19 13
239 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
294 294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false true false false true false too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)   19 4 19 13
855 855 -73.9808247660048 40.7689408831287 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false runs from false false false true false false false true   POINT (-73.9808247660048 40.7689408831287)   19 4 19 13
887 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
1019 1019 -73.9704269630964 40.7722964640257 10G-AM-1006-09 10G AM 10062018 9 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9704269630964 40.7722964640257)   19 4 19 13
1126 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 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
1403 1403 -73.9761632586697 40.7741085606149 9B-PM-1013-05 09B PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9761632586697 40.7741085606149)   19 4 19 13
1421 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 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 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
1836 1836 -73.9751056714758 40.7732060035215 8C-PM-1013-03 08C PM 10132018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9751056714758 40.7732060035215)   19 4 19 13
1956 1956 -73.980897497712 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false false false   POINT (-73.980897497712 40.7690578709841)   19 4 19 13
1981 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
2044 2044 -73.9771552326199 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   false false false true false true false false   POINT (-73.9771552326199 40.7706917595308)   19 4 19 13
2185 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 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
2397 2397 -73.9704592500888 40.772962887933 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   false false true false false   false false false true false false false true   POINT (-73.9704592500888 40.772962887933)   19 4 19 13
2444 2444 -73.966590487009 40.7802469052891 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false true false false false false   POINT (-73.96659048700901 40.7802469052891)   19 4 19 13
2547 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
2591 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
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false true false false false true   POINT (-73.95795157569 40.7961254697958)   19 4 19 13
2794 2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   true false false true false false false true   POINT (-73.9712187890707 40.7750640173134)   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 10.427ms