accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

60 rows where filer_id = 34 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, committee_type, report_date, report_start_date, report_end_date, transaction_id, entity_type, payee_last_name, payee_first_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), 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
4192 4192 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2019-01-14 2019-01-01 2019-01-20   VNF249HE7E0 IND Nosakhare Shereda     Oakland CA 94605-5003 58 0 58 0      
3270 3270 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2019-01-12 2018-10-21 2018-12-31   VNF249HDX34 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 809.5 0 809.5 0      
3271 3271 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2019-01-12 2018-10-21 2018-12-31   VNF249HDX42 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 4.2 0 4.2 0      
3272 3272 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2019-01-12 2018-10-21 2018-12-31   VNF249HE0P9 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 1261.94 0 1261.94 0      
3273 3273 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2019-01-12 2018-10-21 2018-12-31   VNF249HE0Q7 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 23.69 0 23.69 0      
3274 3274 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2019-01-12 2018-10-21 2018-12-31   VNF249HE2P3 IND Nosakhare Shereda     Oakland CA 94605-5003 58 0 58 0      
3275 3275 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2019-01-12 2018-10-21 2018-12-31   VNF249HE7E0 IND Nosakhare Shereda     Oakland CA 94605-5003 0 58 0 58      
3493 3493 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-10-22 2018-09-23 2018-10-20 2018-11-06 VNF249HDX34 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 809.5 0 0 809.5      
3494 3494 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-10-22 2018-09-23 2018-10-20 2018-11-06 VNF249HDX42 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 4.2 0 0 4.2      
3495 3495 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-10-22 2018-09-23 2018-10-20 2018-11-06 VNF249HE0P9 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 1261.94 0 0 1261.94      
3496 3496 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-10-22 2018-09-23 2018-10-20 2018-11-06 VNF249HE0Q7 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 23.69 0 0 23.69      
3651 3651 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-09-27 2018-07-01 2018-09-22 2018-11-06 VNF249HDX34 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 809.5 0 0 809.5      
3652 3652 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-09-27 2018-07-01 2018-09-22 2018-11-06 VNF249HDX42 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 4.2 0 0 4.2      
3653 3653 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-09-27 2018-07-01 2018-09-22 2018-11-06 VNF249HE0P9 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 1261.94 0 1261.94      
3654 3654 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-09-27 2018-07-01 2018-09-22 2018-11-06 VNF249HE0Q7 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 23.69 0 23.69      
3856 3856 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-07-22 2018-01-01 2018-06-30   VNF249HDC78 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 606 0 606 0      
3857 3857 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-07-22 2018-01-01 2018-06-30   VNF249HDC86 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0.1 0 0.1 0      
3858 3858 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-07-22 2018-01-01 2018-06-30   VNF249HDC93 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 164 0 164 0      
3859 3859 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-07-22 2018-01-01 2018-06-30   VNF249HDCA1 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0.4 0 0.4 0      
3860 3860 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-07-22 2018-01-01 2018-06-30   VNF249HDCB9 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 403 0 403 0      
3861 3861 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-07-22 2018-01-01 2018-06-30   VNF249HDCC7 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 1.1 0 1.1 0      
3862 3862 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-07-22 2018-01-01 2018-06-30   VNF249HDX34 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 809.5 0 809.5      
3863 3863 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-07-22 2018-01-01 2018-06-30   VNF249HDX42 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 4.2 0 4.2      
2803 2803 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-01-11 2017-07-01 2017-12-31   VNF249HD556 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 479 0 479 0      
2804 2804 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-01-11 2017-07-01 2017-12-31   VNF249HD564 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 3 0 3 0      
2805 2805 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-01-11 2017-07-01 2017-12-31   VNF249HDC78 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 606 0 606      
2806 2806 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-01-11 2017-07-01 2017-12-31   VNF249HDC86 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 0.1 0 0.1      
2807 2807 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-01-11 2017-07-01 2017-12-31   VNF249HDC93 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 164 0 164      
2808 2808 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-01-11 2017-07-01 2017-12-31   VNF249HDCA1 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 0.4 0 0.4      
2809 2809 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-01-11 2017-07-01 2017-12-31   VNF249HDCB9 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 403 0 403      
2810 2810 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2018-01-11 2017-07-01 2017-12-31   VNF249HDCC7 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 1.1 0 1.1      
2900 2900 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-07-31 2017-01-01 2017-06-30   VNF249HCQF7 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 393.5 0 393.5 0      
2901 2901 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-07-31 2017-01-01 2017-06-30   VNF249HCQG5 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 3.76 0 3.76 0      
2902 2902 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-07-31 2017-01-01 2017-06-30   VNF249HD556 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 479 0 479      
2903 2903 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-07-31 2017-01-01 2017-06-30   VNF249HD564 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 3 0 3      
2904 2904 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-07-31 2017-01-01 2017-06-30   VNF249HC998 OTH NGP Van       Washington DC 20005-5006 33.34 0 33.34 0      
2905 2905 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-07-31 2017-01-01 2017-06-30   VNF249HC9A6 OTH NGP Van       Washington DC 20005-5006 350 0 350 0      
2906 2906 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-07-31 2017-01-01 2017-06-30   VNF249HC9B4 OTH NGP Van       Washington DC 20005-5006 0.5 0 0.5 0      
2073 2073 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-01-31 2016-07-01 2016-12-31   VNF249HC8X4 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 1921 0 1921 0      
2074 2074 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-01-31 2016-07-01 2016-12-31   VNF249HC8Y2 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 33.2 0 33.2 0      
2075 2075 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-01-31 2016-07-01 2016-12-31   VNF249HCQF7 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 393.5 0 393.5      
2076 2076 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-01-31 2016-07-01 2016-12-31   VNF249HCQG5 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 3.76 0 3.76      
2077 2077 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-01-31 2016-07-01 2016-12-31   VNF249HC998 OTH NGP Van       Washington DC 20005-5006 33.34 0 0 33.34      
2078 2078 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-01-31 2016-07-01 2016-12-31   VNF249HC9A6 OTH NGP Van       Washington DC 20005-5006 350 0 0 350      
2079 2079 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2017-01-31 2016-07-01 2016-12-31   VNF249HC9B4 OTH NGP Van       Washington DC 20005-5006 0.5 0 0 0.5      
2702 2702 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2016-07-26 2016-01-01 2016-06-30   VNF249HC8X4 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 1921 0 1921      
2703 2703 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2016-07-26 2016-01-01 2016-06-30   VNF249HC8Y2 OTH Kaufman Legal Group       Los Angeles CA 90017-5864 0 33.2 0 33.2      
2704 2704 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2016-07-26 2016-01-01 2016-06-30   VNF249HC998 OTH NGP Van       Washington DC 20005-5006 0 33.34 0 33.34      
2705 2705 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2016-07-26 2016-01-01 2016-06-30   VNF249HC9A6 OTH NGP Van       Washington DC 20005-5006 0 350 0 350      
2706 2706 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CAO 2016-07-26 2016-01-01 2016-06-30   VNF249HC9B4 OTH NGP Van       Washington DC 20005-5006 0 0.5 0 0.5      
1162 1162 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CTL 2016-01-29 2015-07-01 2015-12-31   PAY50 OTH The Henry Levy Group       Oakland CA 94618 916.35 0 916.35 0      
1163 1163 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CTL 2016-01-29 2015-07-01 2015-12-31   PAY68 IND Ruhland Lisa     Oakland CA 94619 272.06 0 272.06 0      
1267 1267 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CTL 2015-07-28 2015-01-01 2015-06-30   PAY50 OTH The Henry Levy Group       Oakland CA 94618 0 916.35 0 916.35      
1268 1268 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CTL 2015-07-28 2015-01-01 2015-06-30   PAY67 OTH The Henry Levy Group       Oakland CA 94618 0 28.02 0 28.02      
1269 1269 1362261 34 Mayor Libby Schaaf 2014 Officeholder Committee 119 CTL 2015-07-28 2015-01-01 2015-06-30   PAY68 IND Ruhland Lisa     Oakland CA 94619 0 272.06 0 272.06      
241 241 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 CTL 2014-07-29 2014-01-01 2014-06-30   VNF249H82C4 IND Berley Steve     Oakland CA 94602-1856 130 0 130 0 PO Box fee (reimbursement spanning reporting periods)    
1092 1092 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 CTL 2014-07-29 2014-01-01 2014-06-30   VNF249H82C4 IND Berley Steve     Oakland CA 94602-1856 130 0 130 0 PO Box fee (reimbursement spanning reporting periods)    
146 146 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 CTL 2014-02-19 2013-07-01 2013-12-31   VNF249H82C4 IND Berley Steve     Oakland CA 94602-1856 0 130 0 130 PO Box fee (reimbursement spanning reporting periods)    
147 147 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 CTL 2014-02-19 2013-07-01 2013-12-31   VNF249H82C4 IND Berley Steve     Oakland CA 94602-1856 0 130 0 130 PO Box fee (reimbursement spanning reporting periods)    
173 173 1362261 34 Libby Schaaf for Oakland Mayor 2014 28 CTL 2014-01-28 2013-07-01 2013-12-31   VNF249H82C4 IND Berley Steve     Oakland CA 94602-1856 0 130 0 130 PO Box fee (reimbursement spanning reporting periods)    

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