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-05-24T02:52:00Z 30.02 63.0 8.0 NA 2019-05-23 19:52:00
KABQ 2019-05-24T01:52:00Z 29.99 66.0 10.0 NA 2019-05-23 18:52:00
KABQ 2019-05-24T00:52:00Z 29.98 68.0 20.0 NA 2019-05-23 17:52:00
KABQ 2019-05-23T23:52:00Z 29.97 70.0 18.0 26.0 2019-05-23 16:52:00
KABQ 2019-05-23T22:52:00Z 29.96 70.0 23.0 33.0 2019-05-23 15:52:00
KABQ 2019-05-23T21:52:00Z 29.93 71.1 23.0 41.0 2019-05-23 14:52:00
KABQ 2019-05-23T20:52:00Z 29.91 73.0 28.0 41.0 2019-05-23 13:52:00
KABQ 2019-05-23T19:52:00Z 29.89 73.9 33.0 48.0 2019-05-23 12:52:00
KABQ 2019-05-23T18:52:00Z 29.89 73.0 33.0 47.0 2019-05-23 11:52:00
KABQ 2019-05-23T17:52:00Z 29.89 73.0 35.0 45.0 2019-05-23 10:52:00
KABQ 2019-05-23T16:52:00Z 29.89 70.0 33.0 46.0 2019-05-23 09:52:00
KABQ 2019-05-23T15:52:00Z 29.89 69.1 30.0 40.0 2019-05-23 08:52:00
KABQ 2019-05-23T14:52:00Z 29.88 66.9 26.0 41.0 2019-05-23 07:52:00
KABQ 2019-05-23T13:52:00Z 29.87 64.9 23.0 NA 2019-05-23 06:52:00
KABQ 2019-05-23T12:52:00Z 29.86 59.0 16.0 NA 2019-05-23 05:52:00
KABQ 2019-05-23T11:52:00Z 29.85 55.0 12.0 NA 2019-05-23 04:52:00
KABQ 2019-05-23T10:52:00Z 29.84 57.0 5.0 NA 2019-05-23 03:52:00
KABQ 2019-05-23T09:52:00Z 29.83 55.0 0.0 NA 2019-05-23 02:52:00
KABQ 2019-05-23T08:52:00Z 29.83 57.0 10.0 NA 2019-05-23 01:52:00
KABQ 2019-05-23T07:52:00Z 29.82 57.9 6.0 NA 2019-05-23 00:52:00
KABQ 2019-05-23T06:52:00Z 29.81 57.0 10.0 NA 2019-05-22 23:52:00
KABQ 2019-05-23T05:52:00Z 29.8 55.9 10.0 NA 2019-05-22 22:52:00
KABQ 2019-05-23T04:52:00Z 29.8 57.9 12.0 NA 2019-05-22 21:52:00
KABQ 2019-05-23T03:52:00Z 29.78 64.9 6.0 NA 2019-05-22 20:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query