squirrels

14 rows where Approaches = "true", Climbing = "false" and Date = 10182018

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Running, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Indifferent, 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
266 266 -73.9786481009499 40.7697372811949 4B-PM-1018-03 04B PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786481009499 40.7697372811949)   19 4 19 13
320 320 -73.9684376038582 40.7824275067237 20C-PM-1018-09 20C PM 10182018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false true false false   POINT (-73.9684376038582 40.7824275067237)   19 4 19 13
579 579 -73.9786714207307 40.7696870806229 4B-PM-1018-01 04B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786714207307 40.7696870806229)   19 4 19 13
882 882 -73.9786805884996 40.7697559231927 4B-PM-1018-02 04B PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786805884996 40.7697559231927)   19 4 19 13
913 913 -73.9514111329059 40.7975085872897 42G-AM-1018-01 42G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false true   POINT (-73.9514111329059 40.797508587289705)   19 4 19 13
1111 1111 -73.9632799339872 40.7808316436308 21H-PM-1018-01 21H PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false staring false false false false true true false false   POINT (-73.9632799339872 40.7808316436308)   19 4 19 13
1174 1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false staring false false false true false true false false approaches (very close) POINT (-73.9682067129876 40.7779911208015)   19 4 19 13
1270 1270 -73.967762162893 40.7823359027165 20C-PM-1018-08 20C PM 10182018 8 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false false   false false false false false true false true runs from (dog) POINT (-73.967762162893 40.7823359027165)   19 4 19 13
1312 1312 -73.9712034320741 40.7764415506669 13D-PM-1018-05 13D PM 10182018 5 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 false true   false false false false true true true false   POINT (-73.9712034320741 40.7764415506669)   19 4 19 13
1704 1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9624052832372 40.7809656348254)   19 4 19 13
1725 1725 -73.9657480066074 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9657480066074 40.7753465489231)   19 4 19 13
2170 2170 -73.9678923667678 40.7819675626236 20C-PM-1018-05 20C PM 10182018 5 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9678923667678 40.781967562623606)   19 4 19 13
2703 2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9690174442945 40.7817617696508)   19 4 19 13
2772 2772 -73.9677368646039 40.7821550964837 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.96773686460392 40.782155096483706)   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 58.657ms