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 2017-07-20T17:52:00Z 30.29 81.0 9.0 NA 2017-07-20 10:52:00
KABQ 2017-07-20T16:52:00Z 30.3 80.1 8.0 NA 2017-07-20 09:52:00
KABQ 2017-07-20T15:52:00Z 30.31 77.0 0.0 NA 2017-07-20 08:52:00
KABQ 2017-07-20T14:52:00Z 30.31 75.0 8.0 NA 2017-07-20 07:52:00
KABQ 2017-07-20T13:52:00Z 30.31 73.0 8.0 NA 2017-07-20 06:52:00
KABQ 2017-07-20T12:52:00Z 30.3 70.0 8.0 NA 2017-07-20 05:52:00
KABQ 2017-07-20T11:52:00Z 30.29 69.1 5.0 NA 2017-07-20 04:52:00
KABQ 2017-07-20T10:52:00Z 30.29 66.9 6.0 NA 2017-07-20 03:52:00
KABQ 2017-07-20T09:52:00Z 30.29 69.1 6.0 NA 2017-07-20 02:52:00
KABQ 2017-07-20T08:52:00Z 30.29 70.0 5.0 NA 2017-07-20 01:52:00
KABQ 2017-07-20T07:52:00Z 30.28 70.0 6.0 NA 2017-07-20 00:52:00
KABQ 2017-07-20T06:52:00Z 30.28 71.1 3.0 NA 2017-07-19 23:52:00
KABQ 2017-07-20T05:52:00Z 30.27 71.1 7.0 NA 2017-07-19 22:52:00
KABQ 2017-07-20T04:52:00Z 30.26 73.9 13.0 23.0 2017-07-19 21:52:00
KABQ 2017-07-20T03:52:00Z 30.24 77.0 23.0 32.0 2017-07-19 20:52:00
KABQ 2017-07-20T03:04:00Z 30.22 81.0 17.0 39.0 2017-07-19 20:04:00
KABQ 2017-07-20T02:52:00Z 30.2 84.0 29.0 36.0 2017-07-19 19:52:00
KABQ 2017-07-20T01:52:00Z 30.15 88.0 17.0 NA 2017-07-19 18:52:00
KABQ 2017-07-20T00:52:00Z 30.13 91.0 16.0 NA 2017-07-19 17:52:00
KABQ 2017-07-19T23:52:00Z 30.13 91.0 7.0 NA 2017-07-19 16:52:00
KABQ 2017-07-19T22:52:00Z 30.15 91.0 0.0 NA 2017-07-19 15:52:00
KABQ 2017-07-19T21:52:00Z 30.17 91.9 8.0 NA 2017-07-19 14:52:00
KABQ 2017-07-19T20:52:00Z 30.21 90.0 7.0 NA 2017-07-19 13:52:00
KABQ 2017-07-19T19:52:00Z 30.23 90.0 10.0 NA 2017-07-19 12:52:00
KABQ 2017-07-19T18:52:00Z 30.25 87.1 0.0 NA 2017-07-19 11:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query