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-06-02T01:52:00Z 30.25 64.9 8.0 NA 2020-06-01 18:52:00
KABQ 2020-06-02T01:36:00Z 30.23 66.0 8.0 NA 2020-06-01 18:36:00
KABQ 2020-06-02T01:23:00Z 30.21 66.9 9.0 NA 2020-06-01 18:23:00
KABQ 2020-06-02T00:52:00Z 30.18 66.0 16.0 NA 2020-06-01 17:52:00
KABQ 2020-06-02T00:28:00Z 30.17 66.9 30.0 43.0 2020-06-01 17:28:00
KABQ 2020-06-02T00:13:00Z 30.11 66.9 15.0 33.0 2020-06-01 17:13:00
KABQ 2020-06-02T00:02:00Z 30.1 80.1 21.0 26.0 2020-06-01 17:02:00
KABQ 2020-06-01T23:52:00Z 30.07 82.9 17.0 NA 2020-06-01 16:52:00
KABQ 2020-06-01T23:29:00Z 30.05 86.0 0.0 NA 2020-06-01 16:29:00
KABQ 2020-06-01T22:52:00Z 30.05 90.0 8.0 NA 2020-06-01 15:52:00
KABQ 2020-06-01T21:52:00Z 30.08 86.0 0.0 NA 2020-06-01 14:52:00
KABQ 2020-06-01T20:52:00Z 30.11 87.1 0.0 NA 2020-06-01 13:52:00
KABQ 2020-06-01T19:52:00Z 30.13 86.0 5.0 NA 2020-06-01 12:52:00
KABQ 2020-06-01T18:52:00Z 30.18 82.0 0.0 NA 2020-06-01 11:52:00
KABQ 2020-06-01T17:52:00Z 30.21 82.0 6.0 NA 2020-06-01 10:52:00
KABQ 2020-06-01T16:52:00Z 30.22 75.9 6.0 NA 2020-06-01 09:52:00
KABQ 2020-06-01T15:52:00Z 30.24 75.0 8.0 NA 2020-06-01 08:52:00
KABQ 2020-06-01T14:52:00Z 30.24 73.0 0.0 NA 2020-06-01 07:52:00
KABQ 2020-06-01T13:52:00Z 30.24 69.1 10.0 NA 2020-06-01 06:52:00
KABQ 2020-06-01T12:52:00Z 30.24 66.0 8.0 NA 2020-06-01 05:52:00
KABQ 2020-06-01T11:52:00Z 30.22 64.0 7.0 NA 2020-06-01 04:52:00
KABQ 2020-06-01T10:52:00Z 30.21 66.0 8.0 NA 2020-06-01 03:52:00
KABQ 2020-06-01T09:52:00Z 30.2 66.9 3.0 NA 2020-06-01 02:52:00
KABQ 2020-06-01T08:52:00Z 30.2 71.1 7.0 NA 2020-06-01 01:52:00
KABQ 2020-06-01T07:52:00Z 30.2 71.1 15.0 NA 2020-06-01 00:52:00
KABQ 2020-06-01T06:52:00Z 30.21 71.1 17.0 NA 2020-05-31 23:52:00
KABQ 2020-06-01T05:52:00Z 30.22 72.0 12.0 NA 2020-05-31 22:52:00
KABQ 2020-06-01T04:52:00Z 30.19 73.0 16.0 22.0 2020-05-31 21:52:00
KABQ 2020-06-01T03:52:00Z 30.15 77.0 8.0 NA 2020-05-31 20:52:00
KABQ 2020-06-01T02:52:00Z 30.11 79.0 16.0 22.0 2020-05-31 19:52:00

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query