summaries
Data source: Summary
527 rows where filer_name = 425 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 129406 | 129406 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | -5150 | -5150 |
| 129407 | 129407 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 43500 |
| 129408 | 129408 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | -5150 | 38350 |
| 129409 | 129409 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129410 | 129410 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | -5150 | 38350 |
| 129411 | 129411 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 3174.33 | 3174.33 |
| 129412 | 129412 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129413 | 129413 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 3174.33 | 3174.33 |
| 129414 | 129414 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129415 | 129415 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129416 | 129416 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 3174.33 | 3174.33 |
| 129417 | 129417 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 9888.83 | 0 |
| 129418 | 129418 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | -5150 | 0 |
| 129419 | 129419 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129420 | 129420 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 3174.33 | 0 |
| 129421 | 129421 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 1564.5 | 0 |
| 129422 | 129422 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129423 | 129423 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129424 | 129424 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 43500 | 0 |
| 129425 | 129425 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | -5100 | 0 |
| 129426 | 129426 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | -50 | 0 |
| 129427 | 129427 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | -5150 | 0 |
| 129428 | 129428 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129429 | 129429 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129430 | 129430 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129431 | 129431 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129432 | 129432 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129433 | 129433 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129434 | 129434 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129435 | 129435 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129436 | 129436 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129437 | 129437 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 3075 | 0 |
| 129438 | 129438 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 99.33 | 0 |
| 129439 | 129439 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129440 | 129440 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 3174.33 | 0 |
| 129441 | 129441 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129442 | 129442 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129443 | 129443 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129444 | 129444 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129445 | 129445 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129446 | 129446 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129447 | 129447 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129448 | 129448 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129449 | 129449 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 129450 | 129450 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-07-25 | 2025-01-01 | 2025-06-30 | 2024-11-05 | SMRY | 0 | 0 |
| 116027 | 116027 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 8962.82 | 75627.82 |
| 116028 | 116028 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 5500 | 43500 |
| 116029 | 116029 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 14462.82 | 119127.82 |
| 116030 | 116030 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116031 | 116031 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 14462.82 | 119127.82 |
| 116032 | 116032 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 99673.48 | 128546.02 |
| 116033 | 116033 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116034 | 116034 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 99673.48 | 128546.02 |
| 116035 | 116035 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | -60424.51 | 0 |
| 116036 | 116036 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116037 | 116037 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 39248.97 | 128546.02 |
| 116038 | 116038 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 95359.49 | 0 |
| 116039 | 116039 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 14462.82 | 0 |
| 116040 | 116040 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116041 | 116041 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 99673.48 | 0 |
| 116042 | 116042 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 10148.83 | 0 |
| 116043 | 116043 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116044 | 116044 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116045 | 116045 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 43500 | 0 |
| 116046 | 116046 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 8712.82 | 0 |
| 116047 | 116047 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 250 | 0 |
| 116048 | 116048 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 8962.82 | 0 |
| 116049 | 116049 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 5500 | 0 |
| 116050 | 116050 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116051 | 116051 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 5500 | 0 |
| 116052 | 116052 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116053 | 116053 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116054 | 116054 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116055 | 116055 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 3000 | 0 |
| 116056 | 116056 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116057 | 116057 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 3000 | 0 |
| 116058 | 116058 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 99673.48 | 0 |
| 116059 | 116059 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116060 | 116060 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116061 | 116061 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 99673.48 | 0 |
| 116062 | 116062 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116063 | 116063 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 60424.51 | 0 |
| 116064 | 116064 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | -60424.51 | 0 |
| 116065 | 116065 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116066 | 116066 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116067 | 116067 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116068 | 116068 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116069 | 116069 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116070 | 116070 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 116071 | 116071 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | SMRY | 0 | 0 |
| 112715 | 112715 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 21706 | 66665 |
| 112716 | 112716 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 38000 |
| 112717 | 112717 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 21706 | 104665 |
| 112718 | 112718 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112719 | 112719 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 21706 | 104665 |
| 112720 | 112720 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 4259.63 | 28872.54 |
| 112721 | 112721 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 0 | 0 |
| 112722 | 112722 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 4259.63 | 28872.54 |
| 112723 | 112723 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | SMRY | 46078.68 | 60424.51 |
| 112724 | 112724 | 1462429 313 | Ryan Richardson for Oakland City Attorney 2024 425 | CTL | 2024-12-20 | 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");