FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and Short_Form_First_Name = "Roger"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Termination_Date (date)
Registration_Number 10
- Quebec Government Office 2
- Kelly, Nason, Inc. 1
- Agence France-Presse (France-Presse News Agency) 1
- British Information Services 1
- Parti National Haitian (Haitian National Party) 1
- Ruder Finn, Inc. 1
- Milbank, Tweed, Hadley & McCloy 1
- Friedlich, Fearon & Strohmeier, Inc. 1
- DJJ Communications, Inc. 1
- Lord Group 1
Registrant_Name 10
- Quebec Government Office 2
- Agence France-Presse (France-Presse News Agency) 1
- British Information Services 1
- DJJ Communications, Inc. 1
- Friedlich, Fearon & Strohmeier, Inc. 1
- Kelly, Nason, Inc. 1
- Lord Group 1
- Milbank, Tweed, Hadley & McCloy 1
- Parti National Haitian (Haitian National Party) 1
- Ruder Finn, Inc. 1
State 1
- NY 11
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4429 | 4429 | 1990-01-25 | 1954-05-20 | Bannister | Roger | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
14199 | 14199 | 1993-04-27 | 1991-09-19 | Feldman | Roger | Lord Group 4556 | 1991-08-14 | Lord Group | 810 Seventh Avenue | New York | NY | 10019 | |
15906 | 15906 | 1974-05-08 | 1972-10-12 | Carlin | Roger | DJJ Communications, Inc. 2371 | 1972-08-24 | DJJ Communications, Inc. | 575 Madison Avenue | New York | NY | 10022 | |
18743 | 18743 | 1977-06-03 | 1974-08-01 | Boyle | Roger | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
19911 | 19911 | 1975-06-20 | 1970-12-03 | Turner | Roger | Friedlich, Fearon & Strohmeier, Inc. 2228 | 1970-12-03 | Friedlich, Fearon & Strohmeier, Inc. | 600 Third Avenue | New York | NY | 10016 | |
23827 | 23827 | 1963-07-23 | 1960-06-03 | Rigaud | Roger | Parti National Haitian (Haitian National Party) 1365 | 1960-06-03 | Parti National Haitian (Haitian National Party) | 360 Riverside Drive | Apartment 12C | New York | NY | |
24472 | 24472 | 1975-07-30 | 1958-04-07 | Joslyn | Roger | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
26492 | 26492 | 1982-08-12 | 1978-08-11 | Cyr | Roger | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
27916 | 27916 | 1976-08-31 | 1976-03-25 | Shelley | Roger | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
39609 | 39609 | 1957-12-31 | 1944-07-31 | Beaucaire | Roger | Agence France-Presse (France-Presse News Agency) 223 | 1943-12-02 | Agence France-Presse (France-Presse News Agency) | 50 Rockefeller Plaza | New York | NY | 10020 | |
39900 | 39900 | 1971-12-31 | 1970-09-16 | Therien | Roger | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
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]) );