filing_id | 1006549 | 1006549 | 1027815 | 1055189 | 1076552 | 1168102 | 1149497 | 1133895 | 1105368 | 1117290 | 1282139 | 1262315 | 1235736 | 1191819 | 1216359 | 1297596 | 1347801 | 1327885 | 1309428 | 1453219 | 1437386 | 1376389 | 1421914 | 1437784 | 1398568 | 1464903 | 2381074 | 2409975 | 2399123 | 2420050 | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||
sender_id | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | 1262045 | 1262045 | 1262045 | 1262045 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | 1285451 | E00789 | E00789 | E00789 | 1285451 | E00789 | 1285451 | 1285451 | 1285451 | 1285451 | 1285451 | ||||||||||||||||||||||||||||||
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | ||||||||||||||||||||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | FRM | FRM | FRM | FRM | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||||||||||||||||||||
filer_naml | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez 1262045 | Hernandez | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | ||||||||||||||||||||||||||||||
filer_namf | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | MARY A. | MARY A. | MARY A. | MARY A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A | Mary A. | Mary A. | Mary A. | Mary A | Mary A. | Mary A | Mary | Mary | Mary | Mary | ||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||
report_num | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||
rpt_date | 2004-03-16 00:00:00 | 2004-04-28 00:00:00 | 2004-07-29 00:00:00 | 2004-10-27 00:00:00 | 2005-01-27 00:00:00 | 2006-05-01 00:00:00 | 2006-01-31 00:00:00 | 2005-10-31 00:00:00 | 2005-05-02 00:00:00 | 2005-07-29 00:00:00 | 2007-07-27 00:00:00 | 2007-04-30 00:00:00 | 2007-01-30 00:00:00 | 2006-07-31 00:00:00 | 2006-10-31 00:00:00 | 2007-10-31 00:00:00 | 2008-07-29 00:00:00 | 2008-04-28 00:00:00 | 2008-01-30 00:00:00 | 2009-11-02 00:00:00 | 2009-07-31 00:00:00 | 2008-10-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2009-02-02 00:00:00 | 2010-02-01 00:00:00 | 2019-04-26 00:00:00 | 2019-08-23 00:00:00 | 2019-07-30 00:00:00 | 2019-10-30 00:00:00 | ||||||||||||||||||||||||||||||
from_date | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 2009-06-22 00:00:00 | 2008-10-01 00:00:00 | 2009-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | ||||||||||||||||||||||||||||||
thru_date | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2007-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2009-09-30 00:00:00 | 2009-06-19 00:00:00 | 2008-09-30 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2008-12-31 00:00:00 | 2009-10-07 00:00:00 | 2019-03-31 00:00:00 | 2019-08-23 00:00:00 | 2019-06-30 00:00:00 | 2019-08-23 00:00:00 | ||||||||||||||||||||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
firm_id | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | 1262045 | 1262045 | 1262045 | 1262045 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | 1285451 | E00789 | E00789 | E00789 | 1285451 | E00789 | 1285451 | 1285451 | 1285451 | 1285451 | 1285451 | ||||||||||||||||||||||||||||||
firm_name | California State Council of Service Employees E00789 | California State Council of Service Employees E00789 | California State Council of Service Employees E00789 | California State Council of Service Employees E00789 | California State Council of Service Employees E00789 | California State Council of Service Employees | CALFORNIA STATE COUNCIL OF SERVICE EMPLOYEES | CA STATE COUNCIL OF SERVICE EMPLOYEES | CALIFORNIA STATE COUNCIL OF SERVICE EMPLOYEES E00789 | CA STATE COUNCIL OF SERVICE EMPLOYEES | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | Service Employees International Union, Local 1000 | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | Service Employees International Union, Local 1000 | California State Council of Service Employees | Service Employees International Union, Local 1000 | Service Employees International Union, Local 1000 | Service Employees International Union, Local 1000 | Service Employees International Union, Local 1000 | Service Employees International Union, Local 1000 | ||||||||||||||||||||||||||||||
firm_city | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | ||||||||||||||||||||||||||||||
firm_st | 9 | 9 | 9 | 9 | 9 | 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 | ||||||||||||||||||||||||||||||
firm_zip4 | 95814-3407 | 95814-3407 | 95814-3407 | 95814-3407 | 95814-3407 | 95814 | 958143407 | 958143407 | 958143407 | 958143407 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95816 | 95814 | 95814 | 95814 | 95816 | 95814 | 95816 | 95811 | 95811 | 95811 | 95811 | ||||||||||||||||||||||||||||||
firm_phon | 916-442-3838 | 916-442-3838 | 916-442-3838 | 916-442-3838 | 916-442-3838 | (916) 442-3838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 554-1234 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 554-1234 | (916) 442-3838 | (916) 554-1234 | (916) 554-1235 | (916) 554-1235 | (916) 554-1235 | (916) 554-1235 | ||||||||||||||||||||||||||||||
mail_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 | ||||||||||||||||||||||||||||||
mail_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 | ||||||||||||||||||||||||||||||
mail_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 | ||||||||||||||||||||||||||||||
mail_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 | ||||||||||||||||||||||||||||||
sig_date | 2004-03-17 00:00:00 | 2004-04-29 00:00:00 | 2004-07-22 00:00:00 | 2004-10-27 00:00:00 | 2005-01-28 00:00:00 | 2006-04-24 00:00:00 | 2006-01-31 00:00:00 | 2005-10-31 00:00:00 | 2005-05-02 00:00:00 | 2005-07-29 00:00:00 | 2007-07-27 00:00:00 | 2007-04-30 00:00:00 | 2007-01-29 00:00:00 | 2006-07-31 00:00:00 | 2006-10-31 00:00:00 | 2007-10-30 00:00:00 | 2008-07-28 00:00:00 | 2008-04-28 00:00:00 | 2008-01-30 00:00:00 | 2009-11-02 00:00:00 | 2009-06-29 00:00:00 | 2008-10-28 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2009-02-02 00:00:00 | 2009-11-02 00:00:00 | 2019-04-26 00:00:00 | 2019-08-23 00:00:00 | 2019-07-30 00:00:00 | 2019-10-28 00:00:00 | ||||||||||||||||||||||||||||||
sig_loc | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | SACRAMENTO CA | SACRAMENTO CA | SACRAMENTO CA | SACRAMENTO CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | ||||||||||||||||||||||||||||||
sig_naml | Tipps | Tipps | Tipps | Tipps | Tipps | Hernandez | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | ||||||||||||||||||||||||||||||
sig_namf | Dean C. | Dean C. | Dean C. | Dean C. | Dean C. | Mary A. | MARY | MARY | MARY A. 1262045 | MARY | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A | Mary A. | Mary A. | Mary A. | Mary A | Mary A. | Mary A | Mary | Mary | Mary | Mary | ||||||||||||||||||||||||||||||
sig_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 | ||||||||||||||||||||||||||||||
sig_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 | ||||||||||||||||||||||||||||||
prn_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Hernandez | Hernandez | Hernandez | Hernandez | ||||||||||||||||||||||||||||||
prn_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 | Mary | Mary | Mary | Mary | ||||||||||||||||||||||||||||||
prn_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 | ||||||||||||||||||||||||||||||
prn_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 | ||||||||||||||||||||||||||||||
sig_title | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Lobbyist | Lobbyist | Lobbyist | Lobbyist | ||||||||||||||||||||||||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||
nopart2_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||
part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
ctrib_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
lobby_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
major_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 | ||||||||||||||||||||||||||||||
major_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 | ||||||||||||||||||||||||||||||
major_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 | ||||||||||||||||||||||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
rcpcmte_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 |
filing_id | 1068095 | 1224102 | 1224102 | 1382099 | 1382099 | 1429768 | 2329317 | 2409974 | 2329317 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | |||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||
form_type | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F606 | F604 | |||||||||
sender_id | E00789 | E00789 | E00789 | E00789 | E00789 | 1285451 | 1285451 | 1285451 | 1285451 | |||||||||
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | |||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||||
filer_naml | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | |||||||||
filer_namf | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary | Mary | Mary | |||||||||
filer_namt | None | None | None | None | None | None | None | None | None | |||||||||
filer_nams | None | None | None | None | None | None | None | None | None | |||||||||
report_num | 000 | 000 | 001 | 000 | 001 | 000 | 000 | 000 | 001 | |||||||||
rpt_date | 2004-12-28 00:00:00 | 2006-12-20 00:00:00 | 2007-06-06 00:00:00 | 2008-11-21 00:00:00 | 2008-12-31 00:00:00 | 2009-07-08 00:00:00 | 2020-12-31 00:00:00 | 2019-08-23 00:00:00 | 2019-07-01 00:00:00 | |||||||||
ls_beg_yr | 2005 | 2007 | 2007 | 2009 | 2009 | 2009 | 2019 | 2019 | 2019 | |||||||||
ls_end_yr | 2006 | 2008 | 2008 | 2010 | 2010 | 2010 | 2020 | 2020 | 2020 | |||||||||
qual_date | 2004-06-05 00:00:00 | None | None | None | None | 2009-06-22 00:00:00 | 2019-01-01 00:00:00 | None | 2019-01-01 00:00:00 | |||||||||
eff_date | 2004-03-05 00:00:00 | None | None | None | None | None | None | 2019-08-23 00:00:00 | None | |||||||||
bus_city | Sacramento, CA | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | |||||||||
bus_st | 9 | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||
bus_zip4 | 95814-3407 | 95814 | 95814 | 95814 | 95814 | 95816 | 95811 | 95811 | 95811 | |||||||||
bus_phon | 916-442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 442-3838 | (916) 554-1234 | (916) 554-1235 | (916) 554-1235 | (916) 554-1235 | |||||||||
bus_fax | None | (916) 442-0976 | (916) 442-0976 | (916) 442-0976 | (916) 442-0976 | (916) 326-4339 | (916) 554-1273 | (916) 554-1273 | (916) 554-1273 | |||||||||
bus_email | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | |||||||||
mail_city | None | None | None | None | None | None | None | None | None | |||||||||
mail_st | None | None | None | None | None | None | None | None | None | |||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | |||||||||
mail_phon | None | None | None | None | None | None | None | None | None | |||||||||
sig_date | 2004-12-15 00:00:00 | 2006-12-06 00:00:00 | 2007-05-18 00:00:00 | 2008-11-14 00:00:00 | 2009-02-24 00:00:00 | 2009-06-29 00:00:00 | 2018-12-21 00:00:00 | 2019-08-23 00:00:00 | 2019-07-01 00:00:00 | |||||||||
sig_loc | Sacramento, CA | None | None | None | None | None | Sacramento CA | Sacramento CA | Sacramento CA | |||||||||
sig_naml | Tipps | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | Hernandez | |||||||||
sig_namf | Dean C. | Mary A. | Mary A. | Mary A. | Mary A. | Mary A. | Mary | Mary | Mary | |||||||||
sig_namt | None | None | None | None | None | None | None | None | None | |||||||||
sig_nams | None | None | None | None | None | None | None | None | None | |||||||||
prn_naml | None | None | None | None | None | None | Hernandez | Hernandez | Hernandez | |||||||||
prn_namf | None | None | None | None | None | None | Mary | Mary | Mary | |||||||||
prn_namt | None | None | None | None | None | None | None | None | None | |||||||||
prn_nams | None | None | None | None | None | None | None | None | None | |||||||||
sig_title | None | None | None | None | None | None | None | Lobbyist | None | |||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | |||||||||
ind_cb | None | None | None | None | None | None | None | None | None | |||||||||
bus_cb | None | None | None | None | None | None | None | None | None | |||||||||
trade_cb | None | None | None | None | None | None | None | None | None | |||||||||
oth_cb | None | None | None | None | None | None | None | None | None | |||||||||
a_b_name | None | None | None | None | None | None | None | None | None | |||||||||
a_b_city | None | None | None | None | None | None | None | None | None | |||||||||
a_b_st | None | None | None | None | None | None | None | None | None | |||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | |||||||||
descrip_1 | None | None | None | None | None | None | None | None | None | |||||||||
descrip_2 | None | None | None | None | None | None | None | None | None | |||||||||
c_less50 | None | None | None | None | None | None | None | None | None | |||||||||
c_more50 | None | None | None | None | None | None | None | None | None | |||||||||
ind_class | None | None | None | None | None | None | None | None | None | |||||||||
ind_descr | None | None | None | None | None | None | None | None | None | |||||||||
bus_class | None | None | None | None | None | None | None | None | None | |||||||||
bus_descr | None | None | None | None | None | None | None | None | None | |||||||||
auth_name | None | None | None | None | None | None | None | None | None | |||||||||
auth_city | None | None | None | None | None | None | None | None | None | |||||||||
auth_st | None | None | None | None | None | None | None | None | None | |||||||||
auth_zip4 | None | None | None | None | None | None | None | None | None | |||||||||
lobby_int | None | None | None | None | None | None | None | None | None | |||||||||
influen_yn | None | None | None | None | None | None | None | None | None | |||||||||
firm_name | California State Council of Service Employees E00789 | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | Service Employees International Union, Local 1000 | Service Employees International Union, Local 1000 | Service Employees International Union, Local 1000 | Service Employees International Union, Local 1000 | |||||||||
newcert_cb | X | None | None | None | None | None | X | None | None | |||||||||
rencert_cb | None | X | None | X | None | None | None | None | None | |||||||||
complet_dt | 2004-03-05 00:00:00 | None | 2007-02-08 00:00:00 | None | 2009-02-19 00:00:00 | 2009-02-19 00:00:00 | None | None | 2019-06-27 00:00:00 | |||||||||
lby_reg_cb | X | X | X | X | X | X | X | None | X | |||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | |||||||||
st_leg_yn | Y | None | None | None | None | None | None | None | None | |||||||||
st_agency | None | None | None | None | None | None | None | None | None | |||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | |||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None |
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2080126 | 2061950 | 2113190 | 2160368 | 2170179 | 2473450 | ||||||
effect_dt | 2005-01-01 00:00:00 | 2004-01-05 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-06-22 00:00:00 | 2019-01-01 00:00:00 | ||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||
session_id | 2005 | 2003 | 2007 | 2009 | 2009 | 2019 |
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | |||||
---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2007 | 2005 | 2009 | 2019 | |||||
ethics_date | 2004-03-05 00:00:00 | 2007-02-08 00:00:00 | 2004-03-05 00:00:00 | 2009-02-19 00:00:00 | 2019-06-27 00:00:00 |
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1006286 | 982816 | 982818 | 1006549 | 1006549 | 1027815 | 1030477 | 1055189 | 1013439 | 1067747 | 1071866 | 1076552 | 1068095 | 1091638 | 1105368 | 1117290 | 1133895 | 1168102 | 1149497 | 1224102 | 1191819 | 1216359 | 1229503 | 1269001 | 1262315 | 1235736 | 1224102 | 1282139 | 1297596 | 1327885 | 1309428 | 1347801 | 1376389 | 1382099 | 1382099 | 1398568 | 1406838 | 1406846 | 1437784 | 1421914 | 1430065 | 1429768 | 1437386 | 1425339 | 1464903 | 1453219 | 1454468 | 2410821 | 2329317 | 2399123 | 2335783 | 2420050 | 2334643 | 2329317 | 2400417 | 2409974 | 2409975 | 2381074 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | None | None | 177 | 177 | 178 | None | 179 | None | None | None | 180 | 180 | None | 181 | 182 | 183 | 185 | 184 | 188 | 186 | 187 | None | None | 189 | 188 | 190 | 190 | 191 | 193 | 192 | 194 | 195 | 196 | 196 | 196 | None | None | 198 | 197 | None | 199 | 198 | None | 200 | 199 | None | None | 244 | 238 | None | 239 | None | 239 | None | 239 | 237 | 237 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F604 | F604 | F999 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F606 | F606 | F604 | F615 | F604 | F615 | F604 | F604 | F604 | F606 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2004-03-05 00:00:00 | 2004-01-15 00:00:00 | 2004-01-15 00:00:00 | 2004-03-16 00:00:00 | 2004-04-28 00:00:00 | 2004-07-29 00:00:00 | 2004-07-29 00:00:00 | 2004-10-27 00:00:00 | 2004-04-28 00:00:00 | 2004-10-28 00:00:00 | 2004-12-28 00:00:00 | 2005-01-27 00:00:00 | 2004-12-28 00:00:00 | 2005-01-27 00:00:00 | 2005-05-02 00:00:00 | 2005-07-29 00:00:00 | 2005-10-31 00:00:00 | 2006-05-01 00:00:00 | 2006-01-31 00:00:00 | 2006-12-20 00:00:00 | 2006-07-31 00:00:00 | 2006-10-31 00:00:00 | 2006-12-19 00:00:00 | 2007-05-23 00:00:00 | 2007-04-30 00:00:00 | 2007-01-30 00:00:00 | 2007-06-06 00:00:00 | 2007-07-27 00:00:00 | 2007-10-31 00:00:00 | 2008-04-28 00:00:00 | 2008-01-30 00:00:00 | 2008-07-29 00:00:00 | 2008-10-30 00:00:00 | 2008-11-21 00:00:00 | 2009-02-25 00:00:00 | 2009-02-02 00:00:00 | 2008-11-21 00:00:00 | 2009-02-19 00:00:00 | 2009-07-31 00:00:00 | 2009-04-30 00:00:00 | 2009-07-07 00:00:00 | 2009-07-08 00:00:00 | 2009-07-31 00:00:00 | 2009-02-25 00:00:00 | 2010-02-01 00:00:00 | 2009-11-02 00:00:00 | 2009-11-12 00:00:00 | 2019-09-17 00:00:00 | 2018-12-21 00:00:00 | 2019-07-31 00:00:00 | 2018-12-19 00:00:00 | 2019-10-31 00:00:00 | 2018-12-28 00:00:00 | 2019-07-30 00:00:00 | 2019-07-30 00:00:00 | 2019-09-18 00:00:00 | 2019-09-18 00:00:00 | 2019-04-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10006 | 10005 | 10005 | 10001 | 10002 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10003 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10002 | 10005 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2005 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | SARRIAGA | GPEREZ | GPEREZ | COMPLETED | COMPLETED | COMPLETED | YRODRIGUEZ | COMPLETED | LTHIBAUL | KVANG | SARRIAGA | COMPLETED | COMPLETED | JWHITE | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | GPEREZ | SARRIAGA | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | YRODRIGU | JINGRAM | GPEREZ | GPEREZ | JINGRAM | YRODRIGU | YRODRIGU | MGUERRA | MGUERRA | CFLAGG | GPEREZ | MGUERRA | YRODRIGU | MGUERRA | MGUERRA | YRODRIGU | GPEREZ | SARRIAGA | VUKSTINA | DMCCASTL | GTAYLOR | SARRIAGA | GPEREZ | VUKSTINA | GPEREZ | GTAYLOR | SUSHAKOV | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-12-28 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-12-20 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-06-06 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-11-21 00:00:00 | 2008-12-31 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-06-22 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-08 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-08-23 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2004-12-28 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-20 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 2007-06-06 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-11-21 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-07-08 00:00:00 | 2009-06-19 00:00:00 | 1900-01-01 00:00:00 | 2009-10-07 00:00:00 | 2009-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-08-23 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-03-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | 22001 | 22001 | 22001 | None | 22001 | None | None | None | 22001 | 22001 | None | 22006 | 22006 | 22006 | 22001 | 22006 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | 22001 |
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||
active | Y | Y | Y | Y | T | Y | T | |||||||
race | 0 | 0 | 0 | None | None | None | None | |||||||
session_id | 2003 | 2005 | 2007 | 2009 | 2009 | 2019 | 2019 | |||||||
category | 0 | 0 | 0 | None | None | None | None | |||||||
category_type | 0 | 0 | 0 | None | None | None | None | |||||||
sub_category | 0 | 0 | 0 | None | None | None | None | |||||||
effect_dt | 2004-01-05 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-10-07 00:00:00 | 2019-01-01 00:00:00 | 2019-08-23 00:00:00 | |||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | |||||||
election_type | 0 | 0 | 0 | None | None | None | None | |||||||
sub_category_a | None | None | None | None | None | None | None | |||||||
nyq_dt | None | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | None | None | None | None | |||||||
party_cd | 0 | 0 | 0 | None | None | None | None | |||||||
county_cd | 0 | 0 | 0 | None | None | None | None | |||||||
district_cd | 0 | 0 | 0 | None | None | None | None |
filer_id | 1262045 | |
---|---|---|
xref_id | 1262045 | |
effect_dt | 2004-01-16 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | ||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||||||||||||||||||||||||||
effect_dt | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 | ||||||||||||||||||||||||||||||
naml | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | HERNANDEZ | ||||||||||||||||||||||||||||||
namf | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY A. | MARY | MARY | MARY | MARY | MARY | MARY | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
zip4 | 958143407 | 958143407 | 95814 | 95814 | 95811 | 95811 | 958143407 | 958143407 | 95814 | 95814 | 95811 | 95811 | 958143407 | 958143407 | 95814 | 95814 | 95811 | 95811 | 958143407 | 958143407 | 95814 | 95814 | 95811 | 95811 | 958143407 | 958143407 | 95814 | 95814 | 95811 | 95811 | ||||||||||||||||||||||||||||||
phon | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9165541234 | 9165541235 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9165541234 | 9165541235 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9165541234 | 9165541235 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9165541234 | 9165541235 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9165541234 | 9165541235 | ||||||||||||||||||||||||||||||
fax | 9164420976 | 9164420976 | 9164420976 | 9164420976 | 9163264339 | 9165541273 | 9164420976 | 9164420976 | 9164420976 | 9164420976 | 9163264339 | 9165541273 | 9164420976 | 9164420976 | 9164420976 | 9164420976 | 9163264339 | 9165541273 | 9164420976 | 9164420976 | 9164420976 | 9164420976 | 9163264339 | 9165541273 | 9164420976 | 9164420976 | 9164420976 | 9164420976 | 9163264339 | 9165541273 | ||||||||||||||||||||||||||||||
[email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] |
filer_id | 1262045 |
---|
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 0 | 1 | 2 | 3 | 4 | 5 | ||||||
session_id | 2003 | 2009 | 2009 | 2009 | 2019 | 2019 | ||||||
log_dt | 2004-01-15 00:00:00 | 2009-06-30 00:00:00 | 2009-07-07 00:00:00 | 2009-11-12 00:00:00 | 2019-10-31 00:00:00 | 2019-09-17 00:00:00 | ||||||
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | ||||||
correction_flg | Y | Y | Y | Y | None | None | ||||||
action | ADDED | DELETED | ADDED | DELETED | DELETED | TERMINATED | ||||||
attribute_changed | None | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | |||||||
ethics_dt | None | None | None | None | None | None | ||||||
interests | None | None | None | None | None | None | ||||||
filer_full_name | HERNANDEZ, MARY A. | HERNANDEZ, MARY A. | HERNANDEZ, MARY A. | HERNANDEZ, MARY A. | MARY HERNANDEZ | HERNANDEZ, MARY | ||||||
filer_city | None | None | SACRAMENTO | None | None | None | ||||||
filer_st | None | None | CA | None | None | None | ||||||
filer_zip | None | None | 958143407 | None | None | None | ||||||
filer_phone | None | None | 9164423838 | None | None | None | ||||||
entity_type | 2 | 2 | 2 | 2 | 2 | 4 | ||||||
entity_name | CALIFORNIA STATE COUNCIL OF SERVICE EMPLOYEES | CALIFORNIA STATE COUNCIL OF SERVICE EMPLOYEES | SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000 | SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000 | SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000 | None | ||||||
entity_city | None | None | None | None | None | None | ||||||
entity_st | None | None | None | None | None | None | ||||||
entity_zip | None | None | None | None | None | None | ||||||
entity_phone | None | None | None | None | None | None | ||||||
entity_id | 1146846 | 1146846 | None | 1285451 | 1285451 | 0 | ||||||
responsible_officer | None | None | None | None | None | None | ||||||
effect_dt | 2004-01-05 00:00:00 | 2009-06-19 00:00:00 | 2009-06-22 00:00:00 | 2009-10-07 00:00:00 | 2019-08-23 00:00:00 | 2019-08-23 00:00:00 |
filer_id | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | 1262045 | |||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 67528.cal | 185869.cal | 1168102_0.cal | 1191819_0.cal | 1327885_0.cal | 1382099_1.cal | 1398568_0.cal | 1347801_0.cal | 1464903_0.cal | 1453219_0.cal | 1224102_0.cal | 1216359_0.cal | 1235736_0.cal | 1282139_0.cal | 1224102_1.cal | 1262315_0.cal | 1421914_0.cal | 1429768_0.cal | 1437386_0.cal | 1437784_0.cal | 1297596_0.cal | 1382099_0.cal | 1376389_0.cal | 1309428_0.cal | 2329317_0.cal | 2381074_0.cal | 2409974_0.cal | 2409975_0.cal | 2329317_1.cal | 2420050_0.cal | 2399123_0.cal | |||||||||||||||||||||||||||||||
received_date | 2004-04-28 00:00:00 | 2004-07-29 00:00:00 | 2006-05-01 00:00:00 | 2006-07-31 00:00:00 | 2008-04-28 00:00:00 | 2009-02-25 00:00:00 | 2009-02-02 00:00:00 | 2008-07-29 00:00:00 | 2010-02-01 00:00:00 | 2009-11-02 00:00:00 | 2006-12-20 00:00:00 | 2006-10-31 00:00:00 | 2007-01-30 00:00:00 | 2007-07-27 00:00:00 | 2007-06-06 00:00:00 | 2007-04-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-08 00:00:00 | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2007-10-31 00:00:00 | 2008-11-21 00:00:00 | 2008-10-30 00:00:00 | 2008-01-30 00:00:00 | 2018-12-21 00:00:00 | 2019-04-30 00:00:00 | 2019-09-18 00:00:00 | 2019-09-18 00:00:00 | 2019-07-30 00:00:00 | 2019-10-31 00:00:00 | 2019-07-31 00:00:00 | |||||||||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||
filing_id | None | None | 1168102 | 1191819 | 1327885 | 1382099 | 1398568 | 1347801 | 1464903 | 1453219 | 1224102 | 1216359 | 1235736 | 1282139 | 1224102 | 1262315 | 1421914 | 1429768 | 1437386 | 1437784 | 1297596 | 1382099 | 1376389 | 1309428 | 2329317 | 2381074 | 2409974 | 2409975 | 2329317 | 2420050 | 2399123 | |||||||||||||||||||||||||||||||
form_id | None | None | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F606 | F615 | F604 | F615 | F615 | |||||||||||||||||||||||||||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |