accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

11 rows where filer_id = 216 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, transaction_id, payee_last_name, payee_city, payee_state, payee_zipcode, beginning_balance, amount_incurred, amount_paid, ending_balance, expenditure_description, report_date (date), report_start_date (date), report_end_date (date), election_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 beginning_balance amount_incurred amount_paid ending_balance expenditure_description committee_id memo_reference_number
5605 5605 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 RCP 2021-03-05 2021-01-01 2021-03-05 2020-11-03 F-31-V OTH Red Horse Strategies       Brooklyn NY 11201 7984.7 0 7984.7 0 See Schedule E for codes or descriptions.    
5606 5606 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 RCP 2021-03-05 2021-01-01 2021-03-05 2020-11-03 F-13-V OTH Telegraph       Oakland CA 94612 26191.86 0 26191.86 0 See Schedule E for codes or descriptions.    
4573 4573 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 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 F-42-V OTH Alameda Labor Council AFL-CIO       Oakland CA 94621 0 1070.34 0 1070.34 Accrued In Error    
4574 4574 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 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 F-31-V OTH Red Horse Strategies       Brooklyn NY 11201 0 17548.65 0 17548.65 Accrued in Error    
4575 4575 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 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 F-13-V OTH Telegraph       Oakland CA 94612 0 48700.38 0 48700.38 Voter Data    
4681 4681 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 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 F-42-V OTH Alameda Labor Council AFL-CIO       Oakland CA 94621 1070.34 3455.29 4525.63 0 See Schedule E for codes or descriptions.    
4682 4682 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 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 F-31-V OTH Red Horse Strategies       Brooklyn NY 11201 17548.65 18280.04 27843.99 7984.7 Accrued in Error    
4683 4683 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 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 F-13-V OTH Telegraph       Oakland CA 94612 48700.38 68872.49 91381.01 26191.86 Voter Data    
5010 5010 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 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 F-42-V OTH Alameda Labor Council AFL-CIO       Oakland CA 94621 0 1070.34 0 1070.34 Phone Calls    
5011 5011 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 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 F-31-V OTH Red Horse Strategies       Brooklyn NY 11201 0 17548.65 0 17548.65 Phone Calls    
5012 5012 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 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 F-13-V OTH Telegraph       Oakland CA 94612 0 28666.68 0 28666.68 Doorhanger    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "accrued_expenses" (
"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" INTEGER,
  "payee_prefix" INTEGER,
  "payee_suffix" INTEGER,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "beginning_balance" INTEGER,
  "amount_incurred" INTEGER,
  "amount_paid" INTEGER,
  "ending_balance" INTEGER,
  "expenditure_description" TEXT,
  "committee_id" INTEGER,
  "memo_reference_number" INTEGER
,
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 ["accrued_expenses_filer_id"] ON [accrued_expenses]("filer_id");
CREATE INDEX ["accrued_expenses_filer_name"] ON [accrued_expenses]("filer_name");
CREATE INDEX ["accrued_expenses_committee_id"] ON [accrued_expenses]("committee_id");