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

444 rows where Registrant_Name = "Podesta Group, Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Date_Stamped (date)

Foreign_Principal_Name >30

  • - 297
  • Embassy of the Republic of Azerbaijan 35
  • Republic of India, Embassy 23
  • Center for Studies and Media Affairs at Saudi Royal Court 13
  • Embassy of Japan 10
  • Republic of Korea, Embassy 9
  • Democratic Party of Moldova 7
  • Hong Kong Trade Development Council 7
  • Embassy of the Socialist Republic of Vietnam 6
  • Republic of Iraq 5
  • Republic of Albania 4
  • National Security Council of Georgia 3
  • Embassy of the Socialisr Republic of Vietnam 2
  • European Centre for a Modern Ukraine 2
  • Republic of South Sudan 2
  • Democratic Party of Albania 1
  • Federal Media Partner 1
  • Federal Republlc of Somalia 1
  • Government of Morocco, Embassy (through Private Public Solutions) 1
  • Government of Thailand, Embassy 1
  • Government of the Arab Republic of Egypt, Embassy, through the PLM Group 1
  • Mr. Salman Al-Ansari (through Saudi American Public Relation Affairs Committee, Inc.) 1
  • Ocean Advisory & Consulting W.L.L. through Andreae & Associates 1
  • Republic of Cyprus, Embassy 1
  • Republic of Kenya 1
  • Republic of Korea Embassy (through Porter Gordon Silver Communications, LLC) 1
  • Republic of Kosova 1
  • Republic of Kosovo, Embassy 1
  • Republic of Maldives 1
  • Republic of the Union of Myanmar 1
  • …

Foreign_Principal_Country 27

  • - 299
  • AZERBAIJAN 35
  • INDIA 23
  • SAUDI ARABIA 14
  • KOREA SOUTH 10
  • JAPAN 9
  • VIETNAM 8
  • HONG KONG 7
  • MOLDOVA 7
  • ALBANIA 5
  • IRAQ 5
  • GEORGIA 3
  • AFGHANISTAN 2
  • KOSOVA 2
  • REPUBLIC OF SOUTH SUDAN 2
  • UKRAINE 2
  • CYPRUS 1
  • EGYPT 1
  • KENYA 1
  • MALDIVES 1
  • MOROCCO 1
  • MYANMAR BURMA 1
  • QATAR 1
  • ROMANIA 1
  • SOMALI DEMOCRATIC REPUBLIC 1
  • SWITZERLAND 1
  • THAILAND 1

Document_Type 7

  • Short-Form 190
  • Exhibit AB 101
  • Amendment 84
  • Informational Materials 46
  • Supplemental Statement 20
  • Registration Statement 2
  • Exhibit C 1

Registrant_Name 1

  • Podesta Group, Inc. · 444 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
4801 4801 2011-01-11 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20110111-5.pdf
4802 4802 2011-01-11 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Oak, Dale     https://efile.fara.gov/docs/5926-Short-Form-20110111-96.pdf
5029 5029 2017-01-12 Podesta Group, Inc. Podesta Group, Inc. 5926 Informational Materials   Embassy of the Republic of Azerbaijan AZERBAIJAN https://efile.fara.gov/docs/5926-Informational-Materials-20170112-1.pdf
5030 5030 2017-01-12 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Thompson, Dana     https://efile.fara.gov/docs/5926-Short-Form-20170112-342.pdf
5786 5786 2015-01-16 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20150116-38.pdf
6244 6244 2017-01-19 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20170119-71.pdf
6428 6428 2017-01-20 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of the Republic of Azerbaijan AZERBAIJAN https://efile.fara.gov/docs/5926-Exhibit-AB-20170120-92.pdf
6781 6781 2015-01-22 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20150122-39.pdf
6782 6782 2015-01-22 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of the Socialist Republic of Vietnam VIETNAM https://efile.fara.gov/docs/5926-Exhibit-AB-20150122-53.pdf
6783 6783 2016-01-22 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20160122-51.pdf
6784 6784 2016-01-22 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Center for Studies and Media Affairs at Saudi Royal Court SAUDI ARABIA https://efile.fara.gov/docs/5926-Exhibit-AB-20160122-71.pdf
7506 7506 2017-01-25 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20170125-72.pdf
7507 7507 2017-01-25 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of the Socialist Republic of Vietnam VIETNAM https://efile.fara.gov/docs/5926-Exhibit-AB-20170125-93.pdf
7968 7968 2015-01-27 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20150127-40.pdf
7969 7969 2015-01-27 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of the Republic of Azerbaijan AZERBAIJAN https://efile.fara.gov/docs/5926-Exhibit-AB-20150127-54.pdf
8238 8238 2011-01-28 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Baierlein, Daniele     https://efile.fara.gov/docs/5926-Short-Form-20110128-108.pdf
8239 8239 2011-01-28 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Clark, Christine     https://efile.fara.gov/docs/5926-Short-Form-20110128-106.pdf
8240 8240 2011-01-28 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Kauders, Andrew     https://efile.fara.gov/docs/5926-Short-Form-20110128-104.pdf
8241 8241 2011-01-28 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Scofield, John     https://efile.fara.gov/docs/5926-Short-Form-20110128-100.pdf
8242 8242 2011-01-28 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Shagabutdinova, Ella     https://efile.fara.gov/docs/5926-Short-Form-20110128-102.pdf
8243 8243 2011-01-28 Podesta Group, Inc. Podesta Group, Inc. 5926 Supplemental Statement       https://efile.fara.gov/docs/5926-Supplemental-Statement-20110128-4.pdf
8627 8627 2015-01-29 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Adams, David     https://efile.fara.gov/docs/5926-Short-Form-20150129-272.pdf
8628 8628 2015-01-29 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Bohlen, Will     https://efile.fara.gov/docs/5926-Short-Form-20150129-278.pdf
8629 8629 2015-01-29 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Lawrence-Vaca, Jessica     https://efile.fara.gov/docs/5926-Short-Form-20150129-276.pdf
8630 8630 2015-01-29 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Lillenfeld, Claudio     https://efile.fara.gov/docs/5926-Short-Form-20150129-274.pdf
9063 9063 2012-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Supplemental Statement       https://efile.fara.gov/docs/5926-Supplemental-Statement-20120130-6.pdf
9117 9117 2014-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Kauders, Andrew     https://efile.fara.gov/docs/5926-Short-Form-20140130-248.pdf
9118 9118 2014-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Moore, Riley     https://efile.fara.gov/docs/5926-Short-Form-20140130-250.pdf
9119 9119 2014-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Supplemental Statement       https://efile.fara.gov/docs/5926-Supplemental-Statement-20140130-10.pdf
9143 9143 2015-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Kauders, Andrew     https://efile.fara.gov/docs/5926-Short-Form-20150130-284.pdf
9144 9144 2015-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Rademaker, Stephen     https://efile.fara.gov/docs/5926-Short-Form-20150130-282.pdf
9145 9145 2015-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Tavlarides, Mark     https://efile.fara.gov/docs/5926-Short-Form-20150130-280.pdf
9146 9146 2015-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Supplemental Statement       https://efile.fara.gov/docs/5926-Supplemental-Statement-20150130-12.pdf
9203 9203 2017-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Informational Materials   Center for Studies and Media Affairs at Saudi Royal Court SAUDI ARABIA https://efile.fara.gov/docs/5926-Informational-Materials-20170130-4.pdf
9204 9204 2017-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Informational Materials   Center for Studies and Media Affairs at Saudi Royal Court SAUDI ARABIA https://efile.fara.gov/docs/5926-Informational-Materials-20170130-6.pdf
9205 9205 2017-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Neal, Terry     https://efile.fara.gov/docs/5926-Short-Form-20170130-344.pdf
9206 9206 2017-01-30 Podesta Group, Inc. Podesta Group, Inc. 5926 Supplemental Statement       https://efile.fara.gov/docs/5926-Supplemental-Statement-20170130-16.pdf
10202 10202 2011-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Glassco, Tim     https://efile.fara.gov/docs/5926-Short-Form-20110131-110.pdf
10203 10203 2011-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Glassco, Tim     https://efile.fara.gov/docs/5926-Short-Form-20110131-98.pdf
10217 10217 2012-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20120131-11.pdf
10226 10226 2013-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of the Republic of Azerbaijan AZERBAIJAN https://efile.fara.gov/docs/5926-Exhibit-AB-20130131-23.pdf
10227 10227 2013-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Dyer, James     https://efile.fara.gov/docs/5926-Short-Form-20130131-174.pdf
10228 10228 2013-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Holly, Josh     https://efile.fara.gov/docs/5926-Short-Form-20130131-176.pdf
10229 10229 2013-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Podesta, Anthony T.     https://efile.fara.gov/docs/5926-Short-Form-20130131-178.pdf
10230 10230 2013-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Supplemental Statement       https://efile.fara.gov/docs/5926-Supplemental-Statement-20130131-8.pdf
10272 10272 2017-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Informational Materials   Center for Studies and Media Affairs at Saudi Royal Court SAUDI ARABIA https://efile.fara.gov/docs/5926-Informational-Materials-20170131-3.pdf
10273 10273 2017-01-31 Podesta Group, Inc. Podesta Group, Inc. 5926 Informational Materials   Center for Studies and Media Affairs at Saudi Royal Court SAUDI ARABIA https://efile.fara.gov/docs/5926-Informational-Materials-20170131-5.pdf
13429 13429 2016-02-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20160201-52.pdf
13430 13430 2016-02-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of the Republic of Azerbaijan AZERBAIJAN https://efile.fara.gov/docs/5926-Exhibit-AB-20160201-72.pdf
13670 13670 2015-02-02 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Lewin, Andrew     https://efile.fara.gov/docs/5926-Short-Form-20150202-286.pdf
13853 13853 2010-02-03 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   National Security Council of Georgia GEORGIA https://efile.fara.gov/docs/5926-Exhibit-AB-20100203-4.pdf
13854 13854 2010-02-03 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Anderson, John     https://efile.fara.gov/docs/5926-Short-Form-20100203-52.pdf
13855 13855 2010-02-03 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Baker, Teal     https://efile.fara.gov/docs/5926-Short-Form-20100203-50.pdf
13856 13856 2010-02-03 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Lawrence, Jessica     https://efile.fara.gov/docs/5926-Short-Form-20100203-54.pdf
13857 13857 2010-02-03 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form McKew, Molly     https://efile.fara.gov/docs/5926-Short-Form-20100203-48.pdf
13858 13858 2010-02-03 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Podesta, Anthony T.     https://efile.fara.gov/docs/5926-Short-Form-20100203-46.pdf
13879 13879 2014-02-03 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Anderson, John     https://efile.fara.gov/docs/5926-Short-Form-20140203-252.pdf
14641 14641 2013-02-06 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Chang, Benjamin     https://efile.fara.gov/docs/5926-Short-Form-20130206-180.pdf
15109 15109 2016-02-08 Podesta Group, Inc. Podesta Group, Inc. 5926 Supplemental Statement       https://efile.fara.gov/docs/5926-Supplemental-Statement-20160208-14.pdf
15315 15315 2017-02-09 Podesta Group, Inc. Podesta Group, Inc. 5926 Informational Materials   Republic of India, Embassy INDIA https://efile.fara.gov/docs/5926-Informational-Materials-20170209-7.pdf
15465 15465 2012-02-10 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20120210-12.pdf
15466 15466 2012-02-10 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of India, Embassy INDIA https://efile.fara.gov/docs/5926-Exhibit-AB-20120210-13.pdf
15472 15472 2014-02-10 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20140210-30.pdf
15473 15473 2014-02-10 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of India, Embassy INDIA https://efile.fara.gov/docs/5926-Exhibit-AB-20140210-33.pdf
15474 15474 2014-02-10 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Kirsch, Steven     https://efile.fara.gov/docs/5926-Short-Form-20140210-254.pdf
15485 15485 2015-02-10 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of Kenya KENYA https://efile.fara.gov/docs/5926-Exhibit-AB-20150210-55.pdf
15681 15681 2013-02-11 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Antelo, Cristina     https://efile.fara.gov/docs/5926-Short-Form-20130211-184.pdf
15682 15682 2013-02-11 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Gerard, Randall     https://efile.fara.gov/docs/5926-Short-Form-20130211-182.pdf
16089 16089 2013-02-13 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20130213-22.pdf
16090 16090 2013-02-13 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of India, Embassy INDIA https://efile.fara.gov/docs/5926-Exhibit-AB-20130213-24.pdf
16091 16091 2013-02-13 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of Iraq IRAQ https://efile.fara.gov/docs/5926-Exhibit-AB-20130213-25.pdf
17155 17155 2010-02-18 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20100218-1.pdf
17188 17188 2016-02-18 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20160218-54.pdf
17189 17189 2016-02-18 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of Iraq IRAQ https://efile.fara.gov/docs/5926-Exhibit-AB-20160218-73.pdf
17380 17380 2015-02-19 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Adams, David     https://efile.fara.gov/docs/5926-Short-Form-20150219-288.pdf
17386 17386 2016-02-19 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20160219-55.pdf
18235 18235 2017-02-23 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20170223-73.pdf
18236 18236 2017-02-23 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of the Republic of Azerbaijan AZERBAIJAN https://efile.fara.gov/docs/5926-Exhibit-AB-20170223-94.pdf
19332 19332 2015-02-27 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Transformation and Continuity through Roberti White, LLC AFGHANISTAN https://efile.fara.gov/docs/5926-Exhibit-AB-20150227-57.pdf
24092 24092 2013-03-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Anderson, John     https://efile.fara.gov/docs/5926-Short-Form-20130301-196.pdf
24093 24093 2013-03-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Holly, Josh     https://efile.fara.gov/docs/5926-Short-Form-20130301-198.pdf
24094 24094 2013-03-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Lawrence-Vaca, Jessica     https://efile.fara.gov/docs/5926-Short-Form-20130301-194.pdf
24095 24095 2013-03-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Moore, Riley     https://efile.fara.gov/docs/5926-Short-Form-20130301-190.pdf
24096 24096 2013-03-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Podesta, Anthony T.     https://efile.fara.gov/docs/5926-Short-Form-20130301-192.pdf
24097 24097 2013-03-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Rademarker, Stephen     https://efile.fara.gov/docs/5926-Short-Form-20130301-188.pdf
24098 24098 2013-03-01 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Tavlarides, Mark     https://efile.fara.gov/docs/5926-Short-Form-20130301-186.pdf
24508 24508 2015-03-02 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20150302-41.pdf
24509 24509 2015-03-02 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of India, Embassy INDIA https://efile.fara.gov/docs/5926-Exhibit-AB-20150302-56.pdf
24890 24890 2010-03-03 Podesta Group, Inc. Podesta Group, Inc. 5926 Supplemental Statement       https://efile.fara.gov/docs/5926-Supplemental-Statement-20100303-2.pdf
25175 25175 2013-03-04 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Griffis, Kevin     https://efile.fara.gov/docs/5926-Short-Form-20130304-200.pdf
25931 25931 2011-03-07 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20110307-6.pdf
25932 25932 2011-03-07 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20110307-7.pdf
25933 25933 2011-03-07 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Ramirez, Oscar     https://efile.fara.gov/docs/5926-Short-Form-20110307-114.pdf
25934 25934 2011-03-07 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Shagabutdinova, Ella     https://efile.fara.gov/docs/5926-Short-Form-20110307-112.pdf
25950 25950 2013-03-07 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Antelo, Cristina     https://efile.fara.gov/docs/5926-Short-Form-20130307-204.pdf
25951 25951 2013-03-07 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Kauders, Andrew     https://efile.fara.gov/docs/5926-Short-Form-20130307-202.pdf
26193 26193 2013-03-08 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Baierlein, Daniele     https://efile.fara.gov/docs/5926-Short-Form-20130308-206.pdf
26194 26194 2013-03-08 Podesta Group, Inc. Podesta Group, Inc. 5926 Short-Form Morgenstern, David     https://efile.fara.gov/docs/5926-Short-Form-20130308-208.pdf
26204 26204 2017-03-08 Podesta Group, Inc. Podesta Group, Inc. 5926 Amendment       https://efile.fara.gov/docs/5926-Amendment-20170308-74.pdf
26205 26205 2017-03-08 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of Iraq IRAQ https://efile.fara.gov/docs/5926-Exhibit-AB-20170308-95.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 · Queries took 544.335ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history