FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
160 rows where Registrant_Name = "NATIONAL FILM BOARD OF CANADA" and Registration_Number = 437 sorted by Date_Stamped
This data as json, CSV (advanced)
Link | rowid | Date_Stamped ▼ | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
10450 | 10450 | 1943-02-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Exhibit AB | NATIONAL FILM BOARD OF CANADA | CANADA | https://efile.fara.gov/docs/437-Exhibit-AB-19430201-CXXZA502.pdf | |
10454 | 10454 | 1947-02-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Exhibit AB | NATIONAL FILM BOARD OF CANADA | CANADA | https://efile.fara.gov/docs/437-Exhibit-AB-19470201-CXZB7Y01.pdf | |
10455 | 10455 | 1947-02-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Registration Statement | Available-FARA-Public-Office | |||
15972 | 15972 | 1947-02-13 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | EDWIN WOOLLATT SCYTHES | Available-FARA-Public-Office | ||
15973 | 15973 | 1947-02-13 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JANE MARGARET CARTER | Available-FARA-Public-Office | ||
15974 | 15974 | 1947-02-13 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JANET C. S. SCELLEN | Available-FARA-Public-Office | ||
15975 | 15975 | 1947-02-13 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | LILIAS MARGARET SAVAGE | Available-FARA-Public-Office | ||
91533 | 91533 | 1947-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19470901-CXXYXH02.pdf | |||
8 | 8 | 1948-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Amendment | https://efile.fara.gov/docs/437-Amendment-19480101-CXXZ6L02.pdf | |||
20388 | 20388 | 1948-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19480301-CXXZ4C02.pdf | |||
68367 | 68367 | 1948-06-29 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | GRACE MARION BROWN | Available-FARA-Public-Office | ||
68368 | 68368 | 1948-06-29 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | LILLIAN ADELAIDE SIMS | Available-FARA-Public-Office | ||
68892 | 68892 | 1948-06-30 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | PATRICIA AYLISH MACOUN | Available-FARA-Public-Office | ||
70408 | 70408 | 1948-07-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Amendment | https://efile.fara.gov/docs/437-Amendment-19480701-CXXYRW02.pdf | |||
91536 | 91536 | 1948-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19480901-CXXYPN02.pdf | |||
11 | 11 | 1949-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Amendment | https://efile.fara.gov/docs/437-Amendment-19490101-CXXYPA02.pdf | |||
20391 | 20391 | 1949-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19490301-CXXYMX02.pdf | |||
91539 | 91539 | 1949-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19490901-CXXYVA02.pdf | |||
20393 | 20393 | 1950-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19500301-CXXYTE02.pdf | |||
91542 | 91542 | 1950-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19500901-CXXY6502.pdf | |||
20400 | 20400 | 1951-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19510301-CXXYC502.pdf | |||
91545 | 91545 | 1951-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19510901-CXXY9R02.pdf | |||
20405 | 20405 | 1952-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19520301-CXXY8A02.pdf | |||
91551 | 91551 | 1952-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19520901-CXXYLG02.pdf | |||
123632 | 123632 | 1952-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JOHN HENRY DUERKOP | Available-FARA-Public-Office | ||
20409 | 20409 | 1953-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19530301-CXXYJ602.pdf | |||
91554 | 91554 | 1953-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19530901-CXXYH702.pdf | |||
123640 | 123640 | 1953-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | THOMAS LOW JOHNSTON | Available-FARA-Public-Office | ||
20413 | 20413 | 1954-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19540301-CXXYFE02.pdf | |||
91559 | 91559 | 1954-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19540901-CXXYDU02.pdf | |||
20420 | 20420 | 1955-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19550301-CXXPH402.pdf | |||
91563 | 91563 | 1955-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | RALPH COLIN ELLIS | Available-FARA-Public-Office | ||
91564 | 91564 | 1955-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19550901-CXXY4G02.pdf | |||
58 | 58 | 1956-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | RONALD CLAUDE WARD | Available-FARA-Public-Office | ||
20425 | 20425 | 1956-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19560301-CXXY2D02.pdf | |||
57185 | 57185 | 1956-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | LYDALL STANLEY STEWART | Available-FARA-Public-Office | ||
91567 | 91567 | 1956-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19560901-CXXY0H02.pdf | |||
20431 | 20431 | 1957-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19570301-CXXPLG02.pdf | |||
91574 | 91574 | 1957-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19570901-CXXPJP02.pdf | |||
20436 | 20436 | 1958-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | ROBERT MONTEITH | Available-FARA-Public-Office | ||
20437 | 20437 | 1958-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19580301-CXXP8002.pdf | |||
91581 | 91581 | 1958-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19580901-CXXP6902.pdf | |||
20442 | 20442 | 1959-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19590301-CXXP4J02.pdf | |||
91587 | 91587 | 1959-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19590901-CXXP2W02.pdf | |||
20450 | 20450 | 1960-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19600301-CXXP1402.pdf | |||
91593 | 91593 | 1960-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19600901-CXXOZJ02.pdf | |||
20461 | 20461 | 1961-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19610301-CXXOXE02.pdf | |||
57313 | 57313 | 1961-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | HENRY BRAMWELL CHANDLER | Available-FARA-Public-Office | ||
91603 | 91603 | 1961-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19610901-CXXOVQ02.pdf | |||
20474 | 20474 | 1962-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19620301-CXXOTS02.pdf | |||
70482 | 70482 | 1962-07-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | KENNETH ASHTON WILLIAMS | Available-FARA-Public-Office | ||
91612 | 91612 | 1962-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19620901-CXXOR802.pdf | |||
86 | 86 | 1963-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | KENNETH ASHTON WILLIAMS | Available-FARA-Public-Office | ||
20485 | 20485 | 1963-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19630301-CXXPF602.pdf | |||
70488 | 70488 | 1963-07-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | LEONARD WILLIAM CHATWIN | Available-FARA-Public-Office | ||
91622 | 91622 | 1963-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19630901-CXXPC702.pdf | |||
95 | 95 | 1964-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JAMES ROBERT MOODIE | Available-FARA-Public-Office | ||
96 | 96 | 1964-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JOEL SAMUELS | Available-FARA-Public-Office | ||
97 | 97 | 1964-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JOHN DUERKOP | Available-FARA-Public-Office | ||
20503 | 20503 | 1964-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19640301-CXXP9U02.pdf | |||
57416 | 57416 | 1964-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Amendment | https://efile.fara.gov/docs/437-Amendment-19640601-CXXPBI02.pdf | |||
57417 | 57417 | 1964-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Amendment | https://efile.fara.gov/docs/437-Amendment-19640601-CXXPBV02.pdf | |||
123898 | 123898 | 1964-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19641201-CXXOO802.pdf | |||
57454 | 57454 | 1965-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19650601-CXXOLY02.pdf | |||
123937 | 123937 | 1965-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19651201-CXZ82K01.pdf | |||
10556 | 10556 | 1966-02-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | KENNETH ASHTON WILLIAMS | Available-FARA-Public-Office | ||
57501 | 57501 | 1966-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19660601-CXZ80301.pdf | |||
81648 | 81648 | 1966-08-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Exhibit AB | NATIONAL FILM BOARD OF CANADA | CANADA | https://efile.fara.gov/docs/437-Exhibit-AB-19660801-CXZ7YO01.pdf | |
123974 | 123974 | 1966-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19661201-CXZB5K01.pdf | |||
57544 | 57544 | 1967-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19670601-CXXZRE02.pdf | |||
81662 | 81662 | 1967-08-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | ALCON KENNETH SHERE | Available-FARA-Public-Office | ||
81663 | 81663 | 1967-08-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | ANDREW PAUL KENNY COURTICE | Available-FARA-Public-Office | ||
124015 | 124015 | 1967-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19671201-CXZ7TG01.pdf | |||
10587 | 10587 | 1968-02-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | DENIS BELLEVILLE | Available-FARA-Public-Office | ||
10588 | 10588 | 1968-02-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JOSEPH WILLIAM COSMAN | Available-FARA-Public-Office | ||
57588 | 57588 | 1968-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19680601-CXZ7RX01.pdf | |||
124067 | 124067 | 1968-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19681201-CXZ7PY01.pdf | |||
45516 | 45516 | 1969-05-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | HERBERT R. ANDERSON | Available-FARA-Public-Office | ||
57636 | 57636 | 1969-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19690601-CXZ7MU01.pdf | |||
81689 | 81689 | 1969-08-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | ALBERT ERIC GEE | Available-FARA-Public-Office | ||
124111 | 124111 | 1969-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19691201-CXZ7JT01.pdf | |||
10610 | 10610 | 1970-02-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | THOMAS LOW JOHNSTON | Available-FARA-Public-Office | ||
57692 | 57692 | 1970-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19700601-CXZ7FX01.pdf | |||
81710 | 81710 | 1970-08-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JOHN EDWARD MILTON BOUNDY | Available-FARA-Public-Office | ||
124166 | 124166 | 1970-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19701201-CXZ7VX01.pdf | |||
57751 | 57751 | 1971-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19710601-CXXN9302.pdf | |||
86697 | 86697 | 1971-08-10 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | DOUGLAS SELVESTER ELIUK | Available-FARA-Public-Office | ||
86698 | 86698 | 1971-08-10 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | RUSSELL ASHLEY SEARLE | Available-FARA-Public-Office | ||
124213 | 124213 | 1971-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19711201-CXXNFM02.pdf | |||
57806 | 57806 | 1972-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19720601-CXZB2Y01.pdf | |||
124277 | 124277 | 1972-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19721201-CXXOJ402.pdf | |||
244 | 244 | 1973-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | THOMAS LOW JOHNSTON | Available-FARA-Public-Office | ||
57867 | 57867 | 1973-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19730601-CXXNCW02.pdf | |||
81813 | 81813 | 1973-08-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Exhibit AB | NATIONAL FILM BOARD OF CANADA | CANADA | https://efile.fara.gov/docs/437-Exhibit-AB-19730801-CXXNCE02.pdf | |
91855 | 91855 | 1973-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Amendment | https://efile.fara.gov/docs/437-Amendment-19730901-CXP1OU03.pdf | |||
124346 | 124346 | 1973-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19731201-CXP1LE03.pdf | |||
57947 | 57947 | 1974-06-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19740601-DBKVAA03.pdf | |||
91890 | 91890 | 1974-09-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | JAMES ROBERT MOODIE | Available-FARA-Public-Office | ||
124410 | 124410 | 1974-12-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Supplemental Statement | https://efile.fara.gov/docs/437-Supplemental-Statement-19741201-CXP1HG03.pdf | |||
20842 | 20842 | 1975-03-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | RONALD J. LADOUCEUR | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );