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)

Suggested facets: Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)

Registrant_Name >30

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

Foreign_Principal >30

  • Embassy of Japan 94
  • Japan External Trade Organization 23
  • Japan Trade Center 18
  • Government of Japan 17
  • Japan External Trade Organization (JETRO) 16
  • Japan Fisheries Association 16
  • Japan National Tourist Organization 13
  • Electronic Industries Association of Japan 11
  • Consulate General of Japan 10
  • Hitachi, Ltd. 10
  • Japan Iron & Steel Exporters' Association 10
  • U.S.-Japan Trade Council 10
  • Fujitsu, Ltd. 9
  • Japan Tobacco, Inc. 8
  • Government of Japan, Embassy 7
  • JETRO, New York 7
  • Japan Automobile Manufacturers' Association, Inc. 6
  • Japan Whaling Association 6
  • Sanyo Electric Company, Ltd. 6
  • Sony Corporation 6
  • Federation of Electric Power Companies of Japan 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 Chemical Fibres Association 4
  • Japan Trade Center (JETRO) 4
  • …

State 17

  • - 712
  • DC 168
  • NY 150
  • CA 61
  • TX 14
  • IL 13
  • WA 11
  • NJ 8
  • GA 6
  • AK 3
  • MA 2
  • NH 2
  • OH 2
  • KY 1
  • MI 1
  • MO 1
  • PA 1

City 15

  • - 1,070
  • Washington 54
  • New York 10
  • Tokyo 10
  • Boston 2
  • Tokyo 1
  • Atlanta 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,156 ✖
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
124 124   Consulate General of Japan in Atlanta 2022-08-11 JAPAN Gilbert, Harrell, Sumerford & Martin 7155 2022-08-11 Gilbert, Harrell, Sumerford & Martin          
125 125   Consulate General of Japan in Atlanta 2018-10-15 JAPAN Freeman Mathis Decisions 6600 2018-10-15 Freeman Mathis Decisions 3438 Peachtree Road Phipps Tower, Suite 850 Atlanta GA 30326
126 126   Consulate General of Japan in Boston 2014-04-09 JAPAN Policy Agency, LLC 6213 2014-04-09 Policy Agency, LLC Federal Reserve Plaza, 22nd Floor 600 Atlantic Avenue   Boston MA 02210
127 127   Consulate General of Japan in New York 2021-03-30 JAPAN APCO Worldwide LLC 6582 2018-08-22 APCO Worldwide LLC 299 Park Avenue, Suite 19   New York NY 10171
128 128   Consulate General of Japan 2018-07-11 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 299 Park Avenue, 19th Floor   New York NY 10171
160 160   Embassy of Japan 2018-02-10 JAPAN Forbes Tate Partners LLC 6522 2018-02-10 Forbes Tate Partners LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
161 161   Embassy of Japan 2011-03-02 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
162 162   Embassy of Japan 2019-04-09 JAPAN Beacon Policy Advisors LLC 6658 2019-04-09 Beacon Policy Advisors LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
163 163   Embassy of Japan 2020-04-10 JAPAN Patrick,Griffin 6815 2020-04-10 Patrick,Griffin 2520 Massachusetts Avenue, NW   Washington DC 20008
164 164   Embassy of Japan 2020-04-10 JAPAN Tiber Creek Group, Inc. 6816 2020-04-10 Tiber Creek Group, Inc. 2520 Massachusetts Avenue, NW   Washington DC 20008
165 165   Embassy of Japan 2023-04-14 JAPAN Ballard Partners 7070 2022-01-13 Ballard Partners 2520 Massachusetts Ave, NW   Washington DC 20008
166 166   Embassy of Japan 2015-04-16 JAPAN Daschle Group, LLC 6280 2015-03-16 Daschle Group, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
167 167   Embassy of Japan 2001-04-19 JAPAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100        
168 168   Embassy of Japan 2023-04-21 JAPAN theGroup DC, LLC 6388 2016-10-28 theGroup DC, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
170 170   Embassy of Japan 2017-04-26 JAPAN S-3 Group 6422 2017-04-26 S-3 Group 2520 Massachusetts Avenue, NW   Washington DC 20008
171 171   Embassy of Japan 2015-05-08 JAPAN Holland & Knight 3718 1985-08-07 Holland & Knight 2520 Massachusetts Avenue, NW   Washington DC 20008
172 172   Embassy of Japan 2015-05-16 JAPAN Greenfield Law, LLC 6294 2015-05-16 Greenfield Law, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
173 173   Embassy of Japan 2018-05-18 JAPAN RSC Services International LLC 6554 2018-05-18 RSC Services International LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
174 174   Embassy of Japan 2015-09-18 JAPAN Alignment Government Strategies 6317 2015-09-18 Alignment Government Strategies 2520 Massachusetts Avenue, NW   Washington DC 20008
175 175   Embassy of Japan 2013-11-08 JAPAN Parvin, C. Landon 6194 2013-11-08 Parvin, C. Landon 2520 Massachusetts Avenue, NW   Washington DC  
266 266   Global Guardian Trust 2010-09-30 JAPAN Foster Garvey PC 3047 1979-08-09 Foster Garvey PC Akatsuka Bldg 3F 1-2-8 Higashikanda Chiyoda-ku, Tokyo      
285 285   Government of Japan - Japan External Trade Organization 2017-04-19 JAPAN Prism Strategy, Inc. 6419 2017-04-19 Prism Strategy, Inc. 565 Fifth Avenue 4th Floor New York NY 10017
286 286   Government of Japan 2023-05-10 JAPAN Hunton Andrews Kurth LLP 7268 2023-05-10 Hunton Andrews Kurth LLP 2520 Massachusetts Avenue NW   Washington DC 20008
287 287   Government of Japan 2001-08-03 JAPAN Hecht, Latham, Spencer & Associates, Inc. 5451 2001-08-03 Hecht, Latham, Spencer & Associates, Inc. 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100        
324 324   Harada International Law Office 2022-04-18 JAPAN Ho, Jason 7109 2022-04-18 Ho, Jason Nippo Yaesu Building 2nd Floor, 2-5-8 Yaesu, Chuoku   Tokyo    
346 346   Institute of Cetacean Research 2018-07-31 JAPAN Butterfield Evans & Associates, LLC 6579 2018-07-31 Butterfield Evans & Associates, LLC 4-5 Toyomi-cho, Chuo-ku, Tokyo 104-0055        
364 364   JNG Shareholders Group 1993-12-10 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc.          
365 365   JTB Communication Design, Inc. 2023-07-07 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Celestine Shiba Mitsui Bldg. 12F, 3-23-1 Shiba, MinatoKu   Tokyo    
368 368   Japan External Trade Organization (JETRO) 1965-02-02 JAPAN JETRO, Chicago 1850 1965-02-02 JETRO, Chicago Tokyo        
369 369   Japan External Trade Organization (JETRO) 1971-09-20 JAPAN JETRO, Houston 2277 1971-09-20 JETRO, Houston Tokyo        
370 370   Japan External Trade Organization (JETRO) 1964-11-05 JAPAN JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco Tokyo        
371 371   Japan External Trade Organization (JETRO) 1987-12-01 JAPAN JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta Tokyo        
372 372   Japan External Trade Organization (JETRO) 1964-12-14 JAPAN JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles Tokyo        
373 373   Japan External Trade Organization 1963-06-25 JAPAN JETRO, New York 1643 1963-06-25 JETRO, New York Tokyo        
374 374   Japan National Tourism Organization 1972-07-03 JAPAN Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles Tokyo        
375 375   Japan National Tourist Organization 1953-05-26 JAPAN Japan National Tourism Organization 769 1953-05-26 Japan National Tourism Organization Tokyo        
376 376   Japan National Tourist Organization 2021-11-29 JAPAN Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC          
377 377   Japanese National Tourism Organization through All Nippon Airways 2021-12-06 JAPAN Harris, Waheeda 7053 2021-12-06 Harris, Waheeda          
389 389   Kanagawa Prefectural Government 2006-02-01 JAPAN JETRO, New York 1643 1963-06-25 JETRO, New York 1 Nihon Odori Naka-ku Yokohama-city, Kanagawa-Pref. 231-8588        
400 400   Kobe Municipal Government 1973-07-02 JAPAN Kobe Trade Information Office 2438 1973-07-02 Kobe Trade Information Office Kobe City        
420 420   Kyoto Convention & Visitors Bureau 2018-04-30 JAPAN Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC Karasuma Ebisugawa Nakagyo-ku Kyoto 604-0862      
450 450   Manufactured Imports and Investment Promotion Organization (MIPRO) 1981-02-05 JAPAN Manufactured Imports and Investment Promotion Organization (MIPRO) 3196 1981-02-05 Manufactured Imports and Investment Promotion Organization (MIPRO) Tokyo        
458 458   Ministry of Agriculture, Forestry and Fisheries, Governement of Japan 2023-05-18 JAPAN Keys Group, LLC 7274 2023-05-18 Keys Group, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
472 472   Ministry of Foreign Affairs of Japan Embassy 2019-05-28 JAPAN Prime Policy Group 6377 2016-09-19 Prime Policy Group          
542 542   Okinawa Prefectural Government of Japan 2015-12-23 JAPAN Okinawa Prefecture DC Office, Inc. 6332 2015-12-23 Okinawa Prefecture DC Office, Inc. 1-2-2 Izumizaki Naha City, Okinawa 900-0021        
543 543   Okinawa Prefecture 2015-06-03 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1101 Connecticut Avenue, NW Suite 450 Washington DC 20036
605 605   Revatron Co., Ltd. 2022-04-18 JAPAN Ho, Jason 7109 2022-04-18 Ho, Jason 5F Ginza Fugetsudo Building, 6-6-1 Ginza, Chuouku   Tokyo    
632 632   Shizuoka Prefectural Tourism Association 2019-05-22 JAPAN Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC 2F Mizunomori Bldg., 14-1 Minami-cho, Suraga-ku, Shizuoka 422-8067        
687 687   The Embassy of Japan in the U.S.A., Washington, DC 2020-03-04 JAPAN Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
718 718   Toyooka City Hall Tourism Division 2018-06-01 JAPAN Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC 2-4 Chuo-machi Toyooka City, Hyogo 668-8666      
776 776 1953-01-01 Japanese Government 1952-12-16 JAPAN Lykke-Wilkin & Associates 750 1952-12-16 Lykke-Wilkin & Associates Tokyo        
788 788 1963-01-01 Japan General Merchandise Exporters' Association 1962-03-07 JAPAN Forbes Research, Inc. 1197 1959-02-03 Forbes Research, Inc. New York     NY  
824 824 1978-01-01 Hitachi, Ltd. 1977-02-07 JAPAN Chapman, Clearwaters & Warren 2753 1977-02-07 Chapman, Clearwaters & Warren Tokyo        
831 831 1979-01-01 Japan Fisheries Association (Through Tele-Press Associates, New York) 1978-06-06 JAPAN Fraser Associates, Inc. 2844 1977-11-08 Fraser Associates, Inc. Tokyo        
845 845 1982-01-01 Consulate General of Japan, New York 1979-03-05 JAPAN Philip S. Goodman, Inc. 3003 1979-03-05 Philip S. Goodman, Inc.       NY  
855 855 1982-01-01 U.S.-Japan Trade Council 1975-08-01 JAPAN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
866 866 1984-01-01 Alaska Pulp & Resources Corporation 1983-03-02 JAPAN Hannaford Company, Inc. 2850 1977-11-29 Hannaford Company, Inc. Sitka     AK  
873 873 1985-01-01 Panama Canal Study Group 1983-02-01 JAPAN Richard V. Allen Company 3438 1983-02-01 Richard V. Allen Company cs        
875 875 1985-01-01 Takata Kojyo Company, Ltd. 1975-07-01 JAPAN Masaoka & Associates, Inc. 2521 1974-06-19 Masaoka & Associates, Inc. Tokyo        
890 890 1987-01-01 Hoya Corporation 1985-12-23 JAPAN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Tokyo        
891 891 1987-01-01 Japan Trade Center 1987-02-16 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
910 910 1988-01-01 New Japan Securities International, Inc. 1986-11-26 JAPAN Wilbur F. Monroe Associates, Inc. 2888 1978-04-20 Wilbur F. Monroe Associates, Inc. New York     NY  
923 923 1990-01-01 Japan Telescopes Manufacturers' Association 1983-11-03 JAPAN Masaoka & Associates, Inc. 2521 1974-06-19 Masaoka & Associates, Inc. Tokyo        
942 942 1992-01-01 Electronics Industries Association of Japan 1987-10-02 JAPAN Mudge, Rose, Guthrie, Alexander & Ferdon 3200 1981-02-18 Mudge, Rose, Guthrie, Alexander & Ferdon          
1068 1068 1991-01-04 Hitachi Research Institute 1989-05-31 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Tokyo        
1075 1075 1988-01-05 Japan Aluminum Federation 1985-12-31 JAPAN Mudge, Rose, Guthrie, Alexander & Ferdon 3200 1981-02-18 Mudge, Rose, Guthrie, Alexander & Ferdon Tokyo        
1113 1113 2000-01-06 Fujitsu, Ltd. 1987-10-02 JAPAN Michael Solomon Associates 3923 1987-01-06 Michael Solomon Associates Kanagana-ken        
1193 1193 1997-01-10 Nippon Steel Corporation 1989-03-28 JAPAN Steptoe & Johnson, L.L.P. 3975 1987-05-08 Steptoe & Johnson, L.L.P. Tokyo        
1196 1196 2010-01-10 Japan Iron & Steel Exporters' Association 1983-12-29 JAPAN Charles E. Butler & Associates 3544 1983-12-29 Charles E. Butler & Associates Tokyo        
1218 1218 1988-01-11 Honda Motor Company 1987-09-28 JAPAN Law Offices of John P. Sears 3584 1984-05-09 Law Offices of John P. Sears Tokyo        
1239 1239 1988-01-12 Embassy of Japan 1987-04-16 JAPAN Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Washington     DC  
1276 1276 2017-01-13 Embassy of Japan through Akin Gump Strauss Hauer & Feld, LLP 2014-09-09 JAPAN KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
1278 1278 1954-01-14 Embassy of Japan 1954-01-14 JAPAN Griggs, Elizabeth Haring 811 1954-01-14 Griggs, Elizabeth Haring Washington     DC  
1280 1280 1972-01-14 Japan National Tourist Organization 1966-01-14 JAPAN United World Films, Inc. 1952 1966-01-14 United World Films, Inc. New York     NY  
1312 1312 1970-01-15 Japan Chemical Fibres Association 1968-04-22 JAPAN Donald G. Lerch, Jr. & Company, Inc. 2089 1968-04-22 Donald G. Lerch, Jr. & Company, Inc. Tokyo        
1323 1323 1985-01-15 Japan Broadcasting Corporation 1971-07-29 JAPAN Japan Broadcasting Corporation 820 1954-03-15 Japan Broadcasting Corporation Tokyo        
1324 1324 1985-01-15 Nippon Hoso Kyokai (NHK) (Broadcasting Corporation of Japan) 1954-03-15 JAPAN Japan Broadcasting Corporation 820 1954-03-15 Japan Broadcasting Corporation Tokyo        
1326 1326 1987-01-15 Japan Machine Tool Builders' Association 1986-08-11 JAPAN Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Tokyo        
1327 1327 1987-01-15 Japan Machinery Exporters' Association 1986-08-11 JAPAN Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Tokyo        
1328 1328 1987-01-15 Japan Metal Forming Machine Builders' Association 1986-08-11 JAPAN Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Tokyo        
1330 1330 1987-01-15 Japan Forming Machinery Association 1986-09-17 JAPAN Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Tokyo        
1333 1333 1990-01-15 DCA Advertising, Inc. 1989-08-01 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe New York     NY  
1334 1334 1990-01-15 NEC Electronics, Inc. 1989-07-28 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe Mountain View     CA  
1335 1335 1992-01-15 Committee to Establish City of America (Through Perkins Coie) 1991-06-20 JAPAN Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Tokyo        
1384 1384 1984-01-17 Policy Study Group 1979-07-17 JAPAN Craig J. Spence & Associates, Inc. 3041 1979-07-17 Craig J. Spence & Associates, Inc.          
1403 1403 1997-01-18 Hitachi, Ltd. 1986-07-18 JAPAN Hitachi, Ltd. 3855 1986-07-18 Hitachi, Ltd. Tokyo        
1435 1435 1992-01-20 MCA, Inc. 1991-01-03 JAPAN Baker, Worthington, Crossley, Stansberry & Woolf 4397 1990-07-12 Baker, Worthington, Crossley, Stansberry & Woolf Universal City     CA  
1437 1437 1997-01-20 Japan Automobile Manufacturers' Association, Inc. 1993-01-19 JAPAN Law Offices of Robert K. Kelley 4754 1993-01-19 Law Offices of Robert K. Kelley Tokyo        
1448 1448 1993-01-21 Embassy of Japan 1992-04-24 JAPAN Clarke Judge Consultants 4654 1992-04-24 Clarke Judge Consultants Washington     DC  
1467 1467 1996-01-22 NEC Corporation 1987-04-10 JAPAN Manatt, Phelps & Phillips 3736 1985-09-20 Manatt, Phelps & Phillips Washington     DC  
1511 1511 1993-01-25 Fujitsu Microelectronics, Inc. - Fujitsu, Ltd. 1986-04-17 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Tokyo        
1512 1512 1993-01-25 Matsushita Electronics Corporation 1990-11-27 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Osaka        
1544 1544 2000-01-26 Electronic Industries Association of Japan 1993-08-16 JAPAN Schmertz Company, Inc. 4161 1988-07-26 Schmertz Company, Inc. Tokyo        
1556 1556 1984-01-27 House of Counselors, Japanese Diet 1984-01-09 JAPAN International Business-Government Counsellors, Inc. 3332 1982-02-12 International Business-Government Counsellors, Inc. Tokyo        
1560 1560 1994-01-27 Murata Machinery, Ltd. 1990-01-24 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Kyoto        
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        

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 219.029ms · 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