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-08-20T04:52:00Z 30.15 82.0 13.0 NA 2019-08-19 21:52:00 KABQ 200452Z 19011KT 10SM SCT200 28/06 A3015 RMK AO2 SLP111 T02780061
KABQ 2019-08-20T03:52:00Z 30.14 84.0 15.0 NA 2019-08-19 20:52:00 KABQ 200352Z 18013KT 10SM FEW160 29/06 A3014 RMK AO2 SLP107 T02890056
KABQ 2019-08-20T02:52:00Z 30.11 87.1 14.0 NA 2019-08-19 19:52:00 KABQ 200252Z 18012KT 10SM FEW160 31/04 A3011 RMK AO2 SLP101 T03060044 53008
KABQ 2019-08-20T01:52:00Z 30.09 90.0 14.0 NA 2019-08-19 18:52:00 KABQ 200152Z 19012KT 10SM SCT160 32/04 A3009 RMK AO2 SLP092 T03220039
KABQ 2019-08-20T00:52:00Z 30.08 93.0 14.0 NA 2019-08-19 17:52:00 KABQ 200052Z 22012KT 10SM FEW140 FEW180 34/03 A3008 RMK AO2 SLP087 T03390028
KABQ 2019-08-19T23:52:00Z 30.08 93.9 6.0 NA 2019-08-19 16:52:00 KABQ 192352Z 24005KT 10SM FEW140 34/02 A3008 RMK AO2 SLP089 T03440022 10356 20306 56013
KABQ 2019-08-19T22:52:00Z 30.1 93.9 8.0 NA 2019-08-19 15:52:00 KABQ 192252Z 22007KT 180V260 10SM FEW120 SCT200 34/02 A3010 RMK AO2 SLP095 T03440022
KABQ 2019-08-19T21:52:00Z 30.11 93.9 6.0 NA 2019-08-19 14:52:00 KABQ 192152Z 22005KT 10SM SCT120 SCT200 34/03 A3011 RMK AO2 SLP092 T03440028
KABQ 2019-08-19T20:52:00Z 30.13 93.9 7.0 NA 2019-08-19 13:52:00 KABQ 192052Z 24006KT 10SM SCT140 SCT200 34/02 A3013 RMK AO2 SLP101 T03440017 58019
KABQ 2019-08-19T19:52:00Z 30.15 93.0 8.0 NA 2019-08-19 12:52:00 KABQ 191952Z 26007KT 220V290 10SM SCT140 34/01 A3015 RMK AO2 SLP108 T03390006
KABQ 2019-08-19T18:52:00Z 30.17 90.0 3.0 NA 2019-08-19 11:52:00 KABQ 191852Z 11003KT 10SM BKN130 BKN190 32/M01 A3017 RMK AO2 SLP118 T03221006
KABQ 2019-08-19T17:52:00Z 30.19 87.1 6.0 NA 2019-08-19 10:52:00 KABQ 191752Z 33005KT 10SM SCT150 SCT190 31/M01 A3019 RMK AO2 SLP125 T03061006 10311 20172 58002
KABQ 2019-08-19T16:52:00Z 30.2 84.0 5.0 NA 2019-08-19 09:52:00 KABQ 191652Z VRB04KT 10SM SCT140 SCT190 29/01 A3020 RMK AO2 SLP128 T02890006
KABQ 2019-08-19T15:52:00Z 30.2 79.0 0.0 NA 2019-08-19 08:52:00 KABQ 191552Z 00000KT 10SM SCT140 SCT230 26/01 A3020 RMK AO2 SLP134 T02610011
KABQ 2019-08-19T14:52:00Z 30.2 73.0 5.0 NA 2019-08-19 07:52:00 KABQ 191452Z 33004KT 10SM BKN140 BKN230 23/03 A3020 RMK AO2 SLP135 T02280033 51014
KABQ 2019-08-19T13:52:00Z 30.18 69.1 7.0 NA 2019-08-19 06:52:00 KABQ 191352Z 32006KT 10SM SCT140 SCT230 21/02 A3018 RMK AO2 SLP130 T02060017
KABQ 2019-08-19T12:52:00Z 30.17 69.1 12.0 NA 2019-08-19 05:52:00 KABQ 191252Z 01010KT 10SM SCT140 BKN230 21/01 A3017 RMK AO2 SLP121 T02060006
KABQ 2019-08-19T11:52:00Z 30.15 68.0 6.0 NA 2019-08-19 04:52:00 KABQ 191152Z 02005KT 10SM SCT140 SCT230 20/02 A3015 RMK AO2 SLP114 T02000017 10267 20194 53010
KABQ 2019-08-19T10:52:00Z 30.13 66.9 5.0 NA 2019-08-19 03:52:00 KABQ 191052Z 27004KT 10SM SCT140 SCT250 19/04 A3013 RMK AO2 SLP110 T01940039
KABQ 2019-08-19T09:52:00Z 30.12 75.0 10.0 NA 2019-08-19 02:52:00 KABQ 190952Z 04009KT 10SM SCT140 SCT250 24/M01 A3012 RMK AO2 SLP097 T02391011
KABQ 2019-08-19T08:52:00Z 30.11 73.0 8.0 NA 2019-08-19 01:52:00 KABQ 190852Z 36007KT 10SM FEW140 FEW250 23/03 A3011 RMK AO2 SLP099 T02280028 53002
KABQ 2019-08-19T07:52:00Z 30.11 73.9 3.0 NA 2019-08-19 00:52:00 KABQ 190752Z 25003KT 10SM FEW140 SCT250 23/M01 A3011 RMK AO2 SLP097 T02331011
KABQ 2019-08-19T06:52:00Z 30.1 75.0 7.0 NA 2019-08-18 23:52:00 KABQ 190652Z 08006KT 10SM FEW140 BKN240 24/M01 A3010 RMK AO2 SLP095 T02391006 403440178
KABQ 2019-08-19T05:52:00Z 30.11 78.1 3.0 NA 2019-08-18 22:52:00 KABQ 190552Z 14003KT 10SM FEW140 BKN240 26/M01 A3011 RMK AO2 SLP096 T02561011 10333 20250 52010

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query