summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

45 rows where filer_name = 59 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: total_this_period, 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
6401 6401 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6402 6402 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6403 6403 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6404 6404 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6405 6405 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6406 6406 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 162 162
6407 6407 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6408 6408 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 162 162
6409 6409 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6410 6410 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6411 6411 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 162 162
6412 6412 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6413 6413 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6414 6414 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6415 6415 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 162 0
6416 6416 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY -162 0
6417 6417 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6418 6418 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6419 6419 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6420 6420 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6421 6421 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6422 6422 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6423 6423 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6424 6424 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6425 6425 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6426 6426 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6427 6427 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6428 6428 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6429 6429 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6430 6430 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6431 6431 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6432 6432 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 120 0
6433 6433 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 42 0
6434 6434 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6435 6435 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 162 0
6436 6436 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6437 6437 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6438 6438 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6439 6439 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6440 6440 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6441 6441 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6442 6442 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6443 6443 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6444 6444 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 SMRY 0 0
6445 6445 1345683 64 Walton for City Council 2012 59 CTL 2013-07-30 2013-01-01 2013-06-30 2012-11-06 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");