lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "fbbb1738-156b-4af7-96cb-eae4e4617ab2" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2084705 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | AVI | H.R.2825, Department of Homeland Security Authorization Act; Aviation security solutions and detection technologies for the Transportation Security Administration (TSA). | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084706 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | ENG | Conversations around liquid pipeline safety performance and voluntary standards for mechanical seals. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084707 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | DEF | H.R.2810/S.1519, National Defense Authorization Act for Fiscal Year 2018 (P.L.115-91); Issues related to CBRNE (Chemical, Biological, Radiological, Nuclear and Explosives) technology and detection solutions for the Department of Defense. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084708 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | ENV | Issues related to climate change and emissions technologies. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084709 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | TRD | Issues related to the North American Free Trade Agreement (NAFTA). | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084710 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | TAX | H.R.184, Protect Medical Innovation Act of 2017; S.108, Medical Device Access and Innovation Protection Act; H.R.1628, American Health Care Act of 2017/Better Care Reconciliation Act of 2017; H.R.1, Tax Cuts and Jobs Act (P.L.115-97); Issues related to the repeal of the medical device excise tax; tax reform; international tax issues; manufacturing and taxes. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084711 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | MMM | S.1738, Medicare Home Infusion Therapy Access Act of 2017; H.R.3178, Medicare Part B Improvement Act of 2017; issues related to patient infusion therapy. Reimbursement and policy issues related to non-opioid acute pain management. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084712 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | BUD | Funding for aviation security and homeland security technologies: H.R.3355/Senate, Department of Homeland Security Appropriations Act, 2018; Transportation Security Administration (TSA) funding issues. H.R.3219/Senate, Department of Defense Appropriations Act, 2018; chemical and biological counter measures. H.J.Res.123, Making further continuing appropriations for fiscal year 2018, and for other purposes (P.L.115-90); H.R.1370, Further Additional Continuing Appropriations Act, 2018 (P.L.115-96). | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084713 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | HOM | H.R.3355/Senate, Department of Homeland Security Appropriations Act, 2018; H.R.2142/S.708, INTERDICT ACT; Issues related to aviation security solutions and detection technologies for the Transportation Security Administration (TSA), Department of Homeland Security (DHS), U.S. Customs and Border Protection (CBP) and the Domestic Nuclear Detection Office (DNDO). Issues related to CBRNE (Chemical, Biological, Radiological, Nuclear and Explosives) technology and other border security solutions. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084714 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | MED | Implementation of 21st Century Cures Act (P.L.114-255); S.1738, Medicare Home Infusion Therapy Access Act of 2017; H.R.3178, Medicare Part B Improvement Act of 2017; issues related to patient infusion therapy. H.R.1628, American Health Care Act of 2017/Better Care Reconciliation Act of 2017; issues related to the medical device tax. Issues related to Medicare reimbursements for tracheotomy tubes. Medical device technology related to the opioid epidemic. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084715 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | TOR | H.R.906, Furthering Asbestos Claim Transparency (FACT) Act of 2017; H.R.985, Fairness in Class Action Litigation and Furthering Asbestos Claim Transparency Act of 2017; Issues related to tort reform. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-05:00 | |
| 2084716 | SMITHS GROUP SERVICES CORPORATION fbbb1738-156b-4af7-96cb-eae4e4617ab2 | Q4 | SMITHS GROUP SERVICES CORPORATION | 290137 | SMITHS GROUP SERVICES CORPORATION | 2017 | fourth_quarter | HCR | Reimbursement and policy issues related to non-opioid acute pain management. | Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Policy Development,SENATE,Transportation Security Administration (TSA),U.S. Customs & Border Protection,U.S. Trade Representative (USTR) | 580000 | 0 | 0 | 2018-01-22T13:30:17.460000-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);