filing_id | 2175242 | 2155926 | 2192802 | 2239405 | 2206174 | 2273598 | 2346390 | 2350011 | 2381486 | 2320374 | 2419535 | 2443698 | 2399178 | 2471502 | 2485203 | 2549640 | 2531506 | 2538323 | 2621606 | 2579497 | 2596552 | 2706075 | 2641496 | 2672650 | 2745164 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
sender_id | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | E00246 | 1261533 | E00246 | 1261533 | E00246 | E00246 | E00246 | E00246 | E00246 | 1395038 | E00246 | E00246 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | |||||||||||||||||||||||||
filer_id | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | |||||||||||||||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | FRM | LBY | LBY | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||||||||||||
filer_naml | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | Boehm | BOEHM | Boehm | BOEHM | Boehm | Boehm | Boehm | Boehm | Boehm | BOEHM | Boehm | Boehm | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | |||||||||||||||||||||||||
filer_namf | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | Kelli | KELLI | Kelli | KELLI | Kelli | Kelli | Kelli | Kelli | Kelli | KELLI | Kelli | Kelli | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | 000 | |||||||||||||||||||||||||
rpt_date | 2017-07-27 00:00:00 | 2017-04-20 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-01-31 00:00:00 | 2018-07-31 00:00:00 | 2019-01-23 00:00:00 | 2019-01-26 00:00:00 | 2019-04-30 00:00:00 | 2018-10-17 00:00:00 | 2019-10-31 00:00:00 | 2020-01-29 00:00:00 | 2019-07-30 00:00:00 | 2020-04-29 00:00:00 | 2020-07-31 00:00:00 | 2021-01-28 00:00:00 | 2020-10-30 00:00:00 | 2020-12-11 00:00:00 | 2021-10-28 00:00:00 | 2021-04-29 00:00:00 | 2021-07-26 00:00:00 | 2022-08-01 00:00:00 | 2022-01-28 00:00:00 | 2022-04-28 00:00:00 | 2022-10-28 00:00:00 | |||||||||||||||||||||||||
from_date | 2017-04-01 00:00:00 | 2017-03-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2018-10-29 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-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-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-10-26 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-11-04 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-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 | None | |||||||||||||||||||||||||
firm_id | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | E00246 | 1261533 | E00246 | 1261533 | E00246 | E00246 | E00246 | E00246 | E00246 | 1395038 | E00246 | E00246 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | |||||||||||||||||||||||||
firm_name | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | California Medical Association | POLITICAL SOLUTIONS, LLC | California Medical Association | POLITICAL SOLUTIONS, LLC | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | Centene and its affiliate Health Net | California Medical Association | California Medical Association | Centene and its affiliate Health Net | Centene and its affiliate Health Net | Centene and its affiliate Health Net | Centene and its affiliate Health Net | Centene and its affiliate Health Net | Centene and its affiliate Health Net | Centene and its affiliate Health Net | |||||||||||||||||||||||||
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 | 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 | 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 | 95814 | |||||||||||||||||||||||||
firm_phon | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | (916) 444-5532 | 916 492-2766 | (916) 444-5532 | 916 492-2766 | (916) 444-5532 | (916) 444-5532 | (916) 444-5532 | (916) 444-5532 | (916) 444-5532 | 9164445532 | (916) 444-5532 | (916) 444-5532 | 9165525284 | 9165525284 | 9165525284 | 9165525284 | 9165525284 | 9165525284 | 9165525284 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
sig_date | 2017-07-27 00:00:00 | 2017-04-20 00:00:00 | 2017-10-27 00:00:00 | 2018-04-12 00:00:00 | 2018-01-18 00:00:00 | 2018-07-14 00:00:00 | 2019-01-23 00:00:00 | 2019-01-26 00:00:00 | 2019-04-30 00:00:00 | 2018-10-17 00:00:00 | 2019-10-31 00:00:00 | 2020-01-29 00:00:00 | 2019-07-30 00:00:00 | 2020-04-29 00:00:00 | 2020-07-31 00:00:00 | 2021-01-28 00:00:00 | 2020-10-30 00:00:00 | 2020-12-11 00:00:00 | 2021-10-20 00:00:00 | 2021-04-21 00:00:00 | 2021-07-21 00:00:00 | 2022-07-19 00:00:00 | 2022-01-18 00:00:00 | 2022-04-20 00:00:00 | 2022-10-25 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 | |||||||||||||||||||||||||
sig_naml | BOEHM (444200 SLM) | BOEHM (444200 SLM) | BOEHM (444200 SLM) | BOEHM | BOEHM (444200 SLM) | BOEHM | Boehm | BOEHM | Boehm | BOEHM | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | |||||||||||||||||||||||||
sig_namf | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | Kelli | KELLI | Kelli | KELLI | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
prn_naml | BOEHM (444200 SLM) | BOEHM (444200 SLM) | BOEHM (444200 SLM) | BOEHM | BOEHM (444200 SLM) | BOEHM | Boehm | BOEHM | Boehm | BOEHM | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | Boehm | |||||||||||||||||||||||||
prn_namf | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | Kelli | KELLI | Kelli | KELLI | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | Kelli | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
sig_title | None | None | None | None | None | None | Lobbyist | None | Lobbyist | None | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | None | Lobbyist | Lobbyist | 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 | 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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 |
filing_id | 2144176 | 2144176 | 2326649 | 2330151 | 2540631 | 2540658 | 2540658 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 0 | 0 | 0 | 1 | |||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||
form_type | F604 | F604 | F604 | F604 | F604 | F604 | F604 | |||||||
sender_id | 1261533 | 1261533 | E00246 | E00246 | E24495 | E24495 | E24495 | |||||||
filer_id | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | |||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||
filer_naml | BOEHM | BOEHM | Boehm | Boehm | BOEHM | BOEHM | BOEHM | |||||||
filer_namf | KELLI | KELLI | Kelli | Kelli | KELLI | KELLI | KELLI | |||||||
filer_namt | None | None | None | None | None | None | None | |||||||
filer_nams | None | None | None | None | None | None | None | |||||||
report_num | 000 | 001 | 000 | 000 | 000 | 000 | 001 | |||||||
rpt_date | 2017-02-28 00:00:00 | 2017-11-02 00:00:00 | 2018-10-30 00:00:00 | 2020-12-31 00:00:00 | 2020-12-30 00:00:00 | 2020-12-30 00:00:00 | 2021-06-22 00:00:00 | |||||||
ls_beg_yr | 2017 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | |||||||
ls_end_yr | 2018 | 2018 | 2018 | 2020 | 2020 | 2022 | 2022 | |||||||
qual_date | 2017-03-01 00:00:00 | 2017-03-01 00:00:00 | None | None | None | 2021-01-01 00:00:00 | None | |||||||
eff_date | None | None | None | None | None | None | None | |||||||
bus_city | SACRAMENTO | SACRAMENTO | Sacramento | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | |||||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||
bus_phon | 916 492-2766 | 916 492-2766 | (916) 444-5532 | (916) 444-5532 | 9165525284 | 9165525284 | 9165525284 | |||||||
bus_fax | None | None | None | None | None | None | None | |||||||
bus_email | None | None | None | None | None | None | None | |||||||
mail_city | None | None | None | None | None | None | None | |||||||
mail_st | None | None | None | None | None | None | None | |||||||
mail_zip4 | None | None | None | None | None | None | None | |||||||
mail_phon | None | None | None | None | None | None | None | |||||||
sig_date | 2017-02-28 00:00:00 | 2017-11-02 00:00:00 | 2018-11-26 00:00:00 | 2018-12-26 00:00:00 | 2020-12-08 00:00:00 | 2020-12-08 00:00:00 | 2021-06-14 00:00:00 | |||||||
sig_loc | SACRAMENTO, CA | SACRAMENTO, CA | Sacramento CA | Sacramento CA | None | None | None | |||||||
sig_naml | BOEHM | BOEHM | Boehm | Boehm | BOEHM | BOEHM | BOEHM | |||||||
sig_namf | KELLI | KELLI | Kelli | Kelli | KELLI | KELLI | KELLI | |||||||
sig_namt | None | None | None | None | None | None | None | |||||||
sig_nams | None | None | None | None | None | None | None | |||||||
prn_naml | BOEHM | BOEHM | Boehm | Boehm | BOEHM | BOEHM | BOEHM | |||||||
prn_namf | KELLI | KELLI | Kelli | Kelli | KELLI | KELLI | KELLI | |||||||
prn_namt | None | None | None | None | None | None | None | |||||||
prn_nams | None | None | None | None | None | None | None | |||||||
sig_title | LOBBYIST (4442)SLC | LOBBYIST (4442)SLC | None | None | None | None | None | |||||||
stmt_firm | None | None | None | None | None | None | None | |||||||
ind_cb | None | None | None | None | None | None | None | |||||||
bus_cb | None | None | None | None | None | None | None | |||||||
trade_cb | None | None | None | None | None | None | None | |||||||
oth_cb | None | None | None | None | None | None | None | |||||||
a_b_name | None | None | None | None | None | None | None | |||||||
a_b_city | None | None | None | None | None | None | None | |||||||
a_b_st | None | None | None | None | None | None | None | |||||||
a_b_zip4 | None | None | None | None | None | None | None | |||||||
descrip_1 | None | None | None | None | None | None | None | |||||||
descrip_2 | None | None | None | None | None | None | None | |||||||
c_less50 | None | None | None | None | None | None | None | |||||||
c_more50 | None | None | None | None | None | None | None | |||||||
ind_class | None | None | None | None | None | None | None | |||||||
ind_descr | None | None | None | None | None | None | None | |||||||
bus_class | None | None | None | None | None | None | None | |||||||
bus_descr | None | None | None | None | None | None | None | |||||||
auth_name | None | None | None | None | None | None | None | |||||||
auth_city | None | None | None | None | None | None | None | |||||||
auth_st | None | None | None | None | None | None | None | |||||||
auth_zip4 | None | None | None | None | None | None | None | |||||||
lobby_int | None | None | None | None | None | None | None | |||||||
influen_yn | None | None | None | None | None | None | None | |||||||
firm_name | POLITICAL SOLUTIONS LLC | POLITICAL SOLUTIONS LLC | California Medical Association | California Medical Association | Centene and its affiliate Health Net | Centene and Its Affiliate Health Net | Centene and Its Affiliate Health Net | |||||||
newcert_cb | X | None | None | None | None | None | None | |||||||
rencert_cb | None | None | None | None | None | X | None | |||||||
complet_dt | None | 2017-11-02 00:00:00 | 2017-11-02 00:00:00 | 2018-11-15 00:00:00 | 2018-11-15 00:00:00 | None | 2021-06-10 00:00:00 | |||||||
lby_reg_cb | X | X | X | X | X | X | X | |||||||
lby_604_cb | None | None | None | None | None | None | None | |||||||
st_leg_yn | Y | Y | None | None | Y | Y | Y | |||||||
st_agency | None | None | None | None | None | None | None | |||||||
lobby_cb | None | None | None | None | None | None | None | |||||||
l_firm_cb | None | None | None | None | None | None | None |
filer_id | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2468721 | 2428630 | 2507392 | 2550331 | 2526612 | 2473446 | ||||||
effect_dt | 2018-10-29 00:00:00 | 2017-03-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-10-29 00:00:00 | 2019-01-01 00:00:00 | ||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||
session_id | 2017 | 2017 | 2021 | 2023 | 2021 | 2019 |
filer_id | 1395038 | 1395038 | 1395038 | |||
---|---|---|---|---|---|---|
session_id | 2017 | 2019 | 2021 | |||
ethics_date | 2017-11-02 00:00:00 | 2018-11-15 00:00:00 | 2021-06-10 00:00:00 |
filer_id | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | ||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2330151 | 2419535 | 2194955 | 2206174 | 2336752 | 2320374 | 2531506 | 2151596 | 2155926 | 2144176 | 2175242 | 2273598 | 2326735 | 2346390 | 2443698 | 2350011 | 2485203 | 2471502 | 2192802 | 2540631 | 2579497 | 2538323 | 2239405 | 2569442 | 2326649 | 2144176 | 2381486 | 2399178 | 2591493 | 2596552 | 2540658 | 2706075 | 2621606 | 2549640 | 2641496 | 2672650 | 2540658 | 2745164 | ||||||||||||||||||||||||||||||||||||||
period_id | 244 | 239 | None | 232 | None | 235 | 243 | None | 229 | 229 | 230 | 234 | None | 236 | 240 | 236 | 242 | 241 | 231 | 244 | 245 | 244 | 233 | None | 236 | 232 | 237 | 238 | None | 246 | 244 | 250 | 247 | 244 | 248 | 249 | 246 | 251 | ||||||||||||||||||||||||||||||||||||||
form_id | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | ||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||||||||||||||||||||||||||||||||||||||
filing_date | 2018-12-28 00:00:00 | 2019-10-31 00:00:00 | 2017-11-02 00:00:00 | 2018-01-26 00:00:00 | 2018-12-27 00:00:00 | 2018-10-31 00:00:00 | 2020-11-02 00:00:00 | 2017-03-03 00:00:00 | 2017-04-28 00:00:00 | 2017-03-06 00:00:00 | 2017-07-31 00:00:00 | 2018-07-31 00:00:00 | 2018-11-28 00:00:00 | 2019-01-30 00:00:00 | 2020-01-31 00:00:00 | 2019-01-31 00:00:00 | 2020-07-31 00:00:00 | 2020-04-30 00:00:00 | 2017-10-30 00:00:00 | 2020-12-30 00:00:00 | 2021-04-29 00:00:00 | 2020-12-23 00:00:00 | 2018-04-27 00:00:00 | 2021-01-04 00:00:00 | 2018-11-29 00:00:00 | 2017-11-22 00:00:00 | 2019-04-30 00:00:00 | 2019-07-31 00:00:00 | 2021-06-24 00:00:00 | 2021-07-26 00:00:00 | 2020-12-30 00:00:00 | 2022-08-01 00:00:00 | 2021-10-28 00:00:00 | 2021-01-28 00:00:00 | 2022-01-28 00:00:00 | 2022-04-28 00:00:00 | 2021-06-22 00:00:00 | 2022-10-28 00:00:00 | ||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | ||||||||||||||||||||||||||||||||||||||
stmnt_status | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||
session_id | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2017 | 2021 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||
user_id | GPEREZ | VUKSTINA | PBANFORD | AGLADNEY | GPEREZ | JFRONEFIELD | GTAYLOR | GPEREZ | JINGRAM | GPEREZ | SMCCONNAN | AGLADNEY | GPEREZ | AGLADNEY | VUKSTINA | AGLADNEY | CVANLIEW | VUKSTINA | AGLADNEY | CAFILER | CHARTRIDGE | GTAYLOR | AGLADNEY | JMENDOZA | GPEREZ | GPEREZ | VUKSTINA | VUKSTINA | MMERCHANT | CHATRIDGE | JMENDOZA | CAFILER | GTAYLOR | GTAYLOR | CHATRIDGE | CAFILER | MMERCHANT | 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 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||
rpt_start | 2020-12-31 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-01 00:00:00 | 2017-02-28 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-29 00:00:00 | 2019-10-01 00:00:00 | 2018-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2017-07-01 00:00:00 | 2020-12-30 00:00:00 | 2021-01-01 00:00:00 | 2020-10-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-30 00:00:00 | 2017-11-02 00:00:00 | 2019-01-01 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-12-30 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-06-22 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||
rpt_end | 2020-12-31 00:00:00 | 2019-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-02-28 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2018-10-26 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2017-09-30 00:00:00 | 2020-12-30 00:00:00 | 2021-03-31 00:00:00 | 2020-11-04 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-10-30 00:00:00 | 2017-11-02 00:00:00 | 2019-03-31 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2020-12-30 00:00:00 | 2022-06-30 00:00:00 | 2021-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-06-22 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 | None | None | ||||||||||||||||||||||||||||||||||||||
filing_type | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1395038 | 1395038 | 1395038 | 1395038 | ||||
---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | ||||
active | Y | Y | Y | N | ||||
race | None | 0 | 0 | None | ||||
session_id | 2021 | 2019 | 2017 | 2023 | ||||
category | None | 0 | 0 | None | ||||
category_type | None | 0 | 0 | None | ||||
sub_category | None | 0 | 0 | None | ||||
effect_dt | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-03-01 00:00:00 | 2023-01-01 00:00:00 | ||||
sub_category_type | None | 0 | 0 | None | ||||
election_type | None | 0 | 0 | None | ||||
sub_category_a | None | None | None | None | ||||
nyq_dt | None | None | None | None | ||||
party_cd | None | 0 | 0 | None | ||||
county_cd | None | 0 | 0 | None | ||||
district_cd | None | 0 | 0 | None |
filer_id | 1395038 | |
---|---|---|
xref_id | 1395038 | |
effect_dt | 2017-03-06 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | 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 | 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 | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | BOEHM | ||||||||||||||||||||||||
namf | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | KELLI | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
phon | 9164922766 | 9164445532 | 9164445532 | 9165525284 | 9165525284 | 9165525284 | 9164922766 | 9164445532 | 9164445532 | 9165525284 | 9165525284 | 9165525284 | 9164922766 | 9164445532 | 9164445532 | 9165525284 | 9165525284 | 9165525284 | 9164922766 | 9164445532 | 9164445532 | 9165525284 | 9165525284 | 9165525284 | ||||||||||||||||||||||||
fax | None | 9165512035 | None | 9165512035 | None | 9165512035 | None | 9165512035 | ||||||||||||||||||||||||||||||||||||||||
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 | 1395038 |
---|
filer_id | 1395038 | 1395038 | 1395038 | |||
---|---|---|---|---|---|---|
change_no | 1 | 0 | 2 | |||
session_id | 2017 | 2017 | 2017 | |||
log_dt | 2017-03-03 00:00:00 | 2017-03-03 00:00:00 | 2018-11-02 00:00:00 | |||
filer_type | 4 | 4 | 4 | |||
correction_flg | None | Y | None | |||
action | SET ACTIVE | ADDED | DELETED | |||
attribute_changed | FIRM | FIRM | ||||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | BOEHM, KELLI | BOEHM, KELLI | KELLI BOEHM | |||
filer_city | None | None | None | |||
filer_st | None | None | None | |||
filer_zip | None | None | None | |||
filer_phone | None | None | None | |||
entity_type | 4 | 3 | 3 | |||
entity_name | None | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 0 | 1261533 | 1261533 | |||
responsible_officer | None | None | None | |||
effect_dt | 2017-03-01 00:00:00 | 2017-03-01 00:00:00 | 2018-10-26 00:00:00 |
filer_id | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | 1395038 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2155926_0.cal | 380562.cal | 2144176_0.cal | 2175242_0.cal | 2330151_0.cal | 2206174_0.cal | 2320374_0.cal | 2381486_0.cal | 2419535_0.cal | 2273598_0.cal | 2399178_0.cal | 2350011_0.cal | 2346390_0.cal | 2471502_0.cal | 2192802_0.cal | 2239405_0.cal | 2485203_0.cal | 2326649_0.cal | 2443698_0.cal | 2144176_1.cal | 2531506_0.cal | 2540631_0.cal | 2538323_0.cal | 2540658_1.cal | 2540658_0.cal | |||||||||||||||||||||||||
received_date | 2017-04-28 00:00:00 | 2017-03-06 00:00:00 | 2017-03-06 00:00:00 | 2017-07-31 00:00:00 | 2018-12-28 00:00:00 | 2018-01-26 00:00:00 | 2018-10-31 00:00:00 | 2019-04-30 00:00:00 | 2019-10-31 00:00:00 | 2018-07-31 00:00:00 | 2019-07-31 00:00:00 | 2019-01-31 00:00:00 | 2019-01-30 00:00:00 | 2020-04-30 00:00:00 | 2017-10-30 00:00:00 | 2018-04-27 00:00:00 | 2020-07-31 00:00:00 | 2018-11-29 00:00:00 | 2020-01-31 00:00:00 | 2017-11-22 00:00:00 | 2020-11-02 00:00:00 | 2020-12-30 00:00:00 | 2020-12-23 00:00:00 | 2021-06-22 00:00:00 | 2020-12-30 00:00:00 | |||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/cal | /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 | |||||||||||||||||||||||||
filing_id | 2155926 | None | 2144176 | 2175242 | 2330151 | 2206174 | 2320374 | 2381486 | 2419535 | 2273598 | 2399178 | 2350011 | 2346390 | 2471502 | 2192802 | 2239405 | 2485203 | 2326649 | 2443698 | 2144176 | 2531506 | 2540631 | 2538323 | 2540658 | 2540658 | |||||||||||||||||||||||||
form_id | F615 | None | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F604 | F604 | |||||||||||||||||||||||||
receive_comment | Filing accepted | 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 |