Research LOE for historical committee treasurer search

[patphongs]

Summary

As a user, I want to be able to search for historic committee treasurers so that I can get a complete view of a committee's treasurer history.

Current Situation

The committee treasurer historical information is only available on the committee profile page and it is not searchable. You need to go through each two-year period to find out what to do.

https://www.fec.gov/data/committee/C00213512/?tab=about-committee&cycle=2008

https://www.fec.gov/data/committee/C00213512/?tab=about-committee

Completion Criteria

• Research this issue to give us a start on addressing the request that was made in the recent website initiative (2023).
• Documentation put in the comments why this may be difficult to accomplish (paper filers, other reasons) and things to consider
• List made of what data would be needed to track this going forward.

[tmpayton]

From a backend perspective, this would require minimal/no changes. Historical treasurer data can be found using the committee/{committee_id}/history/ endpoint. The underling materialized view, ofec_committee_history_mv, contains the history for all committees regardless of source (paper/electronic).

Here is an example query: https://api.open.fec.gov/v1/committee/C00213512/history/?page=1&per_page=20&election_full=true&sort=-cycle&sort_hide_null=false&sort_null_only=false&sort_nulls_last=false&api_key=DEMO_KEY

We also could create a new endpoint that contains a subset of information from ofec_committee_history_mv using the columns committee_id, cycle, and treasurer_name . The level of effort for this would be minimal.

The changes needed to be able to search for historic committee treasurers would be mostly front-end.