squirrels

14 rows where Combination of Primary and Highlight Color = "Cinnamon+Gray, White" and Running = "true" sorted by Other Activities

View and edit SQL

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

Hectare Squirrel Number

Running

  • true · 14

Combination of Primary and Highlight Color

  • Cinnamon+Gray, White · 14
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
87 -73.9541453465817 40.7982162223764 42E-PM-1012-06 42E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9541453465817 40.79821622237641)   19 4 19 13
684 -73.9691057326088 40.7765973509721 14F-PM-1012-07 14F PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9691057326088 40.7765973509721)   19 4 19 13
1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn true true false false false   false false false false false false true false   POINT (-73.9765805609072 40.7692807820935)   19 4 19 13
1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9594676326588 40.7984457363388)   19 4 19 13
1739 -73.9639700434449 40.7775003050028 17I-AM-1014-01 17I AM 10142018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE Running across fence between statue & swings true false true true false   false false false false false false true false   POINT (-73.9639700434449 40.7775003050028)   19 4 19 13
1772 -73.9690540696008 40.7766014124609 14F-PM-1012-08 14F PM 10122018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9690540696008 40.7766014124609)   19 4 19 13
1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House true false false false false   false false false false false false false true   POINT (-73.9748367344424 40.7693513000034)   19 4 19 13
1947 -73.9747175419546 40.7692820030878 5E-PM-1012-05 05E PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false true false false begging POINT (-73.9747175419546 40.7692820030878)   19 4 19 13
2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9686925781295 40.7705688673142)   19 4 19 13
2574 -73.978199543688 40.7695660563362 4C-PM-1010-17 04C PM 10102018 17 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE climbed up tree true false true false true   false false false false true false false true   POINT (-73.978199543688 40.7695660563362)   19 4 19 13
2647 -73.954499539822 40.7949716693686 38F-AM-1018-01 38F AM 10182018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.954499539822 40.7949716693686)   19 4 19 13
2735 -73.9768096953647 40.7708185213129 5C-PM-1010-08 05C PM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9768096953647 40.7708185213129)   19 4 19 13
1165 -73.9689504114652 40.7766770153764 14F-PM-1012-05 14F PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 2 on a fallen branch true false false true false sitting false false false false false false false false looking at me POINT (-73.9689504114652 40.7766770153764)   19 4 19 13
1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   true false false false false was chased by # 11 true false false false false false false true   POINT (-73.9763236949008 40.7686815615335)   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 72.037ms