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 = "Curran"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1167 | 1167 | 2022-05-31 | Curran | Caroline Pollard | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 | |
1291 | 1291 | 2018-06-25 | Curran | Christopher M. | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | ||
4634 | 4634 | 1995-01-27 | 1994-02-01 | Curran | Colleen T. | McCann Direct, Inc. 3922 | 1986-12-29 | McCann Direct, Inc. | 750 Third Avenue | New York | NY | 10017 | |
7819 | 7819 | 1951-02-28 | 1950-08-22 | Curran | John Steven | Netherlands Chamber of Commerce in the U.S. 639 | 1950-08-22 | Netherlands Chamber of Commerce in the U.S. | 350 South Figueroa Street | Suite 901 | Los Angeles | CA | 90017 |
12562 | 12562 | 2014-04-01 | 2011-10-31 | Curran | Christopher | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
13829 | 13829 | 1958-04-21 | 1958-04-21 | Curran | Michael | Prisoners Aid Society 1202 | 1958-04-21 | Prisoners Aid Society | 58-60 North Broadway | Yonkers | NY | ||
16883 | 16883 | 1990-05-22 | 1989-04-05 | Curran | Catherine M.C. | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
26445 | 26445 | 1989-08-11 | 1979-02-26 | Curran | Denis | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
27667 | 27667 | 1972-08-29 | 1972-08-01 | Curran | Michael W. | Swedish-American Chamber of Commerce, Inc. 13 | 1942-07-06 | Swedish-American Chamber of Commerce, Inc. | 250 Park Avenue | New York | NY | 10017 | |
38323 | 38323 | 2010-12-14 | 2007-11-05 | Curran | Christopher | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );