fara_foreign_principals
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
444 rows where country = "KOREA, SOUTH" sorted by foreign_principal
This data as json, CSV (advanced)
Suggested facets: address_2, city, state, zip
country 1
- KOREA, SOUTH · 444 ✖
| rowid | registration_number | registrant_date | registrant_name | foreign_principal ▼ | fp_registration_date | fp_termination_date | country | address_1 | address_2 | city | state | zip |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3561 | 5356 | 01/31/2000 | Livingston Group, LLC | A.K.Capital NHB | 06/04/2009 | 07/31/2009 | KOREA, SOUTH | |||||
| 4510 | 5356 | 01/31/2000 | Livingston Group, LLC | Air Window, Inc. | 05/02/2003 | 05/15/2003 | KOREA, SOUTH | Suite 224, D-Best Business Center 54-7 Shinwoldong, Yangcchonku Seoul | ||||
| 13997 | 2012 | 03/07/1967 | American International Business Research Corporation | Ambassador Hyun Chul Kim | 03/07/1967 | 06/30/1967 | KOREA, SOUTH | Washington | DC | |||
| 14969 | 1493 | 11/24/1961 | Oliver, Robert T. | Ambassador Soo Young Lee (Republic of Korea Delegation to the United Nations) | 11/24/1961 | 11/20/1962 | KOREA, SOUTH | New York | NY | |||
| 8036 | 3489 | 06/24/1983 | Global U.S.A., Inc. | Association of Foreign Trading Agents of Korea | 03/22/1990 | 04/08/1990 | KOREA, SOUTH | Seoul | ||||
| 5889 | 3492 | 06/24/1983 | Akin, Gump, Strauss, Hauer & Feld, LLP | Cheil Industries, Inc. | 03/16/1995 | 06/22/1995 | KOREA, SOUTH | Seoul | ||||
| 5778 | 4754 | 01/19/1993 | Law Offices of Robert K. Kelley | Choon-Won Lim | 07/31/1995 | 09/01/1995 | KOREA, SOUTH | Seoul | ||||
| 5417 | 5187 | 06/23/1997 | ChungCheongNam-Do Provincial Government - New York Office | Chungcheongnam-Do Provincial Government | 06/23/1997 | 11/30/2007 | KOREA, SOUTH | Taejon | ||||
| 10470 | 2572 | 04/07/1975 | Aaron D. Cushman & Associates, Inc. | Consulate General Republic of Korea | 08/13/1984 | 04/24/1985 | KOREA, SOUTH | CHICAGO, ILL | KS | |||
| 3080 | 6142 | 11/20/2012 | Parter International, Inc. | Consulate General of Republic of Korea | 11/21/2012 | 02/07/2013 | KOREA, SOUTH | |||||
| 2132 | 6557 | 05/14/2018 | Sachem Strategies, LLC | Consulate General of the Republic of Korea | 05/14/2018 | 09/23/2019 | KOREA, SOUTH | 300 Washington Street #251 | Newton | MA | 02458 | |
| 4536 | 5548 | 03/28/2003 | Hichkad, Ravi Ramesh | Consulate General of the Republic of Korea | 03/28/2003 | 05/23/2003 | KOREA, SOUTH | 229 Peachtree Street, N.E. International Tower, #500 Atlanta 30303 | GA | |||
| 1322 | 5198 | 07/31/1997 | Pillsbury Winthrop Shaw Pittman, LLP | Corporate Association of the Gaesong Industrial Complex (CAGIC) at the direction of South Korean consultancy HC & Sons LLC (HC & Sons) | 07/21/2021 | 10/10/2022 | KOREA, SOUTH | Suite 706 Kbiz Bldg. | 30 Eunhaeng-ro Yeongdeungpo-gu | Seoul | ||
| 11783 | 2944 | 08/09/1978 | Fasturn, Inc. | Council of Korea Textiles Export Associations | 11/26/1979 | 08/08/1984 | KOREA, SOUTH | Seoul | ||||
| 12307 | 2072 | 01/30/1968 | Daniels, Houlihan & Palmeter | Council of Korea Textiles Export Associations | 11/04/1977 | 03/26/1986 | KOREA, SOUTH | Seoul | ||||
| 16292 | 705 | 01/08/1952 | Geissinger, Wayne Townsend | D.Y. Namkoong | 01/08/1952 | 06/30/1952 | KOREA, SOUTH | |||||
| 756 | 7118 | 05/12/2022 | 5W Public Relations, LLC | Dae Kim | 09/22/2023 | 09/30/2023 | KOREA, SOUTH | 31, Dongmak -ro, 2-gil, Mapo-gu, | Seoul | |||
| 11768 | 2848 | 11/25/1977 | Hendricks, Marshall L. | Daehankyoyuk Life Insurance Company | 12/01/1979 | 11/24/1989 | KOREA, SOUTH | Seoul | ||||
| 10023 | 3734 | 09/18/1985 | Michael K. Deaver & Associates | Daewoo Corporation | 11/21/1985 | 10/24/1986 | KOREA, SOUTH | Seoul | ||||
| 10098 | 3301 | 11/10/1981 | Hill and Knowlton Strategies, LLC | Daewoo Electronics Company/Samsung Electronics/Lucky Goldstar Company, Ltd. | 09/25/1985 | 12/31/1986 | KOREA, SOUTH | Seoul | ||||
| 10244 | 3678 | 05/15/1985 | Latham, Watkins & Hills | Daewoo Industrial Company, Ltd. | 05/15/1985 | 03/06/1986 | KOREA, SOUTH | Seoul | ||||
| 12271 | 2852 | 12/15/1977 | Akin, Gump, Hauer & Feld | Daewoo Industrial Company, Ltd. | 12/15/1977 | 06/15/1979 | KOREA, SOUTH | Seoul | ||||
| 9631 | 3845 | 06/18/1986 | Wagner, Hines & Avary, Inc. | Daewoo International America | 09/23/1986 | 12/01/1987 | KOREA, SOUTH | |||||
| 10658 | 2740 | 12/17/1976 | Hill & Knowlton, Inc. | Daewoo International Corporation | 01/06/1984 | 10/22/1986 | KOREA, SOUTH | Washington | DC | |||
| 2269 | 6377 | 09/19/2016 | Prime Policy Group | Democratic Party of Korea | 01/03/2018 | 04/01/2018 | KOREA, SOUTH | |||||
| 11741 | 3081 | 01/09/1980 | Lillick, McHose & Charles | Dongwon Fisheries Company, Ltd. | 01/29/1980 | 07/31/1980 | KOREA, SOUTH | Seoul | ||||
| 11722 | 3088 | 02/15/1980 | Bomar, Thomas H. | Dongwon Fisheries Company, Ltd. (Yoon Kook Wang) (Kings Pacific Fisheries Corporation) | 02/15/1980 | 08/01/1980 | KOREA, SOUTH | Seoul | ||||
| 16069 | 838 | 07/27/1954 | John C. Metcalfe & Associates, Inc. | Dr. S.M. Vinocour | 07/27/1954 | 07/27/1959 | KOREA, SOUTH | Washington | DC | |||
| 16293 | 705 | 01/08/1952 | Geissinger, Wayne Townsend | Dr. Syngman Rhee | 01/08/1952 | 06/30/1952 | KOREA, SOUTH | |||||
| 17629 | 63 | 07/27/1942 | Chung, Woonsoo | Dr. Syngman Rhee | 07/27/1942 | 07/27/1943 | KOREA, SOUTH | Washington | DC | |||
| 17683 | 26 | 07/09/1942 | Chang, Kee Young | Dr. Syngman Rhee | 07/09/1942 | 07/09/1942 | KOREA, SOUTH | Washington | DC | |||
| 6936 | 4674 | 05/27/1992 | McGuire, Woods, Battle & Boothe | Electronic Industries Association of Korea | 05/27/1992 | 07/01/1993 | KOREA, SOUTH | Seoul | ||||
| 7970 | 4149 | 06/22/1988 | Manchester Trade, Inc. | Electronic Industries Association of Korea | 05/11/1990 | 03/31/1992 | KOREA, SOUTH | Seoul | ||||
| 9512 | 3301 | 11/10/1981 | Hill and Knowlton Strategies, LLC | Electronics Industries Association of Korea | 01/12/1987 | 03/31/1990 | KOREA, SOUTH | |||||
| 9670 | 3871 | 08/18/1986 | Electronic Industries Association of Korea (EIAK) | Electronics Industries Association of Korea | 08/18/1986 | 10/14/1986 | KOREA, SOUTH | |||||
| 10809 | 3485 | 06/16/1983 | Oppenheimer, Wolff & Donnelly | Electronics Industries Association of Korea | 06/16/1983 | 02/28/1987 | KOREA, SOUTH | Seoul | ||||
| 4976 | 5291 | 12/04/1998 | Downen, Robert L. | Embassy of Korea | 02/01/2000 | 12/31/2001 | KOREA, SOUTH | 2450 Massachusetts Avenue N.W. 20008 | DC | |||
| 9515 | 2696 | 06/09/1976 | Anderson & Pendleton, C.A. | Embassy of Korea | 01/12/1987 | 11/30/1988 | KOREA, SOUTH | Washington | DC | |||
| 9917 | 3663 | 03/22/1985 | Colby, Baily & Associates | Embassy of Korea | 02/20/1986 | 12/31/1986 | KOREA, SOUTH | Washington | DC | |||
| 11948 | 3001 | 02/26/1979 | Sigur, Christopher | Embassy of Korea | 02/26/1979 | 06/30/1979 | KOREA, SOUTH | Washington | DC | |||
| 13988 | 2020 | 04/11/1967 | Carl Levin Associates, Inc. | Embassy of Korea | 04/11/1967 | 03/16/1967 | KOREA, SOUTH | Washington | DC | |||
| 14717 | 540 | 09/16/1948 | Ginsburg, Feldman & Bress | Embassy of Korea | 07/15/1963 | 01/01/1969 | KOREA, SOUTH | Washington | DC | |||
| 3777 | 5848 | 01/25/2008 | Steptoe & Johnson, LLP | Embassy of Korea, the Korean Government | 01/25/2008 | 02/01/2008 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3082 | 5852 | 02/05/2008 | Covington & Burling, LLP | Embassy of Republic of Korea in United States | 11/15/2012 | 12/31/2013 | KOREA, SOUTH | |||||
| 111 | 3492 | 06/24/1983 | Akin, Gump, Strauss, Hauer & Feld, LLP | Embassy of the Republic of Korea | 03/03/2026 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 413 | 5430 | 05/10/2001 | BGR Government Affairs, LLC | Embassy of the Republic of Korea | 02/27/2025 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 501 | 7321 | 09/12/2023 | DGA Group LLC | Embassy of the Republic of Korea | 11/23/2024 | 12/31/2024 | KOREA, SOUTH | |||||
| 1435 | 5870 | 06/16/2008 | Brownstein Hyatt Farber Schreck, LLP | Embassy of the Republic of Korea | 01/24/2021 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 1672 | 5044 | 09/13/1995 | Reed, T. Dean | Embassy of the Republic of Korea | 12/30/2019 | 06/01/2021 | KOREA, SOUTH | |||||
| 1970 | 5928 | 04/10/2009 | Nelson Mullins Riley & Scarborough, LLP | Embassy of the Republic of Korea | 01/10/2019 | 04/20/2022 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2100 | 5430 | 05/10/2001 | BGR Government Affairs, LLC | Embassy of the Republic of Korea | 06/26/2018 | 12/31/2022 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2266 | 2165 | 10/09/1969 | Squire Patton Boggs, LLP | Embassy of the Republic of Korea | 01/10/2018 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 2493 | 6401 | 01/20/2017 | Cornerstone Government Affairs | Embassy of the Republic of Korea | 01/20/2017 | 01/01/2025 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2554 | 3718 | 08/07/1985 | Holland & Knight | Embassy of the Republic of Korea | 08/23/2016 | 12/31/2019 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2667 | 6320 | 09/29/2015 | Rokk Solutions, LLC | Embassy of the Republic of Korea | 09/29/2015 | 04/01/2018 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2742 | 5430 | 05/10/2001 | BGR Government Affairs, LLC | Embassy of the Republic of Korea | 04/17/2015 | 12/31/2016 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2775 | 6276 | 02/08/2015 | TwinLogic Strategies, LLP | Embassy of the Republic of Korea | 02/08/2015 | 01/01/2017 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2777 | 6275 | 02/04/2015 | Harbinger Strategies, LLC | Embassy of the Republic of Korea | 02/04/2015 | 12/31/2016 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2843 | 6197 | 11/19/2013 | Kasowitz, Benson, Torres and Friedman, LLP | Embassy of the Republic of Korea | 09/09/2014 | 12/31/2014 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2911 | 6216 | 04/16/2014 | Singer Bonjean Strategies | Embassy of the Republic of Korea | 04/16/2014 | 12/08/2014 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2926 | 6212 | 03/10/2014 | Finn Partners, Inc. | Embassy of the Republic of Korea | 03/10/2014 | 12/31/2016 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | ||
| 2930 | 6211 | 03/07/2014 | Cornerstone Government Affairs, LLC | Embassy of the Republic of Korea | 03/07/2014 | 12/31/2014 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3142 | 6107 | 06/06/2012 | West Wing Writers, LLC | Embassy of the Republic of Korea | 06/06/2012 | 12/31/2013 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008-2850 | |
| 3178 | 6089 | 02/15/2012 | Nickles Group, LLC | Embassy of the Republic of Korea | 02/15/2012 | 12/31/2018 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3191 | 1481 | 09/27/1961 | Ruder Finn, Inc. | Embassy of the Republic of Korea | 01/06/2012 | 03/01/2014 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3217 | 6072 | 10/19/2011 | West Wing Writers, LLC | Embassy of the Republic of Korea | 10/19/2011 | 10/31/2011 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008-2850 | |
| 3381 | 3634 | 11/15/1984 | Daniel J. Edelman, Inc. | Embassy of the Republic of Korea | 09/24/2010 | 12/31/2011 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3383 | 6001 | 09/21/2010 | Singer Bonjean Strategies | Embassy of the Republic of Korea | 09/21/2010 | 12/31/2012 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3384 | 5666 | 01/31/2005 | FGS Global (US) LLC (FKA FGH Holdings LLC) | Embassy of the Republic of Korea | 09/20/2010 | 12/31/2011 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3423 | 3492 | 06/24/1983 | Akin, Gump, Strauss, Hauer & Feld, LLP | Embassy of the Republic of Korea | 05/25/2010 | 12/31/2017 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3447 | 5982 | 03/22/2010 | Thomas Capitol Partners, Inc. | Embassy of the Republic of Korea | 03/22/2010 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 3689 | 5882 | 09/22/2008 | Arent Fox, LLP | Embassy of the Republic of Korea | 09/22/2008 | 03/15/2010 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3868 | 3492 | 06/24/1983 | Akin, Gump, Strauss, Hauer & Feld, LLP | Embassy of the Republic of Korea | 06/18/2007 | 12/31/2008 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 4017 | 5671 | 03/01/2005 | RJI Government Strategies | Embassy of the Republic of Korea | 06/28/2006 | 09/30/2007 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 4035 | 5303 | 12/07/1998 | Sandler, Travis & Rosenberg, P.A. | Embassy of the Republic of Korea | 05/26/2006 | 06/30/2007 | KOREA, SOUTH | 2450 Massachusetts Avenue, N.W. | Washington | DC | 20008 | |
| 4144 | 5673 | 03/07/2005 | Scribe Strategies & Advisors | Embassy of the Republic of Korea | 10/14/2005 | 12/30/2009 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 4763 | 5458 | 09/10/2001 | International Technology and Trade Associates, Inc. (ITTA) | Embassy of the Republic of Korea | 09/10/2001 | 12/31/2001 | KOREA, SOUTH | 2450 Massachusetts Avenue N.W. 20008 | DC | |||
| 5906 | 4539 | 07/09/1991 | Paul, Weiss, Rifkind, Wharton & Garrison | Embassy of the Republic of Korea | 02/28/1995 | 01/01/2000 | KOREA, SOUTH | Washington | DC | |||
| 6462 | 2469 | 10/23/1973 | Burson-Marsteller | Embassy of the Republic of Korea | 06/17/1993 | 11/24/1993 | KOREA, SOUTH | Washington, DC | ||||
| 7126 | 3320 | 01/05/1982 | Washington International Group, Inc. | Embassy of the Republic of Korea | 02/05/1992 | 03/03/1995 | KOREA, SOUTH | Washington | DC | |||
| 8243 | 4292 | 09/14/1989 | Tucker & Associates | Embassy of the Republic of Korea | 09/27/1989 | 10/19/1989 | KOREA, SOUTH | Washington | DC | |||
| 9123 | 3957 | 04/07/1987 | Colby, William E. | Embassy of the Republic of Korea | 11/09/1987 | 09/25/1987 | KOREA, SOUTH | Washington | DC | |||
| 11701 | 3097 | 04/01/1980 | Hess, Clyde Gardner | Embassy of the Republic of Korea | 04/01/1980 | 07/31/1988 | KOREA, SOUTH | |||||
| 12473 | 1678 | 01/03/1964 | Ragan & Mason | Embassy of the Republic of Korea | 03/01/1977 | 03/28/1977 | KOREA, SOUTH | Washington | DC | |||
| 14227 | 1900 | 06/09/1965 | Gilbert Jonas Company, Inc. | Embassy of the Republic of Korea | 06/09/1965 | 06/06/1967 | KOREA, SOUTH | Washington | DC | |||
| 9214 | 3489 | 06/24/1983 | Global U.S.A., Inc. | Embassy of the Republic of Korea (Commercial Section) | 09/02/1987 | 10/01/1987 | KOREA, SOUTH | Washington | DC | |||
| 4704 | 5480 | 03/04/2002 | Korea - U.S. Consulting, Inc. (KCI) | Embassy of the Republic of Korea (a U.S. treaty ally) | 03/04/2002 | 03/31/2006 | KOREA, SOUTH | 2450 Massachusetts Avenue, N.W. 20008 | DC | |||
| 497 | 6170 | 05/14/2013 | Mercury Public Affairs, LLC | Embassy of the Republic of Korea in the USA | 11/26/2024 | 07/01/2026 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 2472 | 6408 | 03/14/2017 | DiNino Associates, LLC | Embassy of the Republic of Korea through Cornerstone Government Affairs | 03/14/2017 | 02/28/2025 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 977 | 5483 | 03/06/2002 | QORVIS LLC | Embassy of the Republic of Korea to the United States | 10/13/2022 | 01/01/2025 | KOREA, SOUTH | 2450 Massachusetts Avenue NW | Washington | DC | 20008 | |
| 2537 | 6378 | 09/22/2016 | Prime Strategies, LLC | Embassy of the Republic of Korea to the United States | 09/22/2016 | 09/01/2017 | KOREA, SOUTH | 2320 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 3755 | 5432 | 05/18/2001 | Loeffler Group, LLP | Embassy of the Republic of Korea to the United States | 03/26/2008 | 09/30/2008 | KOREA, SOUTH | 2450 Massachusetts Avenue | Washington | DC | 20008 | |
| 12155 | 2542 | 10/24/1974 | Kearns International | Export-Import Bank of Korea | 05/17/1978 | 04/30/1979 | KOREA, SOUTH | Seoul | ||||
| 2680 | 6263 | 11/14/2014 | Prime Policy Group | Far East Lines Limited | 09/10/2015 | 08/06/2015 | KOREA, SOUTH | 27 Tesbury Centre, 28 Queen's Road | East Wan Chai | Hong Kong | ||
| 12633 | 2685 | 04/22/1976 | San Francisco Off. of Korea Institute of Machinery & Metals | Fine Instruments Center | 04/22/1976 | 05/30/1985 | KOREA, SOUTH | Seoul | ||||
| 1395 | 6367 | 08/10/2016 | West Wing Writers, LLC | Gang Province Won | 03/24/2021 | 04/30/2021 | KOREA, SOUTH | 1 Jangangro, Chuncheon S | Gangwon-do 200-700 | |||
| 3824 | 3975 | 05/08/1987 | Steptoe & Johnson, L.L.P. | Government of Korea, Embassy | 09/27/2007 | 05/31/2006 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 5445 | 3301 | 11/10/1981 | Hill and Knowlton Strategies, LLC | Government of Korea, Embassy | 04/25/1997 | 05/31/1997 | KOREA, SOUTH | Washington | DC | |||
| 3081 | 2165 | 10/09/1969 | Squire Patton Boggs, LLP | Government of South Korea | 11/20/2012 | 06/30/2014 | KOREA, SOUTH | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 9390 | 2836 | 10/12/1977 | North American Precis Syndicate | Government of South Korea | 05/01/1987 | 10/12/1987 | KOREA, SOUTH | NY |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE fara_foreign_principals (
rowid INTEGER PRIMARY KEY,
registration_number TEXT,
registrant_date TEXT,
registrant_name TEXT,
foreign_principal TEXT,
fp_registration_date TEXT,
fp_termination_date TEXT,
country TEXT,
address_1 TEXT,
address_2 TEXT,
city TEXT,
state TEXT,
zip TEXT
);
CREATE INDEX idx_fara_fp_reg ON fara_foreign_principals(registration_number);
CREATE INDEX idx_fara_fp_country ON fara_foreign_principals(country);
CREATE INDEX idx_fara_fp_principal ON fara_foreign_principals(foreign_principal);