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
KHQU 260955Z AUTO 00000KT 10SM CLR 05/M02 A3013 RMK AO1 T00451025 KHQU 2017-02-26T09:55:00Z 33.53 -82.52 4.5 -2.5 0 0 10.0 30.129921 TRUE TRUE VFR METAR 152.0 2017-02-26 10:25:57
RJOC 261000Z 06009KT 9999 -SHRA FEW020 SCT030 BKN040 08/04 Q1023 RJOC 2017-02-26T10:00:00Z 35.42 132.87 8.0 4.0 60 9 6.21 30.206694 -SHRA VFR METAR 5.0 2017-02-26 10:25:57
RJKA 261000Z 01014KT 4500 -SHRA BR FEW015 BKN020 BKN030 13/11 Q1020 RJKA 2017-02-26T10:00:00Z 28.42 129.72 13.0 11.0 10 14 2.8 30.11811 -SHRA BR IFR METAR 7.0 2017-02-26 10:25:57
FTTA 261000Z 10010KT CAVOK 34/02 Q1013 FTTA 2017-02-26T10:00:00Z 9.15 18.37 34.0 2.0 100 10 6.21 29.911417 VFR METAR 365.0 2017-02-26 10:25:57
KCDA 260955Z AUTO 25010G14KT 7SM -SN SCT016 BKN048 OVC060 M01/M04 A2957 RMK AO2 T10121038 KCDA 2017-02-26T09:55:00Z 44.57 -72.02 -1.2 -3.8 250 10 14 7.0 29.568897 TRUE TRUE -SN VFR METAR 363.0 2017-02-26 10:25:57
KGBD 260956Z AUTO 34010KT 10SM CLR M02/M08 A2990 RMK AO2 SLP136 T10171078 FZRANO KGBD 2017-02-26T09:56:00Z 38.35 -98.87 -1.7 -7.8 340 10 10.0 29.899607 1013.6 TRUE TRUE TRUE VFR METAR 575.0 2017-02-26 10:25:57
KFCS 260958Z AUTO 01004KT 10SM CLR M04/M18 A2975 RMK AO2 SLP117 T10411178 $ KFCS 2017-02-26T09:58:00Z 38.67 -104.77 -4.1 -17.8 10 4 10.0 29.749016 1011.7 TRUE TRUE TRUE VFR METAR 1789.0 2017-02-26 10:25:57
CWLC 261000Z AUTO 02018KT 04/M01 RMK AO1 PK WND 01022/0900 T00421013 CWLC 2017-02-26T10:00:00Z 54.3 -130.62 4.2 -1.3 20 18 TRUE TRUE METAR 27.0 2017-02-26 10:25:57
KMFE 260953Z AUTO 04005KT 10SM FEW035 OVC080 19/14 A2993 RMK AO2 SLP133 T01890144 KMFE 2017-02-26T09:53:00Z 26.18 -98.25 18.9 14.4 40 5 10.0 29.929134 1013.3 TRUE TRUE VFR METAR 38.0 2017-02-26 10:25:57
PAQT 260953Z AUTO 07029G36KT 1/4SM SN FZFG VV009 M24/M26 A3002 RMK PK WND 07036/0920 SLP167 P0000 T12391256 TSNO $ VIA AUTODIAL PAQT 2017-02-26T09:53:00Z 70.22 -151.0 -23.9 -25.6 70 29 36 0.25 30.02067 1016.7 TRUE TRUE TRUE SN FZFG LIFR 0.005 900 METAR 12.0 2017-02-26 10:25:57
KMMU 260955Z AUTO 31011G19KT 10SM SCT047 03/M05 A2984 RMK AO2 KMMU 2017-02-26T09:55:00Z 40.78 -74.42 3.0 -5.0 310 11 19 10.0 29.840551 TRUE TRUE VFR METAR 57.0 2017-02-26 10:25:57
EFMI 260950Z AUTO 00000KT CAVOK M03/M07 Q0996 EFMI 2017-02-26T09:50:00Z 61.68 27.2 -3.0 -7.0 0 0 6.21 29.409449 TRUE VFR METAR 138.0 2017-02-26 10:25:57
KBHM 260953Z 00000KT 10SM CLR 01/M03 A3019 RMK AO2 SLP225 T00111033 KBHM 2017-02-26T09:53:00Z 33.57 -86.75 1.1 -3.3 0 0 10.0 30.188976 1022.5 TRUE VFR METAR 197.0 2017-02-26 10:25:57
CYWA 261000Z AUTO 29016KT 9SM OVC030 M08/M14 A2979 RMK SLP096 CYWA 2017-02-26T10:00:00Z 45.95 -77.32 -8.0 -14.0 290 16 9.0 29.790354 1009.6 TRUE MVFR METAR 130.0 2017-02-26 10:25:57
KARM 260955Z AUTO 00000KT 10SM CLR 06/05 A3002 RMK AO2 T00630049 KARM 2017-02-26T09:55:00Z 29.25 -96.15 6.3 4.9 0 0 10.0 30.02067 TRUE TRUE VFR METAR 31.0 2017-02-26 10:25:57
PKWA 261000Z AUTO 07020G25KT 10SM SCT023 SCT030 SCT042 28/23 A2980 RMK AO2 T02770234 PKWA 2017-02-26T10:00:00Z 8.72 167.72 27.7 23.4 70 20 25 10.0 29.799213 TRUE TRUE VFR SPECI 8.0 2017-02-26 10:25:57
KDFI 260953Z AUTO 26003KT 10SM CLR M04/M08 A3008 RMK AO2 SLP195 T10391083 KDFI 2017-02-26T09:53:00Z 41.33 -84.43 -3.9 -8.3 260 3 10.0 30.079725 1019.5 TRUE TRUE VFR METAR 219.0 2017-02-26 10:25:57
CAHR 261000Z AUTO 17012G17KT 07/07 RMK AO1 1PAST HR PRESFR SOG 30 6094 PK WND 12024/0942 SLP896 P0016 T00730067 50126 CAHR 2017-02-26T10:00:00Z 46.35 -63.17 7.3 6.7 170 12 17 989.6 TRUE TRUE 0.0 0.16 METAR 53.0 2017-02-26 10:25:57
KGGW 260953Z AUTO 13005KT 10SM BKN055 OVC070 M08/M10 A2964 RMK AO2 SLP073 T10831100 KGGW 2017-02-26T09:53:00Z 48.22 -106.62 -8.3 -10.0 130 5 10.0 29.639763 1007.3 TRUE TRUE VFR METAR 694.0 2017-02-26 10:25:57
KHOB 260955Z AUTO 21006KT 10SM CLR 01/M04 A2986 RMK AO2 KHOB 2017-02-26T09:55:00Z 32.67 -103.22 1.0 -4.0 210 6 10.0 29.861221 TRUE TRUE VFR METAR 1115.0 2017-02-26 10:25:57
LFQA 261000Z AUTO 21012KT 9999 OVC022 08/03 Q1015 LFQA 2017-02-26T10:00:00Z 49.2 4.15 8.0 3.0 210 12 6.21 29.970472 TRUE MVFR METAR 95.0 2017-02-26 10:25:57
KCMX 261011Z AUTO 20006KT 2 1/2SM -SN BR FEW014 OVC029 M06/M08 A2967 RMK AO2 P0000 T10611083 KCMX 2017-02-26T10:11:00Z 47.17 -88.48 -6.1 -8.3 200 6 2.5 29.66929 TRUE TRUE -SN BR IFR 0.005 SPECI 326.0 2017-02-26 10:25:57
KSAR 260955Z AUTO 15005KT 10SM CLR M03/M09 A3015 RMK AO2 T10321094 KSAR 2017-02-26T09:55:00Z 38.15 -89.7 -3.2 -9.4 150 5 10.0 30.15059 TRUE TRUE VFR METAR 164.0 2017-02-26 10:25:57
DAAE 261000Z 24007KT 8000 SCT020 FEW026CB BKN040 12/10 Q1023 DAAE 2017-02-26T10:00:00Z 36.72 5.07 12.0 10.0 240 7 4.97 30.206694 MVFR METAR 2.0 2017-02-26 10:25:57
MHSC 260958Z AUTO 13003KT 9999 CLR 19/16 A2998 RMK AO2 SLP108 T01920163 $ MHSC 2017-02-26T09:58:00Z 14.37 -87.62 19.2 16.3 130 3 6.21 29.97933 1010.8 TRUE TRUE TRUE VFR METAR 626.0 2017-02-26 10:25:57
KAWM 260953Z AUTO 14003KT 10SM CLR M01/M02 A3017 RMK AO2 SLP218 T10061022 $ KAWM 2017-02-26T09:53:00Z 35.13 -90.23 -0.6 -2.2 140 3 10.0 30.171259 1021.8 TRUE TRUE TRUE VFR METAR 65.0 2017-02-26 10:25:57
LIPO 260950Z 26003KT CAVOK 09/M00 Q1020 LIPO 2017-02-26T09:50:00Z 45.42 10.33 9.0 0.0 260 3 6.21 30.11811 VFR METAR 109.0 2017-02-26 10:25:57
LZZI 261000Z 33002KT CAVOK 02/M03 Q1019 LZZI 2017-02-26T10:00:00Z 49.23 18.62 2.0 -3.0 330 2 6.21 30.088583 VFR METAR 311.0 2017-02-26 10:25:57
KOGD 260953Z AUTO 17008KT 10SM CLR M07/M11 A2995 RMK AO2 SLP168 T10721106 KOGD 2017-02-26T09:53:00Z 41.2 -112.02 -7.2 -10.6 170 8 10.0 29.949802 1016.8 TRUE TRUE VFR METAR 1353.0 2017-02-26 10:25:57
KDNL 260953Z AUTO 30008KT 10SM CLR 07/M07 A3008 RMK AO2 SLP184 T00721072 KDNL 2017-02-26T09:53:00Z 33.47 -82.03 7.2 -7.2 300 8 10.0 30.079725 1018.4 TRUE TRUE VFR METAR 130.0 2017-02-26 10:25:57
SULS 261000Z 04004KT CAVOK 22/20 Q1013 SULS 2017-02-26T10:00:00Z -34.87 -55.1 22.0 20.0 40 4 6.21 29.911417 VFR METAR 30.0 2017-02-26 10:25:57
EGLF 260950Z 25008KT 9999 VCSH FEW007 BKN022 09/09 Q1008 EGLF 2017-02-26T09:50:00Z 51.28 -0.77 9.0 9.0 250 8 6.21 29.763779 VCSH MVFR METAR 65.0 2017-02-26 10:25:57
BGJN 260950Z 16001KT 9999 FEW170 M29/M35 Q1017 BGJN 2017-02-26T09:50:00Z 69.25 -51.07 -29.0 -35.0 160 1 6.21 30.029528 VFR METAR 25.0 2017-02-26 10:25:57
OMAA 261000Z 33014KT 7000 -RA NSC 19/17 Q1017 NOSIG OMAA 2017-02-26T10:00:00Z 24.42 54.63 19.0 17.0 330 14 4.35 30.029528 TRUE -RA MVFR METAR 27.0 2017-02-26 10:25:57
CWRX 261000Z AUTO 18009G16KT ////SM //// NCD ///// A//// CWRX 2017-02-26T10:00:00Z 69.07 -79.02 180 9 16 TRUE METAR 41.0 2017-02-26 10:25:57
EBDT 260955Z AUTO 21008KT 9999 BKN018/// BKN025/// 09/04 Q1012 WHT EBDT 2017-02-26T09:55:00Z 51.02 5.07 9.0 4.0 210 8 6.21 29.88189 TRUE MVFR METAR 54.0 2017-02-26 10:25:57
KMQB 260955Z AUTO 18010KT 10SM OVC090 M02/M08 A3004 RMK AO2 T10211076 KMQB 2017-02-26T09:55:00Z 40.52 -90.65 -2.1 -7.6 180 10 10.0 30.041338 TRUE TRUE VFR METAR 215.0 2017-02-26 10:25:57
SVMI 261000Z 14002KT 9999 SCT016 27/14 Q1015 SVMI 2017-02-26T10:00:00Z 10.58 -67.0 27.0 14.0 140 2 6.21 29.970472 VFR METAR 48.0 2017-02-26 10:25:57
CWBE 261000Z AUTO 31004KT M06/M09 RMK AO1 SLP130 T10621089 53010 CWBE 2017-02-26T10:00:00Z 45.98 -81.48 -6.2 -8.9 310 4 1013.0 TRUE TRUE 1.0 METAR 196.0 2017-02-26 10:25:57
KJWY 260955Z AUTO 11004KT 10SM CLR 03/00 A2999 RMK AO2 T00301004 KJWY 2017-02-26T09:55:00Z 32.45 -96.92 3.0 -0.4 110 4 10.0 29.991142 TRUE TRUE VFR METAR 217.0 2017-02-26 10:25:57
SAWG 261000Z 00000KT CAVOK 09/02 Q1009 SAWG 2017-02-26T10:00:00Z -51.62 -69.32 9.0 2.0 0 0 6.21 29.793306 VFR METAR 19.0 2017-02-26 10:25:57
ETHC 260920Z 23015KT 9999 BKN026 08/02 Q1009 BLU ETHC 2017-02-26T09:20:00Z 52.6 10.02 8.0 2.0 230 15 6.21 29.793306 MVFR METAR 52.0 2017-02-26 10:25:57
LIVC 260955Z 27002KT CAVOK 03/M06 Q1019 RMK SKC MON LIB VAL NIL VIS MIN 9999 LIVC 2017-02-26T09:55:00Z 44.2 10.68 3.0 -6.0 270 2 6.21 30.088583 VFR METAR 2173.0 2017-02-26 10:25:57
FOOG 261000Z 19011KT 9999 FEW010 30/26 Q1011 FOOG 2017-02-26T10:00:00Z -0.7 8.75 30.0 26.0 190 11 6.21 29.852362 VFR METAR 4.0 2017-02-26 10:25:57
YPEA 261000Z AUTO 24011KT 9999 // NCD 25/17 Q1012 YPEA 2017-02-26T10:00:00Z -31.67 116.02 25.0 17.0 240 11 6.21 29.88189 TRUE VFR SPECI 49.0 2017-02-26 10:25:57
CWNE 261000Z AUTO 13010G17KT 03/02 RMK AO1 8PAST HR PRESFR 6077 PK WND 12018/0947 SLP900 P0034 T00280022 50163 CWNE 2017-02-26T10:00:00Z 47.07 -64.0 2.8 2.2 130 10 17 990.0 TRUE TRUE 0.0 0.34 METAR 15.0 2017-02-26 10:25:57
KSCR 260950Z AUTO 00000KT 10SM CLR 02/M07 A3004 RMK AO2 T00201073 KSCR 2017-02-26T09:50:00Z 35.7 -79.5 2.0 -7.3 0 0 10.0 30.041338 TRUE TRUE VFR METAR 188.0 2017-02-26 10:25:57
KMMH 260955Z AUTO 31003KT 10SM CLR M12/M17 A2988 RMK AO2 T11231169 KMMH 2017-02-26T09:55:00Z 37.62 -118.82 -12.3 -16.9 310 3 10.0 29.878937 TRUE TRUE VFR METAR 2173.0 2017-02-26 10:25:57
K7W4 260955Z AUTO 30003KT 10SM CLR 01/M06 A2999 RMK AO1 T00141058 K7W4 2017-02-26T09:55:00Z 37.97 -77.75 1.4 -5.8 300 3 10.0 29.991142 TRUE TRUE VFR METAR 106.0 2017-02-26 10:25:57
KSMQ 260953Z AUTO 29008G15KT 10SM OVC042 03/M05 A2983 RMK AO2 SLP101 T00281050 $ KSMQ 2017-02-26T09:53:00Z 40.62 -74.67 2.8 -5.0 290 8 15 10.0 29.828741 1010.1 TRUE TRUE TRUE VFR METAR 30.0 2017-02-26 10:25:57

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query