FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
120 rows where Country/Location_Represented = "INDIA"
This data as json, CSV (advanced)
Registrant_Name 20
- American Continental Group 1
- Boggs, J.C. 1
- Broadcast Planning Corporation 1
- Colby II, Whitney Coffin 1
- Daniel J. Edelman, Inc. 1
- Films of the Nations, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Howard J. Rubenstein Associates, Inc. 1
- Ispahani, Mirza Abolhassan 1
- Nawaz, Jehan Ara Shah 1
- North American Precis Syndicate 1
- Ogilvy Public Relations 1
- Ruder Finn, Inc. 1
- Schaler, Butler & Associates 1
- Smith, Edwin S. 1
- Squire Patton Boggs, LLP 1
- Tea Council of the U.S.A., Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Venable, LLP 1
- Washington Group 1
Registrant_Date (date) 19 ✖
- 1946-11-19 2
- 1946-04-22 1
- 1952-02-26 1
- 1952-05-05 1
- 1960-06-16 1
- 1961-09-27 1
- 1964-04-02 1
- 1965-02-10 1
- 1969-10-09 1
- 1977-10-12 1
- 1981-11-10 1
- 1984-11-15 1
- 1985-12-10 1
- 1990-01-18 1
- 1996-03-04 1
- 1997-04-15 1
- 2001-05-29 1
- 2010-11-16 1
- 2018-01-22 1
Foreign_Principal_Registration_Date (date) 19 ✖
- 1946-11-19 2
- 1946-04-22 1
- 1954-09-14 1
- 1954-12-22 1
- 1960-06-16 1
- 1964-06-08 1
- 1971-07-15 1
- 1980-11-20 1
- 1985-12-10 1
- 1992-10-13 1
- 1996-03-04 1
- 1997-04-21 1
- 1998-06-11 1
- 2005-10-24 1
- 2008-09-18 1
- 2010-06-25 1
- 2010-11-16 1
- 2018-01-22 1
- 2021-06-16 1
Foreign_Principal 11
- Government of India 5
- Embassy of India 3
- Government of India, Embassy 3
- Government of India Tourist Office 2
- Air India 1
- All India Muslim League 1
- All-India Muslim League 1
- Bharat Petroleum Corporation Limited 1
- Government of India Information Services 1
- Suzlon Energy Ltd. 1
- The Gem and Jewellery Export Promotion Council(GJEPC")" 1
City 4
- - 16
- Washington 2
- Mumbai 1
- Mumbia 1
Country/Location_Represented 1
- INDIA · 20 ✖
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13365 | 13365 | 1997-10-31 | Government of India, Embassy | 1997-04-21 | INDIA | Boggs, J.C. 5172 | 1997-04-15 | Boggs, J.C. | Washington | DC | |||
13869 | 13869 | 1992-11-10 | Government of India Tourist Office | 1992-10-13 | INDIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
14019 | 14019 | 2010-11-16 | Bharat Petroleum Corporation Limited | 2010-11-16 | INDIA | Colby II, Whitney Coffin 6007 | 2010-11-16 | Colby II, Whitney Coffin | Industrial & Commercial, SBU, 4th Floor, Bharat Bhavan | 4&6 Currimbhoy Road, Ballard Estates, | Mumbai | ||
14060 | 14060 | 1998-11-18 | Government of India, Embassy | 1996-03-04 | INDIA | American Continental Group 5097 | 1996-03-04 | American Continental Group | Washington | DC | |||
14066 | 14066 | 1946-11-19 | All India Muslim League | 1946-11-19 | INDIA | Ispahani, Mirza Abolhassan 396 | 1946-11-19 | Ispahani, Mirza Abolhassan | Daryagang, Delhi | ||||
14067 | 14067 | 1946-11-19 | All-India Muslim League | 1946-11-19 | INDIA | Nawaz, Jehan Ara Shah 395 | 1946-11-19 | Nawaz, Jehan Ara Shah | Daryaganj, Delhi | ||||
14370 | 14370 | 1986-11-30 | Government of India | 1985-12-10 | INDIA | Howard J. Rubenstein Associates, Inc. 3761 | 1985-12-10 | Howard J. Rubenstein Associates, Inc. | Washington | DC | |||
14566 | 14566 | 2017-11-30 | Government of India | 2018-01-22 | INDIA | Ogilvy Public Relations 6509 | 2018-01-22 | Ogilvy Public Relations | Ministry of Food Processing Industries Panchsheel Bhawan, August Kranti Marg | Khelgaon, New Delhi-110049 | |||
14758 | 14758 | 2010-12-02 | Embassy of India | 2008-09-18 | INDIA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2107 Massachusetts Avenue, NW | Washington | DC | 20008 | |
15170 | 15170 | 1961-12-16 | Government of India Tourist Office | 1960-06-16 | INDIA | Broadcast Planning Corporation 1371 | 1960-06-16 | Broadcast Planning Corporation | Janapath, New Delhi | ||||
15308 | 15308 | 1954-12-22 | Government of India | 1954-12-22 | INDIA | Schaler, Butler & Associates 718 | 1952-02-26 | Schaler, Butler & Associates | Washington | DC | |||
15536 | 15536 | 1954-12-31 | Embassy of India | 1954-09-14 | INDIA | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | Washington | DC | |||
15572 | 15572 | 1957-12-31 | Government of India Information Services | 1946-04-22 | INDIA | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | New York | NY | |||
15630 | 15630 | 1964-12-31 | Government of India | 1964-06-08 | INDIA | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
15803 | 15803 | 1978-12-31 | Government of India | 1971-07-15 | INDIA | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | New Delhi | ||||
16229 | 16229 | 1992-12-31 | Air India | 1980-11-20 | INDIA | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | Bombay | ||||
16435 | 16435 | 1998-12-31 | Government of India, Embassy | 1998-06-11 | INDIA | Washington Group 4332 | 1990-01-18 | Washington Group | Washington | DC | |||
16599 | 16599 | 2006-12-31 | Embassy of India | 2005-10-24 | INDIA | Venable, LLP 5435 | 2001-05-29 | Venable, LLP | 2107 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16699 | 16699 | 2011-12-31 | Suzlon Energy Ltd. | 2010-06-25 | INDIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 5th Floor, Godrej Millennium 9, Koregaon Park Road | Pune - 411 001 | |||
16912 | 16912 | 2021-12-31 | The Gem and Jewellery Export Promotion Council(GJEPC")" | 2021-06-16 | INDIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Office No. AW 1010 Tower A, G Block, Bharat Diamond | Bourse, Bandra- Kurla Complex, Bandra- East | Mumbia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );