on_behalf_of_expenditures
Data source: G_Expenditure
160 rows where filer_id = 71 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, entity_type, payee_first_name, payee_city, payee_state, expenditure_date, expenditure_type, expenditure_description, ballot_measure_name, ballot_measure_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1609 | 1609 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON546 | OTH | AEN-TV | New York | NY | 10017 | 2016-10-13 | 538 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1610 | 1610 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON547 | OTH | BRVO-TV | New York | NY | 10036 | 2016-10-13 | 588 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1611 | 1611 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON548 | OTH | ESPN-TV | Bristol | CT | 06010 | 2016-10-13 | 688 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1612 | 1612 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON549 | OTH | FX-TV | Los Angeles | CA | 90035 | 2016-10-13 | 548 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1613 | 1613 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON550 | OTH | HGTV-TV | Knoxville | TN | 37932 | 2016-10-13 | 724 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1614 | 1614 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON551 | OTH | TNT-TV | Atlanta | GA | 30318 | 2016-10-13 | 886 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1615 | 1615 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON552 | OTH | USA-TV | New York | NY | 10112 | 2016-10-13 | 979 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1616 | 1616 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON516 | OTH | AEN-TV | New York | NY | 10017 | 2016-10-13 | 1746 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1617 | 1617 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON517 | OTH | AMC-TV | New York | NY | 10001 | 2016-10-13 | 1055 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1618 | 1618 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON518 | OTH | BET-TV | Los Angeles | CA | 90025 | 2016-10-13 | 637 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1619 | 1619 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON519 | OTH | CMDY-TV | New York | NY | 10014 | 2016-10-13 | 1520 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1620 | 1620 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON520 | OTH | CNBC-TV | Englewood Cliffs | NJ | 07632 | 2016-10-13 | 1000 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1621 | 1621 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON521 | OTH | CNN-TV | Atlanta | GA | 30303 | 2016-10-13 | 1299 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1622 | 1622 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON522 | OTH | DISC-TV | Chicago | IL | 60601 | 2016-10-13 | 986 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1623 | 1623 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON523 | COM | ENT-TV | Los Angeles | CA | 90036 | 2016-10-13 | 1230 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1624 | 1624 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON524 | OTH | ESP2-TV | Bristol | CT | 06010 | 2016-10-13 | 652 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1625 | 1625 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON525 | OTH | ESPN-TV | Bristol | CT | 06010 | 2016-10-13 | 2350 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1626 | 1626 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON526 | OTH | FAM-TV | Burbank | CA | 91505 | 2016-10-13 | 1015 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1627 | 1627 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON527 | OTH | FOOD-TV | Los Angeles | CA | 90036 | 2016-10-13 | 1758 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1628 | 1628 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON528 | OTH | FOXD-TV | New York | NY | 10036 | 2016-10-13 | 742 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1629 | 1629 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON529 | OTH | FS1-TV | Potomac | MD | 20854 | 2016-10-13 | 584 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1630 | 1630 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON531 | OTH | FXNC-TV | New York | NY | 10036 | 2016-10-13 | 1222 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1631 | 1631 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON530 | OTH | FX-TV | Los Angeles | CA | 90035 | 2016-10-13 | 1441 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1632 | 1632 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON532 | OTH | GALA-TV | Los Angeles | CA | 90045 | 2016-10-13 | 1519 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1633 | 1633 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON533 | OTH | HALL-TV | Studio City | CA | 91604 | 2016-10-13 | 652 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1634 | 1634 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON534 | OTH | HGTV-TV | Knoxville | TN | 37932 | 2016-10-13 | 2306 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1635 | 1635 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON535 | OTH | HIST-TV | New York | NY | 10017 | 2016-10-13 | 980 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1636 | 1636 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON536 | OTH | LIF-TV | New York | NY | 10017 | 2016-10-13 | 1000 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1637 | 1637 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON537 | OTH | MSNBC-TV | New York | NY | 10112 | 2016-10-13 | 804 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1638 | 1638 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON538 | OTH | MTV-TV | New York | NY | 10036 | 2016-10-13 | 966 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1639 | 1639 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON539 | OTH | SPK-TV | Santa Monica | CA | 90404 | 2016-10-13 | 792 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1640 | 1640 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON540 | OTH | SYFY-TV | New York | NY | 10112 | 2016-10-13 | 554 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1641 | 1641 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON541 | OTH | TBSC-TV | Atlanta | GA | 30318 | 2016-10-13 | 1470 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1642 | 1642 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON542 | OTH | TLC-TV | Silver Spring | MD | 20910 | 2016-10-13 | 828 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1643 | 1643 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON543 | OTH | TNT-TV | Atlanta | GA | 30318 | 2016-10-13 | 2376 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1644 | 1644 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON544 | OTH | TRAV-TV | Chevy Chase | MD | 20815 | 2016-10-13 | 650 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1645 | 1645 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON545 | OTH | USA-TV | New York | NY | 10112 | 2016-10-13 | 2091 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1646 | 1646 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | EDT34 | OTH | AT&T Uverse | Dallas | CA | 75202 | 2016-10-13 | 11224 | 11224 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1647 | 1647 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | EDT32 | OTH | Comcast Spotlight | San Francisco | CA | 94133 | 2016-10-13 | 43776 | 43776 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1648 | 1648 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | EDT30 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-10-03 | 1925.01 | 5737.19 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1649 | 1649 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-09-25 | 2016-10-22 | 2016-11-08 | EDT33 | OTH | Mobile TV | Dallas | TX | 75202 | 2016-10-13 | 15000 | 15000 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
1933 | 1933 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-10-23 | 2016-12-31 | EDT35 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-10-31 | 870.53 | 8532.73 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
1934 | 1934 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-10-23 | 2016-12-31 | EDT36 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-10-31 | 1925.01 | 8532.73 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
1935 | 1935 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-05-15 | 2016-10-23 | 2016-12-31 | EDT37 | OTH | Timodesigns, Inc. | Oakland | CA | 94610 | 2016-10-31 | 400 | 1250 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
1936 | 1936 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-03-28 | 2016-10-23 | 2016-12-31 | EDT35 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-10-31 | 870.53 | 8532.73 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
1937 | 1937 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-03-28 | 2016-10-23 | 2016-12-31 | EDT36 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-10-31 | 1925.01 | 8532.73 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
1938 | 1938 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-03-28 | 2016-10-23 | 2016-12-31 | EDT37 | OTH | Timodesigns, Inc. | Oakland | CA | 94610 | 2016-10-31 | 400 | 1250 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
2178 | 2178 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-01-31 | 2016-10-23 | 2016-12-31 | EDT35 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-10-31 | 870.53 | 8532.73 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
2179 | 2179 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-01-31 | 2016-10-23 | 2016-12-31 | EDT36 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-10-31 | 1925.01 | 8532.73 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
2180 | 2180 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2017-01-31 | 2016-10-23 | 2016-12-31 | EDT37 | OTH | Timodesigns, Inc. | Oakland | CA | 94610 | 2016-10-31 | 400 | 1250 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
1125 | 1125 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-07-01 | 2016-09-24 | 2016-11-08 | EDT29 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-09-09 | 1987.43 | 3812.18 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2316 | 2316 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON546 | OTH | AEN-TV | New York | NY | 10017 | 2016-10-13 | 538 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2317 | 2317 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON547 | OTH | BRVO-TV | New York | NY | 10036 | 2016-10-13 | 588 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2318 | 2318 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON548 | OTH | ESPN-TV | Bristol | CT | 06010 | 2016-10-13 | 688 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2319 | 2319 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON549 | OTH | FX-TV | Los Angeles | CA | 90035 | 2016-10-13 | 548 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2320 | 2320 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON550 | OTH | HGTV-TV | Knoxville | TN | 37932 | 2016-10-13 | 724 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2321 | 2321 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON551 | OTH | TNT-TV | Atlanta | GA | 30318 | 2016-10-13 | 886 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2322 | 2322 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON552 | OTH | USA-TV | New York | NY | 10112 | 2016-10-13 | 979 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2323 | 2323 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON516 | OTH | AEN-TV | New York | NY | 10017 | 2016-10-13 | 1746 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2324 | 2324 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON517 | OTH | AMC-TV | New York | NY | 10001 | 2016-10-13 | 1055 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2325 | 2325 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON518 | OTH | BET-TV | Los Angeles | CA | 90025 | 2016-10-13 | 637 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2326 | 2326 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON519 | OTH | CMDY-TV | New York | NY | 10014 | 2016-10-13 | 1520 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2327 | 2327 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON520 | OTH | CNBC-TV | Englewood Cliffs | NJ | 07632 | 2016-10-13 | 1000 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2328 | 2328 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON521 | OTH | CNN-TV | Atlanta | GA | 30303 | 2016-10-13 | 1299 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2329 | 2329 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON522 | OTH | DISC-TV | Chicago | IL | 60601 | 2016-10-13 | 986 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2330 | 2330 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON523 | COM | ENT-TV | Los Angeles | CA | 90036 | 2016-10-13 | 1230 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2331 | 2331 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON524 | OTH | ESP2-TV | Bristol | CT | 06010 | 2016-10-13 | 652 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2332 | 2332 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON525 | OTH | ESPN-TV | Bristol | CT | 06010 | 2016-10-13 | 2350 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2333 | 2333 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON526 | OTH | FAM-TV | Burbank | CA | 91505 | 2016-10-13 | 1015 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2334 | 2334 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON527 | OTH | FOOD-TV | Los Angeles | CA | 90036 | 2016-10-13 | 1758 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2335 | 2335 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON528 | OTH | FOXD-TV | New York | NY | 10036 | 2016-10-13 | 742 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2336 | 2336 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON529 | OTH | FS1-TV | Potomac | MD | 20854 | 2016-10-13 | 584 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2337 | 2337 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON531 | OTH | FXNC-TV | New York | NY | 10036 | 2016-10-13 | 1222 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2338 | 2338 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON530 | OTH | FX-TV | Los Angeles | CA | 90035 | 2016-10-13 | 1441 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2339 | 2339 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON532 | OTH | GALA-TV | Los Angeles | CA | 90045 | 2016-10-13 | 1519 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2340 | 2340 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON533 | OTH | HALL-TV | Studio City | CA | 91604 | 2016-10-13 | 652 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2341 | 2341 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON534 | OTH | HGTV-TV | Knoxville | TN | 37932 | 2016-10-13 | 2306 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2342 | 2342 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON535 | OTH | HIST-TV | New York | NY | 10017 | 2016-10-13 | 980 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2343 | 2343 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON536 | OTH | LIF-TV | New York | NY | 10017 | 2016-10-13 | 1000 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2344 | 2344 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON537 | OTH | MSNBC-TV | New York | NY | 10112 | 2016-10-13 | 804 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2345 | 2345 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON538 | OTH | MTV-TV | New York | NY | 10036 | 2016-10-13 | 966 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2346 | 2346 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON539 | OTH | SPK-TV | Santa Monica | CA | 90404 | 2016-10-13 | 792 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2347 | 2347 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON540 | OTH | SYFY-TV | New York | NY | 10112 | 2016-10-13 | 554 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2348 | 2348 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON541 | OTH | TBSC-TV | Atlanta | GA | 30318 | 2016-10-13 | 1470 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2349 | 2349 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON542 | OTH | TLC-TV | Silver Spring | MD | 20910 | 2016-10-13 | 828 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2350 | 2350 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON543 | OTH | TNT-TV | Atlanta | GA | 30318 | 2016-10-13 | 2376 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2351 | 2351 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON544 | OTH | TRAV-TV | Chevy Chase | MD | 20815 | 2016-10-13 | 650 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2352 | 2352 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | NON545 | OTH | USA-TV | New York | NY | 10112 | 2016-10-13 | 2091 | 0 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2353 | 2353 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | EDT34 | OTH | AT&T Uverse | Dallas | CA | 75202 | 2016-10-13 | 11224 | 11224 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2354 | 2354 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | EDT32 | OTH | Comcast Spotlight | San Francisco | CA | 94133 | 2016-10-13 | 43776 | 43776 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2355 | 2355 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | EDT30 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-10-03 | 1925.01 | 5737.19 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
2356 | 2356 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-10-27 | 2016-09-25 | 2016-10-22 | 2016-11-08 | EDT33 | OTH | Mobile TV | Dallas | TX | 75202 | 2016-10-13 | 15000 | 15000 | TEL | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
962 | 962 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-09-29 | 2016-01-01 | 2016-06-30 | PDT4 | OTH | Discovery Petitions | Sacramento | CA | 95826 | 2016-05-11 | 6576 | 6576 | PET | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
963 | 963 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-09-29 | 2016-01-01 | 2016-06-30 | PDT5 | OTH | Harwig | Santa Cruz | CA | 95062 | 2016-05-11 | 11680 | 11680 | PET | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
964 | 964 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-09-29 | 2016-01-01 | 2016-06-30 | PDT2 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-05-20 | 1824.75 | 1824.75 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
965 | 965 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-09-29 | 2016-01-01 | 2016-06-30 | PDT3 | OTH | Timodesigns, Inc. | Oakland | CA | 94610 | 2016-05-20 | 850 | 850 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
966 | 966 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-09-29 | 2016-01-01 | 2016-06-30 | EDT28 | OTH | Powell Phones, LLC | Portland | OR | 97210 | 2016-05-26 | 4886.31 | 4886.31 | PHO | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | |||||||||||||||
2654 | 2654 | 1364564 71 | Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 | BMC | 2016-09-29 | 2016-07-01 | 2016-09-24 | 2016-11-08 | EDT29 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-09-09 | 1987.43 | 3812.18 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | JJ | City of Oakland | S | ||||||||||||||
967 | 967 | 1364564 71 | Committee to Protect Oakland Renters sponsored by labor and community organizations 129 | BMC | 2016-08-17 | 2016-01-01 | 2016-06-30 | PDT2 | OTH | Cornerstone Printing, Inc. | San Francisco | CA | 94133 | 2016-05-20 | 1824.75 | 1824.75 | LIT | Proposed amendments to residental rent adjustments and evictions ordinance | TBD | City of Oakland | S | |||||||||||||||
968 | 968 | 1364564 71 | Committee to Protect Oakland Renters sponsored by labor and community organizations 129 | BMC | 2016-08-17 | 2016-01-01 | 2016-06-30 | EDT28 | OTH | Powell Phones, LLC | Portland | OR | 97210 | 2016-05-26 | 4886.31 | 4886.31 | PHO | Proposed amendments to residental rent adjustments and evictions ordinance | TBD | City of Oakland | S |
Advanced export
JSON shape: default, array, newline-delimited
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");