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
SBSV 200500Z 08009KT 9999 SCT020 25/21 Q1016 SBSV 2019-09-20T05:00:00Z -12.9 -38.32 25.0 21.0 80 9 6.21 30.0 VFR METAR 6.0 2019-09-20 05:14:27
KHSV 200453Z 13011KT 10SM CLR 24/16 A3015 RMK AO2 SLP203 T02390156 KHSV 2019-09-20T04:53:00Z 34.65 -86.78 23.9 15.6 130 11 10.0 30.15059 1020.3 TRUE VFR METAR 191.0 2019-09-20 05:14:28
KBDG 200455Z AUTO 18009KT 10SM 19/M01 A2998 RMK AO1 T01931007 KBDG 2019-09-20T04:55:00Z 37.58 -109.47 19.3 -0.7 180 9 10.0 29.97933 TRUE TRUE METAR 1788.0 2019-09-20 05:14:28
KPIM 200455Z AUTO 09010KT 10SM CLR 22/09 A3021 RMK AO2 T02150090 KPIM 2019-09-20T04:55:00Z 32.83 -84.88 21.5 9.0 90 10 10.0 30.209646 TRUE TRUE VFR METAR 275.0 2019-09-20 05:14:28
KHRT 200456Z 07006KT 10SM SCT200 27/16 A3007 RMK AO2A SLP184 T02650164 $ KHRT 2019-09-20T04:56:00Z 30.42 -86.67 26.5 16.4 70 6 10.0 30.070866 1018.4 TRUE TRUE VFR METAR 12.0 2019-09-20 05:14:27
EBAW 200450Z VRB01KT CAVOK 06/05 Q1029 NOSIG EBAW 2019-09-20T04:50:00Z 51.2 4.47 6.0 5.0 0 1 6.21 30.383858 TRUE VFR METAR 14.0 2019-09-20 05:14:28
KAKH 200454Z AUTO 00000KT 10SM CLR 14/11 A3028 RMK AO2 SLP251 T01390111 402610139 KAKH 2019-09-20T04:54:00Z 35.2 -81.15 13.9 11.1 0 0 10.0 30.280512 1025.1 TRUE TRUE VFR 26.1 13.9 METAR 243.0 2019-09-20 05:14:28
KSLR 200455Z AUTO 14007KT 7SM -RA OVC010 23/23 A2996 RMK AO2 P0001 T02280225 KSLR 2019-09-20T04:55:00Z 33.17 -95.62 22.8 22.5 140 7 7.0 29.958662 TRUE TRUE -RA MVFR 0.01 SPECI 149.0 2019-09-20 05:14:28
KDTA 200455Z AUTO 35008G14KT 10SM CLR 11/00 A2990 RMK AO1 KDTA 2019-09-20T04:55:00Z 39.38 -112.5 11.0 0.0 350 8 14 10.0 29.899607 TRUE TRUE VFR METAR 1402.0 2019-09-20 05:14:28
KHSG 200455Z AUTO 01008KT 330V030 10SM CLR 15/06 A2985 RMK AO2 T01480055 KHSG 2019-09-20T04:55:00Z 43.72 -108.38 14.8 5.5 10 8 10.0 29.84941 TRUE TRUE VFR METAR 1494.0 2019-09-20 05:14:28
HTIR 200400Z 17004KT 9999 FEW020 17/10 Q1021 HTIR 2019-09-20T04:00:00Z -7.67 35.75 17.0 10.0 170 4 6.21 30.147638 VFR METAR 1428.0 2019-09-20 05:14:28
MUCL 200405Z AUTO 05015KT 27/23 Q1011 MUCL 2019-09-20T04:05:00Z 21.63 -81.55 27.0 23.0 50 15 29.852362 TRUE METAR 5.0 2019-09-20 05:14:28
KSME 200455Z AUTO 00000KT 10SM CLR 21/15 A3018 RMK AO2 KSME 2019-09-20T04:55:00Z 37.05 -84.62 21.0 15.0 0 0 10.0 30.180119 TRUE TRUE VFR METAR 283.0 2019-09-20 05:14:28
SBRJ 200500Z 09003KT 6000 SCT020 23/23 Q1009 SBRJ 2019-09-20T05:00:00Z -22.88 -43.17 23.0 23.0 90 3 3.73 29.793306 MVFR METAR 3.0 2019-09-20 05:14:27
KFNB 200453Z AUTO 13004KT 10SM CLR 23/21 A2997 RMK AO2 SLP139 T02280211 KFNB 2019-09-20T04:53:00Z 40.07 -95.58 22.8 21.1 130 4 10.0 29.970472 1013.9 TRUE TRUE VFR METAR 300.0 2019-09-20 05:14:28
K1KM 200458Z AUTO 35013KT 10SM BKN140 BKN200 11/06 A2988 RMK AO2 SLP112 T01130058 $ K1KM 2019-09-20T04:58:00Z 46.45 -109.8 11.3 5.8 350 13 10.0 29.878937 1011.2 TRUE TRUE TRUE VFR METAR 1330.0 2019-09-20 05:14:27
KLUX 200455Z AUTO 02004KT 10SM CLR 13/12 A3028 RMK AO2 KLUX 2019-09-20T04:55:00Z 34.5 -81.95 13.0 12.0 20 4 10.0 30.280512 TRUE TRUE VFR METAR 213.0 2019-09-20 05:14:28
KAAO 200454Z AUTO 15007KT 10SM CLR 24/20 A2996 RMK AO2 SLP131 T02440200 KAAO 2019-09-20T04:54:00Z 37.75 -97.22 24.4 20.0 150 7 10.0 29.958662 1013.1 TRUE TRUE VFR METAR 434.0 2019-09-20 05:14:28
KLCK 200455Z AUTO 13006KT 10SM CLR 19/12 A3014 RMK AO2 T01910118 KLCK 2019-09-20T04:55:00Z 39.82 -82.92 19.1 11.8 130 6 10.0 30.138779 TRUE TRUE VFR SPECI 227.0 2019-09-20 05:14:28
OODQ 200450Z AUTO 23009KT 9999 OVC015 26/23 Q1011 NOSIG OODQ 2019-09-20T04:50:00Z 19.52 57.65 26.0 23.0 230 9 6.21 29.852362 TRUE TRUE MVFR METAR 0.0 2019-09-20 05:14:28
ENBS 200450Z 35021KT 7000 -RA SCT010 BKN018 04/02 Q1001 ENBS 2019-09-20T04:50:00Z 70.62 29.72 4.0 2.0 350 21 4.35 29.557087 -RA MVFR METAR 10.0 2019-09-20 05:14:28
KVES 200455Z AUTO 14004KT 7SM CLR 19/17 A3012 RMK AO2 KVES 2019-09-20T04:55:00Z 40.2 -84.53 19.0 17.0 140 4 7.0 30.121063 TRUE TRUE VFR METAR 307.0 2019-09-20 05:14:28
SCIP 200500Z 09005KT 9999 SCT025 16/13 Q1029 NOSIG SCIP 2019-09-20T05:00:00Z -27.17 -109.43 16.0 13.0 90 5 6.21 30.383858 TRUE VFR METAR 69.0 2019-09-20 05:14:27
K04W 200456Z AUTO 00000KT 10SM CLR 15/15 A3004 RMK AO2 K04W 2019-09-20T04:56:00Z 46.02 -92.9 15.0 15.0 0 0 10.0 30.041338 TRUE TRUE VFR METAR 311.0 2019-09-20 05:14:27
PTPN 200404Z 30011KT 15SM SCT018 BKN300 31/26 A2974 RMK LAST PTPN 2019-09-20T04:04:00Z 6.97 158.22 31.0 26.0 300 11 15.0 29.740158 VFR METAR 2.0 2019-09-20 05:14:28
LLIB 200450Z VRB03KT 8000 NSC 25/19 Q1013 LLIB 2019-09-20T04:50:00Z 32.98 35.57 25.0 19.0 0 3 4.97 29.911417 MVFR METAR 282.0 2019-09-20 05:14:28
KVEL 200453Z AUTO VRB05KT 10SM CLR 17/01 A2976 RMK AO2 SLP015 T01670011 $ KVEL 2019-09-20T04:53:00Z 40.45 -109.52 16.7 1.1 0 5 10.0 29.760826 1001.5 TRUE TRUE TRUE VFR METAR 1604.0 2019-09-20 05:14:28
VLLB 200500Z 14002KT 9999 SCT020 31/24 Q1010 NOSIG VLLB 2019-09-20T05:00:00Z 19.9 102.17 31.0 24.0 140 2 6.21 29.822834 TRUE VFR METAR 291.0 2019-09-20 05:14:27
SBBE 200500Z 07006KT 8000 NSC 24/22 Q1010 SBBE 2019-09-20T05:00:00Z -1.37 -48.47 24.0 22.0 70 6 4.97 29.822834 MVFR METAR 16.0 2019-09-20 05:14:27
KCKB 200453Z AUTO 00000KT 10SM CLR 14/09 A3021 RMK AO2 SLP220 T01440094 402780106 KCKB 2019-09-20T04:53:00Z 39.3 -80.22 14.4 9.4 0 0 10.0 30.209646 1022.0 TRUE TRUE VFR 27.8 10.6 METAR 360.0 2019-09-20 05:14:28
RJCM 200500Z 01011KT 9999 -SHRA FEW010 SCT015 BKN020 14/10 Q1011 RJCM 2019-09-20T05:00:00Z 43.88 144.17 14.0 10.0 10 11 6.21 29.852362 -SHRA MVFR METAR 36.0 2019-09-20 05:14:27
KBOI 200453Z AUTO 29006KT 10SM OVC085 13/08 A2992 RMK AO2 SLP125 T01280078 KBOI 2019-09-20T04:53:00Z 43.57 -116.23 12.8 7.8 290 6 10.0 29.920275 1012.5 TRUE TRUE VFR METAR 875.0 2019-09-20 05:14:28
KVKS 200455Z AUTO VRB05KT 10SM CLR 24/22 A3004 RMK A01 KVKS 2019-09-20T04:55:00Z 32.23 -90.93 24.0 22.0 0 5 10.0 30.041338 TRUE TRUE VFR METAR 32.0 2019-09-20 05:14:28
KLVM 200453Z AUTO 28009KT 10SM CLR 12/05 A2991 RMK AO2 SLP105 T01170050 KLVM 2019-09-20T04:53:00Z 45.7 -110.43 11.7 5.0 280 9 10.0 29.911417 1010.5 TRUE TRUE VFR SPECI 1418.0 2019-09-20 05:14:28
CXKT 200400Z AUTO 19003KT 06/04 RMK AO1 SLP216 T00580038 58014 CXKT 2019-09-20T04:00:00Z 45.07 -64.48 5.8 3.8 190 3 1021.6 TRUE TRUE -1.4 METAR 49.0 2019-09-20 05:14:28
LPPD 200500Z 27010KT 9999 SCT005 BKN010 22/21 Q1014 LPPD 2019-09-20T05:00:00Z 37.72 -25.68 22.0 21.0 270 10 6.21 29.940945 MVFR METAR 72.0 2019-09-20 05:14:27
KIKK 200455Z AUTO 14003KT 10SM CLR 19/16 A3007 RMK AO2 LTG DSNT NW T01890160 KIKK 2019-09-20T04:55:00Z 41.07 -87.85 18.9 16.0 140 3 10.0 30.070866 TRUE TRUE VFR METAR 192.0 2019-09-20 05:14:28
CZZJ 200400Z AUTO 28002KT 09/07 RMK AO1 2PAST HR SOG 03 0000 SLP116 P0001 T00860072 50002 CZZJ 2019-09-20T04:00:00Z 53.58 -116.47 8.6 7.2 280 2 1011.6 TRUE TRUE 0.2 0.01 METAR 927.0 2019-09-20 05:14:28
KSAA 200455Z AUTO 13004KT 10SM CLR 13/M02 A2995 RMK AO2 KSAA 2019-09-20T04:55:00Z 41.45 -106.83 13.0 -2.0 130 4 10.0 29.949802 TRUE TRUE VFR METAR 2138.0 2019-09-20 05:14:28
CWCF 200400Z AUTO 09006KT 10/09 RMK AO1 SLP167 T01040086 58005 CWCF 2019-09-20T04:00:00Z 52.35 -97.03 10.4 8.6 90 6 1016.7 TRUE TRUE -0.5 METAR 222.0 2019-09-20 05:14:28
KJES 200501Z AUTO 03005KT 10SM CLR 20/16 A3018 RMK AO2 KJES 2019-09-20T05:01:00Z 31.55 -81.88 20.0 16.0 30 5 10.0 30.180119 TRUE TRUE VFR SPECI 33.0 2019-09-20 05:14:27
LZTT 200500Z 25006KT 9999 FEW010 SCT043 04/02 Q1025 NOSIG LZTT 2019-09-20T05:00:00Z 49.07 20.25 4.0 2.0 250 6 6.21 30.265747 TRUE VFR METAR 707.0 2019-09-20 05:14:27
KWJF 200456Z AUTO 25011KT 10SM CLR 17/06 A2988 RMK AO2 SLP107 T01670056 KWJF 2019-09-20T04:56:00Z 34.72 -118.22 16.7 5.6 250 11 10.0 29.878937 1010.7 TRUE TRUE VFR METAR 715.0 2019-09-20 05:14:27
KCDA 200458Z AUTO 00000KT 10SM CLR 06/05 A3026 RMK AO2 T00600050 402001015 KCDA 2019-09-20T04:58:00Z 44.57 -72.02 6.0 5.0 0 0 10.0 30.259842 TRUE TRUE VFR 20.0 -1.5 METAR 363.0 2019-09-20 05:14:27
NVVV 200500Z 07013KT 9999 SCT025 BKN300 26/19 Q1015 NVVV 2019-09-20T05:00:00Z -17.68 168.3 26.0 19.0 70 13 6.21 29.970472 VFR METAR 21.0 2019-09-20 05:14:27
KDIK 200456Z AUTO 14013KT 10SM CLR 19/17 A2975 RMK AO2 SLP058 T01890172 KDIK 2019-09-20T04:56:00Z 46.8 -102.8 18.9 17.2 140 13 10.0 29.749016 1005.8 TRUE TRUE VFR METAR 788.0 2019-09-20 05:14:27
KRHV 200453Z 00000KT 10SM SKC 18/12 A2993 RMK LAST KRHV 2019-09-20T04:53:00Z 37.32 -121.82 18.0 12.0 0 0 10.0 29.929134 VFR METAR 41.0 2019-09-20 05:14:28
RPVP 200500Z 18010KT 6000 FEW019 32/25 Q1009 RMK A2980 RPVP 2019-09-20T05:00:00Z 9.75 118.72 32.0 25.0 180 10 3.73 29.793306 MVFR METAR 16.0 2019-09-20 05:14:27
GVAC 200500Z 04011KT 9999 BKN014 27/22 Q1012 NOSIG GVAC 2019-09-20T05:00:00Z 16.72 -22.93 27.0 22.0 40 11 6.21 29.88189 TRUE MVFR METAR 55.0 2019-09-20 05:14:27
KSFB 200453Z AUTO 10005KT 10SM FEW060 22/19 A3007 RMK AO2 SLP179 T02220194 403060217 KSFB 2019-09-20T04:53:00Z 28.77 -81.22 22.2 19.4 100 5 10.0 30.070866 1017.9 TRUE TRUE VFR 30.6 21.7 METAR 17.0 2019-09-20 05:14:28

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query