summaries
Data source: Summary
5 rows where filer_name = 416 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 92904 | 92904 | Pending 22 | End Citizens United//Let America Vote Action Fund 416 | MDI | 2023-01-30 | 2022-07-27 | 2022-12-31 | 2022-11-08 | SMRY | 25000 | 0 |
| 92905 | 92905 | Pending 22 | End Citizens United//Let America Vote Action Fund 416 | MDI | 2023-01-30 | 2022-07-27 | 2022-12-31 | 2022-11-08 | SMRY | 0 | 0 |
| 92906 | 92906 | Pending 22 | End Citizens United//Let America Vote Action Fund 416 | MDI | 2023-01-30 | 2022-07-27 | 2022-12-31 | 2022-11-08 | SMRY | 25000 | 0 |
| 92907 | 92907 | Pending 22 | End Citizens United//Let America Vote Action Fund 416 | MDI | 2023-01-30 | 2022-07-27 | 2022-12-31 | 2022-11-08 | SMRY | 0 | 0 |
| 92908 | 92908 | Pending 22 | End Citizens United//Let America Vote Action Fund 416 | MDI | 2023-01-30 | 2022-07-27 | 2022-12-31 | 2022-11-08 | SMRY | 25000 | 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");