lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

9 rows where filing_uuid = "b8f74cfd-e7d8-49fb-9161-1b4ac2cec663" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 9

filing_year 1

filing_period 1

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
846457 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter BEV Proposals to restrict the marketing of alcohol beverage products Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00
846458 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter FOO H.R. 1105 - Omnibus Appropriations Act, 2009, provision in the Financial Services report that requires a four-agency working group to study and develop recommendations for standards for the marketing of food when such marketing targets children who are 17 years old or younger or when such food represents a significant component of the diets of children Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00
846459 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter PHA Proposals to place a moratorium on prescription drug advertising and requiring a "fair balance" between risk and benefit information in prescription drug advertisements Proposals to extend FDA authority to over-the-counter drug advertisements H.R. 2175 - Familes for ED Decency Act, to prohibit the broadcast of drugs for erectile dysfuncton/male enhancement on indecency grounds Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00
846460 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter CPI S. 139 - Data Breach Notification Act, requiring notice to consumers when a security breach occurs H.R. 2221 - Data Accountability and Trust Act, setting standards for consumer data security and notice requirements FTC activity regarding development of self-regulatory principles for online behavioral advertising Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00
846461 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter COM H.R. 1084 - Commercial Advertisement Loudness Mitigation Act (CALM Act), to require the FCC to conduct a rulemaking regarding the volume of television commercials FCC Notice of Inquiry on blocking technologies and content ratings for television commercials Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00
846462 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter CSP H.R. 3126 - proposal to create a Consumer Financial Protection Agency as they relate to the FTC and the advertising industry Proposals to reauthorize the Federal Trade Commission FTC rulemaking making changes to guidelines on use of endorsements and testimonials in advertising Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00
846463 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter TOB S. 579 - Federal Tobacco Act of 2009, provisions restricting advertising practices for tobacco products to limit youth exposure H.R. 1256, S. 982 - Family Smoking Prevention and Tobacco Control Act, provisions transferring authority over tobacco advertising to FDA and requiring it to promulgate a rule to place limits on tobacco advertising H.R. 1261 - Youth Prevention and Tobacco Harm Reduction Act, provisions setting up a Tobacco Harm Reduction Center in the Department of Health and Human Services and setting up a commission to review and make recommendations to Congress on further advertising and marketing restrictions for tobacco products Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00
846464 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter TAX H.R. 2917 - To amend the Internal Revenue Code of 1986 to deny any deduction for advertising prescription drugs H.R. 2966 - Say No To Drug Ads Act, to prohibit the tax deduction for advertising of prescription drugs Proposals to fund health care reform by eliminating the tax deduction for advertisements of prescription drugs Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00
846465 ASSOCIATION OF NATIONAL ADVERTISERS, INC. b8f74cfd-e7d8-49fb-9161-1b4ac2cec663 Q3 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2009 third_quarter BUD Lobbying for increased funding for the Centers for Disease Control and Prevention's Division of Nutrition, Physical Activity and Obesity Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2009-10-20T12:06:20-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);