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

1,027 rows where Foreign_Principal_Name = "Republika Srpska"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

These facets timed out: Registrant_Name

Foreign_Principal_Country 2

Document_Type 2

Foreign_Principal_Name 1

  • Republika Srpska · 1,027 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
3293 3293 2021-01-04 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210104-557.pdf
3294 3294 2021-01-04 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210104-558.pdf
3295 3295 2021-01-04 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210104-559.pdf
3296 3296 2021-01-04 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210104-560.pdf
3491 3491 2021-01-05 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210105-561.pdf
3492 3492 2021-01-05 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210105-562.pdf
3493 3493 2021-01-05 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210105-563.pdf
3743 3743 2021-01-06 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210106-564.pdf
3786 3786 2023-01-06 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230106-1065.pdf
3787 3787 2023-01-06 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230106-1066.pdf
3939 3939 2021-01-07 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210107-565.pdf
3940 3940 2021-01-07 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210107-566.pdf
3941 3941 2021-01-07 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210107-567.pdf
4854 4854 2021-01-11 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210111-568.pdf
4855 4855 2021-01-11 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210111-569.pdf
5063 5063 2021-01-12 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210112-570.pdf
5097 5097 2022-01-12 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220112-888.pdf
5098 5098 2022-01-12 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220112-889.pdf
5315 5315 2022-01-13 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220113-890.pdf
5485 5485 2021-01-14 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210114-571.pdf
5498 5498 2022-01-14 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220114-891.pdf
5499 5499 2022-01-14 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220114-892.pdf
5617 5617 2020-01-15 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200115-113.pdf
5803 5803 2020-01-16 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200116-115.pdf
6107 6107 2022-01-18 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220118-893.pdf
6114 6114 2023-01-18 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230118-1069.pdf
6269 6269 2021-01-19 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210119-575.pdf
6288 6288 2022-01-19 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220119-894.pdf
6289 6289 2022-01-19 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220119-895.pdf
6303 6303 2023-01-19 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230119-1068.pdf
6435 6435 2021-01-20 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210120-572.pdf
6436 6436 2021-01-20 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210120-573.pdf
6437 6437 2021-01-20 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210120-574.pdf
6456 6456 2022-01-20 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220120-896.pdf
6457 6457 2022-01-20 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220120-897.pdf
6458 6458 2022-01-20 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220120-898.pdf
6465 6465 2023-01-20 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230120-1067.pdf
6623 6623 2021-01-21 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210121-576.pdf
6624 6624 2021-01-21 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210121-577.pdf
6625 6625 2021-01-21 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210121-578.pdf
6668 6668 2022-01-21 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220121-899.pdf
6669 6669 2022-01-21 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220121-900.pdf
6815 6815 2020-01-22 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200122-116.pdf
6816 6816 2020-01-22 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200122-117.pdf
6836 6836 2021-01-22 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210122-579.pdf
6837 6837 2021-01-22 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210122-580.pdf
6838 6838 2021-01-22 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210122-581.pdf
6839 6839 2021-01-22 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210122-582.pdf
7337 7337 2022-01-24 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220124-901.pdf
7548 7548 2021-01-25 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210125-583.pdf
7549 7549 2021-01-25 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210125-584.pdf
7577 7577 2022-01-25 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220125-902.pdf
7578 7578 2022-01-25 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220125-903.pdf
7747 7747 2021-01-26 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210126-585.pdf
7748 7748 2021-01-26 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210126-586.pdf
7749 7749 2021-01-26 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210126-587.pdf
7791 7791 2022-01-26 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220126-904.pdf
7792 7792 2022-01-26 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220126-905.pdf
7793 7793 2022-01-26 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220126-906.pdf
7814 7814 2023-01-26 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230126-1070.pdf
7815 7815 2023-01-26 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230126-1071.pdf
7816 7816 2023-01-26 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230126-1072.pdf
8009 8009 2020-01-27 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200127-118.pdf
8363 8363 2021-01-28 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210128-593.pdf
8364 8364 2021-01-28 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210128-594.pdf
8427 8427 2022-01-28 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220128-907.pdf
8604 8604 2010-01-29 Quinn Gillespie & Associates, LLC Quinn Gillespie & Associates, LLC 5753 Exhibit AB   Republika Srpska SERBIA https://efile.fara.gov/docs/5753-Exhibit-AB-20100129-13.pdf
8740 8740 2021-01-29 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210129-588.pdf
8741 8741 2021-01-29 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210129-589.pdf
8742 8742 2021-01-29 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210129-590.pdf
8743 8743 2021-01-29 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210129-591.pdf
8744 8744 2021-01-29 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210129-592.pdf
8998 8998 2008-01-30 Quinn Gillespie & Associates, LLC Quinn Gillespie & Associates, LLC 5753 Exhibit AB   Republika Srpska SERBIA https://efile.fara.gov/docs/5753-Exhibit-AB-20080130-6.pdf
9022 9022 2009-01-30 Quinn Gillespie & Associates, LLC Quinn Gillespie & Associates, LLC 5753 Exhibit AB   Republika Srpska SERBIA https://efile.fara.gov/docs/5753-Exhibit-AB-20090130-8.pdf
9303 9303 2020-01-30 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200130-119.pdf
10326 10326 2020-01-31 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200131-120.pdf
13461 13461 2021-02-01 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210201-595.pdf
13472 13472 2021-02-01 McGinnis Lochridge McGinnis Lochridge 6672 Exhibit AB   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Exhibit-AB-20210201-5.pdf
13723 13723 2021-02-02 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210202-596.pdf
13724 13724 2021-02-02 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210202-597.pdf
13748 13748 2022-02-02 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220202-908.pdf
13920 13920 2021-02-03 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210203-598.pdf
13921 13921 2021-02-03 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210203-599.pdf
13949 13949 2022-02-03 McGinnis Lochridge McGinnis Lochridge 6672 Exhibit AB   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Exhibit-AB-20220203-6.pdf
14206 14206 2020-02-04 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200204-121.pdf
14214 14214 2021-02-04 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210204-600.pdf
14270 14270 2022-02-04 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220204-909.pdf
14474 14474 2020-02-05 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200205-122.pdf
14490 14490 2021-02-05 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210205-601.pdf
14491 14491 2021-02-05 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210205-602.pdf
14700 14700 2020-02-06 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200206-123.pdf
14701 14701 2020-02-06 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20200206-124.pdf
14923 14923 2022-02-07 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20220207-910.pdf
14948 14948 2023-02-07 McGinnis Lochridge McGinnis Lochridge 6672 Exhibit AB   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Exhibit-AB-20230207-7.pdf
14949 14949 2023-02-07 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230207-1073.pdf
14950 14950 2023-02-07 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230207-1074.pdf
14951 14951 2023-02-07 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230207-1075.pdf
14952 14952 2023-02-07 McGinnis Lochridge McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20230207-1076.pdf
15149 15149 2021-02-08 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210208-603.pdf
15150 15150 2021-02-08 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20210208-604.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])
);