Table: lemp
filing_id |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
| 2115444 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 2 |
| 2 |
| 2 |
| 2 |
line_item |
| 3 |
| 4 |
| 1 |
| 2 |
| 1 |
| 2 |
| 3 |
| 4 |
| 1 |
| 2 |
| 3 |
| 4 |
rec_type |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
form_type |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
client_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_naml |
| California Compost Coalition |
| Zanker Road Landfill |
| Turlock Scavennger Company |
| Turlock Scavennger Company |
| Turlock Scavennger Company |
| Turlock Scavennger Company |
| California Compost Coalition |
| Zanker Road Landfill |
| California Compost Coalition |
| Zanker Road Landfill |
| Turlock Scavennger Company |
| Turlock Scavennger Company |
cli_namf |
| 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 |
cli_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_city |
| Sacramento |
| San Jose |
| Turlock |
| Turlock |
| Turlock |
| Turlock |
| Sacramento |
| San Jose |
| Sacramento |
| San Jose |
| Turlock |
| Turlock |
cli_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
cli_zip4 |
| 95811 |
| 95122 |
| 95381 |
| 95381 |
| 95381 |
| 95381 |
| 95811 |
| 95122 |
| 95811 |
| 95122 |
| 95381 |
| 95381 |
cli_phon |
| 916-739-1200 |
| 408-283-4821 |
| 209-668-7274 |
| 209-668-7274 |
| 209-668-7274 |
| 209-668-7274 |
| 916-739-1200 |
| 408-283-4821 |
| 916-739-1200 |
| 408-283-4821 |
| 209-668-7274 |
| 209-668-7274 |
eff_date |
| 2017-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
| 2017-01-01 00:00:00 |
con_period |
| 01/01/2017-12/31/2018 |
| 01/01/2017-12/31/2018 |
| 01/01/2015-12/31/2016 |
| 01/01/2017-12/31/2018 |
| 01/01/2015-12/31/2016 |
| 01/01/2017-12/31/2018 |
| 01/01/2017-12/31/2018 |
| 01/01/2017-12/31/2018 |
| 01/01/2017-12/31/2018 |
| 01/01/2017-12/31/2018 |
| 01/01/2017-12/31/2018 |
| 01/01/2017-12/31/2018 |
agencylist |
| Governor's Office Legislature CA Dept. of Food and AgricultureCal EPA and its Boards CalRecycle; California Energy Commission |
| Cal EPA and its Boards CalRecycle; California Energy Commission;Public Utilities Commission; California Dept. of Food and Agriculture |
| CARB San Joaquin Air pollution Control District |
| Cal EPA and its Boards CalRecycle CARB; California Energy Commission; San Joaquin Air Pollution Control District |
| CARB San Joaquin Air pollution Control District |
| Cal EPA and its Boards CalRecycle CARB; California Energy Commission; San Joaquin Air Pollution Control District |
| Governor's Office Legislature CA Dept. of Food and AgricultureCal EPA and its Boards CalRecycle; California Energy Commission |
| Cal EPA and its Boards CalRecycle; California Energy Commission;Public Utilities Commission; California Dept. of Food and Agriculture |
| Governor's Office Legislature CA Dept. of Food and AgricultureCal EPA and its Boards CalRecycle; California Energy Commission |
| Cal EPA and its Boards CalRecycle; California Energy Commission;Public Utilities Commission; California Dept. of Food and Agriculture |
| Cal EPA and its boards CalRecycle CEC CARB San Joaquin Air pollution Control District |
| Cal EPA and its Boards CalRecycle CARB; California Energy Commission; San Joaquin Air Pollution Control District |
descrip |
| Legislative and Regulatory Actions on behalf of Compost Industry |
| Legislative and Regulatory Actions affecting Solid Waste Recycling and Composting biomass wood util |
| CARB and all 35 Air Pollution Control and Air Quality Mgmt Districts |
| Legislative and Regulatory Actions affecting Solid Waste Recycling and Composting biomass wood util |
| CARB and all 35 Air Pollution Control and Air Quality Mgmt Districts |
| Legislative and Regulatory Actions affecting Solid Waste Recycling and Composting biomass wood util |
| Legislative and Regulatory Actions on behalf of Compost Industry |
| Legislative and Regulatory Actions affecting Solid Waste Recycling and Composting biomass wood util |
| Legislative and Regulatory Actions on behalf of Compost Industry |
| Legislative and Regulatory Actions affecting Solid Waste Recycling and Composting biomass wood util |
| Legislative and Regulatory Actions affecting Solid Waste Recycling and Composting biomass wood util |
| Legislative and Regulatory Actions affecting Solid Waste Recycling and Composting biomass wood util |
subfirm_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sub_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sub_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sub_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sub_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sub_phon |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |