lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
81,241 rows where filing_year = 2007 sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: filing_type, is_termination, received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 502652 | SMITH GARSON FKA SMITH DAWSON & ANDREWS 2623b646-51a5-42ad-85fa-09869015b09b | MT | SMITH GARSON FKA SMITH DAWSON & ANDREWS | 35707 | WESTERN UNION FINANCIAL SERVICES INC | 2007 | mid_year | FIN | 22500 | 0 | 0 | 2006-08-10T00:00:00-04:00 | |||
| 502653 | THE UNIVERSITY OF AKRON 5e34ca97-11cd-4205-b528-43a61788e325 | MMY | THE UNIVERSITY OF AKRON | 288134 | UNIVERSITY OF AKRON | 2007 | mid_year | 0 | 0 | 0 | 2006-10-25T00:00:00-04:00 | ||||
| 502654 | CAPITOL ASSOCIATES, INC. 47d84d06-e7a3-4459-ab73-0151d4d500a0 | MT | CAPITOL ASSOCIATES, INC. | 8101 | GREYSTONE GROUP (MINOT STATE UNIV) | 2007 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-01-12T00:00:00-05:00 | ||
| 502655 | MICHELLE DOYLE EDUCATIONAL CONSULTING, LLC 26bef2f1-984b-4eba-b0b8-d1320a970bc7 | MMY | MICHELLE DOYLE EDUCATIONAL CONSULTING, LLC | 302335 | CATAPULT LEARNING LLC | 2007 | mid_year | 0 | 0 | 2007-01-12T00:00:00-05:00 | |||||
| 502656 | MICHELLE DOYLE EDUCATIONAL CONSULTING, LLC efa8960c-9176-45d3-80f2-754c393b18f4 | MA | MICHELLE DOYLE EDUCATIONAL CONSULTING, LLC | 302335 | CATAPULT LEARNING LLC | 2007 | mid_year | 0 | 0 | 2007-01-12T00:00:00-05:00 | |||||
| 502657 | HILDEBRAND TEWES CONSULTING 4d91e196-64a5-40f0-a30a-9b4a119e8a63 | MT | HILDEBRAND TEWES CONSULTING | 299070 | ENVIRONMENTAL DEFENSE | 2007 | mid_year | ENV | S. 139 Lieberman-McCain Climate Stewardship Act - all provisions | SENATE | 0 | 0 | 2007-01-16T00:00:00-05:00 | ||
| 502658 | G. THOMAS CATOR bb2fd626-3551-4be8-85de-191d50a4a0b4 | YT | G. THOMAS CATOR | 50672 | COALITION FOR FAIR LUMBER IMPORTS | 2007 | year_end | TRD | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 60000 | 0 | 0 | 2007-01-22T00:00:00-05:00 | ||
| 502659 | ANDERSON, PATRICK 6a2100f9-c350-4c08-a198-d75080c55352 | MTY | ANDERSON, PATRICK | 312895 | SAN ANTONIO TRADE GROUP | 2007 | mid_year | BAN | Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-02-01T00:00:00-05:00 | ||
| 502660 | ANDERSON, PATRICK 6a2100f9-c350-4c08-a198-d75080c55352 | MTY | ANDERSON, PATRICK | 312895 | SAN ANTONIO TRADE GROUP | 2007 | mid_year | IMM | Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-02-01T00:00:00-05:00 | ||
| 502661 | GALLATIN PUBLIC AFFAIRS 0034ca82-a934-4647-8513-0186221f0881 | MT | GALLATIN PUBLIC AFFAIRS | 15747 | CONSERVATION FUND | 2007 | mid_year | 0 | 0 | 2007-02-01T12:47:54-05:00 | |||||
| 502662 | GALLATIN PUBLIC AFFAIRS 73995784-9d57-4cce-8746-c660683041e2 | MT | GALLATIN PUBLIC AFFAIRS | 15747 | MICROSOFT CORP | 2007 | mid_year | 0 | 0 | 2007-02-01T12:50:55-05:00 | |||||
| 502663 | GALLATIN PUBLIC AFFAIRS 9a4dc318-d4b3-4165-b9a2-241941473fd7 | MT | GALLATIN PUBLIC AFFAIRS | 15747 | HOFFMAN-LAROCHE | 2007 | mid_year | MMM | End Stage Rental Disease funding, Patent Process Reform | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-01T17:49:58-05:00 | ||
| 502664 | GALLATIN PUBLIC AFFAIRS 492643f1-7655-4766-91b9-b1877e33129a | MT | GALLATIN PUBLIC AFFAIRS | 15747 | TWIN FALLS COALITON | 2007 | mid_year | ECN | Federal Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-01T17:52:01-05:00 | ||
| 502665 | GALLATIN PUBLIC AFFAIRS de438c4a-1c58-4b20-9bc8-36aabdddb83e | MT | GALLATIN PUBLIC AFFAIRS | 15747 | ENERGYSOLUTIONS | 2007 | mid_year | ENG | GNEP, Energy and Water Appropriations, | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-01T17:55:06-05:00 | ||
| 502666 | GALLATIN PUBLIC AFFAIRS 312d11e5-3c94-4c01-ab6d-86e52e2bc9cd | MT | GALLATIN PUBLIC AFFAIRS | 15747 | AMI SEMICONDUCTOR | 2007 | mid_year | CPI | DOD Appropriations, DoD Authorization, Tax, Trade | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-01T18:00:10-05:00 | ||
| 502667 | GALLATIN PUBLIC AFFAIRS 1666904a-d13a-47cb-8f71-c8d714c9ed42 | MT | GALLATIN PUBLIC AFFAIRS | 15747 | OFFICEMAX | 2007 | mid_year | SMB | Contract bundling, small business set-aside requirement, SRBA | HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Small Business Administration (SBA) | 0 | 0 | 2007-02-01T18:17:15-05:00 | ||
| 502668 | MARSHALL BRACHMAN 064a05d8-3a2f-40fd-9c16-884df44377dc | MTY | MARSHALL BRACHMAN | 6848 | NORTHROP GRUMMAN CORP | 2007 | mid_year | 0 | 0 | 0 | 2007-02-05T00:00:00-05:00 | ||||
| 502669 | TRADE PARTNERSHIP WORLDWIDE, LLC 773a0b9d-ab05-4841-a8a2-12aea842425c | YT | TRADE PARTNERSHIP WORLDWIDE, LLC | 76376 | CITAC FOUNDATION | 2007 | year_end | TRD | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-02-06T00:00:00-05:00 | ||
| 502670 | KRIVIT AND KRIVIT P.C. 9f2336ca-f9fb-4e32-8c6f-533da6c27705 | MA | KRIVIT AND KRIVIT P.C. | 66614 | TOWNSHIP OF MAPLEWOOD NEW JERSEY | 2007 | mid_year | ENV | Appropriations for environmental infrastructure for the Township of Kearny. | 20000 | 0 | 0 | 2007-02-08T00:00:00-05:00 | ||
| 502671 | KRIVIT AND KRIVIT P.C. 9f2336ca-f9fb-4e32-8c6f-533da6c27705 | MA | KRIVIT AND KRIVIT P.C. | 66614 | TOWNSHIP OF MAPLEWOOD NEW JERSEY | 2007 | mid_year | LAW | Appropriations to assist acquisition of law enforcement technology for the Township of Kearny Police Department. | 20000 | 0 | 0 | 2007-02-08T00:00:00-05:00 | ||
| 502672 | ACG ADVOCACY d814503e-a402-4b20-bdf5-38850d6e4eb5 | YT | ACG ADVOCACY | 2057 | ADVANCED TECHNOLOGY INSTITUTE | 2007 | year_end | DEF | HR5631; General Defense Issues | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2007-02-08T00:00:00-05:00 | |
| 502673 | ACG ADVOCACY d814503e-a402-4b20-bdf5-38850d6e4eb5 | YT | ACG ADVOCACY | 2057 | ADVANCED TECHNOLOGY INSTITUTE | 2007 | year_end | BUD | Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2007-02-08T00:00:00-05:00 | |
| 502674 | THE WASHINGTON GROUP 9c736c5e-4c2c-4c0f-b0dd-3049a735ad34 | MT | THE WASHINGTON GROUP | 40555 | THERAGENICS CORP | 2007 | mid_year | 0 | 0 | 2007-02-08T09:50:35-05:00 | |||||
| 502675 | CYBER SECURITY RESEARCH CONSULTANTS, LLC 4b960498-541f-40a0-bdc3-46855d6abc4b | MT | CYBER SECURITY RESEARCH CONSULTANTS, LLC | 91694 | LIVINGSTON GROUP (PARTNERSHIP FOR A DRUG FREE AMERICA) | 2007 | mid_year | TRA | Transportation Appropriations (Media Campaign) | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-08T14:11:43-05:00 | ||
| 502676 | AMERICAN COTTON SHIPPERS ASSOCIATION 5423582e-94ab-425a-a512-a984168f0d2b | MM | AMERICAN COTTON SHIPPERS ASSOCIATION | 2070 | AMERICAN COTTON SHIPPERS ASSOCIATION | 2007 | mid_year | AGR | -Imbalance between the value of the Chinese Yuan and U.S. Dollar -Re-concentration of upland cotton under the Commodity Credit Corporation Loan -Doha Round of World Trade Organization: Export Credit Financing Program -Repeal of Export Credit Guarantee Program -Competitive provision of upland cotton marketing loan -Surge of textile imports from the People's Republic of China | Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2007-02-08T14:35:45-05:00 | ||
| 502677 | W.B. DRIGGERS AND ASSOCIATES, INC. 4c2023b5-41c5-4c27-9f0e-7585232dce56 | MT | W.B. DRIGGERS AND ASSOCIATES, INC. | 45857 | GROUP W | 2007 | mid_year | DEF | Annual Defense Budget | HOUSE OF REPRESENTATIVES | 0 | 0 | 2007-02-08T17:12:20-05:00 | ||
| 502678 | W.B. DRIGGERS AND ASSOCIATES, INC. 11bcb07b-aae1-4625-8eb0-063da7b4f6ba | MT | W.B. DRIGGERS AND ASSOCIATES, INC. | 45857 | RAYTHEON SYSTEMS CO | 2007 | mid_year | DEF | Annual Defense Budget | HOUSE OF REPRESENTATIVES | 0 | 0 | 2007-02-08T17:39:57-05:00 | ||
| 502679 | W.B. DRIGGERS AND ASSOCIATES, INC. 5e758e75-74c8-43b1-9f7f-8173a53d382d | MT | W.B. DRIGGERS AND ASSOCIATES, INC. | 45857 | MUSTANG TECHNOLOGY GROUP | 2007 | mid_year | DEF | Annual Defense Budget | HOUSE OF REPRESENTATIVES | 20000 | 0 | 0 | 2007-02-08T17:49:26-05:00 | |
| 502680 | W.B. DRIGGERS AND ASSOCIATES, INC. dfb3caff-62d8-4328-abbc-b04af9a91b96 | MT | W.B. DRIGGERS AND ASSOCIATES, INC. | 45857 | DIGITAL FUSION SOLUTIONS | 2007 | mid_year | DEF | Annual Defense Budget | HOUSE OF REPRESENTATIVES | 0 | 0 | 2007-02-08T17:54:27-05:00 | ||
| 502681 | W.B. DRIGGERS AND ASSOCIATES, INC. 75680891-eb2d-4dca-aae9-3be16948941a | MT | W.B. DRIGGERS AND ASSOCIATES, INC. | 45857 | SCIENCE & ENGINEERING SERVICES | 2007 | mid_year | DEF | Annual Defense Budget | HOUSE OF REPRESENTATIVES | 0 | 0 | 2007-02-08T18:01:39-05:00 | ||
| 502682 | W.B. DRIGGERS AND ASSOCIATES, INC. ede13c8f-f9ab-44d9-9a4d-cb0d7c7977af | MT | W.B. DRIGGERS AND ASSOCIATES, INC. | 45857 | PHASE IV ENGINEERING INC | 2007 | mid_year | DEF | Annual Defense Budget | HOUSE OF REPRESENTATIVES | 0 | 0 | 2007-02-08T18:08:49-05:00 | ||
| 502683 | PROCESS HANDLER ET AL. FOR HIRE, INC. 0a180e2f-5781-4738-9dde-a13c05fb2dcd | MTY | PROCESS HANDLER ET AL. FOR HIRE, INC. | 81830 | MCTAGGART MARTHA E | 2007 | mid_year | 0 | 0 | 0 | 2007-02-09T00:00:00-05:00 | ||||
| 502684 | U.S. BEET SUGAR ASSOCIATION e9f28e43-46ad-4ee9-8055-5b4dceda6afe | MM | U.S. BEET SUGAR ASSOCIATION | 38712 | U.S. BEET SUGAR ASSOCIATION | 2007 | mid_year | AGR | Agriculture Legislation, Including Appropriations Acts Administration of U.S. Sugar Policy U.S. Negotiations on Trade Agreements | Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 0 | 0 | 2007-02-12T10:36:11-05:00 | ||
| 502685 | NATIONAL GROCERS ASSOCIATION 4ddb2a19-22cc-4088-b0db-8dc6a24b5fde | MM | NATIONAL GROCERS ASSOCIATION | 27924 | NATIONAL GROCERS ASSOCIATION | 2007 | mid_year | BAN | Industrial Loan Companies: H.R. 1224 Credit Card Interchange Fees | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-02-12T10:47:07-05:00 | |
| 502686 | NATIONAL GROCERS ASSOCIATION 4ddb2a19-22cc-4088-b0db-8dc6a24b5fde | MM | NATIONAL GROCERS ASSOCIATION | 27924 | NATIONAL GROCERS ASSOCIATION | 2007 | mid_year | TAX | Permanent Death Tax Repeal: H.R. 8, S. 420 | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-02-12T10:47:07-05:00 | |
| 502687 | NATIONAL GROCERS ASSOCIATION 4ddb2a19-22cc-4088-b0db-8dc6a24b5fde | MM | NATIONAL GROCERS ASSOCIATION | 27924 | NATIONAL GROCERS ASSOCIATION | 2007 | mid_year | SMB | Preserve Competition and Consumer Choice | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-02-12T10:47:07-05:00 | |
| 502688 | NATIONAL GROCERS ASSOCIATION 4ddb2a19-22cc-4088-b0db-8dc6a24b5fde | MM | NATIONAL GROCERS ASSOCIATION | 27924 | NATIONAL GROCERS ASSOCIATION | 2007 | mid_year | ALC | Methamphetamine Legislation: S. 103 | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-02-12T10:47:07-05:00 | |
| 502689 | NATIONAL GROCERS ASSOCIATION 4ddb2a19-22cc-4088-b0db-8dc6a24b5fde | MM | NATIONAL GROCERS ASSOCIATION | 27924 | NATIONAL GROCERS ASSOCIATION | 2007 | mid_year | FOO | Country of Origin Labeling, S. 1300 | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-02-12T10:47:07-05:00 | |
| 502690 | NATIONAL GROCERS ASSOCIATION 4ddb2a19-22cc-4088-b0db-8dc6a24b5fde | MM | NATIONAL GROCERS ASSOCIATION | 27924 | NATIONAL GROCERS ASSOCIATION | 2007 | mid_year | LBR | Minimum Wage | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-02-12T10:47:07-05:00 | |
| 502691 | ROETZEL & ANDRESS, LPA ccc987fe-7daa-4d4a-b3b4-8e8442fd8d2c | MM | ROETZEL & ANDRESS, LPA | 304452 | J W DIDADO INC | 2007 | mid_year | ENV | Lobbying the Congress, FEMA and VHS on Katrina funding matters. | 0 | 0 | 2007-02-12T14:58:48-05:00 | |||
| 502692 | A.L. ROSS ASSOCIATES d9e0c83b-e7a9-4186-a834-feef4ec945e0 | MT | A.L. ROSS ASSOCIATES | 48634 | SNC TECHNOLOGIES | 2007 | mid_year | DEF | Defense appropriations and authorizations | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-12T15:36:47-05:00 | ||
| 502693 | WELCH RESOURCES, INC. 96b6f94e-ac20-4b57-9989-24893c035c5e | MT | WELCH RESOURCES, INC. | 83978 | OPERATION RESPOND INSTITUTE | 2007 | mid_year | DEF | Establishing a network which will coordinate first responders throughout the nation to provide information for emergencies and disasters primarily involving railcars, trucks, and port shipping containers. | Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-12T16:59:54-05:00 | ||
| 502694 | E-COPERNICUS, LLC 8c2fe85e-ea1d-4c03-a1bc-7d2529aeae74 | MT | E-COPERNICUS, LLC | 70472 | BELLSOUTH CORP | 2007 | mid_year | TEC | Telecommunications | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-12T21:24:51-05:00 | ||
| 502695 | THE WASHINGTON GROUP 168a9218-54f3-4b8e-bc3b-7e35beea168e | MT | THE WASHINGTON GROUP | 40555 | WESTFIELD INC | 2007 | mid_year | 40000 | 0 | 0 | 2007-02-13T09:42:35-05:00 | ||||
| 502696 | PAUL MARCONE & ASSOCIATES, LLC d53fc26a-8782-4bdb-a029-13fd97fc7767 | MT | PAUL MARCONE & ASSOCIATES, LLC | 283732 | BRIDGES FOR CHILDREN CENTER | 2007 | mid_year | EDU | FY 07 Labor-HHS-Education Appropriations bill | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-13T23:11:16-05:00 | ||
| 502697 | PAUL MARCONE & ASSOCIATES, LLC 96a5938f-dbca-4d06-b9a4-c9f0d75f2424 | MT | PAUL MARCONE & ASSOCIATES, LLC | 283732 | LONG ISLAND EDUCATIONAL RESOURCES | 2007 | mid_year | 0 | 0 | 2007-02-13T23:19:32-05:00 | |||||
| 502698 | PAUL MARCONE & ASSOCIATES, LLC 508aad9f-d572-44b7-99f0-db0d61d29edd | MT | PAUL MARCONE & ASSOCIATES, LLC | 283732 | MESORAH HERITAGE FOUNDATION | 2007 | mid_year | 0 | 0 | 2007-02-13T23:22:39-05:00 | |||||
| 502699 | THE WASHINGTON GROUP a99ca289-7ac9-430a-96e7-1f63737b0af6 | MT | THE WASHINGTON GROUP | 40555 | BEACON CAPITAL PARTNERS | 2007 | mid_year | 20000 | 0 | 0 | 2007-02-14T15:45:46-05:00 | ||||
| 502700 | HEDAYAT, YASHAR c41bdef2-09e7-4491-9dfd-d6f60dfba928 | MT | HEDAYAT, YASHAR | 311553 | LINEBARGER GOGGAN BLAIR & SAMPSON | 2007 | mid_year | TAX | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-02-16T00:00:00-05:00 | ||
| 502701 | GSP CONSULTING CORP 52bef596-9acd-4ac0-90a4-3b71952d38fc | M@ | GSP CONSULTING CORP | 72372 | NANOSCIENCE ENGINEERING CORP | 2007 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-02-16T00:00:00-05:00 | ||
| 502702 | JACK WILLIAMS 0f8d2e0f-55a8-4ba7-9825-39a052a01951 | MM | JACK WILLIAMS | 41498 | TYSON FOODS | 2007 | mid_year | AGR | Legislation to clarify, manure is not included in super fund legislation. | HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2007-02-16T10:34:13-05:00 | |
| 502703 | THE RABEN GROUP e958707c-ab82-42c9-b634-3fa1d2817282 | MT | THE RABEN GROUP | 61458 | APPLESEED | 2007 | mid_year | 40000 | 0 | 0 | 2007-02-20T00:00:00-05:00 | ||||
| 502704 | PODESTA GROUP, INC. 63fad3b2-40a0-44ba-9159-35ec173715aa | MA | PODESTA GROUP, INC. | 31680 | GENENTECH | 2007 | mid_year | HCR | Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 80000 | 0 | 0 | 2007-02-21T00:00:00-05:00 | ||
| 502705 | ERIC MONDERO 928cba8c-3dd2-45f9-8c2f-763dc3718765 | YY | ERIC MONDERO | 324137 | AMERICAN RED CROSS 431 18TH STREET NW WASHINGTON DC 20006 | 2007 | year_end | 20000 | 0 | 0 | 2007-02-21T00:00:00-05:00 | ||||
| 502706 | IMPACT TEXAS COMMUNICATIONS, LLP (D/B/A IMPACT US) 5cc06717-ad35-4d0c-8672-01eef9a3626d | MT | IMPACT TEXAS COMMUNICATIONS, LLP (D/B/A IMPACT US) | 87472 | NURSES UNLIMITED | 2007 | mid_year | 0 | 0 | 2007-02-21T16:26:49-05:00 | |||||
| 502707 | GSP CONSULTING CORP 3f257400-54cf-4871-b950-81260700d4a7 | MT | GSP CONSULTING CORP | 72372 | M-BOTS INC | 2007 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-02-23T00:00:00-05:00 | ||
| 502708 | PROMONTORY FINANCIAL GROUP 105e0f8e-2152-4cef-bc6e-135ef08dabfa | MT | PROMONTORY FINANCIAL GROUP | 289410 | TD AMERITRADE HOLDING CORP | 2007 | mid_year | FIN | market structure data security portfolio margining net neutraliy | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE | 20000 | 0 | 0 | 2007-02-23T16:53:17-05:00 | |
| 502709 | WHITTEN & DIAMOND d7f0d3bc-5bab-46b9-ab0d-dbcaa303e3e2 | YY | WHITTEN & DIAMOND | 41328 | TEMPLE UNIVERSITY | 2007 | year_end | HCR | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2007-02-26T00:00:00-05:00 | ||
| 502710 | MEHLMAN CAPITAL STRATEGIES, INC. 455f2ba0-a588-4655-be75-0890814e1b84 | MT | MEHLMAN CAPITAL STRATEGIES, INC. | 295714 | LIGHTSQUARED (FORMERLY KNOWN AS SKYTERRA) | 2007 | mid_year | TEC | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) | 10000 | 0 | 0 | 2007-02-26T00:00:00-05:00 | ||
| 502711 | MS. ELIZABETH WALKER 388d14a5-c0ef-4248-bc6b-c38183a02a3c | MT | MS. ELIZABETH WALKER | 84616 | ST PIERRE CECELIA ET AL | 2007 | mid_year | IND | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 40000 | 0 | 0 | 2007-02-27T00:00:00-05:00 | ||
| 502712 | MS. ELIZABETH WALKER 6a17fe25-f263-4235-b570-c848d77a74d4 | MM | MS. ELIZABETH WALKER | 84616 | VIRGINIA INDIAN TRIBAL ALLIANCE FOR LIFE | 2007 | mid_year | IND | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE | 40000 | 0 | 0 | 2007-02-27T00:00:00-05:00 | ||
| 502713 | E-COPERNICUS, LLC 5cd2e2d9-a451-4f59-b1ac-8605b3368f44 | MM | E-COPERNICUS, LLC | 70472 | VEHICLE TRAFFIC INFORMATION COALITION (VTIC) | 2007 | mid_year | COM | Vehicle Traffic Saftey | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 0 | 0 | 2007-02-27T23:18:02-05:00 | ||
| 502714 | E-COPERNICUS, LLC 8d0bcf5e-3503-4281-abb3-6c352e8aed77 | MM | E-COPERNICUS, LLC | 70472 | SPACE DATA | 2007 | mid_year | TEC | Telecommunications Border Patrol Rural Cellular Service Homeland Security | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Customs & Border Protection | 0 | 0 | 2007-02-27T23:24:03-05:00 | ||
| 502715 | E-COPERNICUS, LLC 98bd077d-d2e5-4caa-a6dc-d3b891cbef42 | MM | E-COPERNICUS, LLC | 70472 | M2Z NETWORKS | 2007 | mid_year | TEC | New Technology | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-27T23:36:04-05:00 | ||
| 502716 | E-COPERNICUS, LLC b9d16c3e-4ea5-4a77-860b-bab159a62143 | MM | E-COPERNICUS, LLC | 70472 | ATX GROUP | 2007 | mid_year | TEC | Emergency Communications E9-1-1 Networks | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-02-27T23:42:06-05:00 | |
| 502717 | E-COPERNICUS, LLC 7c15e880-ecd4-441b-8b1b-359b2238ec69 | MM | E-COPERNICUS, LLC | 70472 | HISPANIC INFORMATION AND TELECOMMUNICATIONS NETWORK INC (HITN) | 2007 | mid_year | COM | Federal Funding FCC / USAC Grant Programs | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-27T23:47:07-05:00 | ||
| 502718 | E-COPERNICUS, LLC 4d7fc6c8-425a-4061-8a33-c9f3cde06368 | MM | E-COPERNICUS, LLC | 70472 | THAT CORPORATION | 2007 | mid_year | COM | Digital Television Conversion | HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE | 0 | 0 | 2007-02-27T23:52:08-05:00 | ||
| 502719 | MILLER, RICHARD D. 93a9ce81-469c-4f73-b7c0-9482f70a7d3d | MTY | MILLER, RICHARD D. | 25396 | USW LOCAL 5-550 | 2007 | mid_year | 0 | 0 | 0 | 2007-02-28T00:00:00-05:00 | ||||
| 502720 | MILLER, RICHARD D. a08286be-ba6c-4384-840a-0e364ca1ee8b | MT | MILLER, RICHARD D. | 25396 | GOVT ACCOUNTABILITY PROJECT | 2007 | mid_year | BUD | Energy, Dept of,Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office | 0 | 0 | 0 | 2007-02-28T00:00:00-05:00 | ||
| 502721 | MILLER, RICHARD D. a08286be-ba6c-4384-840a-0e364ca1ee8b | MT | MILLER, RICHARD D. | 25396 | GOVT ACCOUNTABILITY PROJECT | 2007 | mid_year | LBR | Energy, Dept of,Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office | 0 | 0 | 0 | 2007-02-28T00:00:00-05:00 | ||
| 502722 | MILLER, RICHARD D. fd0de867-5ba0-431a-8420-abc1f0b8bc57 | MT | MILLER, RICHARD D. | 25396 | RESEARCH FOUNDATION OF CUNY ON BEHALF OF QUEENS COLLEGE | 2007 | mid_year | BUD | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-02-28T00:00:00-05:00 | ||
| 502723 | E-COPERNICUS, LLC 242ab599-53c5-4e98-8007-41ac955384de | MM | E-COPERNICUS, LLC | 70472 | NORTH DAKOTA HEALTH CARE ASSOCIATION | 2007 | mid_year | TEC | Interaction with FCC/USAC with completion of forms for Universal Serivces Funds for rural health care in ND | Federal Communications Commission (FCC) | 0 | 0 | 2007-02-28T00:01:11-05:00 | ||
| 502724 | E-COPERNICUS, LLC bacbff5b-45aa-4aab-a748-0f0226a29382 | MM | E-COPERNICUS, LLC | 70472 | ORANGE BROADBAND HOLDING COMPANY/BAJA BROADBAND | 2007 | mid_year | TEC | USDA / RUS - Broadband Loan | Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-28T00:05:12-05:00 | ||
| 502725 | E-COPERNICUS, LLC e83bdea5-91ed-45ea-b325-597ae3dfe401 | MM | E-COPERNICUS, LLC | 70472 | AWPHD | 2007 | mid_year | TEC | FCC Rural Pilot Program | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2007-02-28T00:10:13-05:00 | ||
| 502726 | ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) ee20f8f0-5d01-408b-a6d4-a5d8174a34fd | MT | ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) | 57475 | COX ENTERPRISES INC | 2007 | mid_year | TAX | Misc. estate tax issues. | HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 20000 | 0 | 0 | 2007-02-28T18:40:53-05:00 | |
| 502727 | ORACLE CERNER (FORMERLY CERNER CORPORATION) 0211d2c0-67fd-4344-9a25-f49822686619 | MA | ORACLE CERNER (FORMERLY CERNER CORPORATION) | 296830 | ORACLE CERNER (FORMERLY CERNER CORPORATION) | 2007 | mid_year | 120000 | 0 | 0 | 2007-03-01T00:00:00-05:00 | ||||
| 502728 | CYBER SECURITY RESEARCH CONSULTANTS, LLC 1a098519-e404-441c-a09d-012027db6ba4 | MT | CYBER SECURITY RESEARCH CONSULTANTS, LLC | 91694 | LIVINGSTON GROUP (NATL ASSN OF DRUG COURT PROFESSIONALS) | 2007 | mid_year | LAW | Funding of DOJ Drug Court Program | HOUSE OF REPRESENTATIVES | 0 | 0 | 2007-03-01T07:43:55-05:00 | ||
| 502729 | MENELL GROUP LLC 903082dc-51b7-43e8-99c2-752acca9ea90 | YT | MENELL GROUP LLC | 84514 | NATL MULTI HOUSING COUNCIL | 2007 | year_end | TAX | REIT, LIHTC, mortgage finance, depreciation, partnership, estate tax, exit tax, affordable housing | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2007-03-01T11:26:09-05:00 | |
| 502730 | CAPITOL SOLUTIONS 22adb2e0-7fe7-4f88-9069-fbcd9afe6df9 | MT | CAPITOL SOLUTIONS | 47108 | MOTOROLA | 2007 | mid_year | BUD | Funding and standards for interoperable communications equipment for federal, state, and local first responders S 385- Interoperable Emergency Communications Act S 4- Improving America's Security by Implementing Unfinished Recommendations of the 9/11 Commission Act of 2007 | Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 100000 | 0 | 0 | 2007-03-02T10:55:30-05:00 | |
| 502731 | CAPITOL SOLUTIONS 22adb2e0-7fe7-4f88-9069-fbcd9afe6df9 | MT | CAPITOL SOLUTIONS | 47108 | MOTOROLA | 2007 | mid_year | HOM | Funding and standards for interoperable communications equipment for federal, state, and local first responders S 385- Interoperable Emergency Communications Act S 4- Improving America's Security by Implementing Unfinished Recommendations of the 9/11 Commission Act of 2007 | Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 100000 | 0 | 0 | 2007-03-02T10:55:30-05:00 | |
| 502732 | CAPITOL SOLUTIONS 22adb2e0-7fe7-4f88-9069-fbcd9afe6df9 | MT | CAPITOL SOLUTIONS | 47108 | MOTOROLA | 2007 | mid_year | LAW | Funding and standards for interoperable communications equipment for federal, state, and local first responders S 385- Interoperable Emergency Communications Act S 4- Improving America's Security by Implementing Unfinished Recommendations of the 9/11 Commission Act of 2007 | Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 100000 | 0 | 0 | 2007-03-02T10:55:30-05:00 | |
| 502733 | CAPITOL SOLUTIONS 22adb2e0-7fe7-4f88-9069-fbcd9afe6df9 | MT | CAPITOL SOLUTIONS | 47108 | MOTOROLA | 2007 | mid_year | COM | Funding and standards for interoperable communications equipment for federal, state, and local first responders | Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 100000 | 0 | 0 | 2007-03-02T10:55:30-05:00 | |
| 502734 | CAPITOL SOLUTIONS faf6f713-b2a9-4972-b64d-ab1c1aebd9d7 | MT | CAPITOL SOLUTIONS | 47108 | CINGULAR WIRELESS | 2007 | mid_year | BUD | Issues related to the DTV and Public Safety Bill | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2007-03-02T12:39:44-05:00 | |
| 502735 | CAPITOL SOLUTIONS faf6f713-b2a9-4972-b64d-ab1c1aebd9d7 | MT | CAPITOL SOLUTIONS | 47108 | CINGULAR WIRELESS | 2007 | mid_year | TEC | Issues related to the DTV and Public Safety Bill | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2007-03-02T12:39:44-05:00 | |
| 502736 | CAPITOL HEALTH GROUP, LLC b1968b52-c7f1-4df1-8485-392c2739be8d | MT | CAPITOL HEALTH GROUP, LLC | 63713 | HEALTH INDUSTRY GROUP PURCHASING ASSN | 2007 | mid_year | HCR | H.J.Res.20 - Revised Continuing Appropriations Resolution, 2007 Implementation of Medicare Prescription Drug and Modernization Act of 2003 | Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-03-02T13:10:46-05:00 | |
| 502737 | CAPITOL HEALTH GROUP, LLC b1968b52-c7f1-4df1-8485-392c2739be8d | MT | CAPITOL HEALTH GROUP, LLC | 63713 | HEALTH INDUSTRY GROUP PURCHASING ASSN | 2007 | mid_year | MMM | H.J.Res.20 - Revised Continuing Appropriations Resolution, 2007 Implementation of Medicare Prescription Drug and Modernization Act of 2003 | Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-03-02T13:10:46-05:00 | |
| 502738 | CAPITOL HEALTH GROUP, LLC 40daa8e7-9ee2-4c99-8515-d2e5bc5bdd9e | MT | CAPITOL HEALTH GROUP, LLC | 63713 | ACADEMY OF MOLECULAR IMAGING/PET COALITION | 2007 | mid_year | MMM | Implementation of DRA (Deficit Reduction Act); Implementation of Out Patient Prospective Payment Regs; Educational work for PET Scans and regulatory issues relating to Medicare, Medicaid and other federal health programs which affect coverage or payment for PET. | Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-03-02T13:13:48-05:00 | |
| 502739 | CAPITOL HEALTH GROUP, LLC 40daa8e7-9ee2-4c99-8515-d2e5bc5bdd9e | MT | CAPITOL HEALTH GROUP, LLC | 63713 | ACADEMY OF MOLECULAR IMAGING/PET COALITION | 2007 | mid_year | HCR | Implementation of DRA (Deficit Reduction Act); Implementation of Out Patient Prospective Payment Regs; Educational work for PET Scans and regulatory issues relating to Medicare, Medicaid and other federal health programs which affect coverage or payment for PET. | Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-03-02T13:13:48-05:00 | |
| 502740 | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL 1ea1db72-0342-4eda-929d-c1ead032651f | YTY | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL | 47861 | MONTGOMERY COUNTY HOSPITAL DIST | 2007 | year_end | 0 | 0 | 0 | 2007-03-05T00:00:00-05:00 | ||||
| 502741 | CHARLES CROMWELL 9f09f9ef-0d56-44b3-88d2-bda6c7fa6b5c | YY | CHARLES CROMWELL | 11344 | MTS SYSTEMS CORP | 2007 | year_end | DEF | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2007-03-05T00:00:00-05:00 | ||
| 502742 | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL 0814bf16-cbec-41d1-a75d-2ddebd6a9510 | YTY | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL | 47861 | TARRANT COUNTY HOSPITAL DIST | 2007 | year_end | 0 | 0 | 0 | 2007-03-05T00:00:00-05:00 | ||||
| 502743 | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL 4b27647e-0af9-4ce8-b7f9-9751794ec952 | YTY | BICKERSTAFF HEATH SMILEY POLLAN KEVER & MCDANIEL | 47861 | TEXAS COUNTY STORM WATER COALITION | 2007 | year_end | 0 | 0 | 0 | 2007-03-05T00:00:00-05:00 | ||||
| 502744 | ECKERT SEAMANS CHERIN & MELLOTT, LLC 04129e68-ec98-4f2f-8446-531bc49b99d9 | MTY | ECKERT SEAMANS CHERIN & MELLOTT, LLC | 13073 | REYNOLDS AMERICAN INC | 2007 | mid_year | TOB | 0 | 0 | 0 | 2007-03-08T00:00:00-05:00 | |||
| 502745 | CAPITOL ASSOCIATES, INC. 7d7227ad-43d1-4c75-9da7-556f360b6f25 | MT | CAPITOL ASSOCIATES, INC. | 8101 | GRAND VIEW HOSPITAL | 2007 | mid_year | BUD | H.R. 5647: Making appropriations for the Departments of Labor, Health and Human Services and Education, and related Agencies for the fiscal year ending September 30, 2007, and for other purposes. H.R. 5631: Making appropriations for the Department of Defense for the fiscal year ending September 30, 2007, and for other purposes/Continuing Appropriations Resolution, 2007. H.J.Res. 100: Making further continuing appropriations for the fiscal year 2007, and for other purposes H.J.Res. 102: Making further continuing appropriations for the fiscal year 2007, and for other purposes | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2007-03-08T12:32:52-05:00 | |
| 502746 | PATRICIA LYNCH ASSOCIATES 5eeb12f0-8e24-4379-bbc4-a49a714f54d9 | MT | PATRICIA LYNCH ASSOCIATES | 76616 | ANTARES REAL ESTATE | 2007 | mid_year | 0 | 0 | 2007-03-08T15:04:10-05:00 | |||||
| 502747 | GSP CONSULTING CORP 394fd5dc-5909-4ae3-9460-4f85e0979233 | MT | GSP CONSULTING CORP | 72372 | MACRO-21 | 2007 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-03-09T00:00:00-05:00 | ||
| 502748 | BITTLE, R. HARRY 16fff330-6546-4526-8847-0fcafe22278a | YT | BITTLE, R. HARRY | 55154 | NASSAUX-HEMSLEY | 2007 | year_end | CAW | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2007-03-12T00:00:00-04:00 | ||
| 502749 | AMERICAN ZOO AND AQUARIUM ASSOCIATION cc38a740-b346-42c7-98d6-085cfd3abf2f | MA | AMERICAN ZOO AND AQUARIUM ASSOCIATION | 3732 | AMERICAN ZOO AND AQUARIUM ASSOCIATION | 2007 | mid_year | ANI | Appropriations for USDA/APHIS, Multinational Species Conservation Fund, IMLS, State Wildlife Grant HR 2693 Great Ape Conservation Act, HR 4075 Marine Mammal Protection Act, HR 1707 Great Cats and Rare Canids Act, HR 1329 Captive Primate Safety Act, S 943 Crane Conservation Act | Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Marines | 0 | 0 | 2007-03-12T12:51:10-04:00 | ||
| 502750 | BOND & COMPANY c0a1f439-72ac-4e04-aa3d-07a386455ac6 | MT | BOND & COMPANY | 6677 | SERVICE EMPLOYEES INTL UNION | 2007 | mid_year | 0 | 0 | 2007-03-12T13:14:11-04:00 | |||||
| 502751 | INDIANA STATEWIDE ASSN OF RURAL ELECTRIC COOPERATIVES 4555add7-734f-49f4-8ac7-f8304b8e2d17 | Y@Y | INDIANA STATEWIDE ASSN OF RURAL ELECTRIC COOPERATIVES | 19296 | INDIANA STATEWIDE ASSN OF RURAL ELECTRIC COOPERATIVES | 2007 | year_end | 0 | 0 | 2007-03-19T11:23:16-04: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);