FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where "Short_Form_Termination_Date" is on date 2000-03-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_2, Zip
Short_Form_Date (date) 17 ✖
- 1997-11-18 3
- 1998-03-03 3
- 1999-11-18 3
- 1987-06-15 1
- 1988-09-01 1
- 1996-07-15 1
- 1997-07-31 1
- 1997-08-22 1
- 1998-02-19 1
- 1998-02-20 1
- 1998-04-20 1
- 1998-10-19 1
- 1999-09-07 1
- 1999-09-15 1
- 1999-10-28 1
- 1999-12-16 1
- 2000-01-19 1
Registration_Number 13
- KOTRA 4
- Davis Manafort & Freedman, Inc. 3
- U.S. Representative Offices of the Development Bank of Japan 3
- Ruder Finn, Inc. 2
- Fleishman-Hillard, Inc. 2
- Shandwick Public Affairs, Inc. 2
- Sveriges Television AB (Swedish Broadcasting Corporation) 1
- Alpine Tourist Office 1
- Bernhagen & Associates 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- David Morey Group, Inc. (DMG) 1
- Ropes and Gray 1
- Carlington Sales Canada Corporation 1
Registration_Date (date) 13 ✖
- 1963-04-17 4
- 1998-03-03 3
- 1999-11-18 3
- 1961-09-27 2
- 1986-02-05 2
- 1997-12-17 2
- 1964-01-02 1
- 1967-09-27 1
- 1987-06-15 1
- 1997-07-31 1
- 1998-02-19 1
- 1999-09-15 1
- 1999-12-09 1
Registrant_Name 13
- KOTRA 4
- Davis Manafort & Freedman, Inc. 3
- U.S. Representative Offices of the Development Bank of Japan 3
- Fleishman-Hillard, Inc. 2
- Ruder Finn, Inc. 2
- Shandwick Public Affairs, Inc. 2
- Alpine Tourist Office 1
- Bernhagen & Associates 1
- Carlington Sales Canada Corporation 1
- David Morey Group, Inc. (DMG) 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- Ropes and Gray 1
- Sveriges Television AB (Swedish Broadcasting Corporation) 1
City 8
- New York 11
- Alexandria 3
- Washington 3
- St. Louis 2
- Boston 1
- Montreal, Quebec 1
- San Francisco 1
- Seattle 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11829 | 11829 | 2000-03-31 | 2000-01-19 | Wilson | Peter Vance | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
11830 | 11830 | 2000-03-31 | 1998-02-19 | Morey | David | David Morey Group, Inc. (DMG) 5236 | 1998-02-19 | David Morey Group, Inc. (DMG) | 1701 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
11831 | 11831 | 2000-03-31 | 1998-02-20 | Ha | Seung Beom | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
11832 | 11832 | 2000-03-31 | 1998-03-03 | Davis | Richard H. | Davis Manafort & Freedman, Inc. 5240 | 1998-03-03 | Davis Manafort & Freedman, Inc. | 211 North Union Street | Suite 250 | Alexandria | VA | 22314 |
11833 | 11833 | 2000-03-31 | 1998-03-03 | Manafort | Paul J. | Davis Manafort & Freedman, Inc. 5240 | 1998-03-03 | Davis Manafort & Freedman, Inc. | 211 North Union Street | Suite 250 | Alexandria | VA | 22314 |
11834 | 11834 | 2000-03-31 | 1998-03-03 | McKone | Timothy | Davis Manafort & Freedman, Inc. 5240 | 1998-03-03 | Davis Manafort & Freedman, Inc. | 211 North Union Street | Suite 250 | Alexandria | VA | 22314 |
11835 | 11835 | 2000-03-31 | 1998-04-20 | Pio Trippa | Dott. | Alpine Tourist Office 2052 | 1967-09-27 | Alpine Tourist Office | C/O Austrian Tourist Office, Inc. | 608 Fifth Avenue | New York | NY | 10020 |
11836 | 11836 | 2000-03-31 | 1987-06-15 | Bernhagen | Clyde | Bernhagen & Associates 3992 | 1987-06-15 | Bernhagen & Associates | 10233 - 26th Avenue, S.W. | Seattle | WA | 98146 | |
11837 | 11837 | 2000-03-31 | 1996-07-15 | Glidden | Julia A. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11838 | 11838 | 2000-03-31 | 1997-07-31 | Conn | Robert E. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
11839 | 11839 | 2000-03-31 | 1997-08-22 | Golden-Vazquez | Abigail | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11840 | 11840 | 2000-03-31 | 1988-09-01 | Johansson | Elisabeth | Sveriges Television AB (Swedish Broadcasting Corporation) 1676 | 1964-01-02 | Sveriges Television AB (Swedish Broadcasting Corporation) | 747 Third Avenue | New York | NY | 10017 | |
11841 | 11841 | 2000-03-31 | 1999-09-07 | Parker | Amy M. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11842 | 11842 | 2000-03-31 | 1999-09-15 | Baron | David R. | Ropes and Gray 5328 | 1999-09-15 | Ropes and Gray | One International Place | Boston | MA | 02110-2624 | |
11843 | 11843 | 2000-03-31 | 1998-10-19 | Griffin | Maire | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
11844 | 11844 | 2000-03-31 | 1999-10-28 | Janashvili | Lev | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11845 | 11845 | 2000-03-31 | 1997-11-18 | Choe | Ki Hyung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
11846 | 11846 | 2000-03-31 | 1997-11-18 | Kim | Tae Chil | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
11847 | 11847 | 2000-03-31 | 1997-11-18 | Son | Pyung Il | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
11848 | 11848 | 2000-03-31 | 1999-11-18 | Goto | Kiyoshi | U.S. Representative Offices of the Development Bank of Japan 5344 | 1999-11-18 | U.S. Representative Offices of the Development Bank of Japan | 1251 Avenue of the Americas | Suite 830 | New York | NY | 10020 |
11849 | 11849 | 2000-03-31 | 1999-11-18 | Kai | Shigetoshi | U.S. Representative Offices of the Development Bank of Japan 5344 | 1999-11-18 | U.S. Representative Offices of the Development Bank of Japan | 1251 Avenue of the Americas | Suite 830 | New York | NY | 10020 |
11850 | 11850 | 2000-03-31 | 1999-11-18 | Mashiyama | Yuji | U.S. Representative Offices of the Development Bank of Japan 5344 | 1999-11-18 | U.S. Representative Offices of the Development Bank of Japan | 1251 Avenue of the Americas | Suite 830 | New York | NY | 10020 |
11851 | 11851 | 2000-03-31 | 1999-12-16 | Hooper | Peter | Carlington Sales Canada Corporation 5347 | 1999-12-09 | Carlington Sales Canada Corporation | 1260 Crescent, | Suite 201 | Montreal, Quebec |
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]) );