{"data":[{"state":"AL","name":"Alabama","authority":"Alabama Secretary of State; U.S. Election Assistance Commission","resultRows":201,"resultJurisdictions":67,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":67,"taggedResultJurisdictions":67,"historical2020Jurisdictions":67,"taggedHistorical2020Jurisdictions":67,"matchedHistorical2020Jurisdictions":67,"missingHistorical2020Jurisdictions":0},"sourceCount":12,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":70,"countyIndicatorCount":70,"flaggedCountyJurisdictions":58,"flaggedAreas":58,"reviewRowCount":2083,"turnoutRowCount":67,"historicalRowCount":201,"equipmentRowCount":67,"flaggedJurisdictions":58,"importRunCount":13,"legacyImportCount":6,"latestImportAt":"2026-07-03T03:40:52.936Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":30062,"nativeResultRows":67,"nativeReviewRows":2083,"nativeTrumpVotes":1462616,"storedResultRows":201,"storedReviewRows":2083,"nativeBallotsCast":2272911,"nativeHarrisVotes":772412,"nativeTurnoutRows":67,"storedTurnoutRows":67,"nativeReviewWarning":"Alabama review rows are President-versus-U.S. House comparisons from official SOS county XLS matrices. U.S. House is district-based and some split-district or absentee/provisional columns aggregate district coverage, so these rows are directional public-interest review signals, not findings.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":70,"nativeComparisonRows":2083,"nativeHistoricalRows":201,"storedHistoricalRows":201,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":3868040,"nativeResultTotalVotes":2265090,"nativeComparisonContest":"U.S. House","nativeHistoricalWarning":"Alabama historical baseline rows are official county-level presidential context from SOS 2012, 2016, and 2020 artifacts. Use them as context only, not as 2024 certified data.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":"Official Alabama SOS precinct XLS ZIP rows paired at county/precinct/reporting-mode column grain where U.S. House cells have explicit nonzero coverage; U.S. House is district-based and no 2024 Alabama U.S. Senate race existed."},"latestNativeImportSummary":{"nativeOtherVotes":30062,"nativeResultRows":67,"nativeReviewRows":2083,"nativeTrumpVotes":1462616,"storedResultRows":201,"storedReviewRows":2083,"nativeBallotsCast":2272911,"nativeHarrisVotes":772412,"nativeTurnoutRows":67,"storedTurnoutRows":67,"nativeReviewWarning":"Alabama review rows are President-versus-U.S. House comparisons from official SOS county XLS matrices. U.S. House is district-based and some split-district or absentee/provisional columns aggregate district coverage, so these rows are directional public-interest review signals, not findings.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":70,"nativeComparisonRows":2083,"nativeHistoricalRows":201,"storedHistoricalRows":201,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":3868040,"nativeResultTotalVotes":2265090,"nativeComparisonContest":"U.S. House","nativeHistoricalWarning":"Alabama historical baseline rows are official county-level presidential context from SOS 2012, 2016, and 2020 artifacts. Use them as context only, not as 2024 certified data.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":"Official Alabama SOS precinct XLS ZIP rows paired at county/precinct/reporting-mode column grain where U.S. House cells have explicit nonzero coverage; U.S. House is district-based and no 2024 Alabama U.S. Senate race existed."},"latestParser":"nativeCountyPresidentCsv","nativeImportCount":4,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"AK","name":"Alaska","authority":"Alaska Division of Elections; U.S. Election Assistance Commission","resultRows":3,"resultJurisdictions":1,"historicalJoinReady":false,"jurisdictionTagCoverage":{"resultJurisdictions":1,"taggedResultJurisdictions":0,"historical2020Jurisdictions":0,"taggedHistorical2020Jurisdictions":0,"matchedHistorical2020Jurisdictions":0,"missingHistorical2020Jurisdictions":0},"sourceCount":14,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":2,"countyIndicatorCount":2,"flaggedCountyJurisdictions":1,"flaggedAreas":1,"reviewRowCount":523,"turnoutRowCount":1,"historicalRowCount":0,"equipmentRowCount":1,"flaggedJurisdictions":1,"importRunCount":12,"legacyImportCount":4,"latestImportAt":"2026-07-06T04:03:53.153Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":13693,"nativeResultRows":1,"nativeReviewRows":523,"nativeTrumpVotes":184458,"storedResultRows":3,"storedReviewRows":523,"nativeBallotsCast":340981,"nativeHarrisVotes":140026,"nativeTurnoutRows":1,"storedTurnoutRows":1,"nativeReviewWarning":"Alaska review coverage uses official ENR precinct/reporting-unit President and U.S. Representative named-candidate first-choice rows. Alaska used ranked-choice voting for U.S. House; the ENR precinct CSV does not itemize U.S. House write-in rows, leaving a 750-vote statewide write-in gap versus the summary PDF. Rows include Election Day precincts plus absentee, early, question, and remote reporting units and are not geometry-ready precinct polygons.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":2,"nativeComparisonRows":523,"storedHistoricalRows":0,"nativeRegisteredVoters":611078,"nativeResultTotalVotes":338177,"nativeComparisonContest":"U.S. Representative first-choice votes","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":""},"latestNativeImportSummary":{"nativeOtherVotes":13693,"nativeResultRows":1,"nativeReviewRows":523,"nativeTrumpVotes":184458,"storedResultRows":3,"storedReviewRows":523,"nativeBallotsCast":340981,"nativeHarrisVotes":140026,"nativeTurnoutRows":1,"storedTurnoutRows":1,"nativeReviewWarning":"Alaska review coverage uses official ENR precinct/reporting-unit President and U.S. Representative named-candidate first-choice rows. Alaska used ranked-choice voting for U.S. House; the ENR precinct CSV does not itemize U.S. House write-in rows, leaving a 750-vote statewide write-in gap versus the summary PDF. Rows include Election Day precincts plus absentee, early, question, and remote reporting units and are not geometry-ready precinct polygons.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":2,"nativeComparisonRows":523,"storedHistoricalRows":0,"nativeRegisteredVoters":611078,"nativeResultTotalVotes":338177,"nativeComparisonContest":"U.S. Representative first-choice votes","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":""},"latestParser":"nativeAlaskaStatewideSummaryCsv","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":false,"reviewGraphs":true,"turnout":true,"historicalBaseline":false,"notes":"Native official-source ETL promotion."},"status":"results_only","gaps":["Map capability pending","Historical baseline pending","1 result jurisdiction missing canonical tags"]},{"state":"AZ","name":"Arizona","authority":"Arizona Secretary of State","resultRows":45,"resultJurisdictions":15,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":15,"taggedResultJurisdictions":15,"historical2020Jurisdictions":15,"taggedHistorical2020Jurisdictions":15,"matchedHistorical2020Jurisdictions":15,"missingHistorical2020Jurisdictions":0},"sourceCount":7,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":14,"countyIndicatorCount":14,"flaggedCountyJurisdictions":14,"flaggedAreas":14,"reviewRowCount":15,"turnoutRowCount":15,"historicalRowCount":45,"equipmentRowCount":15,"flaggedJurisdictions":14,"importRunCount":20,"legacyImportCount":5,"latestImportAt":"2026-07-12T17:07:55.642Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":37059,"nativeResultRows":15,"nativeReviewRows":15,"nativeTrumpVotes":1770242,"storedResultRows":45,"storedReviewRows":15,"nativeBallotsCast":3428011,"nativeHarrisVotes":1582860,"nativeTurnoutRows":15,"storedTurnoutRows":15,"nativeReviewWarning":"Arizona review rows are county-level President-versus-U.S. Senate comparisons from signed canvass county totals. They are useful for statewide county review, but they are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":14,"nativeComparisonRows":15,"nativeHistoricalRows":45,"storedHistoricalRows":45,"historicalReviewYears":[2016,2020],"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":4367593,"nativeResultTotalVotes":3390161,"storedReviewRowsByYear":{"2016":15,"2020":15,"2024":15},"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Arizona historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with state-source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0,"storedIndicatorRowsByYear":{"2016":10,"2020":1,"2024":14},"nativeHistoricalReviewRows":30,"storedHistoricalReviewRows":30,"nativeHistoricalReviewYears":[2016,2020],"nativeHistoricalReviewWarning":"Arizona historical advisory rows compare official county presidential and U.S. Senate totals for 2016 and 2020. They are county-level screening context, not precinct scatter-plot evidence. Candidate and contest differences, split-ticket voting, and participation differences can explain observed patterns; advisory indicators are not findings of fraud or misconduct.","storedHistoricalIndicatorRows":11,"nativeHistoricalReviewRowsByYear":{"2016":15,"2020":15},"nativeHistoricalReviewComparisonRows":30},"latestNativeImportSummary":{"nativeOtherVotes":37059,"nativeResultRows":15,"nativeReviewRows":15,"nativeTrumpVotes":1770242,"storedResultRows":45,"storedReviewRows":15,"nativeBallotsCast":3428011,"nativeHarrisVotes":1582860,"nativeTurnoutRows":15,"storedTurnoutRows":15,"nativeReviewWarning":"Arizona review rows are county-level President-versus-U.S. Senate comparisons from signed canvass county totals. They are useful for statewide county review, but they are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":14,"nativeComparisonRows":15,"nativeHistoricalRows":45,"storedHistoricalRows":45,"historicalReviewYears":[2016,2020],"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":4367593,"nativeResultTotalVotes":3390161,"storedReviewRowsByYear":{"2016":15,"2020":15,"2024":15},"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Arizona historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with state-source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0,"storedIndicatorRowsByYear":{"2016":10,"2020":1,"2024":14},"nativeHistoricalReviewRows":30,"storedHistoricalReviewRows":30,"nativeHistoricalReviewYears":[2016,2020],"nativeHistoricalReviewWarning":"Arizona historical advisory rows compare official county presidential and U.S. Senate totals for 2016 and 2020. They are county-level screening context, not precinct scatter-plot evidence. Candidate and contest differences, split-ticket voting, and participation differences can explain observed patterns; advisory indicators are not findings of fraud or misconduct.","storedHistoricalIndicatorRows":11,"nativeHistoricalReviewRowsByYear":{"2016":15,"2020":15},"nativeHistoricalReviewComparisonRows":30},"latestParser":"nativeArizonaCanvassCountyCsv","nativeImportCount":12,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"AR","name":"Arkansas","authority":"Arkansas Secretary of State","resultRows":225,"resultJurisdictions":75,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":75,"taggedResultJurisdictions":75,"historical2020Jurisdictions":75,"taggedHistorical2020Jurisdictions":75,"matchedHistorical2020Jurisdictions":75,"missingHistorical2020Jurisdictions":0},"sourceCount":7,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":117,"countyIndicatorCount":117,"flaggedCountyJurisdictions":71,"flaggedAreas":71,"reviewRowCount":2779,"turnoutRowCount":73,"historicalRowCount":225,"equipmentRowCount":75,"flaggedJurisdictions":71,"importRunCount":13,"legacyImportCount":5,"latestImportAt":"2026-07-02T23:09:30.496Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":26530,"nativeResultRows":75,"nativeReviewRows":2779,"nativeTrumpVotes":759241,"storedResultRows":225,"storedReviewRows":2779,"nativeBallotsCast":1122278,"nativeHarrisVotes":396905,"nativeTurnoutRows":73,"storedTurnoutRows":73,"nativeReviewWarning":"Arkansas review rows use official TotalResults county-scoped federal reporting-unit IDs for President-versus-U.S. House comparisons. The API exposes stable local result IDs but not human-readable precinct names; review rows are advisory screening inputs, not confirmed findings.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":117,"nativeComparisonRows":2778,"nativeHistoricalRows":225,"storedHistoricalRows":225,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":1750202,"nativeResultTotalVotes":1182676,"nativeComparisonContest":"United States House","nativeHistoricalWarning":"Arkansas historical baseline rows are county-level presidential context for 2012, 2016, and 2020. Rows for 2016 and 2020 are official Arkansas Secretary of State TotalResults API rows; 2012 uses a secondary county table because the official 2012 TotalResults archive entry returned no script-readable contest data in this pass. Use as contextual baseline rows only.","nativeTurnoutWarningRows":1,"nativeMissingComparisonRows":1},"latestNativeImportSummary":{"nativeOtherVotes":26530,"nativeResultRows":75,"nativeReviewRows":2779,"nativeTrumpVotes":759241,"storedResultRows":225,"storedReviewRows":2779,"nativeBallotsCast":1122278,"nativeHarrisVotes":396905,"nativeTurnoutRows":73,"storedTurnoutRows":73,"nativeReviewWarning":"Arkansas review rows use official TotalResults county-scoped federal reporting-unit IDs for President-versus-U.S. House comparisons. The API exposes stable local result IDs but not human-readable precinct names; review rows are advisory screening inputs, not confirmed findings.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":117,"nativeComparisonRows":2778,"nativeHistoricalRows":225,"storedHistoricalRows":225,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":1750202,"nativeResultTotalVotes":1182676,"nativeComparisonContest":"United States House","nativeHistoricalWarning":"Arkansas historical baseline rows are county-level presidential context for 2012, 2016, and 2020. Rows for 2016 and 2020 are official Arkansas Secretary of State TotalResults API rows; 2012 uses a secondary county table because the official 2012 TotalResults archive entry returned no script-readable contest data in this pass. Use as contextual baseline rows only.","nativeTurnoutWarningRows":1,"nativeMissingComparisonRows":1},"latestParser":"nativeArkansasTotalResultsFederalJson","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"CA","name":"California","authority":"California Secretary of State","resultRows":174,"resultJurisdictions":58,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":58,"taggedResultJurisdictions":58,"historical2020Jurisdictions":58,"taggedHistorical2020Jurisdictions":58,"matchedHistorical2020Jurisdictions":58,"missingHistorical2020Jurisdictions":0},"sourceCount":10,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":5,"countyIndicatorCount":5,"flaggedCountyJurisdictions":5,"flaggedAreas":5,"reviewRowCount":58,"turnoutRowCount":58,"historicalRowCount":174,"equipmentRowCount":58,"flaggedJurisdictions":5,"importRunCount":11,"legacyImportCount":4,"latestImportAt":"2026-07-06T04:04:28.137Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":507599,"nativeResultRows":58,"nativeReviewRows":58,"nativeTrumpVotes":6081697,"storedResultRows":174,"storedReviewRows":58,"nativeBallotsCast":16140044,"nativeHarrisVotes":9276179,"nativeTurnoutRows":58,"storedTurnoutRows":58,"nativeReviewWarning":"California review rows are county-level President-versus-U.S. Senate full-term comparisons from official Statement of Vote county totals. They are useful for county-level context, but they are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":5,"nativeComparisonRows":58,"nativeHistoricalRows":174,"storedHistoricalRows":174,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":22595659,"nativeResultTotalVotes":15865475,"nativeComparisonContest":"United States Senator (Full Term)","nativeHistoricalWarning":"California historical baseline rows are official county-level presidential results from 2012, 2016, and 2020 Statement of Vote workbooks. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":507599,"nativeResultRows":58,"nativeReviewRows":58,"nativeTrumpVotes":6081697,"storedResultRows":174,"storedReviewRows":58,"nativeBallotsCast":16140044,"nativeHarrisVotes":9276179,"nativeTurnoutRows":58,"storedTurnoutRows":58,"nativeReviewWarning":"California review rows are county-level President-versus-U.S. Senate full-term comparisons from official Statement of Vote county totals. They are useful for county-level context, but they are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":5,"nativeComparisonRows":58,"nativeHistoricalRows":174,"storedHistoricalRows":174,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":22595659,"nativeResultTotalVotes":15865475,"nativeComparisonContest":"United States Senator (Full Term)","nativeHistoricalWarning":"California historical baseline rows are official county-level presidential results from 2012, 2016, and 2020 Statement of Vote workbooks. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0},"latestParser":"nativeCaliforniaCountyPresidentCsv","nativeImportCount":4,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"CO","name":"Colorado","authority":"U.S. Election Assistance Commission","resultRows":192,"resultJurisdictions":64,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":64,"taggedResultJurisdictions":64,"historical2020Jurisdictions":64,"taggedHistorical2020Jurisdictions":64,"matchedHistorical2020Jurisdictions":64,"missingHistorical2020Jurisdictions":0},"sourceCount":13,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":60,"countyIndicatorCount":60,"flaggedCountyJurisdictions":60,"flaggedAreas":60,"reviewRowCount":64,"turnoutRowCount":64,"historicalRowCount":128,"equipmentRowCount":64,"flaggedJurisdictions":60,"importRunCount":17,"legacyImportCount":7,"latestImportAt":"2026-07-11T02:53:31.616Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":85273,"nativeResultRows":64,"nativeReviewRows":64,"nativeTrumpVotes":1377441,"storedResultRows":192,"storedReviewRows":64,"nativeBallotsCast":3241155,"nativeHarrisVotes":1728159,"nativeTurnoutRows":64,"storedTurnoutRows":64,"nativeReviewWarning":"Colorado review rows are county-level President-versus-CU-Regent-at-large comparisons from the official Secretary of State Clarity detail XML ZIP. The loaded presidential candidate rows are 1,872 votes below the prior Abstract/certified-total lead, so use these as official county source-review inputs rather than a write-in-inclusive certified total. They are not precinct scatter-plot coverage and not confirmed findings.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":60,"nativeComparisonRows":64,"nativeHistoricalRows":128,"storedHistoricalRows":128,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":4583280,"nativeResultTotalVotes":3190873,"nativeComparisonContest":"Regent of the University of Colorado - At Large","nativeHistoricalWarning":"Colorado historical baseline rows are official county-level 2016 and 2020 General Election President results from Colorado Secretary of State Historical Election Data contest exports. Use them as contextual baseline rows for jurisdictionTag county flip joins, not as 2024 certified data. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeColoradoCertifiedVoteGap":1872,"nativeColoradoClarityTurnoutRows":64,"nativeColoradoClarityBallotsCastLead":3241120,"nativeColoradoClarityTotalVotersLead":4058938},"latestNativeImportSummary":{"nativeOtherVotes":85273,"nativeResultRows":64,"nativeReviewRows":64,"nativeTrumpVotes":1377441,"storedResultRows":192,"storedReviewRows":64,"nativeBallotsCast":3241155,"nativeHarrisVotes":1728159,"nativeTurnoutRows":64,"storedTurnoutRows":64,"nativeReviewWarning":"Colorado review rows are county-level President-versus-CU-Regent-at-large comparisons from the official Secretary of State Clarity detail XML ZIP. The loaded presidential candidate rows are 1,872 votes below the prior Abstract/certified-total lead, so use these as official county source-review inputs rather than a write-in-inclusive certified total. They are not precinct scatter-plot coverage and not confirmed findings.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":60,"nativeComparisonRows":64,"nativeHistoricalRows":128,"storedHistoricalRows":128,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":4583280,"nativeResultTotalVotes":3190873,"nativeComparisonContest":"Regent of the University of Colorado - At Large","nativeHistoricalWarning":"Colorado historical baseline rows are official county-level 2016 and 2020 General Election President results from Colorado Secretary of State Historical Election Data contest exports. Use them as contextual baseline rows for jurisdictionTag county flip joins, not as 2024 certified data. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeColoradoCertifiedVoteGap":1872,"nativeColoradoClarityTurnoutRows":64,"nativeColoradoClarityBallotsCastLead":3241120,"nativeColoradoClarityTotalVotersLead":4058938},"latestParser":"nativeColoradoClarityDetailXml","nativeImportCount":7,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"CT","name":"Connecticut","authority":"Connecticut Secretary of the State; U.S. Election Assistance Commission; U.S. Census Bureau","resultRows":27,"resultJurisdictions":9,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":9,"taggedResultJurisdictions":9,"historical2020Jurisdictions":9,"taggedHistorical2020Jurisdictions":0,"matchedHistorical2020Jurisdictions":9,"missingHistorical2020Jurisdictions":0},"sourceCount":17,"mapGeometrySourceCount":3,"sourcesMissingUrls":0,"indicatorCount":12,"countyIndicatorCount":12,"flaggedCountyJurisdictions":7,"flaggedAreas":7,"reviewRowCount":169,"turnoutRowCount":169,"historicalRowCount":18,"equipmentRowCount":8,"flaggedJurisdictions":7,"importRunCount":14,"legacyImportCount":6,"latestImportAt":"2026-07-11T02:54:09.918Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":30054,"nativeResultRows":9,"nativeReviewRows":169,"nativeTrumpVotes":737024,"storedResultRows":27,"storedReviewRows":169,"nativeBallotsCast":1788981,"nativeHarrisVotes":992197,"nativeTurnoutRows":169,"storedTurnoutRows":169,"nativeReviewWarning":"Connecticut review rows compare certified Statement of Vote town President values with EMS version 80741 U.S. Senate values and fuse Christopher S. Murphy Democratic and Working Families ballot lines by person. They are town-level public-interest screening inputs only, not precinct-level findings.","nativeTurnoutParser":"connecticutEmsTownJson","storedIndicatorRows":12,"nativeComparisonRows":169,"nativeHistoricalRows":18,"nativeTownResultRows":169,"storedHistoricalRows":18,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":2348545,"nativeResultTotalVotes":1759275,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Connecticut historical baselines are official EMS 2016 and 2020 town President results aggregated reproducibly to the nine current Census planning-region county-equivalents for jurisdictionTag comparisons. Planning regions were not the historical election reporting units. Official 2012 rows remain uncollected.","nativePresidentSourceId":"ct-2024-statement-of-vote-president-town","nativeComparisonDemVotes":1000695,"nativeComparisonRepVotes":678256,"nativeComparisonSourceId":"ct-2024-ems-election-91-version-80741","nativePlanningRegionRows":9,"nativeTurnoutWarningRows":169,"nativeComparisonOtherVotes":29308,"nativeEmsPresidentTotalVotes":1759010,"nativeStatementOfVoteTownRows":169,"nativePlanningRegionTownCounts":{"09110":38,"09120":6,"09130":17,"09140":19,"09150":16,"09160":21,"09170":15,"09180":19,"09190":18},"nativePlanningRegionCrosswalkRows":169,"nativeStatementOfVoteAdjustmentVotes":265},"latestNativeImportSummary":{"nativeOtherVotes":30054,"nativeResultRows":9,"nativeReviewRows":169,"nativeTrumpVotes":737024,"storedResultRows":27,"storedReviewRows":169,"nativeBallotsCast":1788981,"nativeHarrisVotes":992197,"nativeTurnoutRows":169,"storedTurnoutRows":169,"nativeReviewWarning":"Connecticut review rows compare certified Statement of Vote town President values with EMS version 80741 U.S. Senate values and fuse Christopher S. Murphy Democratic and Working Families ballot lines by person. They are town-level public-interest screening inputs only, not precinct-level findings.","nativeTurnoutParser":"connecticutEmsTownJson","storedIndicatorRows":12,"nativeComparisonRows":169,"nativeHistoricalRows":18,"nativeTownResultRows":169,"storedHistoricalRows":18,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":2348545,"nativeResultTotalVotes":1759275,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Connecticut historical baselines are official EMS 2016 and 2020 town President results aggregated reproducibly to the nine current Census planning-region county-equivalents for jurisdictionTag comparisons. Planning regions were not the historical election reporting units. Official 2012 rows remain uncollected.","nativePresidentSourceId":"ct-2024-statement-of-vote-president-town","nativeComparisonDemVotes":1000695,"nativeComparisonRepVotes":678256,"nativeComparisonSourceId":"ct-2024-ems-election-91-version-80741","nativePlanningRegionRows":9,"nativeTurnoutWarningRows":169,"nativeComparisonOtherVotes":29308,"nativeEmsPresidentTotalVotes":1759010,"nativeStatementOfVoteTownRows":169,"nativePlanningRegionTownCounts":{"09110":38,"09120":6,"09130":17,"09140":19,"09150":16,"09160":21,"09170":15,"09180":19,"09190":18},"nativePlanningRegionCrosswalkRows":169,"nativeStatementOfVoteAdjustmentVotes":265},"latestParser":"nativeConnecticutEmsTownJson","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"DE","name":"Delaware","authority":"Delaware Department of Elections; U.S. Election Assistance Commission","resultRows":9,"resultJurisdictions":3,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":3,"taggedResultJurisdictions":3,"historical2020Jurisdictions":3,"taggedHistorical2020Jurisdictions":3,"matchedHistorical2020Jurisdictions":3,"missingHistorical2020Jurisdictions":0},"sourceCount":18,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":6,"countyIndicatorCount":6,"flaggedCountyJurisdictions":3,"flaggedAreas":3,"reviewRowCount":529,"turnoutRowCount":3,"historicalRowCount":6,"equipmentRowCount":3,"flaggedJurisdictions":3,"importRunCount":16,"legacyImportCount":7,"latestImportAt":"2026-07-11T02:54:47.838Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":7588,"nativeResultRows":3,"nativeReviewRows":529,"nativeTrumpVotes":214351,"storedResultRows":9,"storedReviewRows":529,"nativeBallotsCast":514367,"nativeHarrisVotes":289758,"nativeTurnoutRows":3,"storedTurnoutRows":3,"nativeReviewWarning":"Delaware review rows are election-district President versus U.S. Senate comparisons from the official DOE report. County labels come from the official AGP report; election-district geometry/crosswalks are not loaded.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":6,"nativeComparisonRows":529,"nativeHistoricalRows":6,"storedHistoricalRows":6,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":788441,"nativeResultTotalVotes":511697,"nativeComparisonContest":"U.S. Senator","nativeHistoricalWarning":"Delaware historical baseline rows are official county-level 2016 and 2020 General Election President results from Delaware Department of Elections artifacts. Use them as contextual baseline rows for jurisdictionTag county flip joins, not as 2024 certified data. The 2016 raw export labels New Castle County as Wilmington. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":7588,"nativeResultRows":3,"nativeReviewRows":529,"nativeTrumpVotes":214351,"storedResultRows":9,"storedReviewRows":529,"nativeBallotsCast":514367,"nativeHarrisVotes":289758,"nativeTurnoutRows":3,"storedTurnoutRows":3,"nativeReviewWarning":"Delaware review rows are election-district President versus U.S. Senate comparisons from the official DOE report. County labels come from the official AGP report; election-district geometry/crosswalks are not loaded.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":6,"nativeComparisonRows":529,"nativeHistoricalRows":6,"storedHistoricalRows":6,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":788441,"nativeResultTotalVotes":511697,"nativeComparisonContest":"U.S. Senator","nativeHistoricalWarning":"Delaware historical baseline rows are official county-level 2016 and 2020 General Election President results from Delaware Department of Elections artifacts. Use them as contextual baseline rows for jurisdictionTag county flip joins, not as 2024 certified data. The 2016 raw export labels New Castle County as Wilmington. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0},"latestParser":"nativeDelawareOfficialReportHtml","nativeImportCount":6,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"DC","name":"District of Columbia","authority":"District of Columbia Board of Elections; U.S. Census Bureau","resultRows":3,"resultJurisdictions":1,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":1,"taggedResultJurisdictions":1,"historical2020Jurisdictions":1,"taggedHistorical2020Jurisdictions":1,"matchedHistorical2020Jurisdictions":1,"missingHistorical2020Jurisdictions":0},"sourceCount":7,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":0,"countyIndicatorCount":0,"flaggedCountyJurisdictions":0,"flaggedAreas":0,"reviewRowCount":0,"turnoutRowCount":0,"historicalRowCount":2,"equipmentRowCount":0,"flaggedJurisdictions":0,"importRunCount":1,"legacyImportCount":0,"latestImportAt":"2026-07-11T05:55:03.824Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":10608,"nativeResultRows":1,"nativeReviewRows":0,"nativeTrumpVotes":21076,"storedResultRows":3,"storedReviewRows":0,"nativeHarrisVotes":294185,"nativeTurnoutRows":0,"storedTurnoutRows":0,"storedIndicatorRows":0,"nativeHistoricalRows":2,"storedHistoricalRows":2,"nativeHistoricalYears":[2016,2020],"nativeResultTotalVotes":325869,"nativeHistoricalWarning":"D.C. is a single Census county-equivalent. Official precinct rows for 2016 and 2020 are aggregated to county:11001 for contextual presidential baseline joins; no sub-county FIPS codes are inferred."},"latestNativeImportSummary":{"nativeOtherVotes":10608,"nativeResultRows":1,"nativeReviewRows":0,"nativeTrumpVotes":21076,"storedResultRows":3,"storedReviewRows":0,"nativeHarrisVotes":294185,"nativeTurnoutRows":0,"storedTurnoutRows":0,"storedIndicatorRows":0,"nativeHistoricalRows":2,"storedHistoricalRows":2,"nativeHistoricalYears":[2016,2020],"nativeResultTotalVotes":325869,"nativeHistoricalWarning":"D.C. is a single Census county-equivalent. Official precinct rows for 2016 and 2020 are aggregated to county:11001 for contextual presidential baseline joins; no sub-county FIPS codes are inferred."},"latestParser":"nativeCountyPresidentCsv","nativeImportCount":1,"sourceTier":"native_official","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":false,"turnout":false,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"review_ready","gaps":["Review rows pending","Turnout pending"]},{"state":"FL","name":"Florida","authority":"Florida Department of State","resultRows":201,"resultJurisdictions":67,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":67,"taggedResultJurisdictions":67,"historical2020Jurisdictions":67,"taggedHistorical2020Jurisdictions":67,"matchedHistorical2020Jurisdictions":67,"missingHistorical2020Jurisdictions":0},"sourceCount":11,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":83,"countyIndicatorCount":83,"flaggedCountyJurisdictions":59,"flaggedAreas":59,"reviewRowCount":5618,"turnoutRowCount":67,"historicalRowCount":201,"equipmentRowCount":67,"flaggedJurisdictions":59,"importRunCount":15,"legacyImportCount":4,"latestImportAt":"2026-07-06T05:52:47.980Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":100589,"nativeResultRows":67,"nativeReviewRows":5618,"nativeTrumpVotes":6110125,"storedResultRows":201,"storedReviewRows":5618,"nativeBallotsCast":10999125,"nativeExtractRows":3321,"nativeHarrisVotes":4683038,"nativeTurnoutRows":67,"storedTurnoutRows":67,"nativeReviewWarning":"Florida review rows use the official precinct-level 2024 General Election ZIP to pair President and U.S. Senate rows by county, unique precinct identifier, and polling-location label. Certified county map totals remain sourced from the official county detail table because the precinct ZIP presidential candidate total is 204 votes below that table and the Trump total is one vote higher. The ZIP registration field is retained as a denominator lead only; active turnout rows remain EAC fallback until compatible state-native ballots-cast rows are collected.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":83,"nativeComparisonRows":5618,"nativeHistoricalRows":201,"storedHistoricalRows":201,"nativeExtractSourceId":"fl-2024-general-results-extract","nativeHistoricalYears":[2012,2016,2020],"nativePrecinctZipRows":537897,"nativeExtractRaceCount":40,"nativePrecinctZipFiles":67,"nativeRegisteredVoters":15740083,"nativeResultTotalVotes":10893752,"nativeComparisonContest":"United States Senator","nativeExtractSenateRows":402,"nativeHistoricalWarning":"Florida historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeExtractCountyCount":67,"nativeTurnoutWarningRows":0,"nativePrecinctZipSourceId":"fl-2024-general-precinct-results","nativeExtractPresidentRows":603,"nativePrecinctZipOtherVotes":100384,"nativePrecinctZipTrumpVotes":6110126,"nativePrecinctZipHarrisVotes":4683038,"nativePrecinctZipPrecinctRows":5712,"nativeExtractVerificationPassed":true,"nativePrecinctZipReviewableRows":5618,"nativePrecinctZipSenateDemVotes":4603077,"nativePrecinctZipSenateRepVotes":5977707,"nativeCountyDistributionAnalysis":false,"nativePrecinctZipRegisteredVoters":13942186,"nativePrecinctZipSenateOtherVotes":176632,"nativePrecinctZipZeroRegistrationRows":110,"nativeExtractSenateVerificationSkipped":true,"nativePrecinctZipSenateSpecialRowsVotes":245108,"nativePrecinctZipPresidentCandidateTotal":10893548,"nativePrecinctZipPresidentSpecialRowsVotes":108985,"nativePrecinctZipPresidentCandidateTotalDelta":-204},"latestNativeImportSummary":{"nativeOtherVotes":100589,"nativeResultRows":67,"nativeReviewRows":5618,"nativeTrumpVotes":6110125,"storedResultRows":201,"storedReviewRows":5618,"nativeBallotsCast":10999125,"nativeExtractRows":3321,"nativeHarrisVotes":4683038,"nativeTurnoutRows":67,"storedTurnoutRows":67,"nativeReviewWarning":"Florida review rows use the official precinct-level 2024 General Election ZIP to pair President and U.S. Senate rows by county, unique precinct identifier, and polling-location label. Certified county map totals remain sourced from the official county detail table because the precinct ZIP presidential candidate total is 204 votes below that table and the Trump total is one vote higher. The ZIP registration field is retained as a denominator lead only; active turnout rows remain EAC fallback until compatible state-native ballots-cast rows are collected.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":83,"nativeComparisonRows":5618,"nativeHistoricalRows":201,"storedHistoricalRows":201,"nativeExtractSourceId":"fl-2024-general-results-extract","nativeHistoricalYears":[2012,2016,2020],"nativePrecinctZipRows":537897,"nativeExtractRaceCount":40,"nativePrecinctZipFiles":67,"nativeRegisteredVoters":15740083,"nativeResultTotalVotes":10893752,"nativeComparisonContest":"United States Senator","nativeExtractSenateRows":402,"nativeHistoricalWarning":"Florida historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeExtractCountyCount":67,"nativeTurnoutWarningRows":0,"nativePrecinctZipSourceId":"fl-2024-general-precinct-results","nativeExtractPresidentRows":603,"nativePrecinctZipOtherVotes":100384,"nativePrecinctZipTrumpVotes":6110126,"nativePrecinctZipHarrisVotes":4683038,"nativePrecinctZipPrecinctRows":5712,"nativeExtractVerificationPassed":true,"nativePrecinctZipReviewableRows":5618,"nativePrecinctZipSenateDemVotes":4603077,"nativePrecinctZipSenateRepVotes":5977707,"nativeCountyDistributionAnalysis":false,"nativePrecinctZipRegisteredVoters":13942186,"nativePrecinctZipSenateOtherVotes":176632,"nativePrecinctZipZeroRegistrationRows":110,"nativeExtractSenateVerificationSkipped":true,"nativePrecinctZipSenateSpecialRowsVotes":245108,"nativePrecinctZipPresidentCandidateTotal":10893548,"nativePrecinctZipPresidentSpecialRowsVotes":108985,"nativePrecinctZipPresidentCandidateTotalDelta":-204},"latestParser":"nativeFloridaDetailHtml","nativeImportCount":8,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"GA","name":"Georgia","authority":"Georgia Secretary of State","resultRows":477,"resultJurisdictions":159,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":159,"taggedResultJurisdictions":159,"historical2020Jurisdictions":159,"taggedHistorical2020Jurisdictions":159,"matchedHistorical2020Jurisdictions":159,"missingHistorical2020Jurisdictions":0},"sourceCount":9,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":132,"countyIndicatorCount":132,"flaggedCountyJurisdictions":79,"flaggedAreas":79,"reviewRowCount":2684,"turnoutRowCount":159,"historicalRowCount":477,"equipmentRowCount":159,"flaggedJurisdictions":79,"importRunCount":16,"legacyImportCount":5,"latestImportAt":"2026-07-12T17:08:33.781Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":38932,"nativeResultRows":159,"nativeReviewRows":2684,"nativeTrumpVotes":2663117,"storedResultRows":477,"storedReviewRows":2684,"nativeBallotsCast":5297500,"nativeHarrisVotes":2548017,"nativeTurnoutRows":159,"storedTurnoutRows":159,"nativeReviewWarning":"Georgia native review rows use official Georgia Secretary of State media-export precinct presidential rows paired with U.S. House rows from the same SOS media export where comparable. U.S. House is district-based and candidate-specific, so directional screens are low-confidence advisory context rather than candidate-benefit findings. Eight nonzero precinct rows have one-sided House comparison coverage, 39 precinct keys aggregate more than one House district and are excluded from down-ballot dropoff calculations, county presidential candidate rows sum 19 votes higher than the statewide presidential contest total in minor-party/other rows, and 17 zero-total precinct entries are omitted from review charts.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":132,"nativeComparisonRows":2684,"nativeHistoricalRows":477,"storedHistoricalRows":477,"historicalReviewYears":[2016,2020],"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":8234335,"nativeResultTotalVotes":5250066,"storedReviewRowsByYear":{"2016":159,"2020":159,"2024":2684},"nativeComparisonContest":"U.S. House","nativeHistoricalWarning":"Georgia historical baseline rows are official county-level presidential results from Georgia Secretary of State media exports for 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data. The 2020 media export reports the original November general-election export total; separate recount result tables should be reconciled before replacing or combining those rows.","nativeTurnoutWarningRows":159,"storedIndicatorRowsByYear":{"2016":139,"2020":12,"2024":132},"nativeHistoricalReviewRows":318,"storedHistoricalReviewRows":318,"nativeHistoricalReviewYears":[2016,2020],"nativeOneSidedComparisonRows":8,"nativeHistoricalReviewWarning":"Georgia historical advisory rows compare official county presidential results with official U.S. Senate results from the same county. The 2016 comparison is United States Senator, Isakson. The 2020 comparison is the regular US Senate (Perdue) contest from the original November general export, before the runoff; the Loeffler special election is excluded. Candidate and contest differences, split-ticket voting, and participation differences can explain observed patterns. The selected source options contain no precinct results, so this is county-only advisory context, not a finding of misconduct.","nativeStatewideCertifiedVotes":5250047,"storedHistoricalIndicatorRows":151,"nativeComparableComparisonRows":2637,"nativeStatewideCertifiedVoteGap":19,"nativeHistoricalReviewRowsByYear":{"2016":159,"2020":159},"nativeReviewZeroTotalRowsOmitted":17,"nativeMultiDistrictComparisonRows":39,"nativeHistoricalReviewComparisonRows":318},"latestNativeImportSummary":{"nativeOtherVotes":38932,"nativeResultRows":159,"nativeReviewRows":2684,"nativeTrumpVotes":2663117,"storedResultRows":477,"storedReviewRows":2684,"nativeBallotsCast":5297500,"nativeHarrisVotes":2548017,"nativeTurnoutRows":159,"storedTurnoutRows":159,"nativeReviewWarning":"Georgia native review rows use official Georgia Secretary of State media-export precinct presidential rows paired with U.S. House rows from the same SOS media export where comparable. U.S. House is district-based and candidate-specific, so directional screens are low-confidence advisory context rather than candidate-benefit findings. Eight nonzero precinct rows have one-sided House comparison coverage, 39 precinct keys aggregate more than one House district and are excluded from down-ballot dropoff calculations, county presidential candidate rows sum 19 votes higher than the statewide presidential contest total in minor-party/other rows, and 17 zero-total precinct entries are omitted from review charts.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":132,"nativeComparisonRows":2684,"nativeHistoricalRows":477,"storedHistoricalRows":477,"historicalReviewYears":[2016,2020],"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":8234335,"nativeResultTotalVotes":5250066,"storedReviewRowsByYear":{"2016":159,"2020":159,"2024":2684},"nativeComparisonContest":"U.S. House","nativeHistoricalWarning":"Georgia historical baseline rows are official county-level presidential results from Georgia Secretary of State media exports for 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data. The 2020 media export reports the original November general-election export total; separate recount result tables should be reconciled before replacing or combining those rows.","nativeTurnoutWarningRows":159,"storedIndicatorRowsByYear":{"2016":139,"2020":12,"2024":132},"nativeHistoricalReviewRows":318,"storedHistoricalReviewRows":318,"nativeHistoricalReviewYears":[2016,2020],"nativeOneSidedComparisonRows":8,"nativeHistoricalReviewWarning":"Georgia historical advisory rows compare official county presidential results with official U.S. Senate results from the same county. The 2016 comparison is United States Senator, Isakson. The 2020 comparison is the regular US Senate (Perdue) contest from the original November general export, before the runoff; the Loeffler special election is excluded. Candidate and contest differences, split-ticket voting, and participation differences can explain observed patterns. The selected source options contain no precinct results, so this is county-only advisory context, not a finding of misconduct.","nativeStatewideCertifiedVotes":5250047,"storedHistoricalIndicatorRows":151,"nativeComparableComparisonRows":2637,"nativeStatewideCertifiedVoteGap":19,"nativeHistoricalReviewRowsByYear":{"2016":159,"2020":159},"nativeReviewZeroTotalRowsOmitted":17,"nativeMultiDistrictComparisonRows":39,"nativeHistoricalReviewComparisonRows":318},"latestParser":"nativeGeorgiaMediaExportJson","nativeImportCount":8,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"HI","name":"Hawaii","authority":"Hawaii Office of Elections; U.S. Election Assistance Commission; U.S. Census Bureau","resultRows":15,"resultJurisdictions":5,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":5,"taggedResultJurisdictions":5,"historical2020Jurisdictions":5,"taggedHistorical2020Jurisdictions":5,"matchedHistorical2020Jurisdictions":5,"missingHistorical2020Jurisdictions":0},"sourceCount":15,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":11,"countyIndicatorCount":11,"flaggedCountyJurisdictions":4,"flaggedAreas":4,"reviewRowCount":467,"turnoutRowCount":4,"historicalRowCount":10,"equipmentRowCount":4,"flaggedJurisdictions":4,"importRunCount":18,"legacyImportCount":7,"latestImportAt":"2026-07-11T05:51:42.350Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":9996,"nativeResultRows":5,"nativeReviewRows":467,"nativeTrumpVotes":193661,"storedResultRows":15,"storedReviewRows":467,"nativeBallotsCast":522236,"nativeHarrisVotes":313044,"nativeTurnoutRows":4,"storedTurnoutRows":4,"nativeReviewWarning":"Hawaii review rows are same-grain President-versus-U.S.-Senate precinct/split rows from the official Office of Elections media.txt export. The parser excludes three zero-vote non-geographic President keys (PRES, OS I, OS II) from advisory rows; numbered precinct/split review rows aggregate to the certified statewide presidential total. County labels use the documented district-range crosswalk with exact precinct 13-09 pinned to Kalawao County FIPS 15005; they are reproducible reporting assignments, not loaded precinct-boundary geometry. Advisory rows are public-interest source-review signals only, not findings of fraud or misconduct.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":11,"nativeComparisonRows":467,"nativeHistoricalRows":10,"storedHistoricalRows":10,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":860868,"nativeResultTotalVotes":516701,"nativeComparisonContest":"U.S. Senate","nativeHistoricalWarning":"Hawaii historical baseline rows are official 2016 and 2020 Office of Elections President results aggregated with reviewed year-specific pre-reapportionment district ranges: 01-07 Hawaii, 08-13 Maui, 14-16 Kauai, and 17-51 Honolulu. Precinct 13-09 split ID 78 is separated from Maui and pinned to Kalawao FIPS 15005. Every county tuple and statewide total is asserted. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeHawaiiKalawaoPrecinct":"13-09","nativeReviewCertifiedVoteGap":0,"nativeHawaiiKalawaoOtherVotes":0,"nativeHawaiiKalawaoTotalVotes":18,"nativeHawaiiKalawaoTrumpVotes":3,"nativeHawaiiSummaryOtherVotes":9996,"nativeHawaiiSummaryTotalVotes":516701,"nativeHawaiiSummaryTrumpVotes":193661,"nativeReviewPresidentialVotes":516701,"nativeHawaiiKalawaoHarrisVotes":15,"nativeHawaiiSummaryHarrisVotes":313044,"nativeHawaiiMissingComparisonRows":0,"nativeHawaiiKalawaoPrecinctSplitIds":["487","78"],"nativeHawaiiNonGeographicSenateKeysExcluded":2,"nativeHawaiiNonGeographicPresidentKeysExcluded":3,"nativeHawaiiZeroVoteNumberedPresidentKeysSkipped":27},"latestNativeImportSummary":{"nativeOtherVotes":9996,"nativeResultRows":5,"nativeReviewRows":467,"nativeTrumpVotes":193661,"storedResultRows":15,"storedReviewRows":467,"nativeBallotsCast":522236,"nativeHarrisVotes":313044,"nativeTurnoutRows":4,"storedTurnoutRows":4,"nativeReviewWarning":"Hawaii review rows are same-grain President-versus-U.S.-Senate precinct/split rows from the official Office of Elections media.txt export. The parser excludes three zero-vote non-geographic President keys (PRES, OS I, OS II) from advisory rows; numbered precinct/split review rows aggregate to the certified statewide presidential total. County labels use the documented district-range crosswalk with exact precinct 13-09 pinned to Kalawao County FIPS 15005; they are reproducible reporting assignments, not loaded precinct-boundary geometry. Advisory rows are public-interest source-review signals only, not findings of fraud or misconduct.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":11,"nativeComparisonRows":467,"nativeHistoricalRows":10,"storedHistoricalRows":10,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":860868,"nativeResultTotalVotes":516701,"nativeComparisonContest":"U.S. Senate","nativeHistoricalWarning":"Hawaii historical baseline rows are official 2016 and 2020 Office of Elections President results aggregated with reviewed year-specific pre-reapportionment district ranges: 01-07 Hawaii, 08-13 Maui, 14-16 Kauai, and 17-51 Honolulu. Precinct 13-09 split ID 78 is separated from Maui and pinned to Kalawao FIPS 15005. Every county tuple and statewide total is asserted. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeHawaiiKalawaoPrecinct":"13-09","nativeReviewCertifiedVoteGap":0,"nativeHawaiiKalawaoOtherVotes":0,"nativeHawaiiKalawaoTotalVotes":18,"nativeHawaiiKalawaoTrumpVotes":3,"nativeHawaiiSummaryOtherVotes":9996,"nativeHawaiiSummaryTotalVotes":516701,"nativeHawaiiSummaryTrumpVotes":193661,"nativeReviewPresidentialVotes":516701,"nativeHawaiiKalawaoHarrisVotes":15,"nativeHawaiiSummaryHarrisVotes":313044,"nativeHawaiiMissingComparisonRows":0,"nativeHawaiiKalawaoPrecinctSplitIds":["487","78"],"nativeHawaiiNonGeographicSenateKeysExcluded":2,"nativeHawaiiNonGeographicPresidentKeysExcluded":3,"nativeHawaiiZeroVoteNumberedPresidentKeysSkipped":27},"latestParser":"nativeHawaiiOfficeText","nativeImportCount":8,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"ID","name":"Idaho","authority":"Idaho Secretary of State","resultRows":132,"resultJurisdictions":44,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":44,"taggedResultJurisdictions":44,"historical2020Jurisdictions":44,"taggedHistorical2020Jurisdictions":44,"matchedHistorical2020Jurisdictions":44,"missingHistorical2020Jurisdictions":0},"sourceCount":11,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":27,"countyIndicatorCount":27,"flaggedCountyJurisdictions":27,"flaggedAreas":27,"reviewRowCount":44,"turnoutRowCount":44,"historicalRowCount":132,"equipmentRowCount":44,"flaggedJurisdictions":27,"importRunCount":15,"legacyImportCount":4,"latestImportAt":"2026-07-09T22:05:00.547Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":24749,"nativeResultRows":44,"nativeReviewRows":44,"nativeTrumpVotes":605246,"storedResultRows":132,"storedReviewRows":44,"nativeBallotsCast":917469,"nativeHarrisVotes":274972,"nativeTurnoutRows":44,"storedTurnoutRows":44,"nativeReviewWarning":"Idaho review rows are county-level President-versus-U.S. House comparisons from the official Vote Idaho archive. The public archive does not expose presidential precinct-level rows in the collected source package; U.S. House is district-based, so these are advisory screening inputs, not confirmed findings.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":27,"nativeComparisonRows":44,"nativeHistoricalRows":132,"storedHistoricalRows":132,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":1178750,"nativeResultTotalVotes":904967,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Idaho historical baselines are official county-level context rows for 2012, 2016, and 2020. They are used for county flip/join context, not as 2024 certified results or advisory findings.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":24749,"nativeResultRows":44,"nativeReviewRows":44,"nativeTrumpVotes":605246,"storedResultRows":132,"storedReviewRows":44,"nativeBallotsCast":917469,"nativeHarrisVotes":274972,"nativeTurnoutRows":44,"storedTurnoutRows":44,"nativeReviewWarning":"Idaho review rows are county-level President-versus-U.S. House comparisons from the official Vote Idaho archive. The public archive does not expose presidential precinct-level rows in the collected source package; U.S. House is district-based, so these are advisory screening inputs, not confirmed findings.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":27,"nativeComparisonRows":44,"nativeHistoricalRows":132,"storedHistoricalRows":132,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":1178750,"nativeResultTotalVotes":904967,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Idaho historical baselines are official county-level context rows for 2012, 2016, and 2020. They are used for county flip/join context, not as 2024 certified results or advisory findings.","nativeTurnoutWarningRows":0},"latestParser":"nativeIdahoCountyPresidentCsv","nativeImportCount":8,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"IL","name":"Illinois","authority":"Illinois State Board of Elections","resultRows":306,"resultJurisdictions":102,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":102,"taggedResultJurisdictions":102,"historical2020Jurisdictions":102,"taggedHistorical2020Jurisdictions":102,"matchedHistorical2020Jurisdictions":102,"missingHistorical2020Jurisdictions":0},"sourceCount":11,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":90,"countyIndicatorCount":90,"flaggedCountyJurisdictions":60,"flaggedAreas":60,"reviewRowCount":6655,"turnoutRowCount":108,"historicalRowCount":204,"equipmentRowCount":107,"flaggedJurisdictions":60,"importRunCount":12,"legacyImportCount":4,"latestImportAt":"2026-07-11T02:55:50.149Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":137837,"nativeResultRows":102,"nativeReviewRows":6655,"nativeTrumpVotes":2449079,"storedResultRows":306,"storedReviewRows":6655,"nativeBallotsCast":5717147,"nativeHarrisVotes":3062863,"nativeTurnoutRows":108,"storedTurnoutRows":108,"nativeReviewWarning":"Illinois review rows compare official precinct President rows with U.S. House rows where the jurisdiction/precinct key is unambiguous and the House contest has both Democratic and Republican candidate votes. Rows are omitted for precinct keys appearing in multiple House districts and for uncontested or one-party House comparison rows. This is an advisory same-election comparison, not a statewide Senate or Governor comparison.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":90,"nativeComparisonRows":6655,"nativeHistoricalRows":204,"storedHistoricalRows":204,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":8970541,"nativeResultTotalVotes":5649779,"nativeComparisonContest":"U.S. House","nativeHistoricalWarning":"Illinois historical baseline rows come from official State Board of Elections Candidate Totals by County workbooks. They include candidate and write-in votes but exclude blank, undervote, and overvote records that are not present in those workbooks. Pre-promotion reconciliation is pinned in data/il-historical-promotion-reconciliation.json: all 102 live 2020 tags are preserved, 100 vote tuples change, and McLean and Winnebago correct from incomplete red winners to official blue winners. Use these rows as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeReviewPresidentialVotes":4329145,"nativeReviewMissingPresidentialRows":0,"nativeReviewMultiDistrictPrecinctsOmitted":292,"nativeReviewUncontestedHousePrecinctsOmitted":3080},"latestNativeImportSummary":{"nativeOtherVotes":137837,"nativeResultRows":102,"nativeReviewRows":6655,"nativeTrumpVotes":2449079,"storedResultRows":306,"storedReviewRows":6655,"nativeBallotsCast":5717147,"nativeHarrisVotes":3062863,"nativeTurnoutRows":108,"storedTurnoutRows":108,"nativeReviewWarning":"Illinois review rows compare official precinct President rows with U.S. House rows where the jurisdiction/precinct key is unambiguous and the House contest has both Democratic and Republican candidate votes. Rows are omitted for precinct keys appearing in multiple House districts and for uncontested or one-party House comparison rows. This is an advisory same-election comparison, not a statewide Senate or Governor comparison.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":90,"nativeComparisonRows":6655,"nativeHistoricalRows":204,"storedHistoricalRows":204,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":8970541,"nativeResultTotalVotes":5649779,"nativeComparisonContest":"U.S. House","nativeHistoricalWarning":"Illinois historical baseline rows come from official State Board of Elections Candidate Totals by County workbooks. They include candidate and write-in votes but exclude blank, undervote, and overvote records that are not present in those workbooks. Pre-promotion reconciliation is pinned in data/il-historical-promotion-reconciliation.json: all 102 live 2020 tags are preserved, 100 vote tuples change, and McLean and Winnebago correct from incomplete red winners to official blue winners. Use these rows as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeReviewPresidentialVotes":4329145,"nativeReviewMissingPresidentialRows":0,"nativeReviewMultiDistrictPrecinctsOmitted":292,"nativeReviewUncontestedHousePrecinctsOmitted":3080},"latestParser":"nativeIllinoisElectionResultsByOfficeCsvDirectory","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":false,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"results_only","gaps":["Map capability pending"]},{"state":"IN","name":"Indiana","authority":"Indiana Election Division","resultRows":276,"resultJurisdictions":92,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":92,"taggedResultJurisdictions":92,"historical2020Jurisdictions":92,"taggedHistorical2020Jurisdictions":92,"matchedHistorical2020Jurisdictions":92,"missingHistorical2020Jurisdictions":0},"sourceCount":15,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":154,"countyIndicatorCount":154,"flaggedCountyJurisdictions":87,"flaggedAreas":87,"reviewRowCount":5253,"turnoutRowCount":92,"historicalRowCount":276,"equipmentRowCount":92,"flaggedJurisdictions":87,"importRunCount":24,"legacyImportCount":5,"latestImportAt":"2026-07-04T23:04:29.992Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":52727,"nativeResultRows":92,"nativeReviewRows":5253,"nativeTrumpVotes":1720347,"storedResultRows":276,"storedReviewRows":5253,"nativeBallotsCast":2976599,"nativeHarrisVotes":1163603,"nativeTurnoutRows":92,"storedTurnoutRows":92,"nativeReviewWarning":"Indiana local review rows use MIT/OpenElections supplemental precinct President-versus-U.S. Senate rows. Certified county totals remain official Indiana ENR. MIT warns Senate totals are overreported in some counties and precinct labels are not always unique identifiers.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":154,"nativeComparisonRows":5253,"nativeHistoricalRows":276,"storedHistoricalRows":276,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":4837802,"nativeResultTotalVotes":2936677,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Indiana historical baseline rows are official county-level presidential results from Indiana Election Division sources for 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data. The 2012 source is the current Indiana Voters ENRHistorical table endpoint, while 2016 and 2020 use official ENR archive JSON.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":"MIT/OpenElections supplemental Indiana precinct rows: 5,253 local President-versus-U.S.-Senate review rows across all 92 counties, generated from Dataverse file 13731143 with TOTAL mode used per county where present and all non-total modes summed otherwise."},"latestNativeImportSummary":{"nativeOtherVotes":52727,"nativeResultRows":92,"nativeReviewRows":5253,"nativeTrumpVotes":1720347,"storedResultRows":276,"storedReviewRows":5253,"nativeBallotsCast":2976599,"nativeHarrisVotes":1163603,"nativeTurnoutRows":92,"storedTurnoutRows":92,"nativeReviewWarning":"Indiana local review rows use MIT/OpenElections supplemental precinct President-versus-U.S. Senate rows. Certified county totals remain official Indiana ENR. MIT warns Senate totals are overreported in some counties and precinct labels are not always unique identifiers.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":154,"nativeComparisonRows":5253,"nativeHistoricalRows":276,"storedHistoricalRows":276,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":4837802,"nativeResultTotalVotes":2936677,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Indiana historical baseline rows are official county-level presidential results from Indiana Election Division sources for 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data. The 2012 source is the current Indiana Voters ENRHistorical table endpoint, while 2016 and 2020 use official ENR archive JSON.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":"MIT/OpenElections supplemental Indiana precinct rows: 5,253 local President-versus-U.S.-Senate review rows across all 92 counties, generated from Dataverse file 13731143 with TOTAL mode used per county where present and all non-total modes summed otherwise."},"latestParser":"nativeIndianaEnrCountyJson","nativeImportCount":16,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"IA","name":"Iowa","authority":"Iowa Secretary of State","resultRows":297,"resultJurisdictions":99,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":99,"taggedResultJurisdictions":99,"historical2020Jurisdictions":99,"taggedHistorical2020Jurisdictions":99,"matchedHistorical2020Jurisdictions":99,"missingHistorical2020Jurisdictions":0},"sourceCount":13,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":134,"countyIndicatorCount":134,"flaggedCountyJurisdictions":73,"flaggedAreas":73,"reviewRowCount":1653,"turnoutRowCount":1651,"historicalRowCount":297,"equipmentRowCount":99,"flaggedJurisdictions":73,"importRunCount":15,"legacyImportCount":5,"latestImportAt":"2026-07-06T04:09:43.271Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":29209,"nativeResultRows":99,"nativeReviewRows":1653,"nativeTrumpVotes":927019,"storedResultRows":297,"storedReviewRows":1653,"nativeHarrisVotes":707278,"nativeTurnoutRows":1651,"storedTurnoutRows":1651,"nativeReviewWarning":"Iowa review rows are precinct-level President-versus-U.S. House comparisons from official Secretary of State county detail XML report ZIPs. U.S. House is district-based; treat these as advisory review inputs, not confirmed findings.","storedIndicatorRows":134,"nativeComparisonRows":1653,"nativeHistoricalRows":297,"storedHistoricalRows":297,"nativeHistoricalYears":[2012,2016,2020],"nativeResultTotalVotes":1663506,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Iowa historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with state-source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutBallotsCast":1672068,"nativeTurnoutRegisteredVoters":1893715,"nativeMissingComparisonCounties":[]},"latestNativeImportSummary":{"nativeOtherVotes":29209,"nativeResultRows":99,"nativeReviewRows":1653,"nativeTrumpVotes":927019,"storedResultRows":297,"storedReviewRows":1653,"nativeHarrisVotes":707278,"nativeTurnoutRows":1651,"storedTurnoutRows":1651,"nativeReviewWarning":"Iowa review rows are precinct-level President-versus-U.S. House comparisons from official Secretary of State county detail XML report ZIPs. U.S. House is district-based; treat these as advisory review inputs, not confirmed findings.","storedIndicatorRows":134,"nativeComparisonRows":1653,"nativeHistoricalRows":297,"storedHistoricalRows":297,"nativeHistoricalYears":[2012,2016,2020],"nativeResultTotalVotes":1663506,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Iowa historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with state-source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutBallotsCast":1672068,"nativeTurnoutRegisteredVoters":1893715,"nativeMissingComparisonCounties":[]},"latestParser":"nativeIowaClarityCountyDetailXmlDirectory","nativeImportCount":7,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"KS","name":"Kansas","authority":"U.S. Election Assistance Commission","resultRows":315,"resultJurisdictions":105,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":105,"taggedResultJurisdictions":105,"historical2020Jurisdictions":105,"taggedHistorical2020Jurisdictions":105,"matchedHistorical2020Jurisdictions":105,"missingHistorical2020Jurisdictions":0},"sourceCount":16,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":155,"countyIndicatorCount":155,"flaggedCountyJurisdictions":95,"flaggedAreas":95,"reviewRowCount":3739,"turnoutRowCount":105,"historicalRowCount":315,"equipmentRowCount":105,"flaggedJurisdictions":95,"importRunCount":11,"legacyImportCount":5,"latestImportAt":"2026-07-02T22:53:04.191Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":23936,"nativeResultRows":105,"nativeReviewRows":3739,"nativeTrumpVotes":758802,"storedResultRows":315,"storedReviewRows":3739,"nativeBallotsCast":1342102,"nativeHarrisVotes":544853,"nativeTurnoutRows":105,"storedTurnoutRows":105,"nativeReviewWarning":"Kansas review rows use official Kansas Secretary of State precinct presidential rows and President-versus-U.S.-House same-row comparisons. The U.S. House workbook stores Johnson, Sedgwick, Shawnee, and Wyandotte in separate wide-format tabs; three nonzero presidential local rows do not have a matching House comparison and are kept as vote-share-only rows. U.S. House is district-based, so these are advisory screening inputs, not confirmed findings.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":155,"nativeComparisonRows":3736,"nativeHistoricalRows":315,"storedHistoricalRows":315,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":2031119,"nativeResultTotalVotes":1327591,"nativeComparisonContest":"United States House of Representatives","nativeHistoricalWarning":"Kansas historical baseline rows are county-level context for 2012, 2016, and 2020. 2020 rows are normalized from official Kansas Secretary of State presidential workbooks and certified PDF totals. 2016 rows use the official SOS presidential workbook for 101 counties plus secondary contextual county rows for Johnson, Sedgwick, Shawnee, and Wyandotte because those counties are absent from the workbook; statewide totals reconcile to the official 2016 PDF. The official 2012 SOS PDF did not expose county presidential rows in this pass, so 2012 county rows use secondary contextual tables and do not reconcile to the SOS statewide certified total. Use all historical rows as contextual baselines only, not as 2024 certified data.","nativeTurnoutWarningRows":0,"nativeKansasHousePrecinctRows":4566},"latestNativeImportSummary":{"nativeOtherVotes":23936,"nativeResultRows":105,"nativeReviewRows":3739,"nativeTrumpVotes":758802,"storedResultRows":315,"storedReviewRows":3739,"nativeBallotsCast":1342102,"nativeHarrisVotes":544853,"nativeTurnoutRows":105,"storedTurnoutRows":105,"nativeReviewWarning":"Kansas review rows use official Kansas Secretary of State precinct presidential rows and President-versus-U.S.-House same-row comparisons. The U.S. House workbook stores Johnson, Sedgwick, Shawnee, and Wyandotte in separate wide-format tabs; three nonzero presidential local rows do not have a matching House comparison and are kept as vote-share-only rows. U.S. House is district-based, so these are advisory screening inputs, not confirmed findings.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":155,"nativeComparisonRows":3736,"nativeHistoricalRows":315,"storedHistoricalRows":315,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":2031119,"nativeResultTotalVotes":1327591,"nativeComparisonContest":"United States House of Representatives","nativeHistoricalWarning":"Kansas historical baseline rows are county-level context for 2012, 2016, and 2020. 2020 rows are normalized from official Kansas Secretary of State presidential workbooks and certified PDF totals. 2016 rows use the official SOS presidential workbook for 101 counties plus secondary contextual county rows for Johnson, Sedgwick, Shawnee, and Wyandotte because those counties are absent from the workbook; statewide totals reconcile to the official 2016 PDF. The official 2012 SOS PDF did not expose county presidential rows in this pass, so 2012 county rows use secondary contextual tables and do not reconcile to the SOS statewide certified total. Use all historical rows as contextual baselines only, not as 2024 certified data.","nativeTurnoutWarningRows":0,"nativeKansasHousePrecinctRows":4566},"latestParser":"nativeKansasPresidentialHouseXlsx","nativeImportCount":3,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"KY","name":"Kentucky","authority":"Kentucky State Board of Elections","resultRows":360,"resultJurisdictions":120,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":120,"taggedResultJurisdictions":120,"historical2020Jurisdictions":120,"taggedHistorical2020Jurisdictions":120,"matchedHistorical2020Jurisdictions":120,"missingHistorical2020Jurisdictions":0},"sourceCount":14,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":104,"countyIndicatorCount":104,"flaggedCountyJurisdictions":88,"flaggedAreas":88,"reviewRowCount":3067,"turnoutRowCount":120,"historicalRowCount":360,"equipmentRowCount":120,"flaggedJurisdictions":88,"importRunCount":17,"legacyImportCount":5,"latestImportAt":"2026-07-06T04:19:01.048Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":29567,"nativeResultRows":120,"nativeReviewRows":3067,"nativeTrumpVotes":1315523,"storedResultRows":360,"storedReviewRows":3067,"nativeBallotsCast":2086090,"nativeHarrisVotes":691021,"nativeTurnoutRows":120,"storedTurnoutRows":120,"nativeReviewWarning":"Kentucky review rows are precinct-level President-versus-U.S. House comparisons extracted from official county recap PDFs. U.S. House is district-based and some counties have uncontested or county-only rows; Elliott County is image-only and uses a manual transcription of the President and U.S. House rows from the official PDF scan.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":104,"nativeComparisonRows":3067,"nativeHistoricalRows":360,"storedHistoricalRows":360,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":3548136,"nativeResultTotalVotes":2036111,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Kentucky historical baseline rows are official county-level presidential results from 2012, 2016, and 2020 Kentucky election-results PDFs. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0,"nativeKentuckyCountyOnlyRows":["Clay County","Jackson County","Lee County","Leslie County","Rockcastle County","Scott County"],"nativeKentuckyMissingCountyTextRows":[]},"latestNativeImportSummary":{"nativeOtherVotes":29567,"nativeResultRows":120,"nativeReviewRows":3067,"nativeTrumpVotes":1315523,"storedResultRows":360,"storedReviewRows":3067,"nativeBallotsCast":2086090,"nativeHarrisVotes":691021,"nativeTurnoutRows":120,"storedTurnoutRows":120,"nativeReviewWarning":"Kentucky review rows are precinct-level President-versus-U.S. House comparisons extracted from official county recap PDFs. U.S. House is district-based and some counties have uncontested or county-only rows; Elliott County is image-only and uses a manual transcription of the President and U.S. House rows from the official PDF scan.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":104,"nativeComparisonRows":3067,"nativeHistoricalRows":360,"storedHistoricalRows":360,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":3548136,"nativeResultTotalVotes":2036111,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Kentucky historical baseline rows are official county-level presidential results from 2012, 2016, and 2020 Kentucky election-results PDFs. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0,"nativeKentuckyCountyOnlyRows":["Clay County","Jackson County","Lee County","Leslie County","Rockcastle County","Scott County"],"nativeKentuckyMissingCountyTextRows":[]},"latestParser":"nativeKentuckyGeneralRecapTextDirectory","nativeImportCount":9,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"LA","name":"Louisiana","authority":"Louisiana Secretary of State","resultRows":192,"resultJurisdictions":64,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":64,"taggedResultJurisdictions":64,"historical2020Jurisdictions":64,"taggedHistorical2020Jurisdictions":64,"matchedHistorical2020Jurisdictions":64,"missingHistorical2020Jurisdictions":0},"sourceCount":14,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":75,"countyIndicatorCount":75,"flaggedCountyJurisdictions":48,"flaggedAreas":48,"reviewRowCount":3885,"turnoutRowCount":64,"historicalRowCount":128,"equipmentRowCount":64,"flaggedJurisdictions":48,"importRunCount":13,"legacyImportCount":4,"latestImportAt":"2026-07-11T03:01:43.915Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":31600,"nativeResultRows":64,"nativeReviewRows":3885,"nativeTrumpVotes":1208505,"storedResultRows":192,"storedReviewRows":3885,"nativeBallotsCast":2021164,"nativeHarrisVotes":766870,"nativeTurnoutRows":64,"storedTurnoutRows":64,"nativeReviewWarning":"Louisiana review rows use official precinct/mode President rows compared with U.S. House rows where the same parish, ward, and precinct or vote-mode key is available. This is weaker than a statewide same-office comparison because House districts, uncontested or same-party races, incumbency, and candidate effects can dominate the signal. One-sided House rows are retained as vote-share context but do not produce drop-off direction.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":75,"nativeComparisonRows":3911,"nativeHistoricalRows":128,"storedHistoricalRows":128,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":3046375,"nativeResultTotalVotes":2006975,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Louisiana historical baseline rows are official parish-level 2016 and 2020 Presidential Electors results from Louisiana Secretary of State ByParish CSV blobs. Use them as contextual county-equivalent jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 parish presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeReviewCertifiedVoteGap":0,"nativeReviewPresidentialVotes":2006975,"nativeComparableComparisonRows":3119},"latestNativeImportSummary":{"nativeOtherVotes":31600,"nativeResultRows":64,"nativeReviewRows":3885,"nativeTrumpVotes":1208505,"storedResultRows":192,"storedReviewRows":3885,"nativeBallotsCast":2021164,"nativeHarrisVotes":766870,"nativeTurnoutRows":64,"storedTurnoutRows":64,"nativeReviewWarning":"Louisiana review rows use official precinct/mode President rows compared with U.S. House rows where the same parish, ward, and precinct or vote-mode key is available. This is weaker than a statewide same-office comparison because House districts, uncontested or same-party races, incumbency, and candidate effects can dominate the signal. One-sided House rows are retained as vote-share context but do not produce drop-off direction.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":75,"nativeComparisonRows":3911,"nativeHistoricalRows":128,"storedHistoricalRows":128,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":3046375,"nativeResultTotalVotes":2006975,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Louisiana historical baseline rows are official parish-level 2016 and 2020 Presidential Electors results from Louisiana Secretary of State ByParish CSV blobs. Use them as contextual county-equivalent jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 parish presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeReviewCertifiedVoteGap":0,"nativeReviewPresidentialVotes":2006975,"nativeComparableComparisonRows":3119},"latestParser":"nativeLouisianaSosPrecinctCsvDirectory","nativeImportCount":6,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"ME","name":"Maine","authority":"Maine Secretary of State; U.S. Election Assistance Commission","resultRows":51,"resultJurisdictions":17,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":17,"taggedResultJurisdictions":16,"historical2020Jurisdictions":17,"taggedHistorical2020Jurisdictions":16,"matchedHistorical2020Jurisdictions":16,"missingHistorical2020Jurisdictions":0},"sourceCount":16,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":42,"countyIndicatorCount":42,"flaggedCountyJurisdictions":16,"flaggedAreas":16,"reviewRowCount":512,"turnoutRowCount":497,"historicalRowCount":34,"equipmentRowCount":16,"flaggedJurisdictions":16,"importRunCount":15,"legacyImportCount":6,"latestImportAt":"2026-07-11T03:07:06.256Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":17746,"nativeResultRows":17,"nativeReviewRows":512,"nativeTrumpVotes":377977,"storedResultRows":51,"storedReviewRows":512,"nativeBallotsCast":842447,"nativeHarrisVotes":435652,"nativeTurnoutRows":497,"storedTurnoutRows":497,"nativeReviewWarning":"Maine review rows pair official SOS town-level President rows with the official U.S. Senate workbook after conservative municipality-label normalization. U.S. Senate includes a major independent candidate, so Democratic/Republican dropoff fields are directional source-review inputs only. State UOCAVA is loaded in certified result totals as non-geographic and excluded from town review rows; a few true grain mismatches remain vote-share-only.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":42,"nativeComparisonRows":509,"nativeHistoricalRows":34,"storedHistoricalRows":34,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":1223468,"nativeResultTotalVotes":831375,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Maine historical baseline rows are official SOS county plus State UOCAVA context for 2016 and 2020. Official 2012 county and municipal XLS artifacts are collected but not parsed because the current repo reader supports .xlsx, not legacy .xls. Use historical rows as contextual baselines only, not 2024 certified data.","nativeTurnoutWarningRows":497,"nativeReviewCertifiedVoteGap":6569,"nativeReviewPresidentialVotes":824806},"latestNativeImportSummary":{"nativeOtherVotes":17746,"nativeResultRows":17,"nativeReviewRows":512,"nativeTrumpVotes":377977,"storedResultRows":51,"storedReviewRows":512,"nativeBallotsCast":842447,"nativeHarrisVotes":435652,"nativeTurnoutRows":497,"storedTurnoutRows":497,"nativeReviewWarning":"Maine review rows pair official SOS town-level President rows with the official U.S. Senate workbook after conservative municipality-label normalization. U.S. Senate includes a major independent candidate, so Democratic/Republican dropoff fields are directional source-review inputs only. State UOCAVA is loaded in certified result totals as non-geographic and excluded from town review rows; a few true grain mismatches remain vote-share-only.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":42,"nativeComparisonRows":509,"nativeHistoricalRows":34,"storedHistoricalRows":34,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":1223468,"nativeResultTotalVotes":831375,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Maine historical baseline rows are official SOS county plus State UOCAVA context for 2016 and 2020. Official 2012 county and municipal XLS artifacts are collected but not parsed because the current repo reader supports .xlsx, not legacy .xls. Use historical rows as contextual baselines only, not 2024 certified data.","nativeTurnoutWarningRows":497,"nativeReviewCertifiedVoteGap":6569,"nativeReviewPresidentialVotes":824806},"latestParser":"nativeMaineSosCountyTownXlsx","nativeImportCount":6,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":["1 result jurisdiction missing canonical tags"]},{"state":"MD","name":"Maryland","authority":"Maryland State Board of Elections","resultRows":72,"resultJurisdictions":24,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":24,"taggedResultJurisdictions":24,"historical2020Jurisdictions":24,"taggedHistorical2020Jurisdictions":24,"matchedHistorical2020Jurisdictions":24,"missingHistorical2020Jurisdictions":0},"sourceCount":11,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":48,"countyIndicatorCount":48,"flaggedCountyJurisdictions":24,"flaggedAreas":24,"reviewRowCount":1958,"turnoutRowCount":24,"historicalRowCount":48,"equipmentRowCount":24,"flaggedJurisdictions":24,"importRunCount":10,"legacyImportCount":4,"latestImportAt":"2026-07-11T03:05:17.694Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":100207,"nativeResultRows":24,"nativeReviewRows":1958,"nativeTrumpVotes":1035550,"storedResultRows":72,"storedReviewRows":1958,"nativeBallotsCast":3028813,"nativeHarrisVotes":1902577,"nativeTurnoutRows":24,"storedTurnoutRows":24,"nativeReviewWarning":"Maryland review rows use official State Board of Elections precinct-level President-versus-U.S.-Senate comparisons. The precinct CSV includes ballot-mode columns, but no same-row registered-voter denominator; turnout remains EAC jurisdiction fallback until a state-native denominator source is collected. Precinct boundary geometry is not included.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":48,"nativeComparisonRows":1958,"nativeHistoricalRows":48,"storedHistoricalRows":48,"nativeHistoricalYears":[2016,2020],"nativeSenateModeVotes":{"Early Votes":962075,"Provisional Votes":139845,"Election Night Votes":1105287,"Mail-In Ballot 1 Votes":499757,"Mail-In Ballot 2 Votes":238292},"nativeRegisteredVoters":4555217,"nativeResultTotalVotes":3038334,"nativeComparisonContest":"U.S. Senator","nativeHistoricalWarning":"Maryland historical baseline rows are official county/county-equivalent 2016 and 2020 General Election President results from Maryland State Board of Elections artifacts. Use them as contextual baseline rows for jurisdictionTag county flip joins, not as 2024 certified data. Baltimore City and Baltimore County are separate Census county-equivalent tags. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativePresidentialModeVotes":{"Early Votes":989923,"Provisional Votes":145835,"Election Night Votes":1149987,"Mail-In Ballot 1 Votes":508880,"Mail-In Ballot 2 Votes":243709}},"latestNativeImportSummary":{"nativeOtherVotes":100207,"nativeResultRows":24,"nativeReviewRows":1958,"nativeTrumpVotes":1035550,"storedResultRows":72,"storedReviewRows":1958,"nativeBallotsCast":3028813,"nativeHarrisVotes":1902577,"nativeTurnoutRows":24,"storedTurnoutRows":24,"nativeReviewWarning":"Maryland review rows use official State Board of Elections precinct-level President-versus-U.S.-Senate comparisons. The precinct CSV includes ballot-mode columns, but no same-row registered-voter denominator; turnout remains EAC jurisdiction fallback until a state-native denominator source is collected. Precinct boundary geometry is not included.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":48,"nativeComparisonRows":1958,"nativeHistoricalRows":48,"storedHistoricalRows":48,"nativeHistoricalYears":[2016,2020],"nativeSenateModeVotes":{"Early Votes":962075,"Provisional Votes":139845,"Election Night Votes":1105287,"Mail-In Ballot 1 Votes":499757,"Mail-In Ballot 2 Votes":238292},"nativeRegisteredVoters":4555217,"nativeResultTotalVotes":3038334,"nativeComparisonContest":"U.S. Senator","nativeHistoricalWarning":"Maryland historical baseline rows are official county/county-equivalent 2016 and 2020 General Election President results from Maryland State Board of Elections artifacts. Use them as contextual baseline rows for jurisdictionTag county flip joins, not as 2024 certified data. Baltimore City and Baltimore County are separate Census county-equivalent tags. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativePresidentialModeVotes":{"Early Votes":989923,"Provisional Votes":145835,"Election Night Votes":1149987,"Mail-In Ballot 1 Votes":508880,"Mail-In Ballot 2 Votes":243709}},"latestParser":"nativeMarylandPrecinctCsv","nativeImportCount":3,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"MA","name":"Massachusetts","authority":"Massachusetts Secretary of the Commonwealth","resultRows":42,"resultJurisdictions":14,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":14,"taggedResultJurisdictions":14,"historical2020Jurisdictions":14,"taggedHistorical2020Jurisdictions":14,"matchedHistorical2020Jurisdictions":14,"missingHistorical2020Jurisdictions":0},"sourceCount":10,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":142,"countyIndicatorCount":142,"flaggedCountyJurisdictions":85,"flaggedAreas":85,"reviewRowCount":2382,"turnoutRowCount":351,"historicalRowCount":42,"equipmentRowCount":14,"flaggedJurisdictions":85,"importRunCount":13,"legacyImportCount":5,"latestImportAt":"2026-07-06T05:58:25.250Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":135109,"nativeResultRows":14,"nativeReviewRows":2382,"nativeTrumpVotes":1251303,"storedResultRows":42,"storedReviewRows":2382,"nativeBallotsCast":3512930,"nativeHarrisVotes":2126518,"nativeTurnoutRows":351,"storedTurnoutRows":351,"nativeReviewWarning":"Massachusetts review rows are official PD43+ city/town, ward, and precinct rows comparing President against U.S. Senate. Jurisdiction grouping is municipality-centric because the PD43+ bulk export does not include county in the row schema.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":142,"nativeComparisonRows":2382,"nativeHistoricalRows":42,"storedHistoricalRows":42,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":5142343,"nativeResultTotalVotes":3512930,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Massachusetts historical baseline rows are official PD43+ county-level presidential results for 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data; the 2020 county rows preserve the official displayed county-row sum, which is one non-D/R vote above the statewide summary line.","nativeTurnoutWarningRows":0,"nativeReviewCertifiedVoteGap":0,"nativeReviewPresidentialVotes":3512930},"latestNativeImportSummary":{"nativeOtherVotes":135109,"nativeResultRows":14,"nativeReviewRows":2382,"nativeTrumpVotes":1251303,"storedResultRows":42,"storedReviewRows":2382,"nativeBallotsCast":3512930,"nativeHarrisVotes":2126518,"nativeTurnoutRows":351,"storedTurnoutRows":351,"nativeReviewWarning":"Massachusetts review rows are official PD43+ city/town, ward, and precinct rows comparing President against U.S. Senate. Jurisdiction grouping is municipality-centric because the PD43+ bulk export does not include county in the row schema.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":142,"nativeComparisonRows":2382,"nativeHistoricalRows":42,"storedHistoricalRows":42,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":5142343,"nativeResultTotalVotes":3512930,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Massachusetts historical baseline rows are official PD43+ county-level presidential results for 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data; the 2020 county rows preserve the official displayed county-row sum, which is one non-D/R vote above the statewide summary line.","nativeTurnoutWarningRows":0,"nativeReviewCertifiedVoteGap":0,"nativeReviewPresidentialVotes":3512930},"latestParser":"nativeMassachusettsPd43PrecinctCsv","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"MI","name":"Michigan","authority":"Michigan Secretary of State","resultRows":249,"resultJurisdictions":83,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":83,"taggedResultJurisdictions":83,"historical2020Jurisdictions":83,"taggedHistorical2020Jurisdictions":83,"matchedHistorical2020Jurisdictions":83,"missingHistorical2020Jurisdictions":0},"sourceCount":8,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":128,"countyIndicatorCount":128,"flaggedCountyJurisdictions":77,"flaggedAreas":77,"reviewRowCount":4428,"turnoutRowCount":83,"historicalRowCount":249,"equipmentRowCount":83,"flaggedJurisdictions":77,"importRunCount":10,"legacyImportCount":4,"latestImportAt":"2026-07-01T07:04:32.972Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":111017,"nativeResultRows":83,"nativeReviewRows":4428,"nativeTrumpVotes":2816636,"storedResultRows":249,"storedReviewRows":4428,"nativeBallotsCast":5706503,"nativeHarrisVotes":2736533,"nativeTurnoutRows":83,"storedTurnoutRows":83,"nativeReviewWarning":"Michigan native review rows use precinct-level presidential vote-share screening and presidential-versus-U.S. Senate same-party drop-off screening. Precinct boundary geometry is not included in this package.","storedIndicatorRows":128,"nativeComparisonRows":4416,"nativeHistoricalRows":249,"storedHistoricalRows":249,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":7310804,"nativeResultTotalVotes":5664186,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Michigan historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with Michigan official result-page citations where available. Use them as contextual baseline rows, not as 2024 certified data. Prefer replacing them with official Michigan Secretary of State historical MVIC or mielections.us exports if those can be collected."},"latestNativeImportSummary":{"nativeOtherVotes":111017,"nativeResultRows":83,"nativeReviewRows":4428,"nativeTrumpVotes":2816636,"storedResultRows":249,"storedReviewRows":4428,"nativeBallotsCast":5706503,"nativeHarrisVotes":2736533,"nativeTurnoutRows":83,"storedTurnoutRows":83,"nativeReviewWarning":"Michigan native review rows use precinct-level presidential vote-share screening and presidential-versus-U.S. Senate same-party drop-off screening. Precinct boundary geometry is not included in this package.","storedIndicatorRows":128,"nativeComparisonRows":4416,"nativeHistoricalRows":249,"storedHistoricalRows":249,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":7310804,"nativeResultTotalVotes":5664186,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Michigan historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with Michigan official result-page citations where available. Use them as contextual baseline rows, not as 2024 certified data. Prefer replacing them with official Michigan Secretary of State historical MVIC or mielections.us exports if those can be collected."},"latestParser":"nativeMichiganMvic","nativeImportCount":3,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"MN","name":"Minnesota","authority":"Minnesota Secretary of State","resultRows":261,"resultJurisdictions":87,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":87,"taggedResultJurisdictions":87,"historical2020Jurisdictions":87,"taggedHistorical2020Jurisdictions":87,"matchedHistorical2020Jurisdictions":87,"missingHistorical2020Jurisdictions":0},"sourceCount":5,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":173,"countyIndicatorCount":173,"flaggedCountyJurisdictions":87,"flaggedAreas":87,"reviewRowCount":4075,"turnoutRowCount":4103,"historicalRowCount":348,"equipmentRowCount":87,"flaggedJurisdictions":87,"importRunCount":10,"legacyImportCount":4,"latestImportAt":"2026-07-06T22:54:34.429Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":77909,"nativeResultRows":87,"nativeReviewRows":4075,"nativeTrumpVotes":1519032,"storedResultRows":261,"storedReviewRows":4075,"nativeBallotsCast":3272414,"nativeHarrisVotes":1656979,"nativeTurnoutRows":4103,"storedTurnoutRows":4103,"nativeReviewWarning":"Minnesota native review rows use precinct-level presidential vote-share screening and presidential-versus-U.S. Senate same-party drop-off screening. Precinct map overlays remain disabled until precinct boundary geometry is sourced.","storedIndicatorRows":173,"nativeComparisonRows":4075,"storedHistoricalRows":0,"nativeRegisteredVoters":3982883,"nativeResultTotalVotes":3253920,"nativeComparisonContest":"United States Senator"},"latestNativeImportSummary":{"nativeOtherVotes":77909,"nativeResultRows":87,"nativeReviewRows":4075,"nativeTrumpVotes":1519032,"storedResultRows":261,"storedReviewRows":4075,"nativeBallotsCast":3272414,"nativeHarrisVotes":1656979,"nativeTurnoutRows":4103,"storedTurnoutRows":4103,"nativeReviewWarning":"Minnesota native review rows use precinct-level presidential vote-share screening and presidential-versus-U.S. Senate same-party drop-off screening. Precinct map overlays remain disabled until precinct boundary geometry is sourced.","storedIndicatorRows":173,"nativeComparisonRows":4075,"storedHistoricalRows":0,"nativeRegisteredVoters":3982883,"nativeResultTotalVotes":3253920,"nativeComparisonContest":"United States Senator"},"latestParser":"nativeMinnesotaPrecinctResultsXlsx","nativeImportCount":3,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"MS","name":"Mississippi","authority":"Mississippi Secretary of State","resultRows":246,"resultJurisdictions":82,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":82,"taggedResultJurisdictions":82,"historical2020Jurisdictions":82,"taggedHistorical2020Jurisdictions":82,"matchedHistorical2020Jurisdictions":82,"missingHistorical2020Jurisdictions":0},"sourceCount":9,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":5,"countyIndicatorCount":5,"flaggedCountyJurisdictions":5,"flaggedAreas":5,"reviewRowCount":82,"turnoutRowCount":82,"historicalRowCount":246,"equipmentRowCount":82,"flaggedJurisdictions":5,"importRunCount":19,"legacyImportCount":5,"latestImportAt":"2026-07-03T23:18:56.612Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":13576,"nativeResultRows":82,"nativeReviewRows":82,"nativeTrumpVotes":746305,"storedResultRows":246,"storedReviewRows":82,"nativeBallotsCast":1225176,"nativeHarrisVotes":465357,"nativeTurnoutRows":82,"storedTurnoutRows":82,"nativeReviewWarning":"Mississippi review rows are county-level President-versus-U.S. Senate comparisons from the official statewide recap CSV. They are useful for county review, but they are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":5,"nativeComparisonRows":82,"nativeHistoricalRows":246,"storedHistoricalRows":246,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":2131726,"nativeResultTotalVotes":1225238,"nativeComparisonContest":"United States Senate","nativeHistoricalWarning":"Mississippi historical baselines are official county-level presidential context from SOS archive artifacts; they are not precinct review rows.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":13576,"nativeResultRows":82,"nativeReviewRows":82,"nativeTrumpVotes":746305,"storedResultRows":246,"storedReviewRows":82,"nativeBallotsCast":1225176,"nativeHarrisVotes":465357,"nativeTurnoutRows":82,"storedTurnoutRows":82,"nativeReviewWarning":"Mississippi review rows are county-level President-versus-U.S. Senate comparisons from the official statewide recap CSV. They are useful for county review, but they are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":5,"nativeComparisonRows":82,"nativeHistoricalRows":246,"storedHistoricalRows":246,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":2131726,"nativeResultTotalVotes":1225238,"nativeComparisonContest":"United States Senate","nativeHistoricalWarning":"Mississippi historical baselines are official county-level presidential context from SOS archive artifacts; they are not precinct review rows.","nativeTurnoutWarningRows":0},"latestParser":"nativeMississippiElectionRecapCsv","nativeImportCount":11,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"MO","name":"Missouri","authority":"Missouri Secretary of State","resultRows":345,"resultJurisdictions":115,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":115,"taggedResultJurisdictions":115,"historical2020Jurisdictions":115,"taggedHistorical2020Jurisdictions":115,"matchedHistorical2020Jurisdictions":115,"missingHistorical2020Jurisdictions":0},"sourceCount":21,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":75,"countyIndicatorCount":75,"flaggedCountyJurisdictions":75,"flaggedAreas":75,"reviewRowCount":115,"turnoutRowCount":115,"historicalRowCount":345,"equipmentRowCount":116,"flaggedJurisdictions":75,"importRunCount":16,"legacyImportCount":5,"latestImportAt":"2026-07-11T05:52:45.782Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":42742,"nativeResultRows":115,"nativeReviewRows":115,"nativeTrumpVotes":1751986,"storedResultRows":345,"storedReviewRows":115,"nativeBallotsCast":2995376,"nativeHarrisVotes":1200599,"nativeTurnoutRows":115,"storedTurnoutRows":115,"nativeReviewWarning":"Missouri review rows compare official President and U.S. Senate totals at Census county/county-equivalent grain. The retained SOS source reports Jackson County outside Kansas City and Kansas City within Jackson County separately; the canonical rows sum those election authorities into Jackson County FIPS 29095. These are county-level review rows, not precinct scatter plots.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":75,"nativeComparisonRows":115,"nativeHistoricalRows":345,"storedHistoricalRows":345,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":4433383,"nativeResultTotalVotes":2995327,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Missouri historical baselines are canonical Census-county rows generated from official SOS 2012, 2016, and 2020 election-authority PDFs. Kansas City within Jackson County is aggregated into county:29095 with zero statewide deltas. The 2016 PDF exposes party columns but not county-level write-in detail, so 2016 other/total values remain visible-column sums.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":42742,"nativeResultRows":115,"nativeReviewRows":115,"nativeTrumpVotes":1751986,"storedResultRows":345,"storedReviewRows":115,"nativeBallotsCast":2995376,"nativeHarrisVotes":1200599,"nativeTurnoutRows":115,"storedTurnoutRows":115,"nativeReviewWarning":"Missouri review rows compare official President and U.S. Senate totals at Census county/county-equivalent grain. The retained SOS source reports Jackson County outside Kansas City and Kansas City within Jackson County separately; the canonical rows sum those election authorities into Jackson County FIPS 29095. These are county-level review rows, not precinct scatter plots.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":75,"nativeComparisonRows":115,"nativeHistoricalRows":345,"storedHistoricalRows":345,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":4433383,"nativeResultTotalVotes":2995327,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Missouri historical baselines are canonical Census-county rows generated from official SOS 2012, 2016, and 2020 election-authority PDFs. Kansas City within Jackson County is aggregated into county:29095 with zero statewide deltas. The 2016 PDF exposes party columns but not county-level write-in detail, so 2016 other/total values remain visible-column sums.","nativeTurnoutWarningRows":0},"latestParser":"nativeMissouriCountyPresidentCsv","nativeImportCount":8,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"MT","name":"Montana","authority":"Montana Secretary of State","resultRows":168,"resultJurisdictions":56,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":56,"taggedResultJurisdictions":56,"historical2020Jurisdictions":56,"taggedHistorical2020Jurisdictions":56,"matchedHistorical2020Jurisdictions":56,"missingHistorical2020Jurisdictions":0},"sourceCount":13,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":61,"countyIndicatorCount":61,"flaggedCountyJurisdictions":29,"flaggedAreas":29,"reviewRowCount":726,"turnoutRowCount":56,"historicalRowCount":112,"equipmentRowCount":56,"flaggedJurisdictions":29,"importRunCount":14,"legacyImportCount":5,"latestImportAt":"2026-07-11T03:08:05.176Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":18978,"nativeResultRows":56,"nativeReviewRows":726,"nativeTrumpVotes":352079,"storedResultRows":168,"storedReviewRows":726,"nativeBallotsCast":612423,"nativeHarrisVotes":231906,"nativeTurnoutRows":56,"storedTurnoutRows":56,"nativeReviewWarning":"Montana native review rows use official precinct-level presidential vote-share screening and President-versus-U.S. Senate same-party drop-off screening from the Secretary of State precinct workbook. The workbook does not include 27 presidential write-in votes listed in the separate write-in canvass, so native result rows are 27 votes below the statewide certified presidential total.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":61,"nativeComparisonRows":726,"nativeHistoricalRows":112,"storedHistoricalRows":112,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":800573,"nativeResultTotalVotes":602963,"nativeComparisonContest":"UNITED STATES SENATOR","nativeHistoricalWarning":"Montana historical baselines use official precinct workbook candidate rows aggregated to county. Separate write-in canvass totals are retained as context and excluded from county other_votes/total_votes because the official election-results export does not allocate them consistently into county rows. 2012 remains uncollected.","nativeTurnoutWarningRows":56,"nativeStatewideCertifiedVotes":602990,"nativeStatewideCertifiedVoteGap":-27},"latestNativeImportSummary":{"nativeOtherVotes":18978,"nativeResultRows":56,"nativeReviewRows":726,"nativeTrumpVotes":352079,"storedResultRows":168,"storedReviewRows":726,"nativeBallotsCast":612423,"nativeHarrisVotes":231906,"nativeTurnoutRows":56,"storedTurnoutRows":56,"nativeReviewWarning":"Montana native review rows use official precinct-level presidential vote-share screening and President-versus-U.S. Senate same-party drop-off screening from the Secretary of State precinct workbook. The workbook does not include 27 presidential write-in votes listed in the separate write-in canvass, so native result rows are 27 votes below the statewide certified presidential total.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":61,"nativeComparisonRows":726,"nativeHistoricalRows":112,"storedHistoricalRows":112,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":800573,"nativeResultTotalVotes":602963,"nativeComparisonContest":"UNITED STATES SENATOR","nativeHistoricalWarning":"Montana historical baselines use official precinct workbook candidate rows aggregated to county. Separate write-in canvass totals are retained as context and excluded from county other_votes/total_votes because the official election-results export does not allocate them consistently into county rows. 2012 remains uncollected.","nativeTurnoutWarningRows":56,"nativeStatewideCertifiedVotes":602990,"nativeStatewideCertifiedVoteGap":-27},"latestParser":"nativeMontanaPrecinctResultsXlsx","nativeImportCount":6,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"NE","name":"Nebraska","authority":"Nebraska Secretary of State","resultRows":279,"resultJurisdictions":93,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":93,"taggedResultJurisdictions":93,"historical2020Jurisdictions":93,"taggedHistorical2020Jurisdictions":93,"matchedHistorical2020Jurisdictions":93,"missingHistorical2020Jurisdictions":0},"sourceCount":14,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":6,"countyIndicatorCount":6,"flaggedCountyJurisdictions":6,"flaggedAreas":6,"reviewRowCount":93,"turnoutRowCount":93,"historicalRowCount":279,"equipmentRowCount":93,"flaggedJurisdictions":6,"importRunCount":15,"legacyImportCount":5,"latestImportAt":"2026-07-02T00:22:31.238Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":17371,"nativeResultRows":93,"nativeReviewRows":93,"nativeTrumpVotes":564816,"storedResultRows":279,"storedReviewRows":93,"nativeBallotsCast":965145,"nativeHarrisVotes":369995,"nativeTurnoutRows":93,"storedTurnoutRows":93,"nativeReviewWarning":"Nebraska review rows are county-level President-versus-U.S. Senate two-year special election comparisons from the official 2024 General Canvass Book. They are useful for county review, but they are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":6,"nativeComparisonRows":93,"nativeHistoricalRows":279,"storedHistoricalRows":279,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":1263487,"nativeResultTotalVotes":952182,"nativeComparisonContest":"United States Senator (Two Year Term)","nativeHistoricalWarning":"Nebraska historical baseline rows are official county-level presidential results from 2012, 2016, and 2020 General Canvass Book PDFs. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":17371,"nativeResultRows":93,"nativeReviewRows":93,"nativeTrumpVotes":564816,"storedResultRows":279,"storedReviewRows":93,"nativeBallotsCast":965145,"nativeHarrisVotes":369995,"nativeTurnoutRows":93,"storedTurnoutRows":93,"nativeReviewWarning":"Nebraska review rows are county-level President-versus-U.S. Senate two-year special election comparisons from the official 2024 General Canvass Book. They are useful for county review, but they are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":6,"nativeComparisonRows":93,"nativeHistoricalRows":279,"storedHistoricalRows":279,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":1263487,"nativeResultTotalVotes":952182,"nativeComparisonContest":"United States Senator (Two Year Term)","nativeHistoricalWarning":"Nebraska historical baseline rows are official county-level presidential results from 2012, 2016, and 2020 General Canvass Book PDFs. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0},"latestParser":"nativeNebraskaCountyPresidentCsv","nativeImportCount":7,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"NV","name":"Nevada","authority":"Nevada Secretary of State","resultRows":51,"resultJurisdictions":17,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":17,"taggedResultJurisdictions":17,"historical2020Jurisdictions":17,"taggedHistorical2020Jurisdictions":17,"matchedHistorical2020Jurisdictions":17,"missingHistorical2020Jurisdictions":0},"sourceCount":12,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":4,"countyIndicatorCount":4,"flaggedCountyJurisdictions":3,"flaggedAreas":3,"reviewRowCount":1057,"turnoutRowCount":17,"historicalRowCount":51,"equipmentRowCount":17,"flaggedJurisdictions":3,"importRunCount":19,"legacyImportCount":5,"latestImportAt":"2026-07-02T06:23:36.639Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":28438,"nativeResultRows":17,"nativeReviewRows":1057,"nativeTrumpVotes":751205,"storedResultRows":51,"storedReviewRows":1057,"nativeBallotsCast":1486297,"nativeHarrisVotes":705197,"nativeTurnoutRows":17,"storedTurnoutRows":17,"nativeReviewWarning":"Nevada review rows now include Clark County, Washoe County, and Humboldt County official CVR precinct President-versus-U.S. Senate rows. The rest of Nevada remains county-level statewide-results context, and county CVR totals may differ from certified county totals, so statewide conclusions still require source-row inspection and additional county local exports.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":4,"nativeComparisonRows":1057,"nativeHistoricalRows":51,"storedHistoricalRows":51,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":2256275,"nativeResultTotalVotes":1484840,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Nevada historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with state-source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":17,"nativeReviewSourceCoverage":"Clark County, Washoe County, and Humboldt County official CVR precinct rows are loaded; the other 14 Nevada jurisdictions remain county-only until local exports or records-request productions are collected."},"latestNativeImportSummary":{"nativeOtherVotes":28438,"nativeResultRows":17,"nativeReviewRows":1057,"nativeTrumpVotes":751205,"storedResultRows":51,"storedReviewRows":1057,"nativeBallotsCast":1486297,"nativeHarrisVotes":705197,"nativeTurnoutRows":17,"storedTurnoutRows":17,"nativeReviewWarning":"Nevada review rows now include Clark County, Washoe County, and Humboldt County official CVR precinct President-versus-U.S. Senate rows. The rest of Nevada remains county-level statewide-results context, and county CVR totals may differ from certified county totals, so statewide conclusions still require source-row inspection and additional county local exports.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":4,"nativeComparisonRows":1057,"nativeHistoricalRows":51,"storedHistoricalRows":51,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":2256275,"nativeResultTotalVotes":1484840,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Nevada historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with state-source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":17,"nativeReviewSourceCoverage":"Clark County, Washoe County, and Humboldt County official CVR precinct rows are loaded; the other 14 Nevada jurisdictions remain county-only until local exports or records-request productions are collected."},"latestParser":"nativeNevadaStatewideGeneralCsv","nativeImportCount":11,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"NH","name":"New Hampshire","authority":"New Hampshire Secretary of State","resultRows":30,"resultJurisdictions":10,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":10,"taggedResultJurisdictions":10,"historical2020Jurisdictions":10,"taggedHistorical2020Jurisdictions":10,"matchedHistorical2020Jurisdictions":10,"missingHistorical2020Jurisdictions":0},"sourceCount":13,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":14,"countyIndicatorCount":14,"flaggedCountyJurisdictions":9,"flaggedAreas":9,"reviewRowCount":304,"turnoutRowCount":304,"historicalRowCount":20,"equipmentRowCount":10,"flaggedJurisdictions":9,"importRunCount":16,"legacyImportCount":4,"latestImportAt":"2026-07-09T22:12:14.617Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":12178,"nativeResultRows":10,"nativeReviewRows":304,"nativeTrumpVotes":395523,"storedResultRows":30,"storedReviewRows":304,"nativeBallotsCast":831468,"nativeHarrisVotes":418488,"nativeTurnoutRows":304,"storedTurnoutRows":304,"nativeReviewWarning":"New Hampshire review rows are town/ward-level President-versus-U.S.-House comparisons from archived official Secretary of State workbooks. U.S. House is a same-grain comparison but district-based rather than a single statewide contest, so directional labels remain advisory screening context. State-native ballots-cast and names-on-checklist turnout rows are loaded from official workbooks; detailed ballots-cast rows sum one vote above the county summary after a source correction note. Town/ward boundary geometry is not included.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":14,"nativeComparisonRows":304,"nativeHistoricalRows":20,"storedHistoricalRows":20,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":1013075,"nativeResultTotalVotes":826189,"nativeComparisonContest":"U.S. House","nativeHistoricalWarning":"New Hampshire historical baselines are county-level contextual rows normalized from archived official Secretary of State 2016 and 2020 President and presidential write-in workbooks. They are used for county flip context only; 2012 official sources remain request-blocked.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":12178,"nativeResultRows":10,"nativeReviewRows":304,"nativeTrumpVotes":395523,"storedResultRows":30,"storedReviewRows":304,"nativeBallotsCast":831468,"nativeHarrisVotes":418488,"nativeTurnoutRows":304,"storedTurnoutRows":304,"nativeReviewWarning":"New Hampshire review rows are town/ward-level President-versus-U.S.-House comparisons from archived official Secretary of State workbooks. U.S. House is a same-grain comparison but district-based rather than a single statewide contest, so directional labels remain advisory screening context. State-native ballots-cast and names-on-checklist turnout rows are loaded from official workbooks; detailed ballots-cast rows sum one vote above the county summary after a source correction note. Town/ward boundary geometry is not included.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":14,"nativeComparisonRows":304,"nativeHistoricalRows":20,"storedHistoricalRows":20,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":1013075,"nativeResultTotalVotes":826189,"nativeComparisonContest":"U.S. House","nativeHistoricalWarning":"New Hampshire historical baselines are county-level contextual rows normalized from archived official Secretary of State 2016 and 2020 President and presidential write-in workbooks. They are used for county flip context only; 2012 official sources remain request-blocked.","nativeTurnoutWarningRows":0},"latestParser":"nativeNewHampshireTownWardCsv","nativeImportCount":9,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"NJ","name":"New Jersey","authority":"New Jersey Department of State, Division of Elections","resultRows":63,"resultJurisdictions":21,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":21,"taggedResultJurisdictions":21,"historical2020Jurisdictions":21,"taggedHistorical2020Jurisdictions":21,"matchedHistorical2020Jurisdictions":21,"missingHistorical2020Jurisdictions":0},"sourceCount":20,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":8,"countyIndicatorCount":8,"flaggedCountyJurisdictions":8,"flaggedAreas":8,"reviewRowCount":21,"turnoutRowCount":21,"historicalRowCount":42,"equipmentRowCount":21,"flaggedJurisdictions":8,"importRunCount":16,"legacyImportCount":7,"latestImportAt":"2026-07-11T03:09:06.384Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":83797,"nativeResultRows":21,"nativeReviewRows":21,"nativeTrumpVotes":1968215,"storedResultRows":63,"storedReviewRows":21,"nativeBallotsCast":4321921,"nativeHarrisVotes":2220713,"nativeTurnoutRows":21,"storedTurnoutRows":21,"nativeReviewWarning":"New Jersey review rows are county-level President-versus-U.S.-Senate comparisons from official statewide DOE PDFs. They are useful public-interest source-review inputs, but they are not municipal or precinct scatter plots. Municipal DOE PDFs, municipal geometry/crosswalks, and non-geographic Federal Overseas or Hand Counts handling remain follow-up work.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":8,"nativeComparisonRows":21,"nativeHistoricalRows":42,"storedHistoricalRows":42,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":6682699,"nativeResultTotalVotes":4272725,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"New Jersey historical baseline rows are official county-level 2016 and 2020 General Election President results from New Jersey Department of State, Division of Elections artifacts. Use them as contextual baseline rows for jurisdictionTag county flip joins, not as 2024 certified data. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":83797,"nativeResultRows":21,"nativeReviewRows":21,"nativeTrumpVotes":1968215,"storedResultRows":63,"storedReviewRows":21,"nativeBallotsCast":4321921,"nativeHarrisVotes":2220713,"nativeTurnoutRows":21,"storedTurnoutRows":21,"nativeReviewWarning":"New Jersey review rows are county-level President-versus-U.S.-Senate comparisons from official statewide DOE PDFs. They are useful public-interest source-review inputs, but they are not municipal or precinct scatter plots. Municipal DOE PDFs, municipal geometry/crosswalks, and non-geographic Federal Overseas or Hand Counts handling remain follow-up work.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":8,"nativeComparisonRows":21,"nativeHistoricalRows":42,"storedHistoricalRows":42,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":6682699,"nativeResultTotalVotes":4272725,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"New Jersey historical baseline rows are official county-level 2016 and 2020 General Election President results from New Jersey Department of State, Division of Elections artifacts. Use them as contextual baseline rows for jurisdictionTag county flip joins, not as 2024 certified data. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0},"latestParser":"nativeCountyPresidentCsv","nativeImportCount":6,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"NM","name":"New Mexico","authority":"New Mexico Secretary of State; U.S. Election Assistance Commission","resultRows":99,"resultJurisdictions":33,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":33,"taggedResultJurisdictions":33,"historical2020Jurisdictions":33,"taggedHistorical2020Jurisdictions":33,"matchedHistorical2020Jurisdictions":33,"missingHistorical2020Jurisdictions":0},"sourceCount":15,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":53,"countyIndicatorCount":53,"flaggedCountyJurisdictions":29,"flaggedAreas":29,"reviewRowCount":2165,"turnoutRowCount":33,"historicalRowCount":66,"equipmentRowCount":33,"flaggedJurisdictions":29,"importRunCount":15,"legacyImportCount":7,"latestImportAt":"2026-07-06T22:57:52.734Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":21210,"nativeResultRows":33,"nativeReviewRows":2165,"nativeTrumpVotes":423391,"storedResultRows":99,"storedReviewRows":2165,"nativeBallotsCast":927923,"nativeHarrisVotes":478802,"nativeTurnoutRows":33,"storedTurnoutRows":33,"nativeReviewWarning":"Official SOS precinct mapdata masks many small candidate counts with '*'. The parser infers masked counts from SOS percentages and de-duplicates repeated county/precinct/candidate rows. After that, 2,169 President precinct keys produce 2,165 nonzero review rows; four zero-vote precinct keys are skipped. President and U.S. Senate precinct totals are each 7 votes below the corresponding county-level certified totals, so review rows are advisory screening context only and not evidence of fraud or misconduct.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":53,"nativeComparisonRows":2165,"nativeHistoricalRows":66,"storedHistoricalRows":66,"nativeComparisonVotes":903304,"nativeHistoricalYears":[2016,2020],"nativeMaskedCountyRows":24,"nativeMaskedReviewRows":9430,"nativeRegisteredVoters":1415984,"nativeResultTotalVotes":923403,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Official SOS API county historical baselines are loaded for 2020 and 2016. The 2012 archive routes to the legacy election statistics hub and remains unnormalized.","nativeTurnoutWarningRows":0,"nativeHistoricalMaskedRows":39,"nativePresidentPrecinctKeys":2169,"nativeReviewCertifiedVoteGap":7,"nativeReviewPresidentialVotes":923396,"nativeReviewZeroVoteUnitsSkipped":4,"nativePresidentPrecinctDuplicatesDropped":49,"nativeComparisonPrecinctDuplicatesDropped":14},"latestNativeImportSummary":{"nativeOtherVotes":21210,"nativeResultRows":33,"nativeReviewRows":2165,"nativeTrumpVotes":423391,"storedResultRows":99,"storedReviewRows":2165,"nativeBallotsCast":927923,"nativeHarrisVotes":478802,"nativeTurnoutRows":33,"storedTurnoutRows":33,"nativeReviewWarning":"Official SOS precinct mapdata masks many small candidate counts with '*'. The parser infers masked counts from SOS percentages and de-duplicates repeated county/precinct/candidate rows. After that, 2,169 President precinct keys produce 2,165 nonzero review rows; four zero-vote precinct keys are skipped. President and U.S. Senate precinct totals are each 7 votes below the corresponding county-level certified totals, so review rows are advisory screening context only and not evidence of fraud or misconduct.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":53,"nativeComparisonRows":2165,"nativeHistoricalRows":66,"storedHistoricalRows":66,"nativeComparisonVotes":903304,"nativeHistoricalYears":[2016,2020],"nativeMaskedCountyRows":24,"nativeMaskedReviewRows":9430,"nativeRegisteredVoters":1415984,"nativeResultTotalVotes":923403,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Official SOS API county historical baselines are loaded for 2020 and 2016. The 2012 archive routes to the legacy election statistics hub and remains unnormalized.","nativeTurnoutWarningRows":0,"nativeHistoricalMaskedRows":39,"nativePresidentPrecinctKeys":2169,"nativeReviewCertifiedVoteGap":7,"nativeReviewPresidentialVotes":923396,"nativeReviewZeroVoteUnitsSkipped":4,"nativePresidentPrecinctDuplicatesDropped":49,"nativeComparisonPrecinctDuplicatesDropped":14},"latestParser":"nativeNewMexicoSosMapDataJson","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"NY","name":"New York","authority":"New York State Board of Elections","resultRows":186,"resultJurisdictions":62,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":62,"taggedResultJurisdictions":62,"historical2020Jurisdictions":62,"taggedHistorical2020Jurisdictions":62,"matchedHistorical2020Jurisdictions":62,"missingHistorical2020Jurisdictions":0},"sourceCount":14,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":85,"countyIndicatorCount":85,"flaggedCountyJurisdictions":50,"flaggedAreas":50,"reviewRowCount":10408,"turnoutRowCount":62,"historicalRowCount":186,"equipmentRowCount":62,"flaggedJurisdictions":50,"importRunCount":46,"legacyImportCount":5,"latestImportAt":"2026-07-04T23:10:15.208Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":182367,"nativeResultRows":62,"nativeReviewRows":10408,"nativeTrumpVotes":3579519,"storedResultRows":186,"storedReviewRows":10408,"nativeBallotsCast":8389626,"nativeHarrisVotes":4619543,"nativeTurnoutRows":62,"storedTurnoutRows":62,"nativeReviewWarning":"New York local review rows are election-district President-versus-U.S. Senate comparisons normalized from machine-readable OpenElections county source files, selected text-layer OpenElections PDFs, reconciled official Monroe County detail rows, plus legacy NYC local review rows. Image-only, president-only, unsupported, or unreviewed counties are not included yet, and county-certified result totals remain the map authority.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":85,"nativeComparisonRows":10408,"nativeHistoricalRows":186,"storedHistoricalRows":186,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":13579416,"nativeResultTotalVotes":8381429,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"New York historical baseline rows are county-level presidential results from official NYSBOE general-election PDFs for 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data. 2012 and 2016 include separate official presidential write-in final totals; 2020 uses the presidential table write-in column.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":"Machine-readable OpenElections county source files, selected text-layer OpenElections PDFs, reconciled official Monroe County detail rows, plus legacy NYC local review rows; image-only, president-only, unsupported, or unreviewed counties are not included in this review-row CSV yet."},"latestNativeImportSummary":{"nativeOtherVotes":182367,"nativeResultRows":62,"nativeReviewRows":10408,"nativeTrumpVotes":3579519,"storedResultRows":186,"storedReviewRows":10408,"nativeBallotsCast":8389626,"nativeHarrisVotes":4619543,"nativeTurnoutRows":62,"storedTurnoutRows":62,"nativeReviewWarning":"New York local review rows are election-district President-versus-U.S. Senate comparisons normalized from machine-readable OpenElections county source files, selected text-layer OpenElections PDFs, reconciled official Monroe County detail rows, plus legacy NYC local review rows. Image-only, president-only, unsupported, or unreviewed counties are not included yet, and county-certified result totals remain the map authority.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":85,"nativeComparisonRows":10408,"nativeHistoricalRows":186,"storedHistoricalRows":186,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":13579416,"nativeResultTotalVotes":8381429,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"New York historical baseline rows are county-level presidential results from official NYSBOE general-election PDFs for 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data. 2012 and 2016 include separate official presidential write-in final totals; 2020 uses the presidential table write-in column.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":"Machine-readable OpenElections county source files, selected text-layer OpenElections PDFs, reconciled official Monroe County detail rows, plus legacy NYC local review rows; image-only, president-only, unsupported, or unreviewed counties are not included in this review-row CSV yet."},"latestParser":"nativeNewYorkCountyPresidentCsv","nativeImportCount":38,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"NC","name":"North Carolina","authority":"North Carolina State Board of Elections","resultRows":300,"resultJurisdictions":100,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":100,"taggedResultJurisdictions":100,"historical2020Jurisdictions":100,"taggedHistorical2020Jurisdictions":100,"matchedHistorical2020Jurisdictions":100,"missingHistorical2020Jurisdictions":0},"sourceCount":8,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":206,"countyIndicatorCount":206,"flaggedCountyJurisdictions":86,"flaggedAreas":86,"reviewRowCount":2658,"turnoutRowCount":100,"historicalRowCount":300,"equipmentRowCount":100,"flaggedJurisdictions":86,"importRunCount":17,"legacyImportCount":4,"latestImportAt":"2026-07-13T02:11:37.841Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":85343,"nativeResultRows":100,"nativeReviewRows":2658,"nativeTrumpVotes":2898423,"storedResultRows":300,"storedReviewRows":2658,"nativeBallotsCast":5756106,"nativeHarrisVotes":2715375,"nativeTurnoutRows":100,"storedTurnoutRows":100,"nativeReviewWarning":"North Carolina native review rows use the official NCSBE Real Precinct=Y filter for precinct-only presidential vote-share screening and presidential-versus-Governor same-party drop-off screening. Certified county totals still aggregate all official reporting units, including early voting, absentee, provisional, and transfer rows. The comparison contest is Governor, not U.S. Senate, because North Carolina did not have a 2024 U.S. Senate race.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":206,"nativeComparisonRows":2658,"nativeHistoricalRows":300,"storedHistoricalRows":300,"historicalReviewYears":[2016,2020],"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":7854464,"nativeResultTotalVotes":5699141,"storedReviewRowsByYear":{"2016":100,"2020":2662,"2024":2658},"nativeComparisonContest":"North Carolina Governor","nativeHistoricalWarning":"North Carolina historical baseline rows are county-level presidential aggregates generated from official NCSBE 2012, 2016, and 2020 precinct results ZIPs. Use them as contextual baselines, not as 2024 certified data or precinct-sort geometry.","nativeTurnoutWarningRows":100,"storedIndicatorRowsByYear":{"2016":14,"2020":166,"2024":206},"nativeHistoricalReviewRows":2762,"storedHistoricalReviewRows":2762,"nativeHistoricalReviewYears":[2016,2020],"nativeReviewCertifiedVoteGap":1775402,"nativeHistoricalReviewWarning":"North Carolina 2016 historical advisory rows aggregate every official President and U.S. Senate reporting row by the explicit source County field and make no precinct-level claim. The 2020 rows include only official same-grain keys marked Real Precinct=Y; 403 Real Precinct=N administrative keys are excluded and exactly reconciled. Candidate and contest differences can explain the calculated patterns. Advisory indicators are review signals, not proof of fraud or misconduct.","nativeReviewPresidentialVotes":3923739,"storedHistoricalIndicatorRows":180,"nativeReviewReportingUnitFilter":"Real Precinct=Y","nativeHistoricalReviewRowsByYear":{"2016":100,"2020":2662},"nativeReviewExcludedReportingUnits":250,"nativeHistoricalReviewComparisonRows":2762,"nativeReviewExcludedPresidentialVotes":1775402},"latestNativeImportSummary":{"nativeOtherVotes":85343,"nativeResultRows":100,"nativeReviewRows":2658,"nativeTrumpVotes":2898423,"storedResultRows":300,"storedReviewRows":2658,"nativeBallotsCast":5756106,"nativeHarrisVotes":2715375,"nativeTurnoutRows":100,"storedTurnoutRows":100,"nativeReviewWarning":"North Carolina native review rows use the official NCSBE Real Precinct=Y filter for precinct-only presidential vote-share screening and presidential-versus-Governor same-party drop-off screening. Certified county totals still aggregate all official reporting units, including early voting, absentee, provisional, and transfer rows. The comparison contest is Governor, not U.S. Senate, because North Carolina did not have a 2024 U.S. Senate race.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":206,"nativeComparisonRows":2658,"nativeHistoricalRows":300,"storedHistoricalRows":300,"historicalReviewYears":[2016,2020],"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":7854464,"nativeResultTotalVotes":5699141,"storedReviewRowsByYear":{"2016":100,"2020":2662,"2024":2658},"nativeComparisonContest":"North Carolina Governor","nativeHistoricalWarning":"North Carolina historical baseline rows are county-level presidential aggregates generated from official NCSBE 2012, 2016, and 2020 precinct results ZIPs. Use them as contextual baselines, not as 2024 certified data or precinct-sort geometry.","nativeTurnoutWarningRows":100,"storedIndicatorRowsByYear":{"2016":14,"2020":166,"2024":206},"nativeHistoricalReviewRows":2762,"storedHistoricalReviewRows":2762,"nativeHistoricalReviewYears":[2016,2020],"nativeReviewCertifiedVoteGap":1775402,"nativeHistoricalReviewWarning":"North Carolina 2016 historical advisory rows aggregate every official President and U.S. Senate reporting row by the explicit source County field and make no precinct-level claim. The 2020 rows include only official same-grain keys marked Real Precinct=Y; 403 Real Precinct=N administrative keys are excluded and exactly reconciled. Candidate and contest differences can explain the calculated patterns. Advisory indicators are review signals, not proof of fraud or misconduct.","nativeReviewPresidentialVotes":3923739,"storedHistoricalIndicatorRows":180,"nativeReviewReportingUnitFilter":"Real Precinct=Y","nativeHistoricalReviewRowsByYear":{"2016":100,"2020":2662},"nativeReviewExcludedReportingUnits":250,"nativeHistoricalReviewComparisonRows":2762,"nativeReviewExcludedPresidentialVotes":1775402},"latestParser":"nativeNorthCarolinaPrecinctResultsZip","nativeImportCount":10,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"ND","name":"North Dakota","authority":"North Dakota Secretary of State; U.S. Election Assistance Commission","resultRows":159,"resultJurisdictions":53,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":53,"taggedResultJurisdictions":53,"historical2020Jurisdictions":53,"taggedHistorical2020Jurisdictions":53,"matchedHistorical2020Jurisdictions":53,"missingHistorical2020Jurisdictions":0},"sourceCount":9,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":32,"countyIndicatorCount":32,"flaggedCountyJurisdictions":17,"flaggedAreas":17,"reviewRowCount":383,"turnoutRowCount":53,"historicalRowCount":212,"equipmentRowCount":53,"flaggedJurisdictions":17,"importRunCount":15,"legacyImportCount":7,"latestImportAt":"2026-07-03T06:04:35.014Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":9323,"nativeResultRows":53,"nativeReviewRows":383,"nativeTrumpVotes":246505,"storedResultRows":159,"storedReviewRows":383,"nativeBallotsCast":371974,"nativeHarrisVotes":112327,"nativeTurnoutRows":53,"storedTurnoutRows":53,"nativeReviewWarning":"North Dakota review rows are same-key President-versus-U.S.-Senate precinct rows from the official SOS ResultsAjax dashboard endpoint. Rows are advisory source-review context only, not findings. The active turnout denominator remains EAC fallback with a zero registered-voter denominator because North Dakota does not require voter registration; state-native eligible-voter denominator replacement still needs reconciliation.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":32,"nativeComparisonRows":383,"nativeHistoricalRows":0,"storedHistoricalRows":0,"nativeRegisteredVoters":0,"nativeResultTotalVotes":368155,"nativeComparisonContest":"U.S. Senate","nativeTurnoutWarningRows":53,"nativeReviewSourceCoverage":"official_sos_resultsajax_county_scoped_precinct_rows"},"latestNativeImportSummary":{"nativeOtherVotes":9323,"nativeResultRows":53,"nativeReviewRows":383,"nativeTrumpVotes":246505,"storedResultRows":159,"storedReviewRows":383,"nativeBallotsCast":371974,"nativeHarrisVotes":112327,"nativeTurnoutRows":53,"storedTurnoutRows":53,"nativeReviewWarning":"North Dakota review rows are same-key President-versus-U.S.-Senate precinct rows from the official SOS ResultsAjax dashboard endpoint. Rows are advisory source-review context only, not findings. The active turnout denominator remains EAC fallback with a zero registered-voter denominator because North Dakota does not require voter registration; state-native eligible-voter denominator replacement still needs reconciliation.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":32,"nativeComparisonRows":383,"nativeHistoricalRows":0,"storedHistoricalRows":0,"nativeRegisteredVoters":0,"nativeResultTotalVotes":368155,"nativeComparisonContest":"U.S. Senate","nativeTurnoutWarningRows":53,"nativeReviewSourceCoverage":"official_sos_resultsajax_county_scoped_precinct_rows"},"latestParser":"nativeCountyPresidentCsv","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"OH","name":"Ohio","authority":"Ohio Secretary of State","resultRows":264,"resultJurisdictions":88,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":88,"taggedResultJurisdictions":88,"historical2020Jurisdictions":88,"taggedHistorical2020Jurisdictions":88,"matchedHistorical2020Jurisdictions":88,"missingHistorical2020Jurisdictions":0},"sourceCount":6,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":174,"countyIndicatorCount":174,"flaggedCountyJurisdictions":88,"flaggedAreas":88,"reviewRowCount":8878,"turnoutRowCount":8878,"historicalRowCount":264,"equipmentRowCount":88,"flaggedJurisdictions":88,"importRunCount":12,"legacyImportCount":4,"latestImportAt":"2026-06-30T02:02:31.296Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":53973,"nativeResultRows":88,"nativeReviewRows":8878,"nativeTrumpVotes":3180116,"storedResultRows":264,"storedReviewRows":8878,"nativeBallotsCast":5851387,"nativeHarrisVotes":2533699,"nativeTurnoutRows":8878,"storedTurnoutRows":8878,"nativeReviewWarning":"Ohio native review rows use official precinct presidential vote-share screening and President-versus-U.S. Senate same-party drop-off screening from the Secretary of State precinct workbook.","storedIndicatorRows":174,"nativeComparisonRows":8878,"nativeHistoricalRows":264,"storedHistoricalRows":264,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":8159946,"nativeResultTotalVotes":5767788,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Ohio historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data."},"latestNativeImportSummary":{"nativeOtherVotes":53973,"nativeResultRows":88,"nativeReviewRows":8878,"nativeTrumpVotes":3180116,"storedResultRows":264,"storedReviewRows":8878,"nativeBallotsCast":5851387,"nativeHarrisVotes":2533699,"nativeTurnoutRows":8878,"storedTurnoutRows":8878,"nativeReviewWarning":"Ohio native review rows use official precinct presidential vote-share screening and President-versus-U.S. Senate same-party drop-off screening from the Secretary of State precinct workbook.","storedIndicatorRows":174,"nativeComparisonRows":8878,"nativeHistoricalRows":264,"storedHistoricalRows":264,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":8159946,"nativeResultTotalVotes":5767788,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Ohio historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data."},"latestParser":"nativeOhioOfficialXlsx","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"OK","name":"Oklahoma","authority":"Oklahoma State Election Board","resultRows":231,"resultJurisdictions":77,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":77,"taggedResultJurisdictions":77,"historical2020Jurisdictions":77,"taggedHistorical2020Jurisdictions":77,"matchedHistorical2020Jurisdictions":77,"missingHistorical2020Jurisdictions":0},"sourceCount":13,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":99,"countyIndicatorCount":99,"flaggedCountyJurisdictions":66,"flaggedAreas":66,"reviewRowCount":1977,"turnoutRowCount":77,"historicalRowCount":154,"equipmentRowCount":77,"flaggedJurisdictions":66,"importRunCount":15,"legacyImportCount":5,"latestImportAt":"2026-07-11T03:09:22.405Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":30361,"nativeResultRows":77,"nativeReviewRows":1977,"nativeTrumpVotes":1036213,"storedResultRows":231,"storedReviewRows":1977,"nativeBallotsCast":1573274,"nativeHarrisVotes":499599,"nativeTurnoutRows":77,"storedTurnoutRows":77,"nativeReviewWarning":"Oklahoma native review rows use official precinct presidential vote-share screening and same-precinct President-versus-U.S. House comparison only where the exported precinct has both Democratic and Republican U.S. House candidate votes. U.S. House District 3 and other non-comparable precincts are retained as vote-share-only rows.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":99,"nativeComparisonRows":1517,"nativeHistoricalRows":154,"storedHistoricalRows":154,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":2442211,"nativeResultTotalVotes":1566173,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Oklahoma historical baseline rows come from official State Election Board county candidate exports for President race 10001. The 2016 export contains three presidential tickets and the 2020 export contains six presidential tickets (Democratic, Republican, Libertarian, and three independent tickets); all non-Democratic/non-Republican candidate votes are retained in other_votes. These are contextual jurisdictionTag flip baselines, not 2024 certified-result rows. Historical jurisdiction names use canonical Census display names while local_unit preserves official export labels; county:40079 therefore displays as Le Flore County in staging. Official 2012 county baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeOklahomaHousePrecinctRows":1517,"nativeOklahomaVoteShareOnlyRows":460,"nativeOklahomaUnknownCountyCodes":[],"nativeOklahomaRaceLevelOtherVotes":30361,"nativeOklahomaRaceLevelTotalVotes":1566173,"nativeOklahomaRaceLevelTrumpVotes":1036213,"nativeOklahomaRaceLevelHarrisVotes":499599,"nativeOklahomaZeroTotalPresidentialPrecincts":9},"latestNativeImportSummary":{"nativeOtherVotes":30361,"nativeResultRows":77,"nativeReviewRows":1977,"nativeTrumpVotes":1036213,"storedResultRows":231,"storedReviewRows":1977,"nativeBallotsCast":1573274,"nativeHarrisVotes":499599,"nativeTurnoutRows":77,"storedTurnoutRows":77,"nativeReviewWarning":"Oklahoma native review rows use official precinct presidential vote-share screening and same-precinct President-versus-U.S. House comparison only where the exported precinct has both Democratic and Republican U.S. House candidate votes. U.S. House District 3 and other non-comparable precincts are retained as vote-share-only rows.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":99,"nativeComparisonRows":1517,"nativeHistoricalRows":154,"storedHistoricalRows":154,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":2442211,"nativeResultTotalVotes":1566173,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"Oklahoma historical baseline rows come from official State Election Board county candidate exports for President race 10001. The 2016 export contains three presidential tickets and the 2020 export contains six presidential tickets (Democratic, Republican, Libertarian, and three independent tickets); all non-Democratic/non-Republican candidate votes are retained in other_votes. These are contextual jurisdictionTag flip baselines, not 2024 certified-result rows. Historical jurisdiction names use canonical Census display names while local_unit preserves official export labels; county:40079 therefore displays as Le Flore County in staging. Official 2012 county baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeOklahomaHousePrecinctRows":1517,"nativeOklahomaVoteShareOnlyRows":460,"nativeOklahomaUnknownCountyCodes":[],"nativeOklahomaRaceLevelOtherVotes":30361,"nativeOklahomaRaceLevelTotalVotes":1566173,"nativeOklahomaRaceLevelTrumpVotes":1036213,"nativeOklahomaRaceLevelHarrisVotes":499599,"nativeOklahomaZeroTotalPresidentialPrecincts":9},"latestParser":"nativeOklahomaOfficialCsvZip","nativeImportCount":7,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"OR","name":"Oregon","authority":"Oregon Secretary of State","resultRows":108,"resultJurisdictions":36,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":36,"taggedResultJurisdictions":36,"historical2020Jurisdictions":36,"taggedHistorical2020Jurisdictions":36,"matchedHistorical2020Jurisdictions":36,"missingHistorical2020Jurisdictions":0},"sourceCount":14,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":6,"countyIndicatorCount":6,"flaggedCountyJurisdictions":6,"flaggedAreas":6,"reviewRowCount":36,"turnoutRowCount":36,"historicalRowCount":72,"equipmentRowCount":36,"flaggedJurisdictions":6,"importRunCount":13,"legacyImportCount":5,"latestImportAt":"2026-07-11T03:11:26.766Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":84413,"nativeResultRows":36,"nativeReviewRows":36,"nativeTrumpVotes":919480,"storedResultRows":108,"storedReviewRows":36,"nativeBallotsCast":2269608,"nativeHarrisVotes":1240600,"nativeTurnoutRows":36,"storedTurnoutRows":36,"nativeReviewWarning":"Oregon review rows are county-level President-versus-Attorney General comparisons from official Abstract of Votes county totals. They support county-level flags and directional screening, but they are not precinct-level vote-share scatter plots. Official county precinct artifacts are collected for provenance and later OCR-backed normalization.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":6,"nativeComparisonRows":36,"nativeHistoricalRows":72,"storedHistoricalRows":72,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":3060374,"nativeResultTotalVotes":2244493,"nativeComparisonContest":"Attorney General","nativeHistoricalWarning":"Oregon historical baselines use official General Election Abstract of Votes county presidential PDF rows for 2016 and 2020. Use them as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":84413,"nativeResultRows":36,"nativeReviewRows":36,"nativeTrumpVotes":919480,"storedResultRows":108,"storedReviewRows":36,"nativeBallotsCast":2269608,"nativeHarrisVotes":1240600,"nativeTurnoutRows":36,"storedTurnoutRows":36,"nativeReviewWarning":"Oregon review rows are county-level President-versus-Attorney General comparisons from official Abstract of Votes county totals. They support county-level flags and directional screening, but they are not precinct-level vote-share scatter plots. Official county precinct artifacts are collected for provenance and later OCR-backed normalization.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":6,"nativeComparisonRows":36,"nativeHistoricalRows":72,"storedHistoricalRows":72,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":3060374,"nativeResultTotalVotes":2244493,"nativeComparisonContest":"Attorney General","nativeHistoricalWarning":"Oregon historical baselines use official General Election Abstract of Votes county presidential PDF rows for 2016 and 2020. Use them as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0},"latestParser":"nativeOregonCountyPresidentCsv","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"PA","name":"Pennsylvania","authority":"Pennsylvania Department of State","resultRows":201,"resultJurisdictions":67,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":67,"taggedResultJurisdictions":67,"historical2020Jurisdictions":67,"taggedHistorical2020Jurisdictions":67,"matchedHistorical2020Jurisdictions":67,"missingHistorical2020Jurisdictions":0},"sourceCount":8,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":111,"countyIndicatorCount":111,"flaggedCountyJurisdictions":66,"flaggedAreas":66,"reviewRowCount":9154,"turnoutRowCount":67,"historicalRowCount":201,"equipmentRowCount":67,"flaggedJurisdictions":66,"importRunCount":14,"legacyImportCount":4,"latestImportAt":"2026-07-06T23:05:47.891Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":67831,"nativeResultRows":67,"nativeReviewRows":9154,"nativeTrumpVotes":3543041,"storedResultRows":201,"storedReviewRows":9154,"nativeBallotsCast":7074630,"nativeHarrisVotes":3420865,"nativeTurnoutRows":67,"storedTurnoutRows":67,"nativeReviewWarning":"Pennsylvania native review rows use precinct-level presidential vote-share screening and presidential-versus-U.S. Senate same-party drop-off screening. Two presidential precinct groups do not have Senate rows and are kept as vote-share-only rows.","storedIndicatorRows":111,"nativeComparisonRows":9152,"nativeHistoricalRows":201,"storedHistoricalRows":201,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":9175132,"nativeResultTotalVotes":7031737,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Pennsylvania historical baseline rows are contextual county-level presidential rows aggregated from official Department of State 2012, 2016, and 2020 precinct election-return bulk files. Use them as historical baselines, not as 2024 certified data. The official bulk rows do not include a separate write-in reconciliation artifact, so totals can differ from secondary certified-summary tables."},"latestNativeImportSummary":{"nativeOtherVotes":67831,"nativeResultRows":67,"nativeReviewRows":9154,"nativeTrumpVotes":3543041,"storedResultRows":201,"storedReviewRows":9154,"nativeBallotsCast":7074630,"nativeHarrisVotes":3420865,"nativeTurnoutRows":67,"storedTurnoutRows":67,"nativeReviewWarning":"Pennsylvania native review rows use precinct-level presidential vote-share screening and presidential-versus-U.S. Senate same-party drop-off screening. Two presidential precinct groups do not have Senate rows and are kept as vote-share-only rows.","storedIndicatorRows":111,"nativeComparisonRows":9152,"nativeHistoricalRows":201,"storedHistoricalRows":201,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":9175132,"nativeResultTotalVotes":7031737,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Pennsylvania historical baseline rows are contextual county-level presidential rows aggregated from official Department of State 2012, 2016, and 2020 precinct election-return bulk files. Use them as historical baselines, not as 2024 certified data. The official bulk rows do not include a separate write-in reconciliation artifact, so totals can differ from secondary certified-summary tables."},"latestParser":"nativePennsylvaniaBulkCsv","nativeImportCount":7,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"RI","name":"Rhode Island","authority":"Rhode Island Board of Elections","resultRows":18,"resultJurisdictions":6,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":6,"taggedResultJurisdictions":5,"historical2020Jurisdictions":6,"taggedHistorical2020Jurisdictions":5,"matchedHistorical2020Jurisdictions":5,"missingHistorical2020Jurisdictions":0},"sourceCount":15,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":6,"countyIndicatorCount":6,"flaggedCountyJurisdictions":5,"flaggedAreas":5,"reviewRowCount":444,"turnoutRowCount":39,"historicalRowCount":18,"equipmentRowCount":5,"flaggedJurisdictions":5,"importRunCount":18,"legacyImportCount":6,"latestImportAt":"2026-07-11T03:11:46.068Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":13824,"nativeResultRows":6,"nativeReviewRows":444,"nativeTrumpVotes":214406,"storedResultRows":18,"storedReviewRows":444,"nativeBallotsCast":522164,"nativeHarrisVotes":285156,"nativeTurnoutRows":39,"storedTurnoutRows":39,"nativeMapResultRows":5,"nativeReviewWarning":"Rhode Island review rows are same-key President-versus-U.S.-Senate rows normalized from the explicit finalized root member of the official BOE long-format ZIP. President and U.S. Senate contest totals exactly match posted statewide JSON; 39 presidential-only rows do not have same-key Senate comparison rows and 14 zero-vote same-key rows are excluded. Review rows are advisory source-review signals, not findings. The certified-result map uses county aggregation from official city/town rows; Federal Precincts is retained as non-geographic and is not mapped. City/town or precinct geometry/crosswalks are not loaded.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":6,"nativeComparisonRows":444,"nativeHistoricalRows":18,"storedHistoricalRows":18,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":792075,"nativeResultTotalVotes":513386,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Rhode Island historical baseline rows are contextual official BOE county-aggregated rows for 2012, 2016, and 2020, plus non-geographic Federal Precincts rows left unforced for county FIPS joins. Each archive is read from an explicit finalized root member and validated against its official statewide JSON totals. The read-only production-versus-staging reconciliation accepts the intentional 2012/2016 municipal-to-county display-grain replacement: all five county aggregates plus Federal Precincts reconcile with zero vote delta in every year. This acceptance does not itself authorize production promotion.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":"","nativeNonGeographicResultRows":1},"latestNativeImportSummary":{"nativeOtherVotes":13824,"nativeResultRows":6,"nativeReviewRows":444,"nativeTrumpVotes":214406,"storedResultRows":18,"storedReviewRows":444,"nativeBallotsCast":522164,"nativeHarrisVotes":285156,"nativeTurnoutRows":39,"storedTurnoutRows":39,"nativeMapResultRows":5,"nativeReviewWarning":"Rhode Island review rows are same-key President-versus-U.S.-Senate rows normalized from the explicit finalized root member of the official BOE long-format ZIP. President and U.S. Senate contest totals exactly match posted statewide JSON; 39 presidential-only rows do not have same-key Senate comparison rows and 14 zero-vote same-key rows are excluded. Review rows are advisory source-review signals, not findings. The certified-result map uses county aggregation from official city/town rows; Federal Precincts is retained as non-geographic and is not mapped. City/town or precinct geometry/crosswalks are not loaded.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":6,"nativeComparisonRows":444,"nativeHistoricalRows":18,"storedHistoricalRows":18,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":792075,"nativeResultTotalVotes":513386,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Rhode Island historical baseline rows are contextual official BOE county-aggregated rows for 2012, 2016, and 2020, plus non-geographic Federal Precincts rows left unforced for county FIPS joins. Each archive is read from an explicit finalized root member and validated against its official statewide JSON totals. The read-only production-versus-staging reconciliation accepts the intentional 2012/2016 municipal-to-county display-grain replacement: all five county aggregates plus Federal Precincts reconcile with zero vote delta in every year. This acceptance does not itself authorize production promotion.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":"","nativeNonGeographicResultRows":1},"latestParser":"nativeRhodeIslandBoeCsv","nativeImportCount":9,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":["1 result jurisdiction missing canonical tags"]},{"state":"SC","name":"South Carolina","authority":"South Carolina Election Commission","resultRows":138,"resultJurisdictions":46,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":46,"taggedResultJurisdictions":46,"historical2020Jurisdictions":46,"taggedHistorical2020Jurisdictions":46,"matchedHistorical2020Jurisdictions":46,"missingHistorical2020Jurisdictions":0},"sourceCount":11,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":78,"countyIndicatorCount":78,"flaggedCountyJurisdictions":45,"flaggedAreas":45,"reviewRowCount":2401,"turnoutRowCount":46,"historicalRowCount":92,"equipmentRowCount":46,"flaggedJurisdictions":45,"importRunCount":13,"legacyImportCount":5,"latestImportAt":"2026-07-11T03:12:23.524Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":35941,"nativeResultRows":46,"nativeReviewRows":2401,"nativeTrumpVotes":1483747,"storedResultRows":138,"storedReviewRows":2401,"nativeBallotsCast":2553185,"nativeHarrisVotes":1028452,"nativeTurnoutRows":46,"storedTurnoutRows":46,"nativeReviewWarning":"South Carolina review rows use official South Carolina Elections Database precinct presidential rows and President-versus-U.S.-House comparison rows. U.S. House is district-based rather than a single statewide comparison race; duplicate county/precinct keys from district splits are aggregated before comparison, one nonzero presidential row lacks a nonzero House comparison and is kept as vote-share-only, and precinct boundary geometry is not included. Use these rows as advisory screening inputs, not confirmed findings.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":78,"nativeComparisonRows":2400,"nativeHistoricalRows":92,"storedHistoricalRows":92,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":3851930,"nativeResultTotalVotes":2548140,"nativeComparisonContest":"United States House","nativeHistoricalWarning":"South Carolina historical baselines use official Elections Database county presidential CSV rows for 2016 and 2020. Use them as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":46,"nativeMissingComparisonRows":1,"nativeComparisonPrecinctRows":2491,"nativeDuplicateComparisonRows":45,"nativePresidentialPrecinctRows":2446,"nativeZeroPresidentialPrecinctRows":45},"latestNativeImportSummary":{"nativeOtherVotes":35941,"nativeResultRows":46,"nativeReviewRows":2401,"nativeTrumpVotes":1483747,"storedResultRows":138,"storedReviewRows":2401,"nativeBallotsCast":2553185,"nativeHarrisVotes":1028452,"nativeTurnoutRows":46,"storedTurnoutRows":46,"nativeReviewWarning":"South Carolina review rows use official South Carolina Elections Database precinct presidential rows and President-versus-U.S.-House comparison rows. U.S. House is district-based rather than a single statewide comparison race; duplicate county/precinct keys from district splits are aggregated before comparison, one nonzero presidential row lacks a nonzero House comparison and is kept as vote-share-only, and precinct boundary geometry is not included. Use these rows as advisory screening inputs, not confirmed findings.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":78,"nativeComparisonRows":2400,"nativeHistoricalRows":92,"storedHistoricalRows":92,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":3851930,"nativeResultTotalVotes":2548140,"nativeComparisonContest":"United States House","nativeHistoricalWarning":"South Carolina historical baselines use official Elections Database county presidential CSV rows for 2016 and 2020. Use them as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":46,"nativeMissingComparisonRows":1,"nativeComparisonPrecinctRows":2491,"nativeDuplicateComparisonRows":45,"nativePresidentialPrecinctRows":2446,"nativeZeroPresidentialPrecinctRows":45},"latestParser":"nativeSouthCarolinaElectionHistoryCsv","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"SD","name":"South Dakota","authority":"South Dakota Secretary of State; U.S. Election Assistance Commission","resultRows":198,"resultJurisdictions":66,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":66,"taggedResultJurisdictions":66,"historical2020Jurisdictions":66,"taggedHistorical2020Jurisdictions":66,"matchedHistorical2020Jurisdictions":66,"missingHistorical2020Jurisdictions":0},"sourceCount":10,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":48,"countyIndicatorCount":48,"flaggedCountyJurisdictions":48,"flaggedAreas":48,"reviewRowCount":66,"turnoutRowCount":66,"historicalRowCount":198,"equipmentRowCount":66,"flaggedJurisdictions":48,"importRunCount":11,"legacyImportCount":5,"latestImportAt":"2026-07-04T22:59:16.013Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":9982,"nativeResultRows":66,"nativeReviewRows":66,"nativeTrumpVotes":272081,"storedResultRows":198,"storedReviewRows":66,"nativeBallotsCast":435739,"nativeHarrisVotes":146859,"nativeTurnoutRows":66,"storedTurnoutRows":66,"nativeReviewWarning":"South Dakota review rows are county-level President-versus-at-large-U.S.-House comparisons from secondary Wikipedia county tables that cite the South Dakota Secretary of State 2024 General Election Canvass and Certificate. Wave 23 retained the official SD SOS ElectionID 684 statewide XLSX export from ResultsExport.aspx?eid=684, but that official app export is labeled unofficial and matches the lower archive map-data totals rather than the current certified-style staging totals. These rows remain caveated staging/source-review coverage and are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":48,"nativeComparisonRows":66,"nativeHistoricalRows":198,"storedHistoricalRows":198,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":690306,"nativeResultTotalVotes":428922,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"South Dakota historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":9982,"nativeResultRows":66,"nativeReviewRows":66,"nativeTrumpVotes":272081,"storedResultRows":198,"storedReviewRows":66,"nativeBallotsCast":435739,"nativeHarrisVotes":146859,"nativeTurnoutRows":66,"storedTurnoutRows":66,"nativeReviewWarning":"South Dakota review rows are county-level President-versus-at-large-U.S.-House comparisons from secondary Wikipedia county tables that cite the South Dakota Secretary of State 2024 General Election Canvass and Certificate. Wave 23 retained the official SD SOS ElectionID 684 statewide XLSX export from ResultsExport.aspx?eid=684, but that official app export is labeled unofficial and matches the lower archive map-data totals rather than the current certified-style staging totals. These rows remain caveated staging/source-review coverage and are not precinct-level vote-share scatter plots.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":48,"nativeComparisonRows":66,"nativeHistoricalRows":198,"storedHistoricalRows":198,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":690306,"nativeResultTotalVotes":428922,"nativeComparisonContest":"United States Representative","nativeHistoricalWarning":"South Dakota historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":0},"latestParser":"nativeCountyPresidentCsv","nativeImportCount":3,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"TN","name":"Tennessee","authority":"Tennessee Secretary of State","resultRows":285,"resultJurisdictions":95,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":95,"taggedResultJurisdictions":95,"historical2020Jurisdictions":95,"taggedHistorical2020Jurisdictions":95,"matchedHistorical2020Jurisdictions":95,"missingHistorical2020Jurisdictions":0},"sourceCount":16,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":149,"countyIndicatorCount":149,"flaggedCountyJurisdictions":86,"flaggedAreas":86,"reviewRowCount":1859,"turnoutRowCount":95,"historicalRowCount":190,"equipmentRowCount":95,"flaggedJurisdictions":86,"importRunCount":11,"legacyImportCount":4,"latestImportAt":"2026-07-11T03:14:32.938Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":40812,"nativeResultRows":95,"nativeReviewRows":1859,"nativeTrumpVotes":1966865,"storedResultRows":285,"storedReviewRows":1859,"nativeBallotsCast":3090161,"nativeHarrisVotes":1056265,"nativeTurnoutRows":95,"storedTurnoutRows":95,"nativeReviewWarning":"Tennessee review rows are precinct-level President-versus-U.S.-Senate comparisons from the official SOS precinct PDF. They are public-interest advisory screening inputs, not findings of fraud or misconduct. Precinct boundary geometry and state-native turnout denominators are not loaded.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":149,"nativeComparisonRows":1859,"nativeHistoricalRows":190,"storedHistoricalRows":190,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":4825601,"nativeResultTotalVotes":3063942,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Tennessee historical baseline rows are official county-level 2016 and 2020 presidential results from Tennessee Secretary of State PDFs. Use them as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":""},"latestNativeImportSummary":{"nativeOtherVotes":40812,"nativeResultRows":95,"nativeReviewRows":1859,"nativeTrumpVotes":1966865,"storedResultRows":285,"storedReviewRows":1859,"nativeBallotsCast":3090161,"nativeHarrisVotes":1056265,"nativeTurnoutRows":95,"storedTurnoutRows":95,"nativeReviewWarning":"Tennessee review rows are precinct-level President-versus-U.S.-Senate comparisons from the official SOS precinct PDF. They are public-interest advisory screening inputs, not findings of fraud or misconduct. Precinct boundary geometry and state-native turnout denominators are not loaded.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":149,"nativeComparisonRows":1859,"nativeHistoricalRows":190,"storedHistoricalRows":190,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":4825601,"nativeResultTotalVotes":3063942,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Tennessee historical baseline rows are official county-level 2016 and 2020 presidential results from Tennessee Secretary of State PDFs. Use them as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":0,"nativeReviewSourceCoverage":""},"latestParser":"nativeCountyPresidentCsv","nativeImportCount":4,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"TX","name":"Texas","authority":"Texas Secretary of State","resultRows":762,"resultJurisdictions":254,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":254,"taggedResultJurisdictions":254,"historical2020Jurisdictions":254,"taggedHistorical2020Jurisdictions":254,"matchedHistorical2020Jurisdictions":254,"missingHistorical2020Jurisdictions":0},"sourceCount":7,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":309,"countyIndicatorCount":309,"flaggedCountyJurisdictions":172,"flaggedAreas":172,"reviewRowCount":9348,"turnoutRowCount":9712,"historicalRowCount":762,"equipmentRowCount":254,"flaggedJurisdictions":172,"importRunCount":14,"legacyImportCount":5,"latestImportAt":"2026-06-30T01:50:09.948Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":159827,"nativeResultRows":254,"nativeReviewRows":9348,"nativeTrumpVotes":6393597,"storedResultRows":762,"storedReviewRows":9348,"nativeBallotsCast":11460798,"nativeHarrisVotes":4835250,"nativeTurnoutRows":9712,"storedTurnoutRows":9712,"nativeReviewWarning":"Texas native review rows use Capitol Data Portal VTD-level 2024 General Election President-versus-U.S. Senate rows. Certified county result rows remain sourced from Texas SOS County.json. The VTD presidential rows aggregate to 11,404,528 votes, 15,854 above the SOS county certified-result package total of 11,388,674. Reconciliation shows the gap is primarily a write-in scope difference: VTD rows include 24,730 generic Write-In votes, while SOS certified county rows include 8,569 named declared write-in candidate votes. Use VTD rows as official local screening context rather than replacement certified totals.","nativeTurnoutParser":"texasVtdZipVrto","storedIndicatorRows":309,"nativeComparisonRows":9346,"nativeHistoricalRows":762,"storedHistoricalRows":762,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":18686517,"nativeResultTotalVotes":11388674,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Texas historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with state-source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeReviewCertifiedVoteGap":-15854,"nativeReviewPresidentialVotes":11404528,"nativeReviewGenericWriteInVotes":24730,"nativeReviewOtherVtdMinusCertified":16164,"nativeReviewTrumpVtdMinusCertified":-194,"nativeReviewVtdMinusCertifiedVotes":15854,"nativeCertifiedDeclaredWriteInVotes":8569,"nativeReviewHarrisVtdMinusCertified":-116,"nativeReviewNamedMinorVtdMinusCertified":3,"nativeReviewGenericWriteInOverCertifiedDeclaredWriteIns":16161},"latestNativeImportSummary":{"nativeOtherVotes":159827,"nativeResultRows":254,"nativeReviewRows":9348,"nativeTrumpVotes":6393597,"storedResultRows":762,"storedReviewRows":9348,"nativeBallotsCast":11460798,"nativeHarrisVotes":4835250,"nativeTurnoutRows":9712,"storedTurnoutRows":9712,"nativeReviewWarning":"Texas native review rows use Capitol Data Portal VTD-level 2024 General Election President-versus-U.S. Senate rows. Certified county result rows remain sourced from Texas SOS County.json. The VTD presidential rows aggregate to 11,404,528 votes, 15,854 above the SOS county certified-result package total of 11,388,674. Reconciliation shows the gap is primarily a write-in scope difference: VTD rows include 24,730 generic Write-In votes, while SOS certified county rows include 8,569 named declared write-in candidate votes. Use VTD rows as official local screening context rather than replacement certified totals.","nativeTurnoutParser":"texasVtdZipVrto","storedIndicatorRows":309,"nativeComparisonRows":9346,"nativeHistoricalRows":762,"storedHistoricalRows":762,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":18686517,"nativeResultTotalVotes":11388674,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Texas historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with state-source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeReviewCertifiedVoteGap":-15854,"nativeReviewPresidentialVotes":11404528,"nativeReviewGenericWriteInVotes":24730,"nativeReviewOtherVtdMinusCertified":16164,"nativeReviewTrumpVtdMinusCertified":-194,"nativeReviewVtdMinusCertifiedVotes":15854,"nativeCertifiedDeclaredWriteInVotes":8569,"nativeReviewHarrisVtdMinusCertified":-116,"nativeReviewNamedMinorVtdMinusCertified":3,"nativeReviewGenericWriteInOverCertifiedDeclaredWriteIns":16161},"latestParser":"nativeTexasCountyJsonVtdReview","nativeImportCount":6,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"UT","name":"Utah","authority":"Utah Lieutenant Governor Elections Office","resultRows":87,"resultJurisdictions":29,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":29,"taggedResultJurisdictions":29,"historical2020Jurisdictions":29,"taggedHistorical2020Jurisdictions":29,"matchedHistorical2020Jurisdictions":29,"missingHistorical2020Jurisdictions":0},"sourceCount":13,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":28,"countyIndicatorCount":28,"flaggedCountyJurisdictions":28,"flaggedAreas":28,"reviewRowCount":29,"turnoutRowCount":29,"historicalRowCount":87,"equipmentRowCount":29,"flaggedJurisdictions":28,"importRunCount":11,"legacyImportCount":5,"latestImportAt":"2026-07-02T05:17:20.371Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":42110,"nativeResultRows":29,"nativeReviewRows":29,"nativeTrumpVotes":883818,"storedResultRows":87,"storedReviewRows":29,"nativeBallotsCast":1529139,"nativeHarrisVotes":562566,"nativeTurnoutRows":29,"storedTurnoutRows":29,"nativeReviewWarning":"Utah review rows are county-level President-versus-Attorney-General comparisons from the official statewide canvass PDF. They support county-level directional screening only; they are not precinct-level scatter plots, and Attorney General is not a federal Senate comparison contest.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":28,"nativeComparisonRows":29,"nativeHistoricalRows":87,"storedHistoricalRows":87,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":1793317,"nativeResultTotalVotes":1488494,"nativeComparisonContest":"Attorney General","nativeHistoricalWarning":"Utah historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data; official Utah historical Excel/PDF artifacts are identified as replacement leads.","nativeTurnoutWarningRows":0},"latestNativeImportSummary":{"nativeOtherVotes":42110,"nativeResultRows":29,"nativeReviewRows":29,"nativeTrumpVotes":883818,"storedResultRows":87,"storedReviewRows":29,"nativeBallotsCast":1529139,"nativeHarrisVotes":562566,"nativeTurnoutRows":29,"storedTurnoutRows":29,"nativeReviewWarning":"Utah review rows are county-level President-versus-Attorney-General comparisons from the official statewide canvass PDF. They support county-level directional screening only; they are not precinct-level scatter plots, and Attorney General is not a federal Senate comparison contest.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":28,"nativeComparisonRows":29,"nativeHistoricalRows":87,"storedHistoricalRows":87,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":1793317,"nativeResultTotalVotes":1488494,"nativeComparisonContest":"Attorney General","nativeHistoricalWarning":"Utah historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data; official Utah historical Excel/PDF artifacts are identified as replacement leads.","nativeTurnoutWarningRows":0},"latestParser":"nativeCountyPresidentCsv","nativeImportCount":3,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"VT","name":"Vermont","authority":"Vermont Secretary of State; U.S. Election Assistance Commission","resultRows":42,"resultJurisdictions":14,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":14,"taggedResultJurisdictions":14,"historical2020Jurisdictions":14,"taggedHistorical2020Jurisdictions":14,"matchedHistorical2020Jurisdictions":14,"missingHistorical2020Jurisdictions":0},"sourceCount":16,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":11,"countyIndicatorCount":11,"flaggedCountyJurisdictions":9,"flaggedAreas":9,"reviewRowCount":283,"turnoutRowCount":247,"historicalRowCount":28,"equipmentRowCount":14,"flaggedJurisdictions":9,"importRunCount":15,"legacyImportCount":6,"latestImportAt":"2026-07-11T03:16:41.094Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":14236,"nativeResultRows":14,"nativeReviewRows":283,"nativeTrumpVotes":119395,"storedResultRows":42,"storedReviewRows":283,"nativeBallotsCast":361604,"nativeHarrisVotes":235791,"nativeTurnoutRows":247,"storedTurnoutRows":247,"nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":11,"nativeComparisonRows":283,"nativeHistoricalRows":28,"storedHistoricalRows":28,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":500986,"nativeResultTotalVotes":369422,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Vermont historical baseline rows are official 2016 and 2020 President results from the Vermont Election Results Archive municipality CSV downloads, aggregated to counties using the official Vermont manifest town/county crosswalk plus explicit abbreviation aliases. Blanks and spoiled ballots are excluded from candidate-vote baselines. Official 2012 county presidential baselines remain uncollected.","nativeComparisonDemVotes":229429,"nativeComparisonRepVotes":116512,"nativeTurnoutWarningRows":247,"nativeComparisonOtherVotes":17312,"nativeCanvassSenateOvervotes":296,"nativeCanvassSenateBlankVotes":9336,"nativeReviewPresidentialVotes":369422,"nativeCanvassPresidentOvervotes":268,"nativeCanvassPresidentBlankVotes":3195,"nativeExcludedStatewideSummaryRows":2,"nativeCanvassSenateTotalVotesCounted":372885,"nativeCanvassPresidentTotalVotesCounted":372885},"latestNativeImportSummary":{"nativeOtherVotes":14236,"nativeResultRows":14,"nativeReviewRows":283,"nativeTrumpVotes":119395,"storedResultRows":42,"storedReviewRows":283,"nativeBallotsCast":361604,"nativeHarrisVotes":235791,"nativeTurnoutRows":247,"storedTurnoutRows":247,"nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":11,"nativeComparisonRows":283,"nativeHistoricalRows":28,"storedHistoricalRows":28,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":500986,"nativeResultTotalVotes":369422,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Vermont historical baseline rows are official 2016 and 2020 President results from the Vermont Election Results Archive municipality CSV downloads, aggregated to counties using the official Vermont manifest town/county crosswalk plus explicit abbreviation aliases. Blanks and spoiled ballots are excluded from candidate-vote baselines. Official 2012 county presidential baselines remain uncollected.","nativeComparisonDemVotes":229429,"nativeComparisonRepVotes":116512,"nativeTurnoutWarningRows":247,"nativeComparisonOtherVotes":17312,"nativeCanvassSenateOvervotes":296,"nativeCanvassSenateBlankVotes":9336,"nativeReviewPresidentialVotes":369422,"nativeCanvassPresidentOvervotes":268,"nativeCanvassPresidentBlankVotes":3195,"nativeExcludedStatewideSummaryRows":2,"nativeCanvassSenateTotalVotesCounted":372885,"nativeCanvassPresidentTotalVotesCounted":372885},"latestParser":"nativeVermontStaticElectionJson","nativeImportCount":6,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"VA","name":"Virginia","authority":"Virginia Department of Elections","resultRows":399,"resultJurisdictions":133,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":133,"taggedResultJurisdictions":133,"historical2020Jurisdictions":133,"taggedHistorical2020Jurisdictions":0,"matchedHistorical2020Jurisdictions":133,"missingHistorical2020Jurisdictions":0},"sourceCount":9,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":147,"countyIndicatorCount":147,"flaggedCountyJurisdictions":89,"flaggedAreas":89,"reviewRowCount":2669,"turnoutRowCount":2669,"historicalRowCount":400,"equipmentRowCount":134,"flaggedJurisdictions":89,"importRunCount":14,"legacyImportCount":5,"latestImportAt":"2026-07-02T19:16:32.628Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":95461,"nativeResultRows":133,"nativeReviewRows":2669,"nativeTrumpVotes":2075085,"storedResultRows":399,"storedReviewRows":2669,"nativeBallotsCast":4537976,"nativeHarrisVotes":2335395,"nativeTurnoutRows":2669,"storedTurnoutRows":2669,"nativeReviewWarning":"Virginia review rows use the official ENR all-results CSV for same-precinct President-versus-U.S. Senate screening. ENR precinct display names can differ from the historical contest CSV names; rows are advisory review inputs, not findings.","storedIndicatorRows":147,"nativeComparisonRows":2669,"nativeHistoricalRows":400,"storedHistoricalRows":400,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":6434637,"nativeResultTotalVotes":4505941,"nativeComparisonContest":"Member, United States Senate","nativeHistoricalWarning":"Virginia historical baseline rows are official Virginia Elections Database locality-level presidential results from 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data. The 2016 locality rows sum 11 votes below the State row in minor/write-in/total scope, while Democratic and Republican locality sums match the State row.","nativeMissingComparisonRows":0,"nativeReviewPresidentialVotes":4505941},"latestNativeImportSummary":{"nativeOtherVotes":95461,"nativeResultRows":133,"nativeReviewRows":2669,"nativeTrumpVotes":2075085,"storedResultRows":399,"storedReviewRows":2669,"nativeBallotsCast":4537976,"nativeHarrisVotes":2335395,"nativeTurnoutRows":2669,"storedTurnoutRows":2669,"nativeReviewWarning":"Virginia review rows use the official ENR all-results CSV for same-precinct President-versus-U.S. Senate screening. ENR precinct display names can differ from the historical contest CSV names; rows are advisory review inputs, not findings.","storedIndicatorRows":147,"nativeComparisonRows":2669,"nativeHistoricalRows":400,"storedHistoricalRows":400,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":6434637,"nativeResultTotalVotes":4505941,"nativeComparisonContest":"Member, United States Senate","nativeHistoricalWarning":"Virginia historical baseline rows are official Virginia Elections Database locality-level presidential results from 2012, 2016, and 2020. Use them as contextual baseline rows, not as 2024 certified data. The 2016 locality rows sum 11 votes below the State row in minor/write-in/total scope, while Democratic and Republican locality sums match the State row.","nativeMissingComparisonRows":0,"nativeReviewPresidentialVotes":4505941},"latestParser":"nativeVirginiaElectionStatsContestCsv","nativeImportCount":6,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"WA","name":"Washington","authority":"Washington Secretary of State","resultRows":117,"resultJurisdictions":39,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":39,"taggedResultJurisdictions":39,"historical2020Jurisdictions":39,"taggedHistorical2020Jurisdictions":39,"matchedHistorical2020Jurisdictions":39,"missingHistorical2020Jurisdictions":0},"sourceCount":12,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":57,"countyIndicatorCount":57,"flaggedCountyJurisdictions":37,"flaggedAreas":37,"reviewRowCount":5007,"turnoutRowCount":39,"historicalRowCount":78,"equipmentRowCount":39,"flaggedJurisdictions":37,"importRunCount":13,"legacyImportCount":5,"latestImportAt":"2026-07-11T03:17:16.975Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":147471,"nativeResultRows":39,"nativeReviewRows":5007,"nativeTrumpVotes":1530923,"storedResultRows":117,"storedReviewRows":5007,"nativeBallotsCast":3949810,"nativeHarrisVotes":2245849,"nativeTurnoutRows":39,"storedTurnoutRows":39,"nativeReviewWarning":"Washington native review rows use the official participating county precinct CSV for presidential vote-share screening and President-versus-U.S. Senate same-party drop-off screening. The precinct export aggregates to 3,918,934 presidential votes, 5,309 fewer than the certified county presidential total of 3,924,243, so review charts must be treated as official participating-precinct screening rather than a fully reconciled statewide precinct dataset.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":57,"nativeComparisonRows":4994,"nativeHistoricalRows":78,"storedHistoricalRows":78,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":5597156,"nativeResultTotalVotes":3924243,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Washington historical baseline rows are official county-level 2016 and 2020 presidential results from Washington Secretary of State all-counties CSV exports. Use them as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":39,"nativeReviewCertifiedVoteGap":5309,"nativeReviewPresidentialVotes":3918934},"latestNativeImportSummary":{"nativeOtherVotes":147471,"nativeResultRows":39,"nativeReviewRows":5007,"nativeTrumpVotes":1530923,"storedResultRows":117,"storedReviewRows":5007,"nativeBallotsCast":3949810,"nativeHarrisVotes":2245849,"nativeTurnoutRows":39,"storedTurnoutRows":39,"nativeReviewWarning":"Washington native review rows use the official participating county precinct CSV for presidential vote-share screening and President-versus-U.S. Senate same-party drop-off screening. The precinct export aggregates to 3,918,934 presidential votes, 5,309 fewer than the certified county presidential total of 3,924,243, so review charts must be treated as official participating-precinct screening rather than a fully reconciled statewide precinct dataset.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":57,"nativeComparisonRows":4994,"nativeHistoricalRows":78,"storedHistoricalRows":78,"nativeHistoricalYears":[2016,2020],"nativeRegisteredVoters":5597156,"nativeResultTotalVotes":3924243,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Washington historical baseline rows are official county-level 2016 and 2020 presidential results from Washington Secretary of State all-counties CSV exports. Use them as contextual jurisdictionTag flip baselines, not as 2024 certified-result rows. Official 2012 county presidential baselines remain uncollected.","nativeTurnoutWarningRows":39,"nativeReviewCertifiedVoteGap":5309,"nativeReviewPresidentialVotes":3918934},"latestParser":"nativeWashingtonCsvExports","nativeImportCount":5,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"WV","name":"West Virginia","authority":"West Virginia Secretary of State","resultRows":165,"resultJurisdictions":55,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":55,"taggedResultJurisdictions":55,"historical2020Jurisdictions":55,"taggedHistorical2020Jurisdictions":55,"matchedHistorical2020Jurisdictions":55,"missingHistorical2020Jurisdictions":0},"sourceCount":12,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":102,"countyIndicatorCount":102,"flaggedCountyJurisdictions":55,"flaggedAreas":55,"reviewRowCount":1648,"turnoutRowCount":1649,"historicalRowCount":165,"equipmentRowCount":55,"flaggedJurisdictions":55,"importRunCount":17,"legacyImportCount":5,"latestImportAt":"2026-07-02T23:12:17.050Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":14525,"nativeResultRows":55,"nativeReviewRows":1648,"nativeTrumpVotes":533556,"storedResultRows":165,"storedReviewRows":1648,"nativeHarrisVotes":214309,"nativeTurnoutRows":1649,"storedTurnoutRows":1649,"nativeReviewWarning":"West Virginia review rows are precinct-level President-versus-U.S. Senate comparisons from official Secretary of State county detail XML report ZIPs. They are advisory review inputs, not confirmed findings.","storedIndicatorRows":102,"nativeComparisonRows":1648,"nativeHistoricalRows":165,"storedHistoricalRows":165,"nativeHistoricalYears":[2012,2016,2020],"nativeResultTotalVotes":762390,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"West Virginia historical baseline rows are county-level presidential context for 2012, 2016, and 2020 from official West Virginia Secretary of State sources. The 2012 and 2016 legacy results app states that write-in candidate information is not included, so use these as contextual baseline rows only, not as write-in-inclusive certified totals.","nativeTurnoutBallotsCast":770587,"nativeTurnoutRegisteredVoters":1187991,"nativeMissingComparisonCounties":[]},"latestNativeImportSummary":{"nativeOtherVotes":14525,"nativeResultRows":55,"nativeReviewRows":1648,"nativeTrumpVotes":533556,"storedResultRows":165,"storedReviewRows":1648,"nativeHarrisVotes":214309,"nativeTurnoutRows":1649,"storedTurnoutRows":1649,"nativeReviewWarning":"West Virginia review rows are precinct-level President-versus-U.S. Senate comparisons from official Secretary of State county detail XML report ZIPs. They are advisory review inputs, not confirmed findings.","storedIndicatorRows":102,"nativeComparisonRows":1648,"nativeHistoricalRows":165,"storedHistoricalRows":165,"nativeHistoricalYears":[2012,2016,2020],"nativeResultTotalVotes":762390,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"West Virginia historical baseline rows are county-level presidential context for 2012, 2016, and 2020 from official West Virginia Secretary of State sources. The 2012 and 2016 legacy results app states that write-in candidate information is not included, so use these as contextual baseline rows only, not as write-in-inclusive certified totals.","nativeTurnoutBallotsCast":770587,"nativeTurnoutRegisteredVoters":1187991,"nativeMissingComparisonCounties":[]},"latestParser":"nativeWestVirginiaClarityCountyDetailXmlDirectory","nativeImportCount":9,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"WI","name":"Wisconsin","authority":"Wisconsin Elections Commission","resultRows":216,"resultJurisdictions":72,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":72,"taggedResultJurisdictions":72,"historical2020Jurisdictions":72,"taggedHistorical2020Jurisdictions":72,"matchedHistorical2020Jurisdictions":72,"missingHistorical2020Jurisdictions":0},"sourceCount":16,"mapGeometrySourceCount":1,"sourcesMissingUrls":0,"indicatorCount":187,"countyIndicatorCount":107,"flaggedCountyJurisdictions":67,"flaggedAreas":126,"reviewRowCount":3503,"turnoutRowCount":1851,"historicalRowCount":216,"equipmentRowCount":72,"flaggedJurisdictions":126,"importRunCount":22,"legacyImportCount":5,"latestImportAt":"2026-07-01T07:44:06.370Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":57063,"nativeResultRows":72,"nativeReviewRows":3503,"nativeTrumpVotes":1697626,"storedResultRows":216,"storedReviewRows":3503,"nativeBallotsCast":3434185,"nativeHarrisVotes":1668229,"nativeTurnoutRows":1851,"storedTurnoutRows":1851,"nativeReviewWarning":"Wisconsin native review rows use ward-level presidential vote-share screening and presidential-versus-U.S. Senate same-party drop-off screening. Turnout rows use EAC 2024 V2 local-jurisdiction fallback data because the WEC ward results workbook does not include registered-voter denominator fields.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":187,"nativeComparisonRows":3503,"nativeHistoricalRows":216,"storedHistoricalRows":216,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":3933068,"nativeResultTotalVotes":3422918,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Wisconsin historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":2},"latestNativeImportSummary":{"nativeOtherVotes":57063,"nativeResultRows":72,"nativeReviewRows":3503,"nativeTrumpVotes":1697626,"storedResultRows":216,"storedReviewRows":3503,"nativeBallotsCast":3434185,"nativeHarrisVotes":1668229,"nativeTurnoutRows":1851,"storedTurnoutRows":1851,"nativeReviewWarning":"Wisconsin native review rows use ward-level presidential vote-share screening and presidential-versus-U.S. Senate same-party drop-off screening. Turnout rows use EAC 2024 V2 local-jurisdiction fallback data because the WEC ward results workbook does not include registered-voter denominator fields.","nativeTurnoutParser":"normalizedTurnoutCsv","storedIndicatorRows":187,"nativeComparisonRows":3503,"nativeHistoricalRows":216,"storedHistoricalRows":216,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":3933068,"nativeResultTotalVotes":3422918,"nativeComparisonContest":"United States Senator","nativeHistoricalWarning":"Wisconsin historical baseline rows are county-level presidential results from 2012, 2016, and 2020 Wikipedia county tables with source footnotes. Use them as contextual baseline rows, not as 2024 certified data.","nativeTurnoutWarningRows":2},"latestParser":"nativeWisconsinWardByWardXlsx","nativeImportCount":13,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]},{"state":"WY","name":"Wyoming","authority":"Wyoming Secretary of State; U.S. Election Assistance Commission; U.S. Census Bureau","resultRows":69,"resultJurisdictions":23,"historicalJoinReady":true,"jurisdictionTagCoverage":{"resultJurisdictions":23,"taggedResultJurisdictions":23,"historical2020Jurisdictions":23,"taggedHistorical2020Jurisdictions":23,"matchedHistorical2020Jurisdictions":23,"missingHistorical2020Jurisdictions":0},"sourceCount":11,"mapGeometrySourceCount":2,"sourcesMissingUrls":0,"indicatorCount":19,"countyIndicatorCount":19,"flaggedCountyJurisdictions":19,"flaggedAreas":19,"reviewRowCount":431,"turnoutRowCount":23,"historicalRowCount":69,"equipmentRowCount":23,"flaggedJurisdictions":19,"importRunCount":13,"legacyImportCount":6,"latestImportAt":"2026-07-03T19:04:19.552Z","latestImportStatus":"promoted","latestImportSummary":{"nativeOtherVotes":6888,"nativeResultRows":23,"nativeReviewRows":431,"nativeTrumpVotes":192633,"storedResultRows":69,"storedReviewRows":431,"nativeBallotsCast":271123,"nativeHarrisVotes":69527,"nativeTurnoutRows":23,"storedTurnoutRows":23,"nativeReviewWarning":"Official Wyoming precinct-by-precinct rows pair President with U.S. Senate for same-row advisory review. County geometry only; precinct boundaries, state-native registration denominator, audit, CVR, recount, incident, correction, and litigation rows are not normalized. Advisory indicators are not evidence of fraud or misconduct.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":19,"nativeComparisonRows":431,"nativeHistoricalRows":69,"storedHistoricalRows":69,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":296960,"nativeResultTotalVotes":269048,"nativeComparisonContest":"U.S. Senate","nativeHistoricalWarning":"Official Wyoming SOS historical baselines are county-level presidential rows. 2012 is aggregated from official county precinct-by-precinct workbooks because the ZIP lacks a statewide candidates summary workbook.","nativeTurnoutWarningRows":0,"nativeReviewCertifiedVoteGap":0,"nativeReviewPresidentialVotes":269048,"nativeZeroPresidentialPrecinctRows":5},"latestNativeImportSummary":{"nativeOtherVotes":6888,"nativeResultRows":23,"nativeReviewRows":431,"nativeTrumpVotes":192633,"storedResultRows":69,"storedReviewRows":431,"nativeBallotsCast":271123,"nativeHarrisVotes":69527,"nativeTurnoutRows":23,"storedTurnoutRows":23,"nativeReviewWarning":"Official Wyoming precinct-by-precinct rows pair President with U.S. Senate for same-row advisory review. County geometry only; precinct boundaries, state-native registration denominator, audit, CVR, recount, incident, correction, and litigation rows are not normalized. Advisory indicators are not evidence of fraud or misconduct.","nativeTurnoutParser":"eacTurnoutCsv","storedIndicatorRows":19,"nativeComparisonRows":431,"nativeHistoricalRows":69,"storedHistoricalRows":69,"nativeHistoricalYears":[2012,2016,2020],"nativeRegisteredVoters":296960,"nativeResultTotalVotes":269048,"nativeComparisonContest":"U.S. Senate","nativeHistoricalWarning":"Official Wyoming SOS historical baselines are county-level presidential rows. 2012 is aggregated from official county precinct-by-precinct workbooks because the ZIP lacks a statewide candidates summary workbook.","nativeTurnoutWarningRows":0,"nativeReviewCertifiedVoteGap":0,"nativeReviewPresidentialVotes":269048,"nativeZeroPresidentialPrecinctRows":5},"latestParser":"nativeWyomingSosGeneralZip","nativeImportCount":4,"sourceTier":"mixed","capabilities":{"sourcePlanner":true,"certifiedResults":true,"map":true,"reviewGraphs":true,"turnout":true,"historicalBaseline":true,"notes":"Native official-source ETL promotion."},"status":"complete","gaps":[]}],"meta":{"generatedAt":"2026-07-26T14:47:27.949Z","source":"database","releaseId":null,"schemaVersion":"1.0.0","completeStates":48,"statesLoaded":51,"year":2024}}