Table: lemp
filing_id |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
| 2112802 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 24 |
| 25 |
| 26 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
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 |
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 |
client_id |
| 1366767 |
| C22520 |
| E24746 |
| C21180 |
| C00343 |
| E00191 |
| E00243 |
| E24750 |
| C26266 |
| 1377354 |
| 1222747 |
| C23414 |
| 1288756 |
| C26137 |
| 1338299 |
| C27195 |
| C28236 |
| 1303334 |
| C21457 |
| E24530 |
| E23700 |
| E24113 |
| 1263449 |
| C27423 |
| 1367918 |
| C27633 |
cli_naml |
| AMERICAN BEVERAGE ASSOCIATION |
| CALIFORNIA ADULT EDUCATION ADMINISTRATORS ASSOCIATION |
| CALIFORNIA CORRECTIONAL PEACE OFFICERS ASSOCIATION (CCPOA) |
| CALIFORNIA COUNCIL FOR ADULT EDUCATION |
| CALIFORNIA COUNCIL FOR ENVIRONMENTAL AND ECONOMIC BALANCE |
| CALIFORNIA CREDIT UNION LEAGUE |
| CALIFORNIA MANUFACTURERS and TECHNOLOGY ASSOCIATION |
| CALIFORNIANS ALLIED FOR PATIENT PROTECTION |
| CALPORTLAND COMPANY |
| COVESTRO LLC |
| CRIME VICTIMS UNITED OF CALIFORNIA |
| STATE OF CALIFORNIA AUTO DISMANTLERS ASSOCIATION |
| STRATEGIC MATERIALS, INC. |
| THE CHILD ABUSE PREVENTION CENTER and ITS AFFILIATES SAFE KIDS CALIFORNIA, PREVENT CHILD ABUSE CALIFORNIA and THE CALIFORNIA FAMILY RESOURCE ASSOCIATION |
| CSAA INSURANCE EXCHANGE AND AFFILIATES |
| DISTILLED SPIRITS COUNCIL OF THE UNITED STATES |
| GEOVERA HOLDINGS, INC. |
| HARTFORD FINANCIAL SERVICES GROUP |
| INTERNATIONAL PAPER |
| JOHNSON & JOHNSON SERVICES, INC. AND AFFILIATED ENTITIES |
| KOCH COMPANIES PUBLIC SECTOR, LLC and AFFILIATES |
| NATIONAL ASSOCIATION OF INSURANCE AND FINANCIAL ADVISORS - CALIFORNIA |
| PACIFIC ASSOCIATION OF DOMESTIC INSURANCE COMPANIES |
| PECHANGA BAND OF LUISENO MISSION INDIANS |
| RETIRED EMPLOYEES OF KERN COUNTY |
| SHELL OIL PRODUCTS/SHELL OIL COMPANY & AFFILIATED ENTITIES |
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 |
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 |
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 |
cli_city |
| WASHINGTON |
| Montebello |
| West Sacramento |
| San Diego |
| San Francisco |
| Sacramento |
| Sacramento |
| Sacramento |
| Glendora |
| Washington |
| Auburn |
| Sacramento |
| Houston |
| North Highlands |
| Walnut Creek |
| Washington |
| Fairfield |
| Hartford |
| Washington DC |
| Sacramento |
| Portland |
| Cedar Falls |
| Sacramento |
| Temecula |
| BAKERSFIELD |
| Sacramento |
cli_st |
| DC |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| DC |
| CA |
| CA |
| TX |
| CA |
| CA |
| DC |
| CA |
| CT |
| DC |
| CA |
| OR |
| IA |
| CA |
| CA |
| CA |
| CA |
cli_zip4 |
| 20004 |
| 90640 |
| 95605 |
| 92116 |
| 94105-1744 |
| 95814 |
| 95814 |
| 95814 |
| 91741-4692 |
| 20004 |
| 95603 |
| 95821 |
| 77079 |
| 95660 |
| 94597 |
| 20005-3998 |
| 94534 |
| 06155 |
| 20004 |
| 95814 |
| 97213 |
| 50613 |
| 95814 |
| 92593 |
| 93303 |
| 95814 |
cli_phon |
| (202) 463-6707 |
| (323) 887-7900 ext. |
| (916) 372-6060 |
| (619) 991-1672 |
| (415) 512-7890 |
| (916) 325-1360 |
| (916) 441-5420 |
| (916) 448-7992 |
| (626) 852-6261 |
| 202-572-8615 |
| (530) 885-9544 |
| (916) 979-7088 |
| (281) 647-2784 |
| (916) 244-1976 |
| (925) 279-2463 |
| (202) 628-3544 |
| (707) 863-3604 |
| (860) 547-3348 |
| (202) 628-1223 |
| (916) 443-0104 |
| (503) 378-1576 |
| (844-536-9339 |
| None |
| (951) 676-2768 |
| (661) 330-4194 |
| (916) 443-0840 |
eff_date |
| 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 |
| 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 |
| 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 |
| 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 |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
agencylist |
| Governorb s Office, GoBiz, CalEPA, OEHHA and Legislature |
| Governor's Office, Legislature, Department of Education, Department of Finance, Legislative Analyst's Office, State Board Of Education, California Commission on Teacher Credentialing, Office of Pub |
| See attached memo - 601P2AAL0 |
| Governor's Office, Legislature, State Departments Of Education and Finance, State Allocation Board, State Board Of Education, Commission on Teacher Credentialing, Legislative Analyst |
| See attached memo - 601P2AAL1 |
| See attached memo - 601P2AAL3 |
| See attached memo - 601P2AAL4 |
| Governor's Office, Legislature |
| See attached memo - 601P2AAL5 |
| CalEPA, DTSC, OEHHA, Energy Commission |
| See attached memo - 601P2AAL6 |
| See attached memo - 601P2AAL13 |
| See attached memo - 601P2AAL15 |
| See attached memo - 601P2AAL16 |
| Governor's Office, Legislature, Department of Motor Vehicles (DMV) and Department of Insurance |
| Governor's Office, Legislature, Attorney General's Office, Alcoholic Beverage Control, Franchise Tax Board |
| Governor's Office, Legislature, Department of Insurance |
| Legislature, Administration, Department of Insurance, Department of Motor Vehicles, Department of Finance |
| See attached memo - 601P2AAL7 |
| See attached memo - 601P2AAL8 |
| See attached memo - 601P2AAL9 |
| Governor's Office, Legislature, Department of Insurance, State & Consumer Services Agency, Office of the Insurance Advisor |
| See attached memo - 601P2AAL11 |
| Legislature, Governors Office, Attorney General, Gaming Control Commission, Board of Equalization and Native American Heritage |
| Legislature, Department of Finance and Governor's Office |
| See attached memo - 601P2AAL12 |
descrip |
| National trade association of soft drinks sales, distribution and production |
| Adult Education issues |
| State employee & public safety issues |
| Legislation relating to public schools and students |
| See attached memo - 601P2AD2 |
| Credit Unions |
| Manufacturing, Technology, Aerospace and Employer issues |
| Medical and hospital issues |
| Issues pertaining to the manufacturing, marketing, and sale of cement products and services |
| Producer of plastics and polymer materials |
| Victims rights, notification, restitution, parole, and inmate issues |
| See attached memo - 601P2AD14 |
| Recycling, beverage recycling issues and funding |
| Child abuse prevention and intervention |
| Insurance related issues |
| Issues affecting distilled spirits producers/marketers and the products they each control |
| Earthquake insurance and general related insurance issues |
| Insurance |
| Manufacturing, distribution, and sale of paper, plastic, and building products |
| Pertaining to manufacturing & sale of pharmaceuticals, medical devices, and personal care products |
| See attached memo - 601P2AD10 |
| Insurance agents and brokers issues; financial services |
| Insurance and financial services |
| Legislation and regulations impacting California's Indian tribes. |
| Public employee retirement and benefits, state budget, 1937 act counties. |
| Refining, Marketing and transportation of Petroleum Products |
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 |
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 |
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 |
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 |
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 |
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 |