FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Rand"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 10
Registrant_Name 10
City 5
- New York 6
- St. Louis 2
- Bethesda 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1762 | 1762 | 2021-09-10 | Rand | Amy | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
5907 | 5907 | 2020-02-01 | 2019-05-08 | Rand | Amy Rosenberg | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
6160 | 6160 | 1971-02-05 | 1968-10-31 | Rand | Larry Anthony | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
6450 | 6450 | 1978-02-09 | 1976-08-19 | Rand | Harry I. | Botein, Hays, Sklar & Herzberg 2716 | 1976-08-19 | Botein, Hays, Sklar & Herzberg | 20 Park Avenue | New York | NY | 10017 | |
10016 | 10016 | 2021-03-15 | 2021-01-21 | Rand | Amy | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
10274 | 10274 | 1959-03-19 | 1955-05-23 | Rand | William B. , Jr. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
17805 | 17805 | 1995-05-31 | 1995-02-24 | Rand | Kristin | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
25902 | 25902 | 2021-08-03 | 2020-08-18 | Rand | Haley | LGND, LLC 6570 | 2018-07-10 | LGND, LLC | 6701 Democracy Blvd | Suite 300 | Bethesda | MD | 20817 |
29836 | 29836 | 1987-09-15 | 1986-10-22 | Rand | Edward J. | David M. Grant, Inc. 3900 | 1986-10-22 | David M. Grant, Inc. | 750 Third Avenue | New York | NY | 10017-2703 | |
35283 | 35283 | 1979-11-05 | 1975-11-03 | Rand | Joseph | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
36609 | 36609 | 1967-11-30 | 1964-11-02 | Rand | William , Jr. | Coudert Brothers 1811 | 1964-11-02 | Coudert Brothers | 200 Park Avenue | New York | NY | 10017 |
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]) );