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

147 rows where Registration_Number = 6522

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Name

Document_Type 7

  • Informational Materials 51
  • Short-Form 42
  • Amendment 22
  • Exhibit AB 20
  • Supplemental Statement 10
  • Exhibit C 1
  • Registration Statement 1

Foreign_Principal_Name 3

  • - 76
  • H.Q. Energy Services (U.S.) Inc. 65
  • Embassy of Japan 6

Foreign_Principal_Country 3

  • - 76
  • CANADA 65
  • JAPAN 6

Registrant_Name 2

  • Forbes Tate Partners LLC 135
  • 6522 12
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
3964 3964 2022-01-07 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Schaper, Nick     https://efile.fara.gov/docs/6522-Short-Form-20220107-76.pdf
4648 4648 2022-01-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Hynes, Patrick     https://efile.fara.gov/docs/6522-Short-Form-20220110-78.pdf
6268 6268 2021-01-19 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210119-3.pdf
6885 6885 2022-01-22 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20220122-44.pdf
13740 13740 2022-02-02 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20220202-46.pdf
15506 15506 2018-02-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6522-Exhibit-AB-20180210-2.pdf
15507 15507 2018-02-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit C       https://efile.fara.gov/docs/6522-Exhibit-C-20180210-1.pdf
15508 15508 2018-02-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Registration Statement       https://efile.fara.gov/docs/6522-Registration-Statement-20180210-1.pdf
15509 15509 2018-02-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Cooper, George     https://efile.fara.gov/docs/6522-Short-Form-20180210-6.pdf
15510 15510 2018-02-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Forbes, Jeffrey Alan     https://efile.fara.gov/docs/6522-Short-Form-20180210-8.pdf
15511 15511 2018-02-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Miller, Rachel Dora     https://efile.fara.gov/docs/6522-Short-Form-20180210-10.pdf
15512 15512 2018-02-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Schweer, Adrienne Noel     https://efile.fara.gov/docs/6522-Short-Form-20180210-4.pdf
15513 15513 2018-02-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Tate Jr., Daniel Clyde     https://efile.fara.gov/docs/6522-Short-Form-20180210-2.pdf
17035 17035 2022-02-17 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20220217-47.pdf
17264 17264 2022-02-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form O'Donnell, Michael Neil     https://efile.fara.gov/docs/6522-Short-Form-20220218-80.pdf
17265 17265 2022-02-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Pessel, Peter Lloyd     https://efile.fara.gov/docs/6522-Short-Form-20220218-82.pdf
27205 27205 2022-03-11 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20220311-48.pdf
28797 28797 2022-03-17 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20220317-49.pdf
29066 29066 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20210318-5.pdf
29067 29067 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Exhibit-AB-20210318-7.pdf
29068 29068 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Bambrick, Rhonda Kay     https://efile.fara.gov/docs/6522-Short-Form-20210318-30.pdf
29069 29069 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Benjamin, Todd     https://efile.fara.gov/docs/6522-Short-Form-20210318-32.pdf
29070 29070 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Canney, Crystal     https://efile.fara.gov/docs/6522-Short-Form-20210318-36.pdf
29071 29071 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Genco, Stephanie Bernice     https://efile.fara.gov/docs/6522-Short-Form-20210318-40.pdf
29072 29072 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Hynes, Patrick     https://efile.fara.gov/docs/6522-Short-Form-20210318-42.pdf
29073 29073 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Mason, Garrett     https://efile.fara.gov/docs/6522-Short-Form-20210318-34.pdf
29074 29074 2021-03-18 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Summers Grice, Kathleen     https://efile.fara.gov/docs/6522-Short-Form-20210318-38.pdf
29558 29558 2019-03-20 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Supplemental Statement       https://efile.fara.gov/docs/6522-Supplemental-Statement-20190320-2.pdf
30766 30766 2019-03-25 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Brown, Cynthia Sue     https://efile.fara.gov/docs/6522-Short-Form-20190325-14.pdf
31315 31315 2020-03-27 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Supplemental Statement       https://efile.fara.gov/docs/6522-Supplemental-Statement-20200327-4.pdf
31670 31670 2023-03-28 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Supplemental Statement       https://efile.fara.gov/docs/6522-Supplemental-Statement-20230328-10.pdf
32384 32384 2021-03-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Supplemental Statement       https://efile.fara.gov/docs/6522-Supplemental-Statement-20210330-6.pdf
32444 32444 2022-03-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Exhibit-AB-20220330-15.pdf
32445 32445 2022-03-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Supplemental Statement       https://efile.fara.gov/docs/6522-Supplemental-Statement-20220330-8.pdf
37101 37101 2022-04-01 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20220401-15.pdf
37102 37102 2022-04-01 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20220401-16.pdf
37103 37103 2022-04-01 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Exhibit-AB-20220401-16.pdf
37282 37282 2021-04-02 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210402-4.pdf
39081 39081 2020-04-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20200409-3.pdf
39082 39082 2020-04-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6522-Exhibit-AB-20200409-4.pdf
39555 39555 2021-04-11 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210411-5.pdf
39593 39593 2023-04-11 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20230411-25.pdf
39594 39594 2023-04-11 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6522-Exhibit-AB-20230411-21.pdf
39801 39801 2022-04-12 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20220412-50.pdf
41596 41596 2021-04-20 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20210420-8.pdf
42114 42114 2021-04-22 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210422-6.pdf
44106 44106 2021-04-29 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210429-7.pdf
45258 45258 2021-04-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20210430-7.pdf
45259 45259 2021-04-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6522-Exhibit-AB-20210430-9.pdf
45260 45260 2021-04-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Exhibit-AB-20210430-8.pdf
45261 45261 2021-04-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Hynes, Patrick     https://efile.fara.gov/docs/6522-Short-Form-20210430-44.pdf
45262 45262 2021-04-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Mason, Garrett     https://efile.fara.gov/docs/6522-Short-Form-20210430-48.pdf
45263 45263 2021-04-30 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Summers Grice, Kathleen     https://efile.fara.gov/docs/6522-Short-Form-20210430-52.pdf
48862 48862 2022-05-02 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20220502-17.pdf
48863 48863 2022-05-02 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Exhibit-AB-20220502-17.pdf
48864 48864 2022-05-02 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Mason, Garrett     https://efile.fara.gov/docs/6522-Short-Form-20220502-84.pdf
48865 48865 2022-05-02 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Summers-Grice, Kathleen     https://efile.fara.gov/docs/6522-Short-Form-20220502-86.pdf
49422 49422 2023-05-04 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Driscoll, Jerry Joseph     https://efile.fara.gov/docs/6522-Short-Form-20230504-88.pdf
49645 49645 2022-05-05 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20220505-18.pdf
49646 49646 2022-05-05 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6522-Exhibit-AB-20220505-18.pdf
50888 50888 2018-05-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20180510-1.pdf
50889 50889 2018-05-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6522-Exhibit-AB-20180510-3.pdf
51277 51277 2022-05-11 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20220511-51.pdf
52005 52005 2021-05-14 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210514-8.pdf
52753 52753 2021-05-17 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210517-10.pdf
52754 52754 2021-05-17 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210517-9.pdf
55595 55595 2021-05-28 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210528-11.pdf
55596 55596 2021-05-28 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210528-12.pdf
55597 55597 2021-05-28 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210528-13.pdf
55598 55598 2021-05-28 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210528-14.pdf
55599 55599 2021-05-28 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210528-15.pdf
63653 63653 2021-06-08 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20210608-10.pdf
63654 63654 2021-06-08 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Exhibit-AB-20210608-10.pdf
64459 64459 2021-06-11 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210611-16.pdf
65076 65076 2021-06-14 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Schaper, Nick     https://efile.fara.gov/docs/6522-Short-Form-20210614-54.pdf
74948 74948 2020-07-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Exhibit-AB-20200709-5.pdf
74949 74949 2020-07-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Forbes, Jeffrey Alan     https://efile.fara.gov/docs/6522-Short-Form-20200709-26.pdf
74950 74950 2020-07-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Gallagher, Caitlin     https://efile.fara.gov/docs/6522-Short-Form-20200709-18.pdf
74951 74951 2020-07-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Murphy, Rick     https://efile.fara.gov/docs/6522-Short-Form-20200709-24.pdf
74952 74952 2020-07-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Smith, Wendy     https://efile.fara.gov/docs/6522-Short-Form-20200709-28.pdf
74953 74953 2020-07-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Tipton, Stacia     https://efile.fara.gov/docs/6522-Short-Form-20200709-22.pdf
74954 74954 2020-07-09 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Usher, Doug     https://efile.fara.gov/docs/6522-Short-Form-20200709-20.pdf
75576 75576 2021-07-12 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210712-17.pdf
75577 75577 2021-07-12 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210712-18.pdf
76561 76561 2021-07-16 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210716-19.pdf
76562 76562 2021-07-16 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210716-20.pdf
80048 80048 2020-07-29 6522 Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20200729-1.pdf
86896 86896 2021-08-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210810-21.pdf
86897 86897 2021-08-10 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210810-22.pdf
87315 87315 2021-08-12 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210812-23.pdf
89529 89529 2021-08-24 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210824-24.pdf
90085 90085 2021-08-27 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20210827-11.pdf
90086 90086 2021-08-27 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Exhibit AB   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Exhibit-AB-20210827-11.pdf
90087 90087 2021-08-27 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Short-Form Casas, Owen D.     https://efile.fara.gov/docs/6522-Short-Form-20210827-56.pdf
96250 96250 2021-09-07 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210907-25.pdf
96251 96251 2021-09-07 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210907-26.pdf
96252 96252 2021-09-07 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210907-27.pdf
97551 97551 2021-09-13 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210913-28.pdf
97552 97552 2021-09-13 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Informational Materials   H.Q. Energy Services (U.S.) Inc. CANADA https://efile.fara.gov/docs/6522-Informational-Materials-20210913-29.pdf
97580 97580 2022-09-13 Forbes Tate Partners LLC Forbes Tate Partners LLC 6522 Amendment       https://efile.fara.gov/docs/6522-Amendment-20220913-19.pdf

Next page

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 578.084ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history