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

Adding street address to raw receipt data download #3531

Open
qqss88 opened this issue Dec 7, 2018 · 0 comments
Open

Adding street address to raw receipt data download #3531

qqss88 opened this issue Dec 7, 2018 · 0 comments

Comments

@qqss88
Copy link
Contributor

qqss88 commented Dec 7, 2018

New feature requested by Paul:

processed data download includes street address https://www.fec.gov/data/receipts/?two_year_transaction_period=2018&data_type=processed&committee_id=C00648956&min_date=01%2F01%2F2017&max_date=12%2F06%2F2018

raw data download does not include street address https://www.fec.gov/data/receipts/?two_year_transaction_period=2018&data_type=efiling&committee_id=C00648956

We need to add street address to the raw data download. What needs to be done to make that happen?

initial research and code snippet from Charlie:
I did a quick code search, but I am not quite sure if this is the reason. May need some input from others:

class ScheduleAEfile(BaseRawItemized):
table_args = {‘schema’: ‘real_efile’}
tablename = ‘sa7’

file_number = db.Column(“repid”, db.Integer, index=True, primary_key=True)
related_line_number = db.Column(“rel_lineno”, db.Integer, primary_key=True)
committee_id = db.Column(“comid”, db.String, index=True, doc=docs.COMMITTEE_ID)
contributor_prefix = db.Column(‘prefix’, db.String)
contributor_name_text = db.Column(TSVECTOR)
contributor_first_name = db.Column(‘fname’, db.String)
contributor_middle_name = db.Column(‘mname’, db.String)
contributor_last_name = db.Column(‘name’, db.String)
contributor_suffix = db.Column(‘suffix’, db.String)

Street address omitted per FEC policy in schemas

contributor_street_1 = db.Column(‘contbr_st1’, db.String)

contributor_street_2 = db.Column(‘contbr_st2’, db.String)

contributor_city = db.Column(‘city’, db.String, doc=docs.CONTRIBUTOR_CITY)
contributor_state = db.Column(‘state’, db.String, index=True, doc=docs.CONTRIBUTOR_STATE)
contributor_zip = db.Column(‘zip’, db.String, doc=docs.CONTRIBUTOR_ZIP)
contributor_employer = db.Column(‘indemp’, db.String, doc=docs.CONTRIBUTOR_EMPLOYER)
contributor_employer_text = db.Column(TSVECTOR)
contributor_occupation = db.Column(‘indocc’, db.String, doc=docs.CONTRIBUTOR_OCCUPATION)
contributor_occupation_text = db.Column(TSVECTOR)
contributor_aggregate_ytd = db.Column(‘ytd’, db.Numeric(30, 2))
contribution_receipt_amount = db.Column(‘amount’, db.Numeric(30, 2))
contribution_receipt_date = db.Column(‘date_con’, db.Date)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: ❄️ Icebox
Development

No branches or pull requests

2 participants