Database design
$250-750 USD
Paid on delivery
1. Build a database of US politicians including their campaign issue platform, actual voting records and sources of campaign finance.
2. Integrate existing data from public sources and/or third party providers. Most of this data seems to be public, just not yet organized well. We have some leads here and open to further suggestions.
3. Using the new database, build analytical tools that:
a. Designate the representatives and executives for a given individual user by zip code / voting district;
b. Return platform versus actual voting analysis and relative ranking amongst all politicians;
c. Return sources of finance in three categories- Party, Corporate/PAC, and individual;
The data used to populate the database you will create, should you be selected, will come from public/open sources (i.e., [url removed, login to view]; [url removed, login to view]; [url removed, login to view]; [url removed, login to view]; and various U.S. state secretary of state offices). The data is available through API or downloadable data files. The database would need to be able to scrape all of this information on a bi-monthly/monthly basis. The data would need to be searchable and returnable to a UI with the parameters mentioned in the original job posting. Have you done this type of database design in the past? If so please provide us with details, samples, references to these previous projects. We are unsure of how long this project will take. We are open to suggestions on timeframe, but time is of the essence and the project needs to be completed ASAP. Would you be able to give an accurate timeframe for completing this project based on the information provided? If not, what further information would you need to provide an accurate time to completion? Please let me know if there are any further questions you need from us. Thank you, Envolved Team
Project ID: #8114401
About the project
5 freelancers are bidding on average $594 for this job
I have been working with database designing, programming and data migration projects since last 8 years. Have done such projects on enterprise-level databases during my past job. Also having expert command on MySQL dat More
Designing and developing relational and multi-dimensional warehouses for over 10 years. Below is what the bid covers: 1. Scope/Requirements gathering 2. Database design 3. Database development 4. Building of job More
I have over 20 years experience in database design. I have also worked as a DBA. I live and breathe database design and development.