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

28 rows where Registration_Number = 6736

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Foreign_Principal_Name 2

Foreign_Principal_Country 2

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
16325 16325 2020-02-14 PIVOT Pivot Integrated Communications, a division of BCW LLC 6736 Informational Materials   Huawei Technologies USA, Inc. CHINA https://efile.fara.gov/docs/6736-Informational-Materials-20200214-3.pdf
29043 29043 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Amendment       https://efile.fara.gov/docs/6736-Amendment-20200318-1.pdf
29044 29044 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Cook, James     https://efile.fara.gov/docs/6736-Short-Form-20200318-26.pdf
29045 29045 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Culbertson, Matthew     https://efile.fara.gov/docs/6736-Short-Form-20200318-28.pdf
29046 29046 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Delgado, Kelly     https://efile.fara.gov/docs/6736-Short-Form-20200318-30.pdf
29047 29047 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Goodman, Adam     https://efile.fara.gov/docs/6736-Short-Form-20200318-32.pdf
29048 29048 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Hamilton, Chris     https://efile.fara.gov/docs/6736-Short-Form-20200318-34.pdf
29049 29049 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Hendl, Jonathan     https://efile.fara.gov/docs/6736-Short-Form-20200318-36.pdf
29050 29050 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Marino, Gabrielle     https://efile.fara.gov/docs/6736-Short-Form-20200318-38.pdf
29051 29051 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Mastrojohn, Dean     https://efile.fara.gov/docs/6736-Short-Form-20200318-22.pdf
29052 29052 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Minuskin, Eric     https://efile.fara.gov/docs/6736-Short-Form-20200318-24.pdf
29053 29053 2020-03-18 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Silvers, Sharron     https://efile.fara.gov/docs/6736-Short-Form-20200318-20.pdf
52263 52263 2020-05-15 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Davmer, Ariella     https://efile.fara.gov/docs/6736-Short-Form-20200515-40.pdf
55944 55944 2020-05-29 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Supplemental Statement       https://efile.fara.gov/docs/6736-Supplemental-Statement-20200529-1.pdf
106482 106482 2019-10-03 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Exhibit AB   Huawei Technologies USA, Inc. CHINA https://efile.fara.gov/docs/6736-Exhibit-AB-20191003-1.pdf
106483 106483 2019-10-03 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Exhibit C       https://efile.fara.gov/docs/6736-Exhibit-C-20191003-1.pdf
106484 106484 2019-10-03 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Registration Statement       https://efile.fara.gov/docs/6736-Registration-Statement-20191003-1.pdf
106485 106485 2019-10-03 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Cook, James     https://efile.fara.gov/docs/6736-Short-Form-20191003-6.pdf
106486 106486 2019-10-03 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Goodman, Adam     https://efile.fara.gov/docs/6736-Short-Form-20191003-10.pdf
106487 106487 2019-10-03 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Hamilton, Chris     https://efile.fara.gov/docs/6736-Short-Form-20191003-8.pdf
106488 106488 2019-10-03 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Hendl, Jonathan     https://efile.fara.gov/docs/6736-Short-Form-20191003-4.pdf
106489 106489 2019-10-03 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Marino, Gabrielle     https://efile.fara.gov/docs/6736-Short-Form-20191003-2.pdf
108174 108174 2019-10-11 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Informational Materials   Huawei Technologies USA, Inc. CHINA https://efile.fara.gov/docs/6736-Informational-Materials-20191011-2.pdf
110262 110262 2019-10-21 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Informational Materials   Huawei Technologies USA, Inc. CHINA https://efile.fara.gov/docs/6736-Informational-Materials-20191021-1.pdf
117912 117912 2019-11-06 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Culbertson, Matthew     https://efile.fara.gov/docs/6736-Short-Form-20191106-14.pdf
117913 117913 2019-11-06 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Mastrojohn, Dean     https://efile.fara.gov/docs/6736-Short-Form-20191106-16.pdf
118809 118809 2020-11-11 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Supplemental Statement       https://efile.fara.gov/docs/6736-Supplemental-Statement-20201111-2.pdf
122172 122172 2019-11-27 Pivot Integrated Communications, a division of BCW LLC Pivot Integrated Communications, a division of BCW LLC 6736 Short-Form Delgado, Kelly     https://efile.fara.gov/docs/6736-Short-Form-20191127-18.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])
);