FARA_All_Registrants

List of all registrant data (active and terminated)

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

36 rows where City = "McLean"

View and edit SQL

Suggested facets: Address_2, Zip, Registration_Date (date), Termination_Date (date)

State

City

  • McLean · 36
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
1963 1966-02-16 1966-08-30 Pace, Thomas A.   1922 Franklin Avenue   McLean VA 22101
2516 1974-06-06 1976-03-18 Bell, Linda Jane   6516 Ridge Street   McLean VA 22101
2526 1974-07-08   Beef + Lamb New Zealand, Ltd.   6841 Elm Street #7401 McLean VA 22106
2747 1977-01-19 1978-10-13 ARRCO International, Ltd.   6723 Whittier Avenue   McLean VA 22101
3089 1980-02-15 1981-02-24 Davis, Gillenwater, Lynch & Doane   6801 Whittier Avenue   McLean VA 22101
3124 1980-07-28 1982-11-09 KBS Associates   8455 Brook Road   McLean VA 22102
3350 1982-04-02 1985-10-02 Sedam & Herge, a Professional Corporation   8300 Greensboro Drive Suite 1100 McLean VA 22102
3487 1983-06-17 1990-08-31 Wachholz, Douglas P.   7002 Bright Avenue   McLean VA 22101
3568 1984-03-13 1991-03-13 Japan Tobacco, Inc.   1207 Pine Hill Road   McLean VA 22101
3674 1985-05-02 1987-09-23 A.I.H. International, Inc.   7005 Hector Road   McLean VA 22101
3798 1986-03-18 1987-05-08 Rainbolt II, John Vernon   1355 Lancia Drive   McLean VA 22102
4284 1989-09-01 1993-05-28 Schiappa, Gerard F.   2010 Corporate Ridge Drive Suite 700 McLean VA 22102-7838
4367 1990-04-18 2006-04-30 Gibbons & Company, Inc.   P.O. Box 1037   McLean VA 22101-1037
4385 1990-06-12 1991-11-21 Stackig, Sanderson & White   7680 Old Springhouse Road   McLean VA 22102
4403 1990-07-19 1991-12-31 Lindstrom, Talbot Shaw   6627 Old Chesterbrook Road   McLean VA 22101
4476 1991-02-28 1992-02-28 Cahill, Harry Amory   1240 Daleview Drive   McLean VA 22102
4489 1991-03-19 1997-08-30 Indo-American Chamber of Commerce   1240 Daleview Drive   McLean VA 22102
4751 1993-01-13 2010-01-31 Veve, Michael E.   8300 Greensboro Drive Suite 800 McLean VA 22102
4999 1995-03-03 1997-09-30 Decision Management, Inc.   2010 Corporate Ridge 7th Floor McLean VA 22102
5046 1995-09-15 1995-09-30 Sack & Associates, Inc.   8300 Greensboro Drive Suite 1080 McLean VA 22102
5111 1996-06-10 1998-06-30 Fein, Bruce   6515 Sunny Hill Court   McLean VA 22101
5132 1996-10-03 1997-04-01 Murphy, Pintak, Gautier & Hudome Agency, Inc.   7601 Lewinsville Road Suite 320 McLean VA 22102
5196 1997-07-22 2006-10-31 Shemdin, Nijyar H.   1420 Spring Hill Road Suite 600 McLean VA 22102-3030
5263 1998-06-26 1999-06-30 Fein, Bruce   6515 Sunny Hill Court   McLean VA 22101
5358 2000-02-14 2009-01-01 Solarz Associates   1120 Bellview Road   McLean VA 22102
5439 2001-06-01 2002-06-30 Alliance Strategies, L.L.C.   P.O. Box 11387   McLean VA 22102
5445 2001-07-09 2002-06-30 Trans Pacific Partners, LLC   1204 Old Stable Road   McLean VA 22102
5661 2004-11-29 2005-05-01 Western Strategy Group   6711 Corner Lane   McLean VA 2219103823
5900 2008-12-16 2009-12-31 Jacobs, Barry   Chartwell Consultancy, LLC 1206 Old Stable Road McLean VA 22102
5977 2010-03-04 2010-04-16 Akbar, Mir H.   8380 Greensboro Drive Apt. 509 McLean VA 22102
5984 2010-04-14 2011-02-28 Global Footwear Partnerships, LLC   8506 Sparger Street   McLean VA 22102
6255 2014-09-29 2015-05-20 Chartwell Consultancy, LLC   1206 Old Stable Road   McLean VA 22102
6276 2015-02-08 2017-01-01 TwinLogic Strategies, LLP   6313 Evermay Drive   McLean VA 22101
6430 2017-05-12 2017-05-19 Kim, Nancy Myung-Jin   Lange, Thomas & Associates, LLP 6849 Old Dominion Drive, Suite 225 McLean VA 22101
6656 2019-04-08   Jacobs Global Trade & Compliance LLC   4134 N. River Street   McLean VA 22101
6843 2020-06-30 2020-06-30 Booz Allen Hamilton Inc.   8283 Greensboro Drive   McLean VA 22102

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_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 · Query took 56.43ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history