squirrels

23 rows where Combination of Primary and Highlight Color = "Gray+", Date = 10072018 and Eating = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, 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
52 52 -73.9675634326877 40.7813477352507 19D-AM-1007-01 19D AM 10072018 1 Juvenile Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false false fenced off area can't approach POINT (-73.9675634326877 40.7813477352507)   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
171 171 -73.971086588091 40.7719703235178 9G-PM-1007-06 09G PM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.971086588091 40.7719703235178)   19 4 19 13
244 244 -73.9597648775789 40.7903443029725 32E-AM-1007-01 32E AM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9597648775789 40.7903443029725)   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
406 406 -73.9766354967197 40.7734575166319 8B-AM-1007-09 08B AM 10072018 9 Adult Gray   Gray+   Ground Plane FALSE   true false false true false shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating false false false false false false true false   POINT (-73.9766354967197 40.7734575166319)   19 4 19 13
912 912 -73.958024711869 40.7938724278575 36D-PM-1007-01 36D PM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.958024711869 40.7938724278575)   19 4 19 13
1495 1495 -73.9735137178369 40.769109895294 5F-AM-1007-06 05F AM 10072018 6 Adult Gray   Gray+   Above Ground 2 branch false false false true false   false false false false false false false false   POINT (-73.9735137178369 40.769109895294)   19 4 19 13
1546 1546 -73.976422624924 40.7735818387346 8B-AM-1007-08 08B AM 10072018 8 Adult Gray   Gray+   Above Ground 6   false false false true false holding nut false false false false false false true false   POINT (-73.976422624924 40.7735818387346)   19 4 19 13
1624 1624 -73.9737060043988 40.7725660224983 8D-AM-1007-05 08D AM 10072018 5 Adult Gray   Gray+   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9737060043988 40.7725660224983)   19 4 19 13
1647 1647 -73.9795585338537 40.768895893226 3B-PM-1007-08 03B PM 10072018 8 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9795585338537 40.768895893226)   19 4 19 13
1684 1684 -73.9637824756607 40.7904737110761 30B-AM-1007-08 30B AM 10072018 8 Adult Gray   Gray+   Above Ground 40   true false false true false   false false false false false false false false   POINT (-73.9637824756607 40.7904737110761)   19 4 19 13
1701 1701 -73.9701634768603 40.7778691433218 15D-AM-1007-03 15D AM 10072018 3 Adult Gray   Gray+   Above Ground 10   false false true true false   false false false false false false true false   POINT (-73.9701634768603 40.7778691433218)   19 4 19 13
1743 1743 -73.9635412640983 40.7902529354639 30B-AM-1007-11 30B AM 10072018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9635412640983 40.7902529354639)   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
2100 2100 -73.9638312025305 40.7903826659569 30B-AM-1007-07 30B AM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9638312025305 40.7903826659569)   19 4 19 13
2167 2167 -73.9799594281222 40.7701978146968 4A-AM-1007-05 04A AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9799594281222 40.7701978146968)   19 4 19 13
2370 2370 -73.9573119777312 40.7875347862766 30H-AM-1007-02 30H AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false following #1 false false false false true false false false   POINT (-73.9573119777312 40.7875347862766)   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
2566 2566 -73.9744226682925 40.7755625717273 11B-AM-1007-04 11B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9744226682925 40.7755625717273)   19 4 19 13
2859 2859 -73.9786940945874 40.7690820276888 3B-PM-1007-05 03B PM 10072018 5 Juvenile Gray   Gray+   Above Ground 6 on rock false false true true false   false false false false false false true false   POINT (-73.9786940945874 40.7690820276888)   19 4 19 13
2869 2869 -73.9630822385425 40.7914844989865 31B-PM-1007-04 31B PM 10072018 4 Juvenile Gray   Gray+         false false false true false   false false false false false false false false   POINT (-73.9630822385425 40.7914844989865)   19 4 19 13
3019 3019 -73.9639431360458 40.7908677445466 30B-AM-1007-04 30B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9639431360458 40.7908677445466)   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 71.124ms