lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
23,823 rows where filing_period = "year_end" and filing_year = 1999 sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: filing_type, specific_issues, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | AMERICAN COTTON SHIPPERS ASSOCIATION 897fdada-c393-4de3-b506-9342a34c5073 | YY | AMERICAN COTTON SHIPPERS ASSOCIATION | 2070 | AMERICAN COTTON SHIPPERS ASSOCIATION | 1999 | year_end | AGR | Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 1999-01-05T00:00:00-05:00 | |||
| 4 | RAY & CO, BRUCE 50e3e8b2-9976-4cab-bb14-f3a86135704f | YY | RAY & CO, BRUCE | 32748 | FAIRVIEW HEALTH SYSTEM | 1999 | year_end | DEF | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-05T00:00:00-05:00 | ||
| 5 | MITCHELL COOPER 99b45f08-c763-4a75-8e9e-b6db554d47a4 | YY | MITCHELL COOPER | 10742 | RUBBER AND PLASTIC FOOTWEAR MANUFACTURERS ASSOCIATION (RPFMA) | 1999 | year_end | TRD | Commerce, Dept of (DOC),SENATE,U.S. Trade Representative (USTR) | 20000 | 0 | 0 | 1999-01-05T00:00:00-05:00 | ||
| 7 | BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL 106c2c6e-f0e1-46e3-9409-294e0bd27878 | YY | BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL | 7394 | BUILDING OWNERS AND MANAGERS ASSOCIATION INTERNATIONAL | 1999 | year_end | RES | Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-01-05T00:00:00-05:00 | ||
| 8 | LONG, ROBERT MICHAEL f89c3a24-ff68-46c5-be4e-59e41962cb09 | YTY | LONG, ROBERT MICHAEL | 23122 | SPRINT | 1999 | year_end | 0 | 0 | 1999-01-10T00:00:00-05:00 | |||||
| 9 | THOMPSON AND NAUGHTON INC. ef0e2816-268a-4e3e-952e-9aeff8ce65df | YY | THOMPSON AND NAUGHTON INC. | 38038 | GENERAL MOTORS | 1999 | year_end | ENG | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 10 | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL f7859dd9-113e-47e8-87bc-56765517d046 | YY | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL | 47861 | TEXAS COUNTY STORM WATER COALITION | 1999 | year_end | ENV | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||||
| 11 | THOMPSON AND NAUGHTON INC. 4a036cde-bfc7-4921-9bd0-299f9f1a2add | YY | THOMPSON AND NAUGHTON INC. | 38038 | PROCESS GAS CONSUMERS GROUP | 1999 | year_end | ENG | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 13 | FINCH, WILLIAM J. fff29969-fdec-4125-809e-0d8d2d8e73fc | YY | FINCH, WILLIAM J. | 14542 | COOK GROUP | 1999 | year_end | MED | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 1999-01-10T00:00:00-05:00 | |||
| 14 | THOMPSON AND NAUGHTON INC. f2b23337-3088-4a81-badd-405130271343 | YY | THOMPSON AND NAUGHTON INC. | 38038 | BELLSOUTH CORP | 1999 | year_end | COM | HOUSE OF REPRESENTATIVES,SENATE | 12000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 23 | SYSTEM PLANNING CORP 0c064aae-3e12-48a6-8f0e-18d1157b0613 | YY | SYSTEM PLANNING CORP | 37562 | CONEXOR | 1999 | year_end | ECN | HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 0 | 0 | 1999-01-10T00:00:00-05:00 | |||
| 26 | LONG, ROBERT MICHAEL 99db1e88-4e95-4133-af7e-ddf8ba3a7b2a | YYY | LONG, ROBERT MICHAEL | 23122 | BROADWING COMMUNICATIONS INC | 1999 | year_end | 0 | 0 | 1999-01-10T00:00:00-05:00 | |||||
| 27 | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL 3b605825-4d1b-4ea3-847d-e45c06825333 | YTY | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL | 47861 | MONTGOMERY COUNTY HOSPITAL DIST | 1999 | year_end | 0 | 0 | 1999-01-10T00:00:00-05:00 | |||||
| 28 | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL b1929e76-35c9-46d6-900f-f421225c8897 | YTY | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL | 47861 | TARRANT COUNTY HOSPITAL DIST | 1999 | year_end | 0 | 0 | 1999-01-10T00:00:00-05:00 | |||||
| 33 | SYSTEM PLANNING CORP 0b698bc4-d5c9-4cd4-aa18-1b3ca74c7d3b | YY | SYSTEM PLANNING CORP | 37562 | HEBREW UNIV OF JERUSALEM | 1999 | year_end | SCI | HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 0 | 0 | 1999-01-10T00:00:00-05:00 | |||
| 34 | THOMPSON AND NAUGHTON INC. f967fa50-3292-4bc8-a9c8-9c3f40f9fe7d | YY | THOMPSON AND NAUGHTON INC. | 38038 | ITRON | 1999 | year_end | COM | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 35 | BINGHAM MCCUTCHEN LLP a6454328-c954-4a99-b7cf-4deb686e1209 | YA | BINGHAM MCCUTCHEN LLP | 51560 | FLEET BOSTON FINANCIAL CORP | 1999 | year_end | BAN | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 36 | BINGHAM MCCUTCHEN LLP a6454328-c954-4a99-b7cf-4deb686e1209 | YA | BINGHAM MCCUTCHEN LLP | 51560 | FLEET BOSTON FINANCIAL CORP | 1999 | year_end | BNK | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 38 | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0 | YY | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. | 37675 | TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC. | 1999 | year_end | ENV | HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 340000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 39 | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0 | YY | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. | 37675 | TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC. | 1999 | year_end | UTI | HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 340000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 40 | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0 | YY | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. | 37675 | TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC. | 1999 | year_end | TAX | HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 340000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 41 | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0 | YY | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. | 37675 | TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC. | 1999 | year_end | HCR | HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 340000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 42 | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. 6baf49df-7ff0-4369-a274-3b41eaa685d0 | YY | TECO HOLDINGS INC., FORMERLY KNOWN AS TECO ENERGY, INC. | 37675 | TECO HOLDINGS INC., FORMERLY KNOWN AS ENERGY, INC. | 1999 | year_end | MAR | HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 340000 | 0 | 0 | 1999-01-10T00:00:00-05:00 | ||
| 43 | ROGERS & WELLS be3a7c8a-3108-43af-b261-dd4528a51804 | YT | ROGERS & WELLS | 33603 | PARIBAS (NY BRANCH) | 1999 | year_end | BAN | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 1999-01-10T00:00:00-05:00 | |||
| 49 | MORSE CONSULTING e977c1a9-c2dc-479b-9762-79a2287d12ad | YY | MORSE CONSULTING | 47074 | FIRST DATA CORP | 1999 | year_end | BAN | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 50 | ENS RESOURCES, INC. 89c3d3a6-725e-4812-9b00-69a62275c56c | YY | ENS RESOURCES, INC. | 13610 | SACRAMENTO REGIONAL COUNTY SANITATION DISTRICT | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 1999-01-13T00:00:00-05:00 | |||
| 51 | ENS RESOURCES, INC. d382587a-65fc-4f4a-b050-bdd2ad63d93c | YY | ENS RESOURCES, INC. | 13610 | SOUTH TAHOE PUBLIC UTILITY DISTRICT | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 52 | ENS RESOURCES, INC. 205da590-4647-494e-aa26-0f5817e8b2fd | YY | ENS RESOURCES, INC. | 13610 | WATEREUSE ASSOCIATION | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 53 | ENS RESOURCES, INC. 85bf5bcf-9416-4bf5-9d9a-6c090591d02d | YY | ENS RESOURCES, INC. | 13610 | EAST BAY MUNICIPAL UTILITY DISTRICT | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 54 | ENS RESOURCES, INC. 85bf5bcf-9416-4bf5-9d9a-6c090591d02d | YY | ENS RESOURCES, INC. | 13610 | EAST BAY MUNICIPAL UTILITY DISTRICT | 1999 | year_end | ENV | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 55 | ENS RESOURCES, INC. 85bf5bcf-9416-4bf5-9d9a-6c090591d02d | YY | ENS RESOURCES, INC. | 13610 | EAST BAY MUNICIPAL UTILITY DISTRICT | 1999 | year_end | CAW | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 56 | ENS RESOURCES, INC. 9cc7e198-9534-4064-a02d-87591730e07e | YY | ENS RESOURCES, INC. | 13610 | CITY OF SACRAMENTO DEPARTMENT OF UTILITIES | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 57 | MR. ROBERT BUCKLER 6172e52d-b223-484c-b159-612b2a04f107 | YYY | MR. ROBERT BUCKLER | 7348 | UPM-KYMMENE INC | 1999 | year_end | 0 | 0 | 1999-01-13T00:00:00-05:00 | |||||
| 58 | STRATACOMM LLC 26f7bf91-9709-4f80-b787-d85a383d23f5 | YYY | STRATACOMM LLC | 36925 | AMERICAN COALITION FOR TRAFFIC SAFETY | 1999 | year_end | 0 | 0 | 1999-01-13T00:00:00-05:00 | |||||
| 59 | ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8 | YY | ALLIANCE FOR CHILDREN AND FAMILIES | 47826 | ALLIANCE FOR CHILDREN AND FAMILIES | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 60 | ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8 | YY | ALLIANCE FOR CHILDREN AND FAMILIES | 47826 | ALLIANCE FOR CHILDREN AND FAMILIES | 1999 | year_end | FAM | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 61 | ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8 | YY | ALLIANCE FOR CHILDREN AND FAMILIES | 47826 | ALLIANCE FOR CHILDREN AND FAMILIES | 1999 | year_end | WEL | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 62 | ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8 | YY | ALLIANCE FOR CHILDREN AND FAMILIES | 47826 | ALLIANCE FOR CHILDREN AND FAMILIES | 1999 | year_end | LAW | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 63 | ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8 | YY | ALLIANCE FOR CHILDREN AND FAMILIES | 47826 | ALLIANCE FOR CHILDREN AND FAMILIES | 1999 | year_end | TAX | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 64 | ALLIANCE FOR CHILDREN AND FAMILIES c72f34b6-7742-4942-9b30-ca2abec4ccf8 | YY | ALLIANCE FOR CHILDREN AND FAMILIES | 47826 | ALLIANCE FOR CHILDREN AND FAMILIES | 1999 | year_end | HCR | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 65 | ENS RESOURCES, INC. ab501fe5-0a39-40ec-9856-e20020487f99 | YY | ENS RESOURCES, INC. | 13610 | WESTERN RESEARCH INSTITUTE | 1999 | year_end | BUD | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 66 | ENS RESOURCES, INC. 3bc9a45f-b07e-47fd-88ac-68ffd2fd7192 | YY | ENS RESOURCES, INC. | 13610 | CALIFORNIA ASSOCIATION OF SANITATION AGENCIES | 1999 | year_end | BUD | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 67 | ENS RESOURCES, INC. 3bc9a45f-b07e-47fd-88ac-68ffd2fd7192 | YY | ENS RESOURCES, INC. | 13610 | CALIFORNIA ASSOCIATION OF SANITATION AGENCIES | 1999 | year_end | ENV | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 68 | ENS RESOURCES, INC. 3bc9a45f-b07e-47fd-88ac-68ffd2fd7192 | YY | ENS RESOURCES, INC. | 13610 | CALIFORNIA ASSOCIATION OF SANITATION AGENCIES | 1999 | year_end | CAW | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 69 | ENS RESOURCES, INC. 5d000056-eb64-462e-a8f8-62a57787aad5 | YY | ENS RESOURCES, INC. | 13610 | COUNTY OF SACRAMENTO-PUBLIC WORKS AGENCY-TRANSPORTATION DIV | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 70 | ENS RESOURCES, INC. 5d000056-eb64-462e-a8f8-62a57787aad5 | YY | ENS RESOURCES, INC. | 13610 | COUNTY OF SACRAMENTO-PUBLIC WORKS AGENCY-TRANSPORTATION DIV | 1999 | year_end | NAT | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 71 | ENS RESOURCES, INC. 7f3a56d2-48f1-4156-9902-32d6f9bcc48d | YY | ENS RESOURCES, INC. | 13610 | COUNTY SANITATION DISTRICTS OF ORANGE COUNTY | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 72 | ENS RESOURCES, INC. 7f3a56d2-48f1-4156-9902-32d6f9bcc48d | YY | ENS RESOURCES, INC. | 13610 | COUNTY SANITATION DISTRICTS OF ORANGE COUNTY | 1999 | year_end | NAT | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 20000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 73 | ENS RESOURCES, INC. c849c800-92fb-4788-8ec2-af260ea329b0 | YY | ENS RESOURCES, INC. | 13610 | INFILCO DEGREMONT | 1999 | year_end | CAW | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 76 | STRATACOMM LLC 9b752cc8-afaf-47bb-8808-1f97c6d7d969 | YYY | STRATACOMM LLC | 36925 | COALITION FOR VEHICLE CHOICE | 1999 | year_end | 0 | 0 | 1999-01-13T00:00:00-05:00 | |||||
| 77 | MORSE CONSULTING 67f4fcf6-a0fd-48a1-a533-ce4a2f127b1c | YY | MORSE CONSULTING | 47074 | AXCESS FINANCIAL | 1999 | year_end | BAN | HOUSE OF REPRESENTATIVES | 0 | 0 | 1999-01-13T00:00:00-05:00 | |||
| 78 | MORSE CONSULTING ec083ee2-3082-4111-aa36-867c9a2ac93e | YY | MORSE CONSULTING | 47074 | KNICKERBOCKER MANAGEMENT | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 79 | STRATACOMM LLC 26f06bb4-e1d4-4677-aaa6-e8929338b04c | YYY | STRATACOMM LLC | 36925 | CONTINENTAL TEVES | 1999 | year_end | 0 | 0 | 1999-01-13T00:00:00-05:00 | |||||
| 80 | STRATACOMM LLC 92112f29-e6c4-48e9-b666-88d2060a8b9a | YYY | STRATACOMM LLC | 36925 | WINE & SPIRITS WHOLESALERS OF AMERICA | 1999 | year_end | 0 | 0 | 1999-01-13T00:00:00-05:00 | |||||
| 81 | BUSINESS EXECUTIVES FOR NATL SECURITY cc9cfdcd-a700-4427-ba6d-b3254eb0648e | YY | BUSINESS EXECUTIVES FOR NATL SECURITY | 7521 | BUSINESS EXECUTIVES FOR NATL SECURITY | 1999 | year_end | DEF | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Security Council (NSC),SENATE | 0 | 0 | 1999-01-13T00:00:00-05:00 | |||
| 82 | MORSE CONSULTING cf65d7c0-1355-4c1d-9b27-eb0c85842f3d | YY | MORSE CONSULTING | 47074 | HOUSEHOLD FINANCIAL GROUP | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE | 60000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 83 | MORSE CONSULTING cf65d7c0-1355-4c1d-9b27-eb0c85842f3d | YY | MORSE CONSULTING | 47074 | HOUSEHOLD FINANCIAL GROUP | 1999 | year_end | BNK | HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE | 60000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 84 | NEW JEWISH NARRATIVE (FKA AMERICANS FOR PEACE NOW) e2dc182d-6e2c-4a3c-a542-fb6ce0150c20 | YY | NEW JEWISH NARRATIVE (FKA AMERICANS FOR PEACE NOW) | 3798 | NEW JEWISH NARRATIVE (FKA AMERICANS FOR PEACE NOW) | 1999 | year_end | FOR | HOUSE OF REPRESENTATIVES,Natl Security Council (NSC),SENATE,State, Dept of (DOS) | 40000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 85 | ENS RESOURCES, INC. 6397527d-2740-4e65-8295-2f21bc165a93 | YY | ENS RESOURCES, INC. | 13610 | UNION SANITARY DISTRICT | 1999 | year_end | NAT | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 86 | ENS RESOURCES, INC. 6397527d-2740-4e65-8295-2f21bc165a93 | YY | ENS RESOURCES, INC. | 13610 | UNION SANITARY DISTRICT | 1999 | year_end | BUD | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 1999-01-13T00:00:00-05:00 | ||
| 87 | KIDSPEACE CORPORATION 9d3b5670-e16d-4fc6-a167-d9dd07b73f77 | YY | KIDSPEACE CORPORATION | 45471 | KIDSPEACE CORPORATION | 1999 | year_end | BUD | Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,SENATE | 98200 | 0 | 0 | 1999-01-14T00:00:00-05:00 | ||
| 94 | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 7ed9506d-06e9-4c8e-bf76-cf614d7fa579 | YY | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) | 33875 | RENT-A-CENTER | 1999 | year_end | BAN | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 95 | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 144c611c-6937-48ac-9303-d85d3ab66cd6 | YYY | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) | 33875 | CONFERENCE OF STATE BANK SUPERVISORS | 1999 | year_end | 0 | 0 | 1999-02-07T00:00:00-05:00 | |||||
| 96 | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 961ab94f-da9e-4042-85d4-cd00ccbd3da1 | YY | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) | 33875 | AMERICAN NAMES ASSN | 1999 | year_end | FIN | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 97 | IT GROUP, INC 87009120-fa9a-4bf6-b4a2-c4f0aa20845d | YY | IT GROUP, INC | 20061 | IT GROUP INC | 1999 | year_end | ENV | Army, Dept of (Corps of Engineers),Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE | 20000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 98 | TERRY, JOHN H. eebce0a1-6412-4eea-8f53-5652d510ca65 | YY | TERRY, JOHN H. | 37824 | NIAGARA MOHAWK POWER CORP | 1999 | year_end | UTI | HOUSE OF REPRESENTATIVES,SENATE | 26080 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 99 | INTL COUNCIL OF CRUISE LINES 961c981e-d0bb-4a38-8287-955969d4878e | YY | INTL COUNCIL OF CRUISE LINES | 19913 | INTL COUNCIL OF CRUISE LINES | 1999 | year_end | TRA | Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Defense, Dept of (DOD),Government Accountability Office (GAO),Justice, Dept of (DOJ),Natl Institutes of Health (NIH),Panama Canal Commission,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Coast Guard (USCG) | 279601 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 100 | INTL COUNCIL OF CRUISE LINES 961c981e-d0bb-4a38-8287-955969d4878e | YY | INTL COUNCIL OF CRUISE LINES | 19913 | INTL COUNCIL OF CRUISE LINES | 1999 | year_end | HCR | Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Defense, Dept of (DOD),Government Accountability Office (GAO),Justice, Dept of (DOJ),Natl Institutes of Health (NIH),Panama Canal Commission,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Coast Guard (USCG) | 279601 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 101 | INTL COUNCIL OF CRUISE LINES 961c981e-d0bb-4a38-8287-955969d4878e | YY | INTL COUNCIL OF CRUISE LINES | 19913 | INTL COUNCIL OF CRUISE LINES | 1999 | year_end | ENV | Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Defense, Dept of (DOD),Government Accountability Office (GAO),Justice, Dept of (DOJ),Natl Institutes of Health (NIH),Panama Canal Commission,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Coast Guard (USCG) | 279601 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 102 | INTL COUNCIL OF CRUISE LINES 961c981e-d0bb-4a38-8287-955969d4878e | YY | INTL COUNCIL OF CRUISE LINES | 19913 | INTL COUNCIL OF CRUISE LINES | 1999 | year_end | IMM | Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Defense, Dept of (DOD),Government Accountability Office (GAO),Justice, Dept of (DOJ),Natl Institutes of Health (NIH),Panama Canal Commission,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Coast Guard (USCG) | 279601 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 103 | MERCURY PUBLIC AFFAIRS, LLC 5a6ef2c2-b53a-4904-95d6-6159e6e9cf0c | YY | MERCURY PUBLIC AFFAIRS, LLC | 70175 | AMERICAN INTL GROUP | 1999 | year_end | TAX | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 104 | MERCURY PUBLIC AFFAIRS, LLC 5a6ef2c2-b53a-4904-95d6-6159e6e9cf0c | YY | MERCURY PUBLIC AFFAIRS, LLC | 70175 | AMERICAN INTL GROUP | 1999 | year_end | INS | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 105 | MERCURY PUBLIC AFFAIRS, LLC edc0d1b6-f012-4d19-bb42-7eb3a84d31f2 | YY | MERCURY PUBLIC AFFAIRS, LLC | 70175 | BHP COPPER | 1999 | year_end | TAX | HOUSE OF REPRESENTATIVES,SENATE | 80000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 106 | MERCURY PUBLIC AFFAIRS, LLC ae5e98ec-76ff-4408-872a-aa9ee96edf94 | YYY | MERCURY PUBLIC AFFAIRS, LLC | 70175 | INTEL CORP | 1999 | year_end | ENV | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 1999-02-07T00:00:00-05:00 | |||
| 107 | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 51aafdff-e9ea-48d0-862c-b9c88012740a | YY | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) | 33875 | AMERICAN COLLECTORS ASSN | 1999 | year_end | BAN | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 108 | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 5aef18d0-daab-4fed-ac34-9309fd48f3da | YY | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) | 33875 | CHICAGO MERCANTILE EXCHANGE | 1999 | year_end | FIN | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 109 | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) d829e37e-ec03-493b-bd16-f3dd1a44ceff | YYY | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) | 33875 | TRADE EXCHANGE OF AMERICA | 1999 | year_end | 0 | 0 | 1999-02-07T00:00:00-05:00 | |||||
| 110 | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 2c6e3144-8671-4b3c-830d-262c0da768ae | YY | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) | 33875 | EDISON PROPERTIES | 1999 | year_end | RES | HOUSE OF REPRESENTATIVES | 60000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 111 | NELSON, PAUL 2be8ca36-c800-49f2-8628-0b5536eb5908 | YY | NELSON, PAUL | 29015 | CONSUMER DATA INDUSTRY ASSOCIATION (FORMERLY ASSOCIATED CREDIT BUREAUS) | 1999 | year_end | FIN | HOUSE OF REPRESENTATIVES | 20000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 112 | MERCURY PUBLIC AFFAIRS, LLC e9c5c6c5-c13f-40e3-932e-6bd1792c9441 | YY | MERCURY PUBLIC AFFAIRS, LLC | 70175 | GAF CORP | 1999 | year_end | MAN | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 1999-02-07T00:00:00-05:00 | |||
| 113 | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) 2db1409d-2a66-4dc2-977d-5440bf233f69 | YYY | THE ROYER LAW FIRM (FORMERLY ROYER & BROOKS) | 33875 | MACANDREWS & FORBES HOLDING | 1999 | year_end | 0 | 0 | 1999-02-07T00:00:00-05:00 | |||||
| 114 | MERCURY PUBLIC AFFAIRS, LLC 8d7b74f8-a8bb-4480-ab26-11d5870651fb | YY | MERCURY PUBLIC AFFAIRS, LLC | 70175 | NCR | 1999 | year_end | ENV | HOUSE OF REPRESENTATIVES,SENATE | 80000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 115 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | TAX | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 116 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | HCR | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 117 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | TRD | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 118 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | BAN | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 119 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | MAN | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 120 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | DEF | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 121 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | IMM | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 122 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | LBR | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 123 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | MED | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 124 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | TRA | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 125 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | ENV | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 126 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | FOR | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 127 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | BUD | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 128 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | CSP | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 129 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | GOV | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 130 | HALLIBURTON COMPANY da8d9c73-294e-4570-b0bc-c462e4b58ebe | YY | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 1999 | year_end | ENG | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA) | 400000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 131 | NELSON, PAUL 888ef36e-c4bc-497c-b6b2-9134fccfec52 | YY | NELSON, PAUL | 29015 | INVESTMENT CO INST | 1999 | year_end | FIN | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 1999-02-07T00:00:00-05:00 | ||
| 132 | FAMILY RESEARCH COUNCIL ce3b6118-4a95-43ef-bd86-e711357caff7 | YY | FAMILY RESEARCH COUNCIL | 14110 | FAMILY RESEARCH COUNCIL | 1999 | year_end | DEF | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 1999-02-07T00: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);