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

286 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 286

City 1

  • Alexandria · 286 ✖
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
333 333   2019-02-07 Chwat John McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
521 521   2020-03-05 Goth Bashir Somaliland Mission USA, LLC 6798 2020-03-05 Somaliland Mission USA, LLC 6019 Tower Court   Alexandria VA 22304
522 522   2020-03-05 Meri Yassin Mohamed Somaliland Mission USA, LLC 6798 2020-03-05 Somaliland Mission USA, LLC 6019 Tower Court   Alexandria VA 22304
597 597   2023-03-16 Harris Marshall The Marshall Harris Group 7245 2023-03-16 The Marshall Harris Group 703 Norfolk Lane   Alexandria VA 22314
847 847   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
1087 1087   2023-05-19 Fogarty Kevin Ambrose Partners LLC 7276 2023-05-19 Ambrose Partners LLC 1803 Olive Court   Alexandria VA 22308
1616 1616   2018-08-22 Keysor David McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
1730 1730   2006-09-12 Boddie Richard F. Slocum & Boddie, PLLC 5765 2006-09-12 Slocum & Boddie, PLLC 5400 Shanee Rd. Suite 300 Alexandria VA 22312
1731 1731   2006-09-12 Slocum J. Michael Slocum & Boddie, PLLC 5765 2006-09-12 Slocum & Boddie, PLLC 5400 Shanee Rd. Suite 300 Alexandria VA 22312
2151 2151   2021-11-15 Gallagher James P. The Gallagher Group, LLC 7046 2021-11-15 The Gallagher Group, LLC 2503 Hayes Street   Alexandria VA 22302
2153 2153   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
3369 3369 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
3512 3512 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
3580 3580 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
3581 3581 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
3953 3953 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
4092 4092 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
4158 4158 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
4163 4163 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
4340 4340 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
4342 4342 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
4994 4994 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
5248 5248 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
5410 5410 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
5419 5419 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
5486 5486 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
5786 5786 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
6515 6515 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
6723 6723 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
7144 7144 2006-02-17 2001-05-29 Higdon Sarah Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
7408 7408 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
7667 7667 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
7780 7780 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
7781 7781 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
7782 7782 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
7923 7923 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
7949 7949 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
8016 8016 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
8017 8017 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
8162 8162 2006-02-28 1983-02-08 Saunders Steven R. Saunders & Company 3440 1983-02-08 Saunders & Company 1015 Duke Street   Alexandria VA 22314-3551
8174 8174 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
8175 8175 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
8188 8188 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
8189 8189 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
8191 8191 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
8304 8304 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
8305 8305 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
8766 8766 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
8767 8767 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
9213 9213 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
9368 9368 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
9369 9369 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
9605 9605 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
10010 10010 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
10011 10011 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
10012 10012 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
10013 10013 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
10014 10014 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
10197 10197 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
10342 10342 1998-03-20 1997-09-04 Livingston Laura Bain & Associates, Inc. 5205 1997-09-04 Bain & Associates, Inc. 913 King Street   Alexandria VA 22314
10473 10473 1994-03-22 1991-03-22 Moore John Oceans & International 4479 1991-02-14 Oceans & International 3-1618, 307 Yoakum Parkway   Alexandria VA 22304
10870 10870 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
10929 10929 1999-03-28 1995-04-11 Derwinski Edward Derwinski, Edward 5011 1995-04-11 Derwinski, Edward 1800 Diagonal Road Suite 600 Alexandria VA 22314
11033 11033 2002-03-29 1993-11-26 Hingeley Anne Bannerman & Associates, Inc. 3964 1987-04-28 Bannerman & Associates, Inc. 3 Wilkes Street   Alexandria VA 22314
11122 11122 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
11123 11123 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
11124 11124 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
11582 11582 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
11747 11747 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
11748 11748 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
11788 11788 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
11789 11789 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
11790 11790 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
12155 12155 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
12156 12156 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
12177 12177 2018-03-31 2018-02-14 Chwat John Chwat, John 6525 2018-02-14 Chwat, John 1423 Powhatan Street Suite 1 Alexandria VA 22314
12402 12402 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
12403 12403 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
12544 12544 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
12635 12635 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
12636 12636 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
12637 12637 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
12735 12735 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
13038 13038 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
13039 13039 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
13040 13040 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
13041 13041 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
13955 13955 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
13956 13956 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
14509 14509 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
14646 14646 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
14647 14647 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
14648 14648 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
14672 14672 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
14673 14673 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
14674 14674 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
14675 14675 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
14863 14863 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
14915 14915 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
14916 14916 2008-04-30 2008-04-15 Smith J. Brian 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 286.899ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history