Table: lemp
filing_id |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
| 1922137 |
amend_id |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
line_item |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 7 |
| 8 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 1 |
| 2 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
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 |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
| LEMP |
form_type |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
client_id |
| C28152 |
| 1319548 |
| C20083 |
| C23969 |
| C24039 |
| C00862 |
| None |
| C24039 |
| C00862 |
| 1231940 |
| C27370 |
| C28152 |
| 1319548 |
| C20083 |
| C23969 |
| 1231940 |
| C27370 |
| 1231940 |
| C27370 |
| C28152 |
| 1319548 |
| C20083 |
| C23969 |
| C24039 |
| C00862 |
| None |
| 1231940 |
| C27370 |
| C28152 |
| 1319548 |
| C20083 |
| C23969 |
| C24039 |
| C00862 |
| None |
| None |
cli_naml |
| Exxon Mobil Corporation |
| General Motors LLC |
| RAI Services Company and its Affiliates |
| Southern Wine & Spirits of America, Inc. |
| West Coast Chapter - Institute of Scrap Recycling Industries, aka CA ISRI |
| Wine & Spirits Wholesalers of California |
| Les Schwab Warehouses, Inc. |
| West Coast Chapter - Institute of Scrap Recycling Industries, aka CA ISRI |
| Wine & Spirits Wholesalers of California |
| CGI Technologies & Solutions, Inc. |
| Continental Casualty Company (CNA Insurance Companies) |
| Exxon Mobil Corporation |
| General Motors LLC |
| RAI Services Company and its Affiliates |
| Southern Wine & Spirits of America, Inc. |
| CGI Technologies & Solutions, Inc. |
| Continental Casualty Company (CNA Insurance Companies) |
| CGI Technologies & Solutions, Inc. |
| Continental Casualty Company (CNA Insurance Companies) |
| Exxon Mobil Corporation |
| General Motors LLC |
| RAI Services Company and its Affiliates |
| Southern Wine & Spirits of America, Inc. |
| West Coast Chapter - Institute of Scrap Recycling Industries, aka CA ISRI |
| Wine & Spirits Wholesalers of California |
| Les Schwab Warehouses, Inc. |
| CGI Technologies & Solutions, Inc. |
| Continental Casualty Company (CNA Insurance Companies) |
| Exxon Mobil Corporation |
| General Motors LLC |
| RAI Services Company and its Affiliates |
| Southern Wine & Spirits of America, Inc. |
| West Coast Chapter - Institute of Scrap Recycling Industries, aka CA ISRI |
| Wine & Spirits Wholesalers of California |
| Les Schwab Warehouses, Inc. |
| Scientific Games International, 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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_city |
| Sacramento |
| Washington |
| Winston-Salem |
| Miami |
| Oakland |
| Carmichael |
| Bend |
| Oakland |
| Carmichael |
| Sacramento |
| Chicago |
| Sacramento |
| Washington |
| Winston-Salem |
| Miami |
| Sacramento |
| Chicago |
| Sacramento |
| Chicago |
| Sacramento |
| Washington |
| Winston-Salem |
| Miami |
| Oakland |
| Carmichael |
| Bend |
| Sacramento |
| Chicago |
| Sacramento |
| Washington |
| Winston-Salem |
| Miami |
| Oakland |
| Carmichael |
| Bend |
| Alpharetta |
cli_st |
| CA |
| DC |
| NC |
| FL |
| CA |
| CA |
| OR |
| CA |
| CA |
| CA |
| IL |
| CA |
| DC |
| NC |
| FL |
| CA |
| IL |
| CA |
| IL |
| CA |
| DC |
| NC |
| FL |
| CA |
| CA |
| OR |
| CA |
| IL |
| CA |
| DC |
| NC |
| FL |
| CA |
| CA |
| OR |
| GA |
cli_zip4 |
| 95814 |
| 20001 |
| 27102 |
| 33169 |
| 94607 |
| 95608 |
| 97701 |
| 94607 |
| 95608 |
| 95814 |
| 60685 |
| 95814 |
| 20001 |
| 27102 |
| 33169 |
| 95814 |
| 60685 |
| 95814 |
| 60685 |
| 95814 |
| 20001 |
| 27102 |
| 33169 |
| 94607 |
| 95608 |
| 97701 |
| 95814 |
| 60685 |
| 95814 |
| 20001 |
| 27102 |
| 33169 |
| 94607 |
| 95608 |
| 97701 |
| 30004 |
cli_phon |
| (916) 444-7858 |
| (202) 775-5056 |
| (910) 741-2739 |
| (305) 625-4171 |
| (510) 893-6476 |
| (916) 944-1470 |
| (541) 416-5231 |
| 510-893-6476 |
| 916-944-1470 |
| 916-283-2001 |
| 312-822-1740 |
| 916-444-7858 |
| 202-775-5056 |
| 910-741-2739 |
| 305-625-4171 |
| (916) 283-2001 |
| (312) 822-1740 |
| (916) 283-2001 |
| (312) 822-1740 |
| (916) 444-7858 |
| (202) 775-5056 |
| (910) 741-2739 |
| (305) 625-4171 |
| (510) 893-6476 |
| (916) 944-1470 |
| (541) 416-5231 |
| (916) 283-2001 |
| (312) 822-1740 |
| (916) 444-7858 |
| (202) 775-5056 |
| (910) 741-2739 |
| (305) 625-4171 |
| (510) 893-6476 |
| (916) 944-1470 |
| (541) 416-5231 |
| (770) 664-3700 |
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-15 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-15 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-15 00:00:00 |
| 2016-01-21 00:00:00 |
con_period |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
| Unknown |
agencylist |
| Governor, Legislature, CA Air Resources Board, CAL-EPA |
| Governor, Legislature |
| Governor, Legislature, CAL-EPA |
| Governor, Legislature |
| Governor, Legislature, Dept of Conservation, Integrated Waste Mgmt Bd, Dept of Toxic Substances Control, State Watere Resources Control Board |
| Governor, Legislature |
| Legislature, Governor, CalEPA, CA Air Resources Board, State & Consumer Services Agency, Bureau of Automatic Repair |
| Governor, Legislature, Dept of Conservation, Integrated Waste Mgmt Bd, Dept of Toxic Substances Control, State Watere Resources Control Board |
| Governor, Legislature |
| Department of General Services |
| Governor, Legislature, Department of Insurance |
| Governor, Legislature, CA Air Resources Board, CAL-EPA |
| Governor, Legislature |
| Governor, Legislature, CAL-EPA |
| Governor, Legislature |
| Department of General Services |
| Governor, Legislature, Department of Insurance |
| Department of General Services |
| Governor, Legislature, Department of Insurance |
| Governor, Legislature, CA Air Resources Board, CAL-EPA |
| Governor, Legislature |
| Governor, Legislature, CAL-EPA |
| Governor, Legislature |
| Governor, Legislature, Dept of Conservation, Integrated Waste Mgmt Bd, Dept of Toxic Substances Control, State Watere Resources Control Board |
| Governor, Legislature |
| Legislature, Governor, CalEPA, CA Air Resources Board, State & Consumer Services Agency, Bureau of Automatic Repair |
| Department of General Services |
| Governor, Legislature, Department of Insurance |
| Governor, Legislature, CA Air Resources Board, CAL-EPA |
| Governor, Legislature |
| Governor, Legislature, CAL-EPA |
| Governor, Legislature |
| Governor, Legislature, Dept of Conservation, Integrated Waste Mgmt Bd, Dept of Toxic Substances Control, State Watere Resources Control Board |
| Governor, Legislature |
| Legislature, Governor, CalEPA, CA Air Resources Board, State & Consumer Services Agency, Bureau of Automatic Repair |
| Legislature, Governor |
descrip |
| Exploration, production, refining, mfg, marketing of petroleum, chemical & related products |
| Manufacturing of automobile vehicles, including distribution and financing |
| Manufacture and sale of tobacco products |
| Sale of alcoholic beverages |
| Scrap and solid waste recycling |
| Sale of alcohol beverages |
| Issues relating to automotive and truck repair |
| Scrap and solid waste recycling |
| Sale of alcohol beverages |
| Information Technology |
| Insurance Issues |
| Exploration, production, refining, mfg, marketing of petroleum, chemical & related products |
| Manufacturing of automobile vehicles, including distribution and financing |
| Manufacture and sale of tobacco products |
| Sale of alcoholic beverages |
| Information Technology |
| Insurance Issues |
| Information Technology |
| Insurance Issues |
| Exploration, production, refining, mfg, marketing of petroleum, chemical & related products |
| Manufacturing of automobile vehicles, including distribution and financing |
| Manufacture and sale of tobacco products |
| Sale of alcoholic beverages |
| Scrap and solid waste recycling |
| Sale of alcohol beverages |
| Issues relating to automotive and truck repair |
| Information Technology |
| Insurance Issues |
| Exploration, production, refining, mfg, marketing of petroleum, chemical & related products |
| Manufacturing of automobile vehicles, including distribution and financing |
| Manufacture and sale of tobacco products |
| Sale of alcoholic beverages |
| Scrap and solid waste recycling |
| Sale of alcohol beverages |
| Issues relating to automotive and truck repair |
| Gaming |
subfirm_id |
| 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 |
sub_name |
| 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 |
sub_city |
| 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 |
sub_st |
| 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 |
sub_zip4 |
| 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 |
sub_phon |
| 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 |