FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where "Short_Form_Date" is on date 1980-01-21
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2612 | 2612 | 1983-01-01 | 1980-01-21 | Yuan | John C. C. | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | 1511 K Street, N.W. | Suite 505 | Washington | DC | 20005 |
2784 | 2784 | 1999-01-01 | 1980-01-21 | Madden | Donald P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6223 | 6223 | 1981-02-06 | 1980-01-21 | Schmults | Edward C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6723 | 6723 | 1981-02-13 | 1980-01-21 | Kunz | Diane B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9156 | 9156 | 1980-03-05 | 1980-01-21 | Gillespie | Thomas E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10123 | 10123 | 1980-03-17 | 1980-01-21 | Berman | Helen A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
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 |
11523 | 11523 | 1983-03-31 | 1980-01-21 | Paradise | David T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12516 | 12516 | 2003-04-01 | 1980-01-21 | Huber | David L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14332 | 14332 | 1982-04-29 | 1980-01-21 | Tiedemann | Edwin W. | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
19534 | 19534 | 1984-06-15 | 1980-01-21 | Kearns | John J. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19746 | 19746 | 1983-06-17 | 1980-01-21 | Kennedy | Paul L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
20947 | 20947 | 1980-06-30 | 1980-01-21 | Pala | Gabriele | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
20991 | 20991 | 1983-06-30 | 1980-01-21 | Appert | Richard H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21348 | 21348 | 2000-06-30 | 1980-01-21 | Wales | Gwynne H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
22835 | 22835 | 1982-07-09 | 1980-01-21 | Lindsay | George P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
24069 | 24069 | 1982-07-26 | 1980-01-21 | Rouss | Ruth | Rouss & O'Rourke 2346 | 1972-09-18 | Rouss & O'Rourke | 1614 - 20th Street, N.W. | Washington | DC | 20009 | |
26591 | 26591 | 1981-08-14 | 1980-01-21 | McAnaney | Brian T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28059 | 28059 | 1983-08-31 | 1980-01-21 | Ismael | Bruce K. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29040 | 29040 | 2005-09-02 | 1980-01-21 | Dreizen | Alison M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32512 | 32512 | 1992-10-09 | 1980-01-21 | Epley | Marion J. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
36663 | 36663 | 1984-11-30 | 1980-01-21 | Giesecke | Karstan P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
37788 | 37788 | 1980-12-05 | 1980-01-21 | Meriam | Thomas C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40451 | 40451 | 1988-12-31 | 1980-01-21 | Hu | Tsu-Wang | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | 1511 K Street, N.W. | Suite 505 | Washington | DC | 20005 |
40770 | 40770 | 1994-12-31 | 1980-01-21 | McNally | John J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );