| filing_id | 2175251 | 2155945 | 2192808 | 2239450 | 2273607 | 2206184 | 2381618 | 2320408 | 2350041 | 2393883 | 2444371 | 2417257 | 2469182 | 2554374 | 2529548 | 2483294 | 2602837 | 2581335 | 2621000 | 2675716 | 2707392 | 2642253 | 2746607 | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| sender_id | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | |||||||||||||||||||||||
| filer_id | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| filer_naml | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | HYZDU | WERNER | HYZDU | HYZDU | HYZDU | HYZDU | HYZDU | |||||||||||||||||||||||
| filer_namf | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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-07-31 00:00:00 | 2018-01-31 00:00:00 | 2019-04-26 00:00:00 | 2018-10-17 00:00:00 | 2019-01-26 00:00:00 | 2019-07-31 00:00:00 | 2020-01-24 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2021-01-31 00:00:00 | 2020-10-31 00:00:00 | 2020-04-30 00:00:00 | 2021-01-31 00:00:00 | 2021-01-31 00:00:00 | 2021-01-31 00:00:00 | 2022-04-30 00:00:00 | 2022-07-25 00:00:00 | 2022-01-25 00:00:00 | 2022-10-21 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 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-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 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 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 | None | None | None | None | |||||||||||||||||||||||
| firm_id | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | 1261533 | |||||||||||||||||||||||
| firm_name | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | POLITICAL SOLUTIONS, LLC | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| firm_phon | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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-07-14 00:00:00 | 2018-01-18 00:00:00 | 2019-04-26 00:00:00 | 2018-10-17 00:00:00 | 2019-01-26 00:00:00 | 2019-07-17 00:00:00 | 2020-01-24 00:00:00 | 2019-10-16 00:00:00 | 2020-04-17 00:00:00 | 2021-01-21 00:00:00 | 2020-10-17 00:00:00 | 2020-07-19 00:00:00 | 2021-07-21 00:00:00 | 2021-04-26 00:00:00 | 2021-10-19 00:00:00 | 2022-04-28 00:00:00 | 2022-07-25 00:00:00 | 2022-01-25 00:00:00 | 2022-10-21 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 | |||||||||||||||||||||||
| sig_naml | WERNER (444200-SLM) | WERNER (444200-SLM) | WERNER (444200-SLM) | WERNER | WERNER | WERNER (444200-SLM) | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | HYZDU | WERNER | HYZDU | HYZDU | HYZDU | HYZDU | HYZDU | |||||||||||||||||||||||
| sig_namf | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| prn_naml | WERNER (444200-SLM) | WERNER (444200-SLM) | WERNER (444200-SLM) | WERNER | WERNER | WERNER (444200-SLM) | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | HYZDU | WERNER | HYZDU | HYZDU | HYZDU | HYZDU | HYZDU | |||||||||||||||||||||||
| prn_namf | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| sig_title | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 | |||||||||||||||||||||||
| 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 |
| filing_id | 2144177 | 2144177 | 2331176 | 2538725 | ||||
|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 1 | 0 | 0 | ||||
| rec_type | CVR | CVR | CVR | CVR | ||||
| form_type | F604 | F604 | F604 | F604 | ||||
| sender_id | 1261533 | 1261533 | 1261533 | 1261533 | ||||
| filer_id | 1395039 | 1395039 | 1395039 | 1395039 | ||||
| entity_cd | LBY | LBY | LBY | LBY | ||||
| filer_naml | WERNER | WERNER | WERNER | WERNER | ||||
| filer_namf | MELISSA | MELISSA | MELISSA | MELISSA | ||||
| filer_namt | None | None | None | None | ||||
| filer_nams | None | None | None | None | ||||
| report_num | 000 | 001 | 000 | 000 | ||||
| rpt_date | 2017-02-28 00:00:00 | 2017-11-02 00:00:00 | 2018-12-30 00:00:00 | 2020-12-31 00:00:00 | ||||
| ls_beg_yr | 2017 | 2017 | 2019 | 2021 | ||||
| ls_end_yr | 2018 | 2018 | 2020 | 2022 | ||||
| qual_date | 2017-03-01 00:00:00 | 2017-03-01 00:00:00 | None | None | ||||
| eff_date | None | None | None | None | ||||
| bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||
| bus_st | CA | CA | CA | CA | ||||
| bus_zip4 | 95814 | 95814 | 95814 | 95814 | ||||
| bus_phon | 916 492-2766 | 916 492-2766 | 916 492-2766 | 916 492-2766 | ||||
| bus_fax | None | None | None | None | ||||
| bus_email | None | None | None | None | ||||
| mail_city | None | None | None | None | ||||
| mail_st | None | None | None | None | ||||
| mail_zip4 | None | None | None | None | ||||
| mail_phon | None | None | None | None | ||||
| sig_date | 2017-02-28 00:00:00 | 2017-11-02 00:00:00 | 2018-12-14 00:00:00 | 2020-12-08 00:00:00 | ||||
| sig_loc | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | ||||
| sig_naml | WERNER | WERNER | WERNER | WERNER | ||||
| sig_namf | MELISSA | MELISSA | MELISSA | MELISSA | ||||
| sig_namt | None | None | None | None | ||||
| sig_nams | None | None | None | None | ||||
| prn_naml | WERNER | WERNER | WERNER | WERNER | ||||
| prn_namf | MELISSA | MELISSA | MELISSA | MELISSA | ||||
| prn_namt | None | None | None | None | ||||
| prn_nams | None | None | None | None | ||||
| sig_title | LOBBYIST (4442)SLC | LOBBYIST (4442)SLC | LOBBYIST | LOBBYIST | ||||
| stmt_firm | None | None | None | None | ||||
| ind_cb | None | None | None | None | ||||
| bus_cb | None | None | None | None | ||||
| trade_cb | None | None | None | None | ||||
| oth_cb | None | None | None | None | ||||
| a_b_name | None | None | None | None | ||||
| a_b_city | None | None | None | None | ||||
| a_b_st | None | None | None | None | ||||
| a_b_zip4 | None | None | None | None | ||||
| descrip_1 | None | None | None | None | ||||
| descrip_2 | None | None | None | None | ||||
| c_less50 | None | None | None | None | ||||
| c_more50 | None | None | None | None | ||||
| ind_class | None | None | None | None | ||||
| ind_descr | None | None | None | None | ||||
| bus_class | None | None | None | None | ||||
| bus_descr | None | None | None | None | ||||
| auth_name | None | None | None | None | ||||
| auth_city | None | None | None | None | ||||
| auth_st | None | None | None | None | ||||
| auth_zip4 | None | None | None | None | ||||
| lobby_int | None | None | None | None | ||||
| influen_yn | None | None | None | None | ||||
| firm_name | POLITICAL SOLUTIONS LLC | POLITICAL SOLUTIONS LLC | POLITICAL SOLUTIONS LLC | POLITICAL SOLUTIONS LLC | ||||
| newcert_cb | X | None | None | None | ||||
| rencert_cb | None | None | None | None | ||||
| complet_dt | None | 2017-11-02 00:00:00 | 2018-11-15 00:00:00 | 2020-12-03 00:00:00 | ||||
| lby_reg_cb | X | X | X | X | ||||
| lby_604_cb | None | None | None | None | ||||
| st_leg_yn | Y | Y | Y | Y | ||||
| st_agency | None | None | None | None | ||||
| lobby_cb | None | None | None | None | ||||
| l_firm_cb | None | None | None | None |
| filer_id | 1395039 | 1395039 | 1395039 | 1395039 | ||||
|---|---|---|---|---|---|---|---|---|
| adrid | 2428631 | 2470741 | 2550047 | 2509086 | ||||
| effect_dt | 2017-03-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||
| add_type | 7051 | 7051 | 7051 | 7051 | ||||
| session_id | 2017 | 2019 | 2023 | 2021 |
| filer_id | 1395039 | 1395039 | 1395039 | |||
|---|---|---|---|---|---|---|
| session_id | 2019 | 2017 | 2021 | |||
| ethics_date | 2018-11-15 00:00:00 | 2017-11-02 00:00:00 | 2020-12-03 00:00:00 |
| filer_id | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | |||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2192808 | 2195037 | 2538725 | 2206184 | 2554374 | 2350041 | 2273607 | 2239450 | 2381618 | 2155945 | 2151644 | 2144177 | 2175251 | 2417257 | 2393883 | 2331176 | 2320408 | 2569030 | 2469182 | 2483294 | 2351444 | 2144177 | 2444371 | 2602837 | 2529548 | 2581335 | 2642253 | 2675716 | 2707392 | 2621000 | 2746607 | |||||||||||||||||||||||||||||||
| period_id | 231 | None | 244 | 232 | 244 | 236 | 234 | 233 | 237 | 229 | None | 229 | 230 | 239 | 238 | 236 | 235 | None | 241 | 242 | None | 232 | 240 | 246 | 243 | 245 | 248 | 249 | 250 | 247 | 251 | |||||||||||||||||||||||||||||||
| form_id | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
| filing_date | 2017-10-30 00:00:00 | 2017-11-02 00:00:00 | 2020-12-28 00:00:00 | 2018-01-26 00:00:00 | 2021-02-01 00:00:00 | 2019-01-31 00:00:00 | 2018-07-31 00:00:00 | 2018-04-27 00:00:00 | 2019-04-30 00:00:00 | 2017-04-28 00:00:00 | 2017-03-03 00:00:00 | 2017-03-06 00:00:00 | 2017-07-31 00:00:00 | 2019-10-29 00:00:00 | 2019-07-26 00:00:00 | 2018-12-31 00:00:00 | 2018-10-31 00:00:00 | 2020-12-30 00:00:00 | 2020-04-29 00:00:00 | 2020-07-29 00:00:00 | 2018-12-31 00:00:00 | 2017-11-22 00:00:00 | 2020-01-31 00:00:00 | 2021-08-02 00:00:00 | 2020-11-01 00:00:00 | 2021-04-30 00:00:00 | 2022-01-29 00:00:00 | 2022-05-01 00:00:00 | 2022-08-01 00:00:00 | 2021-10-27 00:00:00 | 2022-10-30 00:00:00 | |||||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||
| session_id | 2017 | 2017 | 2021 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2021 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||
| user_id | AGLADNEY | PBANFORD | MMERCHANT | AGLADNEY | GTAYLOR | JFRONEFIELD | AGLADNEY | AGLADNEY | JFRONEFIELD | SMCCONNAN | GPEREZ | GPEREZ | SMCCONNAN | VUKSTINA | VUKSTINA | PBANFORD | JFRONEFIELD | MMERCHANT | VUKSTINA | VUKSTINA | PBANFORD | CAFILER | VUKSTINA | CHATRIDGE | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | CAFILER | 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 | |||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||
| rpt_start | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2017-10-01 00:00:00 | 2020-10-01 00:00:00 | 2018-10-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-03-01 00:00:00 | 1900-01-01 00:00:00 | 2017-02-28 00:00:00 | 2017-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-12-30 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2017-11-02 00:00:00 | 2019-10-01 00:00:00 | 2021-04-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||
| rpt_end | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2017-12-31 00:00:00 | 2020-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2019-03-31 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-02-28 00:00:00 | 2017-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-12-30 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2017-11-02 00:00:00 | 2019-12-31 00:00:00 | 2021-06-30 00:00:00 | 2020-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-09-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 | |||||||||||||||||||||||||||||||
| filing_type | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
| filer_id | 1395039 | 1395039 | 1395039 | 1395039 | ||||
|---|---|---|---|---|---|---|---|---|
| filer_type | 4 | 4 | 4 | 4 | ||||
| active | Y | Y | Y | N | ||||
| race | None | None | 0 | None | ||||
| session_id | 2021 | 2019 | 2017 | 2023 | ||||
| category | None | None | 0 | None | ||||
| category_type | None | None | 0 | None | ||||
| sub_category | None | None | 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 | None | 0 | None | ||||
| election_type | None | None | 0 | None | ||||
| sub_category_a | None | None | None | None | ||||
| nyq_dt | None | None | None | None | ||||
| party_cd | None | None | 0 | None | ||||
| county_cd | None | None | 0 | None | ||||
| district_cd | None | None | 0 | None |
| filer_id | 1395039 | |
|---|---|---|
| xref_id | 1395039 | |
| effect_dt | 2017-03-06 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | ||||||||||||||||||||
| 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 | HYZDU | HYZDU | HYZDU | HYZDU | HYZDU | HYZDU | HYZDU | HYZDU | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | WERNER | ||||||||||||||||||||
| namf | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA | ||||||||||||||||||||
| 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 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | 9164922766 | ||||||||||||||||||||
| fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||
| None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
| filer_id | 1395039 |
|---|
| filer_id | 1395039 | 1395039 | ||
|---|---|---|---|---|
| change_no | 0 | 1 | ||
| session_id | 2017 | 2017 | ||
| log_dt | 2017-03-03 00:00:00 | 2017-03-03 00:00:00 | ||
| filer_type | 4 | 4 | ||
| correction_flg | Y | None | ||
| action | ADDED | SET ACTIVE | ||
| attribute_changed | FIRM | |||
| ethics_dt | None | None | ||
| interests | None | None | ||
| filer_full_name | WERNER, MELISSA | WERNER, MELISSA | ||
| filer_city | None | None | ||
| filer_st | None | None | ||
| filer_zip | None | None | ||
| filer_phone | None | None | ||
| entity_type | 3 | 4 | ||
| entity_name | POLITICAL SOLUTIONS, LLC | None | ||
| entity_city | None | None | ||
| entity_st | None | None | ||
| entity_zip | None | None | ||
| entity_phone | None | None | ||
| entity_id | 1261533 | 0 | ||
| responsible_officer | None | None | ||
| effect_dt | 2017-03-01 00:00:00 | 2017-03-01 00:00:00 |
| filer_id | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | 1395039 | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 2155945_0.cal | 2144177_0.cal | 2175251_0.cal | 2192808_0.cal | 2417257_0.cal | 2350041_0.cal | 2393883_0.cal | 2206184_0.cal | 2239450_0.cal | 2273607_0.cal | 2320408_0.cal | 2331176_0.cal | 2483294_0.cal | 2444371_0.cal | 2381618_0.cal | 2144177_1.cal | 2469182_0.cal | 2538725_0.cal | 2707392_0.cal | 2621000_0.cal | 2554374_0.cal | 2581335_0.cal | 2746607_0.cal | 2642253_0.cal | 23675.cal | 2675716_0.cal | 2529548_0.cal | 2602837_0.cal | ||||||||||||||||||||||||||||
| received_date | 2017-04-28 00:00:00 | 2017-03-06 00:00:00 | 2017-07-31 00:00:00 | 2017-10-30 00:00:00 | 2019-10-29 00:00:00 | 2019-01-31 00:00:00 | 2019-07-26 00:00:00 | 2018-01-26 00:00:00 | 2018-04-27 00:00:00 | 2018-07-31 00:00:00 | 2018-10-31 00:00:00 | 2018-12-31 00:00:00 | 2020-07-29 00:00:00 | 2020-01-31 00:00:00 | 2019-04-30 00:00:00 | 2017-11-22 00:00:00 | 2020-04-29 00:00:00 | 2020-12-28 00:00:00 | 2022-08-01 00:00:00 | 2021-10-27 00:00:00 | 2021-02-01 00:00:00 | 2021-04-30 00:00:00 | 2022-10-30 00:00:00 | 2022-01-29 00:00:00 | 2022-01-29 00:00:00 | 2022-05-01 00:00:00 | 2020-11-01 00:00:00 | 2021-08-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 | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||
| filing_id | 2155945 | 2144177 | 2175251 | 2192808 | 2417257 | 2350041 | 2393883 | 2206184 | 2239450 | 2273607 | 2320408 | 2331176 | 2483294 | 2444371 | 2381618 | 2144177 | 2469182 | 2538725 | 2707392 | 2621000 | 2554374 | 2581335 | 2746607 | 2642253 | None | 2675716 | 2529548 | 2602837 | ||||||||||||||||||||||||||||
| form_id | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | None | 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 | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted |