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

13 rows where Registration_Number = 477

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Norwegian Industries Commission · 13 ✖

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
3509 3509 1948-01-10 1947-07-10 Jebsen Gustav Adolf Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
3510 3510 1949-01-10 1947-07-10 Dueland Rudolf Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
3511 3511 1949-01-10 1947-07-10 Severud Fred Nicholas Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
12355 12355 1950-04-01 1950-02-15 Bruun Johannes Hadeln Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
12356 12356 1950-04-01 1950-02-21 Myhren Arne Johannes Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
12357 12357 1950-04-01 1949-05-09 Quande Erling Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
12358 12358 1950-04-01 1947-07-10 Andersen Bjorn Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
12359 12359 1950-04-01 1947-07-10 Gronningsater Anton Martin Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
12360 12360 1950-04-01 1947-07-10 Reimers Jan Herman Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
12361 12361 1950-04-01 1947-07-10 Wennberg Odd Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
12362 12362 1950-04-01 1947-07-10 Westbye John B. Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
14408 14408 1949-04-30 1948-08-20 Nyquist Nils Hoel Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 New York NY  
16353 16353 1949-05-15 1948-01-21 Graff Truls Wiel Norwegian Industries Commission 477 1947-07-10 Norwegian Industries Commission 21 East 40th Street Room 505 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])
);