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 2018-12-14T11:52:00Z 30.39 27.0 7.0 NA 2018-12-14 04:52:00 KABQ 141152Z 04006KT 10SM CLR M03/M13 A3039 RMK AO2 SLP298 T10281128 10011 21044 51005 $
KABQ 2018-12-14T10:52:00Z 30.38 24.1 0.0 NA 2018-12-14 03:52:00 KABQ 141052Z 00000KT 10SM CLR M04/M12 A3038 RMK AO2 SLP297 T10441122 $
KABQ 2018-12-14T09:52:00Z 30.38 27.0 6.0 NA 2018-12-14 02:52:00 KABQ 140952Z 02005KT 10SM CLR M03/M12 A3038 RMK AO2 SLP292 T10281117 $
KABQ 2018-12-14T08:52:00Z 30.37 28.9 7.0 NA 2018-12-14 01:52:00 KABQ 140852Z 04006KT 10SM CLR M02/M12 A3037 RMK AO2 SLP290 T10171117 50002 $
KABQ 2018-12-14T07:52:00Z 30.38 30.0 3.0 NA 2018-12-14 00:52:00 KABQ 140752Z 06003KT 10SM CLR M01/M12 A3038 RMK AO2 SLP291 T10111122 $
KABQ 2018-12-14T06:52:00Z 30.37 32.0 8.0 NA 2018-12-13 23:52:00 KABQ 140652Z 34007KT 10SM CLR 00/M12 A3037 RMK AO2 SLP288 T00001122 400721017 $
KABQ 2018-12-14T05:52:00Z 30.36 34.0 5.0 NA 2018-12-13 22:52:00 KABQ 140552Z 34004KT 10SM CLR 01/M12 A3036 RMK AO2 SLP287 T00111122 10061 20000 51009 $
KABQ 2018-12-14T04:52:00Z 30.35 36.0 9.0 NA 2018-12-13 21:52:00 KABQ 140452Z 35008KT 10SM CLR 02/M13 A3035 RMK AO2 SLP285 T00221128 $
KABQ 2018-12-14T03:52:00Z 30.35 36.0 10.0 NA 2018-12-13 20:52:00 KABQ 140352Z 35009KT 10SM CLR 02/M13 A3035 RMK AO2 SLP286 T00221128 $
KABQ 2018-12-14T02:52:00Z 30.33 37.0 9.0 NA 2018-12-13 19:52:00 KABQ 140252Z 35008KT 10SM CLR 03/M13 A3033 RMK AO2 SLP281 T00281133 53018
KABQ 2018-12-14T01:52:00Z 30.31 37.9 8.0 NA 2018-12-13 18:52:00 KABQ 140152Z 36007KT 10SM CLR 03/M14 A3031 RMK AO2 SLP273 T00331139
KABQ 2018-12-14T00:52:00Z 30.29 39.9 10.0 NA 2018-12-13 17:52:00 KABQ 140052Z 36009KT 10SM FEW250 04/M13 A3029 RMK AO2 SLP264 T00441133
KABQ 2018-12-13T23:52:00Z 30.27 43.0 12.0 NA 2018-12-13 16:52:00 KABQ 132352Z 35010KT 10SM FEW250 06/M14 A3027 RMK AO2 SLP252 T00611144 10072 20028 53002
KABQ 2018-12-13T22:52:00Z 30.27 45.0 13.0 NA 2018-12-13 15:52:00 KABQ 132252Z 31011KT 10SM FEW250 07/M14 A3027 RMK AO2 SLP247 T00721144
KABQ 2018-12-13T21:52:00Z 30.26 44.1 9.0 NA 2018-12-13 14:52:00 KABQ 132152Z 02008KT 10SM FEW250 07/M13 A3026 RMK AO2 SLP246 T00671133
KABQ 2018-12-13T20:52:00Z 30.27 43.0 9.0 NA 2018-12-13 13:52:00 KABQ 132052Z 35008KT 10SM CLR 06/M13 A3027 RMK AO2 SLP247 T00611133 56014
KABQ 2018-12-13T19:52:00Z 30.28 41.0 8.0 NA 2018-12-13 12:52:00 KABQ 131952Z 33007KT 10SM FEW200 05/M13 A3028 RMK AO2 SLP251 T00501128
KABQ 2018-12-13T18:52:00Z 30.29 39.0 8.0 NA 2018-12-13 11:52:00 KABQ 131852Z 02007KT 10SM CLR 04/M12 A3029 RMK AO2 SLP258 T00391122 $
KABQ 2018-12-13T17:52:00Z 30.31 37.0 9.0 NA 2018-12-13 10:52:00 KABQ 131752Z 33008KT 10SM FEW055 03/M12 A3031 RMK AO2 SLP269 T00281117 10028 21017 51017
KABQ 2018-12-13T16:52:00Z 30.29 34.0 8.0 NA 2018-12-13 09:52:00 KABQ 131652Z 34007KT 10SM FEW050 01/M11 A3029 RMK AO2 SLP261 T00111111
KABQ 2018-12-13T15:52:00Z 30.28 30.9 15.0 20.0 2018-12-13 08:52:00 KABQ 131552Z 33013G17KT 10SM FEW050 M01/M11 A3028 RMK AO2 SLP263 T10061111
KABQ 2018-12-13T14:52:00Z 30.25 30.0 8.0 NA 2018-12-13 07:52:00 KABQ 131452Z 34007KT 10SM FEW040 FEW055 M01/M11 A3025 RMK AO2 SLP248 MTN TOPS OBSC SE T10111111 53040
KABQ 2018-12-13T13:52:00Z 30.2 30.0 10.0 NA 2018-12-13 06:52:00 KABQ 131352Z 34009KT 10SM FEW045 FEW110 M01/M11 A3020 RMK AO2 SLP221 T10111111
KABQ 2018-12-13T12:52:00Z 30.16 30.0 13.0 NA 2018-12-13 05:52:00 KABQ 131252Z 34011KT 10SM FEW040 FEW110 SCT160 M01/M11 A3016 RMK AO2 SLP205 MTNS OBSC SE T10111106

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query