USGS_WC_eartags_output_files_2009-2011-Argos

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

31,089 rows sorted by Longitude

View and edit SQL

Link rowid DeployID Ptt RecordType MsgCount Duplicates Corrupt AvgInterval MinInterval Date Satellite LocationQuality Latitude Longitude ▼ Frequency
4164 20776 93964.0 DS 11.0 0.0 2.0 62.0 62.0 4/8/2010 19:28 M        
4196 20776 93964.0 DS 3.0 0.0 1.0 62.0 62.0 4/10/2010 21:24 N        
4198 20776 93964.0 DS 1.0 0.0 1.0     4/11/2010 18:02 N        
4214 20776 93964.0 DS 10.0 0.0 2.0 68.0 62.0 4/12/2010 19:02 L        
4222 20776 93964.0 DS 18.0 0.0 3.0 74.0 62.0 4/12/2010 21:14 M        
4235 20776 93964.0 DS 1.0 0.0 1.0     4/13/2010 21:29 A        
4250 20776 93964.0 DS 9.0 0.0 1.0 77.0 62.0 4/15/2010 18:27 L        
4302 20776 93964.0 DS 1.0 0.0 0.0     4/19/2010 18:03 K        
4319 20776 93964.0 DS 6.0 0.0 0.0 86.0 62.0 4/20/2010 19:07 A        
4329 20776 93964.0 DS 6.0 0.0 0.0 86.0 62.0 4/21/2010 19:01 L        
4335 20776 93964.0 DS 7.0 0.0 0.0 72.0 62.0 4/21/2010 21:09 M        
4336 20776 93964.0 DS 7.0 0.0 0.0 72.0 62.0 4/22/2010 18:20 K        
4338 20776 93964.0 DS 13.0 0.0 0.0 72.0 62.0 4/22/2010 18:43 L        
4361 20776 93964.0 DS 5.0 0.0 0.0 62.0 62.0 4/23/2010 21:23 A        
4362                            
4363 20529 93965.0 DS 3.0 2.0 3.0     12/9/2009 2:25 M        
4365 20529 93965.0 DS 1.0 0.0 1.0     12/9/2009 3:59 M        
4393 20529 93965.0 DS 1.0 0.0 0.0     4/6/2010 21:27 P        
4398 20529 93965.0 DS 1.0 0.0 0.0     4/7/2010 18:43 N        
4419 20529 93965.0 DS 1.0 0.0 0.0     4/8/2010 21:30 L        
4445 20529 93965.0 DS 1.0 0.0 0.0     4/10/2010 21:29 N        
4446 20529 93965.0 DS 1.0 0.0 0.0     4/11/2010 18:03 N        
4462 20529 93965.0 DS 11.0 1.0 1.0     4/12/2010 19:03 L        
4466 20529 93965.0 DS 17.0 0.0 5.0 63.0 63.0 4/12/2010 20:27 P        
4470 20529 93965.0 DS 19.0 0.0 4.0 75.0 63.0 4/12/2010 21:13 M        
4474 20529 93965.0 DS 11.0 0.0 0.0 75.0 63.0 4/13/2010 18:51 L        
4475 20529 93965.0 DS 11.0 0.0 0.0 75.0 63.0 4/13/2010 19:08 M        
4483 20529 93965.0 DS 1.0 0.0 1.0     4/13/2010 21:30 A        
4486 20529 93965.0 DS 5.0 0.0 0.0 94.0 63.0 4/14/2010 18:41 L        
4513 20529 93965.0 DS 3.0 0.0 1.0 157.0 126.0 4/16/2010 18:46 A        
4549 20529 93965.0 DS 3.0 0.0 0.0 63.0 63.0 4/18/2010 21:28 A        
4563 20529 93965.0 DS 3.0 0.0 0.0 63.0 63.0 4/19/2010 21:28 N        
4564 20529 93965.0 DS 1.0 0.0 0.0     4/20/2010 18:07 N        
4565 20529 93965.0 DS 1.0 0.0 1.0     4/20/2010 18:13 M        
4568 20529 93965.0 DS 9.0 0.0 0.0 63.0 62.0 4/20/2010 19:13 L        
4580 20529 93965.0 DS 8.0 0.0 0.0 99.0 63.0 4/21/2010 18:57 L        
4587 20529 93965.0 DS 11.0 0.0 1.0 63.0 63.0 4/21/2010 21:06 M        
4589 20529 93965.0 DS 7.0 0.0 0.0 63.0 63.0 4/22/2010 18:19 K        
4592 20529 93965.0 DS 10.0 0.0 1.0 77.0 63.0 4/22/2010 18:44 L        
4639 20529 93965.0 DS 1.0 0.0 0.0     4/25/2010 21:30 L        
4648 20529 93965.0 DS 2.0 0.0 0.0 189.0 189.0 4/26/2010 20:09 K        
4654 20529 93965.0 DS 1.0 0.0 0.0     4/27/2010 18:01 P        
4656 20529 93965.0 DS 5.0 0.0 1.0 63.0 63.0 4/27/2010 18:19 A        
4672 20529 93965.0 DS 8.0 0.0 4.0 99.0 63.0 4/28/2010 19:16 L        
4675 20529 93965.0 DS 1.0 0.0 1.0     4/28/2010 20:02 N        
4684 20529 93965.0 DS 12.0 0.0 2.0 74.0 63.0 4/29/2010 19:01 L        
4693 20529 93965.0 DS 8.0 0.0 1.0 72.0 63.0 4/29/2010 21:20 M        
4700 20529 93965.0 DS 7.0 0.0 1.0 94.0 63.0 4/30/2010 19:15 M        
4701 20529 93965.0 DS 1.0 0.0 0.0     4/30/2010 19:37 N        
4744 20529 93965.0 DS 1.0 0.0 0.0     5/3/2010 20:50 N        
4748 20529 93965.0 DS 1.0 0.0 0.0     5/4/2010 18:25 P        
4759 20529 93965.0 DS 1.0 0.0 0.0     5/5/2010 18:03 L        
4775 20529 93965.0 DS 5.0 0.0 1.0 78.0 63.0 5/6/2010 19:27 L        
4779 20529 93965.0 DS 8.0 0.0 1.0 63.0 63.0 5/6/2010 20:17 A        
4795 20529 93965.0 DS 1.0 0.0 0.0     5/7/2010 21:31 M        
4830 20529 93965.0 DS 2.0 0.0 0.0 63.0 63.0 5/10/2010 21:13 K        
4834 20529 93965.0 DS 1.0 0.0 1.0     5/11/2010 18:32 A        
4837 20529 93965.0 DS 2.0 0.0 0.0 126.0 126.0 5/11/2010 19:22 N        
4854 20529 93965.0 DS 1.0 0.0 0.0     5/12/2010 20:52 N        
4869 20529 93965.0 DS 1.0 0.0 0.0     5/14/2010 18:02 K        
4870 20529 93965.0 DS 1.0 0.0 0.0     5/14/2010 18:28 P        
4871 20529 93965.0 DS 6.0 0.0 0.0 75.0 63.0 5/14/2010 18:47 M        
4896 20529 93965.0 DS 1.0 0.0 1.0     5/16/2010 18:28 A        
4906 20529 93965.0 DS 10.0 0.0 0.0 63.0 63.0 5/16/2010 21:20 M        
4955 20529 93965.0 DS 7.0 0.0 1.0 63.0 63.0 5/20/2010 20:38 P        
4957 20529 93965.0 DS 2.0 0.0 1.0 315.0 315.0 5/20/2010 21:26 M        
4971 20529 93965.0 DS 1.0 0.0 0.0     5/22/2010 18:02 L        
4974 20529 93965.0 DS 5.0 0.0 1.0 63.0 63.0 5/22/2010 18:38 P        
4990 20529 93965.0 DS 10.0 0.0 0.0 70.0 63.0 5/23/2010 19:21 L        
5003 20529 93965.0 DS 8.0 0.0 2.0 81.0 63.0 5/24/2010 19:08 L        
5004 20529 93965.0 DS 7.0 0.0 1.0 94.0 63.0 5/24/2010 19:55 P        
5028 20529 93965.0 DS 6.0 0.0 2.0 114.0 63.0 5/26/2010 19:34 P        
5036 20529 93965.0 DS 1.0 0.0 0.0     5/27/2010 18:06 A        
5046 20529 93965.0 DS 1.0 0.0 0.0     5/27/2010 21:02 K        
5054 20529 93965.0 DS 8.0 0.0 0.0 72.0 63.0 5/28/2010 19:15 P        
5065 20529 93965.0 DS 2.0 0.0 0.0 378.0 378.0 5/29/2010 18:57 A        
5074 20529 93965.0 DS 13.0 1.0 1.0     5/29/2010 21:16 M        
5075 20529 93965.0 DS 1.0 0.0 1.0     5/29/2010 21:31 L        
5085 20529 93965.0 DS 4.0 0.0 1.0 189.0 63.0 5/30/2010 20:33 P        
5086 20529 93965.0 DS 8.0 0.0 1.0 117.0 63.0 5/30/2010 20:52 M        
5092 20529 93965.0 DS 1.0 0.0 0.0     5/31/2010 18:56 M        
5096 20529 93965.0 DS 9.0 0.0 0.0 70.0 63.0 5/31/2010 20:32 M        
5097 20529 93965.0 DS 1.0 0.0 0.0     5/31/2010 20:45 N        
5104 20529 93965.0 DS 9.0 0.0 0.0 94.0 63.0 6/1/2010 19:15 L        
5116 20529 93965.0 DS 7.0 0.0 0.0 94.0 63.0 6/2/2010 19:03 L        
5125 20529 93965.0 DS 7.0 0.0 0.0 94.0 63.0 6/3/2010 18:11 K        
5128 20529 93965.0 DS 7.0 0.0 1.0 115.0 63.0 6/3/2010 18:51 L        
5156 20529 93965.0 DS 1.0 0.0 0.0     6/5/2010 19:57 A        
5157 20529 93965.0 DS 3.0 0.0 1.0 94.0 63.0 6/5/2010 19:59 N        
5162 20529 93965.0 DS 1.0 0.0 1.0     6/6/2010 18:13 M        
5170 20529 93965.0 DS 6.0 0.0 0.0 63.0 63.0 6/6/2010 21:05 P        
5187 20529 93965.0 DS 9.0 0.0 2.0 70.0 63.0 6/8/2010 19:03 P        
5201 20529 93965.0 DS 2.0 0.0 1.0 252.0 252.0 6/9/2010 19:07 K        
5202 20529 93965.0 DS 1.0 0.0 0.0     6/9/2010 19:24 L        
5203 20529 93965.0 DS 1.0 0.0 0.0     6/9/2010 20:18 A        
5204 20529 93965.0 DS 1.0 0.0 0.0     6/9/2010 20:24 M        
5205 20529 93965.0 DS 1.0 0.0 0.0     6/9/2010 20:58 N        
5206 20529 93965.0 DS 1.0 0.0 1.0     6/9/2010 21:06 L        
5219 20529 93965.0 DS 4.0 0.0 1.0 63.0 63.0 6/10/2010 21:28 A        
5223 20529 93965.0 DS 9.0 0.0 2.0 78.0 63.0 6/11/2010 18:56 L        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "USGS_WC_eartags_output_files_2009-2011-Argos" (
"DeployID" TEXT,
  "Ptt" REAL,
  "RecordType" TEXT,
  "MsgCount" REAL,
  "Duplicates" REAL,
  "Corrupt" REAL,
  "AvgInterval" REAL,
  "MinInterval" REAL,
  "Date" TEXT,
  "Satellite" TEXT,
  "LocationQuality" TEXT,
  "Latitude" REAL,
  "Longitude" REAL,
  "Frequency" REAL
);
CREATE INDEX "ix_USGS_WC_eartags_output_files_2009-2011-Argos_DeployID"ON "USGS_WC_eartags_output_files_2009-2011-Argos" ("DeployID");
Powered by Datasette · Query took 94.838ms · Data source: USGS Alaska Science Center, Polar Bear Research Program