! 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| WTNM4|3MI.W WATTON,MI|46.51030|-88.66670|1430 feet|snowfall|2012-07-27 11|0.000|in|12|hours|49970| WHKM4|4MI.E WHITE LAKE,MI|42.69750|-83.47220|1027 feet|snowfall|2012-07-27 12|0.000|in|6|hours|48386| TOL|TOLEDO EXPRESS AIRPORT|41.58750|-83.80530|669 feet|snowfall|2012-07-27 12|0.000|in|24|hours|43558| SCOM4|SCOTTVILLE 2 SE|43.93310|-86.24530|666 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49454| RNBW3|WFO GREEN BAY|44.49780|-88.11080|673 feet|snowfall|2012-07-27 11|0.000|in|6|hours|54313| ORD|O'HARE INTL AP|41.97940|-87.90440|705 feet|snowfall|2012-07-27 12|0.000|in|6|hours|60666| MQT|MARQUETTE, MI|46.53140|-87.54920|1411 feet|snowfall|2012-07-27 12|0.000|in|6|hours|49866| MKG|MUSKEGON COUNTY AIRPORT|43.16940|-86.23810|630 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49441| LOTI2|ROMEOVILLE WFO|41.60440|-88.08580|650 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60446| LAN|CAPITAL CITY AIRPORT|42.77860|-84.58720|846 feet|snowfall|2012-07-27 12|0.000|in|24|hours|48906| IWXI3|NORTHERN INDIANA WFO|41.35880|-85.69970|948 feet|snowfall|2012-07-27 12|0.000|in|6|hours|46567| INAM4|1MI.WNW IONIA,MI|42.98330|-85.06670|666 feet|snowfall|2012-07-27 12|0.000|in|24|hours|48846| IHBM4|HOIST BASIN|46.58930|-87.69570|1375 feet|snowfall|2012-07-27 12|0.000|in|12|hours|49849| HTL|ROSCOMMON COUNTY AIRPORT|44.35000|-84.66670|1145 feet|snowfall|2012-07-27 12|0.000|in|24|hours|48629| HRTM4|HART,MI|43.70000|-86.36670|656 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49420| HASM4|WWTP|42.65000|-85.30000|784 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49058| GRRM4|NWS FORECAST OFFICE GRAND RAPIDS|42.89330|-85.54480|778 feet|snowfall|2012-07-27 12|0.000|in|6|hours|49512| GRR|GRAND RAPIDS, MI|42.89390|-85.54470|794 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49512| GRDM4|WWTP|43.06670|-86.20000|574 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49456| GGRM4|GREEN GARDEN NO.2|46.45330|-87.30380|679 feet|snowfall|2012-07-26 15|0.000|in|12|hours|49855| DPAI2|DUPAGE AIRPORT|41.90670|-88.24830|748 feet|snowfall|2012-07-26 18|0.000|in|12|hours|60185| DLHM5|DULUTH NWS|46.83680|-92.21080|1427 feet|snowfall|2012-07-27 06|0.000|in|6|hours|55811| BGRM4|WATER WORKS|43.70000|-85.48330|922 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49307| APXM4|S. 1.4MI. OTSEGO LAKE|44.90750|-84.71940|1453 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49735| APN|PHELPS COLLINS FIELD|45.07810|-83.56030|669 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49707| ANJ|SAULT STE MARIE|46.46670|-84.36670|699 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49783| 9883O_MADIS|BAY CITY 5.3 N, MI|43.66637|-83.90610|604 feet|snowfall|2012-07-27 12|0.000|in|24|hours|48706| 9736O_MADIS|HIGHLAND 1.0 ESE, IN|41.54229|-87.43970|623 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46322| 9651A_MADIS|GRAND JUNCTION 1.3 ENE, MI|42.40926|-86.04810|682 feet|snowfall|2012-07-26 20|0.000|in|24|hours|49056| 9598O_MADIS|VALPARAISO 0.9 NNW, IN|41.48956|-87.05800|843 feet|snowfall|2012-07-27 10|0.000|in|24|hours|46383| 9571O_MADIS|ST. JOHN 0.2 WSW, IN|41.44627|-87.48020|722 feet|snowfall|2012-07-27 11|0.000|in|24|hours|46373| 9564A_MADIS|BAD AXE 0.5 SSW, MI|43.79614|-82.99960|758 feet|snowfall|2012-07-26 13|0.000|in|24|hours|48413| 9549A_MADIS|GRAND LEDGE 0.3 NNE, MI|42.75690|-84.74530|846 feet|snowfall|2012-07-27 12|0.000|in|24|hours|48837| 9531A_MADIS|ALPENA 1.6 SSW, MI|45.05156|-83.44880|584 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49707| 9390S_MADIS|FORT WAYNE 9.9 NNE, IN|41.21696|-85.08510|850 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46845| 8887S_MADIS|NAPOLEON 3.8 S, OH|41.33970|-84.11960|689 feet|snowfall|2012-07-26 13|0.000|in|24|hours|43545| 8643O_MADIS|WINONA LAKE 0.9 ENE, IN|41.22179|-85.79860|866 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46590| 8391O_MADIS|ANN ARBOR 3.1 SE, MI|42.23914|-83.69580|837 feet|snowfall|2012-07-27 11|0.000|in|24|hours|48108| 8372A_MADIS|PLYMOUTH 2.5 WSW, IN|41.32970|-86.35680|817 feet|snowfall|2012-07-27 09|0.000|in|24|hours|46563| 8274A_MADIS|RENSSELAER 6.2 SE, IN|40.86261|-87.08020|689 feet|snowfall|2012-07-27 12|0.000|in|24|hours|47978| 8259A_MADIS|RENSSELAER 1.9 SSW, IN|40.90845|-87.15860|673 feet|snowfall|2012-07-27 11|0.000|in|24|hours|47978| 8164A_MADIS|BUTLER 0.5 NNE, IN|41.43555|-84.86550|869 feet|snowfall|2012-07-27 10|0.000|in|24|hours|46721| 8160A_MADIS|AUBURN 0.8 NE, IN|41.37045|-85.04570|879 feet|snowfall|2012-07-27 10|0.000|in|24|hours|46706| 8134O_MADIS|MONTAGUE 8.1 NW, MI|43.50000|-86.47000|758 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49446| 8127A_MADIS|LOGANSPORT 2.2 NNW, IN|40.78220|-86.37400|728 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46947| 8126O_MADIS|HANOVER 3.8 W, MI|42.10700|-84.62600|1070 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49241| 8112O_MADIS|SOUTH BEND 4.6 SE, IN|41.62090|-86.21520|896 feet|snowfall|2012-07-27 11|0.000|in|24|hours|46614| 8090A_MADIS|HUNTERTOWN 2.6 ESE, IN|41.21444|-85.12420|866 feet|snowfall|2012-07-27 11|0.000|in|24|hours|46845| 7977O_MADIS|JACKSON 1.2 ENE, MI|42.24845|-84.38300|971 feet|snowfall|2012-07-27 10|0.000|in|24|hours|49203| 7878A_MADIS|PALATINE 1.3 E, IL|42.11385|-88.01780|741 feet|snowfall|2012-07-26 15|0.000|in|24|hours|60074| 7820S_MADIS|NEOPIT-MENOMINEE TRIBAL ENTERPR|44.98040|-88.82930|1053 feet|snowfall|2012-07-26 12|0.000|in|24|hours|54416| 7784O_MADIS|GRAND RAPIDS 3.2 S, MI|42.91468|-85.64920|659 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49507| 7768O_MADIS|WAYLAND 2.0 W, MI|42.67323|-85.68010|741 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49348| 7704S_MADIS|JANESVILLE 4.9 N, WI|42.75430|-89.03430|938 feet|snowfall|2012-07-27 12|0.000|in|24|hours|53545| 7683S_MADIS|BERLIN 0.6 NNW, WI|43.97570|-88.94760|787 feet|snowfall|2012-07-27 12|0.000|in|24|hours|54923| 7675S_MADIS|SUAMICO 4.4 WNW, WI|44.66111|-88.11780|712 feet|snowfall|2012-07-27 12|0.000|in|24|hours|54313| 7580O_MADIS|SHELBY 0.4 SSE, MI|42.66594|-83.02870|692 feet|snowfall|2012-07-27 11|0.000|in|24|hours|48317| 7573O_MADIS|LOWELL 1.4 ESE, MI|42.92369|-85.32220|722 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49331| 7571O_MADIS|TRAVERSE CITY 4.1 E, MI|44.74662|-85.51930|656 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49686| 7493O_MADIS|EAST GRAND RAPIDS 0.7 SSW, MI|42.93801|-85.61340|748 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49506| 7401O_MADIS|GARDEN CORNERS 0.8 NW, MI|45.89815|-86.54850|581 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49835| 7209O_MADIS|WELLSTON 0.8 N, MI|44.22876|-85.95780|771 feet|snowfall|2012-07-26 16|0.000|in|24|hours|49689| 7199O_MADIS|HOUGHTON 1.6 ESE, MI|47.10774|-88.52940|715 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49931| 7197O_MADIS|HASLETT 1.2 N, MI|42.76997|-84.40310|873 feet|snowfall|2012-07-27 11|0.000|in|24|hours|48840| 7196O_MADIS|BEAVER ISLAND 5.9 NNW, MI|45.74985|-85.51030|574 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49782| 7147O_MADIS|MONROE COUNTY, MI|41.94960|-83.28010|577 feet|snowfall|2012-07-27 11|0.000|in|24|hours|48166| 7106O_MADIS|MARQUETTE COUNTY, MI|46.47310|-87.36780|719 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49855| 6907C_MADIS|BAYFIELD COUNTY, WI|46.16937|-90.98090|1503 feet|snowfall|2012-07-27 12|0.000|in|24|hours|54821| 6906O_MADIS|MADISON 3.7 WSW, WI|43.06230|-89.45650|948 feet|snowfall|2012-07-27 12|0.000|in|24|hours|53705| 6814H_MADIS|FREMONT 3.5 NNW, MI|43.51068|-85.96660|869 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49412| 6797H_MADIS|OAK PARK 1.5 S, IL|41.86592|-87.79280|620 feet|snowfall|2012-07-27 11|0.000|in|24|hours|60304| 6738C_MADIS|CROWN POINT 2.0 WSW, IN|41.40892|-87.38990|751 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46307| 6515O_MADIS|KANE COUNTY, IL|41.89503|-88.31140|741 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60134| 6499S_MADIS|NAPOLEON 0.3 NNW, OH|41.39793|-84.12900|666 feet|snowfall|2012-07-27 12|0.000|in|24|hours|43545| 6458C_MADIS|ELK GROVE VILLAGE 2.2 WSW, IL|41.99526|-88.05270|725 feet|snowfall|2012-07-27 11|0.000|in|24|hours|60007| 6388H_MADIS|SYRACUSE 0.9 SW, IN|41.41286|-85.75830|896 feet|snowfall|2012-07-27 11|0.000|in|24|hours|46567| 6201C_MADIS|MERRILL 7.0 W, WI|45.17746|-89.84820|1424 feet|snowfall|2012-07-27 11|0.000|in|24|hours|54452| 5850C_MADIS|CEDARBURG 0.8 NNE, WI|43.30855|-87.98480|830 feet|snowfall|2012-07-27 12|0.000|in|24|hours|53012| 5846C_MADIS|BAYFIELD 8.8 N, WI|46.93855|-90.83490|705 feet|snowfall|2012-07-27 12|0.000|in|24|hours|54814| 5795C_MADIS|WEYAUWEGA 0.1 S, WI|44.32130|-88.92860|801 feet|snowfall|2012-07-26 13|0.000|in|24|hours|54983| 5704S_MADIS|SAGINAW 3.0 NW, MI|43.45566|-83.98460|610 feet|snowfall|2012-07-27 12|0.000|in|24|hours|48603| 5665S_MADIS|TRAVERSE CITY 4.2 E, MI|44.74558|-85.51840|696 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49686| 5347B_MADIS|BIG RAPIDS 0.8 NE, MI|43.71075|-85.47240|935 feet|snowfall|2012-07-27 10|0.000|in|24|hours|49307| 5225S_MADIS|URBANA 0.3 ENE, IN|40.89899|-85.78720|817 feet|snowfall|2012-07-27 10|0.000|in|24|hours|46990| 5154C_MADIS|ELGIN 1.0 S, IL|42.02560|-88.28850|781 feet|snowfall|2012-07-27 11|0.000|in|24|hours|60123| 5122S_MADIS|FORT WAYNE 4.0 NE, IN|41.11755|-85.08920|810 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46815| 5109O_MADIS|HART 3 WSW, MI|43.67470|-86.42250|774 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49436| 5106S_MADIS|NEW LENOX 1.8 SE, IL|41.49964|-87.96030|705 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60451| 5099S_MADIS|HOMER GLEN 3.9 WNW, IL|41.63752|-88.00290|735 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60491| 5087B_MADIS|NORTHVILLE 1.5 SW, MI|42.42319|-83.51100|876 feet|snowfall|2012-07-27 11|0.000|in|24|hours|48167| 5066S_MADIS|ALGONQUIN 0.7 N, IL|42.17392|-88.29930|846 feet|snowfall|2012-07-27 11|0.000|in|24|hours|60102| 5024S_MADIS|MOMENCE 3.3 NE, IL|41.20188|-87.62490|715 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60954| 4988S_MADIS|AURORA 3.5 NE, IL|41.80891|-88.25280|745 feet|snowfall|2012-07-27 11|0.000|in|24|hours|60504| 4976S_MADIS|ARLINGTON HEIGHTS 1.2 SW, IL|42.08194|-87.99710|715 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60005| 4931O_MADIS|ST. JOHN 1.9 ENE, IN|41.45591|-87.44120|738 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46307| 4844B_MADIS|EAST JORDAN 1.6 SSE, MI|45.13460|-85.12300|587 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49727| 4773C_MADIS|KANE COUNTY, IL|41.84815|-88.31440|725 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60510| 4588C_MADIS|FULTON COUNTY, IN|41.08516|-86.22930|768 feet|snowfall|2012-07-27 10|0.000|in|24|hours|46975| 4580C_MADIS|GENEVA 1.6 ENE, IL|41.89409|-88.28840|751 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60134| 4226S_MADIS|WOODBURN 2.8 WSW, IN|41.11740|-84.90630|745 feet|snowfall|2012-07-27 09|0.000|in|24|hours|46797| 4133H_MADIS|WAUKESHA 2.1 SSW, WI|42.98472|-88.25310|820 feet|snowfall|2012-07-27 12|0.000|in|24|hours|53189| 4130H_MADIS|JACKSON 1.9 N, WI|43.34880|-88.15980|955 feet|snowfall|2012-07-27 12|0.000|in|24|hours|53037| 4128H_MADIS|HOLY HILL 2 E, WI|43.24215|-88.28890|984 feet|snowfall|2012-07-27 11|0.000|in|24|hours|53033| 4125H_MADIS|LAKE GENEVA 0.6 ENE, WI|42.59169|-88.41770|912 feet|snowfall|2012-07-27 12|0.000|in|24|hours|53147| 4120O_MADIS|ST. CHARLES 0.1 E, IL|41.92010|-88.29900|781 feet|snowfall|2012-07-26 13|0.000|in|24|hours|60174| 4119B_MADIS|FORT WAYNE 2.6 NE, IN|41.10262|-85.10830|814 feet|snowfall|2012-07-27 11|0.000|in|24|hours|46805| 4110H_MADIS|WEST ALLIS 0.7 SSE, WI|42.99802|-88.02380|771 feet|snowfall|2012-07-26 13|0.000|in|24|hours|53227| 4081H_MADIS|MCFARLAND 0.8 E, WI|43.01858|-89.27850|928 feet|snowfall|2012-07-27 12|0.000|in|24|hours|53558| 3949B_MADIS|CARLETON 2.5 S, MI|42.02125|-83.39450|610 feet|snowfall|2012-07-27 11|0.000|in|24|hours|48117| 3653S_MADIS|ALBION 3.7 S, IN|41.34161|-85.41560|945 feet|snowfall|2012-07-26 14|0.000|in|24|hours|46701| 3492O_MADIS|GAYLORD 1.8 ESE, MI|45.00932|-84.64680|1293 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49735| 3349B_MADIS|NEW LENOX 4.2 SE, IL|41.46807|-87.93780|728 feet|snowfall|2012-07-27 11|0.000|in|24|hours|60451| 3330O_MADIS|LINCOLNWOOD 1.8 E, IL|42.00187|-87.69850|607 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60645| 3328O_MADIS|EVANSTON 1.2 SSE, IL|42.03061|-87.68570|627 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60202| 3319B_MADIS|WELLSTON 3.9 WNW, MI|44.23370|-86.03580|728 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49689| 3276S_MADIS|ALSIP 0.2 E, IL|41.67031|-87.73120|610 feet|snowfall|2012-07-27 12|0.000|in|24|hours|60803| 3197B_MADIS|MILAN 0.4 ENE, OH|41.29115|-82.59340|669 feet|snowfall|2012-07-27 12|0.000|in|24|hours|44846| 3172B_MADIS|SANDUSKY 6.8 S, OH|41.35800|-82.72610|666 feet|snowfall|2012-07-27 12|0.000|in|24|hours|44870| 2865C_MADIS|FORT WAYNE 4.1 NE, IN|41.12066|-85.08950|817 feet|snowfall|2012-07-27 11|0.000|in|24|hours|46835| 2624B_MADIS|(AA9SH)LAGRO 5.2 NW, IN|40.89890|-85.78710|817 feet|snowfall|2012-07-27 11|0.000|in|24|hours|46990| 2621B_MADIS|(K9EQT)LOGANSPORT 3.9 NNW, IN|40.80540|-86.38580|748 feet|snowfall|2012-07-27 11|0.000|in|24|hours|46947| 2570B_MADIS|(KB9GPW)NORTH JUDSON 3.9 SW, IN|41.18030|-86.83270|725 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46366| 2511O_MADIS|FREDERIC 5.5 NNE, MI|44.83650|-84.72980|1332 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49733| 2415B_MADIS|MCCLURE 3.4 SSE, OH|41.32822|-83.90880|679 feet|snowfall|2012-07-27 11|0.000|in|24|hours|43534| 2384B_MADIS|HIBBING 2.5 W, MN|47.39410|-93.00180|1493 feet|snowfall|2012-07-27 11|0.000|in|24|hours|55746| 2166B_MADIS|LUCK 2.8 SSW, WI|45.54104|-92.49890|1257 feet|snowfall|2012-07-26 13|0.000|in|24|hours|54853| 1868B_MADIS|CHARLEVOIX 0.7 NE, MI|45.32008|-85.24370|627 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49720| 1863O_MADIS|ALLEN COUNTY, IN|41.04738|-85.27070|833 feet|snowfall|2012-07-27 12|0.000|in|24|hours|46804| 1614R_MADIS|PORT HURON 1.6 W, MI|42.99617|-82.46430|614 feet|snowfall|2012-07-26 13|0.000|in|24|hours|48060| 1548O_MADIS|DULUTH 12.8 NE, MN|46.93117|-91.94280|1093 feet|snowfall|2012-07-27 12|0.000|in|24|hours|55804| 1521H_MADIS|CECIL 0.3 N, OH|41.22402|-84.60220|712 feet|snowfall|2012-07-27 11|0.000|in|24|hours|45821| 1519H_MADIS|PORT CLINTON 2.5 W, OH|41.50300|-82.98640|610 feet|snowfall|2012-07-26 13|0.000|in|24|hours|43452| 1485H_MADIS|TOLEDO 2.4 ENE, OH|41.68228|-83.54120|597 feet|snowfall|2012-07-27 11|0.000|in|24|hours|43608| 1455H_MADIS|NAPOLEON 0.7 ESE, OH|41.38930|-84.11540|663 feet|snowfall|2012-07-26 13|0.000|in|24|hours|43545| 1410H_MADIS|DEFIANCE 0.9 E, OH|41.28117|-84.34540|709 feet|snowfall|2012-07-27 12|0.000|in|24|hours|43512| 1345O_MADIS|EAST TAWAS 0.8 WSW, MI|44.28322|-83.49920|587 feet|snowfall|2012-07-27 12|0.000|in|24|hours|48730| 1049B_MADIS|CHISHOLM 0.4 WSW, MN|47.48557|-92.88690|1549 feet|snowfall|2012-07-27 12|0.000|in|24|hours|55719| 0669S_MADIS|CHARLEVOIX COUNTY, MI|45.25720|-85.21650|774 feet|snowfall|2012-07-27 11|0.000|in|24|hours|49720| 0157O_MADIS|COLUMBIA CITY 6.6 SSE, IN|41.07590|-85.42170|873 feet|snowfall|2012-07-27 10|0.000|in|24|hours|46725| 0154O_MADIS|ALLEN COUNTY, IN|41.22849|-85.17220|846 feet|snowfall|2012-07-26 16|0.000|in|24|hours|46748| 0047B_MADIS|ELK RAPIDS 0.5 ESE, MI|44.89249|-85.39460|614 feet|snowfall|2012-07-27 12|0.000|in|24|hours|49629|