FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where "Short_Form_Termination_Date" is on date 1989-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Zip
Registration_Number 19
- Arnold & Porter Kaye Scholer LLP 2
- Hill and Knowlton Strategies, LLC 2
- Australian Information Service 1
- Singapore Economic Development Board 1
- Bahamas Tourist Office 1
- Singapore Tourism Board 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- John G. Gelinas & Associates, Inc. 1
- Scottish Enterprise 1
- AbramsonEhrlichManes, Inc. 1
- Wilmer, Cutler & Pickering 1
- Saatchi & Saatchi North America, Inc. 1
- Hyjek & Fix, Inc. 1
- Kelley, Drye & Warren 1
- Welsh Development Agency 1
- Washington, Perito & Dubuc 1
- ClarkeGowardFittsMatteson, Inc. 1
- Greve, Clifford, Diepenbrock & Paras 1
- Ropes & Gray 1
Registrant_Name 19
- Arnold & Porter Kaye Scholer LLP 2
- Hill and Knowlton Strategies, LLC 2
- AbramsonEhrlichManes, Inc. 1
- Australian Information Service 1
- Bahamas Tourist Office 1
- ClarkeGowardFittsMatteson, Inc. 1
- Greve, Clifford, Diepenbrock & Paras 1
- Hyjek & Fix, Inc. 1
- John G. Gelinas & Associates, Inc. 1
- Kelley, Drye & Warren 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Ropes & Gray 1
- Saatchi & Saatchi North America, Inc. 1
- Scottish Enterprise 1
- Singapore Economic Development Board 1
- Singapore Tourism Board 1
- Washington, Perito & Dubuc 1
- Welsh Development Agency 1
- Wilmer, Cutler & Pickering 1
City 7
- Washington 10
- New York 6
- Boston 1
- Cambridge 1
- Chicago 1
- Nassau 1
- Sacramento 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21130 | 21130 | 1989-06-30 | 1988-11-18 | O'Brien | Michael E. | ClarkeGowardFittsMatteson, Inc. 4123 | 1988-04-20 | ClarkeGowardFittsMatteson, Inc. | 535 Boylston Street | Boston | MA | 02116 | |
21131 | 21131 | 1989-06-30 | 1986-12-15 | MacAlister-Hall | Colin W. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
21115 | 21115 | 1989-06-30 | 1989-03-09 | Francis | Colin E. | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
21124 | 21124 | 1989-06-30 | 1977-08-05 | Brown | McNair | Bahamas Tourist Office 2310 | 1972-01-27 | Bahamas Tourist Office | Ministry of Tourism | Post Office Box N-3701 | Nassau | ||
21113 | 21113 | 1989-06-30 | 1957-02-13 | Buckley | Noel | Australian Information Service 418 | 1946-12-31 | Australian Information Service | 636 Fifth Avenue | New York | NY | 10020 | |
21114 | 21114 | 1989-06-30 | 1989-02-15 | Burt | William | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
21117 | 21117 | 1989-06-30 | 1976-04-08 | Gelinas | John G. | John G. Gelinas & Associates, Inc. 2681 | 1976-04-08 | John G. Gelinas & Associates, Inc. | 529 Fifth Avenue | 18th Floor | New York | NY | 10017 |
21122 | 21122 | 1989-06-30 | 1988-07-09 | Poon | Alfred K.H. | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
21127 | 21127 | 1989-06-30 | 1976-09-28 | Terry | Carolyn A. | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | 309 West 49th Street | Worldwide Plaza | New York | NY | 10019-7399 |
21128 | 21128 | 1989-06-30 | 1983-10-03 | Khor | Peng-Soon | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
21123 | 21123 | 1989-06-30 | 1988-07-29 | Gray | Joe S. | Greve, Clifford, Diepenbrock & Paras 4163 | 1988-07-29 | Greve, Clifford, Diepenbrock & Paras | 1000 G Street, Suite 400 | Post Office Box 2469 | Sacramento | CA | 95812-2469 |
21111 | 21111 | 1989-06-30 | 1987-01-21 | Crispen | Cheryl | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
21112 | 21112 | 1989-06-30 | 1988-02-02 | Block | Marian | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
21116 | 21116 | 1989-06-30 | 1986-04-01 | Nordquist | Myron Harry | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
21118 | 21118 | 1989-06-30 | 1989-05-03 | Sinnott | Richard L. | Hyjek & Fix, Inc. 3660 | 1985-03-19 | Hyjek & Fix, Inc. | 2100 Pennsylvania Avenue, N.W. | Suite 560 | Washington | DC | 20037 |
21119 | 21119 | 1989-06-30 | 1989-05-12 | Bridge | Thomas W. | Ropes & Gray 4251 | 1989-05-12 | Ropes & Gray | 1301 K Street, N.W. | Suite 800 East | Washington | DC | 20005 |
21120 | 21120 | 1989-06-30 | 1989-06-01 | Fyock | John | AbramsonEhrlichManes, Inc. 3103 | 1980-04-30 | AbramsonEhrlichManes, Inc. | 1275 K Street, N.W. | Suite 300 | Washington | DC | 20005 |
21121 | 21121 | 1989-06-30 | 1988-06-30 | Hildreth | William C. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
21125 | 21125 | 1989-06-30 | 1985-08-22 | Brenner | Edgar H. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
21126 | 21126 | 1989-06-30 | 1988-09-13 | Cobbs | Louise | Washington, Perito & Dubuc 4107 | 1988-03-21 | Washington, Perito & Dubuc | 1120 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
21129 | 21129 | 1989-06-30 | 1988-11-04 | Anderson | David R. | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 |
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]) );