Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Independent expenditures do not filter correctly #5422

Closed
Tracked by #137
patphongs opened this issue Sep 28, 2022 · 3 comments
Closed
Tracked by #137

Independent expenditures do not filter correctly #5422

patphongs opened this issue Sep 28, 2022 · 3 comments

Comments

@patphongs
Copy link
Member

patphongs commented Sep 28, 2022

It looks like we have a couple issues with IEs.

  • If you click on the IE link on the financial summary tab of a committee profile, you are taken to "24- and 48-Hour Reports" instead of "Regularly scheduled reports." https://www.fec.gov/data/committee/C00687103/ then click through for IE transactions
    • You get "24- and 48-Hour Reports" instead of "Regularly scheduled reports"
    • For the "24- and 48-Hour Reports", you get 33,440 records (I'm not sure the committee ID filter is working)
    • If you switch to "Regularly scheduled reports," you get zero (0) IEs. The committee has 1,037 for 2021-2022.
  • Using the IE data table page: If you search for processed IEs disclosed on regularly scheduled reports for C00687103, the website returns zero (0) records. The committee has 1,037 IEs. select count(*) from DISCLOSURE.F_ITEM_RECEIPT_OR_EXP where rpt_yr in (2021, 2022) and form_tp_cd = 'F3X' and sched_tp_cd = 'SE' and cmte_id = 'C00687103';
  • https://www.fec.gov/data/independent-expenditures/?data_type=processed&most_recent=true&q_spender=C00687103&is_notice=false

After bug is fixed, put in ticket for the CMS changes described below

@patphongs patphongs added the Bug label Sep 28, 2022
@patphongs
Copy link
Member Author

It appears to be trying to pass committee_id rather than q_spender, which is a recent update to the spender name or ID field, it expects to be able to handle both strings and committee IDs within one field

@patphongs
Copy link
Member Author

@patphongs
Copy link
Member Author

Fixes have been completed and deployed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant