summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

85 rows where filer_id = 59 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, election_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
58044 58044 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   SMRY 31000 0
58045 58045 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   SMRY 0 0
58046 58046 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   SMRY 31000 0
58047 58047 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   SMRY 0 0
58048 58048 S10226 59 The Clorox Company 55 MDI 2018-04-02 2018-01-01 2018-03-31   SMRY 31000 0
41024 41024 S10226 59 The Clorox Company 55 MDI 2018-01-03 2017-10-01 2017-12-31   SMRY 0 0
41025 41025 S10226 59 The Clorox Company 55 MDI 2018-01-03 2017-10-01 2017-12-31   SMRY 0 0
41026 41026 S10226 59 The Clorox Company 55 MDI 2018-01-03 2017-10-01 2017-12-31   SMRY 0 0
41027 41027 S10226 59 The Clorox Company 55 MDI 2018-01-03 2017-10-01 2017-12-31   SMRY 57350 0
41028 41028 S10226 59 The Clorox Company 55 MDI 2018-01-03 2017-10-01 2017-12-31   SMRY 57350 0
41166 41166 S10226 59 The Clorox Company 55 MDI 2017-10-04 2017-07-01 2017-09-30   SMRY 0 0
41167 41167 S10226 59 The Clorox Company 55 MDI 2017-10-04 2017-07-01 2017-09-30   SMRY 0 0
41168 41168 S10226 59 The Clorox Company 55 MDI 2017-10-04 2017-07-01 2017-09-30   SMRY 0 0
41169 41169 S10226 59 The Clorox Company 55 MDI 2017-10-04 2017-07-01 2017-09-30   SMRY 57350 0
41170 41170 S10226 59 The Clorox Company 55 MDI 2017-10-04 2017-07-01 2017-09-30   SMRY 57350 0
43525 43525 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   SMRY 43650 0
43526 43526 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   SMRY 0 0
43527 43527 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   SMRY 43650 0
43528 43528 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   SMRY 13700 0
43529 43529 S10226 59 The Clorox Company 55 MDI 2017-07-05 2017-04-01 2017-06-30   SMRY 57350 0
43710 43710 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   SMRY 13700 0
43711 43711 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   SMRY 0 0
43712 43712 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   SMRY 13700 0
43713 43713 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   SMRY 0 0
43714 43714 S10226 59 The Clorox Company 55 MDI 2017-04-06 2017-01-01 2017-03-31   SMRY 13700 0
31385 31385 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   SMRY 11300 0
31386 31386 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   SMRY 0 0
31387 31387 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   SMRY 11300 0
31388 31388 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   SMRY 48250 0
31389 31389 S10226 59 The Clorox Company 55 MDI 2017-01-06 2016-07-01 2016-12-31   SMRY 59550 0
24963 24963 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 48250 0
24964 24964 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 0 0
24965 24965 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 48250 0
24966 24966 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 0 0
24967 24967 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 48250 0
38208 38208 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 48250 0
38209 38209 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 0 0
38210 38210 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 48250 0
38211 38211 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 128089 0
38212 38212 S10226 59 The Clorox Company 55 MDI 2016-07-06 2016-01-01 2016-06-30 2016-06-07 SMRY 176339 0
22554 22554 S10226 59 The Clorox Company 55 MDI 2016-01-04 2015-10-01 2015-12-31   SMRY 6000 0
22555 22555 S10226 59 The Clorox Company 55 MDI 2016-01-04 2015-10-01 2015-12-31   SMRY 0 0
22556 22556 S10226 59 The Clorox Company 55 MDI 2016-01-04 2015-10-01 2015-12-31   SMRY 6000 0
22557 22557 S10226 59 The Clorox Company 55 MDI 2016-01-04 2015-10-01 2015-12-31   SMRY 122089 0
22558 22558 S10226 59 The Clorox Company 55 MDI 2016-01-04 2015-10-01 2015-12-31   SMRY 128089 0
22768 22768 S10226 59 The Clorox Company 55 MDI 2015-09-30 2015-07-01 2015-09-30   SMRY 10500 0
22769 22769 S10226 59 The Clorox Company 55 MDI 2015-09-30 2015-07-01 2015-09-30   SMRY 0 0
22770 22770 S10226 59 The Clorox Company 55 MDI 2015-09-30 2015-07-01 2015-09-30   SMRY 10500 0
22771 22771 S10226 59 The Clorox Company 55 MDI 2015-09-30 2015-07-01 2015-09-30   SMRY 111589 0
22772 22772 S10226 59 The Clorox Company 55 MDI 2015-09-30 2015-07-01 2015-09-30   SMRY 122089 0
24481 24481 S10226 59 The Clorox Company 55 MDI 2015-07-08 2015-04-01 2015-06-30   SMRY 24164 0
24482 24482 S10226 59 The Clorox Company 55 MDI 2015-07-08 2015-04-01 2015-06-30   SMRY -1500 0
24483 24483 S10226 59 The Clorox Company 55 MDI 2015-07-08 2015-04-01 2015-06-30   SMRY 22664 0
24484 24484 S10226 59 The Clorox Company 55 MDI 2015-07-08 2015-04-01 2015-06-30   SMRY 88925 0
24485 24485 S10226 59 The Clorox Company 55 MDI 2015-07-08 2015-04-01 2015-06-30   SMRY 111589 0
24743 24743 S10226 59 The Clorox Company 55 MDI 2015-03-31 2015-01-01 2015-03-31   SMRY 29425 0
24744 24744 S10226 59 The Clorox Company 55 MDI 2015-03-31 2015-01-01 2015-03-31   SMRY -1000 0
24745 24745 S10226 59 The Clorox Company 55 MDI 2015-03-31 2015-01-01 2015-03-31   SMRY 28425 0
24746 24746 S10226 59 The Clorox Company 55 MDI 2015-03-31 2015-01-01 2015-03-31   SMRY 60500 0
24747 24747 S10226 59 The Clorox Company 55 MDI 2015-03-31 2015-01-01 2015-03-31   SMRY 88925 0
12950 12950 S10226 59 The Clorox Company 55 MDI 2015-01-06 2014-07-01 2014-12-31   SMRY 16000 0
12951 12951 S10226 59 The Clorox Company 55 MDI 2015-01-06 2014-07-01 2014-12-31   SMRY 0 0
12952 12952 S10226 59 The Clorox Company 55 MDI 2015-01-06 2014-07-01 2014-12-31   SMRY 16000 0
12953 12953 S10226 59 The Clorox Company 55 MDI 2015-01-06 2014-07-01 2014-12-31   SMRY 44500 0
12954 12954 S10226 59 The Clorox Company 55 MDI 2015-01-06 2014-07-01 2014-12-31   SMRY 60500 0
19593 19593 S10226 59 The Clorox Company 55 MDI 2014-07-03 2014-04-01 2014-06-30 2014-06-03 SMRY 11500 0
19594 19594 S10226 59 The Clorox Company 55 MDI 2014-07-03 2014-04-01 2014-06-30 2014-06-03 SMRY 0 0
19595 19595 S10226 59 The Clorox Company 55 MDI 2014-07-03 2014-04-01 2014-06-30 2014-06-03 SMRY 11500 0
19596 19596 S10226 59 The Clorox Company 55 MDI 2014-07-03 2014-04-01 2014-06-30 2014-06-03 SMRY 33000 0
19597 19597 S10226 59 The Clorox Company 55 MDI 2014-07-03 2014-04-01 2014-06-30 2014-06-03 SMRY 44500 0
19864 19864 S10226 59 The Clorox Company 55 MDI 2014-04-04 2014-01-01 2014-03-31 2014-06-03 SMRY 33000 0
19865 19865 S10226 59 The Clorox Company 55 MDI 2014-04-04 2014-01-01 2014-03-31 2014-06-03 SMRY 0 0
19866 19866 S10226 59 The Clorox Company 55 MDI 2014-04-04 2014-01-01 2014-03-31 2014-06-03 SMRY 33000 0
19867 19867 S10226 59 The Clorox Company 55 MDI 2014-04-04 2014-01-01 2014-03-31 2014-06-03 SMRY 0 0
19868 19868 S10226 59 The Clorox Company 55 MDI 2014-04-04 2014-01-01 2014-03-31 2014-06-03 SMRY 33000 0
5228 5228 S10226 59 The Clorox Company 55 MDI 2014-01-08 2013-10-01 2013-12-31   SMRY 950 0
5229 5229 S10226 59 The Clorox Company 55 MDI 2014-01-08 2013-10-01 2013-12-31   SMRY 0 0
5230 5230 S10226 59 The Clorox Company 55 MDI 2014-01-08 2013-10-01 2013-12-31   SMRY 950 0
5231 5231 S10226 59 The Clorox Company 55 MDI 2014-01-08 2013-10-01 2013-12-31   SMRY 88750 0
5232 5232 S10226 59 The Clorox Company 55 MDI 2014-01-08 2013-10-01 2013-12-31   SMRY 89700 0
6471 6471 S10226 59 The Clorox Company 55 MDI 2013-07-08 2013-04-01 2013-06-30   SMRY 28000 0
6472 6472 S10226 59 The Clorox Company 55 MDI 2013-07-08 2013-04-01 2013-06-30   SMRY 0 0
6473 6473 S10226 59 The Clorox Company 55 MDI 2013-07-08 2013-04-01 2013-06-30   SMRY 28000 0
6474 6474 S10226 59 The Clorox Company 55 MDI 2013-07-08 2013-04-01 2013-06-30   SMRY 32500 0
6475 6475 S10226 59 The Clorox Company 55 MDI 2013-07-08 2013-04-01 2013-06-30   SMRY 60500 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");