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

371 rows where Foreign_Principal_Country = "RUSSIA"

View and edit SQL

Suggested facets: Date_Stamped (date)

Document_Type

Foreign_Principal_Country

  • RUSSIA · 371
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
76 1961-01-01 INTOURIST, RUSSIAN JOINT STOCK COMPANY FOR FOREIGN TRAVEL, 1240 1240 Exhibit AB   VSESOJUZNOE AKTZIONERNOE OBSHCHESTVO "INTOURIST" RUSSIA https://www.fara.gov/docs/1240-Exhibit-AB-19610101-CYO3XT02.pdf
1707 1991-01-01 CHALK, O. ROY 4461 4461 Exhibit AB   REPUBLIC OF RUSSIA RUSSIA https://www.fara.gov/docs/4461-Exhibit-AB-19910101-D1QTG802.pdf
2141 1992-01-01 NEW HORIZONS VENTURES 4578 4578 Exhibit AB   TYUMEN REGION ADMINISTRATION OF THE RUSSIAN REPUBLIC, USSR RUSSIA https://www.fara.gov/docs/4578-Exhibit-AB-19920101-D1UXT004.pdf
2534 1993-01-01 NUTTER & HARRIS, INC. 4635 4635 Exhibit AB   MOSCOW PHARMACY CHAMBER RUSSIA https://www.fara.gov/docs/4635-Exhibit-AB-19930101-D1WM3J04.pdf
3502 2012-01-06 Clark & Weinstock 5914 5914 Exhibit AB   Gazprom Export through Ketchum Inc RUSSIA https://www.fara.gov/docs/5914-Exhibit-AB-20120106-7.pdf
3694 2019-01-07 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://www.fara.gov/docs/6170-Informational-Materials-20190107-50.pdf
3796 2014-01-08 Alston & Bird, LLP 5549 5549 Exhibit AB   Russian Federation (through Ketchum, Inc.) RUSSIA https://www.fara.gov/docs/5549-Exhibit-AB-20140108-10.pdf
3990 2019-01-09 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://www.fara.gov/docs/6170-Informational-Materials-20190109-41.pdf
4007 2020-01-09 RM Broadcasting, LLC 6694 6694 Exhibit AB   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://www.fara.gov/docs/6694-Exhibit-AB-20200109-3.pdf
4008 2020-01-09 RM Broadcasting, LLC 6694 6694 Informational Materials   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://www.fara.gov/docs/6694-Informational-Materials-20200109-12.pdf
5013 2020-01-15 Reston Translator, LLC 6490 6490 Exhibit AB   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://www.fara.gov/docs/6490-Exhibit-AB-20200115-3.pdf
5144 2019-01-16 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://www.fara.gov/docs/6170-Informational-Materials-20190116-47.pdf
5811 1982-01-22 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Sojuzpromexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19820122-HVCLVT01.pdf
6127 2019-01-23 Latham & Watkins LLP 6628 6628 Exhibit AB   Lord Gregory Barker of Battle RUSSIA https://www.fara.gov/docs/6628-Exhibit-AB-20190123-1.pdf
7036 2013-01-28 Alston & Bird, LLP 5549 5549 Exhibit AB   Russian Federation (through Ketchum, Inc.) RUSSIA https://www.fara.gov/docs/5549-Exhibit-AB-20130128-8.pdf
7112 2019-01-28 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://www.fara.gov/docs/6170-Informational-Materials-20190128-49.pdf
7138 2020-01-28 Reston Translator, LLC 6490 6490 Informational Materials   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://www.fara.gov/docs/6490-Informational-Materials-20200128-1.pdf
7166 1991-01-29 PARTNERS & SHEVACK, INC. 1436 1436 Exhibit AB   INTOURIST RUSSIA https://www.fara.gov/docs/1436-Exhibit-AB-19910129-CYZDHN03.pdf
7255 2009-01-29 Alston & Bird, LLP 5549 5549 Exhibit AB   Russian Federation (through Ketchum, Inc.) RUSSIA https://www.fara.gov/docs/5549-Exhibit-AB-20090129-2.pdf
7581 2007-01-30 Venable, LLP 5435 5435 Exhibit AB   Rodina Political Party RUSSIA https://www.fara.gov/docs/5435-Exhibit-AB-20070130-6.pdf
11026 1992-02-01 ENERGIA U.S.A., INC. 4621 4621 Exhibit AB   NPO ENERGIA RUSSIA https://www.fara.gov/docs/4621-Exhibit-AB-19920201-D1W0LC04.pdf
11603 1994-02-01 MURRAY,SCHEER,MONTGOMERY,TAPIA,O'DONNELL 3557 3557 Exhibit AB   REPUBLIC OF TATARSTAN RUSSIA https://www.fara.gov/docs/3557-Exhibit-AB-19940201-D0W3LS01.pdf
12523 1991-02-05 HANSEN, DONALD K. 4469 4469 Exhibit AB   CITY OF UFA RUSSIA https://www.fara.gov/docs/4469-Exhibit-AB-19910205-D1RGYW02.pdf
12524 1991-02-05 HANSEN, DONALD K. 4469 4469 Exhibit AB   SOVIET SOCIALIST REPUBLIC OF BASHKIRIA RUSSIA https://www.fara.gov/docs/4469-Exhibit-AB-19910205-D1RGY102.pdf
12867 2020-02-06 RM Broadcasting, LLC 6694 6694 Informational Materials   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://www.fara.gov/docs/6694-Informational-Materials-20200206-2.pdf
13026 2019-02-07 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://www.fara.gov/docs/6170-Informational-Materials-20190207-46.pdf
13065 1980-02-08 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Machinoimport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19800208-HW2CJ104.pdf
13066 1980-02-08 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Techsnabexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19800208-HW2CCG04.pdf
13304 2004-02-09 Gallagher, John J. 5336 5336 Exhibit AB   Kurchatov Institute RUSSIA https://www.fara.gov/docs/5336-Exhibit-AB-20040209-HUOD3603.pdf
13523 1985-02-11 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Sojuzkoopvneshtorg RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19850211-HJTXFY03.pdf
13914 2007-02-13 Ketchum Inc. NY 5758 5758 Exhibit AB   Russian Federation RUSSIA https://www.fara.gov/docs/5758-Exhibit-AB-20070213-2.pdf
13969 2020-02-13 BurgherGray LLP 6793 6793 Exhibit AB   Ivanyan and Partners RUSSIA https://www.fara.gov/docs/6793-Exhibit-AB-20200213-1.pdf
14166 1979-02-15 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Strojmaterialintorg RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19790215-HW46U505.pdf
14386 1996-02-16 HOGAN & HARTSON, L.L.P. 2244 2244 Exhibit AB   ELBIM BANK RUSSIA https://www.fara.gov/docs/2244-Exhibit-AB-19960216-DOU6TX91.pdf
14451 2018-02-16 RIA Global LLC 6524 6524 Exhibit AB   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://www.fara.gov/docs/6524-Exhibit-AB-20180216-2.pdf
14646 1986-02-18 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Electronorgtechnica RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19860218-HJTO3U03.pdf
14657 1992-02-18 AMTORG TRADING CORPORATION 596 596 Exhibit AB   "VNESHSTROYKOMPLEX" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19920218-CY6NY002.pdf
14658 1992-02-18 AMTORG TRADING CORPORATION 596 596 Exhibit AB   MOSCOW FAT PROCESSING PLANT RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19920218-CY6NX002.pdf
14659 1992-02-18 AMTORG TRADING CORPORATION 596 596 Exhibit AB   MOSCOW INDUSTRIAL UNION FOR DIAMOND TOOLS PRODUCTION RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19920218-CY6NTG02.pdf
14660 1992-02-18 AMTORG TRADING CORPORATION 596 596 Exhibit AB   MULTIBRANCH BUSINESS ASSOCIATION "ELEM" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19920218-CY6NVD02.pdf
14662 1992-02-18 AMTORG TRADING CORPORATION 596 596 Exhibit AB   VPO "SOJUZELEKTROSETISOLYATSIYA" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19920218-CY6NUD02.pdf
14775 2019-02-18 Tenam Corporation 6638 6638 Exhibit AB   Uranium One, Inc. RUSSIA https://www.fara.gov/docs/6638-Exhibit-AB-20190218-1.pdf
15490 1995-02-23 GCI GROUP, INC. 3856 3856 Exhibit AB   MOST GROUP RUSSIA https://www.fara.gov/docs/3856-Exhibit-AB-19950223-DMU9GL92.pdf
15715 2003-02-24 Solutions North America Incorporated 5517 5517 Exhibit AB   Saratuv Aviation Plant Joint Stock Company RUSSIA https://www.fara.gov/docs/5517-Exhibit-AB-20030224-HBC6HX03.pdf
15839 1991-02-25 Amtorg Trading Corporation 596 596 Exhibit AB   "Kwartzsamotsvety" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19910225-HJ7DTH03.pdf
15840 1991-02-25 Amtorg Trading Corporation 596 596 Exhibit AB   V/O "STROJDORMASHEXPORT" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19910225-HJ7DYL03.pdf
15841 1991-02-25 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Avtopromimport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19910225-HJ7DMY03.pdf
15842 1991-02-25 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Tehsnabexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19910225-HJ7E3O03.pdf
16251 1990-02-27 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Almazjuvelirexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900227-HJGYLN03.pdf
16252 1990-02-27 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Strojmaterialintorg RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900227-HJGYZM03.pdf
16382 2008-02-27 Integrated Solutions Group, LLC 5855 5855 Exhibit AB   Russian Federation through the Washington Group RUSSIA https://www.fara.gov/docs/5855-Exhibit-AB-20080227-3.pdf
17183 2019-02-28 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://www.fara.gov/docs/6170-Informational-Materials-20190228-55.pdf
17184 2019-02-28 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://www.fara.gov/docs/6170-Informational-Materials-20190228-57.pdf
17453 1961-03-01 PARTNERS & SHEVACK, INC. 1436 1436 Exhibit AB   INTOURIST RUSSIA https://www.fara.gov/docs/1436-Exhibit-AB-19610301-CYZ0XE03.pdf
20362 1992-03-01 NUTTER & HARRIS, INC. 4635 4635 Exhibit AB   INTERNATIONAL FOUNDATION FOR MOTHER & CHILD CARE RUSSIA https://www.fara.gov/docs/4635-Exhibit-AB-19920301-D1WJX804.pdf
20647 1993-03-01 GOWRAN INTERNATIONAL, LTD. 4417 4417 Exhibit AB   DEMOCRACY NEXT CENTURY ASSOCIATION (DNCA) RUSSIA https://www.fara.gov/docs/4417-Exhibit-AB-19930301-D1PS4D02.pdf
20947 1993-03-01 STROOCK & STROOCK & LAVAN 4750 4750 Exhibit AB   MINISTRY FOR PROTECTION OF THE ENVIRONMENT AND NATURAL RUSSIA https://www.fara.gov/docs/4750-Exhibit-AB-19930301-D1XV6X02.pdf
21180 1979-03-02 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Novoexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19790302-HW46ON05.pdf
21697 2019-03-03 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://www.fara.gov/docs/6170-Informational-Materials-20190303-56.pdf
22072 2020-03-05 RM Broadcasting, LLC 6694 6694 Informational Materials   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://www.fara.gov/docs/6694-Informational-Materials-20200305-13.pdf
22585 1994-03-08 NUTTER & HARRIS, INC. 4635 4635 Exhibit AB   FERRANE JOINT STOCK COMPANY FORMERLY (FERRANE) RUSSIA https://www.fara.gov/docs/4635-Exhibit-AB-19940308-DIV82Y01.pdf
22988 2000-03-10 Fleishman-Hillard, Inc. 3774 3774 Exhibit AB   Tyumen Oil Company RUSSIA https://www.fara.gov/docs/3774-Exhibit-AB-20000310-G560MG01.pdf
23640 2017-03-13 Daniel J. Edelman, Inc. 3634 3634 Exhibit AB   International Centre for Legal Protection (ICLP) RUSSIA https://www.fara.gov/docs/3634-Exhibit-AB-20170313-56.pdf
23721 1977-03-14 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Sojuzvneshstrojimport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19770314-HW9R3104.pdf
23751 1990-03-14 Amtorg Trading Corporation 596 596 Exhibit AB   "Paton Welding Institute" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900314-HJGYAE03.pdf
23752 1990-03-14 Amtorg Trading Corporation 596 596 Exhibit AB   P/O "TERMINAL" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900314-HJGY4O03.pdf
23755 1991-03-14 Amtorg Trading Corporation 596 596 Exhibit AB   Uhtomskiy Helicopter Works RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19910314-HJ7DF103.pdf
23946 2019-03-14 RIA Global LLC 6524 6524 Exhibit AB   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://www.fara.gov/docs/6524-Exhibit-AB-20190314-3.pdf
24524 1987-03-18 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Vneshtorgreklama RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19870318-HJIRIM03.pdf
24710 1985-03-19 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Energomashexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19850319-HJTX3X03.pdf
25155 1990-03-21 Amtorg Trading Corporation 596 596 Exhibit AB   V/O "Promexport" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900321-HJGXR603.pdf
25156 1990-03-21 Amtorg Trading Corporation 596 596 Exhibit AB   V/O "Soyuzkarta" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900321-HJGXYX03.pdf
26351 2009-03-27 Spencer, Thomas R. 5924 5924 Exhibit AB   NCB Finetechproject RUSSIA https://www.fara.gov/docs/5924-Exhibit-AB-20090327-1.pdf
26482 1995-03-28 HOGAN & HARTSON, L.L.P. 2244 2244 Exhibit AB   VOLGA-DNEPR J.S. CARGO AIRLINE RUSSIA https://www.fara.gov/docs/2244-Exhibit-AB-19950328-DOKOJ701.pdf
26720 1990-03-29 Amtorg Trading Corporation 596 596 Exhibit AB   "Kwartzsamotsvety" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900329-HJGX9603.pdf
26721 1990-03-29 Amtorg Trading Corporation 596 596 Exhibit AB   V/O "Sovintersport" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900329-HJGXLN03.pdf
26765 1999-03-29 ADVANTAGE ASSOCIATES, INC. 5275 5275 Exhibit AB   CHECHEN REPUBLIC RUSSIA https://www.fara.gov/docs/5275-Exhibit-AB-19990329-FALTQS01.pdf
26959 1990-03-30 Amtorg Trading Corporation 596 596 Exhibit AB   "Chernovtsy Rubber Shoesfactory" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900330-HJGWX103.pdf
26960 1990-03-30 Amtorg Trading Corporation 596 596 Exhibit AB   TSNT Cooperative "Steamer" RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19900330-HJGX2S03.pdf
27347 1994-03-31 NUTTER & HARRIS, INC. 4635 4635 Exhibit AB   MINISTRY OF HEALTH CARE OF THE REPUBLIC OF TATARSTAN RUSSIA https://www.fara.gov/docs/4635-Exhibit-AB-19940331-DIV8HU01.pdf
27998 2011-03-31 APCO Worldwide, Inc. 4561 4561 Exhibit AB   Joint Stock Company "Techsnabexport" RUSSIA https://www.fara.gov/docs/4561-Exhibit-AB-20110331-12.pdf
28388 1974-04-01 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Exportkhleb RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740401-HWJBB804.pdf
28389 1974-04-01 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Machinoexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740401-HWKWY904.pdf
28390 1974-04-01 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Machinoimport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740401-HWJBGJ04.pdf
28391 1974-04-01 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Mashpriborintorg RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740401-HWKWPL04.pdf
28392 1974-04-01 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Medexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740401-HWKVTM04.pdf
28393 1974-04-01 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Raznoimport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740401-HWKWJN04.pdf
28395 1974-04-01 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Sojuzpromexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740401-HWKWE304.pdf
28397 1974-04-01 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Techmashimport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740401-HWKW7O04.pdf
29847 1990-04-01 MAYER, BROWN & PLATT 3076 3076 Exhibit AB   BANK FOR FOREIGN ECONOMIC AFFAIRS OF RUSSIA RUSSIA https://www.fara.gov/docs/3076-Exhibit-AB-19900401-D0K7JW02.pdf
30615 1992-04-01 HOGAN & HARTSON, L.L.P. 2244 2244 Exhibit AB   TECHSNABEXPORT, LTD. (TENEX) RUSSIA https://www.fara.gov/docs/2244-Exhibit-AB-19920401-CZD8TX02.pdf
30965 1993-04-01 MURRAY,SCHEER,MONTGOMERY,TAPIA,O'DONNELL 3557 3557 Exhibit AB   ASSOCIATION OF INDUSTRIALISTS & BUSINESSMEN OF TATARSTAN RUSSIA https://www.fara.gov/docs/3557-Exhibit-AB-19930401-D0W28T01.pdf
30974 1993-04-01 AMERICAN-CHECHENIAN FRIENDSHIP & ECONOMIC ASSOCIATION 4791 4791 Exhibit AB   CHECHEN REPUBLIC RUSSIA https://www.fara.gov/docs/4791-Exhibit-AB-19930401-D1Y19U02.pdf
31098 1993-04-01 EURAMERICA CAPITAL CORPORATION, LTD. 4794 4794 Exhibit AB   GOVERNMENT OF REPUBLIC OF TATARSTAN RUSSIA https://www.fara.gov/docs/4794-Exhibit-AB-19930401-D1Y2JN02.pdf
31183 1993-04-01 HOGAN & HARTSON, L.L.P. 2244 2244 Exhibit AB   TECHSNABEXPORT, LTD. (TENEX) RUSSIA https://www.fara.gov/docs/2244-Exhibit-AB-19930401-CZD7YU02.pdf
32990 1985-04-09 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Vneshposyltorg RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19850409-HJTWZF03.pdf
33209 1974-04-10 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Licensintorg RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740410-HWJ9ES04.pdf
33210 1974-04-10 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Prodintorg RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740410-HWJAHC04.pdf
33211 1974-04-10 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Promsyrioimport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740410-HWJAV604.pdf
33212 1974-04-10 Amtorg Trading Corporation 596 596 Exhibit AB   V/O Raznoexport RUSSIA https://www.fara.gov/docs/596-Exhibit-AB-19740410-HWJB0W04.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 545.864ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history