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

5 rows where Foreign_Principal_Name = "GOVERNMENT OF BOLIVIA"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 4

  • ROWLES, JAMES P. 2
  • BOZELL SAWYER MILLER GROUP 1
  • O'CONNOR & HANNAN, LLP 1
  • WILLIAMS & CONNOLLY 1

Foreign_Principal_Name 1

  • GOVERNMENT OF BOLIVIA · 5 ✖

Foreign_Principal_Country 1

  • BOLIVIA 5

Document_Type 1

  • Exhibit AB 5
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
23914 23914 1993-03-01 ROWLES, JAMES P. Rowles, James P. 4774 Exhibit AB   GOVERNMENT OF BOLIVIA BOLIVIA https://efile.fara.gov/docs/4774-Exhibit-AB-19930301-D1YBI402.pdf
60035 60035 1990-06-01 WILLIAMS & CONNOLLY Williams & Connolly 4225 Exhibit AB   GOVERNMENT OF BOLIVIA BOLIVIA https://efile.fara.gov/docs/4225-Exhibit-AB-19900601-D1OOFR02.pdf
74346 74346 1994-07-07 ROWLES, JAMES P. Rowles, James P. 4774 Exhibit AB   GOVERNMENT OF BOLIVIA BOLIVIA https://efile.fara.gov/docs/4774-Exhibit-AB-19940707-DHFJV202.pdf
103907 103907 1986-10-01 O'CONNOR & HANNAN, LLP O'Connor & Hannan, L.L.P. 2972 Exhibit AB   GOVERNMENT OF BOLIVIA BOLIVIA https://efile.fara.gov/docs/2972-Exhibit-AB-19861001-D0D07103.pdf
107016 107016 1993-10-06 BOZELL SAWYER MILLER GROUP IPG DXTRA, Inc 3911 Exhibit AB   GOVERNMENT OF BOLIVIA BOLIVIA https://efile.fara.gov/docs/3911-Exhibit-AB-19931006-D181HH02.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 1042.81ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history