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 2017-04-26T20:52:00Z 29.86 64.0 16.0 23.0 2017-04-26 13:52:00 KABQ 262052Z 24014G20KT 10SM FEW100 SCT140 SCT200 18/M07 A2986 RMK AO2 PK WND 25030/2037 SLP063 T01781072 56022
KABQ 2017-04-26T19:52:00Z 29.88 62.1 14.0 NA 2017-04-26 12:52:00 KABQ 261952Z 26012KT 10SM SCT085 SCT120 SCT200 17/M06 A2988 RMK AO2 SLP074 T01671061
KABQ 2017-04-26T18:52:00Z 29.9 59.0 15.0 24.0 2017-04-26 11:52:00 KABQ 261852Z 26013G21KT 10SM FEW080 FEW200 SCT300 15/M05 A2990 RMK AO2 SLP081 T01501050
KABQ 2017-04-26T17:52:00Z 29.93 55.0 6.0 NA 2017-04-26 10:52:00 KABQ 261752Z 16005KT 10SM FEW050 SCT200 13/M01 A2993 RMK AO2 SLP098 T01281006 10128 20050 50001
KABQ 2017-04-26T16:52:00Z 29.95 52.0 8.0 NA 2017-04-26 09:52:00 KABQ 261652Z 22007KT 10SM FEW045 FEW200 11/01 A2995 RMK AO2 SLP105 T01110006
KABQ 2017-04-26T15:52:00Z 29.95 50.0 8.0 NA 2017-04-26 08:52:00 KABQ 261552Z 32007KT 10SM FEW040 FEW250 10/M01 A2995 RMK AO2 SLP108 T01001006
KABQ 2017-04-26T14:52:00Z 29.93 46.9 9.0 NA 2017-04-26 07:52:00 KABQ 261452Z 33008KT 10SM FEW040 FEW250 08/M01 A2993 RMK AO2 SLP106 T00831011 51011
KABQ 2017-04-26T13:52:00Z 29.92 45.0 14.0 NA 2017-04-26 06:52:00 KABQ 261352Z 35012KT 10SM CLR 07/M02 A2992 RMK AO2 SLP107 T00721017
KABQ 2017-04-26T12:52:00Z 29.91 42.1 12.0 NA 2017-04-26 05:52:00 KABQ 261252Z 36010KT 10SM CLR 06/M01 A2991 RMK AO2 SLP107 T00561011
KABQ 2017-04-26T11:52:00Z 29.89 42.1 9.0 NA 2017-04-26 04:52:00 KABQ 261152Z 02008KT 10SM CLR 06/M01 A2989 RMK AO2 SLP091 70021 T00561011 10083 20056 53012
KABQ 2017-04-26T10:52:00Z 29.87 43.0 9.0 NA 2017-04-26 03:52:00 KABQ 261052Z 01008KT 10SM CLR 06/M02 A2987 RMK AO2 SLP078 T00611017
KABQ 2017-04-26T09:52:00Z 29.86 43.0 7.0 NA 2017-04-26 02:52:00 KABQ 260952Z 06006KT 10SM CLR 06/M01 A2986 RMK AO2 SLP074 T00611006
KABQ 2017-04-26T08:52:00Z 29.85 45.0 8.0 NA 2017-04-26 01:52:00 KABQ 260852Z 03007KT 10SM BKN060 07/M01 A2985 RMK AO2 SLP071 T00721006 53009
KABQ 2017-04-26T07:52:00Z 29.83 45.0 3.0 NA 2017-04-26 00:52:00 KABQ 260752Z 32003KT 10SM CLR 07/M01 A2983 RMK AO2 SLP069 T00721011
KABQ 2017-04-26T06:52:00Z 29.82 46.9 12.0 NA 2017-04-25 23:52:00 KABQ 260652Z 34010KT 10SM CLR 08/M02 A2982 RMK AO2 SLP064 T00831022 401830072
KABQ 2017-04-26T05:52:00Z 29.82 46.0 5.0 NA 2017-04-25 22:52:00 KABQ 260552Z 12004KT 10SM FEW110 08/02 A2982 RMK AO2 SLP067 60003 T00780017 10117 20078 51014
KABQ 2017-04-26T04:52:00Z 29.8 46.9 7.0 NA 2017-04-25 21:52:00 KABQ 260452Z 20006KT 10SM FEW040 SCT100 SCT140 08/02 A2980 RMK AO2 SLP063 MTNS OBSC NE-SE T00830022
KABQ 2017-04-26T03:52:00Z 29.79 48.0 8.0 NA 2017-04-25 20:52:00 KABQ 260352Z 27007KT 10SM FEW040 BKN100 BKN200 09/02 A2979 RMK AO2 SLP057 MTNS OBSC NE-SE T00890022
KABQ 2017-04-26T02:52:00Z 29.77 46.9 10.0 NA 2017-04-25 19:52:00 KABQ 260252Z 36009KT 10SM FEW040 BKN100 BKN200 08/03 A2977 RMK AO2 SLP049 MTNS OBSC NE-SE 60003 T00830033 51037
KABQ 2017-04-26T01:52:00Z 29.73 46.9 7.0 NA 2017-04-25 18:52:00 KABQ 260152Z VRB06KT 10SM FEW040 SCT090 BKN120 08/03 A2973 RMK AO2 RAE00 SLP031 MTNS OBSC NE-SE P0000 T00830033
KABQ 2017-04-26T01:00:00Z 29.7 46.9 17.0 NA 2017-04-25 18:00:00 KABQ 260100Z 02015KT 10SM SCT038 BKN055 BKN090 08/04 A2970 RMK AO2 LTG DSNT SE AND S RAE00 SHRA DSNT S-SW MTNS OBSC NE-SE P0000 T00830044
KABQ 2017-04-26T00:52:00Z 29.7 46.9 18.0 NA 2017-04-25 17:52:00 KABQ 260052Z 01016KT 8SM VCTS -RA FEW035 BKN065CB BKN090 BKN200 08/05 A2970 RMK AO2 PK WND 31032/0025 LTG DSNT W RAB00 TSB17E48 SLP015 TS E MOV E MTNS OBSC NE-SE P0003 T00830050
KABQ 2017-04-26T00:17:00Z 29.68 51.1 18.0 28.0 2017-04-25 17:17:00 KABQ 260017Z 35016G24KT 10SM -TSRA FEW035 BKN060CB BKN090 BKN200 11/05 A2968 RMK AO2 LTG DSNT ALQDS RAB00 TSB17 PRESRR TS OHD MOV E MTN TOPS OBSC NE AND SE P0000 T01060050
KABQ 2017-04-26T00:10:00Z 29.66 51.1 16.0 25.0 2017-04-25 17:10:00 KABQ 260010Z 36014G22KT 10SM VCTS -RA FEW035 BKN060CB BKN090 BKN200 11/05 A2966 RMK AO2 LTG DSNT ALQDS RAB00 TS W MOV E MTN TOPS OBSC NE AND SE P0000 T01060050
KABQ 2017-04-25T23:52:00Z 29.64 53.1 17.0 26.0 2017-04-25 16:52:00 KABQ 252352Z 01015G23KT 10SM FEW040 BKN070 BKN150 12/05 A2964 RMK AO2 PK WND 35031/2321 LTG DSNT E AND SW RAB2258E13 SLP984 SHRA DSNT SW-NW MTN TOPS OBSC NE AND SE P0000 60000 T01170050 10150 20089 55014
KABQ 2017-04-25T23:31:00Z 29.65 54.0 20.0 36.0 2017-04-25 16:31:00 KABQ 252331Z 36017G31KT 10SM FEW035 SCT070 SCT200 12/04 A2965 RMK AO2 PK WND 35031/2321 LTG DSNT NE RAB2258E13 SHRA DSNT SW-NW MTNS OBSC NE AND SE P0000 T01220039
KABQ 2017-04-25T23:10:00Z 29.62 55.0 18.0 33.0 2017-04-25 16:10:00 KABQ 252310Z 35016G29KT 10SM VCTS -RA SCT045 BKN060CB BKN090 BKN180 13/04 A2962 RMK AO2 PK WND 34031/2302 LTG DSNT S RAB2258 TS NE MOV E SHRA DSNT NE-SE MTNS OBSC NE AND SE P0000 T01280044
KABQ 2017-04-25T22:52:00Z 29.62 57.0 3.0 NA 2017-04-25 15:52:00 KABQ 252252Z 21003KT 10SM SCT030 BKN060 BKN090 BKN180 14/07 A2962 RMK AO2 LTG DSNT NE AND S SLP972 SHRA DSNT SE-S AND NW-NE MTN TOPS OBSC NE AND SE T01390067
KABQ 2017-04-25T21:52:00Z 29.64 57.0 6.0 NA 2017-04-25 14:52:00 KABQ 252152Z 04005KT 10SM SCT046 SCT060 SCT100 14/07 A2964 RMK AO2 RAB35E46 SLP978 MTN TOPS OBSC NE AND SE P0000 T01390067

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query