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-01-18T18:52:00Z 29.96 45.0 26.0 33.0 2019-01-18 11:52:00
KABQ 2019-01-18T17:52:00Z 29.97 41.0 23.0 31.0 2019-01-18 10:52:00
KABQ 2019-01-18T16:52:00Z 30.0 39.0 20.0 28.0 2019-01-18 09:52:00
KABQ 2019-01-18T15:52:00Z 29.98 39.0 20.0 38.0 2019-01-18 08:52:00
KABQ 2019-01-18T15:28:00Z 29.98 39.9 30.0 38.0 2019-01-18 08:28:00
KABQ 2019-01-18T14:52:00Z 29.94 44.1 16.0 28.0 2019-01-18 07:52:00
KABQ 2019-01-18T13:52:00Z 29.95 44.1 5.0 NA 2019-01-18 06:52:00
KABQ 2019-01-18T12:52:00Z 29.94 43.0 3.0 NA 2019-01-18 05:52:00
KABQ 2019-01-18T12:24:00Z 29.94 43.0 7.0 NA 2019-01-18 05:24:00
KABQ 2019-01-18T11:52:00Z 29.94 44.1 10.0 NA 2019-01-18 04:52:00
KABQ 2019-01-18T11:21:00Z 29.95 43.0 7.0 NA 2019-01-18 04:21:00
KABQ 2019-01-18T10:52:00Z 29.96 42.1 8.0 NA 2019-01-18 03:52:00
KABQ 2019-01-18T09:52:00Z 29.99 46.0 14.0 NA 2019-01-18 02:52:00
KABQ 2019-01-18T08:52:00Z 30.02 45.0 7.0 NA 2019-01-18 01:52:00
KABQ 2019-01-18T07:52:00Z 30.04 42.1 7.0 NA 2019-01-18 00:52:00
KABQ 2019-01-18T06:52:00Z 30.08 42.1 7.0 NA 2019-01-17 23:52:00
KABQ 2019-01-18T05:52:00Z 30.09 43.0 12.0 NA 2019-01-17 22:52:00
KABQ 2019-01-18T04:52:00Z 30.08 42.1 9.0 NA 2019-01-17 21:52:00
KABQ 2019-01-18T03:52:00Z 30.08 39.0 7.0 NA 2019-01-17 20:52:00
KABQ 2019-01-18T02:52:00Z 30.11 48.9 5.0 NA 2019-01-17 19:52:00
KABQ 2019-01-18T01:52:00Z 30.11 46.0 5.0 NA 2019-01-17 18:52:00
KABQ 2019-01-18T00:52:00Z 30.12 50.0 3.0 NA 2019-01-17 17:52:00
KABQ 2019-01-17T23:52:00Z 30.13 53.1 6.0 NA 2019-01-17 16:52:00
KABQ 2019-01-17T22:52:00Z 30.14 54.0 7.0 NA 2019-01-17 15:52:00
KABQ 2019-01-17T21:52:00Z 30.14 54.0 6.0 NA 2019-01-17 14:52:00
KABQ 2019-01-17T20:52:00Z 30.17 51.1 3.0 NA 2019-01-17 13:52:00
KABQ 2019-01-17T19:52:00Z 30.22 50.0 0.0 NA 2019-01-17 12:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query