FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where Short_Form_Last_Name = "Johnston"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 20
- Jamaica Progressive League, Inc. 2
- National Film Board of Canada 2
- British Information Services 2
- APCO Worldwide, Inc. 2
- Japan National Tourism Organization 1
- Government of Ontario, Canada 1
- Burson-Marsteller 1
- Scottish Enterprise 1
- Bishop, Cook, Purcell & Reynolds 1
- Williams & Jensen, P.C. 1
- GCI Group, Inc. 1
- Invest Northern Ireland 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
- Corallo Media Strategies, Inc 1
- Kivvit, LLC 1
Registrant_Name 20
- APCO Worldwide, Inc. 2
- British Information Services 2
- Jamaica Progressive League, Inc. 2
- National Film Board of Canada 2
- Baker Donelson Bearman Caldwell & Berkowitz, PC 1
- Bishop, Cook, Purcell & Reynolds 1
- Burson-Marsteller 1
- Carmen Group Incorporated 1
- Corallo Media Strategies, Inc 1
- GCI Group, Inc. 1
- Government of Ontario, Canada 1
- Invest Northern Ireland 1
- Japan National Tourism Organization 1
- Kivvit, LLC 1
- Livingston Group, LLC 1
- Miller, Canfield, Paddock & Stone, P.L.C. 1
- Ogilvy Public Relations Worldwide 1
- Scottish Enterprise 1
- Steptoe & Johnson, LLP 1
- Williams & Jensen, P.C. 1
City 8
- Washington 11
- New York 6
- Jamaica 2
- Alexandria 1
- Bannockburn 1
- Cambridge 1
- Chicago 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4412 | 4412 | 1990-01-25 | 1954-02-16 | Johnston | Lily Emily | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
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 |
7158 | 7158 | 1955-02-17 | 1949-04-27 | Johnston | Vincent Llewelyn | Jamaica Progressive League, Inc. 296 | 1945-03-12 | Jamaica Progressive League, Inc. | 15905 Hillside Avenue | 2nd Floor | Jamaica | NY | 11432 |
7824 | 7824 | 1955-02-28 | 1953-12-14 | Johnston | Thomas Low | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
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 | |
11664 | 11664 | 1992-03-31 | 1989-04-18 | Johnston | Laura K. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
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 |
19612 | 19612 | 2015-06-15 | 2018-10-19 | Johnston | Michael | Corallo Media Strategies, Inc 6602 | 2018-10-19 | Corallo Media Strategies, Inc | 520 North Washington Street | Alexandria | VA | 22314 | |
20904 | 20904 | 1976-06-30 | 1973-01-23 | Johnston | Thomas Low | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
21846 | 21846 | 2015-06-30 | 2020-08-06 | Johnston | Michael | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
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 |
24609 | 24609 | 2021-07-30 | 2008-12-18 | Johnston | Mark Andrew | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
24795 | 24795 | 1990-07-31 | 1988-04-27 | Johnston | Jean | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 |
33765 | 33765 | 1993-10-28 | 1983-04-19 | Johnston | Carolyn J. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
34296 | 34296 | 1989-10-31 | 1975-07-03 | Johnston | Vincent L. | Jamaica Progressive League, Inc. 296 | 1945-03-12 | Jamaica Progressive League, Inc. | 15905 Hillside Avenue | 2nd Floor | Jamaica | NY | 11432 |
34790 | 34790 | 1947-11-01 | 1947-09-19 | Johnston | Thomas | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
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 |
39552 | 39552 | 1956-12-31 | 1956-02-23 | Johnston | Helen Claire | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
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]) );