summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

424 rows where filer_name = 87 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, 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
23488 23488 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 8339 8339
23489 23489 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23490 23490 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 8339 8339
23491 23491 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23492 23492 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 8339 8339
23493 23493 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 12081.49 12081.49
23494 23494 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23495 23495 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 12081.49 12081.49
23496 23496 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY -6771.28 1568.06
23497 23497 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23498 23498 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 5310.21 13649.55
23499 23499 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 3360.85 0
23500 23500 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 8339 0
23501 23501 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 427.93 0
23502 23502 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 12081.49 0
23503 23503 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 46.29 0
23504 23504 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23505 23505 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23506 23506 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 1568.06 0
23507 23507 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 8075 0
23508 23508 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 264 0
23509 23509 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 8339 0
23510 23510 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 427.93 0
23511 23511 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23512 23512 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23513 23513 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 427.93 0
23514 23514 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 12030.24 0
23515 23515 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 51.25 0
23516 23516 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23517 23517 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 12081.49 0
23518 23518 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 1568.06 0
23519 23519 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 8339.34 0
23520 23520 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY -6771.28 0
23521 23521 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23522 23522 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23523 23523 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23524 23524 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23525 23525 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
23526 23526 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   SMRY 0 0
9859 9859 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 16497 110441.36
9860 9860 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9861 9861 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 16497 110441.36
9862 9862 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 79 79
9863 9863 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 16576 110520.36
9864 9864 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 30211.24 126501.51
9865 9865 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9866 9866 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 30211.24 126501.51
9867 9867 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY -5879.12 8339.34
9868 9868 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 79 79
9869 9869 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 24411.12 134919.85
9870 9870 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 6177.01 0
9871 9871 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 16497 0
9872 9872 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 10898.08 0
9873 9873 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 30211.24 0
9874 9874 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 3360.85 0
9875 9875 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9876 9876 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9877 9877 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 8339.34 0
9878 9878 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 15310 0
9879 9879 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 1187 0
9880 9880 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 16497 0
9881 9881 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9882 9882 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 79 0
9883 9883 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 79 0
9884 9884 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 10898.08 0
9885 9885 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9886 9886 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9887 9887 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 10898.08 0
9888 9888 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 30211.24 0
9889 9889 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9890 9890 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9891 9891 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 30211.24 0
9892 9892 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 8339.34 0
9893 9893 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 14218.46 0
9894 9894 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY -5879.12 0
9895 9895 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 4100 0
9896 9896 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 4100 0
9897 9897 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9898 9898 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9899 9899 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
9900 9900 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   SMRY 0 0
11708 11708 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 16497 110441.36
11709 11709 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 0 0
11710 11710 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 16497 110441.36
11711 11711 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 79 79
11712 11712 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 16576 110520.36
11713 11713 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 30211.24 126501.51
11714 11714 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 0 0
11715 11715 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 30211.24 126501.51
11716 11716 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY -7254.12 6964.34
11717 11717 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 79 79
11718 11718 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 23036.12 133544.85
11719 11719 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 6177.01 0
11720 11720 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 16497 0
11721 11721 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 10898.08 0
11722 11722 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 30211.24 0
11723 11723 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 3360.85 0
11724 11724 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 0 0
11725 11725 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 0 0
11726 11726 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   SMRY 6964.34 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");