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

149 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 · 149 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
5724 5724 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
6785 6785 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
7445 7445 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
7969 7969 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
14602 14602 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
14975 14975 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
15482 15482 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
16089 16089 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
16628 16628 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
17417 17417 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
18532 18532 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
18549 18549 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
19498 19498 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
23237 23237 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
23271 23271 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
23548 23548 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
26937 26937 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
28566 28566 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
28567 28567 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
28568 28568 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
28569 28569 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
35966 35966 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
36231 36231 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
36472 36472 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
36483 36483 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
36898 36898 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
37028 37028 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
37278 37278 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
37301 37301 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
37322 37322 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
37532 37532 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
37550 37550 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
37552 37552 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
37568 37568 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
37725 37725 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
37891 37891 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
38129 38129 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
38642 38642 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
38645 38645 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
38853 38853 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
39088 39088 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
39092 39092 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
39094 39094 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
39274 39274 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
39446 39446 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
39823 39823 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
40059 40059 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
40660 40660 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
40794 40794 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
40957 40957 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
41540 41540 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
41877 41877 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
41913 41913 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
41928 41928 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
43010 43010 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
43056 43056 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
46241 46241 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
46354 46354 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
46363 46363 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
46793 46793 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
46846 46846 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
46849 46849 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
46976 46976 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
47168 47168 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
47248 47248 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
47262 47262 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
47265 47265 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
47418 47418 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
47851 47851 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
47905 47905 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
48213 48213 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
48425 48425 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
48461 48461 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
48465 48465 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
48490 48490 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
48514 48514 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
48715 48715 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
49813 49813 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
50084 50084 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
50313 50313 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
50469 50469 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
50956 50956 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
50971 50971 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
51236 51236 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
51599 51599 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
51908 51908 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
53083 53083 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
53084 53084 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
53217 53217 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
53887 53887 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
58816 58816 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
59267 59267 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
59443 59443 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
60730 60730 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
61456 61456 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
62414 62414 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
62546 62546 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
63163 63163 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
63381 63381 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
63787 63787 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])
);