monetary_contributions
Data source: A_Contributions
19 rows where employer = 101 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, transaction_id, last_name, first_name, zipcode, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84035 | 84035 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | HUaTqa6IGcvy | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-11-09 | 35 | 385 | |||||
| 85731 | 85731 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-10-27 | 2022-09-25 | 2022-10-22 | 2022-11-08 | RRqYgsMGzljH | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-10-19 | 35 | 350 | |||||
| 87514 | 87514 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-09-29 | 2022-07-01 | 2022-09-24 | 2022-11-08 | FahAAhhDJU79 | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-07-19 | 35 | 315 | |||||
| 87570 | 87570 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-09-29 | 2022-07-01 | 2022-09-24 | 2022-11-08 | T2Jbwtz3RdNb | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-08-19 | 35 | 315 | |||||
| 87632 | 87632 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-09-29 | 2022-07-01 | 2022-09-24 | 2022-11-08 | x8kk6U9QuHrz | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-09-19 | 35 | 315 | |||||
| 87633 | 87633 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-09-29 | 2022-07-01 | 2022-09-24 | 2022-11-08 | K7vjwfS3gJ5P | IND | Powell | Randa | Oakland | CA | 94602 | The Mentoring Center 101 | Program Coordinator | n | 2022-09-19 | 900 | 900 | |||||
| 89965 | 89965 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-08-01 | 2022-01-01 | 2022-06-30 | 2022-11-08 | ts8M1yYQjPgj | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-01-19 | 35 | 210 | |||||
| 90006 | 90006 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-08-01 | 2022-01-01 | 2022-06-30 | 2022-11-08 | opTjQMosQ8jt | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-02-19 | 35 | 210 | |||||
| 90046 | 90046 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-08-01 | 2022-01-01 | 2022-06-30 | 2022-11-08 | roobZIrmQA7O | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-03-19 | 35 | 210 | |||||
| 90099 | 90099 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-08-01 | 2022-01-01 | 2022-06-30 | 2022-11-08 | I3F8VJwwcRR2 | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-04-19 | 35 | 210 | |||||
| 90140 | 90140 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-08-01 | 2022-01-01 | 2022-06-30 | 2022-11-08 | lTgt1ceA5TIg | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-05-19 | 35 | 210 | |||||
| 90147 | 90147 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-08-01 | 2022-01-01 | 2022-06-30 | 2022-11-08 | AqYAbU16mdGS | IND | Haskins | Don | Oakland | CA | 94612 | The Mentoring Center 101 | Program Director | n | 2022-05-20 | 100 | 100 | |||||
| 90208 | 90208 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-08-01 | 2022-01-01 | 2022-06-30 | 2022-11-08 | eUXVwXYwpFJp | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2022-06-19 | 35 | 210 | |||||
| 69828 | 69828 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-03-03 | 2021-07-01 | 2021-12-31 | 2022-11-08 | K6sgZeWqZIhc | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2021-12-19 | 150 | 150 | |||||
| 73700 | 73700 | 1442227 260 | Hodge for Oakland Mayor 2022 335 | 2022-01-31 | 2021-07-01 | 2021-12-31 | 2022-11-08 | K6sgZeWqZIhc | IND | Makini | Fanya | Oakland | CA | 94619 | The Mentoring Center 101 | Director | n | 2021-12-19 | 150 | 150 | |||||
| 35052 | 35052 | 1375179 109 | Re-Elect McElhaney for City Council 2016 117 | 2016-08-01 | 2016-01-01 | 2016-06-30 | 2016-11-08 | INC345 | IND | Snead | Celsa | Oakland | CA | 94610 | The Mentoring Center 101 | Attorney | n | 2016-04-27 | 100 | 100 | |||||
| 11392 | 11392 | 1369855 75 | Neighbors for a Safer Oakland 2014, Yes on Z, sponsored and major funding by International Association of Firefighters Local 55 72 | 2015-01-25 | 2014-10-19 | 2014-12-31 | INC143 | IND | Snead | Celsa | Oakland | CA | 94610 | The Mentoring Center 101 | Director | n | 2014-10-28 | 100 | 100 | ||||||
| 277 | 277 | 1345919 6 | James Harris for Oakland School Board 6 | 2013-01-31 | 2012-10-01 | 2012-10-20 | 2012-11-06 | C4571717 | IND | Pressley | George H. | Oakland | CA | 94611 | The Mentoring Center 101 | Director | n | 2012-10-17 | 100 | 100 | |||||
| 1338 | 1338 | 1345919 6 | James Harris for Oakland School Board 6 | 2012-10-25 | 2012-10-01 | 2012-10-20 | 2012-11-06 | C4571717 | IND | Pressley | George H. | Oakland | CA | 94611 | The Mentoring Center 101 | Director | n | 2012-10-17 | 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");