Table: lemp
filing_id |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
| 1921257 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
rec_type |
| 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 |
| F601P2B |
client_id |
| C01783 |
| C26046 |
| E00218 |
| 1225419 |
| C00858 |
| C23101 |
| C25328 |
| C01783 |
| C26046 |
| E00218 |
| 1225419 |
| C00858 |
| C23101 |
| C25328 |
| None |
cli_naml |
| CALIFORNIA ASSOCIATION OF PUBLIC HOSPITALS & HEALTH SYSTEMS |
| CALIFORNIA COUNCIL/AMERICAN SOCIETY OF LANDSCAPE ARCHITECTS |
| CALIFORNIA HOSPITAL ASSOCIATION ET AL |
| CONSUMER HEALTHCARE PRODUCTS ASSOCIATION |
| MOTION PICTURE ASSOCIATION OF AMERICA |
| NATIONAL ASSOCIATION OF THEATRE OWNERS OF CALIFORNIA/NEVADA |
| WALT DISNEY COMPANY AND ITS AFFILIATED ENTITIES, THE |
| CALIFORNIA ASSOCIATION OF PUBLIC HOSPITALS & HEALTH SYSTEMS |
| CALIFORNIA COUNCIL/AMERICAN SOCIETY OF LANDSCAPE ARCHITECTS |
| CALIFORNIA HOSPITAL ASSOCIATION ET AL |
| CONSUMER HEALTHCARE PRODUCTS ASSOCIATION |
| MOTION PICTURE ASSOCIATION OF AMERICA |
| NATIONAL ASSOCIATION OF THEATRE OWNERS OF CALIFORNIA/NEVADA |
| WALT DISNEY COMPANY AND ITS AFFILIATED ENTITIES, THE |
| SMALL BUSINESS FANTASY SPORTS TRADE ASSOCIATION |
cli_namf |
| 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 |
cli_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cli_city |
| OAKLAND |
| SAN DIEGO |
| SACRAMENTO |
| WASHINGTON |
| WASHINGTON |
| LOS ANGELES |
| BURBANK |
| OAKLAND |
| SAN DIEGO |
| SACRAMENTO |
| WASHINGTON |
| WASHINGTON |
| LOS ANGELES |
| BURBANK |
| APPLETON |
cli_st |
| CA |
| CA |
| CA |
| DC |
| DC |
| CA |
| CA |
| CA |
| CA |
| CA |
| DC |
| DC |
| CA |
| CA |
| WI |
cli_zip4 |
| 94607 |
| 92106 |
| 95814 |
| 20006 |
| 20006 |
| 90049 |
| 91521-1451 |
| 94607 |
| 92106 |
| 95814 |
| 20006 |
| 20006 |
| 90049 |
| 91521-1451 |
| 54912 |
cli_phon |
| (510) 874-7100 |
| (619) 283-8818 |
| (916) 443-7401 |
| (202) 429-3524 |
| (202) 378-9140 |
| (310) 460-2900 |
| (818) 560-1719 |
| (510) 874-7100 |
| (619) 283-8818 |
| (916) 443-7401 |
| (202) 429-3524 |
| (202) 378-9140 |
| (310) 460-2900 |
| (818) 560-1719 |
| (217) 306-1791 |
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-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-07-01 00:00:00 |
con_period |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
| INDEFINITE |
agencylist |
| SEE ATTACHMENT A |
| SEE ATTACHMENT B |
| SEE ATTACHMENT C |
| SEE ATTACHMENT D |
| SEE ATTACHMENT E |
| GOVERNOR'S OFFICE, CALIFORNIA LEGISLATURE, DEPARTMENT OF FINANCE, DEPARTMENT OF IDUSTRIAL RELATIONS, LABOR & WORKFORCE DEVELOPMENT AGENCY |
| SEE ATTACHMENT F |
| SEE ATTACHMENT A |
| SEE ATTACHMENT B |
| SEE ATTACHMENT C |
| SEE ATTACHMENT D |
| SEE ATTACHMENT E |
| GOVERNOR'S OFFICE, CALIFORNIA LEGISLATURE, DEPARTMENT OF FINANCE, DEPARTMENT OF IDUSTRIAL RELATIONS, LABOR & WORKFORCE DEVELOPMENT AGENCY |
| SEE ATTACHMENT F |
| GOVERNOR'S OFFICE, LEGISLATURE AND DEPARTMENT OF JUSTICE |
descrip |
| ISSUES RELATING TO PUBLIC HOSPITALS AND SERVICES |
| ISSUES RELATING TO PRACTICE OF LANDSCAPE ARCHITECTURE INCLUDING LICENSURE ISSUES. |
| ISSUES RELATING TO HOSPITALS AND SERVICES |
| ISSUES RELATING TO THE PRODUCTION, DISTRIBUTION AND REGULATION OF OVER-THE-COUNTER DRUG PRODUCTS |
| ISSUES RELATING TO THE PRODUCTION AND/OR DISTRIBUTION OF MOTION PICTURE AND TELEVISION PROGRAMS |
| ISSUES RELATING TO THE EXHIBITION OF MOTION PICTURES AND THE OPERATION OF MOVIE THEATRES. |
| ISSUES RELATING TO MOTION PICTURES, TELEVISION, AMUSEMENT PARKS AND OTHER COMPANY INTERESTS |
| ISSUES RELATING TO PUBLIC HOSPITALS AND SERVICES |
| ISSUES RELATING TO PRACTICE OF LANDSCAPE ARCHITECTURE INCLUDING LICENSURE ISSUES. |
| ISSUES RELATING TO HOSPITALS AND SERVICES |
| ISSUES RELATING TO THE PRODUCTION, DISTRIBUTION AND REGULATION OF OVER-THE-COUNTER DRUG PRODUCTS |
| ISSUES RELATING TO THE PRODUCTION AND/OR DISTRIBUTION OF MOTION PICTURE AND TELEVISION PROGRAMS |
| ISSUES RELATING TO THE EXHIBITION OF MOTION PICTURES AND THE OPERATION OF MOVIE THEATRES. |
| ISSUES RELATING TO MOTION PICTURES, TELEVISION, AMUSEMENT PARKS AND OTHER COMPANY INTERESTS |
| FANTASY SPORTS |
subfirm_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| F00980 |
sub_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| EDELSTEIN, GILBERT, ROBSON & SMITH, LLC |
sub_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| SACRAMENTO |
sub_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CA |
sub_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 95814 |
sub_phon |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| (916) 443-6400 |