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 2018-06-21T22:52:00Z 30.08 91.9 8.0 NA 2018-06-21 15:52:00 KABQ 212252Z 18007KT 10SM FEW090 FEW200 33/03 A3008 RMK AO2 SLP085 CB DSNT NE T03330028
KABQ 2018-06-21T21:52:00Z 30.1 93.9 5.0 NA 2018-06-21 14:52:00 KABQ 212152Z 02004KT 10SM FEW120 34/03 A3010 RMK AO2 SLP093 CB DSNT NE T03440033
KABQ 2018-06-21T20:52:00Z 30.13 93.0 7.0 NA 2018-06-21 13:52:00 KABQ 212052Z 06006KT 10SM FEW110 FEW150 34/02 A3013 RMK AO2 SLP101 FU FEW150 T03390022 58019
KABQ 2018-06-21T19:52:00Z 30.15 89.1 6.0 NA 2018-06-21 12:52:00 KABQ 211952Z VRB05KT 10SM FEW110 FEW150 32/03 A3015 RMK AO2 SLP114 FU FEW150 T03170033
KABQ 2018-06-21T18:52:00Z 30.17 88.0 0.0 NA 2018-06-21 11:52:00 KABQ 211852Z 00000KT 10SM FEW100 FEW150 31/01 A3017 RMK AO2 SLP118 FU FEW150 T03110011
KABQ 2018-06-21T17:52:00Z 30.19 84.9 0.0 NA 2018-06-21 10:52:00 KABQ 211752Z 00000KT 10SM FEW080 FEW100 29/08 A3019 RMK AO2 SLP124 FU FEW100 T02940078 10294 20200 57005
KABQ 2018-06-21T16:52:00Z 30.2 82.0 5.0 NA 2018-06-21 09:52:00 KABQ 211652Z 30004KT 10SM FEW070 28/11 A3020 RMK AO2 SLP126 T02780106
KABQ 2018-06-21T15:52:00Z 30.2 79.0 9.0 NA 2018-06-21 08:52:00 KABQ 211552Z 03008KT 10SM FEW030 26/11 A3020 RMK AO2 SLP128 T02610111
KABQ 2018-06-21T14:52:00Z 30.21 75.9 22.0 NA 2018-06-21 07:52:00 KABQ 211452Z 09019KT 10SM FEW025 24/14 A3021 RMK AO2 SLP131 T02440139 51016
KABQ 2018-06-21T13:52:00Z 30.19 73.0 18.0 29.0 2018-06-21 06:52:00 KABQ 211352Z 08016G25KT 10SM FEW020 23/14 A3019 RMK AO2 SLP124 MTN TOPS OBSC NE-SE T02280139
KABQ 2018-06-21T12:52:00Z 30.17 71.1 0.0 NA 2018-06-21 05:52:00 KABQ 211252Z 00000KT 10SM FEW020 22/10 A3017 RMK AO2 SLP119 MTN TOPS OBSC NE-SE T02170100
KABQ 2018-06-21T11:52:00Z 30.15 69.1 8.0 NA 2018-06-21 04:52:00 KABQ 211152Z 26007KT 10SM CLR 21/03 A3015 RMK AO2 SLP114 T02060033 10272 20206 53013
KABQ 2018-06-21T10:52:00Z 30.12 71.1 0.0 NA 2018-06-21 03:52:00 KABQ 211052Z 00000KT 10SM CLR 22/05 A3012 RMK AO2 SLP104 T02170050
KABQ 2018-06-21T09:52:00Z 30.12 72.0 3.0 NA 2018-06-21 02:52:00 KABQ 210952Z 30003KT 10SM CLR 22/07 A3012 RMK AO2 SLP101 T02220067
KABQ 2018-06-21T08:52:00Z 30.11 73.0 12.0 NA 2018-06-21 01:52:00 KABQ 210852Z 11010KT 10SM CLR 23/07 A3011 RMK AO2 SLP097 T02280072 51003
KABQ 2018-06-21T07:52:00Z 30.1 71.1 0.0 NA 2018-06-21 00:52:00 KABQ 210752Z 00000KT 10SM CLR 22/00 A3010 RMK AO2 SLP100 T02170000
KABQ 2018-06-21T06:52:00Z 30.1 77.0 7.0 NA 2018-06-20 23:52:00 KABQ 210652Z 26006KT 10SM CLR 25/M01 A3010 RMK AO2 SLP095 T02501011 403440167
KABQ 2018-06-21T05:52:00Z 30.1 81.0 10.0 NA 2018-06-20 22:52:00 KABQ 210552Z 34009KT 10SM CLR 27/M02 A3010 RMK AO2 SLP093 T02721022 10344 20272 51016
KABQ 2018-06-21T04:52:00Z 30.09 82.9 8.0 NA 2018-06-20 21:52:00 KABQ 210452Z 34007KT 10SM CLR 28/M02 A3009 RMK AO2 SLP089 T02831022
KABQ 2018-06-21T03:52:00Z 30.07 86.0 7.0 NA 2018-06-20 20:52:00 KABQ 210352Z 35006KT 10SM CLR 30/M03 A3007 RMK AO2 SLP084 T03001033
KABQ 2018-06-21T02:52:00Z 30.04 88.0 10.0 NA 2018-06-20 19:52:00 KABQ 210252Z 34009KT 10SM CLR 31/M03 A3004 RMK AO2 SLP076 T03111028 53007
KABQ 2018-06-21T01:52:00Z 30.03 91.9 13.0 NA 2018-06-20 18:52:00 KABQ 210152Z 33011KT 10SM CLR 33/M03 A3003 RMK AO2 SLP069 T03331028
KABQ 2018-06-21T00:52:00Z 30.02 93.0 7.0 NA 2018-06-20 17:52:00 KABQ 210052Z 30006KT 10SM CLR 34/M04 A3002 RMK AO2 SLP065 T03391044
KABQ 2018-06-20T23:52:00Z 30.02 93.0 6.0 NA 2018-06-20 16:52:00 KABQ 202352Z VRB05KT 10SM CLR 34/M03 A3002 RMK AO2 SLP073 T03391028 10339 20283 56019

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query