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
KRDM 221256Z 05004KT 10SM OVC060 08/05 A3032 RMK AO2 SLP260 T00830050 KRDM 2019-10-22T12:56:00Z 44.25 -121.15 8.3 5.0 50 4 10.0 30.318897 1026.0 TRUE VFR METAR 938.0 2019-10-22 13:34:07
CYTH 221300Z 02005KT 15SM SCT240 M07/M08 A2999 RMK CI3 SLP175 CYTH 2019-10-22T13:00:00Z 55.78 -97.87 -7.0 -8.0 20 5 15.0 29.991142 1017.5 VFR METAR 218.0 2019-10-22 13:34:07
RODN 221256Z AUTO 17003KT 10SM CLR 24/21 A2985 RMK AO2 SLP114 T02360213 $ RODN 2019-10-22T12:56:00Z 26.35 127.77 23.6 21.3 170 3 10.0 29.84941 1011.4 TRUE TRUE TRUE VFR METAR 45.0 2019-10-22 13:34:07
ETIK 221256Z AUTO 01004KT 9999 FEW200 16/13 A3024 RMK AO2 SLP243 T01570132 ETIK 2019-10-22T12:56:00Z 49.47 10.37 15.7 13.2 10 4 6.21 30.239174 1024.3 TRUE TRUE VFR METAR 325.0 2019-10-22 13:34:07
KHUA 221258Z AUTO 00000KT 5SM BR CLR 12/12 A2998 RMK AO2 SLP151 T01210117 KHUA 2019-10-22T12:58:00Z 34.68 -86.68 12.1 11.7 0 0 5.0 29.97933 1015.1 TRUE TRUE BR MVFR METAR 209.0 2019-10-22 13:34:07
K2G4 221300Z AUTO 14014G19KT M1/4SM OVC001 11/11 A2985 RMK AO1 K2G4 2019-10-22T13:00:00Z 39.58 -79.33 11.0 11.0 140 14 19 0.25 29.84941 TRUE TRUE LIFR METAR 894.0 2019-10-22 13:34:07
LTCR 221250Z 25005KT 210V290 9999 FEW025TCU SCT036 BKN180 24/10 Q1014 LTCR 2019-10-22T12:50:00Z 37.22 40.63 24.0 10.0 250 5 6.21 29.940945 VFR METAR 527.0 2019-10-22 13:34:08
SPQU 221300Z VRB02KT CAVOK 15/M03 NOSIG Q1027 RMK PP000 SPQU 2019-10-22T13:00:00Z -16.33 -71.57 15.0 -3.0 0 2 6.21 30.324802 TRUE VFR METAR 2554.0 2019-10-22 13:34:07
KJXI 221315Z AUTO 31003KT 10SM OVC004 10/05 A3019 RMK AO2 T00970046 KJXI 2019-10-22T13:15:00Z 32.7 -94.95 9.7 4.6 310 3 10.0 30.188976 TRUE TRUE LIFR SPECI 127.0 2019-10-22 13:34:07
EFKT 221320Z AUTO 16010KT 2500 -SN OVC004 00/M00 Q0984 EFKT 2019-10-22T13:20:00Z 67.7 24.85 0.0 0.0 160 10 1.55 29.055119 TRUE -SN LIFR METAR 643.0 2019-10-22 13:34:07
CYZF 221308Z 08003KT 2SM -SN BR VV002 M01/M01 A2986 RMK SN8 SLP127 CYZF 2019-10-22T13:08:00Z 62.47 -114.45 -1.0 -1.0 80 3 2.0 29.861221 1012.7 -SN BR LIFR 200 SPECI 206.0 2019-10-22 13:34:07
PATL 221255Z AUTO VRB02KT 10SM SCT002 BKN026 M02/M02 A2976 RMK AO2 RAB1122E1155SHRAB1226E1249 SLP094 P0001 T10161016 PATL 2019-10-22T12:55:00Z 62.9 -155.97 -1.6 -1.6 0 2 10.0 29.760826 1009.4 TRUE TRUE MVFR 0.01 METAR 294.0 2019-10-22 13:34:07
KBIJ 221315Z AUTO 32013G19KT 300V360 7SM -RA BKN009 BKN015 OVC019 17/15 A3000 RMK AO2 KBIJ 2019-10-22T13:15:00Z 31.4 -84.9 17.0 15.0 320 13 19 7.0 30.0 TRUE TRUE -RA IFR SPECI 65.0 2019-10-22 13:34:07
LEVD 221300Z 06015KT 040V100 9999 SCT020 BKN026 10/06 Q1015 LEVD 2019-10-22T13:00:00Z 41.72 -4.83 10.0 6.0 60 15 6.21 29.970472 MVFR METAR 854.0 2019-10-22 13:34:07
KLBB 221253Z 06009KT 10SM FEW250 03/M04 A3022 RMK AO2 SLP223 T00331039 KLBB 2019-10-22T12:53:00Z 33.67 -101.82 3.3 -3.9 60 9 10.0 30.221457 1022.3 TRUE VFR METAR 993.0 2019-10-22 13:34:07
ENSF 221250Z AUTO 33012KT 9999NDV -RA BKN026/// 08/03 Q1008 W///S6 ENSF 2019-10-22T12:50:00Z 61.25 1.85 8.0 3.0 330 12 29.763779 TRUE -RA METAR 10.0 2019-10-22 13:34:08
LIMN 221255Z VRB02KT 9999 FEW020 22/15 Q1022 RMK SCT SCT080 VIS MIN 9999 BLU LIMN 2019-10-22T12:55:00Z 45.52 8.67 22.0 15.0 0 2 6.21 30.177166 VFR METAR 169.0 2019-10-22 13:34:07
KUNI 221315Z AUTO 17004KT 10SM -RA OVC090 13/13 A2981 RMK AO2 T01270127 KUNI 2019-10-22T13:15:00Z 39.22 -82.23 12.7 12.7 170 4 10.0 29.811024 TRUE TRUE -RA VFR SPECI 193.0 2019-10-22 13:34:07
K42J 221315Z AUTO 20010KT 4SM BR BKN008 OVC110 25/25 A2997 RMK A01 TSNO K42J 2019-10-22T13:15:00Z 29.85 -82.05 25.0 25.0 200 10 4.0 29.970472 TRUE TRUE TRUE BR IFR METAR 60.0 2019-10-22 13:34:07
KFKL 221310Z AUTO 20005KT 4SM +RA BR FEW005 OVC009 13/12 A2982 RMK AO2 CIG 007V012 P0010 KFKL 2019-10-22T13:10:00Z 41.37 -79.87 13.0 12.0 200 5 4.0 29.819881 TRUE TRUE +RA BR IFR 0.1 METAR 469.0 2019-10-22 13:34:07
LTCL 221250Z 21006KT 180V240 9999 FEW025CB SCT035 24/12 Q1015 LTCL 2019-10-22T12:50:00Z 37.98 41.83 24.0 12.0 210 6 6.21 29.970472 VFR METAR 610.0 2019-10-22 13:34:08
EGLF 221320Z 24007KT 200V280 9999 NSC 15/04 Q1023 EGLF 2019-10-22T13:20:00Z 51.28 -0.77 15.0 4.0 240 7 6.21 30.206694 VFR METAR 65.0 2019-10-22 13:34:07
CWGY 221300Z AUTO M04/M06 RMK AO1 SLP127 T10381057 56026 CWGY 2019-10-22T13:00:00Z 51.67 -110.2 -3.8 -5.7 1012.7 TRUE TRUE -2.6 METAR 707.0 2019-10-22 13:34:07
GCRR 221300Z 36015KT 320V040 9999 FEW045 25/11 Q1018 GCRR 2019-10-22T13:00:00Z 28.93 -13.58 25.0 11.0 360 15 6.21 30.059055 VFR METAR 40.0 2019-10-22 13:34:07
KPLD 221315Z AUTO 24014G17KT 10SM CLR 11/03 A2973 RMK AO2 KPLD 2019-10-22T13:15:00Z 40.45 -84.98 11.0 3.0 240 14 17 10.0 29.731298 TRUE TRUE VFR SPECI 282.0 2019-10-22 13:34:07
KEHY 221310Z AUTO 25028G33KT 10SM OVC030 00/M05 A3015 RMK AO2 PWINO KEHY 2019-10-22T13:10:00Z 41.73 -106.47 0.0 -5.0 250 28 33 10.0 30.15059 TRUE TRUE TRUE MVFR METAR 2225.0 2019-10-22 13:34:07
KGPT 221253Z 34006KT 10SM CLR 17/14 A3006 RMK AO2 SLP180 T01670144 KGPT 2019-10-22T12:53:00Z 30.42 -89.08 16.7 14.4 340 6 10.0 30.059055 1018.0 TRUE VFR SPECI 14.0 2019-10-22 13:34:07
KMKN 221315Z AUTO 32003KT 10SM CLR 06/03 A3022 RMK AO2 T00570032 KMKN 2019-10-22T13:15:00Z 31.92 -98.6 5.7 3.2 320 3 10.0 30.221457 TRUE TRUE VFR METAR 423.0 2019-10-22 13:34:07
EEKA 221250Z 23012KT 160V270 9999 BKN017 12/08 Q1011 EEKA 2019-10-22T12:50:00Z 58.98 22.83 12.0 8.0 230 12 6.21 29.852362 MVFR METAR 4.0 2019-10-22 13:34:08
ZGNN 221300Z VRB01MPS CAVOK 25/20 Q1010 NOSIG ZGNN 2019-10-22T13:00:00Z 22.62 108.17 25.0 20.0 0 2 6.21 29.822834 TRUE VFR METAR 73.0 2019-10-22 13:34:07
CYCB 221310Z 28018KT 15SM FEW018 BKN055 BKN100 M10/M12 A2976 RMK SC1SC4AC1 SLP082 CYCB 2019-10-22T13:10:00Z 69.08 -105.12 -10.0 -12.0 280 18 15.0 29.760826 1008.2 VFR SPECI 27.0 2019-10-22 13:34:07
ENQC 221250Z AUTO 30017KT 7000NDV RA BKN008/// 08/07 Q1007 W///S6 ENQC 2019-10-22T12:50:00Z 60.88 3.62 8.0 7.0 300 17 29.734253 TRUE RA METAR 20.0 2019-10-22 13:34:08
SBUL 221300Z 24006KT 9999 BKN019 20/16 Q1017 SBUL 2019-10-22T13:00:00Z -18.87 -48.22 20.0 16.0 240 6 6.21 30.029528 MVFR METAR 922.0 2019-10-22 13:34:07
GVNP 221300Z 03021KT 9999 BKN017 29/20 Q1014 NOSIG GVNP 2019-10-22T13:00:00Z 14.95 -23.48 29.0 20.0 30 21 6.21 29.940945 TRUE MVFR METAR 70.0 2019-10-22 13:34:07
KIKK 221315Z AUTO 24021G25KT 10SM -DZ BKN028 BKN039 OVC060 09/05 A2964 RMK AO2 T00920053 KIKK 2019-10-22T13:15:00Z 41.07 -87.85 9.2 5.3 240 21 25 10.0 29.639763 TRUE TRUE -DZ MVFR SPECI 192.0 2019-10-22 13:34:07
GVAC 221300Z 06016KT 9999 BKN014 29/19 Q1015 NOSIG GVAC 2019-10-22T13:00:00Z 16.72 -22.93 29.0 19.0 60 16 6.21 29.970472 TRUE MVFR METAR 55.0 2019-10-22 13:34:07
UACP 221300Z 21009MPS 9999 -SHRA OVC026CB 03/M01 Q1017 R23/2/0256 NOSIG RMK QFE750/1000 UACP 2019-10-22T13:00:00Z 54.78 69.18 3.0 -1.0 210 17 6.21 30.029528 TRUE -SHRA MVFR METAR 142.0 2019-10-22 13:34:07
TNCM 221300Z 11004KT 9999 -SHRA SCT016 29/25 Q1015 NOSIG TNCM 2019-10-22T13:00:00Z 18.05 -63.12 29.0 25.0 110 4 6.21 29.970472 TRUE -SHRA VFR METAR 4.0 2019-10-22 13:34:07
MHNO 221300Z 00000KT 3000 BR FEW030 SCT090 19/19 3 KM ALL BR HZ MHNO 2019-10-22T13:00:00Z 14.43 -89.18 19.0 19.0 0 0 1.86 BR HZ BR IFR METAR 2.0 2019-10-22 13:34:07
ENBN 221250Z 23031G46KT 9999 -SHRA FEW011CB BKN023 08/04 Q0986 ENBN 2019-10-22T12:50:00Z 65.47 12.22 8.0 4.0 230 31 46 6.21 29.114174 -SHRA MVFR METAR 9.0 2019-10-22 13:34:08
MMZC 221240Z 00000KT 10SM BKN020 OVC100 16/13 A3027 RMK 8/42/ MMZC 2019-10-22T12:40:00Z 22.9 -102.68 16.0 13.0 0 0 10.0 30.268702 MVFR METAR 2177.0 2019-10-22 13:34:08
LQBK 221300Z 02004KT 340V110 CAVOK 27/14 Q1021 NOSIG LQBK 2019-10-22T13:00:00Z 44.93 17.3 27.0 14.0 20 4 6.21 30.147638 TRUE VFR METAR 122.0 2019-10-22 13:34:07
OIZH 221300Z 02010KT 9999 FEW045 22/M01 Q1019 A3010 NOSIG OIZH 2019-10-22T13:00:00Z 29.47 60.92 22.0 -1.0 20 10 6.21 30.088583 TRUE VFR METAR 1370.0 2019-10-22 13:34:07
SLET 221300Z 17012KT 9999 SCT023 BKN070 BKN200 24/11 Q1016 SLET 2019-10-22T13:00:00Z -17.8 -63.17 24.0 11.0 170 12 6.21 30.0 VFR METAR 414.0 2019-10-22 13:34:07
YBDV 221300Z AUTO 16007KT //// // ////// 25/M09 Q1016 YBDV 2019-10-22T13:00:00Z -25.9 139.35 25.0 -9.0 160 7 30.0 TRUE METAR 47.0 2019-10-22 13:34:07
KCPK 221315Z AUTO 14004KT 10SM OVC006 15/14 A3002 RMK AO2 T01500143 KCPK 2019-10-22T13:15:00Z 36.67 -76.32 15.0 14.3 140 4 10.0 30.02067 TRUE TRUE IFR SPECI 6.0 2019-10-22 13:34:07
SOCA 221300Z AUTO 04006KT 350V140 9999 BKN029 31/23 Q1012 NOSIG SOCA 2019-10-22T13:00:00Z 4.82 -52.37 31.0 23.0 40 6 6.21 29.88189 TRUE TRUE MVFR METAR 9.0 2019-10-22 13:34:07
KSPF 221315Z AUTO 27012KT 10SM OVC080 04/M03 A2998 RMK AO2 KSPF 2019-10-22T13:15:00Z 44.47 -103.77 4.0 -3.0 270 12 10.0 29.97933 TRUE TRUE VFR SPECI 1188.0 2019-10-22 13:34:07
SCTB 221300Z 23003KT CAVOK 18/03 Q1016 SCTB 2019-10-22T13:00:00Z -33.45 -70.53 18.0 3.0 230 3 6.21 30.0 VFR METAR 649.0 2019-10-22 13:34:07
EKBI 221320Z AUTO 26010KT 9999 BKN017/// BKN051/// 13/10 Q1019 EKBI 2019-10-22T13:20:00Z 55.72 9.15 13.0 10.0 260 10 6.21 30.088583 TRUE MVFR METAR 66.0 2019-10-22 13:34:07

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query