FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "Ervin"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_2, Zip, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
344 | 344 | 2016-02-10 | Ervin | Clark Kent | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | ||
8460 | 8460 | 1992-02-29 | 1991-11-29 | Ervin | James L. | ASL International, Inc. 4598 | 1991-11-29 | ASL International, Inc. | 1133 Connecticut Avenue, N.W. | Suite 700 | Washington | DC | 20036 |
9582 | 9582 | 2004-03-10 | 2003-07-24 | Ervin | Roger M. | Global Market Solutions, Inc. 5568 | 2003-07-24 | Global Market Solutions, Inc. | 1055 Thomas Jefferson Street, N.W. | Suite 300 | Washington | DC | 20007 |
17496 | 17496 | 2003-05-30 | 2003-03-21 | Ervin | Roger | Foley & Lardner 5546 | 2003-03-21 | Foley & Lardner | 150 East Gilman Street | Madison | WI | 53703-1441 | |
17916 | 17916 | 1999-05-31 | 1998-03-04 | Ervin | Roger M. | C/R International, L.L.C. 5117 | 1996-07-02 | C/R International, L.L.C. | 1730 Rhode Island Avenue, NW | Suite 207 | Washington | DC | 20036 |
20528 | 20528 | 1990-06-29 | 1990-01-10 | Ervin | James Larance | Edwards, Jack 3958 | 1987-04-09 | Edwards, Jack | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
20535 | 20535 | 1990-06-29 | 1990-06-29 | Ervin | James Lawrence | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
29765 | 29765 | 2004-09-14 | 2004-09-29 | Ervin | Roger M. | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | 1133 21st Street, NW | Suite 405 | Washington | DC | 20036 |
31288 | 31288 | 2002-09-30 | 2002-02-25 | Ervin | Roger M. | Global Market Solutions 5475 | 2002-02-25 | Global Market Solutions | 4711 Albemarle Street, N.W. | Washington | DC | 20016 | |
38747 | 38747 | 1995-12-19 | 1989-09-26 | Ervin | James Lawrence | Ervin Technical Associates, Inc. 4296 | 1989-09-26 | Ervin Technical Associates, Inc. | 4347 First Street, S.E. | Suite 300 | Washington | DC | 20003 |
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]) );