FARA_All_ShortForms

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)

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

State

Registration_Number

  • 437 · 47 ✖

Registrant_Name

City

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
3517 3517 1985-01-14 1969-08-07 Gee Albert Eric 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
4611 4611 1957-01-31 1952-12-23 Duerkop John Henry 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5309 5309 1954-02-01 1948-06-29 Brown Grace Marion 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5333 5333 1966-02-01 1956-01-16 Ward Ronald Claude 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5350 5350 1970-02-01 1964-01-20 Duerkop John 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5598 5598 1967-02-02 1964-01-20 Moodie James Robert 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
5599 5599 1967-02-02 1963-07-31 Chatwin Leonard William 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
6845 6845 1973-02-20 1947-02-13 Savage Lilias Margaret 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
6846 6846 1973-02-20 1944-04-21 Carter Jane Margaret 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
6847 6847 1973-02-20 1944-04-21 Scellen Janet C.S. 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
6848 6848 1973-02-20 1955-09-21 Ellis Ralph Colin 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
7359 7359 1955-02-28 1953-12-14 Johnston Thomas Low 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
9730 9730 1970-03-20 1969-05-13 Anderson Herbert R. 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
10758 10758 1971-03-31 1967-08-01 Shere Alcon Kenneth 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
10817 10817 1978-03-31 1975-03-14 Ladouceur Ronald J. 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
10821 10821 1979-03-31 1977-02-22 Anderson Herbert 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
13276 13276 1980-04-26 1974-09-30 Moodie James Robert 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
13523 13523 1949-04-30 1947-02-13 Scythes Edwin Woolatt 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
13724 13724 1990-04-30 1988-06-14 Cournoyer Rachelle J. 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
14317 14317 1957-05-01 1955-06-21 Smith William Dean 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
14340 14340 1971-05-01 1968-02-01 Belleville Denis 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
14355 14355 1974-05-01 1971-08-10 Eliuk Douglas Selvester 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
15564 15564 1979-05-18 1979-03-05 Litwack William 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
16454 16454 1963-05-31 1963-01-09 Vale Robert Kenneth 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
17198 17198 1969-06-01 1966-02-01 Williams Kenneth Ashton 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
17216 17216 1974-06-01 1971-08-10 Searle Russell Ashley 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
17684 17684 2009-06-05 1999-05-10 Malcolm Elizabeth 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
17685 17685 2009-06-05 1999-05-10 Sirabella John 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
17686 17686 2009-06-05 1999-05-10 Terrell Mary Jane 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
18839 18839 1970-06-24 1964-01-20 Samuels Joel 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
19600 19600 1976-06-30 1973-01-23 Johnston Thomas Low 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
19756 19756 1986-06-30 1948-06-28 Sims Lillian Adelaide 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
20653 20653 1963-07-01 1962-07-19 Williams Kenneth Ashton 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
20759 20759 1985-07-01 1980-02-05 Schioler Karen Capen 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
20760 20760 1985-07-01 1979-03-05 Shere A. Kenneth 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
23824 23824 1948-08-01 1948-06-30 Macoun Patricia Aylish 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
24851 24851 1999-08-12 1999-05-10 Hamilton Eric 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
25037 25037 1983-08-15 1980-08-08 McCutcheon Ian 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
27413 27413 1968-09-05 1957-07-16 Cosman Joseph William 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
28137 28137 1980-09-16 1976-02-04 Bragg James A. 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
28806 28806 1962-09-28 1961-06-13 Chandler Henry Bramwell 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
28999 28999 1961-09-30 1956-06-06 Stewart Lydall Stanley 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
29088 29088 1979-09-30 1978-02-02 Finesmith Jared 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
29917 29917 1974-10-01 1970-08-12 Boundy John Edward Milton 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
29975 29975 1984-10-01 1981-08-04 Ladouceur Ronald J. 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
32774 32774 1968-11-01 1967-08-01 Courtice Andrew Paul Kenny 437 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
34055 34055 1961-11-22 1958-03-04 Monteith Robert 437 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)
);
Powered by Datasette · Query took 346.625ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history