lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
3 rows where filing_uuid = "a10eae4f-b44b-4d5c-9884-77fdb81f36ea" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2260550 | BROWN & FORTUNATO, P.C. a10eae4f-b44b-4d5c-9884-77fdb81f36ea | 1T | BROWN & FORTUNATO, P.C. | 401104878 | INVACARE CORPORATION | 2019 | first_quarter | BUD | FY 2019 Military Construction and Veterans Affairs Appropriations Bill | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 0 | 1 | 2019-02-15T12:01:12.350000-05:00 |
| 2260551 | BROWN & FORTUNATO, P.C. a10eae4f-b44b-4d5c-9884-77fdb81f36ea | 1T | BROWN & FORTUNATO, P.C. | 401104878 | INVACARE CORPORATION | 2019 | first_quarter | TAR | Monitor and educate lawmakers about impact of proposed and final tariffs on goods from China; monitor and educate lawmakers about impact of tariffs imposed on steel and aluminum from certain countries. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 0 | 1 | 2019-02-15T12:01:12.350000-05:00 |
| 2260552 | BROWN & FORTUNATO, P.C. a10eae4f-b44b-4d5c-9884-77fdb81f36ea | 1T | BROWN & FORTUNATO, P.C. | 401104878 | INVACARE CORPORATION | 2019 | first_quarter | MMM | H.R. 750, Ensuring Access to Quality Complex Rehabilitation Technology Act of 2015; H.R. 3730 to Amend Title XVIII of the Social Security Act to provide for the non-application of Medicare competitive acquisition rates to complex rehabilitative wheelchairs and accessories; S. 486 Protecting Beneficiary Access to Complex Rehab Technology Act of 2017 and H.R. 1361 to Amend Title XVIII of the Social Security Act to provide for the non-application of Medicare competitive acquisition rates to complex rehabilitative manual wheelchairs and accessories; H.R. 4229 Protecting HOME Access Act of 2017. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 0 | 1 | 2019-02-15T12:01:12.350000-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,
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);