contribution_reports_24_hours

FPPC Form 497

Data source: 497

11 rows where committee_id = 618 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, committee_type, report_date, entity_type, entity_last_name, entity_city, entity_zipcode, contribution_date, amount, ballot_measure_name, 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
606 606 1405491 164 East Bay Alliance for a Sustainable Economy (EBASE) nonprofit 501(c)(3) 207 BMC 2018-10-25     2018-11-06 F497P2-8 BNM Time's Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-10-24 00:00:00 10139.53 1403165 618                 Hotel Protection and Employment Standards Enforcement Initiative   City of Oakland  
614 614 1294190 81 Unity PAC, sponsored by Alameda Labor Council, AFL-CIO to support Thao for City Council 2018 215 RCP 2018-10-23       EXP970 COM Yes on Measure Z, Committee for Fair Workplaces & Ending Sexual Assault on the Job Times Up Oakland:     Sacramento CA 95814       2018-10-23 00:00:00 25000 1403165 618                 Hotel Employee Minimum Wage Charter Amendment, Measure Z   City of Oakland  
615 615 1332115 37 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund 31 RCP 2018-10-23     2018-11-06 F497P2-1469 BNM Time's Up Oakland: Yes on Measure Z Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-10-22 00:00:00 5000 1403165 618                 Hotel Worker Protection Measure Z City of Oakland  
634 634 pending 99 UNITE HERE Local 2850 227   2018-10-22       7xvcrMHEtcCv COM Time's Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-10-22 00:00:00 1000 1403165 618                 Hotel Worker Protection and Employment Standards Enforcement Initiative   City of Oakland  
754 754 1405491 164 East Bay Alliance for a Sustainable Economy (EBASE) nonprofit 501(c)(3) 207 BMC 2018-09-27     2018-11-06 F497P2-7 BNM Time's Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-09-22 00:00:00 5564.95 1403165 618                 Hotel Protection and Employment Standards Enforcement Initiative   City of Oakland  
783 783 pending 99 UNITE HERE Local 2850 227   2018-09-24       KRGQ21Y9QkXC COM Time's Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-09-24 00:00:00 1000 1403165 618                 Hotel Worker Protection and Employment Standards Enforcement Initiative   City of Oakland  
808 808 pending 99 UNITE HERE Local 2850 227   2018-09-12       1b6nl347zdWt COM Time's Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-09-12 00:00:00 4120 1403165 618                 Hotel Worker Protection and Employment Standards Enforcement Initiative   City of Oakland  
811 811 pending 99 UNITE HERE Local 2850 227   2018-09-11       HUf2xH9sbG2W COM Time's Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-09-11 00:00:00 2500 1403165 618                 Hotel Worker Protection and Employment Standards Enforcement Initiative   City of Oakland  
815 815 1405491 164 East Bay Alliance for a Sustainable Economy (EBASE) nonprofit 501(c)(3) 207 BMC 2018-09-06     2018-11-06 F497P2-5 BNM Time's Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94612       2018-09-05 00:00:00 8000 1403165 618                 Hotel Protection and Employment Standards Enforcement Initiative   City of Oakland  
850 850 1284523 193 Alameda Labor Council, AFL-CIO Solidarity PAC 244 RCP 2018-05-22       EXP9858 COM Times Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Oakland CA 94621       2018-05-10 00:00:00 5000 1403165 618                 Hotel Protection and Employment Standards Enforcement Initiative   City of Oakland  
856 856 1351785 194 Sheet Metal Workers' International Association Local Union No. 104 Issues Committee 245 RCP 2018-05-10       EXP78357 COM Times Up Oakland: Committee for Fair Workplaces & Ending Sexual Assault on the Job       Sacramento CA 95814       2018-05-10 00:00:00 10000 1403165 618                 Hotel Protection & Employer Standards Enforcement TBD City of Oakland  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");