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 station_id AS "Code", observation_time AS "Time (GMT)", ROUND(altim_in_hg,2) AS "Pressure (inches)", ROUND(temp_c*1.8+32, 1) AS "Temp. (F)", ROUND(wind_speed_kt*1.15077945) AS "Wind (mph)", (CASE WHEN wind_gust_kt THEN ROUND(wind_gust_kt*1.15077945) ELSE "NA" END) AS "Gust (mph)", DATETIME(observation_time,'-7 hours') AS "Time (MST)", ""||raw_text||"" AS "METAR" FROM metar WHERE station_id='KABQ' ORDER BY observation_time DESC

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

Code Time (GMT) Pressure (inches) Temp. (F) Wind (mph) Gust (mph) Time (MST) METAR
KABQ 2018-08-18T00:52:00Z 30.27 69.1 10.0 NA 2018-08-17 17:52:00 KABQ 180052Z 10009KT 9SM -RA FEW035 BKN110 BKN160 BKN220 21/18 A3027 RMK AO2 LTG DSNT NW TSE07 SLP177 CB DSNT E AND NW MTNS OBSC NE-SE P0009 T02060178
KABQ 2018-08-18T00:08:00Z 30.27 73.0 16.0 NA 2018-08-17 17:08:00 KABQ 180008Z 08014KT 7SM RA FEW040 BKN080 BKN160 BKN220 23/16 A3027 RMK AO2 LTG DSNT E AND W TSE07 CB DSNT NE-E MTNS OBSC NE AND SE P0001 T02280161
KABQ 2018-08-17T23:52:00Z 30.26 80.1 7.0 NA 2018-08-17 16:52:00 KABQ 172352Z 28006KT 10SM -TSRA FEW060CB BKN080CB BKN160 BKN220 27/14 A3026 RMK AO2 PK WND 22032/2313 LTG DSNT NE AND E RAB47 SLP161 OCNL LTGICCG NE-SE TS NE-SE MOV NE MTNS OBSC NE-SE P0000 60000 T02670139 10333 20267 53012
KABQ 2018-08-17T22:52:00Z 30.19 89.1 9.0 NA 2018-08-17 15:52:00 KABQ 172252Z 24008KT 10SM TS BKN090CB BKN160 BKN220 32/09 A3019 RMK AO2 LTG DSNT N AND S AND SW TSB47 SLP128 OCNL LTGICCG SE AND SW TS SE AND SW MOV NE VCSH SE AND SW MTNS OBSC SE T03170089
KABQ 2018-08-17T22:27:00Z 30.19 90.0 6.0 NA 2018-08-17 15:27:00 KABQ 172227Z VRB05KT 10SM VCTS SCT090CB SCT160 BKN220 32/11 A3019 RMK AO2 LTG DSNT S AND SW OCNL LTGICCG VC SE-S TS SE-S MOV NE VCSH SE MTNS OBSC SE T03220111
KABQ 2018-08-17T21:52:00Z 30.19 91.0 6.0 NA 2018-08-17 14:52:00 KABQ 172152Z VRB05KT 10SM BKN090 BKN200 33/11 A3019 RMK AO2 LTG DSNT W-NE SLP126 CB DSNT SW-NW SHRA DSNT ALQDS T03280106
KABQ 2018-08-17T20:52:00Z 30.22 90.0 5.0 NA 2018-08-17 13:52:00 KABQ 172052Z VRB04KT 10SM SCT090 SCT200 32/11 A3022 RMK AO2 SLP134 CB DSNT ALQDS SHRA DSNT NE-SE T03220106 56022
KABQ 2018-08-17T19:52:00Z 30.24 88.0 7.0 NA 2018-08-17 12:52:00 KABQ 171952Z 32006KT 10SM FEW075 FEW200 31/11 A3024 RMK AO2 LTG DSNT E AND SE SLP143 CB DSNT N-E AND SW-NW TCU DSNT NE-SE T03110111
KABQ 2018-08-17T18:52:00Z 30.27 84.9 9.0 NA 2018-08-17 11:52:00 KABQ 171852Z 35008KT 10SM FEW070 FEW120 FEW200 29/12 A3027 RMK AO2 LTG DSNT E AND SE SLP155 CB DSNT N-E AND SW-NW T02940122
KABQ 2018-08-17T18:23:00Z 30.28 84.0 8.0 NA 2018-08-17 11:23:00 KABQ 171823Z 31007KT 10SM FEW060 FEW210 29/13 A3028 RMK AO2 LTG DSNT SE CB DSNT E AND W T02890128
KABQ 2018-08-17T17:52:00Z 30.29 84.0 8.0 NA 2018-08-17 10:52:00 KABQ 171752Z 34007KT 10SM VCTS FEW060CB SCT210 29/13 A3029 RMK AO2 LTG DSNT SE SLP164 OCNL LTGCG VC NE TS NE MOV E T02890128 10289 20211 58005
KABQ 2018-08-17T16:52:00Z 30.31 81.0 3.0 NA 2018-08-17 09:52:00 KABQ 171652Z VRB03KT 10SM FEW060 SCT210 27/13 A3031 RMK AO2 SLP174 T02720133
KABQ 2018-08-17T15:52:00Z 30.31 75.9 0.0 NA 2018-08-17 08:52:00 KABQ 171552Z 00000KT 10SM FEW130 SCT220 24/13 A3031 RMK AO2 SLP177 T02440128
KABQ 2018-08-17T14:52:00Z 30.31 75.0 0.0 NA 2018-08-17 07:52:00 KABQ 171452Z 00000KT 10SM FEW140 BKN220 24/13 A3031 RMK AO2 SLP174 VIRGA T02390133 51007
KABQ 2018-08-17T13:52:00Z 30.31 71.1 0.0 NA 2018-08-17 06:52:00 KABQ 171352Z 00000KT 10SM FEW150 SCT180 22/14 A3031 RMK AO2 SLP175 VIRGA SE-SW T02170139
KABQ 2018-08-17T12:52:00Z 30.29 71.1 5.0 NA 2018-08-17 05:52:00 KABQ 171252Z 12004KT 10SM FEW130 BKN160 BKN210 22/12 A3029 RMK AO2 SLP169 VIRGA S-W T02170122
KABQ 2018-08-17T11:52:00Z 30.28 71.1 6.0 NA 2018-08-17 04:52:00 KABQ 171152Z 12005KT 10SM FEW130 BKN160 OVC220 22/12 A3028 RMK AO2 SLP163 T02170122 10239 20211 52002
KABQ 2018-08-17T10:52:00Z 30.28 70.0 5.0 NA 2018-08-17 03:52:00 KABQ 171052Z 10004KT 10SM FEW100 FEW130 BKN170 OVC220 21/12 A3028 RMK AO2 SLP158 T02110122
KABQ 2018-08-17T09:52:00Z 30.28 71.1 5.0 NA 2018-08-17 02:52:00 KABQ 170952Z 20004KT 10SM FEW060 FEW100 SCT130 SCT170 22/13 A3028 RMK AO2 SLP159 T02170128
KABQ 2018-08-17T08:52:00Z 30.28 73.9 12.0 17.0 2018-08-17 01:52:00 KABQ 170852Z 16010G15KT 10SM FEW060 SCT120 BKN170 23/12 A3028 RMK AO2 SLP156 T02330122 56002
KABQ 2018-08-17T07:52:00Z 30.28 75.0 3.0 NA 2018-08-17 00:52:00 KABQ 170752Z 13003KT 10SM FEW070 FEW100 BKN130 OVC170 24/13 A3028 RMK AO2 SLP156 T02390128
KABQ 2018-08-17T06:52:00Z 30.28 75.0 6.0 NA 2018-08-16 23:52:00 KABQ 170652Z 01005KT 10SM FEW070 FEW100 SCT200 24/12 A3028 RMK AO2 SLP160 T02390122 403330206
KABQ 2018-08-17T05:52:00Z 30.29 75.0 6.0 NA 2018-08-16 22:52:00 KABQ 170552Z 25005KT 10SM SCT070 BKN110 BKN200 24/13 A3029 RMK AO2 SLP162 60000 T02390133 10306 20233 51018
KABQ 2018-08-17T04:52:00Z 30.28 73.9 9.0 NA 2018-08-16 21:52:00 KABQ 170452Z 10008KT 10SM FEW065 BKN110 OVC200 23/13 A3028 RMK AO2 RAB0358E36 SLP162 P0000 T02330128
KABQ 2018-08-17T03:52:00Z 30.27 75.0 17.0 NA 2018-08-16 20:52:00 KABQ 170352Z 10015KT 10SM SCT100 BKN150 BKN250 24/13 A3027 RMK AO2 SLP161 T02390128
KABQ 2018-08-17T02:52:00Z 30.23 81.0 20.0 NA 2018-08-16 19:52:00 KABQ 170252Z 07017KT 10SM FEW100 BKN150 BKN250 27/11 A3023 RMK AO2 SLP145 T02720111 51020
KABQ 2018-08-17T01:52:00Z 30.21 82.9 9.0 NA 2018-08-16 18:52:00 KABQ 170152Z 33008KT 10SM SCT110 BKN160 BKN250 28/11 A3021 RMK AO2 WSHFT 0049 SLP143 VCSH NW T02830106

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query