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-01-28T01:52:00Z 30.01 42.1 18.0 30.0 2020-01-27 18:52:00
KABQ 2020-01-28T00:52:00Z 29.99 42.1 12.0 NA 2020-01-27 17:52:00
KABQ 2020-01-27T23:52:00Z 29.97 43.0 20.0 29.0 2020-01-27 16:52:00
KABQ 2020-01-27T22:52:00Z 29.96 44.1 18.0 24.0 2020-01-27 15:52:00
KABQ 2020-01-27T21:52:00Z 29.94 44.1 13.0 NA 2020-01-27 14:52:00
KABQ 2020-01-27T20:52:00Z 29.95 46.9 7.0 NA 2020-01-27 13:52:00
KABQ 2020-01-27T19:52:00Z 29.97 46.0 6.0 NA 2020-01-27 12:52:00
KABQ 2020-01-27T18:52:00Z 29.99 45.0 6.0 NA 2020-01-27 11:52:00
KABQ 2020-01-27T17:52:00Z 30.03 41.0 0.0 NA 2020-01-27 10:52:00
KABQ 2020-01-27T16:52:00Z 30.04 36.0 7.0 NA 2020-01-27 09:52:00
KABQ 2020-01-27T15:52:00Z 30.05 35.1 0.0 NA 2020-01-27 08:52:00
KABQ 2020-01-27T14:52:00Z 30.04 34.0 6.0 NA 2020-01-27 07:52:00
KABQ 2020-01-27T13:52:00Z 30.03 30.0 7.0 NA 2020-01-27 06:52:00
KABQ 2020-01-27T12:52:00Z 30.03 33.1 0.0 NA 2020-01-27 05:52:00
KABQ 2020-01-27T11:52:00Z 30.02 27.0 6.0 NA 2020-01-27 04:52:00
KABQ 2020-01-27T10:52:00Z 30.03 30.0 0.0 NA 2020-01-27 03:52:00
KABQ 2020-01-27T09:52:00Z 30.04 32.0 3.0 NA 2020-01-27 02:52:00
KABQ 2020-01-27T08:52:00Z 30.04 37.0 5.0 NA 2020-01-27 01:52:00
KABQ 2020-01-27T07:52:00Z 30.05 37.0 0.0 NA 2020-01-27 00:52:00
KABQ 2020-01-27T06:52:00Z 30.07 39.9 3.0 NA 2020-01-26 23:52:00
KABQ 2020-01-27T05:52:00Z 30.07 39.0 5.0 NA 2020-01-26 22:52:00
KABQ 2020-01-27T04:52:00Z 30.08 37.0 3.0 NA 2020-01-26 21:52:00
KABQ 2020-01-27T03:52:00Z 30.09 39.0 3.0 NA 2020-01-26 20:52:00
KABQ 2020-01-27T02:52:00Z 30.09 45.0 0.0 NA 2020-01-26 19:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query