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
KF46 300555Z AUTO 00000KT 10SM BKN100 OVC120 16/11 A3013 RMK AO2 T01610106 10195 20160 402170096 KF46 2020-03-30T05:55:00Z 32.93 -96.43 16.1 10.6 0 0 10.0 30.129921 TRUE TRUE VFR 19.5 16.0 21.7 9.6 METAR 176.0 2020-03-30 06:11:31
LBSF 300600Z 15003KT 120V180 CAVOK 03/01 Q1012 NOSIG LBSF 2020-03-30T06:00:00Z 42.65 23.37 3.0 1.0 150 3 6.21 29.88189 TRUE VFR METAR 592.0 2020-03-30 06:11:31
CYLL 300500Z AUTO 03012G17KT 9SM OVC016 M06/M09 A2972 RMK SLP109 CYLL 2020-03-30T05:00:00Z 53.32 -110.07 -6.0 -9.0 30 12 17 9.0 29.719488 1010.9 TRUE MVFR METAR 669.0 2020-03-30 06:11:31
K42J 300555Z AUTO 00000KT 6SM BR 19/19 A3011 RMK A01 TSNO K42J 2020-03-30T05:55:00Z 29.85 -82.05 19.0 19.0 0 0 6.0 30.109253 TRUE TRUE TRUE BR METAR 60.0 2020-03-30 06:11:31
K4S2 300555Z AUTO 00000KT 10SM BKN050 OVC060 08/06 A2987 RMK AO2 K4S2 2020-03-30T05:55:00Z 45.68 -121.55 8.0 6.0 0 0 10.0 29.870079 TRUE TRUE VFR METAR 192.0 2020-03-30 06:11:31
KBIH 300556Z AUTO 33006KT 10SM CLR 01/M02 A3009 RMK AO2 SLP180 60000 T00111017 10128 20006 51016 KBIH 2020-03-30T05:56:00Z 37.37 -118.35 1.1 -1.7 330 6 10.0 30.088583 1018.0 TRUE TRUE VFR 1.6 12.8 0.6 0.005 METAR 1253.0 2020-03-30 06:11:31
VVCI 300530Z AUTO 15005KT 9999 FEW014/// SCT016/// OVC028/// 24/22 Q1009 NOSIG VVCI 2020-03-30T05:30:00Z 20.82 106.73 24.0 22.0 150 5 6.21 29.793306 TRUE TRUE MVFR METAR 3.0 2020-03-30 06:11:31
KDYB 300555Z AUTO 22003KT 10SM SCT047 OVC060 21/20 A3004 RMK AO2 KDYB 2020-03-30T05:55:00Z 33.07 -80.28 21.0 20.0 220 3 10.0 30.041338 TRUE TRUE VFR METAR 18.0 2020-03-30 06:11:31
KIRK 300555Z AUTO 29005KT 10SM CLR 03/M02 A3014 RMK AO2 SLP212 T00281017 10144 20028 401670028 51005 KIRK 2020-03-30T05:55:00Z 40.1 -92.55 2.8 -1.7 290 5 10.0 30.138779 1021.2 TRUE TRUE VFR 0.5 14.4 2.8 16.7 2.8 METAR 293.0 2020-03-30 06:11:31
VOAT 300530Z 34004KT 6000 FEW015 31/25 Q1012 NOSIG VOAT 2020-03-30T05:30:00Z 10.82 72.18 31.0 25.0 340 4 3.73 29.88189 TRUE MVFR METAR 4.0 2020-03-30 06:11:31
KCRQ 300553Z AUTO 00000KT 10SM BKN019 14/10 A3013 RMK AO2 SLP202 T01390100 10167 20139 50004 $ KCRQ 2020-03-30T05:53:00Z 33.13 -117.28 13.9 10.0 0 0 10.0 30.129921 1020.2 TRUE TRUE TRUE MVFR 0.4 16.7 13.9 METAR 99.0 2020-03-30 06:11:31
ENCN 300550Z 04007KT 9999 FEW049 00/M03 Q1027 ENCN 2020-03-30T05:50:00Z 58.2 8.07 0.0 -3.0 40 7 6.21 30.324802 VFR METAR 17.0 2020-03-30 06:11:31
UIAA 300530Z 29010G16MPS 9999 SCT043CB 02/M16 Q1015 R29/60D NOSIG RMK QFE702/0937 UIAA 2020-03-30T05:30:00Z 52.02 113.32 2.0 -16.0 290 19 31 6.21 29.970472 TRUE VFR METAR 685.0 2020-03-30 06:11:31
KICL 300555Z AUTO 00000KT 10SM CLR 01/01 A3017 RMK AO2 KICL 2020-03-30T05:55:00Z 40.72 -95.02 1.0 1.0 0 0 10.0 30.171259 TRUE TRUE VFR METAR 303.0 2020-03-30 06:11:31
KNSI 300553Z AUTO 31019KT 10SM FEW010 12/09 A3014 RMK AO2 PK WND 32026/0520 SLP203 T01170094 10150 20117 53010 $ KNSI 2020-03-30T05:53:00Z 33.22 -119.45 11.7 9.4 310 19 10.0 30.138779 1020.3 TRUE TRUE TRUE VFR 1.0 15.0 11.7 METAR 154.0 2020-03-30 06:11:31
KDYA 300555Z AUTO 00000KT 10SM CLR 15/12 A3016 RMK AO2 T01500117 10200 20148 402520148 KDYA 2020-03-30T05:55:00Z 32.47 -87.95 15.0 11.7 0 0 10.0 30.159449 TRUE TRUE VFR 20.0 14.8 25.2 14.8 METAR 34.0 2020-03-30 06:11:31
SBAR 300600Z 00000KT 9999 SCT017 SCT050 24/23 Q1011 SBAR 2020-03-30T06:00:00Z -10.97 -37.07 24.0 23.0 0 0 6.21 29.852362 VFR METAR 9.0 2020-03-30 06:11:31
KFYE 300555Z AUTO 28003KT 10SM CLR 14/06 A3016 RMK A01 KFYE 2020-03-30T05:55:00Z 35.2 -89.38 14.0 6.0 280 3 10.0 30.159449 TRUE TRUE VFR METAR 133.0 2020-03-30 06:11:31
KRHV 300450Z 32006KT 10SM BKN040 13/09 A3018 KRHV 2020-03-30T04:50:00Z 37.32 -121.82 13.0 9.0 320 6 10.0 30.180119 VFR METAR 41.0 2020-03-30 06:11:31
NFFN 300600Z 02004KT 9999 SCT024 BKN046 BKN110 28/25 Q1007 NOSIG NFFN 2020-03-30T06:00:00Z -17.75 177.45 28.0 25.0 20 4 6.21 29.734253 TRUE VFR METAR 18.0 2020-03-30 06:11:31
LFRM 300530Z AUTO 03011KT CAVOK 01/M08 Q1028 LFRM 2020-03-30T05:30:00Z 47.95 0.2 1.0 -8.0 30 11 6.21 30.35433 TRUE VFR METAR 52.0 2020-03-30 06:11:31
WAJJ 300530Z 28019KT 9999 FEW013 30/22 Q1005 NOSIG WAJJ 2020-03-30T05:30:00Z -2.58 140.52 30.0 22.0 280 19 6.21 29.675198 TRUE VFR METAR 88.0 2020-03-30 06:11:31
KS52 300555Z AUTO 33004KT 10SM CLR 04/M03 A2976 RMK AO2 T00431031 10136 20033 KS52 2020-03-30T05:55:00Z 48.38 -120.15 4.3 -3.1 330 4 10.0 29.760826 TRUE TRUE VFR 13.6 3.3 METAR 520.0 2020-03-30 06:11:31
KAIT 300556Z AUTO 00000KT 10SM CLR M03/M06 A3008 RMK AO2 KAIT 2020-03-30T05:56:00Z 46.53 -93.67 -3.0 -6.0 0 0 10.0 30.079725 TRUE TRUE VFR METAR 367.0 2020-03-30 06:11:31
KIGQ 300555Z AUTO 28007G19KT 10SM BKN028 OVC036 07/02 A2994 RMK AO2 T00660021 10082 20066 401500065 KIGQ 2020-03-30T05:55:00Z 41.53 -87.53 6.6 2.1 280 7 19 10.0 29.940945 TRUE TRUE MVFR 8.2 6.6 15.0 6.5 METAR 188.0 2020-03-30 06:11:31
LFAQ 300530Z AUTO 02011KT CAVOK M01/M05 Q1032 LFAQ 2020-03-30T05:30:00Z 49.97 2.7 -1.0 -5.0 20 11 6.21 30.47244 TRUE VFR METAR 111.0 2020-03-30 06:11:31
PARC 300556Z AUTO 01003KT 10SM CLR M22/M27 A3029 RMK AO2 SLP354 T12171272 11083 21217 51009 FZRANO PARC 2020-03-30T05:56:00Z 68.12 -145.58 -21.7 -27.2 10 3 10.0 30.28937 1035.4 TRUE TRUE TRUE VFR 0.9 -8.3 -21.7 METAR 626.0 2020-03-30 06:11:31
CYCK 300500Z AUTO 25016G21KT 9SM BKN045 OVC060 09/05 A2978 RMK SLP087 CYCK 2020-03-30T05:00:00Z 42.3 -82.08 9.0 5.0 250 16 21 9.0 29.778543 1008.7 TRUE VFR METAR 198.0 2020-03-30 06:11:31
KN60 300552Z AUTO 13008KT 02/M03 A3002 RMK AO1 SLP178 T00221028 10133 20017 401441039 50006 KN60 2020-03-30T05:52:00Z 47.65 -101.43 2.2 -2.8 130 8 30.02067 1017.8 TRUE TRUE 0.6 13.3 1.7 14.4 -3.9 METAR 582.0 2020-03-30 06:11:31
VLLB 300500Z 18002KT 1000 FU SCT019 33/17 Q1008 NOSIG VLLB 2020-03-30T05:00:00Z 19.9 102.17 33.0 17.0 180 2 0.62 29.763779 TRUE FU LIFR METAR 291.0 2020-03-30 06:11:31
YPGV 300530Z 11010KT 9999 SCT025 31/23 Q1007 YPGV 2020-03-30T05:30:00Z -12.27 136.82 31.0 23.0 110 10 6.21 29.734253 VFR METAR 55.0 2020-03-30 06:11:31
CYYL 300537Z AUTO 10013KT 9SM -SN SCT016 OVC050 M14/M16 A3020 RMK SLP269 CYYL 2020-03-30T05:37:00Z 56.87 -101.07 -14.0 -16.0 100 13 9.0 30.200787 1026.9 TRUE -SN VFR SPECI 357.0 2020-03-30 06:11:31
EDDN 300550Z 36006KT 9999 FEW028 M02/M08 Q1027 NOSIG EDDN 2020-03-30T05:50:00Z 49.5 11.08 -2.0 -8.0 360 6 6.21 30.324802 TRUE VFR METAR 312.0 2020-03-30 06:11:31
KPNS 300553Z AUTO 01005KT 10SM CLR 22/11 A3013 RMK AO2 SLP203 T02170106 10256 20217 403060217 56002 KPNS 2020-03-30T05:53:00Z 30.48 -87.18 21.7 10.6 10 5 10.0 30.129921 1020.3 TRUE TRUE VFR -0.2 25.6 21.7 30.6 21.7 METAR 38.0 2020-03-30 06:11:31
KMNI 300555Z AUTO 26005KT 10SM CLR 22/16 A3005 RMK AO2 KMNI 2020-03-30T05:55:00Z 33.58 -80.22 22.0 16.0 260 5 10.0 30.050198 TRUE TRUE VFR METAR 32.0 2020-03-30 06:11:31
KNFL 300556Z AUTO 27007KT 10SM CLR 04/M01 A3008 RMK AO2 SLP152 T00441011 10117 20022 53016 $ KNFL 2020-03-30T05:56:00Z 39.42 -118.7 4.4 -1.1 270 7 10.0 30.079725 1015.2 TRUE TRUE TRUE VFR 1.6 11.7 2.2 METAR 1199.0 2020-03-30 06:11:31
KOCF 300551Z AUTO 00000KT 10SM CLR 19/19 A3014 RMK AO2 SLP205 T01890189 10261 20183 58003 $ KOCF 2020-03-30T05:51:00Z 29.17 -82.22 18.9 18.9 0 0 10.0 30.138779 1020.5 TRUE TRUE TRUE VFR -0.3 26.1 18.3 METAR 27.0 2020-03-30 06:11:31
K9L2 300558Z AUTO 23008KT 10SM CLR 09/02 A3008 RMK AO2 SLP182 T00860015 10146 20086 50009 $ K9L2 2020-03-30T05:58:00Z 34.97 -117.87 8.6 1.5 230 8 10.0 30.079725 1018.2 TRUE TRUE TRUE VFR 0.9 14.6 8.6 METAR 701.0 2020-03-30 06:11:31
KSUE 300556Z AUTO 31008KT 10SM -RA OVC018 02/01 A2981 RMK AO2 UPB02E08B52E55 SLP100 P0000 60000 T00220011 10044 20022 400670022 51031 FZRANO KSUE 2020-03-30T05:56:00Z 44.85 -87.42 2.2 1.1 310 8 10.0 29.811024 1010.0 TRUE TRUE TRUE -RA MVFR 3.1 4.4 2.2 6.7 2.2 0.005 0.005 METAR 221.0 2020-03-30 06:11:31
EGXT 300450Z AUTO 31008KT 9999 FEW025/// BKN050/// 02/M02 Q1036 EGXT 2020-03-30T04:50:00Z 52.62 -0.47 2.0 -2.0 310 8 6.21 30.590551 TRUE VFR METAR 84.0 2020-03-30 06:11:31
EGCK 300550Z AUTO 02004KT 9999 BKN014/// 05/02 Q1040 EGCK 2020-03-30T05:50:00Z 53.1 -4.33 5.0 2.0 20 4 6.21 30.708662 TRUE MVFR METAR 0.0 2020-03-30 06:11:31
GMTN 300500Z AUTO 15005KT 10/09 Q1013 GMTN 2020-03-30T05:00:00Z 35.57 -5.32 10.0 9.0 150 5 29.911417 TRUE METAR 10.0 2020-03-30 06:11:31
CWLP 300500Z AUTO 14028G33KT 07/04 RMK AO1 6037 PK WND 13038/0411 SLP949 T00740035 50002 CWLP 2020-03-30T05:00:00Z 50.93 -127.63 7.4 3.5 140 28 33 994.9 TRUE TRUE 0.2 METAR 17.0 2020-03-30 06:11:31
KTXK 300553Z AUTO 00000KT 10SM CLR 16/08 A3015 RMK AO2 SLP207 T01610083 10200 20133 402280072 58004 KTXK 2020-03-30T05:53:00Z 33.45 -93.98 16.1 8.3 0 0 10.0 30.15059 1020.7 TRUE TRUE VFR -0.4 20.0 13.3 22.8 7.2 METAR 111.0 2020-03-30 06:11:31
CWLY 300500Z AUTO 20011G21KT 9SM -RA OVC039 06/03 A2970 RMK SLP065 CWLY 2020-03-30T05:00:00Z 50.22 -121.58 6.0 3.0 200 11 21 9.0 29.698818 1006.5 TRUE -RA VFR METAR 229.0 2020-03-30 06:11:31
KPYX 300555Z AUTO 15009KT 10SM CLR 08/02 A3008 RMK AO2 T00760021 10178 20075 401861015 KPYX 2020-03-30T05:55:00Z 36.42 -100.75 7.6 2.1 150 9 10.0 30.079725 TRUE TRUE VFR 17.8 7.5 18.6 -1.5 METAR 889.0 2020-03-30 06:11:31
ZJSY 300500Z 14005MPS 9999 FEW025 31/24 Q1010 NOSIG ZJSY 2020-03-30T05:00:00Z 18.3 109.42 31.0 24.0 140 10 6.21 29.822834 TRUE VFR METAR 27.0 2020-03-30 06:11:31
KFRM 300556Z AUTO 31009KT 10SM CLR 03/M01 A3013 RMK AO2 SLP214 T00281006 10111 20028 401170006 51013 KFRM 2020-03-30T05:56:00Z 43.63 -94.42 2.8 -0.6 310 9 10.0 30.129921 1021.4 TRUE TRUE VFR 1.3 11.1 2.8 11.7 0.6 METAR 354.0 2020-03-30 06:11:31
CYYE 300500Z 36008KT 12SM -SN BKN058 M16/M20 A3030 RMK SN5SC1 SLP303 CYYE 2020-03-30T05:00:00Z 58.82 -122.57 -16.0 -20.0 360 8 12.0 30.301182 1030.3 -SN VFR METAR 382.0 2020-03-30 06:11:31
CWSR 300500Z AUTO 08007KT M08/M13 RMK AO1 SOG 24 0001 SLP114 T10761128 CWSR 2020-03-30T05:00:00Z 53.37 -107.53 -7.6 -12.8 80 7 1011.4 TRUE TRUE METAR 584.0 2020-03-30 06:11:31

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query