filing_id | 2443941 | 2471675 | 2531914 | 2487573 | 2555145 | 2604081 | 2624994 | 2580915 | 2677762 | 2708429 | 2644669 | 2748423 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | ||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||
sender_id | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | ||||||||||||
filer_id | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | ||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||
filer_naml | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | ||||||||||||
filer_namf | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | ||||||||||||
filer_namt | 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 | ||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||
rpt_date | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2020-11-02 00:00:00 | 2020-07-31 00:00:00 | 2021-01-31 00:00:00 | 2021-07-30 00:00:00 | 2021-11-01 00:00:00 | 2021-04-30 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2022-01-28 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||
from_date | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||
thru_date | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
firm_id | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | E00789 | ||||||||||||
firm_name | 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 | California State Council of Service Employees | California State Council of Service Employees | California State Council of Service Employees | ||||||||||||
firm_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | ||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||
firm_phon | 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-442-3838 | 916-442-3838 | 916-442-3838 | ||||||||||||
mail_city | 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 | ||||||||||||
mail_zip4 | 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 | ||||||||||||
sig_date | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2020-11-02 00:00:00 | 2020-07-31 00:00:00 | 2021-01-31 00:00:00 | 2021-07-30 00:00:00 | 2021-11-01 00:00:00 | 2021-04-30 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2022-01-28 00:00:00 | 2022-10-31 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 | ||||||||||||
sig_naml | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | ||||||||||||
sig_namf | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | ||||||||||||
sig_namt | 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 | ||||||||||||
prn_naml | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | Lege | ||||||||||||
prn_namf | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | Matt | ||||||||||||
prn_namt | 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 | ||||||||||||
sig_title | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | ||||||||||||
nopart1_cb | 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 | ||||||||||||
part1_1_cb | 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 | ||||||||||||
ctrib_n_cb | 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 | ||||||||||||
lby_actvty | 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 | ||||||||||||
lobby_y_cb | 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 | ||||||||||||
major_namf | 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 | ||||||||||||
major_nams | 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 | ||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 2411927 | 2541594 | ||
---|---|---|---|---|
amend_id | 0 | 0 | ||
rec_type | CVR | CVR | ||
form_type | F604 | F604 | ||
sender_id | E00789 | E00789 | ||
filer_id | 1421500 | 1421500 | ||
entity_cd | LBY | LBY | ||
filer_naml | Lege | Lege | ||
filer_namf | Matt | Matt | ||
filer_namt | None | None | ||
filer_nams | None | None | ||
report_num | 000 | 000 | ||
rpt_date | 2019-10-03 00:00:00 | 2022-12-31 00:00:00 | ||
ls_beg_yr | 2019 | 2021 | ||
ls_end_yr | 2020 | 2022 | ||
qual_date | 2019-10-01 00:00:00 | 2019-10-01 00:00:00 | ||
eff_date | None | None | ||
bus_city | Sacramento | Sacramento | ||
bus_st | CA | CA | ||
bus_zip4 | 95814 | 95814 | ||
bus_phon | 916-442-3838 | 916-442-3838 | ||
bus_fax | None | None | ||
bus_email | None | None | ||
mail_city | None | None | ||
mail_st | None | None | ||
mail_zip4 | None | None | ||
mail_phon | None | None | ||
sig_date | 2019-09-27 00:00:00 | 2020-12-31 00:00:00 | ||
sig_loc | Sacramento CA | Sacramento CA | ||
sig_naml | Lege | Lege | ||
sig_namf | Matt | Matt | ||
sig_namt | None | None | ||
sig_nams | None | None | ||
prn_naml | Lege | Lege | ||
prn_namf | Matt | Matt | ||
prn_namt | None | None | ||
prn_nams | None | None | ||
sig_title | None | None | ||
stmt_firm | None | None | ||
ind_cb | None | None | ||
bus_cb | None | None | ||
trade_cb | None | None | ||
oth_cb | None | None | ||
a_b_name | None | None | ||
a_b_city | None | None | ||
a_b_st | None | None | ||
a_b_zip4 | None | None | ||
descrip_1 | None | None | ||
descrip_2 | None | None | ||
c_less50 | None | None | ||
c_more50 | None | None | ||
ind_class | None | None | ||
ind_descr | None | None | ||
bus_class | None | None | ||
bus_descr | None | None | ||
auth_name | None | None | ||
auth_city | None | None | ||
auth_st | None | None | ||
auth_zip4 | None | None | ||
lobby_int | None | None | ||
influen_yn | None | None | ||
firm_name | California State Council of Service Employees | California State Council of Service Employees | ||
newcert_cb | X | None | ||
rencert_cb | None | X | ||
complet_dt | None | None | ||
lby_reg_cb | X | X | ||
lby_604_cb | None | None | ||
st_leg_yn | None | None | ||
st_agency | None | None | ||
lobby_cb | None | None | ||
l_firm_cb | None | None |
filer_id | 1421500 | 1421500 | 1421500 | 1421500 | ||||
---|---|---|---|---|---|---|---|---|
adrid | 2535086 | 2546349 | 2507484 | 2485078 | ||||
effect_dt | 2022-03-07 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-10-01 00:00:00 | ||||
add_type | 7051 | 7051 | 7051 | 7051 | ||||
session_id | 2021 | 2023 | 2021 | 2019 |
filer_id | 1421500 | 1421500 | ||
---|---|---|---|---|
session_id | 2019 | 2021 | ||
ethics_date | 2020-03-12 00:00:00 | 2021-03-12 00:00:00 |
filer_id | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2412485 | 2487573 | 2443941 | 2463318 | 2411927 | 2471675 | 2570468 | 2555145 | 2677762 | 2591608 | 2531914 | 2624994 | 2541594 | 2604081 | 2644669 | 2580915 | 2708429 | 2748423 | ||||||||||||||||||
period_id | None | 242 | 240 | None | 240 | 241 | None | 244 | 249 | None | 243 | 247 | 252 | 246 | 248 | 245 | 250 | 251 | ||||||||||||||||||
form_id | F604 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
filing_date | 2019-10-07 00:00:00 | 2020-07-31 00:00:00 | 2020-01-31 00:00:00 | 2020-03-16 00:00:00 | 2019-10-08 00:00:00 | 2020-04-30 00:00:00 | 2021-01-04 00:00:00 | 2021-02-01 00:00:00 | 2022-05-02 00:00:00 | 2021-06-29 00:00:00 | 2020-11-02 00:00:00 | 2021-11-01 00:00:00 | 2020-12-31 00:00:00 | 2021-08-02 00:00:00 | 2022-01-31 00:00:00 | 2021-04-30 00:00:00 | 2022-08-01 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||
stmnt_type | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||
session_id | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||
user_id | SARRIAGA | CVANLIEW | VUKSTINA | GPEREZ | SARRIAGA | VUKSTINA | JMENDOZA | JMAVES | CAFILER | MMERCHANT | MKIRKHAM | GTAYLOR | JMENDOZA | CHATRIDGE | RATTIYEH | CHARTRIDGE | CAFILER | CAFILER | ||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||
fine_audit | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-03 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-12-31 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2019-10-03 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 00:00:00 | 2022-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
filing_type | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1421500 | 1421500 | 1421500 | |||
---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | |||
active | Y | Y | N | |||
race | None | 0 | None | |||
session_id | 2021 | 2019 | 2023 | |||
category | None | 0 | None | |||
category_type | None | 0 | None | |||
sub_category | None | 0 | None | |||
effect_dt | 2021-01-01 00:00:00 | 2019-10-01 00:00:00 | 2023-01-01 00:00:00 | |||
sub_category_type | None | 0 | None | |||
election_type | None | 0 | None | |||
sub_category_a | None | None | None | |||
nyq_dt | None | None | None | |||
party_cd | None | 0 | None | |||
county_cd | None | 0 | None | |||
district_cd | None | 0 | None |
filer_id | 1421500 | |
---|---|---|
xref_id | 1421500 | |
effect_dt | 2019-10-03 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | ||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||
naml | LEGE | LEGE | LEGE | LEGE | LEGE | LEGE | LEGE | LEGE | LEGE | LEGE | LEGE | LEGE | ||||||||||||
namf | MATT | MATT | MATT | MATT | MATT | MATT | MATT | MATT | MATT | MATT | MATT | MATT | ||||||||||||
namt | 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 | ||||||||||||
adr1 | 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 | ||||||||||||
city | 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 | ||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||
phon | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | 9164423838 | ||||||||||||
fax | 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_id | 1421500 |
---|
filer_id | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | 1421500 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2411927_0.cal | 2443941_0.cal | 2487573_0.cal | 2471675_0.cal | 2604081_0.cal | 2580915_0.cal | 2624994_0.cal | 2644669_0.cal | 2708429_0.cal | 121257.cal | 2677762_0.cal | 2748423_0.cal | 123616.cal | 2541594_0.cal | 2531914_0.cal | 2555145_0.cal | ||||||||||||||||
received_date | 2019-10-08 00:00:00 | 2020-01-31 00:00:00 | 2020-07-31 00:00:00 | 2020-04-30 00:00:00 | 2021-08-02 00:00:00 | 2021-04-30 00:00:00 | 2021-11-01 00:00:00 | 2022-01-31 00:00:00 | 2022-08-01 00:00:00 | 2021-04-30 00:00:00 | 2022-05-02 00:00:00 | 2022-10-31 00:00:00 | 2021-04-30 00:00:00 | 2020-12-31 00:00:00 | 2020-11-02 00:00:00 | 2021-02-01 00:00:00 | ||||||||||||||||
filing_directory | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||
filing_id | 2411927 | 2443941 | 2487573 | 2471675 | 2604081 | 2580915 | 2624994 | 2644669 | 2708429 | None | 2677762 | 2748423 | None | 2541594 | 2531914 | 2555145 | ||||||||||||||||
form_id | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | None | F604 | F615 | F615 | ||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted |