Table: lemp
filing_id |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
| 1922391 |
amend_id |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
line_item |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| E22985 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| E22985 |
| None |
| None |
| None |
| None |
| E22985 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_naml |
| NESTLE USA INC |
| CARGILL |
| BEEPI INC |
| SUNPOWER CORPORATION |
| VALLEY CAN (CLEAN AIR NOW) |
| CALIFORNIA BUILDING INDSUTRY ASSOCIATION |
| JELD-WEN |
| NESTLE WATERS NORTH AMERICA INC |
| VENOCO INC |
| AIR LIQUIDE USA LLC |
| NESTLE USA INC |
| CARGILL |
| BEEPI INC |
| CALIFORNIA BUILDING INDSUTRY ASSOCIATION |
| JELD-WEN |
| NESTLE WATERS NORTH AMERICA INC |
| VENOCO INC |
| AIR LIQUIDE USA LLC |
| CALIFORNIA BUILDING INDSUTRY ASSOCIATION |
| JELD-WEN |
| NESTLE WATERS NORTH AMERICA INC |
| VENOCO INC |
| AIR LIQUIDE USA LLC |
| NESTLE USA INC |
| CARGILL |
| BEEPI INC |
| SUNPOWER CORPORATION |
| VALLEY CAN (CLEAN AIR NOW) |
| Flurish Inc. dba LendUp |
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 |
| WASHINGTON |
| WAYZATA |
| LOS ALTOS |
| RICHMOND |
| SACRAMENTO |
| SACRAMENTO |
| PORTLAND |
| STAMFORD |
| CARPENTERIA |
| HOUSTON |
| WASHINGTON |
| WAYZATA |
| LOS ALTOS |
| SACRAMENTO |
| PORTLAND |
| STAMFORD |
| CARPENTERIA |
| HOUSTON |
| SACRAMENTO |
| PORTLAND |
| STAMFORD |
| CARPENTERIA |
| HOUSTON |
| WASHINGTON |
| WAYZATA |
| LOS ALTOS |
| RICHMOND |
| SACRAMENTO |
| SAN FRANCISCO |
cli_st |
| DC |
| MN |
| CA |
| CA |
| CA |
| CA |
| OR |
| CT |
| CA |
| TX |
| DC |
| MN |
| CA |
| CA |
| OR |
| CT |
| CA |
| TX |
| CA |
| OR |
| CT |
| CA |
| TX |
| DC |
| MN |
| CA |
| CA |
| CA |
| CA |
cli_zip4 |
| 20036 |
| 55440 |
| 94022 |
| 94804 |
| 95814 |
| 95814 |
| 97201 |
| 06902-1138 |
| 93013 |
| 77056 |
| 20036 |
| 55440 |
| 94022 |
| 95814 |
| 97201 |
| 06902-1138 |
| 93013 |
| 77056 |
| 95814 |
| 97201 |
| 06902-1138 |
| 93013 |
| 77056 |
| 20036 |
| 55440 |
| 94022 |
| 94804 |
| 95814 |
| 94108 |
cli_phon |
| 202-756-2489 |
| 952-742-6780 |
| 888-542-3374 |
| 510-260-8552 |
| 916-273-8886 |
| 916.443.7933 |
| 503.412.4269 |
| 203-817-3303 |
| 805-745-1816 |
| 713-624-8023 |
| 202-756-2489 |
| 952-742-6780 |
| 888-542-3374 |
| 916.443.7933 |
| 503.412.4269 |
| 203-817-3303 |
| 805-745-1816 |
| 713-624-8023 |
| 916.443.7933 |
| 503.412.4269 |
| 203-817-3303 |
| 805-745-1816 |
| 713-624-8023 |
| 202-756-2489 |
| 952-742-6780 |
| 888-542-3374 |
| 510-260-8552 |
| 916-273-8886 |
| 415-580-1178 |
eff_date |
| 2011-01-01 00:00:00 |
| 2013-07-01 00:00:00 |
| 2014-10-15 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-02 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2013-07-01 00:00:00 |
| 2014-10-15 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2011-01-01 00:00:00 |
| 2013-07-01 00:00:00 |
| 2014-10-15 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-02 00:00:00 |
| 2015-07-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 |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
agencylist |
| LEGISLATURE & GOVERNOR'S OFFICE |
| LEGISLATURE & ADMISITRATION |
| ADMINISTRATION & LEGISLATURE |
| CA LEGISLATURE GOV'S OFFICE CA ENERGY COMMISSION |
| LEGISLATURECA AIR RESOURCES BOARD GOV OFFICE |
| LEGISLATURE AND ADMINISTRATION |
| LEGISLATURE & GOVERNORS OFFICE/ADMINISTRATION ARB ENERGY COMMISSION BUILDING STANDARDS DTSC STATE FIRE MARSHALL CAL/EPA RESOURCES AGENCY AND IWMB. |
| LEGISLATURE GOVERNOR'S OFFICE DEPT OF WATER RESOURCES DEPT OF HEALTH SERVICES |
| LEGISLATURE GOVERNOR'S OFFICE ADMINISTRATION AND STATE LANDS COMMISSION |
| LEGISLATURE |
| LEGISLATURE & GOVERNOR'S OFFICE |
| LEGISLATURE & ADMISITRATION |
| ADMINISTRATION & LEGISLATURE |
| LEGISLATURE AND ADMINISTRATION |
| LEGISLATURE & GOVERNORS OFFICE/ADMINISTRATION ARB ENERGY COMMISSION BUILDING STANDARDS DTSC STATE FIRE MARSHALL CAL/EPA RESOURCES AGENCY AND IWMB. |
| LEGISLATURE GOVERNOR'S OFFICE DEPT OF WATER RESOURCES DEPT OF HEALTH SERVICES |
| LEGISLATURE GOVERNOR'S OFFICE ADMINISTRATION AND STATE LANDS COMMISSION |
| LEGISLATURE |
| LEGISLATURE AND ADMINISTRATION |
| LEGISLATURE & GOVERNORS OFFICE/ADMINISTRATION ARB ENERGY COMMISSION BUILDING STANDARDS DTSC STATE FIRE MARSHALL CAL/EPA RESOURCES AGENCY AND IWMB. |
| LEGISLATURE GOVERNOR'S OFFICE DEPT OF WATER RESOURCES DEPT OF HEALTH SERVICES |
| LEGISLATURE GOVERNOR'S OFFICE ADMINISTRATION AND STATE LANDS COMMISSION |
| LEGISLATURE |
| LEGISLATURE & GOVERNOR'S OFFICE |
| LEGISLATURE & ADMISITRATION |
| ADMINISTRATION & LEGISLATURE |
| CA LEGISLATURE GOV'S OFFICE CA ENERGY COMMISSION |
| LEGISLATURECA AIR RESOURCES BOARD GOV OFFICE |
| LEGSISLATURE AND GOVERNOR'S OFICE |
descrip |
| FOOD AND BEVERAGE MANUFACTURING |
| FOOD AGRICULTURE FINANCIAL & INDUSTRIAL POLICY |
| USED CAR SALES AND ADVERTISING |
| SOLAR ENERGY |
| AIR QUALITY |
| ISSUES RELATED TO HOME BUILDING |
| ISSUES AFFECTING THE MANUFRACTURE AND SALE OF DOORS AND WINDOWS |
| LEGISLATION RELATING TO BOTTLED WATER AND SPRING WATER CERTIFICATION |
| ENERGY PRODUCTION ISSUES |
| INDUSTIRAL AND MEDICAL GASES AND RELATED SERVICES |
| FOOD AND BEVERAGE MANUFACTURING |
| FOOD AGRICULTURE FINANCIAL & INDUSTRIAL POLICY |
| USED CAR SALES AND ADVERTISING |
| ISSUES RELATED TO HOME BUILDING |
| ISSUES AFFECTING THE MANUFRACTURE AND SALE OF DOORS AND WINDOWS |
| LEGISLATION RELATING TO BOTTLED WATER AND SPRING WATER CERTIFICATION |
| ENERGY PRODUCTION ISSUES |
| INDUSTIRAL AND MEDICAL GASES AND RELATED SERVICES |
| ISSUES RELATED TO HOME BUILDING |
| ISSUES AFFECTING THE MANUFRACTURE AND SALE OF DOORS AND WINDOWS |
| LEGISLATION RELATING TO BOTTLED WATER AND SPRING WATER CERTIFICATION |
| ENERGY PRODUCTION ISSUES |
| INDUSTIRAL AND MEDICAL GASES AND RELATED SERVICES |
| FOOD AND BEVERAGE MANUFACTURING |
| FOOD AGRICULTURE FINANCIAL & INDUSTRIAL POLICY |
| USED CAR SALES AND ADVERTISING |
| SOLAR ENERGY |
| AIR QUALITY |
| ONLINE LENDING POLICIES |
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 |