! 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| ZNOM4|NORWAY|45.77810|-87.89560|974 feet|snowfall|2012-07-20 12|0.000|in|12|hours|49870| WTNM4|3MI.W WATTON,MI|46.51030|-88.66670|1430 feet|snowfall|2012-07-20 11|0.000|in|12|hours|49970| WHKM4|4MI.E WHITE LAKE,MI|42.69750|-83.47220|1027 feet|snowfall|2012-07-21 06|0.000|in|6|hours|48386| SCOM4|SCOTTVILLE 2 SE|43.93310|-86.24530|666 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49454| RRVM4|RAPID RIVER 9S|45.78750|-86.93920|659 feet|snowfall|2012-07-20 11|0.000|in|12|hours|49878| RNBW3|WFO GREEN BAY|44.49780|-88.11080|673 feet|snowfall|2012-07-21 05|0.000|in|6|hours|54313| ORD|O'HARE INTL AP|41.97940|-87.90440|705 feet|snowfall|2012-07-21 06|0.000|in|6|hours|60666| MQT|MARQUETTE, MI|46.53140|-87.54920|1411 feet|snowfall|2012-07-21 00|0.000|in|12|hours|49866| MKG|MUSKEGON COUNTY AIRPORT|43.16940|-86.23810|630 feet|snowfall|2012-07-21 00|0.000|in|24|hours|49441| MHKM4|MOHAWK|47.30580|-88.36390|1033 feet|snowfall|2012-07-20 12|0.000|in|12|hours|49950| LOTI2|ROMEOVILLE WFO|41.60440|-88.08580|650 feet|snowfall|2012-07-21 06|0.000|in|6|hours|60446| LAN|CAPITAL CITY AIRPORT|42.77860|-84.58720|846 feet|snowfall|2012-07-21 00|0.000|in|24|hours|48906| IWXI3|NORTHERN INDIANA WFO|41.35880|-85.69970|948 feet|snowfall|2012-07-21 06|0.000|in|6|hours|46567| INAM4|1MI.WNW IONIA,MI|42.98330|-85.06670|666 feet|snowfall|2012-07-20 12|0.000|in|24|hours|48846| IHBM4|HOIST BASIN|46.58930|-87.69570|1375 feet|snowfall|2012-07-20 12|0.000|in|12|hours|49849| HTL|ROSCOMMON COUNTY AIRPORT|44.35000|-84.66670|1145 feet|snowfall|2012-07-21 00|0.000|in|24|hours|48629| HRTM4|HART,MI|43.70000|-86.36670|656 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49420| HOLM4|HOLLAND,MI|42.80000|-86.11670|607 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49424| HASM4|WWTP|42.65000|-85.30000|784 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49058| GRRM4|NWS FORECAST OFFICE GRAND RAPIDS|42.89330|-85.54480|778 feet|snowfall|2012-07-21 05|0.000|in|6|hours|49512| GRR|GRAND RAPIDS, MI|42.89390|-85.54470|794 feet|snowfall|2012-07-21 00|0.000|in|24|hours|49512| GRDM4|WWTP|43.06670|-86.20000|574 feet|snowfall|2012-07-20 12|0.000|in|24|hours|49456| GPDM4|44TH STREET|42.90000|-85.76670|617 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49418| GGRM4|GREEN GARDEN NO.2|46.45330|-87.30380|679 feet|snowfall|2012-07-20 13|0.000|in|12|hours|49855| DPAI2|DUPAGE AIRPORT|41.90670|-88.24830|748 feet|snowfall|2012-07-20 18|0.000|in|12|hours|60185| DLHM5|DULUTH NWS|46.83680|-92.21080|1427 feet|snowfall|2012-07-20 18|0.000|in|6|hours|55811| BRKM4|BARK RIVER|45.70940|-87.31310|761 feet|snowfall|2012-07-20 12|0.000|in|12|hours|49807| BGRM4|WATER WORKS|43.70000|-85.48330|922 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49307| AROM4|2MI.N ARNOLD,MI|46.06670|-87.48330|1070 feet|snowfall|2012-07-20 12|0.000|in|12|hours|49833| APXM4|S. 1.4MI. OTSEGO LAKE|44.90750|-84.71940|1453 feet|snowfall|2012-07-20 12|0.000|in|24|hours|49735| APN|PHELPS COLLINS FIELD|45.07810|-83.56030|669 feet|snowfall|2012-07-21 00|0.000|in|24|hours|49707| ANJ|SAULT STE MARIE|46.46670|-84.36670|699 feet|snowfall|2012-07-21 00|0.000|in|24|hours|49783| 9620A_MADIS|COMMERCE 1.0 N, MI|42.61214|-83.49200|955 feet|snowfall|2012-07-20 12|0.000|in|24|hours|48382| 9598O_MADIS|VALPARAISO 0.9 NNW, IN|41.48956|-87.05800|843 feet|snowfall|2012-07-20 10|0.000|in|24|hours|46383| 9561A_MADIS|JONESVILLE 5.9 ENE, MI|42.01472|-84.56190|1201 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49250| 9549S_MADIS|SAULT STE. MARIE 2.9 W, MI|46.48160|-84.42660|617 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49783| 9531A_MADIS|ALPENA 1.6 SSW, MI|45.05156|-83.44880|584 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49707| 9390S_MADIS|FORT WAYNE 9.9 NNE, IN|41.21696|-85.08510|850 feet|snowfall|2012-07-20 12|0.000|in|24|hours|46845| 8835S_MADIS|DULUTH 3.0 NE, MN|46.81528|-92.06370|810 feet|snowfall|2012-07-20 12|0.000|in|24|hours|55812| 8745S_MADIS|ORLAND PARK 4.6 WNW, IL|41.64330|-87.92810|696 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60467| 8733S_MADIS|STREAMWOOD 0.6 W, IL|42.02169|-88.18460|801 feet|snowfall|2012-07-21 01|0.000|in|24|hours|60107| 8372A_MADIS|PLYMOUTH 2.5 WSW, IN|41.32970|-86.35680|817 feet|snowfall|2012-07-20 09|0.000|in|24|hours|46563| 8134O_MADIS|MONTAGUE 8.1 NW, MI|43.50000|-86.47000|758 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49446| 8126O_MADIS|HANOVER 3.8 W, MI|42.10700|-84.62600|1070 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49241| 8122O_MADIS|CHASSELL 4.0 N, MI|47.08313|-88.52690|699 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49916| 8112O_MADIS|SOUTH BEND 4.6 SE, IN|41.62090|-86.21520|896 feet|snowfall|2012-07-20 11|0.000|in|24|hours|46614| 8090A_MADIS|HUNTERTOWN 2.6 ESE, IN|41.21444|-85.12420|866 feet|snowfall|2012-07-20 11|0.000|in|24|hours|46845| 8074A_MADIS|PLAINFIELD 2.4 SSE, IL|41.58191|-88.19370|584 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60544| 7878A_MADIS|PALATINE 1.3 E, IL|42.11385|-88.01780|741 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60074| 7768O_MADIS|WAYLAND 2.0 W, MI|42.67323|-85.68010|741 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49348| 7673S_MADIS|ASHLAND 0.5 WNW, WI|46.58240|-90.88390|689 feet|snowfall|2012-07-20 12|0.000|in|24|hours|54806| 7580O_MADIS|SHELBY 0.4 SSE, MI|42.66594|-83.02870|692 feet|snowfall|2012-07-20 11|0.000|in|24|hours|48317| 7576O_MADIS|GRANDVILLE 1.3 WSW, MI|42.89716|-85.77910|614 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49418| 7573O_MADIS|LOWELL 1.4 ESE, MI|42.92369|-85.32220|722 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49331| 7493O_MADIS|EAST GRAND RAPIDS 0.7 SSW, MI|42.93801|-85.61340|748 feet|snowfall|2012-07-20 12|0.000|in|24|hours|49506| 7401O_MADIS|GARDEN CORNERS 0.8 NW, MI|45.89815|-86.54850|581 feet|snowfall|2012-07-20 12|0.000|in|24|hours|49835| 7199O_MADIS|HOUGHTON 1.6 ESE, MI|47.10774|-88.52940|715 feet|snowfall|2012-07-20 12|0.000|in|24|hours|49931| 7196O_MADIS|BEAVER ISLAND 5.9 NNW, MI|45.74985|-85.51030|574 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49782| 7104O_MADIS|LAINGSBURG 5.0 SW, MI|42.84028|-84.41970|830 feet|snowfall|2012-07-20 11|0.000|in|24|hours|48808| 7092O_MADIS|OTSEGO COUNTY, MI|44.99783|-84.65310|1329 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49735| 6907C_MADIS|BAYFIELD COUNTY, WI|46.16937|-90.98090|1503 feet|snowfall|2012-07-20 12|0.000|in|24|hours|54821| 6797H_MADIS|OAK PARK 1.5 S, IL|41.86592|-87.79280|620 feet|snowfall|2012-07-20 11|0.000|in|24|hours|60304| 6738C_MADIS|CROWN POINT 2.0 WSW, IN|41.40892|-87.38990|751 feet|snowfall|2012-07-20 12|0.000|in|24|hours|46307| 6344C_MADIS|MOUNTAIN 1.1 SW, WI|45.17239|-88.48990|965 feet|snowfall|2012-07-20 12|0.000|in|24|hours|54149| 6201C_MADIS|MERRILL 7.0 W, WI|45.17746|-89.84820|1424 feet|snowfall|2012-07-20 11|0.000|in|24|hours|54452| 5795C_MADIS|WEYAUWEGA 0.1 S, WI|44.32130|-88.92860|801 feet|snowfall|2012-07-20 12|0.000|in|24|hours|54983| 5692S_MADIS|WHITE CLOUD 7.5 ENE, MI|43.60630|-85.64190|991 feet|snowfall|2012-07-21 01|0.000|in|24|hours|49349| 5620C_MADIS|BATAVIA 1.5 WNW, IL|41.85937|-88.32750|719 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60510| 5497C_MADIS|LA GRANGE PARK 0.9 NE, IL|41.84070|-87.85960|633 feet|snowfall|2012-07-20 13|0.000|in|24|hours|60526| 5480H_MADIS|CLARE 0.3 W, MI|43.82400|-84.77100|840 feet|snowfall|2012-07-20 11|0.000|in|24|hours|48617| 5207S_MADIS|VALPARAISO 6.2 SW, IN|41.42227|-87.14600|791 feet|snowfall|2012-07-20 15|0.000|in|24|hours|46385| 5109O_MADIS|HART 3 WSW, MI|43.67470|-86.42250|774 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49436| 5106S_MADIS|NEW LENOX 1.8 SE, IL|41.49964|-87.96030|705 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60451| 5087B_MADIS|NORTHVILLE 1.5 SW, MI|42.42319|-83.51100|876 feet|snowfall|2012-07-20 11|0.000|in|24|hours|48167| 5066S_MADIS|ALGONQUIN 0.7 N, IL|42.17392|-88.29930|846 feet|snowfall|2012-07-20 11|0.000|in|24|hours|60102| 4799C_MADIS|LEESBURG 0.1 WNW, IN|41.32988|-85.85070|860 feet|snowfall|2012-07-20 10|0.000|in|24|hours|46538| 4685B_MADIS|NORTH WEBSTER 2.3 N, IN|41.35866|-85.70060|955 feet|snowfall|2012-07-20 12|0.000|in|24|hours|46567| 4588C_MADIS|FULTON COUNTY, IN|41.08516|-86.22930|768 feet|snowfall|2012-07-20 10|0.000|in|24|hours|46975| 4314B_MADIS|LAND O' LAKES 7.7 WSW, WI|46.14347|-89.37520|1726 feet|snowfall|2012-07-20 12|0.000|in|24|hours|54540| 4228O_MADIS|STONE LAKE 2.0 NW, WI|45.85960|-91.57710|1332 feet|snowfall|2012-07-20 12|0.000|in|24|hours|54876| 4227O_MADIS|EAST TROY 2.5 NNE, WI|42.82249|-88.38050|837 feet|snowfall|2012-07-20 12|0.000|in|24|hours|53120| 4133H_MADIS|WAUKESHA 2.1 SSW, WI|42.98472|-88.25310|820 feet|snowfall|2012-07-20 12|0.000|in|24|hours|53189| 4130O_MADIS|NAPERVILLE 3.6 SSW, IL|41.71461|-88.18070|682 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60564| 4130H_MADIS|JACKSON 1.9 N, WI|43.34880|-88.15980|955 feet|snowfall|2012-07-20 12|0.000|in|24|hours|53037| 4125H_MADIS|LAKE GENEVA 0.6 ENE, WI|42.59169|-88.41770|912 feet|snowfall|2012-07-20 12|0.000|in|24|hours|53147| 4120O_MADIS|ST. CHARLES 0.1 E, IL|41.92010|-88.29900|781 feet|snowfall|2012-07-20 13|0.000|in|24|hours|60174| 4119B_MADIS|FORT WAYNE 2.6 NE, IN|41.10262|-85.10830|814 feet|snowfall|2012-07-20 11|0.000|in|24|hours|46805| 4089H_MADIS|WHITEWATER 1.3 NW, WI|42.84799|-88.75420|840 feet|snowfall|2012-07-20 12|0.000|in|24|hours|53190| 4087H_MADIS|FOND DU LAC 1.0 WSW, WI|43.76747|-88.46440|771 feet|snowfall|2012-07-20 11|0.000|in|24|hours|54935| 3625O_MADIS|BATAVIA 1.3 WNW, IL|41.85917|-88.32210|728 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60510| 3622B_MADIS|JOLIET 1.4 ENE, IL|41.53550|-88.09760|656 feet|snowfall|2012-07-20 11|0.000|in|24|hours|60435| 3492O_MADIS|GAYLORD 1.8 ESE, MI|45.00932|-84.64680|1293 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49735| 3330O_MADIS|LINCOLNWOOD 1.8 E, IL|42.00187|-87.69850|607 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60645| 3319B_MADIS|WELLSTON 3.9 WNW, MI|44.23370|-86.03580|728 feet|snowfall|2012-07-20 12|0.000|in|24|hours|49689| 3305O_MADIS|WASHINGTON COUNTY, WI|43.32007|-88.16820|896 feet|snowfall|2012-07-20 11|0.000|in|24|hours|53037| 2874B_MADIS|PISTAKEE HIGHLANDS 0.4 SW, IL|42.39865|-88.21700|794 feet|snowfall|2012-07-20 12|0.000|in|24|hours|60050| 2865C_MADIS|FORT WAYNE 4.1 NE, IN|41.12066|-85.08950|817 feet|snowfall|2012-07-20 11|0.000|in|24|hours|46835| 2703B_MADIS|MARQUETTE 16.0 NW, MI|46.71000|-87.64000|899 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49861| 2650B_MADIS|DULUTH 2.0 NNE, MN|46.81091|-92.09180|1079 feet|snowfall|2012-07-20 12|0.000|in|24|hours|55805| 2511O_MADIS|FREDERIC 5.5 NNE, MI|44.83650|-84.72980|1332 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49733| 2166B_MADIS|LUCK 2.8 SSW, WI|45.54104|-92.49890|1257 feet|snowfall|2012-07-20 11|0.000|in|24|hours|54853| 2036R_MADIS|KALAMAZOO 2.3 NE, MI|42.30141|-85.56140|843 feet|snowfall|2012-07-20 23|0.000|in|24|hours|49048| 1964B_MADIS|SILVER BAY 2.7 ENE, MN|47.31454|-91.23010|745 feet|snowfall|2012-07-20 12|0.000|in|24|hours|55614| 1868B_MADIS|CHARLEVOIX 0.7 NE, MI|45.32008|-85.24370|627 feet|snowfall|2012-07-20 11|0.000|in|24|hours|49720| 1722R_MADIS|HAYWARD 9.2 NNE, WI|46.13255|-91.40500|1348 feet|snowfall|2012-07-20 11|0.000|in|24|hours|54843| 1657O_MADIS|RENSSELAER 4.3 N, IN|40.99768|-87.16150|686 feet|snowfall|2012-07-20 12|0.000|in|24|hours|47978| 1614R_MADIS|PORT HURON 1.6 W, MI|42.99617|-82.46430|614 feet|snowfall|2012-07-20 09|0.000|in|24|hours|48060| 1548O_MADIS|DULUTH 12.8 NE, MN|46.93117|-91.94280|1093 feet|snowfall|2012-07-20 12|0.000|in|24|hours|55804| 1524B_MADIS|DULUTH 1.4 NNW, MN|46.80321|-92.11240|1204 feet|snowfall|2012-07-20 13|0.000|in|24|hours|55811| 1485H_MADIS|TOLEDO 2.4 ENE, OH|41.68228|-83.54120|597 feet|snowfall|2012-07-20 11|0.000|in|24|hours|43608| 1345O_MADIS|EAST TAWAS 0.8 WSW, MI|44.28322|-83.49920|587 feet|snowfall|2012-07-20 12|0.000|in|24|hours|48730| 1073B_MADIS|TOFTE 4.9 NE, MN|47.62394|-90.76100|938 feet|snowfall|2012-07-20 12|0.000|in|24|hours|00160| 1049B_MADIS|CHISHOLM 0.4 WSW, MN|47.48557|-92.88690|1549 feet|snowfall|2012-07-20 12|0.000|in|24|hours|55719| 0433B_MADIS|CROMWELL 2.7 SW, IN|41.37748|-85.65250|879 feet|snowfall|2012-07-20 10|0.000|in|24|hours|46732|