{"data":{"checkedAt":"2026-07-12","description":"Source acquisition tier registry for planning result, review, turnout, and method collection work. This classifies acquisition difficulty and scripting ROI; it does not replace loaded result or review data.","states":[{"state":"AL","stateName":"Alabama","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct_absentee_provisional_columns","exportFormats":["official precinct XLS ZIP","official turnout PDF","official voter registration XLSX","EAC fallback turnout CSV","county GeoJSON"],"sourceUrls":["https://www.sos.alabama.gov/alabama-votes/voter/election-data","https://www.sos.alabama.gov/sites/default/files/election-data/2024-12/2024-General%20Precinct%20Level%20Results.zip","https://www.sos.alabama.gov/sites/default/files/election-data/2025-01/2024GeneralElectionTotalBallotsCast.pdf","https://www.sos.alabama.gov/sites/default/files/election-data/2025-01/ALVR-2024.xlsx","https://www.sos.alabama.gov/public-records-request"],"exampleUrls":["https://www.sos.alabama.gov/sites/default/files/election-data/2024-12/2024-General%20Precinct%20Level%20Results.zip"],"availableFields":["official county presidential rows from the 2024 SOS precinct XLS ZIP","official precinct/reporting-mode President-versus-U.S. House review rows where House coverage is explicit","official 2012/2016/2020 county historical baseline rows","EAC fallback turnout rows plus Alabama SOS turnout/registration denominator leads","county geometry","county equipment context from Verified Voting Verifier","SOS public-records and county-official request paths for administration context"],"missingFields":["state-native turnout rows reconciled with denominator timing","precinct boundary geometry or official precinct-header crosswalk","normalized audit, CVR availability, recount, incident, correction, and litigation rows"],"parserStatus":"native county President rows, precinct/reporting-mode U.S. House review rows, EAC fallback turnout, county geometry, and official historical baseline rows are active through etl/state-configs/al.json; scripts/normalize-al-sos-results.mjs regenerates AL CSVs from official SOS artifacts","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The official 2024 precinct ZIP is loaded through generated CSVs from 67 county XLS files. U.S. House is district-based and no 2024 Alabama U.S. Senate race existed, so review rows are directional source-review signals only. Active turnout remains EAC fallback until SOS Total Ballots Cast PDF and ALVR denominator timing are reconciled; the generated precinct-ZIP ballots-cast lead is 180 lower than active EAC/SOS fallback ballots cast. County geometry is loaded, but precinct geometry/crosswalks and normalized audit/CVR/recount/incident/correction/litigation rows remain missing.","nextAction":"Review state-native turnout replacement semantics, especially the 180-ballot precinct-ZIP versus EAC/SOS fallback ballots-cast difference and ALVR denominator timing; then collect official precinct geometry/crosswalks and administration-context records."},{"state":"CA","stateName":"California","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"county","exportFormats":["XLSX Statement of Vote workbooks","PDF participation and registration tables","GeoJSON county geometry","EAC fallback benchmark CSV"],"sourceUrls":["https://www.sos.ca.gov/elections/prior-elections/statewide-election-results/general-election-nov-5-2024/statement-vote","https://elections.cdn.sos.ca.gov/sov/2024-general/sov/03-voter-participation-stats-by-county.pdf","https://www.sos.ca.gov/elections/prior-elections/statewide-election-results","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2706%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","https://www.sos.ca.gov/elections/election-cybersecurity","https://www.sos.ca.gov/elections/recounts","https://www.sos.ca.gov/administration/public-records-act-requests","https://statewidedatabase.org/election.html"],"exampleUrls":["https://elections.cdn.sos.ca.gov/sov/2024-general/sov/16-president.xlsx","https://elections.cdn.sos.ca.gov/sov/2024-general/sov/19-uss-ft.xlsx","https://statewidedatabase.org/d20/g24.html"],"availableFields":["official county presidential totals","official county U.S. Senate full-term comparison rows","official county voter participation and 15-day registered-voter denominator rows","Census county geometry","official 2012/2016/2020 county presidential historical baseline workbooks","official Statement of Vote voting-systems-by-county PDF lead and Verified Voting county equipment context","official election-security 1% manual audit description","SOS recount and Public Records Act request paths for remaining administration context","SWDB supplemental 2024 precinct/local result, registration, voter, geography, and conversion source lead documented for future reconciliation"],"missingFields":["precinct or city/local reporting-unit President rows","same-grain subcounty comparison contest rows","precinct boundary geometry or official county-local crosswalk","normalized post-election audit selection/outcome rows","normalized CVR availability, incident, correction, recount, litigation, custody, and tabulator-log records"],"parserStatus":"native county package loaded from official California SOS Statement of Vote President and U.S. Senate XLSX workbooks; official SOS county voter-participation PDF normalized by scripts/normalize-ca-turnout.mjs; historical 2012/2016/2020 county baselines normalized from official SOS workbooks","manualReviewBurden":"low","confidence":"loaded","caveats":"Current CA review rows are county-level President-versus-U.S. Senate full-term comparisons, not precinct or city/local scatter plots. Turnout uses SOS voter participation rows; registered voters are 15-day Report of Registration totals and do not include Same Day Voter Registration after the 15-day close. Normalized audit/CVR/incident/correction/recount/litigation rows are not loaded. SWDB is documented as a supplemental future precinct/local source lead only; SOS Statement of Vote remains authoritative for active certified county rows until any SWDB files are collected, masking-reviewed, and reconciled.","nextAction":"Use data/ca-2024-data-coverage-inventory.json and data/ca-2024-swdb-source-review.json as the current CA source-search records; next steps are precinct/local reporting-unit result exports, precinct geometry/crosswalks, and normalized audit/CVR/recount/incident/correction/litigation records from SOS or county sources."},{"state":"DC","stateName":"District of Columbia","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_historical_geometry","tier":"tier_1_official_export_database","reportingGrain":"official_precinct_to_single_county_equivalent","exportFormats":["official certified CSV","normalized county-equivalent CSV","Census GeoJSON"],"sourceUrls":["https://electionresults.dcboe.org/Downloads/Reports/November_8_2016_General_Election_Certified_Results.csv","https://electionresults.dcboe.org/Downloads/Reports/November_3_2020_General_Election_Certified_Results.csv","https://electionresults.dcboe.org/Downloads/Reports/November_5_2024_General_Election_Certified_Results.csv","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2711%27&outFields=GEOID%2CSTATE%2CCOUNTY%2CNAME%2CBASENAME&returnGeometry=true&outSR=4326&f=geojson"],"exampleUrls":["https://electionresults.dcboe.org/Downloads/Reports/November_5_2024_General_Election_Certified_Results.csv"],"availableFields":["official certified 2016, 2020, and 2024 presidential candidate votes","single county-equivalent FIPS 11001","official precinct counts and overvote/undervote reconciliation","Census county-equivalent geometry"],"missingFields":["same-grain comparison contest","reviewed turnout and registration denominator package"],"parserStatus":"scripts/normalize-dc-certified-results.mjs verifies reviewed source hashes and emits one 2024 row plus one historical row for each of 2016 and 2020, all joined to county:11001.","manualReviewBurden":"low","confidence":"loaded","caveats":"D.C. is one county-equivalent. Overvotes and undervotes are reconciled separately and excluded from candidate totals; no sub-county FIPS units are inferred.","nextAction":"Add comparison and turnout context if needed; county FIPS coverage is complete."},{"state":"FL","stateName":"Florida","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_precinct_gis","tier":"tier_1_official_export_database","reportingGrain":"precinct_location","exportFormats":["official county detail tables","official precinct-level ZIP","field definitions PDF","tab-delimited statewide extract","reviewed election-specific precinct geometry packages"],"sourceUrls":["https://dos.fl.gov/elections/data-statistics/elections-data/precinct-level-election-results/","https://results.elections.myflorida.com/DetailRpt.Asp?ELECTIONDATE=11/5/2024&RACE=PRE&PARTY=&DIST=&GRP=&DATAMODE=","https://results.elections.myflorida.com/downloadresults.asp?ElectionDate=11/5/2024&DATAMODE=","https://doi.org/10.7910/DVN/NH5S2I/IAELIN","https://dataverse.harvard.edu/file.xhtml?fileId=4938250&version=24.0","https://int.nyt.com/newsgraphics/elections/map-data/2024/national/FL-precincts-with-results.geojson.gz"],"exampleUrls":[],"availableFields":["certified county presidential rows from official county detail table","precinct/location President versus U.S. Senate review rows from official precinct ZIP","precinct/location registered-voter denominator lead from official precinct ZIP","county turnout from EAC fallback","county geometry","reviewed 2016, 2020, and 2024 precinct geometry and official-result relationships","official 2012/2016/2020 Department of State precinct-ZIP county historical presidential aggregates"],"missingFields":["state-native ballots-cast rows compatible with the precinct ZIP registration denominator","complete election-effective statewide 2012 precinct boundary geometry and result-to-feature crosswalk","separate certified historical county or statewide canvass artifacts for independent reconciliation of the 2012/2016/2020 DOS precinct-ZIP aggregates","normalized audit, recount, CVR availability, incident, correction, litigation, custody, and tabulator-log rows"],"parserStatus":"nativeFloridaDetailHtml keeps certified county map totals from the official county detail table; floridaPrecinctZipPresidentSenate loads 5,618 same-grain President-versus-U.S. Senate precinct/location review rows; scripts/normalize-fl-historical-presidential-baseline.mjs verifies pinned official 2012/2016/2020 DOS precinct ZIPs and aggregates their presidential candidate rows into 201 county historical rows with per-year exact totals; scripts/collect-fl-precinct-geometry.mjs retains official four-year presidential result universes and reviewed 2016/2020/2024 geometry relationships published at production revision 25 while keeping 2012 blocked; EAC fallback turnout remains active","manualReviewBurden":"low","confidence":"loaded_with_caveat","caveats":"The official precinct ZIP is valid for same-grain review rows and registration-denominator leads, but not for replacing certified county map totals: its presidential candidate total is 204 votes below the official county detail table and its Trump total is one vote higher. The retained 2012/2016/2020 DOS ZIPs provide official-source-derived historical county aggregates, but no separate certified historical county or statewide canvass artifact is retained for independent reconciliation; historical rows remain context and do not activate historical geometry. ZIP registration is an election-date field only; it lacks compatible election-level ballots-cast semantics, so turnout remains EAC fallback. The 2016 and 2020 presentation geometry is attributed VEST data under retained CC BY 4.0 evidence; the 2024 presentation geometry is attributed New York Times data under retained C-UDA non-commercial terms. Every displayed vote value comes only from official Florida exports, and excluded units are never allocated.","nextAction":"Maintain the reviewed public delivery and hash-pinned release evidence for 2016, 2020, and 2024; continue public archive discovery or a records request for election-effective 2012 geometry; collect compatible state-native turnout and normalized administration-context records."},{"state":"HI","stateName":"Hawaii","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct_split","exportFormats":["official certified text export","official certified PDF reports","EAC fallback turnout CSV","GeoJSON county geometry","official 2012/2016/2020 certified historical text exports"],"sourceUrls":["https://elections.hawaii.gov/election-results/","https://files.hawaii.gov/elections/files/results/2024/General/summary.txt","https://files.hawaii.gov/elections/files/results/2024/General/media.txt","https://elections.hawaii.gov/resources/registration-voter-turnout-statistics/","https://elections.hawaii.gov/resources/maps/geographic-information-systems-gis-files/","https://files.hawaii.gov/elections/files/results/2012/general/summary.txt","https://files.hawaii.gov/elections/files/results/2012/general/media.txt","https://files.hawaii.gov/elections/files/results/2016/general/summary.txt","https://files.hawaii.gov/elections/files/results/2016/general/media.txt","https://files.hawaii.gov/elections/files/results/2020/general/summary.txt","https://files.hawaii.gov/elections/files/results/2020/general/media.txt","https://files.hawaii.gov/elections/files/maps/Election2024Maps/HD_13.pdf","https://files.hawaii.gov/elections/files/maps/precincttext/Precinct-Boundary-Descriptions-Statewide.pdf"],"exampleUrls":["https://files.hawaii.gov/elections/files/results/2024/General/summary.txt","https://files.hawaii.gov/elections/files/results/2024/General/media.txt"],"availableFields":["official statewide certified President totals from summary.txt","official county presidential rows aggregated from numbered precinct/split rows","official precinct/split President rows","official same-grain U.S. Senate comparison rows","official Hawaii Office county registration and turnout rows","county geometry","equipment context from Verified Voting","official 2024 recount/provisional/security/source-request paths documented in coverage inventory","official county presidential rows aggregated from the Office of Elections precinct/split text export","official precinct/split President rows for 467 nonzero numbered precinct/split units","official precinct/split U.S. Senate comparison rows for all 467 nonzero President review units","official precinct/split registered-voter and ballots fields in precinct detail text retained as turnout lead context","state-native turnout and registration table lead","supplemental county equipment context","official 2012, 2016, and 2020 county presidential historical baseline rows with county:<GEOID> tags","2012 precinct/split registration, ballots, and vote-method fields retained as timing-caveated source context","Kalawao County FIPS 15005 result rows for 2012, 2016, 2020, and 2024 from exact precinct 13-09"],"missingFields":["precinct boundary geometry or official precinct_splitId crosswalk","normalized official audit, recount, CVR availability, incident, correction, and litigation rows","official 2024 precinct boundary geometry or precinct_splitId crosswalk","normalized audit, recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"nativeHawaiiOfficeText emits five 2024 county/county-equivalent President rows, 467 review rows, and four state-native turnout rows; the historical normalizer emits five rows each for 2012, 2016, and 2020. Exact Kalawao and Maui residual tuples, statewide totals, and the 2012 476-vote overseas exclusion fail closed.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Official map and boundary evidence identify precinct 13-09 as Kalawao County FIPS 15005. The Hawaii Office turnout table still has only four election-county rows, so no Kalawao turnout denominator is invented. Full precinct geometry remains unloaded.","nextAction":"Collect election-effective precinct geometry/crosswalks if subcounty overlays are pursued, and normalized audit/CVR/recount/incident/correction/litigation records."},{"state":"IL","stateName":"Illinois","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical","tier":"tier_1_official_export_database","reportingGrain":"county_results_and_historical_with_precinct_review","exportFormats":["official by-office CSV downloads","EAC fallback turnout","official by-office turnout-field review JSON","official 2020 by-office President CSV","normalized historical baseline CSV","official Candidate Totals by County XLS workbooks","normalized historical county CSV"],"sourceUrls":["https://www.elections.il.gov/ElectionOperations/ElectionVoteTotals.aspx?ID=66","https://www.elections.il.gov/ElectionOperations/ElectionVoteTotals.aspx?ID=58","https://www.eac.gov/research-and-data/studies-and-reports","https://www.elections.il.gov/ElectionOperations/DownloadVoteTotals.aspx","https://www.elections.il.gov/Downloads/ElectionOperations/VoteTotals/GE2016Cty.xls","https://www.elections.il.gov/Downloads/ElectionOperations/VoteTotals/GE2020Cty.xls"],"exampleUrls":[],"availableFields":["precinct presidential results","precinct U.S. House results","by-office Registration field reviewed as denominator lead only","President contest over-vote, under-vote, and blank-ballot rows reviewed as contest-total lead only","EAC fallback turnout","official 2020 county-named election-authority presidential historical baseline rows","jurisdiction registration by precinct","102 county presidential result rows aggregated from official 2024 election-jurisdiction exports","official 2016 and 2020 Candidate Totals by County workbooks normalized to 102 canonical county tags per year"],"missingFields":["state-native turnout or voter-participation artifact with confirmed ballots-cast field and denominator timing","valid precinct registration denominator for all election authorities","statewide Senate/Governor same-grain comparison contest for 2024","state-native turnout denominator artifact promoted separately","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"illinoisElectionResultsByOfficeCsvDirectory rolls six separate city election authorities into 102 county result rows and loads precinct President-versus-U.S.-House review rows; scripts/report-il-turnout-source-review.mjs retains EAC turnout after rejecting the by-office fields as a valid replacement; scripts/collect-il-historical-presidential-baseline.mjs loads 204 official 2016/2020 county rows; scripts/reconcile-il-historical-promotion.mjs pins the live-to-staged correction.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Illinois 2024 has no statewide U.S. Senate or Governor contest in the by-office package. Review rows compare President to U.S. House only where the jurisdiction/precinct key is unambiguous and the House row has both Democratic and Republican candidate votes; split/multi-district precinct keys and uncontested House rows are omitted. Historical workbooks contain candidate and write-in votes but not blank, undervote, or overvote records.","nextAction":"After promotion, confirm 102 county result rows, 204 historical rows, and 90 stored indicators; pursue a valid state-native turnout denominator and official 2012 county baseline."},{"state":"KS","stateName":"Kansas","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_inventory","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["XLSX","PDF","GeoJSON","EAC fallback CSV","equipment context CSV"],"sourceUrls":["https://sos.ks.gov/elections/elections-statistics.html","https://sos.ks.gov/elections/24elec/2024-Presidential-Results.xlsx","https://sos.ks.gov/elections/24elec/2024-General-Election-United-States-House-of-Representatives-Precinct-Results.xlsx","https://sos.ks.gov/elections/24elec/2024-General-Election-Official-Vote-Totals.pdf","https://www.eac.gov/research-and-data/studies-and-reports","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/20"],"exampleUrls":["https://sos.ks.gov/elections/24elec/2024-Presidential-Results.xlsx","https://sos.ks.gov/elections/24elec/2024-General-Election-United-States-House-of-Representatives-Precinct-Results.xlsx"],"availableFields":["official county presidential totals from SOS presidential workbook","official precinct presidential rows from SOS presidential workbook","official precinct U.S. House comparison rows from SOS workbook","official certified vote-total PDF provenance","EAC fallback county turnout and registered-voter denominator rows","Census county geometry","county equipment context from Verified Voting Verifier","official 2020 county historical presidential baselines","mixed official/secondary 2012 and 2016 county historical presidential baselines with caveats"],"missingFields":["state-native turnout denominator and ballots-cast rows","precinct boundary geometry or precinct crosswalk","official 2012, 2016, and 2020 historical presidential baseline rows","normalized post-election audit selection/outcome rows","official CVR availability or request-produced CVR records","official incident, correction, recount, and litigation records"],"parserStatus":"nativeKansasPresidentialHouseXlsx package loaded from official Kansas SOS presidential and U.S. House workbooks; historicalPresidentialCsv loaded from official 2020 SOS workbook rows, mostly official 2016 rows, and secondary contextual 2012/missing-2016 county rows; EAC fallback turnout and Census county geometry loaded; data/ks-2024-data-coverage-inventory.json documents remaining official-source gaps","manualReviewBurden":"low","confidence":"loaded","caveats":"U.S. House is district-based, so precinct review rows are advisory screening context. Three nonzero presidential local rows lack matching House comparison rows and are kept as vote-share-only rows. Turnout remains EAC fallback until Kansas-native turnout/registration rows are collected and reconciled. County geometry is loaded; precinct geometry and normalized audit/CVR/incident/recount/litigation rows are not loaded. Historical baselines are contextual: 2020 is official, 2016 uses four secondary county rows for counties absent from the SOS workbook, and 2012 secondary county rows do not reconcile to the SOS statewide certified total.","nextAction":"Use data/ks-2024-data-coverage-inventory.json as the current KS source-search record; next steps are Kansas-native turnout denominators, precinct geometry/crosswalks, official replacement for 2012 county historical baselines if obtainable, and official audit/CVR/incident/correction/recount/litigation records."},{"state":"MA","stateName":"Massachusetts","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"city_town_ward_precinct","exportFormats":["official PD43+ CSV download","official PD43+ county-filtered HTML totals","official PD43+ historical county HTML tables","official statewide turnout statistics page","EAC fallback turnout"],"sourceUrls":["https://electionstats.state.ma.us/elections/download/165300/precincts_include:1/","https://electionstats.state.ma.us/elections/view/165300/","https://electionstats.state.ma.us/elections/download/165304/precincts_include:1/","https://electionstats.state.ma.us/elections/view/112698/","https://electionstats.state.ma.us/elections/view/130243/","https://electionstats.state.ma.us/elections/view/140751/","https://www.sec.state.ma.us/divisions/elections/research-and-statistics/voter-turnout-statistics.htm","https://www.sec.state.ma.us/divisions/elections/recent-updates/2024-post-election-audits.htm","https://www.eac.gov/research-and-data/studies-and-reports","https://www.sec.state.ma.us/divisions/elections/research-and-statistics/registration-statistics.htm"],"exampleUrls":["https://electionstats.state.ma.us/elections/view/165300/","https://electionstats.state.ma.us/elections/view/165304/"],"availableFields":["official county President rows","municipality President rows","ward/precinct President rows","ward/precinct U.S. Senate comparison rows","EAC jurisdiction turnout fallback with official statewide turnout cross-check","official 2012/2016/2020 PD43+ county historical presidential baselines","county geometry","county equipment context","official post-election audit source page and request paths","official Massachusetts registration statistics page verified as a statewide/local enrollment source lead"],"missingFields":["state-native local turnout denominator rows","precinct/ward/municipal geometry or reporting-unit crosswalk","normalized detailed audit workpapers and discrepancy rows","normalized CVR availability, ballot-image availability, tabulator-log, logic-and-accuracy, custody, incident, correction, recount, and litigation records"],"parserStatus":"massachusettsPd43PrecinctCsv loaded for county certified results and city/town/ward/precinct President-vs-U.S. Senate review rows; historicalPresidentialCsv now generated from official PD43+ 2012/2016/2020 county pages; data/ma-2024-data-coverage-inventory.json documents turnout, geometry, audit, CVR, and incident gaps","manualReviewBurden":"low","confidence":"loaded","caveats":"PD43+ bulk CSV rows are municipality-centric and do not include county, so county certified result rows are collected from official PD43+ county-filtered County Totals pages. Turnout remains EAC jurisdiction fallback, with only a statewide Massachusetts turnout-statistics cross-check. Historical rows are contextual county baselines; the 2020 PD43+ county rows sum one non-D/R vote above the statewide summary line. Administration inventory records request paths only and does not load CVR, ballot-image, tabulator-log, L&A, custody, incident, correction, recount, or litigation rows.","nextAction":"Collect a Massachusetts state-native local turnout denominator export, official precinct/ward/municipal geometry or reporting-unit crosswalk, and detailed audit/CVR/log/L&A/custody/incident/recount/litigation artifacts or request responses."},{"state":"MD","stateName":"Maryland","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["official statewide all-precinct CSV","official precinct reference XLSX","EAC fallback turnout","official 2020 county result CSVs","official 2016 county result HTML","official 2020 all-by-precinct CSV","historicalPresidentialCsv"],"sourceUrls":["https://elections.maryland.gov/elections/archive/2024/election_data/PG24_AllPrecincts.csv","https://elections.maryland.gov/elections/archive/2024/Polling%20Places%20AEMS%20PG24.xlsx","https://www.eac.gov/research-and-data/studies-and-reports","https://elections.maryland.gov/elections/archive/2020/election_data/index.html","https://elections.maryland.gov/elections/archive/2020/election_data/All_State_2020_General.csv","https://elections.maryland.gov/elections/archive/2016/results/general/gen_detail_results_2016_4_BOT001-.html","https://elections.maryland.gov/elections/archive/2020/election_data/All_By_Precinct_2020_General.csv","https://elections.maryland.gov/elections/archive/2020/results/general/gen_results_2020_4_001-.html"],"exampleUrls":["https://elections.maryland.gov/elections/archive/2024/election_data/index.html"],"availableFields":["county presidential totals aggregated from precinct rows","precinct President candidate rows","same-grain U.S. Senate comparison rows","early vote totals","election night vote totals","mail-in ballot round 1 totals","provisional totals","mail-in ballot round 2 totals","EAC fallback turnout","official 2020 county/county-equivalent presidential historical baseline rows","official 2016 county/county-equivalent presidential historical baselines","official 2020 county/county-equivalent presidential historical baselines"],"missingFields":["state-native precinct registered-voter denominator","precinct boundary geometry","audit/CVR/incident artifacts","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"marylandPrecinctCsv parser loaded in etl/state-configs/md.json; scripts/normalize-md-historical-presidential-baseline.mjs now loads official 2016 and 2020 county/county-equivalent historicalPresidentialCsv rows","manualReviewBurden":"low","confidence":"loaded","caveats":"Official SBE precinct candidate rows support President-versus-U.S.-Senate directional screening. Turnout still uses EAC jurisdiction fallback until a Maryland-native registered-voter denominator is collected. Official 2016 and 2020 historical county/county-equivalent baselines are loaded; 2012 remains uncollected.","nextAction":"Collect Maryland state-native registered-voter/ballots-cast denominator rows, official 2012 county/county-equivalent presidential baseline rows, and any post-election audit/CVR/incident artifacts."},{"state":"ME","stateName":"Maine","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"local_reporting_unit_county","exportFormats":["official Excel workbooks","official RCV/CVR Excel exports","EAC fallback turnout CSV","registered/enrolled voter text files","county GeoJSON","official Maine GeoLibrary local boundary archive","reviewed election-specific secondary geometry"],"sourceUrls":["https://www.maine.gov/sos/elections-voting/election-results-data/election-results-2024","https://www.maine.gov/sos/elections-voting/voter-data/previous-enrollment-data","https://www.maine.gov/sos/elections-voting/election-results-data/previous-election-results","https://www.eac.gov/research-and-data/studies-and-reports","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/23","https://www.maine.gov/sos/elections-voting/voter-data/statewide-registered-and-enrolled-voter","https://www.maine.gov/geolib/","https://github.com/mggg-states/ME-shapefiles","https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/NH5S2I","https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/K7760H","https://github.com/nytimes/presidential-precinct-map-2024"],"exampleUrls":["https://www.maine.gov/sos/sites/maine.gov.sos/files/inline-files/President%20and%20Vice%20President%20FINAL-Corrected%2020241205.xlsx","https://www.maine.gov/sos/sites/maine.gov.sos/files/inline-files/US%20Senator%20FINAL-Corrected%2020241205.xlsx","https://www.maine.gov/sos/sites/maine.gov.sos/files/content/assets/2012presmuni.xls"],"availableFields":["official county/town presidential Excel rows loaded","official county/town U.S. Senate comparison Excel rows loaded","official presidential congressional-district Excel artifact retained for split-electoral-vote context","official EAC fallback turnout rows loaded","official Maine SOS active/inactive registered-enrolled denominator leads normalized with statewide EAC reconciliation","county geometry","county equipment context","official 2016 and 2020 county historical baselines loaded","official Maine SOS local presidential rows parsed for 2012, 2016, 2020, and 2024","fail-closed local-reporting-unit geometry/crosswalk candidates for all four years","exact statewide local-result reconciliation for 2016, 2020, and 2024"],"missingFields":["state-native ballots-cast or voter-participation rows paired with registration denominators","immutable public delivery and production activation for reviewed local-reporting-unit packages","uniquely attributable 2012 geometry for five rows totaling eight presidential votes","explicit derivative redistribution permission for the MGGG 2012 candidate or an official replacement with confirmed election-date applicability","native historical-baseline integration for the parsed 2012 legacy XLS rows","normalized audit, recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"nativeMaineSosCountyTownXlsx loads official 2024 county/town and comparison rows plus 2016/2020 county baselines. scripts/normalize-me-2024-enrollment-leads.mjs deterministically normalizes the official active/inactive enrollment text files and records a statewide EAC denominator comparison without changing active turnout. scripts/collect-me-local-reporting-geometry.mjs separately parses the official statewide local result workbooks for all four years, builds reviewed one-to-one local geometry/crosswalk candidates, strips secondary vote attributes, and keeps every package blocked until delivery review.","manualReviewBurden":"low","confidence":"loaded_with_caveat","caveats":"Maine's statewide presidential workbooks mix towns, plantations, townships, voting districts, and combined units, so the geometry is labeled local reporting unit rather than precinct. No town total is copied to multiple ward polygons. The enrollment normalizer preserves SOS source labels for CG/SS/SR/CC without inferring their meanings; the 1,223,192 active-plus-inactive enrollment total is 276 below EAC registered voters and has no ballots-cast field, so turnout remains EAC fallback. The 2012 candidate is partial: five rows totaling eight votes remain excluded, the MGGG reconstruction is secondary, its exact official November 2012 boundary edition is unconfirmed, and no explicit derivative redistribution permission was located. State UOCAVA remains non-geographic.","nextAction":"Build and review immutable delivery/production tooling for the complete 2016, 2020, and 2024 local-reporting-unit candidates. Keep 2012 blocked while seeking the five missing boundaries plus an official election-date replacement or explicit MGGG derivative permission; also collect compatible Maine-native turnout and normalized administration records."},{"state":"MI","stateName":"Michigan","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["TXT","ZIP","ArcGIS GeoJSON","JSON source evidence and crosswalk","PDF registration reference","secondary historical CSV","admin source inventory JSON"],"sourceUrls":["https://mvic.sos.state.mi.us/VoteHistory/","https://gisagocss.state.mi.us/arcgis/rest/services/OpenData/boundaries/MapServer"],"exampleUrls":[],"availableFields":["county results","precinct President rows","precinct U.S. Senate rows","county registration/turnout","2012, 2016, and 2020 county historical presidential baseline rows","official 2012, 2016, 2020, and 2024 precinct result ZIPs","official election-cycle precinct geometry for all four years","reviewed complete 2024 result-to-geometry relationships with non-geographic and source-alias identities retained","equipment context","administration source inventory"],"missingFields":["immutable public delivery and guarded production activation for the reviewed 2024 precinct package","authoritative resolution of the remaining 2016 and 2020 result-to-geometry gaps","immutable 2012 election-date geometry custody and affirmative derivative redistribution terms","native historical-baseline replacement using the now-retained official 2012/2016/2020 precinct exports","normalized audit/recount/CVR/incident/correction records"],"parserStatus":"native precinct review package loaded with secondary historical baseline and administration source inventory; scripts/build-mi-reviewed-precincts.mjs separately parses and hash-pins all four official precinct result ZIPs, official election-cycle geometry, explicit non-geographic units, and reviewed result-to-geometry evidence","manualReviewBurden":"low","confidence":"loaded_with_caveat","caveats":"Turnout is county-level, not precinct-level. The ordinary native historical baseline still uses secondary contextual county tables, although official 2012/2016/2020 precinct ZIPs are now retained in the separate GIS package. The 2024 geometry/result relationship is complete and allocation-free but awaits guarded delivery; 2012, 2016, and 2020 remain fail-closed for their documented vintage, terms, or unresolved-identity gaps. Administration inventory documents source paths and request needs but does not load row-level audit, recount, CVR, incident, or correction records.","nextAction":"Implement and review the guarded 2024 local-database, immutable delivery, and public-activation path. Keep 2012, 2016, and 2020 outside the public registry while resolving their exact documented blockers; separately replace the native secondary county history from retained official results and collect row-level administration records if available."},{"state":"MN","stateName":"Minnesota","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["XLSX","official statewide shapefile ZIP"],"sourceUrls":["https://www.sos.mn.gov/elections-voting/election-results","https://www.sos.mn.gov/media/yt3llxwd/2024-general-federal-state-results-by-precinct-official.xlsx","https://sos.mn.gov/media/1450/2012mngeneralelectionresults_official_postrecounts.xlsx","https://gis.lcc.mn.gov/html/download.html","https://gis.lcc.mn.gov/data/shape/vtd2024general.zip"],"exampleUrls":["https://www.sos.mn.gov/media/yt3llxwd/2024-general-federal-state-results-by-precinct-official.xlsx","https://gis.lcc.mn.gov/data/shape/vtd2024general.zip"],"availableFields":["county presidential rows aggregated from the official precinct workbook","4,103 VTDID-keyed precinct presidential ResultRows in local staging","precinct President rows","precinct U.S. Senate rows","precinct TOTVOTING turnout rows","precinct REG7AM plus EDR registration denominator fields","official 2012 precinct 7AM plus EDR registration denominators and TOTVOTING ballots for 4,102 VTDIDs","official certified precinct presidential result identities for 2012, 2016, 2020, and 2024 with 4,102, 4,120, 4,110, and 4,103 units","official election-applicable statewide precinct geometry for all four tracked elections with 16,435 exact reviewed VTDID relationships across 87 counties per year","deterministic presentation-only delivery candidates with source terms and no election-value properties for all four tracked elections","content-addressed release overlay with Git-base patches and Minnesota-only shared-registry projections","deterministic shared-diff review tooling that hash-checks 23 modified/shared surfaces and explicitly separates Minnesota requirements from unrelated workspace work","separately guarded atomic migration-plus-hidden-load transaction and release-specific read-only production preflight tooling","receipt-bound canonical-manifest and database publication-status activation tooling with protected-preview, two-person, idempotency, and rollback guards"],"missingFields":["current production backup/preflight evidence, exact hidden-load and immutable-Blob receipts, a verified protected preview, named independent deployment and rollback roles, and explicitly authorized coordinated public activation"],"parserStatus":"the 2024 native parser retains 87 county aggregates and emits 4,103 independently reviewed VTDID-keyed precinct ResultRows, 4,075 review rows, and 4,103 turnout rows; the guarded four-election planner additionally normalizes certified 2012/2016/2020/2024 precinct result identities and exact reviewed LCC-GIS geometry/crosswalks for 16,435 local units; scripts/build-mn-2012-turnout-staging.mjs separately hash-pins the 2012 official workbook and emits 4,102 turnout-only rows","manualReviewBurden":"low","confidence":"loaded","caveats":"The 2024 turnout denominator is REG7AM plus EDR; the 2012 workbook instead uses 7AM plus EDR. Twenty official 2012 precinct rows report TOTVOTING above that combined denominator and remain warning-required. All four geometry/result packages reconcile by exact VTDID, including 33/31/33/28 geographic zero-vote precincts. The 2016 and 2020 LCC election attributes are preliminary and excluded; certified SOS workbooks are the sole vote authority. The LCC-GIS redistribution disclaimer must accompany every delivered copy. The merged release tooling remains fail-closed without current hash-pinned preflight and restoration-verified backup evidence, named independent roles, an active deployment window, exact hidden-load and Blob receipts, a verified protected preview, and exact authorization acknowledgements. Canonical manifests and public delivery remain blocked until that coordinated release completes.","nextAction":"Seal a fresh merged-main candidate, create current production backup/preflight evidence, complete the authorized hidden load and immutable Blob publication, then use the receipt-bound activation candidate and protected-preview publication-status workflow for cutover."},{"state":"MS","stateName":"Mississippi","jurisdictionName":"Statewide county recap CSV","scope":"statewide","dataFamily":"results_review","tier":"tier_1_official_export_database","reportingGrain":"county","exportFormats":["CSV","PDF reference"],"sourceUrls":["https://www.sos.ms.gov/elections/electionresults/2024ElectionRecapSheets.csv"],"exampleUrls":["https://www.sos.ms.gov/elections-voting/election-results/2024/2024-general-election-results","https://www.sos.ms.gov/elections-voting/election-results/2020/2020-general-election","https://www.sos.ms.gov/elections-voting/election-results/2016/2016-general-election","https://www.sos.ms.gov/elections-voting/election-results/2012/2012-election-results","https://www.sos.ms.gov/elections-voting/active-voter-count-reports"],"availableFields":["county President rows","county U.S. Senate rows","November 2024 active-voter denominator lead with generated EAC fallback comparison summary","official 2012/2016/2020 county historical presidential baseline rows"],"missingFields":["precinct rows","state-native ballots-cast turnout rows to pair with the collected November 2024 active-voter denominator lead"],"parserStatus":"mississippiElectionRecapCsv loaded for county review; scripts/collect-ms-active-voter-count.mjs normalizes the official November 2024 Active Voter Count denominator lead and writes data/ms-2024-turnout-denominator-lead-summary.json; scripts/collect-ms-historical-baseline.mjs loads official SOS 2012/2016/2020 county presidential baselines; data/ms-2024-source-request-matrix.tsv tracks OCR, turnout, geometry, and administration-context follow-up asks","manualReviewBurden":"low","confidence":"loaded","caveats":"County-level review is useful but not a precinct-level scatter plot. The collected SOS Active Voter Count PDF and generated summary are denominator-lead context only and do not replace ballots-cast turnout rows by themselves.","nextAction":"Keep loaded county and historical packages; use data/ms-2024-source-request-matrix.tsv to pair the collected November 2024 active-voter denominator lead with official Mississippi ballots-cast/voter-participation rows before replacing EAC turnout, and continue OCR/manual review before any precinct promotion."},{"state":"MT","stateName":"Montana","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["XLSX","historical precinct XLSX","normalized historical baseline CSV","write-in canvass PDF context"],"sourceUrls":["https://sosmt.gov/elections/results/","https://electionresults.mt.gov/ResultsList.aspx?eid=450002785","https://sosmt.gov/docs/32/results/66992/2024_general_precinct_by_precinct","https://sosmt.gov/docs/31/post-election/66775/2024-general-election-report-state-canvass","https://sosmt.gov/elections/systems/","https://sosmt.gov/wp-content/uploads/2020_General_Precinct-by-Precinct.xlsx","https://sosmt.gov/wp-content/uploads/State_Canvass_Report.pdf","https://sosmt.gov/Portals/142/Elections/archives/2010s/2016/2016-General-Results-by-Precinct.xlsx","https://sosmt.gov/wp-content/uploads/attachments/2016GeneralStateCanvassWriteIn.pdf","https://sosmt.gov/wp-content/uploads/State_Canvass_Writein_by_County.pdf"],"exampleUrls":["https://sosmt.gov/docs/32/results/66992/2024_general_precinct_by_precinct","https://sosmt.gov/docs/31/post-election/66775/2024-general-election-report-state-canvass","https://sosmt.gov/wp-content/uploads/2020_General_Precinct-by-Precinct.xlsx"],"availableFields":["precinct President rows","precinct U.S. Senate rows","official statewide canvass context","EAC fallback county/jurisdiction turnout rows","county geometry","Verified Voting county equipment context","official 2020 county presidential historical baseline rows with county:<GEOID> tags","official 2016 county presidential historical baseline rows","official 2020 county presidential historical baseline rows","official 2016 and 2020 write-in canvass context"],"missingFields":["state-native turnout denominator","precinct boundary geometry","normalized post-election audit/recount/CVR availability artifacts","normalized incident/correction/litigation records","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"montanaPrecinctResultsXlsx loaded for official precinct President-versus-U.S. Senate review rows; historical 2016 and 2020 county baselines normalized from official SOS precinct workbooks with write-in caveat; EAC fallback turnout is warning-marked; 2012 historical and admin-context artifacts remain inventory/documentation gaps","manualReviewBurden":"low","confidence":"loaded","caveats":"Official workbook rows omit separate write-in canvass votes: 27 in 2024, and historical write-in canvass totals are retained as context rather than allocated into county other_votes. County maps use Census county geometry only. Turnout currently uses warning-marked EAC fallback rows until a Montana state-native denominator artifact is collected.","nextAction":"Collect or normalize Montana state-native turnout denominators, precinct boundary geometry, official 2012 county historical baseline, and post-election audit/recount/CVR/incident/correction context."},{"state":"NC","stateName":"North Carolina","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin_context","tier":"tier_1_official_export_database","reportingGrain":"county_certified_precinct_review_historical_vtd_and_precinct_geometry","exportFormats":["ZIP","CSV"],"sourceUrls":["https://www.ncsbe.gov/results-data/election-results/historical-election-results-data","https://www.ncsbe.gov/results-data/voter-turnout/2024-general-election-turnout","https://www.ncsbe.gov/results-data/voter-registration-data","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2024_11_05/history_stats_20241105.zip","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2024_11_05/voter_stats_20241105.zip","https://www.ncsbe.gov/results-data/voter-history-data","https://www.ncsbe.gov/results-data/voting-maps-redistricting","https://www.ncsbe.gov/about-elections/election-security/post-election-procedures-and-audits","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2012_11_06/results_sort_20121106.zip","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2016_11_08/results_pct_20161108.zip","https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2020_11_03/results_pct_20201103.zip","https://s3.amazonaws.com/dl.ncsbe.gov/ShapeFiles/Precinct/SBE_PRECINCTS_20161004.zip","https://s3.amazonaws.com/dl.ncsbe.gov/ShapeFiles/Precinct/SBE_PRECINCTS_20201018.zip","https://s3.amazonaws.com/dl.ncsbe.gov/ShapeFiles/Precinct/SBE_PRECINCTS_20240723.zip","https://github.com/mggg-states/NC-shapefiles"],"exampleUrls":[],"availableFields":["certified county President rows from all reporting units","Real Precinct=Y President review rows","Real Precinct=Y Governor comparison rows","EAC fallback county turnout","official 2012/2016/2020 county historical presidential baselines","official precinct shapefile folder lead","official 2024 post-election audit PDF lead","official NCSBE 2024 voter_stats registered-voter denominator lead","official NCSBE 2024 history_stats voter-history turnout lead","generated county turnout-denominator lead and source-review summary with pinned raw/archive hashes and replay check","official 2016 county President-versus-U.S.-Senate historical advisory rows aggregated from all 3,209 source reporting-unit keys across 100 canonical county tags","official 2020 same-grain President-versus-U.S.-Senate historical advisory rows for 2,662 Real Precinct=Y county/precinct keys across 100 county tags","reviewed 2012 VTD geometry and exact official precinct-sorted presidential crosswalk for 2,692 geographic units","reviewed 2016 official precinct geometry and exact crosswalk for 2,704 geographic units","reviewed 2020 official precinct geometry with four independently documented official-source supplements and exact crosswalk for 2,662 Real Precinct=Y units","complete 2024 candidate geometry and exact crosswalk for 2,658 Real Precinct=Y units plus one explicit no-data feature"],"missingFields":["state-native turnout replacement semantics for history_stats voters versus ballots cast","November 5, 2024 boundary-vintage confirmation for Henderson CV and Wake 01-07A / 07-07A restored from the official August 2019 snapshot","guarded database and immutable delivery release for the reviewed 2012, 2016, and 2020 local geometry packages","normalized audit/recount/CVR/incident/correction records"],"parserStatus":"native county certified package loaded; scripts/build-nc-reviewed-precincts.mjs hash-pins and replays four local-boundary packages without vote allocation: 2012 official precinct-sorted VTD rows joined to MGGG/NCGA geometry, 2016 exact official NCSBE geometry IDs, 2020 official NCSBE geometry plus four documented official supplements, and a fail-closed 2024 candidate plus three unconfirmed supplements; scripts/normalize-nc-turnout.mjs now hash-pins both NCSBE ZIPs, their extracted entries, and the EAC benchmark, rejects malformed numeric/row data, asserts exact source counts, and supports a no-write --check replay","manualReviewBurden":"medium","confidence":"loaded","caveats":"Certified county totals aggregate all official reporting units. Local geometry never receives administrative, absentee, early-vote, provisional, transfer, or other no-geometry totals. The 2012 VTD analysis export reassigns accepted absentee/provisional ballots to residential VTDs and adds statutory statistical noise; it is official NCSBE analysis data rather than the certified canvass presentation, and MGGG ODbL/DBCL terms apply to geometry. The 2016 package maps 2,704 official precinct identities and keeps 505 result-only units separate. The 2020 package maps all 2,662 Real Precinct=Y units after four official-source topology repairs and keeps 403 Real Precinct=N units separate. The 2024 candidate maps all 2,658 Real Precinct=Y units and preserves one no-data feature, but public rendering remains blocked because three restored subprecinct polygons lack November 5 applicability confirmation. Each election retains its own boundary vintage and is not a stable cross-election trend geography.","nextAction":"Prepare guarded local database and immutable delivery tooling for reviewed 2012, 2016, and 2020 packages; keep 2024 outside public activation until an election-effective source or custodian confirmation establishes the three restored boundaries, and continue the separate turnout/audit context work."},{"state":"NH","stateName":"New Hampshire","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin_inventory","tier":"tier_1_official_export_database","reportingGrain":"town_ward","exportFormats":["XLS","XLSX","normalized CSV","archived official 2016/2020 XLS/XLSX baseline workbooks","admin inventory JSON","source request matrix TSV"],"sourceUrls":["https://www.sos.nh.gov/2024-general-election-results"],"exampleUrls":["https://web.archive.org/web/20241219172754id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-president_3.xls","https://web.archive.org/web/20250311214424id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-congressional-district-1_3.xlsx","https://web.archive.org/web/20250611055423id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2024-ge-names-on-checklist_7.xlsx","https://web.archive.org/cdx?url=www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2016-ge-president*&output=json&fl=timestamp,original,statuscode,mimetype&filter=statuscode:200&collapse=urlkey","https://web.archive.org/web/20240720085749id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2016-ge-governor.xls","https://web.archive.org/web/20240720085753id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/inline-documents/sonh/2016-ge-congressional-district-1.xlsx","https://www.sos.nh.gov/elections/2020-election-results/2020-general-election-results","https://web.archive.org/web/20231127033944id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/documents/2020%20GE%20Election%20Tallies/2020-president.xls","https://web.archive.org/web/20231127033944id_/https://www.sos.nh.gov/sites/g/files/ehbemt561/files/documents/2020%20GE%20Election%20Tallies/2020-presidential-write-ins.xls"],"availableFields":["town/ward President rows","town/ward U.S. House comparison rows by congressional district","town/ward Governor comparison rows retained as context","town/ward ballots-cast rows","town/ward names-on-checklist registered-voter denominator rows","county geometry","county equipment context","official 2016 and 2020 county presidential historical baseline rows normalized from archived SOS workbooks","NH administration/source inventory with recount, geometry, audit, CVR, incident, correction, and litigation request paths","NH source request matrix with exact follow-up rows for 2016/2020/2012 historical baselines, town/ward geometry, and administration-context records"],"missingFields":["official 2012 historical President baseline and historical President-versus-U.S. House/Governor ticket-splitting baselines","town/ward boundary geometry","normalized post-election audit rows","normalized recount, CVR availability, incident/correction, and litigation rows"],"parserStatus":"newHampshireTownWardCsv loaded with official President, Governor, U.S. House, ballots-cast, and names-on-checklist rows normalized by scripts/normalize-nh-general-workbooks.mjs; scripts/normalize-nh-historical-baseline.mjs now generates 20 official county historical presidential rows for 2016 and 2020 with county:<GEOID> tags; data/nh-2024-admin-source-inventory.json records remaining admin/geometry/2012 request paths","manualReviewBurden":"medium","confidence":"loaded_with_district_comparison_and_historical_caveats","caveats":"Live SOS pages are access-limited from this environment; archived official workbook artifacts are retained. U.S. House is same town/ward grain but district-based rather than a single statewide contest. State-native ballots-cast and names-on-checklist rows replace EAC fallback turnout, with a one-vote source summary/detail caveat in ballots-cast totals. Official 2016 and 2020 county historical presidential baselines are loaded as contextual county rows with FIPS jurisdiction tags; 2012 remains a targeted archive/records-request item tracked in data/nh-2024-source-request-matrix.tsv.","nextAction":"Continue targeted archive/records requests for official 2012 historical baseline artifacts; request town/ward geometry or a reporting-unit crosswalk; normalize official audit/recount/CVR/incident/correction/litigation records if obtained."},{"state":"OH","stateName":"Ohio","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_admin","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["XLSX","official precinct rows"],"sourceUrls":["https://www.ohiosos.gov/elections/election-results-and-data/"],"exampleUrls":[],"availableFields":["precinct presidential rows","precinct U.S. Senate comparison rows","ward-level review rows","precinct registered-voter turnout denominator rows","county equipment context"],"missingFields":["precinct boundary geometry","normalized official post-election audit result rows","statewide CVR availability inventory","incident, correction, recount, and litigation source inventory","2020, 2016, and 2012 historical baselines"],"parserStatus":"native official XLSX package loaded for county certified results, precinct President-versus-U.S.-Senate review rows, and precinct registered-voter turnout rows","manualReviewBurden":"low","confidence":"loaded","caveats":"Ohio comparison screening is mapped from the Secretary of State precinct-level U.S. Senate rows in the same official workbook as the presidential precinct rows. County geometry is loaded for map joins, but precinct boundary geometry is not loaded. Audit, DATA Act/CVR availability, incident/correction/recount/litigation context, and official historical baselines remain source-inventory gaps.","nextAction":"Collect official precinct boundary geometry if available; inventory Ohio 2024 post-election audit/CVR/recount/correction/litigation sources; then add official 2020/2016/2012 county presidential baselines."},{"state":"OK","stateName":"Oklahoma","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["official race-level CSV","official county-level CSV ZIP","official precinct-level CSV ZIP","EAC fallback turnout CSV","Census county GeoJSON","Verified Voting equipment context CSV","official Nov. 1 voter-registration PDF denominator lead","official 2020 results app county tables","official historical county-level CSV ZIP","normalized historical county CSV"],"sourceUrls":["https://oklahoma.gov/elections/elections-results/election-results/2024-election-results/november-general-election.html","https://results.okelections.gov/OKERS/enrapi/GetExtract/CSV/20241105","https://results.okelections.gov/OKERS/enrapi/GetExtract/CLCSV/20241105","https://results.okelections.gov/OKERS/enrapi/GetExtract/PLCSV/20241105","https://www.eac.gov/research-and-data/studies-and-reports","https://oklahoma.gov/elections/security-integrity/post-election-audits/post-election-audit-archives/2024-post-election-audits.html","https://oklahoma.gov/elections/candidates/district-and-precinct-maps.html","https://oklahoma.gov/elections/about-us/information-and-records-requests.html","https://oklahoma.gov/content/dam/ok/en/elections/voter-registration-statistics/2024-vr-statistics/vrstats-district-nov1-2024.pdf","https://results.okelections.gov/OKER/?elecDate=20201103","https://oklahoma.gov/elections/elections-results/election-results/2016-election-results/2016-november-general-election.html","https://results.okelections.gov/OKERS/enrapi/GetExtract/CLCSV/20161108","https://oklahoma.gov/elections/elections-results/election-results/2020-election-results/2020-november-general-election.html","https://results.okelections.gov/OKERS/enrapi/GetExtract/CLCSV/20201103"],"exampleUrls":["https://results.okelections.gov/OKERS/enrapi/GetExtract/PLCSV/20241105","https://oklahoma.gov/content/dam/ok/en/elections/voter-registration-statistics/2024-vr-statistics/vrstats-district-nov1-2024.pdf"],"availableFields":["official county presidential totals","official precinct presidential rows","official precinct U.S. House comparison rows where both major-party House candidates are present","official EAC fallback turnout rows","county geometry","county equipment context from Verified Voting","official post-election audit archive source path","official Nov. 1, 2024 county registered-voter denominator lead parsed from congressional-district county fragments and reconciled to EAC registered voters","official 2020 county presidential historical baseline rows","official 2016 and 2020 county presidential candidate exports normalized to 77 canonical county tags per year"],"missingFields":["state-native ballots-cast or voter-history rows to pair with the collected Nov. 1 registered-voter denominator lead","precinct boundary geometry or precinct-to-county crosswalk","normalized post-election audit selection/outcome rows","normalized CVR availability, recount, incident, correction, and litigation records","state-native turnout denominator rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"nativeOklahomaOfficialCsvZip loads official 2024 race/county/precinct exports; scripts/collect-ok-vrstats-registration.mjs preserves the Nov. 1 registration denominator lead; scripts/normalize-ok-historical-presidential-baseline.py safely loads exact-root official 2016/2020 CountyResults ZIP members into 154 canonical county rows.","manualReviewBurden":"low","confidence":"loaded_with_caveat","caveats":"Oklahoma has official export endpoints for current and historical county results. Review rows use U.S. House by district and retain vote-share-only rows when a precinct lacks both major-party House candidates. Historical rows retain every official candidate: three tickets in 2016 and six in 2020, with all non-Democratic/non-Republican votes classified as Other. Turnout remains EAC fallback; official 2012 history, precinct geometry, and normalized audit/CVR/recount/incident/correction/litigation rows remain gaps.","nextAction":"Collect Oklahoma-native ballots-cast or voter-history rows, official precinct geometry/crosswalks, an official 2012 county baseline, and row-level audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"PA","stateName":"Pennsylvania","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["TXT","XLSX","official Census and LRC Shapefile ZIP diagnostics","official Union County historical Shapefile ZIPs distributed by PASDA","version-pinned VEST Shapefile ZIPs","normalized vote-free GeoJSON and reviewed crosswalk JSON"],"sourceUrls":["https://www.pa.gov/agencies/vote/elections/election-results.html","https://www.pa.gov/agencies/dos/resources/voting-and-elections-resources/voting-and-election-statistics/election-data","https://www.redistricting.state.pa.us/maps/","https://www2.census.gov/geo/tiger/TIGER2012/VTD/tl_2012_42_vtd10.zip","https://www.pasda.psu.edu/uci/DataSummary.aspx?dataset=1994","https://election.lab.ufl.edu/dataset/pa-2016-precinct-level-election-results/","https://election.lab.ufl.edu/dataset/pa-2020-precinct-level-election-results/"],"exampleUrls":[],"availableFields":["precinct President rows","precinct U.S. Senate rows","official precinct registration snapshot joined by county code plus precinct code, with 9,154 warning-required presidential-participation proxy review rows","county turnout","official 2012/2016/2020 county historical baselines from precinct bulk rows","published reviewed partial 2016 and 2020 precinct geometry/crosswalk packages with every geometry-source vote field stripped","reviewed delivery-null official Union County 2020 and 2024 candidate packages with 27 polygons and 27 result relationships each; the 2020 vintage is confirmed and the 2024 vintage is unknown","blocked 2012 Census VTD and statewide 2024 LRC VTD availability diagnostics"],"missingFields":["complete election-effective 2012 and statewide 2024 precinct geometry and official result crosswalks beyond the Union County candidate","complete 2016 and 2020 result-to-geometry coverage beyond the published exact-vector subsets and reviewed Union County candidate","affirmative 2024 Union County boundary-effective-date evidence, plus terms-reviewed immutable delivery and guarded activation for new official county expansions","precinct vote-history or election-level ballots-cast numerator"],"parserStatus":"Native precinct review, an exact county-code-plus-precinct-code registration join, and official historical bulk baselines are loaded. The registration parser rebuilds the returns display name from segmented breakdown fields and exposes only a warning-required presidential-votes/registration participation proxy below county level. scripts/collect-pa-precinct-geometry.mjs rebuilds the four canonical vote-free source packages; the reviewed partial 2016/2020 subsets are public. scripts/collect-pa-union-county-precinct-geometry.mjs separately rebuilds official 2020/2024 Union County candidates from hash-pinned PASDA archives and complete unique county-scoped name bijections, while keeping the 2024 vintage unknown because its feature metadata remains dated 2021-10-12.","manualReviewBurden":"high","confidence":"loaded_with_caveat","caveats":"Actual turnout is county-level, not precinct-level. The precinct registration join supports a warning-required presidential-participation proxy only: four nonzero review rows have zero registration denominators and 17 drawable ratios exceed 100 percent. Historical baselines are official DOS bulk context and may differ from secondary certified-summary tables where write-in reconciliation is separate. VEST supplies attributed 2016/2020 geometry only; its election-value fields are stripped and DOS remains the sole vote authority. The published 2016 package excludes 1,158 official units/782,683 votes; the published 2020 package excludes 2,360 units/1,545,703 votes, including every Pike County unit. Official Union County candidates cover 27 units in 2020 and 2024, but remain delivery-null; the PASDA metadata has no explicit open-data license. The 2024 archive has a 2024-09-05 export lineage but 2021-10-12 feature metadata, so Election Day effectiveness is unknown. The canonical 2012 and statewide 2024 packages remain blocked with zero normalized features.","nextAction":"Continue election-effective official county archive/crosswalk collection, using the retained Union County candidates as the reviewed pattern. Obtain custodian or other authoritative effective-date evidence before treating the 2024 Union County geometry as election-applicable. Any county expansion requires separate terms and guarded release review; collect same-grain precinct vote-history or election-level ballots-cast rows before describing local participation as turnout."},{"state":"RI","stateName":"Rhode Island","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_1_official_export_database","reportingGrain":"county_aggregated_city_town_federal_reporting_unit_review_and_city_town_precinct_party_status_registration","exportFormats":["official long-format ZIP","official short-format ZIP","statewide JSON","normalized CSV","EAC fallback turnout CSV","official SOS Data Hub Power BI registration query and normalized city/town-precinct status rows","promotion reconciliation JSON"],"sourceUrls":["https://www.ri.gov/election/results/","https://www.ri.gov/election/results/2012/general_election/data/rigen2012l.zip","https://www.ri.gov/election/results/2016/general_election/data/rigen2016l.zip","https://www.ri.gov/election/results/2020/general_election/data/rigen2020l.zip","https://www.ri.gov/election/results/2024/general_election/data/rigen2024l.zip","https://rigov.s3.amazonaws.com/election/results/2024/general_election/statewide.json","https://www.eac.gov/research-and-data/studies-and-reports","https://datahub.sos.ri.gov/RegisteredVoter.aspx/"],"exampleUrls":["https://www.ri.gov/election/results/2024/general_election/data/rigen2024l.zip","https://rigov.s3.amazonaws.com/election/results/2024/general_election/statewide.json"],"availableFields":["official finalized-root 2024 city/town presidential rows aggregated to five county result-map rows plus unforced Federal Precincts","official same-key President-versus-U.S.-Senate review rows from the finalized BOE long-format root member","EAC fallback turnout rows","official SOS Data Hub 2024-11-01 city/town-and-precinct registration denominator lead with Active, Inactive, and Pending statuses","official finalized-root 2012, 2016, and 2020 city/town presidential rows aggregated to five canonical county tags per year plus unforced Federal Precincts","county geometry and supplemental equipment context","fail-closed live-versus-staging historical promotion reconciliation with per-year, per-county, tag, vote-total, and display-path differences"],"missingFields":["state-native ballots-cast or voter-participation rows compatible with the SOS Data Hub registration lead","result-ready city/town or precinct geometry/crosswalk for finer overlays","normalized official audit, recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"scripts/normalize-ri-boe-results.mjs reads explicit finalized root members from the official 2012, 2016, 2020, and 2024 BOE long-format ZIPs, rejects sanitized non-root entries, requires exact President and Senate statewide bucket reconciliation, emits six 2024 result rows, 444 review rows, and 18 county-plus-Federal historical rows; nativeRhodeIslandBoeCsv loads the normalized artifacts. scripts/normalize-ri-registration-datahub.mjs reproduces and hash-pins the official public Power BI registration query and emits 3,838 status-separated city/town-precinct-party rows as a denominator lead. scripts/audit-ri-historical-promotion.mjs then fails closed unless the live API and staging preserve all years and every official vote bucket while resolving to five canonical county tags plus unforced Federal Precincts.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The explicit finalized 2024 long-format root member reconciles exactly to posted statewide President and U.S. Senate bucket totals; no synthetic reconciliation row is emitted. Review rows exclude zero-vote Limited rows and presidential-only rows. Federal Precincts remain non-geographic and unforced. EAC turnout remains active; the SOS Data Hub 2024-11-01 registration lead is status-separated, has no compatible ballots-cast field, and totals 794 above EAC. The read-only promotion audit accepted reducing 86 live rows to 18 staged rows (a 68-row reduction) by aggregating 2012/2016 municipal rows to counties: all 2012/2016/2020 statewide and canonical county/Federal vote buckets have zero delta, 2020 display rows are unchanged, and production promotion remains a separate coordinator action.","nextAction":"Collect state-native ballots-cast or voter-participation rows compatible with the SOS Data Hub registration lead, pursue finer city/town or precinct geometry/crosswalks, and normalize audit/CVR/recount/incident/correction/litigation records. Preserve the accepted historical-promotion reconciliation as the pre-promotion guard."},{"state":"SC","stateName":"South Carolina","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["official CSV download","Election History table export","Election History Voter Statistics contest export","official 2012 historical President CSV download","official 2016 and 2020 historical President CSV downloads","normalized historical baseline CSV","historical contest CSV","reviewed election-specific precinct GeoJSON/Shapefile packages"],"sourceUrls":["https://electionhistory.scvotes.gov/","https://sc.elstats.civera.com/api/download_contest/7131_table.csv?split_party=false","https://sc.elstats.civera.com/api/download_contest/7075_table.csv?split_party=false","https://sc.elstats.civera.com/api/download_contest/1974_table.csv?split_party=false","https://sc.elstats.civera.com/api/download_contest/5292_table.csv?split_party=false","https://sc.elstats.civera.com/api/download_contest/9112_table.csv?split_party=false","https://dataverse.harvard.edu/file.xhtml?persistentId=doi:10.7910/DVN/NH5S2I/Y3OFQZ&version=78.0","https://dataverse.harvard.edu/file.xhtml?fileId=4789402&version=27.0","https://int.nyt.com/newsgraphics/elections/map-data/2024/national/SC-precincts-with-results.geojson.gz"],"exampleUrls":["https://electionhistory.scvotes.gov/contest/7131","https://sc.elstats.civera.com/api/download_contest/7131_table.csv?split_party=false","https://electionhistory.scvotes.gov/contest/7075","https://sc.elstats.civera.com/api/download_contest/7075_table.csv?split_party=false","https://electionhistory.scvotes.gov/contest/1974","https://sc.elstats.civera.com/api/download_contest/1974_table.csv?split_party=false"],"availableFields":["official presidential county and precinct CSV rows","official U.S. House county and precinct CSV comparison rows","official VREMS county voter-history turnout and printed-list registration rows","official VREMS precinct/polling-place locator export","EAC turnout fallback retained as a benchmark","official Election History 2024 General Voter Statistics state/county/precinct export retained as a candidate registration and election-level ballots source","official 2012 county presidential historical baseline rows normalized from the SC Elections Database contest CSV","official 2020 county presidential historical baseline rows from the SC Elections Database contest CSV","official 2016 county presidential historical baseline rows","hash-pinned historical source artifacts and statewide reconciliation summaries","reviewed 2016, 2020, and 2024 precinct geometry and official-result crosswalks without vote allocation","blocked 2012 RFA-origin candidate geometry and official precinct-result evidence"],"missingFields":["immutable parent-scoped delivery and guarded production activation for the reviewed 2016, 2020, and 2024 geometry","election-date, affirmative-reuse, and official crosswalk proof for 2012 geometry","statewide same-office comparison contest","active-registered-voter denominator artifact at the same grain as precinct results","reviewed semantic equivalence of Election History Voter Statistics registration/ballots fields to active VREMS voter-history rows before any turnout-source replacement"],"parserStatus":"native parser loaded from official Election History President and U.S. House CSV downloads; scripts/normalize-sc-election-history-voter-statistics.mjs retains and hash-pins Voter Statistics contest 7075 as a candidate source with an explicit county reconciliation to active VREMS; historical 2012, 2016, and 2020 county baselines normalize from official Election History contest CSVs; county turnout uses normalized SC VREMS voter-history rows; scripts/build-sc-reviewed-precincts.mjs deterministically rebuilds all four precinct source packages","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"U.S. House is district-based rather than a single statewide comparison race; duplicate county/precinct keys from district splits are aggregated before advisory directional screening. The Election History Voter Statistics contest 7075 export reports 2,566,404 election-level ballots and 3,451,344 registered voters across 46 counties, while active SC VREMS reports 2,553,185 participating voters and 3,851,930 printed-list registrants; no active/inactive breakdown is exposed in the candidate export, so VREMS remains active and warning-required. VEST and NYT supply attributed geometry only; their vote fields are stripped and the South Carolina Election Commission CSVs remain the sole result authority. The 2012 geometry archive is post-election and has no retained affirmative derivative terms or reviewed crosswalk, but the independent official 2012 county baseline is now loaded. The retained historical source bytes and SHA-256 values are recorded in data/sc-historical-presidential-baseline-summary.json. A 2026-08-19 review proved the apparent 2016 drift was checkout line-ending conversion only: the repository blob, endpoint content, and all contest totals were identical. Byte-preservation attributes now keep the current 132,795-byte LF response stable.","nextAction":"Build immutable county-scoped delivery and guarded release tooling for reviewed 2016, 2020, and 2024 packages; obtain election-date geometry/reuse/crosswalk evidence for 2012; resolve the Election History/VREMS denominator and ballots semantics before considering any turnout-source change; and normalize audit/CVR/incident/recount/litigation rows."},{"state":"VA","stateName":"Virginia","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["CSV"],"sourceUrls":["https://www.elections.virginia.gov/resultsreports/election-results/"],"exampleUrls":[],"availableFields":["official presidential locality rows","official precinct President rows","official precinct U.S. Senate comparison rows","official precinct turnout and registration rows","official ENR change-log summary","county-equivalent geometry"],"missingFields":["precinct boundary geometry","normalized audit, recount, CVR availability, incident, litigation, and correction records beyond ENR change-log summary and equipment context"],"parserStatus":"native Virginia ElectionStats and ENR package loaded for certified locality results, precinct President-versus-U.S. Senate review rows, and precinct turnout/registration rows","manualReviewBurden":"low","confidence":"loaded","caveats":"Review rows use the official VA ENR all-results CSV and ENR canonical precinct names, which can differ from the historical contest CSV display names. The ENR turnout file reports TotalVoteTurnout across the ballot, not presidential contest votes. Precinct boundary geometry and deeper audit/CVR/incident records remain uncollected.","nextAction":"Collect precinct boundary geometry and official audit/CVR/recount/litigation records or document source-side blockers."},{"state":"WA","stateName":"Washington","jurisdictionName":"Statewide participating county package","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["CSV","official historical all-counties CSV","normalized historical baseline CSV"],"sourceUrls":["https://www.sos.wa.gov/elections/data-research/election-data-and-maps","https://results.vote.wa.gov/results/20201103/export.html","https://results.vote.wa.gov/results/20201103/export/20201103_AllCounties.csv","https://results.vote.wa.gov/results/20161108/export/20161108_AllCounties.csv"],"exampleUrls":["https://results.vote.wa.gov/results/20241105/export/20241105_AllCounties.csv","https://results.vote.wa.gov/results/20201103/export/20201103_AllCounties.csv"],"availableFields":["county presidential totals","participating precinct review rows","county turnout fallback","official 2016 and 2020 county presidential historical baseline rows"],"missingFields":["complete statewide precinct export","precinct boundary geometry","state-native turnout denominator","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"native participating precinct review package loaded; scripts/normalize-wa-historical-presidential-baseline.mjs downloads official 2016 and 2020 all-counties CSV exports and writes 78 historicalPresidentialCsv county baseline rows","manualReviewBurden":"medium","confidence":"partial_with_2016_2020_historical_loaded","caveats":"Participating precinct export is 5,309 presidential votes below certified county totals. Official 2016 and 2020 county presidential historical baselines are loaded from all-counties CSV exports; 2012 remains missing.","nextAction":"Identify whether a complete statewide precinct package exists or keep participating-export caveat; collect state-native turnout denominator, precinct geometry, 2012 historical baseline, and administration-context artifacts."},{"state":"WI","stateName":"Wisconsin","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_audit_geometry","tier":"tier_1_official_export_database","reportingGrain":"ward","exportFormats":["XLSX"],"sourceUrls":["https://elections.wi.gov/elections/election-results"],"exampleUrls":[],"availableFields":["ward President rows","ward U.S. Senate rows","EAC fallback turnout","EAC vote-method rows","Verified Voting equipment context","2012/2016/2020 county historical presidential baselines","WEC post-election audit selected reporting units","WEC post-election audit statewide findings","reviewed election-specific local-reporting geometry and official-result crosswalks for 2016, 2020, and 2024","blocked 2012 official-result and LTSB ward evidence package"],"missingFields":["ward-level registration denominator","per-reporting-unit audit discrepancy outcomes","county CVR availability verification","normalized incident/correction/recount/litigation rows","authoritative 2012 reporting-unit-to-election-boundary crosswalk","immutable parent-scoped geometry delivery and guarded production activation"],"parserStatus":"native ward review package loaded; deterministic reviewed local-reporting geometry builder covers 2016, 2020, and 2024 and preserves a blocked 2012 package","manualReviewBurden":"medium","confidence":"loaded_with_reviewed_geometry_candidates","caveats":"Turnout rows use EAC local-jurisdiction fallback because WEC ward workbook lacks denominator fields. Historical rows are contextual county baselines from secondary tables with source footnotes. WEC/GAB workbooks are the sole source of displayed vote values. VEST 2016/2020 and NYT 2024 supply attributed geometry only; their election-value fields are discarded. The official LTSB January 2025 ward layer is retained only as a blocked diagnostic because its metadata says election values were population-disaggregated and ward totals may differ from WEC totals. No official result row is split or proportionally allocated. The 2012 LTSB context is population-disaggregated and cannot prove a vote-preserving reporting-unit crosswalk, so 2012 remains blocked. WEC audit context includes selected reporting units and statewide findings, but the published report does not include per-reporting-unit discrepancy outcomes.","nextAction":"Validate and seal the guarded 2016/2020/2024 local-reporting release from a clean merged checkout, then execute the separately authorized hidden-load, immutable delivery, deployment, and atomic publication sequence. Obtain an authoritative 2012 reporting-unit crosswalk or election-effective boundary package before considering 2012 delivery; separately continue denominator and administration-context collection."},{"state":"WY","stateName":"Wyoming","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_equipment_admin_context","tier":"tier_1_official_export_database","reportingGrain":"precinct","exportFormats":["official SOS XLSX ZIP","EAC fallback turnout CSV","Census county GeoJSON","supplemental equipment context"],"sourceUrls":["https://sos.wyo.gov/Elections/Docs/2024/2024GeneralResults.aspx","https://sos.wyo.gov/Elections/Docs/2024/Results/General/2024_Wyoming_General_Results.zip","https://sos.wyo.gov/Elections/ElectionResults.aspx","https://www.eac.gov/research-and-data/studies-and-reports","https://www2.census.gov/geo/tiger/TIGER2024/COUNTY/tl_2024_us_county.zip"],"exampleUrls":["https://sos.wyo.gov/Elections/Docs/2024/2024GeneralResults.aspx"],"availableFields":["certified county presidential totals","precinct-by-precinct President rows","same-row U.S. Senate comparison contest","EAC fallback turnout and registered-voter denominator rows","county geometry","official 2012/2016/2020 county historical baselines","supplemental equipment context"],"missingFields":["state-native registered-voter denominator","precinct boundary geometry or crosswalks","normalized audit/CVR/recount/incident/correction/litigation records"],"parserStatus":"nativeWyomingSosGeneralZip parses official 2024 SOS ZIP plus official 2012/2016/2020 historical ZIPs; turnout remains EAC fallback.","manualReviewBurden":"low_for_results_medium_for_remaining_context","confidence":"loaded_with_caveat","caveats":"Official result and review rows are loaded. EAC fallback turnout denominator remains active; precinct geometry and post-election context records remain request-tracked.","nextAction":"Collect state-native registered-voter denominator, precinct geometry/crosswalks, and official audit/CVR/recount/incident/correction/litigation context where available."},{"state":"AR","stateName":"Arkansas","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"reporting_unit","exportFormats":["TotalResults JSON API","EAC fallback turnout CSV","Census TIGERweb GeoJSON"],"sourceUrls":["https://enr.totalresults.com/arkansas/","https://www.sos.arkansas.gov/elections/results","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2705%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson"],"exampleUrls":["https://enr.totalresults.com/arkansas/"],"availableFields":["official county presidential totals","official county-scoped reporting-unit President rows","official county-scoped reporting-unit U.S. House comparison rows","EAC fallback turnout rows","county geometry","county equipment context from Verified Voting Verifier"],"missingFields":["human-readable precinct names for TotalResults reporting-unit IDs","state-native county or precinct turnout denominator rows","precinct boundary geometry or reporting-unit crosswalks","official 2012/2016/2020 historical baseline artifacts normalized into ETL","normalized official audit, recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"arkansasTotalResultsFederalJson loaded for official county President rows and county-scoped reporting-unit President-versus-U.S.-House review rows; EAC fallback turnout and Census county geometry are loaded; admin registry has equipment context only","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The TotalResults county-scoped federal buckets expose stable reporting-unit IDs but not human-readable precinct names. U.S. House is district-based and candidate-specific, so advisory screens are directional source-review context, not candidate-benefit findings. Turnout remains EAC fallback, and no normalized Arkansas audit/recount/CVR/incident/correction rows or official historical baselines are loaded.","nextAction":"Use data/ar-2024-data-coverage-inventory.json as the current AR source-search record; next steps are state-native turnout denominators, official precinct/reporting-unit crosswalk or geometry, normalized official historical baselines, and audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"CO","stateName":"Colorado","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county","exportFormats":["official Clarity detail XML ZIP endpoint","official SOS Abstract of Votes Cast source path","official Historical Election Data voter-statistics CSV","EAC benchmark turnout CSV","Census county GeoJSON","Verified Voting equipment context","official 2012, 2016, and 2020 Historical Election Data President contest CSVs"],"sourceUrls":["https://results.enr.clarityelections.com/CO/122598/web.345435/#/summary","https://results.enr.clarityelections.com/CO/122598/current_ver.txt","https://results.enr.clarityelections.com/CO/122598/367167/reports/detailxml.zip","https://historicalelectiondata.coloradosos.gov/search?","https://historicalelectiondata.coloradosos.gov/contest/5017","https://historicalelectiondata.coloradosos.gov/contest/4436","https://historicalelectiondata.coloradosos.gov/contest/3640","https://www.sos.state.co.us/pubs/elections/Results/Abstract/","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2708%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/8","https://www.sos.state.co.us/pubs/elections/Resources/countyElectionOffices.html","https://www.sos.state.co.us/pubs/info_center/recordsRequests.html"],"exampleUrls":["https://results.enr.clarityelections.com/CO/122598/367167/reports/detailxml.zip"],"availableFields":["official county presidential candidate rows from the committed Clarity detail XML endpoint","loaded county CU Regent at-large comparison rows from the same endpoint","official state-native county turnout and active-plus-inactive registered-voter denominator rows from Historical Election Data voter statistics","official 2012, 2016, and 2020 county presidential historical baseline rows from Historical Election Data contest exports","EAC fallback turnout rows retained as benchmark context","Clarity ElectionVoterTurnout rows retained as reconciliation context","county geometry","county equipment context"],"missingFields":["write-in-inclusive county allocation for the 1,872-vote Clarity-versus-Abstract presidential gap","precinct or local reporting-unit President rows","same-grain precinct or local comparison contest rows","precinct boundary geometry or reporting-unit crosswalk","normalized official audit, recount, CVR availability, incident, correction, litigation, custody, ballot-manifest, tabulator-log, and EMS-log rows"],"parserStatus":"coloradoClarityDetailXml loaded for 64 county President rows and 64 county President-versus-CU-Regent review rows; scripts/normalize-co-historical-voter-statistics.mjs collects the Historical Election Data voter-statistics CSV and writes the active normalizedTurnoutCsv county turnout rows; scripts/normalize-co-historical-presidential-baseline.mjs collects the official 2012, 2016, and 2020 President contest list CSVs and writes 192 historicalPresidentialCsv county baseline rows","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The official Clarity statewide detail XML exposes county candidate totals and precinct participation counts, but no per-precinct candidate result rows were observed. Loaded presidential candidate rows sum to 3,190,873, which is 1,872 below the prior Abstract/certified-total lead of 3,192,745; do not allocate that gap by county without an official source. Colorado had no 2024 U.S. Senate race; the same-grain comparison is county-level CU Regent at-large. Active turnout now uses official Historical Election Data 2024 General Voting Statistics county rows: Total Voters equals Active Voters plus Inactive Voters and matches the former EAC denominator, while Total Ballots Cast is 401 above EAC and 35 above Clarity ElectionVoterTurnout. Official 2012, 2016, and 2020 county presidential baselines are loaded from the same Historical Election Data platform.","nextAction":"Collect an official write-in-inclusive Abstract artifact or source note for the 1,872-vote presidential gap, then pursue precinct/local result rows, precinct geometry/crosswalks, and normalized audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"CT","stateName":"Connecticut","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"certified_sov_current_planning_region_results_with_town_review_turnout","exportFormats":["official EMS static JSON","official Statement of Vote PDF","official EMS town turnout JSON","Census TIGERweb county-subdivision GeoJSON","EAC fallback turnout CSV benchmark","official Election History CSV source-review artifact","official historical EMS static JSON","Census TIGERweb planning-region GeoJSON","normalized current-planning-region crosswalk and historical CSV","normalized certified SOV town President CSV","SOV-versus-EMS reconciliation JSON"],"sourceUrls":["https://ctemspublic.tgstg.net/","https://ctemspublic.tgstg.net/ng-app/data/Elections.json","https://portal.ct.gov/sots/election-services/election-results/election-results","https://portal.ct.gov/sots/election-services/statement-of-vote-pdfs/general-elections-statement-of-vote-1922?archived=true","https://electionhistory.ct.gov/","https://portal.ct.gov/sots/election-services/statistics-and-data/statistics-and-data","https://voter.engr.uconn.edu/audits-2/","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/tigerWMS_Current/MapServer","https://ctemspublic.tgstg.net/ng-app/data/election/1/5603/townVotes_Electiondata.json","https://ctemspublic.tgstg.net/ng-app/data/election/54/64824/townVotes_Electiondata.json"],"exampleUrls":["https://ctemspublic.tgstg.net/ng-app/data/election/91/Version.json","https://ctemspublic.tgstg.net/ng-app/data/election/91/80741/townVotes_Electiondata.json","https://ctemspublic.tgstg.net/ng-app/data/election/91/80741/voterTurnout_Electiondata.json","https://portal.ct.gov/-/media/sots/electionservices/statementofvote_pdfs/2024_statement_of_vote.pdf?hash=27BE5012F5EF0B6BBF37B2A9242B54A2&rev=21871844f0be463886b823b12e6a442e","https://electionhistory.ct.gov/search?"],"availableFields":["official town President rows in EMS static JSON loaded into staging","official town U.S. Senate rows in the same EMS static JSON loaded into staging with cross-endorsed Murphy lines fused","official EMS town turnout rows loaded into staging as warning-required state-native turnout context","official Statement of Vote PDF collected as reconciliation source","official Election History event 582 President town/vote-channel source review confirming EMS President totals","official polling-place labels and reporting-completeness fields for 759 polling places","official Statement of Vote and Election History leads for 2012, 2016, and 2020 historical baselines","county geometry, town/MCD geometry lead, and Verified Voting equipment context","UConn VoTeR 2024 post-election audit report lead linked from Connecticut SOTS","nine current Census planning-region President rows aggregated from 169 official 2024 EMS town rows","169 official town U.S. Senate review rows with cross-endorsed Murphy lines fused","169 official EMS town turnout rows loaded as warning-required state-native turnout context","official 2016 and 2020 EMS town President rows aggregated reproducibly to nine current planning-region county-equivalent tags per year","exact 169-town EMS-name to Census BASENAME crosswalk using current Census COUNTY/GEOID assignments","current planning-region geometry, town/MCD geometry, and Verified Voting equipment context","certified Statement of Vote PDF reconciled to 169 town rows, 12 presidential tickets, and nine current planning-region aggregates"],"missingFields":["Election History event 582 voter-statistic rows or registered-voter denominator that could replace EMS turnout warnings","confirmed precinct/ward candidate vote rows or CVR availability","EMS town/MCD geometry crosswalk QA and precinct/ward geometry if sub-town rows are collected","normalized audit, CVR, recount, incident, correction, and litigation rows","precinct/ward geometry if sub-town rows are collected","official 2012 historical baseline normalized into ETL"],"parserStatus":"scripts/normalize-ct-2024-statement-of-vote.mjs hash-pins and extracts all certified SOV town President tickets; connecticutEmsTownJson uses those 169 rows for nine current planning-region results/review presidential fields while EMS supplies 169 town U.S. Senate comparison and turnout rows. scripts/normalize-ct-historical-presidential-baseline.mjs produces 18 tagged 2016/2020 historical rows.","manualReviewBurden":"medium","confidence":"loaded_certified_sov_reconciled","caveats":"Connecticut reporting is town-centric, while the active county-equivalent comparison geography is nine current Census planning regions. The certified SOV has 265 more President votes than EMS version 80741; active President rows use SOV, while EMS supplies Senate comparison and warning-required turnout. The 2016/2020 region rows are current-geography aggregates, not historical reporting units.","nextAction":"Collect an official 2012 baseline, review EMS report-download paths for precinct/ward rows or CVR availability, resolve EV/VV turnout semantics, and normalize audit/CVR/recount/incident/correction/litigation records if published or request-produced."},{"state":"GA","stateName":"Georgia","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct_2024_county_historical_review","exportFormats":["official media export JSON","normalized CSV"],"sourceUrls":["https://results.sos.ga.gov/","https://results.sos.ga.gov/results/public/Georgia","https://sos.ga.gov/page/historical-elections-results","https://results.sos.ga.gov/cdn/results/Georgia/export-2016NovGen.json","https://results.sos.ga.gov/cdn/results/Georgia/export-2020NovGen.json"],"exampleUrls":[],"availableFields":["precinct presidential rows","precinct U.S. House comparison rows from the same official media export","county turnout from EAC fallback","official 2012/2016/2020 county historical presidential baselines from Georgia SOS media exports","official 2012/2016/2020 county registration and ballots-cast leads from SOS General Election archives","county equipment context from Verified Voting Verifier","official President vote-method candidate groupResults from SOS media export","documented turnout/registration exclusion review at data/ga-2024-turnout-vote-method-source-review.json","official 2016 and 2020 county President-versus-U.S.-Senate historical advisory rows: 159 canonical county rows per year in data/ga-historical-review-rows.csv"],"missingFields":["state-native turnout denominator","precinct boundary geometry","normalized official audit/recount/CVR/incident/correction records"],"parserStatus":"native precinct President-versus-U.S.-House review package loaded from official media export; official county historical baseline CSV generated from 2012/2016/2020 SOS media exports; scripts/normalize-ga-historical-archive-registration.mjs hash-verifies official SOS General Election archives and parses 159 county summary CSVs per year, reconciling presidential candidate totals to the JSON baselines while retaining registration/ballots-cast only as historical leads; scripts/normalize-ga-historical-review.mjs generates 318 historicalReviewCsv county President-versus-U.S.-Senate rows for 2016 and 2020 with exact statewide reconciliation; scripts/report-ga-turnout-vote-method-source-review.mjs documents that SOS vote-method groupResults are candidate-result splits and not a turnout replacement","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"U.S. House is district-based and candidate-specific, so Georgia directional screens are low-confidence advisory context rather than candidate-benefit findings. Of 2,684 nonzero presidential precinct review rows, 2,637 have comparable two-party U.S. House rows, 8 have one-sided House comparison coverage, and 39 precinct keys aggregate more than one House district and are excluded from down-ballot dropoff calculations. County presidential candidate rows sum 19 votes higher than the statewide presidential contest total in minor-party/other rows, and 17 zero-total precinct entries are omitted from review charts. Turnout remains EAC fallback and precinct geometry/admin evidence are not loaded. Historical rows are official county-level SOS media-export baselines for context only; the 2020 media export reports the original November general-election export total and should not be mixed with separate recount tables without reconciliation. The historical advisory package contains 159 canonical county rows for each of 2016 and 2020. The 2016 rows reconcile to 4,092,373 presidential votes and 3,897,792 Senate votes; the 2020 rows reconcile to 4,998,482 presidential votes and 4,952,175 regular Senate votes. The 2020 comparison is the regular US Senate (Perdue) contest from the original November general election before the runoff; the Loeffler special election is excluded. The selected historical county contest options expose no precinct-result rows, and advisory signals can reflect candidate, contest, split-ticket, and participation differences rather than misconduct. The July 5, 2026 vote-method source review found official President groupResults by Election Day, Absentee by Mail, Provisional, and Advanced Voting, but no registered-voter denominator or election-level ballots-cast field; EAC turnout remains active.","nextAction":"Use data/ga-2024-data-coverage-inventory.json as the current GA source-search record; next steps are state-native turnout denominators, precinct boundary geometry/crosswalks, and official audit/recount/CVR/incident/correction artifacts."},{"state":"IA","stateName":"Iowa","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct","exportFormats":["JSON","detail XML ZIP","Excel/statistical report links","county precinct shapefile and map archives","reviewed GeoJSON and result-to-geometry crosswalks"],"sourceUrls":["https://electionresults.iowa.gov/IA/","https://sos.iowa.gov/iowans/election-results-statistics","https://sos.iowa.gov/shapefiles-county-precincts"],"exampleUrls":["https://electionresults.iowa.gov/IA/122322/web.345435/","https://sos.iowa.gov/sites/default/files/2025-02/2024PrecinctAudits.png"],"availableFields":["county results","precinct President rows","precinct U.S. House comparison rows","precinct turnout/registration fields","President and U.S. House candidate vote type splits in official detail XML","complete official presidential precinct rows for 2012, 2016, 2020, and 2024","reviewed 2016, 2020, and 2024 statewide precinct geometry and exact one-to-one crosswalks","hash-pinned geometry attribution and redistribution terms","official county precinct shapefile source leads and retained 2012 county map availability evidence","official 2024 county precinct-audit source lead","official historical result/statistical-report replacement leads"],"missingFields":["normalized ballot-method package for the public vote-method API/UI","complete election-effective 2012 statewide precinct boundary geometry","normalized post-election audit selection/outcome rows","normalized recount, CVR availability, incident, correction, and litigation artifacts","official historical baseline parser replacing secondary contextual rows"],"parserStatus":"iowaClarityCountyDetailXmlDirectory remains loaded for 2024 results, review, and precinct turnout. The precinct GIS pipeline now deterministically normalizes all four official presidential result universes, reviews 2016/2020/2024 geometry and crosswalks, and keeps 2012 geometry blocked. Detail XML VoteType, precinct-audit, and broader historical county-baseline replacement work remain separate.","manualReviewBurden":"low","confidence":"loaded","caveats":"U.S. House is district-based, so review rows remain advisory. The official detail XML includes candidate VoteType splits such as Election Day and Absentee, but the public vote-method contract does not yet load Iowa Clarity method rows. The 2016 map uses official LSA/SOS geometry; 2020 uses explicitly attributed VEST CC BY 4.0 geometry; 2024 uses the attributed New York Times official-boundary compilation under non-commercial terms. Complete official 2012 result rows are retained, but no complete election-effective statewide 2012 polygon set was found, and later boundaries are not backcast. The 2024 precinct-audit image is identified but not normalized. Historical county baseline rows remain secondary context until the separate official replacement work is complete.","nextAction":"Review and publish the guarded 2016, 2020, and 2024 immutable precinct package through the database and Blob gates. Continue the tracked no-email archive search for complete election-effective 2012 geometry without weakening the vintage rule. Vote-method, audit, recount, CVR, incident, correction, litigation, and county historical-baseline work remain separate tasks."},{"state":"ID","stateName":"Idaho","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county","exportFormats":["official Vote Idaho XML endpoints","official Vote Idaho map HTML widgets","official county turnout XLSX","official raw precinct turnout XLSX","retained EAC benchmark turnout CSV","Census county GeoJSON","Verified Voting equipment CSV","official 2012/2016 archive HTML","official 2020 county statistics HTML","historical baseline CSV"],"sourceUrls":["https://sos.idaho.gov/elections-division/election-results/","https://archive.voteidaho.gov/results/2024/general/xml.html","https://archive.voteidaho.gov/results/2024/general/presidential.html","https://archive.voteidaho.gov/results/2024/general/congressional.html","https://archive.voteidaho.gov/results/2024/general/turnout.html","https://canvass.sos.idaho.gov/","https://sos.idaho.gov/elections/data/results/2024/raw_stats_general.xlsx","https://sos.idaho.gov/elections/data/results/2024/turnout_county_general.xlsx","https://voteidaho.gov/data-and-dashboards/voter-turnout/","https://www.eac.gov/research-and-data/studies-and-reports","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/16","https://sos.idaho.gov/elections-division/2020-results-statistics/","https://archive.sos.idaho.gov/ELECT/results/2016/General/president_by_county.html","https://archive.sos.idaho.gov/ELECT/results/2012/General/cnty_USPres.htm"],"exampleUrls":["https://archive.voteidaho.gov/results/2024/general/xml.html","https://sos.idaho.gov/elections/data/results/2024/turnout_county_general.xlsx"],"availableFields":["official county presidential totals","official county U.S. House comparison rows","official state-native county turnout and total registered-voter denominator rows","official raw precinct turnout source lead","county geometry","county equipment context","official 2012, 2016, and 2020 historical source leads","official 2012/2016/2020 county historical presidential baselines"],"missingFields":["precinct/local reporting-unit President rows","same-grain precinct/local comparison contest rows","loaded precinct turnout rows joined to same-grain review rows","precinct boundary geometry or reporting-unit crosswalk","normalized official audit, CVR, incident, correction, recount, and litigation records"],"parserStatus":"nativeIdahoCountyPresidentCsv loaded from data/id-2024-general-president.csv and data/id-2024-general-us-house.csv; official state-native county turnout rows load from data/id-2024-general-turnout.csv generated by scripts/normalize-id-turnout.mjs; official 2012/2016/2020 county historical rows load from data/id-historical-presidential-baseline.csv generated by scripts/collect-id-historical-baseline.py; data/id-2024-data-coverage-inventory.json documents remaining official-source leads and gaps","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Current Idaho review rows are county-level President-versus-U.S.-House comparisons, not precinct scatter plots. U.S. House is district-based. Turnout now uses official Idaho SOS county turnout rows, while the official raw precinct turnout workbook remains a source lead until precinct/local President and comparison rows are loaded at the same grain. Historical baselines are official county-level context rows for 2012, 2016, and 2020. No normalized audit, CVR, incident, correction, recount, litigation, or precinct-geometry rows are loaded.","nextAction":"Use data/id-2024-data-coverage-inventory.json as the current ID source-search record; next steps are precinct/local result exports, same-grain precinct turnout use, precinct geometry/crosswalks, and official audit/CVR/incident/correction/recount/litigation source collection."},{"state":"IN","stateName":"Indiana","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county_plus_supplemental_precinct","exportFormats":["archived ENR JSON","official ENR public data shape inventory","official turnout PDF normalized CSV","supplemental MIT/OpenElections CSV","EAC fallback turnout CSV retained as benchmark","Verified Voting equipment CSV","official request matrix TSV","official records-request packet","official ENRHistorical AJAX table JSON","official county request-routing CSV"],"sourceUrls":["https://enr.indianavoters.in.gov/","https://www.in.gov/sos/elections/voter-information/files/2024-General-Election-Turnout-and-Registration-Report.pdf","https://www.in.gov/sos/elections/voter-information/register-to-vote/voter-registration-and-turnout-statistics/","https://www.in.gov/sos/elections/election-commission/election-results/","https://www.eac.gov/research-and-data/studies-and-reports","https://doi.org/10.7910/DVN/NYTPDU","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/18","https://www.in.gov/sos/elections/vstop/vstop-post-election-risk-limiting-audit-reports","https://www.in.gov/sos/elections/indiana-recount-commission/","https://indianavoters.in.gov/ENRHistorical/ElectionResults?year=2012","https://www.in.gov/sos/elections/files/StatewideCountsofPrecincts-and-PrecinctSplits.9.21.23new.pdf"],"exampleUrls":["https://web.archive.org/web/20241229230948id_/https://enr.indianavoters.in.gov/site/data/OffCatC_1019_A.json","https://www.in.gov/sos/elections/voter-information/files/2024-General-Election-Turnout-and-Registration-Report.pdf"],"availableFields":["official county President rows","official county U.S. Senate rows","official county registered-voter and voters-voting turnout rows","supplemental precinct President-versus-U.S.-Senate review rows","EAC county turnout fallback retained as benchmark","county election equipment context","official 2012, 2016, and 2020 county historical presidential baselines","official VSTOP post-election risk-limiting audit source path documented","official Recount Commission petition/order/minute source path documented","Indiana official-source request matrix maintained at data/in-2024-source-request-matrix.tsv","Indiana records-request packet maintained at data/source-records-request-packets/in-2024-precinct-results-request.md","official VSTOP 2024 General Election audit summary rows for seven counties","official ENR public app/data-path scan confirming no retained same-grain subcounty President/Senate export","machine-readable 92-county custodian routing tracker with official office/contact metadata and precinct/split counts"],"missingFields":["official precinct/precinct-split/subcounty President rows","official same-grain precinct/precinct-split/subcounty U.S. Senate comparison rows","precinct turnout and registered-voter denominator rows","precinct boundary geometry","detailed official VSTOP audit-unit selection/workpaper rows beyond the summary report","normalized official recount/contest/correction records","official CVR availability or request-produced CVR records","official incident and correction records"],"parserStatus":"indianaEnrCountyJson package loaded; official 2012/2016/2020 historicalPresidentialCsv loaded from ENRHistorical/AJAX and ENR archive sources; supplemental MIT/OpenElections precinct review rows loaded; scripts/normalize-in-audit-summary.mjs loads official VSTOP 2024 county audit-summary context rows; scripts/inspect-in-enr-public-data.mjs records the official ENR public data-path evidence that retained President/Senate files are county/locality-grain and JurR files have zero candidate containers; July 4, 2026 ordinary public-path checks returned HTTP 200 for settings, President, U.S. Senate, and turnout JSON but still identified no precinct/subcounty candidate export. scripts/build-in-request-routing.mjs emits data/in-2024-county-request-routing.csv and summary JSON for official county custodian follow-up; this tracker does not contain candidate result rows.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Archived ENR category files contain 92 county/locality RegionSummary rows for 2024, not precinct rows; data/in-2024-official-enr-public-data-inventory.json records that the public app download route exports turnout statistics only and no retained ENR JSON artifact exposes same-grain subcounty President/Senate candidate rows. The July 4, 2026 live public-path recheck confirmed the documented archive JSON paths are reachable but still county/result-statistics scoped. The current subcounty review rows are supplemental MIT/OpenElections context with upstream caveats, so Indiana should remain in source discovery until official same-grain precinct/subcounty President and U.S. Senate rows are obtained or the completion methodology changes. Historical baselines are official county context for 2012, 2016, and 2020; 2012 is collected from the current Indiana Voters ENRHistorical table endpoint, while 2016 and 2020 use ENR archive JSON.","nextAction":"Use data/in-2024-source-request-matrix.tsv, data/source-records-request-packets/in-2024-precinct-results-request.md, and data/in-2024-county-request-routing.csv to request official same-grain precinct/precinct-split 2024 President and U.S. Senate rows, precinct geometry/turnout if needed, detailed VSTOP audit workpapers, Recount Commission/CVR/incident records suitable for normalization."},{"state":"LA","stateName":"Louisiana","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct_vote_mode_and_parish","exportFormats":["Louisiana SOS static precinct CSV endpoints","Louisiana SOS human-readable XLSX workbook","Louisiana SOS post-election statistics XLS workbooks","normalized SOS parish turnout CSV","EAC benchmark turnout CSV","Census TIGERweb GeoJSON","Louisiana SOS historical 2016 and 2020 ByParish presidential CSV endpoints","normalized official 2016 and 2020 historical baseline CSV"],"sourceUrls":["https://voterportal.sos.la.gov/static/","https://voterportal.sos.la.gov/static/20241105/resultsRace/Presidential","https://s3-us-west-2.amazonaws.com/mediaresults.sos.la.gov/HumanReadableElectionResults/20241105/Election+Results+(11-05-2024).xlsx","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2722%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","https://voterportal.sos.la.gov/graphical","https://electionstatistics.sos.la.gov/data/Post_Election_Statistics/statewide/2024_1105_sta.xls","https://electionstatistics.sos.la.gov/data/Post_Election_Statistics/parish/2024_1105_par.xls","https://voterportal.sos.la.gov/static/20201103/resultsRace/Presidential","https://voterportal.sos.la.gov/static/20161108/resultsRace/Presidential"],"exampleUrls":["https://voterportal.sos.la.gov/static/20241105/resultsRace/Presidential"],"availableFields":["official parish presidential totals","official precinct and vote-mode President rows","official precinct and vote-mode U.S. House comparison rows where same-grain keys align","official SOS parish post-election qualified-voter and voted turnout rows","EAC benchmark turnout rows","official 2016 and 2020 parish presidential historical baseline rows","parish geometry","parish equipment context from Verified Voting Verifier","data/la-2024-data-coverage-inventory.json coverage inventory"],"missingFields":["precinct boundary geometry or precinct-to-parish crosswalks","normalized official audit, recount, CVR availability, incident, correction, and litigation rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"louisianaSosPrecinctCsvDirectory loads official parish President result rows and precinct/vote-mode President-versus-U.S.-House review rows; scripts/normalize-la-post-election-statistics.mjs generates active SOS parish turnout rows; scripts/normalize-la-historical-presidential-baseline.mjs loads official 2016 and 2020 parish historical presidential baselines; EAC is retained as a benchmark.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Louisiana uses parishes rather than counties. U.S. House is district-based and candidate-specific, so review rows are advisory source-review context, not same-office statewide comparison rows. Active turnout uses official SOS parish post-election statistics; EAC remains a benchmark only. Official 2016 and 2020 parish presidential historical baselines are loaded; official 2012 remains missing.","nextAction":"Collect precinct boundary geometry/crosswalks, an official 2012 historical baseline artifact, and normalized audit/CVR/incident/correction/recount/litigation records."},{"state":"ND","stateName":"North Dakota","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county_results_precinct_review","exportFormats":["official ResultsAjax JSON endpoint","official ASP.NET results dashboard","CSV/Excel/XML export form","HTML precinct turnout table","official archived canvass PDFs"],"sourceUrls":["https://results.sos.nd.gov/ResultsSW.aspx?text=Race&type=SW&map=CTY","https://resultsws.sos.nd.gov/ResultsAjax.svc/GetMapData?type=SW&category=CTY&raceID=19893&osn=100&county=0&party=0","https://results.sos.nd.gov/VoterTurnoutDetails.aspx","https://www.sos.nd.gov/elections/voter/voting-north-dakota","https://www.sos.nd.gov/elections/election-security/post-election-audits"],"exampleUrls":["https://resultsws.sos.nd.gov/ResultsAjax.svc/GetMapData?type=SW&category=CTY&raceID=19893&osn=100&county=0&party=0","https://resultsws.sos.nd.gov/ResultsAjax.svc/GetMapData?type=SW&category=PREC&raceID=19893&osn=100&county=01&party=0"],"availableFields":["official county President totals from SOS ResultsAjax JSON","official same-key precinct President rows from SOS ResultsAjax JSON","official same-key precinct U.S. Senate comparison rows from SOS ResultsAjax JSON","official precinct ballots-cast turnout table lead","official eligible-voter turnout denominator summary lead","county geometry","official 2020, 2016, and 2012 historical archive leads","county equipment context from Verified Voting and official SOS equipment description","official post-election audit policy and recount page source paths"],"missingFields":["state-native eligible-voter denominator parser and reconciliation to EAC fallback","precinct boundary geometry or result-to-precinct crosswalk","normalized historical baseline rows","normalized audit, CVR availability, incident, correction, recount, and litigation rows"],"parserStatus":"scripts/collect-nd-sos-results.mjs collects official SOS ResultsAjax JSON rows and writes countyPresidentCsv plus localComparisonCsv artifacts; active ND ETL now loads 53 county result rows, 383 same-key precinct President-versus-U.S.-Senate review rows, EAC fallback turnout, and county geometry","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"North Dakota does not require voter registration, so registered-voter denominator fields are not native turnout denominators. Active turnout remains EAC fallback with 371,974 ballots cast and 0 registered voters until the official SOS eligible-voter turnout lead of 371,975 voter turnout and 594,140 eligible voters is normalized and reconciled. Review rows are advisory source-review context only; precinct geometry/crosswalks, historical baselines, and normalized audit/CVR/recount/incident/correction/litigation rows remain missing.","nextAction":"Reconcile and normalize SOS eligible-voter turnout, collect precinct geometry/crosswalks and official 2012/2016/2020 historical baselines, then collect audit/CVR/recount/incident/correction/litigation artifacts."},{"state":"NM","stateName":"New Mexico","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county_precinct","exportFormats":["official SOS mapdata API JSON","official election results dashboard","turnout details table/export lead","GIS clearinghouse shapefiles lead","EAC fallback turnout CSV","official SOS Elections Database historical source portal","voter statistics archive OCR denominator lead"],"sourceUrls":["https://www.sos.nm.gov/sos-archive/election-results-archive/2024-election-results/","https://electionresults.sos.nm.gov/Default.aspx?eid=2882","https://electionresults.sos.nm.gov/ResultsMedia.aspx?eid=2882","https://electionresults.sos.nm.gov/VoterTurnoutDetails.aspx?eid=2882","https://www.sos.nm.gov/sos-archive/maps-archive/gis-voting-district-data-archive/","https://electionstats.sos.nm.gov/","https://www.sos.nm.gov/sos-archive/voter-statistics-data-archive/2024-voter-statistics-data/"],"exampleUrls":["https://electionresults.sos.nm.gov/resultsSW.aspx?eid=2882&map=CTY&type=FED","https://electionresults.sos.nm.gov/resultsSW.aspx?eid=2882&map=CTY&type=SW"],"availableFields":["official county President result rows loaded from SOS API","official precinct President rows loaded from SOS API for review","official precinct U.S. Senate same-grain comparison rows loaded from SOS API","EAC jurisdiction turnout fallback rows loaded","official 2020 and 2016 county historical presidential baselines loaded from SOS API","official SOS turnout details, GIS, audit, recount, voter-data, and IPRA request paths documented","official SOS Elections Database verified as historical/source-validation lead","official 2024 voter statistics archive identified as registration denominator OCR lead"],"missingFields":["state-native turnout rows reconciled with denominator timing","OCR-backed voter statistics denominator artifact reviewed and normalized","precinct boundary geometry or result-key crosswalk","official 2012 historical baseline rows","normalized audit, CVR availability, recount, incident, correction, litigation, custody, and tabulator-log rows"],"parserStatus":"etl/state-configs/nm.json now loads official NM SOS 2024 President county results, President-vs-U.S. Senate precinct review rows, EAC turnout fallback rows, and 2020/2016 official historical baselines through nativeNewMexicoSosMapDataJson.","manualReviewBurden":"medium","confidence":"loaded_with_caveats","caveats":"The official SOS API masks small counts with '*', so the parser infers masked values from SOS percentages. After inference and de-duplication, precinct President and U.S. Senate totals are each 7 votes below county-level official totals; advisory review rows are not evidence of fraud or misconduct. SOS turnout uses eligible voters while active EAC fallback uses registered voters. The 2024 SOS voter-statistics archive is an official denominator lead but is not active because a reviewed script-readable artifact was not identified and OCR/manual review may be required.","nextAction":"Review SOS turnout denominator semantics, collect/OCR a reviewed 2024 voter-statistics artifact if available, collect precinct geometry/crosswalk, normalize 2012 historical and admin-context artifacts, and QA website display after any explicit production promotion."},{"state":"NV","stateName":"Nevada","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct","exportFormats":["archived official statewide results","county totals","Clark County CVR zip","Washoe County CVR csv","Humboldt County CVR csv","normalized Clark/Washoe/Humboldt precinct review CSVs","county election pages","records-request path","county source request matrix TSV","non-Clark jurisdiction request packet JSON","official NVSOS 2012, 2016, 2020, and 2024 precinct result exports","official Clark County 2024 presidential Statement of Vote","official 2024 LCB precinct GeoJSON","VEST 2016 and 2020 election-specific shapefiles","normalized precinct GeoJSON, result, crosswalk, and validation artifacts"],"sourceUrls":["https://www.nvsos.gov/SOSelectionPages/results/2024StateWideGeneral/ElectionSummary.aspx","https://www.clarkcountynv.gov/government/departments/elections/reports_data_maps/index.php","https://elections.clarkcountynv.gov/electionresultsTV/cvr/24G/24G_CVRExport_NOV_Final_Confidential.zip","https://www.washoecounty.gov/voters/results/archivedresults.php","https://www.washoecounty.gov/voters/results/resultsfiles/2024generalcvr.csv","https://www.humboldtcountynv.gov/317/Elections","https://www.humboldtcountynv.gov/DocumentCenter/View/7893","https://www.nvsos.gov/sos/elections/voters/county-clerk-contact-information","https://www.nvsos.gov/silverstate2012gen/","https://election.lab.ufl.edu/dataset/nv-2016-precinct-level-election-results/","https://dataverse.harvard.edu/file.xhtml?fileId=4863168&version=21.0","https://services9.arcgis.com/UU5yXg9PV67U0ebq/arcgis/rest/services/2024_Precincts/FeatureServer/0","https://elections.clarkcountynv.gov/electionresultsTV/SOV/24G/PRESIDENT.txt"],"exampleUrls":[],"availableFields":["county President rows","county U.S. Senate rows","Clark County precinct President/Senate CVR review rows","Washoe County precinct President/Senate CVR review rows","Humboldt County precinct President/Senate CVR review rows","county equipment context","14-jurisdiction result/turnout/geometry/admin request matrix","14-jurisdiction operational request packets","2012 reviewed hybrid candidate geometry: 2,002 normalized features, 1,760 colorable presidential units, and five reviewed multipart precincts retained as single MultiPolygon features","2016 official statewide results joined to attributed VEST geometry: 2,067 features and 1,843 safely colorable units","2020 official statewide results joined to attributed VEST geometry: 2,094 features and 1,869 safely colorable units","2024 official LCB election-relevant geometry: 1,635 features and 1,576 displayable presidential units, including 58 Clark precincts with exact Statement-of-Vote totals and legally suppressed candidate detail"],"missingFields":["same-grain U.S. Senate/local review rows for 14 non-Clark/non-Washoe/non-Humboldt jurisdictions","state-native turnout denominator","election-date Washoe 2012 precinct archive needed to replace the labeled proxy partition","official 2012/2016/2020 historical baseline replacement for secondary context rows","post-election audit, L&A, tabulator-log, custody, incident/correction, recount, litigation, and remaining CVR availability artifacts"],"parserStatus":"scripts/collect-nv-precinct-geometry.mjs deterministically normalizes and hash-pins all four diagnostic years. The guarded release package selects only 2016, 2020, and 2024, builds 51 immutable county GeoJSON files plus three indexes, validates a blocked hidden load, and requires an atomic database publication before either public API opens. localComparisonCsv remains the separate President-versus-Senate advisory path; active turnout remains EAC fallback.","manualReviewBurden":"high","confidence":"loaded_with_caveats","caveats":"All four presidential precinct GIS years have reproducible normalized artifacts and reviewed relationship evidence. Only 2012 retains an external map-source gate because Washoe uses a labeled 2016 proxy; GitHub issue #220 tracks that archive. Its multipart relationships are normalized to one-to-one MultiPolygon features. For 2016 and 2020, all displayed votes come from official NVSOS statewide precinct exports while VEST supplies clearly attributed election-specific CC BY 4.0 geometry only. The exact 2020 version-21 terms are retained. For 2024, every retained Clark election-reporting polygon has official result evidence: 852 complete candidate rows and 58 exact county Statement-of-Vote totals (164 combined) whose candidate allocation remains legally suppressed. Ninety-one raw LCB Clark shapes absent from both official result universes are audited and excluded rather than shown as missing-result precincts; 59 reviewed no-data polygons remain outside Clark. The source-ready years have immutable delivery and fail-closed release tooling, but production loading, Blob upload, deployment verification, and database publication remain explicit operations. These gaps are source limitations, not evidence of misconduct.","nextAction":"Review and merge the guarded 2016/2020/2024 release implementation, then execute its separately authorized production sequence. Continue public/archive discovery for issue #220 without substituting the later Washoe proxy, and continue collecting same-grain U.S. Senate review rows and state-native turnout separately."},{"state":"UT","stateName":"Utah","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"county","exportFormats":["official electionresults API JSON","official canvass PDF text layer","normalized CSV","official standardized canvass workbook","county GeoJSON"],"sourceUrls":["https://vote.utah.gov/election-results/","https://vote.utah.gov/2024-election-information/","https://vote.utah.gov/wp-content/uploads/2025/02/2024-General-Election-Statewide-Canvass-2.pdf","https://vote.utah.gov/wp-content/uploads/2025/12/Master-Aggregated-Numbers-2023-2025.xlsx","https://electionresults.utah.gov/results/public/api/elections/utah/general11052024/ballot-items/88e40000-968a-0c37-b0b0-08dce9374078"],"exampleUrls":["https://vote.utah.gov/wp-content/uploads/2025/02/2024-General-Election-Statewide-Canvass-2.pdf","https://vote.utah.gov/wp-content/uploads/2025/12/Master-Aggregated-Numbers-2023-2025.xlsx","https://electionresults.utah.gov/results/public/api/elections/utah/general11052024/ballot-items/88e40000-968a-0c37-b0b0-08dce9374078"],"availableFields":["official county presidential API rows including qualified write-ins","county Attorney General comparison rows","state-native county turnout and active-voter denominator","county geometry","secondary 2012/2016/2020 historical baseline rows"],"missingFields":["precinct/local reporting-unit rows","precinct boundary geometry or crosswalks","official normalized 2012/2016/2020 historical baselines","normalized audit/CVR/incident/correction/recount/litigation rows"],"parserStatus":"county President rows load from the official electionresults.utah.gov API; Attorney General comparison, turnout, and historical rows load through scripts/normalize-ut-official-results.mjs artifacts and the generic countyPresidentCsv dispatcher.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The official electionresults API resolves the 1,488,494-vote presidential contest total at county grain, including qualified write-ins. Review rows are county-level President-versus-Attorney-General comparisons, not precinct scatter plots. Official precinct/local rows, precinct geometry, official historical baselines, and normalized audit/CVR/incident/correction/recount/litigation rows remain unloaded.","nextAction":"Collect precinct/local reporting-unit rows, precinct geometry/crosswalks, official historical baselines, and normalized audit/CVR/incident/correction/litigation records."},{"state":"VT","stateName":"Vermont","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_turnout_geometry_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"town_or_reporting_district","exportFormats":["official SOS static JSON","official SOS canvass PDF","official SOS turnout PDF","official recount XLSX","EAC fallback turnout","official SOS 2020 archive CSV export","official Election Results Archive municipality CSV downloads"],"sourceUrls":["https://sos.vermont.gov/elections/election-info-resources/elections-results-data/","https://static.electionresults.vermont.gov/elections/elections.json","https://electionarchive.vermont.gov/","https://electionarchive.vermont.gov/elections/view/144513/","https://electionarchive.vermont.gov/elections/download/144513/precincts_include:0/","https://electionarchive.vermont.gov/elections/download/82048/precincts_include:0/"],"exampleUrls":["https://static.electionresults.vermont.gov/elections/67a35c79-05a2-4ae3-a77d-97812256188b.json","https://static.electionresults.vermont.gov/elections/67a35c79-05a2-4ae3-a77d-97812256188b-f-20260611153112.json","https://static.electionresults.vermont.gov/elections/67a35c79-05a2-4ae3-a77d-97812256188b-turnout-20260611153112.json","https://outside.vermont.gov/dept/sos/Elections_Division/election_info_resources/elections_results_data/2024_general_election_official_report_canvassing_committee_united_states_vermont_statewide_offices.pdf","https://outside.vermont.gov/dept/sos/Elections_Division/election_info_resources/elections_results_data/2024_general_election_voter_turnout.pdf"],"availableFields":["official county presidential rows aggregated from SOS static JSON and reconciled to certified canvass totals","official town/reporting-district President rows","official same-grain U.S. Senate comparison rows","official turnout JSON/PDF lead","certified canvass PDF retained as source-of-record reconciliation artifact","county geometry","equipment context","official 2016 and 2020 county presidential historical baseline rows aggregated from SOS municipality exports with county:<GEOID> tags"],"missingFields":["state-native turnout importer replacing EAC fallback","town/reporting-district geometry and crosswalk for subcounty maps","normalized audit, recount, CVR, incident, correction, and litigation rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"nativeVermontStaticElectionJson loads 14 county President rows and 283 town/reporting-district President-versus-U.S.-Senate review rows from official SOS static JSON after excluding the duplicated STATE WIDE summary row and reconciling to certified canvass totals; active turnout remains EAC fallback.; scripts/normalize-vt-historical-presidential-baseline.mjs loads official 2016/2020 archive CSV baselines.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"County result and town/reporting-district review rows are active and source-reconciled. U.S. Senate includes a major independent candidate, so dropoff fields are directional source-review inputs only. Active turnout remains EAC fallback because SOS JSON, SOS canvass cover-page, and EAC registered-voter totals differ. Official 2016 and 2020 county historical baselines are loaded; town/reporting-district geometry, official 2012 baselines, and normalized administration-context rows remain missing.","nextAction":"Resolve SOS turnout denominator timing before replacing EAC fallback; collect town/reporting-district geometry, the official 2012 county historical baseline, and normalized audit/CVR/recount/incident/correction/litigation context."},{"state":"WV","stateName":"West Virginia","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_2_official_dashboard_endpoint","reportingGrain":"precinct","exportFormats":["detail XML ZIP"],"sourceUrls":["https://results.enr.clarityelections.com/WV/","https://sos.wv.gov/elections/Pages/ElectionSecurity.aspx","https://sos.wv.gov/elections/Pages/HistElecResults.aspx","https://sos.wv.gov/elections/Pages/Guidance.aspx","https://sos.wv.gov/about/Pages/FOIAReq.aspx","https://sos.wv.gov/west-virginia-county-clerk-directory"],"exampleUrls":[],"availableFields":["county results","precinct President rows","precinct U.S. Senate rows","precinct turnout rows","county equipment context","official SOS canvass/recount/complaint/FOIA/voter-data request paths documented in data/wv-2024-data-coverage-inventory.json","official historical results source leads for 2020 and 2008-2017"],"missingFields":["official statewide precinct boundary geometry","normalized 2024 post-election audit selection/outcome artifacts","normalized CVR availability rows","incident, correction, recount, and litigation records"],"parserStatus":"westVirginiaClarityCountyDetailXmlDirectory loaded for results/review/turnout; Verified Voting county equipment context loaded; data/wv-2024-data-coverage-inventory.json documents official geometry, audit, CVR, recount, incident/correction, litigation, and historical-source request paths","manualReviewBurden":"low","confidence":"loaded","caveats":"Rows are advisory review inputs, not confirmed findings. Equipment context is jurisdiction-level metadata only. County map geometry is loaded; no official statewide precinct boundary geometry package was identified in this pass. The Wave 9 inventory documents official request/source paths only; no audit outcome, CVR, incident, correction, recount, litigation, or historical baseline rows are loaded.","nextAction":"Request official statewide precinct boundary geometry or county precinct crosswalks, then request and normalize 2024 hand-count audit selections/outcomes, CVR availability responses, recount/correction/incident/litigation records, and official 2012/2016/2020 historical baseline artifacts."},{"state":"TX","stateName":"Texas","jurisdictionName":"Statewide open data project","scope":"statewide","dataFamily":"results_review_turnout","tier":"tier_3_sanctioned_bulk_partial","reportingGrain":"precinct","exportFormats":["compressed CSV ZIP","VTD returns CSV","VTD VRTO CSV","official ESRI Shapefile ZIP","parent-scoped GeoJSON release candidate"],"sourceUrls":["https://data.capitol.texas.gov/topic/elections"],"exampleUrls":["https://data.capitol.texas.gov/dataset/35b16aee-0bb0-4866-b1ec-859f1f044241/resource/e1cd6332-6a7a-4c78-ad2a-852268f6c7a2/download/2024-general-vtds-election-data.zip"],"availableFields":["certified county President rows from Texas SOS County.json","VTD President rows","VTD U.S. Senate comparison rows","VTD registered-voter and turnout rows","VTD reconciliation summary for certified county versus VTD presidential scope","election-specific 2012, 2016, 2020, and 2024 VTD geometry","36,762 reviewed one-to-one official result/geometry relationships across 254 counties per election"],"missingFields":["ballot method fields","source-side explanation for generic VTD write-in rows versus named certified write-in candidates","guarded production hidden load, immutable delivery publication, and public activation"],"parserStatus":"texasCountyJsonVtdReview remains the certified-county/native-review path. Four deterministic TLC collectors, scripts/lib/tx-precinct-gis-plan.mjs, the loopback-only database loader, and the content-addressed parent-delivery builder now validate 36,762 VTD reporting units and 110,286 grouped presidential result rows for 2012, 2016, 2020, and 2024.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The TLC VTD layers are census-geographic precinct approximations and must retain that label. The 2024 VTD presidential rows aggregate to 11,404,528 votes, 15,854 above the SOS County.json certified-result package total of 11,388,674; the documented primary scope difference is 24,730 generic VTD Write-In votes versus 8,569 SOS named declared write-in votes. TLC VTD rows never replace certified SOS county/state totals, and no conclusion about vote tabulation or election conduct follows from this source-scope difference.","nextAction":"Merge and deploy the guarded Texas release tooling, then complete the hash-pinned production hidden load, immutable Blob publication, protected-preview verification, and database publication cutover."},{"state":"TX","stateName":"Texas","jurisdictionName":"Harris County","scope":"county","dataFamily":"local_results","tier":"tier_4_local_scattershot","reportingGrain":"precinct","exportFormats":["county website navigation","local result pages"],"sourceUrls":["https://www.harrisvotes.com/Election-Results"],"exampleUrls":["https://www.harrisvotes.com/Election-Results"],"availableFields":["local county election results"],"missingFields":["statewide coverage","registration denominator source","consistent navigation across counties"],"parserStatus":"example local source only; parser not implemented","manualReviewBurden":"high","confidence":"candidate","caveats":"Useful only as one local override; statewide Texas requires many jurisdictions or a better statewide source.","nextAction":"Use only if Texas statewide sources cannot provide required precinct rows."},{"state":"AK","stateName":"Alaska","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_equipment_admin_context","tier":"tier_5_digital_inconsistent","reportingGrain":"statewide_result_with_precinct_reporting_unit_review","exportFormats":["official summary PDF text layer","official ENR precinct CSV","normalized statewide CSV","normalized precinct/reporting-unit review CSV","EAC fallback turnout CSV","state House District GeoJSON","official results page evidence","ENR turnout field semantics JSON","official source request packet JSON","current Census county-equivalent GeoJSON"],"sourceUrls":["https://www.elections.alaska.gov/election-results/","https://www.elections.alaska.gov/election-results/e/?id=24genr","https://www.elections.alaska.gov/results/24GENR/ElectionSummaryReport.pdf","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/Legislative/MapServer/2/query?where=STATE%3D%2702%27&outFields=GEOID,STATE,SLDL,NAME,BASENAME&returnGeometry=true&outSR=4326&f=geojson","https://www.elections.alaska.gov/results/24GENR/ENRbyPrecinct.csv","https://www.elections.alaska.gov/results/24GENR/RCV-USRep.pdf","https://www.elections.alaska.gov/results/24GENR/CVR_Export_20241130154411.zip","https://www.elections.alaska.gov/contact-us/","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2702%27&outFields=GEOID%2CSTATE%2CCOUNTY%2CNAME%2CBASENAME&returnGeometry=true&outSR=4326&f=geojson"],"exampleUrls":["https://www.elections.alaska.gov/results/24GENR/ElectionSummaryReport.pdf","https://www.elections.alaska.gov/results/24GENR/ENRbyPrecinct.csv"],"availableFields":["official statewide presidential totals","official statewide U.S. Representative first-choice comparison totals including write-ins","official 523-row precinct/reporting-unit President rows","official same-grain U.S. Representative named-candidate first-choice rows","EAC fallback statewide turnout matching the official summary Times Cast row","state House District geometry lead","state-level equipment context from Verified Voting","official CVR ZIP and RCV report URLs documented as follow-up context","ENR Reg_voters and total_ballots statewide reconciliation evidence matching EAC fallback and summary Times Cast totals","official request packet covering write-ins, geometry/crosswalk, turnout semantics, historical baselines, CVR, audit, recount, incident, correction, and litigation fields","all 30 current Census county-equivalent FIPS tags and geometry","reviewed election-specific precinct geometry and result relationships for 2012, 2016, 2020, and 2024, parent-scoped by Alaska House District","explicit non-geographic classification for every absentee, early-voting, questioned-ballot, federal-overseas, and administrative result bucket","official historical presidential result packages for 2012, 2016, and 2020 with exact statewide reconciliation"],"missingFields":["U.S. House write-in allocation by precinct/reporting unit or source confirmation of omission","state-native lower-grain turnout denominator rows reviewed for denominator timing","native/API promotion of the reviewed 2012/2016/2020 historical precinct packages","normalized official audit, recount, CVR availability, incident, correction, and litigation rows","exact county-equivalent presidential allocations for 2016, 2020, and 2024"],"parserStatus":"statewide President rows load from scripts/normalize-ak-election-summary.mjs; official ENRbyPrecinct.csv is retained and scripts/normalize-ak-enr-by-precinct.mjs generates 523 localComparisonCsv review rows with a 750-vote U.S. House write-in caveat; scripts/collect-ak-precinct-geometry.mjs deterministically builds reviewed 2012/2016/2020/2024 election-specific precinct geometry, official result universes, and explicit non-geographic relationships; guarded release tooling keeps those rows blocked until separate production authorization; active turnout remains EAC fallback pending source-side semantics","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"AK native staging still exposes the certified map result at statewide grain until the guarded precinct release is separately activated. The reviewed GIS packages map only geographic precincts; 483 four-election administrative units remain unpainted and their votes are retained solely for statewide reconciliation. The 2012 polygon source is a commit-pinned public mirror with no stated formal license. The 2024 ENR precinct CSV omits 750 U.S. House write-ins, so that comparison remains incomplete. No precinct is assigned to a borough or census area, and cross-election precinct comparability is not inferred.","nextAction":"Review and execute the guarded Alaska four-election production release; separately pursue county-equivalent totals or ballot-to-home-precinct mappings where county trend analysis is required."},{"state":"DE","stateName":"Delaware","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_5_digital_inconsistent","reportingGrain":"county_and_election_district","exportFormats":["official HTML report tables","official statewide CSV export","official 2020 HTML/CSV historical report","official AGP fixed-width text","EAC fallback turnout CSV","county GeoJSON","official 2016 raw statewide-office-by-county TXT","official 2020 report HTML","historicalPresidentialCsv"],"sourceUrls":["https://elections.delaware.gov/elections/election_archive.html","https://elections.delaware.gov/reports/GE2024.html","https://elections.delaware.gov/reports/GE2020.html","https://app.powerbigov.us/view?r=eyJrIjoiYmIwM2I3OWUtYjQxNC00YzYxLWEzY2MtY2MwMTIwMjg4NWFhIiwidCI6IjhjMDllNTY5LTUxYzUtNGRlZS1hYmIyLThiOTljMzJhNDM5NiJ9","https://elections.delaware.gov/voter/registrationtotals/reports/agprpt_2024.txt","https://elections.delaware.gov/maps/","https://elections.delaware.gov/public/foia/foia.html","https://elections.delaware.gov/elections/resultsarchive/elect16/elect16_general/data/stwoff_kns.txt"],"exampleUrls":["https://elections.delaware.gov/voter/registrationtotals/pdfs/vrt_PP20241101.csv","https://de-firstmap-delaware.hub.arcgis.com/maps/delaware::election-districts-1"],"availableFields":["official county presidential totals","official election-district President rows","official election-district U.S. Senate comparison rows","EAC fallback turnout rows","DOE AGP state-native registered/voted reconciliation lead","county geometry","supplemental county equipment context","official 2016 and 2020 county presidential historical baseline rows with county:<GEOID> tags"],"missingFields":["active state-native turnout replacement","election-district boundary geometry and result-label crosswalk","normalized audit, recount, CVR availability, incident, correction, litigation, custody, and tabulator-log rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"delawareOfficialReportHtml parser loaded; scripts/normalize-de-historical-presidential-baseline.py loads official 2016 and 2020 historicalPresidentialCsv rows","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Official 2024 report rows and official 2016/2020 historical baselines are loaded. EAC turnout remains active pending DOE AGP semantics review; official 2012 historical baseline rows and election-district geometry/crosswalks remain follow-up work.","nextAction":"Collect official 2012 county presidential baselines, election-district geometry/crosswalks, and audit/CVR/incident/recount/correction/litigation artifacts or request responses."},{"state":"SD","stateName":"South Dakota","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_equipment_admin_context","tier":"tier_5_digital_inconsistent","reportingGrain":"county_and_local_reporting_unit","exportFormats":["official results app CSV/media pages for current election","official archive service evidence for 2024 General ElectionID 684","official ElectionID 684 President and U.S. House local ResultsAjax payloads with 691 shared reporting-unit keys","official ElectionID 684 statewide XLSX export evidence","official 2024 General Election State Canvass and Certificate PDF with deterministic county reconciliation","official 2024 General Election Returns and Registration Figures PDF plus normalized active-voter turnout CSV","official 2012, 2016, and 2020 county presidential PDFs plus deterministic normalized historical CSV","four official 2024 county-canvass bundles with certificate sections for 64 distinct counties","official 2024 polling-location PDF without boundary geometry","secondary county tables","EAC fallback turnout","county GeoJSON","official remaining-native-source request packet JSON","official post-election audit page summary"],"sourceUrls":["https://sdsos.gov/elections-voting/election-resources/election-results/default.aspx","https://electionresults.sd.gov/ResultsMedia.aspx","https://electionresults.sd.gov/ResultsExport.aspx?","https://electionresults.sd.gov/ResultsExport.aspx?eid=684","https://sd-fbfzg0h4abdgeyaz.a01.azurefd.net/ResultsAjax.svc?singleWsdl","https://www.eac.gov/research-and-data/studies-and-reports","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetCandidates?ElectionType=General&ElectionID=684","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetMapDataArchive?Type=SWR&Category=CTY&RaceID=0&OSN=0&County=0&Party=0&ElectionID=684","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetMapDataArchive?Type=SWR&Category=PREC&RaceID=12665&OSN=0&County=0&Party=0&ElectionID=684","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetMapDataArchive?Type=SWR&Category=PREC&RaceID=11954&OSN=0&County=0&Party=0&ElectionID=684","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetVoterTurnoutArchive?ElectionID=684","https://web.archive.org/web/20241105222716/https://electionresults.sd.gov/","https://electionresults.sd.gov/ElectionTerminology.aspx?eid=684","https://sdsos.gov/elections-voting/assets/Archive/2024%20Assets/Recount-Canvass-and-Canvass-Docs-General/2024GeneralElectionCanvassWithCert.pdf","https://sdsos.gov/elections-voting/assets/Archive/2024%20Assets/Post-Election-Audit-General/ElectionReturns2024.pdf","https://sdsos.gov/elections-voting/election-resources/election-history/2024_Election_History.aspx","https://sdsos.gov/elections-voting/assets/Archive/2024%20Assets/2024GeneralPollingLocation.pdf","https://sdsos.gov/elections-voting/assets/Archive/2012%20Assets/2012generalelectionstatewidecandidatesbycounty.pdf","https://sdsos.gov/elections-voting/assets/Archive/Prior%20to%202026/ElectionReturns2016_Web.pdf","https://sdsos.gov/elections-voting/assets/Archive/2020%20Assests/2020GeneralStateCanvassFinal%26Certificate.pdf","https://sdsos.gov/elections-voting/upcoming-elections/general-information/2024/2024-general-postelection-audit-results.aspx","https://www.sd.gov/cs?id=sc_cat_item&sys_id=f7f939eddbd4b150b2fb93d4f39619c0"],"exampleUrls":["https://en.wikipedia.org/wiki/2024_United_States_presidential_election_in_South_Dakota","https://en.wikipedia.org/wiki/2024_United_States_House_of_Representatives_election_in_South_Dakota","https://sdresws.azurewebsites.net/ResultsAjax.svc/GetMapDataArchive?Type=SWR&Category=CTY&RaceID=0&OSN=0&County=0&Party=0&ElectionID=684","https://electionresults.sd.gov/ResultsExport.aspx?eid=684"],"availableFields":["secondary county presidential rows citing the SD SOS 2024 General Election Canvass and Certificate","secondary county U.S. House comparison rows citing the same canvass","official SD SOS archive evidence identifying 2024 General ElectionID 684, President map RaceID 12665, and U.S. House map RaceID 11954","complete official-source unofficial President-versus-U.S.-House review context for 691 CountyID-plus-StatePrecinctID units across 66 counties","official SD SOS archive turnout comparison for 66 counties from ElectionID 684","official Election Returns and Registration Figures table with 66 counties, 624,175 active voters as of November 5, 2024, and 436,478 ballots cast","official SD SOS ElectionID 684 statewide XLSX export retained from ResultsExport.aspx?eid=684, labeled 2024 Unofficial General Election Results","official State Board of Canvassers 2024 General Election Canvass and Certificate PDF, hash-pinned and exactly reconciling 66 county President and U.S. House rows","EAC fallback turnout rows","county geometry","198 official 2012/2016/2020 county presidential baseline rows normalized from three hash-pinned Secretary of State PDFs","published county canvass certificate sections for 64 distinct counties; Buffalo and Stanley are absent and Brule is duplicated across the bundles","official polling-place names and addresses without polygons or stable result-unit IDs","supplemental county equipment context from Verified Voting Verifier","official results FAQ text confirming Election Night app results are unofficial and certified results are published through SOS Elections after county/state canvass certification","official 2024 General post-election audit page summary with 66 county rows, 83 linked audit certificates, and 14 counties with discrepancy summary text","official remaining-source request packet with SOS public-records and county-auditor request targets"],"missingFields":["Buffalo and Stanley certified 2024 local county-canvass tables","authoritative crosswalk from certified-table precinct names to ElectionID 684 CountyID/StatePrecinctID units","election-effective 2024 precinct boundary geometry or reviewed feature crosswalk","normalized official audit certificate rows beyond the retained audit-page summary, plus recount, CVR availability, incident, correction, and litigation rows"],"parserStatus":"countyPresidentCsv loads generated county rows exactly validated by scripts/verify_sd_2024_general_canvass.py against the official State Board certificate. localComparisonCsv loads 691 same-key unofficial ElectionID 684 President-versus-U.S.-House review rows with deterministic certified-delta reconciliation. normalizedTurnoutCsv loads the official 66-county active-voter table from scripts/normalize_sd_2024_official_turnout.py; EAC remains fallback provenance. scripts/normalize_sd_historical_presidential_baseline.py loads and hash-pins 198 official county historical rows for 2012, 2016, and 2020.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"South Dakota is not completed official-native local coverage. The official certificate exactly validates current county candidate rows, but those CSVs retain secondary extraction lineage and no direct certificate-table ingestion is active. The 691 local review rows come from an official application labeled unofficial and remain 194 President votes and 184 U.S. House votes below the certified canvass; no certified deltas are allocated locally and 59 C-prefixed administrative units are not treated as polygon precincts. The SOS-published bundles contain county canvass certificate sections for 64 counties but omit Buffalo and Stanley; their local-result pages expose names rather than ElectionID 684 unit IDs. The polling-location PDF contains no polygons. Turnout uses an official Election Day active-voter denominator, not all registered voters. Official historical county baselines are now loaded.","nextAction":"Request the missing Buffalo and Stanley county canvasses and an authoritative certified-table-name-to-ElectionID-684 crosswalk with election-effective 2024 precinct geometry. Normalize administration context separately. A direct certificate-table county parser remains optional if it improves maintainability."},{"state":"AZ","stateName":"Arizona","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"county_current_and_historical_review","exportFormats":["signed canvass PDF","official detailed XML ZIP","normalized CSV","normalized local artifact","script-blocked county result pages"],"sourceUrls":["https://azsos.gov/elections/election-information/2024-election-info","https://azsos.gov/elections/results-data","https://apps.azsos.gov/election/2016/General/Official%20Signed%20State%20Canvass.pdf","https://apps.azsos.gov/election/2020/resultsdetail_2020generalxml.zip","https://azsos.gov/elections/election-information/2024-election-information/litigation-info","https://azsos.nextrequest.com/","https://azsos.gov/elections/about-elections/county-election-officials-contact-information"],"exampleUrls":["https://apps.azsos.gov/election/2024/ge/canvass/20241105_GeneralCanvass_Signed.pdf","https://apps.azsos.gov/election/2024/ge/LD2_RECOUNT_Maricopa_County_HC_Audit_Report_NOV2024_FINAL.pdf"],"availableFields":["county President versus U.S. Senate rows","county turnout","state-native county turnout denominators from signed canvass","secondary 2012/2016/2020 county presidential baselines for context","official 2016 and 2020 county President-versus-U.S.-Senate historical advisory rows: 15 canonical county rows per year","retained historical advisory reconciliation with source hashes, statewide totals, and PDF visual QA","official county hand-count audit status summary and document links","Maricopa recount and statewide litigation source paths","SOS public-records portal and county election-office request paths"],"missingFields":["precinct review rows","precinct boundary geometry","statewide precinct/local reporting-unit export","same-grain precinct U.S. Senate rows","reviewed official replacement for secondary 2012/2016 historical baseline other-vote semantics","normalized CVR, ballot-image, tabulator-log, L&A, custody, audit-unit, incident, correction, recount, and litigation rows"],"parserStatus":"native county review package loaded; scripts/normalize_az_historical_review.py deterministically generates 30 historicalReviewCsv county rows from the official 2016 signed canvass PDF and 2020 detailed XML ZIP, with exact statewide reconciliation and reviewed PDF text-layer corrections; AZ admin/source inventory documents hand-count, recount/litigation, and records-request paths without normalizing electronic evidence rows","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Current and historical review rows are county-level advisory inputs, not precinct scatter plots. The official historical package contains 15 canonical county President-versus-U.S.-Senate rows per year. In 2016, President reconciles to 1,161,167 Democratic, 1,252,401 Republican, 159,597 other, and 2,573,165 total votes; U.S. Senate reconciles to 1,031,245 Democratic, 1,359,267 Republican, 140,218 other, and 2,530,730 total votes. In 2020, President reconciles to 1,672,143 Democratic, 1,661,686 Republican, 53,497 other, and 3,387,326 total votes; U.S. Senate reconciles to 1,716,467 Democratic, 1,637,661 Republican, 1,189 other, and 3,355,317 total votes. The 2016 PDF parser records 38 printed one-vote cells absent from the text layer as reviewed fail-closed corrections, and every candidate row reconciles to the printed statewide total. The secondary contextual 2016 presidential baseline totals 31,492 votes more than the official candidate-row sum, entirely in unresolved other-vote semantics, so the two totals must not be silently combined or substituted. The 2026-07-01 AZ coverage inventory records official SOS hand-count status summaries, county canvass links, Maricopa recount/litigation links, and records-request paths, but no official statewide precinct/local President plus same-grain U.S. Senate export or normalized CVR/log/custody/audit-unit rows are loaded. Advisory indicators are review signals only, not findings of fraud or misconduct.","nextAction":"Use data/az-2024-admin-source-inventory.json and data/az-2024-data-coverage-inventory.json as the current AZ source-search records; next steps are county-by-county collection or records requests for precinct/local President and U.S. Senate rows, precinct geometry/crosswalks, CVR/ballot-image/log/L&A/custody records, detailed audit/recount/incident/correction rows, and a reviewed official replacement for the secondary historical-baseline other-vote semantics."},{"state":"KY","stateName":"Kentucky","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_equipment_admin_inventory","tier":"tier_6_official_pdf_hostile","reportingGrain":"precinct","exportFormats":["official county recap PDFs","extracted text","official historical PDF results","EAC turnout fallback","official turnout and registration PDF leads"],"sourceUrls":["https://elect.ky.gov/results/Pages/default.aspx","https://elect.ky.gov/results/2020-2029/Pages/2024General-Recap-Sheets.aspx","https://elect.ky.gov/Resources/Pages/Turnout.aspx","https://elect.ky.gov/Resources/Pages/Registration-Statistics.aspx","https://elect.ky.gov/Resources/Pages/Voting-Systems.aspx","https://elect.ky.gov/About-Us/Pages/County-Clerks.aspx","https://www.eac.gov/research-and-data/studies-and-reports","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/21"],"exampleUrls":["https://elect.ky.gov/results/Pages/default.aspx"],"availableFields":["precinct President rows","precinct U.S. House comparison rows for most counties","county EAC turnout fallback rows","candidate State Board 2024 general turnout rows by county and precinct","candidate State Board 2024 general registration denominator rows by county and precinct","2012/2016/2020 official county presidential historical baselines","county equipment context","county turnout/registration reconciliation report"],"missingFields":["six counties have county-only/no precinct-review rows from extracted recap text","county-clerk official turnout documentation and intentional active-turnout replacement review","precinct boundary geometry or result-to-geometry crosswalk","normalized audit/recount/CVR/incident/correction/litigation artifacts"],"parserStatus":"kentuckyGeneralRecapTextDirectory loaded with Elliott manual transcription; historicalPresidentialCsv loaded from official 2012/2016/2020 Kentucky result PDFs; scripts/reconcile-ky-turnout-registration.mjs now generates a county State Board turnout/registration versus EAC fallback reconciliation, but EAC remains active.","manualReviewBurden":"high","confidence":"loaded_with_caveat","caveats":"County recap PDFs are official, but some text extraction is image-only or county-only. Elliott County uses manual transcription from rendered official PDF pages. Historical baseline rows are official county context only. Turnout uses EAC fallback; the generated State Board county reconciliation is candidate provenance only because the State Board warns turnout reports are unofficial and can differ after rolls reopen.","nextAction":"Review county-clerk official turnout documentation before any active turnout replacement, build a precinct turnout/registration parser with reporting-unit crosswalk, collect precinct boundary geometry or a reporting-unit crosswalk, and request/normalize audit/recount/CVR/incident/correction/litigation artifacts from the State Board, county clerks, county boards, or court/board dockets."},{"state":"MO","stateName":"Missouri","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_equipment_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"county","exportFormats":["official PDF"],"sourceUrls":["https://www.sos.mo.gov/elections/results","https://www.sos.mo.gov/elections/goVoteMissouri/localelectionauthority"],"exampleUrls":["https://www.sos.mo.gov/CMSImages/ElectionResultsStatistics/2024GeneralElection.pdf"],"availableFields":["canonical county President rows","canonical county U.S. Senate comparison rows","state-native registered-voter turnout denominators","2012/2016/2020 official canonical county presidential historical baselines","Verified Voting equipment context","official administration-source inventory for audit, CVR availability, incident/correction, recount, litigation, and qualified-system context"],"missingFields":["official purchasable precinct-level President rows","official purchasable precinct-level U.S. Senate rows","precinct boundary geometry","normalized 2024 post-election audit selection/outcome artifacts","county-by-county CVR availability records","normalized incident/correction/recount/litigation rows"],"parserStatus":"scripts/normalize-mo-sos-pdfs.mjs retains official 116-authority source rows and emits 115 canonical county FIPS rows for President, Senate, turnout, and each historical year; Jackson County combines Kansas City-within-Jackson and Jackson-outside-Kansas-City with zero statewide delta.","manualReviewBurden":"medium","confidence":"loaded_with_blocker","caveats":"The official SOS authority list establishes that the Kansas City row is within Jackson County. Canonical outputs aggregate it to county:29095. Review rows remain county-level rather than precinct-level; the 2016 visible-column caveat remains.","nextAction":"Use data/mo-2024-source-request-tracker.json to purchase or request Missouri SOS precinct-level general election files for 2024 President and U.S. Senate, then add precinct geometry and collect/normalize 2024 audit certificates, CVR availability rows, incidents, corrections, recounts, and litigation records."},{"state":"NE","stateName":"Nebraska","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_equipment","tier":"tier_6_official_pdf_hostile","reportingGrain":"county","exportFormats":["official canvass PDF","official registration PDF","normalized CSV","county GeoJSON","district map PDFs and GIS shapefile ZIPs","voter-file request form","county election office directory","equipment API JSON"],"sourceUrls":["https://sos.nebraska.gov/previous-elections","https://sos.nebraska.gov/sites/default/files/doc/elections/2024/2024%20General%20Canvass%20Book.pdf","https://sos.nebraska.gov/elections/voter-registration-statistics","https://sos.nebraska.gov/sites/default/files/doc/elections/vrstats/2024VR/Post-Election-Statewide-November-2024.pdf","https://sos.nebraska.gov/elections/district-subdivision-maps","https://sos.nebraska.gov/elections/voter-file-requests","https://sos.nebraska.gov/elections-division","https://sos.nebraska.gov/election-officials-contact-information","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/31"],"exampleUrls":[],"availableFields":["county President rows","county U.S. Senate two-year special rows","EAC fallback turnout rows","Nebraska canvass county registered-voter and total-voting-by-method tables","Nebraska post-general eligible-voter registration denominator report","county Census TIGER geometry","district/subdivision map PDFs and district GIS shapefiles","voter-file request path with precinct, polling place, district details, and voter history fields subject to statutory use restrictions","2012, 2016, and 2020 official county presidential canvass baselines","canvass Reported Problems section for Dawson, Gage, and Johnson county administration notes","county election-equipment context from supplemental Verified Voting source","Nebraska canvass voting-statistics reconciliation artifact"],"missingFields":["official public precinct/subcounty President result rows","official public precinct/subcounty U.S. Senate result rows","publishable precinct/subcounty boundary geometry or reporting-unit crosswalk","reviewed Nebraska canvass turnout replacement semantics before replacing EAC fallback turnout","official post-election audit selection and outcome artifacts","official recount package for 2024 contests if any were conducted","CVR availability statement or request path with county/state custody caveats","normalized incident, correction, and litigation records beyond the canvass Reported Problems section","official equipment source records from SOS or county election offices beyond supplemental Verified Voting context"],"parserStatus":"county canvass President-versus-U.S. Senate package loaded; official historical county baseline CSV generated by scripts/normalize-ne-historical-baseline.mjs; scripts/normalize-ne-canvass-voting-statistics.mjs generates a canvass/EAC turnout reconciliation showing matching registered voters and a 91-vote ballots/total-voting difference; EAC fallback turnout remains active pending review; precinct/subcounty parser still blocked pending source acquisition","manualReviewBurden":"medium_high","confidence":"loaded","caveats":"Current advisory review rows are county-level President-versus-U.S. Senate two-year special election inputs, not precinct/subcounty scatter plots. The generated canvass voting-statistics reconciliation documents 965,236 statewide Total Voting versus 965,145 EAC fallback ballots cast and no registered-voter denominator difference; active ETL turnout remains EAC fallback pending review. The SOS district GIS shapefiles are district boundaries, not precinct/reporting-unit geometry, and the voter-file request path is restricted and not publishable on the public site.","nextAction":"Review the generated Nebraska canvass voting-statistics reconciliation before replacing EAC fallback turnout; request or locate official Nebraska precinct/subcounty President and U.S. Senate rows plus publishable reporting-unit geometry/crosswalk; request official audit, recount, CVR, incident/correction/litigation, and equipment records from the SOS Elections Division or county election offices."},{"state":"NJ","stateName":"New Jersey","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_geometry_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"county_loaded_municipal_followup","exportFormats":["official statewide certified PDF","normalized official county CSVs","official county municipal result PDFs","official turnout PDFs","official county audit PDFs","county GeoJSON","municipal GIS source lead","EAC fallback benchmark CSV","official 2016 county President PDFs","official 2020 statewide President PDF","historicalPresidentialCsv"],"sourceUrls":["https://www.nj.gov/state/elections/election-information-2024.shtml","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-president.pdf","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-us-senate.pdf","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-voter-turnout.pdf","https://njogis-newjersey.opendata.arcgis.com/datasets/municipal-boundaries-of-nj/about","https://www.nj.gov/state/elections/assets/pdf/election-results/2020/2020-official-general-results-president.pdf","https://www.nj.gov/state/elections/election-information-2016.shtml","https://www.nj.gov/state/elections/assets/pdf/election-results/2016/2016-official-general-results-president-1206b.pdf"],"exampleUrls":["https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-president-atlantic.pdf","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-results-us-senate-atlantic.pdf","https://www.nj.gov/state/elections/assets/pdf/election-results/2024/2024-official-general-result-ballotscast-atlantic.pdf"],"availableFields":["official certified county presidential totals from the DOE statewide PDF","official certified county U.S. Senate comparison totals from the DOE statewide PDF","official county turnout and registered-voter denominator rows from the DOE statewide turnout PDF","EAC fallback turnout retained as a benchmark reconciliation source","county geometry","county equipment context from Verified Voting and NJ DOE equipment inventory source lead","official county-by-county municipal President rows identified as follow-up source leads","official county-by-county municipal U.S. Senate comparison rows identified as follow-up source leads","official 2012/2016/2020 historical archive source leads","official 2024 county post-election audit PDF links and county-official request paths","official 2016 and 2020 county presidential historical baseline rows that resolve to canonical county:<GEOID> tags"],"missingFields":["loaded municipal President-versus-U.S.-Senate review rows","municipal boundary geometry and DOE-label crosswalk","normalized county post-election audit outcome rows","normalized CVR availability, incident, correction, recount, litigation, ballot-manifest, tabulator-log, and EMS-log rows","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"county-level DOE President, U.S. Senate, and turnout PDFs loaded by scripts/normalize-nj-doe-pdfs.mjs; official 2016 and 2020 historicalPresidentialCsv rows loaded by scripts/normalize-nj-historical-presidential-baseline.mjs","manualReviewBurden":"medium","confidence":"loaded_county_with_municipal_followup","caveats":"County-level 2024 rows and official 2016/2020 historical baselines are loaded from DOE PDFs. Municipal PDFs, municipal geometry/crosswalks, official 2012 historical baselines, audit/CVR/incident/recount/correction/litigation artifacts, and non-geographic row handling remain follow-up work.","nextAction":"Collect official 2012 county presidential baselines, municipal President/U.S. Senate/turnout PDF rows and geometry/crosswalks, plus audit/CVR/incident/recount/correction/litigation artifacts or request responses."},{"state":"NY","stateName":"New York","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_historical_equipment","tier":"tier_6_official_pdf_hostile","reportingGrain":"county","exportFormats":["official PDF","normalized CSV","EAC fallback turnout CSV","Verified Voting equipment context","NYSBOE enrollment report leads","NYSBOE Flateau/VEDA future local-data path","VEDA future results/download export readiness check","source request matrix TSV","missing county request packet JSON","Monroe County official canvass/certification packet follow-through PDFs","Wave 25 official-path evidence JSON"],"sourceUrls":["https://elections.ny.gov/election-results","https://results.elections.ny.gov/document/476","https://ny.elstats-staging.com/eng/files/serve/476","https://ny.elstats-staging.com/eng/files/serve/106","https://ny.elstats-staging.com/eng/files/serve/116","https://ny.elstats-staging.com/eng/files/serve/128","https://www.eac.gov/research-and-data/studies-and-reports","https://elections.ny.gov/enrollment-county","https://elections.ny.gov/enrollment-election-district","https://elections.ny.gov/flateau-database","https://flateau.elections.ny.gov/","https://flateau.elections.ny.gov/results","https://flateau.elections.ny.gov/downloads","https://elections.ny.gov/election-security","https://elections.ny.gov/freedom-information-law-foil-requests","https://publicreporting.elections.ny.gov/CountyBoardRoster/CountyBoardRoster","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/36","https://www.monroecounty.gov/elections-results","https://www.oswegocountyny.gov/government/board_of_elections/elections.php"],"exampleUrls":[],"availableFields":["2024 county President rows from official NYSBOE archive PDF","2024 county U.S. Senate comparison rows from the same official archive PDF","EAC 2024 county/jurisdiction turnout fallback rows","county geometry","2012/2016/2020 county presidential historical baselines from official NYSBOE PDFs","Verified Voting county equipment context","NYSBOE 11/01/2024 county enrollment report lead and election-district enrollment report lead","NYSBOE post-election audit, FOIL, county-board roster, and Flateau/VEDA request/publication paths documented in data/ny-2024-data-coverage-inventory.json","Wave 21 source request matrix for missing local review, turnout, geometry, administration-context artifacts, and VEDA export readiness","Wave 22/25 missing-county request packet JSON for the 12 remaining excluded county equivalents","Wave 23 Monroe County official canvass-book detail and November 26, 2024 certification PDFs retained as follow-through evidence only","Wave 25 official-path evidence artifact for the 12 remaining county equivalents, including an official Oswego County 2024 General PDF/Excel result lead not yet loaded"],"missingFields":["official precinct/local reporting-unit President rows from NYSBOE or county boards for counties still outside local review coverage","official same-grain precinct/local U.S. Senate comparison rows from NYSBOE or county boards for counties still outside local review coverage","state-native ballots-cast or voter-history artifact to pair with NYSBOE enrollment denominators before replacing EAC fallback","official CVR availability inventory","official audit/recount/correction/incident/litigation record package","precinct or election-district boundary geometry and result-label crosswalk"],"parserStatus":"countyPresidentCsv loaded with localComparisonCsv partial review rows, EAC turnout fallback, official PDF historical baseline, county equipment context, NY coverage inventory, Wave 21 source request matrix, Wave 22 county packets, Wave 24 Monroe official detail rows, and Wave 25 official-path evidence; official full-state precinct/election-district parser still needs a complete source package and crosswalk. VEDA/Flateau results and downloads are classified as future official export paths, currently empty for 2024 replacement purposes. Wave 25 found an official Oswego County 2024 General PDF/Excel result lead, but it is not collected, parsed, or reconciled yet.","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"Current certified results and historical baselines are official county-level rows. Local review rows are supplemental OpenElections county-board source normalizations and legacy NYC rows, not a complete official NYSBOE precinct package; 12 county equivalents remain outside normalized review coverage. EAC turnout fallback and Verified Voting equipment context remain advisory metadata. Monroe official detail rows are loaded after reconciliation, but this does not complete statewide local coverage. Wave 25 found an official Oswego County 2024 General PDF/Excel result lead, but no Oswego rows are loaded until ordinary collection, scripting, and reconciliation are complete.","nextAction":"Use data/ny-2024-data-coverage-inventory.json, data/ny-2024-source-request-matrix.tsv, data/ny-2024-missing-county-request-packets.json, and data/ny-2024-wave25-official-path-checks.json to collect or request official NYSBOE/county election-district President and U.S. Senate rows, starting with ordinary collection and reconciliation of the Oswego County 2024 General PDF/Excel lead; also collect ballots-cast/voter-history rows paired with enrollment denominators, CVR availability, audit/recount/correction/incident records, and precinct/election-district geometry or crosswalks. Monitor VEDA results/download exports for post-April 1, 2026 elections or any later historical 2024 export."},{"state":"OR","stateName":"Oregon","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_equipment_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"county","exportFormats":["official abstract PDF","normalized county CSV","ORMS county precinct PDF/CSV package","EAC fallback turnout CSV","Census county GeoJSON","official 2020 historical abstract PDF","normalized 2020 historical baseline CSV","official 2016/2020 historical abstract PDFs","normalized 2016/2020 historical baseline CSV"],"sourceUrls":["https://sos.oregon.gov/elections/Pages/electionhistory.aspx","https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735458","https://records.sos.state.or.us/ORSOSWebDrawer/Record?q=recNotes%3A2024+General+Election+Precinct+Level+Results&sortBy=recTypedTitle","https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735459","https://sos.oregon.gov/elections/Pages/voting-systems.aspx","https://sos.oregon.gov/elections/Pages/countyofficials.aspx","https://oregonsos.govqa.us/WEBAPP/_rs/","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/13735458","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/13735450","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/6873777","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/6873690","https://records.sos.state.or.us/ORSOSWebDrawer/Record/6873777/File/document","https://digitalcollections.library.oregon.gov/nodes/view/208504"],"exampleUrls":["https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/13735458","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/13735450","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/6873777","https://records.sos.state.or.us/ORSOSWebDrawer/Recordhtml/6873690","https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735458","https://records.sos.state.or.us/ORSOSCM/Recordhtml/13735450","https://records.sos.state.or.us/ORSOSCM/Recordhtml/6873777","https://records.sos.state.or.us/ORSOSCM/Recordhtml/6873690"],"availableFields":["official county presidential totals","official county Attorney General comparison rows","official EAC fallback turnout rows","Census county geometry","county equipment context from Verified Voting","official ORMS precinct result package collected for provenance","official 2020 county presidential historical baseline rows","official 2012/2016 historical result PDF leads","official 2016/2020 historical county presidential baseline rows","official 2012 historical result PDF lead"],"missingFields":["normalized precinct President and same-grain comparison rows","state-native turnout denominator rows from the official Oregon turnout statistics PDF","precinct boundary geometry or reporting-unit crosswalks","normalized post-election audit, CVR availability, incident, correction, recount, litigation, tabulator-log, logic-and-accuracy, custody, and ballot-image records","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"native county President-versus-Attorney-General package loaded from official Oregon abstract PDF; 2016/2020 historical county baselines loaded from official abstract PDFs; ORMS precinct package collected but not normalized; data/or-2024-data-coverage-inventory.json documents remaining official turnout, 2012 historical, audit/CVR, request, and display-path gaps","manualReviewBurden":"high","confidence":"loaded_with_caveat","caveats":"Current Oregon review rows are county-level advisory inputs, not precinct scatter plots. The official ORMS precinct package includes many image/PDF artifacts requiring county-aware extraction or request-produced machine-readable files. Turnout remains EAC fallback until the official Oregon voter registration and turnout statistics PDF is normalized and reconciled. Official 2016/2020 historical baseline rows are loaded from abstract PDFs; 2012 remains a source lead.","nextAction":"Normalize the 2024 official turnout statistics PDF, collect official 2012 historical baseline rows, then build or request machine-readable precinct President plus same-grain comparison rows."},{"state":"TN","stateName":"Tennessee","jurisdictionName":"Statewide","scope":"statewide","dataFamily":"results_review_turnout_geometry_equipment_admin_context","tier":"tier_6_official_pdf_hostile","reportingGrain":"precinct","exportFormats":["official text-layer PDF","normalized CSV","EAC fallback turnout CSV","county GeoJSON","official historical text-layer PDF","official historical county PDF","normalized historical baseline CSV"],"sourceUrls":["https://sos.tn.gov/elections/results","https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyCounty.pdf","https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyOffice.pdf","https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyPrecinct.pdf","https://www.eac.gov/research-and-data/studies-and-reports","https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/State_County/MapServer/1/query?where=STATE%3D%2747%27&outFields=NAME,BASENAME,GEOID,STATE,COUNTY&returnGeometry=true&outSR=4326&f=geojson","https://verifiedvoting.org/verifier/#mode/navigate/map/voteEquip/mapType/ppEquip/year/2024/state/47","https://sos-tn-gov-files.tnsosfiles.com/Nov%202020%20General%20by%20County.pdf","https://sos-tn-gov-files.s3.amazonaws.com/PresidentbyCountyNov2016.pdf"],"exampleUrls":["https://sos-prod.tnsosgovfiles.com/s3fs-public/document/20241105GeneralbyPrecinct.pdf","https://sos-tn-gov-files.tnsosfiles.com/Nov%202020%20General%20by%20County.pdf"],"availableFields":["official county presidential totals","official precinct President rows","official precinct U.S. Senate comparison rows","EAC fallback turnout rows","county geometry","county equipment context from Verified Voting Verifier","official 2016 and 2020 county presidential historical baseline rows"],"missingFields":["state-native turnout denominator rows","precinct boundary geometry or reporting-unit crosswalk","normalized official audit, recount, CVR availability, incident, correction, and litigation records","official 2012 county or county-equivalent presidential baseline normalized into ETL"],"parserStatus":"scripts/normalize-tn-sos-results.mjs normalizes the official SOS precinct PDF to 95 county President rows and 1,859 nonzero precinct President-versus-U.S.-Senate review rows; scripts/normalize-tn-historical-presidential-baseline.mjs normalizes official 2016 and 2020 county presidential PDF baselines; EAC fallback turnout, county geometry, and equipment context are loaded","manualReviewBurden":"medium","confidence":"loaded_with_caveat","caveats":"The official result sources are text-layer PDFs rather than structured exports; the normalizers reconcile parsed totals to official statewide totals before writing CSV artifacts. Turnout remains EAC fallback, county geometry is loaded, precinct geometry/crosswalks are not loaded, official 2012 historical baseline rows remain missing, and no normalized administration-context rows are loaded beyond equipment metadata.","nextAction":"Collect state-native turnout denominators, official precinct geometry/crosswalks, official 2012 historical baselines, and normalized audit/CVR/recount/incident/correction/litigation records."},{"state":"MS","stateName":"Mississippi","jurisdictionName":"County recapitulation PDFs","scope":"statewide","dataFamily":"precinct_review_upgrade","tier":"tier_7_scanned_system_printout","reportingGrain":"precinct","exportFormats":["image-only official PDFs","OCR candidate CSV"],"sourceUrls":["https://sos.ms.gov/elections/electionresults_aspx/elections_results_2024_county.aspx"],"exampleUrls":[],"availableFields":["image-only precinct President rows","image-only precinct U.S. Senate rows"],"missingFields":["reviewed structured precinct CSV","complete correction-reviewed OCR coverage for all counties","fully reconciled OCR output"],"parserStatus":"OCR scripts and reconciliation gate exist; 2026-06-30 reviewed partial verification reported 11 import-ready counties, 61 review-required counties, and 10 missing-OCR counties","manualReviewBurden":"high","confidence":"partial","caveats":"OCR and reviewed corrections recover some counties, but most county outputs remain review-gated; correction additions can represent reviewed cells that are not present in the partial checked-in OCR text. Do not import precinct rows until all counties reconcile to the official SOS recap totals.","nextAction":"Continue OCR/manual review for the 61 review-required counties and 10 missing-OCR counties, rerun npm run etl:verify:ms:ocr:reviewed, then promote only fully reviewed precinct rows."}],"summary":{"byConfidence":{"loaded_with_caveat":29,"loaded":14,"loaded_with_district_comparison_and_historical_caveats":1,"partial_with_2016_2020_historical_loaded":1,"loaded_with_reviewed_geometry_candidates":1,"loaded_certified_sov_reconciled":1,"loaded_with_caveats":2,"candidate":1,"loaded_with_blocker":1,"loaded_county_with_municipal_followup":1,"partial":1},"byScope":{"statewide":52,"county":1},"byTier":{"tier_1_official_export_database":25,"tier_2_official_dashboard_endpoint":14,"tier_3_sanctioned_bulk_partial":1,"tier_4_local_scattershot":1,"tier_5_digital_inconsistent":3,"tier_6_official_pdf_hostile":8,"tier_7_scanned_system_printout":1},"highRoiRows":39,"humanSetupRows":12,"localRows":1,"total":53,"unknownRows":0},"tierDefinitions":[{"tier":"tier_1_official_export_database","label":"Tier 1 official export database","roiRank":1,"description":"Official query or export database, usually CSV/XLS/XLSX capable. Best scripting ROI."},{"tier":"tier_2_official_dashboard_endpoint","label":"Tier 2 official dashboard endpoint","roiRank":2,"description":"Official dashboard or ENR system with consistent JSON, XML, ZIP, or text endpoints."},{"tier":"tier_3_sanctioned_bulk_partial","label":"Tier 3 sanctioned partial bulk data","roiRank":3,"description":"State-sanctioned or official-adjacent bulk data that is useful but incomplete, delayed, or missing fields."},{"tier":"tier_4_local_scattershot","label":"Tier 4 local scattershot","roiRank":4,"description":"County or local sources that must be collected and stitched jurisdiction by jurisdiction."},{"tier":"tier_5_digital_inconsistent","label":"Tier 5 inconsistent digital official data","roiRank":5,"description":"Official digital data with inconsistent jurisdiction names, unusual aggregation, or significant human setup."},{"tier":"tier_6_official_pdf_hostile","label":"Tier 6 official hostile PDF","roiRank":6,"description":"Official PDFs that need extraction/OCR and may include noisy or non-printing text."},{"tier":"tier_7_scanned_system_printout","label":"Tier 7 scanned system printout","roiRank":7,"description":"Scanned printouts from recognizable official systems. OCR may work but requires recurring human checks."},{"tier":"tier_8_scanned_handwritten","label":"Tier 8 scanned handwritten","roiRank":8,"description":"Scanned handwritten records. Lowest scripting ROI and highest manual review burden."},{"tier":"unknown","label":"Unknown","roiRank":99,"description":"Source path has not been classified yet."}]},"meta":{"generatedAt":"2026-09-09T18:17:35.103Z","source":"database","releaseId":null,"schemaVersion":"1.0.0","state":null,"tier":null,"rowCount":53}}