FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "New York" and Short_Form_First_Name = "Lawrence"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 12
- White & Case, LLP 2
- Universal Trading Corporation 1
- Ruder Finn, Inc. 1
- Artley, Inc. 1
- Savage, John 1
- Singapore Economic Development Board 1
- LKP/Sapan, Inc. 1
- LKP International, Ltd. 1
- ACTS for Israel 1
- Hong Kong Economic & Trade Office 1
- Friends of Sinn Fein, Inc. 1
- Filangiere Society for Justice and Good Government 1
Registrant_Name 12
- White & Case, LLP 2
- ACTS for Israel 1
- Artley, Inc. 1
- Filangiere Society for Justice and Good Government 1
- Friends of Sinn Fein, Inc. 1
- Hong Kong Economic & Trade Office 1
- LKP International, Ltd. 1
- LKP/Sapan, Inc. 1
- Ruder Finn, Inc. 1
- Savage, John 1
- Singapore Economic Development Board 1
- Universal Trading Corporation 1
State 1
- NY 13
City 1
- New York · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4741 | 4741 | 1959-01-29 | 1947-04-04 | Morris | Lawrence | Universal Trading Corporation 450 | 1947-04-04 | Universal Trading Corporation | 630 Fifth Avenue | New York | NY | ||
10087 | 10087 | 2012-03-16 | 1995-04-03 | Downes | Lawrence | Friends of Sinn Fein, Inc. 5006 | 1995-04-03 | Friends of Sinn Fein, Inc. | 1212 Avenue of the Americas | 5th Floor | New York | NY | 10036 |
11084 | 11084 | 2007-03-29 | 2004-12-22 | Chin | Lawrence | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
15308 | 15308 | 1964-05-01 | 1964-01-17 | Kane | Lawrence | Artley, Inc. 1681 | 1964-01-17 | Artley, Inc. | C/O Eugene J. Cohen | 405 East 56th Street | New York | NY | 10022 |
17415 | 17415 | 1974-05-30 | 1973-07-02 | Silverstein | Lawrence | LKP/Sapan, Inc. 2441 | 1973-07-02 | LKP/Sapan, Inc. | 767 Fifth Avenue | New York | NY | 10002 | |
18739 | 18739 | 1966-06-03 | 1966-01-17 | Kogen | Lawrence | Savage, John 1934 | 1965-10-28 | Savage, John | Crest Productions | 550 Fifth Avenue | New York | NY | 10036 |
25310 | 25310 | 2018-07-31 | 2018-01-24 | Auriana | Lawrence | Filangiere Society for Justice and Good Government 6513 | 2018-01-24 | Filangiere Society for Justice and Good Government | 17 Battery Place | 11th Floor | New York | NY | 10004 |
26831 | 26831 | 1991-08-16 | 1988-10-07 | Cohen | Lawrence | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29055 | 29055 | 2005-09-02 | 2005-04-14 | Byrne | Lawrence | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29202 | 29202 | 1975-09-05 | 1975-05-28 | Parish | Lawrence | ACTS for Israel 2587 | 1975-05-28 | ACTS for Israel | Post Office Box 1643 | New York | NY | 10001 | |
30521 | 30521 | 1985-09-26 | 1974-06-03 | Silverstein | Lawrence | LKP International, Ltd. 2514 | 1974-06-03 | LKP International, Ltd. | 767 Fifth Avenue | New York | NY | 10152 | |
38839 | 38839 | 1996-12-20 | 1990-04-11 | Chan | Lawrence | Hong Kong Economic & Trade Office 3880 | 1986-09-11 | Hong Kong Economic & Trade Office | 680 Fifth Avenue | 22nd Floor | New York | NY | 10019 |
40989 | 40989 | 1996-12-31 | 1986-10-01 | Wilson | Lawrence | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 |
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]) );