summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

45 rows where filer_name = 169 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: total_this_period, year_to_date, report_date (date), report_start_date (date), report_end_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date record_type total_this_period year_to_date
36804 36804 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 600000 600000
36805 36805 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36806 36806 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 600000 600000
36807 36807 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36808 36808 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 600000 600000
36809 36809 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 593709.77 593709.77
36810 36810 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36811 36811 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 593709.77 593709.77
36812 36812 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 153557.74 153557.74
36813 36813 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36814 36814 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 747267.51 747267.51
36815 36815 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36816 36816 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 600000 0
36817 36817 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36818 36818 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 593709.77 0
36819 36819 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 6290.23 0
36820 36820 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36821 36821 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36822 36822 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 153557.74 0
36823 36823 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 600000 0
36824 36824 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36825 36825 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 600000 0
36826 36826 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36827 36827 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36828 36828 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36829 36829 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36830 36830 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36831 36831 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36832 36832 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36833 36833 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36834 36834 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36835 36835 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 593709.77 0
36836 36836 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36837 36837 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36838 36838 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 593709.77 0
36839 36839 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 153557.74 0
36840 36840 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36841 36841 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 153557.74 0
36842 36842 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36843 36843 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36844 36844 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36845 36845 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36846 36846 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36847 36847 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0
36848 36848 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 BMC 2016-08-01 2016-01-01 2016-06-30   SMRY 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "summaries" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "committee_type" TEXT,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "record_type" TEXT,
  "total_this_period" INTEGER,
  "year_to_date" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id));
CREATE INDEX ["summaries_filer_id"] ON [summaries]("filer_id");
CREATE INDEX ["summaries_filer_name"] ON [summaries]("filer_name");