FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Last_Name = "Orr"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 13
- Arnold & Porter Kaye Scholer LLP 1
- Milbank, Tweed, Hadley & McCloy 1
- White & Case, LLP 1
- Washington International Group, Inc. 1
- Al Paul Lefton Company, Inc. 1
- Miller & Chevalier, Chartered 1
- Al Paul Lefton Company Inc. 1
- U.S. - Emirates Alliance, LLC 1
- AB&C Philadelphia, LLC 1
- Miller & Chevalier Chartered 1
- MMGY Global, LLC 1
- Miller & Chevalier Chartered 1
- Miller & Chevalier Chartered 1
Registrant_Name 11
- Miller & Chevalier Chartered 3
- AB&C Philadelphia, LLC 1
- Al Paul Lefton Company Inc. 1
- Al Paul Lefton Company, Inc. 1
- Arnold & Porter Kaye Scholer LLP 1
- MMGY Global, LLC 1
- Milbank, Tweed, Hadley & McCloy 1
- Miller & Chevalier, Chartered 1
- U.S. - Emirates Alliance, LLC 1
- Washington International Group, Inc. 1
- White & Case, LLP 1
City 4
- Washington 7
- Philadelphia 3
- New York 2
- Overland Park 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1297 | 1297 | 2019-06-26 | Orr | Jean | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 | |
8903 | 8903 | 2016-03-01 | 2014-07-02 | Orr | P. Welles | Miller & Chevalier Chartered 6209 | 2014-02-27 | Miller & Chevalier Chartered | 900 16th Street, NW | Washington | DC | 20005 | |
10791 | 10791 | 1982-03-26 | 1980-10-03 | Orr | Richard Forrest | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
12109 | 12109 | 2012-03-31 | 2005-11-29 | Orr | P. Welles | Miller & Chevalier, Chartered 5365 | 2000-04-03 | Miller & Chevalier, Chartered | 655 Fifteenth Street, N.W. | Suite 900 - Metropolitan Square | Washington | DC | 20005-5701 |
12596 | 12596 | 2020-04-01 | 2018-03-15 | Orr | P. Welles | Miller & Chevalier Chartered 6533 | 2018-03-15 | Miller & Chevalier Chartered | 900 16th Street, NW | Washington | DC | 20006 | |
17712 | 17712 | 1988-05-31 | 1984-06-04 | Orr | P. Welles | Washington International Group, Inc. 3320 | 1982-01-05 | Washington International Group, Inc. | 815 Connecticut Avenue, N.W. | Suite 800 | Washington | DC | 20006 |
21390 | 21390 | 2001-06-30 | 1994-05-06 | Orr | John H. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
22193 | 22193 | 1990-07-01 | 1965-01-11 | Orr | Michael Frank | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
25220 | 25220 | 2014-07-31 | 2011-05-24 | Orr | John H. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
27810 | 27810 | 2006-08-30 | 2006-05-31 | Orr | Stephen | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28550 | 28550 | 2010-08-31 | 2004-03-25 | Orr | John H. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
38972 | 38972 | 2017-12-22 | 2017-12-22 | Orr | P. Welles | Miller & Chevalier Chartered 6503 | 2017-12-22 | Miller & Chevalier Chartered | 900 16th Street, NW | Washington | DC | 20006 | |
41717 | 41717 | 2010-12-31 | 2007-08-27 | Orr | Amanda M. | U.S. - Emirates Alliance, LLC 5785 | 2007-01-22 | U.S. - Emirates Alliance, LLC | 2300 N Street, NW | Suite 1200 | Washington | DC | 20037 |
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]) );