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

12,549 rows where Document_Type = "Amendment"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Registrant_Name >30

  • ARNOLD & PORTER 246
  • RUDER & FINN, INC. 142
  • HILL & KNOWLTON, INC. 135
  • APCO Worldwide, Inc. 115
  • Daniel J. Edelman, Inc. 113
  • Mercury Public Affairs, LLC 90
  • SHAW, PITTMAN, POTTS & TROWBRIDGE 85
  • Podesta Group, Inc. 84
  • CIVIC SERVICE, INC. 82
  • Squire Patton Boggs, LLP 82
  • Glover Park Group, LLC 80
  • L.A. MOTLEY & COMPANY 75
  • Pillsbury Winthrop Shaw Pittman, LLP 68
  • Arnold & Porter Kaye Scholer, LLP 66
  • ARENT FOX KINTNER PLOTKIN & KAHN, PLLC 60
  • Patton Boggs, LLP 60
  • APCO ASSOCIATES, INC. 59
  • Nelson Mullins Riley & Scarborough, LLP 58
  • Akin, Gump, Strauss, Hauer & Feld, LLP 57
  • HOGAN & HARTSON, L.L.P. 57
  • Hogan Lovells US LLP 57
  • BGR Government Affairs, LLC 53
  • BURSON-MARSTELLER 53
  • JONES, DAY, REAVIS & POGUE 53
  • Sonoran Policy Group, LLC 53
  • PATTON BOGGS, L.L.P. 52
  • Fratelli Group 51
  • Holland & Knight 50
  • Livingston Group, LLC 50
  • GARVEY, SCHUBERT & BARER 48
  • …

Foreign_Principal_Name 1

  • - 12,549

Foreign_Principal_Country 1

  • - 12,549

Document_Type 1

  • Amendment · 12,549 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
8 8 1948-01-01 NATIONAL FILM BOARD OF CANADA National Film Board of Canada 437 Amendment       https://efile.fara.gov/docs/437-Amendment-19480101-CXXZ6L02.pdf
11 11 1949-01-01 NATIONAL FILM BOARD OF CANADA National Film Board of Canada 437 Amendment       https://efile.fara.gov/docs/437-Amendment-19490101-CXXYPA02.pdf
23 23 1951-01-01 NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. Netherlands Chamber of Commerce in the U.S., Inc. 456 Amendment       https://efile.fara.gov/docs/456-Amendment-19510101-CXXRYX02.pdf
73 73 1961-01-01 CLEARY, GOTTLIEB, STEEN & HAMILTON Cleary, Gottlieb, Steen & Hamilton, LLP 508 Amendment       https://efile.fara.gov/docs/508-Amendment-19610101-CXZVNZ02.pdf
87 87 1964-01-01 AUSTRIAN TRADE COMMISSIONER IN THE U.S., CHICAGO Austrian Trade Commissioner in the U.S., Chicago 874 Amendment       https://efile.fara.gov/docs/874-Amendment-19640101-CYE7K603.pdf
89 89 1964-01-01 BRITISH TOURIST AUTHORITY VisitBritain 579 Amendment       https://efile.fara.gov/docs/579-Amendment-19640101-CY6MCV02.pdf
92 92 1964-01-01 GERMAN FEDERAL RAILROAD German Federal Railroad 945 Amendment       https://efile.fara.gov/docs/945-Amendment-19640101-CY97YO03.pdf
94 94 1964-01-01 ITALIAN GOVERNMENT TOURIST BOARD, NEW YORK Italian Government Tourist Board, New York 568 Amendment       https://efile.fara.gov/docs/568-Amendment-19640101-CY7AZX02.pdf
105 105 1965-01-01 BELGIAN NATIONAL TOURIST OFFICE Belgian National Tourist Office 529 Amendment       https://efile.fara.gov/docs/529-Amendment-19650101-CY1E6D06.pdf
106 106 1965-01-01 BRONZ & FARRELL Bronz & Farrell 1740 Amendment       https://efile.fara.gov/docs/1740-Amendment-19650101-CYWN8002.pdf
110 110 1965-01-01 IRISH TOURIST BOARD Tourism Ireland 536 Amendment       https://efile.fara.gov/docs/536-Amendment-19650101-CY1A2U06.pdf
122 122 1967-01-01 IRISH TOURIST BOARD Tourism Ireland 536 Amendment       https://efile.fara.gov/docs/536-Amendment-19670101-CY19JH06.pdf
125 125 1967-01-01 NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. Netherlands Chamber of Commerce in the U.S., Inc. 456 Amendment       https://efile.fara.gov/docs/456-Amendment-19670101-CXOO5W03.pdf
127 127 1967-01-01 RUDER & FINN, INC. Ruder Finn, Inc. 1481 Amendment       https://efile.fara.gov/docs/1481-Amendment-19670101-CYCYTZ03.pdf
131 131 1968-01-01 CHINA BOOKS & PERIODICALS, INC. China Books & Periodicals, Inc. 1350 Amendment       https://efile.fara.gov/docs/1350-Amendment-19680101-CYO17102.pdf
137 137 1968-01-01 IRISH TOURIST BOARD Tourism Ireland 536 Amendment       https://efile.fara.gov/docs/536-Amendment-19680101-CY19G106.pdf
138 138 1968-01-01 RUDER & FINN, INC. Ruder Finn, Inc. 1481 Amendment       https://efile.fara.gov/docs/1481-Amendment-19680101-CYE4UU03.pdf
187 187 1971-01-01 RUDER & FINN, INC. Ruder Finn, Inc. 1481 Amendment       https://efile.fara.gov/docs/1481-Amendment-19710101-CYCPNA03.pdf
195 195 1971-01-01 VAN BRUNT & COMPANY ADVERTISING-MARKETING, INC. Van Brunt & Company Advertising-Marketing, Inc. 1704 Amendment       https://efile.fara.gov/docs/1704-Amendment-19710101-CYPW6J02.pdf
199 199 1972-01-01 BARBADOS INVESTMENT & DEVELOPMENT CORP. BARBADOS TOURISM Barbados Investment & Development Corp. Barbados Tourism 1995 Amendment       https://efile.fara.gov/docs/1995-Amendment-19720101-CZ9LMI03.pdf
202 202 1972-01-01 DEVELOPMENT COUNSELLORS INTERNATIONAL, LTD. Development Counsellors International, Ltd. 1421 Amendment       https://efile.fara.gov/docs/1421-Amendment-19720101-CYZ62A03.pdf
212 212 1972-01-01 KOREA TRADE PROMOTION CENTER, NEW YORK KOTRA 1619 Amendment       https://efile.fara.gov/docs/1619-Amendment-19720101-CYAK9603.pdf
219 219 1972-01-01 RUDER & FINN, INC. Ruder Finn, Inc. 1481 Amendment       https://efile.fara.gov/docs/1481-Amendment-19720101-CYCQDO03.pdf
225 225 1973-01-01 ALPINE TOURIST COMMISSION Alpine Tourist Office 2052 Amendment       https://efile.fara.gov/docs/2052-Amendment-19730101-CZAEED01.pdf
227 227 1973-01-01 BRONZ & FARRELL Bronz & Farrell 1740 Amendment       https://efile.fara.gov/docs/1740-Amendment-19730101-CYWMOK02.pdf
238 238 1973-01-01 JAPAN ECONOMIC INSTITUTE OF AMERICA Japan Economic Institute of America 929 Amendment       https://efile.fara.gov/docs/929-Amendment-19730101-CY94U703.pdf
242 242 1973-01-01 JAPAN NATIONAL TOURIST ORGANIZATION, NEW YORK Japan National Tourism Organization 769 Amendment       https://efile.fara.gov/docs/769-Amendment-19730101-CYCBCX03.pdf
249 249 1973-01-01 WORLD ZIONIST ORGANIZATION - AMERICAN SECTION, INC. World Zionist Organization - American Section, Inc. 2278 Amendment       https://efile.fara.gov/docs/2278-Amendment-19730101-CZD9CV02.pdf
250 250 1974-01-01 ALPINE TOURIST COMMISSION Alpine Tourist Office 2052 Amendment       https://efile.fara.gov/docs/2052-Amendment-19740101-CZAEAJ01.pdf
256 256 1974-01-01 CAMARA OFICIAL ESPANOLA DE COMERCIO Camara Oficial Espanola de Comercio 2400 Amendment       https://efile.fara.gov/docs/2400-Amendment-19740101-CZOGIH01.pdf
262 262 1974-01-01 EUROPEAN TRAVEL COMMISSION European Travel Commission 574 Amendment       https://efile.fara.gov/docs/574-Amendment-19740101-CY7EDU02.pdf
265 265 1974-01-01 GOVERNMENT OF INDIA TOURIST OFFICE, NEW YORK India Tourism, New York 2329 Amendment       https://efile.fara.gov/docs/2329-Amendment-19740101-DBCHZL02.pdf
268 268 1974-01-01 INTERNATIONAL COUNCIL OF CRUISE LINES International Council of Cruise Lines 2036 Amendment       https://efile.fara.gov/docs/2036-Amendment-19740101-CZBD8B03.pdf
277 277 1974-01-01 NEW ZEALAND CENTRAL RESERVATIONS OFFICE New Zealand Central Reservations Office 672 Amendment       https://efile.fara.gov/docs/672-Amendment-19740101-DBD92302.pdf
282 282 1974-01-01 RUDER & FINN, INC. Ruder Finn, Inc. 1481 Amendment       https://efile.fara.gov/docs/1481-Amendment-19740101-CYCP4C03.pdf
291 291 1974-01-01 SWEDISH TOURIST OFFICE Swedish Tourist Office 68 Amendment       https://efile.fara.gov/docs/68-Amendment-19740101-DBKVF303.pdf
294 294 1974-01-01 WHITEHOUSE ASSOCIATES, INC. Whitehouse Associates, Inc. 2190 Amendment       https://efile.fara.gov/docs/2190-Amendment-19740101-DBOHOA01.pdf
306 306 1975-01-01 GOVERNMENT OF INDIA TOURIST OFFICE, LOS ANGELES Government of India Tourist Office, Los Angeles 2407 Amendment       https://efile.fara.gov/docs/2407-Amendment-19750101-CZN0WU02.pdf
312 312 1975-01-01 JAMAICA TOURIST BOARD, FLORIDA Jamaica Tourist Board, Florida 2360 Amendment       https://efile.fara.gov/docs/2360-Amendment-19750101-CZNEB402.pdf
328 328 1975-01-01 TURKISH CONSULATE OFFICE OF CULTURE & INFORMATION ATTACHE Turkish Consulate Office of Culture & Information Attache 498 Amendment       https://efile.fara.gov/docs/498-Amendment-19750101-CXZDAU01.pdf
339 339 1976-01-01 GRENADA BOARD OF TOURISM Grenada Board of Tourism 2378 Amendment       https://efile.fara.gov/docs/2378-Amendment-19760101-CZNAJG02.pdf
364 364 1977-01-01 ALDEN FILMS, BUSINESS EDUCATION FILMS, FILMS OF THE NATIONS Alden Films, Business Education Films, Films of the Nations 2100 Amendment       https://efile.fara.gov/docs/2100-Amendment-19770101-CZBKW603.pdf
365 365 1977-01-01 ARAB INFORMATION CENTER Arab Information Center 876 Amendment       https://efile.fara.gov/docs/876-Amendment-19770101-CYPNFG02.pdf
377 377 1977-01-01 INTERNATIONAL PUBLIC RELATIONS COMPANY, LTD. International Public Relations Company, Ltd. 1967 Amendment       https://efile.fara.gov/docs/1967-Amendment-19770101-CZ2TOG01.pdf
392 392 1977-01-01 OFFICE OF THE TURKISH REPUBLIC OF NORTHERN CYPRUS Representative of the Turkish Republic of Northern Cyprus 2619 Amendment       https://efile.fara.gov/docs/2619-Amendment-19770101-D01NKK03.pdf
395 395 1977-01-01 SHAW, PITTMAN, POTTS & TROWBRIDGE Shaw, Pittman, Potts & Trowbridge 2580 Amendment       https://efile.fara.gov/docs/2580-Amendment-19770101-CZZPOM03.pdf
408 408 1978-01-01 DANISH TOURIST BOARD VisitDenmark 634 Amendment       https://efile.fara.gov/docs/634-Amendment-19780101-CYAWTB03.pdf
428 428 1978-01-01 KOREA INTERNATL TRADE ASSN, INC. Korea International Trade Association, Inc. 2686 Amendment       https://efile.fara.gov/docs/2686-Amendment-19780101-D03L1Q03.pdf
432 432 1978-01-01 MALAYSIAN INDUSTRIAL DEVELOPMENT AUTHORITY Malaysian Industrial Development Authority 2331 Amendment       https://efile.fara.gov/docs/2331-Amendment-19780101-DBCL4J02.pdf
439 439 1978-01-01 OFFICE OF TIBET Office of Tibet 1699 Amendment       https://efile.fara.gov/docs/1699-Amendment-19780101-CYPTE302.pdf
440 440 1978-01-01 PARTIDO DE LA LIBERACION DOMINICANA, NEW YORK Partido de la Liberacion Dominicana, New York 2509 Amendment       https://efile.fara.gov/docs/2509-Amendment-19780101-CZP3YI03.pdf
441 441 1978-01-01 QUEBEC GOVERNMENT HOUSE Quebec Government Office 1787 Amendment       https://efile.fara.gov/docs/1787-Amendment-19780101-CZ0KAX02.pdf
449 449 1979-01-01 ARAB INFORMATION CENTER Arab Information Center 876 Amendment       https://efile.fara.gov/docs/876-Amendment-19790101-CYPN1302.pdf
452 452 1979-01-01 BRITISH COLUMBIA GOVERNMENT British Columbia Government 2084 Amendment       https://efile.fara.gov/docs/2084-Amendment-19790101-CZBJJZ03.pdf
453 453 1979-01-01 BRONZ & FARRELL Bronz & Farrell 1740 Amendment       https://efile.fara.gov/docs/1740-Amendment-19790101-CYPSFK02.pdf
454 454 1979-01-01 BRONZ & FARRELL Bronz & Farrell 1740 Amendment       https://efile.fara.gov/docs/1740-Amendment-19790101-CYWLJW02.pdf
462 462 1979-01-01 HENRY DAVIS CORPORATION Henry Davis Corporation 2952 Amendment       https://efile.fara.gov/docs/2952-Amendment-19790101-D0D2K403.pdf
466 466 1979-01-01 IDA IRELAND IDA Ireland 1770 Amendment       https://efile.fara.gov/docs/1770-Amendment-19790101-CZ0DGY02.pdf
467 467 1979-01-01 IDA IRELAND IDA Ireland 1770 Amendment       https://efile.fara.gov/docs/1770-Amendment-19790101-CZ0DH602.pdf
468 468 1979-01-01 IDA IRELAND IDA Ireland 1770 Amendment       https://efile.fara.gov/docs/1770-Amendment-19790101-CZ0FMA02.pdf
484 484 1979-01-01 LEBOEUF, LAMB, GREENE & MACRAE, L.L.P. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 Amendment       https://efile.fara.gov/docs/2868-Amendment-19790101-D072RV03.pdf
492 492 1979-01-01 OFFICE OF THE TURKISH REPUBLIC OF NORTHERN CYPRUS Representative of the Turkish Republic of Northern Cyprus 2619 Amendment       https://efile.fara.gov/docs/2619-Amendment-19790101-D01NEV03.pdf
493 493 1979-01-01 OFFICE OF THE TURKISH REPUBLIC OF NORTHERN CYPRUS Representative of the Turkish Republic of Northern Cyprus 2619 Amendment       https://efile.fara.gov/docs/2619-Amendment-19790101-D01NF303.pdf
494 494 1979-01-01 OFFICE OF TIBET Office of Tibet 1699 Amendment       https://efile.fara.gov/docs/1699-Amendment-19790101-CYPTO402.pdf
513 513 1979-01-01 WHITE & CASE White & Case, LLP 2759 Amendment       https://efile.fara.gov/docs/2759-Amendment-19790101-D038BY03.pdf
516 516 1980-01-01 ARNOLD & PORTER Arnold & Porter Kaye Scholer, LLP 1750 Amendment       https://efile.fara.gov/docs/1750-Amendment-19800101-CYYHXD03.pdf
517 517 1980-01-01 ARNOLD & PORTER Arnold & Porter Kaye Scholer, LLP 1750 Amendment       https://efile.fara.gov/docs/1750-Amendment-19800101-CYYHZ503.pdf
532 532 1980-01-01 GRAYDON ASSOCIATES, INC. Graydon Associates, Inc. 2639 Amendment       https://efile.fara.gov/docs/2639-Amendment-19800101-CZZKQB03.pdf
533 533 1980-01-01 GRAYDON ASSOCIATES, INC. Graydon Associates, Inc. 2639 Amendment       https://efile.fara.gov/docs/2639-Amendment-19800101-CZZKSC03.pdf
534 534 1980-01-01 GRAYDON ASSOCIATES, INC. Graydon Associates, Inc. 2639 Amendment       https://efile.fara.gov/docs/2639-Amendment-19800101-CZZKSH03.pdf
535 535 1980-01-01 GRAYDON ASSOCIATES, INC. Graydon Associates, Inc. 2639 Amendment       https://efile.fara.gov/docs/2639-Amendment-19800101-CZZKTL03.pdf
536 536 1980-01-01 GRAYDON ASSOCIATES, INC. Graydon Associates, Inc. 2639 Amendment       https://efile.fara.gov/docs/2639-Amendment-19800101-CZZLMA03.pdf
542 542 1980-01-01 ITALIAN GOVERNMENT TRAVEL OFFICE, CHICAGO Italian Government Travel Office, Chicago 1892 Amendment       https://efile.fara.gov/docs/1892-Amendment-19800101-CZAD2U01.pdf
564 564 1980-01-01 ST. LUCIA TOURIST BOARD St. Lucia Tourist Board 2668 Amendment       https://efile.fara.gov/docs/2668-Amendment-19800101-D057B304.pdf
569 569 1980-01-01 WHITE & CASE White & Case, LLP 2759 Amendment       https://efile.fara.gov/docs/2759-Amendment-19800101-D026Z003.pdf
573 573 1981-01-01 ARENT FOX KINTNER PLOTKIN & KAHN, PLLC Arent Fox Kintner Plotkin & Kahn, PLLC 2661 Amendment       https://efile.fara.gov/docs/2661-Amendment-19810101-D03XW503.pdf
574 574 1981-01-01 ARENT FOX KINTNER PLOTKIN & KAHN, PLLC Arent Fox Kintner Plotkin & Kahn, PLLC 2661 Amendment       https://efile.fara.gov/docs/2661-Amendment-19810101-D054JL04.pdf
575 575 1981-01-01 ARNOLD & PORTER Arnold & Porter Kaye Scholer, LLP 1750 Amendment       https://efile.fara.gov/docs/1750-Amendment-19810101-CYYGVD03.pdf
578 578 1981-01-01 AUSTRIAN NATIONAL TOURIST OFFICE, MIDWEST OFFICE Austrian National Tourist Office, Midwest Office 2457 Amendment       https://efile.fara.gov/docs/2457-Amendment-19810101-CZMWX102.pdf
579 579 1981-01-01 AUSTRIAN TRADE COMMISSIONER IN THE U.S., CHICAGO Austrian Trade Commissioner in the U.S., Chicago 874 Amendment       https://efile.fara.gov/docs/874-Amendment-19810101-CYE6JE03.pdf
585 585 1981-01-01 DDB NEEDHAM WORLDWIDE, INC. DDB Worldwide Communications Group, Inc. 1066 Amendment       https://efile.fara.gov/docs/1066-Amendment-19810101-CYNTTJ02.pdf
586 586 1981-01-01 DDB NEEDHAM WORLDWIDE, INC. DDB Worldwide Communications Group, Inc. 1066 Amendment       https://efile.fara.gov/docs/1066-Amendment-19810101-CYNTTR02.pdf
613 613 1981-01-01 NATIONAL FEDERATION OF COFFEE GROWERS OF COLOMBIA National Federation of Coffee Growers of Colombia 2519 Amendment       https://efile.fara.gov/docs/2519-Amendment-19810101-CZP63003.pdf
619 619 1981-01-01 ROBINSONS, INC. Robinsons, Inc. 3110 Amendment       https://efile.fara.gov/docs/3110-Amendment-19810101-D0K6FA02.pdf
620 620 1981-01-01 ROBINSONS, INC. Robinsons, Inc. 3110 Amendment       https://efile.fara.gov/docs/3110-Amendment-19810101-D0K6FF02.pdf
622 622 1981-01-01 RUDER & FINN, INC. Ruder Finn, Inc. 1481 Amendment       https://efile.fara.gov/docs/1481-Amendment-19810101-CYCV5G03.pdf
623 623 1981-01-01 RUDER & FINN, INC. Ruder Finn, Inc. 1481 Amendment       https://efile.fara.gov/docs/1481-Amendment-19810101-CYCV7803.pdf
633 633 1982-01-01 JAPAN IRON & STEEL EXPORTERS' ASSOCIATION Japan Iron & Steel Federation 3155 Amendment       https://efile.fara.gov/docs/3155-Amendment-19820101-D0PFWU01.pdf
636 636 1982-01-01 ARNOLD & PORTER Arnold & Porter Kaye Scholer, LLP 1750 Amendment       https://efile.fara.gov/docs/1750-Amendment-19820101-CYYLAZ03.pdf
651 651 1982-01-01 FRANKL, WOLFE J. Frankl, Wolfe J. 3173 Amendment       https://efile.fara.gov/docs/3173-Amendment-19820101-D0PUU801.pdf
669 669 1982-01-01 LEBOEUF, LAMB, GREENE & MACRAE, L.L.P. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 Amendment       https://efile.fara.gov/docs/2868-Amendment-19820101-D072CL03.pdf
672 672 1982-01-01 M. SILVER ASSOCIATES, INC. M. Silver Associates, Inc. 3131 Amendment       https://efile.fara.gov/docs/3131-Amendment-19820101-D0JVJ101.pdf
673 673 1982-01-01 M. SILVER ASSOCIATES, INC. M. Silver Associates, Inc. 3131 Amendment       https://efile.fara.gov/docs/3131-Amendment-19820101-D0JVJP01.pdf
674 674 1982-01-01 M. SILVER ASSOCIATES, INC. M. Silver Associates, Inc. 3131 Amendment       https://efile.fara.gov/docs/3131-Amendment-19820101-D0JXTJ01.pdf
675 675 1982-01-01 M. SILVER ASSOCIATES, INC. M. Silver Associates, Inc. 3131 Amendment       https://efile.fara.gov/docs/3131-Amendment-19820101-D0K1AK02.pdf
682 682 1982-01-01 MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON Mudge, Rose, Guthrie, Alexander & Ferdon 3200 Amendment       https://efile.fara.gov/docs/3200-Amendment-19820101-D0Q3AE01.pdf
683 683 1982-01-01 MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON Mudge, Rose, Guthrie, Alexander & Ferdon 3200 Amendment       https://efile.fara.gov/docs/3200-Amendment-19820101-D0Q4W301.pdf
686 686 1982-01-01 OFFICE OF TIBET Office of Tibet 1699 Amendment       https://efile.fara.gov/docs/1699-Amendment-19820101-CYPTCQ02.pdf
687 687 1982-01-01 OFFICE OF TIBET Office of Tibet 1699 Amendment       https://efile.fara.gov/docs/1699-Amendment-19820101-CYPTH702.pdf
688 688 1982-01-01 OFFICE OF TIBET Office of Tibet 1699 Amendment       https://efile.fara.gov/docs/1699-Amendment-19820101-CYPTUI02.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 976.882ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history