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
OIAW 090930Z 18004KT 3500 HZ FEW025 BKN200 16/10 Q1020 OIAW 2019-12-09T09:30:00Z 31.32 48.77 16.0 10.0 180 4 2.17 30.11811 HZ IFR METAR 22.0 2019-12-09 09:49:49
KOWD 090853Z AUTO VRB03KT 10SM BKN043 OVC055 06/02 A3028 RMK AO2 RAB38E49 SLP253 P0000 60000 T00610017 58011 KOWD 2019-12-09T08:53:00Z 42.18 -71.17 6.1 1.7 0 3 10.0 30.280512 1025.3 TRUE TRUE VFR -1.1 0.005 SPECI 19.0 2019-12-09 09:49:49
KLVS 090853Z AUTO 21010KT 10SM 01/00 A2988 RMK AO2 RAB0759E21 SLP075 P0001 60001 T00110000 $ KLVS 2019-12-09T08:53:00Z 35.65 -105.13 1.1 0.0 210 10 10.0 29.878937 1007.5 TRUE TRUE TRUE 0.01 0.01 METAR 2091.0 2019-12-09 09:49:49
KDWX 090930Z AUTO 26007KT 190V290 4SM -SN OVC020 00/M03 A2994 RMK AO2 T10041027 KDWX 2019-12-09T09:30:00Z 41.03 -107.5 -0.4 -2.7 260 7 4.0 29.940945 TRUE TRUE -SN MVFR METAR 1996.0 2019-12-09 09:49:49
MNMG 090900Z 09006KT 9999 SCT021 24/21 Q1011 A2986 NOSIG MNMG 2019-12-09T09:00:00Z 12.15 -86.17 24.0 21.0 90 6 6.21 29.852362 TRUE VFR METAR 59.0 2019-12-09 09:49:49
KSAN 090851Z 31007KT 10SM BKN021 BKN032 16/13 A3004 RMK AO2 RAB19E31 SLP172 VCSH P0000 60000 T01610128 50000 KSAN 2019-12-09T08:51:00Z 32.73 -117.18 16.1 12.8 310 7 10.0 30.041338 1017.2 TRUE MVFR 0.0 0.005 SPECI 12.0 2019-12-09 09:49:49
KTHA 090935Z AUTO 16010KT 10SM OVC024 12/07 A2994 RMK A01 KTHA 2019-12-09T09:35:00Z 35.38 -86.25 12.0 7.0 160 10 10.0 29.940945 TRUE TRUE MVFR METAR 331.0 2019-12-09 09:49:49
KLGB 090853Z AUTO 00000KT 10SM CLR 12/11 A3002 RMK AO2 SLP165 T01220111 50000 KLGB 2019-12-09T08:53:00Z 33.82 -118.15 12.2 11.1 0 0 10.0 30.02067 1016.5 TRUE TRUE VFR 0.0 METAR 10.0 2019-12-09 09:49:49
UKLU 090930Z 12004MPS 060V170 9999 OVC043 07/02 Q1011 R10/090070 NOSIG UKLU 2019-12-09T09:30:00Z 48.63 22.27 7.0 2.0 120 8 6.21 29.852362 TRUE VFR METAR 117.0 2019-12-09 09:49:49
PAGN 090913Z AUTO 05005KT 10SM FEW005 BKN032 03/03 A3015 RMK AO2 PAGN 2019-12-09T09:13:00Z 57.5 -134.58 3.0 3.0 50 5 10.0 30.15059 TRUE TRUE VFR SPECI 2.0 2019-12-09 09:49:49
KIWI 090853Z AUTO 22007KT 200V260 10SM OVC024 04/M01 A3025 RMK AO2 SLP242 T00391006 58010 KIWI 2019-12-09T08:53:00Z 43.97 -69.72 3.9 -0.6 220 7 10.0 30.250984 1024.2 TRUE TRUE MVFR -1.0 METAR 20.0 2019-12-09 09:49:49
CYHK 090900Z AUTO 35013KT 4SM HZ CLR M35/M38 A2992 RMK SLP142 CYHK 2019-12-09T09:00:00Z 68.62 -95.83 -35.0 -38.0 350 13 4.0 29.920275 1014.2 TRUE HZ MVFR METAR 46.0 2019-12-09 09:49:49
SBPJ 090900Z 00000KT 9999 FEW008 SCT016 23/23 Q1011 SBPJ 2019-12-09T09:00:00Z -10.28 -48.37 23.0 23.0 0 0 6.21 29.852362 VFR METAR 236.0 2019-12-09 09:49:49
OIIK 090900Z 31002KT 9999 FEW035 BKN090 08/01 Q1016 OIIK 2019-12-09T09:00:00Z 36.25 50.05 8.0 1.0 310 2 6.21 30.0 VFR METAR 1278.0 2019-12-09 09:49:49
KMSL 090853Z AUTO 16012KT 10SM OVC016 16/12 A2993 RMK AO2 SLP130 T01560122 56019 $ KMSL 2019-12-09T08:53:00Z 34.75 -87.6 15.6 12.2 160 12 10.0 29.929134 1013.0 TRUE TRUE TRUE MVFR -1.9 METAR 164.0 2019-12-09 09:49:49
HELX 090900Z 36002KT CAVOK 22/12 Q1016 NOSIG HELX 2019-12-09T09:00:00Z 25.67 32.7 22.0 12.0 360 2 6.21 30.0 TRUE VFR METAR 88.0 2019-12-09 09:49:49
KMDT 090925Z 29004KT 10SM BKN012 OVC250 01/M02 A3015 RMK AO2 T00061017 KMDT 2019-12-09T09:25:00Z 40.2 -76.77 0.6 -1.7 290 4 10.0 30.15059 TRUE MVFR SPECI 95.0 2019-12-09 09:49:49
LFOJ 090930Z AUTO 26021KT 9999 FEW027 BKN034 OVC044 09/07 Q1008 TEMPO 24020G40KT 2000 TSRA SCT010 BKN020CB LFOJ 2019-12-09T09:30:00Z 47.97 1.75 9.0 7.0 260 21 6.21 29.763779 TRUE VFR METAR 125.0 2019-12-09 09:49:49
MMCZ 090845Z 10006KT 7SM SKC 21/18 A2999 RMK SLP160 57016 970 MMCZ 2019-12-09T08:45:00Z 20.52 -86.92 21.0 18.0 100 6 7.0 29.991142 1016.0 VFR -1.6 METAR 5.0 2019-12-09 09:49:49
CYBW 090900Z AUTO 31009KT 9SM BKN060 OVC070 M05/M09 A2991 RMK SLP209 CYBW 2019-12-09T09:00:00Z 51.1 -114.37 -5.0 -9.0 310 9 9.0 29.911417 1020.9 TRUE VFR METAR 1200.0 2019-12-09 09:49:49
PAMR 090853Z 29003KT 10SM FEW030 SCT130 BKN200 01/M04 A2952 RMK AO2 SLP999 T00061039 400561011 58031 $ PAMR 2019-12-09T08:53:00Z 61.22 -149.85 0.6 -3.9 290 3 10.0 29.518702 999.9 TRUE TRUE VFR -3.1 5.6 -1.1 SPECI 41.0 2019-12-09 09:49:49
PGUA 090855Z 12006KT 10SM SCT018 25/22 A2984 RMK AO2A SLP095 T02520217 $ PGUA 2019-12-09T08:55:00Z 13.57 144.92 25.2 21.7 120 6 10.0 29.840551 1009.5 TRUE TRUE VFR METAR 187.0 2019-12-09 09:49:49
ETWM 090920Z 22005KT 9999 FEW009 SCT014 BKN130 06/05 Q0994 BLU ETWM 2019-12-09T09:20:00Z 52.72 7.33 6.0 5.0 220 5 6.21 29.350393 VFR METAR 21.0 2019-12-09 09:49:49
KMBG 090852Z AUTO 33023G36KT 3SM UP OVC070 M14/M18 A2994 RMK AO2 PK WND 34036/0842 SNB30E45 SLP172 P0000 60000 T11391178 50004 KMBG 2019-12-09T08:52:00Z 45.55 -100.42 -13.9 -17.8 330 23 36 3.0 29.940945 1017.2 TRUE TRUE UP MVFR 0.4 0.005 SPECI 510.0 2019-12-09 09:49:49
SLET 090900Z 00000KT 9999 FEW080 22/21 Q1009 SLET 2019-12-09T09:00:00Z -17.8 -63.17 22.0 21.0 0 0 6.21 29.793306 VFR METAR 414.0 2019-12-09 09:49:49
DAUL 090900Z 00000KT 9999 FEW040 10/04 Q1025 DAUL 2019-12-09T09:00:00Z 33.77 2.92 10.0 4.0 0 0 6.21 30.265747 VFR METAR 765.0 2019-12-09 09:49:49
PALH 090853Z 33012KT 10SM FEW070 FEW120 01/M03 A2954 RMK AO2 SLP002 T00111033 400561006 58033 PALH 2019-12-09T08:53:00Z 61.18 -149.97 1.1 -3.3 330 12 10.0 29.53937 1000.2 TRUE VFR -3.3 5.6 -0.6 SPECI 22.0 2019-12-09 09:49:49
OISR 090900Z 11004KT 9999 FEW030CB SCT040 BKN100 20/15 Q1019 A3009 OISR 2019-12-09T09:00:00Z 27.37 53.2 20.0 15.0 110 4 6.21 30.088583 VFR METAR 408.0 2019-12-09 09:49:49
KGEV 090935Z AUTO 16007G16KT 10SM RA BKN018 BKN030 OVC075 06/02 A3008 RMK AO2 T00600023 KGEV 2019-12-09T09:35:00Z 36.43 -81.42 6.0 2.3 160 7 16 10.0 30.079725 TRUE TRUE RA MVFR SPECI 969.0 2019-12-09 09:49:49
KD07 090856Z AUTO 33013KT M14/M17 A2998 RMK AO1 SLP201 T11391167 51013 KD07 2019-12-09T08:56:00Z 45.03 -102.02 -13.9 -16.7 330 13 29.97933 1020.1 TRUE TRUE 1.3 METAR 784.0 2019-12-09 09:49:49
CXCD 090900Z AUTO 05001KT M09/M10 RMK AO1 T10901098 CXCD 2019-12-09T09:00:00Z 56.32 -119.75 -9.0 -9.8 50 1 TRUE TRUE METAR 630.0 2019-12-09 09:49:49
LSZS 090920Z VRB01KT 9999 SCT016 BKN021 M02/M04 Q1006 RMK F TL180 LSZS 2019-12-09T09:20:00Z 46.53 9.88 -2.0 -4.0 0 1 6.21 29.704725 MVFR SPECI 1706.0 2019-12-09 09:49:49
CYUY 090900Z 03008KT 3SM -FZDZ -SN BKN010 OVC017 M11/M13 A2991 RMK SF7SC1 SLP152 CYUY 2019-12-09T09:00:00Z 48.2 -78.82 -11.0 -13.0 30 8 3.0 29.911417 1015.2 -FZDZ -SN MVFR SPECI 301.0 2019-12-09 09:49:49
ENHF 090920Z VRB03KT CAVOK M05/M09 Q0979 RMK WIND 1254FT 20012KT ENHF 2019-12-09T09:20:00Z 70.67 23.67 -5.0 -9.0 0 3 6.21 28.90748 VFR 1.2 SPECI 81.0 2019-12-09 09:49:49
KSBO 090930Z AUTO 10005KT 10SM SCT110 10/06 A3014 RMK AO2 KSBO 2019-12-09T09:30:00Z 32.62 -82.37 10.0 6.0 100 5 10.0 30.138779 TRUE TRUE VFR SPECI 100.0 2019-12-09 09:49:49
ENSL 090920Z AUTO 34047KT 9999NDV -SHRA SCT022/// 05/01 Q0995 W05/S6 ENSL 2019-12-09T09:20:00Z 58.37 1.9 5.0 1.0 340 47 29.379921 TRUE -SHRA METAR 50.0 2019-12-09 09:49:49
MGGT 090900Z 36014KT 9999 BKN012 16/14 Q1025 A3027 MGGT 2019-12-09T09:00:00Z 14.57 -90.53 16.0 14.0 360 14 6.21 30.265747 MVFR METAR 1509.0 2019-12-09 09:49:49
KMCJ 090935Z AUTO VRB03KT 7SM FEW004 20/19 A2985 RMK A01 KMCJ 2019-12-09T09:35:00Z 29.72 -95.4 20.0 19.0 0 3 7.0 29.84941 TRUE TRUE VFR METAR 69.0 2019-12-09 09:49:49
KEEN 090856Z AUTO 20007KT 10SM OVC029 03/01 A3021 RMK AO2 SLP240 T00330006 58014 $ KEEN 2019-12-09T08:56:00Z 42.88 -72.27 3.3 0.6 200 7 10.0 30.209646 1024.0 TRUE TRUE TRUE MVFR -1.4 METAR 149.0 2019-12-09 09:49:49
SBCG 090900Z 14004KT 8000 -RA SCT003 BKN100 20/20 Q1012 SBCG 2019-12-09T09:00:00Z -20.47 -54.67 20.0 20.0 140 4 4.97 29.88189 -RA MVFR METAR 567.0 2019-12-09 09:49:49
KCKB 090853Z AUTO 09/06 A3000 RMK AO2 RAEMM SLP155 P0006 60009 T00940061 58016 PWINO RVRNO $ KCKB 2019-12-09T08:53:00Z 39.3 -80.22 9.4 6.1 30.0 1015.5 TRUE TRUE TRUE TRUE -1.6 0.06 SPECI 360.0 2019-12-09 09:49:49
KPLU 090935Z AUTO 00000KT 1/4SM -DZ OVC002 06/06 A3024 RMK AO2 KPLU 2019-12-09T09:35:00Z 47.1 -122.28 6.0 6.0 0 0 0.25 30.239174 TRUE TRUE -DZ LIFR METAR 164.0 2019-12-09 09:49:49
KEIK 090935Z AUTO 00000KT 10SM CLR M02/M04 A2994 RMK AO2 T10181041 KEIK 2019-12-09T09:35:00Z 40.02 -105.05 -1.8 -4.1 0 0 10.0 29.940945 TRUE TRUE VFR METAR 1564.0 2019-12-09 09:49:49
DAAE 090900Z 24006KT 9999 FEW020 BKN090 13/11 Q1023 DAAE 2019-12-09T09:00:00Z 36.72 5.07 13.0 11.0 240 6 6.21 30.206694 VFR METAR 2.0 2019-12-09 09:49:49
LEBZ 090900Z 00000KT 9000 4000NW PRFG MIFG FEW010 11/11 Q1030 LEBZ 2019-12-09T09:00:00Z 38.87 -6.82 11.0 11.0 0 0 5.59 30.413385 MIFG PRFG VFR METAR 192.0 2019-12-09 09:49:49
KSXS 090935Z AUTO 16006KT 10SM -RA OVC005 16/16 A3000 RMK AO2 RAB35 SLP159 KSXS 2019-12-09T09:35:00Z 31.37 -85.85 16.0 16.0 160 6 10.0 30.0 1015.9 TRUE TRUE -RA IFR METAR 122.0 2019-12-09 09:49:49
UCFO 090930Z VRB01MPS 6000 SCT050 BKN100 09/M00 Q1015 R12/0///95 NOSIG UCFO 2019-12-09T09:30:00Z 40.6 72.8 9.0 0.0 0 2 3.73 29.970472 TRUE MVFR METAR 884.0 2019-12-09 09:49:49
SBAF 090900Z 29002KT CAVOK 20/19 Q1013 SBAF 2019-12-09T09:00:00Z -22.87 -43.37 20.0 19.0 290 2 6.21 29.911417 VFR METAR 34.0 2019-12-09 09:49:49
PAKH 090933Z AUTO 09031G46KT OVC015 09/08 A2868 RMK AO2 PK WND 11046/0925 PWINO $ PAKH 2019-12-09T09:33:00Z 56.93 -154.18 9.0 8.0 90 31 46 28.680119 TRUE TRUE TRUE TRUE SPECI 14.0 2019-12-09 09:49:49
KORL 090853Z AUTO 00000KT 10SM CLR 16/15 A3012 RMK AO2 SLP201 T01560150 56011 KORL 2019-12-09T08:53:00Z 28.55 -81.33 15.6 15.0 0 0 10.0 30.121063 1020.1 TRUE TRUE VFR -1.1 METAR 37.0 2019-12-09 09:49:49

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query