FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Short_Form_Last_Name = "Hamilton"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 21
- White & Case, LLP 2
- Australian Information Service 1
- National Film Board of Canada 1
- British Information Services 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Covington & Burling 1
- New Zealand Central Reservations Office 1
- Lanseair Travel Service, Inc. 1
- Roosevelt, Summers & Hamilton, Inc. 1
- Broadcast Planning Corporation 1
- Scottish Enterprise 1
- Hill and Knowlton Strategies, LLC 1
- TransPacific Communications & Research Company 1
- Aviso, Inc. 1
- Covington & Burling 1
- Law Firm of Larson-Jackson, P.C. 1
- Ogilvy Group, Inc. 1
- Ketchum Inc. NY 1
- Myriad International Marketing, LLC 1
- Zeno Group, Inc. 1
- Pivot Integrated Communications, a division of BCW LLC 1
Registrant_Name 20
- Covington & Burling 2
- White & Case, LLP 2
- Australian Information Service 1
- Aviso, Inc. 1
- British Information Services 1
- Broadcast Planning Corporation 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Hill and Knowlton Strategies, LLC 1
- Ketchum Inc. NY 1
- Lanseair Travel Service, Inc. 1
- Law Firm of Larson-Jackson, P.C. 1
- Myriad International Marketing, LLC 1
- National Film Board of Canada 1
- New Zealand Central Reservations Office 1
- Ogilvy Group, Inc. 1
- Pivot Integrated Communications, a division of BCW LLC 1
- Roosevelt, Summers & Hamilton, Inc. 1
- Scottish Enterprise 1
- TransPacific Communications & Research Company 1
- Zeno Group, Inc. 1
City 8
- New York 10
- Washington 6
- Alameda 1
- Cambridge 1
- Chicago 1
- Los Angeles 1
- Overland Park 1
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4197 | 4197 | 1970-01-21 | 1964-08-20 | Hamilton | Ian Charles | Australian Information Service 418 | 1946-12-31 | Australian Information Service | 636 Fifth Avenue | New York | NY | 10020 | |
6602 | 6602 | 1958-02-11 | 1958-01-07 | Hamilton | Maxwell Joseph | Roosevelt, Summers & Hamilton, Inc. 1099 | 1958-01-01 | Roosevelt, Summers & Hamilton, Inc. | 787 Fifth Avenue | New York | NY | ||
7050 | 7050 | 1961-02-16 | 1960-08-15 | Hamilton | Louis Westervelt | Broadcast Planning Corporation 1371 | 1960-06-16 | Broadcast Planning Corporation | 793 Lexington Avenue | New York | NY | ||
8014 | 8014 | 1995-02-28 | 1989-02-22 | Hamilton | Irvin C. , Jr. | Aviso, Inc. 4220 | 1989-02-22 | Aviso, Inc. | 1150 Marina Village Parkway | Suite 104 | Alameda | CA | 94501 |
8918 | 8918 | 2019-03-01 | 2018-12-18 | Hamilton | Mycah | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
10919 | 10919 | 1960-03-28 | 1957-03-29 | Hamilton | Anthony | Lanseair Travel Service, Inc. 1014 | 1957-03-29 | Lanseair Travel Service, Inc. | 1026 - 17th Street, N.W. | Washington | DC | ||
11115 | 11115 | 1973-03-30 | 1969-05-16 | Hamilton | James | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
11181 | 11181 | 1999-03-30 | 1988-10-13 | Hamilton | Robert K. | TransPacific Communications & Research Company 4173 | 1988-08-26 | TransPacific Communications & Research Company | 582 Market Street | Suite 602 | San Francisco | CA | 94104 |
12742 | 12742 | 2001-04-04 | 2001-04-04 | Hamilton | Shelby G. | Law Firm of Larson-Jackson, P.C. 5424 | 2001-04-04 | Law Firm of Larson-Jackson, P.C. | 1500 K Street, N.W. | Suite 900 | Washington | DC | 20005 |
20702 | 20702 | 1960-06-30 | 1954-05-10 | Hamilton | Ian Alan | New Zealand Central Reservations Office 672 | 1951-04-23 | New Zealand Central Reservations Office | 6033 West Century Boulevard | Suite 1270 | Los Angeles | CA | 90045 |
21204 | 21204 | 1994-06-30 | 1993-07-21 | Hamilton | Deanna J. | Covington & Burling 4807 | 1993-05-26 | Covington & Burling | Post Office Box 7566 | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20044 |
21538 | 21538 | 2005-06-30 | 2004-06-07 | Hamilton | Diann | Ogilvy Group, Inc. 5626 | 2004-06-07 | Ogilvy Group, Inc. | Worldwide Plaza | 309 West 49th Street | New York | NY | 10019 |
21961 | 21961 | 2020-06-30 | 2019-10-22 | Hamilton | Casey | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | |
26511 | 26511 | 1999-08-12 | 1999-05-10 | Hamilton | Eric | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
27088 | 27088 | 2012-08-20 | 2011-10-28 | Hamilton | Sharon Elizabeth | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
30793 | 30793 | 1949-09-30 | 1947-07-25 | Hamilton | John Lawrence | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
32014 | 32014 | 2006-10-01 | 2003-12-02 | Hamilton | Jonathan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35348 | 35348 | 2019-11-06 | 2019-10-03 | Hamilton | Chris | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
35683 | 35683 | 1973-11-13 | 1948-01-19 | Hamilton | Milo Fowler | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
40530 | 40530 | 1988-12-31 | 1986-10-21 | Hamilton | Molly | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41277 | 41277 | 2002-12-31 | 1983-10-07 | Hamilton | Rayner M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41985 | 41985 | 2014-12-31 | 2013-11-06 | Hamilton | Christopher Young Patrick | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 |
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]) );