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-03-27T05:52:00Z 30.02 52.0 5.0 NA 2017-03-26 22:52:00 KABQ 270552Z 33004KT 10SM BKN200 11/M04 A3002 RMK AO2 SLP123 T01111039 10189 20106 51009
KABQ 2017-03-27T04:52:00Z 30.02 53.1 6.0 NA 2017-03-26 21:52:00 KABQ 270452Z 27005KT 10SM BKN200 12/M04 A3002 RMK AO2 SLP125 T01171044
KABQ 2017-03-27T03:52:00Z 30.01 55.9 6.0 NA 2017-03-26 20:52:00 KABQ 270352Z 36005KT 10SM SCT190 13/M05 A3001 RMK AO2 SLP120 T01331050
KABQ 2017-03-27T02:52:00Z 29.99 57.9 8.0 NA 2017-03-26 19:52:00 KABQ 270252Z 34007KT 10SM FEW085 14/M06 A2999 RMK AO2 SLP116 T01441056 51020
KABQ 2017-03-27T01:52:00Z 29.97 60.1 12.0 NA 2017-03-26 18:52:00 KABQ 270152Z 34010KT 10SM FEW085 SCT250 16/M06 A2997 RMK AO2 SLP112 T01561056
KABQ 2017-03-27T00:52:00Z 29.95 63.0 14.0 NA 2017-03-26 17:52:00 KABQ 270052Z 34012KT 10SM FEW085 SCT250 17/M06 A2995 RMK AO2 SLP106 T01721056
KABQ 2017-03-26T23:52:00Z 29.92 64.9 5.0 NA 2017-03-26 16:52:00 KABQ 262352Z VRB04KT 10SM FEW085 SCT250 18/M05 A2992 RMK AO2 SLP091 T01831050 10189 20133 55003
KABQ 2017-03-26T22:52:00Z 29.92 64.9 12.0 20.0 2017-03-26 15:52:00 KABQ 262252Z 29010G17KT 10SM SCT085 SCT250 18/M05 A2992 RMK AO2 SLP089 T01831050
KABQ 2017-03-26T21:52:00Z 29.92 64.9 16.0 22.0 2017-03-26 14:52:00 KABQ 262152Z 32014G19KT 10SM FEW085 BKN250 18/M05 A2992 RMK AO2 SLP090 T01831050
KABQ 2017-03-26T20:52:00Z 29.93 64.0 16.0 23.0 2017-03-26 13:52:00 KABQ 262052Z 30014G20KT 10SM FEW075 SCT250 18/M04 A2993 RMK AO2 SLP089 T01781044 58013
KABQ 2017-03-26T19:52:00Z 29.95 62.1 12.0 NA 2017-03-26 12:52:00 KABQ 261952Z 32010KT 10SM SCT070 17/M04 A2995 RMK AO2 SLP092 T01671039
KABQ 2017-03-26T18:52:00Z 29.96 60.1 14.0 22.0 2017-03-26 11:52:00 KABQ 261852Z 31012G19KT 10SM SCT060 16/M03 A2996 RMK AO2 SLP099 T01561028
KABQ 2017-03-26T17:52:00Z 29.97 55.9 7.0 NA 2017-03-26 10:52:00 KABQ 261752Z 30006KT 10SM FEW050 13/M02 A2997 RMK AO2 SLP106 MTN TOP OBSC NE T01331017 10133 20028 53002
KABQ 2017-03-26T16:52:00Z 29.97 51.1 5.0 NA 2017-03-26 09:52:00 KABQ 261652Z 03004KT 10SM BKN048 11/M01 A2997 RMK AO2 SLP107 MTN TOP OBSC NE T01061011
KABQ 2017-03-26T15:52:00Z 29.97 48.9 3.0 NA 2017-03-26 08:52:00 KABQ 261552Z 28003KT 10SM SCT045 09/M01 A2997 RMK AO2 SLP103 MTN TOPS OBSC NE T00941011
KABQ 2017-03-26T14:52:00Z 29.96 45.0 7.0 NA 2017-03-26 07:52:00 KABQ 261452Z 25006KT 10SM FEW042 07/M01 A2996 RMK AO2 SLP104 MTN TOPS OBSC NE AND SE T00721011 53015
KABQ 2017-03-26T13:52:00Z 29.95 39.0 7.0 NA 2017-03-26 06:52:00 KABQ 261352Z 08006KT 10SM FEW040 04/M02 A2995 RMK AO2 SLP103 MTN TOPS OBSC NE AND SE T00391022
KABQ 2017-03-26T12:52:00Z 29.92 37.9 7.0 NA 2017-03-26 05:52:00 KABQ 261252Z 08006KT 10SM FEW040 FEW050 03/M03 A2992 RMK AO2 SLP091 MTN TOPS OBSC NE AND SE T00331028
KABQ 2017-03-26T11:52:00Z 29.91 37.9 7.0 NA 2017-03-26 04:52:00 KABQ 261152Z 14006KT 10SM FEW050 FEW080 03/M03 A2991 RMK AO2 SLP086 MTN TOPS OBSC NE T00331028 10106 20033 56009
KABQ 2017-03-26T10:52:00Z 29.92 39.9 6.0 NA 2017-03-26 03:52:00 KABQ 261052Z 13005KT 10SM FEW050 FEW080 04/M02 A2992 RMK AO2 SLP082 MTN TOPS OBSC NE T00441022
KABQ 2017-03-26T09:52:00Z 29.93 41.0 6.0 NA 2017-03-26 02:52:00 KABQ 260952Z 10005KT 10SM FEW055 FEW080 05/M02 A2993 RMK AO2 SLP092 T00501017
KABQ 2017-03-26T08:52:00Z 29.95 46.0 0.0 NA 2017-03-26 01:52:00 KABQ 260852Z 00000KT 10SM FEW025 FEW060 SCT095 SCT130 08/M01 A2995 RMK AO2 SLP096 MTNS OBSC E T00781006 58004
KABQ 2017-03-26T07:52:00Z 29.96 48.9 0.0 NA 2017-03-26 00:52:00 KABQ 260752Z 00000KT 10SM FEW045 FEW060 SCT100 BKN130 09/M01 A2996 RMK AO2 SLP094 MTNS OBSC NE T00941011
KABQ 2017-03-26T06:52:00Z 29.97 50.0 6.0 NA 2017-03-25 23:52:00 KABQ 260652Z 03005KT 10SM FEW060 FEW110 SCT130 10/M01 A2997 RMK AO2 SLP098 T01001011 402170050

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query