USGS_WC_eartags_output_files_2009-2011-Argos

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

31,089 rows sorted by MsgCount descending

View and edit SQL

Link rowid DeployID Ptt RecordType MsgCount ▲ Duplicates Corrupt AvgInterval MinInterval Date Satellite LocationQuality Latitude Longitude Frequency
7210 21157 96865.0 DS 25.0 0.0 6.0 59.0 59.0 4/12/2010 20:31 P 3 72.52600098 -156.38699340000002 401677495.0
11553 20859 96870.0 DS 25.0 0.0 0.0 62.0 62.0 4/12/2010 20:31 P 2 71.52799988 -155.41999819999998 401677480.0
8583 20994 96867.0 DS 21.0 0.0 0.0 60.0 60.0 4/12/2010 21:17 M 0 73.76200104 -152.45199590000001 401677465.0
4470 20529 93965.0 DS 19.0 0.0 4.0 75.0 63.0 4/12/2010 21:13 M        
4222 20776 93964.0 DS 18.0 0.0 3.0 74.0 62.0 4/12/2010 21:14 M        
5618 21152 96863.0 DS 18.0 0.0 6.0 80.0 58.0 4/12/2010 21:07 N 1 71.05200195 -154.1239929 401677503.0
7213 21157 96865.0 DS 18.0 0.0 0.0 59.0 59.0 4/12/2010 21:08 N 3 72.52799988 -156.3860016 401677496.0
8579 20994 96867.0 DS 18.0 0.0 4.0 68.0 60.0 4/12/2010 20:33 P 1 73.86799622 -152.83999630000002 401677424.0
11550 20859 96870.0 DS 18.0 0.0 0.0 69.0 62.0 4/12/2010 19:22 N        
4466 20529 93965.0 DS 17.0 0.0 5.0 63.0 63.0 4/12/2010 20:27 P        
8577 20994 96867.0 DS 17.0 0.0 0.0 66.0 60.0 4/12/2010 19:39 M 2 73.84500122 -152.8670044 401677468.0
11557 20859 96870.0 DS 17.0 0.0 0.0 77.0 62.0 4/12/2010 21:19 M 0 71.54599762 -155.51899719999997 401677486.0
16 20992 80435.0 DS 16.0 3.0 15.0     3/28/2010 20:26 A 3 71.3239975 -156.6690064 401677431.0
132 20992 80435.0 DS 16.0 0.0 0.0 62.0 56.0 4/12/2010 19:38 M 1 71.65599823 -156.852005 401677441.0
1725 20414 91349.0 DS 16.0 2.0 1.0     7/3/2010 20:18 A 0 70.57499695 -145.71099850000002 401677274.0
3123 20446 93963.0 DS 16.0 3.0 0.0     10/3/2010 20:14 A 1 70.1210022 -145.8809967 401677306.0
6577 20845 96864.0 DS 16.0 0.0 0.0 59.0 59.0 11/11/2009 23:07 P 2 70.49199677 -147.94099430000003 401677474.0
7208 21157 96865.0 DS 16.0 0.0 0.0 66.0 59.0 4/12/2010 19:40 M 3 72.52700043 -156.38800049999998 401677497.0
556 21225 80445.0 DS 15.0 1.0 13.0     8/9/2010 19:05 L 3 70.20099640000001 -148.45199590000001 401677428.0
658 21225 80445.0 DS 15.0 2.0 0.0     3/30/2011 19:55 L 0 71.67400359999999 -157.0509949 401677416.0
1953 20414 91349.0 DS 15.0 1.0 1.0     7/23/2010 20:04 A 1 70.42199707 -146.9259949 401677276.0
2975 20446 93963.0 DS 15.0 0.0 2.0 61.0 61.0 9/20/2010 19:34 P 2 70.14900208 -145.91400149999998 401677295.0
2976 20446 93963.0 DS 15.0 2.0 0.0     9/20/2010 19:40 A 2 70.15000153 -145.9290009 401677295.0
3001 20446 93963.0 DS 15.0 2.0 0.0     9/22/2010 19:31 M 1 70.14700317 -145.9219971 401677292.0
4215 20776 93964.0 DS 15.0 0.0 4.0 79.0 62.0 4/12/2010 19:28 N 1 71.20500183 -157.1970062 401677377.0
4218 20776 93964.0 DS 15.0 0.0 6.0 72.0 62.0 4/12/2010 20:31 P 2 71.21299744 -157.1589966 401677376.0
6336 20845 96864.0 DS 15.0 11.0 0.0     10/5/2009 21:24 M 2 70.20099640000001 -148.451004 401677495.0
6672 20845 96864.0 DS 15.0 0.0 1.0 59.0 59.0 11/25/2009 21:05 A        
7058 21157 96865.0 DS 15.0 3.0 0.0     10/10/2009 21:08 M 2 70.20099640000001 -148.451004 401677510.0
8464 20994 96867.0 DS 15.0 10.0 0.0     10/5/2009 21:26 M 3 70.19999695 -148.4530029 401677475.0
9380 20994 96867.0 DS 15.0 0.0 4.0 64.0 60.0 6/15/2010 18:06 L        
12189 20446 (1) 96872.0 DS 15.0 0.0 0.0 59.0 59.0 10/6/2009 22:35 P 1 70.29399872 -147.81300349999998 401677446.0
12217 20446 (1) 96872.0 DS 15.0 0.0 0.0 59.0 59.0 10/8/2009 22:07 N 0 70.32800293 -148.3320007 401677444.0
13065 20968 96874.0 DS 15.0 0.0 0.0 60.0 60.0 8/25/2009 21:08 A        
17794 20493 96876.0 DS 15.0 0.0 0.0 61.0 61.0 8/23/2009 21:26 M 0 70.81800079 -153.4579926 401677564.0
19755 20550 96878.0 DS 15.0 4.0 0.0     8/3/2009 20:50 M 2 70.50099945 -149.90499880000002 401677523.0
21801 21239 96880.0 DS 15.0 5.0 0.0     8/2/2009 20:44 A        
21802 21239 96880.0 DS 15.0 4.0 0.0     8/2/2009 21:11 M 0 70.51200104 -149.9759979 401677634.0
21805 21239 96880.0 DS 15.0 4.0 0.0     8/2/2009 22:11 N 2 70.4980011 -149.88699340000002 401677630.0
28010 20631 96886.0 DS 15.0 1.0 0.0     8/2/2009 22:31 A 2 70.4960022 -149.88000490000002 401677536.0
28024 20631 96886.0 DS 15.0 6.0 0.0     8/3/2009 22:11 A 3 70.49700165 -149.8820038 401677521.0
29541 21231 96887.0 DS 15.0 9.0 0.0     8/3/2009 23:42 N 3 70.4960022 -149.88900759999999 401677521.0
141 20992 80435.0 DS 14.0 1.0 0.0     4/13/2010 18:53 L        
574 21225 80445.0 DS 14.0 1.0 13.0     3/20/2011 21:22 M 2 71.28600311 -156.7649994 401677426.0
605 21225 80445.0 DS 14.0 1.0 3.0     3/26/2011 19:03 L 1 71.46600342 -156.1569977 401677415.0
609 21225 80445.0 DS 14.0 1.0 0.0     3/26/2011 20:15 A 2 71.48000336 -156.2350006 401677406.0
612 21225 80445.0 DS 14.0 1.0 1.0     3/26/2011 20:44 P 2 71.47799683 -156.2220001 401677406.0
702 21225 80445.0 DS 14.0 1.0 1.0     4/3/2011 19:08 L 2 71.93499756 -157.29499819999998 401677418.0
715 21225 80445.0 DS 14.0 0.0 1.0 58.0 58.0 4/4/2011 18:56 L 3 71.85299683 -158.24499509999998 401677418.0
722 21225 80445.0 DS 14.0 0.0 3.0 58.0 58.0 4/4/2011 20:49 P 1 71.85199738 -158.2389984 401677414.0
1458 20414 91349.0 DS 14.0 0.0 3.0 59.0 59.0 6/10/2010 19:04 N 2 70.36599731 -144.59800719999998 401677335.0
1669 20414 91349.0 DS 14.0 1.0 2.0     6/28/2010 20:22 A 1 70.82499695 -146.8289948 401677315.0
1734 20414 91349.0 DS 14.0 1.0 0.0     7/4/2010 19:36 P 2 70.50700378 -145.4109955 401677326.0
1783 20414 91349.0 DS 14.0 1.0 1.0     7/8/2010 20:14 A 1 70.32900238 -146.0720062 401677318.0
1787 20414 91349.0 DS 14.0 2.0 0.0     7/8/2010 20:47 N 1 70.31999969 -146.128006 401677319.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
2964 20446 93963.0 DS 14.0 1.0 0.0     9/19/2010 20:04 A 2 70.1269989 -145.9360046 401677306.0
2972 20446 93963.0 DS 14.0 1.0 0.0     9/20/2010 19:11 L 2 70.14299774 -145.9120026 401677294.0
2973 20446 93963.0 DS 14.0 1.0 0.0     9/20/2010 19:23 N 3 70.15100098 -145.9109955 401677297.0
2983 20446 93963.0 DS 14.0 1.0 0.0     9/21/2010 18:13 M 2 70.15200043 -145.904007 401677297.0
3067 20446 93963.0 DS 14.0 1.0 0.0     9/28/2010 20:29 M 1 70.1210022 -145.8829956 401677288.0
3078 20446 93963.0 DS 14.0 1.0 0.0     9/29/2010 19:54 A 1 70.13099670000001 -145.91700749999998 401677296.0
3079 20446 93963.0 DS 14.0 2.0 0.0     9/29/2010 20:06 M 0 70.09700012 -145.7440033 401677297.0
3124 20446 93963.0 DS 14.0 2.0 0.0     10/3/2010 20:09 M        
3483 20446 93963.0 DS 14.0 0.0 3.0 61.0 61.0 11/10/2010 20:28 A 2 70.06300354 -145.3959961 401677333.0
3502 20446 93963.0 DS 14.0 1.0 0.0     11/12/2010 18:40 L        
4031 20776 93964.0 DS 14.0 1.0 8.0     3/28/2010 18:48 M 1 71.30699921 -156.7539978 401677228.0
4036 20776 93964.0 DS 14.0 1.0 9.0     3/28/2010 20:27 A 2 71.33000183 -156.6609955 401677323.0
4048 20776 93964.0 DS 14.0 1.0 8.0     3/30/2010 20:01 L 3 70.99900055 -158.45199590000001 401677377.0
4076 20776 93964.0 DS 14.0 1.0 0.0     4/1/2010 20:36 M 1 71.03900146 -157.8179932 401677379.0
5534 21152 96863.0 DS 14.0 1.0 0.0     4/5/2010 21:02 A 1 71.1989975 -154.8379974 401677510.0
5617 21152 96863.0 DS 14.0 0.0 0.0 58.0 58.0 4/12/2010 20:47 L 3 71.08300018 -154.03999330000002 401677520.0
6245 21152 96863.0 DS 14.0 0.0 4.0 63.0 58.0 6/3/2010 18:59 A 1 70.74500275 -149.30200200000002 401677506.0
6365 20845 96864.0 DS 14.0 0.0 0.0 59.0 59.0 10/12/2009 23:05 N 3 69.97100067 -146.28500369999998 401677495.0
6517 20845 96864.0 DS 14.0 0.0 1.0 59.0 59.0 11/3/2009 22:49 P 1 70.23000336 -146.08599850000002 401677486.0
6540 20845 96864.0 DS 14.0 1.0 1.0     11/7/2009 20:44 A 2 70.41799927 -147.7720032 401677476.0
6558 20845 96864.0 DS 14.0 0.0 0.0 59.0 59.0 11/9/2009 21:43 A 2 70.49700165 -147.9559937 401677476.0
6559 20845 96864.0 DS 14.0 0.0 0.0 59.0 59.0 11/9/2009 21:44 P 1 70.5 -147.9459992 401677471.0
6570 20845 96864.0 DS 14.0 0.0 0.0 59.0 59.0 11/11/2009 21:09 N 2 70.4960022 -147.9360046 401677484.0
6576 20845 96864.0 DS 14.0 0.0 1.0 59.0 59.0 11/11/2009 22:49 N 2 70.48699951 -147.9680023 401677476.0
6586 20845 96864.0 DS 14.0 0.0 0.0 59.0 59.0 11/13/2009 21:16 M 1 70.58100128 -149.31300349999998 401677480.0
6661 20845 96864.0 DS 14.0 0.0 0.0 59.0 59.0 11/23/2009 21:53 A 1 70.50499725 -147.9589996 401677489.0
6679 20845 96864.0 DS 14.0 0.0 0.0 59.0 59.0 11/25/2009 22:51 A 1 70.5019989 -148.01400759999999 401677482.0
6685 20845 96864.0 DS 14.0 0.0 0.0 59.0 59.0 11/27/2009 20:21 P 2 70.48699951 -147.6260071 401677477.0
7096 21157 96865.0 DS 14.0 0.0 0.0 59.0 59.0 4/3/2010 19:13 L 0 72.01300049 -156.8280029 401677497.0
7100 21157 96865.0 DS 14.0 0.0 1.0 59.0 59.0 4/3/2010 20:02 A 1 71.9980011 -156.84199519999999 401677500.0
7110 21157 96865.0 DS 14.0 0.0 1.0 59.0 59.0 4/4/2010 19:41 A 1 71.97000122 -156.61999509999998 401677503.0
7127 21157 96865.0 DS 14.0 1.0 0.0     4/5/2010 20:43 M 1 72.03399658 -156.477005 401677489.0
7444 21157 96865.0 DS 14.0 0.0 1.0 59.0 59.0 5/1/2010 20:21 A 3 75.21299744 -161.0039978 401677490.0
8465 20994 96867.0 DS 14.0 7.0 0.0     10/5/2009 22:07 A 3 70.1989975 -148.451004 401677475.0
8500 20994 96867.0 DS 14.0 0.0 0.0 60.0 60.0 4/6/2010 18:39 L 1 71.90499878 -156.397995 401677459.0
8507 20994 96867.0 DS 14.0 1.0 0.0     4/6/2010 20:31 N 2 71.875 -156.18400569999997 401677464.0
8541 20994 96867.0 DS 14.0 1.0 0.0     4/9/2010 19:43 L 1 72.79799652 -155.1410065 401677469.0
8568 20994 96867.0 DS 14.0 1.0 0.0     4/11/2010 20:40 P 2 73.79299927 -155.15800480000001 401677467.0
8622 20994 96867.0 DS 14.0 2.0 1.0     4/16/2010 18:15 L        
8695 20994 96867.0 DS 14.0 1.0 0.0     4/21/2010 21:12 N 2 71.16400146 -150.18699650000002 401677470.0
8716 20994 96867.0 DS 14.0 0.0 2.0 60.0 60.0 4/23/2010 20:16 P 1 71.07700348 -149.298996 401677459.0
8943 20994 96867.0 DS 14.0 1.0 0.0     5/11/2010 20:15 A 2 70.44799805 -144.1529999 401677467.0
8944 20994 96867.0 DS 14.0 0.0 2.0 60.0 60.0 5/11/2010 20:32 P 2 70.44300079 -144.1490021 401677466.0
8964 20994 96867.0 DS 14.0 2.0 0.0     5/13/2010 19:12 M 2 70.45300293 -143.4429932 401677465.0

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