squirrels

31 rows where Combination of Primary and Highlight Color = "Gray+", Hectare Squirrel Number = 4 and Running = "true"

View and edit SQL

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Tail twitches, Indifferent, Runs from, Other Interactions

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
336 -73.9757413215621 40.7692582758978 4E-PM-1008-04 04E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   true true true false false   false false false false false false true false   POINT (-73.9757413215621 40.7692582758978)   19 4 19 13
709 -73.9519387881692 40.7936273636929 38I-PM-1014-04 38I PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9519387881692 40.7936273636929)   19 4 19 13
824 -73.9606344681252 40.7958337780644 37B-PM-1013-04 37B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9606344681252 40.795833778064406)   19 4 19 13
889 -73.9681042612938 40.772331431865 11I-PM-1012-04 11I PM 10122018 4 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9681042612938 40.772331431865)   19 4 19 13
903 -73.9719941577406 40.77037129313 7G-AM-1010-04 07G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9719941577406 40.77037129313)   19 4 19 13
932 -73.9718597156773 40.7765858763313 13C-PM-1019-04 13C PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9718597156773 40.7765858763313)   19 4 19 13
1072 -73.9566571713254 40.7989855775435 41C-AM-1017-04 41C AM 10172018 4   Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9566571713254 40.7989855775435)   19 4 19 13
1124 -73.959516757215 40.7952545908471 36C-PM-1013-04 36C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE On rock true false false false true   false false false false false false false true   POINT (-73.959516757215 40.7952545908471)   19 4 19 13
1458 -73.9545037193355 40.7900225055417 33I-PM-1006-04 33I PM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9545037193355 40.7900225055417)   19 4 19 13
1690 -73.96052295327 40.7934359372871 34C-PM-1012-04 34C PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.96052295327 40.7934359372871)   19 4 19 13
1736 -73.9743873549635 40.7745426051392 10C-AM-1018-04 10C AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9743873549635 40.7745426051392)   19 4 19 13
1752 -73.9561091686663 40.7981463047425 41D-AM-1014-04 41D AM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9561091686663 40.7981463047425)   19 4 19 13
1794 -73.9757912350482 40.7747598621451 10B-AM-1006-04 10B AM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9757912350482 40.7747598621451)   19 4 19 13
1823 -73.9612854506075 40.7920830673571 32C-PM-1013-04 32C PM 10132018 4 Juvenile Gray   Gray+   Above Ground     true false true false false   false false false false false false false false   POINT (-73.9612854506075 40.7920830673571)   19 4 19 13
1882 -73.9541601469123 40.7907832744689 34I-PM-1010-04 34I PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE across the lawn and climb up a small tree true false true false false grooming false false false false false false false false   POINT (-73.9541601469123 40.79078327446891)   19 4 19 13
1925 -73.9581389870644 40.7993081122523 41A-PM-1007-04 41A PM 10072018 4 Adult Gray   Gray+   Above Ground 20   true false true false false laid down on the branch false false false false false false false true   POINT (-73.9581389870644 40.799308112252305)   19 4 19 13
1962 -73.9647318357023 40.7760936175332 15I-PM-1012-04 15I PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false false   POINT (-73.9647318357023 40.7760936175332)   19 4 19 13
2018 -73.9697924026634 40.7803611152023 18C-PM-1018-04 18C PM 10182018 4 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9697924026634 40.7803611152023)   19 4 19 13
2101 -73.957600085245 40.7936111607879 35E-PM-1006-04 35E PM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.957600085245 40.7936111607879)   19 4 19 13
2162 -73.9583300280173 40.7853495002675 27I-PM-1020-04 27I PM 10202018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9583300280173 40.7853495002675)   19 4 19 13
2204 -73.9532427699097 40.7962643767092 40G-PM-1013-04 40G PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9532427699097 40.7962643767092)   19 4 19 13
2246 -73.9711607544742 40.774988247642 12E-AM-1017-04 12E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9711607544742 40.774988247642)   19 4 19 13
2279 -73.9586085858962 40.7990326758282 40A-PM-1014-04 40A PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran from path to bushes) POINT (-73.9586085858962 40.7990326758282)   19 4 19 13
2442 -73.9699369796844 40.7720350191273 10G-PM-1017-04 10G PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9699369796844 40.7720350191273)   19 4 19 13
2619 -73.9739737592602 40.7727130476777 9D-AM-1008-04 09D AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9739737592602 40.7727130476777)   19 4 19 13
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
2734 -73.9763629541474 40.7682321897044 3E-PM-1008-04 03E PM 10082018 4 Adult Gray   Gray+   Above Ground 6   true false true false false   false false false false false false false true   POINT (-73.9763629541474 40.7682321897044)   19 4 19 13
2840 -73.9532163535175 40.7982970313067 42F-PM-1017-04 42F PM 10172018 4   Gray   Gray+         true false false false false   false false false false false false true false   POINT (-73.9532163535175 40.7982970313067)   19 4 19 13
2866 -73.9744025383371 40.7777296605765 13A-AM-1017-04 13A AM 10172018 4 Adult Gray   Gray+         true false false false false   false false false false false false true false   POINT (-73.9744025383371 40.7777296605765)   19 4 19 13
2987 -73.9563724838337 40.7882504581015 31I-PM-1019-04 31I PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.95637248383372 40.7882504581015)   19 4 19 13
3012 -73.9613701960898 40.7943363227822 35B-PM-1013-04 35B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   true false true false true got threatened by dog (same dog,dog #1) false false false false false false false true runs from (dog) POINT (-73.9613701960898 40.7943363227822)   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 59.236ms