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

8 rows where City = "Toronto"

View and edit SQL

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

State

  • 8

Country/Location_Represented

City

  • Toronto · 8
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
522   Province of Ontario, Canada 2006-05-17 CANADA 3047 3047 1979-08-09 Foster Garvey PC Ministry of the Attorney General Legal Services Branch, Environment and Energy 10th Floor, 135 St. Clair Ave Toronto    
4496 2011-03-31 Government of Ontario 2006-06-16 CANADA 5754 5754 2006-06-16 PD Frazer Consulting Inc. 135 St. Clair Avenue West 7th Floor   Toronto    
7150 2018-06-02 Government of Ontario 2017-09-13 CANADA 6462 6462 2017-09-13 SKDKnickerbocker, LLC Cabinet Office Communications Room 4420, 4th Floor, Whitney Block 99 Wellesley Street West Toronto    
7727 2018-06-25 Her Majesty The Queen in right of Ontario, as represented by the Cabinet Office 2017-05-31 CANADA 6436 6436 2017-05-31 West Front Strategies, LLC 1075 Bay Street Suite 830 Toronto    
8378 2018-06-30 Peter Maddox, Direct Sellers Association of Canada 2018-03-27 CANADA 6539 6539 2018-03-27 Larkin, Kyle 180 Attwell Drive, Suite 250   Toronto    
9215 2006-07-30 Province of Ontario, Canada Ministry of the Environment 2006-04-18 CANADA 5746 5746 2006-04-18 Biegel Group, Inc. 135 St. Clair Avenue, West M4V 1P5 Toronto    
9216 2006-07-30 Province of Ontario, Canada Ministry of the Environment 2006-04-18 CANADA 5747 5747 2006-04-18 Umansky Network, LLC 135 St. Clair Avenue West M4V 1P5 Toronto    
10656 2007-08-31 Bank of Montreal 2008-02-29 CANADA 5727 5727 2006-01-17 Carmen Group Incorporated 3300 Bloor Street West Centre Tower - 6th Floor Toronto    

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 · Query took 146.659ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history