FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Short_Form_Last_Name = "Ross" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 13
- Hill and Knowlton Strategies, LLC 2
- Arnold & Porter Kaye Scholer LLP 1
- Burson-Marsteller 1
- Metzger, Shadyac & Schwarz 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Steptoe & Johnson, L.L.P. 1
- Jefferson Group, Inc. 1
- Popham, Haik, Schnobrich & Kaufman, Ltd. 1
- BGR Government Affairs, LLC 1
- American Continental Group 1
- American Continental Group 1
- Ogilvy Public Relations Worldwide 1
- Pennsylvania Avenue Strategies Group, LLC 1
Registrant_Name 12
- American Continental Group 2
- Hill and Knowlton Strategies, LLC 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Arnold & Porter Kaye Scholer LLP 1
- BGR Government Affairs, LLC 1
- Burson-Marsteller 1
- Jefferson Group, Inc. 1
- Metzger, Shadyac & Schwarz 1
- Ogilvy Public Relations Worldwide 1
- Pennsylvania Avenue Strategies Group, LLC 1
- Popham, Haik, Schnobrich & Kaufman, Ltd. 1
- Steptoe & Johnson, L.L.P. 1
State 1
- DC · 14 ✖
City 1
- Washington 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5356 | 5356 | 2006-01-31 | 2005-07-08 | Ross | Steven G. | American Continental Group 5695 | 2005-07-08 | American Continental Group | 2099 Pennsylvania Avenue, NW | Suite 850 | Washington | DC | 20006 |
6972 | 6972 | 2009-02-15 | 2006-04-28 | Ross | Shalla | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 601 Thirteenth Street, NW | Eleventh Floor South | Washington | DC | 20005 |
8124 | 8124 | 2001-02-28 | 1998-03-26 | Ross | Jessica Burke (D.) | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
10808 | 10808 | 1990-03-26 | 1987-09-23 | Ross | Stanford G. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
15357 | 15357 | 1982-05-01 | 1980-02-26 | Ross | Yan M. | Metzger, Shadyac & Schwarz 2861 | 1978-01-25 | Metzger, Shadyac & Schwarz | 1275 K Street, N.W. | 10th Floor | Washington | DC | 20005 |
16146 | 16146 | 1994-05-12 | 1990-09-14 | Ross | Thomas B. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17044 | 17044 | 1995-05-24 | 1990-09-14 | Ross | Lorraine N. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
21153 | 21153 | 1991-06-30 | 1990-05-31 | Ross | Kenneth | Popham, Haik, Schnobrich & Kaufman, Ltd. 4247 | 1989-04-28 | Popham, Haik, Schnobrich & Kaufman, Ltd. | 1300 I Street, N.W. | Suite 500 East | Washington | DC | 20005 |
21902 | 21902 | 2018-06-30 | 2007-06-18 | Ross | Steven R. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
24766 | 24766 | 1988-07-31 | 1988-05-11 | Ross | S. Beth | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | 1341 G Street, N.W. | Suite 1100 | Washington | DC | 20005 |
26773 | 26773 | 2007-08-15 | 2007-05-14 | Ross | Steven G. | Pennsylvania Avenue Strategies Group, LLC 5811 | 2007-05-14 | Pennsylvania Avenue Strategies Group, LLC | 900 19th Street, NW | Suite 800 | Washington | DC | 20006 |
36214 | 36214 | 1990-11-22 | 1989-03-28 | Ross | Kelly | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
41341 | 41341 | 2003-12-31 | 2002-12-19 | Ross | Steven G. | American Continental Group 5536 | 2002-12-19 | American Continental Group | 2099 Pennsylvania Avenue, N.W. | Suite 850 | Washington | DC | 20006 |
41668 | 41668 | 2009-12-31 | 2008-07-01 | Ross | Lisa Osborne | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 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]) );