lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "33b0a11e-e3db-4d27-be8a-75345e7b3fca" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1810937 | NFIB (NATIONAL FEDERATION OF INDEPENDENT BUSINESS) 33b0a11e-e3db-4d27-be8a-75345e7b3fca | 1A | NFIB (NATIONAL FEDERATION OF INDEPENDENT BUSINESS) | 27811 | NFIB (NATIONAL FEDERATION OF INDEPENDENT BUSINESS) | 2016 | first_quarter | SMB | House Bills H.R. 712, the Sunshine for Regulatory Decrees and Settlements Act - support. H.R. 1671, Government Neutrality in Contracting Act - support. S.J. Res. 22, a Congressional Review Act resolution of disapproval in response to the problematic Waters of the United States rule - support. H.R. 4612, the Midnight Rule Relief Act - support. H.R. 3624, the Fraudulent Joinder Prevention Act - support. H.R. 4293, the Affordable Retirement Advice Protection Act - support. H.R. 4294, the Strengthening Access to Valuable Education and Retirement Support Act - support. H.R. 3433, the Protecting Orderly and Responsible Transit of Shipments (PORTS) Act - support. Amendment included in Section 913 of S 1269 - oppose. H.R. 3765, The ADA Education and Reform Act of 2015 - support. H.R. 4773, the Protecting Workplace Advancement and Opportunity Act - support. H.R. 2911, the Small Business Healthcare Relief Act - support. Senate Bills S. 2582, the Midnight Rule Relief Act - support. S. 1519, the Protecting Orderly and Responsible Transit of Shipments (PORTS) Act - support. S. 2225, the Save our Small and Seasonal Businesses Act - support. Amendment included in Section 913 of S 1269 - oppose. S. 2707, the Protecting Workplace Advancement and Opportunity Act - support. Hearings Holly Wade testified before the Subcommittee on Economic Growth, Tax and Capital Access on Lip Service but Little Else: Failure of the Small Business Health Insurance Tax Credit on March 22, 2016. Comments Docket ID OSHA-2015-0018 - Memorandum to Open Docket for Comments on OSHA Safety and Health Program Management Guidelines. Occupational Safety and Health Administration, Department of Labor. February 9, 2016. Agency/Docket Number: 3046-0007/Document Number: 2016-01544. Equal Employment Opportunity Commission. March 31, 2016. Other Issues Joint employer standard PN1258 - Merrick Garland nomination to the U.S. Supreme Court Overtime Rule WOTUS | Equal Employment Opportunity Commission (EEOC),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Occupational Safety & Health Administration (OSHA),Office of Management & Budget (OMB),SENATE,Treasury, Dept of | 854000 | 0 | 0 | 2016-04-18T13:37:05.183000-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);