FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Address_1 = "New York" and Country/Location_Represented = "NORWAY"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 10
- Augay Enterprises, Inc. 1
- Billig, Sher & Jones, P.C. 1
- Burson-Marsteller 1
- Films of the Nations, Inc. 1
- International Council of Cruise Lines 1
- Norwegian Masters' Association Overseas Branch 1
- Patton, Blow, Verrill, Brand & Boggs 1
- Public Service Audience Planners 1
- Washington Policy & Analysis 1
- West Glen Communications 1
Registrant_Date (date) 10 ✖
- 1943-08-26 1
- 1946-04-22 1
- 1963-06-06 1
- 1967-07-25 1
- 1973-10-23 1
- 1979-08-23 1
- 1981-10-06 1
- 1982-02-02 1
- 1988-11-23 1
- 1989-01-27 1
Foreign_Principal 9
State 1
- NY 10
Country/Location_Represented 1
- NORWAY · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3542 | 3542 | 1984-03-09 | Norwegian-American Line | 1967-07-25 | NORWAY | International Council of Cruise Lines 2036 | 1967-07-25 | International Council of Cruise Lines | New York | NY | |||
7082 | 7082 | 1990-05-31 | Norwegian Tourist Board | 1988-11-23 | NORWAY | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
7565 | 7565 | 1986-06-04 | Barber West Africa Line | 1983-06-17 | NORWAY | Billig, Sher & Jones, P.C. 3279 | 1981-10-06 | Billig, Sher & Jones, P.C. | New York | NY | |||
7626 | 7626 | 1965-06-06 | Norwegian Mission to the United Nations | 1963-06-06 | NORWAY | Patton, Blow, Verrill, Brand & Boggs 1636 | 1963-06-06 | Patton, Blow, Verrill, Brand & Boggs | New York | NY | |||
10686 | 10686 | 1992-08-23 | Norwegian Information Service | 1981-09-29 | NORWAY | Public Service Audience Planners 2452 | 1979-08-23 | Public Service Audience Planners | New York | NY | |||
10748 | 10748 | 1945-08-26 | No foreign principal listed | 1943-08-26 | NORWAY | Norwegian Masters' Association Overseas Branch 204 | 1943-08-26 | Norwegian Masters' Association Overseas Branch | New York | NY | |||
11244 | 11244 | 1983-09-01 | Norwegian Information Service | 1982-02-02 | NORWAY | Augay Enterprises, Inc. 3328 | 1982-02-02 | Augay Enterprises, Inc. | New York | NY | |||
13404 | 13404 | 2001-10-31 | Royal Norwegian Consulate General New York | 1997-08-13 | NORWAY | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | New York | NY | |||
15577 | 15577 | 1957-12-31 | Norwegian Travel Information Bureau | 1946-04-22 | NORWAY | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | New York | NY | |||
16180 | 16180 | 1990-12-31 | Statoil North America, Inc. | 1989-09-22 | NORWAY | Washington Policy & Analysis 4211 | 1989-01-27 | Washington Policy & Analysis | 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]) );