{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":66,"n_cols":4,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["County","Medi-Cal Enrollment \n(8-2019)","Total Population\n(2019)","Medi-Cal % Of County Population"]
["California",{"$f":"SUM(B3:B60)","v":12764923},{"$f":"SUM(C3:C60)","v":39959095},{"$f":"B2/C2","v":0.31944975230294881}]
["Alameda",410667,1674115,{"$f":"B3/C3","v":0.24530393670685705}]
["Alpine",305,1128,0.2703900709219858]
["Amador",7732,38223,0.20228658137770453]
["Butte",78475,216965,0.36169428248795887]
["Calaveras",11991,44394,0.27010406811731313]
["Colusa",9774,22483,0.43472846150424765]
["Contra Costa",258665,1153077,0.22432586895758044]
["Del Norte",11663,27520,0.42380087209302325]
["El Dorado",36573,191210,0.19127137702003033]
["Fresno",473905,1021960,0.46372167208109905]
["Glenn",12505,29197,0.42829742781792651]
["Humboldt",55230,134909,0.40938706832012689]
["Imperial",92625,190025,0.48743586370214448]
["Inyo",5273,18462,0.28561369299100858]
["Kern",412332,917379,0.44946745020324208]
["Kings",59110,154446,0.38272276394338473]
["Lake",32073,64889,0.49427483857048188]
["Lassen",7723,29880,0.25846720214190094]
["Los Angeles",3787881,10260237,0.36918065342935064]
["Madera",71330,158940,0.44878570529759659]
["Marin",44921,261627,0.17169863966639529]
["Mariposa",4795,17860,0.26847704367301234]
["Mendocino",40526,88590,0.45745569477367648]
["Merced",131862,283408,0.4652726810816914]
["Modoc",3299,9486,0.34777566940754795]
["Mono",3332,13881,0.24004034291477561]
["Monterey",179000,446539,0.40086084306186021]
["Napa",31090,140062,0.22197312618697435]
["Nevada",24890,98613,0.25240079908328517]
["Orange",841432,3220987,0.26123421174937994]
["Placer",58470,394737,0.1481239407504237]
["Plumas",6446,18858,0.34181779616078056]
["Riverside",834187,2443454,0.34139664589552332]
["Sacramento",534728,1553253,0.34426329773707182]
["San Benito",17701,62782,0.28194386926189036]
["San Bernardino",858035,2197650,0.39043296248265191]
["San Diego",833495,3357442,0.24825298545738095]
["San Francisco",203819,889360,0.22917491229648287]
["San Joaquin",284417,771700,0.36855902552805492]
["San Luis Obispo",56739,278902,0.20343704957296829]
["San Mateo",137720,776252,0.17741661213111207]
["Santa Barbara",146097,454529,0.32142503558628821]
["Santa Clara",385635,1961117,0.1966404860087389]
["Santa Cruz",73343,274545,0.26714381977453605]
["Shasta",61915,178029,0.34778041779710045]
["Sierra",773,3121,0.24767702659404037]
["Siskiyou",18090,44060,0.41057648660916929]
["Solano",115648,442145,0.26156125253027851]
["Sonoma",116769,498480,0.23425012036591236]
["Stanislaus",235506,558395,0.42175520912615622]
["Sutter",40700,103580,0.39293299864838771]
["Tehama",26489,65428,0.40485724766155162]
["Trinity",4529,13385,0.3383638401195368]
["Tulare",250968,479924,0.52293279769296808]
["Tuolumne",13021,52568,0.24769821944909451]
["Ventura",221857,853747,0.25986269937112516]
["Yolo",55095,222868,0.24720911032539442]
["Yuba",31752,78292,0.405558677770398]
[]
["Sources:"]
["Medi-Cal Enrollment by County; Created by Department of Health Care Services, MIS/DSS Data Warehouse."]
["https://www.dhcs.ca.gov/dataandstats/statistics/Documents/County_and_4-group_Table_Aug2019.zip"]
["County Population Projections; Prepared by Demographic Research Unit, California Department of Finance, January 2020"]
["http://www.dof.ca.gov/Forecasting/Demographics/projections/documents/P1_County_1yr.xlsx"]