FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Address_1 = "Washington" and Country/Location_Represented = "POLAND"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 14
- APCO Worldwide, Inc. 1
- Burling, Edward B. 1
- Cobb, David 1
- Einhorn, Nathan 1
- Feltus, Randolph 1
- Grzebieniowska, Xenia Zytomirska 1
- Lamberton, Harry C. 1
- Marczynski, Antoni Stanislaw 1
- Meyer, Bernard Stern 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Perry, Marilyn Edith 1
- Select Magazines, Inc. 1
- Smith, Edwin S. 1
- Szabad, George Michael 1
Registrant_Date (date) 14 ✖
- 1945-12-20 1
- 1946-05-09 1
- 1946-10-16 1
- 1946-10-22 1
- 1948-06-29 1
- 1951-11-14 1
- 1951-11-20 1
- 1951-12-14 1
- 1952-05-05 1
- 1957-11-15 1
- 1962-01-24 1
- 1976-10-27 1
- 1985-02-04 1
- 1991-09-03 1
Foreign_Principal 8
- Polish Embassy 4
- Polish Supply & Reconstruction Mission in North America 3
- Embassy of the Polish People's Republic 2
- Embassy of the Polish Government in the U.S. 1
- Embassy of the Polish People's Republic & the Enterprise for Distribution of Foreign Publications, Polish People's Rep. 1
- Government of Poland, Polish Embassy 1
- Government of the Republic of Poland 1
- Republic of Poland, Embassy 1
State 1
- DC 14
Country/Location_Represented 1
- POLAND · 14 ✖
City 1
- - 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2893 | 2893 | 1947-02-28 | Polish Supply & Reconstruction Mission in North America | 1946-10-22 | POLAND | Meyer, Bernard Stern 385 | 1946-10-22 | Meyer, Bernard Stern | Washington | DC | |||
3753 | 3753 | 1974-03-15 | Embassy of the Polish People's Republic | 1962-01-24 | POLAND | Cobb, David 1512 | 1962-01-24 | Cobb, David | Washington | DC | |||
4074 | 4074 | 1947-03-27 | Polish Supply & Reconstruction Mission in North America | 1945-12-20 | POLAND | Burling, Edward B. 333 | 1945-12-20 | Burling, Edward B. | Washington | DC | |||
4557 | 4557 | 1997-03-31 | Republic of Poland, Embassy | 1996-07-05 | POLAND | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Washington | DC | |||
6549 | 6549 | 1974-05-15 | Embassy of the Polish People's Republic & the Enterprise for Distribution of Foreign Publications, Polish People's Rep. | 1959-06-17 | POLAND | Select Magazines, Inc. 1083 | 1957-11-15 | Select Magazines, Inc. | Washington | DC | |||
7342 | 7342 | 1964-06-01 | Polish Embassy | 1952-11-17 | POLAND | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | Washington | DC | |||
8799 | 8799 | 1949-07-01 | Embassy of the Polish Government in the U.S. | 1946-10-16 | POLAND | Feltus, Randolph 381 | 1946-10-16 | Feltus, Randolph | Washington | DC | |||
8819 | 8819 | 1962-07-01 | Polish Embassy | 1951-11-14 | POLAND | Einhorn, Nathan 694 | 1951-11-14 | Einhorn, Nathan | Washington | DC | |||
9250 | 9250 | 1946-07-15 | Polish Supply & Reconstruction Mission in North America | 1946-05-09 | POLAND | Szabad, George Michael 357 | 1946-05-09 | Szabad, George Michael | Washington | DC | |||
12866 | 12866 | 1976-10-20 | Embassy of the Polish People's Republic | 1976-10-27 | POLAND | Perry, Marilyn Edith 2731 | 1976-10-27 | Perry, Marilyn Edith | Washington | DC | |||
13721 | 13721 | 1948-11-05 | Polish Embassy | 1948-06-29 | POLAND | Grzebieniowska, Xenia Zytomirska 531 | 1948-06-29 | Grzebieniowska, Xenia Zytomirska | Washington | DC | |||
14238 | 14238 | 1961-11-25 | Polish Embassy | 1951-11-20 | POLAND | Lamberton, Harry C. 696 | 1951-11-20 | Lamberton, Harry C. | Washington | DC | |||
15081 | 15081 | 1951-12-14 | Government of Poland, Polish Embassy | 1951-12-14 | POLAND | Marczynski, Antoni Stanislaw 701 | 1951-12-14 | Marczynski, Antoni Stanislaw | Washington | DC | |||
16162 | 16162 | 1990-12-31 | Government of the Republic of Poland | 1990-03-16 | POLAND | Paul, Weiss, Rifkind, Wharton & Garrison 3647 | 1985-02-04 | Paul, Weiss, Rifkind, Wharton & Garrison | Washington | 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]) );