on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

53 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, payee_last_name, payee_city, payee_state, payee_zipcode, year_to_date, expenditure_type, expenditure_description, office_sought, report_date (date), report_start_date (date), report_end_date (date), election_date (date), expenditure_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 expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description committee_id candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number incumbent ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose memo_reference_number
78 78 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-08-02 2013-01-01 2013-06-30   YJvxzb7G26Kb OTH Whole Foods Market       Oakland CA 94612 2013-06-18 568.98 568.98 FND     Kalb Dan     OTH City of Oakland 1.0         S  
14 14 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   9wyIeg6cvbRl OTH US Postal Service       San Francisco CA 94118 2012-11-07 90 9868.98 POS     Kalb Dan     OTH City of Oakland 1.0         S  
15 15 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   XzrLLjpN9g69 OTH US Postal Service       San Francisco CA 94118 2012-10-31 2912.39 9868.98 POS     Kalb Dan     OTH City of Oakland 1.0         S  
16 16 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   vYU5tZO6HD6u OTH US Postal Service       San Francisco CA 94118 2012-10-31 4059.96 9868.98 POS     Kalb Dan     OTH City of Oakland 1.0         S  
17 17 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   tIbnDUd55M4z OTH US Postal Service       San Francisco CA 94118 2012-10-31 280.02 9868.98 POS     Kalb Dan     OTH City of Oakland 1.0         S  
18 18 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   yEddKsaeyjiJ OTH US Postal Service       San Francisco CA 94118 2012-11-08 1493.5 9868.98 POS     Kalb Dan     OTH City of Oakland 1.0         S  
19 19 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   Z5CYVGFI5Nep OTH US Postal Service       San Francisco CA 94118 2012-11-08 945.11 9868.98 POS     Kalb Dan     OTH City of Oakland 1.0         S  
20 20 1343715 6 Dan Kalb for City Council 2012 6 CTL 2013-01-30 2012-10-21 2012-12-31   IVPqldcHYW1w OTH Gravis Marketing Inc       Winter Springs FL 32708 2012-11-20 507.43 507.43 PHO     Kalb Dan     OTH City of Oakland 1.0         S  
23 23 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12529953 OTH Vasai Produce Market       Oakland CA 94618 2012-10-10 44.37   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
24 24 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12530036 OTH CallFire       Santa Monica CA 90401 2012-10-11 10   PHO Online minutes   Kalb Dan     CCM City of Oakland 1.0         S  
25 25 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12530075 OTH Alameda County Registrar of Voters       Oakland CA 94612 2012-10-11 35   OTH Precinct maps   Kalb Dan     CCM City of Oakland 1.0         S  
26 26 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12530847 OTH CallFire       Santa Monica CA 90401 2012-10-04 100   PHO Online phone minutes   Kalb Dan     CCM City of Oakland 1.0         S  
27 27 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12531747 OTH Stargate Design & Printing       Herrin IL 62948 2012-10-10 4397   CMP Printed campaign sponge   Kalb Dan     CCM City of Oakland 1.0         S  
28 28 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12534591 OTH Semifreddi's Bakery       Alameda CA 94502 2012-10-14 36.1   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
29 29 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 12534629 OTH Peet's Coffee & Tea       Oakland CA 94611 2012-10-14 34   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
32 32 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12197332 OTH US Postal Service       Oakland CA 94609 2012-07-09 77.4   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
33 33 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12197716 OTH Target       Emeryville CA 94608 2012-07-31 22.56   FND Fundraising event   Kalb Dan     CCM City of Oakland 1.0         S  
34 34 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12197887 OTH FedEx Office       Emeryville CA 94608 2012-07-31 72.04   FND Fundraising event   Kalb Dan     CCM City of Oakland 1.0         S  
35 35 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12197941 OTH The Home Depot       Emeryville CA 94608 2012-07-31 15.27   FND Fundraising event   Kalb Dan     CCM City of Oakland 1.0         S  
36 36 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12199193 OTH NationBuilder       Los Angeles CA 90013 2012-08-23 38   WEB Online contact service   Kalb Dan     CCM City of Oakland 1.0         S  
37 37 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12199209 OTH US Postal Service       Oakland CA 94609 2012-08-23 225   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
38 38 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12199560 OTH Party Warehouse Oakland       Oakland CA 94607 2012-08-30 23.81   FND Decorations for fundraising event   Kalb Dan     CCM City of Oakland 1.0         S  
39 39 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12207306 OTH Oakland Grocery Outlet       Oakland CA 94611 2012-09-23 41.59   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
40 40 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12259013 OTH US Postal Service       Oakland CA 94609 2012-09-27 313.31   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
41 41 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12259420 OTH La Borinquena, Inc.       Oakland CA 94607 2012-09-23 133.39   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
42 42 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12259445 OTH Ladyfingers       Oakland CA 94610 2012-09-23 84   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
43 43 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12259470 OTH Rockridge District Association       Oakland CA 94618 2012-09-23 165   CVC Festival booth fee   Kalb Dan     CCM City of Oakland 1.0         S  
44 44 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12259486 OTH City of Oakland Franklin Plaza Garage       Oakland CA 94612 2012-09-23 12   TRC Parking   Kalb Dan     CCM City of Oakland 1.0         S  
45 45 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12259752 OTH Alameda County Registrar of Voters       Oakland CA 94612 2012-08-30 35   OTH District map   Kalb Dan     CCM City of Oakland 1.0         S  
46 46 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12263771 OTH Alameda County Democratic Party       Hayward CA 94540 2012-09-23 50   LIT Slating fee   Kalb Dan     CCM City of Oakland 1.0         S  
47 47 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260127 OTH Alameda County Registrar of Voters       Oakland CA 94612 2012-07-13 35   OTH Precinct maps   Kalb Dan     CCM City of Oakland 1.0         S  
48 48 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260228 OTH CallFire       Santa Monica CA 90401 2012-08-15 10   PHO Online minutes   Kalb Dan     CCM City of Oakland 1.0         S  
49 49 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260391 OTH J. The Jewish Weekly of Northern California       San Francisco CA 94104 2012-09-12 149   PRT Paid advertisement   Kalb Dan     CCM City of Oakland 1.0         S  
50 50 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260502 OTH NationBuilder       Los Angeles CA 90013 2012-09-18 38   WEB Online contact service   Kalb Dan     CCM City of Oakland 1.0         S  
51 51 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12260583 OTH NationBuilder       Los Angeles CA 90013 2012-09-22 38   WEB Online contact service   Kalb Dan     CCM City of Oakland 1.0         S  
52 52 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-10-05 2012-07-01 2012-09-30   12261066 OTH Vasai Produce Market       Oakland CA 94618 2012-09-30 44.37   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
59 59 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11821860 OTH Kelly Paper       San Francisco CA 94103 2012-04-03 26.58   LIT Envelopes   Kalb Dan     CCM City of Oakland 1.0         S  
60 60 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11821969 OTH US Postal Service       San Francisco CA 94118 2012-04-03 88   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
61 61 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11822248 OTH Party Warehouse Oakland       Oakland CA 94607 2012-06-29 31.17   FND Event decoration   Kalb Dan     CCM City of Oakland 1.0         S  
62 62 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11822265 OTH US Postal Service       Oakland CA 94609 2012-06-29 97.2   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
63 63 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11828544 OTH US Postal Service       Berkeley CA 94704 2012-02-28 90   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
64 64 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11828568 OTH Staples       Berkeley CA 94704 2012-04-03 13.05   LIT Mailing supplies   Kalb Dan     CCM City of Oakland 1.0         S  
65 65 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11828649 OTH Office Max       Emeryville CA 94608 2012-05-04 38.05   LIT Mailing supplies   Kalb Dan     CCM City of Oakland 1.0         S  
66 66 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11828754 OTH US Postal Service       Berkeley CA 94704 2012-05-23 207   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
67 67 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11828911 OTH Temescal Telegraph Business Improvement District       Oakland CA 94609 2012-05-23 93   LIT Booth at street fair   Kalb Dan     CCM City of Oakland 1.0         S  
68 68 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11828984 OTH US Postal Service       Oakland CA 94609 2012-06-28 45   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
69 69 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11829024 OTH NationBuilder       Los Angeles CA 90013 2012-06-28 33   WEB Database service   Kalb Dan     CCM City of Oakland 1.0         S  
70 70 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11857319 OTH US Postal Service       Oakland CA 94609 2012-06-13 42.25   POS Postage   Kalb Dan     CCM City of Oakland 1.0         S  
71 71 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11857856 OTH City of Sacramento Parking Services       Sacramento CA 95814 2012-06-19 11   TRC Parking   Kalb Dan     CCM City of Oakland 1.0         S  
72 72 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11868506 OTH NationBuilder       Los Angeles CA 90013 2012-06-23 38   WEB Database service   Kalb Dan     CCM City of Oakland 1.0         S  
73 73 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11870188 OTH Oakland Grocery Outlet       Oakland CA 94611 2012-06-23 90.8   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
74 74 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11873107 OTH Safeway       Oakland CA 94611 2012-06-27 25.77   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  
75 75 1343715 6 Dan Kalb for City Council 2012 6 CTL 2012-07-31 2012-01-01 2012-06-30   11873149 OTH Oakland Grocery Outlet       Oakland CA 94611 2012-06-27 27.97   FND Refreshments for event   Kalb Dan     CCM City of Oakland 1.0         S  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "on_behalf_of_expenditures" (
"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" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "committee_id" INTEGER,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT,
  "incumbent" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "memo_reference_number" TEXT
,
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 ["on_behalf_of_expenditures_filer_id"] ON [on_behalf_of_expenditures]("filer_id");
CREATE INDEX ["on_behalf_of_expenditures_filer_name"] ON [on_behalf_of_expenditures]("filer_name");
CREATE INDEX ["on_behalf_of_expenditures_committee_id"] ON [on_behalf_of_expenditures]("committee_id");