monetary_contributions
Data source: A_Contributions
64 rows where employer = 5044 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: filer_id, filer_name, report_date, report_start_date, report_end_date, election_date, last_name, first_name, city, zipcode, occupation, transaction_amt, year_to_date, report_date (date), report_start_date (date), report_end_date (date), election_date (date), transaction_date (date)
| Link | rowid | filer_id | filer_name | report_date ▲ | report_start_date | report_end_date | election_date | transaction_id | entity_type | last_name | first_name | prefix | city | state | zipcode | employer | occupation | self_employed | transaction_type | transaction_date | transaction_amt | year_to_date | transaction_description | committee_id | memo_reference_number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99011 | 99011 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2025-02-01 | 2024-10-20 | 2024-12-31 | 8595492 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2024-11-13 | 13 | 156 | |||||
| 99012 | 99012 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2025-02-01 | 2024-10-20 | 2024-12-31 | 8607005 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2024-12-13 | 13 | 156 | |||||
| 100624 | 100624 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | 8240954 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2024-10-13 | 13 | 130 | ||||
| 101959 | 101959 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2024-09-26 | 2024-07-01 | 2024-09-21 | 2024-11-05 | 7387284 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2024-07-13 | 13 | 104 | ||||
| 101960 | 101960 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2024-09-26 | 2024-07-01 | 2024-09-21 | 2024-11-05 | 7672009 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2024-08-13 | 13 | 104 | ||||
| 92573 | 92573 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2024-01-31 | 2023-10-22 | 2023-12-31 | 6287547 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2023-11-13 | 13 | 656 | |||||
| 92574 | 92574 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2024-01-31 | 2023-10-22 | 2023-12-31 | 6371925 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | 2023-12-13 | 13 | 656 | ||||||
| 93756 | 93756 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 5919576 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2023-07-13 | 13 | 630 | ||||
| 93757 | 93757 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 6015566 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2023-08-13 | 13 | 630 | ||||
| 93758 | 93758 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 6083840 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2023-09-13 | 13 | 630 | ||||
| 93759 | 93759 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 6163911 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2023-09-20 | 500 | 630 | ||||
| 93760 | 93760 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 6198681 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2023-10-13 | 13 | 630 | ||||
| 83901 | 83901 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2023-01-27 | 2022-10-23 | 2022-12-31 | 5372924 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2022-11-13 | 13 | 156 | |||||
| 83902 | 83902 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2023-01-27 | 2022-10-23 | 2022-12-31 | 5456384 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2022-12-13 | 13 | 156 | |||||
| 85246 | 85246 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2022-10-27 | 2022-09-25 | 2022-10-22 | 2022-11-08 | 5147742 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2022-10-13 | 13 | 130 | ||||
| 87965 | 87965 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2022-09-28 | 2022-07-01 | 2022-09-24 | 2022-11-08 | 4557523 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2022-07-13 | 13 | 117 | ||||
| 87966 | 87966 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2022-09-28 | 2022-07-01 | 2022-09-24 | 2022-11-08 | 4557531 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2022-08-13 | 13 | 117 | ||||
| 87967 | 87967 | 1332115 39 | Oakland Rising Committee sponsored by Center for Empowered Politics 370 | 2022-09-28 | 2022-07-01 | 2022-09-24 | 2022-11-08 | 4557539 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5044 | Communications Director | n | I | 2022-09-13 | 13 | 117 | ||||
| 73773 | 73773 | 1332115 39 | Oakland Rising Committee Sponsored by Center for Empowered Politics 340 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2213 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-07-13 | 13 | 206 | ||||||
| 73784 | 73784 | 1332115 39 | Oakland Rising Committee Sponsored by Center for Empowered Politics 340 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2224 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-08-13 | 13 | 206 | ||||||
| 73798 | 73798 | 1332115 39 | Oakland Rising Committee Sponsored by Center for Empowered Politics 340 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2235 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-09-13 | 13 | 206 | ||||||
| 73809 | 73809 | 1332115 39 | Oakland Rising Committee Sponsored by Center for Empowered Politics 340 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2246 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-10-13 | 13 | 206 | ||||||
| 73819 | 73819 | 1332115 39 | Oakland Rising Committee Sponsored by Center for Empowered Politics 340 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2256 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-11-13 | 13 | 206 | ||||||
| 73828 | 73828 | 1332115 39 | Oakland Rising Committee Sponsored by Center for Empowered Politics 340 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2265 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-12-13 | 13 | 206 | ||||||
| 74849 | 74849 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC976 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-01-13 | 13 | 128 | ||||||
| 74850 | 74850 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC989 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-02-13 | 13 | 128 | ||||||
| 74851 | 74851 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC999 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-03-13 | 13 | 128 | ||||||
| 74852 | 74852 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC1002 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-03-23 | 50 | 128 | ||||||
| 74853 | 74853 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC2065 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-04-13 | 13 | 128 | ||||||
| 74854 | 74854 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC2017 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-05-13 | 13 | 128 | ||||||
| 74855 | 74855 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC2038 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5044 | Communications Director | n | 2021-06-13 | 13 | 128 | ||||||
| 74974 | 74974 | 1427585 215 | Carroll Fife for City Council 2020 Officeholder 334 | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2020-11-03 | IDT1876 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5044 | Public Advocacy Manager | n | I | 2021-04-30 | 500 | 500 | ||||
| 61221 | 61221 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-02-01 | 2020-10-18 | 2020-12-31 | 2020-11-03 | A1011 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-12-13 | 13 | 156 | |||||
| 61222 | 61222 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2021-02-01 | 2020-10-18 | 2020-12-31 | 2020-11-03 | A960 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-11-13 | 13 | 156 | |||||
| 60215 | 60215 | 1419466 198 | Re-Elect Rebecca Kaplan for City Council 2020 249 | 2021-01-29 | 2020-09-20 | 2020-10-17 | 2020-11-03 | INC498 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-09-25 | 100 | 100 | |||||
| 60487 | 60487 | 1428755 219 | Yes on QQ, Oakland Youth Vote 276 | 2020-12-18 | 2020-10-18 | 2020-12-09 | INC161 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5044 | Policy Advocacy Manager | n | 2020-10-28 | 100 | 100 | INC161 | |||||
| 62335 | 62335 | 1428755 219 | Yes on QQ, Oakland Youth Vote 276 | 2020-12-14 | 2020-10-18 | 2020-12-09 | INC161 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5044 | Policy Advocacy Manager | n | 2020-10-28 | 100 | 100 | INC161 | |||||
| 60329 | 60329 | 1419466 198 | Re-Elect Rebecca Kaplan for City Council 2020 249 | 2020-11-02 | 2020-09-20 | 2020-10-17 | 2020-11-03 | INC498 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-09-25 | 100 | 100 | |||||
| 62660 | 62660 | 1419466 198 | Re-Elect Rebecca Kaplan for City Council 2020 249 | 2020-10-22 | 2020-09-20 | 2020-10-17 | 2020-11-03 | INC498 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-09-25 | 100 | 100 | |||||
| 63051 | 63051 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-10-22 | 2020-07-01 | 2020-10-17 | 2020-11-03 | A939 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-10-13 | 13 | 130 | |||||
| 63052 | 63052 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-10-22 | 2020-07-01 | 2020-10-17 | 2020-11-03 | A922 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-09-13 | 13 | 130 | |||||
| 63053 | 63053 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-10-22 | 2020-07-01 | 2020-10-17 | 2020-11-03 | A918 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-08-13 | 13 | 130 | |||||
| 63054 | 63054 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-10-22 | 2020-07-01 | 2020-10-17 | 2020-11-03 | A907 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2020-07-13 | 13 | 130 | |||||
| 58132 | 58132 | 1427585 215 | Carroll Fife for City Council 2020 272 | 2020-10-21 | 2020-01-01 | 2020-09-19 | 2020-11-03 | IDT1005 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5044 | Public Advocacy Manager | n | I | 2020-09-06 | 500 | 500 | ||||
| 65270 | 65270 | 1427585 215 | Carroll Fife for City Council 2020 272 | 2020-09-24 | 2020-01-01 | 2020-09-19 | 2020-11-03 | IDT1005 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5044 | Public Advocacy Manager | n | I | 2020-09-06 | 500 | 500 | ||||
| 54455 | 54455 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A867 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2019-12-13 | 13 | 117 | |||||
| 54456 | 54456 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A862 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2019-11-13 | 13 | 117 | |||||
| 54457 | 54457 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A853 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2019-10-13 | 13 | 117 | |||||
| 54458 | 54458 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A848 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2019-09-13 | 13 | 117 | |||||
| 54459 | 54459 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A842 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2019-08-13 | 13 | 117 | |||||
| 54460 | 54460 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A821 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5044 | Communications Director | n | 2019-07-13 | 13 | 117 | |||||
| 41356 | 41356 | 1405474 163 | Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 205 | 2019-01-31 | 2018-07-01 | 2018-09-22 | 2018-11-06 | Fm2u5Pwh4iTp | IND | Irons | Edie | Oakland | CA | 94609 | TransForm 5044 | Communcation Director | n | 2018-09-14 | 100 | 100 | |||||
| 43829 | 43829 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2019-01-30 | 2018-10-21 | 2018-12-31 | 2018-11-06 | A668 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2018-12-13 | 13 | 243 | |||||
| 43830 | 43830 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2019-01-30 | 2018-10-21 | 2018-12-31 | 2018-11-06 | A657 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2018-11-13 | 13 | 243 | |||||
| 45736 | 45736 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2018-10-25 | 2018-07-01 | 2018-10-20 | 2018-11-06 | A639 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2018-10-13 | 13 | 217 | |||||
| 45737 | 45737 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2018-10-25 | 2018-07-01 | 2018-10-20 | 2018-11-06 | A509 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2018-09-13 | 13 | 217 | |||||
| 45738 | 45738 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2018-10-25 | 2018-07-01 | 2018-10-20 | 2018-11-06 | A497 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2018-08-13 | 13 | 217 | |||||
| 45739 | 45739 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2018-10-25 | 2018-07-01 | 2018-10-20 | 2018-11-06 | A483 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2018-07-13 | 13 | 217 | |||||
| 41756 | 41756 | 1405474 163 | Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 205 | 2018-10-22 | 2018-07-01 | 2018-09-22 | 2018-11-06 | Fm2u5Pwh4iTp | IND | Irons | Edie | Oakland | CA | 94609 | TransForm 5044 | Communcation Director | n | 2018-09-14 | 100 | 100 | |||||
| 48361 | 48361 | 1405474 163 | Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 205 | 2018-09-27 | 2018-07-01 | 2018-09-22 | 2018-11-06 | Fm2u5Pwh4iTp | IND | Irons | Edie | Oakland | CA | 94609 | TransForm 5044 | Communcation Director | n | 2018-09-14 | 100 | 100 | |||||
| 51087 | 51087 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2018-07-30 | 2018-05-20 | 2018-06-30 | 2018-06-05 | A473 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2018-06-26 | 100 | 165 | |||||
| 51088 | 51088 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2018-07-30 | 2018-05-20 | 2018-06-30 | 2018-06-05 | A462 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2018-06-13 | 13 | 165 | |||||
| 30052 | 30052 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2017-01-28 | 2016-07-01 | 2016-10-22 | 2016-11-08 | A141 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2016-10-14 | 100 | 100 | |||||
| 32532 | 32532 | 1332115 39 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 34 | 2016-10-27 | 2016-07-01 | 2016-10-22 | 2016-11-08 | A141 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5044 | Communications Director | n | 2016-10-14 | 100 | 100 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "monetary_contributions" (
"filer_id" INTEGER,
"filer_name" INTEGER,
"report_date" TEXT,
"report_start_date" TEXT,
"report_end_date" TEXT,
"election_date" TEXT,
"transaction_id" TEXT,
"entity_type" TEXT,
"last_name" TEXT,
"first_name" TEXT,
"prefix" INTEGER,
"city" TEXT,
"state" TEXT,
"zipcode" TEXT,
"employer" INTEGER,
"occupation" TEXT,
"self_employed" TEXT,
"transaction_type" INTEGER,
"transaction_date" TEXT,
"transaction_amt" INTEGER,
"year_to_date" INTEGER,
"transaction_description" INTEGER,
"committee_id" TEXT,
"memo_reference_number" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id),
FOREIGN KEY ("employer") REFERENCES [businesses](id));
CREATE INDEX ["monetary_contributions_filer_id"] ON [monetary_contributions]("filer_id");
CREATE INDEX ["monetary_contributions_filer_name"] ON [monetary_contributions]("filer_name");
CREATE INDEX ["monetary_contributions_committee_id"] ON [monetary_contributions]("committee_id");
CREATE INDEX ["monetary_contributions_employer"] ON [monetary_contributions]("employer");