lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
14 rows where filing_uuid = "8693ae2d-1a9e-43d6-b4e2-e35ec899e27c" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2452536 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | ENV | Issues concerning Superfund site cleanups (no pending legislation) Issues concerning energy conservation, energy research and development, low global warming offerings, and programs administered by the EPA Issues related to mobile air conditioning, biofuels, fuel efficient vehicles, FGas regulation, various EPA rules, climate change, and energy efficiency Appropriations for EPA Cafe/GHG emissions standards | 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 | |
| 2452537 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | TAX | Issues related to FHA Issues related to implementation of PL 155-97 (H.R. 1) Issues related to TCJA Issues related to Global Digital Services Tax Proposals | 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 | |
| 2452538 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | TOR | H.R.985, Fairness in Class Action Litigation and furthering Asbestos Claim Transparency Act of 2017 | 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 | |
| 2452539 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | HCR | Issues related to public readiness and emergency preparedness Public Readiness and Emergency Preparedness (PREP) Act H.R.4982/S.3372 - the Health Care Workforce Protection Act of 2019/2020 | 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 | |
| 2452540 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | FOR | Issues related to Montreal Protocol Ratification | 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 | |
| 2452541 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | TRD | General issues related to existing trade policies Discussions regarding NAFTA Issues related to Sec. 301 tariffs on imports from China Issues related to Sec. 232 tariffs on steel and aluminum imports - Investigation of titanium sponge imports Issues related to US-Mexico-Canada Agreement (USMCA) Issues related to US-EU Commercial Aircraft Subsidies Dispute Executive Order 13873: Securing the Information and Communications Technology and Services Supply Chain U.S. Department of Commerce NPRM for Securing the Nations Information and Communications Technology and Services Supply Chain Issues related to Emerging and Foundational Technologies and Relevant Rules | 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 | |
| 2452542 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | DEF | Issues related to DARPA advanced technology programs (no pending legislation) Issues related to military energy efficiency programs (no pending legislation) Issues related to testing standards for ballistic materials (no pending legislation) Issues related to defense acquisition reform Issues related to US Army Improved Turbine Engine Program (ITEP) S.1790/H.R.2500, National Defense Authorization Act, 2020 H.R.2968, Defense Appropriations Department of Defense Cybersecurity Maturity Model Certification and DoD Commercial Pricing S.2641, Promoting American National Security and Preventing the Resurgence of ISIS Act of 2019; and S.482: Defending American Security from Kremlin Helicopter Safety and Terrain Awareness Warning Systems (TAWS) H.R. 5974 | 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 | |
| 2452543 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | FIN | Issues related to the regulatory outcomes and proposed rules resulting from the Dodd-Frank Issues related to Export-Import Bank of the U.S. Issues related to corporate governance S.2987, National Defense Authorization Act | 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 | |
| 2452544 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | AER | Issues related to classification of certain aerospace components for export licensing purposes(no pending legislation) Issues concerning export controls reform (no pending legislation) FAA Reauthorization Bill, heads up displays, Next Generation Air Transportation System Support NASA top line funding Issues related to Congressional Notification approval for CTS800 engine sale | 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 | |
| 2452545 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | TRA | Issues related to FAA, FHA, and automotive technology programs Issues related to Corporate Average Fuel Economy and greenhouse gas Issues related to environmentally friendly asphalt Issues related to autonomous vehicles Issues related to self-contained breathing apparatus (SCBA) testing Issues related to the Pipeline Safety Act Cockpit Voice Recorder / Flight Data Recorder / Timely Recovery of Data | 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 | |
| 2452546 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | BUD | FY20 Defense Appropriations FY20 Transportation Appropriations Issues related to funding for Department of Defense (DoD) electronic warfare, vibration management, turbine engines, advanced personal protective systems, advanced battery, electronic materials technologies, and training aircraft Survivable microelectronics, advanced communications and navigation, thermal management, and ballistic missile technologies (no pending legislation) Discussions regarding national debt FY20 Interior and Environment Appropriations: EPA budget related to Significant New Alternatives Program and Montreal Protocol FY20 State Department, Foreign Operations and Related Appropriations: State Department budget related to Montreal Protocol FY20 Department of Energy Office of Science Appropriations Discussions regarding Coronavirus Aid, Relief, and Economic Security (CARES) Act | 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 | |
| 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 | |
| 2452548 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | CPI | Privacy - issues related to data privacy; Consumer Online Privacy Rights Act; H.R. 2013 Information Transparency and Personal Data Control Act | 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 | |
| 2452549 | HONEYWELL INTERNATIONAL 8693ae2d-1a9e-43d6-b4e2-e35ec899e27c | Q1 | HONEYWELL INTERNATIONAL | 57453 | HONEYWELL INTERNATIONAL | 2020 | first_quarter | HOM | Issues related to hydrofluoric acid (no pending legislation) Issues related to cybersecurity legislation S.734/H.R.1668, Internet of Things Cybersecurity Improvement Act of 2019 S.1457, SUPPLY CHAIN Act of 2019 Issues related to: privacy legislation, 5G legislation, and AI legislation S.893/H.R. 2881 Secure 5G and Beyond Act of 2019 H.R. 2575 AI in Government Act of 2019 | 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);