FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Short_Form_Date" is on date 2022-02-15
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date)
Registration_Number 2
- BCW LLC 13
- Holland & Knight 1
Registrant_Name 2
- BCW LLC 13
- Holland & Knight 1
State 1
- DC 14
City 1
- Washington 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
397 | 397 | 2022-02-15 | O'Brien | Andrew | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
398 | 398 | 2022-02-15 | Arora | Tanvi | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
399 | 399 | 2022-02-15 | Daniel | Grace | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
400 | 400 | 2022-02-15 | Goodman | Jessica | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
401 | 401 | 2022-02-15 | Heimowitz | Michael | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
402 | 402 | 2022-02-15 | Kelly | Matthew | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
403 | 403 | 2022-02-15 | Mehta | Sarjika | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
404 | 404 | 2022-02-15 | Radick | Stephen | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
405 | 405 | 2022-02-15 | Shaw | Eliza | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
406 | 406 | 2022-02-15 | Venditti | Morgan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
407 | 407 | 2022-02-15 | Wallace | Alayna | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
408 | 408 | 2022-02-15 | Waterman | Michael | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
409 | 409 | 2022-02-15 | Watley | Shawna Francis | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
410 | 410 | 2022-02-15 | Wiescholek | Gabriela Lechin | 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]) );