! 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| 0657V_MADIS|FAIR OAKS 1.9 N, CA|38.67620|-121.25180|63 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|95628| 1281B_MADIS|LOS OSOS 0.5 N, CA|35.32946|-120.83240|23 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93402| 1590R_MADIS|SONOMA 1.9 NNW, CA|38.31627|-122.47260|83 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|95476| 1610B_MADIS|CHICO 1.2 NNW, CA|39.76970|-121.81380|77 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95973| 1669R_MADIS|WALNUT CREEK 1.4 SSE, CA|37.88460|-122.02850|83 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94596| 1814B_MADIS|MARYSVILLE 5.0 N, CA|39.22407|-121.59400|21 meters|snowfall|2014-01-29 14:30|0.000|cm|24.000|hours|95901| 1821R_MADIS|BOULDER CREEK 3.0 NW, CA|37.16930|-122.16410|268 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95006| 1907R_MADIS|FRESNO COUNTY, CA|36.79804|-119.55350|129 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93657| 1952B_MADIS|WHEATLAND 0.1 ENE, CA|39.01347|-121.42430|24 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95692| 1980R_MADIS|FRESNO 4.3 NNW, CA|36.83618|-119.82930|106 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|93711| 1983R_MADIS|LA GRANGE 7.8 ESE, CA|37.63544|-120.32730|339 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95329| 2649O_MADIS|LA RIVIERA 1.0 NE, CA|38.57527|-121.34000|21 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95827| 2669B_MADIS|DAVIS 2.4 W, CA|38.55919|-121.78020|17 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|95616| 2687B_MADIS|REDDING 3.8 S, CA|40.51805|-122.36920|137 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|96001| 2751B_MADIS|CHICO 1.7 SW, CA|39.73851|-121.83200|65 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|95926| 2950O_MADIS|PINE MOUNTAIN CLUB 0.9 SSW, CA|34.83532|-119.16310|1847 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93225| 3270B_MADIS|ROCKLIN 1.1 N, CA|38.81750|-121.24360|122 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95765| 3482V_MADIS|FRESNO 7.1 E, CA|36.78810|-119.66540|111 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93727| 3588B_MADIS|REDDING 3.3 N, CA|40.61900|-122.37600|203 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|96003| 3741B_MADIS|MORGAN HILL 1.4 SW, CA|37.11683|-121.65910|130 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95037| 4349B_MADIS|MOUNT SHASTA 5.1 NW, CA|41.36391|-122.39690|1201 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96067| 4458C_MADIS|FOSTER CITY 1.3 SW, CA|37.54883|-122.25870|-1 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|94404| 4463C_MADIS|SANTA ROSA 3.1 W, CA|38.45143|-122.75770|32 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95403| 4622S_MADIS|CARMEL VALLEY VILLAGE 5.4 WNW,|36.52180|-121.81000|46 meters|snowfall|2014-01-29 16:30|0.000|cm|24.000|hours|93923| 4631S_MADIS|FOLSOM 0.6 NE, CA|38.68232|-121.13750|120 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95630| 4643S_MADIS|FELTON 4.5 NNE, CA|37.10514|-122.04680|280 meters|snowfall|2014-01-29 13:00|0.000|cm|24.000|hours|95018| 5033B_MADIS|LEMOORE 0.9 ESE, CA|36.29320|-119.77180|70 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93245| 6215A_MADIS|PLEASANTON 1.8 SSE, CA|37.64827|-121.87450|107 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94566| 6222A_MADIS|MARTINEZ 0.8 SSE, CA|37.98978|-122.10850|84 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94553| 6231A_MADIS|LAFAYETTE 1.9 WSW, CA|37.88832|-122.15260|159 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94549| 6232A_MADIS|MARTINEZ 2.2 SW, CA|37.97440|-122.13840|205 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94553| 6243A_MADIS|CLOVIS 2.9 N, CA|36.86111|-119.69310|119 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93611| 6249A_MADIS|ORICK 5.9 SSW, CA|41.20841|-124.10270|177 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95570| 6272A_MADIS|HANFORD 3.6 N, CA|36.37689|-119.65270|81 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93230| 6273A_MADIS|HANFORD 1.7 WNW, CA|36.33493|-119.67430|72 meters|snowfall|2014-01-29 23:30|0.000|cm|24.000|hours|93230| 6297A_MADIS|SAN ANSELMO 0.4 NE, CA|37.98723|-122.56430|32 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|94960| 6299A_MADIS|PETALUMA 10.1 W, CA|38.24754|-122.81190|34 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94952| 6324A_MADIS|KING CITY 13.2 S, CA|36.02486|-121.17450|337 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93930| 6325A_MADIS|CASTROVILLE 1.6 ENE, CA|36.77642|-121.72840|7 meters|snowfall|2014-01-29 14:57|0.000|cm|24.000|hours|93907| 6338A_MADIS|CALISTOGA 0.4 SSE, CA|38.57640|-122.57800|107 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94515| 6388A_MADIS|ROSEVILLE 4.7 WNW, CA|38.78023|-121.37660|29 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95747| 6395A_MADIS|LINCOLN 4.3 SSE, CA|38.84228|-121.28370|53 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95648| 6415A_MADIS|CARMICHAEL 1.6 SW, CA|38.61728|-121.34040|32 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95608| 6416A_MADIS|SACRAMENTO 8.0 NE, CA|38.63500|-121.36110|32 meters|snowfall|2014-01-29 13:45|0.000|cm|24.000|hours|95821| 6417A_MADIS|FOLSOM 3.4 ESE, CA|38.65458|-121.09070|179 meters|snowfall|2014-01-29 13:00|0.000|cm|24.000|hours|95630| 6419A_MADIS|CARMICHAEL 0.9 NE, CA|38.64294|-121.30590|40 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|95608| 6421A_MADIS|FOLSOM 1.2 SSE, CA|38.66002|-121.13950|112 meters|snowfall|2014-01-29 14:30|0.000|cm|24.000|hours|95630| 6425A_MADIS|SACRAMENTO 2.0 SE, CA|38.54990|-121.43740|9 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95817| 6435A_MADIS|SACRAMENTO 5.7 SSE, CA|38.49278|-121.41950|9 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95828| 6437A_MADIS|HOLLISTER 5.4 NNE, CA|36.93065|-121.37040|75 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|95023| 6489A_MADIS|LINDEN 5.8 ENE, CA|38.06269|-121.00790|46 meters|snowfall|2014-01-29 13:00|0.000|cm|24.000|hours|95236| 6491A_MADIS|STOCKTON 2.1 NW, CA|37.99120|-121.33330|5 meters|snowfall|2014-01-29 15:15|0.000|cm|24.000|hours|95207| 6492A_MADIS|STOCKTON 5.8 NNE, CA|38.03812|-121.25470|12 meters|snowfall|2014-01-29 13:30|0.000|cm|24.000|hours|95212| 6495A_MADIS|TRACY 2.1 W, CA|37.73535|-121.46990|16 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|95377| 6499A_MADIS|PACIFICA 0.3 W, CA|37.61211|-122.48250|65 meters|snowfall|2014-01-29 17:00|0.000|cm|24.000|hours|94044| 6503A_MADIS|REDWOOD CITY 2.5 SW, CA|37.49311|-122.23990|0 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94063| 6507A_MADIS|MOUNTAIN VIEW 1.2 S, CA|37.38477|-122.07520|34 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|94041| 6513A_MADIS|SAN JOSE 4.6 NE, CA|37.35433|-121.79550|91 meters|snowfall|2014-01-29 15:30|0.000|cm|24.000|hours|95127| 6536A_MADIS|SCOTTS VALLEY 1.7 SW, CA|37.03955|-122.02950|177 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95066| 6538A_MADIS|APTOS 2.6 E, CA|36.99610|-121.85360|120 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95003| 6547A_MADIS|COTTONWOOD 0.5 NNE, CA|40.39710|-122.27600|139 meters|snowfall|2014-01-29 13:30|0.000|cm|24.000|hours|96022| 6553A_MADIS|REDDING 7.9 NNE, CA|40.67211|-122.29130|215 meters|snowfall|2014-01-29 14:30|0.000|cm|24.000|hours|96003| 6554A_MADIS|REDDING 3.7 N, CA|40.62608|-122.35850|188 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96003| 6563A_MADIS|REDDING 0.6 NW, CA|40.57955|-122.37270|150 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96001| 6566A_MADIS|REDDING 4.1 N, CA|40.63123|-122.35840|187 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96003| 6573A_MADIS|WEED 5.4 N, CA|41.49489|-122.36970|933 meters|snowfall|2014-01-29 16:30|0.000|cm|24.000|hours|96094| 6589A_MADIS|CALISTOGA 4.6 WNW, CA|38.61160|-122.65750|149 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94515| 6590A_MADIS|SEBASTOPOL 4.5 WSW, CA|38.37526|-122.90350|137 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95472| 6596A_MADIS|WINDSOR 1.4 SE, CA|38.53173|-122.78000|40 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95492| 6602A_MADIS|CLOVERDALE 3.2 ESE, CA|38.78100|-122.96300|242 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95425| 6604A_MADIS|SEBASTOPOL 2.6 SSE, CA|38.36626|-122.80370|65 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|95472| 6638A_MADIS|ROHNERT PARK 0.9 SW, CA|38.33921|-122.71130|28 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94928| 6641A_MADIS|HEALDSBURG 3.7 WNW, CA|38.64762|-122.92070|44 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95448| 6673A_MADIS|VISALIA 0.7 SSE, CA|36.31525|-119.31760|101 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93277| 6675S_MADIS|CENTRAL POINT 10 N, OR|42.48750|-122.94810|392 meters|snowfall|2014-01-29 17:14|0.000|cm|24.000|hours|97502| 6679A_MADIS|FRAZIER PARK 10.7 WSW, CA|34.74600|-119.11030|1610 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93225| 6683A_MADIS|DAVIS 1.2 SE, CA|38.54250|-121.72100|11 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95616| 6686S_MADIS|ASHLAND 2.4 ESE, OR|42.17530|-122.65720|624 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|97520| 6687S_MADIS|CENTRAL POINT 5.7 NW, OR|42.43344|-122.98690|470 meters|snowfall|2014-01-29 15:30|0.000|cm|24.000|hours|97502| 6690S_MADIS|GOLD HILL 0.2 WSW, OR|42.43347|-123.05310|340 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|97525| 6716B_MADIS|ROSEVILLE 2.4 SE, CA|38.73990|-121.25750|49 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|95661| 6987B_MADIS|REDDING 2.8 NW, CA|40.60238|-122.40070|205 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96003| 7012B_MADIS|RED BLUFF 6.0 W, CA|40.15908|-122.35150|127 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|96080| 7067B_MADIS|COTTONWOOD 7.7 SSW, CA|40.28699|-122.33330|193 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96022| 7309B_MADIS|CLOVIS 1.3 NE, CA|36.83303|-119.68080|119 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|93611| 7610B_MADIS|GOLD HILL 5.4 NNW, OR|42.50690|-123.08900|611 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|97525| 7661B_MADIS|COTTONWOOD 3.6 SSW, CA|40.34098|-122.30180|170 meters|snowfall|2014-01-29 14:45|0.000|cm|24.000|hours|96022| 7669B_MADIS|RED BLUFF 2.8 N, CA|40.21452|-122.24290|127 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96080| 7676B_MADIS|COTTONWOOD 6.7 SSW, CA|40.30706|-122.34720|185 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96022| 7729B_MADIS|SOQUEL 0.8 NE, CA|37.00220|-121.93630|124 meters|snowfall|2014-01-30 01:00|0.000|cm|24.000|hours|95073| 7830C_MADIS|WINDSOR 1.5 WNW, CA|38.55513|-122.82270|38 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95492| 7871C_MADIS|WINDSOR 0.6 NNE, CA|38.55336|-122.79290|46 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95492| 7878S_MADIS|ALAMEDA COUNTY, CA|37.67020|-121.88140|105 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94566| 7885S_MADIS|BELMONT 0.7 WSW, CA|37.51041|-122.30570|136 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94002| 8024B_MADIS|LAYTONVILLE 9.8 NNW, CA|39.81400|-123.53430|640 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|95585| 8056B_MADIS|SANTA CRUZ 3.1 NW, CA|37.00641|-122.07500|289 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|95060| 8212B_MADIS|FAIRFAX 0.6 SSE, CA|37.98098|-122.59070|50 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94930| 8216B_MADIS|SACRAMENTO 4.7 SW, CA|38.51208|-121.52040|4 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|95831| 8219B_MADIS|SAN MATEO 1.2 SW, CA|37.55035|-122.32950|31 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94010| 8227B_MADIS|ANDERSON 8.5 WNW, CA|40.47460|-122.45220|250 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|96007| 8237H_MADIS|GOLETA 3.7 WNW, CA|34.43967|-119.89610|53 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|93117| 8283S_MADIS|FORESTVILLE 0.7 SW, CA|38.47332|-122.89740|58 meters|snowfall|2014-01-29 16:00|0.000|cm|24.000|hours|95436| 8486B_MADIS|COTTONWOOD 3.9 SW, CA|40.35791|-122.34160|141 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96022| 8660B_MADIS|OAKLAND 1.0 NE, CA|37.78166|-122.21240|38 meters|snowfall|2014-01-29 14:00|0.000|cm|24.000|hours|94601| 9515O_MADIS|CONCORD 0.8 WNW, CA|37.97832|-122.01340|41 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|94519| 9625B_MADIS|RED BLUFF 4.9 SE, CA|40.12365|-122.17470|81 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96080| CYVO3|CANYONVILLE 2S|42.94190|-123.28000|210 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|97417| FOJC1|FORT JONES RS|41.60000|-122.84780|832 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96032| HOWO3|HOWARD PRAIRIE DAM|42.22920|-122.38140|1427 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|97520| MFR|MEDFORD, OR|42.37420|-122.87330|399 meters|snowfall|2014-01-30 12:00|0.000|cm|24.000|hours|97502| MFR|MEDFORD, OR|42.37420|-122.87330|399 meters|snowfall|2014-01-30 00:00|0.000|cm|24.000|hours|97502| RIDO3|RIDDLE|42.95060|-123.35720|204 meters|snowfall|2014-01-30 03:00|0.000|cm|24.000|hours|97469| YKAC1|YREKA|41.70360|-122.64080|823 meters|snowfall|2014-01-29 15:00|0.000|cm|24.000|hours|96097|