accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

44 rows where filer_id = 17 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_zipcode, 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
8250 8250 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2025-01-15 2024-09-22 2024-12-31   PAY18835 OTH S.E. Owens & Company       Oakland CA 94607 375 0 375 0      
8761 8761 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-09-23 2024-07-01 2024-09-21 2024-11-05 PAY18835 OTH S.E. Owens & Company       Oakland CA 94607 0 375 0 375      
8935 8935 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-07-13 2024-02-18 2024-06-30   PAY18817 IND Apple Candace     Oakland CA 94611 372.88 0 372.88 0      
7449 7449 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-06-18 2024-01-01 2024-02-17 2024-03-05 PAY18815 IND Apple Candace     Oakland CA 94611 57 0 0 57      
7450 7450 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2024-06-18 2024-01-01 2024-02-17 2024-03-05 PAY18817 IND Apple Candace     Oakland CA 94611 0 372.88 0 372.88      
7282 7282 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2023-07-13 2023-01-01 2023-06-30   PAY18717 OTH S.E. Owens & Company       Oakland CA 94607 813.5 0 813.5 0      
7283 7283 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2023-07-13 2023-01-01 2023-06-30   PAY18729 OTH S.E. Owens & Company       Oakland CA 94607 800 0 800 0      
7284 7284 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2023-07-13 2023-01-01 2023-06-30   PAY18734 OTH S.E. Owens & Company       Oakland CA 94607 406.5 0 406.5 0      
6268 6268 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2023-01-25 2022-09-25 2022-12-31   PAY18717 OTH S.E. Owens & Company       Oakland CA 94607 813.5 0 0 813.5      
6269 6269 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2023-01-25 2022-09-25 2022-12-31   PAY18724 OTH S.E. Owens & Company       Oakland CA 94607 418.5 -418.5 0 0      
6270 6270 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2023-01-25 2022-09-25 2022-12-31   PAY18729 OTH S.E. Owens & Company       Oakland CA 94607 0 800 0 800      
6271 6271 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2023-01-25 2022-09-25 2022-12-31   PAY18734 OTH S.E. Owens & Company       Oakland CA 94607 0 406.5 0 406.5      
6742 6742 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2022-09-24 2022-07-01 2022-09-24 2022-11-08 PAY18717 OTH S.E. Owens & Company       Oakland CA 94607 0 813.5 0 813.5      
6743 6743 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2022-09-24 2022-07-01 2022-09-24 2022-11-08 PAY18724 OTH S.E. Owens & Company       Oakland CA 94607 0 418.5 0 418.5      
3043 3043 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2019-03-07 2018-07-01 2018-09-22 2018-11-06 PAY13734 OTH S.E. Owens & Company       Oakland CA 94618 0 886.69 0 886.69      
3238 3238 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2019-03-07 2018-09-23 2018-12-31   PAY13734 OTH S.E. Owens & Company       Oakland CA 94618 886.69 0 886.69 0      
3044 3044 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2019-01-28 2018-07-01 2018-09-22 2018-11-06 PAY13734 OTH S.E. Owens & Company       Oakland CA 94618 0 886.69 0 886.69      
3407 3407 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2019-01-28 2018-09-23 2018-12-31   PAY13734 OTH S.E. Owens & Company       Oakland CA 94618 886.69 0 886.69 0      
3720 3720 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-09-27 2018-07-01 2018-09-22 2018-11-06 PAY13734 OTH S.E. Owens & Company       Oakland CA 94618 0 886.69 0 886.69      
2797 2797 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-01-29 2017-07-01 2017-12-31   PAY11028 OTH The Henry Levy Group       Oakland CA 94618 357.15 0 357.15 0      
2798 2798 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2018-01-29 2017-07-01 2017-12-31   PAY11088 OTH The Henry Levy Group       Oakland CA 94618 811.6 0 811.6 0      
2714 2714 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-09-14 2017-01-01 2017-06-30   PAY10614 OTH The Henry Levy Group       Oakland CA 94618 1942.45 0 1942.45 0      
2715 2715 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-09-14 2017-01-01 2017-06-30   PAY11028 OTH The Henry Levy Group       Oakland CA 94618 0 357.15 0 357.15      
2716 2716 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-09-14 2017-01-01 2017-06-30   PAY11088 OTH The Henry Levy Group       Oakland CA 94618 0 811.6 0 811.6      
2955 2955 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-07-24 2017-01-01 2017-06-30   PAY10614 OTH The Henry Levy Group       Oakland CA 94618 1942.45 0 1942.45 0      
2956 2956 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-07-24 2017-01-01 2017-06-30   PAY11028 OTH The Henry Levy Group       Oakland CA 94618 0 357.15 0 357.15      
2957 2957 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-07-24 2017-01-01 2017-06-30   PAY11088 OTH The Henry Levy Group       Oakland CA 94618 0 811.6 0 811.6      
1875 1875 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-07-04 2016-07-01 2016-12-31   PAY9574 OTH The Henry Levy Group       Oakland CA 94618 887.5 0 887.5 0      
1876 1876 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-07-04 2016-07-01 2016-12-31   PAY10614 OTH The Henry Levy Group       Oakland CA 94618 0 1942.45 0 1942.45      
2201 2201 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-01-11 2016-07-01 2016-12-31   PAY9574 OTH The Henry Levy Group       Oakland CA 94618 887.5 0 887.5 0      
2202 2202 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2017-01-11 2016-07-01 2016-12-31   PAY10614 OTH The Henry Levy Group       Oakland CA 94618 0 1942.45 0 1942.45      
2641 2641 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2016-08-01 2016-01-01 2016-06-30   PAY8763 OTH The Henry Levy Group       Oakland CA 94618 1423.35 0 1423.35 0      
2642 2642 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2016-08-01 2016-01-01 2016-06-30   PAY9574 OTH The Henry Levy Group       Oakland CA 94618 0 887.5 0 887.5      
1200 1200 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2016-01-24 2015-07-01 2015-12-31   PAY8763 OTH The Henry Levy Group       Oakland CA 94618 0 1423.35 0 1423.35      
1039 1039 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PAY5275 OTH The Henry Levy Group       Oakland CA 94618 993.5 0 993.5 0      
1101 1101 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2014-07-23 2014-01-01 2014-06-30   PAY5275 OTH The Henry Levy Group       Oakland CA 94618 0 993.5 0 993.5      
193 193 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2013-07-31 2013-01-01 2013-06-30   PAY1710 OTH The Henry Levy Group       Oakland CA 94618 2936.28 0 2936.28 0      
194 194 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2013-07-31 2013-01-01 2013-06-30   PAY1890 OTH The Henry Levy Group       Oakland CA 94618 1356.63 0 1356.63 0      
31 31 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2013-01-21 2012-10-21 2012-12-31   PAY1352 OTH Henry C. Levy & Company, CPAs       Oakland CA 94618 1789.45 0 1789.45 0      
32 32 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2013-01-21 2012-10-21 2012-12-31   PAY1710 OTH Henry C. Levy & Company, CPAs       Oakland CA 94618 0 2936.28 0 2936.28      
33 33 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2013-01-21 2012-10-21 2012-12-31   PAY1890 OTH Henry C. Levy & Company, CPAs       Oakland CA 94618 0 1356.63 0 1356.63      
70 70 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2012-10-25 2012-10-01 2012-10-20 2012-11-06 PAY1352 OTH Henry C. Levy & Company, CPAs       Oakland CA 94618 1789.45 0 0 1789.45      
110 110 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2012-10-03 2012-07-01 2012-09-30 2012-11-06 PAY1352 OTH Henry C. Levy & Company, CPAs       Oakland CA 94618 0 1789.45 0 1789.45      
145 145 1342695 17 East Bay Rental Housing Association PAC 17 RCP 2012-07-14 2012-01-01 2012-06-30   PAY512 OTH Henry C. Levy & Company, CPAs       Oakland CA 94618 1080.23 0 1080.23 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");