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 = "f23db261-4e6b-4c9b-8e11-e702809adf3f" 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
1842958 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO f23db261-4e6b-4c9b-8e11-e702809adf3f Q2 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO 7383 BUILDING AND CONSTRUCTION TRADES DEPT AFL-CIO 2016 second_quarter ENV S. 2848 - Water Resources Development Act of 2016 - A bill to provide for the conservation and development of water and related resources, to authorize the Secretary of the Army to construct various projects for improvements to rivers and harbors of the United States. Entire bill Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office   310000 0 0 2016-07-15T10:07:00.253000-04:00
1842959 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO f23db261-4e6b-4c9b-8e11-e702809adf3f Q2 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO 7383 BUILDING AND CONSTRUCTION TRADES DEPT AFL-CIO 2016 second_quarter CHM H.R. 2576/S. 697 - Frank R. Lautenberg Chemical Safety for the 21st Century Act - A bill to amend the Toxic Substances Control Act to reauthorize and modernize that Act. Lobbied to promote infrastructure investment within the bill. Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office   310000 0 0 2016-07-15T10:07:00.253000-04:00
1842960 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO f23db261-4e6b-4c9b-8e11-e702809adf3f Q2 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO 7383 BUILDING AND CONSTRUCTION TRADES DEPT AFL-CIO 2016 second_quarter ENG S. 2012 - Energy Modernization Act - An original bill to provide for the modernization of the energy policy of the United States. Entire bill. S. 2795 - Nuclear Energy Innovation and Modernization Act - A bill to modernize the regulation of nuclear energy. Entire bill. Solar Energy Certification Program - general education and discussion on the solar energy certification process. No bill. Natural Resources Committee Hearing - Testimony on the role of NEPA in the Permitting Process dealing with H. Amendment 1076 - Prohibiting the use of funds to be used to implement or enforce Executive Order 13502. No bill. Energy and Natural Resources Committee Hearing - testimony to examine oil and gas pipeline infrastructure and the economic, safety, environmental, permitting, construction, and maintenance considerations associated with that infrastructure. No bill. Carbon Dioxide Sequestration Credit - general education on the carbon dioxide sequestration credit and a possible extension of the program. No bill. Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office   310000 0 0 2016-07-15T10:07:00.253000-04:00
1842961 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO f23db261-4e6b-4c9b-8e11-e702809adf3f Q2 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO 7383 BUILDING AND CONSTRUCTION TRADES DEPT AFL-CIO 2016 second_quarter IMM General Immigration Reform - General education on immigration reform relating to H2B Visas and EB5 Visa Reform and how it would impact the local construction industry. No bill. Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office   310000 0 0 2016-07-15T10:07:00.253000-04:00
1842962 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO f23db261-4e6b-4c9b-8e11-e702809adf3f Q2 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO 7383 BUILDING AND CONSTRUCTION TRADES DEPT AFL-CIO 2016 second_quarter LBR Project Labor Agreements - Working to ensure proper guidance and implementation of Executive Order 13502, encouraging the use of project labor agreements in connection with large-scale construction projects in order to promote economy and efficiency in federal procurement. No bill. Davis-Bacon Prevailing Wage - General education unrelated to a specific bill concerning the social benefits of Davis-Bacon, sub chapter IV of Chapter 31 or Title 40, United States Code, to provide prevailing wages to federally funded projects. Lobbied to ensure support and compliance of Davis-Bacon. No bill. Registered Apprenticeships and Workforce Development - Lobbied to promote the use of apprenticeship and training programs in workforce development, as well as general education of apprenticeship and training programs. No bill. S. 2945 - Effective Apprenticeships to Rebuild National Skills (EARNS) Act - A bill to promote effective registered apprenticeships, for skills, credentials, and employment. Entire bill. Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office   310000 0 0 2016-07-15T10:07:00.253000-04:00
1842963 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO f23db261-4e6b-4c9b-8e11-e702809adf3f Q2 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO 7383 BUILDING AND CONSTRUCTION TRADES DEPT AFL-CIO 2016 second_quarter RET Multi-Employer Pension Plan Reforms - general education on pension reform and pension recovery. No bill. Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office   310000 0 0 2016-07-15T10:07:00.253000-04:00
1842964 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO f23db261-4e6b-4c9b-8e11-e702809adf3f Q2 BUILDING AND CONSTRUCTION TRADES DEPT., AFL-CIO 7383 BUILDING AND CONSTRUCTION TRADES DEPT AFL-CIO 2016 second_quarter BUD H.R. 4974 - Military Construction and Veterans Affairs and Related Agencies Appropriations - Making appropriations for military construction, the Department of Veterans Affairs, and related agencies for the fiscal year ending September 30, 2017. Lobbied against Amendment 1076 offered by Rep. Perry, which would have banned the use of PLAs on construction agreements that are federally funded. Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office   310000 0 0 2016-07-15T10:07:00.253000-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);