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
LIPL 171055Z 23002KT 4000 BR SCT040 BKN060 10/07 Q1025 RMK OVC VIS MIN 4000 WIND THR31 23002KT WIND THR13 24002KT GRN LIPL 2020-02-17T10:55:00Z 45.42 10.27 10.0 7.0 230 2 2.49 30.265747 BR IFR METAR 92.0 2020-02-17 12:11:20
SLOR 171200Z 36003KT 9999 FEW015 BKN200 09/04 Q1034 SLOR 2020-02-17T12:00:00Z -17.97 -67.08 9.0 4.0 360 3 6.21 30.531496 VFR METAR 3702.0 2020-02-17 12:11:19
OIBB 171200Z 17014KT 5000 SA BKN040 25/12 Q1016 A3000 OIBB 2020-02-17T12:00:00Z 28.97 50.82 25.0 12.0 170 14 3.11 30.0 SA MVFR METAR 19.0 2020-02-17 12:11:19
KTBR 171155Z AUTO 00000KT 7SM OVC003 10/09 A3012 RMK AO2 T00950090 10095 20092 KTBR 2020-02-17T11:55:00Z 32.48 -81.73 9.5 9.0 0 0 7.0 30.121063 TRUE TRUE LIFR 9.5 9.2 METAR 57.0 2020-02-17 12:11:19
RJOS 171200Z 29010G20KT 9999 FEW030 03/M03 Q1012 RJOS 2020-02-17T12:00:00Z 34.12 134.62 3.0 -3.0 290 10 20 6.21 29.88189 VFR METAR 11.0 2020-02-17 12:11:19
EDDR 171150Z 25008KT 9999 FEW008 SCT012 07/06 Q1017 TEMPO BKN012 EDDR 2020-02-17T11:50:00Z 49.22 7.1 7.0 6.0 250 8 6.21 30.029528 VFR METAR 320.0 2020-02-17 12:11:19
KGSP 171153Z 01003KT 7SM CLR 01/M01 A3012 RMK AO2 SLP201 T00061006 10044 20000 53007 KGSP 2020-02-17T11:53:00Z 34.9 -82.22 0.6 -0.6 10 3 7.0 30.121063 1020.1 TRUE VFR 0.7 4.4 0.0 METAR 287.0 2020-02-17 12:11:19
KFKR 171155Z AUTO 13008KT 10SM OVC100 01/M04 A3014 RMK AO2 T00061036 10006 21020 KFKR 2020-02-17T11:55:00Z 40.27 -86.57 0.6 -3.6 130 8 10.0 30.138779 TRUE TRUE VFR 0.6 -2.0 METAR 262.0 2020-02-17 12:11:19
KSPS 171152Z AUTO 21010KT 10SM CLR 07/05 A2970 RMK AO2 SLP052 T00670050 10083 20039 55005 $ KSPS 2020-02-17T11:52:00Z 33.98 -98.5 6.7 5.0 210 10 10.0 29.698818 1005.2 TRUE TRUE TRUE VFR -0.5 8.3 3.9 METAR 308.0 2020-02-17 12:11:19
KHUM 171147Z 08004KT 1SM BR OVC002 14/14 A3000 KHUM 2020-02-17T11:47:00Z 29.57 -90.67 14.0 14.0 80 4 1.0 30.0 BR LIFR METAR 3.0 2020-02-17 12:11:19
DAUU 171100Z 00000KT CAVOK 21/06 Q1027 DAUU 2020-02-17T11:00:00Z 31.92 5.4 21.0 6.0 0 0 6.21 30.324802 VFR METAR 141.0 2020-02-17 12:11:19
CYBQ 171100Z AUTO 30008G15KT 9SM CLR M30/M33 A2986 RMK SLP154 CYBQ 2020-02-17T11:00:00Z 58.7 -98.5 -30.0 -33.0 300 8 15 9.0 29.861221 1015.4 TRUE VFR METAR 262.0 2020-02-17 12:11:19
KPVD 171151Z 27005KT 10SM FEW150 BKN220 M02/M04 A3017 RMK AO2 SLP215 T10171039 11006 21044 53019 KPVD 2020-02-17T11:51:00Z 41.72 -71.43 -1.7 -3.9 270 5 10.0 30.171259 1021.5 TRUE VFR 1.9 -0.6 -4.4 METAR 16.0 2020-02-17 12:11:19
KSFZ 171156Z AUTO 29005KT 10SM CLR M01/M03 A3015 RMK AO2 SLP159 T10061033 10000 21028 53019 FZRANO KSFZ 2020-02-17T11:56:00Z 41.92 -71.5 -0.6 -3.3 290 5 10.0 30.15059 1015.9 TRUE TRUE TRUE VFR 1.9 0.0 -2.8 METAR 134.0 2020-02-17 12:11:19
KCWI 171156Z AUTO 09013KT 7SM -SN BKN034 OVC048 M01/M02 A3000 RMK AO2 UPE03B20E46SNB03E20B46 SLP171 P0000 60000 T10061022 10000 21006 58010 FZRANO KCWI 2020-02-17T11:56:00Z 41.82 -90.32 -0.6 -2.2 90 13 7.0 30.0 1017.1 TRUE TRUE TRUE -SN VFR -1.0 0.0 -0.6 0.005 0.005 METAR 216.0 2020-02-17 12:11:19
KHIO 171153Z AUTO VRB03KT 10SM SCT028 BKN035 BKN042 02/02 A3038 RMK AO2 RAE1055UPB1055E05 SLP288 P0001 60002 70006 T00220017 10056 20011 51007 KHIO 2020-02-17T11:53:00Z 45.55 -122.95 2.2 1.7 0 3 10.0 30.380905 1028.8 TRUE TRUE VFR 0.7 5.6 1.1 0.01 0.02 0.06 METAR 68.0 2020-02-17 12:11:19
SBJR 171100Z 31001KT 9999 FEW040 28/24 Q1012 SBJR 2020-02-17T11:00:00Z -22.97 -43.37 28.0 24.0 310 1 6.21 29.88189 VFR METAR 3.0 2020-02-17 12:11:20
KOZS 171155Z AUTO 14008KT 10SM SCT013 BKN047 OVC055 08/06 A2987 RMK AO2 KOZS 2020-02-17T11:55:00Z 37.97 -92.68 8.0 6.0 140 8 10.0 29.870079 TRUE TRUE VFR METAR 324.0 2020-02-17 12:11:19
GCTS 171200Z 08022KT CAVOK 23/14 Q1026 WS R07 NOSIG GCTS 2020-02-17T12:00:00Z 28.05 -16.57 23.0 14.0 80 22 6.21 30.295275 TRUE VFR METAR 72.0 2020-02-17 12:11:19
PAEN 171153Z AUTO 02013KT 4SM -SN OVC042 M08/M11 A2992 RMK AO2 SNB1055 SLP135 P0000 60000 T10831111 11083 21100 56010 TSNO PAEN 2020-02-17T11:53:00Z 60.57 -151.25 -8.3 -11.1 20 13 4.0 29.920275 1013.5 TRUE TRUE TRUE -SN MVFR -1.0 -8.3 -10.0 0.005 0.005 METAR 27.0 2020-02-17 12:11:19
KFOE 171201Z 00000KT 10SM SCT027 BKN041 05/02 A2983 RMK AO2 T00500017 KFOE 2020-02-17T12:01:00Z 38.93 -95.65 5.0 1.7 0 0 10.0 29.828741 TRUE VFR METAR 320.0 2020-02-17 12:11:19
KFSE 171155Z AUTO 17005KT 4SM -SN SCT017 SCT038 M11/M12 A2988 RMK AO2 KFSE 2020-02-17T11:55:00Z 47.58 -95.77 -11.0 -12.0 170 5 4.0 29.878937 TRUE TRUE -SN MVFR METAR 389.0 2020-02-17 12:11:19
KF00 171155Z AUTO 19016G23KT 10SM OVC010 17/15 A2980 RMK AO2 T01650149 10165 20138 KF00 2020-02-17T11:55:00Z 33.62 -96.18 16.5 14.9 190 16 23 10.0 29.799213 TRUE TRUE MVFR 16.5 13.8 METAR 188.0 2020-02-17 12:11:19
LETL 171200Z AUTO 33004KT 290V030 CAVOK 16/03 Q1027 LETL 2020-02-17T12:00:00Z 40.42 -1.22 16.0 3.0 330 4 6.21 30.324802 TRUE VFR METAR 1013.0 2020-02-17 12:11:19
LYTV 171200Z 24004KT 170V300 CAVOK 16/05 Q1026 NOSIG LYTV 2020-02-17T12:00:00Z 42.38 18.72 16.0 5.0 240 4 6.21 30.295275 TRUE VFR METAR 5.0 2020-02-17 12:11:19
FQIN 171200Z 08004KT 9999 SCT020 34/22 Q1011 FQIN 2020-02-17T12:00:00Z -23.87 35.37 34.0 22.0 80 4 6.21 29.852362 VFR METAR 15.0 2020-02-17 12:11:19
KBHK 171156Z AUTO 36008KT 10SM SCT004 BKN017 OVC034 M04/M05 A2989 RMK AO2 T10391050 KBHK 2020-02-17T11:56:00Z 46.35 -104.25 -3.9 -5.0 360 8 10.0 29.890747 TRUE TRUE MVFR METAR 902.0 2020-02-17 12:11:19
LRBO 171100Z 21022KT 9999 FEW100 13/01 Q1024 BLU BLU LRBO 2020-02-17T11:00:00Z 45.22 26.97 13.0 1.0 210 22 6.21 30.236221 VFR METAR 103.0 2020-02-17 12:11:19
KMGW 171153Z COR 22003KT 6SM BR CLR M03/M04 A3022 RMK AO2 SLP243 I6003 T10331044 11006 21039 51020 KMGW 2020-02-17T11:53:00Z 39.65 -79.92 -3.3 -4.4 220 3 6.0 30.221457 1024.3 TRUE TRUE BR VFR 2.0 -0.6 -3.9 METAR 378.0 2020-02-17 12:11:19
KFYJ 171155Z AUTO 00000KT 10SM CLR 01/01 A3019 RMK AO1 T00120012 10055 20008 KFYJ 2020-02-17T11:55:00Z 37.52 -76.77 1.2 1.2 0 0 10.0 30.188976 TRUE TRUE VFR 5.5 0.8 METAR 7.0 2020-02-17 12:11:19
KBEH 171153Z AUTO 10009KT 10SM OVC100 M03/M08 A3015 RMK AO2 SLP217 I6000 T10281083 11028 21056 56003 KBEH 2020-02-17T11:53:00Z 42.13 -86.42 -2.8 -8.3 100 9 10.0 30.15059 1021.7 TRUE TRUE VFR -0.3 -2.8 -5.6 METAR 191.0 2020-02-17 12:11:19
LIVD 171055Z 00000KT CAVOK 06/M00 Q1023 RMK BKN SCT070 SCT250 VIS MIN 9999 LIVD 2020-02-17T10:55:00Z 46.72 12.22 6.0 0.0 0 0 6.21 30.206694 VFR METAR 1226.0 2020-02-17 12:11:20
KDDH 171154Z AUTO 28004KT 9SM CLR M02/M06 A3016 RMK AO2 SLP221 T10221061 10022 21022 53022 KDDH 2020-02-17T11:54:00Z 42.9 -73.25 -2.2 -6.1 280 4 9.0 30.159449 1022.1 TRUE TRUE VFR 2.2 2.2 -2.2 METAR 244.0 2020-02-17 12:11:19
KEMK 171155Z AUTO 15014KT 4SM BR BKN004 22/21 A2992 RMK A01 KEMK 2020-02-17T11:55:00Z 27.82 -94.32 22.0 21.0 150 14 4.0 29.920275 TRUE TRUE BR LIFR METAR 26.0 2020-02-17 12:11:19
CYGW 171100Z AUTO 16007KT 9SM CLR M29/M32 A3004 RMK SLP177 CYGW 2020-02-17T11:00:00Z 55.27 -77.77 -29.0 -32.0 160 7 9.0 30.041338 1017.7 TRUE VFR METAR 12.0 2020-02-17 12:11:20
KBMG 171153Z 10003KT 10SM BKN110 02/M02 A3010 RMK AO2 SLP197 T00171022 10017 21022 53005 $ KBMG 2020-02-17T11:53:00Z 39.15 -86.62 1.7 -2.2 100 3 10.0 30.100393 1019.7 TRUE TRUE VFR 0.5 1.7 -2.2 METAR 257.0 2020-02-17 12:11:19
SARC 171200Z 02008KT CAVOK 26/23 Q1006 SARC 2020-02-17T12:00:00Z -27.43 -58.77 26.0 23.0 20 8 6.21 29.704725 VFR METAR 62.0 2020-02-17 12:11:19
YCIN 171200Z AUTO 35005KT 9999 // NCD 31/26 Q1006 YCIN 2020-02-17T12:00:00Z -17.58 123.83 31.0 26.0 350 5 6.21 29.704725 TRUE VFR METAR 91.0 2020-02-17 12:11:19
CWBV 171100Z AUTO 07007KT M00/M00 RMK AO1 SLP149 T10011002 58001 CWBV 2020-02-17T11:00:00Z 44.82 -62.32 -0.1 -0.2 70 7 1014.9 TRUE TRUE -0.1 METAR 10.0 2020-02-17 12:11:19
CWMJ 171100Z AUTO 02001KT M18/M20 RMK AO1 SOG 42 1024 SLP248 T11831203 CWMJ 2020-02-17T11:00:00Z 46.27 -76.0 -18.3 -20.3 20 1 1024.8 TRUE TRUE METAR 200.0 2020-02-17 12:11:19
KISO 171156Z 35005KT 2SM BR OVC003 08/08 A3016 KISO 2020-02-17T11:56:00Z 35.32 -77.62 8.0 8.0 350 5 2.0 30.159449 BR LIFR METAR 29.0 2020-02-17 12:11:19
KEKO 171156Z AUTO 06003KT 10SM CLR M03/M08 A3013 RMK AO2 SLP218 70015 T10281083 10033 21033 58001 KEKO 2020-02-17T11:56:00Z 40.82 -115.78 -2.8 -8.3 60 3 10.0 30.129921 1021.8 TRUE TRUE VFR -0.1 3.3 -3.3 0.15 METAR 1547.0 2020-02-17 12:11:19
YGLA 171130Z AUTO 12006KT 9999 // SCT022 SCT028 SCT032 29/23 Q1011 YGLA 2020-02-17T11:30:00Z -23.87 151.22 29.0 23.0 120 6 6.21 29.852362 TRUE VFR METAR 52.0 2020-02-17 12:11:19
CWSF 171100Z AUTO 27017G25KT M08/M12 RMK AO1 SOG 08 1022 PK WND 27029/1028 SLP139 T10821123 CWSF 2020-02-17T11:00:00Z 49.25 -65.32 -8.2 -12.3 270 17 25 1013.9 TRUE TRUE METAR 29.0 2020-02-17 12:11:19
LSMM 171150Z AUTO 26010KT 9999NDV FEW052 09/03 Q1020 RMK LSMM 2020-02-17T11:50:00Z 46.75 8.12 9.0 3.0 260 10 30.11811 TRUE METAR 577.0 2020-02-17 12:11:19
LBPG 171200Z 25004KT 9999 SKC 11/M01 Q1026 LBPG 2020-02-17T12:00:00Z 42.28 24.72 11.0 -1.0 250 4 6.21 30.295275 VFR METAR 58.0 2020-02-17 12:11:19
KC65 171155Z AUTO 10006KT 10SM BKN075 OVC110 M02/M05 A3015 RMK A01 KC65 2020-02-17T11:55:00Z 41.37 -86.3 -2.0 -5.0 100 6 10.0 30.15059 TRUE TRUE VFR METAR 244.0 2020-02-17 12:11:19
KBVS 171155Z AUTO 00000KT 10SM OVC060 01/00 A3032 RMK A01 KBVS 2020-02-17T11:55:00Z 48.47 -122.42 1.0 0.0 0 0 10.0 30.318897 TRUE TRUE VFR METAR 43.0 2020-02-17 12:11:19
KSEA 171153Z 19004KT 10SM SCT075 BKN200 03/01 A3032 RMK AO2 SLP277 T00280006 10044 20022 51011 KSEA 2020-02-17T11:53:00Z 47.45 -122.32 2.8 0.6 190 4 10.0 30.318897 1027.7 TRUE VFR 1.1 4.4 2.2 METAR 136.0 2020-02-17 12:11:19
YPDN 171130Z 26003KT CAVOK 28/23 Q1008 YPDN 2020-02-17T11:30:00Z -12.42 130.9 28.0 23.0 260 3 6.21 29.763779 VFR METAR 30.0 2020-02-17 12:11:19

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query