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

271 rows where Foreign_Principal_Country = "COLOMBIA"

View and edit SQL

Document_Type

Foreign_Principal_Country

  • COLOMBIA · 172
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
39115 2018-04-27 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20180427-83.pdf
39116 2018-04-27 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20180427-84.pdf
39965 1997-04-30 KELLEY SWOFFORD ROY, INC. 5104 5104 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF COLOMBIA, ADMINISTRATIVE DEPAR COLOMBIA https://efile.fara.gov/docs/5104-Exhibit-AB-19970430-EER8UU03.pdf
43506 1993-05-01 CONOVER & COMPANY COMMUNICATIONS, INC. 4809 4809 Exhibit AB   ARTE Y CIA COLOMBIA https://efile.fara.gov/docs/4809-Exhibit-AB-19930501-D1ZT6L04.pdf
43881 1994-05-01 AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 3492 3492 Exhibit AB   COLOMBIA FLOWER COUNCIL COLOMBIA https://efile.fara.gov/docs/3492-Exhibit-AB-19940501-D0V4XO01.pdf
44039 2017-05-01 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170501-30.pdf
44447 2007-05-03 Burson-Marsteller 2469 2469 Exhibit AB   Embassy of Colombia COLOMBIA https://efile.fara.gov/docs/2469-Exhibit-AB-20070503-5.pdf
44651 2017-05-04 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170504-32.pdf
45353 1967-05-08 Robert R. Nathan Associates, Inc. 352 352 Exhibit AB   Republic of Colombia COLOMBIA https://efile.fara.gov/docs/352-Exhibit-AB-19670508-28.pdf
45501 2017-05-08 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170508-33.pdf
45946 2017-05-10 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170510-34.pdf
46111 2000-05-11 Akin, Gump, Strauss, Hauer & Feld, L.L.P. 3492 3492 Exhibit AB   Republic fo Colombia (Embassy) COLOMBIA https://efile.fara.gov/docs/3492-Exhibit-AB-20000511-H9QXXP02.pdf
46595 2015-05-13 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20150513-25.pdf
46957 1997-05-15 Wilkinson, Barker, Knauer & Quinn, LLP 5183 5183 Exhibit AB   Government of Colombia Ministry of Communications COLOMBIA https://efile.fara.gov/docs/5183-Exhibit-AB-19970515-1.pdf
47701 2012-05-18 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20120518-13.pdf
48184 1959-05-21 Robert R. Nathan Associates, Inc. 352 352 Exhibit AB   Government of Colombia COLOMBIA https://efile.fara.gov/docs/352-Exhibit-AB-19590521-16.pdf
48497 1995-05-22 O'CONNOR & HANNAN, LLP 2972 2972 Exhibit AB   PROEXPORT COLOMBIA https://efile.fara.gov/docs/2972-Exhibit-AB-19950522-DQQGZS93.pdf
48587 2012-05-22 Elmendorf Ryan 6039 6039 Exhibit AB   Colombian Foreign Investment and Export Promotion Agency (Proexport) COLOMBIA https://efile.fara.gov/docs/6039-Exhibit-AB-20120522-2.pdf
48604 2017-05-22 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170522-35.pdf
49564 1988-05-27 SAWYER MILLER GROUP 3777 3777 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF COLOMBIA COLOMBIA https://efile.fara.gov/docs/3777-Exhibit-AB-19880527-D15GK901.pdf
49633 2009-05-27 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20090527-4.pdf
49635 2009-05-27 Latin America Information Office LLC 5609 5609 Exhibit AB   Movimiento Poder Ciudadano, Siglo 21 COLOMBIA https://efile.fara.gov/docs/5609-Exhibit-AB-20090527-3.pdf
50525 2007-05-30 Glover Park Group, LLC 5666 5666 Exhibit AB   ProExport Colombia COLOMBIA https://efile.fara.gov/docs/5666-Exhibit-AB-20070530-9.pdf
51258 2013-05-31 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20130531-18.pdf
51777 1966-06-01 COLOMBIAN INFORMATION SERVICE 1979 1979 Exhibit AB   COLOMBIAN CENTER FOR THE REPUBLIC OF COLOMBIA COLOMBIA https://efile.fara.gov/docs/1979-Exhibit-AB-19660601-CZ9J8403.pdf
52237 1974-06-01 NATIONAL FEDERATION OF COFFEE GROWERS OF COLOMBIA 2519 2519 Exhibit AB   FEDERACION NACIONAL DE CAFETEROS DE COLOMBIA COLOMBIA https://efile.fara.gov/docs/2519-Exhibit-AB-19740601-CZOZ9A03.pdf
52685 1980-06-01 BERRY, MAX N. 2216 2216 Exhibit AB   ASOCIACION NACIONAL DE MANUFACTUREROS DEL CUERO COLOMBIA https://efile.fara.gov/docs/2216-Exhibit-AB-19800601-CZDW0K02.pdf
53395 1986-06-01 MURRAY,SCHEER,MONTGOMERY,TAPIA,O'DONNELL 3557 3557 Exhibit AB   NATIONAL FEDERATION OF COFFEE GROWERS OF COLOMBIA COLOMBIA https://efile.fara.gov/docs/3557-Exhibit-AB-19860601-D0WLH201.pdf
53579 1987-06-01 ARNOLD & PORTER 1750 1750 Exhibit AB   ASOCOLFLORES COLOMBIA https://efile.fara.gov/docs/1750-Exhibit-AB-19870601-CYYXYT03.pdf
56605 2008-06-03 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20080603-2.pdf
56750 1997-06-04 KELLEY SWOFFORD ROY HELMKE, INC. 5182 5182 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF COLOMBIA, ADMINISTRATIVE DEPAR COLOMBIA https://efile.fara.gov/docs/5182-Exhibit-AB-19970604-EER9MQ03.pdf
56827 2018-06-04 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20180604-86.pdf
57246 2008-06-06 Glover Park Group, LLC 5666 5666 Exhibit AB   ProExport Colombia COLOMBIA https://efile.fara.gov/docs/5666-Exhibit-AB-20080606-18.pdf
57389 1995-06-07 CHLOPAK, LEONARD, SCHECHTER & ASSOCIATES, INC. 4953 4953 Exhibit AB   AUDIOVISUALES, MINISTRY OF COMMUNICATIONS PREVIOUSLY KNOWN A COLOMBIA https://efile.fara.gov/docs/4953-Exhibit-AB-19950607-DFXG8L02.pdf
57544 1994-06-08 COLOMBIA FLOWER COUNCIL 4888 4888 Exhibit AB   ASOCIACION COLOMBIANA DE EXPORTADORES DE FLORES (ASOCOLFLORE COLOMBIA https://efile.fara.gov/docs/4888-Exhibit-AB-19940608-DGWTJL04.pdf
57787 2000-06-09 BSMG Worldwide 3911 3911 Exhibit AB   Government of Colombia COLOMBIA https://efile.fara.gov/docs/3911-Exhibit-AB-20000609-H9FS9F03.pdf
57977 1997-06-10 KELLEY SWOFFORD ROY, INC. 5104 5104 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF COLOMBIA, ADMINISTRATIVE DPART COLOMBIA https://efile.fara.gov/docs/5104-Exhibit-AB-19970610-EELL3203.pdf
59210 2017-06-16 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170616-36.pdf
60733 2010-06-24 Reid Davis, LLP 5993 5993 Exhibit AB   Federacion Nacional de Departamentos COLOMBIA https://efile.fara.gov/docs/5993-Exhibit-AB-20100624-2.pdf
60734 2010-06-24 Reid Davis, LLP 5993 5993 Exhibit AB   Republic of Colombia COLOMBIA https://efile.fara.gov/docs/5993-Exhibit-AB-20100624-1.pdf
61164 2017-06-26 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170626-37.pdf
61285 1967-06-27 Robert R. Nathan Associates, Inc. 352 352 Exhibit AB   Banco de la Republica of Colombia COLOMBIA https://efile.fara.gov/docs/352-Exhibit-AB-19670627-32.pdf
61329 1996-06-27 GRAHAM & JAMES, LLP 3275 3275 Exhibit AB   PROEXPORT COLOMBIA https://efile.fara.gov/docs/3275-Exhibit-AB-19960627-DULFCZ95.pdf
62241 1987-06-30 ARNOLD & PORTER 1750 1750 Exhibit AB   ASOCOLFLORES COLOMBIA https://efile.fara.gov/docs/1750-Exhibit-AB-19870630-CYYS2B03.pdf
65456 1992-07-01 AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 3492 3492 Exhibit AB   BANCO DE COMERCIO EXTERIOR COLOMBIA https://efile.fara.gov/docs/3492-Exhibit-AB-19920701-D0UHDE01.pdf
67873 2017-07-10 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170710-38.pdf
68017 1997-07-11 GREENBERG TRAURIG CONSULTING, INC. 5191 5191 Exhibit AB   SENATE OF THE REPUBLIC OF COLOMBIA COLOMBIA https://efile.fara.gov/docs/5191-Exhibit-AB-19970711-EFY7WE06.pdf
68329 2017-07-13 Colombia 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170713-39.pdf
69993 2008-07-22 Johnson, Madigan, Peck, Boland & Stewart, Inc. 5776 5776 Exhibit AB   ProExport Colombia COLOMBIA https://efile.fara.gov/docs/5776-Exhibit-AB-20080722-11.pdf
70297 2001-07-24 Akin, Gump, Strauss, Hauer & Feld, L.L.P. 3492 3492 Exhibit AB   Republic of Colombia (Embassy) COLOMBIA https://efile.fara.gov/docs/3492-Exhibit-AB-20010724-GUMFAZ04.pdf
70374 2015-07-24 Sandler, Travis & Rosenberg, P.A. 6309 6309 Exhibit AB   Asociacion Nacional de Empresarios de Colombia (ANDI) COLOMBIA https://efile.fara.gov/docs/6309-Exhibit-AB-20150724-1.pdf
70835 2017-07-26 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170726-40.pdf
71478 2009-07-29 Endeavour Global Strategies 5946 5946 Exhibit AB   Government of Colombia/Colombia is Passion through The Fratelli Group COLOMBIA https://efile.fara.gov/docs/5946-Exhibit-AB-20090729-1.pdf
72208 1995-07-31 MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON 3200 3200 Exhibit AB   ASOCIACION NACIONAL DE INDUSTRIALES (ANDI) COLOMBIA https://efile.fara.gov/docs/3200-Exhibit-AB-19950731-DOZSZ302.pdf
72771 2017-07-31 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170731-41.pdf
73451 1981-08-01 ANDERSON, HIBEY & BLAIR 3208 3208 Exhibit AB   SOCIETE NATIONALE ELF AQUITAINE COLOMBIA https://efile.fara.gov/docs/3208-Exhibit-AB-19810801-D0R83Z03.pdf
75731 1996-08-01 GIBBONS & COMPANY, INC. 4367 4367 Exhibit AB   PROEXPORT-COLOMBIA, REPUBLIC OF COLOMBIA COLOMBIA https://efile.fara.gov/docs/4367-Exhibit-AB-19960801-DW6MSX93.pdf
75857 2014-08-01 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20140801-21.pdf
76228 1988-08-03 GCI Group, Inc. 3856 3856 Exhibit AB   Flota Mercante Grancolombiana, S.A. COLOMBIA https://efile.fara.gov/docs/3856-Exhibit-AB-19880803-25.pdf
76428 2017-08-03 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170803-87.pdf
76443 2018-08-03 Munoz, Jorge 6581 6581 Exhibit AB   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/6581-Exhibit-AB-20180803-1.pdf
76714 1996-08-05 KELLEY SWOFFORD ROY, INC. 5104 5104 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF COLOMBIA, ADMINISTRATIVE DEPAR COLOMBIA https://efile.fara.gov/docs/5104-Exhibit-AB-19960805-DX9TY403.pdf
76859 1985-08-06 RUDER & FINN, INC. 1481 1481 Exhibit AB   COLOMBIA INFORMATION OFFICE COLOMBIA https://efile.fara.gov/docs/1481-Exhibit-AB-19850806-CYCONI03.pdf
77720 1995-08-10 MANATT, PHELPS & PHILLIPS 3736 3736 Exhibit AB   ASOCIACION COLOMBIANA DE EXPORTADORES DE FLORES (ASOCOFLORES COLOMBIA https://efile.fara.gov/docs/3736-Exhibit-AB-19950810-DNUT1W02.pdf
78204 2017-08-12 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170812-42.pdf
78338 2004-08-13 MFJ International, LLC 5640 5640 Exhibit AB   Fiduciaria Colombiana de Comercio Exterior S.A., Fiducoldex COLOMBIA https://efile.fara.gov/docs/5640-Exhibit-AB-20040813-I2WV6404.pdf
78371 2014-08-13 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20140813-22.pdf
78379 2017-08-13 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170813-99.pdf
78603 1995-08-15 CHLOPAK, LEONARD, SCHECHTER & ASSOCIATES, INC. 4953 4953 Exhibit AB   AUDIOVISUALES, MINISTRY OF COMMUNICATIONS PREVIOUSLY KNOWN COLOMBIA https://efile.fara.gov/docs/4953-Exhibit-AB-19950815-DFXFQC02.pdf
78690 2008-08-15 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20080815-3.pdf
78857 2017-08-16 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170816-44.pdf
79583 2008-08-21 Sorini, Samet & Associates, LLC 5839 5839 Exhibit AB   Ministry of Foreign Affairs of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5839-Exhibit-AB-20080821-13.pdf
79648 2019-08-21 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20190821-47.pdf
79803 2017-08-22 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170822-43.pdf
80142 2020-08-24 DCI Group AZ, LLC 6278 6278 Exhibit AB   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Exhibit-AB-20200824-17.pdf
80237 2015-08-25 Sandler, Travis & Rosenberg, P.A. 6309 6309 Exhibit AB   Asociacion Nacional de Empresarios de Colombia (ANDI) COLOMBIA https://efile.fara.gov/docs/6309-Exhibit-AB-20150825-2.pdf
80259 2020-08-25 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200825-70.pdf
81788 2010-08-31 Sharp & Barnes, LLP 6000 6000 Exhibit AB   Federacion National de Departamentos through Reid & Davis COLOMBIA https://efile.fara.gov/docs/6000-Exhibit-AB-20100831-1.pdf
81789 2010-08-31 Sharp & Barnes, LLP 6000 6000 Exhibit AB   Republic of Colombia through Reid & Davis COLOMBIA https://efile.fara.gov/docs/6000-Exhibit-AB-20100831-2.pdf
81844 2017-08-31 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170831-45.pdf
81862 2020-08-31 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200831-72.pdf
82802 1983-09-01 MARTIN, MARSHALL, JACCOMA & MITCHELL ADVERTISING, INC. 3043 3043 Exhibit AB   AVIANCA AIRLINES COLOMBIA https://efile.fara.gov/docs/3043-Exhibit-AB-19830901-D0EZGH02.pdf
82999 1985-09-01 NATIONAL FEDERATION OF COFFEE GROWERS OF COLOMBIA 2519 2519 Exhibit AB   FEDERACION NACIONAL DE CAFETEROS DE COLOMBIA COLOMBIA https://efile.fara.gov/docs/2519-Exhibit-AB-19850901-CZP5LI03.pdf
83094 1986-09-01 HILL & KNOWLTON, INC. 3301 3301 Exhibit AB   ASCOLOFLORES COLOMBIA https://efile.fara.gov/docs/3301-Exhibit-AB-19860901-D0II3A05.pdf
84852 1993-09-01 BOZELL SAWYER MILLER GROUP 3911 3911 Exhibit AB   FUNDACION PRO-IMAGEN DE COLOMBIA EN EL EXTERIOR COLOMBIA https://efile.fara.gov/docs/3911-Exhibit-AB-19930901-D180ZV02.pdf
85426 2020-09-01 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200901-73.pdf
85427 2020-09-01 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200901-74.pdf
85667 2020-09-03 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200903-77.pdf
85668 2020-09-03 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200903-78.pdf
85669 2020-09-03 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200903-79.pdf
85670 2020-09-03 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200903-80.pdf
86385 2017-09-07 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170907-47.pdf
86573 2020-09-08 DCI Group AZ, LLC 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200908-81.pdf
86706 2016-09-09 Fratelli Group 5867 5867 Exhibit AB   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Exhibit-AB-20160909-27.pdf
87317 2008-09-12 Peck, Madigan, Jones & Stewart, Inc. 5776 5776 Exhibit AB   ProExport Colombia COLOMBIA https://efile.fara.gov/docs/5776-Exhibit-AB-20080912-12.pdf
87318 2008-09-12 Peck, Madigan, Jones & Stewart, Inc. 5776 5776 Exhibit AB   ProExport Colombia COLOMBIA https://efile.fara.gov/docs/5776-Exhibit-AB-20080912-13.pdf
87347 2017-09-12 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170912-46.pdf
87749 2017-09-14 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170914-48.pdf
87750 2017-09-14 Fratelli Group 5867 5867 Informational Materials   Government of Colombia, Embassy COLOMBIA https://efile.fara.gov/docs/5867-Informational-Materials-20170914-90.pdf
88580 2020-09-18 6278 6278 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20200918-82.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])
);