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-11-20T19:52:00Z 29.77 59.0 20.0 NA 2019-11-20 12:52:00 KABQ 201952Z 19017KT 10SM FEW034 BKN065 BKN090 15/06 A2977 RMK AO2 SLP028 MTN TOPS OBSC NE AND SE VCSH SE SHRA DSNT W-NW T01500061
KABQ 2019-11-20T18:52:00Z 29.79 57.0 13.0 NA 2019-11-20 11:52:00 KABQ 201852Z 19011KT 10SM FEW019 SCT030 BKN090 14/08 A2979 RMK AO2 SLP035 MTN TOPS OBSC NE AND SE T01390078
KABQ 2019-11-20T17:52:00Z 29.81 54.0 10.0 NA 2019-11-20 10:52:00 KABQ 201752Z 21009KT 10SM SCT015 SCT020 BKN090 12/08 A2981 RMK AO2 SLP046 MTN TOPS OBSC NE-SE 60024 T01220083 10122 20089 50004
KABQ 2019-11-20T16:52:00Z 29.82 53.1 7.0 NA 2019-11-20 09:52:00 KABQ 201652Z 19006KT 10SM FEW010 FEW040 SCT130 BKN250 12/09 A2982 RMK AO2 SLP050 MTN TOPS OBSC NE AND SE T01170094
KABQ 2019-11-20T15:52:00Z 29.82 50.0 7.0 NA 2019-11-20 08:52:00 KABQ 201552Z 31006KT 10SM FEW010 FEW040 SCT130 BKN190 10/08 A2982 RMK AO2 SLP056 MTN TOPS OBSC SE T01000083
KABQ 2019-11-20T14:52:00Z 29.79 48.9 6.0 NA 2019-11-20 07:52:00 KABQ 201452Z 17005KT 10SM FEW020 FEW035 BKN130 BKN200 09/08 A2979 RMK AO2 SLP047 MTN TOPS OBSC SE 60024 T00940078 51002
KABQ 2019-11-20T14:39:00Z 29.77 48.9 3.0 NA 2019-11-20 07:39:00 KABQ 201439Z COR 14003KT 10SM FEW015 SCT028 BKN130 09/08 A2977 RMK AO2 MTN TOPS OBSC SE T00940078
KABQ 2019-11-20T14:12:00Z 29.77 48.0 12.0 NA 2019-11-20 07:12:00 KABQ 201412Z 09010KT 10SM FEW005 FEW015 BKN028 BKN130 09/08 A2977 RMK AO2 MTNS OBSC NE-SE T00890078
KABQ 2019-11-20T13:52:00Z 29.78 48.9 9.0 NA 2019-11-20 06:52:00 KABQ 201352Z 06008KT 10SM FEW004 FEW014 BKN032 BKN130 09/08 A2978 RMK AO2 WSHFT 1248 RAE41 PRESFR SLP045 MTNS OBSC NE-SE P0011 T00940078
KABQ 2019-11-20T13:37:00Z 29.8 48.0 5.0 NA 2019-11-20 06:37:00 KABQ 201337Z 35004KT 8SM -RA FEW004 SCT014 BKN032 OVC130 09/08 A2980 RMK AO2 WSHFT 1248 MTNS OBSC NE-SE P0011 T00890078
KABQ 2019-11-20T13:06:00Z 29.81 48.9 15.0 NA 2019-11-20 06:06:00 KABQ 201306Z 26013KT 3SM +RA BR SCT001 BKN011 OVC035 09/08 A2981 RMK AO2 WSHFT 1248 MTNS OBSC NE-SE P0006 T00940083
KABQ 2019-11-20T12:52:00Z 29.8 50.0 13.0 NA 2019-11-20 05:52:00 KABQ 201252Z 19011KT 5SM -RA BR SCT001 SCT015 OVC040 10/09 A2980 RMK AO2 SLP045 MTNS OBSC NE-SE P0013 T01000089
KABQ 2019-11-20T12:34:00Z 29.79 50.0 13.0 NA 2019-11-20 05:34:00 KABQ 201234Z 18011KT 6SM -RA BR SCT001 SCT022 OVC040 10/09 A2979 RMK AO2 MTNS OBSC NE-SE P0012 T01000094
KABQ 2019-11-20T12:16:00Z 29.78 50.0 16.0 NA 2019-11-20 05:16:00 KABQ 201216Z 17014KT 5SM RA BR SCT006 BKN022 OVC040 10/09 A2978 RMK AO2 MTNS OBSC NE-SE P0009 T01000094
KABQ 2019-11-20T11:52:00Z 29.78 50.0 15.0 NA 2019-11-20 04:52:00 KABQ 201152Z 19013KT 6SM RA BR BKN006 BKN022 OVC040 10/09 A2978 RMK AO2 RAB1055 SLP033 MTNS OBSC NE-SE P0005 60005 70005 T01000094 10133 20100 56007
KABQ 2019-11-20T11:36:00Z 29.78 50.0 14.0 NA 2019-11-20 04:36:00 KABQ 201136Z 19012KT 8SM -RA SCT009 BKN024 OVC040 10/09 A2978 RMK AO2 RAB1055 MTNS OBSC NE-SE P0004 T01000094
KABQ 2019-11-20T11:07:00Z 29.79 52.0 15.0 NA 2019-11-20 04:07:00 KABQ 201107Z 21013KT 6SM RA BR FEW013 BKN018 OVC040 11/09 A2979 RMK AO2 RAB1055 MTNS OBSC NE-SE P0001 T01110089
KABQ 2019-11-20T10:52:00Z 29.79 53.1 16.0 NA 2019-11-20 03:52:00 KABQ 201052Z 19014KT 10SM FEW020 FEW040 OVC070 12/07 A2979 RMK AO2 SLP028 MTNS OBSC NE-SE VCSH NE T01170072
KABQ 2019-11-20T09:52:00Z 29.8 54.0 7.0 NA 2019-11-20 02:52:00 KABQ 200952Z 20006KT 10SM FEW045 BKN070 OVC110 12/07 A2980 RMK AO2 SLP032 MTNS OBSC NE-E VCSH E AND SW T01220067
KABQ 2019-11-20T08:52:00Z 29.81 53.1 6.0 NA 2019-11-20 01:52:00 KABQ 200852Z 18005KT 10SM FEW050 BKN070 BKN130 OVC180 12/06 A2981 RMK AO2 RAE29 SLP037 MTNS OBSC NE-E VCSH E P0000 60000 T01170061 58009
KABQ 2019-11-20T07:52:00Z 29.82 55.0 8.0 NA 2019-11-20 00:52:00 KABQ 200752Z 18007KT 10SM -RA FEW060 BKN080 OVC130 13/05 A2982 RMK AO2 RAB30 SLP043 P0000 T01280050
KABQ 2019-11-20T06:52:00Z 29.83 55.9 12.0 NA 2019-11-19 23:52:00 KABQ 200652Z 19010KT 10SM SCT100 BKN150 BKN250 13/03 A2983 RMK AO2 SLP051 T01330028 401940022
KABQ 2019-11-20T05:52:00Z 29.84 55.0 9.0 NA 2019-11-19 22:52:00 KABQ 200552Z 16008KT 10SM SCT100 BKN150 OVC250 13/M04 A2984 RMK AO2 SLP059 T01281039 10172 20111 58011
KABQ 2019-11-20T04:52:00Z 29.85 57.0 7.0 NA 2019-11-19 21:52:00 KABQ 200452Z 15006KT 10SM BKN150 OVC250 14/M05 A2985 RMK AO2 SLP069 T01391050
KABQ 2019-11-20T03:52:00Z 29.88 55.9 5.0 NA 2019-11-19 20:52:00 KABQ 200352Z 16004KT 10SM BKN210 BKN250 13/M05 A2988 RMK AO2 SLP083 T01331050
KABQ 2019-11-20T02:52:00Z 29.88 55.0 10.0 NA 2019-11-19 19:52:00 KABQ 200252Z 12009KT 10SM BKN210 OVC280 13/M05 A2988 RMK AO2 SLP086 T01281050 57002
KABQ 2019-11-20T01:52:00Z 29.88 52.0 6.0 NA 2019-11-19 18:52:00 KABQ 200152Z 15005KT 10SM BKN210 OVC280 11/M05 A2988 RMK AO2 SLP095 T01111050
KABQ 2019-11-20T00:52:00Z 29.88 60.1 3.0 NA 2019-11-19 17:52:00 KABQ 200052Z 22003KT 10SM SCT200 OVC280 16/M05 A2988 RMK AO2 SLP085 T01561050
KABQ 2019-11-19T23:52:00Z 29.89 63.0 0.0 NA 2019-11-19 16:52:00 KABQ 192352Z 00000KT 10SM SCT200 OVC280 17/M05 A2989 RMK AO2 SLP080 T01721050 10194 20117 56012
KABQ 2019-11-19T22:52:00Z 29.89 66.0 0.0 NA 2019-11-19 15:52:00 KABQ 192252Z 00000KT 10SM FEW100 FEW150 OVC250 19/M05 A2989 RMK AO2 SLP075 T01891050
KABQ 2019-11-19T21:52:00Z 29.9 66.0 0.0 NA 2019-11-19 14:52:00 KABQ 192152Z 00000KT 10SM FEW200 BKN250 19/M04 A2990 RMK AO2 SLP080 T01891044
KABQ 2019-11-19T20:52:00Z 29.93 64.9 3.0 NA 2019-11-19 13:52:00 KABQ 192052Z 24003KT 10SM FEW210 SCT250 18/M04 A2993 RMK AO2 SLP093 T01831044 57034

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query