squirrels

15 rows where Community Districts = 19, Eating = "true", Hectare Squirrel Number = 7 and Indifferent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Foraging, Other Activities, Tail twitches, Approaches, Runs from, Other Interactions

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
722 722 -73.9745953710328 40.7728284025195 8D-AM-1007-07 08D AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9745953710328 40.7728284025195)   19 4 19 13
980 980 -73.9709817796369 40.7773554311586 14D-PM-1019-07 14D PM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9709817796369 40.7773554311586)   19 4 19 13
1080 1080 -73.9690211935346 40.773038298158 11H-AM-1010-07 11H AM 10102018 7 Adult Gray White Gray+White   Above Ground 4   false false false true false   false false false false false false false true   POINT (-73.9690211935346 40.773038298158)   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
1361 1361 -73.961934398055 40.7924789548522 33B-PM-1010-07 33B PM 10102018 7 Adult     +   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.961934398055 40.7924789548522)   19 4 19 13
1388 1388 -73.9685709455958 40.7744877026506 12G-PM-1007-07 12G PM 10072018 7 Juvenile     +   Above Ground 45   false false false true false acorns false false false false false false false false   POINT (-73.9685709455958 40.7744877026506)   19 4 19 13
1614 1614 -73.9806718258385 40.7692776896995 2A-AM-1010-07 02A AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false false false couldn't get near POINT (-73.9806718258385 40.76927768969951)   19 4 19 13
1814 1814 -73.9722359401242 40.7702891474555 7G-AM-1010-07 07G AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9722359401242 40.7702891474555)   19 4 19 13
2066 2066 -73.9784610031588 40.7668839966177 1D-AM-1006-07 01D AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9784610031588 40.7668839966177)   19 4 19 13
2100 2100 -73.9638312025305 40.7903826659569 30B-AM-1007-07 30B AM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9638312025305 40.7903826659569)   19 4 19 13
2165 2165 -73.9794371709817 40.768387910254 2B-PM-1013-07 02B PM 10132018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9794371709817 40.768387910254)   19 4 19 13
2339 2339 -73.9695117797648 40.7802675743233 18C-PM-1018-07 18C PM 10182018 7   Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9695117797648 40.780267574323304)   19 4 19 13
2707 2707 -73.9743165321099 40.7754674678574 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   true false false true true   false false false false false false false false   POINT (-73.9743165321099 40.7754674678574)   19 4 19 13
2825 2825 -73.9643507588008 40.7904324693292 30B-PM-1019-07 30B PM 10192018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.96435075880082 40.7904324693292)   19 4 19 13
2879 2879 -73.9744080700098 40.7731515721826 9C-PM-1006-07 09C PM 10062018 7 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE on top of tarped sand pile false false false true false   false false false false false false false true (me) POINT (-73.9744080700098 40.7731515721826)   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 85.059ms