summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

433 rows where filer_id = 40 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, 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
37078 37078 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 76200 76200
37079 37079 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY -76200 0
37080 37080 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 76200
37081 37081 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37082 37082 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 76200
37083 37083 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37084 37084 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37085 37085 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37086 37086 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY -9500 0
37087 37087 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37088 37088 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY -9500 0
37089 37089 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37090 37090 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37091 37091 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37092 37092 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37093 37093 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37094 37094 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37095 37095 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37096 37096 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37097 37097 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 76200 0
37098 37098 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37099 37099 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 76200 0
37100 37100 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37101 37101 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 76200 0
37102 37102 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY -76200 0
37103 37103 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37104 37104 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37105 37105 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37106 37106 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37107 37107 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37108 37108 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37109 37109 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37110 37110 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37111 37111 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37112 37112 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37113 37113 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY -9500 0
37114 37114 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37115 37115 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY -9500 0
37116 37116 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37117 37117 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37118 37118 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37119 37119 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37120 37120 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37121 37121 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
37122 37122 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-08-01 2016-01-01 2016-06-30 2014-11-04 SMRY 0 0
21875 21875 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21876 21876 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 76200
21877 21877 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 76200
21878 21878 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21879 21879 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 76200
21880 21880 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 807.1 12027
21881 21881 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21882 21882 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 807.1 12027
21883 21883 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 9500
21884 21884 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21885 21885 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 807.1 21527
21886 21886 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 7.1 0
21887 21887 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21888 21888 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 800 0
21889 21889 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 807.1 0
21890 21890 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21891 21891 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21892 21892 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21893 21893 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 85700 0
21894 21894 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21895 21895 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21896 21896 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21897 21897 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21898 21898 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21899 21899 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21900 21900 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21901 21901 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21902 21902 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21903 21903 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21904 21904 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21905 21905 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21906 21906 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 800 0
21907 21907 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 7.1 0
21908 21908 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21909 21909 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 807.1 0
21910 21910 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21911 21911 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21912 21912 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21913 21913 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21914 21914 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21915 21915 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21916 21916 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 800 0
21917 21917 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21918 21918 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
21919 21919 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2016-01-29 2015-07-01 2015-12-31 2014-11-04 SMRY 800 0
23374 23374 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
23375 23375 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY 6200 76200
23376 23376 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY 6200 76200
23377 23377 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
23378 23378 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY 6200 76200
23379 23379 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY 11219.9 11219.9
23380 23380 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
23381 23381 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY 11219.9 11219.9
23382 23382 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 SMRY -20000 9500
23383 23383 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 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");