FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "", Country/Location_Represented = "HUNGARY" and State = "DC" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 13
- Collier Shannon Scott, PLLC 1
- Denton, James S. 1
- Forer & Rein 1
- Francis S. Rath, P.C. 1
- Fried, Frank, Harris, Shriver & Jacobson 1
- Gellert, Hugo 1
- Hill and Knowlton Strategies, LLC 1
- Information for Investment Decisions, Inc. (IID) 1
- LeRoy & Denslow 1
- Paul, Hastings, Janofsky & Walker 1
- Promoter American/Hungarian Public Relations 1
- Rittenberg, Louis 1
- Smith, Edwin S. 1
Foreign_Principal_Registration_Date 12 ✖
- 1993-06-23 2
- 1946-07-11 1
- 1952-11-17 1
- 1953-02-10 1
- 1957-05-01 1
- 1966-03-22 1
- 1990-08-09 1
- 1991-10-03 1
- 1993-03-01 1
- 1999-05-25 1
- 2000-09-25 1
- 2001-04-23 1
Foreign_Principal 9
- Embassy of Hungary 3
- Government of Hungary, Embassy 2
- Legation of the Hungarian People's Republic 2
- Embassy of the People's Republic of Hungary 1
- Government of Hungary 1
- Hungarian Government 1
- Legation of Hungary 1
- Ministry of Foreign Affairs Government of Hungary, Embassy 1
- Republic of Hungary, Embassy 1
State 1
- DC · 13 ✖
Country/Location_Represented 1
- HUNGARY · 13 ✖
City 1
- - · 13 ✖
Link | rowid | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date ▼ | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13777 | 13777 | 1947-11-07 | Legation of Hungary | 1946-07-11 | HUNGARY | LeRoy & Denslow 27 | 1942-07-09 | LeRoy & Denslow | Washington | DC | |||
7323 | 7323 | 1964-06-01 | Legation of the Hungarian People's Republic | 1952-11-17 | HUNGARY | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | Washington | DC | |||
10247 | 10247 | 1953-08-10 | Embassy of the People's Republic of Hungary | 1953-02-10 | HUNGARY | Rittenberg, Louis 758 | 1953-02-10 | Rittenberg, Louis | Washington | DC | |||
15240 | 15240 | 1957-12-20 | Legation of the Hungarian People's Republic | 1957-05-01 | HUNGARY | Gellert, Hugo 1018 | 1957-05-01 | Gellert, Hugo | Washington | DC | |||
12437 | 12437 | 1966-10-02 | Hungarian Government | 1966-03-22 | HUNGARY | Forer & Rein 1771 | 1964-07-20 | Forer & Rein | Washington | DC | |||
13881 | 13881 | 1990-11-11 | Government of Hungary | 1990-08-09 | HUNGARY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
14899 | 14899 | 1993-12-08 | Embassy of Hungary | 1991-10-03 | HUNGARY | Promoter American/Hungarian Public Relations 4573 | 1991-10-03 | Promoter American/Hungarian Public Relations | Washington | DC | |||
6218 | 6218 | 1995-05-01 | Republic of Hungary, Embassy | 1993-03-01 | HUNGARY | Paul, Hastings, Janofsky & Walker 4772 | 1993-03-01 | Paul, Hastings, Janofsky & Walker | Washington | DC | |||
1225 | 1225 | 1995-01-11 | Embassy of Hungary | 1993-06-23 | HUNGARY | Fried, Frank, Harris, Shriver & Jacobson 4821 | 1993-06-23 | Fried, Frank, Harris, Shriver & Jacobson | Washington | DC | |||
1796 | 1796 | 1996-01-31 | Embassy of Hungary | 1993-06-23 | HUNGARY | Francis S. Rath, P.C. 4822 | 1993-06-23 | Francis S. Rath, P.C. | Washington | DC | |||
14493 | 14493 | 2000-11-30 | Government of Hungary, Embassy | 1999-05-25 | HUNGARY | Information for Investment Decisions, Inc. (IID) 5312 | 1999-05-25 | Information for Investment Decisions, Inc. (IID) | 3910 Shoemaker Street, N.W., Washington | DC | |||
6378 | 6378 | 2002-05-07 | Government of Hungary, Embassy | 2000-09-25 | HUNGARY | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | 3910 Shoemaker Street, N.W. 20008 | DC | |||
5993 | 5993 | 2001-04-30 | Ministry of Foreign Affairs Government of Hungary, Embassy | 2001-04-23 | HUNGARY | Denton, James S. 5416 | 2001-03-19 | Denton, James S. | Embassy of Hungary 3910 Shoemaker Street, N.W. 20008 | DC |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );