accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

22 rows where filer_id = 77 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, report_date (date), report_start_date (date), report_end_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
1226 1226 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-12-04 2015-07-01 2015-11-18   PAY141 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 229 0 229 0      
1227 1227 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-12-04 2015-07-01 2015-11-18   PAY144 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 222 0 222 0      
1236 1236 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-07-22 2015-01-01 2015-06-30   PAY126 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 1150.98 0 1150.98 0      
1237 1237 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-07-22 2015-01-01 2015-06-30   PAY141 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 0 229 0 229      
1238 1238 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-07-22 2015-01-01 2015-06-30   PAY144 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 0 222 0 222      
651 651 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY69 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 10000 0 10000 0      
652 652 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY66 OTH TRAMUTOLA, LLC       Oakland CA 94611 259.51 0 259.51 0      
653 653 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY47 OTH TRAMUTOLA, LLC       Oakland CA 94611 50000 0 50000 0      
654 654 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY57 OTH MWW GROUP LLC       East Rutherford NJ 07073 6000 0 6000 0 SEE SCHEDULE G    
655 655 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY63 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 58904.45 0 58904.45 0      
656 656 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY72 OTH MWW GROUP LLC       East Rutherford NJ 07073 29672.98 0 29672.98 0 SEE SCHEDULE G    
657 657 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY90 OTH TRAMUTOLA, LLC       Oakland CA 94611 243.6 0 243.6 0      
658 658 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY94 OTH STATEWIDE INFORMATION SYSTEMS       Sacramento CA 95816 1639.46 0 1639.46 0      
659 659 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2015-02-02 2014-10-01 2014-12-31   PAY126 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 0 1150.98 0 1150.98      
773 773 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PAY69 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 0 10000 0 10000      
774 774 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PAY66 OTH TRAMUTOLA, LLC       Oakland CA 94611 0 259.51 0 259.51      
775 775 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PAY47 OTH TRAMUTOLA, LLC       Oakland CA 94611 0 50000 0 50000      
776 776 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PAY57 OTH MWW GROUP LLC       East Rutherford NJ 07073 0 6000 0 6000 SEE SCHEDULE G    
777 777 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PAY63 OTH NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP       SACRAMENTO CA 95814 0 58904.45 0 58904.45      
778 778 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PAY72 OTH MWW GROUP LLC       East Rutherford NJ 07073 0 29672.98 0 29672.98 SEE SCHEDULE G    
779 779 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PAY90 OTH TRAMUTOLA, LLC       Oakland CA 94611 0 243.6 0 243.6      
780 780 1370696 77 OAKLAND RESIDENTS FOR A CLEAN CITY, WITH MAJOR FUNDING BY WASTE MANAGEMENT AND AFFILIATED ENTITIES 75 BMC 2014-11-12 2014-01-01 2014-09-30   PAY94 OTH STATEWIDE INFORMATION SYSTEMS       Sacramento CA 95816 0 1639.46 0 1639.46      

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