lobbying: lobbying_activities: 348 rows where filing_period = "year_end", filing_year = 2004 and issue_code = "AVI" sorted by filing

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

348 rows where filing_period = "year_end", filing_year = 2004 and issue_code = "AVI" sorted by filing_year descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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	received_date
288005	RYAN MACKINNON VASAPOLI AND BERZOK, LLP ca23df6d-b990-4dad-99cd-55fcfa2bdbb0	YY	RYAN MACKINNON VASAPOLI AND BERZOK, LLP	30187	AIR TRANSPORT ASSOCIATION	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	100000		2004-02-11T00:00:00-05:00
288120	RICHARD F. HOHLT 00de1042-cfee-49d0-b2a2-d2c0be75235b	YY	RICHARD F. HOHLT	18433	NORTHWEST AIRLINES	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	35000		2004-02-11T00:00:00-05:00
288405	BATES CAPITOL GROUP LLC c7a1478e-0a20-47e5-b9fb-10103ecebb6b	YY	BATES CAPITOL GROUP LLC	86414	UNITED PARCEL SERVICE	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE	60000		2004-02-15T00:00:00-05:00
288576	NATIONAL BUSINESS AVIATION ASSOCIATION, INC. 2d3cba8f-15ed-4e8e-9cd1-143cd7271778	YY	NATIONAL BUSINESS AVIATION ASSOCIATION, INC.	27332	NATIONAL BUSINESS AVIATION ASSOCIATION INC	2004	year_end	AVI		Commerce, Dept of (DOC),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Aeronautics & Space Administration (NASA),Natl Transportation Safety Board (NTSB),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,White House Office		200000	2004-02-23T00:00:00-05:00
319255	SAMS, LETHA fdd554b5-df68-43a2-90ca-15792aaf4bc2	YY	SAMS, LETHA	291515	SAMS LETHA ET AL	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,White House Office	0		2004-10-18T00:00:00-04:00
319972	NATIONAL GROUP, LLP 6ef8f53d-67ca-4a14-a91d-584dbc655c62	YY	NATIONAL GROUP, LLP	66090	DELTA AIRLINES	2004	year_end	AVI	Airline Security	HOUSE OF REPRESENTATIVES,SENATE	60000		2004-12-21T00:00:00-05:00
319987	NATIONAL GROUP, LLP 11a4f3b5-ec73-4de5-bc0c-b6b3226e06bb	YY	NATIONAL GROUP, LLP	66090	EQUIFAX	2004	year_end	AVI	Specific lobbying issues Security for Airport	HOUSE OF REPRESENTATIVES,SENATE	20000		2004-12-21T00:00:00-05:00
320334	PILLSBURY WINTHROP SHAW PITTMAN LLP 004b52af-06a6-4a0c-8ed5-9ff5ddd89f27	YT	PILLSBURY WINTHROP SHAW PITTMAN LLP	35002	BRANSON AIRPORT	2004	year_end	AVI		Federal Aviation Administration (FAA)	0		2005-01-05T00:00:00-05:00
320376	PILLSBURY WINTHROP SHAW PITTMAN LLP afed0ae9-ba6d-455a-9366-f31e03bc6361	YY	PILLSBURY WINTHROP SHAW PITTMAN LLP	35002	ENSCO	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation Security Administration (TSA)	40000		2005-01-05T00:00:00-05:00
320379	PILLSBURY WINTHROP SHAW PITTMAN LLP e2608a0b-534e-4dfd-9c7d-f9b95ffd1876	YY	PILLSBURY WINTHROP SHAW PITTMAN LLP	35002	CITY OF BAKERSFIELD CALIFORNIA	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES	0		2005-01-05T00:00:00-05:00
320392	PILLSBURY WINTHROP SHAW PITTMAN LLP aac4ce87-3fba-47dc-8be9-4442c8646145	YY	PILLSBURY WINTHROP SHAW PITTMAN LLP	35002	MIAMI-DADE AVIATION DEPT	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE,Transportation Security Administration (TSA)	40000		2005-01-05T00:00:00-05:00
320669	DENNY MILLER ASSOCIATES 78040ad1-34d0-446f-a82a-fc8e33f15b3d	YY	DENNY MILLER ASSOCIATES	25328	ALASKA AIR GROUP	2004	year_end	AVI	HR 4818, Consolidated Appropriations Act, Division H, Title II, FAA (Federal Aviation Administration) facilities and engineering funding.	HOUSE OF REPRESENTATIVES,SENATE	40000		2005-01-12T00:00:00-05:00
320671	DENNY MILLER ASSOCIATES 4e927148-8cb2-47a3-b28b-7b54aa194e80	YY	DENNY MILLER ASSOCIATES	25328	AMERICAN ASSOCIATION OF AIRPORT EXECUTIVES / AIRPORTS COUNCIL INTERNATIONAL	2004	year_end	AVI	Aviation Policy Issues, no specific bills.	HOUSE OF REPRESENTATIVES,SENATE	10000		2005-01-12T00:00:00-05:00
320682	DENNY MILLER ASSOCIATES 808604fd-05aa-4cea-be5b-2fb7a45a7bd2	YY	DENNY MILLER ASSOCIATES	25328	BOEING COMPANY	2004	year_end	AVI	HR 5025/S.2806, Making Appropriations for Departments of Transportation, Treasury, and Independent Agencies, issues pertaining to Federal Aviation Administration and F&E issues. HR 4818, Consolidated Appropriations Act, 2005, Division H: Departments of Transportation and Treasury, Federal Aviation Administration and F&E issues.	Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE	60000		2005-01-12T00:00:00-05:00
320832	UNIVERSITY OF ILLINOIS c65b0f9a-f3a6-4847-ba52-8664b44cef37	YY	UNIVERSITY OF ILLINOIS	39427	UNIVERSITY OF ILLINOIS	2004	year_end	AVI		Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Federal Aviation Administration (FAA),Federal Highway Administration (FHA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),Natl Endowment for the Arts,Natl Foundation on the Arts & Humanities,Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID),U.S. Forest Service,Veterans Affairs, Dept of (VA)		36743	2005-01-13T00:00:00-05:00
320948	DENNY MILLER ASSOCIATES 05a91442-308a-4907-9881-bc9b995ba3c4	YY	DENNY MILLER ASSOCIATES	25328	FEDEX CORPORATION	2004	year_end	AVI	HR 5025/S.2825, Transportation and Treasury Appropriations Act, 2005, Aviation Security issues. HR 4818, Consolidated Appropriations Act, 2005, Division H: Transportation and Treasury Departments, Aviation Security issues.	HOUSE OF REPRESENTATIVES,SENATE	20000		2005-01-13T00:00:00-05:00
320971	DENNY MILLER ASSOCIATES 2238159b-e213-4733-b9e5-d0a2ab31573b	YY	DENNY MILLER ASSOCIATES	25328	AERIES (AKA PRECISION AEROSPACE CORP AND AKA PACIFIC PROPELLER)	2004	year_end	AVI	Policy relating to Aircraft Efficency Issues. No specific bills.	HOUSE OF REPRESENTATIVES,SENATE	20000		2005-01-13T00:00:00-05:00
321068	BONNIE H. WEINSTEIN 7e06a31b-de51-4dd2-9e99-beefee95a54a	YY	BONNIE H. WEINSTEIN	56235	AIR TRACTOR INC	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	40000		2005-01-14T00:00:00-05:00
321271	CLEMENT, ROBERT N 6a160189-19db-4d5d-aaf7-8079291c1e92	YY	CLEMENT, ROBERT N	290957	STOKES BARTHOLOMEW EVANS & PETREE FOR METROPOLITAN NASHVILLE AIRPORT AUTHORITY	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	0		2005-01-21T00:00:00-05:00
321280	CASH, SMITH & WAGES 14240a1d-4404-4c0f-b599-a6d71267ebb0	YY	CASH, SMITH & WAGES	8420	ASSOCIATION OF PROFESSIONAL FLIGHT ATTENDANTS	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation Security Administration (TSA)	40000		2005-01-21T00:00:00-05:00
321421	ITOCHU INTL INC 4def9887-6c06-421f-a026-6f674f4ecdce	YY	ITOCHU INTL INC	67490	ITOCHU INTL INC	2004	year_end	AVI	-US-Japan Aviation Cooperation in Asia (APEC) -Iraqi reconstruction -Okinawa dual purpose airport -CNS/ATM System	Army, Dept of (Other),Commerce, Dept of (DOC),Defense, Dept of (DOD),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),Natl Security Council (NSC),State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Agency for International Development (USAID),U.S. Marines,U.S. Trade & Development Agency (USTDA)	20000		2005-01-24T00:00:00-05:00
321604	PAULEY MANAGEMENT INC. 96bf7cca-a6ff-4152-b74c-67db7256b7da	YY	PAULEY MANAGEMENT INC.	47187	TITUSVILLE-COCOA AIRPORT AUTHORITY	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	0		2005-01-25T00:00:00-05:00
321677	AIR LINE PILOTS ASSOCIATION 1c05ed6a-4867-4c46-99fb-9a78d31712c2	YY	AIR LINE PILOTS ASSOCIATION	580	AIR LINE PILOTS ASSOCIATION	2004	year_end	AVI	H.R. 1063 - Pilot Age 60, H.R. 2144 - Aviation Security and Technical Corrections; H.R. 4056 - Anti-missile protection for airliners; H.R. 4341 - Postal Reform; H.R. 4126 - Federal Flight Deck Officer Program; H.R. 4567 - FY 05 Appropriations, Department of Homeland Security; H.R. 5025 - FY 05 Appropriations, Department of Transportation; H.R. 10 - 9/11 Commission Recommendations; H.R. 5250 -Federal Flight Deck Officer Improvement Act S. 165 - Air Cargo Security; S. 311 - Anti-missle protection airliners; S. 959 - Pilot Age 60; S. 2268 - Federal Flight Deck Officer Program; S. 2393 - Aviation Security; S. 2537 - FY 05 Appropriations, Department of Homeland Security; S. 2806 - FY 05 Appropriations, Department of Transportation; S. 2845 - 9/11 Commission Recommendations	HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)		340000	2005-01-25T00:00:00-05:00
321738	MICHAEL N. MATTON AND ASSOCIATES, L.L.C. 095cd6d4-ce3a-472d-930c-0ada8a4ff008	YY	MICHAEL N. MATTON AND ASSOCIATES, L.L.C.	288910	BOEING COMPANY	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	80000		2005-01-26T00:00:00-05:00
321833	VERTICAL AVIATION INTERNATIONAL 6d510bcb-757c-4a08-b34f-64c879cbb9bb	YY	VERTICAL AVIATION INTERNATIONAL	18001	VERTICAL AVIATION INTERNATIONAL	2004	year_end	AVI		Agriculture, Dept of (USDA),Federal Aviation Administration (FAA),General Services Administration (GSA),Government Accountability Office (GAO),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Natl Park Service (NPS),Natl Transportation Safety Board (NTSB),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Secret Service		60000	2005-01-26T00:00:00-05:00
321943	FLIR GOVERNMENT SYSTEMS, INC. a4ccdaf2-8a97-41d4-8338-e26cca70fe7e	YY	FLIR GOVERNMENT SYSTEMS, INC.	48838	FLIR GOVERNMENT SYSTEMS, INC	2004	year_end	AVI		Agriculture, Dept of (USDA),Air Force, Dept of,Army, Dept of (Other),Central Intelligence Agency (CIA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Navy, Dept of,SENATE,State, Dept of (DOS),Treasury, Dept of		220000	2005-01-26T00:00:00-05:00
322180	NORTHWEST AIRLINES, INC. (ACQUIRED BY DELTA AIR LINES, INC.) 568608e9-0a7b-4b94-972a-06f955cac4a2	YY	NORTHWEST AIRLINES, INC. (ACQUIRED BY DELTA AIR LINES, INC.)	29573	NORTHWEST AIRLINES INC (ACQUIRED BY DELTA AIR LINES INC )	2004	year_end	AVI	HRes 236 - Expressing the sense of the House of Representative that United States air carriers should establish for all members of the Armed Forces on active duty reduced fares that are comparable to the lowest airfare for ticketed flights, and for other purposes. HR 6 - To enhance energy conservation and research and development, to provide for security and diversity in the energy supply for the American people, and for other purposes. HR 580 - Commercial Airline Missile Defense Act HR 592 - National Aivation Capacity Expansion Act of 2003 HR 1049 - Arming Cargo Pilost Against Terrorism Act HR 1063 - To limit the age restriction imposed by the Administrator of the Federal Aviation Administration for the issuance or renewal of certain airman certificates, and for other purposes. HR 1103 - Air Cargo Security Act HR 1366 - Air Industry Stabilization Act of 2003 HR 1889 - Flight Attendant Certificate Act HR 2144 - Aviation Security Technical Corrections and Improvements Act of 2003. HR 2271 - Second Century of Flight Act HR 2455 - Universal Scrrening of Air Cargo Act HR 2632 - Safe Aviation and Flight Enhancement Act HR 3262 - To amend section 44921 of title 49, United States Code, to provide for the arming of cargo pilots against terrorism. HR 3798 - Secure Existing Aviation Loopholes Act. HR 4056 - Commercial Aviation MANPADS Defense Act of 2004. HR 4130 - Operation Hero Miles Act of 2004. HR 4341 - Postal Accountability and Enhancement Act. HR 4801 - To direct the Administrator of the Federal Aviation Administration to issue an order regarding secondary cockpit barriers. HR 4970 - Passenger Security Act of 2004. HR 5024 - 9/11 Commission Recommendations Implemenation Act of 2004. HR 5040 - 9/11 Commission Report Implementation Act of 2004. HR 5250 - Federal Flight Deck Officer Improvement Act of 2004. --------------------------------------------------------------- S 83 - National Aviation Capacity Expansion Act of 2003. S 165 - Air Cargo Security Improvement Act. S 338 - Safe and Secure …	Agriculture, Dept of (USDA),Air Force, Dept of,Army, Dept of (Other),Commerce, Dept of (DOC),Defense, Dept of (DOD),Defense Intelligence Agency (DIA),Education, Dept of,Energy, Dept of,Federal Aviation Administration (FAA),Federal Bureau of Investigation (FBI),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Navy, Dept of,Peace Corps,Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Information Agency (USIA),U.S. Marines,U.S. Postal Service (USPS),U.S. Secret Service,White House Office		1298556	2005-01-28T00:00:00-05:00
322309	PROFESSIONAL AVIATION SAFETY SPECIALISTS 5ee1c211-c096-46f2-a3f5-c99ac7fc7909	YY	PROFESSIONAL AVIATION SAFETY SPECIALISTS	32260	PROFESSIONAL AVIATION SAFETY SPECIALISTS	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)		120000	2005-01-28T00:00:00-05:00
322402	NORTHWEST AIRLINES, INC. (ACQUIRED BY DELTA AIR LINES, INC.) dcf04e38-3fcd-4373-86f0-f3f279120e45	YA	NORTHWEST AIRLINES, INC. (ACQUIRED BY DELTA AIR LINES, INC.)	29573	NORTHWEST AIRLINES INC (ACQUIRED BY DELTA AIR LINES INC )	2004	year_end	AVI	HRes 236 - Expressing the sense of the House of Representative that United States air carriers should establish for all members of the Armed Forces on active duty reduced fares that are comparable to the lowest airfare for ticketed flights, and for other purposes. HR 6 - To enhance energy conservation and research and development, to provide for security and diversity in the energy supply for the American people, and for other purposes. HR 580 - Commercial Airline Missile Defense Act HR 592 - National Aivation Capacity Expansion Act of 2003 HR 1049 - Arming Cargo Pilost Against Terrorism Act HR 1063 - To limit the age restriction imposed by the Administrator of the Federal Aviation Administration for the issuance or renewal of certain airman certificates, and for other purposes. HR 1103 - Air Cargo Security Act HR 1366 - Air Industry Stabilization Act of 2003 HR 1889 - Flight Attendant Certificate Act HR 2144 - Aviation Security Technical Corrections and Improvements Act of 2003. HR 2271 - Second Century of Flight Act HR 2455 - Universal Scrrening of Air Cargo Act HR 2632 - Safe Aviation and Flight Enhancement Act HR 3262 - To amend section 44921 of title 49, United States Code, to provide for the arming of cargo pilots against terrorism. HR 3798 - Secure Existing Aviation Loopholes Act. HR 4056 - Commercial Aviation MANPADS Defense Act of 2004. HR 4130 - Operation Hero Miles Act of 2004. HR 4341 - Postal Accountability and Enhancement Act. HR 4801 - To direct the Administrator of the Federal Aviation Administration to issue an order regarding secondary cockpit barriers. HR 4970 - Passenger Security Act of 2004. HR 5024 - 9/11 Commission Recommendations Implemenation Act of 2004. HR 5040 - 9/11 Commission Report Implementation Act of 2004. HR 5250 - Federal Flight Deck Officer Improvement Act of 2004. --------------------------------------------------------------- S 83 - National Aviation Capacity Expansion Act of 2003. S 165 - Air Cargo Security Improvement Act. S 338 - Safe and Secure …	Agriculture, Dept of (USDA),Air Force, Dept of,Army, Dept of (Other),Commerce, Dept of (DOC),Defense, Dept of (DOD),Defense Intelligence Agency (DIA),Education, Dept of,Energy, Dept of,Federal Aviation Administration (FAA),Federal Bureau of Investigation (FBI),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Navy, Dept of,Peace Corps,Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Information Agency (USIA),U.S. Marines,U.S. Postal Service (USPS),U.S. Secret Service,White House Office		1298556	2005-01-28T00:00:00-05:00
322705	DENNY MILLER ASSOCIATES 86d0b0fa-627f-447e-9675-8f646cd9d571	YY	DENNY MILLER ASSOCIATES	25328	NORTHROP GRUMMAN CORP	2004	year_end	AVI	Federal Aviation Administration and F & E funding issues	HOUSE OF REPRESENTATIVES,SENATE	20000		2005-02-01T00:00:00-05:00
322706	AB MANAGEMENT ASSOCIATES 3b6d1e6b-cbbf-4363-bf87-1c728f3752cb	YY	AB MANAGEMENT ASSOCIATES	33	PEGASUS MANAGEMENT	2004	year_end	AVI	All legislation relating to airports, airport safety, capacity, development, facilities and equipment, operations and related programs. Department of Transportation, Treasury and Independent Agencies Appropriations Bill;FAA title and programs.	Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)			2005-02-01T00:00:00-05:00
322719	AB MANAGEMENT ASSOCIATES 0a768969-762e-4965-9f0a-8f19a5d56bdd	YY	AB MANAGEMENT ASSOCIATES	33	LOCKHEED MARTIN	2004	year_end	AVI	All legislation relating to Air Traffic Control System modernization, NAS Modernization, aviation, aviation safety, airports, airport safety, capacity, development, Facilities and Equipment, Operations, Research and Development and related programs. Department of Transportation, Treasury and Independent Agencies appropriations bill; FAA title and programs.	Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)			2005-02-01T00:00:00-05:00
322720	AB MANAGEMENT ASSOCIATES 0cad97f7-b480-4421-88ef-89de4aa55bec	YY	AB MANAGEMENT ASSOCIATES	33	CITY OF VERO BEACH FL	2004	year_end	AVI	All legislation relating to airports, airport safety, development, facilities and equipment, research and development and related programs. DOT and Related Agencies Appropriations Bill, FAA title and programs.	Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)			2005-02-01T00:00:00-05:00
322721	AB MANAGEMENT ASSOCIATES 864198a7-089d-492d-8699-0cf14927ca16	YY	AB MANAGEMENT ASSOCIATES	33	MEGAPULSE	2004	year_end	AVI	All legislation relating to airports, airport safety, capacity, development,facilities and equipment, operations and related programs. Department of Transportation, Treasury and Independent Agencies Appropriations Bill; FAA title and programs.	Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)			2005-02-01T00:00:00-05:00
322722	AB MANAGEMENT ASSOCIATES e1b99b34-13d8-4886-a170-2ce6e5bf4f71	YY	AB MANAGEMENT ASSOCIATES	33	AMERICAN ASSN OF AIRPORT EXECUTIVES	2004	year_end	AVI	All legislation relating to airports, airport safety, capacity, development, facilities and equipment, operations and related programs. DOT and related Agencies Appropriations Bill, FAA title and programs.	Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)			2005-02-01T00:00:00-05:00
322723	AB MANAGEMENT ASSOCIATES 08ecdd78-da32-4cc8-b822-9ccbf888dbc8	YY	AB MANAGEMENT ASSOCIATES	33	AIRCRAFT OWNERS & PILOTS ASSN	2004	year_end	AVI	All legislation relating to aviation, general aviation, airports, aviation safety, capacity, development, facilities and equipment, operations, modernization and related programs. Department of Transportation, Treasury and Related Agencies Appropriations.	Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)			2005-02-01T00:00:00-05:00
322726	BKSH & ASSOCIATES 79d224fe-7ebd-4473-bdb9-8c8112fcdd7a	YY	BKSH & ASSOCIATES	6291	DAYTON AREA CHAMBER OF COMMERCE/MIAMI VALLEY REGIONAL COMMISSION	2004	year_end	AVI	Assist Dayton International Airport with Air Traffic Control Tower FY'04 Appropriations	Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE	30000		2005-02-01T00:00:00-05:00
322892	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC d6a3f306-c359-4f54-8dc3-1a20101a5143	YY	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	CHOICEPOINT INC	2004	year_end	AVI		Bureau of Citizenship & Immigration Services (BCIS),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),Transportation, Dept of (DOT),Transportation Security Administration (TSA)	180000		2005-02-02T00:00:00-05:00
322934	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC 65343b90-5d45-4ddf-b89f-3639966b8854	YY	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	EVERGREEN INTERNATIONAL AIRLINES, INC.	2004	year_end	AVI		Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Reserve System,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Postal Service (USPS)	220000		2005-02-02T00:00:00-05:00
322954	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC ec19673a-4f69-4e90-8335-423d0f5bff06	YY	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	TASER INTERNATIONAL	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	120000		2005-02-02T00:00:00-05:00
322981	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC 5aee781b-af1d-43d8-88fa-5ef410a4638d	YY	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	GIBSON DUNN & CRUTCHER LLP	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Transportation, Dept of (DOT)	20000		2005-02-02T00:00:00-05:00
323021	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC f3f4e712-ef4e-4b50-a394-6be8f7931326	YT	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	ORBITZ	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	60000		2005-02-02T00:00:00-05:00
323040	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC 66dd728a-9cba-4abb-b5c5-7b73cbe99bcc	YY	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	BRITISH AIRWAYS	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	20000		2005-02-02T00:00:00-05:00
323057	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC 844634cf-cda5-456c-a0ba-831889b3398d	YY	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	AMERICAN AIRLINES	2004	year_end	AVI		Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	220000		2005-02-02T00:00:00-05:00
323163	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC fc39e890-c542-48e2-a77c-d74aa1eba155	YY	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	MIDWEST AIRLINES	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	60000		2005-02-02T00:00:00-05:00
323283	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC 66a1cbd2-2085-48af-88ba-af801ab467b5	YY	WEXLER \| WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC	41113	LINCOLN AIRPORT AUTHORITY	2004	year_end	AVI		Transportation, Dept of (DOT)	0		2005-02-02T00:00:00-05:00
323471	JOHN J. FAUSTI & ASSOCIATES, LLC d01c1d5c-e103-4cd2-a075-15d1d4770fbd	YY	JOHN J. FAUSTI & ASSOCIATES, LLC	14234	NATIONAL ASSN OF AIRCRAFT & COMMUNICATION SUPPLIERS	2004	year_end	AVI		Defense, Dept of (DOD),Defense Logistics Agency,HOUSE OF REPRESENTATIVES,SENATE	75000		2005-02-03T00:00:00-05:00
323574	ASSN OF FLIGHT ATTENDANTS 31b31c4f-6ad3-4428-89c5-be6a0f842e33	YT	ASSN OF FLIGHT ATTENDANTS	4573	ASSN OF FLIGHT ATTENDANTS	2004	year_end	AVI		Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Transportation Security Administration (TSA)	100000		2005-02-03T00:00:00-05:00
323704	KESSLER & ASSOCIATES BUSINESS SERVICES b9698901-6810-4ef0-bd7b-499fbb626c67	YY	KESSLER & ASSOCIATES BUSINESS SERVICES	21506	ASTAR AIR CARGO	2004	year_end	AVI	Air Cargo Rights in the US	HOUSE OF REPRESENTATIVES,SENATE	150000		2005-02-04T00:00:00-05:00
323857	AMERICAN AIRLINES, INC. ce38fedb-8a81-4346-87d4-65ffde204aa2	YY	AMERICAN AIRLINES, INC.	1422	AMERICAN AIRLINES INC	2004	year_end	AVI		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)		980000	2005-02-04T00:00:00-05:00
323865	BAKER & HOSTETLER LLP 579d38eb-1d0b-4a51-b92b-97d0cac7bc1c	YY	BAKER & HOSTETLER LLP	5131	BANGOR INTL AIRPORT (CITY OF BANGOR)	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	0		2005-02-04T00:00:00-05:00
323947	GENERAL AVIATION MANUFACTURERS ASSOCIATION 79c5d57f-94e1-4c12-8186-373747b95728	YY	GENERAL AVIATION MANUFACTURERS ASSOCIATION	15942	GENERAL AVIATION MANUFACTURERS ASSOCIATION	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)		210000	2005-02-06T00:00:00-05:00
324125	ROCKWELL COLLINS, INC 072f3351-19be-408d-86a3-33dd068f5071	YY	ROCKWELL COLLINS, INC	68296	ROCKWELL COLLINS, INC	2004	year_end	AVI		Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)		460820	2005-02-07T00:00:00-05:00
324237	GLOBAL BUSINESS TRAVEL ASSOCIATION c7909234-e8b3-424c-895f-c3ab430d1b86	YY	GLOBAL BUSINESS TRAVEL ASSOCIATION	89736	GLOBAL BUSINESS TRAVEL ASSOCIATION	2004	year_end	AVI		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)		20000	2005-02-07T00:00:00-05:00
324251	CAPITAL CONCEPTS 6418eacd-98a3-4bfc-bc35-dfd52a07995c	YY	CAPITAL CONCEPTS	8065	LOCKHEED MARTIN	2004	year_end	AVI		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	27600		2005-02-07T00:00:00-05:00
324276	SERVICE EMPLOYEES INTERNATIONAL UNION CTW-CLC 6855194c-6858-49fc-8656-b62021f58921	YY	SERVICE EMPLOYEES INTERNATIONAL UNION CTW-CLC	34887	SERVICE EMPLOYEES INTERNATIONAL UNION CTW-CLC	2004	year_end	AVI		Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Nuclear Regulatory Commission (NRC),Occupational Safety & Health Administration (OSHA),SENATE		80000	2005-02-07T00:00:00-05:00
324361	HUNTON ANDREWS KURTH LLP 7ecc3634-33fd-409c-8a3d-f80d4ab3d79b	YTY	HUNTON ANDREWS KURTH LLP	18978	CENTRAL WEST VIRGINIA REGIONAL AIRPORT AUTHORITY	2004	year_end	AVI	Proposed regional airport.				2005-02-07T00:00:00-05:00
324434	BEN BARNES GROUP LP 6bef55a3-5f00-4093-8fad-c53e27e1c3d4	YY	BEN BARNES GROUP LP	5415	AMERICAN AIRLINES INC	2004	year_end	AVI		SENATE	45000		2005-02-07T00:00:00-05:00
324444	BLANK ROME GOVERNMENT RELATIONS 6df99379-00ca-4265-aee3-4bbbfa68f2bb	YY	BLANK ROME GOVERNMENT RELATIONS	6325	ALEUTIAN PRIBILOF ISLAND COMMUNITY DEVELOPMENT ASSOCIATION	2004	year_end	AVI	H.R.5025/S.2806 Transportation Treasury Appropriations/Making appropriations for foreign operations, export financing, and related programs for the fiscal year ending September 30, 2005, and for other purposes Omnibus Appropriations, P.L. 108-447.	Air Force, Dept of,Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE	40000		2005-02-07T00:00:00-05:00
324461	UNGARETTI & HARRIS 1706f714-7345-4a98-9aa2-1139389ef687	YY	UNGARETTI & HARRIS	38916	NEWPORT NEWS WILLIAMSBURG INTL AIRPORT	2004	year_end	AVI		Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	0		2005-02-08T00:00:00-05:00
324474	UNGARETTI & HARRIS b63fbb03-2f42-404e-b31b-210a221877d7	YY	UNGARETTI & HARRIS	38916	AKRON-CANTON REGIONAL AIRPORT	2004	year_end	AVI		Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	20000		2005-02-08T00:00:00-05:00
324477	UNGARETTI & HARRIS d2cf6d39-cf67-4fc0-81c7-44e80b208230	YY	UNGARETTI & HARRIS	38916	AIRTRAN AIRWAYS	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	80000		2005-02-08T00:00:00-05:00
324478	UNGARETTI & HARRIS 0c74c115-b0b9-4a54-bd27-5272879fcafb	YY	UNGARETTI & HARRIS	38916	AIR CARRIER ASSN OF AMERICA	2004	year_end	AVI		Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Management & Budget (OMB),SENATE,Transportation Security Administration (TSA)	40000		2005-02-08T00:00:00-05:00
324495	MEYERS AND ASSOCIATES 06be1962-7be2-4c0a-9fbe-964a037d0ae3	YY	MEYERS AND ASSOCIATES	25077	TEXAS A&M RESEARCH FOUNDATION	2004	year_end	AVI		Agriculture, Dept of (USDA),Education, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Justice, Dept of (DOJ),Natl Aeronautics & Space Administration (NASA),SENATE	80000		2005-02-08T00:00:00-05:00
324748	C2 STRATEGIES 86b7da05-2283-46d0-ba02-8291d3a261d1	YY	C2 STRATEGIES	29777	DRS TECHNOLOGIES	2004	year_end	AVI	Represent DRS Technologies, Inc. on issues involving commercial and defense aviation flight data recorder standards.	Defense, Dept of (DOD),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Natl Transportation Safety Board (NTSB),SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	40000		2005-02-08T00:00:00-05:00
324822	NAVY LEAGUE OF THE UNITED STATES 87c25220-bf04-408a-8621-8e8ce77d9741	YY	NAVY LEAGUE OF THE UNITED STATES	28903	NAVY LEAGUE OF THE UNITED STATES	2004	year_end	AVI		Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)		160000	2005-02-08T00:00:00-05:00
324861	UNGARETTI & HARRIS c8f4846e-9a55-4c86-b05c-a4615ade81e4	YY	UNGARETTI & HARRIS	38916	FRONTIER AIRLINES INC	2004	year_end	AVI		Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	60000		2005-02-08T00:00:00-05:00
324938	LIBERTY STRATEGIES LLC 0007c16c-f650-411c-9887-e1de1e627195	YY	LIBERTY STRATEGIES LLC	289671	AMERICAN CIVIL LIBERTIES UNION	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	24000		2005-02-08T00:00:00-05:00
324998	WILSON ASSOCIATES LLC 49d92332-db7c-4525-837a-27d4c681df88	YY	WILSON ASSOCIATES LLC	65533	DC-9 HUSHKIT LLC	2004	year_end	AVI		HOUSE OF REPRESENTATIVES	60000		2005-02-08T00:00:00-05:00
325236	MCCANN CAPITOL ADVOCATES 91643263-3bf0-4b0b-a963-4921df8de2dd	YY	MCCANN CAPITOL ADVOCATES	75898	CITY OF CHICAGO-DEPARTMENT OF AVIATION	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	0		2005-02-09T00:00:00-05:00
325294	ROBERTSON, MONAGLE & EASTAUGH LLC 5e4377de-b234-4aa9-906d-73301cdebb98	YY	ROBERTSON, MONAGLE & EASTAUGH LLC	33454	CONTINENTAL AIRLINES	2004	year_end	AVI	Commercial Aviation	HOUSE OF REPRESENTATIVES,SENATE	63000		2005-02-09T00:00:00-05:00
325693	AMERICAN SOCIETY OF TRAVEL ADVISORS, INC. 63013266-b6a0-405f-a75e-003dca6f693c	YY	AMERICAN SOCIETY OF TRAVEL ADVISORS, INC.	3504	AMERICAN SOCIETY OF TRAVEL ADVISORS INC	2004	year_end	AVI		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE		0	2005-02-09T00:00:00-05:00
325830	SPIEGEL & MCDIARMID LLP 6d7c9bf4-3c86-45ca-848c-06ec42bbdfa9	YY	SPIEGEL & MCDIARMID LLP	36344	MINNEAPOLIS-ST. PAUL METRO AIRPORTS COMMISSION	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	30000		2005-02-10T00:00:00-05:00
326222	BRUCE FENNIE & ASSOCIATES 12c25cae-0dc1-4913-9961-8a9d800ded0a	YY	BRUCE FENNIE & ASSOCIATES	57577	MONROE COUNTY AIRPORT AUTHORITY	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	40000		2005-02-10T00:00:00-05:00
326227	SPIEGEL & MCDIARMID LLP d1058455-c800-4fc7-9f77-92376c7e84e8	YY	SPIEGEL & MCDIARMID LLP	36344	LEHIGH-NORTHHAMPTON AIRPORT AUTHORITY	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	0		2005-02-10T00:00:00-05:00
326245	AVENUE SOLUTIONS 0371c9bb-33f1-4894-be3c-9c70eb6f6897	YY	AVENUE SOLUTIONS	72111	NORTHWEST AIRLINES	2004	year_end	AVI	Aviation: Homeland Security Issues	HOUSE OF REPRESENTATIVES,SENATE	108000		2005-02-10T00:00:00-05:00
326341	BRUCE FENNIE & ASSOCIATES 1ff1073b-1270-4f61-acbe-b85fce1d070e	YY	BRUCE FENNIE & ASSOCIATES	57577	SMITHS DETECTION	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	0		2005-02-10T00:00:00-05:00
326464	WASHINGTON AVIATION GROUP 540edc00-ea0b-4fb4-b95a-e0f581be824f	YY	WASHINGTON AVIATION GROUP	58113	AVIATION SUPPLIERS ASSN	2004	year_end	AVI		HOUSE OF REPRESENTATIVES	0		2005-02-10T00:00:00-05:00
326485	K&L GATES, LLP 46bc4c1a-3b0d-4071-834a-ea8920981120	YY	K&L GATES, LLP	32098	GRAND STRAND BUSINESS ASSN	2004	year_end	AVI	Appropriatons for feasibility study for new airport in Horry County, South Carolina. Public Law 108-447 - Division H, Transportation, Treasury, Independent Agencies, and General Government Appropriations Act.	HOUSE OF REPRESENTATIVES,SENATE	20000		2005-02-10T00:00:00-05:00
326524	NATIONAL AIR TRANSPORTATION ASSOCIATION 680bda44-2281-4b9c-8f38-fabd9731187e	YY	NATIONAL AIR TRANSPORTATION ASSOCIATION	26488	NATIONAL AIR TRANSPORTATION ASSOCIATION	2004	year_end	AVI		Environmental Protection Agency (EPA),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),Transportation Security Administration (TSA)		125000	2005-02-10T00:00:00-05:00
326705	K&L GATES, LLP 967fc833-49a4-424b-ae50-f37f364a41ba	YY	K&L GATES, LLP	32098	JACKSON LABORATORY THE	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	20000		2005-02-10T00:00:00-05:00
326889	RTX CORPORATION AND AFFILIATES c0cb6808-9235-4118-b432-7f38491387c7	YY	RTX CORPORATION AND AFFILIATES	39267	RTX CORPORATION AND AFFILIATES	2004	year_end	AVI	Capetown Aircraft Financing Treaty; War Risk Insurance; Funding and Development of Technologies Homeland Security Appropriation/Authorization; Environmental Standards/Engines	Air Force, Dept of,Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Federal Aviation Administration (FAA),General Services Administration (GSA),Government Accountability Office (GAO),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR)		2340000	2005-02-11T00:00:00-05:00
326975	QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) e7fc88b3-8e76-43a1-b87a-06c4c3eb1afd	YY	QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES)	54197	NATL AIR TRAFFIC CONTROLLERS ASSN	2004	year_end	AVI		Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	160000		2005-02-11T00:00:00-05:00
327147	TRIUMPH GROUP, INC b5ab1bdb-a97e-4a14-94b2-35847940dea1	YY	TRIUMPH GROUP, INC	66272	VOUGHT AIRCRAFT INDUSTRIES INC	2004	year_end	AVI		Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)		300000	2005-02-11T00:00:00-05:00
327159	PUBLIC STRATEGIES WASHINGTON, INC. 84ed408c-af6e-4204-9525-3b64798cdb75	YY	PUBLIC STRATEGIES WASHINGTON, INC.	32486	SOUTHWEST AIRLINES	2004	year_end	AVI	Airline Security Issues	HOUSE OF REPRESENTATIVES,SENATE			2005-02-11T00:00:00-05:00
327189	MADISON GOVERNMENT AFFAIRS 1378f9e2-3ae5-4a67-bcca-457fbdd16ec8	YY	MADISON GOVERNMENT AFFAIRS	23452	NEWPORT NEWS - WILLIAMSBURG INTL AIRPORT	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	20000		2005-02-11T00:00:00-05:00
327275	HALL & ASSOCIATES, LLC 87fcfee6-1ca9-4f59-81a1-5b203364ca12	YY	HALL & ASSOCIATES, LLC	68673	BLUECROSS BLUESHIELD OF TENNESSEE	2004	year_end	AVI		Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Natl Transportation Safety Board (NTSB),SENATE	40000		2005-02-11T00:00:00-05:00
327325	HUSCH BLACKWELL, LLP a8ccba91-bb4c-48de-9f8d-6bf42438d91b	YT	HUSCH BLACKWELL, LLP	6303	WESTWARD AIRWAYS	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	0		2005-02-11T00:00:00-05:00
327472	QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 18a9d674-e8cb-4fe3-9499-a12610be46e8	YY	QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES)	54197	SABRE INC	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	100000		2005-02-11T00:00:00-05:00
327484	TEXTRON INC. 1854bd43-d0ad-4b3d-bbd6-9d9ac7f427ee	YY	TEXTRON INC.	37948	TEXTRON INC	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE		2080000	2005-02-11T00:00:00-05:00
327496	DELTA AIR LINES, INC. fd1a4f55-52e7-4412-bc41-9a82b5acc1d5	YY	DELTA AIR LINES, INC.	11982	DELTA AIR LINES INC	2004	year_end	AVI		Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Postal Service (USPS)		680000	2005-02-11T00:00:00-05:00
327610	GALLAGHER & KENNEDY e44cf855-7640-46d6-bc93-c8233559c539	YY	GALLAGHER & KENNEDY	288178	WILLIAM LYON HOMES	2004	year_end	AVI	Luke Air Force Base land exchange	SENATE	20000		2005-02-11T00:00:00-05:00
327773	DEERE & COMPANY 5d4301c2-f752-46d5-b8d0-e64d1f9f5fff	YY	DEERE & COMPANY	11878	DEERE & COMPANY	2004	year_end	AVI		Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Energy, Dept of,Federal Communications Commission (FCC),Federal Deposit Insurance Corporation (FDIC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Treasury, Dept of,U.S. Forest Service,U.S. Trade Representative (USTR),White House Office		520000	2005-02-11T00:00:00-05:00
327829	LIBERTY SQUARE DC, LLC 33699653-2aaf-4a74-88e7-f48dcd011bd9	YY	LIBERTY SQUARE DC, LLC	87335	AVENUE SOLUTIONS	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	40000		2005-02-11T00:00:00-05:00
327866	THE VELASQUEZ GROUP, L.L.C. ce352b0e-1b88-4995-8f57-fd5a8621ff98	YY	THE VELASQUEZ GROUP, L.L.C.	53403	BBA GROUP PLC	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE	0		2005-02-11T00:00:00-05:00
327870	PROFESSIONAL SERVICES COUNCIL 8e3a844c-aeb2-46c6-aad5-f950c309d913	YY	PROFESSIONAL SERVICES COUNCIL	32282	PROFESSIONAL SERVICES COUNCIL	2004	year_end	AVI		HOUSE OF REPRESENTATIVES,SENATE			2005-02-11T00:00:00-05:00
328640	TRANSPORTATION TRADES DEPARTMENT, AFL-CIO 9a7c3a70-36c5-490a-a1fe-59aad8fb1ebf	YY	TRANSPORTATION TRADES DEPARTMENT, AFL-CIO	38392	TRANSPORTATION TRADES DEPARTMENT AFL-CIO	2004	year_end	AVI		Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Railroad Administration,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Mediation Board,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA)		700000	2005-02-14T00:00:00-05:00
328752	VENABLE LLP 04b1a513-6648-41fe-87d1-7b83b2663e7d	YY	VENABLE LLP	39941	AMERICAN AIRLINES INC	2004	year_end	AVI		Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT)	150000		2005-02-14T00:00:00-05:00
328822	THE RHOADS GROUP 0110c67c-7d40-47da-9deb-97708e8440fb	YY	THE RHOADS GROUP	6644	GALAXY TECHNOLOGY	2004	year_end	AVI			40000		2005-02-14T00:00:00-05:00
328848	VAN SCOYOC ASSOCIATES a2e9d15a-3665-45c5-a4dd-9b0727cc5936	YY	VAN SCOYOC ASSOCIATES	39837	REVEAL IMAGING TECHNOLOGIES INC	2004	year_end	AVI		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	60000		2005-02-14T00:00:00-05:00

Advanced export

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

CREATE TABLE lobbying_activities (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            filing_type TEXT NOT NULL,
            registrant_name TEXT NOT NULL,
            registrant_id INTEGER,
            client_name TEXT NOT NULL,
            filing_year INTEGER NOT NULL,
            filing_period TEXT NOT NULL,
            issue_code TEXT,
            specific_issues TEXT,
            government_entities TEXT,
            income_amount INTEGER,
            expense_amount INTEGER,
            is_no_activity INTEGER DEFAULT 0,
            is_termination INTEGER DEFAULT 0,
            received_date TEXT,
            CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);