FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Short_Form_Termination_Date" is on date 2000-06-16
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19688 | 19688 | 2000-06-16 | 1992-01-31 | Simpson | Robert Ivor | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
19689 | 19689 | 2000-06-16 | 1992-01-31 | Singleton | Claire T. | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
19690 | 19690 | 2000-06-16 | 1994-04-22 | Evans | David Morris | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
19691 | 19691 | 2000-06-16 | 1999-06-29 | Dzwill | Eileen | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
19692 | 19692 | 2000-06-16 | 1996-09-19 | Wilson | Christopher S. | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 |
19693 | 19693 | 2000-06-16 | 1993-12-13 | Rowlands | Peter Robert | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
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]) );