monetary_contributions
Data source: A_Contributions
7 rows where employer = 2591 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76995 | 76995 | 1441375 266 | Loren Taylor for Oakland Mayor 2022 343 | 2022-07-31 | 2022-01-01 | 2022-06-30 | 4885097 | IND | Abid | Isaac | Oakland | CA | 94612-3423 | HP Investors 2591 | Partner | n | 2022-06-30 | 500 | 500 | ||||||
88290 | 88290 | 1441375 266 | Loren Taylor for Mayor 2022 344 | 2022-07-31 | 2022-01-01 | 2022-06-30 | 4885097 | IND | Abid | Isaac | Oakland | CA | 94612-3423 | HP Investors 2591 | Partner | n | 2022-06-30 | 500 | 500 | ||||||
37951 | 37951 | 1395968 148 | Libby Schaaf for Mayor 2018 185 | 2017-07-19 | 2017-01-01 | 2017-06-30 | VNHZWFX25P4 | IND | Abid | Isaac | Oakland | CA | 94611-2533 | HP Investors 2591 | Real Estate | n | 2017-06-30 | 800 | 800 | ||||||
28879 | 28879 | 1387983 116 | Invest in Oakland's Infrastructure and Affordable Housing -- Yes on KK, a Coalition of Business, Community Leaders and Oakland Residents 130 | 2016-09-29 | 2016-01-01 | 2016-09-24 | 2016-11-08 | VSHBWD4PB50 | IND | Abid | Isaac | Oakland | CA | 94611-2533 | HP Investors 2591 | Partner | n | I | 2016-09-09 | 500 | 500 | ||||
34079 | 34079 | 1387983 116 | Invest in Oakland's Infrastructure and Affordable Housing -- Yes on KK, a Coalition of Business, Community Leaders and Oakland Residents 130 | 2016-09-29 | 2016-01-01 | 2016-09-24 | 2016-11-08 | VSHBWD4PB50 | IND | Abid | Isaac | Oakland | CA | 94611-2533 | HP Investors 2591 | Partner | n | 2016-09-09 | 500 | 500 | |||||
7855 | 7855 | 1362261 34 | Libby Schaaf for Oakland Mayor 2014 28 | 2014-09-30 | 2014-07-01 | 2014-09-30 | 2014-11-04 | VNHZWD4F1V1 | IND | Abid | Isaac | Oakland | CA | 94611-2533 | HP Investors 2591 | Real Estate | n | 2014-09-16 | 500 | 500 | |||||
17451 | 17451 | 1362261 34 | Libby Schaaf for Oakland Mayor 2014 28 | 2014-09-30 | 2014-07-01 | 2014-09-30 | 2014-11-04 | VNHZWD4F1V1 | IND | Abid | Isaac | Oakland | CA | 94611-2533 | HP Investors 2591 | Real Estate | n | 2014-09-16 | 500 | 500 |
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");