ie_expenditures

FPPC Form 465, Part 3 Expenditure

Data source: F465P3_Expenditures

24 rows where filer_id = 81 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, payee_last_name, payee_city, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_description, candidate_last_name, district_number, 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
58 58 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT43 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-10-01 59.85 36650.5 IND Office Space for Phonebanking; 10/1/14-10/18/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
59 59 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT44 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-10-01 515 36650.5 IND Staff Time & Food for Phonebanking; 10/1/14-10/18/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
60 60 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT47 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 2014-10-01 10167.21 36650.5 IND Field Campaign; 10/1/14-10/18/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
61 61 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT49 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-10-01 87 36650.5 IND Auto Dialer for Phonebanking; 10/1/14-10/18/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
62 62 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT42 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-10-01 59.85 36650.51 IND Office Space for Phonebanking; 10/1/14-10/18/14   Abel Guillen       CCM City of Oakland 2.0         S  
63 63 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT45 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-10-01 515 36650.51 IND Staff Time & Food for Phonebanking; 10/1/14-10/18/14   Abel Guillen       CCM City of Oakland 2.0         S  
64 64 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT46 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 2014-10-01 10167.21 36650.51 IND Field Campaign; 10/1/14-10/18/14   Abel Guillen       CCM City of Oakland 2.0         S  
65 65 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PDT48 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-10-01 87 36650.51 IND Auto Dialer for Phonebanking; 10/1/14-10/18/14   Abel Guillen       CCM City of Oakland 2.0         S  
114 114 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 EDT436 OTH Jim Ross Consulting       San Francisco CA 94102 2014-09-18 3654.84 25821.44 IND Doorhangers   Annie Campbell Washington       CCM City of Oakland 4.0         S  
115 115 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 EDT443.436 OTH Dezignamo       San Leandro CA 94578 2014-09-27 562.5   IND Design for Doorhangers   Annie Campbell Washington       CCM City of Oakland 4.0         S  
116 116 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 EDT444.436 OTH Pacific Print       San Jose CA 95122 2014-09-27 2615.63   IND Printing for Doorhangers   Annie Campbell Washington       CCM City of Oakland 4.0         S  
117 117 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 EDT440 OTH United Labor Bank       Oakland CA 94621 2014-09-27 337.5 25821.44 IND Room Rent for Phonebanking; 9/27/14-11/4/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
118 118 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT35 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-09-18 39.9 25821.44 IND Office Space for Field Campaign & Phonebanking; 9/18/14-9/30/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
119 119 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT37 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-09-18 87 25821.44 IND Auto Dialer for Phonebanking; 9/18/14-9/30/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
120 120 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT39 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 2014-09-18 21525 25821.44 IND Supplies & Staff Time for Field Campaign; 9/18/14-9/30/14   Annie Campbell Washington       CCM City of Oakland 4.0         S  
121 121 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT41 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-09-27 177.2 25821.44 IND Staff Time & Food for Phonebanking   Annie Campbell Washington       CCM City of Oakland 4.0         S  
122 122 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 EDT435 OTH Jim Ross Consulting       San Francisco CA 94102 2014-09-18 3654.85 25821.45 IND Doorhangers   Abel Guillen       CCM City of Oakland 2.0         S  
123 123 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 EDT441.435 OTH Pacific Print       San Jose CA 95122 2014-09-27 2615.63   IND Printing for Doorhangers   Abel Guillen       CCM City of Oakland 2.0         S  
124 124 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 EDT442.435 OTH Dezignamo       San Leandro CA 94578 2014-09-27 562.5   IND Design for Doorhangers   Abel Guillen       CCM City of Oakland 2.0         S  
125 125 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 EDT439 OTH United Labor Bank       Oakland CA 94621 2014-09-27 337.5 25821.45 IND Room Rent for Phonebanking; 9/27/14-11/4/14   Abel Guillen       CCM City of Oakland 2.0         S  
126 126 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT34 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-09-18 39.9 25821.45 IND Office Space for Field Campaign & Phonebanking; 9/18/14-9/30/14   Abel Guillen       CCM City of Oakland 2.0         S  
127 127 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT36 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-09-18 87 25821.45 IND Auto Dialer for Phonebanking; 9/18/14-9/30/14   Abel Guillen       CCM City of Oakland 2.0         S  
128 128 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT38 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 2014-09-18 21525 25821.45 IND Supplies & Staff Time for Field Campaign; 9/18/14-9/30/14   Abel Guillen       CCM City of Oakland 2.0         S  
129 129 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PDT40 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2014-09-27 177.2 25821.45 IND Staff Time & Food for Phonebanking   Abel Guillen       CCM City of Oakland 2.0         S  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ie_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 ["ie_expenditures_filer_id"] ON [ie_expenditures]("filer_id");
CREATE INDEX ["ie_expenditures_filer_name"] ON [ie_expenditures]("filer_name");
CREATE INDEX ["ie_expenditures_committee_id"] ON [ie_expenditures]("committee_id");