accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

30 rows where filer_name = 153 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, election_date, transaction_id, entity_type, payee_last_name, payee_first_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
4100 4100 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2019-07-31 2019-01-01 2019-06-30 2016-11-08 NPJ7sHqmEZyg OTH SCN Strategies, Inc.       San Francisco CA 94104 25527 0 0 25527 Moore for Oakland Campaign Spots    
3263 3263 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2019-01-31 2018-07-01 2018-12-31 2016-11-06 NPJ7sHqmEZyg OTH SCN Strategies, Inc.       San Francisco CA 94104 25527 0 0 25527 Moore for Oakland Campaign Spots    
3929 3929 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2018-07-27 2018-01-01 2018-06-30 2016-11-08 NPJ7sHqmEZyg OTH SCN Strategies, Inc.       San Francisco CA 94104 25527 0 0 25527 Moore for Oakland Campaign Spots    
2822 2822 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2018-01-31 2016-08-01 2017-12-31 2016-11-08 NPJ7sHqmEZyg OTH SCN Strategies, Inc.       San Francisco CA 94104 0 25527 0 25527 Moore for Oakland Campaign Spots    
2823 2823 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2018-01-31 2016-08-01 2017-12-31 2016-11-08 G1NLTcKE3GdC OTH Madison Street Press       Oakland CA 94607 0 845.34 0 845.34 Postcards    
2831 2831 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2017-08-01 2017-01-01 2017-06-30 2016-11-08 NPJ7sHqmEZyg OTH SCN Strategies, Inc.       San Francisco CA 94104 30027 0 4500 25527 Moore for Oakland Campaign Spots    
2000 2000 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2017-01-31 2016-08-01 2016-12-31 2016-11-08 NPJ7sHqmEZyg OTH SCN Strategies, Inc.       San Francisco CA 94104 0 30027 0 30027 Moore for Oakland Campaign Spots    
2227 2227 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 nv9F2qecft4l OTH Opportunities in UrbanRenaissance Television       Oakland CA 94621 0 2500 0 2500 Commercial    
2228 2228 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 ZmaioJOKRdLY OTH Comcast       Seattle WA 98124-1744 325.32 0 0 325.32 Wi-Fi Installation and Service    
2229 2229 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 FFtoiHK7RVnK IND Murphy Mike     Oakland CA 94612 2500 0 0 2500 Rent September    
2230 2230 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 fo54jqWRZbtc IND Moore Peggy     Oakland CA 94606 250 0 0 250 Candidate Filing Fee    
2231 2231 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 xfzx94VM5xzH IND Moore Peggy     Oakland CA 94606 50 0 0 50 Declaration of Candidacy    
2232 2232 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 ap8AqBdm9wIM OTH EMC Research       Oakland CA 94612 15000 0 10000 5000 Oakland City Council Survey    
2233 2233 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 EUkeaHqCghYX OTH Madison Street Press       Oakland CA 94607 974.55 0 974.55 0 Campaign T-Shirts    
2234 2234 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 roO4FCogCuqx OTH Madison Street Press       Oakland CA 94607 5759.7 0 5759.7 0 Pledge Card Brochure    
2235 2235 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 x5f2WGXBdUIx OTH Madison Street Press       Oakland CA 94607 2556.83 0 0 2556.83 Banners, Stickers, Post Cards, Window Signs and Placards    
2236 2236 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 mtGYyob3SRAA OTH Madison Street Press       Oakland CA 94607 4637.33 0 0 4637.33 Lawn Signs    
2237 2237 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 Lpks8BQQtXea OTH Madison Street Press       Oakland CA 94607 258.42 0 0 258.42 Banner    
2238 2238 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-10-27 2016-09-25 2016-10-22 2016-11-08 NPJ7sHqmEZyg OTH SCN Strategies, Inc.       San Francisco CA 94104 30027 0 0 30027 Moore for Oakland Campaign Spots    
2500 2500 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 ZmaioJOKRdLY OTH Comcast       Seattle WA 98124-1744 0 325.32 0 325.32 Wi-Fi Installation and Service    
2501 2501 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 FFtoiHK7RVnK IND Murphy Mike     Oakland CA 94612 0 2500 0 2500 Rent September    
2502 2502 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 fo54jqWRZbtc IND Moore Peggy     Oakland CA 94606 0 250 0 250 Candidate Filing Fee    
2503 2503 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 xfzx94VM5xzH IND Moore Peggy     Oakland CA 94606 0 50 0 50 Declaration of Candidacy    
2504 2504 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 ap8AqBdm9wIM OTH EMC Research       Oakland CA 94612 0 15000 0 15000 Oakland City Council Survey    
2505 2505 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 EUkeaHqCghYX OTH Madison Street Press       Oakland CA 94607 0 974.55 0 974.55 Campaign T-Shirts    
2506 2506 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 roO4FCogCuqx OTH Madison Street Press       Oakland CA 94607 0 5759.7 0 5759.7 Pledge Card Brochure    
2507 2507 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 x5f2WGXBdUIx OTH Madison Street Press       Oakland CA 94607 0 2556.83 0 2556.83 Banners, Stickers, Post Cards, Window Signs and Placards    
2508 2508 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 mtGYyob3SRAA OTH Madison Street Press       Oakland CA 94607 0 4637.33 0 4637.33 Lawn Signs    
2509 2509 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 Lpks8BQQtXea OTH Madison Street Press       Oakland CA 94607 0 258.42 0 258.42 Banner    
2510 2510 1388168 133 Moore for Oakland City Council At-Large 153 CTL 2016-09-29 2016-08-01 2016-09-24 2016-11-08 NPJ7sHqmEZyg OTH SCN Strategies, Inc.       San Francisco CA 94104 0 30027 0 30027 Moore for Oakland Campaign Spots    

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