Table: expn
filing_id |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
| 2060974 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
line_item |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 3 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 13 |
| 14 |
| 15 |
| 16 |
| 1 |
| 2 |
| 4 |
| 12 |
rec_type |
| EXPN |
| EXPN |
| EXPN |
| 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 |
| F461P5 |
| F461P5 |
| F461P5 |
tran_id |
| NON215 |
| NON214 |
| EDT12 |
| NON190 |
| NON204 |
| NON211 |
| NON185 |
| NON199 |
| NON198 |
| NON212 |
| NON186 |
| NON200 |
| NON187 |
| NON188 |
| NON202 |
| NON189 |
| NON203 |
| EXP183 |
| NON197 |
| EDT11 |
| NON201 |
entity_cd |
| COM |
| COM |
| OTH |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| OTH |
| COM |
payee_naml |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| Amazon.com |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| Save Lives California, a coalition of Doctors, Dentists, Health Plans, Labor, and Non-profit Health Advocate Organizations |
| California Dental Association Independent Expenditure PAC |
| Urban Art Lithography, Inc. |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
payee_namf |
| 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 |
payee_nams |
| 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 |
| Seattle |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
payee_st |
| CA |
| CA |
| WA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
payee_zip4 |
| 95814 |
| 95814 |
| 98109 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95816 |
| 95814 |
expn_date |
| 2016-06-01 00:00:00 |
| 2016-06-01 00:00:00 |
| 2016-06-02 00:00:00 |
| 2016-06-30 00:00:00 |
| 2016-06-30 00:00:00 |
| 2016-01-27 00:00:00 |
| 2016-01-31 00:00:00 |
| 2016-01-31 00:00:00 |
| 2016-02-17 00:00:00 |
| 2016-02-17 00:00:00 |
| 2016-02-29 00:00:00 |
| 2016-02-29 00:00:00 |
| 2016-03-31 00:00:00 |
| 2016-04-30 00:00:00 |
| 2016-04-30 00:00:00 |
| 2016-05-31 00:00:00 |
| 2016-05-31 00:00:00 |
| 2016-01-04 00:00:00 |
| 2016-01-27 00:00:00 |
| 2016-01-29 00:00:00 |
| 2016-03-31 00:00:00 |
amount |
| 1020 |
| 1848 |
| 1300 |
| 3704 |
| 3704 |
| 2030 |
| 3704 |
| 3704 |
| 1020 |
| 2550 |
| 3704 |
| 3704 |
| 3704 |
| 3704 |
| 3704 |
| 3704 |
| 3704 |
| 1000000 |
| 1520 |
| 418 |
| 3704 |
cum_ytd |
| 25787 |
| 28654 |
| 1001718 |
| 25787 |
| 28654 |
| 28654 |
| 25787 |
| 28654 |
| 25787 |
| 28654 |
| 25787 |
| 28654 |
| 25787 |
| 25787 |
| 28654 |
| 25787 |
| 28654 |
| 1001718 |
| 25787 |
| 1001718 |
| 28654 |
cum_oth |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
expn_code |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| IKD |
| MON |
| IKD |
| IKD |
| IKD |
expn_dscr |
| None |
| None |
| In-kind contribution for signature gathering; Save Lives CA, ID #1377991 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| In-kind contribution for convention card; Save Lives CA |
| None |
agent_naml |
| 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 |
agent_namt |
| 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 |
cmte_id |
| 1233321 |
| 742855 |
| None |
| 1233321 |
| 742855 |
| 742855 |
| 1233321 |
| 742855 |
| 1233321 |
| 742855 |
| 1233321 |
| 742855 |
| 1233321 |
| 1233321 |
| 742855 |
| 1233321 |
| 742855 |
| 1377991 |
| 1233321 |
| None |
| 742855 |
tres_naml |
| 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 |
tres_namt |
| 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 |
tres_city |
| 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 |
tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_naml |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| None |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| California Dental Association Independent Expenditure PAC |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
| None |
| California Dental Association Independent Expenditure PAC |
| None |
| California Dental Political Action Committee - Small Contributor (CalDPAC) |
cand_namf |
| None |
| None |
| None |
| 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 |
| 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 |
office_cd |
| OTH |
| OTH |
| None |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| None |
| OTH |
| None |
| OTH |
offic_dscr |
| State General Purpose IE Committee |
| State General Purpose committee |
| None |
| State General Purpose IE Committee |
| State General Purpose committee |
| State General Purpose committee |
| State General Purpose IE Committee |
| State General Purpose committee |
| State General Purpose IE Committee |
| State General Purpose committee |
| State General Purpose IE Committee |
| State General Purpose committee |
| State General Purpose IE Committee |
| State General Purpose IE Committee |
| State General Purpose committee |
| State General Purpose IE Committee |
| State General Purpose committee |
| None |
| State General Purpose IE Committee |
| None |
| State General Purpose committee |
juris_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
juris_dscr |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
off_s_h_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bal_name |
| None |
| None |
| AG 15-0029; AG 15-0030 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| AG 15-0029; AG 15-0030 |
| None |
| AG 15-0029; AG 15-0030 |
| None |
bal_num |
| 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 |
| Statewide |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Statewide |
| None |
| Statewide |
| None |
sup_opp_cd |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
memo_code |
| X |
| X |
| None |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| X |
| None |
| X |
| None |
| X |
memo_refno |
| NON215 |
| NON214 |
| None |
| NON190 |
| NON204 |
| NON211 |
| NON185 |
| NON199 |
| NON198 |
| NON212 |
| NON186 |
| NON200 |
| NON187 |
| NON188 |
| NON202 |
| NON189 |
| NON203 |
| None |
| NON197 |
| None |
| NON201 |
bakref_tid |
| 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 |
xref_schnm |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |