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)", ""||raw_text||"" AS "METAR" 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) METAR
KABQ 2017-05-27T08:52:00Z 30.05 57.0 8.0 NA 2017-05-27 01:52:00 KABQ 270852Z 13007KT 10SM CLR 14/M13 A3005 RMK AO2 SLP104 T01391128 51006
KABQ 2017-05-27T07:52:00Z 30.05 60.1 6.0 NA 2017-05-27 00:52:00 KABQ 270752Z 14005KT 10SM CLR 16/M13 A3005 RMK AO2 SLP099 T01561128
KABQ 2017-05-27T06:52:00Z 30.04 61.0 5.0 NA 2017-05-26 23:52:00 KABQ 270652Z 10004KT 10SM CLR 16/M13 A3004 RMK AO2 SLP099 T01611128 403000111
KABQ 2017-05-27T05:52:00Z 30.03 68.0 0.0 NA 2017-05-26 22:52:00 KABQ 270552Z 00000KT 10SM CLR 20/M13 A3003 RMK AO2 SLP091 T02001128 10300 20200 51025
KABQ 2017-05-27T04:52:00Z 30.02 71.1 0.0 NA 2017-05-26 21:52:00 KABQ 270452Z 00000KT 10SM CLR 22/M12 A3002 RMK AO2 SLP085 T02171122
KABQ 2017-05-27T03:52:00Z 29.99 73.9 12.0 NA 2017-05-26 20:52:00 KABQ 270352Z 26010KT 10SM CLR 23/M13 A2999 RMK AO2 SLP074 T02331128
KABQ 2017-05-27T02:52:00Z 29.95 75.9 17.0 NA 2017-05-26 19:52:00 KABQ 270252Z 28015KT 10SM FEW140 24/M14 A2995 RMK AO2 SLP059 T02441139 53018
KABQ 2017-05-27T01:52:00Z 29.91 81.0 18.0 NA 2017-05-26 18:52:00 KABQ 270152Z 28016KT 10SM FEW140 27/M15 A2991 RMK AO2 PK WND 28029/0128 SLP049 T02721150
KABQ 2017-05-27T00:52:00Z 29.89 84.0 23.0 29.0 2017-05-26 17:52:00 KABQ 270052Z 26020G25KT 10SM SCT140 29/M15 A2989 RMK AO2 PK WND 27030/0026 SLP044 VIRGA E T02891150
KABQ 2017-05-26T23:52:00Z 29.89 86.0 23.0 30.0 2017-05-26 16:52:00 KABQ 262352Z 26020G26KT 10SM SCT150 30/M13 A2989 RMK AO2 PK WND 27026/2352 SLP043 T03001133 10300 20239 56016
KABQ 2017-05-26T22:52:00Z 29.9 82.0 7.0 NA 2017-05-26 15:52:00 KABQ 262252Z 24006KT 10SM BKN150 28/M13 A2990 RMK AO2 WSHFT 2201 SLP047 T02781128
KABQ 2017-05-26T22:21:00Z 29.91 84.0 16.0 25.0 2017-05-26 15:21:00 KABQ 262221Z 23014G22KT 10SM BKN150 29/M13 A2991 RMK AO2 WSHFT 2201 T02891128
KABQ 2017-05-26T21:52:00Z 29.91 82.0 3.0 NA 2017-05-26 14:52:00 KABQ 262152Z VRB03KT 10SM BKN160 28/M13 A2991 RMK AO2 SLP053 T02781128
KABQ 2017-05-26T20:52:00Z 29.94 81.0 5.0 NA 2017-05-26 13:52:00 KABQ 262052Z 32004KT 10SM SCT150 27/M11 A2994 RMK AO2 SLP059 T02721106 58024
KABQ 2017-05-26T19:52:00Z 29.98 81.0 13.0 21.0 2017-05-26 12:52:00 KABQ 261952Z 24011G18KT 10SM FEW150 27/M11 A2998 RMK AO2 SLP064 T02721111
KABQ 2017-05-26T18:52:00Z 30.0 78.1 8.0 NA 2017-05-26 11:52:00 KABQ 261852Z 24007KT 10SM FEW140 FEW250 26/M10 A3000 RMK AO2 SLP075 T02561100
KABQ 2017-05-26T17:52:00Z 30.03 75.9 6.0 NA 2017-05-26 10:52:00 KABQ 261752Z VRB05KT 10SM FEW250 24/M10 A3003 RMK AO2 SLP088 T02441100 10244 20111 58010
KABQ 2017-05-26T16:52:00Z 30.04 73.0 6.0 NA 2017-05-26 09:52:00 KABQ 261652Z VRB05KT 10SM FEW250 23/M09 A3004 RMK AO2 SLP094 T02281094
KABQ 2017-05-26T15:52:00Z 30.05 70.0 5.0 NA 2017-05-26 08:52:00 KABQ 261552Z 22004KT 10SM FEW270 21/M11 A3005 RMK AO2 SLP098 T02111106
KABQ 2017-05-26T14:52:00Z 30.06 69.1 6.0 NA 2017-05-26 07:52:00 KABQ 261452Z 25005KT 10SM FEW270 21/M10 A3006 RMK AO2 SLP098 T02061100 51014
KABQ 2017-05-26T13:52:00Z 30.06 63.0 6.0 NA 2017-05-26 06:52:00 KABQ 261352Z 16005KT 10SM FEW250 17/M11 A3006 RMK AO2 SLP100 T01721106
KABQ 2017-05-26T12:52:00Z 30.03 55.9 10.0 NA 2017-05-26 05:52:00 KABQ 261252Z 13009KT 10SM FEW250 13/M11 A3003 RMK AO2 SLP096 T01331106
KABQ 2017-05-26T11:52:00Z 30.01 53.1 6.0 NA 2017-05-26 04:52:00 KABQ 261152Z 12005KT 10SM SCT250 12/M11 A3001 RMK AO2 SLP089 T01171111 10206 20111 53012
KABQ 2017-05-26T10:52:00Z 30.0 57.9 6.0 NA 2017-05-26 03:52:00 KABQ 261052Z 15005KT 10SM FEW250 14/M12 A3000 RMK AO2 SLP078 T01441122
KABQ 2017-05-26T09:52:00Z 29.98 57.9 10.0 NA 2017-05-26 02:52:00 KABQ 260952Z 10009KT 10SM CLR 14/M12 A2998 RMK AO2 SLP073 T01441122

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query