lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
16 rows where filing_uuid = "c106fdcf-a6f3-4a7f-8c09-e18ce4e22335" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2764188 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | AVI | Funding for AIP program as part of stimulus negotiations and bipartisan infrastructure legislation. | Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764189 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | BUD | Priority issues with FY'21 appropriations process, FY'21 budget resolution; budget reconciliation and tax code provisions. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Highway Administration (FHA),Federal Transit Administration (FTA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764190 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | CAW | Funding for Clean Water SRF program, water funding as part of the INVEST Act, bipartisan infrastructure legislation. | Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764191 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | EDU | STEM education programs. | Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764192 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | ENG | Superfund and hazardous waste funding, energy policies for inclusion in bipartisan infrastructure legislation. | Energy, Dept of,Federal Energy Regulatory Commission (FERC),HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764193 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | GOV | Issues related to vaccination requirements for businesses and federal contractors. | Defense, Dept of (DOD),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT) | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764194 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | HCR | Issues related to federal vaccination requirements for businesses and federal contractors. | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764195 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | IMM | Expanding H-1b visas and other high-skilled visa categories. | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764196 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | ROD | Issues related to the reauthorization of the FAST Act; waiving provisions of the FAR as they apply to federally-funded transportation projects and firms that received PPP loans, funding as part of the bipartisan infrastructure package. | Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764197 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | TAX | Proposed tax code changes related to corporate and individual rates, Section 199A, international tax provisions, budget reconciliation. | HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764198 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | TRA | Funding for airports and surface transportation programs, reauthorization of the FAST Act, transportation programs authorized under the INVEST Act and bipartisan infrastructure legislation. | Federal Highway Administration (FHA),Federal Transit Administration (FTA),HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764199 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | TOR | Liability issues related to COVID and federal contractors and businesses. | Army, Dept of (Corps of Engineers),Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764200 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | FIN | Proposed tax code changes affecting engineering firms. | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764201 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | FOR | Funding for federal programs to promote trade in services. | HOUSE OF REPRESENTATIVES,SENATE,U.S. Agency for International Development (USAID),U.S. Trade Representative (USTR) | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764202 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | LBR | Diversity and inclusion policies affecting federal contractors. | HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05:00 | |
| 2764203 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES c106fdcf-a6f3-4a7f-8c09-e18ce4e22335 | Q3 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2021 | third_quarter | ENV | Funding for Superfund and other hazardous waste clean-up programs. | Council on Environmental Quality (CEQ),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 789450 | 0 | 0 | 2022-02-18T13:07:06-05: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);