FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where "Short_Form_Termination_Date" is on date 1995-03-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Zip
Short_Form_Date (date) 24 ✖
- 1994-10-20 4
- 1990-12-12 2
- 1993-10-07 2
- 1977-06-24 1
- 1988-08-17 1
- 1990-02-02 1
- 1990-05-29 1
- 1990-12-19 1
- 1991-05-14 1
- 1992-01-30 1
- 1992-02-10 1
- 1992-02-21 1
- 1992-03-10 1
- 1992-04-09 1
- 1992-06-17 1
- 1992-08-31 1
- 1993-01-19 1
- 1993-03-03 1
- 1993-06-14 1
- 1993-07-21 1
- 1993-08-30 1
- 1994-02-09 1
- 1994-02-16 1
- 1995-03-01 1
Registration_Number 19
- Williams & Jensen, P.C. 6
- Walker/Potter Associates, Inc. 3
- German-American Chamber of Commerce of Chicago 2
- White & Case, LLP 2
- Lloyd's of London Market Representatives 2
- Quebec Government Office 1
- JETRO, Chicago 1
- British Columbia Government 1
- Japan National Tourist Organization, Dallas 1
- Australian Meat & Livestock Corporation 1
- St. Lucia National Development Corporation 1
- Alsace Development International, Inc. 1
- Black, Kelly, Scruggs & Healey 1
- Korea International Trade Association 1
- JETRO, Atlanta 1
- Tourism Authority of Thailand, Chicago 1
- Korn, David A. 1
- Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. 1
- Japan Center for Intercultural Communications (JCIC) 1
Registrant_Name 19
- Williams & Jensen, P.C. 6
- Walker/Potter Associates, Inc. 3
- German-American Chamber of Commerce of Chicago 2
- Lloyd's of London Market Representatives 2
- White & Case, LLP 2
- Alsace Development International, Inc. 1
- Australian Meat & Livestock Corporation 1
- Black, Kelly, Scruggs & Healey 1
- British Columbia Government 1
- Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. 1
- JETRO, Atlanta 1
- JETRO, Chicago 1
- Japan Center for Intercultural Communications (JCIC) 1
- Japan National Tourist Organization, Dallas 1
- Korea International Trade Association 1
- Korn, David A. 1
- Quebec Government Office 1
- St. Lucia National Development Corporation 1
- Tourism Authority of Thailand, Chicago 1
City 9
- Washington 13
- New York 5
- Chicago 4
- London 2
- 68000 Colmar 1
- Atlanta 1
- Dallas 1
- Seattle 1
- Tokyo, 102-0093 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11707 | 11707 | 1995-03-31 | 1993-01-19 | Koide | Junji | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
11708 | 11708 | 1995-03-31 | 1992-01-30 | McNamara | Susan | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
11709 | 11709 | 1995-03-31 | 1990-02-02 | Suzuki | Seiichi | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
11710 | 11710 | 1995-03-31 | 1994-02-09 | Hall | Stephen Hargreaves | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
11711 | 11711 | 1995-03-31 | 1992-02-10 | Marlowe | Dennis | Australian Meat & Livestock Corporation 2611 | 1975-09-29 | Australian Meat & Livestock Corporation | 750 Lexington Avenue | 17th Floor | New York | NY | 10022 |
11712 | 11712 | 1995-03-31 | 1994-02-16 | Mallinson | John Russell | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
11713 | 11713 | 1995-03-31 | 1992-02-21 | Ohnmee | Charun | Tourism Authority of Thailand, Chicago 4622 | 1992-02-21 | Tourism Authority of Thailand, Chicago | 303 East Wacker Drive | Suite 400 | Chicago | IL | 60601 |
11714 | 11714 | 1995-03-31 | 1995-03-01 | Araki | Taizan | Japan Center for Intercultural Communications (JCIC) 4998 | 1995-03-01 | Japan Center for Intercultural Communications (JCIC) | 2-7-7 Hirakawa-cho | Chiyoda-ku | Tokyo, 102-0093 | ||
11715 | 11715 | 1995-03-31 | 1993-03-03 | Korn | David A. | Korn, David A. 4773 | 1993-03-03 | Korn, David A. | 3601 Connecticut Avenue, N.W. | Suite 210 | Washington | DC | 20008 |
11716 | 11716 | 1995-03-31 | 1992-03-10 | Suzuki | Minoru | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11717 | 11717 | 1995-03-31 | 1992-04-09 | Lee | Patricia Y. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11718 | 11718 | 1995-03-31 | 1991-05-14 | Hemmer | Michael William | German-American Chamber of Commerce of Chicago 1878 | 1965-04-06 | German-American Chamber of Commerce of Chicago | 104 South Michigan Avenue | Suite 600 | Chicago | IL | 606035978 |
11719 | 11719 | 1995-03-31 | 1990-05-29 | MacLean | Peter James | British Columbia Government 2084 | 1968-03-27 | British Columbia Government | 720 Olive Way | Suite 1020 | Seattle | WA | 98101 |
11720 | 11720 | 1995-03-31 | 1993-06-14 | Gale | Michael R. | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. 4817 | 1993-06-14 | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. | 1300 Connecticut Avenue, N.W. | Suite 1000 | Washington | DC | 20036 |
11721 | 11721 | 1995-03-31 | 1992-06-17 | Gastinel | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11722 | 11722 | 1995-03-31 | 1977-06-24 | Sylvester | Patrick J.M. | St. Lucia National Development Corporation 2796 | 1977-06-24 | St. Lucia National Development Corporation | 800 2nd Avenue | Suite 910 | New York | NY | 10017-4709 |
11723 | 11723 | 1995-03-31 | 1993-07-21 | Tracey | Evan | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
11724 | 11724 | 1995-03-31 | 1988-08-17 | Flatzek | Peter J. | German-American Chamber of Commerce of Chicago 1878 | 1965-04-06 | German-American Chamber of Commerce of Chicago | 104 South Michigan Avenue | Suite 600 | Chicago | IL | 606035978 |
11725 | 11725 | 1995-03-31 | 1993-08-30 | Murphy | Doris Elaine | Alsace Development International, Inc. 3506 | 1983-08-10 | Alsace Development International, Inc. | Chateau Kiener - 24 rue de Verdum | 68000 Colmar | |||
11726 | 11726 | 1995-03-31 | 1992-08-31 | Kim | Hyong Chun | Korea International Trade Association 3636 | 1984-12-21 | Korea International Trade Association | 1800 K Street, N.W. | Suite 700 | Washington | DC | 20006 |
11727 | 11727 | 1995-03-31 | 1993-10-07 | Hart | J. Steven | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11728 | 11728 | 1995-03-31 | 1993-10-07 | Starr | David Allen | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11729 | 11729 | 1995-03-31 | 1994-10-20 | Franasiak | David E. | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11730 | 11730 | 1995-03-31 | 1994-10-20 | Glennon | Robert E. | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11731 | 11731 | 1995-03-31 | 1994-10-20 | Pharaoh | Jennifer L. | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11732 | 11732 | 1995-03-31 | 1994-10-20 | Roda | Anthony J. | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11733 | 11733 | 1995-03-31 | 1990-12-12 | Fuller | Lee O. | Walker/Potter Associates, Inc. 4446 | 1990-12-12 | Walker/Potter Associates, Inc. | 1730 Pennsylvania Avenue, N.W. | Suite 200 | Washington | DC | 20006 |
11734 | 11734 | 1995-03-31 | 1990-12-12 | Smith | James E. | Walker/Potter Associates, Inc. 4446 | 1990-12-12 | Walker/Potter Associates, Inc. | 1730 Pennsylvania Avenue, N.W. | Suite 200 | Washington | DC | 20006 |
11735 | 11735 | 1995-03-31 | 1990-12-19 | Free | James C. | Walker/Potter Associates, Inc. 4446 | 1990-12-12 | Walker/Potter Associates, Inc. | 1730 Pennsylvania Avenue, N.W. | Suite 200 | Washington | DC | 20006 |
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]) );