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-09-15T23:52:00Z 30.21 64.9 0.0 NA 2019-09-15 16:52:00 KABQ 152352Z 00000KT 10SM -RA FEW020 OVC055 18/13 A3021 RMK AO2 RAB46 SLP166 P0000 60003 T01830133 10194 20161 56009
KABQ 2019-09-15T22:52:00Z 30.21 64.0 7.0 NA 2019-09-15 15:52:00 KABQ 152252Z 07006KT 10SM FEW015 SCT048 BKN065 18/14 A3021 RMK AO2 RAE34 SLP167 MTN TOPS OBSC NE-SE P0001 T01780139
KABQ 2019-09-15T21:52:00Z 30.23 64.9 6.0 NA 2019-09-15 14:52:00 KABQ 152152Z 03005KT 9SM -RA FEW030 SCT065 OVC095 18/13 A3023 RMK AO2 SLP172 MTNS OBSC NE-SE P0001 T01830133
KABQ 2019-09-15T20:52:00Z 30.24 64.9 6.0 NA 2019-09-15 13:52:00 KABQ 152052Z 36005KT 10SM -RA FEW035 BKN070 OVC085 18/13 A3024 RMK AO2 RAB21 SLP176 MTNS OBSC NE-SE P0001 60001 T01830133 58015 $
KABQ 2019-09-15T19:52:00Z 30.27 66.0 9.0 NA 2019-09-15 12:52:00 KABQ 151952Z 33008KT 10SM FEW040 FEW065 BKN100 OVC140 19/13 A3027 RMK AO2 SLP181 CB DSNT SE SHRA DSNT SE MTNS OBSC SE T01890133 $
KABQ 2019-09-15T18:52:00Z 30.29 64.0 12.0 NA 2019-09-15 11:52:00 KABQ 151852Z 02010KT 10SM FEW030 SCT060 OVC110 18/15 A3029 RMK AO2 RAE29 SLP188 MTNS OBSC SE P0000 T01780150 $
KABQ 2019-09-15T17:52:00Z 30.3 61.0 13.0 NA 2019-09-15 10:52:00 KABQ 151752Z 35011KT 9SM -RA FEW020 FEW060 OVC080 16/14 A3030 RMK AO2 RAB08 SLP196 VIS NW-N 2 1/2 MTNS PTLY OBSC NE-SE P0003 60009 T01610144 10189 20156 58004 $
KABQ 2019-09-15T16:52:00Z 30.31 63.0 10.0 NA 2019-09-15 09:52:00 KABQ 151652Z 35009KT 310V020 10SM FEW040 FEW080 OVC100 17/15 A3031 RMK AO2 RAB31E44 SLP198 P0000 T01720150 $
KABQ 2019-09-15T15:52:00Z 30.32 62.1 7.0 NA 2019-09-15 08:52:00 KABQ 151552Z 02006KT 9SM SCT040 BKN075 OVC090 17/14 A3032 RMK AO2 RAE49 SLP204 MTNS PTLY OBSC NE-SE P0002 T01670144 $
KABQ 2019-09-15T14:52:00Z 30.31 61.0 12.0 NA 2019-09-15 07:52:00 KABQ 151452Z 08010KT 4SM RA BR FEW015 BKN050 OVC090 16/14 A3031 RMK AO2 SLP203 MTNS OBSC NE-SE P0004 60004 T01610144 50012
KABQ 2019-09-15T13:52:00Z 30.31 63.0 14.0 NA 2019-09-15 06:52:00 KABQ 151352Z 19012KT 10SM -RA FEW015 BKN050 OVC100 17/13 A3031 RMK AO2 RAB23E32B48 SLP196 MTNS OBSC NE-SE P0000 T01720128
KABQ 2019-09-15T12:52:00Z 30.28 66.0 5.0 NA 2019-09-15 05:52:00 KABQ 151252Z 16004KT 10SM BKN060 OVC100 19/11 A3028 RMK AO2 SLP183 T01890111
KABQ 2019-09-15T11:52:00Z 30.27 64.9 0.0 NA 2019-09-15 04:52:00 KABQ 151152Z 00000KT 10SM SCT060 BKN100 BKN150 OVC190 18/11 A3027 RMK AO2 SLP177 T01830106 10206 20183 53001
KABQ 2019-09-15T10:52:00Z 30.27 64.9 5.0 NA 2019-09-15 03:52:00 KABQ 151052Z 18004KT 10SM FEW075 SCT100 OVC190 18/11 A3027 RMK AO2 SLP174 T01830106
KABQ 2019-09-15T09:52:00Z 30.26 66.9 0.0 NA 2019-09-15 02:52:00 KABQ 150952Z 00000KT 10SM FEW090 FEW120 BKN150 BKN220 19/12 A3026 RMK AO2 SLP167 T01940117
KABQ 2019-09-15T08:52:00Z 30.26 66.0 5.0 NA 2019-09-15 01:52:00 KABQ 150852Z 30004KT 10SM FEW095 SCT130 OVC170 19/11 A3026 RMK AO2 SLP167 T01890111 56002
KABQ 2019-09-15T07:52:00Z 30.27 66.9 6.0 NA 2019-09-15 00:52:00 KABQ 150752Z 29005KT 10SM FEW100 BKN130 OVC200 19/12 A3027 RMK AO2 SLP166 T01940117
KABQ 2019-09-15T06:52:00Z 30.26 69.1 0.0 NA 2019-09-14 23:52:00 KABQ 150652Z 00000KT 10SM FEW110 OVC150 21/10 A3026 RMK AO2 SLP165 T02060100 402940178
KABQ 2019-09-15T05:52:00Z 30.27 68.0 6.0 NA 2019-09-14 22:52:00 KABQ 150552Z 10005KT 10SM OVC160 20/11 A3027 RMK AO2 SLP169 T02000106 10239 20178 58007
KABQ 2019-09-15T04:52:00Z 30.29 69.1 15.0 NA 2019-09-14 21:52:00 KABQ 150452Z 15013KT 10SM FEW110 OVC180 21/12 A3029 RMK AO2 SLP178 T02060117
KABQ 2019-09-15T03:52:00Z 30.29 68.0 10.0 NA 2019-09-14 20:52:00 KABQ 150352Z 13009KT 10SM FEW070 OVC160 20/09 A3029 RMK AO2 SLP183 T02000089
KABQ 2019-09-15T02:52:00Z 30.29 66.0 5.0 NA 2019-09-14 19:52:00 KABQ 150252Z 25004KT 10SM FEW060 SCT070 19/09 A3029 RMK AO2 TSB07E22 SLP187 CB DSNT W T01890094 50020
KABQ 2019-09-15T02:37:00Z 30.3 64.0 9.0 NA 2019-09-14 19:37:00 KABQ 150237Z 29008KT 10SM SCT055 BKN070 18/10 A3030 RMK AO2 TSB07E22 CB DSNT NW T01780100
KABQ 2019-09-15T02:28:00Z 30.31 66.0 15.0 24.0 2019-09-14 19:28:00 KABQ 150228Z 32013G21KT 10SM VCTS FEW050 OVC065CB 19/09 A3031 RMK AO2 LTG DSNT NW TSB07E22 FRQ LTGICCG VC NW TS NW MOV W T01890094
KABQ 2019-09-15T02:13:00Z 30.31 68.0 12.0 28.0 2019-09-14 19:13:00 KABQ 150213Z 35010G24KT 10SM TS OVC070CB 20/08 A3031 RMK AO2 LTG DSNT NW TSB07 FRQ LTGICCG N TS N MOV W T02000078
KABQ 2019-09-15T01:52:00Z 30.3 73.0 10.0 NA 2019-09-14 18:52:00 KABQ 150152Z 30009KT 10SM VCTS BKN075CB OVC090 23/09 A3030 RMK AO2 LTG DSNT NW-NE SLP187 OCNL LTGICCG VC NW TS NW MOV W T02280094
KABQ 2019-09-15T01:27:00Z 30.27 73.0 8.0 NA 2019-09-14 18:27:00 KABQ 150127Z 15007KT 10SM VCTS BKN095CB OVC170 23/10 A3027 RMK AO2 LTG DSNT N AND NW OCNL LTGICCG VC N TS N MOV W T02280100
KABQ 2019-09-15T00:52:00Z 30.25 73.0 13.0 NA 2019-09-14 17:52:00 KABQ 150052Z 16011KT 10SM SCT110 BKN140 23/11 A3025 RMK AO2 LTG DSNT N-E SLP170 T02280106

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query