summaries
Data source: Summary
382 rows where filer_name = 214 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 84122 | 84122 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 50 | 50 |
| 84123 | 84123 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 2000 |
| 84124 | 84124 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 50 | 2050 |
| 84125 | 84125 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84126 | 84126 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 50 | 2050 |
| 84127 | 84127 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 177.24 | 177.24 |
| 84128 | 84128 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84129 | 84129 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 177.24 | 177.24 |
| 84130 | 84130 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 1039.4 |
| 84131 | 84131 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84132 | 84132 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 177.24 | 1216.64 |
| 84133 | 84133 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 1079.17 | 0 |
| 84134 | 84134 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 50 | 0 |
| 84135 | 84135 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84136 | 84136 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 177.24 | 0 |
| 84137 | 84137 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 951.93 | 0 |
| 84138 | 84138 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84139 | 84139 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84140 | 84140 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 3039.4 | 0 |
| 84141 | 84141 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84142 | 84142 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 50 | 0 |
| 84143 | 84143 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 50 | 0 |
| 84144 | 84144 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84145 | 84145 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84146 | 84146 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84147 | 84147 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84148 | 84148 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84149 | 84149 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84150 | 84150 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84151 | 84151 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84152 | 84152 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84153 | 84153 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 127.24 | 0 |
| 84154 | 84154 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 50 | 0 |
| 84155 | 84155 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84156 | 84156 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 177.24 | 0 |
| 84157 | 84157 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84158 | 84158 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84159 | 84159 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84160 | 84160 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84161 | 84161 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84162 | 84162 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84163 | 84163 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84164 | 84164 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84165 | 84165 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 84166 | 84166 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-07-25 | 2021-01-01 | 2021-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 69119 | 69119 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 375 |
| 69120 | 69120 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 2000 |
| 69121 | 69121 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 2375 |
| 69122 | 69122 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69123 | 69123 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 2375 |
| 69124 | 69124 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 165.73 | 433.45 |
| 69125 | 69125 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69126 | 69126 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 165.73 | 433.45 |
| 69127 | 69127 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 1039.4 |
| 69128 | 69128 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69129 | 69129 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 165.73 | 1472.85 |
| 69130 | 69130 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 1244.9 | 0 |
| 69131 | 69131 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69132 | 69132 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69133 | 69133 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 165.73 | 0 |
| 69134 | 69134 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 1079.17 | 0 |
| 69135 | 69135 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69136 | 69136 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69137 | 69137 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 3039.4 | 0 |
| 69138 | 69138 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 165.73 | 0 |
| 69139 | 69139 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69140 | 69140 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69141 | 69141 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 165.73 | 0 |
| 69142 | 69142 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69143 | 69143 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69144 | 69144 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69145 | 69145 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69146 | 69146 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69147 | 69147 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69148 | 69148 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69149 | 69149 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 69150 | 69150 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2021-01-26 | 2020-07-01 | 2020-12-31 | 2018-11-06 | SMRY | 0 | 0 |
| 76007 | 76007 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 375 | 375 |
| 76008 | 76008 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 0 | 2000 |
| 76009 | 76009 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 375 | 2375 |
| 76010 | 76010 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 76011 | 76011 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 375 | 2375 |
| 76012 | 76012 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 267.72 | 267.72 |
| 76013 | 76013 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 76014 | 76014 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 267.72 | 267.72 |
| 76015 | 76015 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 0 | 1039.4 |
| 76016 | 76016 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 76017 | 76017 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 267.72 | 1307.12 |
| 76018 | 76018 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 1137.62 | 0 |
| 76019 | 76019 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 375 | 0 |
| 76020 | 76020 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 76021 | 76021 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 267.72 | 0 |
| 76022 | 76022 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 1244.9 | 0 |
| 76023 | 76023 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 76024 | 76024 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 0 | 0 |
| 76025 | 76025 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 3039.4 | 0 |
| 76026 | 76026 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 200 | 0 |
| 76027 | 76027 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 175 | 0 |
| 76028 | 76028 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 375 | 0 |
| 76029 | 76029 | 1408075 170 | Courtney Ruby for Oakland City Auditor 2018 214 | CTL | 2020-07-23 | 2020-01-01 | 2020-06-30 | 2018-11-06 | SMRY | 194.4 | 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");