Election results database development
Project detail
I want to create a database for election results. Preferably, I am looking for someone who can manage both the back and front ends (open to suggestions too).
There are a lot of features that I want to add to the website over time and at different stages. At this stage, I just want to launch the website with the basic capability of searching for the election results for all countries. After completing this stage, we hopefully can continue our collaboration for other features in the future. I’ll try to explain the project in the next few paragraphs and please let me know any questions you might have and if something is not clear.
I have one excel file for each election that covers all elections for that country’s specific election. To give you a couple of examples, I attached two excel files to this post. File number 1 covers Ireland’s Parliamentary Election and file number 2 covers Ireland’s Presidential Election. The format of the excel files is the same for all countries and all elections (of course with different numbers). Each file has the common information about an election such as the number of votes/seats, changes compare to the previous election, party/leader names, turn out etc.
Overall, the first version of the website which is the purpose of this post and I need your help with will have 3 main pages (plus “contact” and “about us” pages) as follows:
1- Home page: a very simple home page with 4 tabs (home, countries, about and contact) + the map of all countries that I cover their election results + a country search box at the top of the map. Please see file 3 for a basic mock up that I created for the home page. The map should be interactive and people should be able to click on a country map and go to the next page which will be the “country profile” (will explain it later). Essentially, the “map”, “the search box” and “the countries tab” do the same work.
2- Countries tab: countries tab list all countries alphabetically where people can go and see the countries that we cover in our website. In terms of functionality, this is the same as searching the name of a country on the home page’s search box or clicking on a country through the map on the home page. After a country has been chosen through any of the above three ways, users can see what I call a “country profile.” Country profile is a summary of election statistics for a specific country such as the number of elections, votes, turn out, type of election – parliamentary and presidential – percentage of elections covered, voter turnout comparison between presidential vs parliamentary, first, last and next election + the official name of the country and its flag. Please see file 4 attached for a simple mock-up that I prepared for New Zealand’s country profile. All these statistics will come from the excel file/s of election results for each country.
3- Election results: users can click on the “election results link” which they find through the country profile (see file 4) to see the results. The results page will be very similar to what you see in the excel files but of course your help is appreciated when it comes to UI & UX for the results page as well as other pages.
Finally, there will be an About and a Contact page as well.
I bought the domain a while ago but I haven’t bought the host yet. I wanted to check with you to see which host suits my needs best. I need a user-friendly panel to update the results as I go (I am not a techie person myself so I count on your suggestion on what host would be the best choice for me). I don’t want to spend too much at this point on something that I might not. I can upgrade to a better host as I go and if need.
I don’t have a strict timeframe for this project. I know it can be time consuming and you might be busy. So I am open to negotiation on timeframe.
Please let me know if you have any questions and I very much look forward t hearing from you
Jay