summaries
Data source: Summary
20 rows where filer_name = 210 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_date, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 44848 | 44848 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-01-01 | 2018-06-30 | SMRY | 10800 | 0 | |
| 44849 | 44849 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-01-01 | 2018-06-30 | SMRY | 0 | 0 | |
| 44850 | 44850 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-01-01 | 2018-06-30 | SMRY | 10800 | 0 | |
| 44851 | 44851 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-01-01 | 2018-06-30 | SMRY | 0 | 0 | |
| 44852 | 44852 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-01-01 | 2018-06-30 | SMRY | 10800 | 0 | |
| 47290 | 47290 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-07-01 | 2018-12-31 | SMRY | 5900 | 0 | |
| 47291 | 47291 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-07-01 | 2018-12-31 | SMRY | 0 | 0 | |
| 47292 | 47292 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-07-01 | 2018-12-31 | SMRY | 5900 | 0 | |
| 47293 | 47293 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-07-01 | 2018-12-31 | SMRY | 10800 | 0 | |
| 47294 | 47294 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-20 | 2018-07-01 | 2018-12-31 | SMRY | 16700 | 0 | |
| 47647 | 47647 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-12 | 2018-07-01 | 2018-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 47648 | 47648 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-12 | 2018-07-01 | 2018-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 47649 | 47649 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-12 | 2018-07-01 | 2018-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 47650 | 47650 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-12 | 2018-07-01 | 2018-12-31 | 2018-11-06 | SMRY | 10000 | 0 |
| 47651 | 47651 | pending 99 | Charles Freiberg 210 | MDI | 2019-02-12 | 2018-07-01 | 2018-12-31 | 2018-11-06 | SMRY | 10000 | 0 |
| 54676 | 54676 | pending 99 | Charles Freiberg 210 | MDI | 2018-08-10 | 2018-01-01 | 2018-06-30 | 2018-11-06 | SMRY | 10000 | 0 |
| 54677 | 54677 | pending 99 | Charles Freiberg 210 | MDI | 2018-08-10 | 2018-01-01 | 2018-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 54678 | 54678 | pending 99 | Charles Freiberg 210 | MDI | 2018-08-10 | 2018-01-01 | 2018-06-30 | 2018-11-06 | SMRY | 10000 | 0 |
| 54679 | 54679 | pending 99 | Charles Freiberg 210 | MDI | 2018-08-10 | 2018-01-01 | 2018-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 54680 | 54680 | pending 99 | Charles Freiberg 210 | MDI | 2018-08-10 | 2018-01-01 | 2018-06-30 | 2018-11-06 | SMRY | 10000 | 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");