lobbying: lobbying_activities: 373 rows where filing_period = "year_end", filing_year = 2003 and issue_code = "HOM" 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

373 rows where filing_period = "year_end", filing_year = 2003 and issue_code = "HOM" 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
224250	AKIN GUMP STRAUSS HAUER & FELD 567c303b-1ddf-4247-8c40-70c3b04860ef	YY	AKIN GUMP STRAUSS HAUER & FELD	682	CHOICEPOINT	2003	year_end	HOM		Access Board,HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA)	160000		2003-02-17T00:00:00-05:00
224303	AKIN GUMP STRAUSS HAUER & FELD 8eb0d7fa-feac-4b3c-8ac4-dc460555f335	YY	AKIN GUMP STRAUSS HAUER & FELD	682	CERNIUM CORPORATION	2003	year_end	HOM		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	60000		2003-02-17T00:00:00-05:00
224304	AKIN GUMP STRAUSS HAUER & FELD 9b66e78d-8047-4755-a610-7d9c82ab19f0	YY	AKIN GUMP STRAUSS HAUER & FELD	682	NCS PEARSON INC	2003	year_end	HOM		Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	160000		2003-02-17T00:00:00-05:00
224541	UNITED WAY OF AMERICA ad4a152d-5cfd-447e-9dc4-ee0358fdb89d	YY	UNITED WAY OF AMERICA	39303	UNITED WAY OF AMERICA	2003	year_end	HOM		Commerce, Dept of (DOC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Faith-Based & Community Initiatives,SENATE,White House Office		0	2003-04-01T00:00:00-05:00
244087	UNIVERSITY OF IOWA 9c997a74-1b43-4ef0-8d2f-a4ea2b9ba20f	YY	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2003	year_end	HOM		Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Centers For Disease Control & Prevention (CDC),Education, Dept of,Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),State, Dept of (DOS)		80000	2003-08-18T00:00:00-04:00
253759	SCHERDER AND ASSOCIATES[FORMERLY THE WILLARD GROUP] d4de0b1e-3f0f-4e42-a74c-65053e6e1aa5	YY	SCHERDER AND ASSOCIATES[FORMERLY THE WILLARD GROUP]	46381	COMPRESSUS	2003	year_end	HOM	Incentives for implementation for large database and information sharing networks	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE			2004-01-06T00:00:00-05:00
253823	JAMES LEE WITT ASSOCIATES 2c6dc8c9-ce73-4672-a241-ae6618e7da28	YY	JAMES LEE WITT ASSOCIATES	73976	HARRIS CORPORATION	2003	year_end	HOM	All matters pertaining to homeland security.	Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),Justice, Dept of (DOJ)	100000		2004-01-07T00:00:00-05:00
253973	SAP AMERICA, INC. 45cae7a2-3535-4048-8ba2-ff34da513007	YY	SAP AMERICA, INC.	60151	SAP AMERICA, INC.	2003	year_end	HOM		Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),SENATE		340000	2004-01-09T00:00:00-05:00
254064	ALVIN JACKSON 931ac025-666c-483e-a06a-37942fb60aa7	YY	ALVIN JACKSON	81293	BOEING COMPANY	2003	year_end	HOM		Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	90000		2004-01-14T00:00:00-05:00
254099	ALVIN JACKSON cc97aab5-2848-4511-a91c-6a3cb2cf1923	YY	ALVIN JACKSON	81293	NORTHROP GRUMMAN CORPORATION	2003	year_end	HOM		Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	50000		2004-01-14T00:00:00-05:00
254163	AGRICULTURAL RETAILERS ASSOCIATION dccfe687-677a-41af-aea3-cfcd185624fe	YY	AGRICULTURAL RETAILERS ASSOCIATION	454	AGRICULTURAL RETAILERS ASSOCIATION	2003	year_end	HOM		Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office		40000	2004-01-14T00:00:00-05:00
254209	VALERO ENERGY CORPORATION 1c32a740-3584-4146-9592-b49e4d08d2c2	YY	VALERO ENERGY CORPORATION	39746	VALERO ENERGY CORPORATION	2003	year_end	HOM		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		180000	2004-01-15T00:00:00-05:00
254461	THOMPSON CONSULTING GROUP cabde5a2-a92c-48fe-af79-a3029debc0db	YY	THOMPSON CONSULTING GROUP	73670	TOPIA VENTURES	2003	year_end	HOM	Work with congressional offices on technology funding related to airport security.	HOUSE OF REPRESENTATIVES,SENATE	60000		2004-01-21T00:00:00-05:00
254521	ROBINS KAPLAN MILLER & CIRESI 43901447-abef-40e1-bdd9-c8df2b5f1510	YY	ROBINS KAPLAN MILLER & CIRESI	33465	PACIFIC MARITIME ASSN	2003	year_end	HOM		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG)	20000		2004-01-22T00:00:00-05:00
254580	CAGNOLI, W. ALLAN 5bd9634f-75d8-4f91-a4de-27d775ed3dfd	YT	CAGNOLI, W. ALLAN	85470	COMPTIA	2003	year_end	HOM	Cyber security, NET Guard, IT training.	Homeland Security, Dept of (DHS),SENATE	13000		2004-01-22T00:00:00-05:00
254638	TRUCK RENTING AND LEASING ASSOCIATION 5ff0bb24-c045-4823-975f-10d9e9d894f6	YY	TRUCK RENTING AND LEASING ASSOCIATION	38552	TRUCK RENTING AND LEASING ASSOCIATION	2003	year_end	HOM		Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,Transportation Security Administration (TSA)		20000	2004-01-23T00:00:00-05:00
254645	ATOKA INTERNATIONAL, LLC 8f117a42-d10d-4693-8d0a-112f66f87837	YY	ATOKA INTERNATIONAL, LLC	87051	WILTEL COMMUNICATIONS	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	0		2004-01-23T00:00:00-05:00
254935	CAPITOL SOLUTIONS 222e967b-8f54-4902-b42b-b3789482e8e2	YY	CAPITOL SOLUTIONS	47108	VERIZON COMMUNICATIONS (FORMERLY VERIZON WIRELESS)	2003	year_end	HOM		Commerce, Dept of (DOC),Congressional Budget Office (CBO),Defense, Dept of (DOD),Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office	120000		2004-01-28T00:00:00-05:00
254937	CAPITOL SOLUTIONS 65f615cb-b171-4a07-8c56-1da3de3d62bd	YY	CAPITOL SOLUTIONS	47108	MOTOROLA	2003	year_end	HOM		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Management & Budget (OMB),SENATE,White House Office	100000		2004-01-28T00:00:00-05:00
254940	THE C. L. A. GROUP, LLC 738d1b63-2568-4692-992b-2a55f3e22aab	YY	THE C. L. A. GROUP, LLC	47622	AMERICAN CONGRESS ON SURVEYING AND MAPPING	2003	year_end	HOM		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	0		2004-01-28T00:00:00-05:00
254981	CAPITOL SOLUTIONS bf356a8e-3bda-4b8b-b48d-e679b716edf2	YY	CAPITOL SOLUTIONS	47108	CTIA- THE WIRELESS ASSOCIATION	2003	year_end	HOM		Commerce, Dept of (DOC),Congressional Budget Office (CBO),Defense, Dept of (DOD),Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office	80000		2004-01-28T00:00:00-05:00
255092	RON KLINK AND ASSOCIATES 57761fd4-7a7d-450a-b3bf-46495a22cfdc	YY	RON KLINK AND ASSOCIATES	70995	SECURITY FIRST CORPORATION	2003	year_end	HOM		Central Intelligence Agency (CIA),Energy, Dept of,General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Security Agency (NSA),Office of Management & Budget (OMB),SENATE	30000		2004-01-29T00:00:00-05:00
255118	NAVY LEAGUE OF THE UNITED STATES b973aed8-4f68-4c87-9eb8-62a6ffded586	YY	NAVY LEAGUE OF THE UNITED STATES	28903	NAVY LEAGUE OF THE UNITED STATES	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE		40000	2004-01-29T00:00:00-05:00
255157	THE JEWISH FEDERATIONS OF NORTH AMERICA 952511c8-fdc6-4d3a-9180-83daae38423d	YY	THE JEWISH FEDERATIONS OF NORTH AMERICA	11105	JEWISH FEDERATIONS OF NORTH AMERICA	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,White House Office		200000	2004-01-29T00:00:00-05:00
255238	AMERICAN AMBULANCE ASSOCIATION 256e59c3-49cd-4755-a9bb-bdf79d1f473c	YY	AMERICAN AMBULANCE ASSOCIATION	56018	AMERICAN AMBULANCE ASSOCIATION	2003	year_end	HOM		Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE		20000	2004-01-29T00:00:00-05:00
255239	VOLVO TECHNOLOGY OF AMERICA 64b58d63-b684-43b8-8569-c2d940777955	YYY	VOLVO TECHNOLOGY OF AMERICA	283856	VOLVO TECHNOLOGY OF AMERICA	2003	year_end	HOM		HOUSE OF REPRESENTATIVES	0		2004-01-29T00:00:00-05:00
255305	EXELIS INC. (FORMERLY ITT CORPORATION) 51d0c8aa-12b4-4100-af1a-35641f601bdb	YY	EXELIS INC. (FORMERLY ITT CORPORATION)	20287	EXELIS INC. (FORMERLY ITT CORPORATION)	2003	year_end	HOM		Commerce, Dept of (DOC),Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Treasury, Dept of,U.S. Coast Guard (USCG)		220000	2004-01-29T00:00:00-05:00
255425	POLICY DEVELOPMENT GROUP 3690f96f-3858-41e8-b248-730191870edf	YY	POLICY DEVELOPMENT GROUP	31736	ADVANCED CERAMICS RESEARCH	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	37500		2004-01-30T00:00:00-05:00
255460	FLIR GOVERNMENT SYSTEMS, INC. eeb2e5ac-b4c9-43d3-867a-9c13dcb95ab7	YY	FLIR GOVERNMENT SYSTEMS, INC.	48838	FLIR GOVERNMENT SYSTEMS, INC	2003	year_end	HOM		Agriculture, Dept of (USDA),Air Force, Dept of,Army, Dept of (Other),Central Intelligence Agency (CIA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Navy, Dept of,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)		240000	2004-01-30T00:00:00-05:00
255537	UNIVERSITY OF ILLINOIS e2efe211-6af5-41be-92db-68cd26203856	YY	UNIVERSITY OF ILLINOIS	39427	UNIVERSITY OF ILLINOIS	2003	year_end	HOM		Agriculture, Dept of (USDA),Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,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,Indian Health Service,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,Technology Administration,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID),U.S. International Development Cooperation Agency,Veterans Affairs, Dept of (VA)		40000	2004-01-30T00:00:00-05:00
255563	JAMES LEE WITT ASSOCIATES 30267085-af73-4bb9-ae53-2950c4e80894	YY	JAMES LEE WITT ASSOCIATES	73976	SPRINT NEXTEL	2003	year_end	HOM	All matters pertaining to interoperability of public safety communications.	Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	180000		2004-01-30T00:00:00-05:00
255773	BKSH & ASSOCIATES 624572b3-2705-4f27-94ae-77284f7ab01a	YY	BKSH & ASSOCIATES	6291	SAP AMERICA INC	2003	year_end	HOM	Department of Homeland Security issues and contract procurement.	Defense, Dept of (DOD),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	40000		2004-02-02T00:00:00-05:00
255862	MR. MARK SHARPE bb525b07-e864-475c-b8ba-e3c16fc36021	YY	MR. MARK SHARPE	83455	ANAZAOHEALTH CORPORATION	2003	year_end	HOM		Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	20000		2004-02-02T00:00:00-05:00
255924	NATIONAL FRATERNAL ORDER OF POLICE 790a0d24-1c77-4094-9e50-c499ad1e6769	YY	NATIONAL FRATERNAL ORDER OF POLICE	27866	NATIONAL FRATERNAL ORDER OF POLICE	2003	year_end	HOM	S. 1245, the "Homeland Security Grant Enhancement Act," which will streamline the current process for homeland security grant programs and increase the flexibility of these grants; S. 1612, the "Homeland Security Technology Improvement Act," which would would authorize $50 million for the Director of the Office for Domestic Preparedness (ODP) to provide advanced counter-terrorism technology, equipment, and information to law enforcement agencies to help them prevent, detect, and apprehend terrorists;	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,Social Security Administration (SSA),Treasury, Dept of,White House Office		200000	2004-02-02T00:00:00-05:00
255936	HECHT LATHAM SPENCER & ASSOCIATES, INC., FORMERLY KNOWN AS HECHT SPENCER & ASSOC eb98041d-2e7a-4c24-80ea-05695faad4e9	YY	HECHT LATHAM SPENCER & ASSOCIATES, INC., FORMERLY KNOWN AS HECHT SPENCER & ASSOC	17966	3M COMPANY	2003	year_end	HOM		Commerce, Dept of (DOC),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-02T00:00:00-05:00
256042	REPUBLICAN JEWISH COALITION 0bac0577-1e23-4f89-ad05-e9414572a6e4	YY	REPUBLICAN JEWISH COALITION	28093	REPUBLICAN JEWISH COALITION	2003	year_end	HOM	H.R. 2555, Homeland Security Appropriations 2004	HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)		40000	2004-02-03T00:00:00-05:00
256128	HUMAN RIGHTS WATCH 3af171b0-84d7-4976-97d5-a8ac51a6f1b3	YA	HUMAN RIGHTS WATCH	82317	HUMAN RIGHTS WATCH	2003	year_end	HOM	· USA PATRIOT Act (oversight mechanisms) · Bill on civil liberties post 9-11 · H.R. 1029, Detention of Enemy Combatants Act · H.R. 2671, Clear law Enforcement for Criminal Alien Removal Act of 2003 · Detention of enemy combatants apprehended inside the U.S. · Detention and treatment of aliens suspected of terrorism · Establishment of Civil Rights Oversight Mechanism in the new Department of Homeland Security · Guantanamo detainees (child detainees) · Military Commissions: Urged change in rules and structure	Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Security Council (NSC),Office of the Vice President of the United States,SENATE,State, Dept of (DOS)		80000	2004-02-04T00:00:00-05:00
256142	ELECTRONIC DATA SYSTEMS CORPORATION (EDS) 71c1968f-73cf-46a0-be10-27baf578fdaa	YA	ELECTRONIC DATA SYSTEMS CORPORATION (EDS)	13357	ELECTRONIC DATA SYSTEMS CORPORATION (EDS)	2003	year_end	HOM	H.R. 2555: Department of Homeland Security Appropriations Bill for FY 2004. Focus on domestic preparedness, all matters pertaining to information technology funding for US VISIT, SEVIS H.Rept 108-169, S. Rept 108-86 Implementation of regulations related to "Safety Act" Proposed Rule, 68 F.R. 41420, July 11, 2003 Cyber Security S. 187, National Cyber Security Leadership Act of 2003.	Centers For Medicare and Medicaid Services (CMS),Federal Reserve System,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Intl Trade Administration (ITA),Office of Management & Budget (OMB),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),White House Office		1556249	2004-02-04T00:00:00-05:00
256182	HUMAN RIGHTS WATCH a537d9b1-ff4e-48a9-98b5-0a27a8b6155e	YA	HUMAN RIGHTS WATCH	82317	HUMAN RIGHTS WATCH	2003	year_end	HOM	· USA PATRIOT Act (oversight mechanisms) · Bill on civil liberties post 9-11 · H.R. 1029, Detention of Enemy Combatants Act · H.R. 2671, Clear law Enforcement for Criminal Alien Removal Act of 2003 · Detention of enemy combatants apprehended inside the U.S. · Detention and treatment of aliens suspected of terrorism · Establishment of Civil Rights Oversight Mechanism in the new Department of Homeland Security · Guantanamo detainees (child detainees) · Military Commissions: Urged change in rules and structure	Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Security Council (NSC),Office of the Vice President of the United States,SENATE,State, Dept of (DOS)		80000	2004-02-04T00:00:00-05:00
256315	ASSOCIATION OF OLD CROWS ac6cb735-425f-43a7-93bd-39e4dd2ebb4e	YY	ASSOCIATION OF OLD CROWS	84957	ASSOCIATION OF OLD CROWS	2003	year_end	HOM	S. 311/H.R. 580 Lobbied in supoprt of measures	Defense, Dept of (DOD),Government Accountability Office (GAO),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)		60000	2004-02-06T00:00:00-05:00
256412	BKSH & ASSOCIATES 2a416c1d-a7a3-44d5-9407-d360d1a66ee5	YY	BKSH & ASSOCIATES	6291	JP MORGAN	2003	year_end	HOM	Monitoring of homeland security initiatives	HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-06T00:00:00-05:00
256464	STRATEGIC MARKETING INNOVATIONS 4bccf55d-55ff-45f3-9ea7-0623488d3232	YY	STRATEGIC MARKETING INNOVATIONS	60550	DEVAULT AND ASSOCIATES	2003	year_end	HOM	HR 2555 Homeland Security Transportation Appropriations. Funding for armament for Coast Guard Deepwater Program.	HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE	20000		2004-02-09T00:00:00-05:00
256518	SIGNAL GROUP CONSULTING, LLC d9977382-eb22-4152-a461-34f788f5907b	YY	SIGNAL GROUP CONSULTING, LLC	73271	ITA INDUSTRIAL A DIVISON OF ITA INC	2003	year_end	HOM	FY04 Defense Authorization and Approps	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	54000		2004-02-09T00:00:00-05:00
256562	S&P GLOBAL INC. (F/K/A MCGRAW HILL FINANCIAL INC.) e605176a-ee11-4c6d-85b6-759c661b157e	YY	S&P GLOBAL INC. (F/K/A MCGRAW HILL FINANCIAL INC.)	24442	S&P GLOBAL INC. (F/K/A MCGRAW HILL FINANCIAL INC.)	2003	year_end	HOM		Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Postal Service (USPS),U.S. Trade Representative (USTR)		280000	2004-02-09T00:00:00-05:00
256654	STRATEGIC MARKETING INNOVATIONS e2b6d5fa-2ca4-4e0b-92f6-d267fb3d1923	YY	STRATEGIC MARKETING INNOVATIONS	60550	GULF OF MAINE OCEAN OBSERVING SYSTEM	2003	year_end	HOM	HR 2555 House & Senate Department of Homeland Security Appropriations. Funding for Coastal Radar for DHS bill in House & Senate.	HOUSE OF REPRESENTATIVES,Natl Oceanic & Atmospheric Administration (NOAA),SENATE,White House Office			2004-02-09T00:00:00-05:00
256674	SIGNAL GROUP CONSULTING, LLC bab03f13-4891-4230-a7b8-f03e43a9d1e8	YY	SIGNAL GROUP CONSULTING, LLC	73271	NORTHROP GRUMMAN CORP	2003	year_end	HOM	Homeland Security Authorization	HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-09T00:00:00-05:00
256681	U.S. ENGLISH, INC. 21c7d9d0-148c-481b-a1ad-e4c2cc6ecdfe	YY	U.S. ENGLISH, INC.	38791	U.S. ENGLISH, INC.	2003	year_end	HOM		Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE		610000	2004-02-09T00:00:00-05:00
256686	SIGNAL GROUP CONSULTING, LLC 8b7a98cd-5157-4ff1-bbe8-f9c451fa1c20	YY	SIGNAL GROUP CONSULTING, LLC	73271	ASCENTRY	2003	year_end	HOM	Homeland Security Authorization	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	57727		2004-02-09T00:00:00-05:00
256782	NORTHWEST AIRLINES, INC. (ACQUIRED BY DELTA AIR LINES, INC.) a5738f21-ec29-45d9-b0b5-dbde5759841d	YY	NORTHWEST AIRLINES, INC. (ACQUIRED BY DELTA AIR LINES, INC.)	29573	NORTHWEST AIRLINES INC (ACQUIRED BY DELTA AIR LINES INC )	2003	year_end	HOM	H 1467 To amend title 49, United States Code, to impose a 2-year moratorium on the imposition of passenger and air carrier security fees, to reimburse the airline industry for homeland security. H 580 Commercial Airline Missile Defense Act H 1049 Arming Cargo Pilots Against Terrorism Act ---------------------------------------------------- S 728 To reimburse the airline industry for homeland security costs, and for other purposes S 311 Commercial Airlines Missile Defense Act S 516 Arming Cargo Pilots Against Terrorism Act S 208 To require the Secretary of Homeland Security to develop and implement a plan to provide security for cargo entering the United States or being transported in intrastate or interstate S 6 Comprehensive Homeland Security Act of 2003	Agriculture, Dept of (USDA),Air Force, Dept of,Army, Dept of (Other),Commerce, Dept of (DOC),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Aviation Administration (FAA),Federal Bureau of Investigation (FBI),Federal Deposit Insurance Corporation (FDIC),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Agency (NSA),Navy, Dept of,Office of Management & Budget (OMB),Peace Corps,Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Information Agency (USIA),U.S. Postal Service (USPS),U.S. Secret Service,White House Office		1270000	2004-02-09T00:00:00-05:00
256897	SIGNAL GROUP CONSULTING, LLC 2ba48751-29b2-426a-93a6-0268dd1614b6	YY	SIGNAL GROUP CONSULTING, LLC	73271	SAVI TECHNOLOGY	2003	year_end	HOM	Maritime Port Security	Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	129000		2004-02-10T00:00:00-05:00
256952	SIGNAL GROUP CONSULTING, LLC a109ba3c-36da-4f4d-ae11-37a0019eef40	YY	SIGNAL GROUP CONSULTING, LLC	73271	SAGEM MORPHO	2003	year_end	HOM	Homeland Security authorization	Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE	50000		2004-02-10T00:00:00-05:00
256972	SIGNAL GROUP CONSULTING, LLC 3854b3ce-441e-4b77-9be4-4fe639cc2f10	YY	SIGNAL GROUP CONSULTING, LLC	73271	REALNETWORKS	2003	year_end	HOM	Homeland Security Authorization	Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	90000		2004-02-10T00:00:00-05:00
256989	RICCHETTI INCORPORATED 34daf422-e26c-415d-885d-515f3a577f79	YY	RICCHETTI INCORPORATED	62778	SIEMENS CORPORATION	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	90000		2004-02-10T00:00:00-05:00
257040	PETRIZZO GROUP 5f0bd856-f893-4f8b-8345-836ba71dc2a4	YY	PETRIZZO GROUP	53141	INTERCON SECURITY SYSTEMS INC	2003	year_end	HOM		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-10T00:00:00-05:00
257095	BKSH & ASSOCIATES 3fb54b69-8f42-49c9-8c2c-bf7eb2f11183	YY	BKSH & ASSOCIATES	6291	GEOVOX SECURITY INC	2003	year_end	HOM	No specific issues.	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	10000		2004-02-10T00:00:00-05:00
257303	PETRIZZO GROUP e9be0e0d-d974-4476-b12b-ef439aae092c	YY	PETRIZZO GROUP	53141	COCO COMMUNICATIONS	2003	year_end	HOM		Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-10T00:00:00-05:00
257434	BKSH & ASSOCIATES 40953b6b-333a-4768-a718-225ec8c900f0	YY	BKSH & ASSOCIATES	6291	FEATHERLITE INC	2003	year_end	HOM	No specific bills.	Energy, Dept of,Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	40000		2004-02-11T00:00:00-05:00
257645	CLARK & WEINSTOCK a6f11804-b333-43f3-aa75-86c85517891d	YY	CLARK & WEINSTOCK	9443	WALKER DIGITAL MANAGEMENT LLC	2003	year_end	HOM		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	20000		2004-02-11T00:00:00-05:00
257750	TITAN CORP a6cbab8e-9484-4b6b-9302-b014817c3650	YY	TITAN CORP	58374	TITAN CORP	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	0		2004-02-11T00:00:00-05:00
257781	CONAWAY GROUP LLC f426f51e-894c-48ad-a0b8-b5e4a7029186	YT	CONAWAY GROUP LLC	10398	ILOR LLC	2003	year_end	HOM		Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE	0		2004-02-11T00:00:00-05:00
257834	AMITAY CONSULTING 0d00ccad-92cc-4323-8244-d5a5c5c37311	YY	AMITAY CONSULTING	83796	MORRIS J AMITAY P C (ON BEHALF OF AMETEK)	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE,U.S. Coast Guard (USCG),U.S. Customs & Border Protection	0		2004-02-11T00:00:00-05:00
257938	FLEET RESERVE ASSOCIATION e7d0a7f8-ebc1-4b3c-8805-9f54fc648ad0	YA	FLEET RESERVE ASSOCIATION	14781	FLEET RESERVE ASSOCIATION	2003	year_end	HOM	HR 2443 To authorize appropriations for the Coast Guard for fiscal year 2004, to amend various laws administered by the Coast Guard, and for other purposes.	Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE,U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office		79500	2004-02-11T00:00:00-05:00
257948	FLEET RESERVE ASSOCIATION eab53f71-a2a5-4248-a8a3-6790d636e0c4	YA	FLEET RESERVE ASSOCIATION	14781	FLEET RESERVE ASSOCIATION	2003	year_end	HOM	HR 2443 To authorize appropriations for the Coast Guard for fiscal year 2004, to amend various laws administered by the Coast Guard, and for other purposes. HR 3374 To amend title 14, United States Code, to authorize the Commandant of the Coast Guard, after informing the Secretary of the department in which the Coast Guard is operating, to make such recommendations to the Congress relating to the Coast Guard as the Commandant considers appropriate.	Defense Commissary Agency,Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Navy, Dept of,President of the U.S.,SENATE,U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office		79500	2004-02-11T00:00:00-05:00
258079	3M COMPANY 61947d76-7a08-4816-ad23-71e97bc2485a	YY	3M COMPANY	25465	3M COMPANY	2003	year_end	HOM		Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Architectural & Transportation Barriers Compliance Board (ACCESS),U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA)		992000	2004-02-11T00:00:00-05:00
258237	BKSH & ASSOCIATES 89dff7a0-8226-4309-9478-b8ac8ca20f04	YY	BKSH & ASSOCIATES	6291	NATL ASSN OF ROCKETRY	2003	year_end	HOM	S. 724, to amend Title 18, United States Code, to exempt certain rocket propellants from prohibitions under that title on explosive materials.	SENATE	10000		2004-02-12T00:00:00-05:00
258370	IT POLICY SOLUTIONS b9bb9dfa-b25d-4851-a506-37fb532b7bfa	YY	IT POLICY SOLUTIONS	283470	OBERTHUR CARD SYSTEMS	2003	year_end	HOM	Homeland Security appropriations Transportation security US VISIT ePassport	Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	40000		2004-02-12T00:00:00-05:00
258378	P3 CONSULTING LLC 19cc884f-5a83-4bd7-994a-3ce3dbaf97a9	YY	P3 CONSULTING LLC	87530	DRS	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	40000		2004-02-12T00:00:00-05:00
258423	FLEISCHMAN AND HARDING LLP 784a5cfa-a6bf-49a2-86cd-4ff33ebbda09	YT	FLEISCHMAN AND HARDING LLP	14792	NORTHRUP GRUMMAN MISSION SYSTEMS	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	0		2004-02-12T00:00:00-05:00
258462	IT POLICY SOLUTIONS 688f8696-80a9-4d86-996e-681ac36485c1	YY	IT POLICY SOLUTIONS	283470	SCHLUMBERGER	2003	year_end	HOM	Homeland Security appropriations Transportation security US VISIT ePassport	Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	40000		2004-02-12T00:00:00-05:00
258495	THE ROTH GROUP 84215e10-f264-4103-84de-762daacae494	YT	THE ROTH GROUP	33795	NAPCO SECURITY GROUP	2003	year_end	HOM		Energy, Dept of,General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	0		2004-02-12T00:00:00-05:00
258502	IT POLICY SOLUTIONS bdddceba-7ad7-4ab2-a9e6-7ba4c814997c	YY	IT POLICY SOLUTIONS	283470	GEMPLUS	2003	year_end	HOM	Homeland Security appropriations Transportation security US VISIT ePassport	Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	40000		2004-02-12T00:00:00-05:00
258512	NORTHROP GRUMMAN CORPORATION b53ff278-1dae-4f95-ba6e-73240e67a4e6	YY	NORTHROP GRUMMAN CORPORATION	29551	NORTHROP GRUMMAN CORPORATION	2003	year_end	HOM		Defense, Dept of (DOD),Export-Import Bank of the United States (EXIM Bank),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Maritime Administration (MARAD),Natl Aeronautics & Space Administration (NASA),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office		3860000	2004-02-12T00:00:00-05:00
258548	SIGNAL GROUP CONSULTING, LLC 33dd98aa-103a-4cf4-a6cc-97c748d0b2be	YY	SIGNAL GROUP CONSULTING, LLC	73271	MICROVISION	2003	year_end	HOM	FY04 Homeland Security Appropriations; House Select Committee on Homeland Security	Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE	90000		2004-02-12T00:00:00-05:00
258592	IT POLICY SOLUTIONS ea911991-6862-4580-baac-b5d444fa16f3	YY	IT POLICY SOLUTIONS	283470	REGIONAL ALLIANCES FOR INFRASTRUCTURE AND NETWORK SECURITY	2003	year_end	HOM	Department of Homeland Security appropriations Information sharing Cyber security Network communications	Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office	0		2004-02-12T00:00:00-05:00
258602	GEORGETOWN UNIVERSITY e470ffe5-620b-4876-9500-b4cb28ecf48a	YY	GEORGETOWN UNIVERSITY	62016	GEORGETOWN UNIVERSITY	2003	year_end	HOM		Commerce, Dept of (DOC),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Park Service (NPS),SENATE,U.S. Agency for International Development (USAID)		100000	2004-02-12T00:00:00-05:00
258630	SUNDQUIST GROUP (FORMERLY KNOWN AS SUNDQUIST ANTHONY) cf857208-0308-48b7-8dc9-bfb43b08bf90	YY	SUNDQUIST GROUP (FORMERLY KNOWN AS SUNDQUIST ANTHONY)	87574	AIRCELL INC	2003	year_end	HOM	Provide air-ground communicatons systems.	HOUSE OF REPRESENTATIVES,SENATE	75000		2004-02-12T00:00:00-05:00
258661	FLEISCHMAN AND HARDING LLP 40225651-7439-48b2-b421-cf8677ec2083	YY	FLEISCHMAN AND HARDING LLP	14792	PEPCO HOLDINGS	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-12T00:00:00-05:00
258675	DONNA MCLEAN ASSOCIATES, LLC 3040b028-1983-4c27-a63e-bfc035baca11	YY	DONNA MCLEAN ASSOCIATES, LLC	283617	NATL BUSINESS AVIATION ASSN	2003	year_end	HOM	Aviation and homeland security issues.	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	2500		2004-02-12T00:00:00-05:00
258764	MOTION PICTURE ASSOCIATION, INC. 1609e346-24a3-4e14-8f02-fc0930a4a9c3	YY	MOTION PICTURE ASSOCIATION, INC.	26001	MOTION PICTURE ASSOCIATION INC	2003	year_end	HOM		Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)		580000	2004-02-12T00:00:00-05:00
258889	ACCENTURE, LLP eb33ea54-4498-4b63-bbb5-6f1e6075672e	YY	ACCENTURE, LLP	3960	ACCENTURE LLP	2003	year_end	HOM		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Treasury, Dept of		1020000	2004-02-12T00:00:00-05:00
258944	IT POLICY SOLUTIONS c9675f35-2713-4662-9e1d-e3c5b65700a5	YY	IT POLICY SOLUTIONS	283470	DIGIMARC	2003	year_end	HOM	Government ID systems Transportation appropriations	HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT)	40000		2004-02-12T00:00:00-05:00
258952	SIGNAL GROUP CONSULTING, LLC bbec0e77-02ff-4d7f-8830-8009c1b4dc48	YY	SIGNAL GROUP CONSULTING, LLC	73271	TERABEAM	2003	year_end	HOM	FY04 Homeland Security Appropriations; House Select Committee on Homeland Security; National Back-up Dial Tone Network	Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-12T00:00:00-05:00
258993	IT POLICY SOLUTIONS 3d392220-2a1e-4db1-86a1-3303d3f273a9	YY	IT POLICY SOLUTIONS	283470	SWAN ISLAND NETWORKS	2003	year_end	HOM	Homeland Security appropriations Information sharing First responder	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office	12000		2004-02-12T00:00:00-05:00
259110	BKSH & ASSOCIATES 70b90fd2-4fa6-419e-ad7d-b8bffaaea8c9	YY	BKSH & ASSOCIATES	6291	TRIPOLI ROCKETRY ASSN	2003	year_end	HOM	S. 724, to amend Title 18, United State Code, to exempt certain rocket propellants from prohibitions under that title on explosive materials.	SENATE	10000		2004-02-12T00:00:00-05:00
259202	AMERICAN CHEMICAL SOCIETY (ACS) d0668bb1-216e-4ff3-8876-d63a859dbd1e	YY	AMERICAN CHEMICAL SOCIETY (ACS)	1887	AMERICAN CHEMICAL SOCIETY (ACS)	2003	year_end	HOM		Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,State, Dept of (DOS)		120000	2004-02-13T00:00:00-05:00
259256	DENTONS US LLP ea2c8b0d-bc9a-4180-aebc-0974e94d9666	YY	DENTONS US LLP	36105	SMS HOLDINGS CORPORATION	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	20000		2004-02-13T00:00:00-05:00
259358	TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA 1aa8df2f-4010-424c-a8e4-70dca3f2fe4f	YY	TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA	38608	TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE		60000	2004-02-13T00:00:00-05:00
259369	UNITED AIRLINES, INC cced85f5-0edf-4c2c-a7f5-79f3de4016bb	YY	UNITED AIRLINES, INC	39030	UNITED AIRLINES INC	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE		974000	2004-02-13T00:00:00-05:00
259403	UNIVERSITY OF WASHINGTON 9f4fed67-51a2-4a22-9f6d-871bd7dbeb20	YY	UNIVERSITY OF WASHINGTON	39553	UNIVERSITY OF WASHINGTON	2003	year_end	HOM		Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA)		100000	2004-02-13T00:00:00-05:00
259507	NATIONAL AIR TRANSPORTATION ASSOCIATION 7cf2ba50-8f5d-44cf-9ec1-9b057e0c6c13	YY	NATIONAL AIR TRANSPORTATION ASSOCIATION	26488	NATIONAL AIR TRANSPORTATION ASSOCIATION	2003	year_end	HOM		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)		100000	2004-02-13T00:00:00-05:00
259540	DLA PIPER LLP (US) 989760bb-b551-4788-87b2-a305ef0e7a2c	YY	DLA PIPER LLP (US)	76855	ATMEL CORP	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	100000		2004-02-13T00:00:00-05:00
259590	DLA PIPER LLP (US) df826295-e5fb-488d-b4ba-a76ec23876bc	YY	DLA PIPER LLP (US)	76855	BELLSOUTH	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	40000		2004-02-13T00:00:00-05:00
259603	FOLEY & LARDNER LLP 92fe1627-b444-4d50-954b-a8b58576d057	YY	FOLEY & LARDNER LLP	15042	VISTEON CORPORATION	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	80000		2004-02-13T00:00:00-05:00
259614	SUNDQUIST GROUP (FORMERLY KNOWN AS SUNDQUIST ANTHONY) 61425d3f-af0f-496a-8dbb-ab28d6b3efe6	YY	SUNDQUIST GROUP (FORMERLY KNOWN AS SUNDQUIST ANTHONY)	87574	IRIDIUM SATELLITE LLC	2003	year_end	HOM	Satellite communications.	HOUSE OF REPRESENTATIVES,SENATE	150000		2004-02-13T00:00:00-05:00
259654	MCCANN CAPITOL ADVOCATES 4dc09b59-ef7b-4bff-a8a9-aea3eb7e35c4	YY	MCCANN CAPITOL ADVOCATES	75898	SITA	2003	year_end	HOM			20000		2004-02-13T00:00:00-05:00
259673	VALENTE & ASSOCIATES 0fb3a913-89f0-469f-9350-b2dcc444968e	YY	VALENTE & ASSOCIATES	45983	NATL TREASURY EMPLOYEES UNION	2003	year_end	HOM		Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-13T00:00:00-05:00
259714	CORNERSTONE GOVERNMENT AFFAIRS, INC. 3b26e9d0-3b19-4f60-b7fd-b5a1498edbfd	YY	CORNERSTONE GOVERNMENT AFFAIRS, INC.	75557	BAVARIAN NORDIC A/S	2003	year_end	HOM	Bioterrorism programs - smallpox research and stockpiling	Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE	120000		2004-02-13T00:00:00-05:00
259876	DYKEMA GOSSETT PLLC 8476e64f-74f5-41eb-96e8-cc5c7f615d25	YY	DYKEMA GOSSETT PLLC	12915	DETROIT & CANADA TUNNEL CORP	2003	year_end	HOM		HOUSE OF REPRESENTATIVES,SENATE	0		2004-02-13T00:00:00-05:00
260127	BKSH & ASSOCIATES 312a1a43-dbd8-4748-bee4-e6ef2e6c8fa2	YY	BKSH & ASSOCIATES	6291	NEC USA INC	2003	year_end	HOM	Anti-terrorism legislation and appropriations for homeland security.	Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE	60000		2004-02-13T00:00:00-05:00
260144	DICKSTEIN SHAPIRO LLP 4e54e4b0-1075-4626-b99d-e94d79a23064	YY	DICKSTEIN SHAPIRO LLP	12208	EXOXEMIS	2003	year_end	HOM	Issues Specific to Homeland Security with regard to DOD and DHS.	Defense, Dept of (DOD),Homeland Security, Dept of (DHS)	70000		2004-02-13T00: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);