FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where "Short_Form_Termination_Date" is on date 1997-06-30 sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_2
Registration_Number 13
- JETRO, New York 12
- KOTRA 2
- Tea Council of the U.S.A., Inc. 2
- Bermuda Tourism Authority 1
- Pekao Trading Corporation 1
- Ruder Finn, Inc. 1
- JETRO, Chicago 1
- Tourism Authority of Thailand, New York 1
- Friends of Fianna Fail, Inc. 1
- Daniel J. Edelman, Inc. 1
- Deutsche Telekom, Inc. 1
- Symms, Lehn & Associates, Inc. 1
- Ogilvy, Adams & Rinehart 1
Registrant_Name 13
- JETRO, New York 12
- KOTRA 2
- Tea Council of the U.S.A., Inc. 2
- Bermuda Tourism Authority 1
- Daniel J. Edelman, Inc. 1
- Deutsche Telekom, Inc. 1
- Friends of Fianna Fail, Inc. 1
- JETRO, Chicago 1
- Ogilvy, Adams & Rinehart 1
- Pekao Trading Corporation 1
- Ruder Finn, Inc. 1
- Symms, Lehn & Associates, Inc. 1
- Tourism Authority of Thailand, New York 1
City 4
- New York 22
- Chicago 2
- Alexandria 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21263 | 21263 | 1997-06-30 | 1988-02-05 | Zar | Paul L. | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
21268 | 21268 | 1997-06-30 | 1995-08-01 | Szajek | Krzysztof | Pekao Trading Corporation 817 | 1954-02-23 | Pekao Trading Corporation | Two Park Avenue | Suite 400 | New York | NY | 10016 |
21284 | 21284 | 1997-06-30 | 1990-10-30 | Glauber | Anne F. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
21282 | 21282 | 1997-06-30 | 1994-10-17 | Kim | Hyun Tae | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
21283 | 21283 | 1997-06-30 | 1994-10-17 | Park | Dong Hyung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
21260 | 21260 | 1997-06-30 | 1990-02-02 | Okoshi | Hidetomo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21261 | 21261 | 1997-06-30 | 1992-02-04 | Hasegawa | Eiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21262 | 21262 | 1997-06-30 | 1992-02-04 | Washio | Tomoharu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21265 | 21265 | 1997-06-30 | 1995-03-22 | Sasaki | Tadasuke | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21270 | 21270 | 1997-06-30 | 1990-08-03 | Matsunaga | Kazuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21271 | 21271 | 1997-06-30 | 1990-08-03 | Yamamoto | Shunsaku | 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 |
21274 | 21274 | 1997-06-30 | 1993-08-09 | Kaga | Katsumasa | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21275 | 21275 | 1997-06-30 | 1989-08-14 | Maruyama | Kenichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21276 | 21276 | 1997-06-30 | 1994-08-19 | Yahagi | Shinichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21277 | 21277 | 1997-06-30 | 1991-08-23 | Nakaya | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21278 | 21278 | 1997-06-30 | 1991-08-23 | Okuno | Masao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21279 | 21279 | 1997-06-30 | 1994-09-06 | Omura | Kazuyoshi | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
21267 | 21267 | 1997-06-30 | 1993-07-21 | Weerakoon | R. | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | 420 Lexington Avenue | Suite 825 | New York | NY | 10170 |
21269 | 21269 | 1997-06-30 | 1991-08-02 | Simrany | Joseph P. | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | 420 Lexington Avenue | Suite 825 | New York | NY | 10170 |
21264 | 21264 | 1997-06-30 | 1993-02-26 | Suranant | Chalermsak | Tourism Authority of Thailand, New York 1897 | 1965-06-01 | Tourism Authority of Thailand, New York | 61 Broadway | Suite 2810 | New York | NY | 10006 |
21272 | 21272 | 1997-06-30 | 1995-08-04 | Sheeran | Edward | Friends of Fianna Fail, Inc. 3596 | 1984-06-08 | Friends of Fianna Fail, Inc. | C/O Richardson Mahon Casey & Rooney, LLP | 1270 Avenue of the Americas #2911 | New York | NY | 10020 |
21280 | 21280 | 1997-06-30 | 1994-09-08 | Edwards | Jennifer | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21281 | 21281 | 1997-06-30 | 1990-10-09 | Wirz | Herbert | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
21285 | 21285 | 1997-06-30 | 1995-12-12 | Dawkins | Maurice A. | Symms, Lehn & Associates, Inc. 4880 | 1993-12-21 | Symms, Lehn & Associates, Inc. | 127 South Fairfax Street | Suite 137 | Alexandria | VA | 22314-3301 |
21266 | 21266 | 1997-06-30 | 1997-06-30 | Mintz | Richard I. | Ogilvy, Adams & Rinehart 5189 | 1997-06-30 | Ogilvy, Adams & Rinehart | 1901 L Street, N.W. | Suite 300 | Washington | DC | 20036 |
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]) );