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

164 rows where Foreign_Principal_Country = "JAPAN" and Foreign_Principal_Name = "Embassy of Japan"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Document_Type 2

Foreign_Principal_Name 1

  • Embassy of Japan · 164 ✖

Foreign_Principal_Country 1

  • JAPAN · 164 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
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
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
8277 8277 2015-01-28 Parvin, C. Landon Parvin, C. Landon 6194 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6194-Exhibit-AB-20150128-3.pdf
15103 15103 2016-02-08 Akin, Gump, Strauss, Hauer & Feld, LLP Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3492-Exhibit-AB-20160208-35.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
16045 16045 2002-02-13 Butterfield Carter and Associates Butterfield Carter and Associates 5398 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5398-Exhibit-AB-20020213-GTCFOQ01.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
17329 17329 2002-02-19 Hill & Knowlton, Inc. Hill and Knowlton Strategies, LLC 3301 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3301-Exhibit-AB-20020219-GTCAK101.pdf
18171 18171 2007-02-23 Bob, Daniel Bob, Daniel 5794 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5794-Exhibit-AB-20070223-1.pdf
19327 19327 2015-02-27 KP Public Affairs, LLC KP Public Affairs, LLC 6248 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6248-Exhibit-AB-20150227-2.pdf
19344 19344 2017-02-27 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6170-Exhibit-AB-20170227-23.pdf
20368 20368 2016-02-29 King & Spalding, LLP King & Spalding, LLP 6307 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6307-Exhibit-AB-20160229-4.pdf
24107 24107 2016-03-01 Akin, Gump, Strauss, Hauer & Feld, LLP Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3492-Exhibit-AB-20160301-36.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
24478 24478 2011-03-02 Akin, Gump, Strauss, Hauer & Feld, LLP Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3492-Exhibit-AB-20110302-14.pdf
28149 28149 2018-03-15 Akin, Gump, Strauss, Hauer & Feld, LLP Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3492-Exhibit-AB-20180315-49.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
37709 37709 2017-04-04 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5926-Exhibit-AB-20170404-99.pdf
37988 37988 2019-04-05 Alignment Government Strategies Alignment Government Strategies 6317 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Exhibit-AB-20190405-6.pdf
38238 38238 2017-04-06 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6170-Exhibit-AB-20170406-26.pdf
38249 38249 2018-04-06 Holland & Knight Holland & Knight 3718 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3718-Exhibit-AB-20180406-9.pdf
38679 38679 2003-04-08 Parvin, C. Landon Parvin, C. Landon 5551 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5551-Exhibit-AB-20030408-HE243L01.pdf
38809 38809 2020-04-08 Greenfield Law, LLC Greenfield Law, LLC 6294 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Exhibit-AB-20200408-5.pdf
39059 39059 2019-04-09 Beacon Policy Advisors LLC Beacon Policy Advisors LLC 6658 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6658-Exhibit-AB-20190409-1.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
39103 39103 2020-04-09 RSC Services International LLC RSC Services International LLC 6554 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6554-Exhibit-AB-20200409-3.pdf
39315 39315 2020-04-10 Beacon Policy Advisors LLC Beacon Policy Advisors LLC 6658 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6658-Exhibit-AB-20200410-3.pdf
39333 39333 2020-04-10 Patrick Griffin Patrick,Griffin 6815 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6815-Exhibit-AB-20200410-1.pdf
39335 39335 2020-04-10 Peck Madigan Jones, Inc. Tiber Creek Group, Inc. 6816 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6816-Exhibit-AB-20200410-1.pdf
39351 39351 2021-04-10 Peck Madigan Jones, Inc. Tiber Creek Group, Inc. 6816 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6816-Exhibit-AB-20210410-2.pdf
39369 39369 2023-04-10 Greenfield Law, LLC Greenfield Law, LLC 6294 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Exhibit-AB-20230410-8.pdf
39538 39538 2019-04-11 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20190411-85.pdf
39591 39591 2023-04-11 Beacon Policy Advisors LLC Beacon Policy Advisors LLC 6658 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6658-Exhibit-AB-20230411-6.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
39738 39738 2017-04-12 CGCN Group CGCN Group 6396 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6396-Exhibit-AB-20170412-2.pdf
39990 39990 2020-04-13 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20200413-91.pdf
40052 40052 2023-04-13 Beacon Policy Advisors LLC Beacon Policy Advisors LLC 6658 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6658-Exhibit-AB-20230413-7.pdf
40298 40298 2023-04-14 Ballard Partners Ballard Partners 7070 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/7070-Exhibit-AB-20230414-4.pdf
40538 40538 2021-04-15 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20210415-93.pdf
40541 40541 2021-04-15 RSC Services International LLC RSC Services International LLC 6554 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6554-Exhibit-AB-20210415-4.pdf
40752 40752 2015-04-16 Daschle Group, LLC Daschle Group, LLC 6280 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6280-Exhibit-AB-20150416-3.pdf
40994 40994 2017-04-17 Alignment Government Strategies Alignment Government Strategies 6317 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Exhibit-AB-20170417-4.pdf
40998 40998 2018-04-17 Akin, Gump, Strauss, Hauer & Feld, LLP Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3492-Exhibit-AB-20180417-51.pdf
41000 41000 2018-04-17 Alignment Government Strategies Alignment Government Strategies 6317 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Exhibit-AB-20180417-5.pdf
41044 41044 2023-04-17 Alignment Government Strategies Alignment Government Strategies 6317 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Exhibit-AB-20230417-10.pdf
41201 41201 2019-04-18 Comeau & Company LLC Comeau & Company LLC 6666 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6666-Exhibit-AB-20190418-1.pdf
41403 41403 2018-04-19 Sorini, Samet & Associates, LLC Sorini, Samet & Associates, LLC 5839 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5839-Exhibit-AB-20180419-37.pdf
41805 41805 2020-04-21 Alignment Government Strategies Alignment Government Strategies 6317 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Exhibit-AB-20200421-7.pdf
41893 41893 2023-04-21 theGroup DC, LLC theGroup DC, LLC 6388 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6388-Exhibit-AB-20230421-11.pdf
42081 42081 2019-04-22 Greenfield Law, LLC Greenfield Law, LLC 6294 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Exhibit-AB-20190422-4.pdf
42325 42325 2023-04-23 Patrick,Griffin Patrick,Griffin 6815 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6815-Exhibit-AB-20230423-4.pdf
42716 42716 2012-04-25 Friedlander Group Friedlander Group 6097 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6097-Exhibit-AB-20120425-1.pdf
42850 42850 2022-04-25 Greenfield Law, LLC Greenfield Law, LLC 6294 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Exhibit-AB-20220425-7.pdf
42858 42858 2023-04-25 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20230425-98.pdf
43033 43033 2017-04-26 S-3 Group S-3 Group 6422 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6422-Exhibit-AB-20170426-1.pdf
43677 43677 2015-04-28 Sorini, Samet & Associates, LLC Sorini, Samet & Associates, LLC 5839 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5839-Exhibit-AB-20150428-30.pdf
44066 44066 2019-04-29 Daschle Group, LLC Daschle Group, LLC 6280 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6280-Exhibit-AB-20190429-9.pdf
44102 44102 2020-04-29 S-3 Group S-3 Group 6422 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6422-Exhibit-AB-20200429-4.pdf
44117 44117 2021-04-29 Beacon Policy Advisors LLC Beacon Policy Advisors LLC 6658 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6658-Exhibit-AB-20210429-4.pdf
45212 45212 2021-04-30 Alignment Government Strategies Alignment Government Strategies 6317 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Exhibit-AB-20210430-8.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
48473 48473 2004-05-01 Parvin, C. Landon Parvin, C. Landon 5551 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5551-Exhibit-AB-20040501-HXO1N104.pdf
48586 48586 2019-05-01 Beacon Policy Advisors LLC Beacon Policy Advisors LLC 6658 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6658-Exhibit-AB-20190501-2.pdf
48595 48595 2019-05-01 RSC Services International LLC RSC Services International LLC 6554 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6554-Exhibit-AB-20190501-2.pdf
49070 49070 2016-05-03 Alignment Government Strategies Alignment Government Strategies 6317 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Exhibit-AB-20160503-2.pdf
49123 49123 2021-05-03 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20210503-94.pdf
49126 49126 2021-05-03 RSC Services International LLC RSC Services International LLC 6554 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6554-Exhibit-AB-20210503-5.pdf
49292 49292 2012-05-04 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5926-Exhibit-AB-20120504-18.pdf
49485 49485 2023-05-04 Tiber Creek Group, Inc. Tiber Creek Group, Inc. 6816 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6816-Exhibit-AB-20230504-5.pdf
49552 49552 2013-05-05 Reed, T. Dean Reed, T. Dean 5044 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5044-Exhibit-AB-20130505-2.pdf
49632 49632 2022-05-05 Beacon Policy Advisors LLC Beacon Policy Advisors LLC 6658 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6658-Exhibit-AB-20220505-5.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
49649 49649 2022-05-05 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20220505-96.pdf
49824 49824 2020-05-06 Daschle Group, LLC Daschle Group, LLC 6280 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6280-Exhibit-AB-20200506-12.pdf
50284 50284 2001-05-08 Butterfield Carter and Associates Butterfield Carter and Associates 5398 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5398-Exhibit-AB-20010508-GNMOME01.pdf
50338 50338 2015-05-08 Holland & Knight Holland & Knight 3718 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3718-Exhibit-AB-20150508-7.pdf
50656 50656 2022-05-09 Tiber Creek Group, Inc. Tiber Creek Group, Inc. 6816 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6816-Exhibit-AB-20220509-4.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
50924 50924 2021-05-10 Griffin, Patrick Patrick,Griffin 6815 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6815-Exhibit-AB-20210510-2.pdf
50928 50928 2021-05-10 Peck Madigan Jones, Inc. Tiber Creek Group, Inc. 6816 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6816-Exhibit-AB-20210510-3.pdf
50953 50953 2022-05-10 Alignment Government Strategies Alignment Government Strategies 6317 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6317-Exhibit-AB-20220510-9.pdf
50977 50977 2022-05-10 Patrick,Griffin Patrick,Griffin 6815 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6815-Exhibit-AB-20220510-3.pdf
51251 51251 2021-05-11 Greenfield Law, LLC Greenfield Law, LLC 6294 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Exhibit-AB-20210511-6.pdf
52423 52423 2015-05-16 Greenfield & Kress, P.A. Greenfield Law, LLC 6294 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Exhibit-AB-20150516-1.pdf
52730 52730 2016-05-17 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5926-Exhibit-AB-20160517-78.pdf
53011 53011 2018-05-18 RSC Services International LLC RSC Services International LLC 6554 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6554-Exhibit-AB-20180518-1.pdf
53206 53206 2015-05-19 McGuireWoods Consulting, LLC McGuireWoods Consulting, LLC 6295 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6295-Exhibit-AB-20150519-1.pdf
53748 53748 2013-05-21 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5926-Exhibit-AB-20130521-29.pdf
53763 53763 2014-05-21 Sorini, Samet & Associates, LLC Sorini, Samet & Associates, LLC 5839 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5839-Exhibit-AB-20140521-27.pdf
54032 54032 2020-05-22 Comeau & Company LLC Comeau & Company LLC 6666 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6666-Exhibit-AB-20200522-2.pdf
54455 54455 2018-05-24 CGCN Group CGCN Group 6396 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6396-Exhibit-AB-20180524-3.pdf
54798 54798 2021-05-25 Akin, Gump, Strauss, Hauer & Feld, LLP Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/3492-Exhibit-AB-20210525-62.pdf
56092 56092 2006-05-30 Parvin, C. Landon Parvin, C. Landon 5551 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5551-Exhibit-AB-20060530-3.pdf
56093 56093 2006-05-30 Parvin, C. Landon Parvin, C. Landon 5551 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5551-Exhibit-AB-20060530-4.pdf
56226 56226 2015-05-30 Parvin, C. Landon Parvin, C. Landon 6194 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6194-Exhibit-AB-20150530-4.pdf
56966 56966 2017-05-31 Parvin, C. Landon Parvin, C. Landon 6194 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6194-Exhibit-AB-20170531-5.pdf
61940 61940 2018-06-01 Parvin, C. Landon Parvin, C. Landon 6194 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6194-Exhibit-AB-20180601-6.pdf
62490 62490 2021-06-03 Parvin, C. Landon Parvin, C. Landon 6194 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6194-Exhibit-AB-20210603-9.pdf
62688 62688 2020-06-04 Parvin, C. Landon Parvin, C. Landon 6194 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6194-Exhibit-AB-20200604-8.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])
);