on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

1,072 rows where filer_name = 133 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_state, expenditure_type, expenditure_description, memo_reference_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 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
1650 1650 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON377 OTH AMERICAN LANGUAGE SERVICES       Los Angeles CA 90025 2016-09-26 1000 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1651 1651 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON374 IND COLBERG RON     Walnut Creek CA 94596 2016-09-26 750 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1652 1652 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON373 IND FLEMING PETE     San Francisco CA 94121 2016-09-26 750 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1653 1653 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON376 OTH INTERNATIONAL CONTACT INC       Oakland CA 94612 2016-09-26 2450 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1654 1654 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON375 IND MORTILLARO RICH     Burlingame CA 94010 2016-09-26 2500 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1655 1655 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON378 IND ROTHERY DIANA     San Francisco CA 94121 2016-09-26 1000 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1656 1656 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON380 OTH SEERVELD LUKE     San Carlos CA 94070 2016-09-26 1100 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1657 1657 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON381 IND WEINHERT LOU     Los Angeles CA 90027 2016-09-26 1500 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1658 1658 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON379 IND WENDLINGER DAVID     San Francisco CA 94109 2016-09-26 850 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1659 1659 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON496 OTH ANNA WU PHOTOGRAPHY LLC       San Francisco CA 94103 2016-10-14 1546.39 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1660 1660 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON504 IND COLBERG RON     Walnut Creek CA 94596 2016-10-14 6800 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1661 1661 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON494 OTH INTERNATIONAL CONTACT INC       Oakland CA 94612 2016-10-14 1450 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1662 1662 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON498 OTH MONTS CORP       Oakland CA 94601 2016-10-14 850 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1663 1663 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON493 IND MORTILLARO RICH     Burlingame CA 94010 2016-10-14 9000 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1664 1664 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON500 OTH PAM HARRIS PRODUCTIONS       Oakland CA 94602 2016-10-14 2400 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1665 1665 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON499 IND PERKINS PHIL     Albany CA 94706 2016-10-14 934.04 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1666 1666 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON502 IND PITTMAN PHILLIP MARC     Austin TX 78749 2016-10-14 675 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1667 1667 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON497 OTH PREMIUM BEAT       Montreal QB 215 2016-10-14 597 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1668 1668 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON501 OTH SEERVELD LUKE     San Carlos CA 94070 2016-10-14 2077.75 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1669 1669 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON495 IND TUCKER TOMAS     San Francisco CA 94114 2016-10-14 1500 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1670 1670 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 NON503 IND WEINHERT LOU     Los Angeles CA 90027 2016-10-14 1500 0 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1671 1671 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT143 OTH AMERICAN TAI WAH TRADING CORP       Oakland CA 94601 2016-10-10 4500 7500 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1672 1672 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT144 OTH PEONY SEAFOOD RESTAURANT       Oakland CA 94607 2016-10-10 2800 5400   FOOD AND BEVERAGES                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1673 1673 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT142 OTH SLEDRUNNER STUDIOS       Oakland CA 94607 2016-10-10 2700 7700 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1674 1674 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT122 OTH AMERICAN DIRECTIONS GROUP       Washington DC 20036 2016-09-26 11333.48 37246.98 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1675 1675 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT123 OTH POLITICAL DATA INC       Norwalk CA 90650 2016-09-26 600 17250 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1676 1676 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 EDT112 OTH AMERICAN DIRECTIONS GROUP       Washington DC 20036 2016-10-04 3772 37246.98 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1677 1677 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 EDT113 OTH POLITICAL DATA INC       Norwalk CA 90650 2016-10-04 600 17250 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1678 1678 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT146 OTH MOUNTAIN WEST RESEARCH CENTER       Pocatello ID 83201 2016-10-13 913.22 48035.26 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1679 1679 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT204 OTH MOUNTAIN WEST RESEARCH CENTER       Pocatello ID 83201 2016-10-22 47122.04 48035.26 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1680 1680 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT205 OTH POLITICAL DATA INC       Norwalk CA 90650 2016-10-22 4800 17250 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1681 1681 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT206 OTH AMERICAN AIRLINES       Fort Worth TX 76155 2016-10-22 721.55 721.55 TRS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1682 1682 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT192 OTH RODRIGUEZ STRATEGIES       Los Angeles CA 90025 2016-10-22 871.5 302471.48   COMMISSION                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1683 1683 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT191 OTH SMALLWOOD PHOTO       Oakland CA 94611 2016-10-22 4937.66 4937.66   VIDEO PRODUCTION COSTS                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1684 1684 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT208 OTH ST. REGIS       San Francisco CA 94103 2016-10-22 1947.78 1947.78 TRS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1685 1685 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT193 OTH STOREFRONT POLITICAL MEDIA       San Francisco CA 94111 2016-10-22 871.5 7868353.49   COMMISSION                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1686 1686 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT207 OTH UNITED AIRLINES, INC.       Chicago IL 60606 2016-10-22 741.18 741.18 TRS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1687 1687 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT189 IND BOREK JESSICA     Los Angeles CA 90025 2016-10-22 648.67 6831.36   REIMBURSED EXPENSES; UNDER $500                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1688 1688 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT188 IND RODRIGUEZ MATT     Los Angeles CA 90025 2016-10-22 848.55 10195.79   REIMBURSED EXPENSES; UNDER $500                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1689 1689 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT109 OTH GOOGLE, INC       Mountain View CA 94043 2016-09-25 3420 100943 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1690 1690 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT111 OTH IQ POLLS       Salford UK 502 2016-09-25 976 976 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1691 1691 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT100 IND JASPER DENISE     San Francisco CA 94118 2016-09-25 1000 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1692 1692 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT103 IND JASPER DENISE     San Francisco CA 94118 2016-09-25 1000 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1693 1693 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT112 IND JASPER DENISE     San Francisco CA 94118 2016-09-25 1000 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1694 1694 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT110 OTH MOBOPINIONS       London UK 42 2016-09-25 5000 7265 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1695 1695 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT101 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-09-25 15617.73 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1696 1696 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT104 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-09-25 1172.56 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1697 1697 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT106 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-09-25 3436.43 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1698 1698 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT113 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-09-25 15617.73 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1699 1699 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT108 OTH PUBLIC POLICY POLLING       Raleigh NC 27604 2016-09-25 15000 41000 POL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1700 1700 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT102 OTH US POSTMASTER       Oakland CA 94615 2016-09-25 23320.79 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1701 1701 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT105 OTH US POSTMASTER       Oakland CA 94615 2016-09-25 837 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1702 1702 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT107 OTH US POSTMASTER       Oakland CA 94615 2016-09-25 2617.57 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1703 1703 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT114 OTH US POSTMASTER       Oakland CA 94615 2016-09-25 23320.79 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1704 1704 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 EDT110 OTH 4SP FILMS LLC       San Francisco CA 94107 2016-09-26 27510 243527.97   SEE SCHEDULE G                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1705 1705 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT150 IND JASPER DENISE     San Francisco CA 94118 2016-10-03 1000 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1706 1706 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT151 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-10-03 13210.33 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1707 1707 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT152 OTH US POSTMASTER       Oakland CA 94615 2016-10-03 23320.79 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1708 1708 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT156 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-10-04 3436.43 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1709 1709 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT157 OTH US POSTMASTER       Oakland CA 94615 2016-10-04 2616.57 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1710 1710 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT124 OTH COMCAST       San Francisco CA 94133 2016-10-06 234876.25 1030462.45 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT124
1711 1711 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT131 OTH COMCAST       San Francisco CA 94133 2016-10-06 170000 1030462.45 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT131
1712 1712 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT125 OTH KBCW-TV       San Francisco CA 94111 2016-10-06 17365.5 18781.21 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT125
1713 1713 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT126 OTH KGO-ABC       San Francisco CA 94111 2016-10-06 193774.5 236139.83 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT126
1714 1714 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT132 OTH KICU-TV       San Francisco CA 94111 2016-10-06 16369.5 16369.5 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT132
1715 1715 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT127 OTH KNTV-NBC 11       San Francisco CA 94111 2016-10-06 102000 138881.12 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT127
1716 1716 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT133 OTH KOFY-TV       San Francisco CA 94124 2016-10-06 3570 3570 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT133
1717 1717 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT128 OTH KPIX-CBS       San Francisco CA 94111 2016-10-06 133492.5 177778.32 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT128
1718 1718 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT129 OTH KRON-TV       San Francisco CA 94111 2016-10-06 11900 14943.11 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT129
1719 1719 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT130 OTH KTVU-FOX       Oakland CA 94607 2016-10-06 105978 137566.76 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O PDT130
1720 1720 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT153 IND JASPER DENISE     San Francisco CA 94118 2016-10-07 1000 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1721 1721 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT154 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-10-07 13210.33 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1722 1722 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT158 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-10-07 3436.43 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1723 1723 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT155 OTH US POSTMASTER       Oakland CA 94615 2016-10-07 23320.79 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1724 1724 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT159 OTH US POSTMASTER       Oakland CA 94615 2016-10-07 2616.57 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1725 1725 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT175 OTH DATA-CLEAR       Arlington VA 22203 2016-10-09 736.47 6936.22   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1726 1726 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT147 IND JASPER DENISE     San Francisco CA 94118 2016-10-11 1000 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1727 1727 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT148 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-10-11 15617.73 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1728 1728 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT149 OTH US POSTMASTER       Oakland CA 94615 2016-10-11 23320.79 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1729 1729 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT160 IND JASPER DENISE     San Francisco CA 94118 2016-10-12 1000 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1730 1730 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT161 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-10-12 1172.56 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1731 1731 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT162 OTH US POSTMASTER       Oakland CA 94615 2016-10-12 837 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1732 1732 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT173 OTH CNBC DIGITAL       Englewood Cliffs NJ 07632 2016-10-13 1380 1380   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1733 1733 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT166 OTH CNN       Atlanta GA 30348 2016-10-13 5726.23 48226.23   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1734 1734 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT170 OTH GOOGLE, INC       Mountain View CA 94043 2016-10-13 5000 100943   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1735 1735 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT169 OTH INFORM, INC       Atlanta GA 30326 2016-10-13 5403 6806   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1736 1736 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT163 IND JASPER DENISE     San Francisco CA 94118 2016-10-13 1000 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1737 1737 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT174 OTH LA OPINION       Los Angeles CA 90017 2016-10-13 5700 5700   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1738 1738 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT171 OTH MIGHTYHIVE, INC       San Francisco CA 94111 2016-10-13 1778.45 9870.45   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1739 1739 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT168 OTH NEWSWEEK       New York NY 10004 2016-10-13 3230 15980   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1740 1740 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT164 OTH PACIFIC PRINT RESOURCES       Emeryville CA 94608 2016-10-13 8224.02 311294.31 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1741 1741 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT172 OTH PANDORA MEDIA INC.       Chicago IL 60673 2016-10-13 2750 2750   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1742 1742 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT165 OTH US POSTMASTER       Oakland CA 94615 2016-10-13 16352.64 364896.23 POS                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1743 1743 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT167 OTH YAHOO! INC.       Sunnyvale CA 94089 2016-10-13 1979.34 21104.34   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1744 1744 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT181 OTH 4SP FILMS LLC       San Francisco CA 94107 2016-10-14 55898.97 243527.97   SEE SCHEDULE G                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1745 1745 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT176 OTH CLEAR CHANNEL OUTDOOR       Oakland CA 94608 2016-10-14 18272.5 18272.5   BILLBOARD COSTS                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1746 1746 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT178 IND JASPER DENISE     San Francisco CA 94118 2016-10-14 5250 50525 LIT                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1747 1747 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT183 OTH JOYSTICK INTERACTIVE       Los Angeles CA 90292 2016-10-14 22500 38500   DIGITAL MEDIA                   MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1748 1748 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT186 OTH KRON 4.2 TV (SKYLINK)       San Francisco CA 94116 2016-10-14 24786 24786 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  
1749 1749 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 BMC 2017-01-24 2016-09-25 2016-10-22 2016-11-08 PDT185 OTH KTSF       Brisbane CA 94005 2016-10-14 111720 111720 TEL                     MEASURE HH   CITY OF OAKLAND - NOVEMBER 2016 O  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "on_behalf_of_expenditures" (
"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 ["on_behalf_of_expenditures_filer_id"] ON [on_behalf_of_expenditures]("filer_id");
CREATE INDEX ["on_behalf_of_expenditures_filer_name"] ON [on_behalf_of_expenditures]("filer_name");
CREATE INDEX ["on_behalf_of_expenditures_committee_id"] ON [on_behalf_of_expenditures]("committee_id");