contribution_reports_24_hours
Data source: 497
13 rows where filer_id = 322 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, entity_type, entity_last_name, entity_city, entity_zipcode, contribution_date, amount, committee_id, report_date (date), election_date (date), contribution_date (date)
| Link | rowid | filer_id | filer_name | committee_type | report_date ▲ | report_start_date | report_end_date | election_date | transaction_id | entity_type | entity_last_name | entity_first_name | entity_prefix | entity_suffix | entity_city | entity_state | entity_zipcode | contributor_employer | contributor_occupation | contributor_self_employed | contribution_date | amount | committee_id | candidate_last_name | candidate_first_name | candidate_prefix | candidate_suffix | office_sought | office_jurisdiction | district_number | incumbent | ballot_measure_name | ballot_measure_number | ballot_measure_jurisdiction | memo_reference_number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655 | 1655 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-11-01 | 2024-11-05 | INC612 | SCC | AFSCME Local 3299 | Los Angeles | CA | 90017 | 2024-11-01 00:00:00 | 1200 | 1459663 1149 | ||||||||||||||||||||
| 1656 | 1656 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-11-01 | 2024-11-05 | INC614 | SCC | International Brotherhood of Electrical Workers Local 595 PAC | Sacramento | CA | 95814 | 2024-11-01 00:00:00 | 1200 | 1273532 63 | ||||||||||||||||||||
| 1738 | 1738 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-10-29 | 2024-11-05 | NON597 | COM | California Working Families Party | Oakland | CA | 94612 | 2024-10-25 00:00:00 | 412.04 | 1438874 937 | F497P1.NON597 | |||||||||||||||||||
| 1739 | 1739 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-10-29 | 2024-11-05 | NON598 | COM | California Working Families Party | Oakland | CA | 94612 | 2024-10-28 00:00:00 | 721 | 1438874 937 | F497P1.NON598 | |||||||||||||||||||
| 1774 | 1774 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-10-22 | 2024-11-05 | INC558 | COM | Sheet Metal Workers Local Union 104 | Livermore | CA | 94551 | 2024-10-21 00:00:00 | 1200 | 850381 81 | ||||||||||||||||||||
| 1822 | 1822 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-10-18 | 2024-11-05 | INC547 | SCC | Laborers' Local 304 PAC | Sacramento | CA | 95814 | 2024-10-18 00:00:00 | 1000 | 902565 66 | ||||||||||||||||||||
| 1823 | 1823 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-10-18 | 2024-11-05 | INC549 | COM | Oakland Rising Committee Sponsored by the Center for Empowered Politics | Oakland | CA | 94612 | 2024-10-18 00:00:00 | 1200 | 1332115 457 | ||||||||||||||||||||
| 1883 | 1883 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-10-09 | 2024-11-05 | INC522 | SCC | Service Employees International Union Local 1021 Candidate PAC | Sacramento | CA | 95814 | 2024-10-09 00:00:00 | 1200 | 1296948 39 | ||||||||||||||||||||
| 1884 | 1884 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-10-09 | 2024-11-05 | INC523 | COM | UA Local 342 | Concord | CA | 94518 | 2024-10-09 00:00:00 | 1200 | 890268 37 | ||||||||||||||||||||
| 1898 | 1898 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-10-07 | 2024-11-05 | INC512 | COM | United Food & Commercial Workers Local 5 PAC | San Jose | CA | 95113 | 2024-10-07 00:00:00 | 1000 | 1294035 40 | ||||||||||||||||||||
| 1960 | 1960 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-09-22 | 2024-11-05 | INC455 | COM | International Association of Firefighters Local 55 PAC | Oakland | CA | 94612 | 2024-09-21 00:00:00 | 1200 | 892160 59 | ||||||||||||||||||||
| 1970 | 1970 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-09-18 | 2024-11-05 | INC409 | COM | Alameda Labor Council, AFL-CIO Unity PAC | Oakland | CA | 94607 | 2024-09-18 00:00:00 | 1200 | 1294190 58 | ||||||||||||||||||||
| 1971 | 1971 | 1463441 322 | Carroll Fife for City Council 2024 440 | CTL | 2024-09-18 | 2024-11-05 | INC408 | COM | IFPTE Local 21 TJ Anthony PAC Fund | San Francisco | CA | 94103 | 2024-09-18 00:00:00 | 1200 | 881248 31 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "contribution_reports_24_hours" (
"filer_id" INTEGER,
"filer_name" INTEGER,
"committee_type" TEXT,
"report_date" TEXT,
"report_start_date" TEXT,
"report_end_date" TEXT,
"election_date" TEXT,
"transaction_id" TEXT,
"entity_type" TEXT,
"entity_last_name" TEXT,
"entity_first_name" TEXT,
"entity_prefix" TEXT,
"entity_suffix" TEXT,
"entity_city" TEXT,
"entity_state" TEXT,
"entity_zipcode" TEXT,
"contributor_employer" INTEGER,
"contributor_occupation" TEXT,
"contributor_self_employed" TEXT,
"contribution_date" TEXT,
"amount" NUMERIC,
"committee_id" INTEGER,
"candidate_last_name" TEXT,
"candidate_first_name" TEXT,
"candidate_prefix" TEXT,
"candidate_suffix" TEXT,
"office_sought" TEXT,
"office_jurisdiction" TEXT,
"district_number" TEXT,
"incumbent" TEXT,
"ballot_measure_name" TEXT,
"ballot_measure_number" TEXT,
"ballot_measure_jurisdiction" TEXT,
"memo_reference_number" TEXT
,
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 ("contributor_employer") REFERENCES [businesses](id));
CREATE INDEX ["contribution_reports_24_hours_filer_id"] ON [contribution_reports_24_hours]("filer_id");
CREATE INDEX ["contribution_reports_24_hours_filer_name"] ON [contribution_reports_24_hours]("filer_name");
CREATE INDEX ["contribution_reports_24_hours_committee_id"] ON [contribution_reports_24_hours]("committee_id");
CREATE INDEX ["contribution_reports_24_hours_contributor_employer"] ON [contribution_reports_24_hours]("contributor_employer");