FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "Albert"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 8
- Netherlands Chamber of Commerce in the U.S. 1
- DDB Worldwide Communications Group, Inc. 1
- McCann-Erickson, Inc. 1
- Markham/Novell Communications, Ltd. 1
- Coordinadora de Organizaciones Empresariales de Comercio Ext 1
- Mary Rose Oakar & Associates, Inc. 1
- McKenna Long & Aldridge, LLP 1
- Myriad International Marketing, LLC 1
Registrant_Name 8
- Coordinadora de Organizaciones Empresariales de Comercio Ext 1
- DDB Worldwide Communications Group, Inc. 1
- Markham/Novell Communications, Ltd. 1
- Mary Rose Oakar & Associates, Inc. 1
- McCann-Erickson, Inc. 1
- McKenna Long & Aldridge, LLP 1
- Myriad International Marketing, LLC 1
- Netherlands Chamber of Commerce in the U.S. 1
City 4
- New York 3
- Washington 3
- Los Angeles 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2268 | 2268 | 2021-11-29 | Albert | Jamie | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
9516 | 9516 | 1987-03-09 | 1984-02-08 | Albert | Nancy T. | Markham/Novell Communications, Ltd. 3464 | 1983-04-27 | Markham/Novell Communications, Ltd. | 211 East 43rd Street | Suite 1106 | New York | NY | 10017 |
10071 | 10071 | 2002-03-16 | 1976-05-03 | Albert | Bruce Lee | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
10361 | 10361 | 1962-03-20 | 1956-10-05 | Albert | Mayer | Netherlands Chamber of Commerce in the U.S. 639 | 1950-08-22 | Netherlands Chamber of Commerce in the U.S. | 350 South Figueroa Street | Suite 901 | Los Angeles | CA | 90017 |
12072 | 12072 | 2010-03-31 | 2006-10-03 | Albert | Alex | McKenna Long & Aldridge, LLP 5772 | 2006-10-03 | McKenna Long & Aldridge, LLP | 1900 K Street, NW | Washington | DC | 20006 | |
32874 | 32874 | 1986-10-15 | 1985-10-18 | Albert | Victoria | McCann-Erickson, Inc. 3060 | 1979-09-16 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
36788 | 36788 | 1995-11-30 | 1995-07-10 | Albert | Thomas A. | Mary Rose Oakar & Associates, Inc. 5035 | 1995-07-10 | Mary Rose Oakar & Associates, Inc. | Post Office Box 25577 | Georgetown Station | Washington | DC | 20007 |
38875 | 38875 | 1992-12-21 | 1991-05-09 | Albert | Guadalupe | Coordinadora de Organizaciones Empresariales de Comercio Ext 4498 | 1991-04-12 | Coordinadora de Organizaciones Empresariales de Comercio Ext | 1025 Thomas Jeff. Street, N.W. | East Lobby, 7th Floor | Washington | DC | 20007 |
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]) );