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
LBWN 211330Z 14011KT CAVOK 29/21 Q1013 NOSIG LBWN 2018-06-21T13:30:00Z 43.22 27.82 29.0 21.0 140 11 6.21 29.911417 TRUE VFR METAR 43.0 2018-06-21 13:37:48
KSTP 211253Z 06006KT 10SM FEW110 19/16 A2988 RMK AO2 SLP111 T01940161 KSTP 2018-06-21T12:53:00Z 44.93 -93.05 19.4 16.1 60 6 10.0 29.878937 1011.1 TRUE VFR METAR 219.0 2018-06-21 13:37:48
UWUU 211300Z 27010MPS 9999 BKN040 21/06 Q1000 R32L/0///60 NOSIG RMK QFE738/0984 UWUU 2018-06-21T13:00:00Z 54.57 55.87 21.0 6.0 270 19 6.21 29.52756 TRUE VFR METAR 137.0 2018-06-21 13:37:48
KHEZ 211303Z AUTO 24003KT 7SM BKN009 OVC013 25/24 A2995 RMK AO2 RAE1258 CIG 006V010 P0000 KHEZ 2018-06-21T13:03:00Z 31.62 -91.3 25.0 24.0 240 3 7.0 29.949802 TRUE TRUE IFR 0.005 SPECI 83.0 2018-06-21 13:37:48
KP92 211253Z AUTO 00000KT A2992 RMK AO1 SLP133 KP92 2018-06-21T12:53:00Z 29.57 -91.53 0 0 29.920275 1013.3 TRUE TRUE METAR 1.0 2018-06-21 13:37:48
KYIP 211253Z 06009KT 10SM CLR 20/12 A2989 RMK AO2 SLP116 T02000122 KYIP 2018-06-21T12:53:00Z 42.23 -83.53 20.0 12.2 60 9 10.0 29.890747 1011.6 TRUE VFR METAR 215.0 2018-06-21 13:37:48
KOXV 211315Z AUTO 20005KT 6SM BR FEW007 OVC016 18/16 A2971 RMK AO2 KOXV 2018-06-21T13:15:00Z 41.28 -93.12 18.0 16.0 200 5 6.0 29.71063 TRUE TRUE BR MVFR SPECI 283.0 2018-06-21 13:37:48
CYXX 211300Z CCA 24008KT 30SM FEW013 FEW090 SCT210 BKN250 15/12 A3003 RMK SC2AC1CI2CI1 AC TR VIS SW 15 SLP170 CYXX 2018-06-21T13:00:00Z 49.03 -122.38 15.0 12.0 240 8 30.0 30.029528 1017.0 BKN 25000 VFR METAR 58.0 2018-06-21 13:37:48
KDKR 211310Z AUTO 19003KT 10SM OVC003 24/23 A2995 RMK AO2 KDKR 2018-06-21T13:10:00Z 31.3 -95.4 24.0 23.0 190 3 10.0 29.949802 TRUE TRUE LIFR SPECI 106.0 2018-06-21 13:37:48
KGEV 211315Z AUTO 30003KT 10SM SCT020 SCT026 21/17 A2999 RMK AO2 T02120170 KGEV 2018-06-21T13:15:00Z 36.43 -81.42 21.2 17.0 300 3 10.0 29.991142 TRUE TRUE VFR SPECI 969.0 2018-06-21 13:37:48
KHZR 211315Z AUTO 22003KT 10SM OVC075 26/24 A2994 RMK AO2 LTG DSNT W KHZR 2018-06-21T13:15:00Z 30.72 -91.48 26.0 24.0 220 3 10.0 29.940945 TRUE TRUE VFR SPECI 12.0 2018-06-21 13:37:48
UTNN 211300Z 18004KT CAVOK 33/08 Q1010 R33/CLRD60 NOSIG UTNN 2018-06-21T13:00:00Z 42.48 59.63 33.0 8.0 180 4 6.21 29.822834 TRUE VFR METAR 67.0 2018-06-21 13:37:48
OAIX 211258Z 35017G21KT 9999 CLR 30/01 A2981 RMK SLP992 T02990014 $ OAIX 2018-06-21T12:58:00Z 34.95 69.27 29.9 1.4 350 17 21 6.21 29.811024 999.2 TRUE VFR METAR 1492.0 2018-06-21 13:37:48
KGDB 211315Z AUTO 00000KT 10SM SCT016 SCT120 19/17 A2990 RMK AO2 T01930169 KGDB 2018-06-21T13:15:00Z 44.75 -95.55 19.3 16.9 0 0 10.0 29.899607 TRUE TRUE VFR METAR 319.0 2018-06-21 13:37:48
KPVW 211315Z AUTO 00000KT 10SM CLR 21/17 A3010 RMK AO2 T02130169 KPVW 2018-06-21T13:15:00Z 34.17 -101.72 21.3 16.9 0 0 10.0 30.100393 TRUE TRUE VFR SPECI 1028.0 2018-06-21 13:37:48
LRIA 211330Z 11004KT CAVOK 30/16 Q1014 LRIA 2018-06-21T13:30:00Z 47.17 27.62 30.0 16.0 110 4 6.21 29.940945 VFR METAR 104.0 2018-06-21 13:37:48
KMHL 211335Z AUTO 00000KT 10SM SCT018 21/17 A2980 RMK AO2 KMHL 2018-06-21T13:35:00Z 39.1 -93.2 21.0 17.0 0 0 10.0 29.799213 TRUE TRUE VFR SPECI 237.0 2018-06-21 13:37:48
FZAA 211300Z 30006KT 5000 BR SCT016 BKN018 26/19 Q1015 NOSIG FZAA 2018-06-21T13:00:00Z -4.38 15.45 26.0 19.0 300 6 3.11 29.970472 TRUE BR MVFR METAR 312.0 2018-06-21 13:37:48
KPWC 211315Z AUTO 09003KT 10SM CLR 16/11 A3000 RMK AO2 KPWC 2018-06-21T13:15:00Z 46.72 -94.37 16.0 11.0 90 3 10.0 30.0 TRUE TRUE VFR METAR 395.0 2018-06-21 13:37:48
USHH 211300Z 25005MPS 9999 FEW028 18/13 Q0987 R24/190060 NOSIG RMK QFE737 USHH 2018-06-21T13:00:00Z 61.03 69.08 18.0 13.0 250 10 6.21 29.143702 TRUE VFR METAR 23.0 2018-06-21 13:37:48
SASA 211300Z 05003KT CAVOK 11/08 Q1020 SASA 2018-06-21T13:00:00Z -24.85 -65.47 11.0 8.0 50 3 6.21 30.11811 VFR METAR 1216.0 2018-06-21 13:37:48
EGPE 211320Z 30019KT 9999 FEW040 16/05 Q1026 EGPE 2018-06-21T13:20:00Z 57.52 -4.03 16.0 5.0 300 19 6.21 30.295275 VFR METAR 9.0 2018-06-21 13:37:48
LICD 211250Z 14005KT 120V180 CAVOK 25/20 Q1017 LICD 2018-06-21T12:50:00Z 35.5 12.62 25.0 20.0 140 5 6.21 30.029528 VFR METAR 20.0 2018-06-21 13:37:48
KFKR 211315Z AUTO 00000KT 3SM BR BKN005 BKN017 OVC023 A2979 RMK AO2 KFKR 2018-06-21T13:15:00Z 40.27 -86.57 0 0 3.0 29.790354 TRUE TRUE BR IFR SPECI 262.0 2018-06-21 13:37:48
SKCC 211300Z 18016KT 9999 FEW023 28/18 A2999 SKCC 2018-06-21T13:00:00Z 7.92 -72.52 28.0 18.0 180 16 6.21 29.991142 VFR METAR 317.0 2018-06-21 13:37:48
EGXV 211250Z AUTO 34010KT 9999 BKN050/// 17/04 Q1025 EGXV 2018-06-21T12:50:00Z 53.87 -0.45 17.0 4.0 340 10 6.21 30.265747 TRUE VFR METAR 6.0 2018-06-21 13:37:48
KLYH 211254Z VRB04KT 10SM FEW120 27/20 A2982 RMK AO2 SLP088 T02670200 KLYH 2018-06-21T12:54:00Z 37.32 -79.2 26.7 20.0 0 4 10.0 29.819881 1008.8 TRUE VFR METAR 295.0 2018-06-21 13:37:48
KBWI 211308Z 00000KT 10SM FEW003 SCT013 OVC028 23/21 A2978 RMK AO2 FU FEW003 FU PLUME W DRFTG SE T02330211 KBWI 2018-06-21T13:08:00Z 39.17 -76.68 23.3 21.1 0 0 10.0 29.778543 TRUE MVFR SPECI 59.0 2018-06-21 13:37:48
KVIH 211253Z AUTO 23008KT 8SM BKN004 OVC008 21/20 A2981 RMK AO2 RAE09 SLP086 P0000 T02110200 KVIH 2018-06-21T12:53:00Z 38.13 -91.77 21.1 20.0 230 8 8.0 29.811024 1008.6 TRUE TRUE LIFR 0.005 METAR 333.0 2018-06-21 13:37:48
ESSL 211320Z 26011KT 230V310 9999 FEW021 BKN044 BKN059 14/09 Q0999 ESSL 2018-06-21T13:20:00Z 58.38 15.67 14.0 9.0 260 11 6.21 29.498032 VFR METAR 52.0 2018-06-21 13:37:48
SBVT 211300Z 03006KT CAVOK 24/19 Q1023 SBVT 2018-06-21T13:00:00Z -20.27 -40.27 24.0 19.0 30 6 6.21 30.206694 VFR METAR 4.0 2018-06-21 13:37:48
CWQH 211300Z AUTO 35007KT 14/06 RMK AO1 T01430059 CWQH 2018-06-21T13:00:00Z 45.37 -71.82 14.3 5.9 350 7 TRUE TRUE METAR 181.0 2018-06-21 13:37:48
PTRO 211250Z 00000KT 15SM SCT016 BKN120 OVC300 25/24 A2986 PTRO 2018-06-21T12:50:00Z 7.37 134.55 25.0 24.0 0 0 15.0 29.861221 VFR METAR 54.0 2018-06-21 13:37:48
CXWM 211300Z AUTO 16008KT 15/13 RMK AO1 T01470126 CXWM 2018-06-21T13:00:00Z 49.5 -112.12 14.7 12.6 160 8 TRUE TRUE METAR 944.0 2018-06-21 13:37:48
EDDF 211320Z 32017KT 290V360 CAVOK 23/07 Q1017 NOSIG EDDF 2018-06-21T13:20:00Z 50.05 8.6 23.0 7.0 320 17 6.21 30.029528 TRUE VFR METAR 113.0 2018-06-21 13:37:48
KCKI 211335Z AUTO 00000KT 10SM CLR 27/24 A2984 RMK AO2 KCKI 2018-06-21T13:35:00Z 33.72 -79.85 27.0 24.0 0 0 10.0 29.840551 TRUE TRUE VFR METAR 21.0 2018-06-21 13:37:48
LFSD 211330Z AUTO 34010KT 310V010 CAVOK 27/15 Q1018 LFSD 2018-06-21T13:30:00Z 47.27 5.07 27.0 15.0 340 10 6.21 30.059055 TRUE VFR METAR 227.0 2018-06-21 13:37:48
KAWM 211253Z AUTO 23005KT 6SM BR BKN008 OVC013 24/23 A2985 RMK AO2 CIG 006V009 SLP105 T02390233 KAWM 2018-06-21T12:53:00Z 35.13 -90.23 23.9 23.3 230 5 6.0 29.84941 1010.5 TRUE TRUE BR IFR METAR 65.0 2018-06-21 13:37:48
KVGT 211253Z AUTO 30006KT 10SM CLR 26/02 A2987 RMK AO2 SLP102 T02560022 KVGT 2018-06-21T12:53:00Z 36.22 -115.2 25.6 2.2 300 6 10.0 29.870079 1010.2 TRUE TRUE VFR METAR 671.0 2018-06-21 13:37:48
KFAM 211256Z AUTO 24007KT 10SM FEW013 23/21 A2981 RMK AO2 SLP087 T02330206 KFAM 2018-06-21T12:56:00Z 37.77 -90.42 23.3 20.6 240 7 10.0 29.811024 1008.7 TRUE TRUE VFR METAR 288.0 2018-06-21 13:37:48
KOJA 211315Z AUTO 01003KT 10SM CLR 21/16 A3003 RMK AO2 KOJA 2018-06-21T13:15:00Z 35.55 -98.67 21.0 16.0 10 3 10.0 30.029528 TRUE TRUE VFR SPECI 490.0 2018-06-21 13:37:48
CXAG 211300Z AUTO 15005KT 17/13 RMK AO1 T01720129 CXAG 2018-06-21T13:00:00Z 53.92 -112.28 17.2 12.9 150 5 TRUE TRUE METAR 625.0 2018-06-21 13:37:48
KABE 211251Z 35003KT 10SM BKN055 OVC070 22/16 A2981 RMK AO2 RAE1156 SLP090 P0000 T02170156 KABE 2018-06-21T12:51:00Z 40.65 -75.45 21.7 15.6 350 3 10.0 29.811024 1009.0 TRUE VFR 0.005 METAR 114.0 2018-06-21 13:37:48
CWHV 211300Z AUTO 32005KT 12/05 RMK AO1 SLP114 T01160054 51015 CWHV 2018-06-21T13:00:00Z 46.2 -70.77 11.6 5.4 320 5 1011.4 TRUE TRUE 1.5 METAR 229.0 2018-06-21 13:37:48
DTTN 211300Z 29005KT 180V340 9999 SCT020 33/12 Q1014 DTTN 2018-06-21T13:00:00Z 36.47 8.8 33.0 12.0 290 5 6.21 29.940945 VFR METAR 144.0 2018-06-21 13:37:48
CWSF 211300Z AUTO 24014G19KT 10/05 RMK AO1 PK WND 27020/1204 SLP062 T00980049 51022 CWSF 2018-06-21T13:00:00Z 49.25 -65.32 9.8 4.9 240 14 19 1006.2 TRUE TRUE 2.2 METAR 29.0 2018-06-21 13:37:48
K2V6 211314Z AUTO 28005KT 10SM CLR 14/11 A3017 RMK AO2 K2V6 2018-06-21T13:14:00Z 40.1 -102.72 14.0 11.0 280 5 10.0 30.171259 TRUE TRUE VFR METAR 1261.0 2018-06-21 13:37:48
HTKJ 211300Z 00000KT 9999 SCT030 24/18 Q1018 NOSIG HTKJ 2018-06-21T13:00:00Z -3.42 37.07 24.0 18.0 0 0 6.21 30.059055 TRUE VFR METAR 896.0 2018-06-21 13:37:48
KEND 211256Z 28005KT 10SM BKN100 20/16 A3000 RMK AO2A SLP148 T02010157 $ KEND 2018-06-21T12:56:00Z 36.32 -97.92 20.1 15.7 280 5 10.0 30.0 1014.8 TRUE TRUE VFR METAR 398.0 2018-06-21 13:37:48
FAOR 211300Z 31008KT 270V340 CAVOK 18/01 Q1030 NOSIG FAOR 2018-06-21T13:00:00Z -26.12 28.22 18.0 1.0 310 8 6.21 30.413385 TRUE VFR METAR 1700.0 2018-06-21 13:37:48

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query