Skip to content

An SQLite Flask internal app for newsroom reporters. Given a list of registered voters for a county, search and find by name, phone, address.

Notifications You must be signed in to change notification settings

vivertido/voterfinder

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

VoterFinder

VoterFinder is a tool designed to help users easily locate voter information, analyze data, and manage election-related datasets. This project aims to simplify the process of exploring voter demographics and organizing related data for campaigns, studies, and civic engagement.


Installation

  1. Clone the repository:

    git clone https://github.com/vivertido/voterfinder.git
  2. Obtain your voter data. Usually your county will provide a list for purchase.

  3. Clean your data. You should remove unecessary columns to reduce size of dataset. This app uses just basic info for search, but feel free to allow for all the columns of iterest:

    • First name
    • Last name
    • Phone
    • City
    • Mail address
  4. Create a db at /instance (create this directory)

    sqlite3 my_database.db
  5. Enable CSV Mode Tell SQLite to read data in CSV format:

    .mode csv
  6. Import the CSV File Use the .import command to load your .csv file into a new table:

    .import your_file.csv table_name
  7. Verify the Import Check if the data has been imported:

    SELECT * FROM table_name;
  8. Exit sql:

    .exit
    

About

An SQLite Flask internal app for newsroom reporters. Given a list of registered voters for a county, search and find by name, phone, address.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published