FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
77 rows where City = "Washington" and Short_Form_Last_Name = "Johnson"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Date (date)
Registration_Number >30
- Hill and Knowlton Strategies, LLC 7
- Arnold & Porter Kaye Scholer LLP 3
- Akin, Gump, Strauss, Hauer & Feld, LLP 3
- FGS Global (US) LLC (FKA FGH Holdings LLC) 3
- Robert R. Nathan Associates, Inc. 2
- Cleary, Gottlieb, Steen & Hamilton, LLP 2
- Squire Patton Boggs, LLP 2
- Burson-Marsteller 2
- Donald G. Johnson Company 2
- DLA Piper US LLP 2
- APCO Worldwide, Inc. 2
- APCO Worldwide LLC 2
- Covington & Burling 1
- National Lecture Management, Inc. 1
- Galland, Kharasch, Calkins & Short, P.C. 1
- Bradford, T. Walter 1
- Samuel E. Stavisky & Associates, Inc. 1
- Checchi & Company 1
- Hogan Lovells US LLP 1
- Anderson & Pendleton, C.A. 1
- deKieffer & Associates, P.C. 1
- Palestine Information Office 1
- Lebanese Information & Research Center 1
- Crowell & Moring 1
- Seyfarth, Shaw, Fairweather & Geraldson 1
- Martin Ryan Haley & Associates, Inc. 1
- Korea Economic Institute 1
- Wilmer, Cutler & Pickering 1
- Chadbourne & Parke 1
- Gold & Liebengood, Inc. 1
- …
Registrant_Name >30
- Hill and Knowlton Strategies, LLC 7
- APCO Worldwide, Inc. 3
- Akin, Gump, Strauss, Hauer & Feld, LLP 3
- Arnold & Porter Kaye Scholer LLP 3
- FGS Global (US) LLC (FKA FGH Holdings LLC) 3
- APCO Worldwide LLC 2
- Burson-Marsteller 2
- Cleary, Gottlieb, Steen & Hamilton, LLP 2
- DLA Piper US LLP 2
- Donald G. Johnson Company 2
- Robert R. Nathan Associates, Inc. 2
- Squire Patton Boggs, LLP 2
- Anderson & Pendleton, C.A. 1
- Bradford, T. Walter 1
- Cassidy & Associates, Inc. 1
- Chadbourne & Parke 1
- Checchi & Company 1
- Covington & Burling 1
- Covington & Burling LLP 1
- Crowell & Moring 1
- Downey McGrath Group, Inc. 1
- GAGE International, LLC 1
- Galland, Kharasch, Calkins & Short, P.C. 1
- Gold & Liebengood, Inc. 1
- GoodWorks International, LLC 1
- Griffin, Johnson, Dover & Stewart Inc. 1
- Guatemala FUNDESA Working Group 1
- Harbour Group, LLC 1
- Hogan Lovells US LLP 1
- Jefferson Group, Inc. 1
- …
State 1
- DC 77
City 1
- Washington · 77 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1188 | 1188 | 2022-06-03 | Johnson | Lisa | Covington & Burling LLP 6876 | 2020-10-13 | Covington & Burling LLP | 850 10th Street | Washington | DC | 20001 | ||
2306 | 2306 | 2021-11-30 | Johnson | Matthew L. | Klein/Johnson Group LLC 7049 | 2021-11-30 | Klein/Johnson Group LLC | 923 15th St. NW | 6th Floor | Washington | DC | 20005 | |
2422 | 2422 | 2021-12-17 | Johnson | David Robert | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 | |
3579 | 3579 | 1993-01-11 | 1989-08-11 | Johnson | Frances Faye | Lebanese Information & Research Center 2935 | 1978-07-27 | Lebanese Information & Research Center | Post Office Box 57224 | Washington | DC | 20037 | |
6375 | 6375 | 1983-02-08 | 1977-02-08 | Johnson | Thomas A. | Galland, Kharasch, Calkins & Short, P.C. 1051 | 1957-07-09 | Galland, Kharasch, Calkins & Short, P.C. | 1054 - 31st Street, N.W. | Washington | DC | 20007 | |
6415 | 6415 | 1995-02-08 | 1994-07-08 | Johnson | Mark R. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
7013 | 7013 | 2020-02-15 | 2018-09-13 | Johnson | Marc | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
7017 | 7017 | 2020-02-15 | 2018-09-26 | Johnson | Alexandra | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
7119 | 7119 | 1995-02-16 | 1980-07-19 | Johnson | Richard C. | Seyfarth, Shaw, Fairweather & Geraldson 3122 | 1980-07-18 | Seyfarth, Shaw, Fairweather & Geraldson | 815 Connecticut Avenue, N.W. | Suite 500 | Washington | DC | 20006-4004 |
7126 | 7126 | 1996-02-16 | 1995-03-20 | Johnson | George Lee Gewin | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | 1455 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20004 |
7387 | 7387 | 1995-02-22 | 1994-03-11 | Johnson | Samuel B. | Spiegel & McDiarmid 4896 | 1994-02-28 | Spiegel & McDiarmid | 1350 New York Avenue, N.W. | Suite 1100 | Washington | DC | 200054798 |
8371 | 8371 | 2020-02-28 | 2019-04-04 | Johnson | David | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
8448 | 8448 | 1964-02-29 | 1964-05-14 | Johnson | Nicholas | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
8999 | 8999 | 1965-03-03 | 1963-01-09 | Johnson | Betty Josephine | Samuel E. Stavisky & Associates, Inc. 1531 | 1962-04-02 | Samuel E. Stavisky & Associates, Inc. | 1725 DeSales Street, N.W. | Suite 804 | Washington | DC | 20036 |
10320 | 10320 | 1993-03-19 | 1992-05-04 | Johnson | Peri Lynne | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
10445 | 10445 | 1989-03-21 | 1985-08-29 | Johnson | Pamela Joy | Rogers & Cowan, Inc., Washington Office 3707 | 1985-07-29 | Rogers & Cowan, Inc., Washington Office | 2233 Wisconsin Avenue | Suite 500 | Washington | DC | 20007 |
10619 | 10619 | 1995-03-23 | 1990-07-24 | Johnson | Stephen M. | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | 1341 G Street, N.W. | Suite 1100 | Washington | DC | 20005 |
10627 | 10627 | 2001-03-23 | 1996-07-17 | Johnson | Michael S. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
11810 | 11810 | 1999-03-31 | 1997-04-21 | Johnson | Krista K. | Ruder Finn, Inc. 4315 | 1989-11-09 | Ruder Finn, Inc. | 808 - 17th Street, N.W. | Suite 600 | Washington | DC | 20006 |
12106 | 12106 | 2012-03-31 | 2011-09-23 | Johnson | Meghan | Roberti + White, LLC 6065 | 2011-09-23 | Roberti + White, LLC | 900 G Street NW | Suite 301 | Washington | DC | 20001 |
12306 | 12306 | 2022-03-31 | 2022-02-07 | Johnson | Joel | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
13044 | 13044 | 1996-04-09 | 1995-02-17 | Johnson | Richard A. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
13475 | 13475 | 2002-04-15 | 2001-05-07 | Johnson | David E. | Griffin, Johnson, Dover & Stewart Inc. 5428 | 2001-05-07 | Griffin, Johnson, Dover & Stewart Inc. | 1300 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
13996 | 13996 | 1988-04-23 | 1987-10-28 | Johnson | David E. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
14115 | 14115 | 2014-04-25 | 2014-04-16 | Johnson | Glen | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
14761 | 14761 | 1998-04-30 | 1997-04-21 | Johnson | Dennis R. | Olsson, Frank & Weeda, P.C. 5175 | 1997-04-21 | Olsson, Frank & Weeda, P.C. | 1400 - 16th Street, N.W. | Suite 400 | Washington | DC | 20036-2220 |
14902 | 14902 | 2003-04-30 | 1996-06-21 | Johnson | Robert W. , II | Washington World Group, Ltd. 5016 | 1995-04-20 | Washington World Group, Ltd. | 2120 L Street, N.W. | Suite 100 | Washington | DC | 20037 |
15426 | 15426 | 1990-05-01 | 1988-11-02 | Johnson | Evelyn E. | Chadbourne & Parke 3490 | 1983-06-24 | Chadbourne & Parke | 1101 Vermont Avenue, N.W. | Suite 900 | Washington | DC | 20005 |
16066 | 16066 | 2007-05-11 | 2006-06-29 | Johnson | George Lee | Sandler, Travis & Rosenberg, P.A. 5303 | 1998-12-07 | Sandler, Travis & Rosenberg, P.A. | 1300 Pennsylvania Avenue, N.W. | Suite 400 | Washington | DC | 20004-3002 |
16213 | 16213 | 1982-05-13 | 1947-05-22 | Johnson | Gove Griffith | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | 3 Thomas Circle | Washington | DC | 20530 | |
16234 | 16234 | 1982-05-13 | 1964-09-10 | Johnson | Robert Henry | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | 3 Thomas Circle | Washington | DC | 20530 | |
16550 | 16550 | 1971-05-17 | 1964-05-12 | Johnson | Elizabeth V. | Checchi & Company 1713 | 1964-04-14 | Checchi & Company | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
16590 | 16590 | 1983-05-17 | 1979-12-27 | Johnson | W. Stanfield | Crowell & Moring 3058 | 1979-09-11 | Crowell & Moring | 1100 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
16717 | 16717 | 2017-05-19 | 2007-11-16 | Johnson | Joel | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
16964 | 16964 | 1997-05-23 | 1997-02-21 | Johnson | Lee | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
17082 | 17082 | 1988-05-25 | 1978-04-24 | Johnson | Marilyn Penelope | Palestine Information Office 2891 | 1978-04-24 | Palestine Information Office | 818 - 18th Street, N.W. | Suite 620 | Washington | DC | 20006 |
18355 | 18355 | 1958-06-01 | 1958-03-18 | Johnson | Loyce M. | Bradford, T. Walter 1076 | 1957-11-01 | Bradford, T. Walter | 810 - 18th Street, N.W. | Washington | DC | ||
20781 | 20781 | 1966-06-30 | 1965-08-02 | Johnson | Robert Knowles | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
21443 | 21443 | 2002-06-30 | 2001-08-10 | Johnson | C. Donald | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21665 | 21665 | 2010-06-30 | 2008-07-30 | Johnson | Charlie | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
24490 | 24490 | 1982-07-30 | 1980-12-08 | Johnson | Joe P. | Martin Ryan Haley & Associates, Inc. 3178 | 1980-12-09 | Martin Ryan Haley & Associates, Inc. | 1015 - 15th Street, N.W. | Suite 200 | Washington | DC | 20005 |
26726 | 26726 | 1988-08-15 | 1986-04-08 | Johnson | Lindsey | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
26811 | 26811 | 1953-08-16 | 1951-11-09 | Johnson | Doris Hurtig | National Lecture Management, Inc. 638 | 1950-08-16 | National Lecture Management, Inc. | 714 Dupont Cirle Building | Suite 928 | Washington | DC | |
27402 | 27402 | 1978-08-25 | 1978-01-17 | Johnson | Donald G. | deKieffer & Associates, P.C. 2857 | 1978-01-17 | deKieffer & Associates, P.C. | 1055 Thomas Jeff. Street, N.W. | Washington | DC | 20007 | |
28236 | 28236 | 1993-08-31 | 1991-09-04 | Johnson | Eric Laurent | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
28275 | 28275 | 1996-08-31 | 1993-02-12 | Johnson | David E. | Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. 4766 | 1993-02-12 | Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. | 1300 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
28467 | 28467 | 2006-08-31 | 2006-03-15 | Johnson | Jeffrey C. | GAGE International, LLC 5739 | 2006-03-15 | GAGE International, LLC | 122 C Street, NW | Suite 380 | Washington | DC | 20001 |
29229 | 29229 | 2000-09-05 | 1995-06-02 | Johnson | Steven R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29284 | 29284 | 2007-09-06 | 2005-01-31 | Johnson | Joel | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
29575 | 29575 | 1987-09-11 | 1987-05-18 | Johnson | Lea | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
30264 | 30264 | 1989-09-22 | 1989-03-06 | Johnson | Lynne L. | Reid & Priest 4223 | 1989-03-06 | Reid & Priest | 701 Pennsylvania Avenue, N.W. | Suite 800 | Washington | DC | 20004 |
30719 | 30719 | 1986-09-29 | 1983-10-03 | Johnson | Donald G. | Donald G. Johnson Company 3341 | 1981-09-12 | Donald G. Johnson Company | 3710 Corey Place, N.W. | Washington | DC | 20016 | |
30720 | 30720 | 1986-09-29 | 1983-10-03 | Johnson | Jean | Donald G. Johnson Company 3341 | 1981-09-12 | Donald G. Johnson Company | 3710 Corey Place, N.W. | Washington | DC | 20016 | |
30986 | 30986 | 1986-09-30 | 1986-07-01 | Johnson | Donald G. | Riley & Fox, Inc. 3813 | 1986-04-11 | Riley & Fox, Inc. | 1101 - 17th Street, N.W. | Suite 606 | Washington | DC | 20036 |
32052 | 32052 | 2012-10-01 | 2012-08-21 | Johnson | Paul | National Strategies, LLC 6123 | 2012-08-07 | National Strategies, LLC | 1400 Eye Street, NW | Suite 900 | Washington | DC | 20005 |
32451 | 32451 | 1990-10-08 | 1986-02-24 | Johnson | David R. | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
33157 | 33157 | 2011-10-18 | 2008-08-14 | Johnson | Ralph | Quinn Gillespie & Associates, LLC 5753 | 2006-06-01 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, NW | 5th Floor | Washington | DC | 20036 |
34098 | 34098 | 2012-10-30 | Johnson | Lester | Washington Avenue International LLC 6135 | 2012-10-09 | Washington Avenue International LLC | 1701 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 | |
34350 | 34350 | 1994-10-31 | 1993-10-22 | Johnson | Allison Marie | Washington & Christian 4569 | 1991-09-20 | Washington & Christian | 1155 15th Street, N.W. | Suite 1004 | Washington | DC | 20005 |
34355 | 34355 | 1995-10-31 | 1995-04-04 | Johnson | Robert W. , II | Guatemala FUNDESA Working Group 5007 | 1995-04-04 | Guatemala FUNDESA Working Group | 1050 Potomac Street, N.W. | Washington | DC | 20007 | |
35667 | 35667 | 1993-11-12 | 1984-04-19 | Johnson | Richard A. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
35889 | 35889 | 1997-11-15 | 1996-12-30 | Johnson | Jerry | Powell Tate, Inc. 5148 | 1996-12-30 | Powell Tate, Inc. | 700 - 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
36816 | 36816 | 1996-11-30 | 1992-06-03 | Johnson | Jerry | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | 700 - 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
36914 | 36914 | 2003-11-30 | 2003-03-28 | Johnson | Meghan Cara | Downey McGrath Group, Inc. 5411 | 2001-02-13 | Downey McGrath Group, Inc. | 1225 I Street, N.W. | Suite 600 | Washington | DC | 20005 |
37270 | 37270 | 1967-12-01 | 1948-01-19 | Johnson | James Gann , Jr. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
37885 | 37885 | 1992-12-07 | 1982-06-30 | Johnson | Stephen S. | Anderson & Pendleton, C.A. 2696 | 1976-06-09 | Anderson & Pendleton, C.A. | 1700 K Street, N.W. | Suite 1107 | Washington | DC | 20006 |
38752 | 38752 | 2007-12-19 | 2007-11-20 | Johnson | Lionel C. | GoodWorks International, LLC 5414 | 2001-03-02 | GoodWorks International, LLC | 1700 K Street NW | Suite 430 | Washington | DC | 20006-3806 |
39084 | 39084 | 1997-12-24 | 1992-08-14 | Johnson | James , Jr. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
40461 | 40461 | 1988-12-31 | 1988-02-25 | Johnson | Bruce A. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
40499 | 40499 | 1988-12-31 | 1983-06-17 | Johnson | Stephen M. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
40513 | 40513 | 1988-12-31 | 1987-07-28 | Johnson | Mark | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
40536 | 40536 | 1988-12-31 | 1987-11-06 | Johnson | Paul R. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
40551 | 40551 | 1989-12-31 | 1988-03-15 | Johnson | Arnold C. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
41372 | 41372 | 2004-12-31 | 2002-10-30 | Johnson | Joel | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
41394 | 41394 | 2005-12-31 | 2005-03-11 | Johnson | Clete D. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41756 | 41756 | 2011-12-31 | 2010-04-28 | Johnson | Marc | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
42166 | 42166 | 2017-12-31 | 2014-11-18 | Johnson | Rachelle | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );