summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

112 rows where filer_id = 5 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, 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
1046 1046 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 38725 49152
1047 1047 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY -24900 0
1048 1048 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 13825 49152
1049 1049 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 3963.96
1050 1050 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 13825 53115.96
1051 1051 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 22516.52 49152.19
1052 1052 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1053 1053 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 22516.52 49152.19
1054 1054 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY -2984.94 0
1055 1055 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 3963.96
1056 1056 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 19531.58 53116.15
1057 1057 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 8691.52 0
1058 1058 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 13825 0
1059 1059 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1060 1060 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 22516.52 0
1061 1061 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1062 1062 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1063 1063 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1064 1064 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1065 1065 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 38700 0
1066 1066 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 25 0
1067 1067 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 38725 0
1068 1068 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 22380.34 0
1069 1069 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 136.18 0
1070 1070 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1071 1071 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 22516.52 0
1072 1072 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY -543.75 0
1073 1073 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 2441.19 0
1074 1074 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY -2984.94 0
1075 1075 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 12900 0
1076 1076 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 37800 0
1077 1077 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY -24900 0
1078 1078 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1079 1079 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1080 1080 1350016 5 Len Raphael for City Council 2012 5 CTL 2013-01-31 2012-10-21 2012-12-31 2012-11-06 SMRY 0 0
1741 1741 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 5525 10427
1742 1742 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 7500 24900
1743 1743 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 13025 35327
1744 1744 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 3963.96
1745 1745 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 13025 39290.96
1746 1746 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 8298.35 26635.67
1747 1747 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 0
1748 1748 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 8298.35 26635.67
1749 1749 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 2093.19 2984.94
1750 1750 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 3963.96
1751 1751 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 10391.54 33584.57
1752 1752 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 3964.87 0
1753 1753 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 13025 0
1754 1754 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 0
1755 1755 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 8298.35 0
1756 1756 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 8691.52 0
1757 1757 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 0
1758 1758 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 0
1759 1759 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 27884.94 0
1760 1760 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 5450 0
1761 1761 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 75 0
1762 1762 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 5525 0
1763 1763 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 8263.35 0
1764 1764 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 35 0
1765 1765 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 0
1766 1766 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 8298.35 0
1767 1767 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 2984.94 0
1768 1768 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 891.75 0
1769 1769 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 2093.19 0
1770 1770 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 11500 0
1771 1771 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 4000 0
1772 1772 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 7500 0
1773 1773 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 0
1774 1774 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 0
1775 1775 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-25 2012-10-01 2012-10-20 2012-11-06 SMRY 0 0
2077 2077 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 4902 4902
2078 2078 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 17400 17400
2079 2079 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 22302 22302
2080 2080 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 3963.96 3963.96
2081 2081 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 26265.96 26265.96
2082 2082 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 18337.32 18337.32
2083 2083 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0 0
2084 2084 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 18337.32 18337.32
2085 2085 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 891.75 891.75
2086 2086 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 3963.96 3963.96
2087 2087 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 23193.03 23193.03
2088 2088 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0 0
2089 2089 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 22302 0
2090 2090 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0.19 0
2091 2091 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 18337.32 0
2092 2092 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 3964.87 0
2093 2093 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0 0
2094 2094 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0 0
2095 2095 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 18291.75 0
2096 2096 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 4551 0
2097 2097 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 351 0
2098 2098 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 4902 0
2099 2099 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 3963.96 0
2100 2100 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0 0
2101 2101 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 3963.96 0
2102 2102 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0 0
2103 2103 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0.19 0
2104 2104 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0 0
2105 2105 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 0.19 0
2106 2106 1350016 5 Len Raphael for City Council 2012 5 CTL 2012-10-03 2012-01-01 2012-09-30 2012-11-06 SMRY 18223.23 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");