lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where filing_uuid = "4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2206795 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | TOB | Discussions generally on required warnings for cigarette packaging and advertisements, including e-cigarettes | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-04:00 | |
| 2206796 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | GOV | Letter to Department of Commerce regarding the addition of a citizenship question to the 2020 census | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-04:00 | |
| 2206797 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | BEV | Discussions relating to youth exposure to alcohol beverage advertising and marketing | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-04:00 | |
| 2206798 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | COM | Comments and Petition for Reconsideration in regard to the Federal Communication Commission's Order, Protecting the Privacy of Customers of Broadband and Other Telecommunications Services S.J. Res 34 & H.J. Res. 86: A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Communications Commission relating to "Protecting the Privacy of Customers of Broadband and Other Telecommunications Services" H.R. 2520: Balancing the Rights of Web Surfers Equally and Responsibly Act of 2017 (BROWSER Act of 2017), setting requirements for providers of broadband internet access service and edge providers (websites, apps, etc.) regarding consumer online privacy S. 1989 and H.R. 4077: Honest Ads Act, which would require certain disclosures relating to public communications and electioneering communications online S. 2510 and H.R. 4682: Open Internet Preservation Act, prohibiting the blocking or throttling of lawful internet traffic based on content or other criteria S. 2639 and H.R. 5815: Customer Online Notification for Stopping Edge-Provider Network Transgressions Act (CONSENT Act), which sets requirements for edge providers on the use of consumer data | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-04:00 | |
| 2206799 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | ADV | Issues relating to the portrayals of women and girls in advertising | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-04:00 | |
| 2206800 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | TAX | Discussions with members of the Senate and House of Representatives on reform of the tax code, including draft proposals that would change the tax deductibility of advertising expenses Proposals to end the tax deduction for expenses for direct-to-consumer prescription drug advertising, including an amendment to H.R. 1 that would eliminate the deduction for prescription drug advertising expenses S.771 & H.R. 1776: Improving Access to Affordable Prescription Drugs Act, section 405 which would eliminate the tax deduction for expenses related to direct-to-consumer prescription drug advertising S. 2478: End Taxpayer Subsidies for Drug Ads Act, to disallow the tax deduction for expenses relating to direct-to-consumer advertising of prescription drugs | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-04:00 | |
| 2206801 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | FOO | Discussions generally on the marketing of food and beverage products to children | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-04:00 | |
| 2206802 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | PHA | Proposals relating to the regulation of direct-to-consumer prescription drug advertising H.R. 4385, Responsibility in Drug Advertising Act of 2017, which would prohibit DTC advertising of prescription drugs for the first three years after FDA approval Amendment to Labor-HHS appropriations bill and in omnibus appropriations bill (H.R. 6157) to require drug companies to list price information in direct-to-consumer prescription drug advertising | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-04:00 | |
| 2206803 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4e1ca9e2-e9a5-452f-aaa9-e12bef1ed9e0 | Q3 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 4653 | ASSOCIATION OF NATIONAL ADVERTISERS, INC. | 2018 | third_quarter | CPI | Discussions generally on draft legislation dealing with online privacy and data security Discussions with House and Senate staff on the advertising industry's self-regulatory program for interest-based advertising Discussions with Department of State on advertising industry self-regulation and privacy developments in the European Union Draft legislation dealing with a federal standard for online privacy and data protection | Commerce, Dept of (DOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Natl Telecommunications & Information Administration (NTIA),SENATE,Treasury, Dept of | 430000 | 0 | 0 | 2018-10-22T13:28:51.537000-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);