2024 missing data dashboard

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

Add comparison and turnout context if needed; county FIPS coverage is complete.

Parser Status

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.

Missing Fields

same-grain comparison contest; reviewed turnout and registration denominator package

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.

Parser Status

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

Missing Fields

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

Collect official 2012 Hawaii historical baseline rows, precinct geometry/crosswalks if subcounty overlays are pursued, and normalized audit/CVR/recount/incident/correction/litigation records.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

state-native precinct registered-voter denominator; precinct boundary geometry; audit/CVR/incident artifacts; official 2012 county or county-equivalent presidential baseline normalized into ETL

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

native precinct review package loaded with secondary historical baseline and administration source inventory

Missing Fields

precinct boundary geometry; official script-readable 2012/2016/2020 historical county presidential exports; normalized audit/recount/CVR/incident/correction records

Treat as an example Tier 1 goal state; optional next step is precinct geometry.

Parser Status

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

Missing Fields

precinct boundary geometry

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.

Parser Status

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

Missing Fields

precinct rows; state-native ballots-cast turnout rows to pair with the collected November 2024 active-voter denominator lead

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

native official XLSX package loaded for county certified results, precinct President-versus-U.S.-Senate review rows, and precinct registered-voter turnout rows

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

Optional next steps are precinct geometry and precinct turnout denominator.

Parser Status

native precinct review package loaded; official historical bulk baseline loaded

Missing Fields

precinct boundary geometry; precinct turnout denominator

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.

Parser Status

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.

Missing Fields

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

Collect or normalize official 2012 county historical baseline, precinct boundary geometry, and normalized audit/CVR/incident/recount/litigation rows.

Parser Status

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

Missing Fields

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

Collect precinct boundary geometry and official audit/CVR/recount/litigation records or document source-side blockers.

Parser Status

native Virginia ElectionStats and ENR package loaded for certified locality results, precinct President-versus-U.S. Senate review rows, and precinct turnout/registration rows

Missing Fields

precinct boundary geometry; normalized audit, recount, CVR availability, incident, litigation, and correction records beyond ENR change-log summary and equipment context

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.

Parser Status

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

Missing Fields

complete statewide precinct export; precinct boundary geometry; state-native turnout denominator; official 2012 county or county-equivalent presidential baseline normalized into ETL

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.

Parser Status

native ward review package loaded with historical baseline and partial audit context

Missing Fields

ward-level registration denominator; per-reporting-unit audit discrepancy outcomes; county CVR availability verification; normalized incident/correction/recount/litigation rows

Collect state-native registered-voter denominator, precinct geometry/crosswalks, and official audit/CVR/recount/incident/correction/litigation context where available.

Parser Status

nativeWyomingSosGeneralZip parses official 2024 SOS ZIP plus official 2012/2016/2020 historical ZIPs; turnout remains EAC fallback.

Missing Fields

state-native registered-voter denominator; precinct boundary geometry or crosswalks; normalized audit/CVR/recount/incident/correction/litigation records

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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

Missing Fields

state-native turnout denominator; precinct boundary geometry; normalized official audit/recount/CVR/incident/correction records

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

Collect precinct boundary geometry/crosswalks, an official 2012 historical baseline artifact, and normalized audit/CVR/incident/correction/recount/litigation records.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

Collect precinct/local reporting-unit rows, precinct geometry/crosswalks, official historical baselines, and normalized audit/CVR/incident/correction/litigation records.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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

Missing Fields

official statewide precinct boundary geometry; normalized 2024 post-election audit selection/outcome artifacts; normalized CVR availability rows; incident, correction, recount, and litigation records

Request source-side notes or county crosswalk documentation for VTD generic write-in handling, then add VTD boundary geometry.

Parser Status

texasCountyJsonVtdReview loaded with VTD write-in reconciliation summary

Missing Fields

ballot method fields; precinct/VTD boundary geometry; source-side explanation for generic VTD write-in rows versus named certified write-in candidates

Use only if Texas statewide sources cannot provide required precinct rows.

Parser Status

example local source only; parser not implemented

Missing Fields

statewide coverage; registration denominator source; consistent navigation across counties

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.

Parser Status

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

Missing Fields

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

Collect official 2012 county presidential baselines, election-district geometry/crosswalks, and audit/CVR/incident/recount/correction/litigation artifacts or request responses.

Parser Status

delawareOfficialReportHtml parser loaded; scripts/normalize-de-historical-presidential-baseline.py loads official 2016 and 2020 historicalPresidentialCsv rows

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

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.

Parser Status

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.

Missing Fields

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

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.

Parser Status

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

Missing Fields

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

Collect state-native turnout denominators, official precinct geometry/crosswalks, official 2012 historical baselines, and normalized audit/CVR/recount/incident/correction/litigation records.

Parser Status

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

Missing Fields

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

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.

Parser Status

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

Missing Fields

reviewed structured precinct CSV; complete correction-reviewed OCR coverage for all counties; fully reconciled OCR output

Wave 25 keeps AK in sourceDiscoveryQueue but narrows the remaining blockers. AK stages one certified statewide President row, 523 official precinct/reporting-unit President-versus-U.S.-House named-candidate first-choice review rows, and one EAC turnout row. ENRbyPrecinct.csv still does not itemize 750 statewide U.S. House write-in votes by reporting unit. ENR Reg_voters and total_ballots de-duplicate to 523 reporting units and reconcile to 611,078 registered voters and 340,981 ballots, but district absentee, early-voting, and question rows carry ballots with zero registered voters, so active turnout remains EAC fallback until source-side denominator semantics are reviewed. Geometry/crosswalk, official historical baselines, and normalized audit/CVR/recount/incident/correction/litigation rows remain request-tracked in data/ak-2024-official-source-request-packet.json.

Parser

scripts/normalize-ak-election-summary.mjs generates statewide President CSVs from data/ak-2024-general-election-summary-report.pdf. scripts/normalize-ak-enr-by-precinct.mjs reads official data/ak-2024-general-enr-by-precinct.csv and writes data/ak-2024-general-precinct-president-us-house-review.csv for localComparisonCsv review rows. civic_etl/native.py uses countyPresidentCsv for the statewide certified row and localComparisonCsv for 523 AK review rows.

Needed

official 2024 Election Summary Report PDF; normalized statewide President CSV generated from the official summary PDF; official ENRbyPrecinct.csv retained from the 2024 General All Details page; normalized 523-row precinct/reporting-unit President versus U.S. House named-candidate first-choice review CSV generated from ENRbyPrecinct.csv; EAC fallback turnout rows, matching the official summary Times Cast statewide totals; State House District geometry retained as a future join lead only; data/ak-2024-data-coverage-inventory.json and data/ak-2024-source-request-matrix.tsv documenting the remaining U.S. House write-in allocation, geometry/crosswalk, turnout, historical, and administration-context request fields; official results page evidence artifact documenting concrete ENR, SOVC, CVR, and RCV source URLs; data/ak-2024-enr-turnout-semantics.json documenting ENR Reg_voters/total_ballots reconciliation and mixed reporting-unit caveats; data/ak-2024-official-source-request-packet.json refreshing request fields for write-ins, geometry/crosswalk, turnout semantics, historical baselines, and administration context

Official Indiana ENR county category JSON is collected and parsed for certified 2024 county totals, official county turnout is loaded, official 2012/2016/2020 county historical baselines are normalized, and the official VSTOP 2024 General Election audit summary is loaded for seven audited counties as context. The ENR public-data inventory confirms the public app path fetches OffCatC office-category JSON and turnout-statistics downloads, and the July 4, 2026 ordinary public-path recheck returned HTTP 200 for settings, President, U.S. Senate, and turnout JSON, but no President or U.S. Senate precinct/subcounty candidate export; collected JurR county jurisdiction JSON files contain zero candidate containers. Advisory flags still use MIT/OpenElections supplemental local rows, with caveats that MIT flags Indiana Senate/Governor overreporting in some counties and non-unique precinct labels. Indiana remains out of completedNativeStates until official same-grain precinct/subcounty President and U.S. Senate rows are collected or the methodology explicitly accepts supplemental review rows as complete. Normalized detailed audit/CVR/incident/correction records remain preferred/request-path administration items. Wave 25 did not identify a public official replacement export; the existing machine-readable county custodian routing covers all 92 counties and official precinct/split counts for follow-up after the statewide request.

Parser

indianaEnrCountyJson package loaded for official county results; normalizedTurnoutCsv loaded for official county turnout; historicalPresidentialCsv loaded for official 2012/2016/2020 county baselines; indianaEnrJurisdictionDirectoryInventory collected; localComparisonCsv loaded for MIT/OpenElections supplemental precinct President and U.S. Senate rows; scripts/normalize-in-audit-summary.mjs loads official VSTOP 2024 audit summary context. scripts/build-in-request-routing.mjs now generates county custodian request routing from official JurR metadata plus the official precinct/split-count PDF. Future parsers are needed only if an official precinct/subcounty result export, detailed audit workpapers, CVR availability records, or incident/correction/recount rows are obtained.

Needed

official precinct-level or county-subdivision result rows for President, if Indiana publishes or provides them; official same-grain U.S. Senate rows for advisory comparison if President rows are available below county; data/source-records-request-packets/in-2024-precinct-results-request.md as the current Indiana Election Division/county custodian request packet, including precinct-split fields; precinct or lower-level turnout and registered-voter denominator rows if same-grain turnout screening is required; precinct or local reporting-unit boundary geometry, if subcounty map overlays are required; audit, recount, CVR availability, incident, correction, and certification records for 2024 administration context; official county 2024 turnout and registration rows are loaded from the Indiana Election Division PDF; supplemental MIT/OpenElections President and U.S. Senate local review rows are loaded for advisory flag calculation; Verified Voting county equipment context is loaded as secondary administration context only; official 2016 and 2020 county historical presidential baselines are loaded from ENR archive JSON; detailed official VSTOP audit-unit workpapers beyond the loaded 2024 General Election audit summary, if published or request-produced; official CVR availability/exportability records or request-produced county CVR records; official Recount Commission/county incident, correction, recount, and litigation records; official VSTOP 2024 General Election audit summary rows are loaded for seven audited counties as context only; data/in-2024-county-request-routing.csv and data/in-2024-county-request-routing-summary.json as the current county custodian follow-up tracker

Iowa has official county detailxml.zip reports collected from the Secretary of State Clarity results app. The parser loads precinct-level President-versus-U.S.-House review rows and state-native precinct turnout rows. Remaining gaps are a normalized Iowa vote-method package for Clarity VoteType fields, collected/crosswalked SOS precinct shapefile geometry for subcounty overlays, normalized audit selection/outcome rows from the 2024 precinct-audit source or county reports, official 2012/2016/2020 historical replacement artifacts, and normalized recount/CVR availability/incident/correction/litigation records.

Parser

iowaClarityCountyDetailXmlDirectory loaded for 99 county result rows, 1,653 precinct review rows, and 1,651 precinct turnout rows. data/ia-2024-data-coverage-inventory.json now documents confirmed Clarity VoteType fields, official SOS county precinct shapefile leads, the official 2024 precinct-audit image lead, official historical replacement leads, and remaining admin request paths.

Needed

official county detailxml.zip reports for all 99 counties; Iowa Clarity VoteType normalizer/public vote-method package if method display rows are added, with candidate-contest-method caveats and reconciliation to contest totals; official county precinct shapefile ZIP collection, web-safe geometry normalization, and Clarity precinct-name crosswalk if subcounty map overlays are required; browser/manual or request-produced copy of the official 2024 General Election County Precinct Audits source plus normalized selected-precinct report/selection/outcome rows; 2024 recount or administrative-audit request/result packets if any; CVR availability/request-path responses by county or state custodian; official incident, correction, and litigation records if published or provided by request; official Iowa SOS 2012, 2016, and 2020 county presidential artifacts plus parser before replacing secondary historical baseline context rows

Kentucky has official 2024 county recap PDFs, official 2012/2016/2020 county historical presidential baselines, county geometry, loaded county equipment context, and a generated county turnout/registration reconciliation. Remaining blockers are county-clerk official documentation before any active turnout replacement, precinct-level turnout/registration crosswalk work, precinct boundary geometry, normalized audit/recount/CVR/incident/correction/litigation records, and six counties that remain county-only/no precinct-review from extracted 2024 recap text.

Parser

kentuckyGeneralRecapTextDirectory loaded for 120 county result rows and 3,067 precinct review rows; historicalPresidentialCsv loaded for 360 official 2012/2016/2020 county baseline rows; EAC fallback turnout remains active. scripts/reconcile-ky-turnout-registration.mjs now parses county State Board turnout/registration PDFs into a 120-row reconciliation report showing 2,086,320 State Board voters versus 2,086,090 EAC ballots cast and the same 3,548,136 registered-voter denominator.

Needed

county-clerk official turnout documentation and replacement-semantics review before promoting the generated State Board county turnout/registration reconciliation over EAC fallback turnout; precinct boundary geometry or publishable reporting-unit crosswalk if subcounty map overlays are required; post-election audit selection/outcome records, recount/recanvass records, CVR availability/request paths, incident/correction records, and litigation records beyond the loaded equipment context; precinct-level turnout/registration parser or crosswalk if using State Board precinct PDFs below county grain

Mississippi county-level President-versus-U.S. Senate review rows are live from the Secretary of State statewide recap CSV. On 2026-06-30, the reviewed partial OCR path reported 11 import-ready counties, 61 review-required counties, and 10 missing-OCR counties; precinct-level advisory flags remain blocked until all county recapitulation PDFs are OCRed or manually reviewed, reconciled to the official recap totals, and parsed into structured rows. Historical baselines are loaded from official SOS county presidential artifacts for 2020, 2016, and 2012. Turnout remains EAC fallback: the official November 2024 Active Voter Count denominator lead is collected, normalized, and summarized against EAC, but it is not a complete turnout replacement without official Mississippi ballots-cast or voter-participation rows. The current follow-up queue is recorded in data/ms-2024-source-request-matrix.tsv.

Parser

mississippiElectionRecapCsv is loaded for county review. The official November 2024 Active Voter Count denominator lead is collected and normalized by npm run etl:collect:ms:active-voters, but it remains candidate context because it has no ballots-cast rows; the generated summary records the current EAC fallback comparison. For precinct-level rows, run scripts/ocr-ms-county-result-pdfs.mjs or reuse checked-in OCR text, run scripts/extract-ms-recap-ocr-text-rows.mjs and scripts/reconcile-ms-ocr-grid-cells.mjs, apply reviewed corrections with npm run etl:verify:ms:ocr:reviewed for partial-review status, then promote only a fully reviewed structured precinct artifact. Historical baselines are loaded from source-cited official SOS county presidential artifacts for 2020, 2016, and 2012; keep them county-level context only. Use data/ms-2024-source-request-matrix.tsv for artifact-specific follow-up asks.

Needed

OCR text generated from official county recapitulation PDFs with npm run etl:ocr:ms if precinct-level review is pursued; the default renderer/OCR path is Node-based and rotates the sideways recapitulation sheets before OCR, with optional external Poppler/Tesseract mode; reviewed structured precinct-level President-versus-U.S. Senate CSV promoted from scripts/extract-ms-recap-grid-cells.mjs output; state-native turnout denominator artifact and official ballots-cast/voter-participation artifact if replacing EAC turnout fallback; SOS Active Voter Count Reports are a denominator lead only; official November 2024 Active Voter Count denominator lead collected at data/ms-2024-november-active-voter-count.pdf, normalized to data/ms-2024-november-active-voter-count.csv, and summarized at data/ms-2024-turnout-denominator-lead-summary.json by npm run etl:collect:ms:active-voters; keep as candidate context until official ballots-cast or voter-participation rows are paired with it; official 2020, 2016, and 2012 Mississippi SOS county presidential artifacts from the SOS archive iframe targets, direct recap files, or SOS request path before enabling historical baselines; data/ms-2024-source-request-matrix.tsv as the current bounded request queue for OCR review, turnout replacement, historical baselines, precinct geometry, and administration-context records

Missouri has official county/reporting-jurisdiction President-versus-U.S. Senate review rows, state-native 2024 registered-voter turnout denominators, 2012/2016/2020 official historical presidential baselines, an official administration-source inventory for audit/CVR/incident/recount/litigation/equipment context, and a request tracker at data/mo-2024-source-request-tracker.json. The SOS page says precinct-level general election data files are available for purchase by contacting the Elections Division, so precinct-level advisory flags remain blocked until that file is obtained and paired with geometry or a reporting-unit crosswalk. Normalized audit outcomes, county CVR availability, incident/correction, recount, and litigation rows are still not loaded.

Parser

countyPresidentCsv loaded for Missouri official county/reporting-jurisdiction package; normalizedTurnoutCsv and historicalPresidentialCsv are generated from official Missouri SOS PDFs by scripts/normalize-mo-sos-pdfs.mjs; data/mo-2024-admin-source-inventory.json records official administration-source paths; precinct data must be purchased from Missouri SOS for subcounty rows

Needed

official purchasable precinct-level data file if subcounty advisory flags are required; official precinct boundary geometry if subcounty map overlays are required; normalized post-election audit selection/outcome artifacts, CVR availability rows, incident/correction rows, recount records, and litigation records for administration context; data/mo-2024-source-request-tracker.json request tracker maintained until precinct/admin records are collected

Nebraska has official county-level President-versus-U.S. Senate two-year review rows, EAC fallback turnout with generated state-native canvass reconciliation and registration cross-check paths, official 2012/2016/2020 county presidential baselines, county geometry, and an administration-source inventory. The live SOS previous-elections, voter-registration, district-map, voter-file, Elections Division, and county contact pages do not expose a statewide public precinct/subcounty President plus U.S. Senate result export or matching precinct/subcounty geometry. Request those rows and crosswalk/geometry before calculating comparable advisory flags below county level.

Parser

countyPresidentCsv and countyComparisonCsv are loaded for Nebraska official county canvass rows; scripts/normalize-ne-historical-baseline.mjs loads official historical county baselines; scripts/normalize-ne-canvass-voting-statistics.mjs generates the canvass/EAC turnout reconciliation, but EAC remains active until replacement semantics are reviewed; precinct/subcounty result and geometry parsers remain blocked pending source acquisition.

Needed

official precinct-level or local reporting-unit result rows for President; official precinct-level or local reporting-unit result rows for U.S. Senate; precinct/subcounty boundary geometry or official reporting-unit crosswalk if subcounty map overlays are required; review of generated Nebraska canvass voting-statistics reconciliation before replacing EAC fallback turnout; current artifact reconciles official canvass Total Voting 965,236 against EAC fallback ballots cast 965,145; official 2024 post-election audit selection/outcome artifacts if published or obtainable; official recount records for 2024 contests if any were conducted; CVR availability statement or request path with county/state custody and privacy caveats; normalized incident, correction, litigation, and official equipment source records beyond the canvass Reported Problems and supplemental equipment context

Clark County, Washoe County, and Humboldt County official CVR precinct President-versus-Senate rows are loaded, but statewide Nevada remains partial because the other 14 jurisdictions still have only county-level President-versus-Senate review rows. The July 4, 2026 Wave 24 packet pass rechecked Eureka County, found current/downloadable 2026 county election documents but no parser-ready 2024 local export/CVR, and generated data/nv-2024-non-clark-county-request-packets.json from the county request matrix to operationalize county-by-county official records requests.

Parser

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, and Wave 24 adds data/nv-2024-non-clark-county-request-packets.json as generated per-jurisdiction request packets. Local exports or request-produced SOV/CVR files are still needed before statewide precinct advisory coverage can be calculated. A normalizedTurnoutCsv-style parser is needed before replacing EAC fallback turnout, and a geometry/crosswalk parser is needed before mapping subcounty review rows.

Needed

official precinct or local reporting-unit results for President and U.S. Senate for the 14 Nevada jurisdictions outside Clark, Washoe, and Humboldt, tracked with official contact/custodian paths and expected-field detail in data/nv-2024-county-source-request-matrix.tsv plus operational packets in data/nv-2024-non-clark-county-request-packets.json; state-native turnout denominator rows with ballots-cast, registered-voter denominator, timing, and inactive-voter treatment notes; official precinct/local reporting-unit geometry or crosswalks for subcounty review rows; official 2012, 2016, and 2020 Nevada historical presidential baseline exports if available to replace secondary context rows; post-election audit, remaining CVR availability, tabulator-log, L&A, custody, incident/correction, recount, and litigation artifacts

New Hampshire now has official town/ward President-versus-U.S. House review rows and state-native town/ward turnout denominators from archived Secretary of State workbooks. The July 2, 2026 inventory records exact official 2016 CDX capture timestamps, MIME types, digests, and lengths for nine President XLS workbooks, Governor, and U.S. House Districts 1 and 2; direct binary downloads from web/{timestamp}id_ URLs still failed from this worker environment, including after sandbox escalation, so no historical rows are loaded. The live SOS page still returns access denied from this environment, 2020 and 2012 remain targeted archive/records-request items, and town/ward geometry plus normalized audit/recount/CVR/incident/correction/litigation records remain uncollected.

Parser

newHampshireTownWardCsv loaded for 10 county result rows, 304 town/ward President-versus-U.S.-House review rows, and 304 state-native town/ward turnout rows from official ballots-cast and names-on-checklist workbooks. A historical sibling normalizer is needed for the identified 2016 official archive workbook leads before historical baseline rows can be loaded.

Needed

downloaded official 2016 President, Governor, and U.S. House workbook artifacts plus a historical normalizer before loading 2016 baseline rows; targeted official archive or records-request path for 2020 and 2012 President-versus-U.S. House/Governor baseline artifacts; town/ward boundary geometry or official reporting-unit crosswalk if map overlays below county level are required; normalized post-election audit, recount, CVR availability, incident/correction, and litigation artifacts; data/nh-2024-source-request-matrix.tsv as the current official-source request queue for 2016, 2020, 2012, town/ward geometry, and administration-context gaps

County-level President and U.S. Senate rows and 2012/2016/2020 official county historical baselines are loaded from NYSBOE official archive PDFs. Partial local review rows cover 50 county equivalents through OpenElections/legacy NYC sources plus reconciled official Monroe detail rows, while Herkimer, Jefferson, Nassau, Ontario, Orange, Orleans, Oswego, Rockland, Schuyler, Steuben, Wyoming, and Yates remain outside normalized review coverage. Wave 25 found an official Oswego County 2024 General PDF/Excel result lead, but it is not collected, parsed, or reconciled. EAC turnout remains fallback because NYSBOE enrollment reports are denominator leads, not ballots-cast rows. VEDA/Flateau is live but exposes no 2024 exportable replacement rows. CVR availability, audit comparison reports, incident/correction/recount/litigation records, and precinct/election-district geometry still need source collection or request-produced artifacts.

Parser

countyPresidentCsv loaded for New York official county package; localComparisonCsv loaded for partial supplemental local review rows; historicalPresidentialCsv loaded from official NYSBOE PDFs; eacTurnoutCsv remains active. data/ny-2024-source-request-matrix.tsv tracks missing official election-district/local result, turnout/voter-history, geometry/crosswalk, administration-context source requests, and VEDA export-readiness. data/ny-2024-wave25-official-path-checks.json records the Wave 25 recheck and an official Oswego County 2024 General PDF/Excel result lead that still needs ordinary collection, parsing, and reconciliation. A complete official election-district parser, turnout/voter-history parser, and geometry/crosswalk parser are still needed before full same-grain NY local coverage can replace the current caveats.

Needed

official archive PDF document 476 for 2024-11-05 Presidential General results; normalized county President CSV extracted from official PDF; normalized county U.S. Senate CSV extracted from official PDF; supplemental OpenElections local review rows for machine-readable, selected text-layer PDF, Suffolk text, and legacy NYC coverage; official 2012/2016/2020 general-election PDFs for county historical presidential baselines; normalized historical presidential baseline CSV generated from the official PDFs; EAC fallback turnout rows until a New York-native ballots-cast or voter-history package is collected; NYSBOE county and election-district enrollment reports as denominator leads only; county geometry for map joins; Verified Voting county equipment context for advisory administration metadata; NYSBOE audit, FOIL, county-board roster, Flateau/VEDA, and voting-technology paths documented in data/ny-2024-data-coverage-inventory.json; data/ny-2024-source-request-matrix.tsv as the current official-source request queue for missing county local review, turnout, geometry, administration-context gaps, and future VEDA export readiness; data/ny-2024-missing-county-request-packets.json as the county-by-county operational request packet for the 12 remaining missing local-review county equivalents; Monroe County official 2024 canvass-book detail and November 26, 2024 certification PDFs reconciled and loaded as 655 local review rows; data/ny-2024-wave25-official-path-checks.json as the Wave 25 official-path evidence artifact, including an official Oswego County public result lead not yet loaded

West Virginia has official county detailxml.zip reports collected from the Secretary of State Clarity results app. The parser loads precinct-level President-versus-U.S.-Senate review rows and state-native precinct turnout denominators from VoterTurnout totalVoters/ballotsCast. Remaining gaps are official statewide precinct boundary geometry for subcounty overlays, normalized 2024 hand-count audit selection/outcome rows, CVR availability responses, recount/correction/incident/litigation records, and normalized 2012/2016/2020 historical baseline rows. The Wave 9 coverage inventory records the current official request/source paths without loading those rows.

Parser

westVirginiaClarityCountyDetailXmlDirectory loaded for 55 county result rows, 1,648 precinct review rows, and 1,649 precinct turnout rows. Equipment context is loaded separately from Verified Voting county context; data/wv-2024-data-coverage-inventory.json documents official SOS/county request paths for audit outcomes, CVR availability, recounts, corrections, incidents, litigation, precinct geometry, and historical baselines.

Needed

official county detailxml.zip reports for all 55 counties; precinct boundary geometry if subcounty map overlays are required; official 2024 post-election audit selection/outcome artifacts if published or obtainable; CVR availability/request-path inventory; incident, correction, recount, and litigation source inventory; data/wv-2024-data-coverage-inventory.json documenting loaded artifacts, official request paths, historical-source leads, and display caveats

Wave 24 retained official SD SOS archive ElectionID 684 through the older ResultsAjax service, the official ResultsExport.aspx?eid=684 Statewide Results.xlsx workbook, official results FAQ text, and a source-request packet. GetMapDataArchive with RaceID=0 exposes President map RaceID 12665 and U.S. House map RaceID 11954, and the XLSX has matching President/U.S. House sheets. Both official app artifacts total 428,728 President votes and 421,264 U.S. House votes, below the current certified-style staging totals by 194 and 184 votes. The workbook labels itself 2024 Unofficial General Election Results, and five likely SOS 2024 State Canvass and Certificate PDF asset paths returned 404. Current rows remain secondary staging coverage until a certified/reconciling official artifact is retained.

Parser

scripts/collect-sd-2024-county-results.mjs currently regenerates secondary county President and U.S. House CSVs for countyPresidentCsv/countyComparisonCsv. scripts/collect-sd-official-archive-evidence.mjs now retains official ElectionID 684 archive evidence, the official ResultsExport statewide XLSX workbook, official results FAQ text, post-election audit-page context, and data/sd-2024-official-source-request-packet.json. An official certified canvass/export normalizer is still needed before replacing secondary staging rows.

Needed

official SD SOS certified 2024 General Election Canvass and Certificate PDF/static export or an ElectionID 684 official archive/export payload that reconciles to certified county totals; the retained unofficial statewide XLSX export does not reconcile; state-native county or precinct turnout and registered-voter denominator rows; precinct/local President plus same-grain comparison rows if subcounty advisory coverage is pursued; precinct boundary geometry or official reporting-unit crosswalk; official 2012/2016/2020 historical county presidential artifacts; normalized audit, recount, CVR availability, incident, correction, and litigation artifacts or request responses; data/sd-2024-source-request-matrix.tsv as the current official-source request queue