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 2018-01-17T16:52:00Z 30.43 28.0 0.0 NA 2018-01-17 09:52:00
KABQ 2018-01-17T15:52:00Z 30.41 23.0 3.0 NA 2018-01-17 08:52:00
KABQ 2018-01-17T14:52:00Z 30.39 18.0 0.0 NA 2018-01-17 07:52:00
KABQ 2018-01-17T13:52:00Z 30.39 19.0 0.0 NA 2018-01-17 06:52:00
KABQ 2018-01-17T12:52:00Z 30.37 19.0 0.0 NA 2018-01-17 05:52:00
KABQ 2018-01-17T11:52:00Z 30.37 18.0 0.0 NA 2018-01-17 04:52:00
KABQ 2018-01-17T10:52:00Z 30.39 19.9 0.0 NA 2018-01-17 03:52:00
KABQ 2018-01-17T09:52:00Z 30.39 19.0 0.0 NA 2018-01-17 02:52:00
KABQ 2018-01-17T08:52:00Z 30.4 21.9 7.0 NA 2018-01-17 01:52:00
KABQ 2018-01-17T07:52:00Z 30.39 23.0 5.0 NA 2018-01-17 00:52:00
KABQ 2018-01-17T06:52:00Z 30.4 26.1 3.0 NA 2018-01-16 23:52:00
KABQ 2018-01-17T05:52:00Z 30.41 25.0 0.0 NA 2018-01-16 22:52:00
KABQ 2018-01-17T04:52:00Z 30.41 24.1 0.0 NA 2018-01-16 21:52:00
KABQ 2018-01-17T03:52:00Z 30.4 28.0 0.0 NA 2018-01-16 20:52:00
KABQ 2018-01-17T02:52:00Z 30.39 32.0 3.0 NA 2018-01-16 19:52:00
KABQ 2018-01-17T01:52:00Z 30.38 33.1 0.0 NA 2018-01-16 18:52:00
KABQ 2018-01-17T00:52:00Z 30.38 34.0 0.0 NA 2018-01-16 17:52:00
KABQ 2018-01-16T23:52:00Z 30.38 35.1 3.0 NA 2018-01-16 16:52:00
KABQ 2018-01-16T22:52:00Z 30.39 35.1 0.0 NA 2018-01-16 15:52:00
KABQ 2018-01-16T21:52:00Z 30.4 34.0 5.0 NA 2018-01-16 14:52:00
KABQ 2018-01-16T20:52:00Z 30.42 33.1 3.0 NA 2018-01-16 13:52:00
KABQ 2018-01-16T19:52:00Z 30.45 32.0 0.0 NA 2018-01-16 12:52:00
KABQ 2018-01-16T18:52:00Z 30.48 30.0 3.0 NA 2018-01-16 11:52:00
KABQ 2018-01-16T17:52:00Z 30.51 28.9 3.0 NA 2018-01-16 10:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query