! 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|297 meters|snowfall|2012-07-28 00|0.000|cm|12|hours|49870| WTNM4|3MI.W WATTON,MI|46.51030|-88.66670|436 meters|snowfall|2012-07-28 11|0.000|cm|12|hours|49970| WHKM4|4MI.E WHITE LAKE,MI|42.69750|-83.47220|313 meters|snowfall|2012-07-28 12|0.000|cm|6|hours|48386| SCOM4|SCOTTVILLE 2 SE|43.93310|-86.24530|203 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49454| RRVM4|RAPID RIVER 9S|45.78750|-86.93920|201 meters|snowfall|2012-07-28 11|0.000|cm|12|hours|49878| RNBW3|WFO GREEN BAY|44.49780|-88.11080|205 meters|snowfall|2012-07-28 11|0.000|cm|6|hours|54313| ORD|O'HARE INTL AP|41.97940|-87.90440|215 meters|snowfall|2012-07-28 12|0.000|cm|6|hours|60666| MQT|MARQUETTE, MI|46.53140|-87.54920|430 meters|snowfall|2012-07-28 12|0.000|cm|6|hours|49866| MKG|MUSKEGON COUNTY AIRPORT|43.16940|-86.23810|192 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49441| LOTI2|ROMEOVILLE WFO|41.60440|-88.08580|198 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60446| LAN|CAPITAL CITY AIRPORT|42.77860|-84.58720|258 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|48906| IWXI3|NORTHERN INDIANA WFO|41.35880|-85.69970|289 meters|snowfall|2012-07-28 12|0.000|cm|6|hours|46567| IRMM4|WWTP|46.46670|-90.18330|436 meters|snowfall|2012-07-28 12|0.000|cm|12|hours|49938| INAM4|1MI.WNW IONIA,MI|42.98330|-85.06670|203 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|48846| IHBM4|HOIST BASIN|46.58930|-87.69570|419 meters|snowfall|2012-07-28 12|0.000|cm|12|hours|49849| HTL|ROSCOMMON COUNTY AIRPORT|44.35000|-84.66670|349 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|48629| HASM4|WWTP|42.65000|-85.30000|239 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49058| GRRM4|NWS FORECAST OFFICE GRAND RAPIDS|42.89330|-85.54480|237 meters|snowfall|2012-07-28 12|0.000|cm|6|hours|49512| GRR|GRAND RAPIDS, MI|42.89390|-85.54470|242 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49512| GGRM4|GREEN GARDEN NO.2|46.45330|-87.30380|207 meters|snowfall|2012-07-28 12|0.000|cm|12|hours|49855| DPAI2|DUPAGE AIRPORT|41.90670|-88.24830|228 meters|snowfall|2012-07-27 18|0.000|cm|12|hours|60185| DLHM5|DULUTH NWS|46.83680|-92.21080|435 meters|snowfall|2012-07-28 06|0.000|cm|6|hours|55811| BGRM4|WATER WORKS|43.70000|-85.48330|281 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49307| AROM4|2MI.N ARNOLD,MI|46.06670|-87.48330|326 meters|snowfall|2012-07-28 12|0.000|cm|12|hours|49833| APXM4|S. 1.4MI. OTSEGO LAKE|44.90750|-84.71940|443 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49735| APN|PHELPS COLLINS FIELD|45.07810|-83.56030|204 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49707| ANJ|SAULT STE MARIE|46.46670|-84.36670|213 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49783| 9807S_MADIS|POTTERVILLE 0.3 ESE, MI|42.62587|-84.74140|280 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|48876| 9651A_MADIS|GRAND JUNCTION 1.3 ENE, MI|42.40926|-86.04810|208 meters|snowfall|2012-07-27 20|0.000|cm|24|hours|49056| 9598O_MADIS|VALPARAISO 0.9 NNW, IN|41.48956|-87.05800|257 meters|snowfall|2012-07-28 10|0.000|cm|24|hours|46383| 9591O_MADIS|CHESTERTON 4.2 E, IN|41.59433|-86.97520|212 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46304| 9583O_MADIS|PORTER 0.7 S, IN|41.61736|-87.08450|196 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46304| 9578O_MADIS|KOUTS 2.1 WSW, IN|41.30619|-87.06480|205 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|46347| 9571O_MADIS|ST. JOHN 0.2 WSW, IN|41.44627|-87.48020|220 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|46373| 9564A_MADIS|BAD AXE 0.5 SSW, MI|43.79614|-82.99960|231 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|48413| 9549A_MADIS|GRAND LEDGE 0.3 NNE, MI|42.75690|-84.74530|258 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|48837| 9531A_MADIS|ALPENA 1.6 SSW, MI|45.05156|-83.44880|178 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49707| 9390S_MADIS|FORT WAYNE 9.9 NNE, IN|41.21696|-85.08510|259 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46845| 8835S_MADIS|DULUTH 3.0 NE, MN|46.81528|-92.06370|247 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|55812| 8745S_MADIS|ORLAND PARK 4.6 WNW, IL|41.64330|-87.92810|212 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60467| 8428A_MADIS|CHESTERTON 1.7 WSW, IN|41.59486|-87.08990|194 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46304| 8391O_MADIS|ANN ARBOR 3.1 SE, MI|42.23914|-83.69580|255 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|48108| 8257A_MADIS|RENSSELAER 0.5 SSW, IN|40.92925|-87.15360|205 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|47978| 8180A_MADIS|ELKHART 4.8 SW, IN|41.64249|-86.04150|230 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46517| 8134O_MADIS|MONTAGUE 8.1 NW, MI|43.50000|-86.47000|231 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49446| 8112O_MADIS|SOUTH BEND 4.6 SE, IN|41.62090|-86.21520|273 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|46614| 8090A_MADIS|HUNTERTOWN 2.6 ESE, IN|41.21444|-85.12420|264 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46845| 8071A_MADIS|PEOTONE 0.4 ENE, IL|41.33361|-87.78910|222 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|60468| 8069A_MADIS|PEOTONE 0.5 ENE, IL|41.33297|-87.78760|222 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60468| 7980O_MADIS|HORTON 4.6 SE, MI|42.09107|-84.47730|321 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|49246| 7916A_MADIS|BURR RIDGE 1.9 SW, IL|41.73194|-87.94860|224 meters|snowfall|2012-07-27 12|0.000|cm|24|hours|60527| 7908A_MADIS|WHEATON 0.5 W, IL|41.85476|-88.11740|230 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60187| 7878A_MADIS|PALATINE 1.3 E, IL|42.11385|-88.01780|226 meters|snowfall|2012-07-27 15|0.000|cm|24|hours|60074| 7877A_MADIS|HOFFMAN ESTATES 4.6 W, IL|42.05971|-88.23340|253 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60120| 7768O_MADIS|WAYLAND 2.0 W, MI|42.67323|-85.68010|226 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49348| 7704S_MADIS|JANESVILLE 4.9 N, WI|42.75430|-89.03430|286 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|53545| 7683S_MADIS|BERLIN 0.6 NNW, WI|43.97570|-88.94760|240 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|54923| 7673S_MADIS|ASHLAND 0.5 WNW, WI|46.58240|-90.88390|210 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|54806| 7580O_MADIS|SHELBY 0.4 SSE, MI|42.66594|-83.02870|211 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|48317| 7401O_MADIS|GARDEN CORNERS 0.8 NW, MI|45.89815|-86.54850|177 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49835| 7209O_MADIS|WELLSTON 0.8 N, MI|44.22876|-85.95780|235 meters|snowfall|2012-07-27 16|0.000|cm|24|hours|49689| 7196O_MADIS|BEAVER ISLAND 5.9 NNW, MI|45.74985|-85.51030|175 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49782| 7092O_MADIS|OTSEGO COUNTY, MI|44.99783|-84.65310|405 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49735| 6907C_MADIS|BAYFIELD COUNTY, WI|46.16937|-90.98090|458 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|54821| 6906O_MADIS|MADISON 3.7 WSW, WI|43.06230|-89.45650|289 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|53705| 6797H_MADIS|OAK PARK 1.5 S, IL|41.86592|-87.79280|189 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|60304| 6738C_MADIS|CROWN POINT 2.0 WSW, IN|41.40892|-87.38990|229 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46307| 6570O_MADIS|DE MOTTE 0.8 NNW, IN|41.21043|-87.20540|200 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|46310| 6515O_MADIS|KANE COUNTY, IL|41.89503|-88.31140|226 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60134| 6347C_MADIS|OSHKOSH 5.2 N, WI|44.09351|-88.55310|239 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|54904| 6201C_MADIS|MERRILL 7.0 W, WI|45.17746|-89.84820|434 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|54452| 5846C_MADIS|BAYFIELD 8.8 N, WI|46.93855|-90.83490|215 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|54814| 5806C_MADIS|MANHATTAN 4.7 ENE, IL|41.45845|-87.90980|227 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60442| 5800C_MADIS|PARK FOREST 0.8 NNE, IL|41.49280|-87.68150|221 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60466| 5708S_MADIS|PAW PAW 3.6 NNE, MI|42.26582|-85.86190|223 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49079| 5704S_MADIS|SAGINAW 3.0 NW, MI|43.45566|-83.98460|186 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|48603| 5676S_MADIS|GRAND RAPIDS 5.5 NNE, MI|43.03100|-85.61270|222 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|49525| 5620C_MADIS|BATAVIA 1.5 WNW, IL|41.85937|-88.32750|219 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60510| 5497C_MADIS|LA GRANGE PARK 0.9 NE, IL|41.84070|-87.85960|193 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|60526| 5480H_MADIS|CLARE 0.3 W, MI|43.82400|-84.77100|256 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|48617| 5176S_MADIS|DE MOTTE 2.9 SE, IN|41.17556|-87.15400|208 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46392| 5170S_MADIS|DE MOTTE 1.2 SSW, IN|41.18423|-87.20990|205 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46310| 5109S_MADIS|FRANKFORT 2.0 NNE, IL|41.52392|-87.81950|213 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60423| 5106S_MADIS|NEW LENOX 1.8 SE, IL|41.49964|-87.96030|215 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60451| 5087B_MADIS|NORTHVILLE 1.5 SW, MI|42.42319|-83.51100|267 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|48167| 5066S_MADIS|ALGONQUIN 0.7 N, IL|42.17392|-88.29930|258 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60102| 5064S_MADIS|WONDER LAKE 0.8 WNW, IL|42.38354|-88.37090|256 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60097| 5041S_MADIS|LAKEMOOR 1.5 SE, IL|42.32880|-88.17990|238 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|60041| 5030S_MADIS|GRANT PARK 5.8 ENE, IL|41.27533|-87.54470|220 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60940| 5024S_MADIS|MOMENCE 3.3 NE, IL|41.20188|-87.62490|218 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60954| 4988S_MADIS|AURORA 3.5 NE, IL|41.80891|-88.25280|227 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60504| 4987S_MADIS|DARIEN 2.4 SSW, IL|41.71850|-87.99960|231 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|60439| 4845B_MADIS|CORNELL 4.1 W, WI|45.17024|-91.23610|316 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|54732| 4685B_MADIS|NORTH WEBSTER 2.3 N, IN|41.35866|-85.70060|291 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46567| 4588C_MADIS|FULTON COUNTY, IN|41.08516|-86.22930|234 meters|snowfall|2012-07-28 10|0.000|cm|24|hours|46975| 4228O_MADIS|STONE LAKE 2.0 NW, WI|45.85960|-91.57710|406 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|54876| 4227O_MADIS|EAST TROY 2.5 NNE, WI|42.82249|-88.38050|255 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|53120| 4179B_MADIS|PETOSKEY 3.9 SW, MI|45.32050|-85.00260|246 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49770| 4133H_MADIS|WAUKESHA 2.1 SSW, WI|42.98472|-88.25310|250 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|53189| 4128H_MADIS|HOLY HILL 2 E, WI|43.24215|-88.28890|300 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|53033| 4125H_MADIS|LAKE GENEVA 0.6 ENE, WI|42.59169|-88.41770|278 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|53147| 4120O_MADIS|ST. CHARLES 0.1 E, IL|41.92010|-88.29900|238 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|60174| 4119B_MADIS|FORT WAYNE 2.6 NE, IN|41.10262|-85.10830|248 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|46805| 4110H_MADIS|WEST ALLIS 0.7 SSE, WI|42.99802|-88.02380|235 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|53227| 4077B_MADIS|NEW LENOX 3.3 E, IL|41.51934|-87.91930|212 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60451| 3991B_MADIS|LAKE COUNTY, IL|42.19841|-87.81400|212 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60040| 3859B_MADIS|GREGORY 5.6 N, MI|42.54410|-84.06860|288 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|48137| 3769B_MADIS|NORTON SHORES 2.3 SSE, MI|43.12690|-86.24310|189 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49444| 3625O_MADIS|BATAVIA 1.3 WNW, IL|41.85917|-88.32210|222 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60510| 3492O_MADIS|GAYLORD 1.8 ESE, MI|45.00932|-84.64680|394 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49735| 3333O_MADIS|RIVERWOODS 0.4 ENE, IL|42.17264|-87.88840|209 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60015| 3319B_MADIS|WELLSTON 3.9 WNW, MI|44.23370|-86.03580|222 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49689| 2865C_MADIS|FORT WAYNE 4.1 NE, IN|41.12066|-85.08950|249 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|46835| 2621B_MADIS|(K9EQT)LOGANSPORT 3.9 NNW, IN|40.80540|-86.38580|228 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|46947| 2565B_MADIS|(WV90)HOBART 1.3 ENE, IN|41.54050|-87.24600|198 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|46342| 2539B_MADIS|CLOQUET 5.9 SW, MN|46.66803|-92.59010|394 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|55720| 2511O_MADIS|FREDERIC 5.5 NNE, MI|44.83650|-84.72980|406 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49733| 2384B_MADIS|HIBBING 2.5 W, MN|47.39410|-93.00180|455 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|55746| 2224B_MADIS|SUSSEX 3.4 W, WI|43.14425|-88.28540|307 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|53089| 2166B_MADIS|LUCK 2.8 SSW, WI|45.54104|-92.49890|383 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|54853| 2045B_MADIS|HARBOR SPRINGS 0.7 ENE, MI|45.43450|-84.97540|209 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|49740| 1966B_MADIS|DULUTH 3.2 NE, MN|46.81313|-92.05560|197 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|55812| 1722R_MADIS|HAYWARD 9.2 NNE, WI|46.13255|-91.40500|411 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|54843| 1614R_MADIS|PORT HURON 1.6 W, MI|42.99617|-82.46430|187 meters|snowfall|2012-07-27 12|0.000|cm|24|hours|48060| 1485H_MADIS|TOLEDO 2.4 ENE, OH|41.68228|-83.54120|182 meters|snowfall|2012-07-28 11|0.000|cm|24|hours|43608| 1455H_MADIS|NAPOLEON 0.7 ESE, OH|41.38930|-84.11540|202 meters|snowfall|2012-07-27 13|0.000|cm|24|hours|43545| 1439O_MADIS|BOURBONNAIS 1.5 NNE, IL|41.18297|-87.86930|212 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|60914| 1345O_MADIS|EAST TAWAS 0.8 WSW, MI|44.28322|-83.49920|179 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|48730| 1192O_MADIS|ONTONAGON 0.3 NE, MI|46.86955|-89.30930|195 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|49953| 1073B_MADIS|TOFTE 4.9 NE, MN|47.62394|-90.76100|286 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|00160| 1049B_MADIS|CHISHOLM 0.4 WSW, MN|47.48557|-92.88690|472 meters|snowfall|2012-07-28 12|0.000|cm|24|hours|55719| 0154O_MADIS|ALLEN COUNTY, IN|41.22849|-85.17220|258 meters|snowfall|2012-07-27 16|0.000|cm|24|hours|46748|