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 = "Lo"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 8
Registrant_Name 8
City 6
- New York 4
- - 1
- Centerline 1
- Grayling 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7878 | 7878 | 1976-02-28 | 1973-02-22 | Lo | Francis Wing-Chan | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
11522 | 11522 | 1983-03-31 | 1980-01-21 | Lo | G. S. | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | 1511 K Street, N.W. | Suite 505 | Washington | DC | 20005 |
14389 | 14389 | 2020-04-29 | 2017-08-18 | Lo | Yat Fung | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
18626 | 18626 | 1971-06-02 | 1968-10-29 | Lo | Lorenzo | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
28484 | 28484 | 2006-08-31 | 2005-09-30 | Lo | Laurelle C. | Shearman & Sterling, LLP 5670 | 2005-02-25 | Shearman & Sterling, LLP | 599 Lexington Avenue | New York | NY | 10022-6069 | |
28851 | 28851 | 1987-09-01 | 1983-04-15 | Lo | Chong Va | Bee Moua 3311 | 1981-11-27 | Bee Moua | 301 James Street | Grayling | MI | 49738 | |
29555 | 29555 | 1957-09-11 | 1957-09-10 | Lo | Chu-Gi (Tsu-Yi) | Committee for Formosans' Free Formosa 1065 | 1957-09-10 | Committee for Formosans' Free Formosa | No address | PA | |||
35360 | 35360 | 1973-11-07 | 1946-11-26 | Lo | Jung-Pang | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
39192 | 39192 | 2004-12-27 | 2004-06-04 | Lo | Ker | Hmong Foreign Council 5554 | 2003-04-14 | Hmong Foreign Council | 6740 E. Ten Mile Road | Centerline | MI | 48015 |
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]) );