monetary_contributions
Data source: A_Contributions
10 rows where employer = 7643 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45043 | 45043 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-12-14 | 2018-10-21 | 2018-12-13 | 2018-11-06 | INC970 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-10-29 | 50 | 350 | INC970 | ||||
45044 | 45044 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-12-14 | 2018-10-21 | 2018-12-13 | 2018-11-06 | INC991 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-10-30 | 25 | 350 | INC991 | ||||
45528 | 45528 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-10-24 | 2018-09-23 | 2018-10-20 | 2018-11-06 | INC824 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-09-29 | 50 | 275 | INC824 | ||||
45529 | 45529 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-10-24 | 2018-09-23 | 2018-10-20 | 2018-11-06 | INC826 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-09-30 | 25 | 275 | INC826 | ||||
47017 | 47017 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-09-26 | 2018-07-01 | 2018-09-22 | 2018-11-06 | INC624 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-07-30 | 25 | 200 | INC624 | ||||
47018 | 47018 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-09-26 | 2018-07-01 | 2018-09-22 | 2018-11-06 | INC709 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-08-29 | 50 | 200 | INC709 | ||||
47019 | 47019 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-09-26 | 2018-07-01 | 2018-09-22 | 2018-11-06 | INC713 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-08-30 | 25 | 200 | INC713 | ||||
49070 | 49070 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-07-30 | 2018-01-01 | 2018-06-30 | 2018-11-06 | INC168 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-05-30 | 25 | 100 | INC168 | ||||
49071 | 49071 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-07-30 | 2018-01-01 | 2018-06-30 | 2018-11-06 | INC391 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-06-28 | 50 | 100 | INC391 | ||||
49072 | 49072 | 1403124 184 | Natasha Middleton for Oakland City Council 2018 234 | 2018-07-30 | 2018-01-01 | 2018-06-30 | 2018-11-06 | INC337 | IND | Carter | Sean | Emeryville | CA | 94608 | The Carter Law Group 7643 | Lawyer | n | 2018-06-30 | 25 | 100 | INC337 |
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");