Skip to content

Integrated CRUD operations and ORM queries in Django with SQLite, adding Python visuals for user-driven insights

Notifications You must be signed in to change notification settings

stedcheng/elections

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

46 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PoliThinks

Introduction

This dashboard presents a comprehensive and centralized database of all local politicians in the Philippines, designed as a research-oriented tool for examining patterns of political power, kinship, and governance. Beyond serving as a directory of political profiles, it enables users to explore the intricate web of familial ties, shared surnames, and career overlaps that characterize political dynasties across the country. Through its built-in analytical tools, users can visualize network relationships between politicians, identify clusters of interconnected families, and observe how these networks evolve across election cycles. The platform also offers provincial-level dynasty mapping, allowing researchers, students, and policymakers to compare the concentration, reach, and persistence of dynasties in different regions. By integrating profile data with network visualization, the dashboard provides a deeper and more systematic way of understanding how political influence is distributed, inherited, and reproduced within the Philippine political landscape.

Setup

  1. Go to the command line in the desired folder and clone the repository

git clone "https://github.com/stedcheng/elections"

  1. Install a virtual environment

(Windows) python -m venv env env\Scripts\activate

(Mac) python -m venv env source env/bin/activate

  1. Change directory to elections

cd elections

  1. Install requirements

pip install -r requirements.txt

  1. Run server

python manage.py runserver

Credits

This project was created by Rafael Acuna, Aldie Alejandro, Sted Cheng, Annika Montemayor, and Chiel Salazar, and submitted as a requirement for the course CSCI 205: Programming with Databases taken in the first semester of AY 2025-2026 in Ateneo de Manila University.

About

Integrated CRUD operations and ORM queries in Django with SQLite, adding Python visuals for user-driven insights

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •