squirrels

13 rows where Combination of Primary and Highlight Color = "Gray+", Date = 10192018 and Foraging = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Running, Eating, Kuks, Quaas, Tail twitches, Indifferent, Runs from

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
273 273 -73.9579218587172 40.7960605028848 38C-AM-1019-04 38C AM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   true true false false false false true false   POINT (-73.9579218587172 40.79606050288481)   19 4 19 13
638 638 -73.9562765288004 40.7880617963868 31I-PM-1019-02 31I PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9562765288004 40.7880617963868)   19 4 19 13
693 693 -73.969353372175 40.7838247422369 21A-AM-1019-06 21A AM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.969353372175 40.7838247422369)   19 4 19 13
1445 1445 -73.9696196840065 40.7836431098335 21A-AM-1019-09 21A AM 10192018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9696196840065 40.7836431098335)   19 4 19 13
1642 1642 -73.9708860879459 40.7768376656119 14D-PM-1019-15 14D PM 10192018 15 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9708860879459 40.7768376656119)   19 4 19 13
2036 2036 -73.9610266708075 40.7817512107392 23I-PM-1019-03 23I PM 10192018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9610266708075 40.7817512107392)   19 4 19 13
2375 2375 -73.9563720614251 40.7879453306251 31I-PM-1019-01 31I PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9563720614251 40.7879453306251)   19 4 19 13
2567 2567 -73.9690241805398 40.7837967580773 21B-AM-1019-07 21B AM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9690241805398 40.7837967580773)   19 4 19 13
2736 2736 -73.9593895253501 40.7973085844087 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9593895253501 40.7973085844087)   19 4 19 13
2841 2841 -73.9693262952166 40.783260411082 21B-AM-1019-01 21B AM 10192018 1 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9693262952166 40.783260411082)   19 4 19 13
2902 2902 -73.9673220504383 40.7770296345963 15G-PM-1019-04 15G PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9673220504383 40.7770296345963)   19 4 19 13
2907 2907 -73.9685201626934 40.783329261225 21B-AM-1019-05 21B AM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9685201626934 40.783329261225)   19 4 19 13
2924 2924 -73.9727230609785 40.7795341640894 16A-PM-1019-01 16A PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9727230609785 40.7795341640894)   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 62.121ms