Table: lemp
filing_id |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
| 1921149 |
amend_id |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 3 |
| 4 |
| 5 |
| 1 |
| 2 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
rec_type |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
form_type |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
client_id |
| C27395 |
| 1318639 |
| C01980 |
| 1254653 |
| 1309256 |
| C01980 |
| 1254653 |
| 1309256 |
| C27395 |
| 1318639 |
| 1254653 |
| 1309256 |
| C27395 |
| 1318639 |
| None |
| C01980 |
| 1254653 |
| 1309256 |
| None |
| C27395 |
| 1318639 |
| C01980 |
| 1254653 |
| 1309256 |
| None |
| C27395 |
| 1318639 |
| None |
| C01980 |
cli_naml |
| STATE COALITION OF PROBATION ORGANIZATIONS |
| SUNRUN INC. |
| UNITED HEALTHCARE SERVICES, INC. |
| FOX ENTERTAINMENT GROUP, INC. |
| RYAN, LLC |
| UNITED HEALTHCARE SERVICES, INC. |
| FOX ENTERTAINMENT GROUP, INC. |
| RYAN, LLC |
| STATE COALITION OF PROBATION ORGANIZATIONS |
| SUNRUN INC. |
| FOX ENTERTAINMENT GROUP, INC. |
| RYAN, LLC |
| STATE COALITION OF PROBATION ORGANIZATIONS |
| SUNRUN INC. |
| THE ALLIANCE FOR SOLAR CHOICE 'TASC' |
| UNITED HEALTHCARE SERVICES, INC. |
| FOX ENTERTAINMENT GROUP, INC. |
| RYAN, LLC |
| CATALINA FREIGHT LINE |
| STATE COALITION OF PROBATION ORGANIZATIONS |
| SUNRUN INC. |
| UNITED HEALTHCARE SERVICES, INC. |
| FOX ENTERTAINMENT GROUP, INC. |
| RYAN, LLC |
| CATALINA FREIGHT LINE |
| STATE COALITION OF PROBATION ORGANIZATIONS |
| SUNRUN INC. |
| THE ALLIANCE FOR SOLAR CHOICE 'TASC' |
| UNITED HEALTHCARE SERVICES, INC. |
cli_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 |
cli_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 |
cli_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 |
cli_city |
| SACRAMENTO |
| SAN FRANCISCO |
| WASHINGTON |
| LOS ANGELES |
| DALLAS |
| WASHINGTON |
| LOS ANGELES |
| DALLAS |
| SACRAMENTO |
| SAN FRANCISCO |
| LOS ANGELES |
| DALLAS |
| SACRAMENTO |
| SAN FRANCISCO |
| SAN FRANCISCO |
| WASHINGTON |
| LOS ANGELES |
| DALLAS |
| WILMINGTON |
| SACRAMENTO |
| SAN FRANCISCO |
| WASHINGTON |
| LOS ANGELES |
| DALLAS |
| WILMINGTON |
| SACRAMENTO |
| SAN FRANCISCO |
| SAN FRANCISCO |
| WASHINGTON |
cli_st |
| CA |
| CA |
| DC |
| CA |
| TX |
| DC |
| CA |
| TX |
| CA |
| CA |
| CA |
| TX |
| CA |
| CA |
| CA |
| DC |
| CA |
| TX |
| CA |
| CA |
| CA |
| DC |
| CA |
| TX |
| CA |
| CA |
| CA |
| CA |
| DC |
cli_zip4 |
| 95827 |
| 94105 |
| 20004 |
| 90064 |
| 75240 |
| 20004 |
| 90064 |
| 75240 |
| 95827 |
| 94105 |
| 90064 |
| 75240 |
| 95826 |
| 94105 |
| 94105 |
| 20004 |
| 90064 |
| 75240 |
| 90744 |
| 95827 |
| 94105 |
| 20004 |
| 90064 |
| 75240 |
| 90744 |
| 95827 |
| 94105 |
| 94105 |
| 20004 |
cli_phon |
| (209) 403-1537 |
| (415) 580-6854 |
| (702) 242-7191 |
| (310) 369-4642 |
| (512) 476-0022 |
| (702) 242-7191 |
| (310) 369-4642 |
| (512) 476-0022 |
| (209) 403-1537 |
| (415) 580-6854 |
| (310) 369-4642 |
| (512) 476-0022 |
| (209) 403-1537 |
| (415) 580-6854 |
| (415) 580-6854 |
| (702) 242-7191 |
| (310) 369-4642 |
| (512) 476-0022 |
| (310) 510-0248 |
| (209) 403-1537 |
| (415) 580-6854 |
| (702) 242-7191 |
| (310) 369-4642 |
| (512) 476-0022 |
| (310) 510-0248 |
| (209) 403-1537 |
| (415) 580-6854 |
| (415) 580-6854 |
| (702) 242-7191 |
eff_date |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2016-03-15 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2016-02-17 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2016-02-17 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2016-03-15 00:00:00 |
| 2015-01-01 00:00:00 |
con_period |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
agencylist |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, INSURANCE COMMISSIONER, CALPERS AND STATE LEGISLATURE |
| LEGISLATURE, GOVERNOR'S OFFICE, LT. GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE, LEGISLATURE, LT. GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, INSURANCE COMMISSIONER, CALPERS AND STATE LEGISLATURE |
| LEGISLATURE, GOVERNOR'S OFFICE, LT. GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE, LEGISLATURE, LT. GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| LEGISLATURE, GOVERNOR'S OFFICE, LT. GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE, LEGISLATURE, LT. GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| LEGISLATURE, GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, INSURANCE COMMISSIONER, CALPERS AND STATE LEGISLATURE |
| LEGISLATURE, GOVERNOR'S OFFICE, LT. GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE, LEGISLATURE, LT. GOVERNOR'S OFFICE |
| LEGISLATURE, GOVENOR'S OFFICE AND ADMINISTRATION |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, INSURANCE COMMISSIONER, CALPERS AND STATE LEGISLATURE |
| LEGISLATURE, GOVERNOR'S OFFICE, LT. GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE, LEGISLATURE, LT. GOVERNOR'S OFFICE |
| LEGISLATURE, GOVENOR'S OFFICE AND ADMINISTRATION |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, STATE LEGISLATURE |
| LEGISLATURE, GOVERNOR'S OFFICE |
| GOVERNOR'S OFFICE AND RELATED EXECUTIVE AGENCIES, INSURANCE COMMISSIONER, CALPERS AND STATE LEGISLATURE |
descrip |
| GENERAL PUBLIC SAFETY AND PROBATION ISSUES; REALIGNMENT, BUDGET, FUNDING AND OTHER RELATED ISSUES |
| GENERAL ENERGY AND SOLAR ENERGY ISSUES; NET METERING, RENEWABLES PORTFOLIO STANDARD |
| GENERAL HEALTH CARE ISSUES |
| ISSUES REGARDING BROADCASTING CONTRACTS, THE ENTERTAINMENT INDUSTRY AND THE INTERNET |
| ISSUES RELATED TO TAXATION AND SALES TAX ALLOCATION |
| GENERAL HEALTH CARE ISSUES |
| ISSUES REGARDING BROADCASTING CONTRACTS, THE ENTERTAINMENT INDUSTRY AND THE INTERNET |
| ISSUES RELATED TO TAXATION AND SALES TAX ALLOCATION |
| GENERAL PUBLIC SAFETY AND PROBATION ISSUES; REALIGNMENT, BUDGET, FUNDING AND OTHER RELATED ISSUES |
| GENERAL ENERGY AND SOLAR ENERGY ISSUES; NET METERING, RENEWABLES PORTFOLIO STANDARD |
| ISSUES REGARDING BROADCASTING CONTRACTS, THE ENTERTAINMENT INDUSTRY AND THE INTERNET |
| ISSUES RELATED TO TAXATION AND SALES TAX ALLOCATION |
| GENERAL PUBLIC SAFETY AND PROBATION ISSUES; REALIGNMENT, BUDGET, FUNDING AND OTHER RELATED ISSUES |
| GENERAL ENERGY AND SOLAR ENERGY ISSUES; NET METERING, RENEWABLES PORTFOLIO STANDARD |
| RENEWABLE ENERGY, ROOFTOP SOLAR |
| GENERAL HEALTH CARE ISSUES |
| ISSUES REGARDING BROADCASTING CONTRACTS, THE ENTERTAINMENT INDUSTRY AND THE INTERNET |
| ISSUES RELATED TO TAXATION AND SALES TAX ALLOCATION |
| PUBLIC UTILITIES COMMISSION PENDING ACTION |
| GENERAL PUBLIC SAFETY AND PROBATION ISSUES; REALIGNMENT, BUDGET, FUNDING AND OTHER RELATED ISSUES |
| GENERAL ENERGY AND SOLAR ENERGY ISSUES; NET METERING, RENEWABLES PORTFOLIO STANDARD |
| GENERAL HEALTH CARE ISSUES |
| ISSUES REGARDING BROADCASTING CONTRACTS, THE ENTERTAINMENT INDUSTRY AND THE INTERNET |
| ISSUES RELATED TO TAXATION AND SALES TAX ALLOCATION |
| PUBLIC UTILITIES COMMISSION PENDING ACTION |
| GENERAL PUBLIC SAFETY AND PROBATION ISSUES; REALIGNMENT, BUDGET, FUNDING AND OTHER RELATED ISSUES |
| GENERAL ENERGY AND SOLAR ENERGY ISSUES; NET METERING, RENEWABLES PORTFOLIO STANDARD |
| RENEWABLE ENERGY, ROOFTOP SOLAR |
| GENERAL HEALTH CARE ISSUES |
subfirm_id |
| None |
| None |
| None |
| F24917 |
| F24917 |
| None |
| F24917 |
| F24917 |
| None |
| None |
| F24917 |
| F24917 |
| None |
| None |
| None |
| None |
| F24917 |
| F24917 |
| None |
| None |
| None |
| None |
| F24917 |
| F24917 |
| None |
| None |
| None |
| None |
| None |
sub_name |
| None |
| None |
| None |
| CAPITOL ADVOCACY, LLC |
| CAPITOL ADVOCACY, LLC |
| None |
| CAPITOL ADVOCACY, LLC |
| CAPITOL ADVOCACY, LLC |
| None |
| None |
| CAPITOL ADVOCACY, LLC |
| CAPITOL ADVOCACY, LLC |
| None |
| None |
| None |
| None |
| CAPITOL ADVOCACY, LLC |
| CAPITOL ADVOCACY, LLC |
| None |
| None |
| None |
| None |
| CAPITOL ADVOCACY, LLC |
| CAPITOL ADVOCACY, LLC |
| None |
| None |
| None |
| None |
| None |
sub_city |
| None |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| None |
| SACRAMENTO |
| SACRAMENTO |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| None |
| None |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| None |
| None |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| None |
| None |
| None |
| None |
| None |
sub_st |
| None |
| None |
| None |
| CA |
| CA |
| None |
| CA |
| CA |
| None |
| None |
| CA |
| CA |
| None |
| None |
| None |
| None |
| CA |
| CA |
| None |
| None |
| None |
| None |
| CA |
| CA |
| None |
| None |
| None |
| None |
| None |
sub_zip4 |
| None |
| None |
| None |
| 95814 |
| 95814 |
| None |
| 95814 |
| 95814 |
| None |
| None |
| 95814 |
| 95814 |
| None |
| None |
| None |
| None |
| 95814 |
| 95814 |
| None |
| None |
| None |
| None |
| 95814 |
| 95814 |
| None |
| None |
| None |
| None |
| None |
sub_phon |
| None |
| None |
| None |
| (916) 444-0400 |
| (916) 444-0400 |
| None |
| (916) 444-0400 |
| (916) 444-0400 |
| None |
| None |
| (916) 444-0400 |
| (916) 444-0400 |
| None |
| None |
| None |
| None |
| (916) 444-0400 |
| (916) 444-0400 |
| None |
| None |
| None |
| None |
| (916) 444-0400 |
| (916) 444-0400 |
| None |
| None |
| None |
| None |
| None |