home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_RegistrantDocs

Table actions
  • GraphQL API for FARA_All_RegistrantDocs
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

18 rows where Registrant_Name = "Sachem Strategies, LLC" and Registration_Number = 6557

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Document_Type 6

  • Amendment 6
  • Short-Form 4
  • Exhibit AB 3
  • Supplemental Statement 3
  • Exhibit C 1
  • Registration Statement 1

Foreign_Principal_Name 2

  • - 15
  • Consulate General of the Republic of Korea 3

Foreign_Principal_Country 2

  • - 15
  • KOREA SOUTH 3

Registrant_Name 1

  • Sachem Strategies, LLC · 18 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
5911 5911 2019-01-17 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Amendment       https://efile.fara.gov/docs/6557-Amendment-20190117-4.pdf
5912 5912 2019-01-17 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Short-Form Upton, Mark W.     https://efile.fara.gov/docs/6557-Short-Form-20190117-6.pdf
51962 51962 2018-05-14 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Exhibit AB   Consulate General of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6557-Exhibit-AB-20180514-1.pdf
51963 51963 2018-05-14 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Exhibit C       https://efile.fara.gov/docs/6557-Exhibit-C-20180514-1.pdf
51964 51964 2018-05-14 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Registration Statement       https://efile.fara.gov/docs/6557-Registration-Statement-20180514-1.pdf
51965 51965 2018-05-14 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Short-Form Walton, Nathaniel Y.     https://efile.fara.gov/docs/6557-Short-Form-20180514-4.pdf
54235 54235 2018-05-23 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Short-Form Upton, Mark W.     https://efile.fara.gov/docs/6557-Short-Form-20180523-2.pdf
70186 70186 2019-06-30 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Supplemental Statement       https://efile.fara.gov/docs/6557-Supplemental-Statement-20190630-3.pdf
75404 75404 2019-07-11 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Short-Form Upton, Mark W.     https://efile.fara.gov/docs/6557-Short-Form-20190711-8.pdf
81465 81465 2019-07-31 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Amendment       https://efile.fara.gov/docs/6557-Amendment-20190731-5.pdf
108179 108179 2019-10-11 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Supplemental Statement       https://efile.fara.gov/docs/6557-Supplemental-Statement-20191011-4.pdf
110731 110731 2018-10-23 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Amendment       https://efile.fara.gov/docs/6557-Amendment-20181023-1.pdf
110732 110732 2018-10-23 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Amendment       https://efile.fara.gov/docs/6557-Amendment-20181023-2.pdf
110733 110733 2018-10-23 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Amendment       https://efile.fara.gov/docs/6557-Amendment-20181023-3.pdf
110734 110734 2018-10-23 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Exhibit AB   Consulate General of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6557-Exhibit-AB-20181023-2.pdf
110735 110735 2018-10-23 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Exhibit AB   Consulate General of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6557-Exhibit-AB-20181023-3.pdf
112245 112245 2019-10-29 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Amendment       https://efile.fara.gov/docs/6557-Amendment-20191029-6.pdf
135816 135816 2018-12-31 Sachem Strategies, LLC Sachem Strategies, LLC 6557 Supplemental Statement       https://efile.fara.gov/docs/6557-Supplemental-Statement-20181231-2.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])
);
Powered by Datasette · Queries took 741.555ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history