home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

287 rows where City = "Alexandria"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number >30

  • Bannerman & Associates, Inc. 25
  • Keene, Shirley & Associates, Inc. 16
  • Black, Manafort & Stone, Inc. 10
  • Thales, Inc. 10
  • Potomac International Partners, Inc. 10
  • Corallo Media Strategies, Inc 7
  • Rollins International, Ltd. 6
  • Pierson & Burnett, L.L.P. 6
  • Stafford, Burke & Hecker, Inc. 5
  • Justice International 5
  • Stafford, Burke & Hecker, Inc. 5
  • United International Consultants 5
  • Bond Donatelli, Inc. 5
  • Kelley Swofford Roy Helmke, Inc. 5
  • Davis Manafort & Freedman, Inc. 5
  • Spectrum Group Members, LLC 5
  • Grieboski Global Strategies, LLC 5
  • Manafort Jr., Paul J. 4
  • Ginn, Edington, Wade & Sanders, Inc. 4
  • Symms, Lehn & Associates, Inc. 4
  • Davis, Manafort & Freedman 4
  • McCaffrey Braley, Inc. 4
  • Polaris Government Affairs, LLC 4
  • Just Consulting LLC 4
  • McKeon Group, Inc. 4
  • NAP International, Inc. 3
  • NM International, Inc. 3
  • Smith & Harroff, Inc. 3
  • CounterTerrorism Consultants, L.P. 3
  • Smith & Harroff, Inc. 3
  • …

Registrant_Name >30

  • Bannerman & Associates, Inc. 25
  • Keene, Shirley & Associates, Inc. 16
  • Black, Manafort & Stone, Inc. 10
  • Potomac International Partners, Inc. 10
  • Stafford, Burke & Hecker, Inc. 10
  • Thales, Inc. 10
  • Smith & Harroff, Inc. 8
  • Corallo Media Strategies, Inc 7
  • Pierson & Burnett, L.L.P. 6
  • Rollins International, Ltd. 6
  • Bond Donatelli, Inc. 5
  • Davis Manafort & Freedman, Inc. 5
  • Grieboski Global Strategies, LLC 5
  • Justice International 5
  • Kelley Swofford Roy Helmke, Inc. 5
  • Spectrum Group Members, LLC 5
  • United International Consultants 5
  • Davis, Manafort & Freedman 4
  • Ginn, Edington, Wade & Sanders, Inc. 4
  • Just Consulting LLC 4
  • Manafort Jr., Paul J. 4
  • McCaffrey Braley, Inc. 4
  • McKeon Group, Inc. 4
  • Polaris Government Affairs, LLC 4
  • Symms, Lehn & Associates, Inc. 4
  • Bain & Associates, Inc. 3
  • Blueprint Communications, LLC 3
  • CounterTerrorism Consultants, L.P. 3
  • Craig Shirley & Associates, Inc. 3
  • DMS, Inc. 3
  • …

State 1

  • VA 287

City 1

  • Alexandria · 287 ✖
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
332 332   2019-02-07 Chwat John McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
510 510   2020-03-05 Goth Bashir Somaliland Mission USA, LLC 6798 2020-03-05 Somaliland Mission USA, LLC 6019 Tower Court   Alexandria VA 22304
511 511   2020-03-05 Meri Yassin Mohamed Somaliland Mission USA, LLC 6798 2020-03-05 Somaliland Mission USA, LLC 6019 Tower Court   Alexandria VA 22304
584 584   2023-03-16 Harris Marshall The Marshall Harris Group 7245 2023-03-16 The Marshall Harris Group 703 Norfolk Lane   Alexandria VA 22314
827 827   2023-04-18 Lewis Jr. Robert The Van Aucker Group 7260 2023-04-18 The Van Aucker Group 5500 Layne Estates Court   Alexandria VA 22310
1062 1062   2023-05-19 Fogarty Kevin Ambrose Partners LLC 7276 2023-05-19 Ambrose Partners LLC 1803 Olive Court   Alexandria VA 22308
1243 1243   2023-06-15 Djordjevic Zorica Marie The Marshall Harris Group 7245 2023-03-16 The Marshall Harris Group 703 Norfolk Lane   Alexandria VA 22314
1652 1652   2018-08-22 Keysor David McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
1766 1766   2006-09-12 Boddie Richard F. Slocum & Boddie, PLLC 5765 2006-09-12 Slocum & Boddie, PLLC 5400 Shanee Rd. Suite 300 Alexandria VA 22312
1767 1767   2006-09-12 Slocum J. Michael Slocum & Boddie, PLLC 5765 2006-09-12 Slocum & Boddie, PLLC 5400 Shanee Rd. Suite 300 Alexandria VA 22312
2174 2174   2021-11-15 Gallagher James P. The Gallagher Group, LLC 7046 2021-11-15 The Gallagher Group, LLC 2503 Hayes Street   Alexandria VA 22302
2176 2176   2016-11-16 McKeon Howard P. McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
3380 3380 2013-01-07 2012-12-14 Goldstein Dana Webster Hudson Just Consulting LLC 6137 2012-09-25 Just Consulting LLC 950 N. Washington St.   Alexandria VA 22314
3523 3523 1991-01-10 1987-01-09 Weintraub Michael P. Ann E.W. Stone & Associates 3914 1986-12-11 Ann E.W. Stone & Associates 1315 Duke Street   Alexandria VA 22314
3591 3591 2013-01-11 2012-10-03 Grieboski Joseph K Just Consulting LLC 6137 2012-09-25 Just Consulting LLC 950 N. Washington St.   Alexandria VA 22314
3592 3592 2013-01-11 2012-10-03 Hengesbach Kelly Just Consulting LLC 6137 2012-09-25 Just Consulting LLC 950 N. Washington St.   Alexandria VA 22314
3964 3964 1990-01-17 1989-02-14 Zagame John R. John R. Zagame Associates, Inc. 4216 1989-02-14 John R. Zagame Associates, Inc. 211 North Union Street   Alexandria VA 22314
4103 4103 2000-01-19 1999-06-03 Weller Thomas A. Thales, Inc. 4628 1992-04-02 Thales, Inc. 99 Canal Center Plaza Suite 450 Alexandria VA 22314
4169 4169 1995-01-20 1992-04-02 Bell James D. Thales, Inc. 4628 1992-04-02 Thales, Inc. 99 Canal Center Plaza Suite 450 Alexandria VA 22314
4174 4174 2000-01-20 1999-06-03 White, Jr. Thomas G. Thales, Inc. 4628 1992-04-02 Thales, Inc. 99 Canal Center Plaza Suite 450 Alexandria VA 22314
4353 4353 1995-01-24 1988-04-08 Silvers Curtis M. Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
4355 4355 1995-01-24 1990-11-29 Carlen Patricia M. (Bauer) Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
5009 5009 1986-01-31 1984-06-04 Berman Wayne Manafort Jr., Paul J. 3594 1984-06-04 Manafort Jr., Paul J. 211 North Union Street 3rd Floor Alexandria VA 22314
5263 5263 2002-01-31 1997-07-18 Carlberg Ronald L. GMD Solutions (A Division of Defense Group, Inc.) 5195 1997-07-18 GMD Solutions (A Division of Defense Group, Inc.) 2121 Eisenhower Avenue Suite 600 Alexandria VA 22314-4678
5425 5425 2009-01-31 2008-12-01 Davis James B. Spectrum Group Members, LLC 5894 2008-12-01 Spectrum Group Members, LLC 11 Canal Center Plaza Suite 103 Alexandria VA 22314
5434 5434 2010-01-31 2009-07-29 Hamel Gretchen Endeavour Global Strategies 5946 2009-07-29 Endeavour Global Strategies 201 King Street Suite 202 Alexandria VA 22314
5501 5501 2016-01-31 2016-05-02 Leite Mariane Grieboski Global Strategies, LLC 6315 2015-09-08 Grieboski Global Strategies, LLC 950 North Washington Street   Alexandria VA 22314
5802 5802 1998-02-01 1996-08-07 Furman Valerie M. Pierson & Burnett, L.L.P. 5127 1996-08-07 Pierson & Burnett, L.L.P. 517 South Washington Street   Alexandria VA 22314-4143
6534 6534 1987-02-10 1987-01-09 Armstrong Holly Ann E.W. Stone & Associates 3914 1986-12-11 Ann E.W. Stone & Associates 1315 Duke Street   Alexandria VA 22314
6742 6742 1996-02-13 1994-06-07 Ray Richard B. Richard B. Ray, Inc. 4918 1994-06-07 Richard B. Ray, Inc. Post Office Box 15099   Alexandria VA 22309
7175 7175 2006-02-17 2001-05-29 Higdon Sarah Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
7440 7440 1989-02-23 1988-02-04 Flanagan Daniel V. , Jr. Flanagan Group, Inc. 4067 1987-12-03 Flanagan Group, Inc. 11 Canal Center Plaza Suite 250 Alexandria VA 22314
7700 7700 1986-02-26 1985-07-30 Stone Roger J. , Jr. Black, Manafort, Stone & Atwater, Inc. 3710 1985-07-30 Black, Manafort, Stone & Atwater, Inc. 324 North Fairfax Street   Alexandria VA 22314
7813 7813 2017-02-27 2015-09-08 Casey Tracy Lynn Grieboski Global Strategies, LLC 6315 2015-09-08 Grieboski Global Strategies, LLC 950 North Washington Street   Alexandria VA 22314
7814 7814 2017-02-27 2015-09-08 Grieboski Joseph K. Grieboski Global Strategies, LLC 6315 2015-09-08 Grieboski Global Strategies, LLC 950 North Washington Street   Alexandria VA 22314
7815 7815 2017-02-27 2016-09-13 Dulmage Olivia Grieboski Global Strategies, LLC 6315 2015-09-08 Grieboski Global Strategies, LLC 950 North Washington Street   Alexandria VA 22314
7956 7956 1990-02-28 1988-05-02 Moore Powell A. Ginn, Edington, Wade & Sanders, Inc. 4134 1988-05-02 Ginn, Edington, Wade & Sanders, Inc. 803 Prince Street   Alexandria VA 22314
7982 7982 1991-02-28 1990-08-31 Watlington B. Gale Keene, Shirley & Associates, Inc. 3997 1987-06-19 Keene, Shirley & Associates, Inc. 919 Prince Street   Alexandria VA 22314
8049 8049 1996-02-28 1992-02-20 Faranetta Christopher J. Energia U.S.A., Inc. 4621 1992-02-20 Energia U.S.A., Inc. 631 South Washington Street   Alexandria VA 22314
8050 8050 1996-02-28 1992-02-20 Manber Jeffrey Energia U.S.A., Inc. 4621 1992-02-20 Energia U.S.A., Inc. 631 South Washington Street   Alexandria VA 22314
8195 8195 2006-02-28 1983-02-08 Saunders Steven R. Saunders & Company 3440 1983-02-08 Saunders & Company 1015 Duke Street   Alexandria VA 22314-3551
8207 8207 2007-02-28 2000-01-07 Abington Edward G. Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
8208 8208 2007-02-28 2000-01-07 Silvers Curtis M. Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
8221 8221 2007-02-28 1992-03-12 Miner William A. Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
8222 8222 2007-02-28 1987-04-28 Bannerman M. Graeme Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
8224 8224 2007-02-28 2004-11-30 Hannes John Z. Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
8337 8337 2018-02-28 2017-08-09 Amagai Mattie Cowan Strategies Company 6452 2017-08-09 Cowan Strategies Company 119 Oronoco Street Suite 101 Alexandria VA 22314
8338 8338 2018-02-28 2017-08-09 Cowan Mark D. Cowan Strategies Company 6452 2017-08-09 Cowan Strategies Company 119 Oronoco Street Suite 101 Alexandria VA 22314
8800 8800 1995-03-01 1995-01-30 Cofer Williston B. , Jr. Will Cofer Associates, Inc. 4987 1995-01-30 Will Cofer Associates, Inc. 4001 Pine Brook Road   Alexandria VA 22310
8801 8801 1995-03-01 1995-01-30 Feuer Paul H. Will Cofer Associates, Inc. 4987 1995-01-30 Will Cofer Associates, Inc. 4001 Pine Brook Road   Alexandria VA 22310
9247 9247 1997-03-06 1996-08-07 Rubinstein Jules I. Pierson & Burnett, L.L.P. 5127 1996-08-07 Pierson & Burnett, L.L.P. 517 South Washington Street   Alexandria VA 22314-4143
9402 9402 1989-03-07 1987-08-19 Miller David H. NAP International, Inc. 3926 1987-01-12 NAP International, Inc. 211 North Union Street Suite 200 Alexandria VA 22314
9403 9403 1989-03-07 1987-08-19 Miller David H. NM International, Inc. 3927 1987-01-12 NM International, Inc. 211 North Union Street Suite 200 Alexandria VA 22314
9646 9646 1997-03-11 1995-01-20 Sandzer-Bell Benjamin Thales, Inc. 4628 1992-04-02 Thales, Inc. 99 Canal Center Plaza Suite 450 Alexandria VA 22314
10052 10052 1984-03-16 1983-08-16 Burke Kelly H. Stafford, Burke & Hecker, Inc. 3510 1983-08-16 Stafford, Burke & Hecker, Inc. 1006 Cameron Street   Alexandria VA 22314
10053 10053 1984-03-16 1983-08-16 Clarke Joseph J. F. Stafford, Burke & Hecker, Inc. 3510 1983-08-16 Stafford, Burke & Hecker, Inc. 1006 Cameron Street   Alexandria VA 22314
10054 10054 1984-03-16 1983-08-16 Hecker Guy L. , Jr. Stafford, Burke & Hecker, Inc. 3510 1983-08-16 Stafford, Burke & Hecker, Inc. 1006 Cameron Street   Alexandria VA 22314
10055 10055 1984-03-16 1983-08-16 Rogers Sidney D. Stafford, Burke & Hecker, Inc. 3510 1983-08-16 Stafford, Burke & Hecker, Inc. 1006 Cameron Street   Alexandria VA 22314
10056 10056 1984-03-16 1983-08-16 Stafford Thomas P. Stafford, Burke & Hecker, Inc. 3510 1983-08-16 Stafford, Burke & Hecker, Inc. 1006 Cameron Street   Alexandria VA 22314
10239 10239 1992-03-18 1985-09-04 Baldwin Joan B. United International Consultants 3701 1985-07-10 United International Consultants 1800 Diagonal Road Suite 665 Alexandria VA 22314
10384 10384 1998-03-20 1997-09-04 Livingston Laura Bain & Associates, Inc. 5205 1997-09-04 Bain & Associates, Inc. 913 King Street   Alexandria VA 22314
10515 10515 1994-03-22 1991-03-22 Moore John Oceans & International 4479 1991-02-14 Oceans & International 3-1618, 307 Yoakum Parkway   Alexandria VA 22304
10912 10912 2020-03-27 2016-07-27 Gallagher James Patrick Gallagher Group, LLC 6277 2015-02-12 Gallagher Group, LLC 2503 Hayes Street   Alexandria VA 22302
10971 10971 1999-03-28 1995-04-11 Derwinski Edward Derwinski, Edward 5011 1995-04-11 Derwinski, Edward 1800 Diagonal Road Suite 600 Alexandria VA 22314
11076 11076 2002-03-29 1993-11-26 Hingeley Anne Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
11165 11165 1993-03-30 1993-03-30 Greener Bill Smith & Harroff, Inc. 4765 1993-02-09 Smith & Harroff, Inc. 11 Canal Center Plaza Suite 104 Alexandria VA 22314
11166 11166 1993-03-30 1993-03-30 Hannaford Donald R. Smith & Harroff, Inc. 4765 1993-02-09 Smith & Harroff, Inc. 11 Canal Center Plaza Suite 104 Alexandria VA 22314
11167 11167 1993-03-30 1993-03-30 Smith J. Brian Smith & Harroff, Inc. 4765 1993-02-09 Smith & Harroff, Inc. 11 Canal Center Plaza Suite 104 Alexandria VA 22314
11626 11626 1990-03-31 1985-07-10 Hathaway Michael D. United International Consultants 3701 1985-07-10 United International Consultants 1800 Diagonal Road Suite 665 Alexandria VA 22314
11791 11791 1998-03-31 1997-09-04 Bain Charles Jackson Bain & Associates, Inc. 5205 1997-09-04 Bain & Associates, Inc. 913 King Street   Alexandria VA 22314
11792 11792 1998-03-31 1997-09-04 Bain Sandra Kyle Bain & Associates, Inc. 5205 1997-09-04 Bain & Associates, Inc. 913 King Street   Alexandria VA 22314
11832 11832 2000-03-31 1998-03-03 Davis Richard H. Davis Manafort & Freedman, Inc. 5240 1998-03-03 Davis Manafort & Freedman, Inc. 211 North Union Street Suite 250 Alexandria VA 22314
11833 11833 2000-03-31 1998-03-03 Manafort Paul J. Davis Manafort & Freedman, Inc. 5240 1998-03-03 Davis Manafort & Freedman, Inc. 211 North Union Street Suite 250 Alexandria VA 22314
11834 11834 2000-03-31 1998-03-03 McKone Timothy Davis Manafort & Freedman, Inc. 5240 1998-03-03 Davis Manafort & Freedman, Inc. 211 North Union Street Suite 250 Alexandria VA 22314
12199 12199 2017-03-31 2015-03-17 Heisler Rebecca Targeted Victory, LLC 6281 2015-03-17 Targeted Victory, LLC 1033 North Fairfax Street Suite 400 Alexandria VA 22314
12200 12200 2017-03-31 2015-03-17 Packer Spencer Targeted Victory, LLC 6281 2015-03-17 Targeted Victory, LLC 1033 North Fairfax Street Suite 400 Alexandria VA 22314
12221 12221 2018-03-31 2018-02-14 Chwat John Chwat, John 6525 2018-02-14 Chwat, John 1423 Powhatan Street Suite 1 Alexandria VA 22314
12448 12448 1984-04-01 1983-10-28 Butler Gordon R. Justice International 3534 1983-10-28 Justice International 4660 Kenmore Avenue Suite 1018 Alexandria VA 22304
12449 12449 1984-04-01 1983-10-28 Russell Michael J. Justice International 3534 1983-10-28 Justice International 4660 Kenmore Avenue Suite 1018 Alexandria VA 22304
12590 12590 2019-04-01 2018-11-05 Courville Cindy Courville Consultants, LLC 6606 2018-11-05 Courville Consultants, LLC 277 S. Pickett Street Unit 402 Alexandria VA 22304
12681 12681 1985-04-03 1983-10-28 Cambridge-Christner David Justice International 3534 1983-10-28 Justice International 4660 Kenmore Avenue Suite 1018 Alexandria VA 22304
12682 12682 1985-04-03 1983-10-28 Cherry M. Morgan Justice International 3534 1983-10-28 Justice International 4660 Kenmore Avenue Suite 1018 Alexandria VA 22304
12683 12683 1985-04-03 1983-10-28 Puglisi Robert M. Justice International 3534 1983-10-28 Justice International 4660 Kenmore Avenue Suite 1018 Alexandria VA 22304
12782 12782 1990-04-05 1986-12-03 Thompson Richard K. United International Consultants 3701 1985-07-10 United International Consultants 1800 Diagonal Road Suite 665 Alexandria VA 22314
13085 13085 1991-04-10 1987-02-02 Levinson K. Riva NM International, Inc. 3927 1987-01-12 NM International, Inc. 211 North Union Street Suite 200 Alexandria VA 22314
13086 13086 1991-04-10 1987-02-02 Panuzio Nicholas A. NAP International, Inc. 3926 1987-01-12 NAP International, Inc. 211 North Union Street Suite 200 Alexandria VA 22314
13087 13087 1991-04-10 1987-02-02 Roberts Robin D. NM International, Inc. 3927 1987-01-12 NM International, Inc. 211 North Union Street Suite 200 Alexandria VA 22314
13088 13088 1991-04-10 1987-08-19 Levinson K. Riva NAP International, Inc. 3926 1987-01-12 NAP International, Inc. 211 North Union Street Suite 200 Alexandria VA 22314
14005 14005 2003-04-23 1996-08-07 Allison B. Elsa Pierson & Burnett, L.L.P. 5127 1996-08-07 Pierson & Burnett, L.L.P. 517 South Washington Street   Alexandria VA 22314-4143
14006 14006 2003-04-23 1996-08-07 Burnett Dennis James Pierson & Burnett, L.L.P. 5127 1996-08-07 Pierson & Burnett, L.L.P. 517 South Washington Street   Alexandria VA 22314-4143
14560 14560 1985-04-30 1984-10-25 Kirkpatrick Kenneth A. Stafford, Burke & Hecker, Inc. 3623 1984-10-25 Stafford, Burke & Hecker, Inc. 1006 Cameron Street   Alexandria VA 22314
14697 14697 1996-04-30 1994-04-15 Locigno Paul R. Rollins International, Ltd. 4908 1994-04-15 Rollins International, Ltd. 510 King Street Suite 302 Alexandria VA 22314
14698 14698 1996-04-30 1994-04-15 Rollins Edward J. Rollins International, Ltd. 4908 1994-04-15 Rollins International, Ltd. 510 King Street Suite 302 Alexandria VA 22314
14699 14699 1996-04-30 1994-04-15 Youssefiani Mehrdad (Marty) Rollins International, Ltd. 4908 1994-04-15 Rollins International, Ltd. 510 King Street Suite 302 Alexandria VA 22314
14723 14723 1997-04-30 1997-04-16 Brady Patrick B. Davis, Manafort & Freedman 5173 1997-04-16 Davis, Manafort & Freedman 211 North Union Street Suite 250 Alexandria VA 22314
14724 14724 1997-04-30 1997-04-16 Davis Richard Davis, Manafort & Freedman 5173 1997-04-16 Davis, Manafort & Freedman 211 North Union Street Suite 250 Alexandria VA 22314
14725 14725 1997-04-30 1997-04-16 Freedman Matthew Davis, Manafort & Freedman 5173 1997-04-16 Davis, Manafort & Freedman 211 North Union Street Suite 250 Alexandria VA 22314
14726 14726 1997-04-30 1997-04-16 Manafort Paul J. Davis, Manafort & Freedman 5173 1997-04-16 Davis, Manafort & Freedman 211 North Union Street Suite 250 Alexandria VA 22314
14914 14914 2004-04-30 1996-07-31 Schultz Valerie Anne Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
14966 14966 2008-04-30 2008-04-15 Morris Frederick Smith & Harroff, Inc. 5862 2008-04-15 Smith & Harroff, Inc. 99 Canal Center Plaza #310 Alexandria VA 22314

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 355.341ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history