Individuals

idnameage
1John Doe30
2Jane Smith28
3Alice Johnson42
4Bob Brown56
5Carol White37

VotingRecords

recordIDindividualIdparty
(→ Individuals.id)
11Democrat
22Republican
33Libertarian
44Green Party
55Independent

Districts

districtIDnametotalPopulation
(→ Dominating_Party.districtID)
1District A100000
2District B90000
3District C80000
4District D70000
5District E60000

Dominating_Party

districtIDpartyNamepercentageVotes
(→ Districts.districtID)
1Democratic Party45.6
2Republican Party49.2
3Libertarian Party3.1
4Green Party1.7
5Independents0.8

Prevalent_Ideology

districtIDideologyNamepercentageVotes
(→ Districts.districtID)
1Conservative Ideas25.4
2Progressive Ideas28.7
3Moderate Ideas30.6
4Liberal Ideas15.3
5Radical Ideas3.8