summaries
Data source: Summary
405 rows where filer_name = 211 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_date, election_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 83056 | 83056 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 600 | 600 | |
| 83057 | 83057 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 800 | |
| 83058 | 83058 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 600 | 1400 | |
| 83059 | 83059 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83060 | 83060 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 600 | 1400 | |
| 83061 | 83061 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 1611 | 1611 | |
| 83062 | 83062 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83063 | 83063 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 1611 | 1611 | |
| 83064 | 83064 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83065 | 83065 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83066 | 83066 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 1611 | 1611 | |
| 83067 | 83067 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 2034.81 | 0 | |
| 83068 | 83068 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 600 | 0 | |
| 83069 | 83069 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0.12 | 0 | |
| 83070 | 83070 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 1611 | 0 | |
| 83071 | 83071 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 1023.93 | 0 | |
| 83072 | 83072 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83073 | 83073 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83074 | 83074 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 800 | 0 | |
| 83075 | 83075 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 600 | 0 | |
| 83076 | 83076 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83077 | 83077 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 600 | 0 | |
| 83078 | 83078 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83079 | 83079 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83080 | 83080 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83081 | 83081 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83082 | 83082 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83083 | 83083 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83084 | 83084 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83085 | 83085 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83086 | 83086 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83087 | 83087 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 1434 | 0 | |
| 83088 | 83088 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 177 | 0 | |
| 83089 | 83089 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83090 | 83090 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 1611 | 0 | |
| 83091 | 83091 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83092 | 83092 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83093 | 83093 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83094 | 83094 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83095 | 83095 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83096 | 83096 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83097 | 83097 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83098 | 83098 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0.12 | 0 | |
| 83099 | 83099 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0 | 0 | |
| 83100 | 83100 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-08-02 | 2021-01-01 | 2021-06-30 | SMRY | 0.12 | 0 | |
| 67950 | 67950 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 600 | |
| 67951 | 67951 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 800 | |
| 67952 | 67952 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 1400 | |
| 67953 | 67953 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67954 | 67954 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 1400 | |
| 67955 | 67955 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 2116.68 | 4795.58 | |
| 67956 | 67956 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67957 | 67957 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 2116.68 | 4795.58 | |
| 67958 | 67958 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67959 | 67959 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67960 | 67960 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 2116.68 | 4795.58 | |
| 67961 | 67961 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 4151.3 | 0 | |
| 67962 | 67962 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67963 | 67963 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0.19 | 0 | |
| 67964 | 67964 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 2116.68 | 0 | |
| 67965 | 67965 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 2034.81 | 0 | |
| 67966 | 67966 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67967 | 67967 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67968 | 67968 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 800 | 0 | |
| 67969 | 67969 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67970 | 67970 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67971 | 67971 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67972 | 67972 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67973 | 67973 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67974 | 67974 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67975 | 67975 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67976 | 67976 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67977 | 67977 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67978 | 67978 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67979 | 67979 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67980 | 67980 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67981 | 67981 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 2091.99 | 0 | |
| 67982 | 67982 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 24.69 | 0 | |
| 67983 | 67983 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67984 | 67984 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 2116.68 | 0 | |
| 67985 | 67985 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67986 | 67986 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67987 | 67987 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67988 | 67988 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67989 | 67989 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67990 | 67990 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67991 | 67991 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67992 | 67992 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0.19 | 0 | |
| 67993 | 67993 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0 | 0 | |
| 67994 | 67994 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2021-03-16 | 2020-07-01 | 2020-12-31 | SMRY | 0.19 | 0 | |
| 75260 | 75260 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 600 | 600 |
| 75261 | 75261 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 800 |
| 75262 | 75262 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 600 | 1400 |
| 75263 | 75263 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 75264 | 75264 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 600 | 1400 |
| 75265 | 75265 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 2678.9 | 2678.9 |
| 75266 | 75266 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 75267 | 75267 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 2678.9 | 2678.9 |
| 75268 | 75268 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-06-30 | 2022-11-08 | SMRY | 0 | 0 |
| 75269 | 75269 | 1405456 169 | Sheng Thao for Oakland City Council 2018 211 | CTL | 2020-07-29 | 2020-01-01 | 2020-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");