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 2018-01-18T14:52:00Z 30.3 23.0 0.0 NA 2018-01-18 07:52:00 KABQ 181452Z 00000KT 10SM FEW130 SCT220 M05/M11 A3030 RMK AO2 SLP287 T10501106 53001
KABQ 2018-01-18T13:52:00Z 30.3 23.0 6.0 NA 2018-01-18 06:52:00 KABQ 181352Z 01005KT 10SM SCT130 M05/M11 A3030 RMK AO2 SLP281 T10501106
KABQ 2018-01-18T12:52:00Z 30.29 19.0 3.0 NA 2018-01-18 05:52:00 KABQ 181252Z 11003KT 10SM FEW130 M07/M12 A3029 RMK AO2 SLP281 T10721117
KABQ 2018-01-18T11:52:00Z 30.3 21.0 3.0 NA 2018-01-18 04:52:00 KABQ 181152Z 29003KT 10SM CLR M06/M11 A3030 RMK AO2 SLP278 T10611111 11011 21067 58007
KABQ 2018-01-18T10:52:00Z 30.31 23.0 0.0 NA 2018-01-18 03:52:00 KABQ 181052Z 00000KT 10SM CLR M05/M11 A3031 RMK AO2 SLP280 T10501106
KABQ 2018-01-18T09:52:00Z 30.33 24.1 0.0 NA 2018-01-18 02:52:00 KABQ 180952Z 00000KT 10SM CLR M04/M11 A3033 RMK AO2 SLP281 T10441106
KABQ 2018-01-18T08:52:00Z 30.33 28.0 7.0 NA 2018-01-18 01:52:00 KABQ 180852Z 36006KT 10SM CLR M02/M10 A3033 RMK AO2 SLP280 T10221100 55002
KABQ 2018-01-18T07:52:00Z 30.32 27.0 7.0 NA 2018-01-18 00:52:00 KABQ 180752Z 01006KT 10SM CLR M03/M10 A3032 RMK AO2 SLP283 T10281100
KABQ 2018-01-18T06:52:00Z 30.33 28.0 0.0 NA 2018-01-17 23:52:00 KABQ 180652Z 00000KT 10SM CLR M02/M11 A3033 RMK AO2 SLP286 T10221106 400501089
KABQ 2018-01-18T05:52:00Z 30.33 28.0 0.0 NA 2018-01-17 22:52:00 KABQ 180552Z 00000KT 10SM CLR M02/M11 A3033 RMK AO2 SLP291 T10221106 10044 21033 50003
KABQ 2018-01-18T04:52:00Z 30.34 28.0 0.0 NA 2018-01-17 21:52:00 KABQ 180452Z 00000KT 10SM CLR M02/M11 A3034 RMK AO2 SLP298 T10221111
KABQ 2018-01-18T03:52:00Z 30.33 33.1 0.0 NA 2018-01-17 20:52:00 KABQ 180352Z 00000KT 10SM CLR 01/M10 A3033 RMK AO2 SLP295 T00061100
KABQ 2018-01-18T02:52:00Z 30.32 32.0 6.0 NA 2018-01-17 19:52:00 KABQ 180252Z 10005KT 10SM FEW250 00/M11 A3032 RMK AO2 SLP301 T00001106 53009
KABQ 2018-01-18T01:52:00Z 30.31 35.1 3.0 NA 2018-01-17 18:52:00 KABQ 180152Z 25003KT 10SM SCT250 02/M10 A3031 RMK AO2 SLP289 T00171100
KABQ 2018-01-18T00:52:00Z 30.29 37.0 3.0 NA 2018-01-17 17:52:00 KABQ 180052Z 19003KT 10SM SCT140 BKN250 03/M11 A3029 RMK AO2 SLP282 T00281106
KABQ 2018-01-17T23:52:00Z 30.29 39.9 3.0 NA 2018-01-17 16:52:00 KABQ 172352Z 18003KT 10SM BKN140 BKN230 04/M09 A3029 RMK AO2 SLP279 T00441094 10050 21011 56005
KABQ 2018-01-17T22:52:00Z 30.3 39.9 3.0 NA 2018-01-17 15:52:00 KABQ 172252Z 18003KT 10SM BKN150 OVC230 04/M10 A3030 RMK AO2 SLP279 T00441100
KABQ 2018-01-17T21:52:00Z 30.3 41.0 0.0 NA 2018-01-17 14:52:00 KABQ 172152Z 00000KT 10SM FEW170 BKN250 05/M09 A3030 RMK AO2 SLP278 T00501094
KABQ 2018-01-17T20:52:00Z 30.31 39.0 5.0 NA 2018-01-17 13:52:00 KABQ 172052Z 23004KT 10SM BKN280 04/M09 A3031 RMK AO2 SLP281 T00391094 56030
KABQ 2018-01-17T19:52:00Z 30.34 36.0 5.0 NA 2018-01-17 12:52:00 KABQ 171952Z 24004KT 10SM SCT220 BKN280 02/M10 A3034 RMK AO2 SLP293 T00221100
KABQ 2018-01-17T18:52:00Z 30.37 33.1 6.0 NA 2018-01-17 11:52:00 KABQ 171852Z 23005KT 10SM FEW180 BKN200 01/M11 A3037 RMK AO2 SLP305 T00061106
KABQ 2018-01-17T17:52:00Z 30.41 30.9 5.0 NA 2018-01-17 10:52:00 KABQ 171752Z 24004KT 10SM FEW180 BKN200 M01/M10 A3041 RMK AO2 SLP325 T10061100 11006 21089 50006
KABQ 2018-01-17T16:52:00Z 30.43 28.0 0.0 NA 2018-01-17 09:52:00 KABQ 171652Z 00000KT 10SM FEW180 SCT220 M02/M10 A3043 RMK AO2 SLP335 T10221100
KABQ 2018-01-17T15:52:00Z 30.41 23.0 3.0 NA 2018-01-17 08:52:00 KABQ 171552Z 28003KT 10SM FEW180 BKN220 M05/M10 A3041 RMK AO2 SLP328 T10501100

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query