! 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|247 meters|snowfall|2011-07-24 00|0.000|cm|12|hours|60107| SCOM4|SCOTTVILLE 2 SE|43.93310|-86.24530|203 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49454| ORD|O'HARE INTL AP|41.97940|-87.90440|215 meters|snowfall|2011-07-24 18|0.000|cm|6|hours|60666| MRIM4|MORENCI,MI|41.71670|-84.20000|233 meters|snowfall|2011-07-24 12|0.000|cm|48|hours|49256| MQT|MARQUETTE, MI|46.53110|-87.54830|437 meters|snowfall|2011-07-24 18|0.000|cm|6|hours|49866| MKG|MUSKEGON COUNTY AIRPORT|43.16940|-86.23810|192 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49441| LOT|CHICAGO, IL|41.60830|-88.09390|200 meters|snowfall|2011-07-24 18|0.000|cm|6|hours|60446| LAN|CAPITAL CITY AIRPORT|42.77860|-84.58720|258 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48906| INAM4|1MI.WNW IONIA,MI|42.98330|-85.06670|203 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48846| HTL|ROSCOMMON COUNTY AIRPORT|44.35000|-84.66670|349 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48629| HRTM4|HART,MI|43.70000|-86.36670|200 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49420| HOLM4|HOLLAND,MI|42.80000|-86.11670|185 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49424| HASM4|WWTP|42.65000|-85.30000|239 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49058| GRR|GRAND RAPIDS, MI|42.89390|-85.54470|242 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49512| GPDM4|44TH STREET|42.90000|-85.76670|188 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49418| GGRM4|GREEN GARDEN NO.2|46.45330|-87.30380|207 meters|snowfall|2011-07-24 13|0.000|cm|12|hours|49855| BGRM4|WATER WORKS|43.70000|-85.48330|281 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49307| APN|PHELPS COLLINS FIELD|45.07810|-83.56030|204 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49707| ANJ|SAULT STE MARIE|46.46670|-84.36670|213 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49783| AHKM4|AHMEEK 1SW|47.29200|-88.42090|334 meters|snowfall|2011-07-24 11|0.000|cm|12|hours|49913| 9883O_MADIS|BAY CITY 5.3 N, MI|43.66637|-83.90610|184 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48706| 9882O_MADIS|MIKADO 2.3 SE, MI|44.56967|-83.38590|200 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48745| 9802S_MADIS|ELKHART 1.9 ENE, IN|41.70010|-85.93620|232 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|46514| 9651A_MADIS|GRAND JUNCTION 1.3 ENE, MI|42.40926|-86.04810|208 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|49056| 9635A_MADIS|HUDSONVILLE 0.3 E, MI|42.86530|-85.85740|201 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49426| 9599O_MADIS|VALPARAISO 1.8 N, IN|41.50270|-87.04600|256 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|46383| 9598O_MADIS|VALPARAISO 0.9 NNW, IN|41.48956|-87.05800|257 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46383| 9571O_MADIS|ST. JOHN 0.2 WSW, IN|41.44627|-87.48020|220 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46373| 9564A_MADIS|BAD AXE 0.5 SSW, MI|43.79614|-82.99960|231 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|48413| 9561A_MADIS|JONESVILLE 5.9 ENE, MI|42.01472|-84.56190|366 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49250| 9549A_MADIS|GRAND LEDGE 0.3 NNE, MI|42.75690|-84.74530|258 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48837| 9536A_MADIS|WATERVLIET 0.7 NNE, MI|42.19669|-86.25340|200 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49098| 9532A_MADIS|MIDDLEVILLE 1.2 E, MI|42.71114|-85.44190|279 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49333| 9531A_MADIS|ALPENA 1.6 SSW, MI|45.05156|-83.44880|178 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49707| 9390S_MADIS|FORT WAYNE 9.9 NNE, IN|41.21696|-85.08510|259 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|46845| 9281C_MADIS|VALPARAISO 1.4 ENE, IN|41.48770|-87.02750|243 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|46383| 8810S_MADIS|ST. JOSEPH 3.0 S, MI|42.05372|-86.48530|197 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49085| 8738S_MADIS|GENEVA 0.5 SW, IL|41.87730|-88.32120|228 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|60134| 8549O_MADIS|NEW BALTIMORE 0.4 SSE, MI|42.67702|-82.73570|178 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48047| 8465A_MADIS|NEW CARLISLE 3.3 SSW, IN|41.65768|-86.52620|253 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46552| 8403S_MADIS|ROCKFORD 4.3 E, MI|43.12939|-85.47110|289 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49341| 8391O_MADIS|ANN ARBOR 3.1 SE, MI|42.23914|-83.69580|255 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48108| 8372A_MADIS|PLYMOUTH 2.5 WSW, IN|41.32970|-86.35680|249 meters|snowfall|2011-07-24 09|0.000|cm|24|hours|46563| 8337A_MADIS|LA PORTE 6.2 N, IN|41.69783|-86.70920|223 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|46350| 8274A_MADIS|RENSSELAER 6.2 SE, IN|40.86261|-87.08020|210 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|47978| 8263A_MADIS|WHEATFIELD 1.8 ENE, IN|41.20121|-87.01950|205 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|46392| 8234O_MADIS|MOUNT PLEASANT 5.1 NE, MI|43.65009|-84.70810|229 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48858| 8180A_MADIS|ELKHART 4.8 SW, IN|41.64249|-86.04150|230 meters|snowfall|2011-07-24 16|0.000|cm|24|hours|46517| 8134O_MADIS|MONTAGUE 8.1 NW, MI|43.50000|-86.47000|231 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49446| 8126O_MADIS|HANOVER 3.8 W, MI|42.10700|-84.62600|326 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49241| 8121O_MADIS|LANSING 3.9 WNW, MI|42.72420|-84.62790|269 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48917| 8112O_MADIS|SOUTH BEND 4.6 SE, IN|41.62090|-86.21520|273 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46614| 8090A_MADIS|HUNTERTOWN 2.6 ESE, IN|41.21444|-85.12420|264 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46845| 7983O_MADIS|NORTHPORT 5.0 SSW, MI|45.06149|-85.64860|272 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49670| 7977O_MADIS|JACKSON 1.2 ENE, MI|42.24845|-84.38300|296 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49203| 7973O_MADIS|TRAVERSE CITY 9.4 WSW, MI|44.71300|-85.78560|273 meters|snowfall|2011-07-24 14|0.000|cm|24|hours|49684| 7969O_MADIS|BELLEVUE 3.9 W, MI|42.45113|-85.09610|283 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49021| 7967O_MADIS|CHATHAM 0.2 SSE, MI|46.34499|-86.92740|272 meters|snowfall|2011-07-23 22|0.000|cm|24|hours|49826| 7897O_MADIS|HOLLAND 4.3 NNW, MI|42.82315|-86.14850|191 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49424| 7814O_MADIS|PLYMOUTH 5.4 W, MI|42.38279|-83.57120|275 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48170| 7788O_MADIS|BYRON CENTER 2.9 NE, MI|42.84157|-85.68350|217 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49509| 7784O_MADIS|GRAND RAPIDS 3.2 S, MI|42.91468|-85.64920|201 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49507| 7768O_MADIS|WAYLAND 2.0 W, MI|42.67323|-85.68010|226 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49348| 7686S_MADIS|KENOSHA 4.8 NNE, WI|42.64706|-87.81580|193 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|53140| 7685S_MADIS|KENOSHA 1.7 S, WI|42.55970|-87.85660|202 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|53142| 7588O_MADIS|WAYNE COUNTY, MI|42.31400|-83.24500|185 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48124| 7585O_MADIS|GAYLORD 1.7 WNW, MI|45.03280|-84.71090|403 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49735| 7583O_MADIS|WALKERVILLE 4.2 NNE, MI|43.77334|-86.10710|274 meters|snowfall|2011-07-24 09|0.000|cm|24|hours|49459| 7580O_MADIS|SHELBY 0.4 SSE, MI|42.66594|-83.02870|211 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48317| 7576O_MADIS|GRANDVILLE 1.3 WSW, MI|42.89716|-85.77910|187 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49418| 7573O_MADIS|LOWELL 1.4 ESE, MI|42.92369|-85.32220|220 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49331| 7571O_MADIS|TRAVERSE CITY 4.1 E, MI|44.74662|-85.51930|200 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49686| 7564O_MADIS|CHEBOYGAN 2.9 S, MI|45.60000|-84.46280|181 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49721| 7494O_MADIS|GRAND RAPIDS 3.1 NNE, MI|43.00530|-85.64110|216 meters|snowfall|2011-07-24 14|0.000|cm|24|hours|49505| 7493O_MADIS|EAST GRAND RAPIDS 0.7 SSW, MI|42.93801|-85.61340|228 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49506| 7416O_MADIS|WALKER 3.2 W, MI|42.98804|-85.81030|210 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49544| 7401O_MADIS|GARDEN CORNERS 0.8 NW, MI|45.89815|-86.54850|177 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49835| 7212O_MADIS|MIDLAND 8.2 NNE, MI|43.73573|-84.17680|207 meters|snowfall|2011-07-24 09|0.000|cm|24|hours|48642| 7209O_MADIS|WELLSTON 0.8 N, MI|44.22876|-85.95780|235 meters|snowfall|2011-07-24 16|0.000|cm|24|hours|49689| 7197O_MADIS|HASLETT 1.2 N, MI|42.76997|-84.40310|266 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48840| 7196O_MADIS|BEAVER ISLAND 5.9 NNW, MI|45.74985|-85.51030|175 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49782| 7191O_MADIS|BUCHANAN 1.4 ESE, MI|41.81829|-86.34230|229 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49107| 7144O_MADIS|STEVENSVILLE 1.7 SSE, MI|41.99114|-86.50860|192 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49127| 7092O_MADIS|OTSEGO COUNTY, MI|44.99783|-84.65310|405 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49735| 6907C_MADIS|BAYFIELD COUNTY, WI|46.16937|-90.98090|458 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|54821| 6906O_MADIS|MADISON 3.7 WSW, WI|43.06230|-89.45650|289 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|53705| 6814H_MADIS|FREMONT 3.5 NNW, MI|43.51068|-85.96660|265 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49412| 6745C_MADIS|GRANGER 2.9 W, IN|41.73727|-86.19490|248 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46530| 6738C_MADIS|CROWN POINT 2.0 WSW, IN|41.40892|-87.38990|229 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|46307| 6388H_MADIS|SYRACUSE 0.9 SW, IN|41.41286|-85.75830|273 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46567| 6344C_MADIS|MOUNTAIN 1.1 SW, WI|45.17239|-88.48990|294 meters|snowfall|2011-07-24 15|0.000|cm|24|hours|54149| 6201C_MADIS|MERRILL 7.0 W, WI|45.17746|-89.84820|434 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|54452| 6036C_MADIS|KENOSHA 2.2 SW, WI|42.55839|-87.88070|216 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|53142| 5976C_MADIS|SCHERERVILLE 2.0 WSW, IN|41.47611|-87.48190|203 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|46375| 5850C_MADIS|CEDARBURG 0.8 NNE, WI|43.30855|-87.98480|253 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|53012| 5846C_MADIS|BAYFIELD 8.8 N, WI|46.93855|-90.83490|215 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|54814| 5806C_MADIS|MANHATTAN 4.7 ENE, IL|41.45845|-87.90980|227 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|60442| 5714S_MADIS|BELLEVILLE 2.3 NNE, MI|42.23544|-83.47240|210 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48111| 5713C_MADIS|OAK PARK 0.6 NE, IL|41.89342|-87.77980|191 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|60302| 5704S_MADIS|SAGINAW 3.0 NW, MI|43.45566|-83.98460|186 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48603| 5702S_MADIS|ROSCOMMON 4.7 SW, MI|44.45158|-84.66720|368 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48653| 5686S_MADIS|LAKE CITY 5.0 SSW, MI|44.26590|-85.25530|380 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49651| 5685S_MADIS|MIDLAND 1.8 ENE, MI|43.63120|-84.19430|209 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48642| 5676S_MADIS|GRAND RAPIDS 5.5 NNE, MI|43.03100|-85.61270|222 meters|snowfall|2011-07-24 15|0.000|cm|24|hours|49525| 5667S_MADIS|MASON 6.4 W, MI|42.58140|-84.56970|286 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48854| 5620C_MADIS|BATAVIA 1.5 WNW, IL|41.85937|-88.32750|219 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|60510| 5216S_MADIS|MISHAWAKA 3.9 ENE, IN|41.68329|-86.09540|230 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|46545| 5154C_MADIS|ELGIN 1.0 S, IL|42.02560|-88.28850|238 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|60123| 5109O_MADIS|HART 3 WSW, MI|43.67470|-86.42250|236 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49436| 5106S_MADIS|NEW LENOX 1.8 SE, IL|41.49964|-87.96030|215 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|60451| 5099S_MADIS|HOMER GLEN 3.9 WNW, IL|41.63752|-88.00290|224 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|60491| 5066S_MADIS|ALGONQUIN 0.7 N, IL|42.17392|-88.29930|258 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|60102| 5030S_MADIS|GRANT PARK 5.8 ENE, IL|41.27533|-87.54470|220 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|60940| 4972S_MADIS|ARLINGTON HEIGHTS 1.3 SW, IL|42.08222|-88.00190|220 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|60005| 4920C_MADIS|CHICAGO 5.5 ESE, IL|41.80077|-87.59030|183 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|60615| 4857C_MADIS|BEACH PARK 1.4 W, IL|42.42837|-87.88380|216 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|60087| 4228S_MADIS|FORT WAYNE 4.0 SE, IN|41.02675|-85.09460|246 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46816| 4226S_MADIS|WOODBURN 2.8 WSW, IN|41.11740|-84.90630|227 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46797| 4137H_MADIS|BIG BEND 0.1 WNW, WI|42.88200|-88.20460|253 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|53103| 4130H_MADIS|JACKSON 1.9 N, WI|43.34880|-88.15980|291 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|53037| 4125H_MADIS|LAKE GENEVA 0.6 ENE, WI|42.59169|-88.41770|278 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|53147| 4120O_MADIS|ST. CHARLES 0.1 E, IL|41.92010|-88.29900|238 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|60174| 4110H_MADIS|WEST ALLIS 0.7 SSE, WI|42.99802|-88.02380|235 meters|snowfall|2011-07-24 13|0.000|cm|24|hours|53227| 4105H_MADIS|OAK CREEK 2.2 SE, WI|42.85832|-87.86840|209 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|53154| 3653S_MADIS|ALBION 3.7 S, IN|41.34161|-85.41560|288 meters|snowfall|2011-07-24 14|0.000|cm|24|hours|46701| 3493O_MADIS|HOLLAND 5.1 WNW, MI|42.80115|-86.19480|187 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49424| 3492O_MADIS|GAYLORD 1.8 ESE, MI|45.00932|-84.64680|394 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49735| 3276S_MADIS|ALSIP 0.2 E, IL|41.67031|-87.73120|186 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|60803| 3004O_MADIS|ST. JOSEPH COUNTY, MI|41.77780|-85.58330|253 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49099| 2905O_MADIS|TWIN LAKE 5.1 SSE, MI|43.29762|-86.15310|203 meters|snowfall|2011-07-24 14|0.000|cm|24|hours|49457| 2752O_MADIS|BLOOMFIELD TOWNSHIP 3.1 SW, MI|42.54516|-83.31770|267 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|48301| 2586O_MADIS|ALLENDALE 1.3 SSW, MI|42.96742|-85.95740|203 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49401| 2511O_MADIS|FREDERIC 5.5 NNE, MI|44.83650|-84.72980|406 meters|snowfall|2011-07-24 10|0.000|cm|24|hours|49733| 1832R_MADIS|ALLEN COUNTY, IN|41.13380|-85.03070|243 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46835| 1614R_MADIS|PORT HURON 1.6 W, MI|42.99617|-82.46430|187 meters|snowfall|2011-07-24 14|0.000|cm|24|hours|48060| 1485H_MADIS|TOLEDO 2.4 ENE, OH|41.68228|-83.54120|182 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|43608| 1453O_MADIS|TRAVERSE CITY 7.6 SSW, MI|44.65319|-85.66400|274 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|49684| 1345O_MADIS|EAST TAWAS 0.8 WSW, MI|44.28322|-83.49920|179 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|48730| 0670S_MADIS|KALAMAZOO COUNTY, MI|42.26897|-85.47890|263 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49048| 0252O_MADIS|ST. JOSEPH COUNTY, IN|41.64800|-86.12900|226 meters|snowfall|2011-07-24 11|0.000|cm|24|hours|46544| 0047B_MADIS|ELK RAPIDS 0.5 ESE, MI|44.89249|-85.39460|183 meters|snowfall|2011-07-24 12|0.000|cm|24|hours|49629|