FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where City = "Washington", Registration_Number = 5320 and State = "DC" sorted by Short_Form_First_Name
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- DC · 8 ✖
Registration_Number 1
- Carmen Group, Inc. · 8 ✖
Registrant_Name 1
City 1
- Washington · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5229 | 5229 | 2001-01-31 | 2000-02-29 | Strow | Christopher James Reid | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5238 | 5238 | 2001-01-31 | 1999-07-21 | Carmen | Gerald P. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5241 | 5241 | 2001-01-31 | 1999-08-04 | Stevens, Jr. | Jack R. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
3629 | 3629 | 2001-01-12 | 2000-08-31 | Fox | James Edward | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
21364 | 21364 | 2000-06-30 | 1999-08-18 | Hannaford | Peter D. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5808 | 5808 | 2000-02-01 | 1999-09-24 | Burkett | Robert L. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5248 | 5248 | 2001-01-31 | 1999-09-24 | Adesnik | Ryan M. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
26756 | 26756 | 2000-08-15 | 1999-07-21 | Barton | Trent A. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
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]) );