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
UMMG 191030Z 08006G09MPS 9999 OVC010 03/01 Q1029 R35/190065 NOSIG UMMG 2018-11-19T10:30:00Z 53.6 24.05 3.0 1.0 80 12 17 6.21 30.383858 TRUE MVFR SPECI 135.0 2018-11-19 11:06:41
ZUCK 191000Z 01002MPS 9999 SCT046 10/07 Q1022 NOSIG ZUCK 2018-11-19T10:00:00Z 29.72 106.63 10.0 7.0 10 4 6.21 30.177166 TRUE VFR METAR 416.0 2018-11-19 11:06:41
KO54 191035Z AUTO 02003KT 10SM BKN044 M02/M07 A3014 RMK AO1 KO54 2018-11-19T10:35:00Z 40.75 -122.92 -2.0 -7.0 20 3 10.0 30.138779 TRUE TRUE VFR METAR 717.0 2018-11-19 11:06:41
EGAC 191020Z AUTO 07012KT 9999 OVC038/// 09/07 Q1027 EGAC 2018-11-19T10:20:00Z 54.62 -5.87 9.0 7.0 70 12 6.21 30.324802 TRUE VFR METAR 5.0 2018-11-19 11:06:41
KEAU 190956Z AUTO 00000KT 8SM -SN OVC060 M06/M11 A2998 RMK AO2 SNB43 SLP169 P0000 T10611106 KEAU 2018-11-19T09:56:00Z 44.87 -91.47 -6.1 -10.6 0 0 8.0 29.97933 1016.9 TRUE TRUE -SN VFR 0.005 METAR 276.0 2018-11-19 11:06:41
KCLI 191035Z AUTO 21003KT 10SM SCT060 BKN070 OVC095 M04/M12 A3001 RMK AO2 T10431124 KCLI 2018-11-19T10:35:00Z 44.62 -88.73 -4.3 -12.4 210 3 10.0 30.008858 TRUE TRUE VFR SPECI 250.0 2018-11-19 11:06:41
CYGW 191046Z AUTO 20009G15KT 1 3/4SM -SN BKN008 BKN034 OVC044 M09/M10 A2975 RMK SLP077 CYGW 2018-11-19T10:46:00Z 55.27 -77.77 -9.0 -10.0 200 9 15 1.75 29.749016 1007.7 TRUE -SN IFR SPECI 12.0 2018-11-19 11:06:41
KSME 191035Z AUTO 00000KT 10SM OVC100 04/04 A3012 RMK AO2 KSME 2018-11-19T10:35:00Z 37.05 -84.62 4.0 4.0 0 0 10.0 30.121063 TRUE TRUE VFR METAR 283.0 2018-11-19 11:06:41
KDAL 190953Z 34007KT 10SM BKN046 OVC210 04/M01 A3021 RMK AO2 SLP232 T00391006 $ KDAL 2018-11-19T09:53:00Z 32.85 -96.85 3.9 -0.6 340 7 10.0 30.209646 1023.2 TRUE TRUE VFR METAR 158.0 2018-11-19 11:06:41
CWCO 191000Z AUTO 26003KT 01/M04 RMK AO1 SLP191 T00061039 53006 CWCO 2018-11-19T10:00:00Z 44.45 -80.17 0.6 -3.9 260 3 1019.1 TRUE TRUE 0.6 METAR 221.0 2018-11-19 11:06:41
LFRL 191030Z AUTO 06010KT 020V090 CAVOK 07/01 Q1013 NOSIG LFRL 2018-11-19T10:30:00Z 48.27 -4.42 7.0 1.0 60 10 6.21 29.911417 TRUE TRUE VFR METAR 82.0 2018-11-19 11:06:41
K4BM 191036Z AUTO 32012G16KT 10SM CLR M05/M30 A3019 RMK AO2 K4BM 2018-11-19T10:36:00Z 39.05 -105.52 -5.0 -30.0 320 12 16 10.0 30.188976 TRUE TRUE VFR SPECI 3438.0 2018-11-19 11:06:41
NWWW 191030Z AUTO 00000KT CAVOK 20/15 Q1013 NOSIG NWWW 2018-11-19T10:30:00Z -22.02 166.22 20.0 15.0 0 0 6.21 29.911417 TRUE TRUE VFR METAR 16.0 2018-11-19 11:06:41
VTST 191000Z 15010KT 6000 -TSRA FEW017CB SCT020 BKN100 24/23 Q1011 NOSIG VTST 2018-11-19T10:00:00Z 7.52 99.62 24.0 23.0 150 10 3.73 29.852362 TRUE -TSRA MVFR METAR 16.0 2018-11-19 11:06:41
KMWC 191035Z AUTO 22005KT 10SM CLR M04/M10 A3006 RMK AO2 KMWC 2018-11-19T10:35:00Z 43.12 -88.03 -4.0 -10.0 220 5 10.0 30.059055 TRUE TRUE VFR SPECI 227.0 2018-11-19 11:06:41
KSFZ 191017Z AUTO 05003KT 10SM OVC028 02/M03 A3016 RMK AO2 FZRANO KSFZ 2018-11-19T10:17:00Z 41.92 -71.5 2.0 -3.0 50 3 10.0 30.159449 TRUE TRUE TRUE MVFR SPECI 134.0 2018-11-19 11:06:41
ZYCC 191000Z 24002MPS 8000 SCT040 M02/M10 Q1022 NOSIG ZYCC 2018-11-19T10:00:00Z 43.98 125.68 -2.0 -10.0 240 4 4.97 30.177166 TRUE MVFR METAR 238.0 2018-11-19 11:06:41
LFRM 191030Z AUTO 05013KT 020V080 CAVOK 04/M05 Q1013 TEMPO 03015G25KT LFRM 2018-11-19T10:30:00Z 47.95 0.2 4.0 -5.0 50 13 6.21 29.911417 TRUE VFR METAR 52.0 2018-11-19 11:06:41
LLHA 190950Z 13009KT 090V160 CAVOK 26/10 Q1016 RMK FEW100 LLHA 2018-11-19T09:50:00Z 32.78 35.02 26.0 10.0 130 9 6.21 30.0 VFR METAR 8.0 2018-11-19 11:06:41
LIPA 190955Z 04006KT 9999 BKN080 07/02 Q1011 RMK BKN VIS MIN 9999 WIND THR05 /////KT WIND THR23 /////KT A2988 BLU LIPA 2018-11-19T09:55:00Z 46.02 12.58 7.0 2.0 40 6 6.21 29.852362 VFR METAR 126.0 2018-11-19 11:06:41
LIEO 191020Z VRB01KT 8000 SCT055 10/09 Q1004 LIEO 2018-11-19T10:20:00Z 40.88 9.52 10.0 9.0 0 1 4.97 29.64567 MVFR METAR 13.0 2018-11-19 11:06:41
PMDY 190956Z AUTO 13010KT 10SM OVC055 24/22 A3015 RMK AO2 SLP208 T02440217 PMDY 2018-11-19T09:56:00Z 28.22 -177.37 24.4 21.7 130 10 10.0 30.15059 1020.8 TRUE TRUE VFR METAR 4.0 2018-11-19 11:06:41
EDXW 191020Z 06020KT 9999 OVC024 05/02 Q1029 EDXW 2018-11-19T10:20:00Z 54.92 8.33 5.0 2.0 60 20 6.21 30.383858 MVFR METAR 20.0 2018-11-19 11:06:41
GOGG 191000Z 36004KT CAVOK 25/21 Q1014 GOGG 2018-11-19T10:00:00Z 12.55 -16.27 25.0 21.0 360 4 6.21 29.940945 VFR METAR 23.0 2018-11-19 11:06:41
KEVW 190953Z AUTO 19007KT 10SM CLR M06/M11 A3024 RMK AO2 SLP252 T10611111 KEVW 2018-11-19T09:53:00Z 41.27 -111.03 -6.1 -11.1 190 7 10.0 30.239174 1025.2 TRUE TRUE VFR METAR 2177.0 2018-11-19 11:06:41
CWIK 191000Z AUTO 09003KT M14/M17 RMK AO1 SLP277 T11431166 51019 CWIK 2018-11-19T10:00:00Z 50.37 -102.58 -14.3 -16.6 90 3 1027.7 TRUE TRUE 1.9 METAR 602.0 2018-11-19 11:06:41
LIPR 191020Z 29007KT 9999 SCT020 BKN070 07/04 Q1010 LIPR 2018-11-19T10:20:00Z 44.02 12.62 7.0 4.0 290 7 6.21 29.822834 VFR METAR 13.0 2018-11-19 11:06:41
EKOD 190950Z 06019KT 030V090 9999 FEW023 BKN027 05/02 Q1031 EKOD 2018-11-19T09:50:00Z 55.47 10.32 5.0 2.0 60 19 6.21 30.442913 MVFR METAR 17.0 2018-11-19 11:06:41
CZZJ 191000Z AUTO 25004KT M02/M02 RMK AO1 SOG 10 1002 SLP204 T10181015 CZZJ 2018-11-19T10:00:00Z 53.58 -116.47 -1.8 -1.5 250 4 1020.4 TRUE TRUE METAR 927.0 2018-11-19 11:06:41
KRIL 190953Z AUTO 00000KT 10SM CLR M07/M12 A3029 RMK AO2 SLP272 T10721117 KRIL 2018-11-19T09:53:00Z 39.53 -107.73 -7.2 -11.7 0 0 10.0 30.28937 1027.2 TRUE TRUE VFR METAR 1678.0 2018-11-19 11:06:41
CWPR 191000Z AUTO 00000KT M07/M08 RMK AO1 SLP282 T10671076 50000 CWPR 2018-11-19T10:00:00Z 49.47 -120.52 -6.7 -7.6 0 0 1028.2 TRUE TRUE 0.0 METAR 700.0 2018-11-19 11:06:41
VTUQ 191000Z VRB02KT 9999 FEW025 31/24 Q1011 NOSIG VTUQ 2018-11-19T10:00:00Z 14.95 102.32 31.0 24.0 0 2 6.21 29.852362 TRUE VFR METAR 234.0 2018-11-19 11:06:41
SARI 191000Z 18006KT CAVOK 17/15 Q1016 SARI 2018-11-19T10:00:00Z -25.72 -54.47 17.0 15.0 180 6 6.21 30.0 VFR METAR 270.0 2018-11-19 11:06:41
OAKB 190950Z 15005KT 120V240 9999 SCT090 14/M01 Q1023 NOSIG RMK A3022 BLU BLU OAKB 2018-11-19T09:50:00Z 34.55 69.22 14.0 -1.0 150 5 6.21 30.206694 TRUE VFR METAR 1791.0 2018-11-19 11:06:41
KMTN 191021Z AUTO 00000KT 2 1/2SM BR CLR 01/01 A3014 RMK AO2 VIS 1 1/2V4 KMTN 2018-11-19T10:21:00Z 39.32 -76.42 1.0 1.0 0 0 2.5 30.138779 TRUE TRUE BR IFR METAR 7.0 2018-11-19 11:06:41
ESSB 191020Z 01006KT 9999 BKN029 02/M02 Q1039 R30/09//95 ESSB 2018-11-19T10:20:00Z 59.35 17.93 2.0 -2.0 10 6 6.21 30.679134 MVFR SPECI 11.0 2018-11-19 11:06:41
KCXE 191035Z AUTO 00000KT 5SM CLR 03/03 A3015 RMK AO1 T00250025 KCXE 2018-11-19T10:35:00Z 36.78 -78.5 2.5 2.5 0 0 5.0 30.15059 TRUE TRUE MVFR METAR 153.0 2018-11-19 11:06:41
FQPB 191000Z 07012KT 030V100 9999 FEW025 FEW030CB BKN/// 29/23 Q1014 RMK CB TO S/SW FQPB 2018-11-19T10:00:00Z -12.97 40.5 29.0 23.0 70 12 6.21 29.940945 VFR SPECI 50.0 2018-11-19 11:06:41
CYQL 191000Z AUTO 24007KT 9SM OVC085 01/M04 A3010 RMK SLP223 CYQL 2018-11-19T10:00:00Z 49.63 -112.8 1.0 -4.0 240 7 9.0 30.100393 1022.3 TRUE VFR METAR 929.0 2018-11-19 11:06:41
CYNE 191000Z AUTO 32002KT 9SM CLR M27/M29 A3037 RMK SLP317 CYNE 2018-11-19T10:00:00Z 53.97 -97.82 -27.0 -29.0 320 2 9.0 30.369095 1031.7 TRUE VFR METAR 223.0 2018-11-19 11:06:41
KUIL 190953Z AUTO 00000KT 10SM CLR M01/M01 A3012 RMK AO2 SLP199 T10061011 $ KUIL 2018-11-19T09:53:00Z 47.93 -124.55 -0.6 -1.1 0 0 10.0 30.121063 1019.9 TRUE TRUE TRUE VFR METAR 54.0 2018-11-19 11:06:41
KTTF 191035Z AUTO 24003KT 3SM BR OVC004 M01/M02 A3012 RMK AO2 T10121017 KTTF 2018-11-19T10:35:00Z 41.93 -83.42 -1.2 -1.7 240 3 3.0 30.121063 TRUE TRUE BR LIFR METAR 188.0 2018-11-19 11:06:41
RJSF 191000Z 33011KT 9999 FEW030 SCT060 BKN130 09/05 Q1014 RJSF 2018-11-19T10:00:00Z 37.22 140.42 9.0 5.0 330 11 6.21 29.940945 VFR METAR 375.0 2018-11-19 11:06:41
CWCF 191000Z AUTO 02003KT M26/M29 RMK AO1 SOG 05 3018 SLP303 T12571288 CWCF 2018-11-19T10:00:00Z 52.35 -97.03 -25.7 -28.8 20 3 1030.3 TRUE TRUE METAR 222.0 2018-11-19 11:06:41
MKJP 191000Z 08005KT 9999 FEW022 27/21 Q1013 MKJP 2018-11-19T10:00:00Z 17.92 -76.78 27.0 21.0 80 5 6.21 29.911417 VFR METAR 3.0 2018-11-19 11:06:41
PFCL 190956Z AUTO 27006KT 10SM CLR 01/00 A2952 RMK AO2 SLP990 T00060000 FZRANO TSNO PFCL 2018-11-19T09:56:00Z 58.83 -158.53 0.6 0.0 270 6 10.0 29.518702 999.0 TRUE TRUE TRUE TRUE VFR METAR 24.0 2018-11-19 11:06:41
KOJA 191035Z AUTO 22005KT 10SM CLR M01/M02 A3017 RMK AO2 KOJA 2018-11-19T10:35:00Z 35.55 -98.67 -1.0 -2.0 220 5 10.0 30.171259 TRUE TRUE VFR SPECI 490.0 2018-11-19 11:06:41
KRNC 191035Z AUTO 00000KT 4SM BR CLR 03/03 A3012 RMK A01 KRNC 2018-11-19T10:35:00Z 35.7 -85.85 3.0 3.0 0 0 4.0 30.121063 TRUE TRUE BR MVFR METAR 315.0 2018-11-19 11:06:41
KPKB 190953Z AUTO 00000KT 9SM BKN055 OVC070 06/03 A3012 RMK AO2 SLP202 T00560028 KPKB 2018-11-19T09:53:00Z 39.35 -81.42 5.6 2.8 0 0 9.0 30.121063 1020.2 TRUE TRUE VFR METAR 262.0 2018-11-19 11:06:41
KBOI 190953Z 12008KT 10SM CLR M02/M06 A3030 RMK AO2 SLP274 T10171061 KBOI 2018-11-19T09:53:00Z 43.57 -116.23 -1.7 -6.1 120 8 10.0 30.301182 1027.4 TRUE VFR METAR 875.0 2018-11-19 11:06:41

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query