FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

40 rows where City = "Vienna"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

City 1

  • Vienna · 40 ✖
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
147 147   2022-01-18 Chiimbwe Spencer K. Ambessa Solutions LLC 6962 2021-05-17 Ambessa Solutions LLC 1707 Pleasantdale Road Apartment 103 Vienna VA 22180
148 148   2022-01-18 Orth Richard Kevin Ambessa Solutions LLC 6962 2021-05-17 Ambessa Solutions LLC 1707 Pleasantdale Road Apartment 103 Vienna VA 22180
248 248   2023-01-30 Lapetina Christopher Isaiah King 7224 2023-01-30 Isaiah King 1489 Northern Neck Drive   Vienna VA 22182
672 672   2018-03-29 Diaz-Bonilla Rebecca Lumen8 Advisors, LLC 6537 2018-03-29 Lumen8 Advisors, LLC 9924 Browns Mill Road   Vienna VA 22182
2725 2725 1992-01-01 1986-12-10 Gemma Frances Griffin Griffin Communications 3913 1986-06-10 Griffin Communications 713 Park Street, S.E.   Vienna VA 22180
2872 2872 2010-01-01 2006-03-24 Osborne Jason MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
2883 2883 2010-01-01 2009-11-04 Galloway Michael MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
4323 4323 2007-01-23 2006-03-24 Harris William D. MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
11775 11775 1997-03-31 1994-09-26 Morton Ann Patricia Cable & Wireless, Inc. 4945 1994-07-11 Cable & Wireless, Inc. 8219 Leesburg Pike   Vienna VA 22182
12201 12201 2017-03-31 2006-03-24 Stewart Edward B. MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
12211 12211 2017-03-31 2006-10-30 Anderson Frank R. MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
13873 13873 1995-04-21 1994-07-11 Tievsky Charles A. Cable & Wireless, Inc. 4945 1994-07-11 Cable & Wireless, Inc. 8219 Leesburg Pike   Vienna VA 22182
15754 15754 1992-05-05 1989-03-29 Butler Carol Lynne Cable & Wireless North America, Inc. 4231 1989-03-29 Cable & Wireless North America, Inc. 1919 Gallows Road   Vienna VA 22182
15858 15858 2009-05-07 2006-03-24 McPhillips Jr. Manning MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
16326 16326 1987-05-14 1986-05-08 Lucas John A. , Jr. Institutional Development Associates, Ltd. 3828 1986-05-08 Institutional Development Associates, Ltd. 8300 Boone Boulevard Suite 500 Vienna VA 22180
16960 16960 1994-05-23 1989-03-29 Bernard Keith E. Cable & Wireless North America, Inc. 4231 1989-03-29 Cable & Wireless North America, Inc. 1919 Gallows Road   Vienna VA 22182
16961 16961 1994-05-23 1992-05-05 Vinall George Cable & Wireless North America, Inc. 4231 1989-03-29 Cable & Wireless North America, Inc. 1919 Gallows Road   Vienna VA 22182
18098 18098 2012-05-31 2009-12-02 DeKeyser D. Armand MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
18930 18930 2019-06-05 2019-06-05 Dunning Kellen Felix Interamerica Group 6687 2019-06-05 Interamerica Group 2128 Robin Way Court   Vienna VA 22182
18931 18931 2019-06-05 2019-06-05 Pierce Jerome Interamerica Group 6687 2019-06-05 Interamerica Group 2128 Robin Way Court   Vienna VA 22182
22602 22602 1991-07-05 1989-03-29 Esherick Mark Richard Cable & Wireless North America, Inc. 4231 1989-03-29 Cable & Wireless North America, Inc. 1919 Gallows Road   Vienna VA 22182
22781 22781 1995-07-08 1987-01-28 Anderson Philip W. P.W. Anderson & Partners, Inc. 3806 1986-04-04 P.W. Anderson & Partners, Inc. 8381 Old Courthouse Road Suite 140 Vienna VA 22182
22782 22782 1995-07-08 1989-07-26 Jones Roger D. P.W. Anderson & Partners, Inc. 3806 1986-04-04 P.W. Anderson & Partners, Inc. 8381 Old Courthouse Road Suite 140 Vienna VA 22182
22783 22783 1995-07-08 1988-11-14 Fichthorn Jonathan D. P.W. Anderson & Partners, Inc. 3806 1986-04-04 P.W. Anderson & Partners, Inc. 8381 Old Courthouse Road Suite 140 Vienna VA 22182
23303 23303 2005-07-15 2002-12-10 Lee Geun Hyung Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 5486 2002-03-15 Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 1952 Gallows Road Suite 110 Vienna VA 22182
23968 23968 2002-07-24 2002-03-15 Kim Kyung Jin Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 5486 2002-03-15 Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 1952 Gallows Road Suite 110 Vienna VA 22182
28709 28709 2022-08-31 2021-01-24 Jackson Robert Porter Jackson, Robert Porter 6915 2021-01-24 Jackson, Robert Porter 9723 Spring Ridge Lane   Vienna VA 22182-1451
28969 28969 2011-09-01 2009-12-02 O'Dwyer Wm. Ryan MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
32037 32037 2010-10-01 2010-06-25 Harris William D. MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
34365 34365 1995-10-31 1994-07-11 Bernard Keith E. Cable & Wireless, Inc. 4945 1994-07-11 Cable & Wireless, Inc. 8219 Leesburg Pike   Vienna VA 22182
34380 34380 1996-10-31 1995-10-10 Boynton Stephen S. Boynton, Stephen S. 5056 1995-10-10 Boynton, Stephen S. 1015 Moorefield Hill Grove   Vienna VA 22180
34620 34620 2011-10-31 2007-05-14 Demetriades Jr. George American Business Development Group 5810 2007-05-14 American Business Development Group 301 Maple Avenue West Suite 500 Vienna VA 22180
34621 34621 2011-10-31 2007-05-14 Frank Ayal American Business Development Group 5810 2007-05-14 American Business Development Group 301 Maple Avenue West Suite 500 Vienna VA 22180
34622 34622 2011-10-31 2007-05-14 Skipper William American Business Development Group 5810 2007-05-14 American Business Development Group 301 Maple Avenue West Suite 500 Vienna VA 22180
34660 34660 2014-10-31 2009-04-29 Edwards James R. MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
36278 36278 2004-11-23 2002-03-15 Chun Pyong Chon Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 5486 2002-03-15 Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 1952 Gallows Road Suite 110 Vienna VA 22182
36789 36789 1995-11-30 1994-07-11 Arrington Debra B. Cable & Wireless, Inc. 4945 1994-07-11 Cable & Wireless, Inc. 8219 Leesburg Pike   Vienna VA 22182
38846 38846 2008-12-20 2007-05-14 Groover Elizabeth American Business Development Group 5810 2007-05-14 American Business Development Group 301 Maple Avenue West Suite 500 Vienna VA 22180
41602 41602 2008-12-31 2006-01-19 Woo Do Hyun Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 5486 2002-03-15 Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 1952 Gallows Road Suite 110 Vienna VA 22182
41634 41634 2008-12-31 2007-11-16 Kim Myung Kwan Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 5486 2002-03-15 Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 1952 Gallows Road Suite 110 Vienna VA 22182

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])
);