How sivamanikoppisetti/voters works
Voter Insights is a bilingual electoral-roll website. Voters browse counts from the generated chart data by constituency, mandal, village, booth, street and household, or search voter records and retrieve household members through Supabase. The data-preparation workflow loads CSV rows into Supabase and separately rebuilds the website’s counts-only data.json. README evidence establishes the website capabilities and database functions; the HTML and SQL implementations were not sampled, so their internal routing is not expanded here.
Main entry points: load_to_supabase.py CSV loader · index.html Voter search · schema.sql search_voters · config.js Supabase config
Components 15
Website
- Roll browsing
index.html - Charts and counts
index.html - Voter search
index.html - House members
index.html - Chart data
data.json - Supabase config
config.js
Search Service
- search_voters
supabase/schema.sql - house_members
supabase/schema.sql - Voter records
supabase/schema.sql
Data Preparation
- CSV loader
tools/load_to_supabase.py - Row preparation
tools/load_to_supabase.py - Summary builder
tools/site_data.py
Other components
- Website visitor
- Electoral-roll CSV
- Supabase database
Connections 19
- Website visitor → Roll browsing: browses levels
README.md - Roll browsing → Charts and counts: displays counts
README.md - Charts and counts → Chart data: reads data
README.md - Website visitor → Voter search: searches voters
README.md - Voter search → Supabase config: uses endpoint config
README.md - Voter search → search_voters: calls
README.md - Website visitor → House members: views household
README.md - House members → Supabase config: uses endpoint config
README.md - House members → house_members: calls
README.md - search_voters → Voter records: searches records
README.md - house_members → Voter records: reads members
README.md - Electoral-roll CSV → CSV loader: provides rows
tools/load_to_supabase.py - CSV loader → Row preparation: prepares rows
tools/load_to_supabase.py - CSV loader → Supabase database: loads and reads
tools/load_to_supabase.py - CSV loader → Summary builder: builds summaries
tools/load_to_supabase.py - Summary builder → Chart data: writes counts
- Supabase config → Supabase database: configures access
README.md - search_voters → Supabase database: served by
README.md - house_members → Supabase database: served by
README.md