FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
86 rows where Address_1 = "1801 K Street, N.W."
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3664 | 3664 | 1995-01-13 | 1985-05-07 | Freedman | Matthew C. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
3665 | 3665 | 1995-01-13 | 1993-09-24 | Gloy | Dean N. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
3708 | 3708 | 1994-01-14 | 1990-07-20 | McGee | Wyatt Hudson | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
3804 | 3804 | 1996-01-15 | 1984-09-27 | Pinegar | Linda A. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
3805 | 3805 | 1997-01-15 | 1995-12-14 | Gates | Rick | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
5006 | 5006 | 1986-01-31 | 1985-05-07 | Berman | Wayne L. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
5007 | 5007 | 1986-01-31 | 1985-05-07 | Boyette | Van R. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
7962 | 7962 | 1990-02-28 | 1988-09-06 | Castillo | A. Mario | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
8767 | 8767 | 1988-03-01 | 1987-05-12 | Phillips | Ronald B. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
9401 | 9401 | 1989-03-07 | 1987-05-06 | Miller | David H. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
9736 | 9736 | 1999-03-12 | 1999-06-30 | Hayes | Kathleen P. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
11723 | 11723 | 1995-03-31 | 1993-07-21 | Tracey | Evan | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
11783 | 11783 | 1998-03-31 | 1996-02-23 | Whittinghill | Jim | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
12497 | 12497 | 1992-04-01 | 1986-07-29 | Donaldson | John | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
12731 | 12731 | 1994-04-04 | 1987-03-03 | Dabaghi | William K. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
12732 | 12732 | 1994-04-04 | 1988-03-22 | Usui | Y. Taki | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
12733 | 12733 | 1994-04-04 | 1992-06-10 | Wilson | David I. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
12734 | 12734 | 1994-04-04 | 1992-08-07 | Lacy | Peter G. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
12736 | 12736 | 1994-04-04 | 1990-12-31 | Montgomery | Laura D. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
13465 | 13465 | 1996-04-15 | 1985-05-07 | Healey | James C. , Jr. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
13466 | 13466 | 1996-04-15 | 1985-05-07 | Kelly | Peter G. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
13757 | 13757 | 1996-04-19 | 1993-07-02 | Stefani | Robert J. , Jr. | Robins, Kaplan, Miller & Ciresi 4365 | 1990-04-16 | Robins, Kaplan, Miller & Ciresi | 1801 K Street, N.W. | Suite 1200 | Washington | DC | 20006-1301 |
14148 | 14148 | 2000-04-26 | 2000-01-31 | Paul | Maria Theresa | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
14576 | 14576 | 1987-04-30 | 1986-07-21 | Westerfield | Divina K. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
14849 | 14849 | 2001-04-30 | 1995-06-26 | Cohen | Daniel Lawrence | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
14850 | 14850 | 2001-04-30 | 1995-06-26 | Loeffler | Thomas G. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
14851 | 14851 | 2001-04-30 | 1995-06-26 | Plebani | Jon W. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
14871 | 14871 | 2002-04-30 | 1990-04-16 | Mesirow | Harold E. | Robins, Kaplan, Miller & Ciresi 4365 | 1990-04-16 | Robins, Kaplan, Miller & Ciresi | 1801 K Street, N.W. | Suite 1200 | Washington | DC | 20006-1301 |
14874 | 14874 | 2002-04-30 | 1999-05-26 | Hunnicutt | Charles A. | Robins, Kaplan, Miller & Ciresi 4365 | 1990-04-16 | Robins, Kaplan, Miller & Ciresi | 1801 K Street, N.W. | Suite 1200 | Washington | DC | 20006-1301 |
14882 | 14882 | 2002-04-30 | 1997-12-01 | Diamond | Scott E. | Robins, Kaplan, Miller & Ciresi 4365 | 1990-04-16 | Robins, Kaplan, Miller & Ciresi | 1801 K Street, N.W. | Suite 1200 | Washington | DC | 20006-1301 |
15692 | 15692 | 1990-05-04 | 1988-09-20 | Landmeier | Lisa M. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
17773 | 17773 | 1994-05-31 | 1990-09-28 | Gluck | Richard D. | Robins, Kaplan, Miller & Ciresi 4365 | 1990-04-16 | Robins, Kaplan, Miller & Ciresi | 1801 K Street, N.W. | Suite 1200 | Washington | DC | 20006-1301 |
18506 | 18506 | 1995-06-01 | 1985-05-07 | Stone | Roger J. , Jr. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
18656 | 18656 | 1993-06-02 | 1990-04-16 | Martin | Robert | Robins, Kaplan, Miller & Ciresi 4365 | 1990-04-16 | Robins, Kaplan, Miller & Ciresi | 1801 K Street, N.W. | Suite 1200 | Washington | DC | 20006-1301 |
18657 | 18657 | 1993-06-02 | 1990-04-16 | Turnbull | Lowell D. | Robins, Kaplan, Miller & Ciresi 4365 | 1990-04-16 | Robins, Kaplan, Miller & Ciresi | 1801 K Street, N.W. | Suite 1200 | Washington | DC | 20006-1301 |
19024 | 19024 | 1999-06-07 | 1999-07-30 | Heffern | Keith L. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
19349 | 19349 | 1995-06-13 | 1987-04-20 | Davis | Richard H. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
19865 | 19865 | 1992-06-19 | 1989-03-20 | Sweitzer | Donald R. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
21408 | 21408 | 2001-06-30 | 1996-07-18 | Dabaghi | William K. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
21411 | 21411 | 2001-06-30 | 1997-07-30 | Stumme | Susan L. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
22696 | 22696 | 1989-07-07 | 1988-01-21 | Giltmier | James William | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
23116 | 23116 | 1993-07-14 | 1987-03-04 | Sweet | Stuart Jonathan | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23118 | 23118 | 1993-07-14 | 1992-05-18 | Ussery | Elbert Michael | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23120 | 23120 | 1993-07-14 | 1989-07-13 | Sagredo | Virginia E. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23121 | 23121 | 1993-07-14 | 1990-07-13 | Calhoun | Margaret P. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23122 | 23122 | 1994-07-14 | 1986-03-11 | Keyserling | Jonathan | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23123 | 23123 | 1994-07-14 | 1992-07-20 | Fenig | David H. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23127 | 23127 | 1999-07-14 | 1995-03-24 | Powell | Paul | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23236 | 23236 | 1987-07-15 | 1986-01-15 | Drischler | Alvin P. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23279 | 23279 | 1995-07-15 | 1985-05-07 | Manafort | Paul J. , Jr. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
24755 | 24755 | 1987-07-31 | 1987-05-12 | Payer | Catherine | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
24877 | 24877 | 1996-07-31 | 1985-05-07 | Panuzio | Nicholas A. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
24894 | 24894 | 1997-07-31 | 1995-06-26 | Eckart | Dennis E. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
27129 | 27129 | 1991-08-21 | 1985-05-07 | Black | Charles R. , Jr. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
28208 | 28208 | 1991-08-31 | 1988-10-12 | Nishido | Hiroshi | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
28294 | 28294 | 1997-08-31 | 1993-01-08 | Kelly | Peter G. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
28897 | 28897 | 1991-09-01 | 1990-09-25 | Coughlin | Mary Ellen | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
29723 | 29723 | 1987-09-14 | 1986-07-21 | Aycoth | John | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
31151 | 31151 | 1996-09-30 | 1995-10-16 | Willhite | Debbie | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
31910 | 31910 | 1989-10-01 | 1988-02-02 | Calhoun | Margaret P. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
31934 | 31934 | 1993-10-01 | 1993-06-29 | Allbee | Ronald A. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
31950 | 31950 | 1999-10-01 | 1998-01-30 | Chapman | James L. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
33018 | 33018 | 1992-10-16 | 1990-06-20 | Kruchko | Phyllis Elisabeth | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
33019 | 33019 | 1992-10-16 | 1992-06-30 | Moos | Gene | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
33066 | 33066 | 1990-10-17 | 1987-05-12 | Burke | Georgia H. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
33073 | 33073 | 1997-10-17 | 1996-07-18 | Beckert | Stephan A. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
34303 | 34303 | 1990-10-31 | 1988-03-03 | Matsumoto | Tokuo | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
34304 | 34304 | 1990-10-31 | 1988-03-31 | Horiuchi | Mitsugu | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
34305 | 34305 | 1990-10-31 | 1987-05-12 | McDonald | Tom | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
34312 | 34312 | 1990-10-31 | 1988-10-12 | Murayama | Shiji | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
34964 | 34964 | 1999-11-01 | 1996-02-01 | Blum | Jennifer L. | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | 1801 K Street, N.W. | Suite 400-K | Washington | DC | 20006-1301 |
35167 | 35167 | 1992-11-03 | 1985-05-07 | Pastrick | R. Scott | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
35877 | 35877 | 1995-11-15 | 1995-01-13 | Truelove | Tracy | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38122 | 38122 | 1992-12-11 | 1992-12-11 | Komaguchi | Sakari | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
38309 | 38309 | 1996-12-14 | 1995-10-16 | Burns | Anne Davis | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38311 | 38311 | 1999-12-14 | 2000-01-13 | Navarro | Ana V. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38312 | 38312 | 1999-12-14 | 1986-01-15 | Levinson | K. Riva | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38313 | 38313 | 1999-12-14 | 1996-01-16 | Cotter | Lisa Marie | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38314 | 38314 | 1999-12-14 | 1999-01-19 | Chiccehitto | Karen | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38315 | 38315 | 1999-12-14 | 1996-01-31 | Konicoff | Craig S. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38316 | 38316 | 1999-12-14 | 1999-06-28 | Healey | James C. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38317 | 38317 | 1999-12-14 | 1992-07-14 | Arnold | Mary Elizabeth | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38318 | 38318 | 1999-12-14 | 1998-10-14 | Disler | Mark Robert | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
38319 | 38319 | 1999-12-14 | 1998-10-14 | Fenig | David H. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
40438 | 40438 | 1987-12-31 | 1985-09-26 | Lehman | Christopher M. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
40792 | 40792 | 1994-12-31 | 1992-07-14 | Stevens | Robert Gregory | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
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]) );