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