lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
153,405 rows where filing_year = 2017 sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1947750 | OSF HEALTHCARE SYSTEM 7268d336-ebe6-45d2-a8b5-d16dfa4c5e55 | Q1 | OSF HEALTHCARE SYSTEM | 56394 | OSF HEALTHCARE SYSTEM | 2017 | first_quarter | HCR | *Termination report for current internal lobbyist | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Medicare Payment Advisory Commission (MedPAC),SENATE | 100000 | 0 | 0 | 2017-01-10T10:27:16-05:00 | |
| 1947751 | RASKY PARTNERS, INC. 6e79d459-3cc9-48c4-b38e-e8029e7daf3f | 1T | RASKY PARTNERS, INC. | 297410 | H. LEE MOFFITT CANCER CENTER AND RESEARCH INSTITUTE HOSPITAL, INC. | 2017 | first_quarter | HCR | Cancer Issues | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2017-01-13T11:29:30-05:00 | ||
| 1947752 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) 7b15dab4-ea32-4a00-af0a-585680c5cc18 | Q1 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) | 44 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) | 2017 | first_quarter | BAN | H.R 2209, to require the appropriate federal banking agencies to treat certain municipal obligations as level 2A liquid assets S. 3404, to require the appropriate Federal banking agencies to treat certain municipal obligations as level 2B liquid assets Basel Capital Rules Basel Liquidity Rules Accountability for Basel/FSB negotiations Volcker Rule Reform DoL Fiduciary Rule H.R. 5983, The Financial CHOICE Act | Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-19T12:01:00-05:00 | ||
| 1947753 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) 7b15dab4-ea32-4a00-af0a-585680c5cc18 | Q1 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) | 44 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) | 2017 | first_quarter | ECN | Interest on Excess Reserves | Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-19T12:01:00-05:00 | ||
| 1947754 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) 7b15dab4-ea32-4a00-af0a-585680c5cc18 | Q1 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) | 44 | AMERICAN BANKERS ASSOCIATION SECURITIES ASSOCIATION (ABASA) | 2017 | first_quarter | FIN | H.R. 6392, Systemic Risk Designation Improvement Act of 2016 | Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-19T12:01:00-05:00 | ||
| 1947755 | OH STRATEGIC COMMUNICATIONS d0058e1f-6ff3-4de0-8f9c-c5ebe714c3c4 | 1TY | OH STRATEGIC COMMUNICATIONS | 401103730 | SALT RIVER PIMA-MARICOPA INDIAN COMMUNITY | 2017 | first_quarter | 0 | 1 | 2017-01-19T14:32:54-05:00 | |||||
| 1947756 | SUSAN PLATT 87965a4f-3642-479a-88b1-84bc4663c9c6 | 1T | SUSAN PLATT | 59411 | ALTRIA CLIENT SERVICES LLC | 2017 | first_quarter | HCR | FDA Oversight of Tobacco | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2017-01-21T19:05:32-05:00 | ||
| 1947757 | BARNES & THORNBURG, LLP 5e2f9bb1-2489-41a0-a6d1-d8476c8dc550 | 1TY | BARNES & THORNBURG, LLP | 5404 | JLN SOLAR | 2017 | first_quarter | 20000 | 0 | 1 | 2017-01-23T14:03:59-05:00 | ||||
| 1947758 | DENISE WILSON 5fee755d-ea9a-4d9c-8a6e-cd7bba97c605 | 1TY | DENISE WILSON | 401103953 | APWU | 2017 | first_quarter | 0 | 1 | 2017-01-23T14:22:12-05:00 | |||||
| 1947759 | J.A. GREEN AND COMPANY (FORMERLY LLC) eccfb92e-8b4b-48b1-91f8-cf6281e2a4d7 | 1TY | J.A. GREEN AND COMPANY (FORMERLY LLC) | 313511 | NATIONAL AIR CARGO INC | 2017 | first_quarter | 0 | 1 | 2017-01-26T14:42:24.827000-05:00 | |||||
| 1947760 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. ea3295a9-93d2-4d2d-ada1-38ce7a077d79 | 1T | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | ASSOCIATED EQUIPMENT DISTRIBUTORS | 2017 | first_quarter | ENV | Urged Congress to strengthen oversight of Environmental Protection Agency regulatory over-reach. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 1 | 2017-01-27T14:13:31.770000-05:00 | ||
| 1947761 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. ea3295a9-93d2-4d2d-ada1-38ce7a077d79 | 1T | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | ASSOCIATED EQUIPMENT DISTRIBUTORS | 2017 | first_quarter | GOV | Urged closer congressional scrutiny and oversight of executive branch. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 1 | 2017-01-27T14:13:31.770000-05:00 | ||
| 1947762 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. ea3295a9-93d2-4d2d-ada1-38ce7a077d79 | 1T | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | ASSOCIATED EQUIPMENT DISTRIBUTORS | 2017 | first_quarter | ROD | Urged Congress to restore the Highway Trust Fund's long-term solvency and use tax reform as vehicle to identify new highway investment revenue sources (no bill number). | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 1 | 2017-01-27T14:13:31.770000-05:00 | ||
| 1947763 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. ea3295a9-93d2-4d2d-ada1-38ce7a077d79 | 1T | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | ASSOCIATED EQUIPMENT DISTRIBUTORS | 2017 | first_quarter | TRD | Urged Congress to lift embargo with Cuba, ensure the long-term viability of the Export-Import Bank, and build closer relationships with Canada. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 1 | 2017-01-27T14:13:31.770000-05:00 | ||
| 1947764 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. ea3295a9-93d2-4d2d-ada1-38ce7a077d79 | 1T | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | ASSOCIATED EQUIPMENT DISTRIBUTORS | 2017 | first_quarter | TAX | Urged Congress to use tax reform to encourage capital investment, reduce tax rates for businesses, ensure equitable treatment for pass-through entities, repeal the estate tax, create new user fee revenues to support infrastructure investment, hold equipment dealers harmless from Obamacare 3.8 percent passive income tax, reject efforts to extend cost recovery periods for equipment and reject efforts to repeal the last-in, first-out accounting method and IRC Sec. 1031 like-kind exchange. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 1 | 2017-01-27T14:13:31.770000-05:00 | ||
| 1947765 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. ea3295a9-93d2-4d2d-ada1-38ce7a077d79 | 1T | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | ASSOCIATED EQUIPMENT DISTRIBUTORS | 2017 | first_quarter | EDU | Urged enactment of legislation to reauthorize Carl D. Perkins Career and Technical Education Act and improve career technical education programs. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 1 | 2017-01-27T14:13:31.770000-05:00 | ||
| 1947766 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. ea3295a9-93d2-4d2d-ada1-38ce7a077d79 | 1T | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | ASSOCIATED EQUIPMENT DISTRIBUTORS | 2017 | first_quarter | CAW | Urged Congress to increase Clean Water and Safe Drinking Water SRF funding, create Clean Water Trust Fund, and increase volume cap on private activity bonds. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 1 | 2017-01-27T14:13:31.770000-05:00 | ||
| 1947767 | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. ea3295a9-93d2-4d2d-ada1-38ce7a077d79 | 1T | OBADAL, FILLER, MACLEOD & KLEIN, P.L.C. | 81351 | ASSOCIATED EQUIPMENT DISTRIBUTORS | 2017 | first_quarter | ENG | Urged Congress to expand domestic energy production and speed construction of energy infrastructure. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 1 | 2017-01-27T14:13:31.770000-05:00 | ||
| 1947768 | JOHN W. CONRAD III DBA JOHN W. CONRAD III AND COMPANY 8e42ecb6-498e-40e0-bffb-3730af7a4db4 | 1TY | JOHN W. CONRAD III DBA JOHN W. CONRAD III AND COMPANY | 75752 | CITY OF CORALVILLE | 2017 | first_quarter | 0 | 1 | 2017-01-29T12:18:43.637000-05:00 | |||||
| 1947769 | ARONNAX PUBLIC STRATEGIES LLC 20ab7ec9-a86b-4440-af5e-f3731d5a03ab | 1TY | ARONNAX PUBLIC STRATEGIES LLC | 400915666 | PUEBLO OF ZUNI | 2017 | first_quarter | 0 | 1 | 2017-01-30T20:47:05.317000-05:00 | |||||
| 1947770 | YOUTH VILLAGES, INC aca5d1ce-e319-4fe5-ac48-b2baea6f7ca5 | 1TY | YOUTH VILLAGES, INC | 400588795 | YOUTH VILLAGES, INC | 2017 | first_quarter | 0 | 1 | 2017-01-31T12:11:39.607000-05:00 | |||||
| 1947771 | IETAN CONSULTING, LLC 3e32f184-88bb-40d6-9d0d-9a0fe1c8748b | 1T | IETAN CONSULTING, LLC | 60537 | SAGINAW CHIPPEWA INDIAN TRIBE | 2017 | first_quarter | IND | native american issues | Bureau of Indian Affairs (BIA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 46500 | 0 | 1 | 2017-01-31T13:51:56.587000-05:00 | |
| 1947772 | VALENTE & ASSOCIATES 39b07e81-00e4-40d5-8445-be8cfc67f14f | 1T | VALENTE & ASSOCIATES | 45983 | AMERICAN-SPEECH-LANGUAGE-HEARING ASSOCIATION | 2017 | first_quarter | MMM | Medicare; Medicaid | Centers For Medicare and Medicaid Services (CMS),Education, Dept of,HOUSE OF REPRESENTATIVES,Office of Personnel Management (OPM),SENATE | 10000 | 0 | 1 | 2017-01-31T14:23:25.280000-05:00 | |
| 1947773 | VALENTE & ASSOCIATES 39b07e81-00e4-40d5-8445-be8cfc67f14f | 1T | VALENTE & ASSOCIATES | 45983 | AMERICAN-SPEECH-LANGUAGE-HEARING ASSOCIATION | 2017 | first_quarter | HCR | Benefits under Federal Employee Health Benefits Program | Centers For Medicare and Medicaid Services (CMS),Education, Dept of,HOUSE OF REPRESENTATIVES,Office of Personnel Management (OPM),SENATE | 10000 | 0 | 1 | 2017-01-31T14:23:25.280000-05:00 | |
| 1947774 | VALENTE & ASSOCIATES 39b07e81-00e4-40d5-8445-be8cfc67f14f | 1T | VALENTE & ASSOCIATES | 45983 | AMERICAN-SPEECH-LANGUAGE-HEARING ASSOCIATION | 2017 | first_quarter | EDU | Federal Education Program, IDEA, HEA | Centers For Medicare and Medicaid Services (CMS),Education, Dept of,HOUSE OF REPRESENTATIVES,Office of Personnel Management (OPM),SENATE | 10000 | 0 | 1 | 2017-01-31T14:23:25.280000-05:00 | |
| 1947775 | VALENTE & ASSOCIATES 7a5371c7-8cc6-409d-949e-b4d548267e47 | 1T | VALENTE & ASSOCIATES | 45983 | HOLLISTER INC | 2017 | first_quarter | TAX | Tax Issues | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of | 20000 | 0 | 1 | 2017-01-31T14:25:27.233000-05:00 | |
| 1947776 | VALENTE & ASSOCIATES 7a5371c7-8cc6-409d-949e-b4d548267e47 | 1T | VALENTE & ASSOCIATES | 45983 | HOLLISTER INC | 2017 | first_quarter | HCR | General Healthcare Policy Issues | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of | 20000 | 0 | 1 | 2017-01-31T14:25:27.233000-05:00 | |
| 1947777 | VALENTE & ASSOCIATES 7a5371c7-8cc6-409d-949e-b4d548267e47 | 1T | VALENTE & ASSOCIATES | 45983 | HOLLISTER INC | 2017 | first_quarter | MMM | Medicare/Medicaid | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of | 20000 | 0 | 1 | 2017-01-31T14:25:27.233000-05:00 | |
| 1947778 | VALENTE & ASSOCIATES 7a5371c7-8cc6-409d-949e-b4d548267e47 | 1T | VALENTE & ASSOCIATES | 45983 | HOLLISTER INC | 2017 | first_quarter | LBR | Employer/Employee Issues | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of | 20000 | 0 | 1 | 2017-01-31T14:25:27.233000-05:00 | |
| 1947779 | CARPENTER STRATEGIC CONSULTING LLC 93081fdc-df0b-4af8-aa6e-29470880f7d6 | 1TY | CARPENTER STRATEGIC CONSULTING LLC | 401104143 | VERIZON INC. | 2017 | first_quarter | 10000 | 0 | 1 | 2017-02-02T08:30:48.413000-05:00 | ||||
| 1947780 | MCKINNON GROUP, LLC, FORMERLY DOING BUSINESS AS RR&G, LLC cbf98bfd-5dd5-4ebb-8a6a-ba9d0dea6c53 | 1TY | MCKINNON GROUP, LLC, FORMERLY DOING BUSINESS AS RR&G, LLC | 306135 | QUICKEN LOANS | 2017 | first_quarter | 0 | 1 | 2017-02-02T20:16:06.953000-05:00 | |||||
| 1947781 | MG CONSULTING, LLC ceb94691-3176-4e1f-9565-63bad4de1239 | 1TY | MG CONSULTING, LLC | 401103701 | AMERICAN HUMANE ASSOCIATION | 2017 | first_quarter | 10000 | 0 | 1 | 2017-02-03T10:11:22.843000-05:00 | ||||
| 1947782 | J.A. GREEN AND COMPANY (FORMERLY LLC) 5ad251a2-9b66-4642-927c-715f5625085f | 1TY | J.A. GREEN AND COMPANY (FORMERLY LLC) | 313511 | COMMERCE RESOURCES CORPORATION | 2017 | first_quarter | 0 | 1 | 2017-02-03T12:29:32.030000-05:00 | |||||
| 1947783 | J.A. GREEN AND COMPANY (FORMERLY LLC) 44655197-839b-4863-9206-2a77b0e69b3d | 1TY | J.A. GREEN AND COMPANY (FORMERLY LLC) | 313511 | INFINIUM, INC. | 2017 | first_quarter | 0 | 1 | 2017-02-03T12:33:33.657000-05:00 | |||||
| 1947784 | RUFFALO AND ASSOCIATES, LLC 61ddb9ac-bd3a-4790-8f5a-6856e91fc6e1 | 1T | RUFFALO AND ASSOCIATES, LLC | 291572 | TAHOE TRANSPORTATION DISTRICT | 2017 | first_quarter | TRA | Federal Transit Administration apportionments - no bill number | SENATE | 10000 | 0 | 1 | 2017-02-05T06:44:51.857000-05:00 | |
| 1947785 | SANDI STUART/THE STUART MURRAY GROUP 3bfe3c53-dada-430c-bcb4-7ac6b27fe2cc | 1TY | SANDI STUART/THE STUART MURRAY GROUP | 400885593 | GOOGLE, INC. | 2017 | first_quarter | 10000 | 0 | 1 | 2017-02-07T00:44:51.760000-05:00 | ||||
| 1947786 | THORSEN FRENCH ADVOCACY LLC a4e914e7-6af0-4814-8522-71725d248348 | 1T | THORSEN FRENCH ADVOCACY LLC | 400599826 | FAMILIES AGAINST MANDATORY MINIMUMS | 2017 | first_quarter | LAW | Sentencing reforming issues. H.R. 3713: Sentencing Reform Act of 2015. General issues relating to Criminal Justice Reform. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2017-02-11T11:12:14.013000-05:00 | |
| 1947787 | SMITH ADVOCACY GROUP, LLC f33ddf49-18fc-45ab-92e8-8bffdd23ef1b | 1T | SMITH ADVOCACY GROUP, LLC | 401070011 | THE TATITLEK CORPORATION | 2017 | first_quarter | INT | Use of funding for satellite surveillance and sensor technology for monitoring and reporting on maritime domain awareness, mapping, safety, and environmental issues by Federal agencies | HOUSE OF REPRESENTATIVES,SENATE,U.S. Coast Guard (USCG) | 0 | 1 | 2017-02-13T22:47:00.197000-05:00 | ||
| 1947788 | THE MAJORITY GROUP, LLC bd06905e-7eed-46c5-b11f-7614df3104e5 | 1T | THE MAJORITY GROUP, LLC | 400713141 | BOCKORNY GROUP (ON BEHALF OF AIR METHODS) | 2017 | first_quarter | MMM | H.R.822, To amend title XVIII of the Social Security Act to require reporting of certain data by providers and suppliers of air ambulance services for purposes of reforming reimbursements for such services under the Medicare program, and for other purposes. S.1149, A bill to amend title XVIII of the Social Security Act to require reporting of certain data by providers and suppliers of air ambulance services for purposes of reforming reimbursements for such services under the Medicare program, and for other purposes. Issues Related to Air Medical Reimbursement | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2017-02-16T11:07:29.537000-05:00 | ||
| 1947789 | THE MAJORITY GROUP, LLC bd06905e-7eed-46c5-b11f-7614df3104e5 | 1T | THE MAJORITY GROUP, LLC | 400713141 | BOCKORNY GROUP (ON BEHALF OF AIR METHODS) | 2017 | first_quarter | AVI | H.R. 441 - Aviation Innovation, Reform, and Reauthorization Act of 2016, S.2658 - Federal Aviation Administration Reauthorization Act of 2016, Transportation, Housing & Urban Development Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2017-02-16T11:07:29.537000-05:00 | ||
| 1947790 | SHAE ARMSTRONG 8880246f-9d86-481c-9d0f-d55587a73d04 | 1T | SHAE ARMSTRONG | 401104193 | THE MORE AMERICAN JOBS ALLIANCE | 2017 | first_quarter | FIN | EB-5 Immigrant Investment | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2017-02-16T11:50:53.997000-05:00 | ||
| 1947791 | SHAE ARMSTRONG 8880246f-9d86-481c-9d0f-d55587a73d04 | 1T | SHAE ARMSTRONG | 401104193 | THE MORE AMERICAN JOBS ALLIANCE | 2017 | first_quarter | IMM | EB-5 Immigration reform advocacy | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2017-02-16T11:50:53.997000-05:00 | ||
| 1947792 | VENABLE LLP d30a5db8-4a12-4213-932c-6adc8436fb62 | Q1 | VENABLE LLP | 39941 | AON SERVICE CORPORATION | 2017 | first_quarter | FIN | Monitoring financial services issues. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T12:40:17.593000-05:00 | |
| 1947793 | VENABLE LLP 0a51ffea-1a36-4253-90f2-8c80ebb26dfd | Q1 | VENABLE LLP | 39941 | LLOYD'S AMERICA, INC. | 2017 | first_quarter | INS | Issues related to insurance | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T12:41:20.717000-05:00 | |
| 1947794 | VENABLE LLP 308f8aaf-d76c-483f-965e-a67fd09fc26d | Q1 | VENABLE LLP | 39941 | METROPOLITAN LIFE INSURANCE COMPANY | 2017 | first_quarter | INS | Monitoring financial services issues. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T12:43:23.560000-05:00 | |
| 1947795 | VENABLE LLP f7201683-fc72-48f6-a666-0a183ce05d73 | Q1 | VENABLE LLP | 39941 | AMERICAN EXPRESS COMPANY | 2017 | first_quarter | BAN | Monitoring financial services issues. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T12:44:24.907000-05:00 | |
| 1947796 | VENABLE LLP 6c1ba663-f4a9-49c5-823f-196cb7572b71 | Q1 | VENABLE LLP | 39941 | PROPERTY CASUALTY INSURERS ASSOCIATION OF AMERICA | 2017 | first_quarter | INS | Monitoring financial services issues. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T12:45:28.093000-05:00 | |
| 1947797 | VENABLE LLP b53abf89-41af-4fd2-8882-d6a6797a58fb | Q1 | VENABLE LLP | 39941 | S&P GLOBAL INC | 2017 | first_quarter | BAN | Monitoring financial services issues | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T12:51:30.720000-05:00 | |
| 1947798 | VENABLE LLP 18c1d285-07bc-4a24-83e6-67333972404f | Q1 | VENABLE LLP | 39941 | THE CLEARING HOUSE ASSOCIATION | 2017 | first_quarter | FIN | Monitoring financial services issues | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T12:52:34.423000-05:00 | |
| 1947799 | VENABLE LLP 5d5a73ea-e258-47bb-89dc-99befe939962 | Q1 | VENABLE LLP | 39941 | UNITED SERVICES AUTOMOBILE ASSOCIATION | 2017 | first_quarter | FIN | Monitoring financial services issues. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T12:54:37.313000-05:00 | |
| 1947800 | VENABLE LLP b654a419-b90f-4377-a0e1-6dbb5adaab8d | Q1 | VENABLE LLP | 39941 | ELECTRONIC TRANSACTIONS ASSOCIATION | 2017 | first_quarter | FIN | Issues relating to the role of payment processors in commerce and related federal regulations | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2017-02-17T14:55:52.530000-05:00 | |
| 1947801 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 004751d7-1fca-4552-914a-c0980aeb1c25 | 1T | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | TAX | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2017-02-17T15:12:57.487000-05:00 | |
| 1947802 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 004751d7-1fca-4552-914a-c0980aeb1c25 | 1T | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | BUD | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2017-02-17T15:12:57.487000-05:00 | |
| 1947803 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 004751d7-1fca-4552-914a-c0980aeb1c25 | 1T | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | SCI | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2017-02-17T15:12:57.487000-05:00 | |
| 1947804 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 004751d7-1fca-4552-914a-c0980aeb1c25 | 1T | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | MAN | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2017-02-17T15:12:57.487000-05:00 | |
| 1947805 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 004751d7-1fca-4552-914a-c0980aeb1c25 | 1T | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | GOV | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2017-02-17T15:12:57.487000-05:00 | |
| 1947806 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 004751d7-1fca-4552-914a-c0980aeb1c25 | 1T | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | CPT | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2017-02-17T15:12:57.487000-05:00 | |
| 1947807 | VENABLE LLP 07ff0bb5-2629-42d5-ae23-bbf863293200 | Q1 | VENABLE LLP | 39941 | EXPERIAN INC | 2017 | first_quarter | CSP | Issues pertaining to facilitating access to credit. | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-17T16:54:04.873000-05:00 | |
| 1947808 | VENABLE LLP b1f07bb5-442f-4b94-a3b1-04302f52557c | Q1 | VENABLE LLP | 39941 | STATE STREET BANK AND TRUST COMPANY | 2017 | first_quarter | FIN | Financial legislation | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) | 20000 | 0 | 0 | 2017-02-17T16:59:06.403000-05:00 | |
| 1947809 | VENABLE LLP b1f07bb5-442f-4b94-a3b1-04302f52557c | Q1 | VENABLE LLP | 39941 | STATE STREET BANK AND TRUST COMPANY | 2017 | first_quarter | TAX | Federal tax legislation relating to energy policy, re-authorization of agriculture programs and extension of temporary tax provisions. | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) | 20000 | 0 | 0 | 2017-02-17T16:59:06.403000-05:00 | |
| 1947810 | VENABLE LLP 55618bae-8ec2-43b5-bdf0-e4798d9d6a56 | Q1 | VENABLE LLP | 39941 | FRANKLIN ADVISERS, INC. | 2017 | first_quarter | BNK | Issues related to PROMESA implementation. | HOUSE OF REPRESENTATIVES,SENATE | 140000 | 0 | 0 | 2017-02-17T17:03:08.093000-05:00 | |
| 1947811 | VENABLE LLP b1b50897-dffb-49a6-b353-7e275eec9c33 | Q1 | VENABLE LLP | 39941 | MARATHON ASSET MANAGEMENT, LP | 2017 | first_quarter | BNK | Issues related to PROMESA implementation. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-02-17T17:08:09.593000-05:00 | ||
| 1947812 | VENABLE LLP c2a5fddf-81f7-4f20-9664-8eacfc460567 | Q1 | VENABLE LLP | 39941 | KNIGHTHEAD CAPITAL MANAGEMENT, LLC | 2017 | first_quarter | BNK | Issues relate to PROMESA implementation. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-02-17T17:11:11.110000-05:00 | ||
| 1947813 | VENABLE LLP fa63a0cd-36c6-44e5-aef8-30bf8749c85b | Q1 | VENABLE LLP | 39941 | BLUEMOUNTAIN CAPITAL MANAGEMENT, LLC | 2017 | first_quarter | BNK | Issues related to PROMESA implementation. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-02-17T17:14:12.640000-05:00 | ||
| 1947814 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 6e4e6f34-dc48-4f59-9318-3420d36b73d0 | 1@ | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | MAN | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 15000 | 0 | 1 | 2017-02-21T13:34:37.487000-05:00 | |
| 1947815 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 6e4e6f34-dc48-4f59-9318-3420d36b73d0 | 1@ | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | CPT | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 15000 | 0 | 1 | 2017-02-21T13:34:37.487000-05:00 | |
| 1947816 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 6e4e6f34-dc48-4f59-9318-3420d36b73d0 | 1@ | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | BUD | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 15000 | 0 | 1 | 2017-02-21T13:34:37.487000-05:00 | |
| 1947817 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 6e4e6f34-dc48-4f59-9318-3420d36b73d0 | 1@ | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | TAX | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 15000 | 0 | 1 | 2017-02-21T13:34:37.487000-05:00 | |
| 1947818 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 6e4e6f34-dc48-4f59-9318-3420d36b73d0 | 1@ | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | GOV | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 15000 | 0 | 1 | 2017-02-21T13:34:37.487000-05:00 | |
| 1947819 | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) 6e4e6f34-dc48-4f59-9318-3420d36b73d0 | 1@ | NAVIGATORS GLOBAL LLC (FORMERLY DC NAVIGATORS, LLC) | 85071 | VMWARE, INC. | 2017 | first_quarter | SCI | General issues related to the development, sale of software to both the private and public sector. | HOUSE OF REPRESENTATIVES,SENATE | 15000 | 0 | 1 | 2017-02-21T13:34:37.487000-05:00 | |
| 1947820 | HALLMARK CARDS, INC 05dd56ad-f303-4139-9195-dc66522130b0 | Q1 | HALLMARK CARDS, INC | 401041931 | HALLMARK CARDS, INC | 2017 | first_quarter | TAX | Corporate Tax Reform- No bill number yet- looking at Destination Based Tax System and Corporate reform in general based blue prints. | HOUSE OF REPRESENTATIVES,SENATE,U.S. Postal Service (USPS) | 65000 | 0 | 0 | 2017-02-21T15:48:16.743000-05:00 | |
| 1947821 | HALLMARK CARDS, INC 05dd56ad-f303-4139-9195-dc66522130b0 | Q1 | HALLMARK CARDS, INC | 401041931 | HALLMARK CARDS, INC | 2017 | first_quarter | HCR | No bill number at this time for the repair of the Affordable Care Act. Discussing basic principles of reform to improve the nation's health care system. | HOUSE OF REPRESENTATIVES,SENATE,U.S. Postal Service (USPS) | 65000 | 0 | 0 | 2017-02-21T15:48:16.743000-05:00 | |
| 1947822 | HALLMARK CARDS, INC 05dd56ad-f303-4139-9195-dc66522130b0 | Q1 | HALLMARK CARDS, INC | 401041931 | HALLMARK CARDS, INC | 2017 | first_quarter | POS | House Res. 59- calling for the continuation of 6 day delivery. H.R. 756, the Postal Service Reform Act of 2017. The bill addresses unfunded liabilities of the United States Postal Service (USPS), makes reforms to keep mailing costs affordable for consumers, and encourages innovation, all without additional borrowing capacity from the U.S. taxpayer. | HOUSE OF REPRESENTATIVES,SENATE,U.S. Postal Service (USPS) | 65000 | 0 | 0 | 2017-02-21T15:48:16.743000-05:00 | |
| 1947823 | NOBLE STRATEGIES a91ab1ee-7a47-4bd5-9c1c-bef9662c7cb7 | 1T | NOBLE STRATEGIES | 400582779 | CATFISH FARMERS OF AMERICA | 2017 | first_quarter | AGR | Monitor 2014 Farm Bill implementation with specific emphasis on catfish inspection. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2017-02-21T16:40:21.890000-05:00 | |
| 1947824 | NOBLE STRATEGIES a91ab1ee-7a47-4bd5-9c1c-bef9662c7cb7 | 1T | NOBLE STRATEGIES | 400582779 | CATFISH FARMERS OF AMERICA | 2017 | first_quarter | BUD | Monitor agriculture appropriations development and implementation. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2017-02-21T16:40:21.890000-05:00 | |
| 1947825 | J.A. GREEN AND COMPANY (FORMERLY LLC) a566bf4e-709a-41df-a5c3-6e497985cf44 | 1TY | J.A. GREEN AND COMPANY (FORMERLY LLC) | 313511 | AEROSPACE INDUSTRIES ASSOCIATION | 2017 | first_quarter | 20000 | 0 | 1 | 2017-02-24T14:03:07.793000-05:00 | ||||
| 1947826 | THE SMITH-FREE GROUP, LLC e6941305-942b-4137-bcf1-cdc530be8d2b | 1TY | THE SMITH-FREE GROUP, LLC | 35800 | GENERAL ELECTRIC COMPANY | 2017 | first_quarter | 0 | 1 | 2017-02-24T16:27:31.770000-05:00 | |||||
| 1947827 | THE SMITH-FREE GROUP, LLC 5e0e5ecb-5699-41b8-9831-b7b008a7fb9c | Q1Y | THE SMITH-FREE GROUP, LLC | 35800 | ENTERTAINMENT SOFTWARE ASSOCIATION (ESA) | 2017 | first_quarter | 0 | 0 | 2017-02-24T16:27:33.567000-05:00 | |||||
| 1947828 | CHAMBER HILL STRATEGIES 4246c787-3a86-41b6-8b41-9ba17bc14a7e | Q1 | CHAMBER HILL STRATEGIES | 400645947 | AMERICAN ACADEMY OF ADOPTION ATTORNEYS | 2017 | first_quarter | TAX | Support for permanence and refundability of adoption tax credit. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-24T16:45:37.333000-05:00 | |
| 1947829 | CHAMBER HILL STRATEGIES 4246c787-3a86-41b6-8b41-9ba17bc14a7e | Q1 | CHAMBER HILL STRATEGIES | 400645947 | AMERICAN ACADEMY OF ADOPTION ATTORNEYS | 2017 | first_quarter | FAM | Issues related to international adoption and issues related to the National Electronic Interstate Compact Enterprise. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2017-02-24T16:45:37.333000-05:00 | |
| 1947830 | KOUNTOUPES DENHAM CARR & REID, LLC 74d9da6c-c07d-4ce8-8954-5636960845f2 | 1T | KOUNTOUPES DENHAM CARR & REID, LLC | 320918 | GLASSDOOR, INC. | 2017 | first_quarter | LBR | Wage Equality. | Equal Employment Opportunity Commission (EEOC),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office | 10000 | 0 | 1 | 2017-02-24T16:51:39.023000-05:00 | |
| 1947831 | KOUNTOUPES DENHAM CARR & REID, LLC 74d9da6c-c07d-4ce8-8954-5636960845f2 | 1T | KOUNTOUPES DENHAM CARR & REID, LLC | 320918 | GLASSDOOR, INC. | 2017 | first_quarter | CPI | General education about the company's business model, bringing specificity and transparency to job search. Anti-SLAPP legislation, including H. R. 2304, SPEAK FREE Act and H. R. 2110 and S. 2044, Consumer Review Freedom Act of 2015. | Equal Employment Opportunity Commission (EEOC),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office | 10000 | 0 | 1 | 2017-02-24T16:51:39.023000-05:00 | |
| 1947832 | CHAMBER HILL STRATEGIES b12f10de-bfde-4f60-ae86-befcd5767c4a | Q1 | CHAMBER HILL STRATEGIES | 400645947 | U.S. RENAL CARE | 2017 | first_quarter | MMM | Survey and certification delays for dialysis facilities and policies related to Medicare payment, and policies related to third party payments. | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2017-02-24T17:07:40.727000-05:00 | |
| 1947833 | BARNES & THORNBURG, LLP 50ca30bb-6092-4dab-8f53-2d13ca382d52 | 1T | BARNES & THORNBURG, LLP | 5404 | FEDERATED INVESTORS, INC. | 2017 | first_quarter | FIN | Consumer Financial Choice and Capital Markets Competitiveness Act of 2015 and related financial industry issues. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2017-02-27T11:44:54.670000-05:00 | |
| 1947834 | THE FRANKEN GROUP, LLC 05b38e07-5e35-4519-a5be-5a22f102cd3f | Q1 | THE FRANKEN GROUP, LLC | 400401893 | INDA, ASSOCIATION OF THE NONWOVEN FABRICS INDUSTRY | 2017 | first_quarter | APP | Proposed EU beef retaliation affecting rayon | Commerce, Dept of (DOC),U.S. Trade Representative (USTR) | 0 | 0 | 2017-02-27T12:24:02.380000-05:00 | ||
| 1947835 | THE FRANKEN GROUP, LLC 05b38e07-5e35-4519-a5be-5a22f102cd3f | Q1 | THE FRANKEN GROUP, LLC | 400401893 | INDA, ASSOCIATION OF THE NONWOVEN FABRICS INDUSTRY | 2017 | first_quarter | TAR | Miscellaneous Tariff Bills affecting rayon | Commerce, Dept of (DOC),U.S. Trade Representative (USTR) | 0 | 0 | 2017-02-27T12:24:02.380000-05:00 | ||
| 1947836 | THE FRANKEN GROUP, LLC 05b38e07-5e35-4519-a5be-5a22f102cd3f | Q1 | THE FRANKEN GROUP, LLC | 400401893 | INDA, ASSOCIATION OF THE NONWOVEN FABRICS INDUSTRY | 2017 | first_quarter | TRD | Proposed EU beef retaliation affecting rayon | Commerce, Dept of (DOC),U.S. Trade Representative (USTR) | 0 | 0 | 2017-02-27T12:24:02.380000-05:00 | ||
| 1947837 | THE FRANKEN GROUP, LLC 6c9fe326-bc93-4bdb-b8af-b57e407f6205 | 1A | THE FRANKEN GROUP, LLC | 400401893 | C2 ASSOCIATION STRATEGIES (ON BEHALF OF SMART) (FORMERLY KING MANAGEMENT GROUP) | 2017 | first_quarter | APP | Pending ban on secondhand clothing in East African Community | Commerce, Dept of (DOC),U.S. Trade Representative (USTR) | 0 | 0 | 2017-02-27T18:00:07.357000-05:00 | ||
| 1947838 | THE FRANKEN GROUP, LLC 6c9fe326-bc93-4bdb-b8af-b57e407f6205 | 1A | THE FRANKEN GROUP, LLC | 400401893 | C2 ASSOCIATION STRATEGIES (ON BEHALF OF SMART) (FORMERLY KING MANAGEMENT GROUP) | 2017 | first_quarter | TRD | Pending ban on secondhand clothing in East African Community | Commerce, Dept of (DOC),U.S. Trade Representative (USTR) | 0 | 0 | 2017-02-27T18:00:07.357000-05:00 | ||
| 1947839 | FORSCEY, PLLC 361303f2-cc78-4d91-97de-8dd01766c40e | 1TY | FORSCEY, PLLC | 52880 | ADVENTIST HEALTH SYSTEM | 2017 | first_quarter | 0 | 1 | 2017-03-01T13:01:50.557000-05:00 | |||||
| 1947840 | QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 31ae0d28-7f09-4ac0-b7e1-94e43bd033a0 | 1T | QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) | 54197 | STATE FARM INSURANCE | 2017 | first_quarter | TAX | Tax reform Net operating losses | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2017-03-01T15:50:02.817000-05:00 | |
| 1947841 | QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 31ae0d28-7f09-4ac0-b7e1-94e43bd033a0 | 1T | QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) | 54197 | STATE FARM INSURANCE | 2017 | first_quarter | INS | Flood insurance Capital standards | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2017-03-01T15:50:02.817000-05:00 | |
| 1947842 | QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) eb24e19d-fcde-41d6-9d43-ca44f33b912d | 1T | QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) | 54197 | U S STEEL (FORMERLY LISTED AS ALLIANCE FOR AMERICAN MANUFACTURING) | 2017 | first_quarter | TRD | Trade law enforcement | HOUSE OF REPRESENTATIVES,SENATE | 37500 | 0 | 1 | 2017-03-01T15:56:05.913000-05:00 | |
| 1947843 | W STRATEGIES, LLC ce6ea456-5ac7-4f93-9cde-cb5ffae7606c | 1T | W STRATEGIES, LLC | 400605842 | HORIZON PHARMA USA, INC. | 2017 | first_quarter | HCR | Issues related to orphan drugs and the value of innovative medicines. | 20000 | 0 | 1 | 2017-03-02T08:50:41.673000-05:00 | ||
| 1947844 | UPSTREAM CONSULTING, INC. 289462f3-c81f-4005-b436-83bddeb88666 | 1T | UPSTREAM CONSULTING, INC. | 88278 | MELINTA THERAPEUTICS INC (FKA RIB-X PHARMACEUTICALS INC ) | 2017 | first_quarter | HCR | Medicare Reimbursement | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 1 | 2017-03-02T12:58:56-05:00 | |
| 1947845 | ALASKA WILDERNESS LEAGUE e95c1dc8-bcd2-473b-8fe4-b5d5e7f846b5 | Q1 | ALASKA WILDERNESS LEAGUE | 762 | ALASKA WILDERNESS LEAGUE | 2017 | first_quarter | NAT | Tongass National Forest, Arctic Ocean, Arctic Refuge and National Petroleum Reserve-Alaska | Bureau of Land Management (BLM),Council on Environmental Quality (CEQ),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,U.S. Fish & Wildlife Service (USFWS) | 10000 | 0 | 0 | 2017-03-03T07:08:34.430000-05:00 | |
| 1947846 | THE ART HAMILTON GROUP, LLC 7a2b2f50-4c27-4292-88a1-97b8b2ffedd3 | 1TY | THE ART HAMILTON GROUP, LLC | 400531580 | ARIZONA STATE UNIVERSITY | 2017 | first_quarter | 0 | 1 | 2017-03-04T15:55:36.900000-05:00 | |||||
| 1947847 | THE RUSSELL GROUP, INC. fd6d0baf-8bc8-4734-9bbf-967a2d460694 | 1T | THE RUSSELL GROUP, INC. | 22688 | MCWANE INC. | 2017 | first_quarter | MAN | Issues related to water infrastructure. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2017-03-06T11:44:04.590000-05:00 | ||
| 1947848 | MR. SEBASTIAN O'KELLY 1f7554b3-7c54-4227-ac8b-e79c52ad40ea | 1T | MR. SEBASTIAN O'KELLY | 75810 | ARIANESPACE INC. | 2017 | first_quarter | AER | FY 2017 House & Senate NDAA -- Strategic Forces & EELV Sections FY 2017 House & Senate CJS Approps -- NASA Title FY 2017 House & Senate NASA Authorization Bills | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2017-03-06T11:49:07.937000-05:00 | |
| 1947849 | MADISON SERVICES GROUP, INC ff98dc66-707d-417e-8933-8f040240ed97 | 1TY | MADISON SERVICES GROUP, INC | 74795 | ASSOCIATION OF WOMEN'S BUSINESS CENTERS | 2017 | first_quarter | 0 | 1 | 2017-03-08T12:53:30.993000-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);