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
KAVL 120654Z AUTO 00000KT 10SM OVC050 12/06 A2995 RMK AO2 SLP126 T01220056 KAVL 2019-11-12T06:54:00Z 35.43 -82.53 12.2 5.6 0 0 10.0 29.949802 1012.6 TRUE TRUE VFR METAR 670.0 2019-11-12 08:02:06
VTCC 120700Z 16005KT 110V260 9999 FEW035 32/23 Q1012 NOSIG VTCC 2019-11-12T07:00:00Z 18.77 98.97 32.0 23.0 160 5 6.21 29.88189 TRUE VFR METAR 314.0 2019-11-12 08:02:06
DAAT 120730Z 32017KT CAVOK 11/M06 Q1013 DAAT 2019-11-12T07:30:00Z 22.82 5.47 11.0 -6.0 320 17 6.21 29.911417 VFR METAR 1377.0 2019-11-12 08:02:06
KNEL 120700Z AUTO 20009G19KT 10SM CLR 14/07 A2975 RMK AO2 SLP072 T01390067 $ KNEL 2019-11-12T07:00:00Z 40.02 -74.33 13.9 6.7 200 9 19 10.0 29.749016 1007.2 TRUE TRUE TRUE VFR METAR 31.0 2019-11-12 08:02:06
EPRA 120730Z 15010KT CAVOK 06/06 Q1013 EPRA 2019-11-12T07:30:00Z 51.38 21.22 6.0 6.0 150 10 6.21 29.911417 VFR METAR 178.0 2019-11-12 08:02:06
KENL 120735Z AUTO 33012G16KT 10SM CLR M09/M14 A3049 RMK AO2 T10901138 KENL 2019-11-12T07:35:00Z 38.52 -89.1 -9.0 -13.8 330 12 16 10.0 30.490158 TRUE TRUE VFR SPECI 163.0 2019-11-12 08:02:06
KANW 120735Z AUTO 20008KT 10SM CLR M15/M17 A3046 RMK AO2 T11461168 KANW 2019-11-12T07:35:00Z 42.57 -100.0 -14.6 -16.8 200 8 10.0 30.46063 TRUE TRUE VFR SPECI 789.0 2019-11-12 08:02:06
CYXH 120700Z AUTO 22013G18KT 9SM CLR M07/M12 A2994 RMK SLP183 CYXH 2019-11-12T07:00:00Z 50.02 -110.72 -7.0 -12.0 220 13 18 9.0 29.940945 1018.3 TRUE VFR METAR 716.0 2019-11-12 08:02:06
EGNV 120720Z 24006KT 9999 FEW019 SCT024 04/03 Q0988 EGNV 2019-11-12T07:20:00Z 54.52 -1.42 4.0 3.0 240 6 6.21 29.17323 VFR METAR 37.0 2019-11-12 08:02:06
CWIW 120700Z AUTO 19013KT M12/M15 RMK AO1 SOG 01 8043 PK WND 19018/0639 SLP185 T11241152 CWIW 2019-11-12T07:00:00Z 51.67 -105.4 -12.4 -15.2 190 13 1018.5 TRUE TRUE METAR 526.0 2019-11-12 08:02:06
KCQX 120652Z AUTO 19009G19KT 10SM CLR 14/13 A2985 RMK AO2 SLP108 T01390128 $ KCQX 2019-11-12T06:52:00Z 41.68 -70.0 13.9 12.8 190 9 19 10.0 29.84941 1010.8 TRUE TRUE TRUE VFR METAR 19.0 2019-11-12 08:02:06
RJOA 120700Z 16004KT 120V190 9999 FEW030 BKN/// 17/05 Q1018 RJOA 2019-11-12T07:00:00Z 34.42 132.92 17.0 5.0 160 4 6.21 30.059055 VFR METAR 6.0 2019-11-12 08:02:06
VRMM 120700Z 12005KT 9999 SCT018 32/24 Q1012 TEMPO 5000 -SHRA VRMM 2019-11-12T07:00:00Z 4.2 73.52 32.0 24.0 120 5 6.21 29.88189 VFR SPECI 2.0 2019-11-12 08:02:06
KZZV 120737Z AUTO 29013KT 1 3/4SM -SN BR SCT009 BKN013 OVC023 M01/M03 A3005 RMK AO2 P0000 T10111033 KZZV 2019-11-12T07:37:00Z 39.95 -81.9 -1.1 -3.3 290 13 1.75 30.050198 TRUE TRUE -SN BR IFR 0.005 SPECI 268.0 2019-11-12 08:02:06
KMMU 120735Z AUTO 00000KT 7SM CLR 04/04 A2972 RMK AO2 KMMU 2019-11-12T07:35:00Z 40.78 -74.42 4.0 4.0 0 0 7.0 29.719488 TRUE TRUE VFR METAR 57.0 2019-11-12 08:02:06
KFAM 120656Z AUTO 33013G21KT 9SM -SN OVC026 M09/M13 A3050 RMK AO2 SLP354 P0000 T10891133 FZRANO KFAM 2019-11-12T06:56:00Z 37.77 -90.42 -8.9 -13.3 330 13 21 9.0 30.499016 1035.4 TRUE TRUE TRUE -SN MVFR 0.005 METAR 288.0 2019-11-12 08:02:06
EDDG 120720Z 19009KT 9999 -RA FEW012 BKN022 05/03 Q1001 TEMPO SHRA BKN014CB EDDG 2019-11-12T07:20:00Z 52.13 7.7 5.0 3.0 190 9 6.21 29.557087 -RA MVFR METAR 52.0 2019-11-12 08:02:06
FQPB 120700Z 05007KT 360V090 9999 FEW020 SCT/// 30/25 Q1012 FQPB 2019-11-12T07:00:00Z -12.97 40.5 30.0 25.0 50 7 6.21 29.88189 VFR SPECI 50.0 2019-11-12 08:02:06
LFSL 120730Z AUTO 00000KT 2200 -RA BR VV/// 05/05 Q1012 TEMPO 4000 SHRA BKN004 BKN020 LFSL 2019-11-12T07:30:00Z 45.03 1.48 5.0 5.0 0 0 1.37 29.88189 TRUE -RA BR LIFR SPECI 310.0 2019-11-12 08:02:06
FQCH 120700Z /////KT 9999 SCT020 25/19 Q1018 FQCH 2019-11-12T07:00:00Z -19.15 33.43 25.0 19.0 6.21 30.059055 VFR METAR 732.0 2019-11-12 08:02:06
KBNO 120653Z AUTO 30003KT 10SM CLR M03/M09 A3030 RMK AO2 SLP271 T10281089 KBNO 2019-11-12T06:53:00Z 43.6 -118.95 -2.8 -8.9 300 3 10.0 30.301182 1027.1 TRUE TRUE VFR METAR 1264.0 2019-11-12 08:02:06
KGAF 120735Z AUTO 18007KT 10SM CLR M16/M19 A3048 RMK AO2 KGAF 2019-11-12T07:35:00Z 48.4 -97.37 -16.0 -19.0 180 7 10.0 30.481298 TRUE TRUE VFR SPECI 252.0 2019-11-12 08:02:06
EGLC 120720Z AUTO 25012KT 9999 NCD 05/02 Q0999 EGLC 2019-11-12T07:20:00Z 51.5 0.05 5.0 2.0 250 12 6.21 29.498032 TRUE VFR METAR 5.0 2019-11-12 08:02:06
ENVR 120650Z 10019KT 9999 SCT032 01/M04 Q1008 ENVR 2019-11-12T06:50:00Z 67.65 12.72 1.0 -4.0 100 19 6.21 29.763779 VFR METAR 4.0 2019-11-12 08:02:06
KJYM 120735Z AUTO 32005KT 10SM CLR M10/M12 A3016 RMK AO2 T10961116 KJYM 2019-11-12T07:35:00Z 41.92 -84.58 -9.6 -11.6 320 5 10.0 30.159449 TRUE TRUE VFR SPECI 360.0 2019-11-12 08:02:06
VTBU 120730Z 19010KT 8000 FEW020 31/21 Q1008 NOSIG VTBU 2019-11-12T07:30:00Z 12.68 101.0 31.0 21.0 190 10 4.97 29.763779 TRUE MVFR METAR 5.0 2019-11-12 08:02:06
YMER 120700Z AUTO 22011KT 9999 // NCD 18/06 Q1004 YMER 2019-11-12T07:00:00Z -36.92 149.9 18.0 6.0 220 11 6.21 29.64567 TRUE VFR METAR 2.0 2019-11-12 08:02:06
KLHQ 120734Z AUTO 30009G18KT 3SM -SN BR OVC013 M03/M05 A3012 RMK AO2 P0000 T10331050 KLHQ 2019-11-12T07:34:00Z 39.75 -82.67 -3.3 -5.0 300 9 18 3.0 30.121063 TRUE TRUE -SN BR MVFR 0.005 METAR 260.0 2019-11-12 08:02:06
CYOD 120700Z 25005KT 15SM SCT220 M14/M18 A2986 RMK CI3 SLP158 CYOD 2019-11-12T07:00:00Z 54.4 -110.28 -14.0 -18.0 250 5 15.0 29.861221 1015.8 VFR METAR 544.0 2019-11-12 08:02:06
CXET 120700Z AUTO 34004KT M08/M10 RMK AO1 SOG 09 6004 SLP194 T10811095 CXET 2019-11-12T07:00:00Z 44.23 -79.78 -8.1 -9.5 340 4 1019.4 TRUE TRUE METAR 251.0 2019-11-12 08:02:06
VTUW 120700Z 14009KT 9999 FEW030 BKN100 29/20 Q1009 NOSIG VTUW 2019-11-12T07:00:00Z 17.38 104.63 29.0 20.0 140 9 6.21 29.793306 TRUE VFR METAR 184.0 2019-11-12 08:02:06
VOTV 120730Z 25007KT 6000 FEW015 SCT080 FEW025TCU 31/24 Q1009 NOSIG VOTV 2019-11-12T07:30:00Z 8.47 76.95 31.0 24.0 250 7 3.73 29.793306 TRUE MVFR METAR 8.0 2019-11-12 08:02:06
K74V 120735Z AUTO 00000KT 10SM CLR M05/M08 A3045 RMK AO2 K74V 2019-11-12T07:35:00Z 40.28 -110.05 -5.0 -8.0 0 0 10.0 30.448818 TRUE TRUE VFR METAR 1576.0 2019-11-12 08:02:06
LEBL 120730Z 32007KT 280V010 CAVOK 09/03 Q1009 NOSIG LEBL 2019-11-12T07:30:00Z 41.27 2.07 9.0 3.0 320 7 6.21 29.793306 TRUE VFR METAR 6.0 2019-11-12 08:02:06
KCDR 120653Z AUTO 23009KT 10SM CLR M16/M19 A3036 RMK AO2 SLP358 T11561194 410891206 KCDR 2019-11-12T06:53:00Z 42.83 -103.1 -15.6 -19.4 230 9 10.0 30.360237 1035.8 TRUE TRUE VFR -8.9 -20.6 METAR 1010.0 2019-11-12 08:02:06
LFRC 120730Z AUTO 30017KT 270V330 9999 SCT037/// BKN047/// ///TCU 08/01 Q1003 TEMPO 30025G40KT 2000 SHRAGS BKN020CB LFRC 2019-11-12T07:30:00Z 49.63 -1.47 8.0 1.0 300 17 6.21 29.616142 TRUE VFR SPECI 138.0 2019-11-12 08:02:06
KBRD 120653Z AUTO 31004KT 10SM CLR M15/M20 A3053 RMK AO2 SLP370 T11501200 KBRD 2019-11-12T06:53:00Z 46.4 -94.13 -15.0 -20.0 310 4 10.0 30.528543 1037.0 TRUE TRUE VFR METAR 372.0 2019-11-12 08:02:06
ESKM 120720Z AUTO 13007KT 6000 BR OVC002/// 01/01 Q1006 ESKM 2019-11-12T07:20:00Z 60.97 14.52 1.0 1.0 130 7 3.73 29.704725 TRUE BR LIFR METAR 193.0 2019-11-12 08:02:06
KIAB 120656Z AUTO 35008KT 10SM CLR M10/M15 A3068 RMK AO2 SLP416 T11001152 $ KIAB 2019-11-12T06:56:00Z 37.62 -97.27 -10.0 -15.2 350 8 10.0 30.679134 1041.6 TRUE TRUE TRUE VFR METAR 418.0 2019-11-12 08:02:06
KD60 120735Z AUTO 16005KT 10SM CLR M15/M16 A3014 RMK AO2 KD60 2019-11-12T07:35:00Z 48.38 -102.9 -15.0 -16.0 160 5 10.0 30.138779 TRUE TRUE VFR METAR 693.0 2019-11-12 08:02:06
RJTO 120700Z 08006KT 040V110 9999 FEW030 20/13 Q1014 RJTO 2019-11-12T07:00:00Z 34.77 139.37 20.0 13.0 80 6 6.21 29.940945 VFR METAR 41.0 2019-11-12 08:02:06
RKNY 120700Z 12002KT CAVOK 15/03 Q1019 NOSIG RKNY 2019-11-12T07:00:00Z 38.07 128.67 15.0 3.0 120 2 6.21 30.088583 TRUE VFR METAR 74.0 2019-11-12 08:02:06
KP92 120659Z AUTO 35014G24KT 11/10 A3007 RMK AO1 PK WND 34026/0646 SLP183 P0001 T01110100 KP92 2019-11-12T06:59:00Z 29.57 -91.53 11.1 10.0 350 14 24 30.070866 1018.3 TRUE TRUE 0.01 SPECI 1.0 2019-11-12 08:02:06
KSDM 120653Z AUTO 00000KT 6SM BR CLR 12/11 A3004 RMK AO2 SLP171 T01170106 KSDM 2019-11-12T06:53:00Z 32.58 -117.0 11.7 10.6 0 0 6.0 30.041338 1017.1 TRUE TRUE BR VFR METAR 159.0 2019-11-12 08:02:06
EPLL 120730Z 12004KT 060V150 9999 BKN035 05/03 Q1011 EPLL 2019-11-12T07:30:00Z 51.72 19.4 5.0 3.0 120 4 6.21 29.852362 VFR METAR 184.0 2019-11-12 08:02:06
KTOB 120736Z AUTO 30006KT 10SM CLR M15/M18 A3053 RMK AO2 KTOB 2019-11-12T07:36:00Z 44.02 -92.82 -15.0 -18.0 300 6 10.0 30.528543 TRUE TRUE VFR METAR 398.0 2019-11-12 08:02:06
KHFD 120740Z AUTO 35003KT 10SM BKN014 OVC021 06/02 A2976 RMK AO2 T00560017 KHFD 2019-11-12T07:40:00Z 41.73 -72.65 5.6 1.7 350 3 10.0 29.760826 TRUE TRUE MVFR SPECI 4.0 2019-11-12 08:02:06
KUNI 120735Z AUTO 28007KT 2 1/2SM -SN OVC012 M01/M01 A3010 RMK AO2 T10151015 KUNI 2019-11-12T07:35:00Z 39.22 -82.23 -1.5 -1.5 280 7 2.5 30.100393 TRUE TRUE -SN IFR SPECI 193.0 2019-11-12 08:02:06
EDDL 120720Z 18012KT 9999 -RA FEW012 SCT027 BKN032 05/03 Q1002 NOSIG EDDL 2019-11-12T07:20:00Z 51.3 6.77 5.0 3.0 180 12 6.21 29.586615 TRUE -RA VFR METAR 44.0 2019-11-12 08:02:06
RJOB 120700Z VRB02KT 9999 FEW025 BKN060 16/09 Q1018 RJOB 2019-11-12T07:00:00Z 34.75 133.83 16.0 9.0 0 2 6.21 30.059055 VFR METAR 242.0 2019-11-12 08:02:06

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query