FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Short_Form_Last_Name = "Booth"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5508 | 5508 | 2016-01-31 | 2015-12-17 | Booth | Taylor | New Partners Consulting, Inc. 6330 | 2015-12-17 | New Partners Consulting, Inc. | 1250 I Street, NW | Suite 200 | Washington | DC | 20005 |
7880 | 7880 | 1976-02-28 | 1975-09-09 | Booth | Margaret | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11587 | 11587 | 1988-03-31 | 1984-08-29 | Booth | Dean | Kilpatrick & Cody 3610 | 1984-08-29 | Kilpatrick & Cody | 2501 M Street, N.W. | Suite 500 | Washington | DC | 20037 |
15386 | 15386 | 1987-05-01 | 1986-09-21 | Booth | Alyse L. | Friends of Marc Bazin, Inc. 3885 | 1986-09-21 | Friends of Marc Bazin, Inc. | C/O A.L. Booth | 334 West 46th Street, Suite 2 | New York | NY | 10036 |
37394 | 37394 | 1988-12-01 | 1985-03-19 | Booth | Deborah L. | Spring O'Brien & Company, Inc. 3661 | 1985-03-19 | Spring O'Brien & Company, Inc. | 50 West 23rd Street | 11th Floor | New York | NY | 10010-1481 |
39692 | 39692 | 1960-12-31 | 1960-08-12 | Booth | George Warren | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 |
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]) );