home / election_finance

summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

360 rows where filer_id = 115 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
43530 43530 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 432 432
43531 43531 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43532 43532 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 432 432
43533 43533 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43534 43534 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 432 432
43535 43535 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 2447.04 2447.04
43536 43536 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43537 43537 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 2447.04 2447.04
43538 43538 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43539 43539 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43540 43540 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 2447.04 2447.04
43541 43541 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 2005.04 0
43542 43542 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 432 0
43543 43543 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 10 0
43544 43544 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 2447.04 0
43545 43545 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43546 43546 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43547 43547 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43548 43548 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43549 43549 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 100 0
43550 43550 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 332 0
43551 43551 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 432 0
43552 43552 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43553 43553 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43554 43554 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43555 43555 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43556 43556 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43557 43557 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43558 43558 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43559 43559 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43560 43560 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43561 43561 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 2324.79 0
43562 43562 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 122.25 0
43563 43563 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43564 43564 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 2447.04 0
43565 43565 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43566 43566 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43567 43567 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43568 43568 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43569 43569 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43570 43570 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43571 43571 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43572 43572 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 10 0
43573 43573 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 0 0
43574 43574 1379618 115 Transport Oakland 126 RCP 2017-06-14 2017-01-01 2017-06-13   SMRY 10 0
29945 29945 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 296.88 16007.76
29946 29946 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29947 29947 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 296.88 16007.76
29948 29948 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29949 29949 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 296.88 16007.76
29950 29950 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 2141.5 14992.72
29951 29951 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29952 29952 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 2141.5 14992.72
29953 29953 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY -687.11 0
29954 29954 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29955 29955 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 1454.39 14992.72
29956 29956 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 3849.66 0
29957 29957 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 296.88 0
29958 29958 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29959 29959 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 2141.5 0
29960 29960 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 2005.04 0
29961 29961 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29962 29962 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29963 29963 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29964 29964 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 276.88 0
29965 29965 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 20 0
29966 29966 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 296.88 0
29967 29967 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29968 29968 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29969 29969 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29970 29970 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29971 29971 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29972 29972 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29973 29973 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29974 29974 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29975 29975 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29976 29976 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 2066.42 0
29977 29977 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 75.08 0
29978 29978 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29979 29979 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 2141.5 0
29980 29980 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29981 29981 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 687.11 0
29982 29982 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY -687.11 0
29983 29983 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29984 29984 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29985 29985 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29986 29986 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29987 29987 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29988 29988 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
29989 29989 1379618 115 Transport Oakland 126 RCP 2017-01-29 2016-10-23 2016-12-31   SMRY 0 0
33243 33243 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY 2530 15710.88
33244 33244 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY 0 0
33245 33245 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY 2530 15710.88
33246 33246 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY 0 0
33247 33247 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY 2530 15710.88
33248 33248 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY 5881.72 12851.22
33249 33249 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY 0 0
33250 33250 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY 5881.72 12851.22
33251 33251 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 SMRY -574.1 687.11
33252 33252 1379618 115 Transport Oakland 126 RCP 2016-10-27 2016-09-25 2016-10-22 2016-11-08 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");
Powered by Datasette · Queries took 18.918ms · Data source: Summary