FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where "Short_Form_Termination_Date" is on date 1988-11-30
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Registration_Date (date)
Registration_Number 15
- Braun & Company 5
- Colby, William E. 3
- Miller & Chevalier, Chartered 2
- Finnish Tourist Board, New York 1
- Austrian Trade Commissioner in the U.S., Chicago 1
- China Books & Periodicals, Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Korea Trade Center, Chicago 1
- Korea Trade Center, Dallas 1
- Anderson & Pendleton, C.A. 1
- White & Case, LLP 1
- Scottish Enterprise 1
- Oppenheimer, Wolff & Donnelly 1
- Saatchi & Saatchi North America, Inc. 1
- Rifkind, Pondel & Parsons 1
Registrant_Name 15
- Braun & Company 5
- Colby, William E. 3
- Miller & Chevalier, Chartered 2
- Anderson & Pendleton, C.A. 1
- Austrian Trade Commissioner in the U.S., Chicago 1
- China Books & Periodicals, Inc. 1
- Finnish Tourist Board, New York 1
- Korea Trade Center, Chicago 1
- Korea Trade Center, Dallas 1
- Oppenheimer, Wolff & Donnelly 1
- Rifkind, Pondel & Parsons 1
- Saatchi & Saatchi North America, Inc. 1
- Scottish Enterprise 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- White & Case, LLP 1
City 7
- Washington 7
- Los Angeles 6
- New York 4
- Chicago 2
- Cambridge 1
- Dallas 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36694 | 36694 | 1988-11-30 | 1987-01-12 | Shamwell | Horace F. , Jr. | Anderson & Pendleton, C.A. 2696 | 1976-06-09 | Anderson & Pendleton, C.A. | 1700 K Street, N.W. | Suite 1107 | Washington | DC | 20006 |
36695 | 36695 | 1988-11-30 | 1973-02-08 | Noyes | Harry H. | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
36696 | 36696 | 1988-11-30 | 1987-02-12 | Miller | William | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36697 | 36697 | 1988-11-30 | 1987-02-17 | Miller | Judy M. | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36698 | 36698 | 1988-11-30 | 1971-03-04 | Salayi | John C. | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
36699 | 36699 | 1988-11-30 | 1987-03-10 | Cohen | Laura | Colby, William E. 3957 | 1987-04-07 | Colby, William E. | 3028 Dent Place, N.W. | Washington | DC | 20007 | |
36700 | 36700 | 1988-11-30 | 1987-03-10 | Cohen | Richard | Colby, William E. 3957 | 1987-04-07 | Colby, William E. | 3028 Dent Place, N.W. | Washington | DC | 20007 | |
36701 | 36701 | 1988-11-30 | 1987-03-10 | London | Paul A. | Colby, William E. 3957 | 1987-04-07 | Colby, William E. | 3028 Dent Place, N.W. | Washington | DC | 20007 | |
36702 | 36702 | 1988-11-30 | 1987-04-15 | Song | Sung Soo | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
36703 | 36703 | 1988-11-30 | 1986-05-06 | Grimaldi | John P. | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36704 | 36704 | 1988-11-30 | 1986-05-06 | Harper | Jeff | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36705 | 36705 | 1988-11-30 | 1986-05-21 | Miller | Clifford A. | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36706 | 36706 | 1988-11-30 | 1984-06-04 | Lee | Jong Dae | Oppenheimer, Wolff & Donnelly 3485 | 1983-06-16 | Oppenheimer, Wolff & Donnelly | 1020 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 |
36707 | 36707 | 1988-11-30 | 1984-07-20 | Kurki | Yrjo Pekka | Finnish Tourist Board, New York 573 | 1949-05-31 | Finnish Tourist Board, New York | 655 Third Avenue | Suite 1810 | New York | NY | 10017-5617 |
36708 | 36708 | 1988-11-30 | 1986-08-28 | Landon | Barry | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
36709 | 36709 | 1988-11-30 | 1985-09-16 | Suh | Jung-Rak | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
36710 | 36710 | 1988-11-30 | 1986-09-19 | Curtiss | Catherine | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
36711 | 36711 | 1988-11-30 | 1984-09-27 | Seitinger | Heinz K. | Austrian Trade Commissioner in the U.S., Chicago 874 | 1955-02-21 | Austrian Trade Commissioner in the U.S., Chicago | 500 North Michigan Avenue | Suite 1950 | Chicago | IL | 60611 |
36712 | 36712 | 1988-11-30 | 1986-10-09 | Doyle | Margaret M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
36713 | 36713 | 1988-11-30 | 1986-10-10 | Turbitt | Ann Marie | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
36714 | 36714 | 1988-11-30 | 1984-10-31 | Bickwit | Leonard , Jr. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
36715 | 36715 | 1988-11-30 | 1985-12-10 | Heffernan | Garth James | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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]) );