lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "ec3fd4e5-4d9f-412f-a67f-9400c8fa8f22" and issue_code = "TEC" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3217645 | CHAMBER OF COMMERCE OF THE U.S.A. ec3fd4e5-4d9f-412f-a67f-9400c8fa8f22 | Q2 | CHAMBER OF COMMERCE OF THE U.S.A. | 38756 | CHAMBER OF COMMERCE OF THE U.S.A. | 2024 | second_quarter | TEC | H.R. 742, Telling Everyone the Location of Data Leaving the U.S. (TELL) Act H.R. 750, Chinese-owned Applications Using The Information of Our Nation (CAUTION) Act of 2023 H.R. 784, Internet Application I.D. Act H.R. 1050, Data Science and Literacy Act H.R. 1165, Data Privacy Act of 2023 H.R. 1341, Spectrum Coordination Act H.R. 3369, Artificial Intelligence Accountability Act H.R. 3459/S. 307, Increasing Competitiveness for American Drones Act of 2023 H.R. 3557, American Broadband Deployment Act of 2023 H.R. 4814, Consumer Safety Technology Act H.R. 5527, Modernizing Government Technology (MGT) Reform Act of 2023 H.R. 5628/S. 2892, Algorithmic Accountability Act H.R. 6929/S. 3565, Affordable Connectivity Program Extension Act of 2024 H.R. 7116, Do Not Disturb Act H.R. 7520, Protecting Americans Data from Foreign Adversaries Act of 2024 H.R. 7532, Federal AI Governance and Transparency Act H.R. 8070, Servicemember Quality of Life Improvement and National Defense Authorization Act for Fiscal Year 2025 H.R. 8315, Enhancing National Frameworks for Overseas Critical Export Act (ENFORCE Act) H.R. 8773, Financial Services and General Government Appropriations Act, 2025 S. 931, Strengthening Agency Management and Oversight of Software Assets Act S. 1094, Journalism Competition and Preservation Act (JCPA) of 2023 S. 1212, Securing and Enabling Commerce Using Remote and Electronic (SECURE) Notarization Act S. 1409, Kids Online Safety Act S. 1418, Children and Teens Online Privacy Protection Act S. 1671, Digital Platform Commission Act S. 1865, Transparent Automated Governance Act S. 1873, Global Technology Leadership Act S. 1993, No Section 230 immunity in AI Act S. 2032 Legacy IT Reduction Act of 2023 S. 2321, Commerce, Justice, Science, and Related Agencies Appropriations Act, 2024 S. 3312, Artificial Intelligence (AI) Research, Innovation, and Accountability Act of 2023 S. 3565, Affordable Connectivity Program Extension Act of 2024 S. 3849, Promoting United States Leadership in Standards Act of 2024 S. 4178, Future of A… | Agriculture, Dept of (USDA),Bureau of Industry and Security (BIS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Equal Employment Opportunity Commission (EEOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Highway Traffic Safety Administration (NHTSA),Natl Institute of Standards & Technology (NIST),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),Natl Telecommunications & Information Administration (NTIA),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),Patent & Trademark Office (PTO),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),Treasury, Dept of,Veterans Affairs, Dept of (VA) | 13930000 | 0 | 0 | 2024-07-22T14:27:27-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);