! 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| TRVM4|THREE RIVERS,MI|41.93330|-85.63330||snowfall|2011-07-28 11|0.000|cm|48|hours|49093| SNWI2|STREAMWOOD|42.01670|-88.16670||snowfall|2011-07-28 00|0.000|cm|12|hours|60107| SCOM4|SCOTTVILLE 2 SE|43.93310|-86.24530||snowfall|2011-07-28 11|0.000|cm|24|hours|49454| OSHM4|OSHTEMO,MI|42.26670|-85.68330||snowfall|2011-07-28 12|0.000|cm|24|hours|49009| ORD|O'HARE INTL AP|41.97940|-87.90440||snowfall|2011-07-28 12|0.000|cm|6|hours|60666| ONNM4|ONTONAGON 6SE|46.83430|-89.20740||snowfall|2011-07-27 22|0.000|cm|12|hours|49953| MQT|MARQUETTE, MI|46.53110|-87.54830||snowfall|2011-07-28 12|0.000|cm|6|hours|49866| MKG|MUSKEGON COUNTY AIRPORT|43.16940|-86.23810||snowfall|2011-07-28 12|0.000|cm|24|hours|49441| MHYI2|LOCK AND DAM|42.28330|-88.23330||snowfall|2011-07-27 13|0.000|cm|1|hours|60012| LOT|CHICAGO, IL|41.60830|-88.09390||snowfall|2011-07-28 12|0.000|cm|6|hours|60446| LAN|CAPITAL CITY AIRPORT|42.77860|-84.58720||snowfall|2011-07-28 12|0.000|cm|24|hours|48906| INAM4|1MI.WNW IONIA,MI|42.98330|-85.06670||snowfall|2011-07-28 12|0.000|cm|24|hours|48846| HTL|ROSCOMMON COUNTY AIRPORT|44.35000|-84.66670||snowfall|2011-07-28 12|0.000|cm|24|hours|48629| HRTM4|HART,MI|43.70000|-86.36670||snowfall|2011-07-28 11|0.000|cm|24|hours|49420| HOLM4|HOLLAND,MI|42.80000|-86.11670||snowfall|2011-07-28 11|0.000|cm|24|hours|49424| HASM4|WWTP|42.65000|-85.30000||snowfall|2011-07-28 11|0.000|cm|24|hours|49058| GRR|GRAND RAPIDS, MI|42.89390|-85.54470||snowfall|2011-07-28 12|0.000|cm|24|hours|49512| GRDM4|WWTP|43.06670|-86.20000||snowfall|2011-07-28 12|0.000|cm|24|hours|49456| GPDM4|44TH STREET|42.90000|-85.76670||snowfall|2011-07-28 11|0.000|cm|24|hours|49418| GGRM4|GREEN GARDEN NO.2|46.45330|-87.30380||snowfall|2011-07-27 15|0.000|cm|12|hours|49855| BLMM4|BLOOMINGDALE,MI|42.38330|-85.96670||snowfall|2011-07-28 10|0.000|cm|24|hours|49026| BGRM4|WATER WORKS|43.70000|-85.48330||snowfall|2011-07-28 11|0.000|cm|24|hours|49307| APN|PHELPS COLLINS FIELD|45.07810|-83.56030||snowfall|2011-07-28 12|0.000|cm|24|hours|49707| ANJ|SAULT STE MARIE|46.46670|-84.36670||snowfall|2011-07-28 12|0.000|cm|24|hours|49783| AHKM4|AHMEEK 1SW|47.29200|-88.42090||snowfall|2011-07-28 11|0.000|cm|12|hours|49913| 9883O_MADIS|BAY CITY 5.3 N, MI|43.66637|-83.90610|184 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|48706| 9882O_MADIS|MIKADO 2.3 SE, MI|44.56967|-83.38590|200 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|48745| 9729S_MADIS|STAR CITY 1.8 ESE, IN|40.95894|-86.52580|225 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|46985| 9642A_MADIS|ROSCOMMON 4.6 WSW, MI|44.46440|-84.67360|353 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|48653| 9620A_MADIS|COMMERCE 1.0 N, MI|42.61214|-83.49200|291 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|48382| 9599O_MADIS|VALPARAISO 1.8 N, IN|41.50270|-87.04600|256 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|46383| 9598O_MADIS|VALPARAISO 0.9 NNW, IN|41.48956|-87.05800|257 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46383| 9597O_MADIS|VALPARAISO 2.0 ESE, IN|41.46468|-87.01640|246 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46383| 9592O_MADIS|HEBRON 1.2 NW, IN|41.33220|-87.21550|219 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|46341| 9579O_MADIS|VALPARAISO 9.4 SSW, IN|41.36200|-87.14580|224 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46385| 9561A_MADIS|JONESVILLE 5.9 ENE, MI|42.01472|-84.56190|366 meters|snowfall|2011-07-28 09|0.000|cm|24|hours|49250| 9559A_MADIS|TRAVERSE CITY 4.0 WSW, MI|44.73390|-85.67890|287 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|49684| 9550S_MADIS|CADILLAC 4.0 NE, MI|44.28610|-85.35570|390 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49601| 9549A_MADIS|GRAND LEDGE 0.3 NNE, MI|42.75690|-84.74530|258 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|48837| 9532A_MADIS|MIDDLEVILLE 1.2 E, MI|42.71114|-85.44190|279 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49333| 9531A_MADIS|ALPENA 1.6 SSW, MI|45.05156|-83.44880|178 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49707| 9281C_MADIS|VALPARAISO 1.4 ENE, IN|41.48770|-87.02750|243 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46383| 9166S_MADIS|SYRACUSE 0.2 NNE, IN|41.42528|-85.74780|267 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46567| 9165S_MADIS|CLAYPOOL 3.7 NW, IN|41.17015|-85.92410|254 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|46510| 9145S_MADIS|DOWNERS GROVE 0.9 S, IL|41.78402|-88.01680|237 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60516| 8738S_MADIS|GENEVA 0.5 SW, IL|41.87730|-88.32120|228 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60134| 8733S_MADIS|STREAMWOOD 0.6 W, IL|42.02169|-88.18460|244 meters|snowfall|2011-07-28 01|0.000|cm|24|hours|60107| 8554A_MADIS|BURNETTSVILLE 9.9 NNW, IN|40.89772|-86.65250|214 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|47960| 8436A_MADIS|CROWN POINT 7.6 ESE, IN|41.39293|-87.21650|234 meters|snowfall|2011-07-27 15|0.000|cm|24|hours|46341| 8391O_MADIS|ANN ARBOR 3.1 SE, MI|42.23914|-83.69580|255 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|48108| 8387A_MADIS|MOUNT AYR 1.6 NNE, IN|40.97330|-87.29050|205 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|47978| 8337A_MADIS|LA PORTE 6.2 N, IN|41.69783|-86.70920|223 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46350| 8328A_MADIS|WANATAH 4.4 ESE, IN|41.40870|-86.80960|215 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46340| 8310O_MADIS|ANN ARBOR 3.0 SE, MI|42.24360|-83.69200|254 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|48108| 8274A_MADIS|RENSSELAER 6.2 SE, IN|40.86261|-87.08020|210 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|47978| 8259A_MADIS|RENSSELAER 1.9 SSW, IN|40.90845|-87.15860|205 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|47978| 8225S_MADIS|LAOTTO 0.5 NNW, IN|41.29725|-85.20040|262 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|46763| 8160A_MADIS|AUBURN 0.8 NE, IN|41.37045|-85.04570|268 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46706| 8134O_MADIS|MONTAGUE 8.1 NW, MI|43.50000|-86.47000|231 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49446| 8127A_MADIS|LOGANSPORT 2.2 NNW, IN|40.78220|-86.37400|222 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|46947| 8126O_MADIS|HANOVER 3.8 W, MI|42.10700|-84.62600|326 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49241| 8090A_MADIS|HUNTERTOWN 2.6 ESE, IN|41.21444|-85.12420|264 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|46845| 7981O_MADIS|JACKSON 3.2 W, MI|42.24061|-84.46690|310 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|49203| 7980O_MADIS|HORTON 4.6 SE, MI|42.09107|-84.47730|321 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|49246| 7973O_MADIS|TRAVERSE CITY 9.4 WSW, MI|44.71300|-85.78560|273 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|49684| 7916A_MADIS|BURR RIDGE 1.9 SW, IL|41.73194|-87.94860|224 meters|snowfall|2011-07-27 12|0.000|cm|24|hours|60527| 7907A_MADIS|GLEN ELLYN 1.4 SE, IL|41.85151|-88.04530|220 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|60137| 7872A_MADIS|CHICAGO 6.8 NNE, IL|41.93012|-87.63930|188 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|60614| 7799O_MADIS|SPALDING 0.5 NW, MI|45.69894|-87.51530|264 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|49874| 7768O_MADIS|WAYLAND 2.0 W, MI|42.67323|-85.68010|226 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49348| 7700O_MADIS|FORT WAYNE 9.3 N, IN|41.20750|-85.11650|256 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|46845| 7588O_MADIS|WAYNE COUNTY, MI|42.31400|-83.24500|185 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|48124| 7576O_MADIS|GRANDVILLE 1.3 WSW, MI|42.89716|-85.77910|187 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49418| 7573O_MADIS|LOWELL 1.4 ESE, MI|42.92369|-85.32220|220 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49331| 7401O_MADIS|GARDEN CORNERS 0.8 NW, MI|45.89815|-86.54850|177 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|49835| 7243C_MADIS|WINTHROP HARBOR 0.2 SSE, IL|42.47734|-87.82600|199 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60096| 7209O_MADIS|WELLSTON 0.8 N, MI|44.22876|-85.95780|235 meters|snowfall|2011-07-27 16|0.000|cm|24|hours|49689| 7197O_MADIS|HASLETT 1.2 N, MI|42.76997|-84.40310|266 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|48840| 7196O_MADIS|BEAVER ISLAND 5.9 NNW, MI|45.74985|-85.51030|175 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49782| 6815H_MADIS|WATERFORD 2.1 NW, MI|42.68742|-83.41320|300 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|48329| 6739C_MADIS|KINGSBURY 5.0 ENE, IN|41.55944|-86.60610|225 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46350| 6719C_MADIS|LOMBARD 1.0 NNW, IL|41.88841|-88.02290|220 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60148| 6623C_MADIS|WESTVILLE 4.7 ESE, IN|41.50638|-86.82710|238 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46382| 6388H_MADIS|SYRACUSE 0.9 SW, IN|41.41286|-85.75830|273 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|46567| 5850C_MADIS|CEDARBURG 0.8 NNE, WI|43.30855|-87.98480|253 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|53012| 5846C_MADIS|BAYFIELD 8.8 N, WI|46.93855|-90.83490|215 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|54814| 5704S_MADIS|SAGINAW 3.0 NW, MI|43.45566|-83.98460|186 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|48603| 5699S_MADIS|LUZERNE 2.4 NE, MI|44.64140|-84.23830|340 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|48636| 5676S_MADIS|GRAND RAPIDS 5.5 NNE, MI|43.03100|-85.61270|222 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|49525| 5668S_MADIS|LANSING 4.0 NNW, MI|42.76157|-84.58530|261 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|48906| 5546C_MADIS|NAPERVILLE 2.1 ESE, IL|41.75643|-88.11350|220 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60540| 5535C_MADIS|NAPERVILLE 3.2 ESE, IL|41.74233|-88.09820|230 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60565| 5506C_MADIS|DOWNERS GROVE 2.1 SE, IL|41.77162|-87.99400|239 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60516| 5497C_MADIS|LA GRANGE PARK 0.9 NE, IL|41.84070|-87.85960|193 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60526| 5368C_MADIS|LAKE COUNTY, IL|42.20816|-87.91880|206 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60069| 5225S_MADIS|URBANA 0.3 ENE, IN|40.89899|-85.78720|249 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46990| 5207S_MADIS|VALPARAISO 6.2 SW, IN|41.42227|-87.14600||snowfall|2011-07-27 20|0.000|cm|24|hours|46385| 5188S_MADIS|BOURBON 0.6 S, IN|41.28870|-86.11450|257 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46504| 5170S_MADIS|DE MOTTE 1.2 SSW, IN|41.18423|-87.20990|205 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46310| 5128S_MADIS|LOGANSPORT 1.7 ENE, IN|40.76031|-86.32700|199 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46947| 5109O_MADIS|HART 3 WSW, MI|43.67470|-86.42250|236 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49436| 5101S_MADIS|PLAINFIELD 3.0 ESE, IL|41.60400|-88.14900|191 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|60544| 5099S_MADIS|HOMER GLEN 3.9 WNW, IL|41.63752|-88.00290|224 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60491| 5066S_MADIS|ALGONQUIN 0.7 N, IL|42.17392|-88.29930|258 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|60102| 5021S_MADIS|ST. CHARLES 1.4 WSW, IL|41.90957|-88.32290||snowfall|2011-07-27 13|0.000|cm|24|hours|60174| 5019S_MADIS|GENEVA 1.3 SSW, IL|41.86442|-88.32320|221 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60134| 4989S_MADIS|ROSELLE 1.2 ESE, IL|41.97664|-88.05980|233 meters|snowfall|2011-07-27 15|0.000|cm|24|hours|60172| 4987S_MADIS|DARIEN 2.4 SSW, IL|41.71850|-87.99960|231 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60439| 4744O_MADIS|LA PORTE 1.3 ENE, IN|41.61144|-86.69070|243 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46350| 4598C_MADIS|KOSCIUSKO COUNTY, IN|41.40677|-85.69520|264 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|46567| 4588C_MADIS|FULTON COUNTY, IN|41.08516|-86.22930|234 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46975| 4230S_MADIS|LEO 2.2 NW, IN|41.22330|-85.05700|245 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|46765| 4131O_MADIS|MERRILLVILLE 1.6 ESE, IN|41.46209|-87.29680|220 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46410| 4131C_MADIS|HAMMOND 3.0 SW, IN|41.58649|-87.52430|186 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46324| 4128H_MADIS|HOLY HILL 2 E, WI|43.24215|-88.28890|300 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|53033| 4120O_MADIS|ST. CHARLES 0.1 E, IL|41.92010|-88.29900|238 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|60174| 4110H_MADIS|WEST ALLIS 0.7 SSE, WI|42.99802|-88.02380|235 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|53227| 3653S_MADIS|ALBION 3.7 S, IN|41.34161|-85.41560|288 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|46701| 3492O_MADIS|GAYLORD 1.8 ESE, MI|45.00932|-84.64680|394 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49735| 3280S_MADIS|AVILLA 2.4 W, IN|41.36586|-85.28490|305 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46710| 2905O_MADIS|TWIN LAKE 5.1 SSE, MI|43.29762|-86.15310|203 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|49457| 2511O_MADIS|FREDERIC 5.5 NNE, MI|44.83650|-84.72980|406 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|49733| 2505O_MADIS|WABASH 1.2 NNW, IN|40.81613|-85.82990|238 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|46992| 2353O_MADIS|ROCHESTER 7.0 NW, IN|41.12786|-86.29780|242 meters|snowfall|2011-07-28 09|0.000|cm|24|hours|46975| 1832R_MADIS|ALLEN COUNTY, IN|41.13380|-85.03070|243 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|46835| 1657O_MADIS|RENSSELAER 4.3 N, IN|40.99768|-87.16150|209 meters|snowfall|2011-07-28 12|0.000|cm|24|hours|47978| 1614R_MADIS|PORT HURON 1.6 W, MI|42.99617|-82.46430|187 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|48060| 1580H_MADIS|BOWLING GREEN 1.7 NW, OH|41.39121|-83.67510|204 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|43402| 1546H_MADIS|FREMONT 0.4 WNW, OH|41.35290|-83.12030|191 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|43420| 1521H_MADIS|CECIL 0.3 N, OH|41.22402|-84.60220|217 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|45821| 1519H_MADIS|PORT CLINTON 2.5 W, OH|41.50300|-82.98640|186 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|43452| 1459H_MADIS|BELLEVUE 0.6 N, OH|41.28386|-82.84080|224 meters|snowfall|2011-07-28 09|0.000|cm|24|hours|44811| 1453O_MADIS|TRAVERSE CITY 7.6 SSW, MI|44.65319|-85.66400|274 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49684| 1095O_MADIS|KOUTS 2.8 SSW, IN|41.28168|-87.05120|203 meters|snowfall|2011-07-27 13|0.000|cm|24|hours|46347| 1094O_MADIS|CROWN POINT 2.1 ENE, IN|41.43748|-87.32220|213 meters|snowfall|2011-07-27 14|0.000|cm|24|hours|46307| 0670S_MADIS|KALAMAZOO COUNTY, MI|42.26897|-85.47890|263 meters|snowfall|2011-07-28 11|0.000|cm|24|hours|49048| 0645B_MADIS|FORT WAYNE 7.0 N, IN|41.17410|-85.11830||snowfall|2011-07-27 14|0.000|cm|24|hours|46825| 0336O_MADIS|CLAYPOOL 1.2 E, IN|41.13047|-85.85750|280 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46510| 0157O_MADIS|COLUMBIA CITY 6.6 SSE, IN|41.07590|-85.42170|266 meters|snowfall|2011-07-28 10|0.000|cm|24|hours|46725| 0154O_MADIS|ALLEN COUNTY, IN|41.22849|-85.17220|258 meters|snowfall|2011-07-27 16|0.000|cm|24|hours|46748| 0047B_MADIS|ELK RAPIDS 0.5 ESE, MI|44.89249|-85.39460||snowfall|2011-07-28 12|0.000|cm|24|hours|49629| 0030B_MADIS|ANGOLA 0.5 ESE, IN|41.64133|-84.99070||snowfall|2011-07-28 12|0.000|cm|24|hours|46703| 0027B_MADIS|WINAMAC 4.5 NNE, IN|41.10803|-86.55730||snowfall|2011-07-27 13|0.000|cm|24|hours|46996| 0026B_MADIS|MOROCCO 2.9 NNE, IN|40.98689|-87.43970||snowfall|2011-07-28 12|0.000|cm|24|hours|47963|