filing_id | 2273615 | 2241824 | 2349839 | 2320660 | 2382025 | 2444511 | 2471088 | 2398411 | 2415578 | 2554799 | 2531873 | 2487558 | 2581505 | 2604175 | 2625632 | 2678479 | 2708684 | 2644508 | 2749888 | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | |||||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||
sender_id | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | |||||||||||||||||||
filer_id | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | |||||||||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||||||||||||||
filer_naml | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | |||||||||||||||||||
filer_namf | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | |||||||||||||||||||
filer_namt | 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 | |||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||
rpt_date | 2018-07-24 00:00:00 | 2018-04-27 00:00:00 | 2019-01-24 00:00:00 | 2018-10-29 00:00:00 | 2019-04-30 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2019-10-31 00:00:00 | 2021-01-31 00:00:00 | 2020-10-31 00:00:00 | 2020-07-31 00:00:00 | 2021-04-28 00:00:00 | 2021-04-28 00:00:00 | 2021-04-28 00:00:00 | 2022-04-30 00:00:00 | 2022-07-28 00:00:00 | 2021-04-28 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||
from_date | 2018-04-01 00:00:00 | 2018-03-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-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 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 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 | None | None | None | None | None | None | None | |||||||||||||||||||
firm_id | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | F24767 | |||||||||||||||||||
firm_name | BBC PUBLIC AFFAIRS, LLC | BBC PUBLIC AFFAIRS, LLC | BBC PUBLIC AFFAIRS, LLC | BBC PUBLIC AFFAIRS, LLC | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | |||||||||||||||||||
firm_city | 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 | |||||||||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||
firm_phon | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | 916 441-4242 | |||||||||||||||||||
mail_city | 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 | |||||||||||||||||||
mail_zip4 | 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 | |||||||||||||||||||
sig_date | 2018-07-24 00:00:00 | 2018-04-27 00:00:00 | 2019-01-24 00:00:00 | 2018-10-29 00:00:00 | 2019-04-30 00:00:00 | 2020-01-31 00:00:00 | 2020-04-27 00:00:00 | 2019-07-22 00:00:00 | 2019-10-10 00:00:00 | 2021-01-31 00:00:00 | 2020-10-31 00:00:00 | 2020-07-22 00:00:00 | 2021-04-28 00:00:00 | 2021-07-31 00:00:00 | 2021-10-31 00:00:00 | 2022-04-30 00:00:00 | 2022-07-28 00:00:00 | 2022-01-31 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 | |||||||||||||||||||
sig_naml | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | |||||||||||||||||||
sig_namf | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | |||||||||||||||||||
sig_namt | 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 | |||||||||||||||||||
prn_naml | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | |||||||||||||||||||
prn_namf | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | |||||||||||||||||||
prn_namt | 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 | |||||||||||||||||||
sig_title | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||
nopart1_cb | 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 | |||||||||||||||||||
part1_1_cb | 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 | |||||||||||||||||||
ctrib_n_cb | 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 | |||||||||||||||||||
lby_actvty | 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 | |||||||||||||||||||
lobby_y_cb | 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 | |||||||||||||||||||
major_namf | 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 | |||||||||||||||||||
major_nams | 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 | |||||||||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 2225152 | 2225152 | 2330755 | 2544399 | 2544399 | |||||
---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 0 | 1 | |||||
rec_type | CVR | CVR | CVR | CVR | CVR | |||||
form_type | F604 | F604 | F604 | F604 | F604 | |||||
sender_id | F24767 | F24767 | F24767 | F24767 | F24767 | |||||
filer_id | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | |||||
entity_cd | LBY | LBY | LBY | LBY | LBY | |||||
filer_naml | GUARD | GUARD | GUARD | GUARD | GUARD | |||||
filer_namf | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | |||||
filer_namt | None | None | None | None | None | |||||
filer_nams | None | None | None | None | None | |||||
report_num | 000 | 001 | 000 | 000 | 001 | |||||
rpt_date | 2018-03-09 00:00:00 | 2018-03-22 00:00:00 | 2018-12-30 00:00:00 | 2020-12-31 00:00:00 | 2021-02-17 00:00:00 | |||||
ls_beg_yr | 2017 | 2017 | 2019 | 2021 | 2021 | |||||
ls_end_yr | 2018 | 2018 | 2020 | 2022 | 2022 | |||||
qual_date | 2018-03-01 00:00:00 | 2018-03-01 00:00:00 | None | None | None | |||||
eff_date | None | None | None | None | None | |||||
bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||
bus_st | CA | CA | CA | CA | CA | |||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||
bus_phon | (916) 441-4242 | (916) 441-4242 | (916) 441-4242 | (916) 441-4242 | (916) 441-4242 | |||||
bus_fax | None | None | None | None | None | |||||
bus_email | None | None | None | None | None | |||||
mail_city | None | None | None | None | None | |||||
mail_st | None | None | None | None | None | |||||
mail_zip4 | None | None | None | None | None | |||||
mail_phon | None | None | None | None | None | |||||
sig_date | 2018-03-09 00:00:00 | 2018-03-22 00:00:00 | 2018-12-15 00:00:00 | 2020-12-24 00:00:00 | 2021-02-17 00:00:00 | |||||
sig_loc | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | |||||
sig_naml | GUARD | GUARD | GUARD | GUARD | GUARD | |||||
sig_namf | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | |||||
sig_namt | None | None | None | None | None | |||||
sig_nams | None | None | None | None | None | |||||
prn_naml | GUARD | GUARD | GUARD | GUARD | GUARD | |||||
prn_namf | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | |||||
prn_namt | None | None | None | None | None | |||||
prn_nams | None | None | None | None | None | |||||
sig_title | SELF | SELF | SELF | LOBBYIST | LOBBYIST | |||||
stmt_firm | None | None | None | None | None | |||||
ind_cb | None | None | None | None | None | |||||
bus_cb | None | None | None | None | None | |||||
trade_cb | None | None | None | None | None | |||||
oth_cb | None | None | None | None | None | |||||
a_b_name | None | None | None | None | None | |||||
a_b_city | None | None | None | None | None | |||||
a_b_st | None | None | None | None | None | |||||
a_b_zip4 | None | None | None | None | None | |||||
descrip_1 | None | None | None | None | None | |||||
descrip_2 | None | None | None | None | None | |||||
c_less50 | None | None | None | None | None | |||||
c_more50 | None | None | None | None | None | |||||
ind_class | None | None | None | None | None | |||||
ind_descr | None | None | None | None | None | |||||
bus_class | None | None | None | None | None | |||||
bus_descr | None | None | None | None | None | |||||
auth_name | None | None | None | None | None | |||||
auth_city | None | None | None | None | None | |||||
auth_st | None | None | None | None | None | |||||
auth_zip4 | None | None | None | None | None | |||||
lobby_int | None | None | None | None | None | |||||
influen_yn | None | None | None | None | None | |||||
firm_name | BBC PUBLIC AFFAIRS, LLC | BBC PUBLIC AFFAIRS, LLC | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | J. BLONIEN, A PROFESSIONAL LAW CORPORATION | |||||
newcert_cb | X | None | None | None | None | |||||
rencert_cb | None | None | None | X | None | |||||
complet_dt | None | 2018-03-22 00:00:00 | 2018-03-01 00:00:00 | None | 2021-01-28 00:00:00 | |||||
lby_reg_cb | X | X | X | X | X | |||||
lby_604_cb | None | None | None | None | None | |||||
st_leg_yn | Y | Y | Y | None | None | |||||
st_agency | None | None | None | None | None | |||||
lobby_cb | None | None | None | None | None | |||||
l_firm_cb | None | None | None | None | None |
filer_id | 1404155 | 1404155 | 1404155 | 1404155 | ||||
---|---|---|---|---|---|---|---|---|
adrid | 2549141 | 2469405 | 2448741 | 2506923 | ||||
effect_dt | 2023-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-03-01 00:00:00 | 2021-01-01 00:00:00 | ||||
add_type | 7051 | 7051 | 7051 | 7051 | ||||
session_id | 2023 | 2019 | 2017 | 2021 |
filer_id | 1404155 | 1404155 | 1404155 | |||
---|---|---|---|---|---|---|
session_id | 2017 | 2019 | 2021 | |||
ethics_date | 2018-03-22 00:00:00 | 2018-03-22 00:00:00 | 2021-01-28 00:00:00 |
filer_id | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2339111 | 2349839 | 2330755 | 2241824 | 2554799 | 2224856 | 2273615 | 2531873 | 2415578 | 2398411 | 2225152 | 2225152 | 2586099 | 2224819 | 2224821 | 2544399 | 2320660 | 2487558 | 2382025 | 2444511 | 2581505 | 2544399 | 2471088 | 2604175 | 2678479 | 2708684 | 2625632 | 2590218 | 2644508 | 2749888 | ||||||||||||||||||||||||||||||
period_id | None | 236 | 236 | 233 | 244 | None | 234 | 243 | 239 | 238 | 233 | 233 | None | None | None | 245 | 235 | 242 | 237 | 240 | 245 | 244 | 241 | 246 | 249 | 250 | 247 | None | 248 | 251 | ||||||||||||||||||||||||||||||
form_id | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F999 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | ||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
filing_date | 2018-12-28 00:00:00 | 2019-01-31 00:00:00 | 2018-12-28 00:00:00 | 2018-04-30 00:00:00 | 2021-02-01 00:00:00 | 2018-03-22 00:00:00 | 2018-07-31 00:00:00 | 2020-11-02 00:00:00 | 2019-10-25 00:00:00 | 2019-07-31 00:00:00 | 2018-03-26 00:00:00 | 2018-03-26 00:00:00 | 2021-01-14 00:00:00 | 2018-03-22 00:00:00 | 2018-03-22 00:00:00 | 2021-02-22 00:00:00 | 2018-10-31 00:00:00 | 2020-07-31 00:00:00 | 2019-04-30 00:00:00 | 2020-02-01 00:00:00 | 2021-04-30 00:00:00 | 2021-01-14 00:00:00 | 2020-04-30 00:00:00 | 2021-08-02 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2021-11-01 00:00:00 | 2021-02-22 00:00:00 | 2022-01-31 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10005 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | ||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||
session_id | 2019 | 2017 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2021 | 2017 | 2017 | 2021 | 2017 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||
user_id | DMCCASTL | AGLADNEY | CAFILER | AGLADNEY | MKIRKHAM | PBANFORD | JFRONEFIELD | GTAYLOR | VUKSTINA | VUKSTINA | CAFILER | CAFILER | MKIRKHAM | GPEREZ | GPEREZ | MMERCHANT | JFRONEFIELD | CVANLIEW | SUSHAKOV | VUKSTINA | CHARTRIDGE | MKIRKHAM | VUKSTINA | CHATRIDGE | CAFILER | CAFILER | MKIRKHAM | MMERCHANT | RATTIYEH | 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 | ||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-12-30 00:00:00 | 2018-03-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-04-01 00:00:00 | 2020-07-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-03-09 00:00:00 | 2018-03-22 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-02-17 00:00:00 | 2018-07-01 00:00:00 | 2020-04-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2021-01-01 00:00:00 | 2020-12-31 00:00:00 | 2020-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2018-12-30 00:00:00 | 2018-03-31 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-06-30 00:00:00 | 2020-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-03-09 00:00:00 | 2018-03-22 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-02-17 00:00:00 | 2018-09-30 00:00:00 | 2020-06-30 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 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 | ||||||||||||||||||||||||||||||
filing_type | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1404155 | 1404155 | 1404155 | 1404155 | ||||
---|---|---|---|---|---|---|---|---|
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 | 2018-03-01 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 | 1404155 | |
---|---|---|
xref_id | 1404155 | |
effect_dt | 2018-03-23 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | ||||||||||||||||
filer_type | 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 | ||||||||||||||||
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 | ||||||||||||||||
naml | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | GUARD | ||||||||||||||||
namf | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | DANIELLE | ||||||||||||||||
namt | 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 | ||||||||||||||||
adr1 | 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 | ||||||||||||||||
city | 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 | ||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||
phon | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | 9164414242 | ||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
None | None | sos@stephencompany.com | sos@stephencompany.com | None | None | sos@stephencompany.com | sos@stephencompany.com | None | None | sos@stephencompany.com | sos@stephencompany.com | None | None | sos@stephencompany.com | sos@stephencompany.com |
filer_id | 1404155 |
---|
filer_id | 1404155 | |
---|---|---|
change_no | 0 | |
session_id | 2017 | |
log_dt | 2018-03-22 00:00:00 | |
filer_type | 4 | |
correction_flg | Y | |
action | ADDED | |
attribute_changed | FIRM | |
ethics_dt | None | |
interests | None | |
filer_full_name | GUARD, DANIELLE | |
filer_city | None | |
filer_st | None | |
filer_zip | None | |
filer_phone | None | |
entity_type | 3 | |
entity_name | BBC PUBLIC AFFAIRS, LLC | |
entity_city | None | |
entity_st | None | |
entity_zip | None | |
entity_phone | None | |
entity_id | 1147643 | |
responsible_officer | None | |
effect_dt | 2018-03-01 00:00:00 |
filer_id | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | 1404155 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2349839_0.cal | 2330755_0.cal | 2415578_0.cal | 2241824_0.cal | 2471088_0.cal | 2382025_0.cal | 2273615_0.cal | 2398411_0.cal | 2487558_0.cal | 2444511_0.cal | 2225152_0.cal | 2225152_1.cal | 2320660_0.cal | 2604175_0.cal | 2625632_0.cal | 2531873_0.cal | 2544399_0.cal | 2644508_0.cal | 2581505_0.cal | 2708684_0.cal | 2544399_1.cal | 2749888_0.cal | 2554799_0.cal | 2678479_0.cal | ||||||||||||||||||||||||
received_date | 2019-01-31 00:00:00 | 2018-12-28 00:00:00 | 2019-10-25 00:00:00 | 2018-04-30 00:00:00 | 2020-04-30 00:00:00 | 2019-04-30 00:00:00 | 2018-07-31 00:00:00 | 2019-07-31 00:00:00 | 2020-07-31 00:00:00 | 2020-02-01 00:00:00 | 2018-03-26 00:00:00 | 2018-03-26 00:00:00 | 2018-10-31 00:00:00 | 2021-08-02 00:00:00 | 2021-11-01 00:00:00 | 2020-11-02 00:00:00 | 2021-01-14 00:00:00 | 2022-01-31 00:00:00 | 2021-04-30 00:00:00 | 2022-08-01 00:00:00 | 2021-02-22 00:00:00 | 2022-10-31 00:00:00 | 2021-02-01 00:00:00 | 2022-05-02 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/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 | 2349839 | 2330755 | 2415578 | 2241824 | 2471088 | 2382025 | 2273615 | 2398411 | 2487558 | 2444511 | 2225152 | 2225152 | 2320660 | 2604175 | 2625632 | 2531873 | 2544399 | 2644508 | 2581505 | 2708684 | 2544399 | 2749888 | 2554799 | 2678479 | ||||||||||||||||||||||||
form_id | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | ||||||||||||||||||||||||
receive_comment | 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 |