{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Rejected Vote-By-Mail (VBM) By ","Reject Data","SOV Data (Per VoteCal))"],"read":"whole","date_system":"1900"}

{"sheet":"Rejected Vote-By-Mail (VBM) By ","index":0,"n_rows":11,"n_cols":17,"rows_kept":11,"merged":[[0,1,0,16],[2,1,2,16],[4,9,4,10],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,6,14],[6,15,7,15],[6,16,7,16],[10,1,10,16]]}
[null,"KCERA Retirement Board Special Election, April 16,2024\nKern County"]
[]
[null,"Rejected Vote-By-Mail (VBM) Ballots by Reason"]
[]
[{"$nulls":8},"As of:","2024-06-03"]
[]
[null,"Jurisdiction","Total VBM Ballots Issued (Distinct Voters)","Total VBM Ballots Returned","Total VBM Ballots Accepted","Percentage of VBM Ballots Accepted","Vote By Mail (VBM) Ballots Rejected Reasons",{"$nulls":8},"Total VBM Ballots Rejected","Percentage of VBM Ballots Rejected"]
[{"$nulls":6},"Voter already voted","Ballot missing from envelope","Multiple ballots returned in one envelope","Ballot was not received on time","Missing or incorrect address on envelope","No voter signature","Non-matching signature","No ID provided","Please contact your county for further information"]
[null,"Kern",{"v":9811,"d":"9,811"},481,405,{"v":0.84,"d":"84%"},{"$nulls":3},63,null,2,null,null,11,76,{"v":0.15,"d":"15%"}]
[null,"Total",{"v":9811,"d":"9,811"},481,405,{"v":0.84,"d":"84%"},{"$nulls":3},63,null,2,0,0,11,76,{"v":0.15,"d":"15%"}]
[null,"*Rejection reason data is provided by county elections officials to the Secretary of State through the VoteCal system. County elections officials can submit this data into the VoteCal system up to 60 days after an election. If additional information is provided by county elections officials, then the Secretary of State may provide a supplemental update."]

{"sheet":"Reject Data","index":1,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,11],[2,1,2,11],[3,7,4,7]]}
[]
[null,"KCERA Retirement Board Special Election"]
[null,"Detailed VBM Reject Data"]
[{"$nulls":6},"As of:","2024-06-03"]
[]
[]
[null,"County that sent the VBM","Ballot Serial Number","VBM Return Method","VoteCal Voter Id","EMS Voter Id","Current Voter's County","Reject Reason","VBM Sent Date","VBM Create Date-Time","VBM Update Date-Time","Last Name"]

{"sheet":"SOV Data (Per VoteCal))","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"merged":[[1,1,1,9],[3,2,3,7],[5,5,6,5]]}
[]
[null,"KCERA Retirement Board Special Election"]
[]
[null,null,"SOV Data Per VoteCal"]
[]
[{"$nulls":5},"As of:","2024-06-03"]
[]
[]
[{"$nulls":3},"CountyName","RowCreateDatetime","TotalVBMBallots","TotalBallotsCast","Election Code","VoteReportId"]