FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Date = "1985-09-16"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 7
Registrant_Name 7
City 6
- Santa Monica 6
- New York 3
- Dallas 1
- Long Island City 1
- Los Angeles 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3895 | 3895 | 1986-01-16 | 1985-09-16 | Horan | Michael James | Victorian Government Business Office, Los Angeles 3266 | 1981-08-06 | Victorian Government Business Office, Los Angeles | 611 North Larchmont Boulevard | Second Floor | Los Angeles | CA | 90004 |
10704 | 10704 | 2000-03-24 | 1985-09-16 | Sherman | Michael D. | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | 3050 K Street N.W. | Suite 400 | Washington | DC | 20007-5108 |
11568 | 11568 | 1987-03-31 | 1985-09-16 | Kennedy | Linda A. | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 | |
16952 | 16952 | 1986-05-23 | 1985-09-16 | Weber | Lee Ann | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 | |
23235 | 23235 | 1986-07-15 | 1985-09-16 | Tannen | Andrew | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
25566 | 25566 | 1988-08-01 | 1985-09-16 | Lipps | Suzanne | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 | |
30994 | 30994 | 1986-09-30 | 1985-09-16 | Allen | Larry W. | Carl Byoir & Associates, Inc. 3170 | 1980-11-24 | Carl Byoir & Associates, Inc. | 380 Madison Avenue | New York | NY | 10017 | |
30995 | 30995 | 1986-09-30 | 1985-09-16 | Neukrug | Andrea | Carl Byoir & Associates, Inc. 3170 | 1980-11-24 | Carl Byoir & Associates, Inc. | 380 Madison Avenue | New York | NY | 10017 | |
34453 | 34453 | 2001-10-31 | 1985-09-16 | Fontayne | Cynthia | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 | |
35986 | 35986 | 1986-11-17 | 1985-09-16 | Shimano | Chiharu | OCS America, Inc. 3732 | 1985-09-16 | OCS America, Inc. | 27-08 42nd Road | Long Island City | NY | 11101 | |
36709 | 36709 | 1988-11-30 | 1985-09-16 | Suh | Jung-Rak | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
37376 | 37376 | 1984-12-01 | 1985-09-16 | Baronas | Robin Emerson | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 | |
40334 | 40334 | 1985-12-31 | 1985-09-16 | Famy | Sally Ann | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 |
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]) );