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

254 rows where filing_period = "year_end", filing_year = 2002 and issue_code = "MED" 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

  • MED · 254 ✖

filing_year 1

  • 2002 · 254 ✖

filing_period 1

  • year_end · 254 ✖
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
155577 COALITION RESOURCES, INC. fc7c8f9c-d3e8-4673-ab7b-376f488034f9 YY COALITION RESOURCES, INC. 69798 CHILDREN'S ENVIRONMENTAL HEALTH NETWORK 2002 year_end MED   Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-02-05T00:00:00-05:00
155835 ERNST & YOUNG c91b9336-e3ff-4d87-8ff0-a0290e9dbcfe YT ERNST & YOUNG 13825 PHARMACEUTICAL RESEARCH & MANUFACTURERS OF AMERICA 2002 year_end MED     10000   0 0 2002-05-30T00:00:00-04:00
193034 CONCERNED WOMEN FOR AMERICA LEGISLATIVE ACTION COMMITTEE b31a9f24-1919-4863-bd51-4fbefdbf4328 YY CONCERNED WOMEN FOR AMERICA LEGISLATIVE ACTION COMMITTEE 47985 CONCERNED WOMEN FOR AMERICA LEGISLATIVE ACTION COMMITTEE 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE   164000 0 0 2002-10-09T00:00:00-04:00
193732 SAMUELS, MARC B. 6215f80f-4d2d-4df9-a41a-e01b77ee00df YY SAMUELS, MARC B. 63757 IDEC PHARMACEUTICALS 2002 year_end MED   Centers For Medicare and Medicaid Services (CMS),Food & Drug Administration (FDA) 60000   0 0 2003-01-06T00:00:00-05:00
193741 SAMUELS, MARC B. b99d0e5f-f5d1-4689-868a-fc3508a4a8c6 YY SAMUELS, MARC B. 63757 FOLEY HOAG 2002 year_end MED   Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS) 0   0 0 2003-01-06T00:00:00-05:00
193796 NATIONAL VENTURE CAPITAL ASSOCIATION b03804f4-fa8b-48be-85af-b088353543a9 YY NATIONAL VENTURE CAPITAL ASSOCIATION 21687 NATIONAL VENTURE CAPITAL ASSOCIATION 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE   460000 0 0 2003-01-07T00:00:00-05:00
194037 HALLIBURTON COMPANY 0a913df0-8255-416a-809e-08700efe86be YY HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2002 year_end MED HR 2615 Medical Privacy Protection Act HHS Appropriation Bill for Medical Legislation HR 2315, HR 526, S 872 S 812 Patient's Bill of Rights S 710 Kennedy Healthcare bill HR 4600 Health Act HR 3897 Health bill Commerce, Dept of (DOC),Energy, Dept of,Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR),White House Office   150000 0 0 2003-01-15T00:00:00-05:00
194342 EMD SERONO, INC. 4397458b-5dcd-4c34-ae40-796a9fc0931a YY EMD SERONO, INC. 48736 EMD SERONO INC 2002 year_end MED   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   25000 0 0 2003-01-22T00:00:00-05:00
194406 BEN BARNES GROUP LP 10e6688d-1816-4947-adbd-a9a738b5567e YY BEN BARNES GROUP LP 5415 ROGERS ADORNO/JACK JACOBS 2002 year_end MED   SENATE 0   0 0 2003-01-23T00:00:00-05:00
194497 MR. STEVEN BECKHAM 880450a5-8004-4689-be83-ed7ca877134f YY MR. STEVEN BECKHAM 5756 UNIVERSITY OF SOUTH CAROLINA 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2003-01-23T00:00:00-05:00
194512 ZERO PROSTATE CANCER 0871f862-4245-4bdf-b20f-918cc402c06f YY ZERO PROSTATE CANCER 28388 ZERO PROSTATE CANCER 2002 year_end MED Preferred drug list programs Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,Veterans Affairs, Dept of (VA)   40000 0 0 2003-01-24T00:00:00-05:00
194543 SAMUELS, MARC B. 152560cd-94e0-4f7a-a46a-4d5edc058d28 YY SAMUELS, MARC B. 63757 WYETH AYERST PHARMACEUTICALS 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2003-01-27T00:00:00-05:00
194553 ASSN OF DISPOSABLE DEVICE MANUFACTURERS 03897eae-1fda-4d11-b467-a110b1de53c9 YY ASSN OF DISPOSABLE DEVICE MANUFACTURERS 55278 ASSN OF DISPOSABLE DEVICE MANUFACTURERS 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2003-01-27T00:00:00-05:00
194558 GATEWAY VENTURES 84303e87-e0da-4a80-b992-9a1ceb8d3790 YY GATEWAY VENTURES 64337 PHILIP MORRIS 2002 year_end MED   Health & Human Services, Dept of (HHS) 80000   0 0 2003-01-27T00:00:00-05:00
194635 SAMUELS, MARC B. d1ee789f-3904-46e8-8768-05a55af8e643 YY SAMUELS, MARC B. 63757 PHARMACEUTICAL & RESEARCH MANUFACTURERS ASSN OF AMERICA 2002 year_end MED   Centers For Medicare and Medicaid Services (CMS),Executive Office of the President (EOP),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Office of Management & Budget (OMB) 60000   0 0 2003-01-27T00:00:00-05:00
194766 UNIVERSITY OF ILLINOIS edd505be-3af3-432c-be27-47bf2e24909d YY UNIVERSITY OF ILLINOIS 39427 UNIVERSITY OF ILLINOIS 2002 year_end MED   Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Defense, Dept of (DOD),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,Justice, Dept of (DOJ),Natl Endowment for the Arts,Natl Foundation on the Arts & Humanities,Natl Institutes of Health (NIH),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA)   40000 0 0 2003-01-27T00:00:00-05:00
195699 RTI INTERNATIONAL 73f5f714-d794-4a4a-a286-c8c9857d1277 YY RTI INTERNATIONAL 62791 RTI INTERNATIONAL 2002 year_end MED NIH and CDC appropriations HOUSE OF REPRESENTATIVES,SENATE   13672 0 0 2003-02-04T00:00:00-05:00
195860 AMFAR THE FOUNDATION FOR AIDS RESEARCH 7fa35cc3-b7a8-4f65-a813-39a4a3e476f5 YY AMFAR THE FOUNDATION FOR AIDS RESEARCH 2398 AMFAR THE FOUNDATION FOR AIDS RESEARCH 2002 year_end MED   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE   80000 0 0 2003-02-05T00:00:00-05:00
195864 AMERICAN SOCIETY FOR MICROBIOLOGY c6115c64-dc35-4448-b008-3391c9a75fa9 YY AMERICAN SOCIETY FOR MICROBIOLOGY 3355 AMERICAN SOCIETY FOR MICROBIOLOGY 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE   0 0 0 2003-02-05T00:00:00-05:00
195871 ZUCKERMAN SPAEDER LLP 5ec6234f-796c-4f4b-ae8c-50f3f6860cb9 YY ZUCKERMAN SPAEDER LLP 42160 AMERICAN PSYCHOLOGICAL SOCIETY 2002 year_end MED Behavioral research Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE     0 0 2003-02-05T00:00:00-05:00
195967 AMERICAN ASSOCIATION FOR MARRIAGE AND FAMILY THERAPY 2c4e7a72-7851-42d4-bcd1-750d21b8245d YY AMERICAN ASSOCIATION FOR MARRIAGE AND FAMILY THERAPY 1488 AMERICAN ASSOCIATION FOR MARRIAGE AND FAMILY THERAPY 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE   100000 0 0 2003-02-05T00:00:00-05:00
196143 LEGISLATIVE STRATEGIES GROUP cfea709d-d8f9-47fa-bcb9-74933ab9cdf6 YT LEGISLATIVE STRATEGIES GROUP 43651 NOVARTIS CORP 2002 year_end MED   Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2003-02-06T00:00:00-05:00
196273 LEGISLATIVE STRATEGIES GROUP 6e0f0c78-0bb7-45de-b444-6a79e4999c63 YT LEGISLATIVE STRATEGIES GROUP 43651 CHILDREN'S MEDICAL CENTER OF DALLAS 2002 year_end MED   Centers For Disease Control & Prevention (CDC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office 60000   0 0 2003-02-06T00:00:00-05:00
196425 LEGISLATIVE STRATEGIES GROUP 394ad5ba-a1c7-452f-ba8e-ee44a0e6b7fd YT LEGISLATIVE STRATEGIES GROUP 43651 CARDINAL HEALTH 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2003-02-06T00:00:00-05:00
196606 MARSHFIELD CLINIC HEALTH SYSTEM b2ec8aed-07a4-4515-84fd-68a8c95f6d73 YY MARSHFIELD CLINIC HEALTH SYSTEM 57830 MARSHFIELD CLINIC HEALTH SYSTEM 2002 year_end MED HR 4795 introduced by Rep. Kleczka, and S 2560 introduced by Sen. Allard, the Chronic wasting Disease Support Act of 2002, to provide for a multi-agency effort to control the spread of the disease in deer and elk herds. HR 4775. 2002 Supplemental Appropriations Act for Further Recovery From and Response To Terrorist Attacks on the United States introduced by Rep. Young, provisions establishing funding to combat Chronic Wasting Disease. Agency for Healthcare Research & Quality (AHRQ),Centers For Medicare and Medicaid Services (CMS),Council of Economic Advisers (CEA),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,Natl Institutes of Health (NIH),SENATE   122924 0 0 2003-02-07T00:00:00-05:00
196648 ZUCKERMAN SPAEDER LLP bdb4f31c-f53b-4c78-98ec-ffb75368b978 YY ZUCKERMAN SPAEDER LLP 42160 UNITED STATES PHARMACOPEIA 2002 year_end MED Medical error legislation; standard-setting activities Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2003-02-07T00:00:00-05:00
196726 MICHELSON, LAW OFFICE OF STUART R. 2f565753-cc2b-4ff5-aee4-654ccfa51644 YY MICHELSON, LAW OFFICE OF STUART R. 43605 ESRD LABORATORY 2002 year_end MED   Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES 0   0 0 2003-02-09T00:00:00-05:00
196771 MCDERMOTT WILL & SCHULTE LLP 81833648-e397-4f25-ba30-9a7523b5a67d YY MCDERMOTT WILL & SCHULTE LLP 24338 AMERICAN GASTROENTROLOGICAL ASSN 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE 20000   0 0 2003-02-10T00:00:00-05:00
196893 AMERICAN ASSOCIATION OF COLLEGES OF NURSING e5ef4cce-1b99-49bd-92a2-0a02a97546e0 YY AMERICAN ASSOCIATION OF COLLEGES OF NURSING 66911 AMERICAN ASSOCIATION OF COLLEGES OF NURSING 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE   80000 0 0 2003-02-10T00:00:00-05:00
196944 ZUCKERMAN SPAEDER LLP 7863407d-6121-4c34-abc3-503f39ecbc16 YY ZUCKERMAN SPAEDER LLP 42160 KV PHARMACEUTICALS 2002 year_end MED   Food & Drug Administration (FDA)     0 0 2003-02-10T00:00:00-05:00
197199 BKSH & ASSOCIATES 20641772-90f1-4a56-a9a3-45e679629e0c YT BKSH & ASSOCIATES 6291 GENENTECH 2002 year_end MED S. 30, Financial Information Privacy Protection Act of 2001; H.R. 2505/S. 2172, cloning of embryos. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2003-02-10T00:00:00-05:00
197284 FLEISCHMAN AND HARDING LLP e74b7fdb-e8fa-4e71-aa35-017d77c7f147 YY FLEISCHMAN AND HARDING LLP 14792 STEMCYTE INC 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2003-02-11T00:00:00-05:00
197369 COALITION RESOURCES, INC. 83ad6f1d-0d3d-46a6-bb8e-2c48ea9614f8 YY COALITION RESOURCES, INC. 69798 CHILDREN'S ENVIRONMENTAL HEALTH NETWORK 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2003-02-11T00:00:00-05:00
197394 DENNY MILLER ASSOCIATES a450ac6a-a236-45f2-86d0-4737268ae1f8 YY DENNY MILLER ASSOCIATES 25328 SWEDISH MEDICAL CENTER 2002 year_end MED FY2004Departments of Labor, Health and Human Servivces Appropriations Bill FY2004 Department of Vetreans Housing and Urban Deveopment Appropriation Bill FY 3004 Energy and Water Development Appropriations Bill HOUSE OF REPRESENTATIVES,SENATE     0 0 2003-02-11T00:00:00-05:00
197408 ZUCKERMAN SPAEDER LLP 298b6ac3-74f1-4c8d-bbf2-55b5917c7f2b YT ZUCKERMAN SPAEDER LLP 42160 PRAECIS PHARMACEUTICALS INCORPORATED 2002 year_end MED Regulatory issues and strategy. Food & Drug Administration (FDA)     0 0 2003-02-11T00:00:00-05:00
197460 TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA c2a61162-a71b-4d96-9af5-67fc19270fe9 YY TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA 38608 TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE   140000 0 0 2003-02-11T00:00:00-05:00
197662 PILLSBURY WINTHROP SHAW PITTMAN LLP 121a2056-92bf-4b18-896f-f38d440c7699 YY PILLSBURY WINTHROP SHAW PITTMAN LLP 35002 NCCR 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2003-02-11T00:00:00-05:00
197744 ZUCKERMAN SPAEDER LLP 2901c889-9178-4006-be2b-503a486e7557 YY ZUCKERMAN SPAEDER LLP 42160 BARR LABORATORIES 2002 year_end MED Intersection between Hatch-Waxman generic exclusivity and pediatric exclusivity. Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2003-02-11T00:00:00-05:00
197851 CLEVELAND CLINIC FOUNDATION a5a68c9a-9df1-4331-98fa-3ac973e04765 YY CLEVELAND CLINIC FOUNDATION 9498 CLEVELAND CLINIC FOUNDATION 2002 year_end MED   Defense, Dept of (DOD),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE   80000 0 0 2003-02-11T00:00:00-05:00
197890 AMERICAN MEDICAL ASSOCIATION 2f042206-4909-4b6f-869a-edcd9f0c9426 YY AMERICAN MEDICAL ASSOCIATION 2877 AMERICAN MEDICAL ASSOCIATION 2002 year_end MED   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   7220000 0 0 2003-02-11T00:00:00-05:00
197911 ASSOCIATION OF AMERICAN MEDICAL COLLEGES b8d919b4-44ae-49f7-b1d9-f4976d0fc1c1 YY ASSOCIATION OF AMERICAN MEDICAL COLLEGES 4493 ASSOCIATION OF AMERICAN MEDICAL COLLEGES 2002 year_end MED   Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Veterans Affairs, Dept of (VA),White House Office   320000 0 0 2003-02-11T00:00:00-05:00
197919 WAKE FOREST UNIVERSITY HEALTH SCIENCES ce021f94-e352-4ece-a1fb-c719a5c97982 YY WAKE FOREST UNIVERSITY HEALTH SCIENCES 6781 WAKE FOREST UNIVERSITY HEALTH SCIENCES 2002 year_end MED   Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   120000 0 0 2003-02-11T00:00:00-05:00
198120 O'NEILL, ATHY & CASEY, P.C. c922d6f3-7d3a-4f8d-a276-28e2ced05d50 YY O'NEILL, ATHY & CASEY, P.C. 42752 DES MOINES UNIV - OSTEOPATHIC MEDICAL CENTER 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2003-02-12T00:00:00-05:00
198182 AMERICAN INSURANCE ASSN ac92c963-317b-4e2c-956e-4315cc6d2220 YY AMERICAN INSURANCE ASSN 2662 AMERICAN INSURANCE ASSN 2002 year_end MED H.R. 1639 - Common Sense Medical Malpractice Reform Act of 2001 H.R. 2103 - Medical Malpractice Rx Act H.R. 2315 - CARE Act of 2001 H.R. 4600 - Help, Efficient, Accessible, Low Cost, Timely Health Care (HEALTH) Act of 2002 Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of the Comptroller of the Currency (OCC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR)   3145300 0 0 2003-02-12T00:00:00-05:00
198197 GEORGETOWN UNIVERSITY 7c9bee88-a984-46cd-997d-26a46c369b8a YY GEORGETOWN UNIVERSITY 62016 GEORGETOWN UNIVERSITY 2002 year_end MED   Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Federal Transit Administration (FTA),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Institutes of Health (NIH),Natl Park Service (NPS),Overseas Private Investment Corp (OPIC),SENATE   100000 0 0 2003-02-12T00:00:00-05:00
198238 CLARK & WEINSTOCK bf2372d8-ed4f-4cd5-8e0c-49479a445a77 YY CLARK & WEINSTOCK 9443 LEADINGAGE 2002 year_end MED   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 100000   0 0 2003-02-12T00:00:00-05:00
198316 CLARK & WEINSTOCK bce2dda4-ee4f-448b-9e67-65fe768844fe YY CLARK & WEINSTOCK 9443 GUIDANT CORP 2002 year_end MED   Centers For Medicare and Medicaid Services (CMS),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of the Vice President of the United States 160000   0 0 2003-02-12T00:00:00-05:00
198456 CLARK & WEINSTOCK 3e423bd1-edb7-45e4-b6ae-95ccdacfe020 YY CLARK & WEINSTOCK 9443 PHRMA 2002 year_end MED   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 180000   0 0 2003-02-12T00:00:00-05:00
198615 O'NEILL, ATHY & CASEY, P.C. f41e8f3b-2ecc-4713-a5dc-db61fcb87412 YY O'NEILL, ATHY & CASEY, P.C. 42752 MASS GENERAL BRIGHAM 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 120000   0 0 2003-02-12T00:00:00-05:00
198802 CLARK & WEINSTOCK 4ba2ed9e-3c56-4f83-ab7b-54f79b26b4da YY CLARK & WEINSTOCK 9443 HEALTH NET INC 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2003-02-12T00:00:00-05:00
198851 ZUCKERMAN SPAEDER LLP 47915f63-0d94-46b8-a2be-99b802c026e2 YY ZUCKERMAN SPAEDER LLP 42160 SERONO INC 2002 year_end MED Orphan Drug Act Policy; the drug Rebif. Food & Drug Administration (FDA) 20000   0 0 2003-02-12T00:00:00-05:00
198987 AMERICAN HEART ASSOCIATION 778b02e4-0c67-419c-9335-97e417008399 YY AMERICAN HEART ASSOCIATION 2525 AMERICAN HEART ASSOCIATION 2002 year_end MED   Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),General Services Administration (GSA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Veterans Affairs, Dept of (VA),White House Office   620000 0 0 2003-02-12T00:00:00-05:00
199511 MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 300c2d12-735d-47f7-84f8-62dce18747c1 YY MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 25498 MOREHOUSE SCHOOL OF MEDICINE 2002 year_end MED   Centers For Disease Control & Prevention (CDC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,U.S. Agency for International Development (USAID),White House Office 30000   0 0 2003-02-13T00:00:00-05:00
199737 ADVANCEPCS e5a33b50-9080-41b9-969a-8c76a94d9183 YY ADVANCEPCS 67477 ADVANCEPCS 2002 year_end MED   Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office 420000   0 0 2003-02-13T00:00:00-05:00
199792 UNIVERSITY OF WASHINGTON 48badf8a-5d63-44e6-ab9a-997cd7df3fdc YY UNIVERSITY OF WASHINGTON 39553 UNIVERSITY OF WASHINGTON 2002 year_end MED   Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),SENATE   100000 0 0 2003-02-13T00:00:00-05:00
200246 THE UNIVERSITY OF TEXAS SYSTEM f320ba9e-f207-41f1-ba2f-daa5c0bdf9cd YY THE UNIVERSITY OF TEXAS SYSTEM 39531 THE UNIVERSITY OF TEXAS SYSTEM 2002 year_end MED   Agriculture, Dept of (USDA),Army, Dept of (Other),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Internal Revenue Service (IRS),Natl Institutes of Health (NIH),SENATE,Treasury, Dept of   100000 0 0 2003-02-13T00:00:00-05:00
200376 RUSS REID COMPANY f872b711-3123-4f0d-b893-f2732324e4f8 YY RUSS REID COMPANY 33000 KIRYAS JOEL VILLAGE OF 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2003-02-13T00:00:00-05:00
200447 BRISTOL-MYERS SQUIBB COMPANY 3badbc14-37cb-4f06-b30d-1375536707f8 YY BRISTOL-MYERS SQUIBB COMPANY 7053 BRISTOL-MYERS SQUIBB COMPANY 2002 year_end MED   Commerce, Dept of (DOC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR)   2420000 0 0 2003-02-13T00:00:00-05:00
200578 UNIVERSITY OF CALIFORNIA 741f53d1-e961-404b-ae88-246af5ace27e YY UNIVERSITY OF CALIFORNIA 39358 UNIVERSITY OF CALIFORNIA 2002 year_end MED   Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Council of Economic Advisers (CEA),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Aeronautics & Space Administration (NASA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Navy, Dept of,Office of Management & Budget (OMB),SENATE,State, Dept of (DOS)     0 0 2003-02-13T00:00:00-05:00
200729 HOGAN LOVELLS US LLP a270200c-11d9-4009-b257-fc06c7044c6f YY HOGAN LOVELLS US LLP 18422 VIACALL 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE,White House Office 20000   0 0 2003-02-13T00:00:00-05:00
200766 ACADEMY FOR RADIOLOGY & BIOMEDICAL IMAGING RESEARCH 51d90582-08d4-4be3-b7af-5d0e2ae88d66 YY ACADEMY FOR RADIOLOGY & BIOMEDICAL IMAGING RESEARCH 113 ACADEMY FOR RADIOLOGY & BIOMEDICAL IMAGING RESEARCH 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   100000 0 0 2003-02-13T00:00:00-05:00
200784 BROYDRICK & ASSOCIATES 1f48df52-56a6-4f97-8697-c0cbc041823c YY BROYDRICK & ASSOCIATES 7268 SIGMA TAU PHARMACEUTICALS 2002 year_end MED Orphan Drug Act Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2003-02-13T00:00:00-05:00
200835 ARENTFOX SCHIFF LLP 03ffc577-f668-4c8a-9916-5d0abbfea0a9 YY ARENTFOX SCHIFF LLP 4208 AMERICAN ASSN OF BIOANALYSTS 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2003-02-13T00:00:00-05:00
200984 FRESHMAN KAST INC 536518f2-5fa9-47ca-86a6-272bb32ec31d YY FRESHMAN KAST INC 15474 MONTEREY COUNTY ADMINISTRATIVE OFFICE 2002 year_end MED Nurse Reinvestment Act, H.R. 3487, S. 1864 All provisions. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2003-02-13T00:00:00-05:00
201003 CAPITOL ASSOCIATES, INC. f86bbc69-d3dc-41e2-a1f8-656b7c879c43 YY CAPITOL ASSOCIATES, INC. 8101 NATL ALLIANCE FOR EYE & VISION RESEARCH 2002 year_end MED   HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE 60000   0 0 2003-02-13T00:00:00-05:00
201126 PACQUING CONSULTING, INC. babdeeae-acac-49f7-8d59-d0eb1371bb11 YY PACQUING CONSULTING, INC. 53460 LIVINGSTON GROUP 2002 year_end MED   Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) 60000   0 0 2003-02-14T00:00:00-05:00
201194 ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) efaf0dc6-12e4-4ba7-8081-d58bff9484c5 YY ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 57475 US ONCOLOGY 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2003-02-14T00:00:00-05:00
201779 NATIONAL PTA cf80821c-5416-4d3a-9075-0177bb67d433 YY NATIONAL PTA 28390 NATIONAL PTA 2002 year_end MED   Education, Dept of,Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Office of Natl Drug Control Policy (NDCP),SENATE,White House Office   200000 0 0 2003-02-14T00:00:00-05:00
201974 BIOTECHNOLOGY INNOVATION ORGANIZATION e5cc61ef-7ef1-4271-9ae0-0e4dbb81400c YY BIOTECHNOLOGY INNOVATION ORGANIZATION 6245 BIOTECHNOLOGY INNOVATION ORGANIZATION 2002 year_end MED   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,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),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   1740000 0 0 2003-02-14T00:00:00-05:00
201987 DUTKO WORLDWIDE, LLC dd45358e-1763-4305-b527-10714d755fe8 YY DUTKO WORLDWIDE, LLC 12868 AMDEC POLICY GROUP 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2003-02-14T00:00:00-05:00
202068 BALCH & BINGHAM, LLP 2dcb9543-0616-48fa-bd43-14451966252d YY BALCH & BINGHAM, LLP 5197 VAXIN PHARMACEUTICALS INC 2002 year_end MED   Army, Dept of (Other),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE 40000   0 0 2003-02-14T00:00:00-05:00
202176 BARNES & THORNBURG, LLP a44b42e7-4a44-407e-b735-1dc1c10e4a55 YY BARNES & THORNBURG, LLP 5404 CENTER FOR PATIENT ADVOCACY 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2003-02-14T00:00:00-05:00
202463 GSK (FKA GLAXOSMITHKLINE INC.) 01f790d1-b12a-4c35-88be-3376665cf49c YY GSK (FKA GLAXOSMITHKLINE INC.) 16293 GSK (FKA GLAXOSMITHKLINE INC.) 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   2500000 0 0 2003-02-14T00:00:00-05:00
202490 EVANS CAPITOL GROUP 75d62648-9df2-4bd6-893b-37419bc32939 YY EVANS CAPITOL GROUP 13940 SUSAN G KOMEN FOR THE CURE ADVOCACY ALLIANCE 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2003-02-14T00:00:00-05:00
202616 CHRISTOPHER REEVE FOUNDATION, A NEW JERSEY NONPROFIT CORPORATION ecc43edb-4e1e-4ee4-9fcd-3f293e52becb YY CHRISTOPHER REEVE FOUNDATION, A NEW JERSEY NONPROFIT CORPORATION 61618 CHRISTOPHER REEVE FOUNDATION A NEW JERSEY NONPROFIT CORPORATION 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE   0 0 0 2003-02-14T00:00:00-05:00
202814 MS. LAURA ALLENDORF 613e79ec-5645-46d0-bbcb-51d6c113377e YY MS. LAURA ALLENDORF 63096 AMERICAN GERIATRIC SOCIETY 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2003-02-14T00:00:00-05:00
202839 AMERICAN PSYCHIATRIC ASSOCIATION 4cf284ff-3c82-4fe8-9a44-6d7137efce99 YY AMERICAN PSYCHIATRIC ASSOCIATION 3151 AMERICAN PSYCHIATRIC ASSOCIATION 2002 year_end MED   Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   120000 0 0 2003-02-14T00:00:00-05:00
202897 CASSIDY & ASSOCIATES, INC. c643a6f8-399e-46d0-8073-74ea788da83c YT CASSIDY & ASSOCIATES, INC. 8453 GREENWICH LYME DISEASE TASK FORCE 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2003-02-14T00:00:00-05:00
203022 STRATEGIC MARKETING INNOVATIONS 7caf91c5-957a-4c0b-9afb-810674c781c5 YY STRATEGIC MARKETING INNOVATIONS 60550 UNIV OF TEXAS AT DALLAS 2002 year_end MED S 2766 FY '03 Labor, Health & Human Services and Education Appropriations for the expansion of the basic research effort in Sickle Cell Disease. Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE 40000   0 0 2003-02-14T00:00:00-05:00
203173 STONE MATTHEIS XENOPOULOS AND BREW, PC e529b836-80e0-48d6-8dd3-8ca129a275f1 YY STONE MATTHEIS XENOPOULOS AND BREW, PC 6985 AMERICAN MEDICAL TECHNOLOGISTS 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2003-02-14T00:00:00-05:00
203383 BALCH & BINGHAM, LLP 1db391cf-3aab-41d2-a847-a155e5892e18 YT BALCH & BINGHAM, LLP 5197 ALLVIVO INC 2002 year_end MED   HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE 0   0 0 2003-02-14T00:00:00-05:00
203528 CAPITOL ASSOCIATES, INC. bf149181-c5bb-441e-80f1-ad464f47445a YY CAPITOL ASSOCIATES, INC. 8101 NEW YORK UNIVERSITY MEDICAL CENTER 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) 80000   0 0 2003-02-14T00:00:00-05:00
203552 UNIVERSITY OF MICHIGAN 93eee398-e724-4315-ae5e-af6d3a3f04c7 YY UNIVERSITY OF MICHIGAN 39473 UNIVERSITY OF MICHIGAN 2002 year_end MED   Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Centers For Disease Control & Prevention (CDC),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Federal Aviation Administration (FAA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Park Service (NPS),Natl Science Foundation (NSF),Office of Science & Technology Policy (OSTP),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA)   120000 0 0 2003-02-14T00:00:00-05:00
203624 FOLEY & LARDNER LLP 2e2db7dd-6098-47b3-b3f2-b6cac05ba21f YY FOLEY & LARDNER LLP 15042 ENVISION HEALTHCARE (FORMERLY KNOWN AS EMCARE INC.) 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2003-02-14T00:00:00-05:00
203629 WAYNE STATE UNIVERSITY, DETROIT, MICHIGAN 3b23829b-a27f-4bc8-87d0-b6a6972f835e YY WAYNE STATE UNIVERSITY, DETROIT, MICHIGAN 48805 WAYNE STATE UNIVERSITY, DETROIT, MICHIGAN 2002 year_end MED   Bureau of Citizenship & Immigration Services (BCIS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE   120000 0 0 2003-02-14T00:00:00-05:00
203630 CASSIDY & ASSOCIATES, INC. 4a8f89db-47f5-45a5-8446-b79d2bc84a46 YY CASSIDY & ASSOCIATES, INC. 8453 ALCON LABORATORIES 2002 year_end MED   Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2003-02-14T00:00:00-05:00
204038 EVANS CAPITOL GROUP b601b148-f9da-41b9-8eda-186e7e2e7a5a YT EVANS CAPITOL GROUP 13940 AMERICAN RED CROSS 2002 year_end MED     40000   0 0 2003-02-14T00:00:00-05:00
204138 CAPITOL ASSOCIATES, INC. 71bd8485-efd7-47b6-ae33-0c5413c0aa3b YY CAPITOL ASSOCIATES, INC. 8101 NORTHWESTERN MEMORIAL HOSPITAL (NMH) 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE 60000   0 0 2003-02-14T00:00:00-05:00
204152 MEDICAL PROFESSIONAL LIABILITY ASSOCIATION 1f235756-0d83-4f37-8a17-144d353e7363 YY MEDICAL PROFESSIONAL LIABILITY ASSOCIATION 31441 MEDICAL PROFESSIONAL LIABILITY ASSOCIATION 2002 year_end MED   Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office   160000 0 0 2003-02-14T00:00:00-05:00
204201 SQUIRE PATTON BOGGS 825cd4c3-9ad1-4aa3-903c-4b64fec39c04 YY SQUIRE PATTON BOGGS 30906 ORASEE CORP 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2003-02-14T00:00:00-05:00
204293 ERVIN GRAVES STRATEGY GROUP, LLC d3e785f7-fd88-4063-ba6a-9f1936be6ddb YY ERVIN GRAVES STRATEGY GROUP, LLC 13836 VITAL PROBES INC 2002 year_end MED     0   0 0 2003-02-14T00:00:00-05:00
204343 VAN SCOYOC ASSOCIATES ab737a94-be16-4e33-a8b5-5227481b4f2d YY VAN SCOYOC ASSOCIATES 39837 TULANE UNIVERSITY 2002 year_end MED   HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE 60000   0 0 2003-02-14T00:00:00-05:00
204471 VAN SCOYOC ASSOCIATES 970bfe77-33b2-43ba-a962-fb84d4b4e71d YY VAN SCOYOC ASSOCIATES 39837 UNIVERSITY OF ALABAMA SYSTEM 2002 year_end MED   Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),SENATE,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID) 140000   0 0 2003-02-14T00:00:00-05:00
204704 BALCH & BINGHAM, LLP b1583364-3749-4de5-915f-8425a8a21848 YT BALCH & BINGHAM, LLP 5197 EMERGING TECHNOLOGY PARTNERS 2002 year_end MED   Centers For Disease Control & Prevention (CDC),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Navy, Dept of,SENATE,Veterans Affairs, Dept of (VA) 20000   0 0 2003-02-14T00:00:00-05:00
204838 CAPITOL ASSOCIATES, INC. 4ca34e56-8112-4ab1-aa77-dcad9ad365ef YY CAPITOL ASSOCIATES, INC. 8101 JOINT COUNCIL OF ALLERGY ASTHMA & IMMUNOLOGY D/B/A ADVOCACY COUNCIL OF ACAAI 2002 year_end MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE 40000   0 0 2003-02-14T00:00:00-05:00
205008 CAPITOL ASSOCIATES, INC. 28afd127-ace9-4e38-b091-736b24181a03 YY CAPITOL ASSOCIATES, INC. 8101 AMERICAN SOCIETY OF TROPICAL MEDICINE & HYGIENE 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2003-02-14T00:00:00-05:00
205152 LATHAM & WATKINS LLP 7594fcb9-98d3-4cf7-ade1-7100b85dd31b YY LATHAM & WATKINS LLP 22201 BOSTON SCIENTIFIC CORPORATION 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2003-02-14T00:00:00-05:00
205273 THE ADVOCACY GROUP 80c418f6-9f24-493b-867f-3518a150b721 YY THE ADVOCACY GROUP 261 TEXAS CHIROPRACTIC COLLEGE 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2003-02-14T00:00:00-05:00
205395 AMERICAN ASSOCIATION OF COLLEGES OF OSTEOPATHIC MEDICINE b142e47e-4844-4d22-bf6e-e98295701853 YY AMERICAN ASSOCIATION OF COLLEGES OF OSTEOPATHIC MEDICINE 1546 AMERICAN ASSOCIATION OF COLLEGES OF OSTEOPATHIC MEDICINE 2002 year_end MED   Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2003-02-14T00:00:00-05:00
205455 BALCH & BINGHAM, LLP c1f5be50-dd51-471c-801d-68a5615c981d YY BALCH & BINGHAM, LLP 5197 TRANZYME INC 2002 year_end MED   HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) 0   0 0 2003-02-14T00: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);