Table: expn
filing_id |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
| 2439966 |
amend_id |
| 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 |
rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
form_type |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
| F461P5 |
tran_id |
| EXP358 |
| EXP359 |
| EXP347 |
| EXP348 |
| EXP349 |
| EXP350 |
| EXP355 |
| EXP356 |
| EXP360 |
| EXP361 |
| EXP363 |
| EXP364 |
| EXP365 |
| EXP354 |
| EXP352 |
| EXP353 |
| EXP357 |
| EXP351 |
entity_cd |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
payee_naml |
| Atkins 2020 |
| Atkins 2020 |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors Issues Committee |
| California Beer & Beverage Distributors Issues Committee |
| California Beer & Beverage Distributors Issues Committee |
| ChamberPAC Small Contributor Committee |
| Fong for Assembly 2020 |
| Grove for Senate 2022 |
| Grove for Senate 2022 |
| Salas for Assembly 2020 |
payee_namf |
| Re-elect Senator |
| Re-elect Senator |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Vince |
| Shannon |
| Shannon |
| Rudy |
payee_namt |
| 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 |
payee_city |
| Encinitas |
| Encinitas |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Laguna Niguel |
| Sacramento |
| Sacramento |
| Sacramento |
payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
payee_zip4 |
| 92024 |
| 92024 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 92677 |
| 95814 |
| 95814 |
| 95814 |
expn_date |
| 2019-11-06 00:00:00 |
| 2019-11-06 00:00:00 |
| 2019-02-05 00:00:00 |
| 2019-05-06 00:00:00 |
| 2019-06-10 00:00:00 |
| 2019-06-24 00:00:00 |
| 2019-08-01 00:00:00 |
| 2019-09-04 00:00:00 |
| 2019-10-08 00:00:00 |
| 2019-11-21 00:00:00 |
| 2019-11-21 00:00:00 |
| 2019-12-04 00:00:00 |
| 2019-12-31 00:00:00 |
| 2019-04-05 00:00:00 |
| 2019-03-22 00:00:00 |
| 2019-04-29 00:00:00 |
| 2019-10-01 00:00:00 |
| 2019-03-19 00:00:00 |
amount |
| 4700 |
| 4700 |
| 762 |
| 1325 |
| 1450 |
| 905 |
| 822 |
| 902 |
| 953 |
| 681 |
| 78 |
| 236 |
| 207 |
| 100 |
| 1000 |
| 2500 |
| 2000 |
| 1500 |
cum_ytd |
| 9400 |
| 9400 |
| 7800 |
| 7800 |
| 7800 |
| 7800 |
| 7800 |
| 7800 |
| 7800 |
| 7800 |
| 521 |
| 521 |
| 521 |
| 100 |
| 1000 |
| 4500 |
| 4500 |
| 1500 |
cum_oth |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
expn_chkno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
expn_code |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
expn_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
agent_naml |
| 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 |
agent_namt |
| 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 |
cmte_id |
| 1393189 |
| 1393189 |
| 761487 |
| 761487 |
| 761487 |
| 761487 |
| 761487 |
| 761487 |
| 761487 |
| 761487 |
| 951402 |
| 951402 |
| 951402 |
| 1275328 |
| 1414494 |
| 1414696 |
| 1414696 |
| 1414982 |
tres_naml |
| 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 |
tres_namt |
| 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 |
tres_city |
| 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 |
tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_naml |
| Toni Atkins |
| Toni Atkins |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors CAF |
| California Beer & Beverage Distributors Issues Cttee |
| California Beer & Beverage Distributors Issues Cttee |
| California Beer & Beverage Distributors Issues Cttee |
| ChamberPAC Small Contributor Committee |
| Vince Fong |
| Shannon Grove |
| Shannon Grove |
| Rudy Salas |
cand_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_namt |
| 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 |
office_cd |
| SEN |
| SEN |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| None |
| ASM |
| SEN |
| SEN |
| ASM |
offic_dscr |
| None |
| None |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| General Purpose Committee |
| None |
| None |
| None |
| None |
| None |
juris_cd |
| SEN |
| SEN |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ASM |
| SEN |
| SEN |
| ASM |
juris_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
dist_no |
| 39 |
| 39 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 34 |
| 16 |
| 16 |
| 32 |
off_s_h_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bal_name |
| 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 |
bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sup_opp_cd |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
memo_code |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bakref_tid |
| 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 |
xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |