lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where filing_uuid = "b77d1fd5-e6e3-4e70-82e8-efea2b3466a5" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2637312 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. b77d1fd5-e6e3-4e70-82e8-efea2b3466a5 | Q2 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | AERONAUTICAL REPAIR STATION ASSOCIATION | 2021 | second_quarter | BUD | Supported enactment and implementation of economic relief programs for aviation sector, including enactment and implementation of new payroll support program for aviation maintenance providers and manufacturers, extension of Air Carrier Payroll Support Program, extension of Paycheck Protection Program (Aviation Manufacturing Jobs Protection Act (H.R. 553), American Rescue Plan Act (H.R. 1319)). Initiation of and full funding for aviation workforce grant programs created by Sec. 625 of 2018 Federal Aviation Administration (FAA) reauthorization law (no bill number). | Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 40000 | 0 | 0 | 2021-07-14T16:49:39.307000-04:00 | |
| 2637313 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. b77d1fd5-e6e3-4e70-82e8-efea2b3466a5 | Q2 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | AERONAUTICAL REPAIR STATION ASSOCIATION | 2021 | second_quarter | AVI | Encouraged federal policies to improve confidence in air travel during COVID-19 pandemic (no bill number). Opposed legislation that would disrupt the relationship between air carriers and their maintenance contractors, impose new and unnecessarily burdensome reporting requirements on air carriers, undermine the global competitiveness of the U.S. aerospace sector and subject the small business-dominated U.S. aviation maintenance industry to potential retaliation by foreign aviation authorities (no 117th Congress bill number; H.R. 5119 in 116th Congress). Encouraged investment in airport infrastructure, particularly maintenance hangars (no bill number). Encouraged parity in enforcement of FAA maintenance manual rules (no bill number). Supported Advanced Air Mobility Coordination and Leadership Act (HR 1339 and S 516) and related planning grants. Supported incentives for transition to sustainable aircraft fuel (no bill number). Supported clear standards for FAA approval of technical data required to perform major repair or alteration (no bill number). Supported creation of a National Center for Advancement of Aviation (S. 1752 and H.R. 3482). | Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 40000 | 0 | 0 | 2021-07-14T16:49:39.307000-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);