FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Termination_Date" is on date 1997-12-31 sorted by Business_Name
This data as json, CSV (advanced)
Suggested facets: Zip
Registration_Date (date) 10 ✖
- 1979-12-13 1
- 1987-03-20 1
- 1991-06-20 1
- 1993-06-23 1
- 1996-02-29 1
- 1997-06-04 1
- 1997-06-05 1
- 1997-06-19 1
- 1997-06-27 1
- 1997-12-27 1
Address_1 10
Address_2 7 ✖
- - 4
- 216 Maple Avenue 1
- 26th Floor 1
- Suite 1150 1
- Suite 700 1
- Suite 812 1
- Suite 880 1
City 5
- Washington 6
- Alexandria 1
- New York 1
- Oakton 1
- Red Bank 1
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name ▼ | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3076 | 1979-12-13 | 1997-12-31 | Mayer, Brown & Platt | 2000 Pennsylvania Avenue, N.W. | Washington | DC | 20006-1882 | ||
3950 | 1987-03-20 | 1997-12-31 | Robison International, Inc. | One Massachusetts Avenue, N.W. | Suite 880 | Washington | DC | 20001 | |
4529 | 1991-06-20 | 1997-12-31 | Capitoline/MS&L | 1615 L Street, N.W. | Suite 1150 | Washington | DC | 20036 | |
4820 | 1993-06-23 | 1997-12-31 | Graydon Associates, Inc. | Post Office Box 566 | 216 Maple Avenue | Red Bank | NJ | 07701 | |
5096 | 1996-02-29 | 1997-12-31 | Sellars, Duncan W. | 2621 Clide Court | Oakton | VA | 22124 | ||
5182 | 1997-06-04 | 1997-12-31 | Kelley Swofford Roy Helmke, Inc. | 1002 King Street | Alexandria | VA | 22314 | ||
5184 | 1997-06-05 | 1997-12-31 | Nichols - Dezenhall Communications Management Group, Ltd. | 1211 Connecticut Avenue, N.W. | Suite 812 | Washington | DC | 20036 | |
5186 | 1997-06-19 | 1997-12-31 | Daedalus International Corporation | 2300 N Street, NW | Suite 700 | Washington | DC | 20037-1128 | |
5188 | 1997-06-27 | 1997-12-31 | Dilenschneider Group | 200 Park Avenue | 26th Floor | New York | NY | 10166 | |
5223 | 1997-12-27 | 1997-12-31 | Varney, Kevin P. | 4526 Verplanck Place, N.W. | Washington | DC | 20016 |
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]) );