! THESE DATA ARE UNOFFICIAL AND PROVISIONAL Station_Id|Name|Latitude|Longitude|Elevation|Physical_Element|DateTime_Report(UTC)|Amount|Amount_Units|Duration|Duration_Units|Zip_Code| SNWI2|STREAMWOOD|42.01670|-88.16670|247 meters|snowfall|2011-07-24 00|0.000|cm|12|hours|60107| SCOM4|SCOTTVILLE 2 SE|43.93310|-86.24530|203 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49454| ORD|O'HARE INTL AP|41.97940|-87.90440|215 meters|snowfall|2011-07-23 18|0.000|cm|6|hours|60666| MQT|MARQUETTE, MI|46.53110|-87.54830|437 meters|snowfall|2011-07-23 18|0.000|cm|6|hours|49866| MKG|MUSKEGON COUNTY AIRPORT|43.16940|-86.23810|192 meters|snowfall|2011-07-24 00|0.000|cm|24|hours|49441| LOT|CHICAGO, IL|41.60830|-88.09390|200 meters|snowfall|2011-07-23 18|0.000|cm|6|hours|60446| LAN|CAPITAL CITY AIRPORT|42.77860|-84.58720|258 meters|snowfall|2011-07-24 00|0.000|cm|24|hours|48906| INAM4|1MI.WNW IONIA,MI|42.98330|-85.06670|203 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|48846| HTL|ROSCOMMON COUNTY AIRPORT|44.35000|-84.66670|349 meters|snowfall|2011-07-24 00|0.000|cm|24|hours|48629| HRTM4|HART,MI|43.70000|-86.36670|200 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49420| HOLM4|HOLLAND,MI|42.80000|-86.11670|185 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49424| HASM4|WWTP|42.65000|-85.30000|239 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49058| GRR|GRAND RAPIDS, MI|42.89390|-85.54470|242 meters|snowfall|2011-07-24 00|0.000|cm|24|hours|49512| GPDM4|44TH STREET|42.90000|-85.76670|188 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49418| GGRM4|GREEN GARDEN NO.2|46.45330|-87.30380|207 meters|snowfall|2011-07-23 13|0.000|cm|12|hours|49855| BLMM4|BLOOMINGDALE,MI|42.38330|-85.96670|229 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49026| BGRM4|WATER WORKS|43.70000|-85.48330|281 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49307| APN|PHELPS COLLINS FIELD|45.07810|-83.56030|204 meters|snowfall|2011-07-24 00|0.000|cm|24|hours|49707| ANJ|SAULT STE MARIE|46.46670|-84.36670|213 meters|snowfall|2011-07-24 00|0.000|cm|24|hours|49783| AHKM4|AHMEEK 1SW|47.29200|-88.42090|334 meters|snowfall|2011-07-23 11|0.000|cm|12|hours|49913| 9932S_MADIS|GREEN BAY 6.3 WNW, WI|44.54985|-88.11110|201 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54313| 9910H_MADIS|BLACK CREEK 2.1 NNW, WI|44.50127|-88.46940|240 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54106| 9883O_MADIS|BAY CITY 5.3 N, MI|43.66637|-83.90610|184 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|48706| 9882O_MADIS|MIKADO 2.3 SE, MI|44.56967|-83.38590|200 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|48745| 9651A_MADIS|GRAND JUNCTION 1.3 ENE, MI|42.40926|-86.04810|208 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49056| 9642A_MADIS|ROSCOMMON 4.6 WSW, MI|44.46440|-84.67360|353 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|48653| 9632A_MADIS|WEST BRANCH 1.1 NE, MI|44.28645|-84.21870|293 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|48661| 9620S_MADIS|CRANDON 0.3 N, WI|45.57401|-88.89830|501 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|54520| 9620A_MADIS|COMMERCE 1.0 N, MI|42.61214|-83.49200|291 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|48382| 9600A_MADIS|MARQUETTE 1.9 WNW, MI|46.56056|-87.43340|222 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49855| 9599O_MADIS|VALPARAISO 1.8 N, IN|41.50270|-87.04600|256 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|46383| 9598O_MADIS|VALPARAISO 0.9 NNW, IN|41.48956|-87.05800|257 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|46383| 9571O_MADIS|ST. JOHN 0.2 WSW, IN|41.44627|-87.48020|220 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|46373| 9564A_MADIS|BAD AXE 0.5 SSW, MI|43.79614|-82.99960|231 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|48413| 9561A_MADIS|JONESVILLE 5.9 ENE, MI|42.01472|-84.56190|366 meters|snowfall|2011-07-23 10|0.000|cm|24|hours|49250| 9559A_MADIS|TRAVERSE CITY 4.0 WSW, MI|44.73390|-85.67890|287 meters|snowfall|2011-07-23 14|0.000|cm|24|hours|49684| 9555A_MADIS|WATERSMEET 5.0 SE, MI|46.20333|-89.13170|521 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|49969| 9549A_MADIS|GRAND LEDGE 0.3 NNE, MI|42.75690|-84.74530|258 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|48837| 9541A_MADIS|BOYNE CITY 0.4 S, MI|45.20745|-85.01330|196 meters|snowfall|2011-07-23 01|0.000|cm|24|hours|49712| 9537S_MADIS|ORLAND 1.4 W, IN|41.73361|-85.19880|287 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|46776| 9532A_MADIS|MIDDLEVILLE 1.2 E, MI|42.71114|-85.44190|279 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49333| 9531A_MADIS|ALPENA 1.6 SSW, MI|45.05156|-83.44880|178 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49707| 9281C_MADIS|VALPARAISO 1.4 ENE, IN|41.48770|-87.02750|243 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|46383| 8836S_MADIS|HERMANTOWN 9.3 NNE, MN|46.93000|-92.16600|417 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|55803| 8835S_MADIS|DULUTH 3.0 NE, MN|46.81528|-92.06370|247 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|55812| 8833S_MADIS|HERMANTOWN 2.6 ESE, MN|46.79320|-92.18870|403 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|55811| 8391O_MADIS|ANN ARBOR 3.1 SE, MI|42.23914|-83.69580|255 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|48108| 8311O_MADIS|ANN ARBOR 2.4 WNW, MI|42.29346|-83.76990|294 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|48103| 8274A_MADIS|RENSSELAER 6.2 SE, IN|40.86261|-87.08020|210 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|47978| 8134O_MADIS|MONTAGUE 8.1 NW, MI|43.50000|-86.47000|231 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49446| 8126O_MADIS|HANOVER 3.8 W, MI|42.10700|-84.62600|326 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49241| 8122O_MADIS|CHASSELL 4.0 N, MI|47.08313|-88.52690|213 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49916| 8112O_MADIS|SOUTH BEND 4.6 SE, IN|41.62090|-86.21520|273 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|46614| 8090A_MADIS|HUNTERTOWN 2.6 ESE, IN|41.21444|-85.12420|264 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|46845| 8072S_MADIS|WEBB LAKE 2.2 SW, WI|45.98910|-92.16940|306 meters|snowfall|2011-07-23 16|0.000|cm|24|hours|54830| 7983O_MADIS|NORTHPORT 5.0 SSW, MI|45.06149|-85.64860|272 meters|snowfall|2011-07-23 10|0.000|cm|24|hours|49670| 7977O_MADIS|JACKSON 1.2 ENE, MI|42.24845|-84.38300|296 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49203| 7973O_MADIS|TRAVERSE CITY 9.4 WSW, MI|44.71300|-85.78560|273 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49684| 7967O_MADIS|CHATHAM 0.2 SSE, MI|46.34499|-86.92740|272 meters|snowfall|2011-07-23 22|0.000|cm|24|hours|49826| 7820S_MADIS|NEOPIT-MENOMINEE TRIBAL ENTERPR|44.98040|-88.82930|346 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54416| 7768O_MADIS|WAYLAND 2.0 W, MI|42.67323|-85.68010|226 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49348| 7673S_MADIS|ASHLAND 0.5 WNW, WI|46.58240|-90.88390|210 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54806| 7588O_MADIS|WAYNE COUNTY, MI|42.31400|-83.24500|185 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|48124| 7576O_MADIS|GRANDVILLE 1.3 WSW, MI|42.89716|-85.77910|187 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49418| 7573O_MADIS|LOWELL 1.4 ESE, MI|42.92369|-85.32220|220 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|49331| 7571O_MADIS|TRAVERSE CITY 4.1 E, MI|44.74662|-85.51930|200 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49686| 7564O_MADIS|CHEBOYGAN 2.9 S, MI|45.60000|-84.46280|181 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49721| 7493O_MADIS|EAST GRAND RAPIDS 0.7 SSW, MI|42.93801|-85.61340|228 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49506| 7401O_MADIS|GARDEN CORNERS 0.8 NW, MI|45.89815|-86.54850|177 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49835| 7212O_MADIS|MIDLAND 8.2 NNE, MI|43.73573|-84.17680|207 meters|snowfall|2011-07-23 09|0.000|cm|24|hours|48642| 7209O_MADIS|WELLSTON 0.8 N, MI|44.22876|-85.95780|235 meters|snowfall|2011-07-23 16|0.000|cm|24|hours|49689| 7197O_MADIS|HASLETT 1.2 N, MI|42.76997|-84.40310|266 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|48840| 7196O_MADIS|BEAVER ISLAND 5.9 NNW, MI|45.74985|-85.51030|175 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49782| 7106O_MADIS|MARQUETTE COUNTY, MI|46.47310|-87.36780|219 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49855| 7104O_MADIS|LAINGSBURG 5.0 SW, MI|42.84028|-84.41970|253 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|48808| 7092O_MADIS|OTSEGO COUNTY, MI|44.99783|-84.65310|405 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49735| 6907C_MADIS|BAYFIELD COUNTY, WI|46.16937|-90.98090|458 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54821| 6906O_MADIS|MADISON 3.7 WSW, WI|43.06230|-89.45650|289 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|53705| 6813H_MADIS|GRAYLING 6.1 E, MI|44.65580|-84.58570|342 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49738| 6738C_MADIS|CROWN POINT 2.0 WSW, IN|41.40892|-87.38990|229 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|46307| 6388H_MADIS|SYRACUSE 0.9 SW, IN|41.41286|-85.75830|273 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|46567| 6344C_MADIS|MOUNTAIN 1.1 SW, WI|45.17239|-88.48990|294 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54149| 6201C_MADIS|MERRILL 7.0 W, WI|45.17746|-89.84820|434 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|54452| 6038C_MADIS|CECIL 5.6 ENE, WI|44.84920|-88.34720|244 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|54111| 5850C_MADIS|CEDARBURG 0.8 NNE, WI|43.30855|-87.98480|253 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|53012| 5846C_MADIS|BAYFIELD 8.8 N, WI|46.93855|-90.83490|215 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54814| 5806C_MADIS|MANHATTAN 4.7 ENE, IL|41.45845|-87.90980|227 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|60442| 5795C_MADIS|WEYAUWEGA 0.1 S, WI|44.32130|-88.92860|244 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|54983| 5704S_MADIS|SAGINAW 3.0 NW, MI|43.45566|-83.98460|186 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|48603| 5693C_MADIS|RHINELANDER 2.7 WNW, WI|45.65681|-89.46300|479 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54501| 5686S_MADIS|LAKE CITY 5.0 SSW, MI|44.26590|-85.25530|380 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49651| 5665S_MADIS|TRAVERSE CITY 4.2 E, MI|44.74558|-85.51840|212 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49686| 5620C_MADIS|BATAVIA 1.5 WNW, IL|41.85937|-88.32750|219 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|60510| 5154C_MADIS|ELGIN 1.0 S, IL|42.02560|-88.28850|238 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|60123| 5109O_MADIS|HART 3 WSW, MI|43.67470|-86.42250|236 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49436| 5106S_MADIS|NEW LENOX 1.8 SE, IL|41.49964|-87.96030|215 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|60451| 5099S_MADIS|HOMER GLEN 3.9 WNW, IL|41.63752|-88.00290|224 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|60491| 5066S_MADIS|ALGONQUIN 0.7 N, IL|42.17392|-88.29930|258 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|60102| 4588C_MADIS|FULTON COUNTY, IN|41.08516|-86.22930|234 meters|snowfall|2011-07-23 10|0.000|cm|24|hours|46975| 4228O_MADIS|STONE LAKE 2.0 NW, WI|45.85960|-91.57710|406 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54876| 4137H_MADIS|BIG BEND 0.1 WNW, WI|42.88200|-88.20460|253 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|53103| 4130H_MADIS|JACKSON 1.9 N, WI|43.34880|-88.15980|291 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|53037| 4125H_MADIS|LAKE GENEVA 0.6 ENE, WI|42.59169|-88.41770|278 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|53147| 4120O_MADIS|ST. CHARLES 0.1 E, IL|41.92010|-88.29900|238 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|60174| 4118H_MADIS|BUTTERNUT 5.9 SW, WI|45.96501|-90.59750|481 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54552| 4110H_MADIS|WEST ALLIS 0.7 SSE, WI|42.99802|-88.02380|235 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|53227| 3492O_MADIS|GAYLORD 1.8 ESE, MI|45.00932|-84.64680|394 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49735| 3004O_MADIS|ST. JOSEPH COUNTY, MI|41.77780|-85.58330|253 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49099| 2511O_MADIS|FREDERIC 5.5 NNE, MI|44.83650|-84.72980|406 meters|snowfall|2011-07-23 10|0.000|cm|24|hours|49733| 1722R_MADIS|HAYWARD 9.2 NNE, WI|46.13255|-91.40500|411 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|54843| 1614R_MADIS|PORT HURON 1.6 W, MI|42.99617|-82.46430|187 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|48060| 1505O_MADIS|RHINELANDER 6.3 WNW, WI|45.67583|-89.53240|491 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|54501| 1485H_MADIS|TOLEDO 2.4 ENE, OH|41.68228|-83.54120|182 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|43608| 1453O_MADIS|TRAVERSE CITY 7.6 SSW, MI|44.65319|-85.66400|274 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49684| 1345O_MADIS|EAST TAWAS 0.8 WSW, MI|44.28322|-83.49920|179 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|48730| 1192O_MADIS|ONTONAGON 0.3 NE, MI|46.86955|-89.30930|195 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49953| 0707B_MADIS|DE PERE 2.4 W, WI|44.44197|-88.11920|203 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|54115| 0670S_MADIS|KALAMAZOO COUNTY, MI|42.26897|-85.47890|263 meters|snowfall|2011-07-23 13|0.000|cm|24|hours|49048| 0669S_MADIS|CHARLEVOIX COUNTY, MI|45.25720|-85.21650|236 meters|snowfall|2011-07-23 11|0.000|cm|24|hours|49720| 0155R_MADIS|CARLTON 5.6 NE, MN|46.70783|-92.32790|362 meters|snowfall|2011-07-23 14|0.000|cm|24|hours|55733| 0047B_MADIS|ELK RAPIDS 0.5 ESE, MI|44.89249|-85.39460|183 meters|snowfall|2011-07-23 12|0.000|cm|24|hours|49629|