home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

1,156 rows where Country/Location_Represented = "JAPAN"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name >30

  • Hill and Knowlton Strategies, LLC 31
  • NHK Cosmomedia America, Inc. 29
  • Tanaka, Michele N. 27
  • Cosmo Public Relations 23
  • Arter, Hadden & Hemmendinger 22
  • Association of Japanese Textile Imports, Inc. 15
  • Marks, Murase & White 15
  • Ruder Finn, Inc. 15
  • Fleishman-Hillard, Inc. 13
  • Charles von Loewenfeldt, Inc. 12
  • Philip Van Slyck, Inc. 12
  • Anderson, Hibey & Blair 11
  • Daniel J. Edelman, Inc. 11
  • International Public Relations Company, Ltd. 11
  • Wilbur F. Monroe Associates, Inc. 11
  • Association Films, Inc. 10
  • Modern Education Services, Inc. 10
  • Arai, Yoneo 9
  • Bossowick, Irving 9
  • Civic Service, Inc. 9
  • Hastings, Jay Donald 9
  • Akin, Gump, Strauss, Hauer & Feld, LLP 8
  • Foster Garvey PC 8
  • Furudera, Robert H. 8
  • Global U.S.A., Inc. 8
  • McDermott, Will & Emery 8
  • Milbank, Tweed, Hadley & McCloy 8
  • North American Precis Syndicate 8
  • Steele, Donald Dickinson 8
  • Willkie, Farr & Gallagher 8
  • …

Foreign_Principal >30

  • Embassy of Japan 76
  • Japan External Trade Organization 22
  • Japan Trade Center 17
  • Japan Fisheries Association 16
  • Government of Japan 15
  • Japan External Trade Organization (JETRO) 11
  • Electronic Industries Association of Japan 10
  • Japan National Tourist Organization 10
  • Consulate General of Japan 9
  • Japan Iron & Steel Exporters' Association 9
  • U.S.-Japan Trade Council 9
  • Fujitsu, Ltd. 8
  • Hitachi, Ltd. 8
  • Japan Tobacco, Inc. 8
  • Government of Japan, Embassy 7
  • JETRO, New York 7
  • Japan Whaling Association 6
  • Sanyo Electric Company, Ltd. 6
  • Sony Corporation 6
  • Federation of Electric Power Companies of Japan 5
  • Japan Automobile Manufacturers' Association, Inc. 5
  • Japan Lumber Importers' Association 5
  • Matsushita Electric Industrial Company, Ltd. 5
  • Nippon Telegraph & Telephone Public Corporation 5
  • Consulate General of Japan, San Francisco 4
  • Hitachi America, Ltd. 4
  • International Public Relations Company, Ltd. 4
  • Japan Airlines Company, Ltd. 4
  • Japan Trade Center (JETRO) 4
  • Japanese National Railways 4
  • …

State 17

  • - 654
  • DC 145
  • NY 141
  • CA 59
  • TX 14
  • IL 13
  • WA 11
  • NJ 8
  • GA 5
  • AK 2
  • NH 2
  • OH 2
  • KY 1
  • MA 1
  • MI 1
  • MO 1
  • PA 1

City 13

  • - 1,002
  • Washington 35
  • Tokyo 8
  • New York 7
  • Boston 1
  • Chicago 1
  • Los Angeles 1
  • Osaka 1
  • San Francisco 1
  • Tokoyo 1
  • Toyko 1
  • Washington 1
  • Yokohama, Kanagawa 1

Country/Location_Represented 1

  • JAPAN · 1,061 ✖
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
1593 1593 1993-01-28 PR Service Company, Ltd. 1988-05-02 JAPAN Civic Service, Inc. 3385 1982-06-28 Civic Service, Inc. Tokyo        
1606 1606 1969-01-29 Government of Japan 1963-07-29 JAPAN Joyce Jr., William R. 1647 1963-07-29 Joyce Jr., William R. Washington     DC  
1610 1610 1990-01-29 Yamazaki Mazak Corporation 1989-11-30 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Aichi-Pref.        
1614 1614 2016-01-29 Fukuoka Prefectural Government 2003-12-02 JAPAN Fukuoka Center for Overseas Commerce in America 5591 2003-12-02 Fukuoka Center for Overseas Commerce in America 8        
1647 1647 1991-01-30 Nissan Motor Company, Ltd. 1979-08-09 JAPAN Manchester Associates, Ltd. 3046 1979-08-09 Manchester Associates, Ltd. Tokyo        
1663 1663 1957-01-31 Embassy of Japan 1954-08-20 JAPAN Brunner, Toby Emanuel Godfrey 842 1954-08-20 Brunner, Toby Emanuel Godfrey Washington     DC  
1688 1688 1969-01-31 Japan Trade Center (JETRO) 1968-01-06 JAPAN Steele, Donald Dickinson 2030 1967-06-20 Steele, Donald Dickinson San Francisco     CA  
1704 1704 1979-01-31 Mitsubishi Trust & Banking Corporation 1977-11-25 JAPAN Hendricks, Marshall L. 2848 1977-11-25 Hendricks, Marshall L.       NY  
1720 1720 1987-01-31 Federation of Japan Salmon Fisheries Cooperative Association 1983-10-28 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1722 1722 1987-01-31 Japan Fisheries Association 1985-10-09 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1724 1724 1987-01-31 National Common Squid Fishery Association 1985-10-09 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1725 1725 1987-01-31 National Driftnet Fishery Association 1985-10-09 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1726 1726 1987-01-31 National Salmon Drift-Net Fisheries Association 1985-10-09 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1727 1727 1987-01-31 Northern Seas Salmon Mothership Council 1983-10-28 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1733 1733 1989-01-31 Industrial Bank of Japan, Ltd. Los Angeles Agency 1988-12-28 JAPAN Coudert Brothers 3743 1985-10-02 Coudert Brothers Los Angeles     CA  
1740 1740 1990-01-31 Electronics Industries Association of Japan 1990-01-25 JAPAN Hi-Tech Public Relations, Inc. 4335 1990-01-25 Hi-Tech Public Relations, Inc. Tokyo        
1744 1744 1990-01-31 Fujitsu America 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe San Jose     CA  
1746 1746 1990-01-31 Nisshinbo California, Inc. 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe Fresno     CA  
1749 1749 1990-01-31 Sumiden Wire Products Corporation 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe Stockton     CA  
1750 1750 1990-01-31 Toyota Motor Sales U.S.A., Inc. 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe Washington     DC  
1767 1767 1992-01-31 NEC Corporation and its U.S. Subsidiary HNSX Supercomputers, Inc. 1991-07-10 JAPAN Jackson & Kelly 4540 1991-07-10 Jackson & Kelly Tokyo        
1769 1769 1992-01-31 Sanyo Fisher (U.S.A.) Corporation 1992-01-27 JAPAN Pillsbury, Madison & Sutro 4212 1989-01-27 Pillsbury, Madison & Sutro Chatsworth     CA  
1780 1780 1994-01-31 Mitsubishi Gas Chemical America, Inc. 1992-12-23 JAPAN Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt New York     NY  
1803 1803 1996-01-31 NEC Corporation & its U.S. Subsidiary, HNSX Supercomputers, Inc. 1991-07-09 JAPAN Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison Tokyo        
1805 1805 1996-01-31 Toyota Motor Corporate Services of North America 1992-07-27 JAPAN Van Ness, Feldman, A Professional Corporation 4696 1992-07-27 Van Ness, Feldman, A Professional Corporation New York     NY  
1811 1811 1997-01-31 World Cup Japan 2002 Bidding Committee Secretariat 1995-09-06 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tokyo        
1818 1818 1998-01-31 JETRO, New York 1996-07-31 JAPAN IBC New York, Inc. 5125 1996-07-31 IBC New York, Inc. New York     NY  
1831 1831 2001-01-31 Federation of Electric Power Companies of Japan 1994-06-22 JAPAN Federation of Electric Power Companies of Japan 4922 1994-06-22 Federation of Electric Power Companies of Japan Tokyo        
1832 1832 2001-01-31 Federation of Electric Power Companies of Japan 1997-06-30 JAPAN Porter/Novelli 4671 1992-05-18 Porter/Novelli Washington     DC  
1858 1858 2006-01-31 Government of Japan (Japan External Trade Organization) 2005-03-17 JAPAN Alexander Strategy Group 5557 2003-04-23 Alexander Strategy Group 1221 Avenue of the Americas New York 10020-1079     NY  
1924 1924 2019-01-31 Members of the National Diet of Japan 2018-07-20 JAPAN Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 2018-07-20 Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) Nagatacho Chiyoda-Ku Tokyo    
1991 1991 1979-02-01 Japan Trade Center 1971-12-15 JAPAN Ansberry, Louise S. 2297 1971-12-15 Ansberry, Louise S. New York     NY  
2005 2005 1984-02-01 Japan Silk & Synthetic Textile Exporters' Association 1983-09-09 JAPAN Marks, Murase & White 3419 1982-11-04 Marks, Murase & White Tokyo        
2010 2010 1984-02-01 Sumitomo Electric Industries, Ltd. 1983-12-06 JAPAN Marks, Murase & White 3419 1982-11-04 Marks, Murase & White Osaka        
2023 2023 1987-02-01 Hitachi, Ltd. 1985-08-08 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Tokyo        
2045 2045 1993-02-01 Japan Aviation Electronics Industry, Ltd. 1991-10-04 JAPAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tokyo        
2058 2058 2001-02-01 Federation of Electric Power Companies of Japan 1994-06-22 JAPAN Washington Policy & Analysis, Inc. 4611 1992-01-31 Washington Policy & Analysis, Inc. Tokyo        
2092 2092 1967-02-02 Japan Trade Center, Japan External Trade Organization 1964-01-03 JAPAN Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. New York     NY  
2103 2103 1971-02-02 Japan Umbrella Manufacturers' Association 1971-02-14 JAPAN Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger Tokyo        
2108 2108 1987-02-02 NYK Line 1985-08-02 JAPAN Rivkin, Radler, Dunne & Bayh 3711 1985-08-02 Rivkin, Radler, Dunne & Bayh New York     NY  
2129 2129 1961-02-03 Japan Tourist Association 1958-08-04 JAPAN Caples Company 34 1943-03-03 Caples Company New York     NY  
2167 2167 1992-02-03 Sanyo Electric Company, Ltd. 1992-02-03 JAPAN Sanyo Fisher (U.S.A.) Corporation 4612 1992-02-03 Sanyo Fisher (U.S.A.) Corporation Osaka        
2168 2168 1992-02-03 Sanyo Electric Company, Ltd. 1992-02-03 JAPAN Sanyo Audio Manufacturing (U.S.A.) Corporation 4613 1992-02-03 Sanyo Audio Manufacturing (U.S.A.) Corporation Osaka        
2186 2186 1985-02-04 Federation of Japan Tuna Fisheries Co-operative Associations 1981-12-30 JAPAN Anderson & Pendleton, C.A. 2696 1976-06-09 Anderson & Pendleton, C.A. Tokyo        
2187 2187 1985-02-04 Japan Tanner Crab Association 1981-10-02 JAPAN Anderson & Pendleton, C.A. 2696 1976-06-09 Anderson & Pendleton, C.A. Tokyo        
2192 2192 1993-02-04 Japan Airlines Company, Ltd. 1954-01-05 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
2258 2258 1985-02-07 Hakuhodo, Inc. 1984-12-19 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Washington     DC  
2276 2276 1979-02-08 Government of Japan, Japan Trade Center 1978-08-09 JAPAN Malmgren, Inc. 2854 1978-01-04 Malmgren, Inc. New York     NY  
2282 2282 1983-02-08 Japan Airlines Company, Ltd. 1968-05-23 JAPAN Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. Tokyo        
2293 2293 1989-02-08 Toyota Motor Company, Ltd. 1982-02-05 JAPAN Schnader, Harrison, Segal & Lewis 3330 1982-02-05 Schnader, Harrison, Segal & Lewis          
2314 2314 1967-02-09 Japan National Tourist Organization 1966-10-21 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
2319 2319 1984-02-09 Japan Lumber Importers' Association 1979-11-26 JAPAN Fasturn, Inc. 2944 1978-08-09 Fasturn, Inc. Tokyo        
2331 2331 1993-02-09 Japan Information Center 1992-10-13 JAPAN Barbara Burns & Associates, Inc. 4600 1991-12-06 Barbara Burns & Associates, Inc. New York     NY  
2335 2335 1994-02-09 NSK Corporation 1992-06-09 JAPAN Donohue & Donohue, Attorneys at Law 4681 1992-06-09 Donohue & Donohue, Attorneys at Law Ann Arbor     MI  
2354 2354 1992-02-10 Hokuten Trawlers' Association 1979-08-09 JAPAN Foster Garvey PC 3047 1979-08-09 Foster Garvey PC          
2355 2355 1992-02-10 Japan Deep Sea Trawlers' Association/Hokuten Trawlers Association 1979-08-09 JAPAN Foster Garvey PC 3047 1979-08-09 Foster Garvey PC          
2360 2360 1996-02-10 Sumitomo Corporation of America 1990-05-23 JAPAN Foster Garvey PC 3047 1979-08-09 Foster Garvey PC Washington     DC  
2369 2369 1955-02-11 Chen Chung-fu 1955-02-11 JAPAN Free China Political Organizations 871 1955-02-11 Free China Political Organizations Tokyo        
2414 2414 1993-02-12 Fuji Heavy Industries, Ltd. 1986-07-24 JAPAN Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Tokyo        
2482 2482 1984-02-14 Embassy of Japan 1972-02-16 JAPAN Runkle, Scott F. 2318 1972-02-16 Runkle, Scott F.          
2498 2498 1996-02-14 Electronics Industries Association of Japan, IC/User's Committees 1995-05-17 JAPAN McDermott, Will & Emery 4818 1993-06-22 McDermott, Will & Emery Tokyo        
2499 2499 1996-02-14 Japan Automobile Manufacturers' Association, Inc. 1993-06-14 JAPAN Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Tokyo        
2502 2502 1996-02-14 All Nippon Airways Company, Ltd. 1984-09-13 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Tokyo        
2511 2511 1996-02-14 Hitachi, Ltd. 1985-09-05 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Tokyo        
2517 2517 1996-02-14 Japan Federation of Construction Contractors, Inc. 1987-07-10 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Tokyo        
2519 2519 1996-02-14 Komatsu Corporation 1983-07-22 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Tokyo        
2520 2520 1996-02-14 Kyocera Corporation 1984-03-24 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Kyoto        
2620 2620 1989-02-17 Japan Society of Industrial Machinery Manufacturers 1988-05-12 JAPAN Marks, Murase & White 4141 1988-05-12 Marks, Murase & White Tokyo        
2693 2693 1993-02-21 Japan Atomic Energy Research Institute (JERI) 1992-10-19 JAPAN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Tokyo        
2734 2734 1995-02-23 Kawasho Corporation (Kawasho Construction) 1991-01-10 JAPAN TKC International, Inc. 3075 1979-12-13 TKC International, Inc. Tokyo        
2738 2738 1976-02-24 Japan External Trade Organization 1974-03-22 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
2739 2739 1981-02-24 Japan Trade Center, Agriculture and Fisheries Section 1973-03-06 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
2740 2740 1981-02-24 Utsunomiya, Tokuma 1978-11-28 JAPAN Royce, Richard Buhrman 2980 1978-11-28 Royce, Richard Buhrman Room 726, Dai-ichi Giin-kaikan Nagata-cho, Chiyoda-ku   Tokyo    
2746 2746 1988-02-24 Sony Corporation 1986-09-19 JAPAN Miller & Chevalier, Chartered 3626 1984-10-31 Miller & Chevalier, Chartered          
2780 2780 1974-02-25 Japan Development Bank 1965-01-11 JAPAN Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Tokyo        
2872 2872 1953-02-27 Kazuo Kamogawa, Representative, Council on Tuna Export of Japan 1952-01-25 JAPAN Baar, Bennett & Fullen 712 1952-01-25 Baar, Bennett & Fullen Beverly Hills     CA  
2876 2876 1978-02-27 Japan Machinery Exporters' Association & Fasteners Inst. of Japan 1978-04-17 JAPAN Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N.          
2921 2921 1976-02-28 Embassy of Japan 1957-02-21 JAPAN Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger Washington     DC  
2930 2930 1982-02-28 Government of Japan, Embassy of Japan 1981-03-11 JAPAN Gracey, Catherine E. 3212 1981-03-11 Gracey, Catherine E. Washington     DC  
2953 2953 1989-02-28 Mitsubishi Electronics America, Inc. 1988-03-03 JAPAN Kilpatrick & Cody 3610 1984-08-29 Kilpatrick & Cody Washington     DC  
2955 2955 1989-02-28 Onoda Cement Company, Ltd. 1981-07-08 JAPAN Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N.          
2973 2973 1991-02-28 Matsushita Electric Industrial Company, Ltd. 1990-10-18 JAPAN Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 1974-08-12 Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. Osaka        
3000 3000 1995-02-28 Japan Information Center - Consulate General of Japan in New York 1991-08-27 JAPAN Robin Cohn & Company 4553 1991-08-09 Robin Cohn & Company New York     NY  
3013 3013 1996-02-28 Mitsui Planning Company, Ltd. 1995-10-27 JAPAN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Joetsu-City, Niigata        
3014 3014 1996-02-28 NEC Corporation 1987-05-20 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Tokyo        
3020 3020 1997-02-28 Osaka Prefectural Government 1974-05-26 JAPAN JETRO, New York 1643 1963-06-25 JETRO, New York Osaka        
3029 3029 1999-02-28 Federation of Electric Power Companies of Japan 1995-02-14 JAPAN Denison, George H. 4991 1995-02-14 Denison, George H. Washington     DC  
3038 3038 2001-02-28 Japan Automobile Manufacturers' Association (JAMA) 1993-07-01 JAPAN Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. Washington     DC  
3043 3043 2001-02-28 Japanese Government Prime Ministers Office 2001-02-07 JAPAN Hakuhodo Incorporated 5409 2001-02-07 Hakuhodo Incorporated 1-6-1 Nagatacyo, Chiyoda-ku Tokyo 100-8914        
3072 3072 2006-02-28 Embassy of Japan 1983-03-08 JAPAN Saunders & Company 3440 1983-02-08 Saunders & Company Washington     DC  
3078 3078 2006-02-28 Seiko Epson Corporation 1989-06-14 JAPAN Saunders & Company 3440 1983-02-08 Saunders & Company Nagano-ken        
3081 3081 2007-02-28 East Japan Railway Company 2006-07-21 JAPAN Samuels International Associates, Inc. 4848 1993-08-26 Samuels International Associates, Inc. 2-2-2 Yoyogi Shibuya-Ku   Tokoyo    
3083 3083 2007-02-28 Government of Japan, Embassy 2006-07-26 JAPAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
3141 3141 2021-02-28 Embassy of Japan 2020-08-04 JAPAN Seven Letter 6847 2020-08-04 Seven Letter 2520 Massachusetts Avenue, NW   Washington DC 20008
3158 3158 2000-02-29 Japanese Government Prime Minister's Office 2000-02-18 JAPAN Hakuhodo Incorporated 5359 2000-02-18 Hakuhodo Incorporated 1-6-1 Nagatacho, Chiyoda-ku        
3160 3160 2000-02-29 Embassy of Japan 1971-05-07 JAPAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
3189 3189 1945-03-01 Hideshige Kashiwagi 1942-09-01 JAPAN Arai, Yoneo 110 1942-09-01 Arai, Yoneo Tokyo        
3190 3190 1945-03-01 Joshua Tomohiko Midzuno 1942-09-01 JAPAN Arai, Yoneo 110 1942-09-01 Arai, Yoneo Tokyo        
3191 3191 1945-03-01 Kohji Katoh 1942-09-01 JAPAN Arai, Yoneo 110 1942-09-01 Arai, Yoneo Tokyo        
3192 3192 1945-03-01 Meiji Fire Insurance Company 1942-09-01 JAPAN Arai, Yoneo 110 1942-09-01 Arai, Yoneo Tokyo        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 90.427ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows