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 2020-05-28T21:52:00Z 30.14 88.0 3.0 NA 2020-05-28 14:52:00 KABQ 282152Z VRB03KT 10SM SCT110 SCT250 31/02 A3014 RMK AO2 SLP113 T03110017
KABQ 2020-05-28T20:52:00Z 30.16 87.1 5.0 NA 2020-05-28 13:52:00 KABQ 282052Z VRB04KT 10SM SCT110 SCT250 31/02 A3016 RMK AO2 SLP119 T03060022 58013
KABQ 2020-05-28T19:52:00Z 30.19 84.9 5.0 NA 2020-05-28 12:52:00 KABQ 281952Z VRB04KT 10SM SCT100 SCT250 29/02 A3019 RMK AO2 SLP129 CB DSNT NE T02940017
KABQ 2020-05-28T18:52:00Z 30.2 84.9 10.0 NA 2020-05-28 11:52:00 KABQ 281852Z 09009KT 10SM SCT090 SCT300 29/03 A3020 RMK AO2 SLP130 T02940028
KABQ 2020-05-28T17:52:00Z 30.21 82.0 12.0 NA 2020-05-28 10:52:00 KABQ 281752Z 11010KT 10SM FEW100 FEW300 28/03 A3021 RMK AO2 SLP137 T02780033 10278 20183 51001
KABQ 2020-05-28T16:52:00Z 30.21 80.1 8.0 16.0 2020-05-28 09:52:00 KABQ 281652Z 09007G14KT 10SM FEW100 FEW300 27/03 A3021 RMK AO2 SLP137 T02670033
KABQ 2020-05-28T15:52:00Z 30.21 75.0 3.0 NA 2020-05-28 08:52:00 KABQ 281552Z 06003KT 10SM FEW300 24/03 A3021 RMK AO2 SLP143 T02390028
KABQ 2020-05-28T14:52:00Z 30.2 73.0 9.0 NA 2020-05-28 07:52:00 KABQ 281452Z 03008KT 360V070 10SM FEW300 23/03 A3020 RMK AO2 SLP138 T02280028 51021
KABQ 2020-05-28T13:52:00Z 30.18 68.0 22.0 32.0 2020-05-28 06:52:00 KABQ 281352Z 08019G28KT 10SM FEW230 FEW270 20/03 A3018 RMK AO2 PK WND 09030/1326 SLP135 T02000028
KABQ 2020-05-28T12:52:00Z 30.16 66.0 29.0 36.0 2020-05-28 05:52:00 KABQ 281252Z 08025G31KT 10SM FEW160 FEW230 SCT270 19/02 A3016 RMK AO2 PK WND 08031/1252 SLP128 T01890022
KABQ 2020-05-28T11:52:00Z 30.13 66.0 25.0 32.0 2020-05-28 04:52:00 KABQ 281152Z 09022G28KT 10SM FEW160 FEW250 19/02 A3013 RMK AO2 PK WND 08028/1113 SLP115 T01890022 10244 20189 53013
KABQ 2020-05-28T10:52:00Z 30.12 66.9 26.0 33.0 2020-05-28 03:52:00 KABQ 281052Z 08023G29KT 10SM FEW130 FEW160 19/02 A3012 RMK AO2 PK WND 08031/1039 SLP109 T01940022
KABQ 2020-05-28T09:52:00Z 30.1 70.0 26.0 35.0 2020-05-28 02:52:00 KABQ 280952Z 09023G30KT 10SM FEW130 SCT160 21/02 A3010 RMK AO2 PK WND 09030/0949 SLP099 T02110022
KABQ 2020-05-28T08:52:00Z 30.09 72.0 23.0 33.0 2020-05-28 01:52:00 KABQ 280852Z 08020G29KT 10SM FEW090 FEW130 BKN180 22/03 A3009 RMK AO2 PK WND 08029/0847 SLP094 T02220028 53005
KABQ 2020-05-28T07:52:00Z 30.08 72.0 3.0 NA 2020-05-28 00:52:00 KABQ 280752Z 33003KT 10SM FEW100 BKN150 BKN210 22/02 A3008 RMK AO2 SLP092 T02220017
KABQ 2020-05-28T06:52:00Z 30.07 75.0 3.0 NA 2020-05-27 23:52:00 KABQ 280652Z 20003KT 10SM FEW100 SCT160 BKN210 24/02 A3007 RMK AO2 SLP089 T02390017 403170144
KABQ 2020-05-28T05:52:00Z 30.07 75.9 0.0 NA 2020-05-27 22:52:00 KABQ 280552Z 00000KT 10SM SCT110 SCT170 24/02 A3007 RMK AO2 SLP090 T02440017 10306 20239 51017
KABQ 2020-05-28T04:52:00Z 30.07 77.0 6.0 NA 2020-05-27 21:52:00 KABQ 280452Z 05005KT 10SM SCT120 SCT200 25/02 A3007 RMK AO2 SLP091 T02500017
KABQ 2020-05-28T03:52:00Z 30.05 79.0 16.0 NA 2020-05-27 20:52:00 KABQ 280352Z 07014KT 10SM SCT120 BKN200 26/01 A3005 RMK AO2 SLP088 T02610011
KABQ 2020-05-28T02:52:00Z 30.02 82.9 17.0 25.0 2020-05-27 19:52:00 KABQ 280252Z 08015G22KT 10SM SCT120 BKN250 28/M01 A3002 RMK AO2 PK WND 02032/0224 WSHFT 0220 SLP077 VIRGA ALQDS T02831006 53006
KABQ 2020-05-28T02:40:00Z 30.01 82.9 21.0 36.0 2020-05-27 19:40:00 KABQ 280240Z 06018G31KT 10SM SCT120 BKN250 28/00 A3001 RMK AO2 PK WND 02032/0224 WSHFT 0220 VIRGA ALQDS T02830000
KABQ 2020-05-28T01:52:00Z 30.01 84.0 6.0 NA 2020-05-27 18:52:00 KABQ 280152Z 36005KT 10SM SCT140 BKN250 29/M01 A3001 RMK AO2 SLP077 VIRGA SW SHRA DSNT NE T02891011
KABQ 2020-05-28T00:52:00Z 29.99 84.9 9.0 NA 2020-05-27 17:52:00 KABQ 280052Z 30008KT 10SM SCT160 SCT250 29/M01 A2999 RMK AO2 SLP072 VIRGA NE T02941011
KABQ 2020-05-27T23:52:00Z 30.0 87.1 7.0 NA 2020-05-27 16:52:00 KABQ 272352Z VRB06KT 10SM FEW080 SCT140 SCT250 31/M01 A3000 RMK AO2 SLP071 VIRGA W T03061011 10317 20267 56010
KABQ 2020-05-27T22:52:00Z 30.0 87.1 9.0 NA 2020-05-27 15:52:00 KABQ 272252Z 23008KT 10SM SCT140 BKN250 31/M02 A3000 RMK AO2 SLP074 T03061017

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query