squirrels

23 rows where Combination of Primary and Highlight Color = "Gray+", Hectare Squirrel Number = 3, Indifferent = "false", Police Precincts = 13 and Runs from = "true" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail twitches, Other Interactions

Indifferent ✖

  • false · 23 ✖

Hectare Squirrel Number ✖

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
356 356 -73.9761036400144 40.7705482684594 6D-PM-1020-03 06D PM 10202018 3 Juvenile Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false true   POINT (-73.9761036400144 40.7705482684594)   19 4 19 13
402 402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false true runs from the dog POINT (-73.9681917366128 40.7723298813768)   19 4 19 13
491 491 -73.9688470831269 40.7844651946415 22A-AM-1008-03 22A AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9688470831269 40.7844651946415)   19 4 19 13
554 554 -73.973351945818 40.768814796037 5G-PM-1010-03 05G PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.973351945818 40.768814796037)   19 4 19 13
598 598 -73.9698196671161 40.7802972001469 18C-PM-1018-03 18C PM 10182018 3 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9698196671161 40.7802972001469)   19 4 19 13
774 774 -73.9673603655908 40.7876974177782 26A-PM-1006-03 26A PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9673603655908 40.7876974177782)   19 4 19 13
825 825 -73.9580105174865 40.7974468322692 39C-PM-1006-03 39C PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9580105174865 40.7974468322692)   19 4 19 13
869 869 -73.9629483374528 40.7936809905265 33A-PM-1018-03 33A PM 10182018 3 Adult Gray   Gray+   Above Ground 6   true false true false false   false false false false false false false true   POINT (-73.9629483374528 40.7936809905265)   19 4 19 13
888 888 -73.9674177504573 40.7769569731993 15G-PM-1019-03 15G PM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9674177504573 40.7769569731993)   19 4 19 13
898 898 -73.9542828053256 40.7941797320355 37G-AM-1014-03 37G AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9542828053256 40.7941797320355)   19 4 19 13
963 963 -73.9621066718851 40.7942427079733 34A-AM-1012-03 34A AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9621066718851 40.7942427079733)   19 4 19 13
1200 1200 -73.9657721715305 40.778534830257 18G-PM-1013-03 18G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9657721715305 40.778534830257)   19 4 19 13
1553 1553 -73.9690645326017 40.7773822116124 15E-AM-1013-03 15E AM 10132018 3 Adult Gray   Gray+   Above Ground 2 on fallen log false false false false false   false false false false true false false true   POINT (-73.9690645326017 40.7773822116124)   19 4 19 13
1657 1657 -73.9768254058709 40.7716757945251 6C-PM-1020-03 06C PM 10202018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9768254058709 40.7716757945251)   19 4 19 13
1658 1658 -73.9736016229655 40.7723781376714 8D-AM-1007-03 08D AM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true ran up tree when approached POINT (-73.9736016229655 40.77237813767141)   19 4 19 13
1678 1678 -73.9568726508546 40.7878795081255 30I-PM-1006-03 30I PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true up tree POINT (-73.9568726508546 40.7878795081255)   19 4 19 13
1824 1824 -73.9617250054003 40.7925390432044 33B-PM-1010-03 33B PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false true false false true   POINT (-73.9617250054003 40.7925390432044)   19 4 19 13
1920 1920 -73.9545383719188 40.7899711263765 33I-PM-1006-03 33I PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.95453837191882 40.7899711263765)   19 4 19 13
1992 1992 -73.9586085843149 40.7946617684536 36C-AM-1014-03 36C AM 10142018 3   Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9586085843149 40.7946617684536)   19 4 19 13
2416 2416 -73.9588689820908 40.7992384137972 40A-PM-1014-03 40A PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran from base of tree into bushes) POINT (-73.9588689820908 40.799238413797205)   19 4 19 13
2422 2422 -73.9683066605832 40.7781213930544 16E-PM-1018-03 16E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9683066605832 40.7781213930544)   19 4 19 13
2534 2534 -73.9744368038675 40.7674281958115 3G-PM-1013-03 03G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false true runs from (climbed tree to run from) POINT (-73.97443680386752 40.7674281958115)   19 4 19 13
2373 2373 -73.9613276802049 40.7943813964442 35B-PM-1013-03 35B PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false true threatened by approaching dog (dog #1) false false false false false false false true runs from (dog) POINT (-73.96132768020492 40.7943813964442)   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 12884.449ms