home / lobbying

lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

419 rows where filing_period = "year_end", filing_year = 2005 and issue_code = "RET" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filing_type, received_date (date)

issue_code 1

  • RET · 419 ✖

filing_year 1

  • 2005 · 419 ✖

filing_period 1

  • year_end · 419 ✖
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
354943 AMERICAN INTERNATIONAL GROUP, INC. d734d69b-0cef-45aa-a4d9-2110f255d208 YY AMERICAN INTERNATIONAL GROUP, INC. 2695 AMERICAN INTERNATIONAL GROUP, INC. 2005 year_end RET   Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR)   4430000 0 0 2005-02-13T00:00:00-05:00
388319 NEW YORK LIFE INSURANCE COMPANY 1c706ff5-01ff-459f-84b1-0e209a87bb81 YY NEW YORK LIFE INSURANCE COMPANY 29174 NEW YORK LIFE INSURANCE COMPANY 2005 year_end RET   Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   1860000 0 0 2005-12-19T00:00:00-05:00
388374 VOYA SERVICES COMPANY 826b07f8-35cc-4cc4-ac55-7830846aa9f0 YY VOYA SERVICES COMPANY 87973 VOYA SERVICES COMPANY 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE   240000 0 0 2005-12-19T00:00:00-05:00
388404 SUNKIST GROWERS 1adb870d-0f9d-4e1c-af05-a89cf38cb1e2 YY SUNKIST GROWERS 37345 SUNKIST GROWERS 2005 year_end RET   Agriculture, Dept of (USDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   50000 0 0 2005-12-20T00:00:00-05:00
388672 MEADWESTVACO CORPORATION 9a3c328f-2f2f-4755-b71c-843b8978f5cc YY MEADWESTVACO CORPORATION 41090 MEADWESTVACO CORPORATION 2005 year_end RET   Commerce, Dept of (DOC),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   320000 0 0 2005-12-28T00:00:00-05:00
388820 COORS BREWING COMPANY d4ed5368-da1e-4c98-a37d-08b064c43828 YY COORS BREWING COMPANY 10786 COORS BREWING COMPANY 2005 year_end RET   Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Customs & Border Protection   480000 0 0 2005-12-30T00:00:00-05:00
388992 C2 GROUP, LLC 0d87e382-3d0f-4ac8-a94b-41d5c015876f YY C2 GROUP, LLC 66693 AXA FINANCIAL/EQUITABLE LIFE ASSURANCE 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 60000   0 0 2006-01-03T00:00:00-05:00
389084 C2 GROUP, LLC 222f2b05-cbf7-47fa-8101-aaead762ec19 YY C2 GROUP, LLC 66693 METLIFE 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 60000   0 0 2006-01-03T00:00:00-05:00
389107 THE HOBBS GROUP, LLC 111ccc73-7850-4891-b20f-d7818af0e187 YY THE HOBBS GROUP, LLC 294495 ANHEUSER-BUSCH COMPANIES INC 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2006-01-03T00:00:00-05:00
389197 C2 GROUP, LLC 316515bc-3684-4cbc-bc43-c17122630bbe YY C2 GROUP, LLC 66693 PACIFIC LIFE INSURANCE COMPANY 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 60000   0 0 2006-01-03T00:00:00-05:00
389260 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS 47be4206-59e1-413e-b18b-67de619c1918 YY INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS 19822 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS 2005 year_end RET IBEW urges rejection of any proposal that would attempt to cut Social Security benefits or otherwise hurt workers in risky privatized Social Security finance accounts, or raise the retirement age, which already is scheduled to increase to 67. The IBEW position is that forcing workers to stay on the job even longer to collect the benefits they have spent years paying for would be cruel and unnecessary. It is also inconceivable that workers in physically demanding jobs, as is the case with a large number of IBEW members, would be forced to work longer by increasing the retirement age. Chairman William Thomas was expected to include Social Security privatization in the Pension Protection Act of 2005 (H.R. 2830), but did not. Thus, it appears that the Social Security issue is dead for now. The general political climate has thwarted any desire to implement the president’s scheme. The IBEW took no position on H.R. 2830, the “Pension Protection Act of 2005,” or S. 1783, the “Pension Security and Transparency Act of 2005” understanding that the ultimate effect of the proposed bills would encourage employers to cease offering their employees a defined benefit pension. Rather, the IBEW lobbied to urge the inclusion of two separate provisions to the bill. The first was for multi-employer pension plan reform as proposed by the Multi-Employer Pension Plan Coalition, a group of employers and unions involved in the construction, trucking, and food service industries. The second was for a two-part change to Section 420 of the Internal Revenue Code as outlined in S. 1573 the “Retiree Health Benefits Act of 2005.” The language of S. 1573 is included in S. 1783. The language proposes two changes to Section 420 of the Internal Revenue Code to ensure that retirees, such as those at Lucent Technologies [an IBEW/Communication Workers of America (CWA) employer], will continue to receive retiree health care benefits. First, the bill would permit substituting the statutorily mandated maintenance-of-cost requirement with the reti… Defense, Dept of (DOD),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE   520000 0 0 2006-01-04T00:00:00-05:00
389429 MOORE LAW FIRM 46fd7aeb-728d-4cc3-924d-8d315ab0b99c YT MOORE LAW FIRM 25784 NATL COUNCIL ON TEACHER RETIREMENT 2005 year_end RET   HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Social Security Administration (SSA),Treasury, Dept of 0   0 0 2006-01-05T00:00:00-05:00
389726 LOCKE LORD PUBLIC POLICY GROUP LLC 31e02b17-1671-4ab3-9e9e-d595b69a86e4 YT LOCKE LORD PUBLIC POLICY GROUP LLC 300971 DALLAS POLICE & FIRE PENSION SYSTEMS 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2006-01-06T00:00:00-05:00
390033 WEST PENN ALLEGHENY HEALTH SYSTEM 70dded60-288a-4033-aec0-5f9552564e7f YY WEST PENN ALLEGHENY HEALTH SYSTEM 89270 WEST PENN ALLEGHENY HEALTH SYSTEM 2005 year_end RET Pension Reform HOUSE OF REPRESENTATIVES,SENATE     0 0 2006-01-10T00:00:00-05:00
390108 EDUCATION LEGISLATIVE SERVICES, INC bc09a5ec-cede-498d-83cc-574cae790df3 YY EDUCATION LEGISLATIVE SERVICES, INC 13164 LONG BEACH UNIFIED SCHOOL DISTRICT (CA) 2005 year_end RET   Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Education, Dept of,Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office 0   0 0 2006-01-11T00:00:00-05:00
390770 VAN SCOYOC ASSOCIATES 1990beb0-a9ae-4c24-a21f-e72af6a78512 YY VAN SCOYOC ASSOCIATES 39837 NATIONAL ASSOCIATION OF FOSTER GRANDPARENT PROGRAM DIRECTORS 2005 year_end RET No lobbying activity. Corporation for Natl & Community Service,HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2006-01-19T00:00:00-05:00
390851 RESERVE OFFICERS ASSOCIATION OF THE UNITED STATES c5b7ab52-fe73-4336-b10f-b640af7faefd YY RESERVE OFFICERS ASSOCIATION OF THE UNITED STATES 33102 RESERVE OFFICERS ASSOCIATION OF THE UNITED STATES 2005 year_end RET Earlier Retirement for Guard and Reservists, and concurrent receipt. Air Force, Dept of,Army, Dept of (Other),Commerce, Dept of (DOC),Defense, Dept of (DOD),Government Accountability Office (GAO),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Navy, Dept of,Office of Personnel Management (OPM),Selective Service System,SENATE,U.S. Coast Guard (USCG),U.S. Marines,Veterans Affairs, Dept of (VA),White House Office   80000 0 0 2006-01-20T00:00:00-05:00
391398 INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS 6618adaf-c9e0-42ef-84d2-b85e0c3038bd YY INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS 35070 INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS 2005 year_end RET Pension Preservation & Savings Expansion Act 2003 - H.R. 1776, S.A. 2264, S.A. 2233 and H.R. 3108 Employee Retirement Security Act of 1974 H.R. 525/S.406 Pension System Overhaul - Multi Employer pension Fund Reform H.R. 2830 Pension Reform Bills - H.R.2830 & S.1783 HOUSE OF REPRESENTATIVES,SENATE   60000 0 0 2006-01-25T00:00:00-05:00
391555 HOGAN LOVELLS US LLP 9e946cf9-9a49-411c-a937-f579ac9ac1e4 YY HOGAN LOVELLS US LLP 18422 CALIFORNIA STATE TEACHERS' RETIREMENT SYSTEM 2005 year_end RET Possible proposals to impose mandatory coverage under Social Security of State and local government employees; proposals regarding Medicare coverage Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,White House Office 40000   0 0 2006-01-27T00:00:00-05:00
391779 CMS ENERGY CORP be87deac-b5e7-4a67-b5f4-85cc107449d9 YY CMS ENERGY CORP 9578 CMS ENERGY CORP 2005 year_end RET S219 - National Employee Savings and Trust Equity Guarantee Act of 2005. HR2830 - Pension Protection Act of 2005. HR2106 - Employee Pension Preservation and Taxpayer Protection Act of 2005. S861 -Employee Pension Preservation Act of 2005. S.1783 - Pension Security and Transparency Act of 2005. Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)   235000 0 0 2006-01-30T00:00:00-05:00
391972 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. ff67b6dc-f533-439f-bbfe-cf29041c7164 YY NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2005 year_end RET HR 147 / S 619 "Social Security Fairness Act" HR 2177 "HELPS Retirees Act of 2005" HR 2830 "Pension Protection Act of 2005" HR 1714 / S 866 "Public Servant Retirement Security Protection Act" Bureau of Justice Assistance,Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE   40000 0 0 2006-01-31T00:00:00-05:00
391984 FEDERAL POLICY GROUP, LLC 57979dd8-4b58-4e11-9db6-13e71ae28947 YY FEDERAL POLICY GROUP, LLC 72975 ANHEUSER-BUSCH COMPANIES INC (PREVIOUSLY REPORTED AS ANHEUSER-BUSCH COMPANY) 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 160000   0 0 2006-01-31T00:00:00-05:00
392048 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. bf91a0f2-488f-434b-8c3d-5ee74c5bdf9c YA NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2005 year_end RET HR 147 / S 619 "Social Security Fairness Act" HR 2177 "HELPS Retirees Act of 2005" HR 2830 "Pension Protection Act of 2005" HR 1714 / S 866 "Public Servant Retirement Security Protection Act" Bureau of Justice Assistance,Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE   40000 0 0 2006-01-31T00:00:00-05:00
392081 HAAKE & ASSOCIATES 0f42b9bc-bb8e-413a-9c69-185614027fad YY HAAKE & ASSOCIATES 17226 AMERICAN FEDERATION OF GOVERNMENT EMPLOYEES LOCAL 3721 2005 year_end RET Pursue retirement benefit increase for emergency medical technicians. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2006-02-01T00:00:00-05:00
392146 XEROX CORPORATION 81eb8edb-a4ef-40b2-9877-2705acca31e2 YY XEROX CORPORATION 42001 XEROX CORPORATION 2005 year_end RET   SENATE   240000 0 0 2006-02-01T00:00:00-05:00
392213 VENABLE LLP 31ffa860-2a81-41fd-8b45-3320acd380a0 YY VENABLE LLP 39941 XPO LOGISTICS (FORMERLY KNOWN AS CON-WAY INC ) 2005 year_end RET Pension reform legislation ERISA (Employee Retirement Income Security Act) H.R. 4440 Gulf Opportunity Zone Act of 2005 HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA) 80000   0 0 2006-02-02T00:00:00-05:00
392227 VENABLE LLP 65e8db5b-5b64-465d-94b1-069693ff2603 YY VENABLE LLP 39941 AMERICAN AIRLINES INC 2005 year_end RET Pension Reform Legislation HOUSE OF REPRESENTATIVES,Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT) 150000   0 0 2006-02-02T00:00:00-05:00
392374 THE NATIONAL GRANGE OF THE ORDER OF PATRONS OF HUSBANDRY d577e6a6-bccf-4829-9712-b7ad8517bd77 YY THE NATIONAL GRANGE OF THE ORDER OF PATRONS OF HUSBANDRY 27913 NATIONAL GRANGE OF THE ORDER OF PATRONS OF HUSBANDRY 2005 year_end RET   Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Education, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   20000 0 0 2006-02-02T00:00:00-05:00
392458 VALERO ENERGY CORPORATION 6f4c4b8d-bc91-49fd-8d7e-7fa78458eb59 YY VALERO ENERGY CORPORATION 39746 VALERO ENERGY CORPORATION 2005 year_end RET   Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office   300000 0 0 2006-02-02T00:00:00-05:00
392558 BOCKORNY GROUP, INC. 594285b2-886a-4d11-9c13-9d6cd271c294 YY BOCKORNY GROUP, INC. 289773 MCGUIREWOODS CONSULTING LLC 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2006-02-03T00:00:00-05:00
392598 RICHARD F. HOHLT 3e76873a-bb1a-4d72-90dc-ec13f556ad65 YT RICHARD F. HOHLT 18433 NORTHWEST AIRLINES 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2006-02-03T00:00:00-05:00
392772 NATIONWIDE MUTUAL INSURANCE COMPANY af047fdc-4ccf-4c80-a680-9071e39515d6 YY NATIONWIDE MUTUAL INSURANCE COMPANY 26411 NATIONWIDE MUTUAL INSURANCE COMPANY 2005 year_end RET PBGC-Defined Benefit Funding Reform Pension Reform Executive Non-Qualified Deferred Compensation Automatic Enrollment Qualified Plan Fiduciary Relief UNDETERMINED   700000 0 0 2006-02-03T00:00:00-05:00
392796 BOCKORNY GROUP, INC. 79eefd80-dbf5-4cd1-8fc6-86e9e3c21a13 YY BOCKORNY GROUP, INC. 289773 AVAYA INC 2005 year_end RET   Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Office of the Vice President of the United States,SENATE,Treasury, Dept of,Veterans Affairs, Dept of (VA) 40000   0 0 2006-02-03T00:00:00-05:00
392810 NATIONAL BEER WHOLESALERS ASSOCIATION 568f1ad3-9592-4694-af9c-349d989ca86e YY NATIONAL BEER WHOLESALERS ASSOCIATION 27274 NATIONAL BEER WHOLESALERS ASSOCIATION 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE   120000 0 0 2006-02-03T00:00:00-05:00
392933 STRATEGIC CONSULTING GROUP, NA, INC. c17c7fcd-04d8-4fca-be46-ac487a62233a YY STRATEGIC CONSULTING GROUP, NA, INC. 49065 AMERICANS UNITED TO PROTECT SOCIAL SECURITY 2005 year_end RET Prevent Privatization of Social Security HOUSE OF REPRESENTATIVES,SENATE     0 0 2006-02-06T00:00:00-05:00
393234 ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 0e1208a4-e43f-4d4b-bfa6-3b896cad87ff YY ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 57475 NEW AMERICA FOUNDATION 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 160000   0 0 2006-02-07T00:00:00-05:00
393328 COX ENTERPRISES INC. 957e41db-3161-4795-a9b3-970b630dd00a YY COX ENTERPRISES INC. 11231 COX ENTERPRISES INC. 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE   900000 0 0 2006-02-07T00:00:00-05:00
393354 HANCE SCARBOROUGH 8a6277cd-2ee1-4d8c-a974-ddeed4783a60 YY HANCE SCARBOROUGH 17443 ASSOCIATION OF TEXAS PROFESSIONAL EDUCATORS 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2006-02-07T00:00:00-05:00
393479 HECHT LATHAM SPENCER & ASSOCIATES, INC., FORMERLY KNOWN AS HECHT SPENCER & ASSOC a286ad42-3d49-4b97-8180-b86111d02cba YY HECHT LATHAM SPENCER & ASSOCIATES, INC., FORMERLY KNOWN AS HECHT SPENCER & ASSOC 17966 J C PENNEY CORPORATION INC 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2006-02-07T00:00:00-05:00
393567 ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 10218445-68fe-47cd-8687-db80358585ee YT ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 57475 DELTA AIRLINES 2005 year_end RET   Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 200000   0 0 2006-02-07T00:00:00-05:00
393702 FIERCE, ISAKOWITZ & BLALOCK 808489a6-ff04-4a98-8e81-31498b4e05be YY FIERCE, ISAKOWITZ & BLALOCK 44812 AMERICANS FOR SECURE RETIREMENT 2005 year_end RET HR 819 S 381 HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,White House Office 140000   0 0 2006-02-07T00:00:00-05:00
393844 EXELIS INC. (FORMERLY ITT CORPORATION) 2a5b0c58-c8a9-455b-b2e3-64dfbd658935 YY EXELIS INC. (FORMERLY ITT CORPORATION) 20287 EXELIS INC. (FORMERLY ITT CORPORATION) 2005 year_end RET   Commerce, Dept of (DOC),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Oceanic & Atmospheric Administration (NOAA),SENATE   120000 0 0 2006-02-07T00:00:00-05:00
393876 THE OB-C GROUP, LLC 2fd3998b-f7fa-4082-9028-52a047b06a0b YY THE OB-C GROUP, LLC 29802 AMERICAN AIRLINES 2005 year_end RET HR 2830, Pension Protection Act of 2005, pension reform. S.219, National Employee Savings and Trust Equity Guarantee Act of 2005, pension reform. S.1953, National Employee Savings and Trust Equity Guarantee Act of 2005, pension reform. S.1783, Pension Security and Transparency Act of 2005, pension reform. H.RES.602, providing for consideration of the bill HR 2830 to amend the Employee Retirement Income Security Act of 1974 and the IRS Code of 1986 to reform pension rules, entire bill. HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2006-02-07T00:00:00-05:00
394018 TEXTRON INC. d7a91637-acce-4393-ac34-8ba150fbce2d YA TEXTRON INC. 37948 TEXTRON INC 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE   1140000 0 0 2006-02-07T00:00:00-05:00
394071 ALPINE GROUP PARTNERS, LLC. b76d7110-ecec-40a3-a79c-069775af5d7d YY ALPINE GROUP PARTNERS, LLC. 1171 EATON CORPORATION 2005 year_end RET H.R.2830, Pension Protection Act of 2005 - provisions related to employee provided pension benefits H.R.2831, Pension Preservation and Portability Act of 2005 - provisions related to employee provided pension benefits S.1783, Pension Security and Transparency Act of 2005 HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2006-02-07T00:00:00-05:00
394076 ALPINE GROUP PARTNERS, LLC. 6d1490a4-4b89-443b-bc99-a46140fa08fa YY ALPINE GROUP PARTNERS, LLC. 1171 EL PASO CORPORATION 2005 year_end RET H.R.2830, Pension Protection Act of 2005 S. 1953, National Employee Savings and Trust Equity Guarantee Act of 2005 HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2006-02-07T00:00:00-05:00
394297 WHITMER & WORRALL, LLC 06a33efc-2563-4e33-af1c-20692b86520c YY WHITMER & WORRALL, LLC 292892 AIR LINE PILOTS ASSN 2005 year_end RET S 1783 The Pension Security and Transparency Act of 2005 Support the Akaka amendment related to Air Line Pilots Association (ALPA) pension benefits. Natl Transportation Safety Board (NTSB),SENATE,White House Office 40000   0 0 2006-02-08T00:00:00-05:00
394335 THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY fb14eadf-f61f-4c2c-b07a-48385340918e YY THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 29607 THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 2005 year_end RET   HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE   1880000 0 0 2006-02-08T00:00:00-05:00
394556 CELANESE CORPORATION 3a29c09f-ff90-4060-9531-0fa5933c5d27 YY CELANESE CORPORATION 48942 CELANESE CORPORATION 2005 year_end RET   Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   100000 0 0 2006-02-08T00:00:00-05:00
394826 WHITMER & WORRALL, LLC cd67cc77-fead-4034-bc79-81a33de25b6b YY WHITMER & WORRALL, LLC 292892 HILL & ROBBINS 2005 year_end RET S 1783 The Pension Security and Transparency Act of 2005 H.R. 2830 The Pension Protection Act of 2005 HOUSE OF REPRESENTATIVES,SENATE,White House Office 60000   0 0 2006-02-08T00:00:00-05:00
394982 CMFG LIFE INSURANCE COMPANY da4de918-a335-4379-b1de-cb16b915ee2f YY CMFG LIFE INSURANCE COMPANY 80510 CMFG LIFE INSURANCE COMPANY 2005 year_end RET   HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Credit Union Administration (NCUA),SENATE,Treasury, Dept of   250000 0 0 2006-02-08T00:00:00-05:00
394989 PAUL SMITH (DBA AS POLICY CONS SERVICES cff63c4c-5f3a-4407-a9ce-ce18f44e50e2 YY PAUL SMITH (DBA AS POLICY CONS SERVICES 48144 UNITED PARCEL SERVICE 2005 year_end RET   Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 60000   0 0 2006-02-08T00:00:00-05:00
394995 CLARK & WEINSTOCK c58d69fb-ea78-40bf-a01b-ce6b9b4ae34a YT CLARK & WEINSTOCK 9443 AT&T 2005 year_end RET     120000   0 0 2006-02-08T00:00:00-05:00
395008 NESTLE USA 6ca3b6fc-cbf6-4d01-a414-ccd392556313 YY NESTLE USA 29037 NESTLE USA 2005 year_end RET   Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Security Council (NSC),SENATE,State, Dept of (DOS),U.S. Agency for International Development (USAID),U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR)   450000 0 0 2006-02-08T00:00:00-05:00
395015 EASTMAN CHEMICAL COMPANY 49f9399f-ee33-4ac3-8bfa-d0af37a7bf61 YY EASTMAN CHEMICAL COMPANY 13005 EASTMAN CHEMICAL COMPANY 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE,U.S. International Trade Commission (ITC)   320000 0 0 2006-02-08T00:00:00-05:00
395043 CARDENAS PARTNERS, LLC 1d12653f-c039-4d46-909b-de0606597799 YY CARDENAS PARTNERS, LLC 284573 UNITED BROTHERHOOD OF CARPENTERS & JOINERS AMERICAN 2005 year_end RET   SENATE 60000   0 0 2006-02-08T00:00:00-05:00
395156 PRUDENTIAL FINANCIAL, INC. 9da09116-2346-40b1-9159-fb240ac19755 YY PRUDENTIAL FINANCIAL, INC. 32338 PRUDENTIAL FINANCIAL INC 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE   2055245 0 0 2006-02-08T00:00:00-05:00
395198 COVINGTON & BURLING LLP dd7e2b37-9ddf-442a-9ece-385cf778d610 YY COVINGTON & BURLING LLP 11195 ERISA INDUSTRY COMMITTEE 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2006-02-08T00:00:00-05:00
395203 NORTHWEST AIRLINES, INC. (ACQUIRED BY DELTA AIR LINES, INC.) ce4e2e3a-b5d3-40d0-a91b-71a6bc090426 YY NORTHWEST AIRLINES, INC. (ACQUIRED BY DELTA AIR LINES, INC.) 29573 NORTHWEST AIRLINES INC (ACQUIRED BY DELTA AIR LINES INC ) 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE   919220 0 0 2006-02-08T00:00:00-05:00
395214 EATON CORPORATION f3ede27d-df29-4f93-b028-7c6b0d8c2bf7 YY EATON CORPORATION 302698 EATON CORPORATION 2005 year_end RET HR 2830/S 1783 pension reform HOUSE OF REPRESENTATIVES,SENATE   220000 0 0 2006-02-08T00:00:00-05:00
395276 CNA FINANCIAL CORPORATION ac1e359e-70bc-482f-8bee-a2c434746e44 YY CNA FINANCIAL CORPORATION 9580 CNA FINANCIAL CORPORATION 2005 year_end RET   Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Personnel Management (OPM),SENATE,Treasury, Dept of   220000 0 0 2006-02-08T00:00:00-05:00
395344 FIERCE, ISAKOWITZ & BLALOCK acee3133-6086-465c-bae7-b1b6a90993a8 YY FIERCE, ISAKOWITZ & BLALOCK 44812 VIACOM 2005 year_end RET     140000   0 0 2006-02-08T00:00:00-05:00
395396 CLARK & WEINSTOCK dafcb8e0-e9ff-45ca-8201-1cab15e2cc27 YY CLARK & WEINSTOCK 9443 SALLIE MAE INC 2005 year_end RET   HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 120000   0 0 2006-02-08T00:00:00-05:00
395443 TIMMONS AND COMPANY, INC. a2a61bd7-1207-401f-96bd-759203728f11 YY TIMMONS AND COMPANY, INC. 38164 AMERICAN COUNCIL OF LIFE INSURERS 2005 year_end RET   Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 180000   0 0 2006-02-09T00:00:00-05:00
395594 TIMMONS AND COMPANY, INC. 8099b844-cefc-499c-a636-239074d0b075 YY TIMMONS AND COMPANY, INC. 38164 COX ENTERPRISES INC 2005 year_end RET   Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 180000   0 0 2006-02-09T00:00:00-05:00
395624 JOLLY/RISSLER, INC. 89a98803-e7db-4111-9358-1a4920e250e3 YY JOLLY/RISSLER, INC. 20835 WASHINGTON COUNCIL ERNST & YOUNG 2005 year_end RET   Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 80000   0 0 2006-02-09T00:00:00-05:00
395835 CASE NEW HOLLAND INDUSTRIAL INC. 16dd662d-847a-47ce-9a69-73f109c40826 YY CASE NEW HOLLAND INDUSTRIAL INC. 59832 CASE NEW HOLLAND INDUSTRIAL INC 2005 year_end RET Pension reform legislation Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,SENATE   160000 0 0 2006-02-09T00:00:00-05:00
395930 NATIONAL ASSOCIATION OF POSTMASTERS OF THE UNITED STATES 51bd87cf-2115-4fc7-94b1-922eb5836ba6 YY NATIONAL ASSOCIATION OF POSTMASTERS OF THE UNITED STATES 27002 NATIONAL ASSOCIATION OF POSTMASTERS OF THE UNITED STATES 2005 year_end RET H.R.147 S.619 H.R.750 H.R.1690 H.R.1714 S.866 H.R.55 H.R.663 H.R.994 S.484 HOUSE OF REPRESENTATIVES,SENATE,White House Office   79000 0 0 2006-02-09T00:00:00-05:00
395981 AVENUE SOLUTIONS 75f3f9b8-7e30-49fe-81f6-a5bc9aaef963 YY AVENUE SOLUTIONS 72111 NORTHWEST AIRLINES 2005 year_end RET HR.2106 Employee Pension Preservation and Taxpayer Protection Act of 2005Ž HR.2830 The Pension Protection ActŽ S.685 Pension Benefit Guarantee Corporation Pilots Equitable Treatment ActŽ S.861 Employee Preservation Act of 2005Ž S.1783 Pension Security & TransparencyŽ HOUSE OF REPRESENTATIVES,SENATE 84000   0 0 2006-02-09T00:00:00-05:00
396033 DEERE & COMPANY b0ec44ee-9e96-457c-b5c1-aee8e36e2a47 YY DEERE & COMPANY 11878 DEERE & COMPANY 2005 year_end RET S 219: National Employee Savings & Trust Gurantee Act HR 2830: Pension Protection Act HR 2831: Pension Preservation & Portability Act S 1158: Stop Terminating Our Pensions Act Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   420000 0 0 2006-02-09T00:00:00-05:00
396151 MELLON FINANCIAL SERVICES CORPORATION #1 6529e9d2-d5c2-4ec6-b9aa-cf60e6dfd9a4 YY MELLON FINANCIAL SERVICES CORPORATION #1 24863 MELLON FINANCIAL SERVICES CORPORATION #1 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE   120000 0 0 2006-02-09T00:00:00-05:00
396164 TIAA 4812d254-1250-4514-9471-cd76e1a137aa YY TIAA 55757 TIAA 2005 year_end RET   Education, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,White House Office   760000 0 0 2006-02-09T00:00:00-05:00
396256 TIMMONS AND COMPANY, INC. a73e9d6b-e772-4000-b341-de4cc4ff78f1 YT TIMMONS AND COMPANY, INC. 38164 AT&T 2005 year_end RET   Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 180000   0 0 2006-02-09T00:00:00-05:00
396367 JOLLY/RISSLER, INC. 95b04d7a-8214-4e94-95ff-e4bfbd6176aa YY JOLLY/RISSLER, INC. 20835 CNA FINANCIAL CORPORATION 2005 year_end RET   Environmental Protection Agency (EPA),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Personnel Management (OPM),SENATE,Treasury, Dept of 60000   0 0 2006-02-09T00:00:00-05:00
396373 THE LOEFFLER GROUP d8c3e6d6-cbc8-43d0-b7fe-d5b03cdfc338 YY THE LOEFFLER GROUP 64634 INVESTMENT CO INSTITUTE 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2006-02-09T00:00:00-05:00
396529 MUTUAL OF OMAHA fb52eae6-5efb-43cd-8535-0b5154fb70f7 YY MUTUAL OF OMAHA 26284 MUTUAL OF OMAHA 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE   440000 0 0 2006-02-09T00:00:00-05:00
397294 ASSOCIATION FOR FINANCIAL PROFESSIONALS 3c985284-447d-419c-82ca-d65f980fd157 YY ASSOCIATION FOR FINANCIAL PROFESSIONALS 38437 ASSOCIATION FOR FINANCIAL PROFESSIONALS 2005 year_end RET   Commodity Futures Trading Commission (CFTC),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of the Vice President of the United States,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of   20000 0 0 2006-02-10T00:00:00-05:00
397408 TIMMONS AND COMPANY, INC. 1b71b76d-1b7b-42cb-8abf-49fa23548d4a YY TIMMONS AND COMPANY, INC. 38164 MICRON TECHNOLOGY INC 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 180000   0 0 2006-02-10T00:00:00-05:00
397424 SQUIRE PATTON BOGGS aa6f24f4-9f02-472d-b3d0-4c2142278fe8 YY SQUIRE PATTON BOGGS 30906 NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2006-02-10T00:00:00-05:00
397437 TRANSPORTATION COMMUNICATIONS NATIONAL UNION/IAM (FKA TRANSPORTATION COMMUNICATI 990cc299-3e4c-4b69-9910-95d984980869 YY TRANSPORTATION COMMUNICATIONS NATIONAL UNION/IAM (FKA TRANSPORTATION COMMUNICATI 38368 TRANSPORTATION COMMUNICATIONS NATIONAL UNION/IAM (FKA TRANSPORTATION COMMUNICATI 2005 year_end RET   HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Surface Transportation Board (STB),Transportation, Dept of (DOT)   240000 0 0 2006-02-10T00:00:00-05:00
397467 SALT RIVER PROJECT 299167dc-da8e-4093-915d-50dbcda63453 YY SALT RIVER PROJECT 34216 SALT RIVER PROJECT 2005 year_end RET   Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE   180000 0 0 2006-02-10T00:00:00-05:00
397504 FORD MOTOR COMPANY 1a393777-9948-4df3-8762-4a450ed6adf4 YY FORD MOTOR COMPANY 15133 FORD MOTOR COMPANY 2005 year_end RET   Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Reserve System,Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Highway Traffic Safety Administration (NHTSA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,White House Office   4800000 0 0 2006-02-10T00:00:00-05:00
397549 METROPOLITAN LIFE INSURANCE CO 6c923f8a-005d-4dcb-a557-57a0a99a0ade YY METROPOLITAN LIFE INSURANCE CO 25022 METROPOLITAN LIFE INSURANCE CO 2005 year_end RET Pension reform; qualified annuities; cash balance - H.R. 2830; H.R. 2951; S. 1359; S. 219; S. 1783; H.R. 2831 Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Social Security Administration (SSA),State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR) 2340000   0 0 2006-02-10T00:00:00-05:00
397564 AMERIPRISE FINANCIAL, INC. 0fc50ca0-f28b-46eb-a95d-937f3f4c5865 YY AMERIPRISE FINANCIAL, INC. 302313 AMERIPRISE FINANCIAL, INC. 2005 year_end RET   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of   104374 0 0 2006-02-10T00:00:00-05:00
397582 GOLDMAN, SACHS & CO. 51120e0a-74f6-4c63-825a-551675c90b8f YY GOLDMAN, SACHS & CO. 300798 GOLDMAN SACHS & CO 2005 year_end RET   Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) 600000   0 0 2006-02-10T00:00:00-05:00
397632 TIMMONS AND COMPANY, INC. 5de97d76-56b5-4c1b-9332-9ab0fe920a86 YY TIMMONS AND COMPANY, INC. 38164 CHRYSLER LLC 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 190000   0 0 2006-02-10T00:00:00-05:00
397642 LIBERTY SQUARE DC, LLC b7b48c84-c23d-49b9-9695-b64a865b02e3 YY LIBERTY SQUARE DC, LLC 87335 AVENUE SOLUTIONS 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2006-02-10T00:00:00-05:00
397969 THE DUBERSTEIN GROUP INC. 631d1b9b-378e-4110-9253-08e66424575f YY THE DUBERSTEIN GROUP INC. 12675 BUSINESS ROUNDTABLE 2005 year_end RET   Agriculture, Dept of (USDA),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office 100000   0 0 2006-02-10T00:00:00-05:00
397982 MBNA CORP 3ee0642d-88dd-4c16-b53b-0b374f2bbad7 YT MBNA CORP 24180 MBNA CORP 2005 year_end RET   Federal Reserve System,HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE 1956888   0 0 2006-02-10T00:00:00-05:00
398014 SQUIRE PATTON BOGGS c30acbda-7fd0-4b67-bb06-771b81cd7a38 YY SQUIRE PATTON BOGGS 30906 PEACE OFFICERS RESEARCH ASSOCIATION OF CALIFORNIA 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2006-02-10T00:00:00-05:00
398332 ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 01887efb-97f7-46f8-bb3d-2bb3b353e876 YY ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 57475 AMERICAN STAFFING ASSOCIATION 2005 year_end RET   HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of 40000   0 0 2006-02-10T00:00:00-05:00
398444 RICH FEUER ANDERSON acd23ea1-e3c8-441c-bedb-8d80aa0af4d8 YY RICH FEUER ANDERSON 84775 GOLDMAN SACHS & CO 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2006-02-10T00:00:00-05:00
398568 RICH FEUER ANDERSON 7a0c1d73-e619-4c1b-b3b5-3ebb525c14b5 YY RICH FEUER ANDERSON 84775 MANAGED FUNDS ASSN 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2006-02-10T00:00:00-05:00
398571 CON-WAY INC (FORMERLY KNOWN AS CNF INC) 0fdb8673-5898-41e4-ab5b-3ecb5b7503b4 YY CON-WAY INC (FORMERLY KNOWN AS CNF INC) 9591 CON-WAY INC (FORMERLY KNOWN AS CNF INC) 2005 year_end RET H.R.2830 : To amend the Employee Retirement Income Security Act of 1974 and the Internal Revenue Code of 1986 to reform the pension funding rules, and for other purposes. - Meppa reform Federal Highway Administration (FHA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)   740000 0 0 2006-02-10T00:00:00-05:00
398607 SAFEWAY INC. 0fc64df0-fdbf-43fe-a5f9-c8bb9a614e4a YY SAFEWAY INC. 300173 SAFEWAY 2005 year_end RET   Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2006-02-10T00:00:00-05:00
398731 ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) b76a5860-93aa-4f79-8eb6-db7436a2ea39 YY ERNST & YOUNG LLP (WASHINGTON COUNCIL ERNST & YOUNG) 57475 AK STEEL HOLDING CORPORATION 2005 year_end RET     120000   0 0 2006-02-10T00:00:00-05:00
398872 FMC CORPORATION 88634e48-a176-4bbd-bb98-fd4d9fce601b YY FMC CORPORATION 15031 FMC CORPORATION 2005 year_end RET       733908 0 0 2006-02-10T00:00:00-05:00
399070 SQUIRE PATTON BOGGS 4c9b3c2b-ef79-497d-b6ac-815e12b847d0 YY SQUIRE PATTON BOGGS 30906 NEW YORK LIFE INSURANCE COMPANY 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2006-02-10T00:00:00-05:00
399080 DUANE MORRIS GOVERNMENT AFFAIRS 7b50d891-32bd-484b-bd6a-220c9028caa9 YY DUANE MORRIS GOVERNMENT AFFAIRS 49657 NATIONAL ASSOCIATION OF REAL ESTATE INVESTMENT TRUSTS 2005 year_end RET   HOUSE OF REPRESENTATIVES,SENATE 37500   0 0 2006-02-10T00:00:00-05:00
399193 DEERE & COMPANY a799735a-22ef-427a-82bc-25846b7e5ce5 YA DEERE & COMPANY 11878 DEERE & COMPANY 2005 year_end RET S 219: National Employee Savings & Trust Gurantee Act HR 2830: Pension Protection Act HR 2831: Pension Preservation & Portability Act S 1158: Stop Terminating Our Pensions Act Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   420000 0 0 2006-02-10T00:00:00-05:00

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 1005.178ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API