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
SBJU 190600Z 24002KT 9999 BKN019 23/22 Q1015 SBJU 2020-01-19T06:00:00Z -7.22 -39.27 23.0 22.0 240 2 6.21 29.970472 MVFR METAR 409.0 2020-01-19 07:07:56
CWVQ 190600Z AUTO 04010G16KT M14/M16 RMK AO1 SOG 27 7049 PK WND 04018/0523 SLP024 T11421163 CWVQ 2020-01-19T06:00:00Z 45.42 -73.92 -14.2 -16.3 40 10 16 1002.4 TRUE TRUE METAR 39.0 2020-01-19 07:07:56
KSJT 190651Z AUTO 02006KT 10SM CLR 02/M03 A3046 RMK AO2 SLP319 T00221033 KSJT 2020-01-19T06:51:00Z 31.37 -100.5 2.2 -3.3 20 6 10.0 30.46063 1031.9 TRUE TRUE VFR METAR 576.0 2020-01-19 07:07:56
KBZN 190656Z 19004KT 10SM SCT060 SCT095 M03/M04 A3037 RMK AO2 SLP318 T10281044 400331094 KBZN 2020-01-19T06:56:00Z 45.78 -111.17 -2.8 -4.4 190 4 10.0 30.369095 1031.8 TRUE VFR 3.3 -9.4 METAR 1361.0 2020-01-19 07:07:56
KARR 190652Z 27022G30KT 10SM OVC024 M16/M21 A3009 RMK AO2 PK WND 27031/0637 SLP200 T11611206 $ KARR 2020-01-19T06:52:00Z 41.77 -88.48 -16.1 -20.6 270 22 30 10.0 30.088583 1020.0 TRUE TRUE MVFR METAR 215.0 2020-01-19 07:07:56
CWPD 190600Z AUTO 02002KT M19/M21 RMK AO1 SLP101 T11891209 56029 CWPD 2020-01-19T06:00:00Z 47.57 -71.22 -18.9 -20.9 20 2 1010.1 TRUE TRUE -2.9 METAR 803.0 2020-01-19 07:07:56
OIBA 190600Z 15012KT 6000 NSC 23/12 Q1018 OIBA 2020-01-19T06:00:00Z 25.88 55.03 23.0 12.0 150 12 3.73 30.059055 MVFR METAR 7.0 2020-01-19 07:07:56
LIPE 190650Z 24003KT 1400 R12/P1500N R30/P1500N BR SCT017 SCT030 BKN050 06/06 Q1025 LIPE 2020-01-19T06:50:00Z 44.52 11.3 6.0 6.0 240 3 0.87 30.265747 BR LIFR METAR 42.0 2020-01-19 07:07:56
KSAR 190655Z AUTO 31008KT 10SM CLR M03/M09 A3029 RMK AO2 T10321095 KSAR 2020-01-19T06:55:00Z 38.15 -89.7 -3.2 -9.5 310 8 10.0 30.28937 TRUE TRUE VFR METAR 164.0 2020-01-19 07:07:56
SVMI 190602Z AUTO 10005KT NCD 25/// Q1015 SVMI 2020-01-19T06:02:00Z 10.58 -67.0 100 5 29.970472 TRUE METAR 48.0 2020-01-19 07:07:56
EFHK 190650Z 22013KT 9999 BKN010 04/03 Q1011 TEMPO BKN009 EFHK 2020-01-19T06:50:00Z 60.32 24.97 4.0 3.0 220 13 6.21 29.852362 MVFR METAR 56.0 2020-01-19 07:07:56
KAJO 190656Z AUTO 13011KT 10SM CLR 17/M07 A3018 RMK AO2 SLP213 T01671067 KAJO 2020-01-19T06:56:00Z 33.9 -117.6 16.7 -6.7 130 11 10.0 30.180119 1021.3 TRUE TRUE VFR METAR 163.0 2020-01-19 07:07:56
KOMK 190653Z AUTO 00000KT 4SM BR OVC010 M03/M06 A3044 RMK AO2 SLP328 I1000 T10331056 KOMK 2020-01-19T06:53:00Z 48.47 -119.52 -3.3 -5.6 0 0 4.0 30.43996 1032.8 TRUE TRUE BR MVFR SPECI 395.0 2020-01-19 07:07:56
LIMK 190555Z 00000KT CAVOK 02/M01 Q1023 RMK SKC VAL NIL VIS MIN 9999 LIMK 2020-01-19T05:55:00Z 45.02 7.72 2.0 -1.0 0 0 6.21 30.206694 VFR METAR 710.0 2020-01-19 07:07:56
DTMB 190630Z 00000KT 6000 NSC 07/06 Q1023 DTMB 2020-01-19T06:30:00Z 35.77 10.75 7.0 6.0 0 0 3.73 30.206694 MVFR METAR 2.0 2020-01-19 07:07:56
LFKB 190630Z AUTO 23003KT 210V270 9999 -RA BKN030 BKN046 BKN054 06/01 Q1022 NOSIG LFKB 2020-01-19T06:30:00Z 42.53 9.47 6.0 1.0 230 3 6.21 30.177166 TRUE TRUE -RA MVFR METAR 12.0 2020-01-19 07:07:56
KHEF 190656Z AUTO VRB03KT 10SM OVC011 05/04 A2974 RMK AO2 SLP078 T00500039 KHEF 2020-01-19T06:56:00Z 38.72 -77.52 5.0 3.9 0 3 10.0 29.740158 1007.8 TRUE TRUE MVFR SPECI 59.0 2020-01-19 07:07:56
LSMM 190650Z AUTO 10007KT 9999NDV -SN FEW027 SCT038 OVC044 M00/M05 Q1030 RMK LSMM 2020-01-19T06:50:00Z 46.75 8.12 0.0 -5.0 100 7 30.413385 TRUE -SN METAR 577.0 2020-01-19 07:07:56
LGKZ 190650Z 28004KT 8000 3500E BR FEW002 BKN030 BKN070 02/M01 Q1022 LGKZ 2020-01-19T06:50:00Z 40.28 21.83 2.0 -1.0 280 4 4.97 30.177166 BR MVFR METAR 628.0 2020-01-19 07:07:56
KJHN 190655Z AUTO 20008KT 10SM CLR M06/M10 A3039 RMK AO2 T10621100 KJHN 2020-01-19T06:55:00Z 37.58 -101.73 -6.2 -10.0 200 8 10.0 30.389763 TRUE TRUE VFR SPECI 1013.0 2020-01-19 07:07:56
K1OM 190558Z AUTO 15008KT 10SM CLR M17/M20 A3028 RMK AO2 SLP357 T11751204 11155 21175 56005 $ K1OM 2020-01-19T05:58:00Z 47.33 -108.93 -17.5 -20.4 150 8 10.0 30.280512 1035.7 TRUE TRUE TRUE VFR -0.5 -15.5 -17.5 METAR 1086.0 2020-01-19 07:07:56
KLAA 190653Z AUTO 10008KT 10SM CLR M07/M10 A3036 RMK AO2 SLP301 T10671100 400561106 KLAA 2020-01-19T06:53:00Z 38.07 -102.68 -6.7 -10.0 100 8 10.0 30.360237 1030.1 TRUE TRUE VFR 5.6 -10.6 SPECI 1119.0 2020-01-19 07:07:56
K2A0 190635Z AUTO 28006G15KT 10SM FEW017 SCT026 SCT033 08/03 A3010 RMK A01 K2A0 2020-01-19T06:35:00Z 35.48 -84.93 8.0 3.0 280 6 15 10.0 30.100393 TRUE TRUE VFR SPECI 219.0 2020-01-19 07:07:56
KPVU 190656Z AUTO 23004KT 10SM CLR M03/M08 A3051 RMK AO2 SLP361 T10331078 400281061 FZRANO KPVU 2020-01-19T06:56:00Z 40.22 -111.72 -3.3 -7.8 230 4 10.0 30.510826 1036.1 TRUE TRUE TRUE VFR 2.8 -6.1 METAR 1369.0 2020-01-19 07:07:56
UWKD 190630Z 24005MPS 9999 OVC015 01/M02 Q1020 R29/290050 NOSIG RMK QFE754/1005 UWKD 2020-01-19T06:30:00Z 55.62 49.28 1.0 -2.0 240 10 6.21 30.11811 TRUE MVFR SPECI 126.0 2020-01-19 07:07:56
CZBF 190656Z AUTO 00000KT 9SM -SN OVC045 M19/M22 A3009 RMK SLP196 CZBF 2020-01-19T06:56:00Z 47.62 -65.75 -19.0 -22.0 0 0 9.0 30.088583 1019.6 TRUE -SN VFR SPECI 59.0 2020-01-19 07:07:56
KPTD 190635Z AUTO 05005KT 1 1/4SM -SN OVC003 M12/M13 A2949 RMK AO2 KPTD 2020-01-19T06:35:00Z 44.68 -74.95 -12.0 -13.0 50 5 1.25 29.489174 TRUE TRUE -SN LIFR SPECI 144.0 2020-01-19 07:07:56
KJEF 190653Z AUTO 30011G22KT 10SM CLR M03/M12 A3038 RMK AO2 SLP285 T10331122 KJEF 2020-01-19T06:53:00Z 38.6 -92.15 -3.3 -12.2 300 11 22 10.0 30.380905 1028.5 TRUE TRUE VFR METAR 168.0 2020-01-19 07:07:56
KHGR 190653Z AUTO 00000KT 5SM BR OVC046 02/01 A2971 RMK AO2 UPE29RAB17E30 SLP076 P0000 T00220006 KHGR 2020-01-19T06:53:00Z 39.7 -77.73 2.2 0.6 0 0 5.0 29.71063 1007.6 TRUE TRUE BR MVFR 0.005 SPECI 224.0 2020-01-19 07:07:56
CWHN 190600Z AUTO 05004KT 360V090 9SM CLR M26/M31 A3050 RMK SLP408 CWHN 2020-01-19T06:00:00Z 54.88 -109.97 -26.0 -31.0 50 4 9.0 30.499016 1040.8 TRUE VFR METAR 636.0 2020-01-19 07:07:56
EPLB 190630Z 18002KT 0500 R25/1000 FZFG OVC002 M00/M00 Q1026 EPLB 2020-01-19T06:30:00Z 51.23 22.72 0.0 0.0 180 2 0.31 30.295275 FZFG LIFR SPECI 206.0 2020-01-19 07:07:56
CWDC 190600Z AUTO 07003KT M35/M39 RMK AO1 SOG 39 6010 SLP427 T13541389 CWDC 2020-01-19T06:00:00Z 59.57 -108.47 -35.4 -38.9 70 3 1042.7 TRUE TRUE METAR 318.0 2020-01-19 07:07:56
VOPB 190600Z 05010KT 6000 FEW220 30/22 Q1012 NOSIG VOPB 2020-01-19T06:00:00Z 11.63 92.73 30.0 22.0 50 10 3.73 29.88189 TRUE MVFR METAR 4.0 2020-01-19 07:07:56
KTCC 190653Z AUTO 13004KT 10SM CLR M02/M06 A3036 RMK AO2 SLP287 T10171061 400781050 KTCC 2020-01-19T06:53:00Z 35.18 -103.6 -1.7 -6.1 130 4 10.0 30.360237 1028.7 TRUE TRUE VFR 7.8 -5.0 METAR 1235.0 2020-01-19 07:07:56
WBKS 190600Z 05008KT 020V080 9999 SCT016 30/26 Q1011 WBKS 2020-01-19T06:00:00Z 5.9 118.07 30.0 26.0 50 8 6.21 29.852362 VFR METAR 13.0 2020-01-19 07:07:56
PAIK 190656Z AUTO 10010G16KT 10SM OVC070 M15/M22 A2976 RMK AO2 SLP083 T11501217 FZRANO PAIK 2020-01-19T06:56:00Z 66.98 -160.43 -15.0 -21.7 100 10 16 10.0 29.760826 1008.3 TRUE TRUE TRUE VFR SPECI 51.0 2020-01-19 07:07:56
KMAN 190655Z AUTO 00000KT 10SM BKN060 M01/M01 A3052 RMK A01 KMAN 2020-01-19T06:55:00Z 43.58 -116.52 -1.0 -1.0 0 0 10.0 30.519686 TRUE TRUE VFR METAR 774.0 2020-01-19 07:07:56
OIAW 190630Z 16002KT 3500 HZ NSC 19/14 Q1017 OIAW 2020-01-19T06:30:00Z 31.32 48.77 19.0 14.0 160 2 2.17 30.029528 HZ IFR METAR 22.0 2020-01-19 07:07:56
LRBO 190600Z 30006KT 9999 OVC027 01/M03 Q1027 BLU BLU LRBO 2020-01-19T06:00:00Z 45.22 26.97 1.0 -3.0 300 6 6.21 30.324802 MVFR METAR 103.0 2020-01-19 07:07:56
DBBB 190640Z 36004KT 320V030 0800 R24/P0800 FG SCT003 26/25 Q1011 NOSIG DBBB 2020-01-19T06:40:00Z 6.33 2.37 26.0 25.0 360 4 0.5 29.852362 TRUE FG LIFR SPECI 9.0 2020-01-19 07:07:56
KC62 190655Z AUTO 26017G25KT 7SM -SN OVC017 M11/M15 A2995 RMK AO2 T11121149 KC62 2020-01-19T06:55:00Z 41.47 -85.25 -11.2 -14.9 260 17 25 7.0 29.949802 TRUE TRUE -SN MVFR METAR 306.0 2020-01-19 07:07:56
FQPB 190600Z 34009KT 9999 FEW020 BKN100 27/26 Q1008 FQPB 2020-01-19T06:00:00Z -12.97 40.5 27.0 26.0 340 9 6.21 29.763779 VFR METAR 50.0 2020-01-19 07:07:56
KOVS 190653Z AUTO 27009KT 10SM CLR M17/M22 A3016 RMK AO2 SLP227 T11721222 KOVS 2020-01-19T06:53:00Z 43.15 -90.68 -17.2 -22.2 270 9 10.0 30.159449 1022.7 TRUE TRUE VFR SPECI 202.0 2020-01-19 07:07:56
KHQM 190653Z AUTO 08008KT 10SM OVC021 08/08 A3023 RMK AO2 SLP241 T00780078 KHQM 2020-01-19T06:53:00Z 46.97 -123.93 7.8 7.8 80 8 10.0 30.230314 1024.1 TRUE TRUE MVFR SPECI 7.0 2020-01-19 07:07:56
KCWI 190656Z AUTO 29023G28KT 10SM CLR M18/M21 A3019 RMK AO2 PK WND 29028/0650 SLP242 T11831211 FZRANO KCWI 2020-01-19T06:56:00Z 41.82 -90.32 -18.3 -21.1 290 23 28 10.0 30.188976 1024.2 TRUE TRUE TRUE VFR SPECI 216.0 2020-01-19 07:07:56
LZIB 190630Z 33004KT 9999 -RA FEW009 OVC038 02/00 Q1027 R13/290195 NOSIG LZIB 2020-01-19T06:30:00Z 48.17 17.22 2.0 0.0 330 4 6.21 30.324802 TRUE -RA VFR SPECI 134.0 2020-01-19 07:07:56
KGNR 190656Z AUTO 12007KT M13/M16 A2965 RMK AO1 PRESFR SLP075 P0003 T11331156 KGNR 2020-01-19T06:56:00Z 45.47 -69.55 -13.3 -15.6 120 7 29.648623 1007.5 TRUE TRUE 0.03 METAR 427.0 2020-01-19 07:07:56
USNN 190630Z 30005MPS 9999 SCT018 M16/M19 Q1007 R03/490545 NOSIG RMK QFE751 USNN 2020-01-19T06:30:00Z 60.95 76.48 -16.0 -19.0 300 10 6.21 29.734253 TRUE VFR SPECI 54.0 2020-01-19 07:07:56
RJFE 190600Z 31004KT 270V340 9999 FEW015 SCT030 BKN040 09/05 Q1018 RJFE 2020-01-19T06:00:00Z 32.67 128.82 9.0 5.0 310 4 6.21 30.059055 VFR METAR 80.0 2020-01-19 07:07:56
ULMM 190630Z 17001MPS 9999 FEW000 M33/M36 Q1015 R31/390156 NOSIG RMK QBB010 OBST OBSC QFE754 ULMM 2020-01-19T06:30:00Z 68.78 32.75 -33.0 -36.0 170 2 6.21 29.970472 TRUE VFR METAR 51.0 2020-01-19 07:07:56

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query