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/: RAD request: Add fields to /filings/ #4395
• Ticket to research blockers: Affiliated committee data issues  #5856
• Ticket to fix potential data issues: Database work - Fix issues with affiliated committee data  #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.