non_monetary_contributions

FPPC Form 460, Schedule C

Data source: C_Contributions

2 rows where filer_id = 216 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date (date), report_start_date (date), report_end_date (date), election_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
795 795 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-01-29 2020-10-18 2020-12-31 2020-11-03 C21 COM California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021     Sacramento CA 95814     n   2020-10-23 301.26 602.52 Staff Time 721.0  
796 796 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 2021-01-29 2020-10-18 2020-12-31 2020-11-03 C22 COM California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021     Sacramento CA 95814     n   2020-11-06 301.26 602.52 Staff Time 721.0  

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");