filing_id | 2171115 | 2158058 | 2192534 | 2274830 | 2207230 | 2241016 | 2380787 | 2346342 | 2319729 | 2443391 | 2399318 | 2471611 | 2419721 | 2486411 | 2486966 | 2531241 | 2554923 | 2579271 | 2624329 | 2599913 | 2707920 | 2677733 | 2644892 | 2748303 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
sender_id | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E01348 | E00207 | E01348 | E01348 | E01348 | E01348 | E01348 | E01348 | E01348 | E01348 | E01348 | ||||||||||||||||||||||||
filer_id | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | ||||||||||||||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||||||||||||||
filer_naml | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | ||||||||||||||||||||||||
filer_namf | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
report_num | 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 | 2017-07-18 00:00:00 | 2017-04-27 00:00:00 | 2017-10-24 00:00:00 | 2018-07-30 00:00:00 | 2018-01-25 00:00:00 | 2018-04-27 00:00:00 | 2019-04-30 00:00:00 | 2019-01-30 00:00:00 | 2018-10-31 00:00:00 | 2020-01-30 00:00:00 | 2019-07-31 00:00:00 | 2020-04-30 00:00:00 | 2019-10-31 00:00:00 | 2020-07-28 00:00:00 | 2020-07-31 00:00:00 | 2020-10-30 00:00:00 | 2021-01-28 00:00:00 | 2021-04-29 00:00:00 | 2021-11-01 00:00:00 | 2021-07-21 00:00:00 | 2022-08-01 00:00:00 | 2022-05-02 00:00:00 | 2022-01-28 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||
from_date | 2017-04-01 00:00:00 | 2017-01-03 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-06-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||
thru_date | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-03-31 00:00:00 | 2019-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-05-31 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 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 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||
firm_id | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E00207 | E01348 | E00207 | E01348 | E01348 | E01348 | E01348 | E01348 | E01348 | E01348 | E01348 | E01348 | ||||||||||||||||||||||||
firm_name | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Faculty Association | California Federation of Teachers | California Faculty Association | California Faculty Association | California Faculty Association | California Faculty Association | California Faculty Association | California Faculty Association | California Faculty Association | California Faculty Association | California Faculty Association | ||||||||||||||||||||||||
firm_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 | ||||||||||||||||||||||||
firm_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 | ||||||||||||||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||
firm_phon | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | 9164414848 | (916) 446-2788 | 9164414848 | 9164414848 | 9164414848 | 9164414848 | 9164414848 | 9164414848 | 9164414848 | 9164414848 | 9164414848 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
sig_date | 2017-07-18 00:00:00 | 2017-04-27 00:00:00 | 2017-10-24 00:00:00 | 2018-07-30 00:00:00 | 2018-01-25 00:00:00 | 2018-04-27 00:00:00 | 2019-04-30 00:00:00 | 2019-01-30 00:00:00 | 2018-10-31 00:00:00 | 2020-01-30 00:00:00 | 2019-07-31 00:00:00 | 2020-04-30 00:00:00 | 2019-10-29 00:00:00 | 2020-07-28 00:00:00 | 2020-07-31 00:00:00 | 2020-10-30 00:00:00 | 2021-01-28 00:00:00 | 2021-04-29 00:00:00 | 2021-11-01 00:00:00 | 2021-07-21 00:00:00 | 2022-08-01 00:00:00 | 2022-05-02 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 | 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 | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | ||||||||||||||||||||||||
sig_namf | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
prn_naml | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | Ha | ||||||||||||||||||||||||
prn_namf | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
sig_title | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | 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 | 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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 |
filing_id | 2119292 | 2119292 | 2327920 | 2475983 | 2537404 | 2537404 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 0 | 0 | 1 | ||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | ||||||
form_type | F604 | F604 | F604 | F604 | F604 | F604 | ||||||
sender_id | E00207 | E00207 | E00207 | E01348 | E01348 | E01348 | ||||||
filer_id | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | ||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | ||||||
filer_naml | Ha | Ha | Ha | Ha | Ha | Ha | ||||||
filer_namf | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | ||||||
filer_namt | None | None | None | None | None | None | ||||||
filer_nams | None | None | None | None | None | None | ||||||
report_num | 000 | 001 | 000 | 000 | 000 | 001 | ||||||
rpt_date | 2017-01-12 00:00:00 | 2017-04-24 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2022-12-31 00:00:00 | 2021-03-02 00:00:00 | ||||||
ls_beg_yr | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | ||||||
ls_end_yr | 2018 | 2018 | 2020 | 2020 | 2022 | 2022 | ||||||
qual_date | 2017-01-03 00:00:00 | 2017-01-03 00:00:00 | None | 2020-06-01 00:00:00 | 2020-06-01 00:00:00 | 2020-06-01 00:00:00 | ||||||
eff_date | None | None | None | None | None | None | ||||||
bus_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | ||||||
bus_st | CA | CA | CA | CA | CA | CA | ||||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||
bus_phon | (916) 446-2788 | (916) 446-2788 | (916) 446-2788 | 9164414848 | 9164414848 | 9164414848 | ||||||
bus_fax | None | None | None | None | None | None | ||||||
bus_email | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | ||||||
mail_city | None | None | None | None | None | None | ||||||
mail_st | None | None | None | None | None | None | ||||||
mail_zip4 | None | None | None | None | None | None | ||||||
mail_phon | None | None | None | None | None | None | ||||||
sig_date | 2017-01-12 00:00:00 | 2017-04-24 00:00:00 | 2018-12-05 00:00:00 | 2020-06-02 00:00:00 | 2020-11-20 00:00:00 | 2021-03-02 00:00:00 | ||||||
sig_loc | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | ||||||
sig_naml | Ha | Ha | Ha | Ha | Ha | Ha | ||||||
sig_namf | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | ||||||
sig_namt | None | None | None | None | None | None | ||||||
sig_nams | None | None | None | None | None | None | ||||||
prn_naml | Ha | Ha | Ha | Ha | Ha | Ha | ||||||
prn_namf | Bryan | Bryan | Bryan | Bryan | Bryan | Bryan | ||||||
prn_namt | None | None | None | None | None | None | ||||||
prn_nams | None | None | None | None | None | None | ||||||
sig_title | None | None | None | None | None | None | ||||||
stmt_firm | None | None | None | None | None | None | ||||||
ind_cb | None | None | None | None | None | None | ||||||
bus_cb | None | None | None | None | None | None | ||||||
trade_cb | None | None | None | None | None | None | ||||||
oth_cb | None | None | None | None | None | None | ||||||
a_b_name | None | None | None | None | None | None | ||||||
a_b_city | None | None | None | None | None | None | ||||||
a_b_st | None | None | None | None | None | None | ||||||
a_b_zip4 | None | None | None | None | None | None | ||||||
descrip_1 | None | None | None | None | None | None | ||||||
descrip_2 | None | None | None | None | None | None | ||||||
c_less50 | None | None | None | None | None | None | ||||||
c_more50 | None | None | None | None | None | None | ||||||
ind_class | None | None | None | None | None | None | ||||||
ind_descr | None | None | None | None | None | None | ||||||
bus_class | None | None | None | None | None | None | ||||||
bus_descr | None | None | None | None | None | None | ||||||
auth_name | None | None | None | None | None | None | ||||||
auth_city | None | None | None | None | None | None | ||||||
auth_st | None | None | None | None | None | None | ||||||
auth_zip4 | None | None | None | None | None | None | ||||||
lobby_int | None | None | None | None | None | None | ||||||
influen_yn | None | None | None | None | None | None | ||||||
firm_name | California Federation of Teachers | California Federation of Teachers | California Federation of Teachers | California Faculty Association | California Faculty Association | California Faculty Association | ||||||
newcert_cb | X | None | None | None | None | None | ||||||
rencert_cb | None | None | None | None | X | None | ||||||
complet_dt | None | 2017-04-20 00:00:00 | 2018-11-15 00:00:00 | 2018-11-15 00:00:00 | None | 2021-01-28 00:00:00 | ||||||
lby_reg_cb | X | X | X | X | X | X | ||||||
lby_604_cb | None | None | None | None | None | None | ||||||
st_leg_yn | None | None | None | None | None | None | ||||||
st_agency | None | None | None | None | None | None | ||||||
lobby_cb | None | None | None | None | None | None | ||||||
l_firm_cb | None | None | None | None | None | None |
filer_id | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | |||||
---|---|---|---|---|---|---|---|---|---|---|
adrid | 2421395 | 2545991 | 2507325 | 2465826 | 2495306 | |||||
effect_dt | 2017-01-03 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-06-01 00:00:00 | |||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | |||||
session_id | 2017 | 2023 | 2021 | 2019 | 2019 |
filer_id | 1393502 | 1393502 | 1393502 | |||
---|---|---|---|---|---|---|
session_id | 2019 | 2017 | 2021 | |||
ethics_date | 2018-11-15 00:00:00 | 2017-04-20 00:00:00 | 2021-01-28 00:00:00 |
filer_id | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2274830 | 2207230 | 2579271 | 2241016 | 2327920 | 2192534 | 2380787 | 2119292 | 2121692 | 2154197 | 2119292 | 2158058 | 2171115 | 2346342 | 2480559 | 2486966 | 2336887 | 2537404 | 2486411 | 2475983 | 2531241 | 2319729 | 2471611 | 2399318 | 2419721 | 2443391 | 2537404 | 2677733 | 2707920 | 2591579 | 2624329 | 2644892 | 2554923 | 2558950 | 2599913 | 2748303 | ||||||||||||||||||||||||||||||||||||
period_id | 234 | 232 | 245 | 233 | 244 | 231 | 237 | 229 | None | None | 230 | 229 | 230 | 236 | None | 242 | None | 245 | 242 | 244 | 243 | 235 | 241 | 238 | 239 | 240 | 252 | 249 | 250 | None | 247 | 248 | 244 | None | 246 | 251 | ||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | ||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | ||||||||||||||||||||||||||||||||||||
filing_date | 2018-07-31 00:00:00 | 2018-01-29 00:00:00 | 2021-04-29 00:00:00 | 2018-04-30 00:00:00 | 2018-12-12 00:00:00 | 2017-10-30 00:00:00 | 2019-04-30 00:00:00 | 2017-01-12 00:00:00 | 2017-01-12 00:00:00 | 2017-04-20 00:00:00 | 2017-04-28 00:00:00 | 2017-05-01 00:00:00 | 2017-07-25 00:00:00 | 2019-01-30 00:00:00 | 2020-07-02 00:00:00 | 2020-07-31 00:00:00 | 2018-12-12 00:00:00 | 2021-03-17 00:00:00 | 2020-07-31 00:00:00 | 2020-07-01 00:00:00 | 2020-11-02 00:00:00 | 2018-10-31 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2019-10-31 00:00:00 | 2020-01-31 00:00:00 | 2020-12-17 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2021-02-05 00:00:00 | 2021-11-01 00:00:00 | 2022-01-31 00:00:00 | 2021-02-01 00:00:00 | 2020-12-17 00:00:00 | 2021-07-29 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||
stmnt_status | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||
session_id | 2017 | 2017 | 2021 | 2017 | 2019 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||
user_id | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | PBANFORD | PBANFORD | JINGRAM | SMCCONNAN | AGLADNEY | GPEREZ | GTAYLOR | PBANFORD | CVANLIEW | GTAYLOR | GPEREZ | GTAYLOR | JFRONEFIELD | VUKSTINA | VUKSTINA | VUKSTINA | VUKSTINA | CVANLIEW | CAFILER | CAFILER | CVANLIEW | CHATRIDGE | RATTIYEH | JMAVES | CVANLIEW | GTAYLOR | CAFILER | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||
rpt_start | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2021-01-01 00:00:00 | 2018-01-01 00:00:00 | 2020-12-31 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-12 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-24 00:00:00 | 2017-01-03 00:00:00 | 2017-04-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-03-02 00:00:00 | 2020-06-01 00:00:00 | 2020-12-31 00:00:00 | 2020-07-01 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2022-12-31 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||
rpt_end | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2021-03-31 00:00:00 | 2018-03-31 00:00:00 | 2020-12-31 00:00:00 | 2017-09-30 00:00:00 | 2019-03-31 00:00:00 | 2017-01-12 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-24 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-05-31 00:00:00 | 1900-01-01 00:00:00 | 2021-03-02 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2018-09-30 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2022-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
filing_type | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1393502 | 1393502 | 1393502 | 1393502 | ||||
---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | ||||
active | Y | Y | Y | N | ||||
race | 0 | None | None | None | ||||
session_id | 2017 | 2021 | 2019 | 2023 | ||||
category | 0 | None | None | None | ||||
category_type | 0 | None | None | None | ||||
sub_category | 0 | None | None | None | ||||
effect_dt | 2017-01-03 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||
sub_category_type | 0 | None | None | None | ||||
election_type | 0 | None | None | None | ||||
sub_category_a | None | None | None | None | ||||
nyq_dt | None | None | None | None | ||||
party_cd | 0 | None | None | None | ||||
county_cd | 0 | None | None | None | ||||
district_cd | 0 | None | None | None |
filer_id | 1393502 | |
---|---|---|
xref_id | 1393502 | |
effect_dt | 2017-01-12 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | ||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | 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 | 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 | 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 | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | HA | ||||||||||||||||||||
namf | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | BRYAN | ||||||||||||||||||||
namt | 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 | ||||||||||||||||||||
adr1 | 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 | ||||||||||||||||||||
city | 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 | ||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||
phon | 9164462788 | 9164462788 | 9164414848 | 9164414848 | 9164414848 | 9164462788 | 9164462788 | 9164414848 | 9164414848 | 9164414848 | 9164462788 | 9164462788 | 9164414848 | 9164414848 | 9164414848 | 9164462788 | 9164462788 | 9164414848 | 9164414848 | 9164414848 | ||||||||||||||||||||
fax | ||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1393502 |
---|
filer_id | 1393502 | 1393502 | ||
---|---|---|---|---|
change_no | 1 | 0 | ||
session_id | 2019 | 2019 | ||
log_dt | 2020-07-20 00:00:00 | 2020-07-02 00:00:00 | ||
filer_type | 4 | 4 | ||
correction_flg | None | None | ||
action | DELETED | ADDED | ||
attribute_changed | EMPLOYER | EMPLOYER | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | BRYAN HA | HA, BRYAN | ||
filer_city | None | None | ||
filer_st | None | None | ||
filer_zip | None | None | ||
filer_phone | None | None | ||
entity_type | 2 | 2 | ||
entity_name | CALIFORNIA FEDERATION OF TEACHERS | CALIFORNIA FACULTY ASSOCIATION | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1146791 | 1146877 | ||
responsible_officer | None | None | ||
effect_dt | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 |
filer_id | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | 1393502 | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 170622.cal | 170665.cal | 170675.cal | 2119292_0.cal | 2119292_1.cal | 2158058_0.cal | 2171115_0.cal | 2486411_0.cal | 2274830_0.cal | 2471611_0.cal | 2207230_0.cal | 2241016_0.cal | 2327920_0.cal | 2192534_0.cal | 2346342_0.cal | 2419721_0.cal | 2486966_0.cal | 2443391_0.cal | 2399318_0.cal | 2475983_0.cal | 2380787_0.cal | 2319729_0.cal | 2624329_0.cal | 2579271_0.cal | 2554923_0.cal | 2537404_1.cal | 2677733_0.cal | 2707920_0.cal | 2531241_0.cal | 2537404_0.cal | 2748303_0.cal | 2644892_0.cal | 2599913_0.cal | |||||||||||||||||||||||||||||||||
received_date | 2017-01-12 00:00:00 | 2017-01-12 00:00:00 | 2017-01-12 00:00:00 | 2017-01-12 00:00:00 | 2017-04-28 00:00:00 | 2017-05-01 00:00:00 | 2017-07-25 00:00:00 | 2020-07-31 00:00:00 | 2018-07-31 00:00:00 | 2020-04-30 00:00:00 | 2018-01-29 00:00:00 | 2018-04-30 00:00:00 | 2018-12-12 00:00:00 | 2017-10-30 00:00:00 | 2019-01-30 00:00:00 | 2019-10-31 00:00:00 | 2020-07-31 00:00:00 | 2020-01-31 00:00:00 | 2019-07-31 00:00:00 | 2020-07-01 00:00:00 | 2019-04-30 00:00:00 | 2018-10-31 00:00:00 | 2021-11-01 00:00:00 | 2021-04-29 00:00:00 | 2021-02-01 00:00:00 | 2021-03-17 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2020-11-02 00:00:00 | 2020-12-17 00:00:00 | 2022-10-31 00:00:00 | 2022-01-31 00:00:00 | 2021-07-29 00:00:00 | |||||||||||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/temp | /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 | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||
filing_id | None | None | None | 2119292 | 2119292 | 2158058 | 2171115 | 2486411 | 2274830 | 2471611 | 2207230 | 2241016 | 2327920 | 2192534 | 2346342 | 2419721 | 2486966 | 2443391 | 2399318 | 2475983 | 2380787 | 2319729 | 2624329 | 2579271 | 2554923 | 2537404 | 2677733 | 2707920 | 2531241 | 2537404 | 2748303 | 2644892 | 2599913 | |||||||||||||||||||||||||||||||||
form_id | None | None | None | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||
receive_comment | Filing passed validation, but failed DB constraints | 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 | Filing accepted |