FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
33 rows where "Short_Form_Termination_Date" is on date 2006-05-31 sorted by Registration_Date
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2
Registration_Number 9
- Hill and Knowlton Strategies, LLC 10
- Steptoe & Johnson, L.L.P. 6
- Ketchum Washington 6
- International Group of P&I Clubs 4
- Russo Marsh & Rogers 3
- Saudi Refining, Inc. 1
- Watts Partners (J.C. Watts Companies) 1
- Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 1
- Carmen Group Incorporated 1
Registration_Date (date) 9 ✖
- 1981-11-10 10
- 1987-05-08 6
- 2005-11-02 6
- 1991-11-05 4
- 2005-05-10 3
- 1988-10-13 1
- 2004-08-27 1
- 2004-09-29 1
- 2006-01-17 1
Registrant_Name 9
- Hill and Knowlton Strategies, LLC 10
- Ketchum Washington 6
- Steptoe & Johnson, L.L.P. 6
- International Group of P&I Clubs 4
- Russo Marsh & Rogers 3
- Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 1
- Carmen Group Incorporated 1
- Saudi Refining, Inc. 1
- Watts Partners (J.C. Watts Companies) 1
City 5
- Washington 24
- London 4
- Sacramento 3
- Houston 1
- New York 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17992 | 17992 | 2006-05-31 | 2005-01-05 | Hartwig | Myron A. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17993 | 17993 | 2006-05-31 | 2005-01-05 | Reineke | Eugene | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17994 | 17994 | 2006-05-31 | 2005-01-05 | Tragakis | Charles | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17995 | 17995 | 2006-05-31 | 2005-01-05 | Williams | Michele | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17996 | 17996 | 2006-05-31 | 2006-01-27 | Amestoy | Erica | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17997 | 17997 | 2006-05-31 | 2006-01-27 | Goodman | Bonnie | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17998 | 17998 | 2006-05-31 | 2006-01-27 | Haas | Michael | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18001 | 18001 | 2006-05-31 | 2003-03-18 | Grannell | Nora | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18006 | 18006 | 2006-05-31 | 2005-06-10 | Aldinger | Michael | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18007 | 18007 | 2006-05-31 | 2005-06-10 | Mangum | Jeff | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18009 | 18009 | 2006-05-31 | 1997-08-11 | Moran | Mark A. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18010 | 18010 | 2006-05-31 | 2007-09-27 | Columbus | R. Timothy | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18011 | 18011 | 2006-05-31 | 2007-09-27 | Cunningham | Richard O. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18012 | 18012 | 2006-05-31 | 2007-09-27 | Fremlin | Grace Parke | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18013 | 18013 | 2006-05-31 | 2007-09-27 | Kantor | Douglas S. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18014 | 18014 | 2006-05-31 | 2007-09-27 | Maloney | Robert | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18002 | 18002 | 2006-05-31 | 2004-04-02 | Snobar | Mazen I. | Saudi Refining, Inc. 4184 | 1988-10-13 | Saudi Refining, Inc. | One Allen Center | 500 Dallas Street | Houston | TX | 77002 |
18008 | 18008 | 2006-05-31 | 1999-06-30 | Burgess | Sara | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
18022 | 18022 | 2006-05-31 | 1991-11-05 | Watkins | D.J.L. | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
18023 | 18023 | 2006-05-31 | 2005-12-14 | Bardot | Andrew | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
18024 | 18024 | 2006-05-31 | 2005-12-14 | Groom | Alistair John | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
18015 | 18015 | 2006-05-31 | 2005-10-14 | Park | Andrew J. | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
17999 | 17999 | 2006-05-31 | 2006-01-31 | Erickson | Nels H. | Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 5647 | 2004-09-29 | Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology | Office for Economic Development | 560 Lexington Avenue, 17th Floor | New York | NY | 10022 |
18003 | 18003 | 2006-05-31 | 2005-05-10 | Lorenz | Douglas | Russo Marsh & Rogers 5682 | 2005-05-10 | Russo Marsh & Rogers | 770 L Street | # 950 | Sacramento | CA | 95814 |
18004 | 18004 | 2006-05-31 | 2005-05-10 | Russo | Salvatore B. | Russo Marsh & Rogers 5682 | 2005-05-10 | Russo Marsh & Rogers | 770 L Street | # 950 | Sacramento | CA | 95814 |
18005 | 18005 | 2006-05-31 | 2005-05-10 | Wierzbicki | Joe | Russo Marsh & Rogers 5682 | 2005-05-10 | Russo Marsh & Rogers | 770 L Street | # 950 | Sacramento | CA | 95814 |
18016 | 18016 | 2006-05-31 | 2005-11-02 | Heck | Patrick T. | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18017 | 18017 | 2006-05-31 | 2005-11-02 | Jackson III | Alfred | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18018 | 18018 | 2006-05-31 | 2005-11-02 | McCrery | Johnette Hawkins | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18019 | 18019 | 2006-05-31 | 2005-11-02 | Tindall | Zachary | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18020 | 18020 | 2006-05-31 | 2005-11-02 | Wyeth | Natalie | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18021 | 18021 | 2006-05-31 | 2005-11-02 | Zavlodaver | Tal | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18000 | 18000 | 2006-05-31 | 2006-03-03 | Outhier | William | Carmen Group Incorporated 5727 | 2006-01-17 | Carmen Group Incorporated | 1919 Pennsylvania Avenue, N.W. | Fifth Floor | Washington | DC | 20006 |
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]) );