summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

10 rows where filer_name = 227 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, total_this_period, 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
49458 49458 pending 99 UNITE HERE Local 2850 227 MDI 2019-01-25 2018-07-01 2018-12-31 2018-11-06 SMRY 17787 0
49459 49459 pending 99 UNITE HERE Local 2850 227 MDI 2019-01-25 2018-07-01 2018-12-31 2018-11-06 SMRY 0 0
49460 49460 pending 99 UNITE HERE Local 2850 227 MDI 2019-01-25 2018-07-01 2018-12-31 2018-11-06 SMRY 17787 0
49461 49461 pending 99 UNITE HERE Local 2850 227 MDI 2019-01-25 2018-07-01 2018-12-31 2018-11-06 SMRY 130663.7 0
49462 49462 pending 99 UNITE HERE Local 2850 227 MDI 2019-01-25 2018-07-01 2018-12-31 2018-11-06 SMRY 148450.7 0
56939 56939 pending 99 UNITE HERE Local 2850 227 MDI 2018-07-25 2018-01-01 2018-06-30 2018-11-06 SMRY 130663.7 0
56940 56940 pending 99 UNITE HERE Local 2850 227 MDI 2018-07-25 2018-01-01 2018-06-30 2018-11-06 SMRY 0 0
56941 56941 pending 99 UNITE HERE Local 2850 227 MDI 2018-07-25 2018-01-01 2018-06-30 2018-11-06 SMRY 130663.7 0
56942 56942 pending 99 UNITE HERE Local 2850 227 MDI 2018-07-25 2018-01-01 2018-06-30 2018-11-06 SMRY 0 0
56943 56943 pending 99 UNITE HERE Local 2850 227 MDI 2018-07-25 2018-01-01 2018-06-30 2018-11-06 SMRY 130663.7 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");