expenditure_summaries

FPPC Form 460, Schedule D

Data source: D_Expenditure

97 rows where filer_id = 216 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, entity_type, payee_last_name, expenditure_date, year_to_date, expenditure_type, expenditure_description, candidate_last_name, candidate_first_name, incumbent, support_or_oppose, report_date (date), report_start_date (date), report_end_date (date), election_date (date), expenditure_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type payee_last_name payee_first_name payee_prefix payee_suffix payee_city payee_state payee_zipcode expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description committee_id candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number incumbent ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose memo_reference_number
1691 1691 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D69 OTH Carroll Fife             2020-09-26 1000 117397.18 IND Text Messages   Fife Carroll     CCM City of Oakland 3 S       S  
1692 1692 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D70 OTH Rebecca Kaplan             2020-09-26 1000 130844.09 IND Text Messages   Kaplan Rebecca     CCM City of Oakland           S  
1693 1693 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D39 OTH Carroll Fife             2020-09-29 3600 117397.18 IND Video   Fife Carroll     CCM City of Oakland 3 S       S  
1694 1694 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D38 OTH Rebecca Kaplan             2020-09-29 21023.81 130844.09 IND Mailer   Kaplan Rebecca     CCM City of Oakland           S  
1695 1695 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D40 OTH Carroll Fife             2020-09-30 4843.7 117397.18 IND Mailer   Fife Carroll     CCM City of Oakland 3 S       S  
1696 1696 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D41 OTH Carroll Fife             2020-09-30 4104.62 117397.18 IND Doorhanger   Fife Carroll     CCM City of Oakland 3 S       S  
1697 1697 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D43 OTH Carroll Fife             2020-10-01 20150 117397.18 IND Online Advertisements   Fife Carroll     CCM City of Oakland 3 S       S  
1698 1698 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D104 OTH Rebecca Kaplan             2020-10-01 19884.8 130844.09 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
1699 1699 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D42 OTH Carroll Fife             2020-10-05 14744.3 117397.18 IND Mailer   Fife Carroll     CCM City of Oakland 3 S       S  
1700 1700 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D66 OTH Carroll Fife             2020-10-08 7984.7 117397.18 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
1701 1701 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D50 OTH Carroll Fife             2020-10-09 5830.5 117397.18 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
1702 1702 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D48 OTH Carroll Fife             2020-10-09 1750 117397.18 IND Text Messages   Fife Carroll     CCM City of Oakland 3 S       S  
1703 1703 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D51 OTH Rebecca Kaplan             2020-10-09 5830.5 130844.09 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
1704 1704 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D49 OTH Rebecca Kaplan             2020-10-09 1750 130844.09 IND Text Messages   Kaplan Rebecca     CCM City of Oakland           S  
1705 1705 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D54 OTH Rebecca Kaplan             2020-10-10 35000 130844.09 IND Television Advertisements   Kaplan Rebecca     CCM City of Oakland           S  
1706 1706 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D56 OTH Rebecca Kaplan             2020-10-11 1378.06 130844.09 IND Data   Kaplan Rebecca     CCM City of Oakland           S  
1707 1707 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D57 OTH Carroll Fife             2020-10-12 1092.5 117397.18 IND Website   Fife Carroll     CCM City of Oakland 3 S       S  
1708 1708 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D60 OTH Rebecca Kaplan             2020-10-12 6555 130844.09 IND Television Advertisements   Kaplan Rebecca     CCM City of Oakland           S  
1709 1709 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D58 OTH Rebecca Kaplan             2020-10-12 1092.5 130844.09 IND Website   Kaplan Rebecca     CCM City of Oakland           S  
1710 1710 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D55 OTH Carroll Fife             2020-10-13 13547.3 117397.18 IND Mailer   Fife Carroll     CCM City of Oakland 3 S       S  
1711 1711 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D61 OTH Carroll Fife             2020-10-13 1231.26 117397.18 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
1712 1712 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D120 OTH Carroll Fife             2020-10-13 356.78 117397.18 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
1713 1713 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D121 OTH Rebecca Kaplan             2020-10-13 356.78 130844.09 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
1714 1714 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D160 OTH Rebecca Kaplan             2020-10-13 20033.7 130844.09 IND Online Advertising   Kaplan Rebecca     CCM City of Oakland           S  
1715 1715 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D62 OTH Rebecca Kaplan             2020-10-13 1231.27 130844.09 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
1716 1716 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D52 OTH Carroll Fife             2020-10-14 3737.5 117397.18 IND Newspaper Advertisements   Fife Carroll     CCM City of Oakland 3 S       S  
1717 1717 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D53 OTH Rebecca Kaplan             2020-10-14 3737.5 130844.09 IND Newspaper Advertisements   Kaplan Rebecca     CCM City of Oakland           S  
1718 1718 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D67 OTH Carroll Fife             2020-10-15 9537.5 117397.18 IND Online Advertisements   Fife Carroll     CCM City of Oakland 3 S       S  
1719 1719 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D110 OTH Lynette Gibson-McElhaney             2020-10-15 862.5 41640.3 IND Online Advertisements (Cumulative total to date $41640.30)   Gibson-McElhaney Lynette     CCM City of Oakland 3 H       O  
1720 1720 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D68 OTH Lynette Gibson-McElhaney             2020-10-15 17812.5 41640.3 IND Online Advertisements   Gibson-McElhaney Lynette     CCM City of Oakland 3 H       O  
1721 1721 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D119 OTH Rebecca Kaplan             2020-10-15 9563.95 130844.09 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
1722 1722 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D105 OTH Derreck Johnson             2020-10-15 22991.74 22991.74 IND Mailer   Johnson Derreck     CCM City of Oakland           O  
1723 1723 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D64 COM               2020-10-13 1231.27 1588.05 IKD Phone Calls                   The California Schools and Local Communities Funding Act of 2020 15 Statewide S  
1724 1724 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-02-01 2020-09-20 2020-10-17 2020-11-03 D122 COM               2020-10-13 356.78 1588.05 IKD Phone Calls                   The California Schools and Local Communities Funding Act of 2020 15 Statewide S  
1784 1784 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D113 OTH Carroll Fife             2020-10-19 2006.75 126668 IND Doorhanger   Fife Carroll     CCM City of Oakland 3 S       S  
1785 1785 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D117 OTH Carroll Fife             2020-10-19 2262.81 126668 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
1786 1786 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D115 OTH Carroll Fife             2020-10-19 399.47 126668 IND Doorhanger   Fife Carroll     CCM City of Oakland 3 S       S  
1787 1787 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D116 OTH Rebecca Kaplan             2020-10-19 399.47 224049.5 IND Doorhanger   Kaplan Rebecca     CCM City of Oakland           S  
1788 1788 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D114 OTH Rebecca Kaplan             2020-10-19 2006.75 224049.5 IND Doorhanger   Kaplan Rebecca     CCM City of Oakland           S  
1789 1789 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D118 OTH Rebecca Kaplan             2020-10-19 2262.82 224049.5 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
1790 1790 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D161 OTH Carroll Fife             2020-10-20 2098.75 126668 IND Doorhanger   Fife Carroll     CCM City of Oakland 3 S       S  
1791 1791 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D162 OTH Rebecca Kaplan             2020-10-20 2098.75 224049.5 IND Doorhanger   Kaplan Rebecca     CCM City of Oakland           S  
1792 1792 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D124 OTH Rebecca Kaplan             2020-10-21 4481.32 224049.5 IND Text Messages   Kaplan Rebecca     CCM City of Oakland           S  
1793 1793 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D135 OTH Rebecca Kaplan             2020-10-21 731.58 224049.5 IND Voter Data   Kaplan Rebecca     CCM City of Oakland           S  
1794 1794 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D125 OTH Rebecca Kaplan             2020-10-23 3891.33 224049.5 IND Mailer   Kaplan Rebecca     CCM City of Oakland           S  
1795 1795 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D126 OTH Rebecca Kaplan             2020-10-23 58823 224049.5 IND Television Advertisements   Kaplan Rebecca     CCM City of Oakland           S  
1796 1796 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D136 OTH Rebecca Kaplan             2020-10-28 12407.45 224049.5 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
1797 1797 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D137 OTH Carroll Fife             2020-10-29 2262.82 126668 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
1798 1798 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D138 OTH Rebecca Kaplan             2020-10-29 2262.81 224049.5 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
1799 1799 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D140 OTH Carroll Fife             2020-10-30 1861.44 126668 IND Phone Calls (Cumulative to date total $198234.60 / $123784.25)   Fife Carroll     CCM City of Oakland 3 S       S  
1800 1800 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D143 OTH Rebecca Kaplan             2020-10-30 447.9 224049.5 IND Text Messages (Cumulative total to date $198234.60)   Kaplan Rebecca     CCM City of Oakland           S  
1801 1801 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D141 OTH Rebecca Kaplan             2020-10-30 1861.44 224049.5 IND Phone Calls (Cumulative to date total $198234.60 / $123784.25)   Kaplan Rebecca     CCM City of Oakland           S  
1802 1802 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D144 OTH Rebecca Kaplan             2020-10-30 937.01 224049.5 IND Data (Cumulative total to date $198234.60)   Kaplan Rebecca     CCM City of Oakland           S  
1803 1803 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D146 OTH Rebecca Kaplan             2020-11-01 3000 224049.5 IND Phone Calls (Estimate) - (Cumulative total to date $201917.05)   Kaplan Rebecca     CCM City of Oakland           S  
1804 1804 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2021-01-29 2020-10-18 2020-12-31 2020-11-03 D147 OTH Carroll Fife             2020-11-03 785 126668 IND Text Messages (Estimate - Cumulative total to date $124569.25)   Fife Carroll     CCM City of Oakland 3 S       S  
2036 2036 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D69 OTH Carroll Fife             2020-09-26 1000 117397.18 IND Text Messages   Fife Carroll     CCM City of Oakland 3 S       S  
2037 2037 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D70 OTH Rebecca Kaplan             2020-09-26 1000 110810.39 IND Text Messages   Kaplan Rebecca     CCM City of Oakland           S  
2038 2038 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D39 OTH Carroll Fife             2020-09-29 3600 117397.18 IND Video   Fife Carroll     CCM City of Oakland 3 S       S  
2039 2039 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D38 OTH Rebecca Kaplan             2020-09-29 21023.81 110810.39 IND Mailer   Kaplan Rebecca     CCM City of Oakland           S  
2040 2040 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D41 OTH Carroll Fife             2020-09-30 4104.62 117397.18 IND Doorhanger   Fife Carroll     CCM City of Oakland 3 S       S  
2041 2041 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D40 OTH Carroll Fife             2020-09-30 4843.7 117397.18 IND Mailer   Fife Carroll     CCM City of Oakland 3 S       S  
2042 2042 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D43 OTH Carroll Fife             2020-10-01 20150 117397.18 IND Online Advertisements   Fife Carroll     CCM City of Oakland 3 S       S  
2043 2043 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D104 OTH Rebecca Kaplan             2020-10-01 19884.8 110810.39 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
2044 2044 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D42 OTH Carroll Fife             2020-10-05 14744.3 117397.18 IND Mailer   Fife Carroll     CCM City of Oakland 3 S       S  
2045 2045 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D66 OTH Carroll Fife             2020-10-08 7984.7 117397.18 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
2046 2046 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D50 OTH Carroll Fife             2020-10-09 5830.5 117397.18 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
2047 2047 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D48 OTH Carroll Fife             2020-10-09 1750 117397.18 IND Text Messages   Fife Carroll     CCM City of Oakland 3 S       S  
2048 2048 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D51 OTH Rebecca Kaplan             2020-10-09 5830.5 110810.39 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
2049 2049 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D49 OTH Rebecca Kaplan             2020-10-09 1750 110810.39 IND Text Messages   Kaplan Rebecca     CCM City of Oakland           S  
2050 2050 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D54 OTH Rebecca Kaplan             2020-10-10 35000 110810.39 IND Television Advertisements   Kaplan Rebecca     CCM City of Oakland           S  
2051 2051 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D56 OTH Rebecca Kaplan             2020-10-11 1378.06 110810.39 IND Data   Kaplan Rebecca     CCM City of Oakland           S  
2052 2052 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D57 OTH Carroll Fife             2020-10-12 1092.5 117397.18 IND Website   Fife Carroll     CCM City of Oakland 3 S       S  
2053 2053 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D60 OTH Rebecca Kaplan             2020-10-12 6555 110810.39 IND Television Advertisements   Kaplan Rebecca     CCM City of Oakland           S  
2054 2054 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D58 OTH Rebecca Kaplan             2020-10-12 1092.5 110810.39 IND Website   Kaplan Rebecca     CCM City of Oakland           S  
2055 2055 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D55 OTH Carroll Fife             2020-10-13 13547.3 117397.18 IND Mailer   Fife Carroll     CCM City of Oakland 3 S       S  
2056 2056 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D61 OTH Carroll Fife             2020-10-13 1231.26 117397.18 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
2057 2057 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D120 OTH Carroll Fife             2020-10-13 356.78 117397.18 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
2058 2058 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D121 OTH Rebecca Kaplan             2020-10-13 356.78 110810.39 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
2059 2059 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D62 OTH Rebecca Kaplan             2020-10-13 1231.27 110810.39 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
2060 2060 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D52 OTH Carroll Fife             2020-10-14 3737.5 117397.18 IND Newspaper Advertisements   Fife Carroll     CCM City of Oakland 3 S       S  
2061 2061 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D53 OTH Rebecca Kaplan             2020-10-14 3737.5 110810.39 IND Newspaper Advertisements   Kaplan Rebecca     CCM City of Oakland           S  
2062 2062 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D67 OTH Carroll Fife             2020-10-15 9537.5 117397.18 IND Online Advertisements   Fife Carroll     CCM City of Oakland 3 S       S  
2063 2063 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D110 OTH Lynette Gibson-McElhaney             2020-10-15 862.5 41640.3 IND Online Advertisements   Gibson-McElhaney Lynette     CCM City of Oakland 3 H       O  
2064 2064 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D68 OTH Lynette Gibson-McElhaney             2020-10-15 17812.5 41640.3 IND Online Advertisements   Gibson-McElhaney Lynette     CCM City of Oakland 3 H       O  
2065 2065 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D119 OTH Rebecca Kaplan             2020-10-15 9563.95 110810.39 IND Phone Calls   Kaplan Rebecca     CCM City of Oakland           S  
2066 2066 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D105 OTH Derreck Johnson             2020-10-15 22991.74 22991.74 IND Mailer   Johnson Derreck     CCM City of Oakland           O  
2067 2067 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D64 COM               2020-10-13 1231.27 1588.05 IKD Phone Calls                   The California Schools and Local Communities Funding Act of 2020 15 Statewide S  
2068 2068 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-10-22 2020-09-20 2020-10-17 2020-11-03 D122 COM               2020-10-13 356.78 1588.05 IKD Phone Calls                   The California Schools and Local Communities Funding Act of 2020 15 Statewide S  
2315 2315 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D25 OTH Carroll Fife             2020-08-18 1880.37 21480.3 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
2316 2316 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D26 OTH Lynette Gibson-McElhaney             2020-08-18 1880.38 22965.3 IND Phone Calls   Gibson-McElhaney Lynette     CCM City of Oakland 3 H       O  
2317 2317 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D27 OTH Carroll Fife             2020-08-28 2940.63 21480.3 IND Phone Calls   Fife Carroll     CCM City of Oakland 3 S       S  
2318 2318 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D28 OTH Lynette Gibson-McElhaney             2020-08-28 2940.62 22965.3 IND Phone Calls   Gibson-McElhaney Lynette     CCM City of Oakland 3 H       O  
2319 2319 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D5 OTH Carroll Fife             2020-09-10 14744.3 21480.3 IND Mailer   Fife Carroll     CCM City of Oakland 3 S       S  
2320 2320 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D8 OTH Carroll Fife             2020-09-10 650 21480.3 IND Video   Fife Carroll     CCM City of Oakland 3 S       S  
2321 2321 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D17 OTH Carroll Fife             2020-09-15 1265 21480.3 IND Website   Fife Carroll     CCM City of Oakland 3 S       S  
2322 2322 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D20 OTH Lynette Gibson-McElhaney             2020-09-18 3400 22965.3 IND Voter Data   Gibson-McElhaney Lynette     CCM City of Oakland 3 H       O  
2323 2323 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife and Rebecca Kaplan to the Oakland City Council, spnsored by Alameda Labor Council, AFL-CIO 273 RCP 2020-09-23 2020-01-01 2020-09-19 2020-11-03 D18 OTH Lynette Gibson-McElhaney             2020-09-18 14744.3 22965.3 IND Mailer   Gibson-McElhaney Lynette     CCM City of Oakland 3 H       O  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "expenditure_summaries" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "committee_type" TEXT,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "payee_last_name" TEXT,
  "payee_first_name" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "committee_id" INTEGER,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT,
  "incumbent" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "memo_reference_number" TEXT
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id));
CREATE INDEX ["expenditure_summaries_filer_id"] ON [expenditure_summaries]("filer_id");
CREATE INDEX ["expenditure_summaries_filer_name"] ON [expenditure_summaries]("filer_name");
CREATE INDEX ["expenditure_summaries_committee_id"] ON [expenditure_summaries]("committee_id");