FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Last_Name = "Noble"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 7
Registrant_Name 6
City 5
- New York 3
- Chicago 1
- Minneapolis 1
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17091 | 17091 | 2005-05-25 | 2005-04-05 | Noble | Erica | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
18356 | 18356 | 1958-06-01 | 1958-03-18 | Noble | Joseph B. | Bradford, T. Walter 1076 | 1957-11-01 | Bradford, T. Walter | 810 - 18th Street, N.W. | Washington | DC | ||
28387 | 28387 | 2001-08-31 | 2001-04-13 | Noble | Sally | Patrice Tanaka & Company, Inc. 5426 | 2001-04-13 | Patrice Tanaka & Company, Inc. | 320 West 13th Street | 7th Floor | New York | NY | 10016 |
29216 | 29216 | 1984-09-05 | 1972-08-10 | Noble | Gerald S. | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
31460 | 31460 | 2009-09-30 | 2009-05-07 | Noble | Erica | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
33704 | 33704 | 1992-10-27 | 1989-04-07 | Noble | John L. | Noble International, Inc. 4235 | 1989-04-07 | Noble International, Inc. | 3848 - 35th Avenue, South | Minneapolis | MN | 55406 | |
39389 | 39389 | 1988-12-30 | 1966-07-19 | Noble | Ronald | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 |
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]) );