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

163 rows where filing_period = "year_end", filing_year = 2003 and issue_code = "PHA" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filing_type, specific_issues, income_amount, received_date (date)

issue_code 1

  • PHA · 163 ✖

filing_year 1

  • 2003 · 163 ✖

filing_period 1

  • year_end · 163 ✖
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
224461 TWENTY-FIRST CENTURY GROUP, INC. 84a1271d-86ed-4915-8269-802517adc9a1 YY TWENTY-FIRST CENTURY GROUP, INC. 38687 SCHERING-PLOUGH 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2003-04-01T00:00:00-05:00
224524 CEPHALON, INC. 9d80bd91-008d-4c78-bc98-06663a19c87d YY CEPHALON, INC. 8761 CEPHALON INC 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE   100000 0 0 2003-04-01T00:00:00-05:00
244086 UNIVERSITY OF IOWA 9c997a74-1b43-4ef0-8d2f-a4ea2b9ba20f YY UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2003 year_end PHA   Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Centers For Disease Control & Prevention (CDC),Education, Dept of,Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),State, Dept of (DOS)   80000 0 0 2003-08-18T00:00:00-04:00
253732 D. LYNN JOHNSON a72a19d5-6f7f-40aa-829c-7ff222eb44dc YY D. LYNN JOHNSON 86653 KING PHARMACEUTICALS INC 2003 year_end PHA Asked a Senate office to contact the FDA to determine why the agency would not agree to King Pharmaceuticals' promoting the use of AtroPen (approved by the FDA) with physicians and the public by using FDA approved informational materials. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2004-01-06T00:00:00-05:00
253736 D. LYNN JOHNSON 70fd7cd6-5489-44ab-90e1-bd6e5d9771e1 YY D. LYNN JOHNSON 86653 KING PHARMACEUTICALS INC 2003 year_end PHA Asked a Senate office to contact the FDA to determine why the agency would not agree to King Pharmaceuticals' promoting the use of AtroPen (approved by the FDA) with physicians and the public by using FDA approved informational materials. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2004-01-06T00:00:00-05:00
253998 EMD SERONO, INC. 6e0f89b7-a40f-4e46-991e-6cb43a448702 YY EMD SERONO, INC. 48736 EMD SERONO INC 2003 year_end PHA Amendments to Hatch-Waxman exclusivity policies Food & Drug Administration appropriations Reimportation of prescription drugs from foreign sources Centers For Medicare and Medicaid Services (CMS),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE   35000 0 0 2004-01-12T00:00:00-05:00
254452 ALBERTINE ENTERPRISES, INC. edfcfa59-3d39-4df3-b113-224f61059d3d YTY ALBERTINE ENTERPRISES, INC. 795 NATL ASSN OF RV PARKS & CAMPGROUNDS 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2004-01-20T00:00:00-05:00
254802 MARSHALL BRACHMAN 8143b957-4cea-453e-a5f5-6dff5dad4fd8 YY MARSHALL BRACHMAN 6848 PHARMAFAB 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2004-01-26T00:00:00-05:00
255052 MAYBERRY & ASSOCIATES, LLC 151edbbf-4af1-4ef4-bfd7-24b7f1dbcbed YY MAYBERRY & ASSOCIATES, LLC 51968 PHARMACEUTICAL PRINTED LITERATURE ASSOCIATION 2003 year_end PHA   Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2004-01-29T00:00:00-05:00
255187 MAYBERRY & ASSOCIATES, LLC 3c4a6a2a-2c69-4a95-acf0-8ef0e7d381f6 YY MAYBERRY & ASSOCIATES, LLC 51968 HEALTHCARE COMPLIANCE PACKAGING COUNCIL 2003 year_end PHA   Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2004-01-29T00:00:00-05:00
255454 RETIRESAFE 155b04d9-fcdc-4dbc-a1f6-b0353639559a YY RETIRESAFE 11025 RETIRESAFE 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE   260000 0 0 2004-01-30T00:00:00-05:00
255536 UNIVERSITY OF ILLINOIS e2efe211-6af5-41be-92db-68cd26203856 YY UNIVERSITY OF ILLINOIS 39427 UNIVERSITY OF ILLINOIS 2003 year_end PHA   Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Federal Aviation Administration (FAA),Federal Highway Administration (FHA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Endowment for the Arts,Natl Foundation on the Arts & Humanities,Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Technology Administration,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID),U.S. International Development Cooperation Agency,Veterans Affairs, Dept of (VA)   40000 0 0 2004-01-30T00:00:00-05:00
255735 ATRIUM HEALTH-FORMERLY KNOWN AS CAROLINAS HEALTHCARE SYSTEM e3173aab-3710-4168-b90c-56524cd6fcf5 YY ATRIUM HEALTH-FORMERLY KNOWN AS CAROLINAS HEALTHCARE SYSTEM 58534 ATRIUM HEALTH - FORMERLY KNOWN AS CAROLINAS HEALTHCARE SYSTEM 2003 year_end PHA   Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE   180000 0 0 2004-02-02T00:00:00-05:00
255861 MR. MARK SHARPE bb525b07-e864-475c-b8ba-e3c16fc36021 YY MR. MARK SHARPE 83455 ANAZAOHEALTH CORPORATION 2003 year_end PHA   Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-02-02T00:00:00-05:00
256196 TCH GROUP, LLC c1b3e91e-ae45-4fb1-9155-06acbc09e51b YY TCH GROUP, LLC 51478 SANOFI US SERVICES INC (FORMERLY KNOWN AS SANOFI-AVENTIS U S INC ) 2003 year_end PHA 1. S.1, H.R. 1, Medicare prescription drug and modernization act of 2003. 2. S. 1113, Improved access to osteoporosis testing act of 2003. 3. S. 465, A bill to amend title XVIII of the social security act to expand Medicare coverage of certain self-injected biologicals. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-02-05T00:00:00-05:00
256248 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 PHA H.R. 1, Medicare Prescription Drug and Modernization Act of 2003, Title I – Medicare Prescription Drug Benefit, Title XI – Access to Affordable Pharmaceuticals Act. 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. HOUSE OF REPRESENTATIVES,SENATE     0 0 2004-02-05T00:00:00-05:00
256268 TCH GROUP, LLC 3b71b0a3-d411-41a2-88b7-f5b9d9f6516f YY TCH GROUP, LLC 51478 PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA 2003 year_end PHA 1. S.1, H.R. 1 Medicare prescription drug and modernization act of 2003 2. S. 650 Pediatric research equity act of 2003 3. H.R. 2427, Pharmaceutical market access act of 2003 HOUSE OF REPRESENTATIVES,SENATE 120000   0 0 2004-02-05T00:00:00-05:00
256331 BROYDRICK & ASSOCIATES 4cdf0bfd-1b1a-4f18-b4ca-640be7cef894 YY BROYDRICK & ASSOCIATES 7268 BARR LABORATORIES 2003 year_end PHA generic drug legislation HOUSE OF REPRESENTATIVES,SENATE     0 0 2004-02-06T00:00:00-05:00
256367 TCH GROUP, LLC 07881907-59bf-47b5-9c65-bfff50326fbb YY TCH GROUP, LLC 51478 BIOTECHNOLOGY INDUSTRY ORGANIZATION (BIO) 2003 year_end PHA S. 1, H.R. 1, Medicare and Prescription Drug and Modernization Act of 2003. SENATE 40000   0 0 2004-02-06T00:00:00-05:00
256836 TIMMONS AND COMPANY, INC. a2827e4b-2b53-463c-923a-36b8c6d30245 YY TIMMONS AND COMPANY, INC. 38164 BRISTOL-MYERS SQUIBB CO 2003 year_end PHA   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 170000   0 0 2004-02-10T00:00:00-05:00
256983 WINNING STRATEGIES WASHINGTON 066dbd27-d8b4-4b70-9536-57ceac81b438 YY WINNING STRATEGIES WASHINGTON 50796 CVS HEALTH CONNECTION 2003 year_end PHA Promoting CVS Health Connection initiative to assess the rise of type-2 diabetes in children HOUSE OF REPRESENTATIVES,SENATE     0 0 2004-02-10T00:00:00-05:00
257032 MICHAEL POLLARD 066638b5-dc3d-4a68-a4c3-84ba40858720 YY MICHAEL POLLARD 87836 MEDCO HEALTH SOLUTIONS INC 2003 year_end PHA S. 1 “Prescription Drug and Medicare Improvement Act of 2003,” all provisions relating to the prescriptions drug benefit. H.R. 1 “Medicare Prescription Drug and Modernization Act of 2003,” all provisions relating to the prescription drug benefit. Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2004-02-10T00:00:00-05:00
257056 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS c81961bd-e1c5-4eca-bcc9-8a2ec7e23270 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2003 year_end PHA Drug Discount Program (Section 340B of the Public Health Service Act); Medicare Reform and Prescription Drug Coverage - H.R.1, S.1. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   260000 0 0 2004-02-10T00:00:00-05:00
257238 AMERICA'S ESSENTIAL HOSPITALS c1fcd387-e7bc-42a4-80bf-fa1680cb744c YY AMERICA'S ESSENTIAL HOSPITALS 27057 AMERICA'S ESSENTIAL HOSPITALS 2003 year_end PHA Section 340B of the Public Health Service Act S. 1 and H.R. 1 Changing government policy on Medicaid best price exemptions Compliance guidance on patient assistance programs Assistance on 340B refunds Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA),White House Office   200000 0 0 2004-02-10T00:00:00-05:00
257909 WINNING STRATEGIES WASHINGTON 728d4b94-93f2-43a7-be09-22bf780d4a16 YY WINNING STRATEGIES WASHINGTON 50796 PFIZER INC 2003 year_end PHA Promoting Pfizer Health Solutions initiative to assess the ries of type-2 diabetes in children HOUSE OF REPRESENTATIVES,SENATE     0 0 2004-02-11T00:00:00-05:00
258078 3M COMPANY 61947d76-7a08-4816-ad23-71e97bc2485a YY 3M COMPANY 25465 3M COMPANY 2003 year_end PHA   Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Architectural & Transportation Barriers Compliance Board (ACCESS),U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA)   992000 0 0 2004-02-11T00:00:00-05:00
258327 FLEISCHMAN AND HARDING LLP 800948f7-da68-40f2-ab4a-2dc42c658acf YY FLEISCHMAN AND HARDING LLP 14792 NATL ASSN OF CHAIN DRUG STORES 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-02-12T00:00:00-05:00
259006 LENT SCRIVNER & ROTH LLC 555edf98-cf4e-46f5-a89b-4062b8ca1574 YY LENT SCRIVNER & ROTH LLC 22611 PFIZER 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-02-12T00:00:00-05:00
259098 BIOTECHNOLOGY INNOVATION ORGANIZATION f0c07fc8-7bca-478b-800c-08fed59855c1 YY BIOTECHNOLOGY INNOVATION ORGANIZATION 6245 BIOTECHNOLOGY INNOVATION ORGANIZATION 2003 year_end PHA   Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),Office of the Vice President of the United States,Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR),Vice President of the U.S.,White House Office   2220000 0 0 2004-02-12T00:00:00-05:00
259177 STUNTZ DAVIS & STAFFIER, P.C. 254f52a3-1305-4f6d-90e7-c4f0297e8544 YY STUNTZ DAVIS & STAFFIER, P.C. 37141 PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA 2003 year_end PHA   HOUSE OF REPRESENTATIVES 20000   0 0 2004-02-13T00:00:00-05:00
259237 OLSSON, FRANK, WEEDA, TERMAN & MATZ, PC 9061ed61-b800-4cfb-b479-f7c6f91454cb YY OLSSON, FRANK, WEEDA, TERMAN & MATZ, PC 30212 ADHERIS 2003 year_end PHA   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-02-13T00:00:00-05:00
259296 NATIONAL ALLIANCE ON MENTAL ILLNESS 5482b085-f5ae-49b8-9733-3a264523356a YY NATIONAL ALLIANCE ON MENTAL ILLNESS 26502 NATIONAL ALLIANCE ON MENTAL ILLNESS 2003 year_end PHA   Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),SENATE,Veterans Affairs, Dept of (VA)   40000 0 0 2004-02-13T00:00:00-05:00
260205 CONSUMER REPORTS, INC. (F.K.A. CONSUMERS UNION OF UNITED STATES, INC.) f0ac2b19-944a-44a6-b8e9-ef7dba206676 YY CONSUMER REPORTS, INC. (F.K.A. CONSUMERS UNION OF UNITED STATES, INC.) 10651 CONSUMER REPORTS, INC. (F.K.A. CONSUMERS UNION OF UNITED STATES, INC.) 2003 year_end PHA HR 2427 - Pharmaceurical Market Access Act of 2003 Reimportation Agriculture, Dept of (USDA),Federal Communications Commission (FCC),Federal Reserve System,Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)   193121 0 0 2004-02-13T00:00:00-05:00
260562 OLSSON, FRANK, WEEDA, TERMAN & MATZ, PC 4f60e2c4-44d2-4f26-8086-ffbe2df653e7 YY OLSSON, FRANK, WEEDA, TERMAN & MATZ, PC 30212 SANDOZ 2003 year_end PHA   Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-02-13T00:00:00-05:00
260691 DLA PIPER LLP (US) 37d6799d-0854-43ad-b51a-11c3a79f1ed9 YY DLA PIPER LLP (US) 76855 BIOVAIL CORP INTL 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2004-02-13T00:00:00-05:00
260737 MAGAZINE PUBLISHERS OF AMERICA 25405517-55e2-4865-8211-12961673c51e YY MAGAZINE PUBLISHERS OF AMERICA 23496 MAGAZINE PUBLISHERS OF AMERICA 2003 year_end PHA   Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Copyright Office,U.S. Postal Service (USPS)   440000 0 0 2004-02-13T00:00:00-05:00
261203 VAN NESS FELDMAN, LLP 792af186-1b73-4884-970a-5533d0d6606a YY VAN NESS FELDMAN, LLP 39815 MCKESSON CORPORATION 2003 year_end PHA   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-02-13T00:00:00-05:00
261204 R. B. MURPHY & ASSOCIATES, LLC 1ed4468a-915c-45dd-9c1a-564e581a508b YY R. B. MURPHY & ASSOCIATES, LLC 48931 PHRMA 2003 year_end PHA   SENATE 20000   0 0 2004-02-13T00:00:00-05:00
261647 DLA PIPER LLP (US) a677a129-e39f-4f40-8f46-8e5b03b55f76 YY DLA PIPER LLP (US) 76855 HUMAN GENOME SCIENCES, INC. 2003 year_end PHA   Defense, Dept of (DOD),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2004-02-13T00:00:00-05:00
261826 JOLLY/RISSLER, INC. 777784a3-ca04-4f05-8382-e3d69a7f9c0c YY JOLLY/RISSLER, INC. 20835 WASHINGTON COUNCIL ERNST & YOUNG 2003 year_end PHA   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 80000   0 0 2004-02-13T00:00:00-05:00
261980 OLSSON, FRANK, WEEDA, TERMAN & MATZ, PC cc7b60e0-d9e4-4962-9595-0eeb61166e4c YY OLSSON, FRANK, WEEDA, TERMAN & MATZ, PC 30212 BRANDED PHARMACEUTICAL ASSN 2003 year_end PHA   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2004-02-13T00:00:00-05:00
262497 BROYDRICK & ASSOCIATES a9ac9c12-244e-4e94-b1eb-c30d739c9604 YY BROYDRICK & ASSOCIATES 7268 SIGMA TAU PHARMACEUTICALS 2003 year_end PHA Orphan Drug Act reimbursement issues Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE     0 0 2004-02-16T00:00:00-05:00
262584 WILLIAMS AND JENSEN, PLLC 64c32988-89b4-4e1e-a854-c1cd173384bc YY WILLIAMS AND JENSEN, PLLC 41454 WYETH (FORMERLY AMERICAN HOME PRODUCTS) 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 260000   0 0 2004-02-17T00:00:00-05:00
263141 WINSTON & STRAWN LLP 1ea03d16-6953-4f4c-84a2-970e21f109b8 YY WINSTON & STRAWN LLP 41682 BARR LABORATORIES INC 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-02-17T00:00:00-05:00
263200 RICHARD F. HOHLT e3de6147-49d5-46ec-9b86-abe5f0e94fdd YY RICHARD F. HOHLT 18433 BRISTOL-MYERS SQUIBB COMPANY 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 35000   0 0 2004-02-17T00:00:00-05:00
263711 REGENCE BLUECROSS BLUESHIELD OF UTAH ced3fe4e-009f-466a-ab92-e6f88275ed99 YA REGENCE BLUECROSS BLUESHIELD OF UTAH 87791 REGENCE BLUECROSS BLUESHIELD OF UTAH 2003 year_end PHA H.R. 1, Medicare Prescription Drug and Modernization Act of 2003, Title I – Medicare Prescription Drug Benefit, Title XI – Access to Affordable Pharmaceuticals Act. 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. HOUSE OF REPRESENTATIVES,SENATE     0 0 2004-02-17T00:00:00-05:00
263945 BLUE CROSS AND BLUE SHIELD ASSOCIATION cd6e0a39-dee8-4fa4-b18a-7656edc1ec85 YY BLUE CROSS AND BLUE SHIELD ASSOCIATION 6358 BLUE CROSS AND BLUE SHIELD ASSOCIATION 2003 year_end PHA Sections of H1 and S1 pertaining to Prescription Drug Issues; Generic Drugs; Drug Comparative Effectiveness; House Amendment 215 to HR2660 "Labor HHS Appropriations for FY 2004". Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Personnel Management (OPM),SENATE,White House Office   3940000 0 0 2004-02-17T00:00:00-05:00
264072 TEVA PHARMACEUTICALS USA, INC. 7f86059e-e03e-45d0-afe7-f44a8d20c495 YY TEVA PHARMACEUTICALS USA, INC. 76695 TEVA PHARMACEUTICALS USA INC 2003 year_end PHA   Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office   640000 0 0 2004-02-17T00:00:00-05:00
264241 WILMER CUTLER PICKERING HALE AND DORR LLP 9d0c8080-5340-42c5-a75b-563cd9691d30 YY WILMER CUTLER PICKERING HALE AND DORR LLP 41534 WYETH 2003 year_end PHA   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-02-17T00:00:00-05:00
264286 HIATT COMMUNICATIONS 6d86a55d-de93-4a7c-abd7-7b4da713c9bb YT HIATT COMMUNICATIONS 58294 POLICY IMPACT STRATEGIC COMMUNICATIONS 2003 year_end PHA   Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,U.S. Agency for International Development (USAID) 12500   0 0 2004-02-17T00:00:00-05:00
264293 THE COHEN GROUP be328661-8525-4e5d-8f03-6fbe23b1b3f3 YY THE COHEN GROUP 70370 DLA PIPER US LLP 2003 year_end PHA   Defense, Dept of (DOD),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),State, Dept of (DOS),U.S. Agency for International Development (USAID) 150000   0 0 2004-02-17T00:00:00-05:00
264429 PENNSYLVANIA AVE ASSOCIATES 13f0b490-85a6-427f-a4b6-ba1b03179d76 YT PENNSYLVANIA AVE ASSOCIATES 84296 SRI INTL 2003 year_end PHA   Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 0   0 0 2004-02-17T00:00:00-05:00
264457 WINSTEAD CONSULTING GROUP 8f490ba7-4517-4e6d-9b6a-9097097b0e36 YAY WINSTEAD CONSULTING GROUP 80097 RX&D 2003 year_end PHA   Health & Human Services, Dept of (HHS) 70000   0 0 2004-02-17T00:00:00-05:00
264653 NATIONAL COMMUNITY PHARMACISTS ASSOCIATION 3c250a50-1846-49cf-99ca-6637e5beb436 YY NATIONAL COMMUNITY PHARMACISTS ASSOCIATION 27478 NATIONAL COMMUNITY PHARMACISTS ASSOCIATION 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2004-02-17T00:00:00-05:00
265237 AARP c7ba20b9-2df2-41a1-8e16-7b2719a2ae3d YY AARP 1694 AARP 2003 year_end PHA   Administration on Aging,Equal Employment Opportunity Commission (EEOC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Securities & Exchange Commission (SEC),SENATE,Social Security Administration (SSA),Transportation, Dept of (DOT),Treasury, Dept of,White House Office   16380000 0 0 2004-02-17T00:00:00-05:00
265705 SQUIRE PATTON BOGGS bc3726f8-40bf-48b5-b379-c8105148badf YY SQUIRE PATTON BOGGS 30906 PFIZER INC 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-02-17T00:00:00-05:00
265842 SRI INTERNATIONAL f2e38460-1171-4b48-b483-cdc3e5be6bd4 YY SRI INTERNATIONAL 90990 SRI INTERNATIONAL 2003 year_end PHA   Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of   100000 0 0 2004-02-17T00:00:00-05:00
265949 WINSTEAD CONSULTING GROUP b53bdf1b-7a00-489d-8c43-d22c400d80bf YYY WINSTEAD CONSULTING GROUP 80097 RX&D 2003 year_end PHA   Health & Human Services, Dept of (HHS) 70000   0 0 2004-02-17T00:00:00-05:00
266503 PODESTA GROUP, INC. 19b8c896-e241-4817-a7de-f4f1b2db429c YY PODESTA GROUP, INC. 31680 PHARMACEUTICAL RESEARCH & MANUFACTURERS OF AMERICA 2003 year_end PHA   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE 180000   0 0 2004-02-17T00:00:00-05:00
267164 SQUIRE PATTON BOGGS fb77fcf0-0e85-4d05-aa3c-1c53eb14eb99 YY SQUIRE PATTON BOGGS 30906 HOFFMANN-LA ROCHE INC 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 360000   0 0 2004-02-17T00:00:00-05:00
267540 THE HARBOUR GROUP 3c34f5fb-fef5-4a96-9c5e-37527364fa15 YY THE HARBOUR GROUP 66636 PHARMACEUTICAL RESEARCH & MANUFACTURERS OF AMERICA (PHRMA) 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 140000   0 0 2004-02-17T00:00:00-05:00
267615 MEDCO HEALTH SOLUTIONS, INC 444aa7d4-44d0-4c89-8915-3aba947390a6 YY MEDCO HEALTH SOLUTIONS, INC 89177 MEDCO HEALTH SOLUTIONS INC 2003 year_end PHA   Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   500000 0 0 2004-02-17T00:00:00-05:00
267802 BERGNER BOCKORNY CASTAGNETTI HAWKINS & BRAIN c682c080-3b45-4f66-97fe-47c8d168db5d YY BERGNER BOCKORNY CASTAGNETTI HAWKINS & BRAIN 6006 GLAXO SMITH KLINE 2003 year_end PHA   Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 100000   0 0 2004-02-17T00:00:00-05:00
267836 THE OB-C GROUP, LLC 8759d69f-b3ff-41c8-a840-4a1c9fb12e4f YY THE OB-C GROUP, LLC 29802 HEALTHCARE DISTRIBUTION MANAGEMENT ASSN 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-02-17T00:00:00-05:00
268072 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 31feb5f3-f23f-41b6-92ab-5661bdc38709 YYY ASSOCIATION OF NATIONAL ADVERTISERS, INC. 4653 ASSOCIATION OF NATIONAL ADVERTISERS, INC. 2003 year_end PHA   Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   420000 0 0 2004-02-17T00:00:00-05:00
268755 CARMEN GROUP INCORPORATED b2317ae2-0b1d-43e7-8758-819a4b34d6c3 YY CARMEN GROUP INCORPORATED 8316 WALGREEN COMPANY 2003 year_end PHA   Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),White House Office 180000   0 0 2004-02-17T00:00:00-05:00
268799 WINSTEAD PC acd4286f-1c53-4111-9eaf-858f18edd390 YY WINSTEAD PC 42741 AVENTIS PHARMACEUTICALS 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2004-02-17T00:00:00-05:00
268828 MICHAEL POLLARD 7ebd0382-fccb-4908-8213-874fe2adfe35 YY MICHAEL POLLARD 87836 MEDCO HEALTH SOLUTIONS INC 2003 year_end PHA   Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2004-02-17T00:00:00-05:00
268872 MORRISON & FOERSTER, LLP cab64913-c350-44cc-bb65-85b3fa970cc4 YY MORRISON & FOERSTER, LLP 25897 VISA INC (FKA VISA U S A INC ) 2003 year_end PHA   Education, Dept of,Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of 140000   0 0 2004-02-17T00:00:00-05:00
268929 AMERICAN SOCIETY OF HEALTH-SYSTEM PHARMACISTS 07d159af-455f-42c2-a59a-8b389b4ba4df YY AMERICAN SOCIETY OF HEALTH-SYSTEM PHARMACISTS 3457 AMERICAN SOCIETY OF HEALTH-SYSTEM PHARMACISTS 2003 year_end PHA   Agency for Healthcare Research & Quality (AHRQ),Centers For Medicare and Medicaid Services (CMS),Drug Enforcement Administration (DEA),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   60000 0 0 2004-02-17T00:00:00-05:00
268973 ML STRATEGIES, LLC f27d5285-ee72-4bf7-842d-90a4e97e65cc YY ML STRATEGIES, LLC 25603 PHARMACEUTICAL RESEARCH & MANUFACTURERS OF AMERICA (PHRMA) 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2004-02-17T00:00:00-05:00
268996 WILLIAMS AND JENSEN, PLLC 567b9aa5-dcc9-4fe9-b00a-92c04955b048 YY WILLIAMS AND JENSEN, PLLC 41454 NOVARTIS INC 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2004-02-17T00:00:00-05:00
269059 THE OB-C GROUP, LLC af67d16a-1c25-4185-9422-940ccf752853 YY THE OB-C GROUP, LLC 29802 BIOTECHNOLOGY INDUSTRY ORGANIZATION 2003 year_end PHA   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office 160000   0 0 2004-02-17T00:00:00-05:00
269520 MCGUINESS & HOLCH fb024f38-a8af-4c2b-9ac5-8dace6626f18 YY MCGUINESS & HOLCH 24464 BARR LABS 2003 year_end PHA Issues relating to FDA drug approval time; issues relating to the market exclusivity of drugs. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2004-02-18T00:00:00-05:00
269637 JORDEN BURT LLP a5b3718d-9069-48d7-830e-b8415214eb40 YY JORDEN BURT LLP 43398 BLUECROSS BLUESHIELD OF FLORIDA 2003 year_end PHA   Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-02-18T00:00:00-05:00
269857 JORDEN BURT LLP 7f875fc4-a341-4b74-8e90-c602ffecc4af YY JORDEN BURT LLP 43398 KOS PHARMACEUTICALS 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2004-02-19T00:00:00-05:00
270107 HANCE SCARBOROUGH 870c1d39-14ea-4487-bd0b-9b2d554fa64d YY HANCE SCARBOROUGH 17443 PARRY ROMANI DECONCINI & SYMMS 2003 year_end PHA     20000   0 0 2004-02-20T00:00:00-05:00
270227 GILBERT'S LLP c36d74df-15c6-47d1-ae14-17768bbddcc6 YY GILBERT'S LLP 67876 APOTEX INC 2003 year_end PHA   Federal Trade Commission (FTC),Food & Drug Administration (FDA) 15000   0 0 2004-02-20T00:00:00-05:00
270387 US STRATEGIES 914917d2-8ae7-4cc9-b644-9e448a03e6f4 YY US STRATEGIES 38825 IVAX 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-02-24T00:00:00-05:00
270388 ASSOCIATION FOR ACCESSIBLE MEDICINES b25f606a-8554-4457-afb6-a78a83fa8c99 YY ASSOCIATION FOR ACCESSIBLE MEDICINES 16032 ASSOCIATION FOR ACCESSIBLE MEDICINES 2003 year_end PHA   Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office   300000 0 0 2004-02-24T00:00:00-05:00
270464 MEDICAL ASSOCIATION OF GEORGIA 085d5607-18ee-4461-9732-1faced5dc897 YY MEDICAL ASSOCIATION OF GEORGIA 24783 MEDICAL ASSOCIATION OF GEORGIA 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2004-02-24T00:00:00-05:00
270625 THE KROGER CO. bf70c2f3-2744-4022-96bf-82af2785c27c YY THE KROGER CO. 88212 KROGER CO 2003 year_end PHA   Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   0 0 0 2004-02-24T00:00:00-05:00
270837 UNIVERSITY OF IOWA abe35353-7d03-4a6e-b3ef-d2fa14654431 YY UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2003 year_end PHA   Agriculture, Dept of (USDA),Education, Dept of,Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),State, Dept of (DOS)   80000 0 0 2004-02-24T00:00:00-05:00
271678 HEALTHCARE DISTRIBUTION ALLIANCE(HDA)(FORMERLY HEALTHCARE DISTRIBUTION MANAGEMENT ASSOCIATION (HDMA) 6936c652-db05-45fc-aab2-dd64a9d6ee00 YY HEALTHCARE DISTRIBUTION ALLIANCE(HDA)(FORMERLY HEALTHCARE DISTRIBUTION MANAGEMENT ASSOCIATION (HDMA) 28776 HEALTHCARE DISTRIBUTION ALLIANCE (FORMERLY - HDMA) 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE   80000 0 0 2004-03-02T00:00:00-05:00
271767 ANTHEM HEALTH PLANS OF VIRGINIA INC 04f28c01-5081-440d-8699-523be1f461b7 YY ANTHEM HEALTH PLANS OF VIRGINIA INC 38472 ANTHEM HEALTH PLANS OF VIRGINIA INC 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2004-03-03T00:00:00-05:00
272060 THE POTOMAC GROUP c5b514b0-7159-4ca9-b06c-332a8e61fcf7 YY THE POTOMAC GROUP 31918 WALGREENS 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-03-03T00:00:00-05:00
272153 POLICY DIRECTIONS INC. 70dd2b79-71a9-4d8b-9a9d-4b59c1b49249 YY POLICY DIRECTIONS INC. 31747 ALPHARMA INC/PFIZER ANIMAL HEALTH (FORMERLY KNOWN AS ALPHARMA INC ) 2003 year_end PHA   Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-03-03T00:00:00-05:00
272156 RYAN MACKINNON VASAPOLI AND BERZOK, LLP acb71b5c-69fa-46e5-a025-472536f06822 YY RYAN MACKINNON VASAPOLI AND BERZOK, LLP 30187 PFIZER INC 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2004-03-03T00:00:00-05:00
272923 BLUE CROSS AND BLUE SHIELD OF FLORIDA, INC. 339eb6ce-cf60-4e0a-ba19-7818cc7c2917 YY BLUE CROSS AND BLUE SHIELD OF FLORIDA, INC. 6382 BLUE CROSS AND BLUE SHIELD OF FLORIDA INC 2003 year_end PHA   Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE   320000 0 0 2004-03-03T00:00:00-05:00
273056 WELLMARK, INC. 811192ab-7ad7-410e-abb0-b32f6b609656 YY WELLMARK, INC. 40910 WELLMARK INC 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE   0 0 0 2004-03-03T00:00:00-05:00
273240 ASSET & EQUITY CORPORATION efe80bcc-2d62-43bc-a399-c353e6013b4c YY ASSET & EQUITY CORPORATION 4403 THERAGENICS CORPORATION 2003 year_end PHA   Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-03-03T00:00:00-05:00
273312 MEREDITH MCGEHEE 03defeb1-0e63-4075-8e52-0850f0739175 YY MEREDITH MCGEHEE 79858 INTERNATIONAL AIDS VACCINE INITIATIVE 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-03-04T00:00:00-05:00
273504 ROBERT BETZ ASSOCIATES, LLC dc54adf3-2239-48cb-a8bc-58a2d379fad4 YY ROBERT BETZ ASSOCIATES, LLC 6121 HEALTH INDUSTRY GROUP PURCHASING ASSN 2003 year_end PHA   Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2004-03-05T00:00:00-05:00
273952 UNIVERSITY OF PITTSBURGH MEDICAL CENTER 7c88a307-6ed4-438d-ab3c-5deb09d856b9 YY UNIVERSITY OF PITTSBURGH MEDICAL CENTER 32065 UNIVERSITY OF PITTSBURGH MEDICAL CENTER 2003 year_end PHA   Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Bureau of Investigation (FBI),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Institutes of Health (NIH),SENATE,White House Office   200000 0 0 2004-03-09T00:00:00-05:00
274231 PARRY, ROMANI, DECONCINI & SYMMS 3324a884-8c3e-4a4d-a867-e60e7b4d9733 YY PARRY, ROMANI, DECONCINI & SYMMS 30792 CMTE TO ADVANCE COMPOUNDING PHARMACY 2003 year_end PHA   HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2004-03-10T00:00:00-05:00
274318 WYETH 72008861-ab95-4a48-a27c-739bce5608c4 YY WYETH 2558 WYETH 2003 year_end PHA   Executive Office of the President (EOP),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Security Council (NSC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR),Vice President of the U.S.   1500000 0 0 2004-03-11T00:00:00-05:00
274342 ANIMAL HEALTH INSTITUTE 0fa36820-499f-43e0-ad91-c1533214cfcf YY ANIMAL HEALTH INSTITUTE 4037 ANIMAL HEALTH INSTITUTE 2003 year_end PHA   Agriculture, Dept of (USDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2004-03-12T00:00:00-05:00
274348 AMERICAN ASSOCIATION OF COLLEGES OF PHARMACY f45567c7-96f2-4639-91c5-05dc3c503b07 YY AMERICAN ASSOCIATION OF COLLEGES OF PHARMACY 46803 AMERICAN ASSOCIATION OF COLLEGES OF PHARMACY 2003 year_end PHA   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2004-03-12T00:00:00-05:00
275136 ABERNATHY CONSULTANTS, CATHY d80869a9-2332-4dd2-b93f-1b03421e25dd YY ABERNATHY CONSULTANTS, CATHY 69151 PHARMACEUTICAL RESEARCH ASSN (PHRMA) 2003 year_end PHA   HOUSE OF REPRESENTATIVES 140000   0 0 2004-03-16T00:00:00-05:00
275268 WALMART INC. 4fbf218b-3261-45ac-9aa6-4f120affe5e2 YY WALMART INC. 40305 WALMART INC 2003 year_end PHA   Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   540000 0 0 2004-03-17T00:00:00-05:00

Next page

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