March 7, 2025: Search by Office is now live.
March 3, 2025: Geocoded 4 out of 5 addresses.
March 2, 2025: Added automatic import of state database. Added "Filing Received" column to Latest Candidate Table. Added Candidate Lookup functionality. Added export (CSV/Excel/pdf) buttons to tables.
February 27, 2025: Geocoded almost 3 out 4 addresses.
February 21, 2025: Refined standardization processes.
February 9, 2025: Added name standardization processes for all campaign accounts.
February 8, 2025: Added address standardization processes for all 3.5 million transactions. All candidate accounts and transactions from the 2011 Miami-Dade County mayoral special election were added.
February 3, 2025: Automatically matched 11,000 candidate accounts with their equivalents in the state database, with 9,000 containing a VoterID.
January 21, 2025: Added autocomplete search to homepage.
January 17, 2025: Added WIP homepage with functional Lastest Candidates table.
November 30, 2024: Standardized office names for 22,000 candidates.
October 25, 2024: Refined website backup processes.
September 10, 2024: Added automated collection of phone numbers, emails, bios, and images from candidate pages.
August 27, 2024: Optimized Candidate Lookup table for faster loading times.
August 20, 2024: Added Financial Summary to candidate’s profile page.
August 6, 2024: Added Candidate Lookup table. Each candidate account now has a profile page with contributions and expenditures tables.
July 17, 2024: Manually matched all 2024 candidate accounts with their equivalents in the state database.
June 26, 2024: Database updated with Union County data.
April 29, 2024: The database was updated with 3.3 million transactions.
April 19, 2024: The database was updated with the addition of all transactions for the 2024 election.
April 9, 2024: The database was updated with the addition of 175,000 transactions, including all transactions from Alachua, Baker, Bay, and Bradford.
March 26, 2024: Identified 6 counties with inconsistent elections dates. Started contacting election offices to see if those could be corrected. Refined Navigation bar. Crafted links from account numbers to extract transactions data.
March 19, 2024: Installed Bootstrap and configured ssh. Front-end started.
March 5, 2024: Python scripts set to run automatically.
February 20, 2024: Started importing candidates data. Also started to import data from the Florida Division of Elections.
February 6, 2024: Began working from phpMyAdmin. First tables created.
January 30, 2024: Installed Python. Adapted Python scripts to the server.
January 23, 2024: LAMP installed (Linux, Apache, MySQL, and PHP). Domain configured.
January 16, 2024: Server is created.
January 7, 2024: Translated R scripts into Python.