lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
159,313 rows where filing_year = 2018 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2101155 | RED+BLUE STRATEGIES c2574941-656c-4d4b-8d64-6dd1b6bb7e8a | 1TY | RED+BLUE STRATEGIES | 400693064 | COHERUS BIOSCIENCES | 2018 | first_quarter | 0 | 1 | 2018-01-02T14:44:51.177000-05:00 | |||||
| 2101156 | TAUZIN CONSULTANTS, LLC bdba834f-a5b3-4e04-bc6b-382caea5b394 | 1TY | TAUZIN CONSULTANTS, LLC | 400671007 | THEODORE (TED) L. JONES, ATTORNEY AT LAW (ON BEHALF OF ST. BERNARD PORT) | 2018 | first_quarter | 0 | 1 | 2018-01-16T11:47:44.933000-05:00 | |||||
| 2101157 | TAUZIN STRATEGIC NETWORKS a11597d3-a4d8-4537-8339-f478520a7638 | 1TY | TAUZIN STRATEGIC NETWORKS | 400786367 | TAUZIN CONSULTANTS (ON BEHALF TED JONES LAW, ON BEHALF OF ST. BERNARD PORT) | 2018 | first_quarter | 0 | 1 | 2018-01-16T12:21:18.407000-05:00 | |||||
| 2101158 | FOLEY HOAG LLP f842f349-9d45-4618-ad6b-ccf7a6b22c4d | 1TY | FOLEY HOAG LLP | 79610 | SPECTRUM PHARMACEUTICALS | 2018 | first_quarter | 0 | 1 | 2018-01-18T10:15:20.733000-05:00 | |||||
| 2101159 | FIDELITY NATIONAL FINANCIAL, INC. 953b2165-a20e-4f5d-acf9-e69d1f67d678 | 1TY | FIDELITY NATIONAL FINANCIAL, INC. | 401103297 | FIDELITY NATIONAL FINANCIAL, INC. | 2018 | first_quarter | 0 | 1 | 2018-01-18T15:57:54.237000-05:00 | |||||
| 2101160 | FIDELITY NATIONAL FINANCIAL, INC. fffa91ec-2a82-42ef-ac0a-2a1eb598b146 | 1@Y | FIDELITY NATIONAL FINANCIAL, INC. | 401103297 | FIDELITY NATIONAL FINANCIAL, INC. | 2018 | first_quarter | 0 | 1 | 2018-01-18T16:08:26.670000-05:00 | |||||
| 2101161 | RENSSELAER POLYTECHNIC INSTITUTE 5aeb9afb-7a95-4717-bb3c-fc7644a7db12 | 1TY | RENSSELAER POLYTECHNIC INSTITUTE | 40025203 | RENSSELAER POLYTECHNIC INSTITUTE | 2018 | first_quarter | 0 | 1 | 2018-01-19T09:46:46.210000-05:00 | |||||
| 2101162 | ALTA CREST LLC 9d21ff42-04a8-4dc5-96b3-df0977535dae | Q1 | ALTA CREST LLC | 401104600 | SANOVAS, INC. | 2018 | first_quarter | FIN | Regulation D reform | HOUSE OF REPRESENTATIVES | 0 | 0 | 2018-01-19T11:49:25.283000-05:00 | ||
| 2101163 | ALTA CREST LLC 9d21ff42-04a8-4dc5-96b3-df0977535dae | Q1 | ALTA CREST LLC | 401104600 | SANOVAS, INC. | 2018 | first_quarter | TAX | Tax reform | HOUSE OF REPRESENTATIVES | 0 | 0 | 2018-01-19T11:49:25.283000-05:00 | ||
| 2101164 | A1.9 STRATEGIES LLC fb114a46-f678-478c-9d04-df246fcf4139 | 1T | A1.9 STRATEGIES LLC | 401104281 | CORNERSTONE GOVERNMENT AFFAIRS OBO CUBIC CORPORATION | 2018 | first_quarter | BUD | Support for Cubic FY17 defense appropriations priorities and U.S. military readiness including virtual and blended training environments. Support for tactical satellite communications systems. | 20000 | 0 | 1 | 2018-01-21T20:11:09.130000-05:00 | ||
| 2101165 | WHW CONSULTING LLC e1974b42-8600-405e-913c-77351e9a6451 | 1TY | WHW CONSULTING LLC | 40025209 | AT&T SERVICES | 2018 | first_quarter | 0 | 1 | 2018-01-22T13:45:55.407000-05:00 | |||||
| 2101166 | BRIDGEPOINT EDUCATION ca419f06-28c2-4df0-be3c-4fe6d23b4c96 | Q1 | BRIDGEPOINT EDUCATION | 400801401 | BRIDGEPOINT EDUCATION | 2018 | first_quarter | EDU | Department of Education Regulations Post 9/11 G.I. Bill Benefits Issues related to re-authorization of the Higher Education Act (PROSPER Act HR 4508) National Defense Authorization Act (H.R. 2810/S.1519) Regulatory Reform Labor, HHS, Education & Related Agencies Appropriations Cybersecurity & Student Data Privacy Tax Cuts & Jobs Act HR 1 (Individual Deductions for Higher Education & Corporate Reforms) | HOUSE OF REPRESENTATIVES,SENATE | 170000 | 0 | 0 | 2018-01-22T15:41:31.800000-05:00 | |
| 2101167 | SCHOLASTIC, INC. 69f6a9b6-c0d3-4450-9f53-f0dbcb85469c | Q1 | SCHOLASTIC, INC. | 40036304 | SCHOLASTIC INC. | 2018 | first_quarter | EDU | Advancing education and literacy issues | Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2018-01-22T17:20:30.337000-05:00 | |
| 2101168 | MERCURY PUBLIC AFFAIRS, LLC 911b272f-7fbf-4d4e-b6a8-95493b8aa661 | 1TY | MERCURY PUBLIC AFFAIRS, LLC | 70175 | AIRBNB | 2018 | first_quarter | 0 | 1 | 2018-01-24T09:51:18.663000-05:00 | |||||
| 2101169 | LAURA HAAS CONSULTING, LLC (FKA KNOX CONSULTING, LLC) b784d3b3-8945-4df3-a598-36529ae0599a | Q1 | LAURA HAAS CONSULTING, LLC (FKA KNOX CONSULTING, LLC) | 400534595 | AMERICAN SHIPBUILDING SUPPLIERS ASSOCIATION | 2018 | first_quarter | DEF | National Defense Authorization Act Defense Appropriations Navy Shipbuilding | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE | 10000 | 0 | 0 | 2018-01-26T09:22:21.073000-05:00 | |
| 2101170 | MERCURY PUBLIC AFFAIRS, LLC f5401cb2-4f7f-43bc-9c96-f29bfdc07c8e | 1TY | MERCURY PUBLIC AFFAIRS, LLC | 70175 | EBAY, INC | 2018 | first_quarter | 0 | 1 | 2018-01-30T09:59:49.277000-05:00 | |||||
| 2101171 | MR. MATTHEW TALLMER 9f9ee44d-5bff-4946-8e31-2c30e528b69e | 1T | MR. MATTHEW TALLMER | 401104627 | VOIP-PAL | 2018 | first_quarter | CPT | PTAB. Patent and Trademark Office | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2018-01-30T10:02:53.543000-05:00 | |
| 2101172 | JEFFREY J. KIMBELL & ASSOCIATES, INC. 273d1e54-8e3c-4186-b0c2-b80377d026ea | 1TY | JEFFREY J. KIMBELL & ASSOCIATES, INC. | 46038 | SORRENTO THERAPEUTICS, INC. | 2018 | first_quarter | 0 | 1 | 2018-01-30T11:01:05.507000-05:00 | |||||
| 2101173 | GARY AND MARY WEST HEALTH INSTITUTE f2867d28-642f-4e8e-80c5-483ee58fb716 | 1TY | GARY AND MARY WEST HEALTH INSTITUTE | 401095058 | GARY AND MARY WEST HEALTH INSTITUTE | 2018 | first_quarter | 0 | 1 | 2018-01-31T10:12:28.803000-05:00 | |||||
| 2101174 | DOUCET CONSULTING SOLUTIONS, LLC 0ae42700-79cb-4b4e-87c4-d6fbf915b0dc | 1TY | DOUCET CONSULTING SOLUTIONS, LLC | 401104418 | NORIDIAN HEALTHCARE SOLUTIONS | 2018 | first_quarter | 10000 | 0 | 1 | 2018-02-01T15:06:50.213000-05:00 | ||||
| 2101175 | THE PICARD GROUP, LLC a33758e0-bf7c-452d-8800-f5007a6c61f9 | 1TY | THE PICARD GROUP, LLC | 400711132 | RESOURCE ENVIRONMENTAL SOLUTIONS | 2018 | first_quarter | 0 | 1 | 2018-02-01T15:55:44.433000-05:00 | |||||
| 2101176 | BRACY TUCKER BROWN & VALANZANO, INC. 9a78401d-8b3e-44dd-9769-06204748899d | 1T | BRACY TUCKER BROWN & VALANZANO, INC. | 6850 | WILLIS NORTH AMERICA INC | 2018 | first_quarter | INS | Monitor the implementation of the reauthorization of Terrorism Risk Insurance Act (TRIA), specifically regarding data collection and the National Assoc. of Registered Agents and Brokers Reform Act, as included in that Act. Also monitor the activities of the FIO Advisory Committee on Alternative Risk Sharing Mechanisms for TRIA. Monitor issues re implementation of health insurance reform, and efforts to repeal and replace the ACA as in the American Health Care and the Graham/Cassidy amendment to the budget reconciliation act (H.R.1628). Support efforts to repeal the Cadillac Tax as in H.R.173, and S.58. Monitor tax reform proposals generally and support efforts to preserve the current tax treatment for employer sponsored health plans and other employee benefits. Support efforts to maintain current treatment of self-insured plans. Monitor the Small Business Health Insurance Act of 2017 (H.R.1101). Monitor efforts to make changes in the Dodd-Frank Act, as they may relate to insurance. Monitor the activities of the Federal Insurance Office and the development of insurance modernization proposals. Monitor issues related to cyber security and the cyber security insurance market, including the House Small Business Committees hearing on cyber insurance for small businesses. Support the clarification of the Foreign Account Tax Compliance Act to exclude property/casualty insurance as in H.R. 871. Support the reauthorization of the National Flood Insurance Program, particularly the Flood Insurance Market Parity and Modernization Act (S. 563 & H.R. 1422), the Repeatedly Flooded Communities Preparation Act (H.R. 1558), the NFIP Policyholder Protection Act of 2017 (H.R. 2868), the 21st Century Flood Reform Act of 2017 (H.R. 2874), the NFIP Administrative Reform Act of 2017 (H.R. 2875), the Taxpayer Exposure Mitigation Act of 2017 (H.R. 2246), and H.R. 2565 requiring use of replacement cost in determining premium rates. Monitor issues related insurance generally. | HOUSE OF REPRESENTATIVES,SENATE | 16000 | 0 | 1 | 2018-02-02T08:55:39.787000-05:00 | |
| 2101177 | BRACY TUCKER BROWN & VALANZANO, INC. 06a26ceb-f487-4ac5-95c2-7210592cf633 | 1T | BRACY TUCKER BROWN & VALANZANO, INC. | 6850 | WILLIS NORTH AMERICA INC | 2018 | first_quarter | INS | Monitor the implementation of the reauthorization of Terrorism Risk Insurance Act (TRIA), specifically regarding data collection and the National Assoc. of Registered Agents and Brokers Reform Act, as included in that Act. Also monitor the activities of the FIO Advisory Committee on Alternative Risk Sharing Mechanisms for TRIA. Monitor issues re implementation of health insurance reform, and efforts to repeal and replace the ACA as in the American Health Care and the Graham/Cassidy amendment to the budget reconciliation act (H.R.1628). Support efforts to repeal the Cadillac Tax as in H.R.173, and S.58. Monitor tax reform proposals generally and support efforts to preserve the current tax treatment for employer sponsored health plans and other employee benefits. Support efforts to maintain current treatment of self-insured plans. Monitor the Small Business Health Insurance Act of 2017 (H.R.1101). Monitor efforts to make changes in the Dodd-Frank Act, as they may relate to insurance. Monitor the activities of the Federal Insurance Office and the development of insurance modernization proposals. Monitor issues related to cyber security and the cyber security insurance market, including the House Small Business Committees hearing on cyber insurance for small businesses. Support the clarification of the Foreign Account Tax Compliance Act to exclude property/casualty insurance as in H.R. 871. Support the reauthorization of the National Flood Insurance Program, particularly the Flood Insurance Market Parity and Modernization Act (S. 563 & H.R. 1422), the Repeatedly Flooded Communities Preparation Act (H.R. 1558), the NFIP Policyholder Protection Act of 2017 (H.R. 2868), the 21st Century Flood Reform Act of 2017 (H.R. 2874), the NFIP Administrative Reform Act of 2017 (H.R. 2875), the Taxpayer Exposure Mitigation Act of 2017 (H.R. 2246), and H.R. 2565 requiring use of replacement cost in determining premium rates. Monitor issues related insurance generally. | HOUSE OF REPRESENTATIVES,SENATE | 16000 | 0 | 1 | 2018-02-02T08:55:41.477000-05:00 | |
| 2101178 | WHITMER & WORRALL, LLC 07b161d2-f82b-4a95-aabd-272a45dafdf2 | 1TY | WHITMER & WORRALL, LLC | 292892 | ASSOCIATION OF AMERICAN RAILROADS | 2018 | first_quarter | 0 | 1 | 2018-02-07T08:57:01.103000-05:00 | |||||
| 2101179 | WHITMER & WORRALL, LLC 65a93318-9f8d-4c92-95b5-4e4d13fd0475 | 1@Y | WHITMER & WORRALL, LLC | 292892 | ASSOCIATION OF AMERICAN RAILROADS | 2018 | first_quarter | 10000 | 0 | 1 | 2018-02-07T10:08:04.290000-05:00 | ||||
| 2101180 | LITTLER MENDELSON 6ee5d4a0-ad94-41b9-95d5-afde070c07e7 | 1TY | LITTLER MENDELSON | 22952 | DAY & ZIMMERMANN | 2018 | first_quarter | 0 | 1 | 2018-02-07T13:52:33.307000-05:00 | |||||
| 2101181 | LITTLER MENDELSON ac2a9643-82e0-45cf-a253-8e896d17fa7b | 1TY | LITTLER MENDELSON | 22952 | FIRSTGROUP AMERICA | 2018 | first_quarter | 0 | 1 | 2018-02-07T13:57:34.883000-05:00 | |||||
| 2101182 | LITTLER MENDELSON fa01445a-240e-4491-9aa6-ba2c9c5ce37c | 1TY | LITTLER MENDELSON | 22952 | NATIONAL EXPRESS LLC | 2018 | first_quarter | 0 | 1 | 2018-02-07T14:02:36.477000-05:00 | |||||
| 2101183 | BOCKORNY GROUP, INC. c7061565-f01b-48f1-b94a-f6173366f64b | 1T | BOCKORNY GROUP, INC. | 289773 | SWIFT FUELS, LLC | 2018 | first_quarter | TAX | Issues related to incentives for the transition to unleaded aviation gas | Environmental Protection Agency (EPA),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 1 | 2018-02-08T15:27:20.153000-05:00 | ||
| 2101184 | BOCKORNY GROUP, INC. c7061565-f01b-48f1-b94a-f6173366f64b | 1T | BOCKORNY GROUP, INC. | 289773 | SWIFT FUELS, LLC | 2018 | first_quarter | AVI | Issues related to FAA's Transition to Unleaded Aviation Gasoline - PAFI Issues related to FAA Reauthorization | Environmental Protection Agency (EPA),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 1 | 2018-02-08T15:27:20.153000-05:00 | ||
| 2101185 | MILLER & CHEVALIER CHARTERED 7f5cda93-ac11-478b-a84d-09b70cc70072 | 1T | MILLER & CHEVALIER CHARTERED | 25306 | FRANKLIN-HAMILTON INC. | 2018 | first_quarter | TRD | Hill and Administrative advocacy for purposes of lifting restrictions upon and otherwise expediting U.S. energy exports. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-09T14:30:07.727000-05:00 | ||
| 2101186 | MILLER & CHEVALIER CHARTERED 7f5cda93-ac11-478b-a84d-09b70cc70072 | 1T | MILLER & CHEVALIER CHARTERED | 25306 | FRANKLIN-HAMILTON INC. | 2018 | first_quarter | ENG | Hill and Administrative advocacy for purposes of lifting restrictions upon and otherwise expediting U.S. energy exports. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-09T14:30:07.727000-05:00 | ||
| 2101187 | WASHINGTON PARTNERS 78269025-a91d-40a4-b6d0-3a8afcad7dc9 | 1T | WASHINGTON PARTNERS | 77355 | ALLIANCE FOR EXCELLENT EDUCATION | 2018 | first_quarter | BUD | H.R. 3354 and S.1771/Final FY 2018 LHHS ED appropriation bill: LEARN Program (ESSA Title II) | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-12T15:15:41.877000-05:00 | ||
| 2101188 | WHITMER & WORRALL, LLC 435d07c0-f44e-4969-b293-cecba79a2970 | 1TY | WHITMER & WORRALL, LLC | 292892 | AMERICAN SHORT LINE AND REGIONAL RAILROAD ASSOCIATION | 2018 | first_quarter | 10000 | 0 | 1 | 2018-02-13T09:38:20.210000-05:00 | ||||
| 2101189 | HARRY KOPP LLC f7fb8d12-fa60-46ce-8f1a-9f9d0bf8e128 | 1TY | HARRY KOPP LLC | 52971 | PHILIPPINE SUGAR ALLIANCE | 2018 | first_quarter | 0 | 1 | 2018-02-13T09:56:22.190000-05:00 | |||||
| 2101190 | HARRY KOPP LLC 4da18f65-3d9a-46e9-b64f-e3ac7819705a | 1TY | HARRY KOPP LLC | 52971 | PHILIPPINE SUGAR ALLIANCE | 2018 | first_quarter | 0 | 1 | 2018-02-13T10:01:23.860000-05:00 | |||||
| 2101191 | ENERGY FOCUS, INC. 56361f7a-b5e5-445e-9836-0e2d8cbf865b | 1T | ENERGY FOCUS, INC. | 401103864 | ENERGY FOCUS, INC. | 2018 | first_quarter | DEF | Defense, Energy | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-13T13:47:47.170000-05:00 | ||
| 2101192 | ENERGY FOCUS, INC. 56361f7a-b5e5-445e-9836-0e2d8cbf865b | 1T | ENERGY FOCUS, INC. | 401103864 | ENERGY FOCUS, INC. | 2018 | first_quarter | GOV | Defense and Energy | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-13T13:47:47.170000-05:00 | ||
| 2101193 | ENERGY FOCUS, INC. f2833ff7-2030-4718-85b2-2ba8ce546e6f | 1@ | ENERGY FOCUS, INC. | 401103864 | ENERGY FOCUS, INC. | 2018 | first_quarter | DEF | Defense, Energy | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-13T13:58:49.870000-05:00 | ||
| 2101194 | ENERGY FOCUS, INC. f2833ff7-2030-4718-85b2-2ba8ce546e6f | 1@ | ENERGY FOCUS, INC. | 401103864 | ENERGY FOCUS, INC. | 2018 | first_quarter | GOV | Defense and Energy | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-13T13:58:49.870000-05:00 | ||
| 2101195 | COGENT STRATEGIES LLC 1cfe1b9f-4757-4434-a809-b8fc2aa6498b | 1TY | COGENT STRATEGIES LLC | 401104684 | NAVIGATE AFFORDABLE HOUSING PARTNERS | 2018 | first_quarter | 0 | 1 | 2018-02-13T15:27:00.673000-05:00 | |||||
| 2101196 | DENTONS US LLP f401e13c-7c43-4e6a-98a6-8b708c16fe15 | 1TY | DENTONS US LLP | 36105 | HASKELL INDIAN NATIONS UNIVERSITY BOARD OF REGENTS | 2018 | first_quarter | 0 | 1 | 2018-02-14T11:36:48.163000-05:00 | |||||
| 2101197 | DENTONS US LLP 88b0eb7d-01f7-48c2-9b2a-c24ba85c8aae | 1TY | DENTONS US LLP | 36105 | MAKAH NATION | 2018 | first_quarter | 0 | 1 | 2018-02-14T11:43:50.583000-05:00 | |||||
| 2101198 | DENTONS US LLP e57b5f30-f3d4-4c93-9abb-8121a040c1c3 | 1TY | DENTONS US LLP | 36105 | MANDAN, HIDATSA, AND ARIKARA NATION | 2018 | first_quarter | 0 | 1 | 2018-02-14T11:46:52.270000-05:00 | |||||
| 2101199 | BETHANY CHRISTIAN SERVICES ca308b44-3a01-4f32-9033-20bff6b8f2bf | 1TY | BETHANY CHRISTIAN SERVICES | 401104754 | BETHANY CHRISTIAN SERVICES | 2018 | first_quarter | 0 | 1 | 2018-02-14T12:26:59.557000-05:00 | |||||
| 2101200 | DENTONS US LLP ff079746-b4d2-4618-98d0-970a9158db61 | 1T | DENTONS US LLP | 36105 | NATIONAL SEAFOOD MARKETING COALITION | 2018 | first_quarter | NAT | S.1322- American Fisheries Advisory Committee Act, H.R. 214- American Fisheries Advisory Committee Act | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-15T14:26:23.953000-05:00 | ||
| 2101201 | DENTONS US LLP 7f48fc6e-57a5-4018-8162-3c3f288e19dc | 1T | DENTONS US LLP | 36105 | PACIFIC SEAFOOD | 2018 | first_quarter | NAT | H.R. 200 | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-15T14:28:25.610000-05:00 | ||
| 2101202 | DENTONS US LLP ba5ca47d-0f9a-4442-ae06-11d52a9f6c94 | 1T | DENTONS US LLP | 36105 | GROUNDFISH FORUM | 2018 | first_quarter | MAR | Fishery regulation H.R. 200; Magnuson-Stevens Act; maritime regulation, Coast Guard authorization S.1129, H.R. 1726 | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Coast Guard (USCG) | 10000 | 0 | 1 | 2018-02-15T14:30:27.407000-05:00 | |
| 2101203 | DENTONS US LLP 773fcbd1-04ed-428d-8a5f-849fcb21e459 | 1T | DENTONS US LLP | 36105 | ALASKA BERING SEA CRABBERS | 2018 | first_quarter | MAR | Magnuson-Stevens Act; Seafood certification legislation; H.R. 200, legislative issues related to international fisheries; Coast Guard legislation, S. 1129, H.R. 1726 | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,U.S. Coast Guard (USCG) | 10000 | 0 | 1 | 2018-02-15T14:32:29.297000-05:00 | |
| 2101204 | CARD & ASSOCIATES, LLC ad1973ce-8fcd-4290-b4eb-c4edb3edbead | 1T | CARD & ASSOCIATES, LLC | 84217 | J. RONALD TERWILLIGER | 2018 | first_quarter | HOU | Housing/rental affordability issues Support expansion of low income housing tax credit | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-02-15T14:51:36.650000-05:00 | |
| 2101205 | CARD & ASSOCIATES, LLC a769bf2b-d497-4572-8608-31e9cef16fed | Q1 | CARD & ASSOCIATES, LLC | 84217 | BROOKS BAWDEN LLC FOR VIGILANT SOLUTIONS INC. | 2018 | first_quarter | TRA | FY 2018 Transportation, Housing and Urban Development and Related Agencies Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2018-02-15T14:55:38.117000-05:00 | |
| 2101206 | CARD & ASSOCIATES, LLC a769bf2b-d497-4572-8608-31e9cef16fed | Q1 | CARD & ASSOCIATES, LLC | 84217 | BROOKS BAWDEN LLC FOR VIGILANT SOLUTIONS INC. | 2018 | first_quarter | HOM | FY 2018 Homeland Security Appropriations Congressional oversight of privacy and technology issues FY 2018 Budget | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2018-02-15T14:55:38.117000-05:00 | |
| 2101207 | MR. D. RANDALL BENN feea381d-004b-4ca3-a65f-202ab362cecf | 1T | MR. D. RANDALL BENN | 400430087 | NATIONAL ASSOCIATION OF CLEAN WATER AGENCIES | 2018 | first_quarter | ENV | Seeking amendments to the Clean Water Act to elevate State and local utilities to full federal partners and to maximize the use of CWA tools. | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-15T16:48:56.790000-05:00 | ||
| 2101208 | POLICY DEVELOPMENT GROUP 91c28ae3-36e0-4747-9cca-67c8d9c1f01f | 1T | POLICY DEVELOPMENT GROUP | 31736 | SECURED FINANCIAL SOLUTIONS | 2018 | first_quarter | FIN | insurance regulations | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-02-16T13:22:40.377000-05:00 | ||
| 2101209 | DENTONS US LLP a3aefc1d-e529-40f2-824e-44baceec291e | 1T | DENTONS US LLP | 36105 | AMERICAN CHEMISTRY COUNCIL | 2018 | first_quarter | TRA | Legislation related to transportation and regulation. FAA Reauthorization Act; S. 1405, H.R. 1726 | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 10000 | 0 | 1 | 2018-02-16T16:25:43.703000-05:00 | |
| 2101210 | DENTONS US LLP da1e8140-4c59-4d4e-9d5b-4a46c3da4d05 | 1T | DENTONS US LLP | 36105 | KOOTENAI TRIBE OF IDAHO | 2018 | first_quarter | NAT | Reintroduction of wildfire disaster funding legislation; general forestry and natural resources issues. S. 1842, H.R. 2862; 2018 Farm Bill | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-02-16T16:26:45.313000-05:00 | |
| 2101211 | DENTONS US LLP fa673ba7-125e-4b94-8f7f-9cbda7d87a24 | 1T | DENTONS US LLP | 36105 | LUMMI NATION | 2018 | first_quarter | TAX | Tax reform issues, H.R. 3597 | Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),SENATE | 20000 | 0 | 1 | 2018-02-16T16:28:46.813000-05:00 | |
| 2101212 | DENTONS US LLP fa673ba7-125e-4b94-8f7f-9cbda7d87a24 | 1T | DENTONS US LLP | 36105 | LUMMI NATION | 2018 | first_quarter | MAR | Magnuson Stevens Act; Endangered Species Act; treaty fishing rights; 2018 Farm Bill | Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),SENATE | 20000 | 0 | 1 | 2018-02-16T16:28:46.813000-05:00 | |
| 2101213 | DENTONS US LLP fa673ba7-125e-4b94-8f7f-9cbda7d87a24 | 1T | DENTONS US LLP | 36105 | LUMMI NATION | 2018 | first_quarter | IND | General Indian affairs issues; 2018 Farm Bill | Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),SENATE | 20000 | 0 | 1 | 2018-02-16T16:28:46.813000-05:00 | |
| 2101214 | DENTONS US LLP c93550c7-69ac-4ade-bf74-d7ab9a8c3a1b | 1T | DENTONS US LLP | 36105 | NOOKSACK INDIAN TRIBE | 2018 | first_quarter | IND | Federal government relations monitoring related to Indian nations | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 10000 | 0 | 1 | 2018-02-16T16:30:48.357000-05:00 | |
| 2101215 | ASSOCIATION OF THE UNITED STATES NAVY 957b76d9-091b-4abe-b40b-727cf4db84e6 | Q1 | ASSOCIATION OF THE UNITED STATES NAVY | 400894615 | ASSOCIATION OF THE UNITED STATES NAVY | 2018 | first_quarter | HOM | Medical Records | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 2018-02-17T00:19:29.600000-05:00 | ||
| 2101216 | ASSOCIATION OF THE UNITED STATES NAVY 957b76d9-091b-4abe-b40b-727cf4db84e6 | Q1 | ASSOCIATION OF THE UNITED STATES NAVY | 400894615 | ASSOCIATION OF THE UNITED STATES NAVY | 2018 | first_quarter | DEF | NDAA | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 2018-02-17T00:19:29.600000-05:00 | ||
| 2101217 | ASSOCIATION OF THE UNITED STATES NAVY 957b76d9-091b-4abe-b40b-727cf4db84e6 | Q1 | ASSOCIATION OF THE UNITED STATES NAVY | 400894615 | ASSOCIATION OF THE UNITED STATES NAVY | 2018 | first_quarter | VET | Veteran Issues | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 2018-02-17T00:19:29.600000-05:00 | ||
| 2101218 | DENTONS US LLP 95986ea3-7427-4ae7-881b-34701f0fe70a | 1T | DENTONS US LLP | 36105 | AMERICAN SEAFOODS GROUP | 2018 | first_quarter | MAR | Magnuson-Stevens Fishery Conservation and Management Act Reauthorization, H.R. 200 | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-02-20T11:41:06.337000-05:00 | |
| 2101219 | DENTONS US LLP a158d357-3414-4d05-8243-8a685aff81e1 | 1T | DENTONS US LLP | 36105 | ACADEMY OF MODEL AERONAUTICS | 2018 | first_quarter | AVI | FAA Reauthorization S. 1405, H.R. 2997; regulation of model aircraft and drones. | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 10000 | 0 | 1 | 2018-02-20T11:43:07.963000-05:00 | |
| 2101220 | DENTONS US LLP 7a1d99bc-ed05-41ca-807c-e6d4a9c42926 | 1T | DENTONS US LLP | 36105 | INTERNATIONAL ASSOCIATION OF GEOPHYSICAL CONTRACTORS | 2018 | first_quarter | NAT | Issues impacting offshore seismic activities. H.R. 3133, streamline permitting to increase economic development and support coastal restoration programs. H.R. 4239-SECURE American Energy Act. | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 10000 | 0 | 1 | 2018-02-20T11:45:09.713000-05:00 | |
| 2101221 | DENTONS US LLP 9e505dc7-b9b4-43cf-b2ba-3486da43aac9 | 1T | DENTONS US LLP | 36105 | CALISTA CORPORATION | 2018 | first_quarter | ENG | General issues related to energy development | Energy, Dept of,HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 20000 | 0 | 1 | 2018-02-20T11:47:11.323000-05:00 | |
| 2101222 | DENTONS US LLP 9e505dc7-b9b4-43cf-b2ba-3486da43aac9 | 1T | DENTONS US LLP | 36105 | CALISTA CORPORATION | 2018 | first_quarter | TRA | Infrastructure development and issues related to government contracting and taxation. Senate Budget Act provisions relating to opening the Arctic National Wildlife Refugee to energy exploration and development | Energy, Dept of,HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 20000 | 0 | 1 | 2018-02-20T11:47:11.323000-05:00 | |
| 2101223 | WARNER MUSIC GROUP 1da7310f-16ed-43b0-87d0-af7f6b47d2a4 | 1TY | WARNER MUSIC GROUP | 298592 | WARNER MUSIC GROUP | 2018 | first_quarter | 0 | 1 | 2018-02-20T13:39:27.743000-05:00 | |||||
| 2101224 | LEGAL STRATEGIES & CONSULTING, PL 547cb082-27b6-4d06-b2a4-1f76bb06c513 | 1T | LEGAL STRATEGIES & CONSULTING, PL | 401104660 | SIESTA KEY RUM DISTILLERY | 2018 | first_quarter | TAX | Advocacy for HR 747, and addition of HR 747 language to the tax package | HOUSE OF REPRESENTATIVES | 0 | 1 | 2018-02-22T10:54:20.127000-05:00 | ||
| 2101225 | LEGAL STRATEGIES & CONSULTING, PL 350c03d0-3da6-4757-88d7-6a9f91986213 | 1T | LEGAL STRATEGIES & CONSULTING, PL | 401104660 | ST. AUGUSTINE DISTILLERY | 2018 | first_quarter | TAX | Advocacy for HR 747 and inclusion of HR 747 into overall tax package. | HOUSE OF REPRESENTATIVES | 0 | 1 | 2018-02-22T10:56:21.753000-05:00 | ||
| 2101226 | LEGAL STRATEGIES & CONSULTING, PL 02390d99-a719-4d9f-b4d6-bc940a49a56a | 1T | LEGAL STRATEGIES & CONSULTING, PL | 401104660 | SARASOTA COUNTY, FLORIDA | 2018 | first_quarter | TAX | Issues related to the tax reform package. | HOUSE OF REPRESENTATIVES | 0 | 1 | 2018-02-22T10:57:23.287000-05:00 | ||
| 2101227 | MORGAN, LEWIS & BOCKIUS, LLP 1765e205-b51b-4ab5-81d8-aee847640fa7 | 1T | MORGAN, LEWIS & BOCKIUS, LLP | 25818 | ALLIED UNIVERSAL "FKA" ALLIEDBARTON SECURITY SERVICES | 2018 | first_quarter | LAW | Background checks for private security officers, including S. 705, the Child Protection Improvements Act of 2017. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-02-23T11:02:39.847000-05:00 | |
| 2101228 | MORGAN, LEWIS & BOCKIUS, LLP 845c15d9-918e-47c6-9cd8-2703143a7ceb | 1T | MORGAN, LEWIS & BOCKIUS, LLP | 25818 | ARTICHOKE JOE'S CASINO | 2018 | first_quarter | GAM | Gaming issue of relevance to potential and pending projects in the San Fransisco Bay region, including H.R. 597, the Lytton Rancheria Homelands Act of 2017. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-02-23T11:05:41.313000-05:00 | |
| 2101229 | MORGAN, LEWIS & BOCKIUS, LLP ddc0ba5b-ac3c-4ac1-b762-0d2362fe5715 | 1T | MORGAN, LEWIS & BOCKIUS, LLP | 25818 | ALTRIA CLIENT SERVICES LLC | 2018 | first_quarter | TOB | Policies related to the regulation of tobacco products | SENATE | 10000 | 0 | 1 | 2018-02-23T11:07:43.720000-05:00 | |
| 2101230 | MORGAN, LEWIS & BOCKIUS, LLP f10a2876-0c73-480e-b403-f789b7988969 | 1T | MORGAN, LEWIS & BOCKIUS, LLP | 25818 | DRAFTKINGS, INC. | 2018 | first_quarter | SPO | Issues related to fantasy sports | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2018-02-23T11:09:45.360000-05:00 | |
| 2101231 | MORGAN, LEWIS & BOCKIUS, LLP 91b5a264-65d9-4d16-91ba-bcff799f2c5d | 1T | MORGAN, LEWIS & BOCKIUS, LLP | 25818 | GOOGLE INC. | 2018 | first_quarter | TEC | Technology Issues | SENATE | 10000 | 0 | 1 | 2018-02-23T11:10:46.923000-05:00 | |
| 2101232 | MORGAN, LEWIS & BOCKIUS, LLP 6c00b3ac-460e-41c4-9bff-3b5f06bbd9ca | 1T | MORGAN, LEWIS & BOCKIUS, LLP | 25818 | NEUSTAR, INC. | 2018 | first_quarter | TEC | ICANN Related Issues, cybersecurity issues, critical infrastructure protection issues, and telephone numbering issues. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-02-23T11:12:48.657000-05:00 | |
| 2101233 | SWENSON STRATEGIES, INC. 95818fbc-0cde-4d4a-97fd-bdf1ef1f65af | Q1 | SWENSON STRATEGIES, INC. | 401032914 | UTAH SHARED ACCESS ALLIANCE | 2018 | first_quarter | NAT | Advocacy for responsible and improved off-road vehicle use on public lands. | Bureau of Land Management (BLM),HOUSE OF REPRESENTATIVES,SENATE,U.S. Forest Service | 0 | 0 | 2018-02-23T13:35:20.753000-05:00 | ||
| 2101234 | SWENSON STRATEGIES, INC. ca835401-3559-47e7-a18f-eaba4f0e4a37 | Q1Y | SWENSON STRATEGIES, INC. | 401032914 | UTAH ALUNITE CORPORATION | 2018 | first_quarter | 37500 | 0 | 0 | 2018-02-23T13:49:35.990000-05:00 | ||||
| 2101235 | SWENSON STRATEGIES, INC. 82bab5f0-84d0-4623-8bb1-00464c67498f | 1AY | SWENSON STRATEGIES, INC. | 401032914 | UTAH ALUNITE CORPORATION | 2018 | first_quarter | 37500 | 0 | 0 | 2018-02-23T14:33:50.603000-05:00 | ||||
| 2101236 | VENABLE LLP c33cdb26-15e8-4af1-ad37-8c3c64f07fe3 | 1TY | VENABLE LLP | 39941 | CORN REFINERS ASSOCIATION | 2018 | first_quarter | 0 | 1 | 2018-02-23T15:48:05.473000-05:00 | |||||
| 2101237 | WEXLER | WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC c179fa12-d52a-4ec9-8ea4-845454a87710 | 1TY | WEXLER | WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC | 41113 | PERSHING SQUARE CAPITAL MANAGEMENT, L.P. | 2018 | first_quarter | 10000 | 0 | 1 | 2018-02-28T13:09:35.030000-05:00 | ||||
| 2101238 | WINDSTREAM SERVICES LLC 7bf13dfb-8fc3-4f12-b96d-2d6e58832f6b | 1T | WINDSTREAM SERVICES LLC | 316376 | WINDSTREAM SERVICES LLC | 2018 | first_quarter | TEC | Issues related to rural broadband deployment and modernization; issues related to universal service and intercarrier compensation reform, including phases 1 and 2 of the Connect America Fund; issues related to Business Data Services rates, terms & conditions; and issues related to govt-owned networks. Gigabit Opportunity Act (S.1013 & H.R. 2870); H.R. 290, Federal Communications Commission Process Reform Act of 2017; H.R. 460, Improving Rural Call Quality and Reliability Act of 2017; S. 19, MOBILE NOW Act; and S. 96, Improving Rural Call Quality and Reliability Act of 2017. | HOUSE OF REPRESENTATIVES,SENATE | 80000 | 0 | 1 | 2018-02-28T15:02:45.437000-05:00 | |
| 2101239 | CYRRUS ANALYTICS LLC 4df8f440-c3bf-4329-bbfb-0940a4676fb3 | 1T | CYRRUS ANALYTICS LLC | 401103558 | AMAZON WEB SERVICES | 2018 | first_quarter | GOV | Federal IT procurement reform; cloud computing; federal information security. Modernizing Government Technology Act HR2227/S990. Extension to the Federal IT Acquisition Reform Act. | General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA),White House Office | 20000 | 0 | 1 | 2018-03-01T09:35:10.567000-05:00 | |
| 2101240 | LIBERTY GOVERNMENT AFFAIRS 8563003f-72d0-46a8-8213-73a7344a5b69 | 1T | LIBERTY GOVERNMENT AFFAIRS | 401104531 | AMERICAN CIVIL LIBERTIES UNION (ALCU) | 2018 | first_quarter | CIV | Sec. 702 of FISA Reauthorization | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-03-01T11:48:31.483000-05:00 | |
| 2101241 | BLUE STAR STRATEGIES LLC bb4849b7-45cd-4aa4-a4d9-29c7ac96075b | 1TY | BLUE STAR STRATEGIES LLC | 400604838 | ABLV ADVISORY SERVICES, SIA | 2018 | first_quarter | 0 | 1 | 2018-03-01T11:55:33.657000-05:00 | |||||
| 2101242 | RUFFALO AND ASSOCIATES, LLC 8bb46089-fa62-4557-9f3d-3a580451ad9f | 1T | RUFFALO AND ASSOCIATES, LLC | 291572 | VIGILANT SOLUTIONS | 2018 | first_quarter | LAW | Senate - FY2018 Department of Homeland Security appropriations bill - no bill number at this time House - HR 3354 - the Making America Secure and Prosperous Appropriations Act | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2018-03-02T09:30:23.603000-05:00 | |
| 2101243 | CG TECHNOLOGIES INC. 11cd55f9-da7a-4dd1-9169-94406666f4c1 | 1TY | CG TECHNOLOGIES INC. | 300572 | AVION SOLUTIONS | 2018 | first_quarter | 0 | 1 | 2018-03-02T14:56:36.217000-05:00 | |||||
| 2101244 | CG TECHNOLOGIES INC. a246bfdb-2a2f-41b3-b03e-7ee90ebdf17a | 1TY | CG TECHNOLOGIES INC. | 300572 | DYNETICS INC | 2018 | first_quarter | 0 | 1 | 2018-03-02T15:00:38.137000-05:00 | |||||
| 2101245 | CG TECHNOLOGIES INC. 6e6e3811-aaa6-4bf4-9460-a7edad025a7d | 1TY | CG TECHNOLOGIES INC. | 300572 | GENERAL ATOMICS ELECTROMAGNETIC SYSTEMS | 2018 | first_quarter | 0 | 1 | 2018-03-02T15:03:39.890000-05:00 | |||||
| 2101246 | HARLOW GOVERNMENT RELATIONS LLC e8976b4a-5f38-46f9-ab1b-8b36ef50ee90 | 1TY | HARLOW GOVERNMENT RELATIONS LLC | 400745232 | CONOCOPHILLIPS | 2018 | first_quarter | 20000 | 0 | 1 | 2018-03-02T16:28:43.493000-05:00 | ||||
| 2101247 | NEXUS GOVERNMENT RELATIONS da36296d-3083-46aa-b3b9-a3e50250938b | 1T | NEXUS GOVERNMENT RELATIONS | 401103115 | WATER ENVIRONMENT FEDERATION | 2018 | first_quarter | BUD | FY19 Interior and Environment Appropriations for Clean Water SRF, WIFIA, federal funding for infrastructure, and funding for federal agencies. | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,U.S. Geological Survey (USGS) | 30000 | 0 | 1 | 2018-03-04T12:18:19.560000-05:00 | |
| 2101248 | NEXUS GOVERNMENT RELATIONS da36296d-3083-46aa-b3b9-a3e50250938b | 1T | NEXUS GOVERNMENT RELATIONS | 401103115 | WATER ENVIRONMENT FEDERATION | 2018 | first_quarter | CAW | Federal policies regarding water infrastructure, public health, environmental protection and economic development. | Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,U.S. Geological Survey (USGS) | 30000 | 0 | 1 | 2018-03-04T12:18:19.560000-05:00 | |
| 2101249 | JEFFREY J. KIMBELL & ASSOCIATES, INC. 6551091d-ad28-4ca4-8a57-6b42b1fa62be | 1T | JEFFREY J. KIMBELL & ASSOCIATES, INC. | 46038 | FUJIREBIO DIAGNOSTICS, INC. | 2018 | first_quarter | TAX | HR 184, Protect Medical Innovation Act of 2017/S.108 - Medical Device Access and Innovation Protection Act | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-03-05T12:18:07.913000-05:00 | ||
| 2101250 | JEFFREY J. KIMBELL & ASSOCIATES, INC. 6551091d-ad28-4ca4-8a57-6b42b1fa62be | 1T | JEFFREY J. KIMBELL & ASSOCIATES, INC. | 46038 | FUJIREBIO DIAGNOSTICS, INC. | 2018 | first_quarter | MED | Issues related to medical devices and lab developed tests. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2018-03-05T12:18:07.913000-05:00 | ||
| 2101251 | NATIONAL UTILITY CONTRACTORS ASSOCIATION f57c743d-4591-456d-9ce7-1f7d44e43642 | 1TY | NATIONAL UTILITY CONTRACTORS ASSOCIATION | 28743 | NATIONAL UTILITY CONTRACTORS ASSOCIATION | 2018 | first_quarter | 60000 | 0 | 1 | 2018-03-05T14:01:17.270000-05:00 | ||||
| 2101252 | ALPHA ONE FOUNDATION 335ff941-5072-4340-9c0b-3d0ef0a162d1 | Q1 | ALPHA ONE FOUNDATION | 61675 | ALPHA ONE FOUNDATION | 2018 | first_quarter | HCR | Alpha-1 Antitrypsin Deficiency Awareness | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2018-03-05T15:59:24.313000-05:00 | ||
| 2101253 | ROBERTI GLOBAL (F/K/A ROBERTI WHITE, LLC) 601f924b-25f6-4359-8f69-43305f312802 | 1TY | ROBERTI GLOBAL (F/K/A ROBERTI WHITE, LLC) | 400762305 | EMD SERONO INC. | 2018 | first_quarter | 0 | 1 | 2018-03-05T16:06:26.877000-05:00 | |||||
| 2101254 | PAVLUCHUK & ASSOCIATES 1986d75e-9b20-4cfd-a32a-2a95600b21e4 | 1T | PAVLUCHUK & ASSOCIATES | 400559668 | ASSOCIATION FOR COMMUTER TRANSPORTATION | 2018 | first_quarter | TRA | infrastructure bill - investment in TDM FAST ACT follow up Increased access for employers into the planning process | Federal Highway Administration (FHA),Federal Transit Administration (FTA),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2018-03-06T14:09:15.663000-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);