FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
95 rows where Foreign_Principal = "Embassy of Japan"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Foreign_Principal_Termination_Date (date)
Registrant_Name >30
- North American Precis Syndicate 3
- Cladouhos & Brashares 2
- Evans III, Walter H. 2
- Hill and Knowlton Strategies, LLC 2
- Hogan Lovells US LLP 2
- Parvin, C. Landon 2
- Smith, Alan Dexter 2
- Advocacy Group 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Alignment Government Strategies 1
- Anderson, Ervin Oscar 1
- Andrews, Marjorie Key 1
- Arter, Hadden & Hemmendinger 1
- Ballard Partners 1
- Beacon Policy Advisors LLC 1
- Bob, Daniel 1
- Brown/Dowling, Ltd. 1
- Brunner, Toby Emanuel Godfrey 1
- Butterfield Carter and Associates 1
- CGCN Group 1
- Charles von Loewenfeldt, Inc. 1
- Chinworth, Michael Wesley 1
- Clarke Judge Consultants 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Cogent Strategies LLC 1
- Colby, Baily & Associates 1
- Comeau & Company LLC 1
- Copel, Rita Bernice 1
- Culbertson, Pendleton & Pendleton 1
- DYR Public Affairs, Inc. 1
- …
City 3
- - 65
- Washington 29
- Washington, 1
Foreign_Principal 1
- Embassy of Japan · 95 ✖
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
160 | 160 | Embassy of Japan | 2018-02-10 | JAPAN | Forbes Tate Partners LLC 6522 | 2018-02-10 | Forbes Tate Partners LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
161 | 161 | Embassy of Japan | 2011-03-02 | JAPAN | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
162 | 162 | Embassy of Japan | 2019-04-09 | JAPAN | Beacon Policy Advisors LLC 6658 | 2019-04-09 | Beacon Policy Advisors LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
163 | 163 | Embassy of Japan | 2020-04-10 | JAPAN | Patrick,Griffin 6815 | 2020-04-10 | Patrick,Griffin | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
164 | 164 | Embassy of Japan | 2020-04-10 | JAPAN | Tiber Creek Group, Inc. 6816 | 2020-04-10 | Tiber Creek Group, Inc. | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
165 | 165 | Embassy of Japan | 2023-04-14 | JAPAN | Ballard Partners 7070 | 2022-01-13 | Ballard Partners | 2520 Massachusetts Ave, NW | Washington | DC | 20008 | ||
166 | 166 | Embassy of Japan | 2015-04-16 | JAPAN | Daschle Group, LLC 6280 | 2015-03-16 | Daschle Group, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
167 | 167 | Embassy of Japan | 2001-04-19 | JAPAN | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100 | |||||
168 | 168 | Embassy of Japan | 2023-04-21 | JAPAN | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
169 | 169 | Embassy of Japan | 2023-04-25 | TURKEY | West Wing Writers, LLC 6367 | 2016-08-10 | West Wing Writers, LLC | 2520 Massachusetts Ave NW | Washington, | DC | |||
170 | 170 | Embassy of Japan | 2017-04-26 | JAPAN | S-3 Group 6422 | 2017-04-26 | S-3 Group | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
171 | 171 | Embassy of Japan | 2015-05-08 | JAPAN | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
172 | 172 | Embassy of Japan | 2015-05-16 | JAPAN | Greenfield Law, LLC 6294 | 2015-05-16 | Greenfield Law, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
173 | 173 | Embassy of Japan | 2018-05-18 | JAPAN | RSC Services International LLC 6554 | 2018-05-18 | RSC Services International LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
174 | 174 | Embassy of Japan | 2015-09-18 | JAPAN | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
175 | 175 | Embassy of Japan | 2013-11-08 | JAPAN | Parvin, C. Landon 6194 | 2013-11-08 | Parvin, C. Landon | 2520 Massachusetts Avenue, NW | Washington | DC | |||
1239 | 1239 | 1988-01-12 | Embassy of Japan | 1987-04-16 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Washington | DC | |||
1278 | 1278 | 1954-01-14 | Embassy of Japan | 1954-01-14 | JAPAN | Griggs, Elizabeth Haring 811 | 1954-01-14 | Griggs, Elizabeth Haring | Washington | DC | |||
1448 | 1448 | 1993-01-21 | Embassy of Japan | 1992-04-24 | JAPAN | Clarke Judge Consultants 4654 | 1992-04-24 | Clarke Judge Consultants | Washington | DC | |||
1663 | 1663 | 1957-01-31 | Embassy of Japan | 1954-08-20 | JAPAN | Brunner, Toby Emanuel Godfrey 842 | 1954-08-20 | Brunner, Toby Emanuel Godfrey | Washington | DC | |||
2482 | 2482 | 1984-02-14 | Embassy of Japan | 1972-02-16 | JAPAN | Runkle, Scott F. 2318 | 1972-02-16 | Runkle, Scott F. | |||||
2921 | 2921 | 1976-02-28 | Embassy of Japan | 1957-02-21 | JAPAN | Arter, Hadden & Hemmendinger 1001 | 1957-02-21 | Arter, Hadden & Hemmendinger | Washington | DC | |||
3072 | 3072 | 2006-02-28 | Embassy of Japan | 1983-03-08 | JAPAN | Saunders & Company 3440 | 1983-02-08 | Saunders & Company | Washington | DC | |||
3141 | 3141 | 2021-02-28 | Embassy of Japan | 2020-08-04 | JAPAN | Seven Letter 6847 | 2020-08-04 | Seven Letter | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
3160 | 3160 | 2000-02-29 | Embassy of Japan | 1971-05-07 | JAPAN | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Washington | DC | |||
3772 | 3772 | 1990-03-15 | Embassy of Japan | 1979-05-15 | JAPAN | Evans III, Walter H. 3021 | 1979-05-15 | Evans III, Walter H. | Washington | DC | |||
4058 | 4058 | 1986-03-26 | Embassy of Japan | 1968-06-03 | JAPAN | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | Tokyo | ||||
4371 | 4371 | 1979-03-31 | Embassy of Japan | 1978-05-19 | JAPAN | Malmgren, Inc. 2854 | 1978-01-04 | Malmgren, Inc. | Washington | DC | |||
4403 | 4403 | 1983-03-31 | Embassy of Japan | 1979-07-13 | JAPAN | Jack McDonald Associates, Inc. 3038 | 1979-07-13 | Jack McDonald Associates, Inc. | Washington | DC | |||
4462 | 4462 | 1989-03-31 | Embassy of Japan | 1970-12-09 | JAPAN | Donald G. Lerch, Jr. & Company, Inc. 2089 | 1968-04-22 | Donald G. Lerch, Jr. & Company, Inc. | DC | ||||
4683 | 4683 | 2008-03-31 | Embassy of Japan | 2007-02-23 | JAPAN | Bob, Daniel 5794 | 2007-02-23 | Bob, Daniel | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4684 | 4684 | 2008-03-31 | Embassy of Japan | 2001-05-08 | JAPAN | Butterfield Carter and Associates 5398 | 2000-12-01 | Butterfield Carter and Associates | 2520 Massachusetts Avenue, N.W. 20008 | DC | |||
4755 | 4755 | 2016-03-31 | Embassy of Japan | 2015-09-25 | JAPAN | King & Spalding, LLP 6307 | 2015-07-24 | King & Spalding, LLP | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4771 | 4771 | 2018-03-31 | Embassy of Japan | 2016-07-22 | JAPAN | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4772 | 4772 | 2018-03-31 | Embassy of Japan | 2017-12-21 | JAPAN | Cogent Strategies LLC 6502 | 2017-12-21 | Cogent Strategies LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4778 | 4778 | 2019-03-31 | Embassy of Japan | 2012-04-25 | JAPAN | Friedlander Group 6097 | 2012-04-25 | Friedlander Group | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4802 | 4802 | 2021-03-31 | Embassy of Japan | 2019-04-18 | JAPAN | Comeau & Company LLC 6666 | 2019-04-18 | Comeau & Company LLC | |||||
4803 | 4803 | 2021-03-31 | Embassy of Japan | 2015-05-19 | JAPAN | McGuireWoods Consulting, LLC 6295 | 2015-05-19 | McGuireWoods Consulting, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4863 | 4863 | 1978-04-01 | Embassy of Japan | 1977-08-08 | JAPAN | Brown/Dowling, Ltd. 2772 | 1977-04-19 | Brown/Dowling, Ltd. | Washington | DC | |||
4873 | 4873 | 1981-04-01 | Embassy of Japan | 1979-07-23 | JAPAN | Cladouhos & Brashares 3042 | 1979-07-23 | Cladouhos & Brashares | Washington | DC | |||
4928 | 4928 | 1991-04-01 | Embassy of Japan | 1971-05-04 | JAPAN | Philip Van Slyck, Inc. 1991 | 1967-11-06 | Philip Van Slyck, Inc. | Washington | DC | |||
4987 | 4987 | 1981-04-02 | Embassy of Japan | 1977-12-16 | JAPAN | Potter, Mary Jane 2851 | 1977-12-16 | Potter, Mary Jane | |||||
5104 | 5104 | 1993-04-08 | Embassy of Japan | 1988-10-25 | JAPAN | Paul H. DeLaney, Jr. 4127 | 1988-06-11 | Paul H. DeLaney, Jr. | Washington | DC | |||
5206 | 5206 | 1986-04-12 | Embassy of Japan | 1986-02-04 | JAPAN | Colby, Baily & Associates 3663 | 1985-03-22 | Colby, Baily & Associates | Washington | DC | |||
5258 | 5258 | 1983-04-14 | Embassy of Japan | 1983-03-09 | JAPAN | Sutherland, Asbill & Brennan 3450 | 1983-03-09 | Sutherland, Asbill & Brennan | Washington | DC | |||
5316 | 5316 | 2016-04-15 | Embassy of Japan | 2013-05-05 | JAPAN | Reed, T. Dean 5044 | 1995-09-13 | Reed, T. Dean | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
5473 | 5473 | 1963-04-22 | Embassy of Japan | 1953-11-18 | JAPAN | Dadian, Arnold Harry 796 | 1953-11-18 | Dadian, Arnold Harry | Washington | DC | |||
5628 | 5628 | 2001-04-27 | Embassy of Japan | 1977-04-27 | JAPAN | Dechert, Price & Rhoads 2777 | 1977-05-09 | Dechert, Price & Rhoads | Washington | DC | |||
6220 | 6220 | 1997-05-01 | Embassy of Japan | 1995-03-03 | JAPAN | Decision Management, Inc. 4999 | 1995-03-03 | Decision Management, Inc. | Washington | DC | |||
6256 | 6256 | 1966-05-02 | Embassy of Japan | 1963-07-17 | JAPAN | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Washington | DC | |||
6506 | 6506 | 1982-05-13 | Embassy of Japan | 1963-12-10 | JAPAN | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | |||||
7099 | 7099 | 1991-05-31 | Embassy of Japan | 1984-01-26 | JAPAN | Masaoka & Associates, Inc. 2521 | 1974-06-19 | Masaoka & Associates, Inc. | Washington | DC | |||
7674 | 7674 | 1991-06-08 | Embassy of Japan | 1987-06-08 | JAPAN | Washington Resources & Strategy, Inc. 3989 | 1987-06-08 | Washington Resources & Strategy, Inc. | |||||
7754 | 7754 | 1954-06-12 | Embassy of Japan | 1953-10-19 | JAPAN | Singer, Derek S. 792 | 1953-10-19 | Singer, Derek S. | Washington | DC | |||
8256 | 8256 | 1967-06-30 | Embassy of Japan | 1966-06-30 | JAPAN | McKitterick, Nathaniel M. 1984 | 1966-06-30 | McKitterick, Nathaniel M. | Washington | DC | |||
9037 | 9037 | 1982-07-06 | Embassy of Japan | 1982-05-24 | JAPAN | Miller, Mariko T. 3371 | 1982-05-24 | Miller, Mariko T. | Washington | DC | |||
9098 | 9098 | 1993-07-08 | Embassy of Japan | 1956-04-24 | JAPAN | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | DC | ||||
9252 | 9252 | 1953-07-15 | Embassy of Japan | 1952-07-08 | JAPAN | Smith, Alan Dexter 699 | 1951-12-03 | Smith, Alan Dexter | Washington | DC | |||
9294 | 9294 | 1958-07-16 | Embassy of Japan | 1963-03-22 | JAPAN | Desvernine, Raoul E. 1158 | 1958-07-16 | Desvernine, Raoul E. | Washington | DC | |||
9301 | 9301 | 1979-07-16 | Embassy of Japan | 1977-05-11 | JAPAN | Chinworth, Michael Wesley 2782 | 1977-05-11 | Chinworth, Michael Wesley | Washington | DC | |||
9347 | 9347 | 1985-07-18 | Embassy of Japan | 1985-05-28 | JAPAN | DYR Public Affairs, Inc. 3684 | 1985-05-28 | DYR Public Affairs, Inc. | |||||
9437 | 9437 | 1954-07-23 | Embassy of Japan | 1953-11-16 | JAPAN | Uyehara, Cecil Hideo 795 | 1953-11-16 | Uyehara, Cecil Hideo | Washington | DC | |||
9590 | 9590 | 1994-07-29 | Embassy of Japan | 1971-09-16 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | Washington | DC | |||
9648 | 9648 | 1954-07-31 | Embassy of Japan | 1954-07-02 | JAPAN | Spencer, William Byron 836 | 1954-07-02 | Spencer, William Byron | Washington | DC | |||
9786 | 9786 | 1991-07-31 | Embassy of Japan | 1990-09-27 | JAPAN | Davis Wright Tremaine 4382 | 1990-06-05 | Davis Wright Tremaine | Washington | DC | |||
9799 | 9799 | 1993-07-31 | Embassy of Japan | 1992-04-21 | JAPAN | Evans III, Walter H. 4662 | 1992-04-21 | Evans III, Walter H. | Washington | DC | |||
10126 | 10126 | 1978-08-04 | Embassy of Japan | 1971-08-24 | JAPAN | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | |||||
11152 | 11152 | 2015-08-31 | Embassy of Japan | 2015-06-19 | JAPAN | Southwest Strategies, LLC 6302 | 2015-06-19 | Southwest Strategies, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
11204 | 11204 | 1956-09-01 | Embassy of Japan | 1955-01-31 | JAPAN | Smith, Alan Dexter 869 | 1955-01-31 | Smith, Alan Dexter | Washington | DC | |||
11445 | 11445 | 2017-09-08 | Embassy of Japan | 2014-06-26 | JAPAN | Rasky Baerlein Strategic Communications, Inc. 6222 | 2014-05-16 | Rasky Baerlein Strategic Communications, Inc. | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
11479 | 11479 | 1962-09-10 | Embassy of Japan | 1954-12-29 | JAPAN | Andrews, Marjorie Key 861 | 1954-12-29 | Andrews, Marjorie Key | Washington | DC | |||
11671 | 11671 | 1976-09-16 | Embassy of Japan | 1958-02-26 | JAPAN | Japan Trade Promotion Office (JTPO) 1113 | 1958-02-06 | Japan Trade Promotion Office (JTPO) | Washington | DC | |||
12280 | 12280 | 2022-09-30 | Embassy of Japan | 2017-04-12 | JAPAN | CGCN Group 6396 | 2016-11-30 | CGCN Group | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
12367 | 12367 | 1990-10-01 | Embassy of Japan | 1990-04-12 | JAPAN | Plumb, James W. 4363 | 1990-04-12 | Plumb, James W. | Washington | DC | |||
12403 | 12403 | 2007-10-01 | Embassy of Japan | 2007-08-31 | JAPAN | Advocacy Group 5826 | 2007-08-31 | Advocacy Group | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
13011 | 13011 | 1989-10-25 | Embassy of Japan | 1987-08-17 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | DC | ||||
13522 | 13522 | 1954-11-01 | Embassy of Japan | 1954-04-23 | JAPAN | Shohan, Charles Judah 824 | 1954-04-23 | Shohan, Charles Judah | Washington | DC | |||
13559 | 13559 | 1983-11-01 | Embassy of Japan | 1983-05-19 | JAPAN | Wilbur F. Monroe Associates, Inc. 2888 | 1978-04-20 | Wilbur F. Monroe Associates, Inc. | |||||
13587 | 13587 | 1991-11-01 | Embassy of Japan | 1990-12-21 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
13697 | 13697 | 1965-11-04 | Embassy of Japan | 1953-12-29 | JAPAN | Anderson, Ervin Oscar 808 | 1953-12-29 | Anderson, Ervin Oscar | Washington | DC | |||
13723 | 13723 | 1954-11-05 | Embassy of Japan | 1953-11-18 | JAPAN | Copel, Rita Bernice 797 | 1953-11-18 | Copel, Rita Bernice | Washington | DC | |||
13734 | 13734 | 1990-11-05 | Embassy of Japan | 1989-12-20 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
13803 | 13803 | 1995-11-07 | Embassy of Japan | 1995-11-07 | JAPAN | Larry C. Wallace & Associates, P.A. 5070 | 1995-11-07 | Larry C. Wallace & Associates, P.A. | Washington | DC | |||
14341 | 14341 | 1973-11-30 | Embassy of Japan | 1970-06-01 | JAPAN | Robin, Stephen Philip 2153 | 1969-07-24 | Robin, Stephen Philip | Washington | DC | |||
14349 | 14349 | 1977-11-30 | Embassy of Japan | 1966-11-08 | JAPAN | Heffner, Mary A. 1993 | 1966-11-08 | Heffner, Mary A. | 2520 Massachusetts Avenue, N.W. | ||||
14499 | 14499 | 2002-11-30 | Embassy of Japan | 2002-02-19 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 2520 Massachusetts Avenue, N.W. 20008 | DC | |||
14565 | 14565 | 2017-11-30 | Embassy of Japan | 2009-09-16 | JAPAN | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
14587 | 14587 | 2020-11-30 | Embassy of Japan | 2014-05-21 | JAPAN | Sorini, Samet & Associates, LLC 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
14821 | 14821 | 1977-12-05 | Embassy of Japan | 1977-05-03 | JAPAN | Cladouhos & Brashares 2778 | 1977-05-03 | Cladouhos & Brashares | Washington | DC | |||
15537 | 15537 | 1954-12-31 | Embassy of Japan | 1954-10-28 | JAPAN | Culbertson, Pendleton & Pendleton 637 | 1950-08-10 | Culbertson, Pendleton & Pendleton | Washington | DC | |||
15570 | 15570 | 1957-12-31 | Embassy of Japan | 1953-06-11 | JAPAN | Stitt, Nelson Alexander 771 | 1953-06-11 | Stitt, Nelson Alexander | Washington | DC | |||
15914 | 15914 | 1984-12-31 | Embassy of Japan | 1984-06-21 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
16004 | 16004 | 1987-12-31 | Embassy of Japan | 1977-07-21 | JAPAN | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | Washington | DC | |||
16617 | 16617 | 2007-12-31 | Embassy of Japan | 2007-12-18 | JAPAN | Goldman, Betsy M. 5857 | 2007-12-18 | Goldman, Betsy M. | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16630 | 16630 | 2008-12-31 | Embassy of Japan | 2003-04-08 | JAPAN | Parvin, C. Landon 5551 | 2003-04-08 | Parvin, C. Landon | 2520 Massachusetts Avenue, N.W. 20008 | DC |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );