lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

9 rows where filing_uuid = "eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 9

filing_year 1

filing_period 1

id filing_uuid filing_type registrant_name registrant_id client_name filing_year ▲ filing_period issue_code specific_issues government_entities income_amount expense_amount is_no_activity is_termination received_date
1429674 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter FIR Support gun regulation measures HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00
1429675 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter CIV Support for ENDA HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00
1429676 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter DIS Support for FEMA funding for houses of worship HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00
1429677 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter EDU Opposition to vouchers amendments to S.1094 and H.R.5 HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00
1429678 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter REL Implementation and reform of faith-based initative; opposition to aspects of HUD proposed rule on funding of faith-based institutions; opposition to War Memorial Protection Act, S.705 HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00
1429679 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter FOR Support for the U.S.-Israel relationship; support for efforts to thwart Iran's drive for nuclear arms capability; promote U.S. efforts in support of Israel and in support of UN sanctions at UN, unilateral Palestinian actions; support for robust foreign affairs funding in Budget; urge members to sign letter opposing Iran as President of UN Disarmament Commission; support for S.892, the Iran Sanctions Loophole Elimination Act; support for ratification of CEDAW; support for resolution urgingfree and fair elections in Iran, S. Res. 154 and H. Res. 252; support for amendments to NDAA, H.R. 1960, regarding Hezbollah & Iran; extension of Visa Waiver Program, including to Poland and Israel; support for sign-on letter urging the EU to designate Hezbollah as a terrorist organization; support of resolutions condemning Iran for its state sponsored persecution of his Baha'i minority, S.Res.75 and H.Res.109; support for the Congressional Hellenic-Israeli Alliance; support for Jewish refugees from Middle Eastern nations; support for international religious freedom; support for the U.S.-Israel Strategic Partnership Act, S.462 and H.R.938 HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00
1429680 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter ENG Support for U.S.-Israel Energy Cooperation Funding; support for multi-faceted approach to reducing dependence on foreign oil -- through substantial increases in vehicle fuel efficiency, reduction in wasteful energy consumption, development and commercialization of alternative sources of energy and alternative vehicle technologies, increases in domestic supplies of oil and gas with environmental safeguards, further diversification of foreign oil sources - moving away from volatile providers; support forthe Keystone XL pipeline HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00
1429681 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter IMM Comprehensive Immigration Reform; support for S. 744; support for religious workers visas; opposition to H.R.2131, the SKILLS visa act; support for reform of family and labor visas HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00
1429682 AMERICAN JEWISH COMMITTEE eb0cc10e-4e7b-48be-a5f5-ff18de2cf9ff Q2 AMERICAN JEWISH COMMITTEE 2720 AMERICAN JEWISH COMMITTEE 2013 second_quarter WEL Support Jewish communal budget priorities; support RUSH Act prioritizing Holocaust survivors under the Older Americans Act HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,State, Dept of (DOS),White House Office   50000 0 0 2013-07-22T16:34:58.287000-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE lobbying_activities (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            filing_type TEXT NOT NULL,
            registrant_name TEXT NOT NULL,
            registrant_id INTEGER,
            client_name TEXT NOT NULL,
            filing_year INTEGER NOT NULL,
            filing_period TEXT NOT NULL,
            issue_code TEXT,
            specific_issues TEXT,
            government_entities TEXT,
            income_amount INTEGER,
            expense_amount INTEGER,
            is_no_activity INTEGER DEFAULT 0,
            is_termination INTEGER DEFAULT 0,
            received_date TEXT,
            CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);