FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "Washington", Registration_Number = 5932 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Short_Form_Termination_Date (date)
State 1
- DC · 11 ✖
Registration_Number 1
- Raben Group, LLC · 11 ✖
Registrant_Name 1
City 1
- Washington · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12238 | 12238 | 2019-03-31 | 2009-04-24 | Huffman | Katharine | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
12239 | 12239 | 2019-03-31 | 2009-04-24 | Raben | Robert | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
12242 | 12242 | 2019-03-31 | 2016-04-26 | Soto | Eduardo | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
12245 | 12245 | 2019-03-31 | 2016-06-22 | Arciniega | Laura | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
12246 | 12246 | 2019-03-31 | 2016-06-22 | Espinosa | Norma Nereida | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
12247 | 12247 | 2019-03-31 | 2016-06-22 | Gonzalez | Larry | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
12248 | 12248 | 2019-03-31 | 2016-06-22 | Rodriguez | Estuardo | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
25891 | 25891 | 2009-08-03 | 2009-04-24 | Collinson | Eleanor | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
28966 | 28966 | 2010-09-01 | 2010-06-01 | First | Patricia | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
35240 | 35240 | 2011-11-04 | 2009-04-24 | Goulart | Kimberly | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
35244 | 35244 | 2015-11-04 | 2012-01-09 | Goulart | Kimberly | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 1341 G Street NW | Floor 5 | Washington | DC | 20005 |
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]) );