squirrels

40 rows where Eating = "true" and Tail flags = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Other Activities, Kuks, Tail twitches, Approaches, Runs from, Other Interactions

Indifferent ✖

Eating ✖

  • true · 40 ✖
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
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
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
94 94 -73.9641971813967 40.7813537959435 21G-PM-1007-01 21G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9641971813967 40.7813537959435)   19 4 19 13
124 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
159 159 -73.9638270331336 40.7810450065235 21G-PM-1007-02 21G PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.9638270331336 40.7810450065235)   19 4 19 13
203 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
210 210 -73.9711298491132 40.7676902603543 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing false false true true false   false false false true false false false false   POINT (-73.9711298491132 40.7676902603543)   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
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
373 373 -73.9672127283283 40.7810666805133 20D-AM-1007-01 20D AM 10072018 1 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   true false true true false a lot of activity false false false true false false false false   POINT (-73.9672127283283 40.7810666805133)   19 4 19 13
379 379 -73.9606817053484 40.7917320450401 32D-PM-1006-07 32D PM 10062018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9606817053484 40.7917320450401)   19 4 19 13
416 416 -73.9702788578386 40.7694484997295 7I-PM-1013-05 07I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock false false false true false   false false false true false false false false   POINT (-73.9702788578386 40.7694484997295)   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
706 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
727 727 -73.9634563222926 40.780992836417 21G-PM-1007-04 21G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.9634563222926 40.780992836417)   19 4 19 13
730 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
760 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
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
1138 1138 -73.9594357049738 40.7840678890949 25I-AM-1012-01 25I AM 10122018 1 Adult Cinnamon   Cinnamon+   Above Ground 4 on bar false false false true false   false false false true true true false false   POINT (-73.9594357049738 40.7840678890949)   19 4 19 13
1230 1230 -73.9790822606486 40.7714466633386 5A-AM-1006-03 05A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Above Ground 8   false false true true false   false false false true false false false true   POINT (-73.9790822606486 40.7714466633386)   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
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
1795 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
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
1944 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
1967 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
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
2134 2134 -73.9614373639552 40.7945051962914 35B-PM-1013-01 35B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false did not notice dog sitting a few yards away (10-20 ft) false false false true false false true false   POINT (-73.9614373639552 40.7945051962914)   19 4 19 13
2203 2203 -73.9710531485298 40.7773757069445 14D-PM-1019-06 14D PM 10192018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.97105314852982 40.777375706944504)   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
2433 2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   false false false true false   false false false true true false true false   POINT (-73.9706949930717 40.772362045852)   19 4 19 13
2440 2440 -73.9673803508629 40.7785245025508 17F-AM-1007-01 17F AM 10072018 1 Adult Gray   Gray+   Above Ground 18   false false true true false   false false false true false false true false   POINT (-73.9673803508629 40.7785245025508)   19 4 19 13
2463 2463 -73.9653343572865 40.7775286924617 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true false   false false false true false false false true   POINT (-73.9653343572865 40.7775286924617)   19 4 19 13
2489 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
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
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
2852 2852 -73.9728146482385 40.7652951714745 1I-PM-1012-03 01I PM 10122018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.97281464823851 40.765295171474506)   19 4 19 13
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

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 66.78ms