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 = "cf7c166b-bf45-438e-9841-efbb2d22a7ef" and issue_code = "MMM" 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
256246 REGENCE BLUECROSS BLUESHIELD OF UTAH cf7c166b-bf45-438e-9841-efbb2d22a7ef YY REGENCE BLUECROSS BLUESHIELD OF UTAH 87791 REGENCE BLUECROSS BLUESHIELD OF UTAH 2003 year_end MMM H.R. 1, Medicare Prescription Drug and Modernization Act of 2003, Title I -- Medicare Prescription Drug Benefit, Title II – Medicare Enhanced Fee-For-Service and Medicare Advantage Programs; Medicare Competition, Title III – Combating Waste, Fraud and Abuse, Title IV – Rural Health Care Improvements, Section 402 – Immediate Establishment of Uniform Standardized Amount in Rural and Small Urban Areas, Title V – Provisions Relating to Part A, Title VI – Provisions Relating to Part B, Title IX – Regulatory Reduction and Contracting Reform, Subtitle B- Contracting Reform, Subtitle C – Education and Outreach, and Title XI – Access to Affordable Pharmaceuticals. S. 1, Prescription Drug and Medicare Improvement Act of 2003, Title I – Medicare Prescription Drug Benefit, Section 101 – Medicare Voluntary Prescription Drug Delivery Program, Section 103 – Medigap, Section 111 – Medicare Prescription Drug Discount Card and Transitional Assistance for Low-Income Beneficiaries, Title II – Medicare Advantage, Title IV – Medicare Fee-For-Service Improvements, Section 421 – Establishment of Floor on Geographic Adjustments of Payments for Physician Services, Title V – Medicare Appeals, Regulatory and Contracting Improvements, Section 521 – Increased Flexibility in Medicare Administration, Section 531 – Provider Education and Technical Assistance, Section 532 – Access to and Prompt Responses from Medicare Contractors. Labor HHS Appropriations Bills, Medicare Contractor Funding provisions HOUSE OF REPRESENTATIVES,SENATE     0 0 2004-02-05T00:00:00-05: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);