FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Country/Location_Represented = "FRANCE" and Foreign_Principal = "French National Railroads" sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 10
Foreign_Principal 1
- French National Railroads · 11 ✖
Country/Location_Represented 1
- FRANCE · 11 ✖
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2373 | 2373 | 1965-02-11 | French National Railroads | 1964-05-05 | FRANCE | Byrde, Richard & Pound 1722 | 1964-05-05 | Byrde, Richard & Pound | New York | NY | |||
2374 | 2374 | 1974-02-11 | French National Railroads | 1971-08-06 | FRANCE | Baker & Hartel, Inc. 2273 | 1971-08-06 | Baker & Hartel, Inc. | New York | NY | |||
2467 | 2467 | 1971-02-14 | French National Railroads | 1964-06-25 | FRANCE | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
9706 | 9706 | 1969-07-31 | French National Railroads | 1965-01-13 | FRANCE | Mutch Haberman Howard, Inc. 1842 | 1965-01-13 | Mutch Haberman Howard, Inc. | New York | NY | |||
10866 | 10866 | 1947-08-31 | French National Railroads | 1946-10-17 | FRANCE | Foley & Statt 318 | 1945-08-31 | Foley & Statt | Paris | ||||
10918 | 10918 | 1981-08-31 | French National Railroads | 1971-08-24 | FRANCE | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | New York | NY | |||
11273 | 11273 | 1989-09-01 | French National Railroads | 1980-12-15 | FRANCE | Brasseau Advertising 3180 | 1980-12-15 | Brasseau Advertising | New York | NY | |||
12322 | 12322 | 1976-10-01 | French National Railroads | 1974-11-04 | FRANCE | Spiro & Associates, Inc. 2545 | 1974-11-04 | Spiro & Associates, Inc. | New York | NY | |||
12698 | 12698 | 1970-10-15 | French National Railroads | 1970-08-17 | FRANCE | Mutch Haberman Howard, Inc. 1842 | 1965-01-13 | Mutch Haberman Howard, Inc. | New York | NY | |||
14895 | 14895 | 1981-12-08 | French National Railroads | 1961-07-11 | FRANCE | J. Sutherland Gould Associates 1408 | 1960-11-04 | J. Sutherland Gould Associates | New York | NY | |||
16053 | 16053 | 1988-12-31 | French National Railroads | 1981-07-30 | FRANCE | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. |
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]) );