FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Country/Location_Represented = "ROMANIA" and State = "NY"
This data as json, CSV (advanced)
Foreign_Principal 10
- Romanian National Tourist Office 5
- Embassy of Romania 1
- Embassy of the Socialist Republic of Romania, Office of the Economic Counsellor 1
- Embassy of the Socialist Republic of Romania, Office of the Economic Counselor 1
- Government of Romania 1
- Prime Minister, Government of Romania 1
- Romania Tourist Office 1
- Romanian Embassy/Commercial Ofice 1
- Romanian Ministry of Foreign Trade & Internat'l. Economic Cooperation/Embassy of the SRR Office of Economic Counselor 1
- Romanian Tourist Office 1
Registrant_Name 9
- North American Precis Syndicate 6
- Association Films, Inc. 1
- DCS Group 1
- Dutko Group Companies, Inc. 1
- Europican Marketing, Inc. 1
- Romanian Foreign Trade Promotion Office, Chicago 1
- Romanian Foreign Trade Promotion Office, Los Angeles 1
- Romanian Trade Promotion Office, Atlanta 1
- Romanian Trade Promotion Office, Houston 1
State 1
- NY · 14 ✖
Country/Location_Represented 1
- ROMANIA · 14 ✖
City 1
- - 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2682 | 2682 | 1979-02-20 | Romania Tourist Office | 1979-06-27 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
3640 | 3640 | 2002-03-11 | Government of Romania | 2002-05-01 | ROMANIA | Dutko Group Companies, Inc. 5452 | 2001-08-17 | Dutko Group Companies, Inc. | 200 East 38th Street New York 10016 | NY | |||
3780 | 3780 | 2002-03-15 | Prime Minister, Government of Romania | 2002-04-10 | ROMANIA | DCS Group 5493 | 2002-04-10 | DCS Group | Consulate General 200 East 38th Street New York 10016 | NY | |||
5200 | 5200 | 1985-04-12 | Embassy of Romania | 1984-11-13 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5647 | 5647 | 1989-04-28 | Romanian Ministry of Foreign Trade & Internat'l. Economic Cooperation/Embassy of the SRR Office of Economic Counselor | 1980-09-19 | ROMANIA | Romanian Trade Promotion Office, Houston 3149 | 1980-09-19 | Romanian Trade Promotion Office, Houston | New York | NY | |||
5648 | 5648 | 1989-04-28 | Embassy of the Socialist Republic of Romania, Office of the Economic Counsellor | 1973-08-09 | ROMANIA | Romanian Foreign Trade Promotion Office, Chicago 2446 | 1973-08-09 | Romanian Foreign Trade Promotion Office, Chicago | New York | NY | |||
5649 | 5649 | 1989-04-28 | Embassy of the Socialist Republic of Romania, Office of the Economic Counselor | 1974-03-06 | ROMANIA | Romanian Foreign Trade Promotion Office, Los Angeles 2447 | 1973-08-09 | Romanian Foreign Trade Promotion Office, Los Angeles | New York | NY | |||
10728 | 10728 | 1975-08-25 | Romanian Tourist Office | 1971-08-30 | ROMANIA | Europican Marketing, Inc. 2082 | 1968-02-25 | Europican Marketing, Inc. | New York | NY | |||
10955 | 10955 | 1981-08-31 | Romanian National Tourist Office | 1972-12-21 | ROMANIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | New York | NY | |||
12618 | 12618 | 1985-10-12 | Romanian National Tourist Office | 1985-03-18 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13025 | 13025 | 1989-10-25 | Romanian National Tourist Office | 1987-12-28 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13743 | 13743 | 1990-11-05 | Romanian National Tourist Office | 1990-06-21 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13744 | 13744 | 1990-11-05 | Romanian National Tourist Office | 1990-10-10 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
15923 | 15923 | 1984-12-31 | Romanian Embassy/Commercial Ofice | 1980-08-27 | ROMANIA | Romanian Trade Promotion Office, Atlanta 3143 | 1980-08-27 | Romanian Trade Promotion Office, Atlanta | NY |
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]) );