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-04-03T10:52:00Z 29.97 48.9 5.0 NA 2020-04-03 03:52:00 KABQ 031052Z 24004KT 10SM CLR 09/M07 A2997 RMK AO2 SLP090 T00941067
KABQ 2020-04-03T09:52:00Z 29.96 48.0 7.0 NA 2020-04-03 02:52:00 KABQ 030952Z 20006KT 10SM CLR 09/M08 A2996 RMK AO2 SLP086 T00891078
KABQ 2020-04-03T08:52:00Z 29.96 48.9 5.0 NA 2020-04-03 01:52:00 KABQ 030852Z 16004KT 10SM CLR 09/M08 A2996 RMK AO2 SLP088 T00941078 51006
KABQ 2020-04-03T07:52:00Z 29.96 53.1 9.0 NA 2020-04-03 00:52:00 KABQ 030752Z 22008KT 10SM CLR 12/M08 A2996 RMK AO2 SLP085 T01171083
KABQ 2020-04-03T06:52:00Z 29.96 54.0 10.0 NA 2020-04-02 23:52:00 KABQ 030652Z 24009KT 10SM CLR 12/M08 A2996 RMK AO2 SLP084 T01221083 402390067
KABQ 2020-04-03T05:52:00Z 29.94 57.0 13.0 NA 2020-04-02 22:52:00 KABQ 030552Z 25011KT 10SM CLR 14/M09 A2994 RMK AO2 SLP079 T01391089 10222 20139 51022
KABQ 2020-04-03T04:52:00Z 29.92 59.0 16.0 NA 2020-04-02 21:52:00 KABQ 030452Z 26014KT 10SM CLR 15/M09 A2992 RMK AO2 SLP074 T01501094
KABQ 2020-04-03T03:52:00Z 29.9 60.1 15.0 NA 2020-04-02 20:52:00 KABQ 030352Z 27013KT 10SM FEW180 16/M10 A2990 RMK AO2 SLP069 T01561100
KABQ 2020-04-03T02:52:00Z 29.87 63.0 17.0 NA 2020-04-02 19:52:00 KABQ 030252Z 28015KT 10SM FEW140 FEW180 17/M11 A2987 RMK AO2 PK WND 28029/0200 SLP059 T01721106 53025
KABQ 2020-04-03T01:52:00Z 29.82 66.0 23.0 32.0 2020-04-02 18:52:00 KABQ 030152Z 28020G28KT 10SM FEW140 19/M09 A2982 RMK AO2 PK WND 28032/0113 SLP044 T01891094
KABQ 2020-04-03T00:52:00Z 29.8 69.1 24.0 35.0 2020-04-02 17:52:00 KABQ 030052Z 28021G30KT 10SM SCT120 21/M12 A2980 RMK AO2 PK WND 28033/0030 SLP038 T02061117
KABQ 2020-04-02T23:52:00Z 29.78 72.0 23.0 36.0 2020-04-02 16:52:00 KABQ 022352Z 28020G31KT 10SM SCT120 22/M12 A2978 RMK AO2 PK WND 29031/2340 SLP025 T02221117 10239 20189 55003
KABQ 2020-04-02T22:52:00Z 29.78 73.9 20.0 35.0 2020-04-02 15:52:00 KABQ 022252Z 27017G30KT 10SM SCT110 BKN140 23/M11 A2978 RMK AO2 PK WND 25032/2201 SLP021 T02331111
KABQ 2020-04-02T21:52:00Z 29.78 73.9 28.0 37.0 2020-04-02 14:52:00 KABQ 022152Z 25024G32KT 10SM SCT110 23/M11 A2978 RMK AO2 PK WND 25037/2137 SLP017 T02331111
KABQ 2020-04-02T20:52:00Z 29.8 72.0 16.0 29.0 2020-04-02 13:52:00 KABQ 022052Z 23014G25KT 210V280 10SM SCT110 22/M09 A2980 RMK AO2 PK WND 27033/1954 SLP027 T02221089 56030
KABQ 2020-04-02T19:52:00Z 29.83 72.0 20.0 32.0 2020-04-02 12:52:00 KABQ 021952Z 26017G28KT 10SM FEW110 22/M09 A2983 RMK AO2 PK WND 24033/1937 SLP034 T02221089
KABQ 2020-04-02T18:52:00Z 29.86 69.1 9.0 24.0 2020-04-02 11:52:00 KABQ 021852Z 27008G21KT 10SM FEW070 21/M07 A2986 RMK AO2 PK WND 27027/1828 SLP046 T02061067
KABQ 2020-04-02T17:52:00Z 29.9 66.0 16.0 25.0 2020-04-02 10:52:00 KABQ 021752Z 27014G22KT 10SM FEW070 19/M06 A2990 RMK AO2 SLP062 T01891061 10189 20067 58007
KABQ 2020-04-02T16:52:00Z 29.92 63.0 18.0 28.0 2020-04-02 09:52:00 KABQ 021652Z 25016G24KT 10SM FEW050 17/M06 A2992 RMK AO2 SLP071 T01721061
KABQ 2020-04-02T15:52:00Z 29.93 59.0 14.0 NA 2020-04-02 08:52:00 KABQ 021552Z 24012KT 10SM CLR 15/M05 A2993 RMK AO2 SLP079 T01501050
KABQ 2020-04-02T14:52:00Z 29.92 54.0 6.0 NA 2020-04-02 07:52:00 KABQ 021452Z 20005KT 10SM CLR 12/M06 A2992 RMK AO2 SLP080 T01221061 50010
KABQ 2020-04-02T13:52:00Z 29.92 50.0 6.0 NA 2020-04-02 06:52:00 KABQ 021352Z 14005KT 10SM CLR 10/M07 A2992 RMK AO2 SLP081 T01001072
KABQ 2020-04-02T12:52:00Z 29.9 46.9 6.0 NA 2020-04-02 05:52:00 KABQ 021252Z 13005KT 10SM CLR 08/M07 A2990 RMK AO2 SLP070 T00831072
KABQ 2020-04-02T11:52:00Z 29.89 50.0 0.0 NA 2020-04-02 04:52:00 KABQ 021152Z 00000KT 10SM SCT180 10/M07 A2989 RMK AO2 SLP062 T01001072 10150 20094 53003

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query