NOTE: This page is experimental. Bug reports to carter.barry@gmail.com. Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT * FROM metar_now ORDER BY RANDOM() LIMIT 50

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

raw_text station_id observation_time latitude longitude temp_c dewpoint_c wind_dir_degrees wind_speed_kt wind_gust_kt visibility_statute_mi altim_in_hg sea_level_pressure_mb corrected auto auto_station maintenance_indicator_on no_signal lightning_sensor_off freezing_rain_sensor_off present_weather_sensor_off wx_string sky_cover cloud_base_ft_agl flight_category three_hr_pressure_tendency_mb maxT_c minT_c maxT24hr_c minT24hr_c precip_in pcp3hr_in pcp6hr_in pcp24hr_in snow_in vert_vis_ft metar_type elevation_m timestamp
MMAA 260745Z 04005KT 8SM FEW015TCU SCT120 BKN300 27/24 A2991 RMK 8/232 MMAA 2017-06-26T07:45:00Z 16.75 -99.75 27.0 24.0 40 5 8.0 29.911417 VFR METAR 5.0 2017-06-26 08:31:49
CWXC 260800Z AUTO 11002KT 01/01 RMK AO1 SLP105 T00060006 51005 CWXC 2017-06-26T08:00:00Z 48.88 -71.03 0.6 0.6 110 2 1010.5 TRUE TRUE 0.5 METAR 300.0 2017-06-26 08:31:49
KFGX 260815Z AUTO 25003KT 10SM CLR 13/10 A3014 RMK AO2 T01270099 KFGX 2017-06-26T08:15:00Z 38.55 -83.75 12.7 9.9 250 3 10.0 30.138779 TRUE TRUE VFR METAR 278.0 2017-06-26 08:31:49
KLUL 260815Z AUTO 32003KT 18/18 A3014 RMK AO2 T01770177 KLUL 2017-06-26T08:15:00Z 31.67 -89.17 17.7 17.7 320 3 30.138779 TRUE TRUE SPECI 73.0 2017-06-26 08:31:49
EDDN 260820Z 26014KT 9999 SCT040 24/14 Q1014 NOSIG EDDN 2017-06-26T08:20:00Z 49.5 11.08 24.0 14.0 260 14 6.21 29.940945 TRUE VFR METAR 312.0 2017-06-26 08:31:49
EGUW 260750Z 35006KT CAVOK 15/07 Q1015 BLU NOSIG EGUW 2017-06-26T07:50:00Z 52.12 0.97 15.0 7.0 350 6 6.21 29.970472 TRUE VFR METAR 87.0 2017-06-26 08:31:49
KSBS 260814Z AUTO 00000KT 10SM CLR 08/00 A3036 RMK AO1 T00810000 KSBS 2017-06-26T08:14:00Z 40.52 -106.87 8.1 0.0 0 0 10.0 30.360237 TRUE TRUE VFR METAR 2096.0 2017-06-26 08:31:49
KMWA 260815Z AUTO 00000KT 10SM BKN080 17/16 A3020 RMK AO2 KMWA 2017-06-26T08:15:00Z 37.77 -89.02 17.0 16.0 0 0 10.0 30.200787 TRUE TRUE VFR METAR 144.0 2017-06-26 08:31:49
KGZS 260815Z AUTO 00000KT 10SM CLR 13/13 A3018 RMK A01 KGZS 2017-06-26T08:15:00Z 35.15 -87.05 13.0 13.0 0 0 10.0 30.180119 TRUE TRUE VFR SPECI 209.0 2017-06-26 08:31:49
KOTM 260753Z AUTO 26004KT 10SM CLR 10/08 A3017 RMK AO2 SLP215 T01000078 KOTM 2017-06-26T07:53:00Z 41.1 -92.45 10.0 7.8 260 4 10.0 30.171259 1021.5 TRUE TRUE VFR METAR 256.0 2017-06-26 08:31:49
CXFR 260800Z AUTO 10010KT 19/10 RMK AO1 PK WND 12018/0733 T01860103 CXFR 2017-06-26T08:00:00Z 56.08 -118.43 18.6 10.3 100 10 TRUE TRUE METAR 655.0 2017-06-26 08:31:49
KTXK 260753Z AUTO 00000KT 10SM CLR 18/18 A3018 RMK AO2 SLP216 T01830183 KTXK 2017-06-26T07:53:00Z 33.45 -93.98 18.3 18.3 0 0 10.0 30.180119 1021.6 TRUE TRUE VFR METAR 111.0 2017-06-26 08:31:49
KFOZ 260812Z AUTO 00000KT 1 1/4SM BR VV007 04/03 A3013 RMK AO2 KFOZ 2017-06-26T08:12:00Z 47.77 -93.65 4.0 3.0 0 0 1.25 30.129921 TRUE TRUE BR LIFR 700 SPECI 411.0 2017-06-26 08:31:49
KAFO 260815Z AUTO 19010KT 10SM CLR 07/05 A3031 RMK AO2 TSNO KAFO 2017-06-26T08:15:00Z 42.72 -110.95 7.0 5.0 190 10 10.0 30.31004 TRUE TRUE TRUE VFR METAR 1897.0 2017-06-26 08:31:49
CWZO 260800Z AUTO 16007KT RMK AO1 CWZO 2017-06-26T08:00:00Z 48.55 -123.23 160 7 TRUE TRUE METAR 1.0 2017-06-26 08:31:49
PAHX 260756Z AUTO 02003KT 10SM BKN090 16/12 A2970 RMK AO2 SLP060 T01560122 PAHX 2017-06-26T07:56:00Z 62.7 -159.57 15.6 12.2 20 3 10.0 29.698818 1006.0 TRUE TRUE VFR METAR 24.0 2017-06-26 08:31:49
KOWP 260815Z AUTO 07003KT 10SM CLR 21/15 A3020 RMK AO2 T02050154 KOWP 2017-06-26T08:15:00Z 36.18 -96.15 20.5 15.4 70 3 10.0 30.200787 TRUE TRUE VFR METAR 272.0 2017-06-26 08:31:49
SBRB 260800Z 22002KT CAVOK 21/19 Q1012 SBRB 2017-06-26T08:00:00Z -10.0 -67.78 21.0 19.0 220 2 6.21 29.88189 VFR METAR 143.0 2017-06-26 08:31:49
EFOU 260820Z AUTO 30006KT 8000 RA FEW006/// BKN008/// OVC047/// 11/11 Q0988 EFOU 2017-06-26T08:20:00Z 64.92 25.37 11.0 11.0 300 6 4.97 29.17323 TRUE RA IFR METAR 15.0 2017-06-26 08:31:49
KDAA 260758Z AUTO 00000KT 10SM CLR 13/11 A3005 RMK AO2 SLP179 T01320109 KDAA 2017-06-26T07:58:00Z 38.72 -77.17 13.2 10.9 0 0 10.0 30.050198 1017.9 TRUE TRUE VFR METAR 21.0 2017-06-26 08:31:49
CXRH 260800Z AUTO 10005KT 15/ RMK AO1 T0149 CXRH 2017-06-26T08:00:00Z 49.57 -57.88 14.9 100 5 TRUE TRUE METAR 68.0 2017-06-26 08:31:49
CXMD 260800Z AUTO 28006KT 10/05 RMK AO1 SLP232 T01010051 58002 CXMD 2017-06-26T08:00:00Z 49.22 -98.08 10.1 5.1 280 6 1023.2 TRUE TRUE -0.2 METAR 301.0 2017-06-26 08:31:49
KGDJ 260815Z AUTO 11008KT 10SM CLR 24/21 A3015 RMK AO2 T02400205 KGDJ 2017-06-26T08:15:00Z 32.45 -97.82 24.0 20.5 110 8 10.0 30.15059 TRUE TRUE VFR SPECI 237.0 2017-06-26 08:31:49
PAOO 260756Z AUTO 10018KT 10SM -RA BKN034 OVC060 09/08 A2967 RMK AO2 SLP059 P0002 T00940078 PAOO 2017-06-26T07:56:00Z 60.53 -165.12 9.4 7.8 100 18 10.0 29.66929 1005.9 TRUE TRUE -RA VFR 0.02 METAR 18.0 2017-06-26 08:31:49
EFVA 260820Z AUTO 19009KT 9999 BKN021/// BKN049/// OVC100/// 14/08 Q0987 EFVA 2017-06-26T08:20:00Z 63.03 21.77 14.0 8.0 190 9 6.21 29.143702 TRUE MVFR METAR 4.0 2017-06-26 08:31:49
KBIX 260758Z AUTO 04006KT 10SM CLR 22/19 A3009 RMK AO2 SLP192 T02220192 KBIX 2017-06-26T07:58:00Z 30.42 -88.92 22.2 19.2 40 6 10.0 30.088583 1019.2 TRUE TRUE VFR METAR 10.0 2017-06-26 08:31:49
CWBT 260800Z AUTO 00000KT 03/ RMK AO1 SLP055 T0031 53007 CWBT 2017-06-26T08:00:00Z 50.27 -64.23 3.1 0 0 1005.5 TRUE TRUE 0.7 METAR 11.0 2017-06-26 08:31:49
MMTO 260746Z 17008KT 6SM -RA BKN015 OVC070 13/12 A3042 RMK 8/57/ -RAB40 MMTO 2017-06-26T07:46:00Z 19.35 -99.57 13.0 12.0 170 8 6.0 30.41929 -RA MVFR METAR 2576.0 2017-06-26 08:31:49
KSWF 260745Z 26005KT 10SM SKC 14/12 A3001 KSWF 2017-06-26T07:45:00Z 41.5 -74.08 14.0 12.0 260 5 10.0 30.008858 VFR METAR 150.0 2017-06-26 08:31:49
KRYW 260815Z AUTO 18006KT 1 3/4SM +RA BKN003 BKN020 OVC029 22/21 A3015 RMK AO2 P0023 T02210214 KRYW 2017-06-26T08:15:00Z 30.5 -97.97 22.1 21.4 180 6 1.75 30.15059 TRUE TRUE +RA LIFR 0.23 SPECI 376.0 2017-06-26 08:31:49
CYPH 260800Z AUTO 33019G29KT 9SM -RA OVC010 04/03 A2963 RMK SLP036 CYPH 2017-06-26T08:00:00Z 58.45 -78.08 4.0 3.0 330 19 29 9.0 29.630905 1003.6 TRUE -RA MVFR METAR 3.0 2017-06-26 08:31:49
KIMS 260813Z AUTO 00000KT 10SM CLR 13/10 A3017 RMK AO1 KIMS 2017-06-26T08:13:00Z 38.75 -85.47 13.0 10.0 0 0 10.0 30.171259 TRUE TRUE VFR METAR 250.0 2017-06-26 08:31:49
K79J 260756Z AUTO 00000KT 10SM CLR 20/16 A3011 RMK AO2 SLP190 T02000161 K79J 2017-06-26T07:56:00Z 31.32 -86.4 20.0 16.1 0 0 10.0 30.109253 1019.0 TRUE TRUE VFR METAR 94.0 2017-06-26 08:31:49
EIDL 260800Z 11005KT 9999 FEW040 12/11 Q1014 EIDL 2017-06-26T08:00:00Z 55.05 -8.33 12.0 11.0 110 5 6.21 29.940945 VFR METAR 9.0 2017-06-26 08:31:49
KMRY 260754Z 23006KT 10SM CLR 17/12 A3004 RMK AO2 SLP183 T01670117 401830122 KMRY 2017-06-26T07:54:00Z 36.58 -121.85 16.7 11.7 230 6 10.0 30.041338 1018.3 TRUE VFR 18.3 12.2 METAR 66.0 2017-06-26 08:31:49
KIGM 260751Z AUTO 18009KT 10SM CLR 26/01 A3002 RMK AO2 SLP077 T02610011 KIGM 2017-06-26T07:51:00Z 35.25 -113.93 26.1 1.1 180 9 10.0 30.02067 1007.7 TRUE TRUE VFR METAR 1032.0 2017-06-26 08:31:49
ELLX 260820Z 29005KT 240V350 9999 FEW021 20/13 Q1014 NOSIG ELLX 2017-06-26T08:20:00Z 49.63 6.2 20.0 13.0 290 5 6.21 29.940945 TRUE VFR METAR 379.0 2017-06-26 08:31:49
KNQA 260815Z AUTO 00000KT 10SM SCT160 OVC180 18/17 A3016 RMK A01 KNQA 2017-06-26T08:15:00Z 35.35 -89.87 18.0 17.0 0 0 10.0 30.159449 TRUE TRUE VFR SPECI 86.0 2017-06-26 08:31:49
KRQB 260815Z AUTO 27006KT 10SM OVC010 13/11 A2998 RMK AO2 T01250106 KRQB 2017-06-26T08:15:00Z 43.72 -85.5 12.5 10.6 270 6 10.0 29.97933 TRUE TRUE MVFR METAR 302.0 2017-06-26 08:31:49
KD39 260814Z AUTO 30003KT 10SM CLR 07/05 A3019 RMK AO2 T00700052 KD39 2017-06-26T08:14:00Z 45.7 -94.93 7.0 5.2 300 3 10.0 30.188976 TRUE TRUE VFR METAR 380.0 2017-06-26 08:31:49
KSTC 260753Z AUTO 32005KT 10SM CLR 08/06 A3016 RMK AO2 SLP223 T00830061 KSTC 2017-06-26T07:53:00Z 45.55 -94.05 8.3 6.1 320 5 10.0 30.159449 1022.3 TRUE TRUE VFR METAR 314.0 2017-06-26 08:31:49
KVTN 260752Z AUTO 04008KT 10SM CLR 14/04 A3020 RMK AO2 SLP215 T01390044 KVTN 2017-06-26T07:52:00Z 42.87 -100.55 13.9 4.4 40 8 10.0 30.200787 1021.5 TRUE TRUE VFR METAR 788.0 2017-06-26 08:31:49
KGRK 260758Z AUTO 11006KT 10SM SCT022 OVC029 23/22 A3014 RMK AO2 RAB0658E20 OVC V BKN SLP196 P0000 T02280218 $ KGRK 2017-06-26T07:58:00Z 31.07 -97.83 22.8 21.8 110 6 10.0 30.138779 1019.6 TRUE TRUE TRUE MVFR 0.005 METAR 309.0 2017-06-26 08:31:49
ETNH 260820Z 29019KT 9999 FEW035 16/08 Q1009 BLU+BLU+ ETNH 2017-06-26T08:20:00Z 54.32 9.55 16.0 8.0 290 19 6.21 29.793306 VFR METAR 17.0 2017-06-26 08:31:49
KENV 260756Z AUTO 00000KT 10SM 22/01 A3010 RMK AO2 SLP146 T02170006 $ KENV 2017-06-26T07:56:00Z 40.72 -114.02 21.7 0.6 0 0 10.0 30.100393 1014.6 TRUE TRUE TRUE METAR 1292.0 2017-06-26 08:31:49
KLBX 260753Z AUTO 00000KT 9SM -RA FEW120 24/23 A3007 RMK AO2 SLP181 P0003 T02440233 KLBX 2017-06-26T07:53:00Z 29.12 -95.47 24.4 23.3 0 0 9.0 30.070866 1018.1 TRUE TRUE -RA VFR 0.03 METAR 6.0 2017-06-26 08:31:49
KFEP 260815Z AUTO 24004KT 10SM CLR 11/08 A3013 RMK AO2 T01070083 KFEP 2017-06-26T08:15:00Z 42.25 -89.58 10.7 8.3 240 4 10.0 30.129921 TRUE TRUE VFR SPECI 262.0 2017-06-26 08:31:49
KMKG 260755Z AUTO 29013G20KT 10SM FEW019 FEW060 15/11 A3002 RMK AO2 SLP164 T01500111 KMKG 2017-06-26T07:55:00Z 43.17 -86.23 15.0 11.1 290 13 20 10.0 30.02067 1016.4 TRUE TRUE VFR METAR 191.0 2017-06-26 08:31:49
KP28 260756Z AUTO 06004KT 16/12 A3023 RMK AO1 SLP227 T01560122 KP28 2017-06-26T07:56:00Z 37.28 -98.55 15.6 12.2 60 4 30.230314 1022.7 TRUE TRUE METAR 469.0 2017-06-26 08:31:49
KPEZ 260815Z AUTO 06004KT 10SM SCT026 BKN075 23/22 A3011 RMK AO2 T02320222 KPEZ 2017-06-26T08:15:00Z 28.95 -98.52 23.2 22.2 60 4 10.0 30.109253 TRUE TRUE VFR METAR 132.0 2017-06-26 08:31:49

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query