FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Short_Form_First_Name = "Charlotte"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 18
- American Section of the Jewish Agency for Israel 1
- French Government Tourist Office 1
- Korean Research & Information Office 1
- Quebec Government Office 1
- Donald G. Lerch, Jr. & Company, Inc. 1
- World Zionist Organization - American Section, Inc. 1
- Alford Leisure Enterprises, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- International Public Relations Affiliates 1
- Cassidy & Associates, Inc. 1
- Holloman, Charlotte 1
- Whitaker Group, Inc. 1
- CLS Strategies 1
- Ogilvy Public Relations Worldwide 1
- Brownstein Hyatt Farber Schreck, LLP 1
- Beacon Policy Advisors LLC 1
- Teneo Strategy LLC 1
- Linklaters LLP 1
Registrant_Name 18
- Alford Leisure Enterprises, Inc. 1
- American Section of the Jewish Agency for Israel 1
- Beacon Policy Advisors LLC 1
- Brownstein Hyatt Farber Schreck, LLP 1
- CLS Strategies 1
- Cassidy & Associates, Inc. 1
- Donald G. Lerch, Jr. & Company, Inc. 1
- French Government Tourist Office 1
- Hill and Knowlton Strategies, LLC 1
- Holloman, Charlotte 1
- International Public Relations Affiliates 1
- Korean Research & Information Office 1
- Linklaters LLP 1
- Ogilvy Public Relations Worldwide 1
- Quebec Government Office 1
- Teneo Strategy LLC 1
- Whitaker Group, Inc. 1
- World Zionist Organization - American Section, Inc. 1
City 5
- Washington 9
- New York 6
- Burbank 1
- Denver 1
- London 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
668 | 668 | 2023-03-28 | Millington | Charlotte | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
4752 | 4752 | 1988-01-29 | 1987-06-08 | Halpert | Charlotte | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
5184 | 5184 | 1997-01-31 | 1996-10-04 | Holloman | Charlotte | Holloman, Charlotte 5133 | 1996-10-04 | Holloman, Charlotte | 1625-1/2 - 19th Street, N.W. | Suite E | Washington | DC | 20009 |
6760 | 6760 | 2023-02-13 | 2020-02-24 | Morgan | Charlotte | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
10174 | 10174 | 2013-03-17 | 2012-06-29 | Tansill | Charlotte | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
11376 | 11376 | 1962-03-31 | 1953-03-18 | Richmond | Charlotte | Korean Research & Information Office 761 | 1953-03-18 | Korean Research & Information Office | 1828 Jefferson Place, N.W. | Washington | DC | ||
12834 | 12834 | 1990-04-06 | 1988-08-30 | Zatt | Charlotte | International Public Relations Affiliates 4174 | 1988-08-30 | International Public Relations Affiliates | 500 Fifth Avenue | Suite 850 | New York | NY | 10112 |
13388 | 13388 | 1980-04-15 | 1979-06-04 | Tegeder | Charlotte | Donald G. Lerch, Jr. & Company, Inc. 2089 | 1968-04-22 | Donald G. Lerch, Jr. & Company, Inc. | 1030 - 15th Street, N.W. | Suite 948 | Washington | DC | 20005 |
20036 | 20036 | 1995-06-22 | 1993-07-27 | Fortier | Charlotte | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21727 | 21727 | 2013-06-30 | 2013-06-18 | McCoy | Charlotte | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | 1850 M Street, NW | Suite 900 | Washington | DC | 20036 |
22537 | 22537 | 2007-07-03 | 2006-06-29 | Ashamu | Charlotte | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | 1133 21st Street, NW | Suite 405 | Washington | DC | 20036 |
29548 | 29548 | 2021-09-10 | 2020-11-19 | Carstens | Charlotte | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
30974 | 30974 | 1985-09-30 | 1973-04-18 | Hyde | Charlotte | Alford Leisure Enterprises, Inc. 2418 | 1973-04-18 | Alford Leisure Enterprises, Inc. | 4405 Riverside Drive | Suite 205 | Burbank | CA | 91505 |
32742 | 32742 | 1995-10-13 | 1994-09-07 | Newton | Charlotte | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | 700 - 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
33906 | 33906 | 1971-10-29 | 1968-10-09 | Jacobson | Charlotte | American Section of the Jewish Agency for Israel 208 | 1943-09-14 | American Section of the Jewish Agency for Israel | 515 Park Avenue | New York | NY | 10022 | |
36425 | 36425 | 2022-11-25 | 2020-11-12 | Jenkins | Charlotte | Beacon Policy Advisors LLC 6658 | 2019-04-09 | Beacon Policy Advisors LLC | 1701 Pennsylvania Avenue, NW | Suite 200 | Washington | DC | 20006 |
38794 | 38794 | 1982-12-20 | 1971-10-12 | Jacobson | Charlotte | World Zionist Organization - American Section, Inc. 2278 | 1971-09-21 | World Zionist Organization - American Section, Inc. | 633 Third Avenue | 21st Floor | New York | NY | 10017 |
39668 | 39668 | 1959-12-31 | 1959-02-10 | Hyde | Charlotte | French Government Tourist Office 364 | 1946-07-25 | French Government Tourist Office | 610 Fifth Avenue | New York | NY | 10020 |
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]) );