squirrels

33 rows where Date = 10142018, Eating = "true" and Shift = "AM"

✎ View and edit SQL

This data as json, CSV (advanced)

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

These facets timed out: Color notes

Shift ✖

Date ✖

  • 10142018 · 33 ✖
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
154 154 -73.9686056085297 40.7781658424866 16E-AM-1014-03 16E AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9686056085297 40.7781658424866)   19 4 19 13
289 289 -73.9684254196866 40.77809016436 16E-AM-1014-02 16E AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9684254196866 40.77809016436)   19 4 19 13
330 330 -73.9708969246276 40.7767695507462 14D-AM-1014-03 14D AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9708969246276 40.7767695507462)   19 4 19 13
498 498 -73.9669432929573 40.779136518298 18F-AM-1014-01 18F AM 10142018 1 Adult Gray White Gray+White   Above Ground   Low tree false false false true false   false false false false false false true false   POINT (-73.9669432929573 40.779136518298)   19 4 19 13
501 501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9708798496132 40.7761532088521)   19 4 19 13
719 719 -73.9626881234742 40.7905208345549 30C-AM-1014-01 30C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9626881234742 40.7905208345549)   19 4 19 13
736 736 -73.9660110060416 40.7809990098597 20F-AM-1014-01 20F AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9660110060416 40.7809990098597)   19 4 19 13
818 818 -73.9608757424052 40.7906686504657 31D-AM-1014-06 31D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9608757424052 40.7906686504657)   19 4 19 13
842 842 -73.9645147011741 40.7772566833799 17I-AM-1014-04 17I AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true true false   POINT (-73.9645147011741 40.7772566833799)   19 4 19 13
843 843 -73.9714089647431 40.7767916587915 14D-AM-1014-12 14D AM 10142018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9714089647431 40.7767916587915)   19 4 19 13
1021 1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running (from a dog) false false false false false false true false   POINT (-73.97186968288 40.778926988884)   19 4 19 13
1223 1223 -73.9591298551111 40.7919612446005 33E-AM-1014-04 33E AM 10142018 4 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9591298551111 40.7919612446005)   19 4 19 13
1295 1295 -73.9709534894049 40.7765964740768 14D-AM-1014-15 14D AM 10142018 15 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9709534894049 40.7765964740768)   19 4 19 13
1298 1298 -73.9612900553755 40.7912917391867 32C-AM-1014-01 32C AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9612900553755 40.7912917391867)   19 4 19 13
1382 1382 -73.9611274898661 40.7915250069086 32C-AM-1014-05 32C AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9611274898661 40.7915250069086)   19 4 19 13
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   false true true true false   false false false false false false false true   POINT (-73.9710801547498 40.7760872452093)   19 4 19 13
1482 1482 -73.9588610195699 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path false false false true true   false false false false false false true false   POINT (-73.9588610195699 40.7945269936639)   19 4 19 13
1603 1603 -73.9545929242174 40.7986940168685 42D-AM-1014-02 42D AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9545929242174 40.7986940168685)   19 4 19 13
1708 1708 -73.9618486459307 40.7946365810826 35A-AM-1014-02 35A AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9618486459307 40.7946365810826)   19 4 19 13
1739 1739 -73.9639700434449 40.7775003050028 17I-AM-1014-01 17I AM 10142018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE Running across fence between statue & swings true false true true false   false false false false false false true false   POINT (-73.9639700434449 40.7775003050028)   19 4 19 13
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat true false true true false   false false false false false false false true   POINT (-73.958719099962 40.7947587726617)   19 4 19 13
1936 1936 -73.9667911565238 40.779321901098 18F-AM-1014-02 18F AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE In small tree by water false false false true true   false true false false false false true false   POINT (-73.9667911565238 40.77932190109801)   19 4 19 13
2073 2073 -73.9661108248377 40.7891945123815 28A-AM-1014-01 28A AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9661108248377 40.7891945123815)   19 4 19 13
2174 2174 -73.9684092812839 40.7711445841928 9I-AM-1014-07 09I AM 10142018 7 Adult Cinnamon   Cinnamon+ No real highlight, White tail? Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9684092812839 40.7711445841928)   19 4 19 13
2195 2195 -73.955352152771 40.7988549523022 42D-AM-1014-01 42D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   false false true true false   true false false false false false true false   POINT (-73.955352152771 40.7988549523022)   19 4 19 13
2545 2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9617594316752 40.7946803725236)   19 4 19 13
2613 2613 -73.96393252683 40.7808289765857 21G-AM-1014-04 21G AM 10142018 4 Adult Gray White Gray+White   Above Ground 6   false false false true false   false false false false false false true false   POINT (-73.96393252683 40.7808289765857)   19 4 19 13
2641 2641 -73.9615516703494 40.7905219388359 31D-AM-1014-04 31D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Open ground true false false true true   false false false false true false true false   POINT (-73.9615516703494 40.7905219388359)   19 4 19 13
2655 2655 -73.9659156108069 40.7810709818696 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9659156108069 40.7810709818696)   19 4 19 13
2740 2740 -73.9612658688914 40.7912119940469 32C-AM-1014-04 32C AM 10142018 4 Adult Gray   Gray+   Above Ground 8   false false false true false   false false false false false false false false   POINT (-73.9612658688914 40.7912119940469)   19 4 19 13
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9711634340673 40.7760553338671)   19 4 19 13
2846 2846 -73.9661570478029 40.7807271518813 20E-AM-1014-02 20E AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9661570478029 40.7807271518813)   19 4 19 13
2967 2967 -73.9713257586372 40.7762719619467 13D-AM-1014-09 13D AM 10142018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9713257586372 40.7762719619467)   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 1047.734ms