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
LFCK 170530Z AUTO 29007KT 9999 OVC011 02/01 Q1029 NOSIG LFCK 2017-12-17T05:30:00Z 43.55 2.28 2.0 1.0 290 7 6.21 30.383858 TRUE TRUE MVFR METAR 240.0 2017-12-17 05:55:31
KFTY 170453Z 00000KT 10SM CLR M01/M02 A3028 RMK AO2 SLP259 T10061017 401111028 KFTY 2017-12-17T04:53:00Z 33.78 -84.52 -0.6 -1.7 0 0 10.0 30.280512 1025.9 TRUE VFR 11.1 -2.8 METAR 263.0 2017-12-17 05:55:32
KMMK 170453Z AUTO 18003KT 10SM CLR M08/M11 A3021 RMK AO2 SLP233 T10781111 400111144 KMMK 2017-12-17T04:53:00Z 41.52 -72.83 -7.8 -11.1 180 3 10.0 30.209646 1023.3 TRUE TRUE VFR 1.1 -14.4 METAR 31.0 2017-12-17 05:55:32
KDCA 170452Z 00000KT 10SM CLR 02/M03 A3022 RMK AO2 SLP233 T00221028 400891039 KDCA 2017-12-17T04:52:00Z 38.85 -77.03 2.2 -2.8 0 0 10.0 30.221457 1023.3 TRUE VFR 8.9 -3.9 METAR 18.0 2017-12-17 05:55:32
KEIR 170535Z AUTO 18015G22KT 6SM BR FEW021 BKN030 OVC090 22/21 A3009 RMK A01 KEIR 2017-12-17T05:35:00Z 28.63 -91.48 22.0 21.0 180 15 22 6.0 30.088583 TRUE TRUE BR MVFR SPECI 28.0 2017-12-17 05:55:31
KS32 170535Z AUTO 21007KT 10SM CLR M04/M04 A3005 RMK AO2 KS32 2017-12-17T05:35:00Z 47.42 -98.1 -4.0 -4.0 210 7 10.0 30.050198 TRUE TRUE VFR METAR 684.0 2017-12-17 05:55:31
EGXP 170450Z AUTO 23006KT 9999 // FEW180/// M05/M06 Q1022 EGXP 2017-12-17T04:50:00Z 53.3 -0.55 -5.0 -6.0 230 6 6.21 30.177166 TRUE VFR METAR 61.0 2017-12-17 05:55:32
KPSX 170516Z AUTO 36007KT 8SM FEW007 OVC014 10/10 A3003 RMK AO2 T01000100 KPSX 2017-12-17T05:16:00Z 28.72 -96.25 10.0 10.0 360 7 8.0 30.029528 TRUE TRUE MVFR METAR 5.0 2017-12-17 05:55:31
KHYS 170456Z AUTO 04005KT 10SM CLR 04/M05 A2983 RMK AO2 SLP112 T00391050 KHYS 2017-12-17T04:56:00Z 38.85 -99.27 3.9 -5.0 40 5 10.0 29.828741 1011.2 TRUE TRUE VFR METAR 609.0 2017-12-17 05:55:32
KNGU 170459Z 23006KT 10SM CLR 05/M03 A3025 RMK AO2 SLP244 T00501033 400891017 $ KNGU 2017-12-17T04:59:00Z 36.92 -76.27 5.0 -3.3 230 6 10.0 30.250984 1024.4 TRUE TRUE VFR 8.9 -1.7 METAR 5.0 2017-12-17 05:55:32
KEEO 170453Z AUTO 00000KT 10SM CLR M05/M11 A2985 RMK AO2 SLP130 T10501111 KEEO 2017-12-17T04:53:00Z 40.05 -107.88 -5.0 -11.1 0 0 10.0 29.84941 1013.0 TRUE TRUE VFR METAR 1930.0 2017-12-17 05:55:32
KBGM 170453Z AUTO 32003KT 10SM OVC018 M07/M09 A3012 RMK AO2 SLP225 T10671094 410391078 KBGM 2017-12-17T04:53:00Z 42.22 -75.98 -6.7 -9.4 320 3 10.0 30.121063 1022.5 TRUE TRUE MVFR -3.9 -7.8 METAR 490.0 2017-12-17 05:55:32
RJFR 170500Z 27013KT 9999 FEW030 BKN045 04/M07 Q1026 RJFR 2017-12-17T05:00:00Z 33.82 131.03 4.0 -7.0 270 13 6.21 30.295275 VFR METAR 6.0 2017-12-17 05:55:32
KETB 170535Z AUTO 07003KT 10SM OVC009 00/M01 A3012 RMK AO2 KETB 2017-12-17T05:35:00Z 43.42 -88.13 0.0 -1.0 70 3 10.0 30.121063 TRUE TRUE IFR SPECI 270.0 2017-12-17 05:55:31
OINB 170500Z 15004KT CAVOK 07/04 Q1026 OINB 2017-12-17T05:00:00Z 36.72 52.65 7.0 4.0 150 4 6.21 30.295275 VFR METAR -15.0 2017-12-17 05:55:32
CYRQ 170500Z AUTO 00000KT 9SM FEW046 M24/M26 A3020 RMK SLP235 CYRQ 2017-12-17T05:00:00Z 46.35 -72.68 -24.0 -26.0 0 0 9.0 30.200787 1023.5 TRUE VFR METAR 61.0 2017-12-17 05:55:32
KPNS 170453Z AUTO 09004KT 10SM CLR 12/04 A3022 RMK AO2 SLP235 T01170039 KPNS 2017-12-17T04:53:00Z 30.48 -87.18 11.7 3.9 90 4 10.0 30.221457 1023.5 TRUE TRUE VFR METAR 38.0 2017-12-17 05:55:32
KATS 170535Z AUTO 22004KT 10SM CLR 04/M06 A2983 RMK AO2 KATS 2017-12-17T05:35:00Z 32.85 -104.47 4.0 -6.0 220 4 10.0 29.828741 TRUE TRUE VFR METAR 1081.0 2017-12-17 05:55:31
MUHA 170455Z 08004KT 9000 FEW025 21/20 Q1021 MUHA 2017-12-17T04:55:00Z 22.97 -82.42 21.0 20.0 80 4 5.59 30.147638 VFR METAR 64.0 2017-12-17 05:55:32
MUCF 170459Z AUTO 06009KT 22/21 Q1021 MUCF 2017-12-17T04:59:00Z 22.13 -80.4 22.0 21.0 60 9 30.147638 TRUE SPECI 39.0 2017-12-17 05:55:32
KSBA 170453Z AUTO 00000KT 10SM FU CLR 14/M03 A2978 RMK AO2 SLP084 T01441033 $ KSBA 2017-12-17T04:53:00Z 34.43 -119.85 14.4 -3.3 0 0 10.0 29.778543 1008.4 TRUE TRUE TRUE FU VFR METAR 3.0 2017-12-17 05:55:32
VIAR 170530Z 31009KT 4000 HZ NSC 13/08 Q1025 NOSIG VIAR 2017-12-17T05:30:00Z 31.7 74.8 13.0 8.0 310 9 2.49 30.265747 TRUE HZ IFR METAR 234.0 2017-12-17 05:55:31
KLAM 170535Z AUTO 00000KT 10SM CLR 02/M17 A2987 RMK AO2 T00191170 KLAM 2017-12-17T05:35:00Z 35.87 -106.27 1.9 -17.0 0 0 10.0 29.870079 TRUE TRUE VFR SPECI 2179.0 2017-12-17 05:55:31
VLLN 170500Z 27004KT 6000 SCT017 OVC090 18/16 Q1023 NOSIG VLLN 2017-12-17T05:00:00Z 20.97 101.4 18.0 16.0 270 4 3.73 30.206694 TRUE MVFR METAR 600.0 2017-12-17 05:55:32
KHTL 170514Z AUTO 05007KT 10SM OVC009 M09/M12 A3019 RMK AO2 T10941122 KHTL 2017-12-17T05:14:00Z 44.35 -84.67 -9.4 -12.2 50 7 10.0 30.188976 TRUE TRUE IFR SPECI 351.0 2017-12-17 05:55:31
KMSS 170453Z AUTO 24003KT 10SM CLR M19/M21 A3026 RMK AO2 SLP258 I1000 T11941206 410501206 KMSS 2017-12-17T04:53:00Z 44.93 -74.85 -19.4 -20.6 240 3 10.0 30.259842 1025.8 TRUE TRUE VFR -5.0 -20.6 METAR 66.0 2017-12-17 05:55:32
KCAG 170453Z AUTO 34004KT 10SM CLR M09/M13 A2986 RMK AO2 SLP169 T10941128 KCAG 2017-12-17T04:53:00Z 40.5 -107.52 -9.4 -12.8 340 4 10.0 29.861221 1016.9 TRUE TRUE VFR METAR 1887.0 2017-12-17 05:55:32
OIMN 170500Z 00000KT 7000 FEW040 M02/M02 Q1026 OIMN 2017-12-17T05:00:00Z 37.48 57.3 -2.0 -2.0 0 0 4.35 30.295275 MVFR METAR 1074.0 2017-12-17 05:55:32
CXGH 170500Z AUTO 19011KT M09/M09 RMK AO1 T10871094 CXGH 2017-12-17T05:00:00Z 50.63 -97.0 -8.7 -9.4 190 11 TRUE TRUE METAR 217.0 2017-12-17 05:55:32
OJAM 170500Z 07003KT 3000 HZ NSC 06/02 Q1024 NOSIG OJAM 2017-12-17T05:00:00Z 31.97 35.97 6.0 2.0 70 3 1.86 30.236221 TRUE HZ IFR METAR 773.0 2017-12-17 05:55:31
FAPE 170500Z 13011KT 9999 FEW015 OVC039 18/16 Q1017 NOSIG FAPE 2017-12-17T05:00:00Z -33.97 25.6 18.0 16.0 130 11 6.21 30.029528 TRUE VFR METAR 60.0 2017-12-17 05:55:32
OIMQ 170500Z 00000KT CAVOK 10/M06 Q1025 OIMQ 2017-12-17T05:00:00Z 35.23 58.47 10.0 -6.0 0 0 6.21 30.265747 VFR METAR 1140.0 2017-12-17 05:55:32
RJTT 170534Z 34016G27KT 9999 FEW030 08/M06 Q1015 RMK 1CU030 A2998 RJTT 2017-12-17T05:34:00Z 35.53 139.77 8.0 -6.0 340 16 27 6.21 29.970472 VFR SPECI 8.0 2017-12-17 05:55:31
KGOP 170535Z AUTO 00000KT 8SM BKN002 BKN021 OVC047 06/06 A3004 RMK AO2 KGOP 2017-12-17T05:35:00Z 31.42 -97.8 6.0 6.0 0 0 8.0 30.041338 TRUE TRUE LIFR SPECI 276.0 2017-12-17 05:55:31
KPVG 170456Z 25003KT 10SM CLR M03/M04 A3026 RMK AO2 SLP248 T10331044 400891078 FZRANO KPVG 2017-12-17T04:56:00Z 36.78 -76.45 -3.3 -4.4 250 3 10.0 30.259842 1024.8 TRUE TRUE VFR 8.9 -7.8 METAR 7.0 2017-12-17 05:55:32
KHQU 170535Z AUTO 00000KT 5SM BR CLR M02/M03 A3034 RMK AO2 T10201029 KHQU 2017-12-17T05:35:00Z 33.53 -82.52 -2.0 -2.9 0 0 5.0 30.339567 TRUE TRUE BR MVFR SPECI 152.0 2017-12-17 05:55:31
DTTJ 170530Z 36012KT 9999 FEW026 14/02 Q1019 NOSIG DTTJ 2017-12-17T05:30:00Z 33.87 10.77 14.0 2.0 360 12 6.21 30.088583 TRUE VFR METAR 4.0 2017-12-17 05:55:31
KS52 170535Z AUTO 00000KT 10SM OVC011 M02/M03 A3020 RMK AO2 T10171034 KS52 2017-12-17T05:35:00Z 48.38 -120.15 -1.7 -3.4 0 0 10.0 30.200787 TRUE TRUE MVFR METAR 520.0 2017-12-17 05:55:31
SBAR 170500Z 07005KT 9999 SCT013 25/23 Q1012 SBAR 2017-12-17T05:00:00Z -10.97 -37.07 25.0 23.0 70 5 6.21 29.88189 VFR METAR 9.0 2017-12-17 05:55:32
CWGT 170500Z AUTO 11029KT 06/04 RMK AO1 PK WND 11033/0453 SLP204 T00640041 56028 CWGT 2017-12-17T05:00:00Z 49.48 -124.43 6.4 4.1 110 29 1020.4 TRUE TRUE -2.8 METAR 5.0 2017-12-17 05:55:32
KMYP 170533Z AUTO 30011KT 10SM SCT080 SCT090 M05/M17 A3001 RMK AO2 KMYP 2017-12-17T05:33:00Z 38.48 -106.32 -5.0 -17.0 300 11 10.0 30.008858 TRUE TRUE VFR METAR 3667.0 2017-12-17 05:55:31
RJEC 170500Z 01005KT 3200 -SHSN FEW003 SCT010 BKN025 M06/M07 Q1006 RJEC 2017-12-17T05:00:00Z 43.67 142.43 -6.0 -7.0 10 5 1.99 29.704725 -SHSN IFR METAR 211.0 2017-12-17 05:55:32
KBMT 170535Z AUTO 16009G16KT 3SM +RA OVC007 16/14 A2998 RMK AO2 T01560140 KBMT 2017-12-17T05:35:00Z 30.07 -94.22 15.6 14.0 160 9 16 3.0 29.97933 TRUE TRUE +RA IFR SPECI 10.0 2017-12-17 05:55:31
KAQR 170535Z AUTO 19008KT 7SM -RA BKN009 BKN047 OVC070 06/06 A3005 RMK AO2 P0003 KAQR 2017-12-17T05:35:00Z 34.4 -96.15 6.0 6.0 190 8 7.0 30.050198 TRUE TRUE -RA IFR 0.03 SPECI 189.0 2017-12-17 05:55:31
MMCL 170441Z 00000KT 10SM BKN230 17/15 A2995 RMK 8/004 ISOL CU N MMCL 2017-12-17T04:41:00Z 24.77 -107.47 17.0 15.0 0 0 10.0 29.949802 VFR METAR 39.0 2017-12-17 05:55:32
KARM 170535Z AUTO 36007KT 10SM OVC019 09/07 A3004 RMK AO2 T00850071 KARM 2017-12-17T05:35:00Z 29.25 -96.15 8.5 7.1 360 7 10.0 30.041338 TRUE TRUE MVFR SPECI 31.0 2017-12-17 05:55:31
AYMO 170500Z 32010KT 9999 SCT018 BKN140 BKN300 28/24 QNIL AYMO 2017-12-17T05:00:00Z -2.07 147.42 28.0 24.0 320 10 6.21 VFR METAR 4.0 2017-12-17 05:55:32
KUCY 170535Z AUTO 17006KT 10SM CLR 07/M00 A3016 RMK A01 KUCY 2017-12-17T05:35:00Z 36.38 -88.98 7.0 0.0 170 6 10.0 30.159449 TRUE TRUE VFR SPECI 104.0 2017-12-17 05:55:31
EPMO 170530Z 22005KT 190V250 6000 SCT024 01/01 Q1013 EPMO 2017-12-17T05:30:00Z 52.45 20.65 1.0 1.0 220 5 3.73 29.911417 MVFR METAR 104.0 2017-12-17 05:55:31
K6P9 170535Z AUTO 17008KT 7SM OVC005 06/06 A2998 RMK AO2 T00570055 K6P9 2017-12-17T05:35:00Z 32.43 -98.6 5.7 5.5 170 8 7.0 29.97933 TRUE TRUE IFR SPECI 449.0 2017-12-17 05:55:31

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query