non_monetary_contributions

FPPC Form 460, Schedule C

Data source: C_Contributions

4 rows where filer_name = 74 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_start_date, report_end_date, transaction_date, year_to_date, report_date (date), report_start_date (date), report_end_date (date), transaction_date (date)

Link rowid filer_id filer_name report_date ▲ report_start_date report_end_date election_date transaction_id entity_type last_name first_name prefix city state zipcode employer occupation self_employed transaction_type transaction_date transaction_amt year_to_date transaction_description committee_id memo_reference_number
145 145 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2015-02-01 2014-10-19 2014-12-31   PAY34 COM International Association of Firefighters Local 55 PAC     Oakland CA 94612     n T 2014-12-05 510 14257.5 Bill Paid By Third Party 59.0 PAY34
146 146 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2015-02-01 2014-10-19 2014-12-31   PAY35 COM International Association of Firefighters Local 55 PAC     Oakland CA 94612     n T 2014-12-05 3747.5 14257.5 Bill Paid By Third Party 59.0 PAY35
322 322 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2015-02-01 2015-01-01 2015-01-09   PAY36 COM International Association of Firefighters Local 55 PAC     Oakland CA 94612     n T 2015-01-07 1078.1 1664.48 Bill Paid By Third Party 59.0 PAY36
323 323 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 2015-02-01 2015-01-01 2015-01-09   PAY37 COM International Association of Firefighters Local 55 PAC     Oakland CA 94612     n T 2015-01-07 586.38 1664.48 Bill Paid By Third Party 59.0 PAY37

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "non_monetary_contributions" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "last_name" TEXT,
  "first_name" TEXT,
  "prefix" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" TEXT,
  "transaction_date" TEXT,
  "transaction_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "transaction_description" TEXT,
  "committee_id" 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 ("employer") REFERENCES [businesses](id));
CREATE INDEX ["non_monetary_contributions_filer_id"] ON [non_monetary_contributions]("filer_id");
CREATE INDEX ["non_monetary_contributions_filer_name"] ON [non_monetary_contributions]("filer_name");
CREATE INDEX ["non_monetary_contributions_committee_id"] ON [non_monetary_contributions]("committee_id");
CREATE INDEX ["non_monetary_contributions_employer"] ON [non_monetary_contributions]("employer");