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
K3LF 280635Z AUTO 13005KT 10SM CLR 19/19 A2989 RMK AO2 T01920188 K3LF 2020-05-28T06:35:00Z 39.17 -89.67 19.2 18.8 130 5 10.0 29.890747 TRUE TRUE VFR METAR 210.0 2020-05-28 06:49:15
KMQB 280635Z AUTO 15005KT 10SM OVC100 20/19 A2989 RMK AO2 T01980190 KMQB 2020-05-28T06:35:00Z 40.52 -90.65 19.8 19.0 150 5 10.0 29.890747 TRUE TRUE VFR SPECI 215.0 2020-05-28 06:49:15
CYNA 280600Z AUTO 16007KT 9SM BKN005 OVC013 07/06 A2995 RMK SLP143 CYNA 2020-05-28T06:00:00Z 50.17 -61.82 7.0 6.0 160 7 9.0 29.949802 1014.3 TRUE IFR METAR 11.0 2020-05-28 06:49:15
DAOL 280600Z 07004KT 4000 BR SCT010 BKN026 19/17 Q1019 DAOL 2020-05-28T06:00:00Z 35.53 -0.52 19.0 17.0 70 4 2.49 30.088583 BR IFR METAR 112.0 2020-05-28 06:49:15
KREG 280635Z AUTO 00000KT 10SM CLR 20/18 A2991 RMK AO2 T01990178 KREG 2020-05-28T06:35:00Z 30.17 -90.93 19.9 17.8 0 0 10.0 29.911417 TRUE TRUE VFR METAR 4.0 2020-05-28 06:49:15
DAUO 280600Z 09011KT 9999 FEW040 BKN200 20/15 Q1023 DAUO 2020-05-28T06:00:00Z 33.5 6.78 20.0 15.0 90 11 6.21 30.206694 VFR METAR 63.0 2020-05-28 06:49:15
KAHN 280551Z AUTO 10004KT 10SM OVC020 21/19 A2999 RMK AO2 SLP152 T02110194 10222 20206 58005 KAHN 2020-05-28T05:51:00Z 33.95 -83.33 21.1 19.4 100 4 10.0 29.991142 1015.2 TRUE TRUE MVFR -0.5 22.2 20.6 METAR 244.0 2020-05-28 06:49:15
KRVL 280635Z AUTO 00000KT 10SM OVC024 21/18 A3013 RMK AO2 KRVL 2020-05-28T06:35:00Z 40.68 -77.63 21.0 18.0 0 0 10.0 30.129921 TRUE TRUE MVFR METAR 250.0 2020-05-28 06:49:15
FMEE 280630Z AUTO 10014KT 9999 ///TCU 27/20 Q1020 BECMG FEW025 FMEE 2020-05-28T06:30:00Z -20.87 55.52 27.0 20.0 100 14 6.21 30.11811 TRUE METAR 25.0 2020-05-28 06:49:15
K6L4 280635Z AUTO 00000KT 1/4SM -DZ BKN005 OVC008 18/18 A2998 RMK AO2 K6L4 2020-05-28T06:35:00Z 37.85 -81.92 18.0 18.0 0 0 0.25 29.97933 TRUE TRUE -DZ LIFR METAR 508.0 2020-05-28 06:49:15
FBFT 280600Z 35002KT CAVOK 08/M10 Q1025 FBFT 2020-05-28T06:00:00Z -21.17 27.48 8.0 -10.0 350 2 6.21 30.265747 VFR METAR 1000.0 2020-05-28 06:49:15
CWNZ 280600Z AUTO 21003KT 17/16 RMK AO1 SLP108 T01660158 56002 CWNZ 2020-05-28T06:00:00Z 49.75 -84.17 16.6 15.8 210 3 1010.8 TRUE TRUE -0.2 METAR 256.0 2020-05-28 06:49:15
KWLD 280554Z AUTO 34005KT 10SM BKN110 18/17 A2990 RMK AO2 SLP115 60001 T01830167 10222 20183 402500144 58001 KWLD 2020-05-28T05:54:00Z 37.17 -97.03 18.3 16.7 340 5 10.0 29.899607 1011.5 TRUE TRUE VFR -0.1 22.2 18.3 25.0 14.4 0.01 METAR 350.0 2020-05-28 06:49:15
KSNK 280635Z AUTO 16004KT 10SM CLR 20/13 A2995 RMK AO2 T01960125 KSNK 2020-05-28T06:35:00Z 32.7 -100.95 19.6 12.5 160 4 10.0 29.949802 TRUE TRUE VFR METAR 741.0 2020-05-28 06:49:15
KCNM 280553Z AUTO 19007KT 10SM CLR 22/02 A2994 RMK AO2 SLP080 T02220017 10350 20206 51018 KCNM 2020-05-28T05:53:00Z 32.33 -104.25 22.2 1.7 190 7 10.0 29.940945 1008.0 TRUE TRUE VFR 1.8 35.0 20.6 METAR 985.0 2020-05-28 06:49:15
KEWR 280551Z 00000KT 5SM BR BKN004 BKN010 OVC022 17/16 A3021 RMK AO2 SLP231 T01670156 10183 20167 58000 KEWR 2020-05-28T05:51:00Z 40.68 -74.17 16.7 15.6 0 0 5.0 30.209646 1023.1 TRUE BR LIFR 0.0 18.3 16.7 METAR 7.0 2020-05-28 06:49:15
KFKL 280556Z AUTO 15007KT 10SM SCT110 19/16 A3010 RMK AO2 RAE40 SLP182 P0000 60000 T01940161 10233 20194 58002 KFKL 2020-05-28T05:56:00Z 41.37 -79.87 19.4 16.1 150 7 10.0 30.100393 1018.2 TRUE TRUE VFR -0.2 23.3 19.4 0.005 0.005 METAR 469.0 2020-05-28 06:49:15
ZSOF 280600Z 18005MPS 140V210 CAVOK 33/18 Q1008 NOSIG ZSOF 2020-05-28T06:00:00Z 31.98 116.97 33.0 18.0 180 10 6.21 29.763779 TRUE VFR METAR 63.0 2020-05-28 06:49:15
OIMQ 280600Z AUTO 22010KT //// // ////// 31/03 Q1019 OIMQ 2020-05-28T06:00:00Z 35.23 58.47 31.0 3.0 220 10 30.088583 TRUE METAR 1140.0 2020-05-28 06:49:15
LRFT 280600Z 33014KT 9999 BKN025 15/10 Q1017 BLU BLU LRFT 2020-05-28T06:00:00Z 44.38 27.72 15.0 10.0 330 14 6.21 30.029528 MVFR METAR 52.0 2020-05-28 06:49:15
KCVX 280635Z AUTO 27004KT 10SM CLR 18/17 A2991 RMK AO2 T01800165 KCVX 2020-05-28T06:35:00Z 45.3 -85.27 18.0 16.5 270 4 10.0 29.911417 TRUE TRUE VFR METAR 204.0 2020-05-28 06:49:15
LICZ 280555Z 28005KT 9999 FEW080 15/11 Q1025 RMK FEW VIS MIN 9999 WIND THR28 28005KT WIND THR10 28005KT A3028 BLU LICZ 2020-05-28T05:55:00Z 37.38 14.92 15.0 11.0 280 5 6.21 30.265747 VFR METAR 22.0 2020-05-28 06:49:15
KCPS 280553Z AUTO 00000KT 10SM CLR 19/19 A2986 RMK AO2 SLP110 T01890189 10233 20183 402390183 58002 KCPS 2020-05-28T05:53:00Z 38.57 -90.15 18.9 18.9 0 0 10.0 29.861221 1011.0 TRUE TRUE VFR -0.2 23.3 18.3 23.9 18.3 METAR 126.0 2020-05-28 06:49:15
CWEZ 280600Z AUTO 26001KT 15/06 RMK AO1 SLP189 T01540055 58006 CWEZ 2020-05-28T06:00:00Z 48.78 -123.05 15.4 5.5 260 1 1018.9 TRUE TRUE -0.6 METAR 7.0 2020-05-28 06:49:15
KCMR 280635Z AUTO 24007KT 10SM CLR 19/M03 A3025 RMK AO2 KCMR 2020-05-28T06:35:00Z 35.3 -112.2 19.0 -3.0 240 7 10.0 30.250984 TRUE TRUE VFR METAR 2036.0 2020-05-28 06:49:15
KSBD 280640Z AUTO 24005KT 10SM CLR 23/12 A2996 RMK AO2 T02260121 KSBD 2020-05-28T06:40:00Z 34.08 -117.25 22.6 12.1 240 5 10.0 29.958662 TRUE TRUE VFR SPECI 353.0 2020-05-28 06:49:15
FACT 280600Z 36014KT 3000 +DZ OVC018 13/09 Q1019 NOSIG FACT 2020-05-28T06:00:00Z -33.97 18.6 13.0 9.0 360 14 1.86 30.088583 TRUE +DZ IFR METAR 42.0 2020-05-28 06:49:15
ZGOW 280600Z 10003MPS 070V140 7000 SCT011 FEW023TCU BKN023 26/24 Q1010 BECMG -TSRA ZGOW 2020-05-28T06:00:00Z 23.55 116.5 26.0 24.0 100 6 4.35 29.822834 MVFR METAR 3.0 2020-05-28 06:49:15
CXCA 280600Z AUTO 24001KT 11/11 RMK AO1 SLP107 T01120109 53005 CXCA 2020-05-28T06:00:00Z 49.15 -88.35 11.2 10.9 240 1 1010.7 TRUE TRUE 0.5 METAR 228.0 2020-05-28 06:49:15
LBWB 280600Z 34016KT 9999 FEW010 BKN100 13/10 Q1015 LBWB 2020-05-28T06:00:00Z 43.42 28.18 13.0 10.0 340 16 6.21 29.970472 VFR METAR 201.0 2020-05-28 06:49:15
HTDO 280600Z 09012KT 9999 SCT020 21/17 Q1021 NOSIG HTDO 2020-05-28T06:00:00Z -6.17 35.77 21.0 17.0 90 12 6.21 30.147638 TRUE VFR METAR 1120.0 2020-05-28 06:49:15
KIRK 280555Z AUTO 13006KT 10SM BKN006 21/20 A2987 RMK AO2 SLP110 60001 T02060200 10233 20200 402500161 56004 KIRK 2020-05-28T05:55:00Z 40.1 -92.55 20.6 20.0 130 6 10.0 29.870079 1011.0 TRUE TRUE IFR -0.4 23.3 20.0 25.0 16.1 0.01 METAR 293.0 2020-05-28 06:49:15
KI68 280635Z AUTO 12005KT 10SM SCT037 SCT050 OVC090 22/22 A2996 RMK AO1 T02210221 KI68 2020-05-28T06:35:00Z 39.47 -84.25 22.1 22.1 120 5 10.0 29.958662 TRUE TRUE VFR METAR 274.0 2020-05-28 06:49:15
KBXK 280635Z AUTO 00000KT 10SM CLR 29/M01 A2981 RMK A01 KBXK 2020-05-28T06:35:00Z 33.42 -112.68 29.0 -1.0 0 0 10.0 29.811024 TRUE TRUE VFR METAR 315.0 2020-05-28 06:49:15
SBBE 280600Z 12004KT CAVOK 25/24 Q1011 SBBE 2020-05-28T06:00:00Z -1.37 -48.47 25.0 24.0 120 4 6.21 29.852362 VFR METAR 16.0 2020-05-28 06:49:15
DTTZ 280600Z 03003KT 9999 FEW030 20/12 Q1024 DTTZ 2020-05-28T06:00:00Z 33.92 8.08 20.0 12.0 30 3 6.21 30.236221 VFR METAR 93.0 2020-05-28 06:49:15
ENBR 280620Z 31003KT 270V350 9999 FEW022 BKN045 09/05 Q1035 NOSIG RMK WIND 1200FT 32008KT ENBR 2020-05-28T06:20:00Z 60.28 5.22 9.0 5.0 310 3 6.21 30.561024 TRUE VFR SPECI 50.0 2020-05-28 06:49:15
K1IW 280558Z AUTO 07004KT 10SM FEW085 13/10 A3012 RMK AO2 SHRAB02E43 SLP164 P0001 60002 T01340097 10240 20134 50021 $ K1IW 2020-05-28T05:58:00Z 41.05 -102.87 13.4 9.7 70 4 10.0 30.121063 1016.4 TRUE TRUE TRUE VFR 2.1 24.0 13.4 0.01 0.02 METAR 1293.0 2020-05-28 06:49:15
KBKT 280635Z AUTO 12008G14KT 10SM OVC006 A3005 RMK AO1 KBKT 2020-05-28T06:35:00Z 37.07 -77.95 120 8 14 10.0 30.050198 TRUE TRUE IFR METAR 134.0 2020-05-28 06:49:15
KPAE 280553Z AUTO 00000KT 10SM CLR 15/06 A3010 RMK AO2 SLP191 T01500061 10206 20144 58003 KPAE 2020-05-28T05:53:00Z 47.92 -122.28 15.0 6.1 0 0 10.0 30.100393 1019.1 TRUE TRUE VFR -0.3 20.6 14.4 METAR 180.0 2020-05-28 06:49:15
KNFG 280555Z 27003KT 10SM OVC010 18/14 A2997 RMK AO2 SLP146 T01780139 10228 20178 51014 $ KNFG 2020-05-28T05:55:00Z 33.28 -117.33 17.8 13.9 270 3 10.0 29.970472 1014.6 TRUE TRUE MVFR 1.4 22.8 17.8 METAR 24.0 2020-05-28 06:49:15
KTXK 280553Z AUTO 18004KT 10SM SCT065 SCT090 18/16 A2988 RMK AO2 LTG DSNT SE AND SW SLP114 T01780161 10228 20167 402440167 53001 KTXK 2020-05-28T05:53:00Z 33.45 -93.98 17.8 16.1 180 4 10.0 29.878937 1011.4 TRUE TRUE VFR 0.1 22.8 16.7 24.4 16.7 METAR 111.0 2020-05-28 06:49:15
PHNL 280553Z COR 06008KT 10SM FEW025 FEW045 BKN250 26/19 A3011 RMK AO2 SLP195 T02560189 10289 20250 51014 PHNL 2020-05-28T05:53:00Z 21.33 -157.92 25.6 18.9 60 8 10.0 30.109253 1019.5 TRUE TRUE VFR 1.4 28.9 25.0 METAR 4.0 2020-05-28 06:49:15
CYMA 280600Z 28004KT 20SM FEW060 FEW100 SCT220 11/08 A3019 RMK SC2AC1CI1 CLIMAT 16.7/11.2/0.0 TCU ASOCTD SLP242 CYMA 2020-05-28T06:00:00Z 63.62 -135.87 11.0 8.0 280 4 20.0 30.188976 1024.2 VFR METAR 504.0 2020-05-28 06:49:15
RKSM 280600Z 30007KT 9999 BKN060 23/09 A2978 RKSM 2020-05-28T06:00:00Z 37.42 127.12 23.0 9.0 300 7 6.21 29.778543 VFR METAR 20.0 2020-05-28 06:49:15
LICG 280550Z 04011KT 9999 FEW015 18/14 Q1025 LICG 2020-05-28T05:50:00Z 36.82 11.97 18.0 14.0 40 11 6.21 30.265747 VFR METAR 191.0 2020-05-28 06:49:15
LTBH 280550Z 04004KT 010V080 9999 SCT035 BKN100 16/11 Q1018 LTBH 2020-05-28T05:50:00Z 40.13 26.42 16.0 11.0 40 4 6.21 30.059055 VFR METAR 3.0 2020-05-28 06:49:15
CYVC 280600Z 32011KT 12SM -RA BKN012 OVC030 02/01 A3007 RMK SC5SC3 SLP203 CYVC 2020-05-28T06:00:00Z 55.15 -105.27 2.0 1.0 320 11 12.0 30.070866 1020.3 -RA MVFR METAR 379.0 2020-05-28 06:49:15
YHID 280630Z AUTO 11017KT 9999 // NCD 28/20 Q1013 RF00.0/000.0 YHID 2020-05-28T06:30:00Z -10.58 142.3 28.0 20.0 110 17 6.21 29.911417 TRUE VFR METAR 13.0 2020-05-28 06:49:15
KELN 280553Z AUTO 03003KT 10SM CLR 12/03 A3012 RMK AO2 SLP196 T01220028 10278 20122 51011 KELN 2020-05-28T05:53:00Z 47.03 -120.53 12.2 2.8 30 3 10.0 30.121063 1019.6 TRUE TRUE VFR 1.1 27.8 12.2 METAR 519.0 2020-05-28 06:49:15

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query