FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_Last_Name = "Hwang"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 6
Registrant_Name 6
City 5
- New York 5
- Chicago 3
- Los Angeles 2
- Fort Lee 1
- Seattle 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1309 | 1309 | 2022-06-28 | Hwang | Sukjin | Korea SMEs and Startups Agency USA Office 6195 | 2013-11-18 | Korea SMEs and Startups Agency USA Office | 1730 Minor Avenue | 10th Floor - Suite 1050 | Seattle | WA | 98101 | |
3533 | 3533 | 2003-01-10 | 2001-01-10 | Hwang | Ho Yoon | Korea Local Government Center (KLAFIR, America) 5080 | 1995-11-24 | Korea Local Government Center (KLAFIR, America) | 150 East 58th Street | 14th Floor | New York | NY | 10155-0002 |
3631 | 3631 | 2007-01-12 | 2006-11-27 | Hwang | Min Ha | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
5332 | 5332 | 2005-01-31 | 2001-05-17 | Hwang | Eui Shun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
11561 | 11561 | 1987-03-31 | 1985-04-10 | Hwang | Minha | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
11766 | 11766 | 1997-03-31 | 1995-04-26 | Hwang | Gyu Joon | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
13322 | 13322 | 1989-04-14 | 1987-07-06 | Hwang | Kee Hank | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
16749 | 16749 | 1981-05-20 | 1981-02-24 | Hwang | Hwa-Sook | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
25293 | 25293 | 2016-07-31 | 2014-11-25 | Hwang | Pilgoo | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
27791 | 27791 | 2000-08-30 | 1997-06-24 | Hwang | Yong Ku | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
28446 | 28446 | 2005-08-31 | 2003-11-04 | Hwang | Yong Ku | 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 |
41310 | 41310 | 2003-12-31 | 2001-05-30 | Hwang | Kee-Hak | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
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]) );