FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Short_Form_Last_Name = "Min"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Date (date)
Registration_Number 6
Registrant_Name 6
City 5
- Fort Lee 3
- Chicago 2
- New York 2
- Honolulu 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2277 | 2277 | 2021-11-29 | Min | Keunggi | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 | |
5353 | 5353 | 2006-01-31 | 2003-05-16 | Min | Kyun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
11767 | 11767 | 1997-03-31 | 1994-06-23 | Min | Byungho | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
14192 | 14192 | 1988-04-27 | 1988-02-19 | Min | Kyun | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
16921 | 16921 | 1947-05-23 | 1944-05-23 | Min | Chan Ho | Korean National Revolutionary Party, Hawaii 254 | 1944-05-23 | Korean National Revolutionary Party, Hawaii | 1269 South Beretania Street | Honolulu | HI | ||
19864 | 19864 | 1991-06-19 | 1988-07-28 | Min | Kyoung-Sun | Korea International Trade Association 3636 | 1984-12-21 | Korea International Trade Association | 1800 K Street, N.W. | Suite 700 | Washington | DC | 20006 |
21699 | 21699 | 2012-06-30 | 2009-05-26 | Min | Min Hong | 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 |
23383 | 23383 | 1996-07-16 | 1993-11-04 | Min | Min-Hong | 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 |
29143 | 29143 | 1979-09-04 | 1975-10-01 | Min | Young Duck | 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 |
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]) );