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 2020-02-18T22:52:00Z 30.07 55.9 3.0 NA 2020-02-18 15:52:00 KABQ 182252Z VRB03KT 10SM FEW070 FEW120 BKN250 13/M03 A3007 RMK AO2 SLP146 T01331033
KABQ 2020-02-18T21:52:00Z 30.07 57.0 6.0 NA 2020-02-18 14:52:00 KABQ 182152Z 33005KT 10SM FEW070 FEW100 SCT250 14/M04 A3007 RMK AO2 SLP145 T01391039
KABQ 2020-02-18T20:52:00Z 30.09 55.9 0.0 NA 2020-02-18 13:52:00 KABQ 182052Z 00000KT 10SM FEW070 FEW200 BKN250 13/M06 A3009 RMK AO2 SLP155 T01331061 58023
KABQ 2020-02-18T19:52:00Z 30.12 54.0 0.0 NA 2020-02-18 12:52:00 KABQ 181952Z 00000KT 10SM FEW060 FEW150 SCT250 12/M04 A3012 RMK AO2 SLP168 T01221039
KABQ 2020-02-18T18:52:00Z 30.15 50.0 5.0 NA 2020-02-18 11:52:00 KABQ 181852Z VRB04KT 10SM FEW055 SCT250 10/M03 A3015 RMK AO2 SLP180 T01001033
KABQ 2020-02-18T17:52:00Z 30.17 48.9 8.0 NA 2020-02-18 10:52:00 KABQ 181752Z 07007KT 10SM FEW030 FEW250 09/M03 A3017 RMK AO2 SLP190 T00941028 10100 20028 51011
KABQ 2020-02-18T16:52:00Z 30.16 46.9 15.0 20.0 2020-02-18 09:52:00 KABQ 181652Z 07013G17KT 10SM FEW030 FEW250 08/M02 A3016 RMK AO2 SLP184 MTN TOPS OBSC SE T00831022
KABQ 2020-02-18T15:52:00Z 30.15 44.1 5.0 NA 2020-02-18 08:52:00 KABQ 181552Z VRB04KT 10SM FEW030 FEW090 07/M01 A3015 RMK AO2 SLP181 MTN TOPS OBSC NE AND SE T00671006
KABQ 2020-02-18T14:52:00Z 30.13 39.0 7.0 NA 2020-02-18 07:52:00 KABQ 181452Z 35006KT 10SM FEW020 FEW070 SCT090 04/M01 A3013 RMK AO2 SLP179 MTNS OBSC NE-SE T00391011 53023
KABQ 2020-02-18T13:52:00Z 30.09 37.9 5.0 NA 2020-02-18 06:52:00 KABQ 181352Z 35004KT 10SM FEW015 SCT070 SCT100 03/M03 A3009 RMK AO2 SLP167 MTNS OBSC NE-SE SHSN DSNT E-SE T00331028
KABQ 2020-02-18T12:52:00Z 30.07 39.9 7.0 NA 2020-02-18 05:52:00 KABQ 181252Z 02006KT 10SM FEW075 FEW100 SCT180 04/M03 A3007 RMK AO2 SLP150 T00441028
KABQ 2020-02-18T11:52:00Z 30.05 41.0 9.0 NA 2020-02-18 04:52:00 KABQ 181152Z 01008KT 10SM FEW075 SCT100 BKN180 05/M03 A3005 RMK AO2 SLP139 60000 T00501028 10083 20050 53011
KABQ 2020-02-18T10:52:00Z 30.03 45.0 5.0 NA 2020-02-18 03:52:00 KABQ 181052Z 32004KT 10SM SCT075 SCT200 07/M03 A3003 RMK AO2 SLP125 T00721028
KABQ 2020-02-18T09:52:00Z 30.02 46.9 5.0 NA 2020-02-18 02:52:00 KABQ 180952Z 05004KT 10SM OVC075 08/M02 A3002 RMK AO2 SLP121 T00831022
KABQ 2020-02-18T08:52:00Z 30.01 44.1 3.0 NA 2020-02-18 01:52:00 KABQ 180852Z 11003KT 10SM BKN080 BKN110 07/M02 A3001 RMK AO2 RAE14 SLP119 P0000 60000 T00671022 51011
KABQ 2020-02-18T07:52:00Z 29.99 44.1 6.0 NA 2020-02-18 00:52:00 KABQ 180752Z 17005KT 10SM -RA BKN090 OVC110 07/M02 A2999 RMK AO2 RAB37 SLP117 P0000 T00671022
KABQ 2020-02-18T06:52:00Z 29.99 46.0 0.0 NA 2020-02-17 23:52:00 KABQ 180652Z 00000KT 10SM BKN100 08/M02 A2999 RMK AO2 SLP115 T00781022 401780011
KABQ 2020-02-18T05:52:00Z 29.97 45.0 0.0 NA 2020-02-17 22:52:00 KABQ 180552Z 00000KT 10SM SCT130 07/M03 A2997 RMK AO2 SLP114 T00721028 10161 20067 52010
KABQ 2020-02-18T04:52:00Z 29.96 50.0 5.0 NA 2020-02-17 21:52:00 KABQ 180452Z 34004KT 10SM SCT150 10/M03 A2996 RMK AO2 SLP110 T01001028
KABQ 2020-02-18T03:52:00Z 29.95 52.0 7.0 NA 2020-02-17 20:52:00 KABQ 180352Z 35006KT 10SM BKN110 11/M03 A2995 RMK AO2 SLP108 T01111028
KABQ 2020-02-18T02:52:00Z 29.94 53.1 5.0 NA 2020-02-17 19:52:00 KABQ 180252Z 35004KT 10SM BKN100 12/M03 A2994 RMK AO2 SLP112 T01171028 51023
KABQ 2020-02-18T01:52:00Z 29.91 54.0 7.0 NA 2020-02-17 18:52:00 KABQ 180152Z 36006KT 10SM BKN100 12/M03 A2991 RMK AO2 SLP109 T01221028
KABQ 2020-02-18T00:52:00Z 29.89 57.0 10.0 NA 2020-02-17 17:52:00 KABQ 180052Z 35009KT 10SM BKN095 14/M03 A2989 RMK AO2 SLP092 T01391033
KABQ 2020-02-17T23:52:00Z 29.86 61.0 12.0 NA 2020-02-17 16:52:00 KABQ 172352Z 33010KT 10SM BKN095 16/M04 A2986 RMK AO2 SLP077 T01611039 10178 20122 53002

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query