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 2020-04-06T05:52:00Z 29.97 57.0 9.0 NA 2020-04-05 22:52:00
KABQ 2020-04-06T04:52:00Z 29.94 57.9 15.0 NA 2020-04-05 21:52:00
KABQ 2020-04-06T03:52:00Z 29.91 60.1 20.0 NA 2020-04-05 20:52:00
KABQ 2020-04-06T02:52:00Z 29.88 63.0 23.0 NA 2020-04-05 19:52:00
KABQ 2020-04-06T01:52:00Z 29.85 64.9 13.0 NA 2020-04-05 18:52:00
KABQ 2020-04-06T00:52:00Z 29.84 68.0 17.0 NA 2020-04-05 17:52:00
KABQ 2020-04-05T23:52:00Z 29.85 71.1 18.0 23.0 2020-04-05 16:52:00
KABQ 2020-04-05T22:52:00Z 29.86 69.1 15.0 18.0 2020-04-05 15:52:00
KABQ 2020-04-05T21:52:00Z 29.88 69.1 7.0 NA 2020-04-05 14:52:00
KABQ 2020-04-05T20:52:00Z 29.92 68.0 14.0 28.0 2020-04-05 13:52:00
KABQ 2020-04-05T19:52:00Z 29.94 66.0 9.0 23.0 2020-04-05 12:52:00
KABQ 2020-04-05T18:52:00Z 29.97 66.0 14.0 21.0 2020-04-05 11:52:00
KABQ 2020-04-05T17:52:00Z 30.0 63.0 9.0 NA 2020-04-05 10:52:00
KABQ 2020-04-05T16:52:00Z 30.01 62.1 5.0 NA 2020-04-05 09:52:00
KABQ 2020-04-05T15:52:00Z 30.0 57.0 0.0 NA 2020-04-05 08:52:00
KABQ 2020-04-05T14:52:00Z 30.01 52.0 3.0 NA 2020-04-05 07:52:00
KABQ 2020-04-05T13:52:00Z 29.98 51.1 0.0 NA 2020-04-05 06:52:00
KABQ 2020-04-05T12:52:00Z 29.97 41.0 3.0 NA 2020-04-05 05:52:00
KABQ 2020-04-05T11:52:00Z 29.94 42.1 3.0 NA 2020-04-05 04:52:00
KABQ 2020-04-05T10:52:00Z 29.93 45.0 3.0 NA 2020-04-05 03:52:00
KABQ 2020-04-05T09:52:00Z 29.92 48.0 3.0 NA 2020-04-05 02:52:00
KABQ 2020-04-05T08:52:00Z 29.92 50.0 5.0 NA 2020-04-05 01:52:00
KABQ 2020-04-05T07:52:00Z 29.93 55.0 5.0 NA 2020-04-05 00:52:00
KABQ 2020-04-05T06:52:00Z 29.92 51.1 7.0 NA 2020-04-04 23:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query