Table: lemp
filing_id |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
| 2538913 |
amend_id |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 3 |
| 3 |
| 3 |
| 3 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
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 |
form_type |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2B |
client_id |
| 1342433 |
| C01189 |
| 1223580 |
| 1275537 |
| E00581 |
| 1258258 |
| None |
| 1342433 |
| C01189 |
| 1223580 |
| 1275537 |
| E00581 |
| 1258258 |
| None |
| 1342433 |
| C01189 |
| 1223580 |
| 1275537 |
| 1342433 |
| C01189 |
| 1223580 |
| 1275537 |
| 1258258 |
| None |
cli_naml |
| LIBERTY UTILITIES |
| CALIFORNIA WATER ASSOCIATION |
| CENTRAL BASIN WATER ASSOCIATION |
| OLIVENHAIN MUNICIPAL WATER DISTRICT |
| LOS ANGELES CITY OF |
| SAN FRANCISCO BAY AREA WATER EMERGENCY TRANSPORTATION AUTHORITY |
| VENTURA WATER (A DEPARTMENT OF THE CITY OF SAN BUENAVENTURA) |
| LIBERTY UTILITIES |
| CALIFORNIA WATER ASSOCIATION |
| CENTRAL BASIN WATER ASSOCIATION |
| OLIVENHAIN MUNICIPAL WATER DISTRICT |
| LOS ANGELES CITY OF |
| SAN FRANCISCO BAY AREA WATER EMERGENCY TRANSPORTATION AUTHORITY |
| VENTURA WATER (A DEPARTMENT OF THE CITY OF SAN BUENAVENTURA) |
| LIBERTY UTILITIES |
| CALIFORNIA WATER ASSOCIATION |
| CENTRAL BASIN WATER ASSOCIATION |
| OLIVENHAIN MUNICIPAL WATER DISTRICT |
| LIBERTY UTILITIES |
| CALIFORNIA WATER ASSOCIATION |
| CENTRAL BASIN WATER ASSOCIATION |
| OLIVENHAIN MUNICIPAL WATER DISTRICT |
| SAN FRANCISCO BAY AREA WATER EMERGENCY TRANSPORTATION AUTHORITY |
| VENTURA WATER (A DEPARTMENT OF THE CITY OF SAN BUENAVENTURA) |
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 |
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 |
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 |
cli_city |
| DOWNEY |
| SAN FRANCISCO |
| AZUSA |
| ENCINITAS |
| LOS ANGELES |
| SAN FRANCISCO |
| VENTURA |
| DOWNEY |
| SAN FRANCISCO |
| AZUSA |
| ENCINITAS |
| LOS ANGELES |
| SAN FRANCISCO |
| VENTURA |
| DOWNEY |
| SAN FRANCISCO |
| AZUSA |
| ENCINITAS |
| DOWNEY |
| SAN FRANCISCO |
| AZUSA |
| ENCINITAS |
| SAN FRANCISCO |
| VENTURA |
cli_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
cli_zip4 |
| 90241 |
| 94102 |
| 91702 |
| 92024 |
| 90012 |
| 94111 |
| 93001 |
| 90241 |
| 94102 |
| 91702 |
| 92024 |
| 90012 |
| 94111 |
| 93001 |
| 90241 |
| 94102 |
| 91702 |
| 92024 |
| 90241 |
| 94102 |
| 91702 |
| 92024 |
| 94111 |
| 93001 |
cli_phon |
| 562-299-5155 |
| 415-561-9650 |
| 626-815-1300 |
| 760-753-6466 |
| 213-978-0600 |
| 415-291-3377 |
| 805-652-4518 |
| 562-299-5155 |
| 415-561-9650 |
| 626-815-1300 |
| 760-753-6466 |
| 213-978-0600 |
| 415-291-3377 |
| 805-652-4518 |
| 562-299-5155 |
| 415-561-9650 |
| 626-815-1300 |
| 760-753-6466 |
| 562-299-5155 |
| 415-561-9650 |
| 626-815-1300 |
| 760-753-6466 |
| 415-291-3377 |
| 805-652-4518 |
eff_date |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
| 2021-01-01 00:00:00 |
con_period |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN. |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN. |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN. |
| OPEN |
agencylist |
| GOVERNOR; LEGISLATURE; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD. |
| GOVERNOR; LEGISLATURE; ENERGY COMMISSION; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; ENERGY COMMISSION; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; STATE LANDS COMMISSION; ENVIRONMENTAL PROTECTION AGENCY; AIR RESOURCES BOARD. |
| GOVERNOR; LEGISLATURE. |
| Department of Fish & Wildlife; Resources Agency; Governor; Legislature; State Water Resources Control Board. |
| GOVERNOR; LEGISLATURE; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD. |
| GOVERNOR; LEGISLATURE; ENERGY COMMISSION; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; ENERGY COMMISSION; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; STATE LANDS COMMISSION; ENVIRONMENTAL PROTECTION AGENCY; AIR RESOURCES BOARD. |
| GOVERNOR; LEGISLATURE. |
| Department of Fish & Wildlife; Resources Agency; Governor; Legislature; State Water Resources Control Board. |
| GOVERNOR; LEGISLATURE; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD. |
| GOVERNOR; LEGISLATURE; ENERGY COMMISSION; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; ENERGY COMMISSION; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD. |
| GOVERNOR; LEGISLATURE; ENERGY COMMISSION; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; ENERGY COMMISSION; PUBLIC UTILITIES COMMISSION; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE; STATE WATER RESOURCES CONTROL BOARD; DEPARTMENT OF WATER RESOURCES. |
| GOVERNOR; LEGISLATURE. |
| Department of Fish & Wildlife; Resources Agency; Governor; Legislature; State Water Resources Control Board. |
descrip |
| LEGISLATION PERTAINING TO RETAIL WATER SUPPLIERS. |
| PUBLIC UTILITIES; WATER SUPPLY; WATER QUALITY; PUC REGULATIONS. |
| MATTERS PERTAINING TO WATER SUPPLY. |
| WATER POLICY AND REGULATORY AFFAIRS. |
| LEGISLATION AND REGULATIONS IMPACTING PORT OF LOS ANGELES. |
| ISSUES RELATED TO WETA'S MISSION TO PROVIDE AND EXPAND FERRY SERVICE IN THE REGION. |
| Ventura River |
| LEGISLATION PERTAINING TO RETAIL WATER SUPPLIERS. |
| PUBLIC UTILITIES; WATER SUPPLY; WATER QUALITY; PUC REGULATIONS. |
| MATTERS PERTAINING TO WATER SUPPLY. |
| WATER POLICY AND REGULATORY AFFAIRS. |
| LEGISLATION AND REGULATIONS IMPACTING PORT OF LOS ANGELES. |
| ISSUES RELATED TO WETA'S MISSION TO PROVIDE AND EXPAND FERRY SERVICE IN THE REGION. |
| Ventura River |
| LEGISLATION PERTAINING TO RETAIL WATER SUPPLIERS. |
| PUBLIC UTILITIES; WATER SUPPLY; WATER QUALITY; PUC REGULATIONS. |
| MATTERS PERTAINING TO WATER SUPPLY. |
| WATER POLICY AND REGULATORY AFFAIRS. |
| LEGISLATION PERTAINING TO RETAIL WATER SUPPLIERS. |
| PUBLIC UTILITIES; WATER SUPPLY; WATER QUALITY; PUC REGULATIONS. |
| MATTERS PERTAINING TO WATER SUPPLY. |
| WATER POLICY AND REGULATORY AFFAIRS. |
| ISSUES RELATED TO WETA'S MISSION TO PROVIDE AND EXPAND FERRY SERVICE IN THE REGION. |
| Ventura River |
subfirm_id |
| None |
| None |
| None |
| F00369 |
| F00369 |
| F00369 |
| F00369 |
| None |
| None |
| None |
| F00369 |
| F00369 |
| F00369 |
| F00369 |
| None |
| None |
| None |
| F00369 |
| None |
| None |
| None |
| F00369 |
| F00369 |
| F00369 |
sub_name |
| None |
| None |
| None |
| NOSSAMAN LLP |
| NOSSAMAN |
| NOSSAMAN LLP |
| NOSSAMAN LLP |
| None |
| None |
| None |
| NOSSAMAN LLP |
| NOSSAMAN |
| NOSSAMAN LLP |
| NOSSAMAN LLP |
| None |
| None |
| None |
| NOSSAMAN LLP |
| None |
| None |
| None |
| NOSSAMAN LLP |
| NOSSAMAN LLP |
| NOSSAMAN LLP |
sub_city |
| None |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| None |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| None |
| None |
| None |
| SACRAMENTO |
| None |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
sub_st |
| None |
| None |
| None |
| CA |
| CA |
| CA |
| CA |
| None |
| None |
| None |
| CA |
| CA |
| CA |
| CA |
| None |
| None |
| None |
| CA |
| None |
| None |
| None |
| CA |
| CA |
| CA |
sub_zip4 |
| None |
| None |
| None |
| 95814 |
| 95814 |
| 95814 |
| 95914 |
| None |
| None |
| None |
| 95814 |
| 95814 |
| 95814 |
| 95914 |
| None |
| None |
| None |
| 95814 |
| None |
| None |
| None |
| 95814 |
| 95814 |
| 95914 |
sub_phon |
| None |
| None |
| None |
| 916-442-8888 |
| 9164428888 |
| 9164428888 |
| 916-442-8888 |
| None |
| None |
| None |
| 916-442-8888 |
| 9164428888 |
| 9164428888 |
| 916-442-8888 |
| None |
| None |
| None |
| 916-442-8888 |
| None |
| None |
| None |
| 916-442-8888 |
| 9164428888 |
| 916-442-8888 |