Data Dictionary

Column Type Label Description
filer_id text
filer_name text
filer_type_code text
filer_type text
reporting_year numeric
reporting_date date
reporting_period_start date
reporting_period_end date
election_date date
report_number numeric
report_version text
record_code text
record_type text
statement_code text
statement_type text
form_code text
form_name text
form_part_code text
form_part_name text
transaction_id text
transaction_date date
transaction_amount numeric
transaction_ytd_amount numeric
transaction_description text
entity_code text
entity_type text
entity_last_name text
entity_first_name text
entity_city text
entity_state text
entity_zip text
entity_employer text
entity_occupation text
entity_self_employed bool
committee_id numeric
check_number numeric
expenditure_code text
expenditure_type text
beginning_expenses_balance numeric
expenses_incurred numeric
expenses_paid numeric
ending_expenses_balance numeric
loan_amount_1_description text
loan_amount_1 numeric
loan_amount_2_description text
loan_amount_2 numeric
loan_amount_3_description text
loan_amount_3 numeric
loan_amount_4_description text
loan_amount_4 numeric
loan_amount_5_description text
loan_amount_5 numeric
loan_amount_6_description text
loan_amount_6 numeric
loan_amount_7_description text
loan_amount_7 numeric
loan_amount_8_description text
loan_amount_8 numeric
loan_date_1_description text
loan_date_1 date
loan_date_2_description text
loan_date_2 date
loan_rate_description text
loan_rate text
summary_line_description text
summary_line_number numeric
summary_amount_a_description text
summary_amount_a numeric
summary_amount_b_description text
summary_amount_b numeric
summary_amount_c_description text
summary_amount_c numeric
candidate_last_name text
candidate_first_name text
candidate_office_code text
candidate_office text
candidate_office_juristiction text
candidate_office_juristiction_description text
candidate_office_district text
candidate_office_sought_held_code text
candidate_office_sought_held text
ballot_measure_number text
ballot_measure_name text
ballot_measure_juristiction text
support_or_oppose_code text
support_or_oppose text
identifier text

Additional Information

Field Value
Data last updated September 26, 2022
Metadata last updated September 26, 2022
Created September 26, 2022
Format unknown
License odc-by-1-0
Datastore activeTrue
Has viewsTrue
Ida9eb99f4-c633-46b7-bbeb-fc0d50b47e1a
Package id794bf483-288a-4db8-84cc-3721dcfb7d2f
Stateactive
Url typedatastore