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
PAWN 171956Z AUTO 20007KT 10SM FEW004 OVC025 12/11 A2969 RMK AO2 RAE50 SLP065 P0003 T01220111 PAWN 2019-07-17T19:56:00Z 67.57 -162.98 12.2 11.1 200 7 10.0 29.68996 1006.5 TRUE TRUE MVFR 0.03 METAR 30.0 2019-07-17 20:26:42
OMRK 172000Z 14008KT CAVOK 36/21 Q0997 A2945 OMRK 2019-07-17T20:00:00Z 25.62 55.92 36.0 21.0 140 8 6.21 29.438976 VFR METAR 31.0 2019-07-17 20:26:42
KCRS 171953Z AUTO 19011KT 10SM SCT047 SCT055 33/23 A3004 RMK AO2 SLP165 T03330228 $ KCRS 2019-07-17T19:53:00Z 32.03 -96.4 33.3 22.8 190 11 10.0 30.041338 1016.5 TRUE TRUE TRUE VFR METAR 133.0 2019-07-17 20:26:42
ZSSS 172000Z 13004MPS 9999 BKN012 27/26 Q1003 NOSIG ZSSS 2019-07-17T20:00:00Z 31.2 121.33 27.0 26.0 130 8 6.21 29.616142 TRUE MVFR METAR 7.0 2019-07-17 20:26:42
KLNA 172015Z AUTO 11011G14KT 10SM CLR 32/25 A3010 RMK AO2 LTG DSNT SW T03230250 KLNA 2019-07-17T20:15:00Z 26.6 -80.02 32.3 25.0 110 11 14 10.0 30.100393 TRUE TRUE VFR METAR 11.0 2019-07-17 20:26:42
KTOC 171955Z AUTO 36003KT 10SM -RA SCT027 BKN048 BKN065 23/21 A3011 RMK AO2 T02310211 KTOC 2019-07-17T19:55:00Z 34.6 -83.3 23.1 21.1 360 3 10.0 30.109253 TRUE TRUE -RA VFR METAR 304.0 2019-07-17 20:26:42
CYPQ 172000Z AUTO VRB03KT 9SM BKN090 BKN110 24/22 A2987 RMK SLP115 DENSITY ALT 1800FT CYPQ 2019-07-17T20:00:00Z 44.22 -78.37 24.0 22.0 0 3 9.0 29.870079 1011.5 TRUE VFR METAR 191.0 2019-07-17 20:26:42
LGSR 171950Z 34017KT 9999 FEW025 24/18 Q1007 RMK FEW080 BLU LGSR 2019-07-17T19:50:00Z 36.4 25.48 24.0 18.0 340 17 6.21 29.734253 VFR METAR 40.0 2019-07-17 20:26:42
FAPE 172000Z 28004KT 9000 NSC 12/09 Q1018 NOSIG FAPE 2019-07-17T20:00:00Z -33.97 25.6 12.0 9.0 280 4 5.59 30.059055 TRUE VFR METAR 60.0 2019-07-17 20:26:42
KHEY 171958Z AUTO 30004KT 10SM FEW055 34/22 A3007 RMK AO2 SLP181 T03360216 KHEY 2019-07-17T19:58:00Z 31.35 -85.65 33.6 21.6 300 4 10.0 30.070866 1018.1 TRUE TRUE VFR METAR 97.0 2019-07-17 20:26:42
K1LM 171957Z AUTO 24013G18KT 10SM FEW055 SCT085 BKN170 21/11 A2990 RMK AO2 SLP103 T02060105 $ K1LM 2019-07-17T19:57:00Z 46.7 -109.73 20.6 10.5 240 13 18 10.0 29.899607 1010.3 TRUE TRUE TRUE VFR METAR 1414.0 2019-07-17 20:26:42
CYMM 172018Z AUTO 15016G22KT 9SM TS SCT060 BKN073 BKN084 OVC130 20/10 A2958 RMK LTNG DIST S SLP025 DENSITY ALT 2500FT CYMM 2019-07-17T20:18:00Z 56.65 -111.22 20.0 10.0 150 16 22 9.0 29.58071 1002.5 TRUE TS OVC 13000 VFR SPECI 369.0 2019-07-17 20:26:42
MDSD 172000Z 09009KT 060V120 5000 TSRA FEW014CB BKN016 BKN070 26/24 Q1016 CB/NE/E/SE/S MDSD 2019-07-17T20:00:00Z 18.42 -69.67 26.0 24.0 90 9 3.11 30.0 TSRA MVFR SPECI 18.0 2019-07-17 20:26:42
YWGT 172000Z AUTO 28008KT 9999 // SCT039 07/05 Q1017 YWGT 2019-07-17T20:00:00Z -36.42 146.3 7.0 5.0 280 8 6.21 30.029528 TRUE VFR METAR 153.0 2019-07-17 20:26:42
KGWO 171953Z AUTO 20008KT 10SM SCT031 32/24 A3007 RMK AO2 SLP180 T03220244 PWINO $ KGWO 2019-07-17T19:53:00Z 33.5 -90.08 32.2 24.4 200 8 10.0 30.070866 1018.0 TRUE TRUE TRUE TRUE VFR METAR 44.0 2019-07-17 20:26:42
LHSM 171945Z AUTO 00000KT 9000 -SHRA NCD 20/16 Q1012 RESHRA LHSM 2019-07-17T19:45:00Z 46.68 17.17 20.0 16.0 0 0 5.59 29.88189 TRUE -SHRA VFR METAR 125.0 2019-07-17 20:26:42
KEKY 171956Z AUTO VRB06KT 10SM CLR 33/24 A3011 RMK AO2 SLP040 T03280244 KEKY 2019-07-17T19:56:00Z 33.32 -86.93 32.8 24.4 0 6 10.0 30.109253 1004.0 TRUE TRUE VFR METAR 213.0 2019-07-17 20:26:42
CXDW 172000Z AUTO 03004KT 20/17 RMK AO1 9PAST HR 8013 SLP063 P0007 T02000169 50025 CXDW 2019-07-17T20:00:00Z 49.4 -98.32 20.0 16.9 30 4 1006.3 TRUE TRUE 2.5 0.07 METAR 341.0 2019-07-17 20:26:42
KBGM 171953Z 01006KT 10SM SCT037 BKN080 BKN100 26/21 A2994 RMK AO2 LTG DSNT SE-SW RAB1855E18 SLP127 P0000 T02560206 KBGM 2019-07-17T19:53:00Z 42.22 -75.98 25.6 20.6 10 6 10.0 29.940945 1012.7 TRUE VFR 0.005 METAR 490.0 2019-07-17 20:26:42
KWST 171953Z AUTO 20012G18KT 10SM CLR 29/24 A2989 RMK AO2 LTG DSNT NW SLP121 T02890244 KWST 2019-07-17T19:53:00Z 41.35 -71.8 28.9 24.4 200 12 18 10.0 29.890747 1012.1 TRUE TRUE VFR METAR 21.0 2019-07-17 20:26:42
KEIK 172018Z AUTO 33005KT 10SM CLR 33/01 A3000 RMK AO2 T03300010 KEIK 2019-07-17T20:18:00Z 40.02 -105.05 33.0 1.0 330 5 10.0 30.0 TRUE TRUE VFR METAR 1564.0 2019-07-17 20:26:42
LFRG 172000Z AUTO 30004KT 270V340 CAVOK 16/12 Q1014 NOSIG LFRG 2019-07-17T20:00:00Z 49.37 0.15 16.0 12.0 300 4 6.21 29.940945 TRUE TRUE VFR METAR 146.0 2019-07-17 20:26:42
KDLO 172015Z AUTO 01006KT 10SM CLR 31/09 A2987 RMK AO2 T03090092 KDLO 2019-07-17T20:15:00Z 35.75 -119.23 30.9 9.2 10 6 10.0 29.870079 TRUE TRUE VFR METAR 96.0 2019-07-17 20:26:42
LFLN 172000Z AUTO 32002KT CAVOK 23/08 Q1013 NOSIG LFLN 2019-07-17T20:00:00Z 46.42 4.02 23.0 8.0 320 2 6.21 29.911417 TRUE TRUE VFR METAR 244.0 2019-07-17 20:26:42
CXMO 172000Z AUTO 18010KT 22/13 RMK AO1 T02170133 CXMO 2019-07-17T20:00:00Z 51.67 -112.68 21.7 13.3 180 10 TRUE TRUE METAR 836.0 2019-07-17 20:26:42
KUUU 171953Z AUTO 20006KT 9SM CLR 27/24 A2988 RMK AO2 SLP115 T02720239 KUUU 2019-07-17T19:53:00Z 41.53 -71.28 27.2 23.9 200 6 9.0 29.878937 1011.5 TRUE TRUE VFR METAR 51.0 2019-07-17 20:26:42
KJAU 172015Z AUTO 22005KT 10SM BKN026 OVC032 27/22 A3007 RMK A01 KJAU 2019-07-17T20:15:00Z 36.33 -84.17 27.0 22.0 220 5 10.0 30.070866 TRUE TRUE MVFR SPECI 360.0 2019-07-17 20:26:42
KAKH 171954Z AUTO 23006KT 10SM SCT065 35/21 A3002 RMK AO2 SLP157 T03500211 KAKH 2019-07-17T19:54:00Z 35.2 -81.15 35.0 21.1 230 6 10.0 30.02067 1015.7 TRUE TRUE VFR METAR 243.0 2019-07-17 20:26:42
FJDG 171955Z 14013KT 8000 -SHRA SCT017 SCT036 BKN080 27/25 A2984 RMK SLP102 T02670253 FJDG 2019-07-17T19:55:00Z -7.32 72.42 26.7 25.3 140 13 4.97 29.840551 1010.2 -SHRA MVFR SPECI 3.0 2019-07-17 20:26:42
CYIN 172000Z AUTO 15011G17KT 9SM OVC075 15/09 A2968 RMK SLP043 DENSITY ALT 4800FT CYIN 2019-07-17T20:00:00Z 51.27 -121.68 15.0 9.0 150 11 17 9.0 29.681103 1004.3 TRUE VFR METAR 1128.0 2019-07-17 20:26:42
LFBA 172000Z AUTO 30010KT CAVOK 24/12 Q1016 TEMPO 32015G25KT LFBA 2019-07-17T20:00:00Z 44.17 0.6 24.0 12.0 300 10 6.21 30.0 TRUE VFR METAR 60.0 2019-07-17 20:26:42
FAVV 172000Z AUTO 34004KT //// // ////// 06/M01 Q1028 FAVV 2019-07-17T20:00:00Z -26.57 27.97 6.0 -1.0 340 4 30.35433 TRUE SPECI 1483.0 2019-07-17 20:26:42
LGAD 171950Z 00000KT 9999 FEW020 21/18 Q1010 LGAD 2019-07-17T19:50:00Z 37.92 21.27 21.0 18.0 0 0 6.21 29.822834 VFR METAR 12.0 2019-07-17 20:26:42
KAMW 171953Z AUTO 10SM 21/19 A2990 RMK AO2 SLP118 T02060194 KAMW 2019-07-17T19:53:00Z 41.98 -93.62 20.6 19.4 10.0 29.899607 1011.8 TRUE TRUE METAR 279.0 2019-07-17 20:26:42
ENQC 171950Z AUTO 15018KT 9999NDV FEW008/// BKN110/// 13/11 Q1008 W///S3 ENQC 2019-07-17T19:50:00Z 60.88 3.62 13.0 11.0 150 18 29.763779 TRUE METAR 20.0 2019-07-17 20:26:42
KMRH 171958Z AUTO 20013KT 10SM CLR 31/26 A3005 RMK AO2 SLP176 T03110256 KMRH 2019-07-17T19:58:00Z 34.73 -76.65 31.1 25.6 200 13 10.0 30.050198 1017.6 TRUE TRUE VFR SPECI 3.0 2019-07-17 20:26:42
KALW 171953Z 24012G17KT 10SM OVC080 26/09 A2989 RMK AO2 SLP116 T02560089 KALW 2019-07-17T19:53:00Z 46.1 -118.28 25.6 8.9 240 12 17 10.0 29.890747 1011.6 TRUE VFR METAR 363.0 2019-07-17 20:26:42
ZGOW 172000Z 00000MPS 8000 NSC 28/26 Q0998 NOSIG ZGOW 2019-07-17T20:00:00Z 23.55 116.5 28.0 26.0 0 0 4.97 29.468504 TRUE MVFR METAR 3.0 2019-07-17 20:26:42
KC35 172015Z AUTO 23010KT 10SM BKN034 BKN043 OVC060 27/22 A2991 RMK AO2 T02690218 PWINO KC35 2019-07-17T20:15:00Z 43.53 -89.98 26.9 21.8 230 10 10.0 29.911417 TRUE TRUE TRUE VFR METAR 276.0 2019-07-17 20:26:42
OETB 172000Z 27006KT 9999 BKN040 37/03 Q1010 NOSIG OETB 2019-07-17T20:00:00Z 28.37 36.62 37.0 3.0 270 6 6.21 29.822834 TRUE VFR METAR 770.0 2019-07-17 20:26:42
KFZY 172002Z AUTO 00000KT 10SM -RA BKN021 BKN045 OVC110 23/19 A2991 RMK AO2 P0000 T02280194 KFZY 2019-07-17T20:02:00Z 43.35 -76.38 22.8 19.4 0 0 10.0 29.911417 TRUE TRUE -RA MVFR 0.005 SPECI 138.0 2019-07-17 20:26:42
KT20 171955Z AUTO 17011G16KT 10SM BKN048 BKN060 BKN080 35/24 A3000 RMK AO2 T03530239 KT20 2019-07-17T19:55:00Z 29.52 -97.47 35.3 23.9 170 11 16 10.0 30.0 TRUE TRUE VFR SPECI 108.0 2019-07-17 20:26:42
OJAM 172000Z 25010KT 6000 NSC 28/11 Q1010 NOSIG OJAM 2019-07-17T20:00:00Z 31.97 35.97 28.0 11.0 250 10 3.73 29.822834 TRUE MVFR METAR 773.0 2019-07-17 20:26:42
EGPU 171950Z AUTO 23009KT 130V190 9999 SCT013/// SCT036/// 15/13 Q1004 EGPU 2019-07-17T19:50:00Z 56.5 -6.87 15.0 13.0 230 9 6.21 29.64567 TRUE VFR METAR 12.0 2019-07-17 20:26:42
ETHL 171920Z 36002KT 9999 FEW070 20/11 Q1013 BLU+ ETHL 2019-07-17T19:20:00Z 48.22 9.92 20.0 11.0 360 2 6.21 29.911417 VFR METAR 549.0 2019-07-17 20:26:42
KW13 172015Z AUTO 17004KT 10SM SCT120 27/24 A3001 RMK AO1 T02690238 KW13 2019-07-17T20:15:00Z 38.08 -78.95 26.9 23.8 170 4 10.0 30.008858 TRUE TRUE VFR METAR 443.0 2019-07-17 20:26:42
KMBL 171956Z AUTO 32007KT 10SM CLR 30/18 A2992 RMK AO2 SLP128 T03000183 KMBL 2019-07-17T19:56:00Z 44.27 -86.25 30.0 18.3 320 7 10.0 29.920275 1012.8 TRUE TRUE VFR METAR 189.0 2019-07-17 20:26:42
KRYW 172015Z AUTO 16009G16KT 10SM SCT050 SCT065 34/21 A3005 RMK AO2 T03350213 KRYW 2019-07-17T20:15:00Z 30.5 -97.97 33.5 21.3 160 9 16 10.0 30.050198 TRUE TRUE VFR METAR 376.0 2019-07-17 20:26:42
KTTA 172015Z AUTO 20008G14KT 160V220 7SM CLR 35/22 A2998 RMK AO2 T03510215 KTTA 2019-07-17T20:15:00Z 35.58 -79.1 35.1 21.5 200 8 14 7.0 29.97933 TRUE TRUE VFR METAR 75.0 2019-07-17 20:26:42
HEMM 172000Z 31009KT CAVOK 26/21 Q1008 NOSIG HEMM 2019-07-17T20:00:00Z 31.32 27.22 26.0 21.0 310 9 6.21 29.763779 TRUE VFR METAR 30.0 2019-07-17 20:26:42

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query