monetary_contributions
Data source: A_Contributions
64 rows where employer = 5036 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98696 | 98696 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2025-02-01 | 2024-10-20 | 2024-12-31 | 8595492 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2024-11-13 | 13 | 156 | |||||
98697 | 98697 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2025-02-01 | 2024-10-20 | 2024-12-31 | 8607005 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2024-12-13 | 13 | 156 | |||||
100309 | 100309 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | 8240954 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2024-10-13 | 13 | 130 | ||||
101644 | 101644 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2024-09-26 | 2024-07-01 | 2024-09-21 | 2024-11-05 | 7387284 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2024-07-13 | 13 | 104 | ||||
101645 | 101645 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2024-09-26 | 2024-07-01 | 2024-09-21 | 2024-11-05 | 7672009 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2024-08-13 | 13 | 104 | ||||
92573 | 92573 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2024-01-31 | 2023-10-22 | 2023-12-31 | 6287547 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2023-11-13 | 13 | 656 | |||||
92574 | 92574 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2024-01-31 | 2023-10-22 | 2023-12-31 | 6371925 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | 2023-12-13 | 13 | 656 | ||||||
93756 | 93756 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 5919576 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2023-07-13 | 13 | 630 | ||||
93757 | 93757 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 6015566 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2023-08-13 | 13 | 630 | ||||
93758 | 93758 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 6083840 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2023-09-13 | 13 | 630 | ||||
93759 | 93759 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 6163911 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2023-09-20 | 500 | 630 | ||||
93760 | 93760 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2023-10-26 | 2023-07-01 | 2023-10-21 | 2023-11-07 | 6198681 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2023-10-13 | 13 | 630 | ||||
83901 | 83901 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2023-01-27 | 2022-10-23 | 2022-12-31 | 5372924 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2022-11-13 | 13 | 156 | |||||
83902 | 83902 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2023-01-27 | 2022-10-23 | 2022-12-31 | 5456384 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2022-12-13 | 13 | 156 | |||||
85246 | 85246 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2022-10-27 | 2022-09-25 | 2022-10-22 | 2022-11-08 | 5147742 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2022-10-13 | 13 | 130 | ||||
87965 | 87965 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2022-09-28 | 2022-07-01 | 2022-09-24 | 2022-11-08 | 4557523 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2022-07-13 | 13 | 117 | ||||
87966 | 87966 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2022-09-28 | 2022-07-01 | 2022-09-24 | 2022-11-08 | 4557531 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2022-08-13 | 13 | 117 | ||||
87967 | 87967 | 1332115 37 | Oakland Rising Committee sponsored by Center for Empowered Politics 357 | 2022-09-28 | 2022-07-01 | 2022-09-24 | 2022-11-08 | 4557539 | IND | Irons | Edie | Oakland | CA | 94601-4318 | TransForm 5036 | Communications Director | n | I | 2022-09-13 | 13 | 117 | ||||
73773 | 73773 | 1332115 37 | Oakland Rising Committee Sponsored by Center for Empowered Politics 333 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2213 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-07-13 | 13 | 206 | ||||||
73784 | 73784 | 1332115 37 | Oakland Rising Committee Sponsored by Center for Empowered Politics 333 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2224 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-08-13 | 13 | 206 | ||||||
73798 | 73798 | 1332115 37 | Oakland Rising Committee Sponsored by Center for Empowered Politics 333 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2235 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-09-13 | 13 | 206 | ||||||
73809 | 73809 | 1332115 37 | Oakland Rising Committee Sponsored by Center for Empowered Politics 333 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2246 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-10-13 | 13 | 206 | ||||||
73819 | 73819 | 1332115 37 | Oakland Rising Committee Sponsored by Center for Empowered Politics 333 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2256 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-11-13 | 13 | 206 | ||||||
73828 | 73828 | 1332115 37 | Oakland Rising Committee Sponsored by Center for Empowered Politics 333 | 2022-01-31 | 2021-07-01 | 2021-12-31 | INC2265 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-12-13 | 13 | 206 | ||||||
74849 | 74849 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC976 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-01-13 | 13 | 128 | ||||||
74850 | 74850 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC989 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-02-13 | 13 | 128 | ||||||
74851 | 74851 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC999 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-03-13 | 13 | 128 | ||||||
74852 | 74852 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC1002 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-03-23 | 50 | 128 | ||||||
74853 | 74853 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC2065 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-04-13 | 13 | 128 | ||||||
74854 | 74854 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC2017 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-05-13 | 13 | 128 | ||||||
74855 | 74855 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-08-02 | 2021-01-01 | 2021-06-30 | INC2038 | IND | Irons | Edie | Oakland | CA | 94601- | TransForm 5036 | Communications Director | n | 2021-06-13 | 13 | 128 | ||||||
74974 | 74974 | 1427585 213 | Carroll Fife for City Council 2020 Officeholder 347 | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2020-11-03 | IDT1876 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5036 | Public Advocacy Manager | n | I | 2021-04-30 | 500 | 500 | ||||
61221 | 61221 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-02-01 | 2020-10-18 | 2020-12-31 | 2020-11-03 | A1011 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-12-13 | 13 | 156 | |||||
61222 | 61222 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2021-02-01 | 2020-10-18 | 2020-12-31 | 2020-11-03 | A960 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-11-13 | 13 | 156 | |||||
60215 | 60215 | 1419466 206 | Re-Elect Rebecca Kaplan for City Council 2020 258 | 2021-01-29 | 2020-09-20 | 2020-10-17 | 2020-11-03 | INC498 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-09-25 | 100 | 100 | |||||
60487 | 60487 | 1428755 215 | Yes on QQ, Oakland Youth Vote 272 | 2020-12-18 | 2020-10-18 | 2020-12-09 | INC161 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5036 | Policy Advocacy Manager | n | 2020-10-28 | 100 | 100 | INC161 | |||||
62335 | 62335 | 1428755 215 | Yes on QQ, Oakland Youth Vote 272 | 2020-12-14 | 2020-10-18 | 2020-12-09 | INC161 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5036 | Policy Advocacy Manager | n | 2020-10-28 | 100 | 100 | INC161 | |||||
60329 | 60329 | 1419466 206 | Re-Elect Rebecca Kaplan for City Council 2020 258 | 2020-11-02 | 2020-09-20 | 2020-10-17 | 2020-11-03 | INC498 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-09-25 | 100 | 100 | |||||
62660 | 62660 | 1419466 206 | Re-Elect Rebecca Kaplan for City Council 2020 258 | 2020-10-22 | 2020-09-20 | 2020-10-17 | 2020-11-03 | INC498 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-09-25 | 100 | 100 | |||||
63051 | 63051 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-10-22 | 2020-07-01 | 2020-10-17 | 2020-11-03 | A939 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-10-13 | 13 | 130 | |||||
63052 | 63052 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-10-22 | 2020-07-01 | 2020-10-17 | 2020-11-03 | A922 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-09-13 | 13 | 130 | |||||
63053 | 63053 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-10-22 | 2020-07-01 | 2020-10-17 | 2020-11-03 | A918 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-08-13 | 13 | 130 | |||||
63054 | 63054 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-10-22 | 2020-07-01 | 2020-10-17 | 2020-11-03 | A907 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2020-07-13 | 13 | 130 | |||||
58132 | 58132 | 1427585 213 | Carroll Fife for City Council 2020 269 | 2020-10-21 | 2020-01-01 | 2020-09-19 | 2020-11-03 | IDT1005 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5036 | Public Advocacy Manager | n | I | 2020-09-06 | 500 | 500 | ||||
65270 | 65270 | 1427585 213 | Carroll Fife for City Council 2020 269 | 2020-09-24 | 2020-01-01 | 2020-09-19 | 2020-11-03 | IDT1005 | IND | Currier | Hayley | Berkeley | CA | 94702 | TransForm 5036 | Public Advocacy Manager | n | I | 2020-09-06 | 500 | 500 | ||||
54455 | 54455 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A867 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2019-12-13 | 13 | 117 | |||||
54456 | 54456 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A862 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2019-11-13 | 13 | 117 | |||||
54457 | 54457 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A853 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2019-10-13 | 13 | 117 | |||||
54458 | 54458 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A848 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2019-09-13 | 13 | 117 | |||||
54459 | 54459 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A842 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2019-08-13 | 13 | 117 | |||||
54460 | 54460 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2020-01-29 | 2019-07-01 | 2019-12-31 | 2020-03-03 | A821 | IND | Irons | Edie | Oakland | CA | 94601 | TransForm 5036 | Communications Director | n | 2019-07-13 | 13 | 117 | |||||
41356 | 41356 | 1405474 153 | Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 | 2019-01-31 | 2018-07-01 | 2018-09-22 | 2018-11-06 | Fm2u5Pwh4iTp | IND | Irons | Edie | Oakland | CA | 94609 | TransForm 5036 | Communcation Director | n | 2018-09-14 | 100 | 100 | |||||
43829 | 43829 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2019-01-30 | 2018-10-21 | 2018-12-31 | 2018-11-06 | A668 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2018-12-13 | 13 | 243 | |||||
43830 | 43830 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2019-01-30 | 2018-10-21 | 2018-12-31 | 2018-11-06 | A657 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2018-11-13 | 13 | 243 | |||||
45736 | 45736 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2018-10-25 | 2018-07-01 | 2018-10-20 | 2018-11-06 | A639 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2018-10-13 | 13 | 217 | |||||
45737 | 45737 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2018-10-25 | 2018-07-01 | 2018-10-20 | 2018-11-06 | A509 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2018-09-13 | 13 | 217 | |||||
45738 | 45738 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2018-10-25 | 2018-07-01 | 2018-10-20 | 2018-11-06 | A497 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2018-08-13 | 13 | 217 | |||||
45739 | 45739 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2018-10-25 | 2018-07-01 | 2018-10-20 | 2018-11-06 | A483 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2018-07-13 | 13 | 217 | |||||
41756 | 41756 | 1405474 153 | Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 | 2018-10-22 | 2018-07-01 | 2018-09-22 | 2018-11-06 | Fm2u5Pwh4iTp | IND | Irons | Edie | Oakland | CA | 94609 | TransForm 5036 | Communcation Director | n | 2018-09-14 | 100 | 100 | |||||
48361 | 48361 | 1405474 153 | Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 | 2018-09-27 | 2018-07-01 | 2018-09-22 | 2018-11-06 | Fm2u5Pwh4iTp | IND | Irons | Edie | Oakland | CA | 94609 | TransForm 5036 | Communcation Director | n | 2018-09-14 | 100 | 100 | |||||
51087 | 51087 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2018-07-30 | 2018-05-20 | 2018-06-30 | 2018-06-05 | A473 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2018-06-26 | 100 | 165 | |||||
51088 | 51088 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2018-07-30 | 2018-05-20 | 2018-06-30 | 2018-06-05 | A462 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2018-06-13 | 13 | 165 | |||||
30052 | 30052 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2017-01-28 | 2016-07-01 | 2016-10-22 | 2016-11-08 | A141 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | Communications Director | n | 2016-10-14 | 100 | 100 | |||||
32532 | 32532 | 1332115 37 | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 | 2016-10-27 | 2016-07-01 | 2016-10-22 | 2016-11-08 | A141 | IND | Irons | Edith | Oakland | CA | 94610 | TransForm 5036 | 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");