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-09-26T13:52:00Z 30.09 57.9 18.0 NA 2017-09-26 06:52:00 KABQ 261352Z 10016KT 10SM FEW010 FEW035 SCT050 14/09 A3009 RMK AO2 SLP128 MTNS OBSC NE-SE T01440089
KABQ 2017-09-26T12:52:00Z 30.06 57.0 21.0 28.0 2017-09-26 05:52:00 KABQ 261252Z 10018G24KT 10SM FEW015 FEW035 14/09 A3006 RMK AO2 SLP115 MTNS OBSC NE-SE T01390094
KABQ 2017-09-26T11:52:00Z 30.04 57.9 22.0 26.0 2017-09-26 04:52:00 KABQ 261152Z 09019G23KT 10SM FEW020 FEW040 14/09 A3004 RMK AO2 PK WND 09028/1134 SLP104 MTN TOPS OBSC NE-SE T01440089 10167 20144 53009
KABQ 2017-09-26T10:52:00Z 30.02 57.9 22.0 29.0 2017-09-26 03:52:00 KABQ 261052Z 09019G25KT 10SM FEW020 FEW045 14/09 A3002 RMK AO2 PK WND 09027/1024 SLP099 MTN TOPS OBSC NE-E T01440089
KABQ 2017-09-26T09:52:00Z 30.02 59.0 21.0 28.0 2017-09-26 02:52:00 KABQ 260952Z 08018G24KT 10SM FEW015 FEW050 15/09 A3002 RMK AO2 PK WND 09027/0937 SLP095 MTNS OBSC NE-SE T01500094
KABQ 2017-09-26T08:52:00Z 30.01 59.0 22.0 28.0 2017-09-26 01:52:00 KABQ 260852Z 10019G24KT 10SM FEW035 FEW120 15/10 A3001 RMK AO2 SLP093 MTN TOPS OBSC SE T01500100 51003
KABQ 2017-09-26T07:52:00Z 30.01 60.1 21.0 29.0 2017-09-26 00:52:00 KABQ 260752Z 10018G25KT 10SM FEW020 FEW035 16/10 A3001 RMK AO2 SLP093 MTN TOPS OBSC NE-SE T01560100
KABQ 2017-09-26T06:52:00Z 30.0 61.0 21.0 30.0 2017-09-25 23:52:00 KABQ 260652Z 09018G26KT 10SM FEW020 FEW040 16/10 A3000 RMK AO2 PK WND 07028/0553 SLP091 MTN TOPS OBSC NE-SE T01610100 402390111
KABQ 2017-09-26T05:52:00Z 30.0 62.1 25.0 31.0 2017-09-25 22:52:00 KABQ 260552Z 07022G27KT 10SM FEW040 17/10 A3000 RMK AO2 PK WND 06027/0551 SLP094 MTN TOPS OBSC NE-E T01670100 10233 20167 50008
KABQ 2017-09-26T04:52:00Z 30.0 63.0 15.0 NA 2017-09-25 21:52:00 KABQ 260452Z 09013KT 10SM FEW050 17/09 A3000 RMK AO2 SLP099 MTN TOPS OBSC NE T01720089
KABQ 2017-09-26T03:52:00Z 29.98 64.9 7.0 NA 2017-09-25 20:52:00 KABQ 260352Z 36006KT 10SM FEW070 FEW250 18/M14 A2998 RMK AO2 SLP092 CB DSNT SE T01831139
KABQ 2017-09-26T02:52:00Z 29.97 66.0 7.0 NA 2017-09-25 19:52:00 KABQ 260252Z 35006KT 10SM FEW070 FEW250 19/M12 A2997 RMK AO2 SLP090 CB DSNT SE T01891122 53014
KABQ 2017-09-26T01:52:00Z 29.95 69.1 7.0 NA 2017-09-25 18:52:00 KABQ 260152Z 35006KT 10SM FEW070 FEW250 21/M11 A2995 RMK AO2 SLP083 CB DSNT E-SE T02061106
KABQ 2017-09-26T00:52:00Z 29.93 72.0 8.0 NA 2017-09-25 17:52:00 KABQ 260052Z 02007KT 10SM FEW110 22/M11 A2993 RMK AO2 SLP074 T02221106
KABQ 2017-09-25T23:52:00Z 29.92 73.9 12.0 NA 2017-09-25 16:52:00 KABQ 252352Z 02010KT 10SM FEW110 23/M11 A2992 RMK AO2 SLP067 T02331106 10239 20189 56005
KABQ 2017-09-25T22:52:00Z 29.93 73.9 7.0 NA 2017-09-25 15:52:00 KABQ 252252Z 02006KT 10SM FEW110 23/M09 A2993 RMK AO2 SLP068 T02331094
KABQ 2017-09-25T21:52:00Z 29.93 73.9 7.0 NA 2017-09-25 14:52:00 KABQ 252152Z 02006KT 10SM FEW110 23/M08 A2993 RMK AO2 SLP065 CB DSNT SE T02331083
KABQ 2017-09-25T20:52:00Z 29.94 72.0 6.0 NA 2017-09-25 13:52:00 KABQ 252052Z 01005KT 10SM CLR 22/M07 A2994 RMK AO2 SLP071 T02221067 56016
KABQ 2017-09-25T19:52:00Z 29.95 71.1 3.0 NA 2017-09-25 12:52:00 KABQ 251952Z VRB03KT 10SM CLR 22/M06 A2995 RMK AO2 SLP077 T02171056
KABQ 2017-09-25T18:52:00Z 29.98 70.0 6.0 NA 2017-09-25 11:52:00 KABQ 251852Z VRB05KT 10SM FEW110 21/M06 A2998 RMK AO2 SLP085 T02111056
KABQ 2017-09-25T17:52:00Z 29.99 66.0 7.0 NA 2017-09-25 10:52:00 KABQ 251752Z 31006KT 10SM CLR 19/M05 A2999 RMK AO2 SLP092 T01891050 10194 20111 58006
KABQ 2017-09-25T16:52:00Z 30.0 62.1 9.0 NA 2017-09-25 09:52:00 KABQ 251652Z 33008KT 10SM FEW090 17/M04 A3000 RMK AO2 SLP098 T01671044
KABQ 2017-09-25T15:52:00Z 30.02 59.0 8.0 NA 2017-09-25 08:52:00 KABQ 251552Z 33007KT 10SM FEW090 15/M05 A3002 RMK AO2 SLP103 T01501050
KABQ 2017-09-25T14:52:00Z 30.01 55.9 8.0 NA 2017-09-25 07:52:00 KABQ 251452Z 01007KT 10SM FEW090 13/M05 A3001 RMK AO2 SLP102 T01331050 51007

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query