FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "McLaughlin"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 10
Registrant_Name 10
City 6
- New York 5
- Jamaica 1
- Philadelphia 1
- Radnor 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
304 | 304 | 2019-02-04 | McLaughlin | Celia | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | ||
4830 | 4830 | 1991-01-30 | 1990-11-02 | McLaughlin | Peter F. | Coudert Brothers 3743 | 1985-10-02 | Coudert Brothers | 1627 I Street, N. W. | Suite 1200 | Washington, | DC | 20006 |
7070 | 7070 | 1989-02-16 | 1986-08-01 | McLaughlin | Nilufer | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
13164 | 13164 | 1977-04-11 | 1975-11-07 | McLaughlin | Joseph T. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
16864 | 16864 | 1972-05-22 | 1966-01-14 | McLaughlin | Arthur Vincent | United World Films, Inc. 1952 | 1966-01-14 | United World Films, Inc. | 221 Park Avenue, South | New York | NY | 10003 | |
24812 | 24812 | 1990-07-31 | 1978-09-22 | McLaughlin | John | Baron/Canning & Company, Inc. 2270 | 1971-07-23 | Baron/Canning & Company, Inc. | 555 Madison Avenue | 12th Floor | New York | NY | 10022 |
30790 | 30790 | 1948-09-30 | 1947-04-28 | McLaughlin | Inez Maud | Jamaica Progressive League, Inc. 296 | 1945-03-12 | Jamaica Progressive League, Inc. | 15905 Hillside Avenue | 2nd Floor | Jamaica | NY | 11432 |
34180 | 34180 | 1974-10-31 | 1973-09-24 | McLaughlin | Arthur | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
35707 | 35707 | 1984-11-13 | 1976-11-08 | McLaughlin | Dennis | Chilton International Company 2576 | 1975-04-16 | Chilton International Company | Radnor | PA | 19089 | ||
41004 | 41004 | 1996-12-31 | 1995-12-15 | McLaughlin | William J. | McLaughlin & Morgan, Inc. 5088 | 1995-12-15 | McLaughlin & Morgan, Inc. | 146 North Bread Street | Philadelphia | PA | 19149 |
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]) );