Home

Filing ID: 1741081

PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=1741081&amendid=2

Table: cvr2_campaign_disclosure
filing_id   1741081   1741081   1741081
amend_id   0   1   2
line_item   1   1   1
rec_type   CVR2   CVR2   CVR2
form_type   F465   F465   F465
tran_id   AGENCY_1   AGENCY_1   AGENCY_1
entity_cd   POF   POF   POF
title   SECRETARY OF STATE   SECRETARY OF STATE   POLITICAL REFORM DIVISION
mail_city   SACRAMENTO   SACRAMENTO   SACRAMENTO
mail_st   CA   CA   CA
mail_zip4   95812   95812   95814
f460_part   None   None   None
cmte_id   None   None   None
enty_naml   None   None   None
enty_namf   None   None   None
enty_namt   None   None   None
enty_nams   None   None   None
enty_city   None   None   None
enty_st   None   None   None
enty_zip4   None   None   None
enty_phon   None   None   None
enty_fax   None   None   None
enty_email   None   None   None
tres_naml   None   None   None
tres_namf   None   None   None
tres_namt   None   None   None
tres_nams   None   None   None
control_yn   None   None   None
office_cd   None   None   None
offic_dscr   None   None   None
juris_cd   None   None   None
juris_dscr   None   None   None
dist_no   None   None   None
off_s_h_cd   None   None   None
bal_name   None   None   None
bal_num   None   None   None
bal_juris   None   None   None
sup_opp_cd   None   None   None
Table: cvr3_verification_info
filing_id   1741081   1741081   1741081
amend_id   0   1   2
line_item   1   1   1
rec_type   CVR3   CVR3   CVR3
form_type   F465   F465   F465
tran_id   VER_1   VER_1.1   VER_1.1
entity_cd   TRE   TRE   TRE
sig_date   2013-01-31 00:00:00   2013-07-31 00:00:00   2015-04-27 00:00:00
sig_loc   None   None   None
sig_naml   MAINARDI   JESSE MAINARDI   JAMES R. SUTTON
sig_namf   JESSE   None   None
sig_namt   None   None   None
sig_nams   None   None   None
Table: cvr_campaign_disclosure
filing_id   1741081   1741081   1741081
amend_id   0   1   2
rec_type   CVR   CVR   CVR
form_type   F465   F465   F465
filer_id   1346493   1346493   1346493
entity_cd   RCP   RCP   RCP
filer_naml   CONSUMER ADVOCATES FOR SAFE FOOD AND WATER, SPONSORED BY FOOD & WATER WATCH   CONSUMER ADVOCATES FOR SAFE FOOD AND WATER, SPONSORED BY FOOD & WATER WATCH   CONSUMER ADVOCATES FOR SAFE FOOD AND WATER, SPONSORED BY FOOD & WATER WATCH
filer_namf   None   None   None
filer_namt   None   None   None
filer_nams   None   None   None
report_num   000   001   002
rpt_date   2013-01-31 00:00:00   2013-07-31 00:00:00   2015-04-29 00:00:00
stmt_type   None   None   None
late_rptno   CA-01   CA-01   CA-01
from_date   2012-10-21 00:00:00   2012-10-21 00:00:00   2012-10-21 00:00:00
thru_date   2012-12-31 00:00:00   2012-12-31 00:00:00   2012-12-31 00:00:00
elect_date   None   None   None
filer_city   SAN FRANCISCO   OAKLAND   OAKLAND
filer_st   CA   CA   CA
filer_zip4   94107   94612   94612
filer_phon   415/732-7700   415/732-7700   415/732-7700
filer_fax   None   None   None
file_email   None   None   None
mail_city   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO
mail_st   CA   CA   CA
mail_zip4   94108   94108   94108
tres_naml   MAINARDI   MAINARDI   SUTTON
tres_namf   JESSE   JESSE   JAMES R.
tres_namt   None   None   None
tres_nams   None   None   None
tres_city   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO
tres_st   CA   CA   CA
tres_zip4   94108   94108   94108
tres_phon   415/732-7700   415/732-7700   415/732-7700
tres_fax   None   None   None
tres_email   None   None   None
cmtte_type   G   G   G
control_yn   N   N   N
sponsor_yn   Y   Y   Y
primfrm_yn   N   N   N
brdbase_yn   N   N   N
amendexp_1   None   None   None
amendexp_2   None   None   None
amendexp_3   None   None   None
rpt_att_cb   None   None   None
cmtte_id   None   None   None
reportname   None   None   None
rptfromdt   None   None   None
rptthrudt   None   None   None
emplbus_cb   None   None   None
bus_name   None   None   None
bus_city   None   None   None
bus_st   None   None   None
bus_zip4   None   None   None
bus_inter   None   None   None
busact_cb   None   None   None
busactvity   None   None   None
assoc_cb   None   None   None
assoc_int   None   None   None
other_cb   None   None   None
other_int   None   None   None
cand_naml   None   None   None
cand_namf   None   None   None
cand_namt   None   None   None
cand_nams   None   None   None
cand_city   OAKLAND   OAKLAND   OAKLAND
cand_st   CA   CA   CA
cand_zip4   94618   94618   94618
cand_phon   None   None   None
cand_fax   None   None   None
cand_email   None   None   None
bal_name   GENETICALLY ENGINEERED FOODS. LABELING.   GENETICALLY ENGINEERED FOODS. LABELING.   GENETICALLY ENGINEERED FOODS. LABELING.
bal_num   37   37   37
bal_juris   STATEWIDE   STATEWIDE   STATEWIDE
office_cd   None   None   None
offic_dscr   None   None   None
juris_cd   None   None   None
juris_dscr   None   None   None
dist_no   None   None   None
off_s_h_cd   None   None   None
sup_opp_cd   S   S   S
employer   None   None   None
occupation   None   None   None
selfemp_cb   None   None   None
bal_id   None   None   None
cand_id   None   None   None
Table: expn
filing_id   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081
amend_id   0   0   0   0   0   0   0   0   0   0   1   1   1   1   1   1   1   1   1   1   1   2   2   2   2   2   2   2   2   2   2   2   2   2   2   2   2   2   2   2
line_item   1   3   7   2   4   5   6   8   9   10   5   6   7   8   9   10   11   1   2   3   4   18   2   3   4   5   6   7   1   8   9   10   11   12   13   14   15   16   17   19
rec_type   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN   EXPN
form_type   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3   F465P3
tran_id   PDT1   PDT11   PDT16   PDT10   PDT13   PDT14   PDT15   PDT17   PDT8   PDT9   PDT14   PDT15   PDT16   PDT17   PDT19   PDT8   PDT9   PDT1   PDT10   PDT11   PDT13   PDT8   PDT90.1   PDT91.1   PDT92.1   PDT10   PDT93.10   PDT94.10   PDT1   PDT95.10   PDT11   PDT13   PDT14   PDT96.14   PDT97.14   PDT15   PDT16   PDT17   PDT19   PDT9
entity_cd   OTH   OTH   OTH   OTH   OTH   OTH   IND   OTH   OTH   OTH   OTH   IND   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   IND   OTH   OTH   OTH   OTH
payee_naml   FORTUNE MEDIA, INC.   ATLAS FILMS   WONDROS   FORTUNE MEDIA, INC.   SPOT XCHANGE   FORTUNE MEDIA, INC.   DANIEL HELFMAN   49 PRINCE STREET & CO.   ATLAS FILMS   SPOT XCHANGE   FORTUNE MEDIA, INC.   DANIEL HELFMAN   WONDROS   49 PRINCE STREET & CO.   EXTREME REACH, INC   ATLAS FILMS   SPOT XCHANGE   FORTUNE MEDIA, INC.   FORTUNE MEDIA, INC.   ATLAS FILMS   SPOT XCHANGE   ATLAS FILMS   KABC-TV   KCBS-TV   KNBC-TV   FORTUNE MEDIA, INC.   KABC-TV   KCBS-TV   FORTUNE MEDIA, INC.   KNBC-TV   ATLAS FILMS   SPOT XCHANGE   FORTUNE MEDIA, INC.   KCBS-TV   KNBC-TV   DANIEL HELFMAN   WONDROS   49 PRINCE STREET & CO.   EXTREME REACH, INC   SPOT XCHANGE
payee_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
payee_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
payee_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
payee_city   REDONDO BEACH   SANTA MONICA   LOS ANGELES   REDONDO BEACH   BROOMFIELD   REDONDO BEACH   AUSTIN   LOS ANGELES   SANTA MONICA   BROOMFIELD   REDONDO BEACH   AUSTIN   LOS ANGELES   LOS ANGELES   NEEDHAM   SANTA MONICA   BROOMFIELD   REDONDO BEACH   REDONDO BEACH   SANTA MONICA   BROOMFIELD   SANTA MONICA   GLENDALE   STUDIO CITY   UNIVERSAL CITY   REDONDO BEACH   GLENDALE   STUDIO CITY   REDONDO BEACH   UNIVERSAL CITY   SANTA MONICA   BROOMFIELD   REDONDO BEACH   STUDIO CITY   UNIVERSAL CITY   AUSTIN   LOS ANGELES   LOS ANGELES   NEEDHAM   BROOMFIELD
payee_st   CA   CA   CA   CA   CO   CA   TX   CA   CA   CO   CA   TX   CA   CA   MA   CA   CO   CA   CA   CA   CO   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CO   CA   CA   CA   TX   CA   CA   MA   CO
payee_zip4   90277   90404   90048   90277   80020   90277   78750   90048   90404   80020   90277   78750   90048   90048   02494   90404   80020   90277   90277   90404   80020   90404   91201   91604   91608   90277   91201   91604   90277   91608   90404   80020   90277   91604   91608   78750   90048   90048   02494   80020
expn_date   2012-10-25 00:00:00   2012-10-29 00:00:00   2012-11-02 00:00:00   2012-10-31 00:00:00   2012-11-02 00:00:00   2012-11-03 00:00:00   2012-10-28 00:00:00   2012-11-02 00:00:00   2012-10-26 00:00:00   2012-10-26 00:00:00   2012-11-03 00:00:00   2012-10-28 00:00:00   2012-11-02 00:00:00   2012-11-02 00:00:00   2012-11-02 00:00:00   2012-10-26 00:00:00   2012-10-26 00:00:00   2012-10-25 00:00:00   2012-10-31 00:00:00   2012-10-29 00:00:00   2012-11-02 00:00:00   2012-10-26 00:00:00   2012-10-22 00:00:00   2012-10-22 00:00:00   2012-10-22 00:00:00   2012-10-31 00:00:00   2012-10-29 00:00:00   2012-10-29 00:00:00   2012-10-25 00:00:00   2012-10-29 00:00:00   2012-10-29 00:00:00   2012-11-02 00:00:00   2012-11-03 00:00:00   2012-11-01 00:00:00   2012-11-01 00:00:00   2012-10-28 00:00:00   2012-11-02 00:00:00   2012-11-02 00:00:00   2012-11-02 00:00:00   2012-10-26 00:00:00
amount   51750   1975   36118   101250   41190   150000   3000   3900   4015   8810   150000   3000   36118   3900   1500   4015   8810   51750   101250   1975   41190   4015   22500   6500   12250   101250   56500   11000   51750   33750   1975   41190   150000   32065   117935   3000   36118   3900   1500   8810
cum_ytd   465717   465717   465717   465717   465717   465717   465717   465717   465717   465717   467217   467217   467217   467217   467217   467217   467217   467217   467217   467217   467217   467217   None   None   None   467217   None   None   467217   None   467217   467217   467217   None   None   467217   467217   467217   467217   467217
cum_oth   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
expn_chkno   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
expn_code   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   IND   TEL   IND
expn_dscr   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF AD PRODUCTION SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISING SUPPORTING PROP 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADS SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF TV AD SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF WEB AD SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF VIDEO ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF TV AD SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF WEB AD SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF AD PRODUCTION SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF VIDEO ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISING SUPPORTING PROP 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADS SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE; SEE SCHEDULE G.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE; SEE SCHEDULE G.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE; SEE SCHEDULE G.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISING SUPPORTING PROP 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE; SEE SCHEDULE G.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE; SEE SCHEDULE G.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE; SEE SCHEDULE G.   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADS SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF TV AD SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF TELEVSION ADS COVERING PERIOD SUPPORTING PROPOSITION 37, STATEWIDE; SEE SCHEDULE G.   INDEPENDENT EXPENDITURE OF TELEVSION ADS COVERING PERIOD SUPPORTING PROPOSITION 37, STATEWIDE; SEE SCHEDULE G.   INDEPENDENT EXPENDITURE OF WEB AD SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF AD PRODUCTION SUPPORTING PROPOSITION 37, STATEWIDE   INDEPENDENT EXPENDITURE OF VIDEO ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF TELEVISION ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.   INDEPENDENT EXPENDITURE OF WEB ADVERTISEMENT SUPPORTING PROPOSITION 37, STATEWIDE.
agent_naml   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   FORTUNE MEDIA, INC.   FORTUNE MEDIA, INC.   FORTUNE MEDIA, INC.   None   FORTUNE MEDIA, INC.   FORTUNE MEDIA, INC.   None   FORTUNE MEDIA, INC.   None   None   None   FORTUNE MEDIA, INC.   FORTUNE MEDIA, INC.   None   None   None   None   None
agent_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
agent_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
agent_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cmte_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_naml   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_naml   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
office_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
offic_dscr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
juris_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
juris_dscr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
dist_no   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
off_s_h_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_num   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_juris   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sup_opp_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
memo_code   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   X   X   X   None   X   X   None   X   None   None   None   X   X   None   None   None   None   None
memo_refno   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bakref_tid   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
g_from_e_f   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
xref_schnm   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
xref_match   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_filings
filer_id   1346493   1346493   1346493
filing_id   1741081   1741081   1741081
period_id   212   212   212
form_id   F465   F465   F465
filing_sequence   1   2   0
filing_date   2013-07-31 00:00:00   2015-04-29 00:00:00   2013-01-31 00:00:00
stmnt_type   10002   10002   10001
stmnt_status   11003   11003   11001
session_id   2011   2011   2011
user_id   CAFILER   CAFILER   SARRIAGA
special_audit   11003   11003   11003
fine_audit   11003   11003   11003
rpt_start   2012-10-21 00:00:00   2012-10-21 00:00:00   2012-10-21 00:00:00
rpt_end   2012-12-31 00:00:00   2012-12-31 00:00:00   2012-12-31 00:00:00
rpt_date   2013-07-31 00:00:00   2015-04-29 00:00:00   2013-01-31 00:00:00
filing_type   22001   22001   22001
Table: filings
filing_id   1741081
filing_type   22001
Table: hdr
filing_id   1741081   1741081   1741081
amend_id   0   1   2
rec_type   HDR   HDR   HDR
ef_type   CAL   CAL   CAL
state_cd   CA   CA   CA
cal_ver   2.01   2.01   2.01
soft_name   NETFILE   NETFILE   NETFILE
soft_ver   145   154   154
hdrcomment   None   None   None
Table: smry
filing_id   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081   1741081
amend_id   0   0   0   1   1   1   2   2   2
line_item   1   2   3   1   2   3   1   2   3
rec_type   SMRY   SMRY   SMRY   SMRY   SMRY   SMRY   SMRY   SMRY   SMRY
form_type   F465   F465   F465   F465   F465   F465   F465   F465   F465
amount_a   402008   0   402008   403508   0   403508   403508   0   403508
amount_b   None   None   None   None   None   None   None   None   None
amount_c   None   None   None   None   None   None   None   None   None
elec_dt   None   None   None   None   None   None   None   None   None