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

47 rows where Registration_Number = 437

✎ View and edit SQL

This data as json, CSV (advanced)

State 1

Registration_Number 1

  • National Film Board of Canada · 47 ✖

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
3704 3704 1985-01-14 1969-08-07 Gee Albert Eric National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
4881 4881 1957-01-31 1952-12-23 Duerkop John Henry National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5635 5635 1954-02-01 1948-06-29 Brown Grace Marion National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5659 5659 1966-02-01 1956-01-16 Ward Ronald Claude National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5676 5676 1970-02-01 1964-01-20 Duerkop John National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5931 5931 1967-02-02 1964-01-20 Moodie James Robert National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5932 5932 1967-02-02 1963-07-31 Chatwin Leonard William National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
7281 7281 1973-02-20 1947-02-13 Savage Lilias Margaret National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
7282 7282 1973-02-20 1944-04-21 Carter Jane Margaret National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
7283 7283 1973-02-20 1944-04-21 Scellen Janet C.S. National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
7284 7284 1973-02-20 1955-09-21 Ellis Ralph Colin National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
7824 7824 1955-02-28 1953-12-14 Johnston Thomas Low National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
10368 10368 1970-03-20 1969-05-13 Anderson Herbert R. National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
11421 11421 1971-03-31 1967-08-01 Shere Alcon Kenneth National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
11480 11480 1978-03-31 1975-03-14 Ladouceur Ronald J. National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
11484 11484 1979-03-31 1977-02-22 Anderson Herbert National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
14136 14136 1980-04-26 1974-09-30 Moodie James Robert National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
14406 14406 1949-04-30 1947-02-13 Scythes Edwin Woolatt National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
14607 14607 1990-04-30 1988-06-14 Cournoyer Rachelle J. National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
15295 15295 1957-05-01 1955-06-21 Smith William Dean National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
15318 15318 1971-05-01 1968-02-01 Belleville Denis National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
15333 15333 1974-05-01 1971-08-10 Eliuk Douglas Selvester National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
16645 16645 1979-05-18 1979-03-05 Litwack William National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
17591 17591 1963-05-31 1963-01-09 Vale Robert Kenneth National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
18396 18396 1969-06-01 1966-02-01 Williams Kenneth Ashton National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
18414 18414 1974-06-01 1971-08-10 Searle Russell Ashley National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
18917 18917 2009-06-05 1999-05-10 Malcolm Elizabeth National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
18918 18918 2009-06-05 1999-05-10 Sirabella John National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
18919 18919 2009-06-05 1999-05-10 Terrell Mary Jane National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
20128 20128 1970-06-24 1964-01-20 Samuels Joel National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
20904 20904 1976-06-30 1973-01-23 Johnston Thomas Low National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
21060 21060 1986-06-30 1948-06-28 Sims Lillian Adelaide National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
22053 22053 1963-07-01 1962-07-19 Williams Kenneth Ashton National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
22159 22159 1985-07-01 1980-02-05 Schioler Karen Capen National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
22160 22160 1985-07-01 1979-03-05 Shere A. Kenneth National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
25432 25432 1948-08-01 1948-06-30 Macoun Patricia Aylish National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
26511 26511 1999-08-12 1999-05-10 Hamilton Eric National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
26710 26710 1983-08-15 1980-08-08 McCutcheon Ian National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
29197 29197 1968-09-05 1957-07-16 Cosman Joseph William National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
29944 29944 1980-09-16 1976-02-04 Bragg James A. National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
30643 30643 1962-09-28 1961-06-13 Chandler Henry Bramwell National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
30840 30840 1961-09-30 1956-06-06 Stewart Lydall Stanley National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
30929 30929 1979-09-30 1978-02-02 Finesmith Jared National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
31822 31822 1974-10-01 1970-08-12 Boundy John Edward Milton National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
31880 31880 1984-10-01 1981-08-04 Ladouceur Ronald J. National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
34832 34832 1968-11-01 1967-08-01 Courtice Andrew Paul Kenny National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
36192 36192 1961-11-22 1958-03-04 Monteith Robert National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010

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