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
KCLT 200752Z 00000KT 10SM CLR 08/08 A3023 RMK AO2 SLP234 T00780078 KCLT 2017-10-20T07:52:00Z 35.22 -80.95 7.8 7.8 0 0 10.0 30.230314 1023.4 TRUE VFR METAR 220.0 2017-10-20 08:27:32
KPEZ 200815Z AUTO 08003KT 10SM SCT048 OVC050 20/18 A3005 RMK AO2 LTG DSNT E T02020182 KPEZ 2017-10-20T08:15:00Z 28.95 -98.52 20.2 18.2 80 3 10.0 30.050198 TRUE TRUE VFR SPECI 132.0 2017-10-20 08:27:32
VTUW 200800Z VRB02KT 9999 FEW024 32/22 Q1010 VTUW 2017-10-20T08:00:00Z 17.38 104.63 32.0 22.0 0 2 6.21 29.822834 VFR METAR 184.0 2017-10-20 08:27:32
OINN 200800Z 31006KT 9999 FEW025TCU SCT030 21/16 Q1018 OINN 2017-10-20T08:00:00Z 36.67 51.47 21.0 16.0 310 6 6.21 30.059055 VFR METAR -19.0 2017-10-20 08:27:32
CYQI 200800Z 25015G20KT 12SM SCT240 14/12 A2990 RMK CI4 SLP126 CYQI 2017-10-20T08:00:00Z 43.83 -66.08 14.0 12.0 250 15 20 12.0 29.899607 1012.6 VFR METAR 43.0 2017-10-20 08:27:32
KEKO 200756Z AUTO 04004KT 10SM CLR 03/M07 A2966 RMK AO2 SLP017 T00331072 402391061 KEKO 2017-10-20T07:56:00Z 40.82 -115.78 3.3 -7.2 40 4 10.0 29.660433 1001.7 TRUE TRUE VFR 23.9 -6.1 METAR 1547.0 2017-10-20 08:27:32
LZIB 200800Z 07004KT 0150 R31/0175N R22/0250N FG VV001 07/07 Q1018 BECMG FM0830 0600 FG BKN002 LZIB 2017-10-20T08:00:00Z 48.17 17.22 7.0 7.0 70 4 0.09 30.059055 FG LIFR 100 SPECI 134.0 2017-10-20 08:27:32
FAGG 200800Z 27009KT 230V300 9999 FEW040 17/08 Q1021 FAGG 2017-10-20T08:00:00Z -34.0 22.37 17.0 8.0 270 9 6.21 30.147638 VFR METAR 193.0 2017-10-20 08:27:32
CYQU 200800Z 25007KT 25SM SCT080 BKN210 02/M00 A2928 RMK AC3CI2 SLP934 CYQU 2017-10-20T08:00:00Z 55.18 -118.88 2.0 0.0 250 7 25.0 29.279528 993.4 VFR METAR 669.0 2017-10-20 08:27:32
KMVL 200754Z AUTO 00000KT 10SM CLR 11/02 A2999 RMK AO2 SLP157 T01060017 TSNO KMVL 2017-10-20T07:54:00Z 44.53 -72.62 10.6 1.7 0 0 10.0 29.991142 1015.7 TRUE TRUE TRUE VFR METAR 234.0 2017-10-20 08:27:32
KAKO 200753Z AUTO 23009KT 10SM CLR 08/04 A2981 RMK AO2 SLP051 T00830044 KAKO 2017-10-20T07:53:00Z 40.17 -103.22 8.3 4.4 230 9 10.0 29.811024 1005.1 TRUE TRUE VFR SPECI 1421.0 2017-10-20 08:27:32
KJAN 200754Z AUTO 00000KT 10SM CLR 14/12 A3019 RMK AO2 SLP219 T01390122 KJAN 2017-10-20T07:54:00Z 32.32 -90.08 13.9 12.2 0 0 10.0 30.188976 1021.9 TRUE TRUE VFR SPECI 91.0 2017-10-20 08:27:32
KGUC 200756Z AUTO 00000KT 10SM CLR 01/M03 A3009 RMK AO2 SLP144 T00111033 FZRANO KGUC 2017-10-20T07:56:00Z 38.52 -106.92 1.1 -3.3 0 0 10.0 30.088583 1014.4 TRUE TRUE TRUE VFR SPECI 2339.0 2017-10-20 08:27:32
EDXW 200750Z 13012KT 3400 BR NSC 13/12 Q1007 EDXW 2017-10-20T07:50:00Z 54.92 8.33 13.0 12.0 130 12 2.11 29.734253 BR IFR METAR 20.0 2017-10-20 08:27:32
EBAW 200750Z 21011KT 9999 FEW018 14/10 Q1007 TEMPO 21015G25KT EBAW 2017-10-20T07:50:00Z 51.2 4.47 14.0 10.0 210 11 6.21 29.734253 VFR -1.5 METAR 14.0 2017-10-20 08:27:32
KLLJ 200755Z AUTO 27003KT 10SM CLR 06/M08 A2955 RMK AO2 SLP965 T00561078 KLLJ 2017-10-20T07:55:00Z 44.52 -114.22 5.6 -7.8 270 3 10.0 29.551182 996.5 TRUE TRUE VFR SPECI 1536.0 2017-10-20 08:27:32
LFOV 200800Z AUTO 22006KT CAVOK 11/09 Q1014 LFOV 2017-10-20T08:00:00Z 48.03 -0.75 11.0 9.0 220 6 6.21 29.940945 TRUE VFR METAR 101.0 2017-10-20 08:27:32
DAUA 200800Z 00000KT CAVOK 22/05 Q1017 DAUA 2017-10-20T08:00:00Z 27.83 -0.18 22.0 5.0 0 0 6.21 30.029528 VFR METAR 263.0 2017-10-20 08:27:32
KISQ 200815Z AUTO 19005KT 10SM CLR 11/08 A3006 RMK AO2 T01110080 KISQ 2017-10-20T08:15:00Z 45.97 -86.17 11.1 8.0 190 5 10.0 30.059055 TRUE TRUE VFR SPECI 209.0 2017-10-20 08:27:32
RPVM 200800Z 22015KT 8000 -RA SCT020 OVC090 29/25 Q1006 RMK A2971 RPVM 2017-10-20T08:00:00Z 10.32 123.98 29.0 25.0 220 15 4.97 29.704725 -RA MVFR METAR 10.0 2017-10-20 08:27:32
CWWE 200800Z AUTO 24013KT 14/12 RMK AO1 PK WND 24017/0751 SLP122 T01380123 56024 CWWE 2017-10-20T08:00:00Z 43.97 -64.67 13.8 12.3 240 13 1012.2 TRUE TRUE -2.4 METAR 9.0 2017-10-20 08:27:32
KUDG 200756Z AUTO 00000KT 10SM CLR 08/08 A3023 RMK AO2 SLP242 T00830078 KUDG 2017-10-20T07:56:00Z 34.45 -79.88 8.3 7.8 0 0 10.0 30.230314 1024.2 TRUE TRUE VFR SPECI 59.0 2017-10-20 08:27:32
KCDN 200815Z AUTO 00000KT 10SM CLR 08/06 A3023 RMK AO2 KCDN 2017-10-20T08:15:00Z 34.28 -80.57 8.0 6.0 0 0 10.0 30.230314 TRUE TRUE VFR SPECI 92.0 2017-10-20 08:27:31
ESSP 200750Z 21001KT CAVOK 04/04 Q1021 ESSP 2017-10-20T07:50:00Z 58.57 16.25 4.0 4.0 210 1 6.21 30.147638 VFR METAR 8.0 2017-10-20 08:27:32
ENTC 200750Z 25005KT 9999 BKN005 01/00 Q1024 TEMPO OVC004 RMK WIND 2600FT 23006KT ENTC 2017-10-20T07:50:00Z 69.68 18.92 1.0 0.0 250 5 6.21 30.236221 IFR METAR 10.0 2017-10-20 08:27:32
PAGM 200756Z AUTO 35019G26KT 10SM SCT028 OVC035 M04/M08 A2952 RMK AO2 PK WND 34026/0754 UPB17E19SNE17 SLP002 P0000 T10391083 FZRANO PAGM 2017-10-20T07:56:00Z 63.77 -171.73 -3.9 -8.3 350 19 26 10.0 29.518702 1000.2 TRUE TRUE TRUE VFR 0.005 METAR 8.0 2017-10-20 08:27:32
SBPL 200800Z 12007KT CAVOK 22/17 Q1016 SBPL 2017-10-20T08:00:00Z -9.37 -40.57 22.0 17.0 120 7 6.21 30.0 VFR METAR 375.0 2017-10-20 08:27:32
LEGR 200800Z 27004KT 240V320 9999 FEW030 15/14 Q1021 LEGR 2017-10-20T08:00:00Z 37.17 -3.77 15.0 14.0 270 4 6.21 30.147638 VFR METAR 559.0 2017-10-20 08:27:32
LRIA 200800Z 26003KT 210V340 CAVOK 16/09 Q1017 LRIA 2017-10-20T08:00:00Z 47.17 27.62 16.0 9.0 260 3 6.21 30.029528 VFR METAR 104.0 2017-10-20 08:27:32
LSME 200750Z 00000KT 9999 BKN120 10/07 Q1017 RMK BLU LSME 2017-10-20T07:50:00Z 47.1 8.3 10.0 7.0 0 0 6.21 30.029528 VFR METAR 427.0 2017-10-20 08:27:32
NCRG 200800Z 12002KT 9999 -DZ FEW005 SCT018 OVC090 23/22 Q1014 NCRG 2017-10-20T08:00:00Z -21.2 -159.82 23.0 22.0 120 2 6.21 29.940945 -DZ VFR METAR 7.0 2017-10-20 08:27:32
BGJN 200750Z AUTO 00000KT 9999NDV FEW016/// SCT021/// M06/M08 Q1007 BGJN 2017-10-20T07:50:00Z 69.25 -51.07 -6.0 -8.0 0 0 29.734253 TRUE SPECI 25.0 2017-10-20 08:27:32
OINZ 200800Z 30006KT 9999 SCT027TCU 23/13 Q1018 OINZ 2017-10-20T08:00:00Z 36.63 53.2 23.0 13.0 300 6 6.21 30.059055 VFR METAR 11.0 2017-10-20 08:27:32
RJBB 200800Z 07008KT 9999 SHRA FEW008 BKN030 BKN070 19/16 Q1015 BECMG -SHRA RJBB 2017-10-20T08:00:00Z 34.42 135.25 19.0 16.0 70 8 6.21 29.970472 SHRA MVFR METAR 8.0 2017-10-20 08:27:32
TNCE 200755Z AUTO 08010KT 050V110 //// // ///////// 27/23 Q1015 RE// TNCE 2017-10-20T07:55:00Z 17.47 -62.97 27.0 23.0 80 10 29.970472 TRUE SPECI 39.0 2017-10-20 08:27:32
KHBE 200755Z AUTO 07003KT 7SM CLR 08/07 A3024 RMK AO2 PWINO KHBE 2017-10-20T07:55:00Z 39.33 -86.03 8.0 7.0 70 3 7.0 30.239174 TRUE TRUE TRUE VFR METAR 215.0 2017-10-20 08:27:32
FQIN 200800Z 07006KT 9999 BKN020 BKN030 27/23 Q1018 FQIN 2017-10-20T08:00:00Z -23.87 35.37 27.0 23.0 70 6 6.21 30.059055 MVFR METAR 15.0 2017-10-20 08:27:32
ETHN 200720Z 17004KT 9999 FEW120 BKN160 12/10 Q1014 BLU BLU ETHN 2017-10-20T07:20:00Z 49.38 9.97 12.0 10.0 170 4 6.21 29.940945 VFR METAR 473.0 2017-10-20 08:27:32
KDRA 200755Z AUTO 01006KT 10SM CLR 15/M07 A2973 RMK AO2 SLP025 T01501072 402890144 KDRA 2017-10-20T07:55:00Z 36.62 -116.03 15.0 -7.2 10 6 10.0 29.731298 1002.5 TRUE TRUE VFR 28.9 14.4 SPECI 1006.0 2017-10-20 08:27:32
PHHI 200808Z AUTO 05007KT 10SM BKN038 22/19 A3013 RMK AO2 DZE07RAB07E08 SLP193 PHHI 2017-10-20T08:08:00Z 21.48 -158.05 22.0 19.0 50 7 10.0 30.129921 1019.3 TRUE TRUE VFR SPECI 255.0 2017-10-20 08:27:32
KMQJ 200815Z AUTO 00000KT 10SM CLR 09/09 A3023 RMK AO1 KMQJ 2017-10-20T08:15:00Z 39.85 -85.9 9.0 9.0 0 0 10.0 30.230314 TRUE TRUE VFR SPECI 263.0 2017-10-20 08:27:31
LRSB 200800Z 07002KT CAVOK 14/06 Q1019 LRSB 2017-10-20T08:00:00Z 45.78 24.08 14.0 6.0 70 2 6.21 30.088583 VFR METAR 444.0 2017-10-20 08:27:32
KIBM 200815Z AUTO 28005KT 10SM CLR 05/01 A2981 RMK AO2 T00540013 KIBM 2017-10-20T08:15:00Z 41.18 -103.68 5.4 1.3 280 5 10.0 29.811024 TRUE TRUE VFR METAR 1501.0 2017-10-20 08:27:32
RKJK 200758Z 33012KT 6SM HZ CLR 20/13 A3003 RMK AO2A VIS 2V2 1/2 SLP173 T01950128 $ RKJK 2017-10-20T07:58:00Z 35.9 126.62 19.5 12.8 330 12 6.0 30.029528 1017.3 TRUE TRUE HZ VFR METAR 9.0 2017-10-20 08:27:32
KFFL 200815Z AUTO 19006KT 10SM CLR 14/09 A3008 RMK AO2 PWINO KFFL 2017-10-20T08:15:00Z 41.03 -91.97 14.0 9.0 190 6 10.0 30.079725 TRUE TRUE TRUE VFR SPECI 244.0 2017-10-20 08:27:31
KNGP 200756Z AUTO 14003KT 10SM FEW019 BKN036 OVC065 23/21 A2999 RMK AO2 RAB21E49 SLP154 P0010 T02280211 CHINO KNGP 2017-10-20T07:56:00Z 27.68 -97.27 22.8 21.1 140 3 10.0 29.991142 1015.4 TRUE TRUE VFR 0.1 SPECI 6.0 2017-10-20 08:27:32
OEBA 200800Z 10012KT CAVOK 27/04 Q1024 NOSIG OEBA 2017-10-20T08:00:00Z 20.3 41.62 27.0 4.0 100 12 6.21 30.236221 TRUE VFR METAR 1656.0 2017-10-20 08:27:32
ESNO 200750Z 32005KT CAVOK 01/M02 Q1022 ESNO 2017-10-20T07:50:00Z 63.38 18.97 1.0 -2.0 320 5 6.21 30.177166 VFR METAR 103.0 2017-10-20 08:27:32
USTR 200800Z 26010MPS 9999 BKN036CB 06/M01 Q0995 WS R21 R21/290060 TEMPO 25016MPS RMK QFE737/0983 USTR 2017-10-20T08:00:00Z 57.17 65.32 6.0 -1.0 260 19 6.21 29.379921 VFR METAR 115.0 2017-10-20 08:27:32
PALU 200755Z AUTO 12010KT 10SM -SN BKN016 BKN060 M06/M08 A2936 RMK AO2 SHSNB0655E0734 SLP942 P0000 T10571079 PALU 2017-10-20T07:55:00Z 68.88 -166.1 -5.7 -7.9 120 10 10.0 29.359253 994.2 TRUE TRUE -SN MVFR 0.005 METAR 3.0 2017-10-20 08:27:32

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query