on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

68 rows where filer_id = 110 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, payee_last_name, payee_city, payee_state, payee_zipcode, expenditure_type, expenditure_description, 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
2101 2101 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G784-S OTH CVS Pharmacy-41st St       Oakland CA 94611 2016-11-07 2119 0   Election Day Volunteer Gifts   na na             City of Oakland Soda Tax HH City of Oakland S  
2102 2102 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G785-S OTH Rite Aid Pharmacy-Broadway       Oakland CA 94612 2016-11-07 1852.9 0   Election Day Volunteer Gifts   na na             City of Oakland Soda Tax HH City of Oakland S  
2103 2103 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G604-S OTH United States Postal Service       Sacramento CA 95834 2016-10-25 49274 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2104 2104 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G619-S OTH United States Postal Service       Sacramento CA 95834 2016-10-28 10503.32 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2105 2105 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G558-S OTH United States Postal Service       Sacramento CA 95834 2016-11-01 20758.01 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2106 2106 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G595-S OTH United States Postal Service       Sacramento CA 95834 2016-11-03 59710 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2107 2107 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G554-S OTH United States Postal Service       Sacramento CA 95834 2016-11-08 5585 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2108 2108 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G585-S OTH Best Buy       Oakland CA 94608 2016-10-28 582.97 0 OFC     na na             City of Oakland Soda Tax HH City of Oakland S  
2109 2109 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G783-S OTH CVS Pharmacy       Oakland CA 94611 2016-11-07 1059.5 0   Election Day Volunteer Gifts   na na             City of Oakland Soda Tax HH City of Oakland S  
2110 2110 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G781-S OTH Rite Aid Pharmacy       Oakland CA 94611 2016-11-07 2754.7 0   Election Day Volunteer Gifts   na na             City of Oakland Soda Tax HH City of Oakland S  
2111 2111 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G782-S OTH Safeway       Oakland CA 94618 2016-11-07 521.1 0   Election Day Volunteer Gifts   na na             City of Oakland Soda Tax HH City of Oakland S  
2112 2112 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G690-S OTH Internal Revenue Service       Ogden UT 84201 2016-10-31 3719.78 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2113 2113 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G688-S OTH Internal Revenue Service       Ogden UT 84201 2016-11-02 629.57 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2114 2114 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G701-S OTH Internal Revenue Service       Ogden UT 84201 2016-11-03 31.7 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2115 2115 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G704-S OTH Internal Revenue Service       Ogden UT 84201 2016-11-03 244.32 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2116 2116 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G709-S OTH Internal Revenue Service       Ogden UT 84201 2016-11-04 141.49 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2117 2117 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G715-S OTH Internal Revenue Service       Ogden UT 84201 2016-11-07 499.78 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2118 2118 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G730-S OTH Internal Revenue Service       Ogden UT 84201 2016-11-09 3463.26 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2119 2119 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G787-S OTH Internal Revenue Service       Ogden UT 84201 2016-11-15 3408.19 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2120 2120 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G771-S OTH Internal Revenue Service       Ogden UT 84201 2016-11-17 162.94 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2121 2121 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G689-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-10-31 367.11 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2122 2122 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G687-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-11-02 2.5 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2123 2123 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G716-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-11-07 35.3 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2124 2124 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G790-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-11-09 94.62 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2125 2125 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G789-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-11-15 327.63 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2126 2126 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G578-S OTH Apple Store-Palo Alto       Palo Alto CA 94301 2016-11-15 2046.41 0 OFC     na na             City of Oakland Soda Tax HH City of Oakland S  
2127 2127 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G638-S OTH Danger Boys Production LLC       Charleston SC 29406 2016-12-09 2697.5 0 RAD     na na             City of Oakland Soda Tax HH City of Oakland S  
2128 2128 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G637-S OTH Political Data Inc.       Norwalk CA 90650 2016-12-09 12380.9 0   Political Data   na na             City of Oakland Soda Tax HH City of Oakland S  
2129 2129 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G629-S OTH CallFire       Santa Monica CA 90401 2016-11-01 1785.2 0 PHO     na na             City of Oakland Soda Tax HH City of Oakland S  
2130 2130 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G626-S OTH KK Promotions       Chicago IL 60677 2016-11-09 557.14 0 CMP     na na             City of Oakland Soda Tax HH City of Oakland S  
2131 2131 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G628-S OTH Piedmont Copy       Oakland CA 94611 2016-11-01 66.85 0 OFC     na na             City of Oakland Soda Tax HH City of Oakland S  
2132 2132 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G775-S OTH Piedmont Copy       Oakland CA 94611 2016-11-02 37.46 0 OFC     na na             City of Oakland Soda Tax HH City of Oakland S  
2133 2133 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G627-S OTH Piedmont Copy       Oakland CA 94611 2016-11-06 615.93 0 CMP     na na             City of Oakland Soda Tax HH City of Oakland S  
2134 2134 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G780-S OTH 1st United Credit Union-Alameda       Alameda CA 94501 2016-11-07 1900 0   Election Day Volunteer Gifts   na na             City of Oakland Soda Tax HH City of Oakland S  
2135 2135 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G778-S OTH 1st United Credit Union-Berkeley       Berkeley CA 94704 2016-11-07 5000 0   Election Day Volunteer Gifts   na na             City of Oakland Soda Tax HH City of Oakland S  
2136 2136 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G779-S OTH 1st United Credit Union-Oakland       Oakland CA 94618 2016-11-07 2000 0   Election Day Volunteer Gifts   na na             City of Oakland Soda Tax HH City of Oakland S  
2137 2137 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G577-S OTH Cafe Platano       Berkeley CA 94704 2016-11-08 673.67 0 MTG     na na             City of Oakland Soda Tax HH City of Oakland S  
2138 2138 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G773-S OTH Oasis Grill       Berkeley CA 94704 2016-12-31 543.01 0 MTG     na na             City of Oakland Soda Tax HH City of Oakland S  
2139 2139 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2017-01-30 2016-10-23 2016-12-31 2016-11-08 G774-S OTH Zachary's Chicago Pizza       Oakland CA 94618 2016-12-31 914.32 0 MTG     na na             City of Oakland Soda Tax HH City of Oakland S  
2370 2370 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G466-S OTH United States Postal Service       Sacramento CA 95834 2016-10-03 23951.1 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2371 2371 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G435-S OTH United States Postal Service       Sacramento CA 95834 2016-10-12 10503.32 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2372 2372 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G467-S OTH United States Postal Service       Sacramento CA 95834 2016-10-21 10503.32 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2373 2373 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G445-S OTH AT&T       Dallas TX 75202 2016-10-04 375.65 0 WEB     na na             City of Oakland Soda Tax HH City of Oakland S  
2374 2374 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G530-S OTH AT&T       Dallas TX 75202 2016-10-04 375.65 0 WEB     na na             City of Oakland Soda Tax HH City of Oakland S  
2375 2375 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G451-S OTH AT&T       Dallas TX 75202 2016-10-10 102.27 0 PHO     na na             City of Oakland Soda Tax HH City of Oakland S  
2376 2376 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G450-S OTH AT&T       Dallas TX 75202 2016-10-16 68.18 0 PHO     na na             City of Oakland Soda Tax HH City of Oakland S  
2377 2377 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G548-S OTH Internal Revenue Service       Ogden UT 84201 2016-09-30 3027.44 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2378 2378 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G484-S OTH Internal Revenue Service       Ogden UT 84201 2016-10-14 2885.17 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2379 2379 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G536-S OTH Internal Revenue Service       Ogden UT 84201 2016-10-17 1374.55 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2380 2380 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G549-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-09-30 329.6 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2381 2381 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G483-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-10-14 308.91 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2382 2382 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G534-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-10-17 149.61 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2383 2383 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G540-S OTH Incitement       New York NY 10001 2016-10-22 1500 0 LIT     na na             City of Oakland Soda Tax HH City of Oakland S  
2384 2384 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G506-S OTH Political Data Inc.       Norwalk CA 90650 2016-10-22 13624.87 0   Political Data   na na             City of Oakland Soda Tax HH City of Oakland S  
2385 2385 1381041 110 Yes on Measure HH, Coalition for Healthy Oakland Children 136 BMC 2016-10-27 2016-09-25 2016-10-22 2016-11-08 G520-S OTH Powell Phones LLC       Portland OR 97210 2016-10-03 3983.7 0 PHO     na na             City of Oakland Soda Tax HH City of Oakland S  
2436 2436 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G403-S OTH United States Postal Service       Sacramento CA 95834 2016-09-19 23951.1 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2437 2437 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G404-S OTH United States Postal Service       Sacramento CA 95834 2016-09-24 23951.1 0 POS     na na             City of Oakland Soda Tax HH City of Oakland S  
2438 2438 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G305-S OTH Internal Revenue Service       Ogden UT 84201 2016-07-13 1679.06 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2439 2439 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G320-S OTH Internal Revenue Service       Ogden UT 84201 2016-07-27 4898.88 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2440 2440 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G331-S OTH Internal Revenue Service       Ogden UT 84201 2016-08-11 4096.12 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2441 2441 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G341-S OTH Internal Revenue Service       Ogden UT 84201 2016-08-29 4052.27 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2442 2442 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G376-S OTH Internal Revenue Service       Ogden UT 84201 2016-09-15 2820.29 0   Federal Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2443 2443 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G306-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-07-13 145.42 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2444 2444 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G319-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-07-27 483.74 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2445 2445 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G332-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-08-11 375.61 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2446 2446 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G340-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-08-29 375.61 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2447 2447 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G375-S OTH State of California Employment Development Department       West Sacramento CA 95691 2016-09-15 306.4 0   State Payroll Taxes   na na             City of Oakland Soda Tax HH City of Oakland S  
2448 2448 1381041 110 Yes on Measure HH, Citizens for Healthy Oakland Children 138 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 G390-S OTH Powell Phones LLC       Portland OR 97210 2016-09-22 7906.65 0 PHO     na na             City of Oakland Soda Tax HH City of Oakland S  

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");