Table: lemp
filing_id |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
| 1921208 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
line_item |
| 6 |
| 7 |
| 8 |
| 9 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 8 |
| 9 |
| 10 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 1 |
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 |
| 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 |
| C27190 |
| 1243894 |
| C00599 |
| C01417 |
| C00569 |
| C00087 |
| C00128 |
| C22979 |
| 1236649 |
| 1236649 |
| C27190 |
| 1243894 |
| C00569 |
| C00087 |
| C00128 |
| C22979 |
| C00599 |
| C01417 |
| C25770 |
| C00087 |
| C00128 |
| C22979 |
| 1236649 |
| C27190 |
| 1243894 |
| C00599 |
| C01417 |
| C25770 |
| C00569 |
cli_naml |
| Metal Finishing Association of Northern California |
| Professional Fiduciary Association of California |
| Metal Finishing Association of Southern California |
| California Association of Licensed Repossessors |
| California Coalition of Travel Organizations |
| Recreational Boaters of California |
| California Association of Licensed Investigators |
| Cemetery and Mortuary Association of California |
| Plumbing Manufacturers International |
| Plumbing Manufacturers International |
| Metal Finishing Association of Northern California |
| Professional Fiduciary Association of California |
| California Coalition of Travel Organizations |
| Recreational Boaters of California |
| California Association of Licensed Investigators |
| Cemetery and Mortuary Association of California |
| Metal Finishing Association of Southern California |
| California Association of Licensed Repossessors |
| California Real Estate Inspection Association Inc. |
| Recreational Boaters of California |
| California Association of Licensed Investigators |
| Cemetery and Mortuary Association of California |
| Plumbing Manufacturers International |
| Metal Finishing Association of Northern California |
| Professional Fiduciary Association of California |
| Metal Finishing Association of Southern California |
| California Association of Licensed Repossessors |
| California Real Estate Inspection Association Inc. |
| California Coalition of Travel Organizations |
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 |
| Burbank |
| Laguna Beach |
| Burbank |
| Reseda |
| Sacramento |
| Sacramento |
| Aliso Viejo |
| Sacramento |
| Rolling Meadows |
| Rolling Meadows |
| Burbank |
| Laguna Beach |
| Sacramento |
| Sacramento |
| Aliso Viejo |
| Sacramento |
| Burbank |
| Reseda |
| Aliso Viejo |
| Sacramento |
| Aliso Viejo |
| Sacramento |
| Rolling Meadows |
| Burbank |
| Laguna Beach |
| Burbank |
| Reseda |
| Aliso Viejo |
| Sacramento |
cli_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| IL |
| IL |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| IL |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
cli_zip4 |
| 91510 |
| 92651 |
| 91510 |
| 91335 |
| 95814 |
| 95814 |
| 92656 |
| 95814 |
| 60008 |
| 60008 |
| 91510 |
| 92651 |
| 95814 |
| 95814 |
| 92656 |
| 95814 |
| 91510 |
| 91335 |
| 92656 |
| 95814 |
| 92656 |
| 95814 |
| 60008 |
| 91510 |
| 92651 |
| 91510 |
| 91335 |
| 92656 |
| 95814 |
cli_phon |
| 877.238.9490 |
| 866.886.7322 |
| 877.238.9490 |
| 818-945-2257 |
| (916) 441-4166 |
| (916) 441-4166 |
| 949.715.5401 |
| 916-441-4533 |
| 847-481-5500 |
| 847-481-5500 |
| 877.238.9490 |
| 866.886.7322 |
| (916) 441-4166 |
| (916) 441-4166 |
| 949.715.5401 |
| 916-441-4533 |
| 877.238.9490 |
| 818-945-2257 |
| 800-848-7342 |
| (916) 441-4166 |
| 949.715.5401 |
| 916-441-4533 |
| 847-481-5500 |
| 877.238.9490 |
| 866.886.7322 |
| 877.238.9490 |
| 818-945-2257 |
| 800-848-7342 |
| (916) 441-4166 |
eff_date |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2016-08-22 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2014-12-01 00:00:00 |
| 2016-08-22 00:00:00 |
| 2014-12-01 00:00:00 |
con_period |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014-Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014-Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| 08/22/16 - 08/22/17 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| Dec 1 2014 - Dec 31 2016 |
| 08/22/16 - 08/22/17 |
| Dec 1 2014-Dec 31 2016 |
agencylist |
| Department of Toxic Substances Control Cal-OSHA State Water Resources Control Board Air Resources Board California Environmental Protection Agency Office of Environmental Health and Hazard Assessment |
| Department of Consumer Affairs Judicial Council |
| Department of Toxic Substances Control Cal-OSHA State Water Resources Control Board Air Resources Control Board of California Environmental Protection Agency Office of Environmental Health and Hazard |
| Department of Consumer Affairs Department of Motor Vehicles California Highway Patrol |
| Trade & Commerce Agency Dept. of Justice Dept. of Consumer Affairs and Department of Insurance |
| Division of Boating and Waterways Dept. of Motor Vehicles Dept. of Parks & Recreation Resources Agency Dept. of Finance State Water Resources Board California Coastal Commission State Lands Commission |
| Dept. of Consumer Affairs Dept. of Motor Vehicles Office of Privacy Protection State Compensation Insurance Fund |
| Dept. of Consumer Affairs Air Resources Board Department of Insurance |
| Department of Public Health Department of Housing and Community Development Department of Toxic Substances Control Building Standards Commission California Energy Commission Department of General Serv |
| Department of Public Health Department of Housing and Community Development Department of Toxic Substances Control Building Standards Commission California Energy Commission Department of General Serv |
| Department of Toxic Substances Control Cal-OSHA State Water Resources Control Board Air Resources Board California Environmental Protection Agency Office of Environmental Health and Hazard Assessment |
| Department of Consumer Affairs Judicial Council |
| Trade & Commerce Agency Dept. of Justice Dept. of Consumer Affairs and Department of Insurance |
| Division of Boating and Waterways Dept. of Motor Vehicles Dept. of Parks & Recreation Resources Agency Dept. of Finance State Water Resources Board California Coastal Commission State Lands Commission |
| Dept. of Consumer Affairs Dept. of Motor Vehicles Office of Privacy Protection State Compensation Insurance Fund |
| Dept. of Consumer Affairs Air Resources Board Department of Insurance |
| Department of Toxic Substances Control Cal-OSHA State Water Resources Control Board Air Resources Control Board of California Environmental Protection Agency Office of Environmental Health and Hazard |
| Department of Consumer Affairs Department of Motor Vehicles California Highway Patrol |
| None at this time |
| Division of Boating and Waterways Dept. of Motor Vehicles Dept. of Parks & Recreation Resources Agency Dept. of Finance State Water Resources Board California Coastal Commission State Lands Commission |
| Dept. of Consumer Affairs Dept. of Motor Vehicles Office of Privacy Protection State Compensation Insurance Fund |
| Dept. of Consumer Affairs Air Resources Board Department of Insurance |
| Department of Public Health Department of Housing and Community Development Department of Toxic Substances Control Building Standards Commission California Energy Commission Department of General Serv |
| Department of Toxic Substances Control Cal-OSHA State Water Resources Control Board Air Resources Board California Environmental Protection Agency Office of Environmental Health and Hazard Assessment |
| Department of Consumer Affairs Judicial Council |
| Department of Toxic Substances Control Cal-OSHA State Water Resources Control Board Air Resources Control Board of California Environmental Protection Agency Office of Environmental Health and Hazard |
| Department of Consumer Affairs Department of Motor Vehicles California Highway Patrol |
| Department of Water Resources |
| Trade & Commerce Agency Dept. of Justice Dept. of Consumer Affairs and Department of Insurance |
descrip |
| Legislation and regulations of interest to those involved in job shop metal finishing. |
| Legislation and regulations of interest to professional fiduciaries |
| Legislation and regulations of interest to those involved in job shop metal finishing |
| Legislation and regulations of interest to licensed repossessors. |
| Legislation and Regulations of interest to those involved in travel-related services. |
| Legislation and regulations of interest to those involved in recreational boating. |
| Legislation and regulations of interest to those involved in private investigation and security. |
| Legislation and Regulations of interest to cemeteries and mortuaries. |
| Legislation and regulations pertaining to the manufacture and sale of plumbing products. |
| Legislation and regulations pertaining to the manufacture and sale of plumbing products. |
| Legislation and regulations of interest to those involved in job shop metal finishing. |
| Legislation and regulations of interest to professional fiduciaries |
| Legislation and Regulations of interest to those involved in travel-related services. |
| Legislation and regulations of interest to those involved in recreational boating. |
| Legislation and regulations of interest to those involved in private investigation and security. |
| Legislation and Regulations of interest to cemeteries and mortuaries. |
| Legislation and regulations of interest to those involved in job shop metal finishing |
| Legislation and regulations of interest to licensed repossessors. |
| Legislation and regulations of interest to real estate inspectors. |
| Legislation and regulations of interest to those involved in recreational boating. |
| Legislation and regulations of interest to those involved in private investigation and security. |
| Legislation and Regulations of interest to cemeteries and mortuaries. |
| Legislation and regulations pertaining to the manufacture and sale of plumbing products. |
| Legislation and regulations of interest to those involved in job shop metal finishing. |
| Legislation and regulations of interest to professional fiduciaries |
| Legislation and regulations of interest to those involved in job shop metal finishing |
| Legislation and regulations of interest to licensed repossessors. |
| Legislation and regulations of interest to real estate inspectors. |
| Legislation and Regulations of interest to those involved in travel-related services. |
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 |
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 |
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 |
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 |
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 |
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 |