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

5 rows where filing_uuid = "3ddf2d74-ef43-4e67-928b-8cec8a42e161" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 5

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
596649 CMFG LIFE INSURANCE COMPANY 3ddf2d74-ef43-4e67-928b-8cec8a42e161 Q1 CMFG LIFE INSURANCE COMPANY 80510 CMFG LIFE INSURANCE COMPANY 2008 first_quarter AGR HR 2419, "Farm Bill Extension Act of 2007." As the current Farm Bill was set to expire, sought appropriate extension legislation that would protect the crop insurance program by limiting the reduction of both administrative and operating expense reimbursement and the government's quota share. HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   70000 0 0 2008-04-17T17:37:12-04:00
596650 CMFG LIFE INSURANCE COMPANY 3ddf2d74-ef43-4e67-928b-8cec8a42e161 Q1 CMFG LIFE INSURANCE COMPANY 80510 CMFG LIFE INSURANCE COMPANY 2008 first_quarter TAX Supported preservation of credit unions' federal income tax exemption. Supported narrow application of IRC's unrelated business income tax (UBIT) provisions to state-chartered credit unions so that most sources of income remain exempt from federal income tax. HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   70000 0 0 2008-04-17T17:37:12-04:00
596651 CMFG LIFE INSURANCE COMPANY 3ddf2d74-ef43-4e67-928b-8cec8a42e161 Q1 CMFG LIFE INSURANCE COMPANY 80510 CMFG LIFE INSURANCE COMPANY 2008 first_quarter CSP HR 964, Identity Theft and Spyware Protection Act; HR 1525, Spyware Prevention Act; S 495, Personal Data Privacy and Security Act; S 239, Notification of Risk to Personal Data Act; S 1178, ID Theft Prevention Act; S 1260, Data Security Act. Sought effective legislation to protect consumers and reduce insurance risk without overburdening financial institutions and reduce insurance risk without overburdening financial institutions and insurance companies. HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   70000 0 0 2008-04-17T17:37:12-04:00
596652 CMFG LIFE INSURANCE COMPANY 3ddf2d74-ef43-4e67-928b-8cec8a42e161 Q1 CMFG LIFE INSURANCE COMPANY 80510 CMFG LIFE INSURANCE COMPANY 2008 first_quarter FIN HR 1537, Credit Union Regulatory Improvements Act. Supported legislation that would reduce regulatory burden on financial institutions and reduce or eliminate credit union member service limits. SEC rule to modify broker/dealer registration exemption for credit union service organizations (CUSOs) and to extend exemptions to credit unions to same extent as granted to banks and thrifts. HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   70000 0 0 2008-04-17T17:37:12-04:00
596653 CMFG LIFE INSURANCE COMPANY 3ddf2d74-ef43-4e67-928b-8cec8a42e161 Q1 CMFG LIFE INSURANCE COMPANY 80510 CMFG LIFE INSURANCE COMPANY 2008 first_quarter INS HR 2716 and HR 4299 - To Extend the Terrorism Risk Insurance Act. S 618 and HR 1081 - To End the Insurance Industry's Antitrust Exemption under the McCarran-Ferguson Act. S. 40 and HR 3200 - To Establish an Optional Federal Charter for Insurance Companies. Supported bill to reduce regulatory/filing burden on surplus lines insurers. HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of   70000 0 0 2008-04-17T17:37:12-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);