FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
142 rows where Registration_Number = 6227 sorted by Short_Form_Date
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Registration_Date (date)
State 1
- DC 142
Registration_Number 1
- BCW LLC · 142 ✖
Registrant_Name 1
- BCW LLC 142
City 1
- Washington 142
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19990 | 19990 | 2016-06-21 | 2014-06-18 | Khetarpaul | Amit | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
1282 | 1282 | 2014-06-23 | McQuillen | William | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
3308 | 3308 | 2017-01-06 | 2014-06-23 | Levy | Robin | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
5887 | 5887 | 2016-02-01 | 2014-06-23 | Goldburg | Devorah | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
37056 | 37056 | 2014-11-30 | 2014-06-23 | Crawford | Mary | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
36329 | 36329 | 2015-11-24 | 2014-07-16 | Colangelo | Lisa Cotter | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
36236 | 36236 | 2016-11-22 | 2014-09-19 | Wegerson | Paul | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
3926 | 3926 | 2017-01-16 | 2016-05-11 | Law | Michael | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42127 | 42127 | 2017-12-31 | 2016-05-11 | Farber | Ethan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42128 | 42128 | 2017-12-31 | 2016-05-11 | Gensemer | Thomas | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42129 | 42129 | 2017-12-31 | 2016-05-11 | Posner | Ralph | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42130 | 42130 | 2017-12-31 | 2016-05-11 | Sessums | Michael | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42131 | 42131 | 2017-12-31 | 2016-05-11 | Vega | Dagoberto | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42138 | 42138 | 2017-12-31 | 2016-05-31 | Dade | Corey A. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42139 | 42139 | 2017-12-31 | 2016-05-31 | Gaines | Jeremy | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42148 | 42148 | 2017-12-31 | 2016-07-31 | Jarnagan | Stephanie | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42149 | 42149 | 2017-12-31 | 2016-07-31 | Miner | Julie | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42150 | 42150 | 2017-12-31 | 2016-07-31 | Naru | Stephen | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42151 | 42151 | 2017-12-31 | 2016-07-31 | Smith | Rachel | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42152 | 42152 | 2017-12-31 | 2016-07-31 | Spriggs-Hernandez | Cherri | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42153 | 42153 | 2017-12-31 | 2016-07-31 | Vega | Mayra | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
26654 | 26654 | 2019-08-14 | 2017-01-30 | Cosar | Yagmur | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
29779 | 29779 | 2018-09-14 | 2017-01-30 | Chang | Ben | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42083 | 42083 | 2017-12-31 | 2017-01-30 | Allison | Steven | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42084 | 42084 | 2017-12-31 | 2017-01-30 | Avinger | Katie | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42085 | 42085 | 2017-12-31 | 2017-01-30 | Buehler | Susan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42086 | 42086 | 2017-12-31 | 2017-01-30 | Chandler | Carson | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42087 | 42087 | 2017-12-31 | 2017-01-30 | Cox | Matthew | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42088 | 42088 | 2017-12-31 | 2017-01-30 | Cunningham | David | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42089 | 42089 | 2017-12-31 | 2017-01-30 | Dunaway | Scott | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42090 | 42090 | 2017-12-31 | 2017-01-30 | Ert | Lauren Van | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42091 | 42091 | 2017-12-31 | 2017-01-30 | Feeley | Kevin A. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42092 | 42092 | 2017-12-31 | 2017-01-30 | Graul | Mark | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42093 | 42093 | 2017-12-31 | 2017-01-30 | Hallaway | Katie | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42094 | 42094 | 2017-12-31 | 2017-01-30 | Kefauver | Joseph | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42095 | 42095 | 2017-12-31 | 2017-01-30 | Koenig | Shanna | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42096 | 42096 | 2017-12-31 | 2017-01-30 | Martinez | Natalie | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42097 | 42097 | 2017-12-31 | 2017-01-30 | Mason | Karen | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42098 | 42098 | 2017-12-31 | 2017-01-30 | McMillan | Kim | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42099 | 42099 | 2017-12-31 | 2017-01-30 | McShane | Rory | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42100 | 42100 | 2017-12-31 | 2017-01-30 | Melton | Patrick | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42101 | 42101 | 2017-12-31 | 2017-01-30 | Pinales | Yesenia | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42102 | 42102 | 2017-12-31 | 2017-01-30 | Price | Walter | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42103 | 42103 | 2017-12-31 | 2017-01-30 | Pruitt | David | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42104 | 42104 | 2017-12-31 | 2017-01-30 | Schacht | Nathan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42105 | 42105 | 2017-12-31 | 2017-01-30 | Schwartz | David | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42106 | 42106 | 2017-12-31 | 2017-01-30 | Smith | Nancy | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42107 | 42107 | 2017-12-31 | 2017-01-30 | Thomas | Travis | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42108 | 42108 | 2017-12-31 | 2017-01-30 | Thompson | Randi | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42109 | 42109 | 2017-12-31 | 2017-01-30 | Torralvo | Diana | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42110 | 42110 | 2017-12-31 | 2017-01-30 | Walch | Dana | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42122 | 42122 | 2017-12-31 | 2017-05-09 | Brooks | Jeri J. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42123 | 42123 | 2017-12-31 | 2017-05-09 | Callanan | Erin M. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42124 | 42124 | 2017-12-31 | 2017-05-09 | Christman | Rita Elizabeth | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42125 | 42125 | 2017-12-31 | 2017-05-09 | Ortega | Jorge | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42126 | 42126 | 2017-12-31 | 2017-05-09 | Rodriguez | Matthew | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
42154 | 42154 | 2017-12-31 | 2017-07-31 | Komisarjevsky | Nicholas | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
16041 | 16041 | 2019-05-10 | 2017-11-15 | Marshall Jr. | William | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
2207 | 2207 | 2017-11-22 | Ballard | Matthew | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
3459 | 3459 | 2019-01-08 | 2017-11-28 | Felling | Matthew | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
15872 | 15872 | 2018-05-07 | 2017-11-28 | Springsteen | Heili | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
18592 | 18592 | 2018-06-01 | 2017-11-28 | Lerubino | Kathryn L. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
18594 | 18594 | 2019-06-01 | 2017-11-28 | Doyne | Karen L. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
23080 | 23080 | 2018-07-13 | 2017-11-28 | Connor | Ryan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
23081 | 23081 | 2018-07-13 | 2017-11-28 | Klasky | Helaine S. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
24116 | 24116 | 2018-07-26 | 2017-11-28 | Lenigan | Sarah | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
12240 | 12240 | 2019-03-31 | 2018-04-24 | Manyam | Shaila | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
18589 | 18589 | 2018-06-01 | 2018-04-24 | Jeavons | Kathleen S. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
18777 | 18777 | 2019-06-03 | 2018-12-03 | Katz | Nati | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
2419 | 2419 | 2018-12-17 | Naru | Stephen | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
4370 | 4370 | 2020-01-24 | 2019-02-20 | Thornton | Paige | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
38854 | 38854 | 2019-12-20 | 2019-02-20 | Smith | Gerard | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
12237 | 12237 | 2019-03-31 | 2019-03-20 | Neal | Terry | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
13260 | 13260 | 2019-04-12 | 2019-04-12 | Kwan | Lauren | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
1230 | 1230 | 2019-06-12 | Foster | Christian Anthony | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
26326 | 26326 | 2019-08-09 | 2019-06-12 | Jones II | Aranthan Steve | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
27506 | 27506 | 2022-08-26 | 2019-06-12 | Estevez | Michael | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
305 | 305 | 2020-02-04 | Browne | Sabrina N. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
30104 | 30104 | 2022-09-19 | 2020-02-04 | Khouri | Nonna | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
35046 | 35046 | 2020-11-01 | 2020-02-04 | Beattie | Geoffrey S | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
36330 | 36330 | 2020-11-24 | 2020-02-04 | Lagana | Susan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
936 | 936 | 2020-04-30 | Rice | Rebecca | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
16791 | 16791 | 2020-05-20 | 2020-04-30 | Bossung | Taylor | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
27825 | 27825 | 2021-08-30 | 2020-04-30 | Wyldeck | Adam | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
15773 | 15773 | 2023-05-05 | 2020-05-20 | Pevtsov | Emil | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
1350 | 1350 | 2020-07-02 | AlMaskati | Mohammed Emad | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
1351 | 1351 | 2020-07-02 | Manyam | Shaila | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
1352 | 1352 | 2020-07-02 | Wilson | Nathaniel | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
23082 | 23082 | 2020-07-13 | 2020-07-02 | Feidi | Nora | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
23083 | 23083 | 2020-07-13 | 2020-07-02 | Flanagan | Margaret F. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
23084 | 23084 | 2020-07-13 | 2020-07-02 | Moussly | Rania | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
23085 | 23085 | 2020-07-13 | 2020-07-02 | Nye | Stephanie | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
33523 | 33523 | 2020-10-23 | 2020-07-20 | Bailey | Ashley | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
3028 | 3028 | 2023-01-01 | 2020-08-12 | Law | Vivien | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
847 | 847 | 2021-04-21 | Corner | Gwendolyn Marie Abigail | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
19031 | 19031 | 2022-06-07 | 2021-04-26 | Leung | Yee Ching Angelina | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
1047 | 1047 | 2021-05-18 | Doherty | Dan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
15570 | 15570 | 2023-05-01 | 2021-07-06 | Bartkus | Dom | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
1405 | 1405 | 2021-07-14 | Lenahan | Joseph | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
27545 | 27545 | 2021-08-27 | 2021-08-03 | Mcquillen | William | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );