search

hackoregon / archive-campaign-finance-general_non_programing_faq

A catch all for non programing issues concerning our data sets
0 stars 0 forks source link

Transactions with committees committee id is missing but committee name is given. #2

Open stochasticTreat opened 9 years ago

stochasticTreat commented 9 years ago

Some transactions (1652 in the current campaign cycle) have political committees listed with out committee ids given.

Ex: Transaction 1499692: the contributor_payee is "Coos County Democrats", a "Political Party Committee" but an id is not given (state is given as OR). Searching Coos County Democrats in Orestar indicates their ID should have been given as 299.

transaction 1452364: contributor_payee is given as "Romney for President, Inc.", but no filer_id is given. Searching "Romney for President, Inc." on Orestar yields no results. (note: the 'state' field is given as MA, not OR)

stochasticTreat commented 9 years ago

We could possibly make a scraper to attempt to fill in the ids.

stochasticTreat commented 9 years ago

See these SQL queries on our DB: select distinct book_type from cc_working_transactions where contributor_payee_committee_id is not NULL;

select * from cc_working_transactions where book_type in ('Political Party Committee','Political Committee') and contributor_payee_committee_id is NULL;

select * from cc_working_transactions where contributor_payee_committee_id is not NULL and book_type not in ('Individual', 'Business Entity', 'Other');