summaries
Data source: Summary
5 rows where filer_id = 359 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 113837 | 113837 | 1286881 359 | Linda C. Hothem 484 | MDI | 2025-03-12 | 2024-01-01 | 2024-12-31 | 2025-04-15 | SMRY | 16590.04 | 0 |
| 113838 | 113838 | 1286881 359 | Linda C. Hothem 484 | MDI | 2025-03-12 | 2024-01-01 | 2024-12-31 | 2025-04-15 | SMRY | 0 | 0 |
| 113839 | 113839 | 1286881 359 | Linda C. Hothem 484 | MDI | 2025-03-12 | 2024-01-01 | 2024-12-31 | 2025-04-15 | SMRY | 16590.04 | 0 |
| 113840 | 113840 | 1286881 359 | Linda C. Hothem 484 | MDI | 2025-03-12 | 2024-01-01 | 2024-12-31 | 2025-04-15 | SMRY | 0 | 0 |
| 113841 | 113841 | 1286881 359 | Linda C. Hothem 484 | MDI | 2025-03-12 | 2024-01-01 | 2024-12-31 | 2025-04-15 | SMRY | 16590.04 | 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");