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 = "Singh"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 8
Registrant_Name 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1508 | 1508 | 2022-07-28 | Singh | Sindy | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 246 Fifth Avenue | New York | NY | 10001 | ||
2263 | 2263 | 2012-11-29 | Singh | Virendra | Commonwealth of Dominica Maritime Registry, Inc. 5334 | 1999-10-12 | Commonwealth of Dominica Maritime Registry, Inc. | 32 Washington Street | Fairhaven | MA | 02719 | ||
5570 | 5570 | 2020-01-31 | 2020-01-27 | Singh | Nirmala | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | |
7373 | 7373 | 1985-02-22 | 1983-07-08 | Singh | Sookdeo | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
8581 | 8581 | 2016-02-29 | 2015-02-25 | Singh | Aman | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
13071 | 13071 | 1984-04-10 | 1973-04-05 | Singh | K.B. | India Tourism, New York 2329 | 1972-04-05 | India Tourism, New York | 1270 Avenue of the Americas | Suite 303 | New York | NY | 10020-1700 |
15852 | 15852 | 2004-05-07 | 2003-05-27 | Singh | Harjiv | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
17474 | 17474 | 1995-05-30 | 1992-06-02 | Singh | Ranjett | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
24605 | 24605 | 2016-07-30 | 2019-05-30 | Singh | Nirmala | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | |
31015 | 31015 | 1988-09-30 | 1986-03-26 | Singh | Ranbir | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
32075 | 32075 | 2016-10-01 | 2013-05-13 | Singh | Lakhwinder | Commonwealth of Dominica Maritime Registry, Inc. 5334 | 1999-10-12 | Commonwealth of Dominica Maritime Registry, Inc. | 32 Washington Street | Fairhaven | MA | 02719 |
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]) );