! 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| 0525B_MADIS|LOS ALTOS HILLS 1.3 N, CA|37.38650|-122.13550|56 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|94022| 0657V_MADIS|FAIR OAKS 1.9 N, CA|38.67620|-121.25180|63 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95628| 1281B_MADIS|LOS OSOS 0.5 N, CA|35.32946|-120.83240|23 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|93402| 1534B_MADIS|SUNNYVALE 3.6 S, CA|37.33445|-122.01800|54 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94087| 1590R_MADIS|SONOMA 1.9 NNW, CA|38.31627|-122.47260|83 meters|snowfall|2014-07-12 14:37|0.000|cm|24.000|hours|95476| 1669R_MADIS|WALNUT CREEK 1.4 SSE, CA|37.88460|-122.02850|83 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94596| 1765H_MADIS|CAVE JUNCTION 3.7 E, OR|42.15733|-123.57270|472 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|97523| 1821R_MADIS|BOULDER CREEK 3.0 NW, CA|37.16930|-122.16410|268 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95006| 1980R_MADIS|FRESNO 4.3 NNW, CA|36.83618|-119.82930|106 meters|snowfall|2014-07-12 13:15|0.000|cm|24.000|hours|93711| 1981R_MADIS|FRAZIER PARK 0.6 WNW, CA|34.82657|-118.95470|1532 meters|snowfall|2014-07-12 14:30|0.000|cm|24.000|hours|93225| 1984R_MADIS|UKIAH 4.3 S, CA|39.08327|-123.21910|222 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95482| 2338O_MADIS|MILL VALLEY 1.5 S, CA|37.88630|-122.54400|78 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94941| 2501V_MADIS|HYDESVILLE 11.4 NE, CA|40.65780|-123.92450|748 meters|snowfall|2014-07-12 16:00|0.000|cm|24.000|hours|95549| 2562O_MADIS|LAYTONVILLE 1.1 SW, CA|39.67242|-123.48980|499 meters|snowfall|2014-07-12 13:40|0.000|cm|24.000|hours|95454| 2638S_MADIS|HUMBOLDT COUNTY, CA|40.47343|-123.70130|810 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95526| 2751B_MADIS|CHICO 1.7 SW, CA|39.73851|-121.83200|65 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95926| 3068O_MADIS|OROVILLE 2.7 ENE, CA|39.51400|-121.51800|164 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95966| 3111V_MADIS|WILLOW CREEK 4.9 NNE, CA|40.94729|-123.62790|162 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95573| 3190V_MADIS|SANTA MARIA 1.8 NE, CA|34.95890|-120.41860|74 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|93454| 3270B_MADIS|ROCKLIN 1.1 N, CA|38.81750|-121.24360|122 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95765| 3891V_MADIS|SAN JOSE 1.9 SW, CA|37.28839|-121.87720|37 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95125| 4040V_MADIS|SALINAS 3.2 NNW, CA|36.72817|-121.65620|27 meters|snowfall|2014-07-12 18:00|0.000|cm|24.000|hours|93906| 4227C_MADIS|SAN JUAN BAUTISTA 0.5 S, CA|36.83933|-121.53750|70 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95045| 4452V_MADIS|SANTA CRUZ 2.0 ENE, CA|36.97956|-122.00100|22 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95062| 4458C_MADIS|FOSTER CITY 1.3 SW, CA|37.54883|-122.25870|-1 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|94404| 4459C_MADIS|SAN JOSE 3.5 ENE, CA|37.31905|-121.78870|60 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95148| 4596S_MADIS|FREMONT 2.6 ESE, CA|37.51505|-121.95230|6 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94538| 4631S_MADIS|FOLSOM 0.6 NE, CA|38.68232|-121.13750|120 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95630| 4643S_MADIS|FELTON 4.5 NNE, CA|37.10514|-122.04680|280 meters|snowfall|2014-07-12 13:00|0.000|cm|24.000|hours|95018| 4669S_MADIS|DAVIS 2.7 W, CA|38.55229|-121.78550|20 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95616| 4962V_MADIS|FREMONT 1.9 SE, CA|37.51302|-121.96910|9 meters|snowfall|2014-07-12 13:00|0.000|cm|24.000|hours|94538| 4969B_MADIS|FORKS OF SALMON 1.0 NW, CA|41.26883|-123.33360|526 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95568| 5033B_MADIS|LEMOORE 0.9 ESE, CA|36.29320|-119.77180|70 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|93245| 5419H_MADIS|WILLOW CREEK 4.5 NNE, CA|40.93918|-123.62360|203 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95573| 5803V_MADIS|CASPAR 1.4 ESE, CA|39.36100|-123.78900|101 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95420| 6105V_MADIS|WOODSIDE 3.4 S, CA|37.37538|-122.26370|509 meters|snowfall|2014-07-12 19:00|0.000|cm|24.000|hours|94062| 6222A_MADIS|MARTINEZ 0.8 SSE, CA|37.98978|-122.10850|84 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94553| 6232A_MADIS|MARTINEZ 2.2 SW, CA|37.97440|-122.13840|205 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94553| 6234A_MADIS|CRESCENT CITY 5.5 NNE, CA|41.82403|-124.14820|28 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95531| 6243A_MADIS|CLOVIS 2.9 N, CA|36.86111|-119.69310|119 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|93611| 6249A_MADIS|ORICK 5.9 SSW, CA|41.20841|-124.10270|177 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95570| 6257A_MADIS|MIRANDA 4.1 SW, CA|40.20927|-123.89410|182 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95554| 6259A_MADIS|BAYVIEW 0.8 SE, CA|40.75630|-124.16610|57 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95503| 6272A_MADIS|HANFORD 3.6 N, CA|36.37689|-119.65270|81 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|93230| 6273A_MADIS|HANFORD 1.7 WNW, CA|36.33493|-119.67430|72 meters|snowfall|2014-07-12 22:30|0.000|cm|24.000|hours|93230| 6297A_MADIS|SAN ANSELMO 0.4 NE, CA|37.98723|-122.56430|32 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|94960| 6314A_MADIS|REDWOOD VALLEY 1.5 ENE, CA|39.27233|-123.17850|278 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95470| 6325A_MADIS|CASTROVILLE 1.6 ENE, CA|36.77642|-121.72840|7 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|93907| 6419A_MADIS|CARMICHAEL 0.9 NE, CA|38.64294|-121.30590|40 meters|snowfall|2014-07-12 13:00|0.000|cm|24.000|hours|95608| 6421A_MADIS|FOLSOM 1.2 SSE, CA|38.66002|-121.13950|112 meters|snowfall|2014-07-12 12:25|0.000|cm|24.000|hours|95630| 6492A_MADIS|STOCKTON 5.8 NNE, CA|38.03812|-121.25470|12 meters|snowfall|2014-07-12 12:30|0.000|cm|24.000|hours|95212| 6493A_MADIS|LODI 1.0 NNW, CA|38.13600|-121.30440|13 meters|snowfall|2014-07-12 13:00|0.000|cm|24.000|hours|95242| 6494A_MADIS|STOCKTON 3.3 SE, CA|37.94172|-121.25850|5 meters|snowfall|2014-07-12 13:00|0.000|cm|24.000|hours|95206| 6495A_MADIS|TRACY 2.1 W, CA|37.73535|-121.46990|16 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95377| 6502A_MADIS|HALF MOON BAY 0.5 SSW, CA|37.46300|-122.44080|13 meters|snowfall|2014-07-12 16:00|0.000|cm|24.000|hours|94019| 6509A_MADIS|SUNNYVALE 1.9 SE, CA|37.36471|-122.00420|21 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94086| 6511A_MADIS|MONTE SERENO 0.4 SSW, CA|37.23244|-121.99020|145 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95030| 6519A_MADIS|SARATOGA 0.5 N, CA|37.27482|-122.02270|110 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95070| 6535A_MADIS|BOULDER CREEK 3.6 NE, CA|37.18110|-122.09110|521 meters|snowfall|2014-07-13 11:00|0.000|cm|24.000|hours|95006| 6536A_MADIS|SCOTTS VALLEY 1.7 SW, CA|37.03955|-122.02950|177 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95066| 6561A_MADIS|REDDING 3.6 N, CA|40.62349|-122.35360|189 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|96003| 6596A_MADIS|WINDSOR 1.4 SE, CA|38.53173|-122.78000|40 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95492| 6602A_MADIS|CLOVERDALE 3.2 ESE, CA|38.78100|-122.96300|242 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95425| 6604A_MADIS|SEBASTOPOL 2.6 SSE, CA|38.36626|-122.80370|65 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95472| 6637A_MADIS|GLEN ELLEN 1.9 WNW, CA|38.36513|-122.57180|309 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95404| 6638A_MADIS|ROHNERT PARK 0.9 SW, CA|38.33921|-122.71130|28 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94928| 6640S_MADIS|BROOKINGS 4.2 ENE, OR|42.07067|-124.21020|33 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|97415| 6643S_MADIS|PORT ORFORD 5.0 E, OR|42.73930|-124.39870|90 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|97476| 6644S_MADIS|GOLD BEACH 4.8 NE, OR|42.50293|-124.36580|106 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|97444| 6646A_MADIS|ROHNERT PARK 0.9 ESE, CA|38.34507|-122.68120|37 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94928| 6649A_MADIS|KNIGHTS FERRY 5.2 WSW, CA|37.78925|-120.75180|54 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95361| 6657A_MADIS|DOUGLAS CITY 2.4 SW, CA|40.63264|-122.97770|516 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|96024| 6684A_MADIS|DAVIS 0.8 NE, CA|38.56185|-121.72410|14 meters|snowfall|2014-07-12 14:30|0.000|cm|24.000|hours|95616| 6684S_MADIS|SHADY COVE 0.2 S, OR|42.60890|-122.81890|424 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|97539| 6687S_MADIS|CENTRAL POINT 5.7 NW, OR|42.43344|-122.98690|470 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|97502| 6690S_MADIS|GOLD HILL 0.2 WSW, OR|42.43347|-123.05310|340 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|97525| 7481B_MADIS|ALBION 4.0 SE, CA|39.18780|-123.70960|214 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95410| 7626B_MADIS|COTTONWOOD 9.1 SW, CA|40.28207|-122.37840|199 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|96022| 7654B_MADIS|BROOKINGS 4.8 NNW, OR|42.12515|-124.32110|281 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|97415| 7669B_MADIS|RED BLUFF 2.8 N, CA|40.21452|-122.24290|127 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|96080| 7676B_MADIS|COTTONWOOD 6.7 SSW, CA|40.30706|-122.34720|185 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|96022| 7692B_MADIS|RED BLUFF 6.2 NW, CA|40.22833|-122.33450|147 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|96080| 7700C_MADIS|BOONVILLE 2.2 WSW, CA|39.00623|-123.40840|338 meters|snowfall|2014-07-12 16:00|0.000|cm|24.000|hours|95415| 7729B_MADIS|SOQUEL 0.8 NE, CA|37.00220|-121.93630|124 meters|snowfall|2014-07-13 00:00|0.000|cm|24.000|hours|95073| 7799B_MADIS|SAN FRANCISCO 3.0 W, CA|37.77760|-122.47410|67 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|94118| 7871C_MADIS|WINDSOR 0.6 NNE, CA|38.55336|-122.79290|46 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95492| 7887S_MADIS|HEALDSBURG 12.6 NNW, CA|38.78390|-122.96280|321 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95425| 8024B_MADIS|LAYTONVILLE 9.8 NNW, CA|39.81400|-123.53430|640 meters|snowfall|2014-07-12 15:00|0.000|cm|24.000|hours|95585| 8056B_MADIS|SANTA CRUZ 3.1 NW, CA|37.00641|-122.07500|289 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95060| 8069B_MADIS|CHICO 5.5 NW, CA|39.79986|-121.89150|59 meters|snowfall|2014-07-12 13:00|0.000|cm|24.000|hours|95973| 8212B_MADIS|FAIRFAX 0.6 SSE, CA|37.98098|-122.59070|50 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94930| 8333S_MADIS|LOS GATOS 5.4 SSW, CA|37.15603|-121.98750|512 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|95033| 8916S_MADIS|KNEELAND 0.4 NNW, CA|40.76588|-123.99850|622 meters|snowfall|2014-07-12 14:20|0.000|cm|24.000|hours|95549| 9223B_MADIS|BUTTE COUNTY, CA|39.36913|-121.69260|30 meters|snowfall|2014-07-12 13:00|0.000|cm|24.000|hours|95948| 9515O_MADIS|CONCORD 0.8 WNW, CA|37.97832|-122.01340|41 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|94519| 9625B_MADIS|RED BLUFF 4.9 SE, CA|40.12365|-122.17470|81 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|96080| CYVO3|CANYONVILLE 2S|42.94190|-123.28000|210 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|97417| MFR|MEDFORD, OR|42.37420|-122.87330|399 meters|snowfall|2014-07-13 12:00|0.000|cm|24.000|hours|97502| MFR|MEDFORD, OR|42.37420|-122.87330|399 meters|snowfall|2014-07-13 00:00|0.000|cm|24.000|hours|97502| RUCO3|RUCH|42.22310|-123.04720|469 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|97530| YKAC1|YREKA|41.70360|-122.64080|823 meters|snowfall|2014-07-12 14:00|0.000|cm|24.000|hours|96097|