FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Short_Form_Last_Name = "Knight"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 14
- Akin, Gump, Strauss, Hauer & Feld, LLP 2
- Frankfeld, Philip 1
- Milburn McCarty Associates, Inc. 1
- Shearman & Sterling 1
- British Aerospace, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- King & Spalding 1
- GCI Group, Inc. 1
- Levine & Company 1
- King & Spalding 1
- Sitrick and Company, Inc. 1
- Brunswick Group LLC 1
- NSW Government US Office Inc. 1
- Wagstaff Worldwide Public Relations, Inc. 1
Registrant_Name 13
- Akin, Gump, Strauss, Hauer & Feld, LLP 2
- King & Spalding 2
- British Aerospace, Inc. 1
- Brunswick Group LLC 1
- Frankfeld, Philip 1
- GCI Group, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Levine & Company 1
- Milburn McCarty Associates, Inc. 1
- NSW Government US Office Inc. 1
- Shearman & Sterling 1
- Sitrick and Company, Inc. 1
- Wagstaff Worldwide Public Relations, Inc. 1
City 5
- New York 6
- Washington 5
- Los Angeles 2
- Atlanta 1
- Bethesda 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1447 | 1447 | 2023-07-20 | Knight | Katherine Bodor | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | ||
1669 | 1669 | 2022-08-26 | Knight | Robin | Brunswick Group LLC 6826 | 2020-05-20 | Brunswick Group LLC | 245 Park Avenue | 14th Floor | New York | NY | 10167 | |
3315 | 3315 | 2023-01-06 | 2022-10-07 | Knight | Gary | Wagstaff Worldwide Public Relations, Inc. 7179 | 2022-10-07 | Wagstaff Worldwide Public Relations, Inc. | 5443 Fountain Avenue | Los Angeles | CA | 90029 | |
11135 | 11135 | 1988-03-30 | 1988-03-17 | Knight | Edward S. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
13153 | 13153 | 1977-04-11 | 1965-04-29 | Knight | Robert Huntington | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
14266 | 14266 | 1995-04-28 | 1991-03-08 | Knight | W. Donald , Jr. | King & Spalding 4352 | 1990-03-16 | King & Spalding | 1730 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
16510 | 16510 | 1986-05-16 | 1986-02-24 | Knight | Stephany | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17137 | 17137 | 1987-05-26 | 1986-04-10 | Knight | W. Donald , Jr. | King & Spalding 3812 | 1986-04-10 | King & Spalding | 1500 Trust Company | Atlanta | GA | 30303 | |
18044 | 18044 | 2008-05-31 | 2006-11-20 | Knight | Robert Anthony | Sitrick and Company, Inc. 5777 | 2006-11-20 | Sitrick and Company, Inc. | 1840 Century Park East | Suite 800 | Los Angeles | CA | 90067-2109 |
23924 | 23924 | 1993-07-23 | 1992-02-21 | Knight | Edward S. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
24945 | 24945 | 1999-07-31 | 1993-07-26 | Knight | Peter S. | Levine & Company 3971 | 1987-04-29 | Levine & Company | 7100 Millwood Road | Bethesda | MD | 20817 | |
26074 | 26074 | 1963-08-06 | 1962-02-19 | Knight | William James | Milburn McCarty Associates, Inc. 1514 | 1962-02-06 | Milburn McCarty Associates, Inc. | 200 Park Avenue | New York | NY | ||
27316 | 27316 | 1983-08-24 | 1976-01-06 | Knight | G.E. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27397 | 27397 | 1966-08-25 | 1963-08-01 | Knight | Arthur Louis , Jr. | Frankfeld, Philip 1482 | 1961-09-29 | Frankfeld, Philip | 747 Broadway | New York | NY | ||
30277 | 30277 | 2003-09-22 | 2003-08-08 | Knight | Chris | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
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]) );