summaries
Data source: Summary
360 rows where filer_id = 206 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 82257 | 82257 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 35234 | 46985 |
| 82258 | 82258 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82259 | 82259 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 35234 | 46985 |
| 82260 | 82260 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 900 | 900 |
| 82261 | 82261 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 36134 | 47885 |
| 82262 | 82262 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 61878.59 | 63554.1 |
| 82263 | 82263 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82264 | 82264 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 61878.59 | 63554.1 |
| 82265 | 82265 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82266 | 82266 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 900 | 900 |
| 82267 | 82267 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 62778.59 | 64454.1 |
| 82268 | 82268 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 20690.83 | 0 |
| 82269 | 82269 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 35234 | 0 |
| 82270 | 82270 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 5953.76 | 0 |
| 82271 | 82271 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 61878.59 | 0 |
| 82272 | 82272 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82273 | 82273 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82274 | 82274 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82275 | 82275 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82276 | 82276 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 32546 | 0 |
| 82277 | 82277 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 2688 | 0 |
| 82278 | 82278 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 35234 | 0 |
| 82279 | 82279 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82280 | 82280 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82281 | 82281 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82282 | 82282 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 900 | 0 |
| 82283 | 82283 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82284 | 82284 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 900 | 0 |
| 82285 | 82285 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 40147.47 | 0 |
| 82286 | 82286 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82287 | 82287 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 40147.47 | 0 |
| 82288 | 82288 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 61828.59 | 0 |
| 82289 | 82289 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 50 | 0 |
| 82290 | 82290 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82291 | 82291 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 61878.59 | 0 |
| 82292 | 82292 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82293 | 82293 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82294 | 82294 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82295 | 82295 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82296 | 82296 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82297 | 82297 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82298 | 82298 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 5952.63 | 0 |
| 82299 | 82299 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 1.13 | 0 |
| 82300 | 82300 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 0 | 0 |
| 82301 | 82301 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-29 | 2021-07-01 | 2021-12-27 | 2022-11-08 | SMRY | 5953.76 | 0 |
| 64728 | 64728 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 4300 | 4300 |
| 64729 | 64729 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64730 | 64730 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 4300 | 4300 |
| 64731 | 64731 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64732 | 64732 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 4300 | 4300 |
| 64733 | 64733 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 795.59 | 795.59 |
| 64734 | 64734 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64735 | 64735 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 795.59 | 795.59 |
| 64736 | 64736 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64737 | 64737 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64738 | 64738 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 795.59 | 795.59 |
| 64739 | 64739 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 7344.5 | 0 |
| 64740 | 64740 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 4300 | 0 |
| 64741 | 64741 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0.47 | 0 |
| 64742 | 64742 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 795.59 | 0 |
| 64743 | 64743 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 10849.38 | 0 |
| 64744 | 64744 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64745 | 64745 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64746 | 64746 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64747 | 64747 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 4300 | 0 |
| 64748 | 64748 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64749 | 64749 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 4300 | 0 |
| 64750 | 64750 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64751 | 64751 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64752 | 64752 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64753 | 64753 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64754 | 64754 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64755 | 64755 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64756 | 64756 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 500 | 0 |
| 64757 | 64757 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64758 | 64758 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 500 | 0 |
| 64759 | 64759 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 795.59 | 0 |
| 64760 | 64760 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64761 | 64761 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64762 | 64762 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 795.59 | 0 |
| 64763 | 64763 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64764 | 64764 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64765 | 64765 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64766 | 64766 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64767 | 64767 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64768 | 64768 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64769 | 64769 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64770 | 64770 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0.47 | 0 |
| 64771 | 64771 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 64772 | 64772 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-12-06 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0.47 | 0 |
| 78114 | 78114 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 11751 | 11751 |
| 78115 | 78115 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 78116 | 78116 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 11751 | 11751 |
| 78117 | 78117 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 78118 | 78118 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 11751 | 11751 |
| 78119 | 78119 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 1675.51 | 1675.51 |
| 78120 | 78120 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 78121 | 78121 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 1675.51 | 1675.51 |
| 78122 | 78122 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 78123 | 78123 | 1417608 206 | Sheng Thao for Oakland City Council 2022 262 | CTL | 2021-10-11 | 2021-01-01 | 2021-06-30 | 2022-11-08 | 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");