on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

75 rows where filer_name = 62 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, transaction_id, payee_last_name, payee_city, payee_state, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, 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
82 82 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 EDT1 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-03-17 830.07 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
83 83 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 EDT2 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-03-31 598.29 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
84 84 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 EDT3 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-04-15 598.29 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
85 85 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 EDT4 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-04-30 516.37 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
86 86 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 EDT5 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-06-16 590.1 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
87 87 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 EDT6 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-06-30 874.94 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
88 88 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 PDT1 OTH Impact Hub Oakland       Oakland CA 94612 2014-06-30 1425 2375 OFC     Ruby Courtney     MAY City of Oakland              
89 89 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 PDT3 OTH Pacific Print Resources       Emeryville CA 94608 2014-06-30 1972 1972 LIT     Ruby Courtney     MAY City of Oakland              
90 90 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-01-01 2014-06-30 2014-11-04 PDT2 OTH Political Data, Inc.       Norwalk CA 90650 2014-06-30 4499.38 4499.38 LIT     Ruby Courtney     MAY City of Oakland              
154 154 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 EDT12 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-07-15 694.94 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
155 155 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 EDT7 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-07-31 694.94 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
156 156 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 EDT8 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-08-15 833.24 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
157 157 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 EDT9 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-08-29 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
158 158 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 EDT10 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-09-15 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
159 159 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 EDT11 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-09-30 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
160 160 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 PDT7 OTH Advocacy Data       Washington DC 20006 2014-09-30 1044.91 1044.91 WEB     Ruby Courtney     MAY City of Oakland              
161 161 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 PDT4 OTH Campaign Grid       Fort Washington PA 19034 2014-09-30 1517.25 1517.25 WEB     Ruby Courtney     MAY City of Oakland              
162 162 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 PDT5 OTH Facebook       Palo Alto CA 94301 2014-09-30 1024.25 1024.25 WEB     Ruby Courtney     MAY City of Oakland              
163 163 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 PDT6 OTH Pacific Print Resources       Emeryville CA 94608 2014-09-30 1560 3532 CMP     Ruby Courtney     MAY City of Oakland              
164 164 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-07-01 2014-09-30 2014-11-04 PDT8 OTH Whiteboard Stories       Miami FL 33166 2014-09-30 2500 2500 WEB     Ruby Courtney     MAY City of Oakland              
302 302 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-10-01 2014-10-18 2014-11-04 PDT13 OTH Lane Splitter Pizza       Oakland CA 94609 2014-10-18 106.28 210.11 MTG 10/3/14, Meal While Attending Video Shoot, 12, Candidate, Darin Cline-Authority To Approve Expenditures   Ruby Courtney     MAY City of Oakland              
303 303 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-10-01 2014-10-18 2014-11-04 PDT14 OTH Lane Splitter Pizza       Oakland CA 94609 2014-10-18 103.83 210.11 MTG 10/15/14, Meal While Attending Phone Bank, 15, Candidate, Darin Cline-Authority To Approve Expenditures   Ruby Courtney     MAY City of Oakland              
304 304 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-10-01 2014-10-18 2014-11-04 EDT13 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-10-15 1066.36 10496.62 SAL     Ruby Courtney     MAY City of Oakland              
305 305 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-10-01 2014-10-18 2014-11-04 PDT9 OTH East Bay Express       Oakland CA 94607 2014-10-18 1355 1355 PRT     Ruby Courtney     MAY City of Oakland              
306 306 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-10-01 2014-10-18 2014-11-04 PDT11 OTH Pacific Print Resources       Emeryville CA 94608 2014-10-18 2360 5892 LIT     Ruby Courtney     MAY City of Oakland              
307 307 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-10-01 2014-10-18 2014-11-04 PDT12 OTH Rhythm & Design       San Francisco CA 94133 2014-10-18 500 500 LIT     Ruby Courtney     MAY City of Oakland              
308 308 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-10-01 2014-10-18 2014-11-04 PDT10 OTH United States Post Office       Oakland CA 94615 2014-10-18 2700 2700 POS     Ruby Courtney     MAY City of Oakland              
641 641 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2015-01-26 2014-10-19 2014-12-31 2014-11-04 EDT14 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-10-31 1066.36 11562.98 SAL     Ruby Courtney     MAY City of Oakland              
165 165 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT12 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-07-15 694.94 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
166 166 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT7 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-07-31 694.94 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
167 167 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT8 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-08-15 833.24 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
168 168 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT9 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-08-29 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
169 169 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT10 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-09-15 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
170 170 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 EDT11 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-09-30 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
171 171 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 PDT7 OTH Advocacy Data       Washington DC 20006 2014-09-30 1044.91 1044.91 WEB     Ruby Courtney     MAY City of Oakland              
172 172 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 PDT4 OTH Campaign Grid       Fort Washington PA 19034 2014-09-30 1517.25 1517.25 WEB     Ruby Courtney     MAY City of Oakland              
173 173 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 PDT5 OTH Facebook       Palo Alto CA 94301 2014-09-30 1024.25 1024.25 WEB     Ruby Courtney     MAY City of Oakland              
174 174 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 PDT6 OTH Pacific Print Resources       Emeryville CA 94608 2014-09-30 1560 3532 CMP     Ruby Courtney     MAY City of Oakland              
175 175 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-07-01 2014-09-30 2014-11-04 PDT8 OTH Whiteboard Stories       Miami FL 33166 2014-09-30 2500 2500 WEB     Ruby Courtney     MAY City of Oakland              
738 738 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT13 OTH Lane Splitter Pizza       Oakland CA 94609 2014-10-18 106.28 210.11 MTG 10/3/14, Meal While Attending Video Shoot, 12, Candidate, Darin Cline-Authority To Approve Expenditures   Ruby Courtney     MAY City of Oakland              
739 739 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT14 OTH Lane Splitter Pizza       Oakland CA 94609 2014-10-18 103.83 210.11 MTG 10/15/14, Meal While Attending Phone Bank, 15, Candidate, Darin Cline-Authority To Approve Expenditures   Ruby Courtney     MAY City of Oakland              
740 740 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 EDT13 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-10-15 1066.36 10496.62 SAL     Ruby Courtney     MAY City of Oakland              
741 741 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT9 OTH East Bay Express       Oakland CA 94607 2014-10-18 1355 1355 PRT     Ruby Courtney     MAY City of Oakland              
742 742 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT11 OTH Pacific Print Resources       Emeryville CA 94608 2014-10-18 2360 5892 LIT     Ruby Courtney     MAY City of Oakland              
743 743 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT12 OTH Rhythm & Design       San Francisco CA 94133 2014-10-18 500 500 LIT     Ruby Courtney     MAY City of Oakland              
744 744 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT10 OTH United States Post Office       Oakland CA 94615 2014-10-18 2700 2700 POS     Ruby Courtney     MAY City of Oakland              
798 798 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT12 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-07-15 694.94 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
799 799 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT7 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-07-31 694.94 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
800 800 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT8 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-08-15 833.24 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
801 801 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT9 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-08-29 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
802 802 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT10 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-09-15 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
803 803 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT11 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-09-30 1066.36 9430.26 SAL     Ruby Courtney     MAY City of Oakland              
804 804 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT7 OTH Advocacy Data       Washington DC 20006 2014-09-30 1044.91 1044.91 WEB     Ruby Courtney     MAY City of Oakland              
805 805 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT4 OTH Campaign Grid       Fort Washington PA 19034 2014-09-30 1517.25 1517.25 WEB     Ruby Courtney     MAY City of Oakland              
806 806 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT5 OTH Facebook       Palo Alto CA 94301 2014-09-30 1024.25 1024.25 WEB     Ruby Courtney     MAY City of Oakland              
807 807 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT6 OTH Pacific Print Resources       Emeryville CA 94608 2014-09-30 1560 3532 CMP     Ruby Courtney     MAY City of Oakland              
808 808 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 PDT8 OTH Whiteboard Stories       Miami FL 33166 2014-09-30 2500 2500 WEB     Ruby Courtney     MAY City of Oakland              
91 91 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 EDT1 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-03-17 830.07 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
92 92 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 EDT2 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-03-31 598.29 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
93 93 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 EDT3 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-04-15 598.29 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
94 94 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 EDT4 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-04-30 516.37 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
95 95 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 EDT5 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-06-16 590.1 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
96 96 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 EDT6 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-06-30 874.94 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
97 97 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 PDT1 OTH Impact Hub Oakland       Oakland CA 94612 2014-06-30 1425 2375 OFC     Ruby Courtney     MAY City of Oakland              
98 98 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 PDT3 OTH Pacific Print Resources       Emeryville CA 94608 2014-06-30 1972 1972 LIT     Ruby Courtney     MAY City of Oakland              
99 99 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-10-04 2014-01-01 2014-06-30 2014-11-04 PDT2 OTH Political Data, Inc.       Norwalk CA 90650 2014-06-30 4499.38 4499.38 LIT     Ruby Courtney     MAY City of Oakland              
869 869 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT1 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-03-17 830.07 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
870 870 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT2 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-03-31 598.29 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
871 871 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT3 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-04-15 598.29 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
872 872 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT4 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-04-30 516.37 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
873 873 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT5 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-06-16 590.1 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
874 874 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT6 OTH Internal Revenue Services (IRS)       Ogden UT 84201 2014-06-30 874.94 4008.06 SAL     Ruby Courtney     MAY City of Oakland              
875 875 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 PDT1 OTH Impact Hub Oakland       Oakland CA 94612 2014-06-30 1425 2375 OFC     Ruby Courtney     MAY City of Oakland              
876 876 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 PDT3 OTH Pacific Print Resources       Emeryville CA 94608 2014-06-30 1972 1972 LIT     Ruby Courtney     MAY City of Oakland              
877 877 1364278 66 Courtney Ruby for Oakland Mayor 2014 62 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 PDT2 OTH Political Data, Inc.       Norwalk CA 90650 2014-06-30 4499.38 4499.38 LIT     Ruby Courtney     MAY City of Oakland              

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