! 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|in|48|hours|49093| SNWI2|STREAMWOOD|42.01670|-88.16670||snowfall|2011-07-29 00|0.000|in|12|hours|60107| SCOM4|SCOTTVILLE 2 SE|43.93310|-86.24530||snowfall|2011-07-28 11|0.000|in|24|hours|49454| OSHM4|OSHTEMO,MI|42.26670|-85.68330||snowfall|2011-07-28 12|0.000|in|24|hours|49009| ORD|O'HARE INTL AP|41.97940|-87.90440||snowfall|2011-07-29 00|0.000|in|6|hours|60666| MQT|MARQUETTE, MI|46.53110|-87.54830||snowfall|2011-07-29 00|0.000|in|6|hours|49866| MKG|MUSKEGON COUNTY AIRPORT|43.16940|-86.23810||snowfall|2011-07-29 00|0.000|in|24|hours|49441| LOT|CHICAGO, IL|41.60830|-88.09390||snowfall|2011-07-29 00|0.000|in|6|hours|60446| LAN|CAPITAL CITY AIRPORT|42.77860|-84.58720||snowfall|2011-07-29 00|0.000|in|24|hours|48906| INAM4|1MI.WNW IONIA,MI|42.98330|-85.06670||snowfall|2011-07-28 12|0.000|in|24|hours|48846| HTL|ROSCOMMON COUNTY AIRPORT|44.35000|-84.66670||snowfall|2011-07-29 00|0.000|in|24|hours|48629| HRTM4|HART,MI|43.70000|-86.36670||snowfall|2011-07-28 11|0.000|in|24|hours|49420| HOLM4|HOLLAND,MI|42.80000|-86.11670||snowfall|2011-07-28 11|0.000|in|24|hours|49424| HASM4|WWTP|42.65000|-85.30000||snowfall|2011-07-28 11|0.000|in|24|hours|49058| GRR|GRAND RAPIDS, MI|42.89390|-85.54470||snowfall|2011-07-29 00|0.000|in|24|hours|49512| GRDM4|WWTP|43.06670|-86.20000||snowfall|2011-07-28 12|0.000|in|24|hours|49456| GPDM4|44TH STREET|42.90000|-85.76670||snowfall|2011-07-28 11|0.000|in|24|hours|49418| GGRM4|GREEN GARDEN NO.2|46.45330|-87.30380||snowfall|2011-07-28 16|0.000|in|12|hours|49855| BLMM4|BLOOMINGDALE,MI|42.38330|-85.96670||snowfall|2011-07-28 10|0.000|in|24|hours|49026| BGRM4|WATER WORKS|43.70000|-85.48330||snowfall|2011-07-28 11|0.000|in|24|hours|49307| APN|PHELPS COLLINS FIELD|45.07810|-83.56030||snowfall|2011-07-29 00|0.000|in|24|hours|49707| ANJ|SAULT STE MARIE|46.46670|-84.36670||snowfall|2011-07-29 00|0.000|in|24|hours|49783| AHKM4|AHMEEK 1SW|47.29200|-88.42090||snowfall|2011-07-28 11|0.000|in|12|hours|49913| 9883O_MADIS|BAY CITY 5.3 N, MI|43.66637|-83.90610|604 feet|snowfall|2011-07-28 12|0.000|in|24|hours|48706| 9882O_MADIS|MIKADO 2.3 SE, MI|44.56967|-83.38590|656 feet|snowfall|2011-07-28 11|0.000|in|24|hours|48745| 9729S_MADIS|STAR CITY 1.8 ESE, IN|40.95894|-86.52580|738 feet|snowfall|2011-07-28 12|0.000|in|24|hours|46985| 9651A_MADIS|GRAND JUNCTION 1.3 ENE, MI|42.40926|-86.04810|682 feet|snowfall|2011-07-28 20|0.000|in|24|hours|49056| 9642A_MADIS|ROSCOMMON 4.6 WSW, MI|44.46440|-84.67360|1158 feet|snowfall|2011-07-28 11|0.000|in|24|hours|48653| 9620A_MADIS|COMMERCE 1.0 N, MI|42.61214|-83.49200|955 feet|snowfall|2011-07-28 11|0.000|in|24|hours|48382| 9599O_MADIS|VALPARAISO 1.8 N, IN|41.50270|-87.04600|840 feet|snowfall|2011-07-28 11|0.000|in|24|hours|46383| 9598O_MADIS|VALPARAISO 0.9 NNW, IN|41.48956|-87.05800|843 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46383| 9564A_MADIS|BAD AXE 0.5 SSW, MI|43.79614|-82.99960|758 feet|snowfall|2011-07-28 13|0.000|in|24|hours|48413| 9561A_MADIS|JONESVILLE 5.9 ENE, MI|42.01472|-84.56190|1201 feet|snowfall|2011-07-28 09|0.000|in|24|hours|49250| 9559A_MADIS|TRAVERSE CITY 4.0 WSW, MI|44.73390|-85.67890|942 feet|snowfall|2011-07-28 14|0.000|in|24|hours|49684| 9550S_MADIS|CADILLAC 4.0 NE, MI|44.28610|-85.35570|1280 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49601| 9549A_MADIS|GRAND LEDGE 0.3 NNE, MI|42.75690|-84.74530|846 feet|snowfall|2011-07-28 12|0.000|in|24|hours|48837| 9532A_MADIS|MIDDLEVILLE 1.2 E, MI|42.71114|-85.44190|915 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49333| 9531A_MADIS|ALPENA 1.6 SSW, MI|45.05156|-83.44880|584 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49707| 9281C_MADIS|VALPARAISO 1.4 ENE, IN|41.48770|-87.02750|797 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46383| 9166S_MADIS|SYRACUSE 0.2 NNE, IN|41.42528|-85.74780|876 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46567| 9165S_MADIS|CLAYPOOL 3.7 NW, IN|41.17015|-85.92410|833 feet|snowfall|2011-07-28 12|0.000|in|24|hours|46510| 9162S_MADIS|RENSSELAER 1.9 N, IN|40.96239|-87.15270|692 feet|snowfall|2011-07-28 13|0.000|in|24|hours|47978| 8887S_MADIS|NAPOLEON 3.8 S, OH|41.33970|-84.11960|689 feet|snowfall|2011-07-28 11|0.000|in|24|hours|43545| 8733S_MADIS|STREAMWOOD 0.6 W, IL|42.02169|-88.18460|801 feet|snowfall|2011-07-28 01|0.000|in|24|hours|60107| 8554A_MADIS|BURNETTSVILLE 9.9 NNW, IN|40.89772|-86.65250|702 feet|snowfall|2011-07-28 20|0.000|in|24|hours|47960| 8391O_MADIS|ANN ARBOR 3.1 SE, MI|42.23914|-83.69580|837 feet|snowfall|2011-07-28 11|0.000|in|24|hours|48108| 8274A_MADIS|RENSSELAER 6.2 SE, IN|40.86261|-87.08020|689 feet|snowfall|2011-07-28 12|0.000|in|24|hours|47978| 8259A_MADIS|RENSSELAER 1.9 SSW, IN|40.90845|-87.15860|673 feet|snowfall|2011-07-28 11|0.000|in|24|hours|47978| 8225S_MADIS|LAOTTO 0.5 NNW, IN|41.29725|-85.20040|860 feet|snowfall|2011-07-28 11|0.000|in|24|hours|46763| 8160A_MADIS|AUBURN 0.8 NE, IN|41.37045|-85.04570|879 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46706| 8134O_MADIS|MONTAGUE 8.1 NW, MI|43.50000|-86.47000|758 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49446| 8127A_MADIS|LOGANSPORT 2.2 NNW, IN|40.78220|-86.37400|728 feet|snowfall|2011-07-28 12|0.000|in|24|hours|46947| 8126O_MADIS|HANOVER 3.8 W, MI|42.10700|-84.62600|1070 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49241| 8090A_MADIS|HUNTERTOWN 2.6 ESE, IN|41.21444|-85.12420|866 feet|snowfall|2011-07-28 12|0.000|in|24|hours|46845| 7799O_MADIS|SPALDING 0.5 NW, MI|45.69894|-87.51530|866 feet|snowfall|2011-07-28 12|0.000|in|24|hours|49874| 7768O_MADIS|WAYLAND 2.0 W, MI|42.67323|-85.68010|741 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49348| 7700O_MADIS|FORT WAYNE 9.3 N, IN|41.20750|-85.11650|840 feet|snowfall|2011-07-28 11|0.000|in|24|hours|46845| 7588O_MADIS|WAYNE COUNTY, MI|42.31400|-83.24500|607 feet|snowfall|2011-07-28 11|0.000|in|24|hours|48124| 7576O_MADIS|GRANDVILLE 1.3 WSW, MI|42.89716|-85.77910|614 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49418| 7573O_MADIS|LOWELL 1.4 ESE, MI|42.92369|-85.32220|722 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49331| 7401O_MADIS|GARDEN CORNERS 0.8 NW, MI|45.89815|-86.54850|581 feet|snowfall|2011-07-28 12|0.000|in|24|hours|49835| 7215O_MADIS|JENISON 1.0 NE, MI|42.92046|-85.81730|630 feet|snowfall|2011-07-28 13|0.000|in|24|hours|49428| 7197O_MADIS|HASLETT 1.2 N, MI|42.76997|-84.40310|873 feet|snowfall|2011-07-28 11|0.000|in|24|hours|48840| 7196O_MADIS|BEAVER ISLAND 5.9 NNW, MI|45.74985|-85.51030|574 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49782| 6388H_MADIS|SYRACUSE 0.9 SW, IN|41.41286|-85.75830|896 feet|snowfall|2011-07-28 11|0.000|in|24|hours|46567| 5850C_MADIS|CEDARBURG 0.8 NNE, WI|43.30855|-87.98480|830 feet|snowfall|2011-07-28 12|0.000|in|24|hours|53012| 5846C_MADIS|BAYFIELD 8.8 N, WI|46.93855|-90.83490|705 feet|snowfall|2011-07-28 12|0.000|in|24|hours|54814| 5704S_MADIS|SAGINAW 3.0 NW, MI|43.45566|-83.98460|610 feet|snowfall|2011-07-28 12|0.000|in|24|hours|48603| 5699S_MADIS|LUZERNE 2.4 NE, MI|44.64140|-84.23830|1115 feet|snowfall|2011-07-28 11|0.000|in|24|hours|48636| 5668S_MADIS|LANSING 4.0 NNW, MI|42.76157|-84.58530|856 feet|snowfall|2011-07-28 11|0.000|in|24|hours|48906| 5225S_MADIS|URBANA 0.3 ENE, IN|40.89899|-85.78720|817 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46990| 5188S_MADIS|BOURBON 0.6 S, IN|41.28870|-86.11450|843 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46504| 5154C_MADIS|ELGIN 1.0 S, IL|42.02560|-88.28850|781 feet|snowfall|2011-07-28 13|0.000|in|24|hours|60123| 5128S_MADIS|LOGANSPORT 1.7 ENE, IN|40.76031|-86.32700|653 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46947| 5109O_MADIS|HART 3 WSW, MI|43.67470|-86.42250|774 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49436| 5099S_MADIS|HOMER GLEN 3.9 WNW, IL|41.63752|-88.00290|735 feet|snowfall|2011-07-28 13|0.000|in|24|hours|60491| 5066S_MADIS|ALGONQUIN 0.7 N, IL|42.17392|-88.29930|846 feet|snowfall|2011-07-28 12|0.000|in|24|hours|60102| 4931O_MADIS|ST. JOHN 1.9 ENE, IN|41.45591|-87.44120|738 feet|snowfall|2011-07-28 12|0.000|in|24|hours|46307| 4598C_MADIS|KOSCIUSKO COUNTY, IN|41.40677|-85.69520|866 feet|snowfall|2011-07-28 11|0.000|in|24|hours|46567| 4588C_MADIS|FULTON COUNTY, IN|41.08516|-86.22930|768 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46975| 4230S_MADIS|LEO 2.2 NW, IN|41.22330|-85.05700|804 feet|snowfall|2011-07-28 11|0.000|in|24|hours|46765| 4128H_MADIS|HOLY HILL 2 E, WI|43.24215|-88.28890|984 feet|snowfall|2011-07-28 11|0.000|in|24|hours|53033| 4120O_MADIS|ST. CHARLES 0.1 E, IL|41.92010|-88.29900|781 feet|snowfall|2011-07-28 13|0.000|in|24|hours|60174| 4110H_MADIS|WEST ALLIS 0.7 SSE, WI|42.99802|-88.02380|771 feet|snowfall|2011-07-28 13|0.000|in|24|hours|53227| 3492O_MADIS|GAYLORD 1.8 ESE, MI|45.00932|-84.64680|1293 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49735| 3280S_MADIS|AVILLA 2.4 W, IN|41.36586|-85.28490|1001 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46710| 2511O_MADIS|FREDERIC 5.5 NNE, MI|44.83650|-84.72980|1332 feet|snowfall|2011-07-28 10|0.000|in|24|hours|49733| 2505O_MADIS|WABASH 1.2 NNW, IN|40.81613|-85.82990|781 feet|snowfall|2011-07-28 11|0.000|in|24|hours|46992| 2353O_MADIS|ROCHESTER 7.0 NW, IN|41.12786|-86.29780|794 feet|snowfall|2011-07-28 09|0.000|in|24|hours|46975| 1832R_MADIS|ALLEN COUNTY, IN|41.13380|-85.03070|797 feet|snowfall|2011-07-28 11|0.000|in|24|hours|46835| 1657O_MADIS|RENSSELAER 4.3 N, IN|40.99768|-87.16150|686 feet|snowfall|2011-07-28 12|0.000|in|24|hours|47978| 1580H_MADIS|BOWLING GREEN 1.7 NW, OH|41.39121|-83.67510|669 feet|snowfall|2011-07-28 10|0.000|in|24|hours|43402| 1546H_MADIS|FREMONT 0.4 WNW, OH|41.35290|-83.12030|627 feet|snowfall|2011-07-28 11|0.000|in|24|hours|43420| 1521H_MADIS|CECIL 0.3 N, OH|41.22402|-84.60220|712 feet|snowfall|2011-07-28 11|0.000|in|24|hours|45821| 1459H_MADIS|BELLEVUE 0.6 N, OH|41.28386|-82.84080|735 feet|snowfall|2011-07-28 09|0.000|in|24|hours|44811| 1453O_MADIS|TRAVERSE CITY 7.6 SSW, MI|44.65319|-85.66400|899 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49684| 0670S_MADIS|KALAMAZOO COUNTY, MI|42.26897|-85.47890|863 feet|snowfall|2011-07-28 11|0.000|in|24|hours|49048| 0645B_MADIS|FORT WAYNE 7.0 N, IN|41.17410|-85.11830||snowfall|2011-07-28 14|0.000|in|24|hours|46825| 0336O_MADIS|CLAYPOOL 1.2 E, IN|41.13047|-85.85750|919 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46510| 0157O_MADIS|COLUMBIA CITY 6.6 SSE, IN|41.07590|-85.42170|873 feet|snowfall|2011-07-28 10|0.000|in|24|hours|46725| 0155R_MADIS|CARLTON 5.6 NE, MN|46.70783|-92.32790|1188 feet|snowfall|2011-07-28 14|0.000|in|24|hours|55733| 0154O_MADIS|ALLEN COUNTY, IN|41.22849|-85.17220|846 feet|snowfall|2011-07-28 16|0.000|in|24|hours|46748| 0047B_MADIS|ELK RAPIDS 0.5 ESE, MI|44.89249|-85.39460||snowfall|2011-07-28 12|0.000|in|24|hours|49629| 0030B_MADIS|ANGOLA 0.5 ESE, IN|41.64133|-84.99070||snowfall|2011-07-28 12|0.000|in|24|hours|46703| 0027B_MADIS|WINAMAC 4.5 NNE, IN|41.10803|-86.55730||snowfall|2011-07-28 13|0.000|in|24|hours|46996| 0026B_MADIS|MOROCCO 2.9 NNE, IN|40.98689|-87.43970||snowfall|2011-07-28 12|0.000|in|24|hours|47963|