ie_reports_24_hours

FPPC Form 496

Data source: 496

81 rows where filer_id = 216 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, report_start_date, report_end_date, expenditure_date, expenditure_description, support_or_oppose, candidate_last_name, candidate_first_name, district_number, 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 amount expenditure_date expenditure_description memo_reference_number ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number
985 985 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 316 RCP 2021-02-01 2020-10-13 2020-10-13 2020-11-03 S496-160 20033.7 2020-10-13 ONLINE ADVERTISING         S Kaplan Rebecca     City Council Member City of Oakland  
986 986 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 316 RCP 2021-02-01 2020-10-13 2020-10-13 2020-11-03 S496-121 1588.05 2020-10-13 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
992 992 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 316 RCP 2021-02-01 2020-10-20 2020-10-20 2020-11-03 S496-161 2098.75 2020-10-20 DOORHANGER         S Fife Carroll     City Council Member City of Oakland 3.0
993 993 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 316 RCP 2021-02-01 2020-10-20 2020-10-20 2020-11-03 S496-162 2098.75 2020-10-20 DOORHANGER         S Kaplan Rebecca     City Council Member City of Oakland  
640 640 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 316 RCP 2020-11-03 2020-11-03 2020-11-03 2020-11-03 S496-147 785 2020-11-03 TEXT MESSAGES (ESTIMATE - CUMULATIVE TOTAL TO DATE $124569.25)         S Fife Carroll     City Council Member City of Oakland 3
624 624 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 316 RCP 2020-11-02 2020-10-28 2020-10-28 2020-11-03 S496-136 12407.45 2020-10-28 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
641 641 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 316 RCP 2020-11-02 2020-11-01 2020-11-01 2020-11-03 S496-146 3000 2020-11-01 PHONE CALLS (ESTIMATE) - (CUMULATIVE TOTAL TO DATE $201917.05)         S Kaplan Rebecca     City Council Member City of Oakland  
614 614 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 316 RCP 2020-10-30 2020-10-15 2020-10-15 2020-11-03 S496-110 862.5 2020-10-15 ONLINE ADVERTISEMENTS (CUMULATIVE TOTAL TO DATE $41640.30)         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
625 625 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 316 RCP 2020-10-30 2020-10-30 2020-10-30 2020-11-03 S496-140 1861.44 2020-10-30 PHONE CALLS (CUMULATIVE TO DATE TOTAL $123784.25)         S Fife Carroll     City Council Member City of Oakland 3
626 626 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 316 RCP 2020-10-30 2020-10-30 2020-10-30 2020-11-03 S496-144 937.01 2020-10-30 DATA (CUMULATIVE TOTAL TO DATE $198234.60)         S Kaplan Rebecca     City Council Member City of Oakland  
627 627 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 316 RCP 2020-10-30 2020-10-30 2020-10-30 2020-11-03 S496-141 1861.44 2020-10-30 PHONE CALLS (CUMULATIVE TO DATE TOTAL $198234.60)         S Kaplan Rebecca     City Council Member City of Oakland  
628 628 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 316 RCP 2020-10-30 2020-10-30 2020-10-30 2020-11-03 S496-143 447.9 2020-10-30 TEXT MESSAGES (CUMULATIVE TOTAL TO DATE $198234.60)         S Kaplan Rebecca     City Council Member City of Oakland  
646 646 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 316 RCP 2020-10-30 2020-10-30 2020-10-30 2020-11-03 S496-144 937.01 2020-10-30 DATA         S Kaplan Rebecca     City Council Member City of Oakland  
647 647 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 316 RCP 2020-10-30 2020-10-30 2020-10-30 2020-11-03 S496-141 1861.44 2020-10-30 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
648 648 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 316 RCP 2020-10-30 2020-10-30 2020-10-30 2020-11-03 S496-143 447.9 2020-10-30 TEXT MESSAGES         S Kaplan Rebecca     City Council Member City of Oakland  
649 649 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 316 RCP 2020-10-30 2020-10-30 2020-10-30 2020-11-03 S496-140 1861.44 2020-10-30 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
671 671 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 316 RCP 2020-10-29 2020-10-29 2020-10-29 2020-11-03 S496-138 2262.81 2020-10-29 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
672 672 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 316 RCP 2020-10-29 2020-10-29 2020-10-29 2020-11-03 S496-137 2262.82 2020-10-29 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
673 673 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 316 RCP 2020-10-29 2020-10-28 2020-10-28 2020-11-03 S496-136 11725 2020-10-28 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
616 616 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 316 RCP 2020-10-27 2020-10-19 2020-10-19 2020-11-03 S496-116 2406.22 2020-10-19 DOORHANGER         S Kaplan Rebecca     City Council Member City of Oakland  
617 617 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 316 RCP 2020-10-27 2020-10-19 2020-10-19 2020-11-03 S496-118 2262.82 2020-10-19 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
618 618 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 316 RCP 2020-10-27 2020-10-19 2020-10-19 2020-11-03 S496-115 2406.22 2020-10-19 DOORHANGER         S Fife Carroll     City Council Member City of Oakland 3
619 619 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 316 RCP 2020-10-27 2020-10-19 2020-10-19 2020-11-03 S496-117 2262.81 2020-10-19 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
620 620 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 316 RCP 2020-10-27 2020-10-21 2020-10-21 2020-11-03 S496-124 4481.32 2020-10-21 TEXT MESSAGES         S Kaplan Rebecca     City Council Member City of Oakland  
621 621 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 316 RCP 2020-10-27 2020-10-21 2020-10-21 2020-11-03 S496-135 731.58 2020-10-21 VOTER DATA         S Kaplan Rebecca     City Council Member City of Oakland  
693 693 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 316 RCP 2020-10-23 2020-10-23 2020-10-23 2020-11-03 S496-125 3891.33 2020-10-23 MAILER         S Kaplan Rebecca     City Council Member City of Oakland  
694 694 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 316 RCP 2020-10-23 2020-10-23 2020-10-23 2020-11-03 S496-126 58823 2020-10-23 TELEVISION ADVERTISEMENTS         S Kaplan Rebecca     City Council Member City of Oakland  
591 591 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 316 RCP 2020-10-22 2020-10-01 2020-10-01 2020-11-03 S496-104 19884.8 2020-10-01 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
607 607 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 316 RCP 2020-10-22 2020-10-13 2020-10-13 2020-11-03 S496-120 1588.04 2020-10-13 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
608 608 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 316 RCP 2020-10-22 2020-10-13 2020-10-13 2020-11-03 S496-121 1588.05 2020-10-13 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
615 615 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 316 RCP 2020-10-22 2020-10-15 2020-10-15 2020-11-03 S496-119 9563.95 2020-10-15 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
709 709 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 316 RCP 2020-10-22 2020-10-21 2020-10-21 2020-11-03 S496-124 4750 2020-10-21 TEXT MESSAGES         S Kaplan Rebecca     City Council Member City of Oakland  
724 724 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 316 RCP 2020-10-20 2020-10-19 2020-10-19 2020-11-03 S496-118 2428.6 2020-10-19 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
725 725 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 316 RCP 2020-10-20 2020-10-19 2020-10-19 2020-11-03 S496-117 2428.6 2020-10-19 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
728 728 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 316 RCP 2020-10-20 2020-10-19 2020-10-19 2020-11-03 S496-116 2406.22 2020-10-19 DOORHANGER         S Kaplan Rebecca     City Council Member City of Oakland  
729 729 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 316 RCP 2020-10-20 2020-10-19 2020-10-19 2020-11-03 S496-115 2406.22 2020-10-19 DOORHANGER         S Fife Carroll     City Council Member City of Oakland 3
776 776 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 316 RCP 2020-10-16 2020-10-15 2020-10-15 2020-11-03 S496-111 11125.8 2020-10-15 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
777 777 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 316 RCP 2020-10-16 2020-10-15 2020-10-15 2020-11-03 S496-105 22991.74 2020-10-15 MAILER         O Johnson Derreck     City Council Member City of Oakland  
778 778 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 316 RCP 2020-10-16 2020-10-15 2020-10-15 2020-11-03 S496-110 862.5 2020-10-15 ONLINE ADVERTISEMENTS         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
590 590 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 316 RCP 2020-10-15 2020-10-01 2020-10-01 2020-11-03 S496-43 20150 2020-10-01 ONLINE ADVERTISEMENTS         S Fife Carroll     City Council Member City of Oakland 3
600 600 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 316 RCP 2020-10-15 2020-10-08 2020-10-08 2020-11-03 S496-66 7984.7 2020-10-08 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
788 788 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 316 RCP 2020-10-15 2020-10-15 2020-10-15 2020-11-03 S496-67 9537.5 2020-10-15 ONLINE ADVERTISEMENTS         S Fife Carroll     City Council Member City of Oakland 3
789 789 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 316 RCP 2020-10-15 2020-10-15 2020-10-15 2020-11-03 S496-68 17812.5 2020-10-15 ONLINE ADVERTISEMENTS         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
801 801 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 316 RCP 2020-10-13 2020-10-13 2020-10-13 2020-11-03 S496-62 1231.27 2020-10-13 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
802 802 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 316 RCP 2020-10-13 2020-10-13 2020-10-13 2020-11-03 S496-61 1231.27 2020-10-13 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
810 810 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 316 RCP 2020-10-12 2020-10-12 2020-10-12 2020-11-03 S496-60 6555 2020-10-12 TELEVISION ADVERTISEMENTS         S Kaplan Rebecca     City Council Member City of Oakland  
811 811 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 316 RCP 2020-10-12 2020-10-12 2020-10-12 2020-11-03 S496-56 1378.06 2020-10-12 DATA         S Kaplan Rebecca     City Council Member City of Oakland  
812 812 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 316 RCP 2020-10-12 2020-10-12 2020-10-12 2020-11-03 S496-58 1092.5 2020-10-12 WEBSITE         S Kaplan Rebecca     City Council Member City of Oakland  
813 813 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 316 RCP 2020-10-12 2020-10-13 2020-10-13 2020-11-03 S496-55 13547.3 2020-10-13 MAILER         S Fife Carroll     City Council Member City of Oakland 3
814 814 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 316 RCP 2020-10-12 2020-10-12 2020-10-12 2020-11-03 S496-57 1092.5 2020-10-12 WEBSITE         S Fife Carroll     City Council Member City of Oakland 3
821 821 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 316 RCP 2020-10-09 2020-10-09 2020-10-09 2020-11-03 S496-50 5830.5 2020-10-09 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
822 822 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 316 RCP 2020-10-09 2020-10-09 2020-10-09 2020-11-03 S496-51 5830.5 2020-10-09 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
823 823 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 316 RCP 2020-10-09 2020-10-14 2020-10-14 2020-11-03 S496-53 3737.5 2020-10-14 NEWSPAPER ADVERTISEMENTS         S Kaplan Rebecca     City Council Member City of Oakland  
824 824 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 316 RCP 2020-10-09 2020-10-14 2020-10-14 2020-11-03 S496-52 3737.5 2020-10-14 NEWSPAPER ADVERTISEMENTS         S Fife Carroll     City Council Member City of Oakland 3
825 825 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 316 RCP 2020-10-09 2020-10-10 2020-10-10 2020-11-03 S496-54 35000 2020-10-10 TELEVISION ADVERTISEMENTS         S Kaplan Rebecca     City Council Member City of Oakland  
826 826 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 316 RCP 2020-10-09 2020-10-09 2020-10-09 2020-11-03 S496-49 1750 2020-10-09 TEXT MESSAGES         S Kaplan Rebecca     City Council Member City of Oakland  
827 827 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 316 RCP 2020-10-09 2020-10-09 2020-10-09 2020-11-03 S496-48 1750 2020-10-09 TEXT MESSAGES         S Fife Carroll     City Council Member City of Oakland 3
840 840 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 316 RCP 2020-10-08 2020-10-08 2020-10-08 2020-11-03 S496-47 11491.88 2020-10-08 PHONE CALLS (ESTIMATE)         S Fife Carroll     City Council Member City of Oakland 3
876 876 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 316 RCP 2020-10-02 2020-10-01 2020-10-01 2020-11-03 S496-44 26993.45 2020-10-01 PHONE CALLS         S Kaplan Rebecca     City Council Member City of Oakland  
877 877 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 316 RCP 2020-10-02 2020-10-01 2020-10-01 2020-11-03 S496-43 47500 2020-10-01 ONLINE ADVERTISEMENTS         S Fife Carroll     City Council Member City of Oakland 3
899 899 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 316 RCP 2020-09-30 2020-10-05 2020-10-05 2020-11-03 S496-42 14744.3 2020-10-05 MAILER         S Fife Carroll     City Council Member City of Oakland 3
900 900 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 316 RCP 2020-09-30 2020-09-30 2020-09-30 2020-11-03 S496-41 4104.62 2020-09-30 DOORHANGER         S Fife Carroll     City Council Member City of Oakland 3
901 901 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 316 RCP 2020-09-30 2020-09-30 2020-09-30 2020-11-03 S496-40 4843.7 2020-09-30 MAILER         S Fife Carroll     City Council Member City of Oakland 3
902 902 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 316 RCP 2020-09-29 2020-09-29 2020-09-29 2020-11-03 S496-38 21023.81 2020-09-29 MAILER         S Kaplan Rebecca     City Council Member City of Oakland  
903 903 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 316 RCP 2020-09-29 2020-09-29 2020-09-29 2020-11-03 S496-39 3600 2020-09-29 VIDEO         S Fife Carroll     City Council Member City of Oakland 3
921 921 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 316 RCP 2020-09-25 2020-09-26 2020-09-26 2020-11-03 S496-37 1000 2020-09-26 TEXT MESSAGES         S Kaplan Rebecca     City Council Member City of Oakland  
922 922 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 316 RCP 2020-09-25 2020-09-24 2020-09-24 2020-11-03 S496-36 14744.3 2020-09-24 MAILER         S Fife Carroll     City Council Member City of Oakland 3
925 925 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 316 RCP 2020-09-24 2020-09-23 2020-09-23 2020-11-03 S496-35 1000 2020-09-23 TEXT MESSAGES         S Fife Carroll     City Council Member City of Oakland 3
928 928 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 316 RCP 2020-09-18 2020-09-18 2020-09-18 2020-11-03 S496-18 14744.3 2020-09-17 MAILER         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
929 929 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 316 RCP 2020-09-18 2020-09-18 2020-09-18 2020-11-03 S496-20 3400 2020-09-18 VOTER DATA         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
963 963 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 316 RCP 2020-09-15 2020-09-15 2020-09-15 2020-11-03 S496-17 1265 2020-09-15 WEBSITE         S Fife Carroll     City Council Member City of Oakland 3
964 964 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 316 RCP 2020-09-11 2020-09-10 2020-09-10 2020-11-03 S496-5 14744.3 2020-09-10 MAILER         S Fife Carroll     City Council Member City of Oakland 3
965 965 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 316 RCP 2020-09-11 2020-09-10 2020-09-10 2020-11-03 S496-8 650 2020-09-10 VIDEO         S Fife Carroll     City Council Member City of Oakland 3
582 582 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 316 RCP 2020-09-08 2020-08-18 2020-08-18 2020-11-03 S496-1 1880.37 2020-08-18 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
583 583 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 316 RCP 2020-09-08 2020-08-18 2020-08-18 2020-11-03 S496-2 1880.38 2020-08-18 PHONE CALLS         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
584 584 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 316 RCP 2020-09-08 2020-08-28 2020-08-28 2020-11-03 S496-4 2940.63 2020-08-28 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
585 585 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 316 RCP 2020-09-08 2020-08-28 2020-08-28 2020-11-03 S496-3 2940.62 2020-08-28 PHONE CALLS         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
970 970 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 316 RCP 2020-08-29 2020-08-28 2020-08-28 2020-11-03 S496-3 3000 2020-08-28 PHONE CALLS         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
971 971 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 316 RCP 2020-08-29 2020-08-28 2020-08-28 2020-11-03 S496-4 3000 2020-08-28 PHONE CALLS         S Fife Carroll     City Council Member City of Oakland 3
972 972 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife to the Oakland City Council spnsored by Alameda Labor Council AFL-CIO 320 RCP 2020-08-19 2020-08-18 2020-08-18 2020-11-03 S496-2 2487.5 2020-08-18 PHONE CALLS (ESTIMATE)         O Gibson-McElhaney Lynette     City Council Member City of Oakland 3
973 973 1428015 216 Oakland 2020 Committee to Replace Lynette Gibson McElhaney and Elect Carroll Fife to the Oakland City Council spnsored by Alameda Labor Council AFL-CIO 320 RCP 2020-08-19 2020-08-18 2020-08-18 2020-11-03 S496-1 2487.5 2020-08-18 PHONE CALLS (ESTIMATE)         S Fife Carroll     City Council Member City of Oakland 3

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ie_reports_24_hours" (
"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,
  "amount" NUMERIC,
  "expenditure_date" TEXT,
  "expenditure_description" TEXT,
  "memo_reference_number" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id));
CREATE INDEX ["ie_reports_24_hours_filer_id"] ON [ie_reports_24_hours]("filer_id");
CREATE INDEX ["ie_reports_24_hours_filer_name"] ON [ie_reports_24_hours]("filer_name");