squirrels

27 rows where Above Ground Sighter Measurement = 25, Location = "Above Ground" and Running = "false" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Chasing, Climbing, Eating, Other Activities, Kuks, Other Interactions

Foraging ✖

Zip Codes ✖

  • 27

Running ✖

  • false · 27 ✖

Location ✖

  • Above Ground · 27 ✖

Above Ground Sighter Measurement ✖

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
1680 1680 -73.9638167248251 40.7776485679354 18I-PM-1007-03 18I PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25   false false true false false   false false false false false false false false stared at me POINT (-73.9638167248251 40.77764856793541)   19 4 19 13
139 139 -73.969847380865 40.7769884612305 14E-AM-1008-05 14E AM 10082018 5 Adult Gray   Gray+   Above Ground 25   false false true false false nest building false false false false false false true false   POINT (-73.969847380865 40.7769884612305)   19 4 19 13
415 415 -73.9570131890379 40.7991786736124 41B-PM-1014-05 41B PM 10142018 5 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true true   POINT (-73.9570131890379 40.7991786736124)   19 4 19 13
425 425 -73.9704485231855 40.7717290560806 9G-AM-1007-02 09G AM 10072018 2 Adult Gray   Gray+   Above Ground 25   false false true false false   false false false false false false false true kids were trying to poke it with a stick POINT (-73.9704485231855 40.7717290560806)   19 4 19 13
518 518 -73.9687847410656 40.778185700305 16E-AM-1014-09 16E AM 10142018 9 Adult Gray   Gray+   Above Ground 25 In tree false false true false false   false false false false false false true false   POINT (-73.9687847410656 40.778185700305)   19 4 19 13
1061 1061 -73.9532657715601 40.7949046809422 39G-AM-1018-02 39G AM 10182018 2 Juvenile Gray   Gray+   Above Ground 25 Tree false false false false false sitting & watching false false false false false false true false   POINT (-73.9532657715601 40.7949046809422)   19 4 19 13
1357 1357 -73.9631350020634 40.791907210332 32B-PM-1010-01 32B PM 10102018 1 Juvenile Gray   Gray+   Above Ground 25 in tree false false true false false   false false false false true false false true   POINT (-73.9631350020634 40.791907210332)   19 4 19 13
1573 1573 -73.9595613548804 40.7838057527338 25I-PM-1007-04 25I PM 10072018 4 Adult Gray   Gray+   Above Ground 25   false false true false false   false false false false false false false false   POINT (-73.9595613548804 40.7838057527338)   19 4 19 13
1692 1692 -73.973268329435 40.7708296517073 7E-AM-1006-05 07E AM 10062018 5 Adult Gray   Gray+   Above Ground 25 in tree false false true false false   false false false false false false false false   POINT (-73.973268329435 40.7708296517073)   19 4 19 13
1790 1790 -73.9730592548116 40.7740879251541 10D-AM-1008-04 10D AM 10082018 4 Juvenile Gray   Gray+   Above Ground 25   false true true false false   false false false false false false false false   POINT (-73.9730592548116 40.7740879251541)   19 4 19 13
2076 2076 -73.9712636931964 40.77998098773 17B-AM-1010-03 17B AM 10102018 3 Adult Gray   Gray+   Above Ground 25   false false true false false   false false false false false false false false   POINT (-73.9712636931964 40.77998098773)   19 4 19 13
2844 2844 -73.9578840941242 40.7955586232429 37D-PM-1014-06 37D PM 10142018 6 Adult Gray   Gray+   Above Ground 25   false false true false true   false false false false false false false false   POINT (-73.9578840941242 40.7955586232429)   19 4 19 13
2960 2960 -73.962524814515 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true false   POINT (-73.962524814515 40.7810022923615)   19 4 19 13
460 460 -73.9549135206961 40.798525897229 42D-PM-1013-03 42D PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree false false false true false   false false false false false false true false   POINT (-73.9549135206961 40.798525897229)   19 4 19 13
942 942 -73.9533923917973 40.7961701874769 40G-AM-1007-01 40G AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 large tree false false true true false   false false false false false false true false   POINT (-73.9533923917973 40.7961701874769)   19 4 19 13
1012 1012 -73.9755569170561 40.7668006977526 2F-AM-1006-03 02F AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree false false true false false   false false false false false false false false   POINT (-73.9755569170561 40.7668006977526)   19 4 19 13
1609 1609 -73.9639024988123 40.7776953065849 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639024988123 40.7776953065849)   19 4 19 13
2308 2308 -73.9688574856542 40.7780770207023 16E-AM-1014-10 16E AM 10142018 10 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false true false false   false false false false false false false false   POINT (-73.9688574856542 40.7780770207023)   19 4 19 13
2337 2337 -73.9673490137465 40.7782728130401 17F-PM-1020-02 17F PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false false true false   false false false false false false false true   POINT (-73.9673490137465 40.7782728130401)   19 4 19 13
2979 2979 -73.9571808775915 40.7934443866725 35E-AM-1020-02 35E AM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false false false false cleaning herself false false false false false false true false   POINT (-73.9571808775915 40.7934443866725)   19 4 19 13
102 102 -73.9575986161364 40.799368134968 41B-PM-1014-01 41B PM 10142018 1 Adult Gray White Gray+White   Above Ground 25 Climbing tree false false true false false climbing (tree) false false false false false false false true   POINT (-73.9575986161364 40.799368134968)   19 4 19 13
483 483 -73.9789952029637 40.7697758333099 4B-AM-1010-03 04B AM 10102018 3 Juvenile Gray White Gray+White   Above Ground 25   false false true false false   false false false false false false true false   POINT (-73.9789952029637 40.7697758333099)   19 4 19 13
792 792 -73.9730115687964 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   false false true true false   false false false false false false false false   POINT (-73.9730115687964 40.7741018274312)   19 4 19 13
1315 1315 -73.9595955824812 40.7933047943534 34D-PM-1007-01 34D PM 10072018 1 Adult Gray White Gray+White   Above Ground 25   false false true false true   false false false false true false false true   POINT (-73.9595955824812 40.7933047943534)   19 4 19 13
1411 1411 -73.9802840031759 40.7678599069819 1B-PM-1019-04 01B PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.9802840031759 40.7678599069819)   19 4 19 13
2865 2865 -73.9802842404016 40.7678257384977 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.98028424040162 40.7678257384977)   19 4 19 13
2973 2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse false false true false false   false false false false false false true false   POINT (-73.9766693184436 40.7708879215854)   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 9119.952ms