summaries
Data source: Summary
498 rows where filer_name = 339 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
117267 | 117267 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117268 | 117268 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117269 | 117269 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117270 | 117270 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117271 | 117271 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117272 | 117272 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 2032 | 2528.7 |
117273 | 117273 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117274 | 117274 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 2032 | 2528.7 |
117275 | 117275 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 331 | 331 |
117276 | 117276 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117277 | 117277 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 2363 | 2859.7 |
117278 | 117278 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 1830.08 | 0 |
117279 | 117279 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117280 | 117280 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 360 | 0 |
117281 | 117281 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 2032 | 0 |
117282 | 117282 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 158.08 | 0 |
117283 | 117283 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117284 | 117284 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117285 | 117285 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 331 | 0 |
117286 | 117286 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117287 | 117287 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117288 | 117288 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117289 | 117289 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117290 | 117290 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117291 | 117291 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117292 | 117292 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117293 | 117293 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117294 | 117294 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117295 | 117295 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117296 | 117296 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117297 | 117297 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117298 | 117298 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 2032 | 0 |
117299 | 117299 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117300 | 117300 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117301 | 117301 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 2032 | 0 |
117302 | 117302 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 331 | 0 |
117303 | 117303 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117304 | 117304 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 331 | 0 |
117305 | 117305 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117306 | 117306 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117307 | 117307 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117308 | 117308 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 360 | 0 |
117309 | 117309 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117310 | 117310 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 0 | 0 |
117311 | 117311 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2025-01-27 | 2024-07-01 | 2024-12-31 | 2020-11-03 | SMRY | 360 | 0 |
123935 | 123935 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123936 | 123936 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123937 | 123937 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123938 | 123938 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123939 | 123939 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123940 | 123940 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 496.7 | 496.7 |
123941 | 123941 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123942 | 123942 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 496.7 | 496.7 |
123943 | 123943 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123944 | 123944 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123945 | 123945 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 496.7 | 496.7 |
123946 | 123946 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 2326.78 | 0 |
123947 | 123947 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123948 | 123948 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123949 | 123949 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 496.7 | 0 |
123950 | 123950 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 1830.08 | 0 |
123951 | 123951 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123952 | 123952 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123953 | 123953 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123954 | 123954 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123955 | 123955 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123956 | 123956 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123957 | 123957 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123958 | 123958 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123959 | 123959 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123960 | 123960 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123961 | 123961 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123962 | 123962 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123963 | 123963 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123964 | 123964 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123965 | 123965 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123966 | 123966 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 446.2 | 0 |
123967 | 123967 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 50.5 | 0 |
123968 | 123968 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123969 | 123969 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 496.7 | 0 |
123970 | 123970 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123971 | 123971 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123972 | 123972 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123973 | 123973 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123974 | 123974 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123975 | 123975 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123976 | 123976 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123977 | 123977 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123978 | 123978 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
123979 | 123979 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-07-26 | 2024-01-01 | 2024-06-30 | 2020-11-03 | SMRY | 0 | 0 |
104171 | 104171 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 25 | 25 |
104172 | 104172 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 0 | 0 |
104173 | 104173 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 25 | 25 |
104174 | 104174 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 0 | 0 |
104175 | 104175 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 25 | 25 |
104176 | 104176 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 476.78 | 1015.04 |
104177 | 104177 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 0 | 0 |
104178 | 104178 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 476.78 | 1015.04 |
104179 | 104179 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | SMRY | 0 | 0 |
104180 | 104180 | 1442274 262 | Rebecca Kaplan for City Council 2020 Officeholder 339 | CTL | 2024-01-31 | 2023-07-01 | 2023-12-31 | 2020-11-03 | 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");