Home

Filer ID: 1373235

Table: cvr_campaign_disclosure
filing_id   1908748
amend_id   0
rec_type   CVR
form_type   F497
filer_id   1373235
entity_cd   MDI
filer_naml   ROBERT M. KAGAN
filer_namf   None
filer_namt   None
filer_nams   None
report_num   000
rpt_date   2014-10-29 00:00:00
stmt_type   None
late_rptno   LCR #1016
from_date   None
thru_date   None
elect_date   None
filer_city   WALNUT CREEK
filer_st   CA
filer_zip4   94596
filer_phon   (925) 274-2821
filer_fax   None
file_email   None
mail_city   None
mail_st   None
mail_zip4   None
tres_naml   None
tres_namf   None
tres_namt   None
tres_nams   None
tres_city   None
tres_st   None
tres_zip4   None
tres_phon   None
tres_fax   None
tres_email   None
cmtte_type   None
control_yn   None
sponsor_yn   None
primfrm_yn   None
brdbase_yn   None
amendexp_1   None
amendexp_2   None
amendexp_3   None
rpt_att_cb   None
cmtte_id   None
reportname   None
rptfromdt   None
rptthrudt   None
emplbus_cb   None
bus_name   None
bus_city   None
bus_st   None
bus_zip4   None
bus_inter   None
busact_cb   None
busactvity   None
assoc_cb   None
assoc_int   None
other_cb   None
other_int   None
cand_naml   None
cand_namf   None
cand_namt   None
cand_nams   None
cand_city   None
cand_st   None
cand_zip4   None
cand_phon   None
cand_fax   None
cand_email   None
bal_name   None
bal_num   None
bal_juris   None
office_cd   None
offic_dscr   None
juris_cd   None
juris_dscr   None
dist_no   None
off_s_h_cd   None
sup_opp_cd   None
employer   None
occupation   None
selfemp_cb   None
bal_id   None
cand_id   None
Table: filer_address
filer_id   1373235   1373235   1373235
adrid   2334798   2359489   2359490
effect_dt   2014-10-29 00:00:00   2014-02-02 00:00:00   2015-02-02 00:00:00
add_type   7051   7051   7051
session_id   2013   2013   2013
Table: filer_filings
filer_id   1373235   1373235
filing_id   1954809   1908748
period_id   None   220
form_id   F461   F497
filing_sequence   0   0
filing_date   2015-02-02 00:00:00   2014-10-29 00:00:00
stmnt_type   10005   10001
stmnt_status   11001   11003
session_id   2013   2013
user_id   JINGRAM   CAFILER
special_audit   11003   11003
fine_audit   11001   11003
rpt_start   2014-01-01 00:00:00   2014-10-29 00:00:00
rpt_end   2014-12-31 00:00:00   2014-10-29 00:00:00
rpt_date   None   2014-10-29 00:00:00
filing_type   None   22001
Table: filer_to_filer_type
filer_id   1373235
filer_type   10
active   Y
race   0
session_id   2013
category   0
category_type   0
sub_category   0
effect_dt   2014-10-29 00:00:00
sub_category_type   0
election_type   0
sub_category_a   None
nyq_dt   None
party_cd   0
county_cd   0
district_cd   0
Table: filer_xref
filer_id   1373235
xref_id   1373235
effect_dt   2014-10-29 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1373235   1373235   1373235
filer_id   1373235   1373235   1373235
filer_type   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status   ACTIVE   ACTIVE   ACTIVE
effect_dt   2014-10-29 00:00:00   2014-10-29 00:00:00   2014-10-29 00:00:00
naml   KAGAN, ROBERT M.   KAGAN, ROBERT M.   KAGAN, ROBERT M.
namf   None   None   None
namt   None   None   None
nams   None   None   None
adr1   None   None   None
adr2   None   None   None
city   OAKLAND   WALNUT CREEK   WALNUT CREEK
st   CA   CA   CA
zip4   94606   94596   94596
phon   4153896800   9252742821   9252742821
fax   None   None   None
email   None   None   None
Table: filers
filer_id   1373235
Table: received_filings
filer_id   1373235   1373235
filing_file_name   63034.cal   63077.cal
received_date   2014-10-29 00:00:00   2014-10-29 00:00:00
filing_directory   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp
filing_id   None   None
form_id   None   None
receive_comment   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints