summaries
Data source: Summary
5 rows where filer_name = 394 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: total_this_period, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 93222 | 93222 | Pending 20 | California Forward Now 394 | MDI | 2023-01-30 | 2022-10-24 | 2022-12-31 | 2022-11-08 | SMRY | 110933 | 0 |
| 93223 | 93223 | Pending 20 | California Forward Now 394 | MDI | 2023-01-30 | 2022-10-24 | 2022-12-31 | 2022-11-08 | SMRY | 0 | 0 |
| 93224 | 93224 | Pending 20 | California Forward Now 394 | MDI | 2023-01-30 | 2022-10-24 | 2022-12-31 | 2022-11-08 | SMRY | 110933 | 0 |
| 93225 | 93225 | Pending 20 | California Forward Now 394 | MDI | 2023-01-30 | 2022-10-24 | 2022-12-31 | 2022-11-08 | SMRY | 0 | 0 |
| 93226 | 93226 | Pending 20 | California Forward Now 394 | MDI | 2023-01-30 | 2022-10-24 | 2022-12-31 | 2022-11-08 | SMRY | 110933 | 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");