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

11 rows where Registrant_Name = "Lever, Michael" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Country/Location_Represented 7

State 1

Registrant_Name 1

  • Lever, Michael · 11 ✖

City 1

  • - 11
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
806 806 1969-01-01 Embassy of Uruguay 1964-08-13 URUGUAY Lever, Michael 1592 1963-01-25 Lever, Michael Washington     DC  
1424 1424 1967-01-20 Embassy of Chile 1963-08-06 CHILE Lever, Michael 1592 1963-01-25 Lever, Michael Washington     DC  
1485 1485 1964-01-24 Embassy of Ecuador 1964-02-04 ECUADOR Lever, Michael 1592 1963-01-25 Lever, Michael Washington     DC  
1952 1952 1948-02-01 Embassy of Venezuela 1947-02-05 VENEZUELA Lever, Michael 435 1947-02-05 Lever, Michael Washington     DC  
9581 9581 1962-07-29 Embassy of Ecuador 1962-07-18 ECUADOR Lever, Michael 1559 1962-07-18 Lever, Michael Washington     DC  
10250 10250 1963-08-10 Embassy of Venezuela 1963-01-25 VENEZUELA Lever, Michael 1592 1963-01-25 Lever, Michael Washington     DC  
11376 11376 1972-09-05 Embassy of Venezuela 1971-08-09 VENEZUELA Lever, Michael 2274 1971-08-09 Lever, Michael Washington     DC  
12301 12301 1956-10-01 Embassy of Costa Rica 1954-11-15 COSTA RICA Lever, Michael 851 1954-11-15 Lever, Michael Washington     DC  
15239 15239 1955-12-20 Embassy of Uruguay 1955-12-12 URUGUAY Lever, Michael 851 1954-11-15 Lever, Michael Washington     DC  
15676 15676 1970-12-31 Embassy of Argentina 1969-02-10 ARGENTINA Lever, Michael 1592 1963-01-25 Lever, Michael Washington     DC  
15677 15677 1970-12-31 Embassy of Mexico, Economic Office 1964-02-04 MEXICO Lever, Michael 1592 1963-01-25 Lever, Michael 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])
);