FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Craig"
This data as json, CSV (advanced)
Suggested facets: Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4912 | 4912 | 1963-01-31 | 1961-01-18 | Craig | Nicholas | Caribbean Tourism Organization, USA Inc. 991 | 1956-12-31 | Caribbean Tourism Organization, USA Inc. | 1321 Upland Drive | PMB: 11540 | Houston | ||
5299 | 5299 | 2003-01-31 | 2002-08-05 | Craig | Darren | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
5391 | 5391 | 2007-01-31 | 2005-09-22 | Craig | Ashley | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | 575 7th Street, N.W. | Washington | DC | 20004 | |
13516 | 13516 | 1964-04-16 | 1961-05-16 | Craig | William Laurence | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
22332 | 22332 | 2011-07-01 | 2011-05-06 | Craig | Thomas | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
29663 | 29663 | 1965-09-13 | 1965-09-13 | Craig | Glenn Horace | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | 3 Thomas Circle | Washington | DC | 20530 | |
29725 | 29725 | 1990-09-14 | 1988-01-07 | Craig | James L. , Jr. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
31121 | 31121 | 1995-09-30 | 1989-03-14 | Craig | Gregory B. | Williams & Connolly 4225 | 1989-03-14 | Williams & Connolly | Edward Bennett Williams Bldg. | 725 12th Street, N.W. | Washington | DC | 20005 |
32849 | 32849 | 1979-10-15 | 1978-12-22 | Craig | John A. | Shea & Gould 2986 | 1978-12-22 | Shea & Gould | 330 Madison Avenue | New York | NY | 10017 | |
35518 | 35518 | 1990-11-09 | 1986-06-19 | Craig | Brenda J. | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
38354 | 38354 | 1967-12-15 | 1967-02-23 | Craig | Roger P. | Prather, Seeger, Doolittle & Farmer 1815 | 1964-11-13 | Prather, Seeger, Doolittle & Farmer | 1600 M Street, N.W. | 7th Floor | Washington | DC | 20036 |
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]) );