summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

45 rows where filer_name = 110 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
13090 13090 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13091 13091 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13092 13092 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13093 13093 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13094 13094 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13095 13095 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13096 13096 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13097 13097 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13098 13098 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13099 13099 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13100 13100 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13101 13101 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13102 13102 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13103 13103 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13104 13104 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13105 13105 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13106 13106 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13107 13107 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13108 13108 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13109 13109 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13110 13110 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13111 13111 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13112 13112 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13113 13113 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13114 13114 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13115 13115 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13116 13116 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13117 13117 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13118 13118 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13119 13119 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13120 13120 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13121 13121 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13122 13122 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13123 13123 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13124 13124 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13125 13125 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13126 13126 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13127 13127 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13128 13128 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13129 13129 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13130 13130 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13131 13131 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13132 13132 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13133 13133 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 SMRY 0 0
13134 13134 Pending 22 Paul Lim 110 RCP 2014-12-16 2014-12-01 2014-12-01 2014-11-04 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");