summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

225 rows where filer_name = 219 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
47065 47065 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY -301 96265.69
47066 47066 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47067 47067 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY -301 96265.69
47068 47068 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 40
47069 47069 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY -301 96305.69
47070 47070 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 23658.01 111553.69
47071 47071 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47072 47072 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 23658.01 111553.69
47073 47073 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47074 47074 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 40
47075 47075 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 23658.01 111593.69
47076 47076 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 23959.01 0
47077 47077 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY -301 0
47078 47078 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47079 47079 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 23658.01 0
47080 47080 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47081 47081 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47082 47082 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47083 47083 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47084 47084 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY -287 0
47085 47085 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY -14 0
47086 47086 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY -301 0
47087 47087 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47088 47088 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47089 47089 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47090 47090 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47091 47091 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47092 47092 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47093 47093 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 800 0
47094 47094 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47095 47095 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 800 0
47096 47096 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 23605.51 0
47097 47097 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 52.5 0
47098 47098 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47099 47099 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 23658.01 0
47100 47100 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47101 47101 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47102 47102 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47103 47103 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47104 47104 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47105 47105 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47106 47106 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47107 47107 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47108 47108 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
47109 47109 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-02-20 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
63585 63585 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY -301 0
63586 63586 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63587 63587 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY -301 0
63588 63588 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63589 63589 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY -301 0
63590 63590 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 23658.01 0
63591 63591 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63592 63592 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 23658.01 0
63593 63593 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63594 63594 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63595 63595 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 23658.01 0
63596 63596 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 23959.01 0
63597 63597 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY -301 0
63598 63598 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63599 63599 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 23658.01 0
63600 63600 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63601 63601 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63602 63602 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63603 63603 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63604 63604 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY -224 0
63605 63605 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY -77 0
63606 63606 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY -301 0
63607 63607 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63608 63608 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63609 63609 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63610 63610 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63611 63611 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63612 63612 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63613 63613 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 800 0
63614 63614 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63615 63615 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 800 0
63616 63616 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 23448.26 0
63617 63617 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 209.75 0
63618 63618 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63619 63619 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 23658.01 0
63620 63620 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63621 63621 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63622 63622 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63623 63623 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63624 63624 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63625 63625 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63626 63626 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63627 63627 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63628 63628 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
63629 63629 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2019-01-31 2018-10-21 2019-01-31 2018-11-06 SMRY 0 0
52273 52273 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 5280 95574
52274 52274 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 0
52275 52275 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 5280 95574
52276 52276 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 40
52277 52277 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 5280 95614
52278 52278 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 55679.15 93352.69
52279 52279 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 0
52280 52280 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 55679.15 93352.69
52281 52281 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 0
52282 52282 1406241 173 Charlie Michelson for Oakland City Council 2018 219 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 40

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