FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Registrant_Date" is on date 1943-12-01 sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date)
Foreign_Principal 10
- American Research Council 1
- Co-ordinator of Inter-American Affairs 1
- Hoy (Weekly) 1
- Knickerbocker Weekly (Dutch) 1
- Norte (Latin-American Monthly) 1
- Office of War Information 1
- Polish Information Center 1
- Pour la Victoire (Free French Weekly) 1
- United Nations Information Office 1
- Yugoslav Information Center 1
Country/Location_Represented 7
- UNKNOWN 4
- FRANCE 1
- HUNGARY 1
- MEXICO 1
- NETHERLANDS 1
- POLAND 1
- YUGOSLAVIA 1
Address_1 3 ✖
- New York 8
- Mexico City 1
- Washington 1
Registrant_Name 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7303 | 7303 | 1944-06-01 | American Research Council | 1943-12-01 | UNKNOWN | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | Washington | DC | |||
7304 | 7304 | 1944-06-01 | Co-ordinator of Inter-American Affairs | 1943-12-01 | UNKNOWN | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | New York | NY | |||
7305 | 7305 | 1944-06-01 | Hoy (Weekly) | 1943-12-01 | MEXICO | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | Mexico City | ||||
7306 | 7306 | 1944-06-01 | Knickerbocker Weekly (Dutch) | 1943-12-01 | NETHERLANDS | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | New York | NY | |||
7307 | 7307 | 1944-06-01 | Norte (Latin-American Monthly) | 1943-12-01 | UNKNOWN | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | New York | NY | |||
7308 | 7308 | 1944-06-01 | Office of War Information | 1943-12-01 | HUNGARY | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | New York | NY | |||
7309 | 7309 | 1944-06-01 | Polish Information Center | 1943-12-01 | POLAND | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | New York | NY | |||
7310 | 7310 | 1944-06-01 | Pour la Victoire (Free French Weekly) | 1943-12-01 | FRANCE | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | New York | NY | |||
7311 | 7311 | 1944-06-01 | United Nations Information Office | 1943-12-01 | UNKNOWN | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | New York | NY | |||
7312 | 7312 | 1944-06-01 | Yugoslav Information Center | 1943-12-01 | YUGOSLAVIA | Derso & Kelen 222 | 1943-12-01 | Derso & Kelen | New York | 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]) );