summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

45 rows where filer_name = 27 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
3034 3034 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3035 3035 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3036 3036 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3037 3037 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3038 3038 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3039 3039 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3040 3040 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3041 3041 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3042 3042 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3043 3043 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3044 3044 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3045 3045 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3046 3046 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3047 3047 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3048 3048 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3049 3049 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3050 3050 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3051 3051 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3052 3052 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3053 3053 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3054 3054 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3055 3055 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3056 3056 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3057 3057 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3058 3058 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3059 3059 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3060 3060 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3061 3061 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3062 3062 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3063 3063 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3064 3064 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3065 3065 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3066 3066 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3067 3067 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3068 3068 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3069 3069 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3070 3070 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3071 3071 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3072 3072 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3073 3073 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3074 3074 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3075 3075 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3076 3076 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3077 3077 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 SMRY 0 0
3078 3078 Pending 20 James Harris for Oakland School Board 2012 27 CTL 2012-03-22 2012-01-01 2012-03-17 2012-11-06 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");