FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Short_Form_Termination_Date" is on date 1995-08-31
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Short_Form_Date (date)
Registration_Number 11
- Paul Magliocchetti Associates, Inc. 3
- Daniel J. Edelman, Inc. 2
- Doyle & Nelson 2
- Lipsen & Hamberger 2
- VisitBritain 1
- Singapore Economic Development Board 1
- Hogan Lovells US LLP 1
- Aaron D. Cushman & Associates, Inc. 1
- White & Case, LLP 1
- Scottish Enterprise 1
- Lloyd's of London Market Representatives 1
Registrant_Name 11
- Paul Magliocchetti Associates, Inc. 3
- Daniel J. Edelman, Inc. 2
- Doyle & Nelson 2
- Lipsen & Hamberger 2
- Aaron D. Cushman & Associates, Inc. 1
- Hogan Lovells US LLP 1
- Lloyd's of London Market Representatives 1
- Scottish Enterprise 1
- Singapore Economic Development Board 1
- VisitBritain 1
- White & Case, LLP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28257 | 28257 | 1995-08-31 | 1994-01-06 | Gibson | Barry J. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
28258 | 28258 | 1995-08-31 | 1979-01-24 | McAvoy | John J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28259 | 28259 | 1995-08-31 | 1990-02-06 | Doyle | Jon R. | Doyle & Nelson 4337 | 1990-02-06 | Doyle & Nelson | 150 Capitol Street | Post Office Box 2709 | Augusta | ME | 04338-2709 |
28260 | 28260 | 1995-08-31 | 1990-02-06 | Nelson | Craig H. | Doyle & Nelson 4337 | 1990-02-06 | Doyle & Nelson | 150 Capitol Street | Post Office Box 2709 | Augusta | ME | 04338-2709 |
28261 | 28261 | 1995-08-31 | 1995-02-21 | Keefe | Kenneth L. | Paul Magliocchetti Associates, Inc. 4949 | 1994-09-21 | Paul Magliocchetti Associates, Inc. | 1755 Jefferson Davis Highway | Suite 1107 | Arlington | VA | 22202 |
28262 | 28262 | 1995-08-31 | 1988-03-29 | Christian,II | Alphonso Augustine | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28263 | 28263 | 1995-08-31 | 1992-04-20 | Hallan | Mark | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
28264 | 28264 | 1995-08-31 | 1993-04-27 | Goh | Eng-Ghee | 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 |
28265 | 28265 | 1995-08-31 | 1993-07-12 | Hamberger | Martin G. | Lipsen & Hamberger 4829 | 1993-07-12 | Lipsen & Hamberger | Willard Office Building | 1455 Pennsylvania Ave, NW #225 | Washington | DC | 20004-1008 |
28266 | 28266 | 1995-08-31 | 1993-07-12 | Lipsen | Zel | Lipsen & Hamberger 4829 | 1993-07-12 | Lipsen & Hamberger | Willard Office Building | 1455 Pennsylvania Ave, NW #225 | Washington | DC | 20004-1008 |
28267 | 28267 | 1995-08-31 | 1995-07-24 | Johns | Jan A. | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | 35 East Wacker Drive | Suite 850 | Chicago | IL | 60601 |
28268 | 28268 | 1995-08-31 | 1994-09-21 | Magliocchetti | Paul J. | Paul Magliocchetti Associates, Inc. 4949 | 1994-09-21 | Paul Magliocchetti Associates, Inc. | 1755 Jefferson Davis Highway | Suite 1107 | Arlington | VA | 22202 |
28269 | 28269 | 1995-08-31 | 1978-10-31 | Pace | Bedford | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 |
28270 | 28270 | 1995-08-31 | 1994-11-14 | Pin | Clerio | Paul Magliocchetti Associates, Inc. 4949 | 1994-09-21 | Paul Magliocchetti Associates, Inc. | 1755 Jefferson Davis Highway | Suite 1107 | Arlington | VA | 22202 |
28271 | 28271 | 1995-08-31 | 1994-11-15 | Jaffe | Blair | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
28272 | 28272 | 1995-08-31 | 1994-12-16 | Fuhrman | Elina | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
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]) );