ERD of core concepts/mart models?

[risafangs]

I’ve been looking around this project and noticed that the staging layer seems very fleshed out, but there aren’t many marts or analytics models yet. It would probably be helpful to lay out the core “building block” models that need to be built, and any relationships between them.

Based on the current questions to answer, I think it would be helpful to have additional marts models for:

• all_candidates (including Congressional, Presidential)
• committees (PACs)
• offices (including location)

This would facilitate answering questions like:

• What does PAC expenditure look like in non-presidential races? Which Congressional races were most expensive?
• Industry alignment of PAC to office

If we could eventually source election results to expenditure or office geography, that could also be really interesting.