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-07-16T10:52:00Z 30.11 77.0 3.0 NA 2019-07-16 03:52:00
KABQ 2019-07-16T09:52:00Z 30.1 75.9 5.0 NA 2019-07-16 02:52:00
KABQ 2019-07-16T08:52:00Z 30.11 77.0 3.0 NA 2019-07-16 01:52:00
KABQ 2019-07-16T07:52:00Z 30.14 78.1 5.0 NA 2019-07-16 00:52:00
KABQ 2019-07-16T06:52:00Z 30.14 79.0 6.0 NA 2019-07-15 23:52:00
KABQ 2019-07-16T05:52:00Z 30.13 79.0 5.0 NA 2019-07-15 22:52:00
KABQ 2019-07-16T04:52:00Z 30.12 80.1 13.0 NA 2019-07-15 21:52:00
KABQ 2019-07-16T03:52:00Z 30.13 82.0 8.0 NA 2019-07-15 20:52:00
KABQ 2019-07-16T02:52:00Z 30.11 84.0 10.0 NA 2019-07-15 19:52:00
KABQ 2019-07-16T01:52:00Z 30.09 88.0 10.0 25.0 2019-07-15 18:52:00
KABQ 2019-07-16T00:52:00Z 30.06 90.0 8.0 NA 2019-07-15 17:52:00
KABQ 2019-07-15T23:59:00Z 30.05 93.0 10.0 NA 2019-07-15 16:59:00
KABQ 2019-07-15T23:52:00Z 30.04 93.0 8.0 NA 2019-07-15 16:52:00
KABQ 2019-07-15T22:52:00Z 30.05 93.0 10.0 NA 2019-07-15 15:52:00
KABQ 2019-07-15T21:52:00Z 30.07 95.0 5.0 NA 2019-07-15 14:52:00
KABQ 2019-07-15T20:52:00Z 30.1 93.9 8.0 NA 2019-07-15 13:52:00
KABQ 2019-07-15T19:52:00Z 30.13 91.0 7.0 NA 2019-07-15 12:52:00
KABQ 2019-07-15T18:52:00Z 30.16 88.0 0.0 NA 2019-07-15 11:52:00
KABQ 2019-07-15T17:52:00Z 30.18 86.0 3.0 NA 2019-07-15 10:52:00
KABQ 2019-07-15T16:52:00Z 30.19 82.9 6.0 NA 2019-07-15 09:52:00
KABQ 2019-07-15T15:52:00Z 30.2 80.1 7.0 NA 2019-07-15 08:52:00
KABQ 2019-07-15T14:52:00Z 30.21 75.9 7.0 NA 2019-07-15 07:52:00
KABQ 2019-07-15T13:52:00Z 30.21 73.0 8.0 NA 2019-07-15 06:52:00
KABQ 2019-07-15T12:52:00Z 30.21 72.0 5.0 NA 2019-07-15 05:52:00
KABQ 2019-07-15T11:52:00Z 30.2 72.0 10.0 NA 2019-07-15 04:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query