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-06-27T09:52:00Z 30.23 73.0 7.0 NA 2019-06-27 02:52:00 KABQ 270952Z 19006KT 10SM FEW150 23/06 A3023 RMK AO2 SLP143 T02280061
KABQ 2019-06-27T08:52:00Z 30.22 75.0 8.0 NA 2019-06-27 01:52:00 KABQ 270852Z 19007KT 10SM BKN150 24/06 A3022 RMK AO2 SLP135 T02390061 51005
KABQ 2019-06-27T07:52:00Z 30.22 73.0 9.0 NA 2019-06-27 00:52:00 KABQ 270752Z 17008KT 10SM SCT130 SCT250 23/06 A3022 RMK AO2 SLP133 T02280061
KABQ 2019-06-27T06:52:00Z 30.22 73.9 9.0 NA 2019-06-26 23:52:00 KABQ 270652Z 15008KT 10SM FEW130 SCT250 23/06 A3022 RMK AO2 SLP134 T02330056 403440167
KABQ 2019-06-27T05:52:00Z 30.2 78.1 12.0 NA 2019-06-26 22:52:00 KABQ 270552Z 12010KT 10SM FEW110 SCT150 BKN220 26/05 A3020 RMK AO2 SLP129 T02560050 10311 20256 51019
KABQ 2019-06-27T04:52:00Z 30.18 79.0 18.0 NA 2019-06-26 21:52:00 KABQ 270452Z 09016KT 10SM FEW110 BKN150 BKN250 26/06 A3018 RMK AO2 LTG DSNT SE SLP124 T02610056
KABQ 2019-06-27T03:52:00Z 30.16 81.0 13.0 NA 2019-06-26 20:52:00 KABQ 270352Z 11011KT 10SM SCT100 BKN160 BKN250 27/04 A3016 RMK AO2 TSE03 SLP116 VIRGA CB DSNT E T02720044
KABQ 2019-06-27T03:33:00Z 30.16 81.0 21.0 NA 2019-06-26 20:33:00 KABQ 270333Z 08018KT 10SM SCT100 BKN160 BKN250 27/04 A3016 RMK AO2 TSE03 VIRGA CB DSNT E T02720044
KABQ 2019-06-27T03:03:00Z 30.14 82.9 10.0 NA 2019-06-26 20:03:00 KABQ 270303Z 07009KT 10SM VCTS SCT120CB BKN160 BKN250 28/03 A3014 RMK AO2 LTG DSNT ALQDS TSE03 OCNL LTGCG VC E TS E MOV E VIRGA E T02830033
KABQ 2019-06-27T02:52:00Z 30.14 82.9 8.0 NA 2019-06-26 19:52:00 KABQ 270252Z 04007KT 10SM TS SCT120CB BKN160 BKN250 28/03 A3014 RMK AO2 LTG DSNT NE AND S AND NW TSB34 SLP109 OCNL LTGICCC OHD-N TS OHD-N MOV E VIRGA W-N T02830028 53008
KABQ 2019-06-27T02:34:00Z 30.13 82.0 6.0 NA 2019-06-26 19:34:00 KABQ 270234Z 10005KT 10SM TS SCT110CB BKN160 BKN250 28/03 A3013 RMK AO2 LTG DSNT W TSB34 OCNL LTGIC W TS W MOV E VIRGA W T02780028
KABQ 2019-06-27T01:52:00Z 30.11 84.0 9.0 NA 2019-06-26 18:52:00 KABQ 270152Z 13008KT 10SM SCT110 BKN160 BKN250 29/03 A3011 RMK AO2 SLP102 VIRGA W-N T02890033
KABQ 2019-06-27T00:52:00Z 30.11 87.1 9.0 NA 2019-06-26 17:52:00 KABQ 270052Z 13008KT 10SM SCT100 BKN150 BKN250 31/02 A3011 RMK AO2 SLP107 VIRGA W-N T03060017
KABQ 2019-06-26T23:52:00Z 30.11 87.1 14.0 NA 2019-06-26 16:52:00 KABQ 262352Z 10012KT 10SM SCT110 BKN160 BKN280 31/02 A3011 RMK AO2 WSHFT 2239 LTG DSNT S SLP110 VIRGA SE-SW 60000 T03060022 10344 20294 58001
KABQ 2019-06-26T22:52:00Z 30.12 84.9 17.0 28.0 2019-06-26 15:52:00 KABQ 262252Z 10015G24KT 10SM SCT110 BKN160 BKN280 29/04 A3012 RMK AO2 PK WND 19034/2216 WSHFT 2226 LTG DSNT SE-W RAB24E34 SLP107 VIRGA W CB DSNT E P0000 T02940039
KABQ 2019-06-26T21:52:00Z 30.12 86.0 13.0 52.0 2019-06-26 14:52:00 KABQ 262152Z 28011G45KT 240V360 9SM VCTS FEW047 FEW070 BKN100CB 30/01 A3012 RMK AO2 PK WND 26045/2143 LTG DSNT S AND SW SLP109 OCNL LTGCG VC S TS S MOV N T03000006
KABQ 2019-06-26T20:52:00Z 30.11 91.0 14.0 NA 2019-06-26 13:52:00 KABQ 262052Z 21012KT 10SM BKN140 BKN210 33/M01 A3011 RMK AO2 PK WND 17026/2029 SLP099 VIRGA DSNT SW-W T03281011 56016
KABQ 2019-06-26T19:52:00Z 30.13 91.9 16.0 22.0 2019-06-26 12:52:00 KABQ 261952Z 17014G19KT 10SM SCT140 SCT220 33/00 A3013 RMK AO2 SLP103 VIRGA DSNT W T03330000
KABQ 2019-06-26T18:52:00Z 30.15 89.1 6.0 17.0 2019-06-26 11:52:00 KABQ 261852Z 23005G15KT 10SM FEW150 FEW180 SCT220 32/02 A3015 RMK AO2 SLP110 T03170017
KABQ 2019-06-26T17:52:00Z 30.17 87.1 9.0 NA 2019-06-26 10:52:00 KABQ 261752Z 19008KT 10SM FEW140 FEW180 SCT220 31/02 A3017 RMK AO2 SLP117 T03060017 10306 20167 56008
KABQ 2019-06-26T16:52:00Z 30.18 82.0 10.0 NA 2019-06-26 09:52:00 KABQ 261652Z 24009KT 10SM FEW180 SCT220 28/03 A3018 RMK AO2 SLP126 T02780028
KABQ 2019-06-26T15:52:00Z 30.18 82.0 8.0 NA 2019-06-26 08:52:00 KABQ 261552Z 29007KT 10SM FEW180 SCT220 28/M02 A3018 RMK AO2 SLP126 T02781022
KABQ 2019-06-26T14:52:00Z 30.19 79.0 5.0 NA 2019-06-26 07:52:00 KABQ 261452Z 18004KT 10SM SCT210 26/M05 A3019 RMK AO2 SLP127 T02611050 51014
KABQ 2019-06-26T13:52:00Z 30.18 73.0 7.0 NA 2019-06-26 06:52:00 KABQ 261352Z 16006KT 10SM SCT210 23/M06 A3018 RMK AO2 SLP124 T02281061
KABQ 2019-06-26T12:52:00Z 30.16 66.9 6.0 NA 2019-06-26 05:52:00 KABQ 261252Z 15005KT 10SM FEW170 SCT210 19/M07 A3016 RMK AO2 SLP123 T01941067
KABQ 2019-06-26T11:52:00Z 30.14 62.1 10.0 NA 2019-06-26 04:52:00 KABQ 261152Z 11009KT 10SM BKN210 17/M06 A3014 RMK AO2 SLP121 T01671061 10256 20167 53014
KABQ 2019-06-26T10:52:00Z 30.12 70.0 0.0 NA 2019-06-26 03:52:00 KABQ 261052Z 00000KT 10SM FEW170 BKN220 21/M06 A3012 RMK AO2 SLP106 T02111061

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query