accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

13 rows where filer_id = 76 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
646 646 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2014-10-19 2014-12-31   PAY23 OTH Rutan & Tucker, LLP       Palo Alto CA 94306 3747.5 -3747.5 0 0      
647 647 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2014-10-19 2014-12-31   PAY21 OTH The Henry Levy Group       Oakland CA 94618 1078.1 0 0 1078.1      
648 648 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2014-10-19 2014-12-31   PAY33 OTH The Henry Levy Group       Oakland CA 94618 0 586.38 0 586.38      
1331 1331 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2015-01-01 2015-01-09   PAY21 OTH The Henry Levy Group       Oakland CA 94618 1078.1 -1078.1 0 0      
1332 1332 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2015-02-01 2015-01-01 2015-01-09   PAY33 OTH The Henry Levy Group       Oakland CA 94618 586.38 -586.38 0 0      
864 864 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-20 2014-10-01 2014-10-18 2014-11-04 PAY1 OTH Printpro       Oakland CA 94611 10738.77 0 10738.77 0 Mailer Production   PAY1
865 865 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-20 2014-10-01 2014-10-18 2014-11-04 PAY2 OTH Printpro       Oakland CA 94611 3185 0 3185 0 Postage for Mailer    
866 866 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-20 2014-10-01 2014-10-18 2014-11-04 PAY5 OTH The Henry Levy Group       Oakland CA 94618 1726.6 0 1726.6 0      
867 867 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-20 2014-10-01 2014-10-18 2014-11-04 PAY23 OTH Rutan & Tucker, LLP       Palo Alto CA 94306 0 3747.5 0 3747.5      
868 868 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-20 2014-10-01 2014-10-18 2014-11-04 PAY21 OTH The Henry Levy Group       Oakland CA 94618 0 1078.1 0 1078.1      
997 997 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PAY1 OTH Printpro       Oakland CA 94611 0 10738.77 0 10738.77 Mailer Production   PAY1
998 998 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PAY2 OTH Printpro       Oakland CA 94611 0 3185 0 3185 Postage for Mailer    
999 999 1371631 76 Working Families for Abel Guillen for Oakland City Council 2014, Sponsored by the International Association of Firefighters Local 55 PAC and Teamsters DRIVE Committee - FEC #C00032979 74 BMC 2014-10-06 2014-01-01 2014-09-30 2014-11-04 PAY5 OTH The Henry Levy Group       Oakland CA 94618 0 1726.6 0 1726.6      

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