squirrels

18 rows where Foraging = "true" and Hectare Squirrel Number = 12 sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Police Precincts ✖

Hectare Squirrel Number ✖

Foraging ✖

  • true · 18 ✖
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
181 181 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 10192018 12 Adult Black White Black+White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9708775864433 40.772473633538)   19 4 19 13
514 514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true false false true   false true false false false false false false   POINT (-73.9768357173861 40.7683813358343)   19 4 19 13
785 785 -73.9619417432685 40.7930365939865 33B-PM-1010-12 33B PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9619417432685 40.7930365939865)   19 4 19 13
901 901 -73.9702228131711 40.7742131587983 12F-PM-1007-12 12F PM 10072018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   false false false false true going down tree false false false false false false true false   POINT (-73.9702228131711 40.7742131587983)   19 4 19 13
1092 1092 -73.9711319254625 40.7760324859879 13D-PM-1018-12 13D PM 10182018 12 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9711319254625 40.776032485987905)   19 4 19 13
1158 1158 -73.9763894759543 40.7705523372364 5C-PM-1010-12 05C PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9763894759543 40.7705523372364)   19 4 19 13
1275 1275 -73.9702541471417 40.7698584231797 7H-AM-1006-12 07H AM 10062018 12 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9702541471417 40.7698584231797)   19 4 19 13
1386 1386 -73.9730085729495 40.7708933570327 7F-AM-1008-12 07F AM 10082018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9730085729495 40.7708933570327)   19 4 19 13
1567 1567 -73.9774407362587 40.7698056129554 4C-PM-1010-12 04C PM 10102018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774407362587 40.7698056129554)   19 4 19 13
1696 1696 -73.9694591667705 40.7766518221998 14E-AM-1008-12 14E AM 10082018 12 Adult Gray   Gray+   Above Ground 2   false false true true true   false false false false false false true false   POINT (-73.9694591667705 40.7766518221998)   19 4 19 13
1789 1789 -73.9596271142953 40.7906612313673 32E-PM-1017-12 32E PM 10172018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false true false false false false false false   POINT (-73.9596271142953 40.7906612313673)   19 4 19 13
1875 1875 -73.9527430510248 40.7924807950552 36I-PM-1007-12 36I PM 10072018 12 Juvenile Gray Cinnamon Gray+Cinnamon Tiny! So tiny! Above Ground 2   false false false false true   false false false false false false false false   POINT (-73.9527430510248 40.7924807950552)   19 4 19 13
1902 1902 -73.9703314162405 40.778584776139 16D-PM-1010-12 16D PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9703314162405 40.778584776139)   19 4 19 13
2354 2354 -73.9636740170308 40.7903538224977 30B-AM-1007-12 30B AM 10072018 12 Adult Gray   Gray+   Above Ground 4   false false true false true   false false false false false false false true   POINT (-73.96367401703081 40.79035382249771)   19 4 19 13
2547 2547 -73.9743393747021 40.7676346798325 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9743393747021 40.7676346798325)   19 4 19 13
176 176 -73.9618064639153 40.792158440043 32C-PM-1013-12 32C PM 10132018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false true true false false   POINT (-73.9618064639153 40.792158440043)   19 4 19 13
843 843 -73.9714089647431 40.7767916587915 14D-AM-1014-12 14D AM 10142018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9714089647431 40.7767916587915)   19 4 19 13
1485 1485 -73.9791085350047 40.7677025342633 2C-PM-1013-12 02C PM 10132018 12 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9791085350047 40.7677025342633)   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 78.059ms