summaries
Data source: Summary
565 rows where filer_name = 287 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 102079 | 102079 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | -100 |
| 102080 | 102080 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102081 | 102081 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | -100 |
| 102082 | 102082 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102083 | 102083 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | -100 |
| 102084 | 102084 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 14549.42 | 14549.42 |
| 102085 | 102085 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102086 | 102086 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 14549.42 | 14549.42 |
| 102087 | 102087 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 3069.81 | 8577.58 |
| 102088 | 102088 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102089 | 102089 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 17619.23 | 23127 |
| 102090 | 102090 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 33916.12 | 0 |
| 102091 | 102091 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | 0 |
| 102092 | 102092 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 500 | 0 |
| 102093 | 102093 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 14549.42 | 0 |
| 102094 | 102094 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 19766.7 | 0 |
| 102095 | 102095 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102096 | 102096 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102097 | 102097 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 8577.58 | 0 |
| 102098 | 102098 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | 0 |
| 102099 | 102099 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102100 | 102100 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | 0 |
| 102101 | 102101 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102102 | 102102 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102103 | 102103 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102104 | 102104 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102105 | 102105 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102106 | 102106 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102107 | 102107 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -350 | 0 |
| 102108 | 102108 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 1000 | 0 |
| 102109 | 102109 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 650 | 0 |
| 102110 | 102110 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 14499.42 | 0 |
| 102111 | 102111 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 50 | 0 |
| 102112 | 102112 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102113 | 102113 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 14549.42 | 0 |
| 102114 | 102114 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 8577.58 | 0 |
| 102115 | 102115 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 5507.77 | 0 |
| 102116 | 102116 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 3069.81 | 0 |
| 102117 | 102117 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102118 | 102118 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102119 | 102119 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102120 | 102120 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 500 | 0 |
| 102121 | 102121 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102122 | 102122 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 102123 | 102123 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2024-01-25 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 500 | 0 |
| 108243 | 108243 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | -100 |
| 108244 | 108244 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108245 | 108245 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | -100 |
| 108246 | 108246 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108247 | 108247 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | -100 |
| 108248 | 108248 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 15549.42 | 15549.42 |
| 108249 | 108249 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108250 | 108250 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 15549.42 | 15549.42 |
| 108251 | 108251 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 2919.81 | 8427.58 |
| 108252 | 108252 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108253 | 108253 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 18469.23 | 23977 |
| 108254 | 108254 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 33916.12 | 0 |
| 108255 | 108255 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | 0 |
| 108256 | 108256 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 500 | 0 |
| 108257 | 108257 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 15549.42 | 0 |
| 108258 | 108258 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 18766.7 | 0 |
| 108259 | 108259 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108260 | 108260 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108261 | 108261 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 8427.58 | 0 |
| 108262 | 108262 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | 0 |
| 108263 | 108263 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108264 | 108264 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | -100 | 0 |
| 108265 | 108265 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108266 | 108266 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108267 | 108267 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108268 | 108268 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108269 | 108269 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108270 | 108270 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108271 | 108271 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 650 | 0 |
| 108272 | 108272 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108273 | 108273 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 650 | 0 |
| 108274 | 108274 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 15499.42 | 0 |
| 108275 | 108275 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 50 | 0 |
| 108276 | 108276 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108277 | 108277 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 15549.42 | 0 |
| 108278 | 108278 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 8427.58 | 0 |
| 108279 | 108279 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 5507.77 | 0 |
| 108280 | 108280 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 2919.81 | 0 |
| 108281 | 108281 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108282 | 108282 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108283 | 108283 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108284 | 108284 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 500 | 0 |
| 108285 | 108285 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108286 | 108286 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 108287 | 108287 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-07-29 | 2023-01-01 | 2023-06-30 | 2022-11-08 | SMRY | 500 | 0 |
| 93139 | 93139 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 3710 | 64729 |
| 93140 | 93140 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 0 | 0 |
| 93141 | 93141 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 3710 | 64729 |
| 93142 | 93142 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 1241.17 | 1800 |
| 93143 | 93143 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 4951.17 | 66529 |
| 93144 | 93144 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 55061.34 | 137942.57 |
| 93145 | 93145 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 0 | 0 |
| 93146 | 93146 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 55061.34 | 137942.57 |
| 93147 | 93147 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 3128.64 | 5507.77 |
| 93148 | 93148 | 1423821 227 | Re-elect Nikki F Bas for City Council 2022 287 | CTL | 2023-01-30 | 2022-10-23 | 2022-12-31 | 2022-11-08 | SMRY | 1241.17 | 1800 |
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");