FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

30 rows where State = "MD" sorted by Foreign_Principal_Registration_Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

City

State

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
9166 9166 1946-07-27 French Tobacco Commissioner (Service d'Exploitation Industrielle des Tabacs et Allumettes) 1943-10-15 FRANCE 56 56 1942-07-20 Haight, Griffin, Deming & Gardner Baltimore     MD  
7797 7797 1987-06-25 Coordination Council for North American Affairs 1982-11-29 TAIWAN 3422 3422 1982-11-29 Corcoran Jr., Thomas G. Bethesda     MD  
12192 12192 1985-10-12 Coordination Council for North American Activities 1985-04-18 TAIWAN 2836 2836 1977-10-12 North American Precis Syndicate       MD  
12274 12274 1984-10-15 Zodiac of North America 1985-05-30 FRANCE 3179 3179 1980-12-12 Parrish & Company, Inc. Stevensville     MD  
12523 12523 1986-10-23 Coordination Council for North American Activities 1986-03-18 TAIWAN 2836 2836 1977-10-12 North American Precis Syndicate       MD  
2474 2474 1996-02-16 Beretta, U.S.A. Corporation 1987-08-13 ITALY 3700 3700 1985-07-09 Gold & Liebengood, Inc. Accokeek     MD  
14812 14812 1987-12-21 Dalmark Corporation 1987-11-25 NETHERLANDS ANTILLES 2968 2968 1978-10-18 Cole Corette & Abrutyn, P.C. Bethesda     MD  
14813 14813 1987-12-21 Tremark Corporation 1987-11-25 NETHERLANDS ANTILLES 2968 2968 1978-10-18 Cole Corette & Abrutyn, P.C. Bethesda     MD  
821 821 1988-01-01 Dalmark Corporation 1988-03-24 NETHERLANDS ANTILLES 4109 4109 1988-03-24 William A. Kirk, Jr., P.C. Bethesda     MD  
822 822 1988-01-01 Dalmark Corporation 1988-03-24 NETHERLANDS ANTILLES 4110 4110 1988-03-24 James C. Corman, P.C. Bethesda     MD  
829 829 1988-01-01 Tremark Corporation 1988-03-24 NETHERLANDS ANTILLES 4109 4109 1988-03-24 William A. Kirk, Jr., P.C. Bethesda     MD  
830 830 1988-01-01 Tremark Corporation 1988-03-24 NETHERLANDS ANTILLES 4110 4110 1988-03-24 James C. Corman, P.C. Bethesda     MD  
2822 2822 1990-02-28 Moises Escobar 1988-05-27 EL SALVADOR 3452 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Silver Spring     MD  
13711 13711 1989-11-22 Sunbelt Corporation 1988-06-30 INTERNATIONAL 3274 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Baltimore     MD  
3447 3447 1993-03-11 Crest Hotels International 1988-12-21 INTERNATIONAL 2478 2478 1973-11-23 Keating Group, Inc. Silver Springs     MD  
1646 1646 1990-01-31 Westinghouse-Airship Industries, Ltd. 1989-07-25 GREAT BRITAIN 3971 3971 1987-04-29 Levine & Company Baltimore     MD  
5673 5673 1992-04-30 Range Rover of North America, Inc. 1992-02-27 GREAT BRITAIN 3626 3626 1984-10-31 Miller & Chevalier, Chartered Lanham     MD  
9473 9473 1994-07-31 Renaiscencia do Movimento Democratico de Angola (RMDA) 1993-01-04 ANGOLA 4748 4748 1993-01-04 Renaiscencia do Movimento Nacional Democratico (RMNDA) Landover     MD  
1671 1671 1994-01-31 American Guideway Corporation 1993-07-22 CANADA 4495 4495 1991-04-03 Capital Partnerships, Inc. Hunt Valley     MD  
15794 15794 1995-12-31 AECL Technologies, Inc. 1995-10-13 CANADA 3712 3712 1985-08-05 DLA Piper US LLP Rockville     MD  
4368 4368 1996-03-31 Kim Dae-Jung Peace Foundation, U.S.A. 1995-10-27 KOREA, SOUTH 5065 5065 1995-10-27 Costello, Stephen Rockville     MD  
13323 13323 2000-11-06 Scott Caruthers, Ambassador at Large, Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine from the Commonwealth of Dominica 2000-05-18 DOMINICA 5370 5370 2000-05-18 Gershberg & Associates, LLC 597 Scott Drive Westminster     MD  
13324 13324 2000-11-06 Scott Caruthers, Ambassador-at-Large, and Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine, from the Commonwealth of Dominica 2000-05-18 DOMINICA 5371 5371 2000-05-18 Pearl, David 597 Scott Drive Westminster,     MD  
8318 8318 2002-06-30 American Worldwide, Inc./Government of the Republic of Angola 2001-02-14 ANGOLA 2165 2165 1969-10-09 Squire Patton Boggs, LLP 3 Bethesda Metro Center Suite 600 Bethesda 20814     MD  
2917 2917 2003-02-28 Decapolis Group on behalf of Severo Moto 2002-10-23 EQUATORIAL GUINEA 5527 5527 2002-10-23 Butler, Victoria A. 15322 Chinaberry Street North Potomac 20878     MD  
16039 16039 2003-12-31 Ethiopian Medhin Democratic Party 2003-06-26 ETHIOPIA 5565 5565 2003-06-26 Ethiopian Medhin Democratic Association 8115 Fenton Street Suite 305 Silver Spring 20910     MD  
2653 2653 2004-02-25 Dialcom International 2004-02-25 ROMANIA 5601 5601 2004-02-25 Lincoln Park Public Relations, LLC Bethesda, MD     MD  
13029 13029 2014-10-31 Bo Zhang 2013-12-23 CHINA 2165 2165 1969-10-09 Squire Patton Boggs, LLP 5600 Wisconson Avenue Apt. 906 Chevy Chase MD 20815
8453 8453 2018-06-30 Mount Olives, LLC (on behalf of the Nigerian Attorney General) 2018-05-30 NIGERIA 6377 6377 2016-09-19 Prime Policy Group 8470 Winding Trail   Laurel MD 20724
9597 9597 2019-07-31 Innovative Technology & Business Consulting LLC 2018-07-06 UKRAINE 6344 6344 2016-03-25 Livingston Group, LLC 1829 Reisterstown Road, Suite 350   Pikesville MD 21208

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])
);