FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1,400 rows where Registration_Number = 2165 sorted by URL
This data as json, CSV (advanced)
Foreign_Principal_Name >30
- - 901
- Republic of Angola 113
- Embassy of the Republic of Korea 34
- Government of the Republic of Angola 28
- The Federal Democratic Republic of Ethiopia 28
- Government of the Republic of Angola, Embassy 11
- Government of the Republic of Sudan, Embassy 10
- Embassy of the People's Republic of China 8
- Government of the Republic of Cameroon 7
- Corporate Fund Kazakhstan 4
- Government of the Republic of Korea 4
- Republic of Croatia 4
- Embassy of the Republic of Peru 3
- Palestinian Authority 3
- Republic of Benin 3
- CENTRAL AMERICAN SUGAR COUNCIL 2
- DEPARTMENT OF TRADE & INDUSTRY, REPUBLIC OF THE PHILIPPINES 2
- Embassy of Mexico 2
- Embassy of the Bolivarian Republic of Venezuela 2
- Embassy of the Republic of Chad 2
- Government of Georgia 2
- Government of Kosova 2
- Government of the Sultanate of Oman 2
- HENRI DAMASE OMGBA 2
- High Negotiations Committee of the Syrian Opposition (HNC) 2
- Kurdistan Regional Government 2
- Ministry of Commerce and Industries, Republic of Panama 2
- POR LARRANAGA, FABRICA DE TABACOS, S.A. 2
- Sociedade Nacional de Combustiveis de Angola (SONANGOL) /Republic of Angola 2
- AI-Hamar Trading Group 1
- …
Foreign_Principal_Country >30
- - 901
- ANGOLA 156
- KOREA SOUTH 40
- ETHIOPIA 28
- CHINA 12
- SUDAN 10
- CAMEROON 9
- GUATEMALA 6
- SAUDI ARABIA 6
- CROATIA 5
- PHILIPPINES 5
- BENIN 4
- GEORGIA 4
- KAZAKHSTAN 4
- PERU 4
- SPAIN 4
- UNITED ARAB EMIRATES 4
- VENEZUELA 4
- COSTA RICA 3
- IRAQ 3
- ITALY 3
- JAPAN 3
- KOSOVA 3
- MEXICO 3
- NIGERIA 3
- OMAN 3
- PALESTINE 3
- PANAMA 3
- ALBANIA 2
- CANADA 2
- …
Registrant_Name 8
- Squire Patton Boggs, LLP 499
- Patton Boggs, LLP 294
- PATTON BOGGS, L.L.P. 273
- Patton Boggs, L.L.P. 225
- PATTON BOGGS 5
- squire 2
- 2165 1
- PATTON BOGGS, LLP 1
Document_Type 7
- Short-Form 556
- Amendment 230
- Informational Materials 215
- Exhibit AB 184
- Supplemental Statement 109
- Dissemination Report 5
- Registration Statement 1
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL ▼ |
---|---|---|---|---|---|---|---|---|---|
45857 | 45857 | 1979-05-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | DAVID E. DUNN | Available-FARA-Public-Office | ||
45906 | 45906 | 1980-05-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | KATHERINE R. BOYCE | Available-FARA-Public-Office | ||
49739 | 49739 | 2003-05-06 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Brand,Joseph L. | Available-FARA-Public-Office | ||
49740 | 49740 | 2003-05-06 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Glassco,Timothy A. | Available-FARA-Public-Office | ||
49741 | 49741 | 2003-05-06 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Martinez-Fernandez,Mayra L. | Available-FARA-Public-Office | ||
49742 | 49742 | 2003-05-06 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Peters,Stephanie J. | Available-FARA-Public-Office | ||
49743 | 49743 | 2003-05-06 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Peters,Stephanie J. | Available-FARA-Public-Office | ||
49744 | 49744 | 2003-05-06 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Thompson,Heather D. | Available-FARA-Public-Office | ||
49952 | 49952 | 1993-05-07 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | PENELOPE S. FARTHING | Available-FARA-Public-Office | ||
49980 | 49980 | 2003-05-07 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | O'Donnell, Thomas P. | Available-FARA-Public-Office | ||
50797 | 50797 | 2005-05-10 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Newberry, Edward J. | Available-FARA-Public-Office | ||
50798 | 50798 | 2005-05-10 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Newberry, Edward J. | Available-FARA-Public-Office | ||
50799 | 50799 | 2005-05-10 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Norman, W. Caffey | Available-FARA-Public-Office | ||
50800 | 50800 | 2005-05-10 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Samolis, Frank R. | Available-FARA-Public-Office | ||
58448 | 58448 | 1980-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | ELLIOT H. COLE | Available-FARA-Public-Office | ||
58449 | 58449 | 1980-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | WILLIAM J. COLLEY | Available-FARA-Public-Office | ||
59068 | 59068 | 1985-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | DANIEL F. WAKE | Available-FARA-Public-Office | ||
59069 | 59069 | 1985-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | DEBORAH F. NEIPRIS | Available-FARA-Public-Office | ||
59070 | 59070 | 1985-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | FRANK J. DONATELLI | Available-FARA-Public-Office | ||
59071 | 59071 | 1985-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | ROBERT J. PORTMAN | Available-FARA-Public-Office | ||
59072 | 59072 | 1985-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | SHAOUL ASLAN | Available-FARA-Public-Office | ||
59233 | 59233 | 1986-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | RONALD S. LIEBMAN | Available-FARA-Public-Office | ||
59427 | 59427 | 1987-06-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | THEODORE G. KRONMILLER | Available-FARA-Public-Office | ||
62593 | 62593 | 2001-06-04 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Addison ,Daniel R. | Available-FARA-Public-Office | ||
62594 | 62594 | 2001-06-04 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Boggs,Thomas Hale , Jr. | Available-FARA-Public-Office | ||
62595 | 62595 | 2001-06-04 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Laughlin,Gregory H. | Available-FARA-Public-Office | ||
62596 | 62596 | 2001-06-04 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Novey,Rogelio | Available-FARA-Public-Office | ||
62831 | 62831 | 2003-06-05 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Boggs,Thomas Hale , Jr. | Available-FARA-Public-Office | ||
62832 | 62832 | 2003-06-05 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Kapla,Robert S. | Available-FARA-Public-Office | ||
62833 | 62833 | 2003-06-05 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Nolan,Caroline S. | Available-FARA-Public-Office | ||
64987 | 64987 | 1999-06-14 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Martin ,Middleton A. | Available-FARA-Public-Office | ||
65204 | 65204 | 2005-06-15 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Power, Michael G. | Available-FARA-Public-Office | ||
65400 | 65400 | 2000-06-16 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Trapasso ,Joseph S. | Available-FARA-Public-Office | ||
65415 | 65415 | 2003-06-16 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Driver,Michael J. | Available-FARA-Public-Office | ||
65618 | 65618 | 1993-06-17 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | PAUL A.J. WILSON | Available-FARA-Public-Office | ||
66411 | 66411 | 2004-06-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Buck,Daniel J. | Available-FARA-Public-Office | ||
66415 | 66415 | 2005-06-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Buck, Daniel J. | Available-FARA-Public-Office | ||
66645 | 66645 | 1998-06-22 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | LANNY J. DAVIS | Available-FARA-Public-Office | ||
66925 | 66925 | 2003-06-23 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | O'Connor, Eileen M. | Available-FARA-Public-Office | ||
67549 | 67549 | 1985-06-26 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | RICHARD M. STOLBACH | Available-FARA-Public-Office | ||
67945 | 67945 | 2005-06-27 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Christie, Ronald I. | Available-FARA-Public-Office | ||
71374 | 71374 | 1985-07-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | IRA A. FISHMAN | Available-FARA-Public-Office | ||
72071 | 72071 | 1990-07-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | ETHAN S. BURGER | Available-FARA-Public-Office | ||
72072 | 72072 | 1990-07-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | GEOFFREY G. DAVIS | Available-FARA-Public-Office | ||
72073 | 72073 | 1990-07-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JOHN H. RUSSELL | Available-FARA-Public-Office | ||
72074 | 72074 | 1990-07-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | PETER D. ROBERTSON | Available-FARA-Public-Office | ||
72075 | 72075 | 1990-07-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | ROBERT BRUCE PHILLIPS | Available-FARA-Public-Office | ||
72076 | 72076 | 1990-07-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | ROSE E. KRIGER | Available-FARA-Public-Office | ||
74594 | 74594 | 1993-07-08 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | CAROLINA L. MEDEROS | Available-FARA-Public-Office | ||
74595 | 74595 | 1993-07-08 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | ELLIOTT P. LAWS | Available-FARA-Public-Office | ||
74596 | 74596 | 1993-07-08 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | LANNY J. DAVIS | Available-FARA-Public-Office | ||
74597 | 74597 | 1993-07-08 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | PETER D. ROBERTSON | Available-FARA-Public-Office | ||
74598 | 74598 | 1993-07-08 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | ROBERT C. JONES | Available-FARA-Public-Office | ||
74640 | 74640 | 1998-07-08 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | FRANK R. SAMOLIS | Available-FARA-Public-Office | ||
74641 | 74641 | 1998-07-08 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JEFFREY T. SMITH | Available-FARA-Public-Office | ||
75813 | 75813 | 1998-07-13 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JOHN C. GARRETT | Available-FARA-Public-Office | ||
76048 | 76048 | 1999-07-14 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Brand ,Joseph L. | Available-FARA-Public-Office | ||
76265 | 76265 | 1998-07-15 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | DEAN M. DILLEY | Available-FARA-Public-Office | ||
77348 | 77348 | 2005-07-20 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Horn, Robert | Available-FARA-Public-Office | ||
77602 | 77602 | 1999-07-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Brown,Michael A. | Available-FARA-Public-Office | ||
77613 | 77613 | 2005-07-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Boggs, Thomas Hale , Jr. | Available-FARA-Public-Office | ||
77614 | 77614 | 2005-07-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Chorba, Timothy A. | Available-FARA-Public-Office | ||
77615 | 77615 | 2005-07-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Cowan, Mark D. | Available-FARA-Public-Office | ||
77616 | 77616 | 2005-07-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Delaney, Timothy | Available-FARA-Public-Office | ||
77617 | 77617 | 2005-07-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Horn, Robert J. | Available-FARA-Public-Office | ||
77618 | 77618 | 2005-07-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Kapla, Robert S. | Available-FARA-Public-Office | ||
77619 | 77619 | 2005-07-21 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Stillitano, Tom | Available-FARA-Public-Office | ||
78125 | 78125 | 1999-07-23 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | O'Donnell ,Thomas P. | Available-FARA-Public-Office | ||
78126 | 78126 | 1999-07-23 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Boggs,Thomas Hale , Jr. | Available-FARA-Public-Office | ||
78127 | 78127 | 1999-07-23 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Brand ,Joseph L. | Available-FARA-Public-Office | ||
78128 | 78128 | 1999-07-23 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Eizenstat,Jay L. | Available-FARA-Public-Office | ||
78129 | 78129 | 1999-07-23 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Lee III,Lansing B. | Available-FARA-Public-Office | ||
78130 | 78130 | 1999-07-23 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | Samolis ,Frank R. | Available-FARA-Public-Office | ||
78333 | 78333 | 1998-07-24 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | LANNY J. DAVIS | Available-FARA-Public-Office | ||
79125 | 79125 | 1995-07-27 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JOHN J. DESCHAUER JR. | Available-FARA-Public-Office | ||
80792 | 80792 | 1992-07-31 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | CRAIG S. KRAMER | Available-FARA-Public-Office | ||
81949 | 81949 | 1976-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | NANCY W. NEWKIRK | Available-FARA-Public-Office | ||
81994 | 81994 | 1977-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JAMES G. O'HARA | Available-FARA-Public-Office | ||
81995 | 81995 | 1977-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JOHN L. OBERDORFER | Available-FARA-Public-Office | ||
82141 | 82141 | 1980-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | STUART M. PAPE | Available-FARA-Public-Office | ||
82204 | 82204 | 1981-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | BART S. FISHER | Available-FARA-Public-Office | ||
82205 | 82205 | 1981-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | GARY L. STANLEY | Available-FARA-Public-Office | ||
82206 | 82206 | 1981-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | HARVEY J. BAKER | Available-FARA-Public-Office | ||
82207 | 82207 | 1981-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JAMES B. CHRISTIAN | Available-FARA-Public-Office | ||
82208 | 82208 | 1981-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | STEVEN M. SCHNEEBAUM | Available-FARA-Public-Office | ||
82209 | 82209 | 1981-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | THOMAS R. GRAHAM | Available-FARA-Public-Office | ||
82428 | 82428 | 1984-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JEFFREY L. TURNER | Available-FARA-Public-Office | ||
82920 | 82920 | 1988-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | ALLEN HOLT GWYN | Available-FARA-Public-Office | ||
82921 | 82921 | 1988-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | FRANK R. SAMOLIS | Available-FARA-Public-Office | ||
82922 | 82922 | 1988-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JOE ROBERT REEDER | Available-FARA-Public-Office | ||
82923 | 82923 | 1988-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | MICHAEL D. ESCH | Available-FARA-Public-Office | ||
82924 | 82924 | 1988-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | RICHARD D. CONNER | Available-FARA-Public-Office | ||
82925 | 82925 | 1988-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | RICHARD EDWARD MESSICK | Available-FARA-Public-Office | ||
82926 | 82926 | 1988-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | SCOTT N. STONE | Available-FARA-Public-Office | ||
82927 | 82927 | 1988-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | STEPHEN H. LACHTER | Available-FARA-Public-Office | ||
83065 | 83065 | 1989-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | CHARLES E. TALISMAN | Available-FARA-Public-Office | ||
83066 | 83066 | 1989-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | DANIEL ADAM KRACOV | Available-FARA-Public-Office | ||
83067 | 83067 | 1989-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | DANIEL MARCOS FLORES | Available-FARA-Public-Office | ||
83068 | 83068 | 1989-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | JAMES R. STUART, III | Available-FARA-Public-Office | ||
83069 | 83069 | 1989-08-01 | PATTON BOGGS, L.L.P. | Squire Patton Boggs, LLP 2165 | Short-Form | LAURA HUME HILLS | 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]) );