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 2019-12-13T05:52:00Z 30.19 37.9 6.0 NA 2019-12-12 22:52:00 KABQ 130552Z 01005KT 10SM BKN250 03/M04 A3019 RMK AO2 SLP219 T00331044 10094 20028 53002
KABQ 2019-12-13T04:52:00Z 30.18 37.9 6.0 NA 2019-12-12 21:52:00 KABQ 130452Z 08005KT 10SM BKN250 03/M04 A3018 RMK AO2 SLP220 T00331044
KABQ 2019-12-13T03:52:00Z 30.18 42.1 6.0 NA 2019-12-12 20:52:00 KABQ 130352Z 30005KT 10SM BKN250 06/M05 A3018 RMK AO2 SLP221 T00561050
KABQ 2019-12-13T02:52:00Z 30.19 43.0 6.0 NA 2019-12-12 19:52:00 KABQ 130252Z 24005KT 10SM BKN260 06/M06 A3019 RMK AO2 SLP224 T00611056 50007
KABQ 2019-12-13T01:52:00Z 30.19 46.9 13.0 20.0 2019-12-12 18:52:00 KABQ 130152Z 34011G17KT 10SM BKN260 08/M06 A3019 RMK AO2 SLP219 T00831061
KABQ 2019-12-13T00:52:00Z 30.18 46.9 5.0 NA 2019-12-12 17:52:00 KABQ 130052Z 26004KT 10SM SCT250 08/M06 A3018 RMK AO2 SLP218 T00831061
KABQ 2019-12-12T23:52:00Z 30.16 48.9 0.0 NA 2019-12-12 16:52:00 KABQ 122352Z 00000KT 10SM FEW250 09/M06 A3016 RMK AO2 SLP204 T00941061 10111 20044 55002
KABQ 2019-12-12T22:52:00Z 30.16 51.1 0.0 NA 2019-12-12 15:52:00 KABQ 122252Z 00000KT 10SM FEW250 11/M07 A3016 RMK AO2 SLP202 T01061067
KABQ 2019-12-12T21:52:00Z 30.16 50.0 0.0 NA 2019-12-12 14:52:00 KABQ 122152Z 00000KT 10SM FEW250 10/M07 A3016 RMK AO2 SLP203 T01001067
KABQ 2019-12-12T20:52:00Z 30.17 50.0 0.0 NA 2019-12-12 13:52:00 KABQ 122052Z 00000KT 10SM FEW060 FEW250 10/M07 A3017 RMK AO2 SLP205 T01001067 58029
KABQ 2019-12-12T19:52:00Z 30.2 46.9 0.0 NA 2019-12-12 12:52:00 KABQ 121952Z 00000KT 10SM FEW250 08/M06 A3020 RMK AO2 SLP220 T00831056
KABQ 2019-12-12T18:52:00Z 30.24 45.0 5.0 NA 2019-12-12 11:52:00 KABQ 121852Z 23004KT 10SM FEW250 07/M03 A3024 RMK AO2 SLP231 T00721033
KABQ 2019-12-12T17:52:00Z 30.27 39.9 3.0 NA 2019-12-12 10:52:00 KABQ 121752Z 25003KT 10SM FEW200 SCT250 04/00 A3027 RMK AO2 SLP251 I6000 T00440000 10050 21033 50002
KABQ 2019-12-12T16:52:00Z 30.29 36.0 3.0 NA 2019-12-12 09:52:00 KABQ 121652Z 19003KT 10SM FEW230 BKN300 02/01 A3029 RMK AO2 SLP259 T00220011
KABQ 2019-12-12T15:52:00Z 30.28 30.9 0.0 NA 2019-12-12 08:52:00 KABQ 121552Z 00000KT 6SM BR FEW000 FEW020 BKN250 M01/M01 A3028 RMK AO2 SLP264 FZFG FEW000 MTNS OBSC SE T10061011
KABQ 2019-12-12T15:06:00Z 30.26 28.0 0.0 NA 2019-12-12 08:06:00 KABQ 121506Z 00000KT 4SM BR FEW000 FEW200 BKN250 M02/M02 A3026 RMK AO2 VIS SE-SW 1/4 W 1/2 FZFG FEW000 T10221022
KABQ 2019-12-12T14:52:00Z 30.26 28.0 0.0 NA 2019-12-12 07:52:00 KABQ 121452Z 00000KT 6SM BR FEW000 BKN250 M02/M02 A3026 RMK AO2 SLP263 VIS E-S 1/4 FZFG FEW000 I1000 I3000 T10221022 51015
KABQ 2019-12-12T14:44:00Z 30.26 28.9 3.0 NA 2019-12-12 07:44:00 KABQ 121444Z 11003KT 6SM BR FEW000 BKN250 M02/M03 A3026 RMK AO2 VIS SE-SW 1/8 FZFG FEW000 I1000 T10171028
KABQ 2019-12-12T14:32:00Z 30.25 28.0 0.0 NA 2019-12-12 07:32:00 KABQ 121432Z 00000KT 1/4SM FZFG SCT000 SCT015 BKN230 M02/M03 A3025 RMK AO2 VIS 1/4V3 FZFG SCT000 I1000 T10221033
KABQ 2019-12-12T13:52:00Z 30.25 28.9 0.0 NA 2019-12-12 06:52:00 KABQ 121352Z 00000KT 7SM FEW000 FEW230 M02/M03 A3025 RMK AO2 SLP253 FZFG FEW000 I1000 T10171033
KABQ 2019-12-12T12:52:00Z 30.23 28.9 0.0 NA 2019-12-12 05:52:00 KABQ 121252Z 00000KT 8SM FEW000 FEW002 M02/M04 A3023 RMK AO2 SLP246 FZFG FEW000 T10171039
KABQ 2019-12-12T12:24:00Z 30.22 30.0 0.0 NA 2019-12-12 05:24:00 KABQ 121224Z 00000KT 8SM FEW000 FEW002 M01/M02 A3022 RMK AO2 FZFG FEW000 T10111022
KABQ 2019-12-12T11:52:00Z 30.21 30.9 3.0 NA 2019-12-12 04:52:00 KABQ 121152Z 36003KT 8SM FEW001 FEW005 M01/M01 A3021 RMK AO2 SLP230 MTNS OBSC E I1000 I6000 T10061011 10017 21022 50000
KABQ 2019-12-12T10:52:00Z 30.21 30.0 0.0 NA 2019-12-12 03:52:00 KABQ 121052Z 00000KT 8SM FEW002 FEW010 M01/M03 A3021 RMK AO2 SLP231 MTNS OBSC E T10111028
KABQ 2019-12-12T09:52:00Z 30.21 30.9 0.0 NA 2019-12-12 02:52:00 KABQ 120952Z 00000KT 8SM FEW009 FEW015 M01/M02 A3021 RMK AO2 SLP228 MTNS OBSC E T10061022
KABQ 2019-12-12T09:37:00Z 30.21 30.9 0.0 NA 2019-12-12 02:37:00 KABQ 120937Z 00000KT 8SM FEW009 FEW020 M01/M03 A3021 RMK AO2 MTNS OBSC E T10061028
KABQ 2019-12-12T08:52:00Z 30.21 30.9 5.0 NA 2019-12-12 01:52:00 KABQ 120852Z 11004KT 8SM FEW010 FEW040 M01/M02 A3021 RMK AO2 SLP230 T10061022 58002
KABQ 2019-12-12T07:52:00Z 30.22 32.0 0.0 NA 2019-12-12 00:52:00 KABQ 120752Z 00000KT 10SM FEW050 SCT210 00/M02 A3022 RMK AO2 SLP230 MTN TOPS OBSC NE T00001017
KABQ 2019-12-12T06:52:00Z 30.21 35.1 0.0 NA 2019-12-11 23:52:00 KABQ 120652Z 00000KT 10SM FEW060 SCT200 02/M01 A3021 RMK AO2 SLP229 T00171006 400671028

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query