Table: lemp
filing_id |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
| 1920441 |
amend_id |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
rec_type |
| 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 |
client_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_naml |
| CALIFORNIA COALITION FOR YOUTH |
| ASPIRANET |
| JEWISH VOCATIONAL & CAREER COUNSELING SERVICE |
| SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000 |
| FAMILIES IN SCHOOLS |
| NEXUS EWATER INC. |
| CORPORATION FOR EDUCATION NETWORK INITIATIVES IN CALIFORNIA |
| CALIFORNIA COALITION FOR YOUTH |
| ASPIRANET |
| JEWISH VOCATIONAL & CAREER COUNSELING SERVICE |
| SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000 |
| FAMILIES IN SCHOOLS |
| NEXUS EWATER INC. |
| CALIFORNIA COALITION FOR YOUTH |
| ASPIRANET |
| JEWISH VOCATIONAL & CAREER COUNSELING SERVICE |
| SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000 |
| FAMILIES IN SCHOOLS |
| NEXUS EWATER INC. |
| CORPORATION FOR EDUCATION NETWORK INITIATIVES IN CALIFORNIA |
cli_namf |
| 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 |
cli_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_city |
| SACRAMENTO |
| SOUTH SAN FRANCISCO |
| SAN FRANCISCO |
| SACRAMENTO |
| LOS ANGELES |
| LANCASTER |
| LA MIRADA |
| SACRAMENTO |
| SOUTH SAN FRANCISCO |
| SAN FRANCISCO |
| SACRAMENTO |
| LOS ANGELES |
| LANCASTER |
| SACRAMENTO |
| SOUTH SAN FRANCISCO |
| SAN FRANCISCO |
| SACRAMENTO |
| LOS ANGELES |
| SAN DIEGO |
| LA MIRADA |
cli_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
cli_zip4 |
| 95814 |
| 94080 |
| 94104 |
| 95811 |
| 90017 |
| 93535 |
| 90638 |
| 95814 |
| 94080 |
| 94104 |
| 95811 |
| 90017 |
| 93535 |
| 95814 |
| 94080 |
| 94104 |
| 95811 |
| 90017 |
| 92121 |
| 90638 |
cli_phon |
| 916-514-4464 |
| 650-866-4080 |
| 415-391-3600 |
| 916-554-1200 |
| 213-201-3900 |
| 256-656-5012 |
| 714-220-3400 |
| 916-514-4464 |
| 650-866-4080 |
| 415-391-3600 |
| 916-554-1200 |
| 213-201-3900 |
| 256-656-5012 |
| 916-514-4464 |
| 650-866-4080 |
| 415-391-3600 |
| 916-554-1200 |
| 213-201-3900 |
| 877-486-9797 |
| 714-220-3400 |
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-03-02 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-03-02 00:00:00 |
con_period |
| 01/01/15 - 12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 03/02/15 - 12/31/16 |
| 01/01/15 - 12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15 - 12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 01/01/15-12/31/16 |
| 03/02/15 - 12/31/16 |
agencylist |
| HEALTH AND HUMAN SERVICES AGENCY; WORKFORCE INVESTMENT BOARD; DSS; DOJ; PUC; DHCS; DPH; CDE; DOF; OES; BSCC; LEGISLATURE; GOVERNOR'S OFFICE; HCD |
| DSS; DDS; LEGISLATURE; GOVERNOR'S OFFICE; DOF; CDE; CWIB; DHCS; DPH; HEALTH & HUMAN SERVICES AGENCY; EDD; DEPT. OF TECHNOLOGY; HBEX; |
| LEGISLATURE; GOVERNOR'S OFFICE; DOF; EDD; CWIB; DPH; DHCS; HHSA; CDE; CCCCO; DSS; ETP; |
| BOE; CALPERS; CALSTRS; ALL STATE AGENCIES; ALL STATE BOARDS & COMMISSIONS; CONSTITUTIONAL OFFICERS; LEGISLATURE |
| LEGISLATURE; GOVERNOR'S OFFICE; DOF; CDE; CCCCO; SBE |
| CA ENERGY COMMISSION; DWR; GOBIZ; LEGISLATURE; CPUC; CALEPA; ARB; EDD; LWDA; CWIB; LEGISLATURE; GOVERNOR'S OFFICE; DOF; OPR |
| GOVERNOR'S OFFICE; LEGISLATURE; DOF; LAO; CDE; CPUC; STATE LIBRARY; GOBIZ; CalSTA; DEPARTMENT OF TECHNOLOGY; CCCCO; CSU; UC; HRSA; GOVERNMENT OPERATIONS AGENCY; LWDA |
| HEALTH AND HUMAN SERVICES AGENCY; WORKFORCE INVESTMENT BOARD; DSS; DOJ; PUC; DHCS; DPH; CDE; DOF; OES; BSCC; LEGISLATURE; GOVERNOR'S OFFICE; HCD |
| DSS; DDS; LEGISLATURE; GOVERNOR'S OFFICE; DOF; CDE; CWIB; DHCS; DPH; HEALTH & HUMAN SERVICES AGENCY; EDD; DEPT. OF TECHNOLOGY; HBEX; |
| LEGISLATURE; GOVERNOR'S OFFICE; DOF; EDD; CWIB; DPH; DHCS; HHSA; CDE; CCCCO; DSS; ETP; |
| BOE; CALPERS; CALSTRS; ALL STATE AGENCIES; ALL STATE BOARDS & COMMISSIONS; CONSTITUTIONAL OFFICERS; LEGISLATURE |
| LEGISLATURE; GOVERNOR'S OFFICE; DOF; CDE; CCCCO; SBE |
| CA ENERGY COMMISSION; DWR; GOBIZ; LEGISLATURE; CPUC; CALEPA; ARB; EDD; LWDA; CWIB; LEGISLATURE; GOVERNOR'S OFFICE; DOF; OPR |
| HEALTH AND HUMAN SERVICES AGENCY; WORKFORCE INVESTMENT BOARD; DSS; DOJ; PUC; DHCS; DPH; CDE; DOF; OES; BSCC; LEGISLATURE; GOVERNOR'S OFFICE; HCD |
| DSS; DDS; LEGISLATURE; GOVERNOR'S OFFICE; DOF; CDE; CWIB; DHCS; DPH; HEALTH & HUMAN SERVICES AGENCY; EDD; DEPT. OF TECHNOLOGY; HBEX; |
| LEGISLATURE; GOVERNOR'S OFFICE; DOF; EDD; CWIB; DPH; DHCS; HHSA; CDE; CCCCO; DSS; ETP; |
| BOE; CALPERS; CALSTRS; ALL STATE AGENCIES; ALL STATE BOARDS & COMMISSIONS; CONSTITUTIONAL OFFICERS; LEGISLATURE |
| LEGISLATURE; GOVERNOR'S OFFICE; DOF; CDE; CCCCO; SBE |
| CA ENERGY COMMISSION; DWR; GOBIZ; LEGISLATURE; CPUC; CALEPA; ARB; EDD; LWDA; CWIB; LEGISLATURE; GOVERNOR'S OFFICE; DOF; OPR |
| GOVERNOR'S OFFICE; LEGISLATURE; DOF; LAO; CDE; CPUC; STATE LIBRARY; GOBIZ; CalSTA; DEPARTMENT OF TECHNOLOGY; CCCCO; CSU; UC; HRSA; GOVERNMENT OPERATIONS AGENCY; LWDA |
descrip |
| SOCIAL SERVICES FOR YOUTH |
| PROVIDING SERVICES TO YOUTH & THEIR FAMILIES IN AREAS OF FOSTER CARE; EDUCATION; RESIDENTIAL; HEALTH |
| ASSISTING PEOPLE TO FIND JOBS AND ADDRESSING BARRIERS TO EMPLOYMENT |
| ISSUES AFFECTING STATE EMPLOYEES |
| EDUCATION |
| ENERGY AND WATER CONSERVATION AND RECYCLING |
| TO ADVANCE EDUCATION AND RESEARCH THROUGHOUT CALIFORNIA BY PROVIDING WORLD-CLASS NETWORK ESSENTIAL F |
| SOCIAL SERVICES FOR YOUTH |
| PROVIDING SERVICES TO YOUTH & THEIR FAMILIES IN AREAS OF FOSTER CARE; EDUCATION; RESIDENTIAL; HEALTH |
| ASSISTING PEOPLE TO FIND JOBS AND ADDRESSING BARRIERS TO EMPLOYMENT |
| ISSUES AFFECTING STATE EMPLOYEES |
| EDUCATION |
| ENERGY AND WATER CONSERVATION AND RECYCLING |
| SOCIAL SERVICES FOR YOUTH |
| PROVIDING SERVICES TO YOUTH & THEIR FAMILIES IN AREAS OF FOSTER CARE; EDUCATION; RESIDENTIAL; HEALTH |
| ASSISTING PEOPLE TO FIND JOBS AND ADDRESSING BARRIERS TO EMPLOYMENT |
| ISSUES AFFECTING STATE EMPLOYEES |
| EDUCATION |
| ENERGY AND WATER CONSERVATION AND RECYCLING |
| TO ADVANCE EDUCATION AND RESEARCH THROUGHOUT CALIFORNIA BY PROVIDING WORLD-CLASS NETWORK ESSENTIAL F |
subfirm_id |
| 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 |
sub_city |
| 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 |
sub_zip4 |
| 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 |