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

152 rows where Foreign_Principal_Name = "Embassy of Japan"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Foreign_Principal_Country 2

Document_Type 2

Foreign_Principal_Name 1

  • Embassy of Japan · 152 ✖
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
15098 15098 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
15499 15499 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
16038 16038 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
16694 16694 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
17277 17277 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
18119 18119 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
19276 19276 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
19293 19293 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
20316 20316 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
24055 24055 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
24089 24089 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
24425 24425 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
28078 28078 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
29846 29846 2017-03-22 Podesta Group, Inc. Podesta Group, Inc. 5926 Informational Materials   Embassy of Japan   https://efile.fara.gov/docs/5926-Informational-Materials-20170322-13.pdf
29847 29847 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
29848 29848 2017-03-22 Rasky Baerlein Strategic Communications, Inc. Rasky Baerlein Strategic Communications, Inc. 6222 Informational Materials   Embassy of Japan   https://efile.fara.gov/docs/6222-Informational-Materials-20170322-4.pdf
29849 29849 2017-03-22 Rasky Baerlein Strategic Communications, Inc. Rasky Baerlein Strategic Communications, Inc. 6222 Informational Materials   Embassy of Japan   https://efile.fara.gov/docs/6222-Informational-Materials-20170322-5.pdf
37250 37250 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
37515 37515 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
37757 37757 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
37768 37768 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
38183 38183 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
38313 38313 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
38563 38563 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
38586 38586 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
38607 38607 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
38817 38817 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
38835 38835 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
38837 38837 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
38853 38853 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
39010 39010 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
39186 39186 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
39424 39424 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
39937 39937 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
39940 39940 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
40148 40148 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
40383 40383 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
40387 40387 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
40389 40389 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
40569 40569 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
40741 40741 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
41118 41118 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
41354 41354 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
41955 41955 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
42089 42089 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
42252 42252 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
42835 42835 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
43172 43172 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
43208 43208 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
43223 43223 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
44305 44305 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
44352 44352 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
47537 47537 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
47650 47650 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
47659 47659 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
48092 48092 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
48145 48145 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
48148 48148 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
48275 48275 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
48467 48467 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
48547 48547 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
48561 48561 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
48564 48564 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
48717 48717 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
49150 49150 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
49204 49204 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
49512 49512 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
49724 49724 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
49759 49759 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
49763 49763 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
49788 49788 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
49812 49812 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
50013 50013 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
51112 51112 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
51389 51389 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
51643 51643 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
51823 51823 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
52338 52338 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
52353 52353 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
52619 52619 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
53009 53009 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
53336 53336 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
54564 54564 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
54565 54565 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
54698 54698 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
55380 55380 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
60341 60341 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
60827 60827 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
61025 61025 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
62406 62406 2019-06-10 Parvin, C. Landon Parvin, C. Landon 6194 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6194-Exhibit-AB-20190610-7.pdf
63180 63180 2017-06-14 Greenfield & Kress, P.A. Greenfield Law, LLC 6294 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6294-Exhibit-AB-20170614-2.pdf
64233 64233 2015-06-19 Southwest Strategies, LLC Southwest Strategies, LLC 6302 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6302-Exhibit-AB-20150619-1.pdf
64365 64365 2014-06-20 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5926-Exhibit-AB-20140620-42.pdf
65017 65017 2016-06-23 Rasky Baerlein Strategic Communications, Inc. Rasky Baerlein Strategic Communications, Inc. 6222 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6222-Exhibit-AB-20160623-4.pdf
65247 65247 2016-06-24 Sorini, Samet & Associates, LLC Sorini, Samet & Associates, LLC 5839 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/5839-Exhibit-AB-20160624-33.pdf
65674 65674 2014-06-26 Parvin, C. Landon Parvin, C. Landon 6194 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6194-Exhibit-AB-20140626-2.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])
);