Form497Part2ItemVersion

Every version of each late contribution made by a campaign filer.

Fields

Information about the 32 fields and the definitions of any abbreviated values.

amount_received   Decimal number

Dollar amount received (from S497_CD.AMOUNT)

ballot_measure_jurisdiction   String (up to %(max_length)s)

Jurisdiction of the ballot measure supported or opposed by the recipient (from S497_CD.BAL_JURIS)

ballot_measure_name   String (up to %(max_length)s)

Name of the ballot measure supported or opposed by the recipient (from S497_CD.BAL_NAME)

ballot_measure_number   String (up to %(max_length)s)

Ballot measure number (from S497_CD.BAL_NUM)

candidate_district   String (up to %(max_length)s)

District of the office sought by the candidate (from S497_CD.DIST_NO)

candidate_firstname   String (up to %(max_length)s)

First name of the candidate to whom the contribution is connected (S497_CD.CAND_NAMF)

candidate_id   String (up to %(max_length)s)

Identifies the candidate to whom the contribution is connected (from S497_CD.CAND_ID). This can be translated to the filer_id by joining to FILER_XREF_CD.

candidate_jurisdiction_code   String (up to %(max_length)s)

Code describing the jurisdiction of office sought by the candidate (from S497_CD.JURIS_CD)

candidate_jurisdiction_description   String (up to %(max_length)s)

Full description of the jurisdiction of the office sought by the candidate (from S497_CD.JURIS_DSCR)

candidate_lastname   String (up to %(max_length)s)

Last name of the candidate to whom the contribution is connected (S497_CD.CAND_NAML)

candidate_namesuffix   String (up to %(max_length)s)

Name suffix of the candidate to whom the contribution is connected (S497_CD.CAND_NAMS)

candidate_office_code   String (up to %(max_length)s)

Code describing the office sought sought by the candidate (from S497_CD.OFFICE_CD)

candidate_office_description   String (up to %(max_length)s)

Full description of the office sought by the candidate (from S497_CD.OFFIC_DSCR)

candidate_title   String (up to %(max_length)s)

Name title of the candidate to whom the contribution is connected (from S497_CD.CAND_NAMT)

date_received   Date (without time)

Date the late contribution was received (from S497_CD.CTRIB_DATE, unless NULL then from S497_CD.DATE_THRU)

date_received_thru   Date (without time)

End date for late contributions received over a range of days(from S497_CD.DATE_THRU)

election_date   Date (without time)

Date of the election (from S497_CD.ELEC_DATE)

filing_version   Foreign Key (type determined by related field)

Foreign key referring to the version of the Schedule 497 that includes the given contribution

id   Integer

line_item   Integer

Line number of the filing form where the transaction is itemized (from S497_CD.LINE_ITEM)

memo_reference_number   String (up to %(max_length)s)

Reference number for the memo attached to the transaction (from S497_CD.MEMO_REFNO)

recipient_city   String (up to %(max_length)s)

City of the recipient (from S497_CD.ENTY_CITY)

recipient_code   String (up to %(max_length)s)

Code describing the recipient (from S497_CD.ENTITY_CD)

Code Definition
BNM Ballot measure name/title
CAO Candidate/officeholder
COM Committee
CTL Controlled committee
IND Individual
OTH Other
PTY Political Party
RCP Recipient committee
SCC Small Contributor Committee
recipient_committee_id   String (up to %(max_length)s)

Filer identification number identifying the recipient if it is a committee (from S497_CD.CMTE_ID)

recipient_firstname   String (up to %(max_length)s)

First name of the recipient (from S497_CD.ENTY_NAMF)

recipient_lastname   String (up to %(max_length)s)

Last name of the recipient (from S497_CD.ENTY_NAML)

recipient_name_suffix   String (up to %(max_length)s)

Name suffix of the recipient (from S497_CD.ENTY_NAMS)

recipient_state   String (up to %(max_length)s)

State of the recipient (from S497_CD.ENTY_ST)

recipient_title   String (up to %(max_length)s)

Name title of the recipient (from S497_CD.ENTY_NAMT)

recipient_zip   String (up to %(max_length)s)

Zip code (usually zip5, sometimes zip9) of the recipient (from S497_CD.ENTY_ZIP4)

support_opposition_code   String (up to %(max_length)s)

Code describing whether the contribuitor supports or opposesthe candidate or ballot measure (from S497_CD.SUP_OPP_CD)

Code Definition
O Opposition
S Support
transaction_id   String (up to %(max_length)s)

Identifies a unique transaction across versions of the a given Schedule 497 filing (from S497_CD.TRAN_ID)