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 = "Sharma"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 9
- Indian Investment Centre 2
- Government of India Trade Centre, New York 1
- Government of India Tourist Office, Chicago 1
- India Trade Promotion Organization 1
- Hill and Knowlton Strategies, LLC 1
- DLA Piper US LLP 1
- Madison Government Affairs 1
- Covington & Burling, LLP 1
- Waxman Consulting, Inc. DBA Waxman Strategies 1
Registrant_Name 9
- Indian Investment Centre 2
- Covington & Burling, LLP 1
- DLA Piper US LLP 1
- Government of India Tourist Office, Chicago 1
- Government of India Trade Centre, New York 1
- Hill and Knowlton Strategies, LLC 1
- India Trade Promotion Organization 1
- Madison Government Affairs 1
- Waxman Consulting, Inc. DBA Waxman Strategies 1
City 3
- Washington 5
- New York 4
- Chicago 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015 | 3015 | 2021-01-01 | 2020-06-12 | Sharma | Asha Renee | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 1150 Connecticut Avenue, NW | Suite 800 | Washington | DC | 20036 |
4024 | 4024 | 1988-01-18 | 1984-09-13 | Sharma | S.V.S. | Indian Investment Centre 2435 | 1973-06-12 | Indian Investment Centre | 445 Park Avenue | New York | NY | 10022 | |
7485 | 7485 | 2005-02-23 | 2004-09-01 | Sharma | Kapil | Madison Government Affairs 5642 | 2004-09-01 | Madison Government Affairs | 444 North Capitol Street, N.W. | Suite 545 | Washington | DC | 20001 |
18516 | 18516 | 2000-06-01 | 1998-09-23 | Sharma | Kapil | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
21146 | 21146 | 1991-06-30 | 1990-02-14 | Sharma | C.K. | Indian Investment Centre 2435 | 1973-06-12 | Indian Investment Centre | 445 Park Avenue | New York | NY | 10022 | |
24591 | 24591 | 2010-07-30 | 2007-12-04 | Sharma | Prabhat Chandra | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
30165 | 30165 | 2012-09-20 | 2012-03-30 | Sharma | Meena | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
34260 | 34260 | 1985-10-31 | 1984-12-11 | Sharma | A.C. | Government of India Tourist Office, Chicago 2398 | 1972-12-27 | Government of India Tourist Office, Chicago | 5701 North Sheridan Road | Chicago | IL | 60660 | |
34594 | 34594 | 2010-10-31 | 2010-05-14 | Sharma | Anisha | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
37256 | 37256 | 1964-12-01 | 1962-05-15 | Sharma | Shri Narain | Government of India Trade Centre, New York 923 | 1955-12-01 | Government of India Trade Centre, New York | 19 East 49th Street | New York | NY |
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]) );