| filing_id | 2192615 | 2273048 | 2237814 | 2212054 | 2317442 | 2348894 | 2380015 | 2398475 | 2442130 | 2419966 | 2470933 | 2483975 | 2530106 | 2553290 | 2599404 | 2580750 | 2624889 | 2675955 | 2644927 | 2705483 | 2747121 | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 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 | |||||||||||||||||||||
| form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||
| sender_id | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | C27881 | C27881 | C27881 | C27881 | C27881 | C27881 | C27881 | |||||||||||||||||||||
| filer_id | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | |||||||||||||||||||||
| entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||||||||||||||||
| filer_naml | SAPORTA CHENG | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | |||||||||||||||||||||
| filer_namf | CARLA | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | CARLA | CARLA V. | CARLA | CARLA | CARLA | CARLA | CARLA | |||||||||||||||||||||
| filer_namt | 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 | |||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||
| rpt_date | 2017-10-31 00:00:00 | 2018-07-30 00:00:00 | 2018-04-26 00:00:00 | 2018-01-31 00:00:00 | 2018-10-30 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2019-07-31 00:00:00 | 2020-01-31 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2020-07-30 00:00:00 | 2020-11-02 00:00:00 | 2021-02-01 00:00:00 | 2021-07-27 00:00:00 | 2021-04-28 00:00:00 | 2021-10-22 00:00:00 | 2022-04-19 00:00:00 | 2022-01-21 00:00:00 | 2022-07-20 00:00:00 | 2022-10-10 00:00:00 | |||||||||||||||||||||
| from_date | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-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-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-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 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||
| thru_date | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-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-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 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 | 2021-12-31 00:00:00 | 2022-06-30 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 | |||||||||||||||||||||
| firm_id | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | C27881 | C27881 | C27881 | C27881 | C27881 | C27881 | C27881 | |||||||||||||||||||||
| firm_name | BLUE SHIELD OF CALIFORNIA | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | Blue Shield of California | CVS HEALTH | CVS HEALTH | CVS HEALTH | CVS HEALTH | CVS HEALTH | CVS HEALTH | CVS HEALTH | |||||||||||||||||||||
| firm_city | SACRAMENTO | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | |||||||||||||||||||||
| firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | DC | DC | DC | DC | DC | DC | DC | |||||||||||||||||||||
| firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 20004 | 20004 | 20004 | 20004 | 20004 | 20004 | 20004 | |||||||||||||||||||||
| firm_phon | 916 552-2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 916 552 2960 | 202 772-3500 | (202) 772-3500 | 202 772-3500 | 202 772-3500 | 202 772-3500 | 202 772-3500 | 202 772-3500 | |||||||||||||||||||||
| mail_city | 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 | |||||||||||||||||||||
| mail_zip4 | 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 | |||||||||||||||||||||
| sig_date | 2017-10-23 00:00:00 | 2018-07-30 00:00:00 | 2018-04-26 00:00:00 | 2018-01-31 00:00:00 | 2018-10-29 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2019-07-31 00:00:00 | 2020-01-31 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2020-07-30 00:00:00 | 2020-10-30 00:00:00 | 2021-02-01 00:00:00 | 2021-07-27 00:00:00 | 2021-04-28 00:00:00 | 2021-10-22 00:00:00 | 2022-04-19 00:00:00 | 2022-01-21 00:00:00 | 2022-07-20 00:00:00 | 2022-10-10 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 | WASHINGTON, DC | SACRAMENTO, CA | WASHINGTON, DC | WASHINGTON, DC | WASHINGTON, DC | WASHINGTON, DC | WASHINGTON, DC | |||||||||||||||||||||
| sig_naml | SAPORTA CHENG | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | |||||||||||||||||||||
| sig_namf | CARLA | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | |||||||||||||||||||||
| sig_namt | 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 | |||||||||||||||||||||
| prn_naml | SAPORTA CHENG | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | Saporta Cheng | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | |||||||||||||||||||||
| prn_namf | CARLA | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | Carla | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | |||||||||||||||||||||
| prn_namt | 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 | |||||||||||||||||||||
| sig_title | 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 | |||||||||||||||||||||
| nopart2_cb | 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 | |||||||||||||||||||||
| part1_2_cb | 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 | |||||||||||||||||||||
| ctrib_y_cb | 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 | |||||||||||||||||||||
| lobby_n_cb | 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 | |||||||||||||||||||||
| major_naml | 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 | |||||||||||||||||||||
| major_namt | 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 | |||||||||||||||||||||
| rcpcmte_nm | 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 |
| filing_id | 2185614 | 2325699 | 2325699 | 2540820 | 2584070 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 1 | 0 | 0 | |||||
| rec_type | CVR | CVR | CVR | CVR | CVR | |||||
| form_type | F604 | F604 | F604 | F604 | F604 | |||||
| sender_id | E24676 | E24676 | E24676 | E24676 | C27881 | |||||
| filer_id | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | |||||
| entity_cd | LBY | LBY | LBY | LBY | LBY | |||||
| filer_naml | SAPORTA CHENG | Saporta Cheng | Saporta Cheng | Saporta Cheng | SAPORTA CHENG | |||||
| filer_namf | CARLA | Carla | Carla | Carla | CARLA V. | |||||
| filer_namt | None | None | None | None | None | |||||
| filer_nams | None | None | None | None | None | |||||
| report_num | 000 | 000 | 001 | 000 | 000 | |||||
| rpt_date | 2017-08-28 00:00:00 | 2018-10-31 00:00:00 | 2018-10-31 00:00:00 | 2020-12-30 00:00:00 | 2021-02-05 00:00:00 | |||||
| ls_beg_yr | 2017 | 2019 | 2019 | 2021 | 2021 | |||||
| ls_end_yr | 2018 | 2020 | 2020 | 2022 | 2022 | |||||
| qual_date | 2017-08-21 00:00:00 | None | None | None | 2021-01-25 00:00:00 | |||||
| eff_date | None | None | None | None | None | |||||
| bus_city | SACRAMENTO | Sacramento | Sacramento | Sacramento | WEST SACRAMENTO | |||||
| bus_st | CA | CA | CA | CA | CA | |||||
| bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95605 | |||||
| bus_phon | (916) 552-2965 | 916 552 2960 | 916 552 2960 | 916 552 2960 | (916) 208-4890 | |||||
| bus_fax | None | None | None | None | None | |||||
| bus_email | None | [email protected] | [email protected] | [email protected] | 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 | 2017-08-28 00:00:00 | 2018-10-04 00:00:00 | 2018-10-04 00:00:00 | 2020-12-15 00:00:00 | 2021-02-05 00:00:00 | |||||
| sig_loc | SACRAMENTO, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | SACRAMENTO, CA | |||||
| sig_naml | SAPORTA CHENG | Saporta Cheng | Saporta Cheng | Saporta Cheng | SAPORTA CHENG | |||||
| sig_namf | CARLA | Carla | Carla | Carla | CARLA V. | |||||
| sig_namt | None | None | None | None | None | |||||
| sig_nams | None | None | None | None | None | |||||
| prn_naml | SAPORTA CHENG | Saporta Cheng | Saporta Cheng | Saporta Cheng | SAPORTA CHENG | |||||
| prn_namf | CARLA | Carla | Carla | Carla | CARLA V. | |||||
| prn_namt | None | None | None | None | None | |||||
| prn_nams | None | None | None | None | None | |||||
| sig_title | SELF | None | None | Government Affairs Manager | 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 | BLUE SHIELD OF CALIFORNIA | Blue Shield of California | Blue Shield of California | Blue Shield of California | CVS HEALTH | |||||
| newcert_cb | X | None | None | None | None | |||||
| rencert_cb | None | None | None | X | None | |||||
| complet_dt | None | None | 2017-11-02 00:00:00 | None | 2021-02-12 00:00:00 | |||||
| lby_reg_cb | X | X | X | X | X | |||||
| lby_604_cb | None | None | None | None | None | |||||
| st_leg_yn | Y | N | N | N | Y | |||||
| st_agency | None | None | None | None | None | |||||
| lobby_cb | None | None | None | None | None | |||||
| l_firm_cb | None | None | None | None | None |
| filer_id | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2523409 | 2439644 | 2552811 | 2507151 | 2465583 | |||||
| effect_dt | 2021-01-25 00:00:00 | 2017-08-21 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | |||||
| session_id | 2021 | 2017 | 2023 | 2021 | 2019 |
| filer_id | 1398945 | 1398945 | ||
|---|---|---|---|---|
| session_id | 2017 | 2021 | ||
| ethics_date | 2017-11-02 00:00:00 | 2021-02-12 00:00:00 |
| filer_id | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | |||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2195016 | 2185614 | 2184306 | 2184310 | 2317442 | 2470933 | 2327770 | 2237814 | 2442130 | 2348894 | 2483975 | 2540820 | 2419966 | 2398475 | 2325699 | 2530106 | 2273048 | 2322801 | 2325699 | 2212054 | 2192615 | 2380015 | 2610829 | 2599404 | 2675955 | 2565909 | 2553290 | 2580750 | 2584070 | 2644927 | 2705483 | 2624889 | 2747121 | |||||||||||||||||||||||||||||||||
| period_id | None | 231 | None | None | 235 | 241 | None | 233 | 240 | 236 | 242 | 244 | 239 | 238 | 236 | 243 | 234 | None | 236 | 232 | 231 | 237 | None | 246 | 249 | None | 244 | 245 | 245 | 248 | 250 | 247 | 251 | |||||||||||||||||||||||||||||||||
| form_id | F604 | F604 | F604 | F999 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||
| filing_sequence | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| filing_date | 2017-11-02 00:00:00 | 2017-09-27 00:00:00 | 2017-09-14 00:00:00 | 2017-09-14 00:00:00 | 2018-10-30 00:00:00 | 2020-04-30 00:00:00 | 2018-11-01 00:00:00 | 2018-04-26 00:00:00 | 2020-01-31 00:00:00 | 2019-01-31 00:00:00 | 2020-07-30 00:00:00 | 2020-12-30 00:00:00 | 2019-10-31 00:00:00 | 2019-07-31 00:00:00 | 2018-11-28 00:00:00 | 2020-11-02 00:00:00 | 2018-07-30 00:00:00 | 2018-10-31 00:00:00 | 2018-11-15 00:00:00 | 2018-01-31 00:00:00 | 2017-10-30 00:00:00 | 2019-04-30 00:00:00 | 2021-03-30 00:00:00 | 2021-07-29 00:00:00 | 2022-05-02 00:00:00 | 2020-12-31 00:00:00 | 2021-02-01 00:00:00 | 2021-04-30 00:00:00 | 2021-05-14 00:00:00 | 2022-01-31 00:00:00 | 2022-07-31 00:00:00 | 2021-11-01 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||
| stmnt_type | 10006 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 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 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||
| session_id | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||
| user_id | PBANFORD | YRODRIGU | GPEREZ | GPEREZ | JFRONEFIELD | VUKSTINA | GPEREZ | AGLADNEY | VUKSTINA | AGLADNEY | CVANLIEW | CVANLIEW | VUKSTINA | VUKSTINA | GPEREZ | GTAYLOR | JFRONEFIELD | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | VUKSTINA | CVANLIEW | GTAYLOR | MKIRKHAM | CVANLIEW | GTAYLOR | GTAYLOR | CVANLIEW | RATTIYEH | CAFILER | CHATRIDGE | 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 | |||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||
| rpt_start | 1900-01-01 00:00:00 | 2017-08-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-10-01 00:00:00 | 2018-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-12-30 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-31 00:00:00 | 2020-07-01 00:00:00 | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-31 00:00:00 | 2017-10-01 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-05 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||
| rpt_end | 1900-01-01 00:00:00 | 2017-08-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2019-12-31 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-30 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-10-31 00:00:00 | 2020-09-30 00:00:00 | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 2018-10-31 00:00:00 | 2017-12-31 00:00:00 | 2017-09-30 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-02-05 00:00:00 | 2021-12-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 | None | None | |||||||||||||||||||||||||||||||||
| filing_type | None | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
| filer_id | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 4 | 4 | 4 | 4 | 4 | 4 | ||||||
| active | Y | Y | T | Y | Y | N | ||||||
| race | 0 | None | None | None | None | None | ||||||
| session_id | 2017 | 2021 | 2021 | 2021 | 2019 | 2023 | ||||||
| category | 0 | None | None | None | None | None | ||||||
| category_type | 0 | None | None | None | None | None | ||||||
| sub_category | 0 | None | None | None | None | None | ||||||
| effect_dt | 2017-08-21 00:00:00 | 2021-01-01 00:00:00 | 2021-01-23 00:00:00 | 2021-01-25 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||
| sub_category_type | 0 | None | None | None | None | None | ||||||
| election_type | 0 | None | None | None | None | None | ||||||
| sub_category_a | None | None | None | None | None | None | ||||||
| nyq_dt | None | None | None | None | None | None | ||||||
| party_cd | 0 | None | None | None | None | None | ||||||
| county_cd | 0 | None | None | None | None | None | ||||||
| district_cd | 0 | None | None | None | None | None |
| filer_id | 1398945 | |
|---|---|---|
| xref_id | 1398945 | |
| effect_dt | 2017-09-15 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | ||||||||||||||||||||
| 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 | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | SAPORTA CHENG | ||||||||||||||||||||
| namf | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V. | CARLA V | CARLA V | CARLA V | CARLA V | CARLA V | CARLA | CARLA | CARLA | CARLA | CARLA | ||||||||||||||||||||
| 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 | WEST SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | WEST 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 | 95605 | 95605 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95814 | 95814 | 95605 | 95605 | ||||||||||||||||||||
| phon | 9165522965 | 9165522965 | 9165522960 | 9162084890 | 9162084890 | 9165522965 | 9165522965 | 9165522960 | 9162084890 | 9162084890 | 9165522965 | 9165522965 | 9165522960 | 9162084890 | 9162084890 | 9165522965 | 9165522965 | 9165522960 | 9162084890 | 9162084890 | ||||||||||||||||||||
| fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||
| None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | None |
| filer_id | 1398945 |
|---|
| filer_id | 1398945 | |
|---|---|---|
| change_no | 0 | |
| session_id | 2017 | |
| log_dt | 2017-09-14 00:00:00 | |
| filer_type | 4 | |
| correction_flg | Y | |
| action | ADDED | |
| attribute_changed | EMPLOYER | |
| ethics_dt | None | |
| interests | None | |
| filer_full_name | SAPORTA CHENG, CARLA | |
| filer_city | None | |
| filer_st | None | |
| filer_zip | None | |
| filer_phone | None | |
| entity_type | 2 | |
| entity_name | BLUE SHIELD OF CALIFORNIA | |
| entity_city | None | |
| entity_st | None | |
| entity_zip | None | |
| entity_phone | None | |
| entity_id | 1147130 | |
| responsible_officer | None | |
| effect_dt | 2017-08-21 00:00:00 |
| filer_id | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | 1398945 | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 2380015_0.cal | 2185614_0.cal | 2398475_0.cal | 2317442_0.cal | 2483975_0.cal | 2237814_0.cal | 2348894_0.cal | 2442130_0.cal | 2470933_0.cal | 2419966_0.cal | 2325699_1.cal | 2273048_0.cal | 2212054_0.cal | 2192615_0.cal | 2599404_0.cal | 2553290_0.cal | 2540820_0.cal | 2580750_0.cal | 2584070_0.cal | 2747121_0.cal | 2675955_0.cal | 2530106_0.cal | 2705483_0.cal | 2644927_0.cal | 2624889_0.cal | |||||||||||||||||||||||||
| received_date | 2019-04-30 00:00:00 | 2017-09-27 00:00:00 | 2019-07-31 00:00:00 | 2018-10-30 00:00:00 | 2020-07-30 00:00:00 | 2018-04-26 00:00:00 | 2019-01-31 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2019-10-31 00:00:00 | 2018-11-28 00:00:00 | 2018-07-30 00:00:00 | 2018-01-31 00:00:00 | 2017-10-30 00:00:00 | 2021-07-29 00:00:00 | 2021-02-01 00:00:00 | 2020-12-30 00:00:00 | 2021-04-30 00:00:00 | 2021-05-14 00:00:00 | 2022-10-31 00:00:00 | 2022-05-02 00:00:00 | 2020-11-02 00:00:00 | 2022-07-31 00:00:00 | 2022-01-31 00:00:00 | 2021-11-01 00:00:00 | |||||||||||||||||||||||||
| filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/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 | 2380015 | 2185614 | 2398475 | 2317442 | 2483975 | 2237814 | 2348894 | 2442130 | 2470933 | 2419966 | 2325699 | 2273048 | 2212054 | 2192615 | 2599404 | 2553290 | 2540820 | 2580750 | 2584070 | 2747121 | 2675955 | 2530106 | 2705483 | 2644927 | 2624889 | |||||||||||||||||||||||||
| form_id | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | 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 accepted |