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

entities given committee ids, which are not political committees #1

Open stochasticTreat opened 9 years ago

stochasticTreat commented 9 years ago

15 transactions were found where a committee_id (the column named contributor_payee_committee_id) was given for a group marked as 'Individual', 'Business Entity' or 'Other'. Transactions without this anomaly showed committee names and ids matching what was found in Orestar by searching for committee by id (this search page: https://secure.sos.state.or.us/orestar/GotoSearchByName.do )

These are the committees, ids and book types from the transactions showing this anomaly:

"contributor_payee",contributor_payee_committee_id, "book_type" "Mid-Willamette Valley Healthy Communities Initiative";5514;"Business Entity" "Oregon School Employees Association Chapter 1";2307;"Other" "NARAL Pro-Choice Oregon";172;"Other" "Mellon Trust of New England, N.A.";176;"Business Entity" "Martha Scott";342;"Individual" "Martha Scott";342;"Individual" "Gary Ollerenshaw";15698;"Individual" "PacifiCorp Pacific Power Rocky Mountain Power";4283;"Business Entity" "PacifiCorp Pacific Power Rocky Mountain Power";4283;"Business Entity" "Andy Duyck";8065;"Individual" "Mid-Willamette Valley Healthy Communities Initiative";5514;"Business Entity" "Mid-Willamette Valley Healthy Communities Initiative";5514;"Business Entity" "NARAL Pro-Choice Oregon";172;"Other" "Oregon Naral Pro-Choice Oregon";172;"Other" "Secretary of State";6646;"Other"

Examining a few of these more deeply: 342 was given as the ID for "Martha Scott" in two transactions where money was contributed to "Buchal for Attorney General" (transactions 1411083 and 1349579 ). Looking at Orestar directly, it appears this ID should be for the "Umatilla County Republican Central Committee" ( accessed via this URL : https://secure.sos.state.or.us/orestar/GotoSearchByName.do , put 342 into the Committee/Filer ID box. )

The ID 172 was given for "NARAL Pro-Choice Oregon" who's book_type is "Other", in a transaction where "Friends of Ginny Burdick" gave money. According to Orestar, 172 is the correct ID for Naral Pro-Choice Oregon PAC and the committee type is given there as "Miscellaneous".

Several other transactions with 'book_type' given as "other" showed up in orestar with committee type given as "Miscellaneous".

stochasticTreat commented 9 years ago

See these 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');