FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where State = "MD"
This data as json, CSV (advanced)
Foreign_Principal 10
- Coordination Council for North American Activities 2
- AECL Technologies, Inc. 1
- Bo Zhang 1
- Dalmark Corporation 1
- Ethiopian Medhin Democratic Party 1
- Scott Caruthers, Ambassador at Large, Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine from the Commonwealth of Dominica 1
- Scott Caruthers, Ambassador-at-Large, and Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine, from the Commonwealth of Dominica 1
- Sunbelt Corporation 1
- Tremark Corporation 1
- Zodiac of North America 1
Registrant_Name 9
Country/Location_Represented 8
- DOMINICA 2
- NETHERLANDS ANTILLES 2
- TAIWAN 2
- CANADA 1
- CHINA 1
- ETHIOPIA 1
- FRANCE 1
- INTERNATIONAL 1
City 2
- - 10
- Chevy Chase 1
State 1
- MD · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12617 | 12617 | 1985-10-12 | Coordination Council for North American Activities | 1985-04-18 | TAIWAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | MD | ||||
12701 | 12701 | 1984-10-15 | Zodiac of North America | 1985-05-30 | FRANCE | Parrish & Company, Inc. 3179 | 1980-12-12 | Parrish & Company, Inc. | Stevensville | MD | |||
12957 | 12957 | 1986-10-23 | Coordination Council for North American Activities | 1986-03-18 | TAIWAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | MD | ||||
13466 | 13466 | 2014-10-31 | Bo Zhang | 2013-12-23 | CHINA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 5600 Wisconson Avenue | Apt. 906 | Chevy Chase | MD | 20815 |
13771 | 13771 | 2000-11-06 | Scott Caruthers, Ambassador at Large, Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine from the Commonwealth of Dominica | 2000-05-18 | DOMINICA | Gershberg & Associates, LLC 5370 | 2000-05-18 | Gershberg & Associates, LLC | 597 Scott Drive Westminster | MD | |||
13772 | 13772 | 2000-11-06 | Scott Caruthers, Ambassador-at-Large, and Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine, from the Commonwealth of Dominica | 2000-05-18 | DOMINICA | Pearl, David 5371 | 2000-05-18 | Pearl, David | 597 Scott Drive Westminster, | MD | |||
14167 | 14167 | 1989-11-22 | Sunbelt Corporation | 1988-06-30 | INTERNATIONAL | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Baltimore | MD | |||
15296 | 15296 | 1987-12-21 | Dalmark Corporation | 1987-11-25 | NETHERLANDS ANTILLES | Cole Corette & Abrutyn, P.C. 2968 | 1978-10-18 | Cole Corette & Abrutyn, P.C. | Bethesda | MD | |||
15297 | 15297 | 1987-12-21 | Tremark Corporation | 1987-11-25 | NETHERLANDS ANTILLES | Cole Corette & Abrutyn, P.C. 2968 | 1978-10-18 | Cole Corette & Abrutyn, P.C. | Bethesda | MD | |||
16286 | 16286 | 1995-12-31 | AECL Technologies, Inc. | 1995-10-13 | CANADA | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | Rockville | MD | |||
16531 | 16531 | 2003-12-31 | Ethiopian Medhin Democratic Party | 2003-06-26 | ETHIOPIA | Ethiopian Medhin Democratic Association 5565 | 2003-06-26 | Ethiopian Medhin Democratic Association | 8115 Fenton Street Suite 305 Silver Spring 20910 | MD |
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]) );