lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "8693ae2d-1a9e-43d6-b4e2-e35ec899e27c", filing_year = 2020 and issue_code = "ENG" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2452547 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | ENG | Issues related to energy efficiency in commercial and residential buildings, and advanced building controls Issues related to industrial technologies (no pending legislation) Issues related to carbon capture and sequestration technologies (no pending legislation) Issues related to nuclear power (no pending legislation) Issues related to Department of Energy wind technology programs (no pending legislation) Issues related to renewable energy (no pending legislation) Issues related to Smart Grid (no pending legislation) Issues related to natural gas Issues related to energy savings performance contracts Department of Energy appropriations S.1706/H.R.3079, Energy Savings and Public Private Partnership Act of 2019 S.1857, Federal Energy and Water Management Performance Act of 2019 S. 1245 All-of-the Above Federal Building Energy Conservation Act of 2019 S. 2137 Energy Savings and Industrial Competitiveness Act of 2019 Issues related to energy storage Issues related to smart metering Pipeline Safety Act American Energy Innovation Act (AEIA) | Agriculture, Dept of (USDA),Air Force, Dept of,Army, Dept of (Other),Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense Advanced Research Projects Agency (DARPA),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Federal Highway Administration (FHA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Economic Council (NEC),Natl Highway Traffic Safety Administration (NHTSA),Natl Institute of Standards & Technology (NIST),Natl Security Council (NSC),Navy, Dept of,Office of Management & Budget (OMB),Pipeline & Hazardous Materials Safety Administration,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office | 1240000 | 0 | 0 | 2020-04-20T18:34:40.787000-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);