contribution_reports_24_hours

FPPC Form 497

Data source: 497

24 rows where filer_name = 79 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, entity_type, entity_last_name, entity_city, entity_state, entity_zipcode, contribution_date, amount, committee_id, candidate_last_name, office_sought, office_jurisdiction, ballot_measure_name, ballot_measure_jurisdiction, report_date (date), contribution_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type entity_last_name entity_first_name entity_prefix entity_suffix entity_city entity_state entity_zipcode contributor_employer contributor_occupation contributor_self_employed contribution_date amount 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 memo_reference_number
18 18 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       NON643 COM Dignity CA SEIU- United Long Term Care Workers Local 6434       Los Angeles CA 90057       2014-11-01 00:00:00 14870.08 1.35726e+06 150                        
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-11-01       NON646 COM Service Employees International Union Political Education and Action Fund (SEIU PEA) (MPO)       Washington DC 20036       2014-11-01 00:00:00 20593.44 782200 151                        
28 28 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-30       INC638 COM International Federation of Professional and Technical Engineers - Local 21       San Francisco CA 94102       2014-10-28 00:00:00 5000 881248 31                        
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-10-28       NON631 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2014-10-19 00:00:00 7302.58 1.29695e+06 148                       NON:S497:631
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-10-27       INC630 COM Service Employees International Union Local 1021 Independent Expenditure PAC       Sacramento CA 95814       2014-10-24 00:00:00 15000 1.29695e+06 148                        
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-10-22       EXP629 COM Better Transportation for Alameda County, Yes on BB       Oakland CA 94607       2014-10-22 00:00:00 10000 1.36224e+06 290                 Alameda County 30 Year Transportation Expenditure Plan, Measure BB   Alameda County  
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-17       INC623 OTH CLC Alameda County AFL-CIO - COPE/Fundraising       Oakland CA 94621       2014-10-16 00:00:00 9000                          
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-17       INC624 COM International Federation of Professional and Technical Engineers - Local 21       San Francisco CA 94102       2014-10-16 00:00:00 10000 881248 31                        
70 70 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-15       INC621 COM International Brotherhood of Electrical Workers (IBEW) Local Union 1245       Vacaville CA 95687       2014-10-14 00:00:00 3000 742993 56                        
133 133 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-03       INC613 COM Dignity CA SEIU- United Long Term Care Workers Local 6434       Los Angeles CA 90057       2014-10-02 00:00:00 5000 1.35726e+06 150                        
172 172 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-24       NON592 COM California State Council of Service Employees Political Committee       Sacramento CA 95814       2014-09-23 00:00:00 6666.66 1.25832e+06 152                        
173 173 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-24       INC587 SCC Service Employees International Union Local 1021 Candidate PAC       Sacramento CA 95814       2014-09-24 00:00:00 50000 1.29695e+06 148                        
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-23       INC570 OTH CLC Alameda County AFL-CIO - COPE/Fundraising       Oakland CA 94621       2014-09-22 00:00:00 40000                          
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-23       EXP572 COM Abel Guillen for Oakland City Council 2014       Oakland CA 94609       2014-09-22 00:00:00 1400 1.36538e+06 294 Abel Guillen       CCM 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-23       EXP571 COM Annie Campbell Washington for Oakland City Council 2014       Oakland CA 94611       2014-09-22 00:00:00 1400 1.36561e+06 308 Anne Campbell Washington       CCM City of Oakland 4.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-23       EXP574 COM Bowser for Pleasanton School Board 2014       Pleasanton CA 94566       2014-09-22 00:00:00 1000 1.36797e+06 309 Jeff Bowser       OTH Pleasanton USD            
185 185 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-23       EXP576 COM Brenda Roberts for Oakland City Auditor 2014       Oakland CA 94610       2014-09-22 00:00:00 1000 1.36841e+06 307 Brenda Roberts       OTH City of Oakland            
186 186 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-23       EXP579 COM Gilmore for Mayor 2014       Sacramento CA 95815       2014-09-22 00:00:00 1000 1.32345e+06 310 Marie Gilmore       MAY City of Alameda            
187 187 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-23       EXP583 COM Gilmore for Mayor 2014       Sacramento CA 95815       2014-09-22 00:00:00 200 1.32345e+06 310 Marie Gilmore       MAY City of Alameda            
188 188 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-23       EXP573 COM Laursen for School Board 2014       Pleasanton CA 94566       2014-09-22 00:00:00 1000 1.36698e+06 311 Joan Laursen       OTH Pleasanton USD            
189 189 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-23       EXP575 COM Olivia Sanwong for Pleasanton City Council 2014       Oakland CA 94618       2014-09-22 00:00:00 1000 1.35563e+06 312 Olivia Sanwong       CCM City of Pleasanton            
190 190 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-23       EXP578 COM Solana Henneberry for AUSD School Board 2014       Alameda CA 94501       2014-09-22 00:00:00 1000 1.36746e+06 313 Solana Henneberry       OTH Alameda Unified School Board Election            
193 193 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       PDT33 COM Better Transportation for Alameda County       Oakland CA 94607       2014-09-18 00:00:00 1215 1.36224e+06 290                 Alameda County 30 Year Transportation Expenditure Plan, Measure BB   Alameda County  
194 194 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       PDT32 COM Lift Up Oakland - Yes on Measure FF - for better wages, healthy families & a healthy economy spons. by labor & community orgs       Sacramento CA 95814       2014-09-18 00:00:00 1215 1.36456e+06 283                 Establishing a minimum wage, requiring payment for accrued sick leave, and requiring payment for service charges to hospitality workers. Measure FF.   City of Oakland  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "contribution_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,
  "entity_type" TEXT,
  "entity_last_name" TEXT,
  "entity_first_name" TEXT,
  "entity_prefix" TEXT,
  "entity_suffix" TEXT,
  "entity_city" TEXT,
  "entity_state" TEXT,
  "entity_zipcode" TEXT,
  "contributor_employer" INTEGER,
  "contributor_occupation" TEXT,
  "contributor_self_employed" TEXT,
  "contribution_date" TEXT,
  "amount" NUMERIC,
  "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,
  "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),
    FOREIGN KEY ("contributor_employer") REFERENCES [businesses](id));
CREATE INDEX ["contribution_reports_24_hours_filer_id"] ON [contribution_reports_24_hours]("filer_id");
CREATE INDEX ["contribution_reports_24_hours_filer_name"] ON [contribution_reports_24_hours]("filer_name");
CREATE INDEX ["contribution_reports_24_hours_committee_id"] ON [contribution_reports_24_hours]("committee_id");
CREATE INDEX ["contribution_reports_24_hours_contributor_employer"] ON [contribution_reports_24_hours]("contributor_employer");