lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "ed21630b-0b62-46ab-b539-89f11dac5a2b" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2860339 | SMITHBUCKLIN CORPORATION ed21630b-0b62-46ab-b539-89f11dac5a2b | Q3 | SMITHBUCKLIN CORPORATION | 35684 | NATIONAL LUMBER AND BUILDING MATERIAL DEALERS ASSOCIATION | 2022 | third_quarter | TAX | Issues related to the Death Tax Repeal Act of 2021 (H.R.1712/S.617); Issues related to the nations shortage of affordable housing and the Affordable Housing Credit Improvement Act of 2021 (H.R.2573/S.1136) | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2022-10-04T15:03:32-04:00 |
| 2860340 | SMITHBUCKLIN CORPORATION ed21630b-0b62-46ab-b539-89f11dac5a2b | Q3 | SMITHBUCKLIN CORPORATION | 35684 | NATIONAL LUMBER AND BUILDING MATERIAL DEALERS ASSOCIATION | 2022 | third_quarter | TRD | Issues related to the renewal of the U.S.-Canada Softwood Lumber Agreement; Issues related to tariffs issued under Section 301 of the Trade Act of 1974 | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2022-10-04T15:03:32-04:00 |
| 2860341 | SMITHBUCKLIN CORPORATION ed21630b-0b62-46ab-b539-89f11dac5a2b | Q3 | SMITHBUCKLIN CORPORATION | 35684 | NATIONAL LUMBER AND BUILDING MATERIAL DEALERS ASSOCIATION | 2022 | third_quarter | LBR | Issues related to addressing the ongoing labor shortages in the LBM industry and its supply chain; issues related to the National Apprenticeship Act of 2021 (H.R.447); Issues related to the Workforce Development Investment Act (H.R. 6778); Issues related to the tracking of workplace injuries and illnesses; Issues related to proposed new overtime regulations under the Fair Labor Standards Act; Issues related to COVID-19 vaccine requirements. | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE | 0 | 0 | 2022-10-04T15:03:32-04:00 |
| 2860342 | SMITHBUCKLIN CORPORATION ed21630b-0b62-46ab-b539-89f11dac5a2b | Q3 | SMITHBUCKLIN CORPORATION | 35684 | NATIONAL LUMBER AND BUILDING MATERIAL DEALERS ASSOCIATION | 2022 | third_quarter | HOU | Issues related to the nations shortage of affordable housing and the Affordable Housing Credit Improvement Act (H.R.2573/S.1136) | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2022-10-04T15:03:32-04:00 |
| 2860343 | SMITHBUCKLIN CORPORATION ed21630b-0b62-46ab-b539-89f11dac5a2b | Q3 | SMITHBUCKLIN CORPORATION | 35684 | NATIONAL LUMBER AND BUILDING MATERIAL DEALERS ASSOCIATION | 2022 | third_quarter | TRA | Issues related to the nations supply chain crisis and increasing the number of available truck drivers, and the Licensing Individual Commercial Exam-takers Now Safely and Efficiently (LICENSE) Act (H.R.6567/S.3556); Issues related to prioritizing supply chain resiliency and DOT implementation of the Infrastructure Investment and Jobs Act (H.R.3684) | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 0 | 2022-10-04T15:03:32-04:00 |
| 2860344 | SMITHBUCKLIN CORPORATION ed21630b-0b62-46ab-b539-89f11dac5a2b | Q3 | SMITHBUCKLIN CORPORATION | 35684 | NATIONAL LUMBER AND BUILDING MATERIAL DEALERS ASSOCIATION | 2022 | third_quarter | HOM | Issues related to the DHS COVID-19 vaccine requirements. | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2022-10-04T15:03:32-04:00 |
| 2860345 | SMITHBUCKLIN CORPORATION ed21630b-0b62-46ab-b539-89f11dac5a2b | Q3 | SMITHBUCKLIN CORPORATION | 35684 | NATIONAL LUMBER AND BUILDING MATERIAL DEALERS ASSOCIATION | 2022 | third_quarter | ECN | Issues related to Small Business Development Centers (SBDCs) and helping small businesses establish and improve their apprenticeship and job training programs; The Small Business Workforce Pipeline Act (H.R.7622); Issues related to legislation directing the SBAs Small Business Development Centers (SBDCs) and Womens Business Centers (WBCs) to assist small businesses in hiring graduates from career and technical education programs; The Supporting Small Business and Career and Technical Education Act (H.R.7664) | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,Small Business Administration (SBA) | 0 | 0 | 2022-10-04T15:03:32-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,
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);