summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

180 rows where filer_name = 41 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, total_this_period, year_to_date, 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 record_type total_this_period year_to_date
28860 28860 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28861 28861 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28862 28862 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28863 28863 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28864 28864 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28865 28865 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 215 215
28866 28866 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28867 28867 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 215 215
28868 28868 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 150 225
28869 28869 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28870 28870 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 365 440
28871 28871 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 9371.75 0
28872 28872 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28873 28873 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28874 28874 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 215 0
28875 28875 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 9156.75 0
28876 28876 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28877 28877 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28878 28878 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 225 0
28879 28879 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28880 28880 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28881 28881 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28882 28882 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28883 28883 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28884 28884 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28885 28885 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28886 28886 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28887 28887 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28888 28888 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28889 28889 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28890 28890 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28891 28891 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 215 0
28892 28892 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28893 28893 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28894 28894 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 215 0
28895 28895 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 200 0
28896 28896 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 50 0
28897 28897 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 150 0
28898 28898 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28899 28899 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28900 28900 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28901 28901 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28902 28902 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28903 28903 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
28904 28904 1342882 48 Oakland First 41 RCP 2017-02-14 2016-01-01 2016-12-31   SMRY 0 0
11663 11663 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2500 2500
11664 11664 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11665 11665 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2500 2500
11666 11666 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11667 11667 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2500 2500
11668 11668 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2440 2440
11669 11669 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11670 11670 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2440 2440
11671 11671 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 75
11672 11672 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11673 11673 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2440 2515
11674 11674 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 9236.75 0
11675 11675 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2500 0
11676 11676 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11677 11677 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2440 0
11678 11678 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 9296.75 0
11679 11679 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11680 11680 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11681 11681 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 75 0
11682 11682 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2500 0
11683 11683 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11684 11684 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2500 0
11685 11685 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11686 11686 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11687 11687 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11688 11688 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11689 11689 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11690 11690 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11691 11691 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11692 11692 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11693 11693 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11694 11694 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2440 0
11695 11695 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11696 11696 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11697 11697 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 2440 0
11698 11698 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11699 11699 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11700 11700 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11701 11701 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11702 11702 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11703 11703 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11704 11704 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11705 11705 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11706 11706 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
11707 11707 1342882 48 Oakland First 41 RCP 2015-02-02 2014-07-01 2014-12-31   SMRY 0 0
3804 3804 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 0
3805 3805 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 0
3806 3806 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 0
3807 3807 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 0
3808 3808 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 0
3809 3809 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 200
3810 3810 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 0
3811 3811 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 200
3812 3812 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 0
3813 3813 1342882 48 Oakland First 41 RCP 2014-02-05 2013-07-01 2013-12-31   SMRY 0 0

Next page

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