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
EBBL 190625Z 19005KT 9999 FEW050 18/15 Q1016 BLU BLU EBBL 2018-09-19T06:25:00Z 51.17 5.47 18.0 15.0 190 5 6.21 30.0 VFR METAR 64.0 2018-09-19 06:42:46
VTPP 190600Z 19007KT 9999 SCT023 BKN100 30/23 Q1007 NOSIG VTPP 2018-09-19T06:00:00Z 16.78 100.28 30.0 23.0 190 7 6.21 29.734253 TRUE VFR METAR 44.0 2018-09-19 06:42:47
CWXA 190600Z AUTO 02002KT 03/02 RMK AO1 7PAST HR 0000 SLP227 P0003 T00290018 50010 CWXA 2018-09-19T06:00:00Z 51.07 -115.07 2.9 1.8 20 2 1022.7 TRUE TRUE 1.0 0.03 METAR 1298.0 2018-09-19 06:42:47
ENDU 190620Z VRB02KT 9999 FEW040 SCT100 BKN220 04/03 Q0999 NOSIG RMK WIND 1100FT 10008KT WIND 2200FT 10013KT ENDU 2018-09-19T06:20:00Z 69.03 18.55 4.0 3.0 0 2 6.21 29.498032 TRUE VFR 0.8 METAR 79.0 2018-09-19 06:42:47
CZEV 190600Z AUTO 03007KT M04/M07 RMK AO1 SLP289 T10421067 51002 CZEV 2018-09-19T06:00:00Z 68.32 -133.52 -4.2 -6.7 30 7 1028.9 TRUE TRUE 0.2 METAR 103.0 2018-09-19 06:42:47
KPGV 190625Z AUTO 00000KT 10SM BKN070 23/21 A2989 RMK AO2 KPGV 2018-09-19T06:25:00Z 35.62 -77.4 23.0 21.0 0 0 10.0 29.890747 TRUE TRUE VFR METAR 8.0 2018-09-19 06:42:46
KPTB 190619Z AUTO 31004KT 10SM CLR 21/19 A2988 RMK AO2 KPTB 2018-09-19T06:19:00Z 37.17 -77.52 21.0 19.0 310 4 10.0 29.878937 TRUE TRUE VFR SPECI 59.0 2018-09-19 06:42:47
PAWS 190556Z AUTO 22003KT 10SM FEW110 10/09 A3019 RMK AO2 SLP241 6//// T01000089 10144 20100 51003 PAWS 2018-09-19T05:56:00Z 61.57 -149.53 10.0 8.9 220 3 10.0 30.188976 1024.1 TRUE TRUE VFR 0.3 14.4 10.0 METAR 107.0 2018-09-19 06:42:47
URSS 190600Z 03004MPS 9999 FEW030 20/14 Q1022 R02/090070 R06/090070 NOSIG RMK R06/07004MPS MT OBSC QFE765 URSS 2018-09-19T06:00:00Z 43.45 39.95 20.0 14.0 30 8 6.21 30.177166 TRUE VFR METAR 16.0 2018-09-19 06:42:47
YMAV 190600Z AUTO 26014KT 9999 +SHRA SCT039 BKN047 BKN058 12/07 Q1014 YMAV 2018-09-19T06:00:00Z -38.03 144.48 12.0 7.0 260 14 6.21 29.940945 TRUE +SHRA VFR METAR 8.0 2018-09-19 06:42:47
CWEU 190600Z 33004KT 290V090 10SM -FZDZ OVC008 M07/M08 A3020 RMK ST8 BR SLP228 CWEU 2018-09-19T06:00:00Z 80.0 -85.92 -7.0 -8.0 330 4 10.0 30.200787 1022.8 -FZDZ IFR METAR 10.0 2018-09-19 06:42:47
KOXV 190615Z AUTO 07007KT 6SM BR OVC003 19/19 A2994 RMK AO2 KOXV 2018-09-19T06:15:00Z 41.28 -93.12 19.0 19.0 70 7 6.0 29.940945 TRUE TRUE BR LIFR SPECI 283.0 2018-09-19 06:42:47
FIMP 190600Z 11012KT 9999 SCT017 26/17 Q1024 FIMP 2018-09-19T06:00:00Z -20.42 57.67 26.0 17.0 110 12 6.21 30.236221 VFR METAR 57.0 2018-09-19 06:42:47
KAXA 190615Z AUTO 11007KT 10SM CLR 17/16 A2998 RMK AO2 PWINO KAXA 2018-09-19T06:15:00Z 43.07 -94.27 17.0 16.0 110 7 10.0 29.97933 TRUE TRUE TRUE VFR METAR 372.0 2018-09-19 06:42:47
CXMM 190600Z AUTO 17004KT M01/M03 RMK AO1 SLP212 T10141033 51002 CXMM 2018-09-19T06:00:00Z 56.65 -111.22 -1.4 -3.3 170 4 1021.2 TRUE TRUE 0.2 METAR 369.0 2018-09-19 06:42:47
KDYL 190554Z AUTO 00000KT 10SM CLR 19/18 A2982 RMK AO2 SLP094 T01890183 10211 20189 53002 KDYL 2018-09-19T05:54:00Z 40.33 -75.12 18.9 18.3 0 0 10.0 29.819881 1009.4 TRUE TRUE VFR 0.2 21.1 18.9 METAR 117.0 2018-09-19 06:42:47
OJAQ 190600Z 01007KT CAVOK 27/18 Q1011 NOSIG OJAQ 2018-09-19T06:00:00Z 29.62 35.02 27.0 18.0 10 7 6.21 29.852362 TRUE VFR METAR 51.0 2018-09-19 06:42:47
LTCJ 190620Z 24004KT 200V270 CAVOK 25/07 Q1013 RMK RWY20 25005KT 200V280 LTCJ 2018-09-19T06:20:00Z 37.93 41.12 25.0 7.0 240 4 6.21 29.911417 VFR SPECI 540.0 2018-09-19 06:42:47
PFNO 190556Z AUTO 11005KT 10SM OVC065 07/05 A3016 RMK AO2 SLP214 60000 T00720050 10111 20072 58004 PFNO 2018-09-19T05:56:00Z 66.82 -161.02 7.2 5.0 110 5 10.0 30.159449 1021.4 TRUE TRUE VFR -0.4 11.1 7.2 0.005 METAR 17.0 2018-09-19 06:42:47
UKBB 190630Z 23002MPS 180V250 CAVOK 18/13 Q1023 R88/D NOSIG UKBB 2018-09-19T06:30:00Z 50.33 30.9 18.0 13.0 230 4 6.21 30.206694 TRUE VFR METAR 119.0 2018-09-19 06:42:46
EHSA 190625Z AUTO 18017KT 9999 ///////// 18/16 Q1014 W17/H9 EHSA 2018-09-19T06:25:00Z 52.0 3.28 18.0 16.0 180 17 6.21 29.940945 TRUE METAR 50.0 2018-09-19 06:42:46
LTFK 190550Z VRB10KT 9999 FEW030 20/15 Q1020 LTFK 2018-09-19T05:50:00Z 40.2 25.88 20.0 15.0 0 10 6.21 30.11811 VFR METAR 21.0 2018-09-19 06:42:47
K2J3 190610Z AUTO 01003KT 10SM SCT075 23/21 A2993 RMK AO2 T02310208 K2J3 2018-09-19T06:10:00Z 32.98 -82.38 23.1 20.8 10 3 10.0 29.929134 TRUE TRUE VFR METAR 100.0 2018-09-19 06:42:47
ENRA 190620Z 08013KT 9999 RA SCT030 BKN045 12/08 Q0993 ENRA 2018-09-19T06:20:00Z 66.37 14.3 12.0 8.0 80 13 6.21 29.320866 RA VFR METAR 70.0 2018-09-19 06:42:47
FAMM 190609Z 03005KT CAVOK 21/M10 Q1020 NOSIG FAMM 2018-09-19T06:09:00Z -25.8 25.52 21.0 -10.0 30 5 6.21 30.11811 TRUE VFR SPECI 1277.0 2018-09-19 06:42:47
KOKV 190615Z AUTO 00000KT 10SM CLR 17/17 A2992 RMK AO2 KOKV 2018-09-19T06:15:00Z 39.13 -78.15 17.0 17.0 0 0 10.0 29.920275 TRUE TRUE VFR SPECI 222.0 2018-09-19 06:42:47
SBMO 190600Z 08006KT 9999 BKN018 BKN070 23/21 Q1014 SBMO 2018-09-19T06:00:00Z -9.52 -35.77 23.0 21.0 80 6 6.21 29.940945 MVFR METAR 115.0 2018-09-19 06:42:47
KSTC 190553Z AUTO 04006KT 10SM OVC012 14/12 A3003 RMK AO2 SLP177 T01390117 10161 20139 401780106 51004 $ KSTC 2018-09-19T05:53:00Z 45.55 -94.05 13.9 11.7 40 6 10.0 30.029528 1017.7 TRUE TRUE TRUE MVFR 0.4 16.1 13.9 17.8 10.6 METAR 314.0 2018-09-19 06:42:47
KGWR 190615Z AUTO 00000KT 10SM 12/10 A3001 RMK A01 KGWR 2018-09-19T06:15:00Z 46.22 -97.65 12.0 10.0 0 0 10.0 30.008858 TRUE TRUE SPECI 386.0 2018-09-19 06:42:47
YCAR 190600Z AUTO 19020KT 9999 // BKN063 OVC075 25/09 Q1018 YCAR 2018-09-19T06:00:00Z -24.88 113.67 25.0 9.0 190 20 6.21 30.059055 TRUE VFR METAR 8.0 2018-09-19 06:42:47
CYVM 190600Z AUTO 13003KT 090V170 9SM CLR M02/M06 A3013 RMK SLP206 CYVM 2018-09-19T06:00:00Z 67.53 -64.02 -2.0 -6.0 130 3 9.0 30.129921 1020.6 TRUE VFR METAR 6.0 2018-09-19 06:42:47
KDEW 190553Z AUTO 00000KT 10SM CLR 06/00 A3001 RMK AO2 SLP165 T00560000 10211 20033 50002 $ KDEW 2018-09-19T05:53:00Z 47.97 -117.43 5.6 0.0 0 0 10.0 30.008858 1016.5 TRUE TRUE TRUE VFR 0.2 21.1 3.3 METAR 674.0 2018-09-19 06:42:47
VYYY 190600Z 09010KTM 3000 RA BKN015 FEW018CB OVC100 29/26 Q1007 VYYY 2018-09-19T06:00:00Z 16.9 96.13 29.0 26.0 1.86 29.734253 RA IFR METAR 33.0 2018-09-19 06:42:47
LFMV 190630Z AUTO 34001KT 5000 BR OVC003 19/19 Q1020 BECMG NSC LFMV 2018-09-19T06:30:00Z 43.9 4.9 19.0 19.0 340 1 3.11 30.11811 TRUE BR LIFR SPECI 38.0 2018-09-19 06:42:46
PKMR 190553Z 07005KT 12SM -SHRA SCT014TCU BKN045 OVC300 29/25 A2972 RMK SHRAB45 TCU OHD SLP064 60006 8/801 T02910250 10315 20291 53007 PKMR 2018-09-19T05:53:00Z 7.08 171.38 29.1 25.0 70 5 12.0 29.719488 1006.4 -SHRA VFR 0.7 31.5 29.1 0.06 METAR 4.0 2018-09-19 06:42:47
KCCB 190615Z AUTO 00000KT 10SM 19/09 A2984 RMK AO2 KCCB 2018-09-19T06:15:00Z 34.12 -117.68 19.0 9.0 0 0 10.0 29.840551 TRUE TRUE METAR 440.0 2018-09-19 06:42:47
EINN 190630Z 19025G37KT 6000 -RA FEW012 SCT018 BKN024 15/13 Q0991 NOSIG EINN 2018-09-19T06:30:00Z 52.7 -8.92 15.0 13.0 190 25 37 3.73 29.26181 TRUE -RA MVFR METAR 20.0 2018-09-19 06:42:46
KDUX 190615Z AUTO 17007KT 10SM CLR 20/16 A2998 RMK AO2 T01960155 KDUX 2018-09-19T06:15:00Z 35.85 -102.02 19.6 15.5 170 7 10.0 29.97933 TRUE TRUE VFR SPECI 1129.0 2018-09-19 06:42:47
KHRT 190556Z AUTO 00000KT 10SM CLR 25/22 A2991 RMK AO2 SLP130 T02540217 10293 20251 403280240 58004 FZRANO $ KHRT 2018-09-19T05:56:00Z 30.42 -86.67 25.4 21.7 0 0 10.0 29.911417 1013.0 TRUE TRUE TRUE TRUE VFR -0.4 29.3 25.1 32.8 24.0 SPECI 12.0 2018-09-19 06:42:47
KAQW 190625Z AUTO 00000KT 1 3/4SM BR BKN004 OVC009 18/18 A2983 RMK AO2 T01830183 KAQW 2018-09-19T06:25:00Z 42.7 -73.17 18.3 18.3 0 0 1.75 29.828741 TRUE TRUE BR LIFR SPECI 199.0 2018-09-19 06:42:46
CPRY 190600Z AUTO 05003KT 06/04 RMK AO1 T00560042 CPRY 2018-09-19T06:00:00Z 49.48 -112.68 5.6 4.2 50 3 TRUE TRUE METAR 937.0 2018-09-19 06:42:47
KHVE 190615Z AUTO 00000KT 10SM CLR 25/01 A2989 RMK AO2 KHVE 2018-09-19T06:15:00Z 38.42 -110.7 25.0 1.0 0 0 10.0 29.890747 TRUE TRUE VFR METAR 1350.0 2018-09-19 06:42:47
K12N 190554Z AUTO 00000KT 17/17 A2985 RMK AO1 SLP102 T01720167 10206 20172 53004 K12N 2018-09-19T05:54:00Z 41.02 -74.73 17.2 16.7 0 0 29.84941 1010.2 TRUE TRUE 0.4 20.6 17.2 METAR 177.0 2018-09-19 06:42:47
ETHF 190620Z VRB02KT 9999 FEW100 SCT220 13/12 Q1019 BLU+ ETHF 2018-09-19T06:20:00Z 51.12 9.27 13.0 12.0 0 2 6.21 30.088583 VFR METAR 181.0 2018-09-19 06:42:47
EGXU 190550Z 20012KT 9999 FEW012 SCT210 14/11 Q1005 BLU TEMPO 19018G28KT BLU EGXU 2018-09-19T05:50:00Z 54.05 -1.25 14.0 11.0 200 12 6.21 29.675198 VFR METAR 16.0 2018-09-19 06:42:47
KTOP 190553Z AUTO 18005KT 10SM CLR 26/22 A2989 RMK AO2 SLP109 T02560217 10328 20233 403560211 58000 KTOP 2018-09-19T05:53:00Z 39.07 -95.63 25.6 21.7 180 5 10.0 29.890747 1010.9 TRUE TRUE VFR 0.0 32.8 23.3 35.6 21.1 METAR 268.0 2018-09-19 06:42:47
ENTC 190620Z VRB04G14KT CAVOK 06/04 Q1000 NOSIG RMK WIND 2600FT 13012KT ENTC 2018-09-19T06:20:00Z 69.68 18.92 6.0 4.0 0 4 14 6.21 29.52756 TRUE VFR METAR 10.0 2018-09-19 06:42:47
CYNA 190600Z AUTO 04006KT 9SM CLR 01/M02 A3015 RMK SLP211 CYNA 2018-09-19T06:00:00Z 50.17 -61.82 1.0 -2.0 40 6 9.0 30.15059 1021.1 TRUE VFR METAR 11.0 2018-09-19 06:42:47
YMEK 190600Z AUTO 16009KT 090V170 9999 // NCD 24/M07 Q1021 YMEK 2018-09-19T06:00:00Z -26.62 118.55 24.0 -7.0 160 9 6.21 30.147638 TRUE VFR METAR 522.0 2018-09-19 06:42:47
KTTN 190553Z AUTO 32005KT 10SM CLR 20/19 A2980 RMK AO2 SLP085 T02000189 10222 20200 53002 KTTN 2018-09-19T05:53:00Z 40.28 -74.82 20.0 18.9 320 5 10.0 29.799213 1008.5 TRUE TRUE VFR 0.2 22.2 20.0 METAR 59.0 2018-09-19 06:42:47

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query