Table: expn
filing_id |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
| 1980521 |
amend_id |
| 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 |
rec_type |
| 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 |
tran_id |
| EXP101 |
| EXP102 |
| EXP111 |
| EXP105 |
| EXP106 |
| EXP107 |
| EXP108 |
| EXP109 |
| EXP110 |
| EXP103 |
| EXP112 |
| EXP115 |
| EXP114 |
entity_cd |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
payee_naml |
| Eric Guerra for Sacramento City Council 2015 |
| Evan Low for Assembly 2016 |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| Councilmember Roberto Uranga Officeholder Account 2014 |
| Jeff Prang for County Assessor 2014 |
| Evan Low for Assembly 2016 |
| Madison Nguyen For California State Assembly 2016 |
payee_namf |
| 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 |
payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
payee_city |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Long Beach |
| Los Angeles |
| Sacramento |
| San Jose |
payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
payee_zip4 |
| 95814 |
| 95815 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 90809 |
| 90004 |
| 95815 |
| 95131 |
expn_date |
| 2015-02-02 00:00:00 |
| 2015-02-20 00:00:00 |
| 2015-03-05 00:00:00 |
| 2015-03-05 00:00:00 |
| 2015-03-05 00:00:00 |
| 2015-03-05 00:00:00 |
| 2015-03-05 00:00:00 |
| 2015-03-05 00:00:00 |
| 2015-03-05 00:00:00 |
| 2015-03-16 00:00:00 |
| 2015-03-25 00:00:00 |
| 2015-06-24 00:00:00 |
| 2015-06-24 00:00:00 |
amount |
| 250 |
| 1500 |
| 3000 |
| 3000 |
| 500 |
| 500 |
| 3000 |
| 500 |
| 3000 |
| 750 |
| 500 |
| 2500 |
| 500 |
cum_ytd |
| 250 |
| 4000 |
| 13500 |
| 13500 |
| 13500 |
| 13500 |
| 13500 |
| 13500 |
| 13500 |
| 750 |
| 500 |
| 4000 |
| 500 |
cum_oth |
| 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 |
expn_code |
| 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 |
agent_naml |
| 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 |
agent_namt |
| 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 |
cmte_id |
| 1374232 |
| 1373638 |
| 1353866 |
| 1353866 |
| 1353866 |
| 1353866 |
| 1353866 |
| 1353866 |
| 1353866 |
| 1360366 |
| 1359913 |
| 1373638 |
| 1376418 |
tres_naml |
| 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 |
tres_namt |
| 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 |
tres_city |
| 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 |
tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_naml |
| Eric Guerra |
| Evan Low |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| California Building Industry Assocation Issues Committee |
| Roberto Uranga |
| Jeff Prang |
| Evan Low |
| Madison Nguyen |
cand_namf |
| 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 |
cand_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
office_cd |
| CCM |
| ASM |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| CCM |
| ASR |
| ASM |
| 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 |
| None |
| None |
| None |
| None |
juris_cd |
| OTH |
| ASM |
| STW |
| STW |
| STW |
| STW |
| STW |
| STW |
| STW |
| OTH |
| OTH |
| ASM |
| ASM |
juris_dscr |
| City of Sacramento : 6 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| City of Long Beach : 7 |
| County of Los Angeles |
| None |
| None |
dist_no |
| None |
| 28 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 28 |
| 27 |
off_s_h_cd |
| S |
| H |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| H |
| H |
| H |
| S |
bal_name |
| 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 |
bal_juris |
| 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 |
memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
memo_refno |
| None |
| EXP102 |
| EXP111 |
| EXP105 |
| EXP106 |
| EXP107 |
| EXP108 |
| EXP109 |
| EXP110 |
| None |
| EXP112 |
| EXP115 |
| EXP114 |
bakref_tid |
| 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 |
xref_schnm |
| 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 |