on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

97 rows where filer_name = 122 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
1942 1942 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-07-26 2016-10-23 2016-12-31   PDT33 OTH Payless Car Rental       Oakland CA 94621 2016-11-09 779.82 929.82 TRC 10/19-11/9/16, Transportation, Oakland, CA, Campaign Field Work, 1   Kaplan Rebecca     OTH City of Oakland              
1943 1943 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-07-26 2016-10-23 2016-12-31   PDT35 OTH Payless Car Rental       Oakland CA 94621 2016-12-07 150 929.82 TRC 12/7/16, Transportation, Oakland, CA, Campaign Field Work, 1   Kaplan Rebecca     OTH City of Oakland              
1944 1944 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-07-26 2016-10-23 2016-12-31   EDT4 OTH US Postmaster       Berkeley CA 94702 2016-12-30 4712.3 19198.72 POS     Kaplan Rebecca     OTH City of Oakland              
1945 1945 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-07-26 2016-10-23 2016-12-31   PDT36 OTH Google AdWords       Mountain View CA 94043 2016-12-31 1252.61 1252.61   Online Ads   Kaplan Rebecca     OTH City of Oakland              
2159 2159 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-30 2016-10-23 2016-12-31 2016-11-08 PDT33 OTH Payless Car Rental       Oakland CA 94621 2016-11-09 779.82 929.82 TRC 10/19-11/9/16, Transportation, Oakland, CA, Campaign Field Work, 1   Kaplan Rebecca     OTH City of Oakland              
2160 2160 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-30 2016-10-23 2016-12-31 2016-11-08 PDT35 OTH Payless Car Rental       Oakland CA 94621 2016-12-07 150 929.82 TRC 12/7/16, Transportation, Oakland, CA, Campaign Field Work, 1   Kaplan Rebecca     OTH City of Oakland              
2161 2161 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-30 2016-10-23 2016-12-31 2016-11-08 EDT4 OTH US Postmaster       Berkeley CA 94702 2016-12-30 4712.3 19198.72 POS     Kaplan Rebecca     OTH City of Oakland              
1529 1529 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT1 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1530 1530 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT2 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.99 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1531 1531 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT3 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1532 1532 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT6 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-10 10.65 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1533 1533 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT7 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-12 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1534 1534 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT9 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-14 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1535 1535 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT10 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-15 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1536 1536 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT11 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-15 13.49 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1537 1537 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT13 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 16.56 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1538 1538 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT14 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1539 1539 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT15 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 16.32 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1540 1540 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT16 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 11.54 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1541 1541 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT17 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 11.4 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1542 1542 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT18 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 11.37 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1543 1543 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT19 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 13.28 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1544 1544 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT20 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 10.37 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1545 1545 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT21 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1546 1546 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT22 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 8.42 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1547 1547 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT23 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 8.66 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1548 1548 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT4 OTH US Postmaster       Berkeley CA 94702 2016-10-07 94 14486.42 POS     Kaplan Rebecca     OTH City of Oakland              
1549 1549 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT24 OTH US Postmaster       Berkeley CA 94702 2016-10-22 13374.36 14486.42 POS     Kaplan Rebecca     OTH City of Oakland              
1550 1550 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT25 OTH Facebook, Inc.       Menlo Park CA 94025 2016-10-22 772.19 772.19   Online Ads   Kaplan Rebecca     OTH City of Oakland              
1551 1551 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-29 2016-09-25 2016-10-22 2016-11-08 PDT26 OTH Gravis Marketing, Inc.       Winter Springs FL 32708 2016-10-22 588.96 588.96   Robo Calls   Kaplan Rebecca     OTH City of Oakland              
1552 1552 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT1 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1553 1553 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT2 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.99 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1554 1554 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT3 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1555 1555 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT6 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-10 10.65 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1556 1556 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT7 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-12 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1557 1557 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT9 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-14 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1558 1558 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT10 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-15 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1559 1559 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT11 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-15 13.49 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1560 1560 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT13 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 16.56 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1561 1561 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT14 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1562 1562 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT15 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 16.32 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1563 1563 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT16 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 11.54 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1564 1564 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT17 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 11.4 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1565 1565 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT18 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 11.37 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1566 1566 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT19 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 13.28 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1567 1567 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT20 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 10.37 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1568 1568 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT21 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1569 1569 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT22 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 8.42 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1570 1570 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT23 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 8.66 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1571 1571 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT4 OTH US Postmaster       Berkeley CA 94702 2016-10-07 94 14486.42 POS     Kaplan Rebecca     OTH City of Oakland              
1572 1572 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT24 OTH US Postmaster       Berkeley CA 94702 2016-10-22 13374.36 14486.42 POS     Kaplan Rebecca     OTH City of Oakland              
1573 1573 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT25 OTH Facebook, Inc.       Menlo Park CA 94025 2016-10-22 772.19 772.19   Online Ads   Kaplan Rebecca     OTH City of Oakland              
1574 1574 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2017-01-17 2016-09-25 2016-10-22   PDT26 OTH Gravis Marketing, Inc.       Winter Springs FL 32708 2016-10-22 588.96 588.96   Robo Calls   Kaplan Rebecca     OTH City of Oakland              
1575 1575 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT1 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1576 1576 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT2 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.99 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1577 1577 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT3 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1578 1578 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT6 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-10 10.65 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1579 1579 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT7 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-12 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1580 1580 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT9 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-14 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1581 1581 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT10 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-15 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1582 1582 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT11 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-15 13.49 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1583 1583 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT13 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 16.56 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1584 1584 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT14 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1585 1585 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT15 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 16.32 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1586 1586 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT16 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 11.54 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1587 1587 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT17 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 11.4 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1588 1588 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT18 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 11.37 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1589 1589 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT19 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 13.28 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1590 1590 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT20 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 10.37 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1591 1591 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT21 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1592 1592 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT22 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 8.42 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1593 1593 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT23 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 8.66 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
1594 1594 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT4 OTH US Postmaster       Berkeley CA 94702 2016-10-07 94 14486.42 POS     Kaplan Rebecca     OTH City of Oakland              
1595 1595 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT24 OTH US Postmaster       Berkeley CA 94702 2016-10-22 13374.36 14486.42 POS     Kaplan Rebecca     OTH City of Oakland              
1596 1596 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT25 OTH Facebook, Inc.       Menlo Park CA 94025 2016-10-22 772.19 772.19   Online Ads   Kaplan Rebecca     OTH City of Oakland              
1597 1597 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-11-08 2016-09-25 2016-10-22 2016-11-08 PDT26 OTH Gravis Marketing, Inc.       Winter Springs FL 32708 2016-10-22 588.96 588.96   Robo Calls   Kaplan Rebecca     OTH City of Oakland              
2401 2401 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT1 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2402 2402 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT2 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.99 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2403 2403 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT3 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-09-30 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2404 2404 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT6 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-10 10.65 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2405 2405 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT7 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-12 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2406 2406 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT9 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-14 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2407 2407 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT10 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-15 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2408 2408 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT11 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-15 13.49 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2409 2409 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT13 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 16.56 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2410 2410 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT14 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2411 2411 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT15 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 16.32 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2412 2412 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT16 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-17 11.54 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2413 2413 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT17 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 11.4 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2414 2414 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT18 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 11.37 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2415 2415 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT19 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 13.28 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2416 2416 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT20 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-18 10.37 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2417 2417 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT21 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 4.75 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2418 2418 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT22 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 8.42 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2419 2419 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT23 OTH Uber Technologies, Inc.       San Francisco CA 94105 2016-10-19 8.66 170.3 TRC     Kaplan Rebecca     OTH City of Oakland              
2420 2420 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PDT4 OTH US Postmaster       Berkeley CA 94702 2016-10-07 94 1112.06 POS     Kaplan Rebecca     OTH City of Oakland              
2756 2756 1381183 112 Kaplan for Oakland City Council 2016 122 CTL 2016-07-28 2016-01-01 2016-06-30   EDT1 OTH US Postmaster       Berkeley CA 94702 2016-06-13 1018.06 1018.06 POS     Kaplan Rebecca     OTH 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");