FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
31 rows where Short_Form_Last_Name = "Bell"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 29
- Hogan Lovells US LLP 3
- Bermuda Tourism Authority 1
- New York Bureau of the Telegraph Agency of Russia (TASS) 1
- British Information Services 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Allied Public Relations, Inc. 1
- Jamaica Tourist Board, New York 1
- Checchi & Company 1
- Bell & Stanton, Inc. 1
- Bell & Stanton, Inc. 1
- Burson-Marsteller 1
- Jones Day 1
- DLA Piper US LLP 1
- Holland & Knight 1
- Klein Partnership 1
- IPG DXTRA, Inc 1
- Tourism Queensland 1
- International Technology & Trade Associates, Inc. 1
- King & Spalding 1
- Thomson-CSF, Inc. 1
- Baker & McKenzie 1
- Thales, Inc. 1
- Waterman Associates, Inc. 1
- International Liaison Office, Inc. 1
- JWI, LLC 1
- Ogilvy Public Relations Worldwide 1
- Covington & Burling, LLP 1
- NSW Government US Office Inc. 1
- Wagstaff Worldwide Public Relations, Inc. 1
Registrant_Name 28
- Hogan Lovells US LLP 3
- Bell & Stanton, Inc. 2
- Allied Public Relations, Inc. 1
- Baker & McKenzie 1
- Bermuda Tourism Authority 1
- British Information Services 1
- Burson-Marsteller 1
- Checchi & Company 1
- Covington & Burling, LLP 1
- DLA Piper US LLP 1
- Holland & Knight 1
- IPG DXTRA, Inc 1
- International Liaison Office, Inc. 1
- International Technology & Trade Associates, Inc. 1
- JWI, LLC 1
- Jamaica Tourist Board, New York 1
- Jones Day 1
- King & Spalding 1
- Klein Partnership 1
- NSW Government US Office Inc. 1
- New York Bureau of the Telegraph Agency of Russia (TASS) 1
- Ogilvy Public Relations Worldwide 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Thales, Inc. 1
- Thomson-CSF, Inc. 1
- Tourism Queensland 1
- Wagstaff Worldwide Public Relations, Inc. 1
- Waterman Associates, Inc. 1
City 6
- Washington 17
- New York 9
- Los Angeles 2
- Alexandria 1
- Arlington 1
- Houston 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
669 | 669 | 2012-03-29 | Bell | Nathaniel | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | ||
3321 | 3321 | 2023-01-06 | 2022-12-28 | Bell | Katie | Wagstaff Worldwide Public Relations, Inc. 7179 | 2022-10-07 | Wagstaff Worldwide Public Relations, Inc. | 5443 Fountain Avenue | Los Angeles | CA | 90029 | |
3687 | 3687 | 1959-01-14 | 1958-10-09 | Bell | J. Raymond | Allied Public Relations, Inc. 1177 | 1958-10-09 | Allied Public Relations, Inc. | 250 Park Avenue | New York | NY | ||
4169 | 4169 | 1995-01-20 | 1992-04-02 | Bell | James D. | Thales, Inc. 4628 | 1992-04-02 | Thales, Inc. | 99 Canal Center Plaza | Suite 450 | Alexandria | VA | 22314 |
4914 | 4914 | 1964-01-31 | 1960-12-23 | Bell | Martha Anne Maley | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
7950 | 7950 | 1990-02-28 | 1986-01-16 | Bell | William G. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
8071 | 8071 | 1997-02-28 | 1994-01-05 | Bell | Joseph C. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
8409 | 8409 | 2021-02-28 | 2020-02-08 | Bell | Michael J. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
14597 | 14597 | 1989-04-30 | 1989-07-17 | Bell | Diana C. | Klein Partnership 3878 | 1986-08-27 | Klein Partnership | 1201 Louisiana | Suite 3426 | Houston | TX | 77002-5213 |
14691 | 14691 | 1996-04-30 | 1993-02-22 | Bell | Beverly | International Liaison Office, Inc. 4767 | 1993-02-22 | International Liaison Office, Inc. | Post Office Box 25535 | Washington | DC | 20007 | |
16574 | 16574 | 1973-05-17 | 1967-10-06 | Bell | Alan W. | Bell & Stanton, Inc. 2054 | 1967-10-06 | Bell & Stanton, Inc. | 909 Third Avenue | New York | NY | ||
17041 | 17041 | 1994-05-24 | 1990-09-14 | Bell | Thomas D. , Jr. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
20628 | 20628 | 1948-06-30 | 1947-10-08 | Bell | Tessa C. | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
21302 | 21302 | 1998-06-30 | 1997-08-05 | Bell | Molly J. | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | 815 Connecticut Avenue, N.W. | Suite 900 | Washington | DC | 20006 |
22423 | 22423 | 1968-07-02 | 1967-06-19 | Bell | Martha Maley | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
23893 | 23893 | 1992-07-23 | 1983-03-02 | Bell | Stephen R. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
23946 | 23946 | 2023-07-23 | 2022-07-22 | Bell | Kylie | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | |
26481 | 26481 | 1966-08-12 | 1964-12-04 | Bell | Alan W. | Bell & Stanton, Inc. 1827 | 1964-12-04 | Bell & Stanton, Inc. | 757 Third Avenue | New York | NY | ||
26897 | 26897 | 2012-08-17 | 2010-09-30 | Bell | Elizabeth | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
26920 | 26920 | 1985-08-18 | 1951-08-13 | Bell | Nancy | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
27264 | 27264 | 1991-08-23 | 1990-02-21 | Bell | Kathryn F. | International Technology & Trade Associates, Inc. 4341 | 1990-02-21 | International Technology & Trade Associates, Inc. | 1330 Connecticut Avenue, N.W. | Suite 210 | Washington | DC | 20036-1704 |
30883 | 30883 | 1968-09-30 | 1965-08-26 | Bell | Daniel Wafena | Checchi & Company 1713 | 1964-04-14 | Checchi & Company | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
31043 | 31043 | 1990-09-30 | 1990-03-16 | Bell | Griffin B. | King & Spalding 4352 | 1990-03-16 | King & Spalding | 1730 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
36459 | 36459 | 2013-11-26 | 2007-05-07 | Bell | John | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
36780 | 36780 | 1995-11-30 | 1995-02-06 | Bell | Cheryl Lee | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 700 New Hampshire Avenue, NW | Watergate South, Suite 1019 | Washington | DC | 20037 |
37876 | 37876 | 1990-12-07 | 1989-11-17 | Bell | Joseph C. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
40448 | 40448 | 1987-12-31 | 1982-12-10 | Bell | James Frederick | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
40727 | 40727 | 1991-12-31 | 1990-11-30 | Bell | James D. | Thomson-CSF, Inc. 4447 | 1990-11-29 | Thomson-CSF, Inc. | 2231 Crystal Drive | Arlington | VA | 22202 | |
40777 | 40777 | 1994-12-31 | 1995-03-24 | Bell | Cheryl L. | Waterman Associates, Inc. 4738 | 1992-12-17 | Waterman Associates, Inc. | 1700 K Street, N.W. | Suite 405 | Washington | DC | 20006 |
40855 | 40855 | 1995-12-31 | 1988-05-31 | Bell | Megan | Tourism Queensland 4146 | 1988-05-31 | Tourism Queensland | 6100 Center Drive | Suite 1150 | Los Angeles | CA | 90045 |
41306 | 41306 | 2003-12-31 | 2003-04-29 | Bell | Christine T. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 |
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]) );