FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Short_Form_Date" is on date 2003-10-28
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6964 | 6964 | 2005-02-15 | 2003-10-28 | Manson | Joseph L. III | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8234 | 8234 | 2009-02-28 | 2003-10-28 | Kraker | Marcus A. | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
12649 | 12649 | 2007-04-02 | 2003-10-28 | Christy | David S. Jr. | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
12650 | 12650 | 2007-04-02 | 2003-10-28 | Parlin | C. Christopher | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
18060 | 18060 | 2009-05-31 | 2003-10-28 | Rickhoff | Hans Christopher | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
31394 | 31394 | 2007-09-30 | 2003-10-28 | Chua | Chee Kiong | Malaysian Investment Development Authority 5350 | 1999-12-10 | Malaysian Investment Development Authority | 226 Airport Parkway | Suite 480 | San Jose | CA | 95110 |
34522 | 34522 | 2004-10-31 | 2003-10-28 | Illingworth | Montieth | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
34979 | 34979 | 2002-11-01 | 2003-10-28 | Christie | Katherine M. | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | 1925 K Street, N.W. | Suite 450 | Washington | DC | 20006 |
34980 | 34980 | 2002-11-01 | 2003-10-28 | Herrera-Davila | Nina | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | 1925 K Street, N.W. | Suite 450 | Washington | DC | 20006 |
41463 | 41463 | 2005-12-31 | 2003-10-28 | Bakar | Mohamad Ismail Abu | Malaysian Industrial Development Authority 2331 | 1972-04-17 | Malaysian Industrial Development Authority | 875 North Michigan Avenue | Suite 1810 | Chicago | IL | 60611 |
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]) );