summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

270 rows where filer_name = 97 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, 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
22417 22417 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY -7450 -8150
22418 22418 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22419 22419 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY -7450 -8150
22420 22420 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22421 22421 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY -7450 -8150
22422 22422 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 250.07 709.07
22423 22423 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22424 22424 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 250.07 709.07
22425 22425 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22426 22426 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22427 22427 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 250.07 709.07
22428 22428 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 7700.07 0
22429 22429 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY -7450 0
22430 22430 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22431 22431 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 250.07 0
22432 22432 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22433 22433 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22434 22434 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22435 22435 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22436 22436 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY -7450 0
22437 22437 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22438 22438 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY -7450 0
22439 22439 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22440 22440 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22441 22441 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22442 22442 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22443 22443 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22444 22444 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22445 22445 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22446 22446 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22447 22447 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22448 22448 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 177.07 0
22449 22449 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 73 0
22450 22450 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22451 22451 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 250.07 0
22452 22452 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22453 22453 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22454 22454 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22455 22455 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22456 22456 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22457 22457 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22458 22458 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22459 22459 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22460 22460 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
22461 22461 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2016-01-13 2015-07-01 2015-12-31 2014-11-04 SMRY 0 0
24486 24486 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -700 -700
24487 24487 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24488 24488 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -700 -700
24489 24489 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24490 24490 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -700 -700
24491 24491 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 459 459
24492 24492 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24493 24493 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 459 459
24494 24494 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24495 24495 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24496 24496 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 459 459
24497 24497 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 10555.72 0
24498 24498 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -700 0
24499 24499 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -1696.65 0
24500 24500 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 459 0
24501 24501 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 7700.07 0
24502 24502 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24503 24503 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24504 24504 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24505 24505 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -700 0
24506 24506 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24507 24507 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -700 0
24508 24508 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24509 24509 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24510 24510 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24511 24511 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24512 24512 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24513 24513 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24514 24514 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24515 24515 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24516 24516 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24517 24517 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 450 0
24518 24518 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 9 0
24519 24519 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24520 24520 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 459 0
24521 24521 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24522 24522 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24523 24523 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24524 24524 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24525 24525 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24526 24526 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24527 24527 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -1696.65 0
24528 24528 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24529 24529 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY 0 0
24530 24530 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-07-01 2015-01-01 2015-06-30 2014-11-04 SMRY -1696.65 0
11500 11500 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY 21520 85821
11501 11501 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY 0 0
11502 11502 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY 21520 85821
11503 11503 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY 0 0
11504 11504 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY 21520 85821
11505 11505 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY 90105.76 95616.28
11506 11506 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY 0 0
11507 11507 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY 90105.76 95616.28
11508 11508 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 SMRY -2430 -2430
11509 11509 1362843 96 Jill Broadhurst for Council 2014 97 CTL 2015-02-02 2014-07-01 2014-12-31 2014-11-04 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");