USGS_WC_eartag_deployments_2009-2011

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

5 rows where Sign of Injury at Recapture = "Ear split and healed"

View and edit SQL

Suggested facets: Model, Repetition Rate (sec), Sex, Ear applied

Sign of Injury at Recapture

  • Ear split and healed · 5
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
9 20520 91377 SPOT-227B 60 18 - 21 daily 70.52172394 -142.37863159999998 17Apr2010 04:08 F A Left 04Apr2012 08:43   Ear split and healed
20 20994 96867 SPOT-227B 60 18 - 21 daily 71.94403381 -156.4605957 04Apr2010 07:18 M A Right 28Mar2012 06:40   Ear split and healed
21 21152 96863 SPOT-227B 60 18 - 21 daily 71.38644867 -156.383432 28Mar2010 02:53 F A Left 22Mar2011 07:14   Ear split and healed
23 21219 96869 SPOT-227B 60 18 - 21 daily 70.92181396 -143.02872309999998 18Apr2010 11:13 F A Right 02Apr2011 09:32   Ear split and healed
29 21239 96880 SPOT-227C 90 18 - 21 daily 71.14048614 -153.6722504 30Mar2011 06:04 M A Right 21Mar2012 03:29   Ear split and healed

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.442ms · Data source: USGS Alaska Science Center, Polar Bear Research Program