FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where "Short_Form_Date" is on date 1992-08-06
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_1, Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6242 | 6242 | 1995-02-06 | 1992-08-06 | Nishio | Akemi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
7716 | 7716 | 1993-02-26 | 1992-08-06 | Black | Joseph A. | Sandler, Travis & Rosenberg, P.A. 4698 | 1992-07-31 | Sandler, Travis & Rosenberg, P.A. | 5200 Blue Lagoon Drive | Suite 600 | Miami | FL | 33126-2022 |
7717 | 7717 | 1993-02-26 | 1992-08-06 | Gerdes | Ronald W. | Sandler, Travis & Rosenberg, P.A. 4698 | 1992-07-31 | Sandler, Travis & Rosenberg, P.A. | 5200 Blue Lagoon Drive | Suite 600 | Miami | FL | 33126-2022 |
7718 | 7718 | 1993-02-26 | 1992-08-06 | Houston | William H. , III | Sandler, Travis & Rosenberg, P.A. 4698 | 1992-07-31 | Sandler, Travis & Rosenberg, P.A. | 5200 Blue Lagoon Drive | Suite 600 | Miami | FL | 33126-2022 |
7719 | 7719 | 1993-02-26 | 1992-08-06 | Lewis | John | Sandler, Travis & Rosenberg, P.A. 4698 | 1992-07-31 | Sandler, Travis & Rosenberg, P.A. | 5200 Blue Lagoon Drive | Suite 600 | Miami | FL | 33126-2022 |
7720 | 7720 | 1993-02-26 | 1992-08-06 | Weinberg | Diane L. | Sandler, Travis & Rosenberg, P.A. 4698 | 1992-07-31 | Sandler, Travis & Rosenberg, P.A. | 5200 Blue Lagoon Drive | Suite 600 | Miami | FL | 33126-2022 |
10697 | 10697 | 1996-03-24 | 1992-08-06 | Moriai | Mineo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11772 | 11772 | 1997-03-31 | 1992-08-06 | Houston | William H. , III | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | 1300 Pennsylvania Ave., N.W. | Suite 400 | Washington | DC | 20004 |
17040 | 17040 | 1994-05-24 | 1992-08-06 | Mosher | Anne Liese C. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
19439 | 19439 | 1995-06-14 | 1992-08-06 | Bando | Kazuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20179 | 20179 | 1995-06-24 | 1992-08-06 | Tamura | Yoshimasa | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20180 | 20180 | 1995-06-24 | 1992-08-06 | Torika | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20230 | 20230 | 1995-06-25 | 1992-08-06 | Suzuki | Yoshinori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21273 | 21273 | 1997-06-30 | 1992-08-06 | Tsukamoto | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22471 | 22471 | 1996-07-02 | 1992-08-06 | Powell | Richard C. , Jr. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
28232 | 28232 | 1993-08-31 | 1992-08-06 | Lewis | John | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | 1300 Pennsylvania Ave., N.W. | Suite 400 | Washington | DC | 20004 |
28348 | 28348 | 1999-08-31 | 1992-08-06 | Gerdes | Ronald W. | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | 1300 Pennsylvania Ave., N.W. | Suite 400 | Washington | DC | 20004 |
28349 | 28349 | 1999-08-31 | 1992-08-06 | Navarro-Bowman | Chandri | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | 1300 Pennsylvania Ave., N.W. | Suite 400 | Washington | DC | 20004 |
28350 | 28350 | 1999-08-31 | 1992-08-06 | Travis | Thomas G. | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | 1300 Pennsylvania Ave., N.W. | Suite 400 | Washington | DC | 20004 |
29111 | 29111 | 1992-09-03 | 1992-08-06 | Travis | Thomas G. | Sandler, Travis & Rosenberg, P.A. 4698 | 1992-07-31 | Sandler, Travis & Rosenberg, P.A. | 5200 Blue Lagoon Drive | Suite 600 | Miami | FL | 33126-2022 |
36322 | 36322 | 1993-11-24 | 1992-08-06 | Andelman | David A. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 |
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]) );