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-02-27T14:52:00Z 29.95 34.0 6.0 NA 2017-02-27 07:52:00 KABQ 271452Z 12005KT 10SM FEW060 SCT250 01/M04 A2995 RMK AO2 SLP138 T00111044 53010
KABQ 2017-02-27T13:52:00Z 29.94 32.0 0.0 NA 2017-02-27 06:52:00 KABQ 271352Z 00000KT 10SM FEW060 FEW250 00/M06 A2994 RMK AO2 SLP137 T00001056
KABQ 2017-02-27T12:52:00Z 29.92 30.9 8.0 NA 2017-02-27 05:52:00 KABQ 271252Z 11007KT 10SM SCT060 M01/M05 A2992 RMK AO2 SLP127 T10061050
KABQ 2017-02-27T11:52:00Z 29.92 33.1 0.0 NA 2017-02-27 04:52:00 KABQ 271152Z 00000KT 10SM SCT060 01/M05 A2992 RMK AO2 SLP125 T00061050 10033 21011 58002
KABQ 2017-02-27T10:52:00Z 29.92 32.0 3.0 NA 2017-02-27 03:52:00 KABQ 271052Z 09003KT 10SM FEW060 00/M05 A2992 RMK AO2 SLP129 T00001050
KABQ 2017-02-27T09:52:00Z 29.94 30.9 3.0 NA 2017-02-27 02:52:00 KABQ 270952Z 17003KT 10SM FEW080 M01/M05 A2994 RMK AO2 SLP137 T10061050
KABQ 2017-02-27T08:52:00Z 29.93 32.0 8.0 NA 2017-02-27 01:52:00 KABQ 270852Z 13007KT 10SM CLR 00/M06 A2993 RMK AO2 SLP128 T00001056 58002
KABQ 2017-02-27T07:52:00Z 29.94 30.9 7.0 NA 2017-02-27 00:52:00 KABQ 270752Z 12006KT 10SM CLR M01/M06 A2994 RMK AO2 SLP135 T10061056
KABQ 2017-02-27T06:52:00Z 29.94 33.1 9.0 NA 2017-02-26 23:52:00 KABQ 270652Z 15008KT 10SM FEW080 01/M06 A2994 RMK AO2 SLP129 T00061061 400720006
KABQ 2017-02-27T05:52:00Z 29.93 39.0 8.0 NA 2017-02-26 22:52:00 KABQ 270552Z 18007KT 10SM FEW060 BKN080 04/M05 A2993 RMK AO2 SLP125 T00391050 10061 20028 50003
KABQ 2017-02-27T04:52:00Z 29.94 37.9 3.0 NA 2017-02-26 21:52:00 KABQ 270452Z 18003KT 10SM FEW050 BKN080 03/M05 A2994 RMK AO2 SLP129 VIRGA NW-N T00331050
KABQ 2017-02-27T03:52:00Z 29.93 41.0 3.0 NA 2017-02-26 20:52:00 KABQ 270352Z 18003KT 10SM BKN090 05/M05 A2993 RMK AO2 SLP128 T00501050
KABQ 2017-02-27T02:52:00Z 29.92 41.0 5.0 NA 2017-02-26 19:52:00 KABQ 270252Z 12004KT 10SM FEW065 BKN090 05/M05 A2992 RMK AO2 SLP127 T00501050 51009
KABQ 2017-02-27T01:52:00Z 29.92 42.1 6.0 NA 2017-02-26 18:52:00 KABQ 270152Z 11005KT 10SM FEW065 BKN090 06/M04 A2992 RMK AO2 SLP124 T00561044
KABQ 2017-02-27T00:52:00Z 29.91 42.1 9.0 NA 2017-02-26 17:52:00 KABQ 270052Z 13008KT 10SM FEW040 BKN075 BKN110 BKN250 06/M04 A2991 RMK AO2 SLP118 MTN TOPS OBSC NE SHSN DSNT NE T00561044
KABQ 2017-02-26T23:52:00Z 29.89 42.1 7.0 NA 2017-02-26 16:52:00 KABQ 262352Z 16006KT 10SM FEW065 SCT080 SCT110 BKN250 06/M05 A2989 RMK AO2 SLP114 VIRGA ALQDS T00561050 10072 20050 58004
KABQ 2017-02-26T22:52:00Z 29.91 42.1 3.0 NA 2017-02-26 15:52:00 KABQ 262252Z 08003KT 10SM FEW040 OVC050 06/M05 A2991 RMK AO2 SLP115 VIRGA ALQDS SHSN DSNT NE AND SE MTNS OBSC DSNT NE AND SE T00561050
KABQ 2017-02-26T21:52:00Z 29.9 41.0 15.0 NA 2017-02-26 14:52:00 KABQ 262152Z 03013KT 10SM SCT044 OVC085 05/M03 A2990 RMK AO2 SLP110 VIRGA ALQDS SHSN DSNT NE AND SE MTN TOPS OBSC DSNT NE AND SE T00501033
KABQ 2017-02-26T20:52:00Z 29.91 44.1 16.0 NA 2017-02-26 13:52:00 KABQ 262052Z 01014KT 10SM BKN049 OVC075 07/M06 A2991 RMK AO2 SLP108 VIRGA ALQDS SHSN DSNT NE AND SE MTNS OBSC DSNT NE AND SE T00671061 56019
KABQ 2017-02-26T19:52:00Z 29.92 43.0 8.0 NA 2017-02-26 12:52:00 KABQ 261952Z 01007KT 300V060 10SM FEW065 BKN085 BKN130 BKN260 06/M07 A2992 RMK AO2 SLP116 SHSN DSNT NE AND SE MTNS OBSC DSNT NE AND SE T00611072
KABQ 2017-02-26T18:52:00Z 29.94 44.1 3.0 NA 2017-02-26 11:52:00 KABQ 261852Z VRB03KT 10SM BKN070 BKN140 BKN250 07/M07 A2994 RMK AO2 SLP122 T00671072
KABQ 2017-02-26T17:52:00Z 29.97 41.0 5.0 NA 2017-02-26 10:52:00 KABQ 261752Z 28004KT 10SM BKN055 BKN100 BKN200 05/M07 A2997 RMK AO2 SLP136 T00501072 10050 20011 50003
KABQ 2017-02-26T16:52:00Z 29.98 39.0 8.0 NA 2017-02-26 09:52:00 KABQ 261652Z 22007KT 10SM BKN055 BKN130 BKN240 04/M06 A2998 RMK AO2 SLP142 T00391061
KABQ 2017-02-26T15:52:00Z 29.98 36.0 0.0 NA 2017-02-26 08:52:00 KABQ 261552Z 00000KT 10SM BKN050 BKN100 02/M06 A2998 RMK AO2 SLP140 MTN TOPS OBSC NE T00221056

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query