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 = "Russell"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Zip, Short_Form_Termination_Date (date)
Registration_Number 22
- British Information Services 2
- Oceans International Corporation 2
- Pan-American Coffee Bureau 1
- U.S. Office of the British Broadcasting Corporation 1
- Tanaka, Michele N. 1
- DDB Worldwide Communications Group, Inc. 1
- Hong Kong Tourism Board 1
- Squire Patton Boggs, LLP 1
- Bahamas Tourist Office 1
- Walters, Costanzo, Miller & Russell 1
- Justice International 1
- Henry J. Kaufman & Associates, Inc. 1
- William Russell & Associates, Inc. 1
- Porter/Novelli 1
- Lloyd's of London Market Representatives 1
- OIC Services, Inc. 1
- Mullen 1
- Venezuela Information Office 1
- Bryan Cave, LLP 1
- Mercury Public Affairs, LLC 1
- Bryan Cave, LLP 1
- Bryan Cave Leighton Paisner LLP 1
Registrant_Name 21
- British Information Services 2
- Bryan Cave, LLP 2
- Oceans International Corporation 2
- Bahamas Tourist Office 1
- Bryan Cave Leighton Paisner LLP 1
- DDB Worldwide Communications Group, Inc. 1
- Henry J. Kaufman & Associates, Inc. 1
- Hong Kong Tourism Board 1
- Justice International 1
- Lloyd's of London Market Representatives 1
- Mercury Public Affairs, LLC 1
- Mullen 1
- OIC Services, Inc. 1
- Pan-American Coffee Bureau 1
- Porter/Novelli 1
- Squire Patton Boggs, LLP 1
- Tanaka, Michele N. 1
- U.S. Office of the British Broadcasting Corporation 1
- Venezuela Information Office 1
- Walters, Costanzo, Miller & Russell 1
- William Russell & Associates, Inc. 1
City 10
- Washington 9
- New York 5
- Houston 3
- Alexandria 1
- London 1
- Los Angeles 1
- Miami 1
- Nassau 1
- St. Louis 1
- Wenham 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1609 | 1609 | 2022-08-12 | Russell | David | Bryan Cave Leighton Paisner LLP 7157 | 2022-08-12 | Bryan Cave Leighton Paisner LLP | 211 North Broadway | Suite 3600 | St. Louis | MO | 63102 | |
5639 | 5639 | 1956-02-01 | 1953-09-30 | Russell | John Wriothesley | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
7265 | 7265 | 2021-02-19 | 2019-10-04 | Russell | Jennifer Kaufmann | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
8557 | 8557 | 2008-02-29 | 2007-09-27 | Russell | Adam | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
10078 | 10078 | 2002-03-16 | 1963-10-14 | Russell | Edward | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
10322 | 10322 | 1993-03-19 | 1990-07-13 | Russell | Douglas | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Suite 500 | Washington | DC | 20007-4186 |
10633 | 10633 | 2007-03-23 | 2005-02-28 | Russell | David | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
11797 | 11797 | 1998-03-31 | 1996-10-21 | Russell | Burnell J. | Oceans International Corporation 5134 | 1996-10-26 | Oceans International Corporation | 5005 Mitchelldale | Suite 121 | Houston | TX | 77092 |
12449 | 12449 | 1984-04-01 | 1983-10-28 | Russell | Michael J. | Justice International 3534 | 1983-10-28 | Justice International | 4660 Kenmore Avenue | Suite 1018 | Alexandria | VA | 22304 |
13726 | 13726 | 2019-04-18 | 2016-06-06 | Russell | David | Bryan Cave, LLP 6356 | 2016-06-06 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
16425 | 16425 | 1992-05-15 | 1990-07-18 | Russell | John H. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
17015 | 17015 | 1989-05-24 | 1988-04-27 | Russell | William A. , Jr. | William Russell & Associates, Inc. 4135 | 1988-04-27 | William Russell & Associates, Inc. | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
18119 | 18119 | 2014-05-31 | 2011-01-06 | Russell | Ronald Mark | OIC Services, Inc. 5481 | 2001-11-06 | OIC Services, Inc. | 12337 Jones Road | Suite 301 | Houston | TX | 77070 |
20645 | 20645 | 1953-06-30 | 1949-12-09 | Russell | Frederick George Wolseley | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
21822 | 21822 | 2015-06-30 | 2013-04-08 | Russell | David | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
26262 | 26262 | 1986-08-08 | 1981-06-05 | Russell | Robert Marvin | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | 655 - 15th Street, N.W. | Suite 800 | Washington | DC | 20005 |
31172 | 31172 | 1997-09-30 | 1982-09-13 | Russell | James F. | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
32097 | 32097 | 2017-10-01 | 2016-04-29 | Russell | Shane I. | Bahamas Tourist Office 2310 | 1972-01-27 | Bahamas Tourist Office | Ministry of Tourism | Post Office Box N-3701 | Nassau | ||
32665 | 32665 | 1983-10-12 | 1982-03-05 | Russell | David A. | Walters, Costanzo, Miller & Russell 3343 | 1982-03-05 | Walters, Costanzo, Miller & Russell | 330 North Biscayne Boulevard | Suite 500 | Miami | FL | 33132 |
33776 | 33776 | 1993-10-28 | 1992-05-18 | Russell | Bridget | Porter/Novelli 4671 | 1992-05-18 | Porter/Novelli | 1909 K Street | Suite 400 | Washington | DC | 20006 |
34137 | 34137 | 1959-10-31 | 1954-05-28 | Russell | Richard A. | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | 1350 Avenue of the Americas | New York | NY | 10019 | |
34450 | 34450 | 2001-10-31 | 1998-05-19 | Russell | Ronald M. | Oceans International Corporation 5134 | 1996-10-26 | Oceans International Corporation | 5005 Mitchelldale | Suite 121 | Houston | TX | 77092 |
36174 | 36174 | 2003-11-21 | 2003-07-11 | Russell | Jennifer L. | Venezuela Information Office 5567 | 2003-07-11 | Venezuela Information Office | 733 15th Street, N.W. | Suite 437 | Washington | DC | 20005 |
39394 | 39394 | 1988-12-30 | 1959-10-14 | Russell | Derek | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 |
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]) );