Table: lemp
filing_id |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
| 1921254 |
amend_id |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
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 |
form_type |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2A |
| F601P2B |
| F601P2B |
| F601P2B |
client_id |
| 1263048 |
| C27746 |
| 1326603 |
| 1273699 |
| C24756 |
| C25013 |
| C28289 |
| 1374268 |
| 1263048 |
| C27746 |
| 1326603 |
| 1273699 |
| C24756 |
| C25013 |
| 1263048 |
| C27746 |
| 1326603 |
| 1273699 |
| C24756 |
| 1383873 |
| C25013 |
| C28289 |
| 1374268 |
cli_naml |
| SENTINEL OFFENDER SERVICES INC. |
| AMN HEALTHCARE INC. |
| TOBII DYNAVOX LLC |
| HEARING REHABILITATION SOLUTIONS INC. |
| CALIFORNIA ASSOCIATION OF ORAL AND MAXILLOFACIAL SURGEONS |
| CALIFORNIA SOCIETY OF DERMATOLOGY & DERMATOLOGIC SURGERY |
| CALIFORNIA CORRECTIONAL SUPERVISORS ORGANIZATION INC. |
| CAR DEALERS SAVING LIVES |
| SENTINEL OFFENDER SERVICES INC. |
| AMN HEALTHCARE INC. |
| TOBII DYNAVOX LLC |
| HEARING REHABILITATION SOLUTIONS INC. |
| CALIFORNIA ASSOCIATION OF ORAL AND MAXILLOFACIAL SURGEONS |
| CALIFORNIA SOCIETY OF DERMATOLOGY & DERMATOLOGIC SURGERY |
| SENTINEL OFFENDER SERVICES INC. |
| AMN HEALTHCARE INC. |
| TOBII DYNAVOX LLC |
| HEARING REHABILITATION SOLUTIONS INC. |
| CALIFORNIA ASSOCIATION OF ORAL AND MAXILLOFACIAL SURGEONS |
| SUDC FOUNDATION THE |
| CALIFORNIA SOCIETY OF DERMATOLOGY & DERMATOLOGIC SURGERY |
| CALIFORNIA CORRECTIONAL SUPERVISORS ORGANIZATION INC. |
| CAR DEALERS SAVING LIVES |
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 |
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 |
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 |
cli_city |
| IRVINE |
| SAN DIEGO |
| PITTSBURGH |
| SACRAMENTO |
| ROSEVILLE |
| SACRAMENTO |
| ESCALON |
| NEWPORT BEACH |
| IRVINE |
| SAN DIEGO |
| PITTSBURGH |
| SACRAMENTO |
| ROSEVILLE |
| SACRAMENTO |
| IRVINE |
| SAN DIEGO |
| PITTSBURGH |
| SACRAMENTO |
| ROSEVILLE |
| RESTON |
| SACRAMENTO |
| ESCALON |
| NEWPORT BEACH |
cli_st |
| CA |
| CA |
| PA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| PA |
| CA |
| CA |
| CA |
| CA |
| CA |
| PA |
| CA |
| CA |
| VA |
| CA |
| CA |
| CA |
cli_zip4 |
| 92618 |
| 92130 |
| 15203 |
| 95825 |
| 95678 |
| 95814 |
| 95320 |
| 92660 |
| 92618 |
| 92130 |
| 15203 |
| 95825 |
| 95678 |
| 95814 |
| 92618 |
| 92130 |
| 15203 |
| 95825 |
| 95678 |
| 20191 |
| 95814 |
| 95320 |
| 92660 |
cli_phon |
| 800-929-8201 |
| 866-871-8519 |
| 412-381-4883 |
| 888-844-0477 |
| 800-500-1332 |
| 916-498-1712 |
| 209-838-2940 |
| 949-706-4255 |
| 800-929-8201 |
| 866-871-8519 |
| 412-381-4883 |
| 888-844-0477 |
| 800-500-1332 |
| 916-498-1712 |
| 800-929-8201 |
| 866-871-8519 |
| 412-381-4883 |
| 888-844-0477 |
| 800-500-1332 |
| 800-620-7832 |
| 916-498-1712 |
| 209-838-2940 |
| 949-706-4255 |
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-02-20 00:00:00 |
| 2015-02-20 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 |
| 2016-03-11 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-02-20 00:00:00 |
| 2015-02-20 00:00:00 |
con_period |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| ONGOING |
| ONGOING |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| OPEN |
| ONGOING |
| OPEN |
| ONGOING |
| ONGOING |
agencylist |
| LEGISLATURE; GOVERNOR'S OFFICE |
| CALIFORNIA LEGISLATURE; GOVERNOR'S OFFICE; BOARD OF REGISTERED NURSING; DEPARTMENT OF LABOR; EDD; DEPARTMENT OF HEALTHCARE SERVICES |
| CA STATE LEGISLATURE; OFFICE OF THE GOVERNOR; DEPARTMENT OF HEALTHCARE SERVICES; PUBLIC UTILITIES COMMISSION |
| LEGISLATURE; GOVERNOR'S OFFICE; STATE COMPENSATION INSURANCE FUND |
| LEGISLATURE; GOVERNOR'S OFFICE; CALIFORNIA DENTAL BOARD; DEPARTMENT OF CONSUMER AFFAIRS; DEPARTMENT OF HEALTHCARE SERVICES |
| LEGISLATURE; OFFICE OF THE GOVERNOR; DEPARTMENT OF CONSUMER AFFAIRS; DEPARTMENT OF HEALTHCARE SERVICES |
| CA STATE LEGISLATURE; GOVERNOR'S OFFICE |
| STATE LEGISLATURE; GOVERNOR'S OFFICE |
| LEGISLATURE; GOVERNOR'S OFFICE |
| CALIFORNIA LEGISLATURE; GOVERNOR'S OFFICE; BOARD OF REGISTERED NURSING; DEPARTMENT OF LABOR; EDD; DEPARTMENT OF HEALTHCARE SERVICES |
| CA STATE LEGISLATURE; OFFICE OF THE GOVERNOR; DEPARTMENT OF HEALTHCARE SERVICES; PUBLIC UTILITIES COMMISSION |
| LEGISLATURE; GOVERNOR'S OFFICE; STATE COMPENSATION INSURANCE FUND |
| LEGISLATURE; GOVERNOR'S OFFICE; CALIFORNIA DENTAL BOARD; DEPARTMENT OF CONSUMER AFFAIRS; DEPARTMENT OF HEALTHCARE SERVICES |
| LEGISLATURE; OFFICE OF THE GOVERNOR; DEPARTMENT OF CONSUMER AFFAIRS; DEPARTMENT OF HEALTHCARE SERVICES |
| LEGISLATURE; GOVERNOR'S OFFICE |
| CALIFORNIA LEGISLATURE; GOVERNOR'S OFFICE; BOARD OF REGISTERED NURSING; DEPARTMENT OF LABOR; EDD; DEPARTMENT OF HEALTHCARE SERVICES |
| CA STATE LEGISLATURE; OFFICE OF THE GOVERNOR; DEPARTMENT OF HEALTHCARE SERVICES; PUBLIC UTILITIES COMMISSION |
| LEGISLATURE; GOVERNOR'S OFFICE; STATE COMPENSATION INSURANCE FUND |
| LEGISLATURE; GOVERNOR'S OFFICE; CALIFORNIA DENTAL BOARD; DEPARTMENT OF CONSUMER AFFAIRS; DEPARTMENT OF HEALTHCARE SERVICES |
| CA STATE LEGISLATURE |
| LEGISLATURE; OFFICE OF THE GOVERNOR; DEPARTMENT OF CONSUMER AFFAIRS; DEPARTMENT OF HEALTHCARE SERVICES |
| CA STATE LEGISLATURE; GOVERNOR'S OFFICE |
| STATE LEGISLATURE; GOVERNOR'S OFFICE |
descrip |
| CORRECTIONS AND PUBLIC SAFETY ISSUES |
| HEALTHCARE; LABOR AND EMPLOYMENT ISSUES; NURSING ISSUES |
| HEALTHCARE ISSUES; DURABLE MEDICAL EQUIPMENT ISSUES; COMMUNICATION DEVICE ISSUES |
| HEARING AID AND AUDIOLOGY SERVICES |
| DENTAL HEALTHCARE ISSUES |
| HEALTHCARE |
| EMPLOYEE RELATIONS |
| DATA REPORTING IN CAR ACCIDENTS |
| CORRECTIONS AND PUBLIC SAFETY ISSUES |
| HEALTHCARE; LABOR AND EMPLOYMENT ISSUES; NURSING ISSUES |
| HEALTHCARE ISSUES; DURABLE MEDICAL EQUIPMENT ISSUES; COMMUNICATION DEVICE ISSUES |
| HEARING AID AND AUDIOLOGY SERVICES |
| DENTAL HEALTHCARE ISSUES |
| HEALTHCARE |
| CORRECTIONS AND PUBLIC SAFETY ISSUES |
| HEALTHCARE; LABOR AND EMPLOYMENT ISSUES; NURSING ISSUES |
| HEALTHCARE ISSUES; DURABLE MEDICAL EQUIPMENT ISSUES; COMMUNICATION DEVICE ISSUES |
| HEARING AID AND AUDIOLOGY SERVICES |
| DENTAL HEALTHCARE ISSUES |
| HEALTH |
| HEALTHCARE |
| EMPLOYEE RELATIONS |
| DATA REPORTING IN CAR ACCIDENTS |
subfirm_id |
| None |
| None |
| None |
| None |
| None |
| 1294222 |
| F24508 |
| F24508 |
| None |
| None |
| None |
| None |
| None |
| 1294222 |
| None |
| None |
| None |
| None |
| None |
| None |
| 1294222 |
| F24508 |
| F24508 |
sub_name |
| None |
| None |
| None |
| None |
| None |
| CAL CAPITOL GROUP |
| LOVELL; LAW OFFICES OF JOHN |
| LOVELL; LAW OFFICES OF JOHN |
| None |
| None |
| None |
| None |
| None |
| CAL CAPITOL GROUP |
| None |
| None |
| None |
| None |
| None |
| None |
| CAL CAPITOL GROUP |
| LOVELL; LAW OFFICES OF JOHN |
| LOVELL; LAW OFFICES OF JOHN |
sub_city |
| None |
| None |
| None |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| None |
| None |
| None |
| None |
| None |
| SACRAMENTO |
| None |
| None |
| None |
| None |
| None |
| None |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
sub_st |
| None |
| None |
| None |
| None |
| None |
| CA |
| CA |
| CA |
| None |
| None |
| None |
| None |
| None |
| CA |
| None |
| None |
| None |
| None |
| None |
| None |
| CA |
| CA |
| CA |
sub_zip4 |
| None |
| None |
| None |
| None |
| None |
| 95814 |
| 95814 |
| 95814 |
| None |
| None |
| None |
| None |
| None |
| 95814 |
| None |
| None |
| None |
| None |
| None |
| None |
| 95814 |
| 95814 |
| 95814 |
sub_phon |
| None |
| None |
| None |
| None |
| None |
| 916-444-1500 |
| 916-261-7188 |
| 916-261-7188 |
| None |
| None |
| None |
| None |
| None |
| 916-444-1500 |
| None |
| None |
| None |
| None |
| None |
| None |
| 916-444-1500 |
| 916-261-7188 |
| 916-261-7188 |