FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

214 rows where Registrant_Name = "O'CONNOR & HANNAN, LLP"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 1

  • O'CONNOR & HANNAN, LLP · 214 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
814 814 1984-01-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19840101-D0D2UW03.pdf
815 815 1984-01-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   GOVERNMENT OF CYPRUS CYPRUS https://efile.fara.gov/docs/2972-Exhibit-AB-19840101-D0CX1803.pdf
2248 2248 1993-01-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Dissemination Report       https://efile.fara.gov/docs/2972-Dissemination-Report-19930101-D0D4BD03.pdf
11014 11014 1981-02-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form MARTHA PRIDDY PATTERSON     Available-FARA-Public-Office
11440 11440 1986-02-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19860201-D0D0B403.pdf
11441 11441 1986-02-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   KAWASAKI KISEN KAISHA, LTD. JAPAN https://efile.fara.gov/docs/2972-Exhibit-AB-19860201-D0D0BO03.pdf
12832 12832 1993-02-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Dissemination Report       https://efile.fara.gov/docs/2972-Dissemination-Report-19930201-D0D4CW03.pdf
14529 14529 1986-02-06 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form PATRICK E. O'DONNELL     Available-FARA-Public-Office
14530 14530 1986-02-06 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form GEORGE J. MANNINA, JR.     Available-FARA-Public-Office
21115 21115 1980-03-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19800301-D0CXEI03.pdf
21116 21116 1980-03-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19800301-D0CXEN03.pdf
21180 21180 1981-03-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19810301-D0CYQH03.pdf
21530 21530 1985-03-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form DOUGLAS E. LAVIN     Available-FARA-Public-Office
21852 21852 1987-03-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19870301-D0D0K603.pdf
21853 21853 1987-03-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   GOVERNMENT OF THE NETHERLANDS/ANTILLES NETHERLANDS ANTILLES https://efile.fara.gov/docs/2972-Exhibit-AB-19870301-D0D0LE03.pdf
21854 21854 1987-03-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form TIMOTHY M. HAAKE     Available-FARA-Public-Office
22577 22577 1991-03-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Dissemination Report       https://efile.fara.gov/docs/2972-Dissemination-Report-19910301-D0D0XE03.pdf
27441 27441 1987-03-13 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form PATRICK E. O'DONNELL     Available-FARA-Public-Office
27442 27442 1987-03-13 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JAMES W. SYMINGTON     Available-FARA-Public-Office
27443 27443 1987-03-13 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JOSEPH H. BLATCHFORD     Available-FARA-Public-Office
27444 27444 1987-03-13 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form ROBERT SMITH     Available-FARA-Public-Office
29144 29144 1987-03-19 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form GEORGE J. MANNINA, JR.     Available-FARA-Public-Office
29145 29145 1987-03-19 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form MICHAEL COLOPY     Available-FARA-Public-Office
29905 29905 1994-03-22 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19940322-DQQI6N03.pdf
29906 29906 1994-03-22 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   CAMARA NACIONAL DE LA INDUSTRIA PESQUERA (CANAINPES) MEXICO https://efile.fara.gov/docs/2972-Exhibit-AB-19940322-DQQIRA03.pdf
29907 29907 1994-03-22 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form GEORGE J. MANNINA, JR.     Available-FARA-Public-Office
34029 34029 1979-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19790401-D0D3C703.pdf
34089 34089 1980-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19800401-D0D3B303.pdf
34159 34159 1981-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19810401-D0D33G03.pdf
34233 34233 1982-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19820401-D0D37503.pdf
34299 34299 1983-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19830401-D0D2ZU03.pdf
34300 34300 1983-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19830401-D0D30N03.pdf
34301 34301 1983-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19830401-D0D31H03.pdf
34302 34302 1983-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   GOVERNMENT OF JAMAICA JAMAICA https://efile.fara.gov/docs/2972-Exhibit-AB-19830401-D0CX4N03.pdf
34303 34303 1983-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   GOVERNMENT OF SUDAN SUDAN https://efile.fara.gov/docs/2972-Exhibit-AB-19830401-D0CX5E03.pdf
34304 34304 1983-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   JAMAICAN BROADCASTING CORPORATION JAMAICA https://efile.fara.gov/docs/2972-Exhibit-AB-19830401-D0CX6403.pdf
34305 34305 1983-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form THOMAS B. EVANS, JR.     Available-FARA-Public-Office
34306 34306 1983-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19830401-D0CX3I03.pdf
34389 34389 1984-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19840401-D0D32903.pdf
34390 34390 1984-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   BALFOUR BEATTY, LTD. GREAT BRITAIN https://efile.fara.gov/docs/2972-Exhibit-AB-19840401-D0CX6K03.pdf
34391 34391 1984-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19840401-D0D2Q103.pdf
34482 34482 1985-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19850401-D0D03F03.pdf
34565 34565 1986-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19860401-D0D4WJ03.pdf
34707 34707 1987-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19870401-D0D0RA03.pdf
34708 34708 1987-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   ASOCIACION NACIONAL DE LA EMPRESA PRIVADA DE EL SALVADOR EL SALVADOR https://efile.fara.gov/docs/2972-Exhibit-AB-19870401-D0D0SJ03.pdf
34709 34709 1987-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JOSEPH H. BLATCHFORD     Available-FARA-Public-Office
34710 34710 1987-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19870401-D0D28H03.pdf
34841 34841 1988-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19880401-D0D1T303.pdf
35001 35001 1989-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19890401-D0D1C003.pdf
35002 35002 1989-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   ALFREDO CRISTIANI EL SALVADOR https://efile.fara.gov/docs/2972-Exhibit-AB-19890401-D0D1CO03.pdf
35003 35003 1989-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19890401-D0D16O03.pdf
35168 35168 1990-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19900401-D0D1DR03.pdf
35372 35372 1991-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form MARY SCOTT GUEST     Available-FARA-Public-Office
35373 35373 1991-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19910401-D0D53K03.pdf
35815 35815 1992-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19920401-D0CY6H03.pdf
36398 36398 1993-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19930401-D0D4IU03.pdf
36844 36844 1994-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19940401-DQQHP803.pdf
36845 36845 1994-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   STANDARD CHARTERED PLC. GREAT BRITAIN https://efile.fara.gov/docs/2972-Exhibit-AB-19940401-DQQHRW03.pdf
36846 36846 1994-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form THOMAS H. QUINN     Available-FARA-Public-Office
36847 36847 1994-04-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form TIMOTHY W. JENKINS     Available-FARA-Public-Office
42631 42631 1994-04-25 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19940425-DQQGO103.pdf
42638 42638 1995-04-25 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Supplemental Statement       https://efile.fara.gov/docs/2972-Supplemental-Statement-19950425-DQQEUC03.pdf
43220 43220 1989-04-27 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form PATRICK E. O'DONNELL     Available-FARA-Public-Office
43221 43221 1989-04-27 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JAMES W. SYMINGTON     Available-FARA-Public-Office
43222 43222 1989-04-27 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JOSEPH H. BLATCHFORD     Available-FARA-Public-Office
43223 43223 1989-04-27 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form MICHAEL J. FERRELL     Available-FARA-Public-Office
47094 47094 1991-05-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Dissemination Report       https://efile.fara.gov/docs/2972-Dissemination-Report-19910501-D0D0TH03.pdf
47436 47436 1992-05-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   CITY OF AMERICA FOUNDATION, INC. JAPAN https://efile.fara.gov/docs/2972-Exhibit-AB-19920501-D0CYA303.pdf
47437 47437 1992-05-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JOHN J. MCDERMOTT     Available-FARA-Public-Office
47967 47967 1993-05-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Dissemination Report       https://efile.fara.gov/docs/2972-Dissemination-Report-19930501-D0D4HH03.pdf
53876 53876 1995-05-22 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   PROEXPORT COLOMBIA https://efile.fara.gov/docs/2972-Exhibit-AB-19950522-DQQGZS93.pdf
53877 53877 1995-05-22 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JOSEPH H. BLATCHFORD     Available-FARA-Public-Office
54359 54359 1994-05-24 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19940524-DQQGYF03.pdf
58686 58686 1983-06-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form J. TIMOTHY O'NEILL     Available-FARA-Public-Office
59273 59273 1987-06-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19870601-D0D26C03.pdf
59274 59274 1987-06-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   CHINA EXTERNAL TRADE DEVELOPMENT COUNCIL TAIWAN https://efile.fara.gov/docs/2972-Exhibit-AB-19870601-D0D27303.pdf
62308 62308 1983-06-03 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form DONALD S. ARBOUR     Available-FARA-Public-Office
65363 65363 1987-06-16 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form MICHAEL COLOPY     Available-FARA-Public-Office
65364 65364 1987-06-16 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form THOMAS H. QUINN     Available-FARA-Public-Office
70947 70947 1980-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19800701-D0D36D03.pdf
70948 70948 1980-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   TOYOTA MOTOR SALES U.S.A., INC. JAPAN https://efile.fara.gov/docs/2972-Exhibit-AB-19800701-D0CX9W03.pdf
70949 70949 1980-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form PATRICK O'DONNELL     Available-FARA-Public-Office
70950 70950 1980-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form EDWARD W. BROOKE     Available-FARA-Public-Office
70951 70951 1980-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JOSEPH E. PATTISON     Available-FARA-Public-Office
71020 71020 1981-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19810701-D0CXBT03.pdf
71021 71021 1981-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19810701-D0D38D03.pdf
71022 71022 1981-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19810701-D0D38L03.pdf
71023 71023 1981-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   UNITED KINGDOM MUTUAL STEAM SHIP ASSOCIATION (BERMUDA) LTD. BERMUDA https://efile.fara.gov/docs/2972-Exhibit-AB-19810701-D0CXCS03.pdf
71024 71024 1981-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JOHN FORD EVANS, JR.     Available-FARA-Public-Office
71304 71304 1985-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   GOVERNMENT OF ECUADOR ECUADOR https://efile.fara.gov/docs/2972-Exhibit-AB-19850701-D0D0IY03.pdf
72863 72863 1993-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19930701-D0CYJ903.pdf
72864 72864 1993-07-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   GOVERNMENT OF THE PHILLIPINES PHILIPPINES https://efile.fara.gov/docs/2972-Exhibit-AB-19930701-D0CYHL03.pdf
74070 74070 1980-07-06 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form CHRISTINA W. FLEPS     Available-FARA-Public-Office
74071 74071 1980-07-06 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form JOHN J. FLYNN     Available-FARA-Public-Office
74558 74558 1980-07-08 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form THOMAS V. VAKERICS     Available-FARA-Public-Office
76225 76225 1994-07-15 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Amendment       https://efile.fara.gov/docs/2972-Amendment-19940715-DQQG0803.pdf
76226 76226 1994-07-15 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   INSTITUTE OF INTERNATIONAL BANKERS INTERNATIONAL https://efile.fara.gov/docs/2972-Exhibit-AB-19940715-DQQG5F03.pdf
76227 76227 1994-07-15 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form J. TIMOTHY O'NEILL     Available-FARA-Public-Office
76602 76602 1981-07-17 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   WEST O F ENGLAND SHIPOWNERS' MUTUAL INSURANCE ASSOCIATION, GREAT BRITAIN https://efile.fara.gov/docs/2972-Exhibit-AB-19810717-D0CXCC03.pdf
79110 79110 1993-07-27 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Short-Form J. TIMOTHY O'NEILL     Available-FARA-Public-Office

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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