monetary_contributions
Data source: A_Contributions
9 rows where employer = 12646 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, city, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98169 | 98169 | 1469795 360 | Patrice Berry for Oakland School Board 2024 494 | 2025-01-14 | 2024-10-20 | 2024-12-31 | 2024-11-05 | 356 | IND | Uwahemu | Uche | Richmond | CA | 94806 | Center for Elders Independence 12646 | Director of Government Affairs | n | 2025-10-28 | 300 | 300 | |||||
| 100477 | 100477 | 1469795 360 | Patrice Berry for Oakland School Board 2024 494 | 2025-01-14 | 2024-10-20 | 2024-12-31 | 2024-11-05 | 356 | IND | Uwahemu | Uche | Richmond | CA | 94806 | Center for Elders Independence 12646 | Director of Government Affairs | n | 2025-10-28 | 300 | 300 | |||||
| 97077 | 97077 | 1465054 311 | Nikki F Bas for Supervisor 2024 423 | 2024-10-23 | 2024-07-01 | 2024-09-21 | 2024-11-05 | INC883 | IND | Uwahemu | Uche | San Pablo | CA | 94806 | Center for Elders Independence 12646 | Government Affairs | n | 2024-09-05 | 300 | 300 | |||||
| 102803 | 102803 | 1465054 311 | Nikki F Bas for Supervisor 2024 423 | 2024-09-26 | 2024-07-01 | 2024-09-21 | 2024-11-05 | INC883 | IND | Uwahemu | Uche | San Pablo | CA | 94806 | Center for Elders Independence 12646 | Government Affairs | n | 2024-09-05 | 300 | 300 | |||||
| 92365 | 92365 | 1442792 264 | Councilmember Janani Ramachandran Oakland City Council District 4 Officeholder Committee 436 | 2024-01-31 | 2023-07-01 | 2023-12-31 | h7IAubmbkhEE | IND | Uwahemu | Uche | Richmond | CA | 94806 | Center for Elders Independence 12646 | Government Affairs | n | 2023-11-14 | 500 | 500 | ||||||
| 84262 | 84262 | 1443971 276 | Kevin Jenkins for Oakland City Council 2022 358 | 2023-01-27 | 2022-10-23 | 2022-12-31 | 2022-11-08 | IDT141 | IND | Uwahemu | Uche | San Pablo | CA | 94806 | Center for Elders Independence 12646 | Director of Government Affairs | n | I | 2022-11-04 | 300 | 300 | ||||
| 80760 | 80760 | 1442792 264 | Janani Ramachandran for Oakland City Council Disrict 4 2022 342 | 2022-12-07 | 2022-09-25 | 2022-10-22 | 2022-11-08 | shMeSxAOunlR | IND | Uwahemu | Uche | Richmond | CA | 94806 | Center for Elders Independence 12646 | Government Affairs | n | 2022-10-09 | 250 | 250 | |||||
| 85488 | 85488 | 1442792 264 | Janani Ramachandran for Oakland City Council Disrict 4 2022 342 | 2022-10-27 | 2022-09-25 | 2022-10-22 | 2022-11-08 | shMeSxAOunlR | IND | Uwahemu | Uche | Richmond | CA | 94806 | Center for Elders Independence 12646 | Government Affairs | n | 2022-10-09 | 250 | 250 | |||||
| 89365 | 89365 | 1442594 266 | Sheng Thao for Oakland Mayor 2022 344 | 2022-08-01 | 2022-01-01 | 2022-06-30 | 2022-11-08 | PdtjEBADmMHB | IND | uwahemu | Uche | Richmond | CA | 94804 | Center for Elders Independence 12646 | Director of Government Affairs | n | 2022-06-30 | 250 | 250 |
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");