FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Foreign_Principal_Termination_Date = "1995-10-31"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 11
- Rollins International, Ltd. 2
- Brown Communications, Inc. 1
- Capital Consultants Corporation 1
- Crane, Jonathan A. 1
- Dowling, Langley & Associates 1
- Guatemala FUNDESA Working Group 1
- Harron Ellenson 1
- Jameson, Donald F.B. 1
- Millian, Kenneth Y. 1
- Regional Organization of Liberal Democratic Party of Russia 1
- Shapiro & Olander 1
Foreign_Principal 11
- Government of the Sultanate of Oman (Through Patton Boggs & Blow) 2
- British Broadcasting Corporation 1
- Canadian Pulp & Paper Association 1
- China Chamber of International Commerce 1
- Clark Development Corporation 1
- Embassy of Turkmenistan 1
- FUNDESA (Fundacion para el Desarrollo de Guatemala) 1
- Fortress of Louisbourg, N.H.S. d/b/a Parks Canada 1
- Government of Romania 1
- Liberal Democratic Party of Russia 1
- Moscow State University 1
Country/Location_Represented 9
- CANADA 2
- OMAN 2
- RUSSIA 2
- CHINA 1
- GREAT BRITAIN 1
- GUATEMALA 1
- PHILIPPINES 1
- ROMANIA 1
- TURKMENISTAN 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13337 | 13337 | 1995-10-31 | British Broadcasting Corporation | 1993-10-07 | GREAT BRITAIN | Crane, Jonathan A. 4857 | 1993-10-07 | Crane, Jonathan A. | London | ||||
13338 | 13338 | 1995-10-31 | Canadian Pulp & Paper Association | 1994-10-14 | CANADA | Dowling, Langley & Associates 4965 | 1994-10-14 | Dowling, Langley & Associates | Montreal, Quebec | ||||
13339 | 13339 | 1995-10-31 | China Chamber of International Commerce | 1994-04-15 | CHINA | Rollins International, Ltd. 4908 | 1994-04-15 | Rollins International, Ltd. | Nanjing | ||||
13340 | 13340 | 1995-10-31 | Clark Development Corporation | 1994-12-21 | PHILIPPINES | Rollins International, Ltd. 4908 | 1994-04-15 | Rollins International, Ltd. | Pampanga | ||||
13341 | 13341 | 1995-10-31 | Embassy of Turkmenistan | 1995-04-13 | TURKMENISTAN | Shapiro & Olander 5014 | 1995-04-13 | Shapiro & Olander | Washington | DC | |||
13342 | 13342 | 1995-10-31 | FUNDESA (Fundacion para el Desarrollo de Guatemala) | 1995-04-04 | GUATEMALA | Guatemala FUNDESA Working Group 5007 | 1995-04-04 | Guatemala FUNDESA Working Group | Guatemala City | ||||
13343 | 13343 | 1995-10-31 | Fortress of Louisbourg, N.H.S. d/b/a Parks Canada | 1995-04-04 | CANADA | Harron Ellenson 5009 | 1995-04-30 | Harron Ellenson | Nova Scotia | ||||
13344 | 13344 | 1995-10-31 | Government of Romania | 1995-04-05 | ROMANIA | Brown Communications, Inc. 5008 | 1995-04-05 | Brown Communications, Inc. | Bucharest | ||||
13345 | 13345 | 1995-10-31 | Government of the Sultanate of Oman (Through Patton Boggs & Blow) | 1994-10-06 | OMAN | Jameson, Donald F.B. 4960 | 1994-10-06 | Jameson, Donald F.B. | Muscat | ||||
13346 | 13346 | 1995-10-31 | Government of the Sultanate of Oman (Through Patton Boggs & Blow) | 1994-10-06 | OMAN | Millian, Kenneth Y. 4961 | 1994-10-06 | Millian, Kenneth Y. | Muscat | ||||
13347 | 13347 | 1995-10-31 | Liberal Democratic Party of Russia | 1995-10-02 | RUSSIA | Regional Organization of Liberal Democratic Party of Russia 5054 | 1995-10-02 | Regional Organization of Liberal Democratic Party of Russia | Moscow | ||||
13348 | 13348 | 1995-10-31 | Moscow State University | 1993-10-29 | RUSSIA | Capital Consultants Corporation 4874 | 1993-10-29 | Capital Consultants Corporation | Moscow |
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]) );