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

7 rows where filing_uuid = "51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 7

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
326646 REPUBLICAN JEWISH COALITION 51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa YY REPUBLICAN JEWISH COALITION 28093 REPUBLICAN JEWISH COALITION 2004 year_end EDU H.R. 3077, International Studies in Higher Education Act, Title VI provisions. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2005-02-10T00:00:00-05:00
326647 REPUBLICAN JEWISH COALITION 51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa YY REPUBLICAN JEWISH COALITION 28093 REPUBLICAN JEWISH COALITION 2004 year_end WEL H.R. 4, Welfare Reform Extension HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2005-02-10T00:00:00-05:00
326648 REPUBLICAN JEWISH COALITION 51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa YY REPUBLICAN JEWISH COALITION 28093 REPUBLICAN JEWISH COALITION 2004 year_end LAW H.R. 401, S. 684, Koby Mandell Act H.R. 4818, Omnibus FY 2005 Appropriations, Koby Mandell provisions HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2005-02-10T00:00:00-05:00
326649 REPUBLICAN JEWISH COALITION 51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa YY REPUBLICAN JEWISH COALITION 28093 REPUBLICAN JEWISH COALITION 2004 year_end ENG H.R. 6, Energy Policy Act of 2003 HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2005-02-10T00:00:00-05:00
326650 REPUBLICAN JEWISH COALITION 51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa YY REPUBLICAN JEWISH COALITION 28093 REPUBLICAN JEWISH COALITION 2004 year_end DEF H.R. 4613, Defense Appropriations for FY 2005, Middle East provisions HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2005-02-10T00:00:00-05:00
326651 REPUBLICAN JEWISH COALITION 51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa YY REPUBLICAN JEWISH COALITION 28093 REPUBLICAN JEWISH COALITION 2004 year_end FOR H.R. 4818, Omnibus Appropriations for FY 2005, Mideast provisions H.R. 4214, S. 2292, Global Anti-Semitism Review Act H.R. 4284, S. 2389, Investigating UN Oil for Food Program H.Con.Res. 311, S.Res. 325, Jewish Refugees H.Res. 615, Israel and UN WEOG H.Res. 617, Israel and OECD H.Con.Res. 425, S.Con.Res. 110, OSCE Combatting Anti-Semitism H.Res. 713, S.Res. 408, UN ICJ and Israel's Security Barrier H.Con.Res. 398, S.Con.Res. 81, Iran's nuclear weapons program H.R. 5193, S. 2681, Iran Freedom Support Act H.Con.Res. 469, S.Con.Res. 126, Bombing AMIA Jewish Center in Argentina HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2005-02-10T00:00:00-05:00
326652 REPUBLICAN JEWISH COALITION 51f30e8a-b87a-4f47-9e4d-d3dfc48a2dfa YY REPUBLICAN JEWISH COALITION 28093 REPUBLICAN JEWISH COALITION 2004 year_end REL S. 893, Workplace Religious Freedom Act HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2005-02-10T00:00:00-05: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);