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-10-16T21:52:00Z 30.21 71.1 0.0 NA 2019-10-16 14:52:00 KABQ 162152Z 00000KT 10SM FEW250 22/M09 A3021 RMK AO2 SLP169 T02171089
KABQ 2019-10-16T20:52:00Z 30.23 71.1 5.0 NA 2019-10-16 13:52:00 KABQ 162052Z 26004KT 10SM FEW250 22/M08 A3023 RMK AO2 SLP176 T02171083 58030
KABQ 2019-10-16T19:52:00Z 30.26 68.0 0.0 NA 2019-10-16 12:52:00 KABQ 161952Z 00000KT 10SM FEW250 20/M07 A3026 RMK AO2 SLP190 T02001072
KABQ 2019-10-16T18:52:00Z 30.3 64.0 3.0 NA 2019-10-16 11:52:00 KABQ 161852Z 22003KT 10SM FEW250 18/M06 A3030 RMK AO2 SLP206 T01781056
KABQ 2019-10-16T17:52:00Z 30.33 60.1 0.0 NA 2019-10-16 10:52:00 KABQ 161752Z 00000KT 10SM FEW200 16/M04 A3033 RMK AO2 SLP218 T01561039 10161 20078 58004
KABQ 2019-10-16T16:52:00Z 30.34 57.9 3.0 NA 2019-10-16 09:52:00 KABQ 161652Z 04003KT 10SM FEW200 14/M04 A3034 RMK AO2 SLP229 T01441039
KABQ 2019-10-16T15:52:00Z 30.35 55.0 0.0 NA 2019-10-16 08:52:00 KABQ 161552Z 00000KT 10SM CLR 13/M04 A3035 RMK AO2 SLP238 T01281044
KABQ 2019-10-16T14:52:00Z 30.34 50.0 6.0 NA 2019-10-16 07:52:00 KABQ 161452Z 01005KT 10SM CLR 10/M05 A3034 RMK AO2 SLP236 T01001050 53007
KABQ 2019-10-16T13:52:00Z 30.33 46.9 7.0 NA 2019-10-16 06:52:00 KABQ 161352Z 36006KT 10SM CLR 08/M05 A3033 RMK AO2 SLP223 T00831050
KABQ 2019-10-16T12:52:00Z 30.32 46.9 8.0 NA 2019-10-16 05:52:00 KABQ 161252Z 01007KT 10SM CLR 08/M05 A3032 RMK AO2 SLP220 T00831050
KABQ 2019-10-16T11:52:00Z 30.32 48.0 7.0 NA 2019-10-16 04:52:00 KABQ 161152Z 36006KT 10SM CLR 09/M05 A3032 RMK AO2 SLP212 T00891050 10150 20089 53005
KABQ 2019-10-16T10:52:00Z 30.32 48.9 8.0 NA 2019-10-16 03:52:00 KABQ 161052Z 35007KT 10SM CLR 09/M05 A3032 RMK AO2 SLP209 T00941050
KABQ 2019-10-16T09:52:00Z 30.31 54.0 17.0 28.0 2019-10-16 02:52:00 KABQ 160952Z 07015G24KT 10SM CLR 12/M04 A3031 RMK AO2 SLP202 T01221039
KABQ 2019-10-16T08:52:00Z 30.3 55.0 16.0 26.0 2019-10-16 01:52:00 KABQ 160852Z 08014G23KT 10SM CLR 13/M04 A3030 RMK AO2 SLP201 T01281039 53012
KABQ 2019-10-16T07:52:00Z 30.29 55.9 9.0 20.0 2019-10-16 00:52:00 KABQ 160752Z 03008G17KT 10SM CLR 13/M07 A3029 RMK AO2 SLP197 T01331067
KABQ 2019-10-16T06:52:00Z 30.27 57.9 15.0 NA 2019-10-15 23:52:00 KABQ 160652Z 06013KT 10SM CLR 14/M05 A3027 RMK AO2 SLP189 T01441050 402390100
KABQ 2019-10-16T05:52:00Z 30.26 59.0 14.0 NA 2019-10-15 22:52:00 KABQ 160552Z 08012KT 10SM CLR 15/M07 A3026 RMK AO2 SLP189 T01501072 10228 20117 51014
KABQ 2019-10-16T04:52:00Z 30.25 55.0 6.0 NA 2019-10-15 21:52:00 KABQ 160452Z 08005KT 10SM CLR 13/M10 A3025 RMK AO2 SLP193 T01281100
KABQ 2019-10-16T03:52:00Z 30.23 53.1 0.0 NA 2019-10-15 20:52:00 KABQ 160352Z 00000KT 10SM CLR 12/M09 A3023 RMK AO2 SLP193 T01171094
KABQ 2019-10-16T02:52:00Z 30.22 57.0 7.0 NA 2019-10-15 19:52:00 KABQ 160252Z 12006KT 10SM CLR 14/M10 A3022 RMK AO2 SLP189 T01391100 51017
KABQ 2019-10-16T01:52:00Z 30.2 66.0 6.0 NA 2019-10-15 18:52:00 KABQ 160152Z 34005KT 10SM CLR 19/M13 A3020 RMK AO2 SLP176 T01891128
KABQ 2019-10-16T00:52:00Z 30.18 69.1 3.0 NA 2019-10-15 17:52:00 KABQ 160052Z 33003KT 10SM CLR 21/M12 A3018 RMK AO2 SLP166 T02061122
KABQ 2019-10-15T23:52:00Z 30.16 73.0 6.0 NA 2019-10-15 16:52:00 KABQ 152352Z 30005KT 10SM CLR 23/M13 A3016 RMK AO2 SLP152 T02281128 10239 20194 55001
KABQ 2019-10-15T22:52:00Z 30.16 75.0 6.0 NA 2019-10-15 15:52:00 KABQ 152252Z 03005KT 10SM FEW120 24/M13 A3016 RMK AO2 SLP147 T02391128

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query