USGS_WC_eartag_deployments_2009-2011

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

6 rows where Sign of Injury at Recapture = "No"

descending

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	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
4	4	20423	96868	SPOT-227B	60	18 - 21	daily	70.40882874	-144.04338069999997	11Apr2010 05:31	F	A	Left	11Apr2014 11:30		No
6	6	20446	96872	SPOT-227B	60	20 - 23	daily	70.31179809999999	-147.8790131	04Oct2009 05:18	F	A	Right	15Sep2010 02:48		No
13	13	20735	96871	SPOT-227B	60	20 - 23	daily	70.14492035	-143.5785065	29Aug2009 04:28	F	A	Right	18Oct2009 05:58		No
15	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
28	28	21232	96884	SPOT-227C	90	18 - 21	daily	71.03843994	-153.1465851	24Mar2011 08:48	M	S	Left		15Mar2012	No

Advanced export

JSON shape: default, array, newline-delimited

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");