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)" 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)
KABQ 2018-05-26T22:52:00Z 29.92 87.1 14.0 NA 2018-05-26 15:52:00
KABQ 2018-05-26T21:52:00Z 29.95 86.0 6.0 NA 2018-05-26 14:52:00
KABQ 2018-05-26T20:52:00Z 29.98 86.0 7.0 NA 2018-05-26 13:52:00
KABQ 2018-05-26T19:52:00Z 30.0 84.9 9.0 NA 2018-05-26 12:52:00
KABQ 2018-05-26T18:52:00Z 30.03 82.9 5.0 NA 2018-05-26 11:52:00
KABQ 2018-05-26T17:52:00Z 30.05 78.1 6.0 NA 2018-05-26 10:52:00
KABQ 2018-05-26T16:52:00Z 30.06 75.0 7.0 NA 2018-05-26 09:52:00
KABQ 2018-05-26T15:52:00Z 30.08 68.0 7.0 NA 2018-05-26 08:52:00
KABQ 2018-05-26T14:52:00Z 30.08 66.9 8.0 NA 2018-05-26 07:52:00
KABQ 2018-05-26T13:52:00Z 30.08 64.9 5.0 NA 2018-05-26 06:52:00
KABQ 2018-05-26T12:52:00Z 30.07 62.1 3.0 NA 2018-05-26 05:52:00
KABQ 2018-05-26T11:52:00Z 30.07 62.1 0.0 NA 2018-05-26 04:52:00
KABQ 2018-05-26T10:52:00Z 30.06 62.1 7.0 NA 2018-05-26 03:52:00
KABQ 2018-05-26T09:52:00Z 30.06 61.0 7.0 NA 2018-05-26 02:52:00
KABQ 2018-05-26T08:52:00Z 30.05 60.1 6.0 NA 2018-05-26 01:52:00
KABQ 2018-05-26T07:52:00Z 30.03 68.0 7.0 NA 2018-05-26 00:52:00
KABQ 2018-05-26T06:52:00Z 30.05 72.0 6.0 NA 2018-05-25 23:52:00
KABQ 2018-05-26T05:52:00Z 30.04 73.9 3.0 NA 2018-05-25 22:52:00
KABQ 2018-05-26T04:52:00Z 30.04 73.9 8.0 NA 2018-05-25 21:52:00
KABQ 2018-05-26T03:52:00Z 30.03 75.0 10.0 NA 2018-05-25 20:52:00
KABQ 2018-05-26T02:52:00Z 30.02 81.0 12.0 NA 2018-05-25 19:52:00
KABQ 2018-05-26T01:52:00Z 30.01 86.0 10.0 NA 2018-05-25 18:52:00
KABQ 2018-05-26T00:52:00Z 30.01 88.0 9.0 NA 2018-05-25 17:52:00
KABQ 2018-05-25T23:52:00Z 30.02 89.1 6.0 NA 2018-05-25 16:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query