{"data":{"checkedAt":"2026-07-12","description":"Source acquisition tier registry for planning result, review, turnout, and method collection work. This classifies acquisition difficulty and scripting ROI; it does not replace loaded result or review data.","states":[{"state":"AL","stateName":"Alabama","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct_absentee_provisional_columns","exportFormats":["official precinct XLS ZIP","official turnout PDF","official voter registration XLSX","EAC fallback turnout CSV","county GeoJSON"],"sourceUrls":["https://www.sos.alabama.gov/alabama-votes/voter/election-data","https://www.sos.alabama.gov/sites/default/files/election-data/2024-12/2024-General%20Precinct%20Level%20Results.zip","https://www.sos.alabama.gov/sites/default/files/election-data/2025-01/2024GeneralElectionTotalBallotsCast.pdf","https://www.sos.alabama.gov/sites/default/files/election-data/2025-01/ALVR-2024.xlsx","https://www.sos.alabama.gov/public-records-request"],"exampleUrls":["https://www.sos.alabama.gov/sites/default/files/election-data/2024-12/2024-General%20Precinct%20Level%20Results.zip"],"availableFields":["official county presidential rows from the 2024 SOS precinct XLS ZIP","official precinct/reporting-mode President-versus-U.S. House review rows where House coverage is explicit","official 2012/2016/2020 county historical baseline rows","EAC fallback turnout rows plus Alabama SOS turnout/registration denominator leads","county geometry","county equipment context from Verified Voting Verifier","SOS public-records and county-official request paths for administration context"],"missingFields":["state-native turnout rows reconciled with denominator timing","precinct boundary geometry or official precinct-header crosswalk","normalized audit, CVR availability, recount, incident, correction, and litigation rows"],"parserStatus":"native county President rows, precinct/reporting-mode U.S. House review rows, EAC fallback turnout, county geometry, and official historical baseline rows are active through etl/state-configs/al.json; scripts/normalize-al-sos-results.mjs regenerates AL CSVs from official SOS artifacts","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The official 2024 precinct ZIP is loaded through generated CSVs from 67 county XLS files. U.S. House is district-based and no 2024 Alabama U.S. Senate race existed, so review rows are directional source-review signals only. Active turnout remains EAC fallback until SOS Total Ballots Cast PDF and ALVR denominator timing are reconciled; the generated precinct-ZIP ballots-cast lead is 180 lower than active EAC/SOS fallback ballots cast. County geometry is loaded, but precinct geometry/crosswalks and normalized audit/CVR/recount/incident/correction/litigation rows remain missing.","nextAction":"Review state-native turnout replacement semantics, especially the 180-ballot precinct-ZIP versus EAC/SOS fallback ballots-cast difference and ALVR denominator timing; then collect official precinct geometry/crosswalks and administration-context records."},{"state":"CA","stateName":"California","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"county","exportFormats":["XLSX Statement of Vote workbooks","PDF participation and registration tables","GeoJSON county geometry","EAC fallback benchmark CSV"],"sourceUrls":["https://www.sos.ca.gov/elections/prior-elections/statewide-election-results/general-election-nov-5-2024/statement-vote","https://elections.cdn.sos.ca.gov/sov/2024-general/sov/03-voter-participation-stats-by-county.pdf","https://www.sos.ca.gov/elections/prior-elections/statewide-election-results","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2706%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","https://www.sos.ca.gov/elections/election-cybersecurity","https://www.sos.ca.gov/elections/recounts","https://www.sos.ca.gov/administration/public-records-act-requests","https://statewidedatabase.org/election.html"],"exampleUrls":["https://elections.cdn.sos.ca.gov/sov/2024-general/sov/16-president.xlsx","https://elections.cdn.sos.ca.gov/sov/2024-general/sov/19-uss-ft.xlsx","https://statewidedatabase.org/d20/g24.html"],"availableFields":["official county presidential totals","official county U.S. Senate full-term comparison rows","official county voter participation and 15-day registered-voter denominator rows","Census county geometry","official 2012/2016/2020 county presidential historical baseline workbooks","official Statement of Vote voting-systems-by-county PDF lead and Verified Voting county equipment context","official election-security 1% manual audit description","SOS recount and Public Records Act request paths for remaining administration context","SWDB supplemental 2024 precinct/local result, registration, voter, geography, and conversion source lead documented for future reconciliation"],"missingFields":["precinct or city/local reporting-unit President rows","same-grain subcounty comparison contest rows","precinct boundary geometry or official county-local crosswalk","normalized post-election audit selection/outcome rows","normalized CVR availability, incident, correction, recount, litigation, custody, and tabulator-log records"],"parserStatus":"native county package loaded from official California SOS Statement of Vote President and U.S. Senate XLSX workbooks; official SOS county voter-participation PDF normalized by scripts/normalize-ca-turnout.mjs; historical 2012/2016/2020 county baselines normalized from official SOS workbooks","manualReviewBurden":"low","confidence":"loaded","caveats":"Current CA review rows are county-level President-versus-U.S. Senate full-term comparisons, not precinct or city/local scatter plots. Turnout uses SOS voter participation rows; registered voters are 15-day Report of Registration totals and do not include Same Day Voter Registration after the 15-day close. Normalized audit/CVR/incident/correction/recount/litigation rows are not loaded. SWDB is documented as a supplemental future precinct/local source lead only; SOS Statement of Vote remains authoritative for active certified county rows until any SWDB files are collected, masking-reviewed, and reconciled.","nextAction":"Use data/ca-2024-data-coverage-inventory.json and data/ca-2024-swdb-source-review.json as the current CA source-search records; next steps are precinct/local reporting-unit result exports, precinct geometry/crosswalks, and normalized audit/CVR/recount/incident/correction/litigation records from SOS or county sources."},{"state":"DC","stateName":"District of Columbia","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_historical_geometry","tier":"tier_1_official_export_database","reportingGrain":"official_precinct_to_single_county_equivalent","exportFormats":["official certified CSV","normalized county-equivalent CSV","Census GeoJSON"],"sourceUrls":["https://electionresults.dcboe.org/Downloads/Reports/November_8_2016_General_Election_Certified_Results.csv","https://electionresults.dcboe.org/Downloads/Reports/November_3_2020_General_Election_Certified_Results.csv","https://electionresults.dcboe.org/Downloads/Reports/November_5_2024_General_Election_Certified_Results.csv","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2711%27&outFields=GEOID%2CSTATE%2CCOUNTY%2CNAME%2CBASENAME&returnGeometry=true&outSR=4326&f=geojson"],"exampleUrls":["https://electionresults.dcboe.org/Downloads/Reports/November_5_2024_General_Election_Certified_Results.csv"],"availableFields":["official certified 2016, 2020, and 2024 presidential candidate votes","single county-equivalent FIPS 11001","official precinct counts and overvote/undervote reconciliation","Census county-equivalent geometry"],"missingFields":["same-grain comparison contest","reviewed turnout and registration denominator package"],"parserStatus":"scripts/normalize-dc-certified-results.mjs verifies reviewed source hashes and emits one 2024 row plus one historical row for each of 2016 and 2020, all joined to county:11001.","manualReviewBurden":"low","confidence":"loaded","caveats":"D.C. is one county-equivalent. Overvotes and undervotes are reconciled separately and excluded from candidate totals; no sub-county FIPS units are inferred.","nextAction":"Add comparison and turnout context if needed; county FIPS coverage is complete."},{"state":"FL","stateName":"Florida","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct_location","exportFormats":["official county detail tables","official precinct-level ZIP","field definitions PDF","tab-delimited statewide extract"],"sourceUrls":["https://dos.fl.gov/elections/data-statistics/elections-data/precinct-level-election-results/","https://results.elections.myflorida.com/DetailRpt.Asp?ELECTIONDATE=11/5/2024&RACE=PRE&PARTY=&DIST=&GRP=&DATAMODE=","https://results.elections.myflorida.com/downloadresults.asp?ElectionDate=11/5/2024&DATAMODE="],"exampleUrls":[],"availableFields":["certified county presidential rows from official county detail table","precinct/location President versus U.S. Senate review rows from official precinct ZIP","precinct/location registered-voter denominator lead from official precinct ZIP","county turnout from EAC fallback","county geometry","secondary 2012/2016/2020 county historical presidential baselines"],"missingFields":["state-native ballots-cast rows compatible with the precinct ZIP registration denominator","precinct boundary geometry and result-label crosswalk","official 2012/2016/2020 historical baseline replacement rows","normalized audit, recount, CVR availability, incident, correction, litigation, custody, and tabulator-log rows"],"parserStatus":"nativeFloridaDetailHtml keeps certified county map totals from the official county detail table; floridaPrecinctZipPresidentSenate loads 5,618 same-grain President-versus-U.S. Senate precinct/location review rows from data/fl-2024-general-precinct-results.zip; EAC fallback turnout remains active","manualReviewBurden":"low","confidence":"loaded_with_caveat","caveats":"The official precinct ZIP is valid for same-grain review rows and registration-denominator leads, but not for replacing certified county map totals: its presidential candidate total is 204 votes below the official county detail table and its Trump total is one vote higher. The ZIP does not provide compatible ballots-cast rows, so turnout remains EAC fallback.","nextAction":"Collect compatible Florida state-native ballots-cast/turnout rows, precinct geometry/crosswalks, official historical baseline replacements, and normalized audit/CVR/recount/incident/correction/litigation records."},{"state":"HI","stateName":"Hawaii","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct_split","exportFormats":["official certified text export","official certified PDF reports","EAC fallback turnout CSV","GeoJSON county geometry","official 2016/2020 certified historical text exports"],"sourceUrls":["https://elections.hawaii.gov/election-results/","https://files.hawaii.gov/elections/files/results/2024/General/summary.txt","https://files.hawaii.gov/elections/files/results/2024/General/media.txt","https://elections.hawaii.gov/resources/registration-voter-turnout-statistics/","https://elections.hawaii.gov/resources/maps/geographic-information-systems-gis-files/","https://files.hawaii.gov/elections/files/results/2016/general/summary.txt","https://files.hawaii.gov/elections/files/results/2016/general/media.txt","https://files.hawaii.gov/elections/files/results/2020/general/summary.txt","https://files.hawaii.gov/elections/files/results/2020/general/media.txt","https://files.hawaii.gov/elections/files/maps/Election2024Maps/HD_13.pdf","https://files.hawaii.gov/elections/files/maps/precincttext/Precinct-Boundary-Descriptions-Statewide.pdf"],"exampleUrls":["https://files.hawaii.gov/elections/files/results/2024/General/summary.txt","https://files.hawaii.gov/elections/files/results/2024/General/media.txt"],"availableFields":["official statewide certified President totals from summary.txt","official county presidential rows aggregated from numbered precinct/split rows","official precinct/split President rows","official same-grain U.S. Senate comparison rows","official Hawaii Office county registration and turnout rows","county geometry","equipment context from Verified Voting","official 2024 recount/provisional/security/source-request paths documented in coverage inventory","official Hawaii Office 2020 county historical presidential baseline rows with county:<GEOID> tags","official county presidential rows aggregated from the Office of Elections precinct/split text export","official precinct/split President rows for 467 nonzero numbered precinct/split units","official precinct/split U.S. Senate comparison rows for all 467 nonzero President review units","official precinct/split registered-voter and ballots fields in precinct detail text retained as turnout lead context","state-native turnout and registration table lead","supplemental county equipment context","official 2016 and 2020 county presidential historical baseline rows with county:<GEOID> tags","Kalawao County FIPS 15005 result rows for 2016, 2020, and 2024 from exact precinct 13-09"],"missingFields":["precinct boundary geometry or official precinct_splitId crosswalk","normalized official audit, recount, CVR availability, incident, correction, and litigation rows","reconciled state-native turnout replacement for active EAC fallback","official 2024 precinct boundary geometry or precinct_splitId crosswalk","normalized audit, recount, CVR availability, incident, correction, and litigation rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"nativeHawaiiOfficeText emits five 2024 county/county-equivalent President rows, 467 review rows, and four state-native turnout rows; the historical normalizer emits five rows each for 2016 and 2020. Exact Kalawao and Maui residual tuples fail closed.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Official map and boundary evidence identify precinct 13-09 as Kalawao County FIPS 15005. The Hawaii Office turnout table still has only four election-county rows, so no Kalawao turnout denominator is invented. Full precinct geometry remains unloaded.","nextAction":"Collect official 2012 Hawaii historical baseline rows, precinct geometry/crosswalks if subcounty overlays are pursued, and normalized audit/CVR/recount/incident/correction/litigation records."},{"state":"IL","stateName":"Illinois","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical","tier":"tier_1_official_export_database","reportingGrain":"county_results_and_historical_with_precinct_review","exportFormats":["official by-office CSV downloads","EAC fallback turnout","official by-office turnout-field review JSON","official 2020 by-office President CSV","normalized historical baseline CSV","official Candidate Totals by County XLS workbooks","normalized historical county CSV"],"sourceUrls":["https://www.elections.il.gov/ElectionOperations/ElectionVoteTotals.aspx?ID=66","https://www.elections.il.gov/ElectionOperations/ElectionVoteTotals.aspx?ID=58","https://www.eac.gov/research-and-data/studies-and-reports","https://www.elections.il.gov/ElectionOperations/DownloadVoteTotals.aspx","https://www.elections.il.gov/Downloads/ElectionOperations/VoteTotals/GE2016Cty.xls","https://www.elections.il.gov/Downloads/ElectionOperations/VoteTotals/GE2020Cty.xls"],"exampleUrls":[],"availableFields":["precinct presidential results","precinct U.S. House results","by-office Registration field reviewed as denominator lead only","President contest over-vote, under-vote, and blank-ballot rows reviewed as contest-total lead only","EAC fallback turnout","official 2020 county-named election-authority presidential historical baseline rows","jurisdiction registration by precinct","102 county presidential result rows aggregated from official 2024 election-jurisdiction exports","official 2016 and 2020 Candidate Totals by County workbooks normalized to 102 canonical county tags per year"],"missingFields":["state-native turnout or voter-participation artifact with confirmed ballots-cast field and denominator timing","valid precinct registration denominator for all election authorities","statewide Senate/Governor same-grain comparison contest for 2024","state-native turnout denominator artifact promoted separately","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"illinoisElectionResultsByOfficeCsvDirectory rolls six separate city election authorities into 102 county result rows and loads precinct President-versus-U.S.-House review rows; scripts/report-il-turnout-source-review.mjs retains EAC turnout after rejecting the by-office fields as a valid replacement; scripts/collect-il-historical-presidential-baseline.mjs loads 204 official 2016/2020 county rows; scripts/reconcile-il-historical-promotion.mjs pins the live-to-staged correction.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Illinois 2024 has no statewide U.S. Senate or Governor contest in the by-office package. Review rows compare President to U.S. House only where the jurisdiction/precinct key is unambiguous and the House row has both Democratic and Republican candidate votes; split/multi-district precinct keys and uncontested House rows are omitted. Historical workbooks contain candidate and write-in votes but not blank, undervote, or overvote records.","nextAction":"After promotion, confirm 102 county result rows, 204 historical rows, and 90 stored indicators; pursue a valid state-native turnout denominator and official 2012 county baseline."},{"state":"KS","stateName":"Kansas","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_inventory","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["XLSX","PDF","GeoJSON","EAC fallback CSV","equipment context CSV"],"sourceUrls":["https://sos.ks.gov/elections/elections-statistics.html","https://sos.ks.gov/elections/24elec/2024-Presidential-Results.xlsx","https://sos.ks.gov/elections/24elec/2024-General-Election-United-States-House-of-Representatives-Precinct-Results.xlsx","https://sos.ks.gov/elections/24elec/2024-General-Election-Official-Vote-Totals.pdf","https://www.eac.gov/research-and-data/studies-and-reports","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/20"],"exampleUrls":["https://sos.ks.gov/elections/24elec/2024-Presidential-Results.xlsx","https://sos.ks.gov/elections/24elec/2024-General-Election-United-States-House-of-Representatives-Precinct-Results.xlsx"],"availableFields":["official county presidential totals from SOS presidential workbook","official precinct presidential rows from SOS presidential workbook","official precinct U.S. House comparison rows from SOS workbook","official certified vote-total PDF provenance","EAC fallback county turnout and registered-voter denominator rows","Census county geometry","county equipment context from Verified Voting Verifier","official 2020 county historical presidential baselines","mixed official/secondary 2012 and 2016 county historical presidential baselines with caveats"],"missingFields":["state-native turnout denominator and ballots-cast rows","precinct boundary geometry or precinct crosswalk","official 2012, 2016, and 2020 historical presidential baseline rows","normalized post-election audit selection/outcome rows","official CVR availability or request-produced CVR records","official incident, correction, recount, and litigation records"],"parserStatus":"nativeKansasPresidentialHouseXlsx package loaded from official Kansas SOS presidential and U.S. House workbooks; historicalPresidentialCsv loaded from official 2020 SOS workbook rows, mostly official 2016 rows, and secondary contextual 2012/missing-2016 county rows; EAC fallback turnout and Census county geometry loaded; data/ks-2024-data-coverage-inventory.json documents remaining official-source gaps","manualReviewBurden":"low","confidence":"loaded","caveats":"U.S. House is district-based, so precinct review rows are advisory screening context. Three nonzero presidential local rows lack matching House comparison rows and are kept as vote-share-only rows. Turnout remains EAC fallback until Kansas-native turnout/registration rows are collected and reconciled. County geometry is loaded; precinct geometry and normalized audit/CVR/incident/recount/litigation rows are not loaded. Historical baselines are contextual: 2020 is official, 2016 uses four secondary county rows for counties absent from the SOS workbook, and 2012 secondary county rows do not reconcile to the SOS statewide certified total.","nextAction":"Use data/ks-2024-data-coverage-inventory.json as the current KS source-search record; next steps are Kansas-native turnout denominators, precinct geometry/crosswalks, official replacement for 2012 county historical baselines if obtainable, and official audit/CVR/incident/correction/recount/litigation records."},{"state":"MA","stateName":"Massachusetts","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"city_town_ward_precinct","exportFormats":["official PD43+ CSV download","official PD43+ county-filtered HTML totals","official PD43+ historical county HTML tables","official statewide turnout statistics page","EAC fallback turnout"],"sourceUrls":["https://electionstats.state.ma.us/elections/download/165300/precincts_include:1/","https://electionstats.state.ma.us/elections/view/165300/","https://electionstats.state.ma.us/elections/download/165304/precincts_include:1/","https://electionstats.state.ma.us/elections/view/112698/","https://electionstats.state.ma.us/elections/view/130243/","https://electionstats.state.ma.us/elections/view/140751/","https://www.sec.state.ma.us/divisions/elections/research-and-statistics/voter-turnout-statistics.htm","https://www.sec.state.ma.us/divisions/elections/recent-updates/2024-post-election-audits.htm","https://www.eac.gov/research-and-data/studies-and-reports","https://www.sec.state.ma.us/divisions/elections/research-and-statistics/registration-statistics.htm"],"exampleUrls":["https://electionstats.state.ma.us/elections/view/165300/","https://electionstats.state.ma.us/elections/view/165304/"],"availableFields":["official county President rows","municipality President rows","ward/precinct President rows","ward/precinct U.S. Senate comparison rows","EAC jurisdiction turnout fallback with official statewide turnout cross-check","official 2012/2016/2020 PD43+ county historical presidential baselines","county geometry","county equipment context","official post-election audit source page and request paths","official Massachusetts registration statistics page verified as a statewide/local enrollment source lead"],"missingFields":["state-native local turnout denominator rows","precinct/ward/municipal geometry or reporting-unit crosswalk","normalized detailed audit workpapers and discrepancy rows","normalized CVR availability, ballot-image availability, tabulator-log, logic-and-accuracy, custody, incident, correction, recount, and litigation records"],"parserStatus":"massachusettsPd43PrecinctCsv loaded for county certified results and city/town/ward/precinct President-vs-U.S. Senate review rows; historicalPresidentialCsv now generated from official PD43+ 2012/2016/2020 county pages; data/ma-2024-data-coverage-inventory.json documents turnout, geometry, audit, CVR, and incident gaps","manualReviewBurden":"low","confidence":"loaded","caveats":"PD43+ bulk CSV rows are municipality-centric and do not include county, so county certified result rows are collected from official PD43+ county-filtered County Totals pages. Turnout remains EAC jurisdiction fallback, with only a statewide Massachusetts turnout-statistics cross-check. Historical rows are contextual county baselines; the 2020 PD43+ county rows sum one non-D/R vote above the statewide summary line. Administration inventory records request paths only and does not load CVR, ballot-image, tabulator-log, L&A, custody, incident, correction, recount, or litigation rows.","nextAction":"Collect a Massachusetts state-native local turnout denominator export, official precinct/ward/municipal geometry or reporting-unit crosswalk, and detailed audit/CVR/log/L&A/custody/incident/recount/litigation artifacts or request responses."},{"state":"MD","stateName":"Maryland","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["official statewide all-precinct CSV","official precinct reference XLSX","EAC fallback turnout","official 2020 county result CSVs","official 2016 county result HTML","official 2020 all-by-precinct CSV","historicalPresidentialCsv"],"sourceUrls":["https://elections.maryland.gov/elections/archive/2024/election_data/PG24_AllPrecincts.csv","https://elections.maryland.gov/elections/archive/2024/Polling%20Places%20AEMS%20PG24.xlsx","https://www.eac.gov/research-and-data/studies-and-reports","https://elections.maryland.gov/elections/archive/2020/election_data/index.html","https://elections.maryland.gov/elections/archive/2020/election_data/All_State_2020_General.csv","https://elections.maryland.gov/elections/archive/2016/results/general/gen_detail_results_2016_4_BOT001-.html","https://elections.maryland.gov/elections/archive/2020/election_data/All_By_Precinct_2020_General.csv","https://elections.maryland.gov/elections/archive/2020/results/general/gen_results_2020_4_001-.html"],"exampleUrls":["https://elections.maryland.gov/elections/archive/2024/election_data/index.html"],"availableFields":["county presidential totals aggregated from precinct rows","precinct President candidate rows","same-grain U.S. Senate comparison rows","early vote totals","election night vote totals","mail-in ballot round 1 totals","provisional totals","mail-in ballot round 2 totals","EAC fallback turnout","official 2020 county/county-equivalent presidential historical baseline rows","official 2016 county/county-equivalent presidential historical baselines","official 2020 county/county-equivalent presidential historical baselines"],"missingFields":["state-native precinct registered-voter denominator","precinct boundary geometry","audit/CVR/incident artifacts","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"marylandPrecinctCsv parser loaded in etl/state-configs/md.json; scripts/normalize-md-historical-presidential-baseline.mjs now loads official 2016 and 2020 county/county-equivalent historicalPresidentialCsv rows","manualReviewBurden":"low","confidence":"loaded","caveats":"Official SBE precinct candidate rows support President-versus-U.S.-Senate directional screening. Turnout still uses EAC jurisdiction fallback until a Maryland-native registered-voter denominator is collected. Official 2016 and 2020 historical county/county-equivalent baselines are loaded; 2012 remains uncollected.","nextAction":"Collect Maryland state-native registered-voter/ballots-cast denominator rows, official 2012 county/county-equivalent presidential baseline rows, and any post-election audit/CVR/incident artifacts."},{"state":"ME","stateName":"Maine","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"municipality_county","exportFormats":["official Excel workbooks","official RCV/CVR Excel exports","EAC fallback turnout CSV","registered/enrolled voter text files","county GeoJSON"],"sourceUrls":["https://www.maine.gov/sos/elections-voting/election-results-data/election-results-2024","https://www.maine.gov/sos/elections-voting/voter-data/previous-enrollment-data","https://www.maine.gov/sos/elections-voting/election-results-data/previous-election-results","https://www.eac.gov/research-and-data/studies-and-reports","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/23","https://www.maine.gov/sos/elections-voting/voter-data/statewide-registered-and-enrolled-voter"],"exampleUrls":["https://www.maine.gov/sos/sites/maine.gov.sos/files/inline-files/President%20and%20Vice%20President%20FINAL-Corrected%2020241205.xlsx","https://www.maine.gov/sos/sites/maine.gov.sos/files/inline-files/US%20Senator%20FINAL-Corrected%2020241205.xlsx"],"availableFields":["official county/town presidential Excel rows loaded","official county/town U.S. Senate comparison Excel rows loaded","official presidential congressional-district Excel artifact retained for split-electoral-vote context","official EAC fallback turnout rows loaded","official Maine SOS active/inactive registered-enrolled denominator leads collected","county geometry","county equipment context","official 2016 and 2020 county historical baselines loaded"],"missingFields":["state-native ballots-cast or voter-participation rows paired with registration denominators","municipality/town geometry or official reporting-unit crosswalk","normalized official 2012 historical baseline rows from legacy XLS artifacts","normalized audit, recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"nativeMaineSosCountyTownXlsx loads official Maine SOS President county/town rows, U.S. Senate town comparison rows, EAC fallback turnout, and official 2016/2020 historical rows; data/me-2024-data-coverage-inventory.json documents remaining turnout, geometry, 2012 XLS, and admin gaps","manualReviewBurden":"low","confidence":"loaded_with_caveat","caveats":"State UOCAVA is loaded as a non-geographic certified result row and excluded from town review joins. Three town rows are vote-share-only because the Senate workbook grain differs. U.S. Senate includes a major independent candidate, so dropoff fields are directional source-review context only. Turnout remains EAC fallback until state-native ballots-cast semantics are reviewed.","nextAction":"Collect compatible Maine-native ballots-cast/voter-participation rows, municipality/town geometry or a crosswalk, legacy .xls parsing/conversion for 2012 historical baselines, and normalized audit/CVR/recount/incident/correction/litigation records."},{"state":"MI","stateName":"Michigan","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["TXT","ZIP","PDF registration reference","secondary historical CSV","admin source inventory JSON"],"sourceUrls":["https://mvic.sos.state.mi.us/VoteHistory/"],"exampleUrls":[],"availableFields":["county results","precinct President rows","precinct U.S. Senate rows","county registration/turnout","2012, 2016, and 2020 county historical presidential baseline rows","equipment context","administration source inventory"],"missingFields":["precinct boundary geometry","official script-readable 2012/2016/2020 historical county presidential exports","normalized audit/recount/CVR/incident/correction records"],"parserStatus":"native precinct review package loaded with secondary historical baseline and administration source inventory","manualReviewBurden":"low","confidence":"loaded_with_caveat","caveats":"Turnout is county-level, not precinct-level. Historical baseline rows are secondary contextual county tables because MVIC and mielections.us official historical paths were not script-readable in this environment; replace with official Michigan SOS exports if collected. Administration inventory documents source paths and request needs but does not load row-level audit, recount, CVR, incident, or correction records.","nextAction":"Collect official script-readable Michigan historical result exports, official statewide precinct boundary geometry or reporting-unit crosswalks, and row-level 2024 audit/recount/CVR/incident/correction artifacts if available."},{"state":"MN","stateName":"Minnesota","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["XLSX"],"sourceUrls":["https://www.sos.mn.gov/elections-voting/election-results","https://www.sos.mn.gov/media/yt3llxwd/2024-general-federal-state-results-by-precinct-official.xlsx"],"exampleUrls":["https://www.sos.mn.gov/media/yt3llxwd/2024-general-federal-state-results-by-precinct-official.xlsx"],"availableFields":["county presidential rows aggregated from the official precinct workbook","precinct President rows","precinct U.S. Senate rows","precinct TOTVOTING turnout rows","precinct REG7AM plus EDR registration denominator fields"],"missingFields":["precinct boundary geometry"],"parserStatus":"native Minnesota precinct workbook parser is active through etl/state-configs/mn.json and civic_etl.native: it loads 87 county result rows, 4,075 President-versus-U.S.-Senate review rows, and 4,103 turnout rows from the official SOS workbook","manualReviewBurden":"low","confidence":"loaded","caveats":"Turnout denominator is REG7AM plus EDR, so election-day registrations are included in the denominator. Precinct boundary GeoJSON is not included; county geometry is loaded for county map joins only.","nextAction":"Treat as an example Tier 1 goal state; optional next step is precinct geometry."},{"state":"MS","stateName":"Mississippi","jurisdictionName":"Statewide county recap CSV","scope":"statewide","dataFamily":"results_review","tier":"tier_1_official_export_database","reportingGrain":"county","exportFormats":["CSV","PDF reference"],"sourceUrls":["https://www.sos.ms.gov/elections/electionresults/2024ElectionRecapSheets.csv"],"exampleUrls":["https://www.sos.ms.gov/elections-voting/election-results/2024/2024-general-election-results","https://www.sos.ms.gov/elections-voting/election-results/2020/2020-general-election","https://www.sos.ms.gov/elections-voting/election-results/2016/2016-general-election","https://www.sos.ms.gov/elections-voting/election-results/2012/2012-election-results","https://www.sos.ms.gov/elections-voting/active-voter-count-reports"],"availableFields":["county President rows","county U.S. Senate rows","November 2024 active-voter denominator lead with generated EAC fallback comparison summary","official 2012/2016/2020 county historical presidential baseline rows"],"missingFields":["precinct rows","state-native ballots-cast turnout rows to pair with the collected November 2024 active-voter denominator lead"],"parserStatus":"mississippiElectionRecapCsv loaded for county review; scripts/collect-ms-active-voter-count.mjs normalizes the official November 2024 Active Voter Count denominator lead and writes data/ms-2024-turnout-denominator-lead-summary.json; scripts/collect-ms-historical-baseline.mjs loads official SOS 2012/2016/2020 county presidential baselines; data/ms-2024-source-request-matrix.tsv tracks OCR, turnout, geometry, and administration-context follow-up asks","manualReviewBurden":"low","confidence":"loaded","caveats":"County-level review is useful but not a precinct-level scatter plot. The collected SOS Active Voter Count PDF and generated summary are denominator-lead context only and do not replace ballots-cast turnout rows by themselves.","nextAction":"Keep loaded county and historical packages; use data/ms-2024-source-request-matrix.tsv to pair the collected November 2024 active-voter denominator lead with official Mississippi ballots-cast/voter-participation rows before replacing EAC turnout, and continue OCR/manual review before any precinct promotion."},{"state":"MT","stateName":"Montana","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["XLSX","historical precinct XLSX","normalized historical baseline CSV","write-in canvass PDF context"],"sourceUrls":["https://sosmt.gov/elections/results/","https://electionresults.mt.gov/ResultsList.aspx?eid=450002785","https://sosmt.gov/docs/32/results/66992/2024_general_precinct_by_precinct","https://sosmt.gov/docs/31/post-election/66775/2024-general-election-report-state-canvass","https://sosmt.gov/elections/systems/","https://sosmt.gov/wp-content/uploads/2020_General_Precinct-by-Precinct.xlsx","https://sosmt.gov/wp-content/uploads/State_Canvass_Report.pdf","https://sosmt.gov/Portals/142/Elections/archives/2010s/2016/2016-General-Results-by-Precinct.xlsx","https://sosmt.gov/wp-content/uploads/attachments/2016GeneralStateCanvassWriteIn.pdf","https://sosmt.gov/wp-content/uploads/State_Canvass_Writein_by_County.pdf"],"exampleUrls":["https://sosmt.gov/docs/32/results/66992/2024_general_precinct_by_precinct","https://sosmt.gov/docs/31/post-election/66775/2024-general-election-report-state-canvass","https://sosmt.gov/wp-content/uploads/2020_General_Precinct-by-Precinct.xlsx"],"availableFields":["precinct President rows","precinct U.S. Senate rows","official statewide canvass context","EAC fallback county/jurisdiction turnout rows","county geometry","Verified Voting county equipment context","official 2020 county presidential historical baseline rows with county:<GEOID> tags","official 2016 county presidential historical baseline rows","official 2020 county presidential historical baseline rows","official 2016 and 2020 write-in canvass context"],"missingFields":["state-native turnout denominator","precinct boundary geometry","normalized post-election audit/recount/CVR availability artifacts","normalized incident/correction/litigation records","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"montanaPrecinctResultsXlsx loaded for official precinct President-versus-U.S. Senate review rows; historical 2016 and 2020 county baselines normalized from official SOS precinct workbooks with write-in caveat; EAC fallback turnout is warning-marked; 2012 historical and admin-context artifacts remain inventory/documentation gaps","manualReviewBurden":"low","confidence":"loaded","caveats":"Official workbook rows omit separate write-in canvass votes: 27 in 2024, and historical write-in canvass totals are retained as context rather than allocated into county other_votes. County maps use Census county geometry only. Turnout currently uses warning-marked EAC fallback rows until a Montana state-native denominator artifact is collected.","nextAction":"Collect or normalize Montana state-native turnout denominators, precinct boundary geometry, official 2012 county historical baseline, and post-election audit/recount/CVR/incident/correction context."},{"state":"NC","stateName":"North Carolina","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct_review_county_certified_historical_review","exportFormats":["ZIP","CSV"],"sourceUrls":["https://www.ncsbe.gov/results-data/election-results/historical-election-results-data","https://www.ncsbe.gov/results-data/voter-turnout/2024-general-election-turnout","https://www.ncsbe.gov/results-data/voter-registration-data","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2024_11_05/history_stats_20241105.zip","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2024_11_05/voter_stats_20241105.zip","https://www.ncsbe.gov/results-data/voter-history-data","https://www.ncsbe.gov/results-data/voting-maps-redistricting","https://www.ncsbe.gov/about-elections/election-security/post-election-procedures-and-audits","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2016_11_08/results_pct_20161108.zip","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2020_11_03/results_pct_20201103.zip"],"exampleUrls":[],"availableFields":["certified county President rows from all reporting units","Real Precinct=Y President review rows","Real Precinct=Y Governor comparison rows","EAC fallback county turnout","official 2012/2016/2020 county historical presidential baselines","official precinct shapefile folder lead","official 2024 post-election audit PDF lead","official NCSBE 2024 voter_stats registered-voter denominator lead","official NCSBE 2024 history_stats voter-history turnout lead","generated county turnout-denominator lead and source-review summary","official 2016 county President-versus-U.S.-Senate historical advisory rows aggregated from all 3,209 source reporting-unit keys across 100 canonical county tags","official 2020 same-grain President-versus-U.S.-Senate historical advisory rows for 2,662 Real Precinct=Y county/precinct keys across 100 county tags"],"missingFields":["state-native turnout replacement semantics for history_stats voters versus ballots cast","precinct boundary geometry normalized for map joins","normalized audit/recount/CVR/incident/correction records"],"parserStatus":"native county certified package loaded; 2024 review rows filtered to official Real Precinct=Y rows; historicalPresidentialCsv loaded from official NCSBE 2012/2016/2020 precinct result ZIPs; scripts/normalize-nc-historical-review.mjs generates 100 official 2016 county President-versus-U.S.-Senate rows from the source County field plus 2,662 official 2020 Real Precinct=Y rows, while reconciling the 2016 statewide totals, all 100 presidential baseline tuples, one signed source correction, and the 403 excluded 2020 Real Precinct=N keys; scripts/normalize-nc-turnout.mjs generates NCSBE voter_stats/history_stats turnout-denominator lead rows and source-review summary, but active turnout remains EAC fallback pending numerator semantics review","manualReviewBurden":"medium","confidence":"loaded","caveats":"Certified county totals aggregate all official reporting units, including early, absentee, provisional, and transfer rows. Review charts use only rows where the NCSBE Real Precinct field is Y, covering 2,658 precinct rows and 3,923,739 of 5,699,141 presidential votes; excluded non-real reporting units account for 1,775,402 presidential votes. NCSBE voter_stats_20241105.zip matches the active EAC registered-voter denominator at 7,854,464, but NCSBE history_stats_20241105.zip reports 5,705,861 voters who participated, 50,245 below EAC ballots cast and 18,126 below the NCSBE turnout overview ballots-cast figure. Historical baselines are county aggregates for context only. The 2016 historical advisory package aggregates all official reporting rows by the explicit County field into 100 county rows: 4,741,564 presidential votes and 4,691,133 U.S. Senate votes. All presidential county tuples match the official baseline; one signed -4 write-in source correction is retained before final nonnegative reconciliation, and no precinct-level claim is made. The 2020 package includes 2,662 Real Precinct=Y keys across 100 canonical county tags: 3,201,711 included presidential votes and 3,172,016 included U.S. Senate votes. It excludes and exactly reconciles 403 Real Precinct=N administrative keys totaling 2,323,091 presidential votes and 2,302,936 comparison votes.","nextAction":"Keep the 2024 and 2020 Real Precinct=Y review caveats visible and describe the 2016 historical screen as county-only aggregation, not precinct evidence; review NCSBE history_stats voter-participation semantics against ballots-cast/eligible-voter published totals before replacing EAC turnout; next upgrades are normalized precinct boundary geometry from the NCSBE shapefile folder and normalized audit/recount/CVR/incident/correction records."},{"state":"NH","stateName":"New Hampshire","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin_inventory","tier":"tier_1_official_export_database","reportingGrain":"town_ward","exportFormats":["XLS","XLSX","normalized CSV","archived official 2016/2020 XLS/XLSX baseline workbooks","admin inventory JSON","source request matrix TSV"],"sourceUrls":["https://www.sos.nh.gov/2024-general-election-results"],"exampleUrls":["https://web.archive.org/web/20241219172754id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-president_3.xls","https://web.archive.org/web/20250311214424id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-congressional-district-1_3.xlsx","https://web.archive.org/web/20250611055423id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-names-on-checklist_7.xlsx","https://web.archive.org/cdx?url=www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2016-ge-president*&output=json&fl=timestamp,original,statuscode,mimetype&filter=statuscode:200&collapse=urlkey","https://web.archive.org/web/20240720085749id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2016-ge-governor.xls","https://web.archive.org/web/20240720085753id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2016-ge-congressional-district-1.xlsx","https://www.sos.nh.gov/elections/2020-election-results/2020-general-election-results","https://web.archive.org/web/20231127033944id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/documents/2020%20GE%20Election%20Tallies/2020-president.xls","https://web.archive.org/web/20231127033944id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/documents/2020%20GE%20Election%20Tallies/2020-presidential-write-ins.xls"],"availableFields":["town/ward President rows","town/ward U.S. House comparison rows by congressional district","town/ward Governor comparison rows retained as context","town/ward ballots-cast rows","town/ward names-on-checklist registered-voter denominator rows","county geometry","county equipment context","official 2016 and 2020 county presidential historical baseline rows normalized from archived SOS workbooks","NH administration/source inventory with recount, geometry, audit, CVR, incident, correction, and litigation request paths","NH source request matrix with exact follow-up rows for 2016/2020/2012 historical baselines, town/ward geometry, and administration-context records"],"missingFields":["official 2012 historical President baseline and historical President-versus-U.S. House/Governor ticket-splitting baselines","town/ward boundary geometry","normalized post-election audit rows","normalized recount, CVR availability, incident/correction, and litigation rows"],"parserStatus":"newHampshireTownWardCsv loaded with official President, Governor, U.S. House, ballots-cast, and names-on-checklist rows normalized by scripts/normalize-nh-general-workbooks.mjs; scripts/normalize-nh-historical-baseline.mjs now generates 20 official county historical presidential rows for 2016 and 2020 with county:<GEOID> tags; data/nh-2024-admin-source-inventory.json records remaining admin/geometry/2012 request paths","manualReviewBurden":"medium","confidence":"loaded_with_district_comparison_and_historical_caveats","caveats":"Live SOS pages are access-limited from this environment; archived official workbook artifacts are retained. U.S. House is same town/ward grain but district-based rather than a single statewide contest. State-native ballots-cast and names-on-checklist rows replace EAC fallback turnout, with a one-vote source summary/detail caveat in ballots-cast totals. Official 2016 and 2020 county historical presidential baselines are loaded as contextual county rows with FIPS jurisdiction tags; 2012 remains a targeted archive/records-request item tracked in data/nh-2024-source-request-matrix.tsv.","nextAction":"Continue targeted archive/records requests for official 2012 historical baseline artifacts; request town/ward geometry or a reporting-unit crosswalk; normalize official audit/recount/CVR/incident/correction/litigation records if obtained."},{"state":"OH","stateName":"Ohio","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_admin","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["XLSX","official precinct rows"],"sourceUrls":["https://www.ohiosos.gov/elections/election-results-and-data/"],"exampleUrls":[],"availableFields":["precinct presidential rows","precinct U.S. Senate comparison rows","ward-level review rows","precinct registered-voter turnout denominator rows","county equipment context"],"missingFields":["precinct boundary geometry","normalized official post-election audit result rows","statewide CVR availability inventory","incident, correction, recount, and litigation source inventory","2020, 2016, and 2012 historical baselines"],"parserStatus":"native official XLSX package loaded for county certified results, precinct President-versus-U.S.-Senate review rows, and precinct registered-voter turnout rows","manualReviewBurden":"low","confidence":"loaded","caveats":"Ohio comparison screening is mapped from the Secretary of State precinct-level U.S. Senate rows in the same official workbook as the presidential precinct rows. County geometry is loaded for map joins, but precinct boundary geometry is not loaded. Audit, DATA Act/CVR availability, incident/correction/recount/litigation context, and official historical baselines remain source-inventory gaps.","nextAction":"Collect official precinct boundary geometry if available; inventory Ohio 2024 post-election audit/CVR/recount/correction/litigation sources; then add official 2020/2016/2012 county presidential baselines."},{"state":"OK","stateName":"Oklahoma","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["official race-level CSV","official county-level CSV ZIP","official precinct-level CSV ZIP","EAC fallback turnout CSV","Census county GeoJSON","Verified Voting equipment context CSV","official Nov. 1 voter-registration PDF denominator lead","official 2020 results app county tables","official historical county-level CSV ZIP","normalized historical county CSV"],"sourceUrls":["https://oklahoma.gov/elections/elections-results/election-results/2024-election-results/november-general-election.html","https://results.okelections.gov/OKERS/enrapi/GetExtract/CSV/20241105","https://results.okelections.gov/OKERS/enrapi/GetExtract/CLCSV/20241105","https://results.okelections.gov/OKERS/enrapi/GetExtract/PLCSV/20241105","https://www.eac.gov/research-and-data/studies-and-reports","https://oklahoma.gov/elections/security-integrity/post-election-audits/post-election-audit-archives/2024-post-election-audits.html","https://oklahoma.gov/elections/candidates/district-and-precinct-maps.html","https://oklahoma.gov/elections/about-us/information-and-records-requests.html","https://oklahoma.gov/content/dam/ok/en/elections/voter-registration-statistics/2024-vr-statistics/vrstats-district-nov1-2024.pdf","https://results.okelections.gov/OKER/?elecDate=20201103","https://oklahoma.gov/elections/elections-results/election-results/2016-election-results/2016-november-general-election.html","https://results.okelections.gov/OKERS/enrapi/GetExtract/CLCSV/20161108","https://oklahoma.gov/elections/elections-results/election-results/2020-election-results/2020-november-general-election.html","https://results.okelections.gov/OKERS/enrapi/GetExtract/CLCSV/20201103"],"exampleUrls":["https://results.okelections.gov/OKERS/enrapi/GetExtract/PLCSV/20241105","https://oklahoma.gov/content/dam/ok/en/elections/voter-registration-statistics/2024-vr-statistics/vrstats-district-nov1-2024.pdf"],"availableFields":["official county presidential totals","official precinct presidential rows","official precinct U.S. House comparison rows where both major-party House candidates are present","official EAC fallback turnout rows","county geometry","county equipment context from Verified Voting","official post-election audit archive source path","official Nov. 1, 2024 county registered-voter denominator lead parsed from congressional-district county fragments and reconciled to EAC registered voters","official 2020 county presidential historical baseline rows","official 2016 and 2020 county presidential candidate exports normalized to 77 canonical county tags per year"],"missingFields":["state-native ballots-cast or voter-history rows to pair with the collected Nov. 1 registered-voter denominator lead","precinct boundary geometry or precinct-to-county crosswalk","normalized post-election audit selection/outcome rows","normalized CVR availability, recount, incident, correction, and litigation records","state-native turnout denominator rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"nativeOklahomaOfficialCsvZip loads official 2024 race/county/precinct exports; scripts/collect-ok-vrstats-registration.mjs preserves the Nov. 1 registration denominator lead; scripts/normalize-ok-historical-presidential-baseline.py safely loads exact-root official 2016/2020 CountyResults ZIP members into 154 canonical county rows.","manualReviewBurden":"low","confidence":"loaded_with_caveat","caveats":"Oklahoma has official export endpoints for current and historical county results. Review rows use U.S. House by district and retain vote-share-only rows when a precinct lacks both major-party House candidates. Historical rows retain every official candidate: three tickets in 2016 and six in 2020, with all non-Democratic/non-Republican votes classified as Other. Turnout remains EAC fallback; official 2012 history, precinct geometry, and normalized audit/CVR/recount/incident/correction/litigation rows remain gaps.","nextAction":"Collect Oklahoma-native ballots-cast or voter-history rows, official precinct geometry/crosswalks, an official 2012 county baseline, and row-level audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"PA","stateName":"Pennsylvania","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["TXT","XLSX"],"sourceUrls":["https://www.pa.gov/agencies/vote/elections/election-results.html","https://www.pa.gov/agencies/dos/resources/voting-and-elections-resources/voting-and-election-statistics/election-data"],"exampleUrls":[],"availableFields":["precinct President rows","precinct U.S. Senate rows","county turnout","official 2012/2016/2020 county historical baselines from precinct bulk rows"],"missingFields":["precinct boundary geometry","precinct turnout denominator"],"parserStatus":"native precinct review package loaded; official historical bulk baseline loaded","manualReviewBurden":"low","confidence":"loaded","caveats":"Turnout is county-level, not precinct-level. Historical baselines are official DOS bulk context and may differ from secondary certified-summary tables where write-in reconciliation is separate.","nextAction":"Optional next steps are precinct geometry and precinct turnout denominator."},{"state":"RI","stateName":"Rhode Island","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"county_aggregated_city_town_federal_and_reporting_unit_review","exportFormats":["official long-format ZIP","official short-format ZIP","statewide JSON","normalized CSV","EAC fallback turnout CSV","promotion reconciliation JSON"],"sourceUrls":["https://www.ri.gov/election/results/","https://www.ri.gov/election/results/2012/general_election/data/rigen2012l.zip","https://www.ri.gov/election/results/2016/general_election/data/rigen2016l.zip","https://www.ri.gov/election/results/2020/general_election/data/rigen2020l.zip","https://www.ri.gov/election/results/2024/general_election/data/rigen2024l.zip","https://rigov.s3.amazonaws.com/election/results/2024/general_election/statewide.json","https://www.eac.gov/research-and-data/studies-and-reports"],"exampleUrls":["https://www.ri.gov/election/results/2024/general_election/data/rigen2024l.zip","https://rigov.s3.amazonaws.com/election/results/2024/general_election/statewide.json"],"availableFields":["official finalized-root 2024 city/town presidential rows aggregated to five county result-map rows plus unforced Federal Precincts","official same-key President-versus-U.S.-Senate review rows from the finalized BOE long-format root member","EAC fallback turnout rows","official finalized-root 2012, 2016, and 2020 city/town presidential rows aggregated to five canonical county tags per year plus unforced Federal Precincts","county geometry and supplemental equipment context","fail-closed live-versus-staging historical promotion reconciliation with per-year, per-county, tag, vote-total, and display-path differences"],"missingFields":["state-native turnout and registration denominator rows","result-ready city/town or precinct geometry/crosswalk for finer overlays","normalized official audit, recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"scripts/normalize-ri-boe-results.mjs reads explicit finalized root members from the official 2012, 2016, 2020, and 2024 BOE long-format ZIPs, rejects sanitized non-root entries, requires exact President and Senate statewide bucket reconciliation, emits six 2024 result rows, 444 review rows, and 18 county-plus-Federal historical rows; nativeRhodeIslandBoeCsv loads the normalized artifacts. scripts/audit-ri-historical-promotion.mjs then fails closed unless the live API and staging preserve all years and every official vote bucket while resolving to five canonical county tags plus unforced Federal Precincts.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The explicit finalized 2024 long-format root member reconciles exactly to posted statewide President and U.S. Senate bucket totals; no synthetic reconciliation row is emitted. Review rows exclude zero-vote Limited rows and presidential-only rows. Federal Precincts remain non-geographic and unforced. Turnout remains EAC fallback. The read-only promotion audit accepted reducing 86 live rows to 18 staged rows (a 68-row reduction) by aggregating 2012/2016 municipal rows to counties: all 2012/2016/2020 statewide and canonical county/Federal vote buckets have zero delta, 2020 display rows are unchanged, and production promotion remains a separate coordinator action.","nextAction":"Collect state-native turnout denominators and finer city/town or precinct geometry/crosswalks, and normalize audit/CVR/recount/incident/correction/litigation records. Preserve the accepted historical-promotion reconciliation as the pre-promotion guard."},{"state":"SC","stateName":"South Carolina","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["official CSV download","Election History table export","official 2020 historical President CSV download","normalized historical baseline CSV","historical contest CSV"],"sourceUrls":["https://electionhistory.scvotes.gov/","https://sc.elstats.civera.com/api/download_contest/7131_table.csv?split_party=false","https://sc.elstats.civera.com/api/download_contest/1974_table.csv?split_party=false","https://sc.elstats.civera.com/api/download_contest/5292_table.csv?split_party=false"],"exampleUrls":["https://electionhistory.scvotes.gov/contest/7131","https://sc.elstats.civera.com/api/download_contest/7131_table.csv?split_party=false","https://electionhistory.scvotes.gov/contest/1974","https://sc.elstats.civera.com/api/download_contest/1974_table.csv?split_party=false"],"availableFields":["official presidential county and precinct CSV rows","official U.S. House county and precinct CSV comparison rows","official VREMS county voter-history turnout and printed-list registration rows","official VREMS precinct/polling-place locator export","EAC turnout fallback retained as a benchmark","official 2020 county presidential historical baseline rows from the SC Elections Database contest CSV","official 2016 county presidential historical baseline rows","official 2020 county presidential historical baseline rows"],"missingFields":["map-ready precinct boundary geometry","statewide same-office comparison contest","active-registered-voter denominator artifact at the same grain as precinct results","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"native parser loaded from official Election History President and U.S. House CSV downloads; historical 2016 and 2020 county baselines normalized from official Election History contest CSVs; county turnout now uses normalized SC VREMS voter-history rows","manualReviewBurden":"low","confidence":"loaded","caveats":"U.S. House is district-based rather than a single statewide comparison race; duplicate county/precinct keys from district splits are aggregated before advisory directional screening. SC VREMS turnout denominators are printed registration-list counts that include active voters plus some inactive voters for the selected election, so turnout rows are warning-required.","nextAction":"Collect or normalize official 2012 county historical baseline, precinct boundary geometry, and normalized audit/CVR/incident/recount/litigation rows."},{"state":"VA","stateName":"Virginia","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["CSV"],"sourceUrls":["https://www.elections.virginia.gov/resultsreports/election-results/"],"exampleUrls":[],"availableFields":["official presidential locality rows","official precinct President rows","official precinct U.S. Senate comparison rows","official precinct turnout and registration rows","official ENR change-log summary","county-equivalent geometry"],"missingFields":["precinct boundary geometry","normalized audit, recount, CVR availability, incident, litigation, and correction records beyond ENR change-log summary and equipment context"],"parserStatus":"native Virginia ElectionStats and ENR package loaded for certified locality results, precinct President-versus-U.S. Senate review rows, and precinct turnout/registration rows","manualReviewBurden":"low","confidence":"loaded","caveats":"Review rows use the official VA ENR all-results CSV and ENR canonical precinct names, which can differ from the historical contest CSV display names. The ENR turnout file reports TotalVoteTurnout across the ballot, not presidential contest votes. Precinct boundary geometry and deeper audit/CVR/incident records remain uncollected.","nextAction":"Collect precinct boundary geometry and official audit/CVR/recount/litigation records or document source-side blockers."},{"state":"WA","stateName":"Washington","jurisdictionName":"Statewide participating county package","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["CSV","official historical all-counties CSV","normalized historical baseline CSV"],"sourceUrls":["https://www.sos.wa.gov/elections/data-research/election-data-and-maps","https://results.vote.wa.gov/results/20201103/export.html","https://results.vote.wa.gov/results/20201103/export/20201103_AllCounties.csv","https://results.vote.wa.gov/results/20161108/export/20161108_AllCounties.csv"],"exampleUrls":["https://results.vote.wa.gov/results/20241105/export/20241105_AllCounties.csv","https://results.vote.wa.gov/results/20201103/export/20201103_AllCounties.csv"],"availableFields":["county presidential totals","participating precinct review rows","county turnout fallback","official 2016 and 2020 county presidential historical baseline rows"],"missingFields":["complete statewide precinct export","precinct boundary geometry","state-native turnout denominator","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"native participating precinct review package loaded; scripts/normalize-wa-historical-presidential-baseline.mjs downloads official 2016 and 2020 all-counties CSV exports and writes 78 historicalPresidentialCsv county baseline rows","manualReviewBurden":"medium","confidence":"partial_with_2016_2020_historical_loaded","caveats":"Participating precinct export is 5,309 presidential votes below certified county totals. Official 2016 and 2020 county presidential historical baselines are loaded from all-counties CSV exports; 2012 remains missing.","nextAction":"Identify whether a complete statewide precinct package exists or keep participating-export caveat; collect state-native turnout denominator, precinct geometry, 2012 historical baseline, and administration-context artifacts."},{"state":"WI","stateName":"Wisconsin","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_audit","tier":"tier_1_official_export_database","reportingGrain":"ward","exportFormats":["XLSX"],"sourceUrls":["https://elections.wi.gov/elections/election-results"],"exampleUrls":[],"availableFields":["ward President rows","ward U.S. Senate rows","EAC fallback turnout","EAC vote-method rows","Verified Voting equipment context","2012/2016/2020 county historical presidential baselines","WEC post-election audit selected reporting units","WEC post-election audit statewide findings"],"missingFields":["ward-level registration denominator","per-reporting-unit audit discrepancy outcomes","county CVR availability verification","normalized incident/correction/recount/litigation rows"],"parserStatus":"native ward review package loaded with historical baseline and partial audit context","manualReviewBurden":"low","confidence":"loaded","caveats":"Turnout rows use EAC local-jurisdiction fallback because WEC ward workbook lacks denominator fields. Historical rows are contextual county baselines from secondary tables with source footnotes. WEC audit context includes selected reporting units and statewide findings, but the published report does not include per-reporting-unit discrepancy outcomes.","nextAction":"Find ward-level registered-voter denominator if available; request local audit submission materials if per-reporting-unit outcomes are needed; then complete CVR availability and incident/correction source inventories."},{"state":"WY","stateName":"Wyoming","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_equipment_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["official SOS XLSX ZIP","EAC fallback turnout CSV","Census county GeoJSON","supplemental equipment context"],"sourceUrls":["https://sos.wyo.gov/Elections/Docs/2024/2024GeneralResults.aspx","https://sos.wyo.gov/Elections/Docs/2024/Results/General/2024_Wyoming_General_Results.zip","https://sos.wyo.gov/Elections/ElectionResults.aspx","https://www.eac.gov/research-and-data/studies-and-reports","https://www2.census.gov/geo/tiger/TIGER2024/COUNTY/tl_2024_us_county.zip"],"exampleUrls":["https://sos.wyo.gov/Elections/Docs/2024/2024GeneralResults.aspx"],"availableFields":["certified county presidential totals","precinct-by-precinct President rows","same-row U.S. Senate comparison contest","EAC fallback turnout and registered-voter denominator rows","county geometry","official 2012/2016/2020 county historical baselines","supplemental equipment context"],"missingFields":["state-native registered-voter denominator","precinct boundary geometry or crosswalks","normalized audit/CVR/recount/incident/correction/litigation records"],"parserStatus":"nativeWyomingSosGeneralZip parses official 2024 SOS ZIP plus official 2012/2016/2020 historical ZIPs; turnout remains EAC fallback.","manualReviewBurden":"low_for_results_medium_for_remaining_context","confidence":"loaded_with_caveat","caveats":"Official result and review rows are loaded. EAC fallback turnout denominator remains active; precinct geometry and post-election context records remain request-tracked.","nextAction":"Collect state-native registered-voter denominator, precinct geometry/crosswalks, and official audit/CVR/recount/incident/correction/litigation context where available."},{"state":"AR","stateName":"Arkansas","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"reporting_unit","exportFormats":["TotalResults JSON API","EAC fallback turnout CSV","Census TIGERweb GeoJSON"],"sourceUrls":["https://enr.totalresults.com/arkansas/","https://www.sos.arkansas.gov/elections/results","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2705%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson"],"exampleUrls":["https://enr.totalresults.com/arkansas/"],"availableFields":["official county presidential totals","official county-scoped reporting-unit President rows","official county-scoped reporting-unit U.S. House comparison rows","EAC fallback turnout rows","county geometry","county equipment context from Verified Voting Verifier"],"missingFields":["human-readable precinct names for TotalResults reporting-unit IDs","state-native county or precinct turnout denominator rows","precinct boundary geometry or reporting-unit crosswalks","official 2012/2016/2020 historical baseline artifacts normalized into ETL","normalized official audit, recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"arkansasTotalResultsFederalJson loaded for official county President rows and county-scoped reporting-unit President-versus-U.S.-House review rows; EAC fallback turnout and Census county geometry are loaded; admin registry has equipment context only","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The TotalResults county-scoped federal buckets expose stable reporting-unit IDs but not human-readable precinct names. U.S. House is district-based and candidate-specific, so advisory screens are directional source-review context, not candidate-benefit findings. Turnout remains EAC fallback, and no normalized Arkansas audit/recount/CVR/incident/correction rows or official historical baselines are loaded.","nextAction":"Use data/ar-2024-data-coverage-inventory.json as the current AR source-search record; next steps are state-native turnout denominators, official precinct/reporting-unit crosswalk or geometry, normalized official historical baselines, and audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"CO","stateName":"Colorado","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county","exportFormats":["official Clarity detail XML ZIP endpoint","official SOS Abstract of Votes Cast source path","official Historical Election Data voter-statistics CSV","official 2020 Historical Election Data President contest CSV","EAC benchmark turnout CSV","Census county GeoJSON","Verified Voting equipment context","official 2016 and 2020 Historical Election Data President contest CSVs"],"sourceUrls":["https://results.enr.clarityelections.com/CO/122598/web.345435/#/summary","https://results.enr.clarityelections.com/CO/122598/current_ver.txt","https://results.enr.clarityelections.com/CO/122598/367167/reports/detailxml.zip","https://historicalelectiondata.coloradosos.gov/search?","https://historicalelectiondata.coloradosos.gov/contest/3640","https://www.sos.state.co.us/pubs/elections/Results/Abstract/","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2708%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/8","https://www.sos.state.co.us/pubs/elections/Resources/countyElectionOffices.html","https://www.sos.state.co.us/pubs/info_center/recordsRequests.html","https://historicalelectiondata.coloradosos.gov/contest/4436"],"exampleUrls":["https://results.enr.clarityelections.com/CO/122598/367167/reports/detailxml.zip"],"availableFields":["official county presidential candidate rows from the committed Clarity detail XML endpoint","loaded county CU Regent at-large comparison rows from the same endpoint","official state-native county turnout and active-plus-inactive registered-voter denominator rows from Historical Election Data voter statistics","official 2020 county presidential historical baseline rows from Historical Election Data contest export","EAC fallback turnout rows retained as benchmark context","Clarity ElectionVoterTurnout rows retained as reconciliation context","county geometry","county equipment context","official 2016 and 2020 county presidential historical baseline rows from Historical Election Data contest exports"],"missingFields":["write-in-inclusive county allocation for the 1,872-vote Clarity-versus-Abstract presidential gap","precinct or local reporting-unit President rows","same-grain precinct or local comparison contest rows","precinct boundary geometry or reporting-unit crosswalk","normalized official audit, recount, CVR availability, incident, correction, litigation, custody, ballot-manifest, tabulator-log, and EMS-log rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"coloradoClarityDetailXml loaded for 64 county President rows and 64 county President-versus-CU-Regent review rows; scripts/normalize-co-historical-voter-statistics.mjs collects the Historical Election Data voter-statistics CSV and writes the active normalizedTurnoutCsv county turnout rows; scripts/normalize-co-historical-presidential-baseline.mjs collects the official 2016 and 2020 President contest list CSVs and writes 128 historicalPresidentialCsv county baseline rows","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The official Clarity statewide detail XML exposes county candidate totals and precinct participation counts, but no per-precinct candidate result rows were observed. Loaded presidential candidate rows sum to 3,190,873, which is 1,872 below the prior Abstract/certified-total lead of 3,192,745; do not allocate that gap by county without an official source. Colorado had no 2024 U.S. Senate race; the same-grain comparison is county-level CU Regent at-large. Active turnout now uses official Historical Election Data 2024 General Voting Statistics county rows: Total Voters equals Active Voters plus Inactive Voters and matches the former EAC denominator, while Total Ballots Cast is 401 above EAC and 35 above Clarity ElectionVoterTurnout. Official 2020 county presidential baselines are loaded from the same Historical Election Data platform; 2012 and 2016 baselines remain missing.","nextAction":"Collect an official write-in-inclusive Abstract artifact or source note for the 1,872-vote presidential gap, then pursue precinct/local result rows, precinct geometry/crosswalks, official 2012 historical baseline, and normalized audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"CT","stateName":"Connecticut","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"certified_sov_current_planning_region_results_with_town_review_turnout","exportFormats":["official EMS static JSON","official Statement of Vote PDF","official EMS town turnout JSON","Census TIGERweb county-subdivision GeoJSON","EAC fallback turnout CSV benchmark","official Election History CSV source-review artifact","official historical EMS static JSON","Census TIGERweb planning-region GeoJSON","normalized current-planning-region crosswalk and historical CSV","normalized certified SOV town President CSV","SOV-versus-EMS reconciliation JSON"],"sourceUrls":["https://ctemspublic.tgstg.net/","https://ctemspublic.tgstg.net/ng-app/data/Elections.json","https://portal.ct.gov/sots/election-services/election-results/election-results","https://portal.ct.gov/sots/election-services/statement-of-vote-pdfs/general-elections-statement-of-vote-1922?archived=true","https://electionhistory.ct.gov/","https://portal.ct.gov/sots/election-services/statistics-and-data/statistics-and-data","https://voter.engr.uconn.edu/audits-2/","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/tigerWMS_Current/MapServer","https://ctemspublic.tgstg.net/ng-app/data/election/1/5603/townVotes_Electiondata.json","https://ctemspublic.tgstg.net/ng-app/data/election/54/64824/townVotes_Electiondata.json"],"exampleUrls":["https://ctemspublic.tgstg.net/ng-app/data/election/91/Version.json","https://ctemspublic.tgstg.net/ng-app/data/election/91/80741/townVotes_Electiondata.json","https://ctemspublic.tgstg.net/ng-app/data/election/91/80741/voterTurnout_Electiondata.json","https://portal.ct.gov/-/media/sots/electionservices/statementofvote_pdfs/2024_statement_of_vote.pdf?hash=27BE5012F5EF0B6BBF37B2A9242B54A2&rev=21871844f0be463886b823b12e6a442e","https://electionhistory.ct.gov/search?"],"availableFields":["official town President rows in EMS static JSON loaded into staging","official town U.S. Senate rows in the same EMS static JSON loaded into staging with cross-endorsed Murphy lines fused","official EMS town turnout rows loaded into staging as warning-required state-native turnout context","official Statement of Vote PDF collected as reconciliation source","official Election History event 582 President town/vote-channel source review confirming EMS President totals","official polling-place labels and reporting-completeness fields for 759 polling places","official Statement of Vote and Election History leads for 2012, 2016, and 2020 historical baselines","county geometry, town/MCD geometry lead, and Verified Voting equipment context","UConn VoTeR 2024 post-election audit report lead linked from Connecticut SOTS","nine current Census planning-region President rows aggregated from 169 official 2024 EMS town rows","169 official town U.S. Senate review rows with cross-endorsed Murphy lines fused","169 official EMS town turnout rows loaded as warning-required state-native turnout context","official 2016 and 2020 EMS town President rows aggregated reproducibly to nine current planning-region county-equivalent tags per year","exact 169-town EMS-name to Census BASENAME crosswalk using current Census COUNTY/GEOID assignments","current planning-region geometry, town/MCD geometry, and Verified Voting equipment context","certified Statement of Vote PDF reconciled to 169 town rows, 12 presidential tickets, and nine current planning-region aggregates"],"missingFields":["Election History event 582 voter-statistic rows or registered-voter denominator that could replace EMS turnout warnings","confirmed precinct/ward candidate vote rows or CVR availability","EMS town/MCD geometry crosswalk QA and precinct/ward geometry if sub-town rows are collected","normalized audit, CVR, recount, incident, correction, and litigation rows","precinct/ward geometry if sub-town rows are collected","official 2012 historical baseline normalized into ETL"],"parserStatus":"scripts/normalize-ct-2024-statement-of-vote.mjs hash-pins and extracts all certified SOV town President tickets; connecticutEmsTownJson uses those 169 rows for nine current planning-region results/review presidential fields while EMS supplies 169 town U.S. Senate comparison and turnout rows. scripts/normalize-ct-historical-presidential-baseline.mjs produces 18 tagged 2016/2020 historical rows.","manualReviewBurden":"medium","confidence":"loaded_certified_sov_reconciled","caveats":"Connecticut reporting is town-centric, while the active county-equivalent comparison geography is nine current Census planning regions. The certified SOV has 265 more President votes than EMS version 80741; active President rows use SOV, while EMS supplies Senate comparison and warning-required turnout. The 2016/2020 region rows are current-geography aggregates, not historical reporting units.","nextAction":"Collect an official 2012 baseline, review EMS report-download paths for precinct/ward rows or CVR availability, resolve EV/VV turnout semantics, and normalize audit/CVR/recount/incident/correction/litigation records if published or request-produced."},{"state":"GA","stateName":"Georgia","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct_2024_county_historical_review","exportFormats":["official media export JSON","normalized CSV"],"sourceUrls":["https://results.sos.ga.gov/","https://results.sos.ga.gov/results/public/Georgia","https://sos.ga.gov/page/historical-elections-results","https://results.sos.ga.gov/cdn/results/Georgia/export-2016NovGen.json","https://results.sos.ga.gov/cdn/results/Georgia/export-2020NovGen.json"],"exampleUrls":[],"availableFields":["precinct presidential rows","precinct U.S. House comparison rows from the same official media export","county turnout from EAC fallback","official 2012/2016/2020 county historical presidential baselines from Georgia SOS media exports","county equipment context from Verified Voting Verifier","official President vote-method candidate groupResults from SOS media export","documented turnout/registration exclusion review at data/ga-2024-turnout-vote-method-source-review.json","official 2016 and 2020 county President-versus-U.S.-Senate historical advisory rows: 159 canonical county rows per year in data/ga-historical-review-rows.csv"],"missingFields":["state-native turnout denominator","precinct boundary geometry","normalized official audit/recount/CVR/incident/correction records"],"parserStatus":"native precinct President-versus-U.S.-House review package loaded from official media export; official county historical baseline CSV generated from 2012/2016/2020 SOS media exports; scripts/normalize-ga-historical-review.mjs generates 318 historicalReviewCsv county President-versus-U.S.-Senate rows for 2016 and 2020 with exact statewide reconciliation; scripts/report-ga-turnout-vote-method-source-review.mjs documents that SOS vote-method groupResults are candidate-result splits and not a turnout replacement","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"U.S. House is district-based and candidate-specific, so Georgia directional screens are low-confidence advisory context rather than candidate-benefit findings. Of 2,684 nonzero presidential precinct review rows, 2,637 have comparable two-party U.S. House rows, 8 have one-sided House comparison coverage, and 39 precinct keys aggregate more than one House district and are excluded from down-ballot dropoff calculations. County presidential candidate rows sum 19 votes higher than the statewide presidential contest total in minor-party/other rows, and 17 zero-total precinct entries are omitted from review charts. Turnout remains EAC fallback and precinct geometry/admin evidence are not loaded. Historical rows are official county-level SOS media-export baselines for context only; the 2020 media export reports the original November general-election export total and should not be mixed with separate recount tables without reconciliation. The historical advisory package contains 159 canonical county rows for each of 2016 and 2020. The 2016 rows reconcile to 4,092,373 presidential votes and 3,897,792 Senate votes; the 2020 rows reconcile to 4,998,482 presidential votes and 4,952,175 regular Senate votes. The 2020 comparison is the regular US Senate (Perdue) contest from the original November general election before the runoff; the Loeffler special election is excluded. The selected historical county contest options expose no precinct-result rows, and advisory signals can reflect candidate, contest, split-ticket, and participation differences rather than misconduct. The July 5, 2026 vote-method source review found official President groupResults by Election Day, Absentee by Mail, Provisional, and Advanced Voting, but no registered-voter denominator or election-level ballots-cast field; EAC turnout remains active.","nextAction":"Use data/ga-2024-data-coverage-inventory.json as the current GA source-search record; next steps are state-native turnout denominators, precinct boundary geometry/crosswalks, and official audit/recount/CVR/incident/correction artifacts."},{"state":"IA","stateName":"Iowa","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct","exportFormats":["JSON","detail XML ZIP","Excel/statistical report links","county precinct shapefile ZIP leads"],"sourceUrls":["https://electionresults.iowa.gov/IA/","https://sos.iowa.gov/iowans/election-results-statistics","https://sos.iowa.gov/shapefiles-county-precincts"],"exampleUrls":["https://electionresults.iowa.gov/IA/122322/web.345435/","https://sos.iowa.gov/sites/default/files/2025-02/2024PrecinctAudits.png"],"availableFields":["county results","precinct President rows","precinct U.S. House comparison rows","precinct turnout/registration fields","President and U.S. House candidate vote type splits in official detail XML","official county precinct shapefile source leads","official 2024 county precinct-audit source lead","official historical result/statistical-report replacement leads"],"missingFields":["normalized ballot-method package for the public vote-method API/UI","collected and crosswalked precinct boundary geometry","normalized post-election audit selection/outcome rows","normalized recount, CVR availability, incident, correction, and litigation artifacts","official historical baseline parser replacing secondary contextual rows"],"parserStatus":"iowaClarityCountyDetailXmlDirectory loaded for results, review, and precinct turnout; detail XML VoteType fields are confirmed but not normalized into vote-method rows; official SOS shapefile, precinct-audit, and historical replacement leads are inventoried but not normalized","manualReviewBurden":"low","confidence":"loaded","caveats":"U.S. House is district-based, so review rows remain advisory. The official detail XML includes candidate VoteType splits such as Election Day and Absentee, but the public vote-method contract does not yet load Iowa Clarity method rows. County geometry is loaded; official precinct shapefile ZIP leads require collection, normalization, and Clarity precinct-name crosswalk work. The 2024 precinct-audit image is identified but not normalized. Historical baseline rows remain secondary context until official SOS historical county artifacts are parsed.","nextAction":"Use data/ia-2024-data-coverage-inventory.json as the current IA source-search record; next steps are an Iowa Clarity vote-method normalizer, official SOS precinct shapefile collection/crosswalk work, browser/manual collection or request-produced 2024 audit records, and request/normalization paths for recount, CVR availability, incident, correction, litigation, and official historical baseline replacement artifacts."},{"state":"ID","stateName":"Idaho","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county","exportFormats":["official Vote Idaho XML endpoints","official Vote Idaho map HTML widgets","official county turnout XLSX","official raw precinct turnout XLSX","retained EAC benchmark turnout CSV","Census county GeoJSON","Verified Voting equipment CSV","official 2012/2016 archive HTML","official 2020 county statistics HTML","historical baseline CSV"],"sourceUrls":["https://sos.idaho.gov/elections-division/election-results/","https://archive.voteidaho.gov/results/2024/general/xml.html","https://archive.voteidaho.gov/results/2024/general/presidential.html","https://archive.voteidaho.gov/results/2024/general/congressional.html","https://archive.voteidaho.gov/results/2024/general/turnout.html","https://canvass.sos.idaho.gov/","https://sos.idaho.gov/elections/data/results/2024/raw_stats_general.xlsx","https://sos.idaho.gov/elections/data/results/2024/turnout_county_general.xlsx","https://voteidaho.gov/data-and-dashboards/voter-turnout/","https://www.eac.gov/research-and-data/studies-and-reports","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/16","https://sos.idaho.gov/elections-division/2020-results-statistics/","https://archive.sos.idaho.gov/ELECT/results/2016/General/president_by_county.html","https://archive.sos.idaho.gov/ELECT/results/2012/General/cnty_USPres.htm"],"exampleUrls":["https://archive.voteidaho.gov/results/2024/general/xml.html","https://sos.idaho.gov/elections/data/results/2024/turnout_county_general.xlsx"],"availableFields":["official county presidential totals","official county U.S. House comparison rows","official state-native county turnout and total registered-voter denominator rows","official raw precinct turnout source lead","county geometry","county equipment context","official 2012, 2016, and 2020 historical source leads","official 2012/2016/2020 county historical presidential baselines"],"missingFields":["precinct/local reporting-unit President rows","same-grain precinct/local comparison contest rows","loaded precinct turnout rows joined to same-grain review rows","precinct boundary geometry or reporting-unit crosswalk","normalized official audit, CVR, incident, correction, recount, and litigation records"],"parserStatus":"nativeIdahoCountyPresidentCsv loaded from data/id-2024-general-president.csv and data/id-2024-general-us-house.csv; official state-native county turnout rows load from data/id-2024-general-turnout.csv generated by scripts/normalize-id-turnout.mjs; official 2012/2016/2020 county historical rows load from data/id-historical-presidential-baseline.csv generated by scripts/collect-id-historical-baseline.py; data/id-2024-data-coverage-inventory.json documents remaining official-source leads and gaps","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Current Idaho review rows are county-level President-versus-U.S.-House comparisons, not precinct scatter plots. U.S. House is district-based. Turnout now uses official Idaho SOS county turnout rows, while the official raw precinct turnout workbook remains a source lead until precinct/local President and comparison rows are loaded at the same grain. Historical baselines are official county-level context rows for 2012, 2016, and 2020. No normalized audit, CVR, incident, correction, recount, litigation, or precinct-geometry rows are loaded.","nextAction":"Use data/id-2024-data-coverage-inventory.json as the current ID source-search record; next steps are precinct/local result exports, same-grain precinct turnout use, precinct geometry/crosswalks, and official audit/CVR/incident/correction/recount/litigation source collection."},{"state":"IN","stateName":"Indiana","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county_plus_supplemental_precinct","exportFormats":["archived ENR JSON","official ENR public data shape inventory","official turnout PDF normalized CSV","supplemental MIT/OpenElections CSV","EAC fallback turnout CSV retained as benchmark","Verified Voting equipment CSV","official request matrix TSV","official records-request packet","official ENRHistorical AJAX table JSON","official county request-routing CSV"],"sourceUrls":["https://enr.indianavoters.in.gov/","https://www.in.gov/sos/elections/voter-information/files/2024-General-Election-Turnout-and-Registration-Report.pdf","https://www.in.gov/sos/elections/voter-information/register-to-vote/voter-registration-and-turnout-statistics/","https://www.in.gov/sos/elections/election-commission/election-results/","https://www.eac.gov/research-and-data/studies-and-reports","https://doi.org/10.7910/DVN/NYTPDU","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/18","https://www.in.gov/sos/elections/vstop/vstop-post-election-risk-limiting-audit-reports","https://www.in.gov/sos/elections/indiana-recount-commission/","https://indianavoters.in.gov/ENRHistorical/ElectionResults?year=2012","https://www.in.gov/sos/elections/files/StatewideCountsofPrecincts-and-PrecinctSplits.9.21.23new.pdf"],"exampleUrls":["https://web.archive.org/web/20241229230948id_/https://enr.indianavoters.in.gov/site/data/OffCatC_1019_A.json","https://www.in.gov/sos/elections/voter-information/files/2024-General-Election-Turnout-and-Registration-Report.pdf"],"availableFields":["official county President rows","official county U.S. Senate rows","official county registered-voter and voters-voting turnout rows","supplemental precinct President-versus-U.S.-Senate review rows","EAC county turnout fallback retained as benchmark","county election equipment context","official 2012, 2016, and 2020 county historical presidential baselines","official VSTOP post-election risk-limiting audit source path documented","official Recount Commission petition/order/minute source path documented","Indiana official-source request matrix maintained at data/in-2024-source-request-matrix.tsv","Indiana records-request packet maintained at data/source-records-request-packets/in-2024-precinct-results-request.md","official VSTOP 2024 General Election audit summary rows for seven counties","official ENR public app/data-path scan confirming no retained same-grain subcounty President/Senate export","machine-readable 92-county custodian routing tracker with official office/contact metadata and precinct/split counts"],"missingFields":["official precinct/precinct-split/subcounty President rows","official same-grain precinct/precinct-split/subcounty U.S. Senate comparison rows","precinct turnout and registered-voter denominator rows","precinct boundary geometry","detailed official VSTOP audit-unit selection/workpaper rows beyond the summary report","normalized official recount/contest/correction records","official CVR availability or request-produced CVR records","official incident and correction records"],"parserStatus":"indianaEnrCountyJson package loaded; official 2012/2016/2020 historicalPresidentialCsv loaded from ENRHistorical/AJAX and ENR archive sources; supplemental MIT/OpenElections precinct review rows loaded; scripts/normalize-in-audit-summary.mjs loads official VSTOP 2024 county audit-summary context rows; scripts/inspect-in-enr-public-data.mjs records the official ENR public data-path evidence that retained President/Senate files are county/locality-grain and JurR files have zero candidate containers; July 4, 2026 ordinary public-path checks returned HTTP 200 for settings, President, U.S. Senate, and turnout JSON but still identified no precinct/subcounty candidate export. scripts/build-in-request-routing.mjs emits data/in-2024-county-request-routing.csv and summary JSON for official county custodian follow-up; this tracker does not contain candidate result rows.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Archived ENR category files contain 92 county/locality RegionSummary rows for 2024, not precinct rows; data/in-2024-official-enr-public-data-inventory.json records that the public app download route exports turnout statistics only and no retained ENR JSON artifact exposes same-grain subcounty President/Senate candidate rows. The July 4, 2026 live public-path recheck confirmed the documented archive JSON paths are reachable but still county/result-statistics scoped. The current subcounty review rows are supplemental MIT/OpenElections context with upstream caveats, so Indiana should remain in source discovery until official same-grain precinct/subcounty President and U.S. Senate rows are obtained or the completion methodology changes. Historical baselines are official county context for 2012, 2016, and 2020; 2012 is collected from the current Indiana Voters ENRHistorical table endpoint, while 2016 and 2020 use ENR archive JSON.","nextAction":"Use data/in-2024-source-request-matrix.tsv, data/source-records-request-packets/in-2024-precinct-results-request.md, and data/in-2024-county-request-routing.csv to request official same-grain precinct/precinct-split 2024 President and U.S. Senate rows, precinct geometry/turnout if needed, detailed VSTOP audit workpapers, Recount Commission/CVR/incident records suitable for normalization."},{"state":"LA","stateName":"Louisiana","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct_vote_mode_and_parish","exportFormats":["Louisiana SOS static precinct CSV endpoints","Louisiana SOS human-readable XLSX workbook","Louisiana SOS post-election statistics XLS workbooks","normalized SOS parish turnout CSV","EAC benchmark turnout CSV","Census TIGERweb GeoJSON","official 2020 SOS precinct CSV historical baseline","normalized 2020 historical baseline CSV","EAC fallback turnout CSV","Louisiana SOS historical ByParish presidential CSV endpoints"],"sourceUrls":["https://voterportal.sos.la.gov/static/","https://voterportal.sos.la.gov/static/20241105/resultsRace/Presidential","https://s3-us-west-2.amazonaws.com/mediaresults.sos.la.gov/HumanReadableElectionResults/20241105/Election+Results+(11-05-2024).xlsx","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2722%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","https://voterportal.sos.la.gov/graphical","https://electionstatistics.sos.la.gov/data/Post_Election_Statistics/statewide/2024_1105_sta.xls","https://electionstatistics.sos.la.gov/data/Post_Election_Statistics/parish/2024_1105_par.xls","https://voterportal.sos.la.gov/static/20201103/resultsRace/Presidential","https://voterportal.sos.la.gov/static/20161108/resultsRace/Presidential"],"exampleUrls":["https://voterportal.sos.la.gov/static/20241105/resultsRace/Presidential"],"availableFields":["official parish presidential totals","official precinct and vote-mode President rows","official precinct and vote-mode U.S. House comparison rows where same-grain keys align","official SOS parish post-election qualified-voter and voted turnout rows","EAC benchmark turnout rows","official 2020 parish presidential historical baseline rows","parish geometry","parish equipment context from Verified Voting Verifier","data/la-2024-data-coverage-inventory.json coverage inventory","EAC fallback turnout rows","official 2016 and 2020 parish presidential historical baseline rows"],"missingFields":["precinct boundary geometry or precinct-to-parish crosswalks","normalized official audit, recount, CVR availability, incident, correction, and litigation rows","state-native turnout denominator rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"louisianaSosPrecinctCsvDirectory loads official parish President result rows and precinct/vote-mode President-versus-U.S.-House review rows; scripts/normalize-la-post-election-statistics.mjs generates active SOS parish turnout rows; scripts/normalize-la-historical-presidential-baseline.mjs loads official 2016 and 2020 parish historical presidential baselines; EAC is retained as a benchmark.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Louisiana uses parishes rather than counties. U.S. House is district-based and candidate-specific, so review rows are advisory source-review context, not same-office statewide comparison rows. EAC turnout remains a fallback until state-native denominator artifacts are collected. Official 2016 and 2020 parish presidential historical baselines are loaded; official 2012 remains missing.","nextAction":"Collect precinct boundary geometry/crosswalks, an official 2012 historical baseline artifact, and normalized audit/CVR/incident/correction/recount/litigation records."},{"state":"ND","stateName":"North Dakota","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county_results_precinct_review","exportFormats":["official ResultsAjax JSON endpoint","official ASP.NET results dashboard","CSV/Excel/XML export form","HTML precinct turnout table","official archived canvass PDFs"],"sourceUrls":["https://results.sos.nd.gov/ResultsSW.aspx?text=Race&type=SW&map=CTY","https://resultsws.sos.nd.gov/ResultsAjax.svc/GetMapData?type=SW&category=CTY&raceID=19893&osn=100&county=0&party=0","https://results.sos.nd.gov/VoterTurnoutDetails.aspx","https://www.sos.nd.gov/elections/voter/voting-north-dakota","https://www.sos.nd.gov/elections/election-security/post-election-audits"],"exampleUrls":["https://resultsws.sos.nd.gov/ResultsAjax.svc/GetMapData?type=SW&category=CTY&raceID=19893&osn=100&county=0&party=0","https://resultsws.sos.nd.gov/ResultsAjax.svc/GetMapData?type=SW&category=PREC&raceID=19893&osn=100&county=01&party=0"],"availableFields":["official county President totals from SOS ResultsAjax JSON","official same-key precinct President rows from SOS ResultsAjax JSON","official same-key precinct U.S. Senate comparison rows from SOS ResultsAjax JSON","official precinct ballots-cast turnout table lead","official eligible-voter turnout denominator summary lead","county geometry","official 2020, 2016, and 2012 historical archive leads","county equipment context from Verified Voting and official SOS equipment description","official post-election audit policy and recount page source paths"],"missingFields":["state-native eligible-voter denominator parser and reconciliation to EAC fallback","precinct boundary geometry or result-to-precinct crosswalk","normalized historical baseline rows","normalized audit, CVR availability, incident, correction, recount, and litigation rows"],"parserStatus":"scripts/collect-nd-sos-results.mjs collects official SOS ResultsAjax JSON rows and writes countyPresidentCsv plus localComparisonCsv artifacts; active ND ETL now loads 53 county result rows, 383 same-key precinct President-versus-U.S.-Senate review rows, EAC fallback turnout, and county geometry","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"North Dakota does not require voter registration, so registered-voter denominator fields are not native turnout denominators. Active turnout remains EAC fallback with 371,974 ballots cast and 0 registered voters until the official SOS eligible-voter turnout lead of 371,975 voter turnout and 594,140 eligible voters is normalized and reconciled. Review rows are advisory source-review context only; precinct geometry/crosswalks, historical baselines, and normalized audit/CVR/recount/incident/correction/litigation rows remain missing.","nextAction":"Reconcile and normalize SOS eligible-voter turnout, collect precinct geometry/crosswalks and official 2012/2016/2020 historical baselines, then collect audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"NM","stateName":"New Mexico","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county_precinct","exportFormats":["official SOS mapdata API JSON","official election results dashboard","turnout details table/export lead","GIS clearinghouse shapefiles lead","EAC fallback turnout CSV","official SOS Elections Database historical source portal","voter statistics archive OCR denominator lead"],"sourceUrls":["https://www.sos.nm.gov/sos-archive/election-results-archive/2024-election-results/","https://electionresults.sos.nm.gov/Default.aspx?eid=2882","https://electionresults.sos.nm.gov/ResultsMedia.aspx?eid=2882","https://electionresults.sos.nm.gov/VoterTurnoutDetails.aspx?eid=2882","https://www.sos.nm.gov/sos-archive/maps-archive/gis-voting-district-data-archive/","https://electionstats.sos.nm.gov/","https://www.sos.nm.gov/sos-archive/voter-statistics-data-archive/2024-voter-statistics-data/"],"exampleUrls":["https://electionresults.sos.nm.gov/resultsSW.aspx?eid=2882&map=CTY&type=FED","https://electionresults.sos.nm.gov/resultsSW.aspx?eid=2882&map=CTY&type=SW"],"availableFields":["official county President result rows loaded from SOS API","official precinct President rows loaded from SOS API for review","official precinct U.S. Senate same-grain comparison rows loaded from SOS API","EAC jurisdiction turnout fallback rows loaded","official 2020 and 2016 county historical presidential baselines loaded from SOS API","official SOS turnout details, GIS, audit, recount, voter-data, and IPRA request paths documented","official SOS Elections Database verified as historical/source-validation lead","official 2024 voter statistics archive identified as registration denominator OCR lead"],"missingFields":["state-native turnout rows reconciled with denominator timing","OCR-backed voter statistics denominator artifact reviewed and normalized","precinct boundary geometry or result-key crosswalk","official 2012 historical baseline rows","normalized audit, CVR availability, recount, incident, correction, litigation, custody, and tabulator-log rows"],"parserStatus":"etl/state-configs/nm.json now loads official NM SOS 2024 President county results, President-vs-U.S. Senate precinct review rows, EAC turnout fallback rows, and 2020/2016 official historical baselines through nativeNewMexicoSosMapDataJson.","manualReviewBurden":"medium","confidence":"loaded_with_caveats","caveats":"The official SOS API masks small counts with '*', so the parser infers masked values from SOS percentages. After inference and de-duplication, precinct President and U.S. Senate totals are each 7 votes below county-level official totals; advisory review rows are not evidence of fraud or misconduct. SOS turnout uses eligible voters while active EAC fallback uses registered voters. The 2024 SOS voter-statistics archive is an official denominator lead but is not active because a reviewed script-readable artifact was not identified and OCR/manual review may be required.","nextAction":"Review SOS turnout denominator semantics, collect/OCR a reviewed 2024 voter-statistics artifact if available, collect precinct geometry/crosswalk, normalize 2012 historical and admin-context artifacts, and QA website display after any explicit production promotion."},{"state":"NV","stateName":"Nevada","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct","exportFormats":["archived official statewide results","county totals","Clark County CVR zip","Washoe County CVR csv","Humboldt County CVR csv","normalized Clark/Washoe/Humboldt precinct review CSVs","county election pages","records-request path","county source request matrix TSV","non-Clark jurisdiction request packet JSON"],"sourceUrls":["https://www.nvsos.gov/SOSelectionPages/results/2024StateWideGeneral/ElectionSummary.aspx","https://www.clarkcountynv.gov/government/departments/elections/reports_data_maps/index.php","https://elections.clarkcountynv.gov/electionresultsTV/cvr/24G/24G_CVRExport_NOV_Final_Confidential.zip","https://www.washoecounty.gov/voters/results/archivedresults.php","https://www.washoecounty.gov/voters/results/resultsfiles/2024generalcvr.csv","https://www.humboldtcountynv.gov/317/Elections","https://www.humboldtcountynv.gov/DocumentCenter/View/7893","https://www.nvsos.gov/sos/elections/voters/county-clerk-contact-information"],"exampleUrls":[],"availableFields":["county President rows","county U.S. Senate rows","Clark County precinct President/Senate CVR review rows","Washoe County precinct President/Senate CVR review rows","Humboldt County precinct President/Senate CVR review rows","county equipment context","14-jurisdiction result/turnout/geometry/admin request matrix","14-jurisdiction operational request packets"],"missingFields":["local/precinct rows for 14 non-Clark/non-Washoe/non-Humboldt jurisdictions","state-native turnout denominator","precinct/local reporting-unit geometry or crosswalks","official 2012/2016/2020 historical baseline replacement for secondary context rows","post-election audit, L&A, tabulator-log, custody, incident/correction, recount, litigation, and remaining CVR availability artifacts"],"parserStatus":"localComparisonCsv loaded for Clark County, Washoe County, and Humboldt County CVR precinct rows; data/nv-2024-county-source-request-matrix.tsv tracks the remaining 14 jurisdiction request paths; scripts/create-nv-county-request-packets.mjs generates data/nv-2024-non-clark-county-request-packets.json for county-specific request follow-through; active turnout remains EAC fallback","manualReviewBurden":"medium","confidence":"loaded","caveats":"Clark County, Washoe County, and Humboldt County CVR precinct rows are loaded for local review; other Nevada jurisdictions remain county-only. Live NVSOS/Silver State hosts can block scripted access; archived artifacts are retained. The July 4, 2026 NV source pass rechecked Eureka and generated county-specific request packets for the remaining 14 jurisdictions plus state-native turnout, precinct geometry, historical-baseline replacement, and audit/CVR/L&A/tabulator-log/custody/incident evidence needs.","nextAction":"Use data/nv-2024-non-clark-county-request-packets.json and data/nv-2024-county-source-request-matrix.tsv to request official local result exports or records-request productions for the 14 non-Clark/non-Washoe/non-Humboldt jurisdictions, starting with Eureka County, then collect a state-native turnout denominator and administration evidence artifacts."},{"state":"UT","stateName":"Utah","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county","exportFormats":["official electionresults API JSON","official canvass PDF text layer","normalized CSV","official standardized canvass workbook","county GeoJSON"],"sourceUrls":["https://vote.utah.gov/election-results/","https://vote.utah.gov/2024-election-information/","https://vote.utah.gov/wp-content/uploads/2025/02/2024-General-Election-Statewide-Canvass-2.pdf","https://vote.utah.gov/wp-content/uploads/2025/12/Master-Aggregated-Numbers-2023-2025.xlsx","https://electionresults.utah.gov/results/public/api/elections/utah/general11052024/ballot-items/88e40000-968a-0c37-b0b0-08dce9374078"],"exampleUrls":["https://vote.utah.gov/wp-content/uploads/2025/02/2024-General-Election-Statewide-Canvass-2.pdf","https://vote.utah.gov/wp-content/uploads/2025/12/Master-Aggregated-Numbers-2023-2025.xlsx","https://electionresults.utah.gov/results/public/api/elections/utah/general11052024/ballot-items/88e40000-968a-0c37-b0b0-08dce9374078"],"availableFields":["official county presidential API rows including qualified write-ins","county Attorney General comparison rows","state-native county turnout and active-voter denominator","county geometry","secondary 2012/2016/2020 historical baseline rows"],"missingFields":["precinct/local reporting-unit rows","precinct boundary geometry or crosswalks","official normalized 2012/2016/2020 historical baselines","normalized audit/CVR/incident/correction/recount/litigation rows"],"parserStatus":"county President rows load from the official electionresults.utah.gov API; Attorney General comparison, turnout, and historical rows load through scripts/normalize-ut-official-results.mjs artifacts and the generic countyPresidentCsv dispatcher.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The official electionresults API resolves the 1,488,494-vote presidential contest total at county grain, including qualified write-ins. Review rows are county-level President-versus-Attorney-General comparisons, not precinct scatter plots. Official precinct/local rows, precinct geometry, official historical baselines, and normalized audit/CVR/incident/correction/recount/litigation rows remain unloaded.","nextAction":"Collect precinct/local reporting-unit rows, precinct geometry/crosswalks, official historical baselines, and normalized audit/CVR/incident/correction/litigation records."},{"state":"VT","stateName":"Vermont","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_turnout_geometry_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"town_or_reporting_district","exportFormats":["official SOS static JSON","official SOS canvass PDF","official SOS turnout PDF","official recount XLSX","EAC fallback turnout","official SOS 2020 archive CSV export","official Election Results Archive municipality CSV downloads"],"sourceUrls":["https://sos.vermont.gov/elections/election-info-resources/elections-results-data/","https://static.electionresults.vermont.gov/elections/elections.json","https://electionarchive.vermont.gov/","https://electionarchive.vermont.gov/elections/view/144513/","https://electionarchive.vermont.gov/elections/download/144513/precincts_include:0/","https://electionarchive.vermont.gov/elections/download/82048/precincts_include:0/"],"exampleUrls":["https://static.electionresults.vermont.gov/elections/67a35c79-05a2-4ae3-a77d-97812256188b.json","https://static.electionresults.vermont.gov/elections/67a35c79-05a2-4ae3-a77d-97812256188b-f-20260611153112.json","https://static.electionresults.vermont.gov/elections/67a35c79-05a2-4ae3-a77d-97812256188b-turnout-20260611153112.json","https://outside.vermont.gov/dept/sos/Elections_Division/election_info_resources/elections_results_data/2024_general_election_official_report_canvassing_committee_united_states_vermont_statewide_offices.pdf","https://outside.vermont.gov/dept/sos/Elections_Division/election_info_resources/elections_results_data/2024_general_election_voter_turnout.pdf"],"availableFields":["official county presidential rows aggregated from SOS static JSON and reconciled to certified canvass totals","official town/reporting-district President rows","official same-grain U.S. Senate comparison rows","official turnout JSON/PDF lead","certified canvass PDF retained as source-of-record reconciliation artifact","county geometry","equipment context","official 2016 and 2020 county presidential historical baseline rows aggregated from SOS municipality exports with county:<GEOID> tags"],"missingFields":["state-native turnout importer replacing EAC fallback","town/reporting-district geometry and crosswalk for subcounty maps","normalized audit, recount, CVR, incident, correction, and litigation rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"nativeVermontStaticElectionJson loads 14 county President rows and 283 town/reporting-district President-versus-U.S.-Senate review rows from official SOS static JSON after excluding the duplicated STATE WIDE summary row and reconciling to certified canvass totals; active turnout remains EAC fallback.; scripts/normalize-vt-historical-presidential-baseline.mjs loads official 2016/2020 archive CSV baselines.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"County result and town/reporting-district review rows are active and source-reconciled. U.S. Senate includes a major independent candidate, so dropoff fields are directional source-review inputs only. Active turnout remains EAC fallback because SOS JSON, SOS canvass cover-page, and EAC registered-voter totals differ. Official 2016 and 2020 county historical baselines are loaded; town/reporting-district geometry, official 2012 baselines, and normalized administration-context rows remain missing.","nextAction":"Resolve SOS turnout denominator timing before replacing EAC fallback; collect town/reporting-district geometry, the official 2012 county historical baseline, and normalized audit/CVR/recount/incident/correction/litigation context."},{"state":"WV","stateName":"West Virginia","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct","exportFormats":["detail XML ZIP"],"sourceUrls":["https://results.enr.clarityelections.com/WV/","https://sos.wv.gov/elections/Pages/ElectionSecurity.aspx","https://sos.wv.gov/elections/Pages/HistElecResults.aspx","https://sos.wv.gov/elections/Pages/Guidance.aspx","https://sos.wv.gov/about/Pages/FOIAReq.aspx","https://sos.wv.gov/west-virginia-county-clerk-directory"],"exampleUrls":[],"availableFields":["county results","precinct President rows","precinct U.S. Senate rows","precinct turnout rows","county equipment context","official SOS canvass/recount/complaint/FOIA/voter-data request paths documented in data/wv-2024-data-coverage-inventory.json","official historical results source leads for 2020 and 2008-2017"],"missingFields":["official statewide precinct boundary geometry","normalized 2024 post-election audit selection/outcome artifacts","normalized CVR availability rows","incident, correction, recount, and litigation records"],"parserStatus":"westVirginiaClarityCountyDetailXmlDirectory loaded for results/review/turnout; Verified Voting county equipment context loaded; data/wv-2024-data-coverage-inventory.json documents official geometry, audit, CVR, recount, incident/correction, litigation, and historical-source request paths","manualReviewBurden":"low","confidence":"loaded","caveats":"Rows are advisory review inputs, not confirmed findings. Equipment context is jurisdiction-level metadata only. County map geometry is loaded; no official statewide precinct boundary geometry package was identified in this pass. The Wave 9 inventory documents official request/source paths only; no audit outcome, CVR, incident, correction, recount, litigation, or historical baseline rows are loaded.","nextAction":"Request official statewide precinct boundary geometry or county precinct crosswalks, then request and normalize 2024 hand-count audit selections/outcomes, CVR availability responses, recount/correction/incident/litigation records, and official 2012/2016/2020 historical baseline artifacts."},{"state":"TX","stateName":"Texas","jurisdictionName":"Statewide open data project","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_3_sanctioned_bulk_partial","reportingGrain":"precinct","exportFormats":["compressed CSV ZIP","VTD returns CSV","VTD VRTO CSV"],"sourceUrls":["https://data.capitol.texas.gov/topic/elections"],"exampleUrls":["https://data.capitol.texas.gov/dataset/35b16aee-0bb0-4866-b1ec-859f1f044241/resource/e1cd6332-6a7a-4c78-ad2a-852268f6c7a2/download/2024-general-vtds-election-data.zip"],"availableFields":["certified county President rows from Texas SOS County.json","VTD President rows","VTD U.S. Senate comparison rows","VTD registered-voter and turnout rows","VTD reconciliation summary for certified county versus VTD presidential scope"],"missingFields":["ballot method fields","precinct/VTD boundary geometry","source-side explanation for generic VTD write-in rows versus named certified write-in candidates"],"parserStatus":"texasCountyJsonVtdReview loaded with VTD write-in reconciliation summary","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The VTD presidential rows aggregate to 11,404,528 votes, 15,854 above the SOS County.json certified-result package total of 11,388,674. The reconciliation artifact identifies the primary source as VTD generic Write-In rows: 24,730 VTD generic write-in votes versus 8,569 SOS named declared write-in votes. Use VTD rows as official local screening context, not as replacement certified totals.","nextAction":"Request source-side notes or county crosswalk documentation for VTD generic write-in handling, then add VTD boundary geometry."},{"state":"TX","stateName":"Texas","jurisdictionName":"Harris County","scope":"county","dataFamily":"local_results","tier":"tier_4_local_scattershot","reportingGrain":"precinct","exportFormats":["county website navigation","local result pages"],"sourceUrls":["https://www.harrisvotes.com/Election-Results"],"exampleUrls":["https://www.harrisvotes.com/Election-Results"],"availableFields":["local county election results"],"missingFields":["statewide coverage","registration denominator source","consistent navigation across counties"],"parserStatus":"example local source only; parser not implemented","manualReviewBurden":"high","confidence":"candidate","caveats":"Useful only as one local override; statewide Texas requires many jurisdictions or a better statewide source.","nextAction":"Use only if Texas statewide sources cannot provide required precinct rows."},{"state":"AK","stateName":"Alaska","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_equipment_admin_context","tier":"tier_5_digital_inconsistent","reportingGrain":"statewide_result_with_precinct_reporting_unit_review","exportFormats":["official summary PDF text layer","official ENR precinct CSV","normalized statewide CSV","normalized precinct/reporting-unit review CSV","EAC fallback turnout CSV","state House District GeoJSON","official results page evidence","ENR turnout field semantics JSON","official source request packet JSON","current Census county-equivalent GeoJSON"],"sourceUrls":["https://www.elections.alaska.gov/election-results/","https://www.elections.alaska.gov/election-results/e/?id=24genr","https://www.elections.alaska.gov/results/24GENR/ElectionSummaryReport.pdf","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/Legislative/MapServer/2/query?where=STATE%3D%2702%27&outFields=GEOID,STATE,SLDL,NAME,BASENAME&returnGeometry=true&outSR=4326&f=geojson","https://www.elections.alaska.gov/results/24GENR/ENRbyPrecinct.csv","https://www.elections.alaska.gov/results/24GENR/RCV-USRep.pdf","https://www.elections.alaska.gov/results/24GENR/CVR_Export_20241130154411.zip","https://www.elections.alaska.gov/contact-us/","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2702%27&outFields=GEOID%2CSTATE%2CCOUNTY%2CNAME%2CBASENAME&returnGeometry=true&outSR=4326&f=geojson"],"exampleUrls":["https://www.elections.alaska.gov/results/24GENR/ElectionSummaryReport.pdf","https://www.elections.alaska.gov/results/24GENR/ENRbyPrecinct.csv"],"availableFields":["official statewide presidential totals","official statewide U.S. Representative first-choice comparison totals including write-ins","official 523-row precinct/reporting-unit President rows","official same-grain U.S. Representative named-candidate first-choice rows","EAC fallback statewide turnout matching the official summary Times Cast row","state House District geometry lead","state-level equipment context from Verified Voting","official CVR ZIP and RCV report URLs documented as follow-up context","ENR Reg_voters and total_ballots statewide reconciliation evidence matching EAC fallback and summary Times Cast totals","official request packet covering write-ins, geometry/crosswalk, turnout semantics, historical baselines, CVR, audit, recount, incident, correction, and litigation fields","all 30 current Census county-equivalent FIPS tags and geometry"],"missingFields":["U.S. House write-in allocation by precinct/reporting unit or source confirmation of omission","geometry/crosswalk for mixed precinct, absentee, early, question, remote, and HD99 reporting units","state-native lower-grain turnout denominator rows reviewed for denominator timing","loaded 2012/2016/2020 historical baselines","normalized official audit, recount, CVR availability, incident, correction, and litigation rows","exact county-equivalent presidential allocations for 2016, 2020, and 2024"],"parserStatus":"statewide President rows load from scripts/normalize-ak-election-summary.mjs; official ENRbyPrecinct.csv is retained and scripts/normalize-ak-enr-by-precinct.mjs generates 523 localComparisonCsv review rows at precinct/reporting-unit grain with a 750-vote U.S. House write-in caveat; scripts/report-ak-enr-turnout-semantics.mjs confirms ENR Reg_voters/total_ballots reconcile statewide but active turnout remains EAC fallback pending source-side semantics; data/ak-counties.geojson now supplies 30 canonical county-equivalent FIPS tags without changing statewide result grain","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"AK native staging includes official precinct/reporting-unit President versus U.S. House named-candidate first-choice review rows, but certified map results remain statewide only. The ENR precinct CSV omits U.S. House write-in rows, so comparison_other is 750 votes below the statewide summary. ENR turnout fields reconcile statewide after de-duplication, but absentee/early/question units carry ballots with zero registered voters; rows include non-geographic reporting units and should not be joined to geometry without a reviewed crosswalk. Twelve 2024 House districts span multiple county equivalents, so county election totals remain unavailable and no allocation is forced.","nextAction":"Request official county-equivalent totals or ballot-to-home-precinct mappings for 2016, 2020, and 2024, including a reviewed current-geography treatment for the 2016 Valdez-Cordova split."},{"state":"DE","stateName":"Delaware","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_5_digital_inconsistent","reportingGrain":"county_and_election_district","exportFormats":["official HTML report tables","official statewide CSV export","official 2020 HTML/CSV historical report","official AGP fixed-width text","EAC fallback turnout CSV","county GeoJSON","official 2016 raw statewide-office-by-county TXT","official 2020 report HTML","historicalPresidentialCsv"],"sourceUrls":["https://elections.delaware.gov/elections/election_archive.html","https://elections.delaware.gov/reports/GE2024.html","https://elections.delaware.gov/reports/GE2020.html","https://app.powerbigov.us/view?r=eyJrIjoiYmIwM2I3OWUtYjQxNC00YzYxLWEzY2MtY2MwMTIwMjg4NWFhIiwidCI6IjhjMDllNTY5LTUxYzUtNGRlZS1hYmIyLThiOTljMzJhNDM5NiJ9","https://elections.delaware.gov/voter/registrationtotals/reports/agprpt_2024.txt","https://elections.delaware.gov/maps/","https://elections.delaware.gov/public/foia/foia.html","https://elections.delaware.gov/elections/resultsarchive/elect16/elect16_general/data/stwoff_kns.txt"],"exampleUrls":["https://elections.delaware.gov/voter/registrationtotals/pdfs/vrt_PP20241101.csv","https://de-firstmap-delaware.hub.arcgis.com/maps/delaware::election-districts-1"],"availableFields":["official county presidential totals","official election-district President rows","official election-district U.S. Senate comparison rows","EAC fallback turnout rows","DOE AGP state-native registered/voted reconciliation lead","county geometry","supplemental county equipment context","official 2016 and 2020 county presidential historical baseline rows with county:<GEOID> tags"],"missingFields":["active state-native turnout replacement","election-district boundary geometry and result-label crosswalk","normalized audit, recount, CVR availability, incident, correction, litigation, custody, and tabulator-log rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"delawareOfficialReportHtml parser loaded; scripts/normalize-de-historical-presidential-baseline.py loads official 2016 and 2020 historicalPresidentialCsv rows","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Official 2024 report rows and official 2016/2020 historical baselines are loaded. EAC turnout remains active pending DOE AGP semantics review; official 2012 historical baseline rows and election-district geometry/crosswalks remain follow-up work.","nextAction":"Collect official 2012 county presidential baselines, election-district geometry/crosswalks, and audit/CVR/incident/recount/correction/litigation artifacts or request responses."},{"state":"SD","stateName":"South Dakota","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_equipment_admin_context","tier":"tier_5_digital_inconsistent","reportingGrain":"county","exportFormats":["official results app CSV/media pages for current election","official archive service evidence for 2024 General ElectionID 684","official ElectionID 684 statewide XLSX export evidence","secondary county tables","EAC fallback turnout","county GeoJSON","official certified-result request packet JSON","official post-election audit page summary"],"sourceUrls":["https://sdsos.gov/elections-voting/election-resources/election-results/default.aspx","https://electionresults.sd.gov/ResultsMedia.aspx","https://electionresults.sd.gov/ResultsExport.aspx?","https://electionresults.sd.gov/ResultsExport.aspx?eid=684","https://sd-fbfzg0h4abdgeyaz.a01.azurefd.net/ResultsAjax.svc?singleWsdl","https://www.eac.gov/research-and-data/studies-and-reports","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetCandidates?ElectionType=General&ElectionID=684","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetMapDataArchive?Type=SWR&Category=CTY&RaceID=0&OSN=0&County=0&Party=0&ElectionID=684","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetVoterTurnoutArchive?ElectionID=684","https://web.archive.org/web/20241105222716/https://electionresults.sd.gov/","https://electionresults.sd.gov/ElectionTerminology.aspx?eid=684","https://sdsos.gov/elections-voting/upcoming-elections/general-information/2024/2024-general-postelection-audit-results.aspx","https://www.sd.gov/cs?id=sc_cat_item&sys_id=f7f939eddbd4b150b2fb93d4f39619c0"],"exampleUrls":["https://en.wikipedia.org/wiki/2024_United_States_presidential_election_in_South_Dakota","https://en.wikipedia.org/wiki/2024_United_States_House_of_Representatives_election_in_South_Dakota","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetMapDataArchive?Type=SWR&Category=CTY&RaceID=0&OSN=0&County=0&Party=0&ElectionID=684","https://electionresults.sd.gov/ResultsExport.aspx?eid=684"],"availableFields":["secondary county presidential rows citing the SD SOS 2024 General Election Canvass and Certificate","secondary county U.S. House comparison rows citing the same canvass","official SD SOS archive evidence identifying 2024 General ElectionID 684, President map RaceID 12665, and U.S. House map RaceID 11954","official SD SOS archive turnout lead for 66 counties from ElectionID 684","official SD SOS ElectionID 684 statewide XLSX export retained from ResultsExport.aspx?eid=684, labeled 2024 Unofficial General Election Results","EAC fallback turnout rows","county geometry","secondary 2012/2016/2020 historical county baseline rows","supplemental county equipment context from Verified Voting Verifier","official results FAQ text confirming Election Night app results are unofficial and certified results are published through SOS Elections after county/state canvass certification","official 2024 General post-election audit page summary with 66 county rows, 83 linked audit certificates, and 14 counties with discrepancy summary text","official certified-result request packet with SOS public-records and county-auditor request targets"],"missingFields":["retained official SD SOS certified 2024 General Election Canvass and Certificate PDF/static export or archive payload that reconciles to certified county totals","official same-grain precinct/local result rows","state-native turnout denominator rows","precinct boundary geometry or official local reporting-unit crosswalk","official 2012/2016/2020 historical baseline artifacts","normalized official audit certificate rows beyond the retained audit-page summary, plus recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"countyPresidentCsv and countyComparisonCsv still load caveated secondary county staging rows generated by scripts/collect-sd-2024-county-results.mjs. Wave 24 updates scripts/collect-sd-official-archive-evidence.mjs, data/sd-2024-official-results-archive-evidence.json, and data/sd-2024-official-source-request-packet.json to retain official SD SOS archive ElectionID 684, the official Statewide Results.xlsx export, official results FAQ text, a public-records/county-auditor request packet, and 2024 General post-election audit-page context. The archive map-data and XLSX export totals agree with each other but are 194 President votes and 184 U.S. House votes below the current certified-style staging totals, so the certified canvass/export remains a P0 request item.","manualReviewBurden":"medium","confidence":"partial_secondary_staging","caveats":"South Dakota is not completed official-native coverage. Wave 24 retained a stronger official-source request packet and audit-page context, but the official ElectionID 684 statewide XLSX export is labeled unofficial and matches the lower archive map-data totals rather than the current certified-style staging totals. The active 2024 President and U.S. House rows remain reproducible secondary county tables that cite the SD SOS canvass. Review rows are county-level President-versus-at-large-U.S.-House comparisons, not precinct scatter plots. Turnout remains EAC fallback while the ElectionID 684 turnout archive is reviewed as a state-native lead.","nextAction":"Use data/sd-2024-official-source-request-packet.json to request or locate the official 2024 General Election Canvass and Certificate PDF/static export, or a reconciling official ElectionID 684 payload that includes canvass/write-in adjustments beyond the retained unofficial statewide XLSX export. Then decide whether the ElectionID 684 turnout archive can replace EAC fallback after denominator timing review; continue precinct/local result, geometry, historical baseline, and administration-context collection."},{"state":"AZ","stateName":"Arizona","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"county_current_and_historical_review","exportFormats":["signed canvass PDF","official detailed XML ZIP","normalized CSV","normalized local artifact","script-blocked county result pages"],"sourceUrls":["https://azsos.gov/elections/election-information/2024-election-info","https://azsos.gov/elections/results-data","https://apps.azsos.gov/election/2016/General/Official%20Signed%20State%20Canvass.pdf","https://apps.azsos.gov/election/2020/resultsdetail_2020generalxml.zip","https://azsos.gov/elections/election-information/2024-election-information/litigation-info","https://azsos.nextrequest.com/","https://azsos.gov/elections/about-elections/county-election-officials-contact-information"],"exampleUrls":["https://apps.azsos.gov/election/2024/ge/canvass/20241105_GeneralCanvass_Signed.pdf","https://apps.azsos.gov/election/2024/ge/LD2_RECOUNT_Maricopa_County_HC_Audit_Report_NOV2024_FINAL.pdf"],"availableFields":["county President versus U.S. Senate rows","county turnout","state-native county turnout denominators from signed canvass","secondary 2012/2016/2020 county presidential baselines for context","official 2016 and 2020 county President-versus-U.S.-Senate historical advisory rows: 15 canonical county rows per year","retained historical advisory reconciliation with source hashes, statewide totals, and PDF visual QA","official county hand-count audit status summary and document links","Maricopa recount and statewide litigation source paths","SOS public-records portal and county election-office request paths"],"missingFields":["precinct review rows","precinct boundary geometry","statewide precinct/local reporting-unit export","same-grain precinct U.S. Senate rows","reviewed official replacement for secondary 2012/2016 historical baseline other-vote semantics","normalized CVR, ballot-image, tabulator-log, L&A, custody, audit-unit, incident, correction, recount, and litigation rows"],"parserStatus":"native county review package loaded; scripts/normalize_az_historical_review.py deterministically generates 30 historicalReviewCsv county rows from the official 2016 signed canvass PDF and 2020 detailed XML ZIP, with exact statewide reconciliation and reviewed PDF text-layer corrections; AZ admin/source inventory documents hand-count, recount/litigation, and records-request paths without normalizing electronic evidence rows","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Current and historical review rows are county-level advisory inputs, not precinct scatter plots. The official historical package contains 15 canonical county President-versus-U.S.-Senate rows per year. In 2016, President reconciles to 1,161,167 Democratic, 1,252,401 Republican, 159,597 other, and 2,573,165 total votes; U.S. Senate reconciles to 1,031,245 Democratic, 1,359,267 Republican, 140,218 other, and 2,530,730 total votes. In 2020, President reconciles to 1,672,143 Democratic, 1,661,686 Republican, 53,497 other, and 3,387,326 total votes; U.S. Senate reconciles to 1,716,467 Democratic, 1,637,661 Republican, 1,189 other, and 3,355,317 total votes. The 2016 PDF parser records 38 printed one-vote cells absent from the text layer as reviewed fail-closed corrections, and every candidate row reconciles to the printed statewide total. The secondary contextual 2016 presidential baseline totals 31,492 votes more than the official candidate-row sum, entirely in unresolved other-vote semantics, so the two totals must not be silently combined or substituted. The 2026-07-01 AZ coverage inventory records official SOS hand-count status summaries, county canvass links, Maricopa recount/litigation links, and records-request paths, but no official statewide precinct/local President plus same-grain U.S. Senate export or normalized CVR/log/custody/audit-unit rows are loaded. Advisory indicators are review signals only, not findings of fraud or misconduct.","nextAction":"Use data/az-2024-admin-source-inventory.json and data/az-2024-data-coverage-inventory.json as the current AZ source-search records; next steps are county-by-county collection or records requests for precinct/local President and U.S. Senate rows, precinct geometry/crosswalks, CVR/ballot-image/log/L&A/custody records, detailed audit/recount/incident/correction rows, and a reviewed official replacement for the secondary historical-baseline other-vote semantics."},{"state":"KY","stateName":"Kentucky","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_equipment_admin_inventory","tier":"tier_6_official_pdf_hostile","reportingGrain":"precinct","exportFormats":["official county recap PDFs","extracted text","official historical PDF results","EAC turnout fallback","official turnout and registration PDF leads"],"sourceUrls":["https://elect.ky.gov/results/Pages/default.aspx","https://elect.ky.gov/results/2020-2029/Pages/2024General-Recap-Sheets.aspx","https://elect.ky.gov/Resources/Pages/Turnout.aspx","https://elect.ky.gov/Resources/Pages/Registration-Statistics.aspx","https://elect.ky.gov/Resources/Pages/Voting-Systems.aspx","https://elect.ky.gov/About-Us/Pages/County-Clerks.aspx","https://www.eac.gov/research-and-data/studies-and-reports","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/21"],"exampleUrls":["https://elect.ky.gov/results/Pages/default.aspx"],"availableFields":["precinct President rows","precinct U.S. House comparison rows for most counties","county EAC turnout fallback rows","candidate State Board 2024 general turnout rows by county and precinct","candidate State Board 2024 general registration denominator rows by county and precinct","2012/2016/2020 official county presidential historical baselines","county equipment context","county turnout/registration reconciliation report"],"missingFields":["six counties have county-only/no precinct-review rows from extracted recap text","county-clerk official turnout documentation and intentional active-turnout replacement review","precinct boundary geometry or result-to-geometry crosswalk","normalized audit/recount/CVR/incident/correction/litigation artifacts"],"parserStatus":"kentuckyGeneralRecapTextDirectory loaded with Elliott manual transcription; historicalPresidentialCsv loaded from official 2012/2016/2020 Kentucky result PDFs; scripts/reconcile-ky-turnout-registration.mjs now generates a county State Board turnout/registration versus EAC fallback reconciliation, but EAC remains active.","manualReviewBurden":"high","confidence":"loaded_with_caveat","caveats":"County recap PDFs are official, but some text extraction is image-only or county-only. Elliott County uses manual transcription from rendered official PDF pages. Historical baseline rows are official county context only. Turnout uses EAC fallback; the generated State Board county reconciliation is candidate provenance only because the State Board warns turnout reports are unofficial and can differ after rolls reopen.","nextAction":"Review county-clerk official turnout documentation before any active turnout replacement, build a precinct turnout/registration parser with reporting-unit crosswalk, collect precinct boundary geometry or a reporting-unit crosswalk, and request/normalize audit/recount/CVR/incident/correction/litigation artifacts from the State Board, county clerks, county boards, or court/board dockets."},{"state":"MO","stateName":"Missouri","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_equipment_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"county","exportFormats":["official PDF"],"sourceUrls":["https://www.sos.mo.gov/elections/results","https://www.sos.mo.gov/elections/goVoteMissouri/localelectionauthority"],"exampleUrls":["https://www.sos.mo.gov/CMSImages/ElectionResultsStatistics/2024GeneralElection.pdf"],"availableFields":["canonical county President rows","canonical county U.S. Senate comparison rows","state-native registered-voter turnout denominators","2012/2016/2020 official canonical county presidential historical baselines","Verified Voting equipment context","official administration-source inventory for audit, CVR availability, incident/correction, recount, litigation, and qualified-system context"],"missingFields":["official purchasable precinct-level President rows","official purchasable precinct-level U.S. Senate rows","precinct boundary geometry","normalized 2024 post-election audit selection/outcome artifacts","county-by-county CVR availability records","normalized incident/correction/recount/litigation rows"],"parserStatus":"scripts/normalize-mo-sos-pdfs.mjs retains official 116-authority source rows and emits 115 canonical county FIPS rows for President, Senate, turnout, and each historical year; Jackson County combines Kansas City-within-Jackson and Jackson-outside-Kansas-City with zero statewide delta.","manualReviewBurden":"medium","confidence":"loaded_with_blocker","caveats":"The official SOS authority list establishes that the Kansas City row is within Jackson County. Canonical outputs aggregate it to county:29095. Review rows remain county-level rather than precinct-level; the 2016 visible-column caveat remains.","nextAction":"Use data/mo-2024-source-request-tracker.json to purchase or request Missouri SOS precinct-level general election files for 2024 President and U.S. Senate, then add precinct geometry and collect/normalize 2024 audit certificates, CVR availability rows, incidents, corrections, recounts, and litigation records."},{"state":"NE","stateName":"Nebraska","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_equipment","tier":"tier_6_official_pdf_hostile","reportingGrain":"county","exportFormats":["official canvass PDF","official registration PDF","normalized CSV","county GeoJSON","district map PDFs and GIS shapefile ZIPs","voter-file request form","county election office directory","equipment API JSON"],"sourceUrls":["https://sos.nebraska.gov/previous-elections","https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","https://sos.nebraska.gov/elections/voter-registration-statistics","https://sos.nebraska.gov/sites/default/files/doc/elections/vrstats/2024VR/Post-Election-Statewide-November-2024.pdf","https://sos.nebraska.gov/elections/district-subdivision-maps","https://sos.nebraska.gov/elections/voter-file-requests","https://sos.nebraska.gov/elections-division","https://sos.nebraska.gov/election-officials-contact-information","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/31"],"exampleUrls":[],"availableFields":["county President rows","county U.S. Senate two-year special rows","EAC fallback turnout rows","Nebraska canvass county registered-voter and total-voting-by-method tables","Nebraska post-general eligible-voter registration denominator report","county Census TIGER geometry","district/subdivision map PDFs and district GIS shapefiles","voter-file request path with precinct, polling place, district details, and voter history fields subject to statutory use restrictions","2012, 2016, and 2020 official county presidential canvass baselines","canvass Reported Problems section for Dawson, Gage, and Johnson county administration notes","county election-equipment context from supplemental Verified Voting source","Nebraska canvass voting-statistics reconciliation artifact"],"missingFields":["official public precinct/subcounty President result rows","official public precinct/subcounty U.S. Senate result rows","publishable precinct/subcounty boundary geometry or reporting-unit crosswalk","reviewed Nebraska canvass turnout replacement semantics before replacing EAC fallback turnout","official post-election audit selection and outcome artifacts","official recount package for 2024 contests if any were conducted","CVR availability statement or request path with county/state custody caveats","normalized incident, correction, and litigation records beyond the canvass Reported Problems section","official equipment source records from SOS or county election offices beyond supplemental Verified Voting context"],"parserStatus":"county canvass President-versus-U.S. Senate package loaded; official historical county baseline CSV generated by scripts/normalize-ne-historical-baseline.mjs; scripts/normalize-ne-canvass-voting-statistics.mjs generates a canvass/EAC turnout reconciliation showing matching registered voters and a 91-vote ballots/total-voting difference; EAC fallback turnout remains active pending review; precinct/subcounty parser still blocked pending source acquisition","manualReviewBurden":"medium_high","confidence":"loaded","caveats":"Current advisory review rows are county-level President-versus-U.S. Senate two-year special election inputs, not precinct/subcounty scatter plots. The generated canvass voting-statistics reconciliation documents 965,236 statewide Total Voting versus 965,145 EAC fallback ballots cast and no registered-voter denominator difference; active ETL turnout remains EAC fallback pending review. The SOS district GIS shapefiles are district boundaries, not precinct/reporting-unit geometry, and the voter-file request path is restricted and not publishable on the public site.","nextAction":"Review the generated Nebraska canvass voting-statistics reconciliation before replacing EAC fallback turnout; request or locate official Nebraska precinct/subcounty President and U.S. Senate rows plus publishable reporting-unit geometry/crosswalk; request official audit, recount, CVR, incident/correction/litigation, and equipment records from the SOS Elections Division or county election offices."},{"state":"NJ","stateName":"New Jersey","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"county_loaded_municipal_followup","exportFormats":["official statewide certified PDF","normalized official county CSVs","official county municipal result PDFs","official turnout PDFs","official county audit PDFs","county GeoJSON","municipal GIS source lead","EAC fallback benchmark CSV","official 2016 county President PDFs","official 2020 statewide President PDF","historicalPresidentialCsv"],"sourceUrls":["https://www.nj.gov/state/elections/election-information-2024.shtml","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-president.pdf","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-us-senate.pdf","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-voter-turnout.pdf","https://njogis-newjersey.opendata.arcgis.com/datasets/municipal-boundaries-of-nj/about","https://www.nj.gov/state/elections/assets/pdf/election-results/2020/2020-official-general-results-president.pdf","https://www.nj.gov/state/elections/election-information-2016.shtml","https://www.nj.gov/state/elections/assets/pdf/election-results/2016/2016-official-general-results-president-1206b.pdf"],"exampleUrls":["https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-president-atlantic.pdf","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-us-senate-atlantic.pdf","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-result-ballotscast-atlantic.pdf"],"availableFields":["official certified county presidential totals from the DOE statewide PDF","official certified county U.S. Senate comparison totals from the DOE statewide PDF","official county turnout and registered-voter denominator rows from the DOE statewide turnout PDF","EAC fallback turnout retained as a benchmark reconciliation source","county geometry","county equipment context from Verified Voting and NJ DOE equipment inventory source lead","official county-by-county municipal President rows identified as follow-up source leads","official county-by-county municipal U.S. Senate comparison rows identified as follow-up source leads","official 2012/2016/2020 historical archive source leads","official 2024 county post-election audit PDF links and county-official request paths","official 2016 and 2020 county presidential historical baseline rows that resolve to canonical county:<GEOID> tags"],"missingFields":["loaded municipal President-versus-U.S.-Senate review rows","municipal boundary geometry and DOE-label crosswalk","normalized county post-election audit outcome rows","normalized CVR availability, incident, correction, recount, litigation, ballot-manifest, tabulator-log, and EMS-log rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"county-level DOE President, U.S. Senate, and turnout PDFs loaded by scripts/normalize-nj-doe-pdfs.mjs; official 2016 and 2020 historicalPresidentialCsv rows loaded by scripts/normalize-nj-historical-presidential-baseline.mjs","manualReviewBurden":"medium","confidence":"loaded_county_with_municipal_followup","caveats":"County-level 2024 rows and official 2016/2020 historical baselines are loaded from DOE PDFs. Municipal PDFs, municipal geometry/crosswalks, official 2012 historical baselines, audit/CVR/incident/recount/correction/litigation artifacts, and non-geographic row handling remain follow-up work.","nextAction":"Collect official 2012 county presidential baselines, municipal President/U.S. Senate/turnout PDF rows and geometry/crosswalks, plus audit/CVR/incident/recount/correction/litigation artifacts or request responses."},{"state":"NY","stateName":"New York","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_equipment","tier":"tier_6_official_pdf_hostile","reportingGrain":"county","exportFormats":["official PDF","normalized CSV","EAC fallback turnout CSV","Verified Voting equipment context","NYSBOE enrollment report leads","NYSBOE Flateau/VEDA future local-data path","VEDA future results/download export readiness check","source request matrix TSV","missing county request packet JSON","Monroe County official canvass/certification packet follow-through PDFs","Wave 25 official-path evidence JSON"],"sourceUrls":["https://elections.ny.gov/election-results","https://results.elections.ny.gov/document/476","https://ny.elstats-staging.com/eng/files/serve/476","https://ny.elstats-staging.com/eng/files/serve/106","https://ny.elstats-staging.com/eng/files/serve/116","https://ny.elstats-staging.com/eng/files/serve/128","https://www.eac.gov/research-and-data/studies-and-reports","https://elections.ny.gov/enrollment-county","https://elections.ny.gov/enrollment-election-district","https://elections.ny.gov/flateau-database","https://flateau.elections.ny.gov/","https://flateau.elections.ny.gov/results","https://flateau.elections.ny.gov/downloads","https://elections.ny.gov/election-security","https://elections.ny.gov/freedom-information-law-foil-requests","https://publicreporting.elections.ny.gov/CountyBoardRoster/CountyBoardRoster","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/36","https://www.monroecounty.gov/elections-results","https://www.oswegocountyny.gov/government/board_of_elections/elections.php"],"exampleUrls":[],"availableFields":["2024 county President rows from official NYSBOE archive PDF","2024 county U.S. Senate comparison rows from the same official archive PDF","EAC 2024 county/jurisdiction turnout fallback rows","county geometry","2012/2016/2020 county presidential historical baselines from official NYSBOE PDFs","Verified Voting county equipment context","NYSBOE 11/01/2024 county enrollment report lead and election-district enrollment report lead","NYSBOE post-election audit, FOIL, county-board roster, and Flateau/VEDA request/publication paths documented in data/ny-2024-data-coverage-inventory.json","Wave 21 source request matrix for missing local review, turnout, geometry, administration-context artifacts, and VEDA export readiness","Wave 22/25 missing-county request packet JSON for the 12 remaining excluded county equivalents","Wave 23 Monroe County official canvass-book detail and November 26, 2024 certification PDFs retained as follow-through evidence only","Wave 25 official-path evidence artifact for the 12 remaining county equivalents, including an official Oswego County 2024 General PDF/Excel result lead not yet loaded"],"missingFields":["official precinct/local reporting-unit President rows from NYSBOE or county boards for counties still outside local review coverage","official same-grain precinct/local U.S. Senate comparison rows from NYSBOE or county boards for counties still outside local review coverage","state-native ballots-cast or voter-history artifact to pair with NYSBOE enrollment denominators before replacing EAC fallback","official CVR availability inventory","official audit/recount/correction/incident/litigation record package","precinct or election-district boundary geometry and result-label crosswalk"],"parserStatus":"countyPresidentCsv loaded with localComparisonCsv partial review rows, EAC turnout fallback, official PDF historical baseline, county equipment context, NY coverage inventory, Wave 21 source request matrix, Wave 22 county packets, Wave 24 Monroe official detail rows, and Wave 25 official-path evidence; official full-state precinct/election-district parser still needs a complete source package and crosswalk. VEDA/Flateau results and downloads are classified as future official export paths, currently empty for 2024 replacement purposes. Wave 25 found an official Oswego County 2024 General PDF/Excel result lead, but it is not collected, parsed, or reconciled yet.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Current certified results and historical baselines are official county-level rows. Local review rows are supplemental OpenElections county-board source normalizations and legacy NYC rows, not a complete official NYSBOE precinct package; 12 county equivalents remain outside normalized review coverage. EAC turnout fallback and Verified Voting equipment context remain advisory metadata. Monroe official detail rows are loaded after reconciliation, but this does not complete statewide local coverage. Wave 25 found an official Oswego County 2024 General PDF/Excel result lead, but no Oswego rows are loaded until ordinary collection, scripting, and reconciliation are complete.","nextAction":"Use data/ny-2024-data-coverage-inventory.json, data/ny-2024-source-request-matrix.tsv, data/ny-2024-missing-county-request-packets.json, and data/ny-2024-wave25-official-path-checks.json to collect or request official NYSBOE/county election-district President and U.S. Senate rows, starting with ordinary collection and reconciliation of the Oswego County 2024 General PDF/Excel lead; also collect ballots-cast/voter-history rows paired with enrollment denominators, CVR availability, audit/recount/correction/incident records, and precinct/election-district geometry or crosswalks. Monitor VEDA results/download exports for post-April 1, 2026 elections or any later historical 2024 export."},{"state":"OR","stateName":"Oregon","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"county","exportFormats":["official abstract PDF","normalized county CSV","ORMS county precinct PDF/CSV package","EAC fallback turnout CSV","Census county GeoJSON","official 2020 historical abstract PDF","normalized 2020 historical baseline CSV","official 2016/2020 historical abstract PDFs","normalized 2016/2020 historical baseline CSV"],"sourceUrls":["https://sos.oregon.gov/elections/Pages/electionhistory.aspx","https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735458","https://records.sos.state.or.us/ORSOSWebDrawer/Record?q=recNotes%3A2024+General+Election+Precinct+Level+Results&sortBy=recTypedTitle","https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735459","https://sos.oregon.gov/elections/Pages/voting-systems.aspx","https://sos.oregon.gov/elections/Pages/countyofficials.aspx","https://oregonsos.govqa.us/WEBAPP/_rs/","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/13735458","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/13735450","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/6873777","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/6873690","https://records.sos.state.or.us/ORSOSWebDrawer/Record/6873777/File/document","https://digitalcollections.library.oregon.gov/nodes/view/208504"],"exampleUrls":["https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/13735458","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/13735450","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/6873777","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/6873690","https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735458","https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735450","https://records.sos.state.or.us/ORSOSCM/Recordhtml/6873777","https://records.sos.state.or.us/ORSOSCM/Recordhtml/6873690"],"availableFields":["official county presidential totals","official county Attorney General comparison rows","official EAC fallback turnout rows","Census county geometry","county equipment context from Verified Voting","official ORMS precinct result package collected for provenance","official 2020 county presidential historical baseline rows","official 2012/2016 historical result PDF leads","official 2016/2020 historical county presidential baseline rows","official 2012 historical result PDF lead"],"missingFields":["normalized precinct President and same-grain comparison rows","state-native turnout denominator rows from the official Oregon turnout statistics PDF","precinct boundary geometry or reporting-unit crosswalks","normalized post-election audit, CVR availability, incident, correction, recount, litigation, tabulator-log, logic-and-accuracy, custody, and ballot-image records","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"native county President-versus-Attorney-General package loaded from official Oregon abstract PDF; 2016/2020 historical county baselines loaded from official abstract PDFs; ORMS precinct package collected but not normalized; data/or-2024-data-coverage-inventory.json documents remaining official turnout, 2012 historical, audit/CVR, request, and display-path gaps","manualReviewBurden":"high","confidence":"loaded_with_caveat","caveats":"Current Oregon review rows are county-level advisory inputs, not precinct scatter plots. The official ORMS precinct package includes many image/PDF artifacts requiring county-aware extraction or request-produced machine-readable files. Turnout remains EAC fallback until the official Oregon voter registration and turnout statistics PDF is normalized and reconciled. Official 2016/2020 historical baseline rows are loaded from abstract PDFs; 2012 remains a source lead.","nextAction":"Normalize the 2024 official turnout statistics PDF, collect official 2012 historical baseline rows, then build or request machine-readable precinct President plus same-grain comparison rows."},{"state":"TN","stateName":"Tennessee","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_equipment_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"precinct","exportFormats":["official text-layer PDF","normalized CSV","EAC fallback turnout CSV","county GeoJSON","official historical text-layer PDF","official historical county PDF","normalized historical baseline CSV"],"sourceUrls":["https://sos.tn.gov/elections/results","https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyCounty.pdf","https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyOffice.pdf","https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyPrecinct.pdf","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2747%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/47","https://sos-tn-gov-files.tnsosfiles.com/Nov%202020%20General%20by%20County.pdf","https://sos-tn-gov-files.s3.amazonaws.com/PresidentbyCountyNov2016.pdf"],"exampleUrls":["https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyPrecinct.pdf","https://sos-tn-gov-files.tnsosfiles.com/Nov%202020%20General%20by%20County.pdf"],"availableFields":["official county presidential totals","official precinct President rows","official precinct U.S. Senate comparison rows","EAC fallback turnout rows","county geometry","county equipment context from Verified Voting Verifier","official 2016 and 2020 county presidential historical baseline rows"],"missingFields":["state-native turnout denominator rows","precinct boundary geometry or reporting-unit crosswalk","normalized official audit, recount, CVR availability, incident, correction, and litigation records","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"scripts/normalize-tn-sos-results.mjs normalizes the official SOS precinct PDF to 95 county President rows and 1,859 nonzero precinct President-versus-U.S.-Senate review rows; scripts/normalize-tn-historical-presidential-baseline.mjs normalizes official 2016 and 2020 county presidential PDF baselines; EAC fallback turnout, county geometry, and equipment context are loaded","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The official result sources are text-layer PDFs rather than structured exports; the normalizers reconcile parsed totals to official statewide totals before writing CSV artifacts. Turnout remains EAC fallback, county geometry is loaded, precinct geometry/crosswalks are not loaded, official 2012 historical baseline rows remain missing, and no normalized administration-context rows are loaded beyond equipment metadata.","nextAction":"Collect state-native turnout denominators, official precinct geometry/crosswalks, official 2012 historical baselines, and normalized audit/CVR/recount/incident/correction/litigation records."},{"state":"MS","stateName":"Mississippi","jurisdictionName":"County recapitulation PDFs","scope":"statewide","dataFamily":"precinct_review_upgrade","tier":"tier_7_scanned_system_printout","reportingGrain":"precinct","exportFormats":["image-only official PDFs","OCR candidate CSV"],"sourceUrls":["https://sos.ms.gov/elections/electionresults_aspx/elections_results_2024_county.aspx"],"exampleUrls":[],"availableFields":["image-only precinct President rows","image-only precinct U.S. Senate rows"],"missingFields":["reviewed structured precinct CSV","complete correction-reviewed OCR coverage for all counties","fully reconciled OCR output"],"parserStatus":"OCR scripts and reconciliation gate exist; 2026-06-30 reviewed partial verification reported 11 import-ready counties, 61 review-required counties, and 10 missing-OCR counties","manualReviewBurden":"high","confidence":"partial","caveats":"OCR and reviewed corrections recover some counties, but most county outputs remain review-gated; correction additions can represent reviewed cells that are not present in the partial checked-in OCR text. Do not import precinct rows until all counties reconcile to the official SOS recap totals.","nextAction":"Continue OCR/manual review for the 61 review-required counties and 10 missing-OCR counties, rerun npm run etl:verify:ms:ocr:reviewed, then promote only fully reviewed precinct rows."}],"summary":{"byConfidence":{"loaded_with_caveat":26,"loaded":18,"loaded_with_district_comparison_and_historical_caveats":1,"partial_with_2016_2020_historical_loaded":1,"loaded_certified_sov_reconciled":1,"loaded_with_caveats":1,"candidate":1,"partial_secondary_staging":1,"loaded_with_blocker":1,"loaded_county_with_municipal_followup":1,"partial":1},"byScope":{"statewide":52,"county":1},"byTier":{"tier_1_official_export_database":25,"tier_2_official_dashboard_endpoint":14,"tier_3_sanctioned_bulk_partial":1,"tier_4_local_scattershot":1,"tier_5_digital_inconsistent":3,"tier_6_official_pdf_hostile":8,"tier_7_scanned_system_printout":1},"highRoiRows":39,"humanSetupRows":12,"localRows":1,"total":53,"unknownRows":0},"tierDefinitions":[{"tier":"tier_1_official_export_database","label":"Tier 1 official export database","roiRank":1,"description":"Official query or export database, usually CSV/XLS/XLSX capable. Best scripting ROI."},{"tier":"tier_2_official_dashboard_endpoint","label":"Tier 2 official dashboard endpoint","roiRank":2,"description":"Official dashboard or ENR system with consistent JSON, XML, ZIP, or text endpoints."},{"tier":"tier_3_sanctioned_bulk_partial","label":"Tier 3 sanctioned partial bulk data","roiRank":3,"description":"State-sanctioned or official-adjacent bulk data that is useful but incomplete, delayed, or missing fields."},{"tier":"tier_4_local_scattershot","label":"Tier 4 local scattershot","roiRank":4,"description":"County or local sources that must be collected and stitched jurisdiction by jurisdiction."},{"tier":"tier_5_digital_inconsistent","label":"Tier 5 inconsistent digital official data","roiRank":5,"description":"Official digital data with inconsistent jurisdiction names, unusual aggregation, or significant human setup."},{"tier":"tier_6_official_pdf_hostile","label":"Tier 6 official hostile PDF","roiRank":6,"description":"Official PDFs that need extraction/OCR and may include noisy or non-printing text."},{"tier":"tier_7_scanned_system_printout","label":"Tier 7 scanned system printout","roiRank":7,"description":"Scanned printouts from recognizable official systems. OCR may work but requires recurring human checks."},{"tier":"tier_8_scanned_handwritten","label":"Tier 8 scanned handwritten","roiRank":8,"description":"Scanned handwritten records. Lowest scripting ROI and highest manual review burden."},{"tier":"unknown","label":"Unknown","roiRank":99,"description":"Source path has not been classified yet."}]},"meta":{"generatedAt":"2026-07-26T15:53:13.297Z","source":"database","releaseId":null,"schemaVersion":"1.0.0","state":null,"tier":null,"rowCount":53}}