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

691 rows where 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, income_amount, received_date (date)

filing_period 2

issue_code 1

  • MED · 691 ✖

filing_year 1

  • 2002 · 691 ✖
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
155761 K&L GATES, LLP 5202fc12-4b71-43a4-b826-e07a8905ab35 MT K&L GATES, LLP 32098 BENTON COUNTY SUSTAINABLE DEVELOPMENT DEPT 2002 mid_year MED   Energy, Dept of 0   0 0 2002-04-17T00:00:00-04: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
156001 MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 2e141948-5e96-47ea-bac5-22ea54119e26 MM MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 25498 NEW ENGLAND MEDICAL CENTER 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2002-07-12T00:00:00-04:00
156021 MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 53b0df07-1550-4c7e-9ce5-cdae184b4bd6 MM MINTZ LEVIN COHN FERRIS GLOVSKY AND POPEO, P.C. 25498 MOREHOUSE SCHOOL OF MEDICINE 2002 mid_year MED   Centers For Disease Control & Prevention (CDC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Agency for International Development (USAID),White House Office 40000   0 0 2002-07-12T00:00:00-04:00
156117 FIERCE, ISAKOWITZ & BLALOCK deed796d-cf77-4540-9807-c6cc69c79855 MM FIERCE, ISAKOWITZ & BLALOCK 44812 ACTELION 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-07-15T00:00:00-04:00
156269 COALITION RESOURCES, INC. bbf7f2bc-9e8a-4ea0-acc5-96889fe8a5cc MM COALITION RESOURCES, INC. 69798 CHILDREN'S ENVIRONMENTAL HEALTH NETWORK 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-07-17T00:00:00-04:00
156507 ASSN OF DISPOSABLE DEVICE MANUFACTURERS ec08043d-5454-4af2-b97f-a0ec720dbeef MM ASSN OF DISPOSABLE DEVICE MANUFACTURERS 55278 ASSN OF DISPOSABLE DEVICE MANUFACTURERS 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-07-22T00:00:00-04:00
156645 HALLIBURTON COMPANY 3164508e-32b1-4e00-8ccb-34cc45b7a719 MM HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2002 mid_year 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)   150000 0 0 2002-07-23T00:00:00-04:00
157545 PACQUING CONSULTING, INC. ffbc1db0-f943-4402-85ca-501b21bfbb58 MM PACQUING CONSULTING, INC. 53460 LIVINGSTON GROUP 2002 mid_year MED   Agriculture, Dept of (USDA),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Veterans Affairs, Dept of (VA) 40000   0 0 2002-07-31T00:00:00-04:00
157549 HALE & DORR 9b03fd4a-20f3-4784-bc85-d171cfb9605e MM HALE & DORR 17306 NOVA BIOMEDICAL 2002 mid_year MED Procurement practices. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-07-31T00:00:00-04:00
157608 TRADITIONAL VALUES COALITION 0412c29d-49d7-40c6-9653-53cd2f87b621 MM TRADITIONAL VALUES COALITION 38313 TRADITIONAL VALUES COALITION 2002 mid_year MED HR482/S251 - RU-486 Patient Health and Safety Protection Act: all provisions S1899 – Human Cloning Prohibition Act of 2001: all provisions S2439 - Human Cloning Prohibition Act of 2002: all provisions HR2096 – The Responsible Stem Cell Research Act of 2001: all provisions Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),White House Office   240000 0 0 2002-08-01T00:00:00-04:00
157682 BRISTOL-MYERS SQUIBB COMPANY e6f71b96-23cd-4714-a1a4-c07f65c603b2 MM BRISTOL-MYERS SQUIBB COMPANY 7053 BRISTOL-MYERS SQUIBB COMPANY 2002 mid_year MED   Commerce, Dept of (DOC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)   2480000 0 0 2002-08-01T00:00:00-04:00
157706 AMERICAN SOCIETY FOR MICROBIOLOGY 9ae577a8-e994-476a-b13e-7c9929c21e28 MM AMERICAN SOCIETY FOR MICROBIOLOGY 3355 AMERICAN SOCIETY FOR MICROBIOLOGY 2002 mid_year MED   Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2002-08-01T00:00:00-04:00
157795 K&L GATES, LLP c56b4c5b-70ca-4479-b6b1-309c0148610a MM K&L GATES, LLP 32098 AMERICAN SOCIETY FOR THERAPEUTIC RADIOLOGY & ONCOLOGY 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-02T00:00:00-04:00
158248 BILBRAY, BRIAN P. 59d4d29e-808f-4418-a69a-3cabb39ad915 MM BILBRAY, BRIAN P. 63815 COUNTY OF LOS ANGELES 2002 mid_year MED   Justice, Dept of (DOJ),Navy, Dept of,State, Dept of (DOS),White House Office 40000   0 0 2002-08-05T00:00:00-04:00
158516 RITTER AND BOURJAILY 2fb693a2-a9d5-46e0-83bf-5a98378e91b6 MM RITTER AND BOURJAILY 33374 ONCONOVA 2002 mid_year MED   Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-08-05T00:00:00-04:00
158521 BKSH & ASSOCIATES 4079eaba-92f2-4d83-9118-1506b5d1f119 MM BKSH & ASSOCIATES 6291 GENENTECH 2002 mid_year MED S. 30, Financial Information Privacy Protection Act of 2001; H.R. 2505/S. 2172, cloning of embyros. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-05T00:00:00-04:00
158687 UNIVERSITY OF ILLINOIS c6204d48-1339-4941-b3f1-c236feb17f24 MM UNIVERSITY OF ILLINOIS 39427 UNIVERSITY OF ILLINOIS 2002 mid_year MED   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),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Endowment for the Arts,Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA)   60000 0 0 2002-08-06T00:00:00-04:00
158778 HOGAN LOVELLS US LLP 07587a73-5df0-4702-a666-30fdfc19d2e0 MM HOGAN LOVELLS US LLP 18422 VIACALL 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-06T00:00:00-04:00
158824 NATIONAL KIDNEY FOUNDATION 37346a7b-c762-4514-90c5-5d7b79663e38 MM NATIONAL KIDNEY FOUNDATION 28105 NATIONAL KIDNEY FOUNDATION 2002 mid_year MED   Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE   40000 0 0 2002-08-06T00:00:00-04:00
159143 HALE & DORR 56e9de8e-4158-4975-a804-13fb8acdc57d MM HALE & DORR 17306 MEDICINES COMPANY (THE) 2002 mid_year MED Food and Drug Administration. Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE     0 0 2002-08-07T00:00:00-04:00
159177 AMERICAN INSURANCE ASSN e6525f74-0b66-483e-aed4-28a97b0d0a2e MM AMERICAN INSURANCE ASSN 2662 AMERICAN INSURANCE ASSN 2002 mid_year 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)   1520000 0 0 2002-08-07T00:00:00-04:00
159203 THE LAXALT CORPORATION 7556802c-ee80-4e66-81e4-baea60af2736 MT THE LAXALT CORPORATION 22314 TRIMERIDIAN 2002 mid_year MED     0   0 0 2002-08-07T00:00:00-04:00
159228 MARSHFIELD CLINIC HEALTH SYSTEM e625190d-11b5-48bb-b93c-0714d880bac1 MM MARSHFIELD CLINIC HEALTH SYSTEM 57830 MARSHFIELD CLINIC HEALTH SYSTEM 2002 mid_year 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 Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),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),President of the U.S.,SENATE,White House Office   119489 0 0 2002-08-08T00:00:00-04:00
159715 TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA 809b892d-f0e3-43e9-975f-5da67b7e8341 MM TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA 38608 TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE   120000 0 0 2002-08-08T00:00:00-04:00
159825 PHILIPS HOLDING USA, INC. be34a4b1-3911-418e-a46c-c9c426983d65 MM PHILIPS HOLDING USA, INC. 31417 PHILIPS HOLDING USA INC. 2002 mid_year MED   Energy, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)   80000 0 0 2002-08-08T00:00:00-04:00
160085 NATIONAL STRATEGIES, INC. d5662f33-61e3-4a24-bd0c-f432d91a21b3 MT NATIONAL STRATEGIES, INC. 28652 NATL BRAIN INJURY RESEARCH TREATMENT & TRAINING FOUNDATION 2002 mid_year MED   Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE 0   0 0 2002-08-08T00:00:00-04:00
160142 MS. VIRGINIA AINSLIE 8b219bf1-33cd-4fdd-9ed8-92f9b72c0f6b MM MS. VIRGINIA AINSLIE 534 CLEVELAND CLINIC FOUNDTAION 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-08T00:00:00-04:00
160322 MICHELSON, LAW OFFICE OF STUART R. 0fc5d677-f309-4828-a8b1-458a7aa8d93f MM MICHELSON, LAW OFFICE OF STUART R. 43605 ESRD LABORATORY 2002 mid_year MED   Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES 0   0 0 2002-08-09T00:00:00-04:00
160342 O'NEILL, ATHY & CASEY, P.C. 7b41ef66-e4e7-4449-9aa5-74663cf2b3d2 MM O'NEILL, ATHY & CASEY, P.C. 42752 DES MOINES UNIV - OSTEOPATHIC MEDICAL CENTER 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-08-09T00:00:00-04:00
160407 O'NEILL, ATHY & CASEY, P.C. d498ac5d-8291-47d5-9829-ed9bc1f55213 MM O'NEILL, ATHY & CASEY, P.C. 42752 MASS GENERAL BRIGHAM 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 120000   0 0 2002-08-09T00:00:00-04:00
160511 AMFAR THE FOUNDATION FOR AIDS RESEARCH 82ab89a6-ff44-447a-af6a-29cc40a7a8fb MM AMFAR THE FOUNDATION FOR AIDS RESEARCH 2398 AMFAR THE FOUNDATION FOR AIDS RESEARCH 2002 mid_year MED   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE   100000 0 0 2002-08-09T00:00:00-04:00
160597 MEDICAL PROFESSIONAL LIABILITY ASSOCIATION 8d82f3a8-2ecf-405b-bc73-2d50e321066f MM MEDICAL PROFESSIONAL LIABILITY ASSOCIATION 31441 MEDICAL PROFESSIONAL LIABILITY ASSOCIATION 2002 mid_year 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 2002-08-09T00:00:00-04:00
160846 CLARK & WEINSTOCK 8571a411-09bc-4c1c-9a2a-649a287cb6a3 MT CLARK & WEINSTOCK 9443 EMPI 2002 mid_year MED   Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB) 60000   0 0 2002-08-12T00:00:00-04:00
161088 UNIVERSITY OF WASHINGTON b2a61e97-ff3b-4653-8264-ea8422c5c0c0 MM UNIVERSITY OF WASHINGTON 39553 UNIVERSITY OF WASHINGTON 2002 mid_year MED   Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Executive Office of the President (EOP),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 2002-08-12T00:00:00-04:00
161102 RYAN MACKINNON VASAPOLI AND BERZOK, LLP 03dc6427-e163-4385-9e10-a9e3f767adc3 MM RYAN MACKINNON VASAPOLI AND BERZOK, LLP 30187 MULTIDIMENSIONAL IMAGING INC 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2002-08-12T00:00:00-04:00
161185 CASSIDY & ASSOCIATES, INC. 32b4870a-73be-4d0c-bf72-0710f4c3fa58 MM CASSIDY & ASSOCIATES, INC. 8453 OCEAN SPRAY CRANBERRIES 2002 mid_year MED   Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 200000   0 0 2002-08-12T00:00:00-04:00
161238 GEORGETOWN UNIVERSITY 40dce75a-2cc4-4baa-9af9-e182b90a2e79 MM GEORGETOWN UNIVERSITY 62016 GEORGETOWN UNIVERSITY 2002 mid_year MED   Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Education, Dept of,Federal Transit Administration (FTA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Park Service (NPS),SENATE,White House Office   100000 0 0 2002-08-12T00:00:00-04:00
161302 ZUCKERMAN SPAEDER LLP f0c4a859-a4e0-452c-a5f5-69e6bb1d1eea MM ZUCKERMAN SPAEDER LLP 42160 AMERICAN PSYCHOLOGICAL SOCIETY 2002 mid_year MED Behavioral research Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE     0 0 2002-08-12T00:00:00-04:00
161314 HOGAN LOVELLS US LLP 3e6d9397-ba73-4ef9-9c56-69a39f97b572 MM HOGAN LOVELLS US LLP 18422 AMERICAN REGISTRY OF PATHOLOGY 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-08-12T00:00:00-04:00
161551 KAISER ALUMINUM & CHEMICAL CORP d07569c3-28db-4d5f-ad9c-30521fbb227b MM KAISER ALUMINUM & CHEMICAL CORP 21016 KAISER ALUMINUM & CHEMICAL CORP 2002 mid_year MED   Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) 220000   0 0 2002-08-12T00:00:00-04:00
161654 VERNER LIIPFERT BERNHARD MCPHERSON & HAND 21441a0b-b5ec-4e49-8d66-5b9716d27b02 MT VERNER LIIPFERT BERNHARD MCPHERSON & HAND 39974 MUSCULAR DYSTROPHY ASSN 2002 mid_year MED   Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-08-12T00:00:00-04:00
161676 AMERICAN MEDICAL ASSOCIATION fa688e2c-14de-42b2-b18a-f8b76c50b659 MM AMERICAN MEDICAL ASSOCIATION 2877 AMERICAN MEDICAL ASSOCIATION 2002 mid_year MED   Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Personnel Management (OPM),SENATE   7620000 0 0 2002-08-12T00:00:00-04:00
161685 AMERICAN SOCIETY FOR CLINICAL PATHOLOGY aa3a4e6d-2aed-4db2-baf5-0735b5f3604a MM AMERICAN SOCIETY FOR CLINICAL PATHOLOGY 3435 AMERICAN SOCIETY FOR CLINICAL PATHOLOGY 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   100000 0 0 2002-08-12T00:00:00-04:00
161757 TWENTY-FIRST CENTURY GROUP, INC. a207d46d-a887-4b2d-96e7-1c1035fd7566 MM TWENTY-FIRST CENTURY GROUP, INC. 38687 SBC COMMUNICATIONS 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-13T00:00:00-04:00
161769 TWENTY-FIRST CENTURY GROUP, INC. 8897b057-044c-4c95-9c96-81531e484b1a MM TWENTY-FIRST CENTURY GROUP, INC. 38687 LONGHORN PIPELINE 2002 mid_year MED   Education, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office 20000   0 0 2002-08-13T00:00:00-04:00
161776 TWENTY-FIRST CENTURY GROUP, INC. f7677b09-9507-412e-96e6-7c0e870d01cf MM TWENTY-FIRST CENTURY GROUP, INC. 38687 SIERRA GROUP INC 2002 mid_year MED   Education, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office 0   0 0 2002-08-13T00:00:00-04:00
161787 TWENTY-FIRST CENTURY GROUP, INC. 152ca89c-57c8-49c0-a65a-8eba3e1f3e5c MM TWENTY-FIRST CENTURY GROUP, INC. 38687 VERIZON COMMUNICATIONS INC AND VARIOUS SUBSIDIARIES 2002 mid_year MED   Education, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office 20000   0 0 2002-08-13T00:00:00-04:00
161794 TWENTY-FIRST CENTURY GROUP, INC. 94cb0d01-c6be-451e-a13d-ae9114a17740 MM TWENTY-FIRST CENTURY GROUP, INC. 38687 SCHERING-PLOUGH 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-13T00:00:00-04:00
161807 TWENTY-FIRST CENTURY GROUP, INC. b551f22a-e707-47fd-a833-e6051e4719f5 MM TWENTY-FIRST CENTURY GROUP, INC. 38687 ECHOSTAR COMMUNICATIONS CORP 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) 20000   0 0 2002-08-13T00:00:00-04:00
161893 SQUIRE PATTON BOGGS 27a91272-d0f9-4484-8769-c50202af75d4 MM SQUIRE PATTON BOGGS 30906 NATL STROKE ASSN 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-08-13T00:00:00-04:00
161972 LEGISLATIVE STRATEGIES GROUP 2fd89a52-9a05-40a0-8514-f2774fa80d19 MM LEGISLATIVE STRATEGIES GROUP 43651 CARDINAL HEALTH 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 120000   0 0 2002-08-13T00:00:00-04:00
161998 LEGISLATIVE STRATEGIES GROUP 6a93dce5-61da-4a2e-a714-4a23e4bc2dd4 MM LEGISLATIVE STRATEGIES GROUP 43651 NOVARTIS CORP 2002 mid_year MED   Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-08-13T00:00:00-04:00
162005 PARRY, ROMANI, DECONCINI & SYMMS 09bf895f-1192-47b9-a771-7e7389c58fab MM PARRY, ROMANI, DECONCINI & SYMMS 30792 PFIZER 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2002-08-13T00:00:00-04:00
162010 STRATEGIC MARKETING INNOVATIONS 56132522-462b-4e7e-a78a-0a728dd36b13 MM STRATEGIC MARKETING INNOVATIONS 60550 UNIV OF TEXAS AT DALLAS 2002 mid_year 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 2002-08-13T00:00:00-04:00
162056 ZUCKERMAN SPAEDER LLP 5c153f50-ba1d-45d3-9713-c230b967bf44 MM ZUCKERMAN SPAEDER LLP 42160 BARR LABORATORIES 2002 mid_year MED Intersection between Hatch-Waxman generic exclusivity and pediatric exclusivity. Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-08-13T00:00:00-04:00
162102 TWENTY-FIRST CENTURY GROUP, INC. 42a9727d-e52c-401d-a3a9-99db7ec83c09 MM TWENTY-FIRST CENTURY GROUP, INC. 38687 EMPRESAS ICA 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) 0   0 0 2002-08-13T00:00:00-04:00
162119 TWENTY-FIRST CENTURY GROUP, INC. 903cb5e5-5ce5-4e3a-b5bf-4074537b5789 MTY TWENTY-FIRST CENTURY GROUP, INC. 38687 ELECTRONICS INDUSTRY ALLIANCE/TELECOMMUNICATIONS INDUSTRY ASSN 2002 mid_year MED   Education, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office 0   0 0 2002-08-13T00:00:00-04:00
162137 TWENTY-FIRST CENTURY GROUP, INC. 2745e336-bedd-4504-9c89-d86820ed6111 MM TWENTY-FIRST CENTURY GROUP, INC. 38687 SEFBO PIPELINE BRIDGE INC 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) 0   0 0 2002-08-13T00:00:00-04:00
162142 PARRY, ROMANI, DECONCINI & SYMMS 6132e2ef-6766-4f74-8e36-c0e8c81625d0 MM PARRY, ROMANI, DECONCINI & SYMMS 30792 AIDS HEALTHCARE FOUNDATION 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Agency for International Development (USAID) 60000   0 0 2002-08-13T00:00:00-04:00
162207 PARRY, ROMANI, DECONCINI & SYMMS 379a4a0b-2628-4b1a-9bf9-3eb2c622faae MT PARRY, ROMANI, DECONCINI & SYMMS 30792 CONSUMER HEALTHCARE PRODUCTS ASSN 2002 mid_year MED   Federal Trade Commission (FTC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-08-13T00:00:00-04:00
162232 ARTHRITIS FOUNDATION 6b6974af-cc83-4f6e-aefe-04ff92b127dc MM ARTHRITIS FOUNDATION 4356 ARTHRITIS FOUNDATION 2002 mid_year MED Availability of specialty medical care Increased funding for arthritis research at the National Institutes of Health (NIH). 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),Office of Management & Budget (OMB),SENATE   253000 0 0 2002-08-13T00:00:00-04:00
162248 THE COHEN GROUP 9ed40915-7d55-468a-9853-69ff2a90068c MM THE COHEN GROUP 70370 GENESOFT, INC. 2002 mid_year MED   Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE 50000   0 0 2002-08-13T00:00:00-04:00
162321 CLARK & WEINSTOCK 4d86e67e-5b94-40c8-8bbb-352e2c5f937d MM CLARK & WEINSTOCK 9443 LEADINGAGE 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 100000   0 0 2002-08-13T00:00:00-04:00
162353 CLARK & WEINSTOCK 8ed36de9-b54c-4966-ae06-544dcb8d4a9f MM CLARK & WEINSTOCK 9443 HEALTH NET INC 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2002-08-13T00:00:00-04:00
162367 CLARK & WEINSTOCK 4d444172-b4d4-4c3a-a41d-65fce7af87ef MT CLARK & WEINSTOCK 9443 INTEGIC 2002 mid_year MED   Federal Emergency Management Agency (FEMA),Office of Management & Budget (OMB),Transportation, Dept of (DOT) 40000   0 0 2002-08-13T00:00:00-04:00
162438 CLARK & WEINSTOCK bc2ee6a0-4a43-49aa-8b84-a9d70a739986 MM CLARK & WEINSTOCK 9443 PHRMA 2002 mid_year MED   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 180000   0 0 2002-08-13T00:00:00-04:00
162441 ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 594674d0-1e32-418c-a8dd-7cb0ae360f5b MM ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 57475 US ONCOLOGY 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2002-08-13T00:00:00-04:00
162445 CLARK & WEINSTOCK bc42c63e-d922-4171-8b05-a9da18377163 MM CLARK & WEINSTOCK 9443 GUIDANT CORP 2002 mid_year MED   HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB) 160000   0 0 2002-08-13T00:00:00-04:00
162591 CAPITOL ASSOCIATES, INC. 33aea8ea-995a-4868-99fc-14f048b1d0ea MT CAPITOL ASSOCIATES, INC. 8101 NCCR 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office 0   0 0 2002-08-13T00:00:00-04:00
162660 CAPITOL ASSOCIATES, INC. eee84505-bdac-406b-bca3-2b0ceb625d3b MM CAPITOL ASSOCIATES, INC. 8101 JOINT COUNCIL OF ALLERGY ASTHMA & IMMUNOLOGY D/B/A ADVOCACY COUNCIL OF ACAAI 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE 40000   0 0 2002-08-13T00:00:00-04:00
162667 CAPITOL ASSOCIATES, INC. 43a3c361-5a3f-45ef-a04b-2b36545ef066 MM CAPITOL ASSOCIATES, INC. 8101 JOHNS HOPKINS UNIV 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-13T00:00:00-04:00
162938 BROYDRICK & ASSOCIATES f27d4214-5cf9-49f7-b13a-95b2a3c23525 MM BROYDRICK & ASSOCIATES 7268 SIGMA TAU PHARMACEUTICALS 2002 mid_year MED Orphan Drug Act Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2002-08-13T00:00:00-04:00
162991 CAPITOL ASSOCIATES, INC. 26a1fbf3-6d48-49a9-a241-9f3c42857aa6 MM CAPITOL ASSOCIATES, INC. 8101 UNIV OF PENNSYLVANIA/SCHOOL OF DENTAL MEDICI 2002 mid_year MED   Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) 60000   0 0 2002-08-13T00:00:00-04:00
163050 CAPITOL ASSOCIATES, INC. 10c9629e-7d20-4030-a2a0-c412eec2373f MM CAPITOL ASSOCIATES, INC. 8101 NORTHWESTERN MEMORIAL HOSPITAL (NMH) 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE 60000   0 0 2002-08-13T00:00:00-04:00
163391 FLEISCHMAN AND HARDING LLP d5c96408-1993-46d3-b690-0a11dd7cebed MM FLEISCHMAN AND HARDING LLP 14792 STEMCYTE INC 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-08-13T00:00:00-04:00
163436 FLEISCHMAN AND HARDING LLP acb13b39-1894-459e-b339-421526ee8595 MM FLEISCHMAN AND HARDING LLP 14792 REALNETWORKS INC 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-08-13T00:00:00-04:00
163545 LEGISLATIVE STRATEGIES GROUP c763831b-2481-480e-91bf-e7ef5b67220f MM LEGISLATIVE STRATEGIES GROUP 43651 CHILDREN'S MEDICAL CENTER OF DALLAS 2002 mid_year MED   Centers For Disease Control & Prevention (CDC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office 60000   0 0 2002-08-13T00:00:00-04:00
163565 CARDINAL HEALTH, INC. eb2ade21-ac16-46ba-a527-f78b528be4dd MM CARDINAL HEALTH, INC. 58055 CARDINAL HEALTH INC 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2002-08-13T00:00:00-04:00
163594 UNIVERSITY OF CALIFORNIA 4bf6b134-7c20-4f0f-af4f-0ed77eeede6b MM UNIVERSITY OF CALIFORNIA 39358 UNIVERSITY OF CALIFORNIA 2002 mid_year MED   Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),SENATE   240000 0 0 2002-08-13T00:00:00-04:00
163668 HOGAN LOVELLS US LLP ae66c10c-ce01-4cd5-9ed5-af407a7a69fa MM HOGAN LOVELLS US LLP 18422 EMDEON CORP FORMERLY WEB MD CORP 2002 mid_year MED   Centers For Disease Control & Prevention (CDC),HOUSE OF REPRESENTATIVES,SENATE 120000   0 0 2002-08-13T00:00:00-04:00
163700 CAPITOL ASSOCIATES, INC. 555d4aab-d8d2-4dc1-930b-1be9dc116642 MM CAPITOL ASSOCIATES, INC. 8101 NEW YORK UNIVERSITY MEDICAL CENTER 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) 80000   0 0 2002-08-13T00:00:00-04:00
163722 JOHNS HOPKINS UNIVERSITY 4b367e40-8a08-4671-bd9f-5791b98778a4 MM JOHNS HOPKINS UNIVERSITY 20664 JOHNS HOPKINS UNIVERSITY 2002 mid_year MED Monitored the following human cloning bills:S.1758, Human Cloning Prohibition Act of 2001 (Senator Dianne Feinstein);HR 2172, Cloning Prohibition Act of 2001 (Representative James Greenwood); S.790, Human Cloning Prohibition Act of 2001 (Senator Sam Brownback); S.1893, Human Cloning Ban and Stem Cell Research Protection Act of 2001 (Senator Tom Harkin);S.1899, Human Cloning Prohibition Act of 2001 (Senator Sam Brownback);S.2439, Human Cloning Prohibition Act of 2002 (Senator Arlen Specter);Monitored the following stem cell research bills: HR 2059, Stem Cell Research Act of 2001 (Representative Jim McDermott;S.723, Stem Cell Research Act of 2001 (Senator Arlen Specter);Supported Association of American Universities (AAU) Statement on Human Cloning, adopted by AAU membership on April 23, 2002, and sent to Senate leadership shortly thereafter. Johns Hopkins supported the AAU position which "opposes human reproductive cloning, and supports legislation to ban this practice." The statement continues to "support both basic and applied stem cell research. AAU therefore supports nuclear transplantation to produce stem cells, also known as somatic cell nuclear transfer, as nonreproductive cloning, as therapeutic cloning." Centers For Medicare and Medicaid Services (CMS),Education, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   140000 0 0 2002-08-13T00:00:00-04:00
163748 CAPITOL ASSOCIATES, INC. c72a0292-612b-451a-975c-aabe5edf1030 MM CAPITOL ASSOCIATES, INC. 8101 AMERICAN SOCIETY OF TROPICAL MEDICINE & HYGIENE 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-13T00:00:00-04:00
163773 ARTHRITIS FOUNDATION d84def1c-013c-4498-aead-2c92159e57e3 MM ARTHRITIS FOUNDATION 4356 ARTHRITIS FOUNDATION 2002 mid_year MED Availability of specialty medical care Increased funding for arthritis research at the National Institutes of Health (NIH). 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),Office of Management & Budget (OMB),SENATE   253000 0 0 2002-08-13T00:00:00-04:00
163874 ZUCKERMAN SPAEDER LLP 8f820d4f-2421-4172-9596-0a4c10f16fe8 MM ZUCKERMAN SPAEDER LLP 42160 UNITED STATES PHARMACOPEIA 2002 mid_year MED Medical error legislation; standard-setting activities Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2002-08-13T00:00:00-04:00
163914 LOCKRIDGE, GRINDAL, NAUEN, PLLP 8e4bfb2a-56ce-480a-af23-b5cac80758a9 MM LOCKRIDGE, GRINDAL, NAUEN, PLLP 23053 MINNESOTA EAR HEAD & NECK CLINIC 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-08-13T00:00:00-04:00
163926 CAPITOL ASSOCIATES, INC. 315d27a1-df15-493d-b3f1-086447e5f255 MM CAPITOL ASSOCIATES, INC. 8101 NATL ALLIANCE FOR EYE & VISION RESEARCH 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2002-08-13T00:00:00-04:00
163976 CAPITOL ASSOCIATES, INC. 84a6c9f4-cada-4718-9fc0-47e42efe12af MT CAPITOL ASSOCIATES, INC. 8101 HUTCHINSON CANCER RESEARCH CENTER FRED 2002 mid_year MED   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE 20000   0 0 2002-08-13T00:00:00-04:00
164068 ASSOCIATION OF AMERICAN MEDICAL COLLEGES 3e647cb8-346e-44f0-beec-77724f62d91d MM ASSOCIATION OF AMERICAN MEDICAL COLLEGES 4493 ASSOCIATION OF AMERICAN MEDICAL COLLEGES 2002 mid_year 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   260000 0 0 2002-08-13T00:00:00-04:00
164171 BENNETT TURNER & COLEMAN LLP a11666bf-7aa4-4538-8a03-d31bb24eedee MT BENNETT TURNER & COLEMAN LLP 53298 LYMPHOMA RESEARCH FOUNDATION 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-08-14T00:00:00-04:00
164271 MEYERS AND ASSOCIATES 9b6311ee-0d5b-41f1-91d9-e9554b7bf121 MM MEYERS AND ASSOCIATES 25077 TEXAS A&M RESEARCH FOUNDATION 2002 mid_year MED   Agriculture, Dept of (USDA),Bureau of Reclamation,Defense, Dept of (DOD),Environmental Protection Agency (EPA),Federal Aviation Administration (FAA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE 80000   0 0 2002-08-14T00:00:00-04:00
164296 VAN SCOYOC ASSOCIATES f7efb61e-505a-44fc-88f7-eb884717bb9d MM VAN SCOYOC ASSOCIATES 39837 MEMPHIS-SHELBY COUNTY AIRPORT AUTHORITY 2002 mid_year MED   Agriculture, Dept of (USDA),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Executive Office of the President (EOP),Federal Aviation Administration (FAA),General Services Administration (GSA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),U.S. Customs & Border Protection 60000   0 0 2002-08-14T00:00:00-04:00
164404 AMERICAN COLLEGE OF OBSTETRICIANS & GYNECOLOGISTS 4f2d63e9-2e2b-4020-99da-2715684822bc MM AMERICAN COLLEGE OF OBSTETRICIANS & GYNECOLOGISTS 1991 AMERICAN COLLEGE OF OBSTETRICIANS & GYNECOLOGISTS 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2002-08-14T00:00:00-04:00
164462 THE WASHINGTON GROUP 91c388a9-dc67-464c-be4c-5a83be1f459e MM THE WASHINGTON GROUP 40555 INTEGRATED SOLUTIONS GROUP ON BEHALF OF BOSTON MEDICAL CENTER 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2002-08-14T00:00:00-04:00
164473 JORDEN BURT LLP 4ce7a9d2-2a04-4333-8039-686e51c1153c MM JORDEN BURT LLP 43398 BARRY UNIVERSITY 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-08-14T00:00:00-04:00
164525 UNIVERSITY OF WISCONSIN-MADISON ab20957a-bb90-4d48-a885-79ce1274a9ad MM UNIVERSITY OF WISCONSIN-MADISON 39564 UNIVERSITY OF WISCONSIN-MADISON 2002 mid_year MED   HOUSE OF REPRESENTATIVES,SENATE   60000 0 0 2002-08-14T00:00:00-04:00
164574 EVERGREEN ASSOCIATES, LTD. 48989562-0fc7-4786-a8f2-a35ca3f9de10 MM EVERGREEN ASSOCIATES, LTD. 13984 AMERICAN OCCUPATIONAL THERAPY ASSOCIATION 2002 mid_year MED HEALTH CARE POLICY HOUSE OF REPRESENTATIVES,SENATE     0 0 2002-08-14T00:00:00-04:00
164638 VAN SCOYOC ASSOCIATES 1f552350-cd8f-41c5-bab7-30711b1dba9b MM VAN SCOYOC ASSOCIATES 39837 DALLAS AREA RAPID TRANSIT (DART) 2002 mid_year MED   Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of 100000   0 0 2002-08-14T00:00:00-04: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);