FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
33 rows where "Short_Form_Termination_Date" is on date 1997-09-30
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_2, Zip, Short_Form_Date (date)
Registration_Number 16
- Abernathy/MacGregor Group, Inc. 6
- GlobeQuest, Ltd. 5
- Nabo Traders, Inc. 5
- Decision Management, Inc. 3
- Hakuhodo, Inc. 3
- Ruder Finn, Inc. 1
- KOTRA 1
- Singapore Economic Development Board 1
- Hong Kong Tourism Board 1
- Mexico Tourism Board 1
- Far East Trade Service, Inc., Chicago 1
- Korea Economic Institute 1
- Representative of German Industry and Trade 1
- Capitoline/MS&L 1
- APCO Worldwide, Inc. 1
- Witeck-Combs Communications 1
Registrant_Name 16
- Abernathy/MacGregor Group, Inc. 6
- GlobeQuest, Ltd. 5
- Nabo Traders, Inc. 5
- Decision Management, Inc. 3
- Hakuhodo, Inc. 3
- APCO Worldwide, Inc. 1
- Capitoline/MS&L 1
- Far East Trade Service, Inc., Chicago 1
- Hong Kong Tourism Board 1
- KOTRA 1
- Korea Economic Institute 1
- Mexico Tourism Board 1
- Representative of German Industry and Trade 1
- Ruder Finn, Inc. 1
- Singapore Economic Development Board 1
- Witeck-Combs Communications 1
City 8
- New York 9
- Annandale 5
- Arlington 5
- Washington 5
- McLean 3
- Tokyo 3
- Chicago 2
- Los Angeles 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31155 | 31155 | 1997-09-30 | 1987-01-05 | Kaplan | Erica | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
31156 | 31156 | 1997-09-30 | 1996-02-29 | MacKay | Gordon D. | Capitoline/MS&L 4529 | 1991-06-20 | Capitoline/MS&L | 1615 L Street, N.W. | Suite 1150 | Washington | DC | 20036 |
31157 | 31157 | 1997-09-30 | 1993-03-02 | Brenner | Rolf M. | Representative of German Industry and Trade 4274 | 1989-07-21 | Representative of German Industry and Trade | 1130 Connecticut Avenue, NW | Suite 1200 | Washington | DC | 20036 |
31158 | 31158 | 1997-09-30 | 1995-03-03 | Burger | George B. | Decision Management, Inc. 4999 | 1995-03-03 | Decision Management, Inc. | 2010 Corporate Ridge | 7th Floor | McLean | VA | 22102 |
31159 | 31159 | 1997-09-30 | 1995-03-03 | Lunde | Brian A. | Decision Management, Inc. 4999 | 1995-03-03 | Decision Management, Inc. | 2010 Corporate Ridge | 7th Floor | McLean | VA | 22102 |
31160 | 31160 | 1997-09-30 | 1997-03-12 | Suzuki | Asao | Hakuhodo, Inc. 5163 | 1997-03-12 | Hakuhodo, Inc. | 3-4-1 Shibaura | Minato-ku | Tokyo | ||
31161 | 31161 | 1997-09-30 | 1997-03-12 | Umeda | Kazuhiko | Hakuhodo, Inc. 5163 | 1997-03-12 | Hakuhodo, Inc. | 3-4-1 Shibaura | Minato-ku | Tokyo | ||
31162 | 31162 | 1997-09-30 | 1997-03-12 | Watanabe | Kei | Hakuhodo, Inc. 5163 | 1997-03-12 | Hakuhodo, Inc. | 3-4-1 Shibaura | Minato-ku | Tokyo | ||
31163 | 31163 | 1997-09-30 | 1996-03-29 | Cobb | Cindy | GlobeQuest, Ltd. 5103 | 1996-03-29 | GlobeQuest, Ltd. | 7010 Little River Turnpike | Suite 250 | Annandale | VA | 22003 |
31164 | 31164 | 1997-09-30 | 1996-03-29 | Corneil | Terry | GlobeQuest, Ltd. 5103 | 1996-03-29 | GlobeQuest, Ltd. | 7010 Little River Turnpike | Suite 250 | Annandale | VA | 22003 |
31165 | 31165 | 1997-09-30 | 1996-03-29 | Harvey | Thomas | GlobeQuest, Ltd. 5103 | 1996-03-29 | GlobeQuest, Ltd. | 7010 Little River Turnpike | Suite 250 | Annandale | VA | 22003 |
31166 | 31166 | 1997-09-30 | 1996-03-29 | Jones | Jennifer | GlobeQuest, Ltd. 5103 | 1996-03-29 | GlobeQuest, Ltd. | 7010 Little River Turnpike | Suite 250 | Annandale | VA | 22003 |
31167 | 31167 | 1997-09-30 | 1996-03-29 | Jordan | Joelle | GlobeQuest, Ltd. 5103 | 1996-03-29 | GlobeQuest, Ltd. | 7010 Little River Turnpike | Suite 250 | Annandale | VA | 22003 |
31168 | 31168 | 1997-09-30 | 1993-06-09 | Fogarty | Moira | Far East Trade Service, Inc., Chicago 2911 | 1978-06-08 | Far East Trade Service, Inc., Chicago | 225 North Michigan Avenue | Suite 1888 | Chicago | IL | 60601 |
31169 | 31169 | 1997-09-30 | 1996-08-09 | Millard | Cara | Decision Management, Inc. 4999 | 1995-03-03 | Decision Management, Inc. | 2010 Corporate Ridge | 7th Floor | McLean | VA | 22102 |
31170 | 31170 | 1997-09-30 | 1995-08-28 | Song | Hwa Jin | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
31171 | 31171 | 1997-09-30 | 1980-09-01 | Sanchez-Navarro | Jose Luis | Mexico Tourism Board 2448 | 1973-08-09 | Mexico Tourism Board | 225 North Michigan Avenue | Suite 1850 | Chicago | IL | 60601-3715 |
31172 | 31172 | 1997-09-30 | 1982-09-13 | Russell | James F. | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
31173 | 31173 | 1997-09-30 | 1995-09-18 | Khuan | Lee Soon | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
31174 | 31174 | 1997-09-30 | 1997-09-23 | Bryant | Jay | Nabo Traders, Inc. 5212 | 1997-09-23 | Nabo Traders, Inc. | 1800 North Kent Street | Suite 907 | Arlington | VA | 22209 |
31175 | 31175 | 1997-09-30 | 1997-09-23 | Bryant | Susan B. | Nabo Traders, Inc. 5212 | 1997-09-23 | Nabo Traders, Inc. | 1800 North Kent Street | Suite 907 | Arlington | VA | 22209 |
31176 | 31176 | 1997-09-30 | 1997-09-23 | Hudgins | William C. | Nabo Traders, Inc. 5212 | 1997-09-23 | Nabo Traders, Inc. | 1800 North Kent Street | Suite 907 | Arlington | VA | 22209 |
31177 | 31177 | 1997-09-30 | 1997-09-23 | Taylor | Robert W. | Nabo Traders, Inc. 5212 | 1997-09-23 | Nabo Traders, Inc. | 1800 North Kent Street | Suite 907 | Arlington | VA | 22209 |
31178 | 31178 | 1997-09-30 | 1997-09-30 | Olson | David N. | Nabo Traders, Inc. 5212 | 1997-09-23 | Nabo Traders, Inc. | 1800 North Kent Street | Suite 907 | Arlington | VA | 22209 |
31179 | 31179 | 1997-09-30 | 1995-10-12 | Witeck | Robert V. | Witeck-Combs Communications 5058 | 1995-10-12 | Witeck-Combs Communications | 1101 - 14th Street, N.W. | Suite 1210 | Washington | DC | 20005 |
31180 | 31180 | 1997-09-30 | 1994-10-17 | Lee | Kang Man | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
31181 | 31181 | 1997-09-30 | 1994-10-21 | Habeeb | William Mark | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
31182 | 31182 | 1997-09-30 | 1994-12-01 | Kriegel | Jay | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | 501 Madison Avenue | Suite 1300 | New York | NY | 10022 |
31183 | 31183 | 1997-09-30 | 1992-12-11 | Abernathy | James L. | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | 501 Madison Avenue | Suite 1300 | New York | NY | 10022 |
31184 | 31184 | 1997-09-30 | 1992-12-11 | MacGregor | James T. | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | 501 Madison Avenue | Suite 1300 | New York | NY | 10022 |
31185 | 31185 | 1997-09-30 | 1992-12-11 | Metz | Robert T. | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | 501 Madison Avenue | Suite 1300 | New York | NY | 10022 |
31186 | 31186 | 1997-09-30 | 1992-12-11 | Smith | Jonathan | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | 501 Madison Avenue | Suite 1300 | New York | NY | 10022 |
31187 | 31187 | 1997-09-30 | 1992-12-11 | Stockton | Richard | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | 501 Madison Avenue | Suite 1300 | New York | NY | 10022 |
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]) );