List of all short form registrants (active and terminated)

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

94 rows where Registration_Number = 6227

View and edit SQL

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

State

Registration_Number

  • 6227 · 94

Registrant_Name

City

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
278   2020-02-04 Browne Sabrina N. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
279   2020-02-04 Khouri Nonna 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
842   2020-04-30 Rice Rebecca 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
843   2020-04-30 Wyldeck Adam 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
932   2020-05-20 Pevtsov Emil 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
1078   2019-06-12 Estevez Michael 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
1079   2019-06-12 Foster Christian Anthony 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
1108   2014-06-23 McQuillen William 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
1173   2020-07-02 AlMaskati Mohammed Emad 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
1174   2020-07-02 Manyam Shaila 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
1175   2020-07-02 Wilson Nathaniel 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
1357   2020-08-12 Law Vivien 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
1961   2017-11-22 Ballard Matthew 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
2153   2018-12-17 Naru Stephen 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
3041 2017-01-06 2014-06-23 Levy Robin 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
3158 2019-01-08 2017-11-28 Felling Matthew 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
3612 2017-01-16 2016-05-11 Law Michael 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
4040 2020-01-24 2019-02-20 Thornton Paige 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
5515 2016-02-01 2014-06-23 Goldburg Devorah 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
11673 2019-03-31 2019-03-20 Neal Terry 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
11676 2019-03-31 2018-04-24 Manyam Shaila 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
12594 2019-04-12 2019-04-12 Kwan Lauren 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
15046 2018-05-07 2017-11-28 Springsteen Heili 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
15204 2019-05-10 2017-11-15 Marshall Jr. William 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
15924 2020-05-20 2020-04-30 Bossung Taylor 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
17645 2018-06-01 2018-04-24 Jeavons Kathleen S. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
17648 2018-06-01 2017-11-28 Lerubino Kathryn L. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
17649 2019-06-01 2017-11-28 Doyne Karen L. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
17809 2019-06-03 2018-12-03 Katz Nati 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
18978 2016-06-21 2014-06-18 Khetarpaul Amit 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
21933 2018-07-13 2017-11-28 Connor Ryan 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
21934 2018-07-13 2017-11-28 Klasky Helaine S. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
21935 2020-07-13 2020-07-02 Feidi Nora 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
21936 2020-07-13 2020-07-02 Flanagan Margaret F. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
21937 2020-07-13 2020-07-02 Moussly Rania 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
21938 2020-07-13 2020-07-02 Nye Stephanie 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
22954 2018-07-26 2017-11-28 Lenigan Sarah 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
25073 2019-08-09 2019-06-12 Jones II Aranthan Steve 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
25392 2019-08-14 2017-01-30 Cosar Yagmur 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
28432 2018-09-14 2017-01-30 Chang Ben 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
32044 2020-10-23 2020-07-20 Bailey Ashley 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
33535 2020-11-01 2020-02-04 Beattie Geoffrey S 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
34668 2016-11-22 2014-09-19 Wegerson Paul 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
34760 2015-11-24 2014-07-16 Colangelo Lisa Cotter 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
34761 2020-11-24 2020-02-04 Lagana Susan 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
35466 2014-11-30 2014-06-23 Crawford Mary 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
37171 2019-12-20 2019-02-20 Smith Gerard 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40388 2017-12-31 2017-01-30 Allison Steven 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40389 2017-12-31 2017-01-30 Avinger Katie 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40390 2017-12-31 2017-01-30 Buehler Susan 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40391 2017-12-31 2017-01-30 Chandler Carson 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40392 2017-12-31 2017-01-30 Cox Matthew 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40393 2017-12-31 2017-01-30 Cunningham David 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40394 2017-12-31 2017-01-30 Dunaway Scott 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40395 2017-12-31 2017-01-30 Ert Lauren Van 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40396 2017-12-31 2017-01-30 Feeley Kevin A. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40397 2017-12-31 2017-01-30 Graul Mark 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40398 2017-12-31 2017-01-30 Hallaway Katie 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40399 2017-12-31 2017-01-30 Kefauver Joseph 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40400 2017-12-31 2017-01-30 Koenig Shanna 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40401 2017-12-31 2017-01-30 Martinez Natalie 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40402 2017-12-31 2017-01-30 Mason Karen 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40403 2017-12-31 2017-01-30 McMillan Kim 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40404 2017-12-31 2017-01-30 McShane Rory 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40405 2017-12-31 2017-01-30 Melton Patrick 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40406 2017-12-31 2017-01-30 Pinales Yesenia 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40407 2017-12-31 2017-01-30 Price Walter 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40408 2017-12-31 2017-01-30 Pruitt David 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40409 2017-12-31 2017-01-30 Schacht Nathan 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40410 2017-12-31 2017-01-30 Schwartz David 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40411 2017-12-31 2017-01-30 Smith Nancy 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40412 2017-12-31 2017-01-30 Thomas Travis 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40413 2017-12-31 2017-01-30 Thompson Randi 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40414 2017-12-31 2017-01-30 Torralvo Diana 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40415 2017-12-31 2017-01-30 Walch Dana 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40427 2017-12-31 2017-05-09 Brooks Jeri J. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40428 2017-12-31 2017-05-09 Callanan Erin M. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40429 2017-12-31 2017-05-09 Christman Rita Elizabeth 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40430 2017-12-31 2017-05-09 Ortega Jorge 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40431 2017-12-31 2017-05-09 Rodriguez Matthew 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40432 2017-12-31 2016-05-11 Farber Ethan 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40433 2017-12-31 2016-05-11 Gensemer Thomas 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40434 2017-12-31 2016-05-11 Posner Ralph 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40435 2017-12-31 2016-05-11 Sessums Michael 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40436 2017-12-31 2016-05-11 Vega Dagoberto 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40443 2017-12-31 2016-05-31 Dade Corey A. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40444 2017-12-31 2016-05-31 Gaines Jeremy 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40453 2017-12-31 2016-07-31 Jarnagan Stephanie 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40454 2017-12-31 2016-07-31 Miner Julie 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40455 2017-12-31 2016-07-31 Naru Stephen 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40456 2017-12-31 2016-07-31 Smith Rachel 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40457 2017-12-31 2016-07-31 Spriggs-Hernandez Cherri 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40458 2017-12-31 2016-07-31 Vega Mayra 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
40459 2017-12-31 2017-07-31 Komisarjevsky Nicholas 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006

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