home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_RegistrantDocs

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

79 rows where Document_Type = "Exhibit AB" and Foreign_Principal_Country = "LIBYA"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name >30

  • Adams Jones Law Firm, P.A. 4
  • Dickens & Madson Canada Inc. 4
  • Livingston Group, LLC 4
  • Mercury Public Affairs, LLC 4
  • Brown Lloyd James 3
  • Harbour Group, LLC 3
  • Fahmy Hudome International, LLC 2
  • Gerstman Schwartz LLP 2
  • Grassroots Political Consulting LLC 2
  • Keystone Strategic Advisers, LLC 2
  • Mayer Brown, LLP 2
  • Patton Boggs, LLP 2
  • W2 Group, Inc. 2
  • WILLIAM CHASEY ORGANIZATION 2
  • WOOD, RANDELL K. 2
  • AUX Initiatives, LLC 1
  • Actum International UK Limited 1
  • Alexandria Group International 1
  • Anthony Podesta, dba Podesta.com 1
  • Arab Information Center 1
  • BGR Government Affairs, LLC 1
  • Baker & Hostetler LLP 1
  • Ben Barnes Group 1
  • Blank Rome, LLP 1
  • Brownstein Hyatt Farber Schreck, LLP 1
  • Daniel J. Edelman, Inc. 1
  • Diplomatic Trade Ltd. 1
  • Franklin Partnership 1
  • Gotham Government Relations 1
  • Greenberg Traurig, LLP 1
  • …

Foreign_Principal_Name >30

  • GOVERNMENT OF LIBYA 3
  • General People's Committee of Libya 3
  • Government of Libya 3
  • Great Socialist People's Libyan Arab Jamahiriya 3
  • Khalifa Haftar 3
  • Embassy of Libya 2
  • Fathi Bashagha 2
  • Gaddafi International Charity and Development Foundation 2
  • Government of National Accord Libya, Office of the Prime Minister 2
  • Governor of Eastern Libya 2
  • Khaled Khalifa Hifter 2
  • Libyan Asset Recovery and Management Office 2
  • Libyan Investment Authority 2
  • National Oil Corporation 2
  • Tri-Star International Trading, Co. 2
  • Anayurt Libya Co.in Support of Unified Libya Movement 1
  • Anyurt-Libya Co. 1
  • Anyurt-Libya Co. through Dickens & Madson Canada, Inc. 1
  • Anyurt-Libya Co. thru Dickens & Madson Canada in Support of Unified Libya Movement 1
  • Basit Igtet 1
  • COUNTRY OF LIBYA 1
  • Cyrenaica Transitional Council Ibrihim Said al-Jathran Political Bureau of Cyrenaica Usama Buera 1
  • Decision Support Center of Libya (on behalf of the Libyan National Army) 1
  • Dr. Bashir Musa 1
  • Fathi Bashaghi 1
  • General People's Committee for Manpower, Training and Employment 1
  • Government of Cyrenaica Ibrihim Said al-Jathran Usama Buera 1
  • Government of Libya (Unity/Transition) PM Abdulhamid Dababiah 1
  • Government of National Accord (GNA) 1
  • Government of National Accord Libya, Office of the Deputy Prime Minister 1
  • …

Foreign_Principal_Country 1

  • LIBYA · 79 ✖

Document_Type 1

  • Exhibit AB · 79 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
14628 14628 2008-02-06 Blank Rome, LLP Blank Rome, LLP 4929 Exhibit AB   Socialist People's Libyan Arab Jamahiriya (Libya) LIBYA https://efile.fara.gov/docs/4929-Exhibit-AB-20080206-2.pdf
18362 18362 2023-02-23 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   National Oil Corporation LIBYA https://efile.fara.gov/docs/6170-Exhibit-AB-20230223-118.pdf
19222 19222 2006-02-27 International Relief Fund, Inc. International Relief Fund, Inc.  5703 Exhibit AB   Prof Eng. Matoug M. Matoug Secretary of General People's Committee for Manpower, Training and Employment LIBYA https://efile.fara.gov/docs/5703-Exhibit-AB-20060227-2.pdf
19287 19287 2009-02-27 Livingston Group, LLC Livingston Group, LLC 5356 Exhibit AB   Gaddafi International Charity and Development Foundation LIBYA https://efile.fara.gov/docs/5356-Exhibit-AB-20090227-14.pdf
24726 24726 1955-03-03 Arab Information Center Arab Information Center 876 Exhibit AB   United Kingdom of Libya LIBYA https://efile.fara.gov/docs/876-Exhibit-AB-19550303-HBR4W605.pdf
25032 25032 2023-03-03 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   National Oil Corporation LIBYA https://efile.fara.gov/docs/6170-Exhibit-AB-20230303-119.pdf
25927 25927 2008-03-07 White & Case, LLP White & Case, LLP 2759 Exhibit AB   Great Socialist People's Libyan Arab Jamahiriya LIBYA https://efile.fara.gov/docs/2759-Exhibit-AB-20080307-14.pdf
26805 26805 2015-03-10 Sanitas International, LLC Sanitas International, LLC 5963 Exhibit AB   Libya Institute of Advanced Studies (LIAS) LIBYA https://efile.fara.gov/docs/5963-Exhibit-AB-20150310-11.pdf
29767 29767 2008-03-21 Livingston Group L.L.C. Livingston Group, LLC 5356 Exhibit AB   Great Socialist People's Libyan Arab Jamahiriya LIBYA https://efile.fara.gov/docs/5356-Exhibit-AB-20080321-11.pdf
29782 29782 2014-03-21 Daniel J. Edelman, Inc. Daniel J. Edelman, Inc. 3634 Exhibit AB   Libyan Investment Authority thru Enyo Law LLP LIBYA https://efile.fara.gov/docs/3634-Exhibit-AB-20140321-38.pdf
31832 31832 2012-03-29 Harbour Group, LLC Harbour Group, LLC 5478 Exhibit AB   Libyan National Transitional Council/Embassy of Libya LIBYA https://efile.fara.gov/docs/5478-Exhibit-AB-20120329-12.pdf
33424 33424 2021-03-31 Diplomatic Trade Ltd. Diplomatic Trade Ltd. 6932 Exhibit AB   Government of Libya (Unity/Transition) PM Abdulhamid Dababiah LIBYA https://efile.fara.gov/docs/6932-Exhibit-AB-20210331-3.pdf
37457 37457 2015-04-03 MSLGROUP Americas, Inc. QORVIS LLC 5483 Exhibit AB   Embassy of Libya LIBYA https://efile.fara.gov/docs/5483-Exhibit-AB-20150403-42.pdf
37466 37466 2016-04-03 Alexandria Group International Alexandria Group International, LLC 6347 Exhibit AB   H.E. Aly Abuzaakouk Foreign Minister, Foreign Ministry of Libya LIBYA https://efile.fara.gov/docs/6347-Exhibit-AB-20160403-1.pdf
37517 37517 2023-04-03 Jonathan Dart Jonathan Dart 7253 Exhibit AB   Libyan Asset Recovery and Management Office LIBYA https://efile.fara.gov/docs/7253-Exhibit-AB-20230403-1.pdf
38212 38212 2011-04-06 Harbour Group, LLC Harbour Group, LLC 5478 Exhibit AB   Transitional National Council/The Libyan Interim National Council LIBYA https://efile.fara.gov/docs/5478-Exhibit-AB-20110406-9.pdf
38223 38223 2012-04-06 W2 Group, Inc. W2 Group, Inc. 6055 Exhibit AB   General People's Committee of Libya LIBYA https://efile.fara.gov/docs/6055-Exhibit-AB-20120406-4.pdf
38831 38831 2021-04-08 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Exhibit-AB-20210408-96.pdf
39610 39610 2023-04-11 Steven Walton Kay Steven Walton Kay 7257 Exhibit AB   Libya Asset Recovery Management Office LIBYA https://efile.fara.gov/docs/7257-Exhibit-AB-20230411-1.pdf
40542 40542 2022-04-15 Anthony Podesta, dba Podesta.com Anthony Podesta, dba Podesta.com 7108 Exhibit AB   Tala Elemary Consulting Middle East, on behalf of Government of Libya LIBYA https://efile.fara.gov/docs/7108-Exhibit-AB-20220415-1.pdf
40756 40756 2015-04-16 Greenberg Traurig, LLP Greenberg Traurig, LLP 5712 Exhibit AB   Libya Institute of Advanced Studies (LIAS) via Sanitas International LIBYA https://efile.fara.gov/docs/5712-Exhibit-AB-20150416-20.pdf
41768 41768 2011-04-21 Transitional National Council of Libya, Office of the Representative to the United States Transitional National Council of Libya, Office of the Representative to the United States 6035 Exhibit AB   Transitional National Council of Libya LIBYA https://efile.fara.gov/docs/6035-Exhibit-AB-20110421-1.pdf
43069 43069 2019-04-26 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Exhibit-AB-20190426-66.pdf
46741 46741 1988-05-01 WOOD, RANDELL K. Wood, Randell K. 4143 Exhibit AB   COUNTRY OF LIBYA LIBYA https://efile.fara.gov/docs/4143-Exhibit-AB-19880501-D1K5SW02.pdf
48846 48846 2019-05-02 Prime Policy Group Prime Policy Group 6377 Exhibit AB   Government of National Accord Libya, Office of the Deputy Prime Minister LIBYA https://efile.fara.gov/docs/6377-Exhibit-AB-20190502-8.pdf
49782 49782 2011-05-06 Monitor Company Group LP Monitor Company Group LP 6037 Exhibit AB   General People's Committee of Libya LIBYA https://efile.fara.gov/docs/6037-Exhibit-AB-20110506-1.pdf
52203 52203 2013-05-15 Patton Boggs, LLP Squire Patton Boggs, LLP 2165 Exhibit AB   Government of Libya LIBYA https://efile.fara.gov/docs/2165-Exhibit-AB-20130515-47.pdf
52663 52663 2005-05-17 Fahmy Hudome International, LLC Fahmy Hudome International, LLC 5632 Exhibit AB   Government of Libya LIBYA https://efile.fara.gov/docs/5632-Exhibit-AB-20050517-1.pdf
53228 53228 2019-05-19 Linden Government Solutions, LLC Linden Government Solutions, LLC 6682 Exhibit AB   Decision Support Center of Libya (on behalf of the Libyan National Army) LIBYA https://efile.fara.gov/docs/6682-Exhibit-AB-20190519-1.pdf
55202 55202 2009-05-27 Livingston Group, LLC Livingston Group, LLC 5356 Exhibit AB   Great Socialist People's Libyan Arab Jamahiriya LIBYA https://efile.fara.gov/docs/5356-Exhibit-AB-20090527-20.pdf
55276 55276 2021-05-27 Baker & Hostetler LLP Baker & Hostetler LLP 6966 Exhibit AB   Libya Asset Recovery & Management Office ("LARMO") LIBYA https://efile.fara.gov/docs/6966-Exhibit-AB-20210527-1.pdf
55624 55624 2021-05-28 Holland & Knight Holland & Knight 3718 Exhibit AB   Libyan Asset Recovery and Management Office LIBYA https://efile.fara.gov/docs/3718-Exhibit-AB-20210528-25.pdf
56996 56996 2018-05-31 Grassroots Political Consulting LLC Grassroots Political Consulting LLC 6483 Exhibit AB   Khaled Khalifa Hifter LIBYA https://efile.fara.gov/docs/6483-Exhibit-AB-20180531-4.pdf
65666 65666 2008-06-17 Brown Lloyd James BLJ Worldwide LTD 5875 Exhibit AB   Hassan Tatanaki - Challenger Limited LIBYA https://efile.fara.gov/docs/5875-Exhibit-AB-20080617-2.pdf
67208 67208 2011-06-24 Patton Boggs, LLP Squire Patton Boggs, LLP 2165 Exhibit AB   Interim Transitional National Council of Libya LIBYA https://efile.fara.gov/docs/2165-Exhibit-AB-20110624-30.pdf
73666 73666 2021-07-02 Brownstein Hyatt Farber Schreck, LLP Brownstein Hyatt Farber Schreck, LLP 5870 Exhibit AB   Fathi Bashaghi LIBYA https://efile.fara.gov/docs/5870-Exhibit-AB-20210702-22.pdf
74236 74236 2018-07-06 Mayer Brown, LLP Mayer Brown, LLP 6236 Exhibit AB   Tri-Star International Trading, Co. LIBYA https://efile.fara.gov/docs/6236-Exhibit-AB-20180706-2.pdf
76470 76470 2004-07-16 Fahmy Hudome International, LLC Fahmy Hudome International, LLC 5632 Exhibit AB   Government of Libya LIBYA https://efile.fara.gov/docs/5632-Exhibit-AB-20040716-I17UMB04.pdf
77400 77400 2016-07-20 Adams Jones Law Firm, P.A. Adams Jones Law Firm, P.A. 6202 Exhibit AB   Libya HOR, President Agilah Saleh Issa thru Dickens & Madson Canada, Inc. LIBYA https://efile.fara.gov/docs/6202-Exhibit-AB-20160720-4.pdf
77405 77405 2016-07-20 Dickens & Madson Canada Inc. Dickens & Madson Canada Inc. 6200 Exhibit AB   Libya House of Representatives, President Agilah Saleh Issa LIBYA https://efile.fara.gov/docs/6200-Exhibit-AB-20160720-4.pdf
80496 80496 2018-07-30 Mayer Brown, LLP Mayer Brown, LLP 6236 Exhibit AB   Tri-Star International Trading, Co. LIBYA https://efile.fara.gov/docs/6236-Exhibit-AB-20180730-3.pdf
85430 85430 2014-08-04 AUX Initiatives, LLC AUX Initiatives, LLC 6238 Exhibit AB   Dr. Bashir Musa LIBYA https://efile.fara.gov/docs/6238-Exhibit-AB-20140804-2.pdf
86344 86344 2005-08-08 Mena Cultural and Communication Center, Inc. Mena Cultural and Communication Center, Inc. 5702 Exhibit AB   The World Center for the Studies and Research of the Green Book/The Qaddafi LIBYA https://efile.fara.gov/docs/5702-Exhibit-AB-20050808-1.pdf
87239 87239 2011-08-12 W2 Group, Inc. W2 Group, Inc. 6055 Exhibit AB   General People's Committee of Libya LIBYA https://efile.fara.gov/docs/6055-Exhibit-AB-20110812-3.pdf
87990 87990 2019-08-16 Gerstman Schwartz LLP Gerstman Schwartz LLP 6708 Exhibit AB   Libyan Investment Authority LIBYA https://efile.fara.gov/docs/6708-Exhibit-AB-20190816-2.pdf
88149 88149 2011-08-17 Brown Lloyd James BLJ Worldwide LTD 5875 Exhibit AB   Socialist People's Libyan Arab Jamahiriya LIBYA https://efile.fara.gov/docs/5875-Exhibit-AB-20110817-31.pdf
88150 88150 2011-08-17 Brown Lloyd James BLJ Worldwide LTD 5875 Exhibit AB   Hassan Tatanaki, Challenger Limited LIBYA https://efile.fara.gov/docs/5875-Exhibit-AB-20110817-32.pdf
94287 94287 1992-09-01 MURPHY, JOHN M. Murphy, John M. 4679 Exhibit AB   HASSAN TATANAKI LIBYA https://efile.fara.gov/docs/4679-Exhibit-AB-19920901-D1Y9PR02.pdf
95014 95014 2009-09-01 Hopps & Associates, Inc. Hopps & Associates, Inc. 5948 Exhibit AB   Mission of Libya to the UN LIBYA https://efile.fara.gov/docs/5948-Exhibit-AB-20090901-2.pdf
95267 95267 2021-09-02 BGR Government Affairs, LLC BGR Government Affairs, LLC 5430 Exhibit AB   Fathi Bashagha LIBYA https://efile.fara.gov/docs/5430-Exhibit-AB-20210902-98.pdf
95459 95459 2021-09-03 Lanny J. Davis & Associates PLLC Lanny J. Davis & Associates PLLC 7010 Exhibit AB   Khalifa Haftar LIBYA https://efile.fara.gov/docs/7010-Exhibit-AB-20210903-1.pdf
95463 95463 2021-09-03 Livingston Group, LLC Livingston Group, LLC 6344 Exhibit AB   Khalifa Haftar LIBYA https://efile.fara.gov/docs/6344-Exhibit-AB-20210903-18.pdf
95621 95621 2021-09-04 Rawlings International Advisory Group, LLC Rawlings International Advisory Group, LLC 7011 Exhibit AB   Khalifa Haftar LIBYA https://efile.fara.gov/docs/7011-Exhibit-AB-20210904-1.pdf
96893 96893 2019-09-10 Sanitas International, Inc. Sanitas International, Inc. 6530 Exhibit AB   Libya Institute for Advanced Studies (LIAS) LIBYA https://efile.fara.gov/docs/6530-Exhibit-AB-20190910-10.pdf
98718 98718 2009-09-18 Livingston Group, LLC Livingston Group, LLC 5356 Exhibit AB   Gaddafi International Charity and Development Foundation LIBYA https://efile.fara.gov/docs/5356-Exhibit-AB-20090918-21.pdf
100697 100697 2019-09-26 Gotham Government Relations Gotham Government Relations 6728 Exhibit AB   Government of National Accord (GNA) LIBYA https://efile.fara.gov/docs/6728-Exhibit-AB-20190926-2.pdf
106658 106658 2019-10-04 Gerstman Schwartz LLP Gerstman Schwartz LLP 6708 Exhibit AB   Libyan Investment Authority LIBYA https://efile.fara.gov/docs/6708-Exhibit-AB-20191004-3.pdf
116123 116123 1992-11-01 INTERNATIONAL COMMUNICATIONS MARKETING, INC. (ICM) International Communications Marketing, Inc. (ICM) 4733 Exhibit AB   GOVERNMENT OF LIBYA LIBYA https://efile.fara.gov/docs/4733-Exhibit-AB-19921101-D1XSB502.pdf
116270 116270 1992-11-01 WILLIAM CHASEY ORGANIZATION William Chasey 4221 Exhibit AB   GOVERNMENT OF LIBYA LIBYA https://efile.fara.gov/docs/4221-Exhibit-AB-19921101-D1M16802.pdf
116765 116765 2017-11-01 Grassroots Political Consulting LLC Grassroots Political Consulting LLC 6483 Exhibit AB   Khaled Khalifa Hifter LIBYA https://efile.fara.gov/docs/6483-Exhibit-AB-20171101-2.pdf
116796 116796 2021-11-01 Actum International UK Limited Actum International UK Limited 7033 Exhibit AB   Government of National Unity of Libya LIBYA https://efile.fara.gov/docs/7033-Exhibit-AB-20211101-2.pdf
117471 117471 2011-11-04 Franklin Partnership Franklin Partnership 6075 Exhibit AB   Libya Al Hurra Foundation LIBYA https://efile.fara.gov/docs/6075-Exhibit-AB-20111104-1.pdf
118657 118657 2014-11-10 Adams Jones Law Firm, P.A. Adams Jones Law Firm, P.A. 6202 Exhibit AB   Anyurt-Libya Co. through Dickens & Madson Canada, Inc. LIBYA https://efile.fara.gov/docs/6202-Exhibit-AB-20141110-2.pdf
118660 118660 2014-11-10 Dickens & Madson Canada Inc. Dickens & Madson Canada Inc. 6200 Exhibit AB   Anyurt-Libya Co. LIBYA https://efile.fara.gov/docs/6200-Exhibit-AB-20141110-2.pdf
118671 118671 2014-11-10 Washington African Consulting Group, Inc. Washington African Consulting Group, Inc. 6261 Exhibit AB   National Board for the Following -Up and Recovering of the Libyan Looted and Disguised Funds LIBYA https://efile.fara.gov/docs/6261-Exhibit-AB-20141110-1.pdf
120250 120250 2021-11-17 Marathon Strategies LLC Marathon Strategies LLC 7000 Exhibit AB   Fathi Bashagha LIBYA https://efile.fara.gov/docs/7000-Exhibit-AB-20211117-2.pdf
120645 120645 2013-11-19 Kasowitz, Benson, Torres and Friedman, LLP Kasowitz, Benson, Torres and Friedman, LLP 6197 Exhibit AB   Basit Igtet LIBYA https://efile.fara.gov/docs/6197-Exhibit-AB-20131119-1.pdf
121587 121587 2014-11-24 Adams Jones Law Firm, P.A. Adams Jones Law Firm, P.A. 6202 Exhibit AB   Anyurt-Libya Co. thru Dickens & Madson Canada in Support of Unified Libya Movement LIBYA https://efile.fara.gov/docs/6202-Exhibit-AB-20141124-3.pdf
121591 121591 2014-11-24 Dickens & Madson Canada Inc. Dickens & Madson Canada Inc. 6200 Exhibit AB   Anayurt Libya Co.in Support of Unified Libya Movement LIBYA https://efile.fara.gov/docs/6200-Exhibit-AB-20141124-3.pdf
121710 121710 2005-11-25 International Relief Fund, Inc. DBA International Forum Institute, Inc. International Relief Fund, Inc.  5703 Exhibit AB   General People's Committee for Manpower, Training and Employment LIBYA https://efile.fara.gov/docs/5703-Exhibit-AB-20051125-1.pdf
126544 126544 1990-12-01 WOOD, RANDELL K. Wood, Randell K. 4143 Exhibit AB   LIBYA LIBYA https://efile.fara.gov/docs/4143-Exhibit-AB-19901201-D1JQZN02.pdf
127760 127760 1992-12-01 WILLIAM CHASEY ORGANIZATION William Chasey 4221 Exhibit AB   GOVERNMENT OF LIBYA LIBYA https://efile.fara.gov/docs/4221-Exhibit-AB-19921201-D1MV1G02.pdf
128363 128363 2017-12-01 Keystone Strategic Advisers, LLC Keystone Strategic Advisers, LLC 6494 Exhibit AB   Governor of Eastern Libya LIBYA https://efile.fara.gov/docs/6494-Exhibit-AB-20171201-1.pdf
128818 128818 2014-12-03 Ben Barnes Group Ben Barnes Group 6264 Exhibit AB   National Board for Following-Up and Recovering of the Libyan Looted and Disguised Funds LIBYA https://efile.fara.gov/docs/6264-Exhibit-AB-20141203-1.pdf
130344 130344 2013-12-11 Dickens & Madson Canada Inc. Dickens & Madson Canada Inc. 6200 Exhibit AB   Cyrenaica Transitional Council Ibrihim Said al-Jathran Political Bureau of Cyrenaica Usama Buera LIBYA https://efile.fara.gov/docs/6200-Exhibit-AB-20131211-1.pdf
132241 132241 2013-12-20 Adams Jones Law Firm, P.A. Adams Jones Law Firm, P.A. 6202 Exhibit AB   Government of Cyrenaica Ibrihim Said al-Jathran Usama Buera LIBYA https://efile.fara.gov/docs/6202-Exhibit-AB-20131220-1.pdf
132959 132959 2017-12-22 Keystone Strategic Advisers, LLC Keystone Strategic Advisers, LLC 6494 Exhibit AB   Governor of Eastern Libya LIBYA https://efile.fara.gov/docs/6494-Exhibit-AB-20171222-2.pdf
133580 133580 2018-12-26 Yorktown Solutions, LLC Yorktown Solutions, LLC 6491 Exhibit AB   Libyan United Democratic Party (LUDP) LIBYA https://efile.fara.gov/docs/6491-Exhibit-AB-20181226-7.pdf
135762 135762 2012-12-31 Harbour Group, LLC Harbour Group, LLC 5478 Exhibit AB   Embassy of Libya LIBYA https://efile.fara.gov/docs/5478-Exhibit-AB-19710107-15.pdf

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