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

19 rows where Document_Type = "Exhibit AB" and Foreign_Principal_Name = "Consulate General of Japan in New York"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 1

  • Consulate General of Japan in New York · 19 ✖

Foreign_Principal_Country 1

Document_Type 1

  • Exhibit AB · 19 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
19407 19407 2020-02-27 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20200227-14.pdf
28449 28449 2012-03-16 Park Strategies, LLC Park Strategies, LLC 5908 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/5908-Exhibit-AB-20120316-8.pdf
29325 29325 2020-03-19 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20200319-15.pdf
32373 32373 2021-03-30 APCO Worldwide LLC APCO Worldwide LLC 6582 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6582-Exhibit-AB-20210330-11.pdf
37942 37942 2012-04-05 Park Strategies, LLC Park Strategies, LLC 5908 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/5908-Exhibit-AB-20120405-9.pdf
38836 38836 2022-04-08 APCO Worldwide LLC APCO Worldwide LLC 6582 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6582-Exhibit-AB-20220408-25.pdf
39356 39356 2023-04-10 APCO Worldwide LLC APCO Worldwide LLC 6582 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6582-Exhibit-AB-20230410-38.pdf
39736 39736 2016-04-12 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20160412-4.pdf
40759 40759 2015-04-16 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20150416-1.pdf
43809 43809 2023-04-28 APCO Worldwide LLC APCO Worldwide LLC 6582 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6582-Exhibit-AB-20230428-40.pdf
44097 44097 2020-04-29 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20200429-16.pdf
55517 55517 2015-05-28 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20150528-2.pdf
55527 55527 2019-05-28 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20190528-7.pdf
55528 55528 2019-05-28 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20190528-8.pdf
55529 55529 2019-05-28 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20190528-9.pdf
56245 56245 2017-05-30 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20170530-5.pdf
100966 100966 2021-09-27 APCO Worldwide LLC APCO Worldwide LLC 6582 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6582-Exhibit-AB-20210927-17.pdf
120943 120943 2020-11-20 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20201120-17.pdf
122328 122328 2018-11-28 Marathon Strategies, LLC Marathon Strategies, LLC 6289 Exhibit AB   Consulate General of Japan in New York JAPAN https://efile.fara.gov/docs/6289-Exhibit-AB-20181128-6.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])
);