summaries
Data source: Summary
90 rows where filer_name = 389 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_date, total_this_period, year_to_date, report_date (date), report_start_date (date), report_end_date (date)
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");