FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
33 rows where Short_Form_Last_Name = "Choi"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_2, Short_Form_Termination_Date (date)
Registration_Number 18
- KOTRA 12
- Korea National Tourism Organization, New Jersey 2
- Korea Trade Center, Los Angeles 2
- Korea Trade Center, Dallas 2
- KBS America, Inc. 2
- Korea National Tourism Organization, Los Angeles 1
- Korea Trade Center, San Francisco 1
- Korea International Trade Association, Inc. 1
- Korea Trade Center, Atlanta 1
- Korea Economic Institute 1
- Small Business Corporation - USA Office 1
- Daniel J. Edelman, Inc. 1
- Korea International Trade Association 1
- Daniel J. Edelman, Inc. 1
- Hyundai, Washington Office 1
- American International Consulting Group, Inc. 1
- Fleishman-Hillard, Inc. 1
- Ogilvy Public Relations Worldwide 1
Registrant_Name 17
- KOTRA 12
- Daniel J. Edelman, Inc. 2
- KBS America, Inc. 2
- Korea National Tourism Organization, New Jersey 2
- Korea Trade Center, Dallas 2
- Korea Trade Center, Los Angeles 2
- American International Consulting Group, Inc. 1
- Fleishman-Hillard, Inc. 1
- Hyundai, Washington Office 1
- Korea Economic Institute 1
- Korea International Trade Association 1
- Korea International Trade Association, Inc. 1
- Korea National Tourism Organization, Los Angeles 1
- Korea Trade Center, Atlanta 1
- Korea Trade Center, San Francisco 1
- Ogilvy Public Relations Worldwide 1
- Small Business Corporation - USA Office 1
City 11
- New York 14
- Los Angeles 5
- Washington 4
- Dallas 2
- Fort Lee 2
- Chicago 1
- Englewood Cliffs 1
- Marietta 1
- Saint Petersburg 1
- San Francisco 1
- St. Louis 1
Link | rowid ▼ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2205 | 2205 | 2022-11-21 | Choi | Haeri | Korea National Tourism Organization, New Jersey 2614 | 1975-10-04 | Korea National Tourism Organization, New Jersey | 400 Kelby Street | Suite 1602 | Fort Lee | NJ | 07024 | |
2291 | 2291 | 2018-11-30 | Choi | Bosung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 | |
4113 | 4113 | 2010-01-19 | 2006-05-09 | Choi | Hyun Soo | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
5249 | 5249 | 2001-01-31 | 1997-11-05 | Choi | Sung Phil | Small Business Corporation - USA Office 3477 | 1983-05-25 | Small Business Corporation - USA Office | 120 Sylvan Avenue | Suite 301 | Englewood Cliffs | NJ | 07632 |
6081 | 6081 | 2012-02-03 | 2009-11-30 | Choi | Kwang Soo | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
6648 | 6648 | 1987-02-12 | 1985-01-31 | Choi | Kyu Jae | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
8292 | 8292 | 2015-02-28 | 2013-06-25 | Choi | Sung Won | KBS America, Inc. 5684 | 2005-05-17 | KBS America, Inc. | 625 South Kingsley Drive | 4th Floor | Los Angeles | CA | 90005 |
9858 | 9858 | 2018-03-14 | 2018-03-14 | Choi | Michelle | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
10200 | 10200 | 1979-03-18 | 1976-12-09 | Choi | Yoon Hong | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
12427 | 12427 | 1979-04-01 | 1977-03-14 | Choi | Hong Sik | Korea Trade Center, Atlanta 2760 | 1977-03-14 | Korea Trade Center, Atlanta | 2161 Newmarket Parkway | Suite 222 | Marietta | GA | 30067 |
13113 | 13113 | 2013-04-10 | 2012-06-29 | Choi | Mina | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
13401 | 13401 | 1985-04-15 | 1982-05-28 | Choi | Jung Nam | Korea International Trade Association, Inc. 2686 | 1976-04-23 | Korea International Trade Association, Inc. | 460 Park Avenue | Suite 400 | New York | NY | 10022 |
14144 | 14144 | 1995-04-26 | 1992-05-29 | Choi | Yong Tai | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
14549 | 14549 | 1985-04-30 | 1983-02-07 | Choi | Yong Do | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
14681 | 14681 | 1995-04-30 | 1991-08-08 | Choi | Sang-Chae | Korea International Trade Association 3636 | 1984-12-21 | Korea International Trade Association | 1800 K Street, N.W. | Suite 700 | Washington | DC | 20006 |
15548 | 15548 | 2022-05-01 | 2017-05-26 | Choi | Jinsung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
17758 | 17758 | 1992-05-31 | 1988-02-02 | Choi | Dong Sik | Hyundai, Washington Office 4088 | 1988-02-02 | Hyundai, Washington Office | 1850 M Street, N.W. | Suite 840 | Washington | DC | 20036 |
18550 | 18550 | 2011-06-01 | 2009-06-30 | Choi | Chun Ai | KBS America, Inc. 5684 | 2005-05-17 | KBS America, Inc. | 625 South Kingsley Drive | 4th Floor | Los Angeles | CA | 90005 |
21296 | 21296 | 1998-06-30 | 1996-04-22 | Choi | Dal-Lyong | Korea National Tourism Organization, New Jersey 2614 | 1975-10-04 | Korea National Tourism Organization, New Jersey | 400 Kelby Street | Suite 1602 | Fort Lee | NJ | 07024 |
22161 | 22161 | 1985-07-01 | 1977-10-20 | Choi | Duk Hee | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
23379 | 23379 | 1996-07-16 | 1997-02-25 | Choi | Kwang-Soo | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
24217 | 24217 | 1995-07-27 | 1993-07-27 | Choi | Jae-Il | Korea National Tourism Organization, Los Angeles 2544 | 1974-10-25 | Korea National Tourism Organization, Los Angeles | 5509 Wilshire Boulevard | Suite 201 | Los Angeles | CA | 90036 |
24231 | 24231 | 2010-07-27 | 2007-11-30 | Choi | Jangsung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25054 | 25054 | 2004-07-31 | 2000-12-06 | Choi | Yun Gyu | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25207 | 25207 | 2014-07-31 | 2012-03-09 | Choi | Michelle | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25253 | 25253 | 2014-07-31 | 2012-11-28 | Choi | Byunghun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25285 | 25285 | 2016-07-31 | 2012-05-29 | Choi | Myunglae | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
27154 | 27154 | 2003-08-21 | 2003-05-27 | Choi | Michelle | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
28254 | 28254 | 1994-08-31 | 1994-08-08 | Choi | Mike | American International Consulting Group, Inc. 4939 | 1994-08-08 | American International Consulting Group, Inc. | 10033 9th Street N #300 | Saint Petersburg | FL | 33716-3804 | |
31190 | 31190 | 1998-09-30 | 1998-02-20 | Choi | Kwang-Soo | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
33207 | 33207 | 1994-10-19 | 1991-12-06 | Choi | Dong Suk | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
36495 | 36495 | 2015-11-27 | 2011-11-28 | Choi | Inyoung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
41515 | 41515 | 2006-12-31 | 2005-09-26 | Choi | David Lee | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );