FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Address_1 = "Washington" and Country/Location_Represented = "INDIA"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Date (date) 21 ✖
- 1990-01-18 2
- 1951-10-25 1
- 1952-02-26 1
- 1952-05-05 1
- 1952-12-02 1
- 1961-02-27 1
- 1961-05-02 1
- 1964-04-14 1
- 1964-04-15 1
- 1964-07-24 1
- 1965-09-23 1
- 1971-07-23 1
- 1975-01-31 1
- 1977-10-12 1
- 1984-11-15 1
- 1985-12-10 1
- 1987-07-13 1
- 1989-02-27 1
- 1991-09-03 1
- 1996-03-04 1
- 1997-04-15 1
Registrant_Name 20
- Ganju, Janki N. 2
- Washington Group 2
- APCO Worldwide, Inc. 1
- American Continental Group 1
- Anna M. Rosenberg Associates 1
- Baker, Nelson, Williams & Mitchell 1
- Baron/Canning & Company, Inc. 1
- Bernays, Edward L. 1
- Boggs, J.C. 1
- Chase & Moss International, Inc. 1
- Checchi & Company 1
- Daniel J. Edelman, Inc. 1
- Dilworth, Paxson, Kalish, Kohn & Dilks 1
- Howard J. Rubenstein Associates, Inc. 1
- International Development Systems, Inc. 1
- North American Precis Syndicate 1
- Schaler, Butler & Associates 1
- Smith, Edwin S. 1
- Squire, Sanders & Dempsey, L.L.P. 1
- William Chasey 1
Foreign_Principal 9
State 1
- DC 22
Country/Location_Represented 1
- INDIA · 22 ✖
City 1
- - 22
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
6618 | 6618 | 1971-05-17 | Embassy of India | 1967-11-27 | INDIA | Checchi & Company 1713 | 1964-04-14 | Checchi & Company | Washington | DC | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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]) );