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-02-23T05:00:00Z 29.79 30.9 9.0 NA 2019-02-22 22:00:00 KABQ 230500Z 22008KT 1SM BR SCT001 BKN030 OVC060 M01/M01 A2979 RMK AO2 MTNS OBSC NE-SE T10061011
KABQ 2019-02-23T04:52:00Z 29.79 30.9 8.0 NA 2019-02-22 21:52:00 KABQ 230452Z 22007KT 2SM BR SCT001 BKN030 OVC055 M01/M01 A2979 RMK AO2 VIS 1 1/4V3 SNB36E46 SLP075 MTNS OBSC NE-SE P0000 T10061011
KABQ 2019-02-23T04:44:00Z 29.79 30.9 10.0 NA 2019-02-22 21:44:00 KABQ 230444Z 22009KT 1 3/4SM -SN BR FEW001 BKN042 OVC055 M01/M01 A2979 RMK AO2 VIS 1 1/4V4 SNB36 P0000 T10061011
KABQ 2019-02-23T03:52:00Z 29.74 30.9 5.0 NA 2019-02-22 20:52:00 KABQ 230352Z 04004KT 10SM FEW004 SCT030 OVC090 M01/M01 A2974 RMK AO2 SNE35 SLP064 MTN TOPS OBSC NE-SE P0000 T10061011
KABQ 2019-02-23T03:17:00Z 29.75 30.9 9.0 NA 2019-02-22 20:17:00 KABQ 230317Z 02008KT 5SM -SN BR FEW004 BKN030 OVC055 M01/M01 A2975 RMK AO2 MTNS OBSC NE-SE P0000 T10061011
KABQ 2019-02-23T03:02:00Z 29.76 30.9 13.0 NA 2019-02-22 20:02:00 KABQ 230302Z 02011KT 3SM -SN BR SCT004 BKN020 OVC050 M01/M01 A2976 RMK AO2 MTNS OBSC NE-SE P0000 T10061011
KABQ 2019-02-23T02:56:00Z 29.77 30.9 13.0 NA 2019-02-22 19:56:00 KABQ 230256Z 02011KT 2SM -SN BR SCT004 OVC014 M01/M01 A2977 RMK AO2 MTNS OBSC NE-SE P0000 T10061011
KABQ 2019-02-23T02:38:00Z 29.76 30.9 13.0 NA 2019-02-22 19:38:00 KABQ 230238Z 03011KT 1SM -SN BR FEW003 OVC009 M01/M01 A2976 RMK AO2 PRESFR MTNS OBSC NE-SE P0008 T10061011
KABQ 2019-02-23T01:52:00Z 29.79 30.9 9.0 NA 2019-02-22 18:52:00 KABQ 230152Z 03008KT 1/2SM SN FZFG VV005 M01/M01 A2979 RMK AO2 SLP094 MTNS OBSC NE-SE SNINCR 2/2 P0013 T10061006
KABQ 2019-02-23T01:26:00Z 29.77 32.0 9.0 NA 2019-02-22 18:26:00 KABQ 230126Z 02008KT 1/2SM SN FG VV005 00/M01 A2977 RMK AO2 PRESRR MTNS OBSC NE-SE P0007 T00001006
KABQ 2019-02-23T00:52:00Z 29.74 32.0 15.0 24.0 2019-02-22 17:52:00 KABQ 230052Z 33013G21KT 3/4SM -SN BR OVC003 00/M01 A2974 RMK AO2 SLP072 MTNS OBSC NE-SE P0010 T00001006
KABQ 2019-02-23T00:18:00Z 29.71 32.0 10.0 NA 2019-02-22 17:18:00 KABQ 230018Z 28009KT 1/2SM SN FG VV003 00/00 A2971 RMK AO2 MTNS OBSC NE-SE P0005 T00000000
KABQ 2019-02-22T23:56:00Z 29.71 32.0 17.0 NA 2019-02-22 16:56:00 KABQ 222356Z 27015KT 1/4SM +SN FG SCT004 OVC011 00/M01 A2971 RMK AO2 MTNS OBSC NE-SE P0001 T00001006
KABQ 2019-02-22T23:52:00Z 29.71 33.1 20.0 NA 2019-02-22 16:52:00 KABQ 222352Z 27017KT 1/2SM SN FG SCT004 BKN024 OVC050 01/M01 A2971 RMK AO2 PK WND 22027/2309 RAB30E38B40E48SNB38 SLP060 MTNS OBSC NE-SE P0003 60003 T00061006 10128 20006 53022
KABQ 2019-02-22T23:38:00Z 29.71 37.0 18.0 28.0 2019-02-22 16:38:00 KABQ 222338Z COR 25016G24KT 7SM -SN FEW009 BKN026 OVC055 03/00 A2971 RMK AO2 PK WND 22027/2309 RAB30E38SNB38 MTNS OBSC NE-SE P0000 T00280000
KABQ 2019-02-22T22:52:00Z 29.64 48.9 22.0 32.0 2019-02-22 15:52:00 KABQ 222252Z 20019G28KT 10SM BKN085 OVC110 09/M04 A2964 RMK AO2 PK WND 19038/2158 SLP014 VIRGA T00941044
KABQ 2019-02-22T21:52:00Z 29.63 52.0 32.0 46.0 2019-02-22 14:52:00 KABQ 222152Z 18028G40KT 10SM SCT080 BKN100 11/M06 A2963 RMK AO2 PK WND 19041/2140 SLP005 VIRGA T01111061
KABQ 2019-02-22T20:52:00Z 29.64 53.1 30.0 46.0 2019-02-22 13:52:00 KABQ 222052Z 20026G40KT 10SM SCT075 SCT090 12/M06 A2964 RMK AO2 PK WND 17043/2020 SLP007 BLDU ALQDS T01171061 58031
KABQ 2019-02-22T19:52:00Z 29.68 52.0 33.0 48.0 2019-02-22 12:52:00 KABQ 221952Z 19029G42KT 10SM BKN070 BKN085 11/M06 A2968 RMK AO2 PK WND 17044/1904 PRESFR SLP021 BLDU ALQDS T01111056
KABQ 2019-02-22T18:52:00Z 29.72 51.1 33.0 47.0 2019-02-22 11:52:00 KABQ 221852Z 18029G41KT 10SM BKN065 BKN075 11/M05 A2972 RMK AO2 PK WND 19041/1843 SLP036 BLDU ALQDS T01061050
KABQ 2019-02-22T17:52:00Z 29.74 48.0 32.0 43.0 2019-02-22 10:52:00 KABQ 221752Z 18028G37KT 10SM BKN060 09/M06 A2974 RMK AO2 PK WND 17041/1725 SLP044 T00891056 10094 20000 58008
KABQ 2019-02-22T16:52:00Z 29.75 48.0 31.0 48.0 2019-02-22 09:52:00 KABQ 221652Z 19027G42KT 10SM FEW050 09/M04 A2975 RMK AO2 PK WND 17042/1646 SLP047 T00891044
KABQ 2019-02-22T15:52:00Z 29.76 45.0 32.0 45.0 2019-02-22 08:52:00 KABQ 221552Z 19028G39KT 10SM FEW050 07/M03 A2976 RMK AO2 PK WND 19039/1548 SLP056 MTN TOPS OBSC NE T00721033
KABQ 2019-02-22T14:52:00Z 29.77 39.0 9.0 NA 2019-02-22 07:52:00 KABQ 221452Z 15008KT 10SM FEW040 FEW050 SCT120 04/M03 A2977 RMK AO2 SLP063 MTN TOPS OBSC NE AND SE T00391033 51004
KABQ 2019-02-22T13:52:00Z 29.76 33.1 5.0 NA 2019-02-22 06:52:00 KABQ 221352Z 13004KT 10SM FEW040 FEW050 SCT100 01/M07 A2976 RMK AO2 SLP067 MTN TOPS OBSC NE AND SE T00061067
KABQ 2019-02-22T12:52:00Z 29.77 37.0 14.0 NA 2019-02-22 05:52:00 KABQ 221252Z 17012KT 10SM FEW060 FEW110 03/M07 A2977 RMK AO2 SLP063 T00281067
KABQ 2019-02-22T11:52:00Z 29.76 37.0 18.0 NA 2019-02-22 04:52:00 KABQ 221152Z 17016KT 10SM FEW060 SCT110 03/M08 A2976 RMK AO2 SLP059 T00281078 10061 20028 53004
KABQ 2019-02-22T10:52:00Z 29.74 39.0 16.0 NA 2019-02-22 03:52:00 KABQ 221052Z 17014KT 10SM FEW060 FEW090 04/M07 A2974 RMK AO2 SLP051 T00391072
KABQ 2019-02-22T09:52:00Z 29.74 39.0 17.0 NA 2019-02-22 02:52:00 KABQ 220952Z 17015KT 10SM FEW050 FEW065 04/M08 A2974 RMK AO2 SLP049 MTN TOPS OBSC NE T00391078
KABQ 2019-02-22T08:52:00Z 29.74 39.0 18.0 NA 2019-02-22 01:52:00 KABQ 220852Z 17016KT 10SM FEW050 FEW075 04/M08 A2974 RMK AO2 SLP054 MTN TOPS OBSC NE T00391083 50001
KABQ 2019-02-22T07:52:00Z 29.75 39.9 20.0 NA 2019-02-22 00:52:00 KABQ 220752Z 17017KT 10SM FEW075 FEW110 04/M09 A2975 RMK AO2 SLP053 T00441094
KABQ 2019-02-22T06:52:00Z 29.75 41.0 17.0 NA 2019-02-21 23:52:00 KABQ 220652Z 16015KT 10SM BKN110 05/M11 A2975 RMK AO2 SLP057 T00501106 400891033
KABQ 2019-02-22T05:52:00Z 29.74 43.0 20.0 NA 2019-02-21 22:52:00 KABQ 220552Z 17017KT 10SM SCT110 06/M11 A2974 RMK AO2 SLP058 T00611111 10083 20056 51015

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query