lobbying: lobbying_activities: 350 rows where filing_period = "second_quarter", filing_year = 2017 and issue_code = "INS" sorted by filing

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

350 rows where filing_period = "second_quarter", filing_year = 2017 and issue_code = "INS" sorted by filing_year descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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_termination	received_date
1982372	FREEDMAN CONSULTING 73dec582-b3a6-4338-acf1-c50ef1e932e6	Q2	FREEDMAN CONSULTING	401103203	ALLIED WORLD ASSURANCE COMPANY HOLDINGS	2017	second_quarter	INS	Tax Reform legislation				1	2017-06-28T09:16:43.580000-04:00
1982439	THE MICHAEL LEWAN COMPANY af91d52f-d810-43a5-a8ff-b2be147b4da6	Q2	THE MICHAEL LEWAN COMPANY	22746	TRAVELERS COMPANIES INC AND SUBSIDIARIES	2017	second_quarter	INS	Tax Reform as it relates to Insurance	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2017-06-29T13:19:50.053000-04:00
1982512	ZERO PROSTATE CANCER da8fe355-4015-4010-9320-c05c720cfdef	Q2	ZERO PROSTATE CANCER	28388	ZERO PROSTATE CANCER	2017	second_quarter	INS	Health Insurance, Preventive Screenings	HOUSE OF REPRESENTATIVES,SENATE		39600	0	2017-06-30T13:00:12.643000-04:00
1982857	OMER F. BROWN, II LAW OFFICE c586d3f2-7254-4c6d-94d8-d73ee5a7144c	Q2	OMER F. BROWN, II LAW OFFICE	400367702	CONTRACTORS INTERNATIONAL GROUP ON NUCLEAR LIABILITY	2017	second_quarter	INS	Same as ENG	Commerce, Dept of (DOC),Energy, Dept of,Executive Office of the President (EOP),Nuclear Regulatory Commission (NRC),State, Dept of (DOS)			0	2017-07-04T09:10:12.113000-04:00
1983392	CALMETTO MANAGEMENT GROUP 4a345965-4623-4bca-bab2-21efdae07fb0	Q2	CALMETTO MANAGEMENT GROUP	21610	SELF-INSURANCE INSTITUTE OF AMERICA, INC.	2017	second_quarter	INS	HR 1304, the Self-Insurance Protection Act. Matters related to self-insurance and stop-loss coverage, captive insurance and the IRC 831(b)election.	HOUSE OF REPRESENTATIVES,SENATE	80000		0	2017-07-06T12:18:23.317000-04:00
1983445	HOLLAND & KNIGHT LLP f17e5df5-a480-4125-b576-38e56e531f33	2T	HOLLAND & KNIGHT LLP	18466	NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY	2017	second_quarter	INS	Tax treatment of inside buildup; tax treatment of life settlements.	SENATE	30000		1	2017-07-06T13:44:08.823000-04:00
1983847	AMERICAN SOCIETY FOR DERMATOLOGIC SURGERY ASSOCIATION 9f4a8bef-4022-4d2f-9ac2-f9a636f88622	Q2	AMERICAN SOCIETY FOR DERMATOLOGIC SURGERY ASSOCIATION	401103437	AMERICAN SOCIETY FOR DERMATOLOGIC SURGERY ASSOCIATION	2017	second_quarter	INS	Recommendations on health care reform legislation in the House and Senate Prohibiting HHS or any state from requiring a health care provider, as a condition of licensure, to comply with the requirements of meaningful use of electronic health records (HR 1766/Medical Practice Freedom Act)	Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE			0	2017-07-07T11:45:34.467000-04:00
1983987	CHANGE HEALTHCARE 87f5b7f4-a095-4e96-b2ec-3d4a1439482a	Q2	CHANGE HEALTHCARE	401103788	CHANGE HEALTHCARE	2017	second_quarter	INS	risk adjustment	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Medicare Payment Advisory Commission (MedPAC),SENATE			0	2017-07-07T14:36:42.803000-04:00
1984048	RICH FEUER ANDERSON 2c1695e8-1129-457a-8143-a86b22fc462f	Q2	RICH FEUER ANDERSON	84775	AMERICAN PROPERTY CASUALTY INSURERS ASSOCIATION	2017	second_quarter	INS	Regulatory structure for insurance and financial activities, including appropriate role of Federal Insurance Office and Federal Reserve.	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2017-07-07T16:17:13.980000-04:00
1984118	THE WILLIAMS GROUP 5ec5563e-5646-4cdf-8ca3-ed2a43338986	Q2	THE WILLIAMS GROUP	401104049	METLIFE GROUP, INC.(FKA METROPOLITAN LIFE)	2017	second_quarter	INS	Non-Bank SIFI Designation	HOUSE OF REPRESENTATIVES,SENATE	22500		0	2017-07-07T22:36:28.523000-04:00
1984156	DEMOTECH e30de409-fd28-472f-b4cb-e7878254c323	Q2	DEMOTECH	400720167	DEMOTECH	2017	second_quarter	INS	Insurance Company Rating(s) By Demotech, Inc.	SENATE			0	2017-07-09T11:57:00.607000-04:00
1984199	SUN LIFE FINANCIAL (U.S.) SERVICES COMPANY INC. 4af57e84-c6b5-454b-81b2-92d5221649f8	Q2	SUN LIFE FINANCIAL (U.S.) SERVICES COMPANY INC.	401104359	SUN LIFE FINANCIAL (U.S.) SERVICES COMPANY INC.	2017	second_quarter	INS	Lobbied in support of delaying DOL's 81 Fed. Reg. 92316	HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE			0	2017-07-09T14:10:13.257000-04:00
1984228	ROY RAMTHUN 602d0b2a-9194-4018-b03f-64490875f3b9	Q2	ROY RAMTHUN	400705117	AMERICAN BANKERS ASSOCIATION	2017	second_quarter	INS	Health savings accounts, high deductible health insurance plans, and related issues under the Internal Revenue Code and Affordable Care Act.	Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE	30000		0	2017-07-09T18:14:42.270000-04:00
1984404	MORTGAGE GUARANTY INSURANCE CORPORATION 5d273e7e-9b92-46f2-aaa6-541e895b1cac	Q2	MORTGAGE GUARANTY INSURANCE CORPORATION	401103768	MORTGAGE GUARANTY INSURANCE CORPORATION	2017	second_quarter	INS	Housing Finance Reform and Taxation	HOUSE OF REPRESENTATIVES,SENATE		30000	0	2017-07-10T12:41:13.363000-04:00
1984458	VALANZANO & ASSOCIATES e8c77df5-8583-4018-8d3a-753de626727e	Q2	VALANZANO & ASSOCIATES	39735	COUNCIL OF INSURANCE AGENTS & BROKERS	2017	second_quarter	INS	Monitor the implementation of the reauthorization of Terrorism Risk Insurance Act (TRIA), specifically regarding data collection and the National Assoc. of Registered Agents and Brokers Reform Act, as included in that Act. Also monitor the activities of the FIO Advisory Committee on Alternative Risk Sharing Mechanisms for TRIA. Monitor issues re implementation of health insurance reform, and efforts to repeal and replace the ACA as in the American Health Care in the budget reconciliation act (H.R.1628). Support efforts to repeal the Cadillac Tax as in H.R.173, and S.58. Monitor tax reform proposals generally and support efforts to preserve the current tax treatment for employer sponsored health plans and other employee benefits. Support efforts to maintain current treatment of self-insured plans. Support efforts to exclude financial services from border tax proposals. Monitor efforts to make changes in the Dodd-Frank Act, as they may relate to insurance. Monitor the activities of the Federal Insurance Office and the development of insurance modernization proposals. Monitor issues related to cyber security and the cyber security insurance market. Support the clarification of the Foreign Account Tax Compliance Act to exclude property/casualty insurance as in H.R. 871. Support the reauthorization of the National Flood Insurance Program, particularly the Flood Insurance Market Parity and Modernization Act (S. 563 & H.R. 1422), the Repeatedly Flooded Communities Preparation Act (H.R. 1558), the NFIP Policyholder Protection Act of 2017 (H.R. 2868), the 21st Century Flood Reform Act of 2017 (H.R. 2874), the NFIP Administrative Reform Act of 2017 (H.R. 2875), the Taxpayer Exposure Mitigation Act of 2017 (H.R. 2246), and H.R. 2565 requiring use of replacement cost in determining premium rates. Monitor issues related insurance generally.	HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of			0	2017-07-10T13:42:16.003000-04:00
1984486	VALANZANO & ASSOCIATES 0e476b1b-070b-4d59-bb95-4c84ba229d4a	2A	VALANZANO & ASSOCIATES	39735	COUNCIL OF INSURANCE AGENTS & BROKERS	2017	second_quarter	INS	Monitor the implementation of the reauthorization of Terrorism Risk Insurance Act (TRIA), specifically regarding data collection and the National Assoc. of Registered Agents and Brokers Reform Act, as included in that Act. Also monitor the activities of the FIO Advisory Committee on Alternative Risk Sharing Mechanisms for TRIA. Monitor issues re implementation of health insurance reform, and efforts to repeal and replace the ACA as in the American Health Care in the budget reconciliation act (H.R.1628). Support efforts to repeal the Cadillac Tax as in H.R.173, and S.58. Monitor tax reform proposals generally and support efforts to preserve the current tax treatment for employer sponsored health plans and other employee benefits. Support efforts to maintain current treatment of self-insured plans. Support efforts to exclude financial services from border tax proposals. Monitor efforts to make changes in the Dodd-Frank Act, as they may relate to insurance. Monitor the activities of the Federal Insurance Office and the development of insurance modernization proposals. Monitor issues related to cyber security and the cyber security insurance market. Support the clarification of the Foreign Account Tax Compliance Act to exclude property/casualty insurance as in H.R. 871. Support the reauthorization of the National Flood Insurance Program, particularly the Flood Insurance Market Parity and Modernization Act (S. 563 & H.R. 1422), the Repeatedly Flooded Communities Preparation Act (H.R. 1558), the NFIP Policyholder Protection Act of 2017 (H.R. 2868), the 21st Century Flood Reform Act of 2017 (H.R. 2874), the NFIP Administrative Reform Act of 2017 (H.R. 2875), the Taxpayer Exposure Mitigation Act of 2017 (H.R. 2246), and H.R. 2565 requiring use of replacement cost in determining premium rates. Monitor issues related insurance generally.	HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of			0	2017-07-10T13:55:50.860000-04:00
1985028	MARSHFIELD CLINIC HEALTH SYSTEM 5e231365-9255-4d8c-aafb-be5807644fd2	Q2	MARSHFIELD CLINIC HEALTH SYSTEM	57830	MARSHFIELD CLINIC HEALTH SYSTEM	2017	second_quarter	INS	HR 1628, the American Health Care Act (AHCA) will result in a large number of individuals covered under the Affordable Care Act (ACA) with preexisting conditions to lose the necessary coverage to maintain their health. MCHS recommended opposition to the AHCA and any changes to the coverage afforded by the ACA. The changes proposed under the AHCA will undermine what works in the ACA without improving on the circumstances, coverage and care of Wisconsin residents in the individual and small group market. We urged Congress to take steps to improve and repair health coverage in the areas where the ACA was falling short, and to also maintain the gains that the ACA has provided to assure that no one, especially those near poverty, fall through the cracks: Near term stability of the individual market: In the short term, it is imperative the individual market remain a stable, viable option for people to get and maintain coverage. Through Security Health Plan, Marshfield Clinic Health System has seen many people who previously did not have coverage secure coverage, sometimes for the first time. Ensuring that this market is stable through 2018 will give enrollees and health insurers time to enact new reforms aimed at making care more affordable in the long term. Maintaining coverage for the near poverty population: Replacement plans should consider the low income population under 250 percent of the Federal Poverty Line. Half of Security Health Plans membership purchasing a plan on the individual market falls into this category. The AHCAs elimination of cost sharing subsides would have a significant impact on the affordability of care and will increase bad debt to providers which ultimately increases costs for everyone. Stability and continuity of coverage for this population is critical to the health of rural Wisconsin. Reduction in uncollected medical debt: Hand in hand with coverage of the near poverty population is the reduction in uncollected medical debt care providers have experienced. This reduction has all…	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA)		90000	0	2017-07-11T13:31:19.420000-04:00
1985463	WILLIAMS AND JENSEN, PLLC 6203a534-b09b-4b91-853a-46a2f600129b	Q2	WILLIAMS AND JENSEN, PLLC	41454	REINSURANCE ASSOCIATION OF AMERICA	2017	second_quarter	INS	Terrorism Risk Insurance; National Flood Insurance Program issues; Reinsurance Coverage; Natural disaster insurance mitigation; insurance and reinsurance legislation. 31 USC 314 covered agreements. International insurance standards.	HOUSE OF REPRESENTATIVES,SENATE	40000		0	2017-07-12T08:41:22-04:00
1985488	WILLIAMS AND JENSEN, PLLC c14e653c-cc35-4f4d-9a78-a2f072e3827c	Q2	WILLIAMS AND JENSEN, PLLC	41454	NATIONAL COALITION FOR ACCESS TO AUTISM SERVICES (NCAAS)	2017	second_quarter	INS	Access to autism services for those with Autism Spectrum Disorder in the context of health care legislation and CHIP Reauthorization.	HOUSE OF REPRESENTATIVES,SENATE	70000		0	2017-07-12T09:24:55.473000-04:00
1985525	ROBERTSON, MONAGLE & EASTAUGH LLC f85528f7-e159-44cf-b173-f32e09f12cc2	Q2	ROBERTSON, MONAGLE & EASTAUGH LLC	33454	CITY OF MARATHON	2017	second_quarter	INS	National Flood Insurance Program (NFIP) reform; communications with Florida House & Senate staff regarding NFIP re-authorization efforts in the 115th Congress	Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE	10815		0	2017-07-12T10:05:43.917000-04:00
1985655	WILLIAMS AND JENSEN, PLLC b0be6481-bed1-4102-b099-6a41c0dbb65b	Q2	WILLIAMS AND JENSEN, PLLC	41454	TRANSAMERICA COMPANIES (FORMLY AEGON)	2017	second_quarter	INS	Banking reform impacting insurance companies.	Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE	70000		0	2017-07-12T11:22:20.173000-04:00
1985925	NATIONAL ASSOCIATION OF SURETY BOND PRODUCERS 28eb77df-1de8-41b9-aa94-e0dc3180e5e6	Q2	NATIONAL ASSOCIATION OF SURETY BOND PRODUCERS	27183	NATIONAL ASSOCIATION OF SURETY BOND PRODUCERS	2017	second_quarter	INS	Advocated for introduction of legislation, including an amendment to the National Defense Authorization Act, to exempt the Miller Act, 40 USC Section 3131 et seq., a remedial statute affording payment protections to subcontractors and others working on federal construction contracts, from periodic indexing for inflation.	HOUSE OF REPRESENTATIVES,SENATE		50000	0	2017-07-12T14:51:45.430000-04:00
1986004	MR. GAYLORD HUGHEY c4a7ec04-fdb5-41c2-a99d-7434652486de	Q2	MR. GAYLORD HUGHEY	296817	HEARTLAND SECURITY INSURANCE GROUP	2017	second_quarter	INS	Workers compensation	Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE			0	2017-07-12T16:17:12.830000-04:00
1986229	AMERICAN COUNCIL OF LIFE INSURERS badec123-9883-4a74-be03-6aa4c22fa855	Q2	AMERICAN COUNCIL OF LIFE INSURERS	2115	AMERICAN COUNCIL OF LIFE INSURERS	2017	second_quarter	INS	Public Law 111-203, H.R. 4173- Dodd-Frank Wall Street Reform and Consumer Protection Act. Issue: Implementation and Regulatory reform. Captive Reinsurance Transactions, Insurance Capital Standards and Global Capital Standards. Implementation of S. 2270 - Insurance Capital Standards Clarification Act of 2014. The bill would give the Federal Reserve the authority to tailor capital standards for insurance companies subject to Fed supervision. Issue: Capital Standards, Basel III H.R. 372 - Competitive Health Insurance Reform Act of 2017. This bill would restore the application of the Federal antitrust laws to the business of health insurance to protect competition and consumers. Issue: McCarran-Ferguson Act. H.R. 1270 - Living Donor Protection Act of 2017. The bill would promote and protect from discrimination living organ donors. Issue: underwriting. H.R. ___ - Draft legislation to amend the Consumer Financial Protection Act of 2010 to clarify the authority of the Bureau of Consumer Financial Protection with respect to persons regulated by a State insurance regulator. Issue: regulation of insurance companies.	HOUSE OF REPRESENTATIVES,SENATE		1132000	0	2017-07-13T10:05:32.617000-04:00
1986333	DYKEMA GOSSETT PLLC 39c414ac-7b78-4cdc-ab6b-c8f8dc915b3c	Q2	DYKEMA GOSSETT PLLC	12915	JOHN HANCOCK LIFE INSURANCE COMPANY (U.S.A.)	2017	second_quarter	INS	Support Congressional action regarding insurance regulatory issues, including implementation of Dodd Frank Act.	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2017-07-13T10:40:41.093000-04:00
1986524	ALPINE GROUP PARTNERS, LLC. 8ce0bafe-f8e8-4440-8fb3-c3df3033607f	Q2	ALPINE GROUP PARTNERS, LLC.	1171	LOUISIANA FLOOD RISK COALITION	2017	second_quarter	INS	Issues associated with the National Flood Insurance Program, including reauthorization Issues associated with mitigating flood risk Hurricane protection and flood control	HOUSE OF REPRESENTATIVES,SENATE	10000		0	2017-07-13T11:57:15.650000-04:00
1986726	INDEPENDENT INSURANCE AGENTS & BROKERS OF AMERICA 1142d5fe-28ff-4cea-a30c-28a2e90b220b	Q2	INDEPENDENT INSURANCE AGENTS & BROKERS OF AMERICA	19228	INDEPENDENT INSURANCE AGENTS & BROKERS OF AMERICA	2017	second_quarter	INS	PL-114-1 TRIA/NARAB II Implementation DOL Fiduciary Standard (insurance provisions) HFIAA (Homeowner Flood Insurance Affordability Act) Implementation HR 1422 & S 563- Flood Insurance Market Parity Act (all provisions) HR 871 - Foreign Account Tax Compliance (all provisions) HR 10 - CHOICE Act (insurance provisions) Liability Risk Retention Act (generally) HR 1423- National Flood Insurance Program Reauthorization and Improvement Act of 2017 (all provisions) HR 355- Protecting American Families Retirement Act (all provisions) HR 2874- 21st Century Flood Reform Act (all provisions) HR 2875- National Flood Insurance Program Administrative Reform Act of 2017 (all provisions) HR 1558 Repeatedly Flooded Communities Preparation Act (all provisions) HR 2246- Taxpayer Exposure Mitigation Act of 2015 (all provisions) HR 2868 - National Flood Insurance Program Policyholder Protection Act of 2017(all provisions) HR 2565- Require the Use of Replacement Cost Rule in Determining Premium Rates for Flood Insurance (all provisions) S. 1368- Sustainable Affordable, Fair, and Efficient (SAFE) National Flood Insurance Program Reauthorization Act of 2017 (all provisions) S. 1313- Flood Insurance Affordability and Sustainability Act of 2017 (all provisions) HR 2170- Flood and Agriculture and Risk Management Reduction Act (all provisions)	Agriculture, Dept of (USDA),Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Treasury, Dept of		480000	0	2017-07-13T14:40:11.163000-04:00
1987085	DENTONS US LLP 66136394-1fa4-4c9f-92b2-003b9e8d985b	Q2	DENTONS US LLP	36105	AMERICAN COLLEGE HEALTH ASSOCIATION	2017	second_quarter	INS	Any legislative proposals to repeal and replace the Affordable Care Act; Provisions of the American Health Care Act, HR 1628 to provide a tax credit for purchase of insurance in the individual market;	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2017-07-13T19:27:00.367000-04:00
1987334	THE SMITH-FREE GROUP, LLC dada86db-d01d-4d88-8574-e6cc9077eb29	Q2	THE SMITH-FREE GROUP, LLC	35800	PRECAST/PRESTRESSED CONCRETE INSTITUTE	2017	second_quarter	INS	Monitored H.R.2875, National Flood Insurance Program Administrative Reform Act of 2017	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2017-07-14T11:29:06.177000-04:00
1987546	FIDELIS GOVERNMENT RELATIONS c1143319-2087-40b4-a964-9ea41b9638ff	Q2	FIDELIS GOVERNMENT RELATIONS	306011	AFLAC	2017	second_quarter	INS	Personnel issues, Insurance regulation generally	Executive Office of the President (EOP),Office of the Vice President of the United States	45000		0	2017-07-14T13:04:05.290000-04:00
1987562	K&L GATES, LLP 854ed42d-89d4-49e3-ae83-7af70e0a733e	Q2	K&L GATES, LLP	32098	FORTERRA, INC.	2017	second_quarter	INS	H.R. 1101, Small Business Health Fairness Act of 2017, entire bill. Yet to be introduced Labor-HHS FY2018 Appropriations: issues pertaining to DoL audits of association health plans.	HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE	20000		0	2017-07-14T13:13:23.040000-04:00
1987665	LINCOLN NATIONAL CORPORATION fccbbaaa-5bea-40e9-984f-d81e54f0f8c4	Q2	LINCOLN NATIONAL CORPORATION	22872	LINCOLN NATIONAL CORPORATION	2017	second_quarter	INS	PL 111-203 Dodd-Frank Wall Street Reform and Consumer Protection Act. Issues: implementation, regulatory reform, captive reinsurance transactions, insurance capital standards and global capital standards.	HOUSE OF REPRESENTATIVES,SENATE		290000	0	2017-07-14T13:59:51.197000-04:00
1987702	NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) ba1f9e9c-edd5-4f11-97f0-8a4375db1293	Q2	NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC)	85071	THE TRAVELERS COMPANIES, INC. AND SUBSIDIARIES	2017	second_quarter	INS	General issues relating to the Insurance industry - no specific legislation	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2017-07-14T14:23:28.020000-04:00
1987765	HACKENSACK MERIDIAN HEALTH 9e4cb324-80e0-443d-b5ad-aa4d67acbf26	Q2	HACKENSACK MERIDIAN HEALTH	401104109	HACKENSACK MERIDIAN HEALTH	2017	second_quarter	INS	Population health/Accountable Care Organizations (ACO's) ACE Kids Act (S. 298/H.R. 546) Veterans Affairs access to providers	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA)		40000	0	2017-07-14T14:54:14.183000-04:00
1987773	AMERICAN OSTEOPATHIC ASSOCIATION de94c557-2fec-4513-a8eb-f05e69eb5657	Q2	AMERICAN OSTEOPATHIC ASSOCIATION	3014	AMERICAN OSTEOPATHIC ASSOCIATION	2017	second_quarter	INS	American Health Care Act; Better Care Reconciliation Act; Professional Liability Insurance; Health Insurance	Agency for Healthcare Research & Quality (AHRQ),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Executive Office of the President (EOP),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Medicare Payment Advisory Commission (MedPAC),Office of Management & Budget (OMB),SENATE,White House Office		291476	0	2017-07-14T14:56:16.060000-04:00
1987872	NATIONAL ASSOCIATION OF INSURANCE AND FINANCIAL ADVISORS 82e524f8-b061-446a-82d6-4ece97957d76	Q2	NATIONAL ASSOCIATION OF INSURANCE AND FINANCIAL ADVISORS	26901	NATIONAL ASSOCIATION OF INSURANCE AND FINANCIAL ADVISORS	2017	second_quarter	INS	Issues relating to insurance regulatory reform and agent compensation. Issues related to the implementation of of the Patient Protection and Affordable Care Act: S. 28, H.R. 247, H.R. 246, S. 58, H.R. 173. Issues related to terrorism risk insurance. Issues related to flood risk insurance. Issues related to the regulation of insurance competition, products with guarantees, individual and employer owned policies, and fiduciary client relationships.	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of		565000	0	2017-07-14T15:31:49.817000-04:00
1988312	LARRY BLANCHARD f94e726c-b1ca-41b7-a95d-df6dce7c1aeb	Q2	LARRY BLANCHARD	400470324	TRUSTAGE	2017	second_quarter	INS	No specific bill; tax reform in general as related to insurance	HOUSE OF REPRESENTATIVES,SENATE	12500		0	2017-07-16T19:35:37.863000-04:00
1988315	BROYDRICK & ASSOCIATES 51b2ea5d-7269-4c3f-9fb1-c254610404df	Q2	BROYDRICK & ASSOCIATES	7268	DIRECT SUPPLY INC	2017	second_quarter	INS	Post-acute Care Purchasing Act. All healthcare related financing and coverage issues.	HOUSE OF REPRESENTATIVES,SENATE			0	2017-07-16T19:53:43.133000-04:00
1988434	WILLIAMS AND JENSEN, PLLC 1ba9bb9a-dfc7-436b-ac5e-4a69d606361b	Q2	WILLIAMS AND JENSEN, PLLC	41454	AMERICAN ASSOCIATION OF CROP INSURERS (AACI)	2017	second_quarter	INS	USDA's Rick Management Agency (RMA) - Federal Crop Insurance Corp. (FCIC) regarding its general administration of the federal crop insurance program; negotiation with RMA on the Standard Reinsurance Agreement; 2014 Farm Bill provisions regarding the crop insurance program (PL 113-79); reauthorization of 2014 Farm Bill regarding the crop insurance programs.	Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE	60000		0	2017-07-17T09:24:04.210000-04:00
1988570	AMERICAN FOREIGN SERVICE ASSOCIATION 11eb6c60-12fd-45ca-9f82-d262f843ea81	Q2	AMERICAN FOREIGN SERVICE ASSOCIATION	2365	AMERICAN FOREIGN SERVICE ASSOCIATION	2017	second_quarter	INS	Long Term Care Insurance	HOUSE OF REPRESENTATIVES,SENATE		10000	0	2017-07-17T10:12:37.027000-04:00
1988703	DALY CONSULTING GROUP 7a0e5caf-c792-4b7b-85f2-75872f8ba9d4	Q2	DALY CONSULTING GROUP	400923683	TRAVELERS COMPANIES INC AND SUBSIDIARIES (WAS THE TRAVELERS COMPANIES INC	2017	second_quarter	INS	Insurance and corporate governance issues.	HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE	60000		0	2017-07-17T10:50:21.687000-04:00
1988759	GREATER NEW ORLEANS, INC. 7e6c8d88-7be8-4553-96bf-9e11ab3b4f91	Q2	GREATER NEW ORLEANS, INC.	401103215	GREATER NEW ORLEANS, INC.	2017	second_quarter	INS	Advocacy to reauthorize and reform the National Flood Insurance Program	HOUSE OF REPRESENTATIVES,SENATE		30000	0	2017-07-17T11:08:05.893000-04:00
1988785	DALY CONSULTING GROUP f336d5d8-2efe-4fc6-97ea-b75388b6640b	Q2	DALY CONSULTING GROUP	400923683	THE GUARDIAN LIFE INSURANCE COMPANY OF AMERICA	2017	second_quarter	INS	Issues related to life insurance.	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2017-07-17T11:15:24.207000-04:00
1988852	AMERICAN VETERINARY MEDICAL ASSOCIATION 3539675f-dcc7-4d3d-a4e8-ff11f0391368	Q2	AMERICAN VETERINARY MEDICAL ASSOCIATION	3630	AMERICAN VETERINARY MEDICAL ASSOCIATION	2017	second_quarter	INS	Better Care Reconciliation Act of 2017 (Draft) H.R. 1101, Small Business Health Fairness Act of 2017 ENZI draft bill on small Business Health Care	Agriculture, Dept of (USDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE		200000	0	2017-07-17T11:31:50.880000-04:00
1988872	CMFG LIFE INSURANCE COMPANY 7471f836-b8dd-4070-a2d0-000971579ed9	Q2	CMFG LIFE INSURANCE COMPANY	80510	CMFG LIFE INSURANCE COMPANY	2017	second_quarter	INS	Work to keep insurance regulated by the states and not by the Consumer Financial Protection Bureau or set by international bodies. Oppose legislation to repeal the McCarran - Ferguson antitrust exemption for the business of insurance. Support a best interest fiduciary standard for retirement advice and products as proposed by the Department of Labor that is effectively and efficiently workable in the market. Advocate for stronger data security - particularly with regard to merchant plastic card data breaches. Support insurance reform provisions that will provide regulatory relief in the CHOICE 2.0 bill, H.R. 10. Reinforce the limitation on the CFPB in regulating the business of insurance.	HOUSE OF REPRESENTATIVES,Natl Credit Union Administration (NCUA),SENATE,Treasury, Dept of		122875	0	2017-07-17T11:36:04.037000-04:00
1988922	CAPITAL HEALTH SYSTEM 65fe7d4c-6a4e-4996-ab9f-f196513e6d45	Q2	CAPITAL HEALTH SYSTEM	401104159	CAPITAL HEALTH SYSTEM	2017	second_quarter	INS	American Care Health Act H.R. 1628 Better Care Reconciliation Act of 2017 (H.R. 1628)senate Verson	HOUSE OF REPRESENTATIVES,SENATE			0	2017-07-17T11:47:33.007000-04:00
1988940	MODA HEALTH 23752fa0-ecf4-4a37-a17e-8fe2a00a6a07	Q2	MODA HEALTH	401103888	MODA HEALTH	2017	second_quarter	INS	Affordable Care Act risk mitigation provisions, specifically restoration of funding to cover those provisions.	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE		110000	0	2017-07-17T11:49:45.883000-04:00
1988967	MEHLMAN CONSULTING, INC. 0051b583-3d58-450b-a577-a81652c43493	Q2	MEHLMAN CONSULTING, INC.	284950	BLUE CROSS BLUE SHIELD OF ARIZONA	2017	second_quarter	INS	H.R. 1628 - American Health Care Act of 2017 and Senate Amendment - Better Care Reconciliation Act. Cost Sharing Reduction.	HOUSE OF REPRESENTATIVES,SENATE	40000		0	2017-07-17T11:57:07.057000-04:00
1989064	CAPSTONE NATIONAL PARTNERS a3bfda83-6111-4c05-8c37-75977cc5e1a4	Q2	CAPSTONE NATIONAL PARTNERS	8214	CUNA MUTUAL GROUP	2017	second_quarter	INS	Oversight of house financial services committee and Senate banking committee regarding legislative concerns of cooperatives	HOUSE OF REPRESENTATIVES,SENATE	10000		0	2017-07-17T12:29:25.777000-04:00
1989154	CAVAROCCHI RUSCIO DENNIS ASSOCIATES, L.L.C. 99461f34-0edf-49ff-bb35-8bb4cbbd0703	Q2	CAVAROCCHI RUSCIO DENNIS ASSOCIATES, L.L.C.	8511	AMERICAN SOCIETY OF HEMATOLOGY	2017	second_quarter	INS	HR 1628, American Health Care Act & other efforts to Repeal & Replace the Affordable Care Act.	Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Food & Drug Administration (FDA),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE	30000		0	2017-07-17T13:07:24.303000-04:00
1989158	CAVAROCCHI RUSCIO DENNIS ASSOCIATES, L.L.C. 81917821-edd5-45e4-9813-9b04e81e8a8a	Q2	CAVAROCCHI RUSCIO DENNIS ASSOCIATES, L.L.C.	8511	THE HEMOPHILIA ALLIANCE	2017	second_quarter	INS	Implementation of the Affordable Care Act HR 1628 American Health Care Act and other efforts to repeal and replace ACA.	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,SENATE	30000		0	2017-07-17T13:09:25.990000-04:00
1989165	CAVAROCCHI RUSCIO DENNIS ASSOCIATES, L.L.C. f330ee14-120f-4f0c-80dd-907a2abf7929	Q2	CAVAROCCHI RUSCIO DENNIS ASSOCIATES, L.L.C.	8511	NATIONAL HEMOPHILIA FOUNDATION	2017	second_quarter	INS	Implementation of the Affordable Care Act; HR 1628 American Health Care Act and other legislation to Repeal & Replace Affordable Care Act.	Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE	50000		0	2017-07-17T13:10:29.507000-04:00
1989170	CAVAROCCHI RUSCIO DENNIS ASSOCIATES, L.L.C. 608b3b91-7921-416a-bfad-dc09258a4834	Q2	CAVAROCCHI RUSCIO DENNIS ASSOCIATES, L.L.C.	8511	NATIONAL ASSOCIATION OF EPILEPSY CENTERS	2017	second_quarter	INS	Implementation of the Affordable Care Act	Agency for Healthcare Research & Quality (AHRQ),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE	10000		0	2017-07-17T13:11:30.647000-04:00
1989340	ERIS GROUP 4852e36c-e465-4e29-a2ca-4f4e29b9631d	Q2	ERIS GROUP	82055	PROPERTY CASUALTY INSURERS ASSOCIATION OF AMERICA	2017	second_quarter	INS	Issues related to the reauthorization and implementation of the National Flood Insurance Program. H.R.1422, Flood Insurance Market Parity and Modernization Act, all provisions. H.R.1558, Repeatedly Flooded Communities Preparation Act, all provisions. H.R.2246, Taxpayer Exposure Mitigation Act of 2017, all provisions. H.R.2565, To require the use of replacement cost value in determining the premium rates for flood insurance coverage under the National Flood Insurance Act, all provisions. H.R.2868, National Flood Insurance Program Policyholder Protection Act of 2017, all provisions. H.R.2874, 21st Century Flood Reform Act, all provisions. H.R.2875, National Flood Insurance Program Administrative Reform Act of 2017, all provisions. S.563, Flood Insurance Market Parity and Modernization Act, all provisions. S.1313, Flood Insurance Affordability and Sustainability Act of 2017, all provisions. S.1368, Sustainable, Affordable, Fair, and Efficient (SAFE) National Flood Insurance Program Reauthorization Act of 2017, all provisions.	HOUSE OF REPRESENTATIVES,SENATE	22500		0	2017-07-17T14:07:16.717000-04:00
1989453	ERIS GROUP a42fc988-be20-4f41-b054-c9235c3596fa	Q2	ERIS GROUP	82055	U.S. MORTGAGE INSURERS	2017	second_quarter	INS	Issues regarding mortgage insurance and housing finance.	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2017-07-17T14:30:43.187000-04:00
1989735	CASSIDY & ASSOCIATES, INC. ee55853c-9814-4b94-b43b-bcd0aa24f910	Q2	CASSIDY & ASSOCIATES, INC.	8453	SOCIETY OF ACTUARIES	2017	second_quarter	INS	General legislative issues related to actuarial profession	HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	20000		0	2017-07-17T15:09:42.113000-04:00
1989834	RASKY PARTNERS, INC. b843f077-cb69-490d-899a-e61f9686c9cf	Q2	RASKY PARTNERS, INC.	297410	ASSOCIATION FOR ADVANCED LIFE UNDERWRITING	2017	second_quarter	INS	Life Insurance Issues	Treasury, Dept of	40000		0	2017-07-17T15:26:42.053000-04:00
1989967	NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE a92cea2a-21be-471c-bc80-72a8a9abd472	Q2	NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE	48975	NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE	2017	second_quarter	INS	Support the Administration working closely with insurers and state insurance officials to ensure maximum participation in the ACA, and also issuing a regulation that empowers the Administration to negotiate with insurance companies.	Agriculture, Dept of (USDA),Bureau of Alcohol Tobacco Firearms & Explosives,Centers For Medicare and Medicaid Services (CMS),Consumer Financial Protection Bureau (CFPB),Education, Dept of,Election Assistance Commission (EAC),Environmental Protection Agency (EPA),Equal Employment Opportunity Commission (EEOC),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Motor Carrier Safety Administration,Federal Reserve System,Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Park Service (NPS),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Securities & Exchange Commission (SEC),SENATE,Social Security Administration (SSA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,White House Office		70000	0	2017-07-17T15:55:14.230000-04:00
1990022	AMERICAN FAMILY MUTUAL INSURANCE COMPANY, S.I. 7d1cacfe-ec4a-4d71-a077-81764a918284	Q2	AMERICAN FAMILY MUTUAL INSURANCE COMPANY, S.I.	293552	AMERICAN FAMILY MUTUAL INSURANCE COMPANY, S.I.	2017	second_quarter	INS	S 1360 - The International Insurance Capital Standards Accountability Act - support legislation to promote the state-based system of insurance regulation and enhance Congressional review of international insurance agreements	HOUSE OF REPRESENTATIVES,SENATE		120000	0	2017-07-17T16:04:42.183000-04:00
1990039	O'ROURKE & NAPPI, LLP 43f9d2f1-5578-430e-830d-222b80722690	Q2	O'ROURKE & NAPPI, LLP	401103400	THE TRAVELERS COMPANIES INC. AND SUBSIDIARIES	2017	second_quarter	INS	Issues relating to flood insurance.	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2017-07-17T16:10:00.827000-04:00
1990057	KD ADVOCACY AND CONSULTING, LLC babba992-67b1-4ece-8ca5-45588e0a1f54	Q2	KD ADVOCACY AND CONSULTING, LLC	401103971	REACHING MILESTONES	2017	second_quarter	INS	Advocating to improve coverage and access to autism treatment services for TRICARE beneficiaries.	Defense, Dept of (DOD)			0	2017-07-17T16:15:14.920000-04:00
1990096	CALIFORNIA ASSOCIATION OF REALTORS e400d858-ddaa-4d37-b9ef-4ef7f2ee1db4	Q2	CALIFORNIA ASSOCIATION OF REALTORS	7691	CALIFORNIA ASSOCIATION OF REALTORS	2017	second_quarter	INS	H.R. 1422; Flood Insurance Market Parity and Modernization Act; the bill removes barriers for more private company participation in the flood insurance market. H.R. 1558; Repeatedly Flooded Communities Preparation Act; The bill would require NFIP communities to develop plans and make progress toward mitigating repetitive loss properties. H.R. 2246; Taxpayer Exposure Mitigation Act; The bill sets standards for communities to develop flood maps and use risk transfer tools. H.R. 2565; To require the use of replacement cost value in determining the premium rates for flood insurance coverage under the National Flood Insurance Act, and for other purposes; the bill would allow for the use of replacement cost in determining premium rates for the NFIP. H.R. 2868; National Flood Insurance Program Policyholder Protection Act; the bill establishes a cap on NFIP rates. H.R. 2874; 21st Century Flood Reform Act; the bill would reauthorize the NFIP. H.R. 2875; National Flood Insurance Program Administrative Reform Act; the bill would allow homeowners access to mitigate properties before they flood.	Consumer Financial Protection Bureau (CFPB),Federal Housing Finance Agency (FHFA),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE,Veterans Affairs, Dept of (VA)		25130	0	2017-07-17T16:23:38.937000-04:00
1990174	THE SMITH-FREE GROUP, LLC 5404cc02-b944-42ff-9749-dc18d21478df	Q2	THE SMITH-FREE GROUP, LLC	35800	BANK POLICY INSTITUTE	2017	second_quarter	INS	Discussions related to reform of the national flood insurance program	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2017-07-17T16:39:35.077000-04:00
1990313	KOUNTOUPES DENHAM CARR & REID, LLC 15a645f3-c08a-475e-af69-0779662f2207	Q2	KOUNTOUPES DENHAM CARR & REID, LLC	320918	UNUM GROUP	2017	second_quarter	INS	Proposal to enhance income protection for workers.	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2017-07-17T17:46:37.940000-04:00
1990411	THINKP3, LLC a79c7d53-d2b2-4a41-b30c-ce20fb0f963f	Q2	THINKP3, LLC	401103858	NATIONAL ASSOCIATION OF SURETY BOND PRODUCERS	2017	second_quarter	INS	Generally discussed the critical importance of mandatory surety bonding requirements, such as those of the Miller Act of 1935 (40 U.S.C. Section 3131, August 24, 1935) to protect federal taxpayer funds and to provide payment remedies for firms, in particular small businesses, supplying labor and materials on direct federal construction contracts and on construction contracts in part financed with federal funds.	HOUSE OF REPRESENTATIVES,SENATE	10000		0	2017-07-17T19:31:37.077000-04:00
1990516	THORN RUN PARTNERS a858a3ac-9660-4ff2-b964-7fe2a9dd27fd	Q2	THORN RUN PARTNERS	400534596	DENVER HEALTH & HOSPITAL AUTHORITY	2017	second_quarter	INS	H.R.1628, American Health Care Act of 2017/Better Care Reconciliation Act of 2017. Issues related to managed care. Exchange implementation and insurance market reforms.	Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE	30000		0	2017-07-17T23:50:19.030000-04:00
1990539	KING & SPALDING LLP 991310ab-250c-4b4b-9918-0256d3c7ef0b	Q2	KING & SPALDING LLP	21632	ASSOCIATION OF CLAIMS PROFESSIONALS (FORMERLY AAICP)	2017	second_quarter	INS	Support of Claims Licensing Advancement for Interstate Matters (CLAIM) Act	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2017-07-18T07:04:31.390000-04:00
1990560	KING & SPALDING LLP 7a259a7f-0ce2-4e03-8ce2-2697e91d55ac	Q2	KING & SPALDING LLP	21632	SEDGWICK, INC.	2017	second_quarter	INS	-- Federal regulation related to the insurance adjuster industry -- Claims Licensing Advancement for Interstate Matters (CLAIM) Act	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2017-07-18T07:32:01.517000-04:00
1990620	THORN RUN PARTNERS 44d17193-3562-4ea8-ae21-85a515f950cc	Q2	THORN RUN PARTNERS	400534596	COALITION ORGANIZED FOR THE FUTURE OF INSURANCE REGULATION (COFIR)	2017	second_quarter	INS	Financial Services Regulatory Reform; Federal Insurance Regulation; Systemic Risk in Financial Services; International discussions on appropriate capital standards for insurers.	HOUSE OF REPRESENTATIVES,SENATE	30000		0	2017-07-18T09:00:59.827000-04:00
1990626	TRUIST FINANCIAL CORPORATION (FORMERLY KNOWN AS BB&T) 4e5450c0-f76b-4ab2-b230-7bf5b6160db9	Q2	TRUIST FINANCIAL CORPORATION (FORMERLY KNOWN AS BB&T)	74534	TRUIST FINANCIAL CORPORATION (FORMERLY KNOWN AS BB&T)	2017	second_quarter	INS	Discussions related to the flood insurance program.	HOUSE OF REPRESENTATIVES,SENATE		160987	0	2017-07-18T09:08:07.560000-04:00
1990639	COREWELL HEALTH c05ed7b0-fb42-47cc-935f-be15dc10ca97	Q2	COREWELL HEALTH	298455	COREWELL HEALTH	2017	second_quarter	INS	H.R.1628 - American Health Care Act of 2017; Discussions regarding potential new health law. H.R.1628 - Better Care Reconciliation Act of 2017; Discussions regarding potential new health law.	HOUSE OF REPRESENTATIVES,SENATE		50000	0	2017-07-18T09:11:14.497000-04:00
1990645	THORN RUN PARTNERS b77e174f-de54-4c90-bf4a-5577661c2f92	Q2	THORN RUN PARTNERS	400534596	JACKSON NATIONAL LIFE INSURANCE COMPANY	2017	second_quarter	INS	Financial services regulatory reform legislation regarding provisions affecting the regulation of insurance products and companies. International discussions on appropriate capital standards for insurers. Systemic Risk in Financial Services.	HOUSE OF REPRESENTATIVES,SENATE	60000		0	2017-07-18T09:13:17.453000-04:00
1990685	THORN RUN PARTNERS 271d130b-7c88-4244-84b4-4c79a684c1e1	Q2	THORN RUN PARTNERS	400534596	LIBERTY MUTUAL INSURANCE	2017	second_quarter	INS	Financial services regulatory reform legislation regarding provisions affecting the regulation of insurance products and companies. International discussions on appropriate capital standards for insurers. Systemic Risk in Financial Services.	HOUSE OF REPRESENTATIVES,SENATE	50000		0	2017-07-18T09:31:41.953000-04:00
1990707	AZOA SERVICES CORP(ALLIANZ OF AMERICA) FORMERLY AZOA SERIVCES CORP/FIREMAN'S FUND(ALLIANZ OF AMERICA adaad4e0-3c0a-4830-a394-d0509e711f25	Q2	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	2017	second_quarter	INS	Financial Services Regulatory Reform: Lobby for favorable implementation of the Dodd-Frank Wall Street Reform and consumer Protection Act of 2010 regarding insurers, including the possible designation of insurers and asset management companies as systemically important by the Financial Stability Oversight council. Also lobby for robust and effective Federal Insurance Office. Also with key trade associations, worked on regulatory strategy for the implementation of Dodd-Frank. Department of Labor Fiduciary Duty Rulemaking: monitor and lobby against Department of Labor rulemaking that would expand the definition of "fiduciary" under ERISA. Lobby in support of legislation blocking or supplanting the Rule.	Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,Risk Management Agency,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of		530000	0	2017-07-18T09:37:58.407000-04:00
1990846	NATIONAL COUNCIL ON COMPENSATION INSURANCE, INC. 3b418671-ea11-4c52-b98f-ca8e39b04790	Q2	NATIONAL COUNCIL ON COMPENSATION INSURANCE, INC.	67455	NATIONAL COUNCIL ON COMPENSATION INSURANCE, INC.	2017	second_quarter	INS	Workers Compensation Insurance, NCCI	Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE			0	2017-07-18T10:22:35.820000-04:00
1990887	BOSE PUBLIC AFFAIRS GROUP beb35c47-d32c-4f41-ba67-1c31a426c2ca	Q2	BOSE PUBLIC AFFAIRS GROUP	297294	EXPRESS SCRIPTS HOLDING COMPANY	2017	second_quarter	INS	Issues related to reimbursement	Centers For Medicare and Medicaid Services (CMS)	80000		0	2017-07-18T10:30:03.587000-04:00
1990927	MUTUAL OF OMAHA e9fb3f9d-e5ff-4812-b770-f3c81fe2b411	Q2	MUTUAL OF OMAHA	26284	MUTUAL OF OMAHA	2017	second_quarter	INS	Medicare Reform - changes to benefit structure HR 3463/S 3244 -dental rules sold on or off exchanges HR 1628 - ACA Repeal and replace S 1719 - RAISE Family Caregivers Act - long term care insurance Long Term Care premiums - Congressional oversight Long Term Care Tax Incentives - expansion of Long Term Care HIX - assessment applied to products sold off ACA exchanges HR 5143 Transparent Insurance Standards Act - capital requirements for insurers 1210-AB39 claims processing for disability benefits Tri-Agency Rule - Hospital indemnity produces HR 10 - Financial CHOICE Act of 2017 - changes to Dodd-Frank Act	HOUSE OF REPRESENTATIVES,SENATE		95000	0	2017-07-18T10:40:26.697000-04:00
1991057	JAMES W SEGEL LLC d090447a-7f44-41bc-ba62-8041e67423e3	Q2	JAMES W SEGEL LLC	401103350	LIBERTY MUTUAL INSURANCE	2017	second_quarter	INS	Dodd-Frank reform; International regulations.	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2017-07-18T11:01:42.620000-04:00
1991146	THORN RUN PARTNERS 3cdc7ce9-481b-4d69-bd23-b2ec9daa621a	Q2	THORN RUN PARTNERS	400534596	CAMBIA HEALTH SOLUTIONS, INC.	2017	second_quarter	INS	Issues relating to insurance market regulation.		20000		0	2017-07-18T11:24:54.633000-04:00
1991260	TRUCK RENTING AND LEASING ASSOCIATION 76e516d7-f855-490a-95da-3c6dba7f4ae6	Q2	TRUCK RENTING AND LEASING ASSOCIATION	38552	TRUCK RENTING AND LEASING ASSOCIATION	2017	second_quarter	INS	Discuss with federal officials the proposed rulemaking to increase insurance premiums on commercial trucks as well as broaden the requirements to include private carriers. Lobby to exclude rented and leased vehicles given the fact that their operators of these vehicles would already be required to carry these new insurance premiums.	Federal Motor Carrier Safety Administration,HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Treasury, Dept of			0	2017-07-18T11:52:30.203000-04:00
1991285	NATIONAL ASSOCIATION OF PROFESSIONAL INSURANCE AGENTS e1ed7040-81e3-4979-9ba7-c5b404c3e582	Q2	NATIONAL ASSOCIATION OF PROFESSIONAL INSURANCE AGENTS	27024	NATIONAL ASSOCIATION OF PROFESSIONAL INSURANCE AGENTS	2017	second_quarter	INS	Regulation of insurance (general); general issues related to the Federal Insurance Office; general issues related to the Federal Advisory Committee on Insurance (FACI); general issues related to the Financial Stability Oversight Council (FSOC); issues related to the implementation of the National Association of Registered Agents and Brokers; implementation of the Biggert-Waters Flood Insurance Reform Act of 2012 (implementation of the Homeowner Flood Insurance Affordability Act (Public Law No: 113-89); issues related to the National Flood Insurance Program;H.R. 1422/S. 563, the Flood Insurance Market Parity and Modernization Act; H.R. 10,the Financial CHOICE Act; S. 1360, the Transparent Insurance Standards Act; Bilateral Agreement between the European Union and the United States of America On Prudential Measures Regarding Insurance and Reinsurance;H.R. 2868, the National Flood Insurance Program Policyholder Protection Act of 2017;H.R. 2874, the 21st Century Flood Reform Act;H.R. 2875, the National Flood Insurance Program Administrative Reform Act of 2017;H.R. 1558, the Repeatedly Flooded Communities Preparation Act;H.R. 2565, a bill to require the use of replacement cost value in determining the premium rates for flood insurance coverage under the National Flood Insurance Act, and for other purposes;H.R. 2246, the Taxpayer Exposure Mitigation Act of 2017;S. 1313, the Flood Insurance Affordability & Sustainability Act of 2017; S. 1368, The Sustainable, Affordable, Fair and Efficient National Flood Insurance Program Reauthorization Act of 2017	Centers For Medicare and Medicaid Services (CMS),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Risk Management Agency,SENATE,Treasury, Dept of		127830	0	2017-07-18T11:55:42.843000-04:00
1991387	NATIONAL ASSOCIATION OF DENTAL PLANS 1faef685-4538-4c32-a909-ff3ecb5702c5	Q2	NATIONAL ASSOCIATION OF DENTAL PLANS	400462300	NATIONAL ASSOCIATION OF DENTAL PLANS	2017	second_quarter	INS	HR 1606 Dental and Optometric Care Access Act; H.R.1628 - American Health Care Act of 2017 as they relate to the business of dental benefits.	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE		140000	0	2017-07-18T12:15:50.347000-04:00
1991410	NATIONAL ASSOCIATION OF DENTAL PLANS b1daef9f-2a48-4b0c-b98f-f83723e9a4bf	2A	NATIONAL ASSOCIATION OF DENTAL PLANS	400462300	NATIONAL ASSOCIATION OF DENTAL PLANS	2017	second_quarter	INS	HR 1606 Dental and Optometric Care Access Act; H.R.1628 - American Health Care Act of 2017 as they relate to the business of dental benefits.	Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE		150000	0	2017-07-18T12:27:11.643000-04:00
1991737	AMERICAN ASSOCIATION OF ORTHOPAEDIC SURGEONS eb065a38-58d3-4a9f-9111-656d9a5ab024	Q2	AMERICAN ASSOCIATION OF ORTHOPAEDIC SURGEONS	52105	AMERICAN ASSOCIATION OF ORTHOPAEDIC SURGEONS	2017	second_quarter	INS	HR1704-Access Act of 2017 HR302-Sports Medicine Licensure Clarity Act of 2017 HR 1215 Protecting Access to Care Act	HOUSE OF REPRESENTATIVES,SENATE		461408	0	2017-07-18T13:40:24.760000-04:00
1991775	MERCURY PUBLIC AFFAIRS, LLC 20036f00-612a-4b86-9f51-d4e9771b3617	Q2	MERCURY PUBLIC AFFAIRS, LLC	70175	BLUE CROSS BLUE SHIELD OF SOUTH CAROLINA	2017	second_quarter	INS	Monitored legislation to repeal and replace the ACA	HOUSE OF REPRESENTATIVES,Office of Administration,SENATE	20000		0	2017-07-18T13:42:46.277000-04:00
1991810	STRATEGIES 360 d4fbdee2-dec3-416e-a938-14465a6b3057	Q2	STRATEGIES 360	79175	CITY OF BOISE	2017	second_quarter	INS	National Flood Insurance Programs; Lower Boise Watershed Flood Insurance Study; mapping and modeling issues.	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2017-07-18T13:47:06.933000-04:00
1992240	REINSURANCE ASSN OF AMERICA 17086ffd-d860-43b8-90ef-a3cbb5499dad	Q2	REINSURANCE ASSN OF AMERICA	33044	REINSURANCE ASSN OF AMERICA	2017	second_quarter	INS	Covered Agreements under Dodd-Frank Reform NFIP Reauthorization and Reform - H.R. 1422 - "Flood Insurance Market Parity and Modernization Act" H.R. 1558 - "Repeatedly Flooded Communities Preparation Act" H.R. 2246 - "Taxpayer Exposure Mitigation Act of 2017" H.R. 2565 - a bill to require the use of replacement cost value in determining the premium rates for flood insurance coverage under the National Flood Insurance Act and for other purposes. H.R. 2868 - "National Flood Insurance Program Policyholder Protection Act of 2017" H.R. 2875 - "National Flood Insurance Program Administrative Reform Act of 2017" H.R. 2874 - "21st Century Flood Reform Act" S. 563 - "Flood Insurance Market Parity and Modernization Act" S. 1313 - "Flood Insurance Affordability and Sustainability Act of 2017" S. 1368 - "Sustainable, Affordable, Fair, and Efficient (SAFE) National Flood Insurance Program Reauthorization Act of 2017" S. 1445 - "Repeatedly Flooded Communities Preparation Act" Building code legislation Dodd-Frank Act reform Tax reform, corporate and international H.R. 10, the Financial CHOICE Act S. 1360, the International Insurance Capital Standards Accountability Act of 2017 Monitor implementation of (P.L. 114-1), the Terrorism Risk Insurance Program Reauthorization Act of 2015 H.R. 372, the Competitive Health Insurance Reform Act of 2017 Draft legislation "International Insurance Standards Act of 2017" by Reps. Sean Duffy and Denny Heck Cyber Security and cyber insurance issues Crop insurance issues Housing reform Infrastructure reform Export-Import bank reform Sanctions	Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Office of the Vice President of the United States,SENATE,Treasury, Dept of		390000	0	2017-07-18T14:50:11.940000-04:00
1992254	AMERICAN ACADEMY OF PEDIATRICS 3b37bd1c-a31c-472b-ad10-b286afe73a79	Q2	AMERICAN ACADEMY OF PEDIATRICS	1397	AMERICAN ACADEMY OF PEDIATRICS	2017	second_quarter	INS	Adolescent Confidentiality TRICARE Medical Foods CHIP BCRA American Health Care Act	Administration for Children & Families (ACF),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Consumer Product Safety Commission (CPSC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Agency for International Development (USAID),White House Office	90271		0	2017-07-18T14:51:15.130000-04:00
1992292	AMERICAN ACADEMY OF PEDIATRICS 5142711e-4231-4e00-a553-0e2ffeeb7484	2A	AMERICAN ACADEMY OF PEDIATRICS	1397	AMERICAN ACADEMY OF PEDIATRICS	2017	second_quarter	INS	Adolescent Confidentiality TRICARE Medical Foods CHIP BCRA American Health Care Act	Administration for Children & Families (ACF),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Consumer Product Safety Commission (CPSC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Agency for International Development (USAID),White House Office	90271		0	2017-07-18T14:54:34.147000-04:00
1992301	CGCN GROUP, LLC 0684fde5-c046-4f90-a021-2539e70378df	Q2	CGCN GROUP, LLC	76992	ALLY FINANCIAL INC.	2017	second_quarter	INS	Proposals regarding insurance and consumer financial protection.	HOUSE OF REPRESENTATIVES,SENATE	24000		0	2017-07-18T14:54:40.003000-04:00
1992339	AMERICAN ACADEMY OF PEDIATRICS 9af3226d-58c9-4a53-aac6-ddca5787628c	2A	AMERICAN ACADEMY OF PEDIATRICS	1397	AMERICAN ACADEMY OF PEDIATRICS	2017	second_quarter	INS	Adolescent Confidentiality TRICARE Medical Foods CHIP BCRA American Health Care Act	Administration for Children & Families (ACF),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Consumer Product Safety Commission (CPSC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Agency for International Development (USAID),White House Office			0	2017-07-18T14:58:02.350000-04:00
1992394	THE MCGRATH GROUP LLLC 1ee4ca4b-8add-4d85-8350-c7e5859f54d3	Q2	THE MCGRATH GROUP LLLC	401103940	ALLSUP INC,	2017	second_quarter	INS	Social Security Disability Insurance.	HOUSE OF REPRESENTATIVES,SENATE	40000		0	2017-07-18T15:05:45.163000-04:00
1992568	AMERICAN INSURANCE ASSN 998147d6-4fb6-42a9-867e-61151c20cb29	Q2	AMERICAN INSURANCE ASSN	2662	AMERICAN INSURANCE ASSN	2017	second_quarter	INS	H.R. 720 - Lawsuit Abuse Reduction Act of 2017 (entire) H. R. 372 - Competitive Health Insurance Reform Act H.R. 985 - Fairness in Class Action Litigation and Furthering Asbestos Claim Transparency Act 2017. To amend title 11 of the United States Code to require the public disclosure by trusts established under section 524(g) of such title, of quarterly reports that contain detailed information regarding the receipts and dispositions of the claims for injures based on exposure to asbestos; and for other purposes (entire) H.R. 1422/S.563 - Flood Market Parity and Modernization Act - A bill to amend the flood Disaster Protection Act of 1973 to require certain buildings and personal property to be covered by flood insurance and for other purposes (entire bill) H.R. 1423 - The National Flood Insurance Programs and Reauthroization Act of 2017 (entire) H.R. 1558 - The Repeatedly Flooded Communities preparation Act (entire) H.R. 10 - Financial CHOICE Act - Titles I, VI, VII, X, and XI H.R. 1558, the Repeatedly Flooded Communities Preparation Act - H.R. 1558, introduced by Representative Royce and Representative Blumenauer, amends the National Flood Insurance Act of 1968 to ensure community accountability for areas repetitively damaged by floods, and for other purposes. (entire) H.R. 2246, the Taxpayer Exposure Mitigation Act of 2017 - H.R. 2246, introduced by Representative Luetkemeyer, repeals the mandatory flood insurance coverage requirement for commercial properties located in flood hazard areas and to provide for greater transfer of risk under the National Flood Insurance Program to private capital and reinsurance markets, and for other purposes. (entire) H.R. 2565, a bill to require the use of replacement cost value in determining the premium rates for flood insurance coverage under the National Flood Insurance Act, and for other purposes. - H.R. 2565, introduced by Representative Luetkemeyer, would require FEMA to conduct a study on the feasibility of incorporating the actual replacement cost value f…	Federal Emergency Management Agency (FEMA),Federal Reserve System,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Treasury, Dept of		290000	0	2017-07-18T15:21:28.477000-04:00
1992828	PRINCIPAL FINANCIAL GROUP b8f17061-ff56-4caf-9b9d-81e7a85bd465	Q2	PRINCIPAL FINANCIAL GROUP	32178	PRINCIPAL FINANCIAL GROUP	2017	second_quarter	INS	H.R. 372: Competitive Health Insurance Reform Act of 2017 -(Sec. 2) This bill amends the McCarran-Ferguson Act to declare that nothing in that Act modifies, impairs, or supersedes the operation of antitrust laws with respect to the business of health insurance, including the business of dental insurance. This declaration does not apply to a contract, combination, or conspiracy to: (1) collect, compile, or disseminate historical loss data; (2) determine a loss development factor for historical loss data; (3) perform actuarial services if the collaboration does not involve a restraint of trade; or (4) develop or disseminate a standard insurance policy form if adherence to the form is not required. H.R.3110/S.1463: Financial Stability Oversight Council Insurance Member Continuity Act - The bill would allow the Financial Stability and Oversight Council (FSOC) to continue to benefit from the important insight and contributions of the independent member with insurance expertise if his/her replacement has not been confirmed.	HOUSE OF REPRESENTATIVES,SENATE		395000	0	2017-07-18T15:55:41.887000-04:00
1992934	HOLLAND & KNIGHT LLP 2dde4325-c1b3-4c39-91f2-5567ab95b07a	Q2	HOLLAND & KNIGHT LLP	18466	MARSH & MCLENNAN AGENCY, LLC F/K/A THOMAS RUTHERFOORD, INC.	2017	second_quarter	INS	General issues relating to Defense Base Act Insurance, its acquisition by the government and administration.	HOUSE OF REPRESENTATIVES,SENATE	20000		0	2017-07-18T16:10:49.327000-04:00
1993025	PORTERFIELD, FETTIG & SEARS, LLC 551460fd-112e-478d-b9a6-bb334a174211	Q2	PORTERFIELD, FETTIG & SEARS, LLC	305054	PRUDENTIAL FINANCIAL	2017	second_quarter	INS	Issues relating to Dodd-Frank implementation and FIO, OFR, FSOC, FSB including issues relating to capital standards, non-bank SIFI designation, insurance regulation, and oversight.	Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE	40000		0	2017-07-18T16:19:37.687000-04:00
1993127	CHAMBERS, CONLON & HARTWELL, LLC 8ce7d78e-2207-4a5e-8860-03a8dc9b0f00	Q2	CHAMBERS, CONLON & HARTWELL, LLC	8830	CITY AND BOROUGH OF JUNEAU	2017	second_quarter	INS	Post-enactment implementation issues in P.L. 113-76/Senate Report 113-77- Provision directing FEMA to study the feasibility of waiver authority for floodplain management requirements within V-zone areas as a condition of participation in the National Flood Insurance Program.	HOUSE OF REPRESENTATIVES,SENATE,U.S. Coast Guard (USCG)	20000		0	2017-07-18T16:33:42-04:00
1993165	UNUM GROUP 0295de5d-3071-45b0-92e0-f6a4184761c9	Q2	UNUM GROUP	39600	UNUM GROUP	2017	second_quarter	INS	Antitrust: -Issues related to the McCarran Ferguson antitrust exemption for insurers: impact to employer-provided benefits, and supplemental and voluntary benefits insurance industry Dental: - Issues related to the provision and coverage of dental services, including non-covered services -Matters affecting the affordability of dental care - The application of antitrust laws with respect to the business of dental insurance ERISA: -Issues related to regulation of employee benefits under the Employee Retirement Income Security Act and legislation impacting ERISA plans -Clarification of permissibility of default enrollment arrangements for group income protection insurance under ERISA and/or the Fair Labor Standards Act Federal Debt Limit: -Debt Limit Increase: impact on employer-sponsored financial protection benefits industry Financial Services Regulation: -Dodd-Frank Wall Street Reform and Consumer Protection Act implementation: impact on employer-sponsored financial protection benefits industry -Consumer Financial Protection Bureau Interim Final Rule of Records and Information: provisions relating to employer-provided benefits, and supplemental and voluntary benefits insurance industry -Criteria and process for designating nonbank financial companies: provisions relating to employer-provided benefits, and supplemental and voluntary benefits insurance industry Health Care: -Implementation of the Patient Protection and Affordable Care Act, including HHS FAQ regarding fixed indemnity products and other provisions relating to employer-provided benefits, and supplemental and voluntary benefits insurance industry -Loss ratios: issues related to employer-provided benefits, and supplemental and voluntary benefits insurance industry -The Health Information Technology for Economic and Clinical Health Act (HITECH) Act: provisions relating to employer-provided benefits, and supplemental and voluntary benefits insurance industry -Issues related to wellness programs Labor: -Labor issues impacting large employers, includi…	Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,White House Office		150000	0	2017-07-18T16:38:02.347000-04:00
1993177	PORTERFIELD, FETTIG & SEARS, LLC 9b748786-0526-4806-8fe4-11885f7747e4	Q2	PORTERFIELD, FETTIG & SEARS, LLC	305054	STATE FARM INSURANCE COMPANIES	2017	second_quarter	INS	Issues related to the implementation and modifications to the Dodd Frank Act; implementation of the Insurance Capital Standards Clarification Act of 2014; provisions related to capital and accounting standards regulation for insurance based savings and loan holding companies; monitoring international regulatory developments governing insurance and its potential impact and consumer lending issues.	Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE	70000		0	2017-07-18T16:39:07.643000-04:00
1993215	ARNOLD & PORTER KAYE SCHOLER LLP 4ab3ae94-095c-43d9-bb7b-0d62d4bcdaa3	Q2	ARNOLD & PORTER KAYE SCHOLER LLP	4301	AMERICAN ASSOCIATION OF ORTHODONTISTS	2017	second_quarter	INS	RAISE Act (H.R. 1204). ACA regulations. Issues related to McCarran-Ferguson Act repeal. Small business insurance regulations.	HOUSE OF REPRESENTATIVES,SENATE	50000		0	2017-07-18T16:41:24.143000-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

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);