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
KUVA 251035Z AUTO 10007KT 7SM SCT024 SCT031 SCT046 24/23 A2993 RMK AO2 T02360230 KUVA 2019-05-25T10:35:00Z 29.22 -99.75 23.6 23.0 100 7 7.0 29.929134 TRUE TRUE VFR METAR 287.0 2019-05-25 10:57:46
CWJI 251000Z AUTO 25007KT 07/01 RMK AO1 SLP098 T00700010 51007 CWJI 2019-05-25T10:00:00Z 49.72 -105.92 7.0 1.0 250 7 1009.8 TRUE TRUE 0.7 METAR 724.0 2019-05-25 10:57:46
KEZF 251035Z AUTO 00000KT 10SM BKN065 18/18 A3017 RMK AO2 T01800176 KEZF 2019-05-25T10:35:00Z 38.27 -77.45 18.0 17.6 0 0 10.0 30.171259 TRUE TRUE VFR METAR 26.0 2019-05-25 10:57:46
LPFL 251030Z 34003KT 310V010 2000 -DZ BR SCT003 BKN007 16/16 Q1024 LPFL 2019-05-25T10:30:00Z 39.45 -31.12 16.0 16.0 340 3 1.24 30.236221 -DZ BR IFR METAR 29.0 2019-05-25 10:57:46
K27K 251035Z AUTO 00000KT 10SM SCT070 SCT085 BKN120 20/18 A3007 RMK AO1 K27K 2019-05-25T10:35:00Z 38.23 -84.43 20.0 18.0 0 0 10.0 30.070866 TRUE TRUE VFR SPECI 289.0 2019-05-25 10:57:46
PPIZ 251048Z AUTO 02007KT 1/4SM FZFG BKN001 M02/M03 A3016 RMK AO2 FZRANO PPIZ 2019-05-25T10:48:00Z 69.73 -163.0 -2.0 -3.0 20 7 0.25 30.159449 TRUE TRUE TRUE FZFG LIFR SPECI 8.0 2019-05-25 10:57:46
KOPF 250953Z AUTO 06005KT 10SM FEW033 23/17 A3004 RMK AO2 SLP173 T02330172 KOPF 2019-05-25T09:53:00Z 25.92 -80.28 23.3 17.2 60 5 10.0 30.041338 1017.3 TRUE TRUE VFR METAR 16.0 2019-05-25 10:57:46
KMDW 250953Z 21007KT 10SM FEW200 BKN250 23/19 A2984 RMK AO2 SLP098 T02330194 KMDW 2019-05-25T09:53:00Z 41.78 -87.75 23.3 19.4 210 7 10.0 29.840551 1009.8 TRUE VFR METAR 188.0 2019-05-25 10:57:46
PAWS 250956Z AUTO 00000KT 10SM CLR 07/04 A3017 RMK AO2 SLP221 T00670044 PAWS 2019-05-25T09:56:00Z 61.57 -149.53 6.7 4.4 0 0 10.0 30.171259 1022.1 TRUE TRUE VFR METAR 107.0 2019-05-25 10:57:46
KRCA 250956Z AUTO 25005KT 10SM CLR 04/04 A2994 RMK AO2 SLP141 T00350035 $ KRCA 2019-05-25T09:56:00Z 44.13 -103.08 3.5 3.5 250 5 10.0 29.940945 1014.1 TRUE TRUE TRUE VFR METAR 999.0 2019-05-25 10:57:46
K1J0 251044Z AUTO 00000KT 1 1/4SM BR BKN003 19/19 A3014 RMK AO2 T01890189 $ K1J0 2019-05-25T10:44:00Z 30.85 -85.6 18.9 18.9 0 0 1.25 30.138779 TRUE TRUE TRUE BR LIFR SPECI 26.0 2019-05-25 10:57:46
K6A2 251035Z AUTO 32004KT 10SM SCT110 22/20 A3017 RMK AO2 K6A2 2019-05-25T10:35:00Z 33.23 -84.27 22.0 20.0 320 4 10.0 30.171259 TRUE TRUE VFR METAR 292.0 2019-05-25 10:57:46
ESND 251020Z AUTO 34005KT 280V360 9999 OVC030/// 10/03 Q1005 ESND 2019-05-25T10:20:00Z 62.05 14.42 10.0 3.0 340 5 6.21 29.675198 TRUE MVFR METAR 359.0 2019-05-25 10:57:46
KW31 251035Z AUTO 00000KT 10SM BKN085 19/19 A3016 RMK AO1 T01850185 KW31 2019-05-25T10:35:00Z 36.95 -78.18 18.5 18.5 0 0 10.0 30.159449 TRUE TRUE VFR METAR 162.0 2019-05-25 10:57:46
LIEA 251020Z 01004KT 300V090 CAVOK 24/13 Q1012 LIEA 2019-05-25T10:20:00Z 40.62 8.27 24.0 13.0 10 4 6.21 29.88189 VFR METAR 23.0 2019-05-25 10:57:46
PHOG 250954Z AUTO 08010KT 10SM CLR 26/18 A3006 RMK AO2 SLP185 T02560183 403440206 TSNO PHOG 2019-05-25T09:54:00Z 20.9 -156.43 25.6 18.3 80 10 10.0 30.059055 1018.5 TRUE TRUE TRUE VFR 34.4 20.6 METAR 12.0 2019-05-25 10:57:46
KFYV 250953Z AUTO 00000KT 10SM -RA BKN030 OVC038 19/18 A3004 RMK AO2 RAB11 SLP159 P0005 T01890178 TSNO KFYV 2019-05-25T09:53:00Z 36.02 -94.17 18.9 17.8 0 0 10.0 30.041338 1015.9 TRUE TRUE TRUE -RA MVFR 0.05 METAR 379.0 2019-05-25 10:57:46
KSWO 250953Z AUTO 17005KT 10SM FEW085 18/17 A2996 RMK AO2 SLP132 T01830167 KSWO 2019-05-25T09:53:00Z 36.17 -97.08 18.3 16.7 170 5 10.0 29.958662 1013.2 TRUE TRUE VFR METAR 290.0 2019-05-25 10:57:46
K22N 251036Z AUTO 00000KT 10SM CLR 08/08 A3021 RMK AO2 K22N 2019-05-25T10:36:00Z 40.8 -75.77 8.0 8.0 0 0 10.0 30.209646 TRUE TRUE VFR METAR 163.0 2019-05-25 10:57:46
KELO 251036Z AUTO 24008KT 10SM SCT007 BKN014 OVC035 13/12 A2960 RMK AO2 KELO 2019-05-25T10:36:00Z 47.82 -91.82 13.0 12.0 240 8 10.0 29.601377 TRUE TRUE MVFR METAR 443.0 2019-05-25 10:57:46
LFMT 251030Z AUTO 28006KT 250V330 CAVOK 25/13 Q1015 NOSIG LFMT 2019-05-25T10:30:00Z 43.57 3.97 25.0 13.0 280 6 6.21 29.970472 TRUE TRUE VFR METAR 6.0 2019-05-25 10:57:46
CWVF 251000Z AUTO 26002KT 13/12 RMK AO1 T01310121 CWVF 2019-05-25T10:00:00Z 49.1 -123.3 13.1 12.1 260 2 TRUE TRUE METAR 1.0 2019-05-25 10:57:46
PATA 250952Z AUTO 00000KT 10SM BKN060 OVC080 11/09 A3010 RMK AO2 SLP195 T01060089 TSNO PATA 2019-05-25T09:52:00Z 65.17 -152.1 10.6 8.9 0 0 10.0 30.100393 1019.5 TRUE TRUE TRUE VFR METAR 67.0 2019-05-25 10:57:46
KHOB 251035Z AUTO 11007KT 10SM OVC014 21/18 A2995 RMK AO2 KHOB 2019-05-25T10:35:00Z 32.67 -103.22 21.0 18.0 110 7 10.0 29.949802 TRUE TRUE MVFR METAR 1115.0 2019-05-25 10:57:46
KBFF 250953Z AUTO 07003KT 10SM CLR 04/03 A2998 RMK AO2 SLP134 T00440028 KBFF 2019-05-25T09:53:00Z 41.87 -103.58 4.4 2.8 70 3 10.0 29.97933 1013.4 TRUE TRUE VFR METAR 1203.0 2019-05-25 10:57:46
K3R7 251035Z AUTO 10004KT 10SM CLR 23/22 A3006 RMK AO2 T02270220 K3R7 2019-05-25T10:35:00Z 30.25 -92.67 22.7 22.0 100 4 10.0 30.059055 TRUE TRUE VFR METAR 7.0 2019-05-25 10:57:46
RPMD 251000Z 18006KT 9999 FEW015CB BKN090 BKN260 29/24 Q1008 RMK A2977 CB NNW RPMD 2019-05-25T10:00:00Z 7.12 125.65 29.0 24.0 180 6 6.21 29.763779 VFR METAR 18.0 2019-05-25 10:57:46
VHHH 251030Z 11011KT 090V160 9999 FEW012 SCT022 29/25 Q1007 NOSIG VHHH 2019-05-25T10:30:00Z 22.32 113.92 29.0 25.0 110 11 6.21 29.734253 TRUE VFR METAR 9.0 2019-05-25 10:57:46
KCIU 250956Z AUTO 13009KT 6SM BR OVC004 09/09 A2985 RMK AO2 RAE12 SLP110 P0000 T00940089 KCIU 2019-05-25T09:56:00Z 46.25 -84.47 9.4 8.9 130 9 6.0 29.84941 1011.0 TRUE TRUE BR LIFR 0.005 METAR 244.0 2019-05-25 10:57:46
KCBK 251035Z AUTO 30005KT 7SM OVC025 13/13 A2992 RMK AO2 KCBK 2019-05-25T10:35:00Z 39.43 -101.05 13.0 13.0 300 5 7.0 29.920275 TRUE TRUE MVFR METAR 971.0 2019-05-25 10:57:46
KDUH 251035Z AUTO 19005KT 10SM CLR 19/17 A2995 RMK AO2 T01860170 KDUH 2019-05-25T10:35:00Z 41.73 -83.65 18.6 17.0 190 5 10.0 29.949802 TRUE TRUE VFR METAR 204.0 2019-05-25 10:57:46
LEAS 251030Z 35004KT 290V090 9999 FEW012 SCT026 16/11 Q1026 NOSIG LEAS 2019-05-25T10:30:00Z 43.53 -6.02 16.0 11.0 350 4 6.21 30.295275 TRUE VFR METAR 134.0 2019-05-25 10:57:46
K1R7 251035Z AUTO 00000KT 5SM BR CLR 19/19 A3014 RMK AO2 K1R7 2019-05-25T10:35:00Z 31.6 -90.42 19.0 19.0 0 0 5.0 30.138779 TRUE TRUE BR MVFR METAR 149.0 2019-05-25 10:57:46
LTCT 250950Z 10009KT 060V160 9999 SCT035 26/12 Q1013 LTCT 2019-05-25T09:50:00Z 39.98 43.87 26.0 12.0 100 9 6.21 29.911417 VFR METAR 946.0 2019-05-25 10:57:46
KAFO 251035Z AUTO 00000KT 10SM SCT070 BKN080 01/01 A2999 RMK AO2 KAFO 2019-05-25T10:35:00Z 42.72 -110.95 1.0 1.0 0 0 10.0 29.991142 TRUE TRUE VFR SPECI 1897.0 2019-05-25 10:57:46
KASJ 251040Z AUTO 00000KT 7SM SCT100 17/17 A3016 RMK AO2 T01670167 KASJ 2019-05-25T10:40:00Z 36.28 -77.17 16.7 16.7 0 0 7.0 30.159449 TRUE TRUE VFR SPECI 21.0 2019-05-25 10:57:46
LYPG 251030Z 18004KT 130V250 9999 SCT030 23/15 Q1015 NOSIG LYPG 2019-05-25T10:30:00Z 42.37 19.25 23.0 15.0 180 4 6.21 29.970472 TRUE VFR METAR 43.0 2019-05-25 10:57:46
OINB 251000Z 05004KT CAVOK 28/21 Q1011 OINB 2019-05-25T10:00:00Z 36.72 52.65 28.0 21.0 50 4 6.21 29.852362 VFR METAR -15.0 2019-05-25 10:57:46
MMMM 250945Z 00000KT 6SM FEW100 16/10 A3016 RMK 8/030 HZY MMMM 2019-05-25T09:45:00Z 19.85 -101.02 16.0 10.0 0 0 6.0 30.159449 VFR METAR 1833.0 2019-05-25 10:57:46
VTST 251000Z 25010KT 9999 FEW020 32/24 Q1006 NOSIG VTST 2019-05-25T10:00:00Z 7.52 99.62 32.0 24.0 250 10 6.21 29.704725 TRUE VFR METAR 16.0 2019-05-25 10:57:46
EFJO 251020Z AUTO 14004KT 100V190 9999 OVC047 14/04 Q1002 EFJO 2019-05-25T10:20:00Z 62.67 29.62 14.0 4.0 140 4 6.21 29.586615 TRUE VFR METAR 117.0 2019-05-25 10:57:46
EHFS 251025Z AUTO 12004KT 080V160 9999 OVC039/// 15/12 Q1018 W///H/// EHFS 2019-05-25T10:25:00Z 51.45 3.6 15.0 12.0 120 4 6.21 30.059055 TRUE VFR METAR 32.0 2019-05-25 10:57:46
KVKY 251035Z AUTO 20008KT 10SM CLR 25/22 A3011 RMK A01 KVKY 2019-05-25T10:35:00Z 29.25 -88.43 25.0 22.0 200 8 10.0 30.109253 TRUE TRUE VFR METAR 32.0 2019-05-25 10:57:46
KBTM 250953Z AUTO 00000KT 10SM FEW048 BKN055 OVC070 07/04 A2993 RMK AO2 RAE12 SLP112 P0000 T00670039 KBTM 2019-05-25T09:53:00Z 45.97 -112.5 6.7 3.9 0 0 10.0 29.929134 1011.2 TRUE TRUE VFR 0.005 METAR 1688.0 2019-05-25 10:57:46
KSTE 251035Z AUTO 00000KT M1/4SM -DZ OVC002 13/13 A2978 RMK AO2 T01290129 KSTE 2019-05-25T10:35:00Z 44.55 -89.53 12.9 12.9 0 0 0.25 29.778543 TRUE TRUE -DZ LIFR METAR 338.0 2019-05-25 10:57:46
DAAY 251000Z 36014KT 9999 FEW030 BKN233 18/09 Q1017 DAAY 2019-05-25T10:00:00Z 33.53 -0.25 18.0 9.0 360 14 6.21 30.029528 VFR METAR 1149.0 2019-05-25 10:57:46
CYBU 251042Z AUTO 35013G18KT 2SM -RA BR OVC004 06/06 A2985 RMK SLP119 CYBU 2019-05-25T10:42:00Z 53.32 -104.0 6.0 6.0 350 13 18 2.0 29.84941 1011.9 TRUE -RA BR LIFR SPECI 374.0 2019-05-25 10:57:46
ULMM 251030Z 03001MPS 9999 -SHRA BKN022CB 09/M00 Q1007 R31/090070 NOSIG RMK QFE748 ULMM 2019-05-25T10:30:00Z 68.78 32.75 9.0 0.0 30 2 6.21 29.734253 TRUE -SHRA MVFR METAR 51.0 2019-05-25 10:57:46
PGUA 250956Z 07003KT 10SM SCT016 BKN200 27/24 A2990 RMK AO2A SLP115 T02710235 $ PGUA 2019-05-25T09:56:00Z 13.57 144.92 27.1 23.5 70 3 10.0 29.899607 1011.5 TRUE TRUE VFR SPECI 187.0 2019-05-25 10:57:46
NZCH 251030Z AUTO 34003KT 0400 R20/P2000N FG VV002 02/02 Q1013 BECMG 1500M BR NZCH 2019-05-25T10:30:00Z -43.47 172.55 2.0 2.0 340 3 0.25 29.911417 TRUE FG LIFR 200 METAR 34.0 2019-05-25 10:57:46

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query