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 2019-03-19T16:52:00Z 30.19 53.1 9.0 NA 2019-03-19 09:52:00
KABQ 2019-03-19T15:52:00Z 30.19 48.0 13.0 NA 2019-03-19 08:52:00
KABQ 2019-03-19T14:52:00Z 30.19 44.1 8.0 NA 2019-03-19 07:52:00
KABQ 2019-03-19T13:52:00Z 30.18 43.0 6.0 NA 2019-03-19 06:52:00
KABQ 2019-03-19T12:52:00Z 30.15 43.0 8.0 NA 2019-03-19 05:52:00
KABQ 2019-03-19T11:52:00Z 30.14 43.0 10.0 NA 2019-03-19 04:52:00
KABQ 2019-03-19T10:52:00Z 30.14 44.1 7.0 NA 2019-03-19 03:52:00
KABQ 2019-03-19T09:52:00Z 30.13 45.0 8.0 NA 2019-03-19 02:52:00
KABQ 2019-03-19T08:52:00Z 30.15 48.0 6.0 NA 2019-03-19 01:52:00
KABQ 2019-03-19T07:52:00Z 30.15 48.0 8.0 NA 2019-03-19 00:52:00
KABQ 2019-03-19T06:52:00Z 30.16 48.0 5.0 NA 2019-03-18 23:52:00
KABQ 2019-03-19T05:52:00Z 30.15 48.0 8.0 NA 2019-03-18 22:52:00
KABQ 2019-03-19T04:52:00Z 30.15 48.0 7.0 NA 2019-03-18 21:52:00
KABQ 2019-03-19T03:52:00Z 30.14 50.0 6.0 NA 2019-03-18 20:52:00
KABQ 2019-03-19T02:52:00Z 30.13 51.1 6.0 NA 2019-03-18 19:52:00
KABQ 2019-03-19T01:52:00Z 30.12 57.0 5.0 NA 2019-03-18 18:52:00
KABQ 2019-03-19T00:52:00Z 30.12 57.9 6.0 NA 2019-03-18 17:52:00
KABQ 2019-03-18T23:52:00Z 30.12 59.0 8.0 NA 2019-03-18 16:52:00
KABQ 2019-03-18T22:52:00Z 30.13 61.0 9.0 NA 2019-03-18 15:52:00
KABQ 2019-03-18T21:52:00Z 30.15 60.1 7.0 NA 2019-03-18 14:52:00
KABQ 2019-03-18T20:52:00Z 30.16 57.9 7.0 NA 2019-03-18 13:52:00
KABQ 2019-03-18T19:52:00Z 30.2 57.9 0.0 NA 2019-03-18 12:52:00
KABQ 2019-03-18T18:52:00Z 30.24 57.0 7.0 NA 2019-03-18 11:52:00
KABQ 2019-03-18T17:52:00Z 30.25 55.0 12.0 20.0 2019-03-18 10:52:00
KABQ 2019-03-18T17:44:00Z 30.26 55.0 14.0 21.0 2019-03-18 10:44:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query