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 = "a64fa4c2-e3ca-435b-b37d-010fbc4dda2d" and issue_code = "INS" 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
670613 AZOA SERVICES CORP(ALLIANZ OF AMERICA) FORMERLY AZOA SERIVCES CORP/FIREMAN'S FUND(ALLIANZ OF AMERICA a64fa4c2-e3ca-435b-b37d-010fbc4dda2d Q3 AZOA SERVICES CORP(ALLIANZ OF AMERICA) FORMERLY AZOA SERIVCES CORP/FIREMAN'S FUND(ALLIANZ OF AMERICA 14611 AZOA SERVICES CORP(ALLIANZ OF AMERICA) AND AFFILIATES 2008 third_quarter INS Insurance Reform: Advocate in support of an optional Federal Charter, H.R. 3200 and S.40, both titled "The National Insurance Act of 2007". These bills would create an optional federal charter for insurance. Also advocate for H.R. 5840, the Insurance Information Act of 2008. This bill would create an office of Insurance Information within the Treasury Department to provide federal expertise on insurance matters and international negotiations. Long Term Care insurance: Advocate in support of HR 3363 and S.2337, both titled the "Long-term Care Affordability and Security Act of 2007." These bills would allow long-term care insurance to be offered in employer-sponsored cafeteria plans flexible spending arrangements. Annuities/Suitability: Followed the drafting and then the introduction of S.2794, the "Senior Investor Protection Act of 2008", a bill which would hold insurance and securities companies liable for any potential mis-selling of their products by agents and brokers. the bill also required disclosures of fees, costs, and commissions. Also contacted Senate staff on the annuities suitability issues, separate from the introduction of the bill. Also followed SEC action on this issue. Holocaust insurance issues/ICHEIC: Lobbied against a bill introduced in the House, H.R. 1746, the "Holocaust Insurance Accountability Act of 2007", which would create a new cause of action against U.S. insurance companies with European affiliates that may have written life insurance policies involving Holocaust victims. the bill would also require any European insurer with policies written between 1900 and 1945 that may have involved holocaust victims to disclose all files on the policies, including names, to the U.S. Credit-based insurance scores: Lobbied against a bill introduced in the House, H.R. 5733, the "Nondiscriminatory Use of Consumer Reports and Consumer Information Act of 2008", which would restrict the ability of personal lines insurers to use credit information for underwriting or setting rates. Bond i… Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Risk Management Agency,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of   350000 0 0 2008-10-16T15:07:23-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);