squirrels

18 rows where Combination of Primary and Highlight Color = "Gray+White", Date = 10122018 and Foraging = "false"

✎ 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, Chasing, Climbing, Eating, Other Activities, 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
549 549 -73.9549082481152 40.7933537584624 36G-PM-1012-01 36G PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false crossing east drive false false false false false false false false   POINT (-73.9549082481152 40.7933537584624)   19 4 19 13
772 772 -73.9584188461059 40.7913241048498 33E-PM-1012-07 33E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9584188461059 40.7913241048498)   19 4 19 13
907 907 -73.958060992131 40.7907158878729 32F-AM-1012-06 32F AM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.958060992131 40.7907158878729)   19 4 19 13
1231 1231 -73.9555583724966 40.7932879745739 36F-PM-1012-07 36F PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9555583724966 40.7932879745739)   19 4 19 13
1292 1292 -73.959019987128 40.7912546691805 33E-PM-1012-05 33E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing false false false false false false false false   POINT (-73.959019987128 40.7912546691805)   19 4 19 13
1349 1349 -73.9806805581636 40.7681537966505 1B-AM-1012-16 01B AM 10122018 16 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9806805581636 40.7681537966505)   19 4 19 13
1461 1461 -73.956926909344 40.7965323262487 39D-PM-1012-03 39D PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.956926909344 40.7965323262487)   19 4 19 13
1805 1805 -73.9590328527128 40.7912214417577 33E-PM-1012-06 33E PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing false false false false false false false false   POINT (-73.9590328527128 40.7912214417577)   19 4 19 13
2002 2002 -73.9581706950566 40.7906321397269 32F-AM-1012-05 32F AM 10122018 5 Adult Gray White Gray+White   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9581706950566 40.7906321397269)   19 4 19 13
2051 2051 -73.9544808708211 40.7906575852286 34I-AM-1012-02 34I AM 10122018 2 Adult Gray White Gray+White Short tail Ground Plane FALSE   false false false false false hiding false false false false false false false true   POINT (-73.9544808708211 40.7906575852286)   19 4 19 13
2213 2213 -73.9707487237344 40.7800822831001 17B-PM-1012-03 17B PM 10122018 3 Adult Gray White Gray+White   Above Ground 10   true true false false false 2/3 chasing each other false false false false true false true false   POINT (-73.9707487237344 40.7800822831001)   19 4 19 13
2214 2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9583688637255 40.791388958496)   19 4 19 13
2231 2231 -73.9545427611477 40.7930353817441 36G-PM-1012-02 36G PM 10122018 2 Adult Gray White Gray+White   Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.9545427611477 40.7930353817441)   19 4 19 13
2232 2232 -73.9566277721581 40.7966674587803 39D-PM-1012-04 39D PM 10122018 4 Juvenile Gray White Gray+White   Above Ground 10 on tree trunk (descending from height of ~10 ft) false false true false false   false false false false false false true false   POINT (-73.95662777215811 40.7966674587803)   19 4 19 13
2304 2304 -73.9715251156965 40.774621784862 11E-PM-1012-07 11E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9715251156965 40.774621784862)   19 4 19 13
2390 2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   false false false false false watching me - didn't move false false false false true false false true   POINT (-73.9680741975294 40.7847036778165)   19 4 19 13
2394 2394 -73.9785829546046 40.7719652299132 6A-PM-1012-02 06A PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785829546046 40.7719652299132)   19 4 19 13
2617 2617 -73.9564228238736 40.7936908887644 36F-PM-1012-06 36F PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9564228238736 40.7936908887644)   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 64.06ms