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
LGIR 210420Z 17007KT 9999 FEW020 23/11 Q1008 NOSIG LGIR 2017-08-21T04:20:00Z 35.32 25.17 23.0 11.0 170 7 6.21 29.763779 TRUE VFR METAR 39.0 2017-08-21 04:36:42
EHGG 210425Z AUTO 24004KT 9999 SCT023 BKN027 BKN031 09/09 Q1022 NOSIG EHGG 2017-08-21T04:25:00Z 53.12 6.57 9.0 9.0 240 4 6.21 30.177166 TRUE TRUE MVFR METAR 4.0 2017-08-21 04:36:42
KDAB 210353Z 00000KT 10SM FEW050 SCT150 OVC200 27/26 A3012 RMK AO2 SLP198 T02670256 $ KDAB 2017-08-21T03:53:00Z 29.18 -81.07 26.7 25.6 0 0 10.0 30.121063 1019.8 TRUE TRUE VFR METAR 9.0 2017-08-21 04:36:43
KIAG 210353Z AUTO 19005KT 8SM CLR 21/17 A3011 RMK AO2 SLP193 T02060172 KIAG 2017-08-21T03:53:00Z 43.12 -78.93 20.6 17.2 190 5 8.0 30.109253 1019.3 TRUE TRUE VFR METAR 182.0 2017-08-21 04:36:42
URWI 210400Z AUTO 07005MPS 9999 // ///110/// 21/09 Q1017 URWI 2017-08-21T04:00:00Z 46.37 44.33 21.0 9.0 70 10 6.21 30.029528 TRUE METAR 150.0 2017-08-21 04:36:42
KMTH 210415Z AUTO 08006KT 10SM FEW020 SCT026 BKN035 29/27 A3005 RMK AO2 RAE0358 P0000 T02890272 KMTH 2017-08-21T04:15:00Z 24.73 -81.05 28.9 27.2 80 6 10.0 30.050198 TRUE TRUE VFR 0.005 METAR 2.0 2017-08-21 04:36:42
KAOH 210353Z AUTO 00000KT 10SM CLR 20/19 A3011 RMK AO2 SLP188 T02000194 KAOH 2017-08-21T03:53:00Z 40.7 -84.02 20.0 19.4 0 0 10.0 30.109253 1018.8 TRUE TRUE VFR METAR 296.0 2017-08-21 04:36:43
LFBY 210400Z AUTO 09002KT //// // ////// 13/12 Q1021 LFBY 2017-08-21T04:00:00Z 43.67 -1.07 13.0 12.0 90 2 30.147638 TRUE METAR 32.0 2017-08-21 04:36:42
KGDJ 210415Z AUTO 10005KT 10SM CLR 29/20 A3002 RMK AO2 T02920202 KGDJ 2017-08-21T04:15:00Z 32.45 -97.82 29.2 20.2 100 5 10.0 30.02067 TRUE TRUE VFR METAR 237.0 2017-08-21 04:36:42
KIKT 210415Z AUTO 08012KT 10SM FEW030 FEW041 SCT055 30/23 A3009 RMK A01 KIKT 2017-08-21T04:15:00Z 28.52 -88.28 30.0 23.0 80 12 10.0 30.088583 TRUE TRUE VFR METAR 25.0 2017-08-21 04:36:42
KODX 210353Z AUTO 07005KT 10SM FEW021 23/20 A2997 RMK AO2 SLP136 T02280200 $ KODX 2017-08-21T03:53:00Z 41.62 -98.95 22.8 20.0 70 5 10.0 29.970472 1013.6 TRUE TRUE TRUE VFR METAR 631.0 2017-08-21 04:36:42
CXMI 210400Z AUTO 32004KT 19/16 RMK AO1 T01860157 CXMI 2017-08-21T04:00:00Z 44.6 -63.53 18.6 15.7 320 4 TRUE TRUE METAR 15.0 2017-08-21 04:36:42
PAGY 210415Z AUTO 24004KT 10SM -RA SCT004 OVC060 A2983 RMK AO2 P0000 TSNO $ PAGY 2017-08-21T04:15:00Z 59.47 -135.3 240 4 10.0 29.828741 TRUE TRUE TRUE TRUE -RA VFR 0.005 METAR 5.0 2017-08-21 04:36:42
KSMP 210356Z AUTO 23004KT 10SM CLR 12/09 A3020 RMK AO2 SLP215 T01170089 KSMP 2017-08-21T03:56:00Z 47.28 -121.33 11.7 8.9 230 4 10.0 30.200787 1021.5 TRUE TRUE VFR METAR 1208.0 2017-08-21 04:36:42
KGCN 210354Z 00000KT 10SM CLR 15/09 A3029 RMK AO2 SLP163 T01500094 $ KGCN 2017-08-21T03:54:00Z 35.95 -112.15 15.0 9.4 0 0 10.0 30.28937 1016.3 TRUE TRUE VFR METAR 2016.0 2017-08-21 04:36:42
K3L4 210415Z AUTO 13005KT 10SM CLR 28/26 A3005 RMK A01 K3L4 2017-08-21T04:15:00Z 29.8 -92.8 28.0 26.0 130 5 10.0 30.050198 TRUE TRUE VFR METAR 2.0 2017-08-21 04:36:42
PADM 210356Z AUTO 35010KT 10SM FEW037 BKN048 11/06 A2994 RMK AO2 RAB24E42 SLP147 P0000 T01110061 PADM 2017-08-21T03:56:00Z 61.87 -162.03 11.1 6.1 350 10 10.0 29.940945 1014.7 TRUE TRUE VFR 0.005 METAR 31.0 2017-08-21 04:36:42
LTCA 210350Z 27004KT CAVOK 19/02 Q1012 NOSIG LTCA 2017-08-21T03:50:00Z 38.6 39.27 19.0 2.0 270 4 6.21 29.88189 TRUE VFR METAR 882.0 2017-08-21 04:36:43
ESCF 210420Z 19004KT 9999 R01/0700VP2000D R19/0325N MIFG NSC 08/07 Q1012 ESCF 2017-08-21T04:20:00Z 58.38 15.52 8.0 7.0 190 4 6.21 29.88189 MIFG VFR METAR 117.0 2017-08-21 04:36:42
ZUUU 210400Z 01002MPS 340V050 9999 -SHRA FEW010 SCT026 26/25 Q1005 NOSIG ZUUU 2017-08-21T04:00:00Z 30.58 103.95 26.0 25.0 10 4 6.21 29.675198 TRUE -SHRA VFR METAR 508.0 2017-08-21 04:36:42
ZMUB 210430Z 23003MPS 190V260 9999 FEW030CB SCT033 17/09 Q1013 NOSIG RMK QFE652.7 57 MOP ZMUB 2017-08-21T04:30:00Z 47.83 106.78 17.0 9.0 230 6 6.21 29.911417 TRUE VFR SPECI 1330.0 2017-08-21 04:36:42
ENSE 210420Z AUTO 32021KT 9999NDV OVC017/// 12/10 Q1018 W///S4 ENSE 2017-08-21T04:20:00Z 61.45 2.15 12.0 10.0 320 21 30.059055 TRUE METAR 10.0 2017-08-21 04:36:42
KUYF 210415Z AUTO 25003KT 10SM CLR 20/19 A3012 RMK AO2 KUYF 2017-08-21T04:15:00Z 39.93 -83.47 20.0 19.0 250 3 10.0 30.121063 TRUE TRUE VFR METAR 330.0 2017-08-21 04:36:42
CWBE 210400Z AUTO 26004KT 21/16 RMK AO1 SLP174 T02070158 53001 CWBE 2017-08-21T04:00:00Z 45.98 -81.48 20.7 15.8 260 4 1017.4 TRUE TRUE 0.1 METAR 196.0 2017-08-21 04:36:42
KOXR 210351Z 19004KT 10SM CLR 19/14 A2992 RMK AO2 SLP131 T01890144 $ KOXR 2017-08-21T03:51:00Z 34.2 -119.2 18.9 14.4 190 4 10.0 29.920275 1013.1 TRUE TRUE VFR METAR 20.0 2017-08-21 04:36:43
CYBK 210400Z 10021KT 20SM FEW240 10/03 A2989 RMK CI2 SLP126 CYBK 2017-08-21T04:00:00Z 64.28 -96.07 10.0 3.0 100 21 20.0 29.890747 1012.6 VFR METAR 18.0 2017-08-21 04:36:42
OEWJ 210400Z 28012KT CAVOK 30/28 Q1003 NOSIG OEWJ 2017-08-21T04:00:00Z 26.18 36.47 30.0 28.0 280 12 6.21 29.616142 TRUE VFR METAR 16.0 2017-08-21 04:36:42
KLDM 210415Z AUTO 00000KT 10SM CLR 21/16 A3004 RMK AO2 T02050159 KLDM 2017-08-21T04:15:00Z 43.97 -86.4 20.5 15.9 0 0 10.0 30.041338 TRUE TRUE VFR METAR 197.0 2017-08-21 04:36:42
KGBD 210356Z AUTO 16009KT 10SM CLR 27/21 A2999 RMK AO2 SLP135 T02670206 KGBD 2017-08-21T03:56:00Z 38.35 -98.87 26.7 20.6 160 9 10.0 29.991142 1013.5 TRUE TRUE VFR METAR 575.0 2017-08-21 04:36:42
LEBT 210400Z AUTO 01003KT 9999 // FEW042 22/20 Q1020 LEBT 2017-08-21T04:00:00Z 39.58 -0.45 22.0 20.0 10 3 6.21 30.11811 TRUE VFR METAR 50.0 2017-08-21 04:36:42
KEYE 210353Z AUTO 00000KT 10SM CLR 25/20 A3007 RMK AO2 SLP175 T02500200 KEYE 2017-08-21T03:53:00Z 39.83 -86.3 25.0 20.0 0 0 10.0 30.070866 1017.5 TRUE TRUE VFR METAR 248.0 2017-08-21 04:36:42
CXGH 210400Z AUTO 23006KT 19/10 RMK AO1 T01850103 CXGH 2017-08-21T04:00:00Z 50.63 -97.0 18.5 10.3 230 6 TRUE TRUE METAR 217.0 2017-08-21 04:36:42
EDDL 210420Z VRB01KT CAVOK 10/10 Q1023 NOSIG EDDL 2017-08-21T04:20:00Z 51.3 6.77 10.0 10.0 0 1 6.21 30.206694 TRUE VFR METAR 44.0 2017-08-21 04:36:42
RJFY 210350Z 10002KT 9999 FEW003 SCT010 FEW010CB BKN030 27/25 Q1012 RETS RMK 1ST003 4CU010 1CB010 7CU030 A2990 CB 30KM W MOV N RJFY 2017-08-21T03:50:00Z 31.37 130.82 27.0 25.0 100 2 6.21 29.88189 BKN 3000 MVFR METAR 68.0 2017-08-21 04:36:43
KSMO 210426Z AUTO 22004KT 10SM BKN014 19/16 A2995 RMK AO2 T01940161 KSMO 2017-08-21T04:26:00Z 34.02 -118.45 19.4 16.1 220 4 10.0 29.949802 TRUE TRUE MVFR METAR 57.0 2017-08-21 04:36:42
KF70 210415Z AUTO 17009KT 10SM CLR 18/14 A2996 RMK AO1 KF70 2017-08-21T04:15:00Z 33.57 -117.13 18.0 14.0 170 9 10.0 29.958662 TRUE TRUE VFR METAR 412.0 2017-08-21 04:36:42
KGGP 210415Z AUTO 13006KT 10SM CLR 21/18 A3008 RMK AO2 KGGP 2017-08-21T04:15:00Z 40.72 -86.37 21.0 18.0 130 6 10.0 30.079725 TRUE TRUE VFR METAR 225.0 2017-08-21 04:36:42
LFBH 210400Z AUTO 08005KT CAVOK 14/10 Q1023 NOSIG LFBH 2017-08-21T04:00:00Z 46.18 -1.2 14.0 10.0 80 5 6.21 30.206694 TRUE TRUE VFR METAR 10.0 2017-08-21 04:36:42
KSRC 210356Z AUTO 08003KT 10SM CLR 26/24 A3008 RMK AO2 SLP187 T02610244 TSNO KSRC 2017-08-21T03:56:00Z 35.22 -91.73 26.1 24.4 80 3 10.0 30.079725 1018.7 TRUE TRUE TRUE VFR METAR 80.0 2017-08-21 04:36:42
LTCD 210350Z 00000KT CAVOK 16/10 Q1015 NOSIG LTCD 2017-08-21T03:50:00Z 39.72 39.5 16.0 10.0 0 0 6.21 29.970472 TRUE VFR METAR 1215.0 2017-08-21 04:36:43
UWOO 210400Z 04006MPS CAVOK 20/11 Q1022 R26/CLRD65 NOSIG RMK QFE756/1008 UWOO 2017-08-21T04:00:00Z 51.8 55.47 20.0 11.0 40 12 6.21 30.177166 TRUE VFR METAR 109.0 2017-08-21 04:36:42
KFWA 210354Z 00000KT 10SM FEW120 BKN200 21/18 A3010 RMK AO2 SLP186 T02110178 $ KFWA 2017-08-21T03:54:00Z 40.98 -85.18 21.1 17.8 0 0 10.0 30.100393 1018.6 TRUE TRUE VFR METAR 248.0 2017-08-21 04:36:42
KNJK 210356Z AUTO 31003KT 10SM CLR 33/08 A2975 RMK AO2 SLP089 T03330083 $ KNJK 2017-08-21T03:56:00Z 32.82 -115.67 33.3 8.3 310 3 10.0 29.749016 1008.9 TRUE TRUE TRUE VFR METAR -13.0 2017-08-21 04:36:42
KAHN 210351Z AUTO 00000KT 10SM CLR 24/23 A3014 RMK AO2 SLP198 T02440228 KAHN 2017-08-21T03:51:00Z 33.95 -83.33 24.4 22.8 0 0 10.0 30.138779 1019.8 TRUE TRUE VFR METAR 244.0 2017-08-21 04:36:43
LLET 210350Z 01011KT CAVOK 29/19 Q1009 LLET 2017-08-21T03:50:00Z 29.55 34.95 29.0 19.0 10 11 6.21 29.793306 VFR METAR 13.0 2017-08-21 04:36:43
LTBJ 210420Z VRB03KT CAVOK 22/19 Q1008 NOSIG RMK RWY16 00000KT LTBJ 2017-08-21T04:20:00Z 38.28 27.15 22.0 19.0 0 3 6.21 29.763779 TRUE VFR SPECI 120.0 2017-08-21 04:36:42
EDDG 210420Z VRB01KT 9999 0800NW R25/0800VP2000D BCFG NSC 07/07 Q1023 NOSIG EDDG 2017-08-21T04:20:00Z 52.13 7.7 7.0 7.0 0 1 6.21 30.206694 TRUE BCFG VFR METAR 52.0 2017-08-21 04:36:42
KIDI 210415Z AUTO 00000KT 10SM CLR 17/16 A3023 RMK A01 KIDI 2017-08-21T04:15:00Z 40.62 -79.08 17.0 16.0 0 0 10.0 30.230314 TRUE TRUE VFR METAR 429.0 2017-08-21 04:36:42
CYCY 210400Z AUTO 15002KT 9SM CLR 01/00 A2992 RMK SLP135 CYCY 2017-08-21T04:00:00Z 70.47 -68.52 1.0 0.0 150 2 9.0 29.920275 1013.5 TRUE VFR METAR 26.0 2017-08-21 04:36:42
RJOY 210400Z 26007KT 170V300 9999 FEW035 SCT/// 34/21 Q1011 RJOY 2017-08-21T04:00:00Z 34.6 135.58 34.0 21.0 260 7 6.21 29.852362 VFR SPECI 13.0 2017-08-21 04:36:42

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query