A step-by-step guide for activists, researchers, and citizens to audit voter rolls using publicly available data and open-source tools

Voter roll accuracy is crucial for free and fair elections, yet the EC’s proprietary SIR software remains a black box. With the EC refusing to disclose its tool, citizens need alternative methods to audit voter lists today. This guide shows you how to verify voter rolls using open data, free software, and practical techniques in just a few hours.
Start by navigating to the Election Commission of India portal (https://eci.gov.in/) and locate the download section for your district. Choose the PDF or CSV files for the most recent election cycle and save them locally; this is the base dataset for your audit. Make sure to note the file names and dates for traceability.
Open the CSV in OpenRefine (https://openrefine.org/) and use the cluster & merge feature to eliminate duplicate voter entries. Standardize columns like "Name", "Address", and "Election ID" so they match across all files. Export the cleaned dataset as a new CSV for the next steps.
Many municipalities publish resident registries online; download the latest version for your area (often on the municipal website or a city open‑data portal). Use Python’s pandas library to perform a left‑join on voter IDs, flagging mismatches in names or addresses. This reveals potential errors that the EC’s SIR might miss.
Write a short script in Jupyter Notebook to flag entries with missing fields, duplicate names, or improbable age ranges (e.g., voters under 18). Utilize the pandas.isnull() and duplicated() functions to generate a report of suspicious records. Save the output as a CSV for visual inspection.
Import the anomaly CSV into Google My Maps (https://www.google.com/maps/d/). Use the address column to auto‑geocode and plot each problematic voter on the map. The resulting visualization makes it easy to spot clusters of errors and share evidence with stakeholders.
Compile your findings into a PDF using Canva or LibreOffice Writer, including tables, charts, and map screenshots. Highlight key statistics—like the percentage of duplicates or missing data—and provide actionable recommendations. Keep the report concise (2–3 pages) for maximum impact.
Send the report to the local electoral office via email and post it on a public GitHub repository for transparency. Include a brief cover letter explaining your methodology and inviting a dialogue. Follow up within a week to confirm receipt and discuss next steps.
Use Git version control to track changes to your dataset and collaborate with other auditors, ensuring that every edit is documented and reversible.
By following these seven steps, you can independently verify voter roll accuracy and hold election officials accountable. You’ll produce a credible audit that can prompt corrections and improve electoral integrity. Start today and empower your community with data-driven insights.