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 = "3efbf183-e784-4a18-9d7d-5679d55aed67" 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
596421 THE AMERICAN OCCUPATIONAL THERAPY ASSOCIATION, INC. (AOTA) 3efbf183-e784-4a18-9d7d-5679d55aed67 Q1 THE AMERICAN OCCUPATIONAL THERAPY ASSOCIATION, INC. (AOTA) 2970 THE AMERICAN OCCUPATIONAL THERAPY ASSOCIATION, INC. (AOTA) 2008 first_quarter MMM S. 450 and HR 748, The Medicare Access to Rehabilitation Services Act of 2007 - All provisions, passage. HR 1846, The Access to Physical Medicine and Rehabilitation Services Improvement Act of 2007 - Opposed based on quality, cost accountability, and scope of practice concerns. S. 1224, Children's Health Insurance Program (CHIP) Reauthorization Act of 2007 - Advocated in support of the CHIP program and an expanded role for occuaptional therapy. H.R. 3162, Children's Health and Medicare Protections Act of 2007 (CHAMP) - Advocated for Medicare provision regarding therapy caps, 75% rule on inpatient rehabilitation facilities, SGR cuts and Medicaid provisions. S. 799 and H.R. 1621, The Community Choice Act - Supported all provisions. S. 578 and H.R. 1017, Protecting Children's Health in Schools Act - supported passage and maintaining Medicaid funding for school based administrative claiming and transportation services. H.R. 1809 and S. 2103, Medicare Independent Living Act - Supported the provision of improved access to mobility devices for people with disabilities. H.R. 4082 and S. 1980, Long-term Care Quality and Modernization Act of 2007 - Advocated for inclusion of occupational therapy in quality reporting. S. 932 and H.R. 1552, Medicare Patient Access to Physical Therapist Act of 2007 - Advocated regarding impact on occupational therapy. H.R. 1663, Medicare Mental Health Modernization Act of 2007 - Advocated for passage and improved role for occupational therapy. S. 1628, Nurse Faculty and Physical Therapist Education Act of 2007 - Advocated for inclusion of occupational therapy loan repayment. H.R. 4248, Ensuring Medicare Access to Recreational Thearpy Act - Opposed findings language referring to functional capacities and worked to amend that language. No bill number - Medicaid School-based Transportation and Administrative Claiming Costs - Before Congress, opposed elimination of reimbursement - advocated for a moratorium. No bill number - Medicaid Rehabilitation Services Proposed Rule - Before Con… Centers For Disease Control & Prevention (CDC),Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE   130000 0 0 2008-04-17T17:05:39-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);