Table: expn
filing_id |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
| 2741037 |
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 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
form_type |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
tran_id |
| 500064259 |
| 500064262 |
| 500064263 |
| 500064243 |
| 500064253 |
| 500064255 |
| 500064257 |
| 500064245 |
| 500064241 |
| 500064329 |
| 500064247 |
| 500064249 |
| 500064259 |
| 500064262 |
| 500064263 |
| 500064243 |
| 500064253 |
| 500064255 |
| 500064257 |
| 500064245 |
| 500064241 |
| 500064329 |
| 500064247 |
| 500064249 |
entity_cd |
| COM |
| PTY |
| PTY |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| OTH |
| COM |
| COM |
| COM |
| PTY |
| PTY |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| OTH |
| COM |
| COM |
payee_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| California Association of Dental Plans PAC |
| California Democratic Party |
| California Democratic Party |
| Isaac Bryan for Assembly 2022 |
| Jim Wood for Assembly 2022 |
| Joaquin Arambula for Assembly 2022 |
| Lena Gonzalez for Senate 2024 |
| Major General Richard D. Roth, USAF (Ret.) for Insurance Commissioner 2026 |
| Nancy Skinner for Treasurer 2026 |
| Non-California Transactions |
| Robert Rivas for Assembly 2022 |
| Susan Rubio for Senate 2022 |
payee_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 |
payee_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 |
payee_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 |
payee_city |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Nashville |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Nashville |
| Sacramento |
| Sacramento |
payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| TN |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| TN |
| CA |
| CA |
payee_zip4 |
| 95814-3970 |
| 95811-7012 |
| 95811-7012 |
| 95814-3805 |
| 95814-3805 |
| 95814-3805 |
| 95814-3937 |
| 95814-3937 |
| 95814-3937 |
| 37203 |
| 95814-3805 |
| 95814-3805 |
| 95814-3970 |
| 95811-7012 |
| 95811-7012 |
| 95814-3805 |
| 95814-3805 |
| 95814-3805 |
| 95814-3937 |
| 95814-3937 |
| 95814-3937 |
| 37203 |
| 95814-3805 |
| 95814-3805 |
expn_date |
| 2022-10-18 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
amount |
| 5000 |
| 15000 |
| 15000 |
| 2500 |
| 4900 |
| 4900 |
| 3000 |
| 3000 |
| 4900 |
| 146750 |
| 2500 |
| 3000 |
| 5000 |
| 15000 |
| 15000 |
| 2500 |
| 4900 |
| 4900 |
| 3000 |
| 3000 |
| 4900 |
| 146750 |
| 2500 |
| 3000 |
cum_ytd |
| 5000 |
| 30000 |
| 30000 |
| 2500 |
| 4900 |
| 4900 |
| 3000 |
| 3000 |
| 4900 |
| 349250 |
| 2500 |
| 3000 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cum_oth |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
expn_chkno |
| 1277 |
| 1286 |
| 1287 |
| 1284 |
| 1281 |
| 1282 |
| 1283 |
| 1279 |
| 1278 |
| None |
| 1285 |
| 1280 |
| 1277 |
| 1286 |
| 1287 |
| 1284 |
| 1281 |
| 1282 |
| 1283 |
| 1279 |
| 1278 |
| None |
| 1285 |
| 1280 |
expn_code |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
expn_dscr |
| Contribution to State PAC |
| Contribution to State Party |
| Contribution to State Party Committee |
| CA-55 State Assembly |
| CA-2 State Assembly |
| CA-31 State Assembly |
| CA-33 State Senate |
| P2026; Insurance Commissioner |
| P2026 State Treasurer |
| Contributions to Non-CA Committees |
| CA-29 State Assembly |
| CA-22 State Senate |
| Contribution to State PAC |
| Contribution to State Party |
| Contribution to State Party Committee |
| CA-55 State Assembly |
| CA-2 State Assembly |
| CA-31 State Assembly |
| CA-33 State Senate |
| P2026; Insurance Commissioner |
| P2026 State Treasurer |
| Contributions to Non-CA Committees |
| CA-29 State Assembly |
| CA-22 State Senate |
agent_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 |
agent_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 |
agent_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 |
agent_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 |
cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 1305436 |
| 741666 |
| 741666 |
| 1435259 |
| 1434721 |
| 1434574 |
| 1435497 |
| 1434784 |
| 1446928 |
| None |
| 1434962 |
| 1415107 |
tres_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 |
tres_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 |
tres_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 |
tres_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 |
tres_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 |
tres_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 |
tres_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 |
cand_naml |
| California Association of Dental Plans PAC |
| California Democratic Party |
| California Democratic Party |
| Bryan |
| Wood |
| Arambula |
| Gonzalez |
| Roth |
| Skinner |
| Non-California Transactions |
| Rivas |
| Rubio |
| None |
| None |
| None |
| Bryan |
| Wood |
| Arambula |
| Gonzalez |
| Roth |
| Skinner |
| None |
| Rivas |
| Rubio |
cand_namf |
| None |
| None |
| None |
| Isaac |
| Jim |
| Joaquin |
| Lena |
| Richard |
| Nancy |
| None |
| Robert |
| Susan |
| None |
| None |
| None |
| Isaac |
| Jim |
| Joaquin |
| Lena |
| Richard |
| Nancy |
| None |
| Robert |
| Susan |
cand_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 |
cand_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 |
office_cd |
| None |
| None |
| None |
| ASM |
| ASM |
| ASM |
| SEN |
| INS |
| TRE |
| None |
| ASM |
| SEN |
| None |
| None |
| None |
| ASM |
| ASM |
| ASM |
| SEN |
| INS |
| TRE |
| None |
| ASM |
| SEN |
offic_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
juris_cd |
| None |
| None |
| None |
| ASM |
| ASM |
| ASM |
| SEN |
| STW |
| STW |
| None |
| ASM |
| SEN |
| None |
| None |
| None |
| ASM |
| ASM |
| ASM |
| SEN |
| STW |
| STW |
| None |
| ASM |
| SEN |
juris_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
dist_no |
| None |
| None |
| None |
| 55 |
| 2 |
| 31 |
| 33 |
| None |
| None |
| None |
| 29 |
| 22 |
| None |
| None |
| None |
| 55 |
| 2 |
| 31 |
| 33 |
| None |
| None |
| None |
| 29 |
| 22 |
off_s_h_cd |
| None |
| None |
| None |
| S |
| H |
| H |
| H |
| S |
| S |
| None |
| S |
| H |
| None |
| None |
| None |
| S |
| H |
| H |
| H |
| S |
| S |
| None |
| S |
| H |
bal_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bal_num |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sup_opp_cd |
| None |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| None |
| S |
| S |
| None |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| None |
| S |
| S |
memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 500064329 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 500064329 |
| None |
| None |
bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
g_from_e_f |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
xref_match |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |