summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

585 rows where filer_name = 11 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
41396 41396 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41397 41397 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41398 41398 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41399 41399 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41400 41400 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41401 41401 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41402 41402 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41403 41403 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41404 41404 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41405 41405 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41406 41406 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41407 41407 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 8866.73 0
41408 41408 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41409 41409 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41410 41410 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41411 41411 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 8866.73 0
41412 41412 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41413 41413 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41414 41414 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41415 41415 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41416 41416 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41417 41417 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41418 41418 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41419 41419 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41420 41420 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41421 41421 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41422 41422 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41423 41423 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41424 41424 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41425 41425 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41426 41426 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41427 41427 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41428 41428 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41429 41429 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41430 41430 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41431 41431 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41432 41432 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41433 41433 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41434 41434 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41435 41435 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41436 41436 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41437 41437 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41438 41438 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41439 41439 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
41440 41440 1236617 11 Desley Brooks 11 CTL 2017-08-04 2017-01-01 2017-06-30   SMRY 0 0
31115 31115 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY -4900 -4900
31116 31116 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY -2500 0
31117 31117 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY -7400 -4900
31118 31118 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31119 31119 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY -7400 -4900
31120 31120 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 2910.01 4422.77
31121 31121 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31122 31122 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 2910.01 4422.77
31123 31123 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31124 31124 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31125 31125 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 2910.01 4422.77
31126 31126 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 19176.74 0
31127 31127 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY -7400 0
31128 31128 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31129 31129 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 2910.01 0
31130 31130 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 8866.73 0
31131 31131 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31132 31132 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31133 31133 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31134 31134 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY -4900 0
31135 31135 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31136 31136 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY -4900 0
31137 31137 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31138 31138 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 2500 0
31139 31139 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY -2500 0
31140 31140 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31141 31141 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31142 31142 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31143 31143 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31144 31144 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31145 31145 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31146 31146 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 2490.93 0
31147 31147 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 419.08 0
31148 31148 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31149 31149 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 2910.01 0
31150 31150 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31151 31151 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31152 31152 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31153 31153 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31154 31154 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31155 31155 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31156 31156 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31157 31157 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31158 31158 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
31159 31159 1236617 11 Desley Brooks 11 CTL 2017-01-22 2016-07-01 2016-12-31   SMRY 0 0
37438 37438 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 0 0
37439 37439 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 0 2500
37440 37440 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 0 2500
37441 37441 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 0 0
37442 37442 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 0 2500
37443 37443 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 1512.76 1512.76
37444 37444 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 0 0
37445 37445 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 1512.76 1512.76
37446 37446 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 0 0
37447 37447 1236617 11 Desley Brooks 11 CTL 2016-07-30 2016-01-01 2016-06-30   SMRY 0 0

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