NOTE: This page is experimental. Bug reports to 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-10-23T22:59:00Z 30.19 52.0 8.0 NA 2018-10-23 15:59:00 KABQ 232259Z 01007KT 9SM -RA SCT020 BKN045 OVC065 11/09 A3019 RMK AO2 MTNS OBSC NE-SE P0001 T01110094 $
KABQ 2018-10-23T22:52:00Z 30.19 52.0 7.0 NA 2018-10-23 15:52:00 KABQ 232252Z 02006KT 6SM -RA BR FEW012 BKN020 OVC055 11/10 A3019 RMK AO2 SLP180 MTNS OBSC NE-SE P0010 T01110100 $
KABQ 2018-10-23T22:31:00Z 30.2 52.0 5.0 NA 2018-10-23 15:31:00 KABQ 232231Z 03004KT 7SM -RA BKN020 OVC055 11/09 A3020 RMK AO2 MTNS OBSC NE-SE P0007 T01110094 $
KABQ 2018-10-23T21:52:00Z 30.2 52.0 3.0 NA 2018-10-23 14:52:00 KABQ 232152Z 30003KT 3SM -RA BR FEW022 BKN030 OVC060 11/10 A3020 RMK AO2 SLP184 MTNS OBSC NE-SE P0017 T01110100 $
KABQ 2018-10-23T21:13:00Z 30.19 53.1 9.0 NA 2018-10-23 14:13:00 KABQ 232113Z 25008KT 2 1/2SM -RA BR FEW018 BKN028 OVC048 12/10 A3019 RMK AO2 LTG DSNT E AND NW MTNS OBSC NE-SE P0006 T01170100 $
KABQ 2018-10-23T20:52:00Z 30.18 54.0 10.0 NA 2018-10-23 13:52:00 KABQ 232052Z COR 27009KT 6SM VCTS -RA BR BKN018 BKN025 OVC036CB 12/10 A3018 RMK AO2 WSHFT 2016 LTG DSNT NW RAE00B23 SLP171 OCNL LTGCG VC NW TS NW MOV N MTNS OBSC NE-SE P0008 60008 T01220100 55010
KABQ 2018-10-23T20:36:00Z 30.17 55.9 20.0 NA 2018-10-23 13:36:00 KABQ 232036Z 22017KT 4SM -RA BR FEW020 BKN025 OVC039 13/11 A3017 RMK AO2 WSHFT 2016 LTG DSNT W RAE00B23 MTNS OBSC NE-SE P0000 T01330111
KABQ 2018-10-23T19:52:00Z 30.16 62.1 10.0 NA 2018-10-23 12:52:00 KABQ 231952Z 11009KT 10SM -RA FEW036 BKN043 OVC055 17/10 A3016 RMK AO2 LTG DSNT E AND SE RAB45 SLP159 MTN TOPS OBSC NE AND SE P0000 T01670100
KABQ 2018-10-23T18:52:00Z 30.19 62.1 14.0 NA 2018-10-23 11:52:00 KABQ 231852Z 09012KT 10SM SCT037 BKN065 OVC220 17/09 A3019 RMK AO2 SLP168 TSE19 MTN TOPS OBSC NE AND SE T01670094
KABQ 2018-10-23T17:52:00Z 30.21 61.0 18.0 NA 2018-10-23 10:52:00 KABQ 231752Z 07016KT 10SM BKN038 BKN048 BKN055 OVC200 16/09 A3021 RMK AO2 WSHFT 1731 LTG DSNT W SLP178 TSE19 MTN TOPS OBSC NE-SE 60018 T01610094 10167 20100 56010
KABQ 2018-10-23T16:52:00Z 30.24 57.9 10.0 NA 2018-10-23 09:52:00 KABQ 231652Z 01009KT 10SM FEW030 BKN055 OVC170 14/10 A3024 RMK AO2 SLP190 TSE19 MTN TOPS OBSC NE-SE T01440100
KABQ 2018-10-23T15:52:00Z 30.24 55.0 15.0 NA 2018-10-23 08:52:00 KABQ 231552Z 01013KT 10SM FEW030 FEW050 BKN075 OVC220 13/10 A3024 RMK AO2 LTG DSNT NE SLP190 TSE19 MTN TOPS OBSC NE-SE T01280100
KABQ 2018-10-23T14:52:00Z 30.24 53.1 10.0 NA 2018-10-23 07:52:00 KABQ 231452Z 36009KT 10SM SCT033 SCT070 BKN100 BKN130 12/10 A3024 RMK AO2 LTG DSNT NE SLP194 TSE19 VIRGA MTNS OBSC SE SHRA DSNT E 60018 T01170100 51014
KABQ 2018-10-23T14:16:00Z 30.21 54.0 7.0 NA 2018-10-23 07:16:00 KABQ 231416Z 35006KT 10SM FEW030 FEW055 BKN095 12/09 A3021 RMK AO2 TSE19 MTNS OBSC SE VCSH SE SHRA DSNT E T01220089
KABQ 2018-10-23T13:52:00Z 30.21 52.0 8.0 NA 2018-10-23 06:52:00 KABQ 231352Z 32007KT 10SM FEW001 SCT030 BKN050 11/10 A3021 RMK AO2 LTG DSNT NE AND E RAE27 TSE01 SLP182 TSE19 MTNS OBSC NE-SE VCSH NW-NE SHRA DSNT SE AND SW-W P0008 T01110100
KABQ 2018-10-23T13:20:00Z 30.21 51.8 9.0 NA 2018-10-23 06:20:00 KABQ 231320Z 02008KT 10SM -RA FEW001 FEW040 BKN065CB 11/09 A3021 RMK AO2 LTG DSNT N-E TSE01 VIS NE-E 2 1/2 CB DSNT N-E AND W
KABQ 2018-10-23T13:01:00Z 30.22 50.0 16.0 NA 2018-10-23 06:01:00 KABQ 231301Z 08014KT 4SM VCTS +RA BR FEW004 SCT040 BKN070CB 10/09 A3022 RMK AO2 LTG DSNT ALQDS TSE01 PRESFR ONCL LTGICCC VC NE-SE TS VC NE-SE MOV NE CB DSNT ALQDS MTNS OBSC NE-SE P0005 T01000094
KABQ 2018-10-23T12:52:00Z 30.25 50.0 12.0 NA 2018-10-23 05:52:00 KABQ 231252Z 12010KT 4SM +TSRA BR FEW040 BKN070CB OVC180 10/09 A3025 RMK AO2 WSHFT 1153 LTG DSNT N-SE RAB11 TSB14 SLP194 ONCL LTGICCC NE-OHD-SE TS NE-OHD-SE MOV NE CB DSNT ALQDS MTNS OBSC NE-SE P0010 T01000094
KABQ 2018-10-23T12:14:00Z 30.22 54.0 18.0 29.0 2018-10-23 05:14:00 KABQ 231214Z 21016G25KT 9SM -TSRA FEW040 BKN070CB OVC180 12/09 A3022 RMK AO2 WSHFT 1153 LTG DSNT SE AND S AND NW RAB11 TSB14 OCNL LTGCGICCC E-OHD-S TS E-OHD-S MOV NE CB DSNT E-S-W-NW MTN TOPS OBSC NE-SE P0001 T01220094
KABQ 2018-10-23T12:03:00Z 30.22 55.9 16.0 23.0 2018-10-23 05:03:00 KABQ 231203Z 19014G20KT 10SM VCTS FEW040 BKN070CB OVC180 13/08 A3022 RMK AO2 WSHFT 1147 LTG DSNT ALQDS CONS LTGCGICCC VC SE-SW-NW TS VC SE-SW-NW MOV NE CB DSNT S-W-NW MTN TOPS OBSC NE AND SE T01330083
KABQ 2018-10-23T11:52:00Z 30.19 57.9 13.0 NA 2018-10-23 04:52:00 KABQ 231152Z 10011KT 10SM VCTS FEW040 BKN070CB OVC180 14/09 A3019 RMK AO2 LTG DSNT S-NW SLP164 TSB19 FRQ LTGCGICCC VC SW-W TS VC SW-W MOV NE CB DSNT S-W-NW MTN TOPS OBSC NE AND SE T01440089 10150 20133 55003
KABQ 2018-10-23T11:20:00Z 30.18 57.9 16.0 NA 2018-10-23 04:20:00 KABQ 231120Z COR 09014KT 10SM VCTS FEW040 SCT070 BKN180 OVC210 14/09 A3018 RMK AO2 TSB19 LTG DSNT S-W FRQ LTGIC VC SW CONS LTGIC DSNT S-W TS VC SW MOV NE CB DSNT S-W MTN TOPS OBSC NE AND SE T01440089
KABQ 2018-10-23T10:52:00Z 30.18 57.9 14.0 NA 2018-10-23 03:52:00 KABQ 231052Z 09012KT 10SM FEW040 BKN070 BKN190 14/09 A3018 RMK AO2 SLP162 CONS LTGIC DSNT S-W CB DSNT S-W MTN TOPS OBSC NE AND SE T01440089
KABQ 2018-10-23T09:52:00Z 30.19 57.9 14.0 NA 2018-10-23 02:52:00 KABQ 230952Z 09012KT 10SM FEW040 SCT065 BKN090 BKN210 14/09 A3019 RMK AO2 SLP161 MTN TOPS OBSC NE AND SE T01440089
KABQ 2018-10-23T08:52:00Z 30.2 59.0 15.0 NA 2018-10-23 01:52:00 KABQ 230852Z 08013KT 10SM FEW050 FEW065 SCT100 SCT210 15/09 A3020 RMK AO2 SLP163 MTNS OBSC NE T01500089 53004
KABQ 2018-10-23T07:52:00Z 30.19 57.9 13.0 NA 2018-10-23 00:52:00 KABQ 230752Z 08011KT 10SM FEW050 BKN100 BKN170 OVC230 14/08 A3019 RMK AO2 SLP166 MTNS OBSC NE T01440083
KABQ 2018-10-23T06:52:00Z 30.19 57.9 9.0 NA 2018-10-22 23:52:00 KABQ 230652Z 11008KT 10SM FEW050 FEW085 SCT170 BKN230 14/08 A3019 RMK AO2 SLP165 OCNL LTGIC DSNT NE CB DSNT NE MTNS OBSC NE T01440078 402060106
KABQ 2018-10-23T05:52:00Z 30.18 57.0 9.0 NA 2018-10-22 22:52:00 KABQ 230552Z 12008KT 10SM SCT250 14/07 A3018 RMK AO2 SLP167 T01390072 10183 20139 51011
KABQ 2018-10-23T04:52:00Z 30.18 60.1 7.0 NA 2018-10-22 21:52:00 KABQ 230452Z 10006KT 10SM FEW120 SCT250 16/08 A3018 RMK AO2 SLP165 T01560078
KABQ 2018-10-23T03:52:00Z 30.17 62.1 3.0 NA 2018-10-22 20:52:00 KABQ 230352Z VRB03KT 10SM SCT160 17/07 A3017 RMK AO2 SLP160 T01670067
KABQ 2018-10-23T02:52:00Z 30.15 59.0 3.0 NA 2018-10-22 19:52:00 KABQ 230252Z 10003KT 10SM FEW160 SCT220 15/06 A3015 RMK AO2 SLP160 T01500056 53002
KABQ 2018-10-23T01:52:00Z 30.14 62.1 6.0 NA 2018-10-22 18:52:00 KABQ 230152Z 13005KT 10SM FEW100 BKN150 BKN220 17/06 A3014 RMK AO2 SLP156 T01670061
KABQ 2018-10-23T00:52:00Z 30.12 64.9 8.0 NA 2018-10-22 17:52:00 KABQ 230052Z 04007KT 10SM FEW100 BKN150 BKN220 18/06 A3012 RMK AO2 SLP147 SHRA DSNT SW T01830061
KABQ 2018-10-22T23:52:00Z 30.14 64.9 10.0 NA 2018-10-22 16:52:00 KABQ 222352Z 28009KT 10SM FEW100 BKN150 BKN200 18/06 A3014 RMK AO2 SLP151 VIRGA W T01830061 10206 20172 53002

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query