squirrels

21 rows where Above Ground Sighter Measurement = 8, Location = "Above Ground" and Running = "false" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Chasing, Climbing, Eating, Other Activities, Kuks, Moans, Tail flags, Approaches, Indifferent, Runs from, Other Interactions

Foraging ✖

Zip Codes ✖

  • 21

Running ✖

  • false · 21 ✖

Location ✖

  • Above Ground · 21 ✖

Above Ground Sighter Measurement ✖

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
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
319 319 -73.9659034359706 40.7797516688844 19F-AM-1007-02 19F AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 8   false false false true false   false false false false false false true false   POINT (-73.9659034359706 40.77975166888441)   19 4 19 13
2081 2081 -73.9675718059539 40.7786049141486 17F-AM-1007-06 17F AM 10072018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 8   false false true false false   false false false false false false true false   POINT (-73.9675718059539 40.7786049141486)   19 4 19 13
72 72 -73.9666007935638 40.7845098131567 23C-PM-1014-03 23C PM 10142018 3 Adult Gray   Gray+   Above Ground 8   false true false false false chasing (#4 across trees) false false false false false false false false   POINT (-73.9666007935638 40.7845098131567)   19 4 19 13
639 639 -73.9558589529608 40.7892400394941 32H-PM-1006-02 32H PM 10062018 2   Gray   Gray+   Above Ground 8   false false true false false   false false false false false false false false   POINT (-73.9558589529608 40.7892400394941)   19 4 19 13
1087 1087 -73.9679955831115 40.7818431607916 20C-PM-1018-04 20C PM 10182018 4 Adult Gray   Gray+   Above Ground 8   false false true false false   false false false false false false false false   POINT (-73.9679955831115 40.7818431607916)   19 4 19 13
1238 1238 -73.9773692131441 40.7679771150149 3D-PM-1010-02 03D PM 10102018 2 Adult Gray   Gray+   Above Ground 8   false false true false false   false false false false false false false false   POINT (-73.9773692131441 40.7679771150149)   19 4 19 13
1974 1974 -73.9772420734509 40.7730025191407 7A-PM-1007-01 07A PM 10072018 1 Adult Gray   Gray+   Above Ground 8   false false true false false   false false false false false false false false   POINT (-73.9772420734509 40.7730025191407)   19 4 19 13
2341 2341 -73.9665363265054 40.7844967881001 23C-PM-1014-04 23C PM 10142018 4 Adult Gray   Gray+   Above Ground 8   false false false false false being chased by #3 across trees false false false false false false false false   POINT (-73.9665363265054 40.7844967881001)   19 4 19 13
2616 2616 -73.9675917702187 40.7789922281625 17E-AM-1017-02 17E AM 10172018 2 Adult Gray   Gray+   Above Ground 8 Shore false false true false true   false false false false false false true false   POINT (-73.9675917702187 40.7789922281625)   19 4 19 13
2634 2634 -73.9695685186489 40.7788293026327 16D-AM-1007-04 16D AM 10072018 4 Adult Gray   Gray+   Above Ground 8   false false true false false   false false false true false false false true   POINT (-73.9695685186489 40.7788293026327)   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
2942 2942 -73.9672063784809 40.7826070395665 21D-PM-1008-01 21D PM 10082018 1   Gray   Gray+   Above Ground 8   false false true false false   false false false false false true false false   POINT (-73.9672063784809 40.7826070395665)   19 4 19 13
1217 1217 -73.9764850086767 40.7737340720562 8B-AM-1007-07 08B AM 10072018 7 Juvenile Gray Black Gray+Black   Above Ground 8   false false false true false holding nut false false false false false false true false   POINT (-73.9764850086767 40.7737340720562)   19 4 19 13
372 372 -73.9781303869038 40.7725000348875 7A-AM-1006-02 07A AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 in tree false false true false false   false false false false false false false true   POINT (-73.9781303869038 40.7725000348875)   19 4 19 13
2599 2599 -73.9689893412693 40.785308737683 23A-AM-1018-03 23A AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8 Tree false false true false false   false false false false false false true false   POINT (-73.9689893412693 40.785308737683)   19 4 19 13
2680 2680 -73.9721348050673 40.7666920046704 3H-AM-1008-01 03H AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   false false false false false teasing barking dog false false false false false false true false indifferent by not caring about dog POINT (-73.9721348050673 40.7666920046704)   19 4 19 13
2747 2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   false false true false true   false false false false false false true false   POINT (-73.971314838366 40.774951285041)   19 4 19 13
1449 1449 -73.9561124892063 40.7949440648632 37E-AM-1013-04 37E AM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   false false true true false   true false false false false false false true   POINT (-73.9561124892063 40.7949440648632)   19 4 19 13
601 601 -73.9522291603405 40.7976985385835 42G-PM-1014-01 42G PM 10142018 1 Adult Gray White Gray+White   Above Ground 8   false false true false true   false false true false false false false true   POINT (-73.9522291603405 40.7976985385835)   19 4 19 13
2084 2084 -73.9567255763265 40.7936331899263 36F-AM-1017-05 36F AM 10172018 5 Adult Gray White Gray+White   Above Ground 8   false false false false false staying very still to avoid two very curious dogs on the ground false false false false false false false false petrified,frozen (tail over its back,frozen) POINT (-73.9567255763265 40.7936331899263)   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 75.363ms