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
KIXD 201653Z 30010KT 10SM BKN018 BKN024 10/06 A3016 RMK AO2 SLP215 T01000056 KIXD 2019-03-20T16:53:00Z 38.82 -94.88 10.0 5.6 300 10 10.0 30.159449 1021.5 TRUE MVFR METAR 342.0 2019-03-20 17:09:16
KLOT 201635Z AUTO 19010KT 5SM BR OVC007 04/03 A3001 RMK AO2 T00380031 KLOT 2019-03-20T16:35:00Z 41.6 -88.1 3.8 3.1 190 10 5.0 30.008858 TRUE TRUE BR IFR SPECI 205.0 2019-03-20 17:09:16
KBRO 201653Z 06004KT 2SM -RA BR BKN017 BKN024 OVC028 19/19 A3020 RMK AO2 SLP226 P0004 T01940194 KBRO 2019-03-20T16:53:00Z 25.92 -97.42 19.4 19.4 60 4 2.0 30.200787 1022.6 TRUE -RA BR IFR 0.04 METAR 7.0 2019-03-20 17:09:16
KMDW 201653Z 20013G25KT 7SM OVC010 05/03 A3001 RMK AO2 RAE50 SLP168 P0000 T00500028 KMDW 2019-03-20T16:53:00Z 41.78 -87.75 5.0 2.8 200 13 25 7.0 30.008858 1016.8 TRUE MVFR 0.005 METAR 188.0 2019-03-20 17:09:16
CYFS 201600Z 34012KT 15SM FEW210 05/M03 A3009 RMK CI2 SLP200 CYFS 2019-03-20T16:00:00Z 61.75 -121.22 5.0 -3.0 340 12 15.0 30.088583 1020.0 VFR METAR 169.0 2019-03-20 17:09:16
CYGP 201600Z 10007KT 15SM BKN140 BKN200 M03/M10 A3010 RMK AC5CI1 CI TR SLP199 CYGP 2019-03-20T16:00:00Z 48.77 -64.47 -3.0 -10.0 100 7 15.0 30.100393 1019.9 VFR METAR 33.0 2019-03-20 17:09:16
CZFN 201600Z 32007KT 20SM BKN066 04/M02 A3021 RMK AC5 PRESRR SLP238 CZFN 2019-03-20T16:00:00Z 64.92 -125.57 4.0 -2.0 320 7 20.0 30.209646 1023.8 VFR METAR 98.0 2019-03-20 17:09:16
KSFF 201653Z 00000KT 10SM CLR 08/M01 A3010 RMK AO2 SLP198 T00831011 PNO $ KSFF 2019-03-20T16:53:00Z 47.68 -117.32 8.3 -1.1 0 0 10.0 30.100393 1019.8 TRUE TRUE VFR METAR 609.0 2019-03-20 17:09:16
NCMR 201700Z AUTO 09005KT //// ////// Q1009 NCMR 2019-03-20T17:00:00Z -19.85 -157.7 90 5 29.793306 TRUE METAR 8.0 2019-03-20 17:09:16
MWCR 201600Z 20009KT 9999 FEW018 28/22 Q1016 MWCR 2019-03-20T16:00:00Z 19.3 -81.37 28.0 22.0 200 9 6.21 30.0 VFR METAR 3.0 2019-03-20 17:09:16
UUOO 201630Z 35003MPS 9000 4300NW -RA BR OVC015 03/03 Q1025 R30/290150 NOSIG RMK QFE755 UUOO 2019-03-20T16:30:00Z 51.82 39.23 3.0 3.0 350 6 5.59 30.265747 TRUE -RA BR MVFR METAR 157.0 2019-03-20 17:09:16
ESSD 201650Z AUTO 27009KT 9999 NCD 07/M03 Q1016 ESSD 2019-03-20T16:50:00Z 60.42 15.5 7.0 -3.0 270 9 6.21 30.0 TRUE VFR METAR 161.0 2019-03-20 17:09:16
KOMH 201635Z AUTO 09004KT 10SM CLR 09/M05 A3034 RMK AO2 KOMH 2019-03-20T16:35:00Z 38.25 -78.05 9.0 -5.0 90 4 10.0 30.339567 TRUE TRUE VFR SPECI 142.0 2019-03-20 17:09:16
KUOX 201655Z AUTO VRB05KT 10SM CLR 16/M05 A3023 RMK AO2 KUOX 2019-03-20T16:55:00Z 34.38 -89.53 16.0 -5.0 0 5 10.0 30.230314 TRUE TRUE VFR METAR 137.0 2019-03-20 17:09:16
KLYO 201655Z AUTO 29012G16KT 10SM CLR 10/01 A3024 RMK AO2 T00960013 KLYO 2019-03-20T16:55:00Z 38.35 -98.23 9.6 1.3 290 12 16 10.0 30.239174 TRUE TRUE VFR METAR 515.0 2019-03-20 17:09:16
OISS 201630Z 00000KT 9999 FEW040 14/M09 Q1016 A3001 OISS 2019-03-20T16:30:00Z 29.52 52.57 14.0 -9.0 0 0 6.21 30.0 VFR METAR 1491.0 2019-03-20 17:09:16
CXSE 201600Z AUTO 33005KT M27/M30 RMK AO1 SOG 43 3012 SLP043 T12691295 CXSE 2019-03-20T16:00:00Z 73.77 -105.28 -26.9 -29.5 330 5 1004.3 TRUE TRUE METAR 11.0 2019-03-20 17:09:16
KUAO 201653Z 04007KT 10SM CLR 18/00 A2983 RMK AO2 SLP101 T01830000 $ KUAO 2019-03-20T16:53:00Z 45.25 -122.77 18.3 0.0 40 7 10.0 29.828741 1010.1 TRUE TRUE VFR METAR 59.0 2019-03-20 17:09:16
CXRB 201600Z AUTO 00000KT M27/M29 RMK AO1 2PAST HR SOG 03 6004 SLP039 P0001 T12701290 50012 CXRB 2019-03-20T16:00:00Z 74.72 -94.98 -27.0 -29.0 0 0 1003.9 TRUE TRUE 1.2 0.01 METAR 68.0 2019-03-20 17:09:16
YBRM 201630Z AUTO 04007KT 9999 // NCD 27/24 Q1007 RF00.0/000.0 YBRM 2019-03-20T16:30:00Z -17.93 122.22 27.0 24.0 40 7 6.21 29.734253 TRUE VFR SPECI 9.0 2019-03-20 17:09:16
K82V 201655Z AUTO 33018G23KT 10SM CLR 08/M12 A3027 RMK AO2 K82V 2019-03-20T16:55:00Z 41.15 -104.13 8.0 -12.0 330 18 23 10.0 30.268702 TRUE TRUE VFR METAR 1570.0 2019-03-20 17:09:16
KRRT 201655Z AUTO 01009KT 10SM CLR 04/M01 A3005 RMK AO2 KRRT 2019-03-20T16:55:00Z 48.93 -95.33 4.0 -1.0 10 9 10.0 30.050198 TRUE TRUE VFR METAR 327.0 2019-03-20 17:09:16
ESSV 201650Z 25010KT CAVOK 04/03 Q1019 R21/19//79 ESSV 2019-03-20T16:50:00Z 57.67 18.35 4.0 3.0 250 10 6.21 30.088583 VFR METAR 47.0 2019-03-20 17:09:16
KMGG 201655Z AUTO 00000KT 10SM CLR 06/00 A2993 RMK AO2 T00560002 KMGG 2019-03-20T16:55:00Z 45.23 -93.98 5.6 0.2 0 0 10.0 29.929134 TRUE TRUE VFR METAR 313.0 2019-03-20 17:09:16
CWQK 201600Z AUTO 06014KT 12/02 RMK AO1 PK WND 02020/1536 SLP136 T01210016 55000 CWQK 2019-03-20T16:00:00Z 48.3 -123.53 12.1 1.6 60 14 1013.6 TRUE TRUE 0.0 METAR 5.0 2019-03-20 17:09:16
KANJ 201655Z AUTO 18005KT 7SM FEW008 OVC015 04/01 A2991 RMK AO2 UPE1558 SLP135 P0000 T00390011 KANJ 2019-03-20T16:55:00Z 46.47 -84.37 3.9 1.1 180 5 7.0 29.911417 1013.5 TRUE TRUE MVFR 0.005 METAR 218.0 2019-03-20 17:09:16
RODN 201656Z AUTO 16010KT 10SM OVC047 22/20 A2994 RMK AO2 SLP145 T02200197 $ RODN 2019-03-20T16:56:00Z 26.35 127.77 22.0 19.7 160 10 10.0 29.940945 1014.5 TRUE TRUE TRUE VFR METAR 45.0 2019-03-20 17:09:16
KOCW 201640Z AUTO 03012G17KT 10SM -RA OVC027 10/06 A3026 RMK AO2 T01010063 KOCW 2019-03-20T16:40:00Z 35.57 -77.05 10.1 6.3 30 12 17 10.0 30.259842 TRUE TRUE -RA MVFR METAR 12.0 2019-03-20 17:09:16
KDCM 201655Z AUTO 04011G18KT 7SM CLR 13/M05 A3026 RMK AO2 KDCM 2019-03-20T16:55:00Z 34.78 -81.2 13.0 -5.0 40 11 18 7.0 30.259842 TRUE TRUE VFR METAR 200.0 2019-03-20 17:09:16
KCMI 201653Z 19014KT 10SM BKN035 OVC055 07/04 A3004 RMK AO2 SLP177 T00670044 KCMI 2019-03-20T16:53:00Z 40.03 -88.27 6.7 4.4 190 14 10.0 30.041338 1017.7 TRUE VFR METAR 228.0 2019-03-20 17:09:16
KDXX 201656Z AUTO 31010KT 10SM CLR A3002 RMK AO2 KDXX 2019-03-20T16:56:00Z 44.98 -96.18 310 10 10.0 30.02067 TRUE TRUE VFR METAR 330.0 2019-03-20 17:09:16
UUWW 201630Z 24004MPS 9999 BKN047 03/M03 Q1022 R24/000070 NOSIG UUWW 2019-03-20T16:30:00Z 55.6 37.27 3.0 -3.0 240 8 6.21 30.177166 TRUE VFR METAR 203.0 2019-03-20 17:09:16
LICB 201550Z 05015KT 020V080 9999 FEW020 14/10 Q1015 LICB 2019-03-20T15:50:00Z 37.0 14.62 14.0 10.0 50 15 6.21 29.970472 VFR METAR 220.0 2019-03-20 17:09:16
KODO 201653Z AUTO 08012KT 10SM 11/04 A3034 RMK AO2 SLP254 T01060039 KODO 2019-03-20T16:53:00Z 31.92 -102.4 10.6 3.9 80 12 10.0 30.339567 1025.4 TRUE TRUE METAR 902.0 2019-03-20 17:09:16
EGCC 201650Z 20004KT 9999 SCT031 17/12 Q1029 NOSIG EGCC 2019-03-20T16:50:00Z 53.35 -2.27 17.0 12.0 200 4 6.21 30.383858 TRUE VFR METAR 78.0 2019-03-20 17:09:16
KDUH 201656Z AUTO 21008G14KT 170V230 10SM SCT070 OVC090 10/M01 A3012 RMK AO2 T01001013 KDUH 2019-03-20T16:56:00Z 41.73 -83.65 10.0 -1.3 210 8 14 10.0 30.121063 TRUE TRUE VFR METAR 204.0 2019-03-20 17:09:16
KRTN 201653Z AUTO 04004KT 10SM CLR M01/M04 A3034 RMK AO2 SLP285 T10111039 KRTN 2019-03-20T16:53:00Z 36.73 -104.5 -1.1 -3.9 40 4 10.0 30.339567 1028.5 TRUE TRUE VFR METAR 1936.0 2019-03-20 17:09:16
CWJH 201600Z AUTO 24004KT 07/M01 RMK AO1 SOG 46 8025 SLP149 T00661013 CWJH 2019-03-20T16:00:00Z 56.32 -103.27 6.6 -1.3 240 4 1014.9 TRUE TRUE METAR 344.0 2019-03-20 17:09:16
TFFF 201630Z AUTO 11017KT 9999 FEW035 SCT058 29/20 Q1015 BECMG 10006KT TFFF 2019-03-20T16:30:00Z 14.6 -61.0 29.0 20.0 110 17 6.21 29.970472 TRUE VFR 0.6 METAR 5.0 2019-03-20 17:09:16
KFDY 201653Z AUTO 21014KT 10SM BKN075 BKN090 10/M03 A3013 RMK AO2 SLP205 T01001028 KFDY 2019-03-20T16:53:00Z 41.02 -83.67 10.0 -2.8 210 14 10.0 30.129921 1020.5 TRUE TRUE VFR METAR 247.0 2019-03-20 17:09:16
CXOX 201600Z AUTO 24004KT 07/M02 RMK AO1 SOG 34 8012 SLP170 T00741022 CXOX 2019-03-20T16:00:00Z 55.15 -105.27 7.4 -2.2 240 4 1017.0 TRUE TRUE METAR 379.0 2019-03-20 17:09:16
CXOL 201600Z AUTO 22006KT 03/M04 RMK AO1 T00311035 CXOL 2019-03-20T16:00:00Z 51.77 -114.08 3.1 -3.5 220 6 TRUE TRUE METAR 1046.0 2019-03-20 17:09:16
CXHP 201600Z AUTO 15001KT M00/M03 RMK AO1 T10011030 50004 CXHP 2019-03-20T16:00:00Z 55.4 -116.48 -0.1 -3.0 150 1 TRUE TRUE 0.4 METAR 602.0 2019-03-20 17:09:16
SAOC 201600Z 18010KT 9999 FEW020 14/08 Q1025 SAOC 2019-03-20T16:00:00Z -33.12 -64.27 14.0 8.0 180 10 6.21 30.265747 VFR METAR 421.0 2019-03-20 17:09:16
KGHG 201635Z AUTO 13011KT 10SM CLR 07/M05 A3038 RMK AO2 KGHG 2019-03-20T16:35:00Z 42.1 -70.67 7.0 -5.0 130 11 10.0 30.380905 TRUE TRUE VFR SPECI 4.0 2019-03-20 17:09:16
KDMW 201640Z AUTO 16008G15KT 10SM CLR 10/M14 A3033 RMK AO2 KDMW 2019-03-20T16:40:00Z 39.6 -77.0 10.0 -14.0 160 8 15 10.0 30.33071 TRUE TRUE VFR METAR 241.0 2019-03-20 17:09:16
K4BM 201654Z AUTO 03005KT 10SM CLR 00/M19 A3039 RMK AO2 LTG DSNT NW K4BM 2019-03-20T16:54:00Z 39.05 -105.52 0.0 -19.0 30 5 10.0 30.389763 TRUE TRUE VFR METAR 3438.0 2019-03-20 17:09:16
KMYJ 201615Z AUTO 28011G15KT 10SM SCT011 OVC049 06/04 A3009 RMK AO2 KMYJ 2019-03-20T16:15:00Z 39.15 -91.82 6.0 4.0 280 11 15 10.0 30.088583 TRUE TRUE VFR METAR 251.0 2019-03-20 17:09:16
KMRC 201635Z AUTO 23010KT 10SM CLR 15/M05 A3021 RMK A01 KMRC 2019-03-20T16:35:00Z 35.55 -87.18 15.0 -5.0 230 10 10.0 30.209646 TRUE TRUE VFR SPECI 208.0 2019-03-20 17:09:16
KMZZ 201635Z AUTO 21012KT 10SM SCT036 BKN048 OVC060 07/M03 A3013 RMK AO2 T00681033 KMZZ 2019-03-20T16:35:00Z 40.48 -85.68 6.8 -3.3 210 12 10.0 30.129921 TRUE TRUE VFR METAR 262.0 2019-03-20 17:09:16

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query