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-07-23T09:52:00Z 30.18 71.1 9.0 NA 2017-07-23 02:52:00 KABQ 230952Z 06008KT 10SM FEW065 FEW120 SCT220 22/12 A3018 RMK AO2 SLP123 T02170117
KABQ 2017-07-23T08:52:00Z 30.19 69.1 6.0 NA 2017-07-23 01:52:00 KABQ 230852Z 08005KT 10SM FEW060 SCT120 BKN220 21/13 A3019 RMK AO2 SLP130 T02060133 58014
KABQ 2017-07-23T07:52:00Z 30.21 70.0 3.0 NA 2017-07-23 00:52:00 KABQ 230752Z 09003KT 10SM FEW050 BKN120 OVC220 21/13 A3021 RMK AO2 SLP139 T02110133
KABQ 2017-07-23T06:52:00Z 30.24 70.0 9.0 NA 2017-07-22 23:52:00 KABQ 230652Z 14008KT 10SM FEW090 BKN120 OVC220 21/16 A3024 RMK AO2 SLP150 T02110156 403440194
KABQ 2017-07-23T05:52:00Z 30.24 72.0 15.0 NA 2017-07-22 22:52:00 KABQ 230552Z 15013KT 10SM BKN090 BKN150 OVC250 22/15 A3024 RMK AO2 SLP150 60032 T02220150 10344 20206 53021
KABQ 2017-07-23T04:52:00Z 30.22 69.1 6.0 NA 2017-07-22 21:52:00 KABQ 230452Z 17005KT 10SM BKN110 BKN150 BKN250 21/16 A3022 RMK AO2 SLP152 CB DSNT SE T02060161
KABQ 2017-07-23T03:52:00Z 30.18 71.1 13.0 NA 2017-07-22 20:52:00 KABQ 230352Z 16011KT 10SM SCT120 BKN150 BKN250 22/16 A3018 RMK AO2 RAE43 SLP140 CB DSNT SE VCSH SW P0000 T02170156
KABQ 2017-07-23T02:52:00Z 30.16 72.0 13.0 NA 2017-07-22 19:52:00 KABQ 230252Z 12011KT 10SM -RA FEW055 BKN100 BKN120 BKN250 22/18 A3016 RMK AO2 LTG DSNT E TSE14 PRESRR SLP137 CB DSNT SE P0004 60032 T02220178 53041
KABQ 2017-07-23T02:44:00Z 30.15 75.0 5.0 NA 2017-07-22 19:44:00 KABQ 230244Z 16004KT 10SM -RA FEW055 BKN100 BKN120 BKN250 24/16 A3015 RMK AO2 LTG DSNT E AND SW TSE14 PRESRR P0003 T02390156
KABQ 2017-07-23T02:32:00Z 30.12 73.0 8.0 NA 2017-07-22 19:32:00 KABQ 230232Z 22007KT 10SM VCTS -RA FEW055CB BKN110 BKN120 BKN250 23/18 A3012 RMK AO2 LTG DSNT E TSE14 OCNL LTGICCG VC E TS E MOV SW P0003 T02280178
KABQ 2017-07-23T02:18:00Z 30.11 73.9 10.0 NA 2017-07-22 19:18:00 KABQ 230218Z 28009KT 10SM -RA FEW035CB BKN100CB BKN120 BKN250 23/17 A3011 RMK AO2 LTG DSNT E TSE14 OCNL LTGICCG VC E TS E MOV W CB DSNT SW P0003 T02330172
KABQ 2017-07-23T01:52:00Z 30.12 71.1 7.0 NA 2017-07-22 18:52:00 KABQ 230152Z 13006KT 3SM TSRA BKN035CB BKN090CB BKN120 BKN250 22/18 A3012 RMK AO2 LTG DSNT ALQDS RAB33 TSB41 SLP124 FRQ LTGICCG OHD-N-NE TS OHD-N-NE MOV W MTNS OBSC NE P0028 T02170178
KABQ 2017-07-23T01:41:00Z 30.1 73.0 21.0 NA 2017-07-22 18:41:00 KABQ 230141Z COR 13018KT 4SM +TSRA BKN095CB BKN120 BKN250 23/17 A3010 RMK AO2 LTG DSNT NE AND SW RAB33 TSB41 PRESRR OCNL LTGICCG NE TS NE MOV SW MTNS OBSC NE P0004 T02280172
KABQ 2017-07-23T00:52:00Z 30.05 86.0 23.0 NA 2017-07-22 17:52:00 KABQ 230052Z 16020KT 10SM FEW070 BKN120 BKN250 30/11 A3005 RMK AO2 PK WND 18030/0036 WSHFT 0027 LTG DSNT S SLP086 CB DSNT E AND SW VCSH E-SE MTNS OBSC SE T03000106
KABQ 2017-07-23T00:42:00Z 30.05 87.1 24.0 35.0 2017-07-22 17:42:00 KABQ 230042Z 18021G30KT 10SM FEW070 BKN110 BKN250 31/12 A3005 RMK AO2 PK WND 18030/0036 WSHFT 0027 LTG DSNT S AND SW CB DSNT SE-SW SHRA DSNT E-S MTNS OBSC SE T03060117
KABQ 2017-07-22T23:52:00Z 30.03 93.0 7.0 NA 2017-07-22 16:52:00 KABQ 222352Z 31006KT 10SM FEW070 FEW120 SCT250 34/07 A3003 RMK AO2 LTG DSNT S SLP069 CB DSNT SE-S SHRA DSNT SE-S T03390067 10344 20278 56018
KABQ 2017-07-22T22:52:00Z 30.04 91.9 6.0 NA 2017-07-22 15:52:00 KABQ 222252Z VRB05KT 10SM SCT090 SCT250 33/08 A3004 RMK AO2 SLP075 CB DSNT SE AND S T03330078
KABQ 2017-07-22T21:52:00Z 30.06 91.9 7.0 NA 2017-07-22 14:52:00 KABQ 222152Z VRB06KT 10SM SCT110 BKN250 33/09 A3006 RMK AO2 SLP081 CB DSNT N AND SE T03330089
KABQ 2017-07-22T20:52:00Z 30.09 89.1 6.0 NA 2017-07-22 13:52:00 KABQ 222052Z VRB05KT 10SM SCT080 BKN250 32/11 A3009 RMK AO2 SLP090 VIRGA CB DSNT NE AND S T03170106 58026
KABQ 2017-07-22T19:52:00Z 30.12 88.0 0.0 NA 2017-07-22 12:52:00 KABQ 221952Z 00000KT 10SM SCT075 SCT250 31/12 A3012 RMK AO2 SLP103 CB DSNT NE AND S SHRA DSNT S T03110117
KABQ 2017-07-22T18:52:00Z 30.15 86.0 5.0 NA 2017-07-22 11:52:00 KABQ 221852Z VRB04KT 10SM FEW070 SCT250 30/13 A3015 RMK AO2 SLP113 CB DSNT N AND SW T03000128
KABQ 2017-07-22T17:52:00Z 30.18 82.9 7.0 NA 2017-07-22 10:52:00 KABQ 221752Z 25006KT 10SM FEW055 28/14 A3018 RMK AO2 SLP126 T02830144 10283 20194 58009
KABQ 2017-07-22T16:52:00Z 30.2 79.0 5.0 NA 2017-07-22 09:52:00 KABQ 221652Z VRB04KT 10SM FEW045 26/14 A3020 RMK AO2 SLP132 T02610144
KABQ 2017-07-22T15:52:00Z 30.2 75.0 5.0 NA 2017-07-22 08:52:00 KABQ 221552Z 25004KT 10SM FEW045 FEW110 24/14 A3020 RMK AO2 SLP137 T02390144
KABQ 2017-07-22T14:52:00Z 30.21 72.0 6.0 NA 2017-07-22 07:52:00 KABQ 221452Z 19005KT 10SM FEW110 22/15 A3021 RMK AO2 SLP141 T02220150 51012
KABQ 2017-07-22T13:52:00Z 30.2 70.0 7.0 NA 2017-07-22 06:52:00 KABQ 221352Z 18006KT 10SM SCT110 21/14 A3020 RMK AO2 SLP138 T02110144
KABQ 2017-07-22T12:52:00Z 30.18 66.9 6.0 NA 2017-07-22 05:52:00 KABQ 221252Z 12005KT 10SM FEW095 FEW170 19/14 A3018 RMK AO2 SLP132 T01940144
KABQ 2017-07-22T11:52:00Z 30.17 68.0 5.0 NA 2017-07-22 04:52:00 KABQ 221152Z 16004KT 10SM FEW095 FEW170 20/14 A3017 RMK AO2 SLP125 T02000144 10239 20194 53002
KABQ 2017-07-22T10:52:00Z 30.16 66.9 3.0 NA 2017-07-22 03:52:00 KABQ 221052Z 14003KT 10SM FEW080 SCT095 SCT170 19/14 A3016 RMK AO2 SLP122 T01940139

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query