accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

10 rows where filer_name = 364 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, beginning_balance, amount_incurred, amount_paid, ending_balance, 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
6060 6060 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2023-01-29 2022-09-25 2022-10-22 2022-11-08 PAY65 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 734.92 0 0 734.92 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6061 6061 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2023-01-29 2022-09-25 2022-10-22 2022-11-08 PAY66 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 1259.63 0 1259.63 0 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6062 6062 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2023-01-29 2022-09-25 2022-10-22 2022-11-08 PAY97 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 0 1315.24 0 1315.24 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6315 6315 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2023-01-29 2022-10-23 2022-12-31   PAY65 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 734.92 0 734.92 0 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6316 6316 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2023-01-29 2022-10-23 2022-12-31   PAY97 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 1315.24 0 1315.24 0 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6472 6472 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PAY65 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 734.92 0 0 734.92 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6473 6473 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2022-10-27 2022-09-25 2022-10-22 2022-11-08 PAY66 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 1259.63 0 1259.63 0 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6631 6631 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2022-09-29 2022-07-01 2022-09-24   PAY42 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 367.5 0 367.5 0 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6632 6632 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2022-09-29 2022-07-01 2022-09-24   PAY65 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 0 734.92 0 734.92 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    
6633 6633 1444480 281 OAKLANDERS FOR THE OAKLAND ZOO 2022, YES ON Y, SPONSORED BY THE CONSERVATION SOCIETY OF CALIFORNIA 364 BMC 2022-09-29 2022-07-01 2022-09-24   PAY66 OTH THE SUTTON LAW FIRM       SAN FRANCISCO CA 94108 0 1259.63 0 1259.63 JAMES SUTTON, COMMITTEE TREASURER, IS OWNER OF PAYEE; MATTHEW ALVAREZ, COMMITTEE ASSISTANT TREASURER, IS EMPLOYEE OF PAYEE.    

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