USGS_WC_eartags_output_files_2009-2011-Argos

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

31,089 rows sorted by AvgInterval

View and edit SQL

Link rowid DeployID Ptt RecordType MsgCount Duplicates Corrupt AvgInterval ▼ MinInterval Date Satellite LocationQuality Latitude Longitude Frequency
2062 20414 91349.0 DS 10.0 1.0 1.0     8/2/2010 19:23 M 2 70.43299866 -145.121994 401677327.0
2085 20414 91349.0 DS 1.0 0.0 0.0     8/4/2010 20:21 M        
2087 20414 91349.0 DS 1.0 0.0 0.0     8/4/2010 20:54 N        
2093 20414 91349.0 DS 13.0 1.0 1.0     8/5/2010 19:53 M 1 70.58899689 -144.348999 401677330.0
2098 20414 91349.0 DS 1.0 0.0 0.0     8/6/2010 19:18 K        
2112 20414 91349.0 DS 1.0 0.0 0.0     8/7/2010 20:32 K        
2117 20414 91349.0 DS 1.0 0.0 1.0     8/8/2010 18:38 N        
2128 20414 91349.0 DS 1.0 0.0 0.0     8/9/2010 18:25 N        
2143 20414 91349.0 DS 1.0 0.0 0.0     8/10/2010 19:22 K        
2149 20414 91349.0 DS 1.0 0.0 0.0     8/10/2010 20:59 K        
2153 20414 91349.0 DS 8.0 1.0 1.0     8/11/2010 18:36 L        
2174 20414 91349.0 DS 13.0 2.0 0.0     8/13/2010 18:19 L 2 70.78199768 -148.8470001 401677322.0
2197 20414 91349.0 DS 1.0 0.0 0.0     8/15/2010 18:02 L        
2201 20414 91349.0 DS 1.0 0.0 0.0     8/15/2010 19:06 N        
2210 20414 91349.0 DS 1.0 0.0 0.0     8/16/2010 18:28 A        
2222                            
2223 20520 91377.0 DS 9.0 8.0 9.0     4/13/2009 21:29 N        
2225 20520 91377.0 DS 5.0 1.0 5.0     4/13/2009 23:35 L 3 33.38399887 -111.8119965 401662833.0
2226 20520 91377.0 DS 8.0 4.0 8.0     4/14/2009 0:18 K 3 33.38499832 -111.8090057 401662835.0
2227 20520 91377.0 DS 5.0 4.0 5.0     4/14/2009 21:12 N 3 33.38399887 -111.81100459999999 401662864.0
2228 20520 91377.0 DS 6.0 3.0 6.0     4/14/2009 23:54 K        
2229 20520 91377.0 DS 7.0 6.0 7.0     4/24/2009 21:37 L 0 70.26599884 -148.4570007 401662810.0
2230 20520 91377.0 DS 8.0 7.0 8.0     4/24/2009 21:47 K 0 70.23799896 -148.4250031 401662771.0
2231 20520 91377.0 DS 9.0 8.0 9.0     4/24/2009 21:48 M        
2232 20520 91377.0 DS 10.0 9.0 10.0     4/24/2009 22:01 A 0 70.21600342 -148.49099730000003 401662748.0
2233 20520 91377.0 DS 11.0 7.0 11.0     4/24/2009 22:59 N 3 70.1989975 -148.44799809999998 401662731.0
2234 20520 91377.0 DS 8.0 3.0 8.0     4/24/2009 23:17 L 3 70.1989975 -148.451004 401662732.0
2235 20520 91377.0 DS 8.0 4.0 8.0     4/24/2009 23:22 M 3 70.19999695 -148.451004 401662731.0
2236 20520 91377.0 DS 7.0 1.0 7.0     4/24/2009 23:24 K 3 70.19799805 -148.44799809999998 401662733.0
2237 20520 91377.0 DS 9.0 5.0 9.0     4/24/2009 23:40 A 3 70.19999695 -148.44799809999998 401662732.0
2238 20520 91377.0 DS 9.0 5.0 9.0     4/25/2009 0:42 N 3 70.19999695 -148.4400024 401662733.0
2239 20520 91377.0 DS 9.0 5.0 9.0     4/25/2009 0:55 L 3 70.1989975 -148.4530029 401662736.0
2240 20520 91377.0 DS 6.0 1.0 6.0     4/25/2009 1:00 M 3 70.19799805 -148.44799809999998 401662736.0
2241 20520 91377.0 DS 11.0 7.0 11.0     4/25/2009 1:08 K        
2242 20520 91377.0 DS 7.0 3.0 7.0     4/25/2009 1:19 A 2 70.20200348 -148.4459992 401662736.0
2243 20520 91377.0 DS 1.0 0.0 1.0     4/25/2009 18:00 M        
2244 20520 91377.0 DS 6.0 5.0 6.0     4/25/2009 18:05 L 1 70.20300293 -148.4570007 401662761.0
2245 20520 91377.0 DS 5.0 4.0 5.0     4/25/2009 18:06 K 2 70.20099640000001 -148.4539948 401662760.0
2246 20520 91377.0 DS 3.0 2.0 3.0     4/25/2009 18:20 A A 70.19499969 -148.45199590000001 401662754.0
2247 20520 91377.0 DS 5.0 4.0 5.0     4/25/2009 19:29 N 3 70.20099640000001 -148.449997 401662751.0
2248 20520 91377.0 DS 5.0 3.0 5.0     4/25/2009 19:38 M 3 70.19999695 -148.449997 401662751.0
2249 20520 91377.0 DS 5.0 4.0 5.0     4/25/2009 19:43 K 3 70.1989975 -148.44799809999998 401662751.0
2250 20520 91377.0 DS 4.0 3.0 4.0     4/25/2009 19:46 L 2 70.19999695 -148.4459992 401662752.0
2251 20520 91377.0 DS 5.0 4.0 5.0     4/25/2009 20:01 A 2 70.1989975 -148.4559937 401662750.0
2252 20520 91377.0 DS 6.0 5.0 6.0     4/25/2009 21:07 N 1 70.20099640000001 -148.44200130000002 401662752.0
2253 20520 91377.0 DS 5.0 4.0 5.0     4/25/2009 21:20 M 1 70.1989975 -148.44099430000003 401662751.0
2254 20520 91377.0 DS 4.0 2.0 4.0     4/25/2009 21:21 K 3 70.1989975 -148.4539948 401662750.0
2255 20520 91377.0 DS 3.0 2.0 3.0     4/25/2009 21:22 L A 70.19799805 -148.4530029 401662751.0
2256 20520 91377.0 DS 7.0 6.0 7.0     4/25/2009 21:40 A 2 70.1989975 -148.44200130000002 401662751.0
2257 20520 91377.0 DS 8.0 7.0 8.0     4/29/2009 4:24 M 3 70.52600098 -148.02999880000002 401662737.0
2258 20520 91377.0 DS 3.0 2.0 3.0     4/29/2009 4:31 K A 70.52500153 -148.03900149999998 401662737.0
2259 20520 91377.0 DS 8.0 4.0 8.0     4/29/2009 4:55 A 2 70.52500153 -148.03999330000002 401662745.0
2261 20520 91377.0 DS 8.0 4.0 8.0     4/29/2009 6:03 M 2 70.52400208 -148.0370026 401662743.0
2262 20520 91377.0 DS 5.0 1.0 5.0     4/29/2009 6:35 A 1 70.52799988 -148.0079956 401662753.0
2263 20520 91377.0 DS 2.0 1.0 2.0     4/29/2009 18:01 M B 70.51999664 -148.0200043 401662750.0
2264 20520 91377.0 DS 4.0 3.0 4.0     4/29/2009 18:08 K 2 70.52799988 -148.03300480000001 401662738.0
2265 20520 91377.0 DS 5.0 2.0 5.0     4/29/2009 18:34 A 2 70.52500153 -148.0319977 401662749.0
2266 20520 91377.0 DS 4.0 1.0 4.0     4/29/2009 18:46 N 3 70.51999664 -148.029007 401662750.0
2268 20520 91377.0 DS 3.0 2.0 3.0     4/29/2009 19:43 M A 70.52799988 -148.0079956 401662772.0
2269 20520 91377.0 DS 4.0 2.0 4.0     4/29/2009 19:46 K 1 70.53099823 -148.0149994 401662769.0
2270 20520 91377.0 DS 6.0 5.0 6.0     4/29/2009 20:16 A 1 70.52700043 -148.05799869999998 401662776.0
2271 20520 91377.0 DS 5.0 3.0 5.0     4/29/2009 20:26 N 1 70.51899719 -148.0410004 401662782.0
2273 20520 91377.0 DS 4.0 2.0 4.0     4/29/2009 21:25 K 2 70.52799988 -148.04200749999998 401662794.0
2274 20520 91377.0 DS 4.0 3.0 4.0     4/29/2009 21:24 M        
2275 20520 91377.0 DS 4.0 3.0 4.0     4/29/2009 21:55 A 3 70.51799774 -148.0149994 401662788.0
2283 20520 91377.0 DS 1.0 0.0 1.0     4/30/2009 20:24 L        
2287 20520 91377.0 DS 4.0 1.0 1.0     12/9/2009 2:26 M 0 47.67200089 -122.128006 401677316.0
2288 20520 91377.0 DS 1.0 0.0 0.0     12/9/2009 2:36 A        
2289 20520 91377.0 DS 10.0 6.0 0.0     12/9/2009 2:52 L 3 47.67699814 -122.1349945 401677314.0
2290 20520 91377.0 DS 11.0 7.0 0.0     12/9/2009 4:03 M        
2291 20520 91377.0 DS 10.0 6.0 0.0     12/9/2009 4:11 A 3 47.67699814 -122.13600159999999 401677317.0
2292 20520 91377.0 DS 9.0 6.0 0.0     12/9/2009 5:44 M 3 47.6780014 -122.1349945 401677319.0
2293 20520 91377.0 DS 12.0 9.0 0.0     12/9/2009 5:53 A 3 47.67699814 -122.1349945 401677319.0
2294 20520 91377.0 DS 1.0 0.0 1.0     4/11/2010 18:03 N        
2307 20520 91377.0 DS 1.0 0.0 1.0     4/17/2010 21:59 N        
2331 20520 91377.0 DS 1.0 0.0 0.0     4/20/2010 18:01 N        
2413 20520 91377.0 DS 11.0 1.0 2.0     4/26/2010 20:24 A 1 70.14299774 -141.7660065 401677313.0
2414 20520 91377.0 DS 14.0 1.0 0.0     4/26/2010 20:50 M 1 70.14900208 -141.7510071 401677313.0
2441 20520 91377.0 DS 1.0 0.0 0.0     4/28/2010 21:19 A        
2454 20520 91377.0 DS 1.0 0.0 0.0     4/30/2010 18:01 N        
2471 20520 91377.0 DS 1.0 0.0 1.0     5/1/2010 20:34 P        
2481 20520 91377.0 DS 13.0 1.0 0.0     5/2/2010 20:06 M        
2491 20520 91377.0 DS 1.0 0.0 0.0     5/3/2010 19:47 M        
2501 20520 91377.0 DS 11.0 1.0 0.0     5/4/2010 19:20 A 1 70.34300232 -143.0970001 401677304.0
2508 20520 91377.0 DS 10.0 1.0 0.0     5/4/2010 21:05 M 0 70.30999756 -143.125 401677313.0
2509 20520 91377.0 DS 1.0 0.0 0.0     5/5/2010 18:46 N        
2526 20520 91377.0 DS 1.0 0.0 1.0     5/7/2010 18:17 A        
2528 20520 91377.0 DS 1.0 0.0 1.0     5/7/2010 19:01 K        
2529 20520 91377.0 DS 1.0 0.0 0.0     5/7/2010 19:34 P        
2536 20520 91377.0 DS 1.0 0.0 0.0     5/8/2010 18:02 A        
2543 20520 91377.0 DS 1.0 0.0 0.0     5/8/2010 19:52 N        
2552 20520 91377.0 DS 9.0 1.0 1.0     5/9/2010 19:08 M 0 70.45800018 -143.36300659999998 401677315.0
2573 20520 91377.0 DS 1.0 0.0 0.0     5/10/2010 21:11 K        
2586 20520 91377.0 DS 1.0 0.0 1.0     5/12/2010 18:02 M        
2593 20520 91377.0 DS 10.0 1.0 0.0     5/12/2010 19:54 A 1 70.40599823 -143.16400149999998 401677291.0
2599 20520 91377.0 DS 1.0 0.0 1.0     5/13/2010 18:06 L        
2632 20520 91377.0 DS 1.0 0.0 0.0     5/16/2010 18:30 N        
2633 20520 91377.0 DS 1.0 0.0 1.0     5/16/2010 18:32 A        
2651 20520 91377.0 DS 1.0 0.0 1.0     5/17/2010 21:25 A        
2664 20520 91377.0 DS 1.0 0.0 0.0     5/18/2010 21:14 K        

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