Table: expn
filing_id |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
| 2742830 |
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 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 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 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 47 |
| 48 |
| 49 |
| 50 |
| 51 |
| 52 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
| 60 |
| 61 |
| 62 |
| 63 |
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 |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| 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 |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
tran_id |
| EDT943 |
| EDT933 |
| EDT955 |
| EDT959 |
| EDT950 |
| EXP2464 |
| EDT947 |
| EDT948 |
| EDT930 |
| EDT942 |
| EDT932 |
| EDT936 |
| EDT938 |
| EDT939 |
| EDT954 |
| EDT956 |
| EXP2463 |
| EDT952 |
| EDT946 |
| EDT949 |
| EDT951 |
| EDT944 |
| EDT958 |
| EDT962 |
| EDT963 |
| EDT964 |
| EDT945 |
| EXP2459 |
| EXP2466 |
| EXP2464 |
| EXP2474 |
| EXP2478 |
| EXP2461 |
| EXP2472 |
| EXP2479 |
| EXP2483 |
| EXP2463 |
| EXP2457 |
| EXP2470 |
| EXP2476 |
| EXP2451 |
| EXP2454 |
| EXP2456 |
| EXP2458 |
| EXP2465 |
| EXP2469 |
| EXP2467 |
| EXP2480 |
| EXP2452 |
| EXP2482 |
| EXP2475 |
| EXP2453 |
| EXP2455 |
| EXP2477 |
| EDT934 |
| EDT931 |
| EDT935 |
| EDT937 |
| EDT940 |
| EDT953 |
| EDT941 |
| EDT961 |
| EDT957 |
entity_cd |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| OTH |
| OTH |
| COM |
| COM |
| IND |
| OTH |
| OTH |
| OTH |
| OTH |
| COM |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
payee_naml |
| Aisha Wahab (I) |
| Ashby (I) |
| Ashby (I) |
| Ashby (I) |
| Christy Holstege (I) |
| Climate Safe California PAC / Tides Advocacy |
| Dawn Addis (I) |
| Gregg Hart (I) |
| Jones (I) |
| Jones (I) |
| Jones (I) |
| Jones (I) |
| Jones (I) |
| Jones (I) |
| Jones (I) |
| Jones (I) |
| Jones for Senate 2022 sponsored by the Sacramento Central Labor Council |
| Josh Lowenthal (I) |
| Liz Ortega-Toro (I) |
| Pilar Schiavo (I) |
| Rick Chavez-Zbur (I) |
| Smallwood-Cuevas (I) |
| Smallwood-Cuevas (I) |
| Smallwood-Cuevas (I) |
| Smallwood-Cuevas (I) |
| Smallwood-Cuevas (I) |
| Steve Padilla (I) |
| Albion Productions |
| Albion Productions |
| Climate Safe California PAC / Tides Advocacy |
| Cops Voter Guide, Inc. |
| Gil |
| Haymarket Strategies, LLC |
| Haymarket Strategies, LLC |
| Haymarket Strategies, LLC |
| Joan of Art Campaign Design |
| Jones for Senate 2022 sponsored by the Sacramento Central Labor Council |
| Landslide Digital LLC |
| Landslide Digital LLC |
| Landslide Digital LLC |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Paschal Roth Public Affairs |
| Paschal Roth Public Affairs |
| Political Data, Inc. |
| Political Data, Inc. |
| Press Print, Inc. |
| Walker |
| Walker |
| Walker |
| U.S. Postmaster |
| U.S. Postmaster |
| U.S. Postmaster |
| U.S. Postmaster |
| U.S. Postmaster |
| U.S. Postmaster |
| Firefighters Print & Design, Inc. |
| Souza Technical Solutions |
| United States Postal Service |
payee_namf |
| None |
| Angelique |
| Angelique |
| Angelique |
| None |
| None |
| None |
| None |
| Dave |
| Dave |
| Dave |
| Dave |
| Dave |
| Dave |
| Dave |
| Dave |
| Working Families Supporting Dave |
| None |
| None |
| None |
| None |
| Lola |
| Lola |
| Lola |
| Lola |
| Lola |
| None |
| None |
| None |
| None |
| None |
| Paola |
| None |
| None |
| None |
| None |
| Working Families Supporting Dave |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Madeline |
| Madeline |
| Madeline |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| Sacramento |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Sacramento |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Los Angeles |
| Los Angeles |
| Sacramento |
| Sacramento |
| Los Angeles |
| South Pasadena |
| South Pasadena |
| South Pasadena |
| Sacramento |
| Sacramento |
| Leesburg |
| Leesburg |
| Leesburg |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Long Beach |
| Long Beach |
| Banning |
| Seal Beach |
| Seal Beach |
| Seal Beach |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Roseville |
| Banning |
payee_st |
| None |
| None |
| None |
| None |
| None |
| CA |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CA |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| VA |
| VA |
| VA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
payee_zip4 |
| None |
| None |
| None |
| None |
| None |
| 95815 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 95816 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 90027 |
| 90027 |
| 95815 |
| 95815 |
| 90039 |
| 91030 |
| 91030 |
| 91030 |
| 95816 |
| 95816 |
| 20175 |
| 20175 |
| 20175 |
| 95834 |
| 95834 |
| 95834 |
| 95834 |
| 95834 |
| 95834 |
| 95814 |
| 95814 |
| 90806 |
| 90806 |
| 92220 |
| 90740 |
| 90740 |
| 90740 |
| 95834 |
| 95834 |
| 95834 |
| 95834 |
| 95834 |
| 95834 |
| 95833- |
| 95678 |
| 92220 |
expn_date |
| 2022-10-04 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-21 00:00:00 |
amount |
| 604 |
| 31837 |
| 6871 |
| 6266 |
| 604 |
| 100000 |
| 604 |
| 604 |
| 130160 |
| 2456 |
| 31837 |
| 35567 |
| 47426 |
| 61856 |
| 28696 |
| 12419 |
| 35000 |
| 604 |
| 604 |
| 604 |
| 604 |
| 604 |
| 48382 |
| 26972 |
| 26972 |
| 27172 |
| 604 |
| 650 |
| 650 |
| 100000 |
| 12419 |
| 650 |
| 25000 |
| 20000 |
| 20000 |
| 850 |
| 35000 |
| 1350 |
| 1350 |
| 1350 |
| 61207 |
| 63024 |
| 34217 |
| 46776 |
| 61206 |
| 34217 |
| 8500 |
| 6266 |
| 3003 |
| 710 |
| 105288 |
| 950 |
| 650 |
| 650 |
| 29806 |
| 29606 |
| 17792 |
| 23500 |
| 29806 |
| 17792 |
| 1200 |
| 781 |
| 57534 |
cum_ytd |
| 58774 |
| 338458 |
| 338458 |
| 338458 |
| 604 |
| 100000 |
| 604 |
| 604 |
| 473941 |
| 473941 |
| 473941 |
| 473941 |
| 473941 |
| 473941 |
| 473941 |
| 473941 |
| 35000 |
| 604 |
| 604 |
| 604 |
| 604 |
| 130102 |
| 130102 |
| 130102 |
| 130102 |
| 130102 |
| 604 |
| 1300 |
| 1300 |
| 100000 |
| 21632 |
| 650 |
| 220000 |
| 220000 |
| 220000 |
| 3250 |
| 35000 |
| 6750 |
| 6750 |
| 6750 |
| 524887 |
| 524887 |
| 524887 |
| 524887 |
| 524887 |
| 524887 |
| 14766 |
| 14766 |
| 13404 |
| 13404 |
| 105288 |
| 11500 |
| 11500 |
| 11500 |
| 261249 |
| 261249 |
| 261249 |
| 261249 |
| 261249 |
| 261249 |
| 1200 |
| 781 |
| 57534 |
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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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_code |
| IND |
| IND |
| IND |
| IND |
| IND |
| MON |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| MON |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| CTB |
| IND |
| IND |
| None |
| None |
| IND |
| IND |
| CTB |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
expn_dscr |
| Website |
| Mailer |
| Mailer |
| Media Event |
| Website |
| None |
| Website |
| Website |
| Mailer |
| Website |
| Mailer |
| Mailer |
| Mailer |
| Mailer |
| Mailer |
| Slate Mail |
| None |
| Website |
| Website |
| Website |
| Website |
| Website |
| Mailer |
| Mailer |
| Mailer |
| Mailer |
| Website |
| Design for Mailer/Support/Dave Jones |
| Design for Mailer/Support/Dave Jones |
| None |
| Slate Mail/Support/Dave Jones |
| Design for Mailer/Support/Lola Smallwood-Cuevas |
| CNS/IND/Consulting for Mailers/Support/Dave Jones/Oppose/Angelique Ashby |
| CNS/IND/Consulting for Mailers/Support/Dave Jones/Oppose/Angelique Ashby |
| Consulting for Mailers/Support/Lola Smallwood-Cuevas |
| Design for Mailer/Support/Lola Smallwood-Cuevas |
| None |
| Design for Mailer/Support/Dave Jones |
| Design for Mailer/Support/Dave Jones/Oppose/Angelique Ashby |
| Design for Mailer/Support/Lola Smallwood-Cuevas |
| Mailer/Support/Dave Jones |
| Mailer/Support/Dave Jones/Oppose/Angelique Ashby |
| Mailer/Support/Dave Jones |
| Mailer/Support/Dave Jones |
| Mailer/Support/Dave Jones |
| Mailer/Support/Dave Jones/Oppose/Angelique Ashby |
| Website/Support/Various Candidates |
| Media Event/Oppose/Angelique Ashby |
| Data for Mailers/Support/Dave Jones |
| Data for Mailers/Support/Lola Smallwood-Cuevas |
| Mailers/Support/Lola Smallwood-Cuevas |
| Design for Mailer/Support/Dave Jones |
| Design for Mailer/Support/Dave Jones/Oppose/Angelique Ashby |
| Design for Mailer/Support/Lola Smallwood-Cuevas |
| Postage for Mailer |
| Postage for Mailer |
| Postage for Mailer |
| Postage for Mailer |
| Postage for Mailer |
| Postage for Mailer |
| Design for Website |
| Audio and Technical Equipment for Media Event |
| Postage for Mailers |
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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Mailrite Print and Mail, Inc. |
| Paschal Roth Public Affairs |
| Paschal Roth Public Affairs |
| Press Print, Inc. |
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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 1443088 |
| 599014 |
| None |
| None |
| None |
| None |
| None |
| 1454977 |
| None |
| None |
| 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_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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| Aisha Wahab |
| Angelique Ashby |
| Angelique Ashby |
| Angelique Ashby |
| Christy Holstege |
| Climate Safe California PAC / Tides Advocacy |
| Dawn Addis |
| Gregg Hart |
| Dave Jones |
| Dave Jones |
| Dave Jones |
| Dave Jones |
| Dave Jones |
| Dave Jones |
| Dave Jones |
| Dave Jones |
| Working Families Supporting Dave Jones for Senate 2022 sponsored by the Sacramento Central Labor Council |
| Josh Lowenthal |
| Liz Ortega-Toro |
| Pilar Schiavo |
| Rick Chavez-Zbur |
| Lola Smallwood-Cuevas |
| Lola Smallwood-Cuevas |
| Lola Smallwood-Cuevas |
| Lola Smallwood-Cuevas |
| Lola Smallwood-Cuevas |
| Steve Padilla |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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_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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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_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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| SEN |
| SEN |
| SEN |
| SEN |
| ASM |
| None |
| ASM |
| ASM |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| None |
| ASM |
| ASM |
| ASM |
| ASM |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| SEN |
| SEN |
| SEN |
| SEN |
| ASM |
| None |
| ASM |
| ASM |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| None |
| ASM |
| ASM |
| ASM |
| ASM |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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_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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 10 |
| 8 |
| 8 |
| 8 |
| 47 |
| None |
| 30 |
| 37 |
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
| 8 |
| None |
| 69 |
| 20 |
| 40 |
| 51 |
| 28 |
| 28 |
| 28 |
| 28 |
| 28 |
| 18 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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_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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| S |
| O |
| O |
| O |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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_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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |