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"
This data as json, CSV (advanced)
Registrant_Name >30
- HILL & KNOWLTON, INC. 1,219
- Daniel J. Edelman, Inc. 649
- Ogilvy Public Relations Worldwide 305
- ARNOLD & PORTER 290
- BURSON-MARSTELLER 279
- Hill & Knowlton, Inc. 263
- Amtorg Trading Corporation 245
- JETRO, New York 243
- Commonwealth of Dominica Maritime Registry, Inc. 224
- DANIEL J. EDELMAN, INC. 221
- RUDER & FINN, INC. 221
- NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. 217
- WHITE & CASE 209
- Mercury Public Affairs, LLC 197
- SQUIRE, SANDERS & DEMPSEY 195
- DLA Piper US LLP 193
- AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 187
- Hill and Knowlton Strategies, LLC 178
- Qorvis Communications, LLC 173
- Ketchum Inc. NY 167
- Fleishman-Hillard, Inc. 165
- Akin, Gump, Strauss, Hauer & Feld, LLP 158
- MMGY Global, LLC 158
- NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) 152
- JETRO, NEW YORK 151
- Patton Boggs, L.L.P. 146
- MSLGROUP Americas, Inc. 145
- Korea Trade Promotion Center 143
- BGR Government Affairs, LLC 141
- QUEBEC GOVERNMENT HOUSE 135
- …
Foreign_Principal_Name 1
- - 29,641
Foreign_Principal_Country 1
- - 29,641
Document_Type 1
- Short-Form · 29,641 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
36095 | 36095 | 1992-04-01 | JONES, DAY, REAVIS & POGUE | Jones Day 3427 | Short-Form | CHARLES MCC. MATHIAS, JR. | Available-FARA-Public-Office | ||
36103 | 36103 | 1992-04-01 | KLEBAN & SAMOR, P.C. | Kleban & Samor, P.C. 4653 | Short-Form | RICHARD L. ROSE | Available-FARA-Public-Office | ||
36106 | 36106 | 1992-04-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIAKI BABA | Available-FARA-Public-Office | ||
36152 | 36152 | 1992-04-01 | LOCATE IN SCOTLAND | Scottish Enterprise 3013 | Short-Form | MARK HALLAN | Available-FARA-Public-Office | ||
36173 | 36173 | 1992-04-01 | NEIL GOLDSCHMIDT, INC. | Neil Goldschmidt, Inc. 4644 | Short-Form | NEIL GOLDSCHMIDT | Available-FARA-Public-Office | ||
36176 | 36176 | 1992-04-01 | NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | Short-Form | SERGEI LUBIMOV | Available-FARA-Public-Office | ||
36212 | 36212 | 1992-04-01 | PANTIN PARTNERSHIP, INC. | Pantin Partnership, Inc. 4617 | Short-Form | MERCEDES S. PRIETO | Available-FARA-Public-Office | ||
36216 | 36216 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | BENJAMIN O. TAYLOE | Available-FARA-Public-Office | ||
36217 | 36217 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | DOROTHY C. STONE | Available-FARA-Public-Office | ||
36218 | 36218 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | E. SCOTT POLIKOV | Available-FARA-Public-Office | ||
36219 | 36219 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | HARUYUKI SHIMURA | Available-FARA-Public-Office | ||
36220 | 36220 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | LOUISE NICHOLSON HOWE | Available-FARA-Public-Office | ||
36221 | 36221 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | MELISSA ROOVER | Available-FARA-Public-Office | ||
36222 | 36222 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | PARKER E. BRUGGE | Available-FARA-Public-Office | ||
36223 | 36223 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | SCOTT N. STONE | Available-FARA-Public-Office | ||
36224 | 36224 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | SHEILA M. FORAN | Available-FARA-Public-Office | ||
36225 | 36225 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | W. CAFFEY NORMAN, III | Available-FARA-Public-Office | ||
36226 | 36226 | 1992-04-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | WAYNE L. FIRESTONE | Available-FARA-Public-Office | ||
36233 | 36233 | 1992-04-01 | PINTAK COMMUNICATIONS INTERNATIONAL, LTD. | Pintak Communications International, Ltd. 4673 | Short-Form | LAWRENCE E. PINTAK | Available-FARA-Public-Office | ||
36238 | 36238 | 1992-04-01 | PRESTON, GATES & ELLIS | Preston, Gates & Ellis, L.L.P. 3567 | Short-Form | KATHRYN RAILSBACK | Available-FARA-Public-Office | ||
36239 | 36239 | 1992-04-01 | PRESTON, GATES & ELLIS | Preston, Gates & Ellis, L.L.P. 3567 | Short-Form | RICHARD D. FORD | Available-FARA-Public-Office | ||
36259 | 36259 | 1992-04-01 | ROBISON INTERNATIONAL, INC. | Robison International, Inc. 3950 | Short-Form | STEPHEN A. EVERED | Available-FARA-Public-Office | ||
36265 | 36265 | 1992-04-01 | RUDER & FINN, INC. | Ruder Finn, Inc. 1481 | Short-Form | RONALD WILLIAM RUBINOW | Available-FARA-Public-Office | ||
36313 | 36313 | 1992-04-01 | SCHNADER, HARRISON, SEGAL & LEWIS | Schnader, Harrison, Segal & Lewis 3330 | Short-Form | JEROME J. SHESTACK | Available-FARA-Public-Office | ||
36336 | 36336 | 1992-04-01 | TKC INTERNATIONAL, INC. | TKC International, Inc. 3075 | Short-Form | MARGARET GROSS | Available-FARA-Public-Office | ||
36353 | 36353 | 1992-04-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | MAX LEE FRIEDERSDORF | Available-FARA-Public-Office | ||
36354 | 36354 | 1992-04-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | MAX LEE FRIEDERSDORF | Available-FARA-Public-Office | ||
36417 | 36417 | 1993-04-01 | APCO ASSOCIATES, INC. | APCO Worldwide, Inc. 4561 | Short-Form | DON L. BONKER | Available-FARA-Public-Office | ||
36453 | 36453 | 1993-04-01 | CANADIAN CONNECTION, LTD. | Canadian Connection, Ltd. 4800 | Short-Form | EDWARD FARLEY BURKE | Available-FARA-Public-Office | ||
36473 | 36473 | 1993-04-01 | CLARKE & COMPANY, INC. | Clarke & Company, Inc. 4074 | Short-Form | MELISSA A. GEOFFROY | Available-FARA-Public-Office | ||
36488 | 36488 | 1993-04-01 | CRAWFORD & COMPANY PUBLIC RELATIONS | Crawford & Company Public Relations 4796 | Short-Form | CHARLES S. CRAWFORD | Available-FARA-Public-Office | ||
36490 | 36490 | 1993-04-01 | CROWELL & MORING INTERNATIONAL, L.P. | Crowell & Moring International, LLC 3988 | Short-Form | KATHRYN HEATHER BARBARA CLEMANS | Available-FARA-Public-Office | ||
36502 | 36502 | 1993-04-01 | DANIEL J. EDELMAN, INC. | Daniel J. Edelman, Inc. 3657 | Short-Form | SHARON J. COHEN | Available-FARA-Public-Office | ||
36503 | 36503 | 1993-04-01 | DAVID MOREY GROUP, INC. | David E. Morey 4688 | Short-Form | THOMAS R. LANSNER | Available-FARA-Public-Office | ||
36532 | 36532 | 1993-04-01 | EURAMERICA CAPITAL CORPORATION, LTD. | EurAmerica Capital Corporation, Ltd. 4794 | Short-Form | MARC L. HOLTZMAN | Available-FARA-Public-Office | ||
36536 | 36536 | 1993-04-01 | EUROSTRATEGY ASSOCIATES, INC. | Eurostrategy Associates, Inc. 4790 | Short-Form | SETH GOLDSCHLANGER | Available-FARA-Public-Office | ||
36541 | 36541 | 1993-04-01 | FOLEY, HOAG & ELIOT LLP | Foley Hoag, LLP 4776 | Short-Form | PAUL J. F. LUSAKA | Available-FARA-Public-Office | ||
36591 | 36591 | 1993-04-01 | HANFORE, YOHANNES | Hanfore, Yohannes 4788 | Short-Form | YOHANNES HANFORE | Available-FARA-Public-Office | ||
36734 | 36734 | 1993-04-01 | NATIONAL PETROLEUM COMPANY, "SUDAN", LTD. | National Petroleum Company, "Sudan", Ltd. 4797 | Short-Form | MOHAMAD A. EL-SHEIKH | Available-FARA-Public-Office | ||
36769 | 36769 | 1993-04-01 | PUBLIC STRATEGIES WASHINGTON, INC. | Public Strategies Washington, Inc. 4486 | Short-Form | PAUL M. SNYDER | Available-FARA-Public-Office | ||
36773 | 36773 | 1993-04-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | TREMBLAY BERTIN | Available-FARA-Public-Office | ||
36812 | 36812 | 1993-04-01 | SHAW, PITTMAN, POTTS & TROWBRIDGE | Shaw, Pittman, Potts & Trowbridge 2580 | Short-Form | JOHN B. RHINELANDER | Available-FARA-Public-Office | ||
36815 | 36815 | 1993-04-01 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | LINDA HINIKAR EDDLEMAN | Available-FARA-Public-Office | ||
36824 | 36824 | 1993-04-01 | THE LORD GROUP | Lord Group 4556 | Short-Form | ROBIN DAILY | Available-FARA-Public-Office | ||
36825 | 36825 | 1993-04-01 | THOMPSON & COMPANY | Thompson & Company 4094 | Short-Form | ROBERT L. MEUSER | Available-FARA-Public-Office | ||
36827 | 36827 | 1993-04-01 | THOMPSON GROUP, INC. | Thompson Group, Inc. 4792 | Short-Form | KENNETH THOMPSON | Available-FARA-Public-Office | ||
36839 | 36839 | 1993-04-01 | WASHINGTON POLICY & ANALYSIS, INC. | Washington Policy & Analysis, Inc. 4611 | Short-Form | WILLIAM F. MARTIN | Available-FARA-Public-Office | ||
36846 | 36846 | 1994-04-01 | O'CONNOR & HANNAN, LLP | O'Connor & Hannan, L.L.P. 2972 | Short-Form | THOMAS H. QUINN | Available-FARA-Public-Office | ||
36847 | 36847 | 1994-04-01 | O'CONNOR & HANNAN, LLP | O'Connor & Hannan, L.L.P. 2972 | Short-Form | TIMOTHY W. JENKINS | Available-FARA-Public-Office | ||
36858 | 36858 | 1994-04-01 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | JOHN ASHFORD | Available-FARA-Public-Office | ||
36864 | 36864 | 1994-04-01 | ROLLINS INTERNATIONAL, LTD. | Rollins International, Ltd. 4908 | Short-Form | EDWARD J. ROLLINS | Available-FARA-Public-Office | ||
36867 | 36867 | 1994-04-01 | WASHINGTON GROUP | Washington Group 4332 | Short-Form | MORGAN WILLIAM REED III | Available-FARA-Public-Office | ||
36873 | 36873 | 1997-04-01 | JAPAN NATIONAL TOURIST ORGANIZATION, CHICAGO | Japan National Tourist Organization, Chicago 2347 | Short-Form | TAKASHI NAGAOKA | Available-FARA-Public-Office | ||
36880 | 36880 | 1997-04-01 | SKADDEN, ARPS, SLATE, MEAGHER & FLOM, L.L.P. | Skadden, Arps, Slate, Meagher & Flom, L.L.P. 4550 | Short-Form | ROBERT S. BENNETT | Available-FARA-Public-Office | ||
36885 | 36885 | 1998-04-01 | EDELMAN, DANIEL J. | Daniel J. Edelman, Inc. 3634 | Short-Form | ANNE LOTMAN | Available-FARA-Public-Office | ||
36886 | 36886 | 1998-04-01 | EDELMAN, DANIEL J. | Daniel J. Edelman, Inc. 3634 | Short-Form | MICHAL LAWLER | Available-FARA-Public-Office | ||
36888 | 36888 | 1999-04-01 | INDIA TRADE PROMOTION ORGANIZATION | India Trade Promotion Organization 2975 | Short-Form | MEENAKSHISUNDARAM, SWAMIDORAI | Available-FARA-Public-Office | ||
36893 | 36893 | 1999-04-01 | YORKSHIRE AND HUMBER DEVELOPMENT AGENCY | Yorkshire Forward ( Yorkshire and Humber Regional Development Agency) 5310 | Short-Form | HEARD, MEGAN | Available-FARA-Public-Office | ||
36894 | 36894 | 1999-04-01 | YORKSHIRE AND HUMBER DEVELOPMENT AGENCY | Yorkshire Forward ( Yorkshire and Humber Regional Development Agency) 5310 | Short-Form | HIRST, KRISTEN | Available-FARA-Public-Office | ||
36895 | 36895 | 1999-04-01 | YORKSHIRE AND HUMBER DEVELOPMENT AGENCY | Yorkshire Forward ( Yorkshire and Humber Regional Development Agency) 5310 | Short-Form | RICHARDSON, JACQUELINE | Available-FARA-Public-Office | ||
36896 | 36896 | 1999-04-01 | YORKSHIRE AND HUMBER DEVELOPMENT AGENCY | Yorkshire Forward ( Yorkshire and Humber Regional Development Agency) 5310 | Short-Form | ROWLANDS, PETER | Available-FARA-Public-Office | ||
36897 | 36897 | 1999-04-01 | YORKSHIRE AND HUMBER INTERNATIONAL | Yorkshire Forward ( Yorkshire and Humber Regional Development Agency) 5310 | Short-Form | BEESON, SIMON | Available-FARA-Public-Office | ||
36904 | 36904 | 2002-04-01 | Covington & Burling | Covington & Burling 5489 | Short-Form | Eizenstat,Stuart E. | Available-FARA-Public-Office | ||
36905 | 36905 | 2002-04-01 | Covington & Burling | Covington & Burling 5489 | Short-Form | Marchick,David M. | Available-FARA-Public-Office | ||
36916 | 36916 | 2003-04-01 | Alston & Bird LLP | Alston & Bird, LLP 5549 | Short-Form | Dole,Robert J. | Available-FARA-Public-Office | ||
36917 | 36917 | 2003-04-01 | Alston & Bird LLP | Alston & Bird, LLP 5549 | Short-Form | Dole,Robert J. | Available-FARA-Public-Office | ||
36918 | 36918 | 2003-04-01 | Alston & Bird LLP | Alston & Bird, LLP 5549 | Short-Form | Dole,Robert J. | Available-FARA-Public-Office | ||
36919 | 36919 | 2003-04-01 | Alston & Bird LLP | Alston & Bird, LLP 5549 | Short-Form | Harris,Marshall F. | Available-FARA-Public-Office | ||
36920 | 36920 | 2003-04-01 | Alston & Bird LLP | Alston & Bird, LLP 5549 | Short-Form | Harris,Marshall F. | Available-FARA-Public-Office | ||
36921 | 36921 | 2003-04-01 | Alston & Bird LLP | Alston & Bird, LLP 5549 | Short-Form | Harris,Marshall F. | Available-FARA-Public-Office | ||
36923 | 36923 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Belkin ,Edward | Available-FARA-Public-Office | ||
36924 | 36924 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Colford,Chritopher | Available-FARA-Public-Office | ||
36925 | 36925 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Culvahouse,Sarah | Available-FARA-Public-Office | ||
36926 | 36926 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Kontos ,Michael | Available-FARA-Public-Office | ||
36927 | 36927 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | McFadden,Jessica Slovak | Available-FARA-Public-Office | ||
36928 | 36928 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Sarvis,Aubrey | Available-FARA-Public-Office | ||
36929 | 36929 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Schipper,Tom | Available-FARA-Public-Office | ||
36930 | 36930 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Sheehan,Maria | Available-FARA-Public-Office | ||
36931 | 36931 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Trammell,Jeffrey Bevis | Available-FARA-Public-Office | ||
36932 | 36932 | 2003-04-01 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Viorst,Marla | Available-FARA-Public-Office | ||
36937 | 36937 | 2003-04-01 | Whitaker Group, LLC | Whitaker Group, Inc. 5539 | Short-Form | Roske,Monique M. | Available-FARA-Public-Office | ||
36938 | 36938 | 2003-04-01 | Whitaker Group, LLC | Whitaker Group, Inc. 5539 | Short-Form | Whitaker,Rosa M. | Available-FARA-Public-Office | ||
36940 | 36940 | 2004-04-01 | Singapore Economic Development Board | Singapore Economic Development Board 2003 | Short-Form | Ho,Julian Wai-Kit | Available-FARA-Public-Office | ||
36941 | 36941 | 2004-04-01 | Singapore Economic Development Board | Singapore Economic Development Board 2003 | Short-Form | Man,Liu Chung | Available-FARA-Public-Office | ||
36943 | 36943 | 2005-04-01 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Horn,Robert J. | Available-FARA-Public-Office | ||
36949 | 36949 | 2008-04-01 | Harbour Group, LLC | Harbour Group, LLC 5478 | Short-Form | Sforza, Scott | https://efile.fara.gov/docs/5478-Short-Form-20080401-12.pdf | ||
36951 | 36951 | 2009-04-01 | Dickstein Shapiro, LLP | Dickstein Shapiro, LLP 3028 | Short-Form | Hastert, J. Dennis | https://efile.fara.gov/docs/3028-Short-Form-20090401-4.pdf | ||
36952 | 36952 | 2009-04-01 | Dickstein Shapiro, LLP | Dickstein Shapiro, LLP 3028 | Short-Form | Hutchinson, Tim | https://efile.fara.gov/docs/3028-Short-Form-20090401-6.pdf | ||
36953 | 36953 | 2009-04-01 | Dickstein Shapiro, LLP | Dickstein Shapiro, LLP 3028 | Short-Form | Mangas, Robert J. | https://efile.fara.gov/docs/3028-Short-Form-20090401-2.pdf | ||
36954 | 36954 | 2009-04-01 | Dickstein Shapiro, LLP | Dickstein Shapiro, LLP 3028 | Short-Form | Shulman, Allison | https://efile.fara.gov/docs/3028-Short-Form-20090401-8.pdf | ||
36958 | 36958 | 2009-04-01 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | Brathwaite, Paul A. | https://efile.fara.gov/docs/5926-Short-Form-20090401-4.pdf | ||
36959 | 36959 | 2009-04-01 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | Gerard, Randall | https://efile.fara.gov/docs/5926-Short-Form-20090401-6.pdf | ||
36960 | 36960 | 2009-04-01 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | Kauders, Andrew | https://efile.fara.gov/docs/5926-Short-Form-20090401-8.pdf | ||
36961 | 36961 | 2009-04-01 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | Morra, Elizabeth | https://efile.fara.gov/docs/5926-Short-Form-20090401-10.pdf | ||
36962 | 36962 | 2009-04-01 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | Podesta, Anthony T. | https://efile.fara.gov/docs/5926-Short-Form-20090401-2.pdf | ||
36963 | 36963 | 2009-04-01 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | Pryor, Walter | https://efile.fara.gov/docs/5926-Short-Form-20090401-12.pdf | ||
36964 | 36964 | 2009-04-01 | Podesta Group, Inc. | Podesta Group, Inc. 5926 | Short-Form | Scofield, John | https://efile.fara.gov/docs/5926-Short-Form-20090401-14.pdf | ||
36967 | 36967 | 2010-04-01 | ISCI-USA, Inc. | ISCI-USA, Inc. 5885 | Short-Form | Gaith, AlMudhafar | https://efile.fara.gov/docs/5885-Short-Form-20100401-4.pdf | ||
36973 | 36973 | 2011-04-01 | Hogan Lovells US LLP | Hogan Lovells US LLP 2244 | Short-Form | Calamaro, Raymond S. | https://efile.fara.gov/docs/2244-Short-Form-20110401-14.pdf | ||
36985 | 36985 | 2014-04-01 | Cornerstone Government Affairs, LLC | Cornerstone Government Affairs, LLC 6211 | Short-Form | Crumbliss, John | https://efile.fara.gov/docs/6211-Short-Form-20140401-88.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]) );