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

21 rows where Foreign_Principal_Country = "TURKEY" and Foreign_Principal_Name = "Government of the Republic of Turkey, Embassy"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 6

  • LB International Solutions, LLC 14
  • Caspian Group, LLC 2
  • Solomon Group, L.L.C. 2
  • C/R International, L.L.C. 1
  • Fleishman-Hillard, Inc. 1
  • Livingston-Solomon Group, L.L.C. 1

Document_Type 2

  • Exhibit AB 15
  • Informational Materials 6

Foreign_Principal_Name 1

  • Government of the Republic of Turkey, Embassy · 21 ✖

Foreign_Principal_Country 1

  • TURKEY · 21 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
3318 3318 2022-01-04 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Exhibit-AB-20220104-10.pdf
9777 9777 2000-01-31 C/R International, L.L.C. C/R International, L.L.C. 5117 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/5117-Exhibit-AB-20000131-G7Q4A301.pdf
9829 9829 2000-01-31 Solomon Group, L.L.C. Livingston-Solomon Group, L.L.C. 5352 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/5352-Exhibit-AB-20000131-GD6BXH02.pdf
24915 24915 2014-03-03 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Exhibit-AB-20140303-1.pdf
26438 26438 2009-03-09 Caspian Group, LLC Caspian Group, LLC 5915 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/5915-Exhibit-AB-20090309-1.pdf
29366 29366 2022-03-19 LB International Solutions, LLC LB International Solutions, LLC 6210 Informational Materials   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Informational-Materials-20220319-4.pdf
31458 31458 2000-03-28 Livingston-Solomon Group, L.L.C. Livingston-Solomon Group, L.L.C. 5352 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/5352-Exhibit-AB-20000328-H9QWS202.pdf
39701 39701 2001-04-12 Solomon Group, L.L.C. Livingston-Solomon Group, L.L.C. 5352 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/5352-Exhibit-AB-20010412-GLS6B602.pdf
51236 51236 2020-05-11 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Exhibit-AB-20200511-7.pdf
53553 53553 2023-05-20 LB International Solutions, LLC LB International Solutions, LLC 6210 Informational Materials   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Informational-Materials-20230520-6.pdf
61882 61882 2016-06-01 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Exhibit-AB-20160601-2.pdf
64224 64224 2019-06-10 LB International Solutions, LLC LB International Solutions, LLC 6210 Informational Materials   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Informational-Materials-20190610-1.pdf
67231 67231 2016-06-24 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Exhibit-AB-20160624-3.pdf
74481 74481 2021-07-07 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Exhibit-AB-20210707-9.pdf
81491 81491 2022-07-31 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Exhibit-AB-20220731-11.pdf
81492 81492 2022-07-31 LB International Solutions, LLC LB International Solutions, LLC 6210 Informational Materials   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Informational-Materials-20220731-5.pdf
106698 106698 2021-10-04 LB International Solutions, LLC LB International Solutions, LLC 6210 Informational Materials   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Informational-Materials-20211004-3.pdf
108170 108170 2019-10-11 LB International Solutions, LLC LB International Solutions, LLC 6210 Informational Materials   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Informational-Materials-20191011-2.pdf
111139 111139 2011-10-25 Caspian Group, LLC Caspian Group, LLC 5915 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/5915-Exhibit-AB-20111025-2.pdf
132995 132995 2020-12-22 LB International Solutions, LLC LB International Solutions, LLC 6210 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/6210-Exhibit-AB-20201222-8.pdf
134178 134178 2008-12-29 Fleishman-Hillard, Inc. Fleishman-Hillard, Inc. 5801 Exhibit AB   Government of the Republic of Turkey, Embassy TURKEY https://efile.fara.gov/docs/5801-Exhibit-AB-20081229-5.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 597.175ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history