lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
73,149 rows where filing_year = 2005 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 354599 | PARRY, ROMANI, DECONCINI & SYMMS 94841f81-11c5-425e-b166-2b78f16da712 | MM | PARRY, ROMANI, DECONCINI & SYMMS | 30792 | DORSEY & WHITNEY | 2005 | mid_year | TAX | Tax status of expatriates. No bill introduced yet. | HOUSE OF REPRESENTATIVES | 40000 | 0 | 0 | 1980-08-05T00:00:00-04:00 | |
| 354600 | PERKINS COIE LLP 1211fd80-893c-43c8-819c-e653fac5335b | MM | PERKINS COIE LLP | 31213 | SANTA YNEZ VALLEY OF CONCERNED CITIZENS | 2005 | mid_year | NAT | Bureau of Indian Affairs (BIA),Interior, Dept of (DOI) | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354601 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | TRD | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354602 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | BUD | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354603 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | FIN | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354604 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | TAX | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354605 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | TEC | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354606 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | HCR | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354607 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | INS | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354608 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | BNK | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354609 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | ENG | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354610 | EMERSON 69edb565-53cc-406a-9ad5-e4a63a7f4ae7 | MM | EMERSON | 13506 | EMERSON | 2005 | mid_year | TOR | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 253000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354611 | THE RHOADS GROUP 85e10e99-6178-4e3a-81b5-fc97819a7473 | MT | THE RHOADS GROUP | 6644 | NATL CITY CORP | 2005 | mid_year | AVI | HOUSE OF REPRESENTATIVES | 60000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354612 | DEWEY & LEBOEUF LLP f6a22196-4fcc-4870-9bd4-0d1584c7cc05 | MM | DEWEY & LEBOEUF LLP | 22405 | WATER ENVIRONMENT RESEARCH FOUNDATION | 2005 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354613 | DEWEY & LEBOEUF LLP ad173be0-fecc-4b67-9df1-40bf1df2f697 | MM | DEWEY & LEBOEUF LLP | 22405 | NEW YORK STATE RELIABILITY COUNCIL | 2005 | mid_year | ENG | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354614 | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION fabf4ac4-c62d-4cfb-94bf-542757e3c35e | MM | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION | 26477 | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION | 2005 | mid_year | RET | Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Office of Personnel Management (OPM),SENATE,Transportation, Dept of (DOT) | 763000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354615 | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION fabf4ac4-c62d-4cfb-94bf-542757e3c35e | MM | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION | 26477 | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION | 2005 | mid_year | BUD | Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Office of Personnel Management (OPM),SENATE,Transportation, Dept of (DOT) | 763000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354616 | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION fabf4ac4-c62d-4cfb-94bf-542757e3c35e | MM | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION | 26477 | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION | 2005 | mid_year | AVI | Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Office of Personnel Management (OPM),SENATE,Transportation, Dept of (DOT) | 763000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354617 | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION fabf4ac4-c62d-4cfb-94bf-542757e3c35e | MM | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION | 26477 | NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION | 2005 | mid_year | LBR | Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Office of Personnel Management (OPM),SENATE,Transportation, Dept of (DOT) | 763000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354618 | THE RHOADS GROUP 17ed8306-0812-4d64-8e9b-88ff32ca30d1 | MM | THE RHOADS GROUP | 6644 | TEXARKANA CHAMBER OF COMMERCE | 2005 | mid_year | DEF | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE | 80000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354619 | BRYAN CAVE LEIGHTON PAISNER LLP 052f1971-3552-42a8-a691-a22486490c03 | MMY | BRYAN CAVE LEIGHTON PAISNER LLP | 7304 | AMERICAN CHEMISTRY COUNCIL (FORMERLY CHEMICAL MANUFACTURERS ASSN) | 2005 | mid_year | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354620 | PERKINS COIE LLP c6a4051e-8b6b-428d-aa0f-c77cb1597665 | MMY | PERKINS COIE LLP | 31213 | TOWNS OF LEDYARD NORTH STONINGTON & PRESTON CONNECTICUT | 2005 | mid_year | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354621 | PERKINS COIE LLP 1a38abd4-aca8-45a9-8043-d1f1c052f82c | MTY | PERKINS COIE LLP | 31213 | INTERMOUNTAIN FOREST INDUSTRIES ASSN | 2005 | mid_year | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354622 | THE RHOADS GROUP 70d9577a-20ed-4548-b112-2670cbae863c | MT | THE RHOADS GROUP | 6644 | UNITED COMPUTER PRODUCTS CO | 2005 | mid_year | DEF | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES | 20000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354623 | THE RHOADS GROUP 74e2f270-ca71-49a7-a63d-3f9c3fb7e89e | MM | THE RHOADS GROUP | 6644 | UNIVERSITY OF PITTSBURGH MEDICAL CENTER HEALTH SYSTEM (FORMERLY KNOWN AS UPMC) | 2005 | mid_year | BUD | Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE | 180000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354624 | THE RHOADS GROUP 445c9c98-8c95-4ceb-ac76-573f31e309e6 | MM | THE RHOADS GROUP | 6644 | PITTSBURG STATE UNIV | 2005 | mid_year | AGR | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354625 | THE RHOADS GROUP 6ebd6c4d-90f4-4995-ba32-eae43da06208 | MTY | THE RHOADS GROUP | 6644 | MONSTER GOVERNMENT SOLUTIONS | 2005 | mid_year | 40000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354626 | THE RHOADS GROUP 5874a99c-1ab2-45c6-9461-ef2b599defb1 | MT | THE RHOADS GROUP | 6644 | MANGUISTICS | 2005 | mid_year | HOM | Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354627 | THE RHOADS GROUP 5874a99c-1ab2-45c6-9461-ef2b599defb1 | MT | THE RHOADS GROUP | 6644 | MANGUISTICS | 2005 | mid_year | TRA | Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354628 | THE RHOADS GROUP 5874a99c-1ab2-45c6-9461-ef2b599defb1 | MT | THE RHOADS GROUP | 6644 | MANGUISTICS | 2005 | mid_year | DIS | Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354629 | THE RHOADS GROUP 5874a99c-1ab2-45c6-9461-ef2b599defb1 | MT | THE RHOADS GROUP | 6644 | MANGUISTICS | 2005 | mid_year | POS | Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354630 | THE RHOADS GROUP 5874a99c-1ab2-45c6-9461-ef2b599defb1 | MT | THE RHOADS GROUP | 6644 | MANGUISTICS | 2005 | mid_year | BUD | Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354631 | THE RHOADS GROUP 548f0aa3-37d7-4118-afc1-f2a87db06b4b | MT | THE RHOADS GROUP | 6644 | NATL AUTOMOBILE TRANSPORTERS ASSN | 2005 | mid_year | TRA | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354632 | THE RHOADS GROUP d88112ea-73e7-49c0-8465-e9f4d0c8d090 | MM | THE RHOADS GROUP | 6644 | EADS N A | 2005 | mid_year | DEF | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 120000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354633 | THE RHOADS GROUP d88112ea-73e7-49c0-8465-e9f4d0c8d090 | MM | THE RHOADS GROUP | 6644 | EADS N A | 2005 | mid_year | BUD | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 120000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354634 | LEGGETT & PLATT 38b5072b-5272-49cb-99b1-481d3354aa78 | MMY | LEGGETT & PLATT | 22518 | LEGGETT & PLATT | 2005 | mid_year | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354635 | H&R BLOCK MANAGEMENT, LLC, A SUBSIDIARY OF H&R BLOCK, INC. 9d11cc32-6024-4753-af42-e84b500eef92 | MM | H&R BLOCK MANAGEMENT, LLC, A SUBSIDIARY OF H&R BLOCK, INC. | 17215 | H&R BLOCK MANAGEMENT, LLC, A SUBSIDIARY OF H&R BLOCK, INC. | 2005 | mid_year | FIN | HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of | 120000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354636 | H&R BLOCK MANAGEMENT, LLC, A SUBSIDIARY OF H&R BLOCK, INC. 9d11cc32-6024-4753-af42-e84b500eef92 | MM | H&R BLOCK MANAGEMENT, LLC, A SUBSIDIARY OF H&R BLOCK, INC. | 17215 | H&R BLOCK MANAGEMENT, LLC, A SUBSIDIARY OF H&R BLOCK, INC. | 2005 | mid_year | TAX | HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of | 120000 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354637 | BRYAN CAVE LEIGHTON PAISNER LLP 476966d3-674f-456d-a499-aa15fee25b7c | MMY | BRYAN CAVE LEIGHTON PAISNER LLP | 7304 | ELECTRONIC CONSULTANTS | 2005 | mid_year | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354638 | THE RHOADS GROUP 38f69f78-6abd-425b-8015-5093fe82e5c0 | MM | THE RHOADS GROUP | 6644 | SYMBOL TECHNOLOGIES | 2005 | mid_year | CPI | Commerce, Dept of (DOC),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE,White House Office | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||
| 354639 | DEWEY & LEBOEUF LLP e9dbc8d4-ff40-4492-9e14-569a5acd396a | MMY | DEWEY & LEBOEUF LLP | 22405 | SWISS REINSURANCE HOLDING CO | 2005 | mid_year | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354640 | PERKINS COIE LLP 97281818-eb4d-4de7-bb80-f72988a07137 | MMY | PERKINS COIE LLP | 31213 | CITY OF SHAKOPEE MINNESOTA | 2005 | mid_year | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354641 | PERKINS COIE LLP fffb3ec7-c84c-4251-8bfe-0f3b16a0b136 | MTY | PERKINS COIE LLP | 31213 | SEENO CONSTURCTION ALBERT D | 2005 | mid_year | 0 | 0 | 0 | 2002-08-14T00:00:00-04:00 | ||||
| 354642 | SIVON NATTER & WECHSLER, P.C. (FKA BARNETT SIVON & NATTER, P.C.) 125db692-ce29-4073-bb00-0e86963b97c0 | YY | SIVON NATTER & WECHSLER, P.C. (FKA BARNETT SIVON & NATTER, P.C.) | 5448 | BANK POLICY INSTITUTE (FKA FINANCIAL SERVICES ROUNDTABLE) | 2005 | year_end | BAN | HOUSE OF REPRESENTATIVES,SENATE | 120000 | 0 | 0 | 2004-07-29T00:00:00-04:00 | ||
| 354643 | TWENTY-FIRST CENTURY GROUP, INC. 6a9f5365-8b8e-4dbe-a039-00c7c263ba41 | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | SCHERING-PLOUGH | 2005 | mid_year | PHA | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354644 | TWENTY-FIRST CENTURY GROUP, INC. 6a9f5365-8b8e-4dbe-a039-00c7c263ba41 | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | SCHERING-PLOUGH | 2005 | mid_year | MED | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354645 | TWENTY-FIRST CENTURY GROUP, INC. 917d0ebb-ce17-4eeb-890b-1cf6645f9f39 | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | MANATEE COUNTY FLORIDA COUNTY ADMINISTRATOR'S OFFICE | 2005 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354646 | THE VECTRE CORPORATION bf601952-740f-458f-b333-64987fd33c5d | MM | THE VECTRE CORPORATION | 39928 | SMALL BUSINESS COALITION ON FRESH FRUITS AND VEGETABLES | 2005 | mid_year | GOV | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354647 | JPMORGAN CHASE & CO. 14e60527-3f54-4bca-8046-a33d574a7229 | MM | JPMORGAN CHASE & CO. | 25807 | JPMORGAN CHASE & CO | 2005 | mid_year | TRD | HOUSE OF REPRESENTATIVES,SENATE | 1971000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354648 | JPMORGAN CHASE & CO. 14e60527-3f54-4bca-8046-a33d574a7229 | MM | JPMORGAN CHASE & CO. | 25807 | JPMORGAN CHASE & CO | 2005 | mid_year | BAN | HOUSE OF REPRESENTATIVES,SENATE | 1971000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354649 | JPMORGAN CHASE & CO. 14e60527-3f54-4bca-8046-a33d574a7229 | MM | JPMORGAN CHASE & CO. | 25807 | JPMORGAN CHASE & CO | 2005 | mid_year | FIN | HOUSE OF REPRESENTATIVES,SENATE | 1971000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354650 | JPMORGAN CHASE & CO. 14e60527-3f54-4bca-8046-a33d574a7229 | MM | JPMORGAN CHASE & CO. | 25807 | JPMORGAN CHASE & CO | 2005 | mid_year | TAX | HOUSE OF REPRESENTATIVES,SENATE | 1971000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354651 | JPMORGAN CHASE & CO. 14e60527-3f54-4bca-8046-a33d574a7229 | MM | JPMORGAN CHASE & CO. | 25807 | JPMORGAN CHASE & CO | 2005 | mid_year | CPT | HOUSE OF REPRESENTATIVES,SENATE | 1971000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354652 | JPMORGAN CHASE & CO. 14e60527-3f54-4bca-8046-a33d574a7229 | MM | JPMORGAN CHASE & CO. | 25807 | JPMORGAN CHASE & CO | 2005 | mid_year | BNK | HOUSE OF REPRESENTATIVES,SENATE | 1971000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354653 | JPMORGAN CHASE & CO. 14e60527-3f54-4bca-8046-a33d574a7229 | MM | JPMORGAN CHASE & CO. | 25807 | JPMORGAN CHASE & CO | 2005 | mid_year | GOV | HOUSE OF REPRESENTATIVES,SENATE | 1971000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354654 | JPMORGAN CHASE & CO. 14e60527-3f54-4bca-8046-a33d574a7229 | MM | JPMORGAN CHASE & CO. | 25807 | JPMORGAN CHASE & CO | 2005 | mid_year | TOR | HOUSE OF REPRESENTATIVES,SENATE | 1971000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354655 | TWENTY-FIRST CENTURY GROUP, INC. 78a502d1-12de-44eb-93cc-b5bc3ed1503c | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | UNITED COLLECTION BUREAU | 2005 | mid_year | FIN | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354656 | TWENTY-FIRST CENTURY GROUP, INC. 78a502d1-12de-44eb-93cc-b5bc3ed1503c | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | UNITED COLLECTION BUREAU | 2005 | mid_year | TAX | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354657 | TWENTY-FIRST CENTURY GROUP, INC. 78a502d1-12de-44eb-93cc-b5bc3ed1503c | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | UNITED COLLECTION BUREAU | 2005 | mid_year | VET | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354658 | TWENTY-FIRST CENTURY GROUP, INC. 78a502d1-12de-44eb-93cc-b5bc3ed1503c | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | UNITED COLLECTION BUREAU | 2005 | mid_year | SMB | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354659 | TWENTY-FIRST CENTURY GROUP, INC. 78a502d1-12de-44eb-93cc-b5bc3ed1503c | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | UNITED COLLECTION BUREAU | 2005 | mid_year | GOV | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354660 | TWENTY-FIRST CENTURY GROUP, INC. 78a502d1-12de-44eb-93cc-b5bc3ed1503c | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | UNITED COLLECTION BUREAU | 2005 | mid_year | LBR | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354661 | THE VECTRE CORPORATION 7bfb4d44-88b0-43ef-a016-706340a4e403 | MM | THE VECTRE CORPORATION | 39928 | SENTARA HEALTHCARE | 2005 | mid_year | HCR | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354662 | HELEN DELICH BENTLEY abf65926-8580-4b34-8d73-052436ea4161 | MM | HELEN DELICH BENTLEY | 5995 | SMITHS DETECTION - EDGEWOOD INC | 2005 | mid_year | DEF | HOUSE OF REPRESENTATIVES,SENATE | 18000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354663 | IBARRA STRATEGY GROUP 3fedce47-588e-4f5d-8e35-08e427be2912 | MMY | IBARRA STRATEGY GROUP | 72177 | CITY OF SAN JACINTO CALIFORNIA | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354664 | IBARRA STRATEGY GROUP 935f9f80-e97d-4a0a-9a69-08586b82628e | MMY | IBARRA STRATEGY GROUP | 72177 | CITY OF ALBUQUERQUE NM | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354665 | COLLIER SHANNON SCOTT, PLLC d7a92d52-0f20-4b49-9eff-0994be28d005 | MMY | COLLIER SHANNON SCOTT, PLLC | 9900 | METALS INDUSTRY RECYCLING COALITION | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354666 | COLLIER SHANNON SCOTT, PLLC 7f9bb199-a3a6-4aa9-b8c5-1036a4d921cf | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | ALLEGHENY TECHNOLOGIES | 2005 | mid_year | DEF | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354667 | COLLIER SHANNON SCOTT, PLLC 3568ddb6-bf04-45f8-a56d-1a0689fbb242 | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | COUNCIL OF INSURANCE AGENTS & BROKERS | 2005 | mid_year | INS | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354668 | COLLIER SHANNON SCOTT, PLLC c2bd4b00-33b8-49d5-a5dc-1f916cb931c5 | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | GC SERVICES | 2005 | mid_year | TAX | HOUSE OF REPRESENTATIVES | 80000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354669 | COLLIER SHANNON SCOTT, PLLC 9f9eea35-e59b-4279-9149-2197efb30dfa | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | SUPERALLOYS COMMITTEE | 2005 | mid_year | DEF | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354670 | COLLIER SHANNON SCOTT, PLLC 9f9eea35-e59b-4279-9149-2197efb30dfa | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | SUPERALLOYS COMMITTEE | 2005 | mid_year | APP | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354671 | HEALTH POLICY ALTERNATIVES 25ce33d4-4850-40a1-8434-205c53ef3ee6 | MMY | HEALTH POLICY ALTERNATIVES | 17875 | JOHNSON & JOHNSON | 2005 | mid_year | 140000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354672 | COLLIER SHANNON SCOTT, PLLC 73c05c2b-ffc0-4095-b56f-21cbba22569c | MMY | COLLIER SHANNON SCOTT, PLLC | 9900 | METRO INTL TRADE SERVICES | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354673 | COLLIER SHANNON SCOTT, PLLC 646493fe-804a-454d-852b-234a0a7f60ae | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | JOHNSON OUTDOORS | 2005 | mid_year | BUD | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354674 | COLLIER SHANNON SCOTT, PLLC 68f14891-559d-47be-875a-2a96fcfbcad7 | MMY | COLLIER SHANNON SCOTT, PLLC | 9900 | AMERICAN TEXTILE MACHINERY ASSN | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354675 | IBARRA STRATEGY GROUP b095f613-6d3b-4ca7-85e7-2415bb6b22c7 | MMY | IBARRA STRATEGY GROUP | 72177 | NATIONAL EDUCATION ASSOCIATION | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354676 | COLLIER SHANNON SCOTT, PLLC 4be197d5-2db5-4c45-ac0f-241fa74312b3 | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | REHAU | 2005 | mid_year | TRD | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354677 | HELEN DELICH BENTLEY 0b3e866c-06ee-4763-9ef1-2d8945cadaf6 | MM | HELEN DELICH BENTLEY | 5995 | SPARROWS POINT SHIPYARD INDUSTRIAL COMPLEX | 2005 | mid_year | MAR | Maritime Administration (MARAD) | 36000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354678 | COLLIER SHANNON SCOTT, PLLC c9511339-e322-4e59-92de-273922968af7 | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | PETROLEOS DE VENEZUELA SA | 2005 | mid_year | FUE | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE | 140000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354679 | COLLIER SHANNON SCOTT, PLLC 7b2d0d64-e01c-4864-af52-304b11ae0fed | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | TOWN OF CHATHAM | 2005 | mid_year | MAR | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,U.S. Fish & Wildlife Service (USFWS) | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354680 | HEALTH POLICY ALTERNATIVES 7ec417b7-5e86-42ab-bed6-3b69466461d8 | MMY | HEALTH POLICY ALTERNATIVES | 17875 | AMERICAN COLLEGE OF EMERGENCY PHYSICIANS | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354681 | TWENTY-FIRST CENTURY GROUP, INC. c93c6d8a-0686-46a3-ae18-39b1c4ecb04c | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | VERIZON COMMUNICATIONS INC AND VARIOUS SUBSIDIARIES | 2005 | mid_year | TEC | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354682 | HEALTH POLICY ALTERNATIVES 919d48b4-20c2-4c6a-ba01-41dc5ae53044 | MMY | HEALTH POLICY ALTERNATIVES | 17875 | AMERICAN NURSES ASSOCIATION | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354683 | COLLIER SHANNON SCOTT, PLLC 3690430d-6a56-400b-b913-38263eec9288 | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | MUNICIPAL CASTINGS FAIR TRADE COUNCIL | 2005 | mid_year | TRD | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354684 | COLLIER SHANNON SCOTT, PLLC 2ed9e17e-4a54-4d43-a514-3fa2043eb6cb | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | NATL ASSN OF INSURANCE & FINANCIAL ADVISORS | 2005 | mid_year | FIN | HOUSE OF REPRESENTATIVES,SENATE | 140000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354685 | COLLIER SHANNON SCOTT, PLLC 2ed9e17e-4a54-4d43-a514-3fa2043eb6cb | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | NATL ASSN OF INSURANCE & FINANCIAL ADVISORS | 2005 | mid_year | INS | HOUSE OF REPRESENTATIVES,SENATE | 140000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354686 | COLLIER SHANNON SCOTT, PLLC c0fb7de5-8f8b-4c38-8406-3bd4e377a2a5 | MM | COLLIER SHANNON SCOTT, PLLC | 9900 | MILITARY CLOTHING COMPONENTS COALITION | 2005 | mid_year | DEF | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354687 | HELEN DELICH BENTLEY e7955203-fb91-4fa0-bfb0-48d345ca60fc | MTY | HELEN DELICH BENTLEY | 5995 | U S SHIP MANAGEMENT | 2005 | mid_year | MAR | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | |||
| 354688 | HEALTH POLICY ALTERNATIVES 8c01aa9d-403d-4044-9fe0-4e55f01d83f3 | MMY | HEALTH POLICY ALTERNATIVES | 17875 | FEDERATION OF AMERICAN HOSPITALS | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354689 | TWENTY-FIRST CENTURY GROUP, INC. bbf1829a-8d4e-4f62-b75f-56703e735dad | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | QWEST COMMUNICATIONS | 2005 | mid_year | TEC | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354690 | COLLIER SHANNON SCOTT, PLLC ed6fe923-20c0-456c-9421-505613339c57 | MTY | COLLIER SHANNON SCOTT, PLLC | 9900 | AMERICAN FOREST & PAPER ASSN | 2005 | mid_year | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||||
| 354691 | TWENTY-FIRST CENTURY GROUP, INC. 07816d0c-d8d9-45c7-8f3f-5a0ba9223bc3 | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | SIERRA GROUP INC | 2005 | mid_year | BUD | Education, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354692 | TWENTY-FIRST CENTURY GROUP, INC. 07816d0c-d8d9-45c7-8f3f-5a0ba9223bc3 | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | SIERRA GROUP INC | 2005 | mid_year | EDU | Education, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354693 | TWENTY-FIRST CENTURY GROUP, INC. 07816d0c-d8d9-45c7-8f3f-5a0ba9223bc3 | MM | TWENTY-FIRST CENTURY GROUP, INC. | 38687 | SIERRA GROUP INC | 2005 | mid_year | LBR | Education, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA),White House Office | 0 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354694 | WINE INSTITUTE a27dd495-1d31-411c-957d-515753bd2846 | MM | WINE INSTITUTE | 41636 | WINE INSTITUTE | 2005 | mid_year | TRD | Bureau of Alcohol Tobacco Firearms & Explosives,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) | 107186 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354695 | WINE INSTITUTE a27dd495-1d31-411c-957d-515753bd2846 | MM | WINE INSTITUTE | 41636 | WINE INSTITUTE | 2005 | mid_year | TAX | Bureau of Alcohol Tobacco Firearms & Explosives,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) | 107186 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354696 | WINE INSTITUTE a27dd495-1d31-411c-957d-515753bd2846 | MM | WINE INSTITUTE | 41636 | WINE INSTITUTE | 2005 | mid_year | BUD | Bureau of Alcohol Tobacco Firearms & Explosives,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) | 107186 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354697 | WINE INSTITUTE a27dd495-1d31-411c-957d-515753bd2846 | MM | WINE INSTITUTE | 41636 | WINE INSTITUTE | 2005 | mid_year | ADV | Bureau of Alcohol Tobacco Firearms & Explosives,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) | 107186 | 0 | 0 | 2004-08-23T00:00:00-04:00 | ||
| 354698 | WINE INSTITUTE a27dd495-1d31-411c-957d-515753bd2846 | MM | WINE INSTITUTE | 41636 | WINE INSTITUTE | 2005 | mid_year | BEV | Bureau of Alcohol Tobacco Firearms & Explosives,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) | 107186 | 0 | 0 | 2004-08-23T00:00:00-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);