Home

Filer ID: 1423034

Table: f501_502
filing_id   2423459
amend_id   0
rec_type   CVR
form_type   F501
filer_id   1423034
committee_id   None
entity_cd   8
report_num   None
rpt_date   2019-12-04 00:00:00
stmt_type   10001
from_date   None
thru_date   None
elect_date   None
cand_naml   COTTA
cand_namf   TODD
can_namm   None
cand_namt   None
cand_nams   None
moniker_pos   None
moniker   None
cand_city   VISALIA
cand_st   CA
cand_zip4   93291-
cand_phon   5595852000
cand_fax   None
cand_email   [email protected]
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-03 00:00:00
can_sig   None
account_no   None
acct_op_dt   None
party_cd   16002
district_cd   17037
accept_limit_yn   N
did_exceed_dt   None
cntrb_prsnl_fnds_dt   None
Table: filer_address
filer_id   1423034   1423034
adrid   2487739   2487742
effect_dt   2019-12-04 00:00:00   2019-12-04 00:00:00
add_type   7051   7051
session_id   2019   2019
Table: filer_filings
filer_id   1423034
filing_id   2423459
period_id   0
form_id   F501
filing_sequence   0
filing_date   2019-12-04 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   1423034
filer_type   8
active   Y
race   0
session_id   2019
category   0
category_type   40502
sub_category   0
effect_dt   2019-12-04 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   1423034
xref_id   1423034
effect_dt   2019-12-05 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1423034   1423034
filer_id   1423034   1423034
filer_type   CANDIDATE/OFFICEHOLDER   CANDIDATE/OFFICEHOLDER
status   ACTIVE   ACTIVE
effect_dt   2019-12-04 00:00:00   2019-12-04 00:00:00
naml   COTTA   COTTA
namf   TODD   TODD
namt   None   None
nams   None   None
adr1   None   None
adr2   None   None
city   VISALIA   VISALIA
st   CA   CA
zip4   93291   93291-
phon   5595852000   5595852000
fax   None   None
email   [email protected]   [email protected]
Table: filers
filer_id   1423034