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 = "Blair"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2622 | 2622 | 1984-01-01 | 1979-03-29 | Blair | William McCormick , Jr. | Surrey & Morse 2649 | 1976-01-05 | Surrey & Morse | 1250 I Street, N.W. | Washington | DC | 20005 | |
10625 | 10625 | 2001-03-23 | 2001-02-14 | Blair | Wanda | Shandwick USA, Inc. 5315 | 1999-05-11 | Shandwick USA, Inc. | 8000 Norman Center Drive | Suite 400 | Bloomington | MN | 55437 |
16604 | 16604 | 1995-05-17 | 1981-03-09 | Blair | Robert A. | Anderson, Hibey & Blair 3208 | 1981-03-09 | Anderson, Hibey & Blair | 1708 New Hampshire Ave., N.W. | Washington | DC | 20009 | |
16607 | 16607 | 1995-05-17 | 1990-05-23 | Blair | Robert A. | Anderson, Hibey & Blair 3208 | 1981-03-09 | Anderson, Hibey & Blair | 1708 New Hampshire Ave., N.W. | Washington | DC | 20009 | |
20599 | 20599 | 1944-06-30 | 1944-09-28 | Blair | Edwin Foster | Netherland-American Foundation, Inc. 229 | 1944-01-08 | Netherland-American Foundation, Inc. | 10 Rockefeller Plaza | New York | NY | ||
26865 | 26865 | 1979-08-17 | 1979-07-17 | Blair | Anita | 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 |
29595 | 29595 | 2013-09-11 | 2011-04-15 | Blair | Alexander Philip | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
30156 | 30156 | 1996-09-20 | 1995-12-18 | Blair | Robert A. | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | 1501 M Street, N.W. | Suite 700 | Washington | DC | 20005-1702 |
35595 | 35595 | 2003-11-10 | 2001-02-05 | Blair | Martin | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
39174 | 39174 | 1989-12-27 | 1989-09-12 | Blair | Michael W. | Debevoise & Plimpton 3527 | 1983-10-05 | Debevoise & Plimpton | 919 Third Avenue | New York | NY | 10022 | |
41086 | 41086 | 1998-12-31 | 1997-04-11 | Blair | Robert A. | Manatt, Phelps & Phillips 5171 | 1997-04-11 | Manatt, Phelps & Phillips | 700 12th Street, N.W. | Suite 1100 | Washington | DC | 20005 |
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]) );