FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

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

62 rows where Document_Type = "Informational Materials" and Foreign_Principal_Country = "JAPAN"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Country 1

  • JAPAN · 62 ✖

Document_Type 1

  • Informational Materials · 62 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
5119 5119 2023-01-12 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Okinawa Prefecture JAPAN https://efile.fara.gov/docs/6170-Informational-Materials-20230112-1097.pdf
5897 5897 2017-01-17 Rasky Baerlein Strategic Communications, Inc. Rasky Baerlein Strategic Communications, Inc. 6222 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6222-Informational-Materials-20170117-1.pdf
7011 7011 2017-01-23 Greenfield Law, LLC Greenfield Law, LLC 6294 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Informational-Materials-20170123-3.pdf
7026 7026 2018-01-23 6332 Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20180123-8.pdf
7035 7035 2018-01-23 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20180126-3.pdf
7580 7580 2022-01-25 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20220125-12.pdf
7718 7718 2017-01-26 6222 Rasky Baerlein Strategic Communications, Inc. 6222 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6222-Informational-Materials-20170126-8.pdf
8303 8303 2017-01-28 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20170128-1.pdf
8323 8323 2019-01-28 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20190128-9.pdf
8361 8361 2021-01-28 6332 Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20210128-10.pdf
8444 8444 2023-01-28 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20230128-14.pdf
8726 8726 2020-01-29 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20200129-7.pdf
9262 9262 2019-01-30 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20190130-5.pdf
10319 10319 2020-01-31 JETRO, Los Angeles JETRO, Los Angeles 1833 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1833-Informational-Materials-20200131-2.pdf
13720 13720 2021-02-02 1850 JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20210202-12.pdf
16746 16746 2017-02-16 Rasky Baerlein Strategic Communications, Inc. Rasky Baerlein Strategic Communications, Inc. 6222 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6222-Informational-Materials-20170216-2.pdf
17746 17746 2017-02-21 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20170221-2.pdf
18513 18513 2017-02-24 JETRO CHICAGO JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20170224-1.pdf
24141 24141 2018-03-01 Alignment Government Strategies Alignment Government Strategies 6317 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Informational-Materials-20180301-1.pdf
27893 27893 2018-03-14 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20180314-6.pdf
30015 30015 2017-03-22 Podesta Group, Inc. Podesta Group, Inc. 5926 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/5926-Informational-Materials-20170322-23.pdf
30022 30022 2018-03-22 DCI Group AZ, LLC DCI Group AZ, LLC 6278 Informational Materials   Embassy of Japan through Akin Gump Strauss Hauer & Feld LLP JAPAN https://efile.fara.gov/docs/6278-Informational-Materials-20180322-18.pdf
30023 30023 2018-03-22 DCI Group AZ, LLC DCI Group AZ, LLC 6278 Informational Materials   Embassy of Japan through Akin Gump Strauss Hauer & Feld LLP JAPAN https://efile.fara.gov/docs/6278-Informational-Materials-20180322-22.pdf
42098 42098 2020-04-22 JETRO, Houston JETRO, Houston 2277 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/2277-Informational-Materials-20200422-1.pdf
43483 43483 2023-04-27 NHK Cosmomedia America, Inc. NHK Cosmomedia America, Inc. 4490 Informational Materials   JNG Shareholders Group JAPAN https://efile.fara.gov/docs/4490-Informational-Materials-20230427-1.pdf
51540 51540 2023-05-12 Ogilvy Group LLC Ogilvy Group LLC 6797 Informational Materials   The Embassy of Japan in the U.S.A., Washington, DC JAPAN https://efile.fara.gov/docs/6797-Informational-Materials-20230512-10.pdf
51541 51541 2023-05-12 Ogilvy Group LLC Ogilvy Group LLC 6797 Informational Materials   The Embassy of Japan in the U.S.A., Washington, DC JAPAN https://efile.fara.gov/docs/6797-Informational-Materials-20230512-11.pdf
56331 56331 2020-05-30 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Informational Materials   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Informational-Materials-20200530-1.pdf
63904 63904 2017-06-09 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20170609-3.pdf
63972 63972 2022-06-09 Ogilvy Group LLC Ogilvy Group LLC 6797 Informational Materials   The Embassy of Japan in the U.S.A., Washington, DC JAPAN https://efile.fara.gov/docs/6797-Informational-Materials-20220609-5.pdf
74260 74260 2021-07-06 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20210706-13.pdf
75393 75393 2018-07-11 Quinn & Co. of NY LTD. Quinn & Co. of NY LTD. 6433 Informational Materials   Setouchi Tourism Authority through JTB Chugoku Shikoku Corp JAPAN https://efile.fara.gov/docs/6433-Informational-Materials-20180711-12.pdf
79068 79068 2023-07-26 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20230726-15.pdf
79270 79270 2020-07-27 6332 Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20200727-9.pdf
79349 79349 2022-07-27 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20220727-13.pdf
79617 79617 2017-07-28 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20170728-2.pdf
79662 79662 2021-07-28 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20210728-11.pdf
79729 79729 2023-07-28 Daniel J. Edelman, Inc. Daniel J. Edelman, Inc. 3634 Informational Materials   JTB Communication Design, Inc. JAPAN https://efile.fara.gov/docs/3634-Informational-Materials-20230728-209.pdf
80032 80032 2019-07-29 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Informational Materials   Okinawa Prefectural Government of Japan JAPAN https://efile.fara.gov/docs/6332-Informational-Materials-20190729-6.pdf
88545 88545 2019-08-19 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20190819-10.pdf
91456 91456 2020-08-31 1850 JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20200831-11.pdf
96652 96652 2022-09-09 Hill and Knowlton Strategies, LLC Hill and Knowlton Strategies, LLC 3301 Informational Materials   Japan National Tourism Organization ("JNTO") through ALL Nippon Airways Ltd. ("ANA") JAPAN https://efile.fara.gov/docs/3301-Informational-Materials-20220909-68.pdf
97326 97326 2019-09-12 6170 Mercury Public Affairs, LLC 6170 Informational Materials   Consulate General of Japan JAPAN https://efile.fara.gov/docs/6170-Informational-Materials-20190912-659.pdf
97327 97327 2019-09-12 6170 Mercury Public Affairs, LLC 6170 Informational Materials   Consulate General of Japan JAPAN https://efile.fara.gov/docs/6170-Informational-Materials-20190912-660.pdf
97524 97524 2018-09-13 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20180913-7.pdf
99902 99902 2019-09-23 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Consulate General of Japan JAPAN https://efile.fara.gov/docs/6170-Informational-Materials-20190923-186.pdf
100980 100980 2022-09-27 APCO Worldwide LLC APCO Worldwide LLC 6582 Informational Materials   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6582-Informational-Materials-20220927-20.pdf
101245 101245 2018-09-28 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20180928-8.pdf
101249 101249 2018-09-28 Reputation Partners, LLC Reputation Partners, LLC 6556 Informational Materials   Consulate-General of Japan in Chicago JAPAN https://efile.fara.gov/docs/6556-Informational-Materials-20180928-1.pdf
106637 106637 2017-10-04 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20171004-4.pdf
106638 106638 2017-10-04 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20171004-5.pdf
109898 109898 2020-10-19 JETRO, Houston JETRO, Houston 2277 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/2277-Informational-Materials-20201019-2.pdf
111221 111221 2021-10-25 JETRO, Houston JETRO, Houston 2277 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/2277-Informational-Materials-20211025-3.pdf
117758 117758 2020-11-05 Ogilvy Group LLC Ogilvy Group LLC 6797 Informational Materials   The Embassy of Japan in the U.S.A., Washington, DC JAPAN https://efile.fara.gov/docs/6797-Informational-Materials-20201105-3.pdf
117759 117759 2020-11-05 Ogilvy Group LLC Ogilvy Group LLC 6797 Informational Materials   The Embassy of Japan in the U.S.A., Washington, DC JAPAN https://efile.fara.gov/docs/6797-Informational-Materials-20201105-4.pdf
118733 118733 2022-11-10 Greenfield Law, LLC Greenfield Law, LLC 6294 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Informational-Materials-20221110-4.pdf
129014 129014 2017-12-04 Greenfield Law, LLC Greenfield Law, LLC 6294 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Informational-Materials-20171204-1.pdf
129401 129401 2018-12-06 Cogent Strategies LLC Cogent Strategies LLC 6502 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6502-Informational-Materials-20181206-12.pdf
130704 130704 2016-12-13 Rasky Baerlein Strategic Communications, Inc. Rasky Baerlein Strategic Communications, Inc. 6222 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6222-Informational-Materials-20161213-3.pdf
130988 130988 2021-12-14 JETRO, Chicago JETRO, Chicago 1850 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/1850-Informational-Materials-20211214-14.pdf
132041 132041 2017-12-19 Greenfield Law, LLC Greenfield Law, LLC 6294 Informational Materials   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Informational-Materials-20171219-2.pdf
132275 132275 2017-12-20 6170 Mercury Public Affairs, LLC 6170 Informational Materials   Okinawa Prefecture JAPAN https://efile.fara.gov/docs/6170-Informational-Materials-20171220-632.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_RegistrantDocs] (
   [Date_Stamped] TEXT,
   [Registrant_Name] TEXT,
   [Registration_Number] INTEGER,
   [Document_Type] TEXT,
   [Short_Form_Name] TEXT,
   [Foreign_Principal_Name] TEXT,
   [Foreign_Principal_Country] TEXT,
   [URL] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);