lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
33,992 rows where filing_period = "mid_year" and filing_year = 2004 sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: filing_type, is_termination, received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 287868 | JIM PASCO AND ASSOCIATES 659cb694-c511-4dcf-9b49-3077b4ff2ed9 | MM | JIM PASCO AND ASSOCIATES | 30837 | NATL AIR CARGO | 2004 | mid_year | 19500 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||||
| 287869 | CLS STRATEGIES (FORMERLY CHLOPAK, LEONARD, SCHECHTER AND ASSOCIATES, INC.) 3acc6090-b936-4222-880b-940c86a60b7d | MT | CLS STRATEGIES (FORMERLY CHLOPAK, LEONARD, SCHECHTER AND ASSOCIATES, INC.) | 9090 | TRANSPORTADORA DE GAS DEL PERU (TGP) | 2004 | mid_year | FOR | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287870 | CLS STRATEGIES (FORMERLY CHLOPAK, LEONARD, SCHECHTER AND ASSOCIATES, INC.) 3acc6090-b936-4222-880b-940c86a60b7d | MT | CLS STRATEGIES (FORMERLY CHLOPAK, LEONARD, SCHECHTER AND ASSOCIATES, INC.) | 9090 | TRANSPORTADORA DE GAS DEL PERU (TGP) | 2004 | mid_year | ENV | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287871 | CLS STRATEGIES (FORMERLY CHLOPAK, LEONARD, SCHECHTER AND ASSOCIATES, INC.) 3acc6090-b936-4222-880b-940c86a60b7d | MT | CLS STRATEGIES (FORMERLY CHLOPAK, LEONARD, SCHECHTER AND ASSOCIATES, INC.) | 9090 | TRANSPORTADORA DE GAS DEL PERU (TGP) | 2004 | mid_year | FUE | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287872 | GARDNER CARTON & DOUGLAS b95f9f1f-8a55-4764-94dd-c85eea6694c5 | MM | GARDNER CARTON & DOUGLAS | 15805 | SOCIETY OF NUCLEAR MEDICINE | 2004 | mid_year | HCR | Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287873 | GARDNER CARTON & DOUGLAS b95f9f1f-8a55-4764-94dd-c85eea6694c5 | MM | GARDNER CARTON & DOUGLAS | 15805 | SOCIETY OF NUCLEAR MEDICINE | 2004 | mid_year | ENG | Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287874 | JIM PASCO AND ASSOCIATES 20d0d273-8c62-4f8f-ae70-914ddb210818 | MM | JIM PASCO AND ASSOCIATES | 30837 | MILLERCOORS LLC | 2004 | mid_year | ALC | Bureau of Alcohol Tobacco Firearms & Explosives,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 75000 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287875 | GARDNER CARTON & DOUGLAS 0bd007a9-bcb6-4481-963c-d68d3b704f32 | MM | GARDNER CARTON & DOUGLAS | 15805 | SPINA BIFIDA ASSN OF AMERICA | 2004 | mid_year | HCR | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287876 | JIM PASCO AND ASSOCIATES 3b9d1711-c415-43f0-b620-ddc533e84026 | MM | JIM PASCO AND ASSOCIATES | 30837 | SONY BMG MUSIC ENTERTAINMENT INC | 2004 | mid_year | CPT | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,White House Office | 125000 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287877 | ASSN OF PROGRESSIVE RENTAL ORGANIZATIONS c67850ca-3403-4331-b40e-f36aad9c4c24 | MM | ASSN OF PROGRESSIVE RENTAL ORGANIZATIONS | 4697 | ASSN OF PROGRESSIVE RENTAL ORGANIZATIONS | 2004 | mid_year | BAN | HOUSE OF REPRESENTATIVES,SENATE | 180000 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287878 | CLS STRATEGIES (FORMERLY CHLOPAK, LEONARD, SCHECHTER AND ASSOCIATES, INC.) e428adff-d576-4b2b-b44b-62220a027ba6 | MM | CLS STRATEGIES (FORMERLY CHLOPAK, LEONARD, SCHECHTER AND ASSOCIATES, INC.) | 9090 | GENWORTH FINANCIAL | 2004 | mid_year | HOU | HOUSE OF REPRESENTATIVES,SENATE | 180000 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287879 | JIM PASCO AND ASSOCIATES 005a5cec-1a67-4b4c-86f0-e6543f960e21 | MM | JIM PASCO AND ASSOCIATES | 30837 | USA-ID | 2004 | mid_year | HOM | Homeland Security, Dept of (DHS) | 22500 | 0 | 0 | 2001-08-24T00:00:00-04:00 | ||
| 287880 | WORLDSPACE 9d9b8447-32d0-4789-a00c-25333ff3364a | MMY | WORLDSPACE | 41875 | WORLDSPACE | 2004 | mid_year | 0 | 0 | 0 | 2002-06-02T00:00:00-04:00 | ||||
| 287881 | CTB GOVERNMENT RELATIONS 7cd859eb-15d4-4e3d-bcb5-a7db53bbd544 | MTY | CTB GOVERNMENT RELATIONS | 52743 | ENTERPRISE INFORMATION SOLUTIONS | 2004 | mid_year | 0 | 0 | 0 | 2003-03-18T00:00:00-05:00 | ||||
| 287882 | BOND & COMPANY 640f78a3-4ad6-45d2-a328-8136ffe1ba0d | MTY | BOND & COMPANY | 6677 | SERVICE EMPLOYEES INTL UNION | 2004 | mid_year | 0 | 0 | 0 | 2003-04-01T00:00:00-05:00 | ||||
| 287883 | NOVARTIS f4f35ad5-4bf7-44b7-89cf-ae781939abe9 | MM | NOVARTIS | 9204 | NOVARTIS | 2004 | mid_year | TRD | S970/HR1769, Job Protection Act of 2003 Economic Sanction SRM Ban/BSE China/World Trade Organization Fast Track Negotiating Authority Capital Market Sanctions Chile and Singapore FTAs | HOUSE OF REPRESENTATIVES,SENATE | 1479577 | 0 | 0 | 2003-08-12T00:00:00-04:00 | |
| 287884 | NOVARTIS f4f35ad5-4bf7-44b7-89cf-ae781939abe9 | MM | NOVARTIS | 9204 | NOVARTIS | 2004 | mid_year | CPT | S.1225, Greater Access to Affordable Pharmaceuticals Act | HOUSE OF REPRESENTATIVES,SENATE | 1479577 | 0 | 0 | 2003-08-12T00:00:00-04:00 | |
| 287885 | NOVARTIS f4f35ad5-4bf7-44b7-89cf-ae781939abe9 | MM | NOVARTIS | 9204 | NOVARTIS | 2004 | mid_year | HCR | H.R.2218, Regulation of non corrective contact lens as medical devices S.1, Prescription Drug and Medicare Improvement Act of 2003 H.R.1, Medicare Prescription Drug Modernization Act of 2003 H.R.2427, Pharmaceutical Market Access Act of 2003 HR1288/S1037, Access to Cancer Therapies Act of 2003 S178, Comprehensive Immunosuppressive Drug Coverage for Transplant Patients Act of 2003 S191/HR2223, Immunosuppressive Drug Coverage Act of 2003 HR588, Medicare Fairness for Organ Transplant Recipients Act of 2003 HR2356, Prescription Drug Comparative Effectiveness Act of 2003 S.650/HR2857, Pediatric Research Equity Act of 2003 HR2769, Save our Seniors Act of 2003 HR2427 Pharmaceutical Market Access Act of 2003 HR1170, Child Medication Safety Act of 2003 Medicare Prescription Drugs Breaux/Thomas Medicare Reform Plan Health Insurance Portability and Accessibility Act FDA Modernization Act Medical Records Privacy – Senators Jeffords, Bennett, Leahy, Kennedy Bills Prospective Payment System Gene Therapy Drug Reimportation Medicare Reform Agriculture appropriation 2001 – Drug Reimportation Agriculture appropriation 2001 (FDA funding) Stem Cell Research Pediatric Exclusivity Direct-to-Consumer Advertising The Bipartisan Medicare Prescription Drug Act of 2001 (Sen. Kennedy-Draft Bill) | HOUSE OF REPRESENTATIVES,SENATE | 1479577 | 0 | 0 | 2003-08-12T00:00:00-04:00 | |
| 287886 | NOVARTIS f4f35ad5-4bf7-44b7-89cf-ae781939abe9 | MM | NOVARTIS | 9204 | NOVARTIS | 2004 | mid_year | MMM | H.R.2218, Regulation of non corrective contact lens as medical devices S.1, Prescription Drug and Medicare Improvement Act of 2003 H.R.1, Medicare Prescription Drug Modernization Act of 2003 H.R.2427, Pharmaceutical Market Access Act of 2003 HR1288/S1037, Access to Cancer Therapies Act of 2003 S178, Comprehensive Immunosuppressive Drug Coverage for Transplant Patients Act of 2003 S191/HR2223, Immunosuppressive Drug Coverage Act of 2003 HR588, Medicare Fairness for Organ Transplant Recipients Act of 2003 HR2356, Prescription Drug Comparative Effectiveness Act of 2003 S.650, Pediatric Research Equity Act of 2003 HR2769, Save our Seniors Act of 2003 HR2427 Pharmaceutical Market Access Act of 2003 HR2857, Pediatric Research Equity Act of 2003 HR1170, Child Medication Safety Act of 2003 Medicare Prescription Drugs & Modfernization Act The Bipartisan Medicare Prescription Drug Act of 2001 (Sen. Kennedy-Draft Bill) Prospective Payment System Medicare Reform | HOUSE OF REPRESENTATIVES,SENATE | 1479577 | 0 | 0 | 2003-08-12T00:00:00-04:00 | |
| 287909 | ZERO PROSTATE CANCER 6e3b3b6c-51c1-442d-a937-33756d64bd14 | MM | ZERO PROSTATE CANCER | 28388 | ZERO PROSTATE CANCER | 2004 | mid_year | MMM | Medicare/Medicaid: Cancer and Prostate Cancer | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287910 | ZERO PROSTATE CANCER 6e3b3b6c-51c1-442d-a937-33756d64bd14 | MM | ZERO PROSTATE CANCER | 28388 | ZERO PROSTATE CANCER | 2004 | mid_year | BUD | Appropriations: Cancer Research, Prostate Cancer Research | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,Veterans Affairs, Dept of (VA) | 40000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287911 | MADISON ASSOCIATES, LLC f2d8f790-0e72-409f-871f-8d7ee5800bd6 | MM | MADISON ASSOCIATES, LLC | 70392 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS ON BEHALF OF APA'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 20000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287912 | MADISON ASSOCIATES, LLC ac79bd71-4894-4243-8f77-bdb6b7ad8546 | MT | MADISON ASSOCIATES, LLC | 70392 | AMERICAN FOUNDATION FOR THE BLIND | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF AFB'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287913 | MADISON ASSOCIATES, LLC da93b819-3551-4eee-8fee-c33926ee178f | MM | MADISON ASSOCIATES, LLC | 70392 | ASSOCIATION FOR PSYCHOLOGICAL SCIENCE | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS ON BEHALF OF APS' PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 20000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287914 | MADISON ASSOCIATES, LLC 0eb182e4-d809-4186-afd7-a8c89fc6c7ae | MM | MADISON ASSOCIATES, LLC | 70392 | SOUTHEASTERN UNIVERSITIES RESEARCH ASSOCIATION | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF SURA'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287915 | MADISON ASSOCIATES, LLC a540e658-caed-4bbc-8d2d-ab695a43a8c5 | MM | MADISON ASSOCIATES, LLC | 70392 | ALLIANT INTERNATIONAL UNIVERSITY | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF ALLIANT'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287916 | MADISON ASSOCIATES, LLC 21fcbf75-4417-431c-82e7-c4815f345252 | MT | MADISON ASSOCIATES, LLC | 70392 | UNION COLLEGE | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF UNION'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287917 | MADISON ASSOCIATES, LLC eaedd8fc-40d3-423d-8889-fb5e59c8a9f3 | MT | MADISON ASSOCIATES, LLC | 70392 | AMERICAN FOUNDATION FOR THE BLIND | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF AFB'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287918 | MADISON ASSOCIATES, LLC 5f4ed2d2-eae4-4ed9-b102-cf58d9fd6400 | MM | MADISON ASSOCIATES, LLC | 70392 | LAWTON AND RHEA CHILES CENTER FOR HEALTHY MOTHERS AND BABIES | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF THE CHILES CENTER'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2004-01-21T00:00:00-05:00 | ||
| 287919 | MADISON ASSOCIATES, LLC 010d14b3-9e1b-487d-a46b-5d4bc5a200ec | MM | MADISON ASSOCIATES, LLC | 70392 | UNIVERSITY OF FLORIDA | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF UF PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,SENATE | 140000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287920 | MADISON ASSOCIATES, LLC 955642c2-6d3b-49b2-aa95-6133f1cf640d | MM | MADISON ASSOCIATES, LLC | 70392 | AMERICAN LIVER FOUNDATION | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF ALF'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 60000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287921 | MADISON ASSOCIATES, LLC 5ec29351-82cf-4352-946b-860a4c692358 | MM | MADISON ASSOCIATES, LLC | 70392 | JOHNSON & JOHNSON | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF J&J'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 60000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287922 | MADISON ASSOCIATES, LLC 2d965c09-51a1-4a89-bb18-4c4bd854d5d6 | MM | MADISON ASSOCIATES, LLC | 70392 | AMERICAN OCCUPATIONAL THERAPY ASSOCIATION | 2004 | mid_year | BUD | POLICY AND APPROPRIATIONS IN SUPPORT OF AOTA'S PROGRAM INTERESTS. | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2004-01-21T00:00:00-05:00 | |
| 287923 | TAYLOR GRAVOIS ASSOC 0c2c1a08-541e-4dc9-966d-6572eb52ed0b | MTY | TAYLOR GRAVOIS ASSOC | 59570 | CABLEWORKS INC | 2004 | mid_year | 0 | 0 | 0 | 2004-01-26T00:00:00-05:00 | ||||
| 287924 | BERNIE ROBINSON 7a2ed441-9b0c-4e5c-bcf2-9a58d8cd7068 | MT | BERNIE ROBINSON | 88553 | LIVINGSTON GROUP (LA CO METROPOLITAN TRANSPORTATION AUTHORITY) | 2004 | mid_year | TRA | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 0 | 0 | 2004-01-29T00:00:00-05:00 | ||
| 287925 | BERNIE ROBINSON 7a2ed441-9b0c-4e5c-bcf2-9a58d8cd7068 | MT | BERNIE ROBINSON | 88553 | LIVINGSTON GROUP (LA CO METROPOLITAN TRANSPORTATION AUTHORITY) | 2004 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 0 | 0 | 2004-01-29T00:00:00-05:00 | ||
| 287926 | CONGRESSIONAL CONSULTANTS a74074df-1169-4ff8-9878-39330ac80f43 | MTY | CONGRESSIONAL CONSULTANTS | 10456 | RENAL LEADERSHIP COUNCIL | 2004 | mid_year | 0 | 0 | 0 | 2004-01-30T00:00:00-05:00 | ||||
| 287927 | CONGRESSIONAL CONSULTANTS 0e83c731-973f-48a8-96ac-32fe0b2f3f17 | MTY | CONGRESSIONAL CONSULTANTS | 10456 | NATL RENAL ADMINISTRATORS ASSN | 2004 | mid_year | 0 | 0 | 0 | 2004-01-30T00:00:00-05:00 | ||||
| 287928 | AMERICAN ACADEMY OF OPHTHALMOLOGY 202c3c27-6e4b-4d66-a955-1465263aac6b | MM | AMERICAN ACADEMY OF OPHTHALMOLOGY | 1364 | AMERICAN ACADEMY OF OPHTHALMOLOGY | 2004 | mid_year | HCR | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) | 980000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287929 | GARDNER CARTON & DOUGLAS 4e25f0fe-7f1b-4323-b885-5c7f725b64eb | MMY | GARDNER CARTON & DOUGLAS | 15805 | FAUNUS GROUP INTL | 2004 | mid_year | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||||
| 287930 | VOLVO GROUP NORTH AMERICA, LLC 6ae41697-b938-4929-a24f-70e38f541584 | MM | VOLVO GROUP NORTH AMERICA, LLC | 81613 | VOLVO GROUP NORTH AMERICA LLC | 2004 | mid_year | TRA | Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Customs & Border Protection | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287931 | VOLVO GROUP NORTH AMERICA, LLC 6ae41697-b938-4929-a24f-70e38f541584 | MM | VOLVO GROUP NORTH AMERICA, LLC | 81613 | VOLVO GROUP NORTH AMERICA LLC | 2004 | mid_year | AUT | Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Customs & Border Protection | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287932 | VOLVO GROUP NORTH AMERICA, LLC 6ae41697-b938-4929-a24f-70e38f541584 | MM | VOLVO GROUP NORTH AMERICA, LLC | 81613 | VOLVO GROUP NORTH AMERICA LLC | 2004 | mid_year | TAX | Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Customs & Border Protection | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287933 | VOLVO GROUP NORTH AMERICA, LLC 6ae41697-b938-4929-a24f-70e38f541584 | MM | VOLVO GROUP NORTH AMERICA, LLC | 81613 | VOLVO GROUP NORTH AMERICA LLC | 2004 | mid_year | ENV | Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Customs & Border Protection | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287934 | ADVANCED CAPITOL CONSULTING cd944fe8-3f71-4335-bdd3-771fb7608d6e | MM | ADVANCED CAPITOL CONSULTING | 287350 | AMERICAN COLLEGE OF SPORTS MEDICINE | 2004 | mid_year | HCR | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287935 | ADVANCED CAPITOL CONSULTING cd944fe8-3f71-4335-bdd3-771fb7608d6e | MM | ADVANCED CAPITOL CONSULTING | 287350 | AMERICAN COLLEGE OF SPORTS MEDICINE | 2004 | mid_year | BUD | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287936 | ADVANCED CAPITOL CONSULTING cd944fe8-3f71-4335-bdd3-771fb7608d6e | MM | ADVANCED CAPITOL CONSULTING | 287350 | AMERICAN COLLEGE OF SPORTS MEDICINE | 2004 | mid_year | SPO | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287937 | ADVANCED CAPITOL CONSULTING cd944fe8-3f71-4335-bdd3-771fb7608d6e | MM | ADVANCED CAPITOL CONSULTING | 287350 | AMERICAN COLLEGE OF SPORTS MEDICINE | 2004 | mid_year | MED | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287938 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | TOR | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287939 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | HCR | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287940 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287941 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | INS | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287942 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | ENG | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287943 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | RRR | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287944 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | TRA | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287945 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | TAX | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287946 | UNION PACIFIC CORPORATION c1f1cc8a-98c5-4f99-945a-7b9f0d5df8ae | MM | UNION PACIFIC CORPORATION | 38995 | UNION PACIFIC CORPORATION | 2004 | mid_year | LBR | HOUSE OF REPRESENTATIVES,SENATE,Surface Transportation Board (STB) | 1733702 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287947 | ADVANCED CAPITOL CONSULTING 327c4594-7d02-4be6-9012-aae8bf997ece | MM | ADVANCED CAPITOL CONSULTING | 287350 | SANTA CRUZ WATER AND POWER DISTRICTS ASSOCIATION | 2004 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287948 | ADVANCED CAPITOL CONSULTING 327c4594-7d02-4be6-9012-aae8bf997ece | MM | ADVANCED CAPITOL CONSULTING | 287350 | SANTA CRUZ WATER AND POWER DISTRICTS ASSOCIATION | 2004 | mid_year | ENG | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287949 | THE OHIO STATE UNIVERSITY 7c0b1085-7dce-451a-b174-bee39c5f4af5 | MM | THE OHIO STATE UNIVERSITY | 30110 | THE OHIO STATE UNIVERSITY | 2004 | mid_year | EDU | HOUSE OF REPRESENTATIVES,SENATE | 65000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287950 | THE OHIO STATE UNIVERSITY 7c0b1085-7dce-451a-b174-bee39c5f4af5 | MM | THE OHIO STATE UNIVERSITY | 30110 | THE OHIO STATE UNIVERSITY | 2004 | mid_year | HOM | HOUSE OF REPRESENTATIVES,SENATE | 65000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287951 | THE OHIO STATE UNIVERSITY 7c0b1085-7dce-451a-b174-bee39c5f4af5 | MM | THE OHIO STATE UNIVERSITY | 30110 | THE OHIO STATE UNIVERSITY | 2004 | mid_year | SCI | HOUSE OF REPRESENTATIVES,SENATE | 65000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287952 | THE OHIO STATE UNIVERSITY 7c0b1085-7dce-451a-b174-bee39c5f4af5 | MM | THE OHIO STATE UNIVERSITY | 30110 | THE OHIO STATE UNIVERSITY | 2004 | mid_year | TAX | HOUSE OF REPRESENTATIVES,SENATE | 65000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287953 | THE OHIO STATE UNIVERSITY 7c0b1085-7dce-451a-b174-bee39c5f4af5 | MM | THE OHIO STATE UNIVERSITY | 30110 | THE OHIO STATE UNIVERSITY | 2004 | mid_year | TEC | HOUSE OF REPRESENTATIVES,SENATE | 65000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287954 | THE OHIO STATE UNIVERSITY 7c0b1085-7dce-451a-b174-bee39c5f4af5 | MM | THE OHIO STATE UNIVERSITY | 30110 | THE OHIO STATE UNIVERSITY | 2004 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 65000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287955 | GARDNER CARTON & DOUGLAS 1ac349ea-84fe-4350-ae45-d37a4de9a2f8 | MM | GARDNER CARTON & DOUGLAS | 15805 | ZIMMER HOLDINGS | 2004 | mid_year | HCR | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287956 | GARDNER CARTON & DOUGLAS 1ac349ea-84fe-4350-ae45-d37a4de9a2f8 | MM | GARDNER CARTON & DOUGLAS | 15805 | ZIMMER HOLDINGS | 2004 | mid_year | CSP | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287957 | KYROS & CUMMINS ASSOCIATES 515343b0-18ba-441d-a10f-f1c8d37df3b3 | MM | KYROS & CUMMINS ASSOCIATES | 21984 | JOINT STEERING COMMITTEE FOR PUBLIC POLICY | 2004 | mid_year | SCI | Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE | 40000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287958 | KYROS & CUMMINS ASSOCIATES 21391115-258a-43c9-9a2c-b62d4e22ae52 | MM | KYROS & CUMMINS ASSOCIATES | 21984 | MERIT SYSTEMS PROTECTION BOARD PROFESSIONAL ASSOCIATION | 2004 | mid_year | GOV | HOUSE OF REPRESENTATIVES,Merit Systems Protection Board,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287959 | KYROS & CUMMINS ASSOCIATES cf215f44-9329-40a5-8580-707a47294d35 | MM | KYROS & CUMMINS ASSOCIATES | 21984 | ASSOCIATION OF ADMINISTRATIVE LAW JUDGES | 2004 | mid_year | GOV | Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,Social Security Administration (SSA) | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287960 | DOMINION ENERGY, INC. 0df1fbb1-96a6-465b-ab29-a7b17795a78f | MM | DOMINION ENERGY, INC. | 45004 | DOMINION ENERGY INC | 2004 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 260000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287961 | DOMINION ENERGY, INC. 0df1fbb1-96a6-465b-ab29-a7b17795a78f | MM | DOMINION ENERGY, INC. | 45004 | DOMINION ENERGY INC | 2004 | mid_year | ENV | HOUSE OF REPRESENTATIVES,SENATE | 260000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287962 | DOMINION ENERGY, INC. 0df1fbb1-96a6-465b-ab29-a7b17795a78f | MM | DOMINION ENERGY, INC. | 45004 | DOMINION ENERGY INC | 2004 | mid_year | TAX | HOUSE OF REPRESENTATIVES,SENATE | 260000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287963 | DOMINION ENERGY, INC. 0df1fbb1-96a6-465b-ab29-a7b17795a78f | MM | DOMINION ENERGY, INC. | 45004 | DOMINION ENERGY INC | 2004 | mid_year | ENG | HOUSE OF REPRESENTATIVES,SENATE | 260000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287964 | DOMINION ENERGY, INC. 0df1fbb1-96a6-465b-ab29-a7b17795a78f | MM | DOMINION ENERGY, INC. | 45004 | DOMINION ENERGY INC | 2004 | mid_year | NAT | HOUSE OF REPRESENTATIVES,SENATE | 260000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287965 | ADVANCED CAPITOL CONSULTING 78affe82-501e-411b-848f-3f4a69f4df27 | MM | ADVANCED CAPITOL CONSULTING | 287350 | MECHANIX WEAR INC | 2004 | mid_year | TRD | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287966 | ADVANCED CAPITOL CONSULTING 78affe82-501e-411b-848f-3f4a69f4df27 | MM | ADVANCED CAPITOL CONSULTING | 287350 | MECHANIX WEAR INC | 2004 | mid_year | TAX | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287967 | GARDNER CARTON & DOUGLAS 8309a77b-8a7b-4f97-a5fe-6826d1fc9115 | MM | GARDNER CARTON & DOUGLAS | 15805 | SIOUX VALLEY HOSPITALS & HEALTH SYSTEM | 2004 | mid_year | TAX | HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287968 | GARDNER CARTON & DOUGLAS 8309a77b-8a7b-4f97-a5fe-6826d1fc9115 | MM | GARDNER CARTON & DOUGLAS | 15805 | SIOUX VALLEY HOSPITALS & HEALTH SYSTEM | 2004 | mid_year | HCR | HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287969 | KYROS & CUMMINS ASSOCIATES 06e50733-94ee-4a31-88c2-0c6ac8e8be14 | MM | KYROS & CUMMINS ASSOCIATES | 21984 | DEFENSE ADMINISTRATIVE JUDGES PROFESSIONAL ASSOCIATION | 2004 | mid_year | GOV | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287970 | LYONS AND COMPANY de478fed-f583-467f-bcaf-a7cb44be8d54 | MM | LYONS AND COMPANY | 23372 | CLARIANT CORP | 2004 | mid_year | TRA | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. International Trade Commission (ITC) | 80000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287971 | LYONS AND COMPANY de478fed-f583-467f-bcaf-a7cb44be8d54 | MM | LYONS AND COMPANY | 23372 | CLARIANT CORP | 2004 | mid_year | ENV | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. International Trade Commission (ITC) | 80000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287972 | KYROS & CUMMINS ASSOCIATES 63e2b1cd-2a81-4a60-b2e3-0706d826fdad | MM | KYROS & CUMMINS ASSOCIATES | 21984 | BOARD OF VETERANS APPEALS PROFESSIONAL ASSOCIATION | 2004 | mid_year | GOV | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287973 | KYROS & CUMMINS ASSOCIATES 3817f10d-acaf-4392-bbb2-46a2894134dc | MM | KYROS & CUMMINS ASSOCIATES | 21984 | ALLSUP INC | 2004 | mid_year | INS | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Social Security Administration (SSA) | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287974 | KYROS & CUMMINS ASSOCIATES 7dd7e728-c8fa-4b5f-852c-b4cd15c8a65f | MM | KYROS & CUMMINS ASSOCIATES | 21984 | COOPERATIVE OF AMERICAN PHYSICIANS | 2004 | mid_year | INS | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287975 | PACIFIC NORTHWEST WATERWAYS ASSOCIATION (PNWA) ca4a31b0-a51b-4a5a-885b-8d38328addb6 | MM | PACIFIC NORTHWEST WATERWAYS ASSOCIATION (PNWA) | 30564 | PACIFIC NORTHWEST WATERWAYS ASSOCIATION | 2004 | mid_year | TRA | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Maritime Administration (MARAD),SENATE | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287976 | PACIFIC NORTHWEST WATERWAYS ASSOCIATION (PNWA) ca4a31b0-a51b-4a5a-885b-8d38328addb6 | MM | PACIFIC NORTHWEST WATERWAYS ASSOCIATION (PNWA) | 30564 | PACIFIC NORTHWEST WATERWAYS ASSOCIATION | 2004 | mid_year | MAR | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Maritime Administration (MARAD),SENATE | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 287977 | PACIFIC NORTHWEST WATERWAYS ASSOCIATION (PNWA) ca4a31b0-a51b-4a5a-885b-8d38328addb6 | MM | PACIFIC NORTHWEST WATERWAYS ASSOCIATION (PNWA) | 30564 | PACIFIC NORTHWEST WATERWAYS ASSOCIATION | 2004 | mid_year | BUD | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,Maritime Administration (MARAD),SENATE | 20000 | 0 | 0 | 2004-02-02T00:00:00-05:00 | ||
| 288186 | MR. STEVEN ELMENDORF 297b7e32-c7ac-4ef0-adbc-e94af1abd2d8 | MT | MR. STEVEN ELMENDORF | 82818 | FANNIE MAE | 2004 | mid_year | HOU | HOUSE OF REPRESENTATIVES | 0 | 0 | 0 | 2004-02-13T00:00:00-05:00 | ||
| 288187 | VENABLE LLP e292aba6-33d4-426c-9748-439c8046391e | MTY | VENABLE LLP | 39941 | CALIFORNIA POLLUTION CONTROL FINANCING AUTHORITY | 2004 | mid_year | 0 | 0 | 0 | 2004-02-13T00:00:00-05:00 | ||||
| 288188 | POTOMAC COUNSEL, LLC 6e43fd70-35d2-4a95-b90c-6c9b18246c8d | MT | POTOMAC COUNSEL, LLC | 79791 | MCI | 2004 | mid_year | BNK | GSA contracting and S. 1331, tax-treatment of consolidated returns. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2004-02-13T00:00:00-05:00 | |
| 288189 | POTOMAC COUNSEL, LLC 6e43fd70-35d2-4a95-b90c-6c9b18246c8d | MT | POTOMAC COUNSEL, LLC | 79791 | MCI | 2004 | mid_year | GOV | GSA Contracting and S. 1331, tax-treatment of consolidated returns. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2004-02-13T00:00:00-05:00 | |
| 288190 | MR. STEVEN ELMENDORF b561c23b-c125-4cac-9716-961d78175814 | MT | MR. STEVEN ELMENDORF | 82818 | ASSN OF TRIAL LAWYERS OF AMERICA | 2004 | mid_year | TOR | HOUSE OF REPRESENTATIVES | 0 | 0 | 0 | 2004-02-13T00:00:00-05:00 | ||
| 288423 | AMERICAN UROLOGICAL ASSOCIATION 5293d7c5-1b14-41c7-94d9-40dfeca16e80 | MM | AMERICAN UROLOGICAL ASSOCIATION | 90352 | AMERICAN UROLOGICAL ASSOCIATION | 2004 | mid_year | HCR | HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 250000 | 0 | 0 | 2004-02-15T00:00:00-05:00 | ||
| 288424 | AMERICAN UROLOGICAL ASSOCIATION 5293d7c5-1b14-41c7-94d9-40dfeca16e80 | MM | AMERICAN UROLOGICAL ASSOCIATION | 90352 | AMERICAN UROLOGICAL ASSOCIATION | 2004 | mid_year | MMM | HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 250000 | 0 | 0 | 2004-02-15T00:00:00-05:00 | ||
| 288425 | AMERICAN UROLOGICAL ASSOCIATION 5293d7c5-1b14-41c7-94d9-40dfeca16e80 | MM | AMERICAN UROLOGICAL ASSOCIATION | 90352 | AMERICAN UROLOGICAL ASSOCIATION | 2004 | mid_year | TOR | HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 250000 | 0 | 0 | 2004-02-15T00:00:00-05:00 | ||
| 288444 | INTERNATIONAL COMMERCE DEVELOPMENT CORP 856e2fa4-278a-42da-99f6-7ff7cb134d88 | MT | INTERNATIONAL COMMERCE DEVELOPMENT CORP | 286278 | 321 STUDIOSCOM | 2004 | mid_year | CPT | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-02-15T00:00:00-05:00 | ||
| 288560 | NOSSAMAN LLP 1edabc27-e2e2-498a-8404-bc63419c3bb5 | MT | NOSSAMAN LLP | 29846 | COALITION OF COMMUNITY BANKERS | 2004 | mid_year | BAN | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2004-02-17T00:00:00-05:00 | ||
| 288561 | NOSSAMAN LLP 2b021177-25ee-408b-b31b-c77a5e82e470 | MT | NOSSAMAN LLP | 29846 | GRAY INSURANCE CO | 2004 | mid_year | BAN | HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 0 | 0 | 0 | 2004-02-17T00:00:00-05:00 | ||
| 288562 | NOSSAMAN LLP 2b021177-25ee-408b-b31b-c77a5e82e470 | MT | NOSSAMAN LLP | 29846 | GRAY INSURANCE CO | 2004 | mid_year | FIN | HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 0 | 0 | 0 | 2004-02-17T00:00:00-05:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
income_amount INTEGER,
expense_amount INTEGER,
is_no_activity INTEGER DEFAULT 0,
is_termination INTEGER DEFAULT 0,
received_date TEXT,
CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
REFERENCES lobbying_filings_raw(filing_uuid)
);
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);