FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
64 rows where Foreign_Principal_Country = "GUATEMALA"
This data as json, CSV (advanced)
Foreign_Principal_Name 42
- Government of Guatemala 4
- REPUBLIC OF GUATEMALA 4
- FundaSistemas 3
- PRESIDENCY OF THE REPUBLIC OF GUATEMALA 3
- ASOCIACION DE AMIGOS DEL PAIS 2
- CBI SUGAR GROUP 2
- CENTRAL AMERICAN SUGAR COUNCIL 2
- Coalicion del Congreso de Guatemala 2
- Embassy of the Republic of Guatemala 2
- GOVERNMENT OF GUATEMALA 2
- GUATEMALA TOURIST COMMISSION 2
- OFFICE OF THE PRESIDENT OF GUATEMALA 2
- Republic of Guatemala, Embassy 2
- SUPREME COURT OF JUSTICE OF THE REPUBLIC OF GUATEMALA 2
- Secretaria de Integracion Turista Centroamericana (SITCA) 2
- Universidad Francisco Marroquin 2
- ASOCIACION DE AZUCAREROS DE GUATEMALA 1
- Agexpront 1
- BATAB Coalition 1
- CENTRO ESTNA 1
- COMITE DE SOPORTE AL COMERCIO (COSOSCO) 1
- Coordinadora de las Comunidades Afectadas por la Construccion de la Hidroelectrica Chixoy (COCAHICH) 1
- DOMINGO MOREIRA 1
- DR. MARIO CASTEJON 1
- FUNDACION GUATEMALTECA POR LA LIBERTAD 1
- FUNDESA (FUNDACION PARA EL DESARROLLO DE GUATEMALA) 1
- GUATEMALA 1
- Government of Guatemala Ministry of Economy 1
- Government of Guatemala, Embassy 1
- Government of the Republic of Guatemala, Embassy 1
- His Excellency J.E. Morales, President republic of Guatemala 1
- INGUAT (INSTITUTO GUATEMALTECO DE TURISMO) 1
- INQUAT (GUATEMALA) 1
- Instituto Guatelmalteco de Turismo - INGUAT (Guatemalan Institute of Tourism) 1
- PRESIDENT OF GUATEMALA, H.E. JORGE SERRANO ELIAS 1
- PROCESADORA DE CARNE, S.A. (PROCASA) 1
- PRONACOM (Programa Nacional de la Competitividad) 1
- Ramiro Maldonado 1
- Republic of Guatemala 1
- UNION DEL CENTRO NACIONAL 1
- Zury Mayte Rios de Smith 1
- Zury Mayte' Rios Sosa de Weller 1
Registrant_Name 37
- PATTON BOGGS, L.L.P. 6
- Ballard Partners 4
- CAMERON, BRUCE P. 4
- Barnes & Thornburg, LLP 3
- Bracy Tucker Brown, Inc. 3
- SCHUETTE, KEITH E. 3
- Foley, Hoag & Eliot, LLP 2
- Global Communicators, LLC 2
- HANNAFORD COMPANY, INC. 2
- HILL & KNOWLTON, INC. 2
- M. SILVER ASSOCIATES, INC. 2
- Modern Education Services, Inc. 2
- R. THOMPSON & COMPANY 2
- REICHLER & SOBLE 2
- Sonoran Policy Group, LLC 2
- Tew Cardenas Rebak Kellogg Lehman DeMaria Tague Raymond & Levine, LLP 2
- Arnold & Porter, LLP 1
- Barnes & Thornburg LLP 1
- DLA Piper US LLP 1
- ED GRAVES & ASSOCIATES 1
- FOLEY, HOAG & ELIOT LLP 1
- GUATEMALA FUNDESA WORKING GROUP 1
- Greenberg Traurig, L.L.P. 1
- Holland & Knight 1
- INTERNATIONAL DEVELOPMENT SYSTEMS, INC. 1
- LANDAU, DAVID 1
- MCDERMOTT, WILL & EMERY 1
- MWW STRATEGIC COMMUNICATIONS 1
- NEEDHAM & GROHMANN, INC. 1
- Otto Reich Associates, LLC 1
- PURPURO, LAWRENCE J. 1
- Peck, Madigan, Jones & Stewart, Inc. 1
- Rokk Solutions LLC 1
- SHEA & GARDNER 1
- SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS 1
- Sandler, Travis & Rosenberg, P.A. 1
- Williams & Connolly 1
Document_Type 2
Foreign_Principal_Country 1
- GUATEMALA · 64 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
691 | 691 | 1982-01-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Exhibit AB | ASOCIACION DE AZUCAREROS DE GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/2165-Exhibit-AB-19820101-DBKNBT03.pdf | |
790 | 790 | 1983-01-01 | NEEDHAM & GROHMANN, INC. | Needham & Grohmann, Inc. 3451 | Exhibit AB | INQUAT (GUATEMALA) | GUATEMALA | https://efile.fara.gov/docs/3451-Exhibit-AB-19830101-D0PEYM01.pdf | |
1251 | 1251 | 1988-01-01 | CAMERON, BRUCE P. | Cameron, Bruce P. 4043 | Exhibit AB | PRESIDENCY OF THE REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4043-Exhibit-AB-19880101-D1J4O302.pdf | |
5290 | 5290 | 2022-01-13 | Ballard Partners | Ballard Partners 7070 | Exhibit AB | Government of Guatemala | GUATEMALA | https://efile.fara.gov/docs/7070-Exhibit-AB-20220113-1.pdf | |
11111 | 11111 | 1982-02-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Exhibit AB | DOMINGO MOREIRA | GUATEMALA | https://efile.fara.gov/docs/3301-Exhibit-AB-19820201-D0IGNA05.pdf | |
11672 | 11672 | 1987-02-01 | REICHLER & SOBLE | Reichler & Soble 3582 | Exhibit AB | REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/3582-Exhibit-AB-19870201-D0VT6101.pdf | |
12435 | 12435 | 1991-02-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Exhibit AB | REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/2165-Exhibit-AB-19910201-DBBE2I02.pdf | |
15260 | 15260 | 2000-02-09 | Foley, Hoag & Eliot, LLP | Foley Hoag, LLP 4776 | Exhibit AB | Republic of Guatemala | GUATEMALA | https://efile.fara.gov/docs/4776-Exhibit-AB-20000209-G3TX6I01.pdf | |
15769 | 15769 | 2022-02-11 | Ballard Partners | Ballard Partners 7070 | Informational Materials | Government of Guatemala | GUATEMALA | https://efile.fara.gov/docs/7070-Informational-Materials-20220211-1.pdf | |
15873 | 15873 | 2003-02-12 | Greenberg Traurig, L.L.P. | Greenberg Traurig, L.L.P. 5494 | Exhibit AB | Government of the Republic of Guatemala, Embassy | GUATEMALA | https://efile.fara.gov/docs/5494-Exhibit-AB-20030212-HAKO0N03.pdf | |
24788 | 24788 | 1993-03-03 | FOLEY, HOAG & ELIOT LLP | Foley Hoag, LLP 4776 | Exhibit AB | SUPREME COURT OF JUSTICE OF THE REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4776-Exhibit-AB-19930303-D1Y2IC02.pdf | |
26641 | 26641 | 1992-03-10 | REICHLER & SOBLE | Reichler & Soble 3582 | Exhibit AB | SUPREME COURT OF JUSTICE OF THE REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/3582-Exhibit-AB-19920310-D0W0GR01.pdf | |
28215 | 28215 | 2022-03-15 | Ballard Partners | Ballard Partners 7070 | Informational Materials | Government of Guatemala | GUATEMALA | https://efile.fara.gov/docs/7070-Informational-Materials-20220315-2.pdf | |
32182 | 32182 | 2009-03-30 | Bracy Tucker Brown, Inc. | Bracy Tucker Brown, Inc. 5878 | Exhibit AB | FundaSistemas | GUATEMALA | https://efile.fara.gov/docs/5878-Exhibit-AB-20090330-2.pdf | |
32219 | 32219 | 2010-03-30 | Bracy Tucker Brown, Inc. | Bracy Tucker Brown, Inc. 5878 | Exhibit AB | FundaSistemas | GUATEMALA | https://efile.fara.gov/docs/5878-Exhibit-AB-20100330-3.pdf | |
33748 | 33748 | 1971-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Exhibit AB | CENTRAL AMERICAN SUGAR COUNCIL | GUATEMALA | https://efile.fara.gov/docs/2165-Exhibit-AB-19710401-DBBG8T02.pdf | |
35749 | 35749 | 1991-04-01 | SCHUETTE, KEITH E. | Schuette, Keith E. 4503 | Exhibit AB | PRESIDENT OF GUATEMALA, H.E. JORGE SERRANO ELIAS | GUATEMALA | https://efile.fara.gov/docs/4503-Exhibit-AB-19910401-D1URRO04.pdf | |
36314 | 36314 | 1992-04-01 | SCHUETTE, KEITH E. | Schuette, Keith E. 4503 | Exhibit AB | OFFICE OF THE PRESIDENT OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4503-Exhibit-AB-19920401-D1UCVD04.pdf | |
37577 | 37577 | 1995-04-04 | GUATEMALA FUNDESA WORKING GROUP | Guatemala FUNDESA Working Group 5007 | Exhibit AB | FUNDESA (FUNDACION PARA EL DESARROLLO DE GUATEMALA) | GUATEMALA | https://efile.fara.gov/docs/5007-Exhibit-AB-19950404-DF7TH303.pdf | |
40199 | 40199 | 2017-04-14 | Barnes & Thornburg, LLP | Barnes & Thornburg, LLP 6417 | Exhibit AB | His Excellency J.E. Morales, President republic of Guatemala | GUATEMALA | https://efile.fara.gov/docs/6417-Exhibit-AB-20170414-2.pdf | |
41412 | 41412 | 2019-04-19 | Sonoran Policy Group, LLC | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | Exhibit AB | Zury Mayte' Rios Sosa de Weller | GUATEMALA | https://efile.fara.gov/docs/6399-Exhibit-AB-20190419-27.pdf | |
41693 | 41693 | 1995-04-21 | R. THOMPSON & COMPANY | R. Thompson & Company 4950 | Exhibit AB | GOVERNMENT OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4950-Exhibit-AB-19950421-DFVVWG01.pdf | |
44638 | 44638 | 2001-04-30 | Foley, Hoag & Eliot, LLP | Foley Hoag, LLP 4776 | Exhibit AB | Agexpront | GUATEMALA | https://efile.fara.gov/docs/4776-Exhibit-AB-20010430-GNF9JC01.pdf | |
45905 | 45905 | 1980-05-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Exhibit AB | ASOCIACION DE AMIGOS DEL PAIS | GUATEMALA | https://efile.fara.gov/docs/2165-Exhibit-AB-19800501-DBBFNW02.pdf | |
46769 | 46769 | 1989-05-01 | CAMERON, BRUCE P. | Cameron, Bruce P. 4043 | Exhibit AB | PRESIDENCY OF THE REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4043-Exhibit-AB-19890501-D1J4IK02.pdf | |
50438 | 50438 | 1972-05-09 | Modern Education Services, Inc. | Modern Education Services, Inc. 1803 | Exhibit AB | Secretaria de Integracion Turista Centroamericana (SITCA) | GUATEMALA | https://efile.fara.gov/docs/1803-Exhibit-AB-19720509-HD39K303.pdf | |
55137 | 55137 | 1994-05-27 | PURPURO, LAWRENCE J. | Purpuro, Lawrence J. 4917 | Exhibit AB | INGUAT (INSTITUTO GUATEMALTECO DE TURISMO) | GUATEMALA | https://efile.fara.gov/docs/4917-Exhibit-AB-19940527-DFOKQS02.pdf | |
60986 | 60986 | 1992-06-01 | SCHUETTE, KEITH E. | Schuette, Keith E. 4503 | Exhibit AB | OFFICE OF THE PRESIDENT OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4503-Exhibit-AB-19920601-D1UDOC04.pdf | |
61499 | 61499 | 1993-06-01 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Exhibit AB | COMITE DE SOPORTE AL COMERCIO (COSOSCO) | GUATEMALA | https://efile.fara.gov/docs/4818-Exhibit-AB-19930601-D1Y75H02.pdf | |
62225 | 62225 | 2017-06-02 | Barnes & Thornburg, LLP | Barnes & Thornburg, LLP 6417 | Exhibit AB | Coalicion del Congreso de Guatemala | GUATEMALA | https://efile.fara.gov/docs/6417-Exhibit-AB-20170602-3.pdf | |
67629 | 67629 | 2007-06-26 | Global Communicators, LLC | Global Communicators, LLC 5817 | Exhibit AB | Universidad Francisco Marroquin | GUATEMALA | https://efile.fara.gov/docs/5817-Exhibit-AB-20070626-1.pdf | |
68408 | 68408 | 1994-06-29 | LANDAU, DAVID | Landau, David 4944 | Exhibit AB | DR. MARIO CASTEJON | GUATEMALA | https://efile.fara.gov/docs/4944-Exhibit-AB-19940629-DE109J96.pdf | |
70984 | 70984 | 1980-07-01 | M. SILVER ASSOCIATES, INC. | M. Silver Associates, Inc. 3131 | Exhibit AB | GUATEMALA TOURIST COMMISSION | GUATEMALA | https://efile.fara.gov/docs/3131-Exhibit-AB-19800701-D0JW1U01.pdf | |
71851 | 71851 | 1989-07-01 | INTERNATIONAL DEVELOPMENT SYSTEMS, INC. | International Development Systems, Inc. 4012 | Exhibit AB | GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4012-Exhibit-AB-19890701-D1JSG102.pdf | |
72314 | 72314 | 1991-07-01 | MWW STRATEGIC COMMUNICATIONS | MWW/Strategic Communications, Inc. 4542 | Exhibit AB | REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4542-Exhibit-AB-19910701-D1UUV804.pdf | |
74455 | 74455 | 2017-07-07 | Barnes & Thornburg, LLP | Barnes & Thornburg, LLP 6417 | Informational Materials | Coalicion del Congreso de Guatemala | GUATEMALA | https://efile.fara.gov/docs/6417-Informational-Materials-20170707-6.pdf | |
76072 | 76072 | 2003-07-14 | Tew Cardenas Rebak Kellogg Lehman DeMaria Tague Raymond & Levine, LLP | Tew Cardenas, LLP 5562 | Exhibit AB | Republic of Guatemala, Embassy | GUATEMALA | https://efile.fara.gov/docs/5562-Exhibit-AB-20030714-HI6PP901.pdf | |
77095 | 77095 | 2012-07-19 | Sandler, Travis & Rosenberg, P.A. | Sandler, Travis & Rosenberg, P.A. 6115 | Exhibit AB | Government of Guatemala Ministry of Economy | GUATEMALA | https://efile.fara.gov/docs/6115-Exhibit-AB-20120719-1.pdf | |
78392 | 78392 | 2014-07-24 | Otto Reich Associates, LLC | Otto Reich Associates, LLC 6235 | Exhibit AB | Embassy of the Republic of Guatemala | GUATEMALA | https://efile.fara.gov/docs/6235-Exhibit-AB-20140724-1.pdf | |
78398 | 78398 | 2014-07-24 | Peck, Madigan, Jones & Stewart, Inc. | Peck, Madigan, Jones & Stewart, Inc. 6172 | Exhibit AB | Embassy of the Republic of Guatemala | GUATEMALA | https://efile.fara.gov/docs/6172-Exhibit-AB-20140724-3.pdf | |
79022 | 79022 | 2022-07-26 | Ballard Partners | Ballard Partners 7070 | Informational Materials | Government of Guatemala | GUATEMALA | https://efile.fara.gov/docs/7070-Informational-Materials-20220726-8.pdf | |
79849 | 79849 | 1999-07-29 | Williams & Connolly | Williams & Connolly 5323 | Exhibit AB | Government of Guatemala, Embassy | GUATEMALA | https://efile.fara.gov/docs/5323-Exhibit-AB-19990729-GFLOAI04.pdf | |
82140 | 82140 | 1980-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Exhibit AB | PROCESADORA DE CARNE, S.A. (PROCASA) | GUATEMALA | https://efile.fara.gov/docs/2165-Exhibit-AB-19800801-DBKNOJ03.pdf | |
83186 | 83186 | 1990-08-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Exhibit AB | CBI SUGAR GROUP | GUATEMALA | https://efile.fara.gov/docs/3301-Exhibit-AB-19900801-D0IE3C05.pdf | |
86088 | 86088 | 2007-08-07 | Global Communicators, LLC | Global Communicators, LLC 5817 | Exhibit AB | Universidad Francisco Marroquin | GUATEMALA | https://efile.fara.gov/docs/5817-Exhibit-AB-20070807-2.pdf | |
86193 | 86193 | 2020-08-07 | Rokk Solutions LLC | Rokk Solutions LLC 6849 | Exhibit AB | Ramiro Maldonado | GUATEMALA | https://efile.fara.gov/docs/6849-Exhibit-AB-20200807-1.pdf | |
86331 | 86331 | 2003-08-08 | Tew Cardenas Rebak Kellogg Lehman DeMaria Tague Raymond & Levine, LLP | Tew Cardenas, LLP 5562 | Exhibit AB | Republic of Guatemala, Embassy | GUATEMALA | https://efile.fara.gov/docs/5562-Exhibit-AB-20030808-HJKNYM03.pdf | |
87790 | 87790 | 2008-08-15 | Bracy Tucker Brown, Inc. | Bracy Tucker Brown, Inc. 5878 | Exhibit AB | FundaSistemas | GUATEMALA | https://efile.fara.gov/docs/5878-Exhibit-AB-20080815-1.pdf | |
92871 | 92871 | 1987-09-01 | CAMERON, BRUCE P. | Cameron, Bruce P. 4043 | Exhibit AB | PRESIDENCY OF THE REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4043-Exhibit-AB-19870901-D1J4I302.pdf | |
93707 | 93707 | 1991-09-01 | ED GRAVES & ASSOCIATES | Ed Graves & Associates 4541 | Exhibit AB | CBI SUGAR GROUP | GUATEMALA | https://efile.fara.gov/docs/4541-Exhibit-AB-19910901-D1UA8I04.pdf | |
96459 | 96459 | 2021-09-08 | Sonoran Policy Group, LLC | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | Exhibit AB | Zury Mayte Rios de Smith | GUATEMALA | https://efile.fara.gov/docs/6399-Exhibit-AB-20210908-48.pdf | |
96684 | 96684 | 1990-09-10 | CAMERON, BRUCE P. | Cameron, Bruce P. 4043 | Exhibit AB | CENTRO ESTNA | GUATEMALA | https://efile.fara.gov/docs/4043-Exhibit-AB-19900910-D1J49Q02.pdf | |
97724 | 97724 | 2012-09-14 | Arnold & Porter, LLP | Arnold & Porter Kaye Scholer LLP 1750 | Exhibit AB | Instituto Guatelmalteco de Turismo - INGUAT (Guatemalan Institute of Tourism) | GUATEMALA | https://efile.fara.gov/docs/1750-Exhibit-AB-20120914-14.pdf | |
100126 | 100126 | 2018-09-24 | Barnes & Thornburg LLP | Barnes & Thornburg LLP 6594 | Exhibit AB | BATAB Coalition | GUATEMALA | https://efile.fara.gov/docs/6594-Exhibit-AB-20180924-2.pdf | |
102975 | 102975 | 1969-10-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Exhibit AB | CENTRAL AMERICAN SUGAR COUNCIL | GUATEMALA | https://efile.fara.gov/docs/2165-Exhibit-AB-19691001-DBBHE202.pdf | |
103435 | 103435 | 1980-10-01 | HANNAFORD COMPANY, INC. | Hannaford Company, Inc. 2850 | Exhibit AB | FUNDACION GUATEMALTECA POR LA LIBERTAD | GUATEMALA | https://efile.fara.gov/docs/2850-Exhibit-AB-19801001-D06XC503.pdf | |
104029 | 104029 | 1986-10-01 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Exhibit AB | REPUBLIC OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/3901-Exhibit-AB-19861001-D1836D02.pdf | |
105049 | 105049 | 1991-10-01 | SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS | Susan Davis International & Public Affairs 3444 | Exhibit AB | UNION DEL CENTRO NACIONAL | GUATEMALA | https://efile.fara.gov/docs/3444-Exhibit-AB-19911001-D0PLY501.pdf | |
109485 | 109485 | 1995-10-18 | R. THOMPSON & COMPANY | R. Thompson & Company 4950 | Exhibit AB | GOVERNMENT OF GUATEMALA | GUATEMALA | https://efile.fara.gov/docs/4950-Exhibit-AB-19951018-DHFFI002.pdf | |
114412 | 114412 | 1980-11-01 | HANNAFORD COMPANY, INC. | Hannaford Company, Inc. 2850 | Exhibit AB | ASOCIACION DE AMIGOS DEL PAIS | GUATEMALA | https://efile.fara.gov/docs/2850-Exhibit-AB-19801101-D06XAN03.pdf | |
122678 | 122678 | 1970-11-30 | Modern Education Services, Inc. | Modern Education Services, Inc. 1803 | Exhibit AB | Secretaria de Integracion Turista Centroamericana (SITCA) | GUATEMALA | https://efile.fara.gov/docs/1803-Exhibit-AB-19701130-HDC9S403.pdf | |
124918 | 124918 | 1980-12-01 | M. SILVER ASSOCIATES, INC. | M. Silver Associates, Inc. 3131 | Exhibit AB | GUATEMALA TOURIST COMMISSION | GUATEMALA | https://efile.fara.gov/docs/3131-Exhibit-AB-19801201-D0JVZG01.pdf | |
128254 | 128254 | 2006-12-01 | Holland & Knight | Holland & Knight 3718 | Exhibit AB | Coordinadora de las Comunidades Afectadas por la Construccion de la Hidroelectrica Chixoy (COCAHICH) | GUATEMALA | https://efile.fara.gov/docs/3718-Exhibit-AB-20061201-1.pdf | |
129617 | 129617 | 2015-12-07 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | PRONACOM (Programa Nacional de la Competitividad) | GUATEMALA | https://efile.fara.gov/docs/3712-Exhibit-AB-20151207-21.pdf |
Advanced export
JSON shape: default, array, newline-delimited
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]) );