FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
86 rows where "Foreign_Principal_Termination_Date" is on date 1995-12-31 and State = "" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name >30
- Squire Patton Boggs, LLP 6
- Preston, Gates & Ellis, L.L.P. 5
- Burson-Marsteller 4
- LeBoeuf, Lamb, Greene & MacRae, L.L.P. 4
- Hopkins & Sutter 3
- Mayer, Brown & Platt 3
- O'Connor & Hannan, L.L.P. 3
- Shaw, Pittman, Potts & Trowbridge 3
- Capital International Information Services, Inc. 2
- Connaught Laboratories, Inc. 2
- DLA Piper US LLP 2
- Dewey Ballantine 2
- Jones Day 2
- Winthrop, Stimson, Putnam & Roberts, Washington Office 2
- Brock Group 1
- Butera, James J. 1
- Cameron, Bruce P. 1
- Chlopak, Leonard, Schechter & Associates, Inc. 1
- Council of European & Japanese National Shipowners' Assn. 1
- Daimler-Benz Washington, Inc. 1
- Daniel J. Edelman, Inc. 1
- Davis & Harman 1
- DeLay, Randolph L. 1
- Dykema Gossett 1
- Fuji Bank, Ltd., Washington D.C. Representative Office 1
- Fujitsu, Ltd. 1
- GCI Group, Inc. 1
- Gold & Liebengood, Inc. 1
- Goodwin Procter, LLP 1
- Graham & James, L.L.P. 1
- …
Foreign_Principal >30
- Fujitsu, Ltd. 2
- Underwriters at Lloyd's, London 2
- Africa Resources Trust, Zimbabwe Trust 1
- Akitsu Shipping Company, Ltd. (formerly: Kyokuyo Company, Ltd.) 1
- Assicurazione Nazionale Imprese Assicuratrici 1
- Association of British Insurers 1
- Audiovisuale, Ministry of Communications (Formerly: Colombian Ministry of Foreign Affairs) 1
- Banca Quadrum, S.A. aka Servicios Financieros Quadrum, S.A. 1
- Boehringer Ingelheim Zentrale, GmbH 1
- CAMECO Corporation 1
- Camara Nacional de la Industria Pesquera (Canainpes) 1
- Canadian Steel Producers' Association 1
- Caribbean Banana Exporters Association 1
- Cemex, S.A. 1
- Central American & Caribbean Textile & Apparel Council 1
- Centro Industrial de Laboratorios Farmaceuticos Argentinos (CILFA) 1
- Chilean Exporters' Association 1
- Committee on U.S. Business, Canada Health & Life Insurance Association 1
- Compagnie Generale des Etablissements Michelin (CGEM) 1
- Connaught Laboratories, Ltd. 1
- Credit Lyonnais 1
- Daimler-Benz, A.G. 1
- Department of Finance, Government of Abu Dhabi 1
- Deutsche Bundespost Telekom 1
- Deutsche Lufthansa, A.G. 1
- Duty Free Shoppers Group, Ltd. 1
- EUROFER 1
- European Space Agency (ESA) 1
- Exportadora de Sal, S.A. de C.V. 1
- Federal Republic of Germany, Ministry of Economics 1
- …
Country/Location_Represented >30
- JAPAN 14
- CANADA 8
- GREAT BRITAIN 8
- GERMANY 7
- FRANCE 6
- HONG KONG 4
- ITALY 4
- MEXICO 4
- KOREA, SOUTH 3
- CHILE 2
- INTERNATIONAL 2
- RUSSIA 2
- SWITZERLAND 2
- UNITED ARAB EMIRATES 2
- ARGENTINA 1
- BAHRAIN 1
- BARBADOS 1
- BELGIUM 1
- BERMUDA 1
- COLOMBIA 1
- COSTA RICA 1
- GABON 1
- ISRAEL 1
- MOLDOVA 1
- NETHERLANDS 1
- NORWAY 1
- PAKISTAN 1
- PORTUGAL 1
- PORTUGUESE TIMOR 1
- SWEDEN 1
- …
State 1
- - · 86 ✖
City 1
- - 86
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16293 | 16293 | 1995-12-31 | Boehringer Ingelheim Zentrale, GmbH | 1987-04-03 | GERMANY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
16297 | 16297 | 1995-12-31 | Camara Nacional de la Industria Pesquera (Canainpes) | 1994-03-22 | MEXICO | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | |||||
16312 | 16312 | 1995-12-31 | Duty Free Shoppers Group, Ltd. | 1981-02-13 | HONG KONG | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | |||||
16316 | 16316 | 1995-12-31 | Federal Republic of Germany, Ministry of Economics | 1992-08-04 | GERMANY | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | |||||
16334 | 16334 | 1995-12-31 | Hong Kong Trade Development Council (TDC) | 1985-09-25 | HONG KONG | R. Duffy Wall & Associates, Inc. 3737 | 1985-09-25 | R. Duffy Wall & Associates, Inc. | |||||
16336 | 16336 | 1995-12-31 | Institute of International Bankers | 1975-02-21 | INTERNATIONAL | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | |||||
16370 | 16370 | 1995-12-31 | Societe Generale de Surveillance, S.A. | 1986-10-30 | SWITZERLAND | Goodwin Procter, LLP 3901 | 1986-10-30 | Goodwin Procter, LLP | |||||
16371 | 16371 | 1995-12-31 | United Distillers South-East Asia, Ltd., of Hong Kong (United) | 1991-12-02 | HONG KONG | Brock Group 4310 | 1989-10-23 | Brock Group | |||||
16309 | 16309 | 1995-12-31 | Department of Finance, Government of Abu Dhabi | 1990-12-27 | UNITED ARAB EMIRATES | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Abu Dhabi | ||||
16326 | 16326 | 1995-12-31 | Government of Abu Dhabi | 1992-03-10 | UNITED ARAB EMIRATES | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Abu Dhabi | ||||
16341 | 16341 | 1995-12-31 | Internationale Nederlanden Group, N.V. | 1993-11-30 | NETHERLANDS | Jones Day 3427 | 1982-12-10 | Jones Day | Amsterdam | ||||
16291 | 16291 | 1995-12-31 | Audiovisuale, Ministry of Communications (Formerly: Colombian Ministry of Foreign Affairs) | 1994-12-02 | COLOMBIA | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | Bogota | ||||
16310 | 16310 | 1995-12-31 | Deutsche Bundespost Telekom | 1994-11-07 | GERMANY | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Bonn | ||||
16285 | 16285 | 1995-12-31 | West Indies Rum & Spirits Producers' Association | 1987-11-13 | BARBADOS | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | Bridgetown | ||||
16313 | 16313 | 1995-12-31 | EUROFER | 1991-01-30 | BELGIUM | International Advisory Services Group, Ltd. 4267 | 1989-06-23 | International Advisory Services Group, Ltd. | Brussels | ||||
16301 | 16301 | 1995-12-31 | Centro Industrial de Laboratorios Farmaceuticos Argentinos (CILFA) | 1995-06-02 | ARGENTINA | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | Buenos Aires | ||||
16303 | 16303 | 1995-12-31 | Compagnie Generale des Etablissements Michelin (CGEM) | 1987-09-15 | FRANCE | Michelin North America, Inc. 4037 | 1987-09-15 | Michelin North America, Inc. | Clermont-Ferrand | ||||
16311 | 16311 | 1995-12-31 | Deutsche Lufthansa, A.G. | 1994-02-14 | GERMANY | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Cologne | ||||
16363 | 16363 | 1995-12-31 | Rhone-Poulenc, S.A. | 1988-11-21 | FRANCE | Rhone-Poulenc, Inc. 4188 | 1988-11-21 | Rhone-Poulenc, Inc. | Courbevoie | ||||
16367 | 16367 | 1995-12-31 | Schnell-Bruter-Kernkraftwerksgesellschaft, MbH (SBK) | 1993-08-03 | GERMANY | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | Essen | ||||
16373 | 16373 | 1995-12-31 | World Federation of United Nations Associations: The Foundation for the 15th Anniversary of the United Nations | 1994-11-09 | GREAT BRITAIN | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Geneve | ||||
16366 | 16366 | 1995-12-31 | Scheidt & Bachmann, GmbH | 1993-07-02 | GERMANY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Gladbach | ||||
16281 | 16281 | 1995-12-31 | Swedish Shipowners' Association | 1994-12-05 | SWEDEN | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Gothenburg | ||||
16315 | 16315 | 1995-12-31 | Exportadora de Sal, S.A. de C.V. | 1995-07-06 | MEXICO | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Guerrero Negro | ||||
16374 | 16374 | 1995-12-31 | XL Insurance Company, Ltd. | 1994-06-20 | BERMUDA | Vinson & Elkins, L.L.P. 4921 | 1994-06-20 | Vinson & Elkins, L.L.P. | Hamilton | ||||
16287 | 16287 | 1995-12-31 | Africa Resources Trust, Zimbabwe Trust | 1995-04-14 | ZIMBABWE | Law Office of Richard Littell 5015 | 1995-04-14 | Law Office of Richard Littell | Harare | ||||
16332 | 16332 | 1995-12-31 | H.P. Bulmer Holding, PLC | 1995-03-27 | GREAT BRITAIN | Keck, Mahin & Cate 5032 | 1995-03-27 | Keck, Mahin & Cate | Hereford | ||||
16335 | 16335 | 1995-12-31 | Hotung Institute | 1995-12-01 | HONG KONG | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Hong Kong | ||||
16328 | 16328 | 1995-12-31 | Government of Pakistan | 1995-01-30 | PAKISTAN | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Islamabad | ||||
16292 | 16292 | 1995-12-31 | Banca Quadrum, S.A. aka Servicios Financieros Quadrum, S.A. | 1993-11-30 | MEXICO | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Jardines-Montana | ||||
16355 | 16355 | 1995-12-31 | Mircea Snegur, President of the Republic of Moldova | 1993-03-31 | MOLDOVA | Hall, Dickler, Kent, Friedman & Wood, L.L.P. 4537 | 1991-07-08 | Hall, Dickler, Kent, Friedman & Wood, L.L.P. | Kishinev | ||||
16339 | 16339 | 1995-12-31 | International Olympic Committee | 1993-07-26 | SWITZERLAND | Levine & Company 3971 | 1987-04-29 | Levine & Company | Lausanne | ||||
16327 | 16327 | 1995-12-31 | Government of Gabon | 1995-01-18 | GABON | Herman J. Cohen & Associates 4952 | 1994-09-27 | Herman J. Cohen & Associates | Libreville | ||||
16329 | 16329 | 1995-12-31 | Government of Portugal (Foreign Ministry) | 1994-08-25 | PORTUGAL | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Lisboa | ||||
16345 | 16345 | 1995-12-31 | Jose Ramos Horta | 1992-12-11 | PORTUGUESE TIMOR | Cameron, Bruce P. 4043 | 1987-09-28 | Cameron, Bruce P. | Lisbon | ||||
16277 | 16277 | 1995-12-31 | Membership of Council of European & Japanese National Shipowners' Association (CENSA) | 1995-09-14 | GREAT BRITAIN | Council of European & Japanese National Shipowners' Assn. 5045 | 1995-09-14 | Council of European & Japanese National Shipowners' Assn. | London | ||||
16283 | 16283 | 1995-12-31 | Underwriters at Lloyd's, London | 1987-11-09 | GREAT BRITAIN | Davis & Harman 4018 | 1987-07-28 | Davis & Harman | London | ||||
16284 | 16284 | 1995-12-31 | Underwriters at Lloyd's, London | 1987-11-10 | GREAT BRITAIN | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | London | ||||
16290 | 16290 | 1995-12-31 | Association of British Insurers | 1991-08-16 | GREAT BRITAIN | Hopkins & Sutter 4362 | 1990-04-11 | Hopkins & Sutter | London | ||||
16338 | 16338 | 1995-12-31 | Institute of London Underwriters (ILU) | 1992-03-23 | GREAT BRITAIN | Hopkins & Sutter 4362 | 1990-04-11 | Hopkins & Sutter | London | ||||
16350 | 16350 | 1995-12-31 | London Insurance & Reinsurance Market Association | 1991-06-06 | GREAT BRITAIN | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | London | ||||
16330 | 16330 | 1995-12-31 | Government of the State of Bahrain | 1995-02-06 | BAHRAIN | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | Manama | ||||
16361 | 16361 | 1995-12-31 | Pasteur-Merieux Vaccin Serum | 1990-12-03 | FRANCE | Connaught Laboratories, Inc. 4129 | 1988-04-29 | Connaught Laboratories, Inc. | Marnes La Coquette | ||||
16298 | 16298 | 1995-12-31 | Caribbean Banana Exporters Association | 1995-03-03 | INTERNATIONAL | Winthrop, Stimson, Putnam & Roberts, Washington Office 4735 | 1992-12-10 | Winthrop, Stimson, Putnam & Roberts, Washington Office | Middlesex | ||||
16289 | 16289 | 1995-12-31 | Assicurazione Nazionale Imprese Assicuratrici | 1995-10-06 | ITALY | Hopkins & Sutter 4362 | 1990-04-11 | Hopkins & Sutter | Milano | ||||
16299 | 16299 | 1995-12-31 | Cemex, S.A. | 1995-06-19 | MEXICO | DeLay, Randolph L. 5024 | 1995-06-19 | DeLay, Randolph L. | Monterrey | ||||
16343 | 16343 | 1995-12-31 | JSB Inkombank | 1995-10-06 | RUSSIA | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Moscow | ||||
16357 | 16357 | 1995-12-31 | Most Group | 1995-02-23 | RUSSIA | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Moscow | ||||
16317 | 16317 | 1995-12-31 | Fiart Cantieri Italiani, S.p.A. | 1986-03-07 | ITALY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Napoli | ||||
16372 | 16372 | 1995-12-31 | Urdan Industries, Ltd. | 1992-12-01 | ISRAEL | Rafiah, Zvi 4736 | 1992-12-01 | Rafiah, Zvi | Netanya | ||||
16273 | 16273 | 1995-12-31 | Canadian Steel Producers' Association | 1994-08-15 | CANADA | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | Ontario | ||||
16306 | 16306 | 1995-12-31 | Connaught Laboratories, Ltd. | 1988-04-29 | CANADA | Connaught Laboratories, Inc. 4129 | 1988-04-29 | Connaught Laboratories, Inc. | Ontario | ||||
16352 | 16352 | 1995-12-31 | Manufacturers Life Insurance Company | 1984-01-19 | CANADA | Pietroski, Joseph J. 3550 | 1984-01-19 | Pietroski, Joseph J. | Ontario | ||||
16354 | 16354 | 1995-12-31 | Matsushita Electric Industrial Company | 1989-08-01 | JAPAN | Matsushita Electric Industrial Company, Ltd. 4275 | 1989-08-01 | Matsushita Electric Industrial Company, Ltd. | Osaka | ||||
16278 | 16278 | 1995-12-31 | Norwegian Shipowners' Association | 1991-11-01 | NORWAY | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Oslo | ||||
16331 | 16331 | 1995-12-31 | Grand Council of the Crees | 1995-06-20 | CANADA | Sierra Club Legal Defense Fund, Inc. 5026 | 1995-06-20 | Sierra Club Legal Defense Fund, Inc. | Ottawa, Ontario | ||||
16280 | 16280 | 1995-12-31 | Societe Natinale d'Etude et de Construction de Moteurs d'Aviation | 1994-02-04 | FRANCE | Van Fleet - Meredith Group 4891 | 1994-02-04 | Van Fleet - Meredith Group | Paris | ||||
16307 | 16307 | 1995-12-31 | Credit Lyonnais | 1995-06-15 | FRANCE | Butera, James J. 5075 | 1995-06-15 | Butera, James J. | Paris | ||||
16314 | 16314 | 1995-12-31 | European Space Agency (ESA) | 1993-01-26 | FRANCE | Ober, Kaler, Grimes & Shriver 4756 | 1993-01-26 | Ober, Kaler, Grimes & Shriver | Paris | ||||
16325 | 16325 | 1995-12-31 | Giancarlo Parretti | 1995-12-12 | ITALY | Royer & Babyak 5086 | 1995-12-12 | Royer & Babyak | Rome | ||||
16300 | 16300 | 1995-12-31 | Central American & Caribbean Textile & Apparel Council | 1993-06-14 | COSTA RICA | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. 4817 | 1993-06-14 | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. | San Jose | ||||
16274 | 16274 | 1995-12-31 | Chilean Exporters' Association | 1989-10-06 | CHILE | Lepon, McCarthy, White & Holzworth 4302 | 1989-10-06 | Lepon, McCarthy, White & Holzworth | Santiago | ||||
16324 | 16324 | 1995-12-31 | General Directorete for International Economic Relations of the Ministry of Foreign Affairs of the Republic of Chile | 1995-11-13 | CHILE | O'Neill & Athy, P.C. 5076 | 1995-11-13 | O'Neill & Athy, P.C. | Santiago | ||||
16296 | 16296 | 1995-12-31 | CAMECO Corporation | 1994-07-05 | CANADA | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | Saskatoon | ||||
16346 | 16346 | 1995-12-31 | Korea Foreign Trade Association | 1994-08-10 | KOREA, SOUTH | Washington Group 4332 | 1990-01-18 | Washington Group | Seoul | ||||
16347 | 16347 | 1995-12-31 | Korea Semiconductor Industry Association | 1992-12-10 | KOREA, SOUTH | Winthrop, Stimson, Putnam & Roberts, Washington Office 4735 | 1992-12-10 | Winthrop, Stimson, Putnam & Roberts, Washington Office | Seoul | ||||
16348 | 16348 | 1995-12-31 | Korean Iron & Steel Association | 1991-05-23 | KOREA, SOUTH | Capital International Information Services, Inc. 4472 | 1991-02-12 | Capital International Information Services, Inc. | Seoul | ||||
16342 | 16342 | 1995-12-31 | J.D. Irving | 1985-08-05 | CANADA | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | St. John New Brusn. | ||||
16308 | 16308 | 1995-12-31 | Daimler-Benz, A.G. | 1991-03-14 | GERMANY | Daimler-Benz Washington, Inc. 4485 | 1991-03-14 | Daimler-Benz Washington, Inc. | Stuttgart | ||||
16282 | 16282 | 1995-12-31 | Taiwanese Reichbanknote Creditors' Association | 1994-03-22 | TAIWAN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Taoyen City | ||||
16279 | 16279 | 1995-12-31 | Ontario Flue-Cured Tobacco Growers' Marketing Board | 1993-11-18 | CANADA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Tillsonburg, Ontario | ||||
16275 | 16275 | 1995-12-31 | Federation of Bankers' Associations of Japan | 1994-08-17 | JAPAN | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | Tokyo | ||||
16276 | 16276 | 1995-12-31 | Japan Automobile Manufacturers' Association, Inc., Tokyo | 1980-04-16 | JAPAN | Japan Automobile Manufacturers' Association, Inc. 3101 | 1980-04-15 | Japan Automobile Manufacturers' Association, Inc. | Tokyo | ||||
16288 | 16288 | 1995-12-31 | Akitsu Shipping Company, Ltd. (formerly: Kyokuyo Company, Ltd.) | 1992-03-31 | JAPAN | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | Tokyo | ||||
16320 | 16320 | 1995-12-31 | Fuji Bank, Ltd. | 1995-06-30 | JAPAN | Fuji Bank, Ltd., Washington D.C. Representative Office 5034 | 1995-06-30 | Fuji Bank, Ltd., Washington D.C. Representative Office | Tokyo | ||||
16322 | 16322 | 1995-12-31 | Fujitsu, Ltd. | 1991-02-12 | JAPAN | Capital International Information Services, Inc. 4472 | 1991-02-12 | Capital International Information Services, Inc. | Tokyo | ||||
16323 | 16323 | 1995-12-31 | Fujitsu, Ltd. | 1989-09-11 | JAPAN | Fujitsu, Ltd. 4288 | 1989-09-11 | Fujitsu, Ltd. | Tokyo | ||||
16344 | 16344 | 1995-12-31 | Japan Electronic Industry Development Association (JEIDA) | 1990-01-12 | JAPAN | Graham & James, L.L.P. 3275 | 1981-09-23 | Graham & James, L.L.P. | Tokyo | ||||
16353 | 16353 | 1995-12-31 | Maruhu Corporation (Maruha Kabushiki Haisha) (formerly: Taiyo Gyogyo Kabushiki Kaisha) | 1992-03-31 | JAPAN | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | Tokyo | ||||
16356 | 16356 | 1995-12-31 | Mitsubishi Electric Corporation | 1986-12-01 | JAPAN | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Tokyo | ||||
16359 | 16359 | 1995-12-31 | Nichiro Corporation | 1992-03-31 | JAPAN | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | Tokyo | ||||
16360 | 16360 | 1995-12-31 | Nissui Shipping Corporation | 1992-03-31 | JAPAN | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | Tokyo | ||||
16364 | 16364 | 1995-12-31 | Rokuchu Marine Corporation | 1992-03-31 | JAPAN | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | Tokyo | ||||
16365 | 16365 | 1995-12-31 | Sakura Bank, Ltd. | 1992-07-31 | JAPAN | Jones Day 3427 | 1982-12-10 | Jones Day | Tokyo | ||||
16302 | 16302 | 1995-12-31 | Committee on U.S. Business, Canada Health & Life Insurance Association | 1988-03-28 | CANADA | Dykema Gossett 4112 | 1988-03-28 | Dykema Gossett | Toronto, Ontario | ||||
16319 | 16319 | 1995-12-31 | Fiat, S.p.A. (combined with Fiat Washington, Inc.) | 1986-05-16 | ITALY | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Turin |
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]) );