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

14 rows where Registration_Number = 1434

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name

State 1

Registration_Number 1

  • European Free Trade Association · 14 ✖

Registrant_Name 1

City 1

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
3266 3266 1971-01-06 1966-08-24 Young George R. European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
4913 4913 1964-01-31 1963-01-17 Torbjornsen Tor European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
4938 4938 1973-01-31 1968-02-02 Davis Ernest Millett European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
4941 4941 1973-01-31 1961-03-13 Buraas Anders Tangen European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
4942 4942 1973-01-31 1961-03-13 Buraas Janette M.W. Maxwell European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
4945 4945 1973-01-31 1961-08-10 Williams David Carnahan European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
11393 11393 1964-03-31 1961-08-22 Gentry Richard Hayden European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
11414 11414 1970-03-31 1964-10-07 Mitchell Frank European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
14446 14446 1965-04-30 1965-02-26 Ben-Rubin Jack European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
19266 19266 1966-06-12 1964-02-28 Hansen Ole Christian Glavind European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
22826 22826 1968-07-09 1961-08-02 Jacobsen Edward Richard European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
24650 24650 1965-07-31 1964-06-04 Horner Franz European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
30865 30865 1966-09-30 1965-09-13 Leblhuber Alois European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005
38104 38104 1964-12-11 1963-07-15 Karegeannes Peter European Free Trade Association 1434 1961-03-13 European Free Trade Association 711 - 14th Street, N.W.   Washington DC 20005

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])
);