Table: expn
filing_id |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
| 2742200 |
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 |
| 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 |
| 64 |
| 65 |
| 66 |
| 67 |
| 68 |
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 |
| 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 |
| 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 |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
tran_id |
| PDT3335 |
| PDT3333 |
| PDT3334 |
| PDT3336 |
| EDT1068 |
| EDT1069 |
| EDT1070 |
| PDT3337 |
| PDT3339 |
| PDT3340 |
| PDT3342 |
| EDT1072 |
| EDT1073 |
| EDT1075 |
| PDT3346 |
| PDT3348 |
| EDT1071 |
| PDT3351 |
| EDT1076 |
| EDT1077 |
| EDT1084 |
| EDT1085 |
| PDT3354 |
| EXP6880 |
| EXP6882 |
| EXP6947 |
| EXP6886 |
| EXP6888 |
| EXP6890 |
| EXP6896 |
| EXP6899 |
| EXP6898 |
| EXP6907 |
| EXP6923 |
| EXP6909 |
| EXP6911 |
| EXP6915 |
| EXP6917 |
| EXP6919 |
| EXP6921 |
| EXP6927 |
| EXP6925 |
| EXP6924 |
| EXP6931 |
| EXP6933 |
| EXP6940 |
| EXP6941 |
| PDT3343 |
| PDT3345 |
| PDT3356 |
| PDT3358 |
| PDT3359 |
| PDT3360 |
| PDT3364 |
| PDT3362 |
| PDT3363 |
| PDT3365 |
| PDT3361 |
| EDT1086 |
| PDT3350 |
| PDT3349 |
| EDT1074 |
| EDT1080 |
| EDT1081 |
| EDT1078 |
| EDT1082 |
| EDT1079 |
| EDT1083 |
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 |
| 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 |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
payee_naml |
| Marie Alvarado-Gill G2022 |
| Shawn Kumagai G2022 |
| Shawn Kumagai G2022 |
| Marie Alvarado-Gill G2022 |
| Brian Jones - G2022 |
| Brian Jones - G2022 |
| Esmeralda Soria - G2022 |
| Esmeralda Soria - G2022 |
| Marie Alvarado-Gill G2022 |
| Shawn Kumagai G2022 |
| Shawn Kumagai G2022 |
| Brian Jones - G2022 |
| Brian Jones - G2022 |
| Lily Mei - G2022 |
| Lily Mei - G2022 |
| Lily Mei - G2022 |
| Marie Alvarado-Gill G2022 |
| Lily Mei - G2022 |
| Lily Mei - G2022 |
| Lily Mei - G2022 |
| Marie Alvarado-Gill G2022 |
| Marie Alvarado-Gill G2022 |
| Marie Alvarado-Gill G2022 |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| JPM&M, Inc. |
| Burkewood Communications Corp. |
| Push Media Inc. dba Gleeson Digital Strategies |
| Behr Communications, Inc. |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| Street Level Campaigns, LLC |
| 38 77 Media, LLC |
| Nygren & Company |
| The Monaco Group |
| MB Public Affairs, Inc. |
| Push Media Inc. dba Gleeson Digital Strategies |
| West Coast Public Affairs, Inc. |
| West Coast Public Affairs, Inc. |
| Arlene Thornton & Associates |
| Left Hook |
| Direct Edge |
| Insource Print and Design |
| Political Data Inc. |
| United States Postal Service |
| Advanced Image Direct |
| Dome Printing |
| Insource Print and Design |
| Political Data Inc. |
| United States Postal Service |
| Basis Global Technologies, Inc. |
| Diaz Vaughn & Co. |
| Sierra Pacific Lithographics, Inc. |
| United States Postal Service |
| Political Data Inc. |
| Political Data Inc. |
| Red Printing & Mail |
| Red Printing & Mail |
| United States Postal Service |
| United States Postal Service |
payee_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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
payee_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sacramento |
| Princeton |
| Sacramento |
| Santa Monica |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sierra Madre |
| Sheridan |
| Folsom |
| Santa Ana |
| Sacramento |
| Sacramento |
| Woodland Hills |
| Woodland Hills |
| Studio City |
| None |
| Anaheim |
| Sacramento |
| Norwalk |
| West Sacramento |
| Fullerton |
| McClellan Park |
| Sacramento |
| Norwalk |
| West Sacramento |
| Chicago |
| Sacramento |
| Sacramento |
| Santa Ana |
| Norwalk |
| Norwalk |
| Simi Valley |
| Simi Valley |
| Fremont |
| Fremont |
payee_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| NJ |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| NY |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| None |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| IL |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
payee_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 91024 |
| 91024 |
| 91024 |
| 91024 |
| 91024 |
| 91024 |
| 95814 |
| 08540 |
| 95818 |
| 90401 |
| 91024 |
| 91024 |
| 91024 |
| 91024 |
| 91024 |
| 91024 |
| 91024 |
| 82801 |
| 95630 |
| 92705 |
| 95814 |
| 95818 |
| 91364 |
| 91364 |
| 91604 |
| None |
| 92807 |
| 95811 |
| 90650 |
| 95799 |
| 92831 |
| 95652 |
| 95811 |
| 90650 |
| 95799 |
| 60656 |
| 95819 |
| 95815 |
| 92703 |
| 90650 |
| 90650 |
| 93063 |
| 93063 |
| 94538 |
| 94538 |
expn_date |
| 2022-09-30 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-20 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-09-27 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-28 00:00:00 |
| 2022-09-28 00:00:00 |
| 2022-09-28 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-08 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-21 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
amount |
| 39000 |
| 3075 |
| 25000 |
| 52086 |
| 18000 |
| 7800 |
| 5998 |
| 140730 |
| 39000 |
| 25000 |
| 3148 |
| 22457 |
| 1414 |
| 155000 |
| 1250 |
| 15000 |
| 15000 |
| 50000 |
| 71268 |
| 30963 |
| 12360 |
| 33831 |
| 63368 |
| 10000 |
| 33000 |
| 32000 |
| 10000 |
| 26000 |
| 14000 |
| 52086 |
| 7800 |
| 18000 |
| 140730 |
| 15000 |
| 11000 |
| 25000 |
| 14000 |
| 7000 |
| 39000 |
| 39000 |
| 155000 |
| 1414 |
| 22457 |
| 1250 |
| 3148 |
| 71268 |
| 30963 |
| 550 |
| 139980 |
| 15938 |
| 1250 |
| 1225 |
| 27023 |
| 4244 |
| 16238 |
| 1500 |
| 1303 |
| 28194 |
| 15300 |
| 750 |
| 1926 |
| 11031 |
| 2580 |
| 1118 |
| 26400 |
| 11530 |
| 37313 |
| 16155 |
cum_ytd |
| 478408 |
| 124473 |
| 124473 |
| 478408 |
| 49671 |
| 49671 |
| 146728 |
| 146728 |
| 478408 |
| 124473 |
| 124473 |
| 49671 |
| 49671 |
| 323481 |
| 323481 |
| 323481 |
| 478408 |
| 323481 |
| 323481 |
| 323481 |
| 478408 |
| 478408 |
| 478408 |
| 693876 |
| 693876 |
| 693876 |
| 693876 |
| 693876 |
| 693876 |
| 115455 |
| 7800 |
| 21148 |
| 140730 |
| 693876 |
| 693876 |
| 693876 |
| 693876 |
| 693876 |
| 693876 |
| 693876 |
| 155000 |
| 1414 |
| 22457 |
| 4750 |
| 21148 |
| 102231 |
| 102231 |
| 550 |
| 139980 |
| 15938 |
| 2750 |
| 48095 |
| 55217 |
| 4244 |
| 16238 |
| 2750 |
| 48095 |
| 55217 |
| 15300 |
| 1750 |
| 8101 |
| 11031 |
| 48095 |
| 48095 |
| 37930 |
| 37930 |
| 53468 |
| 53468 |
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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
expn_code |
| 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 |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| RAD |
| RAD |
| LIT |
| LIT |
| LIT |
| POS |
| LIT |
| LIT |
| LIT |
| LIT |
| POS |
| WEB |
| CMP |
| CMP |
| POS |
| LIT |
| LIT |
| LIT |
| LIT |
| POS |
| POS |
expn_dscr |
| CNS, PHO, SAL |
| POL |
| CNS, PHO, SAL |
| LIT, POS |
| WEB |
| WEB |
| POL |
| RAD |
| CNS, PHO, SAL |
| CNS, PHO, SAL |
| CMP |
| LIT, POS |
| LIT |
| WEB |
| POL |
| WEB |
| CNS, PHO, SAL |
| CNS, PHO, SAL |
| LIT, POS |
| LIT, POS |
| POL |
| POL |
| LIT, POS |
| PHO; Support; Marie Alvarado-Gil; SD04 |
| CNS, PHO, SAL; Support; Marie Alvarado-Gil; SD04 |
| CNS, PHO, SAL; Support; Marie Alvarado-Gil; SD04 |
| PHO; Support; Shawn Kumagai; AD20 |
| CNS, PHO, SAL; Support; Shawn Kumagai; AD20 |
| CNS, PHO, SAL; Support; Shawn Kumagai; AD20 |
| LIT, POS; Support; Marie Alvarado-Gil; SD04 |
| WEB; Support; Brian Jones; SD40 |
| WEB; Support; Brian Jones; SD40 |
| RAD; Support; Esmeralda Soria; AD27 |
| CNS, PHO, SAL; Support; Marie Alvarado-Gil; SD04 |
| CNS, PHO, SAL; Support; Shawn Kumagai; AD20 |
| CNS, PHO, SAL; Support; Shawn Kumagai; AD20 |
| CNS, PHO, SAL; Support; Shawn Kumagai; AD20 |
| CNS, PHO, SAL; Support; Marie Alvarado-Gil; SD04 |
| CNS, PHO, SAL; Support; Marie Alvarado-Gil; SD04 |
| CNS, PHO, SAL; Support; Marie Alvarado-Gil; SD04 |
| WEB; Support; Lily Mei; SD10 |
| LIT; Support; Brian Jones; SD40 |
| LIT, POS; Support; Brian Jones; SD40 |
| POL; Support; Lily Mei; SD10 |
| CMP; Support; Shawn Kumagai; AD20 |
| LIT, POS; Support; Lily Mei; SD10 |
| LIT, POS; Support; Lily Mei; SD10 |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Behr Communications, Inc. |
| Behr Communications, Inc. |
| JPM&M, Inc. |
| JPM&M, Inc. |
| JPM&M, Inc. |
| JPM&M, Inc. |
| JPM&M, Inc. |
| JPM&M, Inc. |
| JPM&M, Inc. |
| JPM&M, Inc. |
| JPM&M, Inc. |
| Push Media Inc. dba Gleeson Digital Strategies |
| Push Media Inc. dba Gleeson Digital Strategies |
| Push Media Inc. dba Gleeson Digital Strategies |
| The Monaco Group |
| West Coast Public Affairs, Inc. |
| West Coast Public Affairs, Inc. |
| West Coast Public Affairs, Inc. |
| West Coast Public Affairs, Inc. |
| West Coast Public Affairs, Inc. |
| West Coast Public Affairs, 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 |
| 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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
cand_naml |
| Marie Alvarado-Gil |
| Shawn Kumagai |
| Shawn Kumagai |
| Marie Alvarado-Gil |
| Brian Jones |
| Brian Jones |
| Esmeralda Soria |
| Esmeralda Soria |
| Marie Alvarado-Gil |
| Shawn Kumagai |
| Shawn Kumagai |
| Brian Jones |
| Brian Jones |
| Lily Mei |
| Lily Mei |
| Lily Mei |
| Marie Alvarado-Gil |
| Lily Mei |
| Lily Mei |
| Lily Mei |
| Marie Alvarado-Gil |
| Marie Alvarado-Gil |
| Marie Alvarado-Gil |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
office_cd |
| SEN |
| ASM |
| ASM |
| SEN |
| SEN |
| SEN |
| ASM |
| ASM |
| SEN |
| ASM |
| ASM |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
juris_cd |
| SEN |
| ASM |
| ASM |
| SEN |
| SEN |
| SEN |
| ASM |
| ASM |
| SEN |
| ASM |
| ASM |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| SEN |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
dist_no |
| 04 |
| 20 |
| 20 |
| 04 |
| 40 |
| 40 |
| 27 |
| 27 |
| 04 |
| 20 |
| 20 |
| 40 |
| 40 |
| 10 |
| 10 |
| 10 |
| 04 |
| 10 |
| 10 |
| 10 |
| 04 |
| 04 |
| 04 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| E |
| E |
| E |
| E |
| E |
| E |
| F |
| F |
| F |
| F |
| F |
| E |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |