FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "Washington" and Short_Form_Last_Name = "Johnston"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Date (date)
Registration_Number 10
- APCO Worldwide, Inc. 2
- Burson-Marsteller 1
- Bishop, Cook, Purcell & Reynolds 1
- Williams & Jensen, P.C. 1
- Miller, Canfield, Paddock & Stone, P.L.C. 1
- Livingston Group, LLC 1
- Baker Donelson Bearman Caldwell & Berkowitz, PC 1
- Carmen Group Incorporated 1
- Ogilvy Public Relations Worldwide 1
- Steptoe & Johnson, LLP 1
Registrant_Name 10
- APCO Worldwide, Inc. 2
- Baker Donelson Bearman Caldwell & Berkowitz, PC 1
- Bishop, Cook, Purcell & Reynolds 1
- Burson-Marsteller 1
- Carmen Group Incorporated 1
- Livingston Group, LLC 1
- Miller, Canfield, Paddock & Stone, P.L.C. 1
- Ogilvy Public Relations Worldwide 1
- Steptoe & Johnson, LLP 1
- Williams & Jensen, P.C. 1
State 1
- DC 11
City 1
- Washington · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5277 | 5277 | 2003-01-31 | 2002-04-22 | Johnston | J. Bennett | Livingston Group, LLC 5356 | 2000-01-31 | Livingston Group, LLC | 499 South Capitol Street S.W. | Suite 600 | Washington | DC | 20003 |
8762 | 8762 | 1986-03-01 | 1984-09-18 | Johnston | Charles R. , Jr. | Bishop, Cook, Purcell & Reynolds 3050 | 1979-08-17 | Bishop, Cook, Purcell & Reynolds | 1400 L Street, N.W. | Washington | DC | 20005-3502 | |
12042 | 12042 | 2009-03-31 | 2008-06-13 | Johnston | Hunter | Steptoe & Johnson, LLP 5848 | 2008-01-25 | Steptoe & Johnson, LLP | 1330 Connecticut Avenue, NW | Washington | DC | 20036 | |
16967 | 16967 | 1997-05-23 | 1995-04-19 | Johnston | William | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
17716 | 17716 | 1989-05-31 | 1987-01-13 | Johnston | N. Hunter | Williams & Jensen, P.C. 3112 | 1980-06-13 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | 3rd Floor | Washington | DC | 20036 |
22311 | 22311 | 2007-07-01 | 2005-03-31 | Johnston | Charles R. | Baker Donelson Bearman Caldwell & Berkowitz, PC 5678 | 2005-03-31 | Baker Donelson Bearman Caldwell & Berkowitz, PC | Lincoln Square | 555 Eleventh Street, N.W., 6th Floor | Washington | DC | 20004 |
24391 | 24391 | 2010-07-29 | 2007-05-07 | Johnston | Gregory Robert | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
26894 | 26894 | 2007-08-17 | 2008-07-08 | Johnston | Steven | Carmen Group Incorporated 5727 | 2006-01-17 | Carmen Group Incorporated | 1919 Pennsylvania Avenue, N.W. | Fifth Floor | Washington | DC | 20006 |
39413 | 39413 | 1993-12-30 | 1991-05-23 | Johnston | Charles R. , Jr. | Miller, Canfield, Paddock & Stone, P.L.C. 4524 | 1991-05-23 | Miller, Canfield, Paddock & Stone, P.L.C. | 1225 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 |
41763 | 41763 | 2011-12-31 | 2011-04-28 | Johnston | J. Bennett | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41764 | 41764 | 2011-12-31 | 2011-04-28 | Johnston | N. Hunter | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | 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]) );