summaries
Data source: Summary
270 rows where filer_name = 470 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_date, year_to_date, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 112715 | 112715 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 1070550 |
| 112716 | 112716 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112717 | 112717 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 1070550 |
| 112718 | 112718 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112719 | 112719 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 1070550 |
| 112720 | 112720 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 150917.39 | 850656.48 |
| 112721 | 112721 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112722 | 112722 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 150917.39 | 850656.48 |
| 112723 | 112723 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 141611.79 | 240001.79 |
| 112724 | 112724 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112725 | 112725 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 292529.18 | 1090658.27 |
| 112726 | 112726 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 170810.92 | 0 |
| 112727 | 112727 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 0 |
| 112728 | 112728 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112729 | 112729 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 150917.39 | 0 |
| 112730 | 112730 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 219893.53 | 0 |
| 112731 | 112731 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112732 | 112732 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112733 | 112733 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 240001.79 | 0 |
| 112734 | 112734 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 0 |
| 112735 | 112735 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112736 | 112736 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 0 |
| 112737 | 112737 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112738 | 112738 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112739 | 112739 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112740 | 112740 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112741 | 112741 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112742 | 112742 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112743 | 112743 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112744 | 112744 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112745 | 112745 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112746 | 112746 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 150917.39 | 0 |
| 112747 | 112747 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112748 | 112748 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112749 | 112749 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 150917.39 | 0 |
| 112750 | 112750 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 198911.79 | 0 |
| 112751 | 112751 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 57300 | 0 |
| 112752 | 112752 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 141611.79 | 0 |
| 112753 | 112753 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112754 | 112754 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112755 | 112755 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112756 | 112756 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112757 | 112757 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112758 | 112758 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112759 | 112759 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-02-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 115542 | 115542 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 333000 | 1403550 | |
| 115543 | 115543 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115544 | 115544 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 333000 | 1403550 | |
| 115545 | 115545 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115546 | 115546 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 333000 | 1403550 | |
| 115547 | 115547 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 532163.16 | 1382819.64 | |
| 115548 | 115548 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115549 | 115549 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 532163.16 | 1382819.64 | |
| 115550 | 115550 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | -238751.45 | 1250.34 | |
| 115551 | 115551 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115552 | 115552 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 293411.71 | 1384069.98 | |
| 115553 | 115553 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 219893.53 | 0 | |
| 115554 | 115554 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 333000 | 0 | |
| 115555 | 115555 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115556 | 115556 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 532163.16 | 0 | |
| 115557 | 115557 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 20730.37 | 0 | |
| 115558 | 115558 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115559 | 115559 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115560 | 115560 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 1250.34 | 0 | |
| 115561 | 115561 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 333000 | 0 | |
| 115562 | 115562 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115563 | 115563 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 333000 | 0 | |
| 115564 | 115564 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115565 | 115565 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115566 | 115566 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115567 | 115567 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115568 | 115568 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115569 | 115569 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115570 | 115570 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115571 | 115571 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115572 | 115572 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115573 | 115573 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 532163.16 | 0 | |
| 115574 | 115574 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115575 | 115575 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115576 | 115576 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 532163.16 | 0 | |
| 115577 | 115577 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 1250.34 | 0 | |
| 115578 | 115578 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 240001.79 | 0 | |
| 115579 | 115579 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | -238751.45 | 0 | |
| 115580 | 115580 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115581 | 115581 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115582 | 115582 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115583 | 115583 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115584 | 115584 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115585 | 115585 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 115586 | 115586 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-30 | 2024-10-20 | 2024-12-31 | SMRY | 0 | 0 | |
| 112760 | 112760 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 1070550 |
| 112761 | 112761 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112762 | 112762 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 1070550 |
| 112763 | 112763 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112764 | 112764 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 200000 | 1070550 |
| 112765 | 112765 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 150917.39 | 850656.48 |
| 112766 | 112766 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112767 | 112767 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 150917.39 | 850656.48 |
| 112768 | 112768 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 141611.79 | 240001.79 |
| 112769 | 112769 | 1467768 341 | Oaklanders Together - For A Safer Oakland, Yes on NN 470 | BMC | 2025-01-16 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 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");