home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

25 rows where Country/Location_Represented = "ZIMBABWE"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 23

  • Association Films, Inc. 2
  • Farris, Melinda 2
  • Actum International UK Limited 1
  • Air Rhodesia 1
  • Anderson, Hibey & Blair 1
  • Avenue Strategies, LLC 1
  • Ballard Partners 1
  • Barron-Birrell, Inc. 1
  • Chirawu, Teddy O. 1
  • Cohen & Woods International, Inc. 1
  • Dickens & Madson Canada Inc. 1
  • Dow, Lohnes & Albertson 1
  • Dow, Lohnes & Albertson, L.L.P. 1
  • Dube, Kotsho Lloyd 1
  • IPG DXTRA, Inc 1
  • Law Office of Richard Littell 1
  • MDC Zimbabwe 1
  • Marcella Martinez Associates, Inc. 1
  • Mercury Public Affairs, LLC 1
  • Modern Education Services, Inc. 1
  • Purcell & Nelson 1
  • Sanitas International, LLC 1
  • Squire Patton Boggs, LLP 1

Foreign_Principal 22

  • Movement for Democratic Change 2
  • Rhodesian National Tourist Board 2
  • Tobacco Marketing Board of Zimbabwe 2
  • Africa Resources Trust, Zimbabwe Trust 1
  • Government of Zimbabwe, Embassy 1
  • Government of the Republic of Zimbabwe 1
  • MDC Zimbabwe (MDC) 1
  • Minerals Marketing Corporation of Zimbabwe (MMCZ) 1
  • Minister of Foreign Affairs of the Republic of Zimbabwe 1
  • Ministry of Foreign Affairs and International Trade of Zimbabwe 1
  • Ministry of Foreign Affairs and International Trade of Zimbabwe (through Actum International UK Ltd.) (MFA) 1
  • Prime Minister of Zimbabwe 1
  • Republic of Zimbabwe 1
  • Rhodesia National Tourist Board 1
  • Rhodesian Information Service 1
  • South African Democracy Network (SADN) 1
  • Sugar Sales (Private), Ltd. (Rhodesia) 1
  • Sugar Sales (Pvt.), Ltd. 1
  • Zimbabwe African People's Union 1
  • Zimbabwe Democracy Trust 1
  • Zimbabwe Democratic Party 1
  • Zimbabwe National Tourist Office 1

State 4

  • - 20
  • DC 3
  • IL 1
  • NY 1

City 4

  • - 20
  • Harare 2
  • Harrare 2
  • Washington 1

Country/Location_Represented 1

  • ZIMBABWE · 25 ✖
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
1059 1059 1975-01-03 Rhodesia National Tourist Board 1968-02-01 ZIMBABWE Air Rhodesia 2073 1968-02-01 Air Rhodesia Caussway, Salisbury        
1763 1763 1991-01-31 Zimbabwe National Tourist Office 1991-01-24 ZIMBABWE Marcella Martinez Associates, Inc. 4349 1990-03-09 Marcella Martinez Associates, Inc. Causeway        
2254 2254 2021-02-06 Minister of Foreign Affairs of the Republic of Zimbabwe 2019-03-01 ZIMBABWE Ballard Partners 6415 2017-04-05 Ballard Partners 55 Samora Machel Avenue, CBD Harare      
2285 2285 1983-02-08 Rhodesian National Tourist Board 1973-11-16 ZIMBABWE Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
2484 2484 1984-02-14 Tobacco Marketing Board of Zimbabwe 1983-11-10 ZIMBABWE Dow, Lohnes & Albertson 3537 1983-11-10 Dow, Lohnes & Albertson Harare, Zimbabwe        
4040 4040 1980-03-25 Zimbabwe Democratic Party 1979-09-05 ZIMBABWE Chirawu, Teddy O. 3055 1979-09-05 Chirawu, Teddy O. Salisbury        
7296 7296 2022-05-31 Ministry of Foreign Affairs and International Trade of Zimbabwe 2021-11-01 ZIMBABWE Actum International UK Limited 7033 2021-11-01 Actum International UK Limited P.O. Box 4240, Munhumutapa Building, Samora Machel Sam Nujoma Street Harare    
8317 8317 1977-06-30 Rhodesian Information Service 1971-08-24 ZIMBABWE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 2852 McGill Terrace     DC  
8464 8464 1990-06-30 Minerals Marketing Corporation of Zimbabwe (MMCZ) 1987-12-23 ZIMBABWE Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Harare        
8491 8491 1991-06-30 Sugar Sales (Pvt.), Ltd. 1982-04-30 ZIMBABWE Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair Salisbury        
8925 8925 2009-07-01 Prime Minister of Zimbabwe 2009-06-15 ZIMBABWE Farris, Melinda 5942 2009-06-15 Farris, Melinda     Harrare    
8955 8955 1969-07-02 Zimbabwe African People's Union 1966-01-20 ZIMBABWE Dube, Kotsho Lloyd 1953 1966-01-20 Dube, Kotsho Lloyd Lusaka        
9202 9202 2006-07-12 MDC Zimbabwe (MDC) 2006-07-12 ZIMBABWE MDC Zimbabwe 5757 2006-07-12 MDC Zimbabwe Cnr Angwa St./N. Mandela 6th Floor Harvest House Harare    
10038 10038 2001-08-01 Movement for Democratic Change 2001-06-22 ZIMBABWE IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 1900 South Clark Street Chicago 60616     IL  
10061 10061 2019-08-01 Republic of Zimbabwe 2019-04-09 ZIMBABWE Avenue Strategies, LLC 6446 2017-07-24 Avenue Strategies, LLC 1608 New Hampshire Avenue   Washington DC 20009
10972 10972 1984-08-31 Tobacco Marketing Board of Zimbabwe 1983-11-10 ZIMBABWE Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Harare        
12130 12130 2001-09-30 Zimbabwe Democracy Trust 2001-06-18 ZIMBABWE Barron-Birrell, Inc. 5363 1997-12-09 Barron-Birrell, Inc. 16 St. John's Lane London, ECIM 4AF, UK        
12135 12135 2002-09-30 Government of Zimbabwe, Embassy 2000-09-13 ZIMBABWE Cohen & Woods International, Inc. 5003 1995-03-10 Cohen & Woods International, Inc. 1608 New Hampshire Avenue, N.W.     DC  
12157 12157 2004-09-30 Government of the Republic of Zimbabwe 2002-03-14 ZIMBABWE Dickens & Madson Canada Inc. 5485 2002-03-14 Dickens & Madson Canada Inc. President's Department Harare        
12538 12538 2022-10-07 Ministry of Foreign Affairs and International Trade of Zimbabwe (through Actum International UK Ltd.) (MFA) 2019-09-11 ZIMBABWE Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC P.O. Box 4240, Munhumutapa Building Samora Machel Avenue/Sam Nujoma Street Harare      
12730 12730 2007-10-15 Movement for Democratic Change 2007-09-11 ZIMBABWE Farris, Melinda 5828 2007-09-11 Farris, Melinda Harvest House   Harrare    
13464 13464 2013-10-31 South African Democracy Network (SADN) 2013-07-29 ZIMBABWE Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC P.O. Box 91199 Aucland Park 20006 Johannesburg, South Africa      
14108 14108 1967-11-21 Sugar Sales (Private), Ltd. (Rhodesia) 1964-03-23 ZIMBABWE Purcell & Nelson 1702 1964-03-23 Purcell & Nelson Salisbury        
15782 15782 1976-12-31 Rhodesian National Tourist Board 1971-08-24 ZIMBABWE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
16287 16287 1995-12-31 Africa Resources Trust, Zimbabwe Trust 1995-04-14 ZIMBABWE Law Office of Richard Littell 5015 1995-04-14 Law Office of Richard Littell Harare        

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])
);
Powered by Datasette · Queries took 402.758ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows