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

71 rows where Document_Type = "Exhibit AB" and Foreign_Principal_Country = "CYPRUS"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name >30

  • CMS Strategies, LLC 5
  • Covington & Burling 5
  • MANATOS & MANATOS 4
  • Office of the Turkish Republic of Northern Cyprus 3
  • Prime Policy Group 3
  • Prism Public Affairs 3
  • Southfive Strategies, LLC 3
  • DERWINSKI, EDWARD 2
  • Herrick, Feinstein LLP 2
  • INTERNATIONAL PUBLIC RELATIONS COMPANY, LTD. 2
  • MANATT, PHELPS & PHILLIPS 2
  • Representative of the Turkish Republic of Northern Cyprus 2
  • SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS 2
  • ALCALDE & FAY 1
  • Alston & Bird LLP 1
  • BERLINER CORCORAN & ROWE, LLP 1
  • BKSH & Associates 1
  • BROWN NELSON & ASSOCIATES, INC. 1
  • CAMERON & HORNBOSTEL 1
  • CAMERON & HORNBOSTEL, L.L.P. 1
  • DANIEL J. EDELMAN, INC. 1
  • DONALD N. MARTIN & COMPANY, INC. 1
  • ECKERT INTERNATIONAL, INC. 1
  • EVANS GROUP, LTD. 1
  • European Travel Commission 1
  • Federalist Group, LLC 1
  • HOGAN & HARTSON, L.L.P. 1
  • Independent Diplomat, Inc. 1
  • Jacobs, Barry 1
  • Karv Communications, Inc. 1
  • …

Foreign_Principal_Name >30

  • Republic of Cyprus, Embassy 10
  • REPUBLIC OF CYPRUS 6
  • Foreign Ministry of the Turkish Republic of Northern Cyprus 3
  • PSEKA, INTERNATIONAL COORDINATING COMMITTEE--JUSTICE FOR 3
  • Republic of Cyprus, Embassy, through Patton Boggs LLP 3
  • TURKISH REPUBLIC OF NORTHERN CYPRUS 3
  • Turkish Republic of Northern Cyprus (TRNC) 3
  • CYPRUS TOURISM ORGANIZATION 2
  • FREEDOM & JUSTICE FOR CYPRUS TRUST 2
  • GOVERNMENT OF THE REPUBLIC OF CYPRUS 2
  • Government of the Republic of Cyprus 2
  • POLYGON COMPANY, LTD. 2
  • Republic of Cyprus, Embassy, through Covington & Burling LLP 2
  • Turkish Republic of Northern Cyprus ("T.R.N.C.") 2
  • Association of Cyprus Banks 1
  • Association of Cyprus Banks (ACB) (via Pillsbury Winthrop Shaw Pittman LLP) 1
  • Embassv of the Republic of Cyprus 1
  • Embassy of Cyprus 1
  • Embassy of the Republic of Cyprus 1
  • FESTIVAL SHIPPING & TOURIST ENTERPRISES, LTD 1
  • GOVERNMENT OF CYPRUS 1
  • GOVERNMENT OF CYPRUS, EMBASSY 1
  • GOVERNMENT OF THE REPUBLIC OF CYPRUS, EMBASSY 1
  • Government of the Republic of Cyprus, Embassy, through Patton Boggs LLP 1
  • Mehmet Ali Talat 1
  • Ministry of Commerce & Industry (Tourist Section) of Cyprus 1
  • POLYGON CO., LTD. 1
  • PSEKA, INTERNATIONAL CO-ORDINATING COMMITTEE -- 1
  • R.R. DENKTASH 1
  • Republic of Cyprus Government, Embassy 1
  • …

Foreign_Principal_Country 1

  • CYPRUS · 71 ✖

Document_Type 1

  • Exhibit AB · 71 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
815 815 1984-01-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   GOVERNMENT OF CYPRUS CYPRUS https://efile.fara.gov/docs/2972-Exhibit-AB-19840101-D0CX1803.pdf
3156 3156 2023-01-03 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Turkish Republic of Northern Cyprus (TRNC) Washington DC Office CYPRUS https://efile.fara.gov/docs/6210-Exhibit-AB-20230103-12.pdf
8884 8884 2002-01-30 Video Placement Worldwide - A Division of JD Communikaters Video Placement Worldwide - A Division of JD Communikaters 5468 Exhibit AB   Embassy of Cyprus CYPRUS https://efile.fara.gov/docs/5468-Exhibit-AB-20020130-GT8A0U01.pdf
13579 13579 1999-02-02 BERLINER CORCORAN & ROWE, LLP Berliner Corcoran & Rowe, LLP 5299 Exhibit AB   POLYGON COMPANY, LTD. CYPRUS https://efile.fara.gov/docs/5299-Exhibit-AB-19990202-F6ZSQY02.pdf
13594 13594 2001-02-02 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Republic of Cyprus Government, Embassy CYPRUS https://efile.fara.gov/docs/3712-Exhibit-AB-20010202-HQQ6Z501.pdf
22253 22253 1989-03-01 EVANS GROUP, LTD. Evans Group, Ltd. 4222 Exhibit AB   REPUBLIC OF CYPRUS CYPRUS https://efile.fara.gov/docs/4222-Exhibit-AB-19890301-D1OP9I02.pdf
29262 29262 2014-03-19 Southfive Strategies, LLC Southfive Strategies, LLC 6186 Exhibit AB   Foreign Ministry of the Turkish Republic of Northern Cyprus CYPRUS https://efile.fara.gov/docs/6186-Exhibit-AB-20140319-2.pdf
32090 32090 1998-03-30 BROWN NELSON & ASSOCIATES, INC. Brown Nelson & Associates, Inc. 4615 Exhibit AB   UNICOM MANAGEMENT SERVICES LTD. CYPRUS https://efile.fara.gov/docs/4615-Exhibit-AB-19980330-ES8CYT04.pdf
38997 38997 2008-04-09 Office of the Turkish Republic of Northern Cyprus Representative of the Turkish Republic of Northern Cyprus 2619 Exhibit AB   Turkish Republic of Northern Cyprus, Mehmet Ali Talat CYPRUS https://efile.fara.gov/docs/2619-Exhibit-AB-20080409-2.pdf
39447 39447 1995-04-11 DERWINSKI, EDWARD Derwinski, Edward 5011 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF CYPRUS CYPRUS https://efile.fara.gov/docs/5011-Exhibit-AB-19950411-DFH25602.pdf
40905 40905 1998-04-17 MULLIN COMMUNICATIONS, INC. Mullin Communications, Inc. 5253 Exhibit AB   GOVERNMENT OF CYPRUS, EMBASSY CYPRUS https://efile.fara.gov/docs/5253-Exhibit-AB-19980417-ETOCYV03.pdf
47103 47103 1991-05-01 ALCALDE & FAY Alcalde & Fay 3571 Exhibit AB   REPUBLIC OF CYPRUS CYPRUS https://efile.fara.gov/docs/3571-Exhibit-AB-19910501-D0VVEH01.pdf
49988 49988 2004-05-07 Covington & Burling Covington & Burling, LLP 5621 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5621-Exhibit-AB-20040507-HYBU2804.pdf
49998 49998 2004-05-07 Prism Public Affairs Prism Public Affairs 5620 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5620-Exhibit-AB-20040507-HYA99X01.pdf
52367 52367 2003-05-16 Alston & Bird LLP Alston & Bird, LLP 5549 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5549-Exhibit-AB-20030516-HF92ST04.pdf
53702 53702 2007-05-21 Office of the Turkish Republic of Northern Cyprus Representative of the Turkish Republic of Northern Cyprus 2619 Exhibit AB   Talat, Mehmet Ali CYPRUS https://efile.fara.gov/docs/2619-Exhibit-AB-20070521-1.pdf
53783 53783 2019-05-21 Manatos & Manatos (through the National Coordinated Effort of Hellenes - CEH) Manatos & Manatos (through the National Coordinated Effort of Hellenes - CEH) 6683 Exhibit AB   Government of the Republic of Cyprus CYPRUS https://efile.fara.gov/docs/6683-Exhibit-AB-20190521-1.pdf
59090 59090 1985-06-01 SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS Susan Davis International & Public Affairs 3444 Exhibit AB   TURKISH REPUBLIC OF NORTHERN CYPRUS CYPRUS https://efile.fara.gov/docs/3444-Exhibit-AB-19850601-D0KFU801.pdf
61562 61562 1993-06-01 PETER MARTIN ASSOCIATES, INC. Peter Martin Associates, Inc. 4236 Exhibit AB   CYPRUS TOURISM ORGANIZATION CYPRUS https://efile.fara.gov/docs/4236-Exhibit-AB-19930601-D1M2XQ02.pdf
65658 65658 2004-06-17 Federalist Group, LLC Federalist Group, an Ogilvy PR Worldwide Company 5628 Exhibit AB   Republic of Cyprus, Embassy through Covington & Burling CYPRUS https://efile.fara.gov/docs/5628-Exhibit-AB-20040617-I145EN04.pdf
66630 66630 1995-06-22 DERWINSKI, EDWARD Derwinski, Edward 5011 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF CYPRUS CYPRUS https://efile.fara.gov/docs/5011-Exhibit-AB-19950622-DFH2CN02.pdf
70143 70143 2015-06-30 Representative of the Turkish Republic of Northern Cyprus Representative of the Turkish Republic of Northern Cyprus 2619 Exhibit AB   Turkish Republic of Northern Cyprus, H.E. Mustafa Akinci CYPRUS https://efile.fara.gov/docs/2619-Exhibit-AB-20150630-6.pdf
72300 72300 1991-07-01 MANATOS & MANATOS Manatos & Manatos 3522 Exhibit AB   PSEKA, INTERNATIONAL COORDINATING COMMITTEE--JUSTICE FOR CYPRUS https://efile.fara.gov/docs/3522-Exhibit-AB-19910701-D0VNW901.pdf
75889 75889 2018-07-13 Prime Policy Group Prime Policy Group 6377 Exhibit AB   Turkish Republic of Northern Cyprus (TRNC) CYPRUS https://efile.fara.gov/docs/6377-Exhibit-AB-20180713-6.pdf
77966 77966 2010-07-22 Office of the Turkish Republic of Northern Cyprus Representative of the Turkish Republic of Northern Cyprus 2619 Exhibit AB   Turkish Republic of Northern Cyprus H.E. Dr. Dervis Eroglu CYPRUS https://efile.fara.gov/docs/2619-Exhibit-AB-20100722-5.pdf
83261 83261 1990-08-01 STEPTOE & JOHNSON LLP Steptoe & Johnson, L.L.P. 3975 Exhibit AB   TURKISH REPUBLIC OF NORTHERN CYPRUS CYPRUS https://efile.fara.gov/docs/3975-Exhibit-AB-19900801-D1HQ1R02.pdf
90453 90453 2019-08-28 Karv Communications, Inc. KARV Communications, Inc. 6162 Exhibit AB   Association of Cyprus Banks (ACB) (via Pillsbury Winthrop Shaw Pittman LLP) CYPRUS https://efile.fara.gov/docs/6162-Exhibit-AB-20190828-4.pdf
90463 90463 2019-08-28 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Association of Cyprus Banks CYPRUS https://efile.fara.gov/docs/5198-Exhibit-AB-20190828-53.pdf
93511 93511 1990-09-01 MANATOS & MANATOS Manatos & Manatos 3522 Exhibit AB   PSEKA, INTERNATIONAL CO-ORDINATING COMMITTEE -- CYPRUS https://efile.fara.gov/docs/3522-Exhibit-AB-19900901-D0VHRE01.pdf
96170 96170 2004-09-07 Prism Public Affairs Prism Public Affairs 5620 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5620-Exhibit-AB-20040907-I5UAUT04.pdf
96570 96570 2013-09-09 Herrick, Feinstein LLP Herrick, Feinstein LLP 6185 Exhibit AB   Turkish Republic of Northern Cyprus ("T.R.N.C.") CYPRUS https://efile.fara.gov/docs/6185-Exhibit-AB-20130909-1.pdf
96574 96574 2013-09-09 Southfive Strategies, LLC Southfive Strategies, LLC 6186 Exhibit AB   Foreign Ministry of the Turkish Republic of Northern Cyprus CYPRUS https://efile.fara.gov/docs/6186-Exhibit-AB-20130909-1.pdf
96763 96763 2004-09-10 Covington & Burling Covington & Burling, LLP 5621 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5621-Exhibit-AB-20040910-I5SEMM04.pdf
97248 97248 2006-09-12 CMS Strategies, LLC CMS Strategies, LLC 5766 Exhibit AB   Republic of Cyprus, Embassy, through Covington & Burling LLP CYPRUS https://efile.fara.gov/docs/5766-Exhibit-AB-20060912-5.pdf
98351 98351 1987-09-17 SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS Susan Davis International & Public Affairs 3444 Exhibit AB   TURKISH REPUBLIC OF NORTHERN CYPRUS CYPRUS https://efile.fara.gov/docs/3444-Exhibit-AB-19870917-D0KFGD01.pdf
98973 98973 2016-09-19 Prime Policy Group Prime Policy Group 6377 Exhibit AB   Turkish Republic of Northern Cyprus (TRNC) CYPRUS https://efile.fara.gov/docs/6377-Exhibit-AB-20160919-1.pdf
99050 99050 1985-09-20 MANATT, PHELPS & PHILLIPS Manatt, Phelps & Phillips 3736 Exhibit AB   REPUBLIC OF CYPRUS CYPRUS https://efile.fara.gov/docs/3736-Exhibit-AB-19850920-D12MJO01.pdf
99388 99388 2006-09-21 Weber Shandwick, Inc. Weber Shandwick, Inc. 5579 Exhibit AB   Embassv of the Republic of Cyprus CYPRUS https://efile.fara.gov/docs/5579-Exhibit-AB-20060921-2.pdf
100105 100105 2014-09-24 Herrick, Feinstein LLP Herrick, Feinstein LLP 6185 Exhibit AB   Turkish Republic of Northern Cyprus ("T.R.N.C.") CYPRUS https://efile.fara.gov/docs/6185-Exhibit-AB-20140924-2.pdf
100339 100339 2007-09-25 Patton Boggs, L.L.P. Squire Patton Boggs, LLP 2165 Exhibit AB   Government of the Republic of Cyprus CYPRUS https://efile.fara.gov/docs/2165-Exhibit-AB-20070925-10.pdf
102509 102509 2014-09-30 Southfive Strategies, LLC Southfive Strategies, LLC 6186 Exhibit AB   Foreign Ministry of the Turkish Republic of Northern Cyprus CYPRUS https://efile.fara.gov/docs/6186-Exhibit-AB-20140930-3.pdf
103143 103143 1975-10-01 OFFICE OF THE TURKISH REPUBLIC OF NORTHERN CYPRUS Representative of the Turkish Republic of Northern Cyprus 2619 Exhibit AB   R.R. DENKTASH CYPRUS https://efile.fara.gov/docs/2619-Exhibit-AB-19751001-D01NHT03.pdf
103939 103939 1986-10-01 DANIEL J. EDELMAN, INC. Daniel J. Edelman, Inc. 3657 Exhibit AB   FREEDOM & JUSTICE FOR CYPRUS TRUST CYPRUS https://efile.fara.gov/docs/3657-Exhibit-AB-19861001-D0YJYR01.pdf
104024 104024 1986-10-01 SAWYER MILLER GROUP Sawyer Miller Group 3777 Exhibit AB   FREEDOM & JUSTICE FOR CYPRUS TRUST CYPRUS https://efile.fara.gov/docs/3777-Exhibit-AB-19861001-D15G6G01.pdf
104423 104423 1989-10-01 MANATT, PHELPS & PHILLIPS Manatt, Phelps & Phillips 3736 Exhibit AB   REPUBLIC OF CYPRUS CYPRUS https://efile.fara.gov/docs/3736-Exhibit-AB-19891001-D12K3D01.pdf
106365 106365 1997-10-03 HOGAN & HARTSON, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF CYPRUS, EMBASSY CYPRUS https://efile.fara.gov/docs/2244-Exhibit-AB-19971003-EK9BP202.pdf
106407 106407 2007-10-03 Qorvis Communications, LLC QORVIS LLC 5483 Exhibit AB   Government of the Republic of Cyprus, Embassy, through Patton Boggs LLP CYPRUS https://efile.fara.gov/docs/5483-Exhibit-AB-20071003-10.pdf
109743 109743 1998-10-19 CAMERON & HORNBOSTEL, L.L.P. Cameron & Hornbostel, L.L.P. 4705 Exhibit AB   POLYGON CO., LTD. CYPRUS https://efile.fara.gov/docs/4705-Exhibit-AB-19981019-F1NE2R01.pdf
113742 113742 2017-10-31 Prime Policy Group Prime Policy Group 6377 Exhibit AB   Turkish Republic of Northern Cyprus (TRNC) CYPRUS https://efile.fara.gov/docs/6377-Exhibit-AB-20171031-3.pdf
114296 114296 1978-11-01 INTERNATIONAL PUBLIC RELATIONS COMPANY, LTD. International Public Relations Company, Ltd. 1967 Exhibit AB   REPUBLIC OF CYPRUS CYPRUS https://efile.fara.gov/docs/1967-Exhibit-AB-19781101-CZ2UDL01.pdf
115420 115420 1990-11-01 MANATOS & MANATOS Manatos & Manatos 3522 Exhibit AB   PSEKA, INTERNATIONAL COORDINATING COMMITTEE--JUSTICE FOR CYPRUS https://efile.fara.gov/docs/3522-Exhibit-AB-19901101-D0VH5C01.pdf
115777 115777 1991-11-01 MANATOS & MANATOS Manatos & Manatos 3522 Exhibit AB   PSEKA, INTERNATIONAL COORDINATING COMMITTEE--JUSTICE FOR CYPRUS https://efile.fara.gov/docs/3522-Exhibit-AB-19911101-D0VK4M01.pdf
116352 116352 1993-11-01 CAMERON & HORNBOSTEL Cameron & Hornbostel, L.L.P. 4705 Exhibit AB   POLYGON COMPANY, LTD. CYPRUS https://efile.fara.gov/docs/4705-Exhibit-AB-19931101-D1YAFM02.pdf
116967 116967 2007-11-02 CMS Strategies, LLC CMS Strategies, LLC 5766 Exhibit AB   Republic of Cyprus, Embassy, through Patton Boggs LLP CYPRUS https://efile.fara.gov/docs/5766-Exhibit-AB-20071102-6.pdf
117236 117236 2008-11-03 CMS Strategies, LLC CMS Strategies, LLC 5766 Exhibit AB   Republic of Cyprus, Embassy, through Patton Boggs LLP CYPRUS https://efile.fara.gov/docs/5766-Exhibit-AB-20081103-7.pdf
118236 118236 2012-11-08 Podesta Group, Inc. Podesta Group, Inc. 5926 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5926-Exhibit-AB-20121108-22.pdf
118415 118415 2010-11-09 CMS Strategies, LLC CMS Strategies, LLC 5766 Exhibit AB   Republic of Cyprus, Embassy, through Patton Boggs LLP CYPRUS https://efile.fara.gov/docs/5766-Exhibit-AB-20101109-8.pdf
119423 119423 2006-11-14 Covington & Burling Covington & Burling, LLP 5621 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5621-Exhibit-AB-20061114-3.pdf
120946 120946 2020-11-20 Representative of the Turkish Republic of Northern Cyprus Representative of the Turkish Republic of Northern Cyprus 2619 Exhibit AB   Turkish Republic of Northern Cyprus, H.E. Mr. Ersin Tatar CYPRUS https://efile.fara.gov/docs/2619-Exhibit-AB-20201120-7.pdf
121222 121222 2005-11-22 Covington & Burling Covington & Burling, LLP 5621 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5621-Exhibit-AB-20051122-1.pdf
121856 121856 1973-11-26 European Travel Commission European Travel Commission 574 Exhibit AB   Ministry of Commerce & Industry (Tourist Section) of Cyprus CYPRUS https://efile.fara.gov/docs/574-Exhibit-AB-19731126-HGA47D01.pdf
122438 122438 2006-11-29 BKSH & Associates BKSH & Associates 5402 Exhibit AB   Embassy of the Republic of Cyprus CYPRUS https://efile.fara.gov/docs/5402-Exhibit-AB-20061129-9.pdf
125130 125130 1982-12-01 INTERNATIONAL PUBLIC RELATIONS COMPANY, LTD. International Public Relations Company, Ltd. 1967 Exhibit AB   REPUBLIC OF CYPRUS CYPRUS https://efile.fara.gov/docs/1967-Exhibit-AB-19821201-CZ2TPY01.pdf
125363 125363 1984-12-01 DONALD N. MARTIN & COMPANY, INC. Donald N. Martin & Company, Inc. 1381 Exhibit AB   CYPRUS TOURISM ORGANIZATION CYPRUS https://efile.fara.gov/docs/1381-Exhibit-AB-19841201-CYP8YX02.pdf
130543 130543 2006-12-12 CMS Strategies, LLC CMS Strategies, LLC 5766 Exhibit AB   Republic of Cyprus, Embassy, through Covington & Burling LLP CYPRUS https://efile.fara.gov/docs/5766-Exhibit-AB-20061212-4.pdf
130564 130564 2012-12-12 Roberti + White, LLC Roberti + White, LLC 6065 Exhibit AB   Republic of Cyprus through Podesta Group CYPRUS https://efile.fara.gov/docs/6065-Exhibit-AB-20121212-2.pdf
130639 130639 1991-12-13 ECKERT INTERNATIONAL, INC. Eckert International, Inc. 4198 Exhibit AB   FESTIVAL SHIPPING & TOURIST ENTERPRISES, LTD CYPRUS https://efile.fara.gov/docs/4198-Exhibit-AB-19911213-D1J8FD02.pdf
131117 131117 2008-12-15 Independent Diplomat, Inc. Independent Diplomat, Inc. 5860 Exhibit AB   Turkish Republic of Northern Cyprus CYPRUS https://efile.fara.gov/docs/5860-Exhibit-AB-20081215-4.pdf
131331 131331 2008-12-16 Jacobs, Barry Jacobs, Barry 5900 Exhibit AB   Mehmet Ali Talat CYPRUS https://efile.fara.gov/docs/5900-Exhibit-AB-20081216-1.pdf
132848 132848 2004-12-22 Prism Public Affairs Prism Public Affairs 5620 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5620-Exhibit-AB-20041222-I9T2UF04.pdf
133686 133686 2005-12-27 Covington & Burling Covington & Burling, LLP 5621 Exhibit AB   Republic of Cyprus, Embassy CYPRUS https://efile.fara.gov/docs/5621-Exhibit-AB-20051227-2.pdf

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