USGS_WC_eartag_deployments_2009-2011

Data source: USGS Alaska Science Center, Polar Bear Research Program

3 rows where Transmit days = "every 2nd day"

View and edit SQL

Suggested facets: Age Class, Ear applied

Link rowid ▼ BearID PTT_ID Model Repetition Rate (sec) Transmit hours (GMT) Transmit days Capture Latitude Capture Longitude Apply DateTime (GMT, 24-hour clock) Sex Age Class Ear applied Recapture DateTime (GMT, 24-hour clock) Harvest Date Sign of Injury at Recapture
3 20414 96866 SPOT-227B 60 20 - 23 every 2nd day 70.88489075 -152.7988892 10Oct2009 03:28 F A Left 13Apr2010 04:34   No
15 20845 96864 SPOT-227B 60 20 - 23 every 2nd day 69.92344818 -144.81686399999998 09Oct2009 02:26 F A Right 09Apr2014 08:35   No
18 20977 96873 SPOT-227B 60 20 - 23 every 2nd day 70.21342926 -147.25659480000002 06Oct2009 02:27 F S Right      

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "USGS_WC_eartag_deployments_2009-2011" (
"BearID" INTEGER,
  "PTT_ID" INTEGER,
  "Model" TEXT,
  "Repetition Rate (sec)" INTEGER,
  "Transmit hours (GMT)" TEXT,
  "Transmit days" TEXT,
  "Capture Latitude" REAL,
  "Capture Longitude" REAL,
  "Apply DateTime (GMT, 24-hour clock)" TEXT,
  "Sex" TEXT,
  "Age Class" TEXT,
  "Ear applied" TEXT,
  "Recapture DateTime (GMT, 24-hour clock)" TEXT,
  "Harvest Date" TEXT,
  "Sign of Injury at Recapture" TEXT
);
CREATE INDEX "ix_USGS_WC_eartag_deployments_2009-2011_BearID"ON "USGS_WC_eartag_deployments_2009-2011" ("BearID");
Powered by Datasette · Query took 15.636ms · Data source: USGS Alaska Science Center, Polar Bear Research Program