! 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| SNWI2|STREAMWOOD|42.01670|-88.16670|810 feet|snowfall|2011-07-24 00|0.000|in|12|hours|60107| SCOM4|SCOTTVILLE 2 SE|43.93310|-86.24530|666 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49454| ORD|O'HARE INTL AP|41.97940|-87.90440|705 feet|snowfall|2011-07-24 12|0.000|in|6|hours|60666| MRIM4|MORENCI,MI|41.71670|-84.20000|764 feet|snowfall|2011-07-24 12|0.000|in|48|hours|49256| MQT|MARQUETTE, MI|46.53110|-87.54830|1434 feet|snowfall|2011-07-24 12|0.000|in|6|hours|49866| MKG|MUSKEGON COUNTY AIRPORT|43.16940|-86.23810|630 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49441| LOT|CHICAGO, IL|41.60830|-88.09390|656 feet|snowfall|2011-07-24 12|0.000|in|6|hours|60446| LAN|CAPITAL CITY AIRPORT|42.77860|-84.58720|846 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48906| INAM4|1MI.WNW IONIA,MI|42.98330|-85.06670|666 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48846| HTL|ROSCOMMON COUNTY AIRPORT|44.35000|-84.66670|1145 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48629| HRTM4|HART,MI|43.70000|-86.36670|656 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49420| HOLM4|HOLLAND,MI|42.80000|-86.11670|607 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49424| HASM4|WWTP|42.65000|-85.30000|784 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49058| GRR|GRAND RAPIDS, MI|42.89390|-85.54470|794 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49512| GPDM4|44TH STREET|42.90000|-85.76670|617 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49418| GGRM4|GREEN GARDEN NO.2|46.45330|-87.30380|679 feet|snowfall|2011-07-23 13|0.000|in|12|hours|49855| BGRM4|WATER WORKS|43.70000|-85.48330|922 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49307| APN|PHELPS COLLINS FIELD|45.07810|-83.56030|669 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49707| ANJ|SAULT STE MARIE|46.46670|-84.36670|699 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49783| AHKM4|AHMEEK 1SW|47.29200|-88.42090|1096 feet|snowfall|2011-07-24 11|0.000|in|12|hours|49913| 9883O_MADIS|BAY CITY 5.3 N, MI|43.66637|-83.90610|604 feet|snowfall|2011-07-23 12|0.000|in|24|hours|48706| 9882O_MADIS|MIKADO 2.3 SE, MI|44.56967|-83.38590|656 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48745| 9635A_MADIS|HUDSONVILLE 0.3 E, MI|42.86530|-85.85740|659 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49426| 9620S_MADIS|CRANDON 0.3 N, WI|45.57401|-88.89830|1644 feet|snowfall|2011-07-23 13|0.000|in|24|hours|54520| 9599O_MADIS|VALPARAISO 1.8 N, IN|41.50270|-87.04600|840 feet|snowfall|2011-07-24 12|0.000|in|24|hours|46383| 9598O_MADIS|VALPARAISO 0.9 NNW, IN|41.48956|-87.05800|843 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46383| 9571O_MADIS|ST. JOHN 0.2 WSW, IN|41.44627|-87.48020|722 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46373| 9561A_MADIS|JONESVILLE 5.9 ENE, MI|42.01472|-84.56190|1201 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49250| 9559A_MADIS|TRAVERSE CITY 4.0 WSW, MI|44.73390|-85.67890|942 feet|snowfall|2011-07-23 14|0.000|in|24|hours|49684| 9555A_MADIS|WATERSMEET 5.0 SE, MI|46.20333|-89.13170|1709 feet|snowfall|2011-07-23 13|0.000|in|24|hours|49969| 9549A_MADIS|GRAND LEDGE 0.3 NNE, MI|42.75690|-84.74530|846 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48837| 9536A_MADIS|WATERVLIET 0.7 NNE, MI|42.19669|-86.25340|656 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49098| 9532A_MADIS|MIDDLEVILLE 1.2 E, MI|42.71114|-85.44190|915 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49333| 9531A_MADIS|ALPENA 1.6 SSW, MI|45.05156|-83.44880|584 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49707| 9390S_MADIS|FORT WAYNE 9.9 NNE, IN|41.21696|-85.08510|850 feet|snowfall|2011-07-24 12|0.000|in|24|hours|46845| 9281C_MADIS|VALPARAISO 1.4 ENE, IN|41.48770|-87.02750|797 feet|snowfall|2011-07-24 12|0.000|in|24|hours|46383| 8836S_MADIS|HERMANTOWN 9.3 NNE, MN|46.93000|-92.16600|1368 feet|snowfall|2011-07-23 13|0.000|in|24|hours|55803| 8810S_MADIS|ST. JOSEPH 3.0 S, MI|42.05372|-86.48530|646 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49085| 8549O_MADIS|NEW BALTIMORE 0.4 SSE, MI|42.67702|-82.73570|584 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48047| 8465A_MADIS|NEW CARLISLE 3.3 SSW, IN|41.65768|-86.52620|830 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46552| 8403S_MADIS|ROCKFORD 4.3 E, MI|43.12939|-85.47110|948 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49341| 8391O_MADIS|ANN ARBOR 3.1 SE, MI|42.23914|-83.69580|837 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48108| 8372A_MADIS|PLYMOUTH 2.5 WSW, IN|41.32970|-86.35680|817 feet|snowfall|2011-07-24 09|0.000|in|24|hours|46563| 8337A_MADIS|LA PORTE 6.2 N, IN|41.69783|-86.70920|732 feet|snowfall|2011-07-24 12|0.000|in|24|hours|46350| 8274A_MADIS|RENSSELAER 6.2 SE, IN|40.86261|-87.08020|689 feet|snowfall|2011-07-24 12|0.000|in|24|hours|47978| 8263A_MADIS|WHEATFIELD 1.8 ENE, IN|41.20121|-87.01950|673 feet|snowfall|2011-07-24 12|0.000|in|24|hours|46392| 8234O_MADIS|MOUNT PLEASANT 5.1 NE, MI|43.65009|-84.70810|751 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48858| 8134O_MADIS|MONTAGUE 8.1 NW, MI|43.50000|-86.47000|758 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49446| 8126O_MADIS|HANOVER 3.8 W, MI|42.10700|-84.62600|1070 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49241| 8121O_MADIS|LANSING 3.9 WNW, MI|42.72420|-84.62790|883 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48917| 8112O_MADIS|SOUTH BEND 4.6 SE, IN|41.62090|-86.21520|896 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46614| 8090A_MADIS|HUNTERTOWN 2.6 ESE, IN|41.21444|-85.12420|866 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46845| 8072S_MADIS|WEBB LAKE 2.2 SW, WI|45.98910|-92.16940|1004 feet|snowfall|2011-07-23 16|0.000|in|24|hours|54830| 7983O_MADIS|NORTHPORT 5.0 SSW, MI|45.06149|-85.64860|892 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49670| 7977O_MADIS|JACKSON 1.2 ENE, MI|42.24845|-84.38300|971 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49203| 7969O_MADIS|BELLEVUE 3.9 W, MI|42.45113|-85.09610|928 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49021| 7967O_MADIS|CHATHAM 0.2 SSE, MI|46.34499|-86.92740|892 feet|snowfall|2011-07-23 22|0.000|in|24|hours|49826| 7897O_MADIS|HOLLAND 4.3 NNW, MI|42.82315|-86.14850|627 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49424| 7820S_MADIS|NEOPIT-MENOMINEE TRIBAL ENTERPR|44.98040|-88.82930|1135 feet|snowfall|2011-07-23 12|0.000|in|24|hours|54416| 7814O_MADIS|PLYMOUTH 5.4 W, MI|42.38279|-83.57120|902 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48170| 7788O_MADIS|BYRON CENTER 2.9 NE, MI|42.84157|-85.68350|712 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49509| 7784O_MADIS|GRAND RAPIDS 3.2 S, MI|42.91468|-85.64920|659 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49507| 7768O_MADIS|WAYLAND 2.0 W, MI|42.67323|-85.68010|741 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49348| 7685S_MADIS|KENOSHA 1.7 S, WI|42.55970|-87.85660|663 feet|snowfall|2011-07-24 12|0.000|in|24|hours|53142| 7588O_MADIS|WAYNE COUNTY, MI|42.31400|-83.24500|607 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48124| 7585O_MADIS|GAYLORD 1.7 WNW, MI|45.03280|-84.71090|1322 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49735| 7583O_MADIS|WALKERVILLE 4.2 NNE, MI|43.77334|-86.10710|899 feet|snowfall|2011-07-24 09|0.000|in|24|hours|49459| 7580O_MADIS|SHELBY 0.4 SSE, MI|42.66594|-83.02870|692 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48317| 7576O_MADIS|GRANDVILLE 1.3 WSW, MI|42.89716|-85.77910|614 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49418| 7573O_MADIS|LOWELL 1.4 ESE, MI|42.92369|-85.32220|722 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49331| 7571O_MADIS|TRAVERSE CITY 4.1 E, MI|44.74662|-85.51930|656 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49686| 7564O_MADIS|CHEBOYGAN 2.9 S, MI|45.60000|-84.46280|594 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49721| 7493O_MADIS|EAST GRAND RAPIDS 0.7 SSW, MI|42.93801|-85.61340|748 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49506| 7416O_MADIS|WALKER 3.2 W, MI|42.98804|-85.81030|689 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49544| 7401O_MADIS|GARDEN CORNERS 0.8 NW, MI|45.89815|-86.54850|581 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49835| 7212O_MADIS|MIDLAND 8.2 NNE, MI|43.73573|-84.17680|679 feet|snowfall|2011-07-24 09|0.000|in|24|hours|48642| 7209O_MADIS|WELLSTON 0.8 N, MI|44.22876|-85.95780|771 feet|snowfall|2011-07-23 16|0.000|in|24|hours|49689| 7197O_MADIS|HASLETT 1.2 N, MI|42.76997|-84.40310|873 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48840| 7196O_MADIS|BEAVER ISLAND 5.9 NNW, MI|45.74985|-85.51030|574 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49782| 7191O_MADIS|BUCHANAN 1.4 ESE, MI|41.81829|-86.34230|751 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49107| 7144O_MADIS|STEVENSVILLE 1.7 SSE, MI|41.99114|-86.50860|630 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49127| 7092O_MADIS|OTSEGO COUNTY, MI|44.99783|-84.65310|1329 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49735| 6907C_MADIS|BAYFIELD COUNTY, WI|46.16937|-90.98090|1503 feet|snowfall|2011-07-24 12|0.000|in|24|hours|54821| 6906O_MADIS|MADISON 3.7 WSW, WI|43.06230|-89.45650|948 feet|snowfall|2011-07-24 12|0.000|in|24|hours|53705| 6814H_MADIS|FREMONT 3.5 NNW, MI|43.51068|-85.96660|869 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49412| 6745C_MADIS|GRANGER 2.9 W, IN|41.73727|-86.19490|814 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46530| 6738C_MADIS|CROWN POINT 2.0 WSW, IN|41.40892|-87.38990|751 feet|snowfall|2011-07-24 12|0.000|in|24|hours|46307| 6388H_MADIS|SYRACUSE 0.9 SW, IN|41.41286|-85.75830|896 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46567| 6344C_MADIS|MOUNTAIN 1.1 SW, WI|45.17239|-88.48990|965 feet|snowfall|2011-07-24 12|0.000|in|24|hours|54149| 6201C_MADIS|MERRILL 7.0 W, WI|45.17746|-89.84820|1424 feet|snowfall|2011-07-24 11|0.000|in|24|hours|54452| 6038C_MADIS|CECIL 5.6 ENE, WI|44.84920|-88.34720|801 feet|snowfall|2011-07-23 13|0.000|in|24|hours|54111| 6036C_MADIS|KENOSHA 2.2 SW, WI|42.55839|-87.88070|709 feet|snowfall|2011-07-24 12|0.000|in|24|hours|53142| 5976C_MADIS|SCHERERVILLE 2.0 WSW, IN|41.47611|-87.48190|666 feet|snowfall|2011-07-24 12|0.000|in|24|hours|46375| 5850C_MADIS|CEDARBURG 0.8 NNE, WI|43.30855|-87.98480|830 feet|snowfall|2011-07-24 12|0.000|in|24|hours|53012| 5846C_MADIS|BAYFIELD 8.8 N, WI|46.93855|-90.83490|705 feet|snowfall|2011-07-24 12|0.000|in|24|hours|54814| 5806C_MADIS|MANHATTAN 4.7 ENE, IL|41.45845|-87.90980|745 feet|snowfall|2011-07-24 12|0.000|in|24|hours|60442| 5795C_MADIS|WEYAUWEGA 0.1 S, WI|44.32130|-88.92860|801 feet|snowfall|2011-07-23 13|0.000|in|24|hours|54983| 5714S_MADIS|BELLEVILLE 2.3 NNE, MI|42.23544|-83.47240|689 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48111| 5704S_MADIS|SAGINAW 3.0 NW, MI|43.45566|-83.98460|610 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48603| 5702S_MADIS|ROSCOMMON 4.7 SW, MI|44.45158|-84.66720|1207 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48653| 5686S_MADIS|LAKE CITY 5.0 SSW, MI|44.26590|-85.25530|1247 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49651| 5685S_MADIS|MIDLAND 1.8 ENE, MI|43.63120|-84.19430|686 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48642| 5667S_MADIS|MASON 6.4 W, MI|42.58140|-84.56970|938 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48854| 5620C_MADIS|BATAVIA 1.5 WNW, IL|41.85937|-88.32750|719 feet|snowfall|2011-07-24 12|0.000|in|24|hours|60510| 5216S_MADIS|MISHAWAKA 3.9 ENE, IN|41.68329|-86.09540|755 feet|snowfall|2011-07-24 12|0.000|in|24|hours|46545| 5109O_MADIS|HART 3 WSW, MI|43.67470|-86.42250|774 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49436| 5106S_MADIS|NEW LENOX 1.8 SE, IL|41.49964|-87.96030|705 feet|snowfall|2011-07-24 12|0.000|in|24|hours|60451| 5099S_MADIS|HOMER GLEN 3.9 WNW, IL|41.63752|-88.00290|735 feet|snowfall|2011-07-23 13|0.000|in|24|hours|60491| 5066S_MADIS|ALGONQUIN 0.7 N, IL|42.17392|-88.29930|846 feet|snowfall|2011-07-24 11|0.000|in|24|hours|60102| 5030S_MADIS|GRANT PARK 5.8 ENE, IL|41.27533|-87.54470|722 feet|snowfall|2011-07-24 12|0.000|in|24|hours|60940| 4920C_MADIS|CHICAGO 5.5 ESE, IL|41.80077|-87.59030|600 feet|snowfall|2011-07-24 11|0.000|in|24|hours|60615| 4857C_MADIS|BEACH PARK 1.4 W, IL|42.42837|-87.88380|709 feet|snowfall|2011-07-24 11|0.000|in|24|hours|60087| 4228S_MADIS|FORT WAYNE 4.0 SE, IN|41.02675|-85.09460|807 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46816| 4226S_MADIS|WOODBURN 2.8 WSW, IN|41.11740|-84.90630|745 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46797| 4137H_MADIS|BIG BEND 0.1 WNW, WI|42.88200|-88.20460|830 feet|snowfall|2011-07-24 11|0.000|in|24|hours|53103| 4130H_MADIS|JACKSON 1.9 N, WI|43.34880|-88.15980|955 feet|snowfall|2011-07-24 12|0.000|in|24|hours|53037| 4125H_MADIS|LAKE GENEVA 0.6 ENE, WI|42.59169|-88.41770|912 feet|snowfall|2011-07-24 12|0.000|in|24|hours|53147| 4120O_MADIS|ST. CHARLES 0.1 E, IL|41.92010|-88.29900|781 feet|snowfall|2011-07-23 13|0.000|in|24|hours|60174| 4110H_MADIS|WEST ALLIS 0.7 SSE, WI|42.99802|-88.02380|771 feet|snowfall|2011-07-23 13|0.000|in|24|hours|53227| 4105H_MADIS|OAK CREEK 2.2 SE, WI|42.85832|-87.86840|686 feet|snowfall|2011-07-24 12|0.000|in|24|hours|53154| 3493O_MADIS|HOLLAND 5.1 WNW, MI|42.80115|-86.19480|614 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49424| 3492O_MADIS|GAYLORD 1.8 ESE, MI|45.00932|-84.64680|1293 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49735| 3276S_MADIS|ALSIP 0.2 E, IL|41.67031|-87.73120|610 feet|snowfall|2011-07-24 12|0.000|in|24|hours|60803| 3004O_MADIS|ST. JOSEPH COUNTY, MI|41.77780|-85.58330|830 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49099| 2752O_MADIS|BLOOMFIELD TOWNSHIP 3.1 SW, MI|42.54516|-83.31770|876 feet|snowfall|2011-07-24 11|0.000|in|24|hours|48301| 2586O_MADIS|ALLENDALE 1.3 SSW, MI|42.96742|-85.95740|666 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49401| 2511O_MADIS|FREDERIC 5.5 NNE, MI|44.83650|-84.72980|1332 feet|snowfall|2011-07-24 10|0.000|in|24|hours|49733| 1832R_MADIS|ALLEN COUNTY, IN|41.13380|-85.03070|797 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46835| 1485H_MADIS|TOLEDO 2.4 ENE, OH|41.68228|-83.54120|597 feet|snowfall|2011-07-24 11|0.000|in|24|hours|43608| 1453O_MADIS|TRAVERSE CITY 7.6 SSW, MI|44.65319|-85.66400|899 feet|snowfall|2011-07-24 11|0.000|in|24|hours|49684| 1345O_MADIS|EAST TAWAS 0.8 WSW, MI|44.28322|-83.49920|587 feet|snowfall|2011-07-24 12|0.000|in|24|hours|48730| 0707B_MADIS|DE PERE 2.4 W, WI|44.44197|-88.11920|666 feet|snowfall|2011-07-23 13|0.000|in|24|hours|54115| 0670S_MADIS|KALAMAZOO COUNTY, MI|42.26897|-85.47890|863 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49048| 0252O_MADIS|ST. JOSEPH COUNTY, IN|41.64800|-86.12900|741 feet|snowfall|2011-07-24 11|0.000|in|24|hours|46544| 0155R_MADIS|CARLTON 5.6 NE, MN|46.70783|-92.32790|1188 feet|snowfall|2011-07-23 14|0.000|in|24|hours|55733| 0047B_MADIS|ELK RAPIDS 0.5 ESE, MI|44.89249|-85.39460|600 feet|snowfall|2011-07-24 12|0.000|in|24|hours|49629|