FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "Yu"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 10
- KOTRA 1
- Singapore Economic Development Board 1
- Far East Trade Service, Inc., Chicago 1
- Far East Trade Service, Inc., Dallas Branch Office 1
- Daniel J. Edelman, Inc. 1
- Daniel J. Edelman, Inc. 1
- Crowell & Moring International, LLC 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Commonwealth of Dominica Maritime Registry, Inc. 1
- KBS America, Inc. 1
Registrant_Name 9
- Daniel J. Edelman, Inc. 2
- Commonwealth of Dominica Maritime Registry, Inc. 1
- Crowell & Moring International, LLC 1
- Far East Trade Service, Inc., Chicago 1
- Far East Trade Service, Inc., Dallas Branch Office 1
- KBS America, Inc. 1
- KOTRA 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Singapore Economic Development Board 1
City 6
- New York 4
- Chicago 2
- Dallas 1
- Fairhaven 1
- Los Angeles 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2227 | 2227 | 2005-11-25 | Yu | Zhang Chao | Commonwealth of Dominica Maritime Registry, Inc. 5334 | 1999-10-12 | Commonwealth of Dominica Maritime Registry, Inc. | 32 Washington Street | Fairhaven | MA | 02719 | ||
2388 | 2388 | 2013-12-13 | Yu | Evan Tzyy-yih | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 | |
5257 | 5257 | 2002-01-31 | 1999-02-26 | Yu | Tong | Paul, Weiss, Rifkind, Wharton & Garrison 4539 | 1991-07-09 | Paul, Weiss, Rifkind, Wharton & Garrison | 1285 Avenue of the Americas | New York | NY | 10019-6064 | |
5495 | 5495 | 2015-01-31 | 2012-09-17 | Yu | Hui Min Karen | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
8734 | 8734 | 1980-03-01 | 1978-06-08 | Yu | Charles | Far East Trade Service, Inc., Chicago 2911 | 1978-06-08 | Far East Trade Service, Inc., Chicago | 225 North Michigan Avenue | Suite 1888 | Chicago | IL | 60601 |
25008 | 25008 | 2002-07-31 | 2001-10-01 | Yu | Sue-Jung | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
25340 | 25340 | 2018-07-31 | 2015-11-30 | Yu | Byoungwoo | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
31622 | 31622 | 2017-09-30 | 2015-12-24 | Yu | Konshik | KBS America, Inc. 5684 | 2005-05-17 | KBS America, Inc. | 625 South Kingsley Drive | 4th Floor | Los Angeles | CA | 90005 |
37161 | 37161 | 2020-11-30 | 2020-09-14 | Yu | Andrea | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
40236 | 40236 | 1982-12-31 | 1980-08-19 | Yu | Charles T. C. | Far East Trade Service, Inc., Dallas Branch Office 2971 | 1978-10-19 | Far East Trade Service, Inc., Dallas Branch Office | 2050 Stemmons Freeway | W.T.C. 110, P.O. Box 58007 | Dallas | TX | 75258 |
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]) );