FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Foreign_Principal_Termination_Date = "1963-12-31"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 10
- Briggs, Walter Ladd 1
- Clinton E. Frank, Inc., New York 1
- Dahomey Philatelic Agency, Ltd. 1
- Fatoullah & Lazar, Inc. 1
- Geyer & Oswald, Inc. 1
- Ghana Philatelic Agency, Ltd. 1
- Maldivian Philatelic Agency, Ltd. 1
- Nigeria Philatelic Agency, Ltd. 1
- Saxton Graphic Associates, Ltd. 1
- Somalia Philatelic Agency, Ltd. 1
Foreign_Principal 10
- Consejo Nacional de Turismo Mexican National Tourist Council 1
- Federation of Nigeria (Consulate General of Nigeria) 1
- Government of Afghanistan, Post Office 1
- Government of Ghana 1
- Government of Maldive Islands 1
- Government of Somalia 1
- Nigerian Federal Ministry of Communications, Government of Nigeria 1
- Republic of Dahomey 1
- Republic of Korea, Government 1
- Yamaha International Corporation 1
Country/Location_Represented 9
- NIGERIA 2
- AFGHANISTAN 1
- DAHOMEY 1
- GHANA 1
- JAPAN 1
- KOREA, SOUTH 1
- MALDIVES 1
- MEXICO 1
- SOMALI DEMOCRATIC REPUBLIC 1
City 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15620 | 15620 | 1963-12-31 | Consejo Nacional de Turismo Mexican National Tourist Council | 1963-02-25 | MEXICO | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | New York | NY | |||
15621 | 15621 | 1963-12-31 | Federation of Nigeria (Consulate General of Nigeria) | 1963-08-22 | NIGERIA | Saxton Graphic Associates, Ltd. 1637 | 1963-06-07 | Saxton Graphic Associates, Ltd. | New York | NY | |||
15622 | 15622 | 1963-12-31 | Government of Afghanistan, Post Office | 1961-03-01 | AFGHANISTAN | Fatoullah & Lazar, Inc. 1430 | 1961-03-01 | Fatoullah & Lazar, Inc. | Kabul | ||||
15623 | 15623 | 1963-12-31 | Government of Ghana | 1958-01-20 | GHANA | Ghana Philatelic Agency, Ltd. 1108 | 1958-01-20 | Ghana Philatelic Agency, Ltd. | Accra | ||||
15624 | 15624 | 1963-12-31 | Government of Maldive Islands | 1960-05-27 | MALDIVES | Maldivian Philatelic Agency, Ltd. 1364 | 1960-05-27 | Maldivian Philatelic Agency, Ltd. | Colombo | ||||
15625 | 15625 | 1963-12-31 | Government of Somalia | 1960-03-16 | SOMALI DEMOCRATIC REPUBLIC | Somalia Philatelic Agency, Ltd. 1339 | 1960-03-16 | Somalia Philatelic Agency, Ltd. | Mogadescio | ||||
15626 | 15626 | 1963-12-31 | Nigerian Federal Ministry of Communications, Government of Nigeria | 1960-10-26 | NIGERIA | Nigeria Philatelic Agency, Ltd. 1404 | 1960-10-26 | Nigeria Philatelic Agency, Ltd. | |||||
15627 | 15627 | 1963-12-31 | Republic of Dahomey | 1960-04-18 | DAHOMEY | Dahomey Philatelic Agency, Ltd. 1354 | 1960-04-18 | Dahomey Philatelic Agency, Ltd. | Cotonau | ||||
15628 | 15628 | 1963-12-31 | Republic of Korea, Government | 1962-07-26 | KOREA, SOUTH | Briggs, Walter Ladd 1563 | 1962-07-26 | Briggs, Walter Ladd | Seoul | ||||
15629 | 15629 | 1963-12-31 | Yamaha International Corporation | 1963-02-28 | JAPAN | Geyer & Oswald, Inc. 1468 | 1961-08-01 | Geyer & Oswald, Inc. | Los Angeles |
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]) );