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

10 rows where filing_uuid = "7d626f0a-e95f-4e9f-9712-b00fbd459cf0" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 10

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
526152 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year FIN S7-10-06, SEC Proposal on Executive Compensation; all provisions SEC File Number 4-537, Roundtable Discussions Regarding Proxy Process; all provisions H.R. 1257, Shareholder Vote on Executive Compensation Act; all provisions S. 1181, Shareholder Vote on Executive Compensation Act; all provisions S7-03-05, SEC Proposal on Proxy Access; all provisions S7-10-05, SEC Proposal on E-Proxy; all provisions Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526153 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year TAX H.R. 2138, Investment in America Act of 2007; provisions relating to research and development credit Bill not yet assigned, Tax Bill; provisions relating to dividends and capital gains Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526154 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year HCR S. 334, Healthy Americans Act; all provisions S. 628, Critical Access to Health Information Technology Act of 2007; provisions relating to health information technology S. 1082, Prescription Drug User Fee Amendments of 2007; provisions relating to the importation of medicine into the United States and “forced sale” S. 1481, Fair and Reliable Medical Justice Act; all provisions S. 1544, Medicare Quality Enhancement Act of 2007; all provisions S. 1693, Wired for Health Care Quality Act; all provisions S. 1783, Ten Steps to Transform Health Care in America Act; all provisions Bill not yet assigned, Health Care Bill; provisions relating to value-driven health care Bill not yet assigned, Health Care Bill; provisions relating to the President’s health care and tax proposal Bill not yet assigned, Health Care Bill; provisions relating to State waivers to Employee Retirement Income Security Act preemption Bill not yet assigned, Health Care Bill; provisions relating to regulatory pathway for follow-on biologics H.R. 1111, Kids Come First Act of 2007; all provisions H.R. 2055, Improving Children's Access to Health Care Act of 2007; all provisions H.R. 2497, Fair and Reliable Medical Justice Act; all provisions S. 95, Kids Come First Act of 2007; all provisions Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526155 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year ENV Bill not yet assigned; Environmental Bill, provisions relating to environmental issues Bill not yet assigned; Environmental Bill, provisions relating to global warming and climate change Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526156 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year ENG H.R. 6, CLEAN Energy Act of 2007; all provisions Bill not yet assigned, Energy Bill; provisions relating to energy issues Bill not yet assigned, Energy Bill; provisions relating to energy efficiency Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526157 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year IMM S. 1348, Comprehensive Immigration Reform Act of 2007; all provisions Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526158 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year TRD Bill not yet assigned, World Trade Organization Doha Round; all provisions Bill not yet assigned, United States-Colombia Free Trade Agreement; all provisions Bill not yet assigned, United States-Korea Free Trade Agreement; all provisions Bill not yet assigned, United States-Panama Free Trade Agreement; all provisions Bill not yet assigned, United Stated-Peru Free Trade Agreement; all provisions H.R. 556, National Security Foreign Investment Reform and Strengthened Transparency Act of 2007; all provisions H.R. 1229, Nonmarket Economy Trade Remedy Act of 2007; all provisions S. 740, Invest USA Act of 2007; all provisions Bill not yet assigned, Trade Promotion Authority; all provisions Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526159 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year TOR S. 186, Attorney-Client Privilege Protection Act of 2007; all provisions S. 349, Small Business and Work Opportunity Act of 2007; provisions relating to deducting fines and similar penalties paid to the government due to breaking the law Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526160 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year EDU H.R. 1867, National Science Foundation Authorization Act of 2007; provisions relating to improving math and science education H.R. 2272, 21st Century Competitiveness Act of 2007; provisions relating to research in science, technology, engineering, and mathematics S. 761, America Creating Opportunities to Meaningfully Promote Excellence in Technology, Education, and Science Act; provisions relating to improving math and science education and basic research in the physical sciences at National Science Foundation, National Institute of Standards and Technology, and Department of Education Office of Science Bill not yet assigned, No Child Left Behind Act Reauthorization; provisions relating to business priorities and principles H.R. 362, To Authorize Science Scholarships for Educating Mathematics and Science Teachers, and for Other Purposes; provisions relating to National Science Foundation programs to improve teaching of math and science H.R. 363, Sowing the Seeds Through Science and Engineering Research Act; provisions relating to National Science Foundation programs for graduate research in physical sciences Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-04:00
526161 THE BUSINESS ROUNDTABLE, INC. 7d626f0a-e95f-4e9f-9712-b00fbd459cf0 MM THE BUSINESS ROUNDTABLE, INC. 7543 BUSINESS ROUNDTABLE INC 2007 mid_year HOM H.R. 1684, Department of Homeland Security Authorization Act for Fiscal Year 2008; all provisions Education, Dept of,Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   4600000 0 0 2007-08-13T16:15:18-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);