FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Short_Form_First_Name = "Erica"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 14
- Hill and Knowlton Strategies, LLC 3
- Ruder Finn, Inc. 2
- Daniel J. Edelman, Inc. 2
- MMGY Global, LLC 2
- VisitBritain 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Trinidad-Tobago Industrial Development Corporation 1
- Daniel J. Edelman, Inc. 1
- Rockey Company, Inc. 1
- QORVIS LLC 1
- Covington & Burling, LLP 1
- Humanitas Global Development 1
- Information Management Services, Inc. 1
- Rubin Turnbull & Associates, Inc. 1
Registration_Date (date) 14 ✖
- 1981-11-10 3
- 1961-09-27 2
- 1985-03-12 2
- 2017-11-27 2
- 1949-07-07 1
- 1964-04-02 1
- 1965-04-30 1
- 1984-11-15 1
- 1991-11-14 1
- 2002-03-06 1
- 2008-02-05 1
- 2012-08-21 1
- 2016-06-17 1
- 2021-04-01 1
Registrant_Name 13
- Daniel J. Edelman, Inc. 3
- Hill and Knowlton Strategies, LLC 3
- MMGY Global, LLC 2
- Ruder Finn, Inc. 2
- Covington & Burling, LLP 1
- Humanitas Global Development 1
- Information Management Services, Inc. 1
- QORVIS LLC 1
- Rockey Company, Inc. 1
- Rubin Turnbull & Associates, Inc. 1
- Trinidad-Tobago Industrial Development Corporation 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- VisitBritain 1
City 6
- New York 7
- Washington 7
- Overland Park 2
- Chicago 1
- Ft. Lauderdale 1
- Seattle 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1296 | 1296 | 2019-06-26 | Miller | Erica | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 | |
8199 | 8199 | 2006-02-28 | 2006-08-02 | Rose | Erica | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
8290 | 8290 | 2015-02-28 | 2013-06-10 | Lai | Erica | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
10670 | 10670 | 1987-03-24 | 1975-02-28 | Williams | Erica | Trinidad-Tobago Industrial Development Corporation 1889 | 1965-04-30 | Trinidad-Tobago Industrial Development Corporation | 400 Madison Avenue | New York | NY | 10017 | |
15263 | 15263 | 2022-04-30 | 2021-04-01 | Chanti | Erica | Rubin Turnbull & Associates, Inc. 6944 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | 401 E Las Olas Boulevard | Suite 130-447 | Ft. Lauderdale | FL | 33301 |
15607 | 15607 | 2013-05-02 | 2011-06-01 | Flint | Erica | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
17091 | 17091 | 2005-05-25 | 2005-04-05 | Noble | Erica | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
17106 | 17106 | 2022-05-25 | 2021-05-05 | Roney | Erica | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 |
17996 | 17996 | 2006-05-31 | 2006-01-27 | Amestoy | Erica | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18194 | 18194 | 2017-05-31 | 2017-11-27 | Campbell | Erica | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
21606 | 21606 | 2008-06-30 | 2008-06-30 | Amestoy | Erica | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
31155 | 31155 | 1997-09-30 | 1987-01-05 | Kaplan | Erica | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
31455 | 31455 | 2009-09-30 | 2009-05-07 | Lederman | Erica | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31460 | 31460 | 2009-09-30 | 2009-05-07 | Noble | Erica | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31549 | 31549 | 2013-09-30 | 2013-05-24 | Cohen | Erica | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
35907 | 35907 | 2012-11-15 | 2012-08-21 | Oakley | Erica | Humanitas Global Development 6126 | 2012-08-21 | Humanitas Global Development | 1100 Connecticut Avenue, NW | Suite 440 | Washington | DC | 20036 |
36379 | 36379 | 1998-11-25 | 1998-06-19 | Perez | Erica | Rockey Company, Inc. 4594 | 1991-11-14 | Rockey Company, Inc. | 2121 Fifth Avenue | Seattle | WA | 98121 | |
39993 | 39993 | 1975-12-31 | 1974-11-25 | Ress | Erica | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
42041 | 42041 | 2016-12-31 | 2016-06-17 | Symonds | Erica | Information Management Services, Inc. 6361 | 2016-06-17 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 |
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]) );