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-11-20T17:52:00Z 30.18 48.0 3.0 NA 2017-11-20 10:52:00 KABQ 201752Z 24003KT 10SM FEW200 OVC250 09/M14 A3018 RMK AO2 SLP202 T00891144 10089 21028 56008
KABQ 2017-11-20T16:52:00Z 30.19 39.9 0.0 NA 2017-11-20 09:52:00 KABQ 201652Z 00000KT 10SM FEW200 BKN250 04/M13 A3019 RMK AO2 SLP216 T00441128
KABQ 2017-11-20T15:52:00Z 30.18 37.9 0.0 NA 2017-11-20 08:52:00 KABQ 201552Z 00000KT 10SM FEW200 BKN250 03/M13 A3018 RMK AO2 SLP217 T00331133
KABQ 2017-11-20T14:52:00Z 30.2 33.1 6.0 NA 2017-11-20 07:52:00 KABQ 201452Z 04005KT 10SM FEW035 FEW110 SCT200 OVC250 01/M14 A3020 RMK AO2 SLP227 FU FEW035 T00061139 53009
KABQ 2017-11-20T13:52:00Z 30.19 28.9 7.0 NA 2017-11-20 06:52:00 KABQ 201352Z 01006KT 10SM FEW090 SCT180 BKN240 M02/M13 A3019 RMK AO2 SLP229 T10171133
KABQ 2017-11-20T12:52:00Z 30.17 30.0 5.0 NA 2017-11-20 05:52:00 KABQ 201252Z 30004KT 10SM FEW100 FEW150 SCT220 M01/M14 A3017 RMK AO2 SLP210 T10111139
KABQ 2017-11-20T11:52:00Z 30.17 30.0 0.0 NA 2017-11-20 04:52:00 KABQ 201152Z 00000KT 10SM FEW100 FEW220 M01/M14 A3017 RMK AO2 SLP207 T10111139 10033 21022 50002
KABQ 2017-11-20T10:52:00Z 30.17 30.9 7.0 NA 2017-11-20 03:52:00 KABQ 201052Z 32006KT 10SM CLR M01/M15 A3017 RMK AO2 SLP204 T10061150
KABQ 2017-11-20T09:52:00Z 30.17 28.0 3.0 NA 2017-11-20 02:52:00 KABQ 200952Z 13003KT 10SM CLR M02/M16 A3017 RMK AO2 SLP209 T10221156
KABQ 2017-11-20T08:52:00Z 30.16 32.0 0.0 NA 2017-11-20 01:52:00 KABQ 200852Z 00000KT 10SM CLR 00/M15 A3016 RMK AO2 SLP204 T00001150 58007
KABQ 2017-11-20T07:52:00Z 30.18 34.0 6.0 NA 2017-11-20 00:52:00 KABQ 200752Z 02005KT 10SM CLR 01/M13 A3018 RMK AO2 SLP204 T00111133
KABQ 2017-11-20T06:52:00Z 30.18 36.0 6.0 NA 2017-11-19 23:52:00 KABQ 200652Z 28005KT 10SM CLR 02/M14 A3018 RMK AO2 SLP210 T00221144 401171017
KABQ 2017-11-20T05:52:00Z 30.19 37.9 0.0 NA 2017-11-19 22:52:00 KABQ 200552Z 00000KT 10SM CLR 03/M16 A3019 RMK AO2 SLP215 T00331156 10100 20022 52002
KABQ 2017-11-20T04:52:00Z 30.19 39.0 0.0 NA 2017-11-19 21:52:00 KABQ 200452Z 00000KT 10SM CLR 04/M16 A3019 RMK AO2 SLP217 T00391161
KABQ 2017-11-20T03:52:00Z 30.18 37.9 3.0 NA 2017-11-19 20:52:00 KABQ 200352Z 11003KT 10SM CLR 03/M17 A3018 RMK AO2 SLP223 T00331172
KABQ 2017-11-20T02:52:00Z 30.18 41.0 3.0 NA 2017-11-19 19:52:00 KABQ 200252Z 14003KT 10SM FEW250 05/M17 A3018 RMK AO2 SLP223 T00501172 53009
KABQ 2017-11-20T01:52:00Z 30.16 39.9 7.0 NA 2017-11-19 18:52:00 KABQ 200152Z 11006KT 10SM FEW210 SCT300 04/M18 A3016 RMK AO2 SLP218 T00441178
KABQ 2017-11-20T00:52:00Z 30.15 48.0 5.0 NA 2017-11-19 17:52:00 KABQ 200052Z 18004KT 10SM SCT210 BKN300 09/M16 A3015 RMK AO2 SLP205 T00891161
KABQ 2017-11-19T23:52:00Z 30.15 51.1 3.0 NA 2017-11-19 16:52:00 KABQ 192352Z 23003KT 10SM SCT210 BKN300 11/M17 A3015 RMK AO2 SLP199 T01061167 10117 20056 56018
KABQ 2017-11-19T22:52:00Z 30.17 52.0 0.0 NA 2017-11-19 15:52:00 KABQ 192252Z 00000KT 10SM FEW200 BKN300 11/M17 A3017 RMK AO2 SLP202 T01111172
KABQ 2017-11-19T21:52:00Z 30.19 52.0 0.0 NA 2017-11-19 14:52:00 KABQ 192152Z 00000KT 10SM FEW200 SCT300 11/M17 A3019 RMK AO2 SLP206 T01111172
KABQ 2017-11-19T20:52:00Z 30.22 50.0 0.0 NA 2017-11-19 13:52:00 KABQ 192052Z 00000KT 10SM FEW200 BKN300 10/M17 A3022 RMK AO2 SLP219 T01001172 57029
KABQ 2017-11-19T19:52:00Z 30.25 51.1 0.0 NA 2017-11-19 12:52:00 KABQ 191952Z 00000KT 10SM FEW200 BKN300 11/M13 A3025 RMK AO2 SLP227 T01061128
KABQ 2017-11-19T18:52:00Z 30.28 46.0 0.0 NA 2017-11-19 11:52:00 KABQ 191852Z 00000KT 10SM FEW200 BKN300 08/M13 A3028 RMK AO2 SLP245 T00781133

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query