summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

135 rows where filer_name = 123 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, year_to_date, report_date (date), report_start_date (date), report_end_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
31664 31664 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 250
31665 31665 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31666 31666 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 250
31667 31667 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31668 31668 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 250
31669 31669 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 2399.05 8095.53
31670 31670 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31671 31671 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 2399.05 8095.53
31672 31672 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31673 31673 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31674 31674 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 2399.05 8095.53
31675 31675 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 2399.05 0
31676 31676 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31677 31677 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31678 31678 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 2399.05 0
31679 31679 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31680 31680 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31681 31681 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31682 31682 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31683 31683 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31684 31684 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31685 31685 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31686 31686 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31687 31687 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31688 31688 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31689 31689 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31690 31690 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31691 31691 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31692 31692 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 1000 0
31693 31693 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31694 31694 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 1000 0
31695 31695 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 2399.05 0
31696 31696 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31697 31697 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31698 31698 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 2399.05 0
31699 31699 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31700 31700 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31701 31701 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31702 31702 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31703 31703 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31704 31704 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31705 31705 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31706 31706 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31707 31707 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
31708 31708 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23 2016-07-01 2016-11-22   SMRY 0 0
37574 37574 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 250 250
37575 37575 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37576 37576 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 250 250
37577 37577 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37578 37578 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 250 250
37579 37579 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 537.75 5696.48
37580 37580 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37581 37581 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 537.75 5696.48
37582 37582 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37583 37583 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37584 37584 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 537.75 5696.48
37585 37585 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 2686.8 0
37586 37586 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 250 0
37587 37587 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37588 37588 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 537.75 0
37589 37589 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 2399.05 0
37590 37590 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37591 37591 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37592 37592 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37593 37593 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 200 0
37594 37594 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 50 0
37595 37595 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 250 0
37596 37596 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37597 37597 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37598 37598 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37599 37599 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37600 37600 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37601 37601 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37602 37602 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37603 37603 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37604 37604 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37605 37605 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 527.4 0
37606 37606 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 10.35 0
37607 37607 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37608 37608 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 537.75 0
37609 37609 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37610 37610 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37611 37611 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37612 37612 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37613 37613 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37614 37614 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37615 37615 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37616 37616 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37617 37617 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
37618 37618 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-07-28 2016-04-24 2016-06-30   SMRY 0 0
21196 21196 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 8872.94 8872.94
21197 21197 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 0 0
21198 21198 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 8872.94 8872.94
21199 21199 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 0 0
21200 21200 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 8872.94 8872.94
21201 21201 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 1027.41 1027.41
21202 21202 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 0 0
21203 21203 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 1027.41 1027.41
21204 21204 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   SMRY 0 0
21205 21205 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-02-01 2015-01-01 2015-12-31   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");