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

1 row where filing_uuid = "b8db79b9-4c8b-4e50-a4a3-8902b64de1e2" and issue_code = "GOV" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

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
1969156 AMERICAN ASSOCIATION FOR JUSTICE b8db79b9-4c8b-4e50-a4a3-8902b64de1e2 Q1 AMERICAN ASSOCIATION FOR JUSTICE 4733 AMERICAN ASSOCIATION FOR JUSTICE 2017 first_quarter GOV H.R. 985 (Fairness in Class Action Litigation Act of 2015); amends the federal judicial code to prohibit federal courts from certifying any proposed class unless the party seeking to maintain a class action affirmatively demonstrates through admissible evidentiary proof that each proposed class member suffered an injury of the same type and extent as the injury of the named class representatives. H.R. 725 (Innocent Party Protection Act); amends title 28, United States Code, to affect claims of fraudulent joinder. H.R. 720 (Lawsuit Abuse Reduction Act); amends Rule 11 of the Federal Rules of Civil Procedure to make sanctions mandatory. H.R. 5 (Regulatory Accountability Act); amends the Administrative Procedures Act (APA), which is the law that governs how federal agencies propose and establish regulations. S. 21/H.R. 26 (REINS Act); provides that major rules of the executive branch shall have no force or effect unless a joint resolution of approval is enacted into law. S. 34/H.R. 21 (Midnight Rules Relief Act); amends chapter 8 of title 5, United States Code, to provide for en bloc consideration in resolutions of disapproval for midnight rules. S. 56 (RED Tape Act of 2017); prohibits a federal agency from issuing a rule that causes a new financial or administrative burden on businesses or people in the United States unless the agency has repealed or amended two or more such existing rules. S. 69 (Regulatory Responsibility for our Economy Act of 2017); sets forth general requirements for the federal regulatory system, including the protection of public health, welfare, safety, and the environment, the promotion of predictability in the regulatory process, and the consideration of benefits and costs of regulations. S. 584/H.R. 33 (Small Business Regulatory Flexibility Improvements Act); amends chapter 6 of the Regulatory Flexibility Act, to ensure complete analysis of potential impacts on small entities of rules. H.R. 74 (REVIEW Act of 2017); prohibits a final agency rule from being published or taking e… Centers For Medicare and Medicaid Services (CMS),Consumer Financial Protection Bureau (CFPB),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   1510000 0 0 2017-04-20T12:52:39.517000-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);