Table: lemp
filing_id |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
| 1915538 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
line_item |
| 10 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
rec_type |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
form_type |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2B |
client_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_naml |
| Lennox International |
| Caterpillar, Inc. |
| California Surety Federation |
| Marina Recreation Association |
| California Association of Harbor Masters and Port Captains |
| National Marine Manufacturers Association |
| California Yacht Brokers Association |
| Worldwide Boaters Safety Group |
| Financial Services Institute C/O Multistate Associates, Inc. |
| Turlock Irrigation District |
| Caterpillar, Inc. |
| California Surety Federation |
| Marina Recreation Association |
| California Association of Harbor Masters and Port Captains |
| National Marine Manufacturers Association |
| California Yacht Brokers Association |
| Worldwide Boaters Safety Group |
| Financial Services Institute C/O Multistate Associates, Inc. |
| Turlock Irrigation District |
| Lennox International |
| SC Johnson and Son |
cli_namf |
| 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 |
cli_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_city |
| Richardson |
| Springfield |
| Sacramento |
| Sacramento |
| Monterey |
| Washington |
| Oakland |
| Stockton |
| Alexandria |
| Turlock |
| Springfield |
| Sacramento |
| Sacramento |
| Monterey |
| Washington |
| Oakland |
| Stockton |
| Alexandria |
| Turlock |
| Richardson |
| Racine |
cli_st |
| TX |
| IL |
| CA |
| CA |
| CA |
| DC |
| CA |
| CA |
| VA |
| CA |
| IL |
| CA |
| CA |
| CA |
| DC |
| CA |
| CA |
| VA |
| CA |
| TX |
| WI |
cli_zip4 |
| 75080 |
| 62704 |
| 95814 |
| 95814 |
| 93940 |
| 20001 |
| 94606 |
| 95203 |
| 22314 |
| 95381 |
| 62704 |
| 95814 |
| 95814 |
| 93940 |
| 20001 |
| 94606 |
| 95203 |
| 22314 |
| 95381 |
| 75080 |
| 53403 |
cli_phon |
| (972) 497-6218 |
| (217) 753-8050 |
| (916) 447-8300 |
| (916) 441-1475 |
| (925) 779-6957 |
| (202) 737-9750 |
| (800) 875-2922 |
| (209) 384-3034 |
| (703) 684-1110 |
| (209) 882-8214 |
| (217) 753-8050 |
| (916) 447-8300 |
| (916) 441-1475 |
| (925) 779-6957 |
| (202) 737-9750 |
| (800) 875-2922 |
| (209) 384-3034 |
| (703) 684-1110 |
| (209) 882-8214 |
| (972) 497-6218 |
| (262) 260-2493 |
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 |
| 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-12-01 00:00:00 |
con_period |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| On going |
| on going |
agencylist |
| Legislature; Governor; California Energy Commission; California Air Resources Board; California Public Utilities Commission; SEE ATTACHMENT: A635EC90 |
| Legislature; Governor; State Transportation Agency; Caltrans; Health and Welfare Agency; California Public Utilities Commission; California Energy Commission; SEE ATTACHMENT: A02B4F30 |
| Legislature; Governor; California State Transportation Agency; Caltrans; Department of Insurance; Department of General Services SEE ATTACHMENT: AD1CA8DD |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: A04D3AD3 |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: A9AA904D |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: AF88BAFB |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: AD4F4B48 |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: AA51CB00 |
| Legislature; Governor; California Department of Business Oversight; Business, Consumer Services and Housing Agency |
| Legislature; Governor; California Environmental Protection Agency; Natural Resources Agency; SEE ATTACHMENT: A73CF304 |
| Legislature; Governor; State Transportation Agency; Caltrans; Health and Welfare Agency; California Public Utilities Commission; California Energy Commission; SEE ATTACHMENT: A02B4F30 |
| Legislature; Governor; California State Transportation Agency; Caltrans; Department of Insurance; Department of General Services SEE ATTACHMENT: AD1CA8DD |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: A04D3AD3 |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: A9AA904D |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: AF88BAFB |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: AD4F4B48 |
| Legislature; Governor; Department of Parks and Recreation; Department of Pesticide Regulation; California Air Resources Board; SEE ATTACHMENT: AA51CB00 |
| Legislature; Governor; California Department of Business Oversight; Business, Consumer Services and Housing Agency |
| Legislature; Governor; California Environmental Protection Agency; Natural Resources Agency; SEE ATTACHMENT: A73CF304 |
| Legislature; Governor; California Energy Commission; California Air Resources Board; California Public Utilities Commission; SEE ATTACHMENT: A635EC90 |
| Governor, Legislature |
descrip |
| Legislation and regulations affecting the HVAC industry. SEE ATTACHMENT: I635EC90 |
| Legislation and regulations affecting diesel emissions, transportation SEE ATTACHMENT: I02B4F30 |
| Legislation and regulations affecting the surety bond industry |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting the financial services industry. |
| Legislation and regulations affecting electric and water utilities. |
| Legislation and regulations affecting diesel emissions, transportation SEE ATTACHMENT: I02B4F30 |
| Legislation and regulations affecting the surety bond industry |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting marinas and boating |
| Legislation and regulations affecting the financial services industry. |
| Legislation and regulations affecting electric and water utilities. |
| Legislation and regulations affecting the HVAC industry. SEE ATTACHMENT: I635EC90 |
| Consumer Products Labeling |
subfirm_id |
| F24082 |
| F00024 |
| F00024 |
| F24082 |
| F24082 |
| F24082 |
| F24082 |
| F24082 |
| F00024 |
| F24082 |
| F00024 |
| F00024 |
| F24082 |
| F24082 |
| F24082 |
| F24082 |
| F24082 |
| F00024 |
| F24082 |
| F24082 |
| 1344250 |
sub_name |
| The Apex Group |
| Gladfelty Government Relations |
| Gladfelty Government Relations |
| The Apex Group |
| The Apex Group |
| The Apex Group |
| The Apex Group |
| The Apex Group |
| Gladfelty Government Relations |
| The Apex Group |
| Gladfelty Government Relations |
| Gladfelty Government Relations |
| The Apex Group |
| The Apex Group |
| The Apex Group |
| The Apex Group |
| The Apex Group |
| Gladfelty Government Relations |
| The Apex Group |
| The Apex Group |
| Gladfelty Government Relations |
sub_city |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
sub_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
sub_zip4 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
sub_phon |
| (916) 444-3116 |
| (916) 447-8300 |
| (916) 447-8300 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 447-8300 |
| (916) 444-3116 |
| (916) 447-8300 |
| (916) 447-8300 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 447-8300 |
| (916) 444-3116 |
| (916) 444-3116 |
| (916) 447-8300 |