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 = "Bloom"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_1, Address_2, Zip, Short_Form_Date (date), Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5063 | 5063 | 1990-01-31 | 1979-12-13 | Bloom | David I. | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | 2000 Pennsylvania Avenue, N.W. | Washington | DC | 20006-1882 | |
7415 | 7415 | 2023-02-22 | 2022-07-26 | Bloom | Eric | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
11659 | 11659 | 1992-03-31 | 1992-02-07 | Bloom | Jane L. | Paul, Weiss, Rifkind, Wharton & Garrison 4539 | 1991-07-09 | Paul, Weiss, Rifkind, Wharton & Garrison | 1285 Avenue of the Americas | New York | NY | 10019-6064 | |
13084 | 13084 | 1991-04-10 | 1990-01-17 | Bloom | Evan | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
13826 | 13826 | 2022-04-20 | 2021-09-28 | Bloom | Eric | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
17172 | 17172 | 1987-05-26 | 1986-11-10 | Bloom | Herschel M. | King & Spalding 3812 | 1986-04-10 | King & Spalding | 1500 Trust Company | Atlanta | GA | 30303 | |
20811 | 20811 | 1968-06-30 | 1966-12-10 | Bloom | Melvyn Harold | Murden & Company, Inc. 1510 | 1962-01-17 | Murden & Company, Inc. | 39 East 51st Street | New York | NY | 10022 | |
24303 | 24303 | 1992-07-28 | 1989-06-06 | Bloom | Sarah | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
27357 | 27357 | 2001-08-24 | 1987-06-18 | Bloom | Joan E. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
29381 | 29381 | 1965-09-08 | 1965-02-12 | Bloom | Marvin Alan | Bishopric, Green & Fielden, Inc. 1855 | 1965-02-12 | Bishopric, Green & Fielden, Inc. | 3361 Southwest Third Avenue | Miami | FL | 33145 | |
32875 | 32875 | 1986-10-15 | 1985-10-18 | Bloom | Robin S. | McCann-Erickson, Inc. 3060 | 1979-09-16 | McCann-Erickson, Inc. | 485 Lexington 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]) );