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
NGTA 292300Z 04008KT 9999 FEW019 BKN300 30/25 Q1010 NGTA 2017-04-29T23:00:00Z 1.37 173.13 30.0 25.0 40 8 6.21 29.822834 VFR METAR 2.0 2017-04-29 23:30:16
CWNM 292300Z AUTO 26007KT 16/M03 RMK AO1 PK WND 21017/2209 SLP173 T01591032 56021 CWNM 2017-04-29T23:00:00Z 49.5 -117.28 15.9 -3.2 260 7 1017.3 TRUE TRUE -2.1 METAR 535.0 2017-04-29 23:30:16
KBPI 292253Z AUTO 21007KT 10SM FEW055 OVC075 05/M07 A3018 RMK AO2 SLP227 T00501072 KBPI 2017-04-29T22:53:00Z 42.58 -110.1 5.0 -7.2 210 7 10.0 30.180119 1022.7 TRUE TRUE VFR SPECI 2117.0 2017-04-29 23:30:16
PANT 292253Z AUTO VRB04KT 8SM -RA OVC029 07/03 A2965 RMK AO2 SLP042 P0002 T00720033 TSNO PANT 2017-04-29T22:53:00Z 55.03 -131.57 7.2 3.3 0 4 8.0 29.648623 1004.2 TRUE TRUE TRUE -RA MVFR 0.02 SPECI 36.0 2017-04-29 23:30:16
KDTW 292253Z 07010KT 10SM OVC040 09/02 A3021 RMK AO2 SLP231 T00890022 KDTW 2017-04-29T22:53:00Z 42.23 -83.33 8.9 2.2 70 10 10.0 30.209646 1023.1 TRUE VFR SPECI 195.0 2017-04-29 23:30:16
UHMM 292300Z 18001MPS 9999 FEW040 03/M05 Q1009 R10/70D NOSIG RMK QFE742 UHMM 2017-04-29T23:00:00Z 59.92 150.72 3.0 -5.0 180 2 6.21 29.793306 TRUE VFR METAR 175.0 2017-04-29 23:30:16
ENOA 292250Z 16020KT CAVOK 06/02 Q1020 W///S4 ENOA 2017-04-29T22:50:00Z 60.5 2.83 6.0 2.0 160 20 6.21 30.11811 VFR SPECI 5.0 2017-04-29 23:30:16
MMPR 292248Z 21007KT 15SM SCT020 26/19 A2987 RMK 8/500 CU ALQDS MMPR 2017-04-29T22:48:00Z 20.67 -105.25 26.0 19.0 210 7 15.0 29.870079 VFR METAR 6.0 2017-04-29 23:30:16
KLPC 292256Z AUTO 26013KT 10SM CLR 21/08 A3006 RMK AO2 SLP182 T02060078 KLPC 2017-04-29T22:56:00Z 34.67 -120.47 20.6 7.8 260 13 10.0 30.059055 1018.2 TRUE TRUE VFR SPECI 27.0 2017-04-29 23:30:16
MMPA 292243Z 09004KT 6SM OVC280 38/18 A2958 RMK 8/007 HZY MMPA 2017-04-29T22:43:00Z 20.5 -97.47 38.0 18.0 90 4 6.0 29.58071 VFR SPECI 142.0 2017-04-29 23:30:16
KW96 292315Z AUTO 27004KT 10SM CLR 29/23 A3006 RMK AO1 T02920225 KW96 2017-04-29T23:15:00Z 37.5 -77.12 29.2 22.5 270 4 10.0 30.059055 TRUE TRUE VFR METAR 37.0 2017-04-29 23:30:16
KIRK 292255Z AUTO 07020G30KT 10SM OVC007 06/M01 A2982 RMK AO2 PK WND 06030/2232 SLP104 P0001 T00561011 KIRK 2017-04-29T22:55:00Z 40.1 -92.55 5.6 -1.1 70 20 30 10.0 29.819881 1010.4 TRUE TRUE IFR 0.01 METAR 293.0 2017-04-29 23:30:16
OETF 292300Z 22004KT 9999 FEW040 SCT080 19/13 Q1020 NOSIG OETF 2017-04-29T23:00:00Z 21.47 40.53 19.0 13.0 220 4 6.21 30.11811 TRUE VFR SPECI 1449.0 2017-04-29 23:30:16
KPWG 292256Z AUTO 30020G28KT 10SM BKN042 22/14 A2957 RMK AO2 PK WND 30028/2254 WSHFT 2214 SLP020 T02170144 KPWG 2017-04-29T22:56:00Z 31.47 -97.32 21.7 14.4 300 20 28 10.0 29.568897 1002.0 TRUE TRUE VFR METAR 180.0 2017-04-29 23:30:16
KGZS 292315Z AUTO 18009KT 10SM CLR 28/20 A2994 RMK A01 KGZS 2017-04-29T23:15:00Z 35.15 -87.05 28.0 20.0 180 9 10.0 29.940945 TRUE TRUE VFR METAR 209.0 2017-04-29 23:30:16
EGPU 292250Z AUTO 14020KT 9999 NCD 09/06 Q1005 EGPU 2017-04-29T22:50:00Z 56.5 -6.87 9.0 6.0 140 20 6.21 29.675198 TRUE VFR METAR 12.0 2017-04-29 23:30:16
KMNM 292256Z AUTO 06012KT 10SM CLR 07/M02 A3026 RMK AO2 SLP270 T00721022 $ KMNM 2017-04-29T22:56:00Z 45.12 -87.62 7.2 -2.2 60 12 10.0 30.259842 1027.0 TRUE TRUE TRUE VFR SPECI 191.0 2017-04-29 23:30:16
KRNO 292255Z VRB05KT 10SM SCT200 18/M11 A3019 RMK AO2 SLP204 T01781106 KRNO 2017-04-29T22:55:00Z 39.5 -119.77 17.8 -10.6 0 5 10.0 30.188976 1020.4 TRUE VFR METAR 1342.0 2017-04-29 23:30:16
KD07 292256Z AUTO 14/M08 A3018 RMK AO1 SLP232 T01391078 KD07 2017-04-29T22:56:00Z 45.03 -102.02 13.9 -7.8 30.180119 1023.2 TRUE TRUE METAR 784.0 2017-04-29 23:30:16
OPKC 292255Z 27012KT 6000 NSC 28/21 Q1007 NOSIG OPKC 2017-04-29T22:55:00Z 24.88 67.17 28.0 21.0 270 12 3.73 29.734253 TRUE MVFR METAR 22.0 2017-04-29 23:30:16
KGPH 292315Z AUTO 04005KT 10SM RA OVC008 07/07 A2985 RMK AO2 LTG DSNT S AND SW KGPH 2017-04-29T23:15:00Z 39.33 -94.32 7.0 7.0 40 5 10.0 29.84941 TRUE TRUE RA IFR METAR 235.0 2017-04-29 23:30:16
KCRQ 292253Z 29008G15KT 10SM CLR 23/06 A2996 RMK AO2 SLP143 T02330061 KCRQ 2017-04-29T22:53:00Z 33.13 -117.28 23.3 6.1 290 8 15 10.0 29.958662 1014.3 TRUE VFR SPECI 99.0 2017-04-29 23:30:16
KVLL 292314Z AUTO 07008G15KT 10SM OVC046 09/M01 A3024 RMK AO2 T00861010 KVLL 2017-04-29T23:14:00Z 42.55 -83.18 8.6 -1.0 70 8 15 10.0 30.239174 TRUE TRUE VFR METAR 222.0 2017-04-29 23:30:16
OKBK 292300Z 00000KT 1300 R15L/P1500N R33R/P1500N -HZ NSC 31/09 Q1008 NOSIG OKBK 2017-04-29T23:00:00Z 29.22 47.97 31.0 9.0 0 0 0.81 29.763779 TRUE HZ LIFR METAR 55.0 2017-04-29 23:30:16
RJOT 292300Z VRB01KT CAVOK 18/03 Q1011 RJOT 2017-04-29T23:00:00Z 34.22 134.02 18.0 3.0 0 1 6.21 29.852362 VFR METAR 188.0 2017-04-29 23:30:16
KGOP 292315Z AUTO 31010G23KT 10SM CLR 18/11 A2964 RMK AO2 LTG DSNT NE KGOP 2017-04-29T23:15:00Z 31.42 -97.8 18.0 11.0 310 10 23 10.0 29.639763 TRUE TRUE VFR METAR 276.0 2017-04-29 23:30:16
MHSR 292300Z 12004KT 5000 TSFU BKN030B 30/16 CB TS NE TCU SE W NW 5KMS ALL FU MHSR 2017-04-29T23:00:00Z 14.78 -88.78 30.0 16.0 120 4 3.11 TS TS FU METAR 1079.0 2017-04-29 23:30:16
KSJS 292315Z AUTO 12005KT 10SM CLR 28/18 A3002 RMK AO2 T02790182 KSJS 2017-04-29T23:15:00Z 37.75 -82.63 27.9 18.2 120 5 10.0 30.02067 TRUE TRUE VFR METAR 372.0 2017-04-29 23:30:16
KEHC 292315Z AUTO 14032KT 2 1/2SM HZ BKN014 27/24 A2968 RMK A01 KEHC 2017-04-29T23:15:00Z 28.43 -92.88 27.0 24.0 140 32 2.5 29.681103 TRUE TRUE HZ IFR METAR 31.0 2017-04-29 23:30:16
OMAA 292300Z 15005KT 090V260 CAVOK 29/16 Q1007 NOSIG OMAA 2017-04-29T23:00:00Z 24.42 54.63 29.0 16.0 150 5 6.21 29.734253 TRUE VFR METAR 27.0 2017-04-29 23:30:16
HKEL 292300Z 26005KT 9999 FEW018CB BKN080 16/15 Q1025 HKEL 2017-04-29T23:00:00Z 0.4 35.23 16.0 15.0 260 5 6.21 30.265747 VFR METAR 2133.0 2017-04-29 23:30:16
ENSE 292250Z AUTO 16020KT 9999NDV BKN071/// 07/03 Q1020 W///S4 ENSE 2017-04-29T22:50:00Z 61.45 2.15 7.0 3.0 160 20 30.11811 TRUE METAR 10.0 2017-04-29 23:30:16
KMCK 292253Z AUTO 02020G25KT 10SM OVC041 05/00 A3003 RMK AO2 PK WND 02027/2206 SLP182 T00500000 $ KMCK 2017-04-29T22:53:00Z 40.2 -100.58 5.0 0.0 20 20 25 10.0 30.029528 1018.2 TRUE TRUE TRUE VFR SPECI 782.0 2017-04-29 23:30:16
KBCE 292253Z AUTO 01017G27KT 10SM BKN070 08/M09 A3012 RMK AO2 PK WND 01027/2250 SLP147 T00831094 KBCE 2017-04-29T22:53:00Z 37.7 -112.15 8.3 -9.4 10 17 27 10.0 30.121063 1014.7 TRUE TRUE VFR SPECI 2312.0 2017-04-29 23:30:16
WMBA 292300Z 10002KT 7000 FEW004 FEW016CB SCT140 BKN270 25/25 Q1009 WMBA 2017-04-29T23:00:00Z 4.22 100.7 25.0 25.0 100 2 4.35 29.793306 BKN 27000 MVFR METAR 8.0 2017-04-29 23:30:16
LDZD 292300Z 07004KT 020V140 CAVOK 09/M00 Q1016 LDZD 2017-04-29T23:00:00Z 44.1 15.37 9.0 0.0 70 4 6.21 30.0 VFR METAR 84.0 2017-04-29 23:30:16
LFQB 292300Z AUTO 13001KT CAVOK 04/00 Q1011 LFQB 2017-04-29T23:00:00Z 48.32 4.02 4.0 0.0 130 1 6.21 29.852362 TRUE VFR METAR 118.0 2017-04-29 23:30:16
DGAA 292300Z 22007KT 9999 FEW018 29/26 Q1012 NOSIG DGAA 2017-04-29T23:00:00Z 5.58 -0.17 29.0 26.0 220 7 6.21 29.88189 TRUE VFR METAR 69.0 2017-04-29 23:30:16
KAKO 292253Z AUTO 35019G27KT 10SM OVC047 03/M07 A3011 RMK AO2 PK WND 02032/2241 SLP213 T00331072 $ KAKO 2017-04-29T22:53:00Z 40.17 -103.22 3.3 -7.2 350 19 27 10.0 30.109253 1021.3 TRUE TRUE TRUE VFR SPECI 1421.0 2017-04-29 23:30:16
VAAH 292300Z 31007KT 4000 HZ NSC 29/23 Q1007 NOSIG VAAH 2017-04-29T23:00:00Z 23.07 72.62 29.0 23.0 310 7 2.49 29.734253 TRUE HZ IFR METAR 55.0 2017-04-29 23:30:16
RKTU 292300Z 29002KT 9000 NSC 16/08 Q1007 NOSIG RKTU 2017-04-29T23:00:00Z 36.7 127.5 16.0 8.0 290 2 5.59 29.734253 TRUE VFR METAR 66.0 2017-04-29 23:30:16
KTFP 292315Z AUTO 15022G29KT 4SM HZ BKN013 29/25 A2949 RMK AO2 T02860247 KTFP 2017-04-29T23:15:00Z 27.92 -97.22 28.6 24.7 150 22 29 4.0 29.489174 TRUE TRUE HZ MVFR METAR 6.0 2017-04-29 23:30:16
KBBB 292313Z AUTO 10010G16KT 10SM CLR 14/M13 A3018 RMK AO2 KBBB 2017-04-29T23:13:00Z 45.32 -95.65 14.0 -13.0 100 10 16 10.0 30.180119 TRUE TRUE VFR METAR 317.0 2017-04-29 23:30:16
KMYV 292253Z AUTO 32008G15KT 10SM CLR 27/03 A3005 RMK AO2 SLP180 T02670028 KMYV 2017-04-29T22:53:00Z 39.1 -121.57 26.7 2.8 320 8 15 10.0 30.050198 1018.0 TRUE TRUE VFR SPECI 21.0 2017-04-29 23:30:16
SLRI 292300Z 00000KT 9999 BKN020 26/22 Q1014 SLRI 2017-04-29T23:00:00Z -11.02 -66.08 26.0 22.0 0 0 6.21 29.940945 MVFR SPECI 135.0 2017-04-29 23:30:16
KBIH 292256Z AUTO 00000KT 10SM CLR 22/M14 A3011 RMK AO2 SLP172 T02171144 KBIH 2017-04-29T22:56:00Z 37.37 -118.35 21.7 -14.4 0 0 10.0 30.109253 1017.2 TRUE TRUE VFR METAR 1253.0 2017-04-29 23:30:16
KPIM 292315Z AUTO 18004KT 10SM SCT055 SCT065 SCT075 29/20 A3007 RMK AO2 T02940199 KPIM 2017-04-29T23:15:00Z 32.83 -84.88 29.4 19.9 180 4 10.0 30.070866 TRUE TRUE VFR METAR 275.0 2017-04-29 23:30:16
CYBR 292300Z 26012G20KT 15SM SCT070 BKN250 17/00 A3015 RMK AC4CI1 SLP228 DENSITY ALT 1500FT CYBR 2017-04-29T23:00:00Z 49.92 -99.95 17.0 0.0 260 12 20 15.0 30.15059 1022.8 VFR METAR 409.0 2017-04-29 23:30:16
KSTE 292255Z AUTO 08008KT 10SM CLR 08/M02 A3021 RMK AO2 T00831019 KSTE 2017-04-29T22:55:00Z 44.55 -89.53 8.3 -1.9 80 8 10.0 30.209646 TRUE TRUE VFR METAR 338.0 2017-04-29 23:30:16
VECC 292300Z 21008KT 2800 HZ SCT020 SCT100 28/26 Q1006 NOSIG VECC 2017-04-29T23:00:00Z 22.65 88.43 28.0 26.0 210 8 1.74 29.704725 TRUE HZ IFR METAR 6.0 2017-04-29 23:30:16

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query