ie_contributions
Data source: F496P3_Contributions
46 rows where employer = 4933 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, transaction_id, transaction_date, year_to_date, report_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
270 | 270 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-09 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
276 | 276 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-09 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
282 | 282 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-09 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
288 | 288 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-09 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
258 | 258 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-08 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
264 | 264 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-08 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
294 | 294 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-08 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
300 | 300 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-08 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
306 | 306 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-08 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
312 | 312 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-07 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
318 | 318 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-04 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
324 | 324 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-04 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
330 | 330 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-04 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
336 | 336 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-04 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
368 | 368 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-01 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
374 | 374 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-01 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
380 | 380 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-01 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
386 | 386 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-11-01 | INC2883 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-10-23 | 10 | 100 | ||||||||
499 | 499 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-28 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 90 | ||||||||
619 | 619 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-28 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 90 | ||||||||
651 | 651 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-28 | INC2815 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-09-23 | 10 | 90 | ||||||||
687 | 687 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-28 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 90 | ||||||||
807 | 807 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-28 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 90 | ||||||||
839 | 839 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-28 | INC2815 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-09-23 | 10 | 90 | ||||||||
863 | 863 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-20 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
926 | 926 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-20 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
976 | 976 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-20 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1039 | 1039 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-20 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1089 | 1089 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-16 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1152 | 1152 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-16 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1186 | 1186 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-16 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1249 | 1249 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-16 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1283 | 1283 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-16 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1346 | 1346 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-16 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1380 | 1380 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-16 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1443 | 1443 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-16 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1477 | 1477 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-09 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1540 | 1540 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-09 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1571 | 1571 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-01 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1634 | 1634 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-01 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1659 | 1659 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-01 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1722 | 1722 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-01 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1747 | 1747 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-01 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1810 | 1810 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-09-01 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 | ||||||||
1835 | 1835 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-08-26 | INC2628 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-07-23 | 10 | 80 | ||||||||
1898 | 1898 | 1331137 36 | FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 | 2016-08-26 | INC2691 | IND | STEWART | JONATHON | OAKLAND | CA | 94619 | EDUCATION FOR CHANGE PUBLIC SCHOOLS 4933 | DIRECTOR OF DATA; SYSTEMS; AND ANALYSIS | n | 2016-08-23 | 10 | 80 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ie_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" TEXT, "city" TEXT, "state" TEXT, "zipcode" TEXT, "employer" INTEGER, "occupation" TEXT, "self_employed" TEXT, "transaction_type" TEXT, "transaction_date" TEXT, "transaction_amt" NUMERIC, "year_to_date" NUMERIC, "transaction_description" TEXT, "committee_id" TEXT, "memo_reference_number" TEXT , 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 ["ie_contributions_filer_id"] ON [ie_contributions]("filer_id"); CREATE INDEX ["ie_contributions_filer_name"] ON [ie_contributions]("filer_name"); CREATE INDEX ["ie_contributions_committee_id"] ON [ie_contributions]("committee_id"); CREATE INDEX ["ie_contributions_employer"] ON [ie_contributions]("employer");