summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

47 rows where filer_name = 84 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
17852 17852 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 1225.7
17853 17853 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17854 17854 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 1225.7
17855 17855 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 32078.1 32078.1
17856 17856 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 33303.8 33303.8
17857 17857 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 1225.7
17858 17858 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17859 17859 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 1225.7
17860 17860 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17861 17861 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 32078.1 32078.1
17862 17862 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 33303.8 33303.8
17863 17863 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17864 17864 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 0
17865 17865 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17866 17866 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 0
17867 17867 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17868 17868 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17869 17869 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17870 17870 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17871 17871 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17872 17872 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17873 17873 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 422.5 0
17874 17874 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 803.2 0
17875 17875 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 0
17876 17876 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17877 17877 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17878 17878 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17879 17879 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 32078.1 0
17880 17880 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17881 17881 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 32078.1 0
17882 17882 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 0
17883 17883 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17884 17884 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 0
17885 17885 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 0
17886 17886 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17887 17887 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17888 17888 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 1225.7 0
17889 17889 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17890 17890 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17891 17891 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17892 17892 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17893 17893 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17894 17894 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17895 17895 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17896 17896 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17897 17897 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-06-30   SMRY 0 0
17898 17898 1367792 69 East Bay Alliance for a Sustainable Economy Committee to Lift Up Oakland 84 BMC 2014-07-31 2014-01-01 2014-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");