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

7 rows where filing_uuid = "f09c9ebd-0c2d-468f-8123-a7998d943608" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

issue_code 7

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 is_no_activity is_termination received_date
2591758 FORSCEY, PLLC f09c9ebd-0c2d-468f-8123-a7998d943608 Q1 FORSCEY, PLLC 52880 AMERICAN ASSOCIATION FOR JUSTICE 2021 first_quarter CPI Work on cybersecurity and data sharing legislation to narrow the preemptive effect of such legislation. Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT) 0 0 2021-04-02T18:23:48.827000-04:00
2591759 FORSCEY, PLLC f09c9ebd-0c2d-468f-8123-a7998d943608 Q1 FORSCEY, PLLC 52880 AMERICAN ASSOCIATION FOR JUSTICE 2021 first_quarter HOM Work in opposition to cyber security legislation, which would expand the definition of firms eligible for liability relief under existing law. Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT) 0 0 2021-04-02T18:23:48.827000-04:00
2591760 FORSCEY, PLLC f09c9ebd-0c2d-468f-8123-a7998d943608 Q1 FORSCEY, PLLC 52880 AMERICAN ASSOCIATION FOR JUSTICE 2021 first_quarter TEC Work in opposition to or to modify federal data breach and data privacy legislation that would preempt more protective state laws, limit or override the availability of state statutory and common law remedies or which would provide liability relief to firms and federal contractors in cases involving cyber security breaches. Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT) 0 0 2021-04-02T18:23:48.827000-04:00
2591761 FORSCEY, PLLC f09c9ebd-0c2d-468f-8123-a7998d943608 Q1 FORSCEY, PLLC 52880 AMERICAN ASSOCIATION FOR JUSTICE 2021 first_quarter TRA Work in support of amendments to im0prove remedies and insurance coverage under DOHSA, highway safety, maritime and aviation laws. Work in opposition to amendments that would reduce or eliminate the remedies available to foreign seamen under U.S. law. Work to limit pre-emptive effects of legislation authorizing and establishing rules governing the introduction of autonomous vehicles in the 50 states. Work in support of proposals to increase minimum insurance requirements for over the road truckers and in opposition to liability limitations for broker shippers. Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT) 0 0 2021-04-02T18:23:48.827000-04:00
2591762 FORSCEY, PLLC f09c9ebd-0c2d-468f-8123-a7998d943608 Q1 FORSCEY, PLLC 52880 AMERICAN ASSOCIATION FOR JUSTICE 2021 first_quarter HCR Work to modify proposed CMS regulation that would apply the Medicare Secondary Payer Act to liability settlements. Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT) 0 0 2021-04-02T18:23:48.827000-04:00
2591763 FORSCEY, PLLC f09c9ebd-0c2d-468f-8123-a7998d943608 Q1 FORSCEY, PLLC 52880 AMERICAN ASSOCIATION FOR JUSTICE 2021 first_quarter BUD Work on H.R. 1319 The American Rescue Plan Act in opposition to industry and employers efforts to obtain federal immunity from liability for COVID-19 claims by employees or customers of public facilities. Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT) 0 0 2021-04-02T18:23:48.827000-04:00
2591764 FORSCEY, PLLC f09c9ebd-0c2d-468f-8123-a7998d943608 Q1 FORSCEY, PLLC 52880 AMERICAN ASSOCIATION FOR JUSTICE 2021 first_quarter TOR Work to establish Federal limits on pre-dispute arbitration agreements. Work in support of amendments to the Federal Arbitration Act that would reduce or eliminate the use of predispute arbitration agreements. Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT) 0 0 2021-04-02T18:23:48.827000-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,
            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);