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

7 rows where State = "NC"

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	State
811	811	1985-01-01	Bode Corporation	1984-03-21	GERMANY, FEDERAL REPUBLIC OF	3350 3350	1982-04-02	Sedam & Herge, a Professional Corporation		NC
2817	2817	1992-02-28	Elox Corporation	1990-04-27	SWITZERLAND	4370 4370	1990-04-27	G.S. Schwartz & Company, Inc.	Davidson	NC
5186	5186	1992-04-23	Pliana, Inc.	1991-02-13	MEXICO	3988 3988	1987-05-28	Crowell & Moring International, Ltd.	Greensboro	NC
6049	6049	1990-05-08	Elox Corporation	1990-03-16	SWITZERLAND	4351 4351	1990-03-16	Neuman, Williams, Anderson & Olson	Davidson	NC
9762	9762	1987-08-11	Melex U.S.A., Inc.	1987-12-30	POLAND	3599 3599	1984-06-25	Bryan Cave	Raleigh	NC
11090	11090	1990-09-15	Elox Corporation	1990-03-16	SWITZERLAND	4352 4352	1990-03-16	King & Spalding	Davidson	NC
12577	12577	1983-10-31	Moldow Dust Control, Inc., a Delaware Corporation	1981-09-04	DENMARK	2861 2861	1978-01-25	Metzger, Shadyac & Schwarz		NC

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