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

29 rows where Registration_Number = 314

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Argentine Trade Promotion Corporation · 29 ✖

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
13939 13939 1947-04-23 1945-08-18 Ashby Anthony Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
13940 13940 1947-04-23 1945-08-18 Mejia Rafael Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
14017 14017 1947-04-24 1945-08-08 Reh Martha Shaw Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
14403 14403 1947-04-30 1945-08-18 Betzer Norman A. Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
14404 14404 1947-04-30 1946-10-14 Fornaciari Norma V. Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
16352 16352 1947-05-15 1946-10-14 Gicca Voltaire Ali Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
20267 20267 1946-06-26 1945-08-08 Smith Francis Brydon Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26199 26199 1947-08-08 1946-03-08 Barnes Barbara Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26200 26200 1947-08-08 1946-03-08 Forrest Edgar Marsh , II Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26201 26201 1947-08-08 1946-03-08 Marxuach Henry Arthur Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26202 26202 1947-08-08 1947-04-02 Pioletti Jose Camilo Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26203 26203 1947-08-08 1945-08-08 Close Albert Maurice Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26204 26204 1947-08-08 1945-08-08 Fritsch Peter H. Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26205 26205 1947-08-08 1945-08-08 Hubner Henry H. Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26206 26206 1947-08-08 1945-08-08 Mainster Murray D. Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26207 26207 1947-08-08 1945-08-08 Salazar Ralph Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26208 26208 1947-08-08 1945-08-08 Thompson Isabel Warford Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26209 26209 1947-08-08 1945-08-08 Tribe Ernest Fuller Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26210 26210 1947-08-08 1945-08-08 van Fleet Gloria Maria Ryss Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26211 26211 1947-08-08 1945-08-18 Campbell C. Arline Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26212 26212 1947-08-08 1945-08-18 Kemper Portia Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26213 26213 1947-08-08 1945-08-18 Weller Albert Otto Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26214 26214 1947-08-08 1946-10-14 Corbera Eugenia Maria Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26215 26215 1947-08-08 1946-10-14 Diaz Enrique Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
26216 26216 1947-08-08 1946-10-14 Schneidewind Eduardo Wilfredo Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
27828 27828 1945-08-31 1945-08-08 Lanus Gustavo Adolfo , Jr. Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
33229 33229 1946-10-20 1945-08-08 Carlson Rolland Douglas Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
36575 36575 1945-11-30 1945-08-08 Quade Henrietta Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  
39481 39481 1946-12-31 1945-08-18 Davis Elmer George Argentine Trade Promotion Corporation 314 1945-08-08 Argentine Trade Promotion Corporation 45 Rockefeller Plaza Room 557 New York NY  

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