FEC Contributions Analysis | 2018–2020
Mohammed Beheiry

Start with FEC_Contributions_Analysis.html. That is the main report, with my answers, charts and explanation of the choices I made. You can expand the SQL sections to see the queries behind the results.

FEC_Contributions_Analysis_reading_copy.pdf is a printable version of the report without the appendix. The HTML has the full SQL and captured results.

I included the supporting files so you can follow the analysis or rerun it:

- sql: the 29 queries, with a guide to the order they run in.
- FEC_Contributions_Analysis.ipynb: the notebook used to build the report.
- 21_monthly_chart_data.csv: the monthly results used for the first chart.
- QA_results: the saved results from my data checks and comparisons.

The report compares the original totals with a version that excludes WinRed reporting to reduce overlap. I explain the difference and the limitations in the report.

The full appendix is available in the HTML. It is left out when printing to keep the reading copy shorter.
