fara: FARA_All_ForeignPrincipals: 4 rows where where City = "Alexandria" and State = "VA" sorted by Foreign_Principal_Registration

List of all foreign principals (active and terminated)

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

4 rows where City = "Alexandria" and State = "VA" sorted by Foreign_Principal_Registration_Date

Search:

descending

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
13021	13021	2007-10-31	Ukraine Parties of Regions thru Davis Manafort International LLC	2008-01-30	UKRAINE	3657 3657	1985-03-12	Daniel J. Edelman, Inc.	211 North Union Street	Suite 250	Alexandria	VA	22314
2963	2963	2014-02-28	Katrin Michael, Advocate for Iraqi Christians	2010-03-29	IRAQ	3718 3718	1985-08-07	Holland & Knight	6008 B Ellesmere Court		Alexandria	VA	22315
1956	1956	2013-02-01	Kongsberg Protech Systems	2011-07-22	NORWAY	3634 3634	1984-11-15	Daniel J. Edelman, Inc.	1725 Duke Street, Suite 600		Alexandria	VA	22314
7623	7623	2020-06-17	Corallo Media Strategies, Inc. (CMSI") on behalf of Gilbert R. Chagoury"	2020-06-17	NIGERIA	6838 6838	2020-06-17	Black Bag LLC	520 North Washington St.		Alexandria	VA	22314

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