monetary_contributions
Data source: A_Contributions
17 rows where employer = 11264 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, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101529 | 101529 | 1465054 311 | Nikki F Bas for Supervisor 2024 423 | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | INC1010 | IND | Soltani | Abdi | Berkeley | CA | 94705 | ACLU of Northern CA 11264 | Executive Director | n | 2024-09-22 | 100 | 100 | |||||
| 83233 | 83233 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2023-01-31 | 2022-07-01 | 2022-12-31 | A-45370 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-07-02 | 10 | 60 | ||||||
| 83249 | 83249 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2023-01-31 | 2022-07-01 | 2022-12-31 | A-45382 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-08-02 | 10 | 70 | ||||||
| 83271 | 83271 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2023-01-31 | 2022-07-01 | 2022-12-31 | A-45404 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-09-02 | 10 | 80 | ||||||
| 83295 | 83295 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2023-01-31 | 2022-07-01 | 2022-12-31 | A-50451 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-10-02 | 10 | 90 | ||||||
| 83329 | 83329 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2023-01-31 | 2022-07-01 | 2022-12-31 | A-60510 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-11-02 | 10 | 100 | ||||||
| 85780 | 85780 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-10-26 | 2022-09-25 | 2022-10-22 | 2022-11-08 | A-50451 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-10-02 | 10 | 90 | |||||
| 85947 | 85947 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-09-29 | 2022-07-01 | 2022-09-24 | 2022-11-08 | A-45370 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-07-02 | 10 | 60 | |||||
| 85963 | 85963 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-09-29 | 2022-07-01 | 2022-09-24 | 2022-11-08 | A-45382 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-08-02 | 10 | 70 | |||||
| 85985 | 85985 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-09-29 | 2022-07-01 | 2022-09-24 | 2022-11-08 | A-45404 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-09-02 | 10 | 80 | |||||
| 90903 | 90903 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-07-30 | 2022-01-01 | 2022-06-30 | A-20190 | IND | Herring | Ruth | San Francisco | CA | 94112 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-01-10 | 50 | 50 | ||||||
| 90909 | 90909 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-07-30 | 2022-01-01 | 2022-06-30 | A-20196 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-02-02 | 10 | 10 | ||||||
| 90918 | 90918 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-07-30 | 2022-01-01 | 2022-06-30 | A-25208 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-03-02 | 10 | 20 | ||||||
| 90939 | 90939 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-07-30 | 2022-01-01 | 2022-06-30 | A-25228 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-04-02 | 10 | 30 | ||||||
| 90950 | 90950 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-07-30 | 2022-01-01 | 2022-06-30 | A-25238 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-05-02 | 10 | 40 | ||||||
| 90965 | 90965 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-07-30 | 2022-01-01 | 2022-06-30 | A-25253 | IND | Balonek | Courtney | Sacramento | CA | 95831 | ACLU of Northern CA 11264 | Fundraiser | n | 2022-06-02 | 10 | 50 | ||||||
| 70336 | 70336 | 1439739 267 | Committee To Elect Allyssa Victory To Oakland Mayor 2022 345 | 2022-03-26 | 2021-07-01 | 2021-12-31 | A-10106 | IND | Chou | Jennifer | San Francisco | CA | 94110 | ACLU of Northern CA 11264 | Attorney | n | 2021-11-08 | 50 | 50 |
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");