on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

8 rows where filer_name = 74 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, entity_type, payee_last_name, payee_city, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_description, report_date (date), report_start_date (date), report_end_date (date), election_date (date), expenditure_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type payee_last_name payee_first_name payee_prefix payee_suffix payee_city payee_state payee_zipcode expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description 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 support_or_oppose memo_reference_number
575 575 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2014-10-19 2014-12-31   PDT12 OTH California State Board of Equalization       Oakland CA 94612 2014-10-20 507.56 507.56 IND Mailers in support of Abel Guilen                            
576 576 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2014-10-19 2014-12-31   PDT13 IND Lopez Amy     Sacramento CA 95816 2014-10-20 650 1300 IND Mailers in support of Abel Guilen                            
577 577 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2014-10-19 2014-12-31   PDT14 OTH Trade Lithography       Richmond CA 94804 2014-10-20 4202.82 14682.49 IND Mailers in support of Abel Guilen                            
578 578 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2014-10-19 2014-12-31   PDT15 OTH U.S. Postmaster       Oakland CA 94611 2014-10-20 3185 3185 IND Mailers in support of Abel Guilen                            
779 779 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT4 IND Lopez Amy     Sacramento CA 95816 2014-09-24 650 650 IND Graphic Art/Design                            
780 780 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT5 OTH Trade Lithography       Richmond CA 94804 2014-09-24 5806.94 10479.67 IND Printing                            
781 781 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT6 OTH Trade Lithography       Richmond CA 94804 2014-09-24 4672.73 10479.67 IND Mailhouse                            
782 782 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-06 2014-01-01 2014-09-30 2014-11-04 NON4 OTH U.S. Postmaster       Oakland CA 94611 2014-09-24 3185 0 IND Postage for Mailer                            

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "on_behalf_of_expenditures" (
"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,
  "payee_last_name" TEXT,
  "payee_first_name" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "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,
  "support_or_oppose" 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));
CREATE INDEX ["on_behalf_of_expenditures_filer_id"] ON [on_behalf_of_expenditures]("filer_id");
CREATE INDEX ["on_behalf_of_expenditures_filer_name"] ON [on_behalf_of_expenditures]("filer_name");
CREATE INDEX ["on_behalf_of_expenditures_committee_id"] ON [on_behalf_of_expenditures]("committee_id");