Add affiliated committees to the /committees endpoint

[bmathesonFEC]

What we’re after

As a RAD analyst I use the API's filings endpoint to review portions of reports. A piece of information reported on the Form 1 that is not available in the API is affiliated committees (line 6 on the Form 1, but additional affiliated committee may also be added on F1S).

Example: this committee (C00696526) Form 1 discloses multiple committees authorized by this committee (Mark Kelly Victory Fund, Arizona Nevada 2022 Victory Fund, DSCC Battleground Victory 2022... there are 8 total.)

Would it be possible to add affiliated committees to the fiings endpoint. For RAD's purposes we're just looking for the name of the committees, so it could produce a list of affiliated and joint fundraising committees.

I'm submitting this on behalf of @MichaelDobi, feel free to reach out to him directly with questions.

Action items:

• [ ] Need to verify data accuracy across paper and electronically filed reports
• [ ] Data needs for affiliated committees and JFCs
  • [ ] Report filing date
  • [ ] Form type
  • [ ] Filing ID (looks like it may already be present
  • [ ] Affiliated committee type
  • [ ] Affiliated committee name

Completion criteria:

• [ ] Affiliated committee data is available in the /committees endpoint

Related ticket(s)

This open ticket may be relevant because it concerns data on F1S, not sure though:

• [ ] RAD request: Add fields to /filings/: https://github.com/fecgov/openFEC/issues/4395
• [ ] Ticket to research blockers: https://github.com/fecgov/openFEC/issues/5856
• [ ] Ticket to fix potential data issues: https://github.com/fecgov/openFEC/issues/5866

[JonellaCulmer]

Instead of filings endpoint, can we consider the committees endpoint instead? We also need to consider the performance of this endpoint if making this change.

[PaulClark2]

We also need to consider this: https://fecgov.slack.com/archives/C3Z3QP0JD/p1681839361605729?thread_ts=1681830103.394509&cid=C3Z3QP0JD

[tmpayton]

I moved this ticket back to the backlog because there are some data issues blocking the creation of an affiliated committee mv. I created a separate ticket to do more research on the issues that need to be fixed.