Table: lemp
filing_id |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
| 1928583 |
amend_id |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 2 |
| 8 |
| 8 |
| 8 |
| 9 |
| 9 |
| 9 |
| 9 |
| 9 |
| 9 |
| 9 |
| 9 |
| 8 |
| 8 |
| 8 |
| 8 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 7 |
| 7 |
| 7 |
| 7 |
| 7 |
| 7 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 4 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 10 |
| 10 |
| 10 |
| 10 |
| 10 |
| 10 |
| 10 |
| 11 |
| 11 |
| 11 |
| 11 |
| 11 |
| 12 |
| 11 |
| 11 |
| 11 |
| 12 |
| 12 |
| 12 |
| 12 |
| 12 |
| 12 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 3 |
| 4 |
| 5 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 1 |
| 2 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 1 |
| 2 |
| 3 |
| 4 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 4 |
| 6 |
| 7 |
| 8 |
| 1 |
| 2 |
| 3 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| F601P2A |
client_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 |
| 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 |
| 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 |
| None |
cli_naml |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| United Farm Workers |
| American Civil Liberties Union of Northern California |
| American Civil Liberties Union of Southern California |
| American Federation of State, County and Municipal Employees Local 3299 |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| United Farm Workers |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| United Farm Workers |
| American Civil Liberties Union of Northern California |
| California Applicants' Attorneys Association |
| American Civil Liberties Union/Northern California/Southern California |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| United Farm Workers |
| American Civil Liberties Union of Northern California |
| American Civil Liberties Union of Southern California |
| Robert F. Kennedy Medical Plan |
| Thomas Girardi |
| C. A. Rasmussen Co., LLC |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| American Federation of State, County and Municipal Employees Local 3299 |
| Robert F. Kennedy Medical Plan |
| Thomas Girardi |
| C. A. Rasmussen Co., LLC |
| Buena Vista Rancheria of Me-Wuk Indians |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| American Federation of State, County and Municipal Employees Local 3299 |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| American Civil Liberties Union of Southern California |
| American Federation of State, County and Municipal Employees Local 3299 |
| Robert F. Kennedy Medical Plan |
| Thomas Girardi |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| American Federation of State, County and Municipal Employees Local 3299 |
| Robert F. Kennedy Medical Plan |
| Thomas Girardi |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| American Civil Liberties Union of Northern California |
| American Civil Liberties Union of Southern California |
| American Federation of State, County and Municipal Employees Local 3299 |
| Robert F. Kennedy Medical Plan |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| American Civil Liberties Union of Northern California |
| American Civil Liberties Union of Southern California |
| American Federation of State, County and Municipal Employees Local 3299 |
| Robert F. Kennedy Medical Plan |
| Thomas Girardi |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| American Federation of State, County and Municipal Employees Local 3299 |
| Robert F. Kennedy Medical Plan |
| Thomas Girardi |
| Buena Vista Rancheria of Me-Wuk Indians |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| American Federation of State, County and Municipal Employees Local 3299 |
| Robert F. Kennedy Medical Plan |
| American Federation of State, County and Municipal Employees Local 3299 |
| Thomas Girardi |
| Buena Vista Rancheria of Me-Wuk Indians |
| CA Coalition of Agencies Serving the Deaf & Hard of Hearing |
| California Applicants' Attorneys Association |
| California Construction and Industrial Materials Association |
| Goodwill Industries of Sacramento Valley & Northern Nevada, Inc. |
| Robert F. Kennedy Medical Plan |
| Thomas Girardi |
| CA Coalition of Agencies Serving the Deaf & Hard of Hearing |
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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| None |
cli_city |
| Sacramento |
| Sacramento |
| Sacramento |
| Keene |
| Sacramento |
| Sacramento |
| Oakland |
| Sacramento |
| Sacramento |
| Keene |
| Sacramento |
| Sacramento |
| Sacramento |
| Keene |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Keene |
| Sacramento |
| Sacramento |
| Keene |
| Los Angeles |
| Simi Valley |
| Sacramento |
| Sacramento |
| Sacramento |
| Oakland |
| Keene |
| Los Angeles |
| Simi Valley |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Oakland |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Oakland |
| Keene |
| Los Angeles |
| Sacramento |
| Sacramento |
| Sacramento |
| Oakland |
| Keene |
| Los Angeles |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Oakland |
| Keene |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Oakland |
| Keene |
| Los Angeles |
| Sacramento |
| Sacramento |
| Sacramento |
| Oakland |
| Keene |
| Los Angeles |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Oakland |
| Keene |
| Oakland |
| Los Angeles |
| Sacramento |
| North Highlands |
| Sacramento |
| Sacramento |
| Sacramento |
| Keene |
| Los Angeles |
| North Highlands |
cli_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
cli_zip4 |
| 95815 |
| 94814 |
| 85823 |
| 93531 |
| 95814 |
| 95814 |
| 94612 |
| 94814 |
| 85823 |
| 93531 |
| 95815 |
| 94814 |
| 85823 |
| 93531 |
| 95814 |
| 95815 |
| 94814 |
| 95815 |
| 94814 |
| 85823 |
| 93531 |
| 95814 |
| 95814 |
| 93531 |
| 90017 |
| 93065 |
| 95815 |
| 94814 |
| 85823 |
| 94612 |
| 93531 |
| 90017 |
| 93065 |
| 95811 |
| 95815 |
| 94814 |
| 85823 |
| 94612 |
| 95815 |
| 94814 |
| 85823 |
| 95814 |
| 94612 |
| 93531 |
| 90017 |
| 95815 |
| 94814 |
| 85823 |
| 94612 |
| 93531 |
| 90017 |
| 95815 |
| 94814 |
| 85823 |
| 95814 |
| 95814 |
| 94612 |
| 93531 |
| 95815 |
| 94814 |
| 85823 |
| 95814 |
| 95814 |
| 94612 |
| 93531 |
| 90017 |
| 95815 |
| 94814 |
| 85823 |
| 94612 |
| 93531 |
| 90017 |
| 95811 |
| 95815 |
| 94814 |
| 85823 |
| 94612 |
| 93531 |
| 94612 |
| 90017 |
| 95811 |
| 95660 |
| 95815 |
| 94814 |
| 85823 |
| 93531 |
| 90017 |
| 95660 |
cli_phon |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (661) 823-6128 |
| (916) 442-1036 |
| (916) 442-1036 |
| (510) 844-1160 |
| (916) 554-1000 |
| (916) 395-9000 |
| (661) 823-6128 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (661) 823-6128 |
| (916) 442-1036 |
| (916) 444-5155 |
| (916) 442-1036 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (661) 823-6128 |
| (916) 442-1036 |
| (916) 442-1036 |
| (661) 823-6905 |
| (916) 441-1995 |
| (818) 518-6932 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (510) 844-1160 |
| (661) 823-6905 |
| (916) 441-1995 |
| (818) 518-6932 |
| (916) 491-0011 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (510) 844-1160 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (916) 442-1036 |
| (510) 844-1160 |
| (661) 823-6905 |
| (916) 441-1995 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (510) 844-1160 |
| (661) 823-6905 |
| (916) 441-1995 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (916) 442-1036 |
| (916) 442-1036 |
| (510) 844-1160 |
| (661) 823-6905 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (916) 442-1036 |
| (916) 442-1036 |
| (510) 844-1160 |
| (661) 823-6905 |
| (916) 441-1995 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (510) 844-1160 |
| (661) 823-6905 |
| (916) 441-1995 |
| (916) 491-0011 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (510) 844-1160 |
| (661) 823-6905 |
| (510) 844-1160 |
| (916) 441-1995 |
| (916) 491-0011 |
| (916) 349-7500 |
| (916) 444-5155 |
| (916) 554-1000 |
| (916) 395-9000 |
| (661) 823-6905 |
| (916) 441-1995 |
| (916) 349-7500 |
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-04-13 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 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2016-01-01 00:00:00 |
| 2016-02-01 00:00:00 |
| 2016-05-16 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-04-13 00:00:00 |
| 2016-01-01 00:00:00 |
| 2016-02-01 00:00:00 |
| 2016-05-16 00:00:00 |
| 2016-05-16 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-04-13 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-04-13 00:00:00 |
| 2016-01-01 00:00:00 |
| 2016-02-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-04-13 00:00:00 |
| 2016-01-01 00:00:00 |
| 2016-02-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-04-13 00:00:00 |
| 2016-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-04-13 00:00:00 |
| 2016-01-01 00:00:00 |
| 2016-02-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-04-13 00:00:00 |
| 2016-01-01 00:00:00 |
| 2016-02-01 00:00:00 |
| 2016-05-16 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-04-13 00:00:00 |
| 2016-01-01 00:00:00 |
| 2015-04-13 00:00:00 |
| 2016-02-01 00:00:00 |
| 2016-05-16 00:00:00 |
| 2016-10-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2015-01-01 00:00:00 |
| 2016-01-01 00:00:00 |
| 2016-02-01 00:00:00 |
| 2016-10-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 |
| 8/31/2016 |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| 8/31/2016 |
| 8/31/2016 |
| 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 |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| 8/31/2016 |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| 8/31/2016 |
| 9/30/2017 |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| Indefinite |
| 9/30/2017 |
agencylist |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor, Dept. of Finance, Agricultural Labor Relations Board, California Labor & Workforce Development Agency, California Health & Human Services Agency |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor's Office |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor, Dept. of Finance, Agricultural Labor Relations Board, California Labor & Workforce Development Agency, California Health & Human Services Agency |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor, Dept. of Finance, Agricultural Labor Relations Board, California Labor & Workforce Development Agency, California Health & Human Services Agency |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, State Board of Education, California Department of Education |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor, Dept. of Finance, Agricultural Labor Relations Board, California Labor & Workforce Development Agency, California Health & Human Services Agency |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature |
| State Legislature |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor's Office |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature |
| State Legislature |
| State Legislature, Governor |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor's Office |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor's Office |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor's Office |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor's Office |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor, Department of Finance, State Board of Education, Department of Education |
| State Legislature, Governor's Office |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor's Office |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature |
| State Legislature, Governor |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| State Legislature, Governor's Office |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature, Governor's Office |
| State Legislature |
| State Legislature, Governor |
| Legislature, Dept. of Social Services, Dept. of Finance |
| State Legislature, Governor |
| State Legislature, Governor, Department of Finance, California Resources Agency, State Mining and Geology Board |
| State Legislature, Governor, Department of Finance |
| Governor, State Legislature, Department of Health & Human Services |
| State Legislature |
| Legislature, Dept. of Social Services, Dept. of Finance |
descrip |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Legislation related to agricultural employees |
| Legislation related to k-12 education and civil rights |
| Legislation related to k-12 education and civil rights |
| Labor Union |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Legislation related to agricultural employees |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Legislation related to agricultural employees |
| Legislation related to k-12 education and civil rights |
| Legislation related to injured workers and workers' compensation |
| Legislation related to k-12 education and civil rights |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Legislation related to agricultural employees |
| Legislation related to k-12 education and civil rights |
| Legislation related to k-12 education and civil rights |
| Healthcare for farmworkers |
| Issues related to the unlicensed practice of law |
| Legislation relating to real estate management and development |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Labor Union |
| Healthcare for farmworkers |
| Issues related to the unlicensed practice of law |
| Legislation relating to real estate management and development |
| Tribal-State Compact |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Labor Union |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Legislation related to k-12 education and civil rights |
| Labor Union |
| Healthcare for farmworkers |
| Issues related to the unlicensed practice of law |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Labor Union |
| Healthcare for farmworkers |
| Issues related to the unlicensed practice of law |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Legislation related to k-12 education and civil rights |
| Legislation related to k-12 education and civil rights |
| Labor Union |
| Healthcare for farmworkers |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Legislation related to k-12 education and civil rights |
| Legislation related to k-12 education and civil rights |
| Labor Union |
| Healthcare for farmworkers |
| Issues related to the unlicensed practice of law |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Labor Union |
| Healthcare for farmworkers |
| Issues related to the unlicensed practice of law |
| Tribal-State Compact |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Labor Union |
| Healthcare for farmworkers |
| Labor Union |
| Issues related to the unlicensed practice of law |
| Tribal-State Compact |
| Funding for services to the deaf and hard of hearing |
| Legislation related to injured workers and workers' compensation |
| Legislation related to construction, aggregate and industrial materials |
| Legislation related to charitable donations, job training and employment |
| Healthcare for farmworkers |
| Issues related to the unlicensed practice of law |
| Funding for services to the deaf and hard of hearing |
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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| None |