FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

42,460 rows sorted by Registration_Date

✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

These facets timed out: Registrant_Name, State

Link rowid Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date ▼ Registrant_Name Address_1 Address_2 City State Zip
3348 3348 1963-01-07 1960-08-01 Rehder Robert George Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10491 10491 1960-03-22 1957-07-26 Watson Athur Kittredge Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10493 10493 1966-03-22 1962-07-30 Jones Gilbert Edward Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10570 10570 1965-03-23 1957-07-26 Farnstrom Bengt Olof Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10571 10571 1965-03-23 1960-08-01 Lowgren Karl Assar Uno Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10572 10572 1965-03-23 1960-08-01 Zetterberg Stig C. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10656 10656 1970-03-24 1961-07-31 Anderson Roger E. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10657 10657 1970-03-24 1961-07-31 Schmitt Elwood John Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10775 10775 1968-03-26 1960-08-01 Coyet C.A. Peter J. Gillison Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10777 10777 1969-03-26 1957-07-26 Gomperts Jack Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10778 10778 1969-03-26 1958-07-31 Haglund Didrik Wilhelm Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10779 10779 1969-03-26 1963-12-10 Winquist Raymond Victor Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10837 10837 1962-03-27 1960-08-01 Brent John Elford Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10838 10838 1962-03-27 1960-08-01 Hogman Carl Ake Alexander Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
10935 10935 1972-03-28 1966-08-01 Watts James W. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
11027 11027 1971-03-29 1959-07-23 Ohlsson Folke Erling Herlow Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
11028 11028 1971-03-29 1963-07-31 Broden Edwin Rauch Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
11029 11029 1971-03-29 1963-07-31 Unne Bertil Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
12378 12378 1963-04-01 1959-07-23 Lindahl Mac Olof Ernst Leonard Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
13680 13680 1968-04-18 1959-07-23 Haight Charles Sherman Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
19090 19090 1964-06-09 1963-07-31 Larsson Hans Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
22086 22086 1971-07-01 1961-07-31 Lindner Bo Gosta Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27625 27625 1972-08-29 1950-01-06 Grund Chester Verner Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27626 27626 1972-08-29 1950-01-06 Jonsson Arne Bertil Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27627 27627 1972-08-29 1950-01-06 Mollander Sven O. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27628 27628 1972-08-29 1950-01-06 Ollen Lillian E. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27629 27629 1972-08-29 1950-01-06 Ollen Olof Lennart Emanuel Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27630 27630 1972-08-29 1950-01-06 Swensson Sven Arne Theodor Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27631 27631 1972-08-29 1950-01-06 Werner Carl Gustaf William Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27632 27632 1972-08-29 1964-01-08 Pers Anders Harald Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27633 27633 1972-08-29 1954-01-26 Bengtsson John Bertil Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27634 27634 1972-08-29 1954-01-26 Elofsson Axel Fritiof Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27635 27635 1972-08-29 1951-01-30 Annerstedt James Halling Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27636 27636 1972-08-29 1951-01-30 Hjelmvik Sigvard Ragnns Anders Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27637 27637 1972-08-29 1951-01-30 Kumm Einar Axel Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27638 27638 1972-08-29 1956-02-02 Lewendal Lars Anders Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27639 27639 1972-08-29 1943-07-01 Marell Oscar Gustaf Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27640 27640 1972-08-29 1968-07-09 Forsberg Torsten Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27641 27641 1972-08-29 1954-07-23 Lagerfelt Adolf Carl-Henrik Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27642 27642 1972-08-29 1959-07-23 Agrell Goran (George) Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27643 27643 1972-08-29 1959-07-23 Carling Leif Einar Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27644 27644 1972-08-29 1959-07-23 Ericsson Gunnar Lennart Vilhelm Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27645 27645 1972-08-29 1959-07-23 Fris Erik Ivar Dunsterville Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27646 27646 1972-08-29 1959-07-23 Hatcher Rodney Neville Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27647 27647 1972-08-29 1952-07-24 Lindell Bror Emil Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27648 27648 1972-08-29 1955-07-26 Roth Carl Anders Reinhold Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27649 27649 1972-08-29 1957-07-26 Johnson Axel Aaxson , Jr. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27650 27650 1972-08-29 1962-07-30 Forsberg Franklin S. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27651 27651 1972-08-29 1962-07-30 Peterson Rudolph Arvid Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27652 27652 1972-08-29 1965-07-30 Jansson Karl Simon Stig Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27653 27653 1972-08-29 1961-07-31 Hagglund Erik H. Mason Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27654 27654 1972-08-29 1963-07-31 Cassel Carl Edvard Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27655 27655 1972-08-29 1963-07-31 Goranson Gustaf Erik Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27656 27656 1972-08-29 1963-07-31 Von Rosen Jan-Carl Adolf Eugene Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27657 27657 1972-08-29 1964-07-31 Blattmann Albert Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27658 27658 1972-08-29 1964-07-31 Radberg Lars Torstensson Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27659 27659 1972-08-29 1964-07-31 Sandemar Gosta Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27660 27660 1972-08-29 1960-08-01 Dahlberg Lars Sven Claes Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27661 27661 1972-08-29 1960-08-01 Shipley Linwood Parks Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27662 27662 1972-08-29 1966-08-01 Bochow John P. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27663 27663 1972-08-29 1967-08-01 Lennmalm Carl Olof Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27664 27664 1972-08-29 1967-08-01 Messler Eric G. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27665 27665 1972-08-29 1967-08-01 Stahlbrandt Ake Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27666 27666 1972-08-29 1967-08-01 Taapken Albertus Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27667 27667 1972-08-29 1972-08-01 Curran Michael W. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27668 27668 1972-08-29 1972-08-01 Heistein B.J. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27669 27669 1972-08-29 1972-08-01 Peet William J. , II Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27670 27670 1972-08-29 1956-08-02 Folke Harald Elis Ingemar Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27671 27671 1972-08-29 1956-08-02 Ringstrom Bengt Hugo Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27672 27672 1972-08-29 1971-08-03 Ankarcrona J.T. Claes Sason Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27673 27673 1972-08-29 1971-08-03 Fraser John M. , Jr. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27674 27674 1972-08-29 1971-08-03 Liljestrand Bengt Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27675 27675 1972-08-29 1971-08-03 Miller H. Wisner , Jr. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27676 27676 1972-08-29 1971-08-03 Norinder Bertil Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27677 27677 1972-08-29 1971-08-03 Sjowall Lars W. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27678 27678 1972-08-29 1969-08-05 De Groot Christopher Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27679 27679 1972-08-29 1969-08-05 Eliason Sven A. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27680 27680 1972-08-29 1969-08-05 Knopp Homer E. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27681 27681 1972-08-29 1969-08-05 Ohlsson Alvar Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27682 27682 1972-08-29 1969-08-05 Thiel George Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27683 27683 1972-08-29 1970-08-07 Brandt Ake J. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27684 27684 1972-08-29 1970-08-07 Douglas G.A. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27685 27685 1972-08-29 1970-08-07 Hansen Sven Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27686 27686 1972-08-29 1970-08-07 Lynch Robert M. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27687 27687 1972-08-29 1970-08-07 Mark Arne E. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27688 27688 1972-08-29 1970-08-07 Munson Eric Y. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27689 27689 1972-08-29 1970-08-07 Strachan Frank G. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27690 27690 1972-08-29 1965-09-08 Brightman Robert Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27691 27691 1972-08-29 1969-09-11 Jahn Tom F. Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27692 27692 1972-08-29 1953-09-18 Von Seth Torgil Emil Gabriel Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27693 27693 1972-08-29 1972-10-04 Reuterskiold Carl Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
27694 27694 1972-08-29 1964-11-18 Mossberg Hugo Karl Eije Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. 250 Park Avenue   New York NY 10017
22661 22661 1942-07-07 1942-07-07 Lejeune Hubert French National Railroads, New York 8 1942-07-07 French National Railroads, New York 610 Fifth Avenue   New York NY  
3383 3383 1943-01-08 1942-07-08 Bruno Harry A. H.A. Bruno & Associates 19 1942-07-08 H.A. Bruno & Associates 30 Rockefeller Plaza   New York NY  
3384 3384 1943-01-08 1942-07-08 Gudgeon Russell D. H.A. Bruno & Associates 19 1942-07-08 H.A. Bruno & Associates 30 Rockefeller Plaza   New York NY  
32428 32428 1946-10-08 1942-07-08 Alvarez Victor Garcia & Diaz 16 1942-07-08 Garcia & Diaz 17 Battery Place   New York NY  
32429 32429 1946-10-08 1942-07-08 Diaz Manuel Garcia & Diaz 16 1942-07-08 Garcia & Diaz 17 Battery Place   New York NY  
32430 32430 1946-10-08 1942-07-08 Garcia Marcelino Garcia & Diaz 16 1942-07-08 Garcia & Diaz 17 Battery Place   New York NY  
38066 38066 1950-12-11 1943-03-12 Lane Sanford H. Gotham Advertising Company 17 1942-07-08 Gotham Advertising Company 2 West 46th Street   New York NY  
38067 38067 1950-12-11 1943-03-12 Moscoso Octavio Elias Gotham Advertising Company 17 1942-07-08 Gotham Advertising Company 2 West 46th Street   New York NY  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);