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
FQTT 221800Z 00000KT 9000 -RA SCT010 BKN018 BKN080 24/24 Q1010 FQTT 2019-01-22T18:00:00Z -16.1 33.62 24.0 24.0 0 0 5.59 29.822834 -RA MVFR METAR 160.0 2019-01-22 18:31:26
KMFE 221753Z 17024G33KT 8SM -RA CLR 27/14 A2983 RMK AO2 PK WND 15038/1728 RAB22 SLP098 P0000 60000 T02670139 10267 20189 58010 KMFE 2019-01-22T17:53:00Z 26.18 -98.25 26.7 13.9 170 24 33 8.0 29.828741 1009.8 TRUE -RA VFR -1.0 26.7 18.9 0.005 0.005 METAR 38.0 2019-01-22 18:31:26
OIZH 221800Z 20004KT CAVOK 00/M17 Q1018 A3008 OIZH 2019-01-22T18:00:00Z 29.47 60.92 0.0 -17.0 200 4 6.21 30.059055 VFR METAR 1370.0 2019-01-22 18:31:26
CWHN 221800Z AUTO 22005KT 180V280 7SM OVC002 M09/M11 A2979 RMK SLP134 CWHN 2019-01-22T18:00:00Z 54.88 -109.97 -9.0 -11.0 220 5 7.0 29.790354 1013.4 TRUE LIFR METAR 636.0 2019-01-22 18:31:25
KRPH 221755Z AUTO 19006KT 10SM SCT048 16/11 A2978 RMK AO2 T01610111 10161 20142 KRPH 2019-01-22T17:55:00Z 33.12 -98.55 16.1 11.1 190 6 10.0 29.778543 TRUE TRUE VFR 16.1 14.2 METAR 342.0 2019-01-22 18:31:26
KCBE 221800Z AUTO 00000KT 10SM BKN095 M07/M15 A3063 RMK AO2 T10681152 KCBE 2019-01-22T18:00:00Z 39.62 -78.77 -6.8 -15.2 0 0 10.0 30.628937 TRUE TRUE VFR SPECI 236.0 2019-01-22 18:31:26
KAMA 221753Z 33025G34KT 10SM OVC016 M02/M07 A2994 RMK AO2 PK WND 33034/1752 SLP134 T10221072 10039 21022 51036 KAMA 2019-01-22T17:53:00Z 35.22 -101.72 -2.2 -7.2 330 25 34 10.0 29.940945 1013.4 TRUE MVFR 3.6 3.9 -2.2 METAR 1093.0 2019-01-22 18:31:26
KLWA 221816Z AUTO 15005KT 3SM -SN A3011 RMK AO2 KLWA 2019-01-22T18:16:00Z 42.35 -86.25 150 5 3.0 30.109253 TRUE TRUE -SN METAR 203.0 2019-01-22 18:31:25
KVLL 221815Z AUTO 16009G15KT 10SM CLR M05/M16 A3030 RMK AO2 T10501164 KVLL 2019-01-22T18:15:00Z 42.55 -83.18 -5.0 -16.4 160 9 15 10.0 30.301182 TRUE TRUE VFR METAR 222.0 2019-01-22 18:31:25
KBYI 221753Z AUTO 26013G21KT 10SM FEW025 M02/M08 A3043 RMK AO2 SLP329 T10171083 11017 21044 53019 KBYI 2019-01-22T17:53:00Z 42.55 -113.77 -1.7 -8.3 260 13 21 10.0 30.431103 1032.9 TRUE TRUE VFR 1.9 -1.7 -4.4 METAR 1264.0 2019-01-22 18:31:26
KGTF 221753Z 21021KT 10SM CLR M03/M07 A3006 RMK AO2 PK WND 22033/1716 SLP239 T10331072 11033 21083 57010 KGTF 2019-01-22T17:53:00Z 47.47 -111.38 -3.3 -7.2 210 21 10.0 30.059055 1023.9 TRUE VFR -1.0 -3.3 -8.3 METAR 1119.0 2019-01-22 18:31:26
KSUX 221752Z 34016KT 10SM OVC017 M06/M08 A3004 RMK AO2 SLP190 T10561083 11056 21061 51025 KSUX 2019-01-22T17:52:00Z 42.38 -96.38 -5.6 -8.3 340 16 10.0 30.041338 1019.0 TRUE MVFR 2.5 -5.6 -6.1 METAR 338.0 2019-01-22 18:31:26
KBTA 221755Z AUTO 35018G23KT 10SM OVC013 M05/M07 A2998 RMK AO2 T10461066 11037 21047 KBTA 2019-01-22T17:55:00Z 41.42 -96.12 -4.6 -6.6 350 18 23 10.0 29.97933 TRUE TRUE MVFR -3.7 -4.7 METAR 396.0 2019-01-22 18:31:26
KHSA 221745Z 12010G15KT 10SM FEW030 OVC060 14/11 A3020 KHSA 2019-01-22T17:45:00Z 30.37 -89.45 14.0 11.0 120 10 15 10.0 30.200787 VFR METAR 7.0 2019-01-22 18:31:26
KARB 221753Z 12010KT 10SM CLR M08/M15 A3028 RMK AO2 SLP273 T10781150 11078 21122 58039 KARB 2019-01-22T17:53:00Z 42.22 -83.73 -7.8 -15.0 120 10 10.0 30.280512 1027.3 TRUE VFR -3.9 -7.8 -12.2 METAR 251.0 2019-01-22 18:31:26
KBTP 221756Z AUTO 12009KT 10SM CLR M05/M14 A3043 RMK AO2 SLP336 P0006 60008 T10501139 11050 21167 58028 FZRANO KBTP 2019-01-22T17:56:00Z 40.77 -79.95 -5.0 -13.9 120 9 10.0 30.431103 1033.6 TRUE TRUE TRUE VFR -2.8 -5.0 -16.7 0.06 0.08 METAR 380.0 2019-01-22 18:31:26
YBRM 221800Z AUTO 01004KT 9999 // NCD 25/22 Q1004 YBRM 2019-01-22T18:00:00Z -17.93 122.22 25.0 22.0 10 4 6.21 29.64567 TRUE VFR METAR 9.0 2019-01-22 18:31:26
YMIA 221800Z AUTO 18006KT 9999 // NCD 28/09 Q1009 YMIA 2019-01-22T18:00:00Z -34.23 142.08 28.0 9.0 180 6 6.21 29.793306 TRUE VFR METAR 51.0 2019-01-22 18:31:26
YLRE 221800Z AUTO 05009KT 9999 // NCD 27/12 Q1010 YLRE 2019-01-22T18:00:00Z -23.43 144.28 27.0 12.0 50 9 6.21 29.822834 TRUE VFR METAR 193.0 2019-01-22 18:31:26
KMLU 221753Z 16012G16KT 10SM OVC065 18/11 A3006 RMK AO2 SLP177 T01780106 10178 20089 58023 KMLU 2019-01-22T17:53:00Z 32.52 -92.03 17.8 10.6 160 12 16 10.0 30.059055 1017.7 TRUE VFR -2.3 17.8 8.9 METAR 29.0 2019-01-22 18:31:26
PHKO 221753Z 00000KT 10SM FEW035 21/14 A3001 RMK AO2 SLP163 T02110144 10211 20183 53012 PHKO 2019-01-22T17:53:00Z 19.73 -156.05 21.1 14.4 0 0 10.0 30.008858 1016.3 TRUE VFR 1.2 21.1 18.3 METAR 27.0 2019-01-22 18:31:26
KPPF 221752Z AUTO 18008KT 7SM -RA OVC014 11/09 A2980 RMK AO2 RAB21 SLP091 P0000 60000 T01060089 10111 20100 50001 KPPF 2019-01-22T17:52:00Z 37.33 -95.5 10.6 8.9 180 8 7.0 29.799213 1009.1 TRUE TRUE -RA MVFR 0.1 11.1 10.0 0.005 0.005 METAR 274.0 2019-01-22 18:31:26
CYDP 221800Z 33003KT 310V050 15SM FEW200 M19/M27 A2998 RMK CS1 CS TR CI ASOCTD SLP155 CYDP 2019-01-22T18:00:00Z 56.53 -61.67 -19.0 -27.0 330 3 15.0 29.97933 1015.5 VFR METAR 7.0 2019-01-22 18:31:26
K54J 221815Z AUTO 12010KT 10SM OVC060 13/06 A3036 RMK AO2 T01250057 K54J 2019-01-22T18:15:00Z 30.73 -86.15 12.5 5.7 120 10 10.0 30.360237 TRUE TRUE VFR METAR 88.0 2019-01-22 18:31:25
KWMC 221756Z AUTO 17005KT 10SM CLR M04/M07 A3050 RMK AO2 SLP360 T10391072 11039 21106 51015 KWMC 2019-01-22T17:56:00Z 40.9 -117.8 -3.9 -7.2 170 5 10.0 30.499016 1036.0 TRUE TRUE VFR 1.5 -3.9 -10.6 METAR 1310.0 2019-01-22 18:31:26
CYEG 221800Z 18006KT 20SM FEW053 BKN160 M04/M10 A2978 RMK SC2AC5 VIRGA SLP132 CYEG 2019-01-22T18:00:00Z 53.28 -113.57 -4.0 -10.0 180 6 20.0 29.778543 1013.2 VFR METAR 723.0 2019-01-22 18:31:25
LFBM 221800Z AUTO 21005KT 180V240 9999 FEW023/// SCT032/// BKN056/// ///TCU 06/05 Q1009 TEMPO 4500 -RA BKN008 BKN020 LFBM 2019-01-22T18:00:00Z 43.92 -0.5 6.0 5.0 210 5 6.21 29.793306 TRUE VFR SPECI 63.0 2019-01-22 18:31:26
ENAT 221750Z 18003KT CAVOK M16/M18 Q1008 RMK WIND 700FT 18006KT ENAT 2019-01-22T17:50:00Z 69.97 23.37 -16.0 -18.0 180 3 6.21 29.763779 VFR METAR 3.0 2019-01-22 18:31:26
KDEQ 221753Z AUTO 10011KT 10SM BKN029 BKN037 OVC050 12/09 A2995 RMK AO2 SLP139 60000 T01220094 10122 20100 58010 KDEQ 2019-01-22T17:53:00Z 34.05 -94.4 12.2 9.4 100 11 10.0 29.949802 1013.9 TRUE TRUE MVFR -1.0 12.2 10.0 0.005 METAR 106.0 2019-01-22 18:31:26
USCC 221800Z 23003MPS 9999 FEW033CB M12/M14 Q1010 R27/000060 TEMPO 1200 SHSN VV003 RMK QFE737 USCC 2019-01-22T18:00:00Z 55.3 61.5 -12.0 -14.0 230 6 6.21 29.822834 VFR METAR 234.0 2019-01-22 18:31:26
KPCD 221815Z AUTO 10SM SCT027 BKN050 OVC060 03/M01 A3011 RMK AO2 T00331015 KPCD 2019-01-22T18:15:00Z 37.87 -89.87 3.3 -1.5 10.0 30.109253 TRUE TRUE VFR METAR 113.0 2019-01-22 18:31:25
KOVS 221810Z AUTO 03003KT 3SM BR FEW018 SCT027 OVC035 M05/M07 A3001 RMK AO2 SNE09 P0000 T10501072 KOVS 2019-01-22T18:10:00Z 43.15 -90.68 -5.0 -7.2 30 3 3.0 30.008858 TRUE TRUE BR MVFR 0.005 SPECI 202.0 2019-01-22 18:31:25
CERM 221800Z AUTO 29009G17KT M14/M22 RMK AO1 SOG 76 3015 PK WND 29021/1704 SLP239 T11411218 CERM 2019-01-22T18:00:00Z 47.42 -68.32 -14.1 -21.8 290 9 17 1023.9 TRUE TRUE METAR 154.0 2019-01-22 18:31:26
YPKU 221800Z AUTO 02001KT 9999 // NCD 27/25 Q1005 YPKU 2019-01-22T18:00:00Z -15.77 128.68 27.0 25.0 20 1 6.21 29.675198 TRUE VFR METAR 45.0 2019-01-22 18:31:26
OITL 221750Z 00000KT 9999 FEW100 SCT200 M04/M08 Q1015 OITL 2019-01-22T17:50:00Z 38.33 48.42 -4.0 -8.0 0 0 6.21 29.970472 VFR METAR 1316.0 2019-01-22 18:31:26
KOLZ 221815Z AUTO 12004KT 1 1/4SM BR OVC004 M05/M05 A2995 RMK AO2 PWINO KOLZ 2019-01-22T18:15:00Z 42.67 -91.97 -5.0 -5.0 120 4 1.25 29.949802 TRUE TRUE TRUE BR LIFR METAR 328.0 2019-01-22 18:31:25
KSAV 221753Z 05013KT 10SM FEW050 12/04 A3056 RMK AO2 SLP347 T01220039 10122 21006 58011 KSAV 2019-01-22T17:53:00Z 32.12 -81.2 12.2 3.9 50 13 10.0 30.561024 1034.7 TRUE VFR -1.1 12.2 -0.6 METAR 14.0 2019-01-22 18:31:26
LIRZ 221750Z 33006KT 7000 -RA OVC013 02/01 Q1002 LIRZ 2019-01-22T17:50:00Z 43.1 12.5 2.0 1.0 330 6 4.35 29.586615 -RA MVFR METAR 205.0 2019-01-22 18:31:26
MNRS 221800Z 08014KT 9999 FEW015 29/21 Q1013 MNRS 2019-01-22T18:00:00Z 11.42 -85.82 29.0 21.0 80 14 6.21 29.911417 VFR METAR 53.0 2019-01-22 18:31:26
KGGI 221815Z AUTO 09005KT 1 3/4SM UP OVC004 M02/M03 A2993 RMK AO2 T10221028 KGGI 2019-01-22T18:15:00Z 41.72 -92.73 -2.2 -2.8 90 5 1.75 29.929134 TRUE TRUE UP LIFR METAR 307.0 2019-01-22 18:31:25
KALM 221755Z AUTO 10SM CLR 08/M09 A2995 RMK AO2 KALM 2019-01-22T17:55:00Z 32.82 -105.97 8.0 -9.0 10.0 29.949802 TRUE TRUE VFR METAR 1279.0 2019-01-22 18:31:26
SBTE 221800Z 03003KT 9999 SCT048 33/23 Q1010 SBTE 2019-01-22T18:00:00Z -5.03 -42.82 33.0 23.0 30 3 6.21 29.822834 VFR METAR 69.0 2019-01-22 18:31:26
MTPP 221800Z 11005KT 9999 FEW028 32/16 Q1017 A3005 MTPP 2019-01-22T18:00:00Z 18.57 -72.28 32.0 16.0 110 5 6.21 30.029528 VFR METAR 37.0 2019-01-22 18:31:25
KIER 221815Z AUTO 14009G15KT 10SM OVC024 17/13 A2999 RMK AO2 T01730129 KIER 2019-01-22T18:15:00Z 31.73 -93.1 17.3 12.9 140 9 15 10.0 29.991142 TRUE TRUE MVFR METAR 37.0 2019-01-22 18:31:25
CYEV 221800Z CCA 30003KT 10SM -SN OVC004 M23/M26 A3034 RMK ST8 SLP287 CYEV 2019-01-22T18:00:00Z 68.32 -133.5 -23.0 -26.0 300 3 10.0 30.339567 1028.7 -SN LIFR METAR 68.0 2019-01-22 18:31:26
UWOR 221800Z 23005MPS 8000 -SN OVC027 M03/M04 Q1013 R25/990038 NOSIG RMK QFE736/0982 UWOR 2019-01-22T18:00:00Z 51.07 58.6 -3.0 -4.0 230 10 4.97 29.911417 TRUE -SN MVFR METAR 277.0 2019-01-22 18:31:26
KSTC 221753Z 33006KT 10SM BKN017 OVC046 M09/M12 A3003 RMK AO2 SLP198 60001 T10891122 11083 21106 50004 KSTC 2019-01-22T17:53:00Z 45.55 -94.05 -8.9 -12.2 330 6 10.0 30.029528 1019.8 TRUE MVFR 0.4 -8.3 -10.6 0.01 METAR 314.0 2019-01-22 18:31:26
SPHY 221800Z 02008KT 9000 FEW014 BKN050 12/06 Q1036 RMK PP000 SPHY 2019-01-22T18:00:00Z -13.7 -73.35 12.0 6.0 20 8 5.59 30.590551 VFR METAR 3548.0 2019-01-22 18:31:26
LELL 221800Z AUTO 27004KT 240V300 CAVOK 07/00 Q1006 LELL 2019-01-22T18:00:00Z 41.52 2.1 7.0 0.0 270 4 6.21 29.704725 TRUE VFR METAR 250.0 2019-01-22 18:31:25
EGEC 221720Z 30005KT 270V350 9999 SCT010 02/01 Q0995 EGEC 2019-01-22T17:20:00Z 55.43 -5.68 2.0 1.0 300 5 6.21 29.379921 VFR METAR 13.0 2019-01-22 18:31:26

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query