on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

47 rows where filer_name = 78 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, expenditure_type, 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 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
279 279 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9SNED3 OTH Spotlight Design & Printing       San Francisco CA 94107-1014   967.88   CMP     Kaplan Rebecca     MAY City of Oakland              
280 280 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9SNDG4 OTH United States Postal Service       Oakland CA 94612-5598   343   POS     Kaplan Rebecca     MAY City of Oakland              
281 281 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9SQAC1 OTH The Twilight Zone       Oakland CA 94612-2205   535   OFC     Kaplan Rebecca     MAY City of Oakland              
282 282 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9SQAB3 OTH United States Postal Service       Oakland CA 94612-5598   196   POS     Kaplan Rebecca     MAY City of Oakland              
283 283 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNJ8 OTH Inkworks Press       Berkeley CA 94710-2702   218   FND     Kaplan Rebecca     MAY City of Oakland              
284 284 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNG2 OTH NGP VAN, Inc.       Washington DC 20005-5006   1450   WEB     Kaplan Rebecca     MAY City of Oakland              
285 285 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNH0 OTH Spotlight Design & Printing       San Francisco CA 94107-1014   706.88   CMP     Kaplan Rebecca     MAY City of Oakland              
286 286 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9SX6J9 OTH United States Postal Service       Oakland CA 94612-5598   369.88   POS     Kaplan Rebecca     MAY City of Oakland              
287 287 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN80D9TNAK3 OTH Level Two Restaurant       Oakland CA 94607-4019   349.11   FND     Kaplan Rebecca     MAY City of Oakland              
647 647 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TCZ30 OTH Comcast Spotlight       Castro Valley CA 94546-5931   11324.55   TEL     Kaplan Rebecca     MAY City of Oakland              
648 648 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TEKB3 OTH Facebook       Menlo Park CA 94025-1452   864.56   WEB     Kaplan Rebecca     MAY City of Oakland              
649 649 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TNB87 OTH Faz Restaurant       Oakland CA 94607-4139   673.62   FND     Kaplan Rebecca     MAY City of Oakland              
650 650 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TNAM1 OTH Level Two Restaurant       Oakland CA 94607-4019   227.35   FND     Kaplan Rebecca     MAY City of Oakland              
651 651 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TN7Q7 OTH Magnets On The Cheap       Austin TX 78758-3477   698.75   CMP     Kaplan Rebecca     MAY City of Oakland              
652 652 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TNA37 OTH Office Depot       Emeryville CA 94608-4149   119.87   OFC     Kaplan Rebecca     MAY City of Oakland              
653 653 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TNAD6 OTH Spoken Hub LLC       New York NY 10001-2809   500   PHO     Kaplan Rebecca     MAY City of Oakland              
654 654 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TN9Z5 OTH The Twilight Zone       Oakland CA 94612-2205   270   OFC     Kaplan Rebecca     MAY City of Oakland              
655 655 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TBNZ1 OTH United States Postal Service       Oakland CA 94612-5598   7339.5   POS     Kaplan Rebecca     MAY City of Oakland              
656 656 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TCHG2 OTH United States Postal Service       Oakland CA 94612-5598   10573.71   POS     Kaplan Rebecca     MAY City of Oakland              
657 657 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TCJB5 OTH United States Postal Service       Oakland CA 94612-5598   2052.81         Kaplan Rebecca     MAY City of Oakland              
658 658 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TCZ23 OTH United States Postal Service       Oakland CA 94612-5598   4.9   POS     Kaplan Rebecca     MAY City of Oakland              
659 659 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TNAV5 OTH United States Postal Service       Oakland CA 94612-5598   490   POS     Kaplan Rebecca     MAY City of Oakland              
660 660 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-12-31 2014-10-19 2014-12-31   VN80D9TNAG0 OTH United States Postal Service       Oakland CA 94612-5598   225.4   POS     Kaplan Rebecca     MAY City of Oakland              
288 288 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN80D9SNED3 OTH Spotlight Design & Printing       San Francisco CA 94107-1014   967.88   CMP     Kaplan Rebecca     MAY City of Oakland              
289 289 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN80D9SNDG4 OTH United States Postal Service       Oakland CA 94612-5598   343   POS     Kaplan Rebecca     MAY City of Oakland              
290 290 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN80D9SQAC1 OTH The Twilight Zone       Oakland CA 94612-2205   535   OFC     Kaplan Rebecca     MAY City of Oakland              
291 291 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN80D9SQAB3 OTH United States Postal Service       Oakland CA 94612-5598   196   POS     Kaplan Rebecca     MAY City of Oakland              
292 292 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNJ8 OTH Inkworks Press       Berkeley CA 94710-2702   218   FND     Kaplan Rebecca     MAY City of Oakland              
293 293 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNG2 OTH NGP VAN, Inc.       Washington DC 20005-5006   1450   WEB     Kaplan Rebecca     MAY City of Oakland              
294 294 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNH0 OTH Spotlight Design & Printing       San Francisco CA 94107-1014   706.88   CMP     Kaplan Rebecca     MAY City of Oakland              
688 688 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T34W0 OTH Comcast Spotlight       Castro Valley CA 94546-5931   2000   TEL     Kaplan Rebecca     MAY City of Oakland              
689 689 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T2E01 OTH Office Depot       Emeryville CA 94608-4149   213.62   OFC     Kaplan Rebecca     MAY City of Oakland              
690 690 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T2D74 OTH United States Postal Service       Oakland CA 94612-5598   196   POS     Kaplan Rebecca     MAY City of Oakland              
691 691 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T7DZ4 OTH United States Postal Service       Oakland CA 94612-5598   10140.24   POS     Kaplan Rebecca     MAY City of Oakland              
692 692 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T2D66 OTH The Twilight Zone       Oakland CA 94612-2205   271   OFC     Kaplan Rebecca     MAY City of Oakland              
693 693 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T34Y6 OTH Facebook       Menlo Park CA 94025-1452   725.56   WEB     Kaplan Rebecca     MAY City of Oakland              
694 694 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T2D58 OTH Office Depot       Emeryville CA 94608-4149   789.19   OFC     Kaplan Rebecca     MAY City of Oakland              
695 695 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T34X8 OTH Aequus Resources       Oakland CA 94611-5816   2000   CNS     Kaplan Rebecca     MAY City of Oakland              
696 696 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T2E19 OTH The Twilight Zone       Oakland CA 94612-2205   272   OFC     Kaplan Rebecca     MAY City of Oakland              
697 697 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-23 2014-10-01 2014-10-18 2014-11-04 VN80D9T1CR9 OTH United States Postal Service       Oakland CA 94612-5598   13954.82   POS     Kaplan Rebecca     MAY City of Oakland              
758 758 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN80D9SNED3 OTH Spotlight Design & Printing       San Francisco CA 94107-1014   967.88   CMP     Kaplan Rebecca     MAY City of Oakland              
759 759 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN80D9SNDG4 OTH United States Postal Service       Oakland CA 94612-5598   343   POS     Kaplan Rebecca     MAY City of Oakland              
760 760 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN80D9SQAC1 OTH The Twilight Zone       Oakland CA 94612-2205   535   OFC     Kaplan Rebecca     MAY City of Oakland              
761 761 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN80D9SQAB3 OTH United States Postal Service       Oakland CA 94612-5598   196   POS     Kaplan Rebecca     MAY City of Oakland              
762 762 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNJ8 OTH Inkworks Press       Berkeley CA 94710-2702   218   FND     Kaplan Rebecca     MAY City of Oakland              
763 763 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNG2 OTH NGP VAN, Inc.       Washington DC 20005-5006   1450   WEB     Kaplan Rebecca     MAY City of Oakland              
764 764 1367270 80 Kaplan for Oakland Mayor 2014 78 CAO 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN80D9SSNH0 OTH Spotlight Design & Printing       San Francisco CA 94107-1014   706.88   CMP     Kaplan Rebecca     MAY City of Oakland              

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