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-09-20T18:52:00Z 30.05 68.0 3.0 NA 2018-09-20 11:52:00
KABQ 2018-09-20T17:52:00Z 30.06 64.9 5.0 NA 2018-09-20 10:52:00
KABQ 2018-09-20T16:52:00Z 30.07 63.0 8.0 NA 2018-09-20 09:52:00
KABQ 2018-09-20T16:30:00Z 30.07 62.1 7.0 NA 2018-09-20 09:30:00
KABQ 2018-09-20T15:52:00Z 30.06 62.1 5.0 NA 2018-09-20 08:52:00
KABQ 2018-09-20T14:52:00Z 30.05 60.1 6.0 NA 2018-09-20 07:52:00
KABQ 2018-09-20T13:52:00Z 30.05 59.0 8.0 NA 2018-09-20 06:52:00
KABQ 2018-09-20T12:52:00Z 30.03 59.0 7.0 NA 2018-09-20 05:52:00
KABQ 2018-09-20T11:52:00Z 30.02 60.1 7.0 NA 2018-09-20 04:52:00
KABQ 2018-09-20T10:52:00Z 30.01 61.0 9.0 NA 2018-09-20 03:52:00
KABQ 2018-09-20T10:13:00Z 30.02 61.0 9.0 18.0 2018-09-20 03:13:00
KABQ 2018-09-20T09:52:00Z 30.02 61.0 12.0 NA 2018-09-20 02:52:00
KABQ 2018-09-20T09:42:00Z 30.02 62.1 8.0 NA 2018-09-20 02:42:00
KABQ 2018-09-20T08:52:00Z 30.0 63.0 13.0 NA 2018-09-20 01:52:00
KABQ 2018-09-20T08:22:00Z 30.02 64.0 10.0 NA 2018-09-20 01:22:00
KABQ 2018-09-20T08:05:00Z 30.04 64.0 9.0 NA 2018-09-20 01:05:00
KABQ 2018-09-20T07:52:00Z 30.04 64.0 8.0 NA 2018-09-20 00:52:00
KABQ 2018-09-20T07:19:00Z 30.04 64.0 3.0 NA 2018-09-20 00:19:00
KABQ 2018-09-20T06:52:00Z 30.05 64.0 6.0 NA 2018-09-19 23:52:00
KABQ 2018-09-20T06:09:00Z 30.05 64.0 6.0 NA 2018-09-19 23:09:00
KABQ 2018-09-20T05:58:00Z 30.04 64.0 5.0 NA 2018-09-19 22:58:00
KABQ 2018-09-20T05:52:00Z 30.04 64.0 5.0 NA 2018-09-19 22:52:00
KABQ 2018-09-20T04:52:00Z 30.04 63.0 0.0 NA 2018-09-19 21:52:00
KABQ 2018-09-20T03:52:00Z 30.05 66.0 0.0 NA 2018-09-19 20:52:00
KABQ 2018-09-20T02:52:00Z 30.0 70.0 8.0 NA 2018-09-19 19:52:00
KABQ 2018-09-20T02:21:00Z 29.99 71.1 18.0 NA 2018-09-19 19:21:00
KABQ 2018-09-20T01:52:00Z 29.95 75.0 10.0 NA 2018-09-19 18:52:00
KABQ 2018-09-20T01:48:00Z 29.95 75.2 13.0 NA 2018-09-19 18:48:00
KABQ 2018-09-20T00:52:00Z 29.95 77.0 10.0 NA 2018-09-19 17:52:00
KABQ 2018-09-20T00:18:00Z 29.93 78.1 6.0 NA 2018-09-19 17:18:00
KABQ 2018-09-20T00:07:00Z 29.91 78.1 0.0 NA 2018-09-19 17:07:00
KABQ 2018-09-19T23:55:00Z 29.89 75.9 13.0 28.0 2018-09-19 16:55:00
KABQ 2018-09-19T23:28:00Z 29.89 80.1 18.0 NA 2018-09-19 16:28:00
KABQ 2018-09-19T23:16:00Z 29.89 82.9 17.0 NA 2018-09-19 16:16:00
KABQ 2018-09-19T23:02:00Z 29.88 88.0 16.0 25.0 2018-09-19 16:02:00
KABQ 2018-09-19T22:52:00Z 29.88 89.1 18.0 23.0 2018-09-19 15:52:00
KABQ 2018-09-19T22:07:00Z 29.89 87.1 10.0 22.0 2018-09-19 15:07:00
KABQ 2018-09-19T21:52:00Z 29.89 87.1 17.0 NA 2018-09-19 14:52:00
KABQ 2018-09-19T21:42:00Z 29.9 84.9 9.0 22.0 2018-09-19 14:42:00
KABQ 2018-09-19T21:17:00Z 29.9 88.0 12.0 18.0 2018-09-19 14:17:00
KABQ 2018-09-19T20:52:00Z 29.92 88.0 10.0 NA 2018-09-19 13:52:00
KABQ 2018-09-19T20:38:00Z 29.92 88.0 6.0 NA 2018-09-19 13:38:00
KABQ 2018-09-19T20:23:00Z 29.93 88.0 10.0 20.0 2018-09-19 13:23:00
KABQ 2018-09-19T19:52:00Z 29.95 87.1 12.0 NA 2018-09-19 12:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query