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

5 rows where filing_uuid = "8b643d27-2f5a-426d-b60f-e921e400e43a" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 5

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
999721 THE WESSEL GROUP INCORPORATED 8b643d27-2f5a-426d-b60f-e921e400e43a Q3 THE WESSEL GROUP INCORPORATED 308070 UNITED STEELWORKERS 2010 third_quarter CPT S. 515/H.R. 1260,Patent Reform Act of 2009, provisions on damages, post-grant review and publication. Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) 20000   0 0 2010-10-18T20:18:23.837000-04:00
999722 THE WESSEL GROUP INCORPORATED 8b643d27-2f5a-426d-b60f-e921e400e43a Q3 THE WESSEL GROUP INCORPORATED 308070 UNITED STEELWORKERS 2010 third_quarter TRD Continued Dumping and Subsidy Offset Act; Retention of zeroing methodology to calculate dumping margins; Trade law enforcement; Manufacturing and labor concerns relating to the US-Panama, US-Korea and US-Colombia Free Trade Agreements; China-US Bilateral Steel Dialogue; World Trade Organization, Doha Round, rules negotiations; Export promotion; Treatment of glassware sector in multilateral trade negotiations; Antidumping and countervailing duty case on coated paper; Negotiations on Environmental Goods and Services Agreement; Trans-Pacific Partnership Negotiations; Currency manipulation by the People's Republic of China; Chinese subsidies to paper industry; Implementation of Section 421 case on consumer tires; Impact of international trade on domestic alternative and renewable energy production; Opposition to petition to eliminate payment of dumping duties on products imported into foreign trade zones; USW Section 301 petition on alternative and renewable energy production equipment and related products. Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) 20000   0 0 2010-10-18T20:18:23.837000-04:00
999723 THE WESSEL GROUP INCORPORATED 8b643d27-2f5a-426d-b60f-e921e400e43a Q3 THE WESSEL GROUP INCORPORATED 308070 UNITED STEELWORKERS 2010 third_quarter MAN Treatment of iron, steel and manufactured products under Buy America provisions in the economic stimulus program; Obama Administration manufacturing framework; Increasing funding for Section 48(c) of the American Recovery and Reinvestment Act; Development of domestic sourcing for nuclear, wind and other alternative and renewable energy producers House Make It In America Agenda Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) 20000   0 0 2010-10-18T20:18:23.837000-04:00
999724 THE WESSEL GROUP INCORPORATED 8b643d27-2f5a-426d-b60f-e921e400e43a Q3 THE WESSEL GROUP INCORPORATED 308070 UNITED STEELWORKERS 2010 third_quarter ENV Manufacturing concerns with climate change legislation; H.R. 2454, American Clean Energy and Security Act; S. 1733; Clean Energy Jobs and American Power Act; American Power Act; and other pending legislation. Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) 20000   0 0 2010-10-18T20:18:23.837000-04:00
999725 THE WESSEL GROUP INCORPORATED 8b643d27-2f5a-426d-b60f-e921e400e43a Q3 THE WESSEL GROUP INCORPORATED 308070 UNITED STEELWORKERS 2010 third_quarter CSP Potential regulation of cadmium in vitrification process. Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) 20000   0 0 2010-10-18T20:18:23.837000-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);