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-04-18T15:52:00Z 30.24 51.1 9.0 NA 2019-04-18 08:52:00 KABQ 181552Z 01008KT 10SM FEW050 11/04 A3024 RMK AO2 SLP208 T01060044
KABQ 2019-04-18T14:52:00Z 30.23 46.9 9.0 NA 2019-04-18 07:52:00 KABQ 181452Z 36008KT 10SM SCT004 08/07 A3023 RMK AO2 SLP209 T00830067 53028
KABQ 2019-04-18T14:19:00Z 30.21 45.0 10.0 NA 2019-04-18 07:19:00 KABQ 181419Z 33009KT 10SM BKN004 07/06 A3021 RMK AO2 T00720056
KABQ 2019-04-18T13:52:00Z 30.19 45.0 6.0 NA 2019-04-18 06:52:00 KABQ 181352Z 02005KT 10SM FEW000 FEW002 07/06 A3019 RMK AO2 SLP197 PRFG FEW000 T00720056
KABQ 2019-04-18T12:52:00Z 30.16 43.0 3.0 NA 2019-04-18 05:52:00 KABQ 181252Z 34003KT 10SM BCFG FEW001 06/04 A3016 RMK AO2 SLP190 T00610044
KABQ 2019-04-18T11:52:00Z 30.13 43.0 5.0 NA 2019-04-18 04:52:00 KABQ 181152Z 33004KT 9SM BCFG FEW000 06/06 A3013 RMK AO2 SLP180 VIS E 2 1/2 SW-W 3/4 PRFG FEW000 70046 T00610056 10078 20056 53024
KABQ 2019-04-18T10:52:00Z 30.1 42.1 6.0 NA 2019-04-18 03:52:00 KABQ 181052Z 05005KT 8SM BCFG FEW000 FEW001 06/05 A3010 RMK AO2 SLP168 VIS N 2 1/2 W-NE 2 PRFG FEW000 T00560050 $
KABQ 2019-04-18T10:10:00Z 30.07 42.1 3.0 NA 2019-04-18 03:10:00 KABQ 181010Z 06003KT 6SM BCFG FEW000 SCT001 06/05 A3007 RMK AO2 VIS N-NE AND SW-W 1/4 T00560050 $
KABQ 2019-04-18T09:52:00Z 30.06 42.1 0.0 NA 2019-04-18 02:52:00 KABQ 180952Z 00000KT 1/16SM FG VV001 06/06 A3006 RMK AO2 SLP153 VIS S 1/4 T00560056 $
KABQ 2019-04-18T09:35:00Z 30.05 42.1 3.0 NA 2019-04-18 02:35:00 KABQ 180935Z COR 30003KT 1/8SM FG VV001 06/06 A3005 RMK AO2 T00560056 $
KABQ 2019-04-18T09:18:00Z 30.05 43.0 0.0 NA 2019-04-18 02:18:00 KABQ 180918Z 00000KT 3/4SM BR VV001 06/06 A3005 RMK AO2 T00610061 $
KABQ 2019-04-18T08:52:00Z 30.05 45.0 0.0 NA 2019-04-18 01:52:00 KABQ 180852Z 00000KT 10SM CLR 07/06 A3005 RMK AO2 SLP146 T00720056 58001 $
KABQ 2019-04-18T07:52:00Z 30.06 44.1 3.0 NA 2019-04-18 00:52:00 KABQ 180752Z 10003KT 10SM CLR 07/06 A3006 RMK AO2 SLP151 T00670061 $
KABQ 2019-04-18T06:52:00Z 30.06 45.0 8.0 NA 2019-04-17 23:52:00 KABQ 180652Z 12007KT 10SM FEW015 FEW030 SCT070 07/06 A3006 RMK AO2 SLP149 MTNS OBSC E T00720061 401500067 $
KABQ 2019-04-18T05:52:00Z 30.05 46.0 8.0 NA 2019-04-17 22:52:00 KABQ 180552Z 12007KT 10SM FEW009 FEW080 SCT120 08/07 A3005 RMK AO2 SLP145 60008 T00780067 10094 20072 51002 $
KABQ 2019-04-18T04:52:00Z 30.04 46.9 6.0 NA 2019-04-17 21:52:00 KABQ 180452Z 19005KT 10SM BCFG FEW004 SCT100 BKN200 08/07 A3004 RMK AO2 RAE03 SLP143 MTNS OBSC NE-SE P0000 T00830072 $
KABQ 2019-04-18T03:52:00Z 30.06 48.0 0.0 NA 2019-04-17 20:52:00 KABQ 180352Z 00000KT 10SM -RA VCFG FEW003 BKN060 OVC100 09/08 A3006 RMK AO2 RAB43 SLP151 VCFG N-NE MTNS OBSC NE-SE P0000 T00890078 $
KABQ 2019-04-18T03:41:00Z 30.07 48.0 6.0 NA 2019-04-17 20:41:00 KABQ 180341Z 07005KT 10SM VCFG FEW004 BKN080 BKN120 09/07 A3007 RMK AO2 VCFG NE MTNS OBSC NE-SE T00890072 $
KABQ 2019-04-18T02:52:00Z 30.05 48.0 5.0 NA 2019-04-17 19:52:00 KABQ 180252Z 30004KT 10SM FEW006 BKN055 BKN120 09/08 A3005 RMK AO2 RAE17 SLP148 MTNS OBSC NE-SE P0001 60008 T00890078 53027 $
KABQ 2019-04-18T01:52:00Z 29.98 48.0 15.0 NA 2019-04-17 18:52:00 KABQ 180152Z 12013KT 9SM RA FEW004 BKN050 BKN100 09/08 A2998 RMK AO2 SLP124 MTNS OBSC NE-SE P0002 T00890078 $
KABQ 2019-04-18T00:52:00Z 30.0 48.0 8.0 NA 2019-04-17 17:52:00 KABQ 180052Z 25007KT 10SM -RA FEW004 BKN045 OVC080 09/08 A3000 RMK AO2 PRESRR SLP135 MTNS OBSC NE AND SE P0005 T00890078 $
KABQ 2019-04-17T23:52:00Z 29.95 48.9 6.0 NA 2019-04-17 16:52:00 KABQ 172352Z 24005KT 10SM -RA FEW010 BKN045 OVC090 09/07 A2995 RMK AO2 TSE19 SLP112 CB DSNT NW MTNS OBSC NE AND SE P0009 60027 T00940072 10122 20094 51018 $
KABQ 2019-04-17T23:29:00Z 29.95 48.9 8.0 NA 2019-04-17 16:29:00 KABQ 172329Z 12007KT 4SM RA FEW008 BKN050 OVC120 09/07 A2995 RMK AO2 LTG DSNT W AND NW TSE19 CB DSNT NW MTNS OBSC NE AND SE P0007 T00940067 $
KABQ 2019-04-17T23:19:00Z 29.95 48.9 6.0 NA 2019-04-17 16:19:00 KABQ 172319Z 06005KT 9SM VCTS -RA FEW009 BKN046CB OVC120 09/06 A2995 RMK AO2 LTG DSNT W AND NW TSE19 OCNL LTGIC SW TS VC SW MOV S MTNS OBSC NE AND SE P0005 T00940061 $
KABQ 2019-04-17T23:11:00Z 29.95 48.9 5.0 NA 2019-04-17 16:11:00 KABQ 172311Z VRB04KT 3SM TSRA FEW009 BKN045CB OVC120 09/06 A2995 RMK AO2 LTG DSNT NW OCNL LTGIC SW TS SW MOV S MTNS OBSC NE AND SE P0004 T00940061 $
KABQ 2019-04-17T22:52:00Z 29.94 50.0 7.0 NA 2019-04-17 15:52:00 KABQ 172252Z 14006KT 4SM -TSRA FEW025 BKN045CB OVC120 10/07 A2994 RMK AO2 LTG DSNT NW TSB40 SLP107 OCNL LTGIC SW-W TS SW-W MOV S MTNS OBSC NE AND SE P0006 T01000072 $
KABQ 2019-04-17T22:40:00Z 29.94 50.0 12.0 NA 2019-04-17 15:40:00 KABQ 172240Z 13010KT 3SM TSRA FEW025 BKN048CB OVC120 10/07 A2994 RMK AO2 LTG DSNT NW TSB40 OCNL LTGIC S-W TS S-W MOV S MTNS OBSC NE AND SE P0005 T01000072 $
KABQ 2019-04-17T21:59:00Z 29.92 51.1 6.0 NA 2019-04-17 14:59:00 KABQ 172159Z 13005KT 10SM -RA FEW040 OVC060 11/06 A2992 RMK AO2 LTG DSNT W-N MTNS OBSC NE AND SE P0000 T01060061 $
KABQ 2019-04-17T21:52:00Z 29.92 51.1 6.0 NA 2019-04-17 14:52:00 KABQ 172152Z 13005KT 10SM VCTS -RA FEW040 SCT065CB OVC085 11/06 A2992 RMK AO2 LTG DSNT W-N RAB34 SLP098 OCNL LTGCG VC SW-NW TS SW-NW MOV SW MTN TOPS OBSC NE AND SE P0000 T01060061 $
KABQ 2019-04-17T21:34:00Z 29.91 51.1 3.0 NA 2019-04-17 14:34:00 KABQ 172134Z 18003KT 10SM VCTS -RA FEW060 SCT085CB OVC110 11/07 A2991 RMK AO2 LTG DSNT SW-N RAB34 OCNL LTGCG VC SW-NW TS SW-NW MOV SW MTN TOPS OBSC NE AND SE P0000 T01060067 $
KABQ 2019-04-17T20:52:00Z 29.89 51.1 7.0 NA 2019-04-17 13:52:00 KABQ 172052Z 13006KT 10SM FEW020 BKN090 BKN110 11/07 A2989 RMK AO2 LTG DSNT ALQDS RAB1957E34 TSB07E29 SLP077 MTN TOPS OBSC SE P0012 60012 T01060072 55001 $
KABQ 2019-04-17T20:49:00Z 29.89 51.8 10.0 NA 2019-04-17 13:49:00 KABQ 172049Z 11009KT 10SM FEW028 BKN090 BKN110 11/06 A2989 RMK AO2 LTG DSNT SW-N RAB1957E34 TSB07E29 MTN TOPS OBSC SE P0012 $
KABQ 2019-04-17T20:42:00Z 29.88 54.0 8.0 NA 2019-04-17 13:42:00 KABQ 172042Z 14007KT 10SM VCTS FEW020 BKN090CB BKN110 12/06 A2988 RMK AO2 LTG DSNT SW-N RAB1957E34 TSB07E29 OCNL LTGCG VC SW-NW MTN TOPS OBSC SE P0012 T01220056 $
KABQ 2019-04-17T20:30:00Z 29.87 52.0 8.0 NA 2019-04-17 13:30:00 KABQ 172030Z 20007KT 10SM -RA FEW020 BKN034 OVC110 11/06 A2987 RMK AO2 LTG DSNT SW-N RAB1957 TSB07E29 MTN TOPS OBSC SE P0012 T01110056 $
KABQ 2019-04-17T20:13:00Z 29.89 50.0 7.0 NA 2019-04-17 13:13:00 KABQ 172013Z 17006KT 4SM TSRA BKN036 OVC060CB 10/04 A2989 RMK AO2 LTG DSNT N AND NW RAB1957 TSB07 OCNL LTGCG OHD TS OHD MOV SW MTNS OBSC NE-SE P0009 T01000044 $
KABQ 2019-04-17T19:52:00Z 29.89 50.0 18.0 NA 2019-04-17 12:52:00 KABQ 171952Z 12016KT 10SM VCTS SCT040 BKN065CB OVC080 10/07 A2989 RMK AO2 LTG DSNT E AND NW SLP076 OCNL LTGCG VC NE TS NE MOV SW MTNS OBSC NE-SE T01000067 $
KABQ 2019-04-17T18:52:00Z 29.89 52.0 15.0 NA 2019-04-17 11:52:00 KABQ 171852Z 16013KT 10SM FEW020 FEW036 BKN075 11/06 A2989 RMK AO2 LTG DSNT NE SLP074 MTNS OBSC NE-SE T01110061
KABQ 2019-04-17T17:52:00Z 29.9 51.1 15.0 NA 2019-04-17 10:52:00 KABQ 171752Z 16013KT 10SM SCT017 SCT028 BKN032 11/07 A2990 RMK AO2 LTG DSNT E SLP076 MTNS OBSC NE-SE 60011 T01060067 10106 20067 57002
KABQ 2019-04-17T17:26:00Z 29.9 50.0 10.0 NA 2019-04-17 10:26:00 KABQ 171726Z 17009KT 10SM FEW017 BKN032 10/07 A2990 RMK AO2 MTNS OBSC NE-SE T01000067
KABQ 2019-04-17T16:52:00Z 29.9 48.9 7.0 NA 2019-04-17 09:52:00 KABQ 171652Z 22006KT 10SM FEW016 BKN021 BKN032 09/06 A2990 RMK AO2 SLP077 MTNS OBSC NE-SE T00940056

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query