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 = "Griffin"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date)
Registration_Number 10
- Hill and Knowlton Strategies, LLC 2
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Prio Socarras, Carlos 1
- Dawson, Quinn, Riddell, Taylor & Davis 1
- McCann-Erickson, Inc. 1
- Burson-Marsteller 1
- Wald, Harkrader & Ross 1
- Morgan, Lewis & Bockius, L.L.P. 1
- Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. 1
- Shandwick Public Affairs, Inc. 1
Registrant_Name 10
- Hill and Knowlton Strategies, LLC 2
- Burson-Marsteller 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Dawson, Quinn, Riddell, Taylor & Davis 1
- Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. 1
- McCann-Erickson, Inc. 1
- Morgan, Lewis & Bockius, L.L.P. 1
- Prio Socarras, Carlos 1
- Shandwick Public Affairs, Inc. 1
- Wald, Harkrader & Ross 1
City 3
- Washington 9
- Miami 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3180 | 3180 | 1994-01-04 | 1993-02-12 | Griffin | Patrick J. | Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. 4766 | 1993-02-12 | Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. | 1300 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
3921 | 3921 | 2010-01-16 | 2008-12-23 | Griffin | Megan | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
7395 | 7395 | 2000-02-22 | 1986-03-12 | Griffin | Joseph P. | Morgan, Lewis & Bockius, L.L.P. 3794 | 1986-03-12 | Morgan, Lewis & Bockius, L.L.P. | 1111 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
10425 | 10425 | 1971-03-21 | 1962-06-01 | Griffin | Jerry Noel | Dawson, Quinn, Riddell, Taylor & Davis 1547 | 1962-06-01 | Dawson, Quinn, Riddell, Taylor & Davis | 723 Washington Building | Washington | DC | 20005 | |
11843 | 11843 | 2000-03-31 | 1998-10-19 | Griffin | Maire | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
18315 | 18315 | 1955-06-01 | 1954-08-09 | Griffin | John David | Prio Socarras, Carlos 800 | 1953-12-01 | Prio Socarras, Carlos | 2100 South Miami Avenue | Miami | FL | ||
20294 | 20294 | 1987-06-26 | 1981-05-19 | Griffin | Joseph P. | Wald, Harkrader & Ross 3241 | 1981-05-10 | Wald, Harkrader & Ross | 1300 - 19th Street, N.W. | Washington | DC | 20036 | |
21326 | 21326 | 1999-06-30 | 1996-03-21 | Griffin | Kevin A. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
27928 | 27928 | 1977-08-31 | 1970-01-06 | Griffin | Geraldine | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
38023 | 38023 | 1986-12-10 | 1985-03-18 | Griffin | Patrick J. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
41274 | 41274 | 2002-12-31 | 1990-08-31 | Griffin | John G. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd 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]) );