lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where filing_uuid = "77cf6138-bbf6-47d8-aae2-e90c1cdd6794" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: specific_issues, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2701046 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | TRD | Tariffs on Chinese imports. S. 1260 - United States Innovation and Competition Act of 2021. H.R. 3975 - Generalized System of Preferences and Miscellaneous Tariff Bill Modernization Act of 2021 | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701047 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | UTI | Support for improving tap infrastructure | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701048 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | CSP | Bottled water quality; Per- and polyfluoroalkyl substances (PFAS) issues; Recycling issues including H.R. 2357 - RECOVER Act; H.R. 2238 and S. 984 - Break Free From Plastic Pollution Act; H.R. 2159 and S. 923 - RECYCLE Act | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701049 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | BEV | Recycling issues including H.R. 2357 - RECOVER Act; H.R. 2238 and S. 984 - Break Free From Plastic Pollution Act; H.R. 2159 and S. 923 - RECYCLE Act | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701050 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | FOO | Support for healthy hydration messaging in U.S. dietary policy, including the 2020 Dietary Guidelines for Americans; support for adding water to the MyPlate nutrition graphic; Recycling issues including H.R. 2357 - RECOVER Act; H.R. 2238 and S. 984 - Break Free From Plastic Pollution Act; H.R. 2159 and S. 923 - RECYCLE Act | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701051 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | CAW | Bottled water quality; Per- and polyfluoroalkyl substances (PFAS) issues; Recycling issues including H.R. 2357 - RECOVER Act; H.R. 2238 and S. 984 - Break Free From Plastic Pollution Act; H.R. 2159 and S. 923 - RECYCLE Act | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701052 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | NAT | General education regarding bottled water industry; Recycling issues including H.R. 2357 - RECOVER Act; H.R. 2238 and S. 984 - Break Free From Plastic Pollution Act; H.R. 2159 and S. 923 - RECYCLE Act | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701053 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | TRA | Truck weight limits; S. 659 and H.R. 1745 - DRIVE Safe Act | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701054 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | TAX | Plastic tax issues, including the Rewarding Efforts to Decrease Unrecycled Contaminants in Ecosystems (REDUCE) Act of 2021 (S. 2645 and H.R. 5389) | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-04:00 | |
| 2701055 | VAN NESS FELDMAN, LLP 77cf6138-bbf6-47d8-aae2-e90c1cdd6794 | Q3 | VAN NESS FELDMAN, LLP | 39815 | INTERNATIONAL BOTTLED WATER ASSOCIATION | 2021 | third_quarter | TRU | Truck weight limits; S. 659 and H.R. 1745 - DRIVE Safe Act | Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 50000 | 0 | 0 | 2021-10-20T11:47:56.293000-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);