on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

21 rows where filer_id = 77 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_state, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, report_date (date), report_start_date (date), report_end_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
579 579 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PDT16 OTH CUNNINGHAM-SLEMAKER       Pacific Palisades CA 90272 2014-10-14 2000 10500 TEL                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
580 580 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PDT17 OTH CUNNINGHAM-SLEMAKER       Pacific Palisades CA 90272 2014-10-14 8500 10500 TEL                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
581 581 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PDT15 OTH SHINE CREATIVE       WASHINGTON DC 20005 2014-10-14 1000 8140 TEL                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
582 582 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   EDT1 OTH COMCAST       Oakland CA 94621 2014-11-21 -12019.85 11339.85 TEL                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
583 583 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   EDT2 OTH EAST BAY EXPRESS       Oakland CA 94607 2014-11-21 -2346 0 PRT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
584 584 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   EDT3 OTH OAKLAND TRIBUNE       Oakland CA 94598 2014-11-21 -15649.2 28576.8 PRT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
673 673 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT9 OTH SHINE CREATIVE       WASHINGTON DC 20005 2014-09-15 7140 7140 TEL                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
674 674 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT10 OTH TRIBUTE I SF       SAN FRANCISCO CA 94122 2014-09-15 1500 1500 TEL                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
675 675 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   NON74 OTH ENTERPRISE       Oakland CA 94603 2014-09-30 565.39 0 TRS                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
676 676 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT14 OTH ARMOURMEDIA, INC       Santa Monica CA 90403 2014-09-15 9353.91 89353.91   COMMISSION                   ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
677 677 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT11 OTH COMCAST       Oakland CA 94621 2014-09-15 23359.7 23359.7 TEL                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
678 678 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT12 OTH EAST BAY EXPRESS       Oakland CA 94607 2014-09-15 2346 2346 PRT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
679 679 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT13 OTH OAKLAND TRIBUNE       Oakland CA 94598 2014-09-15 44226 44226 PRT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
680 680 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT7 OTH FIVE CORNERS STRATEGIES, LLC       Washington DC 20015 2014-09-30 5000 29519.15 POL                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
681 681 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT8 OTH FIVE CORNERS STRATEGIES, LLC       Washington DC 20015 2014-09-30 24519.15 29519.15   SEE SCHEDULE G                   ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
682 682 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT1 IND LOPEZ AMY     Sacramento CA 95816 2014-09-24 1000 2000 LIT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
683 683 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT4 IND LOPEZ AMY     Sacramento CA 95816 2014-09-24 1000 2000 LIT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
684 684 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT2 OTH TRADE LITHOGRAPHY       Richmond CA 94804 2014-09-24 13861.57 29256.03 LIT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
685 685 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT5 OTH TRADE LITHOGRAPHY       Richmond CA 94804 2014-09-24 15394.46 29256.03 LIT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
686 686 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT3 OTH TRADE LITHOGRAPHY MAILING       Richmond CA 94804 2014-09-24 6887.54 13821.21 LIT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  
687 687 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PDT6 OTH TRADE LITHOGRAPHY MAILING       Richmond CA 94804 2014-09-24 6933.67 13821.21 LIT                     ORDINANCES 13253, 13254 AND 13255   CITY OF OAKLAND O  

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