FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Termination_Date = "2005-12-31" sorted by Name
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Business_Name, Address_2, Zip, Registration_Date (date)
Address_1 12
- 1029 North Royal Street 1
- 110 Fifth Avenue 1
- 1700 Pennsylvania Avenue, N.W. 1
- 1901 Pennsylvania Avenue, NW 1
- 221 Main Street 1
- 4527 29th Street, NW 1
- 499 South Capitol Street, S.W. 1
- 555 Hamilton Avenue 1
- 825 Seventh Avenue 1
- Bosques de Duraznos no. 61, 5th Floor 1
- Bosques de Duraznos no. 61, 5th floor 1
- P.O. Box 220 1
City 8
- Washington 4
- New York 2
- Alexandria 1
- Flint Hill 1
- Mexico D.F. 1
- Mexico, D.F. 1
- Palo Alto 1
- San Francisco 1
Termination_Date (date) 1 ✖
- 2005-12-31 12
Registration_Number | Registration_Date | Termination_Date | Name ▼ | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
5259 | 1998-06-03 | 2005-12-31 | American International Development Group, Inc. | 1029 North Royal Street | Suite 350 | Alexandria | VA | 22314 | |
5500 | 2002-06-05 | 2005-12-31 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | ||
5381 | 2000-09-01 | 2005-12-31 | Bavarian Office for Trade, Investment, Research and Technology | 555 Hamilton Avenue | Suite 130 | Palo Alto | CA | 94301 | |
5569 | 2003-07-28 | 2005-12-31 | Brewster/Jory Associates, LLC | Capitol Hill Consulting Group | 499 South Capitol Street, S.W. | Suite 608 | Washington | DC | 20003 |
5664 | 2004-12-28 | 2005-12-31 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 | |
5604 | 2003-12-29 | 2005-12-31 | Dinamica Multiple, S.A. | Bosques de Duraznos no. 61, 5th floor | Col. Bosques de las Lomas | Mexico D.F. | |||
5663 | 2004-12-22 | 2005-12-31 | Kamber Group | 4527 29th Street, NW | Washington | DC | 20008 | ||
5690 | 2005-06-24 | 2005-12-31 | Kemp Partners | 1901 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 | |
5605 | 2003-12-29 | 2005-12-31 | Mediaedge: CIA, LLC | 825 Seventh Avenue | New York | NY | 10019 | ||
5613 | 2004-03-24 | 2005-12-31 | Paul A. Russo and Associates, Inc. | P.O. Box 220 | Flint Hill | VA | 22627 | ||
5660 | 2004-12-13 | 2005-12-31 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 | |
5603 | 2003-12-29 | 2005-12-31 | Young & Rubicam, S. de R.L. de C.V. | Bosques de Duraznos no. 61, 5th Floor | Col. Bosques de las Lomas | Mexico, D.F. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [FARA_All_Registrants] ( [Registration_Number] INTEGER PRIMARY KEY, [Registration_Date] TEXT, [Termination_Date] TEXT, [Name] TEXT, [Business_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );