home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

61 rows where Country/Location_Represented = "USSR" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Registrant_Name >30

  • Bell, Linda Jane 5
  • Lamken, Natalie 4
  • Kreisinger, Robert 3
  • Brockman Jr., Earle Wingo 2
  • Gleason, Stephen Bernard 2
  • Lerman, Louis 2
  • Silvin, Mary Jane 2
  • Smith, Edwin S. 2
  • Arau & Goldberg 1
  • Arau Associates, Inc. 1
  • Baff, William E. 1
  • Beaumet, Charles Theodore 1
  • Berman, Karen 1
  • Boland, Kerby Ann 1
  • Brockman, Marjorie M. 1
  • Charles Snitow Organization, Inc. 1
  • Compass Publications, Inc. 1
  • Davidson, Martha Golden 1
  • Drucker, David 1
  • Felter, Marcia 1
  • Foss, Roger C. 1
  • Gallagher, Dennis F. 1
  • H&H 1
  • Henley, Lillian 1
  • Holladay-Tyler Printing Corporation 1
  • Jack J. Morris Associates, Inc. 1
  • Jack Shelton, Inc. 1
  • Kassatly, Richard 1
  • Ketchum Communications Holdings, Inc. 1
  • Kulberg, Raoul F. 1
  • …

Foreign_Principal >30

  • Embassy of the U.S.S.R. 10
  • Soviet Embassy 5
  • U.S.S.R. Information Bulletin 5
  • Embassy of the Union of Soviet Socialist Republics 4
  • Soviet Life Magazine 4
  • Soviet Life 3
  • Soviet Embassy, Information Department 2
  • U.S.S.R. Illustrated Monthly 2
  • Embassy of Soviet Union Information Department 1
  • Embassy of the U.S.S.R. (Soviet Life Magazine) 1
  • Embassy of the U.S.S.R. (U.S.S.R. Information Bulletin) 1
  • Embassy of the U.S.S.R. - Press Department 1
  • Embassy of the U.S.S.R. in the U.S. 1
  • Embassy of the Union of Soviet Socialist Republics in the U.S. 1
  • Evgeni A. Zaostrovtsev 1
  • Flor N. Koritz 1
  • Giorghi (Employee for Soviet Embassy Superior of Third Secretary Gaorikov) 1
  • Government of U.S.S.R. 1
  • Information Department - Soviet Embassy - Soviet Life 1
  • Information Department Embassy of the U.S.S.R. 1
  • Mr. Vasilev 1
  • Nikolai I. Kurochkin 1
  • Press Department, Embassy of the U.S.S.R. 1
  • Soviet Embassy (Soviet Life Magazine) 1
  • Soviet Exhibition of Science, Technology & Culture at the Coliseum-NYC-USA-under auspices of Chamber of Commerce-USSR 1
  • Soviet Life Magazine (Formerly: U.S.S.R. Illustrated Monthly) 1
  • Soviet Life Publications, Embassy of the U.S.S.R. 1
  • Soviet Youth Exhibit 1
  • Third Secretary Gennody B. Gaorikov 1
  • U.S.S.R. 1
  • …

City 2

  • - 60
  • Washington 1

State 1

  • DC · 61 ✖

Country/Location_Represented 1

  • USSR · 61 ✖
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
1282 1282 1975-01-14 Embassy of the Union of Soviet Socialist Republics 1967-07-18 USSR Compass Publications, Inc. 1981 1966-06-08 Compass Publications, Inc. Washington     DC  
1491 1491 1975-01-24 Soviet Embassy 1973-02-01 USSR Lamken, Natalie 2405 1973-02-01 Lamken, Natalie Washington     DC  
2000 2000 1980-02-01 Soviet Life Magazine (Formerly: U.S.S.R. Illustrated Monthly) 1973-10-18 USSR Lerman, Louis 973 1956-08-28 Lerman, Louis Washington     DC  
2435 2435 1981-02-13 Information Department - Soviet Embassy - Soviet Life 1980-07-28 USSR Levine, Allen 3125 1980-07-28 Levine, Allen Washington     DC  
2479 2479 1975-02-14 Embassy of the U.S.S.R. 1974-06-06 USSR Bell, Linda Jane 2516 1974-06-06 Bell, Linda Jane Washington     DC  
2636 2636 1966-02-18 Press Department, Embassy of the U.S.S.R. 1952-11-06 USSR Kreisinger, Robert 641 1950-09-20 Kreisinger, Robert Washington     DC  
2637 2637 1966-02-18 U.S.S.R. Information Bulletin 1950-09-20 USSR Kreisinger, Robert 641 1950-09-20 Kreisinger, Robert Washington     DC  
2638 2638 1966-02-18 U.S.S.R. Magazine (Published by the Embassy of the U.S.S.R.) 1956-12-10 USSR Kreisinger, Robert 641 1950-09-20 Kreisinger, Robert Washington     DC  
2805 2805 1947-02-26 Flor N. Koritz 1942-08-26 USSR Drucker, David 108 1942-08-26 Drucker, David Washington     DC  
3393 3393 1980-03-03 U.S.S.R. Illustrated Monthly 1956-08-28 USSR Lerman, Louis 973 1956-08-28 Lerman, Louis Washington     DC  
4150 4150 1960-03-30 Evgeni A. Zaostrovtsev 1960-03-30 USSR Kulberg, Raoul F. 1346 1960-03-30 Kulberg, Raoul F. Washington     DC  
4151 4151 1960-03-30 Giorghi (Employee for Soviet Embassy Superior of Third Secretary Gaorikov) 1960-03-30 USSR Gleason, Stephen Bernard 1345 1960-03-30 Gleason, Stephen Bernard Washington     DC  
4152 4152 1960-03-30 Third Secretary Gennody B. Gaorikov 1960-03-30 USSR Gleason, Stephen Bernard 1345 1960-03-30 Gleason, Stephen Bernard Washington     DC  
5208 5208 1986-04-12 Embassy of the Union of Soviet Socialist Republics 1985-04-25 USSR North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       DC  
5446 5446 1958-04-21 Nikolai I. Kurochkin 1958-04-21 USSR Beaumet, Charles Theodore 1135 1958-04-21 Beaumet, Charles Theodore Washington     DC  
6133 6133 1959-05-01 Mr. Vasilev 1959-05-01 USSR Baff, William E. 1223 1959-05-01 Baff, William E. Washington     DC  
6376 6376 1970-05-07 Government of U.S.S.R. 1968-11-27 USSR Sherwood Ross 2113 1968-11-27 Sherwood Ross Soviet Embassy 1708 - 18 Street N.W.     DC  
6431 6431 1974-05-10 Soviet Embassy, Information Department 1973-10-27 USSR O'Leary, Anne 2475 1973-10-27 O'Leary, Anne Washington     DC  
6544 6544 1965-05-15 Embassy of the Union of Soviet Socialist Republics in the U.S. 1957-11-15 USSR Select Magazines, Inc. 1083 1957-11-15 Select Magazines, Inc. Washington     DC  
6567 6567 1991-05-15 Embassy of the U.S.S.R. 1949-11-10 USSR Henley, Lillian 597 1949-11-10 Henley, Lillian Washington     DC  
6740 6740 1984-05-23 Soviet Life 1981-10-08 USSR Arau & Goldberg 3285 1981-10-08 Arau & Goldberg Washington     DC  
6847 6847 1955-05-26 Embassy of the Union of Soviet Socialist Republics 1953-06-15 USSR Recht, Charles 101 1942-08-20 Recht, Charles 1125 16th Street, NW   Washington DC 20005
7052 7052 1981-05-31 Soviet Life Magazine 1980-08-04 USSR Jack Shelton, Inc. 3129 1980-08-04 Jack Shelton, Inc. Washington     DC  
7316 7316 1952-06-01 U.S.S.R. Information Bulletin 1952-11-17 USSR Smith, Edwin S. 723 1952-05-05 Smith, Edwin S. Washington     DC  
7343 7343 1964-06-01 U.S.S.R. Illustrated Monthly 1957-01-29 USSR Smith, Edwin S. 723 1952-05-05 Smith, Edwin S. Washington     DC  
7608 7608 1972-06-05 Embassy of the U.S.S.R. 1969-06-16 USSR Bell, Linda Jane 2143 1969-06-16 Bell, Linda Jane Washington     DC  
7794 7794 1976-06-14 Embassy of Soviet Union Information Department 1975-06-09 USSR Berman, Karen 2588 1975-06-09 Berman, Karen Washington     DC  
7981 7981 1988-06-21 Embassy of the U.S.S.R. 1981-03-27 USSR Bell, Linda Jane 3219 1981-03-27 Bell, Linda Jane Washington     DC  
7985 7985 1988-06-21 Soviet Life Magazine 1981-03-27 USSR Bell, Linda Jane 3219 1981-03-27 Bell, Linda Jane Washington     DC  
8999 8999 1974-07-04 Soviet Youth Exhibit 1974-03-22 USSR H&H 2506 1974-03-22 H&H Washington     DC  
9391 9391 1976-07-21 Soviet Life Publications, Embassy of the U.S.S.R. 1976-06-18 USSR Boland, Kerby Ann 2699 1976-06-18 Boland, Kerby Ann Washington     DC  
9537 9537 1979-07-27 Embassy of the U.S.S.R. 1979-07-11 USSR Nelidow, Irina 3039 1979-07-11 Nelidow, Irina Washington     DC  
9977 9977 1979-08-01 Soviet Life Magazine 1979-02-28 USSR Ketchum Communications Holdings, Inc. 2386 1972-10-17 Ketchum Communications Holdings, Inc.       DC  
10161 10161 1968-08-06 Soviet Embassy 1968-03-14 USSR Lamken, Natalie 2079 1968-03-14 Lamken, Natalie Washington     DC  
10610 10610 1960-08-19 Valentin M. Ivanov (Soviet First Secretary) 1960-08-19 USSR Foss, Roger C. 1387 1960-08-19 Foss, Roger C. Washington     DC  
10612 10612 1977-08-19 Soviet Embassy 1975-11-03 USSR Lamken, Natalie 2626 1975-11-03 Lamken, Natalie Washington     DC  
10636 10636 1968-08-21 Soviet Life 1967-09-22 USSR Arau Associates, Inc. 2051 1967-09-22 Arau Associates, Inc. Washington     DC  
10655 10655 1952-08-22 U.S.S.R. Information Bulletin 1952-02-20 USSR Brockman, Marjorie M. 716 1952-02-20 Brockman, Marjorie M. Washington     DC  
10759 10759 1972-08-26 Soviet Embassy 1972-03-01 USSR Lamken, Natalie 2323 1972-03-01 Lamken, Natalie Washington     DC  
10986 10986 1988-08-31 U.S.S.R. Trade Mission 1988-06-17 USSR Gallagher, Dennis F. 4152 1988-06-17 Gallagher, Dennis F. Washington     DC  
11201 11201 1952-09-01 U.S.S.R. Information Bulletin 1952-06-23 USSR Mardo, Bill 731 1952-06-23 Mardo, Bill Washington     DC  
11429 11429 1978-09-08 Embassy of the U.S.S.R. (Soviet Life Magazine) 1977-06-17 USSR Bell, Linda Jane 2793 1977-06-17 Bell, Linda Jane Washington     DC  
11577 11577 1973-09-14 Embassy of the U.S.S.R. 1972-10-04 USSR Silvin, Mary Jane 2383 1972-10-04 Silvin, Mary Jane Washington     DC  
11618 11618 1965-09-15 Embassy of the Union of Soviet Socialist Republics 1957-05-07 USSR Davidson, Martha Golden 1022 1957-05-07 Davidson, Martha Golden Washington     DC  
11729 11729 1967-09-20 Soviet Embassy, Information Department 1967-09-20 USSR Marr, Barbara Ann 2050 1967-09-20 Marr, Barbara Ann Washington     DC  
11908 11908 1952-09-30 Embassy of the U.S.S.R. (U.S.S.R. Information Bulletin) 1951-11-14 USSR Pope, Lillian Marcella 693 1951-11-14 Pope, Lillian Marcella Washington     DC  
12298 12298 1951-10-01 Embassy of the U.S.S.R. 1951-10-01 USSR Sperling, Mae Irene 685 1951-10-01 Sperling, Mae Irene Washington     DC  
12303 12303 1959-10-01 Soviet Exhibition of Science, Technology & Culture at the Coliseum-NYC-USA-under auspices of Chamber of Commerce-USSR 1959-08-04 USSR Charles Snitow Organization, Inc. 1251 1959-08-04 Charles Snitow Organization, Inc. Washington     DC  
12315 12315 1972-10-01 Soviet Life Magazine 1971-09-29 USSR Jack J. Morris Associates, Inc. 2281 1971-09-29 Jack J. Morris Associates, Inc. Washington     DC  
12818 12818 1966-10-18 Embassy of the U.S.S.R. in the U.S. 1965-08-17 USSR Lemma, Susan Weber 1916 1965-08-17 Lemma, Susan Weber Washington     DC  
13047 13047 1976-10-26 Soviet Embassy (Soviet Life Magazine) 1969-05-01 USSR Felter, Marcia 2132 1969-05-01 Felter, Marcia Washington     DC  
13897 13897 1976-11-12 Embassy of the U.S.S.R. 1976-06-12 USSR Silvin, Mary Jane 2697 1976-06-12 Silvin, Mary Jane Washington     DC  
14086 14086 1950-11-20 Embassy of the U.S.S.R. 1946-05-07 USSR Lynch, Mary Katherine 356 1946-05-07 Lynch, Mary Katherine Washington     DC  
14237 14237 1961-11-25 Embassy of the U.S.S.R. 1952-06-23 USSR Lamberton, Harry C. 696 1951-11-20 Lamberton, Harry C. Washington     DC  
14427 14427 1990-11-30 Soviet Life 1974-01-21 USSR Siegel, Leah 2488 1974-01-21 Siegel, Leah Washington     DC  
14839 14839 1985-12-06 Soviet Embassy 1964-12-16 USSR Holladay-Tyler Printing Corporation 1835 1964-12-16 Holladay-Tyler Printing Corporation Washington     DC  
14887 14887 1952-12-08 Embassy of the U.S.S.R. - Press Department 1952-11-06 USSR Brockman Jr., Earle Wingo 715 1952-02-20 Brockman Jr., Earle Wingo Washington     DC  
14888 14888 1952-12-08 U.S.S.R. Information Bulletin 1952-02-20 USSR Brockman Jr., Earle Wingo 715 1952-02-20 Brockman Jr., Earle Wingo Washington     DC  
15036 15036 1974-12-12 U.S.S.R. 1973-05-31 USSR Kassatly, Richard 2430 1973-05-31 Kassatly, Richard Washington     DC  
15716 15716 1973-12-31 USSR Illustrated Monthly 1964-06-26 USSR Solov, Liuba 1766 1964-06-29 Solov, Liuba Washington     DC  
16204 16204 1991-12-31 Information Department Embassy of the U.S.S.R. 1987-01-07 USSR Styles, Deborah M. 3924 1987-01-07 Styles, Deborah M. washington     DC  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 173.911ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history