monetary_contributions
Data source: A_Contributions
25 rows where filer_id = 128 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, last_name, first_name, city, state, zipcode, employer, occupation, transaction_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52368 | 52368 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | pDxZWoXRxlV4 | IND | Byrd | Candace | Atlanta | GA | 30331 | City of Atlanta 5120 | Chief of Staff | n | 2016-09-30 | 150 | 0 | |||||
| 52369 | 52369 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | CfEdvSOslMqr | IND | Stanley | Anthony | Miami | FL | 33142 | Baptist Hospital 5121 | Doctor | n | 2016-10-05 | 200 | 0 | |||||
| 52370 | 52370 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | gwFfZIsYvobg | IND | Akhidenor | Christopher | Oakland | CA | 94621 | Self employed 1097 | CPA | n | 2016-10-14 | 300 | 0 | |||||
| 52371 | 52371 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | yafsbD9ikg2R | IND | Brower | Marion | Oakland | CA | 94609 | Unknown 784 | contractor | n | 2016-10-14 | 100 | 0 | |||||
| 52372 | 52372 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | jXV6zK9gCQS3 | IND | Dean | Barbara | Oakland | CA | 94605 | retired 410 | Psychologist | n | 2016-10-14 | 100 | 0 | |||||
| 52373 | 52373 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | oN5wqkqbhnsl | OTH | GAO Associates/ Bini Associates | Alameda | CA | 94502 | n | 2016-10-14 | 500 | 0 | ||||||||
| 52374 | 52374 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | LxBBC9FYxKEM | IND | Hodge | Cleo | Oakland | CA | 94618 | Retired 122 | Social Worker | n | 2016-10-14 | 100 | 0 | |||||
| 52375 | 52375 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | vrFmGksiiHC1 | IND | Hodge | Yvonne | Oakland | CA | 94605 | Retired 122 | Teacher | n | 2016-10-14 | 500 | 0 | |||||
| 52376 | 52376 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | VhEHcqXaibXT | IND | Ikharo | Sadiq | San Ramon | CA | 94582 | Peralta Community College 3645 | Vice Chancellor of General Services | n | 2016-10-14 | 500 | 0 | |||||
| 52377 | 52377 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | Pl6zhCOoXAti | IND | Oiyemhonlan | Raymond | Antioch | CA | 94531 | Unknown 784 | Operation Manager | n | 2016-10-14 | 200 | 0 | |||||
| 52378 | 52378 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | MsEwf9YcZVjB | IND | Okundaye | Osarenkhoe | Oakland | CA | 94601 | Unknown 784 | restaurant owner | n | 2016-10-14 | 150 | 0 | |||||
| 52379 | 52379 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-06-27 | 2016-08-16 | 2018-01-01 | 2016-11-08 | xzcxfsb64y2O | OTH | The Herbert Enterprise Group LLC | Oakland | CA | 94621 | n | 2016-10-14 | 700 | 0 | ||||||||
| 37335 | 37335 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2018-01-31 | 2017-07-01 | 2017-12-31 | 2016-11-08 | Yt8yTlMBVp2j | IND | Hodge | Marcie | Oakland | CA | 94605 | St. John Boys Home, Inc. 5892 | Administrator | n | 2017-08-04 | 50 | 110 | |||||
| 30472 | 30472 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | pDxZWoXRxlV4 | IND | Byrd | Candace | Atlanta | GA | 30331 | City of Atlanta 5120 | Chief of Staff | n | 2016-09-30 | 150 | 150 | |||||
| 30473 | 30473 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | CfEdvSOslMqr | IND | Stanley | Anthony | Miami | FL | 33142 | Baptist Hospital 5121 | Doctor | n | 2016-10-05 | 200 | 200 | |||||
| 30474 | 30474 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | gwFfZIsYvobg | IND | Akhidenor | Christopher | Oakland | CA | 94621 | Self employed 1097 | CPA | n | 2016-10-14 | 300 | 300 | |||||
| 30475 | 30475 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | yafsbD9ikg2R | IND | Brower | Marion | Oakland | CA | 94609 | Unknown 784 | contractor | n | 2016-10-14 | 100 | 100 | |||||
| 30476 | 30476 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | jXV6zK9gCQS3 | IND | Dean | Barbara | Oakland | CA | 94605 | retired 410 | Psychologist | n | 2016-10-14 | 100 | 100 | |||||
| 30477 | 30477 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | oN5wqkqbhnsl | OTH | GAO Associates/ Bini Associates | Alameda | CA | 94502 | n | 2016-10-14 | 500 | 500 | ||||||||
| 30478 | 30478 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | LxBBC9FYxKEM | IND | Hodge | Cleo | Oakland | CA | 94618 | Retired 122 | Social Worker | n | 2016-10-14 | 100 | 100 | |||||
| 30479 | 30479 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | vrFmGksiiHC1 | IND | Hodge | Yvonne | Oakland | CA | 94605 | Retired 122 | Teacher | n | 2016-10-14 | 500 | 500 | |||||
| 30480 | 30480 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | VhEHcqXaibXT | IND | Ikharo | Sadiq | San Ramon | CA | 94582 | Peralta Community College 3645 | Vice Chancellor of General Services | n | 2016-10-14 | 500 | 500 | |||||
| 30481 | 30481 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | Pl6zhCOoXAti | IND | Oiyemhonlan | Raymond | Antioch | CA | 94531 | Unknown 784 | Operation Manager | n | 2016-10-14 | 200 | 200 | |||||
| 30482 | 30482 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | MsEwf9YcZVjB | IND | Okundaye | Osarenkhoe | Oakland | CA | 94601 | Unknown 784 | restaurant owner | n | 2016-10-14 | 150 | 150 | |||||
| 30483 | 30483 | 1388731 128 | Hodge 4 Oakland City Council 2016 148 | 2017-09-14 | 2016-09-25 | 2016-10-22 | 2016-11-06 | xzcxfsb64y2O | OTH | The Herbert Enterprise Group LLC | Oakland | CA | 94621 | n | 2016-10-14 | 700 | 700 |
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");