accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

51 rows where filer_id = 6 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, entity_type, payee_last_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
179 179 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-08-02 2013-01-01 2013-06-30   l95eV3zW6aQj OTH The Next Generation       Oakland CA 94612 507.43 0 507.43 0 Expense reimbursement    
180 180 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-08-02 2013-01-01 2013-06-30   pgucodhfYjy5 OTH The Next Generation       Oakland CA 94612 2567.81 0 2567.81 0      
181 181 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-08-02 2013-01-01 2013-06-30   qmvP2jCKxGZW OTH The Next Generation       Oakland CA 94612 3000 0 3000 0      
35 35 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   l95eV3zW6aQj OTH The Next Generation       Oakland CA 94612 0 507.43 0 507.43 Expense reimbursement    
36 36 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   pgucodhfYjy5 OTH The Next Generation       Oakland CA 94612 0 2567.81 0 2567.81      
37 37 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   qmvP2jCKxGZW OTH The Next Generation       Oakland CA 94612 0 3000 0 3000      
38 38 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   BDhPgagQRS33 OTH Sears Credit Cards       Columbus OH 43228 149 0 149 0      
39 39 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   nvwuHO6ySufs OTH Sears Credit Cards       Columbus OH 43228 38 0 38 0 Expense reimbursement    
40 40 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   tyStbptbKzZS OTH Sears Credit Cards       Columbus OH 43228 38 0 38 0 Expense reimbursement    
41 41 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   Yf3uDVr6ymhi OTH The Next Generation       Oakland CA 94612 4000 0 4000 0      
42 42 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   Cl8dhHP6EugP OTH The Next Generation       Oakland CA 94612 100 0 100 0 Expense reimbursement    
43 43 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   wTDed3eyglHG OTH The Next Generation       Oakland CA 94612 4397 0 4397 0 Expense reimbursement    
44 44 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   RZnbC8GrJPOM OTH California Latino Voters Guide       Los Angeles CA 90041 250 0 250 0      
45 45 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   jVTGpdtHSCfg OTH Laurie J. Earp       Oakland CA 94602 36.1 0 36.1 0 Expense reimbursement    
46 46 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   q2EVphuWiz89 OTH Laurie J. Earp       Oakland CA 94602 34 0 34 0 Expense reimbursement    
47 47 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   eEQHCiZP9WzC OTH Laurie J. Earp       Oakland CA 94602 1500 0 1500 0      
71 71 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12261007 IND Bolotina Olga     Oakland CA 94618 44.37 0 44.37 0 Expense reimbursement    
72 72 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12532234 OTH California Latino Voters Guide       Los Angeles CA 90041 0 250 0 250      
73 73 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12534586 OTH Laurie J. Earp       Oakland CA 94602 0 36.1 0 36.1 Expense reimbursement    
74 74 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12534614 OTH Laurie J. Earp       Oakland CA 94602 0 34 0 34 Expense reimbursement    
75 75 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12534667 OTH Laurie J. Earp       Oakland CA 94602 0 1500 0 1500      
76 76 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12260039 OTH Pacific Print Resources       Emeryville CA 94608 2264.78 0 2264.78 0      
77 77 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12260366 OTH Sears Credit Cards       Columbus OH 43228 149 0 0 149      
78 78 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12260458 OTH Sears Credit Cards       Columbus OH 43228 38 0 0 38 Expense reimbursement    
79 79 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12260538 OTH Sears Credit Cards       Columbus OH 43228 38 0 0 38 Expense reimbursement    
80 80 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12260099 OTH The Next Generation       Oakland CA 94612 35 0 35 0 Expense reimbursement    
81 81 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12260195 OTH The Next Generation       Oakland CA 94612 10 0 10 0 Expense reimbursement    
82 82 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12530672 OTH The Next Generation       Oakland CA 94612 0 4000 0 4000      
83 83 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12530777 OTH The Next Generation       Oakland CA 94612 0 100 0 100 Expense reimbursement    
84 84 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12531561 OTH The Next Generation       Oakland CA 94612 0 4397 0 4397 Expense reimbursement    
85 85 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12260024 OTH WorldWide Communications       Emeryville CA 94608 500 0 500 0      
88 88 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12261007 IND Bolotina Olga     Oakland CA 94618 0 44.37 0 44.37 Expense reimbursement    
89 89 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260039 OTH Pacific Print Resources       Emeryville CA 94608 0 2264.78 0 2264.78      
90 90 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   11857070 OTH Sears Credit Cards       Columbus OH 43228 42.25 0 42.25 0      
91 91 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   11857725 OTH Sears Credit Cards       Columbus OH 43228 11 0 11 0      
92 92 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   11867839 OTH Sears Credit Cards       Columbus OH 43228 38 0 38 0      
93 93 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   11869233 OTH Sears Credit Cards       Columbus OH 43228 90.8 0 90.8 0      
94 94 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   11873016 OTH Sears Credit Cards       Columbus OH 43228 25.77 0 25.77 0      
95 95 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   11873144 OTH Sears Credit Cards       Columbus OH 43228 27.97 0 27.97 0      
96 96 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260366 OTH Sears Credit Cards       Columbus OH 43228 0 149 0 149      
97 97 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260458 OTH Sears Credit Cards       Columbus OH 43228 0 38 0 38 Expense reimbursement    
98 98 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260538 OTH Sears Credit Cards       Columbus OH 43228 0 38 0 38 Expense reimbursement    
99 99 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260099 OTH The Next Generation       Oakland CA 94612 0 35 0 35 Expense reimbursement    
100 100 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260195 OTH The Next Generation       Oakland CA 94612 0 10 0 10 Expense reimbursement    
101 101 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260024 OTH WorldWide Communications       Emeryville CA 94608 0 500 0 500      
112 112 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11857070 OTH Sears Credit Cards       Columbus OH 43228 0 42.25 0 42.25      
113 113 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11857725 OTH Sears Credit Cards       Columbus OH 43228 0 11 0 11      
114 114 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11867839 OTH Sears Credit Cards       Columbus OH 43228 0 38 0 38      
115 115 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11869233 OTH Sears Credit Cards       Columbus OH 43228 0 90.8 0 90.8      
116 116 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11873016 OTH Sears Credit Cards       Columbus OH 43228 0 25.77 0 25.77      
117 117 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11873144 OTH Sears Credit Cards       Columbus OH 43228 0 27.97 0 27.97      

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