summaries
Data source: Summary
270 rows where filer_name = 91 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20341 | 20341 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20342 | 20342 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20343 | 20343 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20344 | 20344 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20345 | 20345 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20346 | 20346 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 211.11 | 211.11 |
| 20347 | 20347 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20348 | 20348 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 211.11 | 211.11 |
| 20349 | 20349 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20350 | 20350 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20351 | 20351 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 211.11 | 211.11 |
| 20352 | 20352 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 221.11 | 0 |
| 20353 | 20353 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20354 | 20354 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20355 | 20355 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 211.11 | 0 |
| 20356 | 20356 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 10 | 0 |
| 20357 | 20357 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20358 | 20358 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20359 | 20359 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20360 | 20360 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20361 | 20361 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20362 | 20362 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20363 | 20363 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20364 | 20364 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20365 | 20365 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20366 | 20366 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20367 | 20367 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20368 | 20368 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20369 | 20369 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20370 | 20370 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20371 | 20371 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20372 | 20372 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 211.11 | 0 |
| 20373 | 20373 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20374 | 20374 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20375 | 20375 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 211.11 | 0 |
| 20376 | 20376 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20377 | 20377 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20378 | 20378 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20379 | 20379 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20380 | 20380 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20381 | 20381 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20382 | 20382 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20383 | 20383 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20384 | 20384 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 20385 | 20385 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2017-05-24 | 2015-08-01 | 2015-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 22802 | 22802 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22803 | 22803 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22804 | 22804 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22805 | 22805 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22806 | 22806 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22807 | 22807 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22808 | 22808 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22809 | 22809 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22810 | 22810 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22811 | 22811 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22812 | 22812 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22813 | 22813 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 221.11 | 0 |
| 22814 | 22814 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22815 | 22815 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22816 | 22816 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22817 | 22817 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 221.11 | 0 |
| 22818 | 22818 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22819 | 22819 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22820 | 22820 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22821 | 22821 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22822 | 22822 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22823 | 22823 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22824 | 22824 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22825 | 22825 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22826 | 22826 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22827 | 22827 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22828 | 22828 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22829 | 22829 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22830 | 22830 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22831 | 22831 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22832 | 22832 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22833 | 22833 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22834 | 22834 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22835 | 22835 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22836 | 22836 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22837 | 22837 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22838 | 22838 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22839 | 22839 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22840 | 22840 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22841 | 22841 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22842 | 22842 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22843 | 22843 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22844 | 22844 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22845 | 22845 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 22846 | 22846 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-08-11 | 2015-01-01 | 2015-06-30 | 2014-11-04 | SMRY | 0 | 0 |
| 10430 | 10430 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 2330 | 17534 |
| 10431 | 10431 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 10432 | 10432 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 2330 | 17534 |
| 10433 | 10433 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 0 | 105 |
| 10434 | 10434 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 2330 | 17639 |
| 10435 | 10435 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 8623.49 | 18311.89 |
| 10436 | 10436 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 10437 | 10437 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 8623.49 | 18311.89 |
| 10438 | 10438 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 0 | 0 |
| 10439 | 10439 | 1365733 92 | Shakir-Gilmore for Oakland School Board 2014 91 | CTL | 2015-02-10 | 2014-10-19 | 2014-12-31 | 2014-11-04 | SMRY | 0 | 105 |
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");