FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
34 rows where Country/Location_Represented = "INDIA" and State = "DC"
This data as json, CSV (advanced)
Registrant_Name >30
- Ganju, Janki N. 2
- Washington Group 2
- APCO Worldwide, Inc. 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- American Continental Group 1
- Anna M. Rosenberg Associates 1
- BGR Government Affairs, LLC 1
- Baker, Nelson, Williams & Mitchell 1
- Baron/Canning & Company, Inc. 1
- Bernays, Edward L. 1
- Boggs, J.C. 1
- Brownstein Hyatt Farber Schreck, LLP 1
- Chase & Moss International, Inc. 1
- Checchi & Company 1
- Cornerstone Government Affairs 1
- Daniel J. Edelman, Inc. 1
- DiNino Associates, LLC 1
- Dilworth, Paxson, Kalish, Kohn & Dilks 1
- Ferox Strategies LLC 1
- Herald Group, LLC 1
- Howard J. Rubenstein Associates, Inc. 1
- International Development Systems, Inc. 1
- North American Precis Syndicate 1
- Podesta Group, Inc. 1
- Rosen, Fred 1
- Schaler, Butler & Associates 1
- Smith, Edwin S. 1
- Squire Patton Boggs, LLP 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Venable, LLP 1
- …
Foreign_Principal_Registration_Date (date) >30 ✖
- 1994-01-25 2
- 2003-03-21 2
- 1949-08-04 1
- 1951-10-25 1
- 1954-09-14 1
- 1954-12-22 1
- 1961-02-27 1
- 1961-05-02 1
- 1964-04-15 1
- 1964-07-24 1
- 1965-09-23 1
- 1967-11-27 1
- 1969-07-03 1
- 1975-01-31 1
- 1981-09-23 1
- 1985-12-10 1
- 1989-02-27 1
- 1992-02-14 1
- 1992-10-13 1
- 1996-03-04 1
- 1997-04-21 1
- 1998-06-11 1
- 1998-07-09 1
- 2005-09-12 1
- 2005-10-24 1
- 2006-05-19 1
- 2008-09-18 1
- 2010-11-05 1
- 2017-11-29 1
- 2019-12-04 1
- …
Foreign_Principal 12
- Embassy of India 10
- Government of India, Embassy 7
- Republic of India 4
- Government of India 3
- Republic of India, Embassy 3
- Embassy of the Government of India 1
- Government of India Tourist Office 1
- Government of India, Embassy of India 1
- India Supply Mission 1
- Republic of India through Cornerstone Government Affairs, Inc. 1
- Republic of India, Embassy through Barbour Griffith & Rogers, LLC 1
- Union of India 1
City 2
- - 25
- Washington 9
State 1
- DC · 34 ✖
Country/Location_Represented 1
- INDIA · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
587 | 587 | Republic of India through Cornerstone Government Affairs, Inc. | 2019-12-06 | INDIA | DiNino Associates, LLC 6408 | 2017-03-14 | DiNino Associates, LLC | 2107 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
589 | 589 | Republic of India | 2019-12-04 | INDIA | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 2107 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
590 | 590 | Republic of India, Embassy | 2005-09-12 | INDIA | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 2107 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
2680 | 2680 | 1974-02-20 | Embassy of India | 1969-07-03 | INDIA | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | Washington | DC | |||
4305 | 4305 | 1961-03-31 | Embassy of India | 1961-02-27 | INDIA | Chase & Moss International, Inc. 1429 | 1961-02-27 | Chase & Moss International, Inc. | Washington | DC | |||
4562 | 4562 | 1998-03-31 | Government of India, Embassy | 1994-01-25 | INDIA | Washington Group 4332 | 1990-01-18 | Washington Group | Washington | DC | |||
6013 | 6013 | 2003-04-30 | Government of India, Embassy | 2003-03-21 | INDIA | Washington World Group, Ltd. 5016 | 1995-04-20 | Washington World Group, Ltd. | 2107 Massachusetts Avenue, N.W. 20008 | DC | |||
6618 | 6618 | 1971-05-17 | Embassy of India | 1967-11-27 | INDIA | Checchi & Company 1713 | 1964-04-14 | Checchi & Company | Washington | DC | |||
6681 | 6681 | 2018-05-20 | Republic of India | 2017-11-29 | INDIA | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 2107 Massachusetts Avenue, NW | Washington | DC | 20008 | |
6839 | 6839 | 1952-05-26 | Embassy of India | 1951-10-25 | INDIA | Bernays, Edward L. 690 | 1951-10-25 | Bernays, Edward L. | Washington | DC | |||
6910 | 6910 | 1995-05-29 | Embassy of India | 1975-01-31 | INDIA | Ganju, Janki N. 2555 | 1975-01-31 | Ganju, Janki N. | Washington | DC | |||
9027 | 9027 | 2022-07-05 | Republic of India | 2021-04-30 | INDIA | Ferox Strategies LLC 6922 | 2021-02-03 | Ferox Strategies LLC | 2107 Massachusetts Ave NW | Washington | DC | 20008 | |
9216 | 9216 | 1993-07-13 | Government of India, Embassy of India | 1992-02-14 | INDIA | International Development Systems, Inc. 4012 | 1987-07-13 | International Development Systems, Inc. | Washington | DC | |||
10726 | 10726 | 1961-08-25 | Government of India | 1961-05-02 | INDIA | Anna M. Rosenberg Associates 1443 | 1961-05-02 | Anna M. Rosenberg Associates | Washington | DC | |||
10868 | 10868 | 1949-08-31 | Government of India, Embassy | 1949-08-04 | INDIA | Rosen, Fred 577 | 1949-06-30 | Rosen, Fred | 2107 Massachusetts Avenue | DC | |||
11047 | 11047 | 1997-08-31 | Embassy of the Government of India | 1994-01-25 | INDIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Washington | DC | |||
11272 | 11272 | 1989-09-01 | Embassy of India | 1989-02-27 | INDIA | William Chasey 4221 | 1989-02-27 | William Chasey | Washington | DC | |||
11301 | 11301 | 2006-09-01 | Republic of India, Embassy through Barbour Griffith & Rogers, LLC | 2006-05-19 | INDIA | Herald Group, LLC 5751 | 2006-05-19 | Herald Group, LLC | 2017 Massachusetts Avenue, N.W. | Washington | DC | 20008 | |
11656 | 11656 | 2000-09-15 | Government of India, Embassy | 1998-07-09 | INDIA | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Washington | DC | |||
11771 | 11771 | 1966-09-23 | Embassy of India | 1965-09-23 | INDIA | Ganju, Janki N. 1927 | 1965-09-23 | Ganju, Janki N. | Washington | DC | |||
12158 | 12158 | 2004-09-30 | Republic of India, Embassy | 2003-03-21 | INDIA | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2107 Massachusetts Avenue, N.W. | DC | |||
12340 | 12340 | 1983-10-01 | Republic of India | 1981-09-23 | INDIA | Baron/Canning & Company, Inc. 2270 | 1971-07-23 | Baron/Canning & Company, Inc. | Washington | DC | |||
12438 | 12438 | 1966-10-02 | India Supply Mission | 1964-07-24 | INDIA | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | Washington | DC | |||
12483 | 12483 | 1966-10-05 | Union of India | 1964-04-15 | INDIA | Baker, Nelson, Williams & Mitchell 1714 | 1964-04-15 | Baker, Nelson, Williams & Mitchell | Washington | DC | |||
12781 | 12781 | 2017-10-16 | Republic of India, Embassy | 2010-11-05 | INDIA | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 2107 Massachusetts Avenue, NW | Washington | DC | 20008 | |
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 |
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]) );