FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
35 rows where "Short_Form_Date" is on date 1973-06-12
This data as json, CSV (advanced)
Registration_Number 13
- Chinese Information Service 13
- Package Express & Travel Agency, Inc. 8
- French Government Tourist Office 2
- KOTRA 2
- Indian Investment Centre 2
- Portuguese National Tourist Office 1
- Corporacion de Fomento de la Produccion 1
- Bermuda Tourism Authority 1
- Modern Education Services, Inc. 1
- Ruder & Finn of California, Inc. 1
- Ernest Wittenberg Association, Inc. 1
- Creative Food Service, Inc. 1
- German-American Chamber of Commerce of Pacific Coast, Inc. 1
Registrant_Name 13
- Chinese Information Service 13
- Package Express & Travel Agency, Inc. 8
- French Government Tourist Office 2
- Indian Investment Centre 2
- KOTRA 2
- Bermuda Tourism Authority 1
- Corporacion de Fomento de la Produccion 1
- Creative Food Service, Inc. 1
- Ernest Wittenberg Association, Inc. 1
- German-American Chamber of Commerce of Pacific Coast, Inc. 1
- Modern Education Services, Inc. 1
- Portuguese National Tourist Office 1
- Ruder & Finn of California, Inc. 1
City 4
- New York 31
- Washington 2
- Beverly Hills 1
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4262 | 4262 | 1985-01-22 | 1973-06-12 | Graffin | Cecile | French Government Tourist Office 364 | 1946-07-25 | French Government Tourist Office | 610 Fifth Avenue | New York | NY | 10020 | |
4263 | 4263 | 1985-01-22 | 1973-06-12 | Rothstein | Liliane Waksberg | French Government Tourist Office 364 | 1946-07-25 | French Government Tourist Office | 610 Fifth Avenue | New York | NY | 10020 | |
4807 | 4807 | 1979-01-30 | 1973-06-12 | Schur | Sylvia | Creative Food Service, Inc. 2432 | 1973-06-12 | Creative Food Service, Inc. | 210 East 39th Street | New York | NY | 10016 | |
4949 | 4949 | 1974-01-31 | 1973-06-12 | Castel-Branco | Antonio | Portuguese National Tourist Office 172 | 1943-01-23 | Portuguese National Tourist Office | 570 Fifth Avenue | New York | NY | 10036 | |
7926 | 7926 | 1986-02-28 | 1973-06-12 | Beem | Wendell Bruce | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
12414 | 12414 | 1974-04-01 | 1973-06-12 | Lin | Grace Chi | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
12415 | 12415 | 1974-04-01 | 1973-06-12 | Wu | York Lang | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
13001 | 13001 | 1985-04-09 | 1973-06-12 | Feigelson | Moses | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13002 | 13002 | 1985-04-09 | 1973-06-12 | Jozaitis | Anna | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13003 | 13003 | 1985-04-09 | 1973-06-12 | Lahoszniak | Wasyl | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13004 | 13004 | 1985-04-09 | 1973-06-12 | Podoba | Teodor | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13005 | 13005 | 1985-04-09 | 1973-06-12 | Samokish | Nina | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13006 | 13006 | 1985-04-09 | 1973-06-12 | Sharvan | Wasyl | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13007 | 13007 | 1985-04-09 | 1973-06-12 | Swan | Thomas | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
20898 | 20898 | 1975-06-30 | 1973-06-12 | Mehra | K.G. | Indian Investment Centre 2435 | 1973-06-12 | Indian Investment Centre | 445 Park Avenue | New York | NY | 10022 | |
20908 | 20908 | 1976-06-30 | 1973-06-12 | Lee | Tong Kyoon | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
20909 | 20909 | 1976-06-30 | 1973-06-12 | Oh | Chang Suk | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
20910 | 20910 | 1976-06-30 | 1973-06-12 | Telang | D.W. | Indian Investment Centre 2435 | 1973-06-12 | Indian Investment Centre | 445 Park Avenue | New York | NY | 10022 | |
23636 | 23636 | 1974-07-20 | 1973-06-12 | Eisenman | David | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
27917 | 27917 | 1976-08-31 | 1973-06-12 | Wang | Louis I.C. | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
30650 | 30650 | 1973-09-28 | 1973-06-12 | Rondell | Thomas | Ruder & Finn of California, Inc. 2284 | 1971-10-07 | Ruder & Finn of California, Inc. | 9300 Wilshire Boulevard | Beverly Hills | CA | 90212 | |
30919 | 30919 | 1977-09-30 | 1973-06-12 | Huang | Shu-Tsing Chu | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
34206 | 34206 | 1979-10-31 | 1973-06-12 | Lusk | Jack Edward | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | 1015 - 18th Street, N.W. | Suite 704 | Washington | DC | 20036 |
35358 | 35358 | 1973-11-07 | 1973-06-12 | Urrutia | Javier | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
35996 | 35996 | 1992-11-17 | 1973-06-12 | Heidenreich | Adam J. | German-American Chamber of Commerce of Pacific Coast, Inc. 2433 | 1973-06-12 | German-American Chamber of Commerce of Pacific Coast, Inc. | 465 California Street | San Francisco | CA | 94104 | |
36536 | 36536 | 1977-11-29 | 1973-06-12 | Posey | James Quinney | Ernest Wittenberg Association, Inc. 2339 | 1972-05-02 | Ernest Wittenberg Association, Inc. | 1616 H Street, N.W. | Washington | DC | 20006 | |
40037 | 40037 | 1977-12-31 | 1973-06-12 | Peng | Kuang-Tien | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40141 | 40141 | 1980-12-31 | 1973-06-12 | Chang | Chao-Ying | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40142 | 40142 | 1980-12-31 | 1973-06-12 | Chang | James Min-Chi | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40143 | 40143 | 1980-12-31 | 1973-06-12 | Chen | Tsong-Yao | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40144 | 40144 | 1980-12-31 | 1973-06-12 | Chiang | Te-Cheng | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40145 | 40145 | 1980-12-31 | 1973-06-12 | Chien | Amy | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40146 | 40146 | 1980-12-31 | 1973-06-12 | Loh | I-Cheng | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40147 | 40147 | 1980-12-31 | 1973-06-12 | Pien | Cheng Wei | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40148 | 40148 | 1980-12-31 | 1973-06-12 | Sui | Kuang-Hua | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 |
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]) );