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

3 rows where filing_uuid = "f85d01dc-66f0-4e67-977f-bdc3dfe2a0de" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 3

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
597330 DIRECT MARKETING ASSOCIATION, INC. f85d01dc-66f0-4e67-977f-bdc3dfe2a0de Q1 DIRECT MARKETING ASSOCIATION, INC. 12301 DIRECT MARKETING ASSOCIATION, INC. 2008 first_quarter TAX HR 3396, Sales Tax Fairness and Simplification Act HR 5267, to regulate certain State taxation of interstate commerce, and for other purposes. S 34, A bill to promote simplification and fairness in the administration and collection of sales and use taxes S 1726, A bill to regulate certain State taxation of interstate commerce Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   375000 0 0 2008-04-18T09:08:01-04:00
597331 DIRECT MARKETING ASSOCIATION, INC. f85d01dc-66f0-4e67-977f-bdc3dfe2a0de Q1 DIRECT MARKETING ASSOCIATION, INC. 12301 DIRECT MARKETING ASSOCIATION, INC. 2008 first_quarter POS No specific bill numbers - Any legislative matters impacting the implementation of the Postal Accountability and Enhancement Act (Public Law 109-432) Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   375000 0 0 2008-04-18T09:08:01-04:00
597332 DIRECT MARKETING ASSOCIATION, INC. f85d01dc-66f0-4e67-977f-bdc3dfe2a0de Q1 DIRECT MARKETING ASSOCIATION, INC. 12301 DIRECT MARKETING ASSOCIATION, INC. 2008 first_quarter COM HR 220, To protect the integrity and confidentiality of Social Security Numbers HR 251, Truth in Caller ID Act of 2007 HR 740, Preventing Harassment through Outbound Number Enforcement (PHONE) Act of 2007 HR 836, To better assure cyber security HR 852, To prohibit obtaining customer information from telecommunications carriers by false pretense HR 936, To prohibit fraudulent access to telephone records HR 948, To strengthen the authority of the Federal Government to protect individuals from certain acts and practices in the sale and purchase of Social Security Numbers HR 958, To protect consumers by requiring reasonable security policies and procedures to protect computerized data containing personal information HR 964, To protect users of the Internet from unknowing trasmission of their personally identifiable information through spyware programs HR 1383, To provide penalties for the misues of robocalls HR 1525, To discourage spyware, and for other purposes HR 1652, To amend the Telemarketing and Consumer Fraud and Abuse Act to authorize the FTC to issue new reules to establish a requirement to prohibit telmarketing calls during the hours of 5PM to 7PM HR 1685, Data Security Act of 2007 HR 1776, To require employees at a call center, who either initiate or receive phone calls, to disclose the physical location of such employees HR 2290, To better assure cyber security HR 2455, To prohibit the sale, purchase, and display to the general public of the Social Security account number HR 2601, To extend the authority of the FTC to collect fees to administer and enforce the provisions relating to the "Do_Not-Call" Registry of the Telemarketing Sales Rule HR 3046, To enhance Social Security Account Number Privacy Protections HR 3541, the Do-Not-Call Improvement Act of 2007 S 49, Protecting Children in the 21st Century Act S 92, Protecting Consumer Phone Records Act S 238, To limit the misues of Social Security numbers S 239, A bill to require Federal agencies, and persons engaged in interstate commerce, in possession o… Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   375000 0 0 2008-04-18T09:08:01-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);