Table: s497
filing_id |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
| 2718331 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
rec_type |
| S497 |
| S497 |
| S497 |
| S497 |
| S497 |
| S497 |
| S497 |
| S497 |
| S497 |
| S497 |
| S497 |
| S497 |
form_type |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
| F497P2 |
tran_id |
| EXP1295 |
| EXP1294 |
| EXP1292 |
| EXP1293 |
| EXP1290 |
| EXP1291 |
| EXP1294 |
| EXP1292 |
| EXP1293 |
| EXP1290 |
| EXP1291 |
| EXP1302 |
entity_cd |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
enty_naml |
| Bass for LA Mayor 2022 |
| Bob Hertzberg for Supervisor 2022, Sponsored by the LA County Fed of Labor, AFL-CIO |
| Essential Workers in support of Tim McOsker for City Council 2022 |
| Karen Bass for Mayor 2022, Sponsored by the LA County Federation of Labor, AFL-CIO |
| Price, Cedillo, Good and Yaroslavsky for Council 2022, spnrd by the Los Angeles County Federation of Labor AFL-CIO |
| Support of Richardson for Mayor and Kerr, Zendejas, Uranga, Ricks-Oddie for City Cncl 2022,Spnrd by the LA CNTY Fed of Labor |
| Bob Hertzberg for Supervisor 2022, Sponsored by the LA County Fed of Labor, AFL-CIO |
| Essential Workers in support of Tim McOsker for City Council 2022 |
| Karen Bass for Mayor 2022, Sponsored by the LA County Federation of Labor, AFL-CIO |
| Price, Cedillo, Good and Yaroslavsky for Council 2022, spnrd by the Los Angeles County Federation of Labor AFL-CIO |
| Support of Richardson for Mayor and Kerr, Zendejas, Uranga, Ricks-Oddie for City Cncl 2022,Spnrd by the LA CNTY Fed of Labor |
| Bass for LA Mayor 2022 |
enty_namf |
| Communities United for |
| First Responders in support of |
| First Responders and |
| Essential Workers in support of |
| Essential Workers in Support of |
| Working Families and Communities in |
| First Responders in support of |
| First Responders and |
| Essential Workers in support of |
| Essential Workers in Support of |
| Working Families and Communities in |
| Communities United for |
enty_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
enty_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
enty_city |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
| Los Angeles |
enty_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
enty_zip4 |
| 90019 |
| 90017 |
| 90017 |
| 90017 |
| 90014 |
| 90017 |
| 90017 |
| 90017 |
| 90017 |
| 90014 |
| 90017 |
| 90019 |
ctrib_emp |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
ctrib_occ |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
ctrib_self |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
elec_date |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
ctrib_date |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-09 00:00:00 |
date_thru |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
amount |
| 450000 |
| 200000 |
| 25000 |
| 250000 |
| 25000 |
| 100000 |
| 200000 |
| 25000 |
| 250000 |
| 25000 |
| 100000 |
| 450000 |
cmte_id |
| 1445924 |
| Pending |
| Pending |
| Pending |
| 1446040 |
| 1446966 |
| Pending |
| Pending |
| Pending |
| 1446040 |
| 1446966 |
| 1445924 |
cand_naml |
| Communities United for Bass for LA Mayor 2022 |
| First Responders in support of Bob Hertzberg for Supervisor 2022, Sponsored by the LA County Federation of Labor, AFL-CIO |
| First Responders and Essential Workers in support of Tim McOsker for City Council 2022 |
| Essential Workers in support of Karen Bass for Mayor 2022, Sponsored by the LA County Federation of Labor, AFL-CIO |
| Essential Workers in Support of Price, Cedillo, Good and Yaroslavsky for Council 2022, spnrd by the Los Angeles County Federation of Labor AFL-CIO |
| Working Families and Communities in Support of Richardson for Mayor and Kerr, Zendejas, Uranga, Ricks-Oddie for City Council 2022,Spnrd by the LA County Fed of Labor, AFL-CIO |
| First Responders in support of Bob Hertzberg for Supervisor 2022, Sponsored by the LA County Federation of Labor, AFL-CIO |
| First Responders and Essential Workers in support of Tim McOsker for City Council 2022 |
| Essential Workers in support of Karen Bass for Mayor 2022, Sponsored by the LA County Federation of Labor, AFL-CIO |
| Essential Workers in Support of Price, Cedillo, Good and Yaroslavsky for Council 2022, spnrd by the Los Angeles County Federation of Labor AFL-CIO |
| Working Families and Communities in Support of Richardson for Mayor and Kerr, Zendejas, Uranga, Ricks-Oddie for City Council 2022,Spnrd by the LA County Fed of Labor, AFL-CIO |
| Communities United for Bass for LA Mayor 2022 |
cand_namf |
| 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 |
cand_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
office_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
offic_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
juris_cd |
| 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 |
dist_no |
| 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 |
bal_name |
| 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 |
bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
memo_code |
| 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 |
bal_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sup_off_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sup_opp_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |