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 * FROM extremes LIMIT 10

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 min0 min1 min2 min5 max95 max98 max99 max100 lowvals highvals latitude longitude elevation name state country wmo
USC00255090 -36.1 -23.3 -20.6 -15.6 36.1 37 38.9 45.6 38614 38796 40.8508 -101.5428 975.4 Madrid Nebraska United States
RSM00024908 -61.0 -50.725 -48.5 -44.4 27.2 29 31.2 35.7 29876 29141 60.3331 102.2667 259.0 Vanavara Russia 24908
USC00182060 -23.3 -13.9 -12.2 -8.9 32.8 34 35.6 42.8 24852 25272 39.6556 -76.1756 12.2 Conowingo Dam Maryland United States
USC00144313 -27.2 -16.7 -13.9 -10.0 37.2 39 40.6 46.7 25883 26051 37.6453 -98.125 471.5 Kingman Kansas United States
CA006016525 -51.2 -38.9 -36.7 -32.8 26.7 28 30.0 40.0 20975 20933 51.45 -90.2167 391.0 Pickle Lake (Aut) Ontario Canada 71835
USC00055531 -28.9 -15.6 -13.9 -11.1 32.2 33 34.4 38.9 33885 33926 37.1997 -108.4892 2176.9 Mesa Verde Np Colorado United States
CA007085106 -49.5 -39.0 -36.0 -31.5 26.5 28 30.0 35.5 12229 12447 48.4167 -78.7333 305.0 Mont Brun Quebec Canada
USR0000OFIS -35.6 -16.7 -14.4 -11.1 33.3 35 36.1 41.7 10747 10741 42.4722 -119.1783 1493.5 Fish Fin Rim Oregon Oregon United States
SWE00138860 -24.9 -13.6 -11.0 -7.6 23.0 25 26.3 31.5 12634 12644 59.3 18.71 16.0 Stavsnas_a Sweden
CHM00056444 -14.7 -9.4 -8.6 -7.5 20.6 22 23.1 34.2 22705 22662 28.45 98.883 3320.0 Deqen China 56444

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query