Home

Filer ID: 1423454

Table: f501_502
filing_id   2425517
amend_id   0
rec_type   CVR
form_type   F501
filer_id   1423454
committee_id   None
entity_cd   8
report_num   None
rpt_date   2019-12-05 00:00:00
stmt_type   10001
from_date   None
thru_date   None
elect_date   None
cand_naml   COLE
cand_namf   CHARLES W.
can_namm   None
cand_namt   None
cand_nams   None
moniker_pos   None
moniker   None
cand_city   SANTA BARBARA
cand_st   CA
cand_zip4   93108-
cand_phon   8054537645
cand_fax   None
cand_email   None
fin_naml   None
fin_namf   None
fin_namt   None
fin_nams   None
fin_city   None
fin_st   None
fin_zip4   None
fin_phon   None
fin_fax   None
fin_email   None
office_cd   30013
offic_dscr   ASSEMBLY
agency_nam   LEGISLATIVE
juris_cd   40502
juris_dscr   None
dist_no   None
party   None
yr_of_elec   2020
elec_type   3002
execute_dt   2019-12-05 00:00:00
can_sig   None
account_no   None
acct_op_dt   None
party_cd   16002
district_cd   17041
accept_limit_yn   Y
did_exceed_dt   None
cntrb_prsnl_fnds_dt   None
Table: filer_address
filer_id   1423454   1423454
adrid   2488336   2488339
effect_dt   2019-12-05 00:00:00   2019-12-05 00:00:00
add_type   7051   7051
session_id   2019   2019
Table: filer_filings
filer_id   1423454
filing_id   2425517
period_id   0
form_id   F501
filing_sequence   0
filing_date   2019-12-05 00:00:00
stmnt_type   10001
stmnt_status   11001
session_id   2019
user_id   RGEREMIA
special_audit   11003
fine_audit   11001
rpt_start   None
rpt_end   None
rpt_date   None
filing_type   None
Table: filer_to_filer_type
filer_id   1423454
filer_type   8
active   Y
race   0
session_id   2019
category   0
category_type   40502
sub_category   0
effect_dt   2019-12-05 00:00:00
sub_category_type   0
election_type   0
sub_category_a   None
nyq_dt   None
party_cd   16002
county_cd   0
district_cd   0
Table: filer_xref
filer_id   1423454
xref_id   1423454
effect_dt   2019-12-18 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1423454   1423454
filer_id   1423454   1423454
filer_type   CANDIDATE/OFFICEHOLDER   CANDIDATE/OFFICEHOLDER
status   ACTIVE   ACTIVE
effect_dt   2019-12-05 00:00:00   2019-12-05 00:00:00
naml   COLE   COLE
namf   CHARLES W.   CHARLES W.
namt   None   None
nams   None   None
adr1   None   None
adr2   None   None
city   SANTA BARBARA   SANTA BARBARA
st   CA   CA
zip4   93108   93108-
phon   8054537645   8054537645
fax   None   None
email   None   None
Table: filers
filer_id   1423454