Home

Filer ID: 1402617

Table: f501_502
filing_id   2217496   2217496
amend_id   1   0
rec_type   CVR   CVR
form_type   F501   F501
filer_id   1402617   1402617
committee_id   None   None
entity_cd   8   8
report_num   None   None
rpt_date   2018-03-05 00:00:00   2018-02-20 00:00:00
stmt_type   10002   10001
from_date   None   None
thru_date   None   None
elect_date   None   None
cand_naml   ERNST   ERNST
cand_namf   DAVID S.   DAVID S.
can_namm   None   None
cand_namt   None   None
cand_nams   None   None
moniker_pos   None   None
moniker   None   None
cand_city   SAN FRANCISCO   SAN FRANCISCO
cand_st   CA   CA
cand_zip4   94121-   94121-
cand_phon   9723608141   9723608141
cand_fax   None   None
cand_email   None   None
fin_naml   None   None
fin_namf   None   None
fin_namt   None   None
fin_nams   None   None
fin_city   None   None
fin_st   None   None
fin_zip4   None   None
fin_phon   None   None
fin_fax   None   None
fin_email   None   None
office_cd   30013   30013
offic_dscr   ASSEMBLY   ASSEMBLY
agency_nam   LEGISLATIVE   LEGISLATIVE
juris_cd   40502   40502
juris_dscr   None   None
dist_no   None   None
party   None   None
yr_of_elec   2018   2018
elec_type   3002   3002
execute_dt   2018-03-05 00:00:00   2018-02-15 00:00:00
can_sig   None   None
account_no   None   None
acct_op_dt   None   None
party_cd   16012   16011
district_cd   17016   17016
accept_limit_yn   Y   Y
did_exceed_dt   None   None
cntrb_prsnl_fnds_dt   None   None
Table: filer_address
filer_id   1402617
adrid   2446246
effect_dt   2018-02-20 00:00:00
add_type   7051
session_id   2017
Table: filer_filings
filer_id   1402617   1402617
filing_id   2217496   2217496
period_id   0   0
form_id   F501   F501
filing_sequence   0   1
filing_date   2018-02-20 00:00:00   2018-03-05 00:00:00
stmnt_type   10001   10002
stmnt_status   11002   11001
session_id   2017   2017
user_id   RGEREMIA   RGEREMIA
special_audit   11003   None
fine_audit   11001   11001
rpt_start   None   None
rpt_end   None   None
rpt_date   None   None
filing_type   None   None
Table: filer_to_filer_type
filer_id   1402617   1402617
filer_type   8   8
active   Y   Y
race   0   0
session_id   2017   2017
category   0   0
category_type   40502   40502
sub_category   0   0
effect_dt   2018-03-05 00:00:00   2018-02-20 00:00:00
sub_category_type   0   0
election_type   0   0
sub_category_a   None   None
nyq_dt   None   None
party_cd   16012   16011
county_cd   0   0
district_cd   0   0
Table: filer_xref
filer_id   1402617
xref_id   1402617
effect_dt   2018-02-21 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1402617
filer_id   1402617
filer_type   CANDIDATE/OFFICEHOLDER
status   ACTIVE
effect_dt   2018-03-05 00:00:00
naml   ERNST
namf   DAVID S.
namt   None
nams   None
adr1   None
adr2   None
city   SAN FRANCISCO
st   CA
zip4   94121-
phon   9723608141
fax   None
email   None
Table: filers
filer_id   1402617