accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

30 rows where filer_name = 118 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_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
5517 5517 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2022-01-08 2021-08-29 2021-12-31   PAY1168 OTH Oaktown Productions       Berkeley CA 94702 281.75 0 281.75 0 Accrued Paid    
5518 5518 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2022-01-08 2021-08-29 2021-12-31   PAY1151 OTH CliffordMoss.       Oakland CA 94609 33651.64 0 33651.64 0 Accrued Paid    
5519 5519 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2022-01-08 2021-08-29 2021-12-31   PAY1154 OTH Mystery Machine Creative       Sacramento CA 95814 500 0 500 0 Accrued Paid    
3416 3416 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2019-01-28 2018-10-21 2018-12-31   PAY979 OTH JR Media, Inc.       Sacramento CA 95814 4000 0 4000 0 Social Media Ad/Support Sheng Thao    
3417 3417 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2019-01-28 2018-10-21 2018-12-31   PAY990 OTH JR Media, Inc.       Sacramento CA 95814 1700 0 1700 0 Mailer Design/Support Sheng Thao    
3418 3418 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2019-01-28 2018-10-21 2018-12-31   PAY991 OTH JR Media, Inc.       Sacramento CA 95814 650 0 650 0 Doorhanger Design/Support Sheng Thao    
1728 1728 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2017-01-31 2016-09-25 2016-10-22 2016-11-08 PAY797 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 180 0 0 180 Phones for phonebanking; In-kind contribution to Nate Miley for Supervisor 2016 (#992285)    
2168 2168 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2017-01-31 2016-10-23 2016-12-31   PAY797 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 180 0 0 180 Phones for phonebanking; In-kind contribution to Nate Miley for Supervisor 2016 (#992285)    
2329 2329 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 PAY797 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 180 0 0 180 Phones for phonebanking; In-kind contribution to Nate Miley for Supervisor 2016 (#992285)    
2511 2511 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-09-29 2016-07-01 2016-09-24 2016-11-08 PAY797 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 180 0 0 180 Phones for phonebanking; In-kind contribution to Nate Miley for Supervisor 2016 (#992285)    
2666 2666 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-08-01 2016-05-22 2016-06-30   PAY797 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 0 180 0 180 Phones for phonebanking; In-kind contribution to Nate Miley for Supervisor 2016 (#992285)    
1153 1153 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-02-01 2015-07-01 2015-12-31   PAY568 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 3000 0 0 3000 Field Campaign/Support/Abel Guillen/Oakland City Council/District 2    
1154 1154 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-02-01 2015-07-01 2015-12-31   PAY569 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 3000 0 0 3000 Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4    
1155 1155 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-02-01 2015-07-01 2015-12-31   PAY603 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 6667.21 0 0 6667.21 Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4    
1156 1156 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-02-01 2015-07-01 2015-12-31   PAY604 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 6667.21 0 0 6667.21 Field Campaign/Support/Abel Guillen/Oakland City Council/District 2    
1157 1157 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-02-01 2015-07-01 2015-12-31   PAY625 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 1630 0 0 1630 Staff Time, Food & Supplies for Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4    
1158 1158 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2016-02-01 2015-07-01 2015-12-31   PAY626 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 1630 0 0 1630 Staff Time, Food & Supplies for Field Campaign/Support/Abel Guillen/Oakland City Council/District 2    
1313 1313 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY516 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 8733 0 8733 0 Staff Time for Field Campaign; In-Kind to CAs for Economic Prosperity to Support Tim Sbranti for Assembly 2014 (#1364160)   PAY516
1314 1314 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY568 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 3000 0 0 3000 Field Campaign/Support/Abel Guillen/Oakland City Council/District 2    
1315 1315 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY569 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 3000 0 0 3000 Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4    
1316 1316 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY609 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 177.2 0 177.2 0 Staff Time & Food for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2    
1317 1317 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY610 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 177.2 0 177.2 0 Staff Time & Food for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4    
1318 1318 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY603 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 6667.21 0 0 6667.21 Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4    
1319 1319 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY604 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 6667.21 0 0 6667.21 Field Campaign/Support/Abel Guillen/Oakland City Council/District 2    
1320 1320 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY607 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 515 0 515 0 Staff Time & Food for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4    
1321 1321 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY608 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 515 0 515 0 Staff Time & Food for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2    
1322 1322 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY625 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 1630 0 0 1630 Staff Time, Food & Supplies for Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4    
1323 1323 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY626 OTH GroundWorks Campaigns, Inc.       Sacramento CA 95815 1630 0 0 1630 Staff Time, Food & Supplies for Field Campaign/Support/Abel Guillen/Oakland City Council/District 2    
1324 1324 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY627 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2594.03 0 2594.03 0 Auto Dialer, Office Rent, Food & Supplies for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2    
1325 1325 1294190 81 Unity PAC, a sponsored committee of the Alameda Labor Council, AFL-CIO 118 RCP 2015-07-27 2015-01-01 2015-06-30   PAY628 OTH Alameda Labor Council, AFL-CIO       Oakland CA 94621 2594.03 0 2594.03 0 Auto Dialer, Office Rent, Food & Supplies for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4    

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