FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Last_Name = "Song"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 10
Registrant_Name 10
City 6
- Chicago 3
- Los Angeles 3
- New York 3
- Washington 2
- Dallas 1
- Englewood Cliffs 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6536 | 6536 | 1989-02-10 | 1986-04-03 | Song | Jhang Gil | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
11620 | 11620 | 1990-03-31 | 1988-02-19 | Song | Dae-Kyun | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
12433 | 12433 | 1982-04-01 | 1979-08-24 | Song | Moo Cho | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
24037 | 24037 | 2009-07-25 | 2005-12-01 | Song | Yoo-Hwang | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
24399 | 24399 | 2012-07-29 | 2009-11-30 | Song | Byungok | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25140 | 25140 | 2008-07-31 | 2005-12-28 | Song | Jung Hye | Small Business Corporation - USA Office 3477 | 1983-05-25 | Small Business Corporation - USA Office | 120 Sylvan Avenue | Suite 301 | Englewood Cliffs | NJ | 07632 |
30917 | 30917 | 1976-09-30 | 1975-12-31 | Song | Byung Hee | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
31125 | 31125 | 1995-09-30 | 1993-05-19 | Song | Dong-Kyu | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
31170 | 31170 | 1997-09-30 | 1995-08-28 | Song | Hwa Jin | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
33818 | 33818 | 1943-10-29 | 1943-10-29 | Song | H.Y. | Min Joong Dai Hoi 219 | 1943-10-29 | Min Joong Dai Hoi | 1415 West 37th Street | Los Angeles | CA | ||
36702 | 36702 | 1988-11-30 | 1987-04-15 | Song | Sung Soo | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
38571 | 38571 | 2004-12-17 | 2003-08-06 | Song | David | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
39704 | 39704 | 1961-12-31 | 1961-03-01 | Song | Willie | Korean Research & Information Office 761 | 1953-03-18 | Korean Research & Information Office | 1828 Jefferson Place, N.W. | Washington | DC |
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]) );