FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40,054 rows where Document_Type = "Short-Form" sorted by Short_Form_Name
This data as json, CSV (advanced)
Registrant_Name >30
- HILL & KNOWLTON, INC. 1,522
- Daniel J. Edelman, Inc. 890
- ARNOLD & PORTER 448
- Hill & Knowlton, Inc. 416
- BURSON-MARSTELLER 389
- SQUIRE, SANDERS & DEMPSEY 343
- Ogilvy Public Relations Worldwide 331
- WHITE & CASE 318
- Amtorg Trading Corporation 314
- JETRO, New York 286
- RUDER & FINN, INC. 285
- DANIEL J. EDELMAN, INC. 281
- Mercury Public Affairs, LLC 271
- AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 269
- NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. 259
- MMGY Global, LLC 241
- Fleishman-Hillard, Inc. 236
- Commonwealth of Dominica Maritime Registry, Inc. 232
- DLA Piper US LLP 228
- QUEBEC GOVERNMENT HOUSE 228
- Akin, Gump, Strauss, Hauer & Feld, LLP 223
- JETRO, NEW YORK 218
- Ketchum Inc. NY 217
- FLEISHMAN-HILLARD, INC. 203
- Hill and Knowlton Strategies, LLC 203
- Qorvis Communications, LLC 199
- L.A. MOTLEY & COMPANY 190
- Podesta Group, Inc. 190
- NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) 186
- Patton Boggs, LLP 185
- …
Foreign_Principal_Name 1
- - 39,970
Foreign_Principal_Country 1
- - 39,970
Document_Type 1
- Short-Form · 39,970 ✖
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name ▼ | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
95202 | 95202 | 2010-09-02 | Beef + Lamb New Zealand, Ltd. | Beef + Lamb New Zealand, Ltd. 2526 | Short-Form | https://efile.fara.gov/docs/2526-Short-Form-20100902-8.pdf | |||
97699 | 97699 | 2009-09-14 | Quebec Government Office | Quebec Government Office 1787 | Short-Form | https://efile.fara.gov/docs/1787-Short-Form-20090914-100.pdf | |||
98185 | 98185 | 2009-09-16 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | https://efile.fara.gov/docs/5926-Short-Form-20090916-20.pdf | |||
99271 | 99271 | 1964-09-21 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
99808 | 99808 | 2008-09-23 | Latin America Information Office LLC | Latin America Information Office LLC 5609 | Short-Form | https://efile.fara.gov/docs/5609-Short-Form-20080923-34.pdf | |||
99814 | 99814 | 2009-09-23 | Global Communicators, LLC | Global Communicators, LLC 5817 | Short-Form | https://efile.fara.gov/docs/5817-Short-Form-20090923-50.pdf | |||
99815 | 99815 | 2009-09-23 | Global Communicators, LLC | Global Communicators, LLC 5817 | Short-Form | https://efile.fara.gov/docs/5817-Short-Form-20090923-54.pdf | |||
99816 | 99816 | 2009-09-23 | Global Communicators, LLC | Global Communicators, LLC 5817 | Short-Form | https://efile.fara.gov/docs/5817-Short-Form-20090923-56.pdf | |||
100363 | 100363 | 2009-09-25 | CMGRP, Inc. | IPG DXTRA, Inc 3911 | Short-Form | https://efile.fara.gov/docs/3911-Short-Form-20090925-38.pdf | |||
100364 | 100364 | 2009-09-25 | CMGRP, Inc. | IPG DXTRA, Inc 3911 | Short-Form | https://efile.fara.gov/docs/3911-Short-Form-20090925-40.pdf | |||
100372 | 100372 | 2009-09-25 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | https://efile.fara.gov/docs/5926-Short-Form-20090925-30.pdf | |||
102383 | 102383 | 2009-09-30 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | https://efile.fara.gov/docs/3712-Short-Form-20090930-334.pdf | |||
102384 | 102384 | 2009-09-30 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | https://efile.fara.gov/docs/3712-Short-Form-20090930-336.pdf | |||
102410 | 102410 | 2009-09-30 | Vision Americas, LLC | Vision Americas, LLC 5907 | Short-Form | https://efile.fara.gov/docs/5907-Short-Form-20090930-16.pdf | |||
102413 | 102413 | 2009-09-30 | Winston & Strawn, LLP | Winston & Strawn, LLP 5909 | Short-Form | https://efile.fara.gov/docs/5909-Short-Form-20090930-10.pdf | |||
102414 | 102414 | 2009-09-30 | Winston & Strawn, LLP | Winston & Strawn, LLP 5909 | Short-Form | https://efile.fara.gov/docs/5909-Short-Form-20090930-12.pdf | |||
102415 | 102415 | 2009-09-30 | Winston & Strawn, LLP | Winston & Strawn, LLP 5909 | Short-Form | https://efile.fara.gov/docs/5909-Short-Form-20090930-16.pdf | |||
107104 | 107104 | 2009-10-06 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Short-Form | https://efile.fara.gov/docs/3634-Short-Form-20091006-102.pdf | |||
107105 | 107105 | 2009-10-06 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Short-Form | https://efile.fara.gov/docs/3634-Short-Form-20091006-94.pdf | |||
107310 | 107310 | 2009-10-07 | Akin, Gump, Strauss, Hauer & Feld, LLP | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | Short-Form | https://efile.fara.gov/docs/3492-Short-Form-20091007-120.pdf | |||
107528 | 107528 | 2010-10-08 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | https://efile.fara.gov/docs/5801-Short-Form-20101008-132.pdf | |||
107529 | 107529 | 2010-10-08 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | https://efile.fara.gov/docs/5801-Short-Form-20101008-136.pdf | |||
107723 | 107723 | 2009-10-09 | McGuireWoods Consulting, LLC | McGuireWoods Consulting, LLC 5408 | Short-Form | https://efile.fara.gov/docs/5408-Short-Form-20091009-50.pdf | |||
107934 | 107934 | 2008-10-10 | Spring O'Brien & Company, Inc. | Spring O'Brien & Company, Inc. 5872 | Short-Form | https://efile.fara.gov/docs/5872-Short-Form-20081010-28.pdf | |||
108735 | 108735 | 2010-10-14 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | https://efile.fara.gov/docs/3712-Short-Form-20101014-344.pdf | |||
109803 | 109803 | 2009-10-19 | Geoffrey Weill Associates | Geoffrey Weill Associates 5773 | Short-Form | https://efile.fara.gov/docs/5773-Short-Form-20091019-16.pdf | |||
110237 | 110237 | 2009-10-21 | Van Scoyoc Associates, Inc. | Van Scoyoc Associates, Inc. 5401 | Short-Form | https://efile.fara.gov/docs/5401-Short-Form-20091021-36.pdf | |||
110238 | 110238 | 2009-10-21 | Van Scoyoc Associates, Inc. | Van Scoyoc Associates, Inc. 5401 | Short-Form | https://efile.fara.gov/docs/5401-Short-Form-20091021-38.pdf | |||
112581 | 112581 | 2008-10-30 | Polish National Tourist Office, New York | Polish National Tourist Office, New York 4762 | Short-Form | https://efile.fara.gov/docs/4762-Short-Form-20081030-4.pdf | |||
112592 | 112592 | 2009-10-30 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3657 | Short-Form | https://efile.fara.gov/docs/3657-Short-Form-20091030-318.pdf | |||
112593 | 112593 | 2009-10-30 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3657 | Short-Form | https://efile.fara.gov/docs/3657-Short-Form-20091030-322.pdf | |||
112594 | 112594 | 2009-10-30 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3657 | Short-Form | https://efile.fara.gov/docs/3657-Short-Form-20091030-336.pdf | |||
113523 | 113523 | 2008-10-31 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3657 | Short-Form | https://efile.fara.gov/docs/3657-Short-Form-20081031-202.pdf | |||
119680 | 119680 | 2010-11-15 | Nelson Mullins Riley & Scarborough, LLP | Nelson Mullins Riley & Scarborough, LLP 5928 | Short-Form | https://efile.fara.gov/docs/5928-Short-Form-20101115-16.pdf | |||
119681 | 119681 | 2010-11-15 | Nelson Mullins Riley & Scarborough, LLP | Nelson Mullins Riley & Scarborough, LLP 5928 | Short-Form | https://efile.fara.gov/docs/5928-Short-Form-20101115-20.pdf | |||
119682 | 119682 | 2010-11-15 | Nelson Mullins Riley & Scarborough, LLP | Nelson Mullins Riley & Scarborough, LLP 5928 | Short-Form | https://efile.fara.gov/docs/5928-Short-Form-20101115-22.pdf | |||
120409 | 120409 | 2010-11-18 | Mercer & Associates, Inc. | Mercer & Associates, Inc. 5923 | Short-Form | https://efile.fara.gov/docs/5923-Short-Form-20101118-4.pdf | |||
120818 | 120818 | 2003-11-20 | Tourism Ireland Limited | Tourism Ireland Limited 5594 | Short-Form | Available-FARA-Public-Office | |||
120819 | 120819 | 2003-11-20 | Tourism Ireland Limited | Tourism Ireland Limited 5594 | Short-Form | Available-FARA-Public-Office | |||
123186 | 123186 | 2009-11-30 | Korea Business Center | KOTRA 1619 | Short-Form | https://efile.fara.gov/docs/1619-Short-Form-20091130-224.pdf | |||
123226 | 123226 | 2010-11-30 | Venable, LLP | Venable, LLP 5931 | Short-Form | https://efile.fara.gov/docs/5931-Short-Form-20101130-22.pdf | |||
123227 | 123227 | 2010-11-30 | Venable, LLP | Venable, LLP 5931 | Short-Form | https://efile.fara.gov/docs/5931-Short-Form-20101130-28.pdf | |||
123228 | 123228 | 2010-11-30 | Venable, LLP | Venable, LLP 5931 | Short-Form | https://efile.fara.gov/docs/5931-Short-Form-20101130-32.pdf | |||
123229 | 123229 | 2010-11-30 | Venable, LLP | Venable, LLP 5931 | Short-Form | https://efile.fara.gov/docs/5931-Short-Form-20101130-34.pdf | |||
128301 | 128301 | 2009-12-01 | Moffett Group, LLC | Moffett Group, LLC 5802 | Short-Form | https://efile.fara.gov/docs/5802-Short-Form-20091201-34.pdf | |||
128302 | 128302 | 2009-12-01 | Moffett Group, LLC | Moffett Group, LLC 5802 | Short-Form | https://efile.fara.gov/docs/5802-Short-Form-20091201-40.pdf | |||
128554 | 128554 | 2009-12-02 | MITA Group, Inc. | MITA Group, Inc. 5741 | Short-Form | https://efile.fara.gov/docs/5741-Short-Form-20091202-18.pdf | |||
128555 | 128555 | 2009-12-02 | MITA Group, Inc. | MITA Group, Inc. 5741 | Short-Form | https://efile.fara.gov/docs/5741-Short-Form-20091202-26.pdf | |||
128993 | 128993 | 2009-12-04 | Spectrum Group Members, LLC | Spectrum Group Members, LLC 5894 | Short-Form | https://efile.fara.gov/docs/5894-Short-Form-20091204-10.pdf | |||
128994 | 128994 | 2009-12-04 | Spectrum Group Members, LLC | Spectrum Group Members, LLC 5894 | Short-Form | https://efile.fara.gov/docs/5894-Short-Form-20091204-14.pdf | |||
129350 | 129350 | 2010-12-06 | India Tourism, New York | India Tourism, New York 2329 | Short-Form | https://efile.fara.gov/docs/2329-Short-Form-20101206-16.pdf | |||
129507 | 129507 | 1972-12-07 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
129706 | 129706 | 1980-12-08 | Bahamas Tourist Office | Bahamas Tourist Office 2310 | Short-Form | Available-FARA-Public-Office | |||
129793 | 129793 | 2010-12-08 | Lanny J. Davis & Associates, LLC | Lanny J. Davis & Associates, LLC 5985 | Short-Form | https://efile.fara.gov/docs/5985-Short-Form-20101208-4.pdf | |||
130896 | 130896 | 2010-12-14 | APCO Worldwide, Inc. | APCO Worldwide, Inc. 4561 | Short-Form | https://efile.fara.gov/docs/4561-Short-Form-20101214-104.pdf | |||
131123 | 131123 | 2009-12-15 | Hills Stern & Morley, LLP | Hills Stern & Morley, LLP 5965 | Short-Form | https://efile.fara.gov/docs/5965-Short-Form-20091215-4.pdf | |||
131131 | 131131 | 2010-12-15 | Overstreet, Larry L. | Oliver A. Dulle Jr. & Company 5246 | Short-Form | https://efile.fara.gov/docs/5246-Short-Form-20101215-4.pdf | |||
131334 | 131334 | 2008-12-16 | Livingston Group, LLC | Livingston Group, LLC 5356 | Short-Form | https://efile.fara.gov/docs/5356-Short-Form-20081216-60.pdf | |||
131580 | 131580 | 2009-12-17 | Picard Kentz & Rowe, LLP | Picard Kentz & Rowe, LLP 5939 | Short-Form | https://efile.fara.gov/docs/5939-Short-Form-20091217-12.pdf | |||
131590 | 131590 | 2010-12-17 | Lanny J. Davis & Associates, LLC | Lanny J. Davis & Associates, LLC 5985 | Short-Form | https://efile.fara.gov/docs/5985-Short-Form-20101217-6.pdf | |||
131993 | 131993 | 2008-12-19 | Gray Loeffler, LLC | Gray Global Advisors, LLC 5806 | Short-Form | https://efile.fara.gov/docs/5806-Short-Form-20081219-12.pdf | |||
132895 | 132895 | 2010-12-22 | Burson-Marsteller | Burson-Marsteller 2469 | Short-Form | https://efile.fara.gov/docs/2469-Short-Form-20101222-124.pdf | |||
133125 | 133125 | 2008-12-23 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | https://efile.fara.gov/docs/3301-Short-Form-20081223-502.pdf | |||
133126 | 133126 | 2008-12-23 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | https://efile.fara.gov/docs/3301-Short-Form-20081223-506.pdf | |||
104469 | 104469 | 1989-10-01 | SIDLEY & AUSTIN | Sidley Austin LLP 3731 | Short-Form | (KEN) YUN YOUNG-GAK | Available-FARA-Public-Office | ||
96999 | 96999 | 1991-09-11 | CASSIDY & ASSOCIATES, INC. | Cassidy & Associates, Inc. 4259 | Short-Form | (KEVIN) YUAN-ZHI ZHANG | Available-FARA-Public-Office | ||
100926 | 100926 | 2018-09-27 | Invest Northern Ireland | Invest Northern Ireland 4364 | Short-Form | :Lynn, Suzanne | https://efile.fara.gov/docs/4364-Short-Form-20180927-128.pdf | ||
6528 | 6528 | 1992-01-21 | UNION OF OROMO IN N.A.--TOKKUMMAA OROMOO AMEERIKAA BITAA | Union of Oromo in N.A.--Tokkummaa Oromoo Ameerikaa Bitaa 4425 | Short-Form | A. ALI ABOUBAKER | Available-FARA-Public-Office | ||
98353 | 98353 | 1991-09-17 | UNION OF OROMO IN N.A.--TOKKUMMAA OROMOO AMEERIKAA BITAA | Union of Oromo in N.A.--Tokkummaa Oromoo Ameerikaa Bitaa 4425 | Short-Form | A. ALI ABOUBAKER | Available-FARA-Public-Office | ||
30879 | 30879 | 1996-03-26 | DEUTSCHE TELEKOM, INC. | Deutsche Telekom, Inc. 4419 | Short-Form | A. BRADLEY SHINGLETON | Available-FARA-Public-Office | ||
94270 | 94270 | 1992-09-01 | MCGUIRE, WOODS, BATTLE & BOOTHE | McGuire, Woods, Battle & Boothe 4674 | Short-Form | A. BRADLEY SHINGLETON | Available-FARA-Public-Office | ||
52568 | 52568 | 1990-05-17 | GOVERNMENT OF ONTARIO, CANADA | Government of Ontario, Canada 2087 | Short-Form | A. BRUCE WILSON | Available-FARA-Public-Office | ||
128483 | 128483 | 1983-12-02 | GOVERNMENT OF ONTARIO, CANADA | Government of Ontario, Canada 2087 | Short-Form | A. BRUCE WILSON | Available-FARA-Public-Office | ||
110148 | 110148 | 1971-10-21 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | A. CAMPBELL BUCHANAN | Available-FARA-Public-Office | ||
32036 | 32036 | 1985-03-30 | GARVEY, SCHUBERT & BARER | Foster Garvey PC 3047 | Short-Form | A. DANIEL O'NEAL | Available-FARA-Public-Office | ||
92194 | 92194 | 1980-09-01 | GARVEY, SCHUBERT & BARER | Foster Garvey PC 3047 | Short-Form | A. DANIEL O'NEAL | Available-FARA-Public-Office | ||
70391 | 70391 | 1942-07-01 | FORT & SCHLEFER | Fort & Schlefer, L.L.P. 3630 | Short-Form | A. DAVID REYNOLDS | Available-FARA-Public-Office | ||
8110 | 8110 | 1983-01-28 | NEEDHAM & GROHMANN, INC. | Needham & Grohmann, Inc. 3451 | Short-Form | A. E. F. CORNWELL | Available-FARA-Public-Office | ||
450 | 450 | 1979-01-01 | ARAB INFORMATION CENTER | Arab Information Center 876 | Short-Form | A. HADI TORON | Available-FARA-Public-Office | ||
131685 | 131685 | 1989-12-18 | SAUDI REFINING, INC. | Saudi Refining, Inc. 4184 | Short-Form | A. J. AL-RAMADHAN | Available-FARA-Public-Office | ||
62341 | 62341 | 1992-06-03 | SAMEX TRADING COMPANY, INC. | Samex Trading Company, Inc. 4680 | Short-Form | A. JEFFREY ABRAMS | Available-FARA-Public-Office | ||
110149 | 110149 | 1971-10-21 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | A. KEES JORDAN | Available-FARA-Public-Office | ||
21077 | 21077 | 1979-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | A. KENNETH SHERE | Available-FARA-Public-Office | ||
26340 | 26340 | 1977-03-09 | WHITE & CASE | White & Case, LLP 2759 | Short-Form | A. LEE LUNDY, JR. | Available-FARA-Public-Office | ||
26094 | 26094 | 1976-03-08 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | A. LINWOOD HOLTON, JR. | Available-FARA-Public-Office | ||
98113 | 98113 | 1977-09-16 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | A. LINWOOD HOLTON, JR. | Available-FARA-Public-Office | ||
39873 | 39873 | 1995-04-13 | SHAPIRO & OLANDER | Shapiro & Olander 5014 | Short-Form | A. LYNNE PUCKETT | Available-FARA-Public-Office | ||
107467 | 107467 | 1997-10-08 | POWELL TATE, INC. | Powell Tate, Inc. 5148 | Short-Form | A. LYNNETTE MOTEN | Available-FARA-Public-Office | ||
95846 | 95846 | 1988-09-06 | ARTER & HADDEN | Arter & Hadden 3942 | Short-Form | A. MARIO CASTILLO | Available-FARA-Public-Office | ||
12144 | 12144 | 1990-02-01 | TEA COUNCIL OF THE U.S.A., INC. | Tea Council of the U.S.A., Inc. 1853 | Short-Form | A. MICHAEL FINN | Available-FARA-Public-Office | ||
29643 | 29643 | 1986-03-21 | ITALIAN PUBLIC RELATIONS ASSOCIATES - ITALPUBLIC, S.P.A. | Italian Public Relations Associates - Italpublic, S.p.A. 3676 | Short-Form | A. MICHAEL FINN | Available-FARA-Public-Office | ||
45599 | 45599 | 1973-05-01 | GOVERNMENT OF INDIA TOURIST OFFICE, LOS ANGELES | Government of India Tourist Office, Los Angeles 2407 | Short-Form | A. N. CHATURVEDI | Available-FARA-Public-Office | ||
10689 | 10689 | 1973-02-01 | GOVERNMENT OF INDIA TOURIST OFFICE, LOS ANGELES | Government of India Tourist Office, Los Angeles 2407 | Short-Form | A. P. CHOWDRY | Available-FARA-Public-Office | ||
8115 | 8115 | 1985-01-28 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | A. PATRICK DOYLE | Available-FARA-Public-Office | ||
82656 | 82656 | 1986-08-01 | WEIL, GOTSHAL, & MANGES, LLP | Weil, Gotshal & Manges, L.L.P. 3317 | Short-Form | A. PAUL VICTOR | Available-FARA-Public-Office | ||
81584 | 81584 | 1959-08-01 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | A. PHILIPPE VON HEMERT | Available-FARA-Public-Office | ||
1651 | 1651 | 1990-01-01 | STEPHENS OVERSEAS SERVICES, INC. | Stephens Overseas Services, Inc. 4283 | Short-Form | A. VERNON WEAVER | Available-FARA-Public-Office | ||
83102 | 83102 | 1989-08-01 | STEPHENS OVERSEAS SERVICES, INC. | Stephens Overseas Services, Inc. 4283 | Short-Form | A. VERNON WEAVER | Available-FARA-Public-Office | ||
7120 | 7120 | 1978-01-24 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | A. W. DIEDERIK QUINT | Available-FARA-Public-Office | ||
216 | 216 | 1972-01-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | A.E. SHRIMPTON | Available-FARA-Public-Office |
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]) );