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
KMCD 242115Z AUTO 03006KT 10SM BKN003 OVC007 01/01 A3001 RMK AO2 T00070007 KMCD 2017-03-24T21:15:00Z 45.85 -84.63 0.7 0.7 30 6 10.0 30.008858 TRUE TRUE LIFR SPECI 226.0 2017-03-24 21:41:04
KTAN 242052Z AUTO 21012G20KT 10SM OVC039 07/00 A3016 RMK AO2 PK WND 20026/2012 SLP211 60000 T00670000 56044 KTAN 2017-03-24T20:52:00Z 41.88 -71.02 6.7 0.0 210 12 20 10.0 30.159449 1021.1 TRUE TRUE VFR -4.4 0.005 METAR 7.0 2017-03-24 21:41:04
SBGO 242100Z 00000KT 9999 -RA FEW030 FEW040TCU OVC100 23/17 Q10 14 SBGO 2017-03-24T21:00:00Z -16.62 -49.22 23.0 17.0 0 0 6.21 -RA VFR SPECI 747.0 2017-03-24 21:41:04
GOSS 242100Z 34008KT 290V350 CAVOK 20/18 Q1012 GOSS 2017-03-24T21:00:00Z 16.05 -16.43 20.0 18.0 340 8 6.21 29.88189 VFR METAR 4.0 2017-03-24 21:41:04
YSDU 242100Z AUTO 05012KT 9999 // NCD 18/15 Q1016 YSDU 2017-03-24T21:00:00Z -32.22 148.57 18.0 15.0 50 12 6.21 30.0 TRUE VFR SPECI 275.0 2017-03-24 21:41:04
VVTS 242100Z VRB01KT 9999 FEW017 27/25 Q1010 NOSIG VVTS 2017-03-24T21:00:00Z 10.82 106.67 27.0 25.0 0 1 6.21 29.822834 TRUE VFR METAR 19.0 2017-03-24 21:41:04
GCHI 242130Z AUTO 05017KT 9999 FEW023/// BKN050/// 16/11 Q1019 GCHI 2017-03-24T21:30:00Z 27.82 -17.87 16.0 11.0 50 17 6.21 30.088583 TRUE VFR METAR 30.0 2017-03-24 21:41:04
PAGY 242053Z AUTO 03019G25KT 10SM FEW065 07/M06 A2964 RMK AO2 SLP035 T00671061 58013 TSNO PAGY 2017-03-24T20:53:00Z 59.47 -135.3 6.7 -6.1 30 19 25 10.0 29.639763 1003.5 TRUE TRUE TRUE VFR -1.3 METAR 5.0 2017-03-24 21:41:04
LTFJ 242120Z 04008KT 0300 R06/1100D R24/0700U BCFG SCT006 05/05 Q1021 NOSIG LTFJ 2017-03-24T21:20:00Z 40.9 29.3 5.0 5.0 40 8 0.19 30.147638 TRUE BCFG LIFR SPECI 98.0 2017-03-24 21:41:04
KHZX 242134Z AUTO 03008KT 10SM OVC022 04/00 A3014 RMK AO2 KHZX 2017-03-24T21:34:00Z 46.62 -93.32 4.0 0.0 30 8 10.0 30.138779 TRUE TRUE MVFR METAR 374.0 2017-03-24 21:41:04
KIKW 242134Z AUTO 35004KT 10SM OVC041 18/08 A2993 RMK AO2 T01810081 KIKW 2017-03-24T21:34:00Z 43.67 -84.27 18.1 8.1 350 4 10.0 29.929134 TRUE TRUE VFR METAR 194.0 2017-03-24 21:41:04
VCRI 242110Z 02002KT 9000 FEW018 23/19 Q1010 NOSIG VCRI 2017-03-24T21:10:00Z 6.28 81.13 23.0 19.0 20 2 5.59 29.822834 TRUE VFR METAR 7.0 2017-03-24 21:41:04
KDGW 242053Z AUTO VRB06KT BKN060 14/M03 A3010 RMK AO2 SLP181 T01391033 58015 KDGW 2017-03-24T20:53:00Z 42.8 -105.38 13.9 -3.3 0 6 30.100393 1018.1 TRUE TRUE -1.5 METAR 1499.0 2017-03-24 21:41:04
KGOK 242053Z AUTO 22014G25KT 10SM CLR 26/M03 A2968 RMK AO2 PK WND 22029/2023 SLP040 T02561028 56014 KGOK 2017-03-24T20:53:00Z 35.85 -97.4 25.6 -2.8 220 14 25 10.0 29.681103 1004.0 TRUE TRUE VFR -1.4 METAR 324.0 2017-03-24 21:41:04
KIXA 242120Z AUTO 22016G21KT 10SM CLR 20/08 A3034 RMK AO2 KIXA 2017-03-24T21:20:00Z 36.33 -77.63 20.0 8.0 220 16 21 10.0 30.339567 TRUE TRUE VFR SPECI 44.0 2017-03-24 21:41:04
KFSW 242115Z AUTO 24006G10KT 10SM -RA SCT024 SCT039 BKN070 16/10 A2996 RMK AO2 KFSW 2017-03-24T21:15:00Z 40.67 -91.32 16.0 10.0 240 6 10 10.0 29.958662 TRUE TRUE -RA VFR SPECI 221.0 2017-03-24 21:41:04
KLEX 242054Z 22012G18KT 10SM BKN050 24/10 A3017 RMK AO2 PK WND 22026/2004 SLP210 T02440100 56020 KLEX 2017-03-24T20:54:00Z 38.03 -84.6 24.4 10.0 220 12 18 10.0 30.171259 1021.0 TRUE VFR -2.0 METAR 300.0 2017-03-24 21:41:04
SCSE 242100Z 28007KT CAVOK 20/12 Q1014 SCSE 2017-03-24T21:00:00Z -29.92 -71.2 20.0 12.0 280 7 6.21 29.940945 VFR METAR 146.0 2017-03-24 21:41:04
CWYK 242100Z AUTO ///// M14/ A2919 RMK SLP959 CWYK 2017-03-24T21:00:00Z 57.12 -61.47 -14.0 29.190945 995.9 TRUE METAR 834.0 2017-03-24 21:41:04
SPRU 242100Z 19011KT 9999 BKN070 29/24 Q1009 RMK PP000 SPRU 2017-03-24T21:00:00Z -8.08 -79.12 29.0 24.0 190 11 6.21 29.793306 VFR METAR 30.0 2017-03-24 21:41:04
KMEV 242115Z AUTO 18010KT 10SM FEW029 BKN037 OVC045 08/01 A3010 RMK AO2 KMEV 2017-03-24T21:15:00Z 38.98 -119.75 8.0 1.0 180 10 10.0 30.100393 TRUE TRUE VFR SPECI 1439.0 2017-03-24 21:41:04
PAPM 242056Z AUTO 04010KT 10SM CLR M11/M14 A2997 RMK AO2 SLP152 T11061139 58008 FZRANO PAPM 2017-03-24T20:56:00Z 59.02 -161.82 -10.6 -13.9 40 10 10.0 29.970472 1015.2 TRUE TRUE TRUE VFR -0.8 METAR 5.0 2017-03-24 21:41:04
LGAV 242120Z 30001KT CAVOK 07/03 Q1021 NOSIG LGAV 2017-03-24T21:20:00Z 37.93 23.95 7.0 3.0 300 1 6.21 30.147638 TRUE VFR METAR 94.0 2017-03-24 21:41:04
CWHL 242100Z AUTO 15007KT 07/04 RMK AO1 2PAST HR 6006 SLP977 P0001 T00670038 50004 CWHL 2017-03-24T21:00:00Z 54.17 -130.35 6.7 3.8 150 7 997.7 TRUE TRUE 0.4 0.01 METAR 5.0 2017-03-24 21:41:04
KAPN 242054Z AUTO 34007KT 4SM -RA BR BKN006 OVC038 02/02 A3003 RMK AO2 SLP178 P0003 60003 T00220017 53017 KAPN 2017-03-24T20:54:00Z 45.07 -83.57 2.2 1.7 340 7 4.0 30.029528 1017.8 TRUE TRUE -RA BR IFR 1.7 0.03 0.03 METAR 210.0 2017-03-24 21:41:04
KMSP 242053Z 01011KT 9SM OVC019 07/02 A3007 RMK AO2 SLP189 T00720022 50004 KMSP 2017-03-24T20:53:00Z 44.88 -93.23 7.2 2.2 10 11 9.0 30.070866 1018.9 TRUE MVFR 0.4 METAR 265.0 2017-03-24 21:41:04
SBPP 242100Z 12004KT 9999 FEW025 BKN070 28/19 Q1012 SBPP 2017-03-24T21:00:00Z -22.55 -55.7 28.0 19.0 120 4 6.21 29.88189 VFR SPECI 660.0 2017-03-24 21:41:04
KOGD 242053Z 19010KT 10SM CLR 12/M02 A3015 RMK AO2 SLP201 T01221017 58021 KOGD 2017-03-24T20:53:00Z 41.2 -112.02 12.2 -1.7 190 10 10.0 30.15059 1020.1 TRUE VFR -2.1 METAR 1353.0 2017-03-24 21:41:04
KGRB 242131Z 04012KT 5SM -RA BR SCT007 BKN018 OVC042 03/02 A3007 RMK AO2 P0001 T00280022 KGRB 2017-03-24T21:31:00Z 44.48 -88.13 2.8 2.2 40 12 5.0 30.070866 TRUE -RA BR MVFR 0.01 SPECI 208.0 2017-03-24 21:41:04
KOWX 242135Z AUTO 22023G30KT 10SM SCT050 23/12 A3001 RMK AO1 KOWX 2017-03-24T21:35:00Z 41.03 -83.98 23.0 12.0 220 23 30 10.0 30.008858 TRUE TRUE VFR METAR 233.0 2017-03-24 21:41:04
CYMX 242100Z 11004KT 3/4SM R24/3500FT/U R11/3500FT/N -SN VV006 M01/M01 A3000 RMK SN8 CIG VRB 4-8 /S02/ SLP166 CYMX 2017-03-24T21:00:00Z 45.67 -74.02 -1.0 -1.0 110 4 0.75 30.0 1016.6 -SN LIFR 600 METAR 82.0 2017-03-24 21:41:04
KGYL 242116Z AUTO 01007KT 7SM OVC015 06/04 A3009 RMK AO2 T00620041 KGYL 2017-03-24T21:16:00Z 44.77 -94.08 6.2 4.1 10 7 7.0 30.088583 TRUE TRUE MVFR SPECI 302.0 2017-03-24 21:41:04
PANN 242053Z AUTO 00000KT 10SM CLR M14/M21 A3004 RMK AO2 SLP189 T11391206 56007 TSNO PANN 2017-03-24T20:53:00Z 64.55 -149.08 -13.9 -20.6 0 0 10.0 30.041338 1018.9 TRUE TRUE TRUE VFR -0.7 METAR 110.0 2017-03-24 21:41:04
KEVW 242053Z AUTO VRB03KT 10SM CLR 07/M02 A3018 RMK AO2 SLP203 T00721017 58013 KEVW 2017-03-24T20:53:00Z 41.27 -111.03 7.2 -1.7 0 3 10.0 30.180119 1020.3 TRUE TRUE VFR -1.3 METAR 2177.0 2017-03-24 21:41:04
CXHR 242100Z AUTO 14015KT 03/03 RMK AO1 PK WND 13020/2038 T00340034 CXHR 2017-03-24T21:00:00Z 51.18 -112.5 3.4 3.4 140 15 TRUE TRUE METAR 971.0 2017-03-24 21:41:04
KMAN 242135Z AUTO 11013KT 3SM HZ SCT047 BKN055 10/06 A2998 RMK A01 KMAN 2017-03-24T21:35:00Z 43.58 -116.52 10.0 6.0 110 13 3.0 29.97933 TRUE TRUE HZ MVFR METAR 774.0 2017-03-24 21:41:04
KZPH 242135Z AUTO 11005KT 10SM BKN070 26/11 A3024 RMK AO2 T02620111 KZPH 2017-03-24T21:35:00Z 28.23 -82.15 26.2 11.1 110 5 10.0 30.239174 TRUE TRUE VFR SPECI 26.0 2017-03-24 21:41:04
KVIH 242053Z AUTO 19018G29KT 10SM BKN065 22/11 A2992 RMK AO2 PK WND 18029/2051 SLP121 T02220111 56017 $ KVIH 2017-03-24T20:53:00Z 38.13 -91.77 22.2 11.1 190 18 29 10.0 29.920275 1012.1 TRUE TRUE TRUE VFR -1.7 METAR 333.0 2017-03-24 21:41:04
PASN 242053Z AUTO 08022G30KT 9SM -SN OVC013 M03/M07 A2980 RMK AO2 PK WND 08031/2017 SLP092 P0000 60000 T10331067 58018 TSNO PASN 2017-03-24T20:53:00Z 57.15 -170.22 -3.3 -6.7 80 22 30 9.0 29.799213 1009.2 TRUE TRUE TRUE -SN MVFR -1.8 0.005 0.005 METAR 29.0 2017-03-24 21:41:04
KAYS 242115Z AUTO 12008G20KT 10SM BKN060 25/12 A3031 RMK AO2 T02490119 KAYS 2017-03-24T21:15:00Z 31.25 -82.4 24.9 11.9 120 8 20 10.0 30.31004 TRUE TRUE VFR METAR 46.0 2017-03-24 21:41:04
KAGC 242053Z 22016G24KT 10SM CLR 23/08 A3006 RMK AO2 PK WND 22026/2003 SLP184 T02280078 56021 KAGC 2017-03-24T20:53:00Z 40.35 -79.92 22.8 7.8 220 16 24 10.0 30.059055 1018.4 TRUE VFR -2.1 METAR 389.0 2017-03-24 21:41:04
KRVS 242053Z 15011G19KT 10SM FEW029 SCT037 22/13 A2975 RMK AO2 SLP077 T02170133 55018 KRVS 2017-03-24T20:53:00Z 36.05 -95.98 21.7 13.3 150 11 19 10.0 29.749016 1007.7 TRUE VFR -1.8 METAR 200.0 2017-03-24 21:41:04
PAPH 242056Z AUTO 04016KT 10SM CLR M05/M12 A2989 RMK AO2 SLP125 T10501117 56014 FZRANO PAPH 2017-03-24T20:56:00Z 56.95 -158.62 -5.0 -11.7 40 16 10.0 29.890747 1012.5 TRUE TRUE TRUE VFR -1.4 METAR 29.0 2017-03-24 21:41:04
UTDT 242130Z 00000MPS 9999 FEW/// SCT/// 13/09 Q1015 35CLRD70 RMK QFE722/0963 UTDT 2017-03-24T21:30:00Z 37.87 68.87 13.0 9.0 0 0 6.21 29.970472 METAR 449.0 2017-03-24 21:41:04
PAWS 242116Z AUTO 29007KT 10SM CLR M03/M14 A2985 RMK AO1 PAWS 2017-03-24T21:16:00Z 61.57 -149.53 -3.0 -14.0 290 7 10.0 29.84941 TRUE TRUE VFR SPECI 107.0 2017-03-24 21:41:04
SLCB 242100Z 14004KT 9999 SCT027 22/10 Q1021 SLCB 2017-03-24T21:00:00Z -17.42 -66.18 22.0 10.0 140 4 6.21 30.147638 VFR METAR 2548.0 2017-03-24 21:41:04
K4A9 242115Z AUTO 18005KT 10SM SCT049 22/07 A3026 RMK AO2 K4A9 2017-03-24T21:15:00Z 34.47 -85.72 22.0 7.0 180 5 10.0 30.259842 TRUE TRUE VFR METAR 267.0 2017-03-24 21:41:04
LIVE 242055Z 36003KT CAVOK 03/M00 Q1025 RMK SKC VIS MIN 9999 LIVE 2017-03-24T20:55:00Z 46.85 10.5 3.0 0.0 360 3 6.21 30.265747 VFR METAR 1800.0 2017-03-24 21:41:04
OTBD 242100Z 07011KT CAVOK 22/19 Q1008 NOSIG OTBD 2017-03-24T21:00:00Z 25.25 51.57 22.0 19.0 70 11 6.21 29.763779 TRUE VFR METAR 10.0 2017-03-24 21:41:04
KSGJ 242058Z 08010KT 10SM FEW042 22/16 A3034 RMK AO2 SLP273 T02220156 56018 KSGJ 2017-03-24T20:58:00Z 29.97 -81.32 22.2 15.6 80 10 10.0 30.339567 1027.3 TRUE VFR -1.8 METAR 3.0 2017-03-24 21:41:04

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query