accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

37 rows where filer_name = 28 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
1201 1201 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2016-02-01 2015-07-01 2015-12-31   PAY1611 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 2000 0 2000 0 REIMBURSED EXPENSES    
1202 1202 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2016-02-01 2015-07-01 2015-12-31   PAY1724 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 299.39 0 299.39 0      
1239 1239 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-07-28 2015-01-01 2015-06-30   PAY1611 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 17007.7 0 15007.7 2000 REIMBURSED EXPENSES    
1240 1240 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-07-28 2015-01-01 2015-06-30   PAY1704 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 9572.4 0 9572.4 0      
1241 1241 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-07-28 2015-01-01 2015-06-30   PAY1724 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 299.39 0 0 299.39      
594 594 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-03-23 2014-10-19 2014-12-31   PAY1550 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 26819.04 0 26819.04 0      
595 595 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-03-23 2014-10-19 2014-12-31   PAY1571 OTH RALLY CAMPAIGNS       SAN FRANCSICO CA 94102 9270.41 0 9270.41 0 LIT SUPPORTING NINA SENN FOR OAKLAND UNIFIED SCHOOL BOARD, DISTRICT 2    
596 596 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-03-23 2014-10-19 2014-12-31   PAY1600 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 14862.37 0 14862.37 0 SEE SCHEDULE D & G    
597 597 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-03-23 2014-10-19 2014-12-31   PAY1653 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 8986.85 0 8986.85 0 REIMBURSED EXPENSES; SEE SCHEDULE G    
598 598 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-03-23 2014-10-19 2014-12-31   PAY1611 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 17007.7 0 17007.7 REIMBURSED EXPENSES; SEE SCHEDULE D & G    
599 599 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-03-23 2014-10-19 2014-12-31   PAY1704 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 9572.4 0 9572.4      
600 600 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-03-23 2014-10-19 2014-12-31   PAY1724 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 299.39 0 299.39      
350 350 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-07-01 2014-09-30 2014-11-04 PAY823 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 4274.42 0 4274.42 0      
351 351 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-07-01 2014-09-30 2014-11-04 PAY890 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 1545.76 0 1545.76 0 SEE SCHEDULE G    
352 352 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-07-01 2014-09-30 2014-11-04 PAY1150 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 17812.31 0 17812.31 SEE SCHEDULE G    
353 353 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-07-01 2014-09-30 2014-11-04 PAY1550 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 26819.04 0 26819.04      
554 554 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-10-01 2014-10-18 2014-11-04 PAY1150 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 17812.31 0 17812.31 0 SEE SCHEDULE G    
555 555 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-10-01 2014-10-18 2014-11-04 PAY1550 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 26819.04 0 0 26819.04      
556 556 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-10-01 2014-10-18 2014-11-04 PAY1571 OTH RALLY CAMPAIGNS       SAN FRANCSICO CA 94102 0 9270.41 0 9270.41 LIT SUPPORTING NINA SENN FOR OAKLAND UNIFIED SCHOOL BOARD, DISTRICT 2    
557 557 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-10-01 2014-10-18 2014-11-04 PAY1600 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 14862.37 0 14862.37 SEE SCHEDULE D & G    
558 558 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-02-02 2014-10-01 2014-10-18 2014-11-04 PAY1653 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 8986.85 0 8986.85 REIMBURSED EXPENSES; SEE SCHEDULE G    
623 623 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-01-27 2014-10-19 2014-12-31   PAY1550 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 26819.04 0 26819.04 0      
624 624 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-01-27 2014-10-19 2014-12-31   PAY1571 OTH RALLY CAMPAIGNS       SAN FRANCSICO CA 94102 9270.41 0 9270.41 0 LIT SUPPORTING NINA SENN FOR OAKLAND UNIFIED SCHOOL BOARD, DISTRICT 2    
625 625 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-01-27 2014-10-19 2014-12-31   PAY1600 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 14862.37 0 14862.37 0 SEE SCHEDULE D & G    
626 626 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-01-27 2014-10-19 2014-12-31   PAY1653 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 8986.85 0 8986.85 0 REIMBURSED EXPENSES; SEE SCHEDULE G    
627 627 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-01-27 2014-10-19 2014-12-31   PAY1611 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 17007.7 0 17007.7 REIMBURSED EXPENSES; SEE SCHEDULE D & G    
628 628 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2015-01-27 2014-10-19 2014-12-31   PAY1704 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 9572.4 0 9572.4      
857 857 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PAY1150 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 17812.31 0 17812.31 0 SEE SCHEDULE G    
858 858 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PAY1550 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 36481.07 0 0 36481.07      
859 859 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PAY1571 OTH RALLY CAMPAIGNS       SAN FRANCSICO CA 94102 0 9270.41 0 9270.41 LIT SUPPORTING NINA SENN FOR OAKLAND UNIFIED SCHOOL BOARD, DISTRICT 2    
860 860 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-10-23 2014-10-01 2014-10-18 2014-11-04 PAY1600 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 15000 0 15000      
980 980 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PAY823 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 4274.42 0 4274.42 0      
981 981 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PAY890 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 1545.76 0 1545.76 0 SEE SCHEDULE G    
982 982 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PAY1150 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 17812.31 0 17812.31 SEE SCHEDULE G    
983 983 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PAY1550 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 9783.03 0 9783.03      
1068 1068 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2014-07-31 2014-01-01 2014-06-30   PAY823 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 0 4274.42 0 4274.42      
182 182 1331137 34 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 28 RCP 2013-07-31 2013-01-01 2013-06-30   PAY524 OTH GREAT OAKLAND PUBLIC SCHOOLS       OAKLAND CA 94607 2992.5 0 2992.5 0      

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