{"data":{"checkedAt":"2026-07-12","blockedStates":[],"completedNativeStates":["AL","AR","AZ","CA","CO","CT","DC","DE","FL","GA","HI","IA","ID","IL","KS","KY","LA","MA","MD","ME","MI","MN","MO","MS","MT","NC","ND","NE","NH","NJ","NM","NV","OH","OK","OR","PA","RI","SC","TN","TX","UT","VA","VT","WA","WI","WV","WY"],"notes":["These packages point to official source artifacts already present in this repository.","Generated *-app-data.js bundles are listed only as reference outputs; native ETL should parse the official artifacts directly.","County geometry is available for these three states. Precinct/ward boundary geometry is not included in this package.","The sourceDiscoveryQueue tracks states where official local reporting-unit artifacts still need collection before native advisory flags can be calculated under the current methodology.","County-only presidential/result tables are not sufficient for comparable advisory flag generation; each review-capable state needs President plus a same-row comparison contest at precinct, ward, town, or equivalent local reporting-unit level."],"purpose":"Native importer handoff package for the next states after Ohio and Wisconsin.","sourceDiscoveryQueue":[{"state":"AK","name":"Alaska","priority":20,"currentStatus":"official_statewide_result_precinct_review_loaded_write_in_geometry_turnout_gaps_remaining","officialSourcePages":["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/CVR_Export_20241130154411.zip","https://www.elections.alaska.gov/results/24GENR/RCV-USRep.pdf","https://www.elections.alaska.gov/contact-us/"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. Representative first-choice votes; official ENRbyPrecinct.csv now provides same-grain President plus U.S. House named-candidate rows for 523 precinct/reporting units, with a 750-vote U.S. House write-in caveat.","parserNeeded":"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.","blocker":"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.","availableArtifacts":{"presidentialStatewideResults":{"sourceTitle":"State of Alaska 2024 General Election Election Summary Report, official results","sourceUrl":"https://www.elections.alaska.gov/results/24GENR/ElectionSummaryReport.pdf","localFile":"data/ak-2024-general-election-summary-report.pdf; data/ak-2024-general-president-statewide.csv","parserHint":"Run node scripts/normalize-ak-election-summary.mjs. The generated countyPresidentCsv row is statewide and totals 338,177 presidential votes: 184,458 Trump, 140,026 Harris, and 13,693 Other."},"statewideComparisonRows":{"sourceTitle":"State of Alaska 2024 General Election Election Summary Report, official U.S. Representative first-choice totals","sourceUrl":"https://www.elections.alaska.gov/results/24GENR/ElectionSummaryReport.pdf","localFile":"data/ak-2024-general-us-house-statewide.csv","level":"statewide","comparisonContest":"U.S. Representative first-choice votes","parserHint":"The generated countyComparisonCsv row groups Peltola and Hafner as DEM comparison votes, Begich as REP comparison votes, and Howe plus write-in as Other. It is statewide ranked-choice first-choice context only."},"turnout":{"sourceTitle":"EAC fallback turnout plus Alaska summary Times Cast cross-check","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ak-2024-eac-turnout.csv","level":"jurisdiction_statewide","denominator":"EAC registered voters; statewide values match Alaska summary Times Cast 340,981 of 611,078.","parserHint":"Active ETL remains eacTurnoutCsv until lower-grain state-native turnout denominators are collected."},"houseDistrictGeometry":{"sourceTitle":"U.S. Census TIGERweb Alaska State House District geography","sourceUrl":"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","localFile":"data/ak-house-districts.geojson","parserHint":"Geometry lead only for AK until official House-district result rows are collected."},"coverageInventory":{"sourceTitle":"Alaska 2024 data coverage and source request inventory","sourceUrl":"https://www.elections.alaska.gov/election-results/","localFile":"data/ak-2024-data-coverage-inventory.json; data/ak-2024-source-request-matrix.tsv; data/ak-2024-official-results-page-evidence.json","parserHint":"Documents the statewide-only load, official 2024 General All Details/SOVC follow-up path, missing district/precinct result rows, state-native turnout, historical baselines, and administration-context gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Alaska 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/2","localFile":"data/ak-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of statewide uniform equipment."},"officialResultsPageEvidence":{"sourceTitle":"Alaska Division of Elections official results page and 2024 General All Details/SOVC source-discovery evidence","sourceUrl":"https://www.elections.alaska.gov/election-results/","localFile":"data/ak-2024-official-results-page-evidence.json","parserHint":"Evidence artifact now records concrete official ENRbyPrecinct.csv, House District SOVC PDF, CVR ZIP, and RCV report URLs; remaining request packet is U.S. House write-in allocation/confirmation, reporting-unit geometry/crosswalk, turnout denominator semantics, historical baselines, and administration context."},"localReviewRows":{"sourceTitle":"Alaska Division of Elections official 2024 General ENRbyPrecinct.csv","sourceUrl":"https://www.elections.alaska.gov/results/24GENR/ENRbyPrecinct.csv","localFile":"data/ak-2024-general-enr-by-precinct.csv; data/ak-2024-general-precinct-president-us-house-review.csv","level":"precinct_or_reporting_unit","comparisonContest":"U.S. Representative first-choice named-candidate rows","parserHint":"Run node scripts/normalize-ak-enr-by-precinct.mjs. The normalized localComparisonCsv emits 523 review rows and reconciles presidential totals exactly to the summary PDF. U.S. House DEM and REP named-candidate totals reconcile, but comparison_other excludes 750 statewide write-ins not itemized in ENRbyPrecinct.csv."},"turnoutSemantics":{"sourceTitle":"Alaska Division of Elections ENRbyPrecinct turnout field semantics reconciliation","sourceUrl":"https://www.elections.alaska.gov/results/24GENR/ENRbyPrecinct.csv","localFile":"data/ak-2024-enr-turnout-semantics.json","level":"precinct_or_reporting_unit","parserHint":"Run node scripts/report-ak-enr-turnout-semantics.mjs. De-duplicated reporting-unit Reg_voters sums to 611,078 and total_ballots sums to 340,981; keep as semantics evidence only until replacement rules are reviewed."},"officialSourceRequestPacket":{"sourceTitle":"Alaska 2024 official source request packet","sourceUrl":"https://www.elections.alaska.gov/election-results/e/?id=24genr","localFile":"data/ak-2024-official-source-request-packet.json","parserHint":"Request packet for U.S. House write-in allocation, geometry/crosswalk, ENR turnout semantics, historical baselines, CVR, audit, recount, incident, correction, and litigation follow-through."}},"requestMatrixArtifact":"data/ak-2024-source-request-matrix.tsv","expected":{"resultRows":1,"stateTotal":338177,"trump":184458,"harris":140026,"other":13693,"localReviewRows":523,"turnoutRows":1}},{"state":"IN","name":"Indiana","priority":1,"currentStatus":"official_county_results_turnout_2012_2016_2020_historical_loaded_supplemental_precinct_review_vstop_audit_summary_loaded_official_enr_public_scan_and_live_recheck_confirm_precinct_rows_missing","completionDecision":{"checkedAt":"2026-07-04","decision":"remain_in_source_discovery_queue","reason":"Indiana should remain in sourceDiscoveryQueue rather than completedNativeStates because official public ENR artifacts provide county President and U.S. Senate rows only, collected JurR county JSON files do not contain President or U.S. Senate candidate rows, and data/in-2024-official-enr-public-data-inventory.json confirms the public ENR app download/data path does not expose a same-grain precinct/subcounty President or U.S. Senate candidate export. A July 4, 2026 ordinary public-path recheck returned HTTP 200 for settings.json, OffCatC_1019_A.json, OffCatC_1006_A.json, and statewideTurnout_A.json, but still found no precinct/subcounty candidate export. Subcounty advisory flags still depend on supplemental MIT/OpenElections precinct rows with upstream caveats. County results, county turnout, official historical baselines, and VSTOP audit-summary context are loaded, but official same-grain precinct/subcounty President and U.S. Senate rows remain the local-review blocker."},"officialSourcePages":["https://web.archive.org/web/20241229230948id_/https://enr.indianavoters.in.gov/site/data/OffCatC_1019_A.json","https://web.archive.org/web/20241229230948id_/https://enr.indianavoters.in.gov/site/data/OffCatC_1006_A.json","https://web.archive.org/cdx?url=enr.indianavoters.in.gov/site/data/JurR_*_B.json&from=20241101&to=20250131&output=json","https://enr.indianavoters.in.gov/archive/2024General/index.html","https://web.archive.org/cdx?url=enr.indianavoters.in.gov/archive/2024General/data/JurR_*_B.json&from=20241101&to=20250131&output=json","https://enr.indianavoters.in.gov/archive/2024General/Scripts/EnrAngular/Directives/enrDownloadResults.js","https://www.in.gov/sos/elections/voter-information/files/2024-General-Election-Turnout-and-Registration-Report.pdf","https://www.in.gov/sos/elections/election-commission/election-results/","https://www.in.gov/sos/elections/statistics-and-maps/","https://www.in.gov/sos/elections/indiana-recount-commission/","https://enr.indianavoters.in.gov/archive/2016General/data/OffCatC_1767_A.json","https://enr.indianavoters.in.gov/archive/2020General/data/OffCatC_1019_A.json","https://indianavoters.in.gov/ENRHistorical/ElectionResults?year=2012","https://www.in.gov/sos/elections/vstop/vstop-post-election-risk-limiting-audit-reports","https://www.in.gov/sos/elections/election-administrators-portal/"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. Senate; official ENR supports certified county totals, and MIT/OpenElections supplemental rows support local President-vs-U.S.-Senate advisory review.","parserNeeded":"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.","blocker":"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.","supplementalSourcePages":["https://doi.org/10.7910/DVN/NYTPDU","https://github.com/openelections/openelections-data-in/tree/master/2024/counties"],"availableArtifacts":{"presidentialCountyResults":{"sourceTitle":"Indiana Election Division archived 2024 General ENR President county JSON","sourceUrl":"https://web.archive.org/web/20241229230948id_/https://enr.indianavoters.in.gov/site/data/OffCatC_1019_A.json","localFile":"data/in-2024-official-results/OffCatC_1019_A.json","parserHint":"indianaEnrCountyJson aggregates RegionSummary candidate rows by county."},"countyComparisonRows":{"sourceTitle":"Indiana Election Division archived 2024 General ENR U.S. Senate county JSON","sourceUrl":"https://web.archive.org/web/20241229230948id_/https://enr.indianavoters.in.gov/site/data/OffCatC_1006_A.json","localFile":"data/in-2024-official-results/OffCatC_1006_A.json","level":"county","comparisonContest":"U.S. Senate","parserHint":"indianaEnrCountyJson comparisonFile loads RegionSummary candidate rows by county."},"localReviewRows":{"sourceTitle":"MIT Election Data and Science Lab supplemental Indiana precinct rows","sourceUrl":"https://doi.org/10.7910/DVN/NYTPDU","localFile":"data/in-2024-mit-local-review.csv","level":"precinct_supplemental","comparisonContest":"U.S. Senate","parserHint":"localComparisonCsv; supplemental advisory rows only until official same-grain rows are obtained."},"turnout":{"sourceTitle":"Indiana Election Division 2024 General Election Turnout and Registration report","sourceUrl":"https://www.in.gov/sos/elections/voter-information/files/2024-General-Election-Turnout-and-Registration-Report.pdf","localFile":"data/in-2024-general-turnout.csv","level":"county","denominator":"Registered Voters","ballotsCast":"Voters Voting","parserHint":"Run node scripts/normalize-in-turnout.mjs after replacing data/in-2024-general-turnout-report.pdf."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2718%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/in-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Indiana 2024 data coverage inventory","localFile":"data/in-2024-data-coverage-inventory.json; data/in-2024-official-enr-public-data-inventory.json; data/source-records-request-packets/in-2024-precinct-results-request.md; data/in-2024-county-request-routing.csv; data/in-2024-county-request-routing-summary.json; data/in-statewide-precinct-counts-2023.pdf","parserHint":"Source-search inventories only; not vote parsers. The ENR public-data inventory records the official app data path and confirms no public same-grain subcounty President/Senate export in retained ENR JSON."},"historicalBaseline":{"sourceTitle":"Indiana Election Division official county presidential historical baselines","sourceUrl":"https://indianavoters.in.gov/ENRHistorical/ElectionResults?year=2012","localFile":"data/in-2012-official-president-county.json; data/in-2016-official-president-county.json; data/in-2020-official-president-county.json; data/in-historical-presidential-baseline.csv","parserHint":"Run node scripts/collect-in-historical-baseline.mjs to regenerate 276 official county presidential baseline rows for 2012, 2016, and 2020."},"auditContext":{"sourceTitle":"Indiana VSTOP 2024 General Election Post-Election Audit Summary Report","sourceUrl":"https://www.in.gov/sos/elections/files/2024-General-Post-Election-Audit-Summary-Report-Final.pdf","localFile":"data/in-2024-general-post-election-audit-summary-report.pdf; data/in-2024-general-post-election-audit-summary.csv; data/in-2024-general-post-election-audit-summary.json","parserHint":"scripts/normalize-in-audit-summary.mjs extracts seven county audit-summary context rows. Context only; not a certified-result replacement and not proof of fraud or misconduct."},"requestRouting":{"sourceTitle":"Indiana county custodian request routing tracker","sourceUrl":"https://www.in.gov/sos/elections/files/StatewideCountsofPrecincts-and-PrecinctSplits.9.21.23new.pdf","localFile":"data/in-2024-county-request-routing.csv; data/in-2024-county-request-routing-summary.json; data/in-statewide-precinct-counts-2023.pdf; data/in-2024-enr-jurisdiction-reports","parserHint":"scripts/build-in-request-routing.mjs pairs official ENR JurR office/contact fields with official county precinct/split counts. Tracker only; not candidate result rows."}}},{"state":"IA","name":"Iowa","priority":2,"currentStatus":"official_precinct_review_turnout_package_collected_vote_method_geometry_audit_leads_documented","officialSourcePages":["https://electionresults.iowa.gov/IA/122322/web.345435/","https://electionresults.iowa.gov/IA/122322/current_ver.txt","https://sos.iowa.gov/iowans/election-results-statistics","https://sos.iowa.gov/shapefiles-county-precincts","https://sos.iowa.gov/precinct-and-district-shapefiles","https://sos.iowa.gov/sites/default/files/2025-02/2024PrecinctAudits.png","https://www.legis.iowa.gov/docs/code/50.51.pdf","https://www.legis.iowa.gov/docs/code/50.48.pdf","https://www.legis.iowa.gov/docs/code/50.50.pdf","https://sos.iowa.gov/elections/auditors/official-directory"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. House by district; loaded from official county detail XML reports as precinct-level President-vs-U.S.-House review rows.","parserNeeded":"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.","blocker":"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.","availableArtifacts":{"presidentialCountyResults":{"sourceTitle":"Iowa Secretary of State official county detail XML reports","sourceUrl":"https://electionresults.iowa.gov/IA/122322/web.345435/","localFile":"data/ia-2024-county-detailxml-reports","parserHint":"iowaClarityCountyDetailXmlDirectory aggregates President and Vice President Choice/VoteType rows by county."},"localReviewRows":{"sourceTitle":"Iowa Secretary of State official county detail XML reports","sourceUrl":"https://electionresults.iowa.gov/IA/122322/web.345435/","localFile":"data/ia-2024-county-detailxml-reports","level":"precinct","comparisonContest":"U.S. House by district","parserHint":"Pair President and United States Representative precinct rows by county and precinct name; keep district-based comparison caveat visible."},"turnout":{"sourceTitle":"Iowa Secretary of State county detail XML VoterTurnout rows","sourceUrl":"https://electionresults.iowa.gov/IA/122322/web.345435/","localFile":"data/ia-2024-county-detailxml-reports","level":"precinct","denominator":"VoterTurnout Precinct totalVoters","parserHint":"Loaded by iowaClarityCountyDetailXmlDirectory; ballotsCast is election-level turnout, not presidential contest votes."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2719%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ia-counties.geojson","parserHint":"County map joins only; official SOS precinct shapefile ZIPs are source leads and are not yet normalized."},"voteMethodLead":{"sourceTitle":"Iowa Secretary of State Clarity VoteType rows","sourceUrl":"https://electionresults.iowa.gov/IA/122322/web.345435/","localFile":"data/ia-2024-county-detailxml-reports","parserHint":"Candidate-by-method source lead only; needs a dedicated normalizer and public caveat before vote-method API/UI publication."},"precinctGeometryLead":{"sourceTitle":"Iowa Secretary of State county precinct shapefile index","sourceUrl":"https://sos.iowa.gov/shapefiles-county-precincts","localFile":"data/ia-2024-data-coverage-inventory.json","parserHint":"Source lead only; collect ZIPs, normalize geometry, and crosswalk to Clarity precinct names before use."},"auditLead":{"sourceTitle":"Iowa SOS 2024 General Election County Precinct Audits image","sourceUrl":"https://sos.iowa.gov/sites/default/files/2025-02/2024PrecinctAudits.png","localFile":"data/ia-2024-data-coverage-inventory.json","parserHint":"Source lead only; scripted download returned Cloudflare challenge and no audit outcome rows are normalized."},"historicalBaseline":{"sourceTitle":"Secondary Iowa county presidential baseline with official SOS replacement leads documented","sourceUrl":"https://sos.iowa.gov/iowans/election-results-statistics","localFile":"data/ia-historical-presidential-baseline.csv; data/ia-2024-data-coverage-inventory.json","parserHint":"historicalPresidentialCsv currently loads 297 contextual rows for 2012/2016/2020. Replace only after official Iowa SOS historical county presidential artifacts are collected and parsed."},"adminSourceInventory":{"sourceTitle":"Iowa 2024 data coverage and administration source inventory","sourceUrl":"https://sos.iowa.gov/iowans/election-results-statistics","localFile":"data/ia-2024-data-coverage-inventory.json","parserHint":"Documents vote-method feasibility, geometry leads, audit source lead, historical replacement leads, and recount/CVR/incident/correction/litigation request paths."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Iowa 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/19","localFile":"data/verifiedvoting-ia-2024-equipment.json; data/ia-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit, incidents, or precinct-uniformity proof."}}},{"state":"KY","name":"Kentucky","priority":3,"currentStatus":"official_precinct_review_package_collected_historical_loaded_state_turnout_leads_reconciled_admin_inventory_documented","officialSourcePages":["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/Resources/Pages/County-Election-Plans.aspx","https://elect.ky.gov/About-Us/Pages/County-Clerks.aspx","https://elect.ky.gov/SiteCollectionDocuments/Election%20Results/2010-2019/2012/2012genresults.pdf","https://elect.ky.gov/results/2010-2019/Documents/2016%20General%20Election%20Results.pdf","https://elect.ky.gov/results/2020-2029/Documents/2020%20General%20Election%20Results.pdf"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. House by district; loaded as precinct-level President-versus-U.S.-House review rows where the county recap PDF includes both contests.","parserNeeded":"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.","blocker":"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.","availableArtifacts":{"presidentialCountyResults":{"sourceTitle":"Kentucky State Board of Elections 2024 General Recap Sheets","sourceUrl":"https://elect.ky.gov/results/2020-2029/Pages/2024General-Recap-Sheets.aspx","localFile":"data/ky-2024-general-recap-sheets; data/ky-2024-general-recap-text","parserHint":"kentuckyGeneralRecapTextDirectory extracts county President totals and precinct President rows from official county recap text artifacts."},"localReviewRows":{"sourceTitle":"Kentucky State Board of Elections 2024 General Recap Sheets","sourceUrl":"https://elect.ky.gov/results/2020-2029/Pages/2024General-Recap-Sheets.aspx","localFile":"data/ky-2024-general-recap-text","level":"precinct","comparisonContest":"U.S. House by district","parserHint":"Compare President rows with United States Representative rows at county/precinct grain where both contests are present; keep one-sided and county-only caveats visible."},"turnout":{"sourceTitle":"EAC fallback plus Kentucky State Board turnout/registration PDF leads","sourceUrl":"https://elect.ky.gov/Resources/Pages/Turnout.aspx","localFile":"data/eac-2024-state-turnout/ky-2024-eac-turnout.csv; data/ky-2024-general-turnout-by-county.pdf; data/ky-2024-general-registration-by-county.pdf; data/ky-2024-turnout-registration-reconciliation.csv; data/ky-2024-turnout-registration-reconciliation-summary.json; data/ky-2024-general-turnout-by-precinct.pdf; data/ky-2024-general-registration-by-precinct.pdf","level":"county_and_precinct_lead","denominator":"EAC fallback currently active; Kentucky State Board registration PDFs collected as candidate denominators","parserHint":"Current ETL uses eacTurnoutCsv. Run npm run etl:reconcile:ky:turnout to regenerate the county State Board turnout/registration versus EAC fallback reconciliation; keep EAC active until county-clerk official documentation and replacement semantics are reviewed."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2721%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ky-counties.geojson","parserHint":"County map joins only; precinct boundaries are not included."},"adminSourceInventory":{"sourceTitle":"Kentucky 2024 data coverage and administration source inventory","sourceUrl":"https://elect.ky.gov/results/Pages/default.aspx","localFile":"data/ky-2024-data-coverage-inventory.json","parserHint":"Documents loaded artifacts, State Board turnout/registration leads, county-clerk request paths, precinct geometry gaps, and audit/recount/CVR/incident/correction blockers."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Kentucky 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/21","localFile":"data/verifiedvoting-ky-2024-equipment.json; data/ky-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit, incidents, or precinct-uniformity proof."}}},{"state":"MS","name":"Mississippi","priority":4,"currentStatus":"official_county_review_historical_turnout_denominator_summary_collected","officialSourcePages":["https://www.sos.ms.gov/elections-voting/election-results/2024/2024-general-election-results","https://www.sos.ms.gov/elections/electionresults/2024ElectionRecapSheets.csv","https://www.sos.ms.gov/elections/electionresults/2024%20Official%20Statewide%20Results.pdf","https://sos.ms.gov/elections/electionresults_aspx/elections_results_2024_county.aspx","https://www.sos.ms.gov/elections-voting/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"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. Senate","parserNeeded":"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.","blocker":"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.","requestMatrixArtifact":"data/ms-2024-source-request-matrix.tsv","availableArtifacts":{"coverageInventory":{"sourceTitle":"Mississippi 2024 data coverage inventory","sourceUrl":"https://www.sos.ms.gov/elections-voting/election-results/2024/2024-general-election-results","localFile":"data/ms-2024-data-coverage-inventory.json","parserHint":"Documents loaded official county result/review rows, EAC fallback turnout, the SOS active-voter denominator lead and generated EAC comparison summary, OCR gate counts, loaded historical baselines, request fields, display paths, and remaining administration-context gaps. Inventory only; no production promotion or normalized administration rows."}}},{"state":"MO","name":"Missouri","priority":5,"currentStatus":"official_county_review_turnout_historical_package_collected_precinct_file_purchase_blocker","officialSourcePages":["https://www.sos.mo.gov/elections/results","https://www.sos.mo.gov/CMSImages/ElectionResultsStatistics/2024GeneralElection.pdf","https://www.sos.mo.gov/CMSImages/ElectionResultsStatistics/ActualResults-November52024.pdf","https://www.sos.mo.gov/elections/security","https://www.sos.mo.gov/elections/qualsystems","https://www.sos.mo.gov/elections/elections_integrity","https://www.sos.mo.gov/CMSImages/ElectionGoVoteMissouri/CurrentElectionLawBook.pdf"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. Senate","parserNeeded":"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","blocker":"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."},{"state":"NE","name":"Nebraska","priority":7,"currentStatus":"official_county_review_historical_admin_inventory_collected_precinct_path_blocked","officialSourcePages":["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"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. Senate","parserNeeded":"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.","blocker":"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.","availableArtifacts":{"presidentialCountyResults":{"sourceTitle":"Nebraska SOS 2024 General Canvass Book","sourceUrl":"https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","localFile":"data/ne-2024-general-canvass-president.csv","parserHint":"countyPresidentCsv normalized from canvass pages 11-12"},"localReviewRows":{"sourceTitle":"Nebraska SOS 2024 General Canvass Book U.S. Senate two-year special county rows","sourceUrl":"https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","localFile":"data/ne-2024-general-canvass-senate-two-year.csv","level":"county","comparisonContest":"U.S. Senate two-year special election","parserHint":"countyComparisonCsv normalized from canvass page 17"},"turnout":{"sourceTitle":"EAC fallback turnout plus generated Nebraska post-general eligible-voter and canvass reconciliation cross-checks","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ne-2024-eac-turnout.csv; data/ne-2024-general-canvass-book.pdf; data/ne-2024-post-general-eligible-voter-report.pdf; data/ne-2024-canvass-voting-statistics-reconciliation.csv; data/ne-2024-canvass-voting-statistics-reconciliation-summary.json","level":"county","denominator":"EAC registered voters for loaded rows; Nebraska canvass and post-general reports retained as state-native cross-checks","parserHint":"Loaded ETL uses eacTurnoutCsv. Run npm run etl:reconcile:ne:turnout to regenerate the Nebraska canvass voting-statistics reconciliation; review the 91-vote canvass-minus-EAC ballots difference before replacing fallback rows."},"historicalBaseline":{"sourceTitle":"Nebraska SOS historical General Canvass Books","sourceUrl":"https://sos.nebraska.gov/previous-elections","localFile":"data/ne-2012-general-canvass-book.pdf; data/ne-2016-general-canvass-book.pdf; data/ne-2020-general-canvass-book.pdf; data/ne-historical-presidential-baseline.csv","parserHint":"Run node scripts/normalize-ne-historical-baseline.mjs to regenerate 279 county presidential baseline rows for 2012, 2016, and 2020"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2731%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ne-counties.geojson","parserHint":"County map joins only; precinct/subcounty boundaries are not included."},"adminSourceInventory":{"sourceTitle":"Nebraska 2024 administration, turnout, geometry, and request-path inventory","sourceUrl":"https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","localFile":"data/ne-2024-admin-source-inventory.json","parserHint":"Documents canvass Reported Problems, canvass voting statistics, voter-file/county request paths, equipment context caveats, and audit/recount/CVR/litigation gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Nebraska 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/31","localFile":"data/ne-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, or proof of precinct-uniform equipment."}}},{"state":"NV","name":"Nevada","priority":8,"currentStatus":"partial_clark_washoe_humboldt_precinct_review_loaded_wave24_request_packets_added","officialSourcePages":["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"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. Senate","parserNeeded":"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.","blocker":"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.","requestMatrixArtifact":"data/nv-2024-county-source-request-matrix.tsv","requestPacketArtifact":"data/nv-2024-non-clark-county-request-packets.json"},{"state":"NH","name":"New Hampshire","priority":9,"currentStatus":"official_town_ward_review_turnout_package_collected_historical_admin_inventory_expanded","requestMatrixArtifact":"data/nh-2024-source-request-matrix.tsv","officialSourcePages":["https://www.sos.nh.gov/2024-general-election-results","https://web.archive.org/web/20260130123951id_/https://www.sos.nh.gov/2024-general-election-results","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/20241219172754id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-governor_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/20250201102742id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-congressional-district-2_4.xlsx","https://web.archive.org/web/20250611055417id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-ballots-cast_14.xls","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://web.archive.org/web/20240720085755id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2016-ge-congressional-district-2.xlsx"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. House, loaded from official Congressional District 1 and 2 town/ward workbooks; keep district-based comparison caveat visible.","parserNeeded":"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.","blocker":"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."},{"state":"NY","name":"New York","priority":10,"currentStatus":"official_county_results_historical_partial_local_review_monroe_loaded_eac_turnout_admin_context_inventory_oswego_lead_wave25","completionDecision":{"checkedAt":"2026-07-04","decision":"remain_in_source_discovery_queue","reason":"NY should remain in sourceDiscoveryQueue rather than completedNativeStates because local review rows are still partial supplemental/official coverage, 12 county equivalents remain outside normalized review coverage, active turnout is still EAC fallback, and precinct/election-district geometry plus normalized audit/CVR/incident/recount/litigation rows are not loaded. Wave 25 added official-path evidence and found an official Oswego County 2024 General PDF/Excel result lead, but no Oswego rows are loaded until the file is collected, parsed, and reconciled."},"officialSourcePages":["https://elections.ny.gov/election-results","https://results.elections.ny.gov/","https://results.elections.ny.gov/document/476","https://results.elections.ny.gov/contest/5591","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://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://elections.ny.gov/voting-technology","https://www.oswegocountyny.gov/government/board_of_elections/elections.php"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. Senate","parserNeeded":"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.","blocker":"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.","availableArtifacts":{"presidentialCountyResults":{"sourceTitle":"New York State Board of Elections official 2024 general election results PDF","sourceUrl":"https://results.elections.ny.gov/document/476","localFile":"data/ny-2024-general-president.csv; data/ny-2024-presidential-general.pdf","parserHint":"countyPresidentCsv extracted from official archive document 476; county-certified rows remain the map authority."},"countyComparisonRows":{"sourceTitle":"New York State Board of Elections official 2024 U.S. Senate county rows","sourceUrl":"https://results.elections.ny.gov/document/476","localFile":"data/ny-2024-general-senate.csv","level":"county","comparisonContest":"U.S. Senate","parserHint":"countyComparisonCsv extracted from the same official archive PDF as President."},"localReviewRows":{"sourceTitle":"OpenElections 2024 New York county-board source collection plus legacy NYC rows","sourceUrl":"https://github.com/openelections/openelections-sources-ny/tree/master/2024/general","localFile":"data/ny-2024-local-review.csv; data/ny-2024-local-review-sources.json","level":"election_district_or_local_unit_partial","comparisonContest":"U.S. Senate","parserHint":"scripts/normalize-ny-local-review.mjs normalizes machine-readable files, selected reviewed text-layer PDFs, Suffolk text rows, reconciled official Monroe County canvass-book detail rows, and legacy NYC rows; data/ny-2024-local-review-sources.json records loaded, zero-row, and excluded source-file statuses, while image-only, president-only, unsupported, or unreviewed counties stay excluded until reviewed."},"turnout":{"sourceTitle":"EAC fallback plus NYSBOE enrollment denominator leads","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ny-2024-eac-turnout.csv; data/eac-2024-state-turnout/ny-2024-eac-registered-voter-denominator.json","level":"county_jurisdiction_fallback","denominator":"EAC registered voters for loaded rows; NYSBOE 11/01/2024 county and election-district enrollment reports are candidate denominator leads","parserHint":"Current ETL uses eacTurnoutCsv. A future New York turnout normalizer should collect ballots-cast or voter-history rows and reconcile them with NYSBOE enrollment denominators before replacing fallback rows."},"historicalBaseline":{"sourceTitle":"New York State Board of Elections official historical general-election PDFs","sourceUrl":"https://elections.ny.gov/election-results","localFile":"data/ny-2012-general.pdf; data/ny-2016-general.pdf; data/ny-2020-general.pdf; data/ny-historical-presidential-baseline.csv","parserHint":"Run node scripts/collect-ny-historical-baseline.mjs to regenerate 186 official county presidential baseline rows for 2012, 2016, and 2020."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2736%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ny-counties.geojson","parserHint":"County map joins only; precinct/election-district boundaries are not included."},"coverageInventory":{"sourceTitle":"New York 2024 data coverage and administration source inventory","sourceUrl":"https://elections.ny.gov/flateau-database","localFile":"data/ny-2024-data-coverage-inventory.json; data/ny-2024-source-request-matrix.tsv; data/ny-2024-missing-county-request-packets.json; data/ny-2024-wave25-official-path-checks.json","parserHint":"Documents excluded local review counties, state-native turnout denominator leads, Flateau/VEDA future local data path and Wave 21 export-readiness blocker, county-board request paths, audit/CVR/incident/recount/litigation blockers, display caveats, and the Wave 21 request matrix. Wave 22 adds county-specific missing-local-review request packets with source-lead statuses for unreviewed PDFs, president-only workbooks, zero-row workbooks, and no-manifest-source counties. Wave 24 reconciles Monroe official county canvass/certification artifacts and loads 655 local review rows; remaining county request packets cover 12 county equivalents. Wave 25 adds official-path evidence and an Oswego public official result lead that remains not loaded pending ordinary collection, inspection, and reconciliation."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier New York 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/36","localFile":"data/verifiedvoting-ny-2024-equipment.json; data/ny-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit, incidents, or proof of precinct-uniform equipment."},"monroePacketFollowThrough":{"sourceTitle":"Monroe County Board of Elections 2024 General canvass-book detail, certification, reconciliation, and turnout-lead PDFs","sourceUrl":"https://www.monroecounty.gov/elections-results","localFile":"data/ny-2024-monroe-canvass-book.pdf; data/ny-2024-monroe-general-certification.pdf; data/ny-2024-monroe-reconciliation-summary.json; data/ny-2024-monroe-general-voter-turnout-v2.pdf","level":"legislative_district_or_town_by_election_district_detail","parserHint":"Loaded through scripts/ny-monroe-official-detail.mjs after detail rows reconciled to the November 26, 2024 certification and active NY county totals. Turnout v2 PDF is retained as a county-specific lead only; active NY turnout remains EAC fallback."},"wave25OfficialPathChecks":{"sourceTitle":"New York Wave 25 official county path and request evidence","sourceUrl":"https://publicreporting.elections.ny.gov/CountyBoardRoster/CountyBoardRoster","localFile":"data/ny-2024-wave25-official-path-checks.json","level":"county_request_path_and_public_official_source_lead","parserHint":"Evidence-only source artifact. Oswego has a public official 2024 General PDF/Excel lead; collect and reconcile before loading local rows."}},"requestMatrixArtifact":"data/ny-2024-source-request-matrix.tsv","requestPacketArtifact":"data/ny-2024-missing-county-request-packets.json"},{"state":"WV","name":"West Virginia","priority":12,"currentStatus":"official_precinct_review_turnout_package_collected_admin_context_inventory_expanded","officialSourcePages":["https://results.enr.clarityelections.com/WV/122766/web.345435/","https://results.enr.clarityelections.com/WV/122766/current_ver.txt","https://sos.wv.gov/elections/Pages/ElectionSecurity.aspx","https://sos.wv.gov/elections/Pages/VoteRegTotals.aspx","https://sos.wv.gov/elections/Pages/HistElecResults.aspx","https://sos.wv.gov/elections/Pages/Guidance.aspx","https://sos.wv.gov/FormSearch/Elections/Informational/Canvassing%20Manual.pdf","https://sos.wv.gov/FormSearch/Elections/Informational/Recount%20Manual.pdf","https://sos.wv.gov/FormSearch/Elections/Complaint_Challenge/ElectionsComplaintForm.pdf","https://sos.wv.gov/about/Pages/FOIAReq.aspx","https://sos.wv.gov/FormSearch/Elections/Informational/Voter%20Data%20Request.pdf","https://sos.wv.gov/west-virginia-county-clerk-directory"],"requiredArtifacts":["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"],"preferredComparisonContest":"U.S. Senate; loaded from official county detail XML reports as precinct-level President-vs-U.S.-Senate review rows.","parserNeeded":"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.","blocker":"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.","availableArtifacts":{"presidentialCountyResults":{"sourceTitle":"West Virginia SOS official county detail XML reports","sourceUrl":"https://results.enr.clarityelections.com/WV/122766/web.345435/","localFile":"data/wv-2024-county-detailxml-reports","parserHint":"Aggregate U.S. PRESIDENT precinct Choice/VoteType rows by county."},"localReviewRows":{"sourceTitle":"West Virginia SOS official county detail XML reports","sourceUrl":"https://results.enr.clarityelections.com/WV/122766/web.345435/","localFile":"data/wv-2024-county-detailxml-reports","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"Pair U.S. PRESIDENT and U.S. SENATOR precinct Choice/VoteType rows by county and precinct name."},"turnout":{"sourceTitle":"West Virginia SOS county detail XML VoterTurnout rows","sourceUrl":"https://results.enr.clarityelections.com/WV/122766/web.345435/","localFile":"data/wv-2024-county-detailxml-reports","level":"precinct","denominator":"VoterTurnout Precinct totalVoters","ballotsCast":"VoterTurnout Precinct ballotsCast"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2754%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/wv-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"West Virginia 2024 data coverage and administration source inventory","sourceUrl":"https://sos.wv.gov/elections/Pages/HistElecResults.aspx","localFile":"data/wv-2024-data-coverage-inventory.json","parserHint":"Documents loaded result/review/turnout/equipment artifacts, official SOS/county request paths for precinct geometry, audit/CVR/recount/incident/correction/litigation records, historical-source leads, and display caveats. Inventory only; no normalized administration rows are loaded."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier West Virginia 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/54","localFile":"data/wv-2024-equipment-context.csv","parserHint":"Context only; do not use for votes or turnout."}}},{"state":"SD","name":"South Dakota","priority":20,"currentStatus":"secondary_county_staging_rows_with_official_archive_evidence_certified_canvass_still_required","completionDecision":{"checkedAt":"2026-07-04","decision":"remain_in_source_discovery_queue","reason":"SD should remain outside completedNativeStates because the active President and U.S. House county rows are still generated from secondary Wikipedia county tables that cite the South Dakota Secretary of State 2024 General Election Canvass and Certificate. Wave 24 retained a stronger official request packet and audit-page context, but the official SD SOS ElectionID 684 statewide XLSX export is labeled unofficial and matches the lower archive map-data totals: 194 President votes and 184 U.S. House votes below the current certified-style staging totals. The official certified canvass/static export or a reconciling official payload, state-native turnout replacement review, precinct/local rows, precinct geometry, and normalized administration-context records remain unresolved."},"officialSourcePages":["https://sdsos.gov/elections-voting/election-resources/election-results/default.aspx","https://electionresults.sd.gov/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://vip.sdsos.gov/CountyAuditors.aspx","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"],"requiredArtifacts":["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"],"preferredComparisonContest":"United States Representative; current staging pairs county President with at-large U.S. House rows, with county-level and secondary-source caveats.","parserNeeded":"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.","blocker":"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.","availableArtifacts":{"presidentialCountyResults":{"sourceTitle":"Wikipedia 2024 South Dakota presidential county table citing SD SOS canvass","sourceUrl":"https://en.wikipedia.org/wiki/2024_United_States_presidential_election_in_South_Dakota","localFile":"data/sd-2024-general-president-county.csv","parserHint":"Generated by scripts/collect-sd-2024-county-results.mjs; replace with official SD SOS canvass/export parser when collected."},"countyComparisonRows":{"sourceTitle":"Wikipedia 2024 South Dakota U.S. House county table citing SD SOS canvass","sourceUrl":"https://en.wikipedia.org/wiki/2024_United_States_House_of_Representatives_election_in_South_Dakota","localFile":"data/sd-2024-general-us-house-county.csv","level":"county","comparisonContest":"United States Representative","parserHint":"Generated by scripts/collect-sd-2024-county-results.mjs as countyComparisonCsv staging context."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback plus SD SOS archive turnout lead","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports; https://sdresws.azurewebsites.net/ResultsAjax.svc/GetVoterTurnoutArchive?ElectionID=684","localFile":"data/eac-2024-state-turnout/sd-2024-eac-turnout.csv; data/sd-2024-official-results-archive-evidence.json","level":"jurisdiction_fallback_active_county_archive_lead_collected","denominator":"Active ETL uses EAC A1a Total Reg registered voters. The ElectionID 684 archive turnout Voters field is retained as a state-native denominator lead only.","ballotsCast":"Active ETL uses EAC normalized ballots cast. The ElectionID 684 archive calcVoterTurnout field totals 436,478 ballots cast and is not active until replacement semantics are reviewed."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2746%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/sd-counties.geojson"},"coverageInventory":{"sourceTitle":"South Dakota 2024 data coverage and source request inventory","localFile":"data/sd-2024-data-coverage-inventory.json; data/sd-2024-source-request-matrix.tsv"},"equipmentContext":{"sourceTitle":"Verified Voting Verifier South Dakota 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/46","localFile":"data/sd-2024-equipment-context.csv"},"officialArchiveEvidence":{"sourceTitle":"South Dakota Secretary of State 2024 General Election archive evidence","sourceUrl":"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","localFile":"data/sd-2024-official-results-archive-evidence.json; data/sd-2024-general-statewide-results.xlsx","parserHint":"Generated by scripts/collect-sd-official-archive-evidence.mjs; identifies ElectionID 684, candidate-list IDs 19833/19835, map RaceIDs 12665/11954, 66 turnout rows, and a retained Statewide Results.xlsx export. Retain as official-source evidence only until certified reconciliation is resolved."},"officialStatewideExport":{"sourceTitle":"South Dakota Secretary of State 2024 General ElectionID 684 statewide XLSX export","sourceUrl":"https://electionresults.sd.gov/ResultsExport.aspx?eid=684","localFile":"data/sd-2024-general-statewide-results.xlsx","parserHint":"Downloaded by ASP.NET Statewide Export postback in scripts/collect-sd-official-archive-evidence.mjs. The workbook is official app evidence but labels itself unofficial and totals 428,728 President votes and 421,264 U.S. House votes, matching archive map-data rather than certified-style staging totals."},"officialSourceRequestPacket":{"sourceTitle":"South Dakota certified-result reconciliation request packet and official audit-page context","sourceUrl":"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","localFile":"data/sd-2024-official-source-request-packet.json","parserHint":"Generated by scripts/collect-sd-official-archive-evidence.mjs; records the certified-result request ask, public-records and county-auditor targets, five 404 canvass-PDF probes, 66 audit-page county rows, 83 linked audit certificate URLs, and 14 counties with audit discrepancy summary text. Request/evidence packet only, not an active result source."},"postElectionAuditContext":{"sourceTitle":"South Dakota SOS 2024 General post-election audit results page","sourceUrl":"https://sdsos.gov/elections-voting/upcoming-elections/general-information/2024/2024-general-postelection-audit-results.aspx","localFile":"data/sd-2024-official-source-request-packet.json","parserHint":"Retained as official administration context: 66 county rows, 83 linked audit certificates, and 14 counties with discrepancy summary text. Does not include complete certified county President or U.S. House totals."}},"expected":{"countyRows":66,"geometryFeatures":66,"stateTotal":428922,"trump":272081,"harris":146859,"other":9982,"localReviewRows":66,"turnoutRows":66,"historicalBaselineRows":198},"requestMatrixArtifact":"data/sd-2024-source-request-matrix.tsv","requestPacketArtifact":"data/sd-2024-official-source-request-packet.json"}],"states":[{"state":"AL","name":"Alabama","priority":0,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_historical_context","authority":"Alabama Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/al.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Alabama Secretary of State 2024 General Precinct Level Results ZIP","sourceUrl":"https://www.sos.alabama.gov/sites/default/files/election-data/2024-12/2024-General%20Precinct%20Level%20Results.zip","localFile":"data/al-2024-general-precinct-level-results.zip; data/al-2024-general-president.csv","parserHint":"Run npm run etl:prepare:al. scripts/normalize-al-sos-results.mjs unzips 67 county XLS matrices and writes county President rows to data/al-2024-general-president.csv."},"localReviewRows":{"sourceTitle":"Alabama Secretary of State 2024 General Precinct Level Results ZIP","sourceUrl":"https://www.sos.alabama.gov/sites/default/files/election-data/2024-12/2024-General%20Precinct%20Level%20Results.zip","localFile":"data/al-2024-local-review.csv","level":"precinct_reporting_mode_column","comparisonContest":"U.S. House","parserHint":"Generated from the same official ZIP. President and U.S. House rows are paired for county XLS columns with explicit nonzero House coverage; U.S. House is district-based and no 2024 AL U.S. Senate race existed."},"turnout":{"sourceTitle":"EAC fallback plus Alabama SOS turnout/registration leads","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/al-2024-eac-turnout.csv; data/al-2024-general-total-ballots-cast.pdf; data/al-2024-registered-voters.xlsx; data/al-2024-turnout-denominator-lead.csv","level":"jurisdiction_fallback_active_county_lead_collected","denominator":"Active ETL uses EAC registered voters. The ALVR November active-voter workbook is retained as a state-native denominator lead only.","parserHint":"Current ETL uses eacTurnoutCsv. The generated turnout lead pairs precinct-ZIP ballots-cast rows with November ALVR active voters but is not active until SOS PDF/ALVR denominator timing is reconciled."},"historicalBaseline":{"sourceTitle":"Alabama Secretary of State official 2012/2016/2020 presidential artifacts","sourceUrl":"https://www.sos.alabama.gov/alabama-votes/voter/election-data","localFile":"data/al-president-general-1976-2012.xls; data/al-2016-general-precinct-level.zip; data/al-2020-general-precinct-results.zip; data/al-historical-presidential-baseline.csv","parserHint":"scripts/normalize-al-sos-results.mjs writes 201 county historical presidential rows from official SOS artifacts."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2701%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/al-counties.geojson","parserHint":"County map joins only; precinct geometry/crosswalks are not loaded."},"coverageInventory":{"sourceTitle":"Alabama 2024 data coverage and administration source inventory","sourceUrl":"https://www.sos.alabama.gov/alabama-votes/voter/election-data","localFile":"data/al-2024-data-coverage-inventory.json","parserHint":"Documents loaded official artifacts and remaining turnout replacement, precinct geometry, audit, CVR, recount, incident, correction, and litigation gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Alabama 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/1","localFile":"data/al-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."}},"expected":{"countyRows":67,"geometryFeatures":67,"stateTotal":2265090,"trump":1462616,"harris":772412,"other":30062,"localReviewRows":2083,"turnoutRows":67,"historicalBaselineRows":201},"caveats":["Review rows are official President-versus-U.S.-House pairs, but U.S. House is district-based and should be treated as directional source-review context, not candidate-benefit findings.","Active turnout remains EAC fallback: 67 jurisdiction rows, 2,272,911 ballots cast, and 3,868,040 registered voters. The generated Alabama turnout lead is not active because the precinct-ZIP ballots-cast sum is 2,272,731, 180 lower than the active EAC/SOS fallback total, and ALVR denominator timing needs review.","County geometry is loaded; precinct boundaries/crosswalks are not loaded.","No normalized Alabama audit, CVR availability, recount, incident, correction, or litigation rows are loaded."],"legacyReferenceBundle":"data/al-app-data.js","validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_house_precinct_reporting_mode_columns","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_state_native_leads_collected","historicalMode":"official_sos_county_baseline_context_2012_2016_2020","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized"}},{"state":"AR","name":"Arkansas","priority":13,"nativeReadiness":"complete_county_map_reporting_unit_review_eac_turnout_admin_context_inventory","authority":"Arkansas Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/ar.json","legacyReferenceBundle":"data/ar-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Arkansas Secretary of State TotalResults official federal JSON package","sourceUrl":"https://enr.totalresults.com/arkansas/","localFile":"data/ar-2024-official-results","parserHint":"arkansasTotalResultsFederalJson reads election-info.json, federal-results.json, and manifest.json; aggregate U.S. President contest 366 county locations using Trump choice 789, Harris choice 791, and all other choices as Other."},"localReviewRows":{"sourceTitle":"Arkansas Secretary of State TotalResults county-scoped federal JSON package","sourceUrl":"https://enr.totalresults.com/arkansas/","localFile":"data/ar-2024-official-results","level":"reporting_unit","comparisonContest":"U.S. House","parserHint":"For each manifest federal-county-results file, pair President contest 366 reporting-unit IDs with U.S. House contest IDs 161, 227, 237, and 645; TotalResults exposes stable local IDs but not human-readable precinct names."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ar-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"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","localFile":"data/ar-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Arkansas 2024 data coverage and administration source inventory","localFile":"data/ar-2024-data-coverage-inventory.json","parserHint":"Documents loaded TotalResults/EAC/Census/equipment artifacts and remaining official-source request paths; no normalized administration rows are loaded beyond equipment context."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Arkansas 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/5","localFile":"data/ar-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."}},"expected":{"countyRows":75,"geometryFeatures":75,"stateTotal":1182676,"trump":759241,"harris":396905,"other":26530,"localReviewRows":2779,"turnoutRows":73},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_house_reporting_unit_ids","turnoutMode":"eac_2024_v2_jurisdiction_fallback","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized"},"caveats":["TotalResults county-scoped federal buckets expose reporting-unit IDs but not human-readable precinct names; review charts should label them as reporting units.","U.S. House is district-based and candidate-specific, so advisory screens are directional source-review context rather than candidate-benefit findings.","One presidential reporting-unit row has no same-row U.S. House comparison coverage in the current official package.","Turnout rows use EAC 2024 V2 jurisdiction fallback data until a state-native Arkansas turnout and registration denominator artifact is collected.","County geometry is loaded; precinct or reporting-unit boundary geometry/crosswalks are not loaded.","Equipment context is loaded from Verified Voting as supplemental administration metadata; normalized official audit/recount/CVR/incident/correction/litigation rows are not loaded.","Official 2012, 2016, and 2020 historical baseline rows are not loaded; use the Secretary of State results page or TotalResults archive paths as the next official source lead."]},{"state":"AZ","name":"Arizona","priority":6,"nativeReadiness":"complete_county_map_county_review_state_native_turnout_secondary_historical_baseline_official_historical_review_admin_context_partial","authority":"Arizona Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/az.json","legacyReferenceBundle":"data/az-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Arizona Secretary of State 2024 signed statewide canvass","sourceUrl":"https://apps.azsos.gov/election/2024/ge/canvass/20241105_GeneralCanvass_Signed.pdf","localFile":"data/az-2024-general-canvass-president.csv","parserHint":"arizonaCanvassCountyCsv loads the 15 retained county presidential rows transcribed from the official signed canvass."},"localReviewRows":{"sourceTitle":"Arizona Secretary of State 2024 signed statewide canvass U.S. Senate rows","sourceUrl":"https://apps.azsos.gov/election/2024/ge/canvass/20241105_GeneralCanvass_Signed.pdf","localFile":"data/az-2024-general-canvass-senate.csv","level":"county","comparisonContest":"U.S. Senate","parserHint":"countyComparisonCsv pairs the 15 county presidential and U.S. Senate rows; these are county review inputs, not precinct scatter rows."},"turnout":{"sourceTitle":"Arizona Secretary of State 2024 signed statewide canvass turnout rows","sourceUrl":"https://apps.azsos.gov/election/2024/ge/canvass/20241105_GeneralCanvass_Signed.pdf","localFile":"data/az-2024-general-canvass-president.csv","level":"county","denominator":"Signed-canvass Total Eligible Registration","ballotsCast":"Signed-canvass Total Ballots Cast"},"historicalBaseline":{"sourceTitle":"Secondary Arizona county presidential tables with state-election-source footnotes","sourceUrl":"https://en.wikipedia.org/wiki/2020_United_States_presidential_election_in_Arizona","localFile":"data/az-historical-presidential-baseline.csv","level":"county","parserHint":"historicalPresidentialCsv loads 45 contextual county rows for 2012, 2016, and 2020. This secondary artifact remains contextual pending an official baseline replacement."},"historicalReviewRows":{"sourceTitle":"Arizona Secretary of State official 2016 signed canvass and 2020 detailed election XML","sourceUrl":"https://apps.azsos.gov/election/2016/General/Official%20Signed%20State%20Canvass.pdf","additionalSourceUrls":["https://apps.azsos.gov/election/2020/resultsdetail_2020generalxml.zip"],"localFile":"data/az-2016-general-official-signed-state-canvass.pdf; data/az-2020-general-results-detail.xml.zip; data/az-historical-review-rows.csv; data/az-historical-review-reconciliation.json","level":"county","comparisonContest":"U.S. Senate","parserHint":"Run python scripts/normalize_az_historical_review.py. historicalReviewCsv loads 30 canonical county rows, 15 each for 2016 and 2020. The reconciliation artifact records source hashes, statewide totals, PDF visual QA, and 38 fail-closed corrections for printed one-vote cells missing from the PDF text layer."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2704%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/az-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"}},"expected":{"countyRows":15,"geometryFeatures":15,"stateTotal":3390161,"trump":1770242,"harris":1582860,"other":37059,"localReviewRows":15,"turnoutRows":15,"historicalBaselineRows":45,"historicalReviewRows":30,"historicalReviewRowsByYear":{"2016":15,"2020":15}},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_county","turnoutMode":"official_signed_canvass_total_eligible_registration","historicalMode":"secondary_county_context_2012_2016_2020","historicalReviewMode":"official_azsos_county_president_vs_us_senate_2016_2020"},"caveats":["Current and historical review rows are county-level screening context, not precinct-level evidence.","The official 2016 PDF parser records 38 printed one-vote cells absent from the PDF text layer as reviewed fail-closed corrections; every candidate row reconciles to its printed statewide total.","The official 2016 presidential candidate rows total 2,573,165, while the secondary contextual baseline totals 2,604,657. The 31,492-vote difference is entirely in unresolved other-vote semantics; do not silently replace or combine these totals.","The 2012/2016/2020 presidential baseline remains secondary context pending a reviewed official replacement.","Advisory indicators are review signals only and are not findings of fraud or misconduct."],"blocker":"Remaining Arizona gaps are official precinct/local President and same-grain U.S. Senate rows, precinct geometry/crosswalks, normalized administration records, and a reviewed official replacement for the secondary historical-baseline other-vote semantics."},{"state":"MN","name":"Minnesota","priority":1,"nativeReadiness":"complete_county_map_precinct_review_turnout","authority":"Minnesota Secretary of State","configFile":"etl/state-configs/mn.json","legacyReferenceBundle":"data/mn-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Minnesota SOS official federal/state precinct spreadsheet","sourceUrl":"https://www.sos.mn.gov/media/yt3llxwd/2024-general-federal-state-results-by-precinct-official.xlsx","localFile":"data/mn-2024-general-federal-state-results-by-precinct-official.xlsx","parserHint":"XLSX sheet Precinct-Results; aggregate COUNTYNAME rows using USPRSR, USPRSDFL, USPRSTOTAL, and other USPRS* candidate columns."},"localReviewRows":{"sourceTitle":"Minnesota SOS precinct federal/state spreadsheet","sourceUrl":"https://www.sos.mn.gov/media/yt3llxwd/2024-general-federal-state-results-by-precinct-official.xlsx","localFile":"data/mn-2024-general-federal-state-results-by-precinct-official.xlsx","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"Use COUNTYNAME, MCDNAME, PCTNAME, USPRSR, USPRSDFL, USPRSTOTAL, USSENR, and USSENDFL."},"turnout":{"sourceTitle":"Minnesota SOS precinct voter-stat fields","sourceUrl":"https://www.sos.mn.gov/media/yt3llxwd/2024-general-federal-state-results-by-precinct-official.xlsx","localFile":"data/mn-2024-general-federal-state-results-by-precinct-official.xlsx","level":"precinct","denominator":"REG7AM plus EDR","ballotsCast":"TOTVOTING"},"countyBoundary":{"sourceTitle":"MnGeo county boundary feature service","sourceUrl":"https://feat.gisdata.mn.gov/arcgis/rest/services/MnGeo/mn_counties/FeatureServer/0","localFile":"data/mn-counties.geojson","appReadyFile":"data/mn-counties.js","nameProperty":"county_name","codeProperty":"county_code"}},"expected":{"countyRows":87,"geometryFeatures":87,"stateTotal":3253920,"trump":1519032,"harris":1656979,"other":77909,"localReviewRows":4075,"turnoutRows":4103},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_dropoff","turnoutMode":"precinct_registered_voters_plus_election_day_registrations"},"caveats":["County presidential totals can be aggregated from the precinct workbook; separate official county text files also exist for historical baseline.","Precinct boundary GeoJSON is not present in this package."]},{"state":"MI","name":"Michigan","priority":2,"nativeReadiness":"complete_county_map_precinct_review_county_turnout_secondary_historical_admin_inventory","authority":"Michigan Secretary of State","configFile":"etl/state-configs/mi.json","legacyReferenceBundle":"data/mi-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Michigan MVIC official county result export","sourceUrl":"https://mvic.sos.state.mi.us/VoteHistory/GetElectionResultFile?electionId=699","localFile":"data/mi-2024-general-election-results.txt","parserHint":"Tab-delimited MVIC county export; filter presidential electors contest and aggregate party/candidate rows by county."},"localReviewRows":{"sourceTitle":"Michigan MVIC official precinct result ZIP","sourceUrl":"https://mvic.sos.state.mi.us/VoteHistory/GetPrecinctResultsFile?electionId=699","localFile":"data/mi-2024-precinct-results.zip","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"Join 2024GEN/2024vote.txt to county, city, and candidate lookup tables. President officeCode 1; Senate officeCode 5."},"turnout":{"sourceTitle":"Michigan MVIC turnout export plus voter registration totals","sourceUrl":"https://mvic.sos.state.mi.us/VoteHistory/GetVoterTurnoutFile?electionId=699","localFile":"data/mi-2024-voter-turnout.txt; data/mi-2024-registered-voter-count.pdf","level":"county","denominator":"November active registered voters","ballotsCast":"MVIC county voter turnout export"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer","localFile":"data/mi-counties.geojson","appReadyFile":"data/mi-counties.js","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"Wikipedia Michigan county presidential tables with Michigan SOS result-page citations where available","sourceUrl":"https://en.wikipedia.org/wiki/2020_United_States_presidential_election_in_Michigan","localFile":"data/mi-historical-presidential-baseline.csv","parserHint":"Run node scripts/collect-mi-historical-baseline.mjs to regenerate 249 county presidential baseline rows for 2012, 2016, and 2020; replace with official SOS historical exports if collected."},"adminSourceInventory":{"sourceTitle":"Michigan 2024 administration, geometry, historical-source, and request-path inventory","localFile":"data/mi-2024-admin-source-inventory.json","parserHint":"Documents loaded and missing Michigan administration-context source paths; not normalized audit/CVR/incident rows."}},"expected":{"countyRows":83,"geometryFeatures":83,"stateTotal":5664186,"trump":2816636,"harris":2736533,"other":111017,"localReviewRows":4428,"turnoutRows":83,"historicalBaselineRows":249},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_dropoff","turnoutMode":"county_turnout_joined_to_registration_pdf","historicalBaselineMode":"secondary_wikipedia_county_context","adminInventoryStatus":"source_paths_documented_not_row_level_loaded"},"caveats":["MVIC live download endpoints are browser-protected; local official export artifacts are already stored in the repo.","Turnout is county-level, not precinct-level.","Precinct boundary GeoJSON is not present in this package.","Historical baseline rows are contextual secondary county tables, not official replacement certified totals; official MVIC/mielections historical endpoints were not script-readable from this environment.","Administration source inventory is documented, but normalized audit/recount/CVR/incident/correction rows are not loaded."]},{"state":"PA","name":"Pennsylvania","priority":3,"nativeReadiness":"complete_county_map_precinct_review_county_turnout","authority":"Pennsylvania Department of State","configFile":"etl/state-configs/pa.json","legacyReferenceBundle":"data/pa-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Pennsylvania DOS precinct election returns bulk file","sourceUrl":"https://www.pa.gov/content/dam/copapwp-pagov/en/dos/resources/voting-and-elections/bulk-data/2024-general-election/er/erstat_2024_g_268768_20250129.txt","localFile":"data/pa-2024-general-election-returns-precinct.txt","parserHint":"Comma-delimited DOS precinct returns; filter officeCode USP and aggregate candidate/party rows by county."},"localReviewRows":{"sourceTitle":"Pennsylvania DOS precinct election returns bulk file","sourceUrl":"https://www.pa.gov/content/dam/copapwp-pagov/en/dos/resources/voting-and-elections/bulk-data/2024-general-election/er/erstat_2024_g_268768_20250129.txt","localFile":"data/pa-2024-general-election-returns-precinct.txt","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"Use officeCode USP for President and USS for U.S. Senate; group by county, precinct code, municipality, ward, and precinct breakdown fields."},"turnout":{"sourceTitle":"Pennsylvania DOS vote history and voter registration summary","sourceUrl":"https://www.pa.gov/content/dam/copapwp-pagov/en/dos/resources/voting-and-elections/bulk-data/2024-general-election/voter%20registration%20-%20vote%20history%20summary%20-%202024%20general.xlsx","localFile":"data/pa-2024-voter-registration-vote-history-summary.xlsx","level":"county","denominator":"Registered voters","ballotsCast":"Vote History"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer","localFile":"data/pa-counties.geojson","appReadyFile":"data/pa-counties.js","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaselines":{"sourceTitle":"Pennsylvania DOS historical precinct election returns bulk files","sourceUrl":"https://www.pa.gov/agencies/dos/resources/voting-and-elections-resources/voting-and-election-statistics/election-data","localFile":"data/pa-historical-presidential-baseline.csv","sourceArtifacts":["data/pa-2012-general-election-returns-precinct.txt","data/pa-2012-general-election-returns-readme.txt","data/pa-2016-general-election-returns-precinct.txt","data/pa-2016-general-election-returns-readme.txt","data/pa-2020-general-election-returns-precinct.txt","data/pa-2020-general-election-returns-readme.txt"],"parserHint":"scripts/collect-pa-historical-baseline.mjs aggregates official USP rows to county historicalPresidentialCsv rows.","rows":201,"years":[2012,2016,2020]}},"expected":{"countyRows":67,"geometryFeatures":67,"stateTotal":7031737,"trump":3543041,"harris":3420865,"other":67831,"localReviewRows":9154,"turnoutRows":67},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_dropoff","turnoutMode":"county_vote_history_registration_summary","historicalBaselineMode":"official_dos_bulk_context"},"caveats":["Official readme says the election returns data was extracted January 10, 2025; the direct bulk file name includes 20250129.","Turnout is county-level, not precinct-level.","Precinct boundary GeoJSON is not present in this package.","Historical baselines are official DOS bulk context; bulk rows do not include a separate write-in reconciliation artifact."]},{"state":"WA","name":"Washington","priority":4,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_2016_2020_historical_partial_reconciliation","authority":"Washington Secretary of State","configFile":"etl/state-configs/wa.json","legacyReferenceBundle":"data/wa-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Washington SOS official all-counties CSV export","sourceUrl":"https://results.vote.wa.gov/results/20241105/export/20241105_AllCounties.csv","localFile":"data/wa-2024-all-counties.csv","parserHint":"CSV export; filter United States President/Vice President and aggregate county rows using Kamala D. Harris, Donald J. Trump, and other candidates."},"localReviewRows":{"sourceTitle":"Washington SOS official participating county precinct CSV export","sourceUrl":"https://results.vote.wa.gov/results/20241105/export/20241105_AllStatePrecincts.csv","localFile":"data/wa-2024-all-state-precincts.csv","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"Use Race, CountyCode, PrecinctName, PrecinctCode, Candidate, and Votes for President/Vice President and U.S. Senator."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/wa-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2753%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/wa-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"Washington Secretary of State official 2016 and 2020 all-counties CSV exports","sourceUrl":"https://results.vote.wa.gov/results/20161108/export/20161108_AllCounties.csv; https://results.vote.wa.gov/results/20201103/export/20201103_AllCounties.csv","localFile":"data/wa-2016-all-counties.csv; data/wa-2020-all-counties.csv; data/wa-historical-presidential-baseline.csv","parserHint":"scripts/normalize-wa-historical-presidential-baseline.mjs downloads official all-counties CSV exports and writes 78 historical baseline rows for 2016 and 2020."}},"expected":{"countyRows":39,"geometryFeatures":39,"stateTotal":3924243,"trump":1530923,"harris":2245849,"other":147471,"localReviewRows":5007,"turnoutRows":39,"historicalBaselineRows":78},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_dropoff_participating_precinct_export","turnoutMode":"eac_2024_v2_jurisdiction_fallback","historicalBaselineMode":"official_sos_2016_2020_county_baseline_context","historicalMode":"official_sos_all_counties_csv_context_2016_2020_2012_missing"},"caveats":["County presidential totals reconcile to the official Washington all-state CSV.","The official participating precinct export aggregates to 3,918,934 presidential votes, 5,309 fewer than the certified county presidential total of 3,924,243.","Precinct boundary GeoJSON is not present in this package.","Turnout rows use EAC 2024 V2 jurisdiction fallback data until an equal-or-finer Washington state source is collected.","Official 2016 and 2020 county presidential historical baseline rows are loaded from Washington Secretary of State all-counties CSV exports; official 2012 historical baseline rows are not loaded."]},{"state":"TN","name":"Tennessee","priority":20,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_2016_2020_historical_admin_context_inventory","authority":"Tennessee Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting Verifier","configFile":"etl/state-configs/tn.json","legacyReferenceBundle":"data/tn-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Tennessee Secretary of State 2024 General Election Results by Precinct PDF","sourceUrl":"https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyPrecinct.pdf","localFile":"data/tn-2024-general-by-precinct.pdf; data/tn-2024-general-president-county.csv","parserHint":"Run npm run etl:prepare:tn. scripts/normalize-tn-sos-results.mjs extracts official county totals from the SOS precinct PDF and writes county President rows."},"localReviewRows":{"sourceTitle":"Tennessee Secretary of State 2024 General Election Results by Precinct PDF","sourceUrl":"https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyPrecinct.pdf","localFile":"data/tn-2024-general-president-senate-precinct-review.csv","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"Generated from the same official precinct PDF. The parser pairs President and U.S. Senate rows by county and precinct label and reconciles 1,862 same-key source rows with no missing comparison keys; three zero-vote rows are omitted from loaded review rows."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/tn-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast","parserHint":"Active ETL remains eacTurnoutCsv until a Tennessee-native turnout or voter-participation denominator artifact is collected and reconciled."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"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","localFile":"data/tn-counties.geojson","parserHint":"County map joins only; precinct geometry/crosswalks are not loaded."},"coverageInventory":{"sourceTitle":"Tennessee 2024 data coverage and administration source inventory","sourceUrl":"https://sos.tn.gov/elections/results","localFile":"data/tn-2024-data-coverage-inventory.json","parserHint":"Documents loaded official result/review artifacts and official 2016/2020 historical baseline rows, plus remaining state-native turnout, precinct geometry, 2012 historical baseline, audit, CVR, recount, incident, correction, and litigation gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Tennessee 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/47","localFile":"data/tn-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."},"historicalBaseline":{"sourceTitle":"Tennessee Secretary of State official 2016 and 2020 county presidential PDFs","sourceUrl":"https://sos-tn-gov-files.s3.amazonaws.com/PresidentbyCountyNov2016.pdf; https://sos-tn-gov-files.tnsosfiles.com/Nov%202020%20General%20by%20County.pdf","localFile":"data/tn-2016-president-by-county.pdf; data/tn-2020-general-by-county.pdf; data/tn-historical-presidential-baseline.csv","level":"county","parserHint":"scripts/normalize-tn-historical-presidential-baseline.mjs extracts official county presidential rows and writes 190 historical baseline rows for 2016 and 2020."}},"expected":{"countyRows":95,"geometryFeatures":95,"stateTotal":3063942,"trump":1966865,"harris":1056265,"other":40812,"localReviewRows":1859,"turnoutRows":95,"historicalBaselineRows":190},"caveats":["The official source is a text-layer PDF rather than a structured export; scripts/normalize-tn-sos-results.mjs reconciles parsed precinct totals to official statewide President and U.S. Senate totals before writing CSV artifacts.","Review rows are precinct-level President-versus-U.S.-Senate comparisons for advisory source-review screening only, not findings of fraud or misconduct.","Turnout rows use EAC 2024 V2 jurisdiction fallback data until a Tennessee-native turnout and registration denominator artifact is collected and reconciled.","County geometry is loaded; precinct boundary geometry/crosswalks are not loaded.","Official 2016 and 2020 historical baseline rows are loaded from Tennessee SOS county PDFs; official 2012 historical baseline rows and normalized audit/recount/CVR/incident/correction/litigation records are not loaded."],"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_precinct_pdf_rows","turnoutMode":"eac_2024_v2_jurisdiction_fallback","historicalMode":"official_sos_county_baseline_context_2016_2020_2012_missing","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized"}},{"state":"TX","name":"Texas","priority":5,"nativeReadiness":"complete_county_map_vtd_review_turnout_partial_reconciliation","authority":"Texas Secretary of State; Texas Legislative Council Capitol Data Portal","configFile":"etl/state-configs/tx.json","legacyReferenceBundle":"data/tx-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Texas SOS official 2024 general county JSON results","sourceUrl":"https://results.texas-election.com/static/data/election/49664/1012/County.json","localFile":"data/tx-2024-official-results/County.json","parserHint":"Use race 1001 for certified county presidential rows and race 7958 for county U.S. Senate comparison totals when needed."},"localReviewRows":{"sourceTitle":"Texas Capitol Data Portal 2024 General Election VTD returns ZIP","sourceUrl":"https://data.capitol.texas.gov/dataset/35b16aee-0bb0-4866-b1ec-859f1f044241/resource/e1cd6332-6a7a-4c78-ad2a-852268f6c7a2/download/2024-general-vtds-election-data.zip","localFile":"data/tx-2024-general-vtds-election-data.zip","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"Inside the ZIP, parse 2024_General_Election_Returns.csv; group by County/FIPS/VTD and compare Office=President with Office=U.S. Sen using Party D/R/other."},"turnout":{"sourceTitle":"Texas Capitol Data Portal 2024 General Election VTD VRTO rows","sourceUrl":"https://data.capitol.texas.gov/dataset/35b16aee-0bb0-4866-b1ec-859f1f044241/resource/e1cd6332-6a7a-4c78-ad2a-852268f6c7a2/download/2024-general-vtds-election-data.zip","localFile":"data/tx-2024-general-vtds-election-data.zip","level":"precinct","denominator":"TotalVR registered voters from 2024_General_Election_VRTO.csv","ballotsCast":"TotalTO turnout from 2024_General_Election_VRTO.csv"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2748%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/tx-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"reconciliation":{"sourceTitle":"Texas 2024 VTD versus certified county reconciliation summary","localFile":"data/tx-2024-vtd-reconciliation-summary.json","countyDeltaFile":"data/tx-2024-vtd-county-reconciliation.csv","parserHint":"Run npm run etl:reconcile:tx:vtd after replacing the Texas SOS County.json or Capitol Data Portal VTD ZIP artifacts."}},"expected":{"countyRows":254,"geometryFeatures":254,"stateTotal":11388674,"trump":6393597,"harris":4835250,"other":159827,"localReviewRows":9348,"turnoutRows":9712},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_dropoff_vtd_export_with_certified_total_gap","turnoutMode":"capitol_data_portal_vtd_vrto"},"caveats":["Certified county result rows remain sourced from Texas SOS County.json.","The Capitol Data Portal 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 summary attributes the main scope difference to VTD generic Write-In rows totaling 24,730 versus 8,569 SOS named declared write-in votes.","VTD rows are official local screening context, not replacement certified totals.","VTD boundary GeoJSON is not present in this package."]},{"state":"NC","name":"North Carolina","priority":6,"nativeReadiness":"complete_county_map_real_precinct_review_eac_turnout_state_native_denominator_lead_historical_2016_2020_historical_review","authority":"North Carolina State Board of Elections; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/nc.json","legacyReferenceBundle":"data/nc-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"North Carolina State Board of Elections 2024 general precinct results ZIP","sourceUrl":"https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2024_11_05/results_pct_20241105.zip","localFile":"data/nc-2024-results-precinct.zip","parserHint":"Parse results_pct_20241105.txt inside the ZIP; aggregate US PRESIDENT rows by County across all reporting units for certified county totals. The file includes Election Day, Early Voting, Absentee by Mail, Provisional, Total Votes, and Real Precinct fields."},"localReviewRows":{"sourceTitle":"North Carolina State Board of Elections 2024 general precinct results ZIP","sourceUrl":"https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2024_11_05/results_pct_20241105.zip","localFile":"data/nc-2024-results-precinct.zip","level":"precinct","comparisonContest":"Governor","parserHint":"Filter review rows to Real Precinct=Y, then pair US PRESIDENT with NC GOVERNOR by County and Precinct. Certified county totals still aggregate all reporting units; Real Precinct=Y review rows cover 3,923,739 of 5,699,141 presidential votes."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback with NCSBE voter_stats/history_stats turnout leads","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports; https://www.ncsbe.gov/results-data/voter-registration-data; https://www.ncsbe.gov/results-data/voter-history-data; https://www.ncsbe.gov/results-data/voter-turnout/2024-general-election-turnout","localFile":"data/eac-2024-state-turnout/nc-2024-eac-turnout.csv; data/nc-2024-voter-stats.zip; data/nc-2024-history-stats.zip; data/nc-2024-turnout-source-review.json; data/nc-2024-turnout-denominator-lead.csv","level":"jurisdiction","denominator":"Active ETL uses EAC A1a Total Reg registered voters; NCSBE voter_stats_20241105.zip is retained as an official state-native denominator lead and matches the EAC registered-voter total exactly.","ballotsCast":"Active ETL uses EAC normalized ballots cast. NCSBE history_stats_20241105.zip reports voters who participated and remains a lead because its statewide total is below EAC ballots cast and the NCSBE overview ballots-cast figure."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2737%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/nc-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"North Carolina State Board of Elections historical precinct results ZIPs","sourceUrl":"https://www.ncsbe.gov/results-data/election-results/historical-election-results-data","localFile":"data/nc-2012-results-precinct.zip; data/nc-2016-results-precinct.zip; data/nc-2020-results-precinct.zip; data/nc-historical-presidential-baseline.csv","parserHint":"Run npm run etl:collect:nc:historical to aggregate official NCSBE 2012, 2016, and 2020 US President rows to 300 county historicalPresidentialCsv baseline rows."},"historicalReviewRows":{"sourceTitle":"North Carolina State Board of Elections official 2016 and 2020 general President and U.S. Senate results","sourceUrl":"https://www.ncsbe.gov/results-data/election-results/historical-election-results-data","localFile":"data/nc-2016-results-precinct.zip; data/nc-2020-results-precinct.zip; data/nc-historical-review-rows.csv","level":"county (2016); precinct (2020)","comparisonContest":"U.S. Senate","parserHint":"Run node scripts/normalize-nc-historical-review.mjs. The 2016 path aggregates all 3,209 official reporting-unit keys by the explicit County field into 100 county rows whose presidential tuples exactly match the existing official baseline; it retains one signed -4 write-in source adjustment before final nonnegative reconciliation. The 2020 path remains 2,662 official Real Precinct=Y county/precinct keys and exactly reconciles 403 excluded Real Precinct=N administrative keys."},"turnoutDenominatorLead":{"sourceTitle":"North Carolina State Board of Elections 2024 General voter_stats and history_stats ZIPs","sourceUrl":"https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2024_11_05/voter_stats_20241105.zip; https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2024_11_05/history_stats_20241105.zip","localFile":"data/nc-2024-voter-stats.zip; data/nc-2024-history-stats.zip; data/nc-2024-turnout-denominator-lead.csv; data/nc-2024-turnout-source-review.json","parserHint":"Run node scripts/normalize-nc-turnout.mjs to aggregate voter_stats registered voters and history_stats voters who participated to 100 county lead rows and the source-review summary. Keep as lead only until numerator semantics are reviewed."}},"expected":{"countyRows":100,"geometryFeatures":100,"stateTotal":5699141,"trump":2898423,"harris":2715375,"other":85343,"localReviewRows":2658,"turnoutRows":100,"historicalBaselineRows":300,"historicalReviewRows":2762,"historicalReviewRowsByYear":{"2016":100,"2020":2662}},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_governor_real_precinct_filter","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_ncsbe_denominator_history_leads","historicalBaselineMode":"official_ncsbe_precinct_zip_county_aggregates","historicalReviewMode":"official_2016_county_and_2020_real_precinct_y_president_vs_us_senate"},"caveats":["Certified county totals aggregate all NCSBE reporting units from the official results ZIP.","Review charts filter to official Real Precinct=Y rows, covering 2,658 precinct rows and 3,923,739 of 5,699,141 presidential votes; early voting, absentee, provisional, transfer, and other non-real reporting units account for 1,775,402 presidential votes and remain in certified county totals only.","Governor is the same-grain comparison contest because North Carolina had no 2024 U.S. Senate race.","Turnout rows remain active EAC 2024 V2 jurisdiction fallback data. Official NCSBE voter_stats_20241105.zip is collected and sums to the same 7,854,464 registered voters as EAC; official history_stats_20241105.zip sums to 5,705,861 voters who participated, which is 50,245 below EAC ballots cast and 18,126 below the NCSBE turnout overview ballots-cast figure, so it is retained as a lead pending semantic review.","Historical baseline rows are official NCSBE county aggregates for context only.","The 2020 historical advisory package contains 2,662 same-grain President-versus-U.S.-Senate rows explicitly marked Real Precinct=Y. Included presidential votes total 3,201,711 and included comparison votes total 3,172,016; 403 Real Precinct=N administrative keys are excluded and reconcile to 2,323,091 presidential votes and 2,302,936 comparison votes.","The 2016 historical advisory package aggregates all official President and U.S. Senate reporting rows by the explicit County field into 100 county rows and makes no precinct-level claim. All presidential county tuples match the official 2016 baseline; one signed -4 write-in source correction is retained before final nonnegative reconciliation.","Precinct boundary GeoJSON, normalized audit/recount/CVR availability, and incident/correction records remain gaps."]},{"state":"SC","name":"South Carolina","priority":6,"nativeReadiness":"complete_county_map_precinct_review_state_turnout_2016_2020_historical_partial_reconciliation","authority":"South Carolina Election Commission","configFile":"etl/state-configs/sc.json","legacyReferenceBundle":"data/sc-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"South Carolina Elections Database official 2024 General Election President CSV","sourceUrl":"https://sc.elstats.civera.com/api/download_contest/7131_table.csv?split_party=false","localFile":"data/sc-2024-election-history/president-7131.csv","parserHint":"southCarolinaElectionHistoryCsv filters County rows for certified county totals and Precinct rows for local presidential review inputs."},"localReviewRows":{"sourceTitle":"South Carolina Elections Database official 2024 General Election U.S. House CSV downloads","sourceUrl":"https://electionhistory.scvotes.gov/","localFile":"data/sc-2024-election-history","level":"precinct","comparisonContest":"U.S. House by congressional district","parserHint":"Parse U.S. House contest CSVs 7124 through 7130 and aggregate duplicate county/precinct keys from congressional-district splits before comparing to presidential precinct rows."},"turnout":{"sourceTitle":"SC VREMS 2024 General Election voter-history county statistics","sourceUrl":"https://vrems.scvotes.sc.gov/Statistics/VoterHistoryResults","localFile":"data/sc-2024-vrems-turnout.csv","level":"county","denominator":"Printed registration-list voters from VREMS totalRegistered","ballotsCast":"VREMS totalVoting participating voters"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2745%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/sc-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"South Carolina Elections Database official 2016 and 2020 presidential contest CSVs normalized to county baselines","sourceUrl":"https://electionhistory.scvotes.gov/","localFile":"data/sc-historical-presidential-baseline.csv","parserHint":"Run scripts/normalize-sc-historical-presidential-baseline.mjs; aggregate county rows by party from official contest CSV downloads 5292 and 1974.","rowCount":92,"years":[2016,2020]}},"expected":{"countyRows":46,"geometryFeatures":46,"stateTotal":2548140,"trump":1483747,"harris":1028452,"other":35941,"localReviewRows":2401,"turnoutRows":46,"historicalBaselineRows":92},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_house_dropoff_district_based","turnoutMode":"sc_vrems_county_voter_history_warning_required","historicalBaselineMode":"official_sc_elections_database_2016_2020_county_baseline_context","historicalMode":"official_election_history_county_csv_2016_2020_2012_missing"},"caveats":["U.S. House is district-based rather than a single statewide comparison race; review rows remain advisory.","The parser aggregates duplicate county/precinct keys created by congressional-district splits before calculating dropoff.","SC VREMS registration denominators are printed registration-list counts and include active voters plus some inactive voters, so turnout rows are warning-required.","Precinct boundary GeoJSON is not included; only county geometry and a VREMS precinct/polling-place reference path are identified.","Official 2016 and 2020 county historical baselines are normalized from South Carolina Elections Database presidential contest CSVs and resolve to Census county FIPS tags.","Official 2012 county historical baseline has not been normalized yet."]},{"state":"MD","name":"Maryland","priority":7,"nativeReadiness":"complete_county_map_precinct_review_turnout_fallback_2016_2020_historical","authority":"Maryland State Board of Elections","configFile":"etl/state-configs/md.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Maryland SBE 2024 Presidential General all-precinct CSV","sourceUrl":"https://elections.maryland.gov/elections/archive/2024/election_data/PG24_AllPrecincts.csv","localFile":"data/md-2024-general-all-precincts.csv","parserHint":"Filter Office Name=President - Vice Pres; aggregate county rows from Election District - Precinct candidate rows using ballot-mode vote columns."},"localReviewRows":{"sourceTitle":"Maryland SBE 2024 Presidential General all-precinct CSV","sourceUrl":"https://elections.maryland.gov/elections/archive/2024/election_data/PG24_AllPrecincts.csv","localFile":"data/md-2024-general-all-precincts.csv","level":"precinct","comparisonContest":"U.S. Senator","parserHint":"Pair President - Vice Pres rows with U.S. Senator rows by County Name and Election District - Precinct; compare Kamala D. Harris with Angela Alsobrooks and Donald J. Trump with Larry Hogan."},"precinctReference":{"sourceTitle":"Maryland SBE 2024 precinct and polling-place reference workbook","sourceUrl":"https://elections.maryland.gov/elections/archive/2024/Polling%20Places%20AEMS%20PG24.xlsx","localFile":"data/md-2024-precinct-reference.xlsx","parserHint":"Reference context only; vote totals come from PG24_AllPrecincts.csv."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/md-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2724%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/md-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"Maryland SBE 2016 county result page and 2020 all-by-precinct CSV historical presidential baselines","sourceUrl":"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","localFile":"data/md-historical-presidential-baseline.csv","level":"county","parserHint":"Run node scripts/normalize-md-historical-presidential-baseline.mjs. The normalized historicalPresidentialCsv emits 48 county/county-equivalent rows across 2016 and 2020. 2016 totals: Clinton 1,677,928; Trump 943,169; Other 160,349; Total 2,781,446. 2020 totals: Biden 1,985,023; Trump 976,414; Other 75,594; Total 3,037,031. Baltimore City and Baltimore County remain separate county-equivalent rows. Official 2012 Maryland baselines remain missing."}},"expected":{"countyRows":24,"geometryFeatures":24,"stateTotal":3038334,"trump":1035550,"harris":1902577,"other":100207,"localReviewRows":1958,"turnoutRows":24,"historicalBaselineRows":48},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_dropoff_precinct_csv","turnoutMode":"eac_2024_v2_jurisdiction_fallback","historicalBaselineMode":"official_sbe_2016_2020_county_or_county_equivalent_context","historicalMode":"official_sbe_county_2016_precinct_2020_2012_missing"},"caveats":["The all-precinct CSV includes official ballot-mode vote columns and same-grain President/U.S. Senate rows, but not same-row registered-voter denominators.","Turnout rows use EAC 2024 V2 jurisdiction fallback data until a Maryland state-native denominator source is collected.","Precinct boundary GeoJSON is not present in this package.","Official 2016 and 2020 county/county-equivalent historical baselines are normalized from Maryland State Board of Elections artifacts and resolve to Census county FIPS tags; official 2012 rows remain uncollected."],"legacyReferenceBundle":"data/md-app-data.js"},{"state":"ID","name":"Idaho","priority":15,"nativeReadiness":"complete_county_map_county_house_review_state_native_county_turnout_historical_context_admin_context_inventory","authority":"Idaho Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting Verifier","configFile":"etl/state-configs/id.json","legacyReferenceBundle":"data/id-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Idaho Secretary of State Vote Idaho official 2024 General Election county XML result endpoints","sourceUrl":"https://archive.voteidaho.gov/results/2024/general/xml.html","localFile":"data/id-2024-general-president.csv","parserHint":"countyPresidentCsv rows generated by scripts/normalize_id_official_results.py from Vote Idaho official county XML endpoints, with documented official county-table fallback handling for stale endpoints."},"localReviewRows":{"sourceTitle":"Idaho Secretary of State Vote Idaho official 2024 General Election congressional map results","sourceUrl":"https://archive.voteidaho.gov/results/2024/general/congressional.html","localFile":"data/id-2024-general-us-house.csv","level":"county","comparisonContest":"U.S. House","parserHint":"countyComparisonCsv rows generated by scripts/normalize_id_official_congressional_results.py; Ada County source district splits are aggregated back to county scope."},"turnout":{"sourceTitle":"Idaho Secretary of State 2024 General Election county turnout workbook","sourceUrl":"https://sos.idaho.gov/elections/data/results/2024/turnout_county_general.xlsx","localFile":"data/id-2024-turnout-county-general.xlsx; data/id-2024-raw-stats-general.xlsx; data/id-2024-general-turnout.csv; data/id-2024-turnout-reconciliation-summary.json","level":"county","denominator":"Idaho SOS Total Registered Voters, equal to Registration at Cutoff plus Election Day Registrations","ballotsCast":"Idaho SOS Ballots Cast","parserHint":"Run node scripts/normalize-id-turnout.mjs. The normalizer writes data/id-2024-general-turnout.csv and verifies county workbook totals against raw precinct-stat county totals and retained EAC benchmark rows."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2716%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/id-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Idaho 2024 data coverage and administration source inventory","sourceUrl":"https://sos.idaho.gov/elections-division/election-results/","localFile":"data/id-2024-data-coverage-inventory.json","parserHint":"Documents loaded Vote Idaho/EAC/Census/equipment artifacts and remaining official-source request paths; no normalized administration rows are loaded beyond equipment context."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Idaho 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/16","localFile":"data/id-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."},"historicalBaseline":{"sourceTitle":"Idaho Secretary of State official 2012/2016/2020 county presidential historical baselines","sourceUrl":"https://sos.idaho.gov/elections-division/2020-results-statistics/","localFile":"data/id-2012-general-president-by-county.html; data/id-2016-general-president-by-county.html; data/id-2020-general-statewide.html; data/id-2020-general-statistics.html; data/id-2020-general-county-abstracts.zip; data/id-historical-presidential-baseline.csv","parserHint":"Run python scripts/collect-id-historical-baseline.py. The collector parses official 2012/2016 archive county tables and the official 2020 SOS county statistics table, then writes 132 historicalPresidentialCsv rows."}},"expected":{"countyRows":44,"geometryFeatures":44,"stateTotal":904967,"trump":605246,"harris":274972,"other":24749,"localReviewRows":44,"turnoutRows":44,"ballotsCast":917469,"registeredVoters":1178750,"historicalBaselineRows":132},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_house_county_rows","turnoutMode":"official_state_native_county_turnout_reconciled_to_eac_benchmark","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized","historicalBaselineMode":"official_sos_county_context_2012_2016_2020"},"caveats":["Current Idaho review rows are county-level President-versus-U.S.-House comparisons, not precinct scatter plots.","U.S. House is district-based and candidate-specific, so advisory screens are directional source-review context rather than candidate-benefit findings.","Turnout rows use official Idaho Secretary of State county turnout and registration rows; the retained EAC benchmark matches ballots cast and registered voters in every county.","Official raw precinct turnout rows are retained as a source lead, but active review rows remain county-level, so precinct turnout is not activated for same-grain advisory screening.","County geometry is loaded; precinct or reporting-unit boundary geometry/crosswalks are not loaded.","Equipment context is loaded from Verified Voting as supplemental administration metadata; normalized official audit/recount/CVR/incident/correction/litigation rows are not loaded.","Official 2012/2016/2020 county historical baseline rows are loaded for county-level context and flip/join coverage; no precinct historical rows are loaded."]},{"state":"IL","name":"Illinois","priority":13,"nativeReadiness":"complete_county_rollup_precinct_house_review_eac_turnout_reviewed_official_2016_2020_historical","authority":"Illinois State Board of Elections","configFile":"etl/state-configs/il.json","legacyReferenceBundle":"data/il-2024-official-results","artifacts":{"presidentialCountyResults":{"sourceTitle":"Illinois State Board of Elections 2024 General by-office CSV downloads","sourceUrl":"https://www.elections.il.gov/ElectionOperations/ElectionVoteTotals.aspx?ID=66","localFile":"data/il-2024-official-results","parserHint":"Parse the official 2024 President by-office CSV and roll City of Bloomington, Chicago, Danville, East St. Louis, Galesburg, and Rockford into their Census parent counties, producing 102 county rows without vote loss."},"localReviewRows":{"sourceTitle":"Illinois State Board of Elections 2024 General President and U.S. House by-office CSV downloads","sourceUrl":"https://www.elections.il.gov/ElectionOperations/ElectionVoteTotals.aspx?ID=66","localFile":"data/il-2024-official-results","level":"precinct","comparisonContest":"U.S. House","parserHint":"Join President precinct rows to 1st-17th Congress CSV rows by JurisdictionID/JurisName/PrecinctName; omit keys with multiple House districts and rows without both Democratic and Republican House votes."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback plus Illinois by-office turnout-field review","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports; https://www.elections.il.gov/ElectionOperations/ElectionVoteTotals.aspx?ID=66","localFile":"data/eac-2024-state-turnout/il-2024-eac-turnout.csv; data/il-2024-turnout-source-review.json","level":"jurisdiction_fallback_active_precinct_by_office_lead_reviewed_not_valid","denominator":"Active ETL uses EAC A1a Total Reg registered voters. The Illinois by-office Registration field is retained as a reviewed denominator lead only because it has zero-registration precinct keys and does not reconcile statewide.","ballotsCast":"Active ETL uses EAC turnout ballots cast. The Illinois by-office President CSV has VoteCount rows but no election-level ballots-cast field; candidate plus over/under/blank rows total 5,702,776, which is 14,371 below active EAC ballots cast.","parserHint":"scripts/report-il-turnout-source-review.mjs regenerates data/il-2024-turnout-source-review.json from the official President by-office CSV and EAC fallback rows."},"countyBoundary":{"sourceTitle":"Census county boundary GeoJSON","sourceUrl":"https://www.census.gov/geographies/mapping-files/time-series/geo/cartographic-boundary.html","localFile":"data/il-counties.geojson","appReadyFile":"data/il-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"turnoutSourceReview":{"sourceTitle":"Illinois State Board of Elections by-office precinct turnout-field review","sourceUrl":"https://www.elections.il.gov/ElectionOperations/ElectionVoteTotals.aspx?ID=66","localFile":"data/il-2024-turnout-source-review.json","parserHint":"Documents reviewed Registration and VoteCount fields and the keep-EAC-fallback decision."},"historicalBaseline":{"sourceTitle":"Illinois State Board of Elections 2016 and 2020 Candidate Totals by County workbooks","sourceUrl":"https://www.elections.il.gov/ElectionOperations/DownloadVoteTotals.aspx","localFile":"data/il-historical-presidential-baseline.csv","level":"county","parserHint":"scripts/collect-il-historical-presidential-baseline.mjs reads GE2016Cty.xls and GE2020Cty.xls, retains candidate and write-in votes, joins county names to data/il-counties.geojson, aggregates to exactly 102 county:<GEOID> rows per year, and records source/reference hashes."},"historicalReconciliation":{"sourceTitle":"Illinois historical presidential source and reconciliation summary","sourceUrl":"https://www.elections.il.gov/ElectionOperations/DownloadVoteTotals.aspx","localFile":"data/il-historical-presidential-baseline-summary.json","parserHint":"Records official workbook URLs and hashes plus Census county-reference authority, URL, path, hash, join fields, and 102-feature count."},"historicalPromotionReconciliation":{"sourceTitle":"Illinois fail-closed historical promotion reconciliation","sourceUrl":"https://www.elections.il.gov/ElectionOperations/DownloadVoteTotals.aspx","localFile":"data/il-historical-promotion-reconciliation.json","parserHint":"Run node scripts/reconcile-il-historical-promotion.mjs --staging-dir=.etl/staging before promotion; it requires all 102 live tags, exact 2024 county rollup parity, and the pinned 2020 correction profile."}},"expected":{"countyRows":102,"geometryFeatures":102,"stateTotal":5649779,"trump":2449079,"harris":3062863,"other":137837,"localReviewRows":6655,"turnoutRows":108,"historicalBaselineRows":204},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_house_contested_precinct_dropoff","turnoutMode":"eac_2024_v2_jurisdiction_fallback_by_office_registration_and_contest_total_reviewed_not_valid_replacement","historicalBaselineMode":"official_2016_2020_candidate_totals_by_county_102_canonical_tags_per_year","historicalPromotionStatus":"accepted_pre_promotion_snapshot"},"caveats":["The 2024 by-office package has no statewide U.S. Senate or Governor contest, so advisory comparison uses U.S. House.","Review rows omit 292 precinct keys that appear in multiple House districts and 3,080 uncontested or one-party House precincts.","Active turnout remains EAC fallback: the official by-office President CSV has Registration and VoteCount fields, but Registration sums to 7,210,422 versus 8,970,541 EAC registered voters, 2,260 precinct keys have zero Registration, and contest totals including over/under/blank rows are 14,371 below EAC ballots cast.","Official 2016 and 2020 Candidate Totals by County workbooks provide candidate and write-in votes but not blank, undervote, or overvote records; 2012 remains uncollected.","The pinned pre-promotion reconciliation preserves all 102 live 2020 county tags but replaces 100 nonmatching vote tuples: six parent counties gain candidate votes previously stored in separate city election-authority rows, while 100 Other/total fields adopt the official candidate-and-write-in scope.","The canonical county rollup corrects McLean and Winnebago from incomplete red winners to official blue winners, removes two spurious 2020-to-2024 red-to-blue flips, preserves all 2024 vote tuples after rollup, and is expected to replace 99 pre-rollup stored indicators with 90 staged indicators."]},{"state":"MT","name":"Montana","priority":14,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_2016_2020_historical_partial_reconciliation","authority":"Montana Secretary of State","configFile":"etl/state-configs/mt.json","legacyReferenceBundle":"data/mt-2024-general-precinct-by-precinct.xlsx","artifacts":{"presidentialCountyResults":{"sourceTitle":"Montana SOS official 2024 General Election precinct-by-precinct workbook","sourceUrl":"https://sosmt.gov/docs/32/results/66992/2024_general_precinct_by_precinct","localFile":"data/mt-2024-general-precinct-by-precinct.xlsx","parserHint":"Parse Sheet1; filter Race Name=PRESIDENT & VICE PRESIDENT, aggregate by CountyName, and bucket Harris/Trump by Party or Last Name. The workbook omits 27 presidential write-in votes that are present in the separate certified canvass total."},"localReviewRows":{"sourceTitle":"Montana SOS official 2024 General Election precinct-by-precinct workbook","sourceUrl":"https://sosmt.gov/docs/32/results/66992/2024_general_precinct_by_precinct","localFile":"data/mt-2024-general-precinct-by-precinct.xlsx","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"Pair PRESIDENT & VICE PRESIDENT and UNITED STATES SENATOR rows by CountyName, County ID, and PrecinctName; compare Harris/Trump to Tester/Sheehy plus other Senate candidates."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/mt-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2730%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/mt-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"Montana SOS official 2016 and 2020 general precinct-by-precinct workbooks normalized to county presidential baselines","sourceUrl":"https://sosmt.gov/elections/results/","localFile":"data/mt-historical-presidential-baseline.csv","parserHint":"Run scripts/normalize-mt-historical-presidential-baseline.mjs; aggregate President rows by CountyName and PartyCode from official historical precinct workbooks. Separate write-in canvass PDFs are retained as context and not forced into county rows.","rowCount":112,"years":[2016,2020]},"historicalWriteInContext":{"sourceTitle":"Montana SOS official 2016 and 2020 write-in canvass context","sourceUrl":"https://sosmt.gov/elections/results/","localFile":"data/mt-historical-presidential-baseline-summary.json","parserHint":"Summary retains official write-in canvass PDF paths and statewide write-in caveat for historical baseline totals."}},"expected":{"countyRows":56,"geometryFeatures":56,"stateTotal":602963,"trump":352079,"harris":231906,"other":18978,"localReviewRows":726,"turnoutRows":56,"historicalBaselineRows":112},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_dropoff_precinct_workbook_with_certified_write_in_gap","turnoutMode":"eac_2024_v2_jurisdiction_fallback_warning_required","historicalMode":"official_sos_precinct_workbook_context_2016_2020_2012_missing_write_ins_context_only"},"caveats":["Official precinct workbook rows aggregate to 602,963 presidential votes, 27 below the 602,990 certified canvass total because presidential write-ins are reported in the separate canvass context rather than the workbook rows parsed for native results.","Turnout rows use EAC 2024 V2 jurisdiction fallback data and are warning-marked until a Montana state-native county or precinct denominator artifact is collected.","County boundary geometry is loaded for map joins; official precinct boundary geometry is not included.","Official 2016 and 2020 county historical baselines are normalized from Montana Secretary of State precinct workbooks and resolve to Census county FIPS tags.","Montana historical other_votes and total_votes exclude separate write-in canvass totals because the official election-results export does not allocate write-ins consistently into county rows; Dem/Rep winner joins are unaffected.","Official 2012 county historical baseline has not been normalized yet."]},{"state":"MO","name":"Missouri","priority":15,"nativeReadiness":"complete_115_county_fips_map_review_turnout_historical_admin_inventory","authority":"Missouri Secretary of State","configFile":"etl/state-configs/mo.json","legacyReferenceBundle":"data/mo-2024-general-results-by-county.pdf","artifacts":{"presidentialCountyResults":{"sourceTitle":"Missouri SOS official 2024 general election results by county PDF and normalized presidential CSV","sourceUrl":"https://www.sos.mo.gov/CMSImages/ElectionResultsStatistics/ActualResults-November52024.pdf","localFile":"data/mo-2024-general-president-county.csv","parserHint":"scripts/normalize-mo-sos-pdfs.mjs retains the 116 official election-authority rows and emits 115 canonical Census-county rows. Kansas City within Jackson County is summed with Jackson outside Kansas City into county:29095 with zero statewide delta."},"localReviewRows":{"sourceTitle":"Missouri SOS official 2024 general election results by county PDF and normalized U.S. Senate CSV","sourceUrl":"https://www.sos.mo.gov/CMSImages/ElectionResultsStatistics/ActualResults-November52024.pdf","localFile":"data/mo-2024-general-senate-county.csv","level":"county","comparisonContest":"U.S. Senate","parserHint":"Canonical President-versus-U.S.-Senate comparison rows cover 115 county/county-equivalent FIPS tags. Jackson County combines the two official SOS authority rows and reconciles exactly."},"turnout":{"sourceTitle":"Missouri SOS official 2024 General Election voter turnout report","sourceUrl":"https://www.sos.mo.gov/CMSImages/ElectionResultsStatistics/Nov2024OfficialVoterTurnout.pdf","localFile":"data/mo-2024-general-turnout-county.csv","level":"county","denominator":"registered voters from SOS turnout report","ballotsCast":"actual voters from SOS turnout report","parserHint":"Canonical 115-county turnout rows retain official actual-voter and registered-voter totals; Jackson combines Kansas City-within-Jackson and Jackson-outside-Kansas-City."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2729%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/mo-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"Missouri SOS official 2012/2016/2020 presidential county baselines","sourceUrl":"https://www.sos.mo.gov/elections/results","localFile":"data/mo-historical-presidential-county-baseline.csv","level":"county","years":[2012,2016,2020],"parserHint":"Canonical 115-county rows per year with explicit county:<GEOID> tags and zero statewide deltas; Kansas City is aggregated into Jackson County FIPS 29095."}},"expected":{"countyRows":115,"geometryFeatures":115,"stateTotal":2995327,"trump":1751986,"harris":1200599,"other":42742,"localReviewRows":115,"turnoutRows":115,"historicalBaselineRows":345},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_115_canonical_county_fips","turnoutMode":"sos_2024_115_canonical_county_rows","historicalBaselineMode":"official_2012_2016_2020_115_county_fips_rows"},"caveats":["Official source PDFs expose 116 local election-authority rows. The SOS authority list identifies Kansas City within Jackson County and Jackson outside Kansas City, so the canonical package sums them into county:29095.","Review rows are official county-level advisory inputs, not precinct scatter plots.","The 2016 historical PDF omits county-level write-in detail; other/total values remain visible-column sums.","Precinct-level President and Senate files remain purchasable/request-only, and normalized administration-context rows remain incomplete."]},{"state":"ND","name":"North Dakota","priority":16,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_admin_context_inventory","authority":"North Dakota Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/nd.json","legacyReferenceBundle":"data/nd-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"North Dakota SOS official ResultsAjax President county JSON","sourceUrl":"https://resultsws.sos.nd.gov/ResultsAjax.svc/GetMapData?type=SW&category=CTY&raceID=19893&osn=100&county=0&party=0","localFile":"data/nd-2024-sos-president-county.csv; data/nd-2024-sos-results-manifest.json","parserHint":"Run npm run etl:collect:nd. scripts/collect-nd-sos-results.mjs fetches official ResultsAjax JSON and writes county President rows for countyPresidentCsv."},"localReviewRows":{"sourceTitle":"North Dakota SOS official ResultsAjax President and U.S. Senate precinct JSON","sourceUrl":"https://results.sos.nd.gov/ResultsSW.aspx?text=Race&type=SW&map=CTY","localFile":"data/nd-2024-sos-president-senate-precinct-review.csv; data/nd-2024-sos-results-manifest.json","level":"county_scoped_precinct","comparisonContest":"U.S. Senate","parserHint":"Generated from same-key official President raceID 19893 and U.S. Senate raceID 19847 county-scoped precinct JSON rows. Two zero-vote precinct keys are excluded and documented in the manifest."},"turnout":{"sourceTitle":"EAC 2024 North Dakota jurisdiction turnout fallback plus SOS eligible-voter lead","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/nd-2024-eac-turnout.csv; data/nd-2024-data-coverage-inventory.json","level":"jurisdiction_fallback_and_state_native_eligible_voter_lead","denominator":"EAC registered voters is zero because North Dakota has no voter registration; official SOS eligible-voter denominator lead reports 594,140 eligible voters statewide.","parserHint":"Current ETL uses eacTurnoutCsv. A future turnout normalizer should collect official dashboard/export eligible-voter fields and reconcile the one-ballot SOS/EAC turnout difference."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2738%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/nd-counties.geojson","parserHint":"County map joins only; precinct geometry/crosswalks are not loaded."},"coverageInventory":{"sourceTitle":"North Dakota 2024 data coverage and administration source inventory","sourceUrl":"https://results.sos.nd.gov/ResultsSW.aspx?text=Race&type=SW&map=CTY","localFile":"data/nd-2024-data-coverage-inventory.json","parserHint":"Documents loaded official SOS endpoint artifacts and remaining turnout denominator, geometry, historical, audit, CVR, recount, incident, correction, and litigation gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier North Dakota 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/38","localFile":"data/nd-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or precinct-uniformity proof."}},"expected":{"countyRows":53,"geometryFeatures":53,"stateTotal":368155,"trump":246505,"harris":112327,"other":9323,"localReviewRows":383,"turnoutRows":53},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_county_scoped_precinct_rows","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_state_native_eligible_voter_lead","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized"},"caveats":["Review rows are official same-key county-scoped precinct President-versus-U.S.-Senate rows from the SOS ResultsAjax dashboard endpoint; they are advisory source-review context only, not findings.","Two zero-vote precinct keys are excluded from review rows and documented in data/nd-2024-sos-results-manifest.json.","Active turnout remains EAC fallback because North Dakota has no voter registration and the SOS eligible-voter denominator lead needs normalization and one-ballot SOS/EAC turnout reconciliation before replacement.","County geometry is loaded; precinct boundary geometry/crosswalks are not loaded.","No normalized historical baseline, audit, CVR availability, recount, incident, correction, or litigation rows are loaded."]},{"state":"NE","name":"Nebraska","priority":11,"nativeReadiness":"complete_county_map_county_review_eac_turnout_historical_admin_inventory_precinct_path_blocked","authority":"Nebraska Secretary of State","configFile":"etl/state-configs/ne.json","legacyReferenceBundle":"data/ne-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Nebraska SOS 2024 General Canvass Book county presidential rows","sourceUrl":"https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","localFile":"data/ne-2024-general-canvass-president.csv","parserHint":"countyPresidentCsv normalized from official canvass pages 11-12; the retained PDF is data/ne-2024-general-canvass-book.pdf."},"localReviewRows":{"sourceTitle":"Nebraska SOS 2024 General Canvass Book U.S. Senate two-year special county rows","sourceUrl":"https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","localFile":"data/ne-2024-general-canvass-senate-two-year.csv","level":"county","comparisonContest":"U.S. Senate two-year special election","parserHint":"countyComparisonCsv normalized from canvass page 17. This is a county-level review source, not a precinct/subcounty result export."},"turnout":{"sourceTitle":"EAC fallback turnout plus generated Nebraska SOS canvass voting-statistics reconciliation","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ne-2024-eac-turnout.csv; data/ne-2024-general-canvass-book.pdf; data/ne-2024-post-general-eligible-voter-report.pdf; data/ne-2024-canvass-voting-statistics-reconciliation.csv; data/ne-2024-canvass-voting-statistics-reconciliation-summary.json","level":"county","denominator":"EAC registered voters for loaded rows; Nebraska canvass and post-general registration reports retained as state-native cross-checks","ballotsCast":"EAC normalized ballots_cast for loaded rows; generated canvass reconciliation documents Total Voting and county deltas before any turnout replacement","stateNativeSourceUrls":["https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","https://sos.nebraska.gov/sites/default/files/doc/elections/vrstats/2024VR/Post-Election-Statewide-November-2024.pdf"],"parserHint":"Loaded ETL uses eacTurnoutCsv. Run npm run etl:reconcile:ne:turnout to regenerate the Nebraska canvass voting-statistics reconciliation; review the 91-vote canvass-minus-EAC ballots difference before replacing fallback rows."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2731%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ne-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"Nebraska SOS historical General Canvass Books","sourceUrl":"https://sos.nebraska.gov/previous-elections","localFile":"data/ne-2012-general-canvass-book.pdf; data/ne-2016-general-canvass-book.pdf; data/ne-2020-general-canvass-book.pdf; data/ne-historical-presidential-baseline.csv","parserHint":"scripts/normalize-ne-historical-baseline.mjs regenerates 279 county presidential baseline rows for 2012, 2016, and 2020."},"adminSourceInventory":{"sourceTitle":"Nebraska 2024 administration, turnout, geometry, and request-path inventory","sourceUrl":"https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","localFile":"data/ne-2024-admin-source-inventory.json","parserHint":"Inventory only; documents canvass Reported Problems, turnout/crosswalk request paths, and audit/recount/CVR/litigation/equipment gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Nebraska 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/31","localFile":"data/ne-2024-equipment-context.csv","parserHint":"Supplemental context only; request official equipment records from Nebraska SOS or county election offices when source-native equipment provenance is needed."}},"expected":{"countyRows":93,"geometryFeatures":93,"stateTotal":952182,"trump":564816,"harris":369995,"other":17371,"localReviewRows":93,"turnoutRows":93,"historicalBaselineRows":279},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"county_president_vs_senate_two_year_dropoff_precinct_blocked","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_generated_state_canvass_reconciliation","historicalMode":"official_canvass_books_2012_2016_2020"},"caveats":["Current review rows are county-level advisory inputs, not precinct/subcounty scatter plots.","The public SOS pass did not identify a statewide precinct/subcounty President and U.S. Senate export; request those rows and matching geometry/crosswalk before upgrading subcounty advisory coverage.","Loaded turnout rows use EAC fallback values. The generated Nebraska canvass voting-statistics reconciliation documents 965,236 statewide Total Voting versus 965,145 EAC fallback ballots cast, a 91-vote canvass-minus-EAC difference across 34 county rows, with no registered-voter denominator difference.","The canvass Reported Problems section is inventoried as administration context only; audit/recount/CVR/litigation records remain source-request items."]},{"state":"GA","name":"Georgia","priority":6,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_official_historical_review_admin_context_partial","authority":"Georgia Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting Verifier","configFile":"etl/state-configs/ga.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Georgia SOS official 2024 media export","sourceUrl":"https://results.sos.ga.gov/cdn/results/Georgia/export-2024NovGen.json","localFile":"data/ga-2024-official-results-export.json","parserHint":"georgiaMediaExportJson aggregates county President of the US rows by county."},"localReviewRows":{"sourceTitle":"Georgia SOS official 2024 media export precinct President and U.S. House rows","sourceUrl":"https://results.sos.ga.gov/cdn/results/Georgia/export-2024NovGen.json","localFile":"data/ga-2024-official-results-export.json","level":"precinct","comparisonContest":"U.S. House","parserHint":"georgiaMediaExportJsonHouseComparison pairs precinct President of the US rows with same-export U.S. House district rows where comparable; one-sided and multi-district rows are caveated."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ga-2024-eac-turnout.csv","level":"county","denominator":"EAC registered voters","ballotsCast":"EAC normalized ballots cast"},"historicalBaseline":{"sourceTitle":"Georgia SOS official historical media exports","sourceUrl":"https://results.sos.ga.gov/","localFile":"data/ga-2012-official-results-export.json; data/ga-2016-official-results-export.json; data/ga-2020-official-results-export.json; data/ga-historical-presidential-baseline.csv","parserHint":"Run node scripts/collect-ga-historical-baseline.mjs to regenerate 477 county presidential baseline rows for 2012, 2016, and 2020."},"historicalReviewRows":{"sourceTitle":"Georgia Secretary of State official 2016 and 2020 county President and U.S. Senate media exports","sourceUrl":"https://results.sos.ga.gov/","localFile":"data/ga-2016-official-results-export.json; data/ga-2020-official-results-export.json; data/ga-historical-review-rows.csv","level":"county","comparisonContest":"U.S. Senate","parserHint":"Run node scripts/normalize-ga-historical-review.mjs. historicalReviewCsv loads 318 canonical county rows: 159 President-versus-United States Senator, Isakson rows for 2016 and 159 President-versus-regular US Senate (Perdue) rows for the original November 2020 general election. The selected county contest options expose no precinct-result rows; the Loeffler special election is excluded."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2713%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ga-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"adminSourceInventory":{"sourceTitle":"Georgia 2024 data coverage inventory","localFile":"data/ga-2024-data-coverage-inventory.json","parserHint":"Documents remaining state-native turnout, precinct geometry, audit/recount/CVR/incident/correction, and county request-path gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Georgia 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/13","localFile":"data/ga-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit outcomes, or precinct-uniform equipment claims."},"voteMethodTurnoutReview":{"sourceTitle":"Georgia SOS media export vote-method and turnout replacement review","sourceUrl":"https://results.sos.ga.gov/results/public/Georgia","localFile":"data/ga-2024-turnout-vote-method-source-review.json","parserHint":"scripts/report-ga-turnout-vote-method-source-review.mjs confirms President groupResults are candidate vote-method splits and that no registered-voter denominator or election-level ballots-cast field is present; EAC turnout remains active."}},"expected":{"countyRows":159,"geometryFeatures":159,"stateTotal":5250066,"trump":2663117,"harris":2548017,"other":38932,"localReviewRows":2684,"turnoutRows":159,"historicalBaselineRows":477,"historicalReviewRows":318,"historicalReviewRowsByYear":{"2016":159,"2020":159}},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_house_with_district_caveats","turnoutMode":"eac_2024_v2_jurisdiction_fallback_after_sos_vote_method_review","historicalMode":"official_sos_media_export_county_baselines","historicalReviewMode":"official_sos_county_president_vs_us_senate_2016_2020"},"caveats":["U.S. House is district-based and candidate-specific, so Georgia directional screens are low-confidence advisory context rather than candidate-benefit findings.","County presidential candidate rows sum 19 votes higher than the statewide presidential contest total in minor-party/other rows.","Turnout remains EAC fallback; state-native turnout denominators are not loaded.","Precinct boundary GeoJSON is not present in this package.","Historical presidential baseline rows are context only; the 2020 media export reports the original November general-election export total and should not be mixed with recount tables without reconciliation.","Historical advisory rows are county-only same-grain President-versus-U.S.-Senate context: 159 canonical county rows for 2016 and 159 for 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 historical advisory comparison uses the regular US Senate (Perdue) contest from the original November general export before the runoff; the Loeffler special election is excluded. The selected county contest options contain no precinct-result rows, so the package must not be described as precinct historical coverage.","Historical advisory indicators are review signals only; candidate differences, contest differences, split-ticket voting, and participation differences can explain broad patterns and the rows are not findings of misconduct.","The July 5, 2026 Georgia vote-method source review confirms official SOS groupResults are candidate-result splits, not turnout/registration denominator rows; EAC turnout remains active until a state-native turnout artifact is collected."],"legacyReferenceBundle":"data/ga-app-data.js","blocker":"Georgia has official 2024 result/review rows, official historical baselines, official 2016 and 2020 county historical advisory rows, county geometry, equipment context, and a retained vote-method source review. Remaining blockers are state-native turnout/registration denominator rows, precinct boundary geometry/crosswalks, and normalized audit/recount/CVR/incident/correction/litigation records."},{"state":"KS","name":"Kansas","priority":26,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_equipment_context_mixed_historical_baseline","authority":"Kansas Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/ks.json","legacyReferenceBundle":"data/ks-2024-presidential-results.xlsx","artifacts":{"presidentialCountyResults":{"sourceTitle":"Kansas SOS official 2024 Presidential Election Results workbook","sourceUrl":"https://sos.ks.gov/elections/24elec/2024-Presidential-Results.xlsx","localFile":"data/ks-2024-presidential-results.xlsx","parserHint":"kansasPresidentialResultsXlsx parses sheet 2024 Presidential Results; aggregate County rows by Party and Votes for certified county map totals."},"localReviewRows":{"sourceTitle":"Kansas SOS official 2024 General Election U.S. House precinct workbook","sourceUrl":"https://sos.ks.gov/elections/24elec/2024-General-Election-United-States-House-of-Representatives-Precinct-Results.xlsx","localFile":"data/ks-2024-general-us-house-precinct.xlsx","level":"precinct","comparisonContest":"U.S. House","parserHint":"Pair official presidential precinct rows with U.S. House precinct rows by county and precinct; Johnson, Sedgwick, Shawnee, and Wyandotte are read from separate wide-format county tabs."},"turnout":{"sourceTitle":"EAC 2024 Kansas jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ks-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2720%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ks-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"Kansas 2012/2016/2020 county presidential historical baseline rows","sourceUrl":"https://sos.ks.gov/elections/election-results.html","localFile":"data/ks-historical-presidential-baseline.csv","parserHint":"historicalPresidentialCsv generated by scripts/collect-ks-historical-baseline.mjs. 2020 rows are official SOS workbook county aggregates; 2016 rows are official for 101 counties plus secondary contextual rows for Johnson, Sedgwick, Shawnee, and Wyandotte; 2012 rows are secondary contextual county rows cross-checked against the SOS statewide PDF but not reconciled to it."}},"expected":{"countyRows":105,"geometryFeatures":105,"stateTotal":1327591,"trump":758802,"harris":544853,"other":23936,"localReviewRows":3739,"turnoutRows":105,"historicalBaselineRows":315},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_house_precinct_workbooks_with_vote_share_only_rows","turnoutMode":"eac_2024_v2_jurisdiction_fallback","historicalBaselineMode":"mixed_official_secondary_context_2012_2016_2020"},"caveats":["U.S. House is district-based rather than a single statewide comparison contest, so review rows are advisory screening inputs only.","Three nonzero presidential local rows do not have a matching House comparison row and are retained as vote-share-only rows.","Turnout rows use EAC 2024 V2 jurisdiction fallback data until a Kansas-native turnout/registration artifact is collected and reconciled.","County boundary geometry is loaded for map joins; official precinct boundary geometry is not included.","Historical baselines are contextual county rows only: 2020 is official SOS workbook-derived, 2016 includes four secondary county rows for counties absent from the official workbook, and 2012 is secondary county context that does not reconcile to the official SOS statewide presidential total.","data/ks-2024-data-coverage-inventory.json documents equipment context plus remaining audit, CVR, incident/correction, recount, litigation, turnout, 2012 official historical replacement, and precinct-geometry gaps."]},{"state":"CA","name":"California","priority":13,"nativeReadiness":"complete_county_map_county_review_state_native_turnout_historical_admin_inventory","authority":"California Secretary of State; U.S. Census Bureau; Verified Voting equipment context","configFile":"etl/state-configs/ca.json","legacyReferenceBundle":"data/ca-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"California SOS 2024 General Election Statement of Vote President by County XLSX","sourceUrl":"https://elections.cdn.sos.ca.gov/sov/2024-general/sov/16-president.xlsx","localFile":"data/ca-2024-general-president.csv","parserHint":"Run npm run etl:prepare:ca to normalize data/ca-2024-president-county.xlsx into 58 county President rows."},"localReviewRows":{"sourceTitle":"California SOS 2024 General Election Statement of Vote U.S. Senator full-term by County XLSX","sourceUrl":"https://elections.cdn.sos.ca.gov/sov/2024-general/sov/19-uss-ft.xlsx","localFile":"data/ca-2024-general-us-senate-full-term.csv","level":"county","comparisonContest":"U.S. Senate full term","parserHint":"Run npm run etl:prepare:ca to normalize data/ca-2024-us-senate-full-term-county.xlsx into 58 county comparison rows."},"turnout":{"sourceTitle":"California SOS 2024 General Election voter participation statistics by county PDF","sourceUrl":"https://elections.cdn.sos.ca.gov/sov/2024-general/sov/03-voter-participation-stats-by-county.pdf","localFile":"data/ca-2024-voter-participation-stats-by-county.csv","level":"county","denominator":"15-day Report of Registration registered voters","ballotsCast":"Total Voters"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"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","localFile":"data/ca-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"California SOS official historical Statement of Vote President by County workbooks","sourceUrl":"https://www.sos.ca.gov/elections/prior-elections/statewide-election-results","localFile":"data/ca-historical-presidential-baseline.csv","parserHint":"scripts/normalize-ca-sov-workbooks.mjs normalizes 2012, 2016, and 2020 county presidential workbook rows."},"coverageInventory":{"sourceTitle":"California 2024 data coverage and administration source inventory","localFile":"data/ca-2024-data-coverage-inventory.json","parserHint":"Documents loaded CA result/review/turnout/historical/equipment artifacts and remaining official request/source paths."},"swdbSupplementalSourceReview":{"sourceTitle":"California Statewide Database 2024 General Election precinct/local source review","sourceUrl":"https://statewidedatabase.org/election.html","localFile":"data/ca-2024-swdb-source-review.json","parserHint":"Generated by scripts/report-ca-swdb-source-review.mjs. Valid supplemental source lead only; keep SOS Statement of Vote artifacts authoritative until SWDB files are collected and reconciled."}},"expected":{"countyRows":58,"geometryFeatures":58,"stateTotal":15865475,"trump":6081697,"harris":9276179,"other":507599,"localReviewRows":58,"turnoutRows":58,"historicalBaselineRows":174},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_county_statement_of_vote","turnoutMode":"sos_county_voter_participation_15_day_registration","historicalBaselineMode":"official_sos_county_statement_of_vote_workbooks","adminInventoryStatus":"source_paths_documented_not_row_level_loaded"},"caveats":["Review rows are county-level President-versus-U.S.-Senate full-term comparisons, not precinct or city/local scatter plots.","Registered-voter turnout denominators are 15-day Report of Registration totals and do not include Same Day Voter Registration after the 15-day close.","County map geometry is loaded; precinct boundary geometry is not part of this package.","Administration context is inventoried, but normalized audit/CVR/incident/correction/recount/litigation rows are not loaded.","SWDB 2024 precinct/local data is documented as a supplemental future source lead, not the active certified-result or turnout source. Collect, masking-review, and reconcile SWDB files to SOS certified totals before loading them."]},{"state":"FL","name":"Florida","priority":19,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_secondary_historical_with_precinct_zip_caveat","authority":"Florida Department of State; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/fl.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Florida Department of State official 2024 General Election President county detail table","sourceUrl":"https://results.elections.myflorida.com/DetailRpt.Asp?ELECTIONDATE=11/5/2024&RACE=PRE&PARTY=&DIST=&GRP=&DATAMODE=","localFile":"data/fl-2024-general-president-detail.html","parserHint":"floridaDetailHtml reads the official county detail table and remains the certified county map source; totals reconcile to 10,893,752 candidate votes."},"localReviewRows":{"sourceTitle":"Florida Department of State 2024 General Election precinct-level ZIP","sourceUrl":"https://dos.fl.gov/elections/data-statistics/elections-data/precinct-level-election-results/","localFile":"data/fl-2024-general-precinct-results.zip; data/fl-2024-precinct-data-definitions.pdf; data/fl-2024-precinct-source-review.json","level":"precinct_location","comparisonContest":"U.S. Senate","parserHint":"floridaPrecinctZipPresidentSenate pairs President and U.S. Senate rows by county, unique precinct identifier, and polling-location label; use the ZIP for review rows only because its presidential candidate total is 204 votes below the certified county detail table."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback with Florida precinct ZIP registration-denominator lead","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/fl-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters; official Florida precinct ZIP registered-voter field retained as denominator lead only","ballotsCast":"EAC normalized ballots cast"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb Florida county boundaries","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2712%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/fl-counties.geojson","nameProperty":"NAME","codeProperty":"GEOID"}},"expected":{"countyRows":67,"geometryFeatures":67,"stateTotal":10893752,"trump":6110125,"harris":4683038,"other":100589,"localReviewRows":5618,"turnoutRows":67,"historicalBaselineRows":201},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_precinct_location_zip","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_state_registration_lead","historicalBaselineMode":"secondary_county_context_2012_2016_2020"},"caveats":["Certified Florida county map totals remain anchored to the official county detail table, not the precinct ZIP.","The official precinct ZIP presidential candidate total is 204 votes below the county detail table and the ZIP Trump total is one vote higher.","The precinct ZIP registered-voter field is a denominator lead only because no compatible state-native ballots-cast rows are loaded.","County geometry is loaded; precinct boundary geometry/crosswalks are not loaded.","Historical baselines are secondary county context rows and not 2024 certified data."],"legacyReferenceBundle":"data/fl-app-data.js"},{"state":"MA","name":"Massachusetts","priority":11,"nativeReadiness":"complete_county_map_city_town_ward_precinct_review_eac_turnout_official_historical_admin_inventory","authority":"Massachusetts Secretary of the Commonwealth; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting","configFile":"etl/state-configs/ma.json","legacyReferenceBundle":"data/ma-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Massachusetts PD43+ official 2024 President county-filtered result pages","sourceUrl":"https://electionstats.state.ma.us/elections/view/165300/","localFile":"data/ma-2024-president-county-results.csv","parserHint":"Run npm run etl:collect:ma:county to refresh official PD43+ County Totals rows for the 14 counties; county rows reconcile to 3,512,930 presidential votes."},"localReviewRows":{"sourceTitle":"Massachusetts PD43+ official 2024 President and U.S. Senate precinct downloads","sourceUrl":"https://electionstats.state.ma.us/elections/download/165300/precincts_include:1/","localFile":"data/ma-2024-president-precinct-results.csv; data/ma-2024-us-senate-precinct-results.csv","level":"city_town_ward_precinct","comparisonContest":"U.S. Senate","parserHint":"Use City/Town, Ward, and Pct to pair President rows with U.S. Senate rows; group review rows by municipality because the PD43+ bulk export lacks county."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback with Massachusetts statewide turnout-statistics cross-check","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ma-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters; Massachusetts statewide turnout page confirms 5,142,343 registered voters and 3,512,930 total votes cast","ballotsCast":"EAC normalized ballots cast"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer","localFile":"data/ma-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"historicalBaseline":{"sourceTitle":"Massachusetts PD43+ official 2012, 2016, and 2020 President county result pages","sourceUrl":"https://electionstats.state.ma.us/elections/view/140751/","localFile":"data/ma-historical-presidential-baseline.csv","parserHint":"Run npm run etl:collect:ma:historical to regenerate 42 official PD43+ county baseline rows."},"coverageInventory":{"sourceTitle":"Massachusetts 2024 data coverage and administration source inventory","sourceUrl":"https://electionstats.state.ma.us/elections/view/165300/","localFile":"data/ma-2024-data-coverage-inventory.json","parserHint":"Documents loaded artifacts, official statewide turnout cross-check, geometry limits, audit/CVR/request paths, and display caveats."}},"expected":{"countyRows":14,"geometryFeatures":14,"stateTotal":3512930,"trump":1251303,"harris":2126518,"other":135109,"localReviewRows":2382,"turnoutRows":351,"historicalBaselineRows":42},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_city_town_ward_precinct_pd43","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_official_statewide_crosscheck","historicalBaselineMode":"official_pd43_county_context","adminInventoryStatus":"source_paths_documented_not_row_level_loaded"},"caveats":["PD43+ precinct rows are municipality-centric and do not include county, so review rows group by city/town while county certified rows come from PD43+ county-filtered pages.","Turnout remains EAC jurisdiction fallback; the official Massachusetts turnout statistics page is a statewide cross-check, not a local replacement package.","Historical baselines are county-level context only; the 2020 PD43+ county rows sum one non-D/R vote above the statewide summary line and the collector preserves official displayed county rows.","County geometry is loaded, but no official precinct/ward/municipal geometry or reporting-unit crosswalk is loaded.","The coverage inventory records audit/CVR/log/L&A/custody/incident/recount/litigation request paths only; normalized administration rows are not loaded."]},{"state":"OK","name":"Oklahoma","priority":12,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_ok_vr_denominator_lead_2016_2020_historical_admin_inventory_official_2016_2020_historical","authority":"Oklahoma State Election Board; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting equipment context","configFile":"etl/state-configs/ok.json","legacyReferenceBundle":"data/ok-2024-official-results","artifacts":{"presidentialCountyResults":{"sourceTitle":"Oklahoma State Election Board official county-level CSV ZIP export","sourceUrl":"https://results.okelections.gov/OKERS/enrapi/GetExtract/CLCSV/20241105","localFile":"data/ok-2024-official-results/ok-2024-county-level-results.zip","parserHint":"nativeOklahomaOfficialCsvZip reads the official county-level ZIP for U.S. President race 10001 and reconciles totals against the official race-level CSV export."},"localReviewRows":{"sourceTitle":"Oklahoma State Election Board official precinct-level CSV ZIP export","sourceUrl":"https://results.okelections.gov/OKERS/enrapi/GetExtract/PLCSV/20241105","localFile":"data/ok-2024-official-results/ok-2024-precinct-level-results.zip","level":"precinct","comparisonContest":"U.S. House","parserHint":"Pair President race 10001 precinct rows with precinct U.S. House rows where both Democratic and Republican candidates are present; retain nonzero presidential precincts without comparable House rows as vote-share-only review rows."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback plus Oklahoma Nov. 1 voter-registration denominator lead","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ok-2024-eac-turnout.csv; data/ok-2024-vrstats-county-denominator-lead.csv; data/ok-2024-vrstats-denominator-summary.json","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters; the Oklahoma State Election Board Nov. 1 VR PDF denominator lead parses to the same 2,442,211 statewide registered voters and zero county registered-voter mismatches.","ballotsCast":"EAC normalized ballots cast; keep fallback active because the OK VR PDF has no ballots-cast or voter-history field."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2740%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ok-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"raceLevelReconciliation":{"sourceTitle":"Oklahoma State Election Board official race-level CSV export","sourceUrl":"https://results.okelections.gov/OKERS/enrapi/GetExtract/CSV/20241105","localFile":"data/ok-2024-official-results/ok-2024-race-level-results.csv","parserHint":"Reconciles presidential statewide totals against county aggregation."},"coverageInventory":{"sourceTitle":"Oklahoma 2024 data coverage and administration source inventory","sourceUrl":"https://oklahoma.gov/elections/elections-results/election-results/2024-election-results/november-general-election.html","localFile":"data/ok-2024-data-coverage-inventory.json","parserHint":"Documents loaded official exports, EAC fallback turnout, county geometry, equipment context, historical-source leads, official audit archive path, records-request path, and display caveats. Inventory only; no normalized audit/CVR/incident/recount/litigation rows are loaded."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Oklahoma 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/40","localFile":"data/ok-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit, incidents, or proof of precinct-uniform equipment."},"turnoutDenominatorLead":{"sourceTitle":"Oklahoma State Election Board MESA Current Registration Statistics by District 11/1/2024","sourceUrl":"https://oklahoma.gov/content/dam/ok/en/elections/voter-registration-statistics/2024-vr-statistics/vrstats-district-nov1-2024.pdf","localFile":"data/ok-2024-vrstats-district-nov1-2024.pdf; data/ok-2024-vrstats-county-denominator-lead.csv; data/ok-2024-vrstats-denominator-summary.json","level":"county_aggregated_from_congressional_district_county_fragments","denominator":"Nov. 1, 2024 registered voters by party; 77 county rows, 2,442,211 registered voters statewide.","parserHint":"scripts/collect-ok-vrstats-registration.mjs extracts the text-layer PDF, aggregates split county fragments from the congressional-district section, validates party totals, and reconciles the denominator to the active EAC fallback."},"historicalBaseline":{"sourceTitle":"Oklahoma State Election Board official 2016 and 2020 CountyResults CSV ZIP exports","sourceUrl":"https://results.okelections.gov/OKER/","localFile":"data/ok-historical-presidential-baseline.csv","level":"county","parserHint":"scripts/normalize-ok-historical-presidential-baseline.py reads only exact root members from the official 20161108 and 20201103 CountyResults ZIPs, filters President race 10001, preserves every candidate, validates all 77 source county names against Census/config county references, and emits 77 canonical county:<GEOID> rows per year."},"historicalReconciliation":{"sourceTitle":"Oklahoma historical presidential source and reconciliation summary","sourceUrl":"https://results.okelections.gov/OKER/","localFile":"data/ok-historical-presidential-baseline-summary.json","parserHint":"Records official discovery/export URLs, ZIP and member metadata, SHA-256 hashes, source/presidential row counts, every candidate total, Census county-reference hash, exact statewide totals, and 77-tag coverage per year."},"historicalPromotionReconciliation":{"sourceTitle":"Oklahoma 2016/2020 official baseline promotion review","sourceUrl":"https://results.okelections.gov/OKER/","localFile":"data/ok-historical-presidential-baseline-summary.json","parserHint":"All 77 live 2020 tags and vote tuples are preserved; 77 official 2016 tags are added. county:40079 uses canonical Le Flore County while local_unit preserves LEFLORE."}},"expected":{"countyRows":77,"geometryFeatures":77,"stateTotal":1566173,"trump":1036213,"harris":499599,"other":30361,"localReviewRows":1977,"turnoutRows":77,"historicalBaselineRows":154},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_house_precinct_with_vote_share_only_rows","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_ok_vr_denominator_lead_reconciled","adminInventoryStatus":"equipment_context_loaded_audit_archive_and_request_paths_documented_not_row_level_loaded","historicalBaselineMode":"official_2016_2020_county_results_race_10001_77_canonical_tags_per_year"},"caveats":["Review rows use U.S. House by district rather than a single statewide comparison contest, and 460 nonzero presidential precinct rows are vote-share-only because comparable major-party House rows are absent.","Turnout rows use EAC 2024 V2 county/jurisdiction fallback data. The collected Oklahoma State Election Board Nov. 1 VR PDF confirms the same 2,442,211 registered-voter denominator statewide with zero county registered-voter mismatches, but it has no ballots-cast field, so active turnout remains EAC fallback until Oklahoma-native ballots-cast or voter-history rows are collected and reconciled.","County geometry is loaded; official precinct boundary geometry or a precinct-to-result crosswalk is not loaded.","The official 2024 post-election audit archive and records-request path are documented, but normalized audit, CVR availability, recount, incident, correction, and litigation rows are not loaded.","Official 2016 and 2020 CountyResults exports are loaded as 154 historical county rows. The 2016 export has three presidential tickets; the 2020 export has six, and all non-Democratic/non-Republican candidate votes are retained as Other. Official 2012 history remains uncollected. Historical jurisdiction names use canonical Census display names while local_unit preserves official export labels; county:40079 is therefore staged as Le Flore County."]},{"state":"OR","name":"Oregon","priority":14,"nativeReadiness":"complete_county_map_county_review_eac_turnout_precinct_package_2016_2020_historical_admin_inventory","authority":"Oregon Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting","configFile":"etl/state-configs/or.json","legacyReferenceBundle":"data/or-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Oregon Secretary of State 2024 November General Election Official Results PDF","sourceUrl":"https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735458","localFile":"data/or-2024-general-president.csv; data/or-2024-general-official-results.pdf","parserHint":"countyPresidentCsv generated by scripts/normalize-or-official-results.mjs from the official abstract PDF; 36 county rows, 2,244,493 presidential votes."},"localReviewRows":{"sourceTitle":"Oregon Secretary of State 2024 November General Election Official Results PDF, Attorney General contest","sourceUrl":"https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735458","localFile":"data/or-2024-general-attorney-general.csv","level":"county","comparisonContest":"Attorney General","parserHint":"countyComparisonCsv pairs county President rows with Attorney General Democratic, Republican, and other totals for county-level advisory screening."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback plus Oregon official voter registration statistics lead","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/or-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast; keep fallback active until Oregon official voter registration statistics PDF is collected, normalized, and reconciled."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2741%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/or-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Oregon 2024 data coverage and administration source inventory","sourceUrl":"https://sos.oregon.gov/elections/Pages/electionhistory.aspx","localFile":"data/or-2024-data-coverage-inventory.json","parserHint":"Documents loaded county artifacts, ORMS precinct package status, official turnout and historical source leads, public-records/county request paths, and display caveats. Inventory only; no normalized administration rows are loaded."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Oregon 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/41","localFile":"data/or-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."},"historicalBaseline":{"sourceTitle":"Oregon Secretary of State 2016 and 2020 General Election Abstract of Votes PDFs","sourceUrl":"https://sos.oregon.gov/elections/Pages/electionhistory.aspx","localFile":"data/or-historical-presidential-baseline.csv; data/or-2016-general-official-results.pdf; data/or-2020-general-official-results.pdf","parserHint":"Run npm run etl:prepare:or. scripts/normalize-or-historical-presidential-baseline.mjs extracts US President county rows from official abstract PDFs and writes 72 historical baseline rows."}},"expected":{"countyRows":36,"geometryFeatures":36,"stateTotal":2244493,"trump":919480,"harris":1240600,"other":84413,"localReviewRows":36,"turnoutRows":36,"historicalBaselineRows":72},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_attorney_general_county","turnoutMode":"eac_2024_v2_jurisdiction_fallback","adminInventoryStatus":"source_paths_documented_not_row_level_loaded","historicalBaselineMode":"official_2020_oregon_abstract_county_context","historicalMode":"official_abstract_pdf_county_2016_2020_2012_missing"},"caveats":["Current Oregon review rows are county-level President-versus-Attorney-General comparisons, not precinct scatter plots.","The official ORMS precinct package is collected for provenance but includes many PDF/image-heavy county artifacts requiring county-aware extraction review or request-produced machine-readable files.","Turnout remains EAC fallback until the official Oregon voter registration and turnout statistics PDF is collected, normalized, and reconciled.","Audit, CVR availability, incident, correction, recount, litigation, tabulator-log, logic-and-accuracy, custody, and ballot-image records are documented as source/request gaps only.","Official 2016 and 2020 historical presidential county baselines are loaded from Oregon abstract PDFs; official 2012 remains uncollected.","Historical baselines are contextual jurisdictionTag flip rows, not replacements for 2024 certified-result rows."]},{"state":"UT","name":"Utah","priority":14,"nativeReadiness":"complete_county_map_county_review_turnout_historical","authority":"Utah Lieutenant Governor Elections Office; U.S. Census Bureau; U.S. Election Assistance Commission","configFile":"etl/state-configs/ut.json","legacyReferenceBundle":"data/ut-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Utah official 2024 General Election U.S. President API county breakdown","sourceUrl":"https://electionresults.utah.gov/results/public/api/elections/utah/general11052024/ballot-items/88e40000-968a-0c37-b0b0-08dce9374078","localFile":"data/ut-2024-general-president.csv; data/ut-2024-general-president-official-api.json","parserHint":"countyPresidentCsv generated by scripts/normalize-ut-official-results.mjs from the official electionresults.utah.gov U.S. President ballot-item detail API; the certified canvass PDF is retained as a cross-check."},"localReviewRows":{"sourceTitle":"Utah 2024 November General Election Statewide Canvass PDF Attorney General rows","sourceUrl":"https://vote.utah.gov/wp-content/uploads/2025/02/2024-General-Election-Statewide-Canvass-2.pdf","localFile":"data/ut-2024-general-attorney-general.csv","level":"county","comparisonContest":"Attorney General","parserHint":"countyComparisonCsv generated by scripts/normalize-ut-official-results.mjs from official PDF text-layer Attorney General rows."},"turnout":{"sourceTitle":"Utah aggregated county standardized canvass statistics 2023-2025 workbook","sourceUrl":"https://vote.utah.gov/wp-content/uploads/2025/12/Master-Aggregated-Numbers-2023-2025.xlsx","localFile":"data/ut-2024-general-turnout.csv","level":"county","denominator":"Active voters","ballotsCast":"Total ballots counted"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2749%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ut-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Utah 2024 data coverage and administration source inventory","sourceUrl":"https://vote.utah.gov/2024-election-information/","localFile":"data/ut-2024-data-coverage-inventory.json","parserHint":"Documents loaded official county results/review/turnout/geometry artifacts, the official API residual resolution, CD2 recount context, and remaining request paths."}},"expected":{"countyRows":29,"geometryFeatures":29,"stateTotal":1488494,"trump":883818,"harris":562566,"other":42110,"localReviewRows":29,"turnoutRows":29,"historicalBaselineRows":87},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"county_president_vs_attorney_general_loaded","turnoutMode":"state_native_county_standardized_canvass_active_voters","adminInventoryStatus":"source_paths_documented_not_row_level_loaded","importerStatus":"loaded_via_generic_county_president_csv_dispatcher","officialApiContestTotal":1488494},"caveats":["Utah presidential county totals are generated from the official electionresults.utah.gov API and reconcile to the 1,488,494-vote statewide contest total; the canvass PDF remains retained as a certified-total cross-check.","UT native result, review, turnout, and historical rows import through the generic countyPresidentCsv dispatcher.","Review rows are county-level President-versus-Attorney-General comparisons, not precinct/local scatter plots.","Turnout rows use total ballots counted and Active voters from the official county standardized canvass statistics workbook; ballots counted are election-level turnout, not presidential contest votes.","Historical baselines remain secondary contextual rows from Wikipedia county tables with source footnotes until official Utah historical artifacts are normalized.","Normalized audit, CVR availability, incident, correction, recount, litigation, L&A, tabulator-log, custody, and precinct-geometry rows are not loaded."]},{"state":"LA","name":"Louisiana","priority":15,"nativeReadiness":"complete_parish_map_precinct_review_sos_turnout_2016_2020_historical_admin_context_inventory_official_2016_2020_historical","authority":"Louisiana Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting","configFile":"etl/state-configs/la.json","legacyReferenceBundle":"data/la-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"Louisiana Secretary of State official 2024 general election precinct CSV results","sourceUrl":"https://voterportal.sos.la.gov/static/20241105/resultsRace/Presidential","localFile":"data/la-2024-general-election-results","parserHint":"louisianaSosPrecinctCsvDirectory aggregates official precinct/vote-mode President CSV rows to 64 parish result rows and reconciles to 2,006,975 presidential votes."},"localReviewRows":{"sourceTitle":"Louisiana Secretary of State official 2024 general election precinct CSV results, U.S. House contests","sourceUrl":"https://voterportal.sos.la.gov/static/20241105/resultsRace/Presidential","localFile":"data/la-2024-general-election-results","level":"precinct_vote_mode","comparisonContest":"U.S. House","parserHint":"louisianaSosPrecinctCsvDirectory pairs President rows with U.S. House rows where parish, ward, precinct, and vote-mode keys align; district/candidate effects are caveated in reviewCharts."},"turnout":{"sourceTitle":"Louisiana Secretary of State parish post-election turnout statistics","sourceUrl":"https://electionstatistics.sos.la.gov/data/Post_Election_Statistics/parish/2024_1105_par.xls","localFile":"data/la-2024-post-election-statistics-turnout.csv","level":"parish","denominator":"SOS qualified voters as of the close of registration records thirty days before the election","ballotsCast":"SOS post-election statistics Voted field, election-level turnout","parserHint":"Generated from official SOS statewide/parish post-election statistics XLS workbooks by scripts/normalize-la-post-election-statistics.mjs. Parish rows reconcile exactly to the statewide workbook: 2,021,164 voted and 3,046,375 qualified voters; retained EAC benchmark is +424 voted and +1 registered voter."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb parish geography","sourceUrl":"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","localFile":"data/la-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Louisiana 2024 data coverage and administration source inventory","sourceUrl":"https://voterportal.sos.la.gov/static/","localFile":"data/la-2024-data-coverage-inventory.json","parserHint":"Documents loaded SOS/EAC/Census/equipment artifacts and remaining official-source request paths; no normalized administration rows are loaded beyond equipment context."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Louisiana 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/22","localFile":"data/la-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."},"historicalBaseline":{"sourceTitle":"Louisiana Secretary of State official 2016 and 2020 Presidential Electors ByParish CSV blobs","sourceUrl":"https://voterportal.sos.la.gov/static/20161108/resultsRace/Presidential; https://voterportal.sos.la.gov/static/20201103/resultsRace/Presidential","localFile":"data/la-2016-general-president-by-parish.csv; data/la-2020-general-president-by-parish.csv; data/la-historical-presidential-baseline.csv; data/la-historical-presidential-baseline-summary.json","level":"parish","parserHint":"Run node scripts/normalize-la-historical-presidential-baseline.mjs. The normalized historicalPresidentialCsv emits 128 parish county-equivalent rows across 2016 and 2020. 2016 totals: Clinton 780,154; Trump 1,178,638; Other 70,240; Total 2,029,032. 2020 totals: Biden 856,034; Trump 1,255,776; Other 36,252; Total 2,148,062. Official 2012 Louisiana baselines remain missing."}},"expected":{"countyRows":64,"geometryFeatures":64,"stateTotal":2006975,"trump":1208505,"harris":766870,"other":31600,"localReviewRows":3885,"turnoutRows":64,"historicalBaselineRows":128},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_house_precinct_vote_mode","turnoutMode":"sos_post_election_statistics_parish_turnout","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized","historicalBaselineMode":"official_2020_sos_parish_context_2012_2016_missing"},"caveats":["Louisiana uses parishes rather than counties; package fields named countyRows/countyBoundary represent parish rows and parish geometry for validator compatibility.","U.S. House is district-based and candidate-specific, so review rows are advisory source-review context rather than same-office statewide comparison rows.","Turnout rows use official SOS parish post-election statistics. Qualified voters are election-eligible registrants as of the close of registration records thirty days before election day; Voted is election-level turnout, not presidential contest votes.","The retained EAC benchmark is 424 voters and one registered/qualified voter higher statewide than the SOS statistics workbook.","Parish geometry is loaded; precinct boundary geometry or precinct-to-parish crosswalks are not loaded.","Equipment context is loaded from Verified Voting as supplemental administration metadata; normalized official audit/recount/CVR/incident/correction/litigation rows are not loaded.","data/la-2024-data-coverage-inventory.json records Louisiana loaded sources and remaining source-collection gaps.","Official 2016 and 2020 parish presidential historical baseline rows are loaded from Louisiana Secretary of State ByParish CSV blobs; official 2012 historical baseline rows are not loaded. data/la-2024-data-coverage-inventory.json records the remaining historical and administration gaps."]},{"state":"ME","name":"Maine","priority":13,"nativeReadiness":"complete_county_map_town_review_eac_turnout_partial_historical","authority":"Maine Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting equipment context","configFile":"etl/state-configs/me.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Maine SOS 2024 President and Vice President by County/Town corrected final workbook","sourceUrl":"https://www.maine.gov/sos/sites/maine.gov.sos/files/inline-files/President%20and%20Vice%20President%20FINAL-Corrected%2020241205.xlsx","localFile":"data/me-official-sources/me-2024-president-county-town-final-corrected-20241205.xlsx","parserHint":"maineSosCountyTownXlsx reads sheet President & VP; use county total rows plus State UOCAVA as non-geographic certified result row; candidate totals exclude blanks."},"localReviewRows":{"sourceTitle":"Maine SOS 2024 United States Senator corrected final workbook","sourceUrl":"https://www.maine.gov/sos/sites/maine.gov.sos/files/inline-files/US%20Senator%20FINAL-Corrected%2020241205.xlsx","localFile":"data/me-official-sources/me-2024-us-senator-county-town-final-corrected-20241205.xlsx","level":"town","comparisonContest":"U.S. Senate","parserHint":"Pair town rows by county code and normalized municipality label; leave Medway/Twps, Day Block Twp, and Wesley as vote-share-only because Senate grain differs."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/me-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast"},"historicalBaseline":{"sourceTitle":"Maine SOS official 2016 and 2020 President workbooks; 2012 XLS retained as blocked provenance","localFile":"data/me-official-sources/me-2016-president.xlsx; data/me-official-sources/me-2020-president-county-town.xlsx; data/me-official-sources/me-2012-president-county.xls; data/me-official-sources/me-2012-president-municipal.xls","parserHint":"maineSosHistoricalPresidentXlsx loads 34 county/non-geographic rows for 2016 and 2020. 2012 requires legacy XLS support or conversion."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","localFile":"data/me-counties.geojson","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2723%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson"},"coverageInventory":{"sourceTitle":"Maine 2024 data coverage and administration source inventory","localFile":"data/me-2024-data-coverage-inventory.json"},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Maine 2024 equipment context","localFile":"data/me-2024-equipment-context.csv"}},"expected":{"countyRows":17,"geometryFeatures":16,"stateTotal":831375,"trump":377977,"harris":435652,"other":17746,"localReviewRows":512,"comparisonRows":509,"turnoutRows":497,"historicalBaselineRows":34},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_town_with_uocava_excluded","turnoutMode":"eac_2024_v2_jurisdiction_fallback","historicalBaselineMode":"official_2016_2020_sos_workbooks_2012_xls_blocked"},"caveats":["State UOCAVA is a non-geographic certified result row; it is not mapped and is excluded from town review joins.","Medway/Twps, Day Block Twp, and Wesley are vote-share-only rows because the Senate workbook combines or labels those units at a different grain.","U.S. Senate includes a major independent candidate, so Democratic/Republican dropoff metrics are directional source-review inputs only.","Turnout remains EAC fallback until Maine-native ballots-cast or voter-participation rows are collected and reconciled with SOS registration/enrollment files.","2012 official historical XLS artifacts are collected but not loaded until legacy XLS support or conversion is added.","Municipality geometry/crosswalks and normalized audit/CVR/recount/incident/correction/litigation rows remain unloaded."],"legacyReferenceBundle":"data/me-2024-data-coverage-inventory.json"},{"state":"CO","name":"Colorado","priority":11,"nativeReadiness":"complete_county_map_county_review_state_native_turnout_2016_2020_historical_with_clarity_gap_caveat","authority":"Colorado Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting","configFile":"etl/state-configs/co.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Colorado Secretary of State 2024 General Clarity detail XML ZIP","sourceUrl":"https://results.enr.clarityelections.com/CO/122598/367167/reports/detailxml.zip","localFile":"data/co-2024-clarity-detailxml.zip","parserHint":"coloradoClarityDetailXml reads Presidential Electors Choice county rows and aggregates DEM as Harris, REP as Trump, and other listed candidates as Other. Loaded county candidate rows total 3,190,873 votes, 1,872 below the prior Abstract/certified-total lead."},"localReviewRows":{"sourceTitle":"Colorado Secretary of State 2024 General Clarity CU Regent at-large contest","sourceUrl":"https://results.enr.clarityelections.com/CO/122598/367167/reports/detailxml.zip","localFile":"data/co-2024-clarity-detailxml.zip","level":"county","comparisonContest":"Regent of the University of Colorado - At Large","parserHint":"coloradoClarityDetailXml pairs county Presidential Electors rows with same-grain CU Regent at-large rows because Colorado had no 2024 U.S. Senate race."},"turnout":{"sourceTitle":"Colorado Historical Election Data 2024 General Voting Statistics CSV","sourceUrl":"https://historicalelectiondata.coloradosos.gov/search?","localFile":"data/co-2024-historical-voter-statistics.csv; data/co-2024-historical-voter-statistics-turnout.csv; data/co-2024-historical-voter-statistics-summary.json","level":"county","denominator":"Total Voters from the official voter-statistics export; equals Active Voters plus Inactive Voters and matches the former EAC registered-voter denominator statewide.","parserHint":"Run node scripts/normalize-co-historical-voter-statistics.mjs. Current active turnout rows use normalizedTurnoutCsv: 64 county rows, 3,241,155 Total Ballots Cast, and 4,583,280 Total Voters. EAC and Clarity turnout rows are retained as reconciliation benchmarks."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"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","localFile":"data/co-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Colorado 2024 data coverage and administration source inventory","sourceUrl":"https://results.enr.clarityelections.com/CO/122598/web.345435/#/summary","localFile":"data/co-2024-data-coverage-inventory.json","parserHint":"Documents loaded Clarity county result/review source, Historical Election Data state-native turnout replacement, EAC/Clarity turnout reconciliation, county geometry/equipment context, historical-source blockers, and remaining administration gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Colorado 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/8","localFile":"data/co-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."},"historicalBaseline":{"sourceTitle":"Colorado Historical Election Data 2016 and 2020 General President contest CSVs","sourceUrl":"https://historicalelectiondata.coloradosos.gov/contest/4436; https://historicalelectiondata.coloradosos.gov/contest/3640","localFile":"data/co-2016-general-president-list.csv; data/co-2020-general-president-list.csv; data/co-historical-presidential-baseline.csv; data/co-historical-presidential-baseline-summary.json","level":"county","parserHint":"Run node scripts/normalize-co-historical-presidential-baseline.mjs. The normalized historicalPresidentialCsv emits 128 county rows across 2016 and 2020. 2016 totals: Clinton 1,338,870; Trump 1,202,484; Other 238,893; Total 2,780,247. 2020 totals: Biden 1,804,352; Trump 1,364,607; Other 88,021; Total 3,256,980. Official 2012 Colorado baselines remain missing."}},"expected":{"countyRows":64,"geometryFeatures":64,"stateTotal":3190873,"trump":1377441,"harris":1728159,"other":85273,"localReviewRows":64,"turnoutRows":64,"registeredVoters":4583280,"ballotsCast":3241155,"historicalBaselineRows":128},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"county_president_vs_cu_regent_at_large","turnoutMode":"historical_election_data_county_voter_statistics_active_with_eac_clarity_reconciliation","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized","historicalBaselineMode":"official_2020_historical_election_data_county_context_2012_2016_missing"},"caveats":["Loaded Clarity presidential county candidate rows total 3,190,873 votes, 1,872 below the prior Abstract/certified-total lead of 3,192,745; do not allocate that gap by county without an official source.","Review rows are county-level President-versus-CU-Regent-at-large comparisons, not precinct scatter plots.","County geometry is loaded; precinct boundaries/crosswalks are not loaded.","Active turnout uses official Historical Election Data county voter-statistics rows. Total Voters equals Active Voters plus Inactive Voters and matches the former EAC denominator; Total Ballots Cast is 401 above EAC fallback and 35 above the Clarity ElectionVoterTurnout lead.","Official 2016 and 2020 county presidential historical baseline rows are loaded from Colorado Historical Election Data; official 2012 historical baselines and normalized Colorado audit, CVR availability, recount, incident, correction, or litigation rows are not loaded."],"legacyReferenceBundle":"data/co-2024-clarity-detailxml.zip"},{"state":"CT","name":"Connecticut","priority":15,"nativeReadiness":"complete_certified_sov_current_planning_region_results_ems_town_review_turnout_official_2016_2020_historical","authority":"Connecticut Secretary of the State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting equipment context","configFile":"etl/state-configs/ct.json","artifacts":{"localReviewRows":{"sourceTitle":"Connecticut Secretary of the State EMS election 91/version 80741 townVotes static JSON","sourceUrl":"https://ctemspublic.tgstg.net/ng-app/data/election/91/80741/townVotes_Electiondata.json","localFile":"data/ct-2024-ems-election-91-version-80741","level":"town","comparisonContest":"U.S. Senate","parserHint":"Pair office 16518 President with office 16524 U.S. Senator at EMS town grain; fuse Christopher S. Murphy Democratic candidate 35495 and Working Families candidate 35860 by person; Republican Corey candidate 35830."},"turnout":{"sourceTitle":"Connecticut Secretary of the State EMS voterTurnout static JSON","sourceUrl":"https://ctemspublic.tgstg.net/ng-app/data/election/91/80741/voterTurnout_Electiondata.json","localFile":"data/ct-2024-ems-election-91-version-80741","level":"town","denominator":"EMS EV registered/elector field","ballotsCast":"EMS VV voters checked field; warning-required pending EMS/SOV/EAC semantics review"},"statementOfVoteCrossCheck":{"sourceTitle":"2024 Connecticut Statement of Vote PDF","sourceUrl":"https://portal.ct.gov/-/media/sots/electionservices/statementofvote_pdfs/2024_statement_of_vote.pdf?hash=27BE5012F5EF0B6BBF37B2A9242B54A2&rev=21871844f0be463886b823b12e6a442e","localFile":"data/ct-2024-statement-of-vote.pdf","parserHint":"scripts/normalize-ct-2024-statement-of-vote.mjs hash-pins the PDF and extracts all 169 towns/12 tickets from pages 11-34, with exact printed candidate totals and an EMS comparison.","normalizedTownFile":"data/ct-2024-statement-of-vote-president-town.csv","reconciliationSummary":"data/ct-2024-statement-of-vote-president-reconciliation.json"},"coverageInventory":{"sourceTitle":"Connecticut 2024 data coverage and administration source inventory","localFile":"data/ct-2024-data-coverage-inventory.json","parserHint":"Documents EMS/SOV reconciliation caveat, town geometry/crosswalk QA, historical source leads, and remaining admin request paths."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Connecticut 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/9","localFile":"data/ct-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."},"presidentialCountyResults":{"sourceTitle":"Connecticut SOTS certified Statement of Vote town President rows aggregated to current Census planning regions","sourceUrl":"https://portal.ct.gov/-/media/sots/electionservices/statementofvote_pdfs/2024_statement_of_vote.pdf?hash=27BE5012F5EF0B6BBF37B2A9242B54A2&rev=21871844f0be463886b823b12e6a442e","localFile":"data/ct-2024-statement-of-vote-president-town.csv","parserHint":"connecticutEmsTownJson reads 169 certified SOV President rows and aggregates them through data/ct-current-planning-region-crosswalk.csv into nine result rows; EMS town U.S. Senate review and turnout remain at town grain."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb current Connecticut planning-region county-equivalent geometry","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2709%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ct-counties.geojson","appReadyFile":"data/ct-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY","parserHint":"Nine current Census planning-region county-equivalent features keyed GEOID 09110 through 09190."},"electionHistorySourceReview":{"sourceTitle":"Connecticut Election History event 582 source review","sourceUrl":"https://electionhistory.ct.gov/search?","localFile":"data/ct-2024-election-history-source-review.json","parserHint":"Run node scripts/report-ct-election-history-source-review.mjs --checked-at 2026-07-06 --out data/ct-2024-election-history-source-review.json. Use as official President town/vote-channel cross-check only; event 582 voterStats rows are absent and do not replace EMS turnout."},"townBoundary":{"sourceTitle":"U.S. Census TIGERweb current Connecticut county-subdivision geometry","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/tigerWMS_Current/MapServer/22/query?where=STATE%3D%2709%27&outFields=GEOID,STATE,COUNTY,COUSUB,NAME,BASENAME,COUSUBNS&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ct-town-mcds.geojson","parserHint":"Filter five COUSUB=00000 placeholders; the remaining 169 BASENAME values match EMS town names exactly."},"planningRegionCrosswalk":{"sourceTitle":"Reproducible Connecticut EMS town to current Census planning-region crosswalk","localFile":"data/ct-current-planning-region-crosswalk.csv","parserHint":"Generated from exact EMS town-name equals Census BASENAME joins and Census COUNTY/GEOID assignments; identical town ID/name pairs are required across 2016, 2020, and 2024."},"historicalBaseline":{"sourceTitle":"Connecticut SOTS EMS 2016 and 2020 town President results aggregated to current Census planning regions","sourceUrl":"https://ctemspublic.tgstg.net/","localFile":"data/ct-historical-presidential-baseline.csv","level":"current_planning_region_county_equivalent","parserHint":"Official election 1/version 5603 and election 54/version 64824 town rows aggregate to nine county:<GEOID> rows per year and reconcile exactly to EMS stateVotes totals."}},"expected":{"townRows":169,"stateTotal":1759275,"trump":737024,"harris":992197,"other":30054,"localReviewRows":169,"turnoutRows":169,"turnoutBallotsCast":1788981,"turnoutRegisteredVoters":2348545,"countyRows":9,"geometryFeatures":9,"sourceTownRows":169,"historicalBaselineRows":18},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_town_rows_cross_endorsed_lines_fused","turnoutMode":"ems_town_ev_vv_warning_required","geometryStatus":"nine_current_planning_regions_and_exact_169_town_crosswalk_loaded","electionHistoryReview":"event_582_president_totals_confirm_ems_voter_stats_absent_for_turnout_replacement","historicalBaselineMode":"official_2016_2020_ems_towns_aggregated_to_current_planning_regions","presidentMode":"certified_sov_169_towns_12_tickets_exact_printed_totals","sovVersusEmsDifferenceVotes":265,"resultPromotionSafety":"ready_no_presidential_reconciliation_blocker"},"caveats":["U.S. Senate comparison rows fuse Christopher S. Murphy Democratic and Working Families ballot lines by person; keep cross-endorsement caveats visible.","EMS turnout uses EV and VV fields and all rows are warning-required pending EMS/SOV/EAC denominator and ballots-cast semantics review.","Election History event 582 President rows confirm EMS President town/vote-channel totals, but the voterStats-only event search returns zero rows and provides no registered-voter denominator; do not replace EMS turnout or SOV/EAC caveats with Election History.","Town/MCD geometry is collected from Census TIGERweb, but five placeholder features must be filtered and EMS town-name joins QAed before map promotion.","Precinct/ward candidate vote rows, CVR availability, official historical baselines, and normalized audit/recount/CVR/incident/correction/litigation rows remain source-collection gaps.","Certified SOV town President rows total 1,759,275 and supersede EMS version 80741 President values by 265 votes; EMS remains the U.S. Senate comparison and warning-required turnout source.","Current result and historical county-equivalent rows use nine Census planning regions; 2016 and 2020 planning-region rows are current-geography aggregates, not historical election reporting units.","U.S. Senate comparison rows fuse Christopher S. Murphy Democratic and Working Families ballot lines by person.","EMS turnout uses EV and VV fields and remains warning-required pending EMS/SOV/EAC semantics review.","Town/MCD and planning-region geometry plus an exact 169-town crosswalk are loaded; precinct/ward geometry remains missing.","Official 2012 history and normalized audit/recount/CVR/incident/correction/litigation rows remain gaps."],"legacyReferenceBundle":"data/ct-2024-data-coverage-inventory.json"},{"state":"RI","name":"Rhode Island","priority":14,"nativeReadiness":"loaded_county_map_review_eac_turnout_official_2012_2016_2020_historical_promotion_reconciled","authority":"Rhode Island Board of Elections; U.S. Election Assistance Commission","configFile":"etl/state-configs/ri.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Rhode Island BOE 2024 General Election long-format ZIP plus statewide JSON","sourceUrl":"https://www.ri.gov/election/results/2024/general_election/data/","localFile":"data/ri-2024-general-president-city-town.csv","parserHint":"Generated from the explicit finalized rigen2024l.txt root member; nativeRhodeIslandBoeCsv aggregates 39 cities/towns into five county map rows and preserves Federal Precincts as an unforced non-geographic row. President buckets reconcile exactly to posted statewide JSON."},"localReviewRows":{"sourceTitle":"Rhode Island BOE 2024 General Election long-format ZIP President and U.S. Senate rows","sourceUrl":"https://www.ri.gov/election/results/2024/general_election/data/rigen2024l.zip","localFile":"data/ri-2024-general-president-senate-review.csv","level":"reporting_unit","comparisonContest":"U.S. Senate","parserHint":"444 nonzero same-key President-versus-U.S.-Senate review rows; zero-vote Limited rows and presidential-only rows are excluded from review pairing."},"turnout":{"sourceTitle":"EAC 2024 Rhode Island jurisdiction turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ri-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters"},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb Rhode Island county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2744%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/ri-counties.geojson","parserHint":"County geometry is active through native city/town-to-county aggregation. Federal Precincts remain non-geographic and are excluded from county joins."},"historicalBaseline":{"sourceTitle":"Official RI.gov 2012, 2016, and 2020 finalized long-format presidential baselines","sourceUrl":"https://www.ri.gov/election/results/","localFile":"data/ri-historical-presidential-baseline.csv","parserHint":"The normalizer reads explicit finalized ZIP root members and aggregates city/town rows to five county:<GEOID> rows per year while retaining Federal Precincts as an unforced row.","level":"county_plus_unforced_federal_precincts"},"coverageInventory":{"sourceTitle":"Rhode Island 2024 data coverage and administration source inventory","localFile":"data/ri-2024-data-coverage-inventory.json","parserHint":"Documents finalized-root artifacts, exact posted-total reconciliation, EAC turnout fallback, complete 2012/2016/2020 county-aggregated history, and remaining gaps."},"historicalPromotionReconciliation":{"sourceTitle":"Rhode Island live-versus-staging historical promotion reconciliation","sourceUrl":"https://www.civicresultmaps.org/api/historical-baselines?state=RI&limit=5000&includeMetrics=true","localFile":"data/ri-historical-promotion-reconciliation.json","parserHint":"Run scripts/audit-ri-historical-promotion.mjs after RI import. The audit recognizes only the reviewed legacy or canonical live profiles, pins official statewide totals, requires five county tags plus unforced Federal Precincts, reconciles every vote bucket, checks display-grain changes, and verifies RI flip impact before atomically replacing the artifact."}},"expected":{"countyRows":6,"geometryFeatures":5,"stateTotal":513386,"trump":214406,"harris":285156,"other":13824,"localReviewRows":444,"turnoutRows":39,"historicalBaselineRows":18},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_same_key_rows_finalized_root_exact_totals","turnoutMode":"eac_2024_v2_jurisdiction_fallback","historicalBaselineMode":"official_2012_2016_2020_finalized_root_county_aggregation","historicalPromotionAcceptance":"accepted_86_live_to_18_staged_zero_vote_delta_five_tags_per_year_promotion_not_authorized"},"caveats":["The explicit finalized 2024 root member reconciles exactly to posted statewide President and U.S. Senate buckets; normalization fails closed on any mismatch and emits no reconciliation row.","Review rows are advisory context only and exclude zero-vote Limited rows and presidential-only rows.","Turnout remains EAC fallback.","County maps use official city/town-to-county aggregation; finer geometry/crosswalks remain missing.","Official 2012, 2016, and 2020 history is aggregated to five county tags per year plus unforced Federal Precincts. The fail-closed read-only audit accepts replacing 86 live rows with 18 staged rows (a 68-row reduction): every statewide and county/Federal vote bucket has zero delta, all years remain present, and canonical flip reporting identifies Kent County as the sole RI red-to-blue flip for 2016-to-2020 and 2016-to-2024. Acceptance does not itself authorize production promotion.","Normalized audit/recount/CVR/incident/correction/litigation rows are not loaded."],"legacyReferenceBundle":"data/ri-2024-data-coverage-inventory.json","historicalMode":"official_2012_2016_2020_county_aggregated_with_unforced_federal_precincts"},{"state":"DE","name":"Delaware","priority":13,"nativeReadiness":"complete_county_map_election_district_review_eac_turnout_2016_2020_historical","authority":"Delaware Department of Elections; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/de.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Delaware DOE 2024 General Election Results Report","sourceUrl":"https://elections.delaware.gov/reports/GE2024.html","localFile":"data/de-2024-general-election-results-report.html","parserHint":"delawareOfficialReportHtml reads the official By County President and Vice President table and aggregates Democratic, Republican, and other ballot candidates into 3 county rows."},"localReviewRows":{"sourceTitle":"Delaware DOE 2024 General Election Results Report by election district","sourceUrl":"https://elections.delaware.gov/reports/GE2024.html","localFile":"data/de-2024-general-election-results-report.html","level":"election_district","comparisonContest":"U.S. Senate","parserHint":"Pairs positive-vote election-district President rows with same-grain U.S. Senator rows; county labels come from the official AGP report election-district sections."},"turnout":{"sourceTitle":"EAC 2024 Delaware jurisdiction turnout fallback; DOE AGP reconciliation retained","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/de-2024-eac-turnout.csv; data/de-2024-agp-turnout-reconciliation.csv","level":"jurisdiction","denominator":"EAC A1a Total Reg registered voters","ballotsCast":"EAC normalized ballots cast","parserHint":"Active turnout remains eacTurnoutCsv. scripts/normalize-de-agp-turnout.mjs documents AGP registered/voted differences before any future replacement."},"historicalBaseline":{"sourceTitle":"Delaware DOE 2016 raw county export and 2020 official report historical presidential baselines","sourceUrl":"https://elections.delaware.gov/elections/resultsarchive/elect16/elect16_general/data/stwoff_kns.txt; https://elections.delaware.gov/reports/GE2020.html","localFile":"data/de-historical-presidential-baseline.csv","level":"county","parserHint":"Run python scripts/normalize-de-historical-presidential-baseline.py. The normalized historicalPresidentialCsv emits 6 county rows across 2016 and 2020. 2016 totals: Clinton 235,603; Trump 185,127; Other 20,860; Total 441,590. 2020 totals: Biden 296,268; Trump 200,603; Other 7,139; Total 504,010. Official 2012 Delaware baselines remain missing."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2710%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/de-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Delaware 2024 data coverage and administration source inventory","localFile":"data/de-2024-data-coverage-inventory.json","parserHint":"Documents loaded DOE report artifacts, AGP/registration reconciliation, geometry/historical/admin source leads, and remaining caveats."}},"expected":{"countyRows":3,"geometryFeatures":3,"stateTotal":511697,"trump":214351,"harris":289758,"other":7588,"localReviewRows":529,"turnoutRows":3,"historicalBaselineRows":6},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_election_districts","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_agp_reconciliation","historicalMode":"official_doe_county_2016_2020_2012_missing","adminInventoryStatus":"source_paths_documented_not_row_level_loaded"},"caveats":["Review rows are election-district President-versus-U.S.-Senate comparisons from the official DOE report; election-district geometry is not loaded, so map joins remain county-level.","Four zero-vote President election-district tables are excluded from review rows; 529 positive-vote districts have same-grain U.S. Senate rows.","Active turnout remains EAC fallback. DOE AGP registered/voted totals differ from EAC by 423 registered voters and 3,719 voted/ballots-cast statewide, so replacement semantics need review.","Historical baselines and normalized audit/recount/CVR/incident/correction/litigation rows are not loaded.","Official 2016 and 2020 county historical baselines are normalized from Delaware Department of Elections artifacts and resolve to Census county FIPS tags; official 2012 rows remain uncollected."],"legacyReferenceBundle":"data/de-2024-general-election-results-report.html"},{"state":"NJ","name":"New Jersey","priority":13,"nativeReadiness":"complete_county_map_county_review_turnout_admin_inventory_2016_2020_historical","authority":"New Jersey Department of State, Division of Elections; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/nj.json","legacyReferenceBundle":"data/nj-app-data.js","artifacts":{"presidentialCountyResults":{"sourceTitle":"New Jersey DOE official 2024 General Election President statewide PDF","sourceUrl":"https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-president.pdf","localFile":"data/nj-2024-official-general-results-president.pdf; data/nj-2024-general-president-county.csv","parserHint":"Run npm run etl:prepare:nj. scripts/normalize-nj-doe-pdfs.mjs extracts 21 county President rows from the official DOE statewide PDF and reconciles to 4,272,725 votes."},"localReviewRows":{"sourceTitle":"New Jersey DOE official 2024 General Election U.S. Senate statewide PDF","sourceUrl":"https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-us-senate.pdf","localFile":"data/nj-2024-official-general-results-us-senate.pdf; data/nj-2024-general-senate-county.csv","level":"county","comparisonContest":"U.S. Senate","parserHint":"Generated from the official statewide U.S. Senate PDF. Rows are county-level President-versus-U.S.-Senate comparison inputs, not municipal or precinct scatter plots."},"turnout":{"sourceTitle":"New Jersey DOE official 2024 General Election voter turnout PDF","sourceUrl":"https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-voter-turnout.pdf","localFile":"data/nj-2024-official-general-voter-turnout.pdf; data/nj-2024-official-turnout-county.csv; data/nj-2024-turnout-reconciliation-summary.json","level":"county","denominator":"DOE official county registered-voter denominator; EAC fallback retained as benchmark only","ballotsCast":"DOE official county ballots cast","parserHint":"scripts/normalize-nj-doe-pdfs.mjs normalizes 21 county rows and writes the DOE-versus-EAC reconciliation summary."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2734%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/nj-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY","parserHint":"County map joins only; municipal geometry/crosswalks are not loaded."},"coverageInventory":{"sourceTitle":"New Jersey 2024 data coverage and administration source inventory","sourceUrl":"https://www.nj.gov/state/elections/election-information-2024.shtml","localFile":"data/nj-2024-data-coverage-inventory.json","parserHint":"Documents loaded county-level DOE PDF artifacts and remaining municipal, historical, geometry, audit, CVR, recount, incident, correction, and litigation gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier New Jersey 2024 equipment context plus NJ DOE equipment inventory lead","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/34","localFile":"data/nj-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or proof of precinct-uniform equipment."},"historicalBaseline":{"sourceTitle":"New Jersey DOE 2016 county President PDFs and 2020 statewide President PDF historical baselines","sourceUrl":"https://www.nj.gov/state/elections/election-information-2016.shtml; https://www.nj.gov/state/elections/assets/pdf/election-results/2020/2020-official-general-results-president.pdf","localFile":"data/nj-historical-presidential-baseline.csv","level":"county","parserHint":"Run node scripts/normalize-nj-historical-presidential-baseline.mjs. The normalized historicalPresidentialCsv emits 42 county rows across 2016 and 2020. 2016 totals: Clinton 2,148,278; Trump 1,601,933; Other 123,835; Total 3,874,046. 2020 totals: Biden 2,608,400; Trump 1,883,313; Other 57,744; Total 4,549,457. Official 2012 New Jersey baselines remain missing."}},"expected":{"countyRows":21,"geometryFeatures":21,"stateTotal":4272725,"trump":1968215,"harris":2220713,"other":83797,"localReviewRows":21,"turnoutRows":21,"historicalBaselineRows":42},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_senate_county_pdf_rows","turnoutMode":"official_doe_county_turnout_with_eac_benchmark_reconciliation","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized","historicalBaselineMode":"official_doe_2016_2020_county_presidential_pdf_context","historicalMode":"official_doe_pdf_county_2016_2020_2012_missing"},"caveats":["Review rows are county-level President-versus-U.S.-Senate comparisons from official statewide DOE PDFs, not municipal or precinct scatter plots.","Active turnout uses the official DOE county turnout PDF. The retained reconciliation summary records 4,321,921 ballots cast in both DOE and EAC sources, and 6,682,699 DOE registered voters versus 6,630,364 EAC registered voters.","County geometry is loaded; municipal geometry/crosswalks are not loaded.","No normalized New Jersey municipal review rows, historical baseline rows, audit outcomes, CVR availability, recount, incident, correction, or litigation rows are loaded."],"nextAction":"Collect and normalize municipal President/Senate/turnout PDFs, municipal geometry/crosswalks, official 2012 and 2016 historical baselines, and official audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"HI","name":"Hawaii","priority":11,"nativeReadiness":"complete_five_county_map_precinct_split_review_state_native_turnout_2016_2020_historical_context","authority":"Hawaii Office of Elections; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/hi.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Hawaii Office of Elections 2024 General Election text exports","sourceUrl":"https://files.hawaii.gov/elections/files/results/2024/General/summary.txt","localFile":"data/hi-2024-general-summary.txt; data/hi-2024-general-precinct-detail.txt","parserHint":"nativeHawaiiOfficeText decodes the official UTF-16 exports, reconciles certified statewide totals, and emits all five county/county-equivalent rows. Exact precinct 13-09 split IDs 78 and 487 are pinned to Kalawao FIPS 15005 using official election-map and boundary evidence."},"localReviewRows":{"sourceTitle":"Hawaii Office of Elections 2024 General Election precinct detail text export","sourceUrl":"https://files.hawaii.gov/elections/files/results/2024/General/media.txt","localFile":"data/hi-2024-general-precinct-detail.txt","level":"precinct_split","comparisonContest":"U.S. Senate","parserHint":"Pairs President contest 283 and U.S. Senate contest 100 by precinct_splitId for 467 nonzero numbered precinct/split review rows. Excludes 27 zero-vote numbered President keys and three zero-vote non-geographic President keys from advisory rows."},"turnout":{"sourceTitle":"Hawaii Office of Elections Registration and Turnout Statistics 2024 General Election table","sourceUrl":"https://elections.hawaii.gov/resources/registration-voter-turnout-statistics/","localFile":"data/hi-2024-registration-turnout-statistics.html; data/hi-2024-general-turnout.csv; data/hi-2024-turnout-reconciliation-summary.json","level":"county","denominator":"Registered Voters from the Hawaii Office 2024 General Election table","ballotsCast":"Voter Turnout from the Hawaii Office 2024 General Election table","parserHint":"Run node scripts/normalize-hi-turnout.mjs. The normalizer extracts the 2024 General statewide and county rows from the committed Office HTML, writes normalizedTurnoutCsv rows, and asserts four county rows reconcile to 860,868 registered voters and 522,236 turnout."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2715%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/hi-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY","parserHint":"County geometry supports all five loaded result counties. The reviewed official HD 13 map and statewide boundary description identify precinct 13-09 as Kalawao; full precinct geometry remains unloaded."},"coverageInventory":{"sourceTitle":"Hawaii 2024 data coverage and administration source inventory","sourceUrl":"https://elections.hawaii.gov/election-results/","localFile":"data/hi-2024-data-coverage-inventory.json","parserHint":"Documents loaded text exports, EAC turnout fallback, state-native turnout lead, GIS/crosswalk needs, official historical-source paths, and audit/CVR/recount/incident/correction/litigation caveats."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Hawaii 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/15","localFile":"data/hi-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit conclusions, incidents, or precinct-uniformity proof."},"historicalBaseline":{"sourceTitle":"Hawaii Office of Elections 2016 and 2020 General Election summary/detail text exports","sourceUrl":"https://files.hawaii.gov/elections/files/results/2016/general/summary.txt; https://files.hawaii.gov/elections/files/results/2020/general/summary.txt","localFile":"data/hi-historical-presidential-baseline.csv","level":"county","years":[2016,2020],"parserHint":"scripts/normalize-hi-historical-presidential-baseline.mjs emits five county/county-equivalent rows per year. Precinct 13-09 is pinned to county:15005 with exact 2016/2020 vote tuples, Maui residuals, and statewide-zero-delta gates."}},"expected":{"countyRows":5,"geometryFeatures":5,"stateTotal":516701,"trump":193661,"harris":313044,"other":9996,"localReviewRows":467,"turnoutRows":4,"historicalBaselineRows":10},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_precinct_split_nonzero_numbered_units","turnoutMode":"official_hawaii_office_registration_turnout_statistics_county_rows","historicalBaselineMode":"official_2016_2020_five_county_baseline_with_kalawao_15005","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized"},"caveats":["Precinct 13-09 is assigned to Kalawao County FIPS 15005 from official Hawaii election-map and precinct-boundary evidence; exact current and historical tuples and Maui residuals fail closed.","Review rows exclude 27 zero-vote numbered President precinct/split keys and three zero-vote non-geographic President keys; 467 retained review rows still reconcile to the certified statewide total.","Active turnout uses four Hawaii Office election-county rows. The source table does not split Kalawao turnout or registration, so no denominator is invented for FIPS 15005.","County geometry is loaded; full precinct boundaries/crosswalks are not loaded.","Advisory review rows are public-interest source-review inputs only, not findings of fraud or misconduct.","Official 2012 historical baselines and normalized administration-context rows remain missing."],"legacyReferenceBundle":"data/hi-2024-data-coverage-inventory.json","nextAction":"Collect official 2012 historical rows, complete precinct geometry/crosswalks if subcounty overlays are pursued, and normalize administration context."},{"state":"NM","name":"New Mexico","priority":12,"nativeReadiness":"complete_county_result_precinct_review_eac_turnout_2016_2020_historical_with_caveats","authority":"New Mexico Secretary of State; U.S. Election Assistance Commission","configFile":"etl/state-configs/nm.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"New Mexico SOS 2024 President county mapdata API","sourceUrl":"https://electionresults-api.sos.nm.gov/NMResultsAjax.svc/GetMapDataArchive?type=FED&category=CTY&raceID=10079&osn=102&county=0&party=0&electionID=2882","localFile":"data/nm-2024-president-county-mapdata.json","parserHint":"nativeNewMexicoSosMapDataJson reads the official SOS county mapdata response, infers suppressed '*' counts from SOS percentages, and emits 33 county President result rows that reconcile to 923,403 votes."},"localReviewRows":{"sourceTitle":"New Mexico SOS 2024 President and U.S. Senate precinct mapdata APIs","sourceUrl":"https://electionresults.sos.nm.gov/Default.aspx?eid=2882","localFile":"data/nm-2024-president-precinct-mapdata.json; data/nm-2024-senate-precinct-mapdata.json","level":"precinct","comparisonContest":"United States Senator","parserHint":"Pairs President and U.S. Senate rows by county and StatePrecinctID after dropping duplicate county/precinct/candidate rows. The SOS API masks many small counts; parser infers masked counts from percentages. Four zero-vote President precinct keys are skipped, leaving 2,165 nonzero review rows."},"turnout":{"sourceTitle":"EAC 2024 New Mexico jurisdiction turnout fallback plus SOS turnout lead","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports; https://electionresults.sos.nm.gov/VoterTurnoutDetails.aspx?eid=2882; https://www.sos.nm.gov/sos-archive/voter-statistics-data-archive/2024-voter-statistics-data/","localFile":"data/eac-2024-state-turnout/nm-2024-eac-turnout.csv; data/nm-2024-data-coverage-inventory.json; data/nm-2024-source-request-matrix.tsv","level":"jurisdiction_fallback_active_precinct_state_native_lead","denominator":"Active ETL uses EAC registered voters. SOS results system reports eligible voters as a candidate replacement denominator.","parserHint":"Current ETL uses eacTurnoutCsv. SOS turnout details remain a lead until eligible-voter denominator semantics and the 367-ballot SOS-minus-EAC difference are reviewed. The SOS 2024 voter-statistics archive is an OCR/manual-review registration denominator lead only and is not normalized in this branch."},"historicalBaseline":{"sourceTitle":"New Mexico SOS 2020 and 2016 President county mapdata APIs","sourceUrl":"https://www.sos.nm.gov/sos-archive/election-results-archive/","localFile":"data/nm-2020-president-county-mapdata.json; data/nm-2016-president-county-mapdata.json","parserHint":"Official SOS county mapdata API artifacts produce 66 historical baseline rows for 2020 and 2016. The 2012 archive routes to the legacy election statistics hub/PDF path and remains unnormalized."},"coverageInventory":{"sourceTitle":"New Mexico 2024 data coverage and administration source inventory","localFile":"data/nm-2024-data-coverage-inventory.json","parserHint":"Documents loaded SOS API artifacts, EAC turnout fallback, 2012 historical blocker, geometry/admin leads, and remaining caveats."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb New Mexico county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2735%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/nm-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY","parserHint":"County geometry is present for county-level map joins. Precinct/voting-district geometry and result-key crosswalks remain unloaded."},"electionStatsDatabase":{"sourceTitle":"New Mexico SOS Elections Database","sourceUrl":"https://electionstats.sos.nm.gov/","localFile":"data/nm-2024-data-coverage-inventory.json; data/nm-2024-source-request-matrix.tsv","parserHint":"Official searchable database of historical election information from source documents. Retained as source-validation/historical lead; not an active 2024 ETL input."}},"expected":{"countyRows":33,"stateTotal":923403,"trump":423391,"harris":478802,"other":21210,"localReviewRows":2165,"presidentPrecinctKeys":2169,"turnoutRows":33,"historicalBaselineRows":66,"geometryFeatures":33},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_precinct_rows_with_masked_count_inference","turnoutMode":"eac_2024_v2_jurisdiction_fallback","historicalBaselineMode":"official_2020_2016_county_mapdata_2012_blocked"},"caveats":["Official SOS mapdata masks small candidate counts with '*'; the parser infers those counts from SOS percentages and inferred reporting-unit totals.","After inference and de-duplication, President and U.S. Senate precinct totals are each 7 votes below the corresponding county-level official totals; county certified rows remain authoritative.","Review rows are advisory public-interest screening context only and are not evidence of fraud or misconduct.","Active turnout remains EAC fallback until SOS eligible-voter denominator semantics and the 367-ballot SOS-minus-EAC ballots-cast difference are reviewed.","The SOS voter-statistics archive is an official denominator lead but remains inactive pending OCR/manual artifact review and denominator-timing reconciliation.","Precinct geometry/crosswalk, 2012 historical baseline, and normalized audit/CVR/recount/incident/correction/litigation rows are not loaded."],"legacyReferenceBundle":"data/nm-2024-data-coverage-inventory.json"},{"state":"VT","name":"Vermont","priority":13,"nativeReadiness":"complete_county_map_town_district_review_eac_turnout_historical_2016_2020","authority":"Vermont Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau; Verified Voting","configFile":"etl/state-configs/vt.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Vermont SOS official 2024 General Election static federal JSON","sourceUrl":"https://static.electionresults.vermont.gov/elections/67a35c79-05a2-4ae3-a77d-97812256188b-f-20260611153112.json","localFile":"data/vt-2024-official-sources/2024-general-federal.json; data/vt-2024-official-sources/2024-general-manifest.json","parserHint":"nativeVermontStaticElectionJson excludes the duplicated STATE WIDE summary row, joins town/reporting-district rows through the official manifest, and aggregates 14 county President result rows."},"localReviewRows":{"sourceTitle":"Vermont SOS official 2024 General Election static federal JSON","sourceUrl":"https://static.electionresults.vermont.gov/elections/67a35c79-05a2-4ae3-a77d-97812256188b-f-20260611153112.json","localFile":"data/vt-2024-official-sources/2024-general-federal.json; data/vt-2024-official-sources/2024-general-manifest.json","level":"town_reporting_district","comparisonContest":"U.S. Senate","parserHint":"Pairs President and U.S. Senate rows at the same 283-row town/reporting-district grain after manifest-based split-town de-duplication."},"certifiedCanvass":{"sourceTitle":"Vermont SOS official report of the canvassing committee for 2024 statewide offices","sourceUrl":"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","localFile":"data/vt-2024-official-sources/2024-general-certified-canvass.pdf","parserHint":"Reference source for statewide reconciliation totals asserted by nativeVermontStaticElectionJson."},"turnout":{"sourceTitle":"EAC 2024 jurisdiction turnout fallback plus Vermont SOS turnout JSON/PDF leads","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/vt-2024-eac-turnout.csv; data/vt-2024-official-sources/2024-general-turnout.json; data/vt-2024-official-sources/2024-general-voter-turnout.pdf","level":"jurisdiction_fallback_with_state_native_leads","denominator":"Active ETL uses EAC registered voters; SOS turnout JSON/PDF replacement is blocked on denominator timing review.","parserHint":"Current active turnout rows use eacTurnoutCsv: 247 rows, 361,604 ballots cast, and 500,986 registered voters. SOS JSON reports 247 rows, 372,885 voters cast, and 517,051 registered voters; canvass cover page reports 522,600 registered voters."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb Vermont county geography","sourceUrl":"https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2750%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","localFile":"data/vt-counties.geojson","nameProperty":"NAME","codeProperty":"COUNTY"},"coverageInventory":{"sourceTitle":"Vermont 2024 data coverage and source request inventory","sourceUrl":"https://sos.vermont.gov/elections/election-info-resources/elections-results-data/","localFile":"data/vt-2024-data-coverage-inventory.json; data/vt-2024-source-request-matrix.tsv","parserHint":"Documents loaded official result/review artifacts and remaining turnout, geometry, historical, audit, CVR, recount, incident, correction, and litigation gaps."},"equipmentContext":{"sourceTitle":"Verified Voting Verifier Vermont 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/50","localFile":"data/verifiedvoting-vt-2024-equipment.json; data/vt-2024-equipment-context.csv","parserHint":"Context only; do not use for votes, turnout, audit, incidents, or proof every precinct used one configuration."},"historicalBaseline":{"sourceTitle":"Vermont Election Results Archive 2016 and 2020 President municipality CSV downloads","sourceUrl":"https://electionarchive.vermont.gov/elections/download/82048/precincts_include:0/; https://electionarchive.vermont.gov/elections/download/144513/precincts_include:0/","localFile":"data/vt-historical-presidential-baseline.csv","level":"county","years":[2016,2020],"parserHint":"scripts/normalize-vt-historical-presidential-baseline.mjs aggregates official municipality CSV rows to counties using the official VT manifest town/county crosswalk plus explicit abbreviation aliases and writes county:<GEOID> tags."}},"expected":{"countyRows":14,"geometryFeatures":14,"stateTotal":369422,"trump":119395,"harris":235791,"other":14236,"localReviewRows":283,"turnoutRows":247,"historicalBaselineRows":28},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"president_vs_us_senate_town_reporting_district","turnoutMode":"eac_2024_v2_jurisdiction_fallback_with_state_native_leads_collected","adminInventoryStatus":"equipment_context_loaded_audit_cvr_incident_paths_documented_not_normalized","historicalBaselineMode":"loaded_official_2016_2020_county_aggregate_from_sos_archive_municipality_rows"},"caveats":["The official static federal JSON contains a duplicated STATE WIDE summary row; nativeVermontStaticElectionJson excludes it and reconciles the remaining rows to the certified canvass.","U.S. Senate includes a major independent candidate, so dropoff fields are directional source-review inputs only.","Active turnout remains EAC fallback. Vermont SOS turnout JSON/PDF artifacts are retained as state-native leads until denominator timing is reviewed.","County geometry and official 2016/2020 county historical baselines are loaded; town/reporting-district geometry, official 2012 historical baselines, and normalized administration-context rows are not loaded."],"legacyReferenceBundle":"data/vt-2024-data-coverage-inventory.json"},{"state":"WY","name":"Wyoming","priority":20,"nativeReadiness":"complete_county_map_precinct_review_eac_turnout_historical_context_with_denominator_followup","authority":"Wyoming Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau","configFile":"etl/state-configs/wy.json","legacyReferenceBundle":"data/wy-2024-data-coverage-inventory.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Wyoming Secretary of State 2024 General Election Results ZIP","sourceUrl":"https://sos.wyo.gov/Elections/Docs/2024/Results/General/2024_Wyoming_General_Results.zip","localFile":"data/wy-2024-general-results.zip","parserHint":"nativeWyomingSosGeneralZip reads 2024 General Results Summaries - OFFICIAL.xlsx / Statewide Candidates."},"localReviewRows":{"sourceTitle":"Wyoming Secretary of State 2024 County General Precinct-by-Precinct Workbook","sourceUrl":"https://sos.wyo.gov/Elections/Docs/2024/Results/General/2024_Wyoming_General_Results.zip","localFile":"data/wy-2024-general-results.zip","level":"precinct","comparisonContest":"U.S. Senate","parserHint":"nativeWyomingSosGeneralZip pairs President and United States Senator columns from 2024 County General PbP - OFFICIAL.xlsx; zero presidential rows are excluded."},"turnout":{"sourceTitle":"EAC fallback turnout rows with Wyoming SOS total-ballots-cast cross-check","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/wy-2024-eac-turnout.csv","level":"jurisdiction","denominator":"EAC reported registered voters remain active. SOS TBC workbook confirms 271,123 ballots cast but does not replace the denominator.","parserHint":"Current ETL uses eacTurnoutCsv."},"historicalBaseline":{"sourceTitle":"Wyoming Secretary of State official 2012/2016/2020 General Results ZIPs","sourceUrl":"https://sos.wyo.gov/Elections/ElectionResults.aspx","localFile":"data/wy-2012-general-results.zip; data/wy-2016-general-results.zip; data/wy-2020-general-results.zip","level":"county","parserHint":"nativeWyomingSosGeneralZip reads 2016/2020 statewide candidates summaries and aggregates 2012 county PbP workbooks."},"countyBoundary":{"sourceTitle":"U.S. Census Bureau TIGER/Line Wyoming county geometry","sourceUrl":"https://www2.census.gov/geo/tiger/TIGER2024/COUNTY/tl_2024_us_county.zip","localFile":"data/wy-counties.geojson","level":"county","parserHint":"Existing county geometry supports WY county map display; no precinct polygons loaded."},"coverageInventory":{"sourceTitle":"Wyoming Wave 20 data coverage inventory and source request matrix","sourceUrl":"https://sos.wyo.gov/Elections/Docs/2024/2024GeneralResults.aspx","localFile":"data/wy-2024-data-coverage-inventory.json; data/wy-2024-source-request-matrix.tsv","parserHint":"Documents loaded official artifacts and remaining official-source requests."},"equipmentContext":{"sourceTitle":"Verified Voting Wyoming 2024 equipment context","sourceUrl":"https://verifiedvoting.org/verifier/","localFile":"data/wy-2024-equipment-context.csv; data/verifiedvoting-wy-2024-equipment.json","level":"county","parserHint":"Supplemental context only; official results remain SOS artifacts."}},"expected":{"countyRows":23,"geometryFeatures":23,"stateTotal":269048,"trump":192633,"harris":69527,"other":6888,"localReviewRows":431,"turnoutRows":23,"historicalBaselineRows":69},"validationStatus":{"localArtifactsPresent":true,"stateConfigUpdated":true,"nativeImportReady":true,"productionPromoted":false},"caveats":["EAC fallback registered-voter denominator remains active until a state-native denominator artifact is collected and reconciled.","Precinct boundary geometry is not loaded; review rows are localUnit rows, not precinct polygons.","Audit, CVR, recount, incident, correction, and litigation records remain request-tracked only.","Advisory indicators are not evidence of fraud or misconduct."]},{"state":"AK","name":"Alaska","priority":0,"nativeReadiness":"statewide_results_with_30_county_equivalent_registry_tags_no_exact_allocation","authority":"Alaska Division of Elections; U.S. Census Bureau","configFile":"etl/state-configs/ak.json","legacyReferenceBundle":"data/ak-2024-data-coverage-inventory.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"Alaska Division of Elections 2024 General Election Summary","sourceUrl":"https://www.elections.alaska.gov/results/24GENR/ElectionSummaryReport.pdf","localFile":"data/ak-2024-general-president-statewide.csv","parserHint":"Official certified presidential totals remain one statewide, untagged row; no county-equivalent allocation is inferred."},"localReviewRows":{"sourceTitle":"Alaska Division of Elections ENR by precinct export","sourceUrl":"https://www.elections.alaska.gov/results/24GENR/ENRbyPrecinct.csv","localFile":"data/ak-2024-general-enr-by-precinct.csv; data/ak-2024-general-precinct-president-us-house-review.csv","level":"precinct_reporting_unit","parserHint":"Reporting units include district-only absentee, early, and questioned ballots and are not forced into county FIPS tags."},"turnout":{"sourceTitle":"EAC 2024 Alaska statewide turnout fallback","sourceUrl":"https://www.eac.gov/research-and-data/studies-and-reports","localFile":"data/eac-2024-state-turnout/ak-2024-eac-turnout.csv","level":"state","parserHint":"Statewide fallback only; no county-equivalent turnout denominator is inferred."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb current Alaska county-equivalent geography","sourceUrl":"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","localFile":"data/ak-counties.geojson","parserHint":"All 30 current county-equivalent FIPS tags are canonical metadata only until an exact election-result crosswalk exists."}},"expected":{"countyRows":0,"geometryFeatures":30,"stateTotal":338177,"trump":184458,"harris":140026,"other":13693,"localReviewRows":523,"turnoutRows":1},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"official_reporting_units_unforced","turnoutMode":"statewide_fallback","countyFipsStatus":"30_current_registry_tags_no_exact_result_allocation"},"caveats":["Twelve 2024 House districts span multiple county equivalents and contain district-only ballots; assigning those votes to county FIPS would fabricate geography.","The 2016 Valdez-Cordova vintage split also requires a reviewed current-geography allocation.","Alaska result rows remain statewide and untagged while the 30 current Census county-equivalent tags are queryable as canonical metadata."],"nextAction":"Request official county-equivalent totals or ballot-to-home-precinct mappings for 2016, 2020, and 2024."},{"state":"DC","name":"District of Columbia","priority":0,"nativeReadiness":"complete_single_county_equivalent_2016_2020_2024","authority":"District of Columbia Board of Elections; U.S. Census Bureau","configFile":"etl/state-configs/dc.json","legacyReferenceBundle":"data/dc-presidential-normalization-summary.json","artifacts":{"presidentialCountyResults":{"sourceTitle":"D.C. Board of Elections 2024 certified precinct results","sourceUrl":"https://electionresults.dcboe.org/Downloads/Reports/November_5_2024_General_Election_Certified_Results.csv","localFile":"data/dc-2024-general-election-certified-results.csv; data/dc-2024-general-president-county-equivalent.csv","parserHint":"scripts/normalize-dc-certified-results.mjs verifies the official source hash and aggregates candidate votes to county:11001."},"localReviewRows":{"sourceTitle":"D.C. Board of Elections certified result export","sourceUrl":"https://electionresults.dcboe.org/Downloads/Reports/November_5_2024_General_Election_Certified_Results.csv","localFile":"data/dc-presidential-normalization-summary.json","level":"not_loaded","parserHint":"No same-grain comparison contest is loaded; the summary records this explicit zero-row scope."},"turnout":{"sourceTitle":"D.C. Board of Elections certified result export","sourceUrl":"https://electionresults.dcboe.org/Downloads/Reports/November_5_2024_General_Election_Certified_Results.csv","localFile":"data/dc-presidential-normalization-summary.json","level":"not_loaded","parserHint":"Candidate totals are loaded; a reviewed registration/ballots-cast denominator package is not yet active."},"countyBoundary":{"sourceTitle":"U.S. Census TIGERweb District of Columbia county-equivalent geography","sourceUrl":"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","localFile":"data/dc-counties.geojson","parserHint":"Single county-equivalent GEOID 11001."}},"expected":{"countyRows":1,"geometryFeatures":1,"stateTotal":325869,"trump":21076,"harris":294185,"other":10608,"localReviewRows":0,"turnoutRows":0,"historicalBaselineRows":2},"validationStatus":{"localArtifactsPresent":true,"generatedBundleTotalsReconcile":true,"reviewMode":"not_loaded","turnoutMode":"not_loaded","historicalBaselineMode":"official_2016_2020_single_county_equivalent"},"caveats":["D.C. is one Census county-equivalent; official precinct votes aggregate exactly to county:11001.","Overvotes and undervotes are reconciled but excluded from candidate-vote totals.","Review and turnout denominator packages are not yet loaded."],"nextAction":"Add a same-grain comparison contest and reviewed turnout denominator if needed; county FIPS coverage is complete."}]},"meta":{"generatedAt":"2026-07-26T17:01:56.043Z","source":"database","releaseId":null,"schemaVersion":"1.0.0","packageCount":39,"state":null}}