FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where Short_Form_Date = "2017-01-30" and Zip = 20006
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Registration_Date, Address_1, Address_2, Short_Form_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
240 | 240 | 2017-01-30 | Tucker | James | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | ||
8303 | 8303 | 2017-02-28 | 2017-01-30 | Thomas | Matthew | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | 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 |
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]) );