FARA_All_RegistrantDocs

List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

215 rows where Foreign_Principal_Country = "QATAR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Foreign_Principal_Name

Document_Type

Foreign_Principal_Country

  • QATAR · 215 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
2910 2910 2015-01-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20150102-7.pdf
3336 3336 2015-01-05 Levick Strategic Communications, LLC 6228 6228 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6228-Exhibit-AB-20150105-3.pdf
3860 3860 2020-01-08 ThirdCircle, Inc. 6540 6540 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6540-Exhibit-AB-20200108-5.pdf
4000 4000 2019-01-09 PAVEA, LLC 6627 6627 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6627-Exhibit-AB-20190109-1.pdf
4242 4242 2018-01-10 Information Management Services, Inc. 6442 6442 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6442-Exhibit-AB-20180110-3.pdf
4995 4995 2015-01-15 Portland PR Inc. 6064 6064 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6064-Exhibit-AB-20150115-5.pdf
5011 5011 2016-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20160115-15.pdf
5957 5957 2019-01-22 ThirdCircle, Inc. 6540 6540 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6540-Exhibit-AB-20190122-2.pdf
6125 6125 2018-01-23 Tigercomm, LLC 6511 6511 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6511-Exhibit-AB-20180123-1.pdf
7836 7836 2017-01-30 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20170130-21.pdf
7896 7896 2019-01-30 Ogilvy Government Relations 6565 6565 Exhibit AB   Embassy of Qatar (through contract with Nelson, Mullins, Riley & Scarborough LLP) QATAR https://efile.fara.gov/docs/6565-Exhibit-AB-20190130-2.pdf
11710 11710 1994-02-01 PATTON BOGGS, L.L.P. 2165 2165 Exhibit AB   GOVERNMENT OF THE STATE OF QATAR QATAR https://efile.fara.gov/docs/2165-Exhibit-AB-19940201-DBKPB503.pdf
12106 12106 2018-02-02 Husch Blackwell Strategies, LLC 6517 6517 Exhibit AB   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6517-Exhibit-AB-20180202-1.pdf
12671 12671 2018-02-05 S.G.R. LLC Government Relations and Lobbying 6379 6379 Exhibit AB   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6379-Exhibit-AB-20180205-6.pdf
12676 12676 2018-02-05 Venable, LLP 5931 5931 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/5931-Exhibit-AB-20180205-7.pdf
13233 13233 2019-02-08 Gallagher Group, LLC 6277 6277 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6277-Exhibit-AB-20190208-11.pdf
13641 13641 2019-02-11 Barzan Aeronautical LLC 6635 6635 Exhibit AB   Barzan Holdings QSTP LLC QATAR https://efile.fara.gov/docs/6635-Exhibit-AB-20190211-1.pdf
13785 13785 2015-02-12 Gallagher Group, LLC 6277 6277 Exhibit AB   Embassy of the State of Qatar (through Portland PR, Inc.) QATAR https://efile.fara.gov/docs/6277-Exhibit-AB-20150212-2.pdf
13961 13961 2017-02-13 Gallagher Group, LLC 6277 6277 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6277-Exhibit-AB-20170213-6.pdf
13969 13969 2018-02-13 Gallagher Group, LLC 6277 6277 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6277-Exhibit-AB-20180213-9.pdf
13977 13977 2019-02-13 Mercury Public Affairs, LLC 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20190213-57.pdf
14459 14459 2018-02-16 Husch Blackwell Strategies, LLC 6517 6517 Informational Materials   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6517-Informational-Materials-20180216-2.pdf
15079 15079 2018-02-20 Iron Bridge Strategies LLC 6497 6497 Exhibit AB   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6497-Exhibit-AB-20180220-3.pdf
15099 15099 2020-02-20 Holland & Knight 3718 3718 Exhibit AB   Embassy of Qatar through Nelson Mullins Riley & Scarborough, LLP QATAR https://efile.fara.gov/docs/3718-Exhibit-AB-20200220-18.pdf
21159 21159 2018-03-01 Portland PR Inc. 6064 6064 Exhibit AB   Education Above All Foundation (through Portland PR Limited (QFC Branch) QATAR https://efile.fara.gov/docs/6064-Exhibit-AB-20180301-13.pdf
21431 21431 2018-03-02 Avenue Strategies Global, LLC 6446 6446 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6446-Exhibit-AB-20180302-3.pdf
21475 21475 2020-03-02 Biggs, Allison 6777 6777 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6777-Exhibit-AB-20200302-3.pdf
22568 22568 2019-03-07 Sitrick Group, LLC 6572 6572 Informational Materials   Embassy of Qatar (through Pillsbury Winthrop Shaw Pittman LLP) QATAR https://efile.fara.gov/docs/6572-Informational-Materials-20190307-1.pdf
23420 23420 1993-03-12 INTERNATIONAL BUSINESS & ECONOMIC RESEARCH CORPORATION 2944 2944 Exhibit AB   COMMITTEE OF READYMADE GARMENT MANUFACTURERS OF QATAR QATAR https://efile.fara.gov/docs/2944-Exhibit-AB-19930312-D07KNO03.pdf
23423 23423 1993-03-12 INTERNATIONAL BUSINESS & ECONOMIC RESEARCH CORPORATION 2944 2944 Exhibit AB   GOVERNMENT OF QATAR QATAR https://efile.fara.gov/docs/2944-Exhibit-AB-19930312-D07KOQ03.pdf
24126 24126 2006-03-15 Hill & Knowlton, Inc. 3301 3301 Exhibit AB   Qatar Foundation QATAR https://efile.fara.gov/docs/3301-Exhibit-AB-20060315-5.pdf
24397 24397 2017-03-16 Levick Strategic Communications, LP 6228 6228 Informational Materials   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6228-Informational-Materials-20170316-1.pdf
24558 24558 2017-03-17 Global Strategies Council, Inc. 6410 6410 Exhibit AB   Kalifa Bin Fahed Bin Mohd Al-Thani QATAR https://efile.fara.gov/docs/6410-Exhibit-AB-20170317-1.pdf
25158 25158 2018-03-20 Nelson Mullins Riley & Scarborough, LLP 5928 5928 Exhibit AB   State of Qatar QATAR https://efile.fara.gov/docs/5928-Exhibit-AB-20180320-33.pdf
25180 25180 2020-03-20 Bridge Builder Communications 6804 6804 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6804-Exhibit-AB-20200320-1.pdf
25182 25182 2020-03-20 Bridge Builder Communications 6804 6804 Informational Materials   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6804-Informational-Materials-20200320-3.pdf
25725 25725 2018-03-23 Pillsbury Winthrop Shaw Pittman, LLP 5198 5198 Exhibit AB   Embassy of Qatar QATAR https://efile.fara.gov/docs/5198-Exhibit-AB-20180323-44.pdf
26118 26118 2020-03-25 Blueprint Advisors LLC 6561 6561 Exhibit AB   State of Qatar QATAR https://efile.fara.gov/docs/6561-Exhibit-AB-20200325-3.pdf
26351 26351 2019-03-26 Portland PR Inc. 6064 6064 Exhibit AB   State of Qatar - Government Communications Office QATAR https://efile.fara.gov/docs/6064-Exhibit-AB-20190326-19.pdf
26353 26353 2019-03-26 ThirdCircle, Inc. 6540 6540 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6540-Exhibit-AB-20190326-3.pdf
26951 26951 1996-03-29 FLEISHMAN-HILLARD, INC. 3774 3774 Exhibit AB   GOVERNMENT OF QATAR, EMBASSY QATAR https://efile.fara.gov/docs/3774-Exhibit-AB-19960329-DR1GFZ04.pdf
27088 27088 2018-03-29 Lumen8 Advisors, LLC 6537 6537 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6537-Exhibit-AB-20180329-1.pdf
27446 27446 2019-03-30 McDermott Will & Emery, LLP 6447 6447 Informational Materials   State of Qatar, Ambassador Sheikh Meshal bin Hamad Al Thani QATAR https://efile.fara.gov/docs/6447-Informational-Materials-20190330-7.pdf
31990 31990 2018-04-02 Ballard Partners 6415 6415 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6415-Exhibit-AB-20180402-9.pdf
32036 32036 2020-04-02 Waltham PLLC 6771 6771 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6771-Exhibit-AB-20200402-2.pdf
32874 32874 2020-04-06 Nelson Mullins Riley & Scarborough, LLP 5928 5928 Exhibit AB   State of Qatar QATAR https://efile.fara.gov/docs/5928-Exhibit-AB-20200406-46.pdf
33041 33041 2016-04-07 Portland PR Inc. 6064 6064 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6064-Exhibit-AB-20160407-6.pdf
33057 33057 2020-04-07 JWI, LLC 4990 4990 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/4990-Exhibit-AB-20200407-34.pdf
33272 33272 2016-04-08 Gallagher Group, LLC 6277 6277 Exhibit AB   Embassy of the State of Qatar (through Portland PR, Inc.) QATAR https://efile.fara.gov/docs/6277-Exhibit-AB-20160408-4.pdf
33287 33287 2019-04-08 Blueprint Advisors LLC 6561 6561 Exhibit AB   State of Qatar, Embassy QATAR https://efile.fara.gov/docs/6561-Exhibit-AB-20190408-2.pdf
33559 33559 2020-04-09 RF Binder Partners Inc. 6814 6814 Exhibit AB   Qatar Foundation through Memac Ogilvy & Mather LLC QATAR https://efile.fara.gov/docs/6814-Exhibit-AB-20200409-1.pdf
34253 34253 2017-04-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20170413-27.pdf
35090 35090 2020-04-17 RF Binder Partners Inc. 6814 6814 Informational Materials   Qatar Foundation through Memac Ogilvy & Mather LLC QATAR https://efile.fara.gov/docs/6814-Informational-Materials-20200417-1.pdf
35562 35562 1992-04-21 EVANS III, WALTER H. 4662 4662 Exhibit AB   EMBASSY OF QATAR QATAR https://efile.fara.gov/docs/4662-Exhibit-AB-19920421-D1XXYN02.pdf
36685 36685 2017-04-26 Gallagher Group, LLC 6277 6277 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6277-Exhibit-AB-20170426-7.pdf
38312 38312 2018-04-30 Myriad Creative 6549 6549 Exhibit AB   Qatar Tourism Authority QATAR https://efile.fara.gov/docs/6549-Exhibit-AB-20180430-10.pdf
38413 38413 2019-04-30 S.G.R. LLC Government Relations and Lobbying 6379 6379 Informational Materials   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6379-Informational-Materials-20190430-6.pdf
38464 38464 2020-04-30 RF Binder Partners Inc. 6814 6814 Informational Materials   Qatar Foundation through Memac Ogilvy & Mather LLC QATAR https://efile.fara.gov/docs/6814-Informational-Materials-20200430-2.pdf
41709 41709 2020-05-01 Ballard Partners 6415 6415 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6415-Exhibit-AB-20200501-20.pdf
42311 42311 2020-05-04 Venable, LLP 5931 5931 Informational Materials   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/5931-Informational-Materials-20200504-4.pdf
42580 42580 2020-05-06 RF Binder Partners Inc. 6814 6814 Informational Materials   Qatar Foundation through Memac Ogilvy & Mather LLC QATAR https://efile.fara.gov/docs/6814-Informational-Materials-20200506-3.pdf
43032 43032 2019-05-08 Hurd, James Daniel 6674 6674 Exhibit AB   Government Communications Office of the State of Qatar (QCO) QATAR https://efile.fara.gov/docs/6674-Exhibit-AB-20190508-1.pdf
43068 43068 2020-05-08 Proof Strategies Inc. 6822 6822 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6822-Exhibit-AB-20200508-1.pdf
43242 43242 2018-05-09 Stonington Strategies, LLC 6458 6458 Informational Materials   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6458-Informational-Materials-20180509-1.pdf
44050 44050 2020-05-13 RF Binder Partners Inc. 6814 6814 Informational Materials   Qatar Foundation through Memac Ogilvy & Mather LLC QATAR https://efile.fara.gov/docs/6814-Informational-Materials-20200513-4.pdf
44246 44246 2020-05-14 Bridge Builder Communications 6804 6804 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6804-Exhibit-AB-20200514-2.pdf
44891 44891 2018-05-17 Stonington Strategies, LLC 6458 6458 Informational Materials   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6458-Informational-Materials-20180517-2.pdf
45922 45922 2020-05-22 Bridge Builder Communications 6804 6804 Informational Materials   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6804-Informational-Materials-20200522-4.pdf
47145 47145 2020-05-28 Nelson Mullins Riley & Scarborough, LLP 5928 5928 Informational Materials   State of Qatar QATAR https://efile.fara.gov/docs/5928-Informational-Materials-20200528-19.pdf
47418 47418 2020-05-29 Qatar-America Institute 6829 6829 Exhibit AB   The State of Qatar, including through the Embassy of Qatar, Qatar National Tourism Council, and Supreme Committee for Delivery and Legacy QATAR https://efile.fara.gov/docs/6829-Exhibit-AB-20200529-1.pdf
47420 47420 2020-05-29 Qatar-America Institute 6829 6829 Informational Materials   The State of Qatar, including through the Embassy of Qatar, Qatar National Tourism Council, and Supreme Committee for Delivery and Legacy QATAR https://efile.fara.gov/docs/6829-Informational-Materials-20200529-3.pdf
48365 48365 2018-05-31 Debevoise & Plimpton LLP 6560 6560 Exhibit AB   State of Qatar QATAR https://efile.fara.gov/docs/6560-Exhibit-AB-20180531-1.pdf
53240 53240 2018-06-01 Blueprint Advisors LLC 6561 6561 Exhibit AB   State of Qatar QATAR https://efile.fara.gov/docs/6561-Exhibit-AB-20180601-1.pdf
53821 53821 2020-06-04 Coast to Coast Strategies, LLC 6833 6833 Exhibit AB   Qatar American Institute QATAR https://efile.fara.gov/docs/6833-Exhibit-AB-20200604-1.pdf
53823 53823 2020-06-04 Coast to Coast Strategies, LLC 6833 6833 Informational Materials   Qatar American Institute QATAR https://efile.fara.gov/docs/6833-Informational-Materials-20200604-1.pdf
54412 54412 2018-06-07 McDermott Will & Emery, LLP 6447 6447 Informational Materials   State of Qatar, Ambassador Sheikh Meshal bin Hamad Al Thani QATAR https://efile.fara.gov/docs/6447-Informational-Materials-20180607-1.pdf
54769 54769 2017-06-09 Ashcroft Law Firm, LLC 6438 6438 Exhibit AB   The Goverment of Qatar QATAR https://efile.fara.gov/docs/6438-Exhibit-AB-20170609-3.pdf
54971 54971 2010-06-10 Fenton Communications 5945 5945 Exhibit AB   Office of Her Highness Sheikha Mozah Bint Nasser Al-Missned QATAR https://efile.fara.gov/docs/5945-Exhibit-AB-20100610-6.pdf
55174 55174 2018-06-11 Nelson Mullins Riley & Scarborough, LLP 5928 5928 Exhibit AB   State of Qatar QATAR https://efile.fara.gov/docs/5928-Exhibit-AB-20180611-38.pdf
55874 55874 2018-06-15 Lexington Strategies, LLC 6563 6563 Exhibit AB   State of Qatar and Qatar Supreme Committee for Delivery and Legacy QATAR https://efile.fara.gov/docs/6563-Exhibit-AB-20180615-2.pdf
55878 55878 2018-06-15 Portland PR Inc. 6064 6064 Exhibit AB   State of Qatar - Government Communications Office QATAR https://efile.fara.gov/docs/6064-Exhibit-AB-20180615-15.pdf
56017 56017 2017-06-16 Levick Strategic Communications, LP 6228 6228 Exhibit AB   Government Communications Office (GCO) of the State of Qatar QATAR https://efile.fara.gov/docs/6228-Exhibit-AB-20170616-10.pdf
56215 56215 2020-06-17 RF Binder Partners Inc. 6814 6814 Informational Materials   Qatar Foundation through Memac Ogilvy & Mather LLC QATAR https://efile.fara.gov/docs/6814-Informational-Materials-20200617-5.pdf
56887 56887 2018-06-21 Ogilvy Government Relations 6565 6565 Exhibit AB   Embassy of Qatar (through contract with Nelson, Mullins, Riley & Scarborough LLP) QATAR https://efile.fara.gov/docs/6565-Exhibit-AB-20180621-1.pdf
57092 57092 2018-06-22 Reed, T. Dean 5044 5044 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/5044-Exhibit-AB-20180622-5.pdf
57290 57290 2020-06-23 Bridge Builder Communications 6804 6804 Informational Materials   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6804-Informational-Materials-20200623-5.pdf
58706 58706 2017-06-29 Information Management Services, Inc. 6442 6442 Exhibit AB   Government Communications Office of the State of Qatar QATAR https://efile.fara.gov/docs/6442-Exhibit-AB-20170629-1.pdf
58723 58723 2018-06-29 Ballard Partners 6415 6415 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6415-Exhibit-AB-20180629-14.pdf
59904 59904 2008-06-30 Hill & Knowlton, Inc. 3301 3301 Exhibit AB   Qatar Financial Centre Authority (through Hill & Knowlton Qatar LLC) QATAR https://efile.fara.gov/docs/3301-Exhibit-AB-20080630-18.pdf
63344 63344 2015-07-02 Levick Strategic Communications, LLC 6228 6228 Exhibit AB   Embassy of Qatar QATAR https://efile.fara.gov/docs/6228-Exhibit-AB-20150702-5.pdf
64248 64248 2020-07-08 RF Binder Partners Inc. 6814 6814 Informational Materials   Qatar Foundation through Memac Ogilvy & Mather LLC QATAR https://efile.fara.gov/docs/6814-Informational-Materials-20200708-6.pdf
64249 64249 2020-07-08 RF Binder Partners Inc. 6814 6814 Informational Materials   Qatar Foundation through Memac Ogilvy & Mather LLC QATAR https://efile.fara.gov/docs/6814-Informational-Materials-20200708-7.pdf
64897 64897 2018-07-12 McDermott Will & Emery, LLP 6447 6447 Informational Materials   State of Qatar, Ambassador Sheikh Meshal bin Hamad Al Thani QATAR https://efile.fara.gov/docs/6447-Informational-Materials-20180712-8.pdf
65032 65032 2017-07-13 Conover + Gould Strategic Communications, Inc. 6205 6205 Exhibit AB   Government Communications Office of the State of Qatar through Information Management Services, Inc. QATAR https://efile.fara.gov/docs/6205-Exhibit-AB-20170713-7.pdf
65049 65049 2018-07-13 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Informational-Materials-20180713-21.pdf
65053 65053 2018-07-13 Sitrick Group, LLC 6572 6572 Exhibit AB   Embassy of Qatar (through Pillsbury Winthrop Shaw Pittman LLP) QATAR https://efile.fara.gov/docs/6572-Exhibit-AB-20180713-1.pdf
65168 65168 2003-07-14 Hogan & Hartson, L.L.P. 2244 2244 Exhibit AB   Government of Qatar, Embassy QATAR https://efile.fara.gov/docs/2244-Exhibit-AB-20030714-HI6Q1401.pdf
65195 65195 2011-07-14 Brown Lloyd James 5875 5875 Exhibit AB   Shafallah Center for Children with Special Needs QATAR https://efile.fara.gov/docs/5875-Exhibit-AB-20110714-24.pdf
65196 65196 2011-07-14 Brown Lloyd James 5875 5875 Exhibit AB   State of Qatar QATAR https://efile.fara.gov/docs/5875-Exhibit-AB-20110714-21.pdf
65408 65408 2018-07-15 McDermott Will & Emery, LLP 6447 6447 Informational Materials   State of Qatar, Ambassador Sheikh Meshal bin Hamad Al Thani QATAR https://efile.fara.gov/docs/6447-Informational-Materials-20180715-2.pdf

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_RegistrantDocs] (
   [Date_Stamped] TEXT,
   [Registrant_Name] TEXT,
   [Registration_Number] INTEGER,
   [Document_Type] TEXT,
   [Short_Form_Name] TEXT,
   [Foreign_Principal_Name] TEXT,
   [Foreign_Principal_Country] TEXT,
   [URL] TEXT,
   FOREIGN KEY(Registration_Number) REFERENCES FARA_All_Registrants(Registration_Number)
);
Powered by Datasette · Query took 659.758ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history