ie_reports_24_hours

FPPC Form 496

Data source: 496

42 rows where filer_name = 79 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, transaction_id, amount, expenditure_date, expenditure_description, memo_reference_number, candidate_last_name, district_number, report_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 amount expenditure_date expenditure_description memo_reference_number ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number
37 37 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-04       PDT50 2594.03 2014-10-19 Auto Dialer, Office Rent, Food & Supplies for Phonebanking; 10/19/14-11/4/14 (estimate) PDT:S496:50       S Abel Guillen         City of Oakland 2.0
38 38 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-04       PDT52 32130.29 2014-10-19 Staff Time, Food & Supplies for Field Campaign; 10/19/14-11/4/14 (estimate) PDT:S496:52       S Abel Guillen         City of Oakland 2.0
39 39 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-04       PDT51 2594.03 2014-10-19 Auto Dialer, Office Rent, Food & Supplies for Phonebanking; 10/19/14-11/4/14 (estimate) PDT:S496:51       S Annie Campbell Washington         City of Oakland 4.0
40 40 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-04       PDT53 32130.29 2014-10-19 Staff Time, Food & Supplies for Field Campaign; 10/19/14-11/4/14 (estimate) PDT:S496:53       S Annie Campbell Washington         City of Oakland 4.0
41 41 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-04       EDT449 7435.04 2014-11-01 Staff time (11/1-11/4) EDT:S496:449       S Abel Guillen         City of Oakland 2.0
42 42 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-04       EDT451 10296.72 2014-11-01 Staff Time EDT:S496:451       S Abel Guillen         City of Oakland 2.0
52 52 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-01       EDT449 7435.04 2014-11-01 Staff time (11/1-11/4) EDT:S496:449       S Abel Guillen         City of Oakland 2.0
53 53 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-01       EDT451 10296.72 2014-11-01 Staff Time EDT:S496:451       S Abel Guillen         City of Oakland 2.0
54 54 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-01       EDT450 7435.04 2014-11-01 Staff time (11/1-11/4) EDT:S496:450       S Annie Campbell Washington         City of Oakland 4.0
55 55 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-11-01       EDT453 10296.72 2014-11-01 Staff Time EDT:S496:453       S Annie Campbell Washington         City of Oakland 4.0
99 99 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-20       PDT51 2594.03 2014-10-19 Auto Dialer, Office Rent, Food & Supplies for Phonebanking; 10/19/14-11/4/14 (estimate) PDT:S496:51       S Annie Campbell Washington         City of Oakland 4.0
100 100 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-20       PDT53 28479 2014-10-19 Staff Time, Food & Supplies for Field Campaign; 10/19/14-11/4/14 (estimate) PDT:S496:53       S Annie Campbell Washington         City of Oakland 4.0
101 101 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-20       PDT50 2594.03 2014-10-19 Auto Dialer, Office Rent, Food & Supplies for Phonebanking; 10/19/14-11/4/14 (estimate) PDT:S496:50       S Abel Guillen         City of Oakland 2.0
102 102 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-20       PDT52 28479 2014-10-19 Staff Time, Food & Supplies for Field Campaign; 10/19/14-11/4/14 (estimate) PDT:S496:52       S Abel Guillen         City of Oakland 2.0
142 142 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-02       PDT40 177.2 2014-09-27 Staff Time & Food for Phonebanking PDT:S496:40       S Abel Guillen         City of Oakland 2.0
143 143 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-02       EDT439 337.5 2014-09-27 Room Rent for Phonebanking; 9/27/14-11/4/14 EDT:S496:439       S Abel Guillen         City of Oakland 2.0
144 144 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-02       PDT42 59.85 2014-10-01 Office Space for Phonebanking; 10/1/14-10/18/14 PDT:S496:42       S Abel Guillen         City of Oakland 2.0
145 145 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-02       PDT45 515 2014-10-01 Staff Time & Food for Phonebanking; 10/1/14-10/18/14 PDT:S496:45       S Abel Guillen         City of Oakland 2.0
146 146 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-02       PDT46 10167.21 2014-10-01 Field Campaign; 10/1/14-10/18/14 PDT:S496:46       S Abel Guillen         City of Oakland 2.0
147 147 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-02       PDT48 87 2014-10-01 Auto Dialer for Phonebanking; 10/1/14-10/18/14 (estimate) PDT:S496:48       S Abel Guillen         City of Oakland 2.0
148 148 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-02       PDT41 177.2 2014-09-27 Staff Time & Food for Phonebanking PDT:S496:41       S Annie Campbell Washington         City of Oakland 4.0
149 149 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-02       EDT440 337.5 2014-09-27 Room Rent for Phonebanking; 9/27/14-11/4/14 EDT:S496:440       S Annie Campbell Washington         City of Oakland 4.0
150 150 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-02       PDT43 59.85 2014-10-01 Office Space for Phonebanking; 10/1/14-10/18/14 PDT:S496:43       S Annie Campbell Washington         City of Oakland 4.0
151 151 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-02       PDT44 515 2014-10-01 Staff Time & Food for Phonebanking; 10/1/14-10/18/14 PDT:S496:44       S Annie Campbell Washington         City of Oakland 4.0
152 152 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-02       PDT47 10167.21 2014-10-01 Field Campaign; 10/1/14-10/18/14 PDT:S496:47       S Annie Campbell Washington         City of Oakland 4.0
153 153 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-02       PDT49 87 2014-10-01 Auto Dialer for Phonebanking; 10/1/14-10/18/14 (estimate) PDT:S496:49       S Annie Campbell Washington         City of Oakland 4.0
19 19 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-30       PDT34 39.9 2014-09-18 Office Space for Field Campaign & Phonebanking; 9/18/14-9/30/14 PDT:S496:34       S Abel Guillen         City of Oakland 2.0
20 20 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-30       PDT36 87 2014-09-18 Auto Dialer for Phonebanking; 9/18/14-9/30/14 (estimate) PDT:S496:36       S Abel Guillen         City of Oakland 2.0
21 21 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-30       PDT38 21525 2014-09-18 Supplies & Staff Time for Field Campaign; 9/18/14-9/30/14 PDT:S496:38       S Abel Guillen         City of Oakland 2.0
22 22 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-30       EDT435 3654.85 2014-09-18 Doorhangers EDT:S496:435       S Abel Guillen         City of Oakland 2.0
23 23 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-30       PDT35 39.9 2014-09-18 Office Space for Field Campaign & Phonebanking; 9/18/14-9/30/14 PDT:S496:35       S Annie Campbell Washington         City of Oakland 4.0
24 24 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-30       PDT37 87 2014-09-18 Auto Dialer for Phonebanking; 9/18/14-9/30/14 (estimate) PDT:S496:37       S Annie Campbell Washington         City of Oakland 4.0
25 25 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-30       PDT39 21525 2014-09-18 Supplies & Staff Time for Field Campaign; 9/18/14-9/30/14 PDT:S496:39       S Annie Campbell Washington         City of Oakland 4.0
26 26 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-30       EDT436 3654.84 2014-09-18 Doorhangers EDT:S496:436       S Annie Campbell Washington         City of Oakland 4.0
177 177 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT29 3645 2014-09-18 Doorhangers PDT:S496:29       S Annie Campbell Washington         City of Oakland 4.0
178 178 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT35 39.9 2014-09-18 Office Space for Field Campaign & Phonebanking; 9/18/14-9/30/14 PDT:S496:35       S Annie Campbell Washington         City of Oakland 4.0
179 179 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT37 87 2014-09-18 Auto Dialer for Phonebanking; 9/18/14-9/30/14 (estimate) PDT:S496:37       S Annie Campbell Washington         City of Oakland 4.0
180 180 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT39 3000 2014-09-18 Field Campaign; 9/18/14-9/30/14 PDT:S496:39       S Annie Campbell Washington         City of Oakland 4.0
181 181 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT30 3645 2014-09-18 Doorhangers PDT:S496:30       S Abel Guillen         City of Oakland 2.0
182 182 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT34 39.9 2014-09-18 Office Space for Field Campaign & Phonebanking; 9/18/14-9/30/14 PDT:S496:34       S Abel Guillen         City of Oakland 2.0
183 183 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT36 87 2014-09-18 Auto Dialer for Phonebanking; 9/18/14-9/30/14 (estimate) PDT:S496:36       S Abel Guillen         City of Oakland 2.0
184 184 1294190 81 Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 RCP 2014-09-19       PDT38 3000 2014-09-18 Field Campaign; 9/18/14-9/30/14 PDT:S496:38       S Abel Guillen         City of Oakland 2.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ie_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,
  "amount" NUMERIC,
  "expenditure_date" TEXT,
  "expenditure_description" TEXT,
  "memo_reference_number" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id));
CREATE INDEX ["ie_reports_24_hours_filer_id"] ON [ie_reports_24_hours]("filer_id");
CREATE INDEX ["ie_reports_24_hours_filer_name"] ON [ie_reports_24_hours]("filer_name");