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

244 rows where filing_period = "year_end", filing_year = 2001 and issue_code = "IMM" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filing_type, specific_issues, income_amount, received_date (date)

issue_code 1

  • IMM · 244 ✖

filing_year 1

  • 2001 · 244 ✖

filing_period 1

  • year_end · 244 ✖
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
102767 NUMBERSUSA.COM 9904e1b6-17a2-4c7f-a328-9e523731b44c YY NUMBERSUSA.COM 68070 NUMBERSUSACOM 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE     0 0 2001-02-13T00:00:00-05:00
103052 NEW YORK UNIVERSITY f026aa64-5623-4727-bc66-05e2dc5e34b0 YY NEW YORK UNIVERSITY 29232 NEW YORK UNIVERSITY 2001 year_end IMM   Agriculture, Dept of (USDA),Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE   260000 0 0 2001-03-02T00:00:00-05:00
103103 UNIVERSITY OF MIAMI 4ebf083f-29b0-4065-b454-9f60aa5c3713 YY UNIVERSITY OF MIAMI 39462 UNIVERSITY OF MIAMI 2001 year_end IMM   Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Agency for International Development (USAID),U.S. Information Agency (USIA)   363381 0 0 2001-03-12T00:00:00-05:00
103131 FAEGRE BAKER DANIELS CONSULTING 9d8e901c-e971-4f52-9a25-b08922ab72eb YY FAEGRE BAKER DANIELS CONSULTING 34158 INDIANA SPORTS CORP 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Customs & Border Protection 20000   0 0 2001-03-12T00:00:00-05:00
126465 AMERICANS FOR TAX REFORM 47cc40df-56a0-4723-b1d0-f6c833119457 YY AMERICANS FOR TAX REFORM 3801 AMERICANS FOR TAX REFORM 2001 year_end IMM HR 1330 Agriculture, Dept of (USDA),Bureau of Economic Analysis,Commerce, Dept of (DOC),Council of Economic Advisers (CEA),Economic Development Administration,HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Natl Economic Council (NEC),President of the U.S.,SENATE,Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR),Vice President of the U.S.,White House Office   400000 0 0 2001-12-26T00:00:00-05:00
126591 NORTEL f83f72df-d489-4d09-b98d-5c8327f8cc08 YY NORTEL 29540 NORTEL 2001 year_end IMM H1-B Visas Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)     0 0 2002-01-10T00:00:00-05:00
126754 NATIONAL MILK PRODUCERS FEDERATION 6cf8425a-d373-4321-b66d-99fef1753ec4 YY NATIONAL MILK PRODUCERS FEDERATION 28207 NATIONAL MILK PRODUCERS FEDERATION 2001 year_end IMM   Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE   180000 0 0 2002-01-17T00:00:00-05:00
127288 HP INC. 26c3749b-5b6b-4e87-9fc4-19f9464d9ea5 YY HP INC. 18158 HP INC 2001 year_end IMM   Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,White House Office   200000 0 0 2002-01-29T00:00:00-05:00
127295 PARRY, ROMANI, DECONCINI & SYMMS b5bae970-3629-4c4c-944a-e40400af96c5 YT PARRY, ROMANI, DECONCINI & SYMMS 30792 HEMENWAY ASSOC 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2002-01-29T00:00:00-05:00
127447 THE C. L. A. GROUP, LLC eade7a3f-fc30-41be-a1ec-7b6a2043f983 YY THE C. L. A. GROUP, LLC 47622 UNITED COLUMBIAN AMERICAN ASSOC 2001 year_end IMM   HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE 0   0 0 2002-01-31T00:00:00-05:00
127456 THE C. L. A. GROUP, LLC 6d9ec826-27b6-44fa-b1cc-2ad7043d2520 YY THE C. L. A. GROUP, LLC 47622 COLOMBIAN AMERICAN SERVICE ASSN 2001 year_end IMM   HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE 0   0 0 2002-01-31T00:00:00-05:00
127626 BKSH & ASSOCIATES 236e596f-98f5-4aac-af2a-299d46e86684 YY BKSH & ASSOCIATES 6291 ACCENTURE 2001 year_end IMM H.R. 2277, Work Authorization/Treaty traders' and investors' spouses; H.R. 2278, L Visas. Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-02-04T00:00:00-05:00
127814 BKSH & ASSOCIATES 2be25ae7-fc57-4430-8f93-ed4f0e3d84c5 YY BKSH & ASSOCIATES 6291 COCA-COLA COMPANY 2001 year_end IMM H-1B visa issue. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-02-05T00:00:00-05:00
127938 AMERICAN COUNCIL ON EDUCATION 1446dc7c-bd1a-4575-aaac-d46125b4e586 YY AMERICAN COUNCIL ON EDUCATION 2148 AMERICAN COUNCIL ON EDUCATION 2001 year_end IMM 1. Student and Exchange Visitor Information System (SEVIS) 2. Recommendations Affecting Student Visas in H.R. 2975 – Patriot Act of 2001 3. Foreign Terrorist Tracking Task Force Bureau of Citizenship & Immigration Services (BCIS),Executive Office of the President (EOP),Federal Trade Commission (FTC),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of   80000 0 0 2002-02-06T00:00:00-05:00
128117 PEARSON & PIPKIN, INC 6ba58ce8-47d1-4aa8-a356-5fb8b0d20ead YY PEARSON & PIPKIN, INC 30996 US BORDER CONTROL 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-02-07T00:00:00-05:00
128140 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 56e75e42-9c4e-4224-a0cb-fe8526198bea YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2001 year_end IMM Eligibility of legal immigrant children for Medicaid and CHIP- S. 582, H.R. 1143 Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   220000 0 0 2002-02-07T00:00:00-05:00
128211 SYRACUSE UNIVERSITY 20f723a7-af8e-4279-b357-4fce35e28ef6 YY SYRACUSE UNIVERSITY 37540 SYRACUSE UNIVERSITY 2001 year_end IMM   Education, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),SENATE   30000 0 0 2002-02-07T00:00:00-05:00
128225 GREENKORN, ROBERT A. 98b08ae2-1484-44be-95c4-56119d3d93a7 YY GREENKORN, ROBERT A. 55611 PURDUE UNIV 2001 year_end IMM   SENATE 0   0 0 2002-02-07T00:00:00-05:00
128248 MR. KHALIL SALIBA 5ef062db-4a2c-4aef-9715-dbdf22997323 YY MR. KHALIL SALIBA 57533 BURGER KING CORPORATION 2001 year_end IMM   Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office 80000   0 0 2002-02-07T00:00:00-05:00
128669 AMERICAN PHYSICAL THERAPY ASSOCIATION eed2d28d-90a3-4571-b884-07fdc5afcae3 YY AMERICAN PHYSICAL THERAPY ASSOCIATION 3093 AMERICAN PHYSICAL THERAPY ASSOCIATION 2001 year_end IMM Immigration Reform Centers For Medicare and Medicaid Services (CMS),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,Veterans Affairs, Dept of (VA)   336077 0 0 2002-02-08T00:00:00-05:00
128906 JOHNS HOPKINS UNIVERSITY c92efc74-9735-4d57-ac28-b32b9fc9bc92 YY JOHNS HOPKINS UNIVERSITY 20664 JOHNS HOPKINS UNIVERSITY 2001 year_end IMM HR 2779,The International Students Reporting Act of 2001: Monitored and urged cosponsorship of the bill which would repeal Section 641 of the Illegal Immigration Reform and Immigrant Responsibility Act of 2001 which, if implemented, would have an adverse effect on international programs at Hopkins; S.1627, Visa Entry Reform Act of 2001: advocated against and opposed bill which would have put a six-month moratorium/freeze on student visas; S.1749/HR 3525, Enhanced Border Security and Visa Entry Reform Act of 2002: advocated concerns with respect to impact on international students and record keeping. Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE   40000 0 0 2002-02-11T00:00:00-05:00
129090 HOGAN LOVELLS US LLP 1d37140f-a4fc-4529-976d-c7e7b85b1d93 YY HOGAN LOVELLS US LLP 18422 NESTLE USA INC 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-02-11T00:00:00-05:00
129134 JOHNS HOPKINS UNIVERSITY b58791b6-59a5-40ad-a266-14e3e639b7cc YY JOHNS HOPKINS UNIVERSITY 20664 JOHNS HOPKINS UNIVERSITY 2001 year_end IMM HR 2779,The International Students Reporting Act of 2001: Monitored and urged cosponsorship of the bill which would repeal Section 641 of the Illegal Immigration Reform and Immigrant Responsibility Act of 2001 which, if implemented, would have an adverse effect on international programs at Hopkins; S.1627, Visa Entry Reform Act of 2001: advocated against and opposed bill which would have put a six-month moratorium/freeze on student visas; S.1749/HR 3525, Enhanced Border Security and Visa Entry Reform Act of 2002: advocated concerns with respect to impact on international students and record keeping. Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE   40000 0 0 2002-02-11T00:00:00-05:00
129290 TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA ae6156a2-4b80-49a1-abc5-5f59c5c3c8d1 YY TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA 38608 TRUSTEES OF THE UNIVERSITY OF PENNSYLVANIA 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE   140000 0 0 2002-02-12T00:00:00-05:00
129304 UNIVERSITY OF WASHINGTON 6139330e-3c34-42b8-a6b4-b16e2f9fa39b YY UNIVERSITY OF WASHINGTON 39553 UNIVERSITY OF WASHINGTON 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),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),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   80000 0 0 2002-02-12T00:00:00-05:00
129426 GEORGETOWN UNIVERSITY 2c872fa6-e91b-4415-bbee-2e7cca3e83d0 YY GEORGETOWN UNIVERSITY 62016 GEORGETOWN UNIVERSITY 2001 year_end IMM   Agriculture, Dept of (USDA),Army, Dept of (Other),Defense, Dept of (DOD),Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Agency for International Development (USAID)   100000 0 0 2002-02-12T00:00:00-05:00
129522 HOGAN LOVELLS US LLP 94127efc-618c-4f9b-b7ce-c5cebc8d0542 YY HOGAN LOVELLS US LLP 18422 AIS INC 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-02-12T00:00:00-05:00
129600 GENERAL MOTORS CORPORATION a62eea72-384f-49b9-9179-aa9ab909ff89 YY GENERAL MOTORS CORPORATION 16021 GENERAL MOTORS CORPORATION 2001 year_end IMM Spousal Equity Act Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Council of Economic Advisers (CEA),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Federal Highway Administration (FHA),Federal Maritime Commission,Federal Railroad Administration,Federal Reserve System,HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Economic Council (NEC),Natl Highway Traffic Safety Administration (NHTSA),Natl Science Foundation (NSF),Natl Transportation Safety Board (NTSB),Occupational Safety & Health Administration (OSHA),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),Office of the Vice President of the United States,SENATE,State, Dept of (DOS),Surface Transportation Board (STB),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2700000 0 0 2002-02-12T00:00:00-05:00
130369 ZELIFF IRELAND & ASSOC fc45749f-9cfc-4f45-bc37-6d005b068000 YY ZELIFF IRELAND & ASSOC 51285 FELD ENTERTAINMENT 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-02-13T00:00:00-05:00
130388 SHELL USA, INC. (FKA SHELL OIL COMPANY) 491af14d-ec18-453c-8696-84e7a240e8d2 YY SHELL USA, INC. (FKA SHELL OIL COMPANY) 35092 SHELL USA, INC. (FKA SHELL OIL COMPANY) 2001 year_end IMM   Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Security Council (NSC),Occupational Safety & Health Administration (OSHA),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. International Trade Commission (ITC)   2705262 0 0 2002-02-13T00:00:00-05:00
130491 COVINGTON & BURLING LLP 19de0599-c2e3-4cee-b144-32f800691846 YY COVINGTON & BURLING LLP 11195 COALITION OF BOSTON TEACHING HOSPITALS 2001 year_end IMM   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-02-13T00:00:00-05:00
130496 CLARK & WEINSTOCK fe128d9a-49f2-4868-9a56-27f2225cdf49 YY CLARK & WEINSTOCK 9443 INTEGIC 2001 year_end IMM   Federal Emergency Management Agency (FEMA),Office of Management & Budget (OMB),Transportation, Dept of (DOT) 40000   0 0 2002-02-13T00:00:00-05:00
130526 CLARK & WEINSTOCK 63868822-9d3e-4a23-9110-6c0c2ee875f5 YY CLARK & WEINSTOCK 9443 LEADINGAGE 2001 year_end IMM   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 100000   0 0 2002-02-13T00:00:00-05:00
130630 AMERICA'S ESSENTIAL HOSPITALS c690195a-ba5b-4ab9-bc10-ab04dbd330ee YY AMERICA'S ESSENTIAL HOSPITALS 27057 AMERICA'S ESSENTIAL HOSPITALS 2001 year_end IMM Immigrant Health Benefits-related legislation (H.R. 2635) H-1B Program (H.R. 4227, H.R., 4402, H.R. 3983) Federal Responsibility for Immigrant Health Act Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,SENATE,White House Office   200000 0 0 2002-02-13T00:00:00-05:00
130748 HALLIBURTON COMPANY 077c5a89-885f-4903-91ac-86da8ad82c4a YY HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2001 year_end IMM   Commerce, Dept of (DOC),Energy, Dept of,Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA)   150000 0 0 2002-02-13T00:00:00-05:00
131135 NAFSA: ASSOCIATION OF INTERNATIONAL EDUCATORS 0becce2c-e839-4eab-a41a-ee3335010954 YY NAFSA: ASSOCIATION OF INTERNATIONAL EDUCATORS 26375 NAFSA: ASSOCIATION OF INTERNATIONAL EDUCATORS 2001 year_end IMM CIPRIS/SEVIS Student Tracking System Immigration Processing/INS Reform Bureau of Citizenship & Immigration Services (BCIS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS)   40000 0 0 2002-02-13T00:00:00-05:00
131154 ANTI-DEFAMATION LEAGUE 8e0309d0-4eac-4e84-80f7-1c96c8c48a5d YY ANTI-DEFAMATION LEAGUE 4072 ANTI-DEFAMATION LEAGUE 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Education, Dept of,HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office   60000 0 0 2002-02-13T00:00:00-05:00
131363 HOGAN LOVELLS US LLP 5001c874-eb5f-46a9-a9c9-91d3b6bd51e8 YY HOGAN LOVELLS US LLP 18422 MICHELIN NORTH AMERICA 2001 year_end IMM   Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR) 480000   0 0 2002-02-13T00:00:00-05:00
131450 UNIVERSITY OF PITTSBURGH 88a425a2-640a-4439-8f72-b58eecd55ac3 YY UNIVERSITY OF PITTSBURGH 53356 UNIVERSITY OF PITTSBURGH 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE   60000 0 0 2002-02-13T00:00:00-05:00
131992 UNIVERSITY OF MICHIGAN 671b85f5-9adb-493e-867b-0bca952d494f YY UNIVERSITY OF MICHIGAN 39473 UNIVERSITY OF MICHIGAN 2001 year_end IMM   Agriculture, Dept of (USDA),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Federal Aviation Administration (FAA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Park Service (NPS),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Transportation, Dept of (DOT),Veterans Affairs, Dept of (VA)   120000 0 0 2002-02-14T00:00:00-05:00
132055 SQUIRE PATTON BOGGS 4cc39b64-e781-4213-97c0-b0d622feba38 YY SQUIRE PATTON BOGGS 30906 MCKINSEY & CO 2001 year_end IMM   HOUSE OF REPRESENTATIVES     0 0 2002-02-14T00:00:00-05:00
132140 SQUIRE PATTON BOGGS 28db21f6-c0b4-49e5-98bf-ee1456723e0e YY SQUIRE PATTON BOGGS 30906 U S ENGLISH 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE,White House Office 0   0 0 2002-02-14T00:00:00-05:00
132493 UNIVERSITY OF CALIFORNIA 4c7fa412-2fd9-40d8-b420-14ce882b446e YY UNIVERSITY OF CALIFORNIA 39358 UNIVERSITY OF CALIFORNIA 2001 year_end IMM   Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Centers For Medicare and Medicaid Services (CMS),Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Institutes of Health (NIH),Natl Oceanic & Atmospheric Administration (NOAA),Natl Science Foundation (NSF),Navy, Dept of,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,White House Office     0 0 2002-02-14T00:00:00-05:00
132567 WINSTON & STRAWN LLP 6892abd2-861f-4cad-a26f-9d57d5a90099 YY WINSTON & STRAWN LLP 41682 REYES HOLDINGS LLC 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS) 0   0 0 2002-02-14T00:00:00-05:00
132679 NURNBERGER & ASSOCIATES 64f9a69a-c8ab-492b-95c0-bc9735b7cabe YT NURNBERGER & ASSOCIATES 29722 MUKESH ASSOMULL 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-02-14T00:00:00-05:00
132698 PAUL, WEISS, RIFKIND, WHARTON & GARRISON LLP a8161fe3-49d5-40e9-a5c5-c0d04d620859 YY PAUL, WEISS, RIFKIND, WHARTON & GARRISON LLP 30930 IBP 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-02-14T00:00:00-05:00
132710 ACCENTURE, LLP 83389850-61a7-44fc-89fc-c2500acf6cb9 YY ACCENTURE, LLP 3960 ACCENTURE LLP 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Executive Office of the President (EOP),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of   271000 0 0 2002-02-14T00:00:00-05:00
132816 PRICEWATERHOUSECOOPERS 2ec41435-9d72-42cc-aa09-ed1bc84516cb YY PRICEWATERHOUSECOOPERS 10764 PWC US GROUP LLP (FKA PRICEWATERHOUSECOOPERS) 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR)   580000 0 0 2002-02-14T00:00:00-05:00
132824 SOLOMON GROUP 02104f53-9a58-4e90-b1b9-f0b089c0e5b1 YT SOLOMON GROUP 49373 UNITED TO SECURE AMERICA 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-02-14T00:00:00-05:00
132929 SCHRAMM, WILLIAMS & ASSOCIATES, INC. 3b3c858e-5d85-4f55-ae7c-221e89301c9e YY SCHRAMM, WILLIAMS & ASSOCIATES, INC. 34592 WESTERN GROWERS 2001 year_end IMM   Agriculture, Dept of (USDA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-02-14T00:00:00-05:00
133085 GREENBERG TRAURIG, LLP 170cd446-80d8-4336-90c6-55c483d75401 YY GREENBERG TRAURIG, LLP 16896 CITY OF MIAMI 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-02-14T00:00:00-05:00
133158 AMERICAN BAR ASSOCIATION 7249d4d7-b4e5-47d7-a048-712e791d7c65 YY AMERICAN BAR ASSOCIATION 1808 AMERICAN BAR ASSOCIATION 2001 year_end IMM   Commerce, Dept of (DOC),Defense, Dept of (DOD),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),SENATE,Treasury, Dept of,White House Office   540000 0 0 2002-02-14T00:00:00-05:00
133241 MEYERS AND ASSOCIATES 01fda054-cbbb-477f-80ff-802fc451bf41 YY MEYERS AND ASSOCIATES 25077 CITY OF LAS CRUCES 2001 year_end IMM   HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE 20000   0 0 2002-02-14T00:00:00-05:00
133253 GREENBERG TRAURIG, LLP b00b7d1e-382b-444a-a364-75d4aedbc590 YY GREENBERG TRAURIG, LLP 16896 TECHSERVE ALLIANCE 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 25000   0 0 2002-02-14T00:00:00-05:00
133308 GREENBERG TRAURIG, LLP a5b6fa8d-1016-4b6e-a409-841cfe0e4ca3 YY GREENBERG TRAURIG, LLP 16896 MIAMI-DADE COUNTY FLORIDA 2001 year_end IMM   Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) 80000   0 0 2002-02-14T00:00:00-05:00
133358 CALIFORNIA STATE UNIVERSITY 5afd17a1-1064-42bc-8a6d-a8e076ff8771 YY CALIFORNIA STATE UNIVERSITY 7782 CALIFORNIA STATE UNIVERSITY 2001 year_end IMM   Defense, Dept of (DOD),Education, Dept of,Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),White House Office   260000 0 0 2002-02-14T00:00:00-05:00
133377 GREENBERG TRAURIG, LLP a05a8c01-2482-410a-bca2-a5fddd683b15 YY GREENBERG TRAURIG, LLP 16896 INGERSOLL-RAND 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-02-14T00:00:00-05:00
133411 GREENBERG TRAURIG, LLP 641d479f-8a6d-4e05-aa54-c0fadf04d5a2 YY GREENBERG TRAURIG, LLP 16896 COMMONWEALTH OF THE NORTHERN MARIANA ISLANDS 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 600000   0 0 2002-02-14T00:00:00-05:00
133455 SCHRAMM, WILLIAMS & ASSOCIATES, INC. b7b3eaa9-34b9-4cbd-953d-d6036b4bebce YY SCHRAMM, WILLIAMS & ASSOCIATES, INC. 34592 CALIFORNIA TOMATO COMMISSION 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-02-14T00:00:00-05:00
133483 MEYERS AND ASSOCIATES 179dbc8e-b6e6-47c1-8a75-d72d2452e04b YY MEYERS AND ASSOCIATES 25077 TEXAS A&M RESEARCH FOUNDATION 2001 year_end IMM   Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Maritime Administration (MARAD),SENATE 80000   0 0 2002-02-14T00:00:00-05:00
133596 US COMMITTEE FOR REFUGEES AND IMMIGRANTS (USCRI) 9d876d0e-9ca9-42e9-b910-1f6b07243e3c YY US COMMITTEE FOR REFUGEES AND IMMIGRANTS (USCRI) 19148 US COMMITTEE FOR REFUGEES AND IMMIGRANTS (USCRI) 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS),White House Office   20000 0 0 2002-02-14T00:00:00-05:00
134184 MGN, INC. (FORMERLY MCCLURE, GERARD & NEUENSCHWANDER, INC.) 87a147d8-f81c-4c25-8d10-727e4a8b577a YY MGN, INC. (FORMERLY MCCLURE, GERARD & NEUENSCHWANDER, INC.) 24260 NATIVE AMERICAN MOHEGANS INC 2001 year_end IMM   HOUSE OF REPRESENTATIVES 100000   0 0 2002-02-14T00:00:00-05:00
134406 BILBRAY, BRIAN P. cb111d6a-6511-4089-958e-c2cd2786f0e9 YY BILBRAY, BRIAN P. 63815 COUNTY OF LOS ANGELES 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Justice, Dept of (DOJ),Office of Management & Budget (OMB),Transportation, Dept of (DOT) 20000   0 0 2002-02-14T00:00:00-05:00
134410 DORCY, JAMES R. 13d2c478-e441-4749-a47e-c154f62923da YYY DORCY, JAMES R. 12471 FED FOR AMERICAN IMMIGRATION REFORM 2001 year_end IMM     0   0 0 2002-02-14T00:00:00-05:00
134501 BAKER & MCKENZIE, LLP ecda35f9-658e-4e39-9c5e-a7b7ec2dfbba YA BAKER & MCKENZIE, LLP 5142 IBP INC 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2002-02-14T00:00:00-05:00
134545 EDUCATION LEGISLATIVE SERVICES, INC ebf14572-846c-405d-b6c8-1a7f4b59a270 YY EDUCATION LEGISLATIVE SERVICES, INC 13164 CENTRAL CALIFORNIA EDUCATION LEGISLATION CONSORTIUM 2001 year_end IMM   Agriculture, Dept of (USDA),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 109000   0 0 2002-02-14T00:00:00-05:00
134616 HELMSIN YARWOOD & ASSOC 8c71cbb9-d78a-45bd-86c5-8a6fe1e6da15 YY HELMSIN YARWOOD & ASSOC 18045 AMERICAN HEALTH CARE ASSN 2001 year_end IMM   Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE 160000   0 0 2002-02-14T00:00:00-05:00
134738 THE OB-C GROUP, LLC 407ac420-be1b-4de5-bcf9-6e832ebd4cdf YY THE OB-C GROUP, LLC 29802 NATL THOROUGHBRED RACING ASSN 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE     0 0 2002-02-14T00:00:00-05:00
134830 FRENCH & COMPANY d88f2e31-f167-4cae-80ba-a6548fa5bb36 YY FRENCH & COMPANY 15452 INTL ELECTRONICS MANUFACTURERS & CONSUMER 2001 year_end IMM   Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Customs & Border Protection 20000   0 0 2002-02-14T00:00:00-05:00
135166 AMERICAN IMMIGRATION LAWYERS ASSOCIATION 96e85d7b-f24a-405a-800d-5d5aceed4233 YY AMERICAN IMMIGRATION LAWYERS ASSOCIATION 2605 AMERICAN IMMIGRATION LAWYERS ASSOCIATION 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,State, Dept of (DOS),White House Office   20000 0 0 2002-02-14T00:00:00-05:00
135209 BAKER & MCKENZIE, LLP 4a890f67-d54a-4724-bf43-7b286ee7f34f YA BAKER & MCKENZIE, LLP 5142 COMMISSION ON GRADUATES OF FOREIGN NURSING SCHOOLS 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-02-14T00:00:00-05:00
135361 INTERNATIONAL BROTHERHOOD OF TEAMSTERS 9d9217b3-f2c6-476f-ab09-9fa536ae88e1 YY INTERNATIONAL BROTHERHOOD OF TEAMSTERS 19855 INTERNATIONAL BROTHERHOOD OF TEAMSTERS 2001 year_end IMM   Energy, Dept of,Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Labor, Dept of (DOL),Office of the Vice President of the United States,SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   510000 0 0 2002-02-14T00:00:00-05:00
135693 NURNBERGER & ASSOCIATES 40b1dcc1-e00c-424b-ad4f-ed5f7b9acbe6 YA NURNBERGER & ASSOCIATES 29722 MUKESH ASSOMULL 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2002-02-14T00:00:00-05:00
135789 HARVARD UNIVERSITY--PRESIDENT AND FELLOWS OF HARVARD COLLEGE 1a902f76-14a5-4252-bb27-1d7b32b98cb2 YY HARVARD UNIVERSITY--PRESIDENT AND FELLOWS OF HARVARD COLLEGE 17705 HARVARD UNIVERSITY--PRESIDENT AND FELLOWS OF HARVARD COLLEGE 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE,White House Office   260000 0 0 2002-02-14T00:00:00-05:00
136220 GREENBERG TRAURIG, LLP 6fdbcc37-5249-4c57-9861-ddf0411ed615 YY GREENBERG TRAURIG, LLP 16896 SAIPAN GARMENT MANUFACTURERS ASSN 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 160000   0 0 2002-02-14T00:00:00-05:00
136332 QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) d4bc1302-ccb5-4a71-b301-18915a41dc8f YY QGA PUBLIC AFFAIRS (FORMERLY QUINN GILLESPIE & ASSOCIATES) 54197 TYSON FOODS INC 2001 year_end IMM   Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 0   0 0 2002-02-14T00:00:00-05:00
136430 SOCIETY FOR HUMAN RESOURCE MANAGEMENT 5dd7a1d3-8f63-4a50-ae89-4cb3e4973679 YY SOCIETY FOR HUMAN RESOURCE MANAGEMENT 35946 SOCIETY FOR HUMAN RESOURCE MANAGEMENT 2001 year_end IMM   Equal Employment Opportunity Commission (EEOC),Executive Office of the President (EOP),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Transportation, Dept of (DOT),Treasury, Dept of   180000 0 0 2002-02-14T00:00:00-05:00
136497 WEXLER | WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC ed16f569-5565-4ac4-8758-7a017a37b6ec YY WEXLER | WALKER, A UNIT OF HILL+KNOWLTON STRATEGIES, LLC 41113 LASER CARD 2001 year_end IMM   Executive Office of the President (EOP),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Management & Budget (OMB),SENATE 0   0 0 2002-02-14T00:00:00-05:00
136624 EDUCATION LEGISLATIVE SERVICES, INC 17b5d5c4-4aa5-46d7-9763-d0d073b1c7ca YY EDUCATION LEGISLATIVE SERVICES, INC 13164 OAKLAND UNIFIED SCHOOL DIST 2001 year_end IMM   Agriculture, Dept of (USDA),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,White House Office 19000   0 0 2002-02-14T00:00:00-05:00
137030 CATALYST PARTNERS LLC 5ba11731-fecb-41d2-85f5-60cfa7869948 YY CATALYST PARTNERS LLC 66658 NUMBERSUSA COM 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Education, Dept of,Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE 40000   0 0 2002-02-14T00:00:00-05:00
137134 LYONDELL CHEMICAL COMPANY 086aa81f-0d7e-4cee-9a9c-8976dfbcad2d YY LYONDELL CHEMICAL COMPANY 49203 LYONDELL CHEMICAL COMPANY 2001 year_end IMM   Education, Dept of,Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE     0 0 2002-02-14T00:00:00-05:00
137268 POWELL GOLDSTEIN LLP c5852d37-06fe-48b8-9a4d-2b21e88c8b86 YY POWELL GOLDSTEIN LLP 31942 NATIONAL ASSOCIATION OF PUBLIC HOSPITALS AND HEALTH SYSTEMS 2001 year_end IMM   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office 40000   0 0 2002-02-14T00:00:00-05:00
137435 WILLIAMS AND JENSEN, PLLC 1d7907b2-3148-4732-b47b-5551dadf7cfb YY WILLIAMS AND JENSEN, PLLC 41454 UNITED AIRLINES INC 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) 180000   0 0 2002-02-14T00:00:00-05:00
137569 RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY 19c04df3-71bc-4482-9573-9bd26a0fccaf YY RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY 33977 RUTGERS THE STATE UNIVERSITY OF NEW JERSEY 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE   220000 0 0 2002-02-14T00:00:00-05:00
137899 MWW GROUP 82e68493-9287-4e27-96dc-2b624ac0b41d YY MWW GROUP 26318 INTL DISTANCE LEARNING 2001 year_end IMM   Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-02-14T00:00:00-05:00
137944 DELTA AIR LINES, INC. c5788bde-3e0f-485a-8cb1-ff234b8b157d YY DELTA AIR LINES, INC. 11982 DELTA AIR LINES INC 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Customs & Border Protection   1300000 0 0 2002-02-14T00:00:00-05:00
138077 PAUL, WEISS, RIFKIND, WHARTON & GARRISON LLP 94377d5a-1a65-461f-b1ad-213e1db2b54e YY PAUL, WEISS, RIFKIND, WHARTON & GARRISON LLP 30930 COMMISSION ON GRADUATES OF FOREIGN NURGING SCHOOLS 2001 year_end IMM   SENATE 20000   0 0 2002-02-14T00:00:00-05:00
138088 NATIONAL IMMIGRATION FORUM 976074be-8d18-4e57-b7a6-24e6fc5fbc06 YY NATIONAL IMMIGRATION FORUM 28036 NATIONAL IMMIGRATION FORUM 2001 year_end IMM       20000 0 0 2002-02-14T00:00:00-05:00
138664 AFFILIATED COMPUTER SERVICES, INC. f2567d44-1f8e-49bf-a537-e4dec24514ff YY AFFILIATED COMPUTER SERVICES, INC. 65316 AFFILIATED COMPUTER SERVICES INC 2001 year_end IMM   HOUSE OF REPRESENTATIVES   100000 0 0 2002-02-14T00:00:00-05:00
138736 AMERICAN HEALTH CARE ASSOCIATION 1b6b8fe1-5b46-40be-8084-8b1324f96d7f YY AMERICAN HEALTH CARE ASSOCIATION 2491 AMERICAN HEALTH CARE ASSOCIATION 2001 year_end IMM   Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE   305000 0 0 2002-02-14T00:00:00-05:00
138804 DISNEY WORLDWIDE SERVICES, INC. ff9a508d-8acd-4dff-a88b-ecd375ec4668 YY DISNEY WORLDWIDE SERVICES, INC. 12378 DISNEY WORLDWIDE SERVICES INC 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE     0 0 2002-02-14T00:00:00-05:00
138956 FOOD RESEARCH AND ACTION CENTER 61385cdd-2cd5-4286-b1d2-8dd85b6b993f YY FOOD RESEARCH AND ACTION CENTER 15100 FOOD RESEARCH AND ACTION CENTER 2001 year_end IMM   Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2002-02-14T00:00:00-05:00
138989 BERLINER CANDON & JIMISON, A PROFESSIONAL CORP f896bdb0-7959-4be2-a77d-0ab902e50aaf YY BERLINER CANDON & JIMISON, A PROFESSIONAL CORP 6883 COUNTY OF LOS ANGELES 2001 year_end IMM   Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Office of Management & Budget (OMB),SENATE,Treasury, Dept of 100000   0 0 2002-02-14T00:00:00-05:00
139115 US STRATEGIES 54a31be3-b88e-4ef2-a667-4817159e2130 YT US STRATEGIES 38825 AMERICAN NURSERY & LANDSCAPE ASSN 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2002-02-14T00:00:00-05:00
139202 PHILIPS HOLDING USA, INC. 3e9116c8-302c-4e49-92b3-60d0b6465aac YY PHILIPS HOLDING USA, INC. 31417 PHILIPS HOLDING USA INC. 2001 year_end IMM   Energy, Dept of,Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Intl Trade Administration (ITA),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2002-02-14T00:00:00-05:00
139227 RETIRESAFE b5eccd57-243f-43f8-ba8b-69b7af6db1f1 YY RETIRESAFE 11025 RETIRESAFE 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE   360000 0 0 2002-02-14T00:00:00-05:00
139512 AFGHANISTAN FOUNDATION 6c043d9a-c876-4372-b16c-246da16390d5 YY AFGHANISTAN FOUNDATION 60891 AFGHANISTAN FOUNDATION 2001 year_end IMM   Central Intelligence Agency (CIA),Commerce, Dept of (DOC),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Agency for International Development (USAID) 0   0 0 2002-02-15T00:00:00-05:00
139542 JORDEN BURT LLP eb8aa159-172d-421a-8c7f-b6b009297d3e YY JORDEN BURT LLP 43398 CITY OF MIAMI BEACH FLORIDA 2001 year_end IMM   HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2002-02-15T00:00:00-05:00
139616 JORDEN BURT LLP 88958754-9a5f-467d-bea6-ce980a23b1bb YT JORDEN BURT LLP 43398 UNIV OF MIAMI 2001 year_end IMM   Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Agency for International Development (USAID),U.S. Information Agency (USIA) 140000   0 0 2002-02-15T00:00:00-05:00
139636 SMITH & ASSOC, PHILIP S. d674dde7-84e9-40da-b6ac-64ddca96d942 YY SMITH & ASSOC, PHILIP S. 48257 AFGHANISTAN FOUNDATION 2001 year_end IMM   Bureau of Citizenship & Immigration Services (BCIS),Central Intelligence Agency (CIA),Commerce, Dept of (DOC),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Agency for International Development (USAID) 0   0 0 2002-02-15T00: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);