Table: cvr2_registration
filing_id |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
rec_type |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
| CVR2 |
form_type |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
tran_id |
| 5960 |
| 5964 |
| 6860 |
| 6863 |
| 7761 |
| 9442 |
| 10919 |
| 10921 |
| 10922 |
| 5960 |
| 5964 |
| 6860 |
| 6863 |
| 7761 |
| 10919 |
| 10922 |
| 11495 |
| 11496 |
| 5960 |
| 5964 |
| 6860 |
| 6863 |
| 7761 |
| 10919 |
| 10922 |
| 11495 |
| 11496 |
| 11524 |
| 5960 |
| 5964 |
| 6860 |
| 6863 |
| 7761 |
| 10919 |
| 10922 |
| 11495 |
| 11496 |
| 5960 |
| 5964 |
| 6860 |
| 6863 |
| 7761 |
| 10919 |
| 10921 |
| 10922 |
| 5960 |
| 5964 |
| 6860 |
| 6863 |
| 7761 |
| 10919 |
| 10922 |
| 11495 |
| 11496 |
| 11524 |
| 11634 |
entity_cd |
| FRM |
| AGY |
| EMP |
| FRM |
| FRM |
| EMP |
| FRM |
| EMP |
| EMP |
| FRM |
| AGY |
| EMP |
| FRM |
| FRM |
| FRM |
| EMP |
| EMP |
| FRM |
| FRM |
| AGY |
| EMP |
| FRM |
| FRM |
| FRM |
| EMP |
| EMP |
| FRM |
| EMP |
| FRM |
| AGY |
| EMP |
| FRM |
| FRM |
| FRM |
| EMP |
| EMP |
| FRM |
| FRM |
| AGY |
| EMP |
| FRM |
| FRM |
| FRM |
| EMP |
| EMP |
| FRM |
| AGY |
| EMP |
| FRM |
| FRM |
| FRM |
| EMP |
| EMP |
| FRM |
| EMP |
| EMP |
entity_id |
| None |
| None |
| 1339534 |
| F00895 |
| 1261533 |
| 1392860 |
| 1282555 |
| 1397446 |
| 1403736 |
| None |
| None |
| 1339534 |
| F00895 |
| 1261533 |
| 1282555 |
| 1403736 |
| 1337924 |
| None |
| None |
| None |
| 1339534 |
| F00895 |
| 1261533 |
| 1282555 |
| 1403736 |
| 1337924 |
| None |
| L25799 |
| None |
| None |
| 1339534 |
| F00895 |
| 1261533 |
| 1282555 |
| 1403736 |
| 1337924 |
| None |
| None |
| None |
| 1339534 |
| F00895 |
| 1261533 |
| 1282555 |
| 1397446 |
| 1403736 |
| None |
| None |
| 1339534 |
| F00895 |
| 1261533 |
| 1282555 |
| 1403736 |
| 1337924 |
| None |
| L25799 |
| 1414582 |
enty_naml |
| CHRIS KAHN CONSULTING |
| ALL STATE AGENCIES |
| BREWER |
| LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS |
| POLITICAL SOLUTIONS, LLC |
| PIERINI |
| FERNANDEZ CERVANTES GOVERNMENT AFFAIRS |
| LEE |
| SMITH |
| CHRIS KAHN CONSULTING |
| ALL STATE AGENCIES |
| BREWER |
| LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS |
| POLITICAL SOLUTIONS, LLC |
| FERNANDEZ CERVANTES GOVERNMENT AFFAIRS |
| SMITH |
| PARRA |
| MILLER CESPEDES & ASSOCIATES, LLC |
| CHRIS KAHN CONSULTING |
| ALL STATE AGENCIES |
| BREWER |
| LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS |
| POLITICAL SOLUTIONS, LLC |
| FERNANDEZ CERVANTES GOVERNMENT AFFAIRS |
| SMITH |
| PARRA |
| MILLER CESPEDES & ASSOCIATES, LLC |
| BORG |
| CHRIS KAHN CONSULTING |
| ALL STATE AGENCIES |
| BREWER |
| LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS |
| POLITICAL SOLUTIONS, LLC |
| FERNANDEZ CERVANTES GOVERNMENT AFFAIRS |
| SMITH |
| PARRA |
| MILLER CESPEDES & ASSOCIATES, LLC |
| CHRIS KAHN CONSULTING |
| ALL STATE AGENCIES |
| BREWER |
| LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS |
| POLITICAL SOLUTIONS, LLC |
| FERNANDEZ CERVANTES GOVERNMENT AFFAIRS |
| LEE |
| SMITH |
| CHRIS KAHN CONSULTING |
| ALL STATE AGENCIES |
| BREWER |
| LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS |
| POLITICAL SOLUTIONS, LLC |
| FERNANDEZ CERVANTES GOVERNMENT AFFAIRS |
| SMITH |
| PARRA |
| MILLER CESPEDES & ASSOCIATES, LLC |
| BORG |
| KOSYDAR |
enty_namf |
| None |
| None |
| ROD |
| None |
| None |
| RYAN J. |
| None |
| REBECCA T. |
| ADAM |
| None |
| None |
| ROD |
| None |
| None |
| None |
| ADAM |
| LAURA |
| None |
| None |
| None |
| ROD |
| None |
| None |
| None |
| ADAM |
| LAURA |
| None |
| CATHERINE |
| None |
| None |
| ROD |
| None |
| None |
| None |
| ADAM |
| LAURA |
| None |
| None |
| None |
| ROD |
| None |
| None |
| None |
| REBECCA T. |
| ADAM |
| None |
| None |
| ROD |
| None |
| None |
| None |
| ADAM |
| LAURA |
| None |
| CATHERINE |
| ANDREW |
enty_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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
enty_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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: cvr_registration
filing_id |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
| 2332961 |
amend_id |
| 0 |
| 1 |
| 2 |
| 4 |
| 3 |
| 5 |
rec_type |
| CVR |
| CVR |
| CVR |
| CVR |
| CVR |
| CVR |
form_type |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
| F603 |
sender_id |
| E00768 |
| E00768 |
| E00768 |
| E00768 |
| E00768 |
| E00768 |
filer_id |
| E00768 |
| E00768 |
| E00768 |
| E00768 |
| E00768 |
| E00768 |
entity_cd |
| LEM |
| LEM |
| LEM |
| LEM |
| LEM |
| LEM |
filer_naml |
| EDISON INTERNATIONAL AND AFFILIATES, INCLUDING SOUTHERN CALIFORNIA EDISON |
| EDISON INTERNATIONAL AND AFFILIATES, INCLUDING SOUTHERN CALIFORNIA EDISON |
| EDISON INTERNATIONAL AND AFFILIATES, INCLUDING SOUTHERN CALIFORNIA EDISON |
| EDISON INTERNATIONAL AND AFFILIATES, INCLUDING SOUTHERN CALIFORNIA EDISON |
| EDISON INTERNATIONAL AND AFFILIATES, INCLUDING SOUTHERN CALIFORNIA EDISON |
| EDISON INTERNATIONAL AND AFFILIATES, INCLUDING SOUTHERN CALIFORNIA EDISON |
filer_namf |
| None |
| None |
| None |
| None |
| None |
| None |
filer_namt |
| None |
| None |
| None |
| None |
| None |
| None |
filer_nams |
| None |
| None |
| None |
| None |
| None |
| None |
report_num |
| 000 |
| 001 |
| 002 |
| 004 |
| 003 |
| 005 |
rpt_date |
| 2018-12-31 00:00:00 |
| 2019-09-17 00:00:00 |
| 2020-01-07 00:00:00 |
| 2020-01-28 00:00:00 |
| 2020-01-17 00:00:00 |
| 2020-05-04 00:00:00 |
ls_beg_yr |
| 2019 |
| 2019 |
| 2019 |
| 2019 |
| 2019 |
| 2019 |
ls_end_yr |
| 2020 |
| 2020 |
| 2020 |
| 2020 |
| 2020 |
| 2020 |
qual_date |
| 2019-01-01 00:00:00 |
| 2019-01-01 00:00:00 |
| 2019-01-01 00:00:00 |
| 2019-01-01 00:00:00 |
| 2019-01-01 00:00:00 |
| 2019-01-01 00:00:00 |
eff_date |
| None |
| None |
| None |
| None |
| None |
| None |
bus_city |
| ROSEMEAD |
| ROSEMEAD |
| ROSEMEAD |
| ROSEMEAD |
| ROSEMEAD |
| ROSEMEAD |
bus_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
bus_zip4 |
| 91770 |
| 91770 |
| 91770 |
| 91770 |
| 91770 |
| 91770 |
bus_phon |
| 626 302-1952 |
| 626 302-1952 |
| 626 302-1952 |
| 626 302-1952 |
| 626 302-1952 |
| 626 302-1952 |
bus_fax |
| None |
| None |
| None |
| None |
| None |
| None |
bus_email |
| None |
| None |
| None |
| None |
| None |
| None |
mail_city |
| LOS ANGELES |
| LOS ANGELES |
| LOS ANGELES |
| LOS ANGELES |
| LOS ANGELES |
| LOS ANGELES |
mail_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
mail_zip4 |
| 90071 |
| 90071 |
| 90071 |
| 90071 |
| 90071 |
| 90071 |
mail_phon |
| None |
| None |
| None |
| None |
| None |
| None |
sig_date |
| 2018-12-31 00:00:00 |
| 2019-09-17 00:00:00 |
| 2020-01-07 00:00:00 |
| 2020-01-28 00:00:00 |
| 2020-01-17 00:00:00 |
| 2020-05-04 00:00:00 |
sig_loc |
| LOS ANGELES, CA |
| LOS ANGELES, CA |
| LOS ANGELES, CA |
| LOS ANGELES, CA |
| LOS ANGELES, CA |
| LOS ANGELES, CA |
sig_naml |
| DAVIDSON |
| DAVIDSON |
| DAVIDSON |
| DAVIDSON |
| DAVIDSON |
| DAVIDSON |
sig_namf |
| CARY |
| CARY |
| CARY |
| CARY |
| CARY |
| CARY |
sig_namt |
| None |
| None |
| None |
| None |
| None |
| None |
sig_nams |
| None |
| None |
| None |
| None |
| None |
| None |
prn_naml |
| DAVIDSON |
| DAVIDSON |
| DAVIDSON |
| DAVIDSON |
| DAVIDSON |
| DAVIDSON |
prn_namf |
| CARY |
| CARY |
| CARY |
| CARY |
| CARY |
| CARY |
prn_namt |
| None |
| None |
| None |
| None |
| None |
| None |
prn_nams |
| None |
| None |
| None |
| None |
| None |
| None |
sig_title |
| LEGAL COUNSEL |
| LEGAL COUNSEL |
| LEGAL COUNSEL |
| LEGAL COUNSEL |
| LEGAL COUNSEL |
| LEGAL COUNSEL |
stmt_firm |
| None |
| None |
| None |
| None |
| None |
| None |
ind_cb |
| None |
| None |
| None |
| None |
| None |
| None |
bus_cb |
| X |
| X |
| X |
| X |
| X |
| X |
trade_cb |
| None |
| None |
| None |
| None |
| None |
| None |
oth_cb |
| None |
| None |
| None |
| None |
| None |
| None |
a_b_name |
| None |
| None |
| None |
| None |
| None |
| None |
a_b_city |
| None |
| None |
| None |
| None |
| None |
| None |
a_b_st |
| None |
| None |
| None |
| None |
| None |
| None |
a_b_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
descrip_1 |
| GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING ENERGY SERVICES |
| GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING ENERGY SERVICES |
| GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING ENERGY SERVICES |
| GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING ENERGY SERVICES |
| GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING ENERGY SERVICES |
| GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING ENERGY SERVICES |
descrip_2 |
| None |
| None |
| None |
| None |
| None |
| None |
c_less50 |
| None |
| None |
| None |
| None |
| None |
| None |
c_more50 |
| None |
| None |
| None |
| None |
| None |
| None |
ind_class |
| UTL |
| UTL |
| UTL |
| UTL |
| UTL |
| UTL |
ind_descr |
| None |
| None |
| None |
| None |
| None |
| None |
bus_class |
| None |
| None |
| None |
| None |
| None |
| None |
bus_descr |
| None |
| None |
| None |
| None |
| None |
| None |
auth_name |
| None |
| None |
| None |
| None |
| None |
| None |
auth_city |
| None |
| None |
| None |
| None |
| None |
| None |
auth_st |
| None |
| None |
| None |
| None |
| None |
| None |
auth_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
lobby_int |
| LEGISLATIVE AND/OR QUASI-LEGISLATIVE ACTION OF THE ABOVE STATE AGENCIES AFFECTING THE BUSINESS OF GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING OF ENERGY SERVICES. |
| LEGISLATIVE AND/OR QUASI-LEGISLATIVE ACTION OF THE ABOVE STATE AGENCIES AFFECTING THE BUSINESS OF GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING OF ENERGY SERVICES. |
| LEGISLATIVE AND/OR QUASI-LEGISLATIVE ACTION OF THE ABOVE STATE AGENCIES AFFECTING THE BUSINESS OF GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING OF ENERGY SERVICES. |
| LEGISLATIVE AND/OR QUASI-LEGISLATIVE ACTION OF THE ABOVE STATE AGENCIES AFFECTING THE BUSINESS OF GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING OF ENERGY SERVICES. |
| LEGISLATIVE AND/OR QUASI-LEGISLATIVE ACTION OF THE ABOVE STATE AGENCIES AFFECTING THE BUSINESS OF GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING OF ENERGY SERVICES. |
| LEGISLATIVE AND/OR QUASI-LEGISLATIVE ACTION OF THE ABOVE STATE AGENCIES AFFECTING THE BUSINESS OF GENERATING, TRANSMITTING, DISTRIBUTING, AND/OR SELLING OF ENERGY SERVICES. |
influen_yn |
| Y |
| Y |
| Y |
| Y |
| Y |
| Y |
firm_name |
| None |
| None |
| None |
| None |
| None |
| None |
newcert_cb |
| None |
| None |
| None |
| None |
| None |
| None |
rencert_cb |
| None |
| None |
| None |
| None |
| None |
| None |
complet_dt |
| None |
| None |
| None |
| None |
| None |
| None |
lby_reg_cb |
| None |
| None |
| None |
| None |
| None |
| None |
lby_604_cb |
| None |
| None |
| None |
| None |
| None |
| None |
st_leg_yn |
| None |
| None |
| None |
| None |
| None |
| None |
st_agency |
| None |
| None |
| None |
| None |
| None |
| None |
lobby_cb |
| None |
| None |
| None |
| None |
| None |
| None |
l_firm_cb |
| None |
| None |
| None |
| None |
| None |
| None |
|