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

12 rows where Registrant_Name = "Pendleton & McLaughlin"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 4

State 3

Registrant_Name 1

  • Pendleton & McLaughlin · 12 ✖

City 1

  • - 12
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
1700 1700 1975-01-31 Taiwan Sugar Company 1970-12-08 TAIWAN Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Taipei        
2781 2781 1975-02-25 Yacimientos Petroliferos Fiscales 1970-12-08 ARGENTINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Buenos Aires        
6884 6884 1965-05-28 Direccion General de Fabricaciones Militares 1964-05-28 ARGENTINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Buenos Aires        
7359 7359 1973-06-01 Somisa 1973-11-28 ARGENTINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Washington     DC  
11620 11620 1968-09-15 Yacimientos Petroliferos Fiscales 1964-05-28 ARGENTINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Buenos Aires        
14283 14283 1975-11-28 Canned Meat Importers' Association 1968-07-18 ARGENTINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin New York     NY  
14284 14284 1975-11-28 Argentine Government 1964-05-28 ARGENTINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Buenos Aires        
14285 14285 1975-11-28 Chinese Government Procurement & Services Mission Division for Taiwan Sugar Corporation 1974-02-12 TAIWAN Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Taipei        
14286 14286 1975-11-28 Republic of Argentina 1967-12-18 ARGENTINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Buenos Aires        
14287 14287 1975-11-28 Sociedad Mixta Siderurgia Argentina 1964-05-28 ARGENTINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Buenos Aires        
14629 14629 1970-12-01 Chinese Embassy 1970-12-08 CHINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Washington     DC  
15672 15672 1969-12-31 Spain Government 1964-07-10 SPAIN Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Madrid        

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