expenditure_summaries

FPPC Form 460, Schedule D

Data source: D_Expenditure

54 rows where committee_id = 198 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, report_date, report_start_date, report_end_date, transaction_id, payee_last_name, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, office_jurisdiction, 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
87 87 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-07-01 2014-09-30 2014-11-04 EDT29 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 881.87 6132.89 IND Coroplast Signs 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
88 88 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-07-01 2014-09-30 2014-11-04 EDT30 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 750 6132.89 IND Design for Signs 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
89 89 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-07-01 2014-09-30 2014-11-04 EDT33 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 365.55 6132.89 IND Data 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
90 90 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-07-01 2014-09-30 2014-11-04 EDT35 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 2300.02 6132.89 IND Printing for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
91 91 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-07-01 2014-09-30 2014-11-04 EDT37 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-23 435.45 6132.89 IND Mass Email 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
191 191 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-01 2014-10-18 2014-11-04 PDT16 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-01 600 11685.02 IND Design for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
192 192 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-01 2014-10-18 2014-11-04 PDT20 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-01 3915.22 11685.02 IND Mailhouse & Postage for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
193 193 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-01 2014-10-18 2014-11-04 EDT39 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-08 1036.91 11685.02 IND Printing for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
201 201 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-19 2014-12-31   EDT46 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 868.02 18983.17 IND Printing for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
202 202 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-19 2014-12-31   EDT48 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 2368.37 18983.17 IND Mailhouse & Postage for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
203 203 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-19 2014-12-31   EDT53 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 500 18983.17 IND Design for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
204 204 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-19 2014-12-31   EDT54 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 2153.17 18983.17 IND Mailhouse & Postage for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
205 205 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-19 2014-12-31   EDT56 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 750 18983.17 IND Design for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
206 206 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-19 2014-12-31   PDT23 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 200 18983.17 IND Emails 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
207 207 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-19 2014-12-31   PDT24 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 285.34 18983.17 IND Robocalls 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
208 208 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-04-10 2014-10-19 2014-12-31   PDT25 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 173.25 18983.17 IND Robocalls 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
216 216 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-27 2014-10-19 2014-12-31   EDT46 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 868.02 18983.17 IND Printing for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
217 217 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-27 2014-10-19 2014-12-31   EDT48 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 2368.37 18983.17 IND Mailhouse & Postage for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
218 218 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-27 2014-10-19 2014-12-31   EDT53 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 500 18983.17 IND Design for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
219 219 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-27 2014-10-19 2014-12-31   EDT54 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 2153.17 18983.17 IND Mailhouse & Postage for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
220 220 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-27 2014-10-19 2014-12-31   EDT56 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 750 18983.17 IND Design for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
221 221 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-27 2014-10-19 2014-12-31   PDT23 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 200 18983.17 IND Emails 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
222 222 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-27 2014-10-19 2014-12-31   PDT24 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 285.34 18983.17 IND Robocalls 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
223 223 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-27 2014-10-19 2014-12-31   PDT25 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 173.25 18983.17 IND Robocalls 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
269 269 892160 78 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 75 RCP 2015-02-02 2014-10-19 2014-12-31   PDT56 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-28 237.58 1855.16 IND Data purchase in support of Campbell Washington 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
270 270 892160 78 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 75 RCP 2015-02-02 2014-10-19 2014-12-31   PDT57 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-28 217.58 1855.16 IND Robocalls in support of Campbell Washington 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
323 323 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-02 2014-10-19 2014-12-31   EDT46 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 868.02 18983.17 IND Printing for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
324 324 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-02 2014-10-19 2014-12-31   EDT48 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 2368.37 18983.17 IND Mailhouse & Postage for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
325 325 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-02 2014-10-19 2014-12-31   EDT53 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 500 18983.17 IND Design for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
326 326 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-02 2014-10-19 2014-12-31   EDT54 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 2153.17 18983.17 IND Mailhouse & Postage for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
327 327 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-02 2014-10-19 2014-12-31   EDT56 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-22 750 18983.17 IND Design for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
328 328 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-02 2014-10-19 2014-12-31   PDT23 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 200 18983.17 IND Emails 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
329 329 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-02 2014-10-19 2014-12-31   PDT24 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 285.34 18983.17 IND Robocalls 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
330 330 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2015-02-02 2014-10-19 2014-12-31   PDT25 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-11-11 173.25 18983.17 IND Robocalls 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
100 100 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT29 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 881.87 6132.89 IND Coroplast Signs 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
101 101 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT30 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 750 6132.89 IND Design for Signs 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
102 102 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT33 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 365.55 6132.89 IND Data 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
103 103 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT35 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 2300.02 6132.89 IND Printing for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
104 104 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT37 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-23 435.45 6132.89 IND Mass Email 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
445 445 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT16 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-01 600 11685.02 IND Design for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
446 446 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT20 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-01 3915.22 11685.02 IND Mailhouse & Postage for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
447 447 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-22 2014-10-01 2014-10-18 2014-11-04 EDT39 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-10-08 1036.91 11685.02 IND Printing for Mailer 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
113 113 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-18 2014-07-01 2014-09-30 2014-11-04 EDT29 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 881.87 5366.22 IND Coroplast Signs 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
114 114 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-18 2014-07-01 2014-09-30 2014-11-04 EDT30 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 750 5366.22 IND Design for Signs 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
115 115 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-18 2014-07-01 2014-09-30 2014-11-04 EDT33 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 365.55 5366.22 IND Data 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
116 116 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-18 2014-07-01 2014-09-30 2014-11-04 EDT35 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 1533.35 5366.22 IND Mailers 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
117 117 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-18 2014-07-01 2014-09-30 2014-11-04 EDT37 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-23 435.45 5366.22 IND Mass Email 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
598 598 1294190 67 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 63 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EXP571 COM Annie Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 1400 1400 MON   1365610 198 Anne Campbell Washington       CCM City of Oakland 4.0         S  
542 542 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-05 2014-07-01 2014-09-30 2014-11-04 EDT29 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 881.87 5366.22 IND Coroplast Signs 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
543 543 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-05 2014-07-01 2014-09-30 2014-11-04 EDT30 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 750 5366.22 IND Design for Signs 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
544 544 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-05 2014-07-01 2014-09-30 2014-11-04 EDT33 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 365.55 5366.22 IND Data 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
545 545 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-05 2014-07-01 2014-09-30 2014-11-04 EDT35 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-22 1533.35 5366.22 IND Mailers 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
546 546 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-10-05 2014-07-01 2014-09-30 2014-11-04 EDT37 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-09-23 435.45 5366.22 IND Mass Email 1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  
624 624 943526 4 Oakland Police Officer's Association - Political Action Committee 4 RCP 2014-07-19 2014-01-01 2014-06-30   EXP107 COM Anne Campbell Washington for Oakland City Council 2014       Oakland CA 94611 2014-05-01 1400 1400 MON   1365610 198 Anne Campbell Washington       CCM City of Oakland, CA 4.0         S  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "expenditure_summaries" (
"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 ["expenditure_summaries_filer_id"] ON [expenditure_summaries]("filer_id");
CREATE INDEX ["expenditure_summaries_filer_name"] ON [expenditure_summaries]("filer_name");
CREATE INDEX ["expenditure_summaries_committee_id"] ON [expenditure_summaries]("committee_id");